Benchmark
Fri, Mar 7 10:09:05


221.7 ms PHP Time
- Base: 338 us
- Controller: 221.4 ms
* SQL: 206.6 ms
* Rest: 14.8 ms

747.14 kb Memory Usage
- PHP Load: 427.67 kb
- Base: 19.58 kb
- Controller: 290.83 kb

1.24 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
37%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
5%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
6%67.7 kbapplication/models/ncomment_model.php
1%9.21 kbapplication/models/bs_news_model.php
3%33.06 kbapplication/req/match.php
2%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%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.15 mbTotal
SQL Queries (85)

Connection to sql... 770 us

SELECT c.*, c.stadium as real_stadium, 2023 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 calendars2023 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 = 'Chernolomets-04-Popovo' AND dt2.basealias = 'Yambol-1915' ORDER BY c.shedule DESC
1 4.6 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 calendars2023 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 = 340935
2 688 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
3 377 us 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 = 86677 AND active = 1
4 1.2 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536290 AND type = 33 ORDER BY groupId ASC, type
5 260 us controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536291 AND type = 33 ORDER BY groupId ASC, type
6 255 us 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 = 340935 AND rel.year = 2023 AND rel.media_id < 90000 AND m.location='es' GROUP BY rel.media_id
7 561 us controllers/news.php

SELECT * FROM calendars2023_times WHERE id = 340935
8 220 us 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, 2023 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=2023 and rp.team_id=6536290 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
9 491 us 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, 2023 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=2023 and rp.team_id=6536291 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 461 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=68483 AND teamId=6536290 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
11 274 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=68483 AND teamId=6536291 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
12 280 us controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2023 WHERE league_id=68483 AND extra_data IS NOT NULL AND (team1=6536290 OR team2=6536290) ORDER BY round ASC
13 409 us controllers/news.php

SELECT round, team1, team2, extra_data, r1, r2 FROM calendars2023 WHERE league_id=68483 AND extra_data IS NOT NULL AND (team1=6536291 OR team2=6536291) ORDER BY round ASC
14 378 us 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 = 68483 AND t.round<=4 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
15 259 us 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=340935 AND rc.year=2023
16 211 us controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2023 AS ev WHERE ev.match_id=340935 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
17 230 us controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 68483 AND id_match = 340935
18 292 us 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=854 AND t1.teamId=86677 AND t2.teamId=102465 AND r1 < 99 AND c.shedule < NOW() - INTERVAL 1 DAY ORDER BY c.shedule DESC LIMIT 10
19 867 us controllers/news.php

SELECT * FROM forecast WHERE matchId = 340935 AND year = 2023
20 180 us 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=86677 LIMIT 1
21 79.3 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=86677 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
22 295 us 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=86677 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
23 232 us 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 = 86677 AND active = 1
24 1.8 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 = 86677 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
25 1.2 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=86677 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
26 1.2 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=86677 and l.id=t.league_id WHERE ct.id IN (238,854) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
27 1.3 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 = 77615 AND tab.round = 18 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
28 1.3 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=6667289 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
29 797 us 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=6667289 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
30 819 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=86677 AND type_rel=2 AND ln='es'
31 231 us 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 (86677) OR rb.destination_team_id IN (86677)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
32 724 us 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=86677 LIMIT 1
33 413 us 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=102465 LIMIT 1
34 73.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=102465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
35 302 us 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=102465 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
36 219 us 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 = 102465 AND active = 1
37 1.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 = 102465 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
38 1.6 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=102465 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
39 1.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=102465 and l.id=t.league_id WHERE ct.id IN (238,2859) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
40 1.2 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 = 76883 AND tab.round = 23 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
41 2.1 ms controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE itemId=102465 AND type_rel=2 AND ln='es'
42 205 us 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 (102465) OR rb.destination_team_id IN (102465)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
43 838 us 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=102465 LIMIT 1
44 291 us 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 = 68483
45 1.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 events2023 AS ev WHERE ev.match_id=340935 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
46 375 us 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 events2023 AS ev WHERE ev.match_id=340935 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
47 223 us controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536290 and type = 33
48 153 us controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536291 and type = 33
49 128 us controllers/news.php

SELECT rating1, rating2 FROM calendars_elo WHERE id=340935 AND league_id=68483 AND year=2023
50 228 us controllers/news.php

SELECT position FROM tables2023 WHERE team=6536290 AND league_id=68483 AND round=4
51 161 us controllers/news.php

SELECT position FROM tables2023 WHERE team=6536291 AND league_id=68483 AND round=4
52 156 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='a587736f77f430a8754d5bc5997f4c74'
53 359 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='36606e85840bb85db6521cd308082a21'
54 439 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='79b6ae4ce99e33b634a24499333a04bc'
55 326 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='6b8decc79ce0bf36a7baba7d3fa57e10'
56 335 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='71249081f8b767253cd8841324288b1c'
57 359 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='spanish' AND keyone='531a9e10f15396b097aa1513d4e89bd0'
58 240 us controllers/news.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='212a0488abf6c0d52971d8e90bf314f9'
59 231 us 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 = 86677 AND active = 1
60 2.1 ms controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536290 AND type = 33 ORDER BY groupId ASC, type
61 118 us controllers/news.php

SELECT data1 FROM stats2023 t WHERE league_id = 68483 AND teamId = 6536291 AND type = 33 ORDER BY groupId ASC, type
62 108 us controllers/news.php

SELECT * FROM calendars2023_times WHERE id = 340935
63 147 us 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, 2023 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=2023 and rp.team_id=6536291 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
64 1 ms controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=68483 AND teamId=6536290 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
65 134 us controllers/news.php

SELECT type, data1, data2, data3, data4 FROM stats2023 WHERE league_id=68483 AND teamId=6536291 AND ((type>=1 AND type<=9) OR (type>=29 AND type<=32)) ORDER BY type ASC
66 118 us 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 = 68483 AND t.round<=4 ORDER BY t.round ASC,t.points DESC, diff DESC, t.ga DESC
67 188 us 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=340935 AND rc.year=2023
68 176 us controllers/news.php

SELECT ev.id, ev.player_id, ev.action, ev.minute, ev.teamId, date, period FROM events2023 AS ev WHERE ev.match_id=340935 AND ev.action<31 ORDER BY ev.minute ASC, ev.date ASC, ev.id ASC
69 189 us controllers/news.php

SELECT id, team_id, tactica AS tactic FROM dreamteam_data_real WHERE league_id = 68483 AND id_match = 340935
70 637 us 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 = 68483 AND rel.team1 = 6536290 AND rel.team2 = 6536291 ORDER BY FIELD(m.location,'es','en') DESC
71 644 us controllers/news.php

SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 68483 AND id_match = 340935
72 531 us 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='68483' AND relp.team_id=6536290 WHERE mp.`match_id` = '340935' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
73 1 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='68483' AND relp.team_id=6536291 WHERE mp.`match_id` = '340935' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
74 1 ms controllers/news.php

SELECT rl.* FROM futbol.rel_live_commentaries AS rl WHERE rl.match_id = 340935 AND rl.year = 2023 AND rl.active = 1 AND rl.ln = 'es';
75 241 us controllers/news.php

SELECT * FROM futbol.live_commentaries2023 WHERE match_id = 340935 AND ln = 'es' AND type = 1 AND owner = '1' ORDER BY minute DESC, creation_date DESC, id DESC;
76 333 us controllers/news.php

SELECT * FROM futbol.live_commentaries2023 WHERE match_id = 340935 AND ln = 'es' AND type = 1 AND owner = 1 ORDER BY minute DESC, extra_minute DESC, creation_date DESC, id DESC;
77 304 us controllers/news.php

SELECT * FROM calendars2023 AS c WHERE c.id=340935
78 267 us controllers/news.php

SELECT * FROM events2023 AS e WHERE e.match_id=340935 ORDER BY minute DESC
79 167 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340935 AND extraId = 68483 AND type_rel = 4
80 192 us controllers/news.php

SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=854 AND type_rel = 3
81 152 us controllers/news.php

SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 854 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
82 1.1 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 (1138777,980168,844883,231358,73515) ORDER BY n.cover_points DESC, update_date DESC
83 1.5 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 `calendars2023` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 68483 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 12
84 3 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 = 68483 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
85 1.4 ms controllers/news.php

TOTAL TIME 206.6 ms QUERIES 85 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