GET https://vps-63a4a332.vps.ovh.net/laundry/alert-group/modal-new/52094

Query Metrics

8 Database Queries
7 Different statements
4.76 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# 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

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Group No errors.
App\Entity\Company No errors.
App\Entity\Client No errors.
App\Entity\Division No errors.
App\Entity\ClientLocalization No errors.
App\Entity\UserNotification No errors.
App\Entity\UserSetting No errors.
App\Entity\Printer No errors.
App\Entity\MqttBroker No errors.
App\Entity\Worker No errors.
App\Entity\StickyNote No errors.
App\Entity\UserRole No errors.
App\Entity\StateStatus No errors.
App\Entity\RolePermission No errors.
App\Entity\Permission No errors.
App\Entity\Tag No errors.
App\Entity\QrCode No errors.
App\Entity\ClientGroup No errors.
App\Entity\PrintTemplate No errors.
App\Entity\TextileTemplate No errors.
App\Entity\Equipment No errors.
App\Entity\EquipmentType No errors.
App\Entity\CompanySetting No errors.
App\Entity\Settlement No errors.
App\Entity\Settings No errors.
App\Entity\Attribute No errors.
App\Entity\Amortization No errors.
App\Entity\ClothesGroup No errors.
App\Entity\Log No errors.
App\Entity\Module No errors.
App\Entity\ProductBatch No errors.
App\Entity\ProductAttributeGroupRelationClient No errors.
App\Entity\ClientPermission No errors.
App\Entity\CassationType No errors.
App\Entity\EquipmentClient No errors.
App\Entity\Clothe No errors.
App\Entity\LumpSumAgreement No errors.
App\Entity\StorageDocument No errors.
App\Entity\ClientLaundry No errors.
App\Entity\AmortizationPrice No errors.
App\Entity\AmortizationContract No errors.
App\Entity\Circulation No errors.
App\Entity\Invoice No errors.
App\Entity\Device No errors.
App\Entity\ProductKit No errors.
App\Entity\Product No errors.
App\Entity\Box No errors.
App\Entity\ProductBatchHistory No errors.
App\Entity\ProductLog No errors.
App\Entity\Cassation No errors.
App\Entity\CassationObjects No errors.
App\Entity\AlertGroup No errors.
App\Entity\ProductReturned No errors.
App\Entity\CirculationItem No errors.
App\Entity\StateHistory No errors.
App\Entity\PermissionGroup No errors.
App\Entity\EquipmentRental No errors.
App\Entity\SettlementItem No errors.
App\Entity\ProductAttributeGroup No errors.
App\Entity\ProductAttribute No errors.
App\Entity\Price No errors.
App\Entity\BatchJob No errors.
App\Entity\AmortizationPriceItem No errors.
App\Entity\PriceMaintenance No errors.
App\Entity\PriceStorage No errors.
App\Entity\ClotheSetting No errors.
App\Entity\PriceBatch No errors.
App\Entity\StorageHistory No errors.
App\Entity\Storage No errors.
App\Entity\ProductLock No errors.
App\Entity\PriceItem No errors.
App\Entity\AmortizationCirculation No errors.
App\Entity\AmortizationSuspension No errors.
App\Entity\InvoiceItem No errors.
App\Entity\ProductState No errors.
App\Entity\Alert No errors.
App\Entity\ClothesService No errors.
App\Entity\ClothesServiceEvent No errors.
App\Entity\ProductReturnedItem No errors.
App\Entity\Size No errors.
App\Entity\AmortizationCirculationItem No errors.
App\Entity\Locker No errors.
App\Entity\ProductAttributeGroupRelationCompany No errors.
App\Entity\EquipmentTransportScanEvent No errors.
App\Entity\ProductWithdrawal No errors.
App\Entity\PhysicalInventory No errors.
App\Entity\DeviceRead No errors.
App\Entity\Task No errors.
App\Entity\StateHistoryArchive No errors.
App\Entity\ReportSettings No errors.
App\Entity\EquipmentTransportOrderLine No errors.
App\Entity\Numeration No errors.
App\Entity\Faq No errors.
App\Entity\EquipmentTransportOrder No errors.
App\Entity\ProductOrderItem No errors.
App\Entity\DeviceError No errors.
App\Entity\EquipmentTransportOrderItem No errors.
App\Entity\Newsletter No errors.
App\Entity\FaqFile No errors.
App\Entity\ProductOrder No errors.
App\Entity\ProductBatchArchive No errors.
App\Entity\InventoryGroup No errors.
App\Entity\ProductWithdrawalItem No errors.
App\Entity\StateRoadMap No errors.
App\Entity\FaqTag No errors.
App\Entity\Inventory No errors.
App\Entity\Document No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\EquipmentTransportOrderExtraItem No errors.
App\Entity\ClothesServiceReason No errors.
App\Entity\EquipmentCurrentState No errors.
Vich\UploaderBundle\Entity\File No errors.