[ DB ] CONNECT:[ UseTime:0.004221s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.008555s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.005283s ]
[ 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.008261s ]
[ 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.008161s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.007799s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 22401 AND `status` = 'normal' LIMIT 1 [ RunTime:0.005578s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 22401 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001116s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 22401 AND `category_id` IN (49) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000998s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.002574s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('意甲','AC米兰','足球') AND `status` = 'normal' [ RunTime:0.159072s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('意甲','AC米兰','足球') [ RunTime:0.012225s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.022519s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.015070s ]
[ 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 (79,81,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:1.147293s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('意甲','AC米兰','足球') [ RunTime:0.000887s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.059230s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (79,81,373) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.012761s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('意甲','AC米兰','足球') [ RunTime:0.008481s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.011828s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (79,81,373) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.287796s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.004578s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.144973s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 75187,1000 [ RunTime:0.224695s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (76156,75626,76131,75564,75485,75815,75808,75563,75458,75882,76023,76091,75856,75817,75666,75748,75846,75860,75331,75354,76096,75190,75799,75384,75600) AND `status` = 'normal' [ RunTime:0.005899s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.018492s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 11799,1000 [ RunTime:0.017736s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (12394,11821,12767,12460,12595,12751,12477,12199,12078,12066,12220,12674,12753,12196,12570,12450,12194,12427,12669,11882,12487,12174,12251,12754,12081) AND `status` = 'normal' [ RunTime:0.001167s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.003093s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.068616s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 118061,1000 [ RunTime:0.275122s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (118454,118290,118151,118597,118649,118298,119015,118837,118721,118935,119018,118786) AND `status` = 'normal' [ RunTime:0.007169s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 22401 [ RunTime:0.441690s ]