Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.32 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.32 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.type AS type_4, p0_.is_active AS is_active_5, p0_.nb_livreurs AS nb_livreurs_6, p0_.nb_produits AS nb_produits_7, p0_.suivi_type AS suivi_type_8, p0_.api AS api_9, p0_.support_dedie AS support_dedie_10, p0_.fonctionnalites_sur_mesure AS fonctionnalites_sur_mesure_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.billing_cycle AS billing_cycle_14, p0_.position AS position_15 FROM plan_abonnement p0_ WHERE p0_.is_active = ? ORDER BY p0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.price AS price_3,
  p0_.type AS type_4,
  p0_.is_active AS is_active_5,
  p0_.nb_livreurs AS nb_livreurs_6,
  p0_.nb_produits AS nb_produits_7,
  p0_.suivi_type AS suivi_type_8,
  p0_.api AS api_9,
  p0_.support_dedie AS support_dedie_10,
  p0_.fonctionnalites_sur_mesure AS fonctionnalites_sur_mesure_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.billing_cycle AS billing_cycle_14,
  p0_.position AS position_15
FROM
  plan_abonnement p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.type AS type_4, p0_.is_active AS is_active_5, p0_.nb_livreurs AS nb_livreurs_6, p0_.nb_produits AS nb_produits_7, p0_.suivi_type AS suivi_type_8, p0_.api AS api_9, p0_.support_dedie AS support_dedie_10, p0_.fonctionnalites_sur_mesure AS fonctionnalites_sur_mesure_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.billing_cycle AS billing_cycle_14, p0_.position AS position_15 FROM plan_abonnement p0_ WHERE p0_.is_active = 1 ORDER BY p0_.position ASC;

#	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 52)
7	App\Repository\PlanAbonnementRepository->findActivePlans (line 21)
8	App\Controller\CommunController->offres (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 248)
16	__TwigTemplate_4ae16d231c4783dda7cae600345fc3a3->block_body (line 446)
17	Twig\Template->yieldBlock (line 373)
18	__TwigTemplate_046f670ace4b30b8ad34e0bdfc3e89de->doDisplay (line 402)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_4ae16d231c4783dda7cae600345fc3a3->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
29	App\Controller\HomeController->index (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\PlanAbonnement	4

Entities Mapping

Class	Mapping errors
App\Entity\PlanAbonnement	No errors.
App\Entity\Livreur	No errors.
App\Entity\Client	No errors.
App\Entity\ContactMessage	No errors.
App\Entity\Devis	No errors.
App\Entity\Abonnement	No errors.
App\Entity\User	No errors.
App\Entity\Page	No errors.
App\Entity\Produit	No errors.
App\Entity\Entreprise	No errors.
App\Entity\Site	No errors.
App\Entity\Affectation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.monlivraison.com/

Configuration Settings

Theme

Page Width