[ DB ] CONNECT:[ UseTime:0.000300s ] mysql:host=localhost;port=3306;dbname=test_92ya_com;charset=utf8
[ 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 = '173' order by a.add_time desc limit 20 [ RunTime:0.000478s ]
[ SQL ] select a.* ,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 article_id = '100' limit 1 [ RunTime:0.000505s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_tags` [ RunTime:0.000751s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 100 [ RunTime:0.000239s ]
[ SQL ] SHOW COLUMNS FROM `ebx_users` [ RunTime:0.001202s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 229 LIMIT 1 [ RunTime:0.000249s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article` [ RunTime:0.000890s ]
[ SQL ] SELECT `article_id`,`title` FROM `ebx_article` WHERE ( article_id > 100 and is_open = 1 ) ORDER BY `weight` desc,`publish_time` desc LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT `article_id`,`title` FROM `ebx_article` WHERE ( article_id < 100 and is_open = 1 ) ORDER BY `weight` desc,`publish_time` desc LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] UPDATE `ebx_article` SET `click`=`click`+1 WHERE `article_id` = 100 [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `ebx_project_type` [ RunTime:0.000782s ]
[ SQL ] SELECT * FROM `ebx_project_type` WHERE `cat_id` = 0 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SELECT `article_id` FROM `ebx_article_tags` WHERE ( article_id!=100 ) ORDER BY article_id desc LIMIT 5 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ebx_article` WHERE ( is_open=1 AND article_id in (98,98,98,97,97) ) ORDER BY `weight` desc,`publish_time` desc LIMIT 0,5 [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 188 LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 98 [ RunTime:0.000201s ]
[ SQL ] SHOW COLUMNS FROM `ebx_article_unique_tags` [ RunTime:0.000711s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('测试标签','第一','第一个标签') [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `ebx_users` WHERE `user_id` = 123 LIMIT 1 [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `ebx_article_tags` WHERE `article_id` = 97 [ RunTime:0.000212s ]
[ SQL ] SELECT `tag`,`tag_id` FROM `ebx_article_unique_tags` WHERE `tag` IN ('最后标签','第一个标签') [ RunTime:0.000199s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '98' [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '测试标签' LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一' LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一个标签' LIMIT 1 [ RunTime:0.000230s ]
[ SQL ] select * from ebx_article_tags as a where a.article_id = '97' [ RunTime:0.000197s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '最后标签' LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SELECT * FROM `ebx_article_unique_tags` WHERE `tag` = '第一个标签' LIMIT 1 [ RunTime:0.000208s ]