[ DB ] CONNECT:[ UseTime:0.000887s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.003957s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001335s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.002481s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 99809 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001104s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 27 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000958s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 7 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000920s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.002864s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','意甲','比利时','意大利') AND `status` = 'normal' [ RunTime:0.227860s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 99809 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005473s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 99809 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.012082s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','意甲','比利时','意大利') [ RunTime:0.007604s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.010726s ]
[ 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 (608,81,3920,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:3.225350s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.040047s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `match_id` IN (47) ORDER BY `id` DESC LIMIT 10 [ RunTime:1.231530s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.013095s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `match_id` IN (47) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.007624s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.100599s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 8372,1000 [ RunTime:0.059051s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (8596,8578,8731,8492,9354,8859,9248,8514,8759,8890,9125,9239,8734,9234,9071,8448,9137,9246,8389,8897,8634,9163,8538,8817,8393) AND `status` = 'normal' [ RunTime:0.053012s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.011670s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.697635s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 75116,1000 [ RunTime:0.062290s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (76096,76010,75602,75792,76063,75409,76075,75933,75859,75290,75629,75685) AND `status` = 'normal' [ RunTime:0.278537s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.041412s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.216180s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 197554,1000 [ RunTime:0.119480s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (198487,198296,197757,197820,197592,198533,197739,198274,198255,198138,198269,198182,198024,197744,198093,197685,197908,197823,197840,197778,198246,198226,197794,197915,197843) AND `status` = 'normal' [ RunTime:0.783759s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 99809 [ RunTime:0.164800s ]