Query Metrics
8
Database Queries
5
Different statements
7.48 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2.85 ms (38.15%) |
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.88 ms (25.17%) |
3 |
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 WHERE t0.members_direction_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||
0.97 ms (12.96%) |
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:
[
3
]
|
||||||||||||||||||||||||||||||
0.96 ms (12.88%) |
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:
[
"gbenou-ghislaine"
]
|
||||||||||||||||||||||||||||||
0.81 ms (10.85%) |
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:
[
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 |
|
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. |
App\Entity\Patient | No errors. |