SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000651s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.001022s ]
UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611129155 AND `locks` = 2 [ RunTime:0.009874s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.001071s ]
UPDATE `chat_tourist` SET `times` = 1 WHERE `updatetime` <= 1611211955 AND `ip` = '3.227.247.17' [ RunTime:0.007530s ]
UPDATE `chat_tourist` SET `status` = 1 , `updatetime` = 1611215555 WHERE `ip` = '3.227.247.17' [ RunTime:0.006976s ]
UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610610755 AND `status` = 1 [ RunTime:0.007281s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000981s ]
SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `chat_images` [ RunTime:0.000429s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 1 LIMIT 1 [ RunTime:0.000274s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000279s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `chat_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000480s ]
SELECT COUNT(*) AS think_count FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 2 [ RunTime:0.000215s ]
SELECT * FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 2 ORDER BY `weigh` DESC,`createtime` DESC LIMIT 5,5 [ RunTime:0.000406s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 5 AND `types` = 4 LIMIT 1 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000334s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 5 [ RunTime:0.000263s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 4 AND `types` = 4 LIMIT 1 [ RunTime:0.000193s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 4 [ RunTime:0.004138s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 4 LIMIT 1 [ RunTime:0.000231s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 3 [ RunTime:0.000287s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 4 LIMIT 1 [ RunTime:0.000215s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 2 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000484s ]