252
341
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-21 04:34:05 HTTP/2.0 GET : https://testm.compassedu.hk/college/1466
- 运行时间 : 0.232758s [ 吞吐率：4.30req/s ] 内存消耗：5,161.88kb 文件加载：145
- 查询信息 : 21 queries
- 缓存信息 : 8 reads,0 writes
- 会话信息 : SESSION_ID=c1f7f770d9db5f65d31357f06b189ffb
- CONNECT:[ UseTime:0.006160s ] mysql:host=172.16.72.151;port=3306;dbname=compassedu;charset=utf8
- SHOW FULL COLUMNS FROM `tb_college_library` [ RunTime:0.004480s ]
- 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` = '1466' AND `cl`.`status` = '2' LIMIT 1 [ RunTime:0.008228s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.008759s ]
- SELECT * FROM `tb_rank_lib` WHERE `brand_id` IN (13,20) AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.009544s ]
- SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.009232s ]
- SELECT `year`,`rank`,`rank_lib_id`,`brand_id` FROM `tb_rank_lib_info` WHERE `college_id` = 1466 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.010172s ]
- SELECT year,rank,brand_id,rank_lib_id,"edur" as url FROM `tb_rank_lib_info` WHERE `college_id` = 1466 AND `rank_lib_id` = 6882 LIMIT 1 [ RunTime:0.008555s ]
- SELECT year,rank,brand_id,rank_lib_id,"rk" as url FROM `tb_rank_lib_info` WHERE `college_id` = 1466 AND `rank_lib_id` = 6604 LIMIT 1 [ RunTime:0.009585s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_abroad` [ RunTime:0.009691s ]
- 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` = 1466 ORDER BY `sort` ASC [ RunTime:0.009701s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_study_assistant` [ RunTime:0.006779s ]
- SELECT `module_title`,`sort`,`jump_url` FROM `tb_collegelib_study_assistant` WHERE `delete_time` IS NULL AND `is_visible` = 1 AND `college_lib_id` = 1466 ORDER BY `sort` ASC [ RunTime:0.005333s ]
- SHOW FULL COLUMNS FROM `tb_collegelib_info` [ RunTime:0.008018s ]
- 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` = '1466' AND `ac`.`status` = '2' AND `information_type` = 2 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 3 [ RunTime:0.010164s ]
- 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` = '1466' AND `ac`.`status` = '2' AND `information_type` = 1 ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 4 [ RunTime:0.009123s ]
- SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.009298s ]
- 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` = '1466' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 5 [ RunTime:0.035709s ]
- 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` = '1466' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' [ RunTime:0.006356s ]
- SELECT ci.article_id as id
,cn.name
,cn.way
,cn.require_compete
,cn.rank
,end_enroll
,(case when start_enroll > "2025-06-21 04:34:05" then 1 when end_enroll < "2025-06-21 04:34:05" then 3 else 2 end) as join_status
,(case when start_enroll > "2025-06-21 04:34:05" then `start_enroll` when end_enroll < "2025-06-21 04:34:05" 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` = '1466' AND `ci`.`information_type` = '3' AND `cn`.`is_deleted` = '1' ORDER BY `end_enroll` DESC,`order_date` ASC LIMIT 0,5 [ RunTime:0.004741s ]
- SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.005460s ]
- SELECT * FROM `tb_handbook` WHERE `type_hb` = 1 AND `college_hb` = 1466 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.005090s ]
0.235949s
