4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Anzhi - Amkar Perm
Jornada 3
FINALIZADO
20
10
1627 Pts. Elo
3º

1529 Pts. Elo
9º

1-0
Domingo, 05 Agosto 2012, 17:00
  • Asistencia: 14.000 espectadores
G. Gabulov 72'
1 - 0

Eventos del partido

Goles

G. GabulovGol de
G. Gabulov
minuto 72'

Tarjetas

G. GabulovT. Amarilla
G. Gabulov
minuto 39'
minuto 49'N. BurmistrovT. Amarilla N. Burmistrov
minuto 88'M. JakubkoT. Amarilla M. Jakubko

Cambios

Carcela-GonzálezEntra en el partido
Carcela-González
minuto 46'
A. IvanovSale del partido
A. Ivanov
minuto 46'
minuto 51'M. BlazićEntra en el partido M. Blazić
minuto 51'V. GrishinSale del partido V. Grishin
O. ShatovSale del partido
O. Shatov
minuto 65'
S. LakhiyalovEntra en el partido
S. Lakhiyalov
minuto 65'
minuto 66'I. CherenchikovEntra en el partido I. Cherenchikov
minuto 66'A. PopovSale del partido A. Popov
minuto 74'N. BurmistrovSale del partido N. Burmistrov
minuto 74'I. PicuşceacEntra en el partido I. Picuşceac
S. MukhammadEntra en el partido
S. Mukhammad
minuto 90'
F. SmolovSale del partido
F. Smolov
minuto 90'

Otros

Carcela-GonzálezAsistencia
Carcela-González
minuto 72'

Alineaciones

Anzhi

Anzhi

4-4-2
Alineación Inicial
Suplentes
Amkar Perm

Amkar Perm

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,889,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4121
Total Execution Time  0.4131
  CADENA URL  
/partido/Anzhi-Makhachkala/Amkar-Perm/2013
  GET DATOS  
$_GET['/partido/Anzhi-Makhachkala/Amkar-Perm/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0126  SELECT data1 FROM stats2013 t WHERE league_id = 1916 AND teamId = 39228 and type = 33
0.0126  SELECT data1 FROM stats2013 t WHERE league_id = 1916 AND teamId = 39227 and type = 33
0.0134  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '393161' and rp.type = 2013 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 393161 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 393161 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='393161' AND `active` = 1 AND year = 2013
0.0319  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='1916' AND relp.team_id=39228 WHERE relp.in_squad=1 and mp.`match_id` = '393161' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0291  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='1916' AND relp.team_id=39227 WHERE relp.in_squad=1 and mp.`match_id` = '393161' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=393161 AND extraId = 1916 AND type_rel = 4
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 27 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 (1315109,1314121,1312606,1312346,1311579) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 393161 AND league_id = 1916 AND year = 2013