POST http://rc.liftapp.it/api/implants/get_implant_position

Query Metrics

4 Database Queries
4 Different statements
2.00 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 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.54 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_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?
Parameters:
[
  3
]
3 0.42 ms
SELECT i0_.created_at AS created_at_0, i0_.updated_at AS updated_at_1, i0_.deleted_at AS deleted_at_2, i0_.id AS id_3, i0_.identifier AS identifier_4, i0_.serial_number AS serial_number_5, i0_.name AS name_6, i0_.maintenance_start_date AS maintenance_start_date_7, i0_.road AS road_8, i0_.house_number AS house_number_9, i0_.city AS city_10, i0_.cap AS cap_11, i0_.province AS province_12, i0_.longitude AS longitude_13, i0_.latitude AS latitude_14, i0_.radius AS radius_15, i0_.state AS state_16, i0_.company_id AS company_id_17, i0_.building_manager_id AS building_manager_id_18, i0_.condominium_id AS condominium_id_19, i0_.invoice_to_id AS invoice_to_id_20 FROM implant i0_ WHERE i0_.company_id = ? AND i0_.deleted_at IS NULL AND i0_.id = ?
Parameters:
[
  3
  401
]
4 0.51 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.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.company_id AS company_id_18, t0.type, t0.notes AS notes_19 FROM registry t0 WHERE t0.id = ? AND t0.type IN ('0', '1', '2', '3', '4', '5')
Parameters:
[
  556
]

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\Implant
  • The field App\Entity\Implant#jobs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Job#implant does not contain the required 'inversedBy="jobs"' attribute.
App\Entity\SysCompany No errors.
App\Entity\Registry No errors.
App\Entity\SysCompanyAddresses No errors.
App\Entity\CondominiumAdministrator No errors.
App\Entity\Condominium No errors.
App\Entity\Customer No errors.
App\Entity\Employee No errors.
App\Entity\Supplier
  • The field App\Entity\Supplier#jobMaterials is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollJobMaterial#supplier does not contain the required 'inversedBy="jobMaterials"' attribute.
  • The field App\Entity\Supplier#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#supplier does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Job No errors.