[ DB ] CONNECT:[ UseTime:0.000238s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000911s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `keyword` = '阳光口腔' AND `area_code` = '0755' AND `type` = 2 LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] UPDATE `ebx_search_keywords` SET `count`=`count`+1 WHERE `id` = 80 [ RunTime:0.003305s ]
[ SQL ] SHOW COLUMNS FROM `ebx_stop_words` [ RunTime:0.001038s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '阳光' LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '口腔' LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '阳光' LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '口腔' LIMIT 1 [ RunTime:0.000238s ]
[ 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 b.city = '236' 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.001424s ]
[ 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 b.city = '236' 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.001788s ]
