[ 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.000660s ]
[ SQL ] SHOW COLUMNS FROM `ls_cms_archives` [ RunTime:0.001102s ]
[ 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_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` = '51' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1653415266' ) GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.002369s ]
[ 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` = '51' ) AND ( `a`.`published_time` > '0' and `a`.`published_time` < '1653415266' ) GROUP BY `a`.`id` ORDER BY `list_order` ASC,`create_time` DESC LIMIT 0,40 [ RunTime:0.003738s ]
大学排名
