Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.role AS role_1,
  m0_.estimated_income AS estimated_income_2,
  m0_.income_suggested AS income_suggested_3,
  m0_.initial_time AS initial_time_4,
  m0_.estimated_income_admin AS estimated_income_admin_5,
  m0_.initial_time_admin AS initial_time_admin_6,
  m0_.activated AS activated_7,
  m0_.refused AS refused_8,
  m0_.activated_at AS activated_at_9,
  m0_.valid_step AS valid_step_10,
  m0_.state_add AS state_add_11,
  m0_.evaluate AS evaluate_12,
  m0_.mission_id AS mission_id_13,
  m0_.user_id AS user_id_14,
  m0_.job_id AS job_id_15
FROM
  mission_participants m0_
WHERE
  m0_.initial_time IS NOT NULL
  AND m0_.initial_time <> 0

SELECT m0_.id AS id_0, m0_.role AS role_1, m0_.estimated_income AS estimated_income_2, m0_.income_suggested AS income_suggested_3, m0_.initial_time AS initial_time_4, m0_.estimated_income_admin AS estimated_income_admin_5, m0_.initial_time_admin AS initial_time_admin_6, m0_.activated AS activated_7, m0_.refused AS refused_8, m0_.activated_at AS activated_at_9, m0_.valid_step AS valid_step_10, m0_.state_add AS state_add_11, m0_.evaluate AS evaluate_12, m0_.mission_id AS mission_id_13, m0_.user_id AS user_id_14, m0_.job_id AS job_id_15 FROM mission_participants m0_ WHERE m0_.initial_time IS NOT NULL AND m0_.initial_time <> 0;

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%';

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
  u0_.id AS id_0,
  u0_.firstname AS firstname_1,
  u0_.new_add AS new_add_2,
  u0_.all_company AS all_company_3,
  u0_.salary AS salary_4,
  u0_.manager AS manager_5,
  u0_.partner AS partner_6,
  u0_.share_my_email AS share_my_email_7,
  u0_.share_my_phone AS share_my_phone_8,
  u0_.lastname AS lastname_9,
  u0_.cell_phone AS cell_phone_10,
  u0_.enabled AS enabled_11,
  u0_.external AS external_12,
  u0_.daily_rate AS daily_rate_13,
  u0_.resale_rate AS resale_rate_14,
  u0_.billing_method AS billing_method_15,
  u0_.picture_name AS picture_name_16,
  u0_.updated_at AS updated_at_17,
  u0_.email AS email_18,
  u0_.original_email AS original_email_19,
  u0_.roles AS roles_20,
  u0_.password AS password_21,
  u0_.created_at AS created_at_22,
  u0_.last_connection_at AS last_connection_at_23,
  u0_.account_type AS account_type_24,
  u0_.notification_type AS notification_type_25,
  u0_.notification AS notification_26,
  u0_.freq_notification AS freq_notification_27,
  u0_.freq_notification_everytime AS freq_notification_everytime_28,
  u0_.freq_notification_per_day AS freq_notification_per_day_29,
  u0_.freq_notification_per_week AS freq_notification_per_week_30,
  u0_.freq_notification_per_month AS freq_notification_per_month_31,
  u0_.is_active_notification AS is_active_notification_32,
  u0_.deleted AS deleted_33,
  u0_.referencing_confirmation_notification AS referencing_confirmation_notification_34,
  u0_.gender AS gender_35,
  u0_.device_connected_list AS device_connected_list_36,
  u0_.invisible AS invisible_37,
  u0_.last_activity_at AS last_activity_at_38,
  u0_.is_logged AS is_logged_39,
  u0_.is_new_client AS is_new_client_40,
  u0_.autorization_date_at AS autorization_date_at_41,
  u0_.accept_presentation AS accept_presentation_42,
  u0_.description AS description_43,
  u0_.title AS title_44,
  u0_.one_time_login_token AS one_time_login_token_45,
  u0_.state AS state_46,
  u0_.company_id AS company_id_47,
  u0_.user_data_id AS user_data_id_48,
  u0_.parent_id AS parent_id_49
FROM
  users u0_
WHERE
  u0_.id IN (?)

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.new_add AS new_add_2, u0_.all_company AS all_company_3, u0_.salary AS salary_4, u0_.manager AS manager_5, u0_.partner AS partner_6, u0_.share_my_email AS share_my_email_7, u0_.share_my_phone AS share_my_phone_8, u0_.lastname AS lastname_9, u0_.cell_phone AS cell_phone_10, u0_.enabled AS enabled_11, u0_.external AS external_12, u0_.daily_rate AS daily_rate_13, u0_.resale_rate AS resale_rate_14, u0_.billing_method AS billing_method_15, u0_.picture_name AS picture_name_16, u0_.updated_at AS updated_at_17, u0_.email AS email_18, u0_.original_email AS original_email_19, u0_.roles AS roles_20, u0_.password AS password_21, u0_.created_at AS created_at_22, u0_.last_connection_at AS last_connection_at_23, u0_.account_type AS account_type_24, u0_.notification_type AS notification_type_25, u0_.notification AS notification_26, u0_.freq_notification AS freq_notification_27, u0_.freq_notification_everytime AS freq_notification_everytime_28, u0_.freq_notification_per_day AS freq_notification_per_day_29, u0_.freq_notification_per_week AS freq_notification_per_week_30, u0_.freq_notification_per_month AS freq_notification_per_month_31, u0_.is_active_notification AS is_active_notification_32, u0_.deleted AS deleted_33, u0_.referencing_confirmation_notification AS referencing_confirmation_notification_34, u0_.gender AS gender_35, u0_.device_connected_list AS device_connected_list_36, u0_.invisible AS invisible_37, u0_.last_activity_at AS last_activity_at_38, u0_.is_logged AS is_logged_39, u0_.is_new_client AS is_new_client_40, u0_.autorization_date_at AS autorization_date_at_41, u0_.accept_presentation AS accept_presentation_42, u0_.description AS description_43, u0_.title AS title_44, u0_.one_time_login_token AS one_time_login_token_45, u0_.state AS state_46, u0_.company_id AS company_id_47, u0_.user_data_id AS user_data_id_48, u0_.parent_id AS parent_id_49 FROM users u0_ WHERE u0_.id IN ('JpJCxzoJkC2TqNYCes1YEm', 'UCKUKNQ4dYg3aYL6usKgqk');

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
  t0.id AS id_1,
  t0.trigger_type AS trigger_type_2,
  t0.operator AS operator_3,
  t0.time_period AS time_period_4,
  t0.operation AS operation_5,
  t0.action_id AS action_id_6,
  t0.email_template_id AS email_template_id_7,
  t0.parent_id AS parent_id_8
FROM
  workflow_triggers t0
WHERE
  t0.action_id = ?

SELECT t0.id AS id_1, t0.trigger_type AS trigger_type_2, t0.operator AS operator_3, t0.time_period AS time_period_4, t0.operation AS operation_5, t0.action_id AS action_id_6, t0.email_template_id AS email_template_id_7, t0.parent_id AS parent_id_8 FROM workflow_triggers t0 WHERE t0.action_id = 36978;

"COMMIT"

"COMMIT";

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;

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';

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

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' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.active AS active_4,
  t0.descriptions AS descriptions_5,
  t0.product_id AS product_id_6,
  t0.company_id AS company_id_7,
  t8.id AS id_9,
  t8.reference AS reference_10,
  t8.position_order AS position_order_11,
  t8.state_client AS state_client_12,
  t8.state_provider AS state_provider_13,
  t8.created_at AS created_at_14,
  t8.desired_delivery AS desired_delivery_15,
  t8.initial_briefing AS initial_briefing_16,
  t8.guide_step AS guide_step_17,
  t8.quantity AS quantity_18,
  t8.price AS price_19,
  t8.price_with_marge_my_flow AS price_with_marge_my_flow_20,
  t8.marge_my_flow AS marge_my_flow_21,
  t8.price_sale AS price_sale_22,
  t8.state AS state_23,
  t8.cancel_reason AS cancel_reason_24,
  t8.libelle_custom AS libelle_custom_25,
  t8.initial_time AS initial_time_26,
  t8.real_time AS real_time_27,
  t8.pre_activated_at AS pre_activated_at_28,
  t8.admin_time AS admin_time_29,
  t8.admin_income AS admin_income_30,
  t8.discount_for_company AS discount_for_company_31,
  t8.original_price AS original_price_32,
  t8.old_command AS old_command_33,
  t8.last_state AS last_state_34,
  t8.can_invoiced AS can_invoiced_35,
  t8.evaluate AS evaluate_36,
  t8.can_send_email_daily AS can_send_email_daily_37,
  t8.can_send_email_monthly AS can_send_email_monthly_38,
  t8.can_send_email_weekly AS can_send_email_weekly_39,
  t8.campaign_id AS campaign_id_40,
  t8.contact_id AS contact_id_41,
  t8.product_id AS product_id_42,
  t8.workflow_id AS workflow_id_43,
  t0.owner_id AS owner_id_44
FROM
  workflows t0
  LEFT JOIN missions t8 ON t8.workflow_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.active AS active_4, t0.descriptions AS descriptions_5, t0.product_id AS product_id_6, t0.company_id AS company_id_7, t8.id AS id_9, t8.reference AS reference_10, t8.position_order AS position_order_11, t8.state_client AS state_client_12, t8.state_provider AS state_provider_13, t8.created_at AS created_at_14, t8.desired_delivery AS desired_delivery_15, t8.initial_briefing AS initial_briefing_16, t8.guide_step AS guide_step_17, t8.quantity AS quantity_18, t8.price AS price_19, t8.price_with_marge_my_flow AS price_with_marge_my_flow_20, t8.marge_my_flow AS marge_my_flow_21, t8.price_sale AS price_sale_22, t8.state AS state_23, t8.cancel_reason AS cancel_reason_24, t8.libelle_custom AS libelle_custom_25, t8.initial_time AS initial_time_26, t8.real_time AS real_time_27, t8.pre_activated_at AS pre_activated_at_28, t8.admin_time AS admin_time_29, t8.admin_income AS admin_income_30, t8.discount_for_company AS discount_for_company_31, t8.original_price AS original_price_32, t8.old_command AS old_command_33, t8.last_state AS last_state_34, t8.can_invoiced AS can_invoiced_35, t8.evaluate AS evaluate_36, t8.can_send_email_daily AS can_send_email_daily_37, t8.can_send_email_monthly AS can_send_email_monthly_38, t8.can_send_email_weekly AS can_send_email_weekly_39, t8.campaign_id AS campaign_id_40, t8.contact_id AS contact_id_41, t8.product_id AS product_id_42, t8.workflow_id AS workflow_id_43, t0.owner_id AS owner_id_44 FROM workflows t0 LEFT JOIN missions t8 ON t8.workflow_id = t0.id WHERE t0.id = 3058;

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
  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 = 'Mz57Dp3dhEpMSMgUCwN11q';

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

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' LIMIT 1;