SHOW FULL COLUMNS FROM `category` [ RunTime:0.000715s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000498s ]
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` = '3' ORDER BY `g`.`id` DESC [ RunTime:0.000366s ]
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` = '3' ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.000383s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000313s ]
