GET https://locav.rben.ovh/agency/address/

Query Metrics

6 Database Queries
5 Different statements
4.47 ms Query time
2 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.id AS id_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.is_email_verified AS is_email_verified_9, t0.is_phone_verified AS is_phone_verified_10, t0.email_verification_token AS email_verification_token_11, t0.phone_verification_token AS phone_verification_token_12, t0.status AS status_13, t0.pending_email AS pending_email_14, t0.pending_phone AS pending_phone_15, t0.reference AS reference_16, t0.created_at AS created_at_17, t0.last_name AS last_name_18, t0.first_name AS first_name_19, t0.phone AS phone_20, t0.discriminator_type, t2.name AS name_21, t2.profile_picture AS profile_picture_22, t2.description AS description_23, t2.slug AS slug_24, t2.is_visible AS is_visible_25, t3.agency_id AS agency_id_26 FROM user t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN agency t2 ON t0.id = t2.id LEFT JOIN employee t3 ON t0.id = t3.id LEFT JOIN client t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  "019bd724-370a-7176-94e1-f55468d22e02"
]
2 0.87 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM agency_address a0_ WHERE a0_.agency_id = ?
Parameters:
[
  "019bd724-370a-7176-94e1-f55468d22e02"
]
3 0.39 ms
SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM agency_address a0_ WHERE a0_.agency_id = ? ORDER BY a0_.id DESC LIMIT 10
Parameters:
[
  "019bd724-370a-7176-94e1-f55468d22e02"
]
4 0.82 ms
SELECT a0_.id AS id_0, a0_.addresses AS addresses_1, a0_.city_id AS city_id_2, a0_.agency_id AS agency_id_3 FROM agency_address a0_ WHERE a0_.agency_id = ? AND a0_.id IN (?, ?) ORDER BY a0_.id DESC
Parameters:
[
  "019bd724-370a-7176-94e1-f55468d22e02"
  2
  1
]
5 0.64 ms
SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.92 ms
SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = ?
Parameters:
[
  2
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AgencyAddress 2
App\Entity\City 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Admin No errors.
App\Entity\Agency
  • The association App\Entity\Agency#employees refers to the owning side field App\Entity\Employee#employee which does not exist.
App\Entity\Employee
  • The mappings App\Entity\Employee#agency and App\Entity\Agency#employees are inconsistent with each other.
App\Entity\Client No errors.
App\Entity\UserStatus No errors.
App\Entity\Vehicle No errors.
App\Entity\AgencyAddress No errors.
App\Entity\Review No errors.
App\Entity\City No errors.
App\Entity\Renter No errors.