MySQL optimizer_trace

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