Benchmark
Fri, Mar 7 10:09:37

634.7 ms PHP Time
- Base: 404 us
- Controller: 634.3 ms
* SQL: 567 ms
* Rest: 67.2 ms

825.27 kb Memory Usage
- PHP Load: 427.39 kb
- Base: 19.56 kb
- Controller: 369.25 kb

1.67 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 (159)

Connection to sql... 9.2 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 = 'Club-Bermeo' AND dt2.basealias = 'Getxo' ORDER BY c.shedule DESC
1 11.1 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 = 119591;
2 1.9 ms controllers/news.php

SELECT c.id, c.league_id, c.date,c.rating1,c.rating2 FROM calendars_elo c WHERE c.id = 119591 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 = 119591
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 = 4710 OR datateam2 = 4710) ORDER BY date DESC LIMIT 1
5 3.4 ms controllers/news.php

SELECT date,rating1,rating2,datateam1,datateam2 FROM calendars_elo WHERE date > NOW()-INTERVAL 1 YEAR AND date < NOW() AND (datateam1 = 1220 OR datateam2 = 1220) ORDER BY date DESC LIMIT 1
6 133.8 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 = 119591
7 2.1 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=4710 AND c.datateam2= 1220) OR (c.datateam1= 1220 AND c.datateam2=4710)) AND c.shedule < '2025-03-07 10:09:37' AND c.year >= 1991 AND c.r1 <98 AND c.r2<98 AND c.id!=119591 ORDER BY c.shedule DESC
8 3.6 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 (77226,73549,68809,60094,51264,39028,33354,15445,1952,1455,1134,849,289,21883,21860,21838)
9 2.2 ms controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (1220,4710)
10 1.9 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1=4710 AND shedule <'2025-03-07 10:09:37' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
11 2.1 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam2=4710 AND shedule <'2025-03-07 10:09:37' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
12 2.1 ms controllers/news.php

SELECT id, year, shedule AS shedule FROM calendars_all WHERE datateam1= 1220 AND shedule <'2025-03-07 10:09:37' 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= 1220 AND shedule <'2025-03-07 10:09:37' AND r1 < 90 AND r2 < 90 ORDER BY shedule DESC LIMIT 5
14 2 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 (119515,119505,119496,119486,119477,119467,119518,119470,119508,119499,119489,119480) ORDER BY c.shedule DESC
15 2.2 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 (77226)
16 2 ms controllers/news.php

SELECT id, nameShow, translate AS team_translate, short_name, basealias FROM datateams WHERE id IN (4710,9464,1220,419,2358,1194,85238,19952,1428,2273,2788)
17 1.9 ms controllers/news.php

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

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

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

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

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 1 AND team = 6659644
22 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 1 AND team = 6659643
23 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 2 AND team = 6659644
24 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 2 AND team = 6659643
25 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 3 AND team = 6659644
26 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 3 AND team = 6659643
27 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 4 AND team = 6659644
28 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 4 AND team = 6659643
29 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 5 AND team = 6659644
30 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 5 AND team = 6659643
31 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 6 AND team = 6659644
32 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 6 AND team = 6659643
33 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 7 AND team = 6659644
34 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 7 AND team = 6659643
35 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 8 AND team = 6659644
36 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 8 AND team = 6659643
37 1.7 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 9 AND team = 6659644
38 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 9 AND team = 6659643
39 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 10 AND team = 6659644
40 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 10 AND team = 6659643
41 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 11 AND team = 6659644
42 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 11 AND team = 6659643
43 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 12 AND team = 6659644
44 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 12 AND team = 6659643
45 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 13 AND team = 6659644
46 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 13 AND team = 6659643
47 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 14 AND team = 6659644
48 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 14 AND team = 6659643
49 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 15 AND team = 6659644
50 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 15 AND team = 6659643
51 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 16 AND team = 6659644
52 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 16 AND team = 6659643
53 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 17 AND team = 6659644
54 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 17 AND team = 6659643
55 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 18 AND team = 6659644
56 2 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 18 AND team = 6659643
57 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 19 AND team = 6659644
58 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 19 AND team = 6659643
59 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 20 AND team = 6659644
60 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 20 AND team = 6659643
61 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 21 AND team = 6659644
62 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 21 AND team = 6659643
63 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 22 AND team = 6659644
64 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 22 AND team = 6659643
65 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 23 AND team = 6659644
66 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 23 AND team = 6659643
67 1.8 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 24 AND team = 6659644
68 1.9 ms controllers/news.php

SELECT position FROM futbol.tables2025 WHERE league_id = 77226 AND round = 24 AND team = 6659643
69 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 = 4710 OR datateam2 = 4710) ORDER BY c.shedule DESC LIMIT 12;
70 2.1 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 = 1220 OR datateam2 = 1220) ORDER BY c.shedule DESC LIMIT 12;
71 2.1 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 (6659644, 6659643) AND t.league_id = 77226 AND t.round = 31;
72 2.1 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 = 119591
73 2.6 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e34ebc2143fce3bf838c9d9091521114'
74 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 = 4710 AND active = 1
75 4 ms controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='3165471793ef5bc01c33c8eee8de4aca'
76 1.9 ms controllers/news.php

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

SELECT data1 FROM stats2025 t WHERE league_id = 77226 AND teamId = 6659643 AND type = 33 ORDER BY groupId ASC, type
78 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 = 119591 AND rel.year = 2025 AND rel.media_id < 90000 AND m.location='es' GROUP BY rel.media_id
79 2.3 ms controllers/news.php

SELECT * FROM calendars2025_times WHERE id = 119591
80 1.8 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=6659644 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
81 2 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=6659643 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
82 2.1 ms controllers/news.php

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

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

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

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2025 WHERE league_id=77226 AND extra_data IS NOT NULL AND (team1=6659643 OR team2=6659643) ORDER BY round ASC
86 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 = 77226 AND t.round = 31 ORDER BY t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
87 2.9 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 = 77226 AND t.round<=31 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
88 3.5 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=119591 AND rc.year=2025
89 1.8 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=119591 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
90 1.8 ms controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 77226 AND id_match = 119591
91 1.9 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=74 AND t1.teamId=4710 AND t2.teamId=1220 AND r1 < 99 AND c.shedule < NOW() - INTERVAL 1 DAY ORDER BY c.shedule DESC LIMIT 10
92 2.7 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 119591 AND year = 2025
93 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=4710 LIMIT 1
94 11.7 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=4710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
95 2.1 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=4710 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
96 2 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 = 4710 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
97 2.9 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=4710 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
98 2.7 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=4710 and l.id=t.league_id WHERE ct.id IN (74) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
99 3.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 = 77226 AND tab.round = 24 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
100 2.8 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=6659644 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
101 2.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, 2024 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=2024 and rp.team_id=6659644 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
102 2.2 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=4710 AND type_rel=2 AND ln='es'
103 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 (4710) OR rb.destination_team_id IN (4710)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
104 2.4 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=4710 LIMIT 1
105 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=1220 LIMIT 1
106 85.5 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=1220 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
107 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=1220 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
108 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 = 1220 AND active = 1
109 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 = 1220 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
110 3.1 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=1220 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
111 2.9 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=1220 and l.id=t.league_id WHERE ct.id IN (74) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
112 2.9 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 = 77226 AND tab.round = 24 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
113 2.5 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=6659643 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
114 2.2 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, 2024 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=2024 and rp.team_id=6659643 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
115 2.2 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=1220 AND type_rel=2 AND ln='es'
116 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 (1220) OR rb.destination_team_id IN (1220)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
117 2.2 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=1220 LIMIT 1
118 1.8 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 = 77226
119 3.1 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=119591 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
120 1.9 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=119591 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
121 2 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 77226 AND teamId = 6659644 and type = 33
122 1.8 ms controllers/news.php

SELECT data1 FROM stats2025 t WHERE league_id = 77226 AND teamId = 6659643 and type = 33
123 1.8 ms controllers/news.php

SELECT rating1, rating2 FROM calendars_elo WHERE id=119591 AND league_id=77226 AND year=2025
124 1.9 ms controllers/news.php

SELECT position FROM tables2025 WHERE team=6659644 AND league_id=77226 AND round=31
125 1.9 ms controllers/news.php

SELECT position FROM tables2025 WHERE team=6659643 AND league_id=77226 AND round=31
126 1.9 ms controllers/news.php

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

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

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

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

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

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

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

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

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

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

SELECT * FROM calendars2025_times WHERE id = 119591
137 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=6659644 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
138 2.2 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=6659643 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
139 2.2 ms controllers/news.php

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

SELECT type, data1, data2, data3, data4 FROM stats2025 WHERE league_id=77226 AND teamId=6659643 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
141 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=119591 AND rc.year=2025
142 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=119591 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
143 1.9 ms controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 77226 AND id_match = 119591
144 2.1 ms controllers/news.php

SELECT * FROM forecast WHERE matchId = 119591 AND year = 2025
145 1.9 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 = 77226 AND rel.team1 = 6659644 AND rel.team2 = 6659643 ORDER BY FIELD(m.location,'es','en') DESC
146 2.5 ms controllers/news.php

SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 77226 AND id_match = 119591
147 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='77226' AND relp.team_id=6659644 WHERE mp.`match_id` = '119591' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
148 2.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='77226' AND relp.team_id=6659643 WHERE mp.`match_id` = '119591' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
149 2.2 ms controllers/news.php

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

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

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

SELECT * FROM calendars2025 AS c WHERE c.id=119591
153 1.9 ms controllers/news.php

SELECT * FROM events2025 AS e WHERE e.match_id=119591 ORDER BY minute DESC
154 1.9 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119591 AND extraId = 77226 AND type_rel = 4
155 1.8 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=74 AND type_rel = 3
156 1.9 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` = 77226 AND c.`round` = 31 ORDER BY shedule ASC LIMIT 12
157 2.6 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 = 77226 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
158 2.5 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 = 77226 AND t.round >= 9 AND t.round <= 24 ORDER BY t.round ASC, t.points DESC, t.ga DESC, dt.nameShow ASC
159 5.8 ms controllers/news.php

TOTAL TIME 567 ms QUERIES 159 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