SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.005707s ]
SELECT `univ_col_id` FROM `tb_univ_majorinfo` WHERE `id` = 65710 LIMIT 1 [ RunTime:0.005412s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.010653s ]
SELECT `country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 92 LIMIT 1 [ RunTime:0.008986s ]
SHOW FULL COLUMNS FROM `tb_track` [ RunTime:0.010358s ]
SELECT * FROM `tb_track` WHERE `majr_track` = 65710 AND `show_track` = 1 ORDER BY `id` ASC [ RunTime:0.009056s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo_sort` [ RunTime:0.008183s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 92 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '859' LIMIT 1 [ RunTime:0.009639s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 92 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '860' LIMIT 1 [ RunTime:0.009852s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_us` [ RunTime:0.010212s ]
SELECT `ucs`.`sort`,`umt`.`major_detail_cname`,`umt`.`tier`,`n`.`tier_desc` FROM `tb_univ_majorinfo_us` `umu` INNER JOIN `tb_univ_majorinfo_tier` `umt` ON `umu`.`id`=`umt`.`major_id` LEFT JOIN `tb_univ_collegeinfo_sort` `ucs` ON `umt`.`major_detail_id`=ucs.univ_major_class and umu.univ_col_id = ucs.univ_col_id and ucs.is_new = 1 and ucs.sort_type = 2 and ucs.sort_name = 862 LEFT JOIN `tb_newclass` `n` ON `n`.`class_cc`=umt.major_detail_id and n.ctry_cc = 12 WHERE `umu`.`id` = '65710' [ RunTime:0.009807s ]
SELECT `is_stem`,`season`,`edu_years`,`edu_fee`,`class_size`,`avg_gpa`,`avg_g`,`per_inter`,`per_sex`,`per_work`,`salary`,`per_stay` FROM `tb_univ_majorinfo_us` WHERE `id` = 65710 AND `status` = 0 LIMIT 1 [ RunTime:0.009411s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.010151s ]
select distinct cover,hot_cover,c.id,title,create_at,m_reading,school_id,video,c.type,create_at as time,c.level_limit,c.cate_id
from tb_article_content c,tb_major_information d,tb_information_count a
left join tb_univ_majorinfo_us b on a.major_id =b.id and a.school_id=b.univ_col_id
where d.information_id=a.id
and d.article_id=c.id
and d.information_id=a.id
and school_id=92
and a.major_id=65710 and video!=''
order by c.create_at desc
limit 2 [ RunTime:0.005466s ]
select distinct cover,hot_cover,c.id,title,create_at,m_reading,school_id,video,c.type,create_at as time,c.level_limit,c.cate_id
from tb_article_content c,tb_major_information d,tb_information_count a
left join tb_univ_majorinfo_us b on a.major_id =b.id and a.school_id=b.univ_col_id
where d.information_id=a.id
and d.article_id=c.id
and d.information_id=a.id
and school_id=92
and a.major_id=65710 and video=''
order by c.create_at desc
limit 3 [ RunTime:0.014393s ]
SELECT * FROM `tb_univ_majorinfo` WHERE `id` = 65710 LIMIT 1 [ RunTime:0.007791s ]
SHOW FULL COLUMNS FROM `tb_mianshi` [ RunTime:0.005365s ]
SELECT distinct
`id_mianshi`,`avatar`,content_mianshi AS content,c.apyear_cust AS year,`month_mianshi`,type_mianshi AS type,add_mianshi AS address,length_mianshi AS length,cinterviewer_mianshi count,join_time_mianshi AS jointime,`m`.`major_mianshi`,`m`.`cust_mianshi`,`show_mianshi`,`majrshow_mianshi`,`cust_mianshi`,`c`.`name_cust`,`lang_mianshi` FROM `tb_mianshi` `m` LEFT JOIN `tb_univ_majorinfo` `um` ON `m`.`major_mianshi`=`um`.`id` LEFT JOIN `tb_register` `r` ON `m`.`cust_mianshi`=r.uid and r.app=1 LEFT JOIN `tb_custom` `c` ON `c`.`id_cust`=`m`.`cust_mianshi` WHERE `show_mianshi` = 1 AND `majrshow_mianshi` <> 0 AND `major_mianshi` = 65710 AND `cust_mianshi` > 0 ORDER BY field(majrshow_mianshi,1,2),`join_time_mianshi` DESC [ RunTime:0.017939s ]
SHOW FULL COLUMNS FROM `tb_apply_ranking_ds` [ RunTime:0.005466s ]
SELECT * FROM `tb_apply_ranking_ds` WHERE `aply_year` = '2023' AND `country_id` = 12 AND `major_aply` = 65710 ORDER BY `apply_rank` ASC,`type` ASC LIMIT 2 [ RunTime:0.007287s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.005311s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 92 LIMIT 1 [ RunTime:0.006953s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.007349s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 92 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.005306s ]