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
 Santa Cruz América RN ASA Arapiraquense Rio Branco Acre Paraná São Raimundo RR Sergipe Caxias do Sul Brasiliense Moto Club MA Santo André Portuguesa RJ Ferroviária Nova Iguaçu Icasa Inter de Limeira São Raimundo AM Sousa Ceilândia Náutico RR SD Juazeirense 4 de Julho Cianorte Tocantinópolis Trem DC Oeste Caldense Globo Marcílio Dias Aimoré Atlético Alagoinhas São Bernardo FC Bahia de Feira São Luiz Jacuipense Real Noroeste URT CSE Anápolis Tuna Luso Castanhal Juventus SC Cascavel FC Costa Rica Lagarto Retro FC Humaitá Afogados Iporá Amazonas FC
Santa Cruz Santa Cruz
América RN América RN
ASA Arapiraquense ASA Arapiraquense
Rio Branco Acre Rio Branco Acre
Paraná Paraná
São Raimundo RR São Raimundo RR
Sergipe Sergipe
Caxias do Sul Caxias do Sul
Brasiliense Brasiliense
Moto Club MA Moto Club MA
Santo André Santo André
Portuguesa RJ Portuguesa RJ
Ferroviária Ferroviária
Nova Iguaçu Nova Iguaçu
Icasa Icasa
Inter de Limeira Inter de Limeira
São Raimundo AM São Raimundo AM
Sousa Sousa
Ceilândia Ceilândia
Náutico RR Náutico RR
SD Juazeirense SD Juazeirense
4 de Julho 4 de Julho
Cianorte Cianorte
Tocantinópolis Tocantinópolis
Trem DC Trem DC
Oeste Oeste
Caldense Caldense
Globo Globo
Marcílio Dias Marcílio Dias
Aimoré Aimoré
Atlético Alagoinhas Atlético Alagoinhas
São Bernardo FC São Bernardo FC
Bahia de Feira Bahia de Feira
São Luiz São Luiz
Jacuipense Jacuipense
Real Noroeste Real Noroeste
URT URT
CSE CSE
Anápolis Anápolis
Tuna Luso Tuna Luso
Castanhal Castanhal
Juventus SC Juventus SC
Cascavel FC Cascavel FC
Costa Rica Costa Rica
Lagarto Lagarto
Retro FC Retro FC
Humaitá Humaitá
Afogados Afogados
Iporá Iporá
Amazonas FC Amazonas FC

  USO DE MEMORIA  
9,365,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.2560
Total Execution Time  0.2590
  CADENA URL  
/serie_d_brasil2022/grupo1/cruces
  GET DATOS  
$_GET['/serie_d_brasil2022/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'serie_d_brasil2022'
0.0039  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=719 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 719 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1272506,1254060,1245098,1241321,1156804) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=719 ORDER BY order_id ASC
0.0023  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 = 66865 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2022 AS c WHERE c.league_id='66865' ORDER BY c.id ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 13:51:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 13:51:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 13:51:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 13:51:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0408  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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66865 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.0705  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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66865 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 events2022 e ON e.player_id = p.id AND e.league_id = 66865 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66865 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0089  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66865 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC