PATCH http://cabinet.shuvar.com/api/agreementss/4835

Query Metrics

6 Database Queries
6 Different statements
9.28 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.00 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.is_valid AS is_valid_3, t0.comment AS comment_4, t0.created_by_id AS created_by_id_5 FROM access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "2022bf679d79514716319b89016639c622986efc7716f6bf4865bd0553d6656b"
]
2 1.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.birthdate AS birthdate_5, t0.ipn AS ipn_6, t0.phone AS phone_7, t0.erdpou AS erdpou_8, t0.site AS site_9, t0.address_legal AS address_legal_10, t0.address_actual AS address_actual_11, t0.work_start_date AS work_start_date_12, t0.uuid AS uuid_13, t0.type AS type_14, t0.active AS active_15, t0.plain_password AS plain_password_16, t0.full_name AS full_name_17, t0.direction AS direction_18, t0.balance AS balance_19, t0.last_login AS last_login_20, t0.login_count AS login_count_21 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "y.kozlov08@gmail.com"
]
4 4.00 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.uuid AS uuid_2, a0_.description AS description_3, a0_.deleted AS deleted_4, a0_.code AS code_5, a0_.number AS number_6, a0_.type AS type_7, a0_.orenda AS orenda_8, a0_.date_from AS date_from_9, a0_.date_to AS date_to_10, a0_.balance AS balance_11, a0_.status AS status_12, u1_.id AS id_13, u1_.email AS email_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.birthdate AS birthdate_17, u1_.ipn AS ipn_18, u1_.phone AS phone_19, u1_.erdpou AS erdpou_20, u1_.site AS site_21, u1_.address_legal AS address_legal_22, u1_.address_actual AS address_actual_23, u1_.work_start_date AS work_start_date_24, u1_.uuid AS uuid_25, u1_.type AS type_26, u1_.active AS active_27, u1_.plain_password AS plain_password_28, u1_.full_name AS full_name_29, u1_.direction AS direction_30, u1_.balance AS balance_31, u1_.last_login AS last_login_32, u1_.login_count AS login_count_33, t2_.id AS id_34, t2_.title AS title_35, t2_.uuid AS uuid_36, t2_.deleted AS deleted_37, t2_.code AS code_38, t2_.description AS description_39, t2_.area AS area_40, t2_.heat_area AS heat_area_41, t2_.cold_area AS cold_area_42, t2_.frost_area AS frost_area_43, t2_.area_garbage AS area_garbage_44, t2_.area_cleaning AS area_cleaning_45, t2_.area_outdoor_lighting AS area_outdoor_lighting_46, o3_.id AS id_47, o3_.title AS title_48, o3_.code AS code_49, o3_.current_account AS current_account_50, o3_.bank AS bank_51, o3_.adress AS adress_52, o3_.ipn AS ipn_53, o3_.certificate_number AS certificate_number_54, o3_.uuid AS uuid_55, i4_.id AS id_56, i4_.title AS title_57, i4_.uuid AS uuid_58, i4_.number AS number_59, i4_.date AS date_60, i4_.sum AS sum_61, a0_.user_id_id AS user_id_id_62, a0_.trading_points_id AS trading_points_id_63, a0_.organisation_id AS organisation_id_64, t2_.sub_zone_id AS sub_zone_id_65, i4_.invoice_group_id AS invoice_group_id_66, i4_.agreement_id_id AS agreement_id_id_67 FROM agreements a0_ LEFT JOIN "user" u1_ ON a0_.user_id_id = u1_.id LEFT JOIN trading_points t2_ ON a0_.trading_points_id = t2_.id LEFT JOIN organizations o3_ ON a0_.organisation_id = o3_.id LEFT JOIN invoice i4_ ON a0_.id = i4_.agreement_id_id WHERE a0_.id = ?
Parameters:
[
  4835
]
5 0.67 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.uuid AS uuid_3, t0.description AS description_4, t0.deleted AS deleted_5, t0.code AS code_6, t0.number AS number_7, t0.type AS type_8, t0.orenda AS orenda_9, t0.date_from AS date_from_10, t0.date_to AS date_to_11, t0.balance AS balance_12, t0.status AS status_13, t0.user_id_id AS user_id_id_14, t0.trading_points_id AS trading_points_id_15, t0.organisation_id AS organisation_id_16 FROM agreements t0 WHERE t0.id = ?
Parameters:
[
  4835
]
6 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.uuid AS uuid_3, t0.number AS number_4, t0.date AS date_5, t0.sum AS sum_6, t0.invoice_group_id AS invoice_group_id_7, t0.agreement_id_id AS agreement_id_id_8 FROM invoice t0 WHERE t0.agreement_id_id = ?
Parameters:
[
  4835
]

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.

Entities Mapping