Query Metrics

33 Database Queries
12 Different statements
666.60 ms Query time
0 Invalid entities
155 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 20.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.dni AS dni_5, t0.document_type AS document_type_6, t0.mobile_phone AS mobile_phone_7, t0.office_phone AS office_phone_8, t0.position AS position_9, t0.address AS address_10, t0.city AS city_11, t0.state AS state_12, t0.zip_code AS zip_code_13, t0.country AS country_14, t0.locale AS locale_15, t0.reset_password_token AS reset_password_token_16, t0.password AS password_17, t0.mailbox AS mailbox_18, t0.roles AS roles_19, t0.mobile_phone_available_time AS mobile_phone_available_time_20, t0.office_phone_available_time AS office_phone_available_time_21, t0.is_favorite AS is_favorite_22, t0.privacy_policy_accepted_at AS privacy_policy_accepted_at_23, t0.password_changed_at AS password_changed_at_24, t0.disabled_at AS disabled_at_25, t0.previous_login_ip AS previous_login_ip_26, t0.previous_login_at AS previous_login_at_27, t0.last_login_ip AS last_login_ip_28, t0.last_login_at AS last_login_at_29, t0.tos_accepted_at AS tos_accepted_at_30, t0.auth_code AS auth_code_31, t0.double_factor_method AS double_factor_method_32, t0.expires_at AS expires_at_33, t0.failed_password_attempts AS failed_password_attempts_34, t0.failed_password_locked_at AS failed_password_locked_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.default_customer_id AS default_customer_id_38, t0.default_provider_id AS default_provider_id_39, t0.backoffice_profile_id AS backoffice_profile_id_40 FROM users t0 WHERE t0.email = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
Parameters:
[
  "fernandodbeaulieu@gmail.com"
]
2 20.43 ms
SELECT b0_.access_key AS access_key_0 FROM backoffice_permission b0_
Parameters:
[]
3 19.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM backoffice_profile t0 WHERE t0.id = ?
Parameters:
[
  "e2a6cbbb-ea32-11ef-a96c-000c291403de"
]
4 20.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.backoffice_permission_type_id AS backoffice_permission_type_id_7 FROM backoffice_permission t0 INNER JOIN backoffice_profile_backoffice_permission ON t0.id = backoffice_profile_backoffice_permission.backoffice_permission_id WHERE backoffice_profile_backoffice_permission.backoffice_profile_id = ?
Parameters:
[
  "e2a6cbbb-ea32-11ef-a96c-000c291403de"
]
5 20.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.code AS code_3, t0.name AS name_4, t0.tin AS tin_5, t0.status AS status_6, t0.type AS type_7, t0.company_type AS company_type_8, t0.partner_type AS partner_type_9, t0.address AS address_10, t0.city AS city_11, t0.state AS state_12, t0.zip_code AS zip_code_13, t0.country AS country_14, t0.language AS language_15, t0.notification_phone AS notification_phone_16, t0.notification_email AS notification_email_17, t0.technical_phone AS technical_phone_18, t0.technical_email AS technical_email_19, t0.observation AS observation_20, t0.disabled_at AS disabled_at_21, t0.can_be_hired AS can_be_hired_22, t0.id_customer_sst AS id_customer_sst_23, t0.block_level AS block_level_24, t0.ticket_notification_emails AS ticket_notification_emails_25, t0.customer_type AS customer_type_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.main_user_id AS main_user_id_29 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  "238576dc-ea5e-41fb-b50e-9dffd5f9612f"
]
6 19.91 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.cpd_id AS cpd_id_4, t0.backoffice_user_id AS backoffice_user_id_5 FROM backoffice_user_cpd t0 WHERE t0.backoffice_user_id = ?
Parameters:
[
  "79721683-1d2d-456b-8dfd-9e87cff26796"
]
7 28.47 ms
SELECT DISTINCT id_0, MIN(sclr_65) AS dctrn_minrownum FROM (SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.email AS email_3, u0_.dni AS dni_4, u0_.document_type AS document_type_5, u0_.mobile_phone AS mobile_phone_6, u0_.office_phone AS office_phone_7, u0_.position AS position_8, u0_.address AS address_9, u0_.city AS city_10, u0_.state AS state_11, u0_.zip_code AS zip_code_12, u0_.country AS country_13, u0_.locale AS locale_14, u0_.reset_password_token AS reset_password_token_15, u0_.password AS password_16, u0_.mailbox AS mailbox_17, u0_.roles AS roles_18, u0_.mobile_phone_available_time AS mobile_phone_available_time_19, u0_.office_phone_available_time AS office_phone_available_time_20, u0_.is_favorite AS is_favorite_21, u0_.privacy_policy_accepted_at AS privacy_policy_accepted_at_22, u0_.password_changed_at AS password_changed_at_23, u0_.disabled_at AS disabled_at_24, u0_.previous_login_ip AS previous_login_ip_25, u0_.previous_login_at AS previous_login_at_26, u0_.last_login_ip AS last_login_ip_27, u0_.last_login_at AS last_login_at_28, u0_.tos_accepted_at AS tos_accepted_at_29, u0_.auth_code AS auth_code_30, u0_.double_factor_method AS double_factor_method_31, u0_.expires_at AS expires_at_32, u0_.failed_password_attempts AS failed_password_attempts_33, u0_.failed_password_locked_at AS failed_password_locked_at_34, u0_.created_at AS created_at_35, u0_.updated_at AS updated_at_36, c1_.id AS id_37, c1_.external_id AS external_id_38, c1_.code AS code_39, c1_.name AS name_40, c1_.tin AS tin_41, c1_.status AS status_42, c1_.type AS type_43, c1_.company_type AS company_type_44, c1_.partner_type AS partner_type_45, c1_.address AS address_46, c1_.city AS city_47, c1_.state AS state_48, c1_.zip_code AS zip_code_49, c1_.country AS country_50, c1_.language AS language_51, c1_.notification_phone AS notification_phone_52, c1_.notification_email AS notification_email_53, c1_.technical_phone AS technical_phone_54, c1_.technical_email AS technical_email_55, c1_.observation AS observation_56, c1_.disabled_at AS disabled_at_57, c1_.can_be_hired AS can_be_hired_58, c1_.id_customer_sst AS id_customer_sst_59, c1_.block_level AS block_level_60, c1_.ticket_notification_emails AS ticket_notification_emails_61, c1_.customer_type AS customer_type_62, c1_.created_at AS created_at_63, c1_.updated_at AS updated_at_64, ROW_NUMBER() OVER(ORDER BY u0_.name ASC) AS sclr_65 FROM users u0_ INNER JOIN user_customer u2_ ON u0_.id = u2_.user_id INNER JOIN customer c1_ ON c1_.id = u2_.customer_id WHERE c1_.id = ? AND u0_.disabled_at IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC OFFSET 0 ROWS FETCH NEXT 100000 ROWS ONLY
Parameters:
[
  "238576dc-ea5e-41fb-b50e-9dffd5f9612f"
]
8 20.55 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.email AS email_3, u0_.dni AS dni_4, u0_.document_type AS document_type_5, u0_.mobile_phone AS mobile_phone_6, u0_.office_phone AS office_phone_7, u0_.position AS position_8, u0_.address AS address_9, u0_.city AS city_10, u0_.state AS state_11, u0_.zip_code AS zip_code_12, u0_.country AS country_13, u0_.locale AS locale_14, u0_.reset_password_token AS reset_password_token_15, u0_.password AS password_16, u0_.mailbox AS mailbox_17, u0_.roles AS roles_18, u0_.mobile_phone_available_time AS mobile_phone_available_time_19, u0_.office_phone_available_time AS office_phone_available_time_20, u0_.is_favorite AS is_favorite_21, u0_.privacy_policy_accepted_at AS privacy_policy_accepted_at_22, u0_.password_changed_at AS password_changed_at_23, u0_.disabled_at AS disabled_at_24, u0_.previous_login_ip AS previous_login_ip_25, u0_.previous_login_at AS previous_login_at_26, u0_.last_login_ip AS last_login_ip_27, u0_.last_login_at AS last_login_at_28, u0_.tos_accepted_at AS tos_accepted_at_29, u0_.auth_code AS auth_code_30, u0_.double_factor_method AS double_factor_method_31, u0_.expires_at AS expires_at_32, u0_.failed_password_attempts AS failed_password_attempts_33, u0_.failed_password_locked_at AS failed_password_locked_at_34, u0_.created_at AS created_at_35, u0_.updated_at AS updated_at_36, c1_.id AS id_37, c1_.external_id AS external_id_38, c1_.code AS code_39, c1_.name AS name_40, c1_.tin AS tin_41, c1_.status AS status_42, c1_.type AS type_43, c1_.company_type AS company_type_44, c1_.partner_type AS partner_type_45, c1_.address AS address_46, c1_.city AS city_47, c1_.state AS state_48, c1_.zip_code AS zip_code_49, c1_.country AS country_50, c1_.language AS language_51, c1_.notification_phone AS notification_phone_52, c1_.notification_email AS notification_email_53, c1_.technical_phone AS technical_phone_54, c1_.technical_email AS technical_email_55, c1_.observation AS observation_56, c1_.disabled_at AS disabled_at_57, c1_.can_be_hired AS can_be_hired_58, c1_.id_customer_sst AS id_customer_sst_59, c1_.block_level AS block_level_60, c1_.ticket_notification_emails AS ticket_notification_emails_61, c1_.customer_type AS customer_type_62, c1_.created_at AS created_at_63, c1_.updated_at AS updated_at_64, u0_.default_customer_id AS default_customer_id_65, u0_.default_provider_id AS default_provider_id_66, u0_.backoffice_profile_id AS backoffice_profile_id_67, c1_.main_user_id AS main_user_id_68 FROM users u0_ INNER JOIN user_customer u2_ ON u0_.id = u2_.user_id INNER JOIN customer c1_ ON c1_.id = u2_.customer_id WHERE c1_.id = ? AND u0_.disabled_at IS NULL AND u0_.id IN (?, ?, ?, ?, ?) ORDER BY u0_.name ASC
Parameters:
[
  "238576dc-ea5e-41fb-b50e-9dffd5f9612f"
  "e3c7669a-bfb9-418e-b2d9-d14faef9b200"
  "79721683-1d2d-456b-8dfd-9e87cff26796"
  "4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b"
  "4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760"
  "86b92ab8-cbb1-4bde-b628-12971a2b109b"
]
9 20.20 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.customer_permission_id AS customer_permission_id_4, t0.user_id AS user_id_5, t0.customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "e3c7669a-bfb9-418e-b2d9-d14faef9b200"
]
10 19.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "BA1B9E54-C7B5-4671-893D-E7D294719EDE"
]
11 19.95 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "B5E7BE34-F052-4B35-98B2-1BF6AD3C14C1"
]
12 19.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "833604E2-25ED-46C6-BFD2-89BFAEF79465"
]
13 20.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "6b142aee-8d16-11ee-9abc-e00af667d704"
]
14 19.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "44C4DD48-2086-4F87-8E70-8156A316C1D5"
]
15 20.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "1a654952-309b-11ee-8d09-e00af667d704"
]
16 20.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "42C4927F-60C7-43F7-BA70-DBE217927B02"
]
17 19.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "344B8D51-361B-4A7B-8D98-C241CD11A3C1"
]
18 19.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "ea12f7df-2adb-11ee-8d09-e00af667d704"
]
19 19.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "CA0A7F03-0A3A-461D-883C-89D4B50560E6"
]
20 19.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "66908D8A-C90B-4DD1-99F0-32D6B22199FD"
]
21 19.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.access_key AS access_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_permission_type_id AS customer_permission_type_id_6 FROM customer_permission t0 WHERE t0.id = ?
Parameters:
[
  "FE1BD7F7-3B4B-4F08-AB44-400214384984"
]
22 19.88 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.customer_id AS customer_id_5, t0.notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "e3c7669a-bfb9-418e-b2d9-d14faef9b200"
]
23 19.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0.id = ?
Parameters:
[
  "604feff2-828a-4593-ad06-446f0496abba"
]
24 19.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0.id = ?
Parameters:
[
  "e2df8676-6142-4a95-b679-71cfc79a94d6"
]
25 20.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM customer_notification_type t0 WHERE t0.id = ?
Parameters:
[
  "0a074caa-f55f-429e-9168-c18cb10d45d1"
]
26 20.01 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.customer_permission_id AS customer_permission_id_4, t0.user_id AS user_id_5, t0.customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "79721683-1d2d-456b-8dfd-9e87cff26796"
]
27 19.66 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.customer_id AS customer_id_5, t0.notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "79721683-1d2d-456b-8dfd-9e87cff26796"
]
28 19.81 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.customer_permission_id AS customer_permission_id_4, t0.user_id AS user_id_5, t0.customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b"
]
29 19.62 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.customer_id AS customer_id_5, t0.notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "4bcf2c0a-6b0b-4e85-87d5-6b5ecfc33e4b"
]
30 19.77 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.customer_permission_id AS customer_permission_id_4, t0.user_id AS user_id_5, t0.customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760"
]
31 19.76 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.customer_id AS customer_id_5, t0.notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "4a6a5c5c-f4a8-4486-b4ac-748ae2cb5760"
]
32 19.78 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.customer_permission_id AS customer_permission_id_4, t0.user_id AS user_id_5, t0.customer_id AS customer_id_6 FROM customer_assigned_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "86b92ab8-cbb1-4bde-b628-12971a2b109b"
]
33 19.52 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.customer_id AS customer_id_5, t0.notification_type_id AS notification_type_id_6 FROM user_customer_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "86b92ab8-cbb1-4bde-b628-12971a2b109b"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
templus_monitoring doctrine.dbal.templus_monitoring_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\BackofficePermission 65
App\Entity\CustomerAssignedPermission 50
App\Entity\CustomerPermission 12
App\Entity\BackofficePermissionType 11
App\Entity\User 5
App\Entity\CustomerPermissionType 3
App\Entity\UserCustomerNotification 3
App\Entity\CustomerNotificationType 3
App\Entity\Customer 2
App\Entity\BackofficeProfile 1