霍恩海姆大学(德语:Universität Hohenheim;英语:University of Hohenheim)位于德国巴登-符腾堡州首府斯图加特市南郊,前身为德国国立农学院,是欧洲顶尖的农科学府,欧洲生命科学基础协会(ELLS)成员。霍恩海姆大学规模较小,下辖仅三个学院:农科院、理科院和经济社科学院,重点授课方向主要以农业科学、自然科学和经济学为主,研究产出与学术声誉高。
SHOW FULL COLUMNS FROM `tb_univ_collegeinfo` [ RunTime:0.005035s ]
SELECT * FROM `tb_univ_collegeinfo` WHERE `id` = 1196 LIMIT 1 [ RunTime:0.009505s ]
SHOW FULL COLUMNS FROM `tb_article_content` [ RunTime:0.008761s ]
SELECT `title`,`id` FROM `tb_article_content` WHERE `status` = 2 AND `type` = 101 AND `title` = '欧盟生命自然科学基础协会成员' ORDER BY `create_at` DESC [ RunTime:0.011139s ]
select distinct b.year,sort
from tb_univ_collegeinfo_sort b,(select max(year) as yea
from tb_univ_collegeinfo_sort b
where b.univ_col_id =1196
and b.sort_type =1
and sort_name=859
and is_show=1) a
where b.univ_col_id =1196
and b.sort_type =1
and sort_name=859
and is_show=1
and year in (a.yea-2,a.yea-1,a.yea)
order by b.year desc
limit 3 [ RunTime:0.008237s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo` [ RunTime:0.007832s ]
SELECT `a`.`id`,`a`.`major_detail_id`,`b`.`sort`,`school_id`,`major_cname`,`major_ename`,`major_detail_name`,aply_count as count,`a`.`univ_col_id` 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 WHERE `a`.`univ_col_id` = '1196' AND `a`.`is_show` = '1' AND `a`.`status` = '0' ORDER BY `aply_count` DESC,left(major_allname_py,1) ASC LIMIT 6 [ RunTime:0.011555s ]
select count(distinct school_id) as count from tb_univ_majorinfo where univ_col_id=1196 [ RunTime:0.009791s ]
select count(distinct id) as count from tb_univ_majorinfo where univ_col_id=1196 [ RunTime:0.010078s ]
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.011174s ]
SELECT DISTINCT n.*,`newsid` FROM `tb_news` `n` LEFT JOIN `tb_advisernews` ON `id_news`=`newsid` WHERE ( type_news in ('succ','acpt') ) AND `id_univ` = 1196 ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.008579s ]
SELECT DISTINCT n.*,`newsid` FROM `tb_news` `n` LEFT JOIN `tb_advisernews` ON `id_news`=`newsid` WHERE ( type_news in ('succ','acpt') ) AND ( id_univ!=1196 ) AND ( ctry_news=81 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.009981s ]
select report_id,applyschool,cname_clss,pass_count,fail_count,pass_rate
from tb_data_applyoffer_base c
left join tb_classes s on c.applymajortypedetailid = s.id_clss
left join tb_univ_collegeinfo f on c.applyschoolid = f.id
left join tb_category cc on c.applymajortypeid = cc.id_cate
where c.applyschoolid= 1196 order by rand()
limit 1 [ RunTime:0.008997s ]
select distinct hot_cover,b.id,title,create_at,m_reading,school_id,video,b.level_limit
from tb_article_content b,tb_major_information a ,tb_information_count c
left join tb_univ_collegeinfo d on c.school_id=d.id
where a.article_id=b.id
and c.id=a.information_id
and school_id= 1196 and deleted_at is null
and c.type=1
and video!=''
and information_type=2
and b.status=2
AND b.show_type = 1
order by a.is_top desc,create_at desc
limit 2 [ RunTime:0.009994s ]
SHOW FULL COLUMNS FROM `tb_major_information` [ RunTime:0.010016s ]
SELECT `mi`.`id`,`mi`.`article_id`,`mi`.`information_type`,`mi`.`is_top`,`ac`.`create_at`,`ac`.`title`,`ac`.`reading`,`ac`.`m_reading`,`ac`.`mp_reading`,`ac`.`web_reading`,`ac`.`desc`,`ac`.`video`,`ac`.`cover`,`ac`.`hot_cover`,`ac`.`type`,`ac`.`tags`,ac.create_at as time,`ac`.`level_limit`,`ac`.`cate_id` FROM `tb_major_information` `mi` LEFT JOIN `tb_information_count` `ic` ON `mi`.`information_id`=ic.id and type=1 LEFT JOIN `tb_article_content` `ac` ON `ac`.`id`=`mi`.`article_id` WHERE `ac`.`show_type` = '1' AND `information_type` = 1 AND `ac`.`status` = '2' AND `school_id` = '1196' AND `deleted_at` IS NULL ORDER BY `mi`.`is_top` DESC,`ac`.`create_at` DESC LIMIT 3 [ RunTime:0.010000s ]
SHOW FULL COLUMNS FROM `tb_univ_monitored` [ RunTime:0.006601s ]
SELECT * FROM `tb_univ_monitored` WHERE `univ_id` = 1196 LIMIT 1 [ RunTime:0.005230s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.008283s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 1196 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.006005s ]