4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Sheffield United

Yasser Larouci

Jugador del Sheffield United
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Yasser Larouci
Nacionalidad
Argelia
Nombre
Yasser Larouci
Edad
22 Años
Altura
176
Dorsal
27
Peso
70 kilogramos
Equipo
Sheffield United
Posición
Defensa
Liga
Premier League
Compañeros de equipo
Fotos
3
  • Foto principal de Yasser Larouci | Troyes
  • Foto principal de Yasser Larouci | Liverpool Sub19
  • Foto principal de Yasser Larouci | Le Havre
0 Comentarios

No hay comentarios


  USO DE MEMORIA  
4,939,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Player / Index )  7.6945
Total Execution Time  7.6962
  CADENA URL  
/jugador/Yasser-Larouci-364643
  GET DATOS  
$_GET['/jugador/Yasser-Larouci-364643']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0020   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '364643'
0.1508  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'Yasser-Larouci-364643' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0150  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72788
0.0017  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '364643'
1.1061  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 71849 AND rp.teamId = 9182 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.3887  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 364643 ORDER BY rp.year DESC
0.0638  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '364643' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '364643' and rp.type = 3
0.0021  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 71849 ORDER BY e.date ASC
1.4207  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71849 AND rel.player_id=364643
0.0024  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 71849 AND action = 18
0.0024  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 71849 AND action = 19
0.0019  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 71432 ORDER BY e.date ASC
0.8445  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71432 AND rel.player_id=364643
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 71432 AND action = 18
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 71432 AND action = 19
0.0019  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 72258 ORDER BY e.date ASC
0.7264  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72258 AND rel.player_id=364643
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72258 AND action = 18
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72258 AND action = 19
0.0020  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 72728 ORDER BY e.date ASC
1.0428  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72728 AND rel.player_id=364643
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72728 AND action = 18
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72728 AND action = 19
0.0020  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 72788 ORDER BY e.date ASC
0.8088  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72788 AND rel.player_id=364643
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72788 AND action = 18
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 72788 AND action = 19
0.0019  SELECT e.* FROM `events2024` e WHERE e.player_id = 364643 AND league_id = 70632 ORDER BY e.date ASC
1.0488  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 70632 AND rel.player_id=364643
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 70632 AND action = 18
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 364643 AND league_id = 70632 AND action = 19