API tools faq
paste
Advertisement
Varholl

Untitled

Varholl
Nov 23rd, 2017
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 36.77 KB | None | 0 0
raw download clone embed print report
  1. Case Load (1.1ms) SELECT "cases".* FROM "cases" ORDER BY "cases"."id" ASC LIMIT 1
  2. Decedent Load (0.5ms) SELECT "decedents".* FROM "decedents" WHERE "decedents"."case_id" IN (81)
  3. Acquaintance Load (0.4ms) SELECT "acquaintances".* FROM "acquaintances" WHERE "acquaintances"."decedent_id" IN (81) ORDER BY acquaintances.sort_order, acquaintances.id
  4. AcquaintanceTypeAcquaintance Load (0.3ms) SELECT "acquaintance_types_acquaintances".* FROM "acquaintance_types_acquaintances" WHERE "acquaintance_types_acquaintances"."acquaintance_id" IN (171, 172, 192, 193)
  5. AcquaintanceType Load (0.2ms) SELECT "acquaintance_types".* FROM "acquaintance_types" WHERE "acquaintance_types"."id" IN (3, 1, 2, 6)
  6. Payment Load (0.6ms) SELECT "payments".* FROM "payments" WHERE "payments"."case_id" IN (81)
  7. InsuranceAssignment Load (2.6ms) SELECT "insurance_assignments".* FROM "insurance_assignments" WHERE "insurance_assignments"."case_id" IN (81)
  8. Refund Load (0.3ms) SELECT "refunds".* FROM "refunds" WHERE "refunds"."case_id" IN (81)
  9. Branch Load (0.4ms) SELECT "branches".* FROM "branches" WHERE "branches"."deleted" = 'f' AND "branches"."id" IN (9) ORDER BY substring(branches.name FROM '^\d+')::int, lower(branches.name)
  10. Organization Load (0.3ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."deleted" = 'f' AND "organizations"."id" IN (2)
  11. Cases::Contract Load (0.3ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."case_id" IN (81)
  12. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE "cases_contract_line_items"."parent_type" = 'Cases::Contract' AND "cases_contract_line_items"."parent_id" IN ('edc8c438-f714-4e3b-b5e6-cf407b91ccea') ORDER BY created_at
  13. Payment Load (11.1ms) SELECT "payments".* FROM "payments" WHERE "payments"."case_id" = $1 AND "payments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from payments where reversal_id IS NOT NULL)) [["case_id", 81]]
  14. InsuranceAssignment Load (0.4ms) SELECT "insurance_assignments".* FROM "insurance_assignments" WHERE "insurance_assignments"."case_id" = $1 AND "insurance_assignments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from insurance_assignments where reversal_id IS NOT NULL)) [["case_id", 81]]
  15. Interest Load (0.4ms) SELECT "interests".* FROM "interests" WHERE "interests"."case_id" = $1 AND "interests"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from interests where reversal_id IS NOT NULL)) [["case_id", 81]]
  16. Refund Load (0.3ms) SELECT "refunds".* FROM "refunds" WHERE "refunds"."case_id" = $1 AND "refunds"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from refunds where reversal_id IS NOT NULL)) [["case_id", 81]]
  17. Adjustment Load (0.2ms) SELECT "adjustments".* FROM "adjustments" WHERE "adjustments"."case_id" = $1 AND "adjustments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from adjustments where reversal_id IS NOT NULL)) [["case_id", 81]]
  18. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  19. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  20. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  21. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  22. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  23. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  24. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  25. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  26. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  27. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  28. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  29. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  30. Cases::Contract Load (0.3ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  31. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  32. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  33. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  34. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  35. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  36. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  37. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  38. Payment Load (11.1ms) SELECT "payments".* FROM "payments" WHERE "payments"."case_id" = $1 AND "payments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from payments where reversal_id IS NOT NULL)) [["case_id", 81]]
  39. InsuranceAssignment Load (0.2ms) SELECT "insurance_assignments".* FROM "insurance_assignments" WHERE "insurance_assignments"."case_id" = $1 AND "insurance_assignments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from insurance_assignments where reversal_id IS NOT NULL)) [["case_id", 81]]
  40. Interest Load (0.1ms) SELECT "interests".* FROM "interests" WHERE "interests"."case_id" = $1 AND "interests"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from interests where reversal_id IS NOT NULL)) [["case_id", 81]]
  41. Refund Load (0.1ms) SELECT "refunds".* FROM "refunds" WHERE "refunds"."case_id" = $1 AND "refunds"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from refunds where reversal_id IS NOT NULL)) [["case_id", 81]]
  42. Adjustment Load (0.1ms) SELECT "adjustments".* FROM "adjustments" WHERE "adjustments"."case_id" = $1 AND "adjustments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from adjustments where reversal_id IS NOT NULL)) [["case_id", 81]]
  43. (0.3ms) SELECT COUNT(*) FROM "insurance_assignments" WHERE "insurance_assignments"."case_id" = $1 AND (id NOT IN (SELECT DISTINCT(reversal_id) from insurance_assignments where reversal_id IS NOT NULL)) AND "insurance_assignments"."reversed_on" IS NULL AND "insurance_assignments"."payment_date" IS NULL [["case_id", 81]]
  44. Cases::Identifiers::Identifier Load (0.2ms) SELECT "cases_identifiers_identifiers".* FROM "cases_identifiers_identifiers" WHERE "cases_identifiers_identifiers"."case_id" = $1 AND "cases_identifiers_identifiers"."current" = 't' LIMIT 1 [["case_id", 81]]
  45. Cases::Identifiers::Segment Load (0.2ms) SELECT "cases_identifiers_segments".* FROM "cases_identifiers_segments" WHERE "cases_identifiers_segments"."identifier_id" = $1 ORDER BY id [["identifier_id", 1341]]
  46. Payment Load (9.3ms) SELECT "payments".* FROM "payments" WHERE "payments"."case_id" = $1 AND "payments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from payments where reversal_id IS NOT NULL)) [["case_id", 81]]
  47. InsuranceAssignment Load (0.2ms) SELECT "insurance_assignments".* FROM "insurance_assignments" WHERE "insurance_assignments"."case_id" = $1 AND "insurance_assignments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from insurance_assignments where reversal_id IS NOT NULL)) [["case_id", 81]]
  48. Interest Load (0.2ms) SELECT "interests".* FROM "interests" WHERE "interests"."case_id" = $1 AND "interests"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from interests where reversal_id IS NOT NULL)) [["case_id", 81]]
  49. Refund Load (0.1ms) SELECT "refunds".* FROM "refunds" WHERE "refunds"."case_id" = $1 AND "refunds"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from refunds where reversal_id IS NOT NULL)) [["case_id", 81]]
  50. Adjustment Load (0.2ms) SELECT "adjustments".* FROM "adjustments" WHERE "adjustments"."case_id" = $1 AND "adjustments"."reversal_id" IS NULL AND (id NOT IN (SELECT DISTINCT(reversal_id) from adjustments where reversal_id IS NOT NULL)) [["case_id", 81]]
  51. Rolodex::CaseEntry Load (0.3ms) SELECT "rolodex_case_entries".* FROM "rolodex_case_entries" WHERE "rolodex_case_entries"."id" = $1 LIMIT 1 [["id", 3]]
  52. Cases::SerialNumber Load (0.2ms) SELECT "cases_serial_numbers".* FROM "cases_serial_numbers" WHERE "cases_serial_numbers"."case_id" = $1 ORDER BY "cases_serial_numbers"."created_at" ASC, "cases_serial_numbers"."id" ASC [["case_id", 81]]
  53. Cases::SerialNumber Load (0.1ms) SELECT "cases_serial_numbers".* FROM "cases_serial_numbers" WHERE "cases_serial_numbers"."case_id" = $1 ORDER BY "cases_serial_numbers"."created_at" ASC, "cases_serial_numbers"."id" ASC [["case_id", 81]]
  54. Cases::SerialNumber Load (0.2ms) SELECT "cases_serial_numbers".* FROM "cases_serial_numbers" WHERE "cases_serial_numbers"."case_id" = $1 ORDER BY "cases_serial_numbers"."created_at" ASC, "cases_serial_numbers"."id" ASC [["case_id", 81]]
  55. Appointment Load (0.3ms) SELECT "appointments".* FROM "appointments" WHERE "appointments"."case_id" = $1 AND "appointments"."appointment_type" = 2 LIMIT 1 [["case_id", 81]]
  56. (0.2ms) SELECT COUNT(*) FROM "payments" WHERE "payments"."case_id" = $1 AND "payments"."exported_on" IS NULL [["case_id", 81]]
  57. ArrangementAccessToken Load (0.2ms) SELECT "arrangement_access_tokens"."id", "arrangement_access_tokens"."grantor_id", "arrangement_access_tokens"."grantor_type", "arrangement_access_tokens"."created_at" FROM "arrangement_access_tokens" WHERE "arrangement_access_tokens"."case_id" = $1 AND "arrangement_access_tokens"."grantor_type" = 'User' [["case_id", 81]]
  58. CareCenter::Case Load (0.2ms) SELECT "care_center_cases".* FROM "care_center_cases" WHERE "care_center_cases"."case_id" = $1 LIMIT 1 [["case_id", 81]]
  59. ClientServiceType Load (0.2ms) SELECT "client_service_types".* FROM "client_service_types" WHERE "client_service_types"."deleted" = 'f' AND "client_service_types"."id" = $1 LIMIT 1 [["id", 6]]
  60. CaseAssignedUser Load (0.2ms) SELECT "case_assigned_users".* FROM "case_assigned_users" WHERE "case_assigned_users"."case_id" = $1 [["case_id", 81]]
  61. User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."type" = 'User' AND "users"."id" = $1 LIMIT 1 [["id", 35]]
  62. Veteran Load (0.3ms) SELECT "veterans".* FROM "veterans" WHERE "veterans"."decedent_id" = $1 LIMIT 1 [["decedent_id", 81]]
  63. Person Load (0.2ms) SELECT "people".* FROM "people" WHERE "people"."id" = $1 LIMIT 1 [["id", 3]]
  64. SQL (0.8ms) SELECT DISTINCT "acquaintances"."id", acquaintances.sort_order, acquaintances.id AS alias_0 FROM "acquaintances" INNER JOIN "acquaintance_types_acquaintances" ON "acquaintance_types_acquaintances"."acquaintance_id" = "acquaintances"."id" INNER JOIN "acquaintance_types" ON "acquaintance_types"."id" = "acquaintance_types_acquaintances"."acquaintance_type_id" WHERE "acquaintances"."decedent_id" = $1 AND "acquaintance_types"."id" = 1 ORDER BY acquaintances.sort_order, acquaintances.id LIMIT 1 [["decedent_id", 81]]
  65. SQL (0.7ms) SELECT "acquaintances"."id" AS t0_r0, "acquaintances"."first_name" AS t0_r1, "acquaintances"."middle_name" AS t0_r2, "acquaintances"."last_name" AS t0_r3, "acquaintances"."last_name_at_birth" AS t0_r4, "acquaintances"."suffix" AS t0_r5, "acquaintances"."is_deceased" AS t0_r6, "acquaintances"."created_at" AS t0_r7, "acquaintances"."updated_at" AS t0_r8, "acquaintances"."address_id" AS t0_r9, "acquaintances"."contact_information_id" AS t0_r10, "acquaintances"."decedent_id" AS t0_r11, "acquaintances"."relationship" AS t0_r12, "acquaintances"."wedding_date" AS t0_r13, "acquaintances"."wedding_place" AS t0_r14, "acquaintances"."date_of_death" AS t0_r15, "acquaintances"."place_of_death" AS t0_r16, "acquaintances"."place_of_burial" AS t0_r17, "acquaintances"."ssn" AS t0_r18, "acquaintances"."medical_service_provider_id" AS t0_r19, "acquaintances"."encrypted_ssn" AS t0_r20, "acquaintances"."front_end_id" AS t0_r21, "acquaintances"."birth_date" AS t0_r22, "acquaintances"."case_caller" AS t0_r23, "acquaintances"."service_provider_id" AS t0_r24, "acquaintances"."visible_on" AS t0_r25, "acquaintances"."client_id" AS t0_r26, "acquaintances"."relationship_type_id" AS t0_r27, "acquaintances"."title" AS t0_r28, "acquaintances"."spouse_acquaintance_id" AS t0_r29, "acquaintances"."preferred_name" AS t0_r30, "acquaintances"."place_of_birth_address_id" AS t0_r31, "acquaintances"."sort_order" AS t0_r32, "acquaintance_types"."id" AS t1_r0, "acquaintance_types"."name" AS t1_r1, "acquaintance_types"."created_at" AS t1_r2, "acquaintance_types"."updated_at" AS t1_r3 FROM "acquaintances" INNER JOIN "acquaintance_types_acquaintances" ON "acquaintance_types_acquaintances"."acquaintance_id" = "acquaintances"."id" INNER JOIN "acquaintance_types" ON "acquaintance_types"."id" = "acquaintance_types_acquaintances"."acquaintance_type_id" WHERE "acquaintances"."decedent_id" = $1 AND "acquaintance_types"."id" = 1 AND "acquaintances"."id" IN (172) ORDER BY acquaintances.sort_order, acquaintances.id [["decedent_id", 81]]
  66. CaseNote Load (0.3ms) SELECT "notes".* FROM "notes" WHERE "notes"."deleted" = 'f' AND "notes"."deleted" = 'f' AND "notes"."type" IN ('CaseNote') AND "notes"."resource_id" = $1 AND "notes"."case_note_type" = 'vital_stats' [["resource_id", 81]]
  67. SQL (0.6ms) SELECT DISTINCT "acquaintances"."id", acquaintances.sort_order, acquaintances.id AS alias_0 FROM "acquaintances" INNER JOIN "acquaintance_types_acquaintances" ON "acquaintance_types_acquaintances"."acquaintance_id" = "acquaintances"."id" INNER JOIN "acquaintance_types" ON "acquaintance_types"."id" = "acquaintance_types_acquaintances"."acquaintance_type_id" WHERE "acquaintances"."decedent_id" = $1 AND "acquaintance_types"."id" = 9 ORDER BY acquaintances.sort_order, acquaintances.id LIMIT 1 [["decedent_id", 81]]
  68. DeathCause Load (0.2ms) SELECT "death_causes".* FROM "death_causes" WHERE "death_causes"."decedent_id" = $1 ORDER BY "death_causes"."id" ASC [["decedent_id", 81]]
  69. DecedentSetting Load (0.3ms) SELECT "decedent_settings".* FROM "decedent_settings" WHERE "decedent_settings"."id" = $1 AND "decedent_settings"."item_type" = 'ethnicity' LIMIT 1 [["id", 257]]
  70. DecedentSetting Load (0.2ms) SELECT "decedent_settings".* FROM "decedent_settings" WHERE "decedent_settings"."id" = $1 AND "decedent_settings"."item_type" = 'race' LIMIT 1 [["id", 279]]
  71. DecedentSetting Load (0.3ms) SELECT "decedent_settings".* FROM "decedent_settings" WHERE "decedent_settings"."id" = $1 AND "decedent_settings"."item_type" = 'education' LIMIT 1 [["id", 283]]
  72. Rolodex::CaseOrganization Load (0.3ms) SELECT "rolodex_case_entries".* FROM "rolodex_case_entries" WHERE "rolodex_case_entries"."type" IN ('Rolodex::CaseOrganization') AND "rolodex_case_entries"."id" = $1 LIMIT 1 [["id", 1]]
  73. Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 6846]]
  74. Address Load (0.1ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 39038]]
  75. Address Load (0.1ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 40530]]
  76. Rolodex::CasePersonEntry Load (0.1ms) SELECT "rolodex_case_entries".* FROM "rolodex_case_entries" WHERE "rolodex_case_entries"."type" IN ('Rolodex::CasePersonEntry') AND "rolodex_case_entries"."id" = $1 LIMIT 1 [["id", 11]]
  77. Person Load (0.2ms) SELECT "people".* FROM "people" WHERE "people"."id" = $1 LIMIT 1 [["id", 28863]]
  78. ContactInformation Load (0.1ms) SELECT "contact_informations".* FROM "contact_informations" WHERE "contact_informations"."id" = $1 LIMIT 1 [["id", 1196671]]
  79. PhoneNumber Load (0.2ms) SELECT "phone_numbers".* FROM "phone_numbers" WHERE "phone_numbers"."contact_information_id" = $1 ORDER BY "phone_numbers"."rank" ASC [["contact_information_id", 1196671]]
  80. Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 1427229]]
  81. Rolodex::CasePersonEntry Load (0.2ms) SELECT "rolodex_case_entries".* FROM "rolodex_case_entries" WHERE "rolodex_case_entries"."type" IN ('Rolodex::CasePersonEntry') AND "rolodex_case_entries"."id" = $1 LIMIT 1 [["id", 12]]
  82. Person Load (0.1ms) SELECT "people".* FROM "people" WHERE "people"."id" = $1 LIMIT 1 [["id", 28864]]
  83. ContactInformation Load (0.2ms) SELECT "contact_informations".* FROM "contact_informations" WHERE "contact_informations"."id" = $1 LIMIT 1 [["id", 1196672]]
  84. PhoneNumber Load (0.2ms) SELECT "phone_numbers".* FROM "phone_numbers" WHERE "phone_numbers"."contact_information_id" = $1 ORDER BY "phone_numbers"."rank" ASC [["contact_information_id", 1196672]]
  85. Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 1427230]]
  86. Cases::Addendum Load (0.3ms) SELECT "cases_addendums".* FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND ("cases_addendums"."signed_at" IS NOT NULL) ORDER BY signed_at DESC LIMIT 1 [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  87. Cases::Addendum Load (0.3ms) SELECT "cases_addendums".* FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 'f' ORDER BY created_at LIMIT 1 [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  88. (0.2ms) SELECT COUNT(*) FROM "cases_contract_line_items" WHERE "cases_contract_line_items"."parent_id" = $1 AND "cases_contract_line_items"."parent_type" = $2 [["parent_id", "c0f702e7-2c37-4c13-ac7e-98ab518d32a5"], ["parent_type", "Cases::Addendum"]]
  89. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  90. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  91. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  92. Cases::ContractLineItem Load (0.6ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  93. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  94. Cases::ContractLineItem Load (0.6ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  95. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  96. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  97. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  98. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  99. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  100. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  101. (0.5ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  102. Cases::ContractLineItem Load (1.3ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  103. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  104. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  105. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  106. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  107. Cases::Contract Load (0.5ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  108. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  109. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  110. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  111. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  112. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  113. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  114. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  115. Cases::Contract Load (0.8ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  116. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  117. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  118. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  119. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  120. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  121. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  122. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  123. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  124. Cases::Contract Load (0.3ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  125. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  126. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  127. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  128. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  129. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  130. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  131. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  132. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  133. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  134. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  135. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  136. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  137. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  138. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  139. Cases::Contract Load (0.1ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  140. Cases::Contract Load (0.2ms) SELECT "cases_contracts".* FROM "cases_contracts" WHERE "cases_contracts"."id" = $1 LIMIT 1 [["id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  141. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  142. Cases::ContractLineItem Load (0.4ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) AND ("cases_contract_line_items"."tax_schedule_id" IS NOT NULL) ORDER BY "cases_contract_line_items"."parent_type" DESC
  143. (0.1ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  144. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) AND "cases_contract_line_items"."tax_schedule_id" IS NULL ORDER BY "cases_contract_line_items"."parent_type" DESC
  145. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  146. Cases::ContractLineItem Load (0.6ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) AND ("cases_contract_line_items"."tax_schedule_id" IS NOT NULL) ORDER BY "cases_contract_line_items"."parent_type" DESC
  147. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 ORDER BY created_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  148. Cases::ContractLineItem Load (0.8ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR "cases_contract_line_items"."parent_id" IN ('c0f702e7-2c37-4c13-ac7e-98ab518d32a5') AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) AND "cases_contract_line_items"."tax_schedule_id" IS NULL AND "cases_contract_line_items"."cash_advance" = 't' ORDER BY "cases_contract_line_items"."parent_type" DESC
  149. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  150. Cases::ContractLineItem Load (0.5ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) AND "cases_contract_line_items"."tax_schedule_id" IS NULL AND "cases_contract_line_items"."cash_advance" = 't' ORDER BY "cases_contract_line_items"."parent_type" DESC
  151. (0.2ms) SELECT "cases_addendums"."id" FROM "cases_addendums" WHERE "cases_addendums"."contract_id" = $1 AND "cases_addendums"."signed" = 't' ORDER BY created_at, signed_at [["contract_id", "edc8c438-f714-4e3b-b5e6-cf407b91ccea"]]
  152. Cases::ContractLineItem Load (0.4ms) SELECT "cases_contract_line_items".* FROM "cases_contract_line_items" WHERE (("cases_contract_line_items"."parent_id" = 'edc8c438-f714-4e3b-b5e6-cf407b91ccea' AND "cases_contract_line_items"."parent_type" = 'Cases::Contract' OR 1=0 AND "cases_contract_line_items"."parent_type" = 'Cases::Addendum')) ORDER BY "cases_contract_line_items"."parent_type" DESC
  153. Acquaintance Load (0.3ms) SELECT "acquaintances".* FROM "acquaintances" WHERE "acquaintances"."id" = $1 ORDER BY acquaintances.sort_order, acquaintances.id LIMIT 1 [["id", 172]]
  154. RelationshipType Load (0.2ms) SELECT "relationship_types".* FROM "relationship_types" WHERE "relationship_types"."id" = $1 LIMIT 1 [["id", 1540]]
  155. (0.5ms) SELECT "acquaintance_types"."name" FROM "acquaintance_types" INNER JOIN "acquaintance_types_acquaintances" ON "acquaintance_types"."id" = "acquaintance_types_acquaintances"."acquaintance_type_id" WHERE "acquaintance_types_acquaintances"."acquaintance_id" = $1 ORDER BY "acquaintance_types"."name" ASC [["acquaintance_id", 172]]
  156. Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."id" = $1 LIMIT 1 [["id", 6910]]
  157. ContactInformation Load (0.1ms) SELECT "contact_informations".* FROM "contact_informations" WHERE "contact_informations"."id" = $1 LIMIT 1 [["id", 6749]]
  158. PhoneNumber Load (0.2ms) SELECT "phone_numbers".* FROM "phone_numbers" WHERE "phone_numbers"."contact_information_id" = $1 ORDER BY "phone_numbers"."rank" ASC [["contact_information_id", 6749]]
  159. Cases::CaseType Load (0.3ms) SELECT "cases_case_types".* FROM "cases_case_types" WHERE "cases_case_types"."case_id" = $1 [["case_id", 81]]
  160. Cases::CaseTypes::Status Load (0.3ms) SELECT "cases_case_types_statuses".* FROM "cases_case_types_statuses" WHERE "cases_case_types_statuses"."case_type_id" = $1 LIMIT 1 [["case_type_id", 1359]]
  161. => {:case_id=>81,
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!