Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

1.46 ms Query time

1 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.59 ms
(40.22%)

SELECT p0_.id AS id_0, p0_.facture AS facture_1, p0_.nom_entreprise AS nom_entreprise_2, p0_.nom_client_entreprise AS nom_client_entreprise_3, p0_.prenom_client_entreprise AS prenom_client_entreprise_4, p0_.adresse_entreprise AS adresse_entreprise_5, p0_.code_postal_entreprise AS code_postal_entreprise_6, p0_.ville_entreprise AS ville_entreprise_7, p0_.pays_entreprise AS pays_entreprise_8, p0_.telephone_entreprise AS telephone_entreprise_9, p0_.mail_entreprise AS mail_entreprise_10, p0_.statut_paiement_donnees AS statut_paiement_donnees_11, p0_.commentaire_paiement AS commentaire_paiement_12, p0_.date_paiement AS date_paiement_13, p0_.somme AS somme_14, p0_.lien AS lien_15, p0_.statut AS statut_16, p0_.error_message AS error_message_17, p0_.paiement_actif AS paiement_actif_18, p0_.langue_utilisateur AS langue_utilisateur_19, p0_.fin_validite_date_paiement AS fin_validite_date_paiement_20, p0_.id_transaction AS id_transaction_21, p0_.paiement_archive AS paiement_archive_22, p0_.type AS type_23, p0_.libelle AS libelle_24 FROM `paiement` p0_ WHERE p0_.paiement_archive = 0 ORDER BY p0_.fin_validite_date_paiement DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.facture AS facture_1,
  p0_.nom_entreprise AS nom_entreprise_2,
  p0_.nom_client_entreprise AS nom_client_entreprise_3,
  p0_.prenom_client_entreprise AS prenom_client_entreprise_4,
  p0_.adresse_entreprise AS adresse_entreprise_5,
  p0_.code_postal_entreprise AS code_postal_entreprise_6,
  p0_.ville_entreprise AS ville_entreprise_7,
  p0_.pays_entreprise AS pays_entreprise_8,
  p0_.telephone_entreprise AS telephone_entreprise_9,
  p0_.mail_entreprise AS mail_entreprise_10,
  p0_.statut_paiement_donnees AS statut_paiement_donnees_11,
  p0_.commentaire_paiement AS commentaire_paiement_12,
  p0_.date_paiement AS date_paiement_13,
  p0_.somme AS somme_14,
  p0_.lien AS lien_15,
  p0_.statut AS statut_16,
  p0_.error_message AS error_message_17,
  p0_.paiement_actif AS paiement_actif_18,
  p0_.langue_utilisateur AS langue_utilisateur_19,
  p0_.fin_validite_date_paiement AS fin_validite_date_paiement_20,
  p0_.id_transaction AS id_transaction_21,
  p0_.paiement_archive AS paiement_archive_22,
  p0_.type AS type_23,
  p0_.libelle AS libelle_24
FROM
  `paiement` p0_
WHERE
  p0_.paiement_archive = 0
ORDER BY
  p0_.fin_validite_date_paiement DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.facture AS facture_1, p0_.nom_entreprise AS nom_entreprise_2, p0_.nom_client_entreprise AS nom_client_entreprise_3, p0_.prenom_client_entreprise AS prenom_client_entreprise_4, p0_.adresse_entreprise AS adresse_entreprise_5, p0_.code_postal_entreprise AS code_postal_entreprise_6, p0_.ville_entreprise AS ville_entreprise_7, p0_.pays_entreprise AS pays_entreprise_8, p0_.telephone_entreprise AS telephone_entreprise_9, p0_.mail_entreprise AS mail_entreprise_10, p0_.statut_paiement_donnees AS statut_paiement_donnees_11, p0_.commentaire_paiement AS commentaire_paiement_12, p0_.date_paiement AS date_paiement_13, p0_.somme AS somme_14, p0_.lien AS lien_15, p0_.statut AS statut_16, p0_.error_message AS error_message_17, p0_.paiement_actif AS paiement_actif_18, p0_.langue_utilisateur AS langue_utilisateur_19, p0_.fin_validite_date_paiement AS fin_validite_date_paiement_20, p0_.id_transaction AS id_transaction_21, p0_.paiement_archive AS paiement_archive_22, p0_.type AS type_23, p0_.libelle AS libelle_24 FROM `paiement` p0_ WHERE p0_.paiement_archive = 0 ORDER BY p0_.fin_validite_date_paiement DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 83)
7	App\Repository\PaiementRepository->getAll (line 43)
8	App\Service\PaiementService->getAll (line 64)
9	App\Controller\Admin\PaiementController->dtAjax (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.55 ms
(37.49%)

SELECT COUNT(p0_.id) AS sclr_0 FROM `paiement` p0_ WHERE p0_.paiement_archive = 0 ORDER BY p0_.fin_validite_date_paiement DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  `paiement` p0_
WHERE
  p0_.paiement_archive = 0
ORDER BY
  p0_.fin_validite_date_paiement DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM `paiement` p0_ WHERE p0_.paiement_archive = 0 ORDER BY p0_.fin_validite_date_paiement DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 67)
8	App\Repository\PaiementRepository->countAll (line 34)
9	App\Service\PaiementService->countAll (line 126)
10	App\Controller\Admin\PaiementController->dtAjax (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.33 ms
(22.28%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6 FROM `user` t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

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\Paiement	10
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Paiement	The field 'App\Entity\Paiement#somme' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

POST https://paiement.grimaldiforum.com.i2n.solutions/admin_paiement_gfm_74qkag4/paiements/dt-list

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping