Symfony Profiler

Query Metrics

27 Database Queries

5 Different statements

6.88 ms Query time

5 Invalid entities

25 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.71 ms
(83.03%)

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?

Parameters:

[
  "name"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parameter_key AS parameter_key_1,
  p0_.parameter_value AS parameter_value_2,
  p0_.parameter_label AS parameter_label_3,
  p0_.parameter_type AS parameter_type_4,
  p0_.parameter_category AS parameter_category_5,
  p0_.in_session AS in_session_6,
  p0_.parameter_category_enabled AS parameter_category_enabled_7,
  p0_.is_deleted AS is_deleted_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10
FROM
  parameter p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.parameter_key = ?

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'name';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 114)
7	Graphlife\CMSBundle\Repository\ParameterRepository->findOneBy (line 58)
8	Graphlife\CMSBundle\Extension\CmsExtension->getParameter (line 227)
9	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5c20879fac09050cb3d5d3528646ce56->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	Graphlife\CMSPaymentBundle\Controller\CartController->get (line 54)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.45 ms
(6.55%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 701)
6	Graphlife\CMSBundle\Extension\CmsExtension->__construct (line 69)
7	ContainerNxCPmNd\App_KernelDevDebugContainer->getCmsExtensionService (line 780)
8	ContainerNxCPmNd\App_KernelDevDebugContainer::getTwigService (line 2630)
9	Symfony\Component\DependencyInjection\Container::getService (line 399)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
14	Graphlife\CMSPaymentBundle\Controller\CartController->get (line 54)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.27 ms
(3.88%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.options AS options_3,
  f0_.price AS price_4,
  f0_.is_subscription_open AS is_subscription_open_5,
  f0_.payment_configuration AS payment_configuration_6,
  f0_.price_ht AS price_ht_7,
  f0_.is_in_top_bar AS is_in_top_bar_8,
  f0_.top_bar_message AS top_bar_message_9,
  f0_.is_deleted AS is_deleted_10,
  f0_.created_at AS created_at_11,
  f0_.updated_at AS updated_at_12,
  f0_.subscription_class_id AS subscription_class_id_13,
  f0_.product_type_id AS product_type_id_14
FROM
  formation f0_
WHERE
  COALESCE(f0_.is_deleted, 0) = 0
  AND f0_.is_in_top_bar = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 114)
7	App\Twig\Runtime\LessonExtensionsRuntime->getInTopBarSubscription (line 62)
8	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 507)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_5c20879fac09050cb3d5d3528646ce56->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
21	Graphlife\CMSPaymentBundle\Controller\CartController->get (line 54)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.27 ms
(3.85%)

SELECT m0_.id AS id_0, m0_.link_name AS link_name_1, m0_.link AS link_2, m0_.on_top AS on_top_3, m0_.ordre AS ordre_4, m0_.visibility AS visibility_5, m0_.link_type AS link_type_6, m0_.is_deleted AS is_deleted_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9 FROM menu m0_ WHERE COALESCE(m0_.is_deleted, 0) = 0 ORDER BY m0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.link_name AS link_name_1,
  m0_.link AS link_2,
  m0_.on_top AS on_top_3,
  m0_.ordre AS ordre_4,
  m0_.visibility AS visibility_5,
  m0_.link_type AS link_type_6,
  m0_.is_deleted AS is_deleted_7,
  m0_.created_at AS created_at_8,
  m0_.updated_at AS updated_at_9
FROM
  menu m0_
WHERE
  COALESCE(m0_.is_deleted, 0) = 0
ORDER BY
  m0_.ordre ASC

SELECT m0_.id AS id_0, m0_.link_name AS link_name_1, m0_.link AS link_2, m0_.on_top AS on_top_3, m0_.ordre AS ordre_4, m0_.visibility AS visibility_5, m0_.link_type AS link_type_6, m0_.is_deleted AS is_deleted_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9 FROM menu m0_ WHERE COALESCE(m0_.is_deleted, 0) = 0 ORDER BY m0_.ordre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Graphlife\CMSBundle\Repository\BaseRepository->findBy (line 189)
7	Graphlife\CMSBundle\Repository\MenuRepository->findBy (line 44)
8	Graphlife\CMSBundle\Extension\CmsExtension->getMenu (line 222)
9	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 354)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5c20879fac09050cb3d5d3528646ce56->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	Graphlife\CMSPaymentBundle\Controller\CartController->get (line 54)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.19 ms
(2.69%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.name AS name_2,
  p0_.footer_name AS footer_name_3,
  p0_.content AS content_4,
  p0_.is_deleted AS is_deleted_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7
FROM
  policy_term p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Graphlife\CMSBundle\Repository\BaseRepository->findAll (line 126)
7	Graphlife\CMSBundle\Extension\CmsExtension->getPolicies (line 172)
8	__TwigTemplate_4dfb0efde8353d7ef860ca585bc6155c->doDisplay (line 132)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 375)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_5c20879fac09050cb3d5d3528646ce56->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
21	Graphlife\CMSPaymentBundle\Controller\CartController->get (line 54)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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
Graphlife\CMSBundle\Entity\Parameter	16
Graphlife\CMSBundle\Entity\PolicyTerm	4
Graphlife\CMSBundle\Entity\Menu	3
App\Entity\Formation	1
Graphlife\CMSPaymentBundle\Entity\ProductType	1

Entities Mapping

Class	Mapping errors
Graphlife\CMSPaymentBundle\Entity\Shippment	The association Graphlife\CMSPaymentBundle\Entity\Shippment#payment refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Payment#shippment which does not exist.
Graphlife\CMSPaymentBundle\Entity\ProductType	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan	No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Payment	The mappings Graphlife\CMSPaymentBundle\Entity\Payment#shippments and Graphlife\CMSPaymentBundle\Entity\Shippment#payment are inconsistent with each other. The association Graphlife\CMSPaymentBundle\Entity\Payment#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#payments which does not exist.
Graphlife\CMSPaymentBundle\Entity\Transaction	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\Category	No errors.
Graphlife\CMSPaymentBundle\Entity\Currency	No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage	No errors.
Graphlife\CMSPaymentBundle\Entity\Product	No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo	No errors.
Graphlife\CMSPaymentBundle\Entity\Package	No errors.
Graphlife\CMSPaymentBundle\Entity\Stock	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod	The association Graphlife\CMSPaymentBundle\Entity\ShippingMethod#countries refers to the inverse side field Graphlife\CMSBundle\Entity\Country#shippingMethods which does not exist.
Graphlife\CMSBundle\Entity\User	No errors.
Graphlife\CMSBundle\Entity\PostCategory	No errors.
Graphlife\CMSBundle\Entity\Country	No errors.
Graphlife\CMSBundle\Entity\Post	No errors.
Graphlife\CMSBundle\Entity\Page	No errors.
Graphlife\CMSBundle\Entity\Email	No errors.
Graphlife\CMSBundle\Entity\Parameter	No errors.
Graphlife\CMSBundle\Entity\Notification	The association Graphlife\CMSBundle\Entity\Notification#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#notifications which does not exist.
Graphlife\CMSBundle\Entity\Widget	No errors.
Graphlife\CMSBundle\Entity\Banner	No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail	No errors.
Graphlife\CMSBundle\Entity\ParameterCategory	No errors.
Graphlife\CMSBundle\Entity\PolicyTerm	No errors.
Graphlife\CMSBundle\Entity\Menu	No errors.
App\Entity\DemandeFormateur	No errors.
App\Entity\Question	No errors.
App\Entity\Document	No errors.
App\Entity\Event	No errors.
App\Entity\Lesson	No errors.
App\Entity\UserCourse	No errors.
App\Entity\StudentClass	No errors.
App\Entity\CompanyCourse	No errors.
App\Entity\ServiceCompany	No errors.
App\Entity\Company	No errors.
App\Entity\QuestionFAQCategory	No errors.
App\Entity\LiveSession	No errors.
App\Entity\Test	The association App\Entity\Test#account refers to the inverse side field Graphlife\CMSBundle\Entity\User#tests which does not exist. The association App\Entity\Test#course refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Product#tests which does not exist.
App\Entity\Formation	No errors.
App\Entity\VideoUploading	No errors.
App\Entity\LessonStatus	No errors.
App\Entity\QuestionFAQ	No errors.
App\Entity\CommissionFormateur	No errors.
App\Entity\UserCompany	No errors.

Symfony Profiler

GET https://africafirst.graph-life.fr/cart

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping