GET https://caisse.sigmsdrh.com/caisse?date=2026-06-15

Query Metrics

14 Database Queries
6 Different statements
7.76 ms Query time
2 Invalid entities
63 Managed entities

Queries

Group similar statements

# Time Info
1 1.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.phone_number AS phone_number_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.42 ms
SELECT t0.id AS id_1, t0.date_ouverture AS date_ouverture_2, t0.caissier_nom AS caissier_nom_3, t0.orange AS orange_4, t0.orange2 AS orange2_5, t0.mtn AS mtn_6, t0.mtn2 AS mtn2_7, t0.wave AS wave_8, t0.wave2 AS wave2_9, t0.push AS push_10, t0.tresor_money AS tresor_money_11, t0.moov AS moov_12, t0.transfert AS transfert_13, t0.billet AS billet_14, t0.monnaie AS monnaie_15, t0.total_fermeture AS total_fermeture_16, t0.caissier_id AS caissier_id_17, t0.fermeture_id AS fermeture_id_18 FROM caisse t0 WHERE t0.caissier_id = ? ORDER BY t0.date_ouverture DESC
Parameters:
[
  1
]
3 0.51 ms
SELECT c0_.id AS id_0, c0_.date_ouverture AS date_ouverture_1, c0_.caissier_nom AS caissier_nom_2, c0_.orange AS orange_3, c0_.orange2 AS orange2_4, c0_.mtn AS mtn_5, c0_.mtn2 AS mtn2_6, c0_.wave AS wave_7, c0_.wave2 AS wave2_8, c0_.push AS push_9, c0_.tresor_money AS tresor_money_10, c0_.moov AS moov_11, c0_.transfert AS transfert_12, c0_.billet AS billet_13, c0_.monnaie AS monnaie_14, c0_.total_fermeture AS total_fermeture_15, c1_.id AS id_16, c1_.date_fermeture AS date_fermeture_17, c1_.orange AS orange_18, c1_.orange2 AS orange2_19, c1_.mtn AS mtn_20, c1_.mtn2 AS mtn2_21, c1_.wave AS wave_22, c1_.wave2 AS wave2_23, c1_.push AS push_24, c1_.tresor_money AS tresor_money_25, c1_.moov AS moov_26, c1_.transfert AS transfert_27, c1_.billet AS billet_28, c1_.monnaie AS monnaie_29, m2_.id AS id_30, m2_.type AS type_31, m2_.montant AS montant_32, m2_.date AS date_33, m2_.libelle AS libelle_34, m2_.libelle2 AS libelle2_35, c0_.caissier_id AS caissier_id_36, c0_.fermeture_id AS fermeture_id_37, c1_.caisse_id AS caisse_id_38, m2_.caisse_id AS caisse_id_39 FROM caisse c0_ LEFT JOIN caisse_fermeture c1_ ON c0_.fermeture_id = c1_.id LEFT JOIN mouvement m2_ ON c0_.id = m2_.caisse_id WHERE c0_.caissier_id = ? AND (c1_.date_fermeture BETWEEN ? AND ?)
Parameters:
[
  1
  "2026-06-01 00:00:00"
  "2026-06-30 23:59:59"
]
4 2.11 ms
SELECT c0_.id AS id_0, c0_.date_ouverture AS date_ouverture_1, c0_.caissier_nom AS caissier_nom_2, c0_.orange AS orange_3, c0_.orange2 AS orange2_4, c0_.mtn AS mtn_5, c0_.mtn2 AS mtn2_6, c0_.wave AS wave_7, c0_.wave2 AS wave2_8, c0_.push AS push_9, c0_.tresor_money AS tresor_money_10, c0_.moov AS moov_11, c0_.transfert AS transfert_12, c0_.billet AS billet_13, c0_.monnaie AS monnaie_14, c0_.total_fermeture AS total_fermeture_15, c0_.caissier_id AS caissier_id_16, c0_.fermeture_id AS fermeture_id_17 FROM caisse c0_ WHERE c0_.date_ouverture >= ? AND c0_.date_ouverture < ? ORDER BY c0_.date_ouverture DESC
Parameters:
[
  "2026-06-15 00:00:00"
  "2026-06-16 00:00:00"
]
5 0.35 ms
SELECT t0.id AS id_1, t0.date_fermeture AS date_fermeture_2, t0.orange AS orange_3, t0.orange2 AS orange2_4, t0.mtn AS mtn_5, t0.mtn2 AS mtn2_6, t0.wave AS wave_7, t0.wave2 AS wave2_8, t0.push AS push_9, t0.tresor_money AS tresor_money_10, t0.moov AS moov_11, t0.transfert AS transfert_12, t0.billet AS billet_13, t0.monnaie AS monnaie_14, t0.caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0.id = ?
Parameters:
[
  1531
]
6 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.montant AS montant_3, t0.date AS date_4, t0.libelle AS libelle_5, t0.libelle2 AS libelle2_6, t0.caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0.caisse_id = ?
Parameters:
[
  1538
]
7 0.33 ms
SELECT t0.id AS id_1, t0.date_fermeture AS date_fermeture_2, t0.orange AS orange_3, t0.orange2 AS orange2_4, t0.mtn AS mtn_5, t0.mtn2 AS mtn2_6, t0.wave AS wave_7, t0.wave2 AS wave2_8, t0.push AS push_9, t0.tresor_money AS tresor_money_10, t0.moov AS moov_11, t0.transfert AS transfert_12, t0.billet AS billet_13, t0.monnaie AS monnaie_14, t0.caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0.id = ?
Parameters:
[
  1532
]
8 0.32 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.montant AS montant_3, t0.date AS date_4, t0.libelle AS libelle_5, t0.libelle2 AS libelle2_6, t0.caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0.caisse_id = ?
Parameters:
[
  1537
]
9 0.34 ms
SELECT t0.id AS id_1, t0.date_fermeture AS date_fermeture_2, t0.orange AS orange_3, t0.orange2 AS orange2_4, t0.mtn AS mtn_5, t0.mtn2 AS mtn2_6, t0.wave AS wave_7, t0.wave2 AS wave2_8, t0.push AS push_9, t0.tresor_money AS tresor_money_10, t0.moov AS moov_11, t0.transfert AS transfert_12, t0.billet AS billet_13, t0.monnaie AS monnaie_14, t0.caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0.id = ?
Parameters:
[
  1528
]
10 0.33 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.montant AS montant_3, t0.date AS date_4, t0.libelle AS libelle_5, t0.libelle2 AS libelle2_6, t0.caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0.caisse_id = ?
Parameters:
[
  1536
]
11 0.36 ms
SELECT t0.id AS id_1, t0.date_fermeture AS date_fermeture_2, t0.orange AS orange_3, t0.orange2 AS orange2_4, t0.mtn AS mtn_5, t0.mtn2 AS mtn2_6, t0.wave AS wave_7, t0.wave2 AS wave2_8, t0.push AS push_9, t0.tresor_money AS tresor_money_10, t0.moov AS moov_11, t0.transfert AS transfert_12, t0.billet AS billet_13, t0.monnaie AS monnaie_14, t0.caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0.id = ?
Parameters:
[
  1529
]
12 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.montant AS montant_3, t0.date AS date_4, t0.libelle AS libelle_5, t0.libelle2 AS libelle2_6, t0.caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0.caisse_id = ?
Parameters:
[
  1535
]
13 0.32 ms
SELECT t0.id AS id_1, t0.date_fermeture AS date_fermeture_2, t0.orange AS orange_3, t0.orange2 AS orange2_4, t0.mtn AS mtn_5, t0.mtn2 AS mtn2_6, t0.wave AS wave_7, t0.wave2 AS wave2_8, t0.push AS push_9, t0.tresor_money AS tresor_money_10, t0.moov AS moov_11, t0.transfert AS transfert_12, t0.billet AS billet_13, t0.monnaie AS monnaie_14, t0.caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0.id = ?
Parameters:
[
  1530
]
14 0.31 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.montant AS montant_3, t0.date AS date_4, t0.libelle AS libelle_5, t0.libelle2 AS libelle2_6, t0.caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0.caisse_id = ?
Parameters:
[
  1534
]

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\Caisse 19
App\Entity\CaisseFermeture 19
App\Entity\Mouvement 19
App\Entity\User 6

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field App\Entity\User#caisses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Caisse#caissier does not contain the required 'inversedBy="caisses"' attribute.
App\Entity\Caisse No errors.
App\Entity\CaisseFermeture
  • The field App\Entity\CaisseFermeture#caisse is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Caisse#fermeture does not contain the required 'mappedBy="caisse"' attribute.
App\Entity\Mouvement No errors.