Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

7.88 ms Query time

0 Invalid entities

25 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.53 ms
(32.11%)

SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.created_at AS created_at_2,
  t1.updated_at AS updated_at_3,
  t1.id AS id_4,
  t1.roles AS roles_5,
  t1.password AS password_6,
  t1.first_name AS first_name_7,
  t1.last_name AS last_name_8,
  t1.email AS email_9,
  t1.last_login AS last_login_10,
  t1.phone AS phone_11,
  t1.active AS active_12,
  t0.is_verified AS is_verified_13,
  t0.confirmation_token AS confirmation_token_14,
  t0.token_expires_at AS token_expires_at_15,
  t1.user_type
FROM
  customers t0
  INNER JOIN users t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = 0x019E1AD3CABF7963B6F7BE99075E7211;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\User::$name::get (line 41)
5	Twig\Extension\CoreExtension->getAttribute (line 1795)
6	__TwigTemplate_acba1c7ccdf58c04f0ee802e716a8518::doDisplay (line 68)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
13	__TwigTemplate_e64e9c793ae235e52702b2d371c2ee86->doDisplay (line 68)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_dde149a540b532df68455f107565c667->block_body (line 89)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_09ffd07cd81faa75d37f6311c65a1bbf->doDisplay (line 79)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_dde149a540b532df68455f107565c667->doDisplay (line 53)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
28	App\Controller\Main\HomeController->homePage (line 26)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 191)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

1.94 ms
(24.55%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?

Parameters:

[
  b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.id AS id_3,
  t0.customer_id AS customer_id_4
FROM
  carts t0
WHERE
  t0.customer_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = 0x019E1AD3CABF7963B6F7BE99075E7211;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
9	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
10	App\Entity\User::$name::get (line 41)
11	Twig\Extension\CoreExtension->getAttribute (line 1795)
12	__TwigTemplate_acba1c7ccdf58c04f0ee802e716a8518::doDisplay (line 68)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
19	__TwigTemplate_e64e9c793ae235e52702b2d371c2ee86->doDisplay (line 68)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_dde149a540b532df68455f107565c667->block_body (line 89)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_09ffd07cd81faa75d37f6311c65a1bbf->doDisplay (line 79)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_dde149a540b532df68455f107565c667->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
34	App\Controller\Main\HomeController->homePage (line 26)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 191)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

1.65 ms
(20.98%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?

Parameters:

[
  b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.image AS image_3,
  t0.image_directory AS image_directory_4,
  t0.id AS id_5,
  t0.customer_name AS customer_name_6,
  t0.customer_email AS customer_email_7,
  t0.message AS message_8,
  t0.is_disabled AS is_disabled_9,
  t0.customer_id AS customer_id_10
FROM
  testimonials t0
WHERE
  t0.customer_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = 0x019E1AD3CABF7963B6F7BE99075E7211;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
9	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
10	App\Entity\User::$name::get (line 41)
11	Twig\Extension\CoreExtension->getAttribute (line 1795)
12	__TwigTemplate_acba1c7ccdf58c04f0ee802e716a8518::doDisplay (line 68)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
19	__TwigTemplate_e64e9c793ae235e52702b2d371c2ee86->doDisplay (line 68)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_dde149a540b532df68455f107565c667->block_body (line 89)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_09ffd07cd81faa75d37f6311c65a1bbf->doDisplay (line 79)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_dde149a540b532df68455f107565c667->doDisplay (line 53)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
34	App\Controller\Main\HomeController->homePage (line 26)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 191)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

1.03 ms
(13.03%)

SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.image AS image_2, p0_.image_directory AS image_directory_3, p0_.id AS id_4, p0_.name AS name_5, p0_.status AS status_6, p0_.quantity AS quantity_7, p0_.price AS price_8, p0_.short_description AS short_description_9, p0_.detailed_description AS detailed_description_10, p0_.specifications AS specifications_11, p0_.category_id AS category_id_12 FROM products p0_ LEFT JOIN product_categories p1_ ON p0_.category_id = p1_.id ORDER BY p0_.name ASC LIMIT 8

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.created_at AS created_at_0,
  p0_.updated_at AS updated_at_1,
  p0_.image AS image_2,
  p0_.image_directory AS image_directory_3,
  p0_.id AS id_4,
  p0_.name AS name_5,
  p0_.status AS status_6,
  p0_.quantity AS quantity_7,
  p0_.price AS price_8,
  p0_.short_description AS short_description_9,
  p0_.detailed_description AS detailed_description_10,
  p0_.specifications AS specifications_11,
  p0_.category_id AS category_id_12
FROM
  products p0_
  LEFT JOIN product_categories p1_ ON p0_.category_id = p1_.id
ORDER BY
  p0_.name ASC
LIMIT
  8

SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.image AS image_2, p0_.image_directory AS image_directory_3, p0_.id AS id_4, p0_.name AS name_5, p0_.status AS status_6, p0_.quantity AS quantity_7, p0_.price AS price_8, p0_.short_description AS short_description_9, p0_.detailed_description AS detailed_description_10, p0_.specifications AS specifications_11, p0_.category_id AS category_id_12 FROM products p0_ LEFT JOIN product_categories p1_ ON p0_.category_id = p1_.id ORDER BY p0_.name ASC LIMIT 8;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BaseRepository->findPaginated (line 31)
7	App\Controller\Main\HomeController->homePage (line 28)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.74 ms
(9.34%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.is_disabled = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.image AS image_3,
  t0.image_directory AS image_directory_4,
  t0.id AS id_5,
  t0.customer_name AS customer_name_6,
  t0.customer_email AS customer_email_7,
  t0.message AS message_8,
  t0.is_disabled AS is_disabled_9,
  t0.customer_id AS customer_id_10
FROM
  testimonials t0
WHERE
  t0.is_disabled = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.is_disabled = 0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\Main\HomeController->homePage (line 29)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Product	8
App\Entity\Testimonial	6
App\Entity\User	4
App\Entity\Cart	4
App\Entity\ProductCategory	3

Entities Mapping

Class	Mapping errors
App\Entity\AbstractTimestampedEntity	No errors.
App\Entity\AbstractImageEntity	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Testimonial	No errors.
App\Entity\User	No errors.
App\Entity\Customer	No errors.
App\Entity\Address	No errors.
App\Entity\Order	No errors.
App\Entity\Review	No errors.
App\Entity\Cart	No errors.
App\Entity\CartItem	No errors.

Symfony Profiler

GET https://www.admin.postmark.co.za/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping