SHOW FULL COLUMNS FROM `tb_course` [ RunTime:0.005260s ]
SHOW FULL COLUMNS FROM `tb_courseshow` [ RunTime:0.040803s ]
SELECT `c`.*,a.id as aid,a.name as aname,b.id as bid,b.name as bname 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 ( c.id=245 ) LIMIT 1 [ RunTime:0.006342s ]
SELECT `c`.*,a.id as aid,a.name as aname,b.id as bid,b.name as bname 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 ( c.id=245 ) LIMIT 1 [ RunTime:0.005906s ]
SELECT * FROM ( 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( 1109, a.pro_second ) ) AND ( star_news=1 ) ORDER BY `c`.`time_news` DESC LIMIT 6 ) A UNION ( ( 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( 1103, a.pro_first ) ) AND ( star_news=1 ) ORDER BY `c`.`time_news` DESC LIMIT 6 ) ) LIMIT 6 [ RunTime:0.174240s ]
SELECT `c`.*,a.id as aid,a.name as aname,b.id as bid,b.name as bname 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 ( c.id=245 ) LIMIT 1 [ RunTime:0.010503s ]