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

Porto II

Entrenador: António Folha

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Abraham Marcus5
Gui Guedes4
Wendel Silva4
Rodrigo Fernandes4
Nilton Varela3
Bernardo Folha3
Jorge Meireles2
Rodrigo Mora2
Rodrigo Pinheiro2
Vasco Sousa2
João Mendes1
ENTRA
G. Sousa15
Rodrigo Mora14
A. Candé13
Jorge Meireles12
U. Djaló8
Abraham Marcus8
Braima Sambú7
Rui Monteiro7
Adramane Cassama6
Rodrigo Fernandes6
Martim Fernandes6
Dinis6
Kennyd5
Gui Guedes4
A. Oliveira4
Wendel Silva4
Umaro Candé3
Rodrigo Pinheiro3
João Mendes2
Antonio Ribeiro2
Nilton Varela2
J. Teixeira1
Romain Correia1
Luís Mota1
Vasco Sousa1
SALE
Rodrigo Fernandes17
Gui Guedes17
Vasco Sousa16
Abraham Marcus14
Rodrigo Mora11
Rodrigo Pinheiro10
Wendel Silva9
Braima Sambú8
Nilton Varela7
A. Candé6
Martim Fernandes6
Jorge Meireles5
Bernardo Folha3
G. Sousa3
Rui Monteiro3
Kennyd2
Adramane Cassama1
Gabriel Brás1
Gabriel Veron1
U. Djaló1

  USO DE MEMORIA  
4,941,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2497
Total Execution Time  0.2516
  CADENA URL  
/estadisticas/Porto-Ii
  GET DATOS  
$_GET['/estadisticas/Porto-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0145  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Porto-Ii' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0133  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9249 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9249 AND type_rel = 2
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9249 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0136  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (25680,30227,68502,83791,96984) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '9249' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0143  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 events2024 e ON e.player_id = p.id AND e.league_id = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 9249 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 events2024 e ON e.player_id = p.id AND e.league_id = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 9249 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 events2024 e ON e.player_id = p.id AND e.league_id = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 9249 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30