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 messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:26:\\\"App\\\\Message\\\\StoreActionLog\\\":5:{s:34:\\\"\\0App\\\\Message\\\\StoreActionLog\\0userId\\\";N;s:34:\\\"\\0App\\\\Message\\\\StoreActionLog\\0method\\\";s:3:\\\"GET\\\";s:34:\\\"\\0App\\\\Message\\\\StoreActionLog\\0action\\\";s:43:\\\"/apiV2/residents/flats/235554/bills/9716454\\\";s:44:\\\"\\0App\\\\Message\\\\StoreActionLog\\0controllerAction\\\";s:61:\\\"App\\\\Controller\\\\ApiV2\\\\Residents\\\\BillController::getFlatBillPdf\\\";s:32:\\\"\\0App\\\\Message\\\\StoreActionLog\\0body\\\";N;}}', '[]', 'async-action-log', '2026-07-02 12:03:16', '2026-07-02 12:03:16');

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

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

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.month AS month_3,
  t0.created_at AS created_at_4,
  t0.update_at AS update_at_5,
  t0.log_creation_date AS log_creation_date_6,
  t0.debit AS debit_7,
  t0.comment AS comment_8,
  t0.monthly_bill AS monthly_bill_9,
  t0.start_money_data AS start_money_data_10,
  t0.left_money_data AS left_money_data_11,
  t0.status AS status_12,
  t0.over_money AS over_money_13,
  t0.createdBy AS createdBy_14,
  t0.month_paid AS month_paid_15,
  t0.bankFileId AS bankFileId_16,
  t0.publish_bill AS publish_bill_17,
  t0.user_id AS user_id_18,
  t0.building_id AS building_id_19,
  t0.flat_id AS flat_id_20,
  t0.processed_flat_id AS processed_flat_id_21
FROM
  money_log t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.month AS month_3, t0.created_at AS created_at_4, t0.update_at AS update_at_5, t0.log_creation_date AS log_creation_date_6, t0.debit AS debit_7, t0.comment AS comment_8, t0.monthly_bill AS monthly_bill_9, t0.start_money_data AS start_money_data_10, t0.left_money_data AS left_money_data_11, t0.status AS status_12, t0.over_money AS over_money_13, t0.createdBy AS createdBy_14, t0.month_paid AS month_paid_15, t0.bankFileId AS bankFileId_16, t0.publish_bill AS publish_bill_17, t0.user_id AS user_id_18, t0.building_id AS building_id_19, t0.flat_id AS flat_id_20, t0.processed_flat_id AS processed_flat_id_21 FROM money_log t0 WHERE t0.id = 9716454;

SELECT
  b0_.id AS id_0,
  b0_.month AS month_1,
  b0_.title AS title_2,
  b0_.note AS note_3,
  b0_.created_at AS created_at_4,
  b0_.update_at AS update_at_5,
  b0_.create_bill_date AS create_bill_date_6,
  b0_.due_date AS due_date_7,
  b0_.status AS status_8,
  b0_.createdBy AS createdBy_9,
  b0_.end_date_to_show_bills AS end_date_to_show_bills_10,
  b0_.short_message AS short_message_11,
  b0_.email_message AS email_message_12,
  b0_.building_id AS building_id_13
FROM
  bill b0_
WHERE
  b0_.building_id = ?
  AND b0_.month = ?

SELECT b0_.id AS id_0, b0_.month AS month_1, b0_.title AS title_2, b0_.note AS note_3, b0_.created_at AS created_at_4, b0_.update_at AS update_at_5, b0_.create_bill_date AS create_bill_date_6, b0_.due_date AS due_date_7, b0_.status AS status_8, b0_.createdBy AS createdBy_9, b0_.end_date_to_show_bills AS end_date_to_show_bills_10, b0_.short_message AS short_message_11, b0_.email_message AS email_message_12, b0_.building_id AS building_id_13 FROM bill b0_ WHERE b0_.building_id = 9079 AND b0_.month = '2026-06-01 00:00:00';

SELECT
  b0_.id AS id_0,
  b0_.month AS month_1,
  b0_.title AS title_2,
  b0_.note AS note_3,
  b0_.created_at AS created_at_4,
  b0_.update_at AS update_at_5,
  b0_.create_bill_date AS create_bill_date_6,
  b0_.due_date AS due_date_7,
  b0_.status AS status_8,
  b0_.createdBy AS createdBy_9,
  b0_.end_date_to_show_bills AS end_date_to_show_bills_10,
  b0_.short_message AS short_message_11,
  b0_.email_message AS email_message_12,
  b0_.building_id AS building_id_13
FROM
  bill b0_
WHERE
  b0_.building_id = ?
  AND b0_.month = ?

SELECT b0_.id AS id_0, b0_.month AS month_1, b0_.title AS title_2, b0_.note AS note_3, b0_.created_at AS created_at_4, b0_.update_at AS update_at_5, b0_.create_bill_date AS create_bill_date_6, b0_.due_date AS due_date_7, b0_.status AS status_8, b0_.createdBy AS createdBy_9, b0_.end_date_to_show_bills AS end_date_to_show_bills_10, b0_.short_message AS short_message_11, b0_.email_message AS email_message_12, b0_.building_id AS building_id_13 FROM bill b0_ WHERE b0_.building_id = 9079 AND b0_.month = '2026-05-01 00:00:00';

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_.month = ?
  AND m0_.debit = ?
ORDER BY
  m0_.created_at DESC

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 = 235554 AND m0_.month = '2026-05-01 00:00:00' AND m0_.debit = 0 ORDER BY m0_.created_at DESC;

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_.id = ?

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_.id = 235554;

SELECT
  b0_.name AS name_0,
  b0_.value AS value_1
FROM
  bill_options b0_
  INNER JOIN bill b1_ ON b0_.bill_id = b1_.id
WHERE
  b1_.building_id = ?
  AND b1_.month = ?

SELECT b0_.name AS name_0, b0_.value AS value_1 FROM bill_options b0_ INNER JOIN bill b1_ ON b0_.bill_id = b1_.id WHERE b1_.building_id = 9079 AND b1_.month = '2026-06-01 00:00:00';

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
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.month AS month_3,
  t0.created_at AS created_at_4,
  t0.update_at AS update_at_5,
  t0.log_creation_date AS log_creation_date_6,
  t0.debit AS debit_7,
  t0.comment AS comment_8,
  t0.monthly_bill AS monthly_bill_9,
  t0.start_money_data AS start_money_data_10,
  t0.left_money_data AS left_money_data_11,
  t0.status AS status_12,
  t0.over_money AS over_money_13,
  t0.createdBy AS createdBy_14,
  t0.month_paid AS month_paid_15,
  t0.bankFileId AS bankFileId_16,
  t0.publish_bill AS publish_bill_17,
  t0.user_id AS user_id_18,
  t0.building_id AS building_id_19,
  t0.flat_id AS flat_id_20,
  t0.processed_flat_id AS processed_flat_id_21
FROM
  money_log t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.month AS month_3, t0.created_at AS created_at_4, t0.update_at AS update_at_5, t0.log_creation_date AS log_creation_date_6, t0.debit AS debit_7, t0.comment AS comment_8, t0.monthly_bill AS monthly_bill_9, t0.start_money_data AS start_money_data_10, t0.left_money_data AS left_money_data_11, t0.status AS status_12, t0.over_money AS over_money_13, t0.createdBy AS createdBy_14, t0.month_paid AS month_paid_15, t0.bankFileId AS bankFileId_16, t0.publish_bill AS publish_bill_17, t0.user_id AS user_id_18, t0.building_id AS building_id_19, t0.flat_id AS flat_id_20, t0.processed_flat_id AS processed_flat_id_21 FROM money_log t0 WHERE t0.id = 9716454 LIMIT 1;

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_.user_id = ?
  AND m0_.id = ?
ORDER BY
  m0_.created_at DESC

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_.user_id = 5014 AND m0_.id = 9716454 ORDER BY m0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.user_id AS user_id_3,
  t0.additional_users AS additional_users_4,
  t0.type AS type_5
FROM
  option_name t0
WHERE
  (
    t0.user_id IN (?)
    OR t0.user_id IS NULL
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.user_id AS user_id_3, t0.additional_users AS additional_users_4, t0.type AS type_5 FROM option_name t0 WHERE (t0.user_id IN (5014) OR t0.user_id IS NULL);

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.user_id AS user_id_2,
  o0_.additional_users AS additional_users_3,
  o0_.type AS type_4
FROM
  option_name o0_
WHERE
  o0_.additional_users LIKE '%,5014,%'
  OR o0_.additional_users LIKE '5014,%'
  OR o0_.additional_users LIKE '%,5014'
  OR o0_.additional_users = 5014

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.user_id AS user_id_2, o0_.additional_users AS additional_users_3, o0_.type AS type_4 FROM option_name o0_ WHERE o0_.additional_users LIKE '%,5014,%' OR o0_.additional_users LIKE '5014,%' OR o0_.additional_users LIKE '%,5014' OR o0_.additional_users = 5014;

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;