[ DB ] CONNECT:[ UseTime:0.014064s ] mysql:host=127.0.0.1;dbname=gzsxbg_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.017002s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.011644s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.016949s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 49222 AND `status` = 'normal' LIMIT 1 [ RunTime:0.010611s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 38 AND `status` = 'normal' LIMIT 1 [ RunTime:0.011652s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 7 AND `status` = 'normal' LIMIT 1 [ RunTime:0.011393s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.011175s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','英超','曼联') AND `status` = 'normal' [ RunTime:0.040551s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 49222 AND `category_id` IN (38) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.031568s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 49222 AND `category_id` IN (38) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.164869s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','英超','曼联') [ RunTime:0.003976s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.007070s ]
[ SQL ] SELECT `id`,`title`,`category_id`,`image`,`seo_description`,`createtime` FROM `ww_news` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (429,91,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:1.145159s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.109360s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `match_id` IN (4) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.006278s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.008688s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `match_id` IN (4) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002612s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.030794s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 1472,1000 [ RunTime:0.022391s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (1828,2182,1787,1995,1530,1748,2262,2055,1730,1988,2415,1651,1819,1803,2316,1603,1919,2074,1905,1915,1948,1625,1873,1741,1829) AND `status` = 'normal' [ RunTime:0.008130s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.004502s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.130236s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 18390,1000 [ RunTime:0.016389s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (19292,19241,18525,18671,18585,19289,18587,18827,19266,18805,18395,18484) AND `status` = 'normal' [ RunTime:0.001680s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.332855s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.318397s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 31937,1000 [ RunTime:0.027759s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (34773,34900,34234,34820,34518,34464,34999,35098,34219,34989,34483,34674,34565,34966,35156,34621,34509,34241,34371,34578,34933,35150,34288,35155,34832) AND `status` = 'normal' [ RunTime:0.185164s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 49222 [ RunTime:0.462938s ]