SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.004703s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.006941s ]
SELECT * FROM `tb_rank_brand` WHERE `short` = 'cug' LIMIT 1 [ RunTime:0.011101s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.005252s ]
SELECT * FROM `tb_rank_lib` WHERE `year` = '2024' AND `cate_id` = 1208 AND `brand_id` = 7 AND `status` = 2 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.017119s ]
SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.006859s ]
SELECT `year`,`rank`,`rank_alias`,`rli`.`major_id`,`univ_cname`,`univ_ename`,`univ_id`,`college_id`,`area_name`,`area_id`,`brand_id`,`rank_major_cname`,`rank_major_ename`,`um`.`major_cname`,`um`.`major_ename` FROM `tb_rank_lib_info` `rli` LEFT JOIN `tb_univ_majorinfo` `um` ON `rli`.`major_id`=`um`.`id` WHERE `rank_lib_id` = 5996 ORDER BY if(rank is null or rank=0,9999,rank), rank asc,rli.id asc [ RunTime:0.012335s ]
SELECT distinct year FROM `tb_rank_lib` WHERE `cate_id` = 1208 AND `brand_id` = 7 AND `status` = 2 AND `delete_time` IS NULL ORDER BY `year` DESC [ RunTime:0.008995s ]
SHOW FULL COLUMNS FROM `tb_rank_introduce` [ RunTime:0.005137s ]
SELECT `ri`.`pic_url`,`ac`.`content` FROM `tb_rank_introduce` `ri` LEFT JOIN `tb_article_content` `ac` ON `ri`.`article_id`=`ac`.`id` WHERE `ri`.`cate_id` = '1208' AND `brand_id` = 7 AND ( ac.status=2 and show_type=2 ) LIMIT 1 [ RunTime:0.009656s ]