GET http://drarnoldstrasbourg.fr/

Query Metrics

10 Database Queries
10 Different statements
8.72 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet t0 WHERE t0.master = ? LIMIT 1
Parameters:
[
  1
]
2 1.43 ms
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.title AS title_5, t0.position AS position_6, t0.icon AS icon_7, t0.field_type AS field_type_8, t0.cabinet_id AS cabinet_id_9 FROM cabinet_website t0 WHERE t0.cabinet_id = ?
Parameters:
[
  7
]
3 1.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.cabinet_id AS cabinet_id_4 FROM cabinet_config t0 WHERE t0.cabinet_id = ? AND t0.name = ? LIMIT 1
Parameters:
[
  7
  "theme"
]
4 0.45 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.image_name AS image_name_3, t0.uploaded_at AS uploaded_at_4, t0.cabinet_id AS cabinet_id_5 FROM cabinet_image t0 WHERE t0.cabinet_id = ?
Parameters:
[
  7
]
5 1.81 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.diplomas AS diplomas_6, t0.refund AS refund_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.mail AS mail_12, t10.mobile AS mobile_13, t10.create_date AS create_date_14, t10.archive_date AS archive_date_15, t10.last_login_date AS last_login_date_16, t10.status AS status_17, t10.slug AS slug_18, t10.roles AS roles_19, t10.password AS password_20, t10.is_verified AS is_verified_21, t10.firstname AS firstname_22, t10.lastname AS lastname_23, t10.patient_id AS patient_id_24, t10.medecin_id AS medecin_id_25 FROM medecin t0 LEFT JOIN `user` t10 ON t10.medecin_id = t0.id INNER JOIN cabinet_medecin ON t0.id = cabinet_medecin.medecin_id WHERE cabinet_medecin.cabinet_id = ?
Parameters:
[
  7
]
6 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.medecin_id AS medecin_id_6, t0.user_id AS user_id_7 FROM medecin_substitute t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
7 0.43 ms
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.position AS position_5, t0.icon AS icon_6, t0.title AS title_7, t0.field_type AS field_type_8, t0.medecin_id AS medecin_id_9 FROM medecin_website t0 WHERE t0.medecin_id = ?
Parameters:
[
  6
]
8 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.message_type AS message_type_3, t0.value AS value_4, t0.value_txt AS value_txt_5, t0.medecin_id AS medecin_id_6 FROM medecin_config t0 WHERE t0.medecin_id = ?
Parameters:
[
  6
]
9 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.cabinet_id AS cabinet_id_4 FROM cabinet_config t0 WHERE t0.cabinet_id = ? AND t0.name = ?
Parameters:
[
  7
  "widget"
]
10 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet t0
Parameters:
[]

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\Cabinet No errors.
App\Entity\Medecin No errors.
App\Entity\MedecinSpecialities
  • The field App\Entity\MedecinSpecialities#consultationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ConsultationType#medecinSpecialities does not contain the required 'inversedBy="consultationTypes"' attribute.
App\Entity\CabinetWebsite No errors.
App\Entity\CabinetConfig No errors.
App\Entity\CabinetImage No errors.
App\Entity\Consultation No errors.
App\Entity\ContactForm No errors.
App\Entity\UserAccess No errors.
App\Entity\MedecinUserAccess No errors.
App\Entity\User No errors.
App\Entity\MedecinWebsite No errors.
App\Entity\MedecinConfig No errors.
App\Entity\CalendarHoliday No errors.
App\Entity\MedecinSubstitute No errors.
App\Entity\TodoList No errors.
App\Entity\Specialities No errors.
App\Entity\ConsultationType No errors.
App\Entity\CalendarTimeSlot No errors.
App\Entity\CalendarModelTimeSlot No errors.
App\Entity\Patient No errors.
App\Entity\CancelReason No errors.
App\Entity\InternalMessage No errors.
App\Entity\ConsultationNotifHistory No errors.
App\Entity\MedecinSubstituteCalendarSlot No errors.
App\Entity\ConsultationInformations No errors.
App\Entity\PatientUserAccess No errors.
App\Entity\CalendarModel No errors.
App\Entity\UserConfig No errors.
App\Entity\CalendarModelRepeat No errors.
App\Entity\ConsultationInformationsConfiguration No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\UserSubscription No errors.
App\Entity\CalendarModelHolidaySlot No errors.
App\Entity\ShortUrl No errors.
App\Entity\PatientImported No errors.
Vich\UploaderBundle\Entity\File No errors.