Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1.63 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.40 ms
(24.29%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.telephone AS telephone_7,
  t0.is_verified AS is_verified_8,
  t0.date_time_payant AS date_time_payant_9,
  t0.date_time_creation AS date_time_creation_10,
  t0.google_id AS google_id_11,
  t0.stripe_id AS stripe_id_12,
  t0.last_pourcentage AS last_pourcentage_13,
  t0.google_authenticator_secret AS google_authenticator_secret_14,
  t0.trusted_version AS trusted_version_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 205)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 125)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.34 ms
(21.02%)

SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE (s0_.current_period_start < ? AND s0_.current_period_end > ? AND s0_.user_id = ? AND s0_.is_active = ? AND p1_.name = ?) OR p1_.name = ? ORDER BY s0_.current_period_end DESC LIMIT 1

Parameters:

[
  "2026-02-04 19:33:01"
  "2026-02-04 19:33:01"
  3
  1
  "Or"
  "Argent"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.stripe_id AS stripe_id_1,
  s0_.current_period_start AS current_period_start_2,
  s0_.current_period_end AS current_period_end_3,
  s0_.is_active AS is_active_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.slug AS slug_7,
  p1_.stripe_id AS stripe_id_8,
  p1_.price AS price_9,
  p1_.created_at AS created_at_10,
  p1_.payment_link AS payment_link_11,
  s0_.plan_id AS plan_id_12,
  s0_.user_id AS user_id_13
FROM
  subscription s0_
  LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id
WHERE
  (
    s0_.current_period_start < ?
    AND s0_.current_period_end > ?
    AND s0_.user_id = ?
    AND s0_.is_active = ?
    AND p1_.name = ?
  )
  OR p1_.name = ?
ORDER BY
  s0_.current_period_end DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE (s0_.current_period_start < '2026-02-04 19:33:01' AND s0_.current_period_end > '2026-02-04 19:33:01' AND s0_.user_id = 3 AND s0_.is_active = 1 AND p1_.name = 'Or') OR p1_.name = 'Argent' ORDER BY s0_.current_period_end DESC LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 97)
7	App\Repository\SubscriptionRepository->findActiveSubPlanOrorArgent (line 240)
8	App\Controller\RevenuController->addPiecejointe (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 5)

0.33 ms
(20.17%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chemin AS chemin_3, t0.taille AS taille_4, t0.type AS type_5, t0.facture_id AS facture_id_6, t0.revenu_id AS revenu_id_7, t0.vehicule_id AS vehicule_id_8, t0.incident_id AS incident_id_9 FROM piece_jointe t0 WHERE t0.revenu_id = ?

Parameters:

[
  1477
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.chemin AS chemin_3,
  t0.taille AS taille_4,
  t0.type AS type_5,
  t0.facture_id AS facture_id_6,
  t0.revenu_id AS revenu_id_7,
  t0.vehicule_id AS vehicule_id_8,
  t0.incident_id AS incident_id_9
FROM
  piece_jointe t0
WHERE
  t0.revenu_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chemin AS chemin_3, t0.taille AS taille_4, t0.type AS type_5, t0.facture_id AS facture_id_6, t0.revenu_id AS revenu_id_7, t0.vehicule_id AS vehicule_id_8, t0.incident_id AS incident_id_9 FROM piece_jointe t0 WHERE t0.revenu_id = 1477;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1230)
9	Twig\Extension\CoreExtension::length (line 190)
10	__TwigTemplate_e1afc68bf498cb025233a842d04c63c4->block_body (line 431)
11	Twig\Template->yieldBlock (line 200)
12	__TwigTemplate_d7ea376f36ae5143ab5fe6b44b1edae3->doDisplay (line 387)
13	Twig\Template->yield (line 58)
14	__TwigTemplate_e1afc68bf498cb025233a842d04c63c4->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 246)
23	App\Controller\RevenuController->addPiecejointe (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.30 ms
(18.57%)

SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE s0_.current_period_start < ? AND s0_.current_period_end > ? AND s0_.user_id = ? AND s0_.is_active = ? ORDER BY s0_.current_period_end DESC LIMIT 1

Parameters:

[
  "2026-02-04 19:33:01"
  "2026-02-04 19:33:01"
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.stripe_id AS stripe_id_1,
  s0_.current_period_start AS current_period_start_2,
  s0_.current_period_end AS current_period_end_3,
  s0_.is_active AS is_active_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.slug AS slug_7,
  p1_.stripe_id AS stripe_id_8,
  p1_.price AS price_9,
  p1_.created_at AS created_at_10,
  p1_.payment_link AS payment_link_11,
  s0_.plan_id AS plan_id_12,
  s0_.user_id AS user_id_13
FROM
  subscription s0_
  LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id
WHERE
  s0_.current_period_start < ?
  AND s0_.current_period_end > ?
  AND s0_.user_id = ?
  AND s0_.is_active = ?
ORDER BY
  s0_.current_period_end DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE s0_.current_period_start < '2026-02-04 19:33:01' AND s0_.current_period_end > '2026-02-04 19:33:01' AND s0_.user_id = 3 AND s0_.is_active = 1 ORDER BY s0_.current_period_end DESC LIMIT 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 65)
7	App\Repository\SubscriptionRepository->findActualSub (line 155)
8	App\Controller\UserController->statusAbo (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 101)
16	__TwigTemplate_175c15ae0a009cb5d2f396882709eee8->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1482)
21	Twig\Extension\CoreExtension::include (line 236)
22	__TwigTemplate_d7ea376f36ae5143ab5fe6b44b1edae3->doDisplay (line 387)
23	Twig\Template->yield (line 58)
24	__TwigTemplate_e1afc68bf498cb025233a842d04c63c4->doDisplay (line 387)
25	Twig\Template->yield (line 343)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 320)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 246)
33	App\Controller\RevenuController->addPiecejointe (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.26 ms
(15.94%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.montant_ht AS montant_ht_3, t0.montant_ttc AS montant_ttc_4, t0.montant_tps AS montant_tps_5, t0.montant_tvq AS montant_tvq_6, t0.pourboire AS pourboire_7, t0.date_time_creation AS date_time_creation_8, t0.numero AS numero_9, t0.mode_paiement_compte AS mode_paiement_compte_10, t0.fournisseur AS fournisseur_11, t0.recurrence AS recurrence_12, t0.ref_recurrence AS ref_recurrence_13, t0.redevance AS redevance_14, t0.user_id AS user_id_15 FROM revenu t0 WHERE t0.id = ?

Parameters:

[
  "1477"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.montant_ht AS montant_ht_3,
  t0.montant_ttc AS montant_ttc_4,
  t0.montant_tps AS montant_tps_5,
  t0.montant_tvq AS montant_tvq_6,
  t0.pourboire AS pourboire_7,
  t0.date_time_creation AS date_time_creation_8,
  t0.numero AS numero_9,
  t0.mode_paiement_compte AS mode_paiement_compte_10,
  t0.fournisseur AS fournisseur_11,
  t0.recurrence AS recurrence_12,
  t0.ref_recurrence AS ref_recurrence_13,
  t0.redevance AS redevance_14,
  t0.user_id AS user_id_15
FROM
  revenu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.montant_ht AS montant_ht_3, t0.montant_ttc AS montant_ttc_4, t0.montant_tps AS montant_tps_5, t0.montant_tvq AS montant_tvq_6, t0.pourboire AS pourboire_7, t0.date_time_creation AS date_time_creation_8, t0.numero AS numero_9, t0.mode_paiement_compte AS mode_paiement_compte_10, t0.fournisseur AS fournisseur_11, t0.recurrence AS recurrence_12, t0.ref_recurrence AS ref_recurrence_13, t0.redevance AS redevance_14, t0.user_id AS user_id_15 FROM revenu t0 WHERE t0.id = '1477';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Fiche	No errors.
App\Entity\Vehicule	No errors.
App\Entity\Depence	No errors.
App\Entity\Facture	No errors.
App\Entity\Revenu	No errors.
App\Entity\Employe	No errors.
App\Entity\Quart	No errors.
App\Entity\Course	No errors.
App\Entity\Horaire	No errors.
App\Entity\Incident	No errors.
App\Entity\PieceJointe	No errors.
App\Entity\Subscription	No errors.
App\Entity\Plan	No errors.

Symfony Profiler

GET https://flottigo.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CUserController%253A%253AstatusAbo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping