Query time 0.00143
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "56.12"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"id_path",
"c_status"
],
"rows_examined_per_scan": 233,
"rows_produced_per_join": 0,
"filtered": "0.43",
"cost_info": {
"read_cost": "53.52",
"eval_cost": "0.20",
"prefix_cost": "53.72",
"data_read_per_join": "2K"
},
"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`.`id_path` like '177/%') 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": "1.00",
"eval_cost": "0.20",
"prefix_cost": "54.92",
"data_read_per_join": "3K"
},
"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": "1.00",
"eval_cost": "0.20",
"prefix_cost": "56.12",
"data_read_per_join": "1K"
},
"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 |
701 |
179 |
177/179/701 |
Arbres 6-12 cm |
0 |
A |
1 |
0 |
arbres-6-12-cm-fr-2 |
177/179 |
217 |
179 |
177/179/217 |
Arbres + 25 cm |
10 |
A |
1 |
0 |
arbres-25-cm-fr |
177/179 |
179 |
177 |
177/179 |
Arbres miniatures |
10 |
A |
1 |
0 |
arbres-miniatures |
177 |
341 |
218 |
177/218/341 |
Feuillage vert clair et printemps |
10 |
A |
1 |
0 |
feuillage-vert-clair-et-printemps-fr |
177/218 |
345 |
223 |
177/224/223/345 |
Flocages et fibres vert clair, printemps-été |
10 |
A |
1 |
0 |
flocages-et-fibres-vert-clair-printemps-ete-fr |
177/224/223 |
349 |
224 |
177/224/349 |
Flocons d'herbe |
10 |
A |
1 |
0 |
flocons-dherbe |
177/224 |
353 |
245 |
177/245/353 |
Lichen et mousse d'Islande vert clair et foncé |
10 |
A |
1 |
0 |
lichen-et-mousse-dislande-vert-clair-et-fonce-fr |
177/245 |
357 |
353 |
177/245/353/357 |
Sachets 30 grammes |
10 |
A |
1 |
0 |
sachets-30-grammes-fr |
177/245/353 |
363 |
355 |
177/245/355/363 |
Sachets 30 grammes |
10 |
A |
1 |
0 |
sachets-30-grammes |
177/245/355 |
416 |
412 |
177/412/416 |
Sapins + 25 cm |
10 |
A |
1 |
0 |
sapins-miniatures-architectes-warhammer-25-cm-fr |
177/412 |
412 |
177 |
177/412 |
Sapins |
11 |
A |
1 |
0 |
sapins-miniatures-decors-fr |
177 |
267 |
177 |
177/267 |
Arbres et sapins naturels |
12 |
A |
1 |
0 |
arbres-sapins-naturels-miniatures |
177 |
180 |
179 |
177/179/180 |
Arbres 12 - 25 cm |
20 |
A |
1 |
0 |
arbres-12-25-cm |
177/179 |
219 |
177 |
177/219 |
Arbustes, haies, vignes |
20 |
A |
1 |
0 |
arbustes-haies-vignes |
177 |
343 |
218 |
177/218/343 |
Feuillage vert moyen |
20 |
A |
1 |
0 |
feuillage-vert-moyen-fr |
177/218 |
348 |
224 |
177/224/348 |
Filet décors pour herbe |
20 |
A |
1 |
0 |
filet-decors-pour-herbe-fr |
177/224 |
346 |
223 |
177/224/223/346 |
Flocages et fibres vert foncé, automne-hiver |
20 |
A |
1 |
0 |
flocages-et-fibres-vert-fonce-automne-hiver-fr |
177/224/223 |
354 |
245 |
177/245/354 |
Lichen et mousse d'Islande colorés |
20 |
A |
1 |
0 |
lichen-et-mousse-dislande-colores-fr |
177/245 |
360 |
354 |
177/245/354/360 |
Sachets 30 grammes |
20 |
A |
1 |
0 |
sachets-30-grammes |
177/245/354 |
361 |
354 |
177/245/354/361 |
Sachets 50 grammes |
20 |
A |
1 |
0 |
sachets-50-grammes |
177/245/354 |
364 |
355 |
177/245/355/364 |
Sachets 50 grammes |
20 |
A |
1 |
0 |
sachets-50-grammes |
177/245/355 |
356 |
353 |
177/245/353/356 |
Sachets 50 grammes |
20 |
A |
1 |
0 |
sachets-50-grammes-fr |
177/245/353 |
415 |
412 |
177/412/415 |
Sapins 12 - 25 cm |
20 |
A |
1 |
0 |
sapins-miniatures-architectes-warhammer-12-25-cm-fr |
177/412 |
400 |
354 |
177/245/354/400 |
Sachets 100 grammes |
25 |
A |
1 |
0 |
sachets-100-grammes-fr |
177/245/354 |
181 |
179 |
177/179/181 |
Arbres 6 - 12 cm |
30 |
A |
1 |
0 |
arbres-6-12-cm-fr |
177/179 |
221 |
177 |
177/221 |
Eau, lacs, rivières |
30 |
A |
1 |
0 |
eau-lacs-rivieres-pour-dioramas-maquettes |
177 |
344 |
218 |
177/218/344 |
Feuillage vert foncé |
30 |
A |
1 |
0 |
feuillage-vert-fonce-fr |
177/218 |
355 |
245 |
177/245/355 |
Lichen et mousse d'Islande : assortiment |
30 |
A |
1 |
0 |
lichen-et-mousse-d-islande-assortiment |
177/245 |
362 |
354 |
177/245/354/362 |
Sachets 250 grammes |
30 |
A |
1 |
0 |
sachets-250-grammes |
177/245/354 |
358 |
353 |
177/245/353/358 |
Sachets 75 grammes |
30 |
A |
1 |
0 |
sachets-75-grammes-fr |
177/245/353 |
365 |
355 |
177/245/355/365 |
Sachets 75 grammes |
30 |
A |
1 |
0 |
sachets-75-grammes |
177/245/355 |
414 |
412 |
177/412/414 |
Sapins 6 - 12 cm |
30 |
A |
1 |
0 |
sapins-miniatures-architectes-warhammer-6-12-cm-fr |
177/412 |
350 |
224 |
177/224/350 |
Tapis de gazon |
30 |
A |
1 |
0 |
tapis-de-gazon |
177/224 |
347 |
177 |
177/347 |
Terre |
30 |
A |
1 |
0 |
terre-et-sol-miniature |
177 |
399 |
353 |
177/245/353/399 |
Sachet 100 grammes |
35 |
A |
1 |
0 |
sachet-100-grammes-fr |
177/245/353 |
182 |
179 |
177/179/182 |
Arbres 0 - 6 cm |
40 |
A |
1 |
0 |
arbres-0-6-cm-fr |
177/179 |
342 |
218 |
177/218/342 |
Feuillage Automne |
40 |
A |
1 |
0 |
feuillage-automne-fr |
177/218 |
382 |
177 |
177/382 |
Fleurs, plantes |
40 |
A |
1 |
0 |
fleurs-plantes-miniatures-pour-dioramas-maquettes |
177 |
351 |
224 |
177/224/351 |
Roseaux et herbes hautes |
40 |
A |
1 |
0 |
roseaux-et-herbes-hautes-fr |
177/224 |
359 |
353 |
177/245/353/359 |
Sachets 250 grammes |
40 |
A |
1 |
0 |
sachets-250-grammes-fr |
177/245/353 |
366 |
355 |
177/245/355/366 |
Sachets 250 grammes |
40 |
A |
1 |
0 |
sachets-250-grammes |
177/245/355 |
413 |
412 |
177/412/413 |
Sapins 0 - 6 cm |
40 |
A |
1 |
0 |
sapins-miniatures-architectes-0-6-cm-fr |
177/412 |
223 |
224 |
177/224/223 |
Flocages, fibres |
50 |
A |
1 |
0 |
flocages-fibres-fr |
177/224 |
352 |
224 |
177/224/352 |
Poudres colorées |
50 |
A |
1 |
0 |
poudres-colorees-fr |
177/224 |
218 |
177 |
177/218 |
Feuillage |
60 |
A |
1 |
0 |
feuillage-miniature |
177 |
224 |
177 |
177/224 |
Herbe, champs, flocages, fibres |
70 |
A |
1 |
0 |
herbe-miniature-poudres-fibres-flocages-fr |
177 |
245 |
177 |
177/245 |
Lichen, mousse d'Islande |
80 |
A |
1 |
0 |
lichen-mousse-dislande-fr |
177 |
225 |
177 |
177/225 |
Pierres, sable, ballast |
90 |
A |
1 |
0 |
pierres-sable-ballast |
177 |
228 |
177 |
177/228 |
Rochers, Montagnes |
100 |
A |
1 |
0 |
rochers-montagnes-fr |
177 |
391 |
177 |
177/391 |
Lièges |
110 |
A |
1 |
0 |
lieges-fr |
177 |
383 |
177 |
177/383 |
Fruits, Légumes, champs de céréales |
120 |
A |
1 |
0 |
fruits-legumes-champs-de-cereales |
177 |
220 |
177 |
177/220 |
Autres |
130 |
A |
1 |
0 |
autres-fr |
177 |
404 |
177 |
177/404 |
Kits de végétation |
140 |
A |
1 |
0 |
kits-de-vegetation-miniatures |
177 |