Symfony Profiler

"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
  INNER JOIN poll_options_flats ON t0.id = poll_options_flats.flat_id
WHERE
  poll_options_flats.poll_option_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 INNER JOIN poll_options_flats ON t0.id = poll_options_flats.flat_id WHERE poll_options_flats.poll_option_id = 733;

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
  2

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 = 8022 AND n0_.publish_notification = 1 ORDER BY n0_.created_at DESC LIMIT 2;

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

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.creator AS creator_3,
  p0_.endsAt AS endsAt_4,
  p0_.startsAt AS startsAt_5,
  p0_.createdAt AS createdAt_6,
  p0_.updateAt AS updateAt_7,
  p0_.file AS file_8,
  p0_.file_name AS file_name_9,
  p0_.building_id AS building_id_10
FROM
  poll p0_
WHERE
  p0_.building_id = ?
  AND p0_.endsAt > ?
ORDER BY
  p0_.createdAt DESC
LIMIT
  2

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.creator AS creator_3, p0_.endsAt AS endsAt_4, p0_.startsAt AS startsAt_5, p0_.createdAt AS createdAt_6, p0_.updateAt AS updateAt_7, p0_.file AS file_8, p0_.file_name AS file_name_9, p0_.building_id AS building_id_10 FROM poll p0_ WHERE p0_.building_id = 8022 AND p0_.endsAt > '2025-03-14 14:02:12' ORDER BY p0_.createdAt DESC LIMIT 2;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.poll_id AS poll_id_3
FROM
  poll_option t0
WHERE
  t0.poll_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.poll_id AS poll_id_3 FROM poll_option t0 WHERE t0.poll_id = 356;

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/flats/186504/dashboard/', 'A', NULL, '2025-03-14 14:02:12', '2025-03-14 14:02:12', NULL);

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

"START TRANSACTION"

"START TRANSACTION";

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;