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

Cruce de partidos LaLiga Genuine - Todos los partidos de la temporada

IdaVuelta
 Athletic Club Fundazioa CA Osasuna Celta Integra Girona FC RC Deportivo de la Coruña RCD Espanyol RCD Mallorca Real Sporting CD Lugo CF Reus Córdoba CF Deportivo Alavés Fundación At. de Madrid Gimnàstic de Tarragona Levante UD Real Oviedo Real Sociedad Real Valladolid Real Zaragoza SD Eibar Fundazioa SD Huesca Sevilla FC UD Almería UD Las Palmas Valencia CF CD Leganés Fundación Albacete Málaga CF EDI Rayo Vallecano Villarreal CF Cádiz CF CD Tenerife Elche CF Getafe CF Granada CF Real Betis Balompié Fundació Barça UD Ibiza Burgos CF CF Fuenlabrada FC Cartagena SD Ponferradina FC Andorra Fundación Real Madrid Racing Racing Ferrol
Athletic Club Fundazioa Athletic Club Fundazioa
CA Osasuna CA Osasuna
Celta Integra Celta Integra
Girona FC Girona FC
RC Deportivo de la Coruña RC Deportivo de la Coruña
RCD Espanyol RCD Espanyol
RCD Mallorca RCD Mallorca
Real Sporting Real Sporting
CD Lugo CD Lugo
CF Reus CF Reus
Córdoba CF Córdoba CF
Deportivo Alavés Deportivo Alavés
Fundación At. de Madrid Fundación At. de Madrid
Gimnàstic de Tarragona Gimnàstic de Tarragona
Levante UD Levante UD
Real Oviedo Real Oviedo
Real Sociedad Real Sociedad
Real Valladolid Real Valladolid
Real Zaragoza Real Zaragoza
SD Eibar Fundazioa SD Eibar Fundazioa
SD Huesca SD Huesca
Sevilla FC Sevilla FC
UD Almería UD Almería
UD Las Palmas UD Las Palmas
Valencia CF Valencia CF
CD Leganés CD Leganés
Fundación Albacete Fundación Albacete
Málaga CF EDI Málaga CF EDI
Rayo Vallecano Rayo Vallecano
Villarreal CF Villarreal CF
Cádiz CF Cádiz CF
CD Tenerife CD Tenerife
Elche CF Elche CF
Getafe CF Getafe CF
Granada CF Granada CF
Real Betis Balompié Real Betis Balompié
Fundació Barça Fundació Barça
UD Ibiza UD Ibiza
Burgos CF Burgos CF
CF Fuenlabrada CF Fuenlabrada
FC Cartagena FC Cartagena
SD Ponferradina SD Ponferradina
FC Andorra FC Andorra
Fundación Real Madrid Fundación Real Madrid
Racing Racing
Racing Ferrol Racing Ferrol

  USO DE MEMORIA  
7,405,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0945
Total Execution Time  0.0964
  CADENA URL  
/laliga_genuine2024/grupo1/cruces
  GET DATOS  
$_GET['/laliga_genuine2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'laliga_genuine2024'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'laliga_genuine' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2092 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2092 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 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 (1200501,1147264,1130550,1122173,1118298) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2092 ORDER BY order_id ASC
0.0028  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='74563' ORDER BY c.id ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 02:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 02:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 02:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 02:48:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'laliga_genuine' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0029  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74563 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74563 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74563 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74563 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0114  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 74563 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC