SHOW FULL COLUMNS FROM `tb_course` [ RunTime:0.022296s ]
SHOW FULL COLUMNS FROM `tb_courseshow` [ RunTime:0.014872s ]
SELECT `c`.`id_news`,`c`.`cname_news`,`c`.`cuniv_news`,`c`.`title_news`,`c`.`detail_news`,`c`.`id_univ`,`b`.`point_exp`,a.id AS course_show_id FROM `tb_courseshow` `a` INNER JOIN `tb_exp` `b` ON `a`.`id`=b.is_bt AND b.show_exp = 1 LEFT JOIN `tb_news` `c` ON `b`.`cust_exp`=c.cust_news AND type_news = "succ" WHERE ( find_in_set( 1120, a.major_direct ) ) AND ( c.ctry_news=12 ) ORDER BY `c`.`time_news` DESC,`c`.`id_news` DESC LIMIT 2 [ RunTime:0.090837s ]
SELECT `c`.`id_news`,`c`.`cname_news`,`c`.`cuniv_news`,`c`.`title_news`,`c`.`detail_news`,`c`.`id_univ`,`b`.`point_exp`,a.id AS course_show_id FROM `tb_courseshow` `a` INNER JOIN `tb_exp` `b` ON `a`.`id`=b.is_bt AND b.show_exp = 1 LEFT JOIN `tb_news` `c` ON `b`.`cust_exp`=c.cust_news AND type_news = "succ" WHERE ( find_in_set( 1120, a.major_direct ) ) AND ( c.ctry_news in (7,9,10,11) ) ORDER BY `c`.`time_news` DESC,`c`.`id_news` DESC LIMIT 4 [ RunTime:0.018304s ]
SELECT * FROM ( SELECT `c`.`id`,`title`,`description`,`date`,`mobile`,`pro_first`,`major_direct`,a.name as aname,a.id as aid,b.name as bname,b.id as bid,`enroll`,`quota`,`startTime`,`endTime` FROM `tb_courseshow` `c` LEFT JOIN `tb_categorys` `b` ON `b`.`id`=`pro_first` LEFT JOIN `tb_categorys` `a` ON `a`.`id`=`pro_second` WHERE `status` = 2 AND ( startTime<="2025-07-05" ) AND ( endTime>="2025-07-05" ) AND ( delete_time is null ) AND ( find_in_set(1120,major_direct) ) AND ( pro_first=1103 or pro_first=1124 ) ) A UNION ( ( SELECT `c`.`id`,`title`,`description`,`date`,`mobile`,`pro_first`,`major_direct`,a.name as aname,a.id as aid,b.name as bname,b.id as bid,`enroll`,`quota`,`startTime`,`endTime` FROM `tb_courseshow` `c` LEFT JOIN `tb_categorys` `b` ON `b`.`id`=`pro_first` LEFT JOIN `tb_categorys` `a` ON `a`.`id`=`pro_second` WHERE `status` = 2 AND ( startTime<="2025-07-05" ) AND ( endTime>="2025-07-05" ) AND ( delete_time is null ) AND ( find_in_set(1120,major_direct) ) AND ( pro_first=1103 or pro_first=1124 ) ) ) ORDER BY field(pro_first,1105,1104,1124,1103),`date` ASC,`id` DESC [ RunTime:0.006835s ]