Query Metrics
12
Database Queries
12
Different statements
110.22 ms
Query time
6
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.12 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.created_by_id AS created_by_id_126, t120.address_id AS address_id_127, t0.point_conversion_rate_id AS point_conversion_rate_id_128, t0.responsable_regate_id AS responsable_regate_id_129, t0.coverage_area_id AS coverage_area_id_130, t0.activated_by_id AS activated_by_id_131 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"super_admin@37deux.com"
]
|
| 2 | 0.48 ms |
SELECT a0_.id AS id_0, a0_.concat_key AS concat_key_1, a0_.value AS value_2, a0_.env AS env_3, a0_.route AS route_4, a0_.params AS params_5, a0_.component AS component_6, a0_.slug AS slug_7, a0_.role AS role_8, a0_.action AS action_9, a0_.job AS job_10 FROM acl_setting a0_ WHERE a0_.concat_key LIKE ?
Parameters:
[
"%api_list_sale_order_updated.no-component.no-slug.%.ROLE_DEVELOPER.NaN"
]
|
| 3 | 43.55 ms |
SELECT s0_.id AS id_0, s0_.total AS total_1, s0_.shipping_method AS shipping_method_2, s0_.status AS status_3, s0_.waiting_status AS waiting_status_4, s0_.cancel_motif AS cancel_motif_5, s0_.shipping_price AS shipping_price_6, s0_.internal_reference AS internal_reference_7, s0_.comment AS comment_8, s0_.is_managed_by_customer AS is_managed_by_customer_9, s0_.fees_order AS fees_order_10, s0_.extra_cb_payment AS extra_cb_payment_11, s0_.total_bonus_used AS total_bonus_used_12, s0_.not_billable AS not_billable_13, s0_.otherinformations AS otherinformations_14, s0_.old_id AS old_id_15, s0_.category_values AS category_values_16, s0_.fees_category_values AS fees_category_values_17, s0_.custom_question AS custom_question_18, s0_.order_rate AS order_rate_19, s0_.is_trip AS is_trip_20, s0_.order_extra_data AS order_extra_data_21, s0_.is_express_delivery AS is_express_delivery_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24, s0_.bank_return_id AS bank_return_id_25, s0_.user_id AS user_id_26, s0_.saleorder_grouped_id AS saleorder_grouped_id_27, s0_.shipping_address_id AS shipping_address_id_28, s0_.billing_address_id AS billing_address_id_29, s0_.cart_id AS cart_id_30, s0_.invoice_id AS invoice_id_31 FROM sale_order s0_ INNER JOIN user u1_ ON s0_.user_id = u1_.id INNER JOIN sale_order_item s2_ ON s0_.id = s2_.order_id INNER JOIN sale_order_address s3_ ON s0_.shipping_address_id = s3_.id WHERE s0_.updated_at BETWEEN ? AND ? ORDER BY s0_.updated_at DESC
Parameters:
[ "2026-02-26 00:00:00" "2026-02-27 01:00:09" ] |
| 4 | 12.65 ms |
SELECT t0.id AS id_1, t0.tracking_code AS tracking_code_2, t0.tracking_url AS tracking_url_3, t0.weight AS weight_4, t0.carrier AS carrier_5, t0.bo_id AS bo_id_6, t0.shipping_cost AS shipping_cost_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sale_order_id AS sale_order_id_10 FROM sale_order_shipment t0 WHERE t0.sale_order_id = ?
Parameters:
[
1
]
|
| 5 | 1.34 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.created_by_id AS created_by_id_126, t120.address_id AS address_id_127, t0.point_conversion_rate_id AS point_conversion_rate_id_128, t0.responsable_regate_id AS responsable_regate_id_129, t0.coverage_area_id AS coverage_area_id_130, t0.activated_by_id AS activated_by_id_131 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 6 | 1.13 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.created_by_id AS created_by_id_126, t120.address_id AS address_id_127, t0.point_conversion_rate_id AS point_conversion_rate_id_128, t0.responsable_regate_id AS responsable_regate_id_129, t0.coverage_area_id AS coverage_area_id_130, t0.activated_by_id AS activated_by_id_131 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 1.35 ms |
UPDATE user SET last_activity = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-02-27 01:00:09" "2026-02-27 01:00:09" 1 ] |
| 9 | 0.48 ms |
UPDATE sale_order SET total = ?, updated_at = ? WHERE id = ?
Parameters:
[ 800.0 "2026-02-27 01:00:09" 1 ] |
| 10 | 21.53 ms |
INSERT INTO audit_sale_order (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES (:type, :object_id, :discriminator, :transaction_hash, :diffs, :blame_id, :blame_user, :blame_user_fqdn, :blame_user_firewall, :ip, :created_at)
Parameters:
[ "type" => "update" "object_id" => "1" "discriminator" => null "transaction_hash" => "b5c900fec971c08a28a9df26c05c5f331d44f13f" "diffs" => "{"total":{"new":"800","old":"800.00"}}" "blame_id" => "1" "blame_user" => "super_admin@37deux.com" "blame_user_fqdn" => "DH\Auditor\User\User" "blame_user_firewall" => "api" "ip" => "149.202.56.9" "created_at" => "2026-02-27 02:00:10.101323" ] |
| 11 | 24.71 ms |
INSERT INTO audit_user (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES (:type, :object_id, :discriminator, :transaction_hash, :diffs, :blame_id, :blame_user, :blame_user_fqdn, :blame_user_firewall, :ip, :created_at)
Parameters:
[ "type" => "update" "object_id" => "1" "discriminator" => null "transaction_hash" => "b5c900fec971c08a28a9df26c05c5f331d44f13f" "diffs" => "{"lastActivity":{"new":"2026-02-27 01:00:09","old":"2026-02-27 00:00:07"}}" "blame_id" => "1" "blame_user" => "super_admin@37deux.com" "blame_user_fqdn" => "DH\Auditor\User\User" "blame_user_firewall" => "api" "ip" => "149.202.56.9" "created_at" => "2026-02-27 02:00:10.126581" ] |
| 12 | 0.40 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| user_logs | doctrine.dbal.user_logs_connection |
| dtv_blacklisted_emails | doctrine.dbal.dtv_blacklisted_emails_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.