GET https://cliniqueserena.com/medecin/hounkpe-melome

Query Metrics

5 Database Queries
4 Different statements
5.66 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.34 ms
(41.27%)
1
SELECT t0.id AS id_1, t0.civility AS civility_2, t0.name_person AS name_person_3, t0.name_poste AS name_poste_4, t0.name_poste_medecin AS name_poste_medecin_5, t0.email_direction AS email_direction_6, t0.serment_year AS serment_year_7, t0.doctor_private_number AS doctor_private_number_8, t0.description AS description_9, t0.position AS position_10, t0.member_administratif AS member_administratif_11, t0.member_medecin AS member_medecin_12, t0.social_tiktok AS social_tiktok_13, t0.social_instagram AS social_instagram_14, t0.social_linkedin AS social_linkedin_15, t0.social_facebook AS social_facebook_16, t0.slug AS slug_17, t0.is_enabled AS is_enabled_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.image_id AS image_id_21, t22.id AS id_23, t22.role AS role_24, t22.fName AS fName_25, t22.lName AS lName_26, t22.email AS email_27, t22.createdAt AS createdAt_28, t22.password AS password_29, t22.is_enabled AS is_enabled_30, t22.last_login AS last_login_31, t22.token AS token_32, t22.sex AS sex_33, t22.telephone AS telephone_34, t22.roles AS roles_35, t22.profile_id AS profile_id_36, t22.photo_id AS photo_id_37, t22.members_direction_id AS members_direction_id_38 FROM members_direction t0 LEFT JOIN Users t22 ON t22.members_direction_id = t0.id WHERE t0.slug = ?
Parameters:
[
  "hounkpe-melome"
]
1.47 ms
(26.05%)
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
]
1.10 ms
(19.36%)
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 INNER JOIN members_direction_specialite ON t0.id = members_direction_specialite.specialite_id WHERE members_direction_specialite.members_direction_id = ?
Parameters:
[
  18
]
0.75 ms
(13.32%)
1
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_ LEFT JOIN members_direction_specialite m2_ ON m0_.id = m2_.members_direction_id LEFT JOIN specialite s1_ ON s1_.id = m2_.specialite_id WHERE s1_.id IN (?) AND m0_.member_medecin = 1 LIMIT 4
Parameters:
[
  7
]

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