[ DB ] CONNECT:[ UseTime:0.021740s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.010988s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.007683s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.003970s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 99769 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 27 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001015s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 7 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000962s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.003078s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','西甲','巴塞罗那','AC米兰','意甲') AND `status` = 'normal' [ RunTime:0.001244s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 99769 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001405s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 99769 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.052211s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','西甲','巴塞罗那','AC米兰','意甲') [ RunTime:0.007629s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.007709s ]
[ 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 (79,421,81,88,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.432815s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.002936s ]
[ 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:0.001109s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.002798s ]
[ 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.000834s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.032098s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 4576,1000 [ RunTime:0.019212s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (5500,5083,5021,4761,4972,5121,5036,5213,4678,5477,5530,5503,5259,4989,5558,4739,4589,4916,5066,4864,5175,5458,5111,4794,5322) AND `status` = 'normal' [ RunTime:0.009513s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.008882s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.153774s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 1959,1000 [ RunTime:0.014033s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (2207,2742,2824,2082,2921,2720,2721,2945,2682,2578,2893,2761) AND `status` = 'normal' [ RunTime:0.004854s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.008242s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.478876s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 46304,1000 [ RunTime:0.069464s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (46554,47225,46785,46971,46606,46843,47302,46725,46455,46383,46949,46621,47146,46328,46972,46514,46997,47110,47211,46916,46868,46442,46605,46839,47162) AND `status` = 'normal' [ RunTime:0.046352s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 99769 [ RunTime:0.207484s ]