PAUL SMITH
BA7-212-11
税込価格 ¥47,300
Final Eyes Chronograph
Warning (2): array_filter() expects parameter 1 to be array, null given [APP/Controller/Front/WatchBrandsController.php, line 125]
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: 28 ms
Total Queries: 53 queries
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `WatchBrand`.`slug`, `WatchBrand`.`thumbnail`, `WatchBrand`.`name`, `WatchBrand`.`id` FROM `yamashiro93-new`.`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 `yamashiro93-new`.`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 `yamashiro93-new`.`jewelry_brands` AS `JewelryBrand` WHERE `enabled` = '1' ORDER BY `order` DESC LIMIT 14 | 7 | 7 | 0 | |
| SELECT `Content`.`id`, `Content`.`name`, `Content`.`content`, `Content`.`type`, `Content`.`enabled` FROM `yamashiro93-new`.`contents` AS `Content` WHERE `Content`.`type` = 'HeadNews' AND `Content`.`enabled` = '1' LIMIT 1 | 0 | 0 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`slug` = 'paulsmith' 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 `yamashiro93-new`.`watches` AS `Watch` WHERE `Watch`.`enabled` = '1' AND `Watch`.`watch_brand_id` = (48) ORDER BY `Watch`.`order` DESC | 16 | 16 | 2 | maybe slow |
| 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 187 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 187 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 187 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 401 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 187 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 188 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 188 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 188 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 188 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`id` = 190 | 1 | 1 | 0 | |
| SELECT `Store`.`id`, `Store`.`name`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro93-new`.`stores` AS `Store` JOIN `yamashiro93-new`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`watch_id` IN (1933, 1934, 1937, 4244, 1941, 4246, 1943, 1944, 1946, 1954, 1961, 1962, 1964, 1966, 1968, 1973) AND `WatchesStore`.`store_id` = `Store`.`id`) | 16 | 16 | 1 | maybe slow |
| SELECT `WatchModel`.`id`, `WatchModel`.`name`, `WatchModel`.`watch_brand_id`, `WatchModel`.`order` FROM `yamashiro93-new`.`watch_models` AS `WatchModel` WHERE `WatchModel`.`watch_brand_id` = (48) ORDER BY `WatchModel`.`order` DESC | 4 | 4 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watch_brands` AS `WatchBrand` WHERE `WatchBrand`.`id` = 48 | 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 `yamashiro93-new`.`watches` AS `Watch` WHERE `Watch`.`enabled` = '1' AND `Watch`.`watch_model_id` IN (188, 187, 190, 401) ORDER BY `Watch`.`order` DESC | 16 | 16 | 1 | maybe slow |
| SELECT `Store`.`id`, `Store`.`name`, `WatchBrandsStore`.`id`, `WatchBrandsStore`.`watch_brand_id`, `WatchBrandsStore`.`store_id` FROM `yamashiro93-new`.`stores` AS `Store` JOIN `yamashiro93-new`.`watch_brands_stores` AS `WatchBrandsStore` ON (`WatchBrandsStore`.`watch_brand_id` = 48 AND `WatchBrandsStore`.`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 `yamashiro93-new`.`watches` AS `Watch` JOIN `yamashiro93-new`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`store_id` = 5 AND `WatchesStore`.`watch_id` = `Watch`.`id`) | 840 | 840 | 11 | |
| 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 `yamashiro93-new`.`bridals` AS `Bridal` JOIN `yamashiro93-new`.`bridals_stores` AS `BridalsStore` ON (`BridalsStore`.`store_id` = 5 AND `BridalsStore`.`bridal_id` = `Bridal`.`id`) | 544 | 544 | 5 | |
| 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 `yamashiro93-new`.`jewelries` AS `Jewelry` JOIN `yamashiro93-new`.`jewelry_stores` AS `JewelryStore` ON (`JewelryStore`.`store_id` = 5 AND `JewelryStore`.`jewelry_id` = `Jewelry`.`id`) | 334 | 334 | 4 | |
| 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 `yamashiro93-new`.`bridal_brands` AS `BridalBrand` JOIN `yamashiro93-new`.`bridal_brands_stores` AS `BridalBrandsStore` ON (`BridalBrandsStore`.`store_id` = 5 AND `BridalBrandsStore`.`bridal_brand_id` = `BridalBrand`.`id`) | 12 | 12 | 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 `yamashiro93-new`.`jewelry_brands` AS `JewelryBrand` JOIN `yamashiro93-new`.`jewelry_brands_stores` AS `JewelryBrandsStore` ON (`JewelryBrandsStore`.`store_id` = 5 AND `JewelryBrandsStore`.`jewelry_brand_id` = `JewelryBrand`.`id`) | 3 | 3 | 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 `yamashiro93-new`.`watches` AS `Watch` LEFT JOIN `yamashiro93-new`.`watch_brands` AS `WatchBrand` ON (`Watch`.`watch_brand_id` = `WatchBrand`.`id`) LEFT JOIN `yamashiro93-new`.`watch_models` AS `WatchModel` ON (`Watch`.`watch_model_id` = `WatchModel`.`id`) WHERE `Watch`.`watch_brand_id` = 48 AND `Watch`.`is_brand_pickupable` = '1' ORDER BY `Watch`.`order_brand_pickup` desc, `Watch`.`order` desc | 4 | 4 | 2 | maybe slow |
| SELECT `Store`.`id`, `Store`.`name`, `WatchesStore`.`id`, `WatchesStore`.`watch_id`, `WatchesStore`.`store_id` FROM `yamashiro93-new`.`stores` AS `Store` JOIN `yamashiro93-new`.`watches_stores` AS `WatchesStore` ON (`WatchesStore`.`watch_id` IN (4243, 4244, 4245, 4246) AND `WatchesStore`.`store_id` = `Store`.`id`) | 4 | 4 | 1 | maybe slow |
31 duplicate queries run.
Query Explain:
Peak Memory Use 16.09 MB
| Message | Memory use |
|---|---|
| Component initialization | 773 KB |
| Controller action start | 1.32 MB |
| Controller render start | 13.68 MB |
| View render complete | 13.84 MB |
Total Request Time: 929 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 656.25 | |
| Event: Controller.initialize | 11.51 | |
| Event: Controller.startup | 0.46 | |
| Controller action | 196.98 | |
| Event: Controller.beforeRender | 2.62 | |
| » Processing toolbar data | 2.43 | |
| Rendering View | 3.17 | |
| » Event: View.beforeRender | 0.04 | |
| » Rendering APP/View/Front/WatchBrands/view.ctp | 1.28 | |
| » » Rendering APP/View/Elements/pickup_watch.ctp | 0.17 | |
| » » Rendering APP/View/Elements/watch_search.ctp | 0.07 | |
| » » 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.94 | |
| » » Rendering APP/View/Elements/header.ctp | 0.45 | |
| » » » Rendering APP/View/Elements/headnews.ctp | 0.06 | |
| » » » 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/paulsmith |
| Query String | |
| Request Method | GET |
| Server Protocol | HTTP/1.1 |
| Gateway Interface | CGI/1.1 |
| Redirect Url | /app/webroot/watch_brands/paulsmith |
| Remote Port | 56883 |
| 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.85 |
| 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 Cookie | CAKEPHP=d5enf5rrjfkpqo3dtaivsss91p; laravel_session=eyJpdiI6IkRuMTRWcHhaRDB6N0l2eW1TNzlnT1E9PSIsInZhbHVlIjoiYTQ2cXVzSEhEYXkyWS9XSUJBUyt2UDFKYjVxUTZhbjlDWjk5Sk95aEJ0YjVXbFB2cnF5Y1IyVjJPdHcrdVRCV2tNdHM2eHFpVmZ4TDFmM1R6eDRwSksvWnI5VDhiVHdkWUV0OHgreDJEU1pNM2ZqV0NyU0luMWtvVUw4cDFMekQiLCJtYWMiOiIwZjQ3MWVjNjhhODZiOTNhYjMwZjlkNDNhOTFkMjAzYmJlMjIwYmIwNTI1ZmZmNGM1ZmUxMDVhMTQ0YzMzYWVjIiwidGFnIjoiIn0%3D |
| 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 | aNsIWZ-O6qAkZWItl@XlkgAAAMg |
| 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 | aNsIWZ-O6qAkZWItl@XlkgAAAMg |
| 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 | aNsIWZ-O6qAkZWItl@XlkgAAAMg |
| Fcgi Role | RESPONDER |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1759184985.3808 |
| Request Time | 1759184985 |
Include Paths
Included Files
