API tools faq
paste
Advertisement
srghma

Untitled

srghma
Aug 13th, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 43.20 KB | None | 0 0
raw download clone embed print report
  1. Started POST "/api/v2/gi/create" for 31.148.171.214 at 2018-08-13 13:16:17 +0000
  2. Processing by Api::V1::GiController#create as JSON
  3. Parameters: {"gi"=>{"project_id"=>"28da8029-b380-46d2-b8c4-5f9f5b4629e2", "name"=>"q", "date"=>"13/08/2018"}}
  4. Can't verify CSRF token authenticity.
  5. Account Load (0.8ms) SELECT "accounts".* FROM "accounts" INNER JOIN "auth_tokens" ON "auth_tokens"."account_id" = "accounts"."id" WHERE "accounts"."deleted_at" IS NULL AND "auth_tokens"."authentication_token" = $1 ORDER BY email ASC LIMIT $2 [["authentication_token", "C6yPxcPv52eCDb4kYzPS"], ["LIMIT", 1]]
  6. AuthToken Load (0.3ms) SELECT "auth_tokens".* FROM "auth_tokens" WHERE "auth_tokens"."account_id" = $1 LIMIT $2 [["account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["LIMIT", 1]]
  7. Visit Load (0.4ms) SELECT "visits".* FROM "visits" WHERE "visits"."id" = $1 ORDER BY "visits"."id" ASC LIMIT $2 [["id", "743101c2-817b-4cc5-8838-4c221733a85d"], ["LIMIT", 1]]
  8. (0.2ms) BEGIN
  9. SQL (0.4ms) UPDATE "accounts" SET "current_sign_in_at" = $1, "last_sign_in_at" = $2, "sign_in_count" = $3, "updated_at" = $4 WHERE "accounts"."id" = $5 [["current_sign_in_at", 2018-08-13 13:16:17 UTC], ["last_sign_in_at", 2018-08-13 13:12:21 UTC], ["sign_in_count", 675], ["updated_at", 2018-08-13 13:16:17 UTC], ["id", "13c3515d-d658-4af6-af62-26bc1b186215"]]
  10. (0.9ms) COMMIT
  11. (0.2ms) BEGIN
  12. SQL (0.4ms) UPDATE "auth_tokens" SET "expire_at" = $1, "updated_at" = $2 WHERE "auth_tokens"."id" = $3 [["expire_at", 2018-08-13 13:46:17 UTC], ["updated_at", 2018-08-13 13:16:17 UTC], ["id", "a24e502a-f02d-4964-89f8-ec5e654821fa"]]
  13. (1.0ms) COMMIT
  14. Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  15. ProjectAccount Load (0.4ms) SELECT "project_accounts".* FROM "project_accounts" WHERE "project_accounts"."deleted_at" IS NULL AND "project_accounts"."project_id" = $1 AND "project_accounts"."account_id" = $2 ORDER BY "project_accounts"."id" ASC LIMIT $3 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["LIMIT", 1]]
  16. ProjectRole Load (0.3ms) SELECT "project_roles".* FROM "project_roles" WHERE "project_roles"."id" = $1 LIMIT $2 [["id", "e4d3b0e3-905d-4895-a72d-285b1f2d0d00"], ["LIMIT", 1]]
  17. CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  18. ProjectAccount Load (0.4ms) SELECT "project_accounts".* FROM "project_accounts" WHERE "project_accounts"."deleted_at" IS NULL AND "project_accounts"."project_id" = '28da8029-b380-46d2-b8c4-5f9f5b4629e2' AND "project_accounts"."account_id" = '13c3515d-d658-4af6-af62-26bc1b186215' ORDER BY "project_accounts"."id" ASC LIMIT $1 [["LIMIT", 1]]
  19. CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  20. CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  21. (0.2ms) BEGIN
  22. SQL (0.6ms) INSERT INTO "general_inspection_entries" ("project_id", "name", "created_at", "updated_at", "date") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["name", "q"], ["created_at", 2018-08-13 13:16:17 UTC], ["updated_at", 2018-08-13 13:16:17 UTC], ["date", 2018-08-13 00:00:00 UTC]]
  23. Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  24. SQL (0.4ms) INSERT INTO "revisions" ("entity_id", "entity_name", "archived", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["entity_id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["entity_name", "GeneralInspectionEntry"], ["archived", false], ["created_at", 2018-08-13 13:16:17 UTC], ["updated_at", 2018-08-13 13:16:17 UTC]]
  25. (5.3ms) SELECT COUNT(*) FROM "revisions" WHERE "revisions"."entity_id" = $1 [["entity_id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"]]
  26. SQL (0.4ms) UPDATE "revisions" SET "id" = $1, "creator_account_id" = $2, "entity_id" = $3, "entity_name" = $4, "number" = $5, "created_timestamp" = $6, "archived" = $7, "created_at" = $8, "updated_at" = $9 WHERE "revisions"."id" = $10 [["id", "b3c1d5e8-5d6d-4761-954f-4160dc3c6464"], ["creator_account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["entity_id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["entity_name", "GeneralInspectionEntry"], ["number", 1], ["created_timestamp", 2018-08-13 13:16:17 UTC], ["archived", false], ["created_at", 2018-08-13 13:16:17 UTC], ["updated_at", 2018-08-13 13:16:17 UTC], ["id", "b3c1d5e8-5d6d-4761-954f-4160dc3c6464"]]
  27. SQL (0.4ms) UPDATE "projects" SET "updated_at" = '2018-08-13 13:16:17.563879' WHERE "projects"."id" = $1 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  28. (1.0ms) COMMIT
  29. Revision Load (5.3ms) SELECT "revisions".* FROM "revisions" WHERE "revisions"."entity_id" = $1 AND "revisions"."entity_name" = $2 ORDER BY created_at DESC LIMIT $3 [["entity_id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["entity_name", "GeneralInspectionEntry"], ["LIMIT", 1]]
  30. Account Load (0.5ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."deleted_at" IS NULL AND "accounts"."id" = $1 ORDER BY email ASC LIMIT $2 [["id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["LIMIT", 1]]
  31. User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."id" = $1 LIMIT $2 [["id", "defb2f9c-93f1-48c3-bea7-35aaa603299c"], ["LIMIT", 1]]
  32. ProjectCalculations Load (0.5ms) SELECT "project_calculations".* FROM "project_calculations" WHERE "project_calculations"."project_id" = $1 LIMIT $2 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  33. WasteEntry Load (0.4ms) SELECT "waste_entries".* FROM "waste_entries" WHERE "waste_entries"."deleted_at" IS NULL AND "waste_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  34. SustainableMaterialEntry Load (0.4ms) SELECT "sustainable_material_entries".* FROM "sustainable_material_entries" WHERE "sustainable_material_entries"."deleted_at" IS NULL AND "sustainable_material_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  35. SustainableMaterialEntryType Load (1.1ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "b2421bb7-6b95-4a05-855a-43d5f057d673"]]
  36. SustainableMaterialType Load (0.5ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  37. CustomField Load (0.5ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  38. CustomFieldValue Load (2.3ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "d8f04a34-3696-447b-84e6-2cea96cf6887"]]
  39. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "d8f04a34-3696-447b-84e6-2cea96cf6887"], ["entity_type", "SustainableMaterialEntryType"]]
  40. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "b5bdea96-dcb0-4e5c-974d-7c905a6f2033"], ["entity_type", "Comment"]]
  41. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "b5bdea96-dcb0-4e5c-974d-7c905a6f2033"], ["entity_type", "Comment"]]
  42. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "d8f04a34-3696-447b-84e6-2cea96cf6887"], ["entity_type", "SustainableMaterialEntryType"]]
  43. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "d8f04a34-3696-447b-84e6-2cea96cf6887"], ["entity_type", "SustainableMaterialEntryType"]]
  44. SustainableMaterialEntryType Load (0.9ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "589a766d-68e1-4e78-9d76-4fb8a55e236a"]]
  45. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  46. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  47. CustomFieldValue Load (1.8ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "0ec2e640-27ea-4551-b421-6b11a1c5f85d"]]
  48. Comment Load (0.7ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "0ec2e640-27ea-4551-b421-6b11a1c5f85d"], ["entity_type", "SustainableMaterialEntryType"]]
  49. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "cae1b330-2ab6-48a0-9666-67c167e9f8a2"], ["entity_type", "Comment"]]
  50. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "cae1b330-2ab6-48a0-9666-67c167e9f8a2"], ["entity_type", "Comment"]]
  51. (0.6ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "0ec2e640-27ea-4551-b421-6b11a1c5f85d"], ["entity_type", "SustainableMaterialEntryType"]]
  52. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "0ec2e640-27ea-4551-b421-6b11a1c5f85d"], ["entity_type", "SustainableMaterialEntryType"]]
  53. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "fbb0d13a-3686-4bf7-b274-6172bb56d13b"]]
  54. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  55. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  56. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "706e2170-8df3-448d-aa55-db27f37abcdc"]]
  57. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "706e2170-8df3-448d-aa55-db27f37abcdc"], ["entity_type", "SustainableMaterialEntryType"]]
  58. Image Load (0.5ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "4c3caee1-3c7b-4f90-966f-b5fc8e09bfba"], ["entity_type", "Comment"]]
  59. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "4c3caee1-3c7b-4f90-966f-b5fc8e09bfba"], ["entity_type", "Comment"]]
  60. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "706e2170-8df3-448d-aa55-db27f37abcdc"], ["entity_type", "SustainableMaterialEntryType"]]
  61. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "706e2170-8df3-448d-aa55-db27f37abcdc"], ["entity_type", "SustainableMaterialEntryType"]]
  62. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "08d95e55-e32e-45b0-b328-995ec1b69216"]]
  63. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  64. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  65. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "cee2673a-d2c9-41f0-83de-4eda814e9921"]]
  66. Comment Load (0.7ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "cee2673a-d2c9-41f0-83de-4eda814e9921"], ["entity_type", "SustainableMaterialEntryType"]]
  67. Image Load (0.5ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "81e851a5-241f-4201-be8e-f019f5689ad7"], ["entity_type", "Comment"]]
  68. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "81e851a5-241f-4201-be8e-f019f5689ad7"], ["entity_type", "Comment"]]
  69. (0.6ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "cee2673a-d2c9-41f0-83de-4eda814e9921"], ["entity_type", "SustainableMaterialEntryType"]]
  70. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "cee2673a-d2c9-41f0-83de-4eda814e9921"], ["entity_type", "SustainableMaterialEntryType"]]
  71. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "4be69a7c-82be-455c-b5a5-8e2ffc9ff0fe"]]
  72. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  73. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  74. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "aab84947-6098-4663-8776-ca88b876e4f6"]]
  75. Comment Load (0.7ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "aab84947-6098-4663-8776-ca88b876e4f6"], ["entity_type", "SustainableMaterialEntryType"]]
  76. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "ccb86231-48c0-48ae-a10b-dfc8a106ff53"], ["entity_type", "Comment"]]
  77. Attachment Load (0.3ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "ccb86231-48c0-48ae-a10b-dfc8a106ff53"], ["entity_type", "Comment"]]
  78. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "aab84947-6098-4663-8776-ca88b876e4f6"], ["entity_type", "SustainableMaterialEntryType"]]
  79. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "aab84947-6098-4663-8776-ca88b876e4f6"], ["entity_type", "SustainableMaterialEntryType"]]
  80. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "0ed1e229-0831-4804-80a4-8e357b63598d"]]
  81. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  82. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  83. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "febba056-1390-4bef-839b-35c000495a76"]]
  84. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "febba056-1390-4bef-839b-35c000495a76"], ["entity_type", "SustainableMaterialEntryType"]]
  85. Image Load (0.5ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "9f59305c-a283-41cb-a5eb-bf2214886029"], ["entity_type", "Comment"]]
  86. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "9f59305c-a283-41cb-a5eb-bf2214886029"], ["entity_type", "Comment"]]
  87. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "febba056-1390-4bef-839b-35c000495a76"], ["entity_type", "SustainableMaterialEntryType"]]
  88. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "febba056-1390-4bef-839b-35c000495a76"], ["entity_type", "SustainableMaterialEntryType"]]
  89. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "17937383-3c81-499c-acb8-5862b797f83b"]]
  90. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  91. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  92. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "43dc3ea9-83a2-48a1-8473-a11958ea305e"]]
  93. Comment Load (0.7ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "43dc3ea9-83a2-48a1-8473-a11958ea305e"], ["entity_type", "SustainableMaterialEntryType"]]
  94. Image Load (0.5ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "2e14b9bb-2023-4e65-9423-ea45391e7520"], ["entity_type", "Comment"]]
  95. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "2e14b9bb-2023-4e65-9423-ea45391e7520"], ["entity_type", "Comment"]]
  96. (0.6ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "43dc3ea9-83a2-48a1-8473-a11958ea305e"], ["entity_type", "SustainableMaterialEntryType"]]
  97. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "43dc3ea9-83a2-48a1-8473-a11958ea305e"], ["entity_type", "SustainableMaterialEntryType"]]
  98. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "df71f018-ad88-49c9-8d67-895917325cf8"]]
  99. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  100. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  101. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "6ccb6564-0769-483f-afb9-72e4c1bf6a14"]]
  102. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "6ccb6564-0769-483f-afb9-72e4c1bf6a14"], ["entity_type", "SustainableMaterialEntryType"]]
  103. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "4d41deea-f7fd-46c7-814c-dde15efb8983"], ["entity_type", "Comment"]]
  104. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "4d41deea-f7fd-46c7-814c-dde15efb8983"], ["entity_type", "Comment"]]
  105. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "6ccb6564-0769-483f-afb9-72e4c1bf6a14"], ["entity_type", "SustainableMaterialEntryType"]]
  106. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "6ccb6564-0769-483f-afb9-72e4c1bf6a14"], ["entity_type", "SustainableMaterialEntryType"]]
  107. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "33d57ba0-ecf3-4eb4-9b60-8b6e8fb0e7c7"]]
  108. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  109. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  110. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "5bf440cc-3966-415d-8e7b-f3353a348b32"]]
  111. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "5bf440cc-3966-415d-8e7b-f3353a348b32"], ["entity_type", "SustainableMaterialEntryType"]]
  112. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "b7259379-c466-4d1c-8ebe-24cb1a18d876"], ["entity_type", "Comment"]]
  113. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "b7259379-c466-4d1c-8ebe-24cb1a18d876"], ["entity_type", "Comment"]]
  114. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "5bf440cc-3966-415d-8e7b-f3353a348b32"], ["entity_type", "SustainableMaterialEntryType"]]
  115. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "5bf440cc-3966-415d-8e7b-f3353a348b32"], ["entity_type", "SustainableMaterialEntryType"]]
  116. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "0400bfe0-a090-4c93-931b-d2e4995a1dd8"]]
  117. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  118. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  119. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "d7fdff1c-b97e-4c58-80a2-e407d00d9b5e"]]
  120. Comment Load (0.7ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "d7fdff1c-b97e-4c58-80a2-e407d00d9b5e"], ["entity_type", "SustainableMaterialEntryType"]]
  121. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "57e1577f-d1c3-41d4-be99-99a3ac0e5a26"], ["entity_type", "Comment"]]
  122. Attachment Load (0.3ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "57e1577f-d1c3-41d4-be99-99a3ac0e5a26"], ["entity_type", "Comment"]]
  123. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "d7fdff1c-b97e-4c58-80a2-e407d00d9b5e"], ["entity_type", "SustainableMaterialEntryType"]]
  124. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "d7fdff1c-b97e-4c58-80a2-e407d00d9b5e"], ["entity_type", "SustainableMaterialEntryType"]]
  125. SustainableMaterialEntryType Load (0.8ms) SELECT "sustainable_material_entry_types".* FROM "sustainable_material_entry_types" WHERE "sustainable_material_entry_types"."deleted_at" IS NULL AND "sustainable_material_entry_types"."sustainable_material_entry_id" = $1 [["sustainable_material_entry_id", "e1a30b14-21d4-4f3e-8194-de365b77fef2"]]
  126. CACHE (0.0ms) SELECT "sustainable_material_types".* FROM "sustainable_material_types" WHERE "sustainable_material_types"."deleted_at" IS NULL AND "sustainable_material_types"."id" = $1 LIMIT $2 [["id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"], ["LIMIT", 1]]
  127. CACHE (0.0ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."deleted_at" IS NULL AND "custom_fields"."entity_id" = $1 [["entity_id", "70c2f241-195f-4364-a3b1-ed82ed7ad0a1"]]
  128. CustomFieldValue Load (1.7ms) SELECT "custom_field_values".* FROM "custom_field_values" WHERE "custom_field_values"."deleted_at" IS NULL AND "custom_field_values"."entity_id" = $1 [["entity_id", "7eb767db-1006-4375-b87b-7a236c63a3e1"]]
  129. Comment Load (0.8ms) SELECT "comments".* FROM "comments" WHERE "comments"."entity_id" = $1 AND "comments"."entity_type" = $2 [["entity_id", "7eb767db-1006-4375-b87b-7a236c63a3e1"], ["entity_type", "SustainableMaterialEntryType"]]
  130. Image Load (0.5ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "89d362a8-90e5-4174-9878-2a1a638c7795"], ["entity_type", "Comment"]]
  131. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "89d362a8-90e5-4174-9878-2a1a638c7795"], ["entity_type", "Comment"]]
  132. (0.7ms) SELECT COUNT(*) FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "7eb767db-1006-4375-b87b-7a236c63a3e1"], ["entity_type", "SustainableMaterialEntryType"]]
  133. (0.4ms) SELECT COUNT(*) FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "7eb767db-1006-4375-b87b-7a236c63a3e1"], ["entity_type", "SustainableMaterialEntryType"]]
  134. (77.7ms) SELECT COUNT(*) AS count_all, sustainable_material_types.type_code AS sustainable_material_types_type_code FROM "sustainable_material_entries" INNER JOIN "sustainable_material_entry_types" ON "sustainable_material_entry_types"."sustainable_material_entry_id" = "sustainable_material_entries"."id" AND "sustainable_material_entry_types"."deleted_at" IS NULL INNER JOIN "sustainable_material_types" ON "sustainable_material_types"."id" = "sustainable_material_entry_types"."sustainable_material_type_id" AND "sustainable_material_types"."deleted_at" IS NULL WHERE "sustainable_material_entries"."deleted_at" IS NULL AND "sustainable_material_entries"."project_id" = $1 GROUP BY sustainable_material_types.type_code [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  135. (0.5ms) SELECT COUNT(*) FROM "esc_entries" WHERE "esc_entries"."deleted_at" IS NULL AND "esc_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  136. (0.6ms) SELECT COUNT(*) FROM "esc_reports" WHERE "esc_reports"."deleted_at" IS NULL AND "esc_reports"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  137. VocEntry Load (0.5ms) SELECT "voc_entries".* FROM "voc_entries" WHERE "voc_entries"."deleted_at" IS NULL AND "voc_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  138. VocProduct Load (0.6ms) SELECT "products".* FROM "products" WHERE "products"."id" IN (32944, 8619, 8531, 1550, 32923, 32924, 32925, 32928, 32929, 32930, 32932, 8530)
  139. ProductCategory Load (0.5ms) SELECT "product_categories".* FROM "product_categories" WHERE "product_categories"."deleted_at" IS NULL AND (id IN ('5be3caa4-70f0-11e4-b6d8-7cd1c3ebff35','df411a1b-3056-4b8d-a12a-1dd15833bad9','5be3f770-70f0-11e4-a0e2-7cd1c3ebff35','5be3bf14-70f0-11e4-8572-7cd1c3ebff35'))
  140. ProductChanges Load (0.5ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 8619], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  141. ProductChanges Load (0.5ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 1550], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  142. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 1550], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  143. ProductChanges Load (0.5ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32928], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  144. ProductChanges Load (0.4ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32929], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  145. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32929], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  146. ProductChanges Load (0.5ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32930], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  147. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32930], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  148. ProductChanges Load (0.4ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32932], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  149. ProductChanges Load (0.4ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 8531], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  150. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 8531], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  151. ProductChanges Load (0.4ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32923], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  152. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32923], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  153. ProductChanges Load (0.5ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32924], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  154. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 32924], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  155. ProductChanges Load (0.4ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 8530], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  156. CACHE (0.0ms) SELECT "product_changes".* FROM "product_changes" WHERE "product_changes"."product_id" = $1 AND "product_changes"."project_id" = $2 LIMIT $3 [["product_id", 8530], ["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  157. VocEntry Exists (0.4ms) SELECT 1 AS one FROM "voc_entries" WHERE "voc_entries"."deleted_at" IS NULL AND "voc_entries"."project_id" = $1 LIMIT $2 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  158. (0.5ms) SELECT COUNT(*) FROM "iaq_entries" WHERE "iaq_entries"."deleted_at" IS NULL AND "iaq_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  159. (0.4ms) SELECT COUNT(*) FROM "general_inspection_entries" WHERE "general_inspection_entries"."deleted_at" IS NULL AND "general_inspection_entries"."project_id" = $1 [["project_id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  160. (0.2ms) BEGIN
  161. SQL (0.5ms) UPDATE "project_calculations" SET "general_inspections" = $1, "updated_at" = $2 WHERE "project_calculations"."id" = $3 [["general_inspections", 2], ["updated_at", 2018-08-13 13:16:18 UTC], ["id", 3]]
  162. SQL (0.4ms) UPDATE "projects" SET "updated_at" = '2018-08-13 13:16:18.063385' WHERE "projects"."id" = $1 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  163. (0.8ms) COMMIT
  164. Rendering defaults/response.json.rabl
  165. Rendered defaults/response.json.rabl (0.9ms)
  166. Completed 200 OK in 542ms (Views: 8.2ms | ActiveRecord: 186.9ms)
  167. Started POST "/api/v2/comment/create" for 31.148.171.214 at 2018-08-13 13:16:18 +0000
  168. Processing by Api::V1::CommentsController#create as JSON
  169. Parameters: {"text"=>"", "entity_name"=>"GeneralInspectionEntry", "entity_id"=>"0d3e895a-8994-4ed7-a9de-9af581ebc090", "comment"=>{"entity_id"=>"0d3e895a-8994-4ed7-a9de-9af581ebc090"}}
  170. Can't verify CSRF token authenticity.
  171. Account Load (0.8ms) SELECT "accounts".* FROM "accounts" INNER JOIN "auth_tokens" ON "auth_tokens"."account_id" = "accounts"."id" WHERE "accounts"."deleted_at" IS NULL AND "auth_tokens"."authentication_token" = $1 ORDER BY email ASC LIMIT $2 [["authentication_token", "C6yPxcPv52eCDb4kYzPS"], ["LIMIT", 1]]
  172. AuthToken Load (0.3ms) SELECT "auth_tokens".* FROM "auth_tokens" WHERE "auth_tokens"."account_id" = $1 LIMIT $2 [["account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["LIMIT", 1]]
  173. Visit Load (0.4ms) SELECT "visits".* FROM "visits" WHERE "visits"."id" = $1 ORDER BY "visits"."id" ASC LIMIT $2 [["id", "743101c2-817b-4cc5-8838-4c221733a85d"], ["LIMIT", 1]]
  174. (0.2ms) BEGIN
  175. SQL (0.4ms) UPDATE "accounts" SET "current_sign_in_at" = $1, "last_sign_in_at" = $2, "sign_in_count" = $3, "updated_at" = $4 WHERE "accounts"."id" = $5 [["current_sign_in_at", 2018-08-13 13:16:18 UTC], ["last_sign_in_at", 2018-08-13 13:16:17 UTC], ["sign_in_count", 676], ["updated_at", 2018-08-13 13:16:18 UTC], ["id", "13c3515d-d658-4af6-af62-26bc1b186215"]]
  176. (0.9ms) COMMIT
  177. (0.2ms) BEGIN
  178. SQL (0.4ms) UPDATE "auth_tokens" SET "expire_at" = $1, "updated_at" = $2 WHERE "auth_tokens"."id" = $3 [["expire_at", 2018-08-13 13:46:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC], ["id", "a24e502a-f02d-4964-89f8-ec5e654821fa"]]
  179. (0.7ms) COMMIT
  180. GeneralInspectionEntry Load (0.4ms) SELECT "general_inspection_entries".* FROM "general_inspection_entries" WHERE "general_inspection_entries"."deleted_at" IS NULL AND "general_inspection_entries"."id" = $1 ORDER BY created_at DESC LIMIT $2 [["id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["LIMIT", 1]]
  181. (0.2ms) BEGIN
  182. SQL (0.4ms) INSERT INTO "comments" ("entity_id", "entity_type", "comment", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["entity_id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["entity_type", "GeneralInspectionEntry"], ["comment", ""], ["created_at", 2018-08-13 13:16:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC]]
  183. GeneralInspectionEntry Load (0.4ms) SELECT "general_inspection_entries".* FROM "general_inspection_entries" WHERE "general_inspection_entries"."deleted_at" IS NULL AND "general_inspection_entries"."id" = $1 ORDER BY created_at DESC LIMIT $2 [["id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"], ["LIMIT", 1]]
  184. Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."deleted_at" IS NULL AND "projects"."id" = $1 GROUP BY projects.id LIMIT $2 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"], ["LIMIT", 1]]
  185. SQL (0.4ms) INSERT INTO "revisions" ("entity_id", "entity_name", "archived", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_name", "Comment"], ["archived", false], ["created_at", 2018-08-13 13:16:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC]]
  186. (5.3ms) SELECT COUNT(*) FROM "revisions" WHERE "revisions"."entity_id" = $1 [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"]]
  187. SQL (0.5ms) UPDATE "revisions" SET "id" = $1, "creator_account_id" = $2, "entity_id" = $3, "entity_name" = $4, "number" = $5, "created_timestamp" = $6, "archived" = $7, "created_at" = $8, "updated_at" = $9 WHERE "revisions"."id" = $10 [["id", "25e81759-082a-4a27-a5a1-734c1bfc89ce"], ["creator_account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_name", "Comment"], ["number", 1], ["created_timestamp", 2018-08-13 13:16:18 UTC], ["archived", false], ["created_at", 2018-08-13 13:16:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC], ["id", "25e81759-082a-4a27-a5a1-734c1bfc89ce"]]
  188. SQL (0.3ms) UPDATE "general_inspection_entries" SET "updated_at" = '2018-08-13 13:16:18.382789' WHERE "general_inspection_entries"."id" = $1 [["id", "0d3e895a-8994-4ed7-a9de-9af581ebc090"]]
  189. SQL (0.4ms) UPDATE "projects" SET "updated_at" = '2018-08-13 13:16:18.397152' WHERE "projects"."id" = $1 [["id", "28da8029-b380-46d2-b8c4-5f9f5b4629e2"]]
  190. (1.1ms) COMMIT
  191. (0.2ms) BEGIN
  192. SQL (0.4ms) INSERT INTO "revisions" ("entity_id", "entity_name", "archived", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_name", "Comment"], ["archived", false], ["created_at", 2018-08-13 13:16:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC]]
  193. (4.9ms) SELECT COUNT(*) FROM "revisions" WHERE "revisions"."entity_id" = $1 [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"]]
  194. SQL (0.4ms) UPDATE "revisions" SET "id" = $1, "creator_account_id" = $2, "entity_id" = $3, "entity_name" = $4, "number" = $5, "created_timestamp" = $6, "archived" = $7, "created_at" = $8, "updated_at" = $9 WHERE "revisions"."id" = $10 [["id", "ae4b6641-5a5a-436c-9058-570d3637206f"], ["creator_account_id", "13c3515d-d658-4af6-af62-26bc1b186215"], ["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_name", "Comment"], ["number", 2], ["created_timestamp", 2018-08-13 13:16:18 UTC], ["archived", false], ["created_at", 2018-08-13 13:16:18 UTC], ["updated_at", 2018-08-13 13:16:18 UTC], ["id", "ae4b6641-5a5a-436c-9058-570d3637206f"]]
  195. (1.0ms) COMMIT
  196. Image Load (0.6ms) SELECT "images".* FROM "images" WHERE "images"."entity_id" = $1 AND "images"."entity_type" = $2 [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_type", "Comment"]]
  197. Attachment Load (0.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."entity_id" = $1 AND "attachments"."entity_type" = $2 [["entity_id", "581cb1c6-a306-401a-8f35-0c7ae74145f8"], ["entity_type", "Comment"]]
  198. Rendering defaults/response.json.rabl
  199. Rendered defaults/response.json.rabl (0.8ms)
  200. Completed 200 OK in 79ms (Views: 7.6ms | ActiveRecord: 22.0ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!