Symfony Profiler

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.product_batch_id = ?

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.product_batch_id = 331154;

SELECT
  p.name
FROM
  permissions p
  inner join permission_user_role pur ON p.id = pur.permission_id
  inner join user_role r on pur.user_role_id = r.id
  inner join user_role_user uru on r.id = uru.user_role_id
WHERE
  uru.user_id = ?
group by
  p.name

SELECT p.name
    FROM permissions  p
        inner join permission_user_role pur ON p.id = pur.permission_id
        inner join user_role r on pur.user_role_id = r.id
        inner join  user_role_user uru on r.id = uru.user_role_id
    WHERE uru.user_id = 184
    group by p.name;

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 = ?

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 = 184;

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 = ?

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 = 2;

SELECT
  t0.id AS id_1,
  t0.codes AS codes_2,
  t0.equipments AS equipments_3,
  t0.state AS state_4,
  t0.weight AS weight_5,
  t0.comment AS comment_6,
  t0.warnings AS warnings_7,
  t0.errors AS errors_8,
  t0.created_at AS created_at_9,
  t0.completed_at AS completed_at_10,
  t0.wrong_divisions AS wrong_divisions_11,
  t0.state_status_id AS state_status_id_12,
  t0.company_id AS company_id_13,
  t0.created_by AS created_by_14,
  t0.owner_id AS owner_id_15
FROM
  batch_job t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codes AS codes_2, t0.equipments AS equipments_3, t0.state AS state_4, t0.weight AS weight_5, t0.comment AS comment_6, t0.warnings AS warnings_7, t0.errors AS errors_8, t0.created_at AS created_at_9, t0.completed_at AS completed_at_10, t0.wrong_divisions AS wrong_divisions_11, t0.state_status_id AS state_status_id_12, t0.company_id AS company_id_13, t0.created_by AS created_by_14, t0.owner_id AS owner_id_15 FROM batch_job t0 WHERE t0.id = '178872';

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 = ?
  )

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 = 'amortization' AND t0.company_id = 6);

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 = ?

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 = 6;

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 = ?

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 = 184;

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 = ?

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 = 184;

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
  INNER JOIN batch_job_product_batch ON t0.id = batch_job_product_batch.product_batch_id
WHERE
  batch_job_product_batch.batch_job_id = ?

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 INNER JOIN batch_job_product_batch ON t0.id = batch_job_product_batch.product_batch_id WHERE batch_job_product_batch.batch_job_id = 178872;

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

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 = 6 AND c0_.status = 'new' AND c0_.created_at >= '2026-08-21 00:00:00' AND c0_.active = 1;