Query time 0.83890
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "8.39"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "inventory",
"access_type": "system",
"possible_keys": [
"pc"
],
"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.10",
"prefix_cost": "0.00",
"data_read_per_join": "880"
},
"used_columns": [
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 7,
"rows_produced_per_join": 0,
"filtered": "2.00",
"cost_info": {
"read_cost": "7.60",
"eval_cost": "0.01",
"prefix_cost": "7.62",
"data_read_per_join": "371"
},
"used_columns": [
"category_id",
"company_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`maniamall_cscart`.`cscart_categories`.`company_id` = 1) and (`maniamall_cscart`.`cscart_categories`.`category_id` in (4528,30755,32420,42629,42630,42631,42632)) and ((`maniamall_cscart`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`))) and (`maniamall_cscart`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.cscart_categories.category_id"
],
"rows_examined_per_scan": 19,
"rows_produced_per_join": 2,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.12",
"eval_cost": "0.27",
"prefix_cost": "8.01",
"data_read_per_join": "43"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "8.28",
"data_read_per_join": "610"
},
"used_columns": [
"product_id",
"status",
"amount",
"usergroup_ids",
"tracking",
"stoc_intern",
"pret_achizitie",
"pret_revanzator",
"gestiune"
],
"attached_condition": "((0 <> (case `maniamall_cscart`.`products`.`tracking` when 'O' then <cache>((NULL > 0)) when 'B' then (`maniamall_cscart`.`products`.`amount` > 0) else 1 end)) and ((`maniamall_cscart`.`products`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`products`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`products`.`usergroup_ids`))) and (`maniamall_cscart`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "shared_descr",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id",
"company_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code",
"company_id"
],
"key_length": "13",
"ref": [
"maniamall_cscart.products_categories.product_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "8.30",
"data_read_per_join": "532"
},
"used_columns": [
"product_id",
"lang_code",
"company_id",
"product"
]
}
},
{
"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": [
"maniamall_cscart.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "8.31",
"data_read_per_join": "533"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "8.33",
"data_read_per_join": "4"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "lower_limit",
"used_key_parts": [
"lower_limit",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "50.00",
"using_index": true,
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "8.39",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(`maniamall_cscart`.`prices`.`usergroup_id` in (0,0,1))"
}
}
]
}
}
}
}
Result
| product_id |
product |
stoc_intern |
pret_achizitie |
pret_revanzator |
gestiune |
| 1662418 |
Pom de Craciun LED, acril, 12 cm - eChilipir |
-99 |
16.22 |
0.00 |
Y |
| 1659922 |
Set sigurante cilindrice 10buc - 4Cars - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1661347 |
Prelata motocicleta impermeabila Ventura - XL - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1657700 |
Sigurante capota tuning competitii 2buc - GC-0 - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658556 |
Plasa grila spoiler Racing Negru - Small 2x4mm 100x33cm - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1659797 |
Bec halogen 12V - H7 - 55W - PX26d 1buc 4Cars - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659562 |
Buson rezervor camion din plastic negru cu cheie Kamar - Ø 80mm - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1657765 |
Prezoane jante conice scurte 10buc - CC1 - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1657745 |
Prezoane jante conice 10buc - TC2 - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1661374 |
Lampa stop LED cu 3 functii Nova 12V - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1915737 |
Cauciuc pedala Ford Fiesta/Fusion;Focus I;Mondeo III - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659943 |
Huse scaun furgoneta de transport Elegance DV3 - 3Locuri - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1661339 |
Lampi semnalizare directie mers Atom LED 12V 2buc - Negru - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659257 |
Bec 12V - 10,5x36mm - C5W - 5W Sofit SV8,5 1buc Narva - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1660558 |
Termostat Wahler - VW Golf/Passat - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659816 |
Rezerva disc panza pentru aparat de lustruit si ceruit Lampa 2buc - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 2591113 |
Cap de aspirare cu perie si sac pentru curatarea piscinii, Bigstren, plastic, culoare negru/portocaliu/gri |
-99 |
23.86 |
36.00 |
Y |
| 1658321 |
Huse scaun Linear set 8buc jacquard high-quality - Gri - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1662787 |
Dozatoare sare şi piper – sticlă – 2 buc./cutie - eChilipir |
-99 |
6.55 |
0.00 |
Y |
| 1664138 |
Lampă solară LED - model „Fulg de zăpadă” - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1660123 |
Vopsea spray cauciucata Kolor Dip 400ml - Fluor green - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1664236 |
Mini proiectoare Dash-Lites 2, LED 2buc 24V - Albastru - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1661363 |
Carcasa tare Opti Case pentru suporti telefon mobil Opti Line - iPhone 6Plus/7Plus/8Plus - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1916044 |
Instalație de pom cu LED - fulgi de nea - 2,3 m - 20 LED - multicolor - 3 x AA - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1660260 |
Bucsa bara stab.fata Ford Mondeo III - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1657702 |
Acoperitori pedale Race 1 - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1660929 |
Prelata auto completa Mobile Garage - L - LAV - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1663152 |
Profil izolator autoadeziv pt. ferestre si usi, profil „P” - 100 m, maro- - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 2596602 |
Organizator auto universal multifunctional pentru scaun, Piele Ecologica, 58x41 cm, negru |
-99 |
20.08 |
36.00 |
Y |
| 2099753 |
Spray silicon bord Polo K2 750ml - Lavanda - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658439 |
Dezactivator Beep centura siguranta Zitto-2 - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1663290 |
Plasa de tantari cu vanzare la rolă, croibila, 100 cm x 30 m - Alb - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1661128 |
Huse scaun dedicate pentru Ford Focus II 2004->2011, Focus III 2011-> - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658521 |
Adaptoare oglinzi Race Seat Leon (11/99-9/05) - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658562 |
Huse scaun Kynox 9buc - Bej - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 2068216 |
Bicicleta fara Pedale pentru Copii, cu Roti din material Eva, Saua reglabila, culoare Negru |
-99 |
114.93 |
155.00 |
Y |