[ DB ] CONNECT:[ UseTime:0.011855s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.010049s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.034502s ]
[ 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.006942s ]
[ 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.008021s ]
[ SQL ] SHOW COLUMNS FROM `ww_live` [ RunTime:0.019810s ]
[ 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` = '122375' AND `l`.`status` = 'normal' LIMIT 1 [ RunTime:0.007552s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.007719s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('吉尔吉斯斯坦U17','也门U17','U17亚洲杯','黑白直播') AND `status` = 'normal' [ RunTime:0.119174s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('吉尔吉斯斯坦U17','也门U17','U17亚洲杯','黑白直播') [ RunTime:0.009808s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.007248s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.006217s ]
[ 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 (23552,20214,14039,99) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.013572s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description` FROM `ww_news` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.011262s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('吉尔吉斯斯坦U17','也门U17','U17亚洲杯','黑白直播') [ RunTime:0.007639s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.007838s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_highlights` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (23552,20214,14039,99) AND `type` = 'highlights' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.005491s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.009769s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('吉尔吉斯斯坦U17','也门U17','U17亚洲杯','黑白直播') [ RunTime:0.008155s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.011941s ]
[ SQL ] SELECT `id`,`title`,`category_id` FROM `ww_videotcpe` WHERE `id` IN ( SELECT `app_id` FROM `ww_tag` WHERE `tag_id` IN (23552,20214,14039,99) AND `type` = 'videotcpe' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.001972s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`image`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `status` = 'normal' ORDER BY `id` DESC LIMIT 6 [ RunTime:0.001067s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.157579s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 1664,1000 [ RunTime:0.030742s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (1679,1905,2293,1940,1833,1731,2304,2564,1877,1944,2471,2204,2538,2493,2570,2553,2117,2111,1954,1680,1880,1882,1790,2386,2491) AND `status` = 'normal' [ RunTime:0.006184s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.020771s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.304279s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 86855,1000 [ RunTime:0.069780s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (87000,87239,87683,87669,87850,87126,87474,87451,87800,87294,87259,87040) AND `status` = 'normal' [ RunTime:0.001781s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.002937s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.151577s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 129033,1000 [ RunTime:0.348964s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (129399,129096,129867,129940,129168,129132,129416,129738,129727,129282,129596,129899,129057,129853,129981,129808,129498,129095,129073,129041,129812,129538,129873,129442,129681) AND `status` = 'normal' [ RunTime:0.032146s ]
[ SQL ] UPDATE `ww_live` SET `click_num`=`click_num`+1 WHERE `id` = 122375 [ RunTime:0.016543s ]