mysql 查看trace_Mysql trace命令介绍

{

"steps": [

{

"join_preparation": { -- 第一阶段：SQL准备阶段

"select#": 1,

"steps": [

{

"expanded_query": "/* select#1 */ select `cr_shop_tables`.`id` AS `id`,`cr_shop_tables`.`title` AS `title`,`cr_shop_tables`.`num` AS `num`,`cr_shop_tables`.`qrcode_pic` AS `qrcode_pic`,`cr_shop_tables`.`sort` AS `sort`,`cr_shop_tables`.`create_time` AS `create_time`,`cr_shop_tables`.`modify_time` AS `modify_time`,`cr_shop_tables`.`shop_id` AS `shop_id`,`cr_shop_tables`.`status` AS `status` from `cr_shop_tables` where (`cr_shop_tables`.`title` > 'a') order by `cr_shop_tables`.`num`"

}

] /* steps */

} /* join_preparation */

},

{

"join_optimization": { ‐‐第二阶段：SQL优化阶段

"select#": 1,

"steps": [

{

"condition_processing": { ‐‐条件处理

"condition&#