Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

4.76 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.10 ms
(23.18%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.publication_date AS publication_date_6, t0.visits_count AS visits_count_7, t0.video_url AS video_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.deleted AS deleted_12, t0.category AS category_13 FROM page t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.publication_date AS publication_date_6,
  t0.visits_count AS visits_count_7,
  t0.video_url AS video_url_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.deleted AS deleted_12,
  t0.category AS category_13
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.publication_date AS publication_date_6, t0.visits_count AS visits_count_7, t0.video_url AS video_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.deleted AS deleted_12, t0.category AS category_13 FROM page t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\ArticlesController->articles (line 139)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
11	frankenphp_handle_request (line 45)
12	Runtime\FrankenPhpSymfony\Runner::run (line 45)
13	require_once (line 32)
14	require_once (line 5)

0.78 ms
(16.33%)

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.created_at DESC LIMIT 5

Parameters:

[
  "article"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.content AS content_4,
  p0_.publication_date AS publication_date_5,
  p0_.visits_count AS visits_count_6,
  p0_.video_url AS video_url_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p0_.deleted_at AS deleted_at_10,
  p0_.deleted AS deleted_11,
  p0_.category AS category_12
FROM
  page p0_
WHERE
  p0_.type = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = 'article' ORDER BY p0_.created_at DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Page\PageRepository->findAllArticles (line 32)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 55)
8	App\Controller\ArticlesController->articles (line 185)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	require_once (line 5)

0.61 ms
(12.76%)

SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page_media p0_ WHERE p0_.page_id = ? AND p0_.is_enabled = true ORDER BY p0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_enabled AS is_enabled_1,
  p0_.is_default AS is_default_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.deleted_at AS deleted_at_5,
  p0_.deleted AS deleted_6,
  p0_.original_filename AS original_filename_7,
  p0_.path AS path_8,
  p0_.mime_type AS mime_type_9,
  p0_.alt AS alt_10,
  p0_.size AS size_11,
  p0_.file_updated_at AS file_updated_at_12,
  p0_.page_id AS page_id_13
FROM
  page_media p0_
WHERE
  p0_.page_id = ?
  AND p0_.is_enabled = true
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page_media p0_ WHERE p0_.page_id = 1 AND p0_.is_enabled = true ORDER BY p0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Page\MediaRepository->findEnabledByPage (line 27)
7	App\Controller\ArticlesController->articles (line 144)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
12	frankenphp_handle_request (line 45)
13	Runtime\FrankenPhpSymfony\Runner::run (line 45)
14	require_once (line 32)
15	require_once (line 5)

0.60 ms
(12.55%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ArticlesController->articles (line 142)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
8	frankenphp_handle_request (line 45)
9	Runtime\FrankenPhpSymfony\Runner::run (line 45)
10	require_once (line 32)
11	require_once (line 5)

0.48 ms
(10.01%)

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> ? ORDER BY a0_.label ASC

Parameters:

[
  "autre"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.deleted_at AS deleted_at_4,
  a0_.deleted AS deleted_5,
  a0_.parent_category AS parent_category_6
FROM
  article_category a0_
WHERE
  a0_.parent_category IS NULL
  AND LOWER(a0_.label) <> ?
ORDER BY
  a0_.label ASC

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> 'autre' ORDER BY a0_.label ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Page\ArticleCategoryRepository->findDefaultCategories (line 45)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 62)
8	App\Controller\ArticlesController->articles (line 185)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	require_once (line 5)

0.41 ms
(8.53%)

UPDATE page SET visits_count = ?, updated_at = ? WHERE id = ?

Parameters:

[
  70
  "2026-03-31 17:59:58"
  1
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  page
SET
  visits_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE page SET visits_count = 70, updated_at = '2026-03-31 17:59:58' WHERE id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\ArticlesController->articles (line 142)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
11	frankenphp_handle_request (line 45)
12	Runtime\FrankenPhpSymfony\Runner::run (line 45)
13	require_once (line 32)
14	require_once (line 5)

0.37 ms
(7.84%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.deleted AS deleted_6, t0.parent_category AS parent_category_7 FROM article_category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.deleted AS deleted_6,
  t0.parent_category AS parent_category_7
FROM
  article_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.deleted AS deleted_6, t0.parent_category AS parent_category_7 FROM article_category t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Page\ArticleCategory::getLabel (line 57)
5	App\Controller\ArticlesController->articles (line 174)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
10	frankenphp_handle_request (line 45)
11	Runtime\FrankenPhpSymfony\Runner::run (line 45)
12	require_once (line 32)
13	require_once (line 5)

0.27 ms
(5.59%)

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = ? LIMIT 1

Parameters:

[
  "autre"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.deleted_at AS deleted_at_4,
  a0_.deleted AS deleted_5,
  a0_.parent_category AS parent_category_6
FROM
  article_category a0_
WHERE
  LOWER(a0_.label) = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = 'autre' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\ArticlesService->getOrCreateOtherCategory (line 32)
7	App\Service\ArticlesService->getCategoriesAndRecentArticles (line 69)
8	App\Controller\ArticlesController->articles (line 185)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
13	frankenphp_handle_request (line 45)
14	Runtime\FrankenPhpSymfony\Runner::run (line 45)
15	require_once (line 32)
16	require_once (line 5)

0.15 ms
(3.21%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ArticlesController->articles (line 142)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
8	frankenphp_handle_request (line 45)
9	Runtime\FrankenPhpSymfony\Runner::run (line 45)
10	require_once (line 32)
11	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\Page\Page	3
App\Entity\Page\ArticleCategory	2
App\Entity\Page\Media	2

Entities Mapping

Class	Mapping errors
App\Entity\Security\User	No errors.
App\Entity\Geo\City	No errors.
App\Entity\Geo\Region	No errors.
App\Entity\Geo\Department	No errors.
App\Entity\Module\Module	No errors.
App\Entity\Module\Tag	No errors.
App\Entity\Contact\Contact	No errors.
App\Entity\Common\Hours	No errors.
App\Entity\Common\Address	No errors.
App\Entity\LegalUnit\NafCode	No errors.
App\Entity\LegalUnit\NaturalPerson	No errors.
App\Entity\LegalUnit\Establishment	No errors.
App\Entity\LegalUnit\Profile\Faq	No errors.
App\Entity\LegalUnit\Profile\SocietyProfile	No errors.
App\Entity\LegalUnit\Profile\Product	No errors.
App\Entity\LegalUnit\Profile\SpecialHours	No errors.
App\Entity\LegalUnit\Profile\Logo	No errors.
App\Entity\LegalUnit\LegalUnit	No errors.
App\Entity\Page\ArticleCategory	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Page\Media	No errors.
Zhortein\AuditableBundle\Entity\AuditEntry	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://bbernier.devlogiciel.com/actualites/article/1-Agence%20de%20communication%20globale%20sur%20Clermont%20Ferrand%20:%20quel%20est%20l%E2%80%99int%C3%A9r%C…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping