Benchmark
Fri, Mar 7 10:12:33


202.7 ms PHP Time
- Base: 501 us
- Controller: 202.2 ms
* SQL: 186.3 ms
* Rest: 15.9 ms

648.46 kb Memory Usage
- PHP Load: 427.44 kb
- Base: 19.56 kb
- Controller: 197.9 kb

1.05 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
1%5.59 kbindex.php
50%434.32 kbkint.phar
0%1.71 kbphar://kint.phar/init_phar.php
0%2.73 kbphar://kint.phar/init.php
3%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
1%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
2%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
1%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
7%58.1 kbapplication/controllers/team.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
5%42.07 kbapplication/helpers/normalize_responses.php
6%53.1 kbapplication/lib/lib.php
2%17.69 kbapplication/req/team.php
1%5.83 kbapplication/req/teams_competitions_history.php
1%9.18 kbapplication/req/ranking_players_competition.php
2%19.64 kbapplication/req/tables.php
1%5.34 kbapplication/req/teams.php
0%3.1 kbapplication/mods/exec_mods.php
0%399 bapplication/mods/team/migrated/breadcrumbs.php
0%3.77 kbapplication/mods/team/migrated/menu_team.php
0%979 bapplication/mods/team/migrated/related_categories.php
0%1.21 kbapplication/mods/team/migrated/other_teams.php
1%12.97 kbapplication/views/common/header_view.php
0%4.08 kbapplication/views/common/quantcast/cfv3.php
1%4.93 kbapplication/mods/home/banner_cookies.php
0%197 bapplication/views/common/menu_view.php
0%104 bapplication/views/common/adstop.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
870.36 kbTotal
SQL Queries (32)

Connection to sql... 8.9 ms

SELECT old,new FROM redirect WHERE old = 'plantilla'
1 1.9 ms config/routes_file.php

TOTAL TIME 89.1 ms QUERIES 2 FILE config/routes_file.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.basealias='Bohemians-Fc' LIMIT 1
2 87.2 ms controllers/home.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=1047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
3 2.2 ms controllers/home.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=1047 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
4 1.9 ms controllers/home.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 = 1047 AND active = 1
5 4.1 ms controllers/home.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 = 1047 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
6 3.9 ms controllers/home.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=1047 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
7 3.7 ms controllers/home.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=1047 and l.id=t.league_id WHERE ct.id IN (346,1623,1692,1748) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
8 4.1 ms controllers/home.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 = 78314 AND tab.round = 5 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
9 2.6 ms controllers/home.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=6676646 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 3.2 ms controllers/home.php

SELECT total FROM bs_rel_resume_items WHERE itemId=1047 AND type_rel=2 AND ln='es'
11 1.9 ms controllers/home.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 (1047) OR rb.destination_team_id IN (1047)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
12 2.8 ms controllers/home.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=1047 LIMIT 1
13 1.9 ms controllers/home.php

SELECT dt.nameShow FROM datateams AS dt WHERE dt.id=1047 LIMIT 1
14 1.9 ms controllers/home.php

SELECT cat.alias, cat.location as cc, cat.logo, cat.name AS category_name, dtm.year, dtm.categoryId,(SUM(dtm.lineup) DIV 11) AS apps, SUM(dtm.goals) AS goals, SUM(dtm.assists) AS assists, SUM(dtm.yellow_cards) AS yellow_cards, SUM(dtm.expulsions) AS expulsions, dtm.league_id, dtm.teamId, cat.troncal,lea.group_code, lea.id as league_id FROM detail_team_match AS dtm INNER JOIN categories_besoccer AS cat ON dtm.categoryId = cat.id LEFT JOIN leagues lea ON lea.id=dtm.league_id WHERE teamId = 1047 AND cat.official = 1 GROUP BY dtm.year, dtm.categoryId ORDER BY dtm.year DESC, dtm.categoryId ASC
15 24.4 ms controllers/home.php

SELECT player_id FROM rel_players rp WHERE rp.category_id=346 and rp.year=1973 AND rp.in_squad=1 AND teamId=1047
16 5.4 ms controllers/home.php

SELECT id FROM leagues WHERE categoryId=346 AND `year`=1973 ORDER BY id ASC
17 2.4 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick,dt.id as teamId, dt.nameShow as teamName,dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND (e.action IN (1,2,11,12,13,26)) AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
18 2.3 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=3 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
19 2.1 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=4 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
20 2.1 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=5 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
21 2.2 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=22 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
22 2.2 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=2 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
23 2.1 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=15 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
24 2.1 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events1973 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=346 and rp.year=1973 and rp.player_id=dp.id WHERE e.league_id in (31352) AND e.action<31 AND e.action=16 AND dt.id=1047 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
25 2 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=346 or sonId=346 LIMIT 1
26 1.8 ms controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 346 AND l.year=1973 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
27 1.9 ms controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1973 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 31352 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
28 2.1 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=346 AND l.year=1973 AND l.group_code='1' ORDER BY l.group_code, dt.nameShow ASC
29 2.1 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=1623 AND l.year=1973 AND l.group_code='1' ORDER BY l.group_code, dt.nameShow ASC
30 1.9 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=1692 AND l.year=1973 AND l.group_code=0 ORDER BY l.group_code, dt.nameShow ASC
31 1.9 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=1748 AND l.year=1973 AND l.group_code=0 ORDER BY l.group_code, dt.nameShow ASC
32 2 ms controllers/home.php

TOTAL TIME 97.2 ms QUERIES 30 FILE controllers/home.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