SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.006366s ]
SELECT `univ_col_id` FROM `tb_univ_majorinfo` WHERE `id` = 67211 LIMIT 1 [ RunTime:0.007859s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.014195s ]
SELECT `country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 87 LIMIT 1 [ RunTime:0.022047s ]
SHOW FULL COLUMNS FROM `tb_track` [ RunTime:0.025013s ]
SELECT * FROM `tb_track` WHERE `majr_track` = 67211 AND `show_track` = 1 ORDER BY `id` ASC [ RunTime:0.016441s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo_sort` [ RunTime:0.007209s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 87 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '859' LIMIT 1 [ RunTime:0.009640s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 87 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '860' LIMIT 1 [ RunTime:0.011588s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_us` [ RunTime:0.005526s ]
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` = '67211' [ RunTime:0.009892s ]
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` = 67211 AND `status` = 0 LIMIT 1 [ RunTime:0.008774s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.012042s ]
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_advisernews` ON `id_news`=`newsid` WHERE `id_univ` = 87 AND `major_news` = 67211 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.009050s ]
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_advisernews` ON `id_news`=`newsid` WHERE `id_clss` = 18 AND `id_univ` = 87 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.006883s ]
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=87
and a.major_id=67211 and video!=''
order by c.create_at desc
limit 2 [ RunTime:0.011876s ]
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=87
and a.major_id=67211 and video=''
order by c.create_at desc
limit 3 [ RunTime:0.006915s ]
SELECT * FROM `tb_univ_majorinfo` WHERE `id` = 67211 LIMIT 1 [ RunTime:0.006693s ]
SHOW FULL COLUMNS FROM `tb_mianshi` [ RunTime:0.007532s ]
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` = 67211 AND `cust_mianshi` > 0 ORDER BY field(majrshow_mianshi,1,2),`join_time_mianshi` DESC [ RunTime:0.010117s ]
SHOW FULL COLUMNS FROM `tb_apply_ranking_ds` [ RunTime:0.007813s ]
SELECT * FROM `tb_apply_ranking_ds` WHERE `aply_year` = '2023' AND `country_id` = 12 AND `major_aply` = 67211 ORDER BY `apply_rank` ASC,`type` ASC LIMIT 2 [ RunTime:0.007618s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.005490s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 87 LIMIT 1 [ RunTime:0.006921s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.006160s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 87 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.007414s ]