SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.005857s ]
SELECT `univ_col_id` FROM `tb_univ_majorinfo` WHERE `id` = 73853 LIMIT 1 [ RunTime:0.008537s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.010400s ]
SELECT `country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 147 LIMIT 1 [ RunTime:0.009046s ]
SHOW FULL COLUMNS FROM `tb_track` [ RunTime:0.005125s ]
SELECT * FROM `tb_track` WHERE `majr_track` = 73853 AND `show_track` = 1 ORDER BY `id` ASC [ RunTime:0.010651s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_us` [ RunTime:0.012203s ]
SELECT `uc`.`country_id`,`uc`.`univ_name`,`uc`.`univ_ename`,`univ_col_id`,`umu`.`id`,`major_cname`,`major_ename`,`toefl_ac`,`toefl_total`,`toefl_min`,`toefl_send`,`ielts_ac`,`ielts_total`,`ielts_min`,`ielts_send`,`gmat_ac`,`gmat_total`,`gmat_min`,`gmat_send`,`gre_ac`,`gre_total`,`gre_min`,`gre_send`,`edu_ddl`,`viewpoint`,`pre_course`,`major_detail_id`,`major_detail_cname`,`uc`.`is_njstar`,`track`,major_detail_cname as major_detail_name,`major_id` FROM `tb_univ_majorinfo_us` `umu` LEFT JOIN `tb_univ_collegeinfo` `uc` ON `uc`.`id`=`umu`.`univ_col_id` WHERE `umu`.`id` = '73853' AND `umu`.`status` = '0' LIMIT 1 [ RunTime:0.010225s ]
SELECT `id`,`id_schl`,`school_id`,`cname_schl`,`mianshi`,`major_ename` FROM `tb_univ_majorinfo` LEFT JOIN `tb_school` `sch` ON `school_id`=`id_schl` WHERE ( id=73853 ) LIMIT 1 [ RunTime:0.008001s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo_sort` [ RunTime:0.009187s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 147 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '859' LIMIT 1 [ RunTime:0.009275s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 147 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '860' LIMIT 1 [ RunTime:0.009880s ]
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` = '73853' [ RunTime:0.007340s ]
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` = 73853 AND `status` = 0 LIMIT 1 [ RunTime:0.004560s ]
SELECT `major_id`,`major_detail_name` FROM `tb_univ_majorinfo` WHERE ( id=73853 ) LIMIT 1 [ RunTime:0.007731s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.013563s ]
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` = 147 AND `major_news` = 73853 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.008777s ]
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` = 46 AND `id_univ` = 147 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.009173s ]
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` = 46 AND `star_news` = 1 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.008306s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.010744s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=23184 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009968s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=23006 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009578s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22521 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009560s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=18586 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.005187s ]
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=147
and a.major_id=73853 and video!=''
order by c.create_at desc
limit 2 [ RunTime:0.014148s ]
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=147
and a.major_id=73853 and video=''
order by c.create_at desc
limit 3 [ RunTime:0.005916s ]
SELECT * FROM `tb_univ_majorinfo` WHERE `id` = 73853 LIMIT 1 [ RunTime:0.005619s ]
SHOW FULL COLUMNS FROM `tb_mianshi` [ RunTime:0.004977s ]
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` = 73853 AND `cust_mianshi` > 0 ORDER BY field(majrshow_mianshi,1,2),`join_time_mianshi` DESC [ RunTime:0.012899s ]
SHOW FULL COLUMNS FROM `tb_apply_ranking_ds` [ RunTime:0.006191s ]
SELECT * FROM `tb_apply_ranking_ds` WHERE `aply_year` = '2023' AND `country_id` = 12 AND `major_aply` = 73853 ORDER BY `apply_rank` ASC,`type` ASC LIMIT 2 [ RunTime:0.009887s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.009773s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 147 LIMIT 1 [ RunTime:0.005247s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.014307s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 147 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.009386s ]