Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

7.41 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.09 ms
(41.68%)

SELECT a0_.id AS id_0, a0_.nom_artiste AS nom_artiste_1, a0_.bio AS bio_2, a0_.image_url AS image_url_3, a0_.created_at AS created_at_4, a0_.email AS email_5, a0_.tel AS tel_6, a0_.facebook_link AS facebook_link_7, a0_.instagram_link AS instagram_link_8, a0_.tiktok_link AS tiktok_link_9, a0_.ville_id AS ville_id_10 FROM artiste a0_ ORDER BY a0_.nom_artiste ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom_artiste AS nom_artiste_1,
  a0_.bio AS bio_2,
  a0_.image_url AS image_url_3,
  a0_.created_at AS created_at_4,
  a0_.email AS email_5,
  a0_.tel AS tel_6,
  a0_.facebook_link AS facebook_link_7,
  a0_.instagram_link AS instagram_link_8,
  a0_.tiktok_link AS tiktok_link_9,
  a0_.ville_id AS ville_id_10
FROM
  artiste a0_
ORDER BY
  a0_.nom_artiste ASC

SELECT a0_.id AS id_0, a0_.nom_artiste AS nom_artiste_1, a0_.bio AS bio_2, a0_.image_url AS image_url_3, a0_.created_at AS created_at_4, a0_.email AS email_5, a0_.tel AS tel_6, a0_.facebook_link AS facebook_link_7, a0_.instagram_link AS instagram_link_8, a0_.tiktok_link AS tiktok_link_9, a0_.ville_id AS ville_id_10 FROM artiste a0_ ORDER BY a0_.nom_artiste 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\Service\ArtisteService->findAllArtistes (line 95)
7	App\Controller\HomeController->index (line 49)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 32)
13	require_once (line 5)

1.21 ms
(16.41%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM genre_musical t0 INNER JOIN artiste_genre_musical ON t0.id = artiste_genre_musical.genre_musical_id WHERE artiste_genre_musical.artiste_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  genre_musical t0
  INNER JOIN artiste_genre_musical ON t0.id = artiste_genre_musical.genre_musical_id
WHERE
  artiste_genre_musical.artiste_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM genre_musical t0 INNER JOIN artiste_genre_musical ON t0.id = artiste_genre_musical.genre_musical_id WHERE artiste_genre_musical.artiste_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_38c4133cc9d3454d4ded707391809520::doDisplay (line 141)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_959b729755625c78d9cc55ba38cd04f0->block_body (line 117)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_33bfc780012f958a64b2c5fc9be08d56->doDisplay (line 320)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_959b729755625c78d9cc55ba38cd04f0->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\HomeController->index (line 48)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.13 ms
(15.23%)

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.debut AS debut_2, e0_.image AS image_3, e0_.description AS description_4, e0_.lien AS lien_5 FROM evenement e0_ WHERE e0_.debut > ? ORDER BY e0_.debut ASC LIMIT 10

Parameters:

[
  "2026-01-16 20:24:28"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nom AS nom_1,
  e0_.debut AS debut_2,
  e0_.image AS image_3,
  e0_.description AS description_4,
  e0_.lien AS lien_5
FROM
  evenement e0_
WHERE
  e0_.debut > ?
ORDER BY
  e0_.debut ASC
LIMIT
  10

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.debut AS debut_2, e0_.image AS image_3, e0_.description AS description_4, e0_.lien AS lien_5 FROM evenement e0_ WHERE e0_.debut > '2026-01-16 20:24:28' ORDER BY e0_.debut ASC LIMIT 10;

#	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\Service\EvenementService->findValideProgram (line 26)
7	App\Controller\HomeController->index (line 51)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 32)
13	require_once (line 5)

0.80 ms
(10.80%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.filename AS filename_3, t0.artiste_id AS artiste_id_4 FROM music t0 ORDER BY t0.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.filename AS filename_3,
  t0.artiste_id AS artiste_id_4
FROM
  music t0
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.filename AS filename_3, t0.artiste_id AS artiste_id_4 FROM music t0 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\MusicService->getAllMusic (line 30)
5	App\Controller\HomeController->index (line 50)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.60 ms
(8.09%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.description AS description_2, p0_.image_couverture_url AS image_couverture_url_3, p0_.lien AS lien_4 FROM podcast p0_ ORDER BY p0_.titre ASC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.description AS description_2,
  p0_.image_couverture_url AS image_couverture_url_3,
  p0_.lien AS lien_4
FROM
  podcast p0_
ORDER BY
  p0_.titre ASC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.description AS description_2, p0_.image_couverture_url AS image_couverture_url_3, p0_.lien AS lien_4 FROM podcast p0_ ORDER BY p0_.titre ASC LIMIT 4;

#	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\Controller\HomeController->index (line 52)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.58 ms
(7.79%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.prix AS prix_2, p0_.stock AS stock_3, p0_.image_file AS image_file_4 FROM produit p0_ WHERE p0_.nom LIKE ? ORDER BY p0_.id ASC LIMIT 4

Parameters:

[
  "%%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.prix AS prix_2,
  p0_.stock AS stock_3,
  p0_.image_file AS image_file_4
FROM
  produit p0_
WHERE
  p0_.nom LIKE ?
ORDER BY
  p0_.id ASC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.prix AS prix_2, p0_.stock AS stock_3, p0_.image_file AS image_file_4 FROM produit p0_ WHERE p0_.nom LIKE '%%' ORDER BY p0_.id ASC LIMIT 4;

#	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\Service\ProduitService->getProduit (line 46)
7	App\Controller\HomeController->index (line 53)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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 32)
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\Artiste	1
App\Entity\Ville	1
App\Entity\Music	1
App\Entity\GenreMusical	1

Entities Mapping

Class	Mapping errors
App\Entity\Artiste	No errors.
App\Entity\Ville	No errors.
App\Entity\GenreMusical	No errors.
App\Entity\Reservation	No errors.
App\Entity\Music	No errors.
App\Entity\Programme	No errors.
App\Entity\Evenement	No errors.
App\Entity\Podcast	No errors.
App\Entity\Produit	No errors.

Symfony Profiler

GET https://slayradio.ch/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping