Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

235.35 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

230.44 ms
(97.91%)

SELECT COUNT(*) FROM our_clients t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  our_clients t0

SELECT COUNT(*) FROM our_clients t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 67)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.25 ms
(0.53%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  category t0
  INNER JOIN blog_category ON t0.id = blog_category.category_id
WHERE
  blog_category.blog_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 618)
10	__TwigTemplate_e70ab868f5dcdcc8d2371322cd7f6c83->block_body (line 446)
11	Twig\Template->yieldBlock (line 419)
12	__TwigTemplate_a171a40af22365f34bed76ed5c979aab->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_e70ab868f5dcdcc8d2371322cd7f6c83->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
23	App\Controller\HomeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.85 ms
(0.36%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.featured_image AS featured_image_4, t0.content AS content_5, t0.visuals AS visuals_6, t0.testimonials AS testimonials_7, t0.published_status AS published_status_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.updated_at AS updated_at_11, t0.updated_by AS updated_by_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_keywords AS meta_keywords_15, t0.slug AS slug_16, t0.featured AS featured_17 FROM case_study t0 WHERE t0.featured = ? AND t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 3

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.client_name AS client_name_3,
  t0.featured_image AS featured_image_4,
  t0.content AS content_5,
  t0.visuals AS visuals_6,
  t0.testimonials AS testimonials_7,
  t0.published_status AS published_status_8,
  t0.created_at AS created_at_9,
  t0.created_by AS created_by_10,
  t0.updated_at AS updated_at_11,
  t0.updated_by AS updated_by_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14,
  t0.meta_keywords AS meta_keywords_15,
  t0.slug AS slug_16,
  t0.featured AS featured_17
FROM
  case_study t0
WHERE
  t0.featured = ?
  AND t0.published_status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.featured_image AS featured_image_4, t0.content AS content_5, t0.visuals AS visuals_6, t0.testimonials AS testimonials_7, t0.published_status AS published_status_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.updated_at AS updated_at_11, t0.updated_by AS updated_by_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_keywords AS meta_keywords_15, t0.slug AS slug_16, t0.featured AS featured_17 FROM case_study t0 WHERE t0.featured = 1 AND t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 54)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.80 ms
(0.34%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured_image AS featured_image_4, t0.published_status AS published_status_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.short_description AS short_description_14, t0.author_id AS author_id_15 FROM blog t0 WHERE t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 2

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.featured_image AS featured_image_4,
  t0.published_status AS published_status_5,
  t0.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.updated_at AS updated_at_8,
  t0.updated_by AS updated_by_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.meta_keywords AS meta_keywords_12,
  t0.slug AS slug_13,
  t0.short_description AS short_description_14,
  t0.author_id AS author_id_15
FROM
  blog t0
WHERE
  t0.published_status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  2

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured_image AS featured_image_4, t0.published_status AS published_status_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.short_description AS short_description_14, t0.author_id AS author_id_15 FROM blog t0 WHERE t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 59)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.70 ms
(0.30%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.featured_image AS featured_image_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.slug AS slug_9, t0.short_description AS short_description_10, t0.content AS content_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.featured_icon AS featured_icon_15, t0.featured AS featured_16 FROM our_services t0 WHERE t0.featured = ? AND t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 3

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.featured_image AS featured_image_3,
  t0.published_status AS published_status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.slug AS slug_9,
  t0.short_description AS short_description_10,
  t0.content AS content_11,
  t0.meta_title AS meta_title_12,
  t0.meta_description AS meta_description_13,
  t0.meta_keywords AS meta_keywords_14,
  t0.featured_icon AS featured_icon_15,
  t0.featured AS featured_16
FROM
  our_services t0
WHERE
  t0.featured = ?
  AND t0.published_status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.featured_image AS featured_image_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.slug AS slug_9, t0.short_description AS short_description_10, t0.content AS content_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.featured_icon AS featured_icon_15, t0.featured AS featured_16 FROM our_services t0 WHERE t0.featured = 1 AND t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.67 ms
(0.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM our_clients t0 WHERE t0.published_status = ? ORDER BY t0.created_at DESC LIMIT 5

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.logo AS logo_3,
  t0.published_status AS published_status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  our_clients t0
WHERE
  t0.published_status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.published_status AS published_status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM our_clients t0 WHERE t0.published_status = 1 ORDER BY t0.created_at DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 63)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.64 ms
(0.27%)

SELECT t0.id AS id_1, t0.route AS route_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.canonical_url AS canonical_url_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM seo_meta t0 WHERE t0.route = ? LIMIT 1

Parameters:

[
  "app_home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.route AS route_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.canonical_url AS canonical_url_6,
  t0.created_at AS created_at_7,
  t0.created_by AS created_by_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10
FROM
  seo_meta t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route AS route_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.canonical_url AS canonical_url_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM seo_meta t0 WHERE t0.route = 'app_home' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 48)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\OurClients	5
App\Entity\Category	4
App\Entity\OurServices	3
App\Entity\CaseStudy	3
App\Entity\Blog	2
App\Entity\SeoMeta	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\SeoMeta	No errors.
App\Entity\OurServices	No errors.
App\Entity\Tag	No errors.
App\Entity\CaseStudy	No errors.
App\Entity\Category	No errors.
App\Entity\Blog	No errors.
App\Entity\User	No errors.
App\Entity\OurClients	No errors.

Symfony Profiler

GET https://beta.cofso.in/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping