Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.99 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.43 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact_person AS contact_person_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.tax_number AS tax_number_7, t0.payment_terms AS payment_terms_8, t0.website AS website_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM supplier t0 WHERE t0.id = ?

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.contact_person AS contact_person_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.tax_number AS tax_number_7,
  t0.payment_terms AS payment_terms_8,
  t0.website AS website_9,
  t0.notes AS notes_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact_person AS contact_person_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.tax_number AS tax_number_7, t0.payment_terms AS payment_terms_8, t0.website AS website_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM supplier t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.56 ms

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_8af774c872c1e5dda2ae04b682668378->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 183)
20	App\Controller\SupplierController->edit (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\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\SupplierCredit	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/1/edit

Configuration Settings

Theme

Page Width