Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

7.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.63 ms
(22.89%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.logo_path AS logo_path_5,
  t0.keywords AS keywords_6
FROM
  seo t0

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 50)
6	App\Twig\GlobalVars->getGlobalVars (line 102)
7	__TwigTemplate_abfd14e5e84e20001c392eb4faf70347->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 280)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
16	App\Controller\ResetPasswordController->request (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.53 ms
(21.58%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.phone_number AS phone_number_3,
  t0.work_hours AS work_hours_4,
  t0.instagram_link AS instagram_link_5,
  t0.facebook_link AS facebook_link_6,
  t0.youtube_link AS youtube_link_7,
  t0.tiktok_link AS tiktok_link_8,
  t0.business_location AS business_location_9,
  t0.twitter_link AS twitter_link_10,
  t0.linkedin_link AS linkedin_link_11,
  t0.google_map_embed AS google_map_embed_12,
  t0.email_address AS email_address_13
FROM
  setting t0

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 51)
6	App\Twig\GlobalVars->getGlobalVars (line 102)
7	__TwigTemplate_abfd14e5e84e20001c392eb4faf70347->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 280)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
16	App\Controller\ResetPasswordController->request (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.45 ms
(20.33%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.content AS content_2,
  b0_.publication_date AS publication_date_3,
  b0_.is_published AS is_published_4,
  b0_.slug AS slug_5,
  b0_.featured_image AS featured_image_6,
  b0_.meta_title AS meta_title_7,
  b0_.meta_description AS meta_description_8,
  b0_.video_url AS video_url_9,
  b0_.author_id AS author_id_10
FROM
  blog b0_
WHERE
  b0_.is_published = ?
ORDER BY
  b0_.id DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = 1 ORDER BY b0_.id DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 39)
7	App\Repository\BlogRepository->findPublished (line 53)
8	App\Twig\GlobalVars->getGlobalVars (line 102)
9	__TwigTemplate_abfd14e5e84e20001c392eb4faf70347->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
18	App\Controller\ResetPasswordController->request (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.34 ms
(18.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.keywords AS keywords_6,
  t0.image AS image_7,
  t0.slug AS slug_8
FROM
  car_make t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 54)
6	App\Twig\GlobalVars->getGlobalVars (line 102)
7	__TwigTemplate_abfd14e5e84e20001c392eb4faf70347->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 280)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
16	App\Controller\ResetPasswordController->request (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.16 ms
(16.34%)

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8 FROM page p0_ WHERE p0_.is_service = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.heading AS heading_1,
  p0_.meta_title AS meta_title_2,
  p0_.meta_description AS meta_description_3,
  p0_.url AS url_4,
  p0_.featured_image AS featured_image_5,
  p0_.page_content AS page_content_6,
  p0_.content_first AS content_first_7,
  p0_.is_service AS is_service_8
FROM
  page p0_
WHERE
  p0_.is_service = ?

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8 FROM page p0_ WHERE p0_.is_service = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\PageRepository->findByIsService (line 55)
8	App\Twig\GlobalVars->getGlobalVars (line 102)
9	__TwigTemplate_abfd14e5e84e20001c392eb4faf70347->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
18	App\Controller\ResetPasswordController->request (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\SEO	No errors.
App\Entity\Setting	No errors.
App\Entity\Blog	No errors.
App\Entity\User	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\CarMake	No errors.
App\Entity\Car	No errors.
App\Entity\CarModel	No errors.
App\Entity\Page	No errors.
App\Entity\Section	No errors.

Symfony Profiler

GET https://gybird.co.ke/reset/reset-password

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping