Query Metrics
29
Database Queries
26
Different statements
352.70 ms
Query time
0
Invalid entities
27
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.97 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.cartrack_driver_id AS cartrack_driver_id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deactivate_date AS deactivate_date_14, t0.group_id AS group_id_15, t0.company_id AS company_id_16, t0.client_id AS client_id_17, t0.division_id AS division_id_18, t0.client_localization_id AS client_localization_id_19, t20.id AS id_21, t20.notifications AS notifications_22, t20.user_id AS user_id_23, t24.id AS id_25, t24.after_login_route AS after_login_route_26, t24.user_id AS user_id_27, t24.printer_id AS printer_id_28, t24.mqtt_broker_id AS mqtt_broker_id_29, t0.worker_id AS worker_id_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32 FROM user t0 LEFT JOIN user_notification t20 ON t20.user_id = t0.id LEFT JOIN user_setting t24 ON t24.user_id = t0.id WHERE t0.id = ?
Parameters:
[
262
]
|
| 2 | 0.70 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.84 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 IS NOT NULL AND p0_.id IN (?)
Parameters:
[ 18 "881733" ] |
| 4 | 0.79 ms |
SELECT 1 AS sclr_0 FROM equipment e0_ WHERE e0_.company_id = ? AND e0_.active = 1 AND (e0_.barcode = ? OR e0_.epc = ?) LIMIT 1
Parameters:
[ 18 "340225C503C848335A4FFADB" "340225C503C848335A4FFADB" ] |
| 5 | 0.67 ms |
SELECT 1 AS sclr_0 FROM products p0_ WHERE p0_.company_id = ? AND p0_.active = 1 AND p0_.code = ? AND p0_.id <> ? LIMIT 1
Parameters:
[ 18 "340225C503C848335A4FFADB" 881733 ] |
| 6 | 0.60 ms |
SELECT 1 AS sclr_0 FROM equipment e0_ WHERE e0_.company_id = ? AND e0_.active = 1 AND (e0_.barcode = ? OR e0_.epc = ?) LIMIT 1
Parameters:
[ 18 "98765458898" "98765458898" ] |
| 7 | 334.27 ms |
SELECT 1 AS sclr_0 FROM products p0_ WHERE p0_.company_id = ? AND p0_.active = 1 AND p0_.barcode = ? AND p0_.id <> ? LIMIT 1
Parameters:
[ 18 "98765458898" 881733 ] |
| 8 | 0.35 ms |
"START TRANSACTION"
Parameters:
[] |
| 9 | 2.64 ms |
UPDATE products SET code = ?, updated_at = ? WHERE id = ?
Parameters:
[ "340225C503C848335A4FFADB" "2026-09-10 14:45:02" 881733 ] |
| 10 | 0.57 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 WHERE t0.id = ?
Parameters:
[
1490
]
|
| 11 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.post_code AS post_code_4, t0.city AS city_5, t0.address AS address_6, t0.nip AS nip_7, t0.phone AS phone_8, t0.symbol AS symbol_9, t0.deleted_at AS deleted_at_10, t0.name_end_status AS name_end_status_11, t0.clothes_service_limit AS clothes_service_limit_12, t0.region AS region_13, t0.delivery_address AS delivery_address_14, t0.email AS email_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deactivate_date AS deactivate_date_18, t0.client_id AS client_id_19 FROM client_localization t0 WHERE t0.id = ?
Parameters:
[
513
]
|
| 12 | 0.88 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:
[
51594
]
|
| 13 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.ktm AS ktm_4, t0.weight AS weight_5, t0.m2 AS m2_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.company_id AS company_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM clothe t0 WHERE t0.id = ?
Parameters:
[
32
]
|
| 14 | 0.32 ms |
SAVEPOINT DOCTRINE_2
Parameters:
[] |
| 15 | 1.30 ms |
INSERT INTO product_log (entity_change_set, type, created_at, company_id, product_id, worker_id, product_attribute_id, state_history_id, created_by, clothes_service_event_id, clothes_service_id, owner_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "{"code":[null,"340225C503C848335A4FFADB"]}" "product_update" "2026-09-10 14:45:03" 18 881733 51594 null null 262 null null null ] |
| 16 | 0.16 ms |
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[] |
| 17 | 1.83 ms |
"COMMIT"
Parameters:
[] |
| 18 | 0.69 ms |
SELECT t0.id AS id_1, t0.expiration_at AS expiration_at_2, t0.circulation_id AS circulation_id_3, t0.worker_id AS worker_id_4, t0.product_id AS product_id_5 FROM circulation_item t0 WHERE ((t0.expiration_at IS NULL AND t0.worker_id = ?) AND t0.product_id = ?)
Parameters:
[ 51594 881733 ] |
| 19 | 0.38 ms |
SELECT t0.id AS id_1, t0.expiration_at AS expiration_at_2, t0.circulation_id AS circulation_id_3, t0.worker_id AS worker_id_4, t0.product_id AS product_id_5 FROM circulation_item t0 WHERE ((t0.expiration_at IS NULL AND t0.worker_id = ?) AND t0.product_id = ?)
Parameters:
[ 51594 881733 ] |
| 20 | 0.32 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.storage_id AS storage_id_3, t0.created_by AS created_by_4, t0.product_id AS product_id_5, t0.company_id AS company_id_6, t0.division_id AS division_id_7, t0.worker_id AS worker_id_8, t0.storage_document_id AS storage_document_id_9 FROM storage_history t0 WHERE t0.product_id = ?
Parameters:
[
881733
]
|
| 21 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.document AS document_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8, t0.storage_id AS storage_id_9, t0.circulation_id AS circulation_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM storage_document t0 WHERE t0.id = ?
Parameters:
[
1512
]
|
| 22 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pz_actions AS pz_actions_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.company_id AS company_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM storage t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 23 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.deactivate_date AS deactivate_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7, t0.alert_group_id AS alert_group_id_8, t0.deactivate_by AS deactivate_by_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM alert t0 WHERE (t0.active = ? AND t0.product_id = ?) ORDER BY t0.created_at DESC
Parameters:
[ 1 881733 ] |
| 24 | 0.37 ms |
SELECT t0.id AS id_1, t0.returned AS returned_2, t0.returned_at AS returned_at_3, t0.updated_at AS updated_at_4, t0.state AS state_5, t0.product_returned_id AS product_returned_id_6, t0.product_id AS product_id_7, t0.division_id AS division_id_8, t0.worker_id AS worker_id_9, t0.clothes_group_id AS clothes_group_id_10, t0.product_kit_id AS product_kit_id_11, t0.returned_by_id AS returned_by_id_12, t0.cassation_id AS cassation_id_13, t0.state_history_id AS state_history_id_14, t0.updated_by AS updated_by_15, t0.storage_history_id AS storage_history_id_16 FROM product_returned_item t0 WHERE t0.product_id = ?
Parameters:
[
881733
]
|
| 25 | 0.47 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.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.cartrack_base_url AS cartrack_base_url_32, t18.cartrack_basic_auth_username AS cartrack_basic_auth_username_33, t18.cartrack_basic_auth_password AS cartrack_basic_auth_password_34, t18.company_id AS company_id_35, t18.printer_default_id AS printer_default_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ?
Parameters:
[
18
]
|
| 26 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.deactivate_date AS deactivate_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.client_localization_id AS client_localization_id_8, t0.division_id AS division_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM locker t0 WHERE t0.id = ?
Parameters:
[
1102
]
|
| 27 | 0.42 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.quantity_price AS quantity_price_3, t0.weight_price AS weight_price_4, t0.m2_price AS m2_price_5, t0.state_status_id AS state_status_id_6, t0.product_id AS product_id_7, t0.client_id AS client_id_8, t0.client_localization_id AS client_localization_id_9, t0.division_id AS division_id_10, t0.product_batch_id AS product_batch_id_11, t0.owner_id AS owner_id_12, t0.lump_sum_agreement_id AS lump_sum_agreement_id_13, t0.worker_id AS worker_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16 FROM state_machines_histories t0 WHERE (t0.owner_id IS NULL AND t0.product_id = ?)
Parameters:
[
881733
]
|
| 28 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.type AS type_4, t0.returned_at AS returned_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.document_type AS document_type_8, t0.company_id AS company_id_9, t0.worker_id AS worker_id_10, t0.alert_group_id AS alert_group_id_11, t0.returned_by_id AS returned_by_id_12, t0.state_status_id AS state_status_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM product_returned t0 WHERE t0.id = ?
Parameters:
[
455
]
|
| 29 | 0.45 ms |
SELECT t0.id AS id_1, t0.expiration_at AS expiration_at_2, t0.circulation_id AS circulation_id_3, t0.worker_id AS worker_id_4, t0.product_id AS product_id_5 FROM circulation_item t0 WHERE ((t0.expiration_at IS NULL AND t0.worker_id = ?) AND t0.product_id = ?)
Parameters:
[ 51594 881733 ] |
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\Client | 2 |
| App\Entity\Company | 1 |
| App\Entity\UserNotification | 1 |
| App\Entity\UserSetting | 1 |
| App\Entity\Printer | 1 |
| App\Entity\MqttBroker | 1 |
| App\Entity\Product | 1 |
| App\Entity\Division | 1 |
| App\Entity\Worker | 1 |
| App\Entity\Clothe | 1 |
| App\Entity\ClientLocalization | 1 |
| App\Entity\Box | 1 |
| App\Entity\Locker | 1 |
| App\Entity\ProductLog | 1 |
| App\Entity\StorageHistory | 1 |
| App\Entity\Storage | 1 |
| App\Entity\StorageDocument | 1 |
| App\Entity\ProductReturnedItem | 1 |
| App\Entity\ProductReturned | 1 |
| App\Entity\CompanySetting | 1 |