GET https://cliniqueserena.com/specialite/imagerie-medicale

Query Metrics

7 Database Queries
6 Different statements
5.63 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.30 ms
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
]
2 0.45 ms
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
]
3 0.55 ms
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.slug = ?
Parameters:
[
  "imagerie-medicale"
]
4 0.58 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.subdescription AS subdescription_2, s0_.slug AS slug_3, s0_.description AS description_4, s0_.details AS details_5, s0_.type_video AS type_video_6, s0_.as_speciality AS as_speciality_7, s0_.as_treatment AS as_treatment_8, s0_.as_analysis AS as_analysis_9, s0_.position AS position_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.is_enabled AS is_enabled_13, s0_.banner_id AS banner_id_14, s0_.icon_banner_id AS icon_banner_id_15, s0_.banner_video_id AS banner_video_id_16, s0_.article_id AS article_id_17 FROM specialite s0_ WHERE s0_.id <> ? AND s0_.as_speciality = ? LIMIT 6
Parameters:
[
  22
  1
]
5 0.91 ms
SELECT m0_.id AS id_0, m0_.civility AS civility_1, m0_.name_person AS name_person_2, m0_.name_poste AS name_poste_3, m0_.name_poste_medecin AS name_poste_medecin_4, m0_.email_direction AS email_direction_5, m0_.serment_year AS serment_year_6, m0_.doctor_private_number AS doctor_private_number_7, m0_.description AS description_8, m0_.position AS position_9, m0_.member_administratif AS member_administratif_10, m0_.member_medecin AS member_medecin_11, m0_.social_tiktok AS social_tiktok_12, m0_.social_instagram AS social_instagram_13, m0_.social_linkedin AS social_linkedin_14, m0_.social_facebook AS social_facebook_15, m0_.slug AS slug_16, m0_.is_enabled AS is_enabled_17, m0_.created_at AS created_at_18, m0_.updated_at AS updated_at_19, m0_.image_id AS image_id_20 FROM members_direction m0_ INNER JOIN members_direction_specialite m2_ ON m0_.id = m2_.members_direction_id INNER JOIN specialite s1_ ON s1_.id = m2_.specialite_id WHERE s1_.id = ? AND m0_.member_medecin = 1 AND s1_.as_speciality = 1
Parameters:
[
  22
]
6 0.93 ms
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 m1_.is_enabled = 1 AND m1_.member_medecin = 1 AND d0_.is_enabled = 1 AND s2_.as_speciality = 1
Parameters:
[
  22
]
7 0.90 ms
SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  32
]

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\Specialite No errors.
App\Entity\Article\Articles No errors.
App\Entity\Services No errors.
App\Entity\RendezVous 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\Disponibilite No errors.
App\Entity\Users No errors.