Created
May 7, 2019 14:21
-
-
Save hulucc/34a19b55811695acf1af10bc79ff3347 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Warning: Using a password on the command line interface can be insecure. | |
+-------+----------------------------------+----------------------------+----------------------------+----------------------------+---------------------------+----------+----------+--------+-----------+---------------------+----------------------------------------------------------------------------------------------------------+--------------------------+-------------+--------------+-------------+---------------------------------------------------------------+-----------------+-----------------+---------------+-----------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------------+-----------+----------------+-----------+-------------------+----+----------------------------------+----------------------------+----------------------------+----------------------------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------+--------+---------------+---------+---------------+----------------------------------+------------+-------------+-----------------+-----------+-----------+ | |
| id | uid | created_at | updated_at | deactivated_at | name | avg_cost | province | city | district | business_hub | address | phone | latitude | longitude | business_id | business_remark | closing_time | opening_time | business_hour | geo_code | server_uid | json_data | openshopid | is_mark_offline | region_id | qualification | server_id | enable_membership | id | uid | created_at | updated_at | deactivated_at | name | description | sub_category | province | city | main_category | logo_id | main_video_id | server_uid | openshopid | shops_count | is_mark_offline | server_id | region_id | | |
+-------+----------------------------------+----------------------------+----------------------------+----------------------------+---------------------------+----------+----------+--------+-----------+---------------------+----------------------------------------------------------------------------------------------------------+--------------------------+-------------+--------------+-------------+---------------------------------------------------------------+-----------------+-----------------+---------------+-----------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------------+-----------+----------------+-----------+-------------------+----+----------------------------------+----------------------------+----------------------------+----------------------------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------+--------+---------------+---------+---------------+----------------------------------+------------+-------------+-----------------+-----------+-----------+ | |
| 3 | 3be1a75728414aa7be72276205bd826e | 2018-09-28 11:39:35.968938 | 2019-04-16 18:22:18.552820 | 2018-09-28 11:42:16.841373 | (田尚坊商业中心 | 0.00 | 上海 | 上海 | NULL | NULL | 钦州北路226号田尚坊商业中心地下一层B05(星巴克楼下) | 021-64688256,17317582638 | 31.18063600 | 121.41968700 | 1 | 下午13:30至17:00为午休时间,请您合理安排时间 | 23:30:00.000000 | 11:00:00.000000 | 0,1,2,3,4,5,6 | wtw36ur07 | NULL | {} | NULL | 0 | 2 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 1 | 085d746258ca4cd9aa000ea30455d9b6 | 2018-09-26 14:52:58.483434 | 2019-04-16 18:22:18.506982 | 2018-09-28 11:42:19.800608 | (田尚坊商业中心店 | 0.00 | 上海 | 上海 | NULL | NULL | 钦州北路226号田尚坊商业中心地下一层B05(星巴克楼下) | 021-64688256,17317582638 | 31.18063600 | 121.41968700 | 1 | 下午13:30至17:00为午休时间,请您合理安排时间 | 23:30:00.000000 | 11:00:00.000000 | 0,1,2,3,4,5,6 | wtw36ur07 | NULL | {} | NULL | 0 | 2 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 2347 | 74d75adb6c4b4d989d37996d5f730e69 | 2018-09-29 10:56:21.829491 | 2018-09-29 10:56:21.829516 | 2018-09-29 16:15:01.466161 | 明月苑烧肉酒场 | 150.00 | 上海 | 上海 | 徐汇区 | 漕河泾/田林 | 钦州北路226号田尚坊商业中心地下一层B05(星巴克楼下) | 021-64688256 | 31.18059800 | 121.41877400 | 1 | | 23:59:59.999999 | 00:00:00.000000 | | | a29ad01c6c6441a9b89d5622d71cafcf | {} | NULL | 0 | 16 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 6 | 4e260c1ebcd44cf38da099879c060359 | 2018-09-28 13:55:24.595439 | 2019-04-16 18:22:18.579081 | 2018-09-28 13:55:34.563386 | 田尚坊 | 0.00 | 上海 | 上海 | NULL | NULL | 钦州北路226号田尚坊商业中心地下一层B05(星巴克楼下) | 021-64688256,17317582638 | 31.18063600 | 121.41968700 | 1 | 下午13:30至17:00为午休时间,请您合理安排时间 | 23:30:00.000000 | 11:00:00.000000 | 0,1,2,3,4,5,6 | wtw36ur07 | NULL | {} | NULL | 0 | 2 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 4 | e0b275d34f4a4b95badc83a7ad4128f5 | 2018-09-28 11:42:11.877491 | 2019-04-16 18:22:18.561888 | 2018-12-04 16:34:16.563249 | 田尚坊商业中心店 | 0.00 | 上海 | 上海 | 徐汇区 | NULL | 钦州北路226号田尚坊商业中心地下一层B05(星巴克楼下) | 021-64688256,17317582638 | 31.18063600 | 121.41968700 | 1 | 下午13:30至17:00为午休时间,请您合理安排时间 | 23:30:00.000000 | 11:00:00.000000 | 0,1,2,3,4,5,6 | wtw36ur07 | NULL | {} | NULL | 0 | 8 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 25195 | 3b58487f81184f8280389e8364851e90 | 2018-10-26 14:28:42.445704 | 2019-01-23 18:47:12.705195 | 2018-11-02 15:19:43.174032 | 钦州北路226号 | 169.00 | 上海 | 上海 | 徐汇区 | 未知 | 钦州北路226号地下一层 | 17317582638 | 31.17666044 | 121.40850083 | 1 | 周一至周日 | |
11:00-13:30 | |
17:00-23:30 | 23:59:59.999999 | 00:00:00.000000 | | wtw36ueey | NULL | {"categories":["日本菜","日式烧烤/烤肉","美食"],"regions":["徐汇区","漕河泾/田林"],"avg_rating":"4.5","taste":"9.0","decoration":"9.0","service":"9.2"} | -L5d09346RXUQTO94eVHmw | 0 | 8 | {"images": []} | -1 | 0 | 1 | 2a2f2e368fb145f199753d3124c575c6 | 2018-09-26 14:45:07.306367 | 2018-12-04 16:34:16.563401 | 2018-12-04 16:34:16.563249 | 明月苑烧肉酒场 | 来自东京川地道的烧肉料理,特色酒饮,以及宾至如归的日式气氛,带给您非凡的餐饮体验。 | 日本菜 | 上海 | 上海 | 餐饮 | 8 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
| 1679 | 2e3e0d0928d041d9bf924ebc5bb0f974 | 2018-09-29 10:56:13.494715 | 2018-09-29 10:56:13.494739 | 2018-10-11 15:51:27.032642 | Sharana Café&Bakery | 57.00 | 上海 | 上海 | 虹口区 | 海宁路/七浦路 | 溧阳路735号半岛湾时尚创意文化产业园区2幢2106室(地铁四号线,十号线海伦路站) | 021-66078737 | 31.25545300 | 121.48933100 | 2 | | 23:59:59.999999 | 00:00:00.000000 | | | b60294fe6f364ac6acf0c51dd039ee22 | {} | NULL | 0 | 114 | {"images": []} | -1 | 0 | 2 | 0c01c0bd27cd40b6860e517b094ed33b | 2018-09-26 17:42:35.086396 | 2019-04-12 19:23:45.740806 | 2019-04-10 15:39:01.399662 | Sharana Café&Bakery | sharana kitchen是一家由设计师创立,并集专业咖啡,手作美食于一体的味觉工作室,一家可以给人温暖和幸福感的咖啡馆。 | 咖啡厅 | 上海 | 上海 | 餐饮 | 20 | NULL | 7406ff4826764b7e96f5d373babcea54 | NULL | 1 | 0 | 2248 | 2 | | |
| 41577 | ea7ee195007e42369007bc0e8ff73064 | 2018-10-26 14:42:35.756559 | 2019-01-23 18:50:23.417669 | 2018-11-02 15:19:43.174032 | 溧阳路735号 | 55.00 | 上海 | 上海 | 虹口区 | 未知 | 溧阳路735号半岛湾时尚创意文化产业园区2幢2106室 | 021-66078737 | 31.25137415 | 121.47813247 | 2 | 周一至周日 09:00-21:00 | 23:59:59.999999 | 00:00:00.000000 | | wtw3u6nqw | NULL | {"categories":["下午茶","面包甜点","美食"],"regions":["三至喜来登酒店","上海东方明珠广播电视塔","中信泰富申虹广场","四川北路","海伦路地铁站","虹口区","10号线","绿地九龙宾馆","4号线"],"avg_rating":"3.5","taste":"7.4","decoration":"7.5","service":"7.4"} | PfE85hyXR5BJL73NodGpjA | 0 | 110 | {"images": []} | -1 | 0 | 2 | 0c01c0bd27cd40b6860e517b094ed33b | 2018-09-26 17:42:35.086396 | 2019-04-12 19:23:45.740806 | 2019-04-10 15:39:01.399662 | Sharana Café&Bakery | sharana kitchen是一家由设计师创立,并集专业咖啡,手作美食于一体的味觉工作室,一家可以给人温暖和幸福感的咖啡馆。 | 咖啡厅 | 上海 | 上海 | 餐饮 | 20 | NULL | 7406ff4826764b7e96f5d373babcea54 | NULL | 1 | 0 | 2248 | 2 | | |
| 2 | f0b6aa2b029941f0bf0921073e1b18f7 | 2018-09-26 17:54:21.714056 | 2019-04-16 18:22:18.542857 | 2019-04-10 15:39:01.399662 | 溧阳路店 | 0.00 | 上海 | 上海 | 虹口区 | NULL | 溧阳路735号半岛湾时尚创意文化产业园区2幢2106室(地铁四号线,十号线海伦路站) | 021-66078737 | 31.25533100 | 121.48907200 | 2 | | 09:00:00.000000 | 09:00:00.000000 | 0,1,2,3,4,5,6 | wtw3u9cek | NULL | {"share_buy": "https://forseti-media.kezaihui.com/shop_pic/e5f8edec14a343e79505c801da5f4af1.png", "share_join": "https://forseti-media.kezaihui.com/shop_pic/6fbf73c4896c4a1a9b17854b0d758f65.png"} | NULL | 0 | 110 | {"images": []} | -1 | 0 | 2 | 0c01c0bd27cd40b6860e517b094ed33b | 2018-09-26 17:42:35.086396 | 2019-04-12 19:23:45.740806 | 2019-04-10 15:39:01.399662 | Sharana Café&Bakery | sharana kitchen是一家由设计师创立,并集专业咖啡,手作美食于一体的味觉工作室,一家可以给人温暖和幸福感的咖啡馆。 | 咖啡厅 | 上海 | 上海 | 餐饮 | 20 | NULL | 7406ff4826764b7e96f5d373babcea54 | NULL | 1 | 0 | 2248 | 2 | | |
| 2665 | 0db73411e1054555bfe9b8c42e88f6af | 2018-09-29 10:56:25.744845 | 2018-09-29 10:56:25.744869 | 2018-10-12 16:40:46.870112 | A PEACE OF CAKE | 53.00 | 上海 | 上海 | 杨浦区 | 五角场/大学区 | 江湾城路99号6幢1层108A | 021-65197988 | 31.31651800 | 121.50975200 | 3 | | 23:59:59.999999 | 00:00:00.000000 | | | 6b9300140e4b4457ae37d8d887bf8ddd | {} | NULL | 0 | 120 | {"images": []} | -1 | 0 | 3 | 7cd93ba0c07945eabf8269ef9c03e4f8 | 2018-09-28 13:45:07.225361 | 2019-04-02 11:17:00.250543 | 2019-04-02 11:17:00.250389 | A Peace Of Cake | 纯进口原材料、注重口味、注重品质生活。 | 面包甜点 | 上海 | 上海 | 餐饮 | 30 | NULL | NULL | NULL | 1 | 0 | -1 | 2 | | |
+-------+----------------------------------+----------------------------+----------------------------+----------------------------+---------------------------+----------+----------+--------+-----------+---------------------+----------------------------------------------------------------------------------------------------------+--------------------------+-------------+--------------+-------------+---------------------------------------------------------------+-----------------+-----------------+---------------+-----------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------------+-----------+----------------+-----------+-------------------+----+----------------------------------+----------------------------+----------------------------+----------------------------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------+--------+---------------+---------+---------------+----------------------------------+------------+-------------+-----------------+-----------+-----------+ | |
*************************** 1. row *************************** | |
QUERY: SELECT * | |
FROM business_shop | |
INNER JOIN business_business ON (business_shop.business_id = business_business.id) | |
GROUP BY business_shop.id | |
ORDER BY NULL | |
LIMIT 10 | |
TRACE: { | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `business_shop`.`id` AS `id`,`business_shop`.`uid` AS `uid`,`business_shop`.`created_at` AS `created_at`,`business_shop`.`updated_at` AS `updated_at`,`business_shop`.`deactivated_at` AS `deactivated_at`,`business_shop`.`name` AS `name`,`business_shop`.`avg_cost` AS `avg_cost`,`business_shop`.`province` AS `province`,`business_shop`.`city` AS `city`,`business_shop`.`district` AS `district`,`business_shop`.`business_hub` AS `business_hub`,`business_shop`.`address` AS `address`,`business_shop`.`phone` AS `phone`,`business_shop`.`latitude` AS `latitude`,`business_shop`.`longitude` AS `longitude`,`business_shop`.`business_id` AS `business_id`,`business_shop`.`business_remark` AS `business_remark`,`business_shop`.`closing_time` AS `closing_time`,`business_shop`.`opening_time` AS `opening_time`,`business_shop`.`business_hour` AS `business_hour`,`business_shop`.`geo_code` AS `geo_code`,`business_shop`.`server_uid` AS `server_uid`,`business_shop`.`json_data` AS `json_data`,`business_shop`.`openshopid` AS `openshopid`,`business_shop`.`is_mark_offline` AS `is_mark_offline`,`business_shop`.`region_id` AS `region_id`,`business_shop`.`qualification` AS `qualification`,`business_shop`.`server_id` AS `server_id`,`business_shop`.`enable_membership` AS `enable_membership`,`business_business`.`id` AS `id`,`business_business`.`uid` AS `uid`,`business_business`.`created_at` AS `created_at`,`business_business`.`updated_at` AS `updated_at`,`business_business`.`deactivated_at` AS `deactivated_at`,`business_business`.`name` AS `name`,`business_business`.`description` AS `description`,`business_business`.`sub_category` AS `sub_category`,`business_business`.`province` AS `province`,`business_business`.`city` AS `city`,`business_business`.`main_category` AS `main_category`,`business_business`.`logo_id` AS `logo_id`,`business_business`.`main_video_id` AS `main_video_id`,`business_business`.`server_uid` AS `server_uid`,`business_business`.`openshopid` AS `openshopid`,`business_business`.`shops_count` AS `shops_count`,`business_business`.`is_mark_offline` AS `is_mark_offline`,`business_business`.`server_id` AS `server_id`,`business_business`.`region_id` AS `region_id` from (`business_shop` join `business_business` on((`business_shop`.`business_id` = `business_business`.`id`))) group by `business_shop`.`id` order by NULL limit 10" | |
}, | |
{ | |
"transformations_to_nested_joins": { | |
"transformations": [ | |
"JOIN_condition_to_WHERE", | |
"parenthesis_removal" | |
], | |
"expanded_query": "/* select#1 */ select `business_shop`.`id` AS `id`,`business_shop`.`uid` AS `uid`,`business_shop`.`created_at` AS `created_at`,`business_shop`.`updated_at` AS `updated_at`,`business_shop`.`deactivated_at` AS `deactivated_at`,`business_shop`.`name` AS `name`,`business_shop`.`avg_cost` AS `avg_cost`,`business_shop`.`province` AS `province`,`business_shop`.`city` AS `city`,`business_shop`.`district` AS `district`,`business_shop`.`business_hub` AS `business_hub`,`business_shop`.`address` AS `address`,`business_shop`.`phone` AS `phone`,`business_shop`.`latitude` AS `latitude`,`business_shop`.`longitude` AS `longitude`,`business_shop`.`business_id` AS `business_id`,`business_shop`.`business_remark` AS `business_remark`,`business_shop`.`closing_time` AS `closing_time`,`business_shop`.`opening_time` AS `opening_time`,`business_shop`.`business_hour` AS `business_hour`,`business_shop`.`geo_code` AS `geo_code`,`business_shop`.`server_uid` AS `server_uid`,`business_shop`.`json_data` AS `json_data`,`business_shop`.`openshopid` AS `openshopid`,`business_shop`.`is_mark_offline` AS `is_mark_offline`,`business_shop`.`region_id` AS `region_id`,`business_shop`.`qualification` AS `qualification`,`business_shop`.`server_id` AS `server_id`,`business_shop`.`enable_membership` AS `enable_membership`,`business_business`.`id` AS `id`,`business_business`.`uid` AS `uid`,`business_business`.`created_at` AS `created_at`,`business_business`.`updated_at` AS `updated_at`,`business_business`.`deactivated_at` AS `deactivated_at`,`business_business`.`name` AS `name`,`business_business`.`description` AS `description`,`business_business`.`sub_category` AS `sub_category`,`business_business`.`province` AS `province`,`business_business`.`city` AS `city`,`business_business`.`main_category` AS `main_category`,`business_business`.`logo_id` AS `logo_id`,`business_business`.`main_video_id` AS `main_video_id`,`business_business`.`server_uid` AS `server_uid`,`business_business`.`openshopid` AS `openshopid`,`business_business`.`shops_count` AS `shops_count`,`business_business`.`is_mark_offline` AS `is_mark_offline`,`business_business`.`server_id` AS `server_id`,`business_business`.`region_id` AS `region_id` from `business_shop` join `business_business` where (`business_shop`.`business_id` = `business_business`.`id`) group by `business_shop`.`id` order by NULL limit 10" | |
} | |
} | |
] | |
} | |
}, | |
{ | |
"join_optimization": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"condition_processing": { | |
"condition": "WHERE", | |
"original_condition": "(`business_shop`.`business_id` = `business_business`.`id`)", | |
"steps": [ | |
{ | |
"transformation": "equality_propagation", | |
"resulting_condition": "multiple equal(`business_shop`.`business_id`, `business_business`.`id`)" | |
}, | |
{ | |
"transformation": "constant_propagation", | |
"resulting_condition": "multiple equal(`business_shop`.`business_id`, `business_business`.`id`)" | |
}, | |
{ | |
"transformation": "trivial_condition_removal", | |
"resulting_condition": "multiple equal(`business_shop`.`business_id`, `business_business`.`id`)" | |
} | |
] | |
} | |
}, | |
{ | |
"substitute_generated_columns": { | |
} | |
}, | |
{ | |
"table_dependencies": [ | |
{ | |
"table": "`business_shop`", | |
"row_may_be_null": false, | |
"map_bit": 0, | |
"depends_on_map_bits": [ | |
] | |
}, | |
{ | |
"table": "`business_business`", | |
"row_may_be_null": false, | |
"map_bit": 1, | |
"depends_on_map_bits": [ | |
] | |
} | |
] | |
}, | |
{ | |
"ref_optimizer_key_uses": [ | |
{ | |
"table": "`business_shop`", | |
"field": "business_id", | |
"equals": "`business_business`.`id`", | |
"null_rejecting": false | |
}, | |
{ | |
"table": "`business_business`", | |
"field": "id", | |
"equals": "`business_shop`.`business_id`", | |
"null_rejecting": false | |
} | |
] | |
}, | |
{ | |
"rows_estimation": [ | |
{ | |
"table": "`business_shop`", | |
"const_keys_added": { | |
"keys": [ | |
"PRIMARY", | |
"uid", | |
"business_shop_business_id_name_0136ca11_uniq", | |
"openshopid", | |
"business_shop_deactivated_at_8a673bec", | |
"idx_bs_g", | |
"business_shop_region_id_93d9c427_fk_core_region_id" | |
], | |
"cause": "group_by" | |
}, | |
"range_analysis": { | |
"table_scan": { | |
"rows": 240352, | |
"cost": 26416 | |
}, | |
"potential_range_indexes": [ | |
{ | |
"index": "PRIMARY", | |
"usable": true, | |
"key_parts": [ | |
"id" | |
] | |
}, | |
{ | |
"index": "uid", | |
"usable": true, | |
"key_parts": [ | |
"uid" | |
] | |
}, | |
{ | |
"index": "business_shop_business_id_name_0136ca11_uniq", | |
"usable": true, | |
"key_parts": [ | |
"business_id", | |
"name" | |
] | |
}, | |
{ | |
"index": "openshopid", | |
"usable": true, | |
"key_parts": [ | |
"openshopid" | |
] | |
}, | |
{ | |
"index": "business_shop_deactivated_at_8a673bec", | |
"usable": true, | |
"key_parts": [ | |
"deactivated_at", | |
"id" | |
] | |
}, | |
{ | |
"index": "idx_bs_g", | |
"usable": true, | |
"key_parts": [ | |
"deactivated_at", | |
"geo_code", | |
"id" | |
] | |
}, | |
{ | |
"index": "business_shop_region_id_93d9c427_fk_core_region_id", | |
"usable": true, | |
"key_parts": [ | |
"region_id", | |
"id" | |
] | |
} | |
], | |
"setup_range_conditions": [ | |
], | |
"group_index_range": { | |
"chosen": false, | |
"cause": "not_single_table" | |
}, | |
"skip_scan_range": { | |
"chosen": false, | |
"cause": "not_single_table" | |
} | |
} | |
}, | |
{ | |
"table": "`business_business`", | |
"table_scan": { | |
"rows": 167102, | |
"cost": 505 | |
} | |
} | |
] | |
}, | |
{ | |
"considered_execution_plans": [ | |
{ | |
"plan_prefix": [ | |
], | |
"table": "`business_business`", | |
"best_access_path": { | |
"considered_access_paths": [ | |
{ | |
"access_type": "ref", | |
"index": "PRIMARY", | |
"usable": false, | |
"chosen": false | |
}, | |
{ | |
"rows_to_scan": 167102, | |
"filtering_effect": [ | |
], | |
"final_filtering_effect": 1, | |
"access_type": "scan", | |
"resulting_rows": 167102, | |
"cost": 17215, | |
"chosen": true | |
} | |
] | |
}, | |
"condition_filtering_pct": 100, | |
"rows_for_plan": 167102, | |
"cost_for_plan": 17215, | |
"rest_of_plan": [ | |
{ | |
"plan_prefix": [ | |
"`business_business`" | |
], | |
"table": "`business_shop`", | |
"best_access_path": { | |
"considered_access_paths": [ | |
{ | |
"access_type": "ref", | |
"index": "business_shop_business_id_name_0136ca11_uniq", | |
"rows": 1.4852, | |
"cost": 86862, | |
"chosen": true | |
}, | |
{ | |
"rows_to_scan": 240352, | |
"filtering_effect": [ | |
], | |
"final_filtering_effect": 1, | |
"access_type": "scan", | |
"using_join_cache": true, | |
"buffers_needed": 1565, | |
"resulting_rows": 240352, | |
"cost": 4.02e9, | |
"chosen": false | |
} | |
] | |
}, | |
"condition_filtering_pct": 100, | |
"rows_for_plan": 248177, | |
"cost_for_plan": 104077, | |
"chosen": true | |
} | |
] | |
}, | |
{ | |
"plan_prefix": [ | |
], | |
"table": "`business_shop`", | |
"best_access_path": { | |
"considered_access_paths": [ | |
{ | |
"access_type": "ref", | |
"index": "business_shop_business_id_name_0136ca11_uniq", | |
"usable": false, | |
"chosen": false | |
}, | |
{ | |
"rows_to_scan": 240352, | |
"filtering_effect": [ | |
], | |
"final_filtering_effect": 1, | |
"access_type": "scan", | |
"resulting_rows": 240352, | |
"cost": 26413, | |
"chosen": true | |
} | |
] | |
}, | |
"condition_filtering_pct": 100, | |
"rows_for_plan": 240352, | |
"cost_for_plan": 26413, | |
"rest_of_plan": [ | |
{ | |
"plan_prefix": [ | |
"`business_shop`" | |
], | |
"table": "`business_business`", | |
"best_access_path": { | |
"considered_access_paths": [ | |
{ | |
"access_type": "eq_ref", | |
"index": "PRIMARY", | |
"rows": 1, | |
"cost": 84123, | |
"chosen": true, | |
"cause": "clustered_pk_chosen_by_heuristics" | |
}, | |
{ | |
"rows_to_scan": 167102, | |
"filtering_effect": [ | |
], | |
"final_filtering_effect": 1, | |
"access_type": "scan", | |
"using_join_cache": true, | |
"buffers_needed": 8724, | |
"resulting_rows": 167102, | |
"cost": 4.02e9, | |
"chosen": false | |
} | |
] | |
}, | |
"condition_filtering_pct": 100, | |
"rows_for_plan": 240352, | |
"cost_for_plan": 110537, | |
"pruned_by_cost": true | |
} | |
] | |
} | |
] | |
}, | |
{ | |
"attaching_conditions_to_tables": { | |
"original_condition": "(`business_shop`.`business_id` = `business_business`.`id`)", | |
"attached_conditions_computation": [ | |
], | |
"attached_conditions_summary": [ | |
{ | |
"table": "`business_business`", | |
"attached": null | |
}, | |
{ | |
"table": "`business_shop`", | |
"attached": null | |
} | |
] | |
} | |
}, | |
{ | |
"optimizing_distinct_group_by_order_by": { | |
"simplifying_order_by": { | |
"original_clause": "NULL", | |
"items": [ | |
{ | |
"item": "NULL", | |
"uses_only_constant_tables": true | |
} | |
], | |
"resulting_clause_is_simple": true, | |
"resulting_clause": "" | |
}, | |
"simplifying_group_by": { | |
"original_clause": "`business_shop`.`id`", | |
"items": [ | |
{ | |
"item": "`business_shop`.`id`" | |
} | |
], | |
"resulting_clause_is_simple": false, | |
"resulting_clause": "`business_shop`.`id`" | |
} | |
} | |
}, | |
{ | |
"refine_plan": [ | |
{ | |
"table": "`business_business`" | |
}, | |
{ | |
"table": "`business_shop`" | |
} | |
] | |
}, | |
{ | |
"considering_tmp_tables": [ | |
{ | |
"adding_tmp_table_in_plan_at_position": 2, | |
"write_method": "write_all_rows" | |
} | |
] | |
} | |
] | |
} | |
}, | |
{ | |
"join_execution": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"creating_tmp_table": { | |
"tmp_table_info": { | |
"table": "intermediate_tmp_table", | |
"in_plan_at_position": 2, | |
"columns": 49, | |
"row_length": 11322, | |
"key_length": 4, | |
"unique_constraint": false, | |
"makes_grouped_rows": true, | |
"cannot_insert_duplicates": false, | |
"location": "TempTable" | |
} | |
} | |
} | |
] | |
} | |
} | |
] | |
} | |
MISSING_BYTES_BEYOND_MAX_MEM_SIZE: 0 | |
INSUFFICIENT_PRIVILEGES: 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment