[ DB ] CONNECT:[ UseTime:0.000868s ] mysql:host=127.0.0.1;dbname=blcscreens_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ww_category` [ RunTime:0.003983s ]
[ SQL ] SELECT `id`,`name`,`type`,`flag`,`pid`,`image`,`nickname`,`url`,`diyname` FROM `ww_category` ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.001081s ]
[ SQL ] SHOW COLUMNS FROM `ww_news` [ RunTime:0.004090s ]
[ SQL ] SELECT * FROM `ww_news` WHERE `id` = 99473 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000897s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 27 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000982s ]
[ SQL ] SELECT * FROM `ww_category` WHERE `id` = 7 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000905s ]
[ SQL ] SHOW COLUMNS FROM `ww_taglist` [ RunTime:0.002954s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `name` IN ('足球','国家队','丹麦','葡萄牙','意甲','AC米兰') AND `status` = 'normal' [ RunTime:0.235587s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` < 99473 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003036s ]
[ SQL ] SELECT `id`,`title` FROM `ww_news` WHERE `id` > 99473 AND `category_id` IN (27) AND `status` = 'normal' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.168927s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `name` IN ('足球','国家队','丹麦','葡萄牙','意甲','AC米兰') [ RunTime:0.018640s ]
[ SQL ] SHOW COLUMNS FROM `ww_tag` [ RunTime:0.011137s ]
[ 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,778,397,81,750,373) AND `type` = 'news' ) ORDER BY `id` DESC LIMIT 8 [ RunTime:0.980208s ]
[ SQL ] SHOW COLUMNS FROM `ww_highlights` [ RunTime:0.007666s ]
[ 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.003587s ]
[ SQL ] SHOW COLUMNS FROM `ww_videotcpe` [ RunTime:0.007582s ]
[ 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.006682s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_taglist` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.062073s ]
[ SQL ] SELECT `id` FROM `ww_taglist` WHERE `status` = 'normal' ORDER BY `id` LIMIT 6060,1000 [ RunTime:0.014107s ]
[ SQL ] SELECT `id`,`name` FROM `ww_taglist` WHERE `id` IN (6090,6625,6809,6664,7062,6424,6381,7012,6548,6827,6918,6567,6317,6068,6661,7046,6445,6843,7005,6906,6878,6648,6368,6113,6762) AND `status` = 'normal' [ RunTime:0.003376s ]
[ SQL ] SHOW COLUMNS FROM `ww_inter` [ RunTime:0.003407s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_inter` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.101025s ]
[ SQL ] SELECT `id` FROM `ww_inter` WHERE `status` = 'normal' ORDER BY `id` LIMIT 93215,1000 [ RunTime:0.071978s ]
[ SQL ] SELECT `id`,`title` FROM `ww_inter` WHERE `id` IN (93362,93496,94130,93406,93290,94091,93292,93943,93382,93411,93792,93672) AND `status` = 'normal' [ RunTime:0.001896s ]
[ SQL ] SHOW COLUMNS FROM `ww_search` [ RunTime:0.019545s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ww_search` WHERE `status` = 'normal' LIMIT 1 [ RunTime:0.408963s ]
[ SQL ] SELECT `id` FROM `ww_search` WHERE `status` = 'normal' ORDER BY `id` LIMIT 117911,1000 [ RunTime:0.256669s ]
[ SQL ] SELECT `id`,`title` FROM `ww_search` WHERE `id` IN (118510,118148,118628,118765,118574,118829,117968,118280,117985,118477,118868,118013,118204,118531,118243,117993,118077,118127,118122,118463,118583,118177,118040,118136,117998) AND `status` = 'normal' [ RunTime:0.004090s ]
[ SQL ] UPDATE `ww_news` SET `click_num`=`click_num`+1 WHERE `id` = 99473 [ RunTime:0.116595s ]