API tools faq
paste
Guest User

Untitled

a guest
Oct 4th, 2018
640
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 51.32 KB | None | 0 0
raw download clone embed print report
  1. EmailTemplate Load (4.1ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."tag" = 'JobSeekerNotifier.job_planner' LIMIT 1
  2. JobOpportunity Load (4.8ms) SELECT "job_opportunities".* FROM "job_opportunities" WHERE "job_opportunities"."owner_id" = 35440 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
  3. Profile Load (4.9ms) SELECT "profiles".* FROM "profiles" WHERE "profiles"."owner_id" = 35440 LIMIT 1
  4. User Load (11.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 35440 LIMIT 1
  5. CustomerEmail Load (5.0ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  6. (13.9ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  7. Level Load (9.0ms) SELECT "levels".* FROM "levels" WHERE "levels"."id" = 37 ORDER BY title, position ASC LIMIT 1
  8. Education Load (1.1ms) SELECT "educations".* FROM "educations" WHERE "educations"."id" = 53 ORDER BY title, position ASC LIMIT 1
  9. Resume Load (5.9ms) SELECT "blobs".* FROM "blobs" WHERE "blobs"."type" IN ('Resume') AND "blobs"."id" = 156898 LIMIT 1
  10. Function Load (30.9ms) SELECT "functions".* FROM "functions" WHERE "functions"."id" = 72 ORDER BY title LIMIT 1
  11. ZipCode Load (1.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."id" = 38295 ORDER BY title LIMIT 1
  12. ZipCode Load (96.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  13. Security Load (7.9ms) SELECT "securities".* FROM "securities" WHERE "securities"."id" = 36 ORDER BY title, position ASC LIMIT 1
  14. CareerStatus Load (1.7ms) SELECT "career_statuses".* FROM "career_statuses" WHERE "career_statuses"."id" = 3 ORDER BY title, position ASC LIMIT 1
  15. Company Load (6.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 172851 ORDER BY title LIMIT 1
  16. (1308.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  17. CustomerEmail Load (1.4ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  18. (0.8ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  19. ZipCode Load (104.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  20. FacebookToken Load (7.1ms) SELECT "facebook_tokens".* FROM "facebook_tokens" WHERE "facebook_tokens"."owner_id" = 35440 LIMIT 1
  21. LinkedinToken Load (2.3ms) SELECT "linkedin_tokens".* FROM "linkedin_tokens" WHERE "linkedin_tokens"."owner_id" = 35440 LIMIT 1
  22. Company Load (16.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  23. ExternalApplication Load (42.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153184 LIMIT 1
  24. Company Load (2.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 4013580 ORDER BY title LIMIT 1
  25. Company Load (1.6ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 546631 ORDER BY title LIMIT 1
  26. Company Load (1.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 346003 ORDER BY title LIMIT 1
  27. Company Load (2.6ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 3991803 ORDER BY title LIMIT 1
  28. Company Load (2.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 37556 ORDER BY title LIMIT 1
  29. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 3991734 ORDER BY title LIMIT 1
  30. Company Load (2.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 3944187 ORDER BY title LIMIT 1
  31. Company Load (3.7ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1499363 ORDER BY title LIMIT 1
  32. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 38909 ORDER BY title LIMIT 1
  33. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 38909 ORDER BY title LIMIT 1
  34. Company Load (1.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 603844 ORDER BY title LIMIT 1
  35. ExternalApplication Load (30.0ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135237 LIMIT 1
  36. (1316.5ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  37. CustomerEmail Load (1.3ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  38. (0.8ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  39. ZipCode Load (157.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  40. CareerBuilderToken Load (25.0ms) SELECT "career_builder_tokens".* FROM "career_builder_tokens" WHERE "career_builder_tokens"."owner_id" = 35440 LIMIT 1
  41. (405.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  42. MatchingProfile Load (38.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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) ORDER BY title
  43. MatchingProfileLocation Load (6.8ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (168, 298, 301, 295, 286, 125, 466, 278, 170, 499, 128, 129, 131, 132, 303, 482, 133, 135, 136, 137, 478, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 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, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 302, 515, 206, 207, 208, 205, 210, 219, 212, 214)
  44. Location Load (22.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800) ORDER BY title
  45. RecentJobSearch Load (1130.4ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  46. Location Load (3.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  47. Location Load (4.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  48. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  49. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  50. Location Load (2.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  51. Location Load (1.3ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  52. Location Load (1.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  53. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  54. MatchingProfile Load (9.2ms) SELECT "matching_profiles".* FROM "matching_profiles" INNER JOIN "distributions" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 35440 ORDER BY title
  55. (7.7ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (357, 133, 583, 145, 153, 154, 155, 203, 225, 252, 173, 186, 187, 191, 389) AND "partners"."superior" = 't' AND (partners.id not in (270,589,136,591,594,173,590))
  56. (1570.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  57. CustomerEmail Load (1.4ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  58. (1.1ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  59. ZipCode Load (119.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  60. Distribution Load (8.4ms) SELECT "distributions"."matching_profile_id" FROM "distributions" INNER JOIN "matching_profiles" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 35440 AND (status = 'incomplete' AND matching_profiles.disabled = false)
  61. (1775.7ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  62. CustomerEmail Load (1.3ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  63. (2.9ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  64. ZipCode Load (131.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  65. q (1961.9ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  66. CustomerEmail Load (5.7ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  67. (3.6ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  68. ZipCode Load (148.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  69. (1560.0ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  70. CustomerEmail Load (1.3ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  71. (1.1ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  72. ZipCode Load (167.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  73. (452.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  74. MatchingProfile Load (24.0ms) 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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) ORDER BY title
  75. MatchingProfileLocation Load (11.9ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (168, 298, 301, 295, 286, 125, 466, 278, 170, 499, 128, 129, 131, 132, 303, 482, 133, 135, 136, 137, 478, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 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, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 302, 515, 206, 207, 208, 205, 210, 219, 212, 214)
  76. Location Load (8.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800) ORDER BY title
  77. RecentJobSearch Load (923.4ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  78. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  79. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  80. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  81. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  82. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  83. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  84. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  85. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  86. (13.7ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (357, 133, 583, 145, 153, 154, 155, 203, 225, 252, 173, 186, 187, 191, 389) AND "partners"."superior" = 't' AND (partners.id not in (270,589,136,591,594,173,590))
  87. (1570.4ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  88. CustomerEmail Load (4.2ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  89. (1.3ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  90. ZipCode Load (240.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  91. Distribution Load (12.1ms) SELECT "distributions"."matching_profile_id" FROM "distributions" INNER JOIN "matching_profiles" ON "matching_profiles"."id" = "distributions"."matching_profile_id" WHERE "distributions"."owner_id" = 35440 AND (status = 'incomplete' AND matching_profiles.disabled = false)
  92. (1450.4ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  93. CustomerEmail Load (0.8ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  94. (1.2ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  95. ZipCode Load (142.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  96. (205.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  97. MatchingProfile Load (156.0ms) 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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) AND (matching_profiles.id not in (0)) ORDER BY title
  98. MatchingProfileLocation Load (1.1ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (308, 317, 325, 326, 517, 514, 524, 194, 178, 179, 195, 392, 393, 486, 400, 374)
  99. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  100. RecentJobSearch Load (1147.7ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  101. Location Load (8.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  102. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  103. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  104. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  105. Location Load (2.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 24 ORDER BY title LIMIT 1
  106. Location Load (28.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  107. (1510.2ms) SELECT 1 FROM "blobs" WHERE ("blobs"."persistence_token" = '5e795599c0d1438ee161e85ee31efa78' AND "blobs"."id" != 156898) LIMIT 1
  108. CustomerEmail Load (4.2ms) SELECT "customer_emails".* FROM "customer_emails" WHERE "customer_emails"."email" = 'dimanikifar40@gmail.com' ORDER BY customer_emails.created_at desc LIMIT 1
  109. (1.1ms) SELECT 1 FROM "profiles" WHERE ("profiles"."owner_id" = 35440 AND "profiles"."id" != 33914) LIMIT 1
  110. ZipCode Load (134.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."type" IN ('ZipCode') AND "locations"."name" = '20110' ORDER BY title LIMIT 1
  111. (469.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  112. MatchingProfile Load (136.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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) AND (matching_profiles.id not in (0)) ORDER BY title
  113. MatchingProfileLocation Load (0.8ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (308, 317, 325, 326, 517, 514, 524, 194, 178, 179, 195, 392, 393, 486, 400, 374)
  114. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  115. RecentJobSearch Load (1309.8ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  116. Location Load (19.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  117. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  118. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  119. Location Load (2.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  120. Location Load (2.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 24 ORDER BY title LIMIT 1
  121. Location Load (1.3ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  122. (103.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  123. MatchingProfile Load (122.1ms) 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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) AND (matching_profiles.id not in (0)) ORDER BY title
  124. MatchingProfileLocation Load (1.1ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (308, 317, 325, 326, 517, 514, 524, 194, 178, 179, 195, 392, 393, 486, 400, 374)
  125. Location Load (3.4ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (2548, 6, 414, 47) ORDER BY title
  126. RecentJobSearch Load (1586.5ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  127. Location Load (2.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  128. Location Load (10.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  129. Location Load (1.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  130. Location Load (3.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  131. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 24 ORDER BY title LIMIT 1
  132. Location Load (4.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  133. (1126.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 LIMIT 6) subquery_for_count
  134. MatchingProfile Load (42.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 (37)) 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 (53)) 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 (36)) or not exists(select id from securities_matching_profiles t where t.matching_profile_id = matching_profiles.id)) AND (exists(select id from salaries_matching_profiles t where t.matching_profile_id = matching_profiles.id and t.salary_id in (4)) or not exists(select id from salaries_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 = 35440)) ORDER BY title
  135. MatchingProfileLocation Load (4.4ms) SELECT "matching_profile_locations".* FROM "matching_profile_locations" WHERE "matching_profile_locations"."matching_profile_id" IN (168, 298, 301, 295, 286, 125, 466, 278, 170, 499, 128, 129, 131, 132, 303, 482, 133, 135, 136, 137, 478, 147, 215, 150, 151, 153, 154, 155, 156, 157, 159, 160, 467, 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, 182, 171, 193, 500, 198, 199, 200, 201, 202, 197, 203, 204, 476, 302, 515, 206, 207, 208, 205, 210, 219, 212, 214)
  136. Location Load (1.3ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (28477, 27850, 27800) ORDER BY title
  137. RecentJobSearch Load (1442.8ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 ORDER BY job_searches.created_at desc LIMIT 6
  138. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" IN (38295, 3572) ORDER BY title
  139. Location Load (1.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6088 ORDER BY title LIMIT 1
  140. Location Load (3.2ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 51 ORDER BY title LIMIT 1
  141. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 6 ORDER BY title LIMIT 1
  142. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  143. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 58 ORDER BY title LIMIT 1
  144. Location Load (1.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 31 ORDER BY title LIMIT 1
  145. Location Load (2.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 35 ORDER BY title LIMIT 1
  146. (1.5ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (357, 133, 583, 145, 153, 154, 155, 203, 225, 252, 173, 186, 187, 191, 389) AND "partners"."superior" = 't' AND (partners.id not in (270,589,136,591,594,173,590))
  147. (1.0ms) SELECT COUNT(*) FROM "partners" WHERE "partners"."id" IN (357, 133, 583, 145, 153, 154, 155, 203, 225, 252, 173, 186, 187, 191, 389) AND "partners"."superior" = 't' AND (partners.id not in (270,589,136,591,594,173,590))
  148. Company Load (3.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 54939 ORDER BY title LIMIT 1
  149. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1993940 ORDER BY title LIMIT 1
  150. Company Load (1.4ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 36023 ORDER BY title LIMIT 1
  151. ExternalApplication Load (37.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135240 LIMIT 1
  152. Company Load (2.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 870415 ORDER BY title LIMIT 1
  153. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  154. ExternalApplication Load (10.9ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153190 LIMIT 1
  155. Company Load (3.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  156. ExternalApplication Load (1.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153188 LIMIT 1
  157. Company Load (5.7ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  158. ExternalApplication Load (0.9ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153189 LIMIT 1
  159. Company Load (4.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  160. ExternalApplication Load (93.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153186 LIMIT 1
  161. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  162. ExternalApplication Load (2.3ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153187 LIMIT 1
  163. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  164. ExternalApplication Load (36.9ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153185 LIMIT 1
  165. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  166. ExternalApplication Load (5.3ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153183 LIMIT 1
  167. Company Load (1.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  168. ExternalApplication Load (18.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153182 LIMIT 1
  169. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  170. ExternalApplication Load (70.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153181 LIMIT 1
  171. Company Load (3.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  172. ExternalApplication Load (107.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 153180 LIMIT 1
  173. Company Load (1.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 44961 ORDER BY title LIMIT 1
  174. ExternalApplication Load (103.8ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 148582 LIMIT 1
  175. Company Load (3.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  176. ExternalApplication Load (65.3ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 148561 LIMIT 1
  177. Company Load (1.3ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 44961 ORDER BY title LIMIT 1
  178. ExternalApplication Load (82.3ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 148556 LIMIT 1
  179. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 44961 ORDER BY title LIMIT 1
  180. ExternalApplication Load (96.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 148555 LIMIT 1
  181. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  182. ExternalApplication Load (114.5ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 148486 LIMIT 1
  183. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  184. ExternalApplication Load (83.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 141960 LIMIT 1
  185. Company Load (1.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  186. ExternalApplication Load (1.8ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 141959 LIMIT 1
  187. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  188. ExternalApplication Load (0.8ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 141957 LIMIT 1
  189. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 37556 ORDER BY title LIMIT 1
  190. Company Load (10.7ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 155820 ORDER BY title LIMIT 1
  191. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1620919 ORDER BY title LIMIT 1
  192. ExternalApplication Load (10.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 136097 LIMIT 1
  193. Company Load (20.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1620919 ORDER BY title LIMIT 1
  194. ExternalApplication Load (34.9ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 136095 LIMIT 1
  195. Company Load (8.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 36459 ORDER BY title LIMIT 1
  196. ExternalApplication Load (103.9ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 136094 LIMIT 1
  197. Company Load (3.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 36459 ORDER BY title LIMIT 1
  198. ExternalApplication Load (81.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 136092 LIMIT 1
  199. Company Load (1.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 117712 ORDER BY title LIMIT 1
  200. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 36023 ORDER BY title LIMIT 1
  201. ExternalApplication Load (97.5ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135239 LIMIT 1
  202. Company Load (1.6ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1290871 ORDER BY title LIMIT 1
  203. ExternalApplication Load (66.0ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135238 LIMIT 1
  204. Company Load (5.6ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 52447 ORDER BY title LIMIT 1
  205. ExternalApplication Load (68.8ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135236 LIMIT 1
  206. Company Load (6.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 1302529 ORDER BY title LIMIT 1
  207. ExternalApplication Load (70.0ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135235 LIMIT 1
  208. Company Load (6.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 603844 ORDER BY title LIMIT 1
  209. ExternalApplication Load (6.7ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135234 LIMIT 1
  210. Company Load (15.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 603844 ORDER BY title LIMIT 1
  211. ExternalApplication Load (55.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 135233 LIMIT 1
  212. Company Load (1.3ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 180554 ORDER BY title LIMIT 1
  213. ExternalApplication Load (92.5ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 119141 LIMIT 1
  214. Company Load (1.3ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 2183516 ORDER BY title LIMIT 1
  215. JobOpportunity Load (10.1ms) SELECT "job_opportunities".* FROM "job_opportunities" WHERE "job_opportunities"."owner_id" = 35440 AND (not disabled) ORDER BY job_opportunities.status_updated_at desc, job_opportunities.updated_at DESC LIMIT 5
  216. RecentJobSearch Load (1528.3ms) SELECT "job_searches".* FROM "job_searches" WHERE "job_searches"."type" IN ('RecentJobSearch') AND "job_searches"."owner_id" = 35440 AND (title <> '"Rails Developer" OR "Software Engineer" OR "Representative - RPM - Perryton, TX" OR "sad" OR "asd" OR "asda" OR "asd"') ORDER BY job_searches.created_at desc, "job_searches"."created_at" DESC LIMIT 1
  217. User Load (1.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 35440 LIMIT 1
  218. Profile Load (3.6ms) SELECT "profiles".* FROM "profiles" WHERE "profiles"."owner_id" = 35440 LIMIT 1
  219. Company Load (7.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = 172851 ORDER BY title LIMIT 1
  220. SuggestedJob Load (5.3ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."owner_id" = 35440 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
  221. SuggestedJob Load (2.4ms) SELECT recommended_jobs.jobkey FROM "recommended_jobs" WHERE "recommended_jobs"."type" IN ('SuggestedJob') AND "recommended_jobs"."viewed" = 't' AND "recommended_jobs"."owner_id" = 35440 ORDER BY recommended_jobs.created_at desc
  222. Location Load (1.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "24036"]]
  223. Company Load (1.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'indeed' ORDER BY title LIMIT 1
  224. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "27692"]]
  225. Company Load (5.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'aaa' ORDER BY title LIMIT 1
  226. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "29623"]]
  227. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'ruth-s-chris-steak-house' ORDER BY title LIMIT 1
  228. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "7332"]]
  229. Company Load (1.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'wells-fargo' ORDER BY title LIMIT 1
  230. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "22643"]]
  231. Company Load (1.4ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'inter-motion' ORDER BY title LIMIT 1
  232. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."title" = 'Inter-Motion' ORDER BY title LIMIT 1
  233. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "25176"]]
  234. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'cadre-proppants' ORDER BY title LIMIT 1
  235. Location Load (1.5ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "8689"]]
  236. Company Load (1.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'work-from-home' ORDER BY title LIMIT 1
  237. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "19637"]]
  238. Company Load (2.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'schneider-national' ORDER BY title LIMIT 1
  239. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "14192"]]
  240. Company Load (1.0ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'northern-indiana-manufacturing' ORDER BY title LIMIT 1
  241. Location Load (1.0ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "9979"]]
  242. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'st-francis-hospital' ORDER BY title LIMIT 1
  243. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "16765"]]
  244. Company Load (1.2ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'cellular' ORDER BY title LIMIT 1
  245. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "22839"]]
  246. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'regional-west-medical-center' ORDER BY title LIMIT 1
  247. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "29122"]]
  248. Company Load (1.7ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'walt-disney-parks-resorts-careers' ORDER BY title LIMIT 1
  249. Location Load (0.6ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "29122"]]
  250. Company Load (1.3ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'walt-disney-parks-resorts-careers' ORDER BY title LIMIT 1
  251. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "2650"]]
  252. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'mediacom-communications-corporation' ORDER BY title LIMIT 1
  253. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "20748"]]
  254. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'american-plastics-group' ORDER BY title LIMIT 1
  255. Location Load (0.8ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "20748"]]
  256. Company Load (1.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'american-plastics-group' ORDER BY title LIMIT 1
  257. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "19438"]]
  258. Company Load (1.7ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'telefonix' ORDER BY title LIMIT 1
  259. Location Load (1.1ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "18662"]]
  260. Company Load (0.9ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'butler-machinery-company' ORDER BY title LIMIT 1
  261. Location Load (0.7ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = $1 ORDER BY title LIMIT 1 [["id", "7074"]]
  262. Company Load (0.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."slug" = 'wells-fargo' ORDER BY title LIMIT 1
  263. (66.1ms) SELECT COUNT(*) FROM "external_applications" WHERE "external_applications"."owner_id" = 35440
  264. ExternalApplication Load (179.6ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."owner_id" = 35440 ORDER BY "external_applications"."id" DESC LIMIT 1
  265. ExternalApplication Load (202.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."owner_id" = 35440 ORDER BY "external_applications"."id" DESC LIMIT 1
  266. ExternalApplication Load (189.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."owner_id" = 35440 ORDER BY "external_applications"."id" DESC LIMIT 1
  267. ExternalApplication Load (168.2ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."owner_id" = 35440 ORDER BY "external_applications"."id" DESC LIMIT 1
  268. Location Load (0.9ms) SELECT "locations".* FROM "locations" WHERE "locations"."id" = 73307 ORDER BY title LIMIT 1
  269. InternalStatus Load (2.0ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 3 LIMIT 1
  270. CompanyRelation Load (8.2ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 35440 AND "company_relations"."company_id" = 180554 LIMIT 1
  271. InternalStatus Load (0.9ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  272. ExternalApplication Load (29.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 221128 LIMIT 1
  273. CompanyRelation Load (0.8ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 35440 AND "company_relations"."company_id" = 4013580 LIMIT 1
  274. InternalStatus Load (1.3ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  275. ExternalApplication Load (65.4ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 219403 LIMIT 1
  276. CompanyRelation Load (0.9ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 35440 AND "company_relations"."company_id" = 546631 LIMIT 1
  277. InternalStatus Load (0.7ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  278. ExternalApplication Load (40.1ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 218605 LIMIT 1
  279. CompanyRelation Load (0.8ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 35440 AND "company_relations"."company_id" = 346003 LIMIT 1
  280. InternalStatus Load (0.6ms) SELECT "internal_statuses".* FROM "internal_statuses" WHERE "internal_statuses"."id" = 13 LIMIT 1
  281. ExternalApplication Load (28.8ms) SELECT "external_applications".* FROM "external_applications" WHERE "external_applications"."job_opportunity_id" = 218395 LIMIT 1
  282. CompanyRelation Load (2.7ms) SELECT "company_relations".* FROM "company_relations" WHERE "company_relations"."owner_id" = 35440 AND "company_relations"."company_id" = 3991803 LIMIT 1
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!