No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `UsersSession`.`id`, `UsersSession`.`user_id` FROM `presst_pre`.`users_sessions` AS `UsersSession` WHERE `UsersSession`.`date` < '2026-07-01 00:27:41' | 0 | 0 | 0 | |
| SELECT `UsersSession`.`id`, `UsersSession`.`user_id` FROM `presst_pre`.`users_sessions` AS `UsersSession` WHERE 1 = 1 | 0 | 0 | 0 | |
| UPDATE `presst_pre`.`users` AS `User` LEFT JOIN `presst_pre`.`masters` AS `Master` ON (`Master`.`user_id` = `User`.`id`) LEFT JOIN `presst_pre`.`subscribers` AS `Subscriber` ON (`Subscriber`.`user_id` = `User`.`id`) LEFT JOIN `presst_pre`.`editors` AS `Editor` ON (`Editor`.`user_id` = `User`.`id`) LEFT JOIN `presst_pre`.`managers` AS `Manager` ON (`Manager`.`user_id` = `User`.`id`) LEFT JOIN `presst_pre`.`users_sessions` AS `UsersSession` ON (`UsersSession`.`user_id` = `User`.`id`) LEFT JOIN `presst_pre`.`registrations` AS `Registration` ON (`Registration`.`user_id` = `User`.`id`) SET `User`.`is_in` = 0 WHERE `User`.`is_in` > 0 AND `User`.`id` IS NOT NULL | 0 | 0 | 7 | maybe slow |
| SELECT `Message`.`id`, `Message`.`user_id`, `Message`.`created`, `Message`.`readed`, `Message`.`read`, `Message`.`class`, `Message`.`message` FROM `presst_pre`.`messages` AS `Message` WHERE `user_id` IS NULL AND `read` = 0 | 0 | 0 | 0 | |
| SELECT DISTINCT `Publication`.*, (NOT ISNULL(IFNULL(`Payment`.`id`, `PaymentSupplement`.`id`))) AS `Publication__payed`, (NOT ISNULL(`Payment`.`pdf`)) AS `Publication__pdf`, (`Journal`.`editor_id`) AS `Publication__editor_id` FROM `presst_pre`.`publications` AS `Publication` LEFT JOIN `presst_pre`.`journals` AS `Journal` ON (`Journal`.`id` = `Publication`.`journal_id`) LEFT JOIN `presst_pre`.`payments` AS `Payment` ON (`Payment`.`subscriber_id` = 0 AND `Payment`.`canceled` = 0 AND `Payment`.`payed` = 1 AND `Payment`.`journal_id` = `Publication`.`journal_id` AND `Payment`.`start_date` <= '2026-07-01' AND `Payment`.`end_date` >= '2026-07-01' AND `Payment`.`start_date` <= DATE_FORMAT(`Publication`.`start_time`, "%Y-%m-%d") AND `Payment`.`end_date` >= DATE_FORMAT(`Publication`.`start_time`, "%Y-%m-%d")) LEFT JOIN `presst_pre`.`journals_suplements` AS `JournalsSuplement` ON (`JournalsSuplement`.`suplement_id` = `Publication`.`journal_id`) LEFT JOIN `presst_pre`.`payments` AS `PaymentSupplement` ON (`PaymentSupplement`.`subscriber_id` = 0 AND `PaymentSupplement`.`journal_id` = `JournalsSuplement`.`journal_id` AND `PaymentSupplement`.`canceled` = 0 AND `PaymentSupplement`.`payed` = 1 AND `PaymentSupplement`.`start_date` <= '2026-07-01' AND `PaymentSupplement`.`end_date` >= '2026-07-01') WHERE `Publication`.`start_time` <= '2026-07-01 00:57:41' AND `Publication`.`end_time` >= '2026-07-01 00:57:41' AND `Publication`.`state` = 'A' ORDER BY `Journal`.`editor_id` ASC, `Journal`.`order` ASC, `Journal`.`id` ASC, `Publication`.`start_time` ASC | 7 | 7 | 80 | maybe slow |
Peak Memory Use 8.09 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.51 MB |
| Controller action start | 5.83 MB |
| Controller render start | 5.98 MB |
| View render complete | 7.40 MB |
Total Request Time: 145 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 19.97 | |
| Event: Controller.initialize | 22.02 | |
| Event: Controller.startup | 0.63 | |
| Controller action | 82.37 | |
| Event: Controller.beforeRender | 2.87 | |
| » Processing toolbar data | 2.80 | |
| Rendering View | 2.82 | |
| » Event: View.beforeRender | 0.02 | |
| » Rendering APP/View/Subscribers/index.ctp | 0.86 | |
| » Rendering APP/View/Elements/Publication/index.ctp #2 | 0.82 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default.ctp | 1.47 | |
| » » Rendering APP/View/Elements/admanager.ctp | 0.15 | |
| » » » Rendering APP/View/Elements/logo.ctp | 0.07 | |
| » » Rendering APP/View/Elements/languages.ctp | 0.15 | |
| » » Rendering APP/View/Elements/menu/menu.ctp | 0.48 | |
| » » Rendering APP/View/Elements/cookie_consent.ctp | 0.05 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/var/www/presst.pre/app/Config/' |
| PDF_FILES | '/var/www/presst.pre/app/Files/' |
| Constant | Value |
|---|---|
| APP | '/var/www/presst.pre/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/var/www/presst.pre/app/Lib/' |
| CACHE | '/var/www/presst.pre/app/tmp/cache/' |
| CAKE | '/var/www/presst.pre/vendors/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/var/www/presst.pre/vendors/cakephp/cakephp/lib' |
| CORE_PATH | '/var/www/presst.pre/vendors/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.24' |
| CSS | '/var/www/presst.pre/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://pre.presst.net' |
| IMAGES | '/var/www/presst.pre/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/var/www/presst.pre/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/var/www/presst.pre/app/tmp/logs/' |
| ROOT | '/var/www/presst.pre' |
| TESTS | '/var/www/presst.pre/app/Test/' |
| TMP | '/var/www/presst.pre/app/tmp/' |
| VENDORS | '/var/www/presst.pre/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/var/www/presst.pre/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.4.33' |
| Unique Id | 'akRJ5eS6hqMUBHInRc-mRAAAAAQ' |
| Debug | '2' |
| Perl5lib | '/usr/share/awstats/lib:/usr/share/awstats/plugins' |
| Https | 'on' |
| Ssl Tls Sni | 'pre.presst.net' |
| Ssl Server S Dn Cn | 'presst.net' |
| Ssl Server I Dn C | 'US' |
| Ssl Server I Dn O | 'Let's Encrypt' |
| Ssl Server I Dn Cn | 'YR1' |
| Ssl Server San Dns 0 | 'dev.presst.net' |
| Ssl Server San Dns 1 | 'pre.presst.net' |
| Ssl Server San Dns 2 | 'presst.net' |
| Ssl Server San Dns 3 | 'www.presst.net' |
| Ssl Version Interface | 'mod_ssl/2.4.6' |
| Ssl Version Library | 'OpenSSL/1.0.2k-fips' |
| Ssl Protocol | 'TLSv1.2' |
| Ssl Secure Reneg | 'true' |
| Ssl Compress Method | 'NULL' |
| Ssl Cipher | 'ECDHE-RSA-AES256-GCM-SHA384' |
| Ssl Cipher Export | 'false' |
| Ssl Cipher Usekeysize | '256' |
| Ssl Cipher Algkeysize | '256' |
| Ssl Client Verify | 'NONE' |
| Ssl Server M Version | '3' |
| Ssl Server M Serial | '055885B473232976D5497D6DB46A8BE7E912' |
| Ssl Server V Start | 'Jun 30 21:03:21 2026 GMT' |
| Ssl Server V End | 'Sep 28 21:03:20 2026 GMT' |
| Ssl Server S Dn | 'CN=presst.net' |
| Ssl Server I Dn | 'CN=YR1,O=Let's Encrypt,C=US' |
| Ssl Server A Key | 'rsaEncryption' |
| Ssl Server A Sig | 'sha256WithRSAEncryption' |
| Ssl Session Resumed | 'Initial' |
| Http Accept | '*/*' |
| Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
| Http Accept Encoding | 'gzip, br, zstd, deflate' |
| Http Host | 'pre.presst.net' |
| Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin' |
| Server Signature | '' |
| Server Software | 'Apache' |
| Server Name | 'pre.presst.net' |
| Server Addr | '172.31.27.0' |
| Server Port | '443' |
| Remote Addr | '216.73.216.251' |
| Document Root | '/var/www/presst.pre/app/webroot' |
| Request Scheme | 'https' |
| Context Prefix | '' |
| Context Document Root | '/var/www/presst.pre/app/webroot' |
| Server Admin | 'root@localhost' |
| Script Filename | '/var/www/presst.pre/app/webroot/index.php' |
| Remote Port | '42816' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/' |
| Script Name | '/index.php' |
| Php Self | '/index.php' |
| Request Time Float | (float) 1782860261.2465 |
| Request Time | (int) 1782860261 |
