[ DB ] CONNECT:[ UseTime:0.001010s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.008102s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001272s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `table` = 'live' AND `pid` = 0 LIMIT 1 [ RunTime:0.001242s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `diyname` = 'zuqiu' AND `pid` = 13 LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SHOW COLUMNS FROM `ww_live` [ RunTime:0.004314s ]
[ SQL ] SELECT `l`.*,m.title vice_title,t1.image image1,t2.image image2,t1.title title1,t2.title title2 FROM `ww_live` `l` LEFT JOIN `ww_match` `m` ON `l`.`match_id`=`m`.`id` LEFT JOIN `ww_team` `t1` ON `l`.`teamz_id`=`t1`.`id` LEFT JOIN `ww_team` `t2` ON `l`.`teamk_id`=`t2`.`id` WHERE `l`.`id` = '126037' AND `l`.`status` = 'normal' LIMIT 1 [ RunTime:0.006759s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.007612s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('加尔瓦尔英雄U21','拉贾斯坦联合U21','印展联U21','雨燕直播') AND `status` = 'normal' [ RunTime:0.007572s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('加尔瓦尔英雄U21','拉贾斯坦联合U21','印展联U21','雨燕直播') [ RunTime:0.000822s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.005446s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.004401s ]
[ 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 (25089,24702,25090,118) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.002477s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description` FROM `ww_news` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.001391s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('加尔瓦尔英雄U21','拉贾斯坦联合U21','印展联U21','雨燕直播') [ RunTime:0.000938s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.003899s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (25089,24702,25090,118) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.051909s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.005605s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('加尔瓦尔英雄U21','拉贾斯坦联合U21','印展联U21','雨燕直播') [ RunTime:0.004415s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.012829s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (25089,24702,25090,118) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.004486s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.001063s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.063276s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 10288,1000 [ RunTime:0.074967s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (10529,11108,11188,11169,10969,10636,10692,11217,10589,10508,10468,10386,10605,10893,10400,10730,10660,11017,11160,10337,11136,10978,10932,11186,11043) AND `status` = 'normal' [ RunTime:0.004919s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.007526s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.783596s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 94401,1000 [ RunTime:0.599405s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (95284,94936,95097,95199,94484,95322,94988,95365,94475,94751,94485,95158) AND `status` = 'normal' [ RunTime:0.007550s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.007968s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:2.416732s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 75152,1000 [ RunTime:0.947859s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (75538,75573,75526,75868,76097,75565,75822,75770,75986,75269,75452,75412,75233,75410,75309,75835,75582,75711,75741,75810,75993,75456,76064,75823,75953) AND `status` = 'normal' [ RunTime:0.001527s ]
[ SQL ] UPDATE `ww_live` SET `click_num`=`click_num`+1 WHERE `id` = 126037 [ RunTime:0.017116s ]