No post data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `CategoryMain`.`id`, `CategoryMain`.`name`, `CategoryMain`.`code`, `CategoryMain`.`cate1_id`, `CategoryMain`.`menu_image`, `CategoryMain`.`menu_ext`, `CategoryMain`.`digest_image`, `CategoryMain`.`digest_ext`, `CategoryMain`.`order_id`, `CategoryMain`.`sort`, `CategoryMain`.`created`, `CategoryMain`.`modified` FROM `marumasa_miyako_db`.`category_mains` AS `CategoryMain` WHERE `CategoryMain`.`code` = 'rentalcar' ORDER BY `CategoryMain`.`order_id` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Feature`.`id`, `Feature`.`comments` FROM `marumasa_miyako_db`.`features` AS `Feature` WHERE `Feature`.`enabled_flg` = 1 ORDER BY `Feature`.`order_id` ASC | 1 | 1 | 2 | maybe slow |
| SELECT `CategoryMain`.`id`, `CategoryMain`.`code`, `CategoryMain`.`name` FROM `marumasa_miyako_db`.`category_mains` AS `CategoryMain` WHERE `CategoryMain`.`code` = 'rentalcar' ORDER BY `CategoryMain`.`order_id` ASC LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `CategorySub`.`id`, `CategorySub`.`name`, `CategorySub`.`category_main_id` FROM `marumasa_miyako_db`.`category_subs` AS `CategorySub` WHERE `CategorySub`.`category_main_id` = (1) ORDER BY `CategorySub`.`order_id` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `Shop`.`id`, `Shop`.`shop_id`, `Shop`.`category_main_id`, `Shop`.`category_sub_id`, `Shop`.`category_purpose_id`, `Shop`.`name`, `Shop`.`sub_title`, `Shop`.`info`, `Shop`.`image_logo`, `Shop`.`image_logo_ext`, `Shop`.`image_main_image`, `Shop`.`image_main_ext`, `Shop`.`intro`, `CategoryMain`.`id`, `CategoryMain`.`code`, `CategoryMain`.`name`, `CategorySub`.`id`, `CategorySub`.`name` FROM `marumasa_miyako_db`.`shops` AS `Shop` LEFT JOIN `marumasa_miyako_db`.`category_mains` AS `CategoryMain` ON (`Shop`.`category_main_id` = `CategoryMain`.`id`) LEFT JOIN `marumasa_miyako_db`.`category_subs` AS `CategorySub` ON (`Shop`.`category_sub_id` = `CategorySub`.`id`) WHERE `Shop`.`category_main_id` = 1 AND `Shop`.`enabled_flg` = 1 ORDER BY rand() ASC | 21 | 21 | 3 | maybe slow |
| SELECT `CategoryPurpose`.`id`, `CategoryPurpose`.`name` FROM `marumasa_miyako_db`.`category_purposes` AS `CategoryPurpose` WHERE 1 = 1 ORDER BY `CategoryPurpose`.`id` ASC | 5 | 5 | 2 | maybe slow |
Peak Memory Use 9.71 MB
| Message | Memory use |
|---|---|
| Component initialization | 3.88 MB |
| Controller action start | 6.03 MB |
| Controller render start | 6.75 MB |
| View render complete | 8.15 MB |
Total Request Time: 133 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 34.55 | |
| Event: Controller.initialize | 26.09 | |
| Event: Controller.startup | 0.98 | |
| Controller action | 30.96 | |
| Event: Controller.beforeRender | 6.55 | |
| » Processing toolbar data | 6.44 | |
| Rendering View | 4.58 | |
| » Event: View.beforeRender | 0.04 | |
| » Rendering APP/View/Genres/index.ctp | 1.35 | |
| » » Rendering APP/View/Elements/get_current_location.ctp | 0.20 | |
| » Event: View.afterRender | 0.03 | |
| » Event: View.beforeLayout | 0.03 | |
| » Rendering APP/View/Layouts/default.ctp | 2.21 | |
| » » Rendering APP/View/Elements/seo.ctp | 0.27 | |
| » » Rendering APP/View/Elements/breadcrumb.ctp | 0.54 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/home/marumasa-miyako/cake_portal/app/Config/' |
| LOG_EMAIL_ERROR | 'log_email_error' |
| LOG_DEV | 'log_dev' |
| SITE_URL | 'https://miyakozima.net/' |
| SITE_URL2 | 'http://miyakozima.net/' |
| SUB_DOMAIN | 'marumasa-miyako' |
| SITE_TITLE | '宮古島ねっと' |
| COPYRIGHT | '2020 宮古島ねっと' |
| UP_FILE_ROOT | '/home/marumasa-miyako/public_html/' |
| UP_DIR_CATEGORY | '/home/marumasa-miyako/public_html/img/category/' |
| UP_DIR_ICON | '/home/marumasa-miyako/public_html/img/icon/' |
| UP_DIR_PAY | '/home/marumasa-miyako/public_html/img/pay/' |
| UP_DIR_ADVERTISE | '/home/marumasa-miyako/public_html/img/advertise/' |
| UP_DIR_FEATURE | '/home/marumasa-miyako/public_html/img/feature/' |
| UP_DIR_USER | '/home/marumasa-miyako/public_html/img/userdata/' |
| UP_DIR_USER_MARUMASA | '/home/marumasa-miyako/public_html/front/images/userdata/' |
| UP_LINK_USER_MARUMASA | 'https://miyakozima.net/front/images/userdata/' |
| UP_DIR_GIRL | '/home/marumasa-miyako/public_html/img/girl/' |
| UP_DIR_TMP | '/home/marumasa-miyako/cake_portal/app/webroot/img/tmp/' |
| UP_DIR_BLOG | '/home/marumasa-miyako/public_html/img/blog/' |
| UP_DIR_INFO | '/home/marumasa-miyako/public_html/img/info/' |
| UP_DIR_LINK | '/home/marumasa-miyako/public_html/img/link/' |
| CSV_DIR | '/home/marumasa-miyako/public_html//csv/' |
| PUBLIC_FLG_ON | (int) 1 |
| PUBLIC_FLG_OFF | (int) 0 |
| GOOGLE_MAP_API_KEY | '' |
| KEY_FILE_LOCATION | '' |
| VIEW_ID | '' |
| TRACKING_ID | '' |
| GOOGLE_CREDENTIALS | '' |
| PROPERTY_ID | '' |
| MAIL_FROM | 'no-reply@miyakozima.net' |
| MAIL_FROM_NAME | '宮古島ねっと' |
| RENT_DAY_CHANGE_TIME | (int) 15 |
| LANG_JA | 'ja' |
| LANG_EN | 'en' |
| LANG_CNH | 'cnh' |
| COURSE_DAY_TRIP | (int) 1 |
| COURSE_5HOUR | (int) 5 |
| COURSE_HALF_DAY | (int) 2 |
| COURSE_1DAY2NIGHT | (int) 3 |
| COURSE_LONG_TRIP | (int) 4 |
| COURSE_DRIVING | (int) 1 |
| COURSE_WALKING | (int) 2 |
| LV_ADVANCED | (int) 1 |
| LV_INTERMEDIATE | (int) 2 |
| LV_ELEMENTARY | (int) 3 |
| Constant | Value |
|---|---|
| APP | '/home/marumasa-miyako/cake_portal/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/home/marumasa-miyako/cake_portal/app/Lib/' |
| CACHE | '/home/marumasa-miyako/cake_portal/app/tmp/cache/' |
| CAKE | '/home/marumasa-miyako/cake_portal/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/home/marumasa-miyako/cake_portal/lib' |
| CORE_PATH | '/home/marumasa-miyako/cake_portal/lib/' |
| CAKE_VERSION | '2.10.20' |
| CSS | '/home/marumasa-miyako/cake_portal/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://marumasa-miyako.i-sys.in' |
| IMAGES | '/home/marumasa-miyako/cake_portal/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/home/marumasa-miyako/cake_portal/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/home/marumasa-miyako/cake_portal/app/tmp/logs/' |
| ROOT | '/home/marumasa-miyako/cake_portal' |
| TESTS | '/home/marumasa-miyako/cake_portal/app/Test/' |
| TMP | '/home/marumasa-miyako/cake_portal/app/tmp/' |
| VENDORS | '/home/marumasa-miyako/cake_portal/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/home/marumasa-miyako/cake_portal/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '5.6.40' |
| User | 'apache' |
| Home | '/usr/share/httpd' |
| Fcgi Role | 'RESPONDER' |
| Redirect From Cloudfront | '1' |
| Redirect Unique Id | 'ajZqJCWzRtAaBE1CD0ZV_AAAAAw' |
| Redirect Ngx Cache Nocachemode | 'off' |
| Redirect Ngx Cache Staticmode | '1' |
| Redirect Https | 'on' |
| Redirect Ssl Tls Sni | 'marumasa-miyako.i-sys.in' |
| Redirect Status | '200' |
| From Cloudfront | '1' |
| Unique Id | 'ajZqJCWzRtAaBE1CD0ZV_AAAAAw' |
| Ngx Cache Nocachemode | 'off' |
| Ngx Cache Staticmode | '1' |
| Https | 'on' |
| Ssl Tls Sni | 'marumasa-miyako.i-sys.in' |
| Proxy-nokeepalive | '1' |
| Http Host | 'marumasa-miyako.i-sys.in' |
| Http X From Cloudfront | 'isys-access' |
| Http Accept | '*/*' |
| Http Accept Encoding | 'gzip, br, zstd, deflate' |
| Http Connection | 'keep-alive' |
| Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
| Http Via | '2.0 8693090c9bc8f44fd1010f18b33c0528.cloudfront.net (CloudFront)' |
| Http X Amz Cf Id | 'xx3U9akpshlGte6qgWOeBE1AsxtEhTqWobH-t88c0cATON7PRRaLAg==' |
| Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin' |
| Server Signature | '' |
| Server Software | 'Apache' |
| Server Name | 'marumasa-miyako.i-sys.in' |
| Server Addr | '172.31.24.38' |
| Server Port | '443' |
| Remote Addr | '216.73.217.94' |
| Document Root | '/home/marumasa-miyako/public_html' |
| Request Scheme | 'https' |
| Context Prefix | '' |
| Context Document Root | '/home/marumasa-miyako/public_html' |
| Server Admin | 'root@localhost' |
| Script Filename | '/home/marumasa-miyako/public_html/index.php' |
| Remote Port | '54332' |
| Redirect Url | '/rentalcar/' |
| Redirect Query String | 'url=rentalcar/&page=3' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | 'url=rentalcar/&page=3' |
| Request Uri | '/rentalcar/?page=3' |
| Script Name | '/index.php' |
| Php Self | '/index.php' |
| Request Time Float | (float) 1781951012.2382 |
| Request Time | (int) 1781951012 |