1821.17 ms (50.03%)
|
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: [
321
null
93
]
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 = 321 OR p0_.recopilatorio_id = NULL) AND s1_.numero < (SELECT s2_.numero FROM semanas s2_ WHERE s2_.id = 93);
|
1585.48 ms (43.55%)
|
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: [
321
null
93
]
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 = 321 OR p0_.recopilatorio_id = NULL) AND s1_.numero <= 93;
|
137.46 ms (3.78%)
|
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 = ?
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 = 93;
|
36.84 ms (1.01%)
|
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: [
92
213
321
]
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 = 92 AND t0.cantante_id = 213 AND t0.cancion_id_id = 321 LIMIT 1;
|
26.10 ms (0.72%)
|
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
SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.fecha AS fecha_2 FROM semanas s0_ WHERE s0_.numero < 93 ORDER BY s0_.numero DESC LIMIT 1;
|
14.75 ms (0.41%)
|
24 |
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 = 213;
|
11.50 ms (0.32%)
|
23 |
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 = 321;
|
3.13 ms (0.09%)
|
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
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 = 92 AND t0.recopilatorio_id = 13 LIMIT 1;
|
1.91 ms (0.05%)
|
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: [
92
1
199
281
]
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 = 92 AND t0.cantante_id = 1 AND t0.cantante1_id = 199 AND t0.cancion_id_id = 281 LIMIT 1;
|
1.27 ms (0.03%)
|
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 = ?
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 = 13;
|
0.71 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 = ?
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3 FROM semanas t0 WHERE t0.id = '93';
|