POST https://app.retouralasourcefx.com/api/auth/heartbeat

Query Metrics

7 Database Queries
7 Different statements
1.50 ms Query time
3 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.telephone AS telephone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.is_email_auth_enabled AS is_email_auth_enabled_9, t0.is_sms_auth_enabled AS is_sms_auth_enabled_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.avatar AS avatar_14, t0.push_token AS push_token_15, t0.push_subscription AS push_subscription_16, t0.agence_id AS agence_id_17, t0.service_transfert_id AS service_transfert_id_18 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "smoise@retouralasourcefx.com"
]
2 0.50 ms
SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.is_active AS is_active_2, a0_.is_appro_initial_valide AS is_appro_initial_valide_3, a0_.date_fin AS date_fin_4, a0_.caissier_id AS caissier_id_5, a0_.caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_.caissier_id = ? AND a0_.is_active = ? AND a0_.date_debut <= ? AND (a0_.date_fin IS NULL OR a0_.date_fin >= ?) ORDER BY a0_.date_debut DESC LIMIT 1
Parameters:
[
  24
  1
  "2026-06-03 13:08:25"
  "2026-06-03 13:08:25"
]
3 0.19 ms
DELETE FROM user_sessions WHERE last_activity < ?
Parameters:
[
  "2026-06-03 12:53:25"
]
4 0.23 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip_address AS ip_address_3, t0.user_agent AS user_agent_4, t0.last_activity AS last_activity_5, t0.created_at AS created_at_6, t0.user_id AS user_id_7 FROM user_sessions t0 WHERE t0.user_id = ? AND t0.session_id = ? LIMIT 1
Parameters:
[
  24
  "client_1780479067325_2csjwbx08"
]
5 0.09 ms
"START TRANSACTION"
Parameters:
[]
6 0.22 ms
UPDATE user_sessions SET last_activity = ? WHERE id = ?
Parameters:
[
  "2026-06-03 13:08:25"
  5502
]
7 0.09 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 1
App\Entity\Agence 1
App\Entity\AffectationCaisse 1
App\Entity\Caisse 1
App\Entity\UserSession 1

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\User No errors.
App\Entity\Agence No errors.
App\Entity\ServiceTransfert No errors.
App\Entity\AffectationAgence No errors.
App\Entity\ApproAgence
  • The mappings App\Entity\ApproAgence#validePar and App\Entity\User#approAgences are inconsistent with each other.
App\Entity\ApproCaisse No errors.
App\Entity\ApproCompteGeneral No errors.
App\Entity\MouvementCaisse No errors.
App\Entity\MouvementCompteBancaire No errors.
App\Entity\Client No errors.
App\Entity\MouvementCompteClient No errors.
App\Entity\Operation
  • The mappings App\Entity\Operation#deviseCible and App\Entity\Devise#operations are inconsistent with each other.
  • The field App\Entity\Operation#mouvementCaisses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCaisse#operation does not contain the required 'inversedBy="mouvementCaisses"' attribute.
  • The field App\Entity\Operation#mouvementBancaires is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCompteBancaire#operation does not contain the required 'inversedBy="mouvementBancaires"' attribute.
  • The field App\Entity\Operation#mouvementCompteClients is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MouvementCompteClient#operation does not contain the required 'inversedBy="mouvementCompteClients"' attribute.
App\Entity\AffectationCaisse No errors.
App\Entity\Pret
  • The association App\Entity\Pret#agence refers to the inverse side field App\Entity\Agence#prets which does not exist.
  • The association App\Entity\Pret#caisse refers to the inverse side field App\Entity\Caisse#prets which does not exist.
App\Entity\Remboursement No errors.
App\Entity\Caisse No errors.
App\Entity\UserSession No errors.