Symfony Profiler

Query Metrics

35 Database Queries

11 Different statements

10.33 ms Query time

5 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.09 ms
(68.60%)

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_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
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	App\Controller\PageController->subscribe (line 122)
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.49 ms
(4.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.description AS description_4, t0.slug AS slug_5, t0.principal_image AS principal_image_6, t0.is_sold AS is_sold_7, t0.top_position AS top_position_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price AS price_11, t0.price_ht AS price_ht_12, t0.properties AS properties_13, t0.max_cart_quantity AS max_cart_quantity_14, t0.weight AS weight_15, t0.variations AS variations_16, t0.is_deleted AS is_deleted_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.product_type_id AS product_type_id_20, t0.author_id AS author_id_21 FROM product t0 INNER JOIN formation_product ON t0.id = formation_product.product_id WHERE formation_product.formation_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.thumb AS thumb_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.principal_image AS principal_image_6,
  t0.is_sold AS is_sold_7,
  t0.top_position AS top_position_8,
  t0.is_enabled AS is_enabled_9,
  t0.keywords AS keywords_10,
  t0.price AS price_11,
  t0.price_ht AS price_ht_12,
  t0.properties AS properties_13,
  t0.max_cart_quantity AS max_cart_quantity_14,
  t0.weight AS weight_15,
  t0.variations AS variations_16,
  t0.is_deleted AS is_deleted_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.product_type_id AS product_type_id_20,
  t0.author_id AS author_id_21
FROM
  product t0
  INNER JOIN formation_product ON t0.id = formation_product.product_id
WHERE
  formation_product.formation_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.description AS description_4, t0.slug AS slug_5, t0.principal_image AS principal_image_6, t0.is_sold AS is_sold_7, t0.top_position AS top_position_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price AS price_11, t0.price_ht AS price_ht_12, t0.properties AS properties_13, t0.max_cart_quantity AS max_cart_quantity_14, t0.weight AS weight_15, t0.variations AS variations_16, t0.is_deleted AS is_deleted_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.product_type_id AS product_type_id_20, t0.author_id AS author_id_21 FROM product t0 INNER JOIN formation_product ON t0.id = formation_product.product_id WHERE formation_product.formation_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->block_body (line 194)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 677)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\PageController->subscribe (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.44 ms
(4.26%)

SELECT t0.id AS id_1, t0.video_path AS video_path_2, t0.lesson_id AS lesson_id_3 FROM video_uploading t0 WHERE t0.lesson_id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.video_path AS video_path_2,
  t0.lesson_id AS lesson_id_3
FROM
  video_uploading t0
WHERE
  t0.lesson_id = ?

SELECT t0.id AS id_1, t0.video_path AS video_path_2, t0.lesson_id AS lesson_id_3 FROM video_uploading t0 WHERE t0.lesson_id = 23;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
9	Doctrine\ORM\AbstractQuery->execute (line 891)
10	Doctrine\ORM\AbstractQuery->getResult (line 689)
11	Graphlife\CMSBundle\Repository\BaseRepository->findBy (line 189)
12	App\Twig\Runtime\LessonExtensionsRuntime->getLessonsByIds (line 67)
13	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->block_body (line 213)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 677)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\PageController->subscribe (line 122)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.40 ms
(3.85%)

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_.id = ?

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_.id = ?

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_.id = '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->find (line 94)
7	App\Controller\PageController->subscribe (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.36 ms
(3.49%)

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	App\Controller\PageController->subscribe (line 122)
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.36 ms
(3.47%)

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_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
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	App\Controller\PageController->subscribe (line 122)
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.33 ms
(3.23%)

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_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
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	App\Controller\PageController->subscribe (line 122)
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.24 ms
(2.32%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.description AS description_2,
  l0_.video_link AS video_link_3,
  l0_.duration AS duration_4,
  l0_.is_video_uploaded AS is_video_uploaded_5,
  l0_.type AS type_6,
  l0_.validation_comments AS validation_comments_7,
  l0_.content AS content_8,
  l0_.is_deleted AS is_deleted_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11,
  l0_.author_id AS author_id_12,
  l0_.status_id AS status_id_13,
  l0_.cours_id AS cours_id_14
FROM
  lesson l0_
WHERE
  COALESCE(l0_.is_deleted, 0) = 0
  AND l0_.id IN (?, ?, ?)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (24, 26, 23);

#	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	App\Twig\Runtime\LessonExtensionsRuntime->getLessonsByIds (line 67)
8	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->block_body (line 213)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 677)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\PageController->subscribe (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.22 ms
(2.18%)

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_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
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	App\Controller\PageController->subscribe (line 122)
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.22 ms
(2.13%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.description AS description_2,
  l0_.video_link AS video_link_3,
  l0_.duration AS duration_4,
  l0_.is_video_uploaded AS is_video_uploaded_5,
  l0_.type AS type_6,
  l0_.validation_comments AS validation_comments_7,
  l0_.content AS content_8,
  l0_.is_deleted AS is_deleted_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11,
  l0_.author_id AS author_id_12,
  l0_.status_id AS status_id_13,
  l0_.cours_id AS cours_id_14
FROM
  lesson l0_
WHERE
  COALESCE(l0_.is_deleted, 0) = 0
  AND l0_.id IN (NULL)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (NULL);

#	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	App\Twig\Runtime\LessonExtensionsRuntime->getLessonsByIds (line 67)
8	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->block_body (line 213)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 677)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\PageController->subscribe (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.17 ms
(1.69%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.description AS description_2,
  l0_.video_link AS video_link_3,
  l0_.duration AS duration_4,
  l0_.is_video_uploaded AS is_video_uploaded_5,
  l0_.type AS type_6,
  l0_.validation_comments AS validation_comments_7,
  l0_.content AS content_8,
  l0_.is_deleted AS is_deleted_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11,
  l0_.author_id AS author_id_12,
  l0_.status_id AS status_id_13,
  l0_.cours_id AS cours_id_14
FROM
  lesson l0_
WHERE
  COALESCE(l0_.is_deleted, 0) = 0
  AND l0_.id IN (?, ?)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.duration AS duration_4, l0_.is_video_uploaded AS is_video_uploaded_5, l0_.type AS type_6, l0_.validation_comments AS validation_comments_7, l0_.content AS content_8, l0_.is_deleted AS is_deleted_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, l0_.author_id AS author_id_12, l0_.status_id AS status_id_13, l0_.cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (23, 23);

#	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	App\Twig\Runtime\LessonExtensionsRuntime->getLessonsByIds (line 67)
8	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->block_body (line 213)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_631296886f47859b1603a3524d5a27fb->block_main (line 677)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_631296886f47859b1603a3524d5a27fb->doDisplay (line 369)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8a76c62dbdbc5295086538ff5decd9e8->doDisplay (line 65)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\PageController->subscribe (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	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\CMSPaymentBundle\Entity\Product	4
Graphlife\CMSBundle\Entity\PolicyTerm	4
Graphlife\CMSBundle\Entity\Menu	3
App\Entity\Lesson	3
Graphlife\CMSBundle\Entity\User	2
App\Entity\LessonStatus	2
App\Entity\Formation	1
Graphlife\CMSPaymentBundle\Entity\ProductType	1
App\Entity\VideoUploading	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/subscribe/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping