Query Metrics

2 Database Queries
2 Different statements
7.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.99 ms
(50.56%)
1
SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.paid AS paid_4, t0.created AS created_5, t0.client_id AS client_id_6, t7.city AS city_8, t7.street AS street_9, t7.house AS house_10, t7.apartment AS apartment_11, t7.contract_id AS contract_id_12, t0.commutator_id AS commutator_id_13 FROM contract t0 LEFT JOIN contract_location t7 ON t7.contract_id = t0.id WHERE t0.number = ? LIMIT 1
Parameters:
[
  "02290"
]
3.90 ms
(49.44%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.amount AS amount_6, t7.name AS name_8, t7.surname AS surname_9, t7.patronymic AS patronymic_10, t7.value AS value_11, t7.number AS number_12, t7.issued AS issued_13, t7.department AS department_14, t7.client_id AS client_id_15 FROM client t0 LEFT JOIN client_identification t7 ON t7.client_id = t0.id WHERE t0.id = ?
Parameters:
[
  b"\x01ˆ\x0ECmy½7ŽÅ«>¬<ï\x01"
]

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.