[ DB ] CONNECT:[ UseTime:0.017166s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.024270s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `keyword` = '检查套餐' AND `area_code` = '0000' AND `type` = 2 AND `kind` = 1 LIMIT 1 [ RunTime:0.025139s ]
[ SQL ] UPDATE `ebx_search_keywords` SET `count`=`count`+1 WHERE `id` = 147 [ RunTime:0.005586s ]
[ SQL ] SHOW COLUMNS FROM `ebx_stop_words` [ RunTime:0.000890s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.000431s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000230s ]
[ SQL ] select count(*) as c from ebx_expert as a where a.is_show = 1 and a.status = 1 and a.kind = 1 AND ( a.name like '%检查%' or a.eid in (
select eid from ebx_expert_hospital as eh where eh.hid in (
select hid from ebx_hospital as hh where (hh.name like '%检查%' or hh.alias_name like '%检查%')
)
group by eh.eid
)or a.name like '%套餐%' or a.eid in (
select eid from ebx_expert_hospital as eh where eh.hid in (
select hid from ebx_hospital as hh where (hh.name like '%套餐%' or hh.alias_name like '%套餐%')
)
group by eh.eid
)) [ RunTime:0.013181s ]
[ SQL ] select a.*,(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 from ebx_expert as a where a.is_show = 1 and a.status = 1 and a.kind = 1 AND ( a.name like '%检查%' or a.eid in (
select eid from ebx_expert_hospital as eh where eh.hid in (
select hid from ebx_hospital as hh where (hh.name like '%检查%' or hh.alias_name like '%检查%')
)
group by eh.eid
)or a.name like '%套餐%' or a.eid in (
select eid from ebx_expert_hospital as eh where eh.hid in (
select hid from ebx_hospital as hh where (hh.name like '%套餐%' or hh.alias_name like '%套餐%')
)
group by eh.eid
)) order by (index_0+index_1) DESC,a.weight desc,a.add_time desc LIMIT 0,2 [ RunTime:0.001037s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000235s ]
[ SQL ] select count(*) as c from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND ( a.title like '%检查%' OR a.title like '%套餐%' ) [ RunTime:0.022099s ]
[ SQL ] select a.article_id,a.cat_id,a.title,a.author,a.come_from,a.keywords,a.introduction,
a.publish_time,a.thumb,a.video_thumb,a.user_id,a.type,a.click,a.virtual_num,a.zan,a.virtual_zan,b.cat_name
from ebx_article as a left join ebx_article_cat as b on a.cat_id = b.cat_id where a.is_open = 1 AND ( a.title like '%检查%' OR a.title like '%套餐%' ) order by a.weight desc , a.publish_time desc LIMIT 0,2 [ RunTime:0.001759s ]
[ SQL ] SHOW COLUMNS FROM `ebx_users` [ RunTime:0.006858s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.010449s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_tags` [ RunTime:0.002785s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 73 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 100 LIMIT 1 [ RunTime:0.001927s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 66 [ RunTime:0.000315s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '73' [ RunTime:0.004374s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '66' [ RunTime:0.000604s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.010994s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000259s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '检查' LIMIT 1 [ RunTime:0.022087s ]
[ SQL ] SELECT * FROM `ebx_stop_words` WHERE `name` = '套餐' LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] select count(DISTINCT a.hid) as c from ebx_hospital as a left join ebx_hospital_tags as b on a.hid = b.hid where a.status = 1 and a.is_show = 1 AND FIND_IN_SET(1,a.kind_str) AND ( a.name like '%检查%' or a.name like '%套餐%' ) [ RunTime:0.013484s ]
[ SQL ] select a.hid,a.name,a.alias_name,a.province,a.city,a.region,a.address,a.logo,a.image_url,a.thum,a.extra,a.lng,a.lat,a.meal_num,a.yuyue_num,a.score,a.comment_num,a.renzheng,a.business_id ,(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 from ebx_hospital as a left join ebx_hospital_tags as b on a.hid = b.hid where a.status = 1 and a.is_show = 1 AND FIND_IN_SET(1,a.kind_str) AND ( a.name like '%检查%' or a.name like '%套餐%' ) group by a.hid order by (index_0+index_1) DESC,a.weight asc,a.hid desc LIMIT 0,2 [ RunTime:0.001014s ]
