Query Metrics
127
Database Queries
15
Different statements
51.99 ms
Query time
0
Invalid entities
250
Managed entities
Grouped Statements
| 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 |