mysql> SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+-------------------------+ | QUERY | TRACE | MISSING_BYTES_BEYOND_MAX_MEM_SIZE | INSUFFICIENT_PRIVILEGES | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+-------------------------+ | SELECT distinct a.* FROM sp_supplier AS a LEFT JOIN sp_productline_partner AS b on a.supplier_code = b.supplier_code LEFT JOIN sp_supplier_payinfo AS d on d.supplier_code = a.supplier_code LEFT JOIN sp_product_line AS c ON b.productId = c.id LEFT JOIN sp_supplier_op_log AS e on a.supplier_code = e.supplier_code LEFT JOIN sp_user_relation AS f on a.supplier_code = f.supplier_code WHERE b.is_delete = 0 order by a.addtime desc, a.supplier_code desc LIMIT 0, 20 | { "steps": [ { "join_preparation": { "select#": 1, "steps": [ { "expanded_query": "/* select#1 */ select distinct `a`.`id` AS `id`,`a`.`supplier_cate` AS `supplier_cate`,`a`.`supplier_code` AS `supplier_code`,`a`.`supplier_name` AS `supplier_name`,`a`.`supplier_alias` AS `supplier_alias`,`a`.`supplier_source` AS `supplier_source`,`a`.`supplier_degreen` AS `supplier_degreen`,`a`.`supplier_level` AS `supplier_level`,`a`.`supplier_status` AS `supplier_status`,`a`.`product_line` AS `product_line`,`a`.`category_id` AS `category_id`,`a`.`express_currency` AS `express_currency`,`a`.`legalman` AS `legalman`,`a`.`regcapital` AS `regcapital`,`a`.`delivery` AS `delivery`,`a`.`priceadvantage` AS `priceadvantage`,`a`.`linkman` AS `linkman`,`a`.`link_status` AS `link_status`,`a`.`link_province` AS `link_province`,`a`.`link_city` AS `link_city`,`a`.`link_district` AS `link_district`,`a`.`link_address` AS `link_address`,`a`.`tel` AS `tel`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`wechat` AS `wechat`,`a`.`QQ` AS `QQ`,`a`.`aliWW` AS `aliWW`,`a`.`status` AS `status`,`a`.`province` AS `province`,`a`.`city` AS `city`,`a`.`district` AS `district`,`a`.`address` AS `address`,`a`.`shop_link` AS `shop_link`,`a`.`taxpayer_date` AS `taxpayer_date`,`a`.`sku_prefix` AS `sku_prefix`,`a`.`limitmoney` AS `limitmoney`,`a`.`alertmoney` AS `alertmoney`,`a`.`is_signed` AS `is_signed`,`a`.`expired` AS `expired`,`a`.`limitleft` AS `limitleft`,`a`.`is_sendsms` AS `is_sendsms`,`a`.`is_sendemail` AS `is_sendemail`,`a`.`auditor` AS `auditor`,`a`.`audittime` AS `audittime`,`a`.`auditnote` AS `auditnote`,`a`.`note` AS `note`,`a`.`overseaAddr` AS `overseaAddr`,`a`.`is_taxpayer` AS `is_taxpayer`,`a`.`is_brand` AS `is_brand`,`a`.`pur_patterns` AS `pur_patterns`,`a`.`adduser` AS `adduser`,`a`.`addtime` AS `addtime`,`a`.`updateuser` AS `updateuser`,`a`.`updatetime` AS `updatetime`,`a`.`is_delete` AS `is_delete`,`a`.`inspect_time` AS `inspect_time`,`a`.`is_insalert` AS `is_insalert`,`a`.`module_id` AS `module_id`,`a`.`cate_manager` AS `cate_manager`,`a`.`main_manager` AS `main_manager`,`a`.`main_manager_info` AS `main_manager_info`,`a`.`second_manager_info` AS `second_manager_info`,`a`.`pur_status` AS `pur_status`,`a`.`manage_type` AS `manage_type`,`a`.`supplier_shortName` AS `supplier_shortName`,`a`.`is_entry_date` AS `is_entry_date`,`a`.`supplier_data_submitter` AS `supplier_data_submitter`,`a`.`corporatemobile` AS `corporatemobile`,`a`.`supplierStore` AS `supplierStore`,`a`.`oalink` AS `oalink` from (((((`sp_supplier` `a` left join `sp_productline_partner` `b` on((`a`.`supplier_code` = `b`.`supplier_code`))) left join `sp_supplier_payinfo` `d` on((`d`.`supplier_code` = `a`.`supplier_code`))) left join `sp_product_line` `c` on((`b`.`productId` = `c`.`id`))) left join `sp_supplier_op_log` `e` on((`a`.`supplier_code` = `e`.`supplier_code`))) left join `sp_user_relation` `f` on((`a`.`supplier_code` = `f`.`supplier_code`))) where (`b`.`is_delete` = 0) order by `a`.`addtime` desc,`a`.`supplier_code` desc limit 0,20" }, { "transformations_to_nested_joins": { "transformations": [ "outer_join_to_inner_join", "JOIN_condition_to_WHERE", "parenthesis_removal" ] /* transformations */, "expanded_query": "/* select#1 */ select distinct `a`.`id` AS `id`,`a`.`supplier_cate` AS `supplier_cate`,`a`.`supplier_code` AS `supplier_code`,`a`.`supplier_name` AS `supplier_name`,`a`.`supplier_alias` AS `supplier_alias`,`a`.`supplier_source` AS `supplier_source`,`a`.`supplier_degreen` AS `supplier_degreen`,`a`.`supplier_level` AS `supplier_level`,`a`.`supplier_status` AS `supplier_status`,`a`.`product_line` AS `product_line`,`a`.`category_id` AS `category_id`,`a`.`express_currency` AS `express_currency`,`a`.`legalman` AS `legalman`,`a`.`regcapital` AS `regcapital`,`a`.`delivery` AS `delivery`,`a`.`priceadvantage` AS `priceadvantage`,`a`.`linkman` AS `linkman`,`a`.`link_status` AS `link_status`,`a`.`link_province` AS `link_province`,`a`.`link_city` AS `link_city`,`a`.`link_district` AS `link_district`,`a`.`link_address` AS `link_address`,`a`.`tel` AS `tel`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`wechat` AS `wechat`,`a`.`QQ` AS `QQ`,`a`.`aliWW` AS `aliWW`,`a`.`status` AS `status`,`a`.`province` AS `province`,`a`.`city` AS `city`,`a`.`district` AS `district`,`a`.`address` AS `address`,`a`.`shop_link` AS `shop_link`,`a`.`taxpayer_date` AS `taxpayer_date`,`a`.`sku_prefix` AS `sku_prefix`,`a`.`limitmoney` AS `limitmoney`,`a`.`alertmoney` AS `alertmoney`,`a`.`is_signed` AS `is_signed`,`a`.`expired` AS `expired`,`a`.`limitleft` AS `limitleft`,`a`.`is_sendsms` AS `is_sendsms`,`a`.`is_sendemail` AS `is_sendemail`,`a`.`auditor` AS `auditor`,`a`.`audittime` AS `audittime`,`a`.`auditnote` AS `auditnote`,`a`.`note` AS `note`,`a`.`overseaAddr` AS `overseaAddr`,`a`.`is_taxpayer` AS `is_taxpayer`,`a`.`is_brand` AS `is_brand`,`a`.`pur_patterns` AS `pur_patterns`,`a`.`adduser` AS `adduser`,`a`.`addtime` AS `addtime`,`a`.`updateuser` AS `updateuser`,`a`.`updatetime` AS `updatetime`,`a`.`is_delete` AS `is_delete`,`a`.`inspect_time` AS `inspect_time`,`a`.`is_insalert` AS `is_insalert`,`a`.`module_id` AS `module_id`,`a`.`cate_manager` AS `cate_manager`,`a`.`main_manager` AS `main_manager`,`a`.`main_manager_info` AS `main_manager_info`,`a`.`second_manager_info` AS `second_manager_info`,`a`.`pur_status` AS `pur_status`,`a`.`manage_type` AS `manage_type`,`a`.`supplier_shortName` AS `supplier_shortName`,`a`.`is_entry_date` AS `is_entry_date`,`a`.`supplier_data_submitter` AS `supplier_data_submitter`,`a`.`corporatemobile` AS `corporatemobile`,`a`.`supplierStore` AS `supplierStore`,`a`.`oalink` AS `oalink` from `sp_supplier` `a` join `sp_productline_partner` `b` left join `sp_supplier_payinfo` `d` on((`d`.`supplier_code` = `a`.`supplier_code`)) left join `sp_product_line` `c` on((`b`.`productId` = `c`.`id`)) left join `sp_supplier_op_log` `e` on((`a`.`supplier_code` = `e`.`supplier_code`)) left join `sp_user_relation` `f` on((`a`.`supplier_code` = `f`.`supplier_code`)) where ((`b`.`is_delete` = 0) and (`a`.`supplier_code` = `b`.`supplier_code`)) order by `a`.`addtime` desc,`a`.`supplier_code` desc limit 0,20" } /* transformations_to_nested_joins */ } ] /* steps */ } /* join_preparation */ }, { "join_optimization": { "select#": 1, "steps": [ { "condition_processing": { "condition": "WHERE", "original_condition": "((`b`.`is_delete` = 0) and (`a`.`supplier_code` = `b`.`supplier_code`))", "steps": [ { "transformation": "equality_propagation", "resulting_condition": "(multiple equal(0, `b`.`is_delete`) and multiple equal(`a`.`supplier_code`, `b`.`supplier_code`))" }, { "transformation": "constant_propagation", "resulting_condition": "(multiple equal(0, `b`.`is_delete`) and multiple equal(`a`.`supplier_code`, `b`.`supplier_code`))" }, { "transformation": "trivial_condition_removal", "resulting_condition": "(multiple equal(0, `b`.`is_delete`) and multiple equal(`a`.`supplier_code`, `b`.`supplier_code`))" } ] /* steps */ } /* condition_processing */ }, { "substitute_generated_columns": { } /* substitute_generated_columns */ }, { "table_dependencies": [ { "table": "`sp_supplier` `a`", "row_may_be_null": false, "map_bit": 0, "depends_on_map_bits": [ ] /* depends_on_map_bits */ }, { "table": "`sp_productline_partner` `b`", "row_may_be_null": true, "map_bit": 1, "depends_on_map_bits": [ ] /* depends_on_map_bits */ }, { "table": "`sp_supplier_payinfo` `d`", "row_may_be_null": true, "map_bit": 2, "depends_on_map_bits": [ 0 ] /* depends_on_map_bits */ }, { "table": "`sp_product_line` `c`", "row_may_be_null": true, "map_bit": 3, "depends_on_map_bits": [ 0, 1, 2 ] /* depends_on_map_bits */ }, { "table": "`sp_supplier_op_log` `e`", "row_may_be_null": true, "map_bit": 4, "depends_on_map_bits": [ 0, 1, 2, 3 ] /* depends_on_map_bits */ }, { "table": "`sp_user_relation` `f`", "row_may_be_null": true, "map_bit": 5, "depends_on_map_bits": [ 0, 1, 2, 3, 4 ] /* depends_on_map_bits */ } ] /* table_dependencies */ }, { "ref_optimizer_key_uses": [ { "table": "`sp_supplier` `a`", "field": "supplier_code", "equals": "`b`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_productline_partner` `b`", "field": "is_delete", "equals": "0", "null_rejecting": true }, { "table": "`sp_productline_partner` `b`", "field": "supplier_code", "equals": "`a`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_supplier_payinfo` `d`", "field": "supplier_code", "equals": "`a`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_supplier_payinfo` `d`", "field": "supplier_code", "equals": "`b`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_product_line` `c`", "field": "id", "equals": "`b`.`productId`", "null_rejecting": true }, { "table": "`sp_supplier_op_log` `e`", "field": "supplier_code", "equals": "`a`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_supplier_op_log` `e`", "field": "supplier_code", "equals": "`b`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_user_relation` `f`", "field": "supplier_code", "equals": "`a`.`supplier_code`", "null_rejecting": true }, { "table": "`sp_user_relation` `f`", "field": "supplier_code", "equals": "`b`.`supplier_code`", "null_rejecting": true } ] /* ref_optimizer_key_uses */ }, { "rows_estimation": [ { "table": "`sp_supplier` `a`", "table_scan": { "rows": 48331, "cost": 773.902 } /* table_scan */ }, { "table": "`sp_productline_partner` `b`", "range_analysis": { "table_scan": { "rows": 58254, "cost": 5867.75 } /* table_scan */, "potential_range_indexes": [ { "index": "PRIMARY", "usable": false, "cause": "not_applicable" }, { "index": "catid", "usable": false, "cause": "not_applicable" }, { "index": "partnerid", "usable": false, "cause": "not_applicable" }, { "index": "isdel", "usable": true, "key_parts": [ "is_delete", "id" ] /* key_parts */ }, { "index": "sucode", "usable": false, "cause": "not_applicable" } ] /* potential_range_indexes */, "setup_range_conditions": [ ] /* setup_range_conditions */, "group_index_range": { "chosen": false, "cause": "not_single_table" } /* group_index_range */, "analyzing_range_alternatives": { "range_scan_alternatives": [ { "index": "isdel", "ranges": [ "is_delete = 0" ] /* ranges */, "index_dives_for_eq_ranges": true, "rowid_ordered": true, "using_mrr": false, "index_only": false, "in_memory": 1, "rows": 29127, "cost": 10194.7, "chosen": false, "cause": "cost" } ] /* range_scan_alternatives */, "analyzing_roworder_intersect": { "usable": false, "cause": "too_few_roworder_scans" } /* analyzing_roworder_intersect */ } /* analyzing_range_alternatives */ } /* range_analysis */ }, { "table": "`sp_supplier_payinfo` `d`", "table_scan": { "rows": 106688, "cost": 280.25 } /* table_scan */ }, { "table": "`sp_product_line` `c`", "table_scan": { "rows": 34, "cost": 0.25 } /* table_scan */ }, { "table": "`sp_supplier_op_log` `e`", "table_scan": { "rows": 1226746, "cost": 3472.58 } /* table_scan */ }, { "table": "`sp_user_relation` `f`", "table_scan": { "rows": 1594713, "cost": 1177.5 } /* table_scan */ } ] /* rows_estimation */ }, { "considered_execution_plans": [ { "plan_prefix": [ ] /* plan_prefix */, "table": "`sp_supplier` `a`", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "supplier_code | 29640 | 0 | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+-------------------------+ 1 row in set (0.00 sec)