Symfony Profiler

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

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

SELECT
  SUM(s0_.weight_in) AS sclr_0,
  SUM(s0_.weight_out) AS sclr_1,
  count(s0_.id) AS sclr_2
FROM
  settlements s0_
  INNER JOIN divisions d1_ ON s0_.id_division = d1_.id
  INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id
  INNER JOIN client c3_ ON c2_.client_id = c3_.id
  LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id
  LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id
WHERE
  s0_.id_company = ?
  AND (
    s0_.settlement_date BETWEEN ?
    AND ?
  )

SELECT SUM(s0_.weight_in) AS sclr_0, SUM(s0_.weight_out) AS sclr_1, count(s0_.id) AS sclr_2 FROM settlements s0_ INNER JOIN divisions d1_ ON s0_.id_division = d1_.id INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id INNER JOIN client c3_ ON c2_.client_id = c3_.id LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id WHERE s0_.id_company = 18 AND (s0_.settlement_date BETWEEN '2026-01-01 00:00:00' AND '2026-06-30 23:59:59');

SELECT
  SUM(s0_.quantity_returned) AS sclr_0
FROM
  settlements s1_
  INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id
  INNER JOIN divisions d2_ ON s1_.id_division = d2_.id
  INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id
WHERE
  s1_.id_company = ?
  AND (
    s1_.settlement_date BETWEEN ?
    AND ?
  )
  AND s1_.type = ?

SELECT SUM(s0_.quantity_returned) AS sclr_0 FROM settlements s1_ INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id INNER JOIN divisions d2_ ON s1_.id_division = d2_.id INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id WHERE s1_.id_company = 18 AND (s1_.settlement_date BETWEEN '2026-01-01 00:00:00' AND '2026-06-30 23:59:59') AND s1_.type = 'pieces';

SELECT
  SUM(s0_.weight_in) AS sclr_0,
  SUM(s0_.weight_out) AS sclr_1,
  count(s0_.id) AS sclr_2
FROM
  settlements s0_
  INNER JOIN divisions d1_ ON s0_.id_division = d1_.id
  INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id
  INNER JOIN client c3_ ON c2_.client_id = c3_.id
  LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id
  LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id
WHERE
  s0_.id_company = ?
  AND (
    s0_.settlement_date BETWEEN ?
    AND ?
  )

SELECT SUM(s0_.weight_in) AS sclr_0, SUM(s0_.weight_out) AS sclr_1, count(s0_.id) AS sclr_2 FROM settlements s0_ INNER JOIN divisions d1_ ON s0_.id_division = d1_.id INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id INNER JOIN client c3_ ON c2_.client_id = c3_.id LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id WHERE s0_.id_company = 18 AND (s0_.settlement_date BETWEEN '2026-06-01 00:00:00' AND '2026-06-30 23:59:59');

SELECT
  SUM(s0_.quantity_returned) AS sclr_0
FROM
  settlements s1_
  INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id
  INNER JOIN divisions d2_ ON s1_.id_division = d2_.id
  INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id
WHERE
  s1_.id_company = ?
  AND (
    s1_.settlement_date BETWEEN ?
    AND ?
  )
  AND s1_.type = ?

SELECT SUM(s0_.quantity_returned) AS sclr_0 FROM settlements s1_ INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id INNER JOIN divisions d2_ ON s1_.id_division = d2_.id INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id WHERE s1_.id_company = 18 AND (s1_.settlement_date BETWEEN '2026-06-01 00:00:00' AND '2026-06-30 23:59:59') AND s1_.type = 'pieces';

SELECT
  SUM(s0_.weight_in) AS sclr_0,
  SUM(s0_.weight_out) AS sclr_1,
  count(s0_.id) AS sclr_2
FROM
  settlements s0_
  INNER JOIN divisions d1_ ON s0_.id_division = d1_.id
  INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id
  INNER JOIN client c3_ ON c2_.client_id = c3_.id
  LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id
  LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id
WHERE
  s0_.id_company = ?
  AND (
    s0_.settlement_date BETWEEN ?
    AND ?
  )

SELECT SUM(s0_.weight_in) AS sclr_0, SUM(s0_.weight_out) AS sclr_1, count(s0_.id) AS sclr_2 FROM settlements s0_ INNER JOIN divisions d1_ ON s0_.id_division = d1_.id INNER JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id INNER JOIN client c3_ ON c2_.client_id = c3_.id LEFT JOIN client_group_client c5_ ON c3_.id = c5_.client_id LEFT JOIN client_group c4_ ON c4_.id = c5_.client_group_id WHERE s0_.id_company = 18 AND (s0_.settlement_date BETWEEN '2026-06-29 00:00:00' AND '2026-06-30 23:59:59');

SELECT
  SUM(s0_.quantity_returned) AS sclr_0
FROM
  settlements s1_
  INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id
  INNER JOIN divisions d2_ ON s1_.id_division = d2_.id
  INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id
WHERE
  s1_.id_company = ?
  AND (
    s1_.settlement_date BETWEEN ?
    AND ?
  )
  AND s1_.type = ?

SELECT SUM(s0_.quantity_returned) AS sclr_0 FROM settlements s1_ INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id INNER JOIN divisions d2_ ON s1_.id_division = d2_.id INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id WHERE s1_.id_company = 18 AND (s1_.settlement_date BETWEEN '2026-06-29 00:00:00' AND '2026-06-30 23:59:59') AND s1_.type = 'pieces';

SELECT
  SUM(s0_.quantity_returned) AS sclr_0
FROM
  settlements s1_
  INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id
  INNER JOIN divisions d2_ ON s1_.id_division = d2_.id
  INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id
WHERE
  s1_.id_company = ?
  AND (
    s1_.settlement_date BETWEEN ?
    AND ?
  )
  AND s1_.type = ?

SELECT SUM(s0_.quantity_returned) AS sclr_0 FROM settlements s1_ INNER JOIN settlements_items s0_ ON s1_.id = s0_.settlement_id INNER JOIN divisions d2_ ON s1_.id_division = d2_.id INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id WHERE s1_.id_company = 18 AND (s1_.settlement_date BETWEEN '2026-06-30 00:00:00' AND '2026-06-30 23:59:59') AND s1_.type = 'pieces';

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  settlements s0_
  INNER JOIN settlements_items s1_ ON s0_.id = s1_.settlement_id
  INNER JOIN divisions d2_ ON s0_.id_division = d2_.id
  INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id
WHERE
  s0_.id_company = ?
  AND (
    s0_.settlement_date BETWEEN ?
    AND ?
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM settlements s0_ INNER JOIN settlements_items s1_ ON s0_.id = s1_.settlement_id INNER JOIN divisions d2_ ON s0_.id_division = d2_.id INNER JOIN client_localization c3_ ON d2_.id_client_localization = c3_.id WHERE s0_.id_company = 18 AND (s0_.settlement_date BETWEEN '2026-06-01 00:00:00' AND '2026-06-30 23:59:59');

SELECT
  count(p0_.id) AS sclr_0
FROM
  products p0_
  LEFT JOIN divisions d1_ ON p0_.division_id = d1_.id
  LEFT JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id
WHERE
  p0_.company_id = ?
  AND p0_.active = ?

SELECT count(p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN divisions d1_ ON p0_.division_id = d1_.id LEFT JOIN client_localization c2_ ON d1_.id_client_localization = c2_.id WHERE p0_.company_id = 18 AND p0_.active = 1;

SELECT
  COUNT(*)
FROM
  client t0
WHERE
  t0.company_id = ?
  AND t0.active = ?

SELECT COUNT(*) FROM client t0 WHERE t0.company_id = 18 AND t0.active = 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.fakturownia_host AS fakturownia_host_27,
  t18.fakturownia_api_token AS fakturownia_api_token_28,
  t18.fakturownia_department_id AS fakturownia_department_id_29,
  t18.company_id AS company_id_30,
  t18.printer_default_id AS printer_default_id_31,
  t0.created_by AS created_by_32,
  t0.updated_by AS updated_by_33
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.fakturownia_host AS fakturownia_host_27, t18.fakturownia_api_token AS fakturownia_api_token_28, t18.fakturownia_department_id AS fakturownia_department_id_29, t18.company_id AS company_id_30, t18.printer_default_id AS printer_default_id_31, t0.created_by AS created_by_32, t0.updated_by AS updated_by_33 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = 18;

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 = 18);

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 = 18);

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

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 = 18 AND c0_.status = 'new' AND c0_.created_at >= '2026-06-30 00:00:00' AND c0_.active = 1;