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
{ | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `datayesdb`.`idx_weight`.`SECURITY_ID` AS `SECURITY_ID`,min(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `startDate`,max(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `endDate` from `datayesdb`.`idx_weight` where (`datayesdb`.`idx_weight`.`SECURITY_ID` = 1782)" | |
} | |
] |
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
{ | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `datayesdb`.`idx_weight`.`SECURITY_ID` AS `SECURITY_ID`,min(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `startDate`,max(`datayesdb`.`idx_weight`.`EFF_DATE`) AS `endDate` from `datayesdb`.`idx_weight` where (`datayesdb`.`idx_weight`.`SECURITY_ID` = 26622)" | |
} | |
] |
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
mysql> select * from information_schema.optimizer_trace \G | |
*************************** 1. row *************************** | |
QUERY: explain select u.*, p.nickname, p.avatar, p.background_image_path, p.self_introduction, p.renamed, | |
pw.salt, pw.password, pw.pay_password, | |
r.recommend_user_id, | |
v.name, v.id_number, | |
s.user_id as status_user_id, s.id_verify as status_id_verify, s.redo_id_verify as status_redo_id_verify, | |
s.has_password as status_has_password, s.has_pay_password as status_has_pay_password, | |
s.has_phone as status_has_phone, s.has_email as status_has_email, | |
s.create_time as status_create_time, s.update_time as status_update_time, |