GET https://cliniqueserena.com/a-propos

Query Metrics

10 Database Queries
7 Different statements
8.41 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.76 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 1.58 ms
SELECT t0.id AS id_1, t0.accroche_title_year AS accroche_title_year_2, t0.title_home AS title_home_3, t0.description_home AS description_home_4, t0.title_question AS title_question_5, t0.description_question AS description_question_6, t0.type_video AS type_video_7, t0.url_video_youtube AS url_video_youtube_8, t0.description_video_home AS description_video_home_9, t0.details_stats AS details_stats_10, t0.details_others AS details_others_11, t0.banner_home_id AS banner_home_id_12, t0.banner_home_question_id AS banner_home_question_id_13, t0.banner_video_home_id AS banner_video_home_id_14, t0.video_id AS video_id_15 FROM about_serena t0
Parameters:
[]
4 0.59 ms
SELECT t0.id AS id_2, t0.target AS target_3, t0.pages AS pages_4, t0.downloads AS downloads_5, t0.reading AS reading_6, t0.name AS name_7, t0.dir AS dir_8, t0.source AS source_9, t0.size AS size_10, t0.is_enabled AS is_enabled_11, t0.is_deleted AS is_deleted_12, t0.last_update AS last_update_13, t0.created_at AS created_at_14, t0.format_size AS format_size_15, t0.mimetype AS mimetype_16, t0.uuid AS uuid_17, t0.view_strategy AS view_strategy_18, t0.created_by_id AS created_by_id_19, t0.type, t1.thumbnail_dir AS thumbnail_dir_20, t1.has_thumbnail AS has_thumbnail_21 FROM FILE t0 LEFT JOIN picture t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
  22
]
5 1.97 ms
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.member_medecin = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
6 0.70 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.is_enabled = ? AND t0.as_speciality = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
7 0.76 ms
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.member_administratif = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
8 0.69 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:
[
  5
]
9 0.47 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:
[
  3
]
10 0.43 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:
[
  4
]

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\AboutSerena No errors.
App\Entity\Users 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\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.