SHOW FULL COLUMNS FROM `category` [ RunTime:0.001093s ]
SELECT * FROM `category` WHERE `parent_id` = 0 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `cart` [ RunTime:0.000994s ]
SELECT COUNT(*) AS think_count FROM `cart` WHERE `session_id` = '8a03b89001530ed84dab99bbd33b7ff9' [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `promotion` [ RunTime:0.000967s ]
SELECT COUNT(*) AS think_count FROM `promotion` WHERE `status` = 1 AND `start_time` <= '2026-10-18 17:22:52' AND `end_time` >= '2026-10-18 17:22:52' [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `staff` [ RunTime:0.001035s ]
SELECT * FROM `staff` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `category` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000217s ]
SELECT * FROM `category` WHERE `parent_id` = 1 AND `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `product` [ RunTime:0.001160s ]
SELECT COUNT(*) AS think_count FROM `product` WHERE `category_id` IN (1,4,5,6,7,9) AND `status` = 1 [ RunTime:0.000282s ]
SELECT * FROM `product` WHERE `category_id` IN (1,4,5,6,7,9) AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 0,20 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `promotion_product` [ RunTime:0.001126s ]
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.000325s ]
SHOW FULL COLUMNS FROM `product_sku` [ RunTime:0.001086s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 2 [ RunTime:0.000251s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 2 [ RunTime:0.000203s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 3 [ RunTime:0.000194s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 3 [ RunTime:0.000201s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 4 [ RunTime:0.000190s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 4 [ RunTime:0.000188s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 6 [ RunTime:0.000187s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 6 [ RunTime:0.000189s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 7 [ RunTime:0.000192s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 7 [ RunTime:0.000218s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 8 [ RunTime:0.000198s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 8 [ RunTime:0.000182s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 9 [ RunTime:0.000188s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 9 [ RunTime:0.000183s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000186s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 10 [ RunTime:0.000183s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000185s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 11 [ RunTime:0.000190s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 12 [ RunTime:0.000190s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 12 [ RunTime:0.000183s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 13 [ RunTime:0.000187s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 13 [ RunTime:0.000189s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 14 [ RunTime:0.000188s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 14 [ RunTime:0.000184s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 15 [ RunTime:0.000186s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 15 [ RunTime:0.000206s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000189s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 16 [ RunTime:0.000185s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 18 [ RunTime:0.000195s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 18 [ RunTime:0.000185s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 19 [ RunTime:0.000186s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 19 [ RunTime:0.000183s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 22 [ RunTime:0.000218s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 22 [ RunTime:0.000184s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 23 [ RunTime:0.000186s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 23 [ RunTime:0.000186s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000190s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 24 [ RunTime:0.000184s ]
SELECT MIN(`price`) AS think_min FROM `product_sku` WHERE `product_id` = 25 [ RunTime:0.000186s ]
SELECT MAX(`price`) AS think_max FROM `product_sku` WHERE `product_id` = 25 [ RunTime:0.000192s ]