https://api-app.de-svitlo.com.ua/api/cron-set-meter-readings

Query Metrics

5 Database Queries
3 Different statements
2.47 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.16 ms
(46.94%)
2
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
]
0.68 ms
(27.71%)
2
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
]
0.63 ms
(25.35%)
1
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"
]

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
  • The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which is not defined as association.
  • The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which does not exist.
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.