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

Paderborn

Entrenador: Lukas Kwasniok

Temporada 2023/2024

Estadísticas

ASISTENCIAS
R. Obermair6
Filip Bilbija5
F. Muslija4
R. Leipertz3
Sirlord Conteh3
Aaron Zehnter2
Felix Platte2
Ilyas Ansah2
S. Klaas2
A. Grimaldi1
Niclas Nadj1
M. Hoffmeier1
K. Kostons1
D. Kinsombi1
Max Kruse1
Kai Klefisch1
ENTRA
Sirlord Conteh22
R. Leipertz18
A. Grimaldi13
Ilyas Ansah10
D. Kinsombi9
Jannis Heuer9
S. Klaas9
Felix Platte7
Marco Schuster5
Niclas Nadj5
Kai Klefisch5
Aaron Zehnter4
Mattes Hansen4
Laurin Curda4
C. Brackelmann4
K. Ezekwem3
Max Kruse3
Tobias Müller3
M. Hoffmeier3
Visar Musliu3
Maximilian Rohr2
R. Obermair2
Filip Bilbija2
F. Muslija1
Jascha Brandt1
K. Kostons1
SALE
S. Klaas15
Kai Klefisch12
Ilyas Ansah11
A. Grimaldi10
K. Kostons10
Sirlord Conteh10
F. Muslija10
Filip Bilbija10
Laurin Curda7
D. Kinsombi7
Felix Platte7
R. Leipertz6
Mattes Hansen6
R. Obermair5
Marco Schuster4
Aaron Zehnter4
Tobias Müller4
C. Brackelmann4
Visar Musliu3
M. Hoffmeier3
Niclas Nadj2
M. Ens1
Jannis Heuer1
Max Kruse1
M. Flotho1
Marco Pledl1

  USO DE MEMORIA  
5,354,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  7.6835
Total Execution Time  7.6849
  CADENA URL  
/estadisticas/Paderborn
  GET DATOS  
$_GET['/estadisticas/Paderborn']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4800 AND type_rel = 2
0.1665  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4800 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0389  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 (2657,19685,47636,81190,90412) ORDER BY n.cover_points DESC, update_date DESC
0.6366  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 = '4800' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0263  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72037 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0463  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72172 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.8932  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=4800 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0179  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72172,72037,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.4258  SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 4800
0.6798  SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 4800
0.2450  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4800
1.1428  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.6648  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.4640  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.7157  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.7672  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.7149  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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 4800 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30