SHOW FULL COLUMNS FROM `category` [ RunTime:0.000581s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000852s ]
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` = '1' ORDER BY `g`.`id` DESC [ RunTime:0.000514s ]
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` = '1' ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.000476s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000291s ]
