[ DB ] CONNECT:[ UseTime:0.000253s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.000879s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.000362s ]
[ SQL ] select count(DISTINCT a.hid) as c from ebx_hospital as a left join ebx_hospital_tags as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_show = 1 and a.`region` = '2335' AND a.city = '236' [ RunTime:0.000564s ]
[ SQL ] select a.* from ebx_hospital as a left join ebx_hospital_tags as b on a.hid = b.hid where 1 = 1 AND a.status = 1 and a.is_show = 1 and a.`region` = '2335' AND a.city = '236' group by a.hid order by a.weight asc , a.hid desc LIMIT 0,10 [ RunTime:0.001103s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=77 order by htc.weight asc [ RunTime:0.000370s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=76 order by htc.weight asc [ RunTime:0.000351s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=75 order by htc.weight asc [ RunTime:0.000298s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=67 order by htc.weight asc [ RunTime:0.000289s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=66 order by htc.weight asc [ RunTime:0.000314s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=64 order by htc.weight asc [ RunTime:0.000311s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=63 order by htc.weight asc [ RunTime:0.000304s ]
[ SQL ] select htc.`name`,htc.`number` from ebx_hospital_tag_config as htc
left join ebx_hospital_tags as ht on htc.number=ht.tag_id
left join ebx_hospital as h on ht.hid=h.hid
where htc.`type`='hospital_mytag' and htc.`deleted`=0 and htc.`is_open`=1
and ht.`type`='hospital_mytag' and ht.hid=78 order by htc.weight asc [ RunTime:0.000311s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.000800s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 77 AND `type` = 'tijian_level' [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 76 AND `type` = 'tijian_level' [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 75 AND `type` = 'tijian_level' [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 67 AND `type` = 'tijian_level' [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 66 AND `type` = 'tijian_level' [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 64 AND `type` = 'tijian_level' [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 63 AND `type` = 'tijian_level' [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 78 AND `type` = 'tijian_level' [ RunTime:0.000313s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.000884s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 77 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 76 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 75 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 67 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 66 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 64 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 63 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 78 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] select `id`,`name`,`area_code`,`level` from `ebx_region` where 1 = 1 AND parent_id = '236' order by weight asc limit 50 [ RunTime:0.000408s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.000895s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_service' AND `deleted` = 0 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.000811s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `number` = 0 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] select `id`,`name`,`area_code`,`level` from `ebx_region` where 1 = 1 AND parent_id = '236' order by weight asc limit 50 [ RunTime:0.000401s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 2335 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] select count(*) as c from ebx_hospital as a where 1 = 1 AND a.status = 1 and a.is_show = 1 AND a.city = '236' AND a.region=2335 limit 1 [ RunTime:0.000453s ]
