Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.92 ms Query time

2 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.92 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 IS NULL AND t0.fermeture_id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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 IS NULL
  AND t0.fermeture_id IS NULL
LIMIT
  1

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 IS NULL AND t0.fermeture_id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 60)
5	App\Controller\CaisseFermetureController->new (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 9)

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

Entities Mapping

Class	Mapping errors
App\Entity\Caisse	No 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\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.

Symfony Profiler

GET https://caisse.sigmsdrh.com/caisse/fermeture/new

Configuration Settings

Theme

Page Width