No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Category`.`id`, `Category`.`region_name`, `Category`.`alias`, `Category`.`count_mo`, `Category`.`count_gobmp`, `Category`.`count_mo_accredit`, `Category`.`procent_mo_accredit`, `Category`.`count_no_mo_accredit`, `Category`.`procent_no_mo_accredit`, `Category`.`map_code`, `Category`.`total_mo`, `Category`.`accredited`, `Category`.`no_status`, `Category`.`recalled`, `Category`.`region_exp`, `Category`.`denied`, `Category`.`doc`, `Category`.`created`, `Category`.`modified`, (`I18n__region_name__en`.`content`) AS `Category__i18n_region_name_en`, (`I18n__region_name__kz`.`content`) AS `Category__i18n_region_name_kz`, (`I18n__titleTranslation__en`.`content`) AS `Category__i18n_titleTranslation_en`, (`I18n__titleTranslation__kz`.`content`) AS `Category__i18n_titleTranslation_kz` FROM `acqhkz_new`.`categories` AS `Category` LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__en` ON (`Category`.`id` = `I18n__region_name__en`.`foreign_key` AND `I18n__region_name__en`.`model` = 'Category' AND `I18n__region_name__en`.`field` = 'region_name' AND `I18n__region_name__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__kz` ON (`Category`.`id` = `I18n__region_name__kz`.`foreign_key` AND `I18n__region_name__kz`.`model` = 'Category' AND `I18n__region_name__kz`.`field` = 'region_name' AND `I18n__region_name__kz`.`locale` = 'kz') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__en` ON (`Category`.`id` = `I18n__titleTranslation__en`.`foreign_key` AND `I18n__titleTranslation__en`.`model` = 'Category' AND `I18n__titleTranslation__en`.`field` = 'title' AND `I18n__titleTranslation__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__kz` ON (`Category`.`id` = `I18n__titleTranslation__kz`.`foreign_key` AND `I18n__titleTranslation__kz`.`model` = 'Category' AND `I18n__titleTranslation__kz`.`field` = 'title' AND `I18n__titleTranslation__kz`.`locale` = 'kz') WHERE `Category`.`alias` = 'almaty' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'Category' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 1 | 1 | 2 | maybe slow |
SELECT `Map`.`id`, `Map`.`name`, `Map`.`region_id`, `Map`.`ownership`, `Map`.`accreditation_year`, `Map`.`date_beginning_accred`, `Map`.`date_end_accred`, `Map`.`status`, `Map`.`category_type`, `Map`.`quarter`, `Map`.`type_organiztion`, `Map`.`created`, `Map`.`modified`, (`I18n__name`.`content`) AS `Map__i18n_name`, (`I18n__category_type`.`content`) AS `Map__i18n_category_type` FROM `acqhkz_new`.`maps` AS `Map` INNER JOIN `acqhkz_new`.`i18n` AS `I18n__name` ON (`Map`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Map' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'ru') INNER JOIN `acqhkz_new`.`i18n` AS `I18n__category_type` ON (`Map`.`id` = `I18n__category_type`.`foreign_key` AND `I18n__category_type`.`model` = 'Map' AND `I18n__category_type`.`field` = 'category_type' AND `I18n__category_type`.`locale` = 'ru') WHERE `Map`.`region_id` = 3 | 69 | 69 | 64 | maybe slow |
Peak Memory Use 5.61 MB
Message | Memory use |
---|---|
Component initialization | 1.49 MB |
Controller action start | 1.63 MB |
Controller render start | 2.69 MB |
View render complete | 3.23 MB |
Total Request Time: 477 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 142.84 | |
Event: Controller.initialize | 0.14 | |
Event: Controller.startup | 11.76 | |
Controller action | 231.88 | |
Event: Controller.beforeRender | 20.39 | |
» Processing toolbar data | 20.26 | |
Rendering View | 5.51 | |
» Event: View.beforeRender | 0.05 | |
» Rendering APP/View/Maps/view.ctp | 1.31 | |
» Event: View.afterRender | 0.04 | |
» Event: View.beforeLayout | 0.05 | |
» Rendering APP/View/Layouts/index.ctp | 1.19 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
APP | /var/www/vhosts/acqh.kz/new.acqh.kz/app/ |
APP_DIR | app |
APPLIBS | /var/www/vhosts/acqh.kz/new.acqh.kz/app/Lib/ |
CACHE | /var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/cache/ |
CAKE | /var/www/vhosts/acqh.kz/new.acqh.kz/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/vhosts/acqh.kz/new.acqh.kz/lib |
CORE_PATH | /var/www/vhosts/acqh.kz/new.acqh.kz/lib/ |
CAKE_VERSION | 2.6.2 |
CSS | /var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://acqh.kz |
IMAGES | /var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/logs/ |
ROOT | /var/www/vhosts/acqh.kz/new.acqh.kz |
TESTS | /var/www/vhosts/acqh.kz/new.acqh.kz/app/Test/ |
TMP | /var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/ |
VENDORS | /var/www/vhosts/acqh.kz/new.acqh.kz/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40 |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
Pp Custom Php Ini | /var/www/vhosts/system/acqh.kz/etc/php.ini |
Pp Custom Php Cgi Index | plesk-php56-fastcgi |
Script Name | /app/webroot/index.php |
Request Uri | /maps/view/almaty |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.0 |
Gateway Interface | CGI/1.1 |
Redirect Url | /app/webroot/maps/view/almaty |
Remote Port | 3402 |
Script Filename | /var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/index.php |
Server Admin | acofqh@yandex.kz |
Context Document Root | /var/www/vhosts/acqh.kz/new.acqh.kz |
Context Prefix | |
Request Scheme | https |
Document Root | /var/www/vhosts/acqh.kz/new.acqh.kz |
Remote Addr | 18.234.247.75 |
Server Port | 443 |
Server Addr | 195.210.46.38 |
Server Name | acqh.kz |
Server Software | Apache |
Server Signature | |
Http Accept Encoding | br,gzip |
Http If Modified Since | Fri, 07 Aug 2020 20:27:10 GMT |
Http Accept Language | en-US,en;q=0.5 |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
Http Connection | close |
Http X Real Ip | 18.234.247.75 |
Http Host | acqh.kz |
Https | on |
Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
Unique Id | YAx3XXCFdAs5-0NG11QtZAAAAD0 |
Redirect Status | 200 |
Redirect Https | on |
Redirect Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
Redirect Unique Id | YAx3XXCFdAs5-0NG11QtZAAAAD0 |
Redirect Redirect Status | 200 |
Redirect Redirect Https | on |
Redirect Redirect Perl5lib | /usr/share/awstats/lib:/usr/share/awstats/plugins |
Redirect Redirect Unique Id | YAx3XXCFdAs5-0NG11QtZAAAAD0 |
Fcgi Role | RESPONDER |
Php Self | /app/webroot/index.php |
Request Time Float | 1611429726.0505 |
Request Time | 1611429726 |