GET https://staging.troskovi.com/apiV2/residents/flats/235554/bills/9716454

Query Metrics

17 Database Queries
16 Different statements
38.49 ms Query time
0 Invalid entities
45 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.99 ms
(18.18%)
1
"COMMIT"
Parameters:
[]
5.32 ms
(13.82%)
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 = ? LIMIT 1
Parameters:
[
  9716454
]
4.95 ms
(12.87%)
1
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
Parameters:
[]
3.28 ms
(8.53%)
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
Parameters:
[
  5014
  9716454
]
2.78 ms
(7.23%)
1
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 = ?
Parameters:
[
  9079
  "2026-06-01 00:00:00"
]
2.76 ms
(7.16%)
1
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)
Parameters:
[
  5014
]
1.87 ms
(4.86%)
2
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 = ?
Parameters:
[
  9079
  "2026-06-01 00:00:00"
]
1.86 ms
(4.84%)
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 = ? LIMIT 1
Parameters:
[
  "[email protected]"
]
1.55 ms
(4.02%)
1
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "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"
]
1.18 ms
(3.07%)
1
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 = ?
Parameters:
[
  5014
]
1.17 ms
(3.03%)
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_.flat_id = ? AND m0_.month = ? AND m0_.debit = ? ORDER BY m0_.created_at DESC
Parameters:
[
  235554
  "2026-05-01 00:00:00"
  0
]
1.16 ms
(3.00%)
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 = ?
Parameters:
[
  235554
]
1.07 ms
(2.77%)
1
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 = ?
Parameters:
[
  9079
]
0.99 ms
(2.59%)
1
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 = ?
Parameters:
[
  5014
  235554
]
0.95 ms
(2.48%)
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 = ?
Parameters:
[
  9716454
]
0.60 ms
(1.56%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\OptionName 39
App\Entity\Resident 1
App\Entity\Flat 1
App\Entity\User 1
App\Entity\Building 1
App\Entity\MoneyLog 1
App\Entity\Bill 1

Entities Mapping

Class Mapping errors
App\Entity\Resident No errors.
App\Entity\Flat No errors.
App\Entity\User No errors.
App\Entity\Building No errors.
App\Entity\FlatWarning No errors.
App\Entity\PollOption No errors.
App\Entity\MoneyLog No errors.
App\Entity\ProcessedFlats No errors.
App\Entity\Bill No errors.
App\Entity\BillOptions No errors.
App\Entity\Obligation No errors.
App\Entity\ActionLog No errors.
App\Entity\OptionName No errors.
App\Entity\Equipment No errors.
App\Entity\BuildingDictionary No errors.