Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

0.79 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.44 ms

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

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 815)
7	App\OG\Controller\FrontController->myFavorites (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Symfony Profiler

GET https://auction.elcaholding.com/my-favorites-1

Configuration Settings

Theme