Symfony Profiler

Query Metrics

12 Database Queries

4 Different statements

6.07 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.51 ms
(57.86%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_secret_key AS stripe_secret_key_6, t0.stripe_publishable_key AS stripe_publishable_key_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM departement t0 INNER JOIN actualite_departement ON t0.id = actualite_departement.departement_id WHERE actualite_departement.actualite_id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.slug AS slug_4,
  t0.stripe_account_id AS stripe_account_id_5,
  t0.stripe_secret_key AS stripe_secret_key_6,
  t0.stripe_publishable_key AS stripe_publishable_key_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  departement t0
  INNER JOIN actualite_departement ON t0.id = actualite_departement.departement_id
WHERE
  actualite_departement.actualite_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_secret_key AS stripe_secret_key_6, t0.stripe_publishable_key AS stripe_publishable_key_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM departement t0 INNER JOIN actualite_departement ON t0.id = actualite_departement.departement_id WHERE actualite_departement.actualite_id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
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 446)
9	Doctrine\ORM\PersistentCollection->isEmpty (line 179)
10	App\Service\Seo\SitemapGenerator->getActualitesUrls (line 59)
11	App\Service\Seo\SitemapGenerator->generate (line 25)
12	App\Controller\Public\SitemapController->__invoke (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.48 ms
(24.40%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.contenu AS contenu_2, a0_.slug AS slug_3, a0_.meta_title AS meta_title_4, a0_.meta_description AS meta_description_5, a0_.meta_keywords AS meta_keywords_6, a0_.status AS status_7, a0_.featured_image AS featured_image_8, a0_.date_publication AS date_publication_9, a0_.tags AS tags_10, a0_.is_flash AS is_flash_11, a0_.visible_public AS visible_public_12, a0_.premium AS premium_13, a0_.turbulances_article AS turbulances_article_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.categorie_id AS categorie_id_17 FROM actualite a0_ WHERE a0_.status = ? AND a0_.date_publication <= ? AND a0_.visible_public = ? ORDER BY a0_.date_publication DESC

Parameters:

[
  "published"
  "2026-04-09 20:57:24"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.contenu AS contenu_2,
  a0_.slug AS slug_3,
  a0_.meta_title AS meta_title_4,
  a0_.meta_description AS meta_description_5,
  a0_.meta_keywords AS meta_keywords_6,
  a0_.status AS status_7,
  a0_.featured_image AS featured_image_8,
  a0_.date_publication AS date_publication_9,
  a0_.tags AS tags_10,
  a0_.is_flash AS is_flash_11,
  a0_.visible_public AS visible_public_12,
  a0_.premium AS premium_13,
  a0_.turbulances_article AS turbulances_article_14,
  a0_.created_at AS created_at_15,
  a0_.updated_at AS updated_at_16,
  a0_.categorie_id AS categorie_id_17
FROM
  actualite a0_
WHERE
  a0_.status = ?
  AND a0_.date_publication <= ?
  AND a0_.visible_public = ?
ORDER BY
  a0_.date_publication DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.contenu AS contenu_2, a0_.slug AS slug_3, a0_.meta_title AS meta_title_4, a0_.meta_description AS meta_description_5, a0_.meta_keywords AS meta_keywords_6, a0_.status AS status_7, a0_.featured_image AS featured_image_8, a0_.date_publication AS date_publication_9, a0_.tags AS tags_10, a0_.is_flash AS is_flash_11, a0_.visible_public AS visible_public_12, a0_.premium AS premium_13, a0_.turbulances_article AS turbulances_article_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.categorie_id AS categorie_id_17 FROM actualite a0_ WHERE a0_.status = 'published' AND a0_.date_publication <= '2026-04-09 20:57:24' AND a0_.visible_public = 1 ORDER BY a0_.date_publication DESC;

#	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 157)
7	App\Service\Seo\SitemapGenerator->getActualitesUrls (line 59)
8	App\Service\Seo\SitemapGenerator->generate (line 25)
9	App\Controller\Public\SitemapController->__invoke (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.66 ms
(10.92%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_secret_key AS stripe_secret_key_6, t0.stripe_publishable_key AS stripe_publishable_key_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM departement t0 INNER JOIN formation_departement ON t0.id = formation_departement.departement_id WHERE formation_departement.formation_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.slug AS slug_4,
  t0.stripe_account_id AS stripe_account_id_5,
  t0.stripe_secret_key AS stripe_secret_key_6,
  t0.stripe_publishable_key AS stripe_publishable_key_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  departement t0
  INNER JOIN formation_departement ON t0.id = formation_departement.departement_id
WHERE
  formation_departement.formation_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_secret_key AS stripe_secret_key_6, t0.stripe_publishable_key AS stripe_publishable_key_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM departement t0 INNER JOIN formation_departement ON t0.id = formation_departement.departement_id WHERE formation_departement.formation_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
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 446)
9	Doctrine\ORM\PersistentCollection->isEmpty (line 233)
10	App\Service\Seo\SitemapGenerator->getFormationsUrls (line 62)
11	App\Service\Seo\SitemapGenerator->generate (line 25)
12	App\Controller\Public\SitemapController->__invoke (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.41 ms
(6.82%)

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.slug AS slug_2, f0_.organisme AS organisme_3, f0_.categorie AS categorie_4, f0_.status AS status_5, f0_.description AS description_6, f0_.date_debut AS date_debut_7, f0_.date_fin AS date_fin_8, f0_.date_publication AS date_publication_9, f0_.lien_inscription AS lien_inscription_10, f0_.pdf_url AS pdf_url_11, f0_.featured_image AS featured_image_12, f0_.pdf_file AS pdf_file_13, f0_.tags AS tags_14, f0_.meta_title AS meta_title_15, f0_.meta_description AS meta_description_16, f0_.meta_keywords AS meta_keywords_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.categorie_v2_id AS categorie_v2_id_20 FROM formation f0_ WHERE f0_.status = ? AND (f0_.date_publication IS NULL OR f0_.date_publication <= ?) ORDER BY f0_.date_publication DESC

Parameters:

[
  "published"
  "2026-04-09 20:57:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.slug AS slug_2,
  f0_.organisme AS organisme_3,
  f0_.categorie AS categorie_4,
  f0_.status AS status_5,
  f0_.description AS description_6,
  f0_.date_debut AS date_debut_7,
  f0_.date_fin AS date_fin_8,
  f0_.date_publication AS date_publication_9,
  f0_.lien_inscription AS lien_inscription_10,
  f0_.pdf_url AS pdf_url_11,
  f0_.featured_image AS featured_image_12,
  f0_.pdf_file AS pdf_file_13,
  f0_.tags AS tags_14,
  f0_.meta_title AS meta_title_15,
  f0_.meta_description AS meta_description_16,
  f0_.meta_keywords AS meta_keywords_17,
  f0_.created_at AS created_at_18,
  f0_.updated_at AS updated_at_19,
  f0_.categorie_v2_id AS categorie_v2_id_20
FROM
  formation f0_
WHERE
  f0_.status = ?
  AND (
    f0_.date_publication IS NULL
    OR f0_.date_publication <= ?
  )
ORDER BY
  f0_.date_publication DESC

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.slug AS slug_2, f0_.organisme AS organisme_3, f0_.categorie AS categorie_4, f0_.status AS status_5, f0_.description AS description_6, f0_.date_debut AS date_debut_7, f0_.date_fin AS date_fin_8, f0_.date_publication AS date_publication_9, f0_.lien_inscription AS lien_inscription_10, f0_.pdf_url AS pdf_url_11, f0_.featured_image AS featured_image_12, f0_.pdf_file AS pdf_file_13, f0_.tags AS tags_14, f0_.meta_title AS meta_title_15, f0_.meta_description AS meta_description_16, f0_.meta_keywords AS meta_keywords_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.categorie_v2_id AS categorie_v2_id_20 FROM formation f0_ WHERE f0_.status = 'published' AND (f0_.date_publication IS NULL OR f0_.date_publication <= '2026-04-09 20:57:25') ORDER BY f0_.date_publication DESC;

#	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 213)
7	App\Service\Seo\SitemapGenerator->getFormationsUrls (line 62)
8	App\Service\Seo\SitemapGenerator->generate (line 25)
9	App\Controller\Public\SitemapController->__invoke (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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\Content\Actualite	8
App\Entity\Geography\Departement	3
App\Entity\Event\Formation	2
App\Entity\Content\ActuCategorie	1

Entities Mapping

Class	Mapping errors
App\Entity\Content\Actualite	No errors.
App\Entity\Content\ActuCategorie	No errors.
App\Entity\Geography\Departement	No errors.
App\Entity\Enterprise\Entreprise	No errors.
App\Entity\Event\Evenement	No errors.
App\Entity\Event\Formation	No errors.
App\Entity\Event\FormationCategoryV2	No errors.

Symfony Profiler

GET http://51.75.65.136/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping