Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.28 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.17 ms
(91.42%)

SELECT t0.id AS id_1, t0.intro_text AS intro_text_2, t0.title AS title_3, t0.full_text AS full_text_4, t0.alias AS alias_5, t0.created AS created_6, t0.ordering AS ordering_7, t0.views AS views_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.image AS image_11, t0.image_title AS image_title_12, t0.image_alt AS image_alt_13, t0.metatitle AS metatitle_14, t0.search_text AS search_text_15, t0.category_id AS category_id_16, t0.sub_category_id AS sub_category_id_17 FROM blog t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  "tests-psychotechniques-ead"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.intro_text AS intro_text_2,
  t0.title AS title_3,
  t0.full_text AS full_text_4,
  t0.alias AS alias_5,
  t0.created AS created_6,
  t0.ordering AS ordering_7,
  t0.views AS views_8,
  t0.metakey AS metakey_9,
  t0.metadesc AS metadesc_10,
  t0.image AS image_11,
  t0.image_title AS image_title_12,
  t0.image_alt AS image_alt_13,
  t0.metatitle AS metatitle_14,
  t0.search_text AS search_text_15,
  t0.category_id AS category_id_16,
  t0.sub_category_id AS sub_category_id_17
FROM
  blog t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.intro_text AS intro_text_2, t0.title AS title_3, t0.full_text AS full_text_4, t0.alias AS alias_5, t0.created AS created_6, t0.ordering AS ordering_7, t0.views AS views_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.image AS image_11, t0.image_title AS image_title_12, t0.image_alt AS image_alt_13, t0.metatitle AS metatitle_14, t0.search_text AS search_text_15, t0.category_id AS category_id_16, t0.sub_category_id AS sub_category_id_17 FROM blog t0 WHERE t0.alias = 'tests-psychotechniques-ead' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.11 ms
(8.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.category_id AS category_id_4 FROM blog_sub_category 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.status AS status_3,
  t0.category_id AS category_id_4
FROM
  blog_sub_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.category_id AS category_id_4 FROM blog_sub_category t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\BlogSubCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\BlogSubCategory->__get (line 153)
7	App\Entity\BlogSubCategory->getName (line 33)
8	App\Controller\BlogController->showArticle (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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\Blog	1
App\Entity\BlogCategory	1
App\Entity\BlogSubCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\Blog	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\BlogSubCategory	No errors.

Symfony Profiler

GET http://www.tp.aac-testpsycho.fr/blog/tests-psychotechniques-ead

Configuration Settings

Theme

Page Width