Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.15 ms Query time

1 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.33 ms
(42.04%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = ? AND t0.visibility = ? LIMIT 1

Parameters:

[
  "register"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.url AS url_6,
  t0.visibility AS visibility_7,
  t0.type AS type_8
FROM
  seo_redirection t0
WHERE
  t0.slug = ?
  AND t0.visibility = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = 'register' AND t0.visibility = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Services\Seo\Redir->getUrl (line 31)
4	App\Listener\RedirectionListener->onKernelRequest (line 44)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.10 ms
(35.02%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.link AS link_5, t0.visibility AS visibility_6, t0.target_blank AS target_blank_7, t0.type AS type_8, t0.sequence AS sequence_9, t0.type_button AS type_button_10, t0.visibility_user AS visibility_user_11, t0.private AS private_12, t0.no_private AS no_private_13, t0.website AS website_14, t0.recruiter AS recruiter_15, t0.company AS company_16, t0.langue AS langue_17 FROM menu_website_parents t0 WHERE t0.type = ? AND t0.no_private = ? ORDER BY t0.sequence ASC

Parameters:

[
  "header"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.link AS link_5,
  t0.visibility AS visibility_6,
  t0.target_blank AS target_blank_7,
  t0.type AS type_8,
  t0.sequence AS sequence_9,
  t0.type_button AS type_button_10,
  t0.visibility_user AS visibility_user_11,
  t0.private AS private_12,
  t0.no_private AS no_private_13,
  t0.website AS website_14,
  t0.recruiter AS recruiter_15,
  t0.company AS company_16,
  t0.langue AS langue_17
FROM
  menu_website_parents t0
WHERE
  t0.type = ?
  AND t0.no_private = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.link AS link_5, t0.visibility AS visibility_6, t0.target_blank AS target_blank_7, t0.type AS type_8, t0.sequence AS sequence_9, t0.type_button AS type_button_10, t0.visibility_user AS visibility_user_11, t0.private AS private_12, t0.no_private AS no_private_13, t0.website AS website_14, t0.recruiter AS recruiter_15, t0.company AS company_16, t0.langue AS langue_17 FROM menu_website_parents t0 WHERE t0.type = 'header' AND t0.no_private = 1 ORDER BY t0.sequence ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 974)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Services\Menu\Core->getMenuWebsiteArray (line 52)
4	App\Twig\MenuExtension->getMenuWebsiteArray (line 50)
5	__TwigTemplate_3fbb74b90a311aa438599a1e498c1151->doDisplay (line 114)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_1d8c39f0d84929e54d63b73b718642f9->doDisplay (line 54)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
16	App\Controller\Login\SecurityController->register (line 104)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 197)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.72 ms
(22.94%)

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.title_page AS title_page_4, c0_.value AS value_5, c0_.type_website AS type_website_6, c0_.sequence AS sequence_7, c0_.type AS type_8, c0_.tool_id AS tool_id_9 FROM core_tools c0_ WHERE c0_.type_website LIKE ? ORDER BY c0_.id ASC

Parameters:

[
  "%blog%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.name AS name_3,
  c0_.title_page AS title_page_4,
  c0_.value AS value_5,
  c0_.type_website AS type_website_6,
  c0_.sequence AS sequence_7,
  c0_.type AS type_8,
  c0_.tool_id AS tool_id_9
FROM
  core_tools c0_
WHERE
  c0_.type_website LIKE ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.title_page AS title_page_4, c0_.value AS value_5, c0_.type_website AS type_website_6, c0_.sequence AS sequence_7, c0_.type AS type_8, c0_.tool_id AS tool_id_9 FROM core_tools c0_ WHERE c0_.type_website LIKE '%blog%' ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\Core\ToolsRepository->getCategory (line 24)
7	App\Services\Core\Tools->getList (line 66)
8	App\Twig\ToolsExtension->getCoreToolsList (line 36)
9	__TwigTemplate_3fbb74b90a311aa438599a1e498c1151->doDisplay (line 73)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1d8c39f0d84929e54d63b73b718642f9->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
20	App\Controller\Login\SecurityController->register (line 104)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 197)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Menu\WebsiteParents	4

Entities Mapping

Class	Mapping errors
App\Entity\Seo\Redirection	No errors.
App\Entity\Core\Tools	The field 'App\Entity\Core\Tools#sequence' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Menu\WebsiteParents	No errors.

Symfony Profiler

GET https://dev.bowkaye.com/register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping