[ SQL ] SELECT `a`.*,c.name as c_name FROM `cmf_cms_archives` `a` INNER JOIN `cmf_cms_channel` `c` ON `a`.`channel_id`=`c`.`id` LEFT JOIN `cmf_cms_appnews` `cms_appnews` ON `cms_appnews`.`id`=`a`.`id` LEFT JOIN `cmf_cms_appphoto` `cms_appphoto` ON `cms_appphoto`.`id`=`a`.`id` LEFT JOIN `cmf_cms_apppro` `cms_apppro` ON `cms_apppro`.`id`=`a`.`id` LEFT JOIN `cmf_cms_appdown` `cms_appdown` ON `cms_appdown`.`id`=`a`.`id` LEFT JOIN `cmf_cms_appblock` `cms_appblock` ON `cms_appblock`.`id`=`a`.`id` WHERE `a`.`status` = 1 AND `a`.`delete_time` = 0 AND ( `a`.`channel_id` = '13' ) AND ( `a`.`published_time` > 0 and `a`.`published_time` < 1696130674 ) GROUP BY `a`.`id` ORDER BY `published_time` DESC LIMIT 20 [ RunTime:0.000693s ]