Query time 0.00092
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "51.78"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"id_path",
"c_status"
],
"key": "id_path",
"used_key_parts": [
"id_path"
],
"key_length": "767",
"rows_examined_per_scan": 36,
"rows_produced_per_join": 0,
"filtered": "0.43",
"index_condition": "(`ea201_diorama`.`cscart_categories`.`id_path` like '203/%')",
"cost_info": {
"read_cost": "51.38",
"eval_cost": "0.03",
"prefix_cost": "51.41",
"data_read_per_join": "412"
},
"used_columns": [
"category_id",
"parent_id",
"id_path",
"usergroup_ids",
"status",
"position",
"company_id",
"is_trash",
"storefront_id"
],
"attached_condition": "((`ea201_diorama`.`cscart_categories`.`company_id` = 1) and ((`ea201_diorama`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`ea201_diorama`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`ea201_diorama`.`cscart_categories`.`usergroup_ids`)) and (`ea201_diorama`.`cscart_categories`.`status` = 'A') and (`ea201_diorama`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "cscart_category_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"lang_code"
],
"key_length": "9",
"ref": [
"ea201_diorama.cscart_categories.category_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.15",
"eval_cost": "0.03",
"prefix_cost": "51.60",
"data_read_per_join": "479"
},
"used_columns": [
"category_id",
"lang_code",
"category"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"key_length": "210",
"ref": [
"ea201_diorama.cscart_categories.category_id",
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.15",
"eval_cost": "0.03",
"prefix_cost": "51.78",
"data_read_per_join": "268"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"lang_code",
"company_id",
"path"
]
}
}
]
}
}
}
Result
category_id |
parent_id |
id_path |
category |
position |
status |
company_id |
storefront_id |
seo_name |
seo_path |
307 |
203 |
203/307 |
Colles |
10 |
A |
1 |
0 |
colles-fr |
203 |
331 |
319 |
203/316/319/331 |
Plaques blanches 150 x 300 |
10 |
A |
1 |
0 |
plaques-blanches-150-x-300-fr |
203/316/319 |
319 |
316 |
203/316/319 |
Plaques de styrène Evergreen |
10 |
A |
1 |
0 |
plaques-de-styrene-evergreen-fr |
203/316 |
327 |
326 |
203/316/326/327 |
Profiles en U |
10 |
A |
1 |
0 |
profiles-en-u-fr |
203/316/326 |
321 |
323 |
203/316/323/321 |
Tubes ronds pleins |
10 |
A |
1 |
0 |
tubes-ronds-pleins-fr |
203/316/323 |
311 |
203 |
203/311 |
Mastics, plâtres |
20 |
A |
1 |
0 |
mastics-platres-fr |
203 |
332 |
319 |
203/316/319/332 |
Plaques transparentes 150 x 300 |
20 |
A |
1 |
0 |
plaques-transparentes-150-x-300-fr |
203/316/319 |
320 |
316 |
203/316/320 |
Polystrips Evergreen |
20 |
A |
1 |
0 |
polystrips-evergreen-fr |
203/316 |
328 |
326 |
203/316/326/328 |
Profiles en I |
20 |
A |
1 |
0 |
profiles-en-i-fr |
203/316/326 |
322 |
323 |
203/316/323/322 |
Tubes ronds creux |
20 |
A |
1 |
0 |
tubes-ronds-creux-fr |
203/316/323 |
324 |
323 |
203/316/323/324 |
Demi-tubes et quart de tubes pleins |
30 |
A |
1 |
0 |
demi-tubes-et-quart-de-tubes-pleins-fr |
203/316/323 |
312 |
203 |
203/312 |
Outils de precision |
30 |
A |
1 |
0 |
outils-de-precision-fr |
203 |
333 |
319 |
203/316/319/333 |
Plaques avec fente en V |
30 |
A |
1 |
0 |
plaques-avec-fente-en-v-fr |
203/316/319 |
323 |
316 |
203/316/323 |
Tubes |
30 |
A |
1 |
0 |
evergreen-tubes-fr |
203/316 |
622 |
203 |
203/622 |
Pinceaux |
40 |
A |
1 |
0 |
pinceaux |
203 |
334 |
319 |
203/316/319/334 |
Plaques de bardage |
40 |
A |
1 |
0 |
plaques-de-bardage-fr |
203/316/319 |
326 |
316 |
203/316/326 |
Profiles |
40 |
A |
1 |
0 |
profiles-fr |
203/316 |
329 |
326 |
203/316/326/329 |
Profiles en H |
40 |
A |
1 |
0 |
profiles-en-h-fr |
203/316/326 |
325 |
323 |
203/316/323/325 |
Tubes carré et rectangulaire creux |
40 |
A |
1 |
0 |
tubes-carre-et-rectangulaire-creux-fr |
203/316/323 |
689 |
316 |
203/316/689 |
Baguettes bois |
50 |
A |
1 |
0 |
baguettes-bois-modelisme-maquettes |
203/316 |
335 |
319 |
203/316/319/335 |
Plaques tôle ondulée |
50 |
A |
1 |
0 |
plaques-tole-ondulee-fr |
203/316/319 |
330 |
326 |
203/316/326/330 |
Profiles en L - angles |
50 |
A |
1 |
0 |
profiles-en-l-angles-fr |
203/316/326 |
336 |
319 |
203/316/319/336 |
Plaques "carrées de trottoir" |
60 |
A |
1 |
0 |
plaques-carrees-de-trottoir-fr |
203/316/319 |
690 |
316 |
203/316/690 |
Plaques contreplaque |
60 |
A |
1 |
0 |
plaques-contreplaque-modelisme-maquettes |
203/316 |
338 |
319 |
203/316/319/338 |
Plaques "toit en tôle" |
70 |
A |
1 |
0 |
plaques-toit-en-tole-fr |
203/316/319 |
337 |
319 |
203/316/319/337 |
Plaques "tasseaux de séparation" |
80 |
A |
1 |
0 |
plaques-tasseaux-de-separation-fr |
203/316/319 |
316 |
203 |
203/316 |
Plaques, profils, Tubes |
80 |
A |
1 |
0 |
plaques-profils-tubes-evergreen-fr |
203 |
679 |
203 |
203/679 |
Outillage PROXXON |
90 |
A |
1 |
0 |
outillage-proxxon |
203 |
340 |
319 |
203/316/319/340 |
Plaques de bardage pour bâtiments |
90 |
A |
1 |
0 |
plaques-de-bardage-pour-batiments-fr |
203/316/319 |
395 |
203 |
203/395 |
Décalcomanies |
110 |
A |
1 |
0 |
decalcomanies-fr |
203 |
339 |
319 |
203/316/319/339 |
Plaques de recouvrement pour wagons de voyageurs et de marchandises |
110 |
A |
1 |
0 |
plaques-de-recouvrement-pour-wagons-de-voyageurs-et-de-marchandises-fr |
203/316/319 |
539 |
203 |
203/539 |
Bandes de liège pour voies |
120 |
A |
1 |
0 |
bandes-de-liege-pour-voies-fr |
203 |
310 |
203 |
203/310 |
Autres |
130 |
A |
1 |
0 |
autres-1-fr |
203 |
707 |
203 |
203/707 |
Aérographes |
140 |
A |
1 |
0 |
aerographes-modelisme-maquettes |
203 |