Query Metrics
33
Database Queries
12
Different statements
666.60 ms
Query time
0
Invalid entities
155
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
238.56 ms (35.79%) |
12 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
99.57 ms (14.94%) |
5 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
98.44 ms (14.77%) |
5 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
59.61 ms (8.94%) |
3 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
28.47 ms (4.27%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
20.75 ms (3.11%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
20.55 ms (3.08%) |
1 |
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" ]
|
||||||||||||||||||||||||||||||||||
|
20.43 ms (3.06%) |
1 |
SELECT b0_.access_key AS access_key_0 FROM backoffice_permission b0_
Parameters:
[] |
||||||||||||||||||||||||||||||||||
|
20.33 ms (3.05%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
20.07 ms (3.01%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
19.91 ms (2.99%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
19.91 ms (2.99%) |
1 |
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"
]
|
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 |