492
991
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-21 03:28:30 HTTP/2.0 GET : https://testm.compassedu.hk/college/2094
- 运行时间 : 0.400362s [ 吞吐率：2.50req/s ] 内存消耗：5,296.21kb 文件加载：146
- 查询信息 : 21 queries
- 缓存信息 : 8 reads,0 writes
- 会话信息 : SESSION_ID=e361913d459cffc0f9093b4e27da6b65
- CONNECT:[ UseTime:0.007249s ] mysql:host=172.16.72.151;port=3306;dbname=compassedu;charset=utf8
- SHOW FULL COLUMNS FROM `tb_college_library` [ RunTime:0.004560s ]
- SELECT `college_id`,`college_cname`,`c`.`college_ename`,`college_desc`,`graduate_direction`,`categories`,`features`,`adviser_id`,`research_project`,`exchange_project`,`elective_course`,`c`.`province_code`,`c`.`address`,`location`,`cl`.`recordlist_url` FROM `tb_college_library` `cl` LEFT JOIN `tb_colleges` `c` ON `c`.`id`=cl.college_id and c.college_type=1 WHERE `cl`.`college_id` = '2094' AND `cl`.`status` = '2' LIMIT 1 [ RunTime:0.005830s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.006427s ]
- SELECT * FROM `tb_rank_lib` WHERE `brand_id` IN (13,20) AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.005149s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.005102s ]
- SELECT `year`,`rank`,`rank_lib_id`,`brand_id` FROM `tb_rank_lib_info` WHERE `college_id` = 2094 AND `rank_lib_id` IN (2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,6018,6019,6020,6021,6022,6023,6024,6025,6026,6027,6604,6736,6737,6738,6739,6740,6741,6742,6743,6744,6745,6881,6882,7025) ORDER BY `brand_id` ASC,`year` ASC [ RunTime:0.004494s ]
- SELECT year,rank,brand_id,rank_lib_id,"edur" as url FROM `tb_rank_lib_info` WHERE `college_id` = 2094 AND `rank_lib_id` = 6882 LIMIT 1 [ RunTime:0.004408s ]
- SELECT year,rank,brand_id,rank_lib_id,"rk" as url FROM `tb_rank_lib_info` WHERE `college_id` = 2094 AND `rank_lib_id` = 6604 LIMIT 1 [ RunTime:0.004364s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_abroad` [ RunTime:0.006913s ]
- SELECT `college_lib_id`,`seat`,`module_title`,`module_content`,`picture`,`sort` FROM `tb_collegelib_study_abroad` WHERE `delete_time` IS NULL AND `is_visible` = 1 AND `college_lib_id` = 2094 ORDER BY `sort` ASC [ RunTime:0.004714s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_assistant` [ RunTime:0.005435s ]
- SELECT `module_title`,`sort`,`jump_url` FROM `tb_collegelib_study_assistant` WHERE `delete_time` IS NULL AND `is_visible` = 1 AND `college_lib_id` = 2094 ORDER BY `sort` ASC [ RunTime:0.004479s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_info` [ RunTime:0.005375s ]
- SELECT `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`.`level_limit` 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 `school_id` = '2094' AND `ac`.`status` = '2' AND `information_type` = 2 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 3 [ RunTime:0.006528s ]
- SELECT `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`.`level_limit` 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 `school_id` = '2094' AND `ac`.`status` = '2' AND `information_type` = 1 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 4 [ RunTime:0.005824s ]
- SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.005831s ]
- SELECT distinct id_news,`title_news`,`time_news`,`cname_news`,`cuniv_news`,`cmajr_news`,`detail_news`,`id_univ`,`newsid` FROM `tb_news` LEFT JOIN `tb_college_library` `cl` ON trim(cuniv_news)=`cl`.`college_cname` LEFT JOIN `tb_advisernews` ON `id_news`=`newsid` WHERE ( type_news in ('succ') ) AND `cl`.`college_id` = '2094' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 5 [ RunTime:0.208954s ]
- SELECT COUNT(*) AS think_count FROM `tb_collegelib_info` `ci` LEFT JOIN `tb_collegelib_count` `ic` ON `ci`.`information_id`=`ic`.`id` LEFT JOIN `tb_competition_new` `cn` ON `cn`.`id_compete`=ci.article_id and cn.is_deleted=1 and cn.status=2 WHERE `ic`.`school_id` = '2094' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' [ RunTime:0.007689s ]
- SELECT ci.article_id as id
,cn.name
,cn.way
,cn.require_compete
,cn.rank
,end_enroll
,(case when start_enroll > "2025-06-21 03:28:30" then 1 when end_enroll < "2025-06-21 03:28:30" then 3 else 2 end) as join_status
,(case when start_enroll > "2025-06-21 03:28:30" then `start_enroll` when end_enroll < "2025-06-21 03:28:30" then `end_enroll` else `end_enroll` end) as order_date FROM `tb_collegelib_info` `ci` LEFT JOIN `tb_collegelib_count` `ic` ON `ci`.`information_id`=`ic`.`id` LEFT JOIN `tb_competition_new` `cn` ON `cn`.`id_compete`=ci.article_id and cn.is_deleted=1 and cn.status=2 WHERE `ic`.`school_id` = '2094' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' ORDER BY `end_enroll` DESC,`order_date` ASC LIMIT 0,5 [ RunTime:0.006358s ]
- SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.005551s ]
- SELECT * FROM `tb_handbook` WHERE `type_hb` = 1 AND `college_hb` = 2094 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.007444s ]
0.403611s
