[ DB ] CONNECT:[ UseTime:0.116320s ] mysql:host=127.0.0.1;port=3306;dbname=vtijian2021;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.006391s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.001859s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.024309s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000966s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.006738s ]
[ 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.003839s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000908s ]
[ 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.000194s ]
[ 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.002345s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.001152s ]
[ 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.000218s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.001064s ]
[ 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.003460s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.044548s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000144s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.001120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.007917s ]
[ 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.001434s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000327s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000147s ]
[ 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` = 1469 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000156s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.001266s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000177s ]
[ 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.000107s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001826s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3524 LIMIT 1 [ RunTime:0.004796s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1322 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1225 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000200s ]
[ 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.000110s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1146 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001787s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000155s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 644 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000935s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 643 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002789s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.002263s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region`
where 1 = 1 AND parent_id = '236' order by weight desc limit 50 [ RunTime:0.004918s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.029035s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = 'it72311f9kpbfkkqoni16uncp7' LIMIT 1 [ RunTime:0.001538s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.008856s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `is_show` = 1 AND `area_code` = '0755' ORDER BY `count` desc,`id` desc LIMIT 5 [ RunTime:0.012741s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.004111s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.008048s ]
[ 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` = '3' and b.type = 'tijian_level' ) AND a.city = '236' [ RunTime:0.012838s ]
[ 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` = '3' 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.020123s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.057835s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 621 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2334 LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 629 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000418s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000914s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 627 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 634 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000900s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1469 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000840s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3524 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1322 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001175s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1225 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001314s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000148s ]
[ 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` = 644 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001430s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.001984s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 621 AND `type` = 'tijian_level' [ RunTime:0.001287s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 629 AND `type` = 'tijian_level' [ RunTime:0.000208s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 627 AND `type` = 'tijian_level' [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 634 AND `type` = 'tijian_level' [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 1469 AND `type` = 'tijian_level' [ RunTime:0.005238s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 1444 AND `type` = 'tijian_level' [ RunTime:0.000224s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 1334 AND `type` = 'tijian_level' [ RunTime:0.000178s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 1322 AND `type` = 'tijian_level' [ RunTime:0.000849s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 1225 AND `type` = 'tijian_level' [ RunTime:0.008676s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 644 AND `type` = 'tijian_level' [ RunTime:0.001062s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000199s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000788s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000147s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '621' and status = 2 [ RunTime:0.000956s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '629' and status = 2 [ RunTime:0.002889s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '629' and status = 2 [ RunTime:0.000187s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '629' and status = 2 [ RunTime:0.000140s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '629' and status = 2 [ RunTime:0.000144s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '627' and status = 2 [ RunTime:0.000125s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '627' and status = 2 [ RunTime:0.000119s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '627' and status = 2 [ RunTime:0.000385s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '627' and status = 2 [ RunTime:0.002138s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '634' and status = 2 [ RunTime:0.000166s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '634' and status = 2 [ RunTime:0.000133s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '634' and status = 2 [ RunTime:0.000126s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '634' and status = 2 [ RunTime:0.000123s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '1469' and status = 2 [ RunTime:0.001468s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '1444' and status = 2 [ RunTime:0.000123s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '1334' and status = 2 [ RunTime:0.000148s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '1334' and status = 2 [ RunTime:0.000130s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '1334' and status = 2 [ RunTime:0.000140s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '1334' and status = 2 [ RunTime:0.002132s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '1322' and status = 2 [ RunTime:0.000127s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '1225' and status = 2 [ RunTime:0.000194s ]
[ SQL ] select sum(z_score) as c from ebx_hospital_meal_comment where hid = '1225' and status = 2 [ RunTime:0.000131s ]
[ SQL ] select sum(f_score) as c from ebx_hospital_meal_comment where hid = '1225' and status = 2 [ RunTime:0.000124s ]
[ SQL ] select sum(t_score) as c from ebx_hospital_meal_comment where hid = '1225' and status = 2 [ RunTime:0.000914s ]
[ SQL ] select count(*) as c from ebx_hospital_meal_comment where hid = '644' and status = 2 [ RunTime:0.000125s ]
[ 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.023238s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 621 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002543s ]
[ 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 = '629' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000333s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 629 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002853s ]
[ 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 = '627' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.003453s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 627 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002047s ]
[ 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 = '634' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.001344s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 634 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.003331s ]
[ 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 = '1469' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000226s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 1469 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001218s ]
[ 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 = '1444' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000215s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001262s ]
[ 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 = '1334' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.000248s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.005633s ]
[ 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 = '1322' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.001281s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 1322 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001243s ]
[ 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 = '1225' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.002986s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 1225 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.016009s ]
[ 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 = '644' and a.hospital_recommend = 1 order by a.weight desc , a.add_time desc limit 3 [ RunTime:0.007481s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 644 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] select `id` , `name` , `area_code` from `ebx_region`
where 1 = 1 AND parent_id = '236' order by weight desc limit 50 [ RunTime:0.000201s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.001061s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_service' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000231s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `number` = 3 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000154s ]
[ 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.004837s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.001044s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000131s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 117 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 83 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.004779s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 81 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 114 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.014710s ]
[ 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.000112s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 112 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000142s ]
[ 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.002676s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.002565s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.002680s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 117 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001460s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.002624s ]
[ 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` = 83 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 81 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002643s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000142s ]
[ 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` = 114 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 112 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `ebx_region` WHERE `area_code` = '0755' LIMIT 1 [ RunTime:0.000168s ]
[ 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.002781s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000145s ]
[ 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` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001780s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000128s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1469 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2338 LIMIT 1 [ RunTime:0.000689s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1444 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1334 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001515s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_cat` [ RunTime:0.006267s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000142s ]
[ 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.000151s ]
[ 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.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000893s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.009973s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000903s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.011018s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000912s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.001192s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.001153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.001205s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.001197s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.023574s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000162s ]
[ 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.003037s ]
[ 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.016557s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.037665s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000134s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000134s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000145s ]
[ 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.000162s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000135s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.004537s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000140s ]
[ 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.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000135s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000134s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.010762s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000186s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.001097s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000220s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.001137s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000147s ]
[ 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.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.001537s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.001672s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.001762s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.001457s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.001377s ]
[ 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.126079s ]
[ 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.151514s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.001606s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000213s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.001424s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000162s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.001131s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.004029s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.001403s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.005228s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000135s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.027907s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 50 [ RunTime:0.002530s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.004650s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000409s ]
[ 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.000825s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.002448s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000378s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000758s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.001017s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000393s ]
[ 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.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000968s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.002194s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000956s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.002109s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 23 [ RunTime:0.000172s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 33 [ RunTime:0.000166s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.045023s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000240s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.002344s ]
[ 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.010589s ]
[ 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.196107s ]
[ 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.059678s ]
