Query Metrics
50
Database Queries
4
Different statements
25.10 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13.36 ms (53.25%) |
24 |
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 m1_.is_enabled = 1 AND m1_.member_medecin = 1 AND d0_.is_enabled = 1 AND s2_.as_speciality = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
9.02 ms (35.95%) |
23 |
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:
[
52
]
|
||||||||||||||||||||||||||||||
1.62 ms (6.46%) |
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.09 ms (4.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 = ?
Parameters:
[ 1 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\Specialite | No errors. |
App\Entity\Article\Articles | No errors. |
App\Entity\Services | No errors. |
App\Entity\RendezVous | No errors. |
App\Entity\Disponibilite | No errors. |
App\Entity\MembersDirection |
|
App\Entity\Users | No errors. |