4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Salisbury City - Hampton & Richmond
Jornada 59
FINALIZADO
00
00
120 Pts. Elo

216 Pts. Elo

0-2
Sábado, 29 Julio 2023, 16:00
0 - 1
 52' S. Deadfield
0 - 2
 61' J. Gray

Eventos del partido

Goles

minuto 52'S. DeadfieldGol de S. Deadfield
minuto 61'J. GrayGol de J. Gray



  USO DE MEMORIA  
5,705,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1604
Total Execution Time  0.1614
  CADENA URL  
/partido/Salisbury-City/Hampton-Richmond
  GET DATOS  
$_GET['/partido/Salisbury-City/Hampton-Richmond']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6586051 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6580072 and type = 33
0.0019  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 71432 AND id_match = 185270
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '185270' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 185270 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 185270 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='185270' AND `active` = 1 AND year = 2024
0.0020  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='71432' AND relp.team_id=6586051 WHERE relp.in_squad=1 and mp.`match_id` = '185270' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  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='71432' AND relp.team_id=6580072 WHERE relp.in_squad=1 and mp.`match_id` = '185270' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '71432' AND id_match = '185270'
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=185270 AND extraId = 71432 AND type_rel = 4
0.0017  SELECT position FROM tables2024 WHERE team=6586051 AND league_id=71432 AND round=59
0.0019  SELECT position FROM tables2024 WHERE team=6580072 AND league_id=71432 AND round=59
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 185270 AND league_id = 71432 AND year = 2024