Symfony Profiler

Query Metrics

211 Database Queries

21 Different statements

1348.74 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1300.61 ms
(96.43%)

105

SELECT s0_.id AS id_0, s1_.date AS date_1 FROM artist a2_ INNER JOIN setlist s1_ ON a2_.id = s1_.artist_id INNER JOIN setlist_song s3_ ON s1_.id = s3_.setlist_id INNER JOIN song s0_ ON s0_.id = s3_.song_id WHERE a2_.id = ? GROUP BY s0_.id, s1_.date

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s1_.date AS date_1
FROM
  artist a2_
  INNER JOIN setlist s1_ ON a2_.id = s1_.artist_id
  INNER JOIN setlist_song s3_ ON s1_.id = s3_.setlist_id
  INNER JOIN song s0_ ON s0_.id = s3_.song_id
WHERE
  a2_.id = ?
GROUP BY
  s0_.id,
  s1_.date

SELECT s0_.id AS id_0, s1_.date AS date_1 FROM artist a2_ INNER JOIN setlist s1_ ON a2_.id = s1_.artist_id INNER JOIN setlist_song s3_ ON s1_.id = s3_.setlist_id INNER JOIN song s0_ ON s0_.id = s3_.song_id WHERE a2_.id = 1 GROUP BY s0_.id, s1_.date;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 60)
7	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
8	App\Controller\HomeController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

36.94 ms
(2.74%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.86 ms
(0.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.removed AS removed_4, t0.mb_id AS mb_id_5 FROM artist 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.added AS added_3,
  t0.removed AS removed_4,
  t0.mb_id AS mb_id_5
FROM
  artist t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.removed AS removed_4, t0.mb_id AS mb_id_5 FROM artist t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 17)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.33 ms
(0.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (2698, 2699, 2700, 2701, 2702, 2703, 2704, 2705, 2706, 2707, 2708, 2709, 2710, 2711, 2712, 2713, 2714, 2715, 2716, 2717, 2718, 2719, 2720);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.91 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.69 ms
(0.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (1678, 1679, 1680, 1681, 1682, 1683, 1684, 1685, 1686, 1687, 1688, 1689, 1690, 1691, 1692, 1693, 1694, 1695, 1696, 1697, 1698, 1699);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.61 ms
(0.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (3194, 3195, 3196, 3197, 3198, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.58 ms
(0.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (NULL)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.56 ms
(0.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.46 ms
(0.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.43 ms
(0.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.38 ms
(0.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (3105, 3106, 3107, 3108, 3109, 3110, 3111, 3112, 3113, 3114, 3115, 3116, 3117, 3118, 3119, 3120, 3121);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.33 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (4382, 4383, 4384, 4385, 4386, 4387, 4388, 4389, 4390, 4391, 4392, 4393, 4394, 4395);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.29 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (5109, 5110, 5111, 5112, 5113, 5114, 5115, 5116, 5117, 5118, 5119, 5120, 5121, 5122, 5123, 5124);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.27 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (4832, 4833, 4834, 4835, 4836, 4837, 4838, 4839, 4840, 4841, 4842, 4843, 4844);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.26 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (2888, 2889, 2890, 2891, 2892, 2893, 2894, 2895, 2896, 2897, 2898, 2899, 2900, 2901, 2902);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.25 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (564, 565, 566, 567, 568);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.25 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.24 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.24 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?)

Parameters:

[
  6025
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (6025);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.23 ms
(0.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_cover AS is_cover_3,
  t0.artist_id AS artist_id_4,
  t0.spotify_track_id AS spotify_track_id_5
FROM
  song t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_cover AS is_cover_3, t0.artist_id AS artist_id_4, t0.spotify_track_id AS spotify_track_id_5 FROM song t0 WHERE t0.id IN (1672, 1673, 1674, 1675, 1676, 1677);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 70)
4	App\Repository\ArtistRepository->getTopWeightedSongs (line 20)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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

Class	Mapping errors
App\Entity\Artist	No errors.
App\Entity\Performance	No errors.
App\Entity\Song	No errors.
App\Entity\Setlist	No errors.
App\Entity\Track	No errors.

Symfony Profiler

GET https://dl24.nne.rs/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping