[ DB ] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=vtijian2021;charset=utf8
[ 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.003206s ]
[ 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.000372s ]
[ 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.000475s ]
[ 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.011495s ]
[ 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.002753s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000833s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3538 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.000751s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3859 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 419 LIMIT 1 [ RunTime:0.000141s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3858 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1404 LIMIT 1 [ RunTime:0.000139s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3857 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000134s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3856 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 142 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3555 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3855 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000134s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000131s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 387 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 124 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1307 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 2555 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2187 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1556 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.000728s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = 'jura2ogpipggbckua6efl3chv3' LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000680s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `is_show` = 1 AND `area_code` = '0000' ORDER BY `count` desc,`id` desc LIMIT 5 [ RunTime:0.001202s ]
[ 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 [ RunTime:0.002711s ]
[ 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 group by a.hid order by a.weight desc , a.hid desc LIMIT 0,10 [ RunTime:0.010559s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 621 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000276s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 387 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 124 LIMIT 1 [ RunTime:0.000135s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1307 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 2555 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1186 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 810 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1164 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 733 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2313 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 685 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1165 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 680 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 962 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000242s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 220 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2177 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 876 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 220 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2178 LIMIT 1 [ RunTime:0.000131s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 872 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.000737s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 621 AND `type` = 'tijian_level' [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 3852 AND `type` = 'tijian_level' [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 2555 AND `type` = 'tijian_level' [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 810 AND `type` = 'tijian_level' [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 733 AND `type` = 'tijian_level' [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 685 AND `type` = 'tijian_level' [ RunTime:0.000187s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 680 AND `type` = 'tijian_level' [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 962 AND `type` = 'tijian_level' [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 876 AND `type` = 'tijian_level' [ RunTime:0.000193s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 872 AND `type` = 'tijian_level' [ RunTime:0.000172s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000217s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000153s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000137s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000161s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '3852' and status = 2 [ RunTime:0.000138s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '3852' and status = 2 [ RunTime:0.000147s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '3852' and status = 2 [ RunTime:0.000144s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '3852' and status = 2 [ RunTime:0.000126s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '2555' and status = 2 [ RunTime:0.000127s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '2555' and status = 2 [ RunTime:0.000153s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '2555' and status = 2 [ RunTime:0.000127s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '2555' and status = 2 [ RunTime:0.000140s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '810' and status = 2 [ RunTime:0.000144s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '810' and status = 2 [ RunTime:0.000126s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '810' and status = 2 [ RunTime:0.000122s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '810' and status = 2 [ RunTime:0.000147s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '733' and status = 2 [ RunTime:0.000143s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '733' and status = 2 [ RunTime:0.000141s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '733' and status = 2 [ RunTime:0.000146s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '733' and status = 2 [ RunTime:0.000131s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '685' and status = 2 [ RunTime:0.000128s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '685' and status = 2 [ RunTime:0.000156s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '685' and status = 2 [ RunTime:0.000137s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '685' and status = 2 [ RunTime:0.000125s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '680' and status = 2 [ RunTime:0.000149s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '680' and status = 2 [ RunTime:0.000139s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '680' and status = 2 [ RunTime:0.000126s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '680' and status = 2 [ RunTime:0.000124s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '962' and status = 2 [ RunTime:0.000139s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '876' and status = 2 [ RunTime:0.000127s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '876' and status = 2 [ RunTime:0.000136s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '876' and status = 2 [ RunTime:0.000144s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '876' and status = 2 [ RunTime:0.000128s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '872' and status = 2 [ RunTime:0.010782s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '872' and status = 2 [ RunTime:0.000152s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '872' and status = 2 [ RunTime:0.000139s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '872' and status = 2 [ RunTime:0.000140s ]
[ 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 = '621' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000361s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 621 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000263s ]
[ 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 = '3852' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000263s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000209s ]
[ 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 = '2555' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000282s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 2555 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000227s ]
[ 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 = '810' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000280s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 810 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000227s ]
[ 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 = '733' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000268s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 733 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000214s ]
[ 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 = '685' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000232s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 685 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000199s ]
[ 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 = '680' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000254s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 680 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000224s ]
[ 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 = '962' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000243s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 962 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000196s ]
[ 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 = '876' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000221s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 876 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000194s ]
[ 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 = '872' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000280s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 872 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000230s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.001012s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_service' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000221s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000129s ]
[ 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 order by a.weight desc , a.add_time desc limit 5 [ RunTime:0.003120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2314 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 151 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000257s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000145s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 309 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.010569s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1174 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 181 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000141s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2314 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 152 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000243s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1403 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 308 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000222s ]
[ 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 order by a.weight desc , a.add_time desc limit 5 [ RunTime:0.002958s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2314 LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 151 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 309 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000303s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1174 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 181 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 384 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 154 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 234 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2314 LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 152 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000320s ]
[ 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 5 [ RunTime:0.004583s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000220s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3538 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3859 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.010503s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 419 LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3858 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1404 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3857 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000147s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3856 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 142 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3555 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3855 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_cat` [ RunTime:0.000836s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000229s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000242s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000231s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000231s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000229s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000236s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000142s ]
[ 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.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) [ RunTime:0.002046s ]
[ 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) order by a.weight desc , a.publish_time desc limit 0,10 [ RunTime:0.002191s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.011379s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000240s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000257s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000200s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000174s ]
[ 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.000172s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 50 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000188s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000236s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000236s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000213s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000259s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000259s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000234s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000209s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000209s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 23 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000196s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000216s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.000215s ]
[ 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.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) [ RunTime:0.022132s ]
[ 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) order by a.add_time desc limit 0,10 [ RunTime:0.025881s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 50 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000165s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.001116s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000816s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000772s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000702s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000179s ]
[ 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.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 23 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000729s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000164s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000665s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.000147s ]
[ 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.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) [ RunTime:0.011151s ]
[ 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) order by a.click desc limit 0,10 [ RunTime:0.018568s ]
[ 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.000794s ]