Query time 0.00699
JSON explain
{
"query_block": {
"select_id": 1,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "products",
"access_type": "range",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"rows": 301,
"filtered": 90.50141144,
"index_condition": "products.product_id in (18661,18662,18664,19131,19820,19857,19858,19859,19860,19863,19865,19866,19868,19869,19870,19871,19872,19873,19874,19875,19876,19877,19878,19879,19880,19881,19882,19883,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19895,19896,19897,19898,19899,19900,19901,19902,19903,19904,19905,19906,19907,19908,19909,19910,19911,19912,19913,19914,19915,19916,19917,19923,19925,20065,20087,20088,20089,20090,20091,20092,20093,20094,20154,20155,20159,20486,20488,20489,20490,20491,20492,20576,20700,20701,20702,20703,20704,20705,20706,20707,20708,20723,20724,20725,20726,20727,20728,20910,20911,20912,20913,20914,20915,20917,20954,20955,20956,20957,20958,20959,20971,20972,20973,20974,21078,21102,21103,21272,21653,21654,21655,21656,21657,21658,21659,21660,21661,21662,21663,21664,21665,21666,21667,21668,21669,21670,21672,21673,21674,21675,21676,21677,21678,21679,21680,21681,21682,21683,21684,21685,21686,21687,21688,21689,21690,21691,21692,21693,21694,21695,21696,21697,21698,21699,21700,21701,21702,21703,21704,21705,21706,21707,21708,21709,21710,21711,21712,21713,21714,21715,21716,21717,21718,21719,21720,21721,21722,21723,21724,21725,21726,21727,21728,21729,21730,21731,21732,21733,21734,21735,21736,21737,21738,21739,21740,21741,21742,21743,21744,21745,21746,21748,21749,21885,21886,21887,21888,21889,21892,21923,21924,21925,21926,21927,22118,22277,22669,22994,22995,23288,23375,23376,23377,23378,23379,23380,23410,23411,23514,23894,23895,23896,23897,23898,23899,23900,23901,23902,23986,10425,19867,19918,19919,19920,19921,19922,20487,20511,20678,20699,20722,21533,21890,21891,21893,21894,22039,22040,22041,22119,22120,22121,22122,22201,22202,22203,22204,22205,22206,22207,22208,22209,22210,22211,22212,22213,22214,22215,22218,22238,22368,22369,22487,22488,22489,22996,23284,23285,23286,23287)",
"attached_condition": "products.company_id = 1 and (products.usergroup_ids = '' or find_in_set(0,products.usergroup_ids) or find_in_set(1,products.usergroup_ids)) and products.`status` = 'A'"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["lillyshop_lillyshop.products.product_id"],
"rows": 1,
"filtered": 99.99145508,
"attached_condition": "prices.lower_limit = 1 and prices.price > 0 and prices.usergroup_id in (0,0,1)"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["lillyshop_lillyshop.products.product_id"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["lillyshop_lillyshop.products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "(cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H') and cscart_categories.storefront_id in (0,1)"
}
},
{
"table": {
"table_name": "img_links",
"access_type": "ref",
"possible_keys": ["PRIMARY", "object_id"],
"key": "object_id",
"key_length": "81",
"used_key_parts": ["object_id", "object_type", "type"],
"ref": ["lillyshop_lillyshop.products.product_id", "const", "const"],
"rows": 1,
"filtered": 100,
"index_condition": "img_links.object_id = products.product_id and img_links.object_type = 'product' and img_links.`type` = 'M'",
"attached_condition": "img_links.pair_id > 0"
}
}
]
}
}
Result
| ab__min_price |
ab__max_price |
| 150.00 |
750.00 |