Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

7.45 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.24 ms
(43.52%)

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id GROUP BY s0_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  supplier s0_
  LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id
GROUP BY
  s0_.id

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id GROUP BY s0_.id;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6xBjgVf\PaginatorProxyBa079e5->paginate (line 35)
16	App\Controller\SupplierController->index (line 183)
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 5)

1.56 ms
(20.90%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.contact_person AS contact_person_2, s0_.email AS email_3, s0_.phone AS phone_4, s0_.address AS address_5, s0_.tax_number AS tax_number_6, s0_.payment_terms AS payment_terms_7, s0_.website AS website_8, s0_.notes AS notes_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, COALESCE(SUM(CASE WHEN s1_.type = 'credit' THEN s1_.amount WHEN s1_.type = 'payment' THEN -s1_.amount ELSE 0 END), 0) AS sclr_12 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id WHERE s0_.id IN (?) GROUP BY s0_.id ORDER BY s0_.id DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.contact_person AS contact_person_2,
  s0_.email AS email_3,
  s0_.phone AS phone_4,
  s0_.address AS address_5,
  s0_.tax_number AS tax_number_6,
  s0_.payment_terms AS payment_terms_7,
  s0_.website AS website_8,
  s0_.notes AS notes_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  COALESCE(
    SUM(
      CASE WHEN s1_.type = 'credit' THEN
        s1_.amount
      WHEN s1_.type = 'payment' THEN
        - s1_.amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_12
FROM
  supplier s0_
  LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id
WHERE
  s0_.id IN (?)
GROUP BY
  s0_.id
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.contact_person AS contact_person_2, s0_.email AS email_3, s0_.phone AS phone_4, s0_.address AS address_5, s0_.tax_number AS tax_number_6, s0_.payment_terms AS payment_terms_7, s0_.website AS website_8, s0_.notes AS notes_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, COALESCE(SUM(CASE WHEN s1_.type = 'credit' THEN s1_.amount WHEN s1_.type = 'payment' THEN -s1_.amount ELSE 0 END), 0) AS sclr_12 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id WHERE s0_.id IN (1) GROUP BY s0_.id ORDER BY s0_.id DESC;

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6xBjgVf\PaginatorProxyBa079e5->paginate (line 35)
16	App\Controller\SupplierController->index (line 183)
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 5)

1.10 ms
(14.75%)

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id GROUP BY s0_.id ORDER BY s0_.id DESC LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  supplier s0_
  LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id
GROUP BY
  s0_.id
ORDER BY
  s0_.id DESC
LIMIT
  12

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM supplier s0_ LEFT JOIN supplier_credit s1_ ON s0_.id = s1_.supplier_id GROUP BY s0_.id ORDER BY s0_.id DESC LIMIT 12;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container6xBjgVf\PaginatorProxyBa079e5->paginate (line 35)
16	App\Controller\SupplierController->index (line 183)
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 5)

1.02 ms
(13.70%)

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.date AS date_5, t0.reference AS reference_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.supplier_id AS supplier_id_10, t0.delivery_note_id AS delivery_note_id_11, t0.supplier_payment_id AS supplier_payment_id_12 FROM supplier_credit t0 WHERE t0.supplier_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.date AS date_5,
  t0.reference AS reference_6,
  t0.description AS description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.supplier_id AS supplier_id_10,
  t0.delivery_note_id AS delivery_note_id_11,
  t0.supplier_payment_id AS supplier_payment_id_12
FROM
  supplier_credit t0
WHERE
  t0.supplier_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.type AS type_3, t0.status AS status_4, t0.date AS date_5, t0.reference AS reference_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.supplier_id AS supplier_id_10, t0.delivery_note_id AS delivery_note_id_11, t0.supplier_payment_id AS supplier_payment_id_12 FROM supplier_credit t0 WHERE t0.supplier_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
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 450)
8	App\Entity\Supplier->getCreditBalance (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 302)
10	__TwigTemplate_f6eb8804a7b29f93e6fa86444880ad77->block_body (line 446)
11	Twig\Template->yieldBlock (line 177)
12	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_f6eb8804a7b29f93e6fa86444880ad77->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
23	App\Controller\SupplierController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.53 ms
(7.13%)

SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.garage AS garage_2,
  t0.currency AS currency_3,
  t0.date_format AS date_format_4,
  t0.time_format AS time_format_5,
  t0.notifications AS notifications_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.logo AS logo_9
FROM
  app_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 25)
5	App\Service\SettingsService->getSettings (line 99)
6	App\Service\SettingsService->getCurrency (line 104)
7	App\Service\SettingsService->getCurrencySymbol (line 71)
8	App\Twig\SettingsExtension->getCurrencySymbol (line 73)
9	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_f6eb8804a7b29f93e6fa86444880ad77->doDisplay (line 402)
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 41)
20	App\Controller\SupplierController->index (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 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Supplier	1
App\Entity\AppSettings	1

Entities Mapping

Class	Mapping errors
App\Entity\Supplier	No errors.
App\Entity\SupplierCredit	No errors.
App\Entity\PriceRequest	No errors.
App\Entity\PurchaseOrder	No errors.
App\Entity\DeliveryNote	No errors.
App\Entity\CreditNote	No errors.
App\Entity\Payment	No errors.
App\Entity\SupplierPayment	No errors.
App\Entity\Article	No errors.
App\Entity\AppSettings	No errors.

Symfony Profiler

GET https://garage.farahtech.ma/supplier

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping