Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

7.98 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.81 ms
(22.63%)

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.opponent AS opponent_2, t0_.match_date AS match_date_3, t0_.guest_availability_date AS guest_availability_date_4, t0_.member_availability_date AS member_availability_date_5, t0_.match_location AS match_location_6, t0_.venue AS venue_7, t0_.billetweb_url AS billetweb_url_8, t0_.price AS price_9, t0_.description AS description_10, t0_.stock AS stock_11, t1_.id AS id_12, t1_.name AS name_13, t1_.slug AS slug_14, t0_.image_id AS image_id_15, t0_.category_id AS category_id_16 FROM ticket t0_ LEFT JOIN ticket_category t1_ ON t0_.category_id = t1_.id WHERE t0_.match_date > ? AND ((t0_.guest_availability_date IS NULL OR t0_.guest_availability_date <= ?)) ORDER BY t0_.match_date ASC

Parameters:

[
  "2026-08-14 08:48:01"
  "2026-08-14 08:48:01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.opponent AS opponent_2,
  t0_.match_date AS match_date_3,
  t0_.guest_availability_date AS guest_availability_date_4,
  t0_.member_availability_date AS member_availability_date_5,
  t0_.match_location AS match_location_6,
  t0_.venue AS venue_7,
  t0_.billetweb_url AS billetweb_url_8,
  t0_.price AS price_9,
  t0_.description AS description_10,
  t0_.stock AS stock_11,
  t1_.id AS id_12,
  t1_.name AS name_13,
  t1_.slug AS slug_14,
  t0_.image_id AS image_id_15,
  t0_.category_id AS category_id_16
FROM
  ticket t0_
  LEFT JOIN ticket_category t1_ ON t0_.category_id = t1_.id
WHERE
  t0_.match_date > ?
  AND (
    (
      t0_.guest_availability_date IS NULL
      OR t0_.guest_availability_date <= ?
    )
  )
ORDER BY
  t0_.match_date ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.opponent AS opponent_2, t0_.match_date AS match_date_3, t0_.guest_availability_date AS guest_availability_date_4, t0_.member_availability_date AS member_availability_date_5, t0_.match_location AS match_location_6, t0_.venue AS venue_7, t0_.billetweb_url AS billetweb_url_8, t0_.price AS price_9, t0_.description AS description_10, t0_.stock AS stock_11, t1_.id AS id_12, t1_.name AS name_13, t1_.slug AS slug_14, t0_.image_id AS image_id_15, t0_.category_id AS category_id_16 FROM ticket t0_ LEFT JOIN ticket_category t1_ ON t0_.category_id = t1_.id WHERE t0_.match_date > '2026-08-14 08:48:01' AND ((t0_.guest_availability_date IS NULL OR t0_.guest_availability_date <= '2026-08-14 08:48:01')) ORDER BY t0_.match_date 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\TicketRepository->findPublicTickets (line 41)
7	App\Controller\TicketController->index (line 42)
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	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.45 ms
(18.11%)

SELECT DISTINCT e0_.season AS season_0 FROM event e0_ INNER JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e1_.section = ? AND e0_.season IS NOT NULL AND e0_.season <> '' ORDER BY e0_.season DESC

Parameters:

[
  "photos_de_match"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT e0_.season AS season_0
FROM
  event e0_
  INNER JOIN event_category e1_ ON e0_.category_id = e1_.id
WHERE
  e1_.section = ?
  AND e0_.season IS NOT NULL
  AND e0_.season <> ''
ORDER BY
  e0_.season DESC

SELECT DISTINCT e0_.season AS season_0 FROM event e0_ INNER JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e1_.section = 'photos_de_match' AND e0_.season IS NOT NULL AND e0_.season <> '' ORDER BY e0_.season DESC;

#	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->getSingleColumnResult (line 712)
6	App\Repository\EventRepository->findSeasonsBySection (line 33)
7	App\Twig\EventSeasonExtension->getSeasons (line 40)
8	App\Twig\EventSeasonExtension->getGlobals (line 24)
9	Twig\ExtensionSet->getGlobals (line 365)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 406)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
19	App\Controller\TicketController->index (line 44)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.23 ms
(15.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.section AS section_4 FROM event_category t0 WHERE t0.section = ? ORDER BY t0.name ASC

Parameters:

[
  "medias"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.section AS section_4
FROM
  event_category t0
WHERE
  t0.section = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.section AS section_4 FROM event_category t0 WHERE t0.section = 'medias' ORDER BY t0.name ASC;

#	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\Repository\EventCategoryRepository->findBySection (line 24)
5	App\Twig\EventCategoryExtension->getMediaCategories (line 36)
6	App\Twig\EventCategoryExtension->getGlobals (line 23)
7	Twig\ExtensionSet->getGlobals (line 365)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 406)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
17	App\Controller\TicketController->index (line 44)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.23 ms
(15.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM ticket_category t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  ticket_category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM ticket_category t0 ORDER BY t0.name ASC;

#	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\Controller\TicketController->index (line 33)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.16 ms
(14.54%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.gallery_id AS gallery_id_5, t0.group_page_id AS group_page_id_6, t0.merch_id AS merch_id_7, t0.event_id AS event_id_8, t0.post_id AS post_id_9 FROM media t0 WHERE t0.id = ?

Parameters:

[
  63
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.updated_at AS updated_at_4,
  t0.gallery_id AS gallery_id_5,
  t0.group_page_id AS group_page_id_6,
  t0.merch_id AS merch_id_7,
  t0.event_id AS event_id_8,
  t0.post_id AS post_id_9
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.gallery_id AS gallery_id_5, t0.group_page_id AS group_page_id_6, t0.merch_id AS merch_id_7, t0.event_id AS event_id_8, t0.post_id AS post_id_9 FROM media t0 WHERE t0.id = 63;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Media->__get (line 153)
7	App\Entity\Media->getPath (line 64)
8	App\Twig\SiteConfigExtension->getBackgroundUrl (line 58)
9	App\Twig\SiteConfigExtension->getGlobals (line 29)
10	Twig\ExtensionSet->getGlobals (line 365)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 406)
13	Twig\Template->display (line 366)
14	Twig\Template->render (line 381)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	App\Controller\TicketController->index (line 44)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.11 ms
(13.87%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.hero_title AS hero_title_3, t0.hero_subtitle AS hero_subtitle_4, t0.chants_subtitle AS chants_subtitle_5, t0.chants_title AS chants_title_6, t0.background_image_id AS background_image_id_7 FROM site_config t0 ORDER BY t0.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.hero_title AS hero_title_3,
  t0.hero_subtitle AS hero_subtitle_4,
  t0.chants_subtitle AS chants_subtitle_5,
  t0.chants_title AS chants_title_6,
  t0.background_image_id AS background_image_id_7
FROM
  site_config t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.hero_title AS hero_title_3, t0.hero_subtitle AS hero_subtitle_4, t0.chants_subtitle AS chants_subtitle_5, t0.chants_title AS chants_title_6, t0.background_image_id AS background_image_id_7 FROM site_config t0 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\SiteConfigExtension->getConfig (line 76)
5	App\Twig\SiteConfigExtension->getSiteName (line 42)
6	App\Twig\SiteConfigExtension->getGlobals (line 27)
7	Twig\ExtensionSet->getGlobals (line 365)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 406)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
17	App\Controller\TicketController->index (line 44)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	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\TicketCategory	2
App\Entity\EventCategory	1
App\Entity\SiteConfig	1
App\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Entity\TicketCategory	No errors.
App\Entity\Ticket	No errors.
App\Entity\Media	No errors.
App\Entity\EventCategory	No errors.
App\Entity\Event	No errors.
App\Entity\SiteConfig	No errors.
App\Entity\Gallery	No errors.
App\Entity\GroupPage	No errors.
App\Entity\Merch	No errors.
App\Entity\Post	No errors.

Symfony Profiler

GET http://ultraslions-fleury.fr/billetterie/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping