Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.30 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.07 ms

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.40 ms

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)

2.83 ms

SELECT t0.id AS id_1, t0.token AS token_2, t0.expire_date AS expire_date_3, t0.qrcode AS qrcode_4, t0.uuid AS uuid_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8, t0.category_fonction_id AS category_fonction_id_9, t0.short_link_id AS short_link_id_10 FROM link_register t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "15245cb8f64fa9844d60d8c33bdc39905fcb54f950e35fdc221d275f775a10d2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.expire_date AS expire_date_3,
  t0.qrcode AS qrcode_4,
  t0.uuid AS uuid_5,
  t0.updated_at AS updated_at_6,
  t0.created_at AS created_at_7,
  t0.user_id AS user_id_8,
  t0.category_fonction_id AS category_fonction_id_9,
  t0.short_link_id AS short_link_id_10
FROM
  link_register t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.expire_date AS expire_date_3, t0.qrcode AS qrcode_4, t0.uuid AS uuid_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8, t0.category_fonction_id AS category_fonction_id_9, t0.short_link_id AS short_link_id_10 FROM link_register t0 WHERE t0.token = '15245cb8f64fa9844d60d8c33bdc39905fcb54f950e35fdc221d275f775a10d2' 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 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\LinkRegister	1
App\Entity\User	1
App\Entity\CategoryFonction	1
App\Entity\ShortLink	1

Entities Mapping

Class	Mapping errors
App\Entity\SeoCity	No errors.
App\Entity\SeoCountry	No errors.
App\Entity\LinkRegister	No errors.
App\Entity\User	No errors.
App\Entity\CategoryFonction	No errors.
App\Entity\ShortLink	No errors.
App\Entity\LinkRegisterGroup	No errors.

Symfony Profiler

GET https://demo.churchmanager.fr/user/15245cb8f64fa9844d60d8c33bdc39905fcb54f950e35fdc221d275f775a10d2/register

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping