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.001099s ]
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.000586s ]
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.000523s ]
CREATE TABLE IF NOT EXISTS settings (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, k VARCHAR(64) UNIQUE, v TEXT, updated_at DATETIME) [ RunTime:0.000614s ]
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.000509s ]
SELECT COUNT(*) AS c FROM tools [ RunTime:0.000324s ]
SELECT COUNT(*) AS c FROM admins [ RunTime:0.000277s ]
INSERT IGNORE INTO tools(`key`,name,enabled,visible,icon,sort,updated_at) VALUES('ip_geo','ip_geo','1','1','fas fa-map-marker-alt text-danger','120',NOW()) [ RunTime:0.001010s ]
INSERT IGNORE INTO tools(`key`,name,enabled,visible,icon,sort,updated_at) VALUES('excel_auto','excel_auto','1','1','fas fa-file-excel text-success','130',NOW()) [ RunTime:0.000883s ]
SELECT 1 FROM blacklist_ips WHERE enabled=1 AND ip='216.73.216.126' LIMIT 1 [ RunTime:0.000437s ]
SELECT `key`, name, icon, link, sort, enabled, visible FROM tools ORDER BY sort ASC, id ASC [ RunTime:0.000559s ]
SHOW FULL COLUMNS FROM `visit_logs` [ RunTime:0.000938s ]