Third Author, Performance Enhancement of Cu2ZnSn(S, Se)4 Solar Cell by Inserting Sb and Sb2Se3 Doping Layer at the Bottom of CZTS Precursor on Materials Research Express 6 125920;
SHOW FULL COLUMNS FROM `tb_news` [ RunTime:0.005687s ]
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` = 19043 LIMIT 1 [ RunTime:0.014633s ]
select id_exp,point_exp,is_bt from tb_exp where cust_exp=42303 and show_exp=1 order by sort_exp DESC,order_exp ASC [ RunTime:0.004509s ]
SELECT `a`.`result_aply` FROM `tb_news` `n` LEFT JOIN `tb_apply` `a` ON `a`.`id_aply`=`n`.`aply_news` WHERE `id_news` = 19043 LIMIT 1 [ RunTime:0.004924s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=62965 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.004872s ]
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 =62965
limit 1 [ RunTime:0.004995s ]
SHOW FULL COLUMNS FROM `tb_data_applyoffer_base` [ RunTime:0.007168s ]
SELECT `report_id`,`pass_count`,`fail_count`,`pass_rate` FROM `tb_data_applyoffer_base` WHERE `applyschoolid` = 39 AND `applymajortypedetailid` = 5 LIMIT 1 [ RunTime:0.004960s ]
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` = 39 AND `major_news` = 62965 AND `cname_news` NOT IN ('0','') AND `type_news` = 'succ' AND ( id_news <>19043 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 4 [ RunTime:0.004930s ]
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` = 5 AND `id_univ` = 39 AND `id_news` NOT IN (22870,21112) AND `type_news` = 'succ' AND ( id_news <>19043 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 2 [ RunTime:0.005386s ]
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` = 10 AND `id_clss` = 5 AND `star_news` = 1 AND `id_news` NOT IN (22870,21112) AND `type_news` = 'succ' AND ( id_news <>19043 ) ORDER BY `time_news` DESC,`id_news` DESC LIMIT 2 [ RunTime:0.006683s ]
SHOW FULL COLUMNS FROM `tb_advisernews` [ RunTime:0.005273s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=22870 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.005321s ]
SELECT * FROM `tb_advisernews`,`tb_adviser` WHERE ( status=1 and userid=user_id and newsid=21112 ) ORDER BY LOCATE(position, '2145') asc LIMIT 1 [ RunTime:0.004876s ]
SHOW FULL COLUMNS FROM `tb_major` [ RunTime:0.005235s ]
SELECT * FROM `tb_major` WHERE `id_majr` = 62965 LIMIT 1 [ RunTime:0.007689s ]
select b.name,a.score from tb_univ_majorinfo_score a,tb_categorys b where a.major_info_id=62965 and a.score_type=b.id and a.is_new=1 and a.is_show=1 [ RunTime:0.004986s ]
SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005411s ]
SELECT * FROM `tb_university` WHERE `id_univ` = 39 LIMIT 1 [ RunTime:0.005466s ]
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=19043) s order by LOCATE(position, '2514') asc [ RunTime:0.020765s ]
SELECT count(newsid) as count FROM `tb_advisernews` WHERE `userid` = 30 LIMIT 1 [ RunTime:0.024920s ]
SHOW FULL COLUMNS FROM `tb_handbook` [ RunTime:0.023552s ]