Query Metrics
3
Database Queries
3
Different statements
1.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.71 ms (50.53%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.password_token AS password_token_6, t0.password_token_at AS password_token_at_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone_number AS phone_number_10, t0.description AS description_11, t0.role_description AS role_description_12, t0.avatar AS avatar_13, t0.avatar_path AS avatar_path_14, t0.gender AS gender_15, t0.birth_at AS birth_at_16, t0.is_verified AS is_verified_17, t0.signing_limit_date AS signing_limit_date_18, t0.last_connected_at AS last_connected_at_19, t0.shown_alert AS shown_alert_20, t0.created_from_import AS created_from_import_21, t0.address_street AS address_street_22, t0.address_post_code AS address_post_code_23, t0.address_city AS address_city_24, t0.address_country AS address_country_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.user_id AS user_id_31, t28.channel_id AS channel_id_32, t28.created_by_id AS created_by_id_33, t0.contact_id AS contact_id_34, t0.created_by_id AS created_by_id_35, t36.id AS id_37, t36.email AS email_38, t36.roles AS roles_39, t36.password AS password_40, t36.enabled AS enabled_41, t36.password_token AS password_token_42, t36.password_token_at AS password_token_at_43, t36.first_name AS first_name_44, t36.last_name AS last_name_45, t36.phone_number AS phone_number_46, t36.description AS description_47, t36.role_description AS role_description_48, t36.avatar AS avatar_49, t36.avatar_path AS avatar_path_50, t36.gender AS gender_51, t36.birth_at AS birth_at_52, t36.is_verified AS is_verified_53, t36.signing_limit_date AS signing_limit_date_54, t36.last_connected_at AS last_connected_at_55, t36.shown_alert AS shown_alert_56, t36.created_from_import AS created_from_import_57, t36.address_street AS address_street_58, t36.address_post_code AS address_post_code_59, t36.address_city AS address_city_60, t36.address_country AS address_country_61, t36.created_at AS created_at_62, t36.updated_at AS updated_at_63, t36.contact_id AS contact_id_64, t36.created_by_id AS created_by_id_65, t36.updated_by_id AS updated_by_id_66, t0.updated_by_id AS updated_by_id_67, t68.id AS id_69, t68.email AS email_70, t68.roles AS roles_71, t68.password AS password_72, t68.enabled AS enabled_73, t68.password_token AS password_token_74, t68.password_token_at AS password_token_at_75, t68.first_name AS first_name_76, t68.last_name AS last_name_77, t68.phone_number AS phone_number_78, t68.description AS description_79, t68.role_description AS role_description_80, t68.avatar AS avatar_81, t68.avatar_path AS avatar_path_82, t68.gender AS gender_83, t68.birth_at AS birth_at_84, t68.is_verified AS is_verified_85, t68.signing_limit_date AS signing_limit_date_86, t68.last_connected_at AS last_connected_at_87, t68.shown_alert AS shown_alert_88, t68.created_from_import AS created_from_import_89, t68.address_street AS address_street_90, t68.address_post_code AS address_post_code_91, t68.address_city AS address_city_92, t68.address_country AS address_country_93, t68.created_at AS created_at_94, t68.updated_at AS updated_at_95, t68.contact_id AS contact_id_96, t68.created_by_id AS created_by_id_97, t68.updated_by_id AS updated_by_id_98 FROM account_users t0 LEFT JOIN channel_user_from_channels t28 ON t28.user_id = t0.id LEFT JOIN account_users t36 ON t0.created_by_id = t36.id LEFT JOIN account_users t68 ON t0.updated_by_id = t68.id WHERE t0.id = ?
Parameters:
[
"1efd70bc-0195-661a-9f5b-5bd4f8d72253"
]
|
|
0.53 ms (37.73%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.channel_id AS channel_id_4, t0.created_by_id AS created_by_id_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.enabled AS enabled_11, t6.password_token AS password_token_12, t6.password_token_at AS password_token_at_13, t6.first_name AS first_name_14, t6.last_name AS last_name_15, t6.phone_number AS phone_number_16, t6.description AS description_17, t6.role_description AS role_description_18, t6.avatar AS avatar_19, t6.avatar_path AS avatar_path_20, t6.gender AS gender_21, t6.birth_at AS birth_at_22, t6.is_verified AS is_verified_23, t6.signing_limit_date AS signing_limit_date_24, t6.last_connected_at AS last_connected_at_25, t6.shown_alert AS shown_alert_26, t6.created_from_import AS created_from_import_27, t6.address_street AS address_street_28, t6.address_post_code AS address_post_code_29, t6.address_city AS address_city_30, t6.address_country AS address_country_31, t6.created_at AS created_at_32, t6.updated_at AS updated_at_33, t6.contact_id AS contact_id_34, t6.created_by_id AS created_by_id_35, t6.updated_by_id AS updated_by_id_36 FROM channel_user_from_channels t0 LEFT JOIN account_users t6 ON t0.created_by_id = t6.id WHERE t0.user_id = ?
Parameters:
[
"bf18b698-519e-11ea-914c-0242ac150002"
]
|
|
0.17 ms (11.74%) |
1 |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.queue_name AS queue_name_2, a0_.secret AS secret_3, a0_.url AS url_4 FROM app a0_ WHERE a0_.queue_name = ?
Parameters:
[
"nim"
]
|
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.