ANALYZE
{ "query_optimization": { "r_total_time_ms": 0.689285906 }, "query_block": { "select_id": 1, "cost": 73.56676887, "r_loops": 1, "r_total_time_ms": 7399.13703, "filesort": { "sort_key": "rand()", "r_loops": 1, "r_total_time_ms": 8.375126401, "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": 2.340287376, "r_other_time_ms": 0.995668756, "r_engine_stats": { "pages_accessed": 7 }, "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.73430412, "r_table_time_ms": 1348.353559, "r_other_time_ms": 1.031647497, "r_engine_stats": { "pages_accessed": 158 }, "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": 646.3929169, "r_other_time_ms": 1.235944016, "r_engine_stats": { "pages_accessed": 13894 }, "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.68187532, "r_table_time_ms": 1101.985844, "r_other_time_ms": 2.869869327, "r_engine_stats": {}, "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": 2422.804696, "r_other_time_ms": 2.122015903, "r_engine_stats": { "pages_accessed": 671 }, "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.56554892, "r_table_time_ms": 477.111896, "r_other_time_ms": 0.68155052, "r_engine_stats": { "pages_accessed": 254 }, "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.52237452, "r_table_time_ms": 166.6293354, "r_other_time_ms": 0.724064181, "r_engine_stats": { "pages_accessed": 53 }, "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.420471015, "r_table_time_ms": 808.7361737, "r_other_time_ms": 4.163294724, "r_engine_stats": { "pages_accessed": 6683 }, "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": 248.3060991, "r_other_time_ms": 45.38393891, "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": 95.66198411, "r_other_time_ms": 13.18283341, "r_engine_stats": { "pages_accessed": 366 }, "filtered": 100, "r_filtered": 100, "attached_condition": "trigcond(trigcond(p.id_manufacturer is not null))" } } ] } } } }