Query Metrics
16
Database Queries
14
Different statements
32.64 ms
Query time
0
Invalid entities
59
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 19.89 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.job_title AS job_title_7, t0.phone AS phone_8, t0.avatar AS avatar_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.last_login AS last_login_12 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 2 | 0.94 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.meeting_date AS meeting_date_3, m0_.start_time AS start_time_4, m0_.end_time AS end_time_5, m0_.location AS location_6, m0_.status AS status_7, m0_.agenda AS agenda_8, m0_.minutes AS minutes_9, m0_.created_at AS created_at_10, m0_.organizer_id AS organizer_id_11 FROM `meetings` m0_ WHERE m0_.meeting_date >= ? ORDER BY m0_.meeting_date ASC LIMIT 5
Parameters:
[
"2026-09-24 00:00:00"
]
|
||||||||||||||||||||||||||||
| 3 | 0.80 ms |
SELECT t0.id AS id_1, t0.reference_number AS reference_number_2, t0.mail_type AS mail_type_3, t0.mail_date AS mail_date_4, t0.sender AS sender_5, t0.recipient AS recipient_6, t0.subject AS subject_7, t0.description AS description_8, t0.status AS status_9, t0.document_path AS document_path_10, t0.created_at AS created_at_11, t0.assigned_to_id AS assigned_to_id_12 FROM `mails` t0 ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 0.95 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.category AS category_3, t0.file_name AS file_name_4, t0.file_extension AS file_extension_5, t0.file_size AS file_size_6, t0.version AS version_7, t0.description AS description_8, t0.is_archived AS is_archived_9, t0.created_at AS created_at_10, t0.uploaded_by_id AS uploaded_by_id_11, t0.project_id AS project_id_12, t0.event_id AS event_id_13 FROM `documents` t0 WHERE t0.is_archived = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
0
]
|
||||||||||||||||||||||||||||
| 5 | 0.99 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.event_type AS event_type_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.location AS location_6, e0_.budget AS budget_7, e0_.program AS program_8, e0_.results_report AS results_report_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.organizer_id AS organizer_id_12, e0_.project_id AS project_id_13 FROM `events` e0_ WHERE e0_.start_date >= ? ORDER BY e0_.start_date ASC LIMIT 4
Parameters:
[
"2026-09-24 00:00:00"
]
|
||||||||||||||||||||||||||||
| 6 | 0.77 ms |
SELECT t0.id AS id_1, t0.reference_number AS reference_number_2, t0.mail_type AS mail_type_3, t0.mail_date AS mail_date_4, t0.sender AS sender_5, t0.recipient AS recipient_6, t0.subject AS subject_7, t0.description AS description_8, t0.status AS status_9, t0.document_path AS document_path_10, t0.created_at AS created_at_11, t0.assigned_to_id AS assigned_to_id_12 FROM `mails` t0 WHERE t0.status IN (?, ?, ?)
Parameters:
[ "recu" "affecte" "en_traitement" ]
|
||||||||||||||||||||||||||||
| 7 | 0.71 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.category AS category_3, t0.file_name AS file_name_4, t0.file_extension AS file_extension_5, t0.file_size AS file_size_6, t0.version AS version_7, t0.description AS description_8, t0.is_archived AS is_archived_9, t0.created_at AS created_at_10, t0.uploaded_by_id AS uploaded_by_id_11, t0.project_id AS project_id_12, t0.event_id AS event_id_13 FROM `documents` t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 8 | 0.68 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meeting_date AS meeting_date_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.location AS location_7, t0.status AS status_8, t0.agenda AS agenda_9, t0.minutes AS minutes_10, t0.created_at AS created_at_11, t0.organizer_id AS organizer_id_12 FROM `meetings` t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 9 | 0.85 ms |
SELECT t0.id AS id_1, t0.week_number AS week_number_2, t0.year AS year_3, t0.activities_done AS activities_done_4, t0.difficulties AS difficulties_5, t0.activities_planned AS activities_planned_6, t0.status AS status_7, t0.validated_at AS validated_at_8, t0.comments AS comments_9, t0.created_at AS created_at_10, t0.author_id AS author_id_11, t0.validated_by_id AS validated_by_id_12 FROM `weekly_reports` t0 WHERE t0.status = ?
Parameters:
[
"soumis"
]
|
||||||||||||||||||||||||||||
| 10 | 0.98 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.title AS title_3, t0.total_amount AS total_amount_4, t0.allocated_amount AS allocated_amount_5, t0.source_funding AS source_funding_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.project_id AS project_id_9, t0.responsible_id AS responsible_id_10 FROM `budgets` t0 WHERE t0.status = ?
Parameters:
[
"actif"
]
|
||||||||||||||||||||||||||||
| 11 | 0.89 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.expense_date AS expense_date_4, t0.category AS category_5, t0.supplier AS supplier_6, t0.description AS description_7, t0.status AS status_8, t0.receipt_path AS receipt_path_9, t0.validated_at AS validated_at_10, t0.rejection_reason AS rejection_reason_11, t0.created_at AS created_at_12, t0.project_id AS project_id_13, t0.event_id AS event_id_14, t0.budget_id AS budget_id_15, t0.recorded_by_id AS recorded_by_id_16, t0.validated_by_id AS validated_by_id_17 FROM `expenses` t0 WHERE t0.status = ?
Parameters:
[
"valide"
]
|
||||||||||||||||||||||||||||
| 12 | 0.92 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.expense_date AS expense_date_4, t0.category AS category_5, t0.supplier AS supplier_6, t0.description AS description_7, t0.status AS status_8, t0.receipt_path AS receipt_path_9, t0.validated_at AS validated_at_10, t0.rejection_reason AS rejection_reason_11, t0.created_at AS created_at_12, t0.project_id AS project_id_13, t0.event_id AS event_id_14, t0.budget_id AS budget_id_15, t0.recorded_by_id AS recorded_by_id_16, t0.validated_by_id AS validated_by_id_17 FROM `expenses` t0 WHERE t0.status = ? ORDER BY t0.expense_date DESC LIMIT 5
Parameters:
[
"en_attente"
]
|
||||||||||||||||||||||||||||
| 13 | 0.94 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.description AS description_4, t0.objectives AS objectives_5, t0.partner AS partner_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.status AS status_9, t0.priority AS priority_10, t0.budget AS budget_11, t0.progress_percentage AS progress_percentage_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.manager_id AS manager_id_15 FROM `projects` t0 WHERE t0.status = ?
Parameters:
[
"en_cours"
]
|
||||||||||||||||||||||||||||
| 14 | 0.86 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.priority AS priority_4, t0.status AS status_5, t0.progress_percentage AS progress_percentage_6, t0.due_date AS due_date_7, t0.created_at AS created_at_8, t0.completed_at AS completed_at_9, t0.project_id AS project_id_10, t0.assigned_to_id AS assigned_to_id_11, t0.created_by_id AS created_by_id_12 FROM `tasks` t0 WHERE t0.status = ? LIMIT 5
Parameters:
[
"en_validation"
]
|
||||||||||||||||||||||||||||
| 15 | 0.74 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.job_title AS job_title_7, t0.phone AS phone_8, t0.avatar AS avatar_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.last_login AS last_login_12 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
| 16 | 0.74 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.job_title AS job_title_7, t0.phone AS phone_8, t0.avatar AS avatar_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.last_login AS last_login_12 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
5
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Expense | 12 |
| App\Entity\Document | 10 |
| App\Entity\Mail | 8 |
| App\Entity\User | 7 |
| App\Entity\Budget | 6 |
| App\Entity\Project | 5 |
| App\Entity\Meeting | 4 |
| App\Entity\Event | 3 |
| App\Entity\Task | 3 |
| App\Entity\WeeklyReport | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Meeting | No errors. |
| App\Entity\Decision | No errors. |
| App\Entity\Mail | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\WeeklyReport | No errors. |
| App\Entity\Budget | No errors. |
| App\Entity\Expense | No errors. |
| App\Entity\Milestone | No errors. |