Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.38 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(31.46%)

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.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 WHERE t0.id = ?

Parameters:

[
  "14"
]

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.category_id AS category_id_17,
  t0.price_id AS price_id_18,
  t0.product_availability_id AS product_availability_id_19,
  t0.product_condition_id AS product_condition_id_20,
  t0.supplier_id AS supplier_id_21
FROM
  Product t0
WHERE
  t0.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.category_id AS category_id_17, t0.price_id AS price_id_18, t0.product_availability_id AS product_availability_id_19, t0.product_condition_id AS product_condition_id_20, t0.supplier_id AS supplier_id_21 FROM Product t0 WHERE t0.id = '14';

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.90 ms
(20.64%)

SELECT t0.id AS id_1, t0.product_condition_id AS product_condition_id_2 FROM product_condition t0 WHERE t0.id = ?

Parameters:

[
  "14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_condition_id AS product_condition_id_2
FROM
  product_condition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.product_condition_id AS product_condition_id_2 FROM product_condition t0 WHERE t0.id = '14';

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.48 ms
(10.86%)

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 88)
8	__TwigTemplate_11e79cd5556cd7c1d42ce4d868ebbcbc->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 49)
11	__TwigTemplate_2ac89e954131854bc7bd289bb0c1cc67->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 1244)
20	App\Controller\HelpdeskController->editProductCondition (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.46 ms
(10.41%)

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.value AS value_3, t0.title_fr_slug AS title_fr_slug_4, t0.description_fr AS description_fr_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM product_condition_value t0 WHERE t0.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.value AS value_3,
  t0.title_fr_slug AS title_fr_slug_4,
  t0.description_fr AS description_fr_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  product_condition_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.value AS value_3, t0.title_fr_slug AS title_fr_slug_4, t0.description_fr AS description_fr_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM product_condition_value 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\ProductConditionValue::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 102)
7	Proxies\__CG__\App\Entity\ProductConditionValue->__load (line 3688)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 959)
9	Doctrine\ORM\EntityManager->initializeObject (line 89)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
16	Symfony\Component\Form\Form->normToView (line 301)
17	Symfony\Component\Form\Form->setData (line 50)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
19	Symfony\Component\Form\Form->setData (line 412)
20	Symfony\Component\Form\Form->initialize (line 176)
21	Symfony\Component\Form\FormBuilder->getForm (line 28)
22	Symfony\Component\Form\FormFactory->create (line 340)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 1225)
24	App\Controller\HelpdeskController->editProductCondition (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.41 ms
(9.38%)

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 1244)
4	App\Controller\HelpdeskController->editProductCondition (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.40 ms
(9.02%)

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 55)
8	__TwigTemplate_c824ecbcd2608a5971e9588b27dd37db->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 137)
11	__TwigTemplate_11e79cd5556cd7c1d42ce4d868ebbcbc->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 49)
14	__TwigTemplate_2ac89e954131854bc7bd289bb0c1cc67->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 1244)
23	App\Controller\HelpdeskController->editProductCondition (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.36 ms
(8.22%)

SELECT p0_.id AS id_0, p0_.title_fr AS title_fr_1, p0_.value AS value_2, p0_.title_fr_slug AS title_fr_slug_3, p0_.description_fr AS description_fr_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM product_condition_value p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title_fr AS title_fr_1,
  p0_.value AS value_2,
  p0_.title_fr_slug AS title_fr_slug_3,
  p0_.description_fr AS description_fr_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6
FROM
  product_condition_value p0_

SELECT p0_.id AS id_0, p0_.title_fr AS title_fr_1, p0_.value AS value_2, p0_.title_fr_slug AS title_fr_slug_3, p0_.description_fr AS description_fr_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM product_condition_value p0_;

#	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 440)
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 1244)
24	App\Controller\HelpdeskController->editProductCondition (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)

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\Product	No errors.
App\Entity\Categories	No errors.
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\Order	No errors.
App\Entity\ProductReview	No errors.
App\Entity\ProductAdditionalDetails	No errors.
App\Entity\Tags	No errors.
App\Entity\ProductWarranty	No errors.
App\Entity\ProductConditionValue	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\CategoriesBanner	No errors.
App\Entity\CategoriesIcon	No errors.
App\Entity\ProductAssociation	No errors.
App\Entity\CategoryWarranty	No errors.
App\Entity\ProductAvailabilityValue	No errors.
App\Entity\ProductSupplierFile	No errors.
App\Entity\ProductInstallment	No errors.
App\Entity\ProductReturn	No errors.
App\Entity\ProductStock	No errors.
App\Entity\ProductSubscription	No errors.
App\Entity\ProductAgeGroup	No errors.
App\Entity\ProductEnergyClass	No errors.
App\Entity\ProductSizeSystem	No errors.
App\Entity\ProductSizeType	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductOption	No errors.
App\Entity\DeliveryAddress	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\PaymentMethod	No errors.
App\Entity\SpecialOffer	No errors.
App\Entity\Warranty	No errors.
App\Entity\Countries	No errors.
App\Entity\ShippingMethodChannel	No errors.
App\Entity\ShippingMethodRate	No errors.
App\Entity\LocaleMobileImg	No errors.
App\Entity\PageConfigFiles	No errors.
App\Entity\PageConfigPart	No errors.
App\Entity\PageConfigLinkVar	No errors.

Symfony Profiler

GET https://expresskauf.com/helpdesk/gestion/marketplace/configurations/produit/14/etat/mise-a-jour/13

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping