MySQL optimizer_trace

最新推荐文章于 2024-06-16 05:34:45 发布

blackcat王文俊

最新推荐文章于 2024-06-16 05:34:45 发布

阅读量160

点赞数

分类专栏：开发工具文章标签： mysql 数据库

本文链接：https://blog.csdn.net/blackcat123/article/details/127998980

版权

开发工具专栏收录该内容

16 篇文章 0 订阅

订阅专栏

set optimizer_trace='enabled=on',end_markers_in_json=on;

select
	ipkrl.log_id,
	ipkrl.create_time,
	ipkrl.app_from,
	ipkrl.phone,
	ipkrl.real_name,
	ipkrl.sex,
	ipkrl.age,
	ipkrl.`desc`,
	ipkrl.keywords_name,
	ipkrl.department_name,
	ipkrl.is_check,
	group_concat(ihd.doctor_name) as doctor_name_concat,
	group_concat(ihd.phone) as doctor_phone_concat,
	group_concat(ipkrld.is_info) as is_info_concat,
	group_concat(ifnull(ipkrld.info_time, '0')) as info_time_concat,
	group_concat(ipkrld.is_consult) as is_consult_concat,
	group_concat(ifnull(ipkrld.consult_time, '0')) as consult_time_concat,
	group_concat(ipkrld.consult_types) as consult_types_concat,
	group_concat(ifnull(ipkrld.pay_money, '0.00')) as pay_money_concat,	
	group_concat(ipkrld.consult_from) as consult_from_concat,
	
	group_concat(ipkrld.consult_id) as consult_id_concat
from
	ih_platform_keywords_recommend_log ipkrl
left join ih_platform_keywords_recommend_log_doctor ipkrld
on
	ipkrl.log_id = ipkrld.log_id
left join ih_doctor ihd on
	ipkrld.doctor_id = ihd.doctor_id
where
	ipkrl.create_time>=1668708866
group by
	ipkrl.log_id
order by ipkrl.log_id desc;

select TRACE from information_schema.optimizer_trace