Redirect 302 redirect from GET @app_dashboard_redirect (46d99d)

GET https://administration.technopole-km.com/administration/dashboard

Query Metrics

16 Database Queries
14 Different statements
32.64 ms Query time
0 Invalid entities
59 Managed entities

Queries

Group similar statements

#▲ 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.