Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.score AS score_1,
  s0_.comment AS comment_2,
  s0_.send_status AS send_status_3,
  s0_.created_at AS created_at_4,
  s0_.modified_at AS modified_at_5,
  s0_.refusal AS refusal_6,
  s0_.extended_comment AS extended_comment_7,
  s0_.extended_comment_created_at AS extended_comment_created_at_8,
  s0_.is_hidden AS is_hidden_9,
  s0_.processed_at AS processed_at_10,
  s0_.job_id AS job_id_11,
  s0_.user_id AS user_id_12,
  s0_.network_id AS network_id_13
FROM
  suggestion s0_
  INNER JOIN job j1_ ON s0_.job_id = j1_.id
  INNER JOIN network n2_ ON s0_.network_id = n2_.id
  LEFT JOIN message m3_ ON (
    m3_.network_id = n2_.id
    AND m3_.user_id = ?
  )
WHERE
  j1_.client_id = ?
  AND j1_.is_active = 1
  AND (
    (
      m3_.id IS NULL
      OR m3_.status IN (?)
    )
  )
  AND s0_.refusal IS NULL
  AND s0_.send_status IS NULL
  AND s0_.is_hidden = ?
  AND s0_.user_id = ?
ORDER BY
  j1_.id ASC,
  n2_.open_to_work DESC
LIMIT
  9

SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.comment AS comment_2, s0_.send_status AS send_status_3, s0_.created_at AS created_at_4, s0_.modified_at AS modified_at_5, s0_.refusal AS refusal_6, s0_.extended_comment AS extended_comment_7, s0_.extended_comment_created_at AS extended_comment_created_at_8, s0_.is_hidden AS is_hidden_9, s0_.processed_at AS processed_at_10, s0_.job_id AS job_id_11, s0_.user_id AS user_id_12, s0_.network_id AS network_id_13 FROM suggestion s0_ INNER JOIN job j1_ ON s0_.job_id = j1_.id INNER JOIN network n2_ ON s0_.network_id = n2_.id LEFT JOIN message m3_ ON (m3_.network_id = n2_.id AND m3_.user_id = 311) WHERE j1_.client_id = 1 AND j1_.is_active = 1 AND ((m3_.id IS NULL OR m3_.status IN ('scheduling_failed', 'sent_failed'))) AND s0_.refusal IS NULL AND s0_.send_status IS NULL AND s0_.is_hidden = 0 AND s0_.user_id = 311 ORDER BY j1_.id ASC, n2_.open_to_work DESC LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.consultation_date AS consultation_date_2,
  t0.created_at AS created_at_3,
  t0.processed_at AS processed_at_4,
  t0.network_id AS network_id_5,
  t0.job_id AS job_id_6,
  t0.user_id AS user_id_7,
  t0.suggestion_id AS suggestion_id_8,
  t9.id AS id_10,
  t9.created_at AS created_at_11,
  t9.proposal_id AS proposal_id_12
FROM
  proposal t0
  LEFT JOIN application t9 ON t9.proposal_id = t0.id
WHERE
  t0.suggestion_id = ?

SELECT t0.id AS id_1, t0.consultation_date AS consultation_date_2, t0.created_at AS created_at_3, t0.processed_at AS processed_at_4, t0.network_id AS network_id_5, t0.job_id AS job_id_6, t0.user_id AS user_id_7, t0.suggestion_id AS suggestion_id_8, t9.id AS id_10, t9.created_at AS created_at_11, t9.proposal_id AS proposal_id_12 FROM proposal t0 LEFT JOIN application t9 ON t9.proposal_id = t0.id WHERE t0.suggestion_id = 94620;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.photo AS photo_6,
  t0.locale AS locale_7,
  t0.is_verified AS is_verified_8,
  t0.created_at AS created_at_9,
  t0.modified_at AS modified_at_10,
  t0.email_pro AS email_pro_11,
  t0.origin AS origin_12,
  t0.has_extension AS has_extension_13,
  t0.extension_last_verified_at AS extension_last_verified_at_14,
  t0.user_uid AS user_uid_15,
  t0.account_uid AS account_uid_16,
  t0.identity_uid AS identity_uid_17,
  t0.linkedin_url AS linkedin_url_18,
  t0.li_at AS li_at_19,
  t0.network_status AS network_status_20,
  t0.phone AS phone_21,
  t0.job AS job_22,
  t0.is_active AS is_active_23,
  t0.enrichments_sent_today_count AS enrichments_sent_today_count_24,
  t0.enrichment_quota_last_reset_at AS enrichment_quota_last_reset_at_25,
  t0.token AS token_26,
  t0.rememberMeKey AS rememberMeKey_27,
  t0.has_seen_linkedin_preview_modal AS has_seen_linkedin_preview_modal_28,
  t0.li_at_updated_at AS li_at_updated_at_29,
  t0.message_template_formal AS message_template_formal_30,
  t0.message_template_informal AS message_template_informal_31,
  t0.greeting_formal AS greeting_formal_32,
  t0.greeting_informal AS greeting_informal_33,
  t0.is_suggestion_tour_hidden AS is_suggestion_tour_hidden_34,
  t0.last_profile_sync_at AS last_profile_sync_at_35,
  t0.number_connections AS number_connections_36,
  t0.password AS password_37,
  t0.has_linkedin_integration AS has_linkedin_integration_38,
  t0.linkedin_integration_created_at AS linkedin_integration_created_at_39,
  t0.linkedin_integration_last_verified_at AS linkedin_integration_last_verified_at_40,
  t0.linkedin_integration_status AS linkedin_integration_status_41,
  t0.linkedin_email_encrypted AS linkedin_email_encrypted_42,
  t0.linkedin_password_encrypted AS linkedin_password_encrypted_43,
  t0.linkedin_credentials_saved_at AS linkedin_credentials_saved_at_44,
  t0.checkpoint_type AS checkpoint_type_45,
  t0.onboarding_step AS onboarding_step_46,
  t0.password_reset_token AS password_reset_token_47,
  t0.password_reset_expires_at AS password_reset_expires_at_48,
  t0.recette_test_progress AS recette_test_progress_49,
  t0.client_id AS client_id_50
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.photo AS photo_6, t0.locale AS locale_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.email_pro AS email_pro_11, t0.origin AS origin_12, t0.has_extension AS has_extension_13, t0.extension_last_verified_at AS extension_last_verified_at_14, t0.user_uid AS user_uid_15, t0.account_uid AS account_uid_16, t0.identity_uid AS identity_uid_17, t0.linkedin_url AS linkedin_url_18, t0.li_at AS li_at_19, t0.network_status AS network_status_20, t0.phone AS phone_21, t0.job AS job_22, t0.is_active AS is_active_23, t0.enrichments_sent_today_count AS enrichments_sent_today_count_24, t0.enrichment_quota_last_reset_at AS enrichment_quota_last_reset_at_25, t0.token AS token_26, t0.rememberMeKey AS rememberMeKey_27, t0.has_seen_linkedin_preview_modal AS has_seen_linkedin_preview_modal_28, t0.li_at_updated_at AS li_at_updated_at_29, t0.message_template_formal AS message_template_formal_30, t0.message_template_informal AS message_template_informal_31, t0.greeting_formal AS greeting_formal_32, t0.greeting_informal AS greeting_informal_33, t0.is_suggestion_tour_hidden AS is_suggestion_tour_hidden_34, t0.last_profile_sync_at AS last_profile_sync_at_35, t0.number_connections AS number_connections_36, t0.password AS password_37, t0.has_linkedin_integration AS has_linkedin_integration_38, t0.linkedin_integration_created_at AS linkedin_integration_created_at_39, t0.linkedin_integration_last_verified_at AS linkedin_integration_last_verified_at_40, t0.linkedin_integration_status AS linkedin_integration_status_41, t0.linkedin_email_encrypted AS linkedin_email_encrypted_42, t0.linkedin_password_encrypted AS linkedin_password_encrypted_43, t0.linkedin_credentials_saved_at AS linkedin_credentials_saved_at_44, t0.checkpoint_type AS checkpoint_type_45, t0.onboarding_step AS onboarding_step_46, t0.password_reset_token AS password_reset_token_47, t0.password_reset_expires_at AS password_reset_expires_at_48, t0.recette_test_progress AS recette_test_progress_49, t0.client_id AS client_id_50 FROM `user` t0 WHERE t0.email = 'scourtes@bambboo.com' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.score AS score_1,
  s0_.comment AS comment_2,
  s0_.send_status AS send_status_3,
  s0_.created_at AS created_at_4,
  s0_.modified_at AS modified_at_5,
  s0_.refusal AS refusal_6,
  s0_.extended_comment AS extended_comment_7,
  s0_.extended_comment_created_at AS extended_comment_created_at_8,
  s0_.is_hidden AS is_hidden_9,
  s0_.processed_at AS processed_at_10,
  s0_.job_id AS job_id_11,
  s0_.user_id AS user_id_12,
  s0_.network_id AS network_id_13
FROM
  suggestion s0_
  INNER JOIN `user` u1_ ON s0_.user_id = u1_.id
WHERE
  u1_.id = ?

SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.comment AS comment_2, s0_.send_status AS send_status_3, s0_.created_at AS created_at_4, s0_.modified_at AS modified_at_5, s0_.refusal AS refusal_6, s0_.extended_comment AS extended_comment_7, s0_.extended_comment_created_at AS extended_comment_created_at_8, s0_.is_hidden AS is_hidden_9, s0_.processed_at AS processed_at_10, s0_.job_id AS job_id_11, s0_.user_id AS user_id_12, s0_.network_id AS network_id_13 FROM suggestion s0_ INNER JOIN `user` u1_ ON s0_.user_id = u1_.id WHERE u1_.id = 311;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  suggestion s0_
WHERE
  s0_.user_id = ?
  AND (
    (
      s0_.send_status IS NOT NULL
      OR s0_.refusal IS NOT NULL
    )
  )

SELECT COUNT(s0_.id) AS sclr_0 FROM suggestion s0_ WHERE s0_.user_id = 311 AND ((s0_.send_status IS NOT NULL OR s0_.refusal IS NOT NULL));

SELECT
  t0.id AS id_1,
  t0.is_formal AS is_formal_2,
  t0.created_at AS created_at_3,
  t0.content AS content_4,
  t0.captaindata_job_uid AS captaindata_job_uid_5,
  t0.status AS status_6,
  t0.user_id AS user_id_7,
  t0.network_id AS network_id_8
FROM
  message t0
WHERE
  t0.user_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_formal AS is_formal_2, t0.created_at AS created_at_3, t0.content AS content_4, t0.captaindata_job_uid AS captaindata_job_uid_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.network_id AS network_id_8 FROM message t0 WHERE t0.user_id = 311 AND t0.status = 'sent_failed' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_formal AS is_formal_2,
  t0.created_at AS created_at_3,
  t0.content AS content_4,
  t0.captaindata_job_uid AS captaindata_job_uid_5,
  t0.status AS status_6,
  t0.user_id AS user_id_7,
  t0.network_id AS network_id_8
FROM
  message t0
WHERE
  t0.user_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.is_formal AS is_formal_2, t0.created_at AS created_at_3, t0.content AS content_4, t0.captaindata_job_uid AS captaindata_job_uid_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.network_id AS network_id_8 FROM message t0 WHERE t0.user_id = 311 AND t0.status = 'pending';

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  suggestion s0_
  INNER JOIN job j1_ ON s0_.job_id = j1_.id
WHERE
  s0_.user_id = ?
  AND j1_.client_id = ?
  AND s0_.send_status IS NULL
  AND s0_.refusal IS NULL

SELECT COUNT(s0_.id) AS sclr_0 FROM suggestion s0_ INNER JOIN job j1_ ON s0_.job_id = j1_.id WHERE s0_.user_id = 311 AND j1_.client_id = 1 AND s0_.send_status IS NULL AND s0_.refusal IS NULL;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.photo AS photo_6,
  t0.locale AS locale_7,
  t0.is_verified AS is_verified_8,
  t0.created_at AS created_at_9,
  t0.modified_at AS modified_at_10,
  t0.email_pro AS email_pro_11,
  t0.origin AS origin_12,
  t0.has_extension AS has_extension_13,
  t0.extension_last_verified_at AS extension_last_verified_at_14,
  t0.user_uid AS user_uid_15,
  t0.account_uid AS account_uid_16,
  t0.identity_uid AS identity_uid_17,
  t0.linkedin_url AS linkedin_url_18,
  t0.li_at AS li_at_19,
  t0.network_status AS network_status_20,
  t0.phone AS phone_21,
  t0.job AS job_22,
  t0.is_active AS is_active_23,
  t0.enrichments_sent_today_count AS enrichments_sent_today_count_24,
  t0.enrichment_quota_last_reset_at AS enrichment_quota_last_reset_at_25,
  t0.token AS token_26,
  t0.rememberMeKey AS rememberMeKey_27,
  t0.has_seen_linkedin_preview_modal AS has_seen_linkedin_preview_modal_28,
  t0.li_at_updated_at AS li_at_updated_at_29,
  t0.message_template_formal AS message_template_formal_30,
  t0.message_template_informal AS message_template_informal_31,
  t0.greeting_formal AS greeting_formal_32,
  t0.greeting_informal AS greeting_informal_33,
  t0.is_suggestion_tour_hidden AS is_suggestion_tour_hidden_34,
  t0.last_profile_sync_at AS last_profile_sync_at_35,
  t0.number_connections AS number_connections_36,
  t0.password AS password_37,
  t0.has_linkedin_integration AS has_linkedin_integration_38,
  t0.linkedin_integration_created_at AS linkedin_integration_created_at_39,
  t0.linkedin_integration_last_verified_at AS linkedin_integration_last_verified_at_40,
  t0.linkedin_integration_status AS linkedin_integration_status_41,
  t0.linkedin_email_encrypted AS linkedin_email_encrypted_42,
  t0.linkedin_password_encrypted AS linkedin_password_encrypted_43,
  t0.linkedin_credentials_saved_at AS linkedin_credentials_saved_at_44,
  t0.checkpoint_type AS checkpoint_type_45,
  t0.onboarding_step AS onboarding_step_46,
  t0.password_reset_token AS password_reset_token_47,
  t0.password_reset_expires_at AS password_reset_expires_at_48,
  t0.recette_test_progress AS recette_test_progress_49,
  t0.client_id AS client_id_50
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.photo AS photo_6, t0.locale AS locale_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.email_pro AS email_pro_11, t0.origin AS origin_12, t0.has_extension AS has_extension_13, t0.extension_last_verified_at AS extension_last_verified_at_14, t0.user_uid AS user_uid_15, t0.account_uid AS account_uid_16, t0.identity_uid AS identity_uid_17, t0.linkedin_url AS linkedin_url_18, t0.li_at AS li_at_19, t0.network_status AS network_status_20, t0.phone AS phone_21, t0.job AS job_22, t0.is_active AS is_active_23, t0.enrichments_sent_today_count AS enrichments_sent_today_count_24, t0.enrichment_quota_last_reset_at AS enrichment_quota_last_reset_at_25, t0.token AS token_26, t0.rememberMeKey AS rememberMeKey_27, t0.has_seen_linkedin_preview_modal AS has_seen_linkedin_preview_modal_28, t0.li_at_updated_at AS li_at_updated_at_29, t0.message_template_formal AS message_template_formal_30, t0.message_template_informal AS message_template_informal_31, t0.greeting_formal AS greeting_formal_32, t0.greeting_informal AS greeting_informal_33, t0.is_suggestion_tour_hidden AS is_suggestion_tour_hidden_34, t0.last_profile_sync_at AS last_profile_sync_at_35, t0.number_connections AS number_connections_36, t0.password AS password_37, t0.has_linkedin_integration AS has_linkedin_integration_38, t0.linkedin_integration_created_at AS linkedin_integration_created_at_39, t0.linkedin_integration_last_verified_at AS linkedin_integration_last_verified_at_40, t0.linkedin_integration_status AS linkedin_integration_status_41, t0.linkedin_email_encrypted AS linkedin_email_encrypted_42, t0.linkedin_password_encrypted AS linkedin_password_encrypted_43, t0.linkedin_credentials_saved_at AS linkedin_credentials_saved_at_44, t0.checkpoint_type AS checkpoint_type_45, t0.onboarding_step AS onboarding_step_46, t0.password_reset_token AS password_reset_token_47, t0.password_reset_expires_at AS password_reset_expires_at_48, t0.recette_test_progress AS recette_test_progress_49, t0.client_id AS client_id_50 FROM `user` t0 WHERE t0.id = 311;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.profile AS profile_3,
  t0.mission AS mission_4,
  t0.ref AS ref_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.modified_at AS modified_at_8,
  t0.city AS city_9,
  t0.remuneration AS remuneration_10,
  t0.slug AS slug_11,
  t0.url AS url_12,
  t0.positive_prompt AS positive_prompt_13,
  t0.negative_prompt AS negative_prompt_14,
  t0.user_id AS user_id_15,
  t0.job_contract_id AS job_contract_id_16,
  t0.job_study_id AS job_study_id_17,
  t0.job_xp_id AS job_xp_id_18,
  t0.job_urgency_id AS job_urgency_id_19,
  t0.client_id AS client_id_20
FROM
  job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.profile AS profile_3, t0.mission AS mission_4, t0.ref AS ref_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.city AS city_9, t0.remuneration AS remuneration_10, t0.slug AS slug_11, t0.url AS url_12, t0.positive_prompt AS positive_prompt_13, t0.negative_prompt AS negative_prompt_14, t0.user_id AS user_id_15, t0.job_contract_id AS job_contract_id_16, t0.job_study_id AS job_study_id_17, t0.job_xp_id AS job_xp_id_18, t0.job_urgency_id AS job_urgency_id_19, t0.client_id AS client_id_20 FROM job t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.display_name AS display_name_4,
  t0.domain_restriction AS domain_restriction_5,
  t0.slug AS slug_6,
  t0.token_recruiter AS token_recruiter_7,
  t0.token_cooptor AS token_cooptor_8,
  t0.benefits AS benefits_9,
  t0.job_banner AS job_banner_10,
  t0.locale AS locale_11,
  t0.is_active AS is_active_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.max_recruiter AS max_recruiter_15,
  t0.max_cooptor AS max_cooptor_16,
  t0.description AS description_17,
  t0.demo AS demo_18,
  t0.favorable_criteria AS favorable_criteria_19,
  t0.disqualifying_criteria AS disqualifying_criteria_20,
  t0.client_id AS client_id_21
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.display_name AS display_name_4, t0.domain_restriction AS domain_restriction_5, t0.slug AS slug_6, t0.token_recruiter AS token_recruiter_7, t0.token_cooptor AS token_cooptor_8, t0.benefits AS benefits_9, t0.job_banner AS job_banner_10, t0.locale AS locale_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.max_recruiter AS max_recruiter_15, t0.max_cooptor AS max_cooptor_16, t0.description AS description_17, t0.demo AS demo_18, t0.favorable_criteria AS favorable_criteria_19, t0.disqualifying_criteria AS disqualifying_criteria_20, t0.client_id AS client_id_21 FROM client t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.linkedin AS linkedin_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.job AS job_5,
  t0.photo AS photo_6,
  t0.created_at AS created_at_7,
  t0.email AS email_8,
  t0.linkedin_data AS linkedin_data_9,
  t0.number_connections AS number_connections_10,
  t0.number_followers AS number_followers_11,
  t0.open_to_work AS open_to_work_12,
  t0.linkedin_profile_id AS linkedin_profile_id_13,
  t0.enrichment_job_id AS enrichment_job_id_14,
  t0.enrichment_locked_at AS enrichment_locked_at_15,
  t0.last_profile_sync_at AS last_profile_sync_at_16
FROM
  network t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.linkedin AS linkedin_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.job AS job_5, t0.photo AS photo_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.linkedin_data AS linkedin_data_9, t0.number_connections AS number_connections_10, t0.number_followers AS number_followers_11, t0.open_to_work AS open_to_work_12, t0.linkedin_profile_id AS linkedin_profile_id_13, t0.enrichment_job_id AS enrichment_job_id_14, t0.enrichment_locked_at AS enrichment_locked_at_15, t0.last_profile_sync_at AS last_profile_sync_at_16 FROM network t0 WHERE t0.id = '5996';