SHOW FULL COLUMNS FROM `tb_internship_new` [ RunTime:0.006819s ]
SELECT distinct session FROM `tb_internship_new` LEFT JOIN `tb_company` `b` ON `b`.`id`=`company_id` WHERE `delete_time` IS NULL AND ( ( find_in_set('2025',session) ) OR ( find_in_set('2024',session) ) OR ( find_in_set('2023',session) ) OR ( find_in_set('2022',session) ) OR ( find_in_set('2021',session) ) OR ( find_in_set('2020',session) ) ) [ RunTime:0.019009s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `tb_internship_new` `a` LEFT JOIN `tb_company` `b` ON `b`.`id`=`a`.`company_id` LEFT JOIN `tb_internship_area_relate` `c` ON `a`.`id`=`c`.`internship_id` WHERE `delete_time` IS NULL AND `status` = 2 AND `a`.`internship_type` = '1' AND `b`.`is_internship` = '1' GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.014207s ]
SELECT `a`.`id`,`a`.`internship_type`,`b`.`fullname`,`b`.`company_type`,`b`.`logo`,`a`.`job_name`,`a`.`area_name`,`a`.`grade_level`,`a`.`sub_cate`,`a`.`internship_time`,`a`.`session` FROM `tb_internship_new` `a` LEFT JOIN `tb_company` `b` ON `b`.`id`=`a`.`company_id` LEFT JOIN `tb_internship_area_relate` `c` ON `a`.`id`=`c`.`internship_id` WHERE `delete_time` IS NULL AND `status` = 2 AND `a`.`internship_type` = '1' AND `b`.`is_internship` = '1' GROUP BY `a`.`id` ORDER BY if(datediff(a.internship_time,now()) < 0 ,1,2) desc,if(datediff(a.internship_time,now()) < 0,datediff(a.internship_time,now()),datediff(now(),a.internship_time)) desc,`a`.`id` DESC LIMIT 0,20 [ RunTime:0.009011s ]