Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.reset_password_code AS reset_password_code_7,
  t0.has_accepted_terms AS has_accepted_terms_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.disabled AS disabled_11
FROM
  residents t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_code AS reset_password_code_7, t0.has_accepted_terms AS has_accepted_terms_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.disabled AS disabled_11 FROM residents t0 WHERE t0.email = '[email protected]' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO action_log (
  method, action, controller_action,
  body, created_at, updated_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO action_log (method, action, controller_action, body, created_at, updated_at, user_id) VALUES ('GET', '/apiV2/residents/home/dashboard?id=211535', 'A', NULL, '2026-03-26 14:33:30', '2026-03-26 14:33:30', NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.display_flat_id AS display_flat_id_2,
  t0.size AS size_3,
  t0.owner_name AS owner_name_4,
  t0.owner_lastname AS owner_lastname_5,
  t0.owner_address AS owner_address_6,
  t0.owner_contact AS owner_contact_7,
  t0.owner_phone_number AS owner_phone_number_8,
  t0.rent AS rent_9,
  t0.debit AS debit_10,
  t0.previous_bill AS previous_bill_11,
  t0.type AS type_12,
  t0.subType AS subType_13,
  t0.old_debit AS old_debit_14,
  t0.comment AS comment_15,
  t0.members AS members_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.company_name AS company_name_19,
  t0.mat_id AS mat_id_20,
  t0.pib AS pib_21,
  t0.owner_email AS owner_email_22,
  t0.email_can_be_used AS email_can_be_used_23,
  t0.company_place AS company_place_24,
  t0.occupant AS occupant_25,
  t0.occupantEmail AS occupantEmail_26,
  t0.archived AS archived_27,
  t0.archived_at AS archived_at_28,
  t0.bank_account AS bank_account_29,
  t0.createdBy AS createdBy_30,
  t0.eInvoice AS eInvoice_31,
  t0.jbkjs AS jbkjs_32,
  t0.contract_number AS contract_number_33,
  t0.order_number AS order_number_34,
  t0.object_code AS object_code_35,
  t0.print_bill AS print_bill_36,
  t0.old_debit_date AS old_debit_date_37,
  t0.user_id AS user_id_38,
  t0.building_id AS building_id_39,
  t0.current_flat AS current_flat_40,
  t0.resident_id AS resident_id_41
FROM
  flat t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.display_flat_id AS display_flat_id_2, t0.size AS size_3, t0.owner_name AS owner_name_4, t0.owner_lastname AS owner_lastname_5, t0.owner_address AS owner_address_6, t0.owner_contact AS owner_contact_7, t0.owner_phone_number AS owner_phone_number_8, t0.rent AS rent_9, t0.debit AS debit_10, t0.previous_bill AS previous_bill_11, t0.type AS type_12, t0.subType AS subType_13, t0.old_debit AS old_debit_14, t0.comment AS comment_15, t0.members AS members_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_name AS company_name_19, t0.mat_id AS mat_id_20, t0.pib AS pib_21, t0.owner_email AS owner_email_22, t0.email_can_be_used AS email_can_be_used_23, t0.company_place AS company_place_24, t0.occupant AS occupant_25, t0.occupantEmail AS occupantEmail_26, t0.archived AS archived_27, t0.archived_at AS archived_at_28, t0.bank_account AS bank_account_29, t0.createdBy AS createdBy_30, t0.eInvoice AS eInvoice_31, t0.jbkjs AS jbkjs_32, t0.contract_number AS contract_number_33, t0.order_number AS order_number_34, t0.object_code AS object_code_35, t0.print_bill AS print_bill_36, t0.old_debit_date AS old_debit_date_37, t0.user_id AS user_id_38, t0.building_id AS building_id_39, t0.current_flat AS current_flat_40, t0.resident_id AS resident_id_41 FROM flat t0 WHERE t0.id = '211535' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.manager_info AS manager_info_1,
  s0_.option_name AS option_name_2,
  s0_.coefficient AS coefficient_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.cc_email AS cc_email_6,
  s0_.invoice_nomenclature AS invoice_nomenclature_7,
  s0_.nomenclature_update AS nomenclature_update_8,
  s0_.unpaid_bills_number_for_alert AS unpaid_bills_number_for_alert_9,
  s0_.coefficient_comment AS coefficient_comment_10,
  s0_.option_names_info AS option_names_info_11,
  s0_.options AS options_12,
  s0_.user_id AS user_id_13,
  s0_.building_id AS building_id_14,
  s0_.flat_id AS flat_id_15
FROM
  settings s0_
WHERE
  s0_.building_id = ?
  AND s0_.manager_info IS NOT NULL
  AND s0_.flat_id IS NULL

SELECT s0_.id AS id_0, s0_.manager_info AS manager_info_1, s0_.option_name AS option_name_2, s0_.coefficient AS coefficient_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.cc_email AS cc_email_6, s0_.invoice_nomenclature AS invoice_nomenclature_7, s0_.nomenclature_update AS nomenclature_update_8, s0_.unpaid_bills_number_for_alert AS unpaid_bills_number_for_alert_9, s0_.coefficient_comment AS coefficient_comment_10, s0_.option_names_info AS option_names_info_11, s0_.options AS options_12, s0_.user_id AS user_id_13, s0_.building_id AS building_id_14, s0_.flat_id AS flat_id_15 FROM settings s0_ WHERE s0_.building_id = 9079 AND s0_.manager_info IS NOT NULL AND s0_.flat_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.code AS code_5,
  t0.address AS address_6,
  t0.mat_id AS mat_id_7,
  t0.pib AS pib_8,
  t0.startingMoney AS startingMoney_9,
  t0.bank_account AS bank_account_10,
  t0.flats AS flats_11,
  t0.building_size AS building_size_12,
  t0.population AS population_13,
  t0.post_code AS post_code_14,
  t0.city AS city_15,
  t0.municipality AS municipality_16,
  t0.type AS type_17,
  t0.email AS email_18,
  t0.construction_year AS construction_year_19,
  t0.active_status AS active_status_20,
  t0.createdBy AS createdBy_21,
  t0.enableFlatUserCreate AS enableFlatUserCreate_22,
  t0.elevator AS elevator_23,
  t0.building_servicing AS building_servicing_24,
  t0.management AS management_25,
  t0.user_id AS user_id_26,
  t0.building_id_bs AS building_id_bs_27,
  t0.main_flat_id AS main_flat_id_28
FROM
  building t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.code AS code_5, t0.address AS address_6, t0.mat_id AS mat_id_7, t0.pib AS pib_8, t0.startingMoney AS startingMoney_9, t0.bank_account AS bank_account_10, t0.flats AS flats_11, t0.building_size AS building_size_12, t0.population AS population_13, t0.post_code AS post_code_14, t0.city AS city_15, t0.municipality AS municipality_16, t0.type AS type_17, t0.email AS email_18, t0.construction_year AS construction_year_19, t0.active_status AS active_status_20, t0.createdBy AS createdBy_21, t0.enableFlatUserCreate AS enableFlatUserCreate_22, t0.elevator AS elevator_23, t0.building_servicing AS building_servicing_24, t0.management AS management_25, t0.user_id AS user_id_26, t0.building_id_bs AS building_id_bs_27, t0.main_flat_id AS main_flat_id_28 FROM building t0 WHERE t0.id = 9079;

SELECT
  (
    sum(f0_.debit + f0_.previous_bill)
  ) AS sclr_0
FROM
  flat f0_
WHERE
  f0_.user_id = ?
  AND f0_.building_id = ?
  AND f0_.archived = 0

SELECT (sum(f0_.debit + f0_.previous_bill)) AS sclr_0 FROM flat f0_ WHERE f0_.user_id = 5014 AND f0_.building_id = 9079 AND f0_.archived = 0;

SELECT
  m0_.id AS id_0,
  m0_.amount AS amount_1,
  m0_.month AS month_2,
  m0_.created_at AS created_at_3,
  m0_.update_at AS update_at_4,
  m0_.log_creation_date AS log_creation_date_5,
  m0_.debit AS debit_6,
  m0_.comment AS comment_7,
  m0_.monthly_bill AS monthly_bill_8,
  m0_.start_money_data AS start_money_data_9,
  m0_.left_money_data AS left_money_data_10,
  m0_.status AS status_11,
  m0_.over_money AS over_money_12,
  m0_.createdBy AS createdBy_13,
  m0_.month_paid AS month_paid_14,
  m0_.bankFileId AS bankFileId_15,
  m0_.publish_bill AS publish_bill_16,
  m0_.user_id AS user_id_17,
  m0_.building_id AS building_id_18,
  m0_.flat_id AS flat_id_19,
  m0_.processed_flat_id AS processed_flat_id_20
FROM
  money_log m0_
WHERE
  m0_.building_id = ?
  AND m0_.created_at >= ?
  AND m0_.created_at <= ?
  AND m0_.debit IN (1, 4)
  AND m0_.status <> 0
ORDER BY
  m0_.created_at ASC

SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.month AS month_2, m0_.created_at AS created_at_3, m0_.update_at AS update_at_4, m0_.log_creation_date AS log_creation_date_5, m0_.debit AS debit_6, m0_.comment AS comment_7, m0_.monthly_bill AS monthly_bill_8, m0_.start_money_data AS start_money_data_9, m0_.left_money_data AS left_money_data_10, m0_.status AS status_11, m0_.over_money AS over_money_12, m0_.createdBy AS createdBy_13, m0_.month_paid AS month_paid_14, m0_.bankFileId AS bankFileId_15, m0_.publish_bill AS publish_bill_16, m0_.user_id AS user_id_17, m0_.building_id AS building_id_18, m0_.flat_id AS flat_id_19, m0_.processed_flat_id AS processed_flat_id_20 FROM money_log m0_ WHERE m0_.building_id = 9079 AND m0_.created_at >= '2000-01-01' AND m0_.created_at <= '2026-05-01' AND m0_.debit IN (1, 4) AND m0_.status <> 0 ORDER BY m0_.created_at ASC;

SELECT
  b0_.createdAt AS createdAt_0,
  b0_.value AS value_1,
  b0_.income AS income_2,
  b0_.comment AS comment_3,
  p1_.name AS name_4,
  b0_.is_loan AS is_loan_5
FROM
  bill_payment b0_
  LEFT JOIN partners p1_ ON (b0_.partner_id = p1_.id)
WHERE
  b0_.type = ?
  AND b0_.building_id = ?

SELECT b0_.createdAt AS createdAt_0, b0_.value AS value_1, b0_.income AS income_2, b0_.comment AS comment_3, p1_.name AS name_4, b0_.is_loan AS is_loan_5 FROM bill_payment b0_ LEFT JOIN partners p1_ ON (b0_.partner_id = p1_.id) WHERE b0_.type = 3 AND b0_.building_id = 9079;

SELECT
  m0_.id AS id_0,
  m0_.amount AS amount_1,
  m0_.month AS month_2,
  m0_.created_at AS created_at_3,
  m0_.update_at AS update_at_4,
  m0_.log_creation_date AS log_creation_date_5,
  m0_.debit AS debit_6,
  m0_.comment AS comment_7,
  m0_.monthly_bill AS monthly_bill_8,
  m0_.start_money_data AS start_money_data_9,
  m0_.left_money_data AS left_money_data_10,
  m0_.status AS status_11,
  m0_.over_money AS over_money_12,
  m0_.createdBy AS createdBy_13,
  m0_.month_paid AS month_paid_14,
  m0_.bankFileId AS bankFileId_15,
  m0_.publish_bill AS publish_bill_16,
  m0_.user_id AS user_id_17,
  m0_.building_id AS building_id_18,
  m0_.flat_id AS flat_id_19,
  m0_.processed_flat_id AS processed_flat_id_20
FROM
  money_log m0_
WHERE
  m0_.building_id = ?
  AND m0_.created_at >= ?
  AND m0_.created_at <= ?
  AND m0_.debit IN (1, 4)
  AND m0_.status <> 0
ORDER BY
  m0_.created_at ASC

SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.month AS month_2, m0_.created_at AS created_at_3, m0_.update_at AS update_at_4, m0_.log_creation_date AS log_creation_date_5, m0_.debit AS debit_6, m0_.comment AS comment_7, m0_.monthly_bill AS monthly_bill_8, m0_.start_money_data AS start_money_data_9, m0_.left_money_data AS left_money_data_10, m0_.status AS status_11, m0_.over_money AS over_money_12, m0_.createdBy AS createdBy_13, m0_.month_paid AS month_paid_14, m0_.bankFileId AS bankFileId_15, m0_.publish_bill AS publish_bill_16, m0_.user_id AS user_id_17, m0_.building_id AS building_id_18, m0_.flat_id AS flat_id_19, m0_.processed_flat_id AS processed_flat_id_20 FROM money_log m0_ WHERE m0_.building_id = 9079 AND m0_.created_at >= '2000-01-01' AND m0_.created_at <= '2026-05-01' AND m0_.debit IN (1, 4) AND m0_.status <> 0 ORDER BY m0_.created_at ASC;

SELECT
  b0_.createdAt AS createdAt_0,
  b0_.value AS value_1,
  b0_.income AS income_2,
  b0_.comment AS comment_3,
  p1_.name AS name_4,
  b0_.is_loan AS is_loan_5
FROM
  bill_payment b0_
  LEFT JOIN partners p1_ ON (b0_.partner_id = p1_.id)
WHERE
  b0_.type = ?
  AND b0_.building_id = ?

SELECT b0_.createdAt AS createdAt_0, b0_.value AS value_1, b0_.income AS income_2, b0_.comment AS comment_3, p1_.name AS name_4, b0_.is_loan AS is_loan_5 FROM bill_payment b0_ LEFT JOIN partners p1_ ON (b0_.partner_id = p1_.id) WHERE b0_.type = 4 AND b0_.building_id = 9079;

SELECT
  sum(m0_.amount) AS sclr_0
FROM
  money_log m0_
WHERE
  m0_.building_id = ?
  AND m0_.month >= ?
  AND m0_.month <= ?
  AND m0_.debit IN (?, ?, ?)

SELECT sum(m0_.amount) AS sclr_0 FROM money_log m0_ WHERE m0_.building_id = 9079 AND m0_.month >= '2026-03-01' AND m0_.month <= '2026-03-31' AND m0_.debit IN (0, 2, 3);

SELECT
  m0_.id AS id_0,
  m0_.amount AS amount_1,
  m0_.month AS month_2,
  m0_.created_at AS created_at_3,
  m0_.update_at AS update_at_4,
  m0_.log_creation_date AS log_creation_date_5,
  m0_.debit AS debit_6,
  m0_.comment AS comment_7,
  m0_.monthly_bill AS monthly_bill_8,
  m0_.start_money_data AS start_money_data_9,
  m0_.left_money_data AS left_money_data_10,
  m0_.status AS status_11,
  m0_.over_money AS over_money_12,
  m0_.createdBy AS createdBy_13,
  m0_.month_paid AS month_paid_14,
  m0_.bankFileId AS bankFileId_15,
  m0_.publish_bill AS publish_bill_16,
  m0_.user_id AS user_id_17,
  m0_.building_id AS building_id_18,
  m0_.flat_id AS flat_id_19,
  m0_.processed_flat_id AS processed_flat_id_20
FROM
  money_log m0_
WHERE
  m0_.flat_id = ?
  AND m0_.debit = 1
  AND m0_.publish_bill = 1
ORDER BY
  m0_.month DESC
LIMIT
  4

SELECT m0_.id AS id_0, m0_.amount AS amount_1, m0_.month AS month_2, m0_.created_at AS created_at_3, m0_.update_at AS update_at_4, m0_.log_creation_date AS log_creation_date_5, m0_.debit AS debit_6, m0_.comment AS comment_7, m0_.monthly_bill AS monthly_bill_8, m0_.start_money_data AS start_money_data_9, m0_.left_money_data AS left_money_data_10, m0_.status AS status_11, m0_.over_money AS over_money_12, m0_.createdBy AS createdBy_13, m0_.month_paid AS month_paid_14, m0_.bankFileId AS bankFileId_15, m0_.publish_bill AS publish_bill_16, m0_.user_id AS user_id_17, m0_.building_id AS building_id_18, m0_.flat_id AS flat_id_19, m0_.processed_flat_id AS processed_flat_id_20 FROM money_log m0_ WHERE m0_.flat_id = 211535 AND m0_.debit = 1 AND m0_.publish_bill = 1 ORDER BY m0_.month DESC LIMIT 4;

SELECT
  sum(m0_.amount) AS sclr_0
FROM
  money_log m0_
WHERE
  m0_.flat_id = ?
  AND m0_.created_at >= ?
  AND m0_.created_at <= ?
  AND m0_.debit IN (?, ?)

SELECT sum(m0_.amount) AS sclr_0 FROM money_log m0_ WHERE m0_.flat_id = 211535 AND m0_.created_at >= '1970-01-01' AND m0_.created_at <= '2026-03-26' AND m0_.debit IN (0, 3);

SELECT
  sum(m0_.amount) AS sclr_0
FROM
  money_log m0_
  INNER JOIN bill b1_ ON (
    b1_.building_id = m0_.building_id
  )
WHERE
  m0_.flat_id = ?
  AND m0_.month = b1_.month
  AND b1_.create_bill_date >= ?
  AND b1_.create_bill_date <= ?
  AND m0_.debit IN (?, ?)

SELECT sum(m0_.amount) AS sclr_0 FROM money_log m0_ INNER JOIN bill b1_ ON (b1_.building_id = m0_.building_id) WHERE m0_.flat_id = 211535 AND m0_.month = b1_.month AND b1_.create_bill_date >= '1970-01-01' AND b1_.create_bill_date <= '2026-03-26' AND m0_.debit IN (1, 4);

SELECT
  n0_.id AS id_0,
  n0_.reception_date AS reception_date_1,
  n0_.created_at AS created_at_2,
  n0_.title AS title_3,
  n0_.text AS text_4,
  n0_.status AS status_5,
  n0_.createdBy AS createdBy_6,
  n0_.publish_notification AS publish_notification_7,
  n0_.file AS file_8,
  n0_.file_name AS file_name_9,
  n0_.building_id AS building_id_10,
  n0_.user_id AS user_id_11
FROM
  notification n0_
WHERE
  n0_.building_id = ?
  AND n0_.publish_notification = 1
ORDER BY
  n0_.created_at DESC
LIMIT
  4

SELECT n0_.id AS id_0, n0_.reception_date AS reception_date_1, n0_.created_at AS created_at_2, n0_.title AS title_3, n0_.text AS text_4, n0_.status AS status_5, n0_.createdBy AS createdBy_6, n0_.publish_notification AS publish_notification_7, n0_.file AS file_8, n0_.file_name AS file_name_9, n0_.building_id AS building_id_10, n0_.user_id AS user_id_11 FROM notification n0_ WHERE n0_.building_id = 9079 AND n0_.publish_notification = 1 ORDER BY n0_.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.enabled AS enabled_6,
  t0.paid_bill AS paid_bill_7,
  t0.salt AS salt_8,
  t0.password AS password_9,
  t0.last_login AS last_login_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.roles AS roles_13,
  t0.firstname AS firstname_14,
  t0.lastname AS lastname_15,
  t0.has_accepted_terms AS has_accepted_terms_16,
  t0.address AS address_17,
  t0.streetnumber AS streetnumber_18,
  t0.zip AS zip_19,
  t0.city AS city_20,
  t0.phone_number AS phone_number_21,
  t0.company_name AS company_name_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.mat_id AS mat_id_25,
  t0.pib AS pib_26,
  t0.company_title AS company_title_27,
  t0.license_id AS license_id_28,
  t0.bank_account AS bank_account_29,
  t0.enable_qr AS enable_qr_30,
  t0.task_notification_email AS task_notification_email_31,
  t0.currency AS currency_32,
  t0.main_user_id AS main_user_id_33
FROM
  fos_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.paid_bill AS paid_bill_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.roles AS roles_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.has_accepted_terms AS has_accepted_terms_16, t0.address AS address_17, t0.streetnumber AS streetnumber_18, t0.zip AS zip_19, t0.city AS city_20, t0.phone_number AS phone_number_21, t0.company_name AS company_name_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.mat_id AS mat_id_25, t0.pib AS pib_26, t0.company_title AS company_title_27, t0.license_id AS license_id_28, t0.bank_account AS bank_account_29, t0.enable_qr AS enable_qr_30, t0.task_notification_email AS task_notification_email_31, t0.currency AS currency_32, t0.main_user_id AS main_user_id_33 FROM fos_user t0 WHERE t0.id = 5014;

SELECT
  f0_.id AS id_0,
  f0_.display_flat_id AS display_flat_id_1,
  f0_.size AS size_2,
  f0_.owner_name AS owner_name_3,
  f0_.owner_lastname AS owner_lastname_4,
  f0_.owner_address AS owner_address_5,
  f0_.owner_contact AS owner_contact_6,
  f0_.owner_phone_number AS owner_phone_number_7,
  f0_.rent AS rent_8,
  f0_.debit AS debit_9,
  f0_.previous_bill AS previous_bill_10,
  f0_.type AS type_11,
  f0_.subType AS subType_12,
  f0_.old_debit AS old_debit_13,
  f0_.comment AS comment_14,
  f0_.members AS members_15,
  f0_.created_at AS created_at_16,
  f0_.updated_at AS updated_at_17,
  f0_.company_name AS company_name_18,
  f0_.mat_id AS mat_id_19,
  f0_.pib AS pib_20,
  f0_.owner_email AS owner_email_21,
  f0_.email_can_be_used AS email_can_be_used_22,
  f0_.company_place AS company_place_23,
  f0_.occupant AS occupant_24,
  f0_.occupantEmail AS occupantEmail_25,
  f0_.archived AS archived_26,
  f0_.archived_at AS archived_at_27,
  f0_.bank_account AS bank_account_28,
  f0_.createdBy AS createdBy_29,
  f0_.eInvoice AS eInvoice_30,
  f0_.jbkjs AS jbkjs_31,
  f0_.contract_number AS contract_number_32,
  f0_.order_number AS order_number_33,
  f0_.object_code AS object_code_34,
  f0_.print_bill AS print_bill_35,
  f0_.old_debit_date AS old_debit_date_36,
  f0_.user_id AS user_id_37,
  f0_.building_id AS building_id_38,
  f0_.current_flat AS current_flat_39,
  f0_.resident_id AS resident_id_40
FROM
  flat f0_
WHERE
  f0_.user_id = ?
  AND f0_.building_id = ?
ORDER BY
  f0_.display_flat_id ASC

SELECT f0_.id AS id_0, f0_.display_flat_id AS display_flat_id_1, f0_.size AS size_2, f0_.owner_name AS owner_name_3, f0_.owner_lastname AS owner_lastname_4, f0_.owner_address AS owner_address_5, f0_.owner_contact AS owner_contact_6, f0_.owner_phone_number AS owner_phone_number_7, f0_.rent AS rent_8, f0_.debit AS debit_9, f0_.previous_bill AS previous_bill_10, f0_.type AS type_11, f0_.subType AS subType_12, f0_.old_debit AS old_debit_13, f0_.comment AS comment_14, f0_.members AS members_15, f0_.created_at AS created_at_16, f0_.updated_at AS updated_at_17, f0_.company_name AS company_name_18, f0_.mat_id AS mat_id_19, f0_.pib AS pib_20, f0_.owner_email AS owner_email_21, f0_.email_can_be_used AS email_can_be_used_22, f0_.company_place AS company_place_23, f0_.occupant AS occupant_24, f0_.occupantEmail AS occupantEmail_25, f0_.archived AS archived_26, f0_.archived_at AS archived_at_27, f0_.bank_account AS bank_account_28, f0_.createdBy AS createdBy_29, f0_.eInvoice AS eInvoice_30, f0_.jbkjs AS jbkjs_31, f0_.contract_number AS contract_number_32, f0_.order_number AS order_number_33, f0_.object_code AS object_code_34, f0_.print_bill AS print_bill_35, f0_.old_debit_date AS old_debit_date_36, f0_.user_id AS user_id_37, f0_.building_id AS building_id_38, f0_.current_flat AS current_flat_39, f0_.resident_id AS resident_id_40 FROM flat f0_ WHERE f0_.user_id = 5014 AND f0_.building_id = 9079 ORDER BY f0_.display_flat_id ASC;

SELECT
  sum(m0_.amount) AS sclr_0,
  m0_.debit AS debit_1
FROM
  money_log m0_
  INNER JOIN flat f1_ ON m0_.flat_id = f1_.id
  LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id
WHERE
  m0_.building_id = ?
  AND m0_.user_id = ?
  AND m0_.debit IN (?)
  AND m0_.created_at < ?
GROUP BY
  m0_.debit

SELECT sum(m0_.amount) AS sclr_0, m0_.debit AS debit_1 FROM money_log m0_ INNER JOIN flat f1_ ON m0_.flat_id = f1_.id LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id WHERE m0_.building_id = 9079 AND m0_.user_id = 5014 AND m0_.debit IN (2) AND m0_.created_at < '2026-01-01' GROUP BY m0_.debit;

SELECT
  m0_.amount AS amount_0,
  m0_.created_at AS created_at_1,
  m0_.comment AS comment_2,
  m0_.month AS month_3,
  m0_.debit AS debit_4,
  f1_.display_flat_id AS display_flat_id_5,
  m0_.log_creation_date AS log_creation_date_6,
  m0_.bankFileId AS bankFileId_7,
  f1_.owner_name AS owner_name_8,
  f1_.owner_lastname AS owner_lastname_9,
  f1_.company_name AS company_name_10,
  f1_.archived AS archived_11,
  f1_.type AS type_12,
  f1_.id AS id_13,
  f2_.display_flat_id AS display_flat_id_14
FROM
  money_log m0_
  INNER JOIN flat f1_ ON m0_.flat_id = f1_.id
  LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id
WHERE
  m0_.building_id = ?
  AND m0_.user_id = ?
  AND m0_.debit IN (?, ?)
  AND m0_.created_at < ?

SELECT m0_.amount AS amount_0, m0_.created_at AS created_at_1, m0_.comment AS comment_2, m0_.month AS month_3, m0_.debit AS debit_4, f1_.display_flat_id AS display_flat_id_5, m0_.log_creation_date AS log_creation_date_6, m0_.bankFileId AS bankFileId_7, f1_.owner_name AS owner_name_8, f1_.owner_lastname AS owner_lastname_9, f1_.company_name AS company_name_10, f1_.archived AS archived_11, f1_.type AS type_12, f1_.id AS id_13, f2_.display_flat_id AS display_flat_id_14 FROM money_log m0_ INNER JOIN flat f1_ ON m0_.flat_id = f1_.id LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id WHERE m0_.building_id = 9079 AND m0_.user_id = 5014 AND m0_.debit IN (0, 3) AND m0_.created_at < '2026-01-01';

SELECT
  flat_id,
  log_creation_date
FROM
  money_log
WHERE
  building_id = :building
  and created_at < :date
  AND debit IN (5, 6)

SELECT
                    flat_id, log_creation_date
                FROM money_log
                WHERE
                    building_id = 9079  and created_at < '2026-01-01'  AND debit IN (5,6) ;

SELECT
  m0_.amount AS amount_0,
  m0_.created_at AS created_at_1,
  m0_.comment AS comment_2,
  m0_.month AS month_3,
  m0_.debit AS debit_4,
  f1_.display_flat_id AS display_flat_id_5,
  m0_.log_creation_date AS log_creation_date_6,
  m0_.bankFileId AS bankFileId_7,
  f1_.owner_name AS owner_name_8,
  f1_.owner_lastname AS owner_lastname_9,
  f1_.company_name AS company_name_10,
  f1_.archived AS archived_11,
  f1_.type AS type_12,
  f1_.id AS id_13,
  f2_.display_flat_id AS display_flat_id_14
FROM
  money_log m0_
  INNER JOIN flat f1_ ON m0_.flat_id = f1_.id
  LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id
WHERE
  m0_.building_id = ?
  AND m0_.user_id = ?
  AND m0_.debit IN (?)
  AND m0_.created_at >= ?

SELECT m0_.amount AS amount_0, m0_.created_at AS created_at_1, m0_.comment AS comment_2, m0_.month AS month_3, m0_.debit AS debit_4, f1_.display_flat_id AS display_flat_id_5, m0_.log_creation_date AS log_creation_date_6, m0_.bankFileId AS bankFileId_7, f1_.owner_name AS owner_name_8, f1_.owner_lastname AS owner_lastname_9, f1_.company_name AS company_name_10, f1_.archived AS archived_11, f1_.type AS type_12, f1_.id AS id_13, f2_.display_flat_id AS display_flat_id_14 FROM money_log m0_ INNER JOIN flat f1_ ON m0_.flat_id = f1_.id LEFT JOIN flat f2_ ON f1_.current_flat = f2_.id WHERE m0_.building_id = 9079 AND m0_.user_id = 5014 AND m0_.debit IN (2) AND m0_.created_at >= '2026-01-01';