4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Ene 20 España Sub 19España 1 - 1 Italia Sub 19Italia 1
28 Ene 20 Macedonia del Norte Sub 19Macedonia 1 - 2 Azerbaiyán Sub 19Azerbaiyán ...
Ver jornada
Jornada 2
12 Feb 20 Italia Sub 19Italia 0 - 0 Suiza Sub 19Suiza ...
18 Feb 20 Croacia Sub 19Croacia 4 - 0 Austria Sub 19Austria ...
20 Feb 20 Bélgica Sub 19Bélgica 2 - 0 Luxemburgo Sub 19Luxemburgo 1
25 Feb 20 Portugal Sub 19Portugal 3 - 1 Francia Sub 19Francia 4
26 Feb 20 España Sub 19España 1 - 1 Dinamarca Sub 19Dinamarca ...
06 Feb 20 Turquia Sub 19Turquia 0 - 1 Eslovenia Sub 19Eslovenia ...
04 Feb 20 Eslovenia Sub 19Eslovenia 1 - 1 Turquia Sub 19Turquia ...
11 Feb 20 Rusia Sub 19Rusia 2 - 0 Uzbekistán Sub 19Uzbekistán ...
18 Feb 20 República Checa Sub 19República 1 - 1 Escocia Sub 19Escocia ...
20 Feb 20 Macedonia del Norte Sub 19Macedonia 1 - 0 Bosnia Sub 19Bosnia ...
20 Feb 20 Austria Sub 19Austria 1 - 1 Croacia Sub 19Croacia ...
20 Feb 20 Escocia Sub 19Escocia 1 - 0 República Checa Sub 19República ...
18 Feb 20 Bosnia Sub 19Bosnia 1 - 0 Macedonia del Norte Sub 19Macedonia ...
28 Feb 20 Macedonia del Norte Sub 19Macedonia 3 - 4 Georgia Sub 19Georgia ...
25 Feb 20 Georgia Sub 19Georgia 1 - 5 Macedonia del Norte Sub 19Macedonia ...
Ver jornada
Jornada 3
04 Mar 20 Eslovenia Sub 19Eslovenia 0 - 1 Austria Sub 19Austria ...
10 Mar 20 Malta Sub 19Malta 0 - 2 Montenegro Sub 19Montenegro ...
10 Mar 20 Serbia Sub 19Serbia 3 - 0 Bulgaria Sub 19Bulgaria ...
12 Mar 20 Montenegro Sub 19Montenegro 3 - 1 Malta Sub 19Malta ...
12 Mar 20 Bulgaria Sub 19Bulgaria 0 - 2 Serbia Sub 19Serbia ...
Ver jornada
Jornada 4
22 Abr 20 Dinamarca Sub 19Dinamarca Apl Alemania Sub 19Alemania ...
Ver jornada
Jornada 5
03 Jun 20 Suecia Sub 19Suecia Apl Suiza Sub 19Suiza ...
Ver jornada
Jornada 6
03 Sep 20 Suiza Sub 19Suiza Apl Irlanda Sub 19Irlanda ...
06 Sep 20 Irlanda Sub 19Irlanda Apl Suiza Sub 19Suiza ...
07 Sep 20 Polonia Sub 19Polonia Apl República Checa Sub 19República ...
02 Sep 20 Croacia Sub 19Croacia 3 - 2 Bulgaria Sub 19Bulgaria ...
03 Sep 20 Polonia Sub 19Polonia 1 - 1 Alemania Sub 19Alemania ...
08 Sep 20 Bélgica Sub 19Bélgica 1 - 0 Alemania Sub 19Alemania ...
04 Sep 20 Austria Sub 19Austria 0 - 2 Eslovenia Sub 19Eslovenia ...
05 Sep 20 Croacia Sub 19Croacia 4 - 3 Arabia Saudí Sub 19Arabia ...
05 Sep 20 Bulgaria Sub 19Bulgaria 3 - 0 Indonesia Sub 19Indonesia ...
08 Sep 20 Arabia Saudí Sub 19Arabia 2 - 3 Bulgaria Sub 19Bulgaria ...
08 Sep 20 Croacia Sub 19Croacia 7 - 1 Indonesia Sub 19Indonesia ...
11 Sep 20 Arabia Saudí Sub 19Arabia 3 - 3 Indonesia Sub 19Indonesia ...
17 Sep 20 Indonesia Sub 19Indonesia 2 - 1 Catar Sub 19Catar ...
20 Sep 20 Catar Sub 19Catar 1 - 1 Indonesia Sub 19Indonesia ...
25 Sep 20 Indonesia Sub 19Indonesia 0 - 1 Bosnia Sub 19Bosnia ...
27 Sep 20 Bosnia Sub 19Bosnia 1 - 1 Catar Sub 19Catar ...
Ver jornada
Jornada 7
13 Oct 20 Eslovaquia Sub 19Eslovaquia Apl Finlandia Sub 19Finlandia ...
06 Oct 20 Croacia Sub 19Croacia 7 - 0 Catar Sub 19Catar ...
08 Oct 20 Polonia Sub 19Polonia 1 - 3 Dinamarca Sub 19Dinamarca ...
08 Oct 20 Inglaterra Sub 19Inglaterra Apl Escocia Sub 19Escocia ...
08 Oct 20 Alemania Sub 19Alemania Apl Francia Sub 19Francia 1
11 Oct 20 Escocia Sub 19Escocia Apl Inglaterra Sub 19Inglaterra ...
12 Oct 20 Dinamarca Sub 19Dinamarca Apl Polonia Sub 19Polonia 1
12 Oct 20 Francia Sub 19Francia Apl Alemania Sub 19Alemania 1
08 Oct 20 Croacia Sub 19Croacia 3 - 3 Eslovenia Sub 19Eslovenia ...
12 Oct 20 Turquia Sub 19Turquia 1 - 2 Bulgaria Sub 19Bulgaria ...
10 Oct 20 Finlandia Sub 19Finlandia Apl Eslovaquia Sub 19Eslovaquia ...
11 Oct 20 Indonesia Sub 19Indonesia 4 - 1 Macedonia del Norte Sub 19Macedonia ...
14 Oct 20 Macedonia del Norte Sub 19Macedonia 0 - 0 Indonesia Sub 19Indonesia ...
13 Oct 20 Bulgaria Sub 19Bulgaria 0 - 1 Turquia Sub 19Turquia ...
Ver jornada
Jornada 8
10 Nov 20 Macedonia del Norte Sub 19Macedonia 0 - 1 Montenegro Sub 19Montenegro ...
12 Nov 20 Montenegro Sub 19Montenegro 1 - 1 Macedonia del Norte Sub 19Macedonia ...
15 Nov 20 Catar Sub 19Catar 5 - 1 Iraq Sub 19Iraq ...
12 Nov 20 Iraq Sub 19Iraq 0 - 0 Catar Sub 19Catar ...
17 Nov 20 Alemania Sub 19Alemania Apl Dinamarca Sub 19Dinamarca ...

  USO DE MEMORIA  
4,681,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0896
Total Execution Time  0.0914
  CADENA URL  
/amistosos_selecciones_sub192020/grupo1/calendario
  GET DATOS  
$_GET['/amistosos_selecciones_sub192020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub192020'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1987 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1987 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1303006,1303000,1216930,1203334,1196364) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1987 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1987 GROUP BY l.categoryId
0.0019  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=1987 GROUP BY l.year ORDER BY l.year DESC
0.0022  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 = 53727 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 53727 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 03:15:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 03:15:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 03:15:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 03:15:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2020
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (53727) 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, e.player_id ASC LIMIT 10
0.0023  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (53727) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (363865,454358,891242,468311,875520,435101,450315,459709,468316,468322) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2020
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (53727) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (53727) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (921614,987023,966726,987009,987021,369036,388176,406918,427208,430825) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2020
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (53727) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (53727) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (430604,921614,966726) ORDER BY rp.in_squad = 1 DESC