4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2011
Temporada Siguiente »
Liga MX - Apertura 2011
2010/2011

liga mx, liga mexico, primera division mexicana, liga mx apertura, primera division mexicana apertura, liga bbva mx, liga bbva mexico,liga mexicana,apertura mexico

Liga MX - Apertura 2011

  • Monterrey
  • Santos Laguna
  • Tigres UANL
  • Chivas Guadalajara
  • Necaxa
  • Tecos
  • América
  • San Luis
  • Pachuca
  • Toluca
  • Atlante FC
  • Atlas Guadalajara
  • Cruz Azul
  • Chiapas
  • Pumas UNAM
  • CA Morelia
  • Puebla
  • Querétaro

Clasificación

Equipo PJ GF GC Puntos
1 Monterrey Monterrey 17 29 20 32
2 Santos Laguna Santos 17 28 19 30
3 Tigres UANL Tigres UANL 17 24 16 24
4 Chivas Guadalajara Chivas 17 16 15 22
5 Necaxa Necaxa 17 14 21 16
6 Tecos Tecos 17 18 36 15
7 América América 17 22 16 27
8 San Luis San Luis 17 21 19 26
9 Pachuca Pachuca 17 27 28 25
10 Toluca Toluca 17 18 20 22
11 Atlante FC Atlante FC 17 17 27 16
12 Atlas Guadalajara Atlas 17 18 27 13
13 Cruz Azul Cruz Azul 17 33 13 39
14 Chiapas Chiapas 17 21 14 25
15 Pumas UNAM Pumas UNAM 17 23 24 25
16 CA Morelia CA Morelia 17 17 16 21
17 Puebla Puebla 17 21 26 19
18 Querétaro Querétaro 17 18 28 19

  USO DE MEMORIA  
5,394,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4845
Total Execution Time  0.4864
  CADENA URL  
/apertura_mexico2011/grupo1/resumen/17
  GET DATOS  
$_GET['/apertura_mexico2011/grupo1/resumen/17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0145  SELECT type FROM routes WHERE alias = 'apertura_mexico2011'
0.0296  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0354  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 68 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (1304130,1303039,1297779,1295604,1295599) ORDER BY n.cover_points DESC, update_date DESC
0.0146  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 68 GROUP BY l.categoryId
0.0147  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=68 GROUP BY l.year ORDER BY l.year DESC
0.0147  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 = 1208 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2011` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 1208 AND c.`round` = 17 ORDER BY shedule ASC LIMIT 200
0.0166  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2011` e INNER JOIN calendars2011 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 17 AND e.real_date IS NOT NULL AND e.league_id = 1208 ORDER BY total DESC LIMIT 100
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:10:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:10:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:10:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:10:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0289  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0496  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0166  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 1208 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC