Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.02 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.02 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:

[
  "d3d35b2365bdc9dba2422c53930e6b30"
  0
  "3198800cd0599581af4bdada7aabe886"
  "5c6a5a6433d6c3074c5ce99adfef9b96"
  "eefff59b014dd2b3927a5d80f42ba7fc"
]

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 = 'd3d35b2365bdc9dba2422c53930e6b30') AND (ibexa_url_alias_ml0.parent = 0) AND (ibexa_url_alias_ml1.text_md5 = '3198800cd0599581af4bdada7aabe886') AND (ibexa_url_alias_ml1.parent = ibexa_url_alias_ml0.link) AND (ibexa_url_alias_ml2.text_md5 = '5c6a5a6433d6c3074c5ce99adfef9b96') AND (ibexa_url_alias_ml2.parent = ibexa_url_alias_ml1.link) AND (u.text_md5 = 'eefff59b014dd2b3927a5d80f42ba7fc') AND (u.parent = ibexa_url_alias_ml2.link) LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 344)
4	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Gateway\DoctrineDatabase->loadUrlAliasData (line 705)
5	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Gateway\ExceptionConversion->loadUrlAliasData (line 187)
6	Ibexa\Core\Persistence\Legacy\Content\UrlAlias\Handler->lookup (line 592)
7	Ibexa\Core\Persistence\Cache\UrlAliasHandler->lookup (line 238)
8	Ibexa\Core\Repository\URLAliasService->lookup (line 653)
9	Ibexa\Contracts\Core\Repository\Decorator\URLAliasServiceDecorator->lookup (line 77)
10	Ibexa\Core\Repository\SiteAccessAware\URLAliasService->lookup (line 89)
11	Ibexa\Bundle\Core\Routing\UrlAliasRouter->getUrlAlias (line 61)
12	Ibexa\Core\MVC\Symfony\Routing\UrlAliasRouter->matchRequest (line 84)
13	Ibexa\Bundle\Core\Routing\UrlAliasRouter->matchRequest (line 38)
14	Netgen\Bundle\IbexaSiteApiBundle\Routing\UrlAliasRouter->matchRequest (line 20)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	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://media.alpha.se7enx.com/fit-healthy/healthy-eating/15-scrumptious-summer-tomato-recipes-you-need-to-try

Query Metrics

Grouped Statements

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://media.alpha.se7enx.com/fit-healthy/healthy-eating/15-scrumptious-summer-tomato-recipes-you-need-to-try

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

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