Symfony Profiler

Query Metrics

35 Database Queries

17 Different statements

24.76 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.72 ms
(27.13%)

SELECT c0_.id AS id_0, c0_.title_fr AS title_fr_1, c0_.identifier_value AS identifier_value_2, c0_.live_stats AS live_stats_3, c0_.description AS description_4, c0_.title_slug_fr AS title_slug_fr_5, c0_.keywords AS keywords_6, c0_.is_enabled AS is_enabled_7, c0_.is_pin AS is_pin_8, c0_.date AS date_9, c0_.icon_library_value AS icon_library_value_10, c0_.parent_identifier_value AS parent_identifier_value_11, c0_.file_created AS file_created_12, c0_.menu_ranking AS menu_ranking_13, c0_.title_de AS title_de_14, c0_.title_slug_de AS title_slug_de_15, c0_.title_en AS title_en_16, c0_.title_slug_en AS title_slug_en_17, c0_.description_de AS description_de_18, c0_.description_en AS description_en_19, c0_.keywords_de AS keywords_de_20, c0_.keywords_en AS keywords_en_21, c0_.seo_title_fr AS seo_title_fr_22, c0_.seo_title_en AS seo_title_en_23, c0_.seo_title_de AS seo_title_de_24, c0_.parent_category_id AS parent_category_id_25 FROM categories c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title_fr AS title_fr_1,
  c0_.identifier_value AS identifier_value_2,
  c0_.live_stats AS live_stats_3,
  c0_.description AS description_4,
  c0_.title_slug_fr AS title_slug_fr_5,
  c0_.keywords AS keywords_6,
  c0_.is_enabled AS is_enabled_7,
  c0_.is_pin AS is_pin_8,
  c0_.date AS date_9,
  c0_.icon_library_value AS icon_library_value_10,
  c0_.parent_identifier_value AS parent_identifier_value_11,
  c0_.file_created AS file_created_12,
  c0_.menu_ranking AS menu_ranking_13,
  c0_.title_de AS title_de_14,
  c0_.title_slug_de AS title_slug_de_15,
  c0_.title_en AS title_en_16,
  c0_.title_slug_en AS title_slug_en_17,
  c0_.description_de AS description_de_18,
  c0_.description_en AS description_en_19,
  c0_.keywords_de AS keywords_de_20,
  c0_.keywords_en AS keywords_en_21,
  c0_.seo_title_fr AS seo_title_fr_22,
  c0_.seo_title_en AS seo_title_en_23,
  c0_.seo_title_de AS seo_title_de_24,
  c0_.parent_category_id AS parent_category_id_25
FROM
  categories c0_

SELECT c0_.id AS id_0, c0_.title_fr AS title_fr_1, c0_.identifier_value AS identifier_value_2, c0_.live_stats AS live_stats_3, c0_.description AS description_4, c0_.title_slug_fr AS title_slug_fr_5, c0_.keywords AS keywords_6, c0_.is_enabled AS is_enabled_7, c0_.is_pin AS is_pin_8, c0_.date AS date_9, c0_.icon_library_value AS icon_library_value_10, c0_.parent_identifier_value AS parent_identifier_value_11, c0_.file_created AS file_created_12, c0_.menu_ranking AS menu_ranking_13, c0_.title_de AS title_de_14, c0_.title_slug_de AS title_slug_de_15, c0_.title_en AS title_en_16, c0_.title_slug_en AS title_slug_en_17, c0_.description_de AS description_de_18, c0_.description_en AS description_en_19, c0_.keywords_de AS keywords_de_20, c0_.keywords_en AS keywords_en_21, c0_.seo_title_fr AS seo_title_fr_22, c0_.seo_title_en AS seo_title_en_23, c0_.seo_title_de AS seo_title_de_24, c0_.parent_category_id AS parent_category_id_25 FROM categories c0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 551)
21	App\Controller\AnonymousController->department (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

4.62 ms
(18.68%)

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.title_de AS title_de_17, t0.title_en AS title_en_18, t0.title_slug_de AS title_slug_de_19, t0.title_slug_en AS title_slug_en_20, t0.description_de AS description_de_21, t0.description_en AS description_en_22, t0.keywords_en AS keywords_en_23, t0.keywords_de AS keywords_de_24, t0.long_description_de AS long_description_de_25, t0.long_description_en AS long_description_en_26, t0.long_description_html_en AS long_description_html_en_27, t0.long_description_html_de AS long_description_html_de_28, t0.category_id AS category_id_29, t0.price_id AS price_id_30, t0.product_availability_id AS product_availability_id_31, t0.product_condition_id AS product_condition_id_32, t0.supplier_id AS supplier_id_33 FROM Product t0 WHERE t0.category_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.title_fr AS title_fr_3,
  t0.description AS description_4,
  t0.is_adult AS is_adult_5,
  t0.date AS date_6,
  t0.live_stats AS live_stats_7,
  t0.title_slug_fr AS title_slug_fr_8,
  t0.is_enabled AS is_enabled_9,
  t0.keywords AS keywords_10,
  t0.price_is_active AS price_is_active_11,
  t0.availability_is_active AS availability_is_active_12,
  t0.condition_is_active AS condition_is_active_13,
  t0.long_description AS long_description_14,
  t0.long_description_html AS long_description_html_15,
  t0.filter_price AS filter_price_16,
  t0.title_de AS title_de_17,
  t0.title_en AS title_en_18,
  t0.title_slug_de AS title_slug_de_19,
  t0.title_slug_en AS title_slug_en_20,
  t0.description_de AS description_de_21,
  t0.description_en AS description_en_22,
  t0.keywords_en AS keywords_en_23,
  t0.keywords_de AS keywords_de_24,
  t0.long_description_de AS long_description_de_25,
  t0.long_description_en AS long_description_en_26,
  t0.long_description_html_en AS long_description_html_en_27,
  t0.long_description_html_de AS long_description_html_de_28,
  t0.category_id AS category_id_29,
  t0.price_id AS price_id_30,
  t0.product_availability_id AS product_availability_id_31,
  t0.product_condition_id AS product_condition_id_32,
  t0.supplier_id AS supplier_id_33
FROM
  Product t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.title_de AS title_de_17, t0.title_en AS title_en_18, t0.title_slug_de AS title_slug_de_19, t0.title_slug_en AS title_slug_en_20, t0.description_de AS description_de_21, t0.description_en AS description_en_22, t0.keywords_en AS keywords_en_23, t0.keywords_de AS keywords_de_24, t0.long_description_de AS long_description_de_25, t0.long_description_en AS long_description_en_26, t0.long_description_html_en AS long_description_html_en_27, t0.long_description_html_de AS long_description_html_de_28, t0.category_id AS category_id_29, t0.price_id AS price_id_30, t0.product_availability_id AS product_availability_id_31, t0.product_condition_id AS product_condition_id_32, t0.supplier_id AS supplier_id_33 FROM Product t0 WHERE t0.category_id = 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 515)
8	App\Controller\AnonymousController->department (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

3.53 ms
(14.26%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.categories_id AS categories_id_3 FROM categories_banner t0 WHERE t0.categories_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.categories_id AS categories_id_3
FROM
  categories_banner t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.categories_id AS categories_id_3 FROM categories_banner t0 WHERE t0.categories_id = 22;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 74)
10	__TwigTemplate_a18baebd99f4a301384b551130853aaa->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 177)
13	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->block_body (line 171)
14	Twig\Template->displayBlock (line 167)
15	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 51)
18	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
27	App\Controller\AnonymousController->department (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.36 ms
(5.49%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.menu_ranking AS menu_ranking_14,
  t0.title_de AS title_de_15,
  t0.title_slug_de AS title_slug_de_16,
  t0.title_en AS title_en_17,
  t0.title_slug_en AS title_slug_en_18,
  t0.description_de AS description_de_19,
  t0.description_en AS description_en_20,
  t0.keywords_de AS keywords_de_21,
  t0.keywords_en AS keywords_en_22,
  t0.seo_title_fr AS seo_title_fr_23,
  t0.seo_title_en AS seo_title_en_24,
  t0.seo_title_de AS seo_title_de_25,
  t0.parent_category_id AS parent_category_id_26
FROM
  categories t0

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 552)
5	App\Controller\AnonymousController->department (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.29 ms
(5.23%)

SELECT t0.id AS id_1, t0.rating_number AS rating_number_2, t0.full_name AS full_name_3, t0.comment AS comment_4, t0.is_visible AS is_visible_5, t0.user_logged_in AS user_logged_in_6, t0.verified_purchase AS verified_purchase_7, t0.created_at AS created_at_8, t0.customer_email AS customer_email_9, t0.is_fake AS is_fake_10, t0.product_id AS product_id_11 FROM product_review t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rating_number AS rating_number_2,
  t0.full_name AS full_name_3,
  t0.comment AS comment_4,
  t0.is_visible AS is_visible_5,
  t0.user_logged_in AS user_logged_in_6,
  t0.verified_purchase AS verified_purchase_7,
  t0.created_at AS created_at_8,
  t0.customer_email AS customer_email_9,
  t0.is_fake AS is_fake_10,
  t0.product_id AS product_id_11
FROM
  product_review t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.rating_number AS rating_number_2, t0.full_name AS full_name_3, t0.comment AS comment_4, t0.is_visible AS is_visible_5, t0.user_logged_in AS user_logged_in_6, t0.verified_purchase AS verified_purchase_7, t0.created_at AS created_at_8, t0.customer_email AS customer_email_9, t0.is_fake AS is_fake_10, t0.product_id AS product_id_11 FROM product_review t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 264)
8	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->block_body (line 171)
9	Twig\Template->displayBlock (line 167)
10	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 51)
13	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
22	App\Controller\AnonymousController->department (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.95 ms
(3.84%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.content AS content_4, t0.content_html AS content_html_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enforcement_at AS enforcement_at_8, t0.is_enabled AS is_enabled_9, t0.random_number AS random_number_10, t0.indice AS indice_11 FROM legal_pages t0 WHERE t0.is_enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_slug_fr AS title_slug_fr_3,
  t0.content AS content_4,
  t0.content_html AS content_html_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.enforcement_at AS enforcement_at_8,
  t0.is_enabled AS is_enabled_9,
  t0.random_number AS random_number_10,
  t0.indice AS indice_11
FROM
  legal_pages t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.content AS content_4, t0.content_html AS content_html_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enforcement_at AS enforcement_at_8, t0.is_enabled AS is_enabled_9, t0.random_number AS random_number_10, t0.indice AS indice_11 FROM legal_pages t0 WHERE t0.is_enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 553)
4	App\Controller\AnonymousController->department (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.93 ms
(3.74%)

SELECT t0.id AS id_1, t0.platform_title AS platform_title_2, t0.is_active AS is_active_3, t0.description AS description_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6 FROM platform_data t0 WHERE t0.is_active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.platform_title AS platform_title_2,
  t0.is_active AS is_active_3,
  t0.description AS description_4,
  t0.start_at AS start_at_5,
  t0.end_at AS end_at_6
FROM
  platform_data t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.platform_title AS platform_title_2, t0.is_active AS is_active_3, t0.description AS description_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6 FROM platform_data t0 WHERE t0.is_active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 447)
4	App\Controller\AnonymousController->department (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.81 ms
(3.25%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.title_slug_fr = ? LIMIT 1

Parameters:

[
  "Salons-et-Ensembles-de-Jardin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.menu_ranking AS menu_ranking_14,
  t0.title_de AS title_de_15,
  t0.title_slug_de AS title_slug_de_16,
  t0.title_en AS title_en_17,
  t0.title_slug_en AS title_slug_en_18,
  t0.description_de AS description_de_19,
  t0.description_en AS description_en_20,
  t0.keywords_de AS keywords_de_21,
  t0.keywords_en AS keywords_en_22,
  t0.seo_title_fr AS seo_title_fr_23,
  t0.seo_title_en AS seo_title_en_24,
  t0.seo_title_de AS seo_title_de_25,
  t0.parent_category_id AS parent_category_id_26
FROM
  categories t0
WHERE
  t0.title_slug_fr = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.title_slug_fr = 'Salons-et-Ensembles-de-Jardin' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.67 ms
(2.70%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.parent_category_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.menu_ranking AS menu_ranking_14,
  t0.title_de AS title_de_15,
  t0.title_slug_de AS title_slug_de_16,
  t0.title_en AS title_en_17,
  t0.title_slug_en AS title_slug_en_18,
  t0.description_de AS description_de_19,
  t0.description_en AS description_en_20,
  t0.keywords_de AS keywords_de_21,
  t0.keywords_en AS keywords_en_22,
  t0.seo_title_fr AS seo_title_fr_23,
  t0.seo_title_en AS seo_title_en_24,
  t0.seo_title_de AS seo_title_de_25,
  t0.parent_category_id AS parent_category_id_26
FROM
  categories t0
WHERE
  t0.parent_category_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.parent_category_id = 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 172)
10	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->block_body (line 171)
11	Twig\Template->displayBlock (line 167)
12	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
24	App\Controller\AnonymousController->department (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.64 ms
(2.59%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 INNER JOIN category_association_categories ON t0.id = category_association_categories.categories_id WHERE category_association_categories.category_association_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.menu_ranking AS menu_ranking_14,
  t0.title_de AS title_de_15,
  t0.title_slug_de AS title_slug_de_16,
  t0.title_en AS title_en_17,
  t0.title_slug_en AS title_slug_en_18,
  t0.description_de AS description_de_19,
  t0.description_en AS description_en_20,
  t0.keywords_de AS keywords_de_21,
  t0.keywords_en AS keywords_en_22,
  t0.seo_title_fr AS seo_title_fr_23,
  t0.seo_title_en AS seo_title_en_24,
  t0.seo_title_de AS seo_title_de_25,
  t0.parent_category_id AS parent_category_id_26
FROM
  categories t0
  INNER JOIN category_association_categories ON t0.id = category_association_categories.categories_id
WHERE
  category_association_categories.category_association_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 INNER JOIN category_association_categories ON t0.id = category_association_categories.categories_id WHERE category_association_categories.category_association_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 526)
8	App\Controller\AnonymousController->department (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.62 ms
(2.52%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.is_pin = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.identifier_value AS identifier_value_3,
  t0.live_stats AS live_stats_4,
  t0.description AS description_5,
  t0.title_slug_fr AS title_slug_fr_6,
  t0.keywords AS keywords_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_pin AS is_pin_9,
  t0.date AS date_10,
  t0.icon_library_value AS icon_library_value_11,
  t0.parent_identifier_value AS parent_identifier_value_12,
  t0.file_created AS file_created_13,
  t0.menu_ranking AS menu_ranking_14,
  t0.title_de AS title_de_15,
  t0.title_slug_de AS title_slug_de_16,
  t0.title_en AS title_en_17,
  t0.title_slug_en AS title_slug_en_18,
  t0.description_de AS description_de_19,
  t0.description_en AS description_en_20,
  t0.keywords_de AS keywords_de_21,
  t0.keywords_en AS keywords_en_22,
  t0.seo_title_fr AS seo_title_fr_23,
  t0.seo_title_en AS seo_title_en_24,
  t0.seo_title_de AS seo_title_de_25,
  t0.parent_category_id AS parent_category_id_26
FROM
  categories t0
WHERE
  t0.is_pin = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.is_pin = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 489)
4	App\Controller\AnonymousController->department (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.51 ms
(2.07%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_favicon t0 WHERE t0.platform_data_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.platform_data_id AS platform_data_id_3
FROM
  platform_favicon t0
WHERE
  t0.platform_data_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_favicon t0 WHERE t0.platform_data_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 83)
8	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 51)
11	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
20	App\Controller\AnonymousController->department (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.49 ms
(1.99%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_logo t0 WHERE t0.platform_data_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.platform_data_id AS platform_data_id_3
FROM
  platform_logo t0
WHERE
  t0.platform_data_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_logo t0 WHERE t0.platform_data_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 72)
8	__TwigTemplate_21ba7a042b425dc30a437adc0c6c9f14->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 164)
11	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 51)
14	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
23	App\Controller\AnonymousController->department (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.48 ms
(1.95%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_fr_slug AS title_fr_slug_3, t0.code AS code_4, t0.exchange_rate AS exchange_rate_5, t0.is_enabled AS is_enabled_6, t0.is_default_currency AS is_default_currency_7 FROM currency t0 INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id WHERE platform_data_currency.platform_data_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_fr_slug AS title_fr_slug_3,
  t0.code AS code_4,
  t0.exchange_rate AS exchange_rate_5,
  t0.is_enabled AS is_enabled_6,
  t0.is_default_currency AS is_default_currency_7
FROM
  currency t0
  INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id
WHERE
  platform_data_currency.platform_data_id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_fr_slug AS title_fr_slug_3, t0.code AS code_4, t0.exchange_rate AS exchange_rate_5, t0.is_enabled AS is_enabled_6, t0.is_default_currency AS is_default_currency_7 FROM currency t0 INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id WHERE platform_data_currency.platform_data_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 448)
8	App\Controller\AnonymousController->department (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.40 ms
(1.63%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.is_sale_price AS is_sale_price_4, t0.sale_price_effective_date_start AS sale_price_effective_date_start_5, t0.sale_price_effective_date_end AS sale_price_effective_date_end_6, t0.is_sale_effective_date AS is_sale_effective_date_7 FROM product_price t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.sale_price AS sale_price_3,
  t0.is_sale_price AS is_sale_price_4,
  t0.sale_price_effective_date_start AS sale_price_effective_date_start_5,
  t0.sale_price_effective_date_end AS sale_price_effective_date_end_6,
  t0.is_sale_effective_date AS is_sale_effective_date_7
FROM
  product_price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.is_sale_price AS is_sale_price_4, t0.sale_price_effective_date_start AS sale_price_effective_date_start_5, t0.sale_price_effective_date_end AS sale_price_effective_date_end_6, t0.is_sale_effective_date AS is_sale_effective_date_7 FROM product_price t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\ProductPrice::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\ProductPrice->__get (line 64)
8	App\Entity\ProductPrice->getSalePrice (line 1635)
9	twig_get_attribute (line 578)
10	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->block_body (line 171)
11	Twig\Template->displayBlock (line 167)
12	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
24	App\Controller\AnonymousController->department (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.40 ms
(1.62%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.product_id AS product_id_3
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 487)
10	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->block_body (line 171)
11	Twig\Template->displayBlock (line 167)
12	__TwigTemplate_0bb6da03930fad43dce4f00a02119830->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_686540d6dfa477598f5212d1e6b3eb86->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 555)
24	App\Controller\AnonymousController->department (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.32 ms
(1.30%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.live_stats AS live_stats_4, t0.identifier_value AS identifier_value_5, t0.category_id AS category_id_6 FROM category_association t0 WHERE t0.identifier_value = ?

Parameters:

[
  "1.0.0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_fr AS title_fr_2,
  t0.title_slug_fr AS title_slug_fr_3,
  t0.live_stats AS live_stats_4,
  t0.identifier_value AS identifier_value_5,
  t0.category_id AS category_id_6
FROM
  category_association t0
WHERE
  t0.identifier_value = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.live_stats AS live_stats_4, t0.identifier_value AS identifier_value_5, t0.category_id AS category_id_6 FROM category_association t0 WHERE t0.identifier_value = '1.0.0';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 490)
4	App\Controller\AnonymousController->department (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Categories	No errors.
App\Entity\CategoriesBanner	No errors.
App\Entity\CategoriesIcon	No errors.
App\Entity\Product	No errors.
App\Entity\ProductAssociation	No errors.
App\Entity\CategoryWarranty	No errors.
App\Entity\PlatformData	No errors.
App\Entity\PlatformLogo	No errors.
App\Entity\PlatformFavicon	No errors.
App\Entity\Currency	No errors.
App\Entity\Locale	No errors.
App\Entity\PageConfig	No errors.
App\Entity\Countries	No errors.
App\Entity\ShippingMethodChannel	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\ShippingMethodRate	No errors.
App\Entity\Order	No errors.
App\Entity\CategoryAssociation	The association App\Entity\CategoryAssociation#category refers to the inverse side field App\Entity\Categories#categoryAssociations which does not exist. The association App\Entity\CategoryAssociation#sub_categories refers to the inverse side field App\Entity\Categories#categoryAssociations which does not exist.
App\Entity\ProductPrice	No errors.
App\Entity\ProductAvailability	No errors.
App\Entity\ProductCondition	No errors.
App\Entity\ProductSupplier	No errors.
App\Entity\ProductVariable	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductAdditionalImage	No errors.
App\Entity\ProductAttributeValue	No errors.
App\Entity\ProductMultipack	No errors.
App\Entity\ProductBundle	No errors.
App\Entity\ProductReview	No errors.
App\Entity\ProductAdditionalDetails	No errors.
App\Entity\Tags	No errors.
App\Entity\ProductWarranty	No errors.
App\Entity\LegalPages	No errors.

Symfony Profiler

GET https://expresskauf.com/Categories/Salons-et-Ensembles-de-Jardin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping