Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

1.59 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.75 ms
(46.87%)

SELECT t0.id AS id_1, t0.weight_unit AS weight_unit_2, t0.length_unit AS length_unit_3, t0.currency AS currency_4, t0.date_format AS date_format_5, t0.number_format AS number_format_6, t0.timezone AS timezone_7, t0.logo AS logo_8, t0.invoice_serie AS invoice_serie_9, t0.invoice_prefix_length AS invoice_prefix_length_10, t0.next_invoice_number AS next_invoice_number_11, t0.vat AS vat_12, t0.mail AS mail_13, t0.days_until_expiration AS days_until_expiration_14, t0.client_key AS client_key_15, t0.support_contact AS support_contact_16, t0.authenticated_marketplace AS authenticated_marketplace_17, t0.verified_marketplace AS verified_marketplace_18, t0.page_head_title AS page_head_title_19, t0.logo_for_documents AS logo_for_documents_20, t0.country_id AS country_id_21 FROM global_settings t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.weight_unit AS weight_unit_2,
  t0.length_unit AS length_unit_3,
  t0.currency AS currency_4,
  t0.date_format AS date_format_5,
  t0.number_format AS number_format_6,
  t0.timezone AS timezone_7,
  t0.logo AS logo_8,
  t0.invoice_serie AS invoice_serie_9,
  t0.invoice_prefix_length AS invoice_prefix_length_10,
  t0.next_invoice_number AS next_invoice_number_11,
  t0.vat AS vat_12,
  t0.mail AS mail_13,
  t0.days_until_expiration AS days_until_expiration_14,
  t0.client_key AS client_key_15,
  t0.support_contact AS support_contact_16,
  t0.authenticated_marketplace AS authenticated_marketplace_17,
  t0.verified_marketplace AS verified_marketplace_18,
  t0.page_head_title AS page_head_title_19,
  t0.logo_for_documents AS logo_for_documents_20,
  t0.country_id AS country_id_21
FROM
  global_settings t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.weight_unit AS weight_unit_2, t0.length_unit AS length_unit_3, t0.currency AS currency_4, t0.date_format AS date_format_5, t0.number_format AS number_format_6, t0.timezone AS timezone_7, t0.logo AS logo_8, t0.invoice_serie AS invoice_serie_9, t0.invoice_prefix_length AS invoice_prefix_length_10, t0.next_invoice_number AS next_invoice_number_11, t0.vat AS vat_12, t0.mail AS mail_13, t0.days_until_expiration AS days_until_expiration_14, t0.client_key AS client_key_15, t0.support_contact AS support_contact_16, t0.authenticated_marketplace AS authenticated_marketplace_17, t0.verified_marketplace AS verified_marketplace_18, t0.page_head_title AS page_head_title_19, t0.logo_for_documents AS logo_for_documents_20, t0.country_id AS country_id_21 FROM global_settings t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
5	Doctrine\ORM\EntityRepository->__call (line 539)
6	App\OG\Service\GlobalService->getGlobalSettings (line 111)
7	App\OG\EventSubscriber\NavigationLogger->onKernelRequest (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 6)

0.35 ms
(22.20%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.visible AS visible_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.authenticated AS authenticated_7, t0.static AS static_8, t0.landing AS landing_9 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.title AS title_2,
  t0.slug AS slug_3,
  t0.visible AS visible_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.authenticated AS authenticated_7,
  t0.static AS static_8,
  t0.landing AS landing_9
FROM
  PAGE t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.visible AS visible_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.authenticated AS authenticated_7, t0.static AS static_8, t0.landing AS landing_9 FROM PAGE t0 WHERE t0.slug = 'login' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
5	Doctrine\ORM\EntityRepository->__call (line 131)
6	App\OG\Controller\FrontController->sellerLogIn (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 6)

0.30 ms
(19.05%)

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.predefined AS predefined_2, f0_.priority AS priority_3, f0_.custom AS custom_4, f0_.use_custom AS use_custom_5, f0_.custom_url AS custom_url_6, f0_.new_tab AS new_tab_7, f0_.page_id AS page_id_8 FROM footer_menu f0_ ORDER BY f0_.priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.predefined AS predefined_2,
  f0_.priority AS priority_3,
  f0_.custom AS custom_4,
  f0_.use_custom AS use_custom_5,
  f0_.custom_url AS custom_url_6,
  f0_.new_tab AS new_tab_7,
  f0_.page_id AS page_id_8
FROM
  footer_menu f0_
ORDER BY
  f0_.priority ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.predefined AS predefined_2, f0_.priority AS priority_3, f0_.custom AS custom_4, f0_.use_custom AS use_custom_5, f0_.custom_url AS custom_url_6, f0_.new_tab AS new_tab_7, f0_.page_id AS page_id_8 FROM footer_menu f0_ ORDER BY f0_.priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 54)
7	App\OG\Repository\FooterMenuRepository->findPrioritised (line 638)
8	App\OG\Service\GlobalService->getFooterMenuItems (line 1709)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_d8b7c6334111be6fcc18616684215412->doDisplay (line 360)
11	Twig\Template->yield (line 142)
12	__TwigTemplate_de75bd8c58fe83264b2831ae7f70ea7b->block_body (line 430)
13	Twig\Template->yieldBlock (line 83)
14	__TwigTemplate_43407a053ea82564ad172e43fa44fdf8->doDisplay (line 360)
15	Twig\Template->yield (line 49)
16	__TwigTemplate_de75bd8c58fe83264b2831ae7f70ea7b->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 299)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 144)
24	App\OG\Controller\FrontController->sellerLogIn (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 6)

0.19 ms
(11.87%)

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.predefined AS predefined_2, h0_.priority AS priority_3, h0_.custom AS custom_4, h0_.use_custom AS use_custom_5, h0_.custom_url AS custom_url_6, h0_.new_tab AS new_tab_7, h0_.page_id AS page_id_8 FROM header_menu h0_ ORDER BY h0_.priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.predefined AS predefined_2,
  h0_.priority AS priority_3,
  h0_.custom AS custom_4,
  h0_.use_custom AS use_custom_5,
  h0_.custom_url AS custom_url_6,
  h0_.new_tab AS new_tab_7,
  h0_.page_id AS page_id_8
FROM
  header_menu h0_
ORDER BY
  h0_.priority ASC

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.predefined AS predefined_2, h0_.priority AS priority_3, h0_.custom AS custom_4, h0_.use_custom AS use_custom_5, h0_.custom_url AS custom_url_6, h0_.new_tab AS new_tab_7, h0_.page_id AS page_id_8 FROM header_menu h0_ ORDER BY h0_.priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 54)
7	App\OG\Repository\HeaderMenuRepository->findPrioritised (line 595)
8	App\OG\Service\GlobalService->getHeaderMenuItems (line 1709)
9	Twig\Extension\CoreExtension::getAttribute (line 73)
10	__TwigTemplate_c793be0958e46003fa04f5a1c61fe29e->doDisplay (line 360)
11	Twig\Template->yield (line 80)
12	__TwigTemplate_43407a053ea82564ad172e43fa44fdf8->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_de75bd8c58fe83264b2831ae7f70ea7b->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 299)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 144)
22	App\OG\Controller\FrontController->sellerLogIn (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 6)

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\OG\Entity\GlobalSettings	No errors.
App\OG\Entity\Country	No errors.
App\OG\Entity\Page	No errors.
App\OG\Entity\HeaderMenu	No errors.
App\OG\Entity\FooterMenu	No errors.

Symfony Profiler

GET https://auction.elcaholding.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping