Symfony Profiler

Query Metrics

12 Database Queries

9 Different statements

3.12 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.83 ms
(26.48%)

"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\TourHTMLController->trackurl (line 175)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.54 ms
(17.38%)

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.trackid_id = ? AND t0.urlname = ? LIMIT 1

Parameters:

[
  69
  "afternoon"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.configname AS configname_2,
  t0.iracingid AS iracingid_3,
  t0.length_km AS length_km_4,
  t0.length_miles AS length_miles_5,
  t0.corners AS corners_6,
  t0.image AS image_7,
  t0.urlname AS urlname_8,
  t0.active AS active_9,
  t0.premium_full AS premium_full_10,
  t0.premium_oval AS premium_oval_11,
  t0.main AS main_12,
  t0.imagewebp AS imagewebp_13,
  t0.lastmod AS lastmod_14,
  t0.tod_afternoon AS tod_afternoon_15,
  t0.tod_lateafternoon AS tod_lateafternoon_16,
  t0.tod_morning AS tod_morning_17,
  t0.tod_noon AS tod_noon_18,
  t0.tod_sunrise AS tod_sunrise_19,
  t0.tod_sunset AS tod_sunset_20,
  t0.tod_night AS tod_night_21,
  t0.trackid_id AS trackid_id_22,
  t0.license_id AS license_id_23
FROM
  trackconfig t0
WHERE
  t0.trackid_id = ?
  AND t0.urlname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.trackid_id = 69 AND t0.urlname = 'afternoon' 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\Controller\TourHTMLController->trackurl (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.42 ms
(13.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.image AS image_4, t0.iracingid AS iracingid_5, t0.urlname AS urlname_6, t0.active AS active_7, t0.imagewebp AS imagewebp_8 FROM track t0 WHERE t0.urlname = ? LIMIT 1

Parameters:

[
  "new-smyrna-speedway"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.location AS location_3,
  t0.image AS image_4,
  t0.iracingid AS iracingid_5,
  t0.urlname AS urlname_6,
  t0.active AS active_7,
  t0.imagewebp AS imagewebp_8
FROM
  track t0
WHERE
  t0.urlname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.image AS image_4, t0.iracingid AS iracingid_5, t0.urlname AS urlname_6, t0.active AS active_7, t0.imagewebp AS imagewebp_8 FROM track t0 WHERE t0.urlname = 'new-smyrna-speedway' 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\Controller\TourHTMLController->trackurl (line 65)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.41 ms
(13.05%)

SELECT t0.id AS id_1, t0.cdn_url AS cdn_url_2, t0.hero_image_folder AS hero_image_folder_3, t0.api_url AS api_url_4, t0.is_bot_user_agents AS is_bot_user_agents_5 FROM settings t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cdn_url AS cdn_url_2,
  t0.hero_image_folder AS hero_image_folder_3,
  t0.api_url AS api_url_4,
  t0.is_bot_user_agents AS is_bot_user_agents_5
FROM
  settings t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cdn_url AS cdn_url_2, t0.hero_image_folder AS hero_image_folder_3, t0.api_url AS api_url_4, t0.is_bot_user_agents AS is_bot_user_agents_5 FROM settings t0 WHERE t0.id = 1 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\Service\GetSettings->getSettings (line 16)
5	App\Service\GetSettings->getBotUserAgents (line 41)
6	App\Service\IsBotCheck->isBot (line 13)
7	App\Controller\TourHTMLController->trackurl (line 153)
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 29)
13	require_once (line 5)

0.25 ms
(8.15%)

SELECT t0.id AS id_1, t0.infotext AS infotext_2, t0.scenesxml AS scenesxml_3, t0.name AS name_4, t0.clicks AS clicks_5, t0.premium_xml AS premium_xml_6, t0.trackconfig_id AS trackconfig_id_7 FROM trackwalk t0 WHERE t0.trackconfig_id = ? LIMIT 1

Parameters:

[
  180
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.infotext AS infotext_2,
  t0.scenesxml AS scenesxml_3,
  t0.name AS name_4,
  t0.clicks AS clicks_5,
  t0.premium_xml AS premium_xml_6,
  t0.trackconfig_id AS trackconfig_id_7
FROM
  trackwalk t0
WHERE
  t0.trackconfig_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.infotext AS infotext_2, t0.scenesxml AS scenesxml_3, t0.name AS name_4, t0.clicks AS clicks_5, t0.premium_xml AS premium_xml_6, t0.trackconfig_id AS trackconfig_id_7 FROM trackwalk t0 WHERE t0.trackconfig_id = 180 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\Controller\TourHTMLController->trackurl (line 125)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.25 ms
(8.05%)

INSERT INTO analytics (referer, request_uri, user_agent, time, bot) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  ""
  "/new-smyrna-speedway/afternoon"
  "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "2026-02-16 19:31:22"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO analytics (
  referer, request_uri, user_agent,
  time, bot
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO analytics (referer, request_uri, user_agent, time, bot) VALUES ('', '/new-smyrna-speedway/afternoon', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-02-16 19:31:22', 1);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\TourHTMLController->trackurl (line 175)
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 29)
12	require_once (line 5)

0.21 ms
(6.73%)

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.trackid_id = ? AND t0.main = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.configname AS configname_2,
  t0.iracingid AS iracingid_3,
  t0.length_km AS length_km_4,
  t0.length_miles AS length_miles_5,
  t0.corners AS corners_6,
  t0.image AS image_7,
  t0.urlname AS urlname_8,
  t0.active AS active_9,
  t0.premium_full AS premium_full_10,
  t0.premium_oval AS premium_oval_11,
  t0.main AS main_12,
  t0.imagewebp AS imagewebp_13,
  t0.lastmod AS lastmod_14,
  t0.tod_afternoon AS tod_afternoon_15,
  t0.tod_lateafternoon AS tod_lateafternoon_16,
  t0.tod_morning AS tod_morning_17,
  t0.tod_noon AS tod_noon_18,
  t0.tod_sunrise AS tod_sunrise_19,
  t0.tod_sunset AS tod_sunset_20,
  t0.tod_night AS tod_night_21,
  t0.trackid_id AS trackid_id_22,
  t0.license_id AS license_id_23
FROM
  trackconfig t0
WHERE
  t0.trackid_id = ?
  AND t0.main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.trackid_id = 69 AND t0.main = 1 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\Controller\TourHTMLController->trackurl (line 130)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.15 ms
(4.81%)

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.id = ?

Parameters:

[
  180
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.configname AS configname_2,
  t0.iracingid AS iracingid_3,
  t0.length_km AS length_km_4,
  t0.length_miles AS length_miles_5,
  t0.corners AS corners_6,
  t0.image AS image_7,
  t0.urlname AS urlname_8,
  t0.active AS active_9,
  t0.premium_full AS premium_full_10,
  t0.premium_oval AS premium_oval_11,
  t0.main AS main_12,
  t0.imagewebp AS imagewebp_13,
  t0.lastmod AS lastmod_14,
  t0.tod_afternoon AS tod_afternoon_15,
  t0.tod_lateafternoon AS tod_lateafternoon_16,
  t0.tod_morning AS tod_morning_17,
  t0.tod_noon AS tod_noon_18,
  t0.tod_sunrise AS tod_sunrise_19,
  t0.tod_sunset AS tod_sunset_20,
  t0.tod_night AS tod_night_21,
  t0.trackid_id AS trackid_id_22,
  t0.license_id AS license_id_23
FROM
  trackconfig t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.configname AS configname_2, t0.iracingid AS iracingid_3, t0.length_km AS length_km_4, t0.length_miles AS length_miles_5, t0.corners AS corners_6, t0.image AS image_7, t0.urlname AS urlname_8, t0.active AS active_9, t0.premium_full AS premium_full_10, t0.premium_oval AS premium_oval_11, t0.main AS main_12, t0.imagewebp AS imagewebp_13, t0.lastmod AS lastmod_14, t0.tod_afternoon AS tod_afternoon_15, t0.tod_lateafternoon AS tod_lateafternoon_16, t0.tod_morning AS tod_morning_17, t0.tod_noon AS tod_noon_18, t0.tod_sunrise AS tod_sunrise_19, t0.tod_sunset AS tod_sunset_20, t0.tod_night AS tod_night_21, t0.trackid_id AS trackid_id_22, t0.license_id AS license_id_23 FROM trackconfig t0 WHERE t0.id = 180;

#	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\TrackconfigRepository->findConfigById (line 85)
5	App\Repository\TrackconfigRepository->getTimeOfDayAvailable (line 171)
6	App\Controller\TourHTMLController->trackurl (line 137)
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 29)
12	require_once (line 5)

0.06 ms
(1.86%)

"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\TourHTMLController->trackurl (line 175)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Track	1
App\Entity\Trackconfig	1
App\Entity\License	1
App\Entity\Trackwalk	1
App\Entity\Settings	1
App\Entity\Analytics	1

Entities Mapping

Class	Mapping errors
App\Entity\Track	No errors.
App\Entity\Trackconfig	No errors.
App\Entity\License	No errors.
App\Entity\Trackwalk	No errors.
App\Entity\Settings	No errors.
App\Entity\Analytics	No errors.

Symfony Profiler

GET https://2026s1.irtrackwalk.com/new-smyrna-speedway/afternoon

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping