Query Metrics
5
Database Queries
5
Different statements
11.27 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.47 ms (39.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.permissions AS permissions_8, t6.role_id AS role_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM user_role t0 LEFT JOIN role_permission t6 ON t6.role_id = t0.id INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = ?
Parameters:
[
184
]
|
|
2.94 ms (26.11%) |
1 |
SELECT t0.id AS id_1, t0.company AS company_2, t0.nip AS nip_3, t0.regon AS regon_4, t0.post_code AS post_code_5, t0.city AS city_6, t0.address AS address_7, t0.image_name AS image_name_8, t0.permissions AS permissions_9, t0.footer_www AS footer_www_10, t0.footer_phone AS footer_phone_11, t0.footer_email AS footer_email_12, t0.report_settings AS report_settings_13, t0.active AS active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deactivate_date AS deactivate_date_17, t18.id AS id_19, t18.locker_settings AS locker_settings_20, t18.alert_settings AS alert_settings_21, t18.base_settings AS base_settings_22, t18.report_columns AS report_columns_23, t18.client_reports AS client_reports_24, t18.worker_name_format AS worker_name_format_25, t18.product_amortization_activation AS product_amortization_activation_26, t18.product_batch_creation_mode AS product_batch_creation_mode_27, t18.alert_product_batch_creation AS alert_product_batch_creation_28, t18.fakturownia_host AS fakturownia_host_29, t18.fakturownia_api_token AS fakturownia_api_token_30, t18.fakturownia_department_id AS fakturownia_department_id_31, t18.company_id AS company_id_32, t18.printer_default_id AS printer_default_id_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
|
1.82 ms (16.12%) |
1 |
SELECT t0.id AS id_1, t0.notifications AS notifications_2, t0.user_id AS user_id_3 FROM user_notification t0 WHERE t0.user_id = ?
Parameters:
[
184
]
|
|
1.35 ms (12.01%) |
1 |
SELECT t0.id AS id_1, t0.after_login_route AS after_login_route_2, t0.user_id AS user_id_3, t0.printer_id AS printer_id_4, t0.mqtt_broker_id AS mqtt_broker_id_5 FROM user_setting t0 WHERE t0.user_id = ?
Parameters:
[
184
]
|
|
0.68 ms (6.07%) |
1 |
SELECT u0_.id AS id_0, u0_.login AS login_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.lastname AS lastname_5, u0_.email AS email_6, u0_.active AS active_7, u0_.locale AS locale_8, u0_.newsletter AS newsletter_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.deactivate_date AS deactivate_date_12, u0_.group_id AS group_id_13, u0_.company_id AS company_id_14, u0_.client_id AS client_id_15, u0_.division_id AS division_id_16, u0_.client_localization_id AS client_localization_id_17, u0_.worker_id AS worker_id_18, u0_.created_by AS created_by_19, u0_.updated_by AS updated_by_20 FROM user u0_ WHERE u0_.login = ? OR u0_.email = ?
Parameters:
[ "serwis@aska.com.pl" "serwis@aska.com.pl" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 3 |
| App\Entity\UserRole | 3 |
| App\Entity\RolePermission | 2 |
| App\Entity\Company | 1 |
| App\Entity\UserSetting | 1 |
| App\Entity\CompanySetting | 1 |