ほげｈごｇへおｇへおげげｆｄｆｄｆｄｆｄｆｄｆｄｆ
test222.webp)
ほげｈごｇへおｇへおげげｆｄｆｄｆｄｆｄｆｄｆｄｆ
test222
Cake Params
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
default
Total Time: 29 ms
Total Queries: 14 queries
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`name`, `WatchBrand`.`id` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 14 | 14 | 0 | |
| SELECT `BridalBrand`.`slug`, `BridalBrand`.`thumbnail`, `BridalBrand`.`name`, `BridalBrand`.`id` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 14 | 14 | 0 | |
| SELECT `JewelryBrand`.`slug`, `JewelryBrand`.`thumbnail`, `JewelryBrand`.`name`, `JewelryBrand`.`id` FROM `yamashiro`.`jewelry_brands` AS `JewelryBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 9 | 9 | 0 | |
| SELECT `Content`.`id`, `Content`.`name`, `Content`.`content`, `Content`.`type`, `Content`.`enabled` FROM `yamashiro`.`contents` AS `Content` WHERE `Content`.`type` = 'HeadNews' AND `Content`.`enabled` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled` FROM `yamashiro`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`slug` = 'test' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id` FROM `yamashiro`.`watches` AS `Watch` WHERE `Watch`.`enabled` = '1' AND `Watch`.`watch_brand_id` = (68) ORDER BY `Watch`.`order` DESC | 0 | 0 | 1 | maybe slow |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`watch_brand_id` = (68) ORDER BY `WatchModel`.`order` DESC | 0 | 0 | 0 | |
| SELECT `Store`.`id`, `Store`.`name`, `WatchBrandsStore`.`id`, `WatchBrandsStore`.`watch_brand_id`, `WatchBrandsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`watch_brands_stores` AS `WatchBrandsStore` ON (`WatchBrandsStore`.`watch_brand_id` = 68 AND `WatchBrandsStore`.`store_id` = `Store`.`id`) | 2 | 2 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`watches` AS `Watch` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`store_id` IN (1, 3) AND `WatchesStore`.`watch_id` = `Watch`.`id`) | 1362 | 1362 | 13 | |
| SELECT `Bridal`.`id`, `Bridal`.`name`, `Bridal`.`slug`, `Bridal`.`image01`, `Bridal`.`image02`, `Bridal`.`image03`, `Bridal`.`image04`, `Bridal`.`image05`, `Bridal`.`image06`, `Bridal`.`image07`, `Bridal`.`image08`, `Bridal`.`price`, `Bridal`.`credit_flg`, `Bridal`.`sold_out`, `Bridal`.`credit_number`, `Bridal`.`credit_amount`, `Bridal`.`description`, `Bridal`.`new`, `Bridal`.`recommend`, `Bridal`.`order`, `Bridal`.`order_all`, `Bridal`.`order_top_pickup`, `Bridal`.`order_brand_pickup`, `Bridal`.`tag_title`, `Bridal`.`tag_description`, `Bridal`.`tag_keyword`, `Bridal`.`blog_slug_1`, `Bridal`.`blog_slug_2`, `Bridal`.`blog_slug_3`, `Bridal`.`blog_slug_4`, `Bridal`.`is_pickupable`, `Bridal`.`is_brand_pickupable`, `Bridal`.`is_marriage`, `Bridal`.`is_engagement`, `Bridal`.`enabled`, `Bridal`.`modified`, `Bridal`.`created`, `Bridal`.`bridal_brand_id`, `Bridal`.`bridal_model_id`, `BridalsStore`.`id`, `BridalsStore`.`bridal_id`, `BridalsStore`.`store_id` FROM `yamashiro`.`bridals` AS `Bridal` JOIN `yamashiro`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`store_id` IN (1, 3) AND `BridalsStore`.`bridal_id` = `Bridal`.`id`) | 723 | 723 | 6 | |
| SELECT `Jewelry`.`id`, `Jewelry`.`slug`, `Jewelry`.`name`, `Jewelry`.`image01`, `Jewelry`.`image02`, `Jewelry`.`image03`, `Jewelry`.`image04`, `Jewelry`.`image05`, `Jewelry`.`image06`, `Jewelry`.`image07`, `Jewelry`.`image08`, `Jewelry`.`price`, `Jewelry`.`credit_flg`, `Jewelry`.`sold_out`, `Jewelry`.`credit_number`, `Jewelry`.`credit_amount`, `Jewelry`.`description`, `Jewelry`.`new`, `Jewelry`.`recommend`, `Jewelry`.`order`, `Jewelry`.`order_all`, `Jewelry`.`order_top_pickup`, `Jewelry`.`order_brand_pickup`, `Jewelry`.`tag_title`, `Jewelry`.`tag_description`, `Jewelry`.`tag_keyword`, `Jewelry`.`blog_slug_1`, `Jewelry`.`blog_slug_2`, `Jewelry`.`blog_slug_3`, `Jewelry`.`blog_slug_4`, `Jewelry`.`is_pickupable`, `Jewelry`.`is_brand_pickupable`, `Jewelry`.`enabled`, `Jewelry`.`modified`, `Jewelry`.`created`, `Jewelry`.`jewelry_brand_id`, `Jewelry`.`jewelry_model_id`, `JewelryStore`.`id`, `JewelryStore`.`jewelry_id`, `JewelryStore`.`store_id` FROM `yamashiro`.`jewelries` AS `Jewelry` JOIN `yamashiro`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`store_id` IN (1, 3) AND `JewelryStore`.`jewelry_id` = `Jewelry`.`id`) | 719 | 719 | 6 | |
| SELECT `BridalBrand`.`id`, `BridalBrand`.`name`, `BridalBrand`.`slug`, `BridalBrand`.`thumbnail`, `BridalBrand`.`cover_images`, `BridalBrand`.`banner`, `BridalBrand`.`banner_text`, `BridalBrand`.`campaign_text`, `BridalBrand`.`order`, `BridalBrand`.`tag_title`, `BridalBrand`.`tag_description`, `BridalBrand`.`tag_keyword`, `BridalBrand`.`enabled`, `BridalBrandsStore`.`id`, `BridalBrandsStore`.`bridal_brand_id`, `BridalBrandsStore`.`store_id` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` JOIN `yamashiro`.`bridal_brands_stores` AS `BridalBrandsStore` ON (`BridalBrandsStore`.`store_id` IN (1, 3) AND `BridalBrandsStore`.`bridal_brand_id` = `BridalBrand`.`id`) | 22 | 22 | 1 | |
| SELECT `JewelryBrand`.`id`, `JewelryBrand`.`name`, `JewelryBrand`.`slug`, `JewelryBrand`.`thumbnail`, `JewelryBrand`.`cover_images`, `JewelryBrand`.`banner`, `JewelryBrand`.`banner_text`, `JewelryBrand`.`campaign_text`, `JewelryBrand`.`order`, `JewelryBrand`.`tag_title`, `JewelryBrand`.`tag_description`, `JewelryBrand`.`tag_keyword`, `JewelryBrand`.`enabled`, `JewelryBrandsStore`.`id`, `JewelryBrandsStore`.`jewelry_brand_id`, `JewelryBrandsStore`.`store_id` FROM `yamashiro`.`jewelry_brands` AS `JewelryBrand` JOIN `yamashiro`.`jewelry_brands_stores` AS `JewelryBrandsStore` ON (`JewelryBrandsStore`.`store_id` IN (1, 3) AND `JewelryBrandsStore`.`jewelry_brand_id` = `JewelryBrand`.`id`) | 11 | 11 | 0 | |
| SELECT `Watch`.`id`, `Watch`.`slug`, `Watch`.`name`, `Watch`.`image01`, `Watch`.`image02`, `Watch`.`image03`, `Watch`.`image04`, `Watch`.`image05`, `Watch`.`image06`, `Watch`.`image07`, `Watch`.`image08`, `Watch`.`price`, `Watch`.`credit_flg`, `Watch`.`sold_out`, `Watch`.`credit_number`, `Watch`.`credit_amount`, `Watch`.`description`, `Watch`.`new`, `Watch`.`recommend`, `Watch`.`order`, `Watch`.`order_all`, `Watch`.`order_top_pickup`, `Watch`.`order_brand_pickup`, `Watch`.`tag_title`, `Watch`.`tag_description`, `Watch`.`tag_keyword`, `Watch`.`blog_slug_1`, `Watch`.`blog_slug_2`, `Watch`.`blog_slug_3`, `Watch`.`blog_slug_4`, `Watch`.`is_pickupable`, `Watch`.`is_brand_pickupable`, `Watch`.`enabled`, `Watch`.`modified`, `Watch`.`created`, `Watch`.`watch_brand_id`, `Watch`.`watch_model_id`, `WatchBrand`.`id`, `WatchBrand`.`name`, `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`cover_images`, `WatchBrand`.`banner`, `WatchBrand`.`banner_text`, `WatchBrand`.`campaign_text`, `WatchBrand`.`order`, `WatchBrand`.`tag_title`, `WatchBrand`.`tag_description`, `WatchBrand`.`tag_keyword`, `WatchBrand`.`enabled`, `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro`.`watches` AS `Watch` LEFT JOIN `yamashiro`.`watch_brands` AS `WatchBrand` ON (`Watch`.`watch_brand_id` = `WatchBrand`.`id`) LEFT JOIN `yamashiro`.`watch_models` AS `WatchModel` ON (`Watch`.`watch_model_id` = `WatchModel`.`id`) WHERE `Watch`.`watch_brand_id` = 68 AND `Watch`.`is_brand_pickupable` = '1' ORDER BY `Watch`.`order_brand_pickup` desc, `Watch`.`order` desc | 0 | 0 | 2 | maybe slow |
Query Explain:
Peak Memory Use 26.76 MB
| Message | Memory use |
|---|---|
| Component initialization | 770 KB |
| Controller action start | 1.30 MB |
| Controller render start | 21.12 MB |
| View render complete | 21.26 MB |
Total Request Time: 310 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.77 | |
| Event: Controller.initialize | 11.86 | |
| Event: Controller.startup | 0.46 | |
| Controller action | 267.75 | |
| Event: Controller.beforeRender | 2.60 | |
| » Processing toolbar data | 2.46 | |
| Rendering View | 3.15 | |
| » Event: View.beforeRender | 0.05 | |
| » Rendering APP/View/Front/WatchBrands/view.ctp | 1.21 | |
| » » Rendering APP/View/Elements/pickup_watch.ctp | 0.13 | |
| » » Rendering APP/View/Elements/watch_search.ctp | 0.08 | |
| » » Rendering APP/View/Elements/popup_slider.ctp | 0.11 | |
| » Event: View.afterRender | 0.04 | |
| » Event: View.beforeLayout | 0.03 | |
| » Rendering APP/View/Layouts/front.ctp | 0.99 | |
| » » Rendering APP/View/Elements/header.ctp | 0.47 | |
| » » » Rendering APP/View/Elements/headnews.ctp | 0.07 | |
| » » » Rendering APP/View/Elements/headnews.ctp #2 | 0.06 | |
| » » Rendering APP/View/Elements/footer.ctp | 0.07 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | /var/www/site/yamashiro93-com/public_html/app/Config/ |
| Constant | Value |
|---|---|
| APP | /var/www/site/yamashiro93-com/public_html/app/ |
| APP_DIR | app |
| APPLIBS | /var/www/site/yamashiro93-com/public_html/app/Lib/ |
| CACHE | /var/www/site/yamashiro93-com/public_html/app/tmp/cache/ |
| CAKE | /var/www/site/yamashiro93-com/public_html/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/site/yamashiro93-com/public_html/lib |
| CORE_PATH | /var/www/site/yamashiro93-com/public_html/lib/ |
| CAKE_VERSION | 2.10.13 |
| CSS | /var/www/site/yamashiro93-com/public_html/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://yamashiro93-com.stylesv.net |
| IMAGES | /var/www/site/yamashiro93-com/public_html/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/site/yamashiro93-com/public_html/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/site/yamashiro93-com/public_html/app/tmp/logs/ |
| ROOT | /var/www/site/yamashiro93-com/public_html |
| TESTS | /var/www/site/yamashiro93-com/public_html/app/Test/ |
| TMP | /var/www/site/yamashiro93-com/public_html/app/tmp/ |
| VENDORS | /var/www/site/yamashiro93-com/public_html/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/site/yamashiro93-com/public_html/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 7.4.33 |
| User | styleweb |
| Home | /home/styleweb |
| Script Name | /app/webroot/index.php |
| Request Uri | /watch_brands/test |
| Query String | |
| Request Method | GET |
| Server Protocol | HTTP/1.1 |
| Gateway Interface | CGI/1.1 |
| Redirect Url | /app/webroot/watch_brands/test |
| Remote Port | 38105 |
| Script Filename | /var/www/site/yamashiro93-com/public_html/app/webroot/index.php |
| Server Admin | miyazato@styleweb.me |
| Context Document Root | /var/www/site/yamashiro93-com/public_html |
| Context Prefix | |
| Request Scheme | https |
| Document Root | /var/www/site/yamashiro93-com/public_html |
| Remote Addr | 216.73.216.195 |
| Server Port | 443 |
| Server Addr | 153.126.190.47 |
| Server Name | yamashiro93-com.stylesv.net |
| Server Software | Apache |
| Server Signature | |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
| Http Host | yamashiro93-com.stylesv.net |
| 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 | yamashiro93-com.stylesv.net |
| Https | on |
| Wpcommentdeny | 1 |
| Wploginnolimit | 1 |
| Allowrestapi | 1 |
| Ngx Cache Staticmode | 1 |
| Ngx Cache Nocachemode | off |
| Unique Id | aEVmQbsDWDx@d2SQyBeRSwAAAE0 |
| Redirect Status | 200 |
| Redirect Ssl Tls Sni | yamashiro93-com.stylesv.net |
| Redirect Https | on |
| Redirect Wpcommentdeny | 1 |
| Redirect Wploginnolimit | 1 |
| Redirect Allowrestapi | 1 |
| Redirect Ngx Cache Staticmode | 1 |
| Redirect Ngx Cache Nocachemode | off |
| Redirect Unique Id | aEVmQbsDWDx@d2SQyBeRSwAAAE0 |
| Redirect Redirect Status | 200 |
| Redirect Redirect Ssl Tls Sni | yamashiro93-com.stylesv.net |
| Redirect Redirect Https | on |
| Redirect Redirect Wpcommentdeny | 1 |
| Redirect Redirect Wploginnolimit | 1 |
| Redirect Redirect Allowrestapi | 1 |
| Redirect Redirect Ngx Cache Staticmode | 1 |
| Redirect Redirect Ngx Cache Nocachemode | off |
| Redirect Redirect Unique Id | aEVmQbsDWDx@d2SQyBeRSwAAAE0 |
| Fcgi Role | RESPONDER |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1749378625.0447 |
| Request Time | 1749378625 |
Include Paths
Included Files
