Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

9.66 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.91 ms
(50.83%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1

Parameters:

[
  "manager"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 163)
5	App\Manager\ManagerManager->getFirstManagerByType (line 25)
6	App\Twig\Runtime\ManagerRuntime->managerApp (line 85)
7	__TwigTemplate_128e3676cc7376977c8d3c2d5a1118ec->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1520)
12	Twig\Extension\CoreExtension::include (line 902)
13	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->block_base_footer (line 446)
14	Twig\Template->yieldBlock (line 357)
15	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_fa6f97a916e5e07e83d70074b81a138b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
26	App\Controller\Home\SecurityController->login (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

2.23 ms
(23.09%)

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.author_name AS author_name_2,
  t0.author_url AS author_url_3,
  t0.profile_photo_url AS profile_photo_url_4,
  t0.rating AS rating_5,
  t0.text AS text_6,
  t0.time AS time_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  google_reviews t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.rating DESC,
  t0.created_at DESC
LIMIT
  50

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 37)
5	App\Service\GoogleReviewsService->getReviews (line 68)
6	App\Twig\GoogleReviewsExtension->getGoogleReviewsStats (line 171)
7	__TwigTemplate_b1c84903bb8a35e97613c44365e8542f->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1520)
12	Twig\Extension\CoreExtension::include (line 853)
13	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->block_schema_org (line 446)
14	Twig\Template->yieldBlock (line 324)
15	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_fa6f97a916e5e07e83d70074b81a138b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
26	App\Controller\Home\SecurityController->login (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.19 ms
(12.35%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.h1 AS h1_5,
  s0_.content AS content_6,
  s0_.keywords AS keywords_7,
  s0_.is_active AS is_active_8,
  s0_.postal_code AS postal_code_9,
  s0_.region AS region_10,
  s0_.country AS country_11,
  s0_.city_image AS city_image_12,
  s0_.created_at AS created_at_13,
  s0_.updated_at AS updated_at_14
FROM
  seo_city s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 47)
7	App\Repository\SeoCityRepository->findAllActive (line 39)
8	App\Manager\SeoCityManager->findAllActive (line 47)
9	App\EventSubscriber\TwigGlobalVariablesSubscriber->onKernelController (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.69 ms
(7.15%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.h1 AS h1_5,
  s0_.content AS content_6,
  s0_.keywords AS keywords_7,
  s0_.is_active AS is_active_8,
  s0_.country_code AS country_code_9,
  s0_.continent AS continent_10,
  s0_.language AS language_11,
  s0_.created_at AS created_at_12,
  s0_.updated_at AS updated_at_13
FROM
  seo_country s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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\SeoCountryRepository->findAllActive (line 33)
8	App\Manager\SeoCountryManager->findAllActive (line 48)
9	App\EventSubscriber\TwigGlobalVariablesSubscriber->onKernelController (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.64 ms
(6.59%)

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = ? ORDER BY t0.rating DESC, 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.author_name AS author_name_2,
  t0.author_url AS author_url_3,
  t0.profile_photo_url AS profile_photo_url_4,
  t0.rating AS rating_5,
  t0.text AS text_6,
  t0.time AS time_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  google_reviews t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.rating DESC,
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.author_name AS author_name_2, t0.author_url AS author_url_3, t0.profile_photo_url AS profile_photo_url_4, t0.rating AS rating_5, t0.text AS text_6, t0.time AS time_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM google_reviews t0 WHERE t0.is_active = 1 ORDER BY t0.rating DESC, t0.created_at DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 37)
5	App\Service\GoogleReviewsService->getReviews (line 39)
6	App\Twig\GoogleReviewsExtension->getGoogleReviews (line 193)
7	__TwigTemplate_b1c84903bb8a35e97613c44365e8542f->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 1520)
12	Twig\Extension\CoreExtension::include (line 853)
13	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->block_schema_org (line 446)
14	Twig\Template->yieldBlock (line 324)
15	__TwigTemplate_02348a436f7400d07b94efab627fd0ac->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_fa6f97a916e5e07e83d70074b81a138b->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
26	App\Controller\Home\SecurityController->login (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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\Manager	1

Entities Mapping

Class	Mapping errors
App\Entity\SeoCity	No errors.
App\Entity\SeoCountry	No errors.
App\Entity\GoogleReview	No errors.
App\Entity\Manager	No errors.
App\Entity\SocialMedia	No errors.

Symfony Profiler

GET https://demo.churchmanager.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping