[ DB ] CONNECT:[ UseTime:0.013166s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.010977s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.007654s ]
[ 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.007710s ]
[ 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.007708s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.008880s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22490 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007693s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22490 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007621s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22490 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007696s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.029869s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','梅西','阿根廷') AND `status` = 'normal' [ RunTime:0.013688s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','梅西','阿根廷') [ RunTime:0.004093s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.009372s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.008359s ]
[ 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 (501,373,2040) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.792985s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','梅西','阿根廷') [ RunTime:0.106533s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.009781s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (501,373,2040) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.010377s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','梅西','阿根廷') [ RunTime:0.007519s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.007978s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (501,373,2040) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.007262s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.007247s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.176298s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 93029,1000 [ RunTime:0.103485s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (93677,93135,93070,93900,93958,93766,93672,93956,93629,93092,93411,93125,93559,93846,93336,93887,93580,93271,93809,93189,93309,93933,93172,93818,94017) AND `status` = 'normal' [ RunTime:0.027907s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.083868s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 8470,1000 [ RunTime:0.042448s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (8623,9344,9316,9284,9473,9062,8534,8479,9417,8645,9419,8997,9163,8692,9237,9175,9218,9079,8955,9244,9181,8498,8703,9439,8535) AND `status` = 'normal' [ RunTime:0.014798s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.008374s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.241503s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 43018,1000 [ RunTime:0.110847s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (43382,43405,43139,44011,43301,43655,43535,43067,43210,43543,43552,43816) AND `status` = 'normal' [ RunTime:0.048990s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22490 [ RunTime:0.029770s ]