CREATE TABLE IF NOT EXISTS users (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(64) UNIQUE, email VARCHAR(128), password VARCHAR(255), status TINYINT DEFAULT 1, created_at DATETIME, updated_at DATETIME) [ RunTime:0.001196s ]
CREATE TABLE IF NOT EXISTS admins (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(64) UNIQUE, password VARCHAR(255), role VARCHAR(32) DEFAULT 'admin', status TINYINT DEFAULT 1, created_at DATETIME, updated_at DATETIME) [ RunTime:0.000530s ]
CREATE TABLE IF NOT EXISTS tools (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `key` VARCHAR(64) UNIQUE, name VARCHAR(128), description TEXT, enabled TINYINT DEFAULT 1, visible TINYINT DEFAULT 1, icon VARCHAR(128), sort INT DEFAULT 100, updated_at DATETIME) [ RunTime:0.000497s ]
CREATE TABLE IF NOT EXISTS settings (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, k VARCHAR(64) UNIQUE, v TEXT, updated_at DATETIME) [ RunTime:0.000479s ]
CREATE TABLE IF NOT EXISTS blacklist_ips (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, ip VARCHAR(64), reason VARCHAR(255), enabled TINYINT DEFAULT 1, created_at DATETIME) [ RunTime:0.000467s ]
SELECT COUNT(*) AS c FROM tools [ RunTime:0.000317s ]
SELECT COUNT(*) AS c FROM admins [ RunTime:0.000253s ]
SELECT 1 FROM blacklist_ips WHERE enabled=1 AND ip='216.73.216.208' LIMIT 1 [ RunTime:0.000386s ]
SELECT `key`, name, icon, sort, enabled, visible FROM tools ORDER BY sort ASC, id ASC [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `visit_logs` [ RunTime:0.000898s ]