SHOW FULL COLUMNS FROM `tb_collegelib_info` [ RunTime:0.004738s ]
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` = '667' AND `information_type` = 2 [ RunTime:0.006119s ]
SELECT distinct `mi`.`id`,`mi`.`article_id`,`mi`.`information_type`,`mi`.`is_top`,`ac`.`create_at`,`ac`.`title`,`ac`.`reading`,`ac`.`m_reading`,`ac`.`mp_reading`,`ac`.`web_reading`,`ac`.`desc`,`ac`.`video`,`ac`.`video_length`,`ac`.`cover`,`ac`.`hot_cover`,`ac`.`type`,`ac`.`tags`,`ac`.`create_at`,`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` = '667' AND `information_type` = 2 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 0,30 [ RunTime:0.006100s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005559s ]
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.005405s ]