SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.014133s ]
SELECT * FROM ( (select a.id,a.univ_name,a.univ_ename,a.city,a.id_univ,b.sort_name,country_id,b.sort,c.counts
from tb_univ_collegeinfo_msearchcount c, tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1
where a.is_show=1
and c.id_univ=a.id_univ
and a.status=0
and a.country_id=7 and sort_name=859 order by counts desc limit 2 ) UNION (select a.id,a.univ_name,a.univ_ename,a.city,a.id_univ,b.sort_name,country_id,b.sort,c.counts
from tb_univ_collegeinfo_msearchcount c, tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1
where a.is_show=1
and c.id_univ=a.id_univ
and a.status=0
and a.country_id=12 and sort_name=859 order by counts desc limit 1 ) UNION (select a.id,a.univ_name,a.univ_ename,a.city,a.id_univ,b.sort_name,country_id,b.sort,c.counts
from tb_univ_collegeinfo_msearchcount c, tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1
where a.is_show=1
and c.id_univ=a.id_univ
and a.status=0
and a.country_id=10 and sort_name=859 order by counts desc limit 1 ) UNION (select a.id,a.univ_name,a.univ_ename,a.city,a.id_univ,b.sort_name,country_id,b.sort,c.counts
from tb_univ_collegeinfo_msearchcount c, tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1
where a.is_show=1
and c.id_univ=a.id_univ
and a.status=0
and a.country_id=11 and sort_name=859 order by counts desc limit 1 ) ) A limit 5 [ RunTime:0.023848s ]
SHOW FULL COLUMNS FROM `tb_article_content` [ RunTime:0.019415s ]
SELECT `cover`,`id`,`title`,`m_reading`,`create_at` FROM `tb_article_content` ORDER BY `web_reading` DESC LIMIT 6 [ RunTime:0.035970s ]
select distinct city,a.id_news,a.title_news,a.content_news,a.detail_news,a.time_news,a.Descrip_news,a.id_univ,a.id_clss,a.ctry_news,a.cuniv_news,a.cmajr_news,a.univrank_news,a.gpa_news,c.univ_name,c.univ_ename,c.univ_abbname,f.id
from tb_univ_collegeinfo c,tb_news a
left join tb_colleges f on a.cuniv_news =f.college_name
where a.id_univ =c.id
and (a.type_news='succ' ) and f.id =24 and a.ctry_news in (7,9,10,11,12,13,1253) and univrank_news >0 order by time_news desc,id_news desc [ RunTime:0.037455s ]
select distinct city,a.id_news,a.title_news,a.content_news,a.detail_news,a.time_news,a.Descrip_news,a.id_univ,a.id_clss,a.ctry_news,a.cuniv_news,a.cmajr_news,a.univrank_news,a.gpa_news,c.univ_name,c.univ_ename,c.univ_abbname,f.id
from tb_univ_collegeinfo c,tb_news a
left join tb_colleges f on a.cuniv_news =f.college_name
where a.id_univ =c.id
and (a.type_news='succ' ) and f.id =24 and a.ctry_news in (7,9,10,11,12,13,1253) and univrank_news >0 order by time_news desc,id_news desc limit 0,20 [ RunTime:0.023763s ]
SHOW FULL COLUMNS FROM `tb_article_category` [ RunTime:0.016231s ]
select id_clss as class_cc
,cname_clss as cname_cc
,cate_clss as cate_cc
from tb_classes
order by cate_cc desc,order_clss desc [ RunTime:0.031966s ]