4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sergipe - ASA Arapiraquense
Jornada 10
FINALIZADO
40
10
323 Pts. Elo
13º

401 Pts. Elo
58º

2-0
Domingo, 08 Agosto 2021, 21:00
Paulinho Simionato 42'
1 - 0
Ewerton 56'
2 - 0

Eventos del partido

Goles

Paulinho SimionatoGol de
Paulinho Simionato
minuto 42'
EwertonGol de penalti
Ewerton
minuto 56'

Tarjetas

minuto 6'Marcelo AmaralT. Amarilla Marcelo Amaral
PitT. Amarilla
Pit
minuto 18'
LuizinhoT. Amarilla
Luizinho
minuto 23'
Júlio CesarT. Amarilla
Júlio Cesar
minuto 39'
EwertonT. Amarilla
Ewerton
minuto 63'

Cambios

minuto 46'Biro ParaíbaEntra en el partido Biro Paraíba
minuto 46'FernandoSale del partido Fernando
minuto 57'DaivisonSale del partido Daivison
minuto 57'JoandersonEntra en el partido Joanderson
EliveltonEntra en el partido
Elivelton
minuto 61'
Júlio CesarSale del partido
Júlio Cesar
minuto 61'
CharlesEntra en el partido
Charles
minuto 61'
Da SilvaSale del partido
Da Silva
minuto 61'
JeilsonEntra en el partido
Jeilson
minuto 79'
EwertonSale del partido
Ewerton
minuto 79'
M. MoraisEntra en el partido
M. Morais
minuto 79'
LuizinhoSale del partido
Luizinho
minuto 79'
minuto 83'CaioEntra en el partido Caio
minuto 83'XandeSale del partido Xande
Paulinho SimionatoSale del partido
Paulinho Simionato
minuto 83'
HenriqueEntra en el partido
Henrique
minuto 83'

Alineaciones

Sergipe

Sergipe

4-4-2
Alineación Inicial
Suplentes
ASA Arapiraquense

ASA Arapiraquense

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,309,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3713
Total Execution Time  0.3723
  CADENA URL  
/partido/Sergipe/Agremiacao-Sportiva-Arapiraquense/2021
  GET DATOS  
$_GET['/partido/Sergipe/Agremiacao-Sportiva-Arapiraquense/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0059   SELECT c.*, c.stadium as real_stadium, 2021 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2021 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Sergipe' AND dt2.basealias = 'Agremiacao-Sportiva-Arapiraquense'
0.0026  SELECT c.*, 2021 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2021 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Sergipe' AND dt2.basealias = 'Agremiacao-Sportiva-Arapiraquense'
0.0019  SELECT data1 FROM stats2021 t WHERE league_id = 62039 AND teamId = 6435519 and type = 33
0.0019  SELECT data1 FROM stats2021 t WHERE league_id = 62039 AND teamId = 6435524 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '395883' and rp.type = 2021 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 395883 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 395883 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0022  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='395883' AND `active` = 1 AND year = 2021
0.0070  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='62039' AND relp.team_id=6435519 WHERE relp.in_squad=1 and mp.`match_id` = '395883' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0057  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='62039' AND relp.team_id=6435524 WHERE relp.in_squad=1 and mp.`match_id` = '395883' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=395883 AND extraId = 62039 AND type_rel = 4
0.0021  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.0032  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.0035  SELECT * FROM futbol.calendars_lineups WHERE id = 395883 AND league_id = 62039 AND year = 2021