415
751
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-21 03:57:52 HTTP/2.0 GET : https://testm.compassedu.hk/college/2031
- 运行时间 : 0.581125s [ 吞吐率：1.72req/s ] 内存消耗：5,296.52kb 文件加载：146
- 查询信息 : 21 queries
- 缓存信息 : 8 reads,0 writes
- 会话信息 : SESSION_ID=405af91b87dffd3e48b64b469adf403c
- CONNECT:[ UseTime:0.023755s ] mysql:host=172.16.72.151;port=3306;dbname=compassedu;charset=utf8
- SHOW FULL COLUMNS FROM `tb_college_library` [ RunTime:0.004725s ]
- 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` = '2031' AND `cl`.`status` = '2' LIMIT 1 [ RunTime:0.004474s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.012850s ]
- SELECT * FROM `tb_rank_lib` WHERE `brand_id` IN (13,20) AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.006547s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.006819s ]
- SELECT `year`,`rank`,`rank_lib_id`,`brand_id` FROM `tb_rank_lib_info` WHERE `college_id` = 2031 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.010248s ]
- SELECT year,rank,brand_id,rank_lib_id,"edur" as url FROM `tb_rank_lib_info` WHERE `college_id` = 2031 AND `rank_lib_id` = 6882 LIMIT 1 [ RunTime:0.027463s ]
- SELECT year,rank,brand_id,rank_lib_id,"rk" as url FROM `tb_rank_lib_info` WHERE `college_id` = 2031 AND `rank_lib_id` = 6604 LIMIT 1 [ RunTime:0.006614s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_abroad` [ RunTime:0.007049s ]
- 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` = 2031 ORDER BY `sort` ASC [ RunTime:0.009009s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_assistant` [ RunTime:0.016089s ]
- SELECT `module_title`,`sort`,`jump_url` FROM `tb_collegelib_study_assistant` WHERE `delete_time` IS NULL AND `is_visible` = 1 AND `college_lib_id` = 2031 ORDER BY `sort` ASC [ RunTime:0.023836s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_info` [ RunTime:0.024894s ]
- 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` = '2031' AND `ac`.`status` = '2' AND `information_type` = 2 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 3 [ RunTime:0.025883s ]
- 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` = '2031' AND `ac`.`status` = '2' AND `information_type` = 1 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 4 [ RunTime:0.026518s ]
- SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.024833s ]
- 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` = '2031' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 5 [ RunTime:0.206445s ]
- 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` = '2031' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' [ RunTime:0.027297s ]
- 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:57:52" then 1 when end_enroll < "2025-06-21 03:57:52" then 3 else 2 end) as join_status
,(case when start_enroll > "2025-06-21 03:57:52" then `start_enroll` when end_enroll < "2025-06-21 03:57:52" 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` = '2031' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' ORDER BY `end_enroll` DESC,`order_date` ASC LIMIT 0,5 [ RunTime:0.016099s ]
- SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.006264s ]
- SELECT * FROM `tb_handbook` WHERE `type_hb` = 1 AND `college_hb` = 2031 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.005247s ]
0.586020s
