Query time 0.20941
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "8.05"
},
"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.25",
"eval_cost": "0.01",
"prefix_cost": "7.27",
"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": "7.66",
"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": "7.93",
"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": "7.95",
"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": "7.96",
"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": "7.97",
"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": "product_id",
"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": "25.00",
"using_index": true,
"cost_info": {
"read_cost": "0.06",
"eval_cost": "0.00",
"prefix_cost": "8.05",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`maniamall_cscart`.`prices`.`lower_limit` = 1) and (`maniamall_cscart`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
stoc_intern |
pret_achizitie |
pret_revanzator |
gestiune |
| 1732000 |
Ornamente crom pt. oglinda compatibil Dacia Duster 2010-> TR MRA36-150421-5 |
-99 |
180.00 |
0.00 |
Y |
| 1661266 |
Ornamente bara protectie reflectorizante Cata-Reflex 4buc - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1731933 |
Ornamente crom pt. oglinda compatibil Land Range Rover Freelander 2 Discovery Sport CROM 0230 MRA36-240521-3 |
-99 |
200.00 |
0.00 |
Y |
| 1658668 |
Priza auto incorporabila DIN - 12/24V 16A - Lampa - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658805 |
Burduf schimbator viteza cu snur - Galben - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 2539827 |
Termometru alimentar analogic de insertie pentru carne, inox, 0°C - 120°C, negru/argintiu |
-99 |
6.34 |
14.00 |
Y |
| 1661450 |
Coliere fixare proiectoare Fixer 2buc - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658400 |
Autocolant 3D crom Type-3 (28mm) litera - B - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1661340 |
Releu electronic pentru semnalizatoare LED 6/12/24V - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 2072334 |
Suport magnetic auto pentru telefon cu prindere in grila de ventilatie, culoare Negru |
-99 |
6.69 |
18.00 |
Y |
| 1659066 |
Maner schimbator viteza imitatie lemn si masaj 4Cars - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1163013 |
TOTAL - Lama taiere - carbid tungsten - compatibil - MTO-THT576004B |
-99 |
0.00 |
0.00 |
N |
| 1663387 |
Țăruși pentru fixarea gazonului artificial - pachet de 10 - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 2253671 |
Set Accesorii Intex pentru Curatarea Piscinelor, culoare Alb/Albastru |
-99 |
99.51 |
127.00 |
Y |
| 1659620 |
Bec tip LED 12V soclu plastic T5 W2x4,6d 2buc - Curcubeu - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658630 |
Bec tip LED 24V poz semn bord soclu metal T4W BA9s 2buc - Rosu - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659207 |
Bec halogen 12V - H10 - 42W - PY20d 1buc Lampa - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658657 |
Bec halogen Blu-Xe H7 100W PX26d 12V 2buc - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1657931 |
Aparatori noroi camion 45x35cm 2buc - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1661143 |
Breloc chei cu cablu 10cm - USB la Micro USB - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1732317 |
Aparatori noroi dedicate Mercedes Clasa E W212 berlina Facelift W212 / W212 T-modell Facelift S212 2013-2016 ( MUD1104 CH-2 ) MRA36-091220-22 |
-99 |
127.27 |
0.00 |
Y |
| 1664148 |
Fierbator apa 1L Carpoint - 12V - 150W - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1732319 |
Aparatori noroi dedicate Land Rover Range Rover Evoque Prestige 2011-> ( MUD1102 CH-2 ) MRA36-091220-20 |
-99 |
127.27 |
0.00 |
Y |
| 1657915 |
Priza auto incorporabila 12V 20A - Carpoint - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659840 |
Oglinda interioara cu ventuza 148x60mm Carpoint - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658338 |
Bec tip LED 12V iluminat bord soclu pl. T5 W2x4,6d 5buc - Albast - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658635 |
Bec tip LED 12V sofit cu 8 leduri 13x35mm SV8,5-8 1buc - Verde - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1658606 |
Set sigurante cilindrice 10buc - Lampa - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658866 |
Prezoane antifurt jante sferice M14x1,5mm 4buc - Tip D - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658169 |
Plasa protectie universala 120x50cm - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1660818 |
Priza tripla bricheta cu USB si telecomanda Duo-4 IR 24V - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1659802 |
Bec Led - 2SMD 12V sofit T11x36mm soclu SV8,5-8 2buc - Alb - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1659293 |
Bec xenon 12V - H7 - 35W PX26d 1buc - 6000K - eChilipir |
-99 |
0.00 |
0.00 |
Y |
| 1660499 |
Placute frana spate TRW - Mercedes C-Class W202/W203 - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1658645 |
Bec halogen Blu-Xe H7 55W PX26d 12V 2buc - eChilipir |
-99 |
0.00 |
0.00 |
N |
| 1661096 |
Huse scaun De-Luxe Sport Edition jacquard high-quality 9buc - Negru - eChilipir |
-99 |
0.00 |
0.00 |
Y |