[ DB ] CONNECT:[ UseTime:0.007999s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.018890s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.005546s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `table` = 'video' AND `pid` = 0 LIMIT 1 [ RunTime:0.006755s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `diyname` = 'lanqiu' AND `pid` = 40 LIMIT 1 [ RunTime:0.042743s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.009201s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22662 AND `status` = 'normal' LIMIT 1 [ RunTime:0.005967s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22662 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007970s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22662 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.005678s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.006809s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('NBA','话题','篮球') AND `status` = 'normal' [ RunTime:0.005765s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','话题','篮球') [ RunTime:0.017890s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.040135s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.022171s ]
[ 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,67) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:1.951701s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','话题','篮球') [ RunTime:0.007109s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.014415s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2,1,67) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.050088s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','话题','篮球') [ RunTime:0.032849s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.064428s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2,1,67) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.012959s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.019728s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.362962s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 84732,1000 [ RunTime:0.312256s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (84792,85173,85349,85337,84810,85279,84774,85586,84873,84870,85623,85513,85350,84991,85062,84876,85335,85319,85308,84970,84843,85444,85134,84838,85628) AND `status` = 'normal' [ RunTime:0.106853s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.087488s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 11973,1000 [ RunTime:0.026128s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (12510,12471,12670,12133,12330,12658,12292,11986,12579,12786,12845,12841,12852,12310,12384,12913,12922,12213,12613,12652,12646,12107,12294,12587,12664) AND `status` = 'normal' [ RunTime:0.001195s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.004963s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.129917s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 78378,1000 [ RunTime:0.063352s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (79281,78900,78616,79150,78943,78497,79124,79280,78619,78566,79366,79177) AND `status` = 'normal' [ RunTime:0.019201s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22662 [ RunTime:0.013552s ]