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

Cruce de partidos Serie D - Brasil - Todos los partidos de la temporada

IdaVuelta
 América RN ASA Arapiraquense Rio Branco Acre São Raimundo RR Joinville Sergipe Campinense Caxias do Sul Brasiliense Moto Club MA Ríver São Caetano Itabaiana Fast Clube Portuguesa RJ Coruripe Ituano Operário MS Salgueiro Brusque Central SC Santos AP Boavista SC Maranhão Ferroviária União Rondonópolis Atlético Roraima Fluminense de Feira SD Juazeirense Cianorte Santa Cruz RN Anapolina Manaus Altos Palmas FR Aparecidense Caldense Tupi Atlético Cearense Bahia de Feira Vitória ES Interporto Jacuipense Galvez EC SAO Raimundo EC EC Avenida URT CA Tubarão Sinop FC Ypiranga AP
América RN América RN
ASA Arapiraquense ASA Arapiraquense
Rio Branco Acre Rio Branco Acre
São Raimundo RR São Raimundo RR
Joinville Joinville
Sergipe Sergipe
Campinense Campinense
Caxias do Sul Caxias do Sul
Brasiliense Brasiliense
Moto Club MA Moto Club MA
Ríver Ríver
São Caetano São Caetano
Itabaiana Itabaiana
Fast Clube Fast Clube
Portuguesa RJ Portuguesa RJ
Coruripe Coruripe
Ituano Ituano
Operário MS Operário MS
Salgueiro Salgueiro
Brusque Brusque
Central SC Central SC
Santos AP Santos AP
Boavista SC Boavista SC
Maranhão Maranhão
Ferroviária Ferroviária
União Rondonópolis União Rondonópolis
Atlético Roraima Atlético Roraima
Fluminense de Feira Fluminense de Feira
SD Juazeirense SD Juazeirense
Cianorte Cianorte
Santa Cruz RN Santa Cruz RN
Anapolina Anapolina
Manaus Manaus
Altos Altos
Palmas FR Palmas FR
Aparecidense Aparecidense
Caldense Caldense
Tupi Tupi
Atlético Cearense Atlético Cearense
Bahia de Feira Bahia de Feira
Vitória ES Vitória ES
Interporto Interporto
Jacuipense Jacuipense
Galvez EC Galvez EC
SAO Raimundo EC SAO Raimundo EC
EC Avenida EC Avenida
URT URT
CA Tubarão CA Tubarão
Sinop FC Sinop FC
Ypiranga AP Ypiranga AP

  USO DE MEMORIA  
8,658,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.2460
Total Execution Time  0.2491
  CADENA URL  
/serie_d_brasil2019/grupo1/cruces
  GET DATOS  
$_GET['/serie_d_brasil2019/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'serie_d_brasil2019'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d_brasil' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=719 ORDER BY order_id ASC
0.0025  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2019 AS c WHERE c.league_id='49171' ORDER BY c.id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 07:12:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 07:12:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 07:12:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 07:12:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d_brasil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0400  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 events2019 e ON e.player_id = p.id AND e.league_id = 49171 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49171 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.0856  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 events2019 e ON e.player_id = p.id AND e.league_id = 49171 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49171 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0071  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 events2019 e ON e.player_id = p.id AND e.league_id = 49171 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49171 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0100  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 49171 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC