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

A. Yusupov

Jugador del Alay Osh
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de A. Yusupov
Nacionalidad
Uzbekistán
Nombre
Abdul Aziz Yusupov
Edad
31 Años (05-01-1993)
Altura
174
Dorsal
20
Equipo
Alay Osh
Posición
Centrocampista
Liga
Liga Kirguistán 2023
Compañeros de equipo

No hay comentarios


  USO DE MEMORIA  
7,284,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Player / Index )  0.3146
Total Execution Time  0.3169
  CADENA URL  
/jugador/a-yusupov-178181
  GET DATOS  
$_GET['/jugador/a-yusupov-178181']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (114)  
0.0005   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` = '178181'
0.0026  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-yusupov-178181' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0092  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 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-yusupov-178181' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0033  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 = 71397
0.0026  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 = 66832
0.0024  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 = 61113
0.0027  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 = 62180
0.0025  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 = 63178
0.0025  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 = 55381
0.0025  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 = 53469
0.0024  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 = 42702
0.0025  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 = 48127
0.0025  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 = 43015
0.0025  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 = 20226
0.0023  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 = 19897
0.0024  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 = 3765
0.0025  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 = 2321
0.0027  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 = 2289
0.0028  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 = 2408
0.0025  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 = 2465
0.0057  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 = 41117
0.0024  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 = 48984
0.0018  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 = '178181'
0.0026  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 = 71397 AND rp.teamId = 63373 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0021  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 = 178181 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 = '178181' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  SELECT e.* FROM `events2023` e WHERE e.player_id = 178181 AND league_id = 71397 ORDER BY e.date ASC
0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71397 AND rel.player_id=178181
0.0021  SELECT action,minute FROM events2023 WHERE player_id = 178181 AND league_id = 71397 AND action = 18
0.0020  SELECT action,minute FROM events2023 WHERE player_id = 178181 AND league_id = 71397 AND action = 19
0.0020  SELECT e.* FROM `events2022` e WHERE e.player_id = 178181 AND league_id = 66832 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 = 66832 AND rel.player_id=178181
0.0029  SELECT action,minute FROM events2022 WHERE player_id = 178181 AND league_id = 66832 AND action = 18
0.0022  SELECT action,minute FROM events2022 WHERE player_id = 178181 AND league_id = 66832 AND action = 19
0.0031  SELECT e.* FROM `events2021` e WHERE e.player_id = 178181 AND league_id = 61113 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 = 61113 AND rel.player_id=178181
0.0020  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 61113 AND action = 18
0.0021  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 61113 AND action = 19
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 178181 AND league_id = 62180 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62180 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 62180 AND action = 18
0.0020  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 62180 AND action = 19
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 178181 AND league_id = 63178 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 = 63178 AND rel.player_id=178181
0.0019  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 63178 AND action = 18
0.0019  SELECT action,minute FROM events2021 WHERE player_id = 178181 AND league_id = 63178 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 178181 AND league_id = 55381 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55381 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 55381 AND action = 18
0.0020  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 55381 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 178181 AND league_id = 49506 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 49506 AND action = 18
0.0020  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 49506 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 178181 AND league_id = 53469 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 = 53469 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 53469 AND action = 18
0.0018  SELECT action,minute FROM events2020 WHERE player_id = 178181 AND league_id = 53469 AND action = 19
0.0021  SELECT e.* FROM `events2019` e WHERE e.player_id = 178181 AND league_id = 49175 ORDER BY e.date ASC
0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49175 AND rel.player_id=178181
0.0023  SELECT action,minute FROM events2019 WHERE player_id = 178181 AND league_id = 49175 AND action = 18
0.0021  SELECT action,minute FROM events2019 WHERE player_id = 178181 AND league_id = 49175 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 178181 AND league_id = 49565 ORDER BY e.date ASC
0.0031  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49565 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 178181 AND league_id = 49565 AND action = 18
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 178181 AND league_id = 49565 AND action = 19
0.0020  SELECT e.* FROM `events2018` e WHERE e.player_id = 178181 AND league_id = 42702 ORDER BY e.date ASC
0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42702 AND rel.player_id=178181
0.0020  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 42702 AND action = 18
0.0019  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 42702 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 178181 AND league_id = 48127 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48127 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 48127 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 48127 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 178181 AND league_id = 43015 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 = 43015 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 43015 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 178181 AND league_id = 43015 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 178181 AND league_id = 20226 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20226 AND rel.player_id=178181
0.0019  SELECT action,minute FROM events2016 WHERE player_id = 178181 AND league_id = 20226 AND action = 18
0.0018  SELECT action,minute FROM events2016 WHERE player_id = 178181 AND league_id = 20226 AND action = 19
0.0021  SELECT e.* FROM `events2015` e WHERE e.player_id = 178181 AND league_id = 19897 ORDER BY e.date ASC
0.0020  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19897 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 178181 AND league_id = 19897 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 178181 AND league_id = 19897 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 178181 AND league_id = 3765 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3765 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 178181 AND league_id = 3765 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 178181 AND league_id = 3765 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 178181 AND league_id = 2321 ORDER BY e.date ASC
0.0027  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2321 AND rel.player_id=178181
0.0022  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2321 AND action = 18
0.0025  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2321 AND action = 19
0.0022  SELECT e.* FROM `events2013` e WHERE e.player_id = 178181 AND league_id = 2289 ORDER BY e.date ASC
0.0025  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2289 AND rel.player_id=178181
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2289 AND action = 18
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2289 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 178181 AND league_id = 2408 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 = 2408 AND rel.player_id=178181
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2408 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2408 AND action = 19
0.0021  SELECT e.* FROM `events2013` e WHERE e.player_id = 178181 AND league_id = 2465 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 = 2465 AND rel.player_id=178181
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2465 AND action = 18
0.0018  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 2465 AND action = 19
0.0019  SELECT e.* FROM `events2013` e WHERE e.player_id = 178181 AND league_id = 41117 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 = 41117 AND rel.player_id=178181
0.0019  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 41117 AND action = 18
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 178181 AND league_id = 41117 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 178181 AND league_id = 48984 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 = 48984 AND rel.player_id=178181
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 178181 AND league_id = 48984 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 178181 AND league_id = 48984 AND action = 19