[ DB ] CONNECT:[ UseTime:0.001604s ] mysql:dbname=wx;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `y_sys` [ RunTime:0.000890s ]
[ SQL ] SELECT `cont` FROM `y_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SHOW COLUMNS FROM `y_wx_0000` [ RunTime:0.000944s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `y_wx_0000` WHERE `numberid` = 861 AND `state` = 1 AND `pubdate` BETWEEN 1546272000 AND 1577807999 LIMIT 1 [ RunTime:0.001147s ]
[ SQL ] SELECT sum(click) as num FROM `y_wx_0000` WHERE `numberid` = 861 AND `state` = 1 AND `pubdate` BETWEEN 1614182400 AND 1614268799 GROUP BY click LIMIT 1 [ RunTime:0.000780s ]
[ SQL ] SELECT `id`,`title`,`pubdate`,`litpic`,`click`,`like`,`number_type_id`,`numberid`,`keywords`,`description`,`article_type`,`w_click` FROM `y_wx_0000` WHERE `numberid` = 861 AND `state` = 1 AND `pubdate` BETWEEN 1546272000 AND 1577807999 ORDER BY pubdate desc LIMIT 0,20 [ RunTime:0.001895s ]
[ SQL ] SELECT `id`,`title`,`pubdate`,`litpic`,`click`,`like`,`number_type_id`,`numberid`,`keywords`,`description`,`article_type`,`w_click`,id as test_id FROM `y_wx_0000` WHERE `state` = 1 AND `number_type_id` = 6 ORDER BY click desc LIMIT 0,10 [ RunTime:1.012785s ]
