[ DB ] CONNECT:[ UseTime:0.005719s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.012319s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.005491s ]
[ 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.007750s ]
[ 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.003382s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.009353s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22579 AND `status` = 'normal' LIMIT 1 [ RunTime:0.009486s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22579 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007154s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22579 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007750s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.008137s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('国家队','中国男足','中国足球','中超','北京国安','足球') AND `status` = 'normal' [ RunTime:0.003855s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('国家队','中国男足','中国足球','中超','北京国安','足球') [ RunTime:0.013310s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.011820s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.010635s ]
[ 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 (2345,498,497,625,397,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.477093s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('国家队','中国男足','中国足球','中超','北京国安','足球') [ RunTime:0.000737s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.017754s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2345,498,497,625,397,373) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.075099s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('国家队','中国男足','中国足球','中超','北京国安','足球') [ RunTime:0.002816s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.011238s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2345,498,497,625,397,373) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.015090s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.032687s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.988769s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 176926,1000 [ RunTime:0.772777s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (177666,177045,177206,177480,177519,177574,176987,177564,177437,177789,177863,177203,177345,177836,177040,177075,177019,177508,177000,177732,177053,177802,177719,177026,177224) AND `status` = 'normal' [ RunTime:0.156188s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.067780s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 5800,1000 [ RunTime:0.025788s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (6699,6265,6006,6101,6252,5826,6439,6558,6536,5840,6583,5851,6139,6591,6483,6419,6690,5948,6085,6788,6723,6619,6208,6722,6082) AND `status` = 'normal' [ RunTime:0.007315s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.007801s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.158240s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 50884,1000 [ RunTime:0.048830s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (50949,51096,51249,51650,51763,51740,51123,51685,51464,51648,51259,51372) AND `status` = 'normal' [ RunTime:0.001723s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22579 [ RunTime:0.076934s ]