GET http://rc.liftapp.it/condominium_administrators

Query Metrics

4 Database Queries
4 Different statements
1.88 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = ?
Parameters:
[
  7
]
2 0.52 ms
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.email AS email_4, s0_.roles AS roles_5, s0_.username AS username_6, s0_.password AS password_7, s0_.last_access AS last_access_8 FROM sys_user s0_ WHERE s0_.username = ?
Parameters:
[
  "s.barsanti@ascensoriservizimecherini.it"
]
3 0.38 ms
SELECT c0_.created_at AS created_at_0, c0_.updated_at AS updated_at_1, c0_.deleted_at AS deleted_at_2, c0_.id AS id_3, c0_.role AS role_4, c0_.user_id AS user_id_5, c0_.company_id AS company_id_6 FROM coll_sys_user_sys_company c0_ WHERE c0_.user_id = ?
Parameters:
[
  7
]
4 0.41 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.road AS road_6, t0.house_number AS house_number_7, t0.city AS city_8, t0.cap AS cap_9, t0.province AS province_10, t0.state AS state_11, t0.country AS country_12, t0.company_type AS company_type_13, t0.phone AS phone_14, t0.mail AS mail_15 FROM sys_company t0 WHERE t0.id = ?
Parameters:
[
  3
]

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

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\SysUser
  • The mappings App\Entity\SysUser#sysRoles and App\Entity\CollSysUserSysCompany#user are inconsistent with each other.
App\Entity\CollSysUserSysCompany
  • The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which is not defined as association.
  • The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which does not exist.
App\Entity\SysCompany No errors.
App\Entity\Registry No errors.
App\Entity\SysCompanyAddresses No errors.