Query time 0.00296
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": [
"PRIMARY",
"c_status",
"p_category_id"
],
"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",
"product_count",
"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`.`category_id` in (245,228,225,224,267,268,311,310,307,221,220,408,402,397,386,179,206,219,218,207,312,316,412,409,405,404,539,622,698,679,676,396,395,376,347,318,317,377,382,393,391,383,201,200,398,394,264,227,401,523,634,548,544,226,209,185,184,178,177,194,202,208,204,203,668,686,379,216,215,214,700,195,199,197,196,213,212,168,167,699,696,191,494,211,210,626,165)) 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 |
product_count |
seo_name |
seo_path |
634 |
0 |
634 |
Articles pour Architectes |
4 |
A |
1 |
0 |
187 |
architectes-miniatures-maquettes-architecture |
|
402 |
194 |
194/402 |
Portes, fenêtres |
5 |
A |
1 |
0 |
6 |
portes-fenetres |
194 |
179 |
177 |
177/179 |
Arbres miniatures |
10 |
A |
1 |
0 |
214 |
arbres-miniatures |
177 |
195 |
194 |
194/195 |
Barrières, grillages, clôtures |
10 |
A |
1 |
0 |
20 |
barrieres-grillages-clotures-fr |
194 |
307 |
203 |
203/307 |
Colles |
10 |
A |
1 |
0 |
39 |
colles-fr |
203 |
494 |
185 |
185/494 |
Echelle 1:87e - Equipements divers, accessoires |
10 |
A |
1 |
0 |
215 |
echelle-1-87e-equipements-divers-accessoires-fr |
185 |
210 |
209 |
209/210 |
Entrées de rues ou tunnels |
10 |
A |
1 |
0 |
33 |
entrees-de-rues-ou-tunnels-fr |
209 |
377 |
208 |
208/377 |
Plateaux Noch |
10 |
A |
1 |
0 |
17 |
plateaux-noch |
208 |
177 |
0 |
177 |
Végétation, nature |
10 |
A |
1 |
0 |
618 |
vegetation-nature-decor-miniature-creches-fr |
|
626 |
398 |
398/626 |
Voitures, tracteurs, véhicules 1:87 |
10 |
A |
1 |
0 |
46 |
voitures-tracteurs-vehicules-1-87-miniatures-maquettes |
398 |
412 |
177 |
177/412 |
Sapins |
11 |
A |
1 |
0 |
97 |
sapins-miniatures-decors-fr |
177 |
267 |
177 |
177/267 |
Arbres et sapins naturels |
12 |
A |
1 |
0 |
68 |
arbres-sapins-naturels-miniatures |
177 |
167 |
165 |
165/167 |
Animaux |
20 |
A |
1 |
0 |
153 |
animaux-miniatures |
165 |
219 |
177 |
177/219 |
Arbustes, haies, vignes |
20 |
A |
1 |
0 |
77 |
arbustes-haies-vignes |
177 |
196 |
194 |
194/196 |
Bâtiments, maisons miniatures |
20 |
A |
1 |
0 |
86 |
batiments-maisons-miniatures |
194 |
311 |
203 |
203/311 |
Mastics, plâtres |
20 |
A |
1 |
0 |
20 |
mastics-platres-fr |
203 |
211 |
209 |
209/211 |
Parkings |
20 |
A |
1 |
0 |
4 |
parkings-fr |
209 |
206 |
204 |
204/206 |
Peinture acrylique |
20 |
A |
1 |
1 |
45 |
peinture-acrylique-fr |
204 |
376 |
208 |
208/376 |
Supports aluminium pour plateaux Noch |
20 |
A |
1 |
0 |
15 |
supports-aluminium-pour-plateaux-noch-fr |
208 |
197 |
194 |
194/197 |
Châteaux, églises, cloîtres |
30 |
A |
1 |
0 |
8 |
chateaux-eglises-cloitres-fr |
194 |
221 |
177 |
177/221 |
Eau, lacs, rivières |
30 |
A |
1 |
0 |
31 |
eau-lacs-rivieres-pour-dioramas-maquettes |
177 |
168 |
165 |
165/168 |
Figurines miniatures |
30 |
A |
1 |
0 |
305 |
personnages-fr |
165 |
165 |
0 |
165 |
Figurines miniatures, animaux |
30 |
A |
1 |
0 |
440 |
figurines-miniatures-animaux |
|
393 |
208 |
208/393 |
Kits de paysages |
30 |
A |
1 |
0 |
3 |
kits-de-paysages-fr |
208 |
312 |
203 |
203/312 |
Outils de precision |
30 |
A |
1 |
0 |
71 |
outils-de-precision-fr |
203 |
268 |
204 |
204/268 |
Patines |
30 |
A |
1 |
1 |
7 |
peintures-patines-fr |
204 |
212 |
209 |
209/212 |
Places, pavés, bétons |
30 |
A |
1 |
0 |
24 |
places-paves-betons |
209 |
347 |
177 |
177/347 |
Terre |
30 |
A |
1 |
0 |
21 |
terre-et-sol-miniature |
177 |
382 |
177 |
177/382 |
Fleurs, plantes |
40 |
A |
1 |
0 |
69 |
fleurs-plantes-miniatures-pour-dioramas-maquettes |
177 |
622 |
203 |
203/622 |
Pinceaux |
40 |
A |
1 |
0 |
21 |
pinceaux |
203 |
213 |
209 |
209/213 |
Ponts, viaducs |
40 |
A |
1 |
0 |
16 |
ponts-viaducs |
209 |
409 |
208 |
208/409 |
Valises Noch |
40 |
A |
1 |
0 |
2 |
valises-noch-fr |
208 |
396 |
204 |
204/396 |
Vernis |
40 |
A |
1 |
1 |
9 |
vernis-fr |
204 |
676 |
208 |
208/676 |
Extensions pour plateaux Noch |
50 |
A |
1 |
0 |
13 |
extensions-pour-plateaux-noch |
208 |
199 |
194 |
194/199 |
Murs et sols en Pierres, briques |
50 |
A |
1 |
0 |
127 |
murs-et-sols-en-pierres-briques |
194 |
405 |
204 |
204/405 |
Peintures Revell |
50 |
A |
1 |
1 |
0 |
peintures-revell-fr |
204 |
214 |
209 |
209/214 |
Routes |
50 |
A |
1 |
0 |
31 |
routes |
209 |
398 |
0 |
398 |
Voitures, véhicules |
50 |
A |
1 |
0 |
65 |
voitures-miniatures-ho-n |
|
185 |
0 |
185 |
Equipements, accessoires |
51 |
A |
1 |
0 |
328 |
equipements-divers-accessoires-fr |
|
397 |
194 |
194/397 |
Murs et sols : tôle, bois, carrelage |
51 |
A |
1 |
0 |
119 |
murs-sols-en-tole-bois-carrelage-fr |
194 |
209 |
0 |
209 |
Routes, tunnels, ponts, voies sncf |
52 |
A |
1 |
0 |
136 |
routes-tunnels-ponts-voies-sncf-miniatures |
|
194 |
0 |
194 |
Maisons, bâtiments, murs, toits |
54 |
A |
1 |
0 |
144 |
maisons-batiments-murs-toits |
|
178 |
0 |
178 |
Eclairages, horloges, poteaux télégraphiques |
55 |
A |
1 |
0 |
74 |
eclairages-horloges-poteaux-fr |
|
218 |
177 |
177/218 |
Feuillage |
60 |
A |
1 |
0 |
23 |
feuillage-miniature |
177 |
204 |
0 |
204 |
Peinture, patines |
60 |
A |
1 |
0 |
51 |
peinture-patines-fr |
|
191 |
165 |
165/191 |
Scénettes |
60 |
A |
1 |
0 |
67 |
scenettes-fr |
165 |
698 |
208 |
208/698 |
Sous plateaux ou "Gares Fantomes" |
60 |
A |
1 |
0 |
4 |
sous-plateaux-ou-gares-fantomes |
208 |
200 |
194 |
194/200 |
Toitures |
60 |
A |
1 |
0 |
77 |
toitures-fr |
194 |
215 |
209 |
209/215 |
Trottoirs |
60 |
A |
1 |
0 |
12 |
trottoirs-fr |
209 |
224 |
177 |
177/224 |
Herbe, champs, flocages, fibres |
70 |
A |
1 |
0 |
192 |
herbe-miniature-poudres-fibres-flocages-fr |
177 |
203 |
0 |
203 |
Outils, materiaux, colles |
70 |
A |
1 |
0 |
144 |
outils-et-materiaux-fr |
|
216 |
209 |
209/216 |
Tunnels |
70 |
A |
1 |
0 |
19 |
tunnels-miniatures-fr |
209 |
201 |
194 |
194/201 |
Voûtes, Arcades |
70 |
A |
1 |
0 |
5 |
voutes-arcades-fr |
194 |
386 |
194 |
194/386 |
Accessoires et habillages |
80 |
A |
1 |
0 |
40 |
accessoires-et-habillages-1-fr |
194 |
226 |
0 |
226 |
Construction des volumes |
80 |
A |
1 |
0 |
66 |
construction-des-volumes |
|
245 |
177 |
177/245 |
Lichen, mousse d'Islande |
80 |
A |
1 |
0 |
37 |
lichen-mousse-dislande-fr |
177 |
316 |
203 |
203/316 |
Plaques, profils, Tubes |
80 |
A |
1 |
0 |
0 |
plaques-profils-tubes-evergreen-fr |
203 |
208 |
0 |
208 |
Plateaux Noch, Kits paysages |
80 |
A |
1 |
0 |
49 |
plateaux-noch-fr |
|
379 |
209 |
209/379 |
Signalisation routière |
80 |
A |
1 |
0 |
17 |
signalisation-routiere |
209 |
264 |
0 |
264 |
Décors Noël, neige, crèches |
90 |
A |
1 |
0 |
93 |
noel-neige-creches |
|
202 |
0 |
202 |
Maquettes, modélisme ferroviaire |
90 |
A |
1 |
0 |
77 |
maquettes-miniatures-pour-dioramas-trains-fr |
|
679 |
203 |
203/679 |
Outillage PROXXON |
90 |
A |
1 |
0 |
22 |
outillage-proxxon |
203 |
225 |
177 |
177/225 |
Pierres, sable, ballast |
90 |
A |
1 |
0 |
77 |
pierres-sable-ballast |
177 |
700 |
209 |
209/700 |
Voies sncf |
90 |
A |
1 |
0 |
7 |
voies-sncf |
209 |
668 |
0 |
668 |
Téléphériques miniatures, Télésièges |
91 |
A |
1 |
0 |
67 |
telepheriques-telesieges-miniatures-brawa-jaegerndorfer |
|
696 |
0 |
696 |
Miniatures 3D |
100 |
A |
1 |
0 |
17 |
miniatures-3d |
|
228 |
177 |
177/228 |
Rochers, Montagnes |
100 |
A |
1 |
0 |
83 |
rochers-montagnes-fr |
177 |
395 |
203 |
203/395 |
Décalcomanies |
110 |
A |
1 |
0 |
16 |
decalcomanies-fr |
203 |
391 |
177 |
177/391 |
Lièges |
110 |
A |
1 |
0 |
4 |
lieges-fr |
177 |
539 |
203 |
203/539 |
Bandes de liège pour voies |
120 |
A |
1 |
0 |
0 |
bandes-de-liege-pour-voies-fr |
203 |
383 |
177 |
177/383 |
Fruits, Légumes, champs de céréales |
120 |
A |
1 |
0 |
23 |
fruits-legumes-champs-de-cereales |
177 |
310 |
203 |
203/310 |
Autres |
130 |
A |
1 |
0 |
43 |
autres-1-fr |
203 |
220 |
177 |
177/220 |
Autres |
130 |
A |
1 |
0 |
8 |
autres-fr |
177 |
404 |
177 |
177/404 |
Kits de végétation |
140 |
A |
1 |
0 |
6 |
kits-de-vegetation-miniatures |
177 |
686 |
0 |
686 |
Maquettes à monter |
1030 |
A |
1 |
0 |
45 |
maquettes-a-monter-france-maquette |
|
544 |
0 |
544 |
Jouets |
1040 |
A |
1 |
0 |
56 |
jouets-miniatures-miniatures-telepheriques-dameuses-voitures |
|