Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.77 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.77 ms

SELECT ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id, ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link, ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias, ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects, ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original, ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action, ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type, ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask, ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text, ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent, ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5, ibexa_url_alias_ml1.id AS ibexa_url_alias_ml1_id, ibexa_url_alias_ml1.link AS ibexa_url_alias_ml1_link, ibexa_url_alias_ml1.is_alias AS ibexa_url_alias_ml1_is_alias, ibexa_url_alias_ml1.alias_redirects AS ibexa_url_alias_ml1_alias_redirects, ibexa_url_alias_ml1.is_original AS ibexa_url_alias_ml1_is_original, ibexa_url_alias_ml1.action AS ibexa_url_alias_ml1_action, ibexa_url_alias_ml1.action_type AS ibexa_url_alias_ml1_action_type, ibexa_url_alias_ml1.lang_mask AS ibexa_url_alias_ml1_lang_mask, ibexa_url_alias_ml1.text AS ibexa_url_alias_ml1_text, ibexa_url_alias_ml1.parent AS ibexa_url_alias_ml1_parent, ibexa_url_alias_ml1.text_md5 AS ibexa_url_alias_ml1_text_md5, ibexa_url_alias_ml2.id AS ibexa_url_alias_ml2_id, ibexa_url_alias_ml2.link AS ibexa_url_alias_ml2_link, ibexa_url_alias_ml2.is_alias AS ibexa_url_alias_ml2_is_alias, ibexa_url_alias_ml2.alias_redirects AS ibexa_url_alias_ml2_alias_redirects, ibexa_url_alias_ml2.is_original AS ibexa_url_alias_ml2_is_original, ibexa_url_alias_ml2.action AS ibexa_url_alias_ml2_action, ibexa_url_alias_ml2.action_type AS ibexa_url_alias_ml2_action_type, ibexa_url_alias_ml2.lang_mask AS ibexa_url_alias_ml2_lang_mask, ibexa_url_alias_ml2.text AS ibexa_url_alias_ml2_text, ibexa_url_alias_ml2.parent AS ibexa_url_alias_ml2_parent, ibexa_url_alias_ml2.text_md5 AS ibexa_url_alias_ml2_text_md5, u.id AS id, u.link AS link, u.is_alias AS is_alias, u.alias_redirects AS alias_redirects, u.is_original AS is_original, u.action AS action, u.action_type AS action_type, u.lang_mask AS lang_mask, u.text AS text, u.parent AS parent, u.text_md5 AS text_md5 FROM "ibexa_url_alias_ml" ibexa_url_alias_ml0, "ibexa_url_alias_ml" ibexa_url_alias_ml1, "ibexa_url_alias_ml" ibexa_url_alias_ml2, "ibexa_url_alias_ml" u WHERE (ibexa_url_alias_ml0.text_md5 = ?) AND (ibexa_url_alias_ml0.parent = ?) AND (ibexa_url_alias_ml1.text_md5 = ?) AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (ibexa_url_alias_ml2.text_md5 = ?) AND (ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link) AND (u.text_md5 = ?) AND (u.parent = ibexa_url_alias_ml2.link) LIMIT 1

Parameters:

[
  "7cef8a734855777c2a9d0caf42666e69"
  0
  "f24d2cc05ca7eaa87d0959ea3f5ddfb2"
  "caf9b6b99962bf5c2264824231d7a40c"
  "492bd93456b81ad92f61e8891174ed04"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id,
  ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link,
  ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias,
  ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects,
  ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original,
  ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action,
  ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type,
  ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask,
  ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text,
  ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent,
  ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5,
  ibexa_url_alias_ml1.id AS ibexa_url_alias_ml1_id,
  ibexa_url_alias_ml1.link AS ibexa_url_alias_ml1_link,
  ibexa_url_alias_ml1.is_alias AS ibexa_url_alias_ml1_is_alias,
  ibexa_url_alias_ml1.alias_redirects AS ibexa_url_alias_ml1_alias_redirects,
  ibexa_url_alias_ml1.is_original AS ibexa_url_alias_ml1_is_original,
  ibexa_url_alias_ml1.action AS ibexa_url_alias_ml1_action,
  ibexa_url_alias_ml1.action_type AS ibexa_url_alias_ml1_action_type,
  ibexa_url_alias_ml1.lang_mask AS ibexa_url_alias_ml1_lang_mask,
  ibexa_url_alias_ml1.text AS ibexa_url_alias_ml1_text,
  ibexa_url_alias_ml1.parent AS ibexa_url_alias_ml1_parent,
  ibexa_url_alias_ml1.text_md5 AS ibexa_url_alias_ml1_text_md5,
  ibexa_url_alias_ml2.id AS ibexa_url_alias_ml2_id,
  ibexa_url_alias_ml2.link AS ibexa_url_alias_ml2_link,
  ibexa_url_alias_ml2.is_alias AS ibexa_url_alias_ml2_is_alias,
  ibexa_url_alias_ml2.alias_redirects AS ibexa_url_alias_ml2_alias_redirects,
  ibexa_url_alias_ml2.is_original AS ibexa_url_alias_ml2_is_original,
  ibexa_url_alias_ml2.action AS ibexa_url_alias_ml2_action,
  ibexa_url_alias_ml2.action_type AS ibexa_url_alias_ml2_action_type,
  ibexa_url_alias_ml2.lang_mask AS ibexa_url_alias_ml2_lang_mask,
  ibexa_url_alias_ml2.text AS ibexa_url_alias_ml2_text,
  ibexa_url_alias_ml2.parent AS ibexa_url_alias_ml2_parent,
  ibexa_url_alias_ml2.text_md5 AS ibexa_url_alias_ml2_text_md5,
  u.id AS id,
  u.link AS link,
  u.is_alias AS is_alias,
  u.alias_redirects AS alias_redirects,
  u.is_original AS is_original,
  u.action AS action,
  u.action_type AS action_type,
  u.lang_mask AS lang_mask,
  u.text AS text,
  u.parent AS parent,
  u.text_md5 AS text_md5
FROM
  "ibexa_url_alias_ml" ibexa_url_alias_ml0,
  "ibexa_url_alias_ml" ibexa_url_alias_ml1,
  "ibexa_url_alias_ml" ibexa_url_alias_ml2,
  "ibexa_url_alias_ml" u
WHERE
  (ibexa_url_alias_ml0.text_md5 = ?)
  AND (ibexa_url_alias_ml0.parent = ?)
  AND (ibexa_url_alias_ml1.text_md5 = ?)
  AND (
    ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link
  )
  AND (ibexa_url_alias_ml2.text_md5 = ?)
  AND (
    ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link
  )
  AND (u.text_md5 = ?)
  AND (
    u.parent = ibexa_url_alias_ml2.link
  )
LIMIT
  1

SELECT ibexa_url_alias_ml0.id AS ibexa_url_alias_ml0_id, ibexa_url_alias_ml0.link AS ibexa_url_alias_ml0_link, ibexa_url_alias_ml0.is_alias AS ibexa_url_alias_ml0_is_alias, ibexa_url_alias_ml0.alias_redirects AS ibexa_url_alias_ml0_alias_redirects, ibexa_url_alias_ml0.is_original AS ibexa_url_alias_ml0_is_original, ibexa_url_alias_ml0.action AS ibexa_url_alias_ml0_action, ibexa_url_alias_ml0.action_type AS ibexa_url_alias_ml0_action_type, ibexa_url_alias_ml0.lang_mask AS ibexa_url_alias_ml0_lang_mask, ibexa_url_alias_ml0.text AS ibexa_url_alias_ml0_text, ibexa_url_alias_ml0.parent AS ibexa_url_alias_ml0_parent, ibexa_url_alias_ml0.text_md5 AS ibexa_url_alias_ml0_text_md5, ibexa_url_alias_ml1.id AS ibexa_url_alias_ml1_id, ibexa_url_alias_ml1.link AS ibexa_url_alias_ml1_link, ibexa_url_alias_ml1.is_alias AS ibexa_url_alias_ml1_is_alias, ibexa_url_alias_ml1.alias_redirects AS ibexa_url_alias_ml1_alias_redirects, ibexa_url_alias_ml1.is_original AS ibexa_url_alias_ml1_is_original, ibexa_url_alias_ml1.action AS ibexa_url_alias_ml1_action, ibexa_url_alias_ml1.action_type AS ibexa_url_alias_ml1_action_type, ibexa_url_alias_ml1.lang_mask AS ibexa_url_alias_ml1_lang_mask, ibexa_url_alias_ml1.text AS ibexa_url_alias_ml1_text, ibexa_url_alias_ml1.parent AS ibexa_url_alias_ml1_parent, ibexa_url_alias_ml1.text_md5 AS ibexa_url_alias_ml1_text_md5, ibexa_url_alias_ml2.id AS ibexa_url_alias_ml2_id, ibexa_url_alias_ml2.link AS ibexa_url_alias_ml2_link, ibexa_url_alias_ml2.is_alias AS ibexa_url_alias_ml2_is_alias, ibexa_url_alias_ml2.alias_redirects AS ibexa_url_alias_ml2_alias_redirects, ibexa_url_alias_ml2.is_original AS ibexa_url_alias_ml2_is_original, ibexa_url_alias_ml2.action AS ibexa_url_alias_ml2_action, ibexa_url_alias_ml2.action_type AS ibexa_url_alias_ml2_action_type, ibexa_url_alias_ml2.lang_mask AS ibexa_url_alias_ml2_lang_mask, ibexa_url_alias_ml2.text AS ibexa_url_alias_ml2_text, ibexa_url_alias_ml2.parent AS ibexa_url_alias_ml2_parent, ibexa_url_alias_ml2.text_md5 AS ibexa_url_alias_ml2_text_md5, u.id AS id, u.link AS link, u.is_alias AS is_alias, u.alias_redirects AS alias_redirects, u.is_original AS is_original, u.action AS action, u.action_type AS action_type, u.lang_mask AS lang_mask, u.text AS text, u.parent AS parent, u.text_md5 AS text_md5 FROM "ibexa_url_alias_ml" ibexa_url_alias_ml0, "ibexa_url_alias_ml" ibexa_url_alias_ml1, "ibexa_url_alias_ml" ibexa_url_alias_ml2, "ibexa_url_alias_ml" u WHERE (ibexa_url_alias_ml0.text_md5 = '7cef8a734855777c2a9d0caf42666e69') AND (ibexa_url_alias_ml0.parent = 0) AND (ibexa_url_alias_ml1.text_md5 = 'f24d2cc05ca7eaa87d0959ea3f5ddfb2') AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (ibexa_url_alias_ml2.text_md5 = 'caf9b6b99962bf5c2264824231d7a40c') AND (ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link) AND (u.text_md5 = '492bd93456b81ad92f61e8891174ed04') AND (u.parent = ibexa_url_alias_ml2.link) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
2	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Gateway\DoctrineDatabase->loadUrlAliasData (line 705)
3	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Gateway\ExceptionConversion->loadUrlAliasData (line 187)
4	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Handler->lookup (line 592)
5	Ibexa\Core\Persistence\Cache\UrlAliasHandler->lookup (line 238)
6	Ibexa\Core\Repository\URLAliasService->lookup (line 653)
7	Ibexa\Contracts\Core\Repository\Decorator\URLAliasServiceDecorator->lookup (line 77)
8	Ibexa\Core\Repository\SiteAccessAware\URLAliasService->lookup (line 89)
9	Ibexa\Core\MVC\Symfony\Routing\UrlAliasRouter->getUrlAlias (line 140)
10	Ibexa\Bundle\Core\Routing\UrlAliasRouter->getUrlAlias (line 58)
11	Ibexa\Core\MVC\Symfony\Routing\UrlAliasRouter->matchRequest (line 84)
12	Ibexa\Bundle\Core\Routing\UrlAliasRouter->matchRequest (line 38)
13	Netgen\Bundle\IbexaSiteApiBundle\Routing\UrlAliasRouter->matchRequest (line 20)
14	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
16	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
ibexa_default	doctrine.orm.ibexa_default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

ibexa_default entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://site.v5.platform.alpha.se7enx.com/open/visitors/info/gets?%3D%26uuid%253D1%25253D%3D=&amp=

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

ibexa_default entity manager

Entities Mapping

default entity manager

ibexa_default entity manager

Symfony Profiler

GET https://site.v5.platform.alpha.se7enx.com/open/visitors/info/gets?%3D%26uuid%253D1%25253D%3D=&amp=

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

ibexa_default entity manager

Entities Mapping

default entity manager

ibexa_default entity manager