Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

8.11 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.26 ms

SELECT w0_.id AS id_0, w0_.language AS language_1, w0_.title AS title_2, w0_.slide_link AS slide_link_3, w0_.slide_image AS slide_image_4, w0_.slide_content AS slide_content_5, w0_.popup_link AS popup_link_6, w0_.popup_image AS popup_image_7, w0_.popup_content AS popup_content_8, w0_.others AS others_9, w0_.date_modified AS date_modified_10, w0_.slide_id AS slide_id_11 FROM ws_site_slide_locales w0_ INNER JOIN ws_site_slides w1_ ON w0_.slide_id = w1_.id WHERE w1_.active = 1 AND w0_.language = ? AND w1_.name <> ? ORDER BY w1_.sort_key ASC LIMIT 10

Parameters:

[
  "en"
  "contest-slide"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.language AS language_1,
  w0_.title AS title_2,
  w0_.slide_link AS slide_link_3,
  w0_.slide_image AS slide_image_4,
  w0_.slide_content AS slide_content_5,
  w0_.popup_link AS popup_link_6,
  w0_.popup_image AS popup_image_7,
  w0_.popup_content AS popup_content_8,
  w0_.others AS others_9,
  w0_.date_modified AS date_modified_10,
  w0_.slide_id AS slide_id_11
FROM
  ws_site_slide_locales w0_
  INNER JOIN ws_site_slides w1_ ON w0_.slide_id = w1_.id
WHERE
  w1_.active = 1
  AND w0_.language = ?
  AND w1_.name <> ?
ORDER BY
  w1_.sort_key ASC
LIMIT
  10

SELECT w0_.id AS id_0, w0_.language AS language_1, w0_.title AS title_2, w0_.slide_link AS slide_link_3, w0_.slide_image AS slide_image_4, w0_.slide_content AS slide_content_5, w0_.popup_link AS popup_link_6, w0_.popup_image AS popup_image_7, w0_.popup_content AS popup_content_8, w0_.others AS others_9, w0_.date_modified AS date_modified_10, w0_.slide_id AS slide_id_11 FROM ws_site_slide_locales w0_ INNER JOIN ws_site_slides w1_ ON w0_.slide_id = w1_.id WHERE w1_.active = 1 AND w0_.language = 'en' AND w1_.name <> 'contest-slide' ORDER BY w1_.sort_key ASC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 44)
7	App\Repository\WsSiteSlideLocaleRepository->findActiveSlidesByLanguage (line 36)
8	App\Controller\DefaultController->homepageAction (line 181)
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)

1.06 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_key AS sort_key_3,
  t0.active AS active_4,
  t0.has_popup AS has_popup_5,
  t0.prod_ready AS prod_ready_6,
  t0.page_css AS page_css_7,
  t0.page_js AS page_js_8,
  t0.date_modified AS date_modified_9
FROM
  ws_site_slides t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\WsSiteSlide::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\WsSiteSlide->__get (line 107)
8	App\Entity\WsSiteSlide->getPageCss (line 1635)
9	twig_get_attribute (line 222)
10	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->block_stylesheets (line 171)
11	Twig\Template->displayBlock (line 94)
12	__TwigTemplate_761995aaad504a7e93d11a7bac9cd5c6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
24	App\Controller\DefaultController->homepageAction (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.96 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_key AS sort_key_3,
  t0.active AS active_4,
  t0.has_popup AS has_popup_5,
  t0.prod_ready AS prod_ready_6,
  t0.page_css AS page_css_7,
  t0.page_js AS page_js_8,
  t0.date_modified AS date_modified_9
FROM
  ws_site_slides t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\WsSiteSlide::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\WsSiteSlide->__get (line 107)
8	App\Entity\WsSiteSlide->getPageCss (line 1635)
9	twig_get_attribute (line 222)
10	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->block_stylesheets (line 171)
11	Twig\Template->displayBlock (line 94)
12	__TwigTemplate_761995aaad504a7e93d11a7bac9cd5c6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
24	App\Controller\DefaultController->homepageAction (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.83 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_key AS sort_key_3,
  t0.active AS active_4,
  t0.has_popup AS has_popup_5,
  t0.prod_ready AS prod_ready_6,
  t0.page_css AS page_css_7,
  t0.page_js AS page_js_8,
  t0.date_modified AS date_modified_9
FROM
  ws_site_slides t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_key AS sort_key_3, t0.active AS active_4, t0.has_popup AS has_popup_5, t0.prod_ready AS prod_ready_6, t0.page_css AS page_css_7, t0.page_js AS page_js_8, t0.date_modified AS date_modified_9 FROM ws_site_slides t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\WsSiteSlide::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\WsSiteSlide->__get (line 107)
8	App\Entity\WsSiteSlide->getPageCss (line 1635)
9	twig_get_attribute (line 222)
10	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->block_stylesheets (line 171)
11	Twig\Template->displayBlock (line 94)
12	__TwigTemplate_761995aaad504a7e93d11a7bac9cd5c6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 52)
15	__TwigTemplate_8481b2d5f9e9305d7a79549a7bd55154->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
24	App\Controller\DefaultController->homepageAction (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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.

Entities Mapping

Class	Mapping errors
App\Entity\WsUser	No errors.
App\Entity\WsSiteSlideLocale	No errors.
App\Entity\WsSiteSlide	No errors.

Symfony Profiler

GET https://dev.websaver.ca/en_ca/?msg=User%20not%20found%20by%20this%20email

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping