[ SQL ] SHOW COLUMNS FROM `ls_cms_archives` [ RunTime:0.001839s ]
[ 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_appnews` `cms_appnews` ON `cms_appnews`.`id`=`a`.`id` LEFT JOIN `ls_cms_apppage` `cms_apppage` ON `cms_apppage`.`id`=`a`.`id` LEFT JOIN `ls_cms_applx` `cms_applx` ON `cms_applx`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND ( `a`.`channel_id` = '14' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1675744852' ) GROUP BY `a`.`id` ORDER BY `a`.`list_order` ASC,`a`.`published_time` DESC LIMIT 1 [ RunTime:0.003167s ]
[ 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_appnews` `cms_appnews` ON `cms_appnews`.`id`=`a`.`id` LEFT JOIN `ls_cms_apppage` `cms_apppage` ON `cms_apppage`.`id`=`a`.`id` LEFT JOIN `ls_cms_applx` `cms_applx` ON `cms_applx`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND ( `a`.`channel_id` = '1' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1675744852' ) GROUP BY `a`.`id` ORDER BY `a`.`list_order` ASC,`a`.`published_time` DESC LIMIT 1 [ RunTime:0.001802s ]
[ 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_appnews` `cms_appnews` ON `cms_appnews`.`id`=`a`.`id` LEFT JOIN `ls_cms_apppage` `cms_apppage` ON `cms_apppage`.`id`=`a`.`id` LEFT JOIN `ls_cms_applx` `cms_applx` ON `cms_applx`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND `a`.`is_top` = '1' AND ( `a`.`channel_id` IN ('8','9','10','11','12','13','2') ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1675744852' ) GROUP BY `a`.`id` ORDER BY `a`.`list_order` ASC,`a`.`published_time` DESC LIMIT 4 [ RunTime:0.002625s ]