Query Metrics
10
Database Queries
7
Different statements
8.41 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1.97 ms (23.45%) |
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
]
|
||||||||||||||||||||||||||||||
1.59 ms (18.95%) |
3 |
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
]
|
||||||||||||||||||||||||||||||
1.58 ms (18.83%) |
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:
[]
|
||||||||||||||||||||||||||||||
1.21 ms (14.38%) |
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.76 ms (9.06%) |
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_administratif = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.70 ms (8.33%) |
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 ]
|
||||||||||||||||||||||||||||||
0.59 ms (7.00%) |
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
]
|
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 |
|
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. |