SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.004826s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.006666s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.009157s ]
SELECT COUNT(*) AS think_count FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE ( cate_id=1209 ) AND ( brand_id=17 ) AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.013794s ]
SELECT `rl`.*,`rb`.`logo` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE ( cate_id=1209 ) AND ( 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.008042s ]