Symfony Profiler

Query Metrics

11 Database Queries

7 Different statements

2.11 ms Query time

0 Invalid entities

153 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.49 ms
(23.25%)

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->getHeroImageFolder (line 31)
6	App\Service\RandomImage->getRandomImage (line 25)
7	App\Controller\HomeController->index (line 59)
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.47 ms
(22.48%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.iracingid AS iracingid_2, CASE WHEN t0_.name NOT LIKE '%\\[Legacy]%' THEN 0 ELSE 1 END AS sclr_3 FROM track t0_ WHERE t0_.active = 1 ORDER BY sclr_3 ASC, t0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.iracingid AS iracingid_2,
  CASE WHEN t0_.name NOT LIKE '%\\[Legacy]%' THEN
    0
  ELSE
    1
  END AS sclr_3
FROM
  track t0_
WHERE
  t0_.active = 1
ORDER BY
  sclr_3 ASC,
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.iracingid AS iracingid_2, CASE WHEN t0_.name NOT LIKE '%\\[Legacy]%' THEN 0 ELSE 1 END AS sclr_3 FROM track t0_ WHERE t0_.active = 1 ORDER BY sclr_3 ASC, t0_.name 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\TrackRepository->getAllTrackIdsByOrderName (line 102)
7	App\Controller\HomeController->index (line 56)
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.36 ms
(16.98%)

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

Parameters:

[]

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

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;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->index (line 41)
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 29)
11	require_once (line 5)

0.29 ms
(13.91%)

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 = 53 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\HomeController->index (line 46)
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.17 ms
(8.00%)

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.iracingid = ? LIMIT 1

Parameters:

[
  303
]

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.iracingid = ?
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.iracingid = 303 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\Repository\TrackRepository->getTrackInfosByIracingId (line 183)
5	App\Controller\HomeController->index (line 52)
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 29)
11	require_once (line 5)

0.17 ms
(7.99%)

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.iracingid = ? LIMIT 1

Parameters:

[
  351
]

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.iracingid = ?
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.iracingid = 351 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\Repository\TrackconfigRepository->getOneTrackconfigInfosByIracingId (line 222)
5	App\Controller\HomeController->index (line 53)
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 29)
11	require_once (line 5)

0.16 ms
(7.39%)

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.active = ?

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.active = ?

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 = 53 AND t0.active = 1;

#	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->getAllTrackconfigsByTrackId (line 260)
5	App\Controller\HomeController->index (line 54)
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 29)
11	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	150
App\Entity\Trackconfig	1
App\Entity\License	1
App\Entity\Settings	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.

Symfony Profiler

GET https://2026s1.irtrackwalk.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping