Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.07 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.07 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, 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` 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 (u.text_md5 = ?) AND (u.parent = ibexa_url_alias_ml1.link) LIMIT 1

Parameters:

[
  "3b4f5036466e6011ab1e485f9af10b29"
  0
  "39d297286dd5bc39ac5cf2626d3d47e8"
  "82938ace676e1cde94ad73d4767b3b8a"
]

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,
  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` 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 (u.text_md5 = ?)
  AND (
    u.parent = ibexa_url_alias_ml1.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, 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` u WHERE (ibexa_url_alias_ml0.text_md5 = '3b4f5036466e6011ab1e485f9af10b29') AND (ibexa_url_alias_ml0.parent = 0) AND (ibexa_url_alias_ml1.text_md5 = '39d297286dd5bc39ac5cf2626d3d47e8') AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (u.text_md5 = '82938ace676e1cde94ad73d4767b3b8a') AND (u.parent = ibexa_url_alias_ml1.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	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

ibexa_default entity manager

Class	Amount of managed objects

default entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://edit.dxp.platform.demo.exponential.earth//sito/wp-includes/wlwmanifest.xml

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

ibexa_default entity manager

default entity manager

Entities Mapping

ibexa_default entity manager

default entity manager

Symfony Profiler

GET https://edit.dxp.platform.demo.exponential.earth//sito/wp-includes/wlwmanifest.xml

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

ibexa_default entity manager

default entity manager

Entities Mapping

ibexa_default entity manager

default entity manager