SHOW FULL COLUMNS FROM `category` [ RunTime:0.002224s ]
SELECT * FROM `category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `cart` [ RunTime:0.002138s ]
SELECT COUNT(*) AS think_count FROM `cart` WHERE `session_id` = '8a03b89001530ed84dab99bbd33b7ff9' [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `promotion` [ RunTime:0.001051s ]
SELECT COUNT(*) AS think_count FROM `promotion` WHERE `status` = 1 AND `start_time` <= '2026-10-18 16:33:29' AND `end_time` >= '2026-10-18 16:33:29' [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `staff` [ RunTime:0.002440s ]
SELECT * FROM `staff` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000264s ]
SELECT * FROM `category` WHERE `id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `category` WHERE `parent_id` = 4 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `product` [ RunTime:0.001022s ]
SELECT COUNT(*) AS think_count FROM `product` WHERE `category_id` = 4 AND `status` = 1 [ RunTime:0.000237s ]
SELECT * FROM `product` WHERE `category_id` = 4 AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 0,20 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `promotion_product` [ RunTime:0.001205s ]
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.000300s ]
SHOW FULL COLUMNS FROM `product_sku` [ RunTime:0.001137s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000237s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000202s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000199s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000197s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000195s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000191s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000193s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000200s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 26 [ RunTime:0.000192s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 26 [ RunTime:0.000187s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 39 [ RunTime:0.000205s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 39 [ RunTime:0.000190s ]