4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Tianjin Tianhai - Beijing Guoan
FINALIZADO
20
10
1321 Pts. Elo
42%
15º

2091 Pts. Elo
58%

0-3
Domingo, 22 Septiembre 2019, 11:30
0 - 1
4' H. Yongyong
0 - 2
28' Zhang Yuning
0 - 3
90' Renato Augusto

Eventos del partido

Goles

minuto 4'Gol de H. Yongyong
minuto 28'Gol de Zhang Yuning
minuto 90'Gol de Renato Augusto

Tarjetas

minuto 73'T. Amarilla Dehai Zou
T. Amarilla
Pei Shuai
minuto 77'
T. Amarilla
Zheng Dalun
minuto 86'

Cambios

Entra en el partido
Leonardo
minuto 46'
Sale del partido
Sun Ke
minuto 46'
Sale del partido
Alan
minuto 66'
Entra en el partido
Xu Yang
minuto 66'
minuto 70'Entra en el partido Dun Ba
minuto 70'Sale del partido H. Yongyong
minuto 80'Sale del partido Xizhe Zhang
minuto 80'Entra en el partido Li Ke
Entra en el partido
Wang Xiaolong
minuto 80'
Sale del partido
Liao Lisheng
minuto 80'
minuto 87'Sale del partido Fernando Lucas
minuto 87'Entra en el partido Cheng Piao

Otros

minuto 28'Asistencia Zhongguo Chi
minuto 90'Asistencia Zhang Yuning

Estadísticas del partido

Tianjin Tianhai Tianjin Beijing Guoan Beijing
42%
Posesión del balón
58%
0
Goles
3
6
Tiros a puerta
9
7
Tiros fuera
9
13
Total tiros
18
6
Paradas del portero
6
7
Saques de esquina
7
0
Fueras de juego
1
2
Tarjetas Amarillas
1
0
Tarjetas Rojas
0
0
Asistencias
2
3
Sustituciones
3
15
Faltas
9

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
Liga de Campeones por M+ TV Castellano

  USO DE MEMORIA  
6,703,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.8764
Total Execution Time  0.8775
  CADENA URL  
/partido/Tianjin-Songjiang/Beijing-Guoan/2019/send_result
  GET DATOS  
$_GET['/partido/Tianjin-Songjiang/Beijing-Guoan/2019/send_result']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0125  SELECT data1 FROM stats2019 t WHERE league_id = 48533 AND teamId = 6258709 and type = 33
0.0124  SELECT data1 FROM stats2019 t WHERE league_id = 48533 AND teamId = 6258696 and type = 33
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '418986' and rp.type = 2019 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 418986 AND year = 2019 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 418986 AND year = 2019 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='418986' AND `active` = 1 AND year = 2019
0.0176  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='48533' AND relp.team_id=6258709 WHERE relp.in_squad=1 and mp.`match_id` = '418986' AND mp.year='2019' ORDER BY mp.`team` ASC, p.`role` ASC
0.0183  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='48533' AND relp.team_id=6258696 WHERE relp.in_squad=1 and mp.`match_id` = '418986' AND mp.year='2019' ORDER BY mp.`team` ASC, p.`role` ASC
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=418986 AND extraId = 48533 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29 AND type_rel = 3
0.0152  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 29 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1311615,1310138,1302659,1300548,1299499) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 418986 AND league_id = 48533 AND year = 2019