GET http://animalife.ovh/doctors/christine-durand-23

Query Metrics

1 Database Queries
1 Different statements
13.06 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 13.06 ms
SELECT d0_.id AS id_0, d0_.image_path AS image_path_1, d0_.address AS address_2, d0_.clinic_name AS clinic_name_3, d0_.education AS education_4, d0_.is_emergency AS is_emergency_5, d0_.experience AS experience_6, d0_.sex AS sex_7, d0_.name_slug AS name_slug_8, d0_.num_rpps AS num_rpps_9, d0_.num_adeli AS num_adeli_10, d0_.consultation_price AS consultation_price_11, d0_.speciality AS speciality_12, u1_.id AS id_13, u1_.email AS email_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.first_name AS first_name_17, u1_.last_name AS last_name_18, u1_.role_id AS role_id_19, u1_.phone AS phone_20, c2_.id AS id_21, c2_.city_name AS city_name_22, c2_.postcode AS postcode_23, a3_.id AS id_24, a3_.type_name AS type_name_25, s4_.id AS id_26, s4_.service_name AS service_name_27, s4_.description AS description_28, d0_.user_id_id AS user_id_id_29, d0_.city_id_id AS city_id_id_30 FROM doctor d0_ LEFT JOIN user u1_ ON d0_.user_id_id = u1_.id LEFT JOIN city c2_ ON d0_.city_id_id = c2_.id LEFT JOIN doctor_animal_type d5_ ON d0_.id = d5_.doctor_id LEFT JOIN animal_type a3_ ON a3_.id = d5_.animal_type_id LEFT JOIN doctor_service d6_ ON d0_.id = d6_.doctor_id LEFT JOIN service s4_ ON s4_.id = d6_.service_id WHERE d0_.name_slug = ?
Parameters:
[
  "christine-durand-23"
]

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\Doctor
  • The association App\Entity\Doctor#animalTypes refers to the inverse side field App\Entity\AnimalType#education which does not exist.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\AnimalType
  • The mappings App\Entity\AnimalType#doctors and App\Entity\Doctor#animalTypes are inconsistent with each other.
App\Entity\Service No errors.
App\Entity\Consultation No errors.
App\Entity\Animal No errors.
App\Entity\Vaccination No errors.