No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Option`.`id`, `Option`.`group`, `Option`.`name`, `Option`.`value`, `Option`.`locked`, `Option`.`description` FROM `b3_xlr`.`options` AS `Option` WHERE 1 = 1 | 34 | 34 | 1 | |
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `active` = '1' | 6 | 6 | 1 | maybe slow |
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `active` = '1' ORDER BY `Server`.`id` asc LIMIT 1 | 1 | 1 | 1 | |
SELECT `ServerOption`.`id`, `ServerOption`.`server_id`, `ServerOption`.`name`, `ServerOption`.`value`, `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add` FROM `b3_xlr`.`server_options` AS `ServerOption` LEFT JOIN `b3_xlr`.`servers` AS `Server` ON (`ServerOption`.`server_id` = `Server`.`id`) WHERE `ServerOption`.`server_id` = 2 | 16 | 16 | 1 | maybe slow |
SELECT `UserSoldier`.`id`, `UserSoldier`.`user_id`, `UserSoldier`.`server_id`, `UserSoldier`.`playerstats_id`, `AppUser`.`id`, `AppUser`.`username`, `AppUser`.`slug`, `AppUser`.`password`, `AppUser`.`password_token`, `AppUser`.`email`, `AppUser`.`email_verified`, `AppUser`.`email_token`, `AppUser`.`email_token_expires`, `AppUser`.`tos`, `AppUser`.`active`, `AppUser`.`last_login`, `AppUser`.`last_action`, `AppUser`.`is_admin`, `AppUser`.`group_id`, `AppUser`.`role`, `AppUser`.`created`, `AppUser`.`modified`, `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add` FROM `b3_xlr`.`user_soldiers` AS `UserSoldier` LEFT JOIN `b3_xlr`.`users` AS `AppUser` ON (`UserSoldier`.`user_id` = `AppUser`.`id`) LEFT JOIN `b3_xlr`.`servers` AS `Server` ON (`UserSoldier`.`server_id` = `Server`.`id`) WHERE `UserSoldier`.`playerstats_id` = 930 AND `UserSoldier`.`server_id` = 2 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 8 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`servername_a` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Server`.`id`, `Server`.`active`, `Server`.`gamename`, `Server`.`servername`, `Server`.`servername_a`, `Server`.`dbhost`, `Server`.`dbuser`, `Server`.`dbpass`, `Server`.`dbname`, `Server`.`server_group_id`, `Server`.`statusurl`, `Server`.`slogan`, `Server`.`time_add`, `ServerGroup`.`id`, `ServerGroup`.`name`, `ServerGroup`.`description`, `ServerGroup`.`active_group` FROM `b3_xlr`.`servers` AS `Server` LEFT JOIN `b3_xlr`.`server_groups` AS `ServerGroup` ON (`Server`.`server_group_id` = `ServerGroup`.`id`) WHERE `Server`.`id` = 2 LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `b3_xlr`.`servers` AS `Server` WHERE `Server`.`id` = 2 | 1 | 1 | 0 | |
UPDATE `b3_xlr`.`servers` SET `id` = 2, `active` = '1', `gamename` = 'cod4', `servername` = '#26', `servername_a` = ' ^44GF.CZ^7 #26 | SD | HC | Cracked', `dbhost` = '127.0.0.1', `dbuser` = 'b3', `dbpass` = 'b3aeu1245', `dbname` = 'b3', `server_group_id` = 1, `statusurl` = '/home/scutifer/httpdocs/xlrstats/status26.xml', `slogan` = '', `time_add` = '0000-00-00 00:00:00' WHERE `b3_xlr`.`servers`.`id` = '2' | 0 | 0 | 0 |
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `PlayerStat`.`id`, `PlayerStat`.`client_id`, `PlayerStat`.`kills`, `PlayerStat`.`deaths`, `PlayerStat`.`teamkills`, `PlayerStat`.`teamdeaths`, `PlayerStat`.`suicides`, `PlayerStat`.`ratio`, `PlayerStat`.`skill`, `PlayerStat`.`assists`, `PlayerStat`.`assistskill`, `PlayerStat`.`curstreak`, `PlayerStat`.`winstreak`, `PlayerStat`.`losestreak`, `PlayerStat`.`rounds`, `PlayerStat`.`hide`, `PlayerStat`.`fixed_name`, `PlayerStat`.`id_token`, `Player`.`id`, `Player`.`ip`, `Player`.`connections`, `Player`.`guid`, `Player`.`pbid`, `Player`.`name`, `Player`.`auto_login`, `Player`.`mask_level`, `Player`.`group_bits`, `Player`.`greeting`, `Player`.`login`, `Player`.`password`, `Player`.`time_add`, `Player`.`time_edit`, `Player`.`show`, `Player`.`spammer`, `Player`.`only_with_client`, `Player`.`trg_admin`, `Player`.`chat_mute`, `Player`.`regular` FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` LEFT JOIN `b3`.`clients` AS `Player` ON (`PlayerStat`.`client_id` = `Player`.`id`) WHERE `PlayerStat`.`id` = 930 LIMIT 1 | 1 | 1 | 1 | |
SET @place = 0 | 0 | 0 | 0 | |
SELECT * FROM (SELECT @place := @place + 1 AS place, PlayerStat.id, PlayerStat.client_id, Player.name FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` ,`b3`.`clients` AS Player WHERE `PlayerStat`.`skill` BETWEEN 1400 AND 9999999 AND `PlayerStat`.`hide` = 0 AND `PlayerStat`.`kills` > 100 AND `Player`.`connections` > 10 AND `PlayerStat`.`client_id` = `Player`.`id` AND `Player`.`time_edit` >= 1680324610 AND `Player`.`id` NOT IN (SELECT DISTINCT(Penalty.client_id) FROM `b3`.`penalties` AS `Penalty` WHERE `Penalty`.`type` IN ('Ban', 'TempBan') AND ((`Penalty`.`time_expire` = -1) OR (`Penalty`.`time_expire` > 1685508610)) AND `Penalty`.`inactive` = '0') ORDER BY `PlayerStat`.`skill` desc) derivated_table WHERE id = 930 | 1 | 1 | 17 | maybe slow |
SELECT COUNT(*) AS `count` FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` LEFT JOIN `b3`.`clients` AS `Player` ON (`PlayerStat`.`client_id` = `Player`.`id`) WHERE 1 = 1 | 1 | 1 | 4 | maybe slow |
SELECT SUM(kills) as total_kills FROM `b3`.`xlr_26_playerstats` AS `PlayerStat` LEFT JOIN `b3`.`clients` AS `Player` ON (`PlayerStat`.`client_id` = `Player`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `WeaponStat`.`id`, `WeaponStat`.`name`, `WeaponStat`.`kills`, `WeaponStat`.`teamkills`, `WeaponStat`.`suicides` FROM `b3`.`xlr_26_weaponstats` AS `WeaponStat` WHERE 1 = 1 ORDER BY `kills` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `MapStat`.`id`, `MapStat`.`name`, `MapStat`.`kills`, `MapStat`.`teamkills`, `MapStat`.`suicides`, `MapStat`.`rounds` FROM `b3`.`xlr_26_mapstats` AS `MapStat` WHERE `MapStat`.`name` = 'mp_backlot' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MapStat`.`id`, `MapStat`.`name`, `MapStat`.`kills`, `MapStat`.`teamkills`, `MapStat`.`suicides`, `MapStat`.`rounds` FROM `b3`.`xlr_26_mapstats` AS `MapStat` WHERE 1 = 1 ORDER BY `rounds` DESC LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 7.01 MB
Message | Memory use |
---|---|
Component initialization | 1.53 MB |
Controller action start | 3.19 MB |
Controller render start | 4.11 MB |
Component initialization #2 | 4.62 MB |
Controller action start #2 | 4.70 MB |
Component initialization #3 | 4.85 MB |
Controller action start #3 | 4.94 MB |
Component initialization #4 | 5.00 MB |
Controller action start #4 | 5.08 MB |
Component initialization #5 | 5.14 MB |
Controller action start #5 | 5.23 MB |
Component initialization #6 | 5.29 MB |
Controller action start #6 | 5.39 MB |
Component initialization #7 | 5.45 MB |
Controller action start #7 | 5.53 MB |
Component initialization #8 | 5.59 MB |
Controller action start #8 | 5.67 MB |
Component initialization #9 | 5.77 MB |
Controller action start #9 | 5.85 MB |
Component initialization #10 | 5.96 MB |
Controller action start #10 | 6.08 MB |
Component initialization #11 | 6.22 MB |
Controller action start #11 | 6.35 MB |
View render complete | 6.69 MB |
Total Request Time: 254 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 17.01 | |
Event: Controller.initialize | 32.56 | |
Event: Controller.startup | 0.88 | |
Controller action | 56.92 | |
Event: Controller.beforeRender | 3.96 | |
» Processing toolbar data | 3.79 | |
Rendering View | 108.10 | |
» Event: View.beforeRender | 0.07 | |
» Rendering APP/View/PlayerStats/view.ctp | 12.99 | |
» » Event: Controller.initialize #2 | 2.26 | |
» » Event: Controller.startup #2 | 0.25 | |
Controller action #2 | 0.00 | |
» » » Event: Controller.shutdown | 0.05 | |
» » » Rendering APP/View/Elements/profile-social-buttons.ctp | 0.16 | |
» » » Rendering APP/View/Elements/disqus.ctp | 0.15 | |
» » Event: View.afterRender | 0.05 | |
» » Event: View.beforeLayout | 0.05 | |
» » Rendering APP/View/Layouts/default.ctp | 93.60 | |
» » » Rendering APP/View/Elements/google-analytics.ctp | 0.16 | |
» » » Rendering APP/View/Elements/login.ctp | 0.13 | |
» » » Rendering APP/View/Elements/menu.ctp | 41.44 | |
» » » » Rendering APP/View/Elements/menu_leagues.ctp | 3.21 | |
» » » » Rendering APP/View/Elements/menu_servers.ctp | 35.36 | |
» » » » » Event: Controller.initialize #3 | 2.25 | |
» » » » » Event: Controller.startup #3 | 0.25 | |
Controller action #3 | 0.00 | |
» » » » » » Event: Controller.shutdown #2 | 0.05 | |
» » » » » » Event: Controller.initialize #4 | 2.26 | |
» » » » » » Event: Controller.startup #4 | 0.25 | |
Controller action #4 | 0.00 | |
» » » » » » » Event: Controller.shutdown #3 | 0.06 | |
» » » » » » » Event: Controller.initialize #5 | 2.28 | |
» » » » » » » Event: Controller.startup #5 | 0.26 | |
Controller action #5 | 0.00 | |
» » » » » » » » Event: Controller.shutdown #4 | 0.05 | |
» » » » » » » » Event: Controller.initialize #6 | 2.43 | |
» » » » » » » » Event: Controller.startup #6 | 0.25 | |
Controller action #6 | 0.00 | |
» » » » » » » » » Event: Controller.shutdown #5 | 0.06 | |
» » » » » » » » » Event: Controller.initialize #7 | 2.44 | |
» » » » » » » » » Event: Controller.startup #7 | 0.26 | |
Controller action #7 | 0.00 | |
» » » » » » » » » » Event: Controller.shutdown #6 | 0.05 | |
» » » » » » » » » » Event: Controller.initialize #8 | 2.47 | |
» » » » » » » » » » Event: Controller.startup #8 | 0.27 | |
Controller action #8 | 0.00 | |
» » » » » » » » » » » Event: Controller.shutdown #7 | 0.05 | |
» » » » » » » » » Rendering APP/View/Elements/server_info.ctp | 46.72 | |
» » » » » » » » » » Event: Controller.initialize #9 | 2.53 | |
» » » » » » » » » » Event: Controller.startup #9 | 0.24 | |
Controller action #9 | 0.00 | |
» » » » » » » » » » » Event: Controller.shutdown #8 | 0.05 | |
» » » » » » » » » » » Event: Controller.initialize #10 | 4.05 | |
» » » » » » » » » » » Event: Controller.startup #10 | 0.73 | |
Controller action #10 | 0.00 | |
» » » » » » » » » » » » Event: Controller.initialize #11 | 2.86 | |
» » » » » » » » » » » » Event: Controller.startup #11 | 0.48 | |
Controller action #11 | 0.00 | |
» » » » » » » » » » » » » Event: Controller.shutdown #9 | 0.08 | |
» » » » » » » » » » » » » Event: Controller.shutdown #10 | 0.07 | |
» » » » » » » » » » » » » Rendering APP/View/Elements/donate_button.ctp | 0.14 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
XLR_VERSION | v3.0.0-beta.10 |
GEOIP_COUNTRY_EDITION | 106 |
GEOIP_REGION_EDITION_REV0 | 112 |
GEOIP_REGION_EDITION_REV1 | 3 |
GEOIP_CITY_EDITION_REV0 | 111 |
GEOIP_CITY_EDITION_REV1 | 2 |
GEOIP_ORG_EDITION | 110 |
GEOIP_ISP_EDITION | 4 |
GEOIP_PROXY_EDITION | 8 |
GEOIP_ASNUM_EDITION | 9 |
GEOIP_NETSPEED_EDITION | 10 |
GEOIP_DOMAIN_EDITION | 11 |
GEOIP_UNKNOWN_SPEED | 0 |
GEOIP_DIALUP_SPEED | 1 |
GEOIP_CABLEDSL_SPEED | 2 |
GEOIP_CORPORATE_SPEED | 3 |
GEOIP_COUNTRY_BEGIN | 16776960 |
GEOIP_STATE_BEGIN_REV0 | 16700000 |
GEOIP_STATE_BEGIN_REV1 | 16000000 |
GEOIP_STANDARD | 0 |
GEOIP_MEMORY_CACHE | 1 |
GEOIP_SHARED_MEMORY | 2 |
STRUCTURE_INFO_MAX_SIZE | 20 |
DATABASE_INFO_MAX_SIZE | 100 |
SEGMENT_RECORD_LENGTH | 3 |
STANDARD_RECORD_LENGTH | 3 |
ORG_RECORD_LENGTH | 4 |
MAX_RECORD_LENGTH | 4 |
MAX_ORG_RECORD_LENGTH | 300 |
GEOIP_SHM_KEY | 1329681409 |
US_OFFSET | 1 |
CANADA_OFFSET | 677 |
WORLD_OFFSET | 1353 |
FIPS_RANGE | 360 |
GEOIP_LOCATIONA_EDITION | 13 |
GEOIP_ACCURACYRADIUS_EDITION | 14 |
GEOIP_CITYCOMBINED_EDITION | 15 |
GEOIP_NETSPEED_EDITION_REV1 | 32 |
GEOIP_NETSPEED_EDITION_REV1_V6 | 33 |
GEOIP_USERTYPE_EDITION | 28 |
GEOIP_USERTYPE_EDITION_V6 | 29 |
GEOIP_ASNUM_EDITION_V6 | 21 |
GEOIP_ISP_EDITION_V6 | 22 |
GEOIP_ORG_EDITION_V6 | 23 |
GEOIP_DOMAIN_EDITION_V6 | 24 |
GEOIP_COUNTRY_EDITION_V6 | 12 |
GEOIP_CITY_EDITION_REV1_V6 | 30 |
GEOIP_CITY_EDITION_REV0_V6 | 31 |
CITYCOMBINED_FIXED_RECORD | 7 |
Constant | Value |
---|---|
APP | /home/scutifer/httpdocs/xlrstats/app/ |
APP_DIR | app |
APPLIBS | /home/scutifer/httpdocs/xlrstats/app/Lib/ |
CACHE | /home/scutifer/httpdocs/xlrstats/app/tmp/cache/ |
CAKE | /home/scutifer/httpdocs/xlrstats/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /home/scutifer/httpdocs/xlrstats/lib |
CORE_PATH | /home/scutifer/httpdocs/xlrstats/lib/ |
CAKE_VERSION | 2.4.3 |
CSS | /home/scutifer/httpdocs/xlrstats/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | http://135.4gf.cz |
IMAGES | /home/scutifer/httpdocs/xlrstats/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /home/scutifer/httpdocs/xlrstats/app/webroot/js/ |
JS_URL | js/ |
LOGS | /home/scutifer/httpdocs/xlrstats/app/tmp/logs/ |
ROOT | /home/scutifer/httpdocs/xlrstats |
TESTS | /home/scutifer/httpdocs/xlrstats/app/Test/ |
TMP | /home/scutifer/httpdocs/xlrstats/app/tmp/ |
VENDORS | /home/scutifer/httpdocs/xlrstats/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /home/scutifer/httpdocs/xlrstats/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40-64+ubuntu22.04.1+deb.sury.org+1 |
Redirect Redirect Status | 200 |
Redirect Status | 200 |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http Accept Language | en-US,en;q=0.5 |
Http Accept Encoding | br,gzip |
Http Host | 135.4gf.cz |
Http Connection | Keep-Alive |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin |
Server Signature | Apache/2.4.52 (Ubuntu) Server at 135.4gf.cz Port 80 |
Server Software | Apache/2.4.52 (Ubuntu) |
Server Name | 135.4gf.cz |
Server Addr | 88.86.107.135 |
Server Port | 80 |
Remote Addr | 3.227.251.94 |
Document Root | /home/scutifer/httpdocs |
Request Scheme | http |
Context Prefix | |
Context Document Root | /home/scutifer/httpdocs |
Server Admin | webmaster@localhost |
Script Filename | /home/scutifer/httpdocs/xlrstats/app/webroot/index.php |
Remote Port | 38218 |
Redirect Url | /xlrstats/app/webroot/2/player_stats/view/930 |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | /xlrstats/2/player_stats/view/930 |
Script Name | /xlrstats/app/webroot/index.php |
Php Self | /xlrstats/app/webroot/index.php |
Request Time Float | 1685508610.05 |
Request Time | 1685508610 |
No configured/allowed cache groups.
Click on some link above.