API tools faq
paste
Guest User

Untitled

a guest
Oct 4th, 2018
690
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 38.52 KB | None | 0 0
raw download clone embed print report
  1. EmailTemplate.send_job_planner(u, false)
  2. EmailTemplate Load (12.2ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."tag" = 'JobSeekerNotifier.job_planner' LIMIT 1
  3. JobOpportunity Load (7.7ms) SELECT "job_opportunities".* FROM "job_opportunities" WHERE "job_opportunities"."owner_id" = 38648 AND (job_opportunities.internal_status_id is not null AND not disabled and hidden_from_view = false) ORDER BY job_opportunities.status_updated_at desc
  4. Profile Load (10.5ms) SELECT "profiles".* FROM "profiles" WHERE "profiles"."owner_id" = 38648 LIMIT 1
  5. User Load (3.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 38648 LIMIT 1
  6. CustomerEmail Load (1.4ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  7. (21.1ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  8. Level Load (6.7ms) SELECT "levels".* FROM "levels" WHERE "levels"."id" = 38 ORDER BY title, position ASC LIMIT 1
  9. Education Load (5.5ms) SELECT "educations".* FROM "educations" WHERE "educations"."id" = 50 ORDER BY title, position ASC LIMIT 1
  10. Resume Load (8.6ms) SELECT "blobs".* FROM "blobs" WHERE "blobs"."type" IN ('Resume') AND "blobs"."id" = 66902 LIMIT 1
  11. Function Load (2.5ms) SELECT "functions".* FROM "functions" WHERE "functions"."id" = 72 ORDER BY title LIMIT 1
  12. ZipCode Load (10.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."id" = 68962 ORDER BY title LIMIT 1
  13. ZipCode Load (248.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  14. (1896.6ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  15. (0.7ms) BEGIN
  16. (2007.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  17. (0.6ms) COMMIT
  18. (0.5ms) BEGIN
  19. (1.6ms) UPDATE "profiles" SET "partners_info" = '--- {}
  20.  
  21. ', "skipped_partners" = '--- []
  22.  
  23. ', "declined_matching_profile_ids" = '--- []
  24.  
  25. ', "updated_at" = '2012-04-27 13:43:32.337757' WHERE "profiles"."id" = 37031
  26. (5.9ms) COMMIT
  27. Security Load (1.0ms) SELECT "securities".* FROM "securities" WHERE "securities"."id" = 37 ORDER BY title, position ASC LIMIT 1
  28. CareerStatus Load (2.1ms) SELECT "career_statuses".* FROM "career_statuses" WHERE "career_statuses"."id" = 3 ORDER BY title, position ASC LIMIT 1
  29. (2047.6ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  30. CustomerEmail Load (1.1ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  31. (0.8ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  32. ZipCode Load (138.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  33. (1854.6ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  34. (0.7ms) BEGIN
  35. (1794.3ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  36. (0.8ms) COMMIT
  37. (0.5ms) BEGIN
  38. (5.7ms) UPDATE "profiles" SET "partners_info" = '--- {}
  39.  
  40. ', "skipped_partners" = '--- []
  41.  
  42. ', "declined_matching_profile_ids" = '--- []
  43.  
  44. ', "updated_at" = '2012-04-27 13:43:38.259799' WHERE "profiles"."id" = 37031
  45. (4.9ms) COMMIT
  46. FacebookToken Load (1.2ms) SELECT "facebook_tokens".* FROM "facebook_tokens" WHERE "facebook_tokens"."owner_id" = 38648 LIMIT 1
  47. Company Load (33.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 44470 ORDER BY title LIMIT 1
  48. ExternalApplication Load (69.3ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 150664 LIMIT 1
  49. (1899.5ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  50. CustomerEmail Load (1.6ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  51. (314.6ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  52. ZipCode Load (180.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  53. (1723.2ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  54. (3.0ms) BEGIN
  55. (1656.4ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  56. (0.5ms) COMMIT
  57. (0.5ms) BEGIN
  58. (1.9ms) UPDATE "profiles" SET "partners_info" = '--- {}
  59.  
  60. ', "skipped_partners" = '--- []
  61.  
  62. ', "declined_matching_profile_ids" = '--- []
  63.  
  64. ', "updated_at" = '2012-04-27 13:43:44.218853' WHERE "profiles"."id" = 37031
  65. (2.1ms) COMMIT
  66. CareerBuilderToken Load (60.3ms) SELECT "career_builder_tokens".* FROM "career_builder_tokens" WHERE "career_builder_tokens"."owner_id" = 38648 LIMIT 1
  67. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  68. Location Load (1.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  69. Location Load (17.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  70. RecentJobSearch Load (4308.5ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  71. Location Load (2.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  72. MatchingProfile Load (19.5ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method != 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from distributions d where d.owner_id = 38648)) ORDER BY title
  73. MatchingProfileLocation Load (2.6ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (288, 168, 294, 296, 297, 141, 293, 291, 292, 287, 125, 466, 278, 170, 499, 128, 129, 494, 131, 132, 303, 482, 133, 135, 136, 137, 478, 305, 138, 140, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 496, 213, 162, 163, 165, 166, 167, 221, 222, 223, 224, 225, 226, 231, 227, 229, 230, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 251, 252, 253, 254, 255, 256, 257, 258, 259, 250, 260, 261, 262, 263, 264, 265, 266, 268, 267, 228, 269, 270, 271, 272, 273, 274, 275, 174, 279, 465, 501, 488, 487, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 525, 515, 206, 207, 280, 208, 205, 210, 219, 212, 214)
  74. Location Load (1.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800, 23, 10, 42, 35, 33, 8, 9, 24, 32, 17, 49, 25, 43, 38) ORDER BY title
  75. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  76. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  77. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  78. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  79. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  80. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 27872 ORDER BY title LIMIT 1
  81. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  82. MatchingProfile Load (1.4ms) SELECT "matching_profiles".* FROM "matching_profiles" INNER JOIN "distributions" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 38648 ORDER BY title
  83. (2.5ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (120, 589, 357, 583, 136, 145, 153, 591, 203, 587, 587, 186, 187, 191, 389, 354) AND "partners"."superior" = 't'
  84. (1133.3ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  85. CustomerEmail Load (1.1ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  86. (0.8ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  87. ZipCode Load (115.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  88. (1371.7ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  89. (0.6ms) BEGIN
  90. (1234.2ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  91. (0.6ms) COMMIT
  92. (0.5ms) BEGIN
  93. (1.0ms) UPDATE "profiles" SET "partners_info" = '--- {}
  94.  
  95. ', "skipped_partners" = '--- []
  96.  
  97. ', "declined_matching_profile_ids" = '--- []
  98.  
  99. ', "updated_at" = '2012-04-27 13:43:53.050830' WHERE "profiles"."id" = 37031
  100. (1.9ms) COMMIT
  101. Distribution Load (2.1ms) SELECT "distributions"."matching_profile_id" FROM "distributions" INNER JOIN "matching_profiles" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 38648 AND (status = 'incomplete' AND matching_profiles.disabled = false)
  102. (978.4ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  103. CustomerEmail Load (1.1ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  104. (2.4ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  105. ZipCode Load (54.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  106. (554.3ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  107. (0.5ms) BEGIN
  108. (397.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  109. (0.5ms) COMMIT
  110. (0.7ms) BEGIN
  111. (1.1ms) UPDATE "profiles" SET "partners_info" = '--- {}
  112.  
  113. ', "skipped_partners" = '--- []
  114.  
  115. ', "declined_matching_profile_ids" = '--- []
  116.  
  117. ', "updated_at" = '2012-04-27 13:43:55.067474' WHERE "profiles"."id" = 37031
  118. (2.2ms) COMMIT
  119. (822.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  120. CustomerEmail Load (0.8ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  121. (1.0ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  122. ZipCode Load (100.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  123. (1264.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  124. (0.5ms) BEGIN
  125. (1051.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  126. (0.7ms) COMMIT
  127. (1.7ms) BEGIN
  128. (1.3ms) UPDATE "profiles" SET "partners_info" = '--- {}
  129.  
  130. ', "skipped_partners" = '--- []
  131.  
  132. ', "declined_matching_profile_ids" = '--- []
  133.  
  134. ', "updated_at" = '2012-04-27 13:43:58.330900' WHERE "profiles"."id" = 37031
  135. (2.0ms) COMMIT
  136. (895.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  137. CustomerEmail Load (12.9ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  138. (0.7ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  139. ZipCode Load (55.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  140. (498.1ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  141. (12.6ms) BEGIN
  142. (803.8ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  143. (0.5ms) COMMIT
  144. (0.4ms) BEGIN
  145. (0.9ms) UPDATE "profiles" SET "partners_info" = '--- {}
  146.  
  147. ', "skipped_partners" = '--- []
  148.  
  149. ', "declined_matching_profile_ids" = '--- []
  150.  
  151. ', "updated_at" = '2012-04-27 13:44:01.168999' WHERE "profiles"."id" = 37031
  152. (2.1ms) COMMIT
  153. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  154. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  155. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  156. RecentJobSearch Load (621.4ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  157. Location Load (1.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  158. MatchingProfile Load (11.8ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method != 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from distributions d where d.owner_id = 38648)) ORDER BY title
  159. MatchingProfileLocation Load (2.7ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (288, 168, 294, 296, 297, 141, 293, 291, 292, 287, 125, 466, 278, 170, 499, 128, 129, 494, 131, 132, 303, 482, 133, 135, 136, 137, 478, 305, 138, 140, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 496, 213, 162, 163, 165, 166, 167, 221, 222, 223, 224, 225, 226, 231, 227, 229, 230, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 251, 252, 253, 254, 255, 256, 257, 258, 259, 250, 260, 261, 262, 263, 264, 265, 266, 268, 267, 228, 269, 270, 271, 272, 273, 274, 275, 174, 279, 465, 501, 488, 487, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 525, 515, 206, 207, 280, 208, 205, 210, 219, 212, 214)
  160. Location Load (3.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800, 23, 10, 42, 35, 33, 8, 9, 24, 32, 17, 49, 25, 43, 38) ORDER BY title
  161. Location Load (3.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  162. Location Load (2.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  163. Location Load (1.3ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  164. Location Load (3.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  165. Location Load (1.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  166. Location Load (6.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 27872 ORDER BY title LIMIT 1
  167. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  168. (1.2ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (120, 589, 357, 583, 136, 145, 153, 591, 203, 587, 587, 186, 187, 191, 389, 354) AND "partners"."superior" = 't'
  169. (1013.2ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  170. CustomerEmail Load (2.8ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  171. (0.8ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  172. ZipCode Load (92.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  173. (666.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  174. (0.5ms) BEGIN
  175. (402.6ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  176. (0.6ms) COMMIT
  177. (0.5ms) BEGIN
  178. (1.0ms) UPDATE "profiles" SET "partners_info" = '--- {}
  179.  
  180. ', "skipped_partners" = '--- []
  181.  
  182. ', "declined_matching_profile_ids" = '--- []
  183.  
  184. ', "updated_at" = '2012-04-27 13:44:04.248970' WHERE "profiles"."id" = 37031
  185. (1.7ms) COMMIT
  186. Distribution Load (2.2ms) SELECT "distributions"."matching_profile_id" FROM "distributions" INNER JOIN "matching_profiles" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 38648 AND (status = 'incomplete' AND matching_profiles.disabled = false)
  187. (316.7ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  188. CustomerEmail Load (1.2ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  189. (0.7ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  190. ZipCode Load (36.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  191. (434.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  192. (0.5ms) BEGIN
  193. (398.4ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  194. (0.7ms) COMMIT
  195. (0.5ms) BEGIN
  196. (1.4ms) UPDATE "profiles" SET "partners_info" = '--- {}
  197.  
  198. ', "skipped_partners" = '--- []
  199.  
  200. ', "declined_matching_profile_ids" = '--- []
  201.  
  202. ', "updated_at" = '2012-04-27 13:44:05.460954' WHERE "profiles"."id" = 37031
  203. (1.8ms) COMMIT
  204. Location Load (16.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  205. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  206. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  207. RecentJobSearch Load (446.1ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  208. Location Load (1.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  209. MatchingProfile Load (45.9ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method = 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from advertisement_distributions d where d.owner_id = 38648)) AND (matching_profiles.id not in (0)) ORDER BY title
  210. MatchingProfileLocation Load (1.3ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (519, 304, 308, 317, 325, 326, 517, 521, 357, 514, 524, 194, 178, 179, 195, 392, 377, 306, 486, 400, 374)
  211. Location Load (5.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  212. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  213. Location Load (1.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  214. (923.7ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  215. CustomerEmail Load (1.5ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'a.karabitski@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  216. (3.3ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 38648 AND "profiles"."id" != 37031) LIMIT 1
  217. ZipCode Load (130.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '90025' ORDER BY title LIMIT 1
  218. (1269.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  219. (0.6ms) BEGIN
  220. (1027.8ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '4bddafa828f6037e1c39d93682555f4c' AND "blobs"."id" != 66902) LIMIT 1
  221. (0.5ms) COMMIT
  222. (0.5ms) BEGIN
  223. (0.9ms) UPDATE "profiles" SET "partners_info" = '--- {}
  224.  
  225. ', "skipped_partners" = '--- []
  226.  
  227. ', "declined_matching_profile_ids" = '--- []
  228.  
  229. ', "updated_at" = '2012-04-27 13:44:09.812616' WHERE "profiles"."id" = 37031
  230. (1.8ms) COMMIT
  231. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  232. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  233. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  234. RecentJobSearch Load (1065.7ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  235. Location Load (6.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  236. MatchingProfile Load (103.3ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method = 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from advertisement_distributions d where d.owner_id = 38648)) AND (matching_profiles.id not in (0)) ORDER BY title
  237. MatchingProfileLocation Load (2.5ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (519, 304, 308, 317, 325, 326, 517, 521, 357, 514, 524, 194, 178, 179, 195, 392, 377, 306, 486, 400, 374)
  238. Location Load (2.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  239. Location Load (9.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  240. Location Load (1.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  241. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  242. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  243. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  244. RecentJobSearch Load (913.8ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  245. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  246. MatchingProfile Load (106.4ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method = 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from advertisement_distributions d where d.owner_id = 38648)) AND (matching_profiles.id not in (0)) ORDER BY title
  247. MatchingProfileLocation Load (0.9ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (519, 304, 308, 317, 325, 326, 517, 521, 357, 514, 524, 194, 178, 179, 195, 392, 377, 306, 486, 400, 374)
  248. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  249. Location Load (1.3ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  250. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  251. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  252. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  253. Location Load (4.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 68962 ORDER BY title LIMIT 1
  254. RecentJobSearch Load (958.7ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 ORDER BY job_searches.created_at desc LIMIT 6
  255. Location Load (11.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (27872) ORDER BY title
  256. MatchingProfile Load (12.4ms) SELECT "matching_profiles".* FROM "matching_profiles" WHERE (delivery_method != 'advertisement') AND (matching_profiles.disabled is null or matching_profiles.disabled = false) AND (exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.function_id in (72)) or not exists(select id from current_functions_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.level_id in (38)) or not exists(select id from levels_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.education_id in (50)) or not exists(select id from educations_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.security_id in (37)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND ((matching_profiles.career_status_id is null or matching_profiles.career_status_id = 3)) AND (matching_profiles.id not in (select d.matching_profile_id from distributions d where d.owner_id = 38648)) ORDER BY title
  257. MatchingProfileLocation Load (2.7ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (288, 168, 294, 296, 297, 141, 293, 291, 292, 287, 125, 466, 278, 170, 499, 128, 129, 494, 131, 132, 303, 482, 133, 135, 136, 137, 478, 305, 138, 140, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 496, 213, 162, 163, 165, 166, 167, 221, 222, 223, 224, 225, 226, 231, 227, 229, 230, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 251, 252, 253, 254, 255, 256, 257, 258, 259, 250, 260, 261, 262, 263, 264, 265, 266, 268, 267, 228, 269, 270, 271, 272, 273, 274, 275, 174, 279, 465, 501, 488, 487, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 525, 515, 206, 207, 280, 208, 205, 210, 219, 212, 214)
  258. Location Load (4.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800, 23, 10, 42, 35, 33, 8, 9, 24, 32, 17, 49, 25, 43, 38) ORDER BY title
  259. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  260. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  261. Location Load (6.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  262. Location Load (1.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  263. Location Load (3.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  264. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 27872 ORDER BY title LIMIT 1
  265. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  266. (31.6ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (120, 589, 357, 583, 136, 145, 153, 591, 203, 587, 587, 186, 187, 191, 389, 354) AND "partners"."superior" = 't'
  267. (1.2ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (120, 589, 357, 583, 136, 145, 153, 591, 203, 587, 587, 186, 187, 191, 389, 354) AND "partners"."superior" = 't'
  268. JobOpportunity Load (1.2ms) SELECT "job_opportunities".* FROM "job_opportunities" WHERE "job_opportunities"."owner_id" = 38648 AND (not disabled) ORDER BY job_opportunities.status_updated_at desc, job_opportunities.updated_at DESC LIMIT 5
  269. RecentJobSearch Load (737.0ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 38648 AND (title <> '"manager" OR "Ruby developer" OR "Ruby On Rails Developer"') ORDER BY job_searches.created_at desc, "job_searches"."created_at" DESC LIMIT 1
  270. Location Load (2.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 27872 ORDER BY title LIMIT 1
  271. User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 38648 LIMIT 1
  272. Profile Load (6.9ms) SELECT "profiles".* FROM "profiles" WHERE "profiles"."owner_id" = 38648 LIMIT 1
  273. SuggestedJob Load (1.7ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."owner_id" = 38648 AND (recommended_jobs.liked OR recommended_jobs.disabled OR exists(select * from job_opportunities jo where recommended_job_id = recommended_jobs.id and jo.internal_status_id is not null)) ORDER BY recommended_jobs.created_at desc
  274. SuggestedJob Load (11.3ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."viewed" = 't' AND "recommended_jobs"."owner_id" = 38648 ORDER BY recommended_jobs.created_at desc
  275. SuggestedJob Load (1.6ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."owner_id" = 38648 AND (recommended_jobs.liked OR recommended_jobs.disabled OR exists(select * from job_opportunities jo where recommended_job_id = recommended_jobs.id and jo.internal_status_id is not null)) ORDER BY recommended_jobs.created_at desc
  276. SuggestedJob Load (0.7ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."viewed" = 't' AND "recommended_jobs"."owner_id" = 38648 ORDER BY recommended_jobs.created_at desc
  277. (29.7ms) SELECT COUNT(*) FROM "external_applications" WHERE "external_applications"."owner_id" = 38648
  278. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 73307 ORDER BY title LIMIT 1
  279. InternalStatus Load (1.7ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  280. CompanyRelation Load (8.6ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 38648 AND "company_relations"."company_id" = 44470 LIMIT 1
  281. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 28191 ORDER BY title LIMIT 1
  282. Company Load (4.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 2455904 ORDER BY title LIMIT 1
  283. InternalStatus Load (2.1ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  284. ExternalApplication Load (27.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 141743 LIMIT 1
  285. CompanyRelation Load (0.8ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 38648 AND "company_relations"."company_id" = 2455904 LIMIT 1
  286. => #<Mail::Message:117731660, Multipart: false, Headers: <Date: Fri, 27 Apr 2012 13:44:14 +0000>, <From: jobplanner@startwire.com>, <To: a.karabitski@gmail.com>, <Cc: >, <Bcc: >, <Message-ID: <4f9aa2aee32af_4343ec7930122c@ip-10-42-234-119.mail>>, <Subject: Andrei, here's your StartWire Job Search Planner for 04/27/12>, <Mime-Version: 1.0>, <Content-Type: text/html>, <Content-Transfer-Encoding: quoted-printable>, <X-SMTPAPI: {"category": "Job Planner"}>>
Add Comment
Please, Sign In to add comment
Public Pastes
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!