[ DB ] CONNECT:[ UseTime:0.004725s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.007082s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.008020s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.008076s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 98973 AND `status` = 'normal' LIMIT 1 [ RunTime:0.004950s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 59 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007409s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 5 AND `status` = 'normal' LIMIT 1 [ RunTime:0.005590s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.019793s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','骑士') AND `status` = 'normal' [ RunTime:0.007655s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 98973 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007543s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 98973 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.195411s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','骑士') [ RunTime:0.007683s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.006322s ]
[ 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 (2,1,3) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:1.181077s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.031586s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `match_id` IN (1) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.013648s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.007476s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `match_id` IN (1) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.019713s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.200962s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 22696,1000 [ RunTime:0.232706s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (23605,23015,22833,23667,22913,23426,23333,23039,23348,23077,23638,23643,23238,23328,22827,22725,23100,22748,23232,23566,23387,23182,22994,23024,23034) AND `status` = 'normal' [ RunTime:0.004238s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.108068s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.633811s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 19062,1000 [ RunTime:0.052250s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (19859,19738,20050,19099,19334,19925,20008,19520,19609,19465,19736,19147) AND `status` = 'normal' [ RunTime:0.001836s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.007291s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.660704s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 183690,1000 [ RunTime:0.271784s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (184579,183693,183988,184353,184415,183881,184060,183872,184542,184352,184446,183784,183846,183807,184141,184496,184287,184369,184331,184673,184170,184639,184395,184259,183948) AND `status` = 'normal' [ RunTime:0.014225s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 98973 [ RunTime:0.016401s ]