4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lokomotiv Moskva

Lokomotiv Moskva

Entrenador: Mikhail Galaktionov

Temporada 2014/2015

Estadísticas

ASISTENCIAS
A. Samedov4
M. Boussoufa4
V. Denisov2
A. Kasaev1
R. Pavlyuchenko1
N. Pejcinovic1
M. Grigoryev1
Maicon Bolt1
M. Fernandes1
Oumar Niasse1
R. Yanbaev1
ENTRA
R. Pavlyuchenko15
Maicon Bolt11
A. Kasaev8
M. Fernandes8
A. Miranchuk7
M. Grigoryev6
Oumar Niasse5
D. N'doye5
N. Pejcinovic4
T. Mikhalik4
P. Skuletic4
S. Tkachev4
R. Shishkin3
A. Sheshukov3
M. Ozdoev2
D. Barinov2
M. Boussoufa2
Y. Tigorev2
R. Yanbaev1
D. Tarasov1
SALE
Maicon Bolt11
M. Fernandes10
A. Kasaev8
P. Skuletic7
M. Boussoufa7
M. Grigoryev6
D. N'doye6
R. Pavlyuchenko5
A. Samedov5
T. Mikhalik4
D. Tarasov4
Oumar Niasse4
A. Miranchuk4
A. Sheshukov4
S. Tkachev4
M. Ozdoev3
A. Miranchuk2
R. Yanbaev2
V. Denisov2
J. Ďurica1
Arseniy Logashov1
R. Shishkin1

  USO DE MEMORIA  
5,424,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0523
Total Execution Time  0.0542
  CADENA URL  
/estadisticas/Lokomotiv-Moskva/2015
  GET DATOS  
$_GET['/estadisticas/Lokomotiv-Moskva/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0040  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1581' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0043  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 3819 WHERE rp.league_id = 3819 AND rp.teamId = 1581 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0050  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 3819 WHERE rp.league_id = 3819 AND rp.teamId = 1581 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 3819 WHERE rp.league_id = 3819 AND rp.teamId = 1581 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30