[ DB ] CONNECT:[ UseTime:0.000491s ] mysql:host=127.0.0.1;port=3306;dbname=vtijian2021;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.000882s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.000349s ]
[ SQL ] select hid,name,alias_name from ebx_hospital as a where
a.status = '1' and a.is_show = 1 and a.is_hot = 1 order by a.weight desc , add_time desc limit 20 [ RunTime:0.002981s ]
[ SQL ] select link_id,link_name,link_url,target from ebx_friend_link where 1 = 1 AND is_show = 1 AND ( province = 0 and city=0) order by `orderby` desc limit 50 [ RunTime:0.000312s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region` where 1 = 1 AND is_hot = 1 and area_code is not null order by weight desc limit 100 [ RunTime:0.000410s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region` where 1 = 1 AND is_hot = 1 and area_code is not null order by weight desc limit 50 [ RunTime:0.000377s ]
[ SQL ] select a.hid , a.name , a.alias_name ,a.logo , a.thum ,a.province ,a.city , a.region ,a.meal_num ,a.yuyue_num,a.score from ebx_hospital as a
where a.status = 1 and a.is_show = 1 order by a.add_time desc limit 10 [ RunTime:0.002425s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000710s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3538 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.000690s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3859 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 419 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3858 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000115s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1404 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3857 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3856 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 142 LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3555 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3855 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 387 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 124 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1307 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 2555 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000115s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2187 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1556 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.000655s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = 'ocucpel9kms2idja4lutnrhoh6' LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000646s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `is_show` = 1 AND `area_code` = '0000' ORDER BY `count` desc,`id` desc LIMIT 5 [ RunTime:0.001158s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `keyword` = '爱康' AND `area_code` = '0000' LIMIT 1 [ RunTime:0.000540s ]
[ SQL ] UPDATE `ebx_search_keywords` SET `count`=`count`+1 WHERE `keyword` = '爱康' AND `area_code` = '0000' [ RunTime:0.000679s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` IS NULL LIMIT 1 [ RunTime:0.000478s ]
[ 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 (a.city = 3 OR province = 3) AND( a.name LIKE '%爱康%' ) [ RunTime:0.003052s ]
[ 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 ,( CASE WHEN LOCATE( '爱康', a.name ) != 0 THEN 1 ELSE 0 END ) AS Index0 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 (a.city = 3 OR province = 3) AND( a.name LIKE '%爱康%' ) group by a.hid order by (Index0) DESC , hid DESC LIMIT 0,5 [ RunTime:0.004564s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` IS NULL LIMIT 1 [ RunTime:0.000263s ]
[ 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 a.STATUS = 1 AND a.is_upper = 1 AND (b.city = 3 OR province = 3 ) AND( a.name LIKE '%爱康%' ) [ RunTime:0.003317s ]
[ SQL ] select a.tid ,a.hid ,a.name , a.y_price,a.j_price,a.w_price,a.thum,a.sex,a.virtual_sell,
a.add_time ,a.extra,a.description,a.yuyue_count
,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 Index0 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 a.STATUS = 1 AND a.is_upper = 1 AND (b.city = 3 OR province = 3 ) AND( a.name LIKE '%爱康%' ) GROUP BY a.tid order by (Index0) DESC , a.yuyue_count desc , a.tid desc LIMIT 0,6 [ RunTime:0.003858s ]
[ SQL ] select a.hid , a.name , a.alias_name ,a.logo , a.thum ,a.province ,a.city , a.region ,a.meal_num ,a.yuyue_num,a.score from ebx_hospital as a
where a.status = 1 and a.is_show = 1 and is_recommend = 1 order by a.weight desc , a.add_time desc limit 6 [ RunTime:0.002287s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 621 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 387 LIMIT 1 [ RunTime:0.000115s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1186 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 810 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2313 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 685 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1165 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 680 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 962 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000183s ]
