Query Metrics
6
Database Queries
6
Different statements
138.83 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.13 ms |
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:
[ "kannegiesser@ics.pl" "kannegiesser@ics.pl" ] |
| 2 | 0.43 ms |
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:
[
337
]
|
| 3 | 0.46 ms |
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:
[
337
]
|
| 4 | 0.65 ms |
SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.login = ? LIMIT 1
Parameters:
[
"kannegiesser@ics.pl"
]
|
| 5 | 0.73 ms |
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:
[
337
]
|
| 6 | 135.43 ms |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.barcode AS barcode_2, p0_.active AS active_3, p0_.cassation AS cassation_4, p0_.cassation_date AS cassation_date_5, p0_.sequence AS sequence_6, p0_.entery_at AS entery_at_7, p0_.expiration_at AS expiration_at_8, p0_.owner AS owner_9, p0_.size AS size_10, p0_.material AS material_11, p0_.color AS color_12, p0_.note AS note_13, p0_.washes AS washes_14, p0_.weight AS weight_15, p0_.region AS region_16, p0_.ktm AS ktm_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.deactivate_date AS deactivate_date_20, p0_.division_id AS division_id_21, p0_.worker_id AS worker_id_22, p0_.clothes_group_id AS clothes_group_id_23, p0_.product_batch_id AS product_batch_id_24, p0_.company_id AS company_id_25, p0_.replacement_id AS replacement_id_26, p0_.product_kit_id AS product_kit_id_27, p0_.product_size_id AS product_size_id_28, p0_.amortization_price_item_id AS amortization_price_item_id_29, p0_.clothe_id AS clothe_id_30, p0_.created_by AS created_by_31, p0_.updated_by AS updated_by_32 FROM products p0_ WHERE p0_.company_id = ? AND p0_.active = 1 AND (p0_.barcode = ? OR p0_.code = ?)
Parameters:
[ 18 "300ED89F335001401F161B15" "300ED89F335001401F161B15" ] |
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 | 2 |
| App\Entity\Company | 1 |
| App\Entity\UserSetting | 1 |
| App\Entity\UserRole | 1 |
| App\Entity\RolePermission | 1 |