SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.005406s ]
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` = 24116 LIMIT 1 [ RunTime:0.008456s ]
select id_exp,point_exp,is_bt from tb_exp where cust_exp=263148 and show_exp=1 order by sort_exp DESC,order_exp ASC [ RunTime:0.009087s ]
SELECT `a`.`result_aply` FROM `tb_news` `n` LEFT JOIN `tb_apply` `a` ON `a`.`id_aply`=`n`.`aply_news` WHERE `id_news` = 24116 LIMIT 1 [ RunTime:0.009536s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.010866s ]
SELECT * FROM `tb_university` WHERE `id_univ` = 2 LIMIT 1 [ RunTime:0.009561s ]
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=24116) s order by LOCATE(position, '2514') asc [ RunTime:0.009708s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.009983s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 238 LIMIT 1 [ RunTime:0.009589s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 270 LIMIT 1 [ RunTime:0.009821s ]
select *
from tb_adviser ,tb_advisernews
where userid=user_id
and newsid=24116
and advisertype=4 [ RunTime:0.012641s ]
SHOW FULL COLUMNS FROM `tb_adviserclue` [ RunTime:0.009712s ]
SELECT COUNT(*) AS think_count FROM `tb_adviserclue` WHERE `adviserid` = 270 [ RunTime:0.009498s ]
SHOW FULL COLUMNS FROM `tb_adviser_custom_acquisition_url_log` [ RunTime:0.007578s ]
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.005817s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.012059s ]
SELECT * FROM `tb_handbook` WHERE `type_hb` = 2 AND `relatedid_hb` IS NULL AND `show_hb` = 1 LIMIT 1 [ RunTime:0.009107s ]