[ DB ] CONNECT:[ UseTime:0.037044s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.006599s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001343s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.006491s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 100134 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001075s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 59 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001036s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 5 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000909s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.004731s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','火箭','杜兰特') AND `status` = 'normal' [ RunTime:0.001138s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 100134 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.015636s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 100134 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.157590s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','火箭','杜兰特') [ RunTime:0.007645s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.008122s ]
[ 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 (2,28,13,1) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.656267s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.006792s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `match_id` IN (1) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001270s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.016678s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `match_id` IN (1) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.006881s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.066604s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 14546,1000 [ RunTime:0.021138s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (14984,14920,15041,14560,14628,14779,14870,15261,14751,14624,15078,15480,15152,15306,14648,14662,14649,15454,14973,14734,14738,14562,15076,14687,14846) AND `status` = 'normal' [ RunTime:0.001427s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.254860s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.229310s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 2893,1000 [ RunTime:0.004247s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (3353,3767,3052,3465,3830,3356,3655,3057,3155,3867,3568,3338) AND `status` = 'normal' [ RunTime:0.057270s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.009012s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.166003s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 48672,1000 [ RunTime:0.079624s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (49562,49056,48821,49397,48874,48785,49431,49253,49358,49375,49120,49605,48745,49577,49482,48710,49351,49499,48925,48787,48944,49283,49198,48747,49622) AND `status` = 'normal' [ RunTime:0.104964s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 100134 [ RunTime:0.407620s ]