Query Metrics
6
Database Queries
5
Different statements
4.44 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1.26 ms (28.38%) |
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, d0_.members_direction_id AS members_direction_id_12, d0_.specialite_id AS specialite_id_13 FROM disponibilite d0_ INNER JOIN members_direction m1_ ON d0_.members_direction_id = m1_.id INNER JOIN members_direction_specialite m3_ ON m1_.id = m3_.members_direction_id INNER JOIN specialite s2_ ON s2_.id = m3_.specialite_id WHERE s2_.id = ? AND d0_.date >= ? AND d0_.statut IN (?, ?) AND m1_.is_enabled = 1 AND m1_.member_medecin = 1 AND d0_.is_enabled = 1 AND s2_.as_speciality = 1 ORDER BY d0_.date ASC, d0_.time_start ASC
Parameters:
[ 5 "2025-08-23 00:00:00" "disponible" "en cours" ]
|
||||||||||||||||||||||||||||||
1.15 ms (25.94%) |
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.77 ms (17.42%) |
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.67 ms (15.01%) |
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 ]
|
||||||||||||||||||||||||||||||
0.59 ms (13.25%) |
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. |