SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000706s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.001015s ]
UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611130686 AND `locks` = 2 [ RunTime:0.008761s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000908s ]
UPDATE `chat_tourist` SET `times` = 1 WHERE `updatetime` <= 1611213486 AND `ip` = '3.227.247.17' [ RunTime:0.006920s ]
UPDATE `chat_tourist` SET `status` = 1 , `updatetime` = 1611217086 WHERE `ip` = '3.227.247.17' [ RunTime:0.006661s ]
UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610612286 AND `status` = 1 [ RunTime:0.007029s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.001777s ]
SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `chat_images` [ RunTime:0.000338s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 1 LIMIT 1 [ RunTime:0.000330s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000204s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `chat_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000383s ]
SELECT COUNT(*) AS think_count FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 8 [ RunTime:0.000218s ]
SELECT * FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 8 ORDER BY `weigh` DESC,`createtime` DESC LIMIT 0,5 [ RunTime:0.000284s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 15 AND `types` = 4 LIMIT 1 [ RunTime:0.000226s ]
SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000312s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 15 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000328s ]