Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.domaine_name AS domaine_name_2,
  c0_.email_project AS email_project_3,
  c0_.mdp_email_project AS mdp_email_project_4,
  c0_.marge_my_flow AS marge_my_flow_5,
  c0_.logo_name AS logo_name_6,
  c0_.favicon_name AS favicon_name_7,
  c0_.enabled AS enabled_8,
  c0_.type_company AS type_company_9,
  c0_.cb_payment AS cb_payment_10,
  c0_.contract AS contract_11,
  c0_.customer_discount AS customer_discount_12,
  c0_.default_credit_cost AS default_credit_cost_13,
  c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.siren AS siren_17,
  c0_.front_id AS front_id_18,
  c0_.current_credit AS current_credit_19,
  c0_.current_balance AS current_balance_20,
  c0_.deleted AS deleted_21,
  c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22,
  c0_.extension_domain AS extension_domain_23,
  c0_.parent_id AS parent_id_24,
  c0_.company_data_id AS company_data_id_25,
  c0_.representative_id AS representative_id_26
FROM
  companies c0_
WHERE
  c0_.domaine_name LIKE ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.domaine_name AS domaine_name_2, c0_.email_project AS email_project_3, c0_.mdp_email_project AS mdp_email_project_4, c0_.marge_my_flow AS marge_my_flow_5, c0_.logo_name AS logo_name_6, c0_.favicon_name AS favicon_name_7, c0_.enabled AS enabled_8, c0_.type_company AS type_company_9, c0_.cb_payment AS cb_payment_10, c0_.contract AS contract_11, c0_.customer_discount AS customer_discount_12, c0_.default_credit_cost AS default_credit_cost_13, c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.siren AS siren_17, c0_.front_id AS front_id_18, c0_.current_credit AS current_credit_19, c0_.current_balance AS current_balance_20, c0_.deleted AS deleted_21, c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22, c0_.extension_domain AS extension_domain_23, c0_.parent_id AS parent_id_24, c0_.company_data_id AS company_data_id_25, c0_.representative_id AS representative_id_26 FROM companies c0_ WHERE c0_.domaine_name LIKE '%offshore-value.my-flow.fr%';

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.new_add AS new_add_3,
  t0.all_company AS all_company_4,
  t0.salary AS salary_5,
  t0.manager AS manager_6,
  t0.partner AS partner_7,
  t0.share_my_email AS share_my_email_8,
  t0.share_my_phone AS share_my_phone_9,
  t0.lastname AS lastname_10,
  t0.cell_phone AS cell_phone_11,
  t0.enabled AS enabled_12,
  t0.external AS external_13,
  t0.daily_rate AS daily_rate_14,
  t0.resale_rate AS resale_rate_15,
  t0.billing_method AS billing_method_16,
  t0.picture_name AS picture_name_17,
  t0.updated_at AS updated_at_18,
  t0.email AS email_19,
  t0.original_email AS original_email_20,
  t0.roles AS roles_21,
  t0.password AS password_22,
  t0.created_at AS created_at_23,
  t0.last_connection_at AS last_connection_at_24,
  t0.account_type AS account_type_25,
  t0.notification_type AS notification_type_26,
  t0.notification AS notification_27,
  t0.freq_notification AS freq_notification_28,
  t0.freq_notification_everytime AS freq_notification_everytime_29,
  t0.freq_notification_per_day AS freq_notification_per_day_30,
  t0.freq_notification_per_week AS freq_notification_per_week_31,
  t0.freq_notification_per_month AS freq_notification_per_month_32,
  t0.is_active_notification AS is_active_notification_33,
  t0.deleted AS deleted_34,
  t0.referencing_confirmation_notification AS referencing_confirmation_notification_35,
  t0.gender AS gender_36,
  t0.device_connected_list AS device_connected_list_37,
  t0.invisible AS invisible_38,
  t0.last_activity_at AS last_activity_at_39,
  t0.is_logged AS is_logged_40,
  t0.is_new_client AS is_new_client_41,
  t0.autorization_date_at AS autorization_date_at_42,
  t0.accept_presentation AS accept_presentation_43,
  t0.description AS description_44,
  t0.title AS title_45,
  t0.one_time_login_token AS one_time_login_token_46,
  t0.state AS state_47,
  t0.company_id AS company_id_48,
  t0.user_data_id AS user_data_id_49,
  t0.parent_id AS parent_id_50
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.id = '5BoLjw34NE6cRj3GZAHNR6';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.domaine_name AS domaine_name_2,
  c0_.email_project AS email_project_3,
  c0_.mdp_email_project AS mdp_email_project_4,
  c0_.marge_my_flow AS marge_my_flow_5,
  c0_.logo_name AS logo_name_6,
  c0_.favicon_name AS favicon_name_7,
  c0_.enabled AS enabled_8,
  c0_.type_company AS type_company_9,
  c0_.cb_payment AS cb_payment_10,
  c0_.contract AS contract_11,
  c0_.customer_discount AS customer_discount_12,
  c0_.default_credit_cost AS default_credit_cost_13,
  c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.siren AS siren_17,
  c0_.front_id AS front_id_18,
  c0_.current_credit AS current_credit_19,
  c0_.current_balance AS current_balance_20,
  c0_.deleted AS deleted_21,
  c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22,
  c0_.extension_domain AS extension_domain_23,
  c0_.parent_id AS parent_id_24,
  c0_.company_data_id AS company_data_id_25,
  c0_.representative_id AS representative_id_26
FROM
  companies c0_
WHERE
  c0_.domaine_name LIKE ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.domaine_name AS domaine_name_2, c0_.email_project AS email_project_3, c0_.mdp_email_project AS mdp_email_project_4, c0_.marge_my_flow AS marge_my_flow_5, c0_.logo_name AS logo_name_6, c0_.favicon_name AS favicon_name_7, c0_.enabled AS enabled_8, c0_.type_company AS type_company_9, c0_.cb_payment AS cb_payment_10, c0_.contract AS contract_11, c0_.customer_discount AS customer_discount_12, c0_.default_credit_cost AS default_credit_cost_13, c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.siren AS siren_17, c0_.front_id AS front_id_18, c0_.current_credit AS current_credit_19, c0_.current_balance AS current_balance_20, c0_.deleted AS deleted_21, c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22, c0_.extension_domain AS extension_domain_23, c0_.parent_id AS parent_id_24, c0_.company_data_id AS company_data_id_25, c0_.representative_id AS representative_id_26 FROM companies c0_ WHERE c0_.domaine_name LIKE '%offshore-value.my-flow.fr%';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  users
SET
  daily_rate = ?,
  resale_rate = ?,
  last_activity_at = ?,
  autorization_date_at = ?
WHERE
  id = ?

UPDATE users SET daily_rate = 0, resale_rate = 0, last_activity_at = '2024-11-21 15:00:19', autorization_date_at = '2024-11-21 15:00:19' WHERE id = '5BoLjw34NE6cRj3GZAHNR6';

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.state AS state_2,
  c0_.date_closed AS date_closed_3,
  c0_.is_new AS is_new_4,
  c0_.disabled AS disabled_5,
  c0_.confidentiality AS confidentiality_6,
  c0_.created_at AS created_at_7,
  c0_.invoiced AS invoiced_8,
  c0_.active_frequency AS active_frequency_9,
  c0_.total_cost_campaign AS total_cost_campaign_10,
  c0_.cancel_reason AS cancel_reason_11,
  c0_.brief AS brief_12,
  c0_.is_paid_on_credit AS is_paid_on_credit_13,
  c0_.payment_method AS payment_method_14,
  c0_.activated_at AS activated_at_15,
  c0_.client_status AS client_status_16,
  c0_.is_to_beinvoiced AS is_to_beinvoiced_17,
  c0_.discount_for_company AS discount_for_company_18,
  c0_.re_send_to_client AS re_send_to_client_19,
  c0_.number_initial_of_missions AS number_initial_of_missions_20,
  c0_.last_state AS last_state_21,
  c0_.delete_reason AS delete_reason_22,
  c0_.is_ordored_by_admin AS is_ordored_by_admin_23,
  c0_.defaut_observer AS defaut_observer_24,
  c0_.default_validator AS default_validator_25,
  c0_.default_validator_external AS default_validator_external_26,
  c0_.defaut_observer_external AS defaut_observer_external_27,
  c0_.status_modify_at AS status_modify_at_28,
  c0_.is_recurrent AS is_recurrent_29,
  c0_.recurring_state AS recurring_state_30,
  c0_.last_step_wp AS last_step_wp_31,
  c0_.front_wp_id AS front_wp_id_32,
  c0_.wp_slug AS wp_slug_33,
  c0_.state_history AS state_history_34,
  c0_.type_initiation AS type_initiation_35,
  c0_.email_sent_insuff_budget AS email_sent_insuff_budget_36,
  c0_.user_writing AS user_writing_37,
  c0_.cloning_source_id AS cloning_source_id_38,
  c0_.is_activated AS is_activated_39,
  c0_.company_id AS company_id_40,
  c0_.ordered_by_id AS ordered_by_id_41,
  c0_.frequency_id AS frequency_id_42,
  c0_.credit_history_id AS credit_history_id_43
FROM
  campaigns c0_
  LEFT JOIN missions m1_ ON c0_.id = m1_.campaign_id
  LEFT JOIN mission_participants m2_ ON m1_.id = m2_.mission_id
WHERE
  c0_.created_at > ?
  AND c0_.state NOT IN (?)
  AND m2_.refused = ?
  AND m2_.user_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.state AS state_2, c0_.date_closed AS date_closed_3, c0_.is_new AS is_new_4, c0_.disabled AS disabled_5, c0_.confidentiality AS confidentiality_6, c0_.created_at AS created_at_7, c0_.invoiced AS invoiced_8, c0_.active_frequency AS active_frequency_9, c0_.total_cost_campaign AS total_cost_campaign_10, c0_.cancel_reason AS cancel_reason_11, c0_.brief AS brief_12, c0_.is_paid_on_credit AS is_paid_on_credit_13, c0_.payment_method AS payment_method_14, c0_.activated_at AS activated_at_15, c0_.client_status AS client_status_16, c0_.is_to_beinvoiced AS is_to_beinvoiced_17, c0_.discount_for_company AS discount_for_company_18, c0_.re_send_to_client AS re_send_to_client_19, c0_.number_initial_of_missions AS number_initial_of_missions_20, c0_.last_state AS last_state_21, c0_.delete_reason AS delete_reason_22, c0_.is_ordored_by_admin AS is_ordored_by_admin_23, c0_.defaut_observer AS defaut_observer_24, c0_.default_validator AS default_validator_25, c0_.default_validator_external AS default_validator_external_26, c0_.defaut_observer_external AS defaut_observer_external_27, c0_.status_modify_at AS status_modify_at_28, c0_.is_recurrent AS is_recurrent_29, c0_.recurring_state AS recurring_state_30, c0_.last_step_wp AS last_step_wp_31, c0_.front_wp_id AS front_wp_id_32, c0_.wp_slug AS wp_slug_33, c0_.state_history AS state_history_34, c0_.type_initiation AS type_initiation_35, c0_.email_sent_insuff_budget AS email_sent_insuff_budget_36, c0_.user_writing AS user_writing_37, c0_.cloning_source_id AS cloning_source_id_38, c0_.is_activated AS is_activated_39, c0_.company_id AS company_id_40, c0_.ordered_by_id AS ordered_by_id_41, c0_.frequency_id AS frequency_id_42, c0_.credit_history_id AS credit_history_id_43 FROM campaigns c0_ LEFT JOIN missions m1_ ON c0_.id = m1_.campaign_id LEFT JOIN mission_participants m2_ ON m1_.id = m2_.mission_id WHERE c0_.created_at > '2021-11-21 15:00:19' AND c0_.state NOT IN ('deleted') AND m2_.refused = 0 AND m2_.user_id = '5BoLjw34NE6cRj3GZAHNR6';

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.position_order AS position_order_3,
  t0.state_client AS state_client_4,
  t0.state_provider AS state_provider_5,
  t0.created_at AS created_at_6,
  t0.desired_delivery AS desired_delivery_7,
  t0.initial_briefing AS initial_briefing_8,
  t0.guide_step AS guide_step_9,
  t0.quantity AS quantity_10,
  t0.price AS price_11,
  t0.price_with_marge_my_flow AS price_with_marge_my_flow_12,
  t0.marge_my_flow AS marge_my_flow_13,
  t0.price_sale AS price_sale_14,
  t0.state AS state_15,
  t0.cancel_reason AS cancel_reason_16,
  t0.libelle_custom AS libelle_custom_17,
  t0.initial_time AS initial_time_18,
  t0.real_time AS real_time_19,
  t0.pre_activated_at AS pre_activated_at_20,
  t0.admin_time AS admin_time_21,
  t0.admin_income AS admin_income_22,
  t0.discount_for_company AS discount_for_company_23,
  t0.original_price AS original_price_24,
  t0.old_command AS old_command_25,
  t0.last_state AS last_state_26,
  t0.can_invoiced AS can_invoiced_27,
  t0.evaluate AS evaluate_28,
  t0.can_send_email_daily AS can_send_email_daily_29,
  t0.can_send_email_monthly AS can_send_email_monthly_30,
  t0.can_send_email_weekly AS can_send_email_weekly_31,
  t0.campaign_id AS campaign_id_32,
  t0.contact_id AS contact_id_33,
  t0.product_id AS product_id_34,
  t0.workflow_id AS workflow_id_35
FROM
  missions t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.position_order AS position_order_3, t0.state_client AS state_client_4, t0.state_provider AS state_provider_5, t0.created_at AS created_at_6, t0.desired_delivery AS desired_delivery_7, t0.initial_briefing AS initial_briefing_8, t0.guide_step AS guide_step_9, t0.quantity AS quantity_10, t0.price AS price_11, t0.price_with_marge_my_flow AS price_with_marge_my_flow_12, t0.marge_my_flow AS marge_my_flow_13, t0.price_sale AS price_sale_14, t0.state AS state_15, t0.cancel_reason AS cancel_reason_16, t0.libelle_custom AS libelle_custom_17, t0.initial_time AS initial_time_18, t0.real_time AS real_time_19, t0.pre_activated_at AS pre_activated_at_20, t0.admin_time AS admin_time_21, t0.admin_income AS admin_income_22, t0.discount_for_company AS discount_for_company_23, t0.original_price AS original_price_24, t0.old_command AS old_command_25, t0.last_state AS last_state_26, t0.can_invoiced AS can_invoiced_27, t0.evaluate AS evaluate_28, t0.can_send_email_daily AS can_send_email_daily_29, t0.can_send_email_monthly AS can_send_email_monthly_30, t0.can_send_email_weekly AS can_send_email_weekly_31, t0.campaign_id AS campaign_id_32, t0.contact_id AS contact_id_33, t0.product_id AS product_id_34, t0.workflow_id AS workflow_id_35 FROM missions t0 WHERE t0.campaign_id = 'WVt32qcZtajpei3Wec6SxW';

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.estimated_income AS estimated_income_3,
  t0.income_suggested AS income_suggested_4,
  t0.initial_time AS initial_time_5,
  t0.estimated_income_admin AS estimated_income_admin_6,
  t0.initial_time_admin AS initial_time_admin_7,
  t0.activated AS activated_8,
  t0.refused AS refused_9,
  t0.activated_at AS activated_at_10,
  t0.valid_step AS valid_step_11,
  t0.state_add AS state_add_12,
  t0.evaluate AS evaluate_13,
  t0.mission_id AS mission_id_14,
  t0.user_id AS user_id_15,
  t0.job_id AS job_id_16
FROM
  mission_participants t0
WHERE
  t0.mission_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.estimated_income AS estimated_income_3, t0.income_suggested AS income_suggested_4, t0.initial_time AS initial_time_5, t0.estimated_income_admin AS estimated_income_admin_6, t0.initial_time_admin AS initial_time_admin_7, t0.activated AS activated_8, t0.refused AS refused_9, t0.activated_at AS activated_at_10, t0.valid_step AS valid_step_11, t0.state_add AS state_add_12, t0.evaluate AS evaluate_13, t0.mission_id AS mission_id_14, t0.user_id AS user_id_15, t0.job_id AS job_id_16 FROM mission_participants t0 WHERE t0.mission_id = 'CzW1ni3pe684qakiahF5h4';

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.new_add AS new_add_3,
  t0.all_company AS all_company_4,
  t0.salary AS salary_5,
  t0.manager AS manager_6,
  t0.partner AS partner_7,
  t0.share_my_email AS share_my_email_8,
  t0.share_my_phone AS share_my_phone_9,
  t0.lastname AS lastname_10,
  t0.cell_phone AS cell_phone_11,
  t0.enabled AS enabled_12,
  t0.external AS external_13,
  t0.daily_rate AS daily_rate_14,
  t0.resale_rate AS resale_rate_15,
  t0.billing_method AS billing_method_16,
  t0.picture_name AS picture_name_17,
  t0.updated_at AS updated_at_18,
  t0.email AS email_19,
  t0.original_email AS original_email_20,
  t0.roles AS roles_21,
  t0.password AS password_22,
  t0.created_at AS created_at_23,
  t0.last_connection_at AS last_connection_at_24,
  t0.account_type AS account_type_25,
  t0.notification_type AS notification_type_26,
  t0.notification AS notification_27,
  t0.freq_notification AS freq_notification_28,
  t0.freq_notification_everytime AS freq_notification_everytime_29,
  t0.freq_notification_per_day AS freq_notification_per_day_30,
  t0.freq_notification_per_week AS freq_notification_per_week_31,
  t0.freq_notification_per_month AS freq_notification_per_month_32,
  t0.is_active_notification AS is_active_notification_33,
  t0.deleted AS deleted_34,
  t0.referencing_confirmation_notification AS referencing_confirmation_notification_35,
  t0.gender AS gender_36,
  t0.device_connected_list AS device_connected_list_37,
  t0.invisible AS invisible_38,
  t0.last_activity_at AS last_activity_at_39,
  t0.is_logged AS is_logged_40,
  t0.is_new_client AS is_new_client_41,
  t0.autorization_date_at AS autorization_date_at_42,
  t0.accept_presentation AS accept_presentation_43,
  t0.description AS description_44,
  t0.title AS title_45,
  t0.one_time_login_token AS one_time_login_token_46,
  t0.state AS state_47,
  t0.company_id AS company_id_48,
  t0.user_data_id AS user_data_id_49,
  t0.parent_id AS parent_id_50
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.new_add AS new_add_3, t0.all_company AS all_company_4, t0.salary AS salary_5, t0.manager AS manager_6, t0.partner AS partner_7, t0.share_my_email AS share_my_email_8, t0.share_my_phone AS share_my_phone_9, t0.lastname AS lastname_10, t0.cell_phone AS cell_phone_11, t0.enabled AS enabled_12, t0.external AS external_13, t0.daily_rate AS daily_rate_14, t0.resale_rate AS resale_rate_15, t0.billing_method AS billing_method_16, t0.picture_name AS picture_name_17, t0.updated_at AS updated_at_18, t0.email AS email_19, t0.original_email AS original_email_20, t0.roles AS roles_21, t0.password AS password_22, t0.created_at AS created_at_23, t0.last_connection_at AS last_connection_at_24, t0.account_type AS account_type_25, t0.notification_type AS notification_type_26, t0.notification AS notification_27, t0.freq_notification AS freq_notification_28, t0.freq_notification_everytime AS freq_notification_everytime_29, t0.freq_notification_per_day AS freq_notification_per_day_30, t0.freq_notification_per_week AS freq_notification_per_week_31, t0.freq_notification_per_month AS freq_notification_per_month_32, t0.is_active_notification AS is_active_notification_33, t0.deleted AS deleted_34, t0.referencing_confirmation_notification AS referencing_confirmation_notification_35, t0.gender AS gender_36, t0.device_connected_list AS device_connected_list_37, t0.invisible AS invisible_38, t0.last_activity_at AS last_activity_at_39, t0.is_logged AS is_logged_40, t0.is_new_client AS is_new_client_41, t0.autorization_date_at AS autorization_date_at_42, t0.accept_presentation AS accept_presentation_43, t0.description AS description_44, t0.title AS title_45, t0.one_time_login_token AS one_time_login_token_46, t0.state AS state_47, t0.company_id AS company_id_48, t0.user_data_id AS user_data_id_49, t0.parent_id AS parent_id_50 FROM users t0 WHERE t0.id = 'CvvCaUqnc8XASpJwiD2C7W';

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.estimated_income AS estimated_income_3,
  t0.income_suggested AS income_suggested_4,
  t0.initial_time AS initial_time_5,
  t0.estimated_income_admin AS estimated_income_admin_6,
  t0.initial_time_admin AS initial_time_admin_7,
  t0.activated AS activated_8,
  t0.refused AS refused_9,
  t0.activated_at AS activated_at_10,
  t0.valid_step AS valid_step_11,
  t0.state_add AS state_add_12,
  t0.evaluate AS evaluate_13,
  t0.mission_id AS mission_id_14,
  t0.user_id AS user_id_15,
  t0.job_id AS job_id_16
FROM
  mission_participants t0
WHERE
  t0.mission_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.estimated_income AS estimated_income_3, t0.income_suggested AS income_suggested_4, t0.initial_time AS initial_time_5, t0.estimated_income_admin AS estimated_income_admin_6, t0.initial_time_admin AS initial_time_admin_7, t0.activated AS activated_8, t0.refused AS refused_9, t0.activated_at AS activated_at_10, t0.valid_step AS valid_step_11, t0.state_add AS state_add_12, t0.evaluate AS evaluate_13, t0.mission_id AS mission_id_14, t0.user_id AS user_id_15, t0.job_id AS job_id_16 FROM mission_participants t0 WHERE t0.mission_id = 'Erig2JJLw12apbCRDSvMBi';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.state AS state_2,
  c0_.date_closed AS date_closed_3,
  c0_.is_new AS is_new_4,
  c0_.disabled AS disabled_5,
  c0_.confidentiality AS confidentiality_6,
  c0_.created_at AS created_at_7,
  c0_.invoiced AS invoiced_8,
  c0_.active_frequency AS active_frequency_9,
  c0_.total_cost_campaign AS total_cost_campaign_10,
  c0_.cancel_reason AS cancel_reason_11,
  c0_.brief AS brief_12,
  c0_.is_paid_on_credit AS is_paid_on_credit_13,
  c0_.payment_method AS payment_method_14,
  c0_.activated_at AS activated_at_15,
  c0_.client_status AS client_status_16,
  c0_.is_to_beinvoiced AS is_to_beinvoiced_17,
  c0_.discount_for_company AS discount_for_company_18,
  c0_.re_send_to_client AS re_send_to_client_19,
  c0_.number_initial_of_missions AS number_initial_of_missions_20,
  c0_.last_state AS last_state_21,
  c0_.delete_reason AS delete_reason_22,
  c0_.is_ordored_by_admin AS is_ordored_by_admin_23,
  c0_.defaut_observer AS defaut_observer_24,
  c0_.default_validator AS default_validator_25,
  c0_.default_validator_external AS default_validator_external_26,
  c0_.defaut_observer_external AS defaut_observer_external_27,
  c0_.status_modify_at AS status_modify_at_28,
  c0_.is_recurrent AS is_recurrent_29,
  c0_.recurring_state AS recurring_state_30,
  c0_.last_step_wp AS last_step_wp_31,
  c0_.front_wp_id AS front_wp_id_32,
  c0_.wp_slug AS wp_slug_33,
  c0_.state_history AS state_history_34,
  c0_.type_initiation AS type_initiation_35,
  c0_.email_sent_insuff_budget AS email_sent_insuff_budget_36,
  c0_.user_writing AS user_writing_37,
  c0_.cloning_source_id AS cloning_source_id_38,
  c0_.is_activated AS is_activated_39,
  c0_.company_id AS company_id_40,
  c0_.ordered_by_id AS ordered_by_id_41,
  c0_.frequency_id AS frequency_id_42,
  c0_.credit_history_id AS credit_history_id_43
FROM
  campaigns c0_
  LEFT JOIN missions m1_ ON c0_.id = m1_.campaign_id
  LEFT JOIN companies c2_ ON c0_.company_id = c2_.id
  LEFT JOIN mission_participants m3_ ON m1_.id = m3_.mission_id
  INNER JOIN mission_participants m4_ ON m1_.id = m4_.mission_id
  LEFT JOIN products p5_ ON m1_.product_id = p5_.id
WHERE
  (
    (
      m3_.refused = ?
      AND m3_.user_id = ?
    )
    OR c0_.ordered_by_id = ?
    OR c0_.ordered_by_id = ?
  )
  AND c0_.state NOT IN (?)
  AND c0_.state NOT IN (?)
  AND c0_.state NOT IN (?)
  AND c0_.disabled IS NULL
ORDER BY
  CASE WHEN c0_.state = 'waiting_validation' THEN 1 ELSE 2 END ASC,
  CASE WHEN c0_.state = 'resend' THEN 1 ELSE 2 END ASC,
  CASE WHEN c0_.state = 'in_progress' THEN 1 ELSE 2 END ASC,
  m1_.reference ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.state AS state_2, c0_.date_closed AS date_closed_3, c0_.is_new AS is_new_4, c0_.disabled AS disabled_5, c0_.confidentiality AS confidentiality_6, c0_.created_at AS created_at_7, c0_.invoiced AS invoiced_8, c0_.active_frequency AS active_frequency_9, c0_.total_cost_campaign AS total_cost_campaign_10, c0_.cancel_reason AS cancel_reason_11, c0_.brief AS brief_12, c0_.is_paid_on_credit AS is_paid_on_credit_13, c0_.payment_method AS payment_method_14, c0_.activated_at AS activated_at_15, c0_.client_status AS client_status_16, c0_.is_to_beinvoiced AS is_to_beinvoiced_17, c0_.discount_for_company AS discount_for_company_18, c0_.re_send_to_client AS re_send_to_client_19, c0_.number_initial_of_missions AS number_initial_of_missions_20, c0_.last_state AS last_state_21, c0_.delete_reason AS delete_reason_22, c0_.is_ordored_by_admin AS is_ordored_by_admin_23, c0_.defaut_observer AS defaut_observer_24, c0_.default_validator AS default_validator_25, c0_.default_validator_external AS default_validator_external_26, c0_.defaut_observer_external AS defaut_observer_external_27, c0_.status_modify_at AS status_modify_at_28, c0_.is_recurrent AS is_recurrent_29, c0_.recurring_state AS recurring_state_30, c0_.last_step_wp AS last_step_wp_31, c0_.front_wp_id AS front_wp_id_32, c0_.wp_slug AS wp_slug_33, c0_.state_history AS state_history_34, c0_.type_initiation AS type_initiation_35, c0_.email_sent_insuff_budget AS email_sent_insuff_budget_36, c0_.user_writing AS user_writing_37, c0_.cloning_source_id AS cloning_source_id_38, c0_.is_activated AS is_activated_39, c0_.company_id AS company_id_40, c0_.ordered_by_id AS ordered_by_id_41, c0_.frequency_id AS frequency_id_42, c0_.credit_history_id AS credit_history_id_43 FROM campaigns c0_ LEFT JOIN missions m1_ ON c0_.id = m1_.campaign_id LEFT JOIN companies c2_ ON c0_.company_id = c2_.id LEFT JOIN mission_participants m3_ ON m1_.id = m3_.mission_id INNER JOIN mission_participants m4_ ON m1_.id = m4_.mission_id LEFT JOIN products p5_ ON m1_.product_id = p5_.id WHERE ((m3_.refused = 0 AND m3_.user_id = '5BoLjw34NE6cRj3GZAHNR6') OR c0_.ordered_by_id = '5BoLjw34NE6cRj3GZAHNR6' OR c0_.ordered_by_id = '5BoLjw34NE6cRj3GZAHNR6') AND c0_.state NOT IN ('closed', 'cancelled', 'archived') AND c0_.state NOT IN ('deleted') AND c0_.state NOT IN ('recurred') AND c0_.disabled IS NULL ORDER BY CASE WHEN c0_.state = 'waiting_validation' THEN 1 ELSE 2 END ASC, CASE WHEN c0_.state = 'resend' THEN 1 ELSE 2 END ASC, CASE WHEN c0_.state = 'in_progress' THEN 1 ELSE 2 END ASC, m1_.reference ASC;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.name AS name_2,
  c0_.credit AS credit_3,
  c0_.mensualite AS mensualite_4,
  c0_.annuite AS annuite_5,
  c0_.report AS report_6,
  c0_.cost AS cost_7,
  c0_.credit_expired_at AS credit_expired_at_8,
  c0_.type_pack AS type_pack_9,
  c0_.start_date_contract AS start_date_contract_10,
  c0_.automatic_renewal AS automatic_renewal_11,
  c0_.end_date_contract AS end_date_contract_12,
  c0_.order_price AS order_price_13,
  c0_.current_balance AS current_balance_14,
  c0_.fin_du_mois AS fin_du_mois_15,
  c0_.availability_duration AS availability_duration_16,
  c0_.balance_reason_updated AS balance_reason_updated_17,
  c0_.deleted AS deleted_18,
  c0_.total_consumption AS total_consumption_19,
  c0_.company_id AS company_id_20,
  c0_.ordered_by_id AS ordered_by_id_21
FROM
  credit_history c0_
WHERE
  ? > c0_.start_date_contract
  AND ? < c0_.credit_expired_at
  AND c0_.company_id = ?

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.name AS name_2, c0_.credit AS credit_3, c0_.mensualite AS mensualite_4, c0_.annuite AS annuite_5, c0_.report AS report_6, c0_.cost AS cost_7, c0_.credit_expired_at AS credit_expired_at_8, c0_.type_pack AS type_pack_9, c0_.start_date_contract AS start_date_contract_10, c0_.automatic_renewal AS automatic_renewal_11, c0_.end_date_contract AS end_date_contract_12, c0_.order_price AS order_price_13, c0_.current_balance AS current_balance_14, c0_.fin_du_mois AS fin_du_mois_15, c0_.availability_duration AS availability_duration_16, c0_.balance_reason_updated AS balance_reason_updated_17, c0_.deleted AS deleted_18, c0_.total_consumption AS total_consumption_19, c0_.company_id AS company_id_20, c0_.ordered_by_id AS ordered_by_id_21 FROM credit_history c0_ WHERE '2024-11-21 15:00:19' > c0_.start_date_contract AND '2024-11-21 15:00:19' < c0_.credit_expired_at AND c0_.company_id = 'PJBMxzaH5hGuhkp7fX36XM';

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.position_order AS position_order_3,
  t0.state_client AS state_client_4,
  t0.state_provider AS state_provider_5,
  t0.created_at AS created_at_6,
  t0.desired_delivery AS desired_delivery_7,
  t0.initial_briefing AS initial_briefing_8,
  t0.guide_step AS guide_step_9,
  t0.quantity AS quantity_10,
  t0.price AS price_11,
  t0.price_with_marge_my_flow AS price_with_marge_my_flow_12,
  t0.marge_my_flow AS marge_my_flow_13,
  t0.price_sale AS price_sale_14,
  t0.state AS state_15,
  t0.cancel_reason AS cancel_reason_16,
  t0.libelle_custom AS libelle_custom_17,
  t0.initial_time AS initial_time_18,
  t0.real_time AS real_time_19,
  t0.pre_activated_at AS pre_activated_at_20,
  t0.admin_time AS admin_time_21,
  t0.admin_income AS admin_income_22,
  t0.discount_for_company AS discount_for_company_23,
  t0.original_price AS original_price_24,
  t0.old_command AS old_command_25,
  t0.last_state AS last_state_26,
  t0.can_invoiced AS can_invoiced_27,
  t0.evaluate AS evaluate_28,
  t0.can_send_email_daily AS can_send_email_daily_29,
  t0.can_send_email_monthly AS can_send_email_monthly_30,
  t0.can_send_email_weekly AS can_send_email_weekly_31,
  t0.campaign_id AS campaign_id_32,
  t0.contact_id AS contact_id_33,
  t0.product_id AS product_id_34,
  t0.workflow_id AS workflow_id_35
FROM
  missions t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.position_order AS position_order_3, t0.state_client AS state_client_4, t0.state_provider AS state_provider_5, t0.created_at AS created_at_6, t0.desired_delivery AS desired_delivery_7, t0.initial_briefing AS initial_briefing_8, t0.guide_step AS guide_step_9, t0.quantity AS quantity_10, t0.price AS price_11, t0.price_with_marge_my_flow AS price_with_marge_my_flow_12, t0.marge_my_flow AS marge_my_flow_13, t0.price_sale AS price_sale_14, t0.state AS state_15, t0.cancel_reason AS cancel_reason_16, t0.libelle_custom AS libelle_custom_17, t0.initial_time AS initial_time_18, t0.real_time AS real_time_19, t0.pre_activated_at AS pre_activated_at_20, t0.admin_time AS admin_time_21, t0.admin_income AS admin_income_22, t0.discount_for_company AS discount_for_company_23, t0.original_price AS original_price_24, t0.old_command AS old_command_25, t0.last_state AS last_state_26, t0.can_invoiced AS can_invoiced_27, t0.evaluate AS evaluate_28, t0.can_send_email_daily AS can_send_email_daily_29, t0.can_send_email_monthly AS can_send_email_monthly_30, t0.can_send_email_weekly AS can_send_email_weekly_31, t0.campaign_id AS campaign_id_32, t0.contact_id AS contact_id_33, t0.product_id AS product_id_34, t0.workflow_id AS workflow_id_35 FROM missions t0 WHERE t0.campaign_id = 'DUeutMGmgpJvyWuneDYVsV';