[ DB ] CONNECT:[ UseTime:0.011315s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.007985s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.007678s ]
[ 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.007828s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `diyname` = 'zuqiu' AND `pid` = 40 LIMIT 1 [ RunTime:0.007669s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.007858s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22393 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007672s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22393 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007596s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22393 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008677s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.007742s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','C罗','Z原创') AND `status` = 'normal' [ RunTime:0.021109s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','C罗','Z原创') [ RunTime:0.007254s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.007809s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.006927s ]
[ 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 (1089,389,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.273415s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','C罗','Z原创') [ RunTime:0.002566s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.017081s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (1089,389,373) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.004980s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.005222s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','C罗','Z原创') [ RunTime:0.005495s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.005743s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (1089,389,373) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.014514s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.012085s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.006887s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.122316s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 13686,1000 [ RunTime:0.005909s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (13813,14129,14216,14379,14664,14022,13720,14206,13710,13922,13815,14252,14543,14225,14326,14677,14025,13945,14602,14331,13805,14363,13958,13781,13769) AND `status` = 'normal' [ RunTime:0.063219s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.107271s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 499,1000 [ RunTime:0.017999s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (769,1083,1087,765,594,743,666,1427,1209,1358,1255,956,1445,1301,622,1394,1471,651,1088,889,1169,665,1111,695,958) AND `status` = 'normal' [ RunTime:0.008026s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.006335s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.185058s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 96617,1000 [ RunTime:0.111504s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (97154,96853,96703,97175,97024,96834,97045,96784,97554,96769,96636,97120) AND `status` = 'normal' [ RunTime:0.001768s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22393 [ RunTime:1.133949s ]