Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.37 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.36 ms
(57.33%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.google_analytics_id AS google_analytics_id_18, t0.google_tag_manager_code AS google_tag_manager_code_19, t0.google_site_verification_code AS google_site_verification_code_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.tagline AS tagline_3,
  t0.logo_footer AS logo_footer_4,
  t0.footer_description AS footer_description_5,
  t0.facebook_link AS facebook_link_6,
  t0.x_link AS x_link_7,
  t0.instagram_link AS instagram_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.whatsapp_link AS whatsapp_link_10,
  t0.contact_phone AS contact_phone_11,
  t0.contact_email AS contact_email_12,
  t0.address AS address_13,
  t0.map_link AS map_link_14,
  t0.home_banner_title AS home_banner_title_15,
  t0.home_banner_description AS home_banner_description_16,
  t0.home_banner_image AS home_banner_image_17,
  t0.google_analytics_id AS google_analytics_id_18,
  t0.google_tag_manager_code AS google_tag_manager_code_19,
  t0.google_site_verification_code AS google_site_verification_code_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.meta_keywords AS meta_keywords_23
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.google_analytics_id AS google_analytics_id_18, t0.google_tag_manager_code AS google_tag_manager_code_19, t0.google_site_verification_code AS google_site_verification_code_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 53)
4	App\Controller\DefaultController->meta (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 64)
12	__TwigTemplate_c6f227c9c22d0f5052ac4f8c31e3a3bb->doDisplay (line 388)
13	Twig\Template->yield (line 59)
14	__TwigTemplate_01da527580efb7873c30134e2161632f->doDisplay (line 388)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_26b1283c993df93a37b58601df8e2741->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
25	App\Controller\SecurityController->login (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.01 ms
(42.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "login"
]

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.title AS title_4,
  t0.body AS body_5,
  t0.featured_image AS featured_image_6,
  t0.footer_nav AS footer_nav_7,
  t0.`position` AS position_8,
  t0.publish AS publish_9,
  t0.public AS public_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.body AS body_5, t0.featured_image AS featured_image_6, t0.footer_nav AS footer_nav_7, t0.`position` AS position_8, t0.publish AS publish_9, t0.public AS public_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM page t0 WHERE t0.slug = 'login' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 71)
4	App\Controller\DefaultController->meta (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 64)
12	__TwigTemplate_c6f227c9c22d0f5052ac4f8c31e3a3bb->doDisplay (line 388)
13	Twig\Template->yield (line 59)
14	__TwigTemplate_01da527580efb7873c30134e2161632f->doDisplay (line 388)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_26b1283c993df93a37b58601df8e2741->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
25	App\Controller\SecurityController->login (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\PageSection	No errors.
App\Entity\School	No errors.
App\Entity\ConsultancyFee	No errors.
App\Entity\LandTypeCategory	The association App\Entity\LandTypeCategory#categories refers to the inverse side field App\Entity\SalesCategory#landSizes which does not exist.
App\Entity\ApprovalGroup	The association App\Entity\ApprovalGroup#approvers refers to the inverse side field App\Entity\User#approvalGroups which does not exist.
App\Entity\DivisionCapacity	No errors.
App\Entity\Department	No errors.
App\Entity\Kyc	No errors.
App\Entity\Royalty	No errors.
App\Entity\Directory	No errors.
App\Entity\ServiceProvider	No errors.
App\Entity\RampUp	No errors.
App\Entity\TermSheet	No errors.
App\Entity\CompanyDocument	No errors.
App\Entity\SchoolGradeYearlyAudit	No errors.
App\Entity\PdcStatus	No errors.
App\Entity\UserReportingManager	No errors.
App\Entity\Shift	No errors.
App\Entity\PaymentInstallment	No errors.
App\Entity\OfficeLocation	No errors.
App\Entity\Division	No errors.
App\Entity\Lead	No errors.
App\Entity\Asset	No errors.
App\Entity\InviteUser	No errors.
App\Entity\Grade	No errors.
App\Entity\Project	No errors.
App\Entity\UserPermission	No errors.
App\Entity\Payment	No errors.
App\Entity\Module	No errors.
App\Entity\AllianceFee	No errors.
App\Entity\InstallmentMaster	No errors.
App\Entity\Permission	No errors.
App\Entity\Zone	No errors.
App\Entity\LandSizeCategory	The association App\Entity\LandSizeCategory#categories refers to the inverse side field App\Entity\SalesCategory#landSizes which does not exist.
App\Entity\InvoiceSubType	No errors.
App\Entity\FinanceTransactionType	No errors.
App\Entity\ErrorLog	No errors.
App\Entity\Task	No errors.
App\Entity\Status	No errors.
App\Entity\EmailTemplate	No errors.
App\Entity\SalesCategory	No errors.
App\Entity\TrustDocument	No errors.
App\Entity\FinanceInvoiceType	No errors.
App\Entity\SchoolYearlyAudit	No errors.
App\Entity\SchoolGradeMonthlyAudit	No errors.
App\Entity\OperationalYear	No errors.
App\Entity\Brand	No errors.
App\Entity\PaymentMode	No errors.
App\Entity\Stream	No errors.
App\Entity\EmployeeZone	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://pms-uat.birlaopenminds.com/login

Configuration Settings

Theme