[ DB ] CONNECT:[ UseTime:0.023143s ] mysql:dbname=kfw_test;host=rm-8vbr0043pyk836f88ho.mysql.zhangbei.rds.aliyuncs.com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `article_category` [ RunTime:0.015352s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` = 1 [ RunTime:0.014888s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` IN (4,5,6,7,8,9) [ RunTime:0.014863s ]
[ SQL ] SHOW COLUMNS FROM `article` [ RunTime:0.017938s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 4 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015391s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 5 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015104s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 6 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.016683s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 7 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.016533s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 8 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.016659s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 9 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.019046s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` = 2 [ RunTime:0.014811s ]
[ SQL ] SELECT * FROM `article_category` WHERE `parentid` IN (10,11,12,13,14) [ RunTime:0.014812s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` IN (10,11,12,13,14) AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.017287s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 10 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015335s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 11 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015532s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 12 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.020978s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 13 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015064s ]
[ SQL ] SELECT * FROM `article` WHERE `articlecategoryid` = 14 AND `state` = 2 ORDER BY updatetime desc LIMIT 0,5 [ RunTime:0.015107s ]
[ 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.020087s ]