[ SQL ] SELECT * FROM `ls_cms_channel` WHERE `status` = 1 AND `delete_time` = 0 AND `id` IN (1,2,3,4,5,6,7,8) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000742s ]
[ SQL ] select * from ls_cms_archives as a left join ls_cms_applxsq as b on a.id = b.id where a.status=1 and a.delete_time = 0 and a.channel_id ='10' order by a.id asc limit 0,1 [ RunTime:0.000548s ]
[ SQL ] SHOW COLUMNS FROM `ls_cms_archives` [ RunTime:0.000907s ]
[ 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_appvedio` `cms_appvedio` ON `cms_appvedio`.`id`=`a`.`id` LEFT JOIN `ls_cms_appschool` `cms_appschool` ON `cms_appschool`.`id`=`a`.`id` LEFT JOIN `ls_cms_appteacher` `cms_appteacher` ON `cms_appteacher`.`id`=`a`.`id` LEFT JOIN `ls_cms_applxsq` `cms_applxsq` ON `cms_applxsq`.`id`=`a`.`id` LEFT JOIN `ls_cms_apprypx` `cms_apprypx` ON `cms_apprypx`.`id`=`a`.`id` LEFT JOIN `ls_cms_apptskc` `cms_apptskc` ON `cms_apptskc`.`id`=`a`.`id` LEFT JOIN `ls_cms_appzpj` `cms_appzpj` ON `cms_appzpj`.`id`=`a`.`id` LEFT JOIN `ls_cms_appsyjh` `cms_appsyjh` ON `cms_appsyjh`.`id`=`a`.`id` LEFT JOIN `ls_cms_appask` `cms_appask` ON `cms_appask`.`id`=`a`.`id` LEFT JOIN `ls_cms_apprxfd` `cms_apprxfd` ON `cms_apprxfd`.`id`=`a`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' AND ( `a`.`channel_id` = '5' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1653421158' ) GROUP BY `a`.`id` ORDER BY `a`.`list_order` ASC,`a`.`published_time` DESC LIMIT 10 [ RunTime:0.003970s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `type_id` IN (37,38,41,49,52,53,54,55,56,57,58,59,60,61) AND `status` = 1 AND `delete_time` = 0 ORDER BY `create_time` DESC LIMIT 0,4 [ RunTime:0.001090s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `status` = 1 AND `delete_time` = 0 ORDER BY `hits` DESC LIMIT 4,6 [ RunTime:0.001016s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `status` = 1 AND `delete_time` = 0 ORDER BY `hits` DESC LIMIT 10,6 [ RunTime:0.001051s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `status` = 1 AND `delete_time` = 0 ORDER BY `hits` DESC LIMIT 16,6 [ RunTime:0.000881s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `status` = 1 AND `delete_time` = 0 ORDER BY `hits` DESC LIMIT 22,6 [ RunTime:0.000816s ]
[ SQL ] SELECT * FROM `ls_cms_archives` WHERE `id` IN (229,182,207,437,181,167,2,570,576,577,578,579,409,184,122,418,420,421,519,547,551,560,552,575,586,587,588,589,590,608,611,613,614,615,616,654,726,729,735,737,711,813,839,890,995,1001,1551,2115,2126,2127,2157,2168) AND `channel_id` = 25 AND `status` = 1 AND `delete_time` = 0 ORDER BY `create_time` DESC LIMIT 0,8 [ RunTime:0.000772s ]