¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Mineros de Fresnillo - Tritones Vallarta
Jornada 3
FINALIZADO
00
00
277 Pts. Elo
4º

379 Pts. Elo
5º

2-0
Sábado, 25 Enero 2025, 19:00
Emiliano Trejo 49'
1 - 0
Angel Macías 97'
2 - 0

Eventos del partido

Goles

Emiliano TrejoGol de
Emiliano Trejo
minuto 49'
Angel MacíasGol de
Angel Macías
minuto 97'



  USO DE MEMORIA  
5,989,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3007
Total Execution Time  0.3017
  CADENA URL  
/partido/Mineros-De-Fresnillo/Tritones-Vallarta/2025?section=legal
  GET DATOS  
$_GET['/partido/Mineros-De-Fresnillo/Tritones-Vallarta/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0105  SELECT data1 FROM stats2025 t WHERE league_id = 77639 AND teamId = 6667468 and type = 33
0.0105  SELECT data1 FROM stats2025 t WHERE league_id = 77639 AND teamId = 6667465 and type = 33
0.0107  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 77639 AND id_match = 187038
0.0113  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '187038' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 187038 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 187038 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='187038' AND `active` = 1 AND year = 2025
0.0110  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='77639' AND relp.team_id=6667468 WHERE relp.in_squad=1 and mp.`match_id` = '187038' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0117  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='77639' AND relp.team_id=6667465 WHERE relp.in_squad=1 and mp.`match_id` = '187038' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '77639' AND id_match = '187038'
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=187038 AND extraId = 77639 AND type_rel = 4
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 187038 AND league_id = 77639 AND year = 2025