SHOW FULL COLUMNS FROM `bbs_site_config` [ RunTime:0.001362s ]
SELECT `value`,`name` FROM `bbs_site_config` WHERE `name` IN ('cache_driver','cache_expire','cache_redis_host','cache_redis_port','cache_redis_password','cache_redis_select','cache_request_enable','cache_request_expire') [ RunTime:0.000482s ]
SELECT COUNT(*) AS c FROM information_schema.TABLES WHERE TABLE_SCHEMA = '5gqqw_cn' AND TABLE_NAME = 'plugin' [ RunTime:0.000759s ]
SHOW FULL COLUMNS FROM `bbs_plugin` [ RunTime:0.001377s ]
SELECT `version`,`name` FROM `bbs_plugin` WHERE `status` = 1 [ RunTime:0.001106s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'community' LIMIT 1 [ RunTime:0.000452s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'dataconvert' AND `status` = 1 LIMIT 1 [ RunTime:0.000441s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'dataconvert' LIMIT 1 [ RunTime:0.000318s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'adminavatar' AND `status` = 1 LIMIT 1 [ RunTime:0.000619s ]
SHOW FULL COLUMNS FROM `bbs_auth_rule` [ RunTime:0.001267s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000782s ]
SHOW FULL COLUMNS FROM `bbs_menu` [ RunTime:0.000647s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000386s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000208s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000234s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar' LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar' LIMIT 1 [ RunTime:0.000215s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar/upload' LIMIT 1 [ RunTime:0.000328s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/adminavatar/save' LIMIT 1 [ RunTime:0.000340s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'adminavatar' LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'community' AND `status` = 1 LIMIT 1 [ RunTime:0.000465s ]
SELECT `name` FROM `bbs_plugin` WHERE `status` = 1 [ RunTime:0.000241s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'mail' AND `status` = 1 LIMIT 1 [ RunTime:0.000543s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'mail' LIMIT 1 [ RunTime:0.000233s ]
SHOW FULL COLUMNS FROM `bbs_community_topic` [ RunTime:0.001190s ]
SELECT `id`,`title`,`reply_count`,`view_count` FROM `bbs_community_topic` WHERE `status` = 1 ORDER BY `view_count` DESC,`id` DESC LIMIT 5 [ RunTime:0.000527s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'paidread' AND `status` = 1 LIMIT 1 [ RunTime:0.000558s ]
SHOW TABLES LIKE 'bbs_community_topic' [ RunTime:0.000694s ]
SHOW COLUMNS FROM `bbs_community_topic` LIKE 'read_mode' [ RunTime:0.000506s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'paidread' LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'message' AND `status` = 1 LIMIT 1 [ RunTime:0.000374s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'message' LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'audio' AND `status` = 1 LIMIT 1 [ RunTime:0.000298s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'audio' LIMIT 1 [ RunTime:0.000701s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'netdisk' AND `status` = 1 LIMIT 1 [ RunTime:0.000349s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'netdisk' LIMIT 1 [ RunTime:0.000231s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'badge' AND `status` = 1 LIMIT 1 [ RunTime:0.000237s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'badge' LIMIT 1 [ RunTime:0.000213s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'signin' AND `status` = 1 LIMIT 1 [ RunTime:0.000204s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'signin' LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'lottery' AND `status` = 1 LIMIT 1 [ RunTime:0.000188s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'lottery' LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'ads' AND `status` = 1 LIMIT 1 [ RunTime:0.000482s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'ads' LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'aiassistant' AND `status` = 1 LIMIT 1 [ RunTime:0.000305s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'aiassistant' LIMIT 1 [ RunTime:0.000356s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'captcha' AND `status` = 1 LIMIT 1 [ RunTime:0.000211s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'captcha' LIMIT 1 [ RunTime:0.000194s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'gamehall' AND `status` = 1 LIMIT 1 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `bbs_gamehall_entry` [ RunTime:0.001010s ]
SELECT * FROM `bbs_gamehall_entry` WHERE `status` = 1 ORDER BY `sort`,`id` LIMIT 30 [ RunTime:0.000327s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'payment' AND `status` = 1 LIMIT 1 [ RunTime:0.000217s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'payment' LIMIT 1 [ RunTime:0.000177s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000416s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'ranklist' AND `status` = 1 LIMIT 1 [ RunTime:0.000355s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'ranklist' LIMIT 1 [ RunTime:0.000222s ]
SHOW COLUMNS FROM `bbs_community_category` LIKE 'show_plaza' [ RunTime:0.001256s ]
SHOW FULL COLUMNS FROM `bbs_community_category` [ RunTime:0.000400s ]
SELECT `id` FROM `bbs_community_category` WHERE ( `show_plaza` = 0 ) AND `bbs_community_category`.`delete_time` = '0' [ RunTime:0.000230s ]
SELECT `id`,`category_id`,`user_id`,`admin_id`,`username`,`title`,`content_type`,`accepted_reply_id`,`bounty_amount`,`bounty_currency`,`bounty_status`,`is_top`,`is_category_top`,`is_essence`,`essence_level`,`is_notice`,`is_highlight`,`highlight_color`,`is_locked`,`status`,`view_count`,`reply_count`,`like_count`,`favorite_count`,`is_paid`,`read_mode`,`price`,`pay_currency`,`software_icon`,`software_screenshots`,`software_language`,`software_update`,`software_version`,`software_platform`,`video_url`,`video_cover`,`video_duration`,`last_reply_time`,`create_time`,`update_time`,`delete_time`,`top_sort`,LEFT(`content`, 12000) AS `content` FROM `bbs_community_topic` WHERE ( `status` = 1 AND `is_top` = 1 ) AND `bbs_community_topic`.`delete_time` = '0' ORDER BY `is_top` DESC,`top_sort` DESC,`last_reply_time` DESC,`id` DESC LIMIT 0,50 [ RunTime:0.000861s ]
SELECT * FROM `bbs_community_category` WHERE ( ( `id` IN (12,8) ) ) AND `bbs_community_category`.`delete_time` = '0' ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `bbs_community_tag` [ RunTime:0.000993s ]
SHOW FULL COLUMNS FROM `bbs_community_topic_tag` [ RunTime:0.000523s ]
SELECT `bbs_community_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`topic_id` AS `pivot__topic_id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`create_time` AS `pivot__create_time` FROM `bbs_community_tag` INNER JOIN `bbs_community_topic_tag` `pivot` ON `pivot`.`tag_id`=`bbs_community_tag`.`id` WHERE ( `pivot`.`topic_id` IN ('229','228','210','58') ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000499s ]
SHOW COLUMNS FROM `bbs_community_topic` LIKE 'admin_id' [ RunTime:0.000629s ]
SHOW INDEX FROM `bbs_community_topic` WHERE Key_name = 'idx_admin_id' [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `bbs_admin` [ RunTime:0.000709s ]
SELECT `id`,`username`,`nickname` FROM `bbs_admin` [ RunTime:0.000186s ]
UPDATE `bbs_community_topic` SET `admin_id` = 1 WHERE `user_id` = 0 AND `admin_id` = 0 AND `username` IN ('chenshao','Mr.Chen') [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `bbs_community_reply` [ RunTime:0.000443s ]
UPDATE `bbs_community_reply` SET `admin_id` = 1 WHERE `user_id` = 0 AND `admin_id` = 0 AND `username` IN ('chenshao','Mr.Chen') [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `bbs_user` [ RunTime:0.000812s ]
SELECT `id`,`avatar`,`nickname`,`username` FROM `bbs_user` WHERE ( `id` = 1 ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000467s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` = 1 [ RunTime:0.000344s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` = 1 AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000438s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` = 1 AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `bbs_virtualpop_user` [ RunTime:0.000494s ]
SELECT `user_id` FROM `bbs_virtualpop_user` WHERE `user_id` = 1 [ RunTime:0.000217s ]
SELECT `id`,`community_role`,`level_id`,`member_level_id` FROM `bbs_user` WHERE ( `id` = 1 ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `bbs_user_level` [ RunTime:0.000651s ]
SELECT * FROM `bbs_user_level` WHERE `status` = 1 ORDER BY `sort` ASC,`coins_min` ASC,`id` ASC [ RunTime:0.000287s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` = 1 [ RunTime:0.000205s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` = 1 AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000278s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` = 1 AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `bbs_netdisk_file` [ RunTime:0.000505s ]
SELECT topic_id, COUNT(*) AS cnt FROM `bbs_netdisk_file` WHERE `topic_id` IN (229,228,210,58) AND `status` = 1 GROUP BY `topic_id` [ RunTime:0.000286s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'redpacket' AND `status` = 1 LIMIT 1 [ RunTime:0.001717s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'redpacket' LIMIT 1 [ RunTime:0.000243s ]
SHOW TABLES LIKE 'bbs_redpacket' [ RunTime:0.000517s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'claim_type' [ RunTime:0.000635s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'claim_level_id' [ RunTime:0.000295s ]
SHOW COLUMNS FROM `bbs_redpacket` LIKE 'expire_time' [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `bbs_redpacket` [ RunTime:0.000381s ]
SELECT * FROM `bbs_redpacket` WHERE `topic_id` IN (229,228,210,58) AND `status` > 0 [ RunTime:0.000272s ]
SHOW TABLES LIKE 'bbs_lottery' [ RunTime:0.000358s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'draw_mode' [ RunTime:0.000426s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'exclude_author' [ RunTime:0.000458s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'allow_level_ids' [ RunTime:0.000503s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'winners_need' [ RunTime:0.000289s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'prepaid_coins' [ RunTime:0.000322s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'prepaid_gold' [ RunTime:0.000219s ]
SHOW COLUMNS FROM `bbs_lottery` LIKE 'prepaid_refunded' [ RunTime:0.000270s ]
SHOW COLUMNS FROM `bbs_lottery_prize` LIKE 'amount' [ RunTime:0.000701s ]
SHOW COLUMNS FROM `bbs_lottery_prize` LIKE 'badge_id' [ RunTime:0.000299s ]
UPDATE `bbs_lottery` SET `draw_mode`='time' WHERE `draw_mode`='' OR `draw_mode` IS NULL [ RunTime:0.000350s ]
UPDATE `bbs_lottery` SET `draw_mode`='time' WHERE `expire_time`>0 AND (`draw_mode`='manual' OR `draw_mode`='') AND `status`=0 [ RunTime:0.000191s ]
UPDATE `bbs_lottery_prize` SET `prize_type`='physical' WHERE `prize_type`='virtual' [ RunTime:0.000404s ]
UPDATE `bbs_lottery_sidebar_prize` SET `prize_type`='physical' WHERE `prize_type`='virtual' [ RunTime:0.000316s ]
SHOW TABLES LIKE 'bbs_lottery_sidebar_prize' [ RunTime:0.000924s ]
SHOW TABLES LIKE 'bbs_lottery_sidebar_log' [ RunTime:0.000268s ]
SHOW TABLES LIKE 'bbs_lottery_win' [ RunTime:0.000349s ]
SHOW TABLES LIKE 'bbs_lottery_page_prize' [ RunTime:0.000443s ]
SHOW TABLES LIKE 'bbs_lottery_page_code' [ RunTime:0.000355s ]
SHOW TABLES LIKE 'bbs_lottery_page_log' [ RunTime:0.000333s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'card_code' [ RunTime:0.000484s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'ship_name' [ RunTime:0.000298s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'ship_phone' [ RunTime:0.000428s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'ship_address' [ RunTime:0.000258s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'ship_time' [ RunTime:0.000364s ]
SHOW COLUMNS FROM `bbs_lottery_page_prize` LIKE 'cover' [ RunTime:0.000803s ]
SHOW COLUMNS FROM `bbs_lottery_sidebar_log` LIKE 'admin_id' [ RunTime:0.000409s ]
SHOW COLUMNS FROM `bbs_lottery_win` LIKE 'admin_id' [ RunTime:0.000272s ]
SHOW INDEX FROM `bbs_lottery_sidebar_log` WHERE Key_name='uk_prize_user' [ RunTime:0.000242s ]
SHOW INDEX FROM `bbs_lottery_sidebar_log` WHERE Key_name='uk_prize_actor' [ RunTime:0.000621s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000783s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000457s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000229s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000223s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery' LIMIT 1 [ RunTime:0.000244s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/lottery' LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/sidebar' LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/sidebar_save' LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/sidebar_delete' LIMIT 1 [ RunTime:0.000201s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/sidebar_status' LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/page' LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/page_save' LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/page_delete' LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/page_status' LIMIT 1 [ RunTime:0.000167s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/page_log' LIMIT 1 [ RunTime:0.000209s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/activity' LIMIT 1 [ RunTime:0.000173s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/activity_force' LIMIT 1 [ RunTime:0.000263s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/win' LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/win_reissue' LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/win_ship' LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/sidebar_log' LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/lottery/save' LIMIT 1 [ RunTime:0.000155s ]
SHOW FULL COLUMNS FROM `bbs_lottery` [ RunTime:0.000674s ]
SELECT * FROM `bbs_lottery` WHERE `topic_id` IN (229,228,210,58) [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `bbs_community_reward` [ RunTime:0.000689s ]
SELECT ref_id, COUNT(*) AS cnt, SUM(amount) AS total FROM `bbs_community_reward` WHERE `ref_type` = 'topic' AND `ref_id` IN (229,228,210,58) GROUP BY `ref_id` [ RunTime:0.000335s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'vote' AND `status` = 1 LIMIT 1 [ RunTime:0.000753s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'vote' LIMIT 1 [ RunTime:0.000214s ]
SHOW TABLES LIKE 'bbs_topic_vote' [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `bbs_topic_vote` [ RunTime:0.001122s ]
SELECT * FROM `bbs_topic_vote` WHERE `topic_id` IN (229,228,210,58) [ RunTime:0.000234s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'attachment' AND `status` = 1 LIMIT 1 [ RunTime:0.000332s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'attachment' LIMIT 1 [ RunTime:0.000220s ]
SHOW TABLES LIKE 'bbs_topic_attachment' [ RunTime:0.000346s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'price' [ RunTime:0.000451s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'currency' [ RunTime:0.000364s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'download_count' [ RunTime:0.000246s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'vip_only' [ RunTime:0.000635s ]
SHOW COLUMNS FROM `bbs_topic_attachment` LIKE 'storage' [ RunTime:0.000442s ]
SHOW TABLES LIKE 'bbs_topic_attachment_unlock' [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `bbs_topic_attachment` [ RunTime:0.000447s ]
SELECT `topic_id` FROM `bbs_topic_attachment` WHERE `topic_id` IN (229,228,210,58) AND `status` = 1 GROUP BY `topic_id` [ RunTime:0.000626s ]
SHOW TABLES LIKE 'bbs_audio_track' [ RunTime:0.000487s ]
SHOW COLUMNS FROM `bbs_audio_track` LIKE 'cover_url' [ RunTime:0.000452s ]
SHOW COLUMNS FROM `bbs_topic_audio` LIKE 'cover_url' [ RunTime:0.000315s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000347s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000330s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000199s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000322s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio' LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/audio' LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/list' LIMIT 1 [ RunTime:0.000304s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/upload' LIMIT 1 [ RunTime:0.000234s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/link' LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/save' LIMIT 1 [ RunTime:0.000197s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/delete' LIMIT 1 [ RunTime:0.000293s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/clear' LIMIT 1 [ RunTime:0.000192s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/audio/status' LIMIT 1 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `bbs_topic_audio` [ RunTime:0.000588s ]
SELECT `topic_id`,`title`,`artist`,`cover_url`,`ext`,`storage` FROM `bbs_topic_audio` WHERE `topic_id` IN (229,228,210,58) AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000612s ]
SHOW FULL COLUMNS FROM `bbs_escort_record` [ RunTime:0.000637s ]
SELECT `user_id` FROM `bbs_escort_record` WHERE `status` = 0 AND `user_id` = 1 GROUP BY `user_id` [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `bbs_duel_profile` [ RunTime:0.000842s ]
SELECT `user_id`,`season_score` FROM `bbs_duel_profile` WHERE `user_id` = 1 [ RunTime:0.000224s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_member` [ RunTime:0.001255s ]
SELECT `user_id`,`realm` FROM `bbs_xiuxian_member` WHERE `user_id` = 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `bbs_xiuxian_realm` [ RunTime:0.000395s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000433s ]
SHOW FULL COLUMNS FROM `bbs_escort_member` [ RunTime:0.000503s ]
SELECT `user_id`,`level` FROM `bbs_escort_member` WHERE `user_id` = 1 [ RunTime:0.000294s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'vip' AND `status` = 1 LIMIT 1 [ RunTime:0.000395s ]
SHOW TABLES LIKE 'bbs_vip_member' [ RunTime:0.000404s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/vip_member','admin/vip_order') [ RunTime:0.000581s ]
DELETE FROM `bbs_menu` WHERE `name` IN ('admin/vip_member','admin/vip_order') [ RunTime:0.000484s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000638s ]
SELECT COUNT(*) AS think_count FROM `bbs_menu` WHERE `delete_time` = 0 AND `pid` = 54 [ RunTime:0.000302s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/vip_settings/labels','admin/vip_settings/saveLabels','admin/vip_settings/authors','admin/vip_settings/saveAuthors','admin/vip_settings/categories','admin/vip_settings/saveCategories') [ RunTime:0.000200s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000275s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000285s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000184s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000172s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/vip' LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/vip' LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/audit' LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/appeal' LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/revoke' LIMIT 1 [ RunTime:0.000450s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/expire' LIMIT 1 [ RunTime:0.000323s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/delete' LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify/types' LIMIT 1 [ RunTime:0.000275s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify_type/save' LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/verify_type/delete' LIMIT 1 [ RunTime:0.000197s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'verify' LIMIT 1 [ RunTime:0.000520s ]
SHOW FULL COLUMNS FROM `bbs_verify_application` [ RunTime:0.000742s ]
SELECT `user_id`,`type`,`subject_name` FROM `bbs_verify_application` WHERE `user_id` = 1 AND `status` = 1 AND ( `expire_time` = 0 OR `expire_time` > 1790977089 ) ORDER BY `id` DESC [ RunTime:0.000820s ]
SELECT COUNT(*) AS think_count FROM `bbs_community_topic` WHERE ( `status` = 1 AND ( `is_top` = 0 AND `is_category_top` = 0 ) ) AND `bbs_community_topic`.`delete_time` = '0' [ RunTime:0.000990s ]
SELECT `id`,`category_id`,`user_id`,`admin_id`,`username`,`title`,`content_type`,`accepted_reply_id`,`bounty_amount`,`bounty_currency`,`bounty_status`,`is_top`,`is_category_top`,`is_essence`,`essence_level`,`is_notice`,`is_highlight`,`highlight_color`,`is_locked`,`status`,`view_count`,`reply_count`,`like_count`,`favorite_count`,`is_paid`,`read_mode`,`price`,`pay_currency`,`software_icon`,`software_screenshots`,`software_language`,`software_update`,`software_version`,`software_platform`,`video_url`,`video_cover`,`video_duration`,`last_reply_time`,`create_time`,`update_time`,`delete_time`,`top_sort`,LEFT(`content`, 12000) AS `content` FROM `bbs_community_topic` WHERE ( `status` = 1 AND ( `is_top` = 0 AND `is_category_top` = 0 ) ) AND `bbs_community_topic`.`delete_time` = '0' ORDER BY `is_top` DESC,`top_sort` DESC,`last_reply_time` DESC,`id` DESC LIMIT 0,16 [ RunTime:0.000916s ]
SELECT * FROM `bbs_community_category` WHERE ( ( `id` IN (12,13,14,15,8,9) ) ) AND `bbs_community_category`.`delete_time` = '0' ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.001016s ]
SELECT `bbs_community_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`topic_id` AS `pivot__topic_id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`create_time` AS `pivot__create_time` FROM `bbs_community_tag` INNER JOIN `bbs_community_topic_tag` `pivot` ON `pivot`.`tag_id`=`bbs_community_tag`.`id` WHERE ( `pivot`.`topic_id` IN ('3','226','225','222','223','224','221','220','219','214','218','215','213','211','206','202') ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.001197s ]
SELECT `id`,`avatar`,`nickname`,`username` FROM `bbs_user` WHERE ( `id` IN (1,10,40,6) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000368s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` IN (1,10,40,6) [ RunTime:0.000399s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` IN (1,10,40,6) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000896s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` IN (1,10,40,6) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000686s ]
SELECT `user_id` FROM `bbs_virtualpop_user` WHERE `user_id` IN (1,10,40,6) [ RunTime:0.005712s ]
SELECT `id`,`community_role`,`level_id`,`member_level_id` FROM `bbs_user` WHERE ( `id` IN (1,10,40,6) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000470s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` IN (1,10,40,6) [ RunTime:0.000271s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` IN (1,10,40,6) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000798s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` IN (1,10,40,6) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000373s ]
SELECT topic_id, COUNT(*) AS cnt FROM `bbs_netdisk_file` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) AND `status` = 1 GROUP BY `topic_id` [ RunTime:0.000564s ]
SELECT * FROM `bbs_redpacket` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) AND `status` > 0 [ RunTime:0.000684s ]
SELECT * FROM `bbs_lottery` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) [ RunTime:0.000356s ]
SELECT ref_id, COUNT(*) AS cnt, SUM(amount) AS total FROM `bbs_community_reward` WHERE `ref_type` = 'topic' AND `ref_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) GROUP BY `ref_id` [ RunTime:0.000498s ]
SELECT * FROM `bbs_topic_vote` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) [ RunTime:0.000404s ]
SELECT `topic_id` FROM `bbs_topic_attachment` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) AND `status` = 1 GROUP BY `topic_id` [ RunTime:0.000393s ]
SELECT `topic_id`,`title`,`artist`,`cover_url`,`ext`,`storage` FROM `bbs_topic_audio` WHERE `topic_id` IN (3,226,225,222,223,224,221,220,219,214,218,215,213,211,206,202) AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000459s ]
SELECT `user_id` FROM `bbs_escort_record` WHERE `status` = 0 AND `user_id` IN (1,10,40,6) GROUP BY `user_id` [ RunTime:0.001592s ]
SELECT `user_id`,`season_score` FROM `bbs_duel_profile` WHERE `user_id` IN (1,10,40,6) [ RunTime:0.000481s ]
SELECT `user_id`,`realm` FROM `bbs_xiuxian_member` WHERE `user_id` IN (1,10,40,6) [ RunTime:0.000320s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 3 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `bbs_xiuxian_realm` WHERE `level` = 0 LIMIT 1 [ RunTime:0.000218s ]
SELECT `user_id`,`level` FROM `bbs_escort_member` WHERE `user_id` IN (1,10,40,6) [ RunTime:0.000526s ]
SELECT `user_id` FROM `bbs_vip_member` WHERE `user_id` IN (1,10,40,6) AND `expire_time` > 1790977089 [ RunTime:0.000435s ]
SELECT `user_id`,`type`,`subject_name` FROM `bbs_verify_application` WHERE `user_id` IN (1,10,40,6) AND `status` = 1 AND ( `expire_time` = 0 OR `expire_time` > 1790977089 ) ORDER BY `id` DESC [ RunTime:0.000634s ]
SELECT * FROM `bbs_community_topic` WHERE ( `status` = 1 ) AND `bbs_community_topic`.`delete_time` = '0' ORDER BY `view_count` DESC,`id` DESC LIMIT 10 [ RunTime:0.001346s ]
SELECT * FROM `bbs_community_topic` WHERE ( `status` = 1 AND `is_essence` = 1 ) AND `bbs_community_topic`.`delete_time` = '0' ORDER BY `essence_level` DESC,`id` DESC LIMIT 10 [ RunTime:0.000710s ]
SELECT user_id, admin_id, username, COUNT(*) AS topic_count, SUM(like_count) AS like_sum FROM `bbs_community_topic` WHERE `status` = 1 AND `delete_time` = 0 GROUP BY `user_id`,`admin_id`,`username` [ RunTime:0.001009s ]
SELECT user_id, admin_id, username, COUNT(*) AS reply_count FROM `bbs_community_reply` WHERE `status` = 1 AND `delete_time` = 0 GROUP BY `user_id`,`admin_id`,`username` [ RunTime:0.000956s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001113s ]
SELECT * FROM `bbs_user` WHERE ( `id` IN (2,10,1,20,16,14,17,13,19) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000371s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` IN (2,10,1,20,16,14,17,13,19) [ RunTime:0.000320s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` IN (2,10,1,20,16,14,17,13,19) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000736s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` IN (2,10,1,20,16,14,17,13,19) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000808s ]
SELECT `user_id` FROM `bbs_virtualpop_user` WHERE `user_id` IN (2,10,1,20,16,14,17,13,19) [ RunTime:0.000505s ]
SELECT `id`,`community_role`,`level_id`,`member_level_id` FROM `bbs_user` WHERE ( `id` IN (2,10,1,20,16,14,17,13,19) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000423s ]
SELECT `user_id` FROM `bbs_vip_member` WHERE `user_id` IN (2,10,1,20,16,14,17,13,19) AND `expire_time` > 1790977089 [ RunTime:0.000241s ]
SELECT `user_id`,`type`,`subject_name` FROM `bbs_verify_application` WHERE `user_id` IN (2,10,1,20,16,14,17,13,19) AND `status` = 1 AND ( `expire_time` = 0 OR `expire_time` > 1790977089 ) ORDER BY `id` DESC [ RunTime:0.000286s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 AND `status` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000456s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `bbs_user` WHERE ( `id` IN (2,10,1,6,11,40,12,13,14) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000561s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` IN (2,10,1,6,11,40,12,13,14) [ RunTime:0.000274s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` IN (2,10,1,6,11,40,12,13,14) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000845s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` IN (2,10,1,6,11,40,12,13,14) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000521s ]
SELECT `user_id` FROM `bbs_virtualpop_user` WHERE `user_id` IN (2,10,1,6,11,40,12,13,14) [ RunTime:0.000203s ]
SELECT `id`,`community_role`,`level_id`,`member_level_id` FROM `bbs_user` WHERE ( `id` IN (2,10,1,6,11,40,12,13,14) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000456s ]
SELECT `user_id` FROM `bbs_vip_member` WHERE `user_id` IN (2,10,1,6,11,40,12,13,14) AND `expire_time` > 1790977089 [ RunTime:0.000237s ]
SELECT `user_id`,`type`,`subject_name` FROM `bbs_verify_application` WHERE `user_id` IN (2,10,1,6,11,40,12,13,14) AND `status` = 1 AND ( `expire_time` = 0 OR `expire_time` > 1790977089 ) ORDER BY `id` DESC [ RunTime:0.000311s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 AND `status` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000708s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `bbs_user` WHERE ( `id` IN (10,1,6,2,11,40,12,13,14) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000423s ]
SELECT `id`,`coins`,`gold` FROM `bbs_user` WHERE `id` IN (10,1,6,2,11,40,12,13,14) [ RunTime:0.000249s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_topic` WHERE `user_id` IN (10,1,6,2,11,40,12,13,14) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000771s ]
SELECT user_id, COUNT(*) AS c FROM `bbs_community_reply` WHERE `user_id` IN (10,1,6,2,11,40,12,13,14) AND `status` = 1 AND `delete_time` = 0 GROUP BY `user_id` [ RunTime:0.000670s ]
SELECT `user_id` FROM `bbs_virtualpop_user` WHERE `user_id` IN (10,1,6,2,11,40,12,13,14) [ RunTime:0.000182s ]
SELECT `id`,`community_role`,`level_id`,`member_level_id` FROM `bbs_user` WHERE ( `id` IN (10,1,6,2,11,40,12,13,14) ) AND `bbs_user`.`delete_time` = '0' [ RunTime:0.000255s ]
SELECT `user_id` FROM `bbs_vip_member` WHERE `user_id` IN (10,1,6,2,11,40,12,13,14) AND `expire_time` > 1790977089 [ RunTime:0.000190s ]
SELECT `user_id`,`type`,`subject_name` FROM `bbs_verify_application` WHERE `user_id` IN (10,1,6,2,11,40,12,13,14) AND `status` = 1 AND ( `expire_time` = 0 OR `expire_time` > 1790977089 ) ORDER BY `id` DESC [ RunTime:0.000333s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 AND `status` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000375s ]
SELECT * FROM `bbs_admin` WHERE ( `id` = 1 ) AND `bbs_admin`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `bbs_community_topic` WHERE ( `status` = 1 AND `is_notice` = 1 ) AND `bbs_community_topic`.`delete_time` = '0' ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000463s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'editor' LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'friends' AND `status` = 1 LIMIT 1 [ RunTime:0.000350s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'friends' LIMIT 1 [ RunTime:0.000320s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'hide' AND `status` = 1 LIMIT 1 [ RunTime:0.000360s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'hide' LIMIT 1 [ RunTime:0.000319s ]
SHOW TABLES LIKE 'bbs_hide_block' [ RunTime:0.001152s ]
SHOW COLUMNS FROM `bbs_hide_block` LIKE 'currency' [ RunTime:0.001877s ]
SHOW TABLES LIKE 'bbs_hide_unlock' [ RunTime:0.000606s ]
SHOW COLUMNS FROM `bbs_hide_unlock` LIKE 'guest_token' [ RunTime:0.000561s ]
ALTER TABLE `bbs_hide_unlock` DROP INDEX `uk_block_actor` [ RunTime:0.003680s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/netdisk_provider','admin/netdisk_provider/list','admin/netdisk_provider/save','admin/netdisk_provider/delete','admin/netdisk_provider/status','admin/netdisk_provider/parse') [ RunTime:0.002956s ]
DELETE FROM `bbs_menu` WHERE `name` IN ('admin/netdisk_provider','admin/netdisk_provider/list','admin/netdisk_provider/save','admin/netdisk_provider/delete','admin/netdisk_provider/status','admin/netdisk_provider/parse') [ RunTime:0.000559s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.001169s ]
SELECT COUNT(*) AS think_count FROM `bbs_menu` WHERE `delete_time` = 0 AND `pid` = 54 [ RunTime:0.000490s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'vip' LIMIT 1 [ RunTime:0.000611s ]
SHOW TABLES LIKE 'bbs_ads_item' [ RunTime:0.000846s ]
SHOW TABLES LIKE 'bbs_ads_package' [ RunTime:0.000921s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'image' [ RunTime:0.001165s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'link' [ RunTime:0.000294s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'style' [ RunTime:0.000498s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'text_body' [ RunTime:0.000445s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'member_id' [ RunTime:0.001177s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'package_id' [ RunTime:0.000494s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'expire_time' [ RunTime:0.000906s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'review_status' [ RunTime:0.000581s ]
SHOW TABLES LIKE 'bbs_ads_package' [ RunTime:0.000423s ]
SHOW COLUMNS FROM `bbs_ads_package` LIKE 'tiers' [ RunTime:0.001228s ]
SHOW COLUMNS FROM `bbs_ads_package` LIKE 'max_count' [ RunTime:0.000632s ]
SHOW COLUMNS FROM `bbs_ads_package` LIKE 'large_count' [ RunTime:0.000322s ]
SHOW COLUMNS FROM `bbs_ads_package` LIKE 'small_count' [ RunTime:0.000359s ]
SHOW COLUMNS FROM `bbs_ads_package` LIKE 'cols_per_row' [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `bbs_ads_package` [ RunTime:0.000560s ]
SELECT * FROM `bbs_ads_package` WHERE ( (tiers IS NULL OR tiers = '') ) [ RunTime:0.002232s ]
UPDATE `bbs_ads_package` SET `large_count` = `max_count` WHERE `large_count` = 0 AND `small_count` = 0 AND `max_count` > 0 [ RunTime:0.001746s ]
SHOW COLUMNS FROM `bbs_ads_item` LIKE 'size' [ RunTime:0.000459s ]
SHOW TABLES LIKE 'bbs_ads_order' [ RunTime:0.000361s ]
SHOW COLUMNS FROM `bbs_ads_order` LIKE 'duration_days' [ RunTime:0.000573s ]
SHOW COLUMNS FROM `bbs_ads_order` LIKE 'size' [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `bbs_ads_item` [ RunTime:0.000489s ]
UPDATE `bbs_ads_item` SET `review_status` = 1 WHERE `review_status` IS NULL [ RunTime:0.000354s ]
ALTER TABLE `bbs_ads_item` MODIFY COLUMN `slot` varchar(160) NOT NULL DEFAULT '' COMMENT '投放区域，逗号多选 ad_left/ad_right/ad_feed_below_slider' [ RunTime:0.001905s ]
ALTER TABLE `bbs_ads_package` MODIFY COLUMN `slot` varchar(160) NOT NULL DEFAULT '' COMMENT '投放区域，逗号多选 ad_left/ad_right/ad_feed_below_slider' [ RunTime:0.002203s ]
ALTER TABLE `bbs_ads_item` MODIFY COLUMN `style` varchar(20) NOT NULL DEFAULT 'image' COMMENT 'image|text|bg_text|icon_title' [ RunTime:0.001530s ]
ALTER TABLE `bbs_ads_package` MODIFY COLUMN `style` varchar(20) NOT NULL DEFAULT 'image' COMMENT 'image|text|bg_text|icon_title' [ RunTime:0.001596s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_left' WHERE `slot` = 'plaza_left_mid' [ RunTime:0.000398s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_right' WHERE `slot` = 'plaza_right_top' [ RunTime:0.000307s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_right' WHERE `slot` = 'plaza_right_mid' [ RunTime:0.000159s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_right' WHERE `slot` = 'plaza_right_bottom' [ RunTime:0.000137s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_detail' WHERE `slot` = 'plaza_feed_top' [ RunTime:0.000132s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_detail' WHERE `slot` = 'topic_after_content' [ RunTime:0.000160s ]
UPDATE `bbs_ads_item` SET `slot` = 'ad_detail' WHERE `slot` = 'topic_before_replies' [ RunTime:0.000169s ]
SELECT * FROM `bbs_ads_item` WHERE `status` = 1 AND `review_status` = 1 AND `package_id` = 0 AND ( FIND_IN_SET('ad_left', `slot`) ) AND ( (expire_time = 0 OR expire_time > '1790977089') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000443s ]
SELECT * FROM `bbs_ads_package` WHERE `status` = 1 AND ( FIND_IN_SET('ad_left', `slot`) ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000263s ]
SELECT * FROM `bbs_ads_item` WHERE `package_id` = 1 AND `status` = 1 AND `review_status` = 1 AND ( (expire_time = 0 OR expire_time > '1790977089') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000373s ]
SELECT COUNT(*) AS think_count FROM `bbs_ads_item` WHERE `package_id` = 1 AND `review_status` IN (0,1) AND `status` = 1 AND ( (expire_time = 0 OR expire_time > '1790977089') ) AND `size` = 'small' [ RunTime:0.000271s ]
SELECT * FROM `bbs_ads_package` WHERE `status` = 1 AND ( FIND_IN_SET('ad_left', `slot`) ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000361s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'slider' LIMIT 1 [ RunTime:0.000381s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'slider' AND `status` = 1 LIMIT 1 [ RunTime:0.000360s ]
SHOW TABLES LIKE 'bbs_slider_item' [ RunTime:0.000449s ]
SHOW COLUMNS FROM `bbs_slider_item` LIKE 'slot' [ RunTime:0.001010s ]
SHOW COLUMNS FROM `bbs_slider_item` LIKE 'image_w' [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `bbs_slider_item` [ RunTime:0.000511s ]
SELECT * FROM `bbs_slider_item` WHERE `status` = 1 AND `slot` = 'home' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000437s ]
SELECT * FROM `bbs_ads_item` WHERE `status` = 1 AND `review_status` = 1 AND `package_id` = 0 AND ( FIND_IN_SET('ad_feed_below_slider', `slot`) ) AND ( (expire_time = 0 OR expire_time > '1790977089') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000553s ]
SELECT * FROM `bbs_ads_package` WHERE `status` = 1 AND ( FIND_IN_SET('ad_feed_below_slider', `slot`) ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000366s ]
SHOW TABLES LIKE 'bbs_signin_log' [ RunTime:0.000753s ]
SHOW COLUMNS FROM `bbs_signin_log` LIKE 'is_makeup' [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `bbs_signin_log` [ RunTime:0.000456s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000623s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000306s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000266s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000187s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/signin_log' LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/signin_log' LIMIT 1 [ RunTime:0.000193s ]
DELETE FROM `bbs_auth_rule` WHERE `name` IN ('admin/signin','admin/signin/save') [ RunTime:0.000205s ]
DELETE FROM `bbs_menu` WHERE `name` IN ('admin/signin','admin/signin/save') [ RunTime:0.000192s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000327s ]
SELECT COUNT(*) AS think_count FROM `bbs_menu` WHERE `delete_time` = 0 AND `pid` = 54 [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `bbs_lottery_sidebar_prize` [ RunTime:0.000781s ]
SELECT * FROM `bbs_lottery_sidebar_prize` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000443s ]
SELECT * FROM `bbs_ads_item` WHERE `status` = 1 AND `review_status` = 1 AND `package_id` = 0 AND ( FIND_IN_SET('ad_right', `slot`) ) AND ( (expire_time = 0 OR expire_time > '1790977089') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000334s ]
SELECT * FROM `bbs_ads_package` WHERE `status` = 1 AND ( FIND_IN_SET('ad_right', `slot`) ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000539s ]
SELECT * FROM `bbs_ads_item` WHERE `package_id` = 1 AND `status` = 1 AND `review_status` = 1 AND ( (expire_time = 0 OR expire_time > '1790977089') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000299s ]
SELECT COUNT(*) AS think_count FROM `bbs_ads_item` WHERE `package_id` = 1 AND `review_status` IN (0,1) AND `status` = 1 AND ( (expire_time = 0 OR expire_time > '1790977089') ) AND `size` = 'small' [ RunTime:0.000274s ]
SELECT * FROM `bbs_ads_package` WHERE `status` = 1 AND ( FIND_IN_SET('ad_right', `slot`) ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000297s ]
SHOW TABLES LIKE 'bbs_friends_link' [ RunTime:0.000625s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `name` = '' LIMIT 1 [ RunTime:0.000495s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `title` = '插件列表' AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000361s ]
DELETE FROM `bbs_menu` WHERE `title` = '广告运营' AND `pid` = 0 AND `type` = 1 [ RunTime:0.000789s ]
DELETE FROM `bbs_auth_rule` WHERE `title` = '广告运营' AND `pid` = 0 AND `name` = '' [ RunTime:0.000391s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends' LIMIT 1 [ RunTime:0.000276s ]
SELECT * FROM `bbs_menu` WHERE `delete_time` = 0 AND `name` = 'admin/friends' LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends/save' LIMIT 1 [ RunTime:0.000307s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends/delete' LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends/status' LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends/audit' LIMIT 1 [ RunTime:0.000596s ]
SELECT * FROM `bbs_auth_rule` WHERE `delete_time` = 0 AND `name` = 'admin/friends/check' LIMIT 1 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `bbs_friends_link` [ RunTime:0.000838s ]
SELECT * FROM `bbs_friends_link` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC LIMIT 12 [ RunTime:0.000382s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'oauth' AND `status` = 1 LIMIT 1 [ RunTime:0.000417s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'oauth' LIMIT 1 [ RunTime:0.000240s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'popup' AND `status` = 1 LIMIT 1 [ RunTime:0.000281s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'popup' LIMIT 1 [ RunTime:0.000237s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'quickreply' AND `status` = 1 LIMIT 1 [ RunTime:0.000407s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'quickreply' LIMIT 1 [ RunTime:0.000531s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'extlink' AND `status` = 1 LIMIT 1 [ RunTime:0.000236s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'extlink' LIMIT 1 [ RunTime:0.000249s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'avatarframe' AND `status` = 1 LIMIT 1 [ RunTime:0.000371s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'avatarframe' LIMIT 1 [ RunTime:0.000248s ]
SHOW TABLES LIKE 'bbs_avatarframe' [ RunTime:0.000629s ]
SHOW COLUMNS FROM `bbs_avatarframe` [ RunTime:0.000740s ]
SHOW TABLES LIKE 'bbs_avatarframe_tag' [ RunTime:0.000431s ]
SHOW COLUMNS FROM `bbs_avatarframe_user` [ RunTime:0.000555s ]
UPDATE `bbs_avatarframe_user` SET `actor_type`='user', `actor_id`=`user_id` WHERE `user_id`>0 AND (`actor_id`=0 OR `actor_type`='' OR `actor_type`='user' AND `actor_id`<> `user_id`) [ RunTime:0.000389s ]
SHOW INDEX FROM `bbs_avatarframe_user` WHERE Key_name='idx_actor_wear' [ RunTime:0.000284s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000307s ]
SHOW TABLES LIKE 'bbs_payment_order' [ RunTime:0.000341s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'taskcenter' AND `status` = 1 LIMIT 1 [ RunTime:0.000283s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'taskcenter' LIMIT 1 [ RunTime:0.000169s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'userban' AND `status` = 1 LIMIT 1 [ RunTime:0.000207s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'userban' LIMIT 1 [ RunTime:0.000216s ]
SELECT * FROM `bbs_plugin` WHERE `name` = 'stat' AND `status` = 1 LIMIT 1 [ RunTime:0.000249s ]
SELECT `config` FROM `bbs_plugin` WHERE `name` = 'stat' LIMIT 1 [ RunTime:0.000169s ]
SELECT COUNT(*) AS c FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = '5gqqw_cn' AND TABLE_NAME = 'bbs_stat_visit_log' AND COLUMN_NAME = 'user_id' [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `bbs_stat_visit` [ RunTime:0.000370s ]
SELECT * FROM `bbs_stat_visit` WHERE `day` = '2026-10-03' LIMIT 1 [ RunTime:0.000204s ]
UPDATE `bbs_stat_visit` SET `pv` = `pv` + 1 , `update_time` = 1790977089 WHERE `id` = 49 [ RunTime:0.001979s ]
SHOW FULL COLUMNS FROM `bbs_stat_visit_log` [ RunTime:0.000433s ]
SELECT * FROM `bbs_stat_visit_log` WHERE `day` = '2026-10-03' AND `visitor` = 'cca1f15d22b9a9d90bc2231ed29abd68' LIMIT 1 [ RunTime:0.000329s ]
