Skip to content

Instantly share code, notes, and snippets.

@csc449

csc449/discourse.log

Created March 22, 2020 14:58
Show Gist options
  • Save csc449/24368d177ecd3c7935e3d06d23c25d32 to your computer and use it in GitHub Desktop.
Save csc449/24368d177ecd3c7935e3d06d23c25d32 to your computer and use it in GitHub Desktop.
Download ZIP
discourse.log
Raw
discourse.log
$ bundle exec rails server
I, [2020-03-22T07:55:40.868562 #6495] INFO -- : Refreshing Gem list
Starting CSS change watcher
(1.3ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'en'
DEPRECATION WARNING: Initialization autoloaded the constants Migration::SafeMigrate, SiteSettings, SiteSettings::DeprecatedSettings, SiteSettingExtension, SiteSettings::YamlLoader, SiteSettings::DefaultsProvider, SiteSettings::Validations, SiteSettings::TypeSupervisor, Enum, RegexSettingValidation, StringSettingValidator, EmailSettingValidator, UsernameSettingValidator, GroupSettingValidator, AllowUserLocaleEnabledValidator, CategoriesTopicsValidator, IntegerSettingValidator, RegexPresenceValidator, CategoryPageStyle, EnableInviteOnlyValidator, EnableLocalLoginsViaEmailValidator, EnableSsoValidator, SsoOverridesEmailValidator, MinUsernameLengthValidator, MaxUsernameLengthValidator, UnicodeUsernameValidator, UnicodeUsernameWhitelistValidator, TrustLevelSetting, EnablePrivateEmailMessagesValidator, MarkdownTypographerQuotationMarksValidator, EmojiSetSiteSetting, ReplyByEmailEnabledValidator, ReplyByEmailAddressValidator, AlternativeReplyByEmailAddressesValidator, POP3PollingEnabledSettingValidator, S3RegionSiteSetting, ExternalSystemAvatarsValidator, ColorListValidator, ReviewableSensitivitySetting, ReviewablePrioritySetting, BackupLocationSiteSetting, CategorySearchPriorityWeightsValidator, SlugSetting, DigestEmailSiteSetting, EmailLevelSiteSetting, MailingListModeSiteSetting, PreviousRepliesSiteSetting, NewTopicDurationSiteSetting, AutoTrackDurationSiteSetting, NotificationLevelWhenReplyingSiteSetting, LikeNotificationFrequencySiteSetting, TrustLevelAndStaffSetting, RemoveMutedTagsFromLatestSiteSetting, SiteSetting, SiteSettings::DbProvider, Site, Searchable, Roleable, HasCustomFields, SecondFactorManager, HasDestroyedWebHook, UserFullNameValidator, AllowedIpAddressValidator, User, MobileDetection, CrawlerDetection, Guardian, TwitterApi, Email, Email::BuildEmailHelper, TranslationOverride, and LocaleSiteSetting.
Being able to do this is deprecated. Autoloading during initialization is going
to be an error condition in future versions of Rails.
Reloading does not reboot the application, and therefore code executed during
initialization does not run again. So, if you reload Migration::SafeMigrate, for example,
the expected changes won't be reflected in that stale Class object.
These autoloaded constants have been unloaded.
Please, check the "Autoloading and Reloading Constants" guide for solutions.
(called from <top (required)> at /home/charles/Downloads/discourse/config/environment.rb:7)
Creating scope :open. Overwriting existing method Poll.open.
I, [2020-03-22T07:55:47.392202 #6495] INFO -- : listening on addr=127.0.0.1:3000 fd=15
UserAvatar Load (2.7ms) SELECT "user_avatars".* FROM "user_avatars" ORDER BY "user_avatars"."id" ASC LIMIT 1
UserProfile Load (2.2ms) SELECT "user_profiles".* FROM "user_profiles" ORDER BY "user_profiles"."user_id" ASC LIMIT 1
QuotedPost Load (1.3ms) SELECT "quoted_posts".* FROM "quoted_posts" ORDER BY "quoted_posts"."id" ASC LIMIT 1
Upload Load (6.2ms) SELECT "uploads".* FROM "uploads" ORDER BY "uploads"."id" ASC LIMIT 1
Badge Load (2.9ms) SELECT "badges".* FROM "badges" ORDER BY "badges"."id" ASC LIMIT 1
BadgeGrouping Load (1.1ms) SELECT "badge_groupings".* FROM "badge_groupings" ORDER BY "badge_groupings"."id" ASC LIMIT 1
Post Load (6.5ms) SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) ORDER BY "posts"."id" ASC LIMIT 1
IncomingReferer Load (1.0ms) SELECT "incoming_referers".* FROM "incoming_referers" ORDER BY "incoming_referers"."id" ASC LIMIT 1
TopicLink Load (3.4ms) SELECT "topic_links".* FROM "topic_links" ORDER BY "topic_links"."id" ASC LIMIT 1
PostTiming Load (1.9ms) SELECT "post_timings".* FROM "post_timings" LIMIT 1
TopicUser Load (1.8ms) SELECT "topic_users".* FROM "topic_users" ORDER BY "topic_users"."id" ASC LIMIT 1
IncomingDomain Load (1.0ms) SELECT "incoming_domains".* FROM "incoming_domains" ORDER BY "incoming_domains"."id" ASC LIMIT 1
Notification Load (3.4ms) SELECT "notifications".* FROM "notifications" ORDER BY "notifications"."id" ASC LIMIT 1
PostReply Load (1.0ms) SELECT "post_replies"."post_id", "post_replies"."created_at", "post_replies"."updated_at", "post_replies"."reply_post_id" FROM "post_replies" LIMIT 1
IncomingLink Load (1.4ms) SELECT "incoming_links".* FROM "incoming_links" ORDER BY "incoming_links"."id" ASC LIMIT 1
SiteSetting Load (0.8ms) SELECT "site_settings".* FROM "site_settings" ORDER BY "site_settings"."id" ASC LIMIT 1
CategoryFeaturedTopic Load (1.6ms) SELECT "category_featured_topics".* FROM "category_featured_topics" ORDER BY "category_featured_topics"."id" ASC LIMIT 1
UserOpenId Load (1.8ms) SELECT "user_open_ids".* FROM "user_open_ids" ORDER BY "user_open_ids"."id" ASC LIMIT 1
UserAction Load (3.0ms) SELECT "user_actions".* FROM "user_actions" ORDER BY "user_actions"."id" ASC LIMIT 1
PostAction Load (3.7ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) ORDER BY "post_actions"."id" ASC LIMIT 1
TopicLinkClick Load (1.1ms) SELECT "topic_link_clicks".* FROM "topic_link_clicks" ORDER BY "topic_link_clicks"."id" ASC LIMIT 1
PostActionType Load (1.2ms) SELECT "post_action_types".* FROM "post_action_types" ORDER BY "post_action_types"."id" ASC LIMIT 1
TopicAllowedUser Load (1.7ms) SELECT "topic_allowed_users".* FROM "topic_allowed_users" ORDER BY "topic_allowed_users"."id" ASC LIMIT 1
EmailLog Load (3.2ms) SELECT "email_logs".* FROM "email_logs" ORDER BY "email_logs"."id" ASC LIMIT 1
Category Load (3.5ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" ORDER BY "categories"."id" ASC LIMIT 1
TopicInvite Load (1.5ms) SELECT "topic_invites".* FROM "topic_invites" ORDER BY "topic_invites"."id" ASC LIMIT 1
EmailToken Load (2.2ms) SELECT "email_tokens".* FROM "email_tokens" ORDER BY "email_tokens"."id" ASC LIMIT 1
UserVisit Load (2.4ms) SELECT "user_visits".* FROM "user_visits" ORDER BY "user_visits"."id" ASC LIMIT 1
DraftSequence Load (1.4ms) SELECT "draft_sequences".* FROM "draft_sequences" ORDER BY "draft_sequences"."id" ASC LIMIT 1
Permalink Load (1.1ms) SELECT "permalinks".* FROM "permalinks" ORDER BY "permalinks"."id" ASC LIMIT 1
Draft Load (1.3ms) SELECT "drafts".* FROM "drafts" ORDER BY "drafts"."id" ASC LIMIT 1
Invite Load (2.5ms) SELECT "invites".* FROM "invites" WHERE ("invites"."deleted_at" IS NULL) ORDER BY "invites"."id" ASC LIMIT 1
GithubUserInfo Load (2.1ms) SELECT "github_user_infos".* FROM "github_user_infos" ORDER BY "github_user_infos"."id" ASC LIMIT 1
UserWarning Load (1.3ms) SELECT "user_warnings".* FROM "user_warnings" ORDER BY "user_warnings"."id" ASC LIMIT 1
Group Load (2.3ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."id" ASC LIMIT 1
TopicAllowedGroup Load (1.7ms) SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" ORDER BY "topic_allowed_groups"."id" ASC LIMIT 1
CategoryGroup Load (1.7ms) SELECT "category_groups".* FROM "category_groups" ORDER BY "category_groups"."id" ASC LIMIT 1
GroupUser Load (2.2ms) SELECT "group_users".* FROM "group_users" ORDER BY "group_users"."id" ASC LIMIT 1
UserField Load (1.3ms) SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."id" ASC LIMIT 1
UserExport Load (0.8ms) SELECT "user_exports".* FROM "user_exports" ORDER BY "user_exports"."id" ASC LIMIT 1
PostUpload Load (1.4ms) SELECT "post_uploads".* FROM "post_uploads" ORDER BY "post_uploads"."id" ASC LIMIT 1
ApplicationRequest Load (0.8ms) SELECT "application_requests".* FROM "application_requests" ORDER BY "application_requests"."id" ASC LIMIT 1
Oauth2UserInfo Load (1.8ms) SELECT "oauth2_user_infos".* FROM "oauth2_user_infos" ORDER BY "oauth2_user_infos"."id" ASC LIMIT 1
ScreenedEmail Load (2.7ms) SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."id" ASC LIMIT 1
ScreenedUrl Load (1.3ms) SELECT "screened_urls".* FROM "screened_urls" ORDER BY "screened_urls"."id" ASC LIMIT 1
PluginStoreRow Load (1.3ms) SELECT "plugin_store_rows".* FROM "plugin_store_rows" ORDER BY "plugin_store_rows"."id" ASC LIMIT 1
ScreenedIpAddress Load (1.6ms) SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" ORDER BY "screened_ip_addresses"."id" ASC LIMIT 1
PostDetail Load (0.9ms) SELECT "post_details".* FROM "post_details" ORDER BY "post_details"."id" ASC LIMIT 1
UserHistory Load (2.6ms) SELECT "user_histories".* FROM "user_histories" ORDER BY "user_histories"."id" ASC LIMIT 1
ApiKey Load (1.7ms) SELECT "api_keys".* FROM "api_keys" ORDER BY "api_keys"."id" ASC LIMIT 1
PostRevision Load (1.9ms) SELECT "post_revisions".* FROM "post_revisions" ORDER BY "post_revisions"."id" ASC LIMIT 1
CategoryUser Load (2.8ms) SELECT "category_users".* FROM "category_users" ORDER BY "category_users"."id" ASC LIMIT 1
TopicEmbed Load (1.6ms) SELECT "topic_embeds".* FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) ORDER BY "topic_embeds"."id" ASC LIMIT 1
TopTopic Load (11.1ms) SELECT "top_topics".* FROM "top_topics" ORDER BY "top_topics"."id" ASC LIMIT 1
BadgeType Load (3.2ms) SELECT "badge_types".* FROM "badge_types" ORDER BY "badge_types"."id" ASC LIMIT 1
ColorScheme Load (1.3ms) SELECT "color_schemes".* FROM "color_schemes" ORDER BY "color_schemes"."id" ASC LIMIT 1
ColorSchemeColor Load (1.3ms) SELECT "color_scheme_colors".* FROM "color_scheme_colors" ORDER BY "color_scheme_colors"."id" ASC LIMIT 1
UserCustomField Load (1.2ms) SELECT "user_custom_fields".* FROM "user_custom_fields" ORDER BY "user_custom_fields"."id" ASC LIMIT 1
UserBadge Load (1.9ms) SELECT "user_badges".* FROM "user_badges" ORDER BY "user_badges"."id" ASC LIMIT 1
SingleSignOnRecord Load (1.7ms) SELECT "single_sign_on_records".* FROM "single_sign_on_records" ORDER BY "single_sign_on_records"."id" ASC LIMIT 1
CategoryCustomField Load (0.9ms) SELECT "category_custom_fields".* FROM "category_custom_fields" ORDER BY "category_custom_fields"."id" ASC LIMIT 1
GroupCustomField Load (1.6ms) SELECT "group_custom_fields".* FROM "group_custom_fields" ORDER BY "group_custom_fields"."id" ASC LIMIT 1
PostCustomField Load (4.2ms) SELECT "post_custom_fields".* FROM "post_custom_fields" ORDER BY "post_custom_fields"."id" ASC LIMIT 1
TopicCustomField Load (1.4ms) SELECT "topic_custom_fields".* FROM "topic_custom_fields" ORDER BY "topic_custom_fields"."id" ASC LIMIT 1
InvitedGroup Load (0.7ms) SELECT "invited_groups".* FROM "invited_groups" ORDER BY "invited_groups"."id" ASC LIMIT 1
MutedUser Load (1.7ms) SELECT "muted_users".* FROM "muted_users" ORDER BY "muted_users"."id" ASC LIMIT 1
DirectoryItem Load (3.6ms) SELECT "directory_items".* FROM "directory_items" ORDER BY "directory_items"."id" ASC LIMIT 1
EmbeddableHost Load (0.8ms) SELECT "embeddable_hosts".* FROM "embeddable_hosts" ORDER BY "embeddable_hosts"."id" ASC LIMIT 1
UserFieldOption Load (0.9ms) SELECT "user_field_options".* FROM "user_field_options" ORDER BY "user_field_options"."id" ASC LIMIT 1
PostStat Load (2.4ms) SELECT "post_stats".* FROM "post_stats" ORDER BY "post_stats"."id" ASC LIMIT 1
UserProfileView Load (2.5ms) SELECT "user_profile_views".* FROM "user_profile_views" ORDER BY "user_profile_views"."id" ASC LIMIT 1
StylesheetCache Load (12.2ms) SELECT "stylesheet_cache".* FROM "stylesheet_cache" ORDER BY "stylesheet_cache"."id" ASC LIMIT 1
GroupMention Load (2.0ms) SELECT "group_mentions".* FROM "group_mentions" ORDER BY "group_mentions"."id" ASC LIMIT 1
UserArchivedMessage Load (1.1ms) SELECT "user_archived_messages".* FROM "user_archived_messages" ORDER BY "user_archived_messages"."id" ASC LIMIT 1
GroupArchivedMessage Load (1.0ms) SELECT "group_archived_messages".* FROM "group_archived_messages" ORDER BY "group_archived_messages"."id" ASC LIMIT 1
EmailChangeRequest Load (1.3ms) SELECT "email_change_requests".* FROM "email_change_requests" ORDER BY "email_change_requests"."id" ASC LIMIT 1
TopicTag Load (1.2ms) SELECT "topic_tags".* FROM "topic_tags" ORDER BY "topic_tags"."id" ASC LIMIT 1
GivenDailyLike Load (0.9ms) SELECT "given_daily_likes".* FROM "given_daily_likes" LIMIT 1
OnceoffLog Load (2.2ms) SELECT "onceoff_logs".* FROM "onceoff_logs" ORDER BY "onceoff_logs"."id" ASC LIMIT 1
TranslationOverride Load (0.4ms) SELECT "translation_overrides".* FROM "translation_overrides" ORDER BY "translation_overrides"."id" ASC LIMIT 1
IncomingEmail Load (2.2ms) SELECT "incoming_emails".* FROM "incoming_emails" ORDER BY "incoming_emails"."id" ASC LIMIT 1
TagUser Load (2.1ms) SELECT "tag_users".* FROM "tag_users" ORDER BY "tag_users"."id" ASC LIMIT 1
CategoryTag Load (1.4ms) SELECT "category_tags".* FROM "category_tags" ORDER BY "category_tags"."id" ASC LIMIT 1
Tag Load (1.2ms) SELECT "tags".* FROM "tags" ORDER BY "tags"."id" ASC LIMIT 1
TagGroupMembership Load (1.0ms) SELECT "tag_group_memberships".* FROM "tag_group_memberships" ORDER BY "tag_group_memberships"."id" ASC LIMIT 1
CategoryTagGroup Load (1.5ms) SELECT "category_tag_groups".* FROM "category_tag_groups" ORDER BY "category_tag_groups"."id" ASC LIMIT 1
TagGroup Load (1.8ms) SELECT "tag_groups".* FROM "tag_groups" ORDER BY "tag_groups"."id" ASC LIMIT 1
UnsubscribeKey Load (1.0ms) SELECT "unsubscribe_keys".* FROM "unsubscribe_keys" ORDER BY "unsubscribe_keys"."key" ASC LIMIT 1
Developer Load (1.7ms) SELECT "developers".* FROM "developers" ORDER BY "developers"."id" ASC LIMIT 1
WebHookEventType Load (1.2ms) SELECT "web_hook_event_types".* FROM "web_hook_event_types" ORDER BY id ASC LIMIT 1
WebHook Load (0.9ms) SELECT "web_hooks".* FROM "web_hooks" ORDER BY id ASC LIMIT 1
UserApiKey Load (2.1ms) SELECT "user_api_keys".* FROM "user_api_keys" ORDER BY "user_api_keys"."id" ASC LIMIT 1
WebHookEvent Load (1.3ms) SELECT "web_hook_events".* FROM "web_hook_events" ORDER BY created_at DESC LIMIT 1
GroupHistory Load (1.9ms) SELECT "group_histories".* FROM "group_histories" ORDER BY "group_histories"."id" ASC LIMIT 1
Topic Load (5.8ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) ORDER BY "topics"."id" ASC LIMIT 1
CustomEmoji Load (1.4ms) SELECT "custom_emojis".* FROM "custom_emojis" ORDER BY "custom_emojis"."id" ASC LIMIT 1
UserAuthToken Load (2.1ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" ORDER BY "user_auth_tokens"."id" ASC LIMIT 1
UserAuthTokenLog Load (1.2ms) SELECT "user_auth_token_logs".* FROM "user_auth_token_logs" ORDER BY "user_auth_token_logs"."id" ASC LIMIT 1
ChildTheme Load (2.2ms) SELECT "child_themes".* FROM "child_themes" ORDER BY "child_themes"."id" ASC LIMIT 1
RemoteTheme Load (0.7ms) SELECT "remote_themes".* FROM "remote_themes" ORDER BY "remote_themes"."id" ASC LIMIT 1
TopicTimer Load (1.7ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) ORDER BY "topic_timers"."id" ASC LIMIT 1
ThemeField Load (1.2ms) SELECT "theme_fields".* FROM "theme_fields" ORDER BY "theme_fields"."id" ASC LIMIT 1
WatchedWord Load (1.0ms) SELECT "watched_words".* FROM "watched_words" ORDER BY "watched_words"."id" ASC LIMIT 1
UserEmail Load (1.8ms) SELECT "user_emails".* FROM "user_emails" ORDER BY "user_emails"."id" ASC LIMIT 1
Theme Load (1.4ms) SELECT "themes".* FROM "themes" ORDER BY "themes"."id" ASC LIMIT 1
User Load (1.4ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1
UserOption Load (2.5ms) SELECT "user_options".* FROM "user_options" ORDER BY "user_options"."user_id" ASC LIMIT 1
SearchLog Load (1.7ms) SELECT "search_logs".* FROM "search_logs" ORDER BY "search_logs"."id" ASC LIMIT 1
ThemeSetting Load (0.8ms) SELECT "theme_settings".* FROM "theme_settings" ORDER BY "theme_settings"."id" ASC LIMIT 1
CategoryTagStat Load (3.2ms) SELECT "category_tag_stats".* FROM "category_tag_stats" ORDER BY "category_tag_stats"."id" ASC LIMIT 1
WebCrawlerRequest Load (1.2ms) SELECT "web_crawler_requests".* FROM "web_crawler_requests" ORDER BY "web_crawler_requests"."id" ASC LIMIT 1
TagGroupPermission Load (1.2ms) SELECT "tag_group_permissions".* FROM "tag_group_permissions" ORDER BY "tag_group_permissions"."id" ASC LIMIT 1
SharedDraft Load (1.5ms) SELECT "shared_drafts".* FROM "shared_drafts" ORDER BY "shared_drafts"."id" ASC LIMIT 1
PushSubscription Load (0.7ms) SELECT "push_subscriptions".* FROM "push_subscriptions" ORDER BY "push_subscriptions"."id" ASC LIMIT 1
UserSecondFactor Load (1.2ms) SELECT "user_second_factors".* FROM "user_second_factors" ORDER BY "user_second_factors"."id" ASC LIMIT 1
PostReplyKey Load (2.4ms) SELECT "post_reply_keys".* FROM "post_reply_keys" ORDER BY "post_reply_keys"."id" ASC LIMIT 1
SkippedEmailLog Load (2.4ms) SELECT "skipped_email_logs".* FROM "skipped_email_logs" ORDER BY "skipped_email_logs"."id" ASC LIMIT 1
Poll Load (1.5ms) SELECT "polls".* FROM "polls" ORDER BY "polls"."id" ASC LIMIT 1
PollOption Load (1.4ms) SELECT "poll_options".* FROM "poll_options" ORDER BY "poll_options"."id" ASC LIMIT 1
PollVote Load (1.8ms) SELECT "poll_votes".* FROM "poll_votes" LIMIT 1
UserUpload Load (2.6ms) SELECT "user_uploads".* FROM "user_uploads" ORDER BY "user_uploads"."id" ASC LIMIT 1
UserStat Load (2.6ms) SELECT "user_stats".* FROM "user_stats" ORDER BY "user_stats"."user_id" ASC LIMIT 1
UserAssociatedAccount Load (1.1ms) SELECT "user_associated_accounts".* FROM "user_associated_accounts" ORDER BY "user_associated_accounts"."id" ASC LIMIT 1
ThemeTranslationOverride Load (1.7ms) SELECT "theme_translation_overrides".* FROM "theme_translation_overrides" ORDER BY "theme_translation_overrides"."id" ASC LIMIT 1
OptimizedImage Load (2.4ms) SELECT "optimized_images".* FROM "optimized_images" ORDER BY "optimized_images"."id" ASC LIMIT 1
Reviewable Load (2.5ms) SELECT "reviewables".* FROM "reviewables" ORDER BY "reviewables"."id" ASC LIMIT 1
ReviewableHistory Load (1.2ms) SELECT "reviewable_histories".* FROM "reviewable_histories" ORDER BY "reviewable_histories"."id" ASC LIMIT 1
GroupRequest Load (1.4ms) SELECT "group_requests".* FROM "group_requests" ORDER BY "group_requests"."id" ASC LIMIT 1
IgnoredUser Load (1.6ms) SELECT "ignored_users".* FROM "ignored_users" ORDER BY "ignored_users"."id" ASC LIMIT 1
ReviewableClaimedTopic Load (1.1ms) SELECT "reviewable_claimed_topics".* FROM "reviewable_claimed_topics" ORDER BY "reviewable_claimed_topics"."id" ASC LIMIT 1
AnonymousUser Load (1.4ms) SELECT "anonymous_users".* FROM "anonymous_users" ORDER BY "anonymous_users"."id" ASC LIMIT 1
TopicGroup Load (0.9ms) SELECT "topic_groups".* FROM "topic_groups" ORDER BY "topic_groups"."id" ASC LIMIT 1
UserSecurityKey Load (2.4ms) SELECT "user_security_keys".* FROM "user_security_keys" ORDER BY "user_security_keys"."id" ASC LIMIT 1
ReviewableScore Load (2.3ms) SELECT "reviewable_scores".* FROM "reviewable_scores" ORDER BY "reviewable_scores"."id" ASC LIMIT 1
BackupDraftTopic Load (1.2ms) SELECT "backup_draft_topics".* FROM "backup_draft_topics" ORDER BY "backup_draft_topics"."id" ASC LIMIT 1
BackupDraftPost Load (2.0ms) SELECT "backup_draft_posts".* FROM "backup_draft_posts" ORDER BY "backup_draft_posts"."id" ASC LIMIT 1
(0.5ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'en'
Bookmark Load (3.3ms) SELECT "bookmarks".* FROM "bookmarks" ORDER BY "bookmarks"."id" ASC LIMIT 1
ThemeModifierSet Load (1.5ms) SELECT "theme_modifier_sets".* FROM "theme_modifier_sets" ORDER BY "theme_modifier_sets"."id" ASC LIMIT 1
Permalink Exists? (0.5ms) SELECT 1 AS one FROM "permalinks" WHERE "permalinks"."url" = 'abc' LIMIT 1
Permalink Exists? (1.4ms) SELECT 1 AS one FROM "permalinks" WHERE "permalinks"."url" = 'abc' LIMIT 1
Starting up 1 supervised sidekiqs
Loading Sidekiq in process id 6570
UserAvatar Load (1.0ms) SELECT "user_avatars".* FROM "user_avatars" ORDER BY "user_avatars"."id" ASC LIMIT 1
UserProfile Load (2.6ms) SELECT "user_profiles".* FROM "user_profiles" ORDER BY "user_profiles"."user_id" ASC LIMIT 1
QuotedPost Load (2.8ms) SELECT "quoted_posts".* FROM "quoted_posts" ORDER BY "quoted_posts"."id" ASC LIMIT 1
Upload Load (3.6ms) SELECT "uploads".* FROM "uploads" ORDER BY "uploads"."id" ASC LIMIT 1
Badge Load (3.1ms) SELECT "badges".* FROM "badges" ORDER BY "badges"."id" ASC LIMIT 1
BadgeGrouping Load (2.8ms) SELECT "badge_groupings".* FROM "badge_groupings" ORDER BY "badge_groupings"."id" ASC LIMIT 1
Post Load (3.6ms) SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) ORDER BY "posts"."id" ASC LIMIT 1
IncomingReferer Load (4.2ms) SELECT "incoming_referers".* FROM "incoming_referers" ORDER BY "incoming_referers"."id" ASC LIMIT 1
TopicLink Load (3.9ms) SELECT "topic_links".* FROM "topic_links" ORDER BY "topic_links"."id" ASC LIMIT 1
PostTiming Load (6.0ms) SELECT "post_timings".* FROM "post_timings" LIMIT 1
TopicUser Load (2.9ms) SELECT "topic_users".* FROM "topic_users" ORDER BY "topic_users"."id" ASC LIMIT 1
IncomingDomain Load (2.6ms) SELECT "incoming_domains".* FROM "incoming_domains" ORDER BY "incoming_domains"."id" ASC LIMIT 1
Notification Load (3.1ms) SELECT "notifications".* FROM "notifications" ORDER BY "notifications"."id" ASC LIMIT 1
PostReply Load (1.7ms) SELECT "post_replies"."post_id", "post_replies"."created_at", "post_replies"."updated_at", "post_replies"."reply_post_id" FROM "post_replies" LIMIT 1
IncomingLink Load (2.7ms) SELECT "incoming_links".* FROM "incoming_links" ORDER BY "incoming_links"."id" ASC LIMIT 1
SiteSetting Load (2.9ms) SELECT "site_settings".* FROM "site_settings" ORDER BY "site_settings"."id" ASC LIMIT 1
CategoryFeaturedTopic Load (3.9ms) SELECT "category_featured_topics".* FROM "category_featured_topics" ORDER BY "category_featured_topics"."id" ASC LIMIT 1
UserOpenId Load (4.6ms) SELECT "user_open_ids".* FROM "user_open_ids" ORDER BY "user_open_ids"."id" ASC LIMIT 1
UserAction Load (2.2ms) SELECT "user_actions".* FROM "user_actions" ORDER BY "user_actions"."id" ASC LIMIT 1
PostAction Load (2.1ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) ORDER BY "post_actions"."id" ASC LIMIT 1
TopicLinkClick Load (2.3ms) SELECT "topic_link_clicks".* FROM "topic_link_clicks" ORDER BY "topic_link_clicks"."id" ASC LIMIT 1
PostActionType Load (0.7ms) SELECT "post_action_types".* FROM "post_action_types" ORDER BY "post_action_types"."id" ASC LIMIT 1
TopicAllowedUser Load (3.3ms) SELECT "topic_allowed_users".* FROM "topic_allowed_users" ORDER BY "topic_allowed_users"."id" ASC LIMIT 1
EmailLog Load (1.4ms) SELECT "email_logs".* FROM "email_logs" ORDER BY "email_logs"."id" ASC LIMIT 1
Category Load (5.8ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" ORDER BY "categories"."id" ASC LIMIT 1
TopicInvite Load (2.0ms) SELECT "topic_invites".* FROM "topic_invites" ORDER BY "topic_invites"."id" ASC LIMIT 1
EmailToken Load (3.8ms) SELECT "email_tokens".* FROM "email_tokens" ORDER BY "email_tokens"."id" ASC LIMIT 1
UserVisit Load (2.3ms) SELECT "user_visits".* FROM "user_visits" ORDER BY "user_visits"."id" ASC LIMIT 1
DraftSequence Load (2.6ms) SELECT "draft_sequences".* FROM "draft_sequences" ORDER BY "draft_sequences"."id" ASC LIMIT 1
Permalink Load (3.6ms) SELECT "permalinks".* FROM "permalinks" ORDER BY "permalinks"."id" ASC LIMIT 1
Draft Load (6.5ms) SELECT "drafts".* FROM "drafts" ORDER BY "drafts"."id" ASC LIMIT 1
Invite Load (1.8ms) SELECT "invites".* FROM "invites" WHERE ("invites"."deleted_at" IS NULL) ORDER BY "invites"."id" ASC LIMIT 1
GithubUserInfo Load (2.1ms) SELECT "github_user_infos".* FROM "github_user_infos" ORDER BY "github_user_infos"."id" ASC LIMIT 1
UserWarning Load (2.0ms) SELECT "user_warnings".* FROM "user_warnings" ORDER BY "user_warnings"."id" ASC LIMIT 1
Group Load (2.1ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."id" ASC LIMIT 1
TopicAllowedGroup Load (3.5ms) SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" ORDER BY "topic_allowed_groups"."id" ASC LIMIT 1
CategoryGroup Load (6.2ms) SELECT "category_groups".* FROM "category_groups" ORDER BY "category_groups"."id" ASC LIMIT 1
GroupUser Load (2.5ms) SELECT "group_users".* FROM "group_users" ORDER BY "group_users"."id" ASC LIMIT 1
UserField Load (3.0ms) SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."id" ASC LIMIT 1
UserExport Load (2.2ms) SELECT "user_exports".* FROM "user_exports" ORDER BY "user_exports"."id" ASC LIMIT 1
PostUpload Load (2.4ms) SELECT "post_uploads".* FROM "post_uploads" ORDER BY "post_uploads"."id" ASC LIMIT 1
ApplicationRequest Load (3.7ms) SELECT "application_requests".* FROM "application_requests" ORDER BY "application_requests"."id" ASC LIMIT 1
Oauth2UserInfo Load (4.7ms) SELECT "oauth2_user_infos".* FROM "oauth2_user_infos" ORDER BY "oauth2_user_infos"."id" ASC LIMIT 1
ScreenedEmail Load (2.6ms) SELECT "screened_emails".* FROM "screened_emails" ORDER BY "screened_emails"."id" ASC LIMIT 1
ScreenedUrl Load (2.2ms) SELECT "screened_urls".* FROM "screened_urls" ORDER BY "screened_urls"."id" ASC LIMIT 1
PluginStoreRow Load (1.9ms) SELECT "plugin_store_rows".* FROM "plugin_store_rows" ORDER BY "plugin_store_rows"."id" ASC LIMIT 1
ScreenedIpAddress Load (1.7ms) SELECT "screened_ip_addresses".* FROM "screened_ip_addresses" ORDER BY "screened_ip_addresses"."id" ASC LIMIT 1
PostDetail Load (1.5ms) SELECT "post_details".* FROM "post_details" ORDER BY "post_details"."id" ASC LIMIT 1
UserHistory Load (3.3ms) SELECT "user_histories".* FROM "user_histories" ORDER BY "user_histories"."id" ASC LIMIT 1
ApiKey Load (1.6ms) SELECT "api_keys".* FROM "api_keys" ORDER BY "api_keys"."id" ASC LIMIT 1
PostRevision Load (4.7ms) SELECT "post_revisions".* FROM "post_revisions" ORDER BY "post_revisions"."id" ASC LIMIT 1
CategoryUser Load (2.9ms) SELECT "category_users".* FROM "category_users" ORDER BY "category_users"."id" ASC LIMIT 1
TopicEmbed Load (2.1ms) SELECT "topic_embeds".* FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) ORDER BY "topic_embeds"."id" ASC LIMIT 1
TopTopic Load (4.5ms) SELECT "top_topics".* FROM "top_topics" ORDER BY "top_topics"."id" ASC LIMIT 1
BadgeType Load (3.5ms) SELECT "badge_types".* FROM "badge_types" ORDER BY "badge_types"."id" ASC LIMIT 1
ColorScheme Load (0.6ms) SELECT "color_schemes".* FROM "color_schemes" ORDER BY "color_schemes"."id" ASC LIMIT 1
ColorSchemeColor Load (5.3ms) SELECT "color_scheme_colors".* FROM "color_scheme_colors" ORDER BY "color_scheme_colors"."id" ASC LIMIT 1
UserCustomField Load (2.8ms) SELECT "user_custom_fields".* FROM "user_custom_fields" ORDER BY "user_custom_fields"."id" ASC LIMIT 1
UserBadge Load (2.5ms) SELECT "user_badges".* FROM "user_badges" ORDER BY "user_badges"."id" ASC LIMIT 1
SingleSignOnRecord Load (3.0ms) SELECT "single_sign_on_records".* FROM "single_sign_on_records" ORDER BY "single_sign_on_records"."id" ASC LIMIT 1
CategoryCustomField Load (4.8ms) SELECT "category_custom_fields".* FROM "category_custom_fields" ORDER BY "category_custom_fields"."id" ASC LIMIT 1
GroupCustomField Load (2.6ms) SELECT "group_custom_fields".* FROM "group_custom_fields" ORDER BY "group_custom_fields"."id" ASC LIMIT 1
PostCustomField Load (5.2ms) SELECT "post_custom_fields".* FROM "post_custom_fields" ORDER BY "post_custom_fields"."id" ASC LIMIT 1
TopicCustomField Load (2.5ms) SELECT "topic_custom_fields".* FROM "topic_custom_fields" ORDER BY "topic_custom_fields"."id" ASC LIMIT 1
InvitedGroup Load (2.5ms) SELECT "invited_groups".* FROM "invited_groups" ORDER BY "invited_groups"."id" ASC LIMIT 1
MutedUser Load (3.4ms) SELECT "muted_users".* FROM "muted_users" ORDER BY "muted_users"."id" ASC LIMIT 1
DirectoryItem Load (3.7ms) SELECT "directory_items".* FROM "directory_items" ORDER BY "directory_items"."id" ASC LIMIT 1
EmbeddableHost Load (2.1ms) SELECT "embeddable_hosts".* FROM "embeddable_hosts" ORDER BY "embeddable_hosts"."id" ASC LIMIT 1
UserFieldOption Load (4.8ms) SELECT "user_field_options".* FROM "user_field_options" ORDER BY "user_field_options"."id" ASC LIMIT 1
PostStat Load (3.7ms) SELECT "post_stats".* FROM "post_stats" ORDER BY "post_stats"."id" ASC LIMIT 1
UserProfileView Load (1.7ms) SELECT "user_profile_views".* FROM "user_profile_views" ORDER BY "user_profile_views"."id" ASC LIMIT 1
StylesheetCache Load (10.0ms) SELECT "stylesheet_cache".* FROM "stylesheet_cache" ORDER BY "stylesheet_cache"."id" ASC LIMIT 1
GroupMention Load (1.5ms) SELECT "group_mentions".* FROM "group_mentions" ORDER BY "group_mentions"."id" ASC LIMIT 1
UserArchivedMessage Load (1.1ms) SELECT "user_archived_messages".* FROM "user_archived_messages" ORDER BY "user_archived_messages"."id" ASC LIMIT 1
GroupArchivedMessage Load (4.3ms) SELECT "group_archived_messages".* FROM "group_archived_messages" ORDER BY "group_archived_messages"."id" ASC LIMIT 1
EmailChangeRequest Load (2.3ms) SELECT "email_change_requests".* FROM "email_change_requests" ORDER BY "email_change_requests"."id" ASC LIMIT 1
TopicTag Load (1.4ms) SELECT "topic_tags".* FROM "topic_tags" ORDER BY "topic_tags"."id" ASC LIMIT 1
GivenDailyLike Load (5.4ms) SELECT "given_daily_likes".* FROM "given_daily_likes" LIMIT 1
OnceoffLog Load (3.1ms) SELECT "onceoff_logs".* FROM "onceoff_logs" ORDER BY "onceoff_logs"."id" ASC LIMIT 1
TranslationOverride Load (57.2ms) SELECT "translation_overrides".* FROM "translation_overrides" ORDER BY "translation_overrides"."id" ASC LIMIT 1
IncomingEmail Load (2.7ms) SELECT "incoming_emails".* FROM "incoming_emails" ORDER BY "incoming_emails"."id" ASC LIMIT 1
TagUser Load (2.5ms) SELECT "tag_users".* FROM "tag_users" ORDER BY "tag_users"."id" ASC LIMIT 1
CategoryTag Load (3.0ms) SELECT "category_tags".* FROM "category_tags" ORDER BY "category_tags"."id" ASC LIMIT 1
Tag Load (2.0ms) SELECT "tags".* FROM "tags" ORDER BY "tags"."id" ASC LIMIT 1
TagGroupMembership Load (3.4ms) SELECT "tag_group_memberships".* FROM "tag_group_memberships" ORDER BY "tag_group_memberships"."id" ASC LIMIT 1
CategoryTagGroup Load (2.3ms) SELECT "category_tag_groups".* FROM "category_tag_groups" ORDER BY "category_tag_groups"."id" ASC LIMIT 1
TagGroup Load (2.6ms) SELECT "tag_groups".* FROM "tag_groups" ORDER BY "tag_groups"."id" ASC LIMIT 1
UnsubscribeKey Load (6.1ms) SELECT "unsubscribe_keys".* FROM "unsubscribe_keys" ORDER BY "unsubscribe_keys"."key" ASC LIMIT 1
Developer Load (4.3ms) SELECT "developers".* FROM "developers" ORDER BY "developers"."id" ASC LIMIT 1
WebHookEventType Load (4.0ms) SELECT "web_hook_event_types".* FROM "web_hook_event_types" ORDER BY id ASC LIMIT 1
WebHook Load (2.8ms) SELECT "web_hooks".* FROM "web_hooks" ORDER BY id ASC LIMIT 1
UserApiKey Load (4.4ms) SELECT "user_api_keys".* FROM "user_api_keys" ORDER BY "user_api_keys"."id" ASC LIMIT 1
WebHookEvent Load (3.0ms) SELECT "web_hook_events".* FROM "web_hook_events" ORDER BY created_at DESC LIMIT 1
GroupHistory Load (2.0ms) SELECT "group_histories".* FROM "group_histories" ORDER BY "group_histories"."id" ASC LIMIT 1
Topic Load (2.7ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) ORDER BY "topics"."id" ASC LIMIT 1
CustomEmoji Load (1.9ms) SELECT "custom_emojis".* FROM "custom_emojis" ORDER BY "custom_emojis"."id" ASC LIMIT 1
UserAuthToken Load (5.6ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" ORDER BY "user_auth_tokens"."id" ASC LIMIT 1
UserAuthTokenLog Load (2.1ms) SELECT "user_auth_token_logs".* FROM "user_auth_token_logs" ORDER BY "user_auth_token_logs"."id" ASC LIMIT 1
ChildTheme Load (1.4ms) SELECT "child_themes".* FROM "child_themes" ORDER BY "child_themes"."id" ASC LIMIT 1
RemoteTheme Load (0.9ms) SELECT "remote_themes".* FROM "remote_themes" ORDER BY "remote_themes"."id" ASC LIMIT 1
TopicTimer Load (3.2ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) ORDER BY "topic_timers"."id" ASC LIMIT 1
ThemeField Load (2.3ms) SELECT "theme_fields".* FROM "theme_fields" ORDER BY "theme_fields"."id" ASC LIMIT 1
WatchedWord Load (2.2ms) SELECT "watched_words".* FROM "watched_words" ORDER BY "watched_words"."id" ASC LIMIT 1
UserEmail Load (1.8ms) SELECT "user_emails".* FROM "user_emails" ORDER BY "user_emails"."id" ASC LIMIT 1
Theme Load (6.5ms) SELECT "themes".* FROM "themes" ORDER BY "themes"."id" ASC LIMIT 1
User Load (1.6ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1
UserOption Load (7.4ms) SELECT "user_options".* FROM "user_options" ORDER BY "user_options"."user_id" ASC LIMIT 1
SearchLog Load (2.7ms) SELECT "search_logs".* FROM "search_logs" ORDER BY "search_logs"."id" ASC LIMIT 1
ThemeSetting Load (2.0ms) SELECT "theme_settings".* FROM "theme_settings" ORDER BY "theme_settings"."id" ASC LIMIT 1
CategoryTagStat Load (1.5ms) SELECT "category_tag_stats".* FROM "category_tag_stats" ORDER BY "category_tag_stats"."id" ASC LIMIT 1
WebCrawlerRequest Load (2.0ms) SELECT "web_crawler_requests".* FROM "web_crawler_requests" ORDER BY "web_crawler_requests"."id" ASC LIMIT 1
TagGroupPermission Load (2.4ms) SELECT "tag_group_permissions".* FROM "tag_group_permissions" ORDER BY "tag_group_permissions"."id" ASC LIMIT 1
SharedDraft Load (2.9ms) SELECT "shared_drafts".* FROM "shared_drafts" ORDER BY "shared_drafts"."id" ASC LIMIT 1
PushSubscription Load (5.1ms) SELECT "push_subscriptions".* FROM "push_subscriptions" ORDER BY "push_subscriptions"."id" ASC LIMIT 1
UserSecondFactor Load (2.5ms) SELECT "user_second_factors".* FROM "user_second_factors" ORDER BY "user_second_factors"."id" ASC LIMIT 1
PostReplyKey Load (1.4ms) SELECT "post_reply_keys".* FROM "post_reply_keys" ORDER BY "post_reply_keys"."id" ASC LIMIT 1
SkippedEmailLog Load (2.1ms) SELECT "skipped_email_logs".* FROM "skipped_email_logs" ORDER BY "skipped_email_logs"."id" ASC LIMIT 1
Poll Load (1.9ms) SELECT "polls".* FROM "polls" ORDER BY "polls"."id" ASC LIMIT 1
PollOption Load (2.3ms) SELECT "poll_options".* FROM "poll_options" ORDER BY "poll_options"."id" ASC LIMIT 1
PollVote Load (3.8ms) SELECT "poll_votes".* FROM "poll_votes" LIMIT 1
UserUpload Load (2.8ms) SELECT "user_uploads".* FROM "user_uploads" ORDER BY "user_uploads"."id" ASC LIMIT 1
UserStat Load (2.5ms) SELECT "user_stats".* FROM "user_stats" ORDER BY "user_stats"."user_id" ASC LIMIT 1
UserAssociatedAccount Load (2.8ms) SELECT "user_associated_accounts".* FROM "user_associated_accounts" ORDER BY "user_associated_accounts"."id" ASC LIMIT 1
ThemeTranslationOverride Load (2.6ms) SELECT "theme_translation_overrides".* FROM "theme_translation_overrides" ORDER BY "theme_translation_overrides"."id" ASC LIMIT 1
OptimizedImage Load (0.6ms) SELECT "optimized_images".* FROM "optimized_images" ORDER BY "optimized_images"."id" ASC LIMIT 1
Reviewable Load (0.7ms) SELECT "reviewables".* FROM "reviewables" ORDER BY "reviewables"."id" ASC LIMIT 1
ReviewableHistory Load (2.8ms) SELECT "reviewable_histories".* FROM "reviewable_histories" ORDER BY "reviewable_histories"."id" ASC LIMIT 1
GroupRequest Load (5.5ms) SELECT "group_requests".* FROM "group_requests" ORDER BY "group_requests"."id" ASC LIMIT 1
IgnoredUser Load (3.2ms) SELECT "ignored_users".* FROM "ignored_users" ORDER BY "ignored_users"."id" ASC LIMIT 1
ReviewableClaimedTopic Load (2.0ms) SELECT "reviewable_claimed_topics".* FROM "reviewable_claimed_topics" ORDER BY "reviewable_claimed_topics"."id" ASC LIMIT 1
AnonymousUser Load (5.0ms) SELECT "anonymous_users".* FROM "anonymous_users" ORDER BY "anonymous_users"."id" ASC LIMIT 1
TopicGroup Load (3.8ms) SELECT "topic_groups".* FROM "topic_groups" ORDER BY "topic_groups"."id" ASC LIMIT 1
UserSecurityKey Load (3.6ms) SELECT "user_security_keys".* FROM "user_security_keys" ORDER BY "user_security_keys"."id" ASC LIMIT 1
ReviewableScore Load (4.4ms) SELECT "reviewable_scores".* FROM "reviewable_scores" ORDER BY "reviewable_scores"."id" ASC LIMIT 1
BackupDraftTopic Load (2.5ms) SELECT "backup_draft_topics".* FROM "backup_draft_topics" ORDER BY "backup_draft_topics"."id" ASC LIMIT 1
BackupDraftPost Load (2.0ms) SELECT "backup_draft_posts".* FROM "backup_draft_posts" ORDER BY "backup_draft_posts"."id" ASC LIMIT 1
Bookmark Load (2.0ms) SELECT "bookmarks".* FROM "bookmarks" ORDER BY "bookmarks"."id" ASC LIMIT 1
ThemeModifierSet Load (1.8ms) SELECT "theme_modifier_sets".* FROM "theme_modifier_sets" ORDER BY "theme_modifier_sets"."id" ASC LIMIT 1
(0.2ms) BEGIN
MiniScheduler::Stat Create (4.0ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ProcessBadgeBacklog', 'charles-t440', 6570, 928008, '2020-03-22 14:55:53.411872') RETURNING "id"
(2.1ms) COMMIT
(0.1ms) BEGIN
MiniScheduler::Stat Update (2.2ms) UPDATE "scheduler_stats" SET "duration_ms" = 119, "live_slots_finish" = 1020872, "success" = TRUE WHERE "scheduler_stats"."id" = 480
(2.2ms) COMMIT
(0.2ms) BEGIN
MiniScheduler::Stat Create (0.5ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::Heartbeat', 'charles-t440', 6570, 1031010, '2020-03-22 14:55:54.410219') RETURNING "id"
(7.8ms) COMMIT
(4.6ms) BEGIN
MiniScheduler::Stat Update (6.3ms) UPDATE "scheduler_stats" SET "duration_ms" = 22, "live_slots_finish" = 1033448, "success" = TRUE WHERE "scheduler_stats"."id" = 481
(7.4ms) COMMIT
I, [2020-03-22T07:55:55.185365 #6495] INFO -- : master process ready
(0.2ms) BEGIN
MiniScheduler::Stat Create (15.2ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::BookmarkReminderNotifications', 'charles-t440', 6570, 1038407, '2020-03-22 14:55:55.412536') RETURNING "id"
(18.7ms) COMMIT
(9.9ms) BEGIN
MiniScheduler::Stat Update (10.7ms) UPDATE "scheduler_stats" SET "duration_ms" = 48, "live_slots_finish" = 1047019, "success" = TRUE WHERE "scheduler_stats"."id" = 482
(3.5ms) COMMIT
(4.4ms) BEGIN
MiniScheduler::Stat Create (12.1ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::MigrateUploadScheme', 'charles-t440', 6570, 1058805, '2020-03-22 14:55:56.420973') RETURNING "id"
(7.5ms) COMMIT
(1.5ms) BEGIN
MiniScheduler::Stat Update (8.5ms) UPDATE "scheduler_stats" SET "duration_ms" = 41, "live_slots_finish" = 1065191, "success" = TRUE WHERE "scheduler_stats"."id" = 483
(3.4ms) COMMIT
(0.2ms) BEGIN
MiniScheduler::Stat Create (3.9ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PollMailbox', 'charles-t440', 6570, 1077379, '2020-03-22 14:55:57.428275') RETURNING "id"
(19.3ms) COMMIT
(0.4ms) BEGIN
MiniScheduler::Stat Update (4.4ms) UPDATE "scheduler_stats" SET "duration_ms" = 37, "live_slots_finish" = 1079610, "success" = TRUE WHERE "scheduler_stats"."id" = 484
(6.6ms) COMMIT
(0.2ms) BEGIN
MiniScheduler::Stat Create (3.8ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::EnqueueOnceoffs', 'charles-t440', 6570, 1086984, '2020-03-22 14:55:58.440758') RETURNING "id"
(7.7ms) COMMIT
(4.0ms) SELECT "onceoff_logs"."job_name" FROM "onceoff_logs"
(0.2ms) BEGIN
MiniScheduler::Stat Update (4.1ms) UPDATE "scheduler_stats" SET "duration_ms" = 307, "live_slots_finish" = 1091101, "success" = TRUE WHERE "scheduler_stats"."id" = 485
(10.5ms) COMMIT
(4.2ms) BEGIN
MiniScheduler::Stat Create (12.0ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::DashboardStats', 'charles-t440', 6570, 1095719, '2020-03-22 14:55:59.450671') RETURNING "id"
(19.3ms) COMMIT
(21.5ms) BEGIN
MiniScheduler::Stat Update (8.0ms) UPDATE "scheduler_stats" SET "duration_ms" = 86, "live_slots_finish" = 1099821, "success" = TRUE WHERE "scheduler_stats"."id" = 486
(7.7ms) COMMIT
(5.7ms) BEGIN
MiniScheduler::Stat Create (5.9ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PeriodicalUpdates', 'charles-t440', 6570, 1107193, '2020-03-22 14:56:00.449810') RETURNING "id"
Upload Load (1.9ms) SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" = -5 LIMIT 1
Upload Load (5.3ms) SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" = -6 LIMIT 1
(120.1ms) COMMIT
CategoryFeaturedTopic Load (4.8ms) SELECT "category_featured_topics"."topic_id", "category_featured_topics"."category_id" FROM "category_featured_topics" ORDER BY "category_featured_topics"."rank" ASC
Category Load (25.3ms) SELECT "categories"."id", "categories"."topic_id", "categories"."num_featured_topics" FROM "categories" WHERE (id >= 0) ORDER BY id ASC LIMIT 100
OptimizedImage Load (1.2ms) SELECT "optimized_images".* FROM "optimized_images" WHERE "optimized_images"."upload_id" = -6 AND "optimized_images"."height" = 32 AND "optimized_images"."width" = 32 LIMIT 1
(0.6ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 1 LIMIT 1
(7.0ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (1) AND (
categories.topic_id <> topics.id OR categories.id = 1
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" IS NOT NULL AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 1) ORDER BY topics.bumped_at DESC, pinned_at DESC
(22.5ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (1) AND (
categories.topic_id <> topics.id OR categories.id = 1
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" IS NOT NULL AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NULL OR topics.category_id <> 1) ORDER BY topics.bumped_at DESC LIMIT 3
I, [2020-03-22T07:56:00.786607 #6587] INFO -- : worker=0 ready
(31.8ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 1 LIMIT 1
(12.3ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
UserAuthToken Load (2.0ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=' OR
prev_auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=') AND rotated_at > '2020-01-22 14:56:00.821324') LIMIT 1
(17.7ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (1) AND (
categories.topic_id <> topics.id OR categories.id = 1
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND NOT (("topics"."id" IN (7, 11) OR "topics"."id" IS NULL)) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 1) ORDER BY topics.bumped_at DESC, pinned_at DESC
(15.4ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (1) AND (
categories.topic_id <> topics.id OR categories.id = 1
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND NOT (("topics"."id" IN (7, 11) OR "topics"."id" IS NULL)) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NULL OR topics.category_id <> 1) ORDER BY topics.bumped_at DESC LIMIT 3
User Load (14.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(3.2ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 2 LIMIT 1
(13.3ms) SELECT "groups"."id" FROM "groups"
(23.1ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (2) AND (
categories.topic_id <> topics.id OR categories.id = 2
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 1 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 2) ORDER BY topics.bumped_at DESC, pinned_at DESC
Delivering backlog [#<struct MessageBus::Message global_id=-1, message_id=-1, channel="/__status", data={"/new"=>1, "/latest"=>2, "/unread/1"=>8, "/delete"=>0, "/recover"=>0, "/global/asset-version"=>4, "/site/banner"=>0, "/file-change"=>0, "/logout"=>0, "/site/read-only"=>0, "/reviewable_counts"=>0, "/categories"=>3, "/client_settings"=>7, "/refresh_client"=>0, "/notification-alert/1"=>1, "/new_user_narrative/tutorial_search"=>0}>] to client fb27cc895def4331917e474eac665d8b for user 1
(8.1ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (2) AND (
categories.topic_id <> topics.id OR categories.id = 2
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 1 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NULL OR topics.category_id <> 2) ORDER BY topics.bumped_at DESC LIMIT 3
(3.0ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 2 LIMIT 1
(13.8ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(6.3ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (2) AND (
categories.topic_id <> topics.id OR categories.id = 2
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 1 AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 2) ORDER BY topics.bumped_at DESC, pinned_at DESC
(8.7ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (2) AND (
categories.topic_id <> topics.id OR categories.id = 2
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 1 AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NULL OR topics.category_id <> 2) ORDER BY topics.bumped_at DESC LIMIT 3
(0.5ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 3 LIMIT 1
(8.6ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 2 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 3) ORDER BY topics.bumped_at DESC, pinned_at DESC
(21.9ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 2 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NULL OR topics.category_id <> 3) ORDER BY topics.bumped_at DESC LIMIT 3
UserAuthToken Load (5.1ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=' OR
prev_auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=') AND rotated_at > '2020-01-22 14:56:01.039280') LIMIT 1
(0.7ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 3 LIMIT 1
User Load (13.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(8.1ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(18.8ms) SELECT "groups"."id" FROM "groups"
(25.3ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" NOT IN (2, 9, 6, 5) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 3) ORDER BY topics.bumped_at DESC, pinned_at DESC
(5.6ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" NOT IN (2, 9, 6, 5) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NULL OR topics.category_id <> 3) ORDER BY topics.bumped_at DESC LIMIT 3
UserVisit Load (2.1ms) SELECT "user_visits".* FROM "user_visits" WHERE "user_visits"."user_id" = 1 AND "user_visits"."visited_at" = '2020-03-22' LIMIT 1
User Update (7.8ms) UPDATE "users" SET "previous_visit_at" = '2020-03-22 05:44:14.891580' WHERE "users"."id" = 1
(27.0ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 4 LIMIT 1
(12.4ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (4) AND (
categories.topic_id <> topics.id OR categories.id = 4
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 3 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 4) ORDER BY topics.bumped_at DESC, pinned_at DESC
(14.0ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = -1) WHERE (categories.id in (4) AND (
categories.topic_id <> topics.id OR categories.id = 4
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 3 AND (topics.deleted_at IS NULL) AND (topics.pinned_at IS NULL OR topics.category_id <> 4) ORDER BY topics.bumped_at DESC LIMIT 3
(3.1ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 4 LIMIT 1
I, [2020-03-22T07:56:01.230328 #6605] INFO -- : worker=1 ready
(8.6ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(27.6ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (4) AND (
categories.topic_id <> topics.id OR categories.id = 4
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" NOT IN (3, 8) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NOT NULL AND topics.category_id = 4) ORDER BY topics.bumped_at DESC, pinned_at DESC
(3.3ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (4) AND (
categories.topic_id <> topics.id OR categories.id = 4
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" NOT IN (3, 8) AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND (topics.pinned_at IS NULL OR topics.category_id <> 4) ORDER BY topics.bumped_at DESC LIMIT 3
TopicTimer Load (4.6ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND (topic_timers.execute_at < '2020-03-22 14:56:01.329310') ORDER BY "topic_timers"."id" ASC LIMIT 1000
UserAvatar Load (0.9ms) SELECT "user_avatars".* FROM "user_avatars" WHERE (last_gravatar_download_attempt IS NULL) ORDER BY "user_avatars"."id" ASC LIMIT 1
User Update (182.8ms) UPDATE "users" SET "last_seen_at" = '2020-03-22 14:56:01.092831' WHERE "users"."id" = 1
(6.1ms) SELECT "posts"."id" FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND (baked_version IS NULL OR baked_version < 2) ORDER BY id desc LIMIT 80
UserProfile Load (4.7ms) SELECT "user_profiles".* FROM "user_profiles" WHERE (bio_cooked_version IS NULL OR bio_cooked_version < 1) LIMIT 250
Topic Load (6.9ms) SELECT "topics"."created_at" FROM "topics" WHERE ("topics"."deleted_at" IS NULL) ORDER BY created_at desc LIMIT 1 OFFSET 500
(2.3ms) SELECT "category_custom_fields"."category_id" FROM "category_custom_fields" WHERE "category_custom_fields"."name" = 'num_auto_bump_daily' AND (NULLIF(value, '')::int > 0)
(5.8ms) BEGIN
MiniScheduler::Stat Update (7.2ms) UPDATE "scheduler_stats" SET "duration_ms" = 933, "live_slots_finish" = 912438, "success" = TRUE WHERE "scheduler_stats"."id" = 487
(13.7ms) COMMIT
(0.1ms) BEGIN
MiniScheduler::Stat Create (3.4ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::EnqueueDigestEmails', 'charles-t440', 6570, 928146, '2020-03-22 14:56:01.458660') RETURNING "id"
(2.0ms) COMMIT
(2.2ms) SELECT "users"."id" FROM "users" INNER JOIN "user_options" ON "user_options"."user_id" = "users"."id" INNER JOIN "user_stats" ON "user_stats"."user_id" = "users"."id" WHERE (users.id > 0) AND (NOT EXISTS(
SELECT 1
FROM anonymous_users a
WHERE a.user_id = users.id
)) AND (suspended_till IS NULL OR suspended_till <= '2020-03-22 14:56:01.473610') AND "users"."active" = TRUE AND "users"."staged" = FALSE AND (user_options.email_digests) AND (user_stats.bounce_score < 4) AND (COALESCE(last_emailed_at, '2010-01-01') <= CURRENT_TIMESTAMP - ('1 MINUTE'::INTERVAL * user_options.digest_after_minutes)) AND (COALESCE(last_seen_at, '2010-01-01') <= CURRENT_TIMESTAMP - ('1 MINUTE'::INTERVAL * user_options.digest_after_minutes)) AND (COALESCE(last_seen_at, '2010-01-01') >= CURRENT_TIMESTAMP - ('1 DAY'::INTERVAL * 365))
(0.2ms) BEGIN
MiniScheduler::Stat Update (4.3ms) UPDATE "scheduler_stats" SET "duration_ms" = 23, "live_slots_finish" = 936708, "success" = TRUE WHERE "scheduler_stats"."id" = 488
(3.6ms) COMMIT
I, [2020-03-22T07:56:01.877983 #6615] INFO -- : worker=2 ready
(0.3ms) BEGIN
MiniScheduler::Stat Create (3.3ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::UnsilenceUsers', 'charles-t440', 6570, 951267, '2020-03-22 14:56:02.464300') RETURNING "id"
(2.6ms) COMMIT
User Load (1.5ms) SELECT "users".* FROM "users" WHERE (silenced_till IS NOT NULL AND silenced_till < now()) ORDER BY "users"."id" ASC LIMIT 1000
(0.6ms) BEGIN
MiniScheduler::Stat Update (1.8ms) UPDATE "scheduler_stats" SET "duration_ms" = 18, "live_slots_finish" = 959682, "success" = TRUE WHERE "scheduler_stats"."id" = 489
(1.5ms) COMMIT
(0.4ms) BEGIN
MiniScheduler::Stat Create (6.0ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::DestroyOldDeletionStubs', 'charles-t440', 6570, 976273, '2020-03-22 14:56:03.470345') RETURNING "id"
(3.4ms) COMMIT
(1.3ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'zh_CN'
Post Load (2.9ms) SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND "posts"."deleted_at" IS NULL AND "posts"."user_deleted" = TRUE AND (NOT EXISTS (
SELECT 1 FROM topics t
WHERE t.deleted_at IS NOT NULL AND
t.id = posts.topic_id
)) AND (updated_at < '2020-03-21 14:56:03.494164') AND (NOT EXISTS (
SELECT 1
FROM post_actions pa
WHERE pa.post_id = posts.id
AND pa.deleted_at IS NULL
AND pa.deferred_at IS NULL
AND pa.post_action_type_id IN (3,4,8,7)
)) ORDER BY "posts"."id" ASC LIMIT 1000
(7.3ms) BEGIN
MiniScheduler::Stat Update (4.9ms) UPDATE "scheduler_stats" SET "duration_ms" = 34, "live_slots_finish" = 988648, "success" = TRUE WHERE "scheduler_stats"."id" = 490
(6.3ms) COMMIT
(0.7ms) BEGIN
MiniScheduler::Stat Create (3.0ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::AboutStats', 'charles-t440', 6570, 1005241, '2020-03-22 14:56:04.474224') RETURNING "id"
(8.5ms) COMMIT
(6.0ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message')
(2.8ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL)
(6.4ms) SELECT COUNT(*) FROM "users" WHERE (users.id > 0) AND (NOT EXISTS(
SELECT 1
FROM anonymous_users a
WHERE a.user_id = users.id
))
(2.3ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (created_at > '2020-03-15 14:56:04.533121')
(4.1ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (created_at > '2020-02-21 14:56:04.541001')
(2.3ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND (created_at > '2020-03-15 14:56:04.546494')
(6.5ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND (created_at > '2020-02-21 14:56:04.552768')
(1.7ms) SELECT COUNT(*) FROM "users" WHERE (created_at > '2020-03-15 14:56:04.563003')
(7.3ms) SELECT COUNT(*) FROM "users" WHERE (created_at > '2020-02-21 14:56:04.566396')
(6.3ms) SELECT COUNT(*) FROM "users" WHERE (last_seen_at > '2020-03-15 14:56:04.577625')
(4.1ms) SELECT COUNT(*) FROM "users" WHERE (last_seen_at > '2020-02-21 14:56:04.590461')
(1.8ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1
(2.8ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1 AND (created_at > '2020-03-15 14:56:04.603694')
(2.5ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1 AND (created_at > '2020-02-21 14:56:04.608781')
(0.8ms) BEGIN
MiniScheduler::Stat Update (4.0ms) UPDATE "scheduler_stats" SET "duration_ms" = 141, "live_slots_finish" = 1046926, "success" = TRUE WHERE "scheduler_stats"."id" = 491
(3.6ms) COMMIT
Started GET "/t/read-me-first-admin-quick-start-guide/9/2" for 127.0.0.1 at 2020-03-22 07:56:05 -0700
(2.7ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Processing by TopicsController#show as HTML
Parameters: {"slug"=>"read-me-first-admin-quick-start-guide", "topic_id"=>"9", "post_number"=>"2"}
UserAuthToken Load (1.7ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=' OR
prev_auth_token = 'sv2/m/uwnpy/pm6Blx7VQnMYakA=') AND rotated_at > '2020-01-22 14:56:05.465112') LIMIT 1
User Load (9.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(0.7ms) BEGIN
MiniScheduler::Stat Create (3.1ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PendingUsersReminder', 'charles-t440', 6570, 1062438, '2020-03-22 14:56:05.488309') RETURNING "id"
UserOption Load (3.4ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
(8.6ms) COMMIT
(0.1ms) BEGIN
MiniScheduler::Stat Update (1.7ms) UPDATE "scheduler_stats" SET "duration_ms" = 38, "live_slots_finish" = 1070780, "success" = TRUE WHERE "scheduler_stats"."id" = 492
(2.2ms) COMMIT
(1.1ms) SELECT "groups"."id", "groups"."name" FROM "groups" ORDER BY name ASC, "groups"."name" ASC
(2.2ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'zh_CN'
(6.6ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "topics" WHERE ("topics"."deleted_at" IS NULL) LIMIT 16) subquery_for_count
(4.4ms) SELECT "users"."id" FROM "users" INNER JOIN "user_auth_tokens" ON "user_auth_tokens"."user_id" = "users"."id" WHERE "users"."admin" = TRUE AND (users.id > 0) ORDER BY user_auth_tokens.created_at LIMIT 1
(3.1ms) SELECT DISTINCT "user_histories"."context" FROM "user_histories" WHERE "user_histories"."action" = 40 AND "user_histories"."context" = 'introduction' ORDER BY "user_histories"."context" ASC
Topic Load (10.2ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 7 ORDER BY "topics"."id" ASC LIMIT 1
Post Load (6.4ms) SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND "posts"."topic_id" = 7 AND "posts"."post_number" = 1 LIMIT 1
CACHE Topic Load (0.0ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 7 ORDER BY "topics"."id" ASC LIMIT 1
CACHE Post Load (0.0ms) SELECT "posts".* FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND "posts"."topic_id" = 7 AND "posts"."post_number" = 1 LIMIT 1
(3.0ms) SELECT "users"."username" FROM "users" WHERE (users.id > 0) AND "users"."admin" = TRUE
User Load (3.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
Theme Load (11.2ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
SiteSetting Exists? (5.8ms) SELECT 1 AS one FROM "site_settings" WHERE "site_settings"."name" = 'default_theme_id' LIMIT 1
(5.2ms) SELECT COUNT(*) FROM "users" WHERE (moderator or admin ) AND (users.id > 0) AND (username_lower not in ('admin','moderator','administrator','mod','sys','system','community','info','you','name','username','user','nickname','discourse','discourseorg','discourseforum','support','hp'))
(3.1ms) SELECT DISTINCT "user_histories"."context" FROM "user_histories" WHERE "user_histories"."action" = 40 AND "user_histories"."context" IN ('locale', 'forum-title', 'introduction', 'privacy', 'contact', 'corporate', 'colors', 'themes-further-reading', 'logos', 'icons', 'homepage', 'emoji', 'invites') ORDER BY "user_histories"."context" ASC
(7.0ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."topic_featured_link_allowed" = TRUE
(3.1ms) SELECT "themes"."id", "themes"."name" FROM "themes" WHERE (id = 2 OR user_selectable) ORDER BY "themes"."name" ASC
(1.3ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = TRUE
Category Load (9.8ms) SELECT categories.*, t.slug topic_slug FROM "categories" LEFT JOIN topics t on t.id = categories.topic_id WHERE (NOT categories.read_restricted OR categories.id IN (3,4)) ORDER BY "categories"."position" ASC
CategoryTag Load (2.9ms) SELECT "category_tags".* FROM "category_tags" WHERE "category_tags"."category_id" IN (1, 2, 3, 4)
CategoryTagGroup Load (9.7ms) SELECT "category_tag_groups".* FROM "category_tag_groups" WHERE "category_tag_groups"."category_id" IN (1, 2, 3, 4)
(8.3ms) SELECT "category_users"."category_id", "category_users"."notification_level" FROM "category_users" WHERE "category_users"."user_id" = 1
UserField Load (1.1ms) SELECT "user_fields".* FROM "user_fields" ORDER BY "user_fields"."position" ASC
(3.8ms) SELECT "child_themes"."child_theme_id" FROM "child_themes" WHERE "child_themes"."parent_theme_id" = 2
Theme Load (11.5ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2
ThemeField Load (4.4ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'after_header' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
ThemeField Load (3.7ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'footer' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
Topic Load (2.7ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."archetype" = 'banner' ORDER BY "topics"."id" ASC LIMIT 1
UserStat Load (1.2ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = 1 LIMIT 1
(2.4ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 1 AND "category_users"."notification_level" = 0
(8.5ms) SELECT "tag_users"."tag_id" FROM "tag_users" WHERE "tag_users"."user_id" = 1 AND "tag_users"."notification_level" = 0
UserProfile Load (13.8ms) SELECT "user_profiles".* FROM "user_profiles" WHERE "user_profiles"."user_id" = 1 LIMIT 1
PluginStoreRow Load (6.6ms) SELECT "plugin_store_rows".* FROM "plugin_store_rows" WHERE "plugin_store_rows"."plugin_name" = 'reviewables' AND "plugin_store_rows"."key" = 'priority_0' LIMIT 1
(7.7ms) SELECT COUNT(*) FROM "reviewables" WHERE "reviewables"."status" = 0
(3.3ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 1 AND "category_users"."notification_level" NOT IN (0, 1) ORDER BY
CASE
WHEN notification_level = 3 THEN 1
WHEN notification_level = 2 THEN 2
WHEN notification_level = 4 THEN 3
END
(0.2ms) BEGIN
(4.1ms) SELECT "groups"."id", "groups"."name" FROM "groups" INNER JOIN "group_users" ON "groups"."id" = "group_users"."group_id" WHERE "group_users"."user_id" = 1 AND (groups.id > 0) ORDER BY name ASC
MiniScheduler::Stat Create (0.7ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::CleanUpUploads', 'charles-t440', 6570, 1090346, '2020-03-22 14:56:06.497368') RETURNING "id"
(3.6ms) COMMIT
UserSecondFactor Exists? (3.6ms) SELECT 1 AS one FROM "user_second_factors" WHERE "user_second_factors"."user_id" = 1 AND "user_second_factors"."method" = 1 AND "user_second_factors"."enabled" = TRUE LIMIT 1
Upload Load (8.8ms) SELECT "uploads".* FROM "uploads" WHERE (uploads.id > 0) AND (retain_hours IS NULL OR created_at < current_timestamp - interval '1 hour' * retain_hours) AND (created_at < '2020-03-20 14:56:06.513294') AND "uploads"."url" = '' ORDER BY "uploads"."id" ASC LIMIT 1000
UserSecurityKey Exists? (9.3ms) SELECT 1 AS one FROM "user_security_keys" WHERE "user_security_keys"."user_id" = 1 AND "user_security_keys"."enabled" = TRUE AND "user_security_keys"."factor_type" = 0 AND "user_security_keys"."enabled" = TRUE LIMIT 1
(2.9ms) BEGIN
MiniScheduler::Stat Update (11.6ms) UPDATE "scheduler_stats" SET "duration_ms" = 34, "live_slots_finish" = 1098274, "success" = TRUE WHERE "scheduler_stats"."id" = 493
(2.9ms) SELECT "username" FROM "ignored_users" INNER JOIN "users" ON "users"."id" = "ignored_users"."ignored_user_id" WHERE "ignored_users"."user_id" = 1
(8.6ms) COMMIT
(10.9ms) SELECT "tag_users"."tag_id" FROM "tag_users" WHERE "tag_users"."user_id" = 1 AND "tag_users"."notification_level" = 0
(1.6ms) SELECT "tag_users"."tag_id" FROM "tag_users" WHERE "tag_users"."user_id" = 1 AND "tag_users"."notification_level" = 0
Topic Load (1.3ms) SELECT "topics".* FROM "topics" WHERE "topics"."id" = 9 ORDER BY "topics"."id" ASC LIMIT 1
Category Load (5.9ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" WHERE "categories"."id" = 3
Post Exists? (5.8ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
(4.8ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 1) ORDER BY "posts"."sort_order" DESC LIMIT 5
(2.8ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order >= 1) ORDER BY "posts"."sort_order" ASC LIMIT 20
(10.6ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 1) ORDER BY "posts"."sort_order" DESC LIMIT 19 OFFSET 0
(4.1ms) SELECT "posts"."id" FROM "posts" LEFT OUTER JOIN "users" ON "users"."id" = "posts"."user_id" LEFT OUTER JOIN "groups" ON "groups"."id" = "users"."primary_group_id" LEFT OUTER JOIN "users" "reply_to_users_posts" ON "reply_to_users_posts"."id" = "posts"."reply_to_user_id" LEFT OUTER JOIN "users" "deleted_bies_posts" ON "deleted_bies_posts"."id" = "posts"."deleted_by_id" LEFT OUTER JOIN "incoming_emails" ON "incoming_emails"."post_id" = "posts"."id" LEFT OUTER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE "posts"."id" = 12 AND "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
(3.9ms) SELECT "post_custom_fields"."post_id", "post_custom_fields"."name", "post_custom_fields"."value" FROM "post_custom_fields" WHERE "post_custom_fields"."post_id" = 12 AND "post_custom_fields"."name" IN ('notice_type', 'notice_args', 'action_code_who', 'requested_group_id', 'has_polls')
WatchedWord Exists? (7.3ms) SELECT 1 AS one FROM "watched_words" WHERE "watched_words"."action" = 3 LIMIT 1
(5.3ms) SELECT MAX("posts"."post_number") FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4))
Post Load (5.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" = 12 AND "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
User Load (6.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
IncomingEmail Load (5.0ms) SELECT "incoming_emails".* FROM "incoming_emails" WHERE "incoming_emails"."post_id" = 12
Topic Load (6.8ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 9
(10.7ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = TRUE
(7.7ms) BEGIN
TopicUser Load (10.0ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" = 9 AND "topic_users"."user_id" = 1 LIMIT 1
Topic Update All (11.8ms) UPDATE "topics" SET views = views + 1 WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 9
(8.1ms) COMMIT
TopicUser Update All (7.0ms) UPDATE "topic_users" SET "last_visited_at" = '2020-03-22 14:56:06.945613' WHERE "topic_users"."topic_id" = 9 AND "topic_users"."user_id" = 1
(14.7ms) SELECT "post_timings"."post_number" FROM "post_timings" WHERE "post_timings"."topic_id" = 9 AND "post_timings"."user_id" = 1 AND "post_timings"."post_number" = 1
PostAction Load (2.2ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_id" = 12 AND "post_actions"."user_id" = 1
(7.4ms) SELECT "posts"."id", EXTRACT(DAYS FROM CURRENT_TIMESTAMP - created_at)::INT AS days_ago FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY "posts"."sort_order" ASC
(9.1ms) SELECT "categories"."topic_id" FROM "categories"
Topic Load (6.9ms) SELECT "topics".* FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (tu.last_read_post_number < topics.highest_staff_post_number) AND (COALESCE(tu.notification_level, 1) >= 2) AND (topics.updated_at >= '2020-03-22 01:25:29.796959') AND (topics.id NOT IN (9)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.user_id = tu.user_id THEN 1 ELSE 2 END, CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
SQL (9.1ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (topics.created_at >= '2020-03-22 01:25:30.838675') AND (tu.last_read_post_number IS NULL) AND (COALESCE(tu.notification_level, 2) >= 2) AND (COALESCE(tu.notification_level,1) > 0) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND (category_users.last_seen_at IS NULL OR topics.created_at > category_users.last_seen_at) AND (topics.id NOT IN (9)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
(7.1ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(2.6ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:07.061506') ORDER BY RANDOM() LIMIT 3000
(4.6ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 3 LIMIT 1
(9.5ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 2 AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:07.091449') ORDER BY RANDOM() LIMIT 3000
SQL (14.5ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.id NOT IN (9,1,3,2)) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND "topics"."id" IN (11, 7, 6, 5, 4, 9) AND (topics.id NOT IN (9)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END LIMIT 5
TopicUser Load (7.8ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (6, 5, 4, 11, 7) AND "topic_users"."user_id" = 1
CategoryUser Load (9.6ms) SELECT "category_users".* FROM "category_users" WHERE "category_users"."category_id" IN (3, 1) AND "category_users"."user_id" = 1
User Load (3.2ms) SELECT "users"."id", "user_emails"."email", "users"."username", "users"."name", "users"."uploaded_avatar_id" FROM "users" INNER JOIN "user_emails" ON "user_emails"."user_id" = "users"."id" WHERE "users"."id" IN (-1, 1)
User Load (2.8ms) SELECT "users"."id", "users"."primary_group_id" FROM "users" WHERE "users"."id" IN (-1, 1) AND "users"."primary_group_id" IS NOT NULL
Group Load (8.0ms) SELECT "groups"."id", "groups"."name", "groups"."flair_url", "groups"."flair_bg_color", "groups"."flair_color" FROM "groups" WHERE 1=0
(3.6ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND "posts"."post_number" = 1 LIMIT 1
CACHE Post Exists? (0.0ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 9 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
TopicEmbed Exists? (9.1ms) SELECT 1 AS one FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) AND "topic_embeds"."topic_id" = 9 LIMIT 1
TopicTimer Load (9.3ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 9 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = TRUE LIMIT 1
TopicTimer Load (4.2ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 9 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = FALSE AND "topic_timers"."user_id" = 1 LIMIT 1
CACHE User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
Group Load (8.1ms) SELECT "groups".* FROM "groups" INNER JOIN "topic_allowed_groups" ON "groups"."id" = "topic_allowed_groups"."group_id" WHERE "topic_allowed_groups"."topic_id" = 9
Category Exists? (7.5ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 9 LIMIT 1
Group Exists? (4.9ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Group Exists? (0.0ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Category Exists? (0.0ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 9 LIMIT 1
User Load (8.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
CACHE User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
(5.3ms) SELECT "theme_modifier_sets"."serialize_topic_excerpts" FROM "theme_modifier_sets" WHERE "theme_modifier_sets"."theme_id" = 2 AND "theme_modifier_sets"."serialize_topic_excerpts" IS NOT NULL
Rendering topics/show.html.erb within layouts/application
(0.6ms) BEGIN
MiniScheduler::Stat Create (11.2ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::CreateMissingAvatars', 'charles-t440', 6570, 835300, '2020-03-22 14:56:07.571655') RETURNING "id"
(2.6ms) COMMIT
SQL (6.9ms) SELECT "user_avatars"."id" AS t0_r0, "user_avatars"."user_id" AS t0_r1, "user_avatars"."custom_upload_id" AS t0_r2, "user_avatars"."gravatar_upload_id" AS t0_r3, "user_avatars"."last_gravatar_download_attempt" AS t0_r4, "user_avatars"."created_at" AS t0_r5, "user_avatars"."updated_at" AS t0_r6, "users"."id" AS t1_r0, "users"."username" AS t1_r1, "users"."created_at" AS t1_r2, "users"."updated_at" AS t1_r3, "users"."name" AS t1_r4, "users"."seen_notification_id" AS t1_r5, "users"."last_posted_at" AS t1_r6, "users"."password_hash" AS t1_r7, "users"."salt" AS t1_r8, "users"."active" AS t1_r9, "users"."username_lower" AS t1_r10, "users"."last_seen_at" AS t1_r11, "users"."admin" AS t1_r12, "users"."last_emailed_at" AS t1_r13, "users"."trust_level" AS t1_r14, "users"."approved" AS t1_r15, "users"."approved_by_id" AS t1_r16, "users"."approved_at" AS t1_r17, "users"."previous_visit_at" AS t1_r18, "users"."suspended_at" AS t1_r19, "users"."suspended_till" AS t1_r20, "users"."date_of_birth" AS t1_r21, "users"."views" AS t1_r22, "users"."flag_level" AS t1_r23, "users"."ip_address" AS t1_r24, "users"."moderator" AS t1_r25, "users"."title" AS t1_r26, "users"."uploaded_avatar_id" AS t1_r27, "users"."locale" AS t1_r28, "users"."primary_group_id" AS t1_r29, "users"."registration_ip_address" AS t1_r30, "users"."staged" AS t1_r31, "users"."first_seen_at" AS t1_r32, "users"."silenced_till" AS t1_r33, "users"."group_locked_trust_level" AS t1_r34, "users"."manual_locked_trust_level" AS t1_r35, "users"."secure_identifier" AS t1_r36 FROM "user_avatars" INNER JOIN "users" ON "users"."id" = "user_avatars"."user_id" WHERE "user_avatars"."last_gravatar_download_attempt" IS NULL ORDER BY users.last_posted_at DESC LIMIT 5000
(4.0ms) BEGIN
MiniScheduler::Stat Update (11.0ms) UPDATE "scheduler_stats" SET "duration_ms" = 51, "live_slots_finish" = 846075, "success" = TRUE WHERE "scheduler_stats"."id" = 494
(7.3ms) COMMIT
Rendered topics/show.html.erb within layouts/application (Duration: 278.0ms | Allocations: 41454)
OptimizedImage Load (7.1ms) SELECT "optimized_images".* FROM "optimized_images" WHERE "optimized_images"."upload_id" = -6 AND "optimized_images"."height" = 180 AND "optimized_images"."width" = 180 LIMIT 1
(3.4ms) SELECT "themes"."color_scheme_id" FROM "themes" WHERE "themes"."id" = 2
Theme Load (13.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 ORDER BY "themes"."id" ASC LIMIT 1
Rendered layouts/_head.html.erb (Duration: 78.2ms | Allocations: 14565)
(2.7ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'zh_CN'
ThemeField Load (3.6ms) SELECT DISTINCT ON (X.theme_sort_column) * FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id JOIN (
SELECT * FROM (VALUES ('zh_CN',0),('en',1)) as Y (locale_code, locale_sort_column)
) as Y ON Y.locale_code = theme_fields.name WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" = 4 AND "theme_fields"."name" IN ('zh_CN', 'en') ORDER BY X.theme_sort_column, Y.locale_sort_column
ThemeField Load (1.9ms) SELECT "theme_fields".* FROM "theme_fields" WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" = 6 AND (compiler_version <> '622b2654cbf341ad5d66c74d38eb87dddd385e14')
JavascriptCache Load (6.6ms) SELECT "javascript_caches".* FROM "javascript_caches" WHERE "javascript_caches"."theme_id" = 2
ThemeField Load (7.4ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'head_tag' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2
CACHE Theme Load (0.2ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(5.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(10.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.2ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(6.8ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(3.2ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(7.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(3.9ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(2.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
(4.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1 [["id", 2], ["LIMIT", 1]]
ThemeField Load (14.6ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (0, 0) AND "theme_fields"."name" = 'scss' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
ThemeField Load (4.0ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'scss' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
(13.7ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
(1.2ms) SELECT "theme_fields"."updated_at" FROM "theme_fields" WHERE "theme_fields"."name" = 'yaml' AND "theme_fields"."type_id" = 5 AND "theme_fields"."theme_id" = 2
(11.0ms) SELECT "theme_settings"."updated_at" FROM "theme_settings" WHERE "theme_settings"."theme_id" = 2
ThemeField Load (9.7ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."type_id" = 2 ORDER BY theme_sort_column
(7.1ms) SELECT "sha1" FROM "theme_fields" INNER JOIN "uploads" ON "uploads"."id" = "theme_fields"."upload_id" WHERE 1=0
Rendered common/_discourse_stylesheet.html.erb (Duration: 491.0ms | Allocations: 109460)
(3.0ms) BEGIN
MiniScheduler::Stat Create (20.5ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PendingQueuedPostsReminder', 'charles-t440', 6570, 868179, '2020-03-22 14:56:08.581875') RETURNING "id"
(4.1ms) COMMIT
(7.5ms) SELECT "reviewables"."id" FROM "reviewables" WHERE "reviewables"."type" = 'ReviewableQueuedPost' AND "reviewables"."status" = 0 AND (created_at < '2020-03-21 14:56:08.629421')
(1.3ms) BEGIN
MiniScheduler::Stat Update (2.6ms) UPDATE "scheduler_stats" SET "duration_ms" = 62, "live_slots_finish" = 877972, "success" = TRUE WHERE "scheduler_stats"."id" = 495
(3.8ms) COMMIT
(1.7ms) SELECT "badges"."icon" FROM "badges"
(3.9ms) SELECT "groups"."flair_url" FROM "groups" WHERE (flair_url LIKE '%fa-%')
CACHE Theme Load (0.0ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2
ThemeField Load (2.6ms) SELECT "theme_fields".* FROM "theme_fields" WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" = 3 AND "theme_fields"."name" = 'yaml' LIMIT 1
ThemeField Load (8.0ms) SELECT "theme_fields".* FROM "theme_fields" INNER JOIN "uploads" ON "uploads"."id" = "theme_fields"."upload_id" WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."type_id" = 2
(2.9ms) SELECT "theme_modifier_sets"."svg_icons" FROM "theme_modifier_sets" WHERE "theme_modifier_sets"."theme_id" = 2 AND "theme_modifier_sets"."svg_icons" IS NOT NULL
(3.9ms) SELECT "theme_fields"."upload_id" FROM "theme_fields" WHERE "theme_fields"."type_id" = 2 AND "theme_fields"."name" = 'icons-sprite' AND "theme_fields"."theme_id" = 2
(3.1ms) SELECT "theme_fields"."upload_id" FROM "theme_fields" WHERE "theme_fields"."type_id" = 2 AND "theme_fields"."name" = 'icons-sprite' AND "theme_fields"."theme_id" = 2
Rendered application/_header.html.erb (Duration: 4.1ms | Allocations: 523)
ThemeField Load (13.8ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'header' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
ThemeField Load (19.0ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'body_tag' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
UserAuthToken Load (3.6ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE "user_auth_tokens"."id" = 1 LIMIT 1
(15.5ms) BEGIN
UserAuthTokenLog Create (3.9ms) INSERT INTO "user_auth_token_logs" ("action", "user_auth_token_id", "user_id", "client_ip", "user_agent", "auth_token", "created_at", "path") VALUES ('rotate', 1, 1, '127.0.0.1/32', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36', 'v43iomhQfdwPNBMhRuweik9LYe0=', '2020-03-22 14:56:09.099421', '/t/read-me-first-admin-quick-start-guide/9/2') RETURNING "id"
(6.4ms) COMMIT
Completed 200 OK in 3709ms (Views: 1413.9ms | ActiveRecord: 746.3ms | Allocations: 952890)
Theme Load (3.8ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 ORDER BY "themes"."id" ASC LIMIT 1000
(9.8ms) SELECT "theme_modifier_sets"."csp_extensions" FROM "theme_modifier_sets" WHERE "theme_modifier_sets"."theme_id" = 2 AND "theme_modifier_sets"."csp_extensions" IS NOT NULL
(3.2ms) BEGIN
MiniScheduler::Stat Create (6.9ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::DirectoryRefreshDaily', 'charles-t440', 6570, 895718, '2020-03-22 14:56:09.596502') RETURNING "id"
(12.7ms) COMMIT
(19.9ms) BEGIN
(2.9ms) COMMIT
(0.2ms) BEGIN
MiniScheduler::Stat Update (5.6ms) UPDATE "scheduler_stats" SET "duration_ms" = 110, "live_slots_finish" = 902088, "success" = TRUE WHERE "scheduler_stats"."id" = 496
(5.9ms) COMMIT
Started GET "/stylesheets/desktop_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:10 -0700
Started GET "/stylesheets/admin_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:10 -0700
(2.2ms) BEGIN
MiniScheduler::Stat Create (2.3ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::TopRefreshToday', 'charles-t440', 6570, 910703, '2020-03-22 14:56:10.599129') RETURNING "id"
(1.9ms) COMMIT
(1.3ms) BEGIN
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"desktop_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
UserAuthToken Load (2.0ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:10.646622') LIMIT 1
User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
UserAuthToken Update All (6.2ms) UPDATE "user_auth_tokens" SET "auth_token_seen" = TRUE, "seen_at" = '2020-03-22 14:56:10.655878' WHERE "user_auth_tokens"."id" = 1 AND "user_auth_tokens"."auth_token" = 'v43iomhQfdwPNBMhRuweik9LYe0='
(0.9ms) BEGIN
(4.4ms) COMMIT
UserAuthTokenLog Create (14.6ms) INSERT INTO "user_auth_token_logs" ("action", "user_auth_token_id", "user_id", "client_ip", "user_agent", "auth_token", "created_at", "path") VALUES ('seen token', 1, 1, '127.0.0.1/32', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36', 'v43iomhQfdwPNBMhRuweik9LYe0=', '2020-03-22 14:56:10.664120', '/stylesheets/desktop_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css') RETURNING "id"
(5.1ms) COMMIT
User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"admin_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
(0.2ms) BEGIN
UserOption Load (0.6ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
MiniScheduler::Stat Update (0.5ms) UPDATE "scheduler_stats" SET "duration_ms" = 85, "live_slots_finish" = 923953, "success" = TRUE WHERE "scheduler_stats"."id" = 497
Theme Load (11.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
(8.2ms) COMMIT
(9.1ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'desktop' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
UserAuthToken Load (3.7ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:10.730191') LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 110ms (Views: 9.7ms | ActiveRecord: 50.3ms | Allocations: 26505)
User Load (13.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Started GET "/stylesheets/discourse-details_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:10 -0700
UserOption Load (0.6ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (0.7ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
Theme Load (2.6ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
(1.5ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
Processing by StylesheetsController#show as CSS
(3.5ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'admin' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Parameters: {"__ws"=>"localhost", "name"=>"discourse-details_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 3)
Completed 304 Not Modified in 490ms (Views: 8.7ms | ActiveRecord: 26.0ms | Allocations: 106569)
UserAuthToken Load (1.5ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:11.194332') LIMIT 1
User Load (10.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Started GET "/stylesheets/discourse-local-dates_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:11 -0700
UserOption Load (13.6ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (5.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
(6.2ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'discourse-details' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 88ms (Views: 2.9ms | ActiveRecord: 37.1ms | Allocations: 13974)
Started GET "/stylesheets/discourse-presence_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:11 -0700
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"discourse-local-dates_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
UserAuthToken Load (2.9ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:11.447852') LIMIT 1
User Load (17.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserOption Load (3.4ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (15.9ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
Theme Load (5.3ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"discourse-presence_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
(3.1ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
UserAuthToken Load (9.1ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:11.521083') LIMIT 1
User Load (8.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(0.4ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'discourse-local-dates' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
UserOption Load (8.4ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Completed 304 Not Modified in 129ms (Views: 13.4ms | ActiveRecord: 49.0ms | Allocations: 25585)
Theme Load (16.2ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
(1.8ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'discourse-presence' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
Started GET "/stylesheets/lazy-yt_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:11 -0700
Rendered text template (Duration: 0.2ms | Allocations: 1)
Completed 304 Not Modified in 113ms (Views: 23.0ms | ActiveRecord: 44.2ms | Allocations: 18896)
Started GET "/stylesheets/poll_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:11 -0700
(9.0ms) BEGIN
MiniScheduler::Stat Create (14.9ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::PendingReviewablesReminder', 'charles-t440', 6570, 940106, '2020-03-22 14:56:11.625823') RETURNING "id"
(9.2ms) COMMIT
PluginStoreRow Load (14.7ms) SELECT "plugin_store_rows".* FROM "plugin_store_rows" WHERE "plugin_store_rows"."plugin_name" = 'reviewables' AND "plugin_store_rows"."key" = 'priority_0' LIMIT 1
(12.1ms) SELECT "reviewables"."id" FROM "reviewables" WHERE "reviewables"."status" = 0 AND (score >= 0.0) AND (latest_score < '2020-03-20 14:56:11.724886') ORDER BY id DESC
(0.7ms) BEGIN
MiniScheduler::Stat Update (11.8ms) UPDATE "scheduler_stats" SET "duration_ms" = 126, "live_slots_finish" = 948257, "success" = TRUE WHERE "scheduler_stats"."id" = 498
(11.6ms) COMMIT
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"lazy-yt_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
Processing by StylesheetsController#show as CSS
UserAuthToken Load (10.0ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:11.863450') LIMIT 1
Parameters: {"__ws"=>"localhost", "name"=>"poll_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
User Load (1.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserAuthToken Load (11.0ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:11.885382') LIMIT 1
User Load (6.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserOption Load (6.9ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
UserOption Load (5.9ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (13.9ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
Theme Load (12.6ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
Theme Load (4.4ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
(0.8ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'poll' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
(2.0ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 66ms (Views: 3.0ms | ActiveRecord: 36.8ms | Allocations: 14868)
Started GET "/stylesheets/poll_desktop_388a7081aeb1e73e505ceed5ddf2f09a61315fa4.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:11 -0700
(10.3ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'lazy-yt' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 157ms (Views: 10.4ms | ActiveRecord: 49.1ms | Allocations: 26138)
Started GET "/stylesheets/desktop_theme_2_791bd17e05b13ee1ea1c66389915d283107a32f8.css?__ws=localhost" for 127.0.0.1 at 2020-03-22 07:56:12 -0700
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"poll_desktop_388a7081aeb1e73e505ceed5ddf2f09a61315fa4"}
UserAuthToken Load (11.2ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:12.205060') LIMIT 1
Processing by StylesheetsController#show as CSS
Parameters: {"__ws"=>"localhost", "name"=>"desktop_theme_2_791bd17e05b13ee1ea1c66389915d283107a32f8"}
UserAuthToken Load (14.3ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:12.238856') LIMIT 1
User Load (2.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserOption Load (5.1ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (2.4ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
Theme Load (9.4ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 LIMIT 1
User Load (134.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserOption Load (6.1ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
Theme Load (5.5ms) SELECT "themes".* FROM "themes" WHERE "themes"."color_scheme_id" IS NULL LIMIT 1
ThemeField Load (1.5ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (0, 0) AND "theme_fields"."name" = 'scss' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
(8.4ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'poll_desktop' AND "stylesheet_cache"."digest" = '388a7081aeb1e73e505ceed5ddf2f09a61315fa4' LIMIT 1
Rendering text template
ThemeField Load (6.2ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."target_id" IN (1, 0) AND "theme_fields"."name" = 'scss' ORDER BY theme_sort_column, "theme_fields"."target_id" ASC
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 219ms (Views: 3.4ms | ActiveRecord: 165.1ms | Allocations: 15791)
(1.0ms) SELECT "categories"."updated_at" FROM "categories" WHERE (uploaded_background_id IS NOT NULL)
(1.1ms) SELECT "theme_fields"."updated_at" FROM "theme_fields" WHERE "theme_fields"."name" = 'yaml' AND "theme_fields"."type_id" = 5 AND "theme_fields"."theme_id" = 2
(20.7ms) SELECT "theme_settings"."updated_at" FROM "theme_settings" WHERE "theme_settings"."theme_id" = 2
ThemeField Load (11.4ms) SELECT "theme_fields".* FROM "theme_fields" JOIN (
SELECT 2 AS theme_id, 0 AS theme_sort_column
) as X ON X.theme_id = theme_fields.theme_id WHERE "theme_fields"."theme_id" = 2 AND "theme_fields"."type_id" = 2 ORDER BY theme_sort_column
(6.1ms) SELECT "sha1" FROM "theme_fields" INNER JOIN "uploads" ON "uploads"."id" = "theme_fields"."upload_id" WHERE 1=0
(9.0ms) SELECT "stylesheet_cache"."created_at" FROM "stylesheet_cache" WHERE "stylesheet_cache"."target" = 'desktop_theme_2' AND "stylesheet_cache"."digest" = '791bd17e05b13ee1ea1c66389915d283107a32f8' LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 304 Not Modified in 329ms (Views: 5.1ms | ActiveRecord: 90.4ms | Allocations: 44785)
(8.0ms) BEGIN
MiniScheduler::Stat Create (17.1ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ScheduleBackup', 'charles-t440', 6570, 959401, '2020-03-22 14:56:12.642561') RETURNING "id"
(2.6ms) COMMIT
(0.3ms) BEGIN
MiniScheduler::Stat Update (14.7ms) UPDATE "scheduler_stats" SET "duration_ms" = 146, "live_slots_finish" = 971096, "success" = TRUE WHERE "scheduler_stats"."id" = 499
(24.5ms) COMMIT
(0.4ms) BEGIN
MiniScheduler::Stat Create (16.3ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::EnqueueSuspectUsers', 'charles-t440', 6570, 980786, '2020-03-22 14:56:13.641850') RETURNING "id"
(16.3ms) COMMIT
User Load (9.4ms) SELECT DISTINCT "users".* FROM "users" INNER JOIN "user_profiles" ON "user_profiles"."user_id" = "users"."id" INNER JOIN "user_stats" ON "user_stats"."user_id" = "users"."id" LEFT OUTER JOIN reviewables r ON r.target_id = users.id AND r.target_type = 'User' LEFT OUTER JOIN user_custom_fields ucf ON users.id = ucf.user_id WHERE "users"."active" = TRUE AND (users.id > 0) AND "users"."approved" = FALSE AND (users.created_at <= '2020-03-21 14:56:13.712882' AND users.created_at >= '2019-09-22 14:56:13.713009') AND (LENGTH(COALESCE(user_profiles.bio_raw, user_profiles.website, '')) > 0) AND (user_stats.posts_read_count <= 1 AND user_stats.topics_entered <= 1) AND (r.id IS NULL) GROUP BY users.id, ucf.id HAVING (ucf.id IS NULL OR NOT bool_or(ucf.name = 'import_id')) LIMIT 10
(0.4ms) BEGIN
MiniScheduler::Stat Update (15.2ms) UPDATE "scheduler_stats" SET "duration_ms" = 97, "live_slots_finish" = 988606, "success" = TRUE WHERE "scheduler_stats"."id" = 500
(7.0ms) COMMIT
(0.1ms) BEGIN
MiniScheduler::Stat Create (3.7ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ReindexSearch', 'charles-t440', 6570, 1002318, '2020-03-22 14:56:14.652181') RETURNING "id"
(4.4ms) COMMIT
(5.9ms) SELECT "topics"."id" FROM "topics" INNER JOIN "topic_search_data" ON "topic_search_data"."topic_id" = "topics"."id" WHERE ("topics"."deleted_at" IS NULL) AND (topic_search_data.locale != 'zh_CN'
OR topic_search_data.version != 3) ORDER BY topics.id desc LIMIT 10000
(4.6ms) SELECT "categories"."id" FROM "categories" INNER JOIN "category_search_data" ON "category_search_data"."category_id" = "categories"."id" WHERE (category_search_data.locale != 'zh_CN'
OR category_search_data.version != 3) ORDER BY categories.id asc LIMIT 500
(10.1ms) SELECT "users"."id" FROM "users" INNER JOIN "user_search_data" ON "user_search_data"."user_id" = "users"."id" WHERE (user_search_data.locale != 'zh_CN'
OR user_search_data.version != 3) ORDER BY users.id asc LIMIT 10000
(4.9ms) SELECT "tags"."id" FROM "tags" INNER JOIN "tag_search_data" ON "tag_search_data"."tag_id" = "tags"."id" WHERE (tag_search_data.locale != 'zh_CN'
OR tag_search_data.version != 3) ORDER BY tags.id asc LIMIT 10000
PostSearchData Destroy (8.7ms) DELETE FROM "post_search_data" WHERE "post_search_data"."post_id" IN (SELECT "post_search_data"."post_id" FROM "post_search_data" LEFT JOIN posts p ON p.id = post_search_data.post_id WHERE (p.raw = ''))
(0.2ms) BEGIN
MiniScheduler::Stat Update (4.1ms) UPDATE "scheduler_stats" SET "duration_ms" = 160, "live_slots_finish" = 1026410, "success" = TRUE WHERE "scheduler_stats"."id" = 501
(11.8ms) COMMIT
Started GET "/about/live_post_counts.json" for 127.0.0.1 at 2020-03-22 07:56:14 -0700
Processing by AboutController#live_post_counts as JSON
UserAuthToken Load (3.3ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:14.998448') LIMIT 1
User Load (3.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(1.4ms) SELECT "categories"."topic_id" FROM "categories"
(11.1ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND "topics"."visible" = TRUE AND (topics.category_id IS NULL OR topics.category_id IN (SELECT id FROM categories WHERE NOT read_restricted)) AND "topics"."id" NOT IN (1, 3, 2)
(7.2ms) SELECT SUM("topics"."posts_count") FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND "topics"."visible" = TRUE AND (topics.category_id IS NULL OR topics.category_id IN (SELECT id FROM categories WHERE NOT read_restricted)) AND "topics"."id" NOT IN (1, 3, 2)
Completed 200 OK in 227ms (Views: 0.4ms | ActiveRecord: 26.5ms | Allocations: 94135)
(0.2ms) BEGIN
MiniScheduler::Stat Create (2.5ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ActivationReminderEmails', 'charles-t440', 6570, 1041712, '2020-03-22 14:56:15.656692') RETURNING "id"
(5.1ms) COMMIT
User Load (3.3ms) SELECT "users".* FROM "users" LEFT JOIN user_custom_fields ON users.id = user_id AND user_custom_fields.name = 'activation_reminder' WHERE "users"."active" = FALSE AND "users"."staged" = FALSE AND "user_custom_fields"."value" IS NULL AND (users.created_at BETWEEN '2020-03-19 14:56:15.673649' AND '2020-03-20 14:56:15.673731') ORDER BY "users"."id" ASC LIMIT 1000
(0.2ms) BEGIN
MiniScheduler::Stat Update (0.5ms) UPDATE "scheduler_stats" SET "duration_ms" = 25, "live_slots_finish" = 1050040, "success" = TRUE WHERE "scheduler_stats"."id" = 502
(6.0ms) COMMIT
Started GET "/manifest.webmanifest" for 127.0.0.1 at 2020-03-22 07:56:16 -0700
Processing by MetadataController#manifest as */*
UserAuthToken Load (2.2ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:16.355034') LIMIT 1
User Load (3.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserOption Load (3.7ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
(5.6ms) SELECT "themes"."color_scheme_id" FROM "themes" WHERE "themes"."id" = 2
Theme Load (3.9ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 ORDER BY "themes"."id" ASC LIMIT 1
(5.0ms) SELECT "translation_overrides"."translation_key", "translation_overrides"."value", "translation_overrides"."compiled_js" FROM "translation_overrides" WHERE "translation_overrides"."locale" = 'zh_CN'
(2.8ms) SELECT "themes"."color_scheme_id" FROM "themes" WHERE "themes"."id" = 2
CACHE Theme Load (0.1ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" = 2 ORDER BY "themes"."id" ASC LIMIT 1
Upload Load (1.7ms) SELECT "uploads".* FROM "uploads" WHERE "uploads"."id" = -6 LIMIT 1
OptimizedImage Load (2.8ms) SELECT "optimized_images".* FROM "optimized_images" WHERE "optimized_images"."upload_id" = -6 AND "optimized_images"."height" = 512 AND "optimized_images"."width" = 512 LIMIT 1
Completed 200 OK in 101ms (Views: 0.2ms | ActiveRecord: 31.0ms | Allocations: 40847)
UserAuthToken Load (0.5ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:16.517118') LIMIT 1
User Load (12.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(1.7ms) SELECT "groups"."id" FROM "groups"
Delivering messages [{"global_id":-1,"message_id":-1,"channel":"/__status","data":{"/new":1,"/latest":2,"/unread/1":8,"/delete":0,"/recover":0,"/global/asset-version":4,"/site/banner":0,"/file-change":0,"/logout":0,"/site/read-only":0,"/reviewable_counts":0,"/categories":3,"/client_settings":7,"/refresh_client":0,"/notification-alert/1":1,"/new_user_narrative/tutorial_search":0,"/polls/9":0}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
(0.1ms) BEGIN
MiniScheduler::Stat Create (13.6ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::Tl3Promotions', 'charles-t440', 6570, 1066799, '2020-03-22 14:56:16.678581') RETURNING "id"
(8.6ms) COMMIT
User Load (20.9ms) SELECT "users".* FROM "users" LEFT JOIN (SELECT gu.user_id, MAX(g.grant_trust_level) AS group_granted_trust_level FROM groups g, group_users gu WHERE g.id = gu.group_id GROUP BY gu.user_id) tl ON users.id = tl.user_id WHERE (users.id > 0) AND (NOT EXISTS(
SELECT 1
FROM anonymous_users a
WHERE a.user_id = users.id
)) AND "users"."trust_level" = 3 AND "users"."manual_locked_trust_level" IS NULL AND (group_granted_trust_level IS NULL OR group_granted_trust_level < 3) ORDER BY "users"."id" ASC LIMIT 1000
User Load (6.6ms) SELECT "users".* FROM "users" INNER JOIN "user_stats" ON "user_stats"."user_id" = "users"."id" WHERE (users.id > 0) AND (NOT EXISTS(
SELECT 1
FROM anonymous_users a
WHERE a.user_id = users.id
)) AND (suspended_till IS NULL OR suspended_till <= '2020-03-22 14:56:16.738335') AND "users"."trust_level" = 2 AND "users"."manual_locked_trust_level" IS NULL AND 1=1 AND (user_stats.days_visited >= 50) AND (user_stats.topic_reply_count >= 10) AND (user_stats.topics_entered >= 200) AND (user_stats.posts_read_count >= 500) AND (user_stats.likes_given >= 30) AND (user_stats.likes_received >= 20) ORDER BY "users"."id" ASC LIMIT 1000
(5.4ms) BEGIN
MiniScheduler::Stat Update (6.2ms) UPDATE "scheduler_stats" SET "duration_ms" = 88, "live_slots_finish" = 1077444, "success" = TRUE WHERE "scheduler_stats"."id" = 503
(20.0ms) COMMIT
(0.4ms) BEGIN
MiniScheduler::Stat Create (5.3ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::EnsureDbConsistency', 'charles-t440', 6570, 1095882, '2020-03-22 14:56:17.688736') RETURNING "id"
(2.9ms) COMMIT
Group Load (0.5ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 0 LIMIT 1
(0.2ms) BEGIN
(0.5ms) COMMIT
WebHook Exists? (7.0ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (3.1ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 1 LIMIT 1
(0.2ms) BEGIN
(1.7ms) COMMIT
WebHook Exists? (1.9ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (2.4ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 1 LIMIT 1
(2.1ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 1
Group Update All (7.3ms) UPDATE "groups" SET "user_count" = 1 WHERE "groups"."id" = 1
Group Load (4.1ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 2 LIMIT 1
(1.7ms) BEGIN
(0.8ms) COMMIT
WebHook Exists? (5.8ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
(0.1ms) BEGIN
(2.8ms) COMMIT
WebHook Exists? (1.6ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (1.7ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 2 LIMIT 1
(6.4ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 2
Group Update All (1.8ms) UPDATE "groups" SET "user_count" = 0 WHERE "groups"."id" = 2
Group Load (2.1ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 3 LIMIT 1
(0.1ms) BEGIN
(0.2ms) COMMIT
WebHook Exists? (1.5ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (3.1ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 3 LIMIT 1
(6.3ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 3
Group Update All (2.5ms) UPDATE "groups" SET "user_count" = 1 WHERE "groups"."id" = 3
Group Load (1.7ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 10 LIMIT 1
(0.1ms) BEGIN
(0.8ms) COMMIT
WebHook Exists? (1.7ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (4.0ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 10 LIMIT 1
(1.8ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 10
Group Update All (2.7ms) UPDATE "groups" SET "user_count" = 1 WHERE "groups"."id" = 10
Group Load (1.8ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 11 LIMIT 1
(0.2ms) BEGIN
(0.3ms) COMMIT
WebHook Exists? (2.3ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (3.2ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 11 LIMIT 1
(2.1ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 11
Group Update All (2.0ms) UPDATE "groups" SET "user_count" = 1 WHERE "groups"."id" = 11
Group Load (1.5ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 12 LIMIT 1
(0.7ms) BEGIN
(2.2ms) COMMIT
WebHook Exists? (2.0ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (2.3ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 12 LIMIT 1
(2.0ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 12
Group Update All (2.4ms) UPDATE "groups" SET "user_count" = 0 WHERE "groups"."id" = 12
Group Load (1.5ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 13 LIMIT 1
(0.5ms) BEGIN
(1.3ms) COMMIT
WebHook Exists? (2.1ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (3.8ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 13 LIMIT 1
(2.4ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 13
Group Update All (2.5ms) UPDATE "groups" SET "user_count" = 0 WHERE "groups"."id" = 13
Group Load (1.6ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 14 LIMIT 1
(0.3ms) BEGIN
(0.2ms) COMMIT
WebHook Exists? (4.3ms) SELECT 1 AS one FROM "web_hooks" INNER JOIN "web_hook_event_types_hooks" ON "web_hook_event_types_hooks"."web_hook_id" = "web_hooks"."id" INNER JOIN "web_hook_event_types" ON "web_hook_event_types"."id" = "web_hook_event_types_hooks"."web_hook_event_type_id" WHERE "web_hooks"."active" = TRUE AND (web_hooks.wildcard_web_hook = TRUE OR web_hook_event_types.name = 'group') LIMIT 1
Group Load (2.2ms) SELECT "groups".* FROM "groups" WHERE "groups"."id" = 14 LIMIT 1
(1.9ms) SELECT COUNT(*) FROM "group_users" WHERE "group_users"."group_id" = 14
Group Update All (2.4ms) UPDATE "groups" SET "user_count" = 0 WHERE "groups"."id" = 14
Topic Update All (0.4ms) UPDATE "topics" SET "pinned_at" = NULL, "pinned_globally" = FALSE, "pinned_until" = NULL WHERE ("topics"."deleted_at" IS NULL) AND (pinned_until < now())
Category Load (0.7ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" LEFT JOIN topics ON categories.topic_id = topics.id AND topics.deleted_at IS NULL WHERE (categories.id <> 1) AND "topics"."id" IS NULL ORDER BY "categories"."id" ASC LIMIT 1000
UserStat Update All (0.9ms) UPDATE "user_stats" SET "bounce_score" = 0.0 WHERE (reset_bounce_score_after < now()) AND (bounce_score > 0)
EnsureDbConsitency Times
UserVisit: 0.00210723599997209
Group: 0.5740004470000031
Notification: 0.0008027549999951589
TopicFeaturedUsers: 0.001465294000013273
PostRevision: 0.0008700299999873096
Topic: 0.0010746319999839216
Badge: 0.002239437000014277
CategoryUser: 0.0004071609999982684
UserOption: 0.00024130200000627156
Tag: 0.0009808249999991858
CategoryTagStat: 0.0005803870000136158
User: 0.00044851199999129676
UserAvatar: 0.0006518150000260903
Category: 0.003764808999960678
UserAction: 0.007571780000034778
UserStat: 0.02018252699997447
(0.9ms) BEGIN
MiniScheduler::Stat Update (6.6ms) UPDATE "scheduler_stats" SET "duration_ms" = 649, "live_slots_finish" = 876574, "success" = TRUE WHERE "scheduler_stats"."id" = 504
(3.3ms) COMMIT
Started GET "/service-worker.js" for 127.0.0.1 at 2020-03-22 07:56:18 -0700
Processing by StaticController#service_worker_asset as */*
UserAuthToken Load (1.7ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:18.438632') LIMIT 1
User Load (2.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 1)
Completed 200 OK in 21ms (Views: 4.8ms | ActiveRecord: 3.8ms | Allocations: 15004)
Started GET "/latest.json?order=default" for 127.0.0.1 at 2020-03-22 07:56:25 -0700
Notification Update All (2.7ms) UPDATE "notifications" SET "read" = TRUE WHERE "notifications"."user_id" = 1 AND "notifications"."topic_id" = 9 AND "notifications"."post_number" = 1 AND "notifications"."read" = FALSE
UserAuthToken Load (1.0ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:25.335930') LIMIT 1
User Load (4.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(7.8ms) SELECT "groups"."id" FROM "groups"
Topic Load (7.1ms) SELECT "topics"."highest_post_number", "topics"."archetype", "topics"."id" FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 9 LIMIT 1
Processing by ListController#latest as JSON
Parameters: {"order"=>"default"}
TopicAllowedGroup Load (122.7ms) SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" WHERE "topic_allowed_groups"."topic_id" = 9
Rendering text template
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Rendered text template (Duration: 0.0ms | Allocations: 2)
UserAuthToken Load (3.8ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:25.492942') LIMIT 1
User Load (9.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
SQL (26.7ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND (topics.deleted_at IS NULL) AND (COALESCE(tu.notification_level,1) > 0) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND (pinned_globally AND pinned_at IS NOT NULL AND (topics.pinned_at > tu.cleared_pinned_at OR tu.cleared_pinned_at IS NULL)) ORDER BY topics.bumped_at DESC LIMIT 30
SQL (14.2ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND (topics.deleted_at IS NULL) AND (COALESCE(tu.notification_level,1) > 0) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND (NOT ( pinned_globally AND pinned_at IS NOT NULL AND (topics.pinned_at > tu.cleared_pinned_at OR tu.cleared_pinned_at IS NULL) )) ORDER BY topics.bumped_at DESC LIMIT 30
UserOption Load (5.5ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
TopicUser Load (1.7ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (7, 11, 9, 8, 6, 5, 4) AND "topic_users"."user_id" = 1
CategoryUser Load (3.1ms) SELECT "category_users".* FROM "category_users" WHERE "category_users"."category_id" IN (1, 3, 4) AND "category_users"."user_id" = 1
User Load (9.6ms) SELECT "users"."id", "user_emails"."email", "users"."username", "users"."name", "users"."uploaded_avatar_id" FROM "users" INNER JOIN "user_emails" ON "user_emails"."user_id" = "users"."id" WHERE "users"."id" IN (-1, 1)
User Load (7.4ms) SELECT "users"."id", "users"."primary_group_id" FROM "users" WHERE "users"."id" IN (-1, 1) AND "users"."primary_group_id" IS NOT NULL
Group Load (2.7ms) SELECT "groups"."id", "groups"."name", "groups"."flair_url", "groups"."flair_bg_color", "groups"."flair_color" FROM "groups" WHERE 1=0
(8.7ms) SELECT "child_themes"."child_theme_id" FROM "child_themes" WHERE "child_themes"."parent_theme_id" IS NULL
Theme Load (3.5ms) SELECT "themes".* FROM "themes" WHERE "themes"."id" IS NULL
(1.7ms) SELECT "theme_modifier_sets"."serialize_topic_excerpts" FROM "theme_modifier_sets" WHERE "theme_modifier_sets"."theme_id" IS NULL AND "theme_modifier_sets"."serialize_topic_excerpts" IS NOT NULL
UserStat Load (4.3ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = 1 LIMIT 1
Completed 200 OK in 386ms (Views: 0.5ms | ActiveRecord: 102.3ms | Allocations: 91301)
Delivering messages [] to client fb27cc895def4331917e474eac665d8b for user 1
Started GET "/t/5/2.json?track_visit=true&forceLoad=true" for 127.0.0.1 at 2020-03-22 07:56:31 -0700
Processing by TopicsController#show as JSON
Parameters: {"track_visit"=>"true", "forceLoad"=>"true", "topic_id"=>"5", "post_number"=>"2"}
UserAuthToken Load (3.1ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:31.628526') LIMIT 1
User Load (4.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserStat Load (6.0ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = 1 LIMIT 1
Topic Load (2.1ms) SELECT "topics".* FROM "topics" WHERE "topics"."id" = 5 ORDER BY "topics"."id" ASC LIMIT 1
Category Load (12.0ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" WHERE "categories"."id" = 3
Post Exists? (5.7ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
(1.9ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 2) ORDER BY "posts"."sort_order" DESC LIMIT 5
(6.5ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order >= 2) ORDER BY "posts"."sort_order" ASC LIMIT 19
(3.1ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 2) ORDER BY "posts"."sort_order" DESC LIMIT 18 OFFSET 1
(12.0ms) SELECT "posts"."id" FROM "posts" LEFT OUTER JOIN "users" ON "users"."id" = "posts"."user_id" LEFT OUTER JOIN "groups" ON "groups"."id" = "users"."primary_group_id" LEFT OUTER JOIN "users" "reply_to_users_posts" ON "reply_to_users_posts"."id" = "posts"."reply_to_user_id" LEFT OUTER JOIN "users" "deleted_bies_posts" ON "deleted_bies_posts"."id" = "posts"."deleted_by_id" LEFT OUTER JOIN "incoming_emails" ON "incoming_emails"."post_id" = "posts"."id" LEFT OUTER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE "posts"."id" IN (6, 7) AND "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
(6.2ms) SELECT "post_custom_fields"."post_id", "post_custom_fields"."name", "post_custom_fields"."value" FROM "post_custom_fields" WHERE "post_custom_fields"."post_id" IN (6, 7) AND "post_custom_fields"."name" IN ('notice_type', 'notice_args', 'action_code_who', 'requested_group_id', 'has_polls')
WatchedWord Exists? (3.8ms) SELECT 1 AS one FROM "watched_words" WHERE "watched_words"."action" = 3 LIMIT 1
(0.2ms) BEGIN
Post Load (7.5ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" IN (6, 7) AND "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
Topic Update All (17.5ms) UPDATE "topics" SET views = views + 1 WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 5
User Load (7.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
IncomingEmail Load (6.3ms) SELECT "incoming_emails".* FROM "incoming_emails" WHERE "incoming_emails"."post_id" IN (6, 7)
(18.7ms) COMMIT
Topic Load (10.8ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 5
TopicUser Update All (6.5ms) UPDATE "topic_users" SET "last_visited_at" = '2020-03-22 14:56:31.861379' WHERE "topic_users"."topic_id" = 5 AND "topic_users"."user_id" = 1
(2.9ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = TRUE
TopicUser Load (3.2ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" = 5 AND "topic_users"."user_id" = 1 LIMIT 1
(6.4ms) SELECT "post_timings"."post_number" FROM "post_timings" WHERE "post_timings"."topic_id" = 5 AND "post_timings"."user_id" = 1 AND "post_timings"."post_number" IN (1, 2)
PostAction Load (2.6ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_id" IN (6, 7) AND "post_actions"."user_id" = 1
(7.6ms) SELECT "posts"."id", EXTRACT(DAYS FROM CURRENT_TIMESTAMP - created_at)::INT AS days_ago FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY "posts"."sort_order" ASC
(5.9ms) SELECT MAX("posts"."post_number") FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4))
Topic Load (7.6ms) SELECT "topics".* FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (tu.last_read_post_number < topics.highest_staff_post_number) AND (COALESCE(tu.notification_level, 1) >= 2) AND (topics.updated_at >= '2020-03-22 14:46:18.319439') AND (topics.id NOT IN (5)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.user_id = tu.user_id THEN 1 ELSE 2 END, CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
UserOption Load (2.8ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
SQL (6.3ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (topics.created_at >= '2020-03-22 01:25:30.838675') AND (tu.last_read_post_number IS NULL) AND (COALESCE(tu.notification_level, 2) >= 2) AND (COALESCE(tu.notification_level,1) > 0) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND (category_users.last_seen_at IS NULL OR topics.created_at > category_users.last_seen_at) AND (topics.id NOT IN (5)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
(7.3ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(8.5ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:32.012561') ORDER BY RANDOM() LIMIT 3000
(4.4ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 3 LIMIT 1
(4.3ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 2 AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:32.038177') ORDER BY RANDOM() LIMIT 3000
SQL (7.8ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.id NOT IN (5,1,3,2)) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND "topics"."id" IN (7, 11, 4, 9, 5, 6) AND (topics.id NOT IN (5)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END LIMIT 5
TopicUser Load (5.3ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (6, 9, 4, 11, 7) AND "topic_users"."user_id" = 1
CategoryUser Load (14.8ms) SELECT "category_users".* FROM "category_users" WHERE "category_users"."category_id" IN (3, 1) AND "category_users"."user_id" = 1
User Load (10.4ms) SELECT "users"."id", "user_emails"."email", "users"."username", "users"."name", "users"."uploaded_avatar_id" FROM "users" INNER JOIN "user_emails" ON "user_emails"."user_id" = "users"."id" WHERE "users"."id" IN (-1, 1)
User Load (6.0ms) SELECT "users"."id", "users"."primary_group_id" FROM "users" WHERE "users"."id" IN (-1, 1) AND "users"."primary_group_id" IS NOT NULL
Group Load (12.0ms) SELECT "groups"."id", "groups"."name", "groups"."flair_url", "groups"."flair_bg_color", "groups"."flair_color" FROM "groups" WHERE 1=0
(12.8ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND "posts"."post_number" = 1 LIMIT 1
CACHE Post Exists? (0.0ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 5 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
TopicEmbed Exists? (7.3ms) SELECT 1 AS one FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) AND "topic_embeds"."topic_id" = 5 LIMIT 1
TopicTimer Load (20.8ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 5 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = TRUE LIMIT 1
TopicTimer Load (19.6ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 5 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = FALSE AND "topic_timers"."user_id" = 1 LIMIT 1
CACHE User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
Group Load (13.4ms) SELECT "groups".* FROM "groups" INNER JOIN "topic_allowed_groups" ON "groups"."id" = "topic_allowed_groups"."group_id" WHERE "topic_allowed_groups"."topic_id" = 5
Category Exists? (11.2ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 5 LIMIT 1
Group Exists? (10.1ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Group Exists? (0.0ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Category Exists? (0.0ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 5 LIMIT 1
User Load (8.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
CACHE User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
Completed 200 OK in 837ms (Views: 0.5ms | ActiveRecord: 329.3ms | Allocations: 171164)
UserAuthToken Load (0.8ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:32.963321') LIMIT 1
User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(10.4ms) SELECT "groups"."id" FROM "groups"
Delivering messages [{"global_id":-1,"message_id":-1,"channel":"/__status","data":{"/polls/5":0}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
UserStat Update All (3.3ms) UPDATE "user_stats" SET time_read = time_read + 10 WHERE "user_stats"."user_id" = 1
UserVisit Update All (7.6ms) UPDATE "user_visits" SET time_read = time_read + 10 WHERE "user_visits"."user_id" = 1 AND "user_visits"."visited_at" = '2020-03-22'
Post Update All (3.8ms) UPDATE "posts" SET reads = reads + 1 WHERE ("posts"."deleted_at" IS NULL) AND (topic_id = 5 and post_number = 2)
UserStat Update All (6.2ms) UPDATE "user_stats" SET posts_read_count = posts_read_count + 1 WHERE "user_stats"."user_id" = 1
Notification Update All (6.3ms) UPDATE "notifications" SET "read" = TRUE WHERE "notifications"."user_id" = 1 AND "notifications"."topic_id" = 5 AND "notifications"."post_number" IN (1, 2) AND "notifications"."read" = FALSE
Delivering messages [{"global_id":1437,"message_id":9,"channel":"/unread/1","data":{"topic_id":5,"message_type":"read","payload":{"last_read_post_number":2,"highest_post_number":2,"topic_id":5,"notification_level":1}}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [{"global_id":1437,"message_id":9,"channel":"/unread/1","data":{"topic_id":5,"message_type":"read","payload":{"last_read_post_number":2,"highest_post_number":2,"topic_id":5,"notification_level":1}}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [{"global_id":1437,"message_id":9,"channel":"/unread/1","data":{"topic_id":5,"message_type":"read","payload":{"last_read_post_number":2,"highest_post_number":2,"topic_id":5,"notification_level":1}}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
UserVisit Load (0.7ms) SELECT "user_visits".* FROM "user_visits" WHERE "user_visits"."user_id" = 1 AND "user_visits"."visited_at" = '2020-03-22' LIMIT 1
(9.7ms) BEGIN
UserVisit Update (7.5ms) UPDATE "user_visits" SET "posts_read" = 7 WHERE "user_visits"."id" = 1
(6.3ms) COMMIT
Topic Load (8.3ms) SELECT "topics"."highest_post_number", "topics"."archetype", "topics"."id" FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 5 LIMIT 1
TopicAllowedGroup Load (3.7ms) SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" WHERE "topic_allowed_groups"."topic_id" = 5
Rendering text template
Rendered text template (Duration: 0.0ms | Allocations: 2)
Started GET "/t/6/3.json?track_visit=true&forceLoad=true" for 127.0.0.1 at 2020-03-22 07:56:35 -0700
UserAuthToken Load (0.7ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:36.154359') LIMIT 1
UserStat Update All (1.9ms) UPDATE "user_stats" SET time_read = time_read + 1 WHERE "user_stats"."user_id" = 1
UserVisit Update All (9.4ms) UPDATE "user_visits" SET time_read = time_read + 1 WHERE "user_visits"."user_id" = 1 AND "user_visits"."visited_at" = '2020-03-22'
User Load (37.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Notification Update All (7.4ms) UPDATE "notifications" SET "read" = TRUE WHERE "notifications"."user_id" = 1 AND "notifications"."topic_id" = 5 AND "notifications"."post_number" IN (1, 2) AND "notifications"."read" = FALSE
(15.2ms) SELECT "groups"."id" FROM "groups"
Topic Load (0.6ms) SELECT "topics"."highest_post_number", "topics"."archetype", "topics"."id" FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 5 LIMIT 1
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
TopicAllowedGroup Load (2.5ms) SELECT "topic_allowed_groups".* FROM "topic_allowed_groups" WHERE "topic_allowed_groups"."topic_id" = 5
Rendering text template
Rendered text template (Duration: 0.1ms | Allocations: 2)
Processing by TopicsController#show as JSON
Parameters: {"track_visit"=>"true", "forceLoad"=>"true", "topic_id"=>"6", "post_number"=>"3"}
UserAuthToken Load (2.9ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:36.525331') LIMIT 1
User Load (9.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
UserStat Load (3.9ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = 1 LIMIT 1
Topic Load (4.3ms) SELECT "topics".* FROM "topics" WHERE "topics"."id" = 6 ORDER BY "topics"."id" ASC LIMIT 1
Category Load (5.7ms) SELECT "categories"."id", "categories"."name", "categories"."color", "categories"."topic_id", "categories"."topic_count", "categories"."created_at", "categories"."updated_at", "categories"."user_id", "categories"."topics_year", "categories"."topics_month", "categories"."topics_week", "categories"."slug", "categories"."description", "categories"."text_color", "categories"."read_restricted", "categories"."auto_close_hours", "categories"."post_count", "categories"."latest_post_id", "categories"."latest_topic_id", "categories"."position", "categories"."parent_category_id", "categories"."posts_year", "categories"."posts_month", "categories"."posts_week", "categories"."email_in", "categories"."email_in_allow_strangers", "categories"."topics_day", "categories"."posts_day", "categories"."allow_badges", "categories"."name_lower", "categories"."auto_close_based_on_last_post", "categories"."topic_template", "categories"."contains_messages", "categories"."sort_order", "categories"."sort_ascending", "categories"."uploaded_logo_id", "categories"."uploaded_background_id", "categories"."topic_featured_link_allowed", "categories"."all_topics_wiki", "categories"."show_subcategory_list", "categories"."num_featured_topics", "categories"."default_view", "categories"."subcategory_list_style", "categories"."default_top_period", "categories"."mailinglist_mirror", "categories"."minimum_required_tags", "categories"."navigate_to_first_post_after_read", "categories"."search_priority", "categories"."allow_global_tags", "categories"."reviewable_by_group_id", "categories"."required_tag_group_id", "categories"."min_tags_from_required_group" FROM "categories" WHERE "categories"."id" = 3
Post Exists? (2.5ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
(5.5ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 2) ORDER BY "posts"."sort_order" DESC LIMIT 5
(8.0ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order >= 2) ORDER BY "posts"."sort_order" ASC LIMIT 19
(5.6ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.sort_order < 2) ORDER BY "posts"."sort_order" DESC LIMIT 18 OFFSET 1
(7.6ms) SELECT "posts"."id" FROM "posts" LEFT OUTER JOIN "users" ON "users"."id" = "posts"."user_id" LEFT OUTER JOIN "groups" ON "groups"."id" = "users"."primary_group_id" LEFT OUTER JOIN "users" "reply_to_users_posts" ON "reply_to_users_posts"."id" = "posts"."reply_to_user_id" LEFT OUTER JOIN "users" "deleted_bies_posts" ON "deleted_bies_posts"."id" = "posts"."deleted_by_id" LEFT OUTER JOIN "incoming_emails" ON "incoming_emails"."post_id" = "posts"."id" LEFT OUTER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE "posts"."id" IN (8, 9) AND "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
(6.2ms) SELECT "post_custom_fields"."post_id", "post_custom_fields"."name", "post_custom_fields"."value" FROM "post_custom_fields" WHERE "post_custom_fields"."post_id" IN (8, 9) AND "post_custom_fields"."name" IN ('notice_type', 'notice_args', 'action_code_who', 'requested_group_id', 'has_polls')
WatchedWord Exists? (2.6ms) SELECT 1 AS one FROM "watched_words" WHERE "watched_words"."action" = 3 LIMIT 1
Post Load (5.0ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" IN (8, 9) AND "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY sort_order
User Load (11.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
IncomingEmail Load (7.8ms) SELECT "incoming_emails".* FROM "incoming_emails" WHERE "incoming_emails"."post_id" IN (8, 9)
Topic Load (2.8ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 6
(2.9ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = TRUE
(3.9ms) BEGIN
TopicUser Load (11.3ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" = 6 AND "topic_users"."user_id" = 1 LIMIT 1
Topic Update All (11.1ms) UPDATE "topics" SET views = views + 1 WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" = 6
(6.5ms) SELECT "post_timings"."post_number" FROM "post_timings" WHERE "post_timings"."topic_id" = 6 AND "post_timings"."user_id" = 1 AND "post_timings"."post_number" IN (1, 2)
(3.3ms) COMMIT
TopicUser Update All (11.9ms) UPDATE "topic_users" SET "last_visited_at" = '2020-03-22 14:56:36.845622' WHERE "topic_users"."topic_id" = 6 AND "topic_users"."user_id" = 1
PostAction Load (17.8ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_id" IN (8, 9) AND "post_actions"."user_id" = 1
(2.8ms) SELECT "posts"."id", EXTRACT(DAYS FROM CURRENT_TIMESTAMP - created_at)::INT AS days_ago FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) ORDER BY "posts"."sort_order" ASC
(6.7ms) SELECT MAX("posts"."post_number") FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4))
Topic Load (4.5ms) SELECT "topics".* FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (tu.last_read_post_number < topics.highest_staff_post_number) AND (COALESCE(tu.notification_level, 1) >= 2) AND (topics.updated_at >= '2020-03-22 14:46:18.319439') AND (topics.id NOT IN (6)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.user_id = tu.user_id THEN 1 ELSE 2 END, CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
UserOption Load (3.0ms) SELECT "user_options".* FROM "user_options" WHERE "user_options"."user_id" = 1 LIMIT 1
SQL (10.1ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (topics.created_at >= '2020-03-22 01:25:30.838675') AND (tu.last_read_post_number IS NULL) AND (COALESCE(tu.notification_level, 2) >= 2) AND (COALESCE(tu.notification_level,1) > 0) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND (category_users.last_seen_at IS NULL OR topics.created_at > category_users.last_seen_at) AND (topics.id NOT IN (6)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END, topics.bumped_at DESC LIMIT 5
(2.8ms) SELECT "categories"."id" FROM "categories" WHERE "categories"."read_restricted" = FALSE
(7.4ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND (topics.deleted_at IS NULL) AND (topics.category_id IS NULL or topics.category_id IN (2,1)) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:36.946342') ORDER BY RANDOM() LIMIT 3000
(4.8ms) SELECT "categories"."sort_order", "categories"."sort_ascending" FROM "categories" WHERE "categories"."id" = 3 LIMIT 1
(2.9ms) SELECT "topics"."id" FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" WHERE (categories.id in (3) AND (
categories.topic_id <> topics.id OR categories.id = 3
)
) AND (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND "topics"."visible" = TRUE AND "topics"."id" != 2 AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.created_at > '2019-03-23 14:56:36.975129') ORDER BY RANDOM() LIMIT 3000
SQL (7.5ms) SELECT "topics"."id" AS t0_r0, "topics"."title" AS t0_r1, "topics"."last_posted_at" AS t0_r2, "topics"."created_at" AS t0_r3, "topics"."updated_at" AS t0_r4, "topics"."views" AS t0_r5, "topics"."posts_count" AS t0_r6, "topics"."user_id" AS t0_r7, "topics"."last_post_user_id" AS t0_r8, "topics"."reply_count" AS t0_r9, "topics"."featured_user1_id" AS t0_r10, "topics"."featured_user2_id" AS t0_r11, "topics"."featured_user3_id" AS t0_r12, "topics"."avg_time" AS t0_r13, "topics"."deleted_at" AS t0_r14, "topics"."highest_post_number" AS t0_r15, "topics"."image_url" AS t0_r16, "topics"."like_count" AS t0_r17, "topics"."incoming_link_count" AS t0_r18, "topics"."category_id" AS t0_r19, "topics"."visible" AS t0_r20, "topics"."moderator_posts_count" AS t0_r21, "topics"."closed" AS t0_r22, "topics"."archived" AS t0_r23, "topics"."bumped_at" AS t0_r24, "topics"."has_summary" AS t0_r25, "topics"."archetype" AS t0_r26, "topics"."featured_user4_id" AS t0_r27, "topics"."notify_moderators_count" AS t0_r28, "topics"."spam_count" AS t0_r29, "topics"."pinned_at" AS t0_r30, "topics"."score" AS t0_r31, "topics"."percent_rank" AS t0_r32, "topics"."subtype" AS t0_r33, "topics"."slug" AS t0_r34, "topics"."deleted_by_id" AS t0_r35, "topics"."participant_count" AS t0_r36, "topics"."word_count" AS t0_r37, "topics"."excerpt" AS t0_r38, "topics"."pinned_globally" AS t0_r39, "topics"."pinned_until" AS t0_r40, "topics"."fancy_title" AS t0_r41, "topics"."highest_staff_post_number" AS t0_r42, "topics"."featured_link" AS t0_r43, "topics"."reviewable_score" AS t0_r44, "categories"."id" AS t1_r0, "categories"."name" AS t1_r1, "categories"."color" AS t1_r2, "categories"."topic_id" AS t1_r3, "categories"."topic_count" AS t1_r4, "categories"."created_at" AS t1_r5, "categories"."updated_at" AS t1_r6, "categories"."user_id" AS t1_r7, "categories"."topics_year" AS t1_r8, "categories"."topics_month" AS t1_r9, "categories"."topics_week" AS t1_r10, "categories"."slug" AS t1_r11, "categories"."description" AS t1_r12, "categories"."text_color" AS t1_r13, "categories"."read_restricted" AS t1_r14, "categories"."auto_close_hours" AS t1_r15, "categories"."post_count" AS t1_r16, "categories"."latest_post_id" AS t1_r17, "categories"."latest_topic_id" AS t1_r18, "categories"."position" AS t1_r19, "categories"."parent_category_id" AS t1_r20, "categories"."posts_year" AS t1_r21, "categories"."posts_month" AS t1_r22, "categories"."posts_week" AS t1_r23, "categories"."email_in" AS t1_r24, "categories"."email_in_allow_strangers" AS t1_r25, "categories"."topics_day" AS t1_r26, "categories"."posts_day" AS t1_r27, "categories"."allow_badges" AS t1_r28, "categories"."name_lower" AS t1_r29, "categories"."auto_close_based_on_last_post" AS t1_r30, "categories"."topic_template" AS t1_r31, "categories"."contains_messages" AS t1_r32, "categories"."sort_order" AS t1_r33, "categories"."sort_ascending" AS t1_r34, "categories"."uploaded_logo_id" AS t1_r35, "categories"."uploaded_background_id" AS t1_r36, "categories"."topic_featured_link_allowed" AS t1_r37, "categories"."all_topics_wiki" AS t1_r38, "categories"."show_subcategory_list" AS t1_r39, "categories"."num_featured_topics" AS t1_r40, "categories"."default_view" AS t1_r41, "categories"."subcategory_list_style" AS t1_r42, "categories"."default_top_period" AS t1_r43, "categories"."mailinglist_mirror" AS t1_r44, "categories"."minimum_required_tags" AS t1_r45, "categories"."navigate_to_first_post_after_read" AS t1_r46, "categories"."search_priority" AS t1_r47, "categories"."allow_global_tags" AS t1_r48, "categories"."reviewable_by_group_id" AS t1_r49, "categories"."required_tag_group_id" AS t1_r50, "categories"."min_tags_from_required_group" AS t1_r51 FROM "topics" LEFT OUTER JOIN "categories" ON "categories"."id" = "topics"."category_id" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 1) LEFT JOIN category_users ON category_users.category_id = topics.category_id AND category_users.user_id = 1 WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND "topics"."closed" = FALSE AND "topics"."archived" = FALSE AND (topics.id NOT IN (6,1,3,2)) AND (topics.category_id = -1
OR COALESCE(category_users.notification_level, 1) <> 0
OR tu.notification_level > 1) AND "topics"."id" IN (11, 7, 6, 9, 4, 5) AND (topics.id NOT IN (6)) AND "topics"."visible" = TRUE ORDER BY CASE WHEN topics.category_id = 3 THEN 0 ELSE 1 END LIMIT 5
TopicUser Load (8.7ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (9, 4, 5, 11, 7) AND "topic_users"."user_id" = 1
CategoryUser Load (7.8ms) SELECT "category_users".* FROM "category_users" WHERE "category_users"."category_id" IN (3, 1) AND "category_users"."user_id" = 1
User Load (2.0ms) SELECT "users"."id", "user_emails"."email", "users"."username", "users"."name", "users"."uploaded_avatar_id" FROM "users" INNER JOIN "user_emails" ON "user_emails"."user_id" = "users"."id" WHERE "users"."id" IN (-1, 1)
User Load (5.0ms) SELECT "users"."id", "users"."primary_group_id" FROM "users" WHERE "users"."id" IN (-1, 1) AND "users"."primary_group_id" IS NOT NULL
Group Load (5.7ms) SELECT "groups"."id", "groups"."name", "groups"."flair_url", "groups"."flair_bg_color", "groups"."flair_color" FROM "groups" WHERE 1=0
(1.6ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND "posts"."post_number" = 2 LIMIT 1
CACHE Post Exists? (0.0ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = 6 AND (posts.user_id = 1 OR post_type IN (1,2,3,4)) AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1
TopicEmbed Exists? (3.0ms) SELECT 1 AS one FROM "topic_embeds" WHERE ("topic_embeds"."deleted_at" IS NULL) AND "topic_embeds"."topic_id" = 6 LIMIT 1
TopicTimer Load (7.2ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 6 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = TRUE LIMIT 1
TopicTimer Load (2.4ms) SELECT "topic_timers".* FROM "topic_timers" WHERE ("topic_timers"."deleted_at" IS NULL) AND "topic_timers"."topic_id" = 6 AND "topic_timers"."deleted_at" IS NULL AND "topic_timers"."public_type" = FALSE AND "topic_timers"."user_id" = 1 LIMIT 1
CACHE User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1
Group Load (2.8ms) SELECT "groups".* FROM "groups" INNER JOIN "topic_allowed_groups" ON "groups"."id" = "topic_allowed_groups"."group_id" WHERE "topic_allowed_groups"."topic_id" = 6
Category Exists? (5.3ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 6 LIMIT 1
Group Exists? (5.7ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Group Exists? (0.0ms) SELECT 1 AS one FROM "groups" INNER JOIN "category_groups" ON "groups"."id" = "category_groups"."group_id" WHERE "category_groups"."category_id" = 3 AND "groups"."automatic" = FALSE LIMIT 1
CACHE Category Exists? (0.0ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 6 LIMIT 1
User Load (2.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
CACHE User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
Completed 200 OK in 660ms (Views: 0.4ms | ActiveRecord: 249.7ms | Allocations: 198144)
UserAuthToken Load (0.6ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:56:37.579249') LIMIT 1
User Load (159.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(10.6ms) SELECT "groups"."id" FROM "groups"
Delivering messages [{"global_id":-1,"message_id":-1,"channel":"/__status","data":{"/polls/6":0}}] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
(0.2ms) BEGIN
MiniScheduler::Stat Create (2.0ms) INSERT INTO "scheduler_stats" ("name", "hostname", "pid", "live_slots_start", "started_at") VALUES ('Jobs::ProcessBadgeBacklog', 'charles-t440', 6570, 1026439, '2020-03-22 14:56:54.811754') RETURNING "id"
(2.3ms) COMMIT
(1.0ms) BEGIN
MiniScheduler::Stat Update (1.0ms) UPDATE "scheduler_stats" SET "duration_ms" = 25, "live_slots_finish" = 1036918, "success" = TRUE WHERE "scheduler_stats"."id" = 505
(4.5ms) COMMIT
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
UserAuthToken Load (0.3ms) SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=' OR
prev_auth_token = 'v43iomhQfdwPNBMhRuweik9LYe0=') AND rotated_at > '2020-01-22 14:57:02.933616') LIMIT 1
User Load (2.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
(3.1ms) SELECT "groups"."id" FROM "groups"
UserVisit Load (10.2ms) SELECT "user_visits".* FROM "user_visits" WHERE "user_visits"."user_id" = 1 AND "user_visits"."visited_at" = '2020-03-22' LIMIT 1
Delivering messages [] to client b62a55e60e404fb68f566e608aa0e6fe for user 1 (chunked)
User Update (4.4ms) UPDATE "users" SET "last_seen_at" = '2020-03-22 14:57:02.941704' WHERE "users"."id" = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment