app/services/csv_export/match_exporter.rb:66
- Average Self
-
2,399ms
- Calls
- 2x
- Total Self
- 4,798ms
- Total Children
- 0ms
- Total runtime
- 4,798ms
BEGIN
SELECT DISTINCT "matches"."id" AS t0_r0, "matches"."need_id" AS t0_r1, "matches"."created_at" AS t0_r2, "matches"."updated_at" AS t0_r3, "matches"."taken_care_of_at" AS t0_r4, "matches"."closed_at" AS t0_r5, "matches"."expert_id" AS t0_r6, "matches"."subject_id" AS t0_r7, "matches"."status" AS t0_r8, "matches"."archived_at" AS t0_r9, "matches"."sent_at" AS t0_r10, "needs"."id" AS t1_r0, "needs"."diagnosis_id" AS t1_r1, "needs"."subject_id" AS t1_r2, "needs"."created_at" AS t1_r3, "needs"."updated_at" AS t1_r4, "needs"."content" AS t1_r5, "needs"."matches_count" AS t1_r6, "needs"."satisfaction_email_sent" AS t1_r7, "needs"."status" AS t1_r8, "needs"."abandoned_email_sent" AS t1_r9, "needs"."retention_sent_at" AS t1_r10, "needs"."starred_at" AS t1_r11, "reminders_actions"."id" AS t2_r0, "reminders_actions"."need_id" AS t2_r1, "reminders_actions"."created_at" AS t2_r2, "reminders_actions"."updated_at" AS t2_r3, "reminders_actions"."category" AS t2_r4, "diagnoses_matches"."id" AS t3_r0, "diagnoses_matches"."content" AS t3_r1, "diagnoses_matches"."created_at" AS t3_r2, "diagnoses_matches"."updated_at" AS t3_r3, "diagnoses_matches"."step" AS t3_r4, "diagnoses_matches"."advisor_id" AS t3_r5, "diagnoses_matches"."visitee_id" AS t3_r6, "diagnoses_matches"."facility_id" AS t3_r7, "diagnoses_matches"."happened_on" AS t3_r8, "diagnoses_matches"."solicitation_id" AS t3_r9, "diagnoses_matches"."completed_at" AS t3_r10, "diagnoses_matches"."retention_email_sent" AS t3_r11, "contacts"."id" AS t4_r0, "contacts"."email" AS t4_r1, "contacts"."phone_number" AS t4_r2, "contacts"."company_id" AS t4_r3, "contacts"."created_at" AS t4_r4, "contacts"."updated_at" AS t4_r5, "contacts"."full_name" AS t4_r6, "facilities_matches"."id" AS t5_r0, "facilities_matches"."company_id" AS t5_r1, "facilities_matches"."siret" AS t5_r2, "facilities_matches"."created_at" AS t5_r3, "facilities_matches"."updated_at" AS t5_r4, "facilities_matches"."naf_code" AS t5_r5, "facilities_matches"."readable_locality" AS t5_r6, "facilities_matches"."code_effectif" AS t5_r7, "facilities_matches"."naf_libelle" AS t5_r8, "facilities_matches"."naf_code_a10" AS t5_r9, "facilities_matches"."opco_id" AS t5_r10, "facilities_matches"."effectif" AS t5_r11, "facilities_matches"."nature_activites" AS t5_r12, "facilities_matches"."nafa_codes" AS t5_r13, "facilities_matches"."insee_code" AS t5_r14, "companies"."id" AS t6_r0, "companies"."name" AS t6_r1, "companies"."siren" AS t6_r2, "companies"."created_at" AS t6_r3, "companies"."updated_at" AS t6_r4, "companies"."legal_form_code" AS t6_r5, "companies"."code_effectif" AS t6_r6, "companies"."date_de_creation" AS t6_r7, "companies"."effectif" AS t6_r8, "companies"."forme_exercice" AS t6_r9, "related_matches_matches"."id" AS t7_r0, "related_matches_matches"."need_id" AS t7_r1, "related_matches_matches"."created_at" AS t7_r2, "related_matches_matches"."updated_at" AS t7_r3, "related_matches_matches"."taken_care_of_at" AS t7_r4, "related_matches_matches"."closed_at" AS t7_r5, "related_matches_matches"."expert_id" AS t7_r6, "related_matches_matches"."subject_id" AS t7_r7, "related_matches_matches"."status" AS t7_r8, "related_matches_matches"."archived_at" AS t7_r9, "related_matches_matches"."sent_at" AS t7_r10, "users"."id" AS t8_r0, "users"."email" AS t8_r1, "users"."encrypted_password" AS t8_r2, "users"."reset_password_token" AS t8_r3, "users"."reset_password_sent_at" AS t8_r4, "users"."remember_created_at" AS t8_r5, "users"."sign_in_count" AS t8_r6, "users"."current_sign_in_at" AS t8_r7, "users"."last_sign_in_at" AS t8_r8, "users"."current_sign_in_ip" AS t8_r9, "users"."last_sign_in_ip" AS t8_r10, "users"."created_at" AS t8_r11, "users"."updated_at" AS t8_r12, "users"."phone_number" AS t8_r13, "users"."job" AS t8_r14, "users"."full_name" AS t8_r15, "users"."antenne_id" AS t8_r16, "users"."invitation_token" AS t8_r17, "users"."invitation_created_at" AS t8_r18, "users"."invitation_sent_at" AS t8_r19, "users"."invitation_accepted_at" AS t8_r20, "users"."invitation_limit" AS t8_r21, "users"."inviter_id" AS t8_r22, "users"."invitations_count" AS t8_r23, "users"."deleted_at" AS t8_r24, "users"."cgu_accepted_at" AS t8_r25, "users"."app_info" AS t8_r26, "users"."demo_invited_at" AS t8_r27, "users"."absence_start_at" AS t8_r28, "users"."absence_end_at" AS t8_r29, "users"."imported_at" AS t8_r30, "experts"."id" AS t9_r0, "experts"."email" AS t9_r1, "experts"."phone_number" AS t9_r2, "experts"."job" AS t9_r3, "experts"."created_at" AS t9_r4, "experts"."updated_at" AS t9_r5, "experts"."full_name" AS t9_r6, "experts"."antenne_id" AS t9_r7, "experts"."deleted_at" AS t9_r8, "expert_antennes_matches"."id" AS t10_r0, "expert_antennes_matches"."name" AS t10_r1, "expert_antennes_matches"."institution_id" AS t10_r2, "expert_antennes_matches"."created_at" AS t10_r3, "expert_antennes_matches"."updated_at" AS t10_r4, "expert_antennes_matches"."deleted_at" AS t10_r5, "expert_antennes_matches"."territorial_level" AS t10_r6, "expert_antennes_match [TRUNCATED]
|