4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ADT de Tarma

ADT de Tarma

Entrenador: Carlos Desio

Temporada 2023/2024
TEMPORADA 2023/2024
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 14 37 15 34
2 Universitario de Deportes Universitari 14 24 6 33
3 FBC Melgar FBC Melgar 14 23 15 29
4 Alianza Lima Alianza Lima 14 27 11 27
5 ADT de Tarma Tarma 14 25 21 24
6 Cusco FC Cusco FC 14 16 17 23
7 Cienciano Cienciano 14 18 19 21
8 Comerciantes Unidos Comerciantes 14 21 27 21
9 Los Chankas Los Chankas 14 22 21 17
10 Sport Huancayo Sport 13 16 22 17
11 UTC Cajamarca Cajamarca 14 16 18 15
12 Univ. César Vallejo Univ. César 14 16 22 15
13 Atlético Grau Atlético 13 14 15 14
14 Deportivo Garcilaso Deportivo 14 17 20 13
15 Alianza Atl. Sullana Alianza Atl. 14 11 16 13
16 Sport Boys Association Sport Boys. 14 12 17 12
17 CA Manucci CA Manucci 14 11 31 12
18 Unión Comercio Unión 14 13 26 7
TEMPORADA 2022/2023
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Universitario de Deportes Universitari 18 28 8 39
2 FBC Melgar FBC Melgar 18 31 13 38
3 Alianza Lima Alianza Lima 18 18 6 37
4 Sporting Cristal Sporting 18 31 13 36
5 ADT de Tarma Tarma 18 21 13 34
6 Sport Huancayo Sport 18 22 14 29
7 Deportivo Garcilaso Deportivo 18 24 20 27
8 Univ. César Vallejo Univ. César 18 25 19 24
9 Cienciano Cienciano 18 21 20 24
10 Sport Boys Association Sport Boys. 18 15 23 23
11 CA Manucci CA Manucci 18 19 22 20
12 UTC Cajamarca Cajamarca 18 21 23 19
13 Cusco FC Cusco FC 18 18 23 18
14 Atlético Grau Atlético 17 17 27 18
15 Deportivo Binacional Deportivo 18 25 34 17
16 Unión Comercio Unión 18 18 32 17
17 Academia Cantolao Academia 18 12 26 17
18 Alianza Atl. Sullana Alianza Atl. 18 14 25 16
19 Deportivo Municipal Deportivo 17 17 36 12
TEMPORADA 2021/2022
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 18 31 10 42
2 Sporting Cristal Sporting 18 39 17 41
3 Atlético Grau Atlético 18 30 19 37
4 Universitario de Deportes Universitari 18 25 10 33
5 FBC Melgar FBC Melgar 18 31 18 33
6 Univ. César Vallejo Univ. César 18 25 24 33
7 UTC Cajamarca Cajamarca 18 28 24 28
8 Sport Huancayo Sport 18 26 18 27
9 Alianza Atl. Sullana Alianza Atl. 18 23 21 27
10 Deportivo Binacional Deportivo 18 28 19 26
11 Cienciano Cienciano 18 24 23 25
12 ADT de Tarma Tarma 18 25 25 24
13 Sport Boys Association Sport Boys. 18 23 31 21
14 Deportivo Municipal Deportivo 18 20 29 20
15 Academia Cantolao Academia 18 19 22 19
16 Ayacucho FC Ayacucho FC 18 16 28 14
17 CA Manucci CA Manucci 18 13 33 13
18 Carlos Stein Carlos Stein 18 18 43 6
19 Univ. San Martín Univ. 18 17 47 6

  USO DE MEMORIA  
5,399,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4549
Total Execution Time  0.4562
  CADENA URL  
/historico/Adt-Tarma
  GET DATOS  
$_GET['/historico/Adt-Tarma']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0115  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Adt-Tarma' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=122732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=122732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=122732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=122732 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0215  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74999
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=122732 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=45 AND type_rel = 3
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 45 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1308316,1302164,1264407,1261212,1258591) ORDER BY n.cover_points DESC, update_date DESC
0.0108  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '122732' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '122732' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0108  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '122732' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74908 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74999 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=122732 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0111  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74999,74908,71432,70809) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 74999 AND teamId = 122732
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 70809 AND teamId = 122732
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 74908 AND teamId = 122732
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 122732
0.0108  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '122732' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '122732' and rp.type = 4
0.0114  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '122732' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0179  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 122732 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 122732 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 122732 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 122732 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 `tables2024` 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 = 74999 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
0.0110  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 `tables2023` 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 = 70808 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 66203 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 66204 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC