Query time 0.00404
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "31.54"
},
"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": 125,
"rows_produced_per_join": 0,
"filtered": "0.80",
"cost_info": {
"read_cost": "28.94",
"eval_cost": "0.20",
"prefix_cost": "29.14",
"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_francemaqu`.`cscart_categories`.`company_id` = 1) and ((`ea201_francemaqu`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`ea201_francemaqu`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`ea201_francemaqu`.`cscart_categories`.`usergroup_ids`)) and (`ea201_francemaqu`.`cscart_categories`.`status` = 'A') and (`ea201_francemaqu`.`cscart_categories`.`category_id` in (32,111,112,9,10,13,110,120,11,33,12,5,45,46,31,30,20,27,19,94,92,2,47,16,49,3,7,8,50,51,17,26,25,18,91,14,29,28,15,122,87,88,89,21,22,62,77,36,40,41,42,37,95,96,44,43,23,39,35,38,34,24,113,74,52,54,55,79,80,81,82,64,97,98,101,99,100,102,103,104,114,4,105,93,118,117,119,121,107,116)) and (`ea201_francemaqu`.`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_francemaqu.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": "30.34",
"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_francemaqu.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": "31.54",
"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 |
47 |
2 |
2/47 |
1ère Guerre Mondiale |
10 |
A |
1 |
1 |
11 |
maquettes-militaires-1ere-guerre-mondiale-fr |
2 |
45 |
5 |
5/45 |
1ère Guerre Mondiale |
10 |
A |
1 |
1 |
20 |
maquettes-avions-1ere-guerre-mondiale-fr |
5 |
39 |
23 |
23/39 |
Aérographes |
10 |
A |
1 |
0 |
38 |
aerographes-fr |
23 |
88 |
87 |
87/88 |
Bateaux bois - navires et voiliers |
10 |
A |
1 |
1 |
97 |
maquettes-bateaux-en-bois |
87 |
22 |
21 |
21/22 |
Décors militaires dioramas |
10 |
A |
1 |
0 |
44 |
decors-militaires |
21 |
26 |
17 |
17/26 |
Figurines 1:32 |
10 |
A |
1 |
0 |
2 |
maquettes-figurines-1-32-fr |
17 |
95 |
37 |
36/37/95 |
Flacons Tamiya Color |
10 |
A |
1 |
1 |
271 |
flacons-tamiya-color |
36/37 |
41 |
40 |
36/40/41 |
Glycéro Enamel Color |
10 |
A |
1 |
1 |
103 |
glycero-fr |
36/40 |
9 |
0 |
9 |
Maquettes VOITURES / Van / Bus |
10 |
A |
1 |
1 |
547 |
maquettes-voitures-fr |
|
111 |
32 |
32/111 |
Model-Set Revell |
10 |
A |
1 |
0 |
111 |
model-set-revell |
32 |
33 |
11 |
11/33 |
Motos de collection |
10 |
A |
1 |
1 |
54 |
maquettes-motos-routieres-fr |
11 |
29 |
14 |
14/29 |
Navires civils |
10 |
A |
1 |
1 |
36 |
maquettes-navires-civils-fr |
14 |
40 |
36 |
36/40 |
Revell - peintures maquettes |
10 |
A |
1 |
1 |
19 |
revell-fr |
36 |
4 |
114 |
114/4 |
Star Wars |
10 |
A |
1 |
0 |
40 |
maquettes-star-wars-fr |
114 |
13 |
9 |
9/13 |
VOITURES de sport |
10 |
A |
1 |
1 |
257 |
maquettes-voitures-de-sport-fr |
9 |
46 |
5 |
5/46 |
2ème Guerre Mondiale |
20 |
A |
1 |
1 |
262 |
maquettes-avions-2eme-guerre-mondiale-fr |
5 |
16 |
2 |
2/16 |
2ème Guerre Mondiale |
20 |
A |
1 |
1 |
432 |
maquettes-militaires-2eme-guerre-mondiale-1-fr |
2 |
89 |
87 |
87/89 |
Accessoires et outillages |
20 |
A |
1 |
1 |
196 |
accessoires-pour-maquettes-bois |
87 |
42 |
40 |
36/40/42 |
Acryliques Aqua Color |
20 |
A |
1 |
1 |
100 |
acryliques-fr |
36/40 |
112 |
32 |
32/112 |
Coffrets cadeau |
20 |
A |
1 |
0 |
326 |
coffrets-cadeau |
32 |
35 |
23 |
23/35 |
Colles pour maquettes |
20 |
A |
1 |
0 |
75 |
colles-pour-maquettes |
23 |
25 |
17 |
17/25 |
Figurines 1:35 |
20 |
A |
1 |
0 |
92 |
maquettes-figurines-1-35-fr |
17 |
105 |
114 |
114/105 |
Leonardo Da Vinci |
20 |
A |
1 |
0 |
6 |
leonardo-da-vinci |
114 |
110 |
0 |
110 |
Maquettes CAMIONS |
20 |
A |
1 |
1 |
97 |
maquettes-camions |
|
28 |
14 |
14/28 |
Marine / Vaisseaux militaires |
20 |
A |
1 |
1 |
132 |
maquettes-navires-militaires-fr |
14 |
12 |
11 |
11/12 |
Motos de sport |
20 |
A |
1 |
1 |
60 |
maquettes-motos-de-sport-fr |
11 |
96 |
37 |
36/37/96 |
Spray Tamiya Color |
20 |
A |
1 |
1 |
134 |
aerosols-tamiya-colors |
36/37 |
37 |
36 |
36/37 |
Tamiya - peintures maquettes |
20 |
A |
1 |
1 |
95 |
tamiya-fr |
36 |
10 |
9 |
9/10 |
Voitures de collection |
20 |
A |
1 |
1 |
343 |
maquettes-voitures-de-collection |
9 |
38 |
23 |
23/38 |
Enduits |
30 |
A |
1 |
0 |
26 |
enduits-fr |
23 |
18 |
17 |
17/18 |
Figurines 1:72 |
30 |
A |
1 |
0 |
137 |
maquettes-figurines-1-72-fr |
17 |
5 |
0 |
5 |
Maquettes AVIONS / Hélicoptères |
30 |
A |
1 |
1 |
681 |
maquettes-avions-fr |
|
14 |
0 |
14 |
Maquettes BATEAUX |
30 |
A |
1 |
1 |
267 |
maquettes-bateaux-fr |
|
49 |
2 |
2/49 |
Matériel post-1950 |
30 |
A |
1 |
1 |
121 |
maquettes-militaires-conflits-contemporains-fr |
2 |
77 |
21 |
21/77 |
Monuments et Bâtiments |
30 |
A |
1 |
0 |
8 |
monuments-maquettes |
21 |
15 |
14 |
14/15 |
Voiliers |
30 |
A |
1 |
1 |
75 |
maquettes-voiliers-fr |
14 |
3 |
2 |
2/3 |
Artillerie |
40 |
A |
1 |
1 |
52 |
maquettes-militaires-artillerie-fr |
2 |
30 |
5 |
5/30 |
Avions militaires modernes |
40 |
A |
1 |
1 |
262 |
avions-militaires-modernes |
5 |
118 |
114 |
114/118 |
Espace |
40 |
A |
1 |
0 |
25 |
espace |
114 |
91 |
17 |
17/91 |
Figurines 1:48 |
40 |
A |
1 |
0 |
0 |
figurines-1-48 |
17 |
87 |
0 |
87 |
Maquettes BOIS BATEAUX |
40 |
A |
1 |
1 |
254 |
maquettes-bois |
|
120 |
9 |
9/120 |
Maquettes Bus, Trains |
40 |
A |
1 |
1 |
30 |
bus-trains |
9 |
34 |
23 |
23/34 |
Outils |
40 |
A |
1 |
0 |
285 |
outils |
23 |
44 |
36 |
36/44 |
Pinceaux |
40 |
A |
1 |
1 |
75 |
pinceaux-fr |
36 |
122 |
14 |
14/122 |
Sous marins |
40 |
A |
1 |
1 |
21 |
maquette-sous-marins |
14 |
7 |
2 |
2/7 |
Chars d'assaut, Blindés |
50 |
A |
1 |
1 |
363 |
maquettes-militaires-chars-dassaut-fr |
2 |
24 |
23 |
23/24 |
Divers |
50 |
A |
1 |
0 |
140 |
sets-fr |
23 |
20 |
5 |
5/20 |
Maquettes Hélicoptères |
50 |
A |
1 |
1 |
51 |
maquettes-miniatures-avions-helicopteres-modelisme |
5 |
11 |
0 |
11 |
Maquettes MOTOS |
50 |
A |
1 |
1 |
101 |
maquettes-motos-fr |
|
27 |
5 |
5/27 |
Maquettes Avions 1:32 |
60 |
A |
1 |
1 |
56 |
maquettes-avions-1-32-fr |
5 |
2 |
0 |
2 |
Maquettes MILITAIRES |
60 |
A |
1 |
1 |
720 |
maquettes-militaires-fr |
|
8 |
2 |
2/8 |
Véhicules Légers |
60 |
A |
1 |
1 |
117 |
maquettes-militaires-vehicules-legers-fr |
2 |
19 |
5 |
5/19 |
Maquettes Avions 1:48 |
70 |
A |
1 |
1 |
192 |
maquettes-avions-1-48 |
5 |
50 |
2 |
2/50 |
Maquettes militaires 1:35 |
70 |
A |
1 |
1 |
337 |
maquettes-militaires-1-35 |
2 |
94 |
5 |
5/94 |
Maquettes Avions 1:72 |
80 |
A |
1 |
1 |
295 |
maquettes-avions-1-72 |
5 |
51 |
2 |
2/51 |
Maquettes militaires 1:72 |
80 |
A |
1 |
1 |
176 |
1-72-1-fr |
2 |
36 |
0 |
36 |
PEINTURES MAQUETTES |
80 |
A |
1 |
1 |
387 |
peintures-maquettes-revell-tamiya-fr |
|
92 |
5 |
5/92 |
Academy Hobby Model Kits |
90 |
A |
1 |
1 |
0 |
academy-hobby-model-kits |
5 |
32 |
0 |
32 |
Kits Complets maquette et peintures |
90 |
A |
1 |
0 |
407 |
maquettes-kits-complets |
|
43 |
36 |
36/43 |
Autres accessoires |
100 |
A |
1 |
1 |
104 |
autres-accessoires-fr |
36 |
23 |
0 |
23 |
Accessoires modélisme |
110 |
A |
1 |
0 |
463 |
accessoires-de-modelisme |
|
54 |
52 |
52/54 |
Miniatures avions / hélicoptères |
140 |
A |
1 |
0 |
7 |
miniatures-avions-helicopteres-fr |
52 |
55 |
52 |
52/55 |
Miniatures Tanks |
150 |
A |
1 |
0 |
0 |
miniatures-tanks-fr |
52 |
119 |
0 |
119 |
Maquettes débutants |
200 |
A |
1 |
1 |
196 |
mes-premieres-maquettes |
|
114 |
0 |
114 |
Maquettes à thèmes |
210 |
A |
1 |
0 |
198 |
maquettes-a-themes |
|
52 |
0 |
52 |
Miniatures |
300 |
A |
1 |
0 |
13 |
miniatures-fr |
|
21 |
0 |
21 |
Decors maquettes |
500 |
A |
1 |
0 |
53 |
decors-fr |
|
17 |
0 |
17 |
Figurines |
600 |
A |
1 |
0 |
252 |
maquettes-figurines-fr |
|
117 |
0 |
117 |
Téléphériques, Télésièges |
1000 |
A |
1 |
0 |
73 |
telepheriques-telesieges |
|
74 |
0 |
74 |
Librairie et catalogues |
1150 |
A |
1 |
0 |
16 |
librairie-catalogues-maquettes |
|
62 |
0 |
62 |
Décors miniatures et végétation |
1400 |
A |
1 |
0 |
260 |
decors-miniatures |
|
116 |
0 |
116 |
Nouveautés Maquettes |
1500 |
A |
1 |
1 |
225 |
nouveautes-maquettes |
|