Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- => Booting Thin
- => Rails 4.1.8 application starting in development on http://0.0.0.0:3000
- => Run `rails server -h` for more startup options
- => Notice: server is listening on all interfaces (0.0.0.0). Consider using 127.0.0.1 (--binding option)
- => Ctrl-C to shutdown server
- Thin web server (v1.6.2 codename Doc Brown)
- Maximum connections set to 1024
- Listening on 0.0.0.0:3000, CTRL+C to stop
- D, [2015-01-31T05:35:54.451136 #32680] DEBUG -- :
- D, [2015-01-31T05:35:54.451208 #32680] DEBUG -- :
- I, [2015-01-31T05:35:54.451343 #32680] INFO -- : Started GET "/" for 127.0.0.1 at 2015-01-31 05:35:54 -0800
- D, [2015-01-31T05:35:54.504357 #32680] DEBUG -- : ActiveRecord::SchemaMigration Load (0.7ms) SELECT "schema_migrations".* FROM "schema_migrations"
- D, [2015-01-31T05:35:54.605595 #32680] DEBUG -- : User Load (24.8ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- I, [2015-01-31T05:35:54.651809 #32680] INFO -- : Processing by ListController#latest as HTML
- D, [2015-01-31T05:35:54.797799 #32680] DEBUG -- : UserVisit Load (15.9ms) SELECT "user_visits".* FROM "user_visits" WHERE "user_visits"."user_id" = $1 AND "user_visits"."visited_at" = '2015-01-31' LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:35:54.896621 #32680] DEBUG -- : UserStat Load (31.9ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:35:55.025772 #32680] DEBUG -- : SQL (14.8ms) UPDATE "user_stats" SET "days_visited" = 48 WHERE "user_stats"."user_id" = 35548
- D, [2015-01-31T05:35:55.106615 #32680] DEBUG -- : (5.8ms) BEGIN
- D, [2015-01-31T05:35:55.222914 #32680] DEBUG -- : SQL (13.1ms) INSERT INTO "user_visits" ("user_id", "visited_at") VALUES ($1, $2) RETURNING "id" [["user_id", 35548], ["visited_at", "2015-01-31"]]
- D, [2015-01-31T05:35:55.295667 #32680] DEBUG -- : (13.9ms) COMMIT
- D, [2015-01-31T05:35:55.334326 #32680] DEBUG -- : SQL (15.8ms) UPDATE "users" SET "previous_visit_at" = '2015-01-29 09:05:20.543793' WHERE "users"."id" = 35548
- D, [2015-01-31T05:35:55.335569 #32680] DEBUG -- : Group Load (1.4ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."name" ASC
- D, [2015-01-31T05:35:55.343470 #32680] DEBUG -- : SQL (5.5ms) UPDATE "users" SET "last_seen_at" = '2015-01-31 13:35:54.642526' WHERE "users"."id" = 35548
- D, [2015-01-31T05:35:55.351631 #32680] DEBUG -- : (1.0ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = 't'
- D, [2015-01-31T05:35:55.354641 #32680] DEBUG -- : Category Load (1.3ms) SELECT "categories".* FROM "categories" WHERE (NOT categories.read_restricted or categories.id in (2,4)) ORDER BY "categories"."position" ASC
- D, [2015-01-31T05:35:55.445799 #32680] DEBUG -- : Topic Load (4.2ms) SELECT id, title, slug FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."id" IN (2, 3, 2124, 1389, 1)
- D, [2015-01-31T05:35:55.465064 #32680] DEBUG -- : (0.9ms) SELECT "categories"."id" FROM "categories"
- D, [2015-01-31T05:35:55.472626 #32680] DEBUG -- : (1.0ms) SELECT "category_users"."category_id", "category_users"."notification_level" FROM "category_users" WHERE "category_users"."user_id" = 35548
- D, [2015-01-31T05:35:55.478936 #32680] DEBUG -- : PostActionType Load (0.9ms) SELECT "post_action_types".* FROM "post_action_types" ORDER BY position asc
- D, [2015-01-31T05:35:55.488863 #32680] DEBUG -- : PostActionType Load (1.0ms) SELECT "post_action_types".* FROM "post_action_types" WHERE "post_action_types"."name_key" IN ('inappropriate', 'spam', 'notify_moderators') ORDER BY position asc
- D, [2015-01-31T05:35:55.500994 #32680] DEBUG -- : UserField Load (8.5ms) SELECT "user_fields".* FROM "user_fields"
- D, [2015-01-31T05:35:55.518369 #32680] DEBUG -- : SiteCustomization Load (9.4ms) SELECT "site_customizations".* FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- D, [2015-01-31T05:35:55.527911 #32680] DEBUG -- : CACHE (0.0ms) SELECT "site_customizations".* FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- D, [2015-01-31T05:35:55.534606 #32680] DEBUG -- : Topic Load (4.5ms) SELECT "topics".* FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."archetype" = 'banner' ORDER BY "topics"."id" ASC LIMIT 1
- D, [2015-01-31T05:35:55.551052 #32680] DEBUG -- : (2.8ms) SELECT COUNT(*) FROM "notifications" WHERE "notifications"."user_id" = $1 AND (read = false) [["user_id", 35548]]
- D, [2015-01-31T05:35:55.556310 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) AS count_all, notification_type AS notification_type FROM "notifications" WHERE "notifications"."user_id" = $1 AND (id > 95966 and read = false) GROUP BY notification_type [["user_id", 35548]]
- D, [2015-01-31T05:35:55.558438 #32680] DEBUG -- : (0.6ms) SELECT COUNT(*) FROM "notifications" WHERE "notifications"."user_id" = $1 AND (read = false AND notification_type = 6) [["user_id", 35548]]
- D, [2015-01-31T05:35:55.564098 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."user_id" = $1 [["user_id", 35548]]
- D, [2015-01-31T05:35:55.574294 #32680] DEBUG -- : (2.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (yearly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.577315 #32680] DEBUG -- : (1.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (monthly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.579685 #32680] DEBUG -- : (1.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (weekly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.581722 #32680] DEBUG -- : (0.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (daily_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.582861 #32680] DEBUG -- : CACHE (0.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (yearly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.583885 #32680] DEBUG -- : CACHE (0.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (monthly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.584893 #32680] DEBUG -- : CACHE (0.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (weekly_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.585923 #32680] DEBUG -- : CACHE (0.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "top_topics" WHERE (daily_score > 0) LIMIT 50) subquery_for_count
- D, [2015-01-31T05:35:55.588432 #32680] DEBUG -- : (0.8ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 35548 AND "category_users"."notification_level" = 0
- D, [2015-01-31T05:35:55.596877 #32680] DEBUG -- : UserProfile Load (0.8ms) SELECT "user_profiles".* FROM "user_profiles" WHERE "user_profiles"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:35:55.656392 #32680] DEBUG -- : (48.2ms) WITH x AS (
- SELECT u.id AS user_id,
- topics.id AS topic_id,
- topics.created_at,
- highest_post_number,
- last_read_post_number,
- c.id AS category_id,
- tu.notification_level
- FROM users u
- INNER JOIN user_stats AS us ON us.user_id = u.id
- FULL OUTER JOIN topics ON 1=1
- LEFT JOIN topic_users tu ON tu.topic_id = topics.id AND tu.user_id = u.id
- LEFT JOIN categories c ON c.id = topics.category_id
- WHERE u.id IN (35548) AND
- topics.archetype <> 'private_message' AND
- (("topics"."deleted_at" IS NULL AND tu.last_read_post_number < topics.highest_post_number AND COALESCE(tu.notification_level, 1) >= 2) OR ("topics"."deleted_at" IS NULL AND topics.created_at >= GREATEST(CASE
- WHEN COALESCE(u.new_topic_duration_minutes, 2880) = -1 THEN u.created_at
- WHEN COALESCE(u.new_topic_duration_minutes, 2880) = -2 THEN COALESCE(u.previous_visit_at,u.created_at)
- ELSE ('2015-01-31 13:35:55.607799'::timestamp - INTERVAL '1 MINUTE' * COALESCE(u.new_topic_duration_minutes, 2880))
- END, us.new_since) AND tu.last_read_post_number IS NULL AND COALESCE(tu.notification_level, 2) >= 2)) AND
- (topics.visible OR u.admin OR u.moderator) AND
- topics.deleted_at IS NULL AND
- ( category_id IS NULL OR NOT c.read_restricted OR category_id IN (
- SELECT c2.id FROM categories c2
- JOIN category_groups cg ON cg.category_id = c2.id
- JOIN group_users gu ON gu.user_id = u.id AND cg.group_id = gu.group_id
- WHERE c2.read_restricted )
- )
- AND NOT EXISTS( SELECT 1 FROM category_users cu
- WHERE cu.user_id = u.id AND
- cu.category_id = topics.category_id AND
- cu.notification_level = 0)
- ORDER BY topics.bumped_at DESC ) SELECT * FROM x LIMIT 500
- D, [2015-01-31T05:35:55.686723 #32680] DEBUG -- : (22.0ms) select sequence from draft_sequences where user_id = 35548 and draft_key = 'new_topic'
- D, [2015-01-31T05:35:55.702415 #32680] DEBUG -- : Draft Load (1.1ms) SELECT "drafts".* FROM "drafts" WHERE "drafts"."user_id" = 35548 AND "drafts"."draft_key" = 'new_topic' LIMIT 1
- D, [2015-01-31T05:35:55.732231 #32680] DEBUG -- : SQL (8.0ms) 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"."off_topic_count" AS t0_r17, "topics"."like_count" AS t0_r18, "topics"."incoming_link_count" AS t0_r19, "topics"."bookmark_count" AS t0_r20, "topics"."category_id" AS t0_r21, "topics"."visible" AS t0_r22, "topics"."moderator_posts_count" AS t0_r23, "topics"."closed" AS t0_r24, "topics"."archived" AS t0_r25, "topics"."bumped_at" AS t0_r26, "topics"."has_summary" AS t0_r27, "topics"."vote_count" AS t0_r28, "topics"."archetype" AS t0_r29, "topics"."featured_user4_id" AS t0_r30, "topics"."notify_moderators_count" AS t0_r31, "topics"."spam_count" AS t0_r32, "topics"."illegal_count" AS t0_r33, "topics"."inappropriate_count" AS t0_r34, "topics"."pinned_at" AS t0_r35, "topics"."score" AS t0_r36, "topics"."percent_rank" AS t0_r37, "topics"."notify_user_count" AS t0_r38, "topics"."subtype" AS t0_r39, "topics"."slug" AS t0_r40, "topics"."auto_close_at" AS t0_r41, "topics"."auto_close_user_id" AS t0_r42, "topics"."auto_close_started_at" AS t0_r43, "topics"."deleted_by_id" AS t0_r44, "topics"."participant_count" AS t0_r45, "topics"."word_count" AS t0_r46, "topics"."excerpt" AS t0_r47, "topics"."pinned_globally" AS t0_r48, "topics"."auto_close_based_on_last_post" AS t0_r49, "topics"."auto_close_hours" AS t0_r50, "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"."logo_url" AS t1_r28, "categories"."background_url" AS t1_r29, "categories"."allow_badges" AS t1_r30, "categories"."name_lower" AS t1_r31, "categories"."auto_close_based_on_last_post" AS t1_r32 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 = 35548) WHERE (topics.archetype <> 'private_message') AND (COALESCE(categories.topic_id, 0) <> topics.id) AND (topics.deleted_at IS NULL) AND (NOT EXISTS(
- SELECT 1 FROM category_users cu
- WHERE cu.user_id = 35548 AND
- cu.category_id = topics.category_id AND
- cu.notification_level = 0 AND
- cu.category_id <> -1
- )) ORDER BY CASE
- WHEN topics.pinned_globally
- AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
- THEN topics.pinned_at + interval '9999 years'
- ELSE topics.bumped_at
- END DESC LIMIT 30
- D, [2015-01-31T05:35:55.739318 #32680] DEBUG -- : TopicUser Load (1.4ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (6, 2127, 2126, 2125, 117, 2116, 2115, 2114, 123, 2063, 612, 571, 113, 274, 764, 1344, 911, 44, 517, 41, 1393, 1339, 53, 1242, 1131, 217, 858, 1851, 1022, 1520) AND "topic_users"."user_id" = 35548
- D, [2015-01-31T05:35:55.791723 #32680] DEBUG -- : User Load (38.1ms) SELECT "users"."id", "users"."email", "users"."username", "users"."uploaded_avatar_id" FROM "users" WHERE "users"."id" IN (-1, 1, 35548, 52, 150, 193, 361, 36222, 5624, 435, 1034, 1037, 36216, 36182, 35609, 36171, 36199, 36208, 3014, 3891, 543, 7953, 26857, 14180, 1599, 735, 1260, 36202, 5079, 2985, 5055, 5068, 36197, 9398, 15214, 1260, 1755, 2742, 13060, 31048, 13312, 235, 15133, 14818, 35303, 35862, 10248, 735, 6609, 5726, 36160, 542, 1180, 1796, 1139, 25059, 1260, 154, 8743, 2279, 36155, 1559, 998, 1587, 1603, 35526, 35548, 35668, 35535, 35538, 36133, 5893, 26, 34450, 2505, 528, 2486, 2488, 54, 36130, 30942, 34782, 16644, 6141, 36147, 2868, 6585, 1139, 1035, 5382, 1139, 3891, 6978, 12094, 36085, 32061, 36130, 32058, 596, 36077, 36062, 36017, 36068, 36113, 15821, 33220, 33232, 33230, 35637, 35629, 35716)
- I, [2015-01-31T05:35:55.849377 #32680] INFO -- : Rendered list/list.erb within layouts/application (10.6ms)
- I, [2015-01-31T05:35:55.861234 #32680] INFO -- : Rendered layouts/_head.html.erb (6.3ms)
- I, [2015-01-31T05:35:55.877379 #32680] INFO -- : Rendered common/_special_font_face.html.erb (13.9ms)
- D, [2015-01-31T05:35:55.887659 #32680] DEBUG -- : ColorScheme Load (1.1ms) SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."versioned_id" IS NULL AND "color_schemes"."enabled" = 't' LIMIT 1
- D, [2015-01-31T05:35:55.890470 #32680] DEBUG -- : (1.3ms) SELECT "categories"."updated_at" FROM "categories" ORDER BY updated_at desc LIMIT 1
- D, [2015-01-31T05:35:55.931180 #32680] DEBUG -- : CACHE (0.0ms) SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."versioned_id" IS NULL AND "color_schemes"."enabled" = 't' LIMIT 1
- D, [2015-01-31T05:35:56.262512 #32680] DEBUG -- : CACHE (0.0ms) SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."versioned_id" IS NULL AND "color_schemes"."enabled" = 't' LIMIT 1
- D, [2015-01-31T05:35:56.310402 #32680] DEBUG -- : CACHE (0.0ms) SELECT "color_schemes".* FROM "color_schemes" WHERE "color_schemes"."versioned_id" IS NULL AND "color_schemes"."enabled" = 't' LIMIT 1
- D, [2015-01-31T05:35:56.813227 #32680] DEBUG -- : Category Load (1.2ms) SELECT "categories".* FROM "categories" WHERE (background_url IS NOT NULL)
- D, [2015-01-31T05:35:57.284314 #32680] DEBUG -- : (1.2ms) SELECT "site_customizations"."stylesheet_baked" FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- I, [2015-01-31T05:35:57.326899 #32680] INFO -- : Rendered common/_discourse_stylesheet.html.erb (1448.0ms)
- D, [2015-01-31T05:36:01.658466 #32680] DEBUG -- : CACHE (0.0ms) SELECT "site_customizations".* FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- D, [2015-01-31T05:36:01.739740 #32680] DEBUG -- : CACHE (0.0ms) SELECT "site_customizations".* FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- I, [2015-01-31T05:36:01.795497 #32680] INFO -- : Rendered common/_discourse_javascript.html.erb (53.6ms)
- D, [2015-01-31T05:36:01.797162 #32680] DEBUG -- : CACHE (0.0ms) SELECT "site_customizations".* FROM "site_customizations" WHERE "site_customizations"."enabled" = 't' ORDER BY "site_customizations"."name" ASC
- I, [2015-01-31T05:36:01.798727 #32680] INFO -- : Completed 200 OK in 7143ms (Views: 5958.4ms | ActiveRecord: 262.4ms)
- D, [2015-01-31T05:36:37.383226 #32680] DEBUG -- :
- D, [2015-01-31T05:36:37.383311 #32680] DEBUG -- :
- I, [2015-01-31T05:36:37.383519 #32680] INFO -- : Started GET "/t/117/37.json?track_visit=true&_=1422711362557" for 127.0.0.1 at 2015-01-31 05:36:37 -0800
- I, [2015-01-31T05:36:37.424089 #32680] INFO -- : Processing by TopicsController#show as JSON
- I, [2015-01-31T05:36:37.425208 #32680] INFO -- : Parameters: {"track_visit"=>"true", "_"=>"1422711362557", "topic_id"=>"117", "post_number"=>"37"}
- D, [2015-01-31T05:36:37.428292 #32680] DEBUG -- : User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:36:37.434270 #32680] DEBUG -- : Topic Load (1.4ms) SELECT "topics".* FROM "topics" WHERE "topics"."id" = 117 ORDER BY "topics"."id" ASC LIMIT 1
- D, [2015-01-31T05:36:37.437963 #32680] DEBUG -- : Category Load (1.2ms) SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (5)
- D, [2015-01-31T05:36:37.506582 #32680] DEBUG -- : Post Exists (54.2ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = $1 AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1 [["topic_id", 117]]
- D, [2015-01-31T05:36:37.546865 #32680] DEBUG -- : (37.9ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = $1 AND (deleted_at IS NULL OR post_number = 1) ORDER BY @(post_number - 37) [["topic_id", 117]]
- D, [2015-01-31T05:36:37.549838 #32680] DEBUG -- : (0.8ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = $1 AND (deleted_at IS NULL OR post_number = 1) ORDER BY "posts"."sort_order" ASC [["topic_id", 117]]
- D, [2015-01-31T05:36:37.552348 #32680] DEBUG -- : (0.9ms) select sequence from draft_sequences where user_id = 35548 and draft_key = 'topic_117'
- D, [2015-01-31T05:36:37.557609 #32680] DEBUG -- : (0.1ms) BEGIN
- D, [2015-01-31T05:36:37.560146 #32680] DEBUG -- : Draft Load (1.2ms) SELECT "drafts".* FROM "drafts" WHERE "drafts"."user_id" = 35548 AND "drafts"."draft_key" = 'topic_117' LIMIT 1
- D, [2015-01-31T05:36:37.591933 #32680] DEBUG -- : (15.1ms) INSERT INTO topic_views (topic_id, ip_address, viewed_at, user_id)
- SELECT 117, '127.0.0.1', '2015-01-31', 35548
- WHERE NOT EXISTS (
- SELECT 1 FROM topic_views
- WHERE (user_id = 35548 AND topic_id = 117)
- )
- D, [2015-01-31T05:36:37.593022 #32680] DEBUG -- : (0.2ms) COMMIT
- D, [2015-01-31T05:36:37.599843 #32680] DEBUG -- : SQL (5.8ms) UPDATE "topic_users" SET "last_visited_at" = '2015-01-31 13:36:37.593467' WHERE "topic_users"."topic_id" = 117 AND "topic_users"."user_id" = 117
- D, [2015-01-31T05:36:37.600790 #32680] DEBUG -- : TopicUser Load (0.2ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" = 117 AND "topic_users"."user_id" = 117
- D, [2015-01-31T05:36:37.602978 #32680] DEBUG -- : Post Load (20.1ms) SELECT "posts".* FROM "posts" WHERE "posts"."id" IN (7917, 7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7927, 7928, 7930, 7931, 7932, 7934, 7937, 95419, 95420, 95421) AND "posts"."topic_id" = 117 ORDER BY sort_order
- D, [2015-01-31T05:36:37.635357 #32680] DEBUG -- : User Load (11.9ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (52, 193, 5261, 361, 5262, 1539, 3162, 5263, 5264, 5265, 1878, 528, 5267, 5268, 150, 5270, 5272, 35548)
- D, [2015-01-31T05:36:37.642285 #32680] DEBUG -- : User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (1878, 35548, 5259)
- D, [2015-01-31T05:36:37.653473 #32680] DEBUG -- : (1.0ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = 't'
- D, [2015-01-31T05:36:37.905904 #32680] DEBUG -- : (251.2ms) SELECT
- l.post_id,
- l.url,
- l.clicks,
- COALESCE(t.title, l.title) AS title,
- l.internal,
- l.reflection,
- l.domain
- FROM topic_links l
- LEFT JOIN topics t ON t.id = l.link_topic_id
- LEFT JOIN categories AS c ON c.id = t.category_id
- WHERE (t.deleted_at IS NULL) AND (COALESCE(t.archetype, 'regular') <> 'private_message') AND (l.post_id IN (7917,7918,7919,7920,7921,7922,7923,7924,7925,7926,7927,7928,7930,7931,7932,7934,7937,95419,95420,95421)) AND (NOT COALESCE(c.read_restricted, false) OR c.id IN (2,4))
- ORDER BY reflection ASC, clicks DESC
- D, [2015-01-31T05:36:37.914412 #32680] DEBUG -- : TopicUser Load (0.8ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" = $1 AND "topic_users"."user_id" = 35548 LIMIT 1 [["topic_id", 117]]
- D, [2015-01-31T05:36:37.923102 #32680] DEBUG -- : (1.4ms) SELECT "posts"."post_number" FROM "posts" LEFT OUTER JOIN "users" ON "users"."id" = "posts"."user_id" LEFT OUTER JOIN "users" "reply_to_users_posts" ON "reply_to_users_posts"."id" = "posts"."reply_to_user_id" WHERE "posts"."id" IN (7917, 7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7927, 7928, 7930, 7931, 7932, 7934, 7937, 95419, 95420, 95421) AND "posts"."topic_id" = 117 ORDER BY sort_order
- D, [2015-01-31T05:36:37.933951 #32680] DEBUG -- : (4.5ms) SELECT "post_timings"."post_number" FROM "post_timings" WHERE "post_timings"."topic_id" = 117 AND "post_timings"."user_id" = 35548 AND "post_timings"."post_number" IN (9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 22, 23, 24, 26, 29, 35, 36, 37)
- D, [2015-01-31T05:36:37.937652 #32680] DEBUG -- : PostAction Load (1.4ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_id" IN (7917, 7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7927, 7928, 7930, 7931, 7932, 7934, 7937, 95419, 95420, 95421) AND "post_actions"."user_id" = 35548
- D, [2015-01-31T05:36:37.940759 #32680] DEBUG -- : PostAction Load (1.2ms) SELECT "post_actions".* FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."disagreed_at" IS NULL AND "post_actions"."deferred_at" IS NULL AND "post_actions"."agreed_at" IS NULL AND "post_actions"."deleted_at" IS NULL AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8) AND "post_actions"."post_id" IN (7917, 7918, 7919, 7920, 7921, 7922, 7923, 7924, 7925, 7926, 7927, 7928, 7930, 7931, 7932, 7934, 7937, 95419, 95420, 95421)
- D, [2015-01-31T05:36:37.958591 #32680] DEBUG -- : (0.9ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = $1 ORDER BY "posts"."sort_order" ASC [["topic_id", 117]]
- D, [2015-01-31T05:36:37.960309 #32680] DEBUG -- : CACHE (0.0ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."topic_id" = $1 ORDER BY "posts"."sort_order" ASC [["topic_id", 117]]
- D, [2015-01-31T05:36:37.965910 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]]
- D, [2015-01-31T05:36:37.971519 #32680] DEBUG -- : User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 35548]]
- D, [2015-01-31T05:36:38.035436 #32680] DEBUG -- : User Load (14.0ms) SELECT "users".* FROM "users" INNER JOIN "topic_allowed_users" ON "users"."id" = "topic_allowed_users"."user_id" WHERE "topic_allowed_users"."topic_id" = $1 [["topic_id", 117]]
- D, [2015-01-31T05:36:38.046970 #32680] DEBUG -- : Group Load (1.0ms) SELECT "groups".* FROM "groups" INNER JOIN "topic_allowed_groups" ON "groups"."id" = "topic_allowed_groups"."group_id" WHERE "topic_allowed_groups"."topic_id" = $1 [["topic_id", 117]]
- D, [2015-01-31T05:36:38.050014 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) AS count_all, user_id AS user_id FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND "posts"."topic_id" = 117 AND (user_id IS NOT NULL) GROUP BY user_id ORDER BY count_all DESC LIMIT 24
- D, [2015-01-31T05:36:38.053846 #32680] DEBUG -- : User Load (1.6ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (35548, 5264, 5267, 3162, 1878, 5260, 1, 1281, 361, 5265, 5263, 5270, 5257, 4217, 5258, 5261, 193, 1539, 3093, 5268, 150, 5272, 528, 52)
- D, [2015-01-31T05:36:38.057464 #32680] DEBUG -- : (0.9ms) SELECT "categories"."topic_id" FROM "categories"
- D, [2015-01-31T05:36:38.064687 #32680] DEBUG -- : Topic Load (5.2ms) SELECT "topics".* FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 35548) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (tu.last_read_post_number < topics.highest_post_number) AND (COALESCE(tu.notification_level, 1) >= 2) AND (topics.id NOT IN (117)) AND "topics"."visible" = 't' ORDER BY CASE WHEN topics.user_id = tu.user_id THEN 1 ELSE 2 END, CASE WHEN topics.category_id = 5 THEN 0 ELSE 1 END, CASE
- WHEN topics.pinned_globally
- AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
- THEN topics.pinned_at + interval '9999 years'
- ELSE topics.bumped_at
- END DESC LIMIT 5
- D, [2015-01-31T05:36:38.067429 #32680] DEBUG -- : CACHE (0.0ms) SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (5)
- D, [2015-01-31T05:36:38.070264 #32680] DEBUG -- : UserStat Load (0.9ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:36:38.077564 #32680] DEBUG -- : SQL (3.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"."off_topic_count" AS t0_r17, "topics"."like_count" AS t0_r18, "topics"."incoming_link_count" AS t0_r19, "topics"."bookmark_count" AS t0_r20, "topics"."category_id" AS t0_r21, "topics"."visible" AS t0_r22, "topics"."moderator_posts_count" AS t0_r23, "topics"."closed" AS t0_r24, "topics"."archived" AS t0_r25, "topics"."bumped_at" AS t0_r26, "topics"."has_summary" AS t0_r27, "topics"."vote_count" AS t0_r28, "topics"."archetype" AS t0_r29, "topics"."featured_user4_id" AS t0_r30, "topics"."notify_moderators_count" AS t0_r31, "topics"."spam_count" AS t0_r32, "topics"."illegal_count" AS t0_r33, "topics"."inappropriate_count" AS t0_r34, "topics"."pinned_at" AS t0_r35, "topics"."score" AS t0_r36, "topics"."percent_rank" AS t0_r37, "topics"."notify_user_count" AS t0_r38, "topics"."subtype" AS t0_r39, "topics"."slug" AS t0_r40, "topics"."auto_close_at" AS t0_r41, "topics"."auto_close_user_id" AS t0_r42, "topics"."auto_close_started_at" AS t0_r43, "topics"."deleted_by_id" AS t0_r44, "topics"."participant_count" AS t0_r45, "topics"."word_count" AS t0_r46, "topics"."excerpt" AS t0_r47, "topics"."pinned_globally" AS t0_r48, "topics"."auto_close_based_on_last_post" AS t0_r49, "topics"."auto_close_hours" AS t0_r50, "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"."logo_url" AS t1_r28, "categories"."background_url" AS t1_r29, "categories"."allow_badges" AS t1_r30, "categories"."name_lower" AS t1_r31, "categories"."auto_close_based_on_last_post" AS t1_r32 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 = 35548) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND (topics.created_at >= '2015-01-29 13:36:38.068929') AND (tu.last_read_post_number IS NULL) AND (COALESCE(tu.notification_level, 2) >= 2) AND (NOT EXISTS(
- SELECT 1 FROM category_users cu
- WHERE cu.user_id = 35548 AND
- cu.category_id = topics.category_id AND
- cu.notification_level = 0 AND
- cu.category_id <> -1
- )) AND (topics.id NOT IN (117,612,210)) AND "topics"."visible" = 't' ORDER BY CASE WHEN topics.category_id = 5 THEN 0 ELSE 1 END, CASE
- WHEN topics.pinned_globally
- AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
- THEN topics.pinned_at + interval '9999 years'
- ELSE topics.bumped_at
- END DESC LIMIT 3
- D, [2015-01-31T05:36:38.080384 #32680] DEBUG -- : CACHE (0.0ms) SELECT "categories"."topic_id" FROM "categories"
- D, [2015-01-31T05:36:38.108736 #32680] DEBUG -- : SQL (6.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"."off_topic_count" AS t0_r17, "topics"."like_count" AS t0_r18, "topics"."incoming_link_count" AS t0_r19, "topics"."bookmark_count" AS t0_r20, "topics"."category_id" AS t0_r21, "topics"."visible" AS t0_r22, "topics"."moderator_posts_count" AS t0_r23, "topics"."closed" AS t0_r24, "topics"."archived" AS t0_r25, "topics"."bumped_at" AS t0_r26, "topics"."has_summary" AS t0_r27, "topics"."vote_count" AS t0_r28, "topics"."archetype" AS t0_r29, "topics"."featured_user4_id" AS t0_r30, "topics"."notify_moderators_count" AS t0_r31, "topics"."spam_count" AS t0_r32, "topics"."illegal_count" AS t0_r33, "topics"."inappropriate_count" AS t0_r34, "topics"."pinned_at" AS t0_r35, "topics"."score" AS t0_r36, "topics"."percent_rank" AS t0_r37, "topics"."notify_user_count" AS t0_r38, "topics"."subtype" AS t0_r39, "topics"."slug" AS t0_r40, "topics"."auto_close_at" AS t0_r41, "topics"."auto_close_user_id" AS t0_r42, "topics"."auto_close_started_at" AS t0_r43, "topics"."deleted_by_id" AS t0_r44, "topics"."participant_count" AS t0_r45, "topics"."word_count" AS t0_r46, "topics"."excerpt" AS t0_r47, "topics"."pinned_globally" AS t0_r48, "topics"."auto_close_based_on_last_post" AS t0_r49, "topics"."auto_close_hours" AS t0_r50, "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"."logo_url" AS t1_r28, "categories"."background_url" AS t1_r29, "categories"."allow_badges" AS t1_r30, "categories"."name_lower" AS t1_r31, "categories"."auto_close_based_on_last_post" AS t1_r32 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 = 35548) WHERE (topics.archetype <> 'private_message') AND (topics.deleted_at IS NULL) AND "topics"."closed" = 'f' AND "topics"."archived" = 'f' AND (topics.id NOT IN (117,612,210,1,2,3,2124,1389)) AND (NOT EXISTS(
- SELECT 1 FROM category_users cu
- WHERE cu.user_id = 35548 AND
- cu.category_id = topics.category_id AND
- cu.notification_level = 0 AND
- cu.category_id <> -1
- )) AND (topics.id NOT IN (117,612,210)) AND "topics"."visible" = 't' ORDER BY CASE WHEN topics.category_id = 5 THEN 0 ELSE 1 END, RANDOM() LIMIT 3
- D, [2015-01-31T05:36:38.112654 #32680] DEBUG -- : TopicUser Load (1.1ms) SELECT "topic_users".* FROM "topic_users" WHERE "topic_users"."topic_id" IN (612, 210, 202, 332, 646) AND "topic_users"."user_id" = 35548
- D, [2015-01-31T05:36:38.145845 #32680] DEBUG -- : User Load (31.3ms) SELECT "users"."id", "users"."email", "users"."username", "users"."uploaded_avatar_id" FROM "users" WHERE "users"."id" IN (1, 36208, 3014, 3891, 543, 7953, 11796, 2175, 11766, 11772, 1139, 11273, 10325, 409, 5757, 7667, 5893, 3891, 320, 688, 1035, 513, 6161, 8419, 299, 6667)
- D, [2015-01-31T05:36:38.249941 #32680] DEBUG -- : (100.3ms) SELECT ftl.url,
- COALESCE(ft.title, ftl.title) AS title,
- ftl.link_topic_id,
- ftl.reflection,
- ftl.internal,
- ftl.domain,
- MIN(ftl.user_id) AS user_id,
- SUM(clicks) AS clicks
- FROM topic_links AS ftl
- LEFT JOIN topics AS ft ON ftl.link_topic_id = ft.id
- LEFT JOIN categories AS c ON c.id = ft.category_id
- WHERE (ftl.topic_id = 117) AND (ft.deleted_at IS NULL) AND (COALESCE(ft.archetype, 'regular') <> 'private_message') AND (NOT COALESCE(c.read_restricted, false) OR c.id IN (2,4))
- GROUP BY ftl.url, ft.title, ftl.title, ftl.link_topic_id, ftl.reflection, ftl.internal, ftl.domain
- ORDER BY clicks DESC
- D, [2015-01-31T05:36:38.255148 #32680] DEBUG -- : Category Exists (1.0ms) SELECT 1 AS one FROM "categories" WHERE "categories"."topic_id" = 117 LIMIT 1
- D, [2015-01-31T05:36:38.259724 #32680] DEBUG -- : (1.0ms) SELECT MAX("posts"."post_number") AS max_id FROM "posts" WHERE "posts"."topic_id" = $1 AND (deleted_at IS NULL OR post_number = 1) [["topic_id", 117]]
- D, [2015-01-31T05:36:38.264136 #32680] DEBUG -- : CACHE (0.0ms) SELECT 1 AS one FROM "posts" WHERE "posts"."topic_id" = $1 AND (posts.deleted_at IS NOT NULL) AND (posts.post_number > 1) LIMIT 1 [["topic_id", 117]]
- D, [2015-01-31T05:36:38.281754 #32680] DEBUG -- : TopicEmbed Exists (1.1ms) SELECT 1 AS one FROM "topic_embeds" WHERE "topic_embeds"."topic_id" = 117 LIMIT 1
- I, [2015-01-31T05:36:38.289730 #32680] INFO -- : Completed 200 OK in 864ms (Views: 0.2ms | ActiveRecord: 589.3ms)
- D, [2015-01-31T05:36:43.774509 #32680] DEBUG -- :
- D, [2015-01-31T05:36:43.774588 #32680] DEBUG -- :
- I, [2015-01-31T05:36:43.774728 #32680] INFO -- : Started GET "/about.json?_=1422711362558" for 127.0.0.1 at 2015-01-31 05:36:43 -0800
- I, [2015-01-31T05:36:43.813148 #32680] INFO -- : Processing by AboutController#index as JSON
- I, [2015-01-31T05:36:43.814199 #32680] INFO -- : Parameters: {"_"=>"1422711362558"}
- D, [2015-01-31T05:36:43.816625 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:36:43.823348 #32680] DEBUG -- : (1.6ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message')
- D, [2015-01-31T05:36:48.558202 #32680] DEBUG -- : (4733.2ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL)
- D, [2015-01-31T05:36:48.658111 #32680] DEBUG -- : (98.5ms) SELECT COUNT(*) FROM "users"
- D, [2015-01-31T05:36:48.662104 #32680] DEBUG -- : (1.7ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (created_at > '2015-01-24 13:36:48.659882')
- D, [2015-01-31T05:36:48.664799 #32680] DEBUG -- : (0.9ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND (created_at > '2015-01-24 13:36:48.663293')
- D, [2015-01-31T05:36:49.209875 #32680] DEBUG -- : (543.7ms) SELECT COUNT(*) FROM "users" WHERE (created_at > '2015-01-24 13:36:48.665697')
- D, [2015-01-31T05:36:49.212598 #32680] DEBUG -- : (0.9ms) SELECT COUNT(*) FROM "users" WHERE (last_seen_at > '2015-01-24 13:36:49.211147')
- D, [2015-01-31T05:36:49.311384 #32680] DEBUG -- : (80.7ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1
- D, [2015-01-31T05:36:49.314585 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1 AND (created_at > '2015-01-24 13:36:49.312757')
- D, [2015-01-31T05:36:49.325641 #32680] DEBUG -- : User Load (8.4ms) SELECT "users".* FROM "users" WHERE "users"."moderator" = 't' AND "users"."admin" = 'f' AND ("users"."id" != -1)
- D, [2015-01-31T05:36:49.348295 #32680] DEBUG -- : User Load (6.3ms) SELECT "users".* FROM "users" WHERE "users"."admin" = 't' AND ("users"."id" != -1)
- I, [2015-01-31T05:36:49.350744 #32680] INFO -- : Completed 200 OK in 5536ms (Views: 0.1ms | ActiveRecord: 5481.5ms)
- D, [2015-01-31T05:36:58.899437 #32680] DEBUG -- :
- D, [2015-01-31T05:36:58.899537 #32680] DEBUG -- :
- I, [2015-01-31T05:36:58.899728 #32680] INFO -- : Started GET "/badges.json?only_listable=true&_=1422711362559" for 127.0.0.1 at 2015-01-31 05:36:58 -0800
- I, [2015-01-31T05:36:58.938155 #32680] INFO -- : Processing by BadgesController#index as JSON
- I, [2015-01-31T05:36:58.939102 #32680] INFO -- : Parameters: {"only_listable"=>"true", "_"=>"1422711362559"}
- D, [2015-01-31T05:36:58.941495 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:36:58.949690 #32680] DEBUG -- : UserVisit Load (0.9ms) SELECT "user_visits".* FROM "user_visits" WHERE "user_visits"."user_id" = $1 AND "user_visits"."visited_at" = '2015-01-31' LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:36:58.953138 #32680] DEBUG -- : Badge Load (1.6ms) SELECT "badges".* FROM "badges" WHERE "badges"."enabled" = 't' AND "badges"."listable" = 't'
- D, [2015-01-31T05:36:58.954877 #32680] DEBUG -- : SQL (2.4ms) UPDATE "users" SET "last_seen_at" = '2015-01-31 13:36:58.943044' WHERE "users"."id" = 35548
- D, [2015-01-31T05:36:58.972553 #32680] DEBUG -- : BadgeGrouping Load (0.9ms) SELECT "badge_groupings".* FROM "badge_groupings" WHERE "badge_groupings"."id" IN (4, 1, 3, 2)
- D, [2015-01-31T05:36:59.066935 #32680] DEBUG -- : (80.4ms) SELECT "user_badges"."badge_id" FROM "user_badges" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) [["user_id", 35548]]
- D, [2015-01-31T05:36:59.080586 #32680] DEBUG -- : BadgeType Load (0.7ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.086619 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.088747 #32680] DEBUG -- : BadgeType Load (0.7ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 2]]
- D, [2015-01-31T05:36:59.090780 #32680] DEBUG -- : BadgeType Load (0.7ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 1]]
- D, [2015-01-31T05:36:59.092289 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.093637 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 2]]
- D, [2015-01-31T05:36:59.094939 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 1]]
- D, [2015-01-31T05:36:59.096160 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.097396 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 2]]
- D, [2015-01-31T05:36:59.098590 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 1]]
- D, [2015-01-31T05:36:59.099728 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.100858 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.102091 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.103352 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.104615 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.105903 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.107080 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.108827 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 2]]
- D, [2015-01-31T05:36:59.110214 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 1]]
- D, [2015-01-31T05:36:59.111348 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.112460 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.113586 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- D, [2015-01-31T05:36:59.114707 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" = $1 LIMIT 1 [["id", 3]]
- I, [2015-01-31T05:36:59.115948 #32680] INFO -- : Completed 200 OK in 176ms (Views: 0.1ms | ActiveRecord: 100.5ms)
- D, [2015-01-31T05:37:03.051384 #32680] DEBUG -- :
- D, [2015-01-31T05:37:03.051512 #32680] DEBUG -- :
- I, [2015-01-31T05:37:03.051725 #32680] INFO -- : Started GET "/users/riking.json?_=1422711362560" for 127.0.0.1 at 2015-01-31 05:37:03 -0800
- I, [2015-01-31T05:37:03.098858 #32680] INFO -- : Processing by UsersController#show as JSON
- I, [2015-01-31T05:37:03.099857 #32680] INFO -- : Parameters: {"_"=>"1422711362560", "username"=>"riking"}
- D, [2015-01-31T05:37:03.103578 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:37:03.107847 #32680] DEBUG -- : User Load (1.5ms) SELECT "users".* FROM "users" WHERE "users"."username_lower" = 'riking' AND "users"."active" = 't' LIMIT 1
- D, [2015-01-31T05:37:03.116728 #32680] DEBUG -- : UserProfile Load (0.7ms) SELECT "user_profiles".* FROM "user_profiles" WHERE "user_profiles"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.339487 #32680] DEBUG -- : UserAction Load (221.3ms)
- SELECT action_type, COUNT(*) count
- FROM user_actions a
- JOIN topics t ON t.id = a.target_topic_id
- LEFT JOIN posts p on p.id = a.target_post_id
- JOIN posts p2 on p2.topic_id = a.target_topic_id and p2.post_number = 1
- LEFT JOIN categories c ON c.id = t.category_id
- WHERE (a.user_id = 35548) AND (t.deleted_at is null)
- GROUP BY action_type
- D, [2015-01-31T05:37:03.345160 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
- D, [2015-01-31T05:37:03.350072 #32680] DEBUG -- : (0.7ms) SELECT COUNT(distinct badge_id) FROM "user_badges" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) [["user_id", 35548]]
- D, [2015-01-31T05:37:03.352284 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "notifications" WHERE "notifications"."user_id" = 35548
- D, [2015-01-31T05:37:03.360535 #32680] DEBUG -- : (0.7ms) SELECT COUNT(*) FROM "badges" INNER JOIN "user_badges" ON "badges"."id" = "user_badges"."badge_id" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) AND "badges"."allow_title" = 't' [["user_id", 35548]]
- D, [2015-01-31T05:37:03.366498 #32680] DEBUG -- : (0.9ms) SELECT "user_fields"."id" FROM "user_fields"
- D, [2015-01-31T05:37:03.368838 #32680] DEBUG -- : UserStat Load (0.7ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.371581 #32680] DEBUG -- : (1.0ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 35548 AND "category_users"."notification_level" = 0
- D, [2015-01-31T05:37:03.374025 #32680] DEBUG -- : (0.8ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 35548 AND "category_users"."notification_level" = 2
- D, [2015-01-31T05:37:03.375886 #32680] DEBUG -- : (0.7ms) SELECT "category_users"."category_id" FROM "category_users" WHERE "category_users"."user_id" = 35548 AND "category_users"."notification_level" = 3
- D, [2015-01-31T05:37:03.389604 #32680] DEBUG -- : (12.0ms) SELECT COUNT(*) FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 35548) WHERE ("topics"."deleted_at" IS NULL) AND (topics.id IN (SELECT topic_id FROM topic_allowed_users WHERE user_id = 35548)) AND "topics"."archetype" = 'private_message'
- D, [2015-01-31T05:37:03.392595 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 35548) WHERE ("topics"."deleted_at" IS NULL) AND (topics.id IN (SELECT topic_id FROM topic_allowed_users WHERE user_id = 35548)) AND "topics"."archetype" = 'private_message' AND "topics"."user_id" = 35548
- D, [2015-01-31T05:37:03.395195 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "topics" LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = 35548) WHERE ("topics"."deleted_at" IS NULL) AND (topics.id IN (SELECT topic_id FROM topic_allowed_users WHERE user_id = 35548)) AND "topics"."archetype" = 'private_message' AND (tu.last_read_post_number IS NULL OR tu.last_read_post_number < topics.highest_post_number)
- D, [2015-01-31T05:37:03.397169 #32680] DEBUG -- : UserAvatar Load (0.7ms) SELECT "user_avatars".* FROM "user_avatars" WHERE "user_avatars"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.435161 #32680] DEBUG -- : Invite Load (22.2ms) SELECT "invites".* FROM "invites" WHERE ("invites"."deleted_at" IS NULL) AND "invites"."user_id" = $1 AND (redeemed_at is not null) ORDER BY "invites"."id" ASC LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.441097 #32680] DEBUG -- : Group Load (0.7ms) SELECT "groups".* FROM "groups" INNER JOIN "group_users" ON "groups"."id" = "group_users"."group_id" WHERE "group_users"."user_id" = $1 AND "groups"."automatic" = 'f' AND "groups"."visible" = 't' [["user_id", 35548]]
- D, [2015-01-31T05:37:03.490450 #32680] DEBUG -- : UserBadge Load (1.4ms) SELECT "user_badges".* FROM "user_badges" INNER JOIN "badges" ON "badges"."id" = "user_badges"."badge_id" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) AND (user_badges.id in (select min(u2.id)
- from user_badges u2 where u2.user_id = 35548 group by u2.badge_id)) ORDER BY CASE WHEN badges.id = (SELECT MAX(ub2.badge_id) FROM user_badges ub2
- WHERE ub2.badge_id IN (1,2,3,4) AND
- ub2.user_id = 35548) THEN 1 ELSE 0 END DESC, badges.badge_type_id ASC, badges.grant_count ASC LIMIT 3 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.499236 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (35548)
- D, [2015-01-31T05:37:03.504645 #32680] DEBUG -- : User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (-1)
- D, [2015-01-31T05:37:03.512946 #32680] DEBUG -- : Badge Load (1.1ms) SELECT "badges".* FROM "badges" WHERE "badges"."id" IN (4, 3, 17)
- D, [2015-01-31T05:37:03.516916 #32680] DEBUG -- : BadgeType Load (0.9ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" IN (2, 1, 3)
- D, [2015-01-31T05:37:03.518829 #32680] DEBUG -- : CACHE (0.0ms) SELECT "user_badges".* FROM "user_badges" INNER JOIN "badges" ON "badges"."id" = "user_badges"."badge_id" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) AND (user_badges.id in (select min(u2.id)
- from user_badges u2 where u2.user_id = 35548 group by u2.badge_id)) ORDER BY CASE WHEN badges.id = (SELECT MAX(ub2.badge_id) FROM user_badges ub2
- WHERE ub2.badge_id IN (1,2,3,4) AND
- ub2.user_id = 35548) THEN 1 ELSE 0 END DESC, badges.badge_type_id ASC, badges.grant_count ASC LIMIT 3 [["user_id", 35548]]
- D, [2015-01-31T05:37:03.520104 #32680] DEBUG -- : CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (35548)
- D, [2015-01-31T05:37:03.582175 #32680] DEBUG -- : CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (-1)
- D, [2015-01-31T05:37:03.583846 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badges".* FROM "badges" WHERE "badges"."id" IN (4, 3, 17)
- D, [2015-01-31T05:37:03.585263 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badge_types".* FROM "badge_types" WHERE "badge_types"."id" IN (2, 1, 3)
- I, [2015-01-31T05:37:03.590214 #32680] INFO -- : Completed 200 OK in 488ms (Views: 0.2ms | ActiveRecord: 288.4ms)
- D, [2015-01-31T05:37:03.600585 #32680] DEBUG -- :
- D, [2015-01-31T05:37:03.600648 #32680] DEBUG -- :
- I, [2015-01-31T05:37:03.600782 #32680] INFO -- : Started GET "/users/riking/staff-info.json?_=1422711362561" for 127.0.0.1 at 2015-01-31 05:37:03 -0800
- I, [2015-01-31T05:37:03.627537 #32680] INFO -- : Processing by UsersController#staff_info as JSON
- I, [2015-01-31T05:37:03.628333 #32680] INFO -- : Parameters: {"_"=>"1422711362561", "username"=>"riking"}
- D, [2015-01-31T05:37:03.630292 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:37:03.633083 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."username_lower" = 'riking' AND "users"."active" = 't' LIMIT 1
- D, [2015-01-31T05:37:03.639990 #32680] DEBUG -- : (1.8ms) SELECT COUNT(*) FROM "posts" WHERE "posts"."user_id" = 35548 AND "posts"."user_deleted" = 'f' AND ("posts"."deleted_by_id" != 35548) AND ("posts"."deleted_at" IS NOT NULL)
- D, [2015-01-31T05:37:03.647801 #32680] DEBUG -- : (2.0ms) SELECT COUNT(*) FROM "posts" WHERE "posts"."user_id" = 35548 AND "posts"."id" IN (SELECT "post_actions"."post_id" FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8) AND "post_actions"."disagreed_at" IS NULL)
- D, [2015-01-31T05:37:03.650110 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."user_id" = 35548 AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8)
- D, [2015-01-31T05:37:03.659893 #32680] DEBUG -- : (2.5ms) SELECT COUNT(*) FROM "user_histories" WHERE "user_histories"."target_user_id" = 35548 AND "user_histories"."action" = 10
- D, [2015-01-31T05:37:03.669764 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "warnings" WHERE "warnings"."user_id" = $1 [["user_id", 35548]]
- I, [2015-01-31T05:37:03.671355 #32680] INFO -- : Completed 200 OK in 42ms (Views: 0.3ms | ActiveRecord: 21.3ms)
- D, [2015-01-31T05:37:03.684950 #32680] DEBUG -- :
- D, [2015-01-31T05:37:03.685026 #32680] DEBUG -- :
- I, [2015-01-31T05:37:03.685272 #32680] INFO -- : Started GET "/user_actions.json?offset=0&username=riking&filter=4,5&_=1422711362562" for 127.0.0.1 at 2015-01-31 05:37:03 -0800
- I, [2015-01-31T05:37:03.723117 #32680] INFO -- : Processing by UserActionsController#index as JSON
- I, [2015-01-31T05:37:03.724139 #32680] INFO -- : Parameters: {"offset"=>"0", "username"=>"riking", "filter"=>"4,5", "_"=>"1422711362562"}
- D, [2015-01-31T05:37:03.726514 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:37:03.728222 #32680] DEBUG -- : Unpermitted parameters: username, _, format
- D, [2015-01-31T05:37:03.730840 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."username_lower" = 'riking' AND "users"."active" = 't' LIMIT 1
- D, [2015-01-31T05:37:03.859960 #32680] DEBUG -- : (127.7ms)
- SELECT
- a.id,
- t.title, a.action_type, a.created_at, t.id topic_id,
- a.user_id AS target_user_id, au.name AS target_name, au.username AS target_username,
- coalesce(p.post_number, 1) post_number, p.id as post_id,
- p.reply_to_post_number,
- pu.email, pu.username, pu.name, pu.id user_id,
- pu.uploaded_avatar_id,
- u.email acting_email, u.username acting_username, u.name acting_name, u.id acting_user_id,
- u.uploaded_avatar_id acting_uploaded_avatar_id,
- coalesce(p.cooked, p2.cooked) cooked,
- CASE WHEN coalesce(p.deleted_at, p2.deleted_at, t.deleted_at) IS NULL THEN false ELSE true END deleted,
- p.hidden,
- p.post_type,
- p.edit_reason,
- t.category_id
- FROM user_actions as a
- JOIN topics t on t.id = a.target_topic_id
- LEFT JOIN posts p on p.id = a.target_post_id
- JOIN posts p2 on p2.topic_id = a.target_topic_id and p2.post_number = 1
- JOIN users u on u.id = a.acting_user_id
- JOIN users pu on pu.id = COALESCE(p.user_id, t.user_id)
- JOIN users au on au.id = a.user_id
- LEFT JOIN categories c on c.id = t.category_id
- WHERE (t.deleted_at is null) AND (a.user_id = 35548) AND (a.action_type in (4,5))
- ORDER BY a.created_at desc
- OFFSET 0
- LIMIT 60
- I, [2015-01-31T05:37:03.976200 #32680] INFO -- : Completed 200 OK in 251ms (Views: 0.1ms | ActiveRecord: 129.7ms)
- D, [2015-01-31T05:37:03.978692 #32680] DEBUG -- :
- D, [2015-01-31T05:37:03.978775 #32680] DEBUG -- :
- I, [2015-01-31T05:37:03.978937 #32680] INFO -- : Started GET "/draft.json?draft_key=new_private_message&_=1422711362563" for 127.0.0.1 at 2015-01-31 05:37:03 -0800
- I, [2015-01-31T05:37:04.011655 #32680] INFO -- : Processing by DraftController#show as JSON
- I, [2015-01-31T05:37:04.012483 #32680] INFO -- : Parameters: {"draft_key"=>"new_private_message", "_"=>"1422711362563"}
- D, [2015-01-31T05:37:04.014494 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- D, [2015-01-31T05:37:04.027875 #32680] DEBUG -- : (11.9ms) select sequence from draft_sequences where user_id = 35548 and draft_key = 'new_private_message'
- D, [2015-01-31T05:37:04.030234 #32680] DEBUG -- : Draft Load (0.8ms) SELECT "drafts".* FROM "drafts" WHERE "drafts"."user_id" = 35548 AND "drafts"."draft_key" = 'new_private_message' LIMIT 1
- I, [2015-01-31T05:37:04.031311 #32680] INFO -- : Completed 200 OK in 18ms (Views: 0.2ms | ActiveRecord: 13.6ms)
- D, [2015-01-31T05:37:07.323513 #32680] DEBUG -- :
- D, [2015-01-31T05:37:07.323611 #32680] DEBUG -- :
- I, [2015-01-31T05:37:07.323789 #32680] INFO -- : Started GET "/admin/users/riking.json?_=1422711362564" for 127.0.0.1 at 2015-01-31 05:37:07 -0800
- D, [2015-01-31T05:37:07.353667 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- I, [2015-01-31T05:37:07.370741 #32680] INFO -- : Processing by Admin::UsersController#show as JSON
- I, [2015-01-31T05:37:07.372097 #32680] INFO -- : Parameters: {"_"=>"1422711362564", "id"=>"riking"}
- D, [2015-01-31T05:37:07.374849 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."username_lower" = 'riking' LIMIT 1
- D, [2015-01-31T05:37:07.388288 #32680] DEBUG -- : UserStat Load (1.3ms) SELECT "user_stats".* FROM "user_stats" WHERE "user_stats"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.441415 #32680] DEBUG -- : TwitterUserInfo Load (42.2ms) SELECT "twitter_user_infos".* FROM "twitter_user_infos" WHERE "twitter_user_infos"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.474947 #32680] DEBUG -- : FacebookUserInfo Load (22.9ms) SELECT "facebook_user_infos".* FROM "facebook_user_infos" WHERE "facebook_user_infos"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.516235 #32680] DEBUG -- : GoogleUserInfo Load (34.3ms) SELECT "google_user_infos".* FROM "google_user_infos" WHERE "google_user_infos"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.564554 #32680] DEBUG -- : GithubUserInfo Load (41.0ms) SELECT "github_user_infos".* FROM "github_user_infos" WHERE "github_user_infos"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.639693 #32680] DEBUG -- : UserOpenId Load (67.7ms) SELECT "user_open_ids".* FROM "user_open_ids" WHERE "user_open_ids"."user_id" = $1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.648980 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 2
- D, [2015-01-31T05:37:07.651715 #32680] DEBUG -- : (1.1ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 1
- D, [2015-01-31T05:37:07.654410 #32680] DEBUG -- : (0.7ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND "topics"."user_id" = $1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.656937 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."user_id" = 35548 AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8)
- D, [2015-01-31T05:37:07.664885 #32680] DEBUG -- : (0.9ms) SELECT COUNT(DISTINCT "posts"."id") FROM "posts" LEFT OUTER JOIN "post_actions" ON "post_actions"."post_id" = "posts"."id" AND ("post_actions"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND "posts"."user_id" = $1 AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8) [["user_id", 35548]]
- D, [2015-01-31T05:37:07.672579 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "topics" INNER JOIN "topic_allowed_users" ON "topics"."id" = "topic_allowed_users"."topic_id" WHERE ("topics"."deleted_at" IS NULL) AND "topic_allowed_users"."user_id" = $1 AND "topics"."archetype" = 'private_message' [["user_id", 35548]]
- D, [2015-01-31T05:37:07.675073 #32680] DEBUG -- : (0.8ms) SELECT COUNT(distinct badge_id) FROM "user_badges" WHERE "user_badges"."user_id" = $1 AND (user_badges.badge_id IN (SELECT id FROM badges where enabled)) [["user_id", 35548]]
- D, [2015-01-31T05:37:07.678420 #32680] DEBUG -- : (0.7ms) SELECT COUNT(*) FROM "warnings" WHERE "warnings"."user_id" = $1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.680102 #32680] DEBUG -- : (0.7ms) SELECT "user_fields"."id" FROM "user_fields"
- D, [2015-01-31T05:37:07.687366 #32680] DEBUG -- : SingleSignOnRecord Load (0.8ms) SELECT "single_sign_on_records".* FROM "single_sign_on_records" WHERE "single_sign_on_records"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.706708 #32680] DEBUG -- : ApiKey Load (11.0ms) SELECT "api_keys".* FROM "api_keys" WHERE "api_keys"."user_id" = $1 LIMIT 1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.709771 #32680] DEBUG -- : UserHistory Load (1.1ms) SELECT "user_histories".* FROM "user_histories" WHERE "user_histories"."target_user_id" = 35548 AND "user_histories"."action" = 10 ORDER BY id DESC LIMIT 1
- D, [2015-01-31T05:37:07.718544 #32680] DEBUG -- : UserHistory Exists (0.8ms) SELECT 1 AS one FROM "user_histories" WHERE "user_histories"."target_user_id" = 35548 AND "user_histories"."action" = 15 AND (created_at >= '2015-01-17 13:37:07.712939') AND "user_histories"."previous_value" = '2' AND "user_histories"."new_value" = '3' LIMIT 1
- D, [2015-01-31T05:37:07.721381 #32680] DEBUG -- : (0.7ms) SELECT COUNT(*) FROM "user_visits" WHERE "user_visits"."user_id" = $1 AND (visited_at > '2014-10-23 13:37:07.719984' and posts_read > 0) [["user_id", 35548]]
- D, [2015-01-31T05:37:07.723940 #32680] DEBUG -- : (0.7ms) SELECT COUNT(distinct topic_id) FROM "posts" WHERE ("posts"."deleted_at" IS NULL) AND "posts"."user_id" = $1 AND (created_at > '2014-10-23 13:37:07.722597' AND post_number > 1) [["user_id", 35548]]
- D, [2015-01-31T05:37:07.729435 #32680] DEBUG -- : (1.0ms) SELECT COUNT("topic_views"."topic_id") FROM "topic_views" WHERE "topic_views"."user_id" = 35548 AND (viewed_at > '2014-10-23 13:37:07.724947')
- D, [2015-01-31T05:37:07.732898 #32680] DEBUG -- : (1.6ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND "topics"."visible" = 't' AND (topics.created_at > '2014-10-23 13:37:07.730753')
- D, [2015-01-31T05:37:07.736131 #32680] DEBUG -- : (0.7ms) SELECT "user_visits"."posts_read" FROM "user_visits" WHERE "user_visits"."user_id" = $1 AND (visited_at > '2014-10-23 13:37:07.734602') [["user_id", 35548]]
- D, [2015-01-31T05:37:07.740495 #32680] DEBUG -- : (1.8ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (topics.visible = true) AND "posts"."hidden" = 'f' AND (posts.created_at > '2014-10-23 13:37:07.737697')
- D, [2015-01-31T05:37:07.795770 #32680] DEBUG -- : (53.3ms) SELECT COUNT("topic_views"."topic_id") FROM "topic_views" WHERE "topic_views"."user_id" = 35548
- D, [2015-01-31T05:37:07.798685 #32680] DEBUG -- : (1.1ms) SELECT "user_visits"."posts_read" FROM "user_visits" WHERE "user_visits"."user_id" = $1 [["user_id", 35548]]
- D, [2015-01-31T05:37:07.802178 #32680] DEBUG -- : (0.7ms) SELECT "posts"."id" FROM "posts" WHERE "posts"."user_id" = $1 AND (created_at > '2014-10-23 13:37:07.800549' AND (spam_count > 0 OR inappropriate_count > 0)) [["user_id", 35548]]
- D, [2015-01-31T05:37:07.805992 #32680] DEBUG -- : (0.8ms) SELECT "post_actions"."post_id" FROM "post_actions" WHERE 1=0 AND ("post_actions"."user_id" != 35548) AND ("post_actions"."agreed_at" IS NOT NULL)
- D, [2015-01-31T05:37:07.808369 #32680] DEBUG -- : (0.7ms) SELECT "post_actions"."user_id" FROM "post_actions" WHERE 1=0 AND ("post_actions"."user_id" != 35548) AND ("post_actions"."agreed_at" IS NOT NULL)
- D, [2015-01-31T05:37:07.810802 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 1 AND (created_at > '2014-10-23 13:37:07.809464')
- D, [2015-01-31T05:37:07.812803 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 2 AND (created_at > '2014-10-23 13:37:07.811622')
- D, [2015-01-31T05:37:07.814947 #32680] DEBUG -- : (0.9ms) SELECT date(created_at) FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 2 AND (created_at > '2014-10-23 13:37:07.813748')
- D, [2015-01-31T05:37:07.817450 #32680] DEBUG -- : (1.0ms) SELECT "user_actions"."acting_user_id" FROM "user_actions" WHERE "user_actions"."user_id" = 35548 AND "user_actions"."action_type" = 2 AND (created_at > '2014-10-23 13:37:07.815878')
- D, [2015-01-31T05:37:07.820063 #32680] DEBUG -- : Group Load (0.7ms) SELECT "groups".* FROM "groups" INNER JOIN "group_users" ON "groups"."id" = "group_users"."group_id" WHERE "group_users"."user_id" = $1 [["user_id", 35548]]
- I, [2015-01-31T05:37:07.822721 #32680] INFO -- : Completed 200 OK in 450ms (Views: 0.1ms | ActiveRecord: 317.7ms)
- D, [2015-01-31T05:37:07.955193 #32680] DEBUG -- :
- D, [2015-01-31T05:37:07.955293 #32680] DEBUG -- :
- I, [2015-01-31T05:37:07.955471 #32680] INFO -- : Started GET "/admin/groups.json?_=1422711362565" for 127.0.0.1 at 2015-01-31 05:37:07 -0800
- D, [2015-01-31T05:37:07.985109 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- I, [2015-01-31T05:37:07.993920 #32680] INFO -- : Processing by Admin::GroupsController#index as JSON
- I, [2015-01-31T05:37:07.994993 #32680] INFO -- : Parameters: {"_"=>"1422711362565"}
- D, [2015-01-31T05:37:07.997266 #32680] DEBUG -- : Group Load (0.9ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."name" ASC
- I, [2015-01-31T05:37:07.998784 #32680] INFO -- : Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 0.9ms)
- D, [2015-01-31T05:37:09.652667 #32680] DEBUG -- :
- D, [2015-01-31T05:37:09.652733 #32680] DEBUG -- :
- I, [2015-01-31T05:37:09.652852 #32680] INFO -- : Started GET "/admin/dashboard.json?_=1422711362566" for 127.0.0.1 at 2015-01-31 05:37:09 -0800
- D, [2015-01-31T05:37:09.689761 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- I, [2015-01-31T05:37:09.698559 #32680] INFO -- : Processing by Admin::DashboardController#index as JSON
- I, [2015-01-31T05:37:09.700358 #32680] INFO -- : Parameters: {"_"=>"1422711362566"}
- D, [2015-01-31T05:37:09.709732 #32680] DEBUG -- : (1.4ms) SELECT COUNT(*) AS count_all, visited_at AS visited_at FROM "user_visits" WHERE (visited_at >= '2014-12-31' and visited_at <= '2015-01-31') GROUP BY visited_at ORDER BY "user_visits"."visited_at" ASC
- D, [2015-01-31T05:37:09.719619 #32680] DEBUG -- : (7.2ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "users" WHERE (id > 0) AND (created_at >= '2014-12-31 00:00:00.000000' and created_at <= '2015-01-31 23:59:59.999999') GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:09.974749 #32680] DEBUG -- : (253.3ms) SELECT COUNT(*) FROM "users" WHERE (id > 0)
- D, [2015-01-31T05:37:09.983745 #32680] DEBUG -- : (7.0ms) SELECT COUNT(*) FROM "users" WHERE (id > 0) AND (created_at >= '2014-12-01 00:00:00.000000' and created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:09.989549 #32680] DEBUG -- : (1.9ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (created_at >= '2014-12-31 00:00:00.000000' and created_at <= '2015-01-31 23:59:59.999999') GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:09.992525 #32680] DEBUG -- : (1.4ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message')
- D, [2015-01-31T05:37:09.995801 #32680] DEBUG -- : (1.7ms) SELECT COUNT(*) FROM "topics" WHERE ("topics"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (topics.created_at >= '2014-12-01 00:00:00.000000' and topics.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:09.999863 #32680] DEBUG -- : (1.4ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (posts.created_at >= '2014-12-31 00:00:00.000000' AND posts.created_at <= '2015-01-31 23:59:59.999999') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.055575 #32680] DEBUG -- : (53.5ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message')
- D, [2015-01-31T05:37:10.060552 #32680] DEBUG -- : (1.9ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype <> 'private_message') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.067895 #32680] DEBUG -- : (2.0ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND (created_at >= '2014-12-31 00:00:00.000000' and created_at <= '2015-01-31 23:59:59.999999') AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8) GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:10.071982 #32680] DEBUG -- : (1.7ms) SELECT COUNT(*) FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8)
- D, [2015-01-31T05:37:10.075777 #32680] DEBUG -- : (1.6ms) SELECT COUNT(*) FROM "post_actions" WHERE ("post_actions"."deleted_at" IS NULL) AND "post_actions"."post_action_type_id" IN (3, 4, 7, 8) AND (post_actions.created_at >= '2014-12-01 00:00:00.000000' and post_actions.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.091992 #32680] DEBUG -- : (13.7ms) SELECT COUNT(*) AS count_all, trust_level AS trust_level FROM "users" WHERE (id > 0) GROUP BY trust_level
- D, [2015-01-31T05:37:10.116184 #32680] DEBUG -- : (1.5ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 2 AND (created_at >= '2015-01-01 13:37:10.113992') GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:10.119367 #32680] DEBUG -- : (1.5ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 2
- D, [2015-01-31T05:37:10.122284 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 2 AND (post_actions.created_at >= '2014-12-01 00:00:00.000000' and post_actions.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.125503 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 1 AND (created_at >= '2015-01-01 13:37:10.123659') GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:10.128228 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 1
- D, [2015-01-31T05:37:10.130979 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 1 AND (post_actions.created_at >= '2014-12-01 00:00:00.000000' and post_actions.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.246140 #32680] DEBUG -- : (103.5ms) SELECT COUNT(*) AS count_all, date(created_at) AS date_created_at FROM "email_logs" WHERE (created_at >= '2014-12-31 00:00:00.000000' and created_at < '2015-01-31 23:59:59.999999' AND skipped = false) GROUP BY date(created_at) ORDER BY date(created_at)
- D, [2015-01-31T05:37:10.268017 #32680] DEBUG -- : (20.5ms) SELECT COUNT(*) FROM "email_logs"
- D, [2015-01-31T05:37:10.270526 #32680] DEBUG -- : (1.0ms) SELECT COUNT(*) FROM "email_logs" WHERE (created_at >= '2014-12-01 00:00:00.000000' and created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.274501 #32680] DEBUG -- : (1.4ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'user_to_user') AND (posts.created_at > '2015-01-01 13:37:10.272123') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.278295 #32680] DEBUG -- : (1.8ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'user_to_user')
- D, [2015-01-31T05:37:10.281198 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'user_to_user') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.284953 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'system_message') AND (posts.created_at > '2015-01-01 13:37:10.282660') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.322687 #32680] DEBUG -- : (35.8ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'system_message')
- D, [2015-01-31T05:37:10.326124 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'system_message') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.329921 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'moderator_warning') AND (posts.created_at > '2015-01-01 13:37:10.327715') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.333470 #32680] DEBUG -- : (1.7ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'moderator_warning')
- D, [2015-01-31T05:37:10.336496 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'moderator_warning') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.339975 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_moderators') AND (posts.created_at > '2015-01-01 13:37:10.337844') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.343797 #32680] DEBUG -- : (1.9ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_moderators')
- D, [2015-01-31T05:37:10.347191 #32680] DEBUG -- : (1.4ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_moderators') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.350994 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) AS count_all, date(posts.created_at) AS date_posts_created_at FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_user') AND (posts.created_at > '2015-01-01 13:37:10.348712') GROUP BY date(posts.created_at) ORDER BY date(posts.created_at)
- D, [2015-01-31T05:37:10.354696 #32680] DEBUG -- : (1.9ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_user')
- D, [2015-01-31T05:37:10.357928 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "posts" INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" AND ("topics"."deleted_at" IS NULL) WHERE ("posts"."deleted_at" IS NULL) AND (topics.archetype = 'private_message') AND (topics.subtype = 'notify_user') AND (posts.created_at >= '2014-12-01 00:00:00.000000' and posts.created_at < '2014-12-31 00:00:00.000000')
- D, [2015-01-31T05:37:10.365000 #32680] DEBUG -- : (5.6ms) SELECT COUNT(*) FROM "users" WHERE "users"."admin" = 't'
- D, [2015-01-31T05:37:10.374986 #32680] DEBUG -- : (8.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."moderator" = 't'
- D, [2015-01-31T05:37:10.380475 #32680] DEBUG -- : (3.7ms) SELECT COUNT(*) FROM "users" WHERE (suspended_till IS NOT NULL AND suspended_till > '2015-01-31 13:37:10.376282')
- D, [2015-01-31T05:37:10.390224 #32680] DEBUG -- : (8.3ms) SELECT COUNT(*) FROM "users" WHERE "users"."blocked" = 't'
- D, [2015-01-31T05:37:10.442922 #32680] DEBUG -- : (38.9ms) SELECT COUNT(*) AS count_all, users.username AS users_username FROM "incoming_links" INNER JOIN "users" ON "users"."id" = "incoming_links"."user_id" WHERE (incoming_links.created_at > '2015-01-01 13:37:10.395042' AND incoming_links.user_id IS NOT NULL) GROUP BY users.username
- D, [2015-01-31T05:37:10.462023 #32680] DEBUG -- : (14.2ms) SELECT COUNT(DISTINCT posts.topic_id) AS count_distinct_posts_topic_id, users.username AS users_username FROM "incoming_links" INNER JOIN "users" ON "users"."id" = "incoming_links"."user_id" INNER JOIN "posts" ON "posts"."id" = "incoming_links"."post_id" AND ("posts"."deleted_at" IS NULL) WHERE (incoming_links.created_at > '2015-01-01 13:37:10.395042' AND incoming_links.user_id IS NOT NULL) GROUP BY users.username
- D, [2015-01-31T05:37:10.528407 #32680] DEBUG -- : (51.1ms) SELECT COUNT(*) AS count_all, incoming_domains.name AS incoming_domains_name FROM "incoming_links" INNER JOIN "incoming_referers" ON "incoming_referers"."id" = "incoming_links"."incoming_referer_id" INNER JOIN "incoming_domains" ON "incoming_domains"."id" = "incoming_referers"."incoming_domain_id" WHERE (incoming_links.created_at > '2015-01-01 13:37:10.463434') GROUP BY incoming_domains.name ORDER BY count_all DESC LIMIT 10
- D, [2015-01-31T05:37:10.533245 #32680] DEBUG -- : (1.8ms) SELECT COUNT(DISTINCT posts.topic_id) AS count_distinct_posts_topic_id, incoming_domains.name AS incoming_domains_name FROM "incoming_links" INNER JOIN "incoming_referers" ON "incoming_referers"."id" = "incoming_links"."incoming_referer_id" INNER JOIN "incoming_domains" ON "incoming_domains"."id" = "incoming_referers"."incoming_domain_id" INNER JOIN "posts" ON "posts"."id" = "incoming_links"."post_id" AND ("posts"."deleted_at" IS NULL) WHERE (incoming_links.created_at > '2015-01-01 13:37:10.529823' AND incoming_domains.name IN (NULL)) GROUP BY incoming_domains.name
- D, [2015-01-31T05:37:10.536809 #32680] DEBUG -- : (1.3ms) SELECT COUNT(*) AS count_all, topic_id AS topic_id FROM "incoming_links" INNER JOIN "posts" ON "posts"."id" = "incoming_links"."post_id" AND ("posts"."deleted_at" IS NULL) WHERE (incoming_links.created_at > '2015-01-01 13:37:10.534562' AND topic_id IS NOT NULL) GROUP BY topic_id
- I, [2015-01-31T05:37:10.552066 #32680] INFO -- : Completed 200 OK in 851ms (Views: 2.5ms | ActiveRecord: 684.5ms)
- D, [2015-01-31T05:37:10.556398 #32680] DEBUG -- :
- D, [2015-01-31T05:37:10.556473 #32680] DEBUG -- :
- I, [2015-01-31T05:37:10.556603 #32680] INFO -- : Started GET "/admin/dashboard/problems.json?_=1422711362567" for 127.0.0.1 at 2015-01-31 05:37:10 -0800
- D, [2015-01-31T05:37:10.588915 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
- I, [2015-01-31T05:37:10.590964 #32680] INFO -- : Processing by Admin::DashboardController#problems as JSON
- I, [2015-01-31T05:37:10.591771 #32680] INFO -- : Parameters: {"_"=>"1422711362567"}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement