SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000724s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.000985s ]
UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611131288 AND `locks` = 2 [ RunTime:0.007328s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000792s ]
UPDATE `chat_tourist` SET `times` = 1 WHERE `updatetime` <= 1611214088 AND `ip` = '3.227.247.17' [ RunTime:0.007857s ]
UPDATE `chat_tourist` SET `status` = 1 , `updatetime` = 1611217688 WHERE `ip` = '3.227.247.17' [ RunTime:0.007055s ]
UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610612888 AND `status` = 1 [ RunTime:0.006501s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000879s ]
SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000479s ]
SELECT `id`,`cat_name`,`pid` FROM `chat_category` WHERE `status` = 1 ORDER BY `weigh` DESC [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.002214s ]
SELECT * FROM `chat_banner` WHERE `status` = 1 ORDER BY `weigh` DESC [ RunTime:0.000197s ]
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.000218s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `chat_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002481s ]
SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000419s ]
SELECT COUNT(*) AS think_count FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 3 [ RunTime:0.000286s ]
SELECT * FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 3 ORDER BY `weigh` DESC,`createtime` DESC LIMIT 0,5 [ RunTime:0.000280s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 20 AND `types` = 4 LIMIT 1 [ RunTime:0.000224s ]
SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000318s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 20 [ RunTime:0.000245s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 19 AND `types` = 4 LIMIT 1 [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 19 [ RunTime:0.000203s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 18 AND `types` = 4 LIMIT 1 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 18 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000312s ]