[root@mysql.sock][supplier_new]> 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"
              ],
              "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"
            }
          }
        ]
      }
    },
    {
      "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`))"
                }
              ]
            }
          },
          {
            "substitute_generated_columns": {
            }
          },
          {
            "table_dependencies": [
              {
                "table": "`sp_supplier` `a`",
                "row_may_be_null": false,
                "map_bit": 0,
                "depends_on_map_bits": [
                ]
              },
              {
                "table": "`sp_productline_partner` `b`",
                "row_may_be_null": true,
                "map_bit": 1,
                "depends_on_map_bits": [
                ]
              },
              {
                "table": "`sp_supplier_payinfo` `d`",
                "row_may_be_null": true,
                "map_bit": 2,
                "depends_on_map_bits": [
                  0
                ]
              },
              {
                "table": "`sp_product_line` `c`",
                "row_may_be_null": true,
                "map_bit": 3,
                "depends_on_map_bits": [
                  0,
                  1,
                  2
                ]
              },
              {
                "table": "`sp_supplier_op_log` `e`",
                "row_may_be_null": true,
                "map_bit": 4,
                "depends_on_map_bits": [
                  0,
                  1,
                  2,
                  3
                ]
              },
              {
                "table": "`sp_user_relation` `f`",
                "row_may_be_null": true,
                "map_bit": 5,
                "depends_on_map_bits": [
                  0,
                  1,
                  2,
                  3,
                  4
                ]
              }
            ]
          },
          {
            "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": false
              },
              {
                "table": "`sp_productline_partner` `b`",
                "field": "supplier_code",
                "equals": "`a`.`supplier_code`",
                "null_rejecting": false
              },
              {
                "table": "`sp_supplier_payinfo` `d`",
                "field": "supplier_code",
                "equals": "`a`.`supplier_code`",
                "null_rejecting": false
              },
              {
                "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": false
              },
              {
                "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": false
              },
              {
                "table": "`sp_user_relation` `f`",
                "field": "supplier_code",
                "equals": "`b`.`supplier_code`",
                "null_rejecting": true
              }
            ]
          },
          {
            "rows_estimation": [
              {
                "table": "`sp_supplier` `a`",
                "table_scan": {
                  "rows": 48241,
                  "cost": 2852
                }
              },
              {
                "table": "`sp_productline_partner` `b`",
                "range_analysis": {
                  "table_scan": {
                    "rows": 57782,
                    "cost": 11720
                  },
                  "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"
                      ]
                    },
                    {
                      "index": "sucode",
                      "usable": false,
                      "cause": "not_applicable"
                    }
                  ],
                  "setup_range_conditions": [
                  ],
                  "group_index_range": {
                    "chosen": false,
                    "cause": "not_single_table"
                  },
                  "analyzing_range_alternatives": {
                    "range_scan_alternatives": [
                      {
                        "index": "isdel",
                        "ranges": [
                          "0 <= is_delete <= 0"
                        ],
                        "index_dives_for_eq_ranges": true,
                        "rowid_ordered": true,
                        "using_mrr": false,
                        "index_only": false,
                        "rows": 28891,
                        "cost": 34670,
                        "chosen": false,
                        "cause": "cost"
                      }
                    ],
                    "analyzing_roworder_intersect": {
                      "usable": false,
                      "cause": "too_few_roworder_scans"
                    }
                  }
                }
              },
              {
                "table": "`sp_supplier_payinfo` `d`",
                "table_scan": {
                  "rows": 115099,
                  "cost": 1057
                }
              },
              {
                "table": "`sp_product_line` `c`",
                "table_scan": {
                  "rows": 34,
                  "cost": 1
                }
              },
              {
                "table": "`sp_supplier_op_log` `e`",
                "table_scan": {
                  "rows": 1195843,
                  "cost": 13806
                }
              },
              {
                "table": "`sp_user_relation` `f`",
                "table_scan": {
                  "rows": 1594288,
                  "cost": 4518
                }
              }
            ]
          },
          {
            "considered_execution_plans": [
              {
                "plan_prefix": [
                ],
                "table": "`sp_supplier` `a`",
                "best_access_path": {
                  "considered_access_paths": [
                    {
                      "access_type": "ref",
                      "index": "supplier_code",
                      "usable": false,
                      "chosen": false
                    },
                    {
                      "rows_to_scan": 48241,
                      "access_type": "scan",
                      "resulting_rows": 48241,
                      "cost": 12500,
                      "chosen": true
                    }
                  ]
                },
                "condition_filtering_pct": 100,
                "rows_for_plan": 48241,
                "cost_for_plan": 12500,
                "rest_of_plan": [
                  {
                    "plan_prefix": [
                      "`sp_supplier` `a`"
                    ],
                    "table": "`sp_productline_partner` `b`",
                    "best_access_path |                             23781 |                       0 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+-------------------------+
1 row in set (0.00 sec)

[root@mysql.sock][supplier_new]> SET optimizer_trace="enabled=off";
Query OK, 0 rows affected (0.00 sec)