SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.005039s ]
SELECT `tb_news`.*,um.id as showmajrid,um.major_cname as showmajrname,um.is_show as umshow,um.status as umstatus,uc.id_univ as showunivid,uc.univ_name as showunivname,uc.is_show as ucshow,uc.status as ucstatus FROM `tb_news` LEFT JOIN `tb_univ_collegeinfo` `uc` ON `uc`.`id_univ`=`tb_news`.`id_univ` LEFT JOIN `tb_univ_majorinfo` `um` ON `um`.`id`=`tb_news`.`major_news` WHERE `id_news` = 24163 LIMIT 1 [ RunTime:0.008204s ]
select id_exp,point_exp,is_bt from tb_exp where cust_exp=399524 and show_exp=1 order by sort_exp DESC,order_exp ASC [ RunTime:0.009185s ]
SELECT `a`.`result_aply` FROM `tb_news` `n` LEFT JOIN `tb_apply` `a` ON `a`.`id_aply`=`n`.`aply_news` WHERE `id_news` = 24163 LIMIT 1 [ RunTime:0.010270s ]
select pre_course,season,edu_years,edu_fee,a.id,a.major_detail_id,a.univ_col_id,major_detail_cname,univ_name
from tb_univ_majorinfo_us a ,tb_univ_collegeinfo b
where a.univ_col_id=b.id
and a.id =65696
limit 1 [ RunTime:0.009777s ]
SHOW FULL COLUMNS FROM `tb_univ_majorinfo_us` [ RunTime:0.010353s ]
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` FROM `tb_univ_majorinfo_us` `umu` LEFT JOIN `tb_univ_collegeinfo` `uc` ON `uc`.`id`=`umu`.`univ_col_id` WHERE `umu`.`id` = '65696' AND `umu`.`status` = '0' LIMIT 1 [ RunTime:0.009584s ]
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` = 92 AND `major_news` = 65696 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' AND ( id_news <>24163 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.013664s ]
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` = 40 AND `id_univ` = 92 AND `id_news` NOT IN (22785,22784,18263) AND `type_news` = 'succ' AND ( id_news <>24163 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 1 [ RunTime:0.008660s ]
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` = 40 AND `star_news` = 1 AND `id_news` NOT IN (22785,22784,18263) AND `type_news` = 'succ' AND ( id_news <>24163 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 1 [ RunTime:0.033262s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.012721s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22785 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009807s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22784 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009474s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=23051 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009282s ]
SHOW FULL COLUMNS FROM `tb_major` [ RunTime:0.010352s ]
SELECT * FROM `tb_major` WHERE `id_majr` = 65696 LIMIT 1 [ RunTime:0.009636s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=65696 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.009994s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005548s ]
SELECT * FROM `tb_university` WHERE `id_univ` = 92 LIMIT 1 [ RunTime:0.013806s ]
select * from (select a.job,
user_id,
name,
intro,
level,
a.desc,
ava,
position
from tb_adviser a,tb_advisernews
where userid=user_id and status=1
and newsid=24163) s order by LOCATE(position, '2514') asc [ RunTime:0.010241s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 238 LIMIT 1 [ RunTime:0.009512s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 270 LIMIT 1 [ RunTime:0.009701s ]
select *
from tb_adviser ,tb_advisernews
where userid=user_id
and newsid=24163
and advisertype=4 [ RunTime:0.010248s ]
SHOW FULL COLUMNS FROM `tb_adviserclue` [ RunTime:0.010406s ]
SELECT COUNT(*) AS think_count FROM `tb_adviserclue` WHERE `adviserid` = 270 [ RunTime:0.008916s ]
SHOW FULL COLUMNS FROM `tb_adviser_custom_acquisition_url_log` [ RunTime:0.005493s ]
SELECT COUNT(*) AS think_count FROM `tb_adviser_custom_acquisition_url_log` WHERE `adviser_id` = 270 AND `add_friend_time` IS NOT NULL [ RunTime:0.014050s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.012200s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 92 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.006584s ]