[ DB ] CONNECT:[ UseTime:0.006143s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.131398s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.002751s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.009587s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 101114 AND `status` = 'normal' LIMIT 1 [ RunTime:0.004426s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 59 AND `status` = 'normal' LIMIT 1 [ RunTime:0.003036s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 5 AND `status` = 'normal' LIMIT 1 [ RunTime:0.009697s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.196575s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','热火') AND `status` = 'normal' [ RunTime:0.019344s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 101114 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.053972s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 101114 AND `category_id` IN (59) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009112s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('篮球','NBA','热火') [ RunTime:0.007068s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.008174s ]
[ 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,22,1) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.667303s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.021080s ]
[ 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.026708s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.010092s ]
[ 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.007683s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.051272s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 7139,1000 [ RunTime:0.037936s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (7312,7716,7325,7178,7536,7537,7749,7877,7694,8125,7165,7714,7789,7935,7463,8064,7721,7469,7193,7489,7811,7316,7319,7851,7648) AND `status` = 'normal' [ RunTime:0.003106s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.008664s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.165647s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 43868,1000 [ RunTime:0.095950s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (44583,44199,44767,44202,44390,44015,44263,44849,44453,44548,44842,44216) AND `status` = 'normal' [ RunTime:0.040964s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.004921s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.361178s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 1365,1000 [ RunTime:0.003275s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (2178,1875,1518,1560,1429,1584,1428,1498,1619,1383,1883,1793,1672,1659,2083,2060,1706,2263,2214,1684,1844,2007,1762,1819,2313) AND `status` = 'normal' [ RunTime:0.034669s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 101114 [ RunTime:0.058841s ]