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

Amine Lachkar

Jugador del Willem II
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Amine Lachkar
Nacionalidad
Países Bajos
Nombre
Amine Lachkar
Edad
21 Años (18-04-2003)
Altura
188
Dorsal
34
Equipo
Willem II
Posición
Defensa
Liga
Eerste Divisie
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
4,639,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.0735
Total Execution Time  0.0749
  CADENA URL  
/jugador/A-Lachkar-3181554
  GET DATOS  
$_GET['/jugador/A-Lachkar-3181554']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0003   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` = '3181554'
0.0061  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 = 'A-Lachkar-3181554' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = '3181554'
0.0020  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 = 3181554 ORDER BY rp.year DESC
0.0019  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 = '3181554' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT e.* FROM `events2024` e WHERE e.player_id = 3181554 AND league_id = 72062 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72062 AND rel.player_id=3181554
0.0023  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72062 AND action = 18
0.0025  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72062 AND action = 19
0.0018  SELECT e.* FROM `events2024` e WHERE e.player_id = 3181554 AND league_id = 72954 ORDER BY e.date ASC
0.0026  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72954 AND rel.player_id=3181554
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72954 AND action = 18
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72954 AND action = 19
0.0018  SELECT e.* FROM `events2024` e WHERE e.player_id = 3181554 AND league_id = 71432 ORDER BY e.date ASC
0.0022  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=3181554
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 71432 AND action = 18
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 71432 AND action = 19
0.0018  SELECT e.* FROM `events2024` e WHERE e.player_id = 3181554 AND league_id = 72637 ORDER BY e.date ASC
0.0023  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72637 AND rel.player_id=3181554
0.0019  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72637 AND action = 18
0.0018  SELECT action,minute FROM events2024 WHERE player_id = 3181554 AND league_id = 72637 AND action = 19