4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Benidorm - Gimnàstic Tarragona
Jornada 12
FINALIZADO
30
31
765 Pts. Elo
12º

563 Pts. Elo
7º

0-0
Miércoles, 10 Noviembre 1993, 00:00

Eventos del partido

Tarjetas

MeseguerT. Amarilla
Meseguer
minuto
PacoT. Amarilla
Paco
minuto
OrtizT. Amarilla
Ortiz
minuto
minuto HerreraT. Amarilla Herrera
minuto 44'JuliT. Amarilla Juli
minuto 44'Juli2a Amarilla y Roja Juli

Cambios

PacoSale del partido
Paco
minuto 50'
MorenoEntra en el partido
Moreno
minuto 50'
minuto 50'SantiagoEntra en el partido Santiago
minuto 50'TotóSale del partido Totó
JiménezEntra en el partido
Jiménez
minuto 60'
UruSale del partido
Uru
minuto 60'
minuto 75'RubioSale del partido Rubio
minuto 75'OribeEntra en el partido Oribe



  USO DE MEMORIA  
5,623,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2517
Total Execution Time  0.2527
  CADENA URL  
/partido/Benidorm/Gimnastic-Tarragona/1994
  GET DATOS  
$_GET['/partido/Benidorm/Gimnastic-Tarragona/1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0110  SELECT data1 FROM stats1994 t WHERE league_id = 22257 AND teamId = 618495 and type = 33
0.0110  SELECT data1 FROM stats1994 t WHERE league_id = 22257 AND teamId = 618482 and type = 33
0.0112  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 22257 AND id_match = 20585
0.0109  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '20585' and rp.type = 1994 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 20585 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 20585 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='20585' AND `active` = 1 AND year = 1994
0.0115  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='22257' AND relp.team_id=618495 WHERE relp.in_squad=1 and mp.`match_id` = '20585' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
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='22257' AND relp.team_id=618482 WHERE relp.in_squad=1 and mp.`match_id` = '20585' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '22257' AND id_match = '20585'
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20585 AND extraId = 22257 AND type_rel = 4
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 20585 AND league_id = 22257 AND year = 1994