SHOW FULL COLUMNS FROM `category` [ RunTime:0.000596s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000654s ]
SELECT COUNT(*) AS think_count FROM `goods` `g` LEFT JOIN `store` `s` ON `s`.`id`=`g`.`store_id` WHERE `g`.`status` = '1' AND `g`.`category_id` = '6' ORDER BY `g`.`id` DESC [ RunTime:0.000389s ]
SELECT `g`.*,s.name as store_name FROM `goods` `g` LEFT JOIN `store` `s` ON `s`.`id`=`g`.`store_id` WHERE `g`.`status` = '1' AND `g`.`category_id` = '6' ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.000390s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000272s ]
