SHOW FULL COLUMNS FROM `category` [ RunTime:0.001347s ]
SELECT * FROM `category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `cart` [ RunTime:0.001343s ]
SELECT COUNT(*) AS think_count FROM `cart` WHERE `session_id` = '8a03b89001530ed84dab99bbd33b7ff9' [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `promotion` [ RunTime:0.001264s ]
SELECT COUNT(*) AS think_count FROM `promotion` WHERE `status` = 1 AND `start_time` <= '2026-10-18 14:39:28' AND `end_time` >= '2026-10-18 14:39:28' [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `staff` [ RunTime:0.005409s ]
SELECT * FROM `staff` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.004940s ]
SHOW FULL COLUMNS FROM `banner` [ RunTime:0.001291s ]
SELECT * FROM `banner` WHERE `status` = 1 ORDER BY `sort_order` ASC LIMIT 5 [ RunTime:0.000253s ]
SELECT * FROM `category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 10 [ RunTime:0.000317s ]
SELECT `id` FROM `category` WHERE `parent_id` = 1 AND `status` = 1 [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `product` [ RunTime:0.001332s ]
SELECT * FROM `product` WHERE `category_id` IN (1,4,5,6,7,9) AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000604s ]
SELECT `id` FROM `category` WHERE `parent_id` = 2 AND `status` = 1 [ RunTime:0.000254s ]
SELECT * FROM `product` WHERE `category_id` = 2 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000299s ]
SELECT `id` FROM `category` WHERE `parent_id` = 3 AND `status` = 1 [ RunTime:0.000210s ]
SELECT * FROM `product` WHERE `category_id` = 3 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000319s ]
SELECT `id` FROM `category` WHERE `parent_id` = 10 AND `status` = 1 [ RunTime:0.000215s ]
SELECT * FROM `product` WHERE `category_id` = 10 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `promotion_product` [ RunTime:0.001525s ]
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.000322s ]
SHOW FULL COLUMNS FROM `product_sku` [ RunTime:0.001264s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 2 [ RunTime:0.000295s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 2 [ RunTime:0.000270s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 3 [ RunTime:0.000257s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 3 [ RunTime:0.000267s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 4 [ RunTime:0.000246s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 4 [ RunTime:0.000243s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 6 [ RunTime:0.000241s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 6 [ RunTime:0.000238s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 7 [ RunTime:0.000238s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 7 [ RunTime:0.000247s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 8 [ RunTime:0.000270s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 8 [ RunTime:0.000271s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 9 [ RunTime:0.000255s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 9 [ RunTime:0.000238s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000260s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000239s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000236s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000251s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 12 [ RunTime:0.000252s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 12 [ RunTime:0.000365s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 13 [ RunTime:0.000286s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 13 [ RunTime:0.000253s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 14 [ RunTime:0.000254s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 14 [ RunTime:0.000234s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 15 [ RunTime:0.000243s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 15 [ RunTime:0.000236s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000206s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000206s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 18 [ RunTime:0.000211s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 18 [ RunTime:0.000203s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 19 [ RunTime:0.000199s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 19 [ RunTime:0.000215s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 22 [ RunTime:0.000207s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 22 [ RunTime:0.000202s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 23 [ RunTime:0.000204s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 23 [ RunTime:0.000203s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000221s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000213s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 25 [ RunTime:0.000230s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 25 [ RunTime:0.000259s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 26 [ RunTime:0.000203s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 26 [ RunTime:0.000258s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 27 [ RunTime:0.000237s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 27 [ RunTime:0.000219s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 28 [ RunTime:0.000211s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 28 [ RunTime:0.000200s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 29 [ RunTime:0.000208s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 29 [ RunTime:0.000211s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 30 [ RunTime:0.000208s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 30 [ RunTime:0.000200s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 31 [ RunTime:0.000205s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 31 [ RunTime:0.000215s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 37 [ RunTime:0.000243s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 37 [ RunTime:0.000235s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 38 [ RunTime:0.000243s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 38 [ RunTime:0.000224s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 39 [ RunTime:0.000260s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 39 [ RunTime:0.000260s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 5 [ RunTime:0.000277s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 5 [ RunTime:0.000276s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 17 [ RunTime:0.000272s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 17 [ RunTime:0.000266s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 20 [ RunTime:0.000277s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 20 [ RunTime:0.000265s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 21 [ RunTime:0.000283s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 21 [ RunTime:0.000272s ]
