Symfony Profiler

Query Metrics

11 Database Queries

4 Different statements

9.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.58 ms
(38.85%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.format AS format_4, t0.path AS path_5 FROM FILE t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_name AS original_name_3,
  t0.format AS format_4,
  t0.path AS path_5
FROM
  FILE t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.format AS format_4, t0.path AS path_5 FROM FILE t0 WHERE t0.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\File->__get (line 175)
7	App\Entity\File->getFilename (line 1635)
8	twig_get_attribute (line 46)
9	__TwigTemplate_1339ffdf98cbc8e33dd02b9d6552a87e->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 1347)
14	twig_include (line 106)
15	__TwigTemplate_a528df20e33b14c55f76e84166ad6ce4->block_content (line 171)
16	Twig\Template->displayBlock (line 75)
17	__TwigTemplate_fbe287d05da5420b876ecd0d0c6294a9->block_body (line 171)
18	Twig\Template->displayBlock (line 80)
19	__TwigTemplate_95297136c30c70f66286b735f07324d2->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_fbe287d05da5420b876ecd0d0c6294a9->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 52)
25	__TwigTemplate_a528df20e33b14c55f76e84166ad6ce4->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 379)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 280)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 147)
34	App\Controller\FormController->form (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

2.34 ms
(25.40%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.region_id AS region_id_2 FROM state s0_ ORDER BY s0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.region_id AS region_id_2
FROM
  state s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.region_id AS region_id_2 FROM state s0_ ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 208)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 149)
21	App\Controller\FormController->form (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.93 ms
(20.98%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.name AS name_3, t0.value AS value_4, t0.value_type AS value_type_5, t0.file_id AS file_id_6 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "BANNER_FILE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.name AS name_3,
  t0.value AS value_4,
  t0.value_type AS value_type_5,
  t0.file_id AS file_id_6
FROM
  settings t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.name AS name_3, t0.value AS value_4, t0.value_type AS value_type_5, t0.file_id AS file_id_6 FROM settings t0 WHERE t0.setting_key = 'BANNER_FILE' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 51)
5	App\Controller\FormController->form (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)

1.36 ms
(14.76%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.email AS email_3, t0.type AS type_4, t0.promotional_banner_url AS promotional_banner_url_5, t0.color AS color_6, t0.show_promotional_banner AS show_promotional_banner_7, t0.industry_id AS industry_id_8, t0.banner_file_id AS banner_file_id_9, t0.promotional_banner_file_id AS promotional_banner_file_id_10, t0.btn_need_file_id AS btn_need_file_id_11, t0.btn_education_file_id AS btn_education_file_id_12 FROM form t0 WHERE t0.url = ? AND t0.id = ? LIMIT 1

Parameters:

[
  "4321-1234"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.email AS email_3,
  t0.type AS type_4,
  t0.promotional_banner_url AS promotional_banner_url_5,
  t0.color AS color_6,
  t0.show_promotional_banner AS show_promotional_banner_7,
  t0.industry_id AS industry_id_8,
  t0.banner_file_id AS banner_file_id_9,
  t0.promotional_banner_file_id AS promotional_banner_file_id_10,
  t0.btn_need_file_id AS btn_need_file_id_11,
  t0.btn_education_file_id AS btn_education_file_id_12
FROM
  form t0
WHERE
  t0.url = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.email AS email_3, t0.type AS type_4, t0.promotional_banner_url AS promotional_banner_url_5, t0.color AS color_6, t0.show_promotional_banner AS show_promotional_banner_7, t0.industry_id AS industry_id_8, t0.banner_file_id AS banner_file_id_9, t0.promotional_banner_file_id AS promotional_banner_file_id_10, t0.btn_need_file_id AS btn_need_file_id_11, t0.btn_education_file_id AS btn_education_file_id_12 FROM form t0 WHERE t0.url = '4321-1234' AND t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 46)
5	App\Controller\FormController->form (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)

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\Form	No errors.
App\Entity\Industry	No errors.
App\Entity\File	No errors.
App\Entity\Lead	No errors.
App\Entity\FormTypeInForm	No errors.
App\Entity\Settings	No errors.
App\Entity\State	No errors.
App\Entity\Region	No errors.
App\Entity\BannerFile	No errors.
App\Entity\AgentForm	No errors.
App\Entity\Attachment	No errors.

Symfony Profiler

GET https://phn.vps.ar-range.app/form/1/4321-1234

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping