Query Metrics
8
Database Queries
7
Different statements
4.42 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 ms |
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%"
]
|
| 2 | 0.31 ms |
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%"
]
|
| 3 | 0.42 ms |
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.share_my_whatsapp AS share_my_whatsapp_10, t0.my_whatsapp_link AS my_whatsapp_link_11, t0.lastname AS lastname_12, t0.cell_phone AS cell_phone_13, t0.enabled AS enabled_14, t0.external AS external_15, t0.daily_rate AS daily_rate_16, t0.resale_rate AS resale_rate_17, t0.billing_method AS billing_method_18, t0.picture_name AS picture_name_19, t0.updated_at AS updated_at_20, t0.email AS email_21, t0.original_email AS original_email_22, t0.roles AS roles_23, t0.password AS password_24, t0.created_at AS created_at_25, t0.last_connection_at AS last_connection_at_26, t0.account_type AS account_type_27, t0.notification_type AS notification_type_28, t0.notification AS notification_29, t0.freq_notification AS freq_notification_30, t0.freq_notification_everytime AS freq_notification_everytime_31, t0.freq_notification_per_day AS freq_notification_per_day_32, t0.freq_notification_per_week AS freq_notification_per_week_33, t0.freq_notification_per_month AS freq_notification_per_month_34, t0.is_active_notification AS is_active_notification_35, t0.deleted AS deleted_36, t0.referencing_confirmation_notification AS referencing_confirmation_notification_37, t0.gender AS gender_38, t0.device_connected_list AS device_connected_list_39, t0.mail_alias AS mail_alias_40, t0.invisible AS invisible_41, t0.last_activity_at AS last_activity_at_42, t0.is_logged AS is_logged_43, t0.is_new_client AS is_new_client_44, t0.autorization_date_at AS autorization_date_at_45, t0.accept_presentation AS accept_presentation_46, t0.description AS description_47, t0.title AS title_48, t0.one_time_login_token AS one_time_login_token_49, t0.state AS state_50, t0.identifier AS identifier_51, t0.my_flow_email AS my_flow_email_52, t0.company_id AS company_id_53, t0.user_data_id AS user_data_id_54, t0.parent_id AS parent_id_55 FROM users t0 WHERE t0.id = ?
Parameters:
[
"DEow9vzG1UumAw1HmjEcSp"
]
|
| 4 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.34 ms |
UPDATE users SET daily_rate = ?, resale_rate = ?, last_activity_at = ?, autorization_date_at = ? WHERE id = ?
Parameters:
[ 10.0 13.0 "2025-07-18 14:10:35" "2025-07-18 14:10:35" "DEow9vzG1UumAw1HmjEcSp" ] |
| 6 | 0.10 ms |
"COMMIT"
Parameters:
[] |
| 7 | 0.30 ms |
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 = ?
Parameters:
[
"FcfGocdtUvZFTK4oDjNWCB"
]
|
| 8 | 2.25 ms |
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_.insert_pinned AS insert_pinned_8, m0_.is_modified AS is_modified_9, m0_.platform AS platform_10, f1_.id AS id_11, f1_.name AS name_12, f1_.is_new AS is_new_13, f1_.type AS type_14, f1_.created_at AS created_at_15, f1_.is_deleted AS is_deleted_16, f1_.is_not_infected AS is_not_infected_17, d2_.id AS id_18, d2_.name AS name_19, d2_.created_at AS created_at_20, d2_.picture_name AS picture_name_21, d2_.deleted AS deleted_22, u3_.id AS id_23, u3_.firstname AS firstname_24, u3_.new_add AS new_add_25, u3_.all_company AS all_company_26, u3_.salary AS salary_27, u3_.manager AS manager_28, u3_.partner AS partner_29, u3_.share_my_email AS share_my_email_30, u3_.share_my_phone AS share_my_phone_31, u3_.share_my_whatsapp AS share_my_whatsapp_32, u3_.my_whatsapp_link AS my_whatsapp_link_33, u3_.lastname AS lastname_34, u3_.cell_phone AS cell_phone_35, u3_.enabled AS enabled_36, u3_.external AS external_37, u3_.daily_rate AS daily_rate_38, u3_.resale_rate AS resale_rate_39, u3_.billing_method AS billing_method_40, u3_.picture_name AS picture_name_41, u3_.updated_at AS updated_at_42, u3_.email AS email_43, u3_.original_email AS original_email_44, u3_.roles AS roles_45, u3_.password AS password_46, u3_.created_at AS created_at_47, u3_.last_connection_at AS last_connection_at_48, u3_.account_type AS account_type_49, u3_.notification_type AS notification_type_50, u3_.notification AS notification_51, u3_.freq_notification AS freq_notification_52, u3_.freq_notification_everytime AS freq_notification_everytime_53, u3_.freq_notification_per_day AS freq_notification_per_day_54, u3_.freq_notification_per_week AS freq_notification_per_week_55, u3_.freq_notification_per_month AS freq_notification_per_month_56, u3_.is_active_notification AS is_active_notification_57, u3_.deleted AS deleted_58, u3_.referencing_confirmation_notification AS referencing_confirmation_notification_59, u3_.gender AS gender_60, u3_.device_connected_list AS device_connected_list_61, u3_.mail_alias AS mail_alias_62, u3_.invisible AS invisible_63, u3_.last_activity_at AS last_activity_at_64, u3_.is_logged AS is_logged_65, u3_.is_new_client AS is_new_client_66, u3_.autorization_date_at AS autorization_date_at_67, u3_.accept_presentation AS accept_presentation_68, u3_.description AS description_69, u3_.title AS title_70, u3_.one_time_login_token AS one_time_login_token_71, u3_.state AS state_72, u3_.identifier AS identifier_73, u3_.my_flow_email AS my_flow_email_74, m0_.user_id AS user_id_75, m0_.campaign_id AS campaign_id_76, m0_.mission_id AS mission_id_77, m0_.discussion_group_id AS discussion_group_id_78, f1_.messages_id AS messages_id_79, d2_.created_by AS created_by_80, d2_.campaign AS campaign_81, u3_.company_id AS company_id_82, u3_.user_data_id AS user_data_id_83, u3_.parent_id AS parent_id_84 FROM messages m0_ LEFT JOIN files_messages f1_ ON m0_.id = f1_.messages_id LEFT JOIN discussion_group d2_ ON m0_.discussion_group_id = d2_.id LEFT JOIN discussion_group_user d4_ ON d2_.id = d4_.discussion_group_id LEFT JOIN users u3_ ON u3_.id = d4_.user_id WHERE m0_.campaign_id = ? AND (m0_.is_deleted <> 1 OR m0_.is_deleted IS NULL) AND m0_.discussion_group_id IS NULL ORDER BY m0_.created_at DESC
Parameters:
[
"LMWUFVukjZUb4m2FtJ7r2j"
]
|
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 |
|---|