SHOW FULL COLUMNS FROM `tb_college_library` [ RunTime:0.005380s ]
SELECT distinct b.province_code as ctry,b.province_code as value,`c`.`code`,c.name as name FROM `tb_college_library` `a` LEFT JOIN `tb_colleges` `b` ON `a`.`college_id`=b.id and b.college_type=1 INNER JOIN `tb_categorys` `c` ON `c`.`id`=`b`.`province_code` WHERE `a`.`status` = '2' ORDER BY `c`.`code` ASC [ RunTime:0.011470s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.005344s ]
SELECT COUNT(*) AS think_count FROM `tb_college_library` `cl` LEFT JOIN `tb_colleges` `c` ON `c`.`id`=cl.college_id and c.college_type=1 LEFT JOIN `tb_rank_lib_info` `rl20` ON `rl20`.`rank_lib_id`=6604 and rl20.college_id=cl.college_id LEFT JOIN `tb_categorys` `ct` ON `ct`.`id`=`c`.`province_code` WHERE `cl`.`status` = '2' [ RunTime:0.014175s ]
SELECT `cl`.`college_id`,cl.college_id as id,`college_cname`,`c`.`college_ename`,`c`.`address`,`categories`,`c`.`features`,`c`.`province_code`,`c`.`categories`,rl20.rank as rk FROM `tb_college_library` `cl` LEFT JOIN `tb_colleges` `c` ON `c`.`id`=cl.college_id and c.college_type=1 LEFT JOIN `tb_rank_lib_info` `rl20` ON `rl20`.`rank_lib_id`=6604 and rl20.college_id=cl.college_id LEFT JOIN `tb_categorys` `ct` ON `ct`.`id`=`c`.`province_code` WHERE `cl`.`status` = '2' ORDER BY if (rl20.rank >0,0,1) asc,`rl20`.`rank` ASC,`cl`.`college_id` ASC LIMIT 0,20 [ RunTime:0.014893s ]
SHOW FULL COLUMNS FROM `tb_college_record_list` [ RunTime:0.009229s ]
SELECT a.id,count( d.id_aply > 0 ) AS count,a.picture_params,b.college_name 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` ORDER BY count( d.id_aply > 0 ) desc LIMIT 4 [ RunTime:0.145951s ]