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

Barcelona Fem

Entrenador: Jonatan Giráldez

Presidente: Joan Laporta

Temporada 2023/2024

Estadísticas

ASISTENCIAS
C. Graham16
Aitana9
Ona Batlle5
E. Brugts5
Mariona5
L. Bronze4
Patri Guijarro4
K. Walsh4
C. Pina4
Vicky López3
S. Paralluelo3
M. Fernández2
B. Vilamala2
Torrejón2
Irene Paredes2
Alexia Putellas2
L. Corrales2
F. Rolfö1
G. Dragoni1
ENTRA
Mariona13
K. Walsh9
Torrejón9
Vicky López8
B. Vilamala8
A. Oshoala7
C. Pina6
I. Engen6
E. Brugts6
L. Corrales5
Alexia Putellas5
Aitana5
L. Bronze5
G. Dragoni4
S. Paralluelo4
C. Graham4
Ari3
Patri Guijarro3
Irene Paredes2
Ona Batlle2
F. Rolfö2
Jana Fernández1
M. Fernández1
Mapi1
SALE
C. Pina11
C. Graham11
Aitana9
E. Brugts9
S. Paralluelo8
Mariona8
Vicky López7
Irene Paredes6
L. Bronze6
B. Vilamala6
Patri Guijarro6
Alexia Putellas6
Ona Batlle5
L. Corrales4
M. Fernández4
Torrejón4
I. Engen3
K. Walsh3
F. Rolfö2
Jana Fernández1

  USO DE MEMORIA  
5,771,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3333
Total Execution Time  0.3345
  CADENA URL  
/estadisticas/Fc-Barcelona-Femenino
  GET DATOS  
$_GET['/estadisticas/Fc-Barcelona-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0253  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 = 72467
0.0131  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 = 74006
0.0132  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 = 74405
0.0132  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 = 75295
0.0129  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 = 75020
0.0132  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 = 74447
0.0131  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 = 73659
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8852 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8852 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (1312869,1312845,10314,15983,17147) 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 = '8852' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 75295 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 72467 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 75020 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8852 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8852 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8852 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30