Query Metrics
5
Database Queries
3
Different statements
2.47 ms
Query time
1
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.63 ms |
SELECT t0.id AS id_1, t0.date_entered AS date_entered_2, t0.value AS value_3, t0.value2 AS value2_4, t0.value3 AS value3_5, t0.status AS status_6, t0.personal_id AS personal_id_7 FROM app_counter_reading t0 WHERE t0.status = ?
Parameters:
[
"new"
]
|
2 | 0.46 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.name AS name_3, t0.number_of_scale AS number_of_scale_4, t0.active AS active_5, t0.full_address AS full_address_6, t0.city AS city_7, t0.street AS street_8, t0.building AS building_9, t0.room AS room_10, t0.main_full_address AS main_full_address_11, t0.type AS type_12, t0.date_entered AS date_entered_13, t0.is_main AS is_main_14, t0.eic AS eic_15, t0.counter AS counter_16, t0.is_show AS is_show_17, t0.owner_id AS owner_id_18, t0.accounts_id AS accounts_id_19, t0.parent_id AS parent_id_20 FROM app_personal_account t0 WHERE t0.id = ?
Parameters:
[
286
]
|
3 | 0.44 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.work_schedule AS work_schedule_11, t0.telegram AS telegram_12, t0.viber AS viber_13, t0.hash_date AS hash_date_14, t0.device_id AS device_id_15, t0.active_code AS active_code_16, t0.deleted AS deleted_17, t0.debug AS debug_18, t0.dev AS dev_19, t0.date_entered AS date_entered_20, t0.manager_id AS manager_id_21 FROM users t0 WHERE t0.id = ?
Parameters:
[
199
]
|
4 | 0.70 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.name AS name_3, t0.number_of_scale AS number_of_scale_4, t0.active AS active_5, t0.full_address AS full_address_6, t0.city AS city_7, t0.street AS street_8, t0.building AS building_9, t0.room AS room_10, t0.main_full_address AS main_full_address_11, t0.type AS type_12, t0.date_entered AS date_entered_13, t0.is_main AS is_main_14, t0.eic AS eic_15, t0.counter AS counter_16, t0.is_show AS is_show_17, t0.owner_id AS owner_id_18, t0.accounts_id AS accounts_id_19, t0.parent_id AS parent_id_20 FROM app_personal_account t0 WHERE t0.id = ?
Parameters:
[
92
]
|
5 | 0.24 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.work_schedule AS work_schedule_11, t0.telegram AS telegram_12, t0.viber AS viber_13, t0.hash_date AS hash_date_14, t0.device_id AS device_id_15, t0.active_code AS active_code_16, t0.deleted AS deleted_17, t0.debug AS debug_18, t0.dev AS dev_19, t0.date_entered AS date_entered_20, t0.manager_id AS manager_id_21 FROM users t0 WHERE t0.id = ?
Parameters:
[
34
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
loe | doctrine.dbal.loe_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
loe | doctrine.orm.loe_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\AppCounterReading | No errors. |
App\Entity\AppPersonalAccount | No errors. |
App\Entity\User |
|
App\Entity\Accounts | No errors. |
App\Entity\ServiceOrderHistory | No errors. |
App\Entity\MediaObject | No errors. |
App\Entity\UserToken | No errors. |
App\Entity\Notification | No errors. |
loe entity manager
No loaded entities.