SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.004953s ]
SELECT `univ_col_id` FROM `tb_univ_majorinfo` WHERE `id` = 74015 LIMIT 1 [ RunTime:0.010784s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.010663s ]
SELECT `country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 172 LIMIT 1 [ RunTime:0.009067s ]
SHOW FULL COLUMNS FROM `tb_track` [ RunTime:0.009982s ]
SELECT * FROM `tb_track` WHERE `majr_track` = 74015 AND `show_track` = 1 ORDER BY `id` ASC [ RunTime:0.005967s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo_sort` [ RunTime:0.006744s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 172 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '859' LIMIT 1 [ RunTime:0.006104s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 172 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '860' LIMIT 1 [ RunTime:0.008363s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_us` [ RunTime:0.006047s ]
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` = '74015' [ RunTime:0.012153s ]
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` = 74015 AND `status` = 0 LIMIT 1 [ RunTime:0.006796s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.011122s ]
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` = 172 AND `major_news` = 74015 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.010101s ]
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` = 26 AND `id_univ` = 172 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.005290s ]
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 `ctry_news` = 12 AND `id_clss` = 26 AND `star_news` = 1 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.011652s ]
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=172
and a.major_id=74015 and video!=''
order by c.create_at desc
limit 2 [ RunTime:0.007114s ]
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=172
and a.major_id=74015 and video=''
order by c.create_at desc
limit 3 [ RunTime:0.015287s ]
SELECT * FROM `tb_univ_majorinfo` WHERE `id` = 74015 LIMIT 1 [ RunTime:0.018361s ]
SHOW FULL COLUMNS FROM `tb_mianshi` [ RunTime:0.022311s ]
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` = 74015 AND `cust_mianshi` > 0 ORDER BY field(majrshow_mianshi,1,2),`join_time_mianshi` DESC [ RunTime:0.028962s ]
SHOW FULL COLUMNS FROM `tb_apply_ranking_ds` [ RunTime:0.016691s ]
SELECT * FROM `tb_apply_ranking_ds` WHERE `aply_year` = '2023' AND `country_id` = 12 AND `major_aply` = 74015 ORDER BY `apply_rank` ASC,`type` ASC LIMIT 2 [ RunTime:0.007779s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.006361s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 172 LIMIT 1 [ RunTime:0.009622s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.011744s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 172 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.004811s ]