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.001197s ]
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.000786s ]
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.000559s ]
CREATE TABLE IF NOT EXISTS settings (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, k VARCHAR(64) UNIQUE, v TEXT, updated_at DATETIME) [ RunTime:0.000481s ]
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.000610s ]
SELECT COUNT(*) AS c FROM tools [ RunTime:0.000334s ]
SELECT COUNT(*) AS c FROM admins [ RunTime:0.000278s ]
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.001628s ]
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.000948s ]
SELECT 1 FROM blacklist_ips WHERE enabled=1 AND ip='216.73.216.126' LIMIT 1 [ RunTime:0.000454s ]
SELECT enabled FROM tools WHERE `key`='image_convert' LIMIT 1 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `visit_logs` [ RunTime:0.001061s ]