Query time 0.45361
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "370.72"
},
"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": "shared_descr",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"product_id",
"company_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"lang_code",
"company_id",
"product"
]
}
},
{
"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": 5,
"filtered": "4.00",
"cost_info": {
"read_cost": "28.14",
"eval_cost": "1.00",
"prefix_cost": "29.14",
"data_read_per_join": "13K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "(((`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` in ('A','H')) and (`ea201_francemaqu`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"ea201_francemaqu.cscart_categories.category_id"
],
"rows_examined_per_scan": 136,
"rows_produced_per_join": 680,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "21.98",
"eval_cost": "136.00",
"prefix_cost": "187.12",
"data_read_per_join": "10K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"ea201_francemaqu.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 34,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "6.80",
"prefix_cost": "323.12",
"data_read_per_join": "124K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"timestamp",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`ea201_francemaqu`.`products`.`company_id` = '1') and (`ea201_francemaqu`.`products`.`parent_product_id` = 0) and (`ea201_francemaqu`.`products`.`timestamp` >= 1723541405) and (`ea201_francemaqu`.`products`.`timestamp` <= 1729589405) and ((`ea201_francemaqu`.`products`.`usergroup_ids` = '') or find_in_set(0,`ea201_francemaqu`.`products`.`usergroup_ids`) or find_in_set(1,`ea201_francemaqu`.`products`.`usergroup_ids`)) and (`ea201_francemaqu`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"ea201_francemaqu.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 34,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "6.80",
"prefix_cost": "329.92",
"data_read_per_join": "129K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"membership",
"product_id",
"lower_limit",
"membership_id"
],
"key": "membership",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"ea201_francemaqu.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 33,
"filtered": "99.94",
"using_index": true,
"cost_info": {
"read_cost": "34.00",
"eval_cost": "6.80",
"prefix_cost": "370.72",
"data_read_per_join": "815"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`ea201_francemaqu`.`prices`.`lower_limit` = 1) and (`ea201_francemaqu`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
product_type |
parent_product_id |
11084 |
Coffret Cadeau The Legendary Bismarck 1/700 et 1/1200 - Revell 05637 |
France Maquette |
P |
0 |
11288 |
Tiny Adventures - Roadster - Revell 00615 |
France Maquette |
P |
0 |
11297 |
Dune Harkonnen Ornithopter 1/72 - Meng DS-009 |
France Maquette |
P |
0 |
10975 |
Camion de Pompier "LaFrance Eagle" 1/72 - Trumpeter 7445 |
France Maquette |
P |
0 |
5759 |
Porteur de la flamme des JO 2024 - le Voilier français Le Belem 1:75 - Artesania 22519 |
France Maquette |
P |
0 |
1925 |
Hermione La Fayette 1/89 - Artesania 22517N |
France Maquette |
P |
0 |
11317 |
HK118 Porsche 917K au 1/8 - Gulf Edition - Pocher HK118 |
France Maquette |
P |
0 |
10974 |
FS Jeanne d'Arc 1/350 - Trumpeter 05635 |
France Maquette |
P |
0 |
11013 |
Sous-marin allemand Type IX C Platinum Edition 1/72 - Revell 05180 |
France Maquette |
P |
0 |
11023 |
69 Chevy Camaro 1/12 - Revell 07727 |
France Maquette |
P |
0 |
11027 |
Model set Raketenjagdpanzer Jaguar 1 1/35 - Revell 63353 |
France Maquette |
P |
0 |
11315 |
Gare de station de ski rouge 1/32 - JC 84381 |
France Maquette |
P |
0 |
11314 |
Macchi MC. 205 veltro au 1/32 - Italeri 2519 |
France Maquette |
P |
0 |
11313 |
Opel blitz truck pompier 1/24 - Italeri 3966 |
France Maquette |
P |
0 |
11312 |
Robot E robot télécommandé - Revell 24702 |
France Maquette |
P |
0 |
11036 |
Cabriolet Typ 320 (W142) 1/35 - Revell 03354 |
France Maquette |
P |
0 |
11073 |
KFK (Kriegsfischkutter - Chalutier de guerre) 1/144 - Revell 05242 |
France Maquette |
P |
0 |
11089 |
Véhicule radiocommandé 4 en 1 - Revell 21304 |
France Maquette |
P |
0 |
11309 |
NISSAN FAIRLADY Z05 au 1/24 - Aoshima 05364 |
France Maquette |
P |
0 |
11302 |
BMW M6 Gt3 2020 NLS winner 1/24 - Nunu PN24042 |
France Maquette |
P |
0 |
10884 |
FS Georges Leygues 1/350 - Trumpeter 5375 |
France Maquette |
P |
0 |
11300 |
Honda Ballade Sports Mugen CR-X PRO 1/24 - Tamiya 24045 |
France Maquette |
P |
0 |
11256 |
Polikarpov I-16 Type 5 1/48 - Zvezda 4832 |
France Maquette |
P |
0 |
11257 |
Trirème Grecque 1/72 - Zvezda 8514 |
France Maquette |
P |
0 |
11316 |
Honda CT125 Hunter Club Turmeric Yellow 1/12 - Aoshima 11184 |
France Maquette |
P |
0 |
10830 |
Fourgon VW T1 "Gulf" 1/24 - Revell 07726 |
France Maquette |
P |
0 |
11286 |
Puzzle 3D One Piece Flying Lamb/ Vogue Merry - Revell 00270 |
France Maquette |
P |
0 |
11285 |
8 flacons compte-gouttes- Heller 99015 |
France Maquette |
P |
0 |
11284 |
Set de 3 scalpels à usage unique - Heller 99006 |
France Maquette |
P |
0 |
11283 |
Set de 5 limes diamantées - Heller 99005 |
France Maquette |
P |
0 |
3875 |
Maquette USS Buchanan DDG-484 1/350 - Dragon 1021 |
France Maquette |
P |
0 |
11282 |
Set de 3 limes à sable - Heller 99002 |
France Maquette |
P |
0 |
10638 |
Coffret Cadeau 25e Anniversaire Station ISS 1/144 - Revell 05651 |
France Maquette |
P |
0 |
10870 |
50e anniversaire Tornado 1/72 - Revell 03801 |
France Maquette |
P |
0 |
11031 |
Puzzle 3D House of the Dragon : Ville de King's Landing - Revell 00225 |
France Maquette |
P |
0 |
11030 |
Puzzle 3D House of the Dragon : Trône de fer - Revell 00224 |
France Maquette |
P |
0 |
10738 |
Mitsubishi Lancer 2000 1/24 - Nunu 24032 |
France Maquette |
P |
0 |
11253 |
Renault 5 Turbo 1/24 - Tamiya 24368 |
France Maquette |
P |
0 |
11025 |
Lamborghini Countach LP500S 1/24 - Revell 07730 |
France Maquette |
P |
0 |
11267 |
Infanterie Britannique Normandie 1944 1/35 - Dragon 06212 |
France Maquette |
P |
0 |
11266 |
Infanterie 29ème Div. US Omaha Beach 1/35 - Dragon 06211 |
France Maquette |
P |
0 |
11265 |
Victory Glider - Revell 24331 |
France Maquette |
P |
0 |
11264 |
Starter kit Gordini Racing Set 1/24 - Heller 52328 |
France Maquette |
P |
0 |
11263 |
Starter kit Citroen HY + Goods Trailer 1/24 - Heller 52331 |
France Maquette |
P |
0 |
11262 |
Maquette Porsche 911 GT3 RS (992) 1/24 - Tamiya 24370 |
France Maquette |
P |
0 |
11259 |
Citroen HY + Goods Trailer 1/24 - Heller 50331 |
France Maquette |
P |
0 |
11261 |
Infanterie Britannique Normandie 1944 1/35 - Dragon 06212 |
France Maquette |
P |
0 |
10848 |
Westland Lynx 1/32 - Revell 03806 |
France Maquette |
P |
0 |
10979 |
Char T-72 M1 1/72 - Revell 03357 |
France Maquette |
P |
0 |
11012 |
BM-13-16 on WOT 8 1/35 - Revell 03338 |
France Maquette |
P |
0 |
11024 |
70 Shelby Mustang GT500 1/25 - Revell 07729 |
France Maquette |
P |
0 |
11090 |
Excavatrice hydraulique 3 en 1 - Revell 21305 |
France Maquette |
P |
0 |
11234 |
U.S. Rangers Normandie 1944 1/35 - Dragon 06021 |
France Maquette |
P |
0 |
11235 |
Infanterie 2e division Blindée US Normandie 1944 1/35 - Dragon 06120 |
France Maquette |
P |
0 |
11258 |
Navette Discovery & Booster - Revell 04736 |
France Maquette |
P |
0 |
11254 |
Liquide de masquage 20 ml – Tamiya 87229 |
France Maquette |
P |
0 |
11269 |
Colle céramique 50 g - Aedes 2400 |
France Maquette |
P |
0 |
10333 |
Remorque de marchandises 1/24 - Heller 80778 |
France Maquette |
P |
0 |
11015 |
Croiseur Lourd Chikuma 1/350 - Tamiya 78027 |
France Maquette |
P |
0 |
11018 |
Toyota Soarer 2000Vr-Turbo 1/24 - Tamiya 24365 |
France Maquette |
P |
0 |
11019 |
Mistubishi Ki-46 III & Kurogane 1/48 - Tamiya 25217 |
France Maquette |
P |
0 |
11238 |
BMW 320si E90 WTCC Vainqueur Brands Hatch 2008 1/24 - Nunu PN24037 |
France Maquette |
P |
0 |
11251 |
Remorque de transport 1/24 - Heller 80774 |
France Maquette |
P |
0 |
11307 |
Miniature : Tractopelle Volvo - New Ray 61370 |
France Maquette |
P |
0 |