SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000647s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.001020s ]
UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611130803 AND `locks` = 2 [ RunTime:0.008087s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000922s ]
UPDATE `chat_tourist` SET `times` = 1 WHERE `updatetime` <= 1611213603 AND `ip` = '3.227.247.17' [ RunTime:0.006806s ]
UPDATE `chat_tourist` SET `status` = 1 , `updatetime` = 1611217203 WHERE `ip` = '3.227.247.17' [ RunTime:0.008087s ]
UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610612403 AND `status` = 1 [ RunTime:0.006377s ]
SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000901s ]
SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `chat_images` [ RunTime:0.000353s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 1 LIMIT 1 [ RunTime:0.000945s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000202s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000266s ]
SELECT * FROM `chat_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000408s ]
SELECT COUNT(*) AS think_count FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 7 [ RunTime:0.000261s ]
SELECT * FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 7 ORDER BY `weigh` DESC,`createtime` DESC LIMIT 0,5 [ RunTime:0.000252s ]
SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 27 AND `types` = 4 LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000319s ]
SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 27 [ RunTime:0.000253s ]
SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000341s ]