GET https://cliniqueserena.com/prise-de-rendez-vous?specialite_id=6

Query Metrics

6 Database Queries
5 Different statements
5.06 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.48 ms
(29.22%)
1
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.time_start AS time_start_2, d0_.time_end AS time_end_3, d0_.statut AS statut_4, d0_.duration AS duration_5, d0_.horaire_consultation AS horaire_consultation_6, d0_.opening_type AS opening_type_7, d0_.type AS type_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.is_enabled AS is_enabled_11, d0_.members_direction_id AS members_direction_id_12, d0_.specialite_id AS specialite_id_13 FROM disponibilite d0_ INNER JOIN members_direction m1_ ON d0_.members_direction_id = m1_.id INNER JOIN members_direction_specialite m3_ ON m1_.id = m3_.members_direction_id INNER JOIN specialite s2_ ON s2_.id = m3_.specialite_id WHERE s2_.id = ? AND d0_.date >= ? AND d0_.statut IN (?, ?) AND m1_.is_enabled = 1 AND m1_.member_medecin = 1 AND d0_.is_enabled = 1 AND s2_.as_speciality = 1 ORDER BY d0_.date ASC, d0_.time_start ASC
Parameters:
[
  6
  "2025-08-23 00:00:00"
  "disponible"
  "en cours"
]
1.36 ms
(26.97%)
2
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_enabled AS is_enabled_8, t0.banner_id AS banner_id_9 FROM articles_categories t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
0.95 ms
(18.77%)
1
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.website AS website_2, i0_.created_at AS created_at_3, i0_.description AS description_4, i0_.position AS position_5, i0_.is_enabled AS is_enabled_6, i0_.logo_id AS logo_id_7, i0_.user_id AS user_id_8 FROM insurances i0_ WHERE i0_.is_enabled = 1 ORDER BY i0_.position ASC, i0_.name ASC
Parameters:
[]
0.64 ms
(12.64%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.subdescription AS subdescription_4, t0.details AS details_5, t0.details_description_avantage AS details_description_avantage_6, t0.position AS position_7, t0.is_enabled AS is_enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.slug AS slug_11, t0.banner_id AS banner_id_12, t0.icon_banner_id AS icon_banner_id_13 FROM services t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
0.63 ms
(12.41%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subdescription AS subdescription_3, t0.slug AS slug_4, t0.description AS description_5, t0.details AS details_6, t0.type_video AS type_video_7, t0.as_speciality AS as_speciality_8, t0.as_treatment AS as_treatment_9, t0.as_analysis AS as_analysis_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.is_enabled AS is_enabled_14, t0.banner_id AS banner_id_15, t0.icon_banner_id AS icon_banner_id_16, t0.banner_video_id AS banner_video_id_17, t0.article_id AS article_id_18 FROM specialite t0 WHERE t0.is_enabled = ? AND t0.as_speciality = ?
Parameters:
[
  1
  1
]

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\Article\ArticlesCategories No errors.
App\Entity\File\File No errors.
App\Entity\File\Picture No errors.
App\Entity\Services No errors.
App\Entity\Specialite No errors.
App\Entity\Article\Articles No errors.
App\Entity\RendezVous No errors.
App\Entity\Disponibilite No errors.
App\Entity\MembersDirection
  • The association App\Entity\MembersDirection#specialites refers to the inverse side field App\Entity\Specialite#members which does not exist.
App\Entity\Insurances No errors.
App\Entity\Users No errors.