aping

{
  "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)"
          }
        ]

aping

{
  "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)"
          }
        ]

aping

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,