Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.41 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.41 ms
(100.00%)

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:

[
  "a81259cef8e959c624df1d456e5d3297"
  0
  "a1b01e734b573fca08eb1a65e6df9a38"
  "7af682f3fa2fd6e0c4822fcc932d434b"
  "168726dbe96b3ce427e7fedce31bb0bc"
]

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 = 'a81259cef8e959c624df1d456e5d3297') AND (ibexa_url_alias_ml0.parent = 0) AND (ibexa_url_alias_ml1.text_md5 = 'a1b01e734b573fca08eb1a65e6df9a38') AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (ibexa_url_alias_ml2.text_md5 = '7af682f3fa2fd6e0c4822fcc932d434b') AND (ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link) AND (u.text_md5 = '168726dbe96b3ce427e7fedce31bb0bc') 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	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/static/style/sys_files/index.js

Query Metrics

Grouped Statements

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/static/style/sys_files/index.js

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

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