Skip to content

Instantly share code, notes, and snippets.

@mysmaily
Created July 24, 2020 07:16
Show Gist options
  • Save mysmaily/18baa19f98b52854f1ddfd82af5bba18 to your computer and use it in GitHub Desktop.
Save mysmaily/18baa19f98b52854f1ddfd82af5bba18 to your computer and use it in GitHub Desktop.
I, [2020-07-24T10:40:42.111259 #156] INFO -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Started GET "/api/messages" for 106.130.215.237 at 2020-07-24 10:40:42 +0900
I, [2020-07-24T10:40:42.112100 #156] INFO -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Processing by Api::MessagesController#index as */*
I, [2020-07-24T10:40:42.112179 #156] INFO -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Parameters: {"message"=>{}}
D, [2020-07-24T10:40:42.114807 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 61], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.115495 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 61], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.116564 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] User Load (2.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 61], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.117048 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE User Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 61], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.119578 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] UserMessage Update All (1.8ms) UPDATE "user_messages" SET "read" = TRUE WHERE "user_messages"."user_id" = $1 [["user_id", 61]]
D, [2020-07-24T10:40:42.120768 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] UserMessage Load (0.6ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 ORDER BY "user_messages"."id" ASC [["user_id", 61]]
D, [2020-07-24T10:40:42.122526 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] UserMessage Update All (6.1ms) UPDATE "user_messages" SET "read" = TRUE WHERE "user_messages"."user_id" = $1 [["user_id", 61]]
D, [2020-07-24T10:40:42.123156 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Message Load (1.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."id" IN ($1, $2, $3, $4, $5) [["id", 1], ["id", 2], ["id", 121], ["id", 118], ["id", 11]]
D, [2020-07-24T10:40:42.125405 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] UserMessage Load (2.4ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 ORDER BY "user_messages"."id" ASC [["user_id", 61]]
D, [2020-07-24T10:40:42.126938 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Body Load (2.5ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_type" = $1 AND "bodies"."bodyable_id" IN ($2, $3, $4, $5, $6) [["bodyable_type", "Message"], ["bodyable_id", 1], ["bodyable_id", 2], ["bodyable_id", 11], ["bodyable_id", 118], ["bodyable_id", 121]]
D, [2020-07-24T10:40:42.128773 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Message Load (1.9ms) SELECT "messages".* FROM "messages" WHERE "messages"."id" IN ($1, $2, $3, $4, $5) [["id", 1], ["id", 2], ["id", 121], ["id", 118], ["id", 11]]
D, [2020-07-24T10:40:42.129994 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] UserMessage Load (1.8ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 [["user_id", 61]]
D, [2020-07-24T10:40:42.131712 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Body Load (1.8ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_type" = $1 AND "bodies"."bodyable_id" IN ($2, $3, $4, $5, $6) [["bodyable_type", "Message"], ["bodyable_id", 1], ["bodyable_id", 2], ["bodyable_id", 11], ["bodyable_id", 118], ["bodyable_id", 121]]
D, [2020-07-24T10:40:42.132758 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] UserMessage Load (1.8ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 ORDER BY "user_messages"."id" ASC LIMIT $2 OFFSET $3 [["user_id", 61], ["LIMIT", 10], ["OFFSET", 0]]
D, [2020-07-24T10:40:42.133913 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."id" IN ($1, $2, $3, $4, $5) [["id", 1], ["id", 2], ["id", 121], ["id", 118], ["id", 11]]
D, [2020-07-24T10:40:42.135361 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Body Load (0.0ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_type" = $1 AND "bodies"."bodyable_id" IN ($2, $3, $4, $5, $6) [["bodyable_type", "Message"], ["bodyable_id", 1], ["bodyable_id", 2], ["bodyable_id", 11], ["bodyable_id", 118], ["bodyable_id", 121]]
D, [2020-07-24T10:40:42.136878 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] UserMessage Load (4.2ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 [["user_id", 61]]
D, [2020-07-24T10:40:42.138525 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] UserMessage Load (0.7ms) SELECT "user_messages".* FROM "user_messages" WHERE "user_messages"."user_id" = $1 ORDER BY "user_messages"."id" ASC LIMIT $2 OFFSET $3 [["user_id", 61], ["LIMIT", 10], ["OFFSET", 0]]
D, [2020-07-24T10:40:42.139685 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."id" IN ($1, $2, $3, $4, $5) [["id", 1], ["id", 2], ["id", 121], ["id", 118], ["id", 11]]
D, [2020-07-24T10:40:42.140774 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Body Load (0.0ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_type" = $1 AND "bodies"."bodyable_id" IN ($2, $3, $4, $5, $6) [["bodyable_type", "Message"], ["bodyable_id", 1], ["bodyable_id", 2], ["bodyable_id", 11], ["bodyable_id", 118], ["bodyable_id", 121]]
D, [2020-07-24T10:40:42.142144 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Message Load (5.4ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.155337 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Option Load (2.0ms) SELECT "options".* FROM "options" WHERE "options"."message_id" = $1 [["message_id", 118]]
D, [2020-07-24T10:40:42.156500 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Option Load (1.5ms) SELECT "options".* FROM "options" WHERE "options"."message_id" = $1 [["message_id", 118]]
D, [2020-07-24T10:40:42.157684 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Body Load (1.3ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 103], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.159103 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Body Load (0.4ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 103], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.160106 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Body Load (1.5ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 104], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.161002 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.161997 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Body Load (2.0ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 104], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.162918 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.163573 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Option Load (2.0ms) SELECT "options".* FROM "options" WHERE "options"."message_id" = $1 [["message_id", 11]]
D, [2020-07-24T10:40:42.164947 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Option Load (1.4ms) SELECT "options".* FROM "options" WHERE "options"."message_id" = $1 [["message_id", 11]]
D, [2020-07-24T10:40:42.165984 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Body Load (1.4ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 1], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.167243 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Body Load (1.4ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 1], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.168218 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Body Load (1.3ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 2], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.169135 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.170116 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.171040 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.171962 #156] DEBUG -- : [987d8f80-7979-484f-932a-21eb9f248c5e] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
I, [2020-07-24T10:40:42.175506 #156] INFO -- : [987d8f80-7979-484f-932a-21eb9f248c5e] Completed 200 OK in 63ms (Views: 3.0ms | ActiveRecord: 33.5ms)
D, [2020-07-24T10:40:42.176536 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Body Load (8.4ms) SELECT "bodies".* FROM "bodies" WHERE "bodies"."bodyable_id" = $1 AND "bodies"."bodyable_type" = $2 LIMIT $3 [["bodyable_id", 2], ["bodyable_type", "Option"], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.177452 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.178426 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.179499 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
D, [2020-07-24T10:40:42.180495 #156] DEBUG -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] CACHE Message Load (0.0ms) SELECT "messages".* FROM "messages" WHERE "messages"."feature_type" = $1 AND "messages"."parent_message_id" IS NULL ORDER BY "messages"."id" ASC LIMIT $2 [["feature_type", 2], ["LIMIT", 1]]
I, [2020-07-24T10:40:42.184145 #156] INFO -- : [b84af1c7-5f37-49d2-a313-8ee2698f21a8] Completed 200 OK in 74ms (Views: 3.1ms | ActiveRecord: 39.0ms)
I, [2020-07-24T10:40:42.398788 #156] INFO -- : [8f0d65e9-786b-4513-8827-517104965b72] Started GET "/cable?access_token=eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjo2MSwiZXhwIjoxNjI1NzE4OTMzfQ.0K6xHr5Pyds2RNb_sUoplC0nGgpEidL0VP5DsmPK9ac" for 106.130.215.237 at 2020-07-24 10:40:42 +0900
I, [2020-07-24T10:40:42.399735 #156] INFO -- : [8f0d65e9-786b-4513-8827-517104965b72] Started GET "/cable/?access_token=eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjo2MSwiZXhwIjoxNjI1NzE4OTMzfQ.0K6xHr5Pyds2RNb_sUoplC0nGgpEidL0VP5DsmPK9ac" [WebSocket] for 106.130.215.237 at 2020-07-24 10:40:42 +0900
I, [2020-07-24T10:40:42.399843 #156] INFO -- : [8f0d65e9-786b-4513-8827-517104965b72] Successfully upgraded to WebSocket (REQUEST_METHOD: GET, HTTP_CONNECTION: Upgrade, HTTP_UPGRADE: websocket)
D, [2020-07-24T10:40:42.402105 #156] DEBUG -- : User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 61], ["LIMIT", 1]]
I, [2020-07-24T10:40:42.402683 #156] INFO -- : Registered connection (Z2lkOi8vbGluZS1tZWRpY2FsL1VzZXIvNjE)
I, [2020-07-24T10:40:42.489734 #156] INFO -- : MessageChannel is transmitting the subscription confirmation
I, [2020-07-24T10:40:42.490425 #156] INFO -- : MessageChannel is streaming from user_61_channel
I, [2020-07-24T10:40:45.538460 #156] INFO -- : Finished "/cable/?access_token=eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjo2MSwiZXhwIjoxNjI1NzE4OTMzfQ.0K6xHr5Pyds2RNb_sUoplC0nGgpEidL0VP5DsmPK9ac" [WebSocket] for 106.130.215.237 at 2020-07-24 10:40:45 +0900
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment