10 MIN DRAW
VERIFIABLE DRAW
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-11-01 08:11:53 HTTP/1.1 GET : https://herepool.com/lottery/results
- 运行时间 : 0.110239s [ 吞吐率:9.07req/s ] 内存消耗:3,448.45kb 文件加载:129
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=f61ffca62380feb4f7780adddc757256
- CONNECT:[ UseTime:0.017732s ] mysql:host=localhost;port=3306;dbname=3d;charset=utf8mb4
- CREATE TABLE IF NOT EXISTS `lottery_number` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`period` VARCHAR(64) NOT NULL,
`n1` VARCHAR(2) NOT NULL,
`n2` VARCHAR(2) NOT NULL,
`n3` VARCHAR(2) NOT NULL,
`n4` VARCHAR(2) NOT NULL,
`n5` VARCHAR(2) NOT NULL,
`n6` VARCHAR(2) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_period` (`period`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.005742s ]
- CREATE TABLE IF NOT EXISTS `lottery_round` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`slot` BIGINT NOT NULL,
`period` VARCHAR(64) NOT NULL,
`n1` VARCHAR(2) NOT NULL,
`n2` VARCHAR(2) NOT NULL,
`n3` VARCHAR(2) NOT NULL,
`n4` VARCHAR(2) NOT NULL,
`n5` VARCHAR(2) NOT NULL,
`n6` VARCHAR(2) NOT NULL,
`winning` VARCHAR(32) DEFAULT NULL COMMENT 'Random 3-of-6 winning numbers, comma-separated',
`secret` VARCHAR(10) NOT NULL,
`commitment` VARCHAR(512) NOT NULL COMMENT 'AES-256-GCM encrypted round payload (legacy period-only supported)',
`status` VARCHAR(16) NOT NULL DEFAULT 'pending',
`start_at` BIGINT NOT NULL,
`end_at` BIGINT NOT NULL,
`revealed_at` BIGINT DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_slot` (`slot`),
KEY `idx_status_end` (`status`, `end_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002225s ]
- CREATE TABLE IF NOT EXISTS `lottery_user` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(20) NOT NULL,
`password_hash` VARCHAR(255) NOT NULL,
`nickname` VARCHAR(30) NOT NULL,
`status` VARCHAR(16) NOT NULL DEFAULT 'active',
`balance` DECIMAL(20,6) NOT NULL DEFAULT 0.000000,
`session_version` INT UNSIGNED NOT NULL DEFAULT 0,
`created_at` BIGINT NOT NULL,
`last_login_at` BIGINT DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_username` (`username`),
KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003361s ]
- CREATE TABLE IF NOT EXISTS `lottery_balance_log` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT UNSIGNED NOT NULL,
`bet_id` INT UNSIGNED DEFAULT NULL,
`amount` DECIMAL(20,6) NOT NULL,
`balance_after` DECIMAL(20,6) NOT NULL,
`type` VARCHAR(32) NOT NULL,
`note` VARCHAR(255) NOT NULL DEFAULT '',
`operator` VARCHAR(64) NOT NULL DEFAULT '',
`created_at` BIGINT NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_user_time` (`user_id`, `created_at`),
KEY `idx_bet_id` (`bet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.001417s ]
- CREATE TABLE IF NOT EXISTS `lottery_bet_setting` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`mode` VARCHAR(16) NOT NULL,
`odds` DECIMAL(12,2) NOT NULL,
`min_amount` DECIMAL(20,6) NOT NULL,
`max_amount` DECIMAL(20,6) NOT NULL,
`updated_at` BIGINT NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_mode` (`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.001603s ]
- CREATE TABLE IF NOT EXISTS `lottery_bet` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`round_id` INT UNSIGNED NOT NULL,
`user_id` INT UNSIGNED NOT NULL,
`mode` VARCHAR(16) NOT NULL,
`numbers` VARCHAR(32) NOT NULL,
`amount` DECIMAL(20,6) NOT NULL,
`odds` DECIMAL(12,2) NOT NULL,
`status` VARCHAR(16) NOT NULL DEFAULT 'pending',
`payout` DECIMAL(20,6) NOT NULL DEFAULT 0.000000,
`balance_after` DECIMAL(20,6) DEFAULT NULL,
`created_at` BIGINT NOT NULL,
`settled_at` BIGINT DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_round_status` (`round_id`, `status`),
KEY `idx_user_time` (`user_id`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002066s ]
- SHOW COLUMNS FROM `lottery_round` LIKE 'winning' [ RunTime:0.001849s ]
- SHOW COLUMNS FROM `lottery_user` LIKE 'balance' [ RunTime:0.000622s ]
- SHOW COLUMNS FROM `lottery_user` LIKE 'session_version' [ RunTime:0.000628s ]
- SHOW COLUMNS FROM `lottery_bet` LIKE 'balance_after' [ RunTime:0.000578s ]
- SHOW COLUMNS FROM `lottery_balance_log` LIKE 'bet_id' [ RunTime:0.000524s ]
- SHOW COLUMNS FROM `lottery_round` LIKE 'commitment' [ RunTime:0.000778s ]

0.118626s