[ DB ] CONNECT:[ UseTime:0.000311s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.000963s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.000340s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.001029s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `keyword` = '检查套餐' AND `area_code` = '0000' AND `type` = 2 LIMIT 1 [ RunTime:0.000464s ]
[ SQL ] UPDATE `ebx_search_keywords` SET `count`=`count`+1 WHERE `id` = 147 [ RunTime:0.005407s ]
[ SQL ] SHOW COLUMNS FROM `ebx_stop_words` [ RunTime:0.000916s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid
left join ebx_hospital_tags as c on c.hid = a.tid
where 1 = 1 AND a.status = 1 and a.is_upper = 1 AND ( a.name like '%检查%' or a.tid in (
select tid from ebx_hospital_meal where hid in (
select hid from ebx_hospital as hh where 1 = 1 and (hh.name like '%检查%' or hh.alias_name like '%检查%')
)
) or a.name like '%套餐%' or a.tid in (
select tid from ebx_hospital_meal where hid in (
select hid from ebx_hospital as hh where 1 = 1 and (hh.name like '%套餐%' or hh.alias_name like '%套餐%')
)
) ) [ RunTime:0.000712s ]
[ SQL ] select a.*
,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region
,(CASE WHEN LOCATE( '检查', 'a.name' ) != 0 THEN 1 ELSE 0 END ) AS index_0,(CASE WHEN LOCATE( '套餐', 'a.name' ) != 0 THEN 1 ELSE 0 END ) AS index_1,(CASE WHEN LOCATE( '检查', 'hh.name' ) != 0 THEN 1 ELSE 0 END ) AS s_index_0,(CASE WHEN LOCATE( '套餐', 'hh.name' ) != 0 THEN 1 ELSE 0 END ) AS s_index_1,(CASE WHEN LOCATE( '检查', 'hh.alias_name' ) != 0 THEN 1 ELSE 0 END ) AS t_index_0,(CASE WHEN LOCATE( '套餐', 'hh.alias_name' ) != 0 THEN 1 ELSE 0 END ) AS t_index_1 from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid
left join ebx_hospital_tags as c on c.hid = a.tid
where 1 = 1 AND a.status = 1 and a.is_upper = 1 AND ( a.name like '%检查%' or a.tid in (
select tid from ebx_hospital_meal where hid in (
select hid from ebx_hospital as hh where 1 = 1 and (hh.name like '%检查%' or hh.alias_name like '%检查%')
)
) or a.name like '%套餐%' or a.tid in (
select tid from ebx_hospital_meal where hid in (
select hid from ebx_hospital as hh where 1 = 1 and (hh.name like '%套餐%' or hh.alias_name like '%套餐%')
)
) ) GROUP BY a.tid order by (index_0+index_1+s_index_0+s_index_1+t_index_0+t_index_1) DESC , a.weight desc , a.hid desc LIMIT 0,10 [ RunTime:0.001158s ]
