SHOW FULL COLUMNS FROM `category` [ RunTime:0.000594s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000721s ]
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` = '7' ORDER BY `g`.`id` DESC [ RunTime:0.000409s ]
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` = '7' ORDER BY `g`.`id` DESC LIMIT 0,20 [ RunTime:0.000541s ]
SELECT * FROM `category` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000318s ]