GET http://pawelvivobook.tail089c3d.ts.net/laundry/products-batch/335449/history

Query Metrics

127 Database Queries
15 Different statements
51.99 ms Query time
0 Invalid entities
250 Managed entities

Grouped Statements

Show all queries

Time Count Info
35.01 ms
(67.34%)
100
SELECT t0.id AS id_1, t0.code AS code_2, t0.barcode AS barcode_3, t0.active AS active_4, t0.cassation AS cassation_5, t0.cassation_date AS cassation_date_6, t0.sequence AS sequence_7, t0.entery_at AS entery_at_8, t0.expiration_at AS expiration_at_9, t0.owner AS owner_10, t0.size AS size_11, t0.material AS material_12, t0.color AS color_13, t0.note AS note_14, t0.washes AS washes_15, t0.weight AS weight_16, t0.region AS region_17, t0.ktm AS ktm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deactivate_date AS deactivate_date_21, t0.division_id AS division_id_22, t0.worker_id AS worker_id_23, t0.clothes_group_id AS clothes_group_id_24, t0.product_batch_id AS product_batch_id_25, t0.company_id AS company_id_26, t0.replacement_id AS replacement_id_27, t0.product_kit_id AS product_kit_id_28, t0.product_size_id AS product_size_id_29, t0.amortization_price_item_id AS amortization_price_item_id_30, t0.clothe_id AS clothe_id_31, t0.created_by AS created_by_32, t0.updated_by AS updated_by_33 FROM products t0 WHERE t0.id = ?
Parameters:
[
  45850
]
5.36 ms
(10.30%)
1
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM state_machines_histories s0_ LEFT JOIN products p1_ ON s0_.product_id = p1_.id INNER JOIN clothe c2_ ON p1_.clothe_id = c2_.id LEFT JOIN workers w3_ ON p1_.worker_id = w3_.id LEFT JOIN products_batch p4_ ON s0_.product_batch_id = p4_.id LEFT JOIN state_statuses s5_ ON s0_.state_status_id = s5_.id LEFT JOIN user u6_ ON s0_.created_by = u6_.id WHERE p1_.company_id = ? AND s0_.product_batch_id = ? AND s0_.owner_id IS NULL
Parameters:
[
  6
  335449
]
4.34 ms
(8.34%)
11
SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.weight AS weight_3, t0.quantity AS quantity_4, t0.size AS size_5, t0.material AS material_6, t0.color AS color_7, t0.priority AS priority_8, t0.washing_limit AS washing_limit_9, t0.active AS active_10, t0.m2 AS m2_11, t0.ktm AS ktm_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.barcode_prefix AS barcode_prefix_15, t0.deactivate_date AS deactivate_date_16, t0.client_id AS client_id_17, t0.division_id AS division_id_18, t0.company_id AS company_id_19, t20.id AS id_21, t20.quantity_price AS quantity_price_22, t20.weight_price AS weight_price_23, t20.m2_price AS m2_price_24, t20.role AS role_25, t20.created_at AS created_at_26, t20.updated_at AS updated_at_27, t20.deleted_at AS deleted_at_28, t20.company_id AS company_id_29, t20.clothes_group_id AS clothes_group_id_30, t20.created_by AS created_by_31, t20.updated_by AS updated_by_32, t0.amortization_id AS amortization_id_33, t0.clothe_id AS clothe_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM clothes_group t0 LEFT JOIN price t20 ON t20.clothes_group_id = t0.id WHERE t0.id = ?
Parameters:
[
  5164
]
1.36 ms
(2.62%)
1
SELECT s0_.id AS id_0, s0_.date AS date_1, s0_.quantity_price AS quantity_price_2, s0_.weight_price AS weight_price_3, s0_.m2_price AS m2_price_4, s0_.state_status_id AS state_status_id_5, s0_.product_id AS product_id_6, s0_.client_id AS client_id_7, s0_.client_localization_id AS client_localization_id_8, s0_.division_id AS division_id_9, s0_.product_batch_id AS product_batch_id_10, s0_.owner_id AS owner_id_11, s0_.lump_sum_agreement_id AS lump_sum_agreement_id_12, s0_.worker_id AS worker_id_13, s0_.created_by AS created_by_14, s0_.updated_by AS updated_by_15 FROM state_machines_histories s0_ LEFT JOIN products p1_ ON s0_.product_id = p1_.id INNER JOIN clothe c2_ ON p1_.clothe_id = c2_.id LEFT JOIN workers w3_ ON p1_.worker_id = w3_.id LEFT JOIN products_batch p4_ ON s0_.product_batch_id = p4_.id LEFT JOIN state_statuses s5_ ON s0_.state_status_id = s5_.id LEFT JOIN user u6_ ON s0_.created_by = u6_.id WHERE p1_.company_id = ? AND s0_.product_batch_id = ? AND s0_.owner_id IS NULL AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  6
  335449
  26869633
  26869634
  26869635
  26869636
  26869637
  26869638
  26869639
  26869640
  26869641
  26869642
  26869643
  26869644
  26869645
  26869646
  26869647
  26869648
  26869649
  26869650
  26869651
  26869652
  26869653
  26869654
  26869655
  26869656
  26869657
  26869658
  26869659
  26869660
  26869661
  26869662
  26869663
  26869664
  26869665
  26869666
  26869667
  26869668
  26869669
  26869670
  26869671
  26869672
  26869673
  26869674
  26869675
  26869676
  26869677
  26869678
  26869679
  26869680
  26869681
  26869682
  26869683
  26869684
  26869685
  26869686
  26869687
  26869688
  26869689
  26869690
  26869691
  26869692
  26869693
  26869694
  26869695
  26869696
  26869697
  26869698
  26869699
  26869700
  26869701
  26869702
  26869703
  26869704
  26869705
  26869706
  26869707
  26869708
  26869709
  26869710
  26869711
  26869712
  26869713
  26869714
  26869715
  26869716
  26869717
  26869718
  26869719
  26869720
  26869721
  26869722
  26869723
  26869724
  26869725
  26869726
  26869727
  26869728
  26869729
  26869730
  26869731
  26869732
]
1.25 ms
(2.40%)
3
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:
[
  1888
]
1.05 ms
(2.02%)
1
SELECT DISTINCT s0_.id AS id_0 FROM state_machines_histories s0_ LEFT JOIN products p1_ ON s0_.product_id = p1_.id INNER JOIN clothe c2_ ON p1_.clothe_id = c2_.id LEFT JOIN workers w3_ ON p1_.worker_id = w3_.id LEFT JOIN products_batch p4_ ON s0_.product_batch_id = p4_.id LEFT JOIN state_statuses s5_ ON s0_.state_status_id = s5_.id LEFT JOIN user u6_ ON s0_.created_by = u6_.id WHERE p1_.company_id = ? AND s0_.product_batch_id = ? AND s0_.owner_id IS NULL LIMIT 100
Parameters:
[
  6
  335449
]
0.86 ms
(1.65%)
2
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"
  6
]
0.68 ms
(1.31%)
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
]
0.43 ms
(0.83%)
1
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:
[
  184
]
0.34 ms
(0.65%)
1
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:
[
  184
]
0.32 ms
(0.62%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.color AS color_3, t0.active AS active_4, t0.is_first AS is_first_5, t0.is_last AS is_last_6, t0.role AS role_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deactivate_date AS deactivate_date_11, t0.company_id AS company_id_12, t0.client_id AS client_id_13, t0.division_id AS division_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16 FROM state_statuses t0 INNER JOIN user_visible_state_status ON t0.id = user_visible_state_status.state_status_id WHERE user_visible_state_status.user_id = ?
Parameters:
[
  184
]
0.29 ms
(0.56%)
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
]
0.28 ms
(0.54%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.color AS color_3, t0.active AS active_4, t0.is_first AS is_first_5, t0.is_last AS is_last_6, t0.role AS role_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deactivate_date AS deactivate_date_11, t0.company_id AS company_id_12, t0.client_id AS client_id_13, t0.division_id AS division_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16 FROM state_statuses t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.25 ms
(0.48%)
1
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:
[
  6
  "new"
  "2026-08-21 00:00:00"
]
0.18 ms
(0.35%)
1
SELECT t0.id AS id_1, t0.batch AS batch_2, t0.active AS active_3, t0.status AS status_4, t0.input_product_count AS input_product_count_5, t0.output_product_count AS output_product_count_6, t0.closed_at AS closed_at_7, t0.weight AS weight_8, t0.comment AS comment_9, t0.document_type AS document_type_10, t0.complete_at AS complete_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deactivate_date AS deactivate_date_14, t0.division_id AS division_id_15, t0.company_id AS company_id_16, t0.state_first_id AS state_first_id_17, t0.state_last_id AS state_last_id_18, t0.client_id AS client_id_19, t0.client_localization_id AS client_localization_id_20, t0.owner_id AS owner_id_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23 FROM products_batch t0 WHERE t0.id = ?
Parameters:
[
  "335449"
]

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\StateHistory 100
App\Entity\Product 100
App\Entity\ClothesGroup 11
App\Entity\Clothe 11
App\Entity\User 5
App\Entity\UserRole 3
App\Entity\Worker 3
App\Entity\Box 3
App\Entity\RolePermission 2
App\Entity\ProductBatch 2
App\Entity\StateStatus 2
App\Entity\Company 1
App\Entity\UserSetting 1
App\Entity\Division 1
App\Entity\Client 1
App\Entity\ClientLocalization 1
App\Entity\CompanySetting 1
App\Entity\Settings 1
App\Entity\Locker 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\ProductBatch No errors.
App\Entity\Product No errors.
App\Entity\ProductBatchHistory No errors.
App\Entity\BatchJob No errors.
App\Entity\StateHistory No errors.
App\Entity\Clothe No errors.
App\Entity\LumpSumAgreement 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\PrintTemplate No errors.
App\Entity\ClothesGroup No errors.
App\Entity\Log No errors.
App\Entity\ClothesService No errors.
App\Entity\ProductKit No errors.
App\Entity\Size No errors.
App\Entity\AmortizationPriceItem No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductState No errors.
App\Entity\Alert No errors.
App\Entity\ProductLog No errors.
App\Entity\ClothesServiceEvent No errors.
App\Entity\CassationObjects No errors.
App\Entity\ProductReturnedItem No errors.
App\Entity\Circulation No errors.
App\Entity\StorageHistory No errors.
App\Entity\CirculationItem No errors.
App\Entity\ProductLock No errors.
App\Entity\AmortizationSuspension No errors.
App\Entity\AmortizationCirculationItem No errors.
App\Entity\Price No errors.
App\Entity\SettlementItem No errors.
App\Entity\Box No errors.
App\Entity\Locker No errors.
App\Entity\Cassation No errors.
App\Entity\AlertGroup No errors.
App\Entity\ProductReturned No errors.
App\Entity\Module No errors.
App\Entity\ProductAttributeGroupRelationClient No errors.
App\Entity\ClientPermission No errors.
App\Entity\CassationType No errors.
App\Entity\EquipmentClient No errors.
App\Entity\StorageDocument No errors.
App\Entity\ClientGroup No errors.
App\Entity\ClientLaundry No errors.
App\Entity\TextileTemplate No errors.
App\Entity\AmortizationPrice No errors.
App\Entity\AmortizationContract No errors.
App\Entity\Invoice No errors.
App\Entity\Device No errors.
App\Entity\Tag No errors.
App\Entity\QrCode No errors.
App\Entity\PermissionGroup No errors.
App\Entity\PriceMaintenance No errors.
App\Entity\PriceStorage No errors.
App\Entity\ClotheSetting No errors.
App\Entity\PriceBatch No errors.
App\Entity\EquipmentRental No errors.
App\Entity\SettlementAdditionalReturnItem No errors.
App\Entity\ProductAttributeGroup No errors.
App\Entity\InvoiceItem No errors.
App\Entity\ClothesServiceReason No errors.
App\Entity\Storage No errors.
App\Entity\AmortizationCirculation No errors.
App\Entity\Equipment No errors.
App\Entity\StateRoadMap No errors.
App\Entity\PriceItem No errors.
App\Entity\ProductAttributeGroupRelationCompany No errors.
App\Entity\Faq No errors.
App\Entity\ProductOrder No errors.
App\Entity\Numeration No errors.
App\Entity\Newsletter No errors.
App\Entity\ReportSettings No errors.
App\Entity\Task No errors.
App\Entity\PhysicalInventory No errors.
App\Entity\StateHistoryArchive No errors.
App\Entity\Notification No errors.
App\Entity\Inventory No errors.
App\Entity\ProductOrderItem No errors.
App\Entity\FaqTag No errors.
App\Entity\EquipmentType No errors.
App\Entity\Document No errors.
App\Entity\ProductBatchArchive No errors.
App\Entity\ProductWithdrawal No errors.
App\Entity\DeviceError No errors.
App\Entity\FaqFile No errors.
App\Entity\DeviceRead No errors.
App\Entity\InventoryGroup No errors.
App\Entity\ProductWithdrawalItem No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
Vich\UploaderBundle\Entity\File No errors.