[ DB ] CONNECT:[ UseTime:0.011843s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.008022s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.007596s ]
[ 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.006565s ]
[ 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.007288s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.007854s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 23149 AND `status` = 'normal' LIMIT 1 [ RunTime:0.016790s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 23149 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008044s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 23149 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.048341s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.016444s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('NBA','篮球','鹈鹕','勇士') AND `status` = 'normal' [ RunTime:0.014700s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','篮球','鹈鹕','勇士') [ RunTime:0.011555s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.010819s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.005409s ]
[ 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,26,1,51) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.970549s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','篮球','鹈鹕','勇士') [ RunTime:0.103690s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.022492s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2,26,1,51) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.018488s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('NBA','篮球','鹈鹕','勇士') [ RunTime:0.011958s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.021259s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2,26,1,51) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.039405s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.008828s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:1.107863s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 192710,1000 [ RunTime:0.435992s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (193400,192842,192981,193199,193388,193390,193027,193549,193188,192822,193562,193475,192913,193322,193544,193047,192978,192714,192868,192711,193104,192793,193244,193044,193432) AND `status` = 'normal' [ RunTime:0.003845s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.030607s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 7367,1000 [ RunTime:0.012053s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (7432,7872,8350,7743,8220,8093,8188,7859,7974,8124,7855,7377,8194,8317,7746,7390,8032,7570,8031,7861,7496,7945,8210,7953,7594) AND `status` = 'normal' [ RunTime:0.001215s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.004723s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.087671s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 65525,1000 [ RunTime:0.078607s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (66485,65910,65684,66431,65593,66179,66437,65858,65616,66465,66198,66239) AND `status` = 'normal' [ RunTime:0.042206s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 23149 [ RunTime:0.055825s ]