4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Dalian Pro - Cangzhou Mighty Lions
Jornada 6
FINALIZADO
10
10
684 Pts. Elo
59%
9º

685 Pts. Elo
40%
11º

1-1
Martes, 09 Mayo 2023, 13:35
0 - 1
 55' O. Maritu
Lin Liangming 57'
1 - 1

Eventos del partido

Goles

minuto 55'O. MarituGol de O. Maritu
Lin LiangmingGol de
Lin Liangming
minuto 57'

Tarjetas

minuto 46'M. SkoricT. Amarilla M. Skoric
Vas NuñezT. Amarilla
Vas Nuñez
minuto 61'

Cambios

S. MambaEntra en el partido
S. Mamba
minuto 46'
Yin ShangSale del partido
Yin Shang
minuto 46'
N. BosančićEntra en el partido
N. Bosančić
minuto 46'
Fei YuSale del partido
Fei Yu
minuto 46'
minuto 85'Zheng KaimuSale del partido Zheng Kaimu
minuto 85'Yao XuchenEntra en el partido Yao Xuchen
minuto 85'G. ZhukovEntra en el partido G. Zhukov
minuto 85'D. Owusu-SekyereSale del partido D. Owusu-Sekyere
Zhu TingEntra en el partido
Zhu Ting
minuto 86'
Zhen'ao WangSale del partido
Zhen'ao Wang
minuto 86'
Yan XiangchuangSale del partido
Yan Xiangchuang
minuto 90'
C. ManzokiEntra en el partido
C. Manzoki
minuto 90'

Otros

minuto 55'D. Owusu-SekyereAsistencia D. Owusu-Sekyere
N. BosančićAsistencia
N. Bosančić
minuto 57'

VAR

S. MambaAnulado por var
S. Mamba
minuto 76'

Alineaciones

Dalian Pro

Dalian Pro

4-5-1
Alineación Inicial
Suplentes
Cangzhou Mighty Lions

Cangzhou Mighty Lions

5-4-1
Alineación Inicial
Suplentes

Estadísticas del partido

Dalian Pro Dalian Pro Cangzhou Mighty Lions Cangzhou
59%
Posesión del balón
 40%
1
Goles
 1
3
Tiros a puerta
 1
7
Tiros fuera
 3
14
Total tiros
 9
0
Paradas del portero
 2
5
Saques de esquina
 4
1
Fueras de juego
 2
0
Tarjetas Rojas
 0
1
Asistencias
 1
3
Sustituciones
 2
10
Faltas
 14


  USO DE MEMORIA  
6,712,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5243
Total Execution Time  0.5254
  CADENA URL  
/partido/Dalian-Aerbin/Shijizhuang-Yongchang/2017?section=legal
  GET DATOS  
$_GET['/partido/Dalian-Aerbin/Shijizhuang-Yongchang/2017']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0117   SELECT c.*, c.stadium as real_stadium, 2024 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 calendars2024 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 = 'Dalian-Aerbin' AND dt2.basealias = 'Shijizhuang-Yongchang'
0.0116   SELECT c.*, c.stadium as real_stadium, 2025 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 calendars2025 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 = 'Dalian-Aerbin' AND dt2.basealias = 'Shijizhuang-Yongchang'
0.0106  SELECT data1 FROM stats2023 t WHERE league_id = 71453 AND teamId = 6573739 and type = 33
0.0106  SELECT data1 FROM stats2023 t WHERE league_id = 71453 AND teamId = 6573736 and type = 33
0.0114  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '807329' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 807329 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0108  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 807329 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='807329' AND `active` = 1 AND year = 2023
0.0113  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='71453' AND relp.team_id=6573739 WHERE relp.in_squad=1 and mp.`match_id` = '807329' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0111  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='71453' AND relp.team_id=6573736 WHERE relp.in_squad=1 and mp.`match_id` = '807329' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=807329 AND extraId = 71453 AND type_rel = 4
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 807329 AND league_id = 71453 AND year = 2023