SHOW FULL COLUMNS FROM `tb_collegelib_info` [ RunTime:0.004884s ]
SELECT * FROM `tb_collegelib_info` `mi` LEFT JOIN `tb_collegelib_count` `ic` ON `mi`.`information_id`=`ic`.`id` LEFT JOIN `tb_article_content` `ac` ON `mi`.`article_id`=`ac`.`id` WHERE `deleted_at` IS NULL AND `ac`.`status` = '2' AND `school_id` = '31' AND `information_type` = 1 [ RunTime:0.013388s ]
SELECT distinct mi.article_id as id,`cover`,`title`,`ac`.`desc`,`ac`.`create_at`,`m_reading`,`ac`.`update_at`,`level_limit`,`uc`.`college_cname` FROM `tb_collegelib_info` `mi` LEFT JOIN `tb_collegelib_count` `ic` ON `mi`.`information_id`=`ic`.`id` LEFT JOIN `tb_article_content` `ac` ON `mi`.`article_id`=`ac`.`id` INNER JOIN `tb_college_library` `uc` ON `uc`.`college_id`=`ic`.`school_id` WHERE `deleted_at` IS NULL AND `ac`.`status` = '2' AND `school_id` = '31' AND `information_type` = 1 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 0,30 [ RunTime:0.012152s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005470s ]
SELECT * FROM `tb_university` `u` LEFT JOIN `tb_univ_collegeinfo` `uc` ON `u`.`id_univ`=`uc`.`id` WHERE `u`.`id_univ` = '' LIMIT 1 [ RunTime:0.005083s ]
