SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.005417s ]
select id_exp,point_exp,is_bt from tb_exp where cust_exp=147407 and show_exp=1 order by sort_exp DESC,order_exp ASC [ RunTime:0.015412s ]
SELECT `a`.`result_aply` FROM `tb_news` `n` LEFT JOIN `tb_apply` `a` ON `a`.`id_aply`=`n`.`aply_news` WHERE `id_news` = 22771 LIMIT 1 [ RunTime:0.010414s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=1600 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.007446s ]
select others_limits,edu_fee,in_month,a.major_detail_id,a.univ_col_id,major_detail_name,univ_name,edu_years,dev_target
from tb_univ_majorinfo a ,tb_univ_collegeinfo b
where a.univ_col_id=b.id
and a.id =1600
limit 1 [ RunTime:0.009629s ]
SHOW FULL COLUMNS FROM `tb_data_applyoffer_base` [ RunTime:0.010575s ]
SELECT `report_id`,`pass_count`,`fail_count`,`pass_rate` FROM `tb_data_applyoffer_base` WHERE `applyschoolid` = 39 AND `applymajortypedetailid` = 51 LIMIT 1 [ RunTime:0.009182s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.008945s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=23018 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009784s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22719 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009026s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22703 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.009322s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22702 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.008813s ]
SHOW FULL COLUMNS FROM `tb_major` [ RunTime:0.005882s ]
SELECT * FROM `tb_major` WHERE `id_majr` = 1600 LIMIT 1 [ RunTime:0.009159s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=1600 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.007135s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.010720s ]
SELECT * FROM `tb_university` WHERE `id_univ` = 39 LIMIT 1 [ RunTime:0.009965s ]
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=22771) s order by LOCATE(position, '2514') asc [ RunTime:0.007728s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 16328 LIMIT 1 [ RunTime:0.007396s ]
select *
from tb_adviser ,tb_advisernews
where userid=user_id
and newsid=22771
and advisertype=2 [ RunTime:0.006128s ]
SHOW FULL COLUMNS FROM `tb_adviserclue` [ RunTime:0.005894s ]
SELECT COUNT(*) AS think_count FROM `tb_adviserclue` WHERE `adviserid` = 16328 [ RunTime:0.005121s ]
SHOW FULL COLUMNS FROM `tb_adviser_custom_acquisition_url_log` [ RunTime:0.007914s ]
SELECT COUNT(*) AS think_count FROM `tb_adviser_custom_acquisition_url_log` WHERE `adviser_id` = 16328 AND `add_friend_time` IS NOT NULL [ RunTime:0.004923s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.006394s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` = 39 AND `show_hb` = 1 LIMIT 1 [ RunTime:0.005426s ]