[ SQL ] SHOW COLUMNS FROM `ls_cms_archives` [ RunTime:0.001150s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `ls_cms_archives` `a` INNER JOIN `ls_cms_channel` `c` ON `a`.`channel_id`=`c`.`id` LEFT JOIN `ls_cms_apparticle` `cms_apparticle` ON `cms_apparticle`.`id`=`a`.`id` LEFT JOIN `ls_cms_appgg` `cms_appgg` ON `cms_appgg`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND ( `a`.`create_time` >= '0' AND `a`.`delete_time` = '0' ) AND ( `a`.`channel_id` = '30' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1783419652' ) GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.001109s ]
[ SQL ] SELECT `a`.*,c.name as c_name FROM `ls_cms_archives` `a` INNER JOIN `ls_cms_channel` `c` ON `a`.`channel_id`=`c`.`id` LEFT JOIN `ls_cms_apparticle` `cms_apparticle` ON `cms_apparticle`.`id`=`a`.`id` LEFT JOIN `ls_cms_appgg` `cms_appgg` ON `cms_appgg`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND ( `a`.`create_time` >= '0' AND `a`.`delete_time` = '0' ) AND ( `a`.`channel_id` = '30' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1783419652' ) GROUP BY `a`.`id` ORDER BY `a`.`published_time` DESC LIMIT 0,5 [ RunTime:0.001695s ]
0798-8489606
149732881@qq.com
江西省景德镇市珠山区三宝路163号
