Query time 0.00171
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.94"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"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": "3K"
},
"used_columns": [
"category_id",
"storefront_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": 124,
"rows_produced_per_join": 124,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.02",
"eval_cost": "12.40",
"prefix_cost": "13.42",
"data_read_per_join": "1K"
},
"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": [
"cscartdevel.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 38,
"filtered": "30.95",
"cost_info": {
"read_cost": "31.00",
"eval_cost": "3.84",
"prefix_cost": "56.82",
"data_read_per_join": "175K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((`cscartdevel`.`products`.`parent_product_id` = 0) and ((`cscartdevel`.`products`.`amount` > 0) or (`cscartdevel`.`products`.`tracking` = 'D')) and ((`cscartdevel`.`products`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdevel`.`products`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdevel`.`products`.`usergroup_ids`))) and (`cscartdevel`.`products`.`status` = 'A') and (`cscartdevel`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"cscartdevel.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "10.00",
"cost_info": {
"read_cost": "9.60",
"eval_cost": "0.38",
"prefix_cost": "70.25",
"data_read_per_join": "29K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`cscartdevel`.`companies`.`status` = 'A')"
}
},
{
"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": [
"cscartdevel.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "99.85",
"cost_info": {
"read_cost": "0.96",
"eval_cost": "0.38",
"prefix_cost": "71.60",
"data_read_per_join": "91"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`cscartdevel`.`prices`.`lower_limit` = 1) and (`cscartdevel`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"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": [
"cscartdevel.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.96",
"eval_cost": "0.38",
"prefix_cost": "72.94",
"data_read_per_join": "20K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
product_type |
parent_product_id |
2281 |
COCONUT MILK - NAPÓJ KOKOSOWY BEZ GUMY GUAR (22 % TŁUSZCZU) BIO 200 ml - TERRASANA |
Eden BIO |
P |
0 |
2379 |
CYKORIA INSTANT BEZGLUTENOWA BIO 100 g - LIMA |
Eden BIO |
P |
0 |
2346 |
HERBATA BIAŁA Z ALOESEM (WHITE TEA WITH ALOE VERA) BIO (17 x 1,8 g) 30,6 g - YOGI TEA |
Eden BIO |
P |
0 |
2301 |
HERBATA CZARNA CEJLOŃSKA FAIR TRADE BIO (20 x 2 g) 40 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2081 |
HERBATA CZARNA SRI LANKA FAIR TRADE BIO (100 x 1,8 g) 180 g - OXFAM |
Eden BIO |
P |
0 |
1947 |
HERBATA CZARNA Z IMBIREM I CYNAMONEM (BLACK CHAI) BIO (17 x 2,2 g) 37,4 g - YOGI TEA |
Eden BIO |
P |
0 |
2157 |
HERBATA CZERWONA LIŚCIASTA PU ERH BIO 70 g - ECOBLIK |
Eden BIO |
P |
0 |
2207 |
HERBATA EARL GREY FAIR TRADE BIO (250 x 2,0 g) 500 g - CLIPPER |
Eden BIO |
P |
0 |
2142 |
HERBATA ENGLISH BREAKFAST FAIR TRADE BIO (250 x 2,2 g) 550 g - CLIPPER |
Eden BIO |
P |
0 |
2121 |
HERBATA ZIELONA ENERGIA (GREEN ENERGY) BIO (17 x 1,8 g) 30,6 g - YOGI TEA |
Eden BIO |
P |
0 |
2375 |
HERBATA ZIELONA JAŚMINOWA BIO (20 x 1,5 g) 30 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2088 |
HERBATA ZIELONA LIŚCIASTA DARJEELING DEMETER BIO 50 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2089 |
HERBATA ZIELONA LIŚCIASTA GUNPOWDER BIO 100 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2090 |
HERBATA ZIELONA LIŚCIASTA JAŚMINOWA BIO 75 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2087 |
HERBATA ZIELONA LIŚCIASTA SENCHA BIO 75 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2158 |
HERBATA ZIELONA LIŚCIASTA SENCHA JAPOŃSKA BIO 70 g - ECOBLIK |
Eden BIO |
P |
0 |
1787 |
HERBATA ZIELONA MATCHA BIO 100 g - BIO PLANET SUPERFOODS |
Eden BIO |
P |
0 |
2105 |
HERBATA ZIELONA RÓWNOWAGA (GREEN BALANCE) BIO (17 x 1,8 g) 30,6 g - YOGI TEA |
Eden BIO |
P |
0 |
2133 |
HERBATA ZIELONA SENCHA BIO (20 x 1,5 g) 30 g - LEBENSBAUM |
Eden BIO |
P |
0 |
2125 |
HERBATA ZIELONA Z CYTRYNĄ I MATCHĄ (GREEN TEA MATCHA LEMON) BIO (17 x 1,8 g) 30,6 g - YOGI TEA |
Eden BIO |
P |
0 |
2092 |
HERBATKA CZEKOLADOWA Z KAKAO (CHOCO) BIO (17 x 2,2 g) 37,4 g - YOGI TEA |
Eden BIO |
P |
0 |
2093 |
HERBATKA DETOX BIO (17 x 1,8 g) 30,6 g - YOGI TEA |
Eden BIO |
P |
0 |
2046 |
HERBATKA DLA DZIECI - DZIKA RÓŻA, MELISA I ROKITNIK BIO (20 x 1,5 g) 30 g - APOTHEKE |
Eden BIO |
P |
0 |
2045 |
HERBATKA DLA DZIECI - KOPER WŁOSKI BIO (20 x 1,5 g) 30 g - APOTHEKE |
Eden BIO |
P |
0 |
2044 |
HERBATKA DLA DZIECI - KOPER WŁOSKI, MELISA I MIĘTA BIO (20 x 1,5 g) 30 g - APOTHEKE |
Eden BIO |
P |
0 |