Benchmark
Fri, Mar 7 10:18:43


601.2 ms PHP Time
- Base: 473 us
- Controller: 600.7 ms
* SQL: 523.9 ms
* Rest: 76.8 ms

818.55 kb Memory Usage
- PHP Load: 427.5 kb
- Base: 19.58 kb
- Controller: 362.41 kb

2.56 mb Max Memory Usage

Config

DB ON
MEMCACHE ON
CORTES OFF
RENEW_MEM OFF
DEVELOP OFF
CONTENT NOT IN MEMCACHE
Included Files


Deprecated: Automatic conversion of false to array is deprecated in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/views/benchmark.php on line 317

Deprecated: Automatic conversion of false to array is deprecated in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/views/benchmark.php on line 318
1%11.22 kb/var/www/rf-desktop/rf/resultados-futbol/besoccer/index.php
1%7.83 kb/var/www/rf-desktop/rf/resultados-futbol/besoccer/system/application/config/routes_static.php
0%5.59 kbindex.php
35%434.32 kbkint.phar
0%1.71 kbphar://kint.phar/init_phar.php
0%2.73 kbphar://kint.phar/init.php
2%22.07 kbphar://kint.phar/src/Kint.php
0%1.77 kbphar://kint.phar/src/FacadeInterface.php
1%9.02 kbphar://kint.phar/src/Utils.php
0%2.54 kbphar://kint.phar/init_helpers.php
2%19.45 kbphar://kint.phar/src/Renderer/RichRenderer.php
0%4.87 kbphar://kint.phar/src/Renderer/AbstractRenderer.php
0%1.85 kbphar://kint.phar/src/Renderer/RendererInterface.php
0%3.29 kbapplication/config/pre_config.php
0%1.79 kbapplication/config/section_routes.php
1%16.85 kbapplication/config/config.php
0%37 b/var/www/rf-desktop/rf/resultados-futbol/besoccer/system/application/config/numcache.txt
0%969 bapplication/config/config_db.php
0%1.83 kb/var/www/rf-desktop/config_db_slave.php
1%6.69 kbsystem/db.php
1%6.73 kbsystem/dbm.php
0%1018 bsystem/view.php
0%1.2 kbsystem/controller.php
0%256 bsystem/model.php
0%5.53 kbsystem/router.php
0%1.88 kbsystem/phponrf.php
0%354 bapplication/config/routes.php
1%9.11 kbapplication/config/routes_file.php
2%25.33 kbapplication/controllers/match_controller.php
0%1.69 kbapplication/helpers/convert_helper.php
0%1.62 kbapplication/helpers/lang_helper.php
1%12.87 kbapplication/helpers/date_helper.php
1%7.14 kbapplication/helpers/render_helper.php
1%12.79 kbapplication/helpers/url_helper.php
0%1.29 kbapplication/helpers/string_helper.php
1%17.07 kbapplication/helpers/news_helper.php
0%4.09 kbapplication/helpers/common_helper.php
1%16.73 kbapplication/helpers/utils_helper.php
4%53.1 kbapplication/lib/lib.php
4%44.42 kbapplication/models/news_model.php
3%40.73 kbapplication/models/match_model.php
4%43.68 kbapplication/models/league_model.php
0%2.65 kbapplication/models/stats_model.php
2%23.23 kbapplication/models/result_model.php
5%67.7 kbapplication/models/ncomment_model.php
1%9.21 kbapplication/models/bs_news_model.php
5%62.68 kbapplication/req/pronosticos_match_preview.php
3%33.06 kbapplication/req/match.php
1%17.69 kbapplication/req/team.php
1%13.51 kbapplication/req/live.php
0%3.1 kbapplication/mods/exec_mods.php
0%2.39 kbapplication/mods/common/menu.php
1%10.36 kbapplication/models/common_model.php
1%15.79 kbapplication/mods/common/menu/menu_static_content.php
1%10.99 kbapplication/mods/common/menu/menu_mini_header.php
0%1.72 kbapplication/mods/common/menu/menu_data.php
1%6.32 kbapplication/mods/common/menu/menu_min_leagues.php
1%7.62 kbapplication/mods/common/menu/menu_esp_navbar.php
0%5.27 kbapplication/mods/common/menu/menu_mobile.php
0%760 bapplication/mods/match/breadcrumbs.php
2%21.68 kbapplication/mods/match/match_header.php
0%2.55 kbapplication/mods/match/match_menu.php
1%14.85 kbapplication/mods/match/match_info.php
0%3.32 kbapplication/mods/match/match_news.php
0%3.71 kbapplication/mods/match/match_other.php
0%1.32 kbapplication/mods/match/match_table.php
0%975 bapplication/mods/match/match_teams.php
1%12.97 kbapplication/views/common/header_view.php
0%4.08 kbapplication/views/common/quantcast/cfv3.php
0%4.93 kbapplication/mods/home/banner_cookies.php
0%197 bapplication/views/common/menu_view.php
0%124 bapplication/views/common/main_view_fw.php
0%161 bapplication/views/common/main_view.php
0%191 bapplication/views/common/sidebar_view.php
1%7.38 kbapplication/views/common/footer_view.php
1.21 mbTotal
SQL Queries (164)

Connection to sql... 8.9 ms

SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2, l.categoryId FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id INNER JOIN leagues AS l ON l.id = c.league_id AND dt1.basealias = 'Sparta-Sub23' AND dt2.basealias = 'Almere-City-Sub23' ORDER BY c.shedule DESC
1 8.2 ms controllers/news.php

SELECT c.team1, c.team2, c.round, c.shedule, c.league_id, c.team1_name AS local_name, c.team2_name AS visitor_name, c.referee, c.datateam1, c.datateam2, cat.name AS competition_name FROM futbol.calendars2025 AS c INNER JOIN futbol.leagues AS l ON l.id = c.league_id INNER JOIN futbol.categories AS cat ON cat.id = l.categoryId WHERE c.id = 35510;
2 2 ms controllers/news.php

SELECT c.id, c.league_id, c.date,c.rating1,c.rating2 FROM calendars_elo c WHERE c.id = 35510 AND c.year = 2025
3 1.9 ms controllers/news.php

SELECT c.r1,c.r2, c.id, l.categoryId,c.shedule,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2, c.datateam1, c.datateam2, c.round, c.league_id FROM calendars2025 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 INNER JOIN leagues l ON l.id = c.league_id WHERE c.id = 35510
4 1.9 ms controllers/news.php

SELECT date,rating1,rating2,datateam1,datateam2 FROM calendars_elo WHERE date > NOW()-INTERVAL 1 YEAR AND date < NOW() AND (datateam1 = 61522 OR datateam2 = 61522) ORDER BY date DESC LIMIT 1
5 2.5 ms controllers/news.php

SELECT date,rating1,rating2,datateam1,datateam2 FROM calendars_elo WHERE date > NOW()-INTERVAL 1 YEAR AND date < NOW() AND (datateam1 = 61521 OR datateam2 = 61521) ORDER BY date DESC LIMIT 1
6 2.2 ms controllers/news.php

SELECT id,r1,r2,expected,date FROM calendars_elo WHERE date >= '2025-05-24' - INTERVAL 1 YEAR AND date < '2025-05-24' AND datateam1 = 61522 AND r1 < 90 AND r2 < 90 ORDER BY date DESC LIMIT 20
7 2.1 ms controllers/news.php

SELECT id,r1,r2,expected,date FROM calendars_elo WHERE date >= '2025-05-24' - INTERVAL 1 YEAR AND date < '2025-05-24' AND datateam2 = 61521 AND r1 < 90 AND r2 < 90 ORDER BY date DESC LIMIT 20
8 2 ms controllers/news.php

SELECT c.id, c.shedule AS shedule, ct.ctype, ct.cat, l.id as league_id,l.current_table_round, l.playoff,c.team1,c.team2,l.year FROM calendars2025 AS c INNER JOIN leagues_besoccer AS l ON c.league_id = l.id INNER JOIN categories_besoccer AS ct ON ct.id = l.categoryId WHERE c.id = 35510
9 2 ms controllers/news.php

SELECT c.id, c.datateam1, c.datateam2, c.team1, c.team2, c.r1, c.r2, c.round, c.year, c.shedule AS shedule, c.league_id, c.comments,dt.basealias as basealias1,dt2.basealias as basealias2,dt.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars_editor c INNER JOIN datateams dt on dt.id=c.datateam1 INNER JOIN datateams dt2 on dt2.id=c.datateam2 WHERE ((c.datateam1=61522 AND c.datateam2= 61521) OR (c.datateam1= 61521 AND c.datateam2=61522)) AND c.shedule < '2025-03-07 10:18:43' AND c.year >= 1991 AND c.r1 <98 AND c.r2<98 AND c.id!=35510 ORDER BY c.shedule DESC
10 2.5 ms controllers/news.php

SELECT l.id AS league_id, ct.id AS category_id, ct.name as name, l.year, ct.coefficient, l.group_code, l.total_group, l.total_rounds, l.playoff, ct.logo FROM leagues_mobile AS l INNER JOIN categories_mobile AS ct ON l.categoryId=ct.id WHERE l.id IN (76755,72649,44341,16023,9455,49668)
11 2.1 ms controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (61521,61522)
12 1.9 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1=61522 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
13 2 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam2=61522 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
14 2 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1= 61521 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
15 2 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam2= 61521 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
16 1.9 ms controllers/news.php

SELECT c.id, c.datateam1, c.datateam2, c.team1, c.team2, c.r1, c.r2, c.round, c.shedule AS shedule, c.league_id, c.prorroga, c.penaltis1, c.penaltis2, c.status, c.minute, c.finished, c.comments,dt.basealias as basealias1,dt2.basealias as basealias2,dt.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars2025 c INNER JOIN datateams dt on dt.id=c.datateam1 INNER JOIN datateams dt2 on dt2.id=c.datateam2 WHERE c.id IN (35425,35410,35399,35391,35385,35374,35423,35409,35407,35397,35386,35379) ORDER BY c.shedule DESC
17 2.1 ms controllers/news.php

SELECT l.id AS league_id, ct.id AS category_id, ct.name as name, l.year, ct.coefficient, l.group_code, l.total_group, l.total_rounds, l.playoff, ct.logo FROM leagues_mobile AS l INNER JOIN categories_mobile AS ct ON l.categoryId=ct.id WHERE l.id IN (76755)
18 1.9 ms controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (7207,61522,7167,61521,7125,7127,7150,7192,7173,7130,7158,7137,7168)
19 1.9 ms controllers/news.php

SELECT id, year, datateam1 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam1=61522 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
20 2 ms controllers/news.php

SELECT id, year, datateam2 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam2=61522 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
21 2 ms controllers/news.php

SELECT id, year, datateam1 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam1= 61521 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
22 1.9 ms controllers/news.php

SELECT id, year, datateam2 as datateamstreak, shedule AS shedule, r1, r2 FROM calendars_all WHERE datateam2= 61521 AND shedule <'2025-03-07 10:18:43' AND r1 < 90 AND r2 < 90 AND year = 2025 ORDER BY shedule DESC
23 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 1 AND team = 6650700
24 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 1 AND team = 6650707
25 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 2 AND team = 6650700
26 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 2 AND team = 6650707
27 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 3 AND team = 6650700
28 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 3 AND team = 6650707
29 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 4 AND team = 6650700
30 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 4 AND team = 6650707
31 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 5 AND team = 6650700
32 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 5 AND team = 6650707
33 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 6 AND team = 6650700
34 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 6 AND team = 6650707
35 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 7 AND team = 6650700
36 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 7 AND team = 6650707
37 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 8 AND team = 6650700
38 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 8 AND team = 6650707
39 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 9 AND team = 6650700
40 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 9 AND team = 6650707
41 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 10 AND team = 6650700
42 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 10 AND team = 6650707
43 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 11 AND team = 6650700
44 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 11 AND team = 6650707
45 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 12 AND team = 6650700
46 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 12 AND team = 6650707
47 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 13 AND team = 6650700
48 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 13 AND team = 6650707
49 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 14 AND team = 6650700
50 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 14 AND team = 6650707
51 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 15 AND team = 6650700
52 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 15 AND team = 6650707
53 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 16 AND team = 6650700
54 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 16 AND team = 6650707
55 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 17 AND team = 6650700
56 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 17 AND team = 6650707
57 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 18 AND team = 6650700
58 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 18 AND team = 6650707
59 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 19 AND team = 6650700
60 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 19 AND team = 6650707
61 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 20 AND team = 6650700
62 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 20 AND team = 6650707
63 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 21 AND team = 6650700
64 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 21 AND team = 6650707
65 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 22 AND team = 6650700
66 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 22 AND team = 6650707
67 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 23 AND team = 6650700
68 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 23 AND team = 6650707
69 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 24 AND team = 6650700
70 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 24 AND team = 6650707
71 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 25 AND team = 6650700
72 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 76755 AND round = 25 AND team = 6650707
73 1.8 ms controllers/news.php

SELECT c.r1, c.r2, c.team1_name, c.team2_name, c.datateam1, c.datateam2, c.shedule FROM futbol.calendars2025 AS c WHERE c.r1 < 98 AND (datateam1 = 61522 OR datateam2 = 61522) ORDER BY c.shedule DESC LIMIT 12;
74 2.2 ms controllers/news.php

SELECT c.r1, c.r2, c.team1_name, c.team2_name, c.datateam1, c.datateam2, c.shedule FROM futbol.calendars2025 AS c WHERE c.r1 < 98 AND (datateam1 = 61521 OR datateam2 = 61521) ORDER BY c.shedule DESC LIMIT 12;
75 2.2 ms controllers/news.php

SELECT team.teamId, t.points, t.gf, t.ga, t.win_h, t.draw_h, t.lose_h, t.win_a, t.draw_a, t.lose_a, t.position, dt.short_name FROM futbol.tables2025 AS t INNER JOIN futbol.teams AS team ON t.team = team.id INNER JOIN futbol.datateams AS dt ON dt.id = team.teamId WHERE t.team IN (6650700, 6650707) AND t.league_id = 76755 AND t.round = 34;
76 2.3 ms controllers/news.php

SELECT l.game,c.id,c.shedule AS sheduleBBDD, cat.name AS league_name,c.isLive, cat.alias, cat.id AS category_id, cat.logo, cat.cat, cat.level, cat.ctype, l.year, l.current_round,cat.active_year,c.datateam1,c.datateam2,c.round, c.extra_data, c.stadium AS stadium_id, CONVERT_TZ(c.shedule, 'Europe/Madrid', 'Europe/Madrid') AS shedule,CONVERT_TZ(c.shedule, 'Europe/Madrid', 'Europe/Madrid') AS sheduleb, CONVERT_TZ(NOW(), 'Europe/Madrid', 'Europe/Madrid') AS cur_date, dt1.seats, c.referee, c.league_id,c.attendance, c.team1, c.team2, c.r1, c.r2, l.group_code,l.total_group, c.last_comment, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.finished, c.minute, c.isDpstats, l.total_rounds, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.id AS dt1id, dt2.id AS dt2id, dt1.translate AS translate1, dt2.translate AS translate2, dt1.stadium, dt1.twitter AS team1_twitter, dt2.twitter AS team2_twitter, dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.chairman as chairman1,dt2.chairman as chairman2,dt1.typefield,dt1.seats,dt1.fans,dt1.yearBuilt,dt1.fax,dt1.phone,dt1.address,dt1.size, c.betId, c.betId_wh, c.betId_bwin, c.betId_marca, 0 AS comments, IF(TIME(c.shedule)='00:00:00',1,0) AS no_hour , c.weather, c.temperature, dp1.nick as local_coach, dp2.nick as visitor_coach, cat.alerts_available AS alerts_available, c.isVideo, c.isLineup, c.acta, c.csb, cat.top, dt1.CountryCode as cc1, dt2.CountryCode as cc2 FROM calendars2025 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams_basics dtb1 ON dt1.id = dtb1.id INNER JOIN datateams dt2 ON dt2.id = c.datateam2 INNER JOIN datateams_basics dtb2 ON dt2.id = dtb2.id LEFT JOIN datapeople AS dp1 ON c.coach1 = dp1.id LEFT JOIN datapeople AS dp2 ON c.coach2 = dp2.id WHERE c.id = 35510
77 2.5 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e34ebc2143fce3bf838c9d9091521114'
78 2 ms controllers/news.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 61522 AND active = 1
79 4.1 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650700 AND type = 33 ORDER BY groupId ASC, type
80 1.9 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650707 AND type = 33 ORDER BY groupId ASC, type
81 1.8 ms controllers/news.php

SELECT rel.media_id, m.name, m.id FROM rel_media_match as rel INNER JOIN media AS m ON rel.media_id = m.id WHERE m.type=10 AND rel.cid = 35510 AND rel.year = 2025 AND rel.media_id < 90000 AND m.location='es' GROUP BY rel.media_id
82 2.3 ms controllers/news.php

SELECT * FROM calendars2025_times WHERE id = 35510
83 1.9 ms controllers/news.php

SELECT dp.id, dp.birthplace, dp.nick,dp.name,dp.last_name,dp.alias,dp.birthdate,dp.height,dp.weight,dp.foot,dp.side, dp.role, 2025 AS year, rp.squadNumber,'' as num,'' as pos,'' as idplayer,'' as goals,'' as reds,'' as yellows,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode, '' as gender FROM futbol.rel_players as rp INNER JOIN futbol.dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.year=2025 and rp.team_id=6650700 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
84 3.1 ms controllers/news.php

SELECT dp.id, dp.birthplace, dp.nick,dp.name,dp.last_name,dp.alias,dp.birthdate,dp.height,dp.weight,dp.foot,dp.side, dp.role, 2025 AS year, rp.squadNumber,'' as num,'' as pos,'' as idplayer,'' as goals,'' as reds,'' as yellows,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode, '' as gender FROM futbol.rel_players as rp INNER JOIN futbol.dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.year=2025 and rp.team_id=6650707 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
85 2.5 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76755 AND teamId=6650700 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
86 1.8 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76755 AND teamId=6650707 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
87 1.8 ms controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2025 WHERE league_id=76755 AND extra_data IS NOT NULL AND (team1=6650700 OR team2=6650700) ORDER BY round ASC
88 2.2 ms controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2025 WHERE league_id=76755 AND extra_data IS NOT NULL AND (team1=6650707 OR team2=6650707) ORDER BY round ASC
89 2.1 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='331715d18c12d88e52ca894ec0905117'
90 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='aeccc29e9af073cb8018173cdb889fb3'
91 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='d25ea7259e1c989a118a00450fe74ae7'
92 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='cfdbcc33fe4236534bfcf4b1cb55d8ed'
93 2.1 ms controllers/news.php

SELECT dt.id,dt.nameShow,dt.translate,dt.basealias, t.points, t.gf, t.ga, t.win_h+t.win_a as wins, t.draw_h+t.draw_a as draws, t.lose_h+t.lose_a as loses, (t.win_h+t.win_a+t.draw_h+t.draw_a+t.lose_h+t.lose_a) AS mp,(cast(t.gf as signed) - cast(t.ga as signed)) AS diff,team.teamId FROM tables2025 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 = 76755 AND t.round = 34 ORDER BY t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
94 2.4 ms controllers/news.php

SELECT t.team,t.round,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff FROM tables2025 AS t WHERE t.league_id = 76755 AND t.round<=34 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
95 3.4 ms controllers/news.php

SELECT dr.id, dr.fullname as name, dr.nick as showName,rc.role, dr.birthdate,dr.birthplace FROM rel_calendars_referee rc LEFT JOIN datapeople dr ON dr.id=rc.referee_id WHERE rc.match_id=35510 AND rc.year=2025
96 2 ms controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2025 AS ev WHERE ev.match_id=35510 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
97 2 ms controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 76755 AND id_match = 35510
98 2.1 ms controllers/news.php

SELECT c.id, c.r1, c.r2, c.shedule, l.year FROM calendars_all AS c INNER JOIN futbol.leagues AS l ON c.league_id=l.id INNER JOIN teams AS t1 ON c.team1=t1.id INNER JOIN teams AS t2 ON c.team2=t2.id WHERE l.categoryId=1892 AND t1.teamId=61522 AND t2.teamId=61521 AND r1 < 99 AND c.shedule < NOW() - INTERVAL 1 DAY ORDER BY c.shedule DESC LIMIT 10
99 2.8 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 35510 AND year = 2025
100 1.9 ms controllers/news.php

SELECT dt.*,cou.Name as Name,cou.Continent as Continent,cou.Region,dp.latitude,dp.longitude,dp.name as geo_location, ds.header_color as color1 FROM datateams AS dt LEFT JOIN country AS cou ON LOWER(cou.Code2) = dt.CountryCode LEFT JOIN dataplaces dp on dp.geonameid=dt.geonameid LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE dt.id=61522 LIMIT 1
101 89.9 ms controllers/news.php

SELECT dp.id, 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=61522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
102 1.9 ms controllers/news.php

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=61522 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
103 1.8 ms controllers/news.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 61522 AND active = 1
104 3 ms controllers/news.php

SELECT c.troncal, t.conference, c.id AS category_id, t.id as team_id,t.league_id,c.name as cat_name, c.name_english as cat_name_en,l.year,l.tables,l.current_round,l.group_code,l.total_group,c.active_year,c.alias, l.table_suffix, c.logo as league_logo FROM teams AS t INNER JOIN leagues_besoccer l ON l.id = t.league_id INNER JOIN categories_besoccer c ON c.id = l.categoryId WHERE t.teamId = 61522 AND c.ctype != 12 ORDER BY c.troncal DESC, l.year DESC, l.end_prev ASC, c.parentId ASC, c.coefficient DESC, l.group_code = 0 ASC, l.group_code ASC LIMIT 2
105 2.4 ms controllers/news.php

SELECT ct.id FROM categories_besoccer AS ct INNER JOIN leagues_besoccer 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=61522 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
106 2.1 ms controllers/news.php

SELECT ct.id, ct.alias, ct.name AS name, ct.logo, ct.CountryCode, ct.active_year, ct.location, ct.continent, ct.competition_type, ct.troncal, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_teams, l.current_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.end_date, t.id as team_id, t.name as team_name FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams t on t.teamId=61522 and l.id=t.league_id WHERE ct.id IN (1892) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
107 2.1 ms controllers/news.php

SELECT dt.nameShow,(cast(tab.gf as signed) - cast(tab.ga as signed) + 100) as diff,tab.*,t.teamId FROM teams AS t INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN tables2025 as tab ON tab.league_id = t.league_id AND tab.team = t.id INNER JOIN datateams dt ON dt.id = t.teamId WHERE c.troncal = 1 AND t.league_id = 76755 AND tab.round = 25 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
108 2.4 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=61522 AND type_rel=2 AND ln='es'
109 1.9 ms controllers/news.php

SELECT rb.id FROM rel_budgets AS rb WHERE (rb.official_budget = 1 or rb.official_budget = 2 or rb.official_budget = 0) AND (rb.origin_team_id IN (61522) OR rb.destination_team_id IN (61522)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
110 2.1 ms controllers/news.php

SELECT ip.id as id, ip.datateamId, site_name as club,ip.json_data FROM club_projects.club_teams ct INNER JOIN club_projects.info_projects ip ON ip.id = ct.project_id WHERE ct.rel_datateamId=61522 LIMIT 1
111 1.9 ms controllers/news.php

SELECT dt.*,cou.Name as Name,cou.Continent as Continent,cou.Region,dp.latitude,dp.longitude,dp.name as geo_location, ds.header_color as color1 FROM datateams AS dt LEFT JOIN country AS cou ON LOWER(cou.Code2) = dt.CountryCode LEFT JOIN dataplaces dp on dp.geonameid=dt.geonameid LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE dt.id=61521 LIMIT 1
112 82.2 ms controllers/news.php

SELECT dp.id, 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=61521 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
113 1.9 ms controllers/news.php

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=61521 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
114 1.9 ms controllers/news.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 61521 AND active = 1
115 3.4 ms controllers/news.php

SELECT c.troncal, t.conference, c.id AS category_id, t.id as team_id,t.league_id,c.name as cat_name, c.name_english as cat_name_en,l.year,l.tables,l.current_round,l.group_code,l.total_group,c.active_year,c.alias, l.table_suffix, c.logo as league_logo FROM teams AS t INNER JOIN leagues_besoccer l ON l.id = t.league_id INNER JOIN categories_besoccer c ON c.id = l.categoryId WHERE t.teamId = 61521 AND c.ctype != 12 ORDER BY c.troncal DESC, l.year DESC, l.end_prev ASC, c.parentId ASC, c.coefficient DESC, l.group_code = 0 ASC, l.group_code ASC LIMIT 2
116 2.5 ms controllers/news.php

SELECT ct.id FROM categories_besoccer AS ct INNER JOIN leagues_besoccer 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=61521 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
117 2.4 ms controllers/news.php

SELECT ct.id, ct.alias, ct.name AS name, ct.logo, ct.CountryCode, ct.active_year, ct.location, ct.continent, ct.competition_type, ct.troncal, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_teams, l.current_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.end_date, t.id as team_id, t.name as team_name FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams t on t.teamId=61521 and l.id=t.league_id WHERE ct.id IN (1892) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
118 2.4 ms controllers/news.php

SELECT dt.nameShow,(cast(tab.gf as signed) - cast(tab.ga as signed) + 100) as diff,tab.*,t.teamId FROM teams AS t INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN tables2025 as tab ON tab.league_id = t.league_id AND tab.team = t.id INNER JOIN datateams dt ON dt.id = t.teamId WHERE c.troncal = 1 AND t.league_id = 76755 AND tab.round = 25 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
119 2.9 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=61521 AND type_rel=2 AND ln='es'
120 2 ms controllers/news.php

SELECT rb.id FROM rel_budgets AS rb WHERE (rb.official_budget = 1 or rb.official_budget = 2 or rb.official_budget = 0) AND (rb.origin_team_id IN (61521) OR rb.destination_team_id IN (61521)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
121 2.6 ms controllers/news.php

SELECT ip.id as id, ip.datateamId, site_name as club,ip.json_data FROM club_projects.club_teams ct INNER JOIN club_projects.info_projects ip ON ip.id = ct.project_id WHERE ct.rel_datateamId=61521 LIMIT 1
122 2 ms controllers/news.php

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 = 76755
123 3.4 ms controllers/news.php

SELECT SQL_NO_CACHE ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=35510 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13 OR ev.action=25) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
124 2 ms controllers/news.php

SELECT SQL_NO_CACHE ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=35510 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
125 1.9 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650700 and type = 33
126 1.9 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650707 and type = 33
127 1.8 ms controllers/news.php

SELECT rating1, rating2 FROM calendars_elo WHERE id=35510 AND league_id=76755 AND year=2025
128 1.9 ms controllers/news.php

SELECT position FROM tables2025 WHERE team=6650700 AND league_id=76755 AND round=34
129 1.9 ms controllers/news.php

SELECT position FROM tables2025 WHERE team=6650707 AND league_id=76755 AND round=34
130 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
131 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
132 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
133 2 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
134 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
135 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
136 1.9 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e34ebc2143fce3bf838c9d9091521114'
137 2 ms controllers/news.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 61522 AND active = 1
138 4.4 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650700 AND type = 33 ORDER BY groupId ASC, type
139 1.9 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 76755 AND teamId = 6650707 AND type = 33 ORDER BY groupId ASC, type
140 1.9 ms controllers/news.php

SELECT * FROM calendars2025_times WHERE id = 35510
141 2 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76755 AND teamId=6650700 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
142 1.9 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=76755 AND teamId=6650707 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
143 1.9 ms controllers/news.php

SELECT dr.id, dr.fullname as name, dr.nick as showName,rc.role, dr.birthdate,dr.birthplace FROM rel_calendars_referee rc LEFT JOIN datapeople dr ON dr.id=rc.referee_id WHERE rc.match_id=35510 AND rc.year=2025
144 1.9 ms controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2025 AS ev WHERE ev.match_id=35510 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
145 2 ms controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 76755 AND id_match = 35510
146 2.2 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 35510 AND year = 2025
147 2 ms controllers/news.php

SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 76755 AND rel.team1 = 6650700 AND rel.team2 = 6650707 ORDER BY FIELD(m.location,'es','en') DESC
148 2.5 ms controllers/news.php

SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 76755 AND id_match = 35510
149 2 ms controllers/news.php

SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='76755' AND relp.team_id=6650700 WHERE mp.`match_id` = '35510' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
150 7.2 ms controllers/news.php

SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='76755' AND relp.team_id=6650707 WHERE mp.`match_id` = '35510' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
151 5.2 ms controllers/news.php

SELECT rl.* FROM futbol.rel_live_commentaries AS rl WHERE rl.match_id = 35510 AND rl.year = 2025 AND rl.active = 1 AND rl.ln = 'es';
152 1.9 ms controllers/news.php

SELECT * FROM futbol.live_commentaries2025 WHERE match_id = 35510 AND ln = 'es' AND type = 1 AND owner = '1' ORDER BY minute DESC, creation_date DESC, id DESC;
153 1.9 ms controllers/news.php

SELECT * FROM futbol.live_commentaries2025 WHERE match_id = 35510 AND ln = 'es' AND type = 1 AND owner = 1 ORDER BY minute DESC, extra_minute DESC, creation_date DESC, id DESC;
154 2 ms controllers/news.php

SELECT * FROM calendars2025 AS c WHERE c.id=35510
155 2 ms controllers/news.php

SELECT * FROM events2025 AS e WHERE e.match_id=35510 ORDER BY minute DESC
156 2 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=35510 AND extraId = 76755 AND type_rel = 4
157 1.9 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1892 AND type_rel = 3
158 2 ms controllers/news.php

SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1892 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
159 2.4 ms controllers/news.php

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 (1329443,1220698,1207759,1075606,936469) ORDER BY n.cover_points DESC, update_date DESC
160 2.6 ms controllers/news.php

SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, c.minute, c.status, c.penaltis1, c.penaltis2, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2025` 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` = 76755 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 12
161 2.8 ms controllers/news.php

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 `tables2025` 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 = 76755 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
162 2.7 ms controllers/news.php

SELECT t.points,t.team,t.round FROM `tables2025` 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 = 76755 AND t.round >= 10 AND t.round <= 25 ORDER BY t.round ASC, t.points DESC, t.ga DESC, dt.nameShow ASC
163 6.4 ms controllers/news.php

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 = 76755 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
164 2.1 ms controllers/news.php

TOTAL TIME 523.9 ms QUERIES 164 FILE controllers/news.php

HTML

There is no HTML
Headers Sent

POST

There is no data POST
Memcache


Warning: Undefined array key "version" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 7

Warning: Undefined array key "pid" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 8

Warning: Undefined array key "uptime" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 9

Warning: Undefined array key "rusage_user" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 10

Warning: Undefined array key "rusage_system" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 11

Warning: Undefined array key "total_items" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 12

Warning: Undefined array key "curr_connections" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 13

Warning: Undefined array key "total_connections" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 14

Warning: Undefined array key "connection_structures" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 15

Warning: Undefined array key "cmd_get" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 16

Warning: Undefined array key "cmd_set" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 17

Warning: Undefined array key "get_hits" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 19

Warning: Undefined array key "cmd_get" in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 19

Fatal error: Uncaught DivisionByZeroError: Division by zero in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php:19 Stack trace: #0 /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/views/benchmark.php(519): printDetails() #1 /var/www/rf-desktop/rf/resultados-futbol/rfutbol/system/view.php(38): require('...') #2 /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/controllers/benchmark.php(30): View->render() #3 /var/www/rf-desktop/rf/resultados-futbol/rfutbol/system/phponrf.php(46): Benchmark->index() #4 /var/www/rf-desktop/rf/resultados-futbol/rfutbol/index.php(184): phponrf() #5 /var/www/rf-desktop/rf/resultados-futbol/besoccer/index.php(200): require_once('...') #6 {main} thrown in /var/www/rf-desktop/rf/resultados-futbol/rfutbol/application/helpers/benchmark_helper.php on line 19
Memcache Server version:
Process id of this server process
Number of seconds this server has been running
Accumulated user time for this process seconds
Accumulated system time for this process seconds
Total number of items stored by this server ever since it started
Number of open connections
Total number of connections opened since the server started running
Number of connection structures allocated by the server
Cumulative number of retrieval requests
Cumulative number of storage requests