GET https://cliniqueserena.com/private

Query Metrics

37 Database Queries
12 Different statements
41.22 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.79 ms
(35.89%)
24
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:
[
  28
]
4.36 ms
(10.58%)
1
SELECT t0.id AS id_1, t0.role AS role_2, t0.fName AS fName_3, t0.lName AS lName_4, t0.email AS email_5, t0.createdAt AS createdAt_6, t0.password AS password_7, t0.is_enabled AS is_enabled_8, t0.last_login AS last_login_9, t0.token AS token_10, t0.sex AS sex_11, t0.telephone AS telephone_12, t0.roles AS roles_13, t0.profile_id AS profile_id_14, t15.id AS id_16, t15.code AS code_17, t15.description AS description_18, t0.photo_id AS photo_id_19, t20.id AS id_21, t20.uuid AS uuid_22, t20.user_id AS user_id_23, t0.members_direction_id AS members_direction_id_24 FROM Users t0 LEFT JOIN Profiles t15 ON t0.profile_id = t15.id LEFT JOIN patient t20 ON t20.user_id = t0.id
Parameters:
[]
3.04 ms
(7.37%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM Roles t0 INNER JOIN profiles_roles ON t0.id = profiles_roles.roles_id WHERE profiles_roles.profiles_id = ?
Parameters:
[
  1
]
2.99 ms
(7.25%)
1
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
]
2.92 ms
(7.08%)
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.member_medecin = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
2.17 ms
(5.27%)
1
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:
[]
2.15 ms
(5.21%)
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 = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
2.12 ms
(5.14%)
1
SELECT t0.title AS title_1, t0.description AS description_2, t0.content AS content_3, t0.slug AS slug_4, t0.date AS date_5, t0.is_on_front_page AS is_on_front_page_6, t0.is_visible AS is_visible_7, t0.is_deleted AS is_deleted_8, t0.flickr AS flickr_9, t0.url AS url_10, t0.soundcloud AS soundcloud_11, t0.tags AS tags_12, t0.is_enabled AS is_enabled_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.type_id AS type_id_18, t0.album_id AS album_id_19, t0.biblio_id AS biblio_id_20, t0.user_id AS user_id_21, t0.updated_by_id AS updated_by_id_22, t0.category_id AS category_id_23, t0.specialites_id AS specialites_id_24, t0.banner_id AS banner_id_25, t0.video_id AS video_id_26 FROM articles t0 WHERE t0.is_enabled = ? ORDER BY t0.id DESC LIMIT 4
Parameters:
[
  1
]
1.77 ms
(4.30%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.created_at AS created_at_4, t0.description AS description_5, t0.position AS position_6, t0.is_enabled AS is_enabled_7, t0.logo_id AS logo_id_8, t0.user_id AS user_id_9 FROM insurances t0 WHERE t0.is_enabled = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
1.74 ms
(4.21%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.libelle AS libelle_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_id AS image_id_8, t0.document_id AS document_id_9 FROM data_static t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "about-serena"
]
1.62 ms
(3.93%)
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 ORDER BY t0.position ASC
Parameters:
[]
1.55 ms
(3.76%)
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
]

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\Users No errors.
App\Entity\Profiles No errors.
App\Entity\Patient 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\Roles No errors.
App\Entity\Services No errors.
App\Entity\Specialite No errors.
App\Entity\AboutSerena No errors.
App\Entity\DataStatic No errors.
App\Entity\Article\Articles No errors.
App\Entity\RendezVous No errors.
App\Entity\Disponibilite No errors.
App\Entity\Article\ArticlesTypes No errors.
App\Entity\Article\Albums No errors.
App\Entity\File\Biblios No errors.
App\Entity\Videos No errors.
App\Entity\Insurances No errors.