4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Poole Town - Gosport Borough
Jornada 8
FINALIZADO
00
00
224 Pts. Elo
7º

164 Pts. Elo
3º

2-0
Martes, 12 Septiembre 2023, 20:45
T. Holmes 50'
1 - 0
T. Lee 60'
2 - 0

Eventos del partido

Goles

T. HolmesGol de
T. Holmes
minuto 50'
T. LeeGol de
T. Lee
minuto 60'



  USO DE MEMORIA  
5,929,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3981
Total Execution Time  0.3991
  CADENA URL  
/partido/Poole-Town/Gosport-Borough/2012?section=legal
  GET DATOS  
$_GET['/partido/Poole-Town/Gosport-Borough/2012']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 72853 AND teamId = 6594094 and type = 33
0.0126  SELECT data1 FROM stats2024 t WHERE league_id = 72853 AND teamId = 6594086 and type = 33
0.0127  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72853 AND id_match = 181551
0.0130  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '181551' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 181551 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0132  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 181551 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='181551' AND `active` = 1 AND year = 2024
0.0178  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='72853' AND relp.team_id=6594094 WHERE relp.in_squad=1 and mp.`match_id` = '181551' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0144  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='72853' AND relp.team_id=6594086 WHERE relp.in_squad=1 and mp.`match_id` = '181551' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0126  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '72853' AND id_match = '181551'
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=181551 AND extraId = 72853 AND type_rel = 4
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=562 AND type_rel = 3
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 562 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1290901,1227363,1202560,1153265,1096842) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT rating1, rating2 FROM calendars_elo WHERE id=181551 AND league_id=72853 AND year=2024
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 181551 AND league_id = 72853 AND year = 2024