[ DB ] CONNECT:[ UseTime:0.007747s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.007344s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.008316s ]
[ 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.007798s ]
[ 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.006568s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.009701s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22377 AND `status` = 'normal' LIMIT 1 [ RunTime:0.009487s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22377 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007201s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22377 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004640s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.008598s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','Z原创') AND `status` = 'normal' [ RunTime:0.007868s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','Z原创') [ RunTime:0.007642s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.009830s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.006150s ]
[ 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 (389,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.373690s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','Z原创') [ RunTime:0.018222s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.015715s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (389,373) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.003624s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.004887s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','Z原创') [ RunTime:0.007347s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.007858s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (389,373) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.041545s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.002770s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.008173s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.645454s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 167259,1000 [ RunTime:0.722849s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (167358,167578,167767,167439,167272,167388,167894,167540,168065,167720,168202,167825,167707,167479,167905,167489,167519,167752,168249,168101,167483,167746,168224,168199,167744) AND `status` = 'normal' [ RunTime:0.002429s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.031410s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 7539,1000 [ RunTime:0.018386s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (8200,8468,8243,8306,7615,8026,8532,7774,8096,8134,7989,7554,8416,7896,8471,8214,7601,8062,8417,7786,7840,8249,7723,8399,7987) AND `status` = 'normal' [ RunTime:0.004646s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.007025s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.196551s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 31964,1000 [ RunTime:0.085626s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (32221,32490,32214,32784,32411,32167,32583,32277,32226,32450,32788,32864) AND `status` = 'normal' [ RunTime:0.019563s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22377 [ RunTime:0.220776s ]