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

Query Metrics

1424 Database Queries
11 Different statements
5411.49 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2794.44 ms
(51.64%)
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:
[
  540
  null
  91
]
2287.84 ms
(42.28%)
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:
[
  540
  null
  91
]
176.95 ms
(3.27%)
51
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:
[
  91
]
55.72 ms
(1.03%)
23
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:
[
  198
]
41.69 ms
(0.77%)
22
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:
[
  90
  198
  540
]
24.20 ms
(0.45%)
25
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:
[
  91
]
18.13 ms
(0.33%)
22
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:
[
  540
]
7.80 ms
(0.14%)
2
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.discogs AS discogs_3, t0.youtube AS youtube_4 FROM recopilatorios t0 WHERE t0.id = ?
Parameters:
[
  13
]
2.56 ms
(0.05%)
2
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.recopilatorio_id = ? LIMIT 1
Parameters:
[
  90
  13
]
1.27 ms
(0.02%)
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 = ? AND t0.cantante_id = ? AND t0.cantante1_id = ? AND t0.cancion_id_id = ? LIMIT 1
Parameters:
[
  90
  1
  199
  281
]
0.89 ms
(0.02%)
1
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3 FROM semanas t0 WHERE t0.id = ?
Parameters:
[
  "91"
]

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.