Query time 0.00194
JSON explain
{
"query_block": {
"select_id": 1,
"filesort": {
"temporary_table": {
"function": "buffer",
"table": {
"table_name": "shared_descr",
"access_type": "system",
"possible_keys": ["PRIMARY", "product_id", "company_id"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"table": {
"table_name": "products_categories",
"access_type": "index",
"possible_keys": ["PRIMARY", "pt"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["category_id", "product_id"],
"rows": 13,
"filtered": 100,
"using_index": true
},
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["egkcysbp_cscartn.products_categories.product_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "((prices.lower_limit = 1) and (prices.usergroup_id in (0,0,1)))",
"using_index": true
},
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "status", "idx_parent_product_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["egkcysbp_cscartn.products_categories.product_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "((products.parent_product_id = 0) 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": "descr1",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["egkcysbp_cscartn.products_categories.product_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond((descr1.lang_code = 'en'))"
},
"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": ["egkcysbp_cscartn.products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "((cscart_categories.company_id = 1) and ((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')))"
}
}
}
}
}
Result
product_id |
product |
product_type |
parent_product_id |
297 |
1994 Hyundai Excel Single Cam Auto |
P |
0 |
296 |
2010 Nissan X-Trail Turbo Diesel Auto |
P |
0 |
295 |
1992 Holden Rodeo 4cyl Petrol Auto |
P |
0 |
294 |
2013 Ford Focus Petrol Manual |
P |
0 |
293 |
2003 Mitsubishi Magna TL V6 Auto 228,791kms |
P |
0 |
292 |
2007 Nissan Navara D40 Turbo Diesel Auto |
P |
0 |
291 |
2006 Mitsubishi Lancer CS 4cyl Manual |
P |
0 |
290 |
2012 Holden Captiva |
P |
0 |
289 |
1999 FORD AU XR6 |
P |
0 |
288 |
2005 VZ ADVENTRA |
P |
0 |
286 |
Wrecking 98 Honda Civic Hatch white |
P |
0 |
285 |
HOLDEN CAPTIVA SILVER SUV 07 WRECKING |
P |
0 |