Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `ReformCategory`.`id` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`photo`, `Article`.`subject`, `Article`.`summary`, `Article`.`reform_category_id`, `ReformCategory`.`name`, `ReformCategory`.`id` FROM `riho`.`articles` AS `Article` LEFT JOIN `riho`.`reform_categories` AS `ReformCategory` ON (`Article`.`reform_category_id` = `ReformCategory`.`id`) WHERE `Article`.`valid_flg` = '1' AND reform_category_id = (66) ORDER BY `Article`.`date` DESC LIMIT 15 | 15 | 15 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `riho`.`articles` AS `Article` LEFT JOIN `riho`.`reform_categories` AS `ReformCategory` ON (`Article`.`reform_category_id` = `ReformCategory`.`id`) WHERE `Article`.`valid_flg` = '1' AND reform_category_id = (66) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`subject`, `Article`.`photo`, `ReformCategory`.`name`, `ReformCategory`.`id` FROM `riho`.`articles` AS `Article` LEFT JOIN `riho`.`reform_categories` AS `ReformCategory` ON (`Article`.`reform_category_id` = `ReformCategory`.`id`) WHERE `Article`.`valid_flg` = '1' ORDER BY `date` DESC, `Article`.`date` DESC LIMIT 6 | 6 | 6 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 1 | 1 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 2 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 3 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 4 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 2 | 2 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`type`, `ReformCategory`.`sort`, `ReformCategory`.`name`, `ReformCategory`.`photo`, `ReformCategory`.`valid_flg`, `ReformCategory`.`created`, `ReformCategory`.`modified` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `type` = 5 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 1 | 1 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 2 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 3 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 4 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 2 | 2 | 0 | |
SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 5 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC | 4 | 4 | 0 | |
SELECT `RihoCounter`.`id`, `RihoCounter`.`begind`, `RihoCounter`.`endd`, `RihoCounter`.`subject`, `RihoCounter`.`direct_url`, `RihoCounterArea`.`id`, `RihoCounterArea`.`name`, `RihoCounterArea`.`color` FROM `riho`.`riho_counters` AS `RihoCounter` LEFT JOIN `riho`.`riho_counter_areas` AS `RihoCounterArea` ON (`RihoCounter`.`riho_counter_area_id` = `RihoCounterArea`.`id`) WHERE `RihoCounter`.`valid_flg` = '1' AND ((((`RihoCounter`.`opend` IS NULL) OR (`RihoCounter`.`opend` <= '2021-03-06'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-03-06')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'RihoCounter' AND `model_id` IN (838, 839, 840, 841, 842, 843) | 6 | 6 | 0 |
Peak Memory Use 2.85 MB
Message | Memory use |
---|---|
Component initialization | 1.27 MB |
Controller action start | 1.60 MB |
Controller render start | 1.99 MB |
View render complete | 2.72 MB |
Total Request Time: 44 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.35 | |
Event: Controller.initialize | 1.52 | |
Event: Controller.startup | 0.14 | |
Controller action | 11.77 | |
Event: Controller.beforeRender | 1.26 | |
» Processing toolbar data | 1.17 | |
Rendering View | 18.88 | |
» Event: View.beforeRender | 0.29 | |
» Rendering APP/View/Articles/index.ctp | 7.59 | |
» » Rendering APP/View/Elements/Web/breadcrumb.ctp | 0.22 | |
» » Rendering APP/View/Articles/_articles.ctp | 1.16 | |
» » Rendering APP/View/Elements/Web/pagination.ctp | 0.26 | |
» » Rendering APP/View/Articles/_new.ctp | 0.46 | |
» » Rendering APP/View/Articles/_category_list.ctp | 5.12 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/default.ctp | 10.74 | |
» » Rendering APP/View/Elements/Web/gdn_code.ctp | 0.02 | |
» » Rendering APP/View/Elements/Web/header.ctp | 0.27 | |
» » » Rendering APP/View/Elements/Web/link.ctp | 0.17 | |
» » » Rendering APP/View/Elements/Web/phone.ctp | 0.02 | |
» » Rendering APP/View/Elements/Web/nav_pc.ctp | 0.23 | |
» » Rendering APP/View/Elements/Web/nav_sp.ctp | 0.24 | |
» » Rendering APP/View/Elements/Web/article_link.ctp | 3.37 | |
» » Rendering APP/View/Elements/Web/events.ctp | 5.80 | |
» » Rendering APP/View/Elements/Web/footer.ctp | 0.30 | |
» » » Rendering APP/View/Elements/Web/link.ctp #2 | 0.17 | |
» » » Rendering APP/View/Elements/Web/phone2.ctp | 0.03 | |
» » Rendering APP/View/Elements/Web/ydn_code.ctp | 0.02 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/var/www/riho2/app/Config/' |
USE_DEBUGLIB | true |
FILE_STORAGE_STORE_PATH | '/var/www/riho2/app/tmp/FileStorage/' |
AJAX_FILE_UPLOAD_WRAPPER_SUFFIX | '_wrapper' |
AJAX_FILE_UPLOAD_FILE_FIELD_SUFFIX | '_ajax' |
AJAX_FILE_UPLOAD_HIDDEN_FIELD_SUFFIX | '_cash' |
AJAX_FILE_UPLOAD_CASH_MODEL_ID | 'cash' |
AJAX_FILE_UPLOAD_FILE_PATH | '/var/www/riho2/app/tmp/files/' |
AJAX_FILE_UPLOAD_TMP_PATH | '/var/www/riho2/app/tmp/files/cache/' |
BLOCK_CONTENTS_PLUGIN_NAME | 'BlockContents' |
EXPORT_PATH | '/tmp/' |
DEFAULT_CONFIG | 'default' |
BACKUP_ROTATE | (int) 3 |
FILE_STORAGE_TEMPORARY | '/var/www/riho2/app/tmp/FileStorageTmp/' |
FILE_STORAGE_STRAGETYPE_LOCAL | 'local' |
FILE_STORAGE_STRAGETYPE_S3 | 's3' |
SECURIMAGE_PATH | '/var/www/riho2/app/Plugin/Securimage/' |
TINYMCE_PLUGIN_NAME | 'TinyMce' |
SITE_TITLE | 'リフォームならRiho(リホ)|福岡・北九州・山口・佐賀・大分で展開中' |
ADMIN_SITE_TITLE | 'Riho管理サイト' |
SENDER_ADDRESS | 'sender@ri-ho.jp' |
SENDER_NAME | 'RIHO' |
CATEGORY_TYPE_FAMILY_STRUCTURE | (int) 1 |
CATEGORY_TYPE_AGE | (int) 2 |
CATEGORY_TYPE_LIFESTAGE | (int) 3 |
CATEGORY_TYPE_POPULATED_PLACE | (int) 4 |
CATEGORY_TYPE_RESIDENCE_STATUS | (int) 5 |
CATEGORY_TYPE_LIFESTYLE | (int) 6 |
CATEGORY_TYPE_REPAIR | (int) 7 |
CATEGORY_TYPE_REFRESH | (int) 8 |
CATEGORY_TYPE_REFORM | (int) 9 |
CATEGORY_TYPE_TASTE | (int) 10 |
CATEGORY_TYPE_FACULTY | (int) 11 |
CATEGORY_TYPE_MEISTER_WORK | (int) 12 |
EVENT_TYPE_OPENHOUSE | (int) 1 |
EVENT_TYPE_EVENT | (int) 2 |
BUILDER_TYPE_AREA | (int) 1 |
BUILDER_TYPE_LARGE | (int) 2 |
BUILDER_TYPE_PERSONAL | (int) 3 |
BUILDER_TYPE_SPEED | (int) 4 |
ADVISER_NEW_CREATED | '-14 day' |
ADVISER_NEW_LABEL | '登録2週間以内!' |
ADVISER_HOT_PORTFOLIO_COUNT | (int) 20 |
FILEBINDER_FILE_PATH | '/var/www/riho2/app/tmp/file/' |
FILEBINDER_TMP_PATH | '/var/www/riho2/app/tmp/file/cache/' |
FILEBINDER_FILE_FIELD_SUFFIX | '_buffer' |
FILEBINDER_FILE_FIELD_DELETE | 'delete_' |
REFORM_CATEGORY_TYPE_ALL | (int) 1 |
REFORM_CATEGORY_TYPE_WATER | (int) 2 |
REFORM_CATEGORY_TYPE_OUTER | (int) 3 |
REFORM_CATEGORY_TYPE_ROOM | (int) 4 |
REFORM_CATEGORY_TYPE_OTHER | (int) 5 |
MAIN_AREA_COOKIE_NAME | 'main_area_id' |
MAIN_AREA_COOKIE_LIFETIME | '+1 month' |
REFORM_PACK_COOKIE_NAME | 'REFORM_PACK' |
INQUIRY_SUMMARY_SESSION_NAME | 'Inquiry.summary' |
CONTACT_TYPE_KITAKYUSHU | (int) 1 |
RIHO_COUNTER_URL | 'http://riho2.ri-ho.jp/riho_counter' |
RIHO_EVENT_URL | 'http://event.ri-ho.jp/' |
CONTENT_IMAGE_BASE_URL | '/images/upload/articles' |
CONTENT_IMAGE_BASE_PATH | '/var/www/riho2/app/webroot/images/upload/articles' |
REFORM_PACK_URL | 'pdf/De-Repa_2017-03-27.pdf' |
RIHO_COUNTER_COUNT | (int) 6 |
GOOGLE_MAP_API_KEY | 'AIzaSyAoakoSB5NvntNjtfnjBmgNr4v8vqa9wkI' |
GOOD_VALUE_KIND_MAKER_CAMPAIGN | (int) 1 |
GOOD_VALUE_KIND_EVENT | (int) 2 |
GOOD_VALUE_KIND_PACK | (int) 3 |
INSTAGRAM_URL | 'https://www.instagram.com/reformpotal/' |
USE_TRUE | (int) 1 |
USE_FALSE | (int) 2 |
DENHITI_REQUEST_KIND_1 | (int) 1 |
DENHITI_REQUEST_KIND_2 | (int) 2 |
DENHITI_REQUEST_KIND_3 | (int) 3 |
DENHITI_REQUEST_OPTION_1 | (int) 1 |
DENHITI_REQUEST_OPTION_2 | (int) 2 |
DENHITI_REQUEST_OPTION_3 | (int) 3 |
DENHITI_REQUEST_OPTION_4 | (int) 4 |
DENHITI_REQUEST_OPTION_5 | (int) 5 |
DENHITI_REQUEST_OPTION_6 | (int) 6 |
DENHITI_REQUEST_OPTION_7 | (int) 7 |
PORTFOLIOS_COUNT | '2,000' |
FOUNDING_YEARS | '139' |
Constant | Value |
---|---|
APP | '/var/www/riho2/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/riho2/app/Lib/' |
CACHE | '/var/www/riho2/app/tmp/cache/' |
CAKE | '/var/www/riho2/Vendor/cakephp/cakephp/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/riho2/Vendor/cakephp/cakephp/lib' |
CORE_PATH | '/var/www/riho2/Vendor/cakephp/cakephp/lib/' |
CAKE_VERSION | '2.10.20' |
CSS | '/var/www/riho2/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'http://riho2.ri-ho.jp' |
IMAGES | '/var/www/riho2/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/riho2/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/riho2/app/tmp/logs/' |
ROOT | '/var/www/riho2' |
TESTS | '/var/www/riho2/app/Test/' |
TMP | '/var/www/riho2/app/tmp/' |
VENDORS | '/var/www/riho2/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/riho2/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '7.3.17' |
Redirect Redirect Unique Id | 'YEONz878CYj4@QuM7xIlzgAAAAI' |
Redirect Redirect Cake Env Mode | 'riho2' |
Redirect Redirect Status | '200' |
Redirect Unique Id | 'YEONz878CYj4@QuM7xIlzgAAAAI' |
Redirect Cake Env Mode | 'riho2' |
Redirect Status | '200' |
Unique Id | 'YEONz878CYj4@QuM7xIlzgAAAAI' |
Cake Env Mode | 'riho2' |
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 If Modified Since | 'Wed, 02 Dec 2020 15:41:26 GMT' |
Http Accept Encoding | 'br,gzip' |
Http Host | 'riho2.ri-ho.jp' |
Http Connection | 'Keep-Alive' |
Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin' |
Server Signature | '' |
Server Software | 'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.17' |
Server Name | 'riho2.ri-ho.jp' |
Server Addr | '153.127.48.136' |
Server Port | '80' |
Remote Addr | '3.220.231.235' |
Document Root | '/var/www/riho2' |
Request Scheme | 'http' |
Context Prefix | '' |
Context Document Root | '/var/www/riho2' |
Server Admin | 'root@localhost' |
Script Filename | '/var/www/riho2/app/webroot/index.php' |
Remote Port | '35898' |
Redirect Query String | 'reform_category_type=1' |
Redirect Url | '/app/webroot/articles' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | 'reform_category_type=1' |
Request Uri | '/articles?reform_category_type=1' |
Script Name | '/app/webroot/index.php' |
Php Self | '/app/webroot/index.php' |
Request Time Float | (float) 1615039951.053 |
Request Time | (int) 1615039951 |