[ DB ] CONNECT:[ UseTime:0.001556s ] mysql:dbname=wx;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `y_sys` [ RunTime:0.000786s ]
[ SQL ] SELECT `cont` FROM `y_sys` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000401s ]
[ SQL ] SHOW COLUMNS FROM `y_hot_destory` [ RunTime:0.000958s ]
[ SQL ] SELECT `pubdate` FROM `y_hot_destory` WHERE `numberid` = 1938 ORDER BY pubdate asc LIMIT 1 [ RunTime:0.975792s ]
[ SQL ] SELECT `pubdate` FROM `y_hot_destory` WHERE `numberid` = 1938 ORDER BY pubdate desc LIMIT 1 [ RunTime:0.478067s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `y_hot_destory` WHERE `year` = 2017 AND `numberid` = 1938 LIMIT 1 [ RunTime:0.000915s ]
[ SQL ] SHOW COLUMNS FROM `y_wx_0000` [ RunTime:0.000501s ]
[ SQL ] SELECT sum(click) as num FROM `y_wx_0000` WHERE `numberid` = 1938 AND `state` = 1 AND `pubdate` BETWEEN 1614182400 AND 1614268799 GROUP BY click LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `pubdate` FROM `y_wx_0000` WHERE `numberid` = 1938 AND `state` = 1 ORDER BY pubdate asc LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT `pubdate` FROM `y_wx_0000` WHERE `numberid` = 1938 AND `state` = 1 ORDER BY pubdate desc LIMIT 1 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `y_hot_destory` WHERE `year` = 2017 AND `numberid` = 1938 ORDER BY click desc LIMIT 0,20 [ RunTime:0.000829s ]
