SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.005414s ]
SELECT `univ_col_id` FROM `tb_univ_majorinfo` WHERE `id` = 76364 LIMIT 1 [ RunTime:0.007514s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.010835s ]
SELECT `country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 299 LIMIT 1 [ RunTime:0.008467s ]
SELECT `a`.*,`b`.`sort`,`uc`.`country_id`,`univ_name`,`univ_ename`,uc.id as id_univ,`uc`.`is_njstar`,a.viewpoint as viewpoint,a.major_detail_name as major_detail_name,`cname_schl` FROM `tb_univ_majorinfo` `a` LEFT JOIN `tb_univ_collegeinfo_sort` `b` ON `a`.`univ_col_id`=b.univ_col_id and a.major_detail_id = b.univ_major_class and b.sort_type =2 and b.sort_name= 862 and b.is_new =1 LEFT JOIN `tb_univ_collegeinfo` `uc` ON `a`.`univ_col_id`=`uc`.`id` LEFT JOIN `tb_school` `sch` ON `sch`.`id_schl`=`a`.`school_id` WHERE `a`.`id` = '76364' LIMIT 1 [ RunTime:0.008723s ]
SHOW FULL COLUMNS FROM `tb_classes` [ RunTime:0.009721s ]
SELECT `cname_clss` FROM `tb_classes` WHERE `id_clss` = 15 LIMIT 1 [ RunTime:0.009263s ]
SHOW FULL COLUMNS FROM `tb_school` [ RunTime:0.010069s ]
SELECT id_schl as id,cname_schl as name FROM `tb_school` WHERE `id_schl` IS NULL LIMIT 1 [ RunTime:0.009587s ]
SELECT `id`,`univ_name`,`univ_ename`,`imageurl`,`country_id` FROM `tb_univ_collegeinfo` WHERE `id` = 299 LIMIT 1 [ RunTime:0.009790s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_fee` [ RunTime:0.010461s ]
SELECT major_info_id as major_id,`money_type`,`fee` FROM `tb_univ_majorinfo_fee` WHERE `major_info_id` IS NULL AND `is_new` = 1 AND `is_show` = 1 [ RunTime:0.009303s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=76364 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.008411s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_applytime` [ RunTime:0.005170s ]
SELECT `id`,`start_time`,`end_time`,`major_info_id`,`year`,`enroll_time` FROM `tb_univ_majorinfo_applytime` WHERE `major_info_id` = 76364 AND `is_new` = 1 AND `is_show` = 1 ORDER BY `year` ASC,`start_time` [ RunTime:0.005177s ]
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo_sort` [ RunTime:0.010018s ]
SELECT `sort` FROM `tb_univ_collegeinfo_sort` WHERE `univ_col_id` = 299 AND `is_new` = 1 AND `sort_type` = 1 AND `sort_name` = '859' LIMIT 1 [ RunTime:0.009574s ]
SHOW FULL COLUMNS FROM `tb_data_applyoffer_base` [ RunTime:0.006355s ]
SELECT `report_id`,`pass_count`,`fail_count`,`pass_rate` FROM `tb_data_applyoffer_base` WHERE `applyschoolid` = 299 AND `applymajortypedetailid` = 15 LIMIT 1 [ RunTime:0.012087s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.010721s ]
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` = 299 AND `major_news` = 76364 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.008785s ]
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` = 15 AND `id_univ` = 299 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.007205s ]
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` = 10 AND `id_clss` = 15 AND `star_news` = 1 AND 1 = 1 AND `type_news` = 'succ' ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.012797s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.006068s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=20705 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009969s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=18885 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.008542s ]
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=299
and a.major_id=76364 and video!=''
order by c.create_at desc
limit 2 [ RunTime:0.009840s ]
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=299
and a.major_id=76364 and video=''
order by c.create_at desc
limit 3 [ RunTime:0.010049s ]
SHOW FULL COLUMNS FROM `tb_mianshi` [ RunTime:0.008559s ]
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` = 76364 AND `cust_mianshi` > 0 ORDER BY field(majrshow_mianshi,1,2),`join_time_mianshi` DESC [ RunTime:0.013010s ]
SHOW FULL COLUMNS FROM `tb_apply_ranking` [ RunTime:0.006213s ]
SELECT * FROM `tb_apply_ranking` WHERE `aply_year` = '2022' AND `country_id` IN (10,11) AND ( major_aply=76364 ) LIMIT 1 [ RunTime:0.009903s ]
SELECT * FROM `tb_apply_ranking` WHERE `aply_year` = '2022' AND `country_id` IN (10,11) AND ( apply_count>=0 ) ORDER BY `apply_count` DESC,`major_aply` ASC [ RunTime:0.014248s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.012258s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 299 LIMIT 1 [ RunTime:0.009364s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.010198s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 299 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.009308s ]