SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.004922s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.007618s ]
SELECT * FROM `tb_rank_brand` WHERE `short` = 'payscale' LIMIT 1 [ RunTime:0.009122s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.010420s ]
SELECT * FROM `tb_rank_lib` WHERE `year` = '2023' AND `cate_id` = 1210 AND `brand_id` = 18 AND `status` = 2 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.011166s ]
SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.009944s ]
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` = 6413 ORDER BY if(rank is null or rank=0,9999,rank), rank asc,rli.id asc [ RunTime:0.014368s ]
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` = '18' 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.010213s ]
SELECT * FROM `tb_rank_brand` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006563s ]
SELECT distinct year FROM `tb_rank_lib` WHERE `cate_id` = 1210 AND `brand_id` = 18 AND `status` = 2 AND `delete_time` IS NULL ORDER BY `year` DESC [ RunTime:0.005180s ]
SHOW FULL COLUMNS FROM `tb_rank_introduce` [ RunTime:0.005385s ]
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` = 18 AND ( ac.status=2 and show_type=2 ) LIMIT 1 [ RunTime:0.005659s ]