[ DB ] CONNECT:[ UseTime:0.001105s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.003911s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001110s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.017100s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 100375 AND `status` = 'normal' LIMIT 1 [ RunTime:0.004600s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 59 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 5 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000971s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.003172s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','快船') AND `status` = 'normal' [ RunTime:0.001026s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 100375 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001125s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 100375 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011929s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','快船') [ RunTime:0.009149s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.018683s ]
[ 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,63,1) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.964110s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.003775s ]
[ 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.001178s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.003495s ]
[ 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.001138s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.108881s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 2022,1000 [ RunTime:0.011874s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (2318,2407,2872,2103,2285,2718,2877,2807,2865,2126,2545,2616,2579,2678,2774,2327,2144,2262,2842,2990,2711,2152,2066,2379,2625) AND `status` = 'normal' [ RunTime:0.007209s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.007764s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.215656s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 74303,1000 [ RunTime:0.164319s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (74821,74560,74730,75169,74830,74769,74355,74773,74745,74613,74859,74523) AND `status` = 'normal' [ RunTime:0.001411s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.003080s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.231998s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 182627,1000 [ RunTime:0.429029s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (183122,183230,183197,183448,182998,182862,182759,183305,183475,183231,183489,182949,183123,182742,183110,183455,182752,182753,183075,183258,183181,183308,183183,183296,183375) AND `status` = 'normal' [ RunTime:0.019936s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 100375 [ RunTime:0.015465s ]