[ DB ] CONNECT:[ UseTime:0.001035s ] mysql:host=127.0.0.1;dbname=gzsxbg_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.099049s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.005573s ]
[ 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.009795s ]
[ SQL ] SELECT `id`,`name`,`diyname`,`keywords`,`seo_title`,`description`,`match_id`,`template` FROM `ww_category` WHERE `diyname` = 'lanqiu' AND `pid` = 13 LIMIT 1 [ RunTime:0.007561s ]
[ SQL ] SHOW COLUMNS FROM `ww_live` [ RunTime:0.024754s ]
[ 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` = '127134' AND `l`.`status` = 'normal' LIMIT 1 [ RunTime:0.065531s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.022649s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('马尔文','拉拉纳加','乌拉联','低调看直播') AND `status` = 'normal' [ RunTime:0.046689s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('马尔文','拉拉纳加','乌拉联','低调看直播') [ RunTime:0.007605s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.014834s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.007591s ]
[ 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 (2862,95,22982,21671) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.036264s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description` FROM `ww_news` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.026612s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('马尔文','拉拉纳加','乌拉联','低调看直播') [ RunTime:0.001860s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.011850s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2862,95,22982,21671) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.033745s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.005131s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('马尔文','拉拉纳加','乌拉联','低调看直播') [ RunTime:0.003749s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.014923s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (2862,95,22982,21671) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.011287s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.005611s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.389816s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 6186,1000 [ RunTime:0.043626s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (6508,6747,6586,6969,6347,6318,6824,6528,7091,7030,7057,6424,6607,6717,6832,6688,7133,6840,6283,6589,6853,6844,7152,6257,6600) AND `status` = 'normal' [ RunTime:0.001469s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.004845s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:2.183947s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 22180,1000 [ RunTime:0.324603s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (22278,23000,22704,22618,22859,22591,22485,22328,23038,23133,23126,23023) AND `status` = 'normal' [ RunTime:0.007308s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.008882s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:3.182433s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 149584,1000 [ RunTime:1.701193s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (152198,151885,151874,152026,152195,152254,151965,152643,152583,151862,152495,152721,152391,151847,152511,152112,152792,151878,152588,151850,152553,152543,152589,152438,152451) AND `status` = 'normal' [ RunTime:0.002388s ]
[ SQL ] UPDATE `ww_live` SET `click_num`=`click_num`+1 WHERE `id` = 127134 [ RunTime:0.168700s ]