Query time 0.01922
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "131.84"
},
"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": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"company_id",
"usergroup_ids",
"status"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 502,
"rows_produced_per_join": 502,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.72",
"eval_cost": "50.20",
"prefix_cost": "51.92",
"data_read_per_join": "7K"
},
"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": 25,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "2.51",
"prefix_cost": "102.12",
"data_read_per_join": "109K"
},
"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": 25,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "2.51",
"prefix_cost": "104.63",
"data_read_per_join": "95K"
},
"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": 25,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "2.51",
"prefix_cost": "107.14",
"data_read_per_join": "95K"
},
"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": 25,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "2.51",
"prefix_cost": "109.65",
"data_read_per_join": "803"
},
"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": 12,
"filtered": "50.00",
"using_index": true,
"cost_info": {
"read_cost": "19.68",
"eval_cost": "1.26",
"prefix_cost": "131.84",
"data_read_per_join": "301"
},
"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 |
| 1128285 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm, culoare gri |
0 |
0.00 |
19.00 |
Y |
| 1128289 |
Set perne decorative pentru mobilier paleti,perna sezut 120x70 cm + perna spate 120x40 cm, culoare bej |
0 |
0.00 |
19.00 |
Y |
| 1129605 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm culoare galben |
0 |
0.00 |
19.00 |
Y |
| 1129852 |
Set perne decorative pentru Balansoar, leagan sau bancuta, perna sezut 180x55 + perna spate 180x55, culoare galben |
-99 |
0.00 |
215.00 |
Y |
| 525901 |
Fata de Perna Decorativa Pufoasa, Catifelata, Culoare Verde, Dimensiune 43x43cm |
-99 |
8.04 |
27.00 |
Y |
| 1128299 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm, culoare mov |
0 |
0.00 |
19.00 |
Y |
| 1199097 |
Perna sezut/spatar pentru scaun de gradina sau balansoar, 50x50x55 cm, culoare gri |
-99 |
0.00 |
19.00 |
Y |
| 2055715 |
Protectie laterala patut, pentru Bebelasi, Ricokids, Bumper Impletit, Antialergic, Albastru/Roz/Alb |
-99 |
93.57 |
124.00 |
Y |
| 1718556 |
Perna pentru sezlong de terasa sau gradina, bumbac cu umplutura moale, curele de fixare, 160x50x4 cm, culoare Albastru |
-99 |
0.00 |
100.00 |
Y |
| 1128294 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm, culoare albastru |
0 |
0.00 |
19.00 |
Y |
| 1129606 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm, culoare alb |
0 |
0.00 |
19.00 |
Y |
| 1444124 |
Fata de Perna Decorativa de Craciun, model Merry Christmas, dimensiune 40x40, alb/auriu |
-99 |
7.42 |
8.90 |
Y |
| 1128290 |
Set perne decorative pentru mobilier paleti, perna sezut 120x70 cm + perna spate 120x40 cm, culoare negru |
0 |
0.00 |
19.00 |
Y |
| 1199098 |
Perna sezut/spatar pentru scaun de gradina sau balansoar, 50x50x55 cm, culoare maro |
-99 |
0.00 |
19.00 |
Y |
| 1373431 |
Fata de Perna Decorativa Italia, Moale, 40x40cm, Culoare Antracit |
-99 |
13.30 |
15.02 |
Y |
| 1722316 |
Fata de Perna Decorativa Springos, design abstract, dimensiune 40x40, culoare gri |
-99 |
7.45 |
8.93 |
Y |
| 1373435 |
Fata de Perna Decorativa Italia, Moale, 40x40cm, Culoare verde deschis |
-99 |
13.30 |
15.02 |
Y |
| 1373432 |
Fata de Perna Decorativa Italia, Moale, 40x40cm, Culoare Roz |
-99 |
13.30 |
15.02 |
Y |
| 1128108 |
Perna pentru scaun de casa si gradina cu spatar, 48x48x75cm, culoare rosu |
-99 |
0.00 |
19.00 |
Y |
| 1199099 |
Perna sezut/spatar pentru scaun de gradina sau balansoar, 50x50x55 cm, culoare mov |
-99 |
0.00 |
19.00 |
Y |
| 1199095 |
Perna sezut/spatar pentru scaun de gradina sau balansoar, 50x50x55 cm, culoare albastru |
-99 |
0.00 |
19.00 |
Y |
| 1129597 |
Perna decorativa rotunda, pentru scaun de bucatarie sau terasa, diametrul 35cm, culoare galben |
-99 |
0.00 |
19.00 |
Y |
| 1128097 |
Perna decorativa rotunda, pentru scaun de bucatarie sau terasa, diametrul 35cm, culoare gri inchis |
-99 |
0.00 |
19.00 |
Y |
| 1129869 |
Perna de sezut pentru banca 100 cm lungime x 40 cm latime, culoare Albastru |
-99 |
0.00 |
64.00 |
Y |
| 1129863 |
Perna de sezut pentru banca 75 cm Lungime x 40 cm latime, culoare Galben |
-99 |
0.00 |
55.00 |
Y |
| 1128078 |
Perna decorativa pentru scaun de bucatarie sau terasa, dimensiuni 40x40cm, culoare Gri |
-99 |
0.00 |
19.00 |
Y |
| 1193387 |
Perna decorativa patrata, 40x40 cm, pentru canapele, plina cu Puf Mania Relax, culoare albastru |
-99 |
0.00 |
23.00 |
Y |
| 1198929 |
Perna decorativa dreptunghiulara, 50x30 cm, plina cu Puf Mania Relax, culoare galben |
-99 |
0.00 |
23.00 |
Y |
| 1198866 |
Perna decorativa dreptunghiulara Mania Relax, din bumbac, 50x70 cm, culoare verde |
-99 |
0.00 |
42.00 |
Y |
| 1129865 |
Perna de sezut pentru banca 100 cm lungime x 40 cm latime, culoare Gri |
-99 |
0.00 |
64.00 |
Y |
| 1129867 |
Perna de sezut pentru banca 100 cm lungime x 40 cm latime, culoare Bej |
-99 |
0.00 |
64.00 |
Y |
| 1198921 |
Perna decorativa dreptunghiulara, 50x30 cm, plina cu Puf Mania Relax, culoare maro |
-99 |
0.00 |
23.00 |
Y |
| 1129873 |
Perna de sezut pentru banca 100 cm lungime x 40 cm latime, culoare Visiniu |
-99 |
0.00 |
64.00 |
Y |
| 1129857 |
Perna de sezut pentru banca 75 cm Lungime x 40 cm latime, culoare Negru |
-99 |
0.00 |
55.00 |
Y |
| 1129861 |
Perna de sezut pentru banca 75 cm Lungime x 40 cm latime, culoare Rosu |
-99 |
0.00 |
55.00 |
Y |
| 1129864 |
Perna de sezut pentru banca 75 cm Lungime x 40 cm latime, culoare Alb |
-99 |
0.00 |
55.00 |
Y |
| 2538988 |
Perna de gradina matlasata cu umplutura moale pentru leagan sau banca, perna sezut 140x60 cm + perna spate 140x50 cm, culoare gri |
-99 |
85.83 |
145.00 |
Y |