{ "query_optimization": { "r_total_time_ms": 0.55945727 }, "query_block": { "select_id": 1, "cost": 73.35705367, "r_loops": 1, "r_total_time_ms": 160.593005, "filesort": { "sort_key": "rand()", "r_loops": 1, "r_total_time_ms": 7.71847674, "r_limit": 8, "r_used_priority_queue": true, "r_output_rows": 9, "r_sort_mode": "sort_key,rowid", "temporary_table": { "nested_loop": [ { "table": { "table_name": "cp", "access_type": "ref", "possible_keys": ["PRIMARY", "id_product", "id_category"], "key": "id_category", "key_length": "4", "used_key_parts": ["id_category"], "ref": ["const"], "loops": 1, "r_loops": 1, "rows": 7323, "r_rows": 7323, "cost": 1.081803775, "r_table_time_ms": 1.592224589, "r_other_time_ms": 0.608072031, "r_engine_stats": { "pages_accessed": 10 }, "filtered": 100, "r_filtered": 100, "using_index": true } }, { "table": { "table_name": "p", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id_product"], "ref": ["a.cp.id_product"], "loops": 7323, "r_loops": 7323, "rows": 1, "r_rows": 0.999044108, "cost": 6.68187532, "r_table_time_ms": 17.87018271, "r_other_time_ms": 0.647724359, "r_engine_stats": { "pages_accessed": 295 }, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "product_attribute_shop", "access_type": "eq_ref", "possible_keys": ["id_product"], "key": "id_product", "key_length": "10", "used_key_parts": ["id_product", "id_shop", "default_on"], "ref": ["a.cp.id_product", "const", "const"], "loops": 7323, "r_loops": 7316, "rows": 1, "r_rows": 0.013121925, "cost": 12.62781148, "r_table_time_ms": 10.70822253, "r_other_time_ms": 0.760816149, "r_engine_stats": { "pages_accessed": 14441 }, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "product_shop", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "8", "used_key_parts": ["id_product", "id_shop"], "ref": ["a.cp.id_product", "const"], "loops": 7323, "r_loops": 7316, "rows": 1, "r_rows": 1, "cost": 6.62944652, "r_table_time_ms": 14.24630415, "r_other_time_ms": 2.088233745, "r_engine_stats": { "pages_accessed": 6 }, "filtered": 100, "r_filtered": 99.91798797, "attached_condition": "product_shop.active = 1 and product_shop.visibility in ('both','catalog')" } }, { "table": { "table_name": "stock", "access_type": "eq_ref", "possible_keys": [ "product_sqlstock", "id_shop", "id_shop_group", "id_product", "id_product_attribute" ], "key": "product_sqlstock", "key_length": "16", "used_key_parts": [ "id_product", "id_product_attribute", "id_shop", "id_shop_group" ], "ref": ["a.cp.id_product", "const", "const", "const"], "loops": 7323, "r_loops": 7310, "rows": 1, "r_rows": 1, "cost": 12.69990108, "r_table_time_ms": 17.2455841, "r_other_time_ms": 1.491814786, "r_engine_stats": { "pages_accessed": 1730 }, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "cl", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "12", "used_key_parts": ["id_category", "id_shop", "id_lang"], "ref": ["a.product_shop.id_category_default", "const", "const"], "loops": 7323, "r_loops": 7310, "r_table_loops": 2433, "rows": 1, "r_rows": 0.99753762, "cost": 6.56636812, "r_table_time_ms": 2.809269668, "r_other_time_ms": 0.239784718, "r_engine_stats": { "pages_accessed": 427 }, "filtered": 100, "r_filtered": 100, "attached_condition": "trigcond(trigcond(product_shop.id_category_default is not null))" } }, { "table": { "table_name": "pl", "access_type": "eq_ref", "possible_keys": ["PRIMARY", "id_lang"], "key": "PRIMARY", "key_length": "12", "used_key_parts": ["id_product", "id_shop", "id_lang"], "ref": ["a.cp.id_product", "const", "const"], "loops": 7323, "r_loops": 7310, "rows": 1, "r_rows": 1, "cost": 7.41751692, "r_table_time_ms": 13.84046625, "r_other_time_ms": 0.605409072, "r_engine_stats": { "pages_accessed": 289 }, "filtered": 100, "r_filtered": 100 } }, { "table": { "table_name": "image_shop", "access_type": "eq_ref", "possible_keys": ["id_product", "id_shop"], "key": "id_product", "key_length": "10", "used_key_parts": ["id_product", "id_shop", "cover"], "ref": ["a.cp.id_product", "const", "const"], "loops": 7323, "r_loops": 7310, "rows": 1, "r_rows": 0.930232558, "cost": 6.419651815, "r_table_time_ms": 13.0142816, "r_other_time_ms": 2.967671859, "r_engine_stats": { "pages_accessed": 10781 }, "filtered": 100, "r_filtered": 100, "using_index": true } }, { "table": { "table_name": "il", "access_type": "eq_ref", "possible_keys": ["PRIMARY", "id_image"], "key": "PRIMARY", "key_length": "8", "used_key_parts": ["id_image", "id_lang"], "ref": ["a.image_shop.id_image", "const"], "loops": 7323, "r_loops": 7310, "r_table_loops": 6800, "rows": 1, "r_rows": 0.930232558, "cost": 6.68187532, "r_table_time_ms": 8.143372466, "r_other_time_ms": 34.55236378, "r_engine_stats": {}, "filtered": 100, "r_filtered": 100, "attached_condition": "trigcond(trigcond(image_shop.id_image is not null))" } }, { "table": { "table_name": "m", "access_type": "eq_ref", "possible_keys": ["PRIMARY"], "key": "PRIMARY", "key_length": "4", "used_key_parts": ["id_manufacturer"], "ref": ["a.p.id_manufacturer"], "loops": 7323, "r_loops": 7310, "r_table_loops": 1298, "rows": 1, "r_rows": 0.982626539, "cost": 6.55080332, "r_table_time_ms": 0.978567979, "r_other_time_ms": 8.418689083, "r_engine_stats": { "pages_accessed": 492 }, "filtered": 100, "r_filtered": 100, "attached_condition": "trigcond(trigcond(p.id_manufacturer is not null))" } } ] } } } }