SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.004940s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.008712s ]
SELECT * FROM `tb_rank_brand` WHERE `short` = 'wm' LIMIT 1 [ RunTime:0.005785s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.009713s ]
SELECT * FROM `tb_rank_lib` WHERE `year` = '2023' AND `cate_id` = 1210 AND `brand_id` = 9 AND `status` = 2 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.015623s ]
SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.005988s ]
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` = 6017 ORDER BY if(rank is null or rank=0,9999,rank), rank asc,rli.id asc [ RunTime:0.012811s ]
SELECT `class_small_id`,`rc`.`cname_rs`,`class_big_id` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rankclasses` `rc` ON `class_small_id`=`rc`.`class_rs` WHERE `cate_id` = 1210 AND `rl`.`brand_id` = '9' AND `year` = '2023' AND `status` = 2 AND `delete_time` IS NULL ORDER BY LOCATE(class_big_id,'2413') asc,`class_small_id` ASC [ RunTime:0.016936s ]
SELECT * FROM `tb_rank_brand` WHERE `id` = 9 LIMIT 1 [ RunTime:0.006201s ]
SELECT distinct year FROM `tb_rank_lib` WHERE `cate_id` = 1210 AND `brand_id` = 9 AND `status` = 2 AND `delete_time` IS NULL ORDER BY `year` DESC [ RunTime:0.009015s ]
SHOW FULL COLUMNS FROM `tb_rank_introduce` [ RunTime:0.010627s ]
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` = '1210' AND `brand_id` = 9 AND ( ac.status=2 and show_type=2 ) LIMIT 1 [ RunTime:0.009338s ]