Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

103.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

82.80 ms
(80.17%)

SELECT p0_.id AS id_0, p0_.product_id AS product_id_1, p0_.reference_price_cents AS reference_price_cents_2, p0_.adjusted_price_cents AS adjusted_price_cents_3, p0_.min_selling_price_cents AS min_selling_price_cents_4, p0_.deposit_price_cents AS deposit_price_cents_5, p0_.effective_margin_bps AS effective_margin_bps_6, p0_.seller_account_id AS seller_account_id_7 FROM price_seller_snapshot p0_ WHERE p0_.product_id = ?

Parameters:

[
  2958833
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.product_id AS product_id_1,
  p0_.reference_price_cents AS reference_price_cents_2,
  p0_.adjusted_price_cents AS adjusted_price_cents_3,
  p0_.min_selling_price_cents AS min_selling_price_cents_4,
  p0_.deposit_price_cents AS deposit_price_cents_5,
  p0_.effective_margin_bps AS effective_margin_bps_6,
  p0_.seller_account_id AS seller_account_id_7
FROM
  price_seller_snapshot p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0, p0_.product_id AS product_id_1, p0_.reference_price_cents AS reference_price_cents_2, p0_.adjusted_price_cents AS adjusted_price_cents_3, p0_.min_selling_price_cents AS min_selling_price_cents_4, p0_.deposit_price_cents AS deposit_price_cents_5, p0_.effective_margin_bps AS effective_margin_bps_6, p0_.seller_account_id AS seller_account_id_7 FROM price_seller_snapshot p0_ WHERE p0_.product_id = 2958833;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\PriceSellerSnapshotRepository->findByProductId (line 27)
8	App\Twig\SellerSnapshotExtension->getSellerSnapshots (line 144)
9	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->block_content (line 432)
10	Twig\Template->yieldBlock (line 1220)
11	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_main_content_wrapper (line 432)
12	Twig\Template->yieldBlock (line 924)
13	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper (line 432)
14	Twig\Template->yieldBlock (line 753)
15	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper_wrapper (line 432)
16	Twig\Template->yieldBlock (line 491)
17	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_body (line 432)
18	Twig\Template->yieldBlock (line 154)
19	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 49)
27	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 4)

8.96 ms
(8.67%)

SELECT t0.id AS id_1, t0.article_number AS article_number_2, t0.search_number AS search_number_3, t0.designation AS designation_4, t0.blocked AS blocked_5, t0.current_price AS current_price_6, t0.internal_quantity AS internal_quantity_7, t0.internal_quantity_bef AS internal_quantity_bef_8, t0.fix_price_daparto AS fix_price_daparto_9, t0.fix_price_tyre AS fix_price_tyre_10, t0.fix_price_am AS fix_price_am_11, t0.fix_price_am_b2b AS fix_price_am_b2b_12, t0.calculated_price_daparto AS calculated_price_daparto_13, t0.calculated_price_am AS calculated_price_am_14, t0.calculated_price_am_b2b AS calculated_price_am_b2b_15, t0.calculated_price_tyre AS calculated_price_tyre_16, t0.calculated_price_gettygo AS calculated_price_gettygo_17, t0.min_price_daparto AS min_price_daparto_18, t0.min_price_tyre AS min_price_tyre_19, t0.min_price_am AS min_price_am_20, t0.min_price_am_b2b AS min_price_am_b2b_21, t0.update_date AS update_date_22, t0.fix_fix_price_daparto AS fix_fix_price_daparto_23, t0.fix_fix_price_tyre AS fix_fix_price_tyre_24, t0.fix_fix_price_am AS fix_fix_price_am_25, t0.cheapest_id AS cheapest_id_26, t0.brand_id AS brand_id_27, t0.cheapest_id AS cheapest_id_28 FROM product t0 WHERE t0.id = ?

Parameters:

[
  "2958833"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.article_number AS article_number_2,
  t0.search_number AS search_number_3,
  t0.designation AS designation_4,
  t0.blocked AS blocked_5,
  t0.current_price AS current_price_6,
  t0.internal_quantity AS internal_quantity_7,
  t0.internal_quantity_bef AS internal_quantity_bef_8,
  t0.fix_price_daparto AS fix_price_daparto_9,
  t0.fix_price_tyre AS fix_price_tyre_10,
  t0.fix_price_am AS fix_price_am_11,
  t0.fix_price_am_b2b AS fix_price_am_b2b_12,
  t0.calculated_price_daparto AS calculated_price_daparto_13,
  t0.calculated_price_am AS calculated_price_am_14,
  t0.calculated_price_am_b2b AS calculated_price_am_b2b_15,
  t0.calculated_price_tyre AS calculated_price_tyre_16,
  t0.calculated_price_gettygo AS calculated_price_gettygo_17,
  t0.min_price_daparto AS min_price_daparto_18,
  t0.min_price_tyre AS min_price_tyre_19,
  t0.min_price_am AS min_price_am_20,
  t0.min_price_am_b2b AS min_price_am_b2b_21,
  t0.update_date AS update_date_22,
  t0.fix_fix_price_daparto AS fix_fix_price_daparto_23,
  t0.fix_fix_price_tyre AS fix_fix_price_tyre_24,
  t0.fix_fix_price_am AS fix_fix_price_am_25,
  t0.cheapest_id AS cheapest_id_26,
  t0.brand_id AS brand_id_27,
  t0.cheapest_id AS cheapest_id_28
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.article_number AS article_number_2, t0.search_number AS search_number_3, t0.designation AS designation_4, t0.blocked AS blocked_5, t0.current_price AS current_price_6, t0.internal_quantity AS internal_quantity_7, t0.internal_quantity_bef AS internal_quantity_bef_8, t0.fix_price_daparto AS fix_price_daparto_9, t0.fix_price_tyre AS fix_price_tyre_10, t0.fix_price_am AS fix_price_am_11, t0.fix_price_am_b2b AS fix_price_am_b2b_12, t0.calculated_price_daparto AS calculated_price_daparto_13, t0.calculated_price_am AS calculated_price_am_14, t0.calculated_price_am_b2b AS calculated_price_am_b2b_15, t0.calculated_price_tyre AS calculated_price_tyre_16, t0.calculated_price_gettygo AS calculated_price_gettygo_17, t0.min_price_daparto AS min_price_daparto_18, t0.min_price_tyre AS min_price_tyre_19, t0.min_price_am AS min_price_am_20, t0.min_price_am_b2b AS min_price_am_b2b_21, t0.update_date AS update_date_22, t0.fix_fix_price_daparto AS fix_fix_price_daparto_23, t0.fix_fix_price_tyre AS fix_fix_price_tyre_24, t0.fix_fix_price_am AS fix_fix_price_am_25, t0.cheapest_id AS cheapest_id_26, t0.brand_id AS brand_id_27, t0.cheapest_id AS cheapest_id_28 FROM product t0 WHERE t0.id = '2958833';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 146)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 254)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 141)
11	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 4)

3.49 ms
(3.38%)

SELECT t0.id AS id_1, t0.discount AS discount_2, t0.waregroup_id AS waregroup_id_3, t0.product_supplier_id AS product_supplier_id_4, t0.brand_id AS brand_id_5 FROM buy_price_calculation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.discount AS discount_2,
  t0.waregroup_id AS waregroup_id_3,
  t0.product_supplier_id AS product_supplier_id_4,
  t0.brand_id AS brand_id_5
FROM
  buy_price_calculation t0

SELECT t0.id AS id_1, t0.discount AS discount_2, t0.waregroup_id AS waregroup_id_3, t0.product_supplier_id AS product_supplier_id_4, t0.brand_id AS brand_id_5 FROM buy_price_calculation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 22)
5	App\Service\DiscountCalculator->__construct (line 2283)
6	ContainerM8xnvTP\App_KernelDevDebugContainer::getTwigService (line 606)
7	ContainerM8xnvTP\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1383)
8	ContainerM8xnvTP\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 937)
9	ContainerM8xnvTP\App_KernelDevDebugContainer::{closure:ContainerM8xnvTP\App_KernelDevDebugContainer::getEventDispatcherService():937} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 4)

2.44 ms
(2.37%)

SELECT t0.id AS id_1, t0.supplier_number AS supplier_number_2, t0.price_list_price AS price_list_price_3, t0.calculated_price AS calculated_price_4, t0.pricelist_deposit AS pricelist_deposit_5, t0.calculated_deposit AS calculated_deposit_6, t0.quantity AS quantity_7, t0.last_quantity AS last_quantity_8, t0.price_update AS price_update_9, t0.quantity_update AS quantity_update_10, t0.blocked AS blocked_11, t0.last_price AS last_price_12, t0.product_supplier_id AS product_supplier_id_13, t0.product_id AS product_id_14, t0.waregroup_id AS waregroup_id_15 FROM product_price_and_quantity t0 WHERE t0.id = ?

Parameters:

[
  21711548
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.supplier_number AS supplier_number_2,
  t0.price_list_price AS price_list_price_3,
  t0.calculated_price AS calculated_price_4,
  t0.pricelist_deposit AS pricelist_deposit_5,
  t0.calculated_deposit AS calculated_deposit_6,
  t0.quantity AS quantity_7,
  t0.last_quantity AS last_quantity_8,
  t0.price_update AS price_update_9,
  t0.quantity_update AS quantity_update_10,
  t0.blocked AS blocked_11,
  t0.last_price AS last_price_12,
  t0.product_supplier_id AS product_supplier_id_13,
  t0.product_id AS product_id_14,
  t0.waregroup_id AS waregroup_id_15
FROM
  product_price_and_quantity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.supplier_number AS supplier_number_2, t0.price_list_price AS price_list_price_3, t0.calculated_price AS calculated_price_4, t0.pricelist_deposit AS pricelist_deposit_5, t0.calculated_deposit AS calculated_deposit_6, t0.quantity AS quantity_7, t0.last_quantity AS last_quantity_8, t0.price_update AS price_update_9, t0.quantity_update AS quantity_update_10, t0.blocked AS blocked_11, t0.last_price AS last_price_12, t0.product_supplier_id AS product_supplier_id_13, t0.product_id AS product_id_14, t0.waregroup_id AS waregroup_id_15 FROM product_price_and_quantity t0 WHERE t0.id = 21711548;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Product\ProductPriceAndQuantity::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Product\ProductPriceAndQuantity->__get (line 235)
8	App\Entity\Product\ProductPriceAndQuantity->getCalculatedPrice (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 127)
10	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->block_content (line 432)
11	Twig\Template->yieldBlock (line 1220)
12	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_main_content_wrapper (line 432)
13	Twig\Template->yieldBlock (line 924)
14	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper (line 432)
15	Twig\Template->yieldBlock (line 753)
16	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper_wrapper (line 432)
17	Twig\Template->yieldBlock (line 491)
18	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_body (line 432)
19	Twig\Template->yieldBlock (line 154)
20	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->doDisplay (line 388)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 49)
28	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 4)

1.97 ms
(1.91%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.username AS username_4, t0.roles AS roles_5, t0.password AS password_6, t0.salt AS salt_7 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.email AS email_3,
  t0.username AS username_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.salt AS salt_7
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.username AS username_4, t0.roles AS roles_5, t0.password AS password_6, t0.salt AS salt_7 FROM app_user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 4)

1.86 ms
(1.80%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.designation AS designation_3, t0.active AS active_4, t0.updates_active AS updates_active_5, t0.pricelist_file AS pricelist_file_6, t0.pricelist_file_date AS pricelist_file_date_7 FROM product_supplier t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.designation AS designation_3,
  t0.active AS active_4,
  t0.updates_active AS updates_active_5,
  t0.pricelist_file AS pricelist_file_6,
  t0.pricelist_file_date AS pricelist_file_date_7
FROM
  product_supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.designation AS designation_3, t0.active AS active_4, t0.updates_active AS updates_active_5, t0.pricelist_file AS pricelist_file_6, t0.pricelist_file_date AS pricelist_file_date_7 FROM product_supplier t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Product\ProductSupplier::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Product\ProductSupplier->__get (line 195)
8	App\Entity\Product\ProductSupplier->getUpdatesActive (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 489)
10	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->block_content (line 432)
11	Twig\Template->yieldBlock (line 1220)
12	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_main_content_wrapper (line 432)
13	Twig\Template->yieldBlock (line 924)
14	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper (line 432)
15	Twig\Template->yieldBlock (line 753)
16	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper_wrapper (line 432)
17	Twig\Template->yieldBlock (line 491)
18	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_body (line 432)
19	Twig\Template->yieldBlock (line 154)
20	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->doDisplay (line 388)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 49)
28	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 4)

1.11 ms
(1.07%)

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.td_id AS td_id_3 FROM brand t0 WHERE t0.id = ?

Parameters:

[
  221
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2,
  t0.td_id AS td_id_3
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.td_id AS td_id_3 FROM brand t0 WHERE t0.id = 221;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Product\Brand::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Product\Brand->__get (line 52)
8	App\Entity\Product\Brand->getDesignation (line 124)
9	App\Entity\Product\Product->__toString (line 77)
10	EasyCorp\Bundle\EasyAdminBundle\Dto\EntityDto->toString (line 185)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getI18nDto (line 67)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 141)
13	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 4)

0.64 ms
(0.62%)

SELECT t0.id AS id_1, t0.supplier_number AS supplier_number_2, t0.price_list_price AS price_list_price_3, t0.calculated_price AS calculated_price_4, t0.pricelist_deposit AS pricelist_deposit_5, t0.calculated_deposit AS calculated_deposit_6, t0.quantity AS quantity_7, t0.last_quantity AS last_quantity_8, t0.price_update AS price_update_9, t0.quantity_update AS quantity_update_10, t0.blocked AS blocked_11, t0.last_price AS last_price_12, t0.product_supplier_id AS product_supplier_id_13, t0.product_id AS product_id_14, t0.waregroup_id AS waregroup_id_15 FROM product_price_and_quantity t0 WHERE t0.product_id = ?

Parameters:

[
  2958833
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.supplier_number AS supplier_number_2,
  t0.price_list_price AS price_list_price_3,
  t0.calculated_price AS calculated_price_4,
  t0.pricelist_deposit AS pricelist_deposit_5,
  t0.calculated_deposit AS calculated_deposit_6,
  t0.quantity AS quantity_7,
  t0.last_quantity AS last_quantity_8,
  t0.price_update AS price_update_9,
  t0.quantity_update AS quantity_update_10,
  t0.blocked AS blocked_11,
  t0.last_price AS last_price_12,
  t0.product_supplier_id AS product_supplier_id_13,
  t0.product_id AS product_id_14,
  t0.waregroup_id AS waregroup_id_15
FROM
  product_price_and_quantity t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.supplier_number AS supplier_number_2, t0.price_list_price AS price_list_price_3, t0.calculated_price AS calculated_price_4, t0.pricelist_deposit AS pricelist_deposit_5, t0.calculated_deposit AS calculated_deposit_6, t0.quantity AS quantity_7, t0.last_quantity AS last_quantity_8, t0.price_update AS price_update_9, t0.quantity_update AS quantity_update_10, t0.blocked AS blocked_11, t0.last_price AS last_price_12, t0.product_supplier_id AS product_supplier_id_13, t0.product_id AS product_id_14, t0.waregroup_id AS waregroup_id_15 FROM product_price_and_quantity t0 WHERE t0.product_id = 2958833;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 474)
8	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->block_content (line 432)
9	Twig\Template->yieldBlock (line 1220)
10	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_main_content_wrapper (line 432)
11	Twig\Template->yieldBlock (line 924)
12	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper (line 432)
13	Twig\Template->yieldBlock (line 753)
14	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_wrapper_wrapper (line 432)
15	Twig\Template->yieldBlock (line 491)
16	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->block_body (line 432)
17	Twig\Template->yieldBlock (line 154)
18	__TwigTemplate_5af35b76bd2be4b2c2710c45fce650f2->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_d894a31caef0fee095a32b9b89e2c03a->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 49)
26	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 4)

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\BuyPriceCalculation	No errors.
App\Entity\Product\Waregroup	No errors.
App\Entity\Product\ProductSupplier	No errors.
App\Entity\Product\Brand	No errors.
App\Entity\User	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Product\ProductPriceAndQuantity	No errors.
App\Entity\Product\SellPriceCalculation	No errors.
App\Entity\Product\ImportPriceHistory	No errors.
App\Entity\Product\PriceSellerSnapshot	No errors.
App\Entity\Product\SellerAccount	No errors.

Symfony Profiler

GET https://marktplace.gigant-autoteile.net/product/2958833

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping