Query Metrics
6
Database Queries
5
Different statements
7.85 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4.50 ms (57.35%) |
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 = ?
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||||
1.39 ms (17.71%) |
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.82 ms (10.46%) |
1 |
SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.time_start AS time_start_2, d0_.time_end AS time_end_3, d0_.statut AS statut_4, d0_.duration AS duration_5, d0_.horaire_consultation AS horaire_consultation_6, d0_.opening_type AS opening_type_7, d0_.type AS type_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.is_enabled AS is_enabled_11, m1_.id AS id_12, m1_.civility AS civility_13, m1_.name_person AS name_person_14, m1_.name_poste AS name_poste_15, m1_.name_poste_medecin AS name_poste_medecin_16, m1_.email_direction AS email_direction_17, m1_.serment_year AS serment_year_18, m1_.doctor_private_number AS doctor_private_number_19, m1_.description AS description_20, m1_.position AS position_21, m1_.member_administratif AS member_administratif_22, m1_.member_medecin AS member_medecin_23, m1_.social_tiktok AS social_tiktok_24, m1_.social_instagram AS social_instagram_25, m1_.social_linkedin AS social_linkedin_26, m1_.social_facebook AS social_facebook_27, m1_.slug AS slug_28, m1_.is_enabled AS is_enabled_29, m1_.created_at AS created_at_30, m1_.updated_at AS updated_at_31, d0_.members_direction_id AS members_direction_id_32, d0_.specialite_id AS specialite_id_33, m1_.image_id AS image_id_34 FROM disponibilite d0_ INNER JOIN members_direction m1_ ON d0_.members_direction_id = m1_.id WHERE d0_.date >= ? AND d0_.statut IN (?, ?) AND m1_.is_enabled = 1 AND m1_.member_medecin = 1 AND d0_.is_enabled = 1 ORDER BY d0_.date ASC, d0_.time_start ASC
Parameters:
[ "2025-08-23 04:45:14" "disponible" "en cours" ]
|
||||||||||||||||||||||||||||||
0.66 ms (8.44%) |
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 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.47 ms (6.04%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.website AS website_2, i0_.created_at AS created_at_3, i0_.description AS description_4, i0_.position AS position_5, i0_.is_enabled AS is_enabled_6, i0_.logo_id AS logo_id_7, i0_.user_id AS user_id_8 FROM insurances i0_ WHERE i0_.is_enabled = 1 ORDER BY i0_.position ASC, i0_.name ASC
Parameters:
[]
|
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\Services | No errors. |
App\Entity\Specialite | No errors. |
App\Entity\Article\Articles | No errors. |
App\Entity\RendezVous | No errors. |
App\Entity\Disponibilite | No errors. |
App\Entity\MembersDirection |
|
App\Entity\Insurances | No errors. |
App\Entity\Users | No errors. |