Query time 0.00243
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "509.55"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "system",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "5K"
},
"used_columns": [
"company_id",
"status",
"company"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 317,
"rows_produced_per_join": 317,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "8.90",
"eval_cost": "63.40",
"prefix_cost": "72.30",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"ea201_diorama.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 15,
"filtered": "5.00",
"cost_info": {
"read_cost": "317.00",
"eval_cost": "3.17",
"prefix_cost": "452.70",
"data_read_per_join": "54K"
},
"used_columns": [
"product_id",
"status",
"amount",
"timestamp",
"tracking",
"company_id",
"usergroup_ids"
],
"attached_condition": "((`ea201_diorama`.`products`.`company_id` = '1') and ((`ea201_diorama`.`products`.`amount` > 0) or (`ea201_diorama`.`products`.`tracking` = 'D')) and ((`ea201_diorama`.`products`.`usergroup_ids` = '') or find_in_set(0,`ea201_diorama`.`products`.`usergroup_ids`) or find_in_set(1,`ea201_diorama`.`products`.`usergroup_ids`)) and (`ea201_diorama`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"membership",
"src_k",
"product_id",
"lower_limit",
"membership_id"
],
"key": "membership",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"ea201_diorama.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 15,
"filtered": "99.45",
"using_index": true,
"cost_info": {
"read_cost": "15.85",
"eval_cost": "3.15",
"prefix_cost": "471.72",
"data_read_per_join": "378"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`ea201_diorama`.`prices`.`lower_limit` = 1) and (`ea201_diorama`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "shared_descr",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id",
"company_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code",
"company_id"
],
"key_length": "13",
"ref": [
"ea201_diorama.products_categories.product_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 15,
"filtered": "100.00",
"cost_info": {
"read_cost": "15.76",
"eval_cost": "3.15",
"prefix_cost": "490.63",
"data_read_per_join": "60K"
},
"used_columns": [
"product_id",
"lang_code",
"company_id",
"product"
]
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"ea201_diorama.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 15,
"filtered": "100.00",
"cost_info": {
"read_cost": "15.76",
"eval_cost": "3.15",
"prefix_cost": "509.55",
"data_read_per_join": "60K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
40826 |
Palmiers 15 et 19 cm - Noch 21972 |
Diorama.fr / NEORAMA sarl |
40509 |
Noch 17830 - Ouvriers du bâtiment 1:42 |
Diorama.fr / NEORAMA sarl |
40510 |
Noch 17840 - Fermiers 1/42 |
Diorama.fr / NEORAMA sarl |
38833 |
Noch 00020 - Tapis d'herbe printemps 300 x 100 cm |
Diorama.fr / NEORAMA sarl |
40495 |
Miniature Eurocopter EC 145 samu 1:34 |
Diorama.fr / NEORAMA sarl |
35693 |
Personnel de gare 1:43 |
Diorama.fr / NEORAMA sarl |
40431 |
2 Fauteuils miniatures auditorium 10026 |
Diorama.fr / NEORAMA sarl |
38832 |
Noch 00010 - Tapis d'herbe printemps 200 x 100 cm |
Diorama.fr / NEORAMA sarl |
38830 |
Noch 270 - Tapis d'herbe fleuri 120 x 60 cm |
Diorama.fr / NEORAMA sarl |
38795 |
4 Silhouettes personnages miniatures |
Diorama.fr / NEORAMA sarl |
38569 |
Fauteuil miniature 'moom' |
Diorama.fr / NEORAMA sarl |
40038 |
Noch 17860 - Gens assis |
Diorama.fr / NEORAMA sarl |
37005 |
Chaises de bureau avec repose-bras 1:50 |
Diorama.fr / NEORAMA sarl |
40042 |
Pin 10/11 cm - Noch 21911 |
Diorama.fr / NEORAMA sarl |
40043 |
Pin 15 cm - Noch 21914 |
Diorama.fr / NEORAMA sarl |
40141 |
Socle Diorama 310 x 210 mm, emplacement avions WW2 - Vallejo 3525 - SC102 |
Diorama.fr / NEORAMA sarl |
40140 |
Socle Diorama 310 x 210 mm, route pavée - Vallejo 3518 - SC101 |
Diorama.fr / NEORAMA sarl |
38788 |
Canapé miniature 2-3 places |
Diorama.fr / NEORAMA sarl |
38831 |
Noch 280 - Tapis d'herbe été 120 x 60 cm |
Diorama.fr / NEORAMA sarl |
39090 |
Champ d'herbes hautes naturelles - Woodland FG171 |
Diorama.fr / NEORAMA sarl |
38875 |
Miniature Eurocopter EC 145 Sécurité Civile 1:43 |
Diorama.fr / NEORAMA sarl |
32009 |
Heki 2127 - 8 sapins épicéas 17 cm |
Diorama.fr / NEORAMA sarl |
39089 |
Champ d'herbes hautes jaune paille - Woodland FG172 |
Diorama.fr / NEORAMA sarl |
40062 |
Socle Diorama 14x14 cm, Chemin accidenté - Vallejo 3501 - SC002 |
Diorama.fr / NEORAMA sarl |
39441 |
10 sapins 16 -19 cm - Noch 26827 |
Diorama.fr / NEORAMA sarl |
39354 |
Plaque rocheuse "basalt"- Noch 58462 |
Diorama.fr / NEORAMA sarl |
39353 |
Protection contre chute de pierre - Noch 58152 |
Diorama.fr / NEORAMA sarl |
36377 |
Lampadaires 1:50 |
Diorama.fr / NEORAMA sarl |
39385 |
15 Figurines miniatures assises transparentes au 1:50 - Hermoli 02-50310 |
Diorama.fr / NEORAMA sarl |
39076 |
Passage à niveau en acier, 0 - Woodland C1146 |
Diorama.fr / NEORAMA sarl |