Advertisement
riking

Rails log of browsing a few pages

Jan 31st, 2015
538
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 83.04 KB | None | 0 0
  1. => Booting Thin
  2. => Rails 4.1.8 application starting in development on http://0.0.0.0:3000
  3. => Run `rails server -h` for more startup options
  4. => Notice: server is listening on all interfaces (0.0.0.0). Consider using 127.0.0.1 (--binding option)
  5. => Ctrl-C to shutdown server
  6. Thin web server (v1.6.2 codename Doc Brown)
  7. Maximum connections set to 1024
  8. Listening on 0.0.0.0:3000, CTRL+C to stop
  9. D, [2015-01-31T05:35:54.451136 #32680] DEBUG -- :
  10. D, [2015-01-31T05:35:54.451208 #32680] DEBUG -- :
  11. I, [2015-01-31T05:35:54.451343 #32680] INFO -- : Started GET "/" for 127.0.0.1 at 2015-01-31 05:35:54 -0800
  12. D, [2015-01-31T05:35:54.504357 #32680] DEBUG -- : ActiveRecord::SchemaMigration Load (0.7ms) SELECT "schema_migrations".* FROM "schema_migrations"
  13. D, [2015-01-31T05:35:54.605595 #32680] DEBUG -- : User Load (24.8ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  14. I, [2015-01-31T05:35:54.651809 #32680] INFO -- : Processing by ListController#latest as HTML
  15. 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]]
  16. 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]]
  17. 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
  18. D, [2015-01-31T05:35:55.106615 #32680] DEBUG -- : (5.8ms) BEGIN
  19. 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"]]
  20. D, [2015-01-31T05:35:55.295667 #32680] DEBUG -- : (13.9ms) COMMIT
  21. 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
  22. D, [2015-01-31T05:35:55.335569 #32680] DEBUG -- : Group Load (1.4ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."name" ASC
  23. 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
  24. D, [2015-01-31T05:35:55.351631 #32680] DEBUG -- : (1.0ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = 't'
  25. 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
  26. 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)
  27. D, [2015-01-31T05:35:55.465064 #32680] DEBUG -- : (0.9ms) SELECT "categories"."id" FROM "categories"
  28. 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
  29. 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
  30. 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
  31. D, [2015-01-31T05:35:55.500994 #32680] DEBUG -- : UserField Load (8.5ms) SELECT "user_fields".* FROM "user_fields"
  32. 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
  33. 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
  34. 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
  35. 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]]
  36. 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]]
  37. 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]]
  38. 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]]
  39. 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
  40. 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
  41. 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
  42. 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
  43. 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
  44. 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
  45. 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
  46. 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
  47. 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
  48. 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]]
  49. D, [2015-01-31T05:35:55.656392 #32680] DEBUG -- : (48.2ms) WITH x AS (
  50. SELECT u.id AS user_id,
  51. topics.id AS topic_id,
  52. topics.created_at,
  53. highest_post_number,
  54. last_read_post_number,
  55. c.id AS category_id,
  56. tu.notification_level
  57. FROM users u
  58. INNER JOIN user_stats AS us ON us.user_id = u.id
  59. FULL OUTER JOIN topics ON 1=1
  60. LEFT JOIN topic_users tu ON tu.topic_id = topics.id AND tu.user_id = u.id
  61. LEFT JOIN categories c ON c.id = topics.category_id
  62. WHERE u.id IN (35548) AND
  63. topics.archetype <> 'private_message' AND
  64. (("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
  65. WHEN COALESCE(u.new_topic_duration_minutes, 2880) = -1 THEN u.created_at
  66. WHEN COALESCE(u.new_topic_duration_minutes, 2880) = -2 THEN COALESCE(u.previous_visit_at,u.created_at)
  67. ELSE ('2015-01-31 13:35:55.607799'::timestamp - INTERVAL '1 MINUTE' * COALESCE(u.new_topic_duration_minutes, 2880))
  68. END, us.new_since) AND tu.last_read_post_number IS NULL AND COALESCE(tu.notification_level, 2) >= 2)) AND
  69. (topics.visible OR u.admin OR u.moderator) AND
  70. topics.deleted_at IS NULL AND
  71. ( category_id IS NULL OR NOT c.read_restricted OR category_id IN (
  72. SELECT c2.id FROM categories c2
  73. JOIN category_groups cg ON cg.category_id = c2.id
  74. JOIN group_users gu ON gu.user_id = u.id AND cg.group_id = gu.group_id
  75. WHERE c2.read_restricted )
  76. )
  77. AND NOT EXISTS( SELECT 1 FROM category_users cu
  78. WHERE cu.user_id = u.id AND
  79. cu.category_id = topics.category_id AND
  80. cu.notification_level = 0)
  81.  
  82. ORDER BY topics.bumped_at DESC ) SELECT * FROM x LIMIT 500
  83. 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'
  84. 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
  85. 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(
  86. SELECT 1 FROM category_users cu
  87. WHERE cu.user_id = 35548 AND
  88. cu.category_id = topics.category_id AND
  89. cu.notification_level = 0 AND
  90. cu.category_id <> -1
  91. )) ORDER BY CASE
  92. WHEN topics.pinned_globally
  93. AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
  94. THEN topics.pinned_at + interval '9999 years'
  95. ELSE topics.bumped_at
  96. END DESC LIMIT 30
  97. 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
  98. 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)
  99. I, [2015-01-31T05:35:55.849377 #32680] INFO -- : Rendered list/list.erb within layouts/application (10.6ms)
  100. I, [2015-01-31T05:35:55.861234 #32680] INFO -- : Rendered layouts/_head.html.erb (6.3ms)
  101. I, [2015-01-31T05:35:55.877379 #32680] INFO -- : Rendered common/_special_font_face.html.erb (13.9ms)
  102. 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
  103. D, [2015-01-31T05:35:55.890470 #32680] DEBUG -- : (1.3ms) SELECT "categories"."updated_at" FROM "categories" ORDER BY updated_at desc LIMIT 1
  104. 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
  105. 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
  106. 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
  107. D, [2015-01-31T05:35:56.813227 #32680] DEBUG -- : Category Load (1.2ms) SELECT "categories".* FROM "categories" WHERE (background_url IS NOT NULL)
  108. 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
  109. I, [2015-01-31T05:35:57.326899 #32680] INFO -- : Rendered common/_discourse_stylesheet.html.erb (1448.0ms)
  110. 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
  111. 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
  112. I, [2015-01-31T05:36:01.795497 #32680] INFO -- : Rendered common/_discourse_javascript.html.erb (53.6ms)
  113. 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
  114. I, [2015-01-31T05:36:01.798727 #32680] INFO -- : Completed 200 OK in 7143ms (Views: 5958.4ms | ActiveRecord: 262.4ms)
  115. D, [2015-01-31T05:36:37.383226 #32680] DEBUG -- :
  116.  
  117.  
  118.  
  119.  
  120.  
  121. D, [2015-01-31T05:36:37.383311 #32680] DEBUG -- :
  122. 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
  123. I, [2015-01-31T05:36:37.424089 #32680] INFO -- : Processing by TopicsController#show as JSON
  124. I, [2015-01-31T05:36:37.425208 #32680] INFO -- : Parameters: {"track_visit"=>"true", "_"=>"1422711362557", "topic_id"=>"117", "post_number"=>"37"}
  125. D, [2015-01-31T05:36:37.428292 #32680] DEBUG -- : User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  126. 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
  127. D, [2015-01-31T05:36:37.437963 #32680] DEBUG -- : Category Load (1.2ms) SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (5)
  128. 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]]
  129. 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]]
  130. 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]]
  131. 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'
  132. D, [2015-01-31T05:36:37.557609 #32680] DEBUG -- : (0.1ms) BEGIN
  133. 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
  134. D, [2015-01-31T05:36:37.591933 #32680] DEBUG -- : (15.1ms) INSERT INTO topic_views (topic_id, ip_address, viewed_at, user_id)
  135. SELECT 117, '127.0.0.1', '2015-01-31', 35548
  136. WHERE NOT EXISTS (
  137. SELECT 1 FROM topic_views
  138. WHERE (user_id = 35548 AND topic_id = 117)
  139. )
  140. D, [2015-01-31T05:36:37.593022 #32680] DEBUG -- : (0.2ms) COMMIT
  141. 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
  142. 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
  143. 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
  144. 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)
  145. D, [2015-01-31T05:36:37.642285 #32680] DEBUG -- : User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (1878, 35548, 5259)
  146. D, [2015-01-31T05:36:37.653473 #32680] DEBUG -- : (1.0ms) SELECT categories.id FROM "categories" WHERE "categories"."read_restricted" = 't'
  147. D, [2015-01-31T05:36:37.905904 #32680] DEBUG -- : (251.2ms) SELECT
  148. l.post_id,
  149. l.url,
  150. l.clicks,
  151. COALESCE(t.title, l.title) AS title,
  152. l.internal,
  153. l.reflection,
  154. l.domain
  155. FROM topic_links l
  156. LEFT JOIN topics t ON t.id = l.link_topic_id
  157. LEFT JOIN categories AS c ON c.id = t.category_id
  158. 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))
  159. ORDER BY reflection ASC, clicks DESC
  160. 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]]
  161. 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
  162. 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)
  163. 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
  164. 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)
  165. 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]]
  166. 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]]
  167. 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]]
  168. 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]]
  169. 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]]
  170. 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]]
  171. 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
  172. 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)
  173. D, [2015-01-31T05:36:38.057464 #32680] DEBUG -- : (0.9ms) SELECT "categories"."topic_id" FROM "categories"
  174. 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
  175. WHEN topics.pinned_globally
  176. AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
  177. THEN topics.pinned_at + interval '9999 years'
  178. ELSE topics.bumped_at
  179. END DESC LIMIT 5
  180. D, [2015-01-31T05:36:38.067429 #32680] DEBUG -- : CACHE (0.0ms) SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (5)
  181. 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]]
  182. 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(
  183. SELECT 1 FROM category_users cu
  184. WHERE cu.user_id = 35548 AND
  185. cu.category_id = topics.category_id AND
  186. cu.notification_level = 0 AND
  187. cu.category_id <> -1
  188. )) 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
  189. WHEN topics.pinned_globally
  190. AND (COALESCE(topics.pinned_at, '1900-01-01') > COALESCE(tu.cleared_pinned_at, '1900-01-01'))
  191. THEN topics.pinned_at + interval '9999 years'
  192. ELSE topics.bumped_at
  193. END DESC LIMIT 3
  194. D, [2015-01-31T05:36:38.080384 #32680] DEBUG -- : CACHE (0.0ms) SELECT "categories"."topic_id" FROM "categories"
  195. 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(
  196. SELECT 1 FROM category_users cu
  197. WHERE cu.user_id = 35548 AND
  198. cu.category_id = topics.category_id AND
  199. cu.notification_level = 0 AND
  200. cu.category_id <> -1
  201. )) 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
  202. 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
  203. 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)
  204. D, [2015-01-31T05:36:38.249941 #32680] DEBUG -- : (100.3ms) SELECT ftl.url,
  205. COALESCE(ft.title, ftl.title) AS title,
  206. ftl.link_topic_id,
  207. ftl.reflection,
  208. ftl.internal,
  209. ftl.domain,
  210. MIN(ftl.user_id) AS user_id,
  211. SUM(clicks) AS clicks
  212. FROM topic_links AS ftl
  213. LEFT JOIN topics AS ft ON ftl.link_topic_id = ft.id
  214. LEFT JOIN categories AS c ON c.id = ft.category_id
  215. 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))
  216. GROUP BY ftl.url, ft.title, ftl.title, ftl.link_topic_id, ftl.reflection, ftl.internal, ftl.domain
  217. ORDER BY clicks DESC
  218. 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
  219. 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]]
  220. 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]]
  221. 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
  222. I, [2015-01-31T05:36:38.289730 #32680] INFO -- : Completed 200 OK in 864ms (Views: 0.2ms | ActiveRecord: 589.3ms)
  223. D, [2015-01-31T05:36:43.774509 #32680] DEBUG -- :
  224.  
  225.  
  226.  
  227.  
  228. D, [2015-01-31T05:36:43.774588 #32680] DEBUG -- :
  229. 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
  230. I, [2015-01-31T05:36:43.813148 #32680] INFO -- : Processing by AboutController#index as JSON
  231. I, [2015-01-31T05:36:43.814199 #32680] INFO -- : Parameters: {"_"=>"1422711362558"}
  232. D, [2015-01-31T05:36:43.816625 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  233. 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')
  234. D, [2015-01-31T05:36:48.558202 #32680] DEBUG -- : (4733.2ms) SELECT COUNT(*) FROM "posts" WHERE ("posts"."deleted_at" IS NULL)
  235. D, [2015-01-31T05:36:48.658111 #32680] DEBUG -- : (98.5ms) SELECT COUNT(*) FROM "users"
  236. 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')
  237. 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')
  238. 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')
  239. 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')
  240. D, [2015-01-31T05:36:49.311384 #32680] DEBUG -- : (80.7ms) SELECT COUNT(*) FROM "user_actions" WHERE "user_actions"."action_type" = 1
  241. 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')
  242. 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)
  243. 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)
  244. I, [2015-01-31T05:36:49.350744 #32680] INFO -- : Completed 200 OK in 5536ms (Views: 0.1ms | ActiveRecord: 5481.5ms)
  245. D, [2015-01-31T05:36:58.899437 #32680] DEBUG -- :
  246.  
  247.  
  248.  
  249. D, [2015-01-31T05:36:58.899537 #32680] DEBUG -- :
  250. 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
  251. I, [2015-01-31T05:36:58.938155 #32680] INFO -- : Processing by BadgesController#index as JSON
  252. I, [2015-01-31T05:36:58.939102 #32680] INFO -- : Parameters: {"only_listable"=>"true", "_"=>"1422711362559"}
  253. D, [2015-01-31T05:36:58.941495 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  254. 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]]
  255. 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'
  256. 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
  257. 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)
  258. 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]]
  259. 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]]
  260. 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]]
  261. 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]]
  262. 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]]
  263. 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]]
  264. 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]]
  265. 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]]
  266. 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]]
  267. 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]]
  268. 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]]
  269. 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]]
  270. 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]]
  271. 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]]
  272. 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]]
  273. 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]]
  274. 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]]
  275. 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]]
  276. 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]]
  277. 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]]
  278. 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]]
  279. 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]]
  280. 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]]
  281. 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]]
  282. I, [2015-01-31T05:36:59.115948 #32680] INFO -- : Completed 200 OK in 176ms (Views: 0.1ms | ActiveRecord: 100.5ms)
  283. D, [2015-01-31T05:37:03.051384 #32680] DEBUG -- :
  284.  
  285.  
  286.  
  287. D, [2015-01-31T05:37:03.051512 #32680] DEBUG -- :
  288. 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
  289. I, [2015-01-31T05:37:03.098858 #32680] INFO -- : Processing by UsersController#show as JSON
  290. I, [2015-01-31T05:37:03.099857 #32680] INFO -- : Parameters: {"_"=>"1422711362560", "username"=>"riking"}
  291. D, [2015-01-31T05:37:03.103578 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  292. 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
  293. 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]]
  294. D, [2015-01-31T05:37:03.339487 #32680] DEBUG -- : UserAction Load (221.3ms)
  295. SELECT action_type, COUNT(*) count
  296. FROM user_actions a
  297. JOIN topics t ON t.id = a.target_topic_id
  298. LEFT JOIN posts p on p.id = a.target_post_id
  299. JOIN posts p2 on p2.topic_id = a.target_topic_id and p2.post_number = 1
  300. LEFT JOIN categories c ON c.id = t.category_id
  301. WHERE (a.user_id = 35548) AND (t.deleted_at is null)
  302. GROUP BY action_type
  303.  
  304. D, [2015-01-31T05:37:03.345160 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = -1 LIMIT 1
  305. 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]]
  306. D, [2015-01-31T05:37:03.352284 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "notifications" WHERE "notifications"."user_id" = 35548
  307. 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]]
  308. D, [2015-01-31T05:37:03.366498 #32680] DEBUG -- : (0.9ms) SELECT "user_fields"."id" FROM "user_fields"
  309. 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]]
  310. 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
  311. 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
  312. 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
  313. 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'
  314. 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
  315. 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)
  316. 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]]
  317. 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]]
  318. 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]]
  319. 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)
  320. 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
  321. WHERE ub2.badge_id IN (1,2,3,4) AND
  322. ub2.user_id = 35548) THEN 1 ELSE 0 END DESC, badges.badge_type_id ASC, badges.grant_count ASC LIMIT 3 [["user_id", 35548]]
  323. D, [2015-01-31T05:37:03.499236 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (35548)
  324. D, [2015-01-31T05:37:03.504645 #32680] DEBUG -- : User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (-1)
  325. D, [2015-01-31T05:37:03.512946 #32680] DEBUG -- : Badge Load (1.1ms) SELECT "badges".* FROM "badges" WHERE "badges"."id" IN (4, 3, 17)
  326. 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)
  327. 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)
  328. 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
  329. WHERE ub2.badge_id IN (1,2,3,4) AND
  330. ub2.user_id = 35548) THEN 1 ELSE 0 END DESC, badges.badge_type_id ASC, badges.grant_count ASC LIMIT 3 [["user_id", 35548]]
  331. D, [2015-01-31T05:37:03.520104 #32680] DEBUG -- : CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (35548)
  332. D, [2015-01-31T05:37:03.582175 #32680] DEBUG -- : CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (-1)
  333. D, [2015-01-31T05:37:03.583846 #32680] DEBUG -- : CACHE (0.0ms) SELECT "badges".* FROM "badges" WHERE "badges"."id" IN (4, 3, 17)
  334. 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)
  335. I, [2015-01-31T05:37:03.590214 #32680] INFO -- : Completed 200 OK in 488ms (Views: 0.2ms | ActiveRecord: 288.4ms)
  336. D, [2015-01-31T05:37:03.600585 #32680] DEBUG -- :
  337.  
  338.  
  339.  
  340. D, [2015-01-31T05:37:03.600648 #32680] DEBUG -- :
  341. 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
  342. I, [2015-01-31T05:37:03.627537 #32680] INFO -- : Processing by UsersController#staff_info as JSON
  343. I, [2015-01-31T05:37:03.628333 #32680] INFO -- : Parameters: {"_"=>"1422711362561", "username"=>"riking"}
  344. D, [2015-01-31T05:37:03.630292 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  345. 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
  346. 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)
  347. 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)
  348. 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)
  349. 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
  350. D, [2015-01-31T05:37:03.669764 #32680] DEBUG -- : (0.8ms) SELECT COUNT(*) FROM "warnings" WHERE "warnings"."user_id" = $1 [["user_id", 35548]]
  351. I, [2015-01-31T05:37:03.671355 #32680] INFO -- : Completed 200 OK in 42ms (Views: 0.3ms | ActiveRecord: 21.3ms)
  352. D, [2015-01-31T05:37:03.684950 #32680] DEBUG -- :
  353.  
  354.  
  355.  
  356. D, [2015-01-31T05:37:03.685026 #32680] DEBUG -- :
  357. 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
  358. I, [2015-01-31T05:37:03.723117 #32680] INFO -- : Processing by UserActionsController#index as JSON
  359. I, [2015-01-31T05:37:03.724139 #32680] INFO -- : Parameters: {"offset"=>"0", "username"=>"riking", "filter"=>"4,5", "_"=>"1422711362562"}
  360. D, [2015-01-31T05:37:03.726514 #32680] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  361. D, [2015-01-31T05:37:03.728222 #32680] DEBUG -- : Unpermitted parameters: username, _, format
  362. 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
  363. D, [2015-01-31T05:37:03.859960 #32680] DEBUG -- : (127.7ms)
  364. SELECT
  365. a.id,
  366. t.title, a.action_type, a.created_at, t.id topic_id,
  367. a.user_id AS target_user_id, au.name AS target_name, au.username AS target_username,
  368. coalesce(p.post_number, 1) post_number, p.id as post_id,
  369. p.reply_to_post_number,
  370. pu.email, pu.username, pu.name, pu.id user_id,
  371. pu.uploaded_avatar_id,
  372. u.email acting_email, u.username acting_username, u.name acting_name, u.id acting_user_id,
  373. u.uploaded_avatar_id acting_uploaded_avatar_id,
  374. coalesce(p.cooked, p2.cooked) cooked,
  375. CASE WHEN coalesce(p.deleted_at, p2.deleted_at, t.deleted_at) IS NULL THEN false ELSE true END deleted,
  376. p.hidden,
  377. p.post_type,
  378. p.edit_reason,
  379. t.category_id
  380. FROM user_actions as a
  381. JOIN topics t on t.id = a.target_topic_id
  382. LEFT JOIN posts p on p.id = a.target_post_id
  383. JOIN posts p2 on p2.topic_id = a.target_topic_id and p2.post_number = 1
  384. JOIN users u on u.id = a.acting_user_id
  385. JOIN users pu on pu.id = COALESCE(p.user_id, t.user_id)
  386. JOIN users au on au.id = a.user_id
  387. LEFT JOIN categories c on c.id = t.category_id
  388. WHERE (t.deleted_at is null) AND (a.user_id = 35548) AND (a.action_type in (4,5))
  389. ORDER BY a.created_at desc
  390. OFFSET 0
  391. LIMIT 60
  392.  
  393. I, [2015-01-31T05:37:03.976200 #32680] INFO -- : Completed 200 OK in 251ms (Views: 0.1ms | ActiveRecord: 129.7ms)
  394. D, [2015-01-31T05:37:03.978692 #32680] DEBUG -- :
  395.  
  396.  
  397.  
  398. D, [2015-01-31T05:37:03.978775 #32680] DEBUG -- :
  399. 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
  400. I, [2015-01-31T05:37:04.011655 #32680] INFO -- : Processing by DraftController#show as JSON
  401. I, [2015-01-31T05:37:04.012483 #32680] INFO -- : Parameters: {"draft_key"=>"new_private_message", "_"=>"1422711362563"}
  402. D, [2015-01-31T05:37:04.014494 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  403. 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'
  404. 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
  405. I, [2015-01-31T05:37:04.031311 #32680] INFO -- : Completed 200 OK in 18ms (Views: 0.2ms | ActiveRecord: 13.6ms)
  406. D, [2015-01-31T05:37:07.323513 #32680] DEBUG -- :
  407.  
  408.  
  409.  
  410. D, [2015-01-31T05:37:07.323611 #32680] DEBUG -- :
  411. 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
  412. D, [2015-01-31T05:37:07.353667 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  413. I, [2015-01-31T05:37:07.370741 #32680] INFO -- : Processing by Admin::UsersController#show as JSON
  414. I, [2015-01-31T05:37:07.372097 #32680] INFO -- : Parameters: {"_"=>"1422711362564", "id"=>"riking"}
  415. D, [2015-01-31T05:37:07.374849 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."username_lower" = 'riking' LIMIT 1
  416. 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]]
  417. 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]]
  418. 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]]
  419. 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]]
  420. 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]]
  421. 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]]
  422. 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
  423. 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
  424. 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]]
  425. 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)
  426. 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]]
  427. 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]]
  428. 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]]
  429. D, [2015-01-31T05:37:07.678420 #32680] DEBUG -- : (0.7ms) SELECT COUNT(*) FROM "warnings" WHERE "warnings"."user_id" = $1 [["user_id", 35548]]
  430. D, [2015-01-31T05:37:07.680102 #32680] DEBUG -- : (0.7ms) SELECT "user_fields"."id" FROM "user_fields"
  431. 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]]
  432. 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]]
  433. 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
  434. 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
  435. 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]]
  436. 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]]
  437. 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')
  438. 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')
  439. 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]]
  440. 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')
  441. 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
  442. 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]]
  443. 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]]
  444. 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)
  445. 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)
  446. 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')
  447. 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')
  448. 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')
  449. 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')
  450. 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]]
  451. I, [2015-01-31T05:37:07.822721 #32680] INFO -- : Completed 200 OK in 450ms (Views: 0.1ms | ActiveRecord: 317.7ms)
  452. D, [2015-01-31T05:37:07.955193 #32680] DEBUG -- :
  453.  
  454.  
  455.  
  456. D, [2015-01-31T05:37:07.955293 #32680] DEBUG -- :
  457. 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
  458. D, [2015-01-31T05:37:07.985109 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  459. I, [2015-01-31T05:37:07.993920 #32680] INFO -- : Processing by Admin::GroupsController#index as JSON
  460. I, [2015-01-31T05:37:07.994993 #32680] INFO -- : Parameters: {"_"=>"1422711362565"}
  461. D, [2015-01-31T05:37:07.997266 #32680] DEBUG -- : Group Load (0.9ms) SELECT "groups".* FROM "groups" ORDER BY "groups"."name" ASC
  462. I, [2015-01-31T05:37:07.998784 #32680] INFO -- : Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 0.9ms)
  463. D, [2015-01-31T05:37:09.652667 #32680] DEBUG -- :
  464.  
  465.  
  466.  
  467. D, [2015-01-31T05:37:09.652733 #32680] DEBUG -- :
  468. 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
  469. D, [2015-01-31T05:37:09.689761 #32680] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  470. I, [2015-01-31T05:37:09.698559 #32680] INFO -- : Processing by Admin::DashboardController#index as JSON
  471. I, [2015-01-31T05:37:09.700358 #32680] INFO -- : Parameters: {"_"=>"1422711362566"}
  472. 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
  473. 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)
  474. D, [2015-01-31T05:37:09.974749 #32680] DEBUG -- : (253.3ms) SELECT COUNT(*) FROM "users" WHERE (id > 0)
  475. 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')
  476. 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)
  477. 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')
  478. 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')
  479. 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)
  480. 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')
  481. 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')
  482. 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)
  483. 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)
  484. 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')
  485. 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
  486. 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)
  487. D, [2015-01-31T05:37:10.119367 #32680] DEBUG -- : (1.5ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 2
  488. 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')
  489. 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)
  490. D, [2015-01-31T05:37:10.128228 #32680] DEBUG -- : (1.2ms) SELECT COUNT(*) FROM "post_actions" WHERE "post_actions"."post_action_type_id" = 1
  491. 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')
  492. 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)
  493. D, [2015-01-31T05:37:10.268017 #32680] DEBUG -- : (20.5ms) SELECT COUNT(*) FROM "email_logs"
  494. 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')
  495. 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)
  496. 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')
  497. 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')
  498. 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)
  499. 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')
  500. 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')
  501. 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)
  502. 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')
  503. 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')
  504. 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)
  505. 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')
  506. 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')
  507. 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)
  508. 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')
  509. 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')
  510. D, [2015-01-31T05:37:10.365000 #32680] DEBUG -- : (5.6ms) SELECT COUNT(*) FROM "users" WHERE "users"."admin" = 't'
  511. D, [2015-01-31T05:37:10.374986 #32680] DEBUG -- : (8.1ms) SELECT COUNT(*) FROM "users" WHERE "users"."moderator" = 't'
  512. 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')
  513. D, [2015-01-31T05:37:10.390224 #32680] DEBUG -- : (8.3ms) SELECT COUNT(*) FROM "users" WHERE "users"."blocked" = 't'
  514. 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
  515. 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
  516. 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
  517. 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
  518. 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
  519. I, [2015-01-31T05:37:10.552066 #32680] INFO -- : Completed 200 OK in 851ms (Views: 2.5ms | ActiveRecord: 684.5ms)
  520. D, [2015-01-31T05:37:10.556398 #32680] DEBUG -- :
  521.  
  522.  
  523.  
  524. D, [2015-01-31T05:37:10.556473 #32680] DEBUG -- :
  525. 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
  526. D, [2015-01-31T05:37:10.588915 #32680] DEBUG -- : User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."auth_token" = '8828e4c99022925cab80e6f686f860cd' LIMIT 1
  527. I, [2015-01-31T05:37:10.590964 #32680] INFO -- : Processing by Admin::DashboardController#problems as JSON
  528. I, [2015-01-31T05:37:10.591771 #32680] INFO -- : Parameters: {"_"=>"1422711362567"}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement