Skip to content

Instantly share code, notes, and snippets.

@bschaeffer

bschaeffer/gist:11385068

Created April 28, 2014 21:50
Show Gist options
  • Save bschaeffer/11385068 to your computer and use it in GitHub Desktop.
Save bschaeffer/11385068 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
17:46:20 web.1 | Started GET "/" for 127.0.0.1 at 2014-04-28 17:46:20 -0400
17:46:20 web.1 | Processing by IndexController#index as HTML
17:46:20 web.1 | User Load (25.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 6 ORDER BY "users"."id" ASC LIMIT 1
17:46:21 web.1 | Account Load (24.9ms) SELECT "accounts".* FROM "accounts" INNER JOIN "account_memberships" ON "accounts"."id" = "account_memberships"."account_id" WHERE "account_memberships"."user_id" = $1 [["user_id", 6]]
17:46:21 web.1 | AccountMembership Load (0.8ms) SELECT "account_memberships".* FROM "account_memberships" WHERE "account_memberships"."user_id" = $1 [["user_id", 6]]
17:46:21 web.1 | User Load (1.0ms) SELECT "users".* FROM "users" INNER JOIN "account_memberships" ON "users"."id" = "account_memberships"."user_id" WHERE "account_memberships"."account_id" = $1 [["account_id", 2]]
17:46:21 web.1 | CACHE (0.1ms) SELECT "accounts".* FROM "accounts" INNER JOIN "account_memberships" ON "accounts"."id" = "account_memberships"."account_id" WHERE "account_memberships"."user_id" = $1 [["user_id", 6]]
17:46:21 web.1 | User Load (0.8ms) SELECT "users".* FROM "users" INNER JOIN "account_memberships" ON "users"."id" = "account_memberships"."user_id" WHERE "account_memberships"."account_id" = $1 [["account_id", 5]]
17:46:21 web.1 | Check Load (22.8ms) SELECT "checks".* FROM "checks" WHERE "checks"."account_id" = $1 [["account_id", 5]]
17:46:21 web.1 | User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:21 web.1 | User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 18]]
17:46:21 web.1 | Account Load (0.6ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:21 web.1 | Step Load (0.6ms) SELECT "steps".* FROM "steps" WHERE "steps"."check_id" = $1 [["check_id", 26]]
17:46:21 web.1 | Position Load (1.5ms) SELECT "positions".* FROM "positions" WHERE "positions"."check_id" = $1 [["check_id", 26]]
17:46:21 web.1 | Verification Load (0.8ms) SELECT "verifications".* FROM "verifications" WHERE "verifications"."id" = $1 ORDER BY "verifications"."id" ASC LIMIT 1 [["id", 52]]
17:46:21 web.1 | Check Load (0.8ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 26]]
17:46:21 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:21 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 18]]
17:46:21 web.1 | Organization Load (10.0ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."id" = $1 ORDER BY "organizations"."id" ASC LIMIT 1 [["id", 38430]]
17:46:22 web.1 | HrContact Load (0.9ms) SELECT "hr_contacts".* FROM "hr_contacts" WHERE "hr_contacts"."id" = $1 ORDER BY "hr_contacts"."id" ASC LIMIT 1 [["id", 22]]
17:46:22 web.1 | Degree Load (1.0ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."check_id" = $1 [["check_id", 26]]
17:46:22 web.1 | Reference Load (1.6ms) SELECT "references".* FROM "references" WHERE "references"."check_id" = $1 [["check_id", 26]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 18]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | Step Load (0.4ms) SELECT "steps".* FROM "steps" WHERE "steps"."check_id" = $1 [["check_id", 19]]
17:46:22 web.1 | Position Load (0.4ms) SELECT "positions".* FROM "positions" WHERE "positions"."check_id" = $1 [["check_id", 19]]
17:46:22 web.1 | Verification Load (0.5ms) SELECT "verifications".* FROM "verifications" WHERE "verifications"."id" = $1 ORDER BY "verifications"."id" ASC LIMIT 1 [["id", 41]]
17:46:22 web.1 | Check Load (0.5ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 19]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."id" = $1 ORDER BY "organizations"."id" ASC LIMIT 1 [["id", 38430]]
17:46:22 web.1 | HrContact Load (0.5ms) SELECT "hr_contacts".* FROM "hr_contacts" WHERE "hr_contacts"."id" = $1 ORDER BY "hr_contacts"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | Degree Load (0.5ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."check_id" = $1 [["check_id", 19]]
17:46:22 web.1 | Verification Load (0.6ms) SELECT "verifications".* FROM "verifications" WHERE "verifications"."id" = $1 ORDER BY "verifications"."id" ASC LIMIT 1 [["id", 43]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 19]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | Organization Load (0.6ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."id" = $1 ORDER BY "organizations"."id" ASC LIMIT 1 [["id", 38431]]
17:46:22 web.1 | Reference Load (0.8ms) SELECT "references".* FROM "references" WHERE "references"."check_id" = $1 [["check_id", 19]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 16]]
17:46:22 web.1 | User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 4]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | Step Load (0.4ms) SELECT "steps".* FROM "steps" WHERE "steps"."check_id" = $1 [["check_id", 21]]
17:46:22 web.1 | Position Load (0.5ms) SELECT "positions".* FROM "positions" WHERE "positions"."check_id" = $1 [["check_id", 21]]
17:46:22 web.1 | Degree Load (0.3ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."check_id" = $1 [["check_id", 21]]
17:46:22 web.1 | Reference Load (0.5ms) SELECT "references".* FROM "references" WHERE "references"."check_id" = $1 [["check_id", 21]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | Check Load (0.6ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 21]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | AccountMembership Load (0.8ms) SELECT "account_memberships".* FROM "account_memberships" WHERE "account_memberships"."account_id" = $1 [["account_id", 5]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 5]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "account_memberships".* FROM "account_memberships" WHERE "account_memberships"."user_id" = $1 [["user_id", 6]]
17:46:22 web.1 | Account Load (0.7ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:22 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:22 web.1 | Check Load (23.3ms) SELECT "checks".* FROM "checks" WHERE "checks"."user_id" = $1 AND ("checks"."state" != 'incomplete') [["user_id", 6]]
17:46:22 web.1 | Identity Load (1.0ms) SELECT "identities".* FROM "identities" WHERE "identities"."user_id" = $1 [["user_id", 6]]
17:46:22 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | Position Load (0.8ms) SELECT "positions".* FROM "positions" WHERE "positions"."user_id" = $1 AND ("positions"."state" != 'incomplete') [["user_id", 6]]
17:46:23 web.1 | Degree Load (1.1ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."user_id" = $1 AND ("degrees"."state" != 'incomplete') [["user_id", 6]]
17:46:23 web.1 | Reference Load (1.1ms) SELECT "references".* FROM "references" WHERE "references"."user_id" = $1 [["user_id", 6]]
17:46:23 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | Reference Load (0.9ms) SELECT "references".* FROM "references" WHERE "references"."provider_id" = $1 [["provider_id", 6]]
17:46:23 web.1 | Check Load (0.4ms) SELECT "checks".* FROM "checks" WHERE "checks"."account_id" = $1 [["account_id", 2]]
17:46:23 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | Step Load (0.4ms) SELECT "steps".* FROM "steps" WHERE "steps"."check_id" = $1 [["check_id", 38]]
17:46:23 web.1 | Position Load (0.3ms) SELECT "positions".* FROM "positions" WHERE "positions"."check_id" = $1 [["check_id", 38]]
17:46:23 web.1 | Degree Load (0.3ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."check_id" = $1 [["check_id", 38]]
17:46:23 web.1 | Reference Load (0.4ms) SELECT "references".* FROM "references" WHERE "references"."check_id" = $1 [["check_id", 38]]
17:46:23 web.1 | CACHE (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | Step Load (0.4ms) SELECT "steps".* FROM "steps" WHERE "steps"."check_id" = $1 [["check_id", 33]]
17:46:23 web.1 | Position Load (0.5ms) SELECT "positions".* FROM "positions" WHERE "positions"."check_id" = $1 [["check_id", 33]]
17:46:23 web.1 | Check Load (0.4ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 33]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | HrContact Load (0.3ms) SELECT "hr_contacts".* FROM "hr_contacts" WHERE "hr_contacts"."id" = $1 ORDER BY "hr_contacts"."id" ASC LIMIT 1 [["id", 24]]
17:46:23 web.1 | Degree Load (0.4ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."check_id" = $1 [["check_id", 33]]
17:46:23 web.1 | CACHE (0.1ms) SELECT "checks".* FROM "checks" WHERE "checks"."id" = $1 ORDER BY "checks"."id" ASC LIMIT 1 [["id", 33]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | Reference Load (0.6ms) SELECT "references".* FROM "references" WHERE "references"."check_id" = $1 [["check_id", 33]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | AccountMembership Load (0.3ms) SELECT "account_memberships".* FROM "account_memberships" WHERE "account_memberships"."account_id" = $1 [["account_id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 ORDER BY "accounts"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "checks".* FROM "checks" WHERE "checks"."user_id" = $1 AND ("checks"."state" != 'incomplete') [["user_id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "identities".* FROM "identities" WHERE "identities"."user_id" = $1 [["user_id", 6]]
17:46:23 web.1 | CACHE (0.1ms) SELECT "positions".* FROM "positions" WHERE "positions"."user_id" = $1 AND ("positions"."state" != 'incomplete') [["user_id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "degrees".* FROM "degrees" WHERE "degrees"."user_id" = $1 AND ("degrees"."state" != 'incomplete') [["user_id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "references".* FROM "references" WHERE "references"."user_id" = $1 [["user_id", 6]]
17:46:23 web.1 | CACHE (0.0ms) SELECT "references".* FROM "references" WHERE "references"."provider_id" = $1 [["provider_id", 6]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment