Query Metrics
7
Database Queries
7
Different statements
16.25 ms
Query time
0
Invalid entities
14
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.02 ms |
SELECT u0_.civility AS civility_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.login AS login_3, u0_.password AS password_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.mobile_phone AS mobile_phone_7, u0_.contact AS contact_8, u0_.status AS status_9, u0_.first_login AS first_login_10, u0_.avatar AS avatar_11, u0_.token AS token_12, u0_.token_created_at AS token_created_at_13, u0_.id AS id_14, u0_.role_id AS role_id_15, u0_.group_id AS group_id_16 FROM user u0_ WHERE LOWER(u0_.login) = ? OR LOWER(u0_.email) = ? LIMIT 1
Parameters:
[ "amine_gest_fd" "amine_gest_fd" ] |
| 2 | 1.53 ms |
SELECT t0.name AS name_1, t0.label AS label_2, t0.id AS id_3, t4.civility AS civility_5, t4.first_name AS first_name_6, t4.last_name AS last_name_7, t4.login AS login_8, t4.password AS password_9, t4.email AS email_10, t4.phone AS phone_11, t4.mobile_phone AS mobile_phone_12, t4.contact AS contact_13, t4.status AS status_14, t4.first_login AS first_login_15, t4.avatar AS avatar_16, t4.token AS token_17, t4.token_created_at AS token_created_at_18, t4.id AS id_19, t4.role_id AS role_id_20, t4.group_id AS group_id_21, t0.parent AS parent_22 FROM role t0 LEFT JOIN user t4 ON t4.role_id = t0.id WHERE t0.id = ?
Parameters:
[
8
]
|
| 3 | 1.98 ms |
SELECT t0.date AS date_1, t0.first_connection_time AS first_connection_time_2, t0.last_connection_time AS last_connection_time_3, t0.last_action_time AS last_action_time_4, t0.last_disconnection_time AS last_disconnection_time_5, t0.total_duration AS total_duration_6, t0.session_count AS session_count_7, t0.active AS active_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM connection_history t0 WHERE t0.user_id = ? AND t0.date = ? LIMIT 1
Parameters:
[ 1046 "2026-04-25" ] |
| 4 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 5.43 ms |
INSERT INTO connection_history (date, first_connection_time, last_connection_time, last_action_time, last_disconnection_time, total_duration, session_count, active, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-25" "2026-04-25 15:00:18" "2026-04-25 15:00:18" "2026-04-25 15:00:18" null 0 1 1 1046 ] |
| 6 | 1.95 ms |
INSERT INTO session (started_at, ended_at, reason, total_duration, connection_history_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-04-25 15:00:18" null null 0 97688 ] |
| 7 | 2.87 ms |
"COMMIT"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 11 |
| App\Entity\Role | 1 |
| App\Entity\ConnectionHistory | 1 |
| App\Entity\Session | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\CentreGroup | No errors. |
| App\Entity\ConnectionHistory | No errors. |
| App\Entity\NotificationHistory | No errors. |
| App\Entity\DocumentQuotationAlert | No errors. |
| App\Entity\QuotationNoFurtherAction | No errors. |
| App\Entity\UserCentreAccessibility | No errors. |
| App\Entity\Centre | No errors. |
| App\Entity\RoleRule | No errors. |
| App\Entity\QuotationStatus | No errors. |
| App\Entity\Session | No errors. |