SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.004644s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.008998s ]
SELECT distinct rb.short,`rl`.`cate_id`,`rb`.`name` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rl`.`brand_id`=`rb`.`id` ORDER BY `rb`.`id` ASC,`cate_id` ASC [ RunTime:0.009052s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.009478s ]
SELECT * FROM `tb_rank_brand` [ RunTime:0.009359s ]
SELECT `id` FROM `tb_rank_lib` WHERE `brand_id` = 1 AND `cate_id` = 1208 AND `status` = 2 AND `delete_time` IS NULL ORDER BY `year` DESC LIMIT 1 [ RunTime:0.009057s ]
SELECT COUNT(*) AS think_count FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE ( brand_id=17 ) AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.011933s ]
SELECT `rl`.*,`rb`.`logo` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE ( brand_id=17 ) AND `status` = 2 AND `delete_time` IS NULL ORDER BY if(rl.id=7029,0,1) asc,`year` DESC,`cate_id` ASC,`brand_id` ASC,`class_small_id` ASC LIMIT 0,20 [ RunTime:0.010436s ]