[ DB ] CONNECT:[ UseTime:0.003145s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.006624s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001252s ]
[ 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.010316s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `diyname` = 'lanqiu' AND `pid` = 40 LIMIT 1 [ RunTime:0.007908s ]
[ SQL ] SHOW COLUMNS FROM `ww_video` [ RunTime:0.008876s ]
[ SQL ] SELECT * FROM `ww_video` WHERE `id` = 23113 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007688s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` < 23113 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008607s ]
[ SQL ] SELECT `id`,`title` FROM `ww_video` WHERE `id` > 23113 AND `category_id` IN (50) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007717s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.009774s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('詹姆斯','NBA','篮球','76人') AND `status` = 'normal' [ RunTime:0.007749s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('詹姆斯','NBA','篮球','76人') [ RunTime:0.001734s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.006809s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.007688s ]
[ 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 (33,2,1,12) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.575827s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('詹姆斯','NBA','篮球','76人') [ RunTime:0.000650s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.003868s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (33,2,1,12) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.114746s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('詹姆斯','NBA','篮球','76人') [ RunTime:0.007432s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.012523s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (33,2,1,12) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.007145s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.016158s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.296678s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 34869,1000 [ RunTime:0.078915s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (34983,34946,35659,35670,35718,35698,35193,35126,35266,35350,35494,34910,35400,34886,35128,35610,34883,35069,35634,35597,34932,35240,34894,35697,35629) AND `status` = 'normal' [ RunTime:0.002741s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.035418s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 6039,1000 [ RunTime:0.010752s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (6990,6727,6685,6062,6723,6097,6430,6924,6267,6576,6799,6566,6613,6437,6401,6307,6047,6593,6517,6399,6202,6046,6511,6795,6573) AND `status` = 'normal' [ RunTime:0.001256s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.005517s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.088806s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 20881,1000 [ RunTime:0.008878s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (21787,21489,21632,21646,21134,20968,21405,21164,20947,21456,21435,21320) AND `status` = 'normal' [ RunTime:0.223061s ]
[ SQL ] UPDATE `ww_video` SET `click_num`=`click_num`+1 WHERE `id` = 23113 [ RunTime:0.236844s ]