Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

4 Database Queries

3 Different statements

4.23 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.93 ms

SELECT t0.id AS id_1, t0.ean AS ean_2, t0.code AS code_3, t0.reserve AS reserve_4, t0.name AS name_5, t0.name_fr AS name_fr_6, t0.name_nl AS name_nl_7, t0.description AS description_8, t0.description_fr AS description_fr_9, t0.description_nl AS description_nl_10, t0.remarks AS remarks_11, t0.text_fr AS text_fr_12, t0.remarks_nl AS remarks_nl_13, t0.online AS online_14, t0.endoflife AS endoflife_15, t0.new AS new_16, t0.diameter AS diameter_17, t0.price AS price_18, t0.purchaseprice AS purchaseprice_19, t0.supplierref AS supplierref_20, t0.stock AS stock_21, t0.createdat AS createdat_22, t0.updatedat AS updatedat_23, t0.sort AS sort_24, t0.remarks_fr AS remarks_fr_25, t0.promo AS promo_26, t0.configurator AS configurator_27, t0.parent_id AS parent_id_28 FROM product t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ean AS ean_2,
  t0.code AS code_3,
  t0.reserve AS reserve_4,
  t0.name AS name_5,
  t0.name_fr AS name_fr_6,
  t0.name_nl AS name_nl_7,
  t0.description AS description_8,
  t0.description_fr AS description_fr_9,
  t0.description_nl AS description_nl_10,
  t0.remarks AS remarks_11,
  t0.text_fr AS text_fr_12,
  t0.remarks_nl AS remarks_nl_13,
  t0.online AS online_14,
  t0.endoflife AS endoflife_15,
  t0.new AS new_16,
  t0.diameter AS diameter_17,
  t0.price AS price_18,
  t0.purchaseprice AS purchaseprice_19,
  t0.supplierref AS supplierref_20,
  t0.stock AS stock_21,
  t0.createdat AS createdat_22,
  t0.updatedat AS updatedat_23,
  t0.sort AS sort_24,
  t0.remarks_fr AS remarks_fr_25,
  t0.promo AS promo_26,
  t0.configurator AS configurator_27,
  t0.parent_id AS parent_id_28
FROM
  product t0

SELECT t0.id AS id_1, t0.ean AS ean_2, t0.code AS code_3, t0.reserve AS reserve_4, t0.name AS name_5, t0.name_fr AS name_fr_6, t0.name_nl AS name_nl_7, t0.description AS description_8, t0.description_fr AS description_fr_9, t0.description_nl AS description_nl_10, t0.remarks AS remarks_11, t0.text_fr AS text_fr_12, t0.remarks_nl AS remarks_nl_13, t0.online AS online_14, t0.endoflife AS endoflife_15, t0.new AS new_16, t0.diameter AS diameter_17, t0.price AS price_18, t0.purchaseprice AS purchaseprice_19, t0.supplierref AS supplierref_20, t0.stock AS stock_21, t0.createdat AS createdat_22, t0.updatedat AS updatedat_23, t0.sort AS sort_24, t0.remarks_fr AS remarks_fr_25, t0.promo AS promo_26, t0.configurator AS configurator_27, t0.parent_id AS parent_id_28 FROM product t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 137)
5	App\Controller\DefaultController->products (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)

0.72 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_fr AS name_fr_4, t0.name_nl AS name_nl_5, t0.content AS content_6, t0.content_nl AS content_nl_7, t0.content_fr AS content_fr_8, t0.public AS public_9, t0.mgmt AS mgmt_10, t0.sort AS sort_11, t0.cookbook_id AS cookbook_id_12, t0.parent_id AS parent_id_13 FROM tag t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_fr AS name_fr_4,
  t0.name_nl AS name_nl_5,
  t0.content AS content_6,
  t0.content_nl AS content_nl_7,
  t0.content_fr AS content_fr_8,
  t0.public AS public_9,
  t0.mgmt AS mgmt_10,
  t0.sort AS sort_11,
  t0.cookbook_id AS cookbook_id_12,
  t0.parent_id AS parent_id_13
FROM
  tag t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_fr AS name_fr_4, t0.name_nl AS name_nl_5, t0.content AS content_6, t0.content_nl AS content_nl_7, t0.content_fr AS content_fr_8, t0.public AS public_9, t0.mgmt AS mgmt_10, t0.sort AS sort_11, t0.cookbook_id AS cookbook_id_12, t0.parent_id AS parent_id_13 FROM tag t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 140)
4	App\Controller\DefaultController->products (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)

1.35 ms

SELECT t0.id AS id_1, t0.fileorder AS fileorder_2, t0.product_id AS product_id_3, t0.file_id AS file_id_4 FROM product_file 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.fileorder AS fileorder_2,
  t0.product_id AS product_id_3,
  t0.file_id AS file_id_4
FROM
  product_file t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.fileorder AS fileorder_2, t0.product_id AS product_id_3, t0.file_id AS file_id_4 FROM product_file t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 472)
8	App\Entity\Product->getFirstfile (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 157)
10	__TwigTemplate_54cdad773151f9c62e08984f96434668->block_body (line 430)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_8297814f7555ba728d2cf8715147737a->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_54cdad773151f9c62e08984f96434668->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
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 150)
22	App\Controller\DefaultController->products (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)

1.23 ms

SELECT t0.id AS id_1, t0.fileorder AS fileorder_2, t0.product_id AS product_id_3, t0.file_id AS file_id_4 FROM product_file t0 WHERE t0.product_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fileorder AS fileorder_2,
  t0.product_id AS product_id_3,
  t0.file_id AS file_id_4
FROM
  product_file t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.fileorder AS fileorder_2, t0.product_id AS product_id_3, t0.file_id AS file_id_4 FROM product_file t0 WHERE t0.product_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 472)
8	App\Entity\Product->getFirstfile (line 1629)
9	Twig\Extension\CoreExtension::getAttribute (line 157)
10	__TwigTemplate_54cdad773151f9c62e08984f96434668->block_body (line 430)
11	Twig\Template->yieldBlock (line 161)
12	__TwigTemplate_8297814f7555ba728d2cf8715147737a->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_54cdad773151f9c62e08984f96434668->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
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 150)
22	App\Controller\DefaultController->products (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)

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\ProductTag	No errors.
App\Entity\ProductFile	No errors.
App\Entity\OrderItem	No errors.
App\Entity\ProductProperty	No errors.
App\Entity\OfferLine	No errors.
App\Entity\Tag	No errors.
App\Entity\TagFile	No errors.
App\Entity\Task	No errors.
App\Entity\Fileasset	No errors.

Symfony Profiler

GET https://www.davinciplatform.be/products/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping