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

J. Novoa

Jugador del Rangers Talca
Ficha de J. Novoa
Nacionalidad
Chile
Nombre
Jonathan Alberto Novoa Tiznado
Edad
42 Años (21-08-1981)
Altura
181
Peso
78 kilogramos
Equipo
Rangers Talca
Posición
Delantero
Liga
Primera B Chile - Apertura Fase 1 2016 G 1
Compañeros de equipo
0 Comentarios

No hay comentarios


  USO DE MEMORIA  
7,340,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Player / Index )  0.3309
Total Execution Time  0.3321
  CADENA URL  
/jugador/j-novoa-225981
  GET DATOS  
$_GET['/jugador/j-novoa-225981']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (112)  
0.0004   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` = '225981'
0.0030  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 = 'j-novoa-225981' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0128  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 = 'j-novoa-225981' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
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 = 4009
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 = 9280
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 = 1878
0.0030  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 = 1880
0.0031  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 = 24561
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 = 24544
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 = 24553
0.0030  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 = 24565
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 = 24573
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 = 24547
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 = 24556
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 = 23433
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 = 23435
0.0019  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 = '225981'
0.0030  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 = 15792 AND rp.teamId = 9270 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0024  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 = 225981 ORDER BY rp.year DESC
0.0025  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 = '225981' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  SELECT e.* FROM `events2016` e WHERE e.player_id = 225981 AND league_id = 15792 ORDER BY e.date ASC
0.0122  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15792 AND rel.player_id=225981
0.0029  SELECT action,minute FROM events2016 WHERE player_id = 225981 AND league_id = 15792 AND action = 18
0.0025  SELECT action,minute FROM events2016 WHERE player_id = 225981 AND league_id = 15792 AND action = 19
0.0024  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 4009 ORDER BY e.date ASC
0.0085  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4009 AND rel.player_id=225981
0.0025  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 4009 AND action = 18
0.0023  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 4009 AND action = 19
0.0027  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 4914 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4914 AND rel.player_id=225981
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 4914 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 4914 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 9012 ORDER BY e.date ASC
0.0035  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9012 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 9012 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 9012 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 9280 ORDER BY e.date ASC
0.0047  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 9280 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 9280 AND action = 18
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 9280 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 3733 ORDER BY e.date ASC
0.0033  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3733 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 3733 AND action = 18
0.0025  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 3733 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 225981 AND league_id = 5210 ORDER BY e.date ASC
0.0034  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 5210 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 5210 AND action = 18
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 225981 AND league_id = 5210 AND action = 19
0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 225981 AND league_id = 3199 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3199 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3199 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3199 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 225981 AND league_id = 3200 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 = 3200 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3200 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3200 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 225981 AND league_id = 3279 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 = 3279 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3279 AND action = 18
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3279 AND action = 19
0.0020  SELECT e.* FROM `events2014` e WHERE e.player_id = 225981 AND league_id = 3680 ORDER BY e.date ASC
0.0024  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3680 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3680 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3680 AND action = 19
0.0019  SELECT e.* FROM `events2014` e WHERE e.player_id = 225981 AND league_id = 3399 ORDER BY e.date ASC
0.0036  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3399 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3399 AND action = 18
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 225981 AND league_id = 3399 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 225981 AND league_id = 1878 ORDER BY e.date ASC
0.0037  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1878 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 1878 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 1878 AND action = 19
0.0019  SELECT e.* FROM `events2012` e WHERE e.player_id = 225981 AND league_id = 1880 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 = 1880 AND rel.player_id=225981
0.0024  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 1880 AND action = 18
0.0019  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 1880 AND action = 19
0.0020  SELECT e.* FROM `events2012` e WHERE e.player_id = 225981 AND league_id = 24561 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 = 24561 AND rel.player_id=225981
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 24561 AND action = 18
0.0018  SELECT action,minute FROM events2012 WHERE player_id = 225981 AND league_id = 24561 AND action = 19
0.0020  SELECT e.* FROM `events2011` e WHERE e.player_id = 225981 AND league_id = 24544 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 = 24544 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24544 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24544 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 225981 AND league_id = 24553 ORDER BY e.date ASC
0.0030  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 24553 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24553 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24553 AND action = 19
0.0022  SELECT e.* FROM `events2011` e WHERE e.player_id = 225981 AND league_id = 24565 ORDER BY e.date ASC
0.0034  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 24565 AND rel.player_id=225981
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24565 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24565 AND action = 19
0.0018  SELECT e.* FROM `events2011` e WHERE e.player_id = 225981 AND league_id = 24573 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 = 24573 AND rel.player_id=225981
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24573 AND action = 18
0.0018  SELECT action,minute FROM events2011 WHERE player_id = 225981 AND league_id = 24573 AND action = 19
0.0021  SELECT e.* FROM `events2010` e WHERE e.player_id = 225981 AND league_id = 24547 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 = 24547 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 24547 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 24547 AND action = 19
0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 225981 AND league_id = 24556 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 = 24556 AND rel.player_id=225981
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 24556 AND action = 18
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 24556 AND action = 19
0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 225981 AND league_id = 23433 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 = 23433 AND rel.player_id=225981
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 23433 AND action = 18
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 23433 AND action = 19
0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 225981 AND league_id = 23435 ORDER BY e.date ASC
0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 23435 AND rel.player_id=225981
0.0018  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 23435 AND action = 18
0.0019  SELECT action,minute FROM events2010 WHERE player_id = 225981 AND league_id = 23435 AND action = 19