4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Seleccionados para España-Eslovaquia

Del Bosque a elegido a estos Jugadores

0comenta tu también!
Hace 8 años por eldenoticias
|
Detalle de votos
convocatoria_SeleccionEspaña
1

Porteros: Casillas,De Gea,Kiko Casilla.

Defensas: Carvajal,Juanfran,Gerard Pique,Raúl Albiol,Sergio Rmos,Azpilicueta,Jordi Alba.

Centocampistas: Iturraspe,Sergio Busquets,Koke,Andres Iniesta,Santi Cazorla,Cesc Fabregas,Rodrigo,Pedro,Raúl García,Juan Bernat

Delanteros:Diego Costa,Paco Alcacer,David Silva.

0 Comentarios

No hay comentarios


  USO DE MEMORIA  
3,984,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Notice / Index )  0.3002
Total Execution Time  0.3018
  CADENA URL  
/noticia/seleccionados-espana-eslovaquia
  GET DATOS  
$_GET['/noticia/seleccionados-espana-eslovaquia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0005   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`new_content_id` = '98844'
0.0343  SELECT n.*,rn.*,u.user_name,u.user_name as media_username,p.title as ptitle,p.width,p.height,v.code,v.title as vtitle,p.id as pid,v.id as vid,p.author_id as pauthor_id,v.author_id as vauthor_id, v.url as video_url, v.type AS vtype FROM `news` n INNER JOIN fa_user u ON u.id = n.author_id INNER JOIN `rel_news` as rn ON n.id = rn.id_new LEFT JOIN `pictures` as p ON n.picture_content_id = p.id AND p.banned=0 LEFT JOIN `videos` as v ON n.video_content_id = v.id WHERE n.alias = 'seleccionados-espana-eslovaquia' AND n.content_type != 2
0.0148  SELECT * FROM rel_news WHERE id_new = 98844 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0148  SELECT title as name,alias FROM topics WHERE id =6
0.0147  SELECT user_name FROM fa_user WHERE id =916260
0.0157  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 98844 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0145  SELECT alias FROM `news` as p WHERE author_id = 916260 AND id < 98844 ORDER by p.id DESC LIMIT 1
0.0147  SELECT alias FROM `news` as p WHERE author_id = 916260 AND id > 98844 ORDER BY p.id ASC LIMIT 1
0.0145  SELECT alias FROM `news` as p WHERE author_id = 916260 AND id > 98844 ORDER BY p.id DESC LIMIT 0,1
0.0147  SELECT alias FROM `news` as p WHERE author_id = 916260 AND id < 98844 ORDER BY p.id ASC LIMIT 0,1
0.0145  SELECT id_content FROM rel_news WHERE id_new = '98844' AND type = '5'
0.0151  SELECT l.id,c.`name` as name,l.group_code,l.total_group,c.CountryCode,c.`alias` as alias FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.status = 1 AND l.links = 2 AND l.year = 2024 AND c.listed = 1 AND l.tables = 1 AND l.group_code > 0 AND c.troncal = 1 AND l.game = 1 AND c.class < 5 ORDER BY c.coefficient DESC, c.name ASC ,l.group_code ASC
0.0145  SELECT * FROM topics ORDER BY priority ASC