[ DB ] CONNECT:[ UseTime:0.031806s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ebx_config` [ RunTime:0.006920s ]
[ SQL ] SELECT * FROM `ebx_config` [ RunTime:0.001392s ]
[ 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 a.status = 1 and a.is_show = 1 AND FIND_IN_SET(1,a.kind_str) AND a.city = '236' [ RunTime:0.003504s ]
[ SQL ] select a.* from ebx_hospital as a left join ebx_hospital_tags as b on a.hid = b.hid where a.status = 1 and a.is_show = 1 AND FIND_IN_SET(1,a.kind_str) AND a.city = '236' group by a.hid order by a.yuyue_num desc , a.hid desc LIMIT 0,10 [ RunTime:0.004994s ]
[ 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=62 order by htc.weight asc [ RunTime:0.021455s ]
[ 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=82 order by htc.weight asc [ RunTime:0.001092s ]
[ 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=80 order by htc.weight asc [ RunTime:0.000456s ]
[ 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.023980s ]
[ 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=93 order by htc.weight asc [ RunTime:0.001869s ]
[ 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=92 order by htc.weight asc [ RunTime:0.011103s ]
[ 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=88 order by htc.weight asc [ RunTime:0.000516s ]
[ 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=87 order by htc.weight asc [ RunTime:0.005740s ]
[ 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=85 order by htc.weight asc [ RunTime:0.013231s ]
[ 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=84 order by htc.weight asc [ RunTime:0.000455s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tags` [ RunTime:0.018201s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 62 AND `type` = 'tijian_level' [ RunTime:0.000574s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 82 AND `type` = 'tijian_level' [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 80 AND `type` = 'tijian_level' [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 63 AND `type` = 'tijian_level' [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 93 AND `type` = 'tijian_level' [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 92 AND `type` = 'tijian_level' [ RunTime:0.008373s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 88 AND `type` = 'tijian_level' [ RunTime:0.000432s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 87 AND `type` = 'tijian_level' [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 85 AND `type` = 'tijian_level' [ RunTime:0.000397s ]
[ SQL ] SELECT * FROM `ebx_hospital_tags` WHERE `hid` = 84 AND `type` = 'tijian_level' [ RunTime:0.012286s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_meal` [ RunTime:0.028848s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 62 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000799s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 82 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000571s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 80 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.002772s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 63 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.012499s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 93 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001812s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 92 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 88 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.023088s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 87 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.001156s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 85 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.000988s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ebx_hospital_meal` WHERE `hid` = 84 AND `status` = 1 AND `is_upper` = 1 LIMIT 1 [ RunTime:0.012088s ]
[ 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.037350s ]
[ SQL ] SHOW COLUMNS FROM `ebx_hospital_tag_config` [ RunTime:0.000980s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `deleted` = 0 AND `is_open` = 1 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_service' AND `deleted` = 0 AND `is_open` = 1 ORDER BY `weight` desc,`add_time` desc [ RunTime:0.000392s ]
[ SQL ] SHOW COLUMNS FROM `ebx_region` [ RunTime:0.006495s ]
[ SQL ] SELECT `name` FROM `ebx_region` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT `name` FROM `ebx_hospital_tag_config` WHERE `type` = 'tijian_level' AND `number` = 0 LIMIT 1 [ RunTime:0.000225s ]
[ 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' limit 1 [ RunTime:0.000616s ]
