クーポンコード
CL10%
2万円(税抜)以上のご注文で使用できる会員様限定10%OFFクーポンです
クーポンコードをご注文の際、お客様情報入力画面にご入力ください
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 0 | 0 | 0 | |
SELECT `Post`.`post_url`, `Post`.`code` FROM `posts` AS `Post` WHERE `post_url` != '' AND `post_div` = 1 AND `Post`.`delete_flg` = '0' | 0 | 0 | 0 | |
SELECT `OperationSetting`.`id`, `OperationSetting`.`code`, `OperationSetting`.`controller`, `OperationSetting`.`value`, `OperationSetting`.`created_user`, `OperationSetting`.`created`, `OperationSetting`.`modified_user`, `OperationSetting`.`modified`, `OperationSetting`.`delete_flg` FROM `kalmor_stg`.`operation_settings` AS `OperationSetting` WHERE `OperationSetting`.`delete_flg` = '0' | 585 | 585 | 2 | |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 1 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` IS NULL AND `Basket`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 1 | maybe slow |
BEGIN | ||||
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '515a2c08-98a1-4c7c-aa38-e5ec0034afd4' | 1 | 1 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '515a2c08-98a1-4c7c-aa38-e5ec0034afd4' | 1 | 1 | 0 | |
INSERT INTO `kalmor_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('515a2c08-98a1-4c7c-aa38-e5ec0034afd4', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2025-06-17 17:12:17', '2025-06-17 17:12:17', '-') | 1 | 1 | 4 | maybe slow |
COMMIT | ||||
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 0 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '515a2c08-98a1-4c7c-aa38-e5ec0034afd4' AND `Basket`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-17' AND `TaxRate`.`tax_div` = 1 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-17' AND `TaxRate`.`tax_div` = 2 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg` FROM `kalmor_stg`.`pages` AS `Page` WHERE `code` = 'search_condition' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `PagePart`.`id`, `PagePart`.`page_id`, `PagePart`.`part_id`, `PagePart`.`display_section_div`, `PagePart`.`display_order`, `PagePart`.`content`, `PagePart`.`created_user`, `PagePart`.`created`, `PagePart`.`modified_user`, `PagePart`.`modified`, `PagePart`.`delete_flg`, `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg`, `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `kalmor_stg`.`page_parts` AS `PagePart` LEFT JOIN `kalmor_stg`.`pages` AS `Page` ON (`PagePart`.`page_id` = `Page`.`id` AND `Page`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`parts` AS `Part` ON (`PagePart`.`part_id` = `Part`.`id` AND `Part`.`delete_flg` = '0') WHERE `page_id` = '5bc72a12-592c-4036-9fd6-1402fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 3 | 3 | 1 | maybe slow |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-17 17:12:17' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND ((`ItemCategory`.`parent_category_tree` IS NULL) OR (`ItemCategory`.`parent_category_tree` = '')) AND `ItemCategory`.`delete_flg` = '0' AND ((`ItemCategory`.`only_bussiness_flg` = '0') OR (`ItemCategory`.`only_bussiness_flg` IS NULL) OR (`ItemCategory`.`only_bussiness_flg` = '0')) ORDER BY `ItemCategory`.`display_order` ASC | 14 | 14 | 1 | maybe slow |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-17 17:12:17' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 2 AND ((`ItemCategory`.`parent_category_tree` IS NULL) OR (`ItemCategory`.`parent_category_tree` = '')) AND `ItemCategory`.`delete_flg` = '0' AND ((`ItemCategory`.`only_bussiness_flg` = '0') OR (`ItemCategory`.`only_bussiness_flg` IS NULL) OR (`ItemCategory`.`only_bussiness_flg` = '0')) ORDER BY `display_order` asc | 0 | 0 | 1 | maybe slow |
2 duplicate queries run.
Peak Memory Use 12.71 MB
Message | Memory use |
---|---|
Component initialization | 6.44 MB |
Controller action start | 10.58 MB |
Controller render start | 10.73 MB |
View render complete | 12.20 MB |
Total Request Time: 177 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 57.01 | |
Event: Controller.initialize | 50.22 | |
Event: Controller.startup | 1.26 | |
Controller action | 7.93 | |
Event: Controller.beforeRender | 1.35 | |
» Processing toolbar data | 1.25 | |
Rendering View | 38.26 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Front/SearchCondition/index.ctp | 1.20 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Front/Layouts/default.ctp | 36.36 | |
» » Rendering APP/View/Front/Elements/gtmHeadCode.ctp | 0.40 | |
» » Rendering APP/View/Front/Elements/gaTrackingCode.ctp | 1.06 | |
» » Rendering APP/View/Front/Elements/gtmBodyCode.ctp | 0.34 | |
» » Rendering APP/View/Front/Elements/parts_header_kalmor.ctp | 1.79 | |
» » Rendering APP/View/Front/Elements/parts_footer.ctp | 0.31 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/home/kalmor/www/app/Config/' |
FILTER_VALIDATE_BOOL | (int) 258 |
Constant | Value |
---|---|
APP | '/home/kalmor/www/app/' |
APP_DIR | 'app' |
APPLIBS | '/home/kalmor/www/app/Lib/' |
CACHE | '/home/kalmor/www/app/tmp/cache/' |
CAKE | '/home/kalmor/www/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/home/kalmor/www/lib' |
CORE_PATH | '/home/kalmor/www/lib/' |
CAKE_VERSION | '2.10.24' |
CSS | '/home/kalmor/www/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'https://kalmor-staging.evercart.jp' |
IMAGES | '/home/kalmor/www/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/home/kalmor/www/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/home/kalmor/www/app/tmp/logs/' |
ROOT | '/home/kalmor/www' |
TESTS | '/home/kalmor/www/app/Test/' |
TMP | '/home/kalmor/www/app/tmp/' |
VENDORS | '/home/kalmor/www/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/home/kalmor/www/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '7.4.30' |
User | 'apache' |
Home | '/usr/share/httpd' |
Script Name | '/index.php' |
Request Uri | '/search_condition' |
Query String | '' |
Request Method | 'GET' |
Server Protocol | 'HTTP/1.1' |
Gateway Interface | 'CGI/1.1' |
Redirect Url | '/search_condition' |
Remote Port | '37161' |
Script Filename | '/home/kalmor/www/app/webroot/index.php' |
Server Admin | 'root@localhost' |
Context Document Root | '/home/kalmor/www/app/webroot' |
Context Prefix | '' |
Request Scheme | 'https' |
Document Root | '/home/kalmor/www/app/webroot' |
Remote Addr | '216.73.216.218' |
Server Port | '443' |
Server Addr | '10.0.1.20' |
Server Name | 'kalmor-staging.evercart.jp' |
Server Software | 'Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1k' |
Server Signature | '' |
Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin' |
Http Host | 'kalmor-staging.evercart.jp' |
Http Accept Encoding | 'gzip, br, zstd, deflate' |
Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
Http Accept | '*/*' |
Proxy-nokeepalive | '1' |
Ssl Tls Sni | 'kalmor-staging.evercart.jp' |
Https | 'on' |
Unique Id | 'aFEjYSgBxYCvQ5c252jPTQAAARE' |
Redirect Status | '200' |
Redirect Ssl Tls Sni | 'kalmor-staging.evercart.jp' |
Redirect Https | 'on' |
Redirect Unique Id | 'aFEjYSgBxYCvQ5c252jPTQAAARE' |
Fcgi Role | 'RESPONDER' |
Php Self | '/index.php' |
Request Time Float | (float) 1750147937.3518 |
Request Time | (int) 1750147937 |