[ DB ] CONNECT:[ UseTime:0.000563s ] 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.003136s ]
[ 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.000351s ]
[ 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.000420s ]
[ 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.000406s ]
[ 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.002386s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000796s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 250 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3538 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.000710s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3859 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000231s ]
[ 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.000121s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3858 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 135 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1404 LIMIT 1 [ RunTime:0.000118s ]
[ 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.000119s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1405 LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3856 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 142 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3555 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3855 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000197s ]
[ 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.000120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3854 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 236 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2336 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3853 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 387 LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 3852 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 124 LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1307 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 2555 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000214s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2187 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT MIN(w_price) AS tp_min FROM `ebx_hospital_meal` WHERE `hid` = 1556 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SHOW COLUMNS FROM `ebx_common_cart` [ RunTime:0.000835s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_common_cart` WHERE `session_id` = 'jt97h1tpn1v6npi63avbq4ltb2' LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SHOW COLUMNS FROM `ebx_search_keywords` [ RunTime:0.000629s ]
[ SQL ] SELECT * FROM `ebx_search_keywords` WHERE `is_show` = 1 AND `area_code` = '0000' ORDER BY `count` desc,`id` desc LIMIT 5 [ RunTime:0.001194s ]
[ SQL ] select count(distinct a.tid ) as c from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid LEFT JOIN ebx_hospital_tags AS c ON a.tid = c.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and c.`tag_id` = '1' and c.type = 'meal_type' [ RunTime:0.013056s ]
[ SQL ] select a.tid ,a.hid ,a.name , a.y_price,a.j_price,a.w_price,a.thum,a.sex,a.virtual_sell,
a.add_time ,a.extra,a.description,a.yuyue_count
,b.name as h_name, b.lng ,b.lat ,b.province , b.city ,b.region
from ebx_hospital_meal as a left join ebx_hospital as b on a.hid = b.hid LEFT JOIN ebx_hospital_tags AS c ON a.tid = c.hid where 1 = 1 AND a.status = 1 and a.is_upper = 1 and c.`tag_id` = '1' and c.type = 'meal_type' GROUP BY a.tid order by a.virtual_sell desc , a.tid desc LIMIT 0,18 [ RunTime:0.031962s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000260s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 926 LIMIT 1 [ RunTime:0.000135s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 50 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 602 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3256 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 139 LIMIT 1 [ RunTime:0.000134s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1434 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 241 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2368 LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 119 LIMIT 1 [ RunTime:0.000139s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1263 LIMIT 1 [ RunTime:0.000121s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 178 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1790 LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 115 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3565 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 126 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1327 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 255 LIMIT 1 [ RunTime:0.000143s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2450 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3256 LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 733 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 733 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 172 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1731 LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 124 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1307 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 272 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2608 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 136 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 1410 LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 366 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 3434 LIMIT 1 [ RunTime:0.000127s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.000728s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'meal_type' AND `number` = 1 LIMIT 1 [ RunTime:0.000163s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'meal_type' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000275s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'meal_type' AND `number` = 1 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'meal_type' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'meal_sick' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000253s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_cat` [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000191s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 17 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 18 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000153s ]
[ 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.000164s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000154s ]
[ 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.000166s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 46 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 47 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000152s ]
[ 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.000188s ]
[ 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.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000143s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000151s ]
[ 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.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 57 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 58 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000153s ]
[ 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.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000153s ]
[ 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.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 70 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000148s ]
[ 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.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000152s ]
[ 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.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000156s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ 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 (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.010809s ]
[ 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.010380s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000237s ]
[ 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.000178s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 25 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 32 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 19 [ RunTime:0.000145s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 39 [ RunTime:0.000177s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 40 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 41 [ RunTime:0.000142s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 20 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 42 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 43 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 44 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 45 [ RunTime:0.000140s ]
[ 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.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 48 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 49 [ RunTime:0.000146s ]
[ 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.000176s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000146s ]
[ 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.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 51 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 52 [ RunTime:0.000156s ]
[ 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.000139s ]
[ 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.000153s ]
[ 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.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 61 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 62 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000139s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 65 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 66 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000144s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 69 [ RunTime:0.000141s ]
[ 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.000148s ]
[ 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.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000140s ]
[ 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.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 34 [ RunTime:0.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 24 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 26 [ RunTime:0.000154s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 27 [ RunTime:0.000147s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 28 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 29 [ RunTime:0.000146s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 30 [ RunTime:0.000153s ]
[ 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.010558s ]
[ 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.010589s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 21 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 35 [ RunTime:0.000178s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 36 [ RunTime:0.000150s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 37 [ RunTime:0.000173s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 38 [ RunTime:0.000160s ]
[ 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.000141s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 53 [ RunTime:0.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 54 [ RunTime:0.000158s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 55 [ RunTime:0.000153s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 56 [ RunTime:0.000141s ]
[ 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.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 59 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 60 [ RunTime:0.000151s ]
[ 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.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 63 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 64 [ RunTime:0.000144s ]
[ 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.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 67 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 68 [ RunTime:0.000170s ]
[ 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.000140s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 71 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 72 [ RunTime:0.000155s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 73 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `ebx_article_cat` WHERE `parent_id` = 74 [ RunTime:0.000154s ]
[ 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.001839s ]
[ 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.001964s ]
[ SQL ] select a.tid , a.yuyue_count , a.virtual_sell , 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.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.index_recommend = 1 order by a.weight desc , a.add_time desc
limit 5 [ RunTime:0.009680s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.000883s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 17392 AND `type` = 'meal_type' [ RunTime:0.000876s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 17391 AND `type` = 'meal_type' [ RunTime:0.000234s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 17171 AND `type` = 'meal_type' [ RunTime:0.000713s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 17157 AND `type` = 'meal_type' [ RunTime:0.000462s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 16869 AND `type` = 'meal_type' [ RunTime:0.000229s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal_sick` [ RunTime:0.000654s ]
[ SQL ] SELECT * FROM `ebx_hospital_meal_sick` WHERE `tid` = 17392 [ RunTime:0.000898s ]
[ SQL ] SELECT * FROM `ebx_hospital_meal_sick` WHERE `tid` = 17391 [ RunTime:0.000171s ]
[ SQL ] SELECT * FROM `ebx_hospital_meal_sick` WHERE `tid` = 17171 [ RunTime:0.000849s ]
[ SQL ] SELECT * FROM `ebx_hospital_meal_sick` WHERE `tid` = 17157 [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `ebx_hospital_meal_sick` WHERE `tid` = 16869 [ RunTime:0.000269s ]