[ DB ] CONNECT:[ UseTime:0.004978s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.012091s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.015377s ]
[ 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.009291s ]
[ 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.003409s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.008108s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22429 AND `status` = 'normal' LIMIT 1 [ RunTime:0.003280s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22429 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007918s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22429 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.005667s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.006682s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('凯恩','德甲','拜仁慕尼黑','英格兰','足球') AND `status` = 'normal' [ RunTime:0.003998s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('凯恩','德甲','拜仁慕尼黑','英格兰','足球') [ RunTime:0.003922s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.008825s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.006326s ]
[ 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 (446,77,285,978,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:1.249368s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('凯恩','德甲','拜仁慕尼黑','英格兰','足球') [ RunTime:0.006233s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.015506s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (446,77,285,978,373) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.075418s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('凯恩','德甲','拜仁慕尼黑','英格兰','足球') [ RunTime:0.008407s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.010857s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (446,77,285,978,373) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.016421s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.011058s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.822811s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 2354,1000 [ RunTime:0.027753s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (3252,2776,2894,3099,2566,2408,2464,2761,3149,3264,2750,2368,3250,2733,2982,2411,3169,3126,3340,3136,2466,2547,3007,2540,3132) AND `status` = 'normal' [ RunTime:0.008143s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.176628s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 9346,1000 [ RunTime:0.121076s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (9658,10241,10092,10043,9382,9354,9851,9574,10263,9762,9489,9834,9821,10302,9878,9775,9644,9510,10058,10301,9793,10034,9466,10192,9812) AND `status` = 'normal' [ RunTime:0.012918s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.010654s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.605386s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 12145,1000 [ RunTime:0.011149s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (12631,12344,13067,13101,12865,12192,12718,12206,12767,12508,13061,12247) AND `status` = 'normal' [ RunTime:0.100666s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22429 [ RunTime:0.035339s ]