4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
IL Stjørdals-Blink - Ranheim
Jornada 192
FINALIZADO
00
00
222 Pts. Elo

711 Pts. Elo

1-2
Domingo, 27 Marzo 2022, 15:00
0 - 1
 69' M. Karlsen
Mats Lillebo 78'
1 - 1
1 - 2
 79' M. Karlsen
IL Stjørdals-Blink
Ranheim
Gol de penalti
Gol
Gol

Eventos del partido

Goles

minuto 69'M. KarlsenGol de penalti M. Karlsen
Mats LilleboGol de
Mats Lillebo
minuto 78'
minuto 79'M. KarlsenGol de M. Karlsen
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,609,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2503
Total Execution Time  0.2512
  CADENA URL  
/partido_62807/Stjordals-Blink/Ranheim/2022
  GET DATOS  
$_GET['/partido_62807/Stjordals-Blink/Ranheim/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT data1 FROM stats2022 t WHERE league_id = 62807 AND teamId = 6503131 and type = 33
0.0018  SELECT data1 FROM stats2022 t WHERE league_id = 62807 AND teamId = 6506153 and type = 33
0.0018  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 62807 AND id_match = 432410
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '432410' and rp.type = 2022 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 = 432410 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 432410 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0129  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 = 62807 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 62807 AND t.round = 220 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='432410' AND `active` = 1 AND year = 2022
0.0023  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='62807' AND relp.team_id=6503131 WHERE relp.in_squad=1 and mp.`match_id` = '432410' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0032  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='62807' AND relp.team_id=6506153 WHERE relp.in_squad=1 and mp.`match_id` = '432410' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '62807' AND id_match = '432410'
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=432410 AND extraId = 62807 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0090  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (1312034,1307741,1307681,1307639,1307019) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT position FROM tables2022 WHERE team=6503131 AND league_id=62807 AND round=192
0.0020  SELECT position FROM tables2022 WHERE team=6506153 AND league_id=62807 AND round=192
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 432410 AND league_id = 62807 AND year = 2022