[ DB ] CONNECT:[ UseTime:0.007337s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.102565s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.005146s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.010604s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 99970 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007587s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 24 AND `status` = 'normal' LIMIT 1 [ RunTime:0.006635s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 7 AND `status` = 'normal' LIMIT 1 [ RunTime:0.007617s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.008735s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','中超','中国足球') AND `status` = 'normal' [ RunTime:0.211696s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 99970 AND `category_id` IN (24) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.024550s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 99970 AND `category_id` IN (24) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.024543s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','中超','中国足球') [ RunTime:0.007816s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.007542s ]
[ 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 (498,497,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.522595s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.005919s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_highlights` WHERE `match_id` IN (3) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001188s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.024142s ]
[ SQL ] SELECT `id`,`title`,`image`,`createtime`,`seo_description`,`category_id` FROM `ww_videotcpe` WHERE `match_id` IN (3) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.005739s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.163546s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 17745,1000 [ RunTime:0.025076s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (18277,17761,17928,17930,17903,18736,18385,18020,18497,18430,18183,18418,18581,17919,17997,18006,18657,18454,18079,18107,18702,18295,17846,18552,18477) AND `status` = 'normal' [ RunTime:0.001211s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.007844s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.264517s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 97079,1000 [ RunTime:0.092410s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (97508,97187,97831,97242,97095,97324,97694,97381,97277,97205,97405,97811) AND `status` = 'normal' [ RunTime:0.001681s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.006344s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.361399s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 87519,1000 [ RunTime:0.282052s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (88409,87831,88504,88510,88036,87862,88487,88299,87893,87953,87977,88217,87592,88047,88442,87872,87859,87644,88037,87745,88162,88222,87762,88267,88389) AND `status` = 'normal' [ RunTime:0.008284s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 99970 [ RunTime:0.028888s ]