SHOW FULL COLUMNS FROM `category` [ RunTime:0.001796s ]
SELECT * FROM `category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.003699s ]
SHOW FULL COLUMNS FROM `cart` [ RunTime:0.003500s ]
SELECT COUNT(*) AS think_count FROM `cart` WHERE `session_id` = '8a03b89001530ed84dab99bbd33b7ff9' [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `promotion` [ RunTime:0.001328s ]
SELECT COUNT(*) AS think_count FROM `promotion` WHERE `status` = 1 AND `start_time` <= '2026-10-18 15:40:47' AND `end_time` >= '2026-10-18 15:40:47' [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `staff` [ RunTime:0.001481s ]
SELECT * FROM `staff` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000231s ]
SELECT * FROM `category` WHERE `id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000277s ]
SELECT * FROM `category` WHERE `parent_id` = 2 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `product` [ RunTime:0.002312s ]
SELECT COUNT(*) AS think_count FROM `product` WHERE `category_id` = 2 AND `status` = 1 [ RunTime:0.000283s ]
SELECT * FROM `product` WHERE `category_id` = 2 AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 0,20 [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `promotion_product` [ RunTime:0.002649s ]
SELECT `pp`.`product_id`,`pp`.`discount_type`,`pp`.`discount_value`,`pp`.`promotion_id`,`p`.`name`,`p`.`start_time`,`p`.`end_time`,`p`.`sort_order` FROM `promotion_product` `pp` INNER JOIN `promotion` `p` ON `p`.`id`=`pp`.`promotion_id` WHERE `p`.`status` = '1' [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `product_sku` [ RunTime:0.001520s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 5 [ RunTime:0.000284s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 5 [ RunTime:0.000267s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 17 [ RunTime:0.000261s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 17 [ RunTime:0.000256s ]