SHOW FULL COLUMNS FROM `tb_college_record_list` [ RunTime:0.004790s ]
SELECT distinct b.province_code as location_code,`G`.`name` FROM `tb_college_record_list` `a` LEFT JOIN `tb_colleges` `b` ON `b`.`id`=`a`.`college_id` INNER JOIN `tb_categorys` `G` ON `G`.`id`=`b`.`province_code` WHERE ( a.delete_time is null and a.status =2 ) ORDER BY `G`.`code` ASC,`G`.`id` DESC [ RunTime:0.009008s ]
SELECT COUNT(*) AS think_count FROM `tb_college_record_list` `b` LEFT JOIN `tb_colleges` `a` ON `b`.`college_id`=`a`.`id` WHERE ( b.status=2 ) [ RunTime:0.006724s ]
SELECT distinct b.id as aid,a.college_name as cname,a.college_ename as ename,`a`.`location`,a.id as cid,`picture_params`,`a`.`province_code` FROM `tb_college_record_list` `b` LEFT JOIN `tb_colleges` `a` ON `b`.`college_id`=`a`.`id` WHERE ( b.status=2 ) LIMIT 0,10000 [ RunTime:0.009320s ]
SELECT distinct college_id FROM `tb_college_record_list` [ RunTime:0.008882s ]
SELECT b.id AS sch_id,count( d.id_aply > 0 ) AS count FROM `tb_college_record_list` `a` INNER JOIN `tb_colleges` `b` ON `a`.`college_id`=`b`.`id` INNER JOIN `tb_custom` `c` ON `c`.`sch_id`=`b`.`id` INNER JOIN `tb_apply` `d` ON `d`.`cust_aply`=c.id_cust AND d.result_aply IN ( '录取', '入学' ) INNER JOIN `tb_categorys` `f` ON `f`.`id`=`b`.`province_code` WHERE ( a.delete_time IS NULL AND a.status = 2 ) GROUP BY `a`.`id` LIMIT 1000 [ RunTime:0.073494s ]
SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.009316s ]
SELECT `id`,`name` FROM `tb_categorys` [ RunTime:0.014895s ]