Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

8.32 ms Query time

2 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

7.47 ms

SELECT SUBSTRING(c0_.date_fermeture FROM 1 FOR 10) AS sclr_0, SUM(COALESCE(c0_.orange, 0) + COALESCE(c0_.orange2, 0) + COALESCE(c0_.mtn, 0) + COALESCE(c0_.mtn2, 0) + COALESCE(c0_.wave, 0) + COALESCE(c0_.wave2, 0) + COALESCE(c0_.moov, 0) + COALESCE(c0_.push, 0) + COALESCE(c0_.tresor_money, 0) + COALESCE(c0_.transfert, 0) + COALESCE(c0_.billet, 0) + COALESCE(c0_.monnaie, 0)) AS sclr_1 FROM caisse_fermeture c0_ GROUP BY sclr_0 ORDER BY sclr_0 DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUBSTRING(
    c0_.date_fermeture
    FROM
      1 FOR 10
  ) AS sclr_0,
  SUM(
    COALESCE(c0_.orange, 0) + COALESCE(c0_.orange2, 0) + COALESCE(c0_.mtn, 0) + COALESCE(c0_.mtn2, 0) + COALESCE(c0_.wave, 0) + COALESCE(c0_.wave2, 0) + COALESCE(c0_.moov, 0) + COALESCE(c0_.push, 0) + COALESCE(c0_.tresor_money, 0) + COALESCE(c0_.transfert, 0) + COALESCE(c0_.billet, 0) + COALESCE(c0_.monnaie, 0)
  ) AS sclr_1
FROM
  caisse_fermeture c0_
GROUP BY
  sclr_0
ORDER BY
  sclr_0 DESC

SELECT SUBSTRING(c0_.date_fermeture FROM 1 FOR 10) AS sclr_0, SUM(COALESCE(c0_.orange, 0) + COALESCE(c0_.orange2, 0) + COALESCE(c0_.mtn, 0) + COALESCE(c0_.mtn2, 0) + COALESCE(c0_.wave, 0) + COALESCE(c0_.wave2, 0) + COALESCE(c0_.moov, 0) + COALESCE(c0_.push, 0) + COALESCE(c0_.tresor_money, 0) + COALESCE(c0_.transfert, 0) + COALESCE(c0_.billet, 0) + COALESCE(c0_.monnaie, 0)) AS sclr_1 FROM caisse_fermeture c0_ GROUP BY sclr_0 ORDER BY sclr_0 DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\CaisseFermetureRepository->getSumOfClosingBalancesByDay (line 232)
8	App\Controller\MouvementController->soldesJournaliers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 9)

0.54 ms

SELECT SUM(c0_.solde_actuel) AS sclr_0 FROM credit c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(c0_.solde_actuel) AS sclr_0
FROM
  credit c0_

SELECT SUM(c0_.solde_actuel) AS sclr_0 FROM credit c0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 238)
8	App\Controller\MouvementController->soldesJournaliers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 9)

0.31 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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 92)
14	Symfony\Bridge\Twig\AppVariable->getUser (line 1909)
15	Twig\Extension\CoreExtension::getAttribute (line 137)
16	__TwigTemplate_bd99445153f8d059af49712fc9711353->doDisplay (line 402)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_e2f592f76d5485ca07b8f8237aa8e63a->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 271)
27	App\Controller\MouvementController->soldesJournaliers (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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
App\Entity\User	1

Entities Mapping

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

Symfony Profiler

GET https://caisse.sigmsdrh.com/mouvement/soldes/journaliers

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping