Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.37 ms Query time

3 Invalid entities

11 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.86 ms

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  setting t0

SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	OHMedia\SettingsBundle\Service\Settings->getEntity (line 98)
5	OHMedia\SettingsBundle\Service\Settings->get (line 66)
6	OHMedia\MetaBundle\Settings\MetaSettings->getBaseTitle (line 27)
7	OHMedia\MetaBundle\Twig\MetaExtension->initSettings (line 71)
8	OHMedia\MetaBundle\Twig\MetaExtension->renderMeta (line 85)
9	OHMedia\MetaBundle\Twig\MetaExtension->getMetaSimple (line 49)
10	__TwigTemplate_5f8337ed1d4db73c649e7c1cbced6eb8->doDisplay (line 70)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_63ec78df2c3c103da93909c1884777a2->doDisplay (line 55)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
21	App\Controller\Frontend\HousingApplicationFrontendController->form (line 69)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.51 ms

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.name AS name_3,
  t0.ext AS ext_4,
  t0.path AS path_5,
  t0.browser AS browser_6,
  t0.locked AS locked_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.alt AS alt_12,
  t0.image AS image_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.folder_id AS folder_id_18,
  t0.resize_parent_id AS resize_parent_id_19
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.name AS name_3, t0.ext AS ext_4, t0.path AS path_5, t0.browser AS browser_6, t0.locked AS locked_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.alt AS alt_12, t0.image AS image_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.folder_id AS folder_id_18, t0.resize_parent_id AS resize_parent_id_19 FROM file t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	OHMedia\SettingsBundle\Service\Settings->get (line 73)
7	OHMedia\MetaBundle\Settings\MetaSettings->getImage (line 37)
8	OHMedia\MetaBundle\Twig\MetaExtension->initSettings (line 73)
9	OHMedia\MetaBundle\Twig\MetaExtension->renderMeta (line 85)
10	OHMedia\MetaBundle\Twig\MetaExtension->getMetaSimple (line 49)
11	__TwigTemplate_5f8337ed1d4db73c649e7c1cbced6eb8->doDisplay (line 70)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_63ec78df2c3c103da93909c1884777a2->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
22	App\Controller\Frontend\HousingApplicationFrontendController->form (line 69)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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
OHMedia\SettingsBundle\Entity\Setting	10
OHMedia\FileBundle\Entity\File	1

Entities Mapping

Class	Mapping errors
App\Entity\Housing\HousingApplication	The mappings App\Entity\Housing\HousingApplication#house_members and App\Entity\Housing\HousingApplicationHouseMember#application are inconsistent with each other. The mappings App\Entity\Housing\HousingApplication#reference_contacts and App\Entity\Housing\HousingApplicationReferenceContact#application are inconsistent with each other.
App\Entity\Housing\HousingApplicationHouseMember	The association App\Entity\Housing\HousingApplicationHouseMember#application refers to the inverse side field App\Entity\Housing\HousingApplication#household_members which does not exist.
App\Entity\Housing\HousingApplicationLandlord	No errors.
App\Entity\Housing\HousingApplicationReferenceContact	The association App\Entity\Housing\HousingApplicationReferenceContact#application refers to the inverse side field App\Entity\Housing\HousingApplication#reference_contact which does not exist.
OHMedia\SettingsBundle\Entity\Setting	No errors.
OHMedia\FileBundle\Entity\File	No errors.
OHMedia\FileBundle\Entity\FileFolder	No errors.

Symfony Profiler

GET https://ehrlo-forms.ohcms.com/housing/form

Configuration Settings

Theme

Page Width