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 '%app.dev.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 = 'JpJCxzoJkC2TqNYCes1YEm';

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 '%app.dev.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-22 08:49:45', autorization_date_at = '2024-11-22 08:49:45' WHERE id = 'JpJCxzoJkC2TqNYCes1YEm';

"COMMIT"

"COMMIT";

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.id = ?
LIMIT
  1

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.id = '6tV5XUVf9WKx8iQgam3bKu' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.state AS state_3,
  t0.date_closed AS date_closed_4,
  t0.is_new AS is_new_5,
  t0.disabled AS disabled_6,
  t0.confidentiality AS confidentiality_7,
  t0.created_at AS created_at_8,
  t0.invoiced AS invoiced_9,
  t0.active_frequency AS active_frequency_10,
  t0.total_cost_campaign AS total_cost_campaign_11,
  t0.cancel_reason AS cancel_reason_12,
  t0.brief AS brief_13,
  t0.is_paid_on_credit AS is_paid_on_credit_14,
  t0.payment_method AS payment_method_15,
  t0.activated_at AS activated_at_16,
  t0.client_status AS client_status_17,
  t0.is_to_beinvoiced AS is_to_beinvoiced_18,
  t0.discount_for_company AS discount_for_company_19,
  t0.re_send_to_client AS re_send_to_client_20,
  t0.number_initial_of_missions AS number_initial_of_missions_21,
  t0.last_state AS last_state_22,
  t0.delete_reason AS delete_reason_23,
  t0.is_ordored_by_admin AS is_ordored_by_admin_24,
  t0.defaut_observer AS defaut_observer_25,
  t0.default_validator AS default_validator_26,
  t0.default_validator_external AS default_validator_external_27,
  t0.defaut_observer_external AS defaut_observer_external_28,
  t0.status_modify_at AS status_modify_at_29,
  t0.is_recurrent AS is_recurrent_30,
  t0.recurring_state AS recurring_state_31,
  t0.last_step_wp AS last_step_wp_32,
  t0.front_wp_id AS front_wp_id_33,
  t0.wp_slug AS wp_slug_34,
  t0.state_history AS state_history_35,
  t0.type_initiation AS type_initiation_36,
  t0.email_sent_insuff_budget AS email_sent_insuff_budget_37,
  t0.user_writing AS user_writing_38,
  t0.cloning_source_id AS cloning_source_id_39,
  t0.is_activated AS is_activated_40,
  t0.company_id AS company_id_41,
  t0.ordered_by_id AS ordered_by_id_42,
  t0.frequency_id AS frequency_id_43,
  t0.credit_history_id AS credit_history_id_44
FROM
  campaigns t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.date_closed AS date_closed_4, t0.is_new AS is_new_5, t0.disabled AS disabled_6, t0.confidentiality AS confidentiality_7, t0.created_at AS created_at_8, t0.invoiced AS invoiced_9, t0.active_frequency AS active_frequency_10, t0.total_cost_campaign AS total_cost_campaign_11, t0.cancel_reason AS cancel_reason_12, t0.brief AS brief_13, t0.is_paid_on_credit AS is_paid_on_credit_14, t0.payment_method AS payment_method_15, t0.activated_at AS activated_at_16, t0.client_status AS client_status_17, t0.is_to_beinvoiced AS is_to_beinvoiced_18, t0.discount_for_company AS discount_for_company_19, t0.re_send_to_client AS re_send_to_client_20, t0.number_initial_of_missions AS number_initial_of_missions_21, t0.last_state AS last_state_22, t0.delete_reason AS delete_reason_23, t0.is_ordored_by_admin AS is_ordored_by_admin_24, t0.defaut_observer AS defaut_observer_25, t0.default_validator AS default_validator_26, t0.default_validator_external AS default_validator_external_27, t0.defaut_observer_external AS defaut_observer_external_28, t0.status_modify_at AS status_modify_at_29, t0.is_recurrent AS is_recurrent_30, t0.recurring_state AS recurring_state_31, t0.last_step_wp AS last_step_wp_32, t0.front_wp_id AS front_wp_id_33, t0.wp_slug AS wp_slug_34, t0.state_history AS state_history_35, t0.type_initiation AS type_initiation_36, t0.email_sent_insuff_budget AS email_sent_insuff_budget_37, t0.user_writing AS user_writing_38, t0.cloning_source_id AS cloning_source_id_39, t0.is_activated AS is_activated_40, t0.company_id AS company_id_41, t0.ordered_by_id AS ordered_by_id_42, t0.frequency_id AS frequency_id_43, t0.credit_history_id AS credit_history_id_44 FROM campaigns t0 WHERE t0.id = 'Mz57Dp3dhEpMSMgUCwN11q';

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.user_list_who_read AS user_list_who_read_4,
  t0.origin AS origin_5,
  t0.reply_to AS reply_to_6,
  t0.original_content AS original_content_7,
  t0.is_deleted AS is_deleted_8,
  t0.is_modified AS is_modified_9,
  t0.user_id AS user_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.mission_id AS mission_id_12
FROM
  messages t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_list_who_read AS user_list_who_read_4, t0.origin AS origin_5, t0.reply_to AS reply_to_6, t0.original_content AS original_content_7, t0.is_deleted AS is_deleted_8, t0.is_modified AS is_modified_9, t0.user_id AS user_id_10, t0.campaign_id AS campaign_id_11, t0.mission_id AS mission_id_12 FROM messages t0 WHERE t0.id = 'VCsBnbZ1dsqmnkfmbL5FdN' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.content AS content_1,
  m0_.created_at AS created_at_2,
  m0_.user_list_who_read AS user_list_who_read_3,
  m0_.origin AS origin_4,
  m0_.reply_to AS reply_to_5,
  m0_.original_content AS original_content_6,
  m0_.is_deleted AS is_deleted_7,
  m0_.is_modified AS is_modified_8,
  m0_.user_id AS user_id_9,
  m0_.campaign_id AS campaign_id_10,
  m0_.mission_id AS mission_id_11
FROM
  messages m0_
WHERE
  m0_.campaign_id = ?
  AND m0_.created_at > ?
  AND (
    m0_.is_deleted <> 1
    OR m0_.is_deleted IS NULL
  )
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.created_at AS created_at_2, m0_.user_list_who_read AS user_list_who_read_3, m0_.origin AS origin_4, m0_.reply_to AS reply_to_5, m0_.original_content AS original_content_6, m0_.is_deleted AS is_deleted_7, m0_.is_modified AS is_modified_8, m0_.user_id AS user_id_9, m0_.campaign_id AS campaign_id_10, m0_.mission_id AS mission_id_11 FROM messages m0_ WHERE m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND m0_.created_at > '2024-11-06 07:37:43' AND (m0_.is_deleted <> 1 OR m0_.is_deleted IS NULL) ORDER BY m0_.created_at DESC;

SELECT
  m0_.id AS id_0
FROM
  messages m0_
WHERE
  m0_.campaign_id = ?
  AND m0_.is_deleted = 1
GROUP BY
  m0_.id

SELECT m0_.id AS id_0 FROM messages m0_ WHERE m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND m0_.is_deleted = 1 GROUP BY m0_.id;

SELECT
  f0_.id AS id_0
FROM
  files_messages f0_
  LEFT JOIN messages m1_ ON f0_.messages_id = m1_.id
WHERE
  m1_.campaign_id = ?
  AND f0_.is_deleted = 1
GROUP BY
  f0_.id

SELECT f0_.id AS id_0 FROM files_messages f0_ LEFT JOIN messages m1_ ON f0_.messages_id = m1_.id WHERE m1_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND f0_.is_deleted = 1 GROUP BY f0_.id;

SELECT
  m0_.id AS id_0,
  m0_.content AS content_1
FROM
  messages m0_
WHERE
  m0_.campaign_id = ?
  AND m0_.is_modified = 1
  AND (
    m0_.is_deleted <> 1
    OR m0_.is_deleted IS NULL
  )
GROUP BY
  m0_.id

SELECT m0_.id AS id_0, m0_.content AS content_1 FROM messages m0_ WHERE m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND m0_.is_modified = 1 AND (m0_.is_deleted <> 1 OR m0_.is_deleted IS NULL) GROUP BY m0_.id;

SELECT
  m0_.id AS id_0,
  m0_.content AS content_1,
  m0_.created_at AS created_at_2,
  m0_.user_list_who_read AS user_list_who_read_3,
  m0_.origin AS origin_4,
  m0_.reply_to AS reply_to_5,
  m0_.original_content AS original_content_6,
  m0_.is_deleted AS is_deleted_7,
  m0_.is_modified AS is_modified_8,
  m0_.user_id AS user_id_9,
  m0_.campaign_id AS campaign_id_10,
  m0_.mission_id AS mission_id_11
FROM
  messages m0_
  LEFT JOIN message_reaction m1_ ON m0_.id = m1_.message_id
WHERE
  m1_.emoji IS NOT NULL
  AND m0_.campaign_id = ?
  AND (
    m0_.is_deleted <> 1
    OR m0_.is_deleted IS NULL
  )
GROUP BY
  m0_.id

SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.created_at AS created_at_2, m0_.user_list_who_read AS user_list_who_read_3, m0_.origin AS origin_4, m0_.reply_to AS reply_to_5, m0_.original_content AS original_content_6, m0_.is_deleted AS is_deleted_7, m0_.is_modified AS is_modified_8, m0_.user_id AS user_id_9, m0_.campaign_id AS campaign_id_10, m0_.mission_id AS mission_id_11 FROM messages m0_ LEFT JOIN message_reaction m1_ ON m0_.id = m1_.message_id WHERE m1_.emoji IS NOT NULL AND m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND (m0_.is_deleted <> 1 OR m0_.is_deleted IS NULL) GROUP BY m0_.id;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  messages m0_
WHERE
  m0_.campaign_id = ?
ORDER BY
  m0_.created_at DESC

SELECT COUNT(m0_.id) AS sclr_0 FROM messages m0_ WHERE m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' ORDER BY m0_.created_at DESC;

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 = '6tV5XUVf9WKx8iQgam3bKu';

SELECT
  m0_.id AS id_0,
  m0_.content AS content_1,
  m0_.created_at AS created_at_2,
  m0_.user_list_who_read AS user_list_who_read_3,
  m0_.origin AS origin_4,
  m0_.reply_to AS reply_to_5,
  m0_.original_content AS original_content_6,
  m0_.is_deleted AS is_deleted_7,
  m0_.is_modified AS is_modified_8,
  m0_.user_id AS user_id_9,
  m0_.campaign_id AS campaign_id_10,
  m0_.mission_id AS mission_id_11
FROM
  messages m0_
WHERE
  m0_.campaign_id = ?
  AND (
    m0_.is_deleted <> 1
    OR m0_.is_deleted IS NULL
  )
ORDER BY
  m0_.created_at DESC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.content AS content_1, m0_.created_at AS created_at_2, m0_.user_list_who_read AS user_list_who_read_3, m0_.origin AS origin_4, m0_.reply_to AS reply_to_5, m0_.original_content AS original_content_6, m0_.is_deleted AS is_deleted_7, m0_.is_modified AS is_modified_8, m0_.user_id AS user_id_9, m0_.campaign_id AS campaign_id_10, m0_.mission_id AS mission_id_11 FROM messages m0_ WHERE m0_.campaign_id = 'Mz57Dp3dhEpMSMgUCwN11q' AND (m0_.is_deleted <> 1 OR m0_.is_deleted IS NULL) ORDER BY m0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = 'VCsBnbZ1dsqmnkfmbL5FdN';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = '3XyyAr1YgUVhV4kA4GHrVh';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = 'VHEUcYcu3U3CQYEvDPuCYG';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = '41xfXoKRQYyLvFLALW3Lj6';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = '2raxzua5cHupABrunAXpYQ';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = 'JVQZkcAXJtk7wUU2j8h4D4';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = 'DyuWBGxgifLox25wpUt1RJ';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_new AS is_new_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.is_deleted AS is_deleted_6,
  t0.messages_id AS messages_id_7
FROM
  files_messages t0
WHERE
  t0.messages_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_new AS is_new_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.is_deleted AS is_deleted_6, t0.messages_id AS messages_id_7 FROM files_messages t0 WHERE t0.messages_id = '3FeHF9bR3RiU4bd41LCPqs';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.state AS state_3,
  t0.date_closed AS date_closed_4,
  t0.is_new AS is_new_5,
  t0.disabled AS disabled_6,
  t0.confidentiality AS confidentiality_7,
  t0.created_at AS created_at_8,
  t0.invoiced AS invoiced_9,
  t0.active_frequency AS active_frequency_10,
  t0.total_cost_campaign AS total_cost_campaign_11,
  t0.cancel_reason AS cancel_reason_12,
  t0.brief AS brief_13,
  t0.is_paid_on_credit AS is_paid_on_credit_14,
  t0.payment_method AS payment_method_15,
  t0.activated_at AS activated_at_16,
  t0.client_status AS client_status_17,
  t0.is_to_beinvoiced AS is_to_beinvoiced_18,
  t0.discount_for_company AS discount_for_company_19,
  t0.re_send_to_client AS re_send_to_client_20,
  t0.number_initial_of_missions AS number_initial_of_missions_21,
  t0.last_state AS last_state_22,
  t0.delete_reason AS delete_reason_23,
  t0.is_ordored_by_admin AS is_ordored_by_admin_24,
  t0.defaut_observer AS defaut_observer_25,
  t0.default_validator AS default_validator_26,
  t0.default_validator_external AS default_validator_external_27,
  t0.defaut_observer_external AS defaut_observer_external_28,
  t0.status_modify_at AS status_modify_at_29,
  t0.is_recurrent AS is_recurrent_30,
  t0.recurring_state AS recurring_state_31,
  t0.last_step_wp AS last_step_wp_32,
  t0.front_wp_id AS front_wp_id_33,
  t0.wp_slug AS wp_slug_34,
  t0.state_history AS state_history_35,
  t0.type_initiation AS type_initiation_36,
  t0.email_sent_insuff_budget AS email_sent_insuff_budget_37,
  t0.user_writing AS user_writing_38,
  t0.cloning_source_id AS cloning_source_id_39,
  t0.is_activated AS is_activated_40,
  t0.company_id AS company_id_41,
  t0.ordered_by_id AS ordered_by_id_42,
  t0.frequency_id AS frequency_id_43,
  t0.credit_history_id AS credit_history_id_44
FROM
  campaigns t0
WHERE
  t0.id = ?
LIMIT
  1