Symfony Profiler

Query Metrics

1424 Database Queries

8 Different statements

6377.47 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3467.65 ms
(54.37%)

625

SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = ?)

Parameters:

[
  474
  null
  138
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.posicion AS posicion_1,
  p0_.cancion_id_id AS cancion_id_id_2,
  p0_.recopilatorio_id AS recopilatorio_id_3,
  p0_.cantante_id AS cantante_id_4,
  p0_.cantante1_id AS cantante1_id_5,
  p0_.semana_id AS semana_id_6
FROM
  posiciones p0_
  INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id
WHERE
  (
    p0_.cancion_id_id = ?
    OR p0_.recopilatorio_id = ?
  )
  AND s1_.numero < (
    SELECT
      s2_.numero
    FROM
      semanas s2_
    WHERE
      s2_.id = ?
  )

SELECT p0_.id AS id_0, p0_.posicion AS posicion_1, p0_.cancion_id_id AS cancion_id_id_2, p0_.recopilatorio_id AS recopilatorio_id_3, p0_.cantante_id AS cantante_id_4, p0_.cantante1_id AS cantante1_id_5, p0_.semana_id AS semana_id_6 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = 474 OR p0_.recopilatorio_id = NULL) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = 138);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 41)
7	App\Service\CancionesPosicionUnoService->getCancionesPosicionUno (line 232)
8	App\Controller\SemanasController->semana (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2557.05 ms
(40.10%)

650

SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = ? OR p0_.recopilatorio_id = ?) AND s1_.numero <= ?

Parameters:

[
  474
  null
  138
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  posiciones p0_
  INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id
WHERE
  (
    p0_.cancion_id_id = ?
    OR p0_.recopilatorio_id = ?
  )
  AND s1_.numero <= ?

SELECT COUNT(p0_.id) AS sclr_0 FROM posiciones p0_ INNER JOIN semanas s1_ ON p0_.semana_id = s1_.id WHERE (p0_.cancion_id_id = 474 OR p0_.recopilatorio_id = NULL) AND s1_.numero <= 138;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 30)
8	App\Service\NumeroSemanasService->contarSemanasPorCancion (line 192)
9	App\Controller\SemanasController->semana (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

166.47 ms
(2.61%)

SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ?

Parameters:

[
  138
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.posicion AS posicion_2,
  t0.cancion_id_id AS cancion_id_id_3,
  t0.recopilatorio_id AS recopilatorio_id_4,
  t0.cantante_id AS cantante_id_5,
  t0.cantante1_id AS cantante1_id_6,
  t0.semana_id AS semana_id_7
FROM
  posiciones t0
WHERE
  t0.semana_id = ?

SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = 138;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 85)
8	App\Controller\SemanasController->semana (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

73.71 ms
(1.16%)

SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = ? AND t0.cantante_id = ? AND t0.cancion_id_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.posicion AS posicion_2,
  t0.cancion_id_id AS cancion_id_id_3,
  t0.recopilatorio_id AS recopilatorio_id_4,
  t0.cantante_id AS cantante_id_5,
  t0.cantante1_id AS cantante1_id_6,
  t0.semana_id AS semana_id_7
FROM
  posiciones t0
WHERE
  t0.semana_id = ?
  AND t0.cantante_id = ?
  AND t0.cancion_id_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.posicion AS posicion_2, t0.cancion_id_id AS cancion_id_id_3, t0.recopilatorio_id AS recopilatorio_id_4, t0.cantante_id AS cantante_id_5, t0.cantante1_id AS cantante1_id_6, t0.semana_id AS semana_id_7 FROM posiciones t0 WHERE t0.semana_id = 137 AND t0.cantante_id = 120 AND t0.cancion_id_id = 474 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 76)
5	App\Service\PosicionAnteriorService->getPoiscionAnterior (line 184)
6	App\Controller\SemanasController->semana (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

45.14 ms
(0.71%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.discogs AS discogs_4 FROM cantantes t0 WHERE t0.id = ?

Parameters:

[
  120
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellidos AS apellidos_3,
  t0.discogs AS discogs_4
FROM
  cantantes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.discogs AS discogs_4 FROM cantantes t0 WHERE t0.id = 120;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Cantantes::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Cantantes->__get (line 54)
8	App\Entity\Cantantes->getNombre (line 103)
9	App\Controller\SemanasController->semana (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

39.97 ms
(0.63%)

SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < ? ORDER BY s0_.numero DESC LIMIT 1

Parameters:

[
  138
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.numero AS numero_1,
  s0_.fecha AS fecha_2
FROM
  semanas s0_
WHERE
  s0_.numero < ?
ORDER BY
  s0_.numero DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < 138 ORDER BY s0_.numero DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 48)
7	App\Service\PosicionAnteriorService->getPoiscionAnterior (line 184)
8	App\Controller\SemanasController->semana (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

26.52 ms
(0.42%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM canciones t0 WHERE t0.id = ?

Parameters:

[
  474
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.discogs AS discogs_3,
  t0.youtube AS youtube_4
FROM
  canciones t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM canciones t0 WHERE t0.id = 474;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Canciones::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Canciones->__get (line 50)
8	App\Entity\Canciones->getNombre (line 121)
9	App\Controller\SemanasController->semana (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.97 ms
(0.02%)

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3 FROM semanas t0 WHERE t0.id = ?

Parameters:

[
  "138"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.fecha AS fecha_3
FROM
  semanas t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3 FROM semanas t0 WHERE t0.id = '138';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 73)
7	App\Controller\SemanasController->semana (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Semanas	No errors.
App\Entity\Posiciones	The mappings App\Entity\Posiciones#cancion_id and App\Entity\Canciones#posiciones are inconsistent with each other. The mappings App\Entity\Posiciones#cantante1_id and App\Entity\Cantantes#posiciones are inconsistent with each other.
App\Entity\Canciones	The association App\Entity\Canciones#posiciones refers to the owning side field App\Entity\Posiciones#cancion_id_id which does not exist.
App\Entity\Recopilatorios	No errors.
App\Entity\Cantantes	The mappings App\Entity\Cantantes#posiciones1 and App\Entity\Posiciones#cantante1_id are inconsistent with each other.

Symfony Profiler

GET http://music.bichomen.com/semana/138

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping