[ DB ] CONNECT:[ UseTime:0.000567s ] mysql:host=127.0.0.1;port=3306;dbname=vtijian2021;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.000881s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.000382s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000656s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000249s ]
[ 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 AND a.city = '236' order by a.weight desc , add_time desc limit 20 [ RunTime:0.002646s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] select link_id,link_name,link_url,target from ebx_friend_link where 1 = 1 AND is_show = 1 AND ( city = '236') order by `orderby` desc limit 50 [ RunTime:0.000228s ]
[ 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.000414s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region`
where 1 = 1 and id !=236 and parent_id = '19' and area_code is not null order by weight desc limit 50 [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000146s ]
[ 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 a.city = '236' order by a.add_time desc limit 10 [ RunTime:0.002337s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000135s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.000779s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000147s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000121s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1469 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3524 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1322 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1225 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1146 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 644 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 643 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region`
where 1 = 1 AND parent_id = '236' order by weight desc limit 50 [ RunTime:0.000248s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.000616s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = '6mi04a6au1lfke3st4s53ju173' LIMIT 1 [ RunTime:0.000167s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000571s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `is_show` = 1 AND `area_code` = '0755' ORDER BY `count` desc,`id` desc LIMIT 5 [ RunTime:0.001150s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] select count(DISTINCT a.hid) as c from ebx_hospital as a where 1 = 1 AND a.status = 1 and a.is_show = 1 AND a.hid in ( select DISTINCT hid from ebx_hospital_tags as b where b.`tag_id` = '4' and b.type = 'tijian_level' ) AND a.city = '236' [ RunTime:0.000831s ]
[ 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
from ebx_hospital as a where 1 = 1 AND a.status = 1 and a.is_show = 1 AND a.hid in ( select DISTINCT hid from ebx_hospital_tags as b where b.`tag_id` = '4' and b.type = 'tijian_level' ) AND a.city = '236' group by a.hid order by a.weight desc , a.hid desc LIMIT 0,10 [ RunTime:0.000959s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 643 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 60 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 59 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2337 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 58 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2337 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 53 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 643 AND `type` = 'tijian_level' [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 60 AND `type` = 'tijian_level' [ RunTime:0.000194s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 59 AND `type` = 'tijian_level' [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 58 AND `type` = 'tijian_level' [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 53 AND `type` = 'tijian_level' [ RunTime:0.000193s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '643' and status = 2 [ RunTime:0.000396s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '643' and status = 2 [ RunTime:0.000180s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '643' and status = 2 [ RunTime:0.000195s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '643' and status = 2 [ RunTime:0.000154s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '60' and status = 2 [ RunTime:0.000123s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '59' and status = 2 [ RunTime:0.000114s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '58' and status = 2 [ RunTime:0.000131s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '53' and status = 2 [ RunTime:0.000112s ]
[ 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.extra,a.description ,
a.yuyue_count , a.buy_count ,b.name as h_name , b.alias_name as h_alias_name
from ebx_hospital_meal as a left join ebx_hospital as b on
a.hid = b.hid
where a.status = 1 and a.is_upper = 1 and a.hid = '643' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000251s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 643 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000201s ]
[ 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.extra,a.description ,
a.yuyue_count , a.buy_count ,b.name as h_name , b.alias_name as h_alias_name
from ebx_hospital_meal as a left join ebx_hospital as b on
a.hid = b.hid
where a.status = 1 and a.is_upper = 1 and a.hid = '60' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000216s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 60 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000152s ]
[ 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.extra,a.description ,
a.yuyue_count , a.buy_count ,b.name as h_name , b.alias_name as h_alias_name
from ebx_hospital_meal as a left join ebx_hospital as b on
a.hid = b.hid
where a.status = 1 and a.is_upper = 1 and a.hid = '59' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000212s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 59 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000149s ]
[ 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.extra,a.description ,
a.yuyue_count , a.buy_count ,b.name as h_name , b.alias_name as h_alias_name
from ebx_hospital_meal as a left join ebx_hospital as b on
a.hid = b.hid
where a.status = 1 and a.is_upper = 1 and a.hid = '58' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000206s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 58 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000151s ]
[ 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.extra,a.description ,
a.yuyue_count , a.buy_count ,b.name as h_name , b.alias_name as h_alias_name
from ebx_hospital_meal as a left join ebx_hospital as b on
a.hid = b.hid
where a.status = 1 and a.is_upper = 1 and a.hid = '53' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000203s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 53 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region`
where 1 = 1 AND parent_id = '236' order by weight desc limit 50 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.000594s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000213s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_service' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000209s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `number` = 4 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000147s ]
[ 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 and is_hot = 1 AND a.city = '236' order by a.weight desc , a.add_time desc limit 5 [ RunTime:0.002498s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 117 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000250s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 83 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 81 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 114 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000231s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000121s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 112 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000151s ]
[ 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 a.is_hot = 1 AND a.city = '236' order by a.weight desc , a.add_time desc limit 5 [ RunTime:0.002456s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 117 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 83 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 81 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000121s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 114 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000152s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 112 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000198s ]
[ 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 a.city = '236' order by a.add_time desc limit 5 [ RunTime:0.002435s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000121s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000135s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1469 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000141s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_cat` [ RunTime:0.000696s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000208s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000155s ]
[ SQL ] select count(*) as count 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.cat_id in (21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74) AND region = 0755 [ RunTime:0.002068s ]
[ SQL ] select a.article_id , a.cat_id , a.title ,a.author ,a.come_from ,a.keywords,
a.add_time ,a.introduction ,a.description ,a.click ,a.publish_time,a.thumb ,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.cat_id in (21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74) AND region = 0755 order by a.weight desc , a.publish_time desc limit 0,10 [ RunTime:0.002193s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 50 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000199s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000170s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000170s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000209s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000183s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 23 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000196s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.000155s ]
[ SQL ] select count(*) as count 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.cat_id in (0,17,18,25,32,19,39,40,41,20,42,43,44,45,46,47,48,49,50,21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,23,33,34,24,26,27,28,29,30) AND region = 0755 [ RunTime:0.011403s ]
[ SQL ] select a.article_id , a.cat_id , a.title ,a.author ,a.come_from ,a.keywords,
a.add_time ,a.introduction ,a.description ,a.click ,a.publish_time,a.thumb ,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.cat_id in (0,17,18,25,32,19,39,40,41,20,42,43,44,45,46,47,48,49,50,21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,23,33,34,24,26,27,28,29,30) AND region = 0755 order by a.add_time desc limit 0,10 [ RunTime:0.011448s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000189s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 50 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000206s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000192s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000175s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 23 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.000148s ]
[ SQL ] select count(*) as count 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.cat_id in (0,17,18,25,32,19,39,40,41,20,42,43,44,45,46,47,48,49,50,21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,23,33,34,24,26,27,28,29,30) AND region = 0755 [ RunTime:0.010702s ]
[ SQL ] select a.article_id , a.cat_id , a.title ,a.author ,a.come_from ,a.keywords,
a.add_time ,a.introduction ,a.description ,a.click ,a.publish_time,a.thumb ,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.cat_id in (0,17,18,25,32,19,39,40,41,20,42,43,44,45,46,47,48,49,50,21,35,36,37,38,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,23,33,34,24,26,27,28,29,30) AND region = 0755 order by a.click desc limit 0,10 [ RunTime:0.011164s ]
[ SQL ] select a.t_name ,a.t_submit_date,a.hid ,a.t_sex ,h.name as h_name from ebx_order_goods_physical_person as a left join ebx_hospital as h on a.hid = h.hid
where a.t_name != '' and a.hid > 0 and a.t_sex > 0 order by a.t_submit_date desc limit 10 [ RunTime:0.000897s ]