SHOW FULL COLUMNS FROM `categories` [ RunTime:0.000475s ]
SELECT * FROM `categories` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `settings` [ RunTime:0.000332s ]
SELECT * FROM `settings` [ RunTime:0.000157s ]
SHOW FULL COLUMNS FROM `products` [ RunTime:0.000368s ]
SELECT * FROM `products` WHERE `id` = 101 AND `status` = 1 LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `categories` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000150s ]
SELECT * FROM `products` WHERE `status` = 1 AND `category_id` = 1 AND `id` <> 101 ORDER BY `price_max` DESC LIMIT 4 [ RunTime:0.000813s ]
SHOW FULL COLUMNS FROM `auction_products` [ RunTime:0.000309s ]
SELECT `a`.`id`,`a`.`title_zhcn`,`a`.`title_zhtw`,`a`.`title_en`,`a`.`start_time`,`a`.`status`,`ap`.`lot_no`,ap.estimate AS lot_estimate FROM `auction_products` `ap` LEFT JOIN `auctions` `a` ON `a`.`id`=`ap`.`auction_id` WHERE `ap`.`product_id` = '101' ORDER BY `a`.`start_time` DESC [ RunTime:0.000247s ]