4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Lo más destacado de la jornada 4

Clasificación

Equipo PJ GF GC Puntos
1 Mirassol Sub 20 Mirassol 10 40 9 25
2 Rio Preto Sub 20 Preto 10 30 13 25
3 Tanabi SP Sub 20 Tanabi 10 20 14 18
4 Olímpia FC Sub 20 Olímpia 10 18 32 10
5 América SP Sub 20 América 10 15 27 6
6 Fernandópolis Sub 20 Fernandópol 10 8 36 3
7 José Bonifácio Sub 20 José 10 17 9 23
8 Aracatuba Sub 20 Aracatuba 10 17 5 20
9 Vocem Sub 20 Vocem 9 20 6 19
10 Bandeirante SP Sub 20 Bandeirante 9 12 13 11
11 Tupã Sub 20 Tupã 9 8 20 7
12 Santacruzense Sub 20 Santacruzens 9 4 25 0
13 Botafogo SP Sub 20 Botafogo 10 19 5 21
14 Comercial Sub 20 Comercial 10 14 10 18
15 CA Bandeirante Sub 20 Bandeirante 10 12 9 15
16 Inter de Bebedouro Sub 20 Inter 10 14 18 14
17 Batatais Sub 20 Batatais 10 8 16 7
18 Francana Sub 20 Francana 10 7 16 7
19 Ferroviária Sub 20 Ferroviária 9 27 2 27
20 Novorizontino Sub 20 Novorizontin 10 32 6 22
21 XV de Jaú Sub 20 Jaú 10 23 9 17
22 Monte Azul Sub 20 Monte Azul 10 18 21 13
23 Taquaritinga Sub 20 Taquaritinga 10 8 39 6
24 Catanduvense Sub 20 Catanduvense 9 3 34 0
25 Lemense Sub 20 Lemense 10 23 7 21
26 Inter Limeira Sub 20 Inter 10 23 11 21
27 Rio Claro SP Sub 20 Claro 10 24 8 17
28 Velo Clube Sub 20 Velo Clube 10 23 15 17
29 São Carlos Sub 20 São Carlos 10 20 31 7
30 União São João Sub 20 União São 10 5 46 1
31 Guarani Sub 20 Guarani 10 20 10 20
32 Capivariano Sub 20 Capivariano 10 31 14 18
33 Comercial de Tietê Sub 20 Comercial 10 13 11 15
34 Rio Branco EC Sub 20 Branco 10 18 22 12
35 XV de Piracicaba Sub 20 Piracicaba 10 11 16 11
36 Independente Limeira Sub 20 Independente 10 10 30 6
37 Ponte Preta Sub 20 Ponte Preta 10 15 7 22
38 Mogi Mirim Sub 20 Mogi Mirim 10 18 12 20
39 Itapirense Sub 20 Itapirense 10 16 9 16
40 Brasilis FC Sub 20 Brasilis 10 16 14 16
41 Guaçuano Sub 20 Guaçuano 10 10 22 8
42 Aguaí Sub 20 Aguaí 10 7 18 2
43 Desportivo Brasil Sub 20 Desportivo 10 32 11 28
44 Oeste Sub 20 Oeste 10 19 14 19
45 Ituano Sub 20 Ituano 10 14 10 19
46 São Bento Sub 20 São Bento 10 15 18 13
47 Sharjah Brasil Sub 20 Sharjah 10 13 19 9
48 Salto Sub 20 Salto 10 4 25 0
49 Ibrachina Sub 20 Ibrachina 10 28 2 27
50 Portuguesa Sub 20 Portuguesa 10 27 5 24
51 RB Bragantino Sub 20 Bragantino 10 35 8 18
52 Flamengo SP Sub 20 Flamengo 10 12 18 12
53 Guarulhos Sub 20 Guarulhos 10 5 32 6
54 Barcelona EC Sub 20 Barcelona 10 1 43 3
55 São Paulo Sub 20 São Paulo 10 25 6 24
56 CA Juventus Sub 20 Juventus 10 15 10 17
57 Osasco Audax Sub 20 Osasco Audax 10 13 10 17
58 SKA Brasil Sub 20 Brasil 10 9 12 17
59 Nacional SP Sub 20 Nacional 10 9 18 8
60 Grêmio Osasco Sub 20 Grêmio 10 4 19 0
61 Palmeiras Sub 20 Palmeiras 10 38 4 30
62 Taubaté Sub 20 Taubaté 10 27 11 19
63 São José EC Sub 20 São José 10 13 7 17
64 Atl. Guaratinguetá Sub 20 Atl. 10 10 13 12
65 Manthiqueira Sub 20 Manthiqueira 10 9 39 6
66 Joseense Sub 20 Joseense 10 5 28 2
67 Corinthians Sub 20 Corinthians 10 49 8 24
68 Água Santa Sub 20 Água Santa 10 24 5 24
69 São Caetano Sub 20 São Caetano 10 17 11 20
70 União Suzano AC Sub 20 União 10 10 20 10
71 União Mogi Sub 20 União Mogi 10 7 34 4
72 União Suzano SP Sub 20 União 10 10 39 3
73 Santos Sub 20 Santos 10 34 6 25
74 EC São Bernardo Sub 20 São 10 22 21 17
75 Jabaquara Sub 20 Jabaquara 10 18 20 13
76 Mauá Sub 20 Mauá 10 16 25 11
77 Mauaense Sub 20 Mauaense 10 9 18 10
78 Portuguesa Santista Sub 20 Portuguesa 10 12 21 9

  USO DE MEMORIA  
8,062,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2432
Total Execution Time  0.2452
  CADENA URL  
/paulista_sub202023/grupo1/resumen/4
  GET DATOS  
$_GET['/paulista_sub202023/grupo1/resumen/4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'paulista_sub202023'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paulista_sub20' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 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=2512 AND type_rel = 3
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2512 ORDER BY order_id ASC
0.0023  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 = 71384 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 `calendars2023` 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` = 71384 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 200
0.0077  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 `events2023` e INNER JOIN calendars2023 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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 71384 ORDER BY total DESC LIMIT 100
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:13:54' 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-04-27 14:13:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:13:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:13:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paulista_sub20' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2512 AND l.year = 2023
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71384,72241,73893,74385) 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.0042  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 (71384,72241,73893,74385) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (977608,982686,3371172,969728,937882,3401269,937918,3155934,3163229,3211604) ORDER BY rp.in_squad = 1 DESC
0.0025  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2512 AND l.year = 2023
0.0170  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71384,72241,73893,74385) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0036  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 (71384,72241,73893,74385) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (914021,982678,3234679,3402121,882976,987468,3157231,3226111,3272620,3292696) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2512 AND l.year = 2023
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71384,72241,73893,74385) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0043  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 (71384,72241,73893,74385) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (982772,3228220,3229399,3272563,3274688,3274772,3295812,3401343,842979,882976) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT *,(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 = 71384 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC