Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.29 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.66 ms
(50.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.minimum_quantity AS minimum_quantity_5, t0.quantity AS quantity_6, t0.unit_price AS unit_price_7, t0.total_price AS total_price_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.contact_id AS contact_id_12 FROM item t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.reference AS reference_4,
  t0.minimum_quantity AS minimum_quantity_5,
  t0.quantity AS quantity_6,
  t0.unit_price AS unit_price_7,
  t0.total_price AS total_price_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.category_id AS category_id_11,
  t0.contact_id AS contact_id_12
FROM
  item t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.minimum_quantity AS minimum_quantity_5, t0.quantity AS quantity_6, t0.unit_price AS unit_price_7, t0.total_price AS total_price_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.contact_id AS contact_id_12 FROM item t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 19)
6	App\Service\SimpleStockNotificationService->getStockNotifications (line 19)
7	App\Twig\NotificationExtension->getGlobals (line 359)
8	Twig\ExtensionSet->getGlobals (line 900)
9	Twig\Environment->getGlobals (line 398)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 459)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
18	App\Controller\SecurityController->login (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 38)
22	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
23	frankenphp_handle_request (line 45)
24	Runtime\FrankenPhpSymfony\Runner->run (line 29)
25	require_once (line 5)

2.64 ms
(49.81%)

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE i0_.is_paid = ? AND i0_.due_date IS NOT NULL AND i0_.due_date <= ?

Parameters:

[
  0
  "2026-04-16 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.is_paid = ?
  AND i0_.due_date IS NOT NULL
  AND i0_.due_date <= ?

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE i0_.is_paid = 0 AND i0_.due_date IS NOT NULL AND i0_.due_date <= '2026-04-16 00:00:00';

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 96)
8	App\Repository\InvoiceRepository->countOverdueUnpaidInvoices (line 20)
9	App\Twig\NotificationExtension->getGlobals (line 359)
10	Twig\ExtensionSet->getGlobals (line 900)
11	Twig\Environment->getGlobals (line 398)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
20	App\Controller\SecurityController->login (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 38)
24	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 1)
25	frankenphp_handle_request (line 45)
26	Runtime\FrankenPhpSymfony\Runner->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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Item	30
App\Entity\ItemCategory	2
App\Entity\Contact	1

Entities Mapping

Class	Mapping errors
App\Entity\Item	No errors.
App\Entity\ItemCategory	No errors.
App\Entity\Contact	No errors.
App\Entity\ItemOrder	No errors.
App\Entity\Invoice	No errors.

Symfony Profiler

GET https://testappsolution.com/connexion

Configuration Settings

Theme

Page Width