Query time 0.07067
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "218.23"
},
"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": 209,
"rows_produced_per_join": 4,
"filtered": "2.00",
"cost_info": {
"read_cost": "188.28",
"eval_cost": "0.42",
"prefix_cost": "188.70",
"data_read_per_join": "10K"
},
"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 (1035,1044,1088,1090,1205,1207,1114,1279,6794,1131,1318,1201,1264,1266,2382,2699,13057,1306,1310,1325,1345,1375,19445,19446,19491,19568,20830,20923,21141,21171,19497,19540,19541,19542,19548,19577,19827,20792,20827,20834,20924,20925,20927,20930,20961,21089,21091,21115,19566,19756,20793,20794,20835,20968,21157,20928,20929,21583,20975,21323,23230,23276,23252,23255,23256,23855,23258,23262,23840,28622,23263,23264,23265,23277,23847,23282,23399,23306,23307,23323,23332,23393,2616,2642,2643,2686,2696,2689,2700,2702,2706,2790,29881,5111,23462,23463,23464,23465,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5134,5366,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,7213,5365,5371,5375,7212,5377,7206,7207,5384,5385,5386,5417,5432,7230,7231,7232,7233,5388,7181,7182,5390,5406,7210,7211,5747,5748,5749,5750,5751,5752,5753,5754,5755,7183,7184,7185,7186,7187,7188,7189,7193,7194,7197,7198,7190,7191,7192,7195,7196,7199,7200,7201,7202,7203,7204,7205,7208,7209,7214,7215,7216,7217,5187,5716,5772,6628,6795,7122,7162,8780,8781,8908)) 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": 81,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.79",
"eval_cost": "8.14",
"prefix_cost": "200.63",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "(`maniamall_cscart`.`products_categories`.`product_id` <> 1231230)"
}
},
{
"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": 8,
"filtered": "10.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.81",
"prefix_cost": "208.78",
"data_read_per_join": "35K"
},
"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": 8,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.81",
"prefix_cost": "209.59",
"data_read_per_join": "31K"
},
"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": 8,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.81",
"prefix_cost": "210.41",
"data_read_per_join": "31K"
},
"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": 8,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.81",
"prefix_cost": "211.22",
"data_read_per_join": "260"
},
"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": 2,
"filtered": "30.00",
"using_index": true,
"cost_info": {
"read_cost": "6.20",
"eval_cost": "0.24",
"prefix_cost": "218.23",
"data_read_per_join": "58"
},
"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 |
| 503738 |
Camera Video Auto Marsarier Blow + Cabluri Montaj Incluse |
-99 |
27.73 |
53.00 |
Y |
| 1114057 |
Purificator Aer Auto Carruzzo, cu Functie de Ionizare, Filtru de carbon, Eficienta 3.6mp |
-99 |
103.66 |
114.37 |
Y |
| 503771 |
Comutator Buton Auto ON/OFF Tunning 10A 125VAC / 6A 250VAC |
-99 |
2.78 |
15.00 |
Y |
| 524883 |
Modulator FM Auto Bluetooth Blow cu Afisaj LCD, Functie Telefon, Telecomanda, Microfon Incorporat si Incarcator USB, Culoare Alb |
-99 |
78.51 |
90.00 |
Y |
| 622209 |
Buton contact electric 5x5x1.4 pentru telecomanda, cheie auto L4 AllCars |
-99 |
2.00 |
0.00 |
N |
| 484137 |
Actuator Auto Universal cu 2 Fire pentru Inchidere Centralizata si Alarme Auto |
-99 |
5.17 |
18.00 |
Y |