Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.65 ms Query time

1 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.91 ms

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1

Parameters:

[
  "https://rct.dev.bbntimes.com/support/faqs"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_url AS original_url_2,
  t0.redirection_url AS redirection_url_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  redirection t0
WHERE
  t0.original_url = ?
  AND t0.status = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/support/faqs' AND t0.status = 'published' ORDER BY t0.updated_at DESC 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 26)
4	App\EventListener\RedirectionListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.43 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.orders AS orders_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.canonical AS canonical_11, t0.image_id AS image_id_12 FROM PAGE t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1

Parameters:

[
  "faqs"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.orders AS orders_8,
  t0.metakey AS metakey_9,
  t0.metadesc AS metadesc_10,
  t0.canonical AS canonical_11,
  t0.image_id AS image_id_12
FROM
  PAGE t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.orders AS orders_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.canonical AS canonical_11, t0.image_id AS image_id_12 FROM PAGE t0 WHERE t0.slug = 'faqs' AND t0.status = 'published' 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 18)
4	App\Controller\PageController->page (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.31 ms

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1

Parameters:

[
  "https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_url AS original_url_2,
  t0.redirection_url AS redirection_url_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  redirection t0
WHERE
  t0.original_url = ?
  AND t0.status = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = 'https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis' AND t0.status = 'published' ORDER BY t0.updated_at DESC 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 26)
4	App\EventListener\RedirectionListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 84)
16	__TwigTemplate_dc67cdc305f050f0a27ba7ef152f05af->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 52)
19	__TwigTemplate_120d8526fe518379a393bdf6cabde865->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
28	App\Controller\PageController->page (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
App\Entity\Redirection	No errors.
App\Entity\Page	The association App\Entity\Page#image refers to the inverse side field App\Entity\File#pages which does not exist.
App\Entity\File	No errors.

Symfony Profiler

GET https://rct.dev.bbntimes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping