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: 16 ms
Total Queries: 17 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 `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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`slug` = 'privatebeach' AND `BridalBrand`.`enabled` = '1' LIMIT 1 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridals` AS `Bridal` WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`bridal_brand_id` = (18) ORDER BY `Bridal`.`order` DESC | 0 | 0 | 1 | maybe slow |
SELECT `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridal_models` AS `BridalModel` WHERE `BridalModel`.`bridal_brand_id` = (18) ORDER BY `BridalModel`.`order` DESC | 2 | 2 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 18 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridal_brands` AS `BridalBrand` WHERE `BridalBrand`.`id` = 18 | 1 | 1 | 0 | |
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` FROM `yamashiro`.`bridals` AS `Bridal` WHERE `Bridal`.`enabled` = '1' AND `Bridal`.`bridal_model_id` IN (52, 56) ORDER BY `Bridal`.`order` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Store`.`id`, `Store`.`name`, `BridalBrandsStore`.`id`, `BridalBrandsStore`.`bridal_brand_id`, `BridalBrandsStore`.`store_id` FROM `yamashiro`.`stores` AS `Store` JOIN `yamashiro`.`bridal_brands_stores` AS `BridalBrandsStore` ON (`BridalBrandsStore`.`bridal_brand_id` = 18 AND `BridalBrandsStore`.`store_id` = `Store`.`id`) | 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`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro`.`watches` AS `Watch` JOIN `yamashiro`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`store_id` = 3 AND `WatchesStore`.`watch_id` = `Watch`.`id`) | 619 | 619 | 6 | |
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` = 3 AND `BridalsStore`.`bridal_id` = `Bridal`.`id`) | 328 | 328 | 3 | |
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` = 3 AND `JewelryStore`.`jewelry_id` = `Jewelry`.`id`) | 280 | 280 | 3 | |
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`, `WatchBrandsStore`.`id`, `WatchBrandsStore`.`watch_brand_id`, `WatchBrandsStore`.`store_id` FROM `yamashiro`.`watch_brands` AS `WatchBrand` JOIN `yamashiro`.`watch_brands_stores` AS `WatchBrandsStore` ON (`WatchBrandsStore`.`store_id` = 3 AND `WatchBrandsStore`.`watch_brand_id` = `WatchBrand`.`id`) | 18 | 18 | 1 | maybe slow |
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` = 3 AND `JewelryBrandsStore`.`jewelry_brand_id` = `JewelryBrand`.`id`) | 5 | 5 | 0 | |
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`, `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`, `BridalModel`.`id`, `BridalModel`.`name`, `BridalModel`.`order`, `BridalModel`.`bridal_brand_id` FROM `yamashiro`.`bridals` AS `Bridal` LEFT JOIN `yamashiro`.`bridal_brands` AS `BridalBrand` ON (`Bridal`.`bridal_brand_id` = `BridalBrand`.`id`) LEFT JOIN `yamashiro`.`bridal_models` AS `BridalModel` ON (`Bridal`.`bridal_model_id` = `BridalModel`.`id`) WHERE `Bridal`.`bridal_brand_id` = 18 AND `is_brand_pickupable` = '1' ORDER BY `Bridal`.`order_brand_pickup` desc, `Bridal`.`order` desc | 0 | 0 | 1 | maybe slow |
1 duplicate queries run.
Query Explain:
Peak Memory Use 12.70 MB
Message | Memory use |
---|---|
Component initialization | 796 KB |
Controller action start | 1.33 MB |
Controller render start | 10.40 MB |
View render complete | 10.55 MB |
Total Request Time: 173 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 6.27 | |
Event: Controller.initialize | 12.49 | |
Event: Controller.startup | 0.52 | |
Controller action | 126.04 | |
Event: Controller.beforeRender | 2.55 | |
» Processing toolbar data | 2.42 | |
Rendering View | 3.80 | |
» Event: View.beforeRender | 0.04 | |
» Rendering APP/View/Front/BridalBrands/view.ctp | 1.85 | |
» » Rendering APP/View/Elements/cover_slick.ctp | 0.24 | |
» » Rendering APP/View/Elements/pickup_bridal.ctp | 0.11 | |
» » Rendering APP/View/Elements/bridal_search.ctp | 0.11 | |
» » Rendering APP/View/Elements/popup_slider.ctp | 0.10 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/front.ctp | 0.98 | |
» » Rendering APP/View/Elements/header.ctp | 0.46 | |
» » » Rendering APP/View/Elements/headnews.ctp | 0.07 | |
» » » Rendering APP/View/Elements/headnews.ctp #2 | 0.06 | |
» » Rendering APP/View/Elements/footer.ctp | 0.08 | |
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 | /bridal_brands/privatebeach |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.1 |
Gateway Interface | CGI/1.1 |
Redirect Url | /app/webroot/bridal_brands/privatebeach |
Remote Port | 29535 |
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 | aEVuoEwjRAo@H7UopFhZoAAAAJg |
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 | aEVuoEwjRAo@H7UopFhZoAAAAJg |
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 | aEVuoEwjRAo@H7UopFhZoAAAAJg |
Fcgi Role | RESPONDER |
Php Self | /app/webroot/index.php |
Request Time Float | 1749380768.1484 |
Request Time | 1749380768 |
Include Paths
Included Files