4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sevilla At. - UCAM Murcia
Jornada 33
HOY
495 Pts. Elo
1º

356 Pts. Elo
9º

12:00
Domingo, 28 Abril 2024

Sevilla At.

4-5-1
Alineación Inicial
Suplentes

UCAM Murcia

4-5-1
Alineación Inicial
Suplentes
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
Facebook Live SevillaFC TV Castellano
SFC TV TV Castellano
SevillaFC YouTube TV Castellano

  USO DE MEMORIA  
6,514,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2938
Total Execution Time  0.2948
  CADENA URL  
/partido/Sevilla-B/Ucam-Murcia-C-F/2024
  GET DATOS  
$_GET['/partido/Sevilla-B/Ucam-Murcia-C-F/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587688 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72365 AND teamId = 6587690 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '197748' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197748 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197748 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197748' AND `active` = 1 AND year = 2024
0.0063  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72365' AND relp.team_id=6587688 WHERE relp.in_squad=1 and mp.`match_id` = '197748' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0084  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72365' AND relp.team_id=6587690 WHERE relp.in_squad=1 and mp.`match_id` = '197748' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT dt.id, dt.nick, dt.alias, dt.name, dt.last_name, t.teamId as team_id, 0 as tvotes, 0 as tpoints, 0 as rating FROM dreamteam_data_real as dr INNER JOIN rel_dreamteam_real as rel ON dr.id=rel.team_number INNER JOIN teams as t ON t.id = dr.team_id INNER JOIN dataplayers as dt ON dt.id=rel.player_id WHERE dr.team_id=6587688 GROUP BY rel.player_id HAVING SUM(rel.votes) > 1 ORDER BY tpoints DESC, votes DESC LIMIT 1
0.0018  SELECT dt.id, dt.nick, dt.alias, dt.name, dt.last_name, t.teamId as team_id, 0 as tvotes, 0 as tpoints, 0 as rating FROM dreamteam_data_real as dr INNER JOIN rel_dreamteam_real as rel ON dr.id=rel.team_number INNER JOIN teams as t ON t.id = dr.team_id INNER JOIN dataplayers as dt ON dt.id=rel.player_id WHERE dr.team_id=6587690 GROUP BY rel.player_id HAVING SUM(rel.votes) > 1 ORDER BY tpoints DESC, votes DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197748 AND extraId = 72365 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 197748 AND league_id = 72365 AND year = 2024