Query Metrics
8
Database Queries
7
Different statements
4.76 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 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.id = ?
Parameters:
[
262
]
|
| 2 | 0.57 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:
[
262
]
|
| 3 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.identify_number AS identify_number_5, t0.inner_number AS inner_number_6, t0.type AS type_7, t0.active AS active_8, t0.note AS note_9, t0.state AS state_10, t0.fired_at AS fired_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deactivate_date AS deactivate_date_14, t0.barcode_prefix AS barcode_prefix_15, t0.division_id AS division_id_16, t0.client_id AS client_id_17, t18.id AS id_19, t18.name AS name_20, t18.active AS active_21, t18.deactivate_date AS deactivate_date_22, t18.created_at AS created_at_23, t18.updated_at AS updated_at_24, t18.worker_id AS worker_id_25, t18.locker_id AS locker_id_26, t18.created_by AS created_by_27, t18.updated_by AS updated_by_28, t0.deactivate_by AS deactivate_by_29, t0.fired_by AS fired_by_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32 FROM workers t0 LEFT JOIN box t18 ON t18.worker_id = t0.id WHERE t0.id = ?
Parameters:
[
"52094"
]
|
| 4 | 0.74 ms |
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.company_id AS company_id_26, t18.printer_default_id AS printer_default_id_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ?
Parameters:
[
18
]
|
| 5 | 0.50 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_type AS setting_type_3, t0.string_value AS string_value_4, t0.bool_value AS bool_value_5, t0.float_value AS float_value_6, t0.company_id AS company_id_7 FROM settings t0 WHERE (t0.setting_key = ? AND t0.company_id = ?)
Parameters:
[ "amortization" 18 ] |
| 6 | 0.32 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_type AS setting_type_3, t0.string_value AS string_value_4, t0.bool_value AS bool_value_5, t0.float_value AS float_value_6, t0.company_id AS company_id_7 FROM settings t0 WHERE (t0.setting_key = ? AND t0.company_id = ?)
Parameters:
[ "amortization" 18 ] |
| 7 | 0.74 ms |
SELECT t0.id AS id_1, t0.division AS division_2, t0.active AS active_3, t0.nip AS nip_4, t0.post_code AS post_code_5, t0.city AS city_6, t0.address AS address_7, t0.type_object AS type_object_8, t0.symbol AS symbol_9, t0.deleted_at AS deleted_at_10, t0.color AS color_11, t0.email AS email_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deactivate_date AS deactivate_date_15, t0.id_client_localization AS id_client_localization_16 FROM divisions t0 INNER JOIN user_division ON t0.id = user_division.division_id WHERE user_division.user_id = ?
Parameters:
[
262
]
|
| 8 | 0.82 ms |
SELECT count(c0_.id) AS sclr_0 FROM clothes_service c0_ LEFT JOIN divisions d1_ ON c0_.division_id = d1_.id WHERE c0_.company_id = ? AND c0_.status = ? AND c0_.created_at >= ? AND c0_.active = 1
Parameters:
[ 18 "new" "2026-06-19 00:00:00" ] |
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\UserRole | 2 |
| App\Entity\RolePermission | 2 |
| App\Entity\Company | 1 |
| App\Entity\UserNotification | 1 |
| App\Entity\UserSetting | 1 |
| App\Entity\Printer | 1 |
| App\Entity\MqttBroker | 1 |
| App\Entity\Worker | 1 |
| App\Entity\Division | 1 |
| App\Entity\Client | 1 |
| App\Entity\CompanySetting | 1 |
| App\Entity\Settings | 1 |