GET http://lasalleerp-m.com/agent/?routeName=toggleSession

Query Metrics

7 Database Queries
7 Different statements
5.04 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.12 ms
(22.14%)
1
SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.user_id AS user_id_3 FROM session_history s0_ WHERE s0_.user_id = ? AND (s0_.start_at BETWEEN ? AND ?) AND s0_.end_at IS NULL
Parameters:
[
  6425
  "2026-07-28 00:00:00"
  "2026-07-28 23:59:59"
]
1.01 ms
(19.97%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6425
]
0.72 ms
(14.31%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ?
Parameters:
[
  6425
]
0.67 ms
(13.38%)
1
"COMMIT"
Parameters:
[]
0.66 ms
(13.01%)
1
UPDATE session_history SET end_at = ? WHERE id = ?
Parameters:
[
  "2026-07-28 14:24:16"
  614
]
0.48 ms
(9.61%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  6425
]
0.38 ms
(7.58%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
salle2 doctrine.dbal.salle2_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\Flexy\ShopBundle\Entity\Vendor\Vendor No errors.
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\SessionHistory No errors.