[ DB ] CONNECT:[ UseTime:0.027194s ] mysql:dbname=kfw_test;host=rm-8vbr0043pyk836f88ho.mysql.zhangbei.rds.aliyuncs.com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `article_category` [ RunTime:0.016017s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` = 1 [ RunTime:0.015533s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` IN (4,5,6,7,8,9) [ RunTime:0.015538s ]
[ SQL ] SHOW COLUMNS FROM `article` [ RunTime:0.015986s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 4 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015992s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 5 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015773s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 6 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.017413s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 7 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015727s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 8 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015693s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 9 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015685s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` = 2 [ RunTime:0.015487s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` IN (10,11,12,13,14) [ RunTime:0.021246s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` IN (10,11,12,13,14) AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.020807s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 10 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.017687s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 11 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.018767s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 12 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.018839s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 13 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.017809s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 14 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.018782s ]
[ SQL ] SELECT `id`,`title`,`createtime`,`total` FROM `article` WHERE `createtime` <= 1751212800 AND `state` = 2 AND `articlecategoryid` > 0 ORDER BY total desc LIMIT 5 [ RunTime:0.024641s ]