MariaDB [wp]> select * from information_schema.optimizer_trace limit 1\G *************************** 1. row *************************** QUERY: SELECT CASE WHEN p.id IS NULL THEN tr.object_id ELSE p.id END AS product_id, tr.object_id AS parent_product_id, tr.object_id AS effective_product_id, t.term_id as brand_id, t.name AS brand, t.slug as brand_slug, '0' as product_stock, '0' as product_count, MAX(ts.name) as size, MAX(tc.name) as color FROM wp_posts p JOIN wp_term_relationships tr ON (p.id = tr.object_id OR p.post_parent = tr.object_id) AND p.post_type LIKE '%product%' AND p.post_status = 'publish' JOIN wp_term_taxonomy xt ON xt.term_taxonomy_id = tr.term_taxonomy_id AND xt.taxonomy = 'pa_brand_master' JOIN wp_terms t ON t.term_id = xt.term_id LEFT JOIN (SELECT trs.object_id, ts.name FROM wp_term_relationships trs JOIN wp_term_taxonomy xs ON xs.term_taxonomy_id = trs.term_taxonomy_id JOIN wp_terms ts ON ts.term_id = xs.term_id WHERE xs.taxonomy IN ('pa_size', 'pa_megethos', 'pa_noumero')) AS ts ON p.id = ts.object_id LEFT JOIN (SELECT trc.object_id, tc.name FROM wp_term_relationships trc JOIN wp_term_taxonomy xc ON xc.term_taxonomy_id = trc.term_taxonomy_id JOIN wp_terms tc ON tc.term_id = xc.term_id WHERE xc.taxonomy IN ('pa_color', 'pa_chroma', 'pa_colour')) AS tc ON p.id = tc.object_id GROUP BY p.id, tr.object_id, t.term_id, t.name, t.slug ORDER BY p.id, t.slug DESC TRACE: { "steps": [ { "join_preparation": { "select_id": 1, "steps": [ { "derived": { "table": "ts", "select_id": 2, "algorithm": "merged" } }, { "join_preparation": { "select_id": 2, "steps": [ { "expanded_query": "/* select#2 */ select trs.object_id AS object_id,ts.`name` AS `name` from ((wp_term_relationships trs join wp_term_taxonomy xs on(xs.term_taxonomy_id = trs.term_taxonomy_id)) join wp_terms ts on(ts.term_id = xs.term_id)) where xs.taxonomy in ('pa_size','pa_megethos','pa_noumero')" } ] } }, { "derived": { "table": "tc", "select_id": 3, "algorithm": "merged" } }, { "join_preparation": { "select_id": 3, "steps": [ { "expanded_query": "/* select#3 */ select trc.object_id AS object_id,tc.`name` AS `name` from ((wp_term_relationships trc join wp_term_taxonomy xc on(xc.term_taxonomy_id = trc.term_taxonomy_id)) join wp_terms tc on(tc.term_id = xc.term_id)) where xc.taxonomy in ('pa_color','pa_chroma','pa_colour')" } ] } }, { "expanded_query": "/* select#1 */ select case when p.`ID` is null then tr.object_id else p.`ID` end AS product_id,tr.object_id AS parent_product_id,tr.object_id AS effective_product_id,t.term_id AS brand_id,t.`name` AS brand,t.slug AS brand_slug,'0' AS product_stock,'0' AS product_count,max(ts.`name`) AS size,max(tc.`name`) AS color from (((((wp_posts p join wp_term_relationships tr on((p.`ID` = tr.object_id or p.post_parent = tr.object_id) and p.post_type like '%product%' and p.post_status = 'publish')) join wp_term_taxonomy xt on(xt.term_taxonomy_id = tr.term_taxonomy_id and xt.taxonomy = 'pa_brand_master')) join wp_terms t on(t.term_id = xt.term_id)) left join (/* select#2 */ select trs.object_id AS object_id,ts.`name` AS `name` from ((wp_term_relationships trs join wp_term_taxonomy xs on(xs.term_taxonomy_id = trs.term_taxonomy_id)) join wp_terms ts on(ts.term_id = xs.term_id)) where xs.taxonomy in ('pa_size','pa_megethos','pa_noumero')) ts on(p.`ID` = ts.object_id)) left join (/* select#3 */ select trc.object_id AS object_id,tc.`name` AS `name` from ((wp_term_relationships trc join wp_term_taxonomy xc on(xc.term_taxonomy_id = trc.term_taxonomy_id)) join wp_terms tc on(tc.term_id = xc.term_id)) where xc.taxonomy in ('pa_color','pa_chroma','pa_colour')) tc on(p.`ID` = tc.object_id)) group by p.`ID`,tr.object_id,t.term_id,t.`name`,t.slug order by p.`ID`,t.slug desc" } ] } }, { "join_optimization": { "select_id": 1, "steps": [ { "condition_processing": { "condition": "WHERE", "original_condition": "t.term_id = xt.term_id and xt.term_taxonomy_id = tr.term_taxonomy_id and xt.taxonomy = 'pa_brand_master' and (p.`ID` = tr.object_id or p.post_parent = tr.object_id) and p.post_type like '%product%' and p.post_status = 'publish'", "steps": [ { "build_equal_items": { "condition": "ON expr", "attached_to": "tc", "resulting_condition": "xc.taxonomy in ('pa_color','pa_chroma','pa_colour') and multiple equal(p.`ID`, trc.object_id) and multiple equal(tc.term_id, xc.term_id) and multiple equal(xc.term_taxonomy_id, trc.term_taxonomy_id)" } }, { "build_equal_items": { "condition": "ON expr", "attached_to": "ts", "resulting_condition": "xs.taxonomy in ('pa_size','pa_megethos','pa_noumero') and multiple equal(p.`ID`, trs.object_id) and multiple equal(ts.term_id, xs.term_id) and multiple equal(xs.term_taxonomy_id, trs.term_taxonomy_id)" } }, { "transformation": "equality_propagation", "resulting_condition": "xt.taxonomy = 'pa_brand_master' and (multiple equal(p.`ID`, tr.object_id) or multiple equal(p.post_parent, tr.object_id)) and p.post_type like '%product%' and p.post_status = 'publish' and multiple equal(t.term_id, xt.term_id) and multiple equal(xt.term_taxonomy_id, tr.term_taxonomy_id)" }, { "transformation": "constant_propagation", "resulting_condition": "xt.taxonomy = 'pa_brand_master' and (multiple equal(p.`ID`, tr.object_id) or multiple equal(p.post_parent, tr.object_id)) and p.post_type like '%product%' and p.post_status = 'publish' and multiple equal(t.term_id, xt.term_id) and multiple equal(xt.term_taxonomy_id, tr.term_taxonomy_id)" }, { "transformation": "trivial_condition_removal", "resulting_condition": "xt.taxonomy = 'pa_brand_master' and (multiple equal(p.`ID`, tr.object_id) or multiple equal(p.post_parent, tr.object_id)) and p.post_type like '%product%' and p.post_status = 'publish' and multiple equal(t.term_id, xt.term_id) and multiple equal(xt.term_taxonomy_id, tr.term_taxonomy_id)" } ] } }, { "table_dependencies": [ { "table": "p", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [] }, { "table": "tr", "row_may_be_null": false, "map_bit": 1, "depends_on_map_bits": [] }, { "table": "xt", "row_may_be_null": false, "map_bit": 2, "depends_on_map_bits": [] }, { "table": "t", "row_may_be_null": false, "map_bit": 3, "depends_on_map_bits": [] }, { "table": "trs", "row_may_be_null": true, "map_bit": 4, "depends_on_map_bits": ["0"] }, { "table": "xs", "row_may_be_null": true, "map_bit": 6, "depends_on_map_bits": ["0"] }, { "table": "ts", "row_may_be_null": true, "map_bit": 7, "depends_on_map_bits": ["0"] }, { "table": "trc", "row_may_be_null": true, "map_bit": 5, "depends_on_map_bits": ["0", "4", "6", "7"] }, { "table": "xc", "row_may_be_null": true, "map_bit": 8, "depends_on_map_bits": ["0", "4", "6", "7"] }, { "table": "tc", "row_may_be_null": true, "map_bit": 9, "depends_on_map_bits": ["0", "4", "6", "7"] } ] }, { "ref_optimizer_key_uses": [ { "table": "tr", "index": "term_taxonomy_id", "field": "term_taxonomy_id", "equals": "xt.term_taxonomy_id", "null_rejecting": false }, { "table": "xt", "index": "PRIMARY", "field": "term_taxonomy_id", "equals": "tr.term_taxonomy_id", "null_rejecting": false }, { "table": "xt", "index": "term_id_taxonomy", "field": "term_id", "equals": "t.term_id", "null_rejecting": false }, { "table": "xt", "index": "term_id_taxonomy", "field": "taxonomy", "equals": "'pa_brand_master'", "null_rejecting": false }, { "table": "xt", "index": "taxonomy", "field": "taxonomy", "equals": "'pa_brand_master'", "null_rejecting": false }, { "table": "xt", "index": "taxonomy", "field": "term_taxonomy_id", "equals": "tr.term_taxonomy_id", "null_rejecting": false }, { "table": "t", "index": "PRIMARY", "field": "term_id", "equals": "xt.term_id", "null_rejecting": false }, { "table": "trs", "index": "PRIMARY", "field": "object_id", "equals": "p.`ID`", "null_rejecting": false }, { "table": "trs", "index": "PRIMARY", "field": "term_taxonomy_id", "equals": "xs.term_taxonomy_id", "null_rejecting": true }, { "table": "trs", "index": "term_taxonomy_id", "field": "term_taxonomy_id", "equals": "xs.term_taxonomy_id", "null_rejecting": true }, { "table": "trs", "index": "term_taxonomy_id", "field": "object_id", "equals": "p.`ID`", "null_rejecting": false }, { "table": "trc", "index": "PRIMARY", "field": "object_id", "equals": "p.`ID`", "null_rejecting": false }, { "table": "trc", "index": "PRIMARY", "field": "term_taxonomy_id", "equals": "xc.term_taxonomy_id", "null_rejecting": true }, { "table": "trc", "index": "term_taxonomy_id", "field": "term_taxonomy_id", "equals": "xc.term_taxonomy_id", "null_rejecting": true }, { "table": "trc", "index": "term_taxonomy_id", "field": "object_id", "equals": "p.`ID`", "null_rejecting": false }, { "table": "xs", "index": "PRIMARY", "field": "term_taxonomy_id", "equals": "trs.term_taxonomy_id", "null_rejecting": true }, { "table": "xs", "index": "term_id_taxonomy", "field": "term_id", "equals": "ts.term_id", "null_rejecting": true }, { "table": "ts", "index": "PRIMARY", "field": "term_id", "equals": "xs.term_id", "null_rejecting": true }, { "table": "xc", "index": "PRIMARY", "field": "term_taxonomy_id", "equals": "trc.term_taxonomy_id", "null_rejecting": true }, { "table": "xc", "index": "term_id_taxonomy", "field": "term_id", "equals": "tc.term_id", "null_rejecting": true }, { "table": "tc", "index": "PRIMARY", "field": "term_id", "equals": "xc.term_id", "null_rejecting": true } ] }, { "eliminated_tables": [] }, { "rows_estimation": [ { "selectivity_for_indexes": [], "selectivity_for_columns": [], "cond_selectivity": 1 }, { "table": "p", "table_scan": { "rows": 61365, "read_cost": 7.811901345, "read_and_compare_cost": 9.775581345 } }, { "table": "tr", "table_scan": { "rows": 92590, "read_cost": 10.77919407, "read_and_compare_cost": 13.74207407 } }, { "table": "xt", "range_analysis": { "table_scan": { "rows": 6893, "cost": 1.2164746 }, "potential_range_indexes": [ { "index": "PRIMARY", "usable": false, "cause": "not applicable" }, { "index": "term_id_taxonomy", "usable": false, "cause": "not applicable" }, { "index": "taxonomy", "usable": true, "key_parts": ["taxonomy", "term_taxonomy_id"] } ], "best_covering_index_scan": { "index": "term_id_taxonomy", "cost": 1.086984425, "chosen": true }, "setup_range_conditions": [], "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "taxonomy", "ranges": [ "(pa_brand_master) <= (taxonomy) <= (pa_brand_master)" ], "rowid_ordered": true, "using_mrr": false, "index_only": false, "rows": 254, "cost": 0.3342332, "chosen": true } ], "analyzing_roworder_intersect": { "cause": "too few roworder scans" }, "analyzing_index_merge_union": [] }, "group_index_range": { "chosen": false, "cause": "not single_table" }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", "index": "taxonomy", "rows": 254, "ranges": [ "(pa_brand_master) <= (taxonomy) <= (pa_brand_master)" ] }, "rows_for_plan": 254, "cost_for_plan": 0.3342332, "chosen": true } } }, { "table": "xt", "rowid_filters": [ { "key": "taxonomy", "build_cost": 0.036833043, "rows": 254 } ] }, { "selectivity_for_indexes": [ { "index_name": "taxonomy", "selectivity_from_index": 0.036848977 } ], "selectivity_for_columns": [], "cond_selectivity": 0.036848977 }, { "table": "t", "table_scan": { "rows": 1, "read_cost": 0.0109858, "read_and_compare_cost": 0.0110178 } }, { "table": "trs", "table_scan": { "rows": 92590, "read_cost": 10.77919407, "read_and_compare_cost": 13.74207407 } }, { "table": "xs", "range_analysis": { "table_scan": { "rows": 6893, "cost": 1.2164746 }, "potential_range_indexes": [ { "index": "PRIMARY", "usable": false, "cause": "not applicable" }, { "index": "term_id_taxonomy", "usable": false, "cause": "not applicable" }, { "index": "taxonomy", "usable": true, "key_parts": ["taxonomy", "term_taxonomy_id"] } ], "best_covering_index_scan": { "index": "term_id_taxonomy", "cost": 1.086984425, "chosen": true }, "setup_range_conditions": [], "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "taxonomy", "ranges": [ "(pa_megethos) <= (taxonomy) <= (pa_megethos)", "(pa_noumero) <= (taxonomy) <= (pa_noumero)", "(pa_size) <= (taxonomy) <= (pa_size)" ], "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 3, "cost": 0.0111668, "chosen": true } ], "analyzing_roworder_intersect": { "cause": "too few roworder scans" }, "analyzing_index_merge_union": [] }, "group_index_range": { "chosen": false, "cause": "not single_table" }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", "index": "taxonomy", "rows": 3, "ranges": [ "(pa_megethos) <= (taxonomy) <= (pa_megethos)", "(pa_noumero) <= (taxonomy) <= (pa_noumero)", "(pa_size) <= (taxonomy) <= (pa_size)" ] }, "rows_for_plan": 3, "cost_for_plan": 0.0111668, "chosen": true } } }, { "table": "xs", "rowid_filters": [ { "key": "taxonomy", "build_cost": 0.005302389, "rows": 3 } ] }, { "selectivity_for_indexes": [ { "index_name": "taxonomy", "selectivity_from_index": 4.352241e-4 } ], "selectivity_for_columns": [], "cond_selectivity": 4.352241e-4 }, { "table": "ts", "table_scan": { "rows": 1, "read_cost": 0.0109858, "read_and_compare_cost": 0.0110178 } }, { "table": "trc", "table_scan": { "rows": 92590, "read_cost": 10.77919407, "read_and_compare_cost": 13.74207407 } }, { "table": "xc", "range_analysis": { "table_scan": { "rows": 6893, "cost": 1.2164746 }, "potential_range_indexes": [ { "index": "PRIMARY", "usable": false, "cause": "not applicable" }, { "index": "term_id_taxonomy", "usable": false, "cause": "not applicable" }, { "index": "taxonomy", "usable": true, "key_parts": ["taxonomy", "term_taxonomy_id"] } ], "best_covering_index_scan": { "index": "term_id_taxonomy", "cost": 1.086984425, "chosen": true }, "setup_range_conditions": [], "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "taxonomy", "ranges": [ "(pa_chroma) <= (taxonomy) <= (pa_chroma)", "(pa_color) <= (taxonomy) <= (pa_color)", "(pa_colour) <= (taxonomy) <= (pa_colour)" ], "rowid_ordered": false, "using_mrr": false, "index_only": false, "rows": 24, "cost": 0.04923224, "chosen": true } ], "analyzing_roworder_intersect": { "cause": "too few roworder scans" }, "analyzing_index_merge_union": [] }, "group_index_range": { "chosen": false, "cause": "not single_table" }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", "index": "taxonomy", "rows": 24, "ranges": [ "(pa_chroma) <= (taxonomy) <= (pa_chroma)", "(pa_color) <= (taxonomy) <= (pa_color)", "(pa_colour) <= (taxonomy) <= (pa_colour)" ] }, "rows_for_plan": 24, "cost_for_plan": 0.04923224, "chosen": true } } }, { "table": "xc", "rowid_filters": [ { "key": "taxonomy", "build_cost": 0.008045806, "rows": 24 } ] }, { "selectivity_for_indexes": [ { "index_name": "taxonomy", "selectivity_from_index": 0.003481793 } ], "selectivity_for_columns": [], "cond_selectivity": 0.003481793 }, { "table": "tc", "table_scan": { "rows": 1, "read_cost": 0.0109858, "read_and_compare_cost": 0.0110178 } } ] }, { "considered_execution_plans": [ { "plan_prefix": "", "get_costs_for_tables": [ { "best_access_path": { "table": "t", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 0.0110178, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 0.0110178, "uses_join_buffering": false } } }, { "best_access_path": { "table": "xt", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "ref", "index": "term_id_taxonomy", "chosen": false, "cause": "no predicate for first keypart" }, { "access_type": "ref", "index": "taxonomy", "used_range_estimates": true, "rows": 254, "cost": 0.33344208, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 254, "rows_out": 254, "cost": 0.33344208, "uses_join_buffering": false } } }, { "best_access_path": { "table": "p", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan", "rows": 61365, "rows_after_filter": 61365, "rows_out": 61365, "cost": 9.775581345, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 61365, "rows_out": 61365, "cost": 9.775581345, "uses_join_buffering": false } } }, { "best_access_path": { "table": "tr", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan", "rows": 92590, "rows_after_filter": 92590, "rows_out": 92590, "cost": 13.74207407, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 92590, "rows_out": 92590, "cost": 13.74207407, "uses_join_buffering": false } } } ] }, { "plan_prefix": "", "table": "t", "rows_for_plan": 1, "cost_for_plan": 0.0110178, "rest_of_plan": [ { "plan_prefix": "t", "get_costs_for_tables": [ { "best_access_path": { "table": "xt", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "term_id_taxonomy", "rows": 1, "cost": 0.001693605, "chosen": true }, { "access_type": "ref", "index": "taxonomy", "used_range_estimates": true, "rows": 254, "cost": 0.33344208, "chosen": false, "cause": "cost" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.001693605, "uses_join_buffering": false } } }, { "best_access_path": { "table": "p", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan_with_join_cache", "rows": 61365, "rows_after_filter": 61365, "rows_out": 61365, "cost": 15.4743643, "cost_without_join_buffer": 9.775581345, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 61365, "rows_out": 61365, "cost": 15.4743643, "uses_join_buffering": true } } }, { "best_access_path": { "table": "tr", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan_with_join_cache", "rows": 92590, "rows_after_filter": 92590, "rows_out": 92590, "cost": 22.34059788, "cost_without_join_buffer": 13.74207407, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 92590, "rows_out": 92590, "cost": 22.34059788, "uses_join_buffering": true } } } ] }, { "plan_prefix": "t", "table": "xt", "rows_for_plan": 1, "cost_for_plan": 0.012711405, "rest_of_plan": [ { "plan_prefix": "t,xt", "get_costs_for_tables": [ { "best_access_path": { "table": "p", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "scan_with_join_cache", "rows": 61365, "rows_after_filter": 61365, "rows_out": 61365, "cost": 19.20940639, "cost_without_join_buffer": 9.775581345, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 61365, "rows_out": 61365, "cost": 19.20940639, "uses_join_buffering": true } } }, { "best_access_path": { "table": "tr", "plan_details": { "record_count": 1 }, "considered_access_paths": [ { "access_type": "ref", "index": "term_taxonomy_id", "rows": 35, "cost": 0.006779895, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 35, "rows_out": 35, "cost": 0.006779895, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt", "table": "tr", "rows_for_plan": 35, "cost_for_plan": 0.0194913, "rest_of_plan": [ { "plan_prefix": "t,xt,tr", "get_costs_for_tables": [ { "best_access_path": { "table": "p", "plan_details": { "record_count": 35 }, "considered_access_paths": [ { "access_type": "scan_with_join_cache", "rows": 61365, "rows_after_filter": 61365, "rows_out": 61365, "cost": 470.6859311, "cost_without_join_buffer": 317.1056799, "index_only": true, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 61365, "rows_out": 61365, "cost": 470.6859311, "uses_join_buffering": true } } } ] }, { "plan_prefix": "t,xt,tr", "table": "p", "rows_for_plan": 2147775, "cost_for_plan": 470.7054224, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p", "get_costs_for_tables": [ { "best_access_path": { "table": "ts", "plan_details": { "record_count": 2147775 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 21904.29893, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 21904.29893, "uses_join_buffering": true } } }, { "best_access_path": { "table": "xs", "plan_details": { "record_count": 2147775 }, "considered_access_paths": [ { "access_type": "range", "range_index": "taxonomy", "rows": 3, "rows_after_filter": 3, "rows_out": 3, "cost": 13427.03511, "chosen": true } ], "chosen_access_method": { "type": "range", "rows_read": 3, "rows_out": 3, "cost": 13427.03511, "uses_join_buffering": true } } }, { "best_access_path": { "table": "trs", "plan_details": { "record_count": 2147775 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 3122.178056, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 3122.178056, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p", "table": "ts", "rows_for_plan": 2147775, "cost_for_plan": 22375.00436, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts", "get_costs_for_tables": [ { "best_access_path": { "table": "xs", "plan_details": { "record_count": 2147775 }, "considered_access_paths": [ { "access_type": "ref", "index": "term_id_taxonomy", "rows": 1, "cost": 2090.722098, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 3, "rows_after_filter": 3, "rows_out": 1, "cost": 13427.03511, "chosen": false } ], "chosen_access_method": { "type": "ref", "rows_read": 1, "rows_out": 1, "cost": 2090.722098, "uses_join_buffering": false } } }, { "best_access_path": { "table": "trs", "plan_details": { "record_count": 2147775 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 3122.178056, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 3122.178056, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts", "table": "xs", "rows_for_plan": 2147775, "cost_for_plan": 24465.72645, "pushdown_cond_selectivity": 4.352241e-4, "filtered": 0.043522414, "rows_out": 4.352241e-4, "selectivity": 4.352241e-4, "estimated_join_cardinality": 934.7635282, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs", "get_costs_for_tables": [ { "best_access_path": { "table": "trs", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 1.07283869, "chosen": true }, { "access_type": "eq_ref", "index": "term_taxonomy_id", "rows": 1, "cost": 0.965637103, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.965637103, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs", "table": "trs", "rows_for_plan": 934.7635282, "cost_for_plan": 24466.69209, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs,trs", "get_costs_for_tables": [ { "best_access_path": { "table": "tc", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 9.534098519, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 9.534098519, "uses_join_buffering": true } } }, { "best_access_path": { "table": "xc", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 24, "cost": 25.36714714, "chosen": true } ], "chosen_access_method": { "type": "range", "rows_read": 24, "rows_out": 24, "cost": 25.36714714, "uses_join_buffering": true } } }, { "best_access_path": { "table": "trc", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 1.595493022, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 1.595493022, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs", "table": "tc", "rows_for_plan": 934.7635282, "cost_for_plan": 24476.22619, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs,trs,tc", "get_costs_for_tables": [ { "best_access_path": { "table": "xc", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "ref", "index": "term_id_taxonomy", "rows": 1, "cost": 0.977077892, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 1, "cost": 25.36714714, "chosen": false } ], "chosen_access_method": { "type": "ref", "rows_read": 1, "rows_out": 1, "cost": 0.977077892, "uses_join_buffering": false } } }, { "best_access_path": { "table": "trc", "plan_details": { "record_count": 934.7635282 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 1.595493022, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 1.595493022, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs,tc", "table": "xc", "rows_for_plan": 934.7635282, "cost_for_plan": 24477.20327, "pushdown_cond_selectivity": 0.003481793, "filtered": 0.348179312, "rows_out": 0.003481793, "selectivity": 0.003481793, "estimated_join_cardinality": 3.254653225, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs,trs,tc,xc", "get_costs_for_tables": [ { "best_access_path": { "table": "trc", "plan_details": { "record_count": 3.254653225 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 0.005577304, "chosen": true }, { "access_type": "eq_ref", "index": "term_taxonomy_id", "rows": 1, "cost": 0.005512097, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.005512097, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs,tc,xc", "table": "trc", "rows_for_plan": 3.254653225, "cost_for_plan": 24477.20878 } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs,tc", "table": "trc", "rows_for_plan": 3739.054113, "cost_for_plan": 24477.82168, "pruned_by_cost": true, "current_cost": 24477.82168, "best_cost": 24477.20878 } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs", "table": "trc", "rows_for_plan": 3739.054113, "cost_for_plan": 24468.28759, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs,trs,trc", "get_costs_for_tables": [ { "best_access_path": { "table": "xc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 3.423821961, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 1, "cost": 101.4022334, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 3.423821961, "uses_join_buffering": false } } }, { "best_access_path": { "table": "tc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 38.13393648, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 38.13393648, "uses_join_buffering": true } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs,trc", "table": "xc", "rows_for_plan": 3739.054113, "cost_for_plan": 24471.71141, "pushdown_cond_selectivity": 0.003481793, "filtered": 0.348179312, "rows_out": 0.003481793, "selectivity": 0.003481793, "estimated_join_cardinality": 13.0186129, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,ts,xs,trs,trc,xc", "get_costs_for_tables": [ { "best_access_path": { "table": "tc", "plan_details": { "record_count": 13.0186129 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 0.012463568, "chosen": true }, { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 0.133590826, "index_only": false, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.012463568, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs,trc,xc", "table": "tc", "rows_for_plan": 13.0186129, "cost_for_plan": 24471.72387 } ] } ] }, { "plan_prefix": "t,xt,tr,p,ts,xs,trs", "table": "xc", "rows_for_plan": 22434.32468, "cost_for_plan": 24492.05924, "pruned_by_cost": true, "current_cost": 24492.05924, "best_cost": 24471.72387 } ] } ] }, { "plan_prefix": "t,xt,tr,p,ts", "table": "trs", "rows_for_plan": 8591100, "cost_for_plan": 25497.18241, "pruned_by_cost": true, "current_cost": 25497.18241, "best_cost": 24471.72387 } ] }, { "plan_prefix": "t,xt,tr,p", "table": "xs", "rows_for_plan": 6443325, "cost_for_plan": 13897.74053, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,xs", "get_costs_for_tables": [ { "best_access_path": { "table": "ts", "plan_details": { "record_count": 6443325 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 5763.168432, "chosen": true }, { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 65712.89516, "index_only": false, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 5763.168432, "uses_join_buffering": false } } }, { "best_access_path": { "table": "trs", "plan_details": { "record_count": 6443325 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 5763.404362, "chosen": true }, { "access_type": "eq_ref", "index": "term_taxonomy_id", "rows": 1, "cost": 5634.223872, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 5634.223872, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,xs", "table": "trs", "rows_for_plan": 6443325, "cost_for_plan": 19531.9644, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,xs,trs", "get_costs_for_tables": [ { "best_access_path": { "table": "ts", "plan_details": { "record_count": 6443325 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 5763.168432, "chosen": true }, { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 65712.89516, "index_only": false, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 5763.168432, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,xs,trs", "table": "ts", "rows_for_plan": 6443325, "cost_for_plan": 25295.13283, "pruned_by_cost": true, "current_cost": 25295.13283, "best_cost": 24471.72387 } ] } ] }, { "plan_prefix": "t,xt,tr,p", "table": "trs", "rows_for_plan": 8591100, "cost_for_plan": 3592.883478, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs", "get_costs_for_tables": [ { "best_access_path": { "table": "ts", "plan_details": { "record_count": 8591100 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 87617.19328, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 87617.19328, "uses_join_buffering": true } } }, { "best_access_path": { "table": "xs", "plan_details": { "record_count": 8591100 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 7684.302946, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 3, "rows_after_filter": 3, "rows_out": 1, "cost": 53708.12568, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 7684.302946, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs", "table": "xs", "rows_for_plan": 8591100, "cost_for_plan": 11277.18642, "pushdown_cond_selectivity": 4.352241e-4, "filtered": 0.043522414, "rows_out": 4.352241e-4, "selectivity": 4.352241e-4, "estimated_join_cardinality": 3739.054113, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs", "get_costs_for_tables": [ { "best_access_path": { "table": "ts", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 3.345178761, "chosen": true }, { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 38.13393648, "index_only": false, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 3.345178761, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs", "table": "ts", "rows_for_plan": 3739.054113, "cost_for_plan": 11280.5316, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs,ts", "get_costs_for_tables": [ { "best_access_path": { "table": "tc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 38.13393648, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 38.13393648, "uses_join_buffering": true } } }, { "best_access_path": { "table": "xc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 24, "cost": 101.4022334, "chosen": true } ], "chosen_access_method": { "type": "range", "rows_read": 24, "rows_out": 24, "cost": 101.4022334, "uses_join_buffering": true } } }, { "best_access_path": { "table": "trc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 5.671725687, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 5.671725687, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts", "table": "tc", "rows_for_plan": 3739.054113, "cost_for_plan": 11318.66554, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs,ts,tc", "get_costs_for_tables": [ { "best_access_path": { "table": "xc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "ref", "index": "term_id_taxonomy", "rows": 1, "cost": 3.706788369, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 1, "cost": 101.4022334, "chosen": false } ], "chosen_access_method": { "type": "ref", "rows_read": 1, "rows_out": 1, "cost": 3.706788369, "uses_join_buffering": false } } }, { "best_access_path": { "table": "trc", "plan_details": { "record_count": 3739.054113 }, "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "rows": 4, "cost": 5.671725687, "chosen": true }, { "access_type": "ref", "index": "term_taxonomy_id", "chosen": false, "cause": "no predicate for first keypart" }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "ref", "rows_read": 4, "rows_out": 4, "cost": 5.671725687, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts,tc", "table": "xc", "rows_for_plan": 3739.054113, "cost_for_plan": 11322.37233, "pushdown_cond_selectivity": 0.003481793, "filtered": 0.348179312, "rows_out": 0.003481793, "selectivity": 0.003481793, "estimated_join_cardinality": 13.0186129, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs,ts,tc,xc", "get_costs_for_tables": [ { "best_access_path": { "table": "trc", "plan_details": { "record_count": 13.0186129 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 0.022309216, "chosen": true }, { "access_type": "eq_ref", "index": "term_taxonomy_id", "rows": 1, "cost": 0.022048388, "chosen": true }, { "type": "scan", "chosen": false, "cause": "cost" } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.022048388, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts,tc,xc", "table": "trc", "rows_for_plan": 13.0186129, "cost_for_plan": 11322.39438 } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts,tc", "table": "trc", "rows_for_plan": 14956.21645, "cost_for_plan": 11324.33727, "pruned_by_cost": true, "current_cost": 11324.33727, "best_cost": 11322.39438 } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts", "table": "trc", "rows_for_plan": 14956.21645, "cost_for_plan": 11286.20333, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs,ts,trc", "get_costs_for_tables": [ { "best_access_path": { "table": "xc", "plan_details": { "record_count": 14956.21645 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 13.45690064, "chosen": true }, { "access_type": "range", "range_index": "taxonomy", "rows": 24, "rows_after_filter": 24, "rows_out": 1, "cost": 405.5425783, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 13.45690064, "uses_join_buffering": false } } }, { "best_access_path": { "table": "tc", "plan_details": { "record_count": 14956.21645 }, "considered_access_paths": [ { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 152.5332883, "index_only": false, "chosen": true } ], "chosen_access_method": { "type": "scan", "rows_read": 1, "rows_out": 1, "cost": 152.5332883, "uses_join_buffering": true } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts,trc", "table": "xc", "rows_for_plan": 14956.21645, "cost_for_plan": 11299.66023, "pushdown_cond_selectivity": 0.003481793, "filtered": 0.348179312, "rows_out": 0.003481793, "selectivity": 0.003481793, "estimated_join_cardinality": 52.07445159, "rest_of_plan": [ { "plan_prefix": "t,xt,tr,p,trs,xs,ts,trc,xc", "get_costs_for_tables": [ { "best_access_path": { "table": "tc", "plan_details": { "record_count": 52.07445159 }, "considered_access_paths": [ { "access_type": "eq_ref", "index": "PRIMARY", "rows": 1, "cost": 0.047396672, "chosen": true }, { "access_type": "scan", "rows": 1, "rows_after_filter": 1, "rows_out": 1, "cost": 0.531905702, "index_only": false, "chosen": false } ], "chosen_access_method": { "type": "eq_ref", "rows_read": 1, "rows_out": 1, "cost": 0.047396672, "uses_join_buffering": false } } } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts,trc,xc", "table": "tc", "rows_for_plan": 52.07445159, "cost_for_plan": 11299.70763 } ] } ] }, { "plan_prefix": "t,xt,tr,p,trs,xs,ts", "table": "xc", "rows_for_plan": 89737.29871, "cost_for_plan": 11381.93384, "pruned_by_cost": true, "current_cost": 11381.93384, "best_cost": 11299.70763 } ] } ] } ] } ] } ] }, { "plan_prefix": "t,xt", "table": "p", "rows_for_plan": 61365, "cost_for_plan": 19.2221178, "pruned_by_heuristic": true } ] }, { "plan_prefix": "t", "table": "p", "rows_for_plan": 61365, "cost_for_plan": 15.4853821, "pruned_by_heuristic": true }, { "plan_prefix": "t", "table": "tr", "rows_for_plan": 92590, "cost_for_plan": 22.35161568, "pruned_by_heuristic": true } ] }, { "plan_prefix": "", "table": "xt", "rows_for_plan": 254, "cost_for_plan": 0.33344208, "pruned_by_heuristic": true }, { "plan_prefix": "", "table": "p", "rows_for_plan": 61365, "cost_for_plan": 9.775581345, "pruned_by_heuristic": true }, { "plan_prefix": "", "table": "tr", "rows_for_plan": 92590, "cost_for_plan": 13.74207407, "pruned_by_heuristic": true } ] }, { "best_join_order": [ "t", "xt", "tr", "p", "trs", "xs", "ts", "trc", "xc", "tc" ], "rows": 52.07445159, "cost": 11299.70763 }, { "substitute_best_equal": { "condition": "WHERE", "resulting_condition": "xt.term_id = t.term_id and tr.term_taxonomy_id = xt.term_taxonomy_id and xt.taxonomy = 'pa_brand_master' and (p.`ID` = tr.object_id or p.post_parent = tr.object_id) and p.post_type like '%product%' and p.post_status = 'publish'" } }, { "substitute_best_equal": { "condition": "ON expr", "attached_to": "trs", "resulting_condition": "trs.object_id = p.`ID` and ts.term_id = xs.term_id and xs.term_taxonomy_id = trs.term_taxonomy_id and xs.taxonomy in ('pa_size','pa_megethos','pa_noumero')" } }, { "substitute_best_equal": { "condition": "ON expr", "attached_to": "trc", "resulting_condition": "trc.object_id = p.`ID` and tc.term_id = xc.term_id and xc.term_taxonomy_id = trc.term_taxonomy_id and xc.taxonomy in ('pa_color','pa_chroma','pa_colour')" } }, { "attaching_conditions_to_tables": { "attached_conditions_computation": [ { "table": "p", "range_analysis": { "table_scan": { "rows": 61365, "cost": 12.9983114 }, "potential_range_indexes": [ { "index": "PRIMARY", "usable": true, "key_parts": ["ID"] }, { "index": "post_name", "usable": false, "cause": "not applicable" }, { "index": "post_parent", "usable": true, "key_parts": [ "post_parent", "post_type", "post_status", "ID" ] }, { "index": "type_status_date", "usable": false, "cause": "not applicable" }, { "index": "post_author", "usable": false, "cause": "not applicable" } ], "best_covering_index_scan": { "index": "post_parent", "cost": 9.775581345, "chosen": true }, "setup_range_conditions": [], "analyzing_range_alternatives": { "range_scan_alternatives": [], "analyzing_roworder_intersect": { "cause": "too few roworder scans" }, "analyzing_index_merge_union": [] }, "group_index_range": { "chosen": false, "cause": "not single_table" } } } ], "attached_conditions_summary": [ { "table": "t", "attached_condition": null }, { "table": "xt", "attached_condition": "xt.taxonomy = 'pa_brand_master'" }, { "table": "tr", "attached_condition": null }, { "table": "p", "attached_condition": "(p.`ID` = tr.object_id or p.post_parent = tr.object_id) and p.post_type like '%product%' and p.post_status = 'publish'" }, { "table": "trs", "attached_condition": "trigcond(trs.term_taxonomy_id is not null)" }, { "table": "xs", "attached_condition": "trigcond(xs.taxonomy in ('pa_size','pa_megethos','pa_noumero') and xs.term_id is not null)" }, { "table": "ts", "attached_condition": null }, { "table": "trc", "attached_condition": "trigcond(trc.term_taxonomy_id is not null)" }, { "table": "xc", "attached_condition": "trigcond(xc.taxonomy in ('pa_color','pa_chroma','pa_colour') and xc.term_id is not null)" }, { "table": "tc", "attached_condition": null } ] } }, { "make_join_readinfo": [] } ] } }, { "join_execution": { "select_id": 1, "steps": [] } } ] } MISSING_BYTES_BEYOND_MAX_MEM_SIZE: 0 INSUFFICIENT_PRIVILEGES: 0 1 row in set (0.001 sec)