Query Metrics

44 Database Queries
28 Different statements
10.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.51 ms
(14.38%)
1
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
Parameters:
[]
1.42 ms
(13.52%)
6
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 = ?
Parameters:
[
  "JpJCxzoJkC2TqNYCes1YEm"
]
1.31 ms
(12.51%)
2
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 ?
Parameters:
[
  "%app.dev.my-flow.fr%"
]
0.84 ms
(8.04%)
8
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 = ?
Parameters:
[
  "VCsBnbZ1dsqmnkfmbL5FdN"
]
0.49 ms
(4.68%)
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_ 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
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.49 ms
(4.68%)
1
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 (?)
Parameters:
[
  [
    1 => "JpJCxzoJkC2TqNYCes1YEm"
    2 => "UCKUKNQ4dYg3aYL6usKgqk"
  ]
]
0.38 ms
(3.59%)
3
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 = ?
Parameters:
[
  36978
]
0.26 ms
(2.52%)
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
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
  "2024-11-06 07:37:43"
]
0.25 ms
(2.40%)
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_.is_deleted <> 1 OR m0_.is_deleted IS NULL) ORDER BY m0_.created_at DESC LIMIT 10
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.25 ms
(2.34%)
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 = ?
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.24 ms
(2.30%)
1
UPDATE users SET daily_rate = ?, resale_rate = ?, last_activity_at = ?, autorization_date_at = ? WHERE id = ?
Parameters:
[
  0.0
  0.0
  "2024-11-26 14:36:51"
  "2024-11-26 14:36:51"
  "JpJCxzoJkC2TqNYCes1YEm"
]
0.24 ms
(2.28%)
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.campaign_id = ?
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.24 ms
(2.26%)
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 = ? LIMIT 1
Parameters:
[
  "JpJCxzoJkC2TqNYCes1YEm"
]
0.23 ms
(2.17%)
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 = ? LIMIT 1
Parameters:
[
  "6tV5XUVf9WKx8iQgam3bKu"
]
0.23 ms
(2.17%)
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 = ?
Parameters:
[
  3058
]
0.22 ms
(2.12%)
1
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
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.22 ms
(2.10%)
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 = ? LIMIT 1
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.21 ms
(2.01%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.front_id AS front_id_3, t0.deleted AS deleted_4, t0.type AS type_5, t0.statut AS statut_6, t0.price AS price_7, t0.link AS link_8, t0.company_id AS company_id_9, t0.created_by_id AS created_by_id_10 FROM products t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.20 ms
(1.95%)
1
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 = ?
Parameters:
[
  "6tV5XUVf9WKx8iQgam3bKu"
]
0.20 ms
(1.91%)
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.campaign_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.19 ms
(1.85%)
1
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
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.18 ms
(1.76%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.completion_time AS completion_time_3, t0.customer_description AS customer_description_4, t0.position AS position_5, t0.supplier_description AS supplier_description_6, t0.manager AS manager_7, t0.active AS active_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.workflow_id AS workflow_id_11, t0.job_id AS job_id_12 FROM workflow_steps t0 WHERE t0.workflow_id = ? ORDER BY t0.position ASC
Parameters:
[
  3058
]
0.17 ms
(1.67%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM messages m0_ WHERE m0_.campaign_id = ? ORDER BY m0_.created_at DESC
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.17 ms
(1.62%)
1
SELECT m0_.id AS id_0 FROM messages m0_ WHERE m0_.campaign_id = ? AND m0_.is_deleted = 1 GROUP BY m0_.id
Parameters:
[
  "Mz57Dp3dhEpMSMgUCwN11q"
]
0.13 ms
(1.23%)
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 = ? LIMIT 1
Parameters:
[
  "VCsBnbZ1dsqmnkfmbL5FdN"
]
0.13 ms
(1.21%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.recipient AS recipient_3, t0.job_id AS job_id_4, t0.step_id AS step_id_5 FROM workflow_actions t0 WHERE t0.step_id = ?
Parameters:
[
  12254
]
0.04 ms
(0.40%)
1
"COMMIT"
Parameters:
[]
0.04 ms
(0.35%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Message No errors.
App\Entity\Company No errors.
App\Entity\Campaign No errors.
App\Entity\User No errors.
App\Entity\Mission No errors.
App\Entity\MissionParticipant No errors.
App\Entity\WorkflowStep No errors.
App\Entity\CreditHistory No errors.
App\Entity\CommandeLogging No errors.
App\Entity\NotificationToSend No errors.
App\Entity\ConfidentialityContract No errors.
App\Entity\CampaignPendingToSend No errors.
App\Entity\SystemEmail No errors.
App\Entity\BalanceTransactions No errors.
App\Entity\Service No errors.
App\Entity\Historique No errors.
App\Entity\SubContractorCompany No errors.
App\Entity\Job No errors.
App\Entity\CompanyData No errors.
App\Entity\UserData No errors.
App\Entity\FileMission No errors.
App\Entity\WorkflowAction No errors.
App\Entity\InfoMission No errors.
App\Entity\Device No errors.
App\Entity\MessageReaction No errors.
App\Entity\Emoji No errors.
App\Entity\Support No errors.
App\Entity\Portfolio No errors.
App\Entity\SignedContract No errors.
App\Entity\Product No errors.
App\Entity\FileMessage No errors.
App\Entity\Workflow No errors.
App\Entity\RecurringService No errors.
App\Entity\Invoice No errors.
App\Entity\WorkflowTrigger No errors.
App\Entity\EmailTemplate No errors.