Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.59 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.10 ms
(68.81%)

SELECT
                app_race.id, app_race.start_date, app_race.end_date, app_race.is_closed, app_race.name, app_race.race_year, app_race.program_file_name
            FROM app_race
            WHERE app_race.race_year = :race_year

Parameters:

[
  "race_year" => "2026"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  app_race.id,
  app_race.start_date,
  app_race.end_date,
  app_race.is_closed,
  app_race.name,
  app_race.race_year,
  app_race.program_file_name
FROM
  app_race
WHERE
  app_race.race_year = :race_year

SELECT
                app_race.id, app_race.start_date, app_race.end_date, app_race.is_closed, app_race.name, app_race.race_year, app_race.program_file_name
            FROM app_race
            WHERE app_race.race_year = '2026';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 38)
3	App\Repository\Page\RaceRepository->getRaceIdForRaceYear (line 42)
4	App\Controller\Page\RaceController->getRaceResults (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.50 ms
(31.19%)

SELECT 
                app_race_event.id, app_race_event.name, app_race_event.race_type, app_race_event.name_i18n, app_race_event.is_relay, app_race_event.category
            FROM app_race_event 
            WHERE app_race_event.id = :race_event_id and app_race_event.race_id = :race_id

Parameters:

[
  "race_event_id" => "e002a4a1-e71f-4957-acf0-bc3edd2a88de"
  "race_id" => "b7962ca5-964e-4ae2-a6a6-3564811d2bf8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  app_race_event.id,
  app_race_event.name,
  app_race_event.race_type,
  app_race_event.name_i18n,
  app_race_event.is_relay,
  app_race_event.category
FROM
  app_race_event
WHERE
  app_race_event.id = :race_event_id
  and app_race_event.race_id = :race_id

SELECT 
                app_race_event.id, app_race_event.name, app_race_event.race_type, app_race_event.name_i18n, app_race_event.is_relay, app_race_event.category
            FROM app_race_event 
            WHERE app_race_event.id = 'e002a4a1-e71f-4957-acf0-bc3edd2a88de' and app_race_event.race_id = 'b7962ca5-964e-4ae2-a6a6-3564811d2bf8';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 28)
3	App\Repository\Page\RaceEventRepository->get (line 48)
4	App\Controller\Page\RaceController->getRaceResults (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://vishalfmarathon.com/app/race/2026/e002a4a1-e71f-4957-acf0-bc3edd2a88de/results

Configuration Settings

Theme