SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.006087s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.007552s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.008138s ]
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.007243s ]
SELECT COUNT(*) AS think_count FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE `status` = 2 AND `delete_time` IS NULL [ RunTime:0.011755s ]
SELECT `rl`.*,`rb`.`logo` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE `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.019260s ]