Sold Byh: Daisy
SKU: SW-117-A0-A3-mgwM6-vxEEO
Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.
- Casual unisex fit
- 64% polyester, 36% polyurethane
- Water column pressure: 4000 mm
- Model is 187cm tall and wearing a size S / M
- Unisex fit
- Drawstring hood with built-in cap
- Front placket with snap buttons
- Ventilation under armpit
- Adjustable cuffs
- Double welted front pockets
- Adjustable elastic string at hempen
- Ultrasonically welded seams
This is a unisex item, please check our clothing & footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.
| 1 x Application (59.07%) | 452.02ms |
| 1 x Booting (40.9%) | 312.95ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
select * from `slugs` where (`key` = 'caesar' and `prefix` = 'products') limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_currencies` order by `order` asc| Metadata | |
|---|---|
| Backtrace |
|
select distinct `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(`ec_reviews`.`star`) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg` from `ec_products` inner join
(
SELECT DISTINCT
ec_products.id,
CASE
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price <> 0
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price = 0
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
(
ec_products.start_date > '2025-05-01 17:41:53' OR
ec_products.end_date < '2025-05-01 17:41:53'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-01 17:41:53' AND
ec_products.end_date >= '2025-05-01 17:41:53'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-05-01 17:41:53'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-01 17:41:53' AND
ec_products.end_date IS NULL
) THEN ec_products.sale_price
ELSE ec_products.price
END AS final_price
FROM ec_products
) AS products_with_final_price
on `products_with_final_price`.`id` = `ec_products`.`id` where `status` = 'published' and `ec_products`.`id` = 93 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (93) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (93)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select * from `mp_stores` where `mp_stores`.`id` in (29)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (29) and `slugs`.`reference_type` = 'Botble\Marketplace\Models\Store'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_tags`.*, `ec_product_tag_product`.`product_id` as `pivot_product_id`, `ec_product_tag_product`.`tag_id` as `pivot_tag_id` from `ec_product_tags` inner join `ec_product_tag_product` on `ec_product_tags`.`id` = `ec_product_tag_product`.`tag_id` where `ec_product_tag_product`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (93) order by `order` asc| Metadata | |
|---|---|
| Backtrace |
|
select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2025-05-01 17:41:53' and (`end_date` is null or `end_date` >= '2025-05-01 17:41:53') and (`target` in ('all-orders', 'amount-minimum-order') or (`target` in ('customer', 'group-products', 'products-by-category', 'specific-product', 'product-variant') and `product_quantity` = 1))| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_flash_sales` where date(`end_date`) >= '2025-05-01' and `status` = 'published' order by `created_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
update `ec_products` set `views` = `views` + 1 where `id` = 93| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 93 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (93)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_tags`.*, `ec_product_tag_product`.`product_id` as `pivot_product_id`, `ec_product_tag_product`.`tag_id` as `pivot_tag_id` from `ec_product_tags` inner join `ec_product_tag_product` on `ec_product_tags`.`id` = `ec_product_tag_product`.`tag_id` where `ec_product_tag_product`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` in (93)| Metadata | |
|---|---|
| Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (93) order by `order` asc| Metadata | |
|---|---|
| Backtrace |
|
insert into `ec_product_views` (`date`, `product_id`, `views`) values ('2025-05-01', 93, 1) on duplicate key update `views` = views + 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (93) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 93 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 93 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_flash_sales`.*, `ec_flash_sale_products`.`product_id` as `pivot_product_id`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`price` as `pivot_price`, `ec_flash_sale_products`.`quantity` as `pivot_quantity`, `ec_flash_sale_products`.`sold` as `pivot_sold` from `ec_flash_sales` inner join `ec_flash_sale_products` on `ec_flash_sales`.`id` = `ec_flash_sale_products`.`flash_sale_id` where `ec_flash_sale_products`.`product_id` = 93 and `status` = 'published' and date(`end_date`) >= '2025-05-01' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 93 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ads`| Metadata | |
|---|---|
| Backtrace |
|
select `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(`ec_reviews`.`star`) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg`, `ec_product_cross_sale_relations`.`from_product_id` as `pivot_from_product_id`, `ec_product_cross_sale_relations`.`to_product_id` as `pivot_to_product_id` from `ec_products` inner join `ec_product_cross_sale_relations` on `ec_products`.`id` = `ec_product_cross_sale_relations`.`to_product_id` where `ec_product_cross_sale_relations`.`from_product_id` = 93 and `status` = 'published' limit 7| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 11, 12, 18) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (1, 11, 12, 18)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` in (1, 11, 12, 18)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (1, 11, 12, 18)| Metadata | |
|---|---|
| Backtrace |
|
select * from `mp_stores` where `mp_stores`.`id` in (3, 15)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (3, 15) and `slugs`.`reference_type` = 'Botble\Marketplace\Models\Store'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 11| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 12| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 18| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `to_product_id` from `ec_product_related_relations` where `ec_product_related_relations`.`from_product_id` = 93| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(`ec_reviews`.`star`) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg` from `ec_products` inner join
(
SELECT DISTINCT
ec_products.id,
CASE
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price <> 0
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price = 0
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
(
ec_products.start_date > '2025-05-01 17:41:53' OR
ec_products.end_date < '2025-05-01 17:41:53'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-01 17:41:53' AND
ec_products.end_date >= '2025-05-01 17:41:53'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-05-01 17:41:53'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-01 17:41:53' AND
ec_products.end_date IS NULL
) THEN ec_products.sale_price
ELSE ec_products.price
END AS final_price
FROM ec_products
) AS products_with_final_price
on `products_with_final_price`.`id` = `ec_products`.`id` where `status` = 'published' and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 93 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 7| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (118, 119, 120, 150, 253, 266, 279) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (118, 119, 120, 150, 253, 266, 279)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` in (118, 119, 120, 150, 253, 266, 279)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (118, 119, 120, 150, 253, 266, 279)| Metadata | |
|---|---|
| Backtrace |
|
select * from `mp_stores` where `mp_stores`.`id` in (2, 29, 41)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (2, 29, 41) and `slugs`.`reference_type` = 'Botble\Marketplace\Models\Store'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 279| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 266| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 253| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 150| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 119| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` = 118| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'faq_schema_config' and `reference_id` = 93 and `reference_type` = 'Botble\Ecommerce\Models\Product') limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `status` = 'published' and exists (select * from `language_meta` where `menus`.`id` = `language_meta`.`reference_id` and `language_meta`.`reference_type` = 'Botble\Menu\Models\Menu' and `lang_meta_code` = 'en_US' and `lang_meta_code` = 'en_US')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9)| Metadata | |
|---|---|
| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`parent_id` in (1, 8, 9, 10, 11, 12, 15, 21, 22, 23, 24, 25, 26, 27, 28, 29, 33, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45) order by `position` asc| Metadata | |
|---|---|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (9, 10, 11) and `meta_boxes`.`reference_type` = 'Botble\Menu\Models\MenuNode'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1, 8, 9, 10, 11, 12, 15, 21, 22, 23, 24, 25, 26, 27, 28, 29, 33, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45) and `meta_boxes`.`reference_type` = 'Botble\Menu\Models\MenuNode'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9)| Metadata | |
|---|---|
| Backtrace |
|
select * from `pages` where `pages`.`id` in (8)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (8) and `slugs`.`reference_type` = 'Botble\Page\Models\Page'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`id` in (15)| Metadata | |
|---|---|
| Backtrace |
|
select * from `widgets` where (`theme` = 'martfury')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `pages` where `pages`.`id` in (15, 13, 14)| Metadata | |
|---|---|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (13, 14, 15) and `slugs`.`reference_type` = 'Botble\Page\Models\Page'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:19 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-6813b261-5bcaaea663840b5765ce6aa9" ] "host" => array:1 [▶ 0 => "fiona-hobbs.drink2drink.com" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "3.16.109.195" ] ]
0 of 0array:51 [▼ "USER" => "apache" "HOME" => "/usr/share/httpd" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/products/caesar" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/products/caesar" "REMOTE_PORT" => "34856" "SCRIPT_FILENAME" => "/var/www/html/public/index.php" "SERVER_ADMIN" => "root@localhost" "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/public" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "http" "DOCUMENT_ROOT" => "/var/www/html/public" "REMOTE_ADDR" => "172.31.17.226" "SERVER_PORT" => "80" "SERVER_ADDR" => "172.31.39.111" "SERVER_NAME" => "fiona-hobbs.drink2drink.com" "SERVER_SOFTWARE" => "Apache/2.4.62 () OpenSSL/1.0.2k-fips" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_X_AMZN_TRACE_ID" => "Root=1-6813b261-5bcaaea663840b5765ce6aa9" "HTTP_HOST" => "fiona-hobbs.drink2drink.com" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "3.16.109.195" "proxy-nokeepalive" => "1" "UNIQUE_ID" => "aBOyYbpUFkLy691X7F96cwAAAA0" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aBOyYbpUFkLy691X7F96cwAAAA0" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746121313.4726 "REQUEST_TIME" => 1746121313 "HTTPS" => "on" ]
[]
0 of 0array:8 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 01 May 2025 17:41:54 GMT" ] "cms-version" => array:1 [▶ 0 => "6.10.4" ] "authorization-at" => array:1 [▶ 0 => "2024-08-20 17:38:27" ] "activated-license" => array:1 [▶ 0 => "No" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:4 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlVISXNKemZJZ0hsVVdqZXNpcHJXYkE9PSIsInZhbHVlIjoicitFL3BuMzNLa244ZnphTU83OWo5MUM2YTBZRkdQK1N0Q29IY2ppbC9YeWRGRmJmYjIvVVFoNk1wVXo5R0ZXNTROb2RwaVBGZU9pUENYMFJNQ1RjcVFjd2lLRU9ONjJVOFNDbFNLZnlRMHBqblQ1eW1CejY5eGVnSzB3eFA2VUkiLCJtYWMiOiIxNjY5MzJjZDE4MmY2ZDExNWU5M2Y1ZGRmNDFmY2MyYjdkZGU3NTFjMjI4NWI3YzcyZDc4YjUxMjllMWRiMmJhIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 19:41:54 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlVISXNKemZJZ0hsVVdqZXNpcHJXYkE9PSIsInZhbHVlIjoicitFL3BuMzNLa244ZnphTU83OWo5MUM2YTBZRkdQK1N0Q29IY2ppbC9YeWRGRmJmYjIvVVFoNk1wVXo5R0ZXNTROb2Rwa ▶" 1 => "botble_session=eyJpdiI6Ik5Yb0haOHgvK2RtZ0lVSDB3TG5wNVE9PSIsInZhbHVlIjoic0VCbUZSYzJVazRIY2x4eFZLYVFBVlVxUFF2VVo0NnIxbjdvREgxTEliS1NYNVZqaGlMQ3JhUi94WmFVcUt5VWVZWGNnbWpSS3JZcTFRZ0FCQmZuSHZHNWhBTnZIUGljUnoxd3ltU2dNcnNSNGRmMU1kOVJzSDhCd2poSmw4b08iLCJtYWMiOiI2YjMyNzNiMTc3MDc0NDBhNzY2NzRkOGQwNWJkYWI4OGNhZGFjYmRhNjk1ZGQyMzUxMzMyYTk0MWI2MDc1YjA4IiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 19:41:54 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6Ik5Yb0haOHgvK2RtZ0lVSDB3TG5wNVE9PSIsInZhbHVlIjoic0VCbUZSYzJVazRIY2x4eFZLYVFBVlVxUFF2VVo0NnIxbjdvREgxTEliS1NYNVZqaGlMQ3JhUi94WmFVcUt5VWVZW ▶" 2 => "botble_footprints_cookie=eyJpdiI6ImQzSmpocitKVDNoMk9EejJTUFB1dmc9PSIsInZhbHVlIjoiMlBVTkk1L1BIc2tzQXdxdWJjeVgxUlRVN3lpMEdtd1p6ckFHaG5zWTMzVTlsS0tINXhURk5mdkxvWkU2WEZ0b3d2dWk5TVNVVkYzTHQ3bVZ4dlRqTHJoSVRFRmVYSU01YXNkTTBlUDJWbXAzUFE2c0FoVXg2QzJkMHg3QmZSbUQiLCJtYWMiOiI0ZmQ5Y2I1ZmM1MzUzMjg3N2Q1NzBmM2ViN2E3OWRhZmZhYTgwMTk5NDA0N2ExODRjNzE0MjE4YTZiNDk0ZDQyIiwidGFnIjoiIn0%3D; expires=Thu, 25 Jun 2026 17:41:53 GMT; Max-Age=36287999; path=/; httponly; samesite=lax ◀botble_footprints_cookie=eyJpdiI6ImQzSmpocitKVDNoMk9EejJTUFB1dmc9PSIsInZhbHVlIjoiMlBVTkk1L1BIc2tzQXdxdWJjeVgxUlRVN3lpMEdtd1p6ckFHaG5zWTMzVTlsS0tINXhURk5mdkxvWkU ▶" 3 => "botble_footprints_cookie_data=eyJpdiI6IklCMDVHRnNjZEg2RWRsaWM3MDJjZWc9PSIsInZhbHVlIjoiY0x4SjEyUnVRVGhSRG9Db0huUy9hdkZkU0pEQ1AvSEozQTlXam5LUDRBeWEvb3BBdUVvNG5RS3ZoTDNLY3JIOWZTUFY5amtMU041TzVIREx4dXV5UjJqV3lSc0lPYWhYZVRtUklocTdaamVCZUhQazFVWWJkbCt4MjlEcjc1K09ibTh0Q0MrQzlFWDNnM3ltenlTK205L1hBNXR2NHlJcG9JUUlSSVJpKzZvbUMzTlBoSFRIWlVuMDRtbDhBN2JSMHlVaG84RGhUaTBkU2N6TnhiMmJWQUV4eHdLNlN3U09sR243dVdJbno0NFhHRGl0eUNkQ2lDeEIwUHUxMHdaSVFMamt2NzBaQlEwUGtMcnN1T0hqVUpid2xIS1pGMzV3emRaTTZkWU5PUFdWQnhQMnNOcm93bDdDZlNvLzZMelQwWjRpMis5Y05aM3ppNEltVmkxUWhFTkNrQlBxS2xoWENqUi9yR1RlRGxLUjZsTkh1SnlSdUVvMmhMQkFCaGdPN21oR2c2ZC8yejMwR1lHdzVXajdFMDZxalNic2hpVUFjMGhZOS9BSG1aY20wR2llL2h2N1duY0h0M09NbXpjMEVHc2tienpIa2EyTmpnWWF0SEw0OFB6QldrMnhsRFNhRXo3M00xckZhcVFiNUJKdTJJZm1KeHA2QVN2ekhFWUh0cEF0dm5XbVZiaDdyVjBiMHM5djNnPT0iLCJtYWMiOiJkOGFiOTJjYzFmZGQ3NjEzYjUyMmNkY2Y2Y2ZlYTljMzk4MjRmNzM0NGM0ZTFmYzEyMTgwZDVlNDYxMGNiNTdmIiwidGFnIjoiIn0%3D; expires=Thu, 25 Jun 2026 17:41:53 GMT; Max-Age=36287999; path=/; httponly; samesite=lax ◀botble_footprints_cookie_data=eyJpdiI6IklCMDVHRnNjZEg2RWRsaWM3MDJjZWc9PSIsInZhbHVlIjoiY0x4SjEyUnVRVGhSRG9Db0huUy9hdkZkU0pEQ1AvSEozQTlXam5LUDRBeWEvb3BBdUVvNG5RS3 ▶" ] "Set-Cookie" => array:4 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlVISXNKemZJZ0hsVVdqZXNpcHJXYkE9PSIsInZhbHVlIjoicitFL3BuMzNLa244ZnphTU83OWo5MUM2YTBZRkdQK1N0Q29IY2ppbC9YeWRGRmJmYjIvVVFoNk1wVXo5R0ZXNTROb2RwaVBGZU9pUENYMFJNQ1RjcVFjd2lLRU9ONjJVOFNDbFNLZnlRMHBqblQ1eW1CejY5eGVnSzB3eFA2VUkiLCJtYWMiOiIxNjY5MzJjZDE4MmY2ZDExNWU5M2Y1ZGRmNDFmY2MyYjdkZGU3NTFjMjI4NWI3YzcyZDc4YjUxMjllMWRiMmJhIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 19:41:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlVISXNKemZJZ0hsVVdqZXNpcHJXYkE9PSIsInZhbHVlIjoicitFL3BuMzNLa244ZnphTU83OWo5MUM2YTBZRkdQK1N0Q29IY2ppbC9YeWRGRmJmYjIvVVFoNk1wVXo5R0ZXNTROb2Rwa ▶" 1 => "botble_session=eyJpdiI6Ik5Yb0haOHgvK2RtZ0lVSDB3TG5wNVE9PSIsInZhbHVlIjoic0VCbUZSYzJVazRIY2x4eFZLYVFBVlVxUFF2VVo0NnIxbjdvREgxTEliS1NYNVZqaGlMQ3JhUi94WmFVcUt5VWVZWGNnbWpSS3JZcTFRZ0FCQmZuSHZHNWhBTnZIUGljUnoxd3ltU2dNcnNSNGRmMU1kOVJzSDhCd2poSmw4b08iLCJtYWMiOiI2YjMyNzNiMTc3MDc0NDBhNzY2NzRkOGQwNWJkYWI4OGNhZGFjYmRhNjk1ZGQyMzUxMzMyYTk0MWI2MDc1YjA4IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 19:41:54 GMT; path=/; httponly ◀botble_session=eyJpdiI6Ik5Yb0haOHgvK2RtZ0lVSDB3TG5wNVE9PSIsInZhbHVlIjoic0VCbUZSYzJVazRIY2x4eFZLYVFBVlVxUFF2VVo0NnIxbjdvREgxTEliS1NYNVZqaGlMQ3JhUi94WmFVcUt5VWVZW ▶" 2 => "botble_footprints_cookie=eyJpdiI6ImQzSmpocitKVDNoMk9EejJTUFB1dmc9PSIsInZhbHVlIjoiMlBVTkk1L1BIc2tzQXdxdWJjeVgxUlRVN3lpMEdtd1p6ckFHaG5zWTMzVTlsS0tINXhURk5mdkxvWkU2WEZ0b3d2dWk5TVNVVkYzTHQ3bVZ4dlRqTHJoSVRFRmVYSU01YXNkTTBlUDJWbXAzUFE2c0FoVXg2QzJkMHg3QmZSbUQiLCJtYWMiOiI0ZmQ5Y2I1ZmM1MzUzMjg3N2Q1NzBmM2ViN2E3OWRhZmZhYTgwMTk5NDA0N2ExODRjNzE0MjE4YTZiNDk0ZDQyIiwidGFnIjoiIn0%3D; expires=Thu, 25-Jun-2026 17:41:53 GMT; path=/; httponly ◀botble_footprints_cookie=eyJpdiI6ImQzSmpocitKVDNoMk9EejJTUFB1dmc9PSIsInZhbHVlIjoiMlBVTkk1L1BIc2tzQXdxdWJjeVgxUlRVN3lpMEdtd1p6ckFHaG5zWTMzVTlsS0tINXhURk5mdkxvWkU ▶" 3 => "botble_footprints_cookie_data=eyJpdiI6IklCMDVHRnNjZEg2RWRsaWM3MDJjZWc9PSIsInZhbHVlIjoiY0x4SjEyUnVRVGhSRG9Db0huUy9hdkZkU0pEQ1AvSEozQTlXam5LUDRBeWEvb3BBdUVvNG5RS3ZoTDNLY3JIOWZTUFY5amtMU041TzVIREx4dXV5UjJqV3lSc0lPYWhYZVRtUklocTdaamVCZUhQazFVWWJkbCt4MjlEcjc1K09ibTh0Q0MrQzlFWDNnM3ltenlTK205L1hBNXR2NHlJcG9JUUlSSVJpKzZvbUMzTlBoSFRIWlVuMDRtbDhBN2JSMHlVaG84RGhUaTBkU2N6TnhiMmJWQUV4eHdLNlN3U09sR243dVdJbno0NFhHRGl0eUNkQ2lDeEIwUHUxMHdaSVFMamt2NzBaQlEwUGtMcnN1T0hqVUpid2xIS1pGMzV3emRaTTZkWU5PUFdWQnhQMnNOcm93bDdDZlNvLzZMelQwWjRpMis5Y05aM3ppNEltVmkxUWhFTkNrQlBxS2xoWENqUi9yR1RlRGxLUjZsTkh1SnlSdUVvMmhMQkFCaGdPN21oR2c2ZC8yejMwR1lHdzVXajdFMDZxalNic2hpVUFjMGhZOS9BSG1aY20wR2llL2h2N1duY0h0M09NbXpjMEVHc2tienpIa2EyTmpnWWF0SEw0OFB6QldrMnhsRFNhRXo3M00xckZhcVFiNUJKdTJJZm1KeHA2QVN2ekhFWUh0cEF0dm5XbVZiaDdyVjBiMHM5djNnPT0iLCJtYWMiOiJkOGFiOTJjYzFmZGQ3NjEzYjUyMmNkY2Y2Y2ZlYTljMzk4MjRmNzM0NGM0ZTFmYzEyMTgwZDVlNDYxMGNiNTdmIiwidGFnIjoiIn0%3D; expires=Thu, 25-Jun-2026 17:41:53 GMT; path=/; httponly ◀botble_footprints_cookie_data=eyJpdiI6IklCMDVHRnNjZEg2RWRsaWM3MDJjZWc9PSIsInZhbHVlIjoiY0x4SjEyUnVRVGhSRG9Db0huUy9hdkZkU0pEQ1AvSEozQTlXam5LUDRBeWEvb3BBdUVvNG5RS3 ▶" ] ]
0 of 0array:7 [▼ "_token" => "keaSTtIpbq7UDFGqw7KE0urqhkqSK1x2UzopOvz9" "language" => "en" "viewed_product" => array:1 [▶ 93 => 1746121313 ] "cart" => array:2 [▶ "recently_viewed_updated_at" => Carbon\Carbon @1746121313 {#3434 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000d6a0000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-05-01 17:41:53.880813 UTC (+00:00) } "recently_viewed" => Illuminate\Support\Collection {#3433 ▶ #items: array:1 [▶ "d3d9ac844d0d81c8d7e15cc2940f3bf2" => Botble\Ecommerce\Cart\CartItem {#3435 ▶ +rowId: "d3d9ac844d0d81c8d7e15cc2940f3bf2" +id: 93 +qty: 1 +name: "Caesar" +price: 683.9 +options: Botble\Ecommerce\Cart\CartItemOptions {#3431 ▶ #items: [] #escapeWhenCastingToString: false } #associatedModel: "Botble\Ecommerce\Models\Product" #taxRate: 0 +"created_at": Carbon\Carbon @1746121313 {#3430 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000d660000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-05-01 17:41:53.880759 UTC (+00:00) } +"updated_at": Carbon\Carbon @1746121313 {#3428 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000d640000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-05-01 17:41:53.880769 UTC (+00:00) } } ] #escapeWhenCastingToString: false } ] "_previous" => array:1 [▶ "url" => "https://fiona-hobbs.drink2drink.com/products/caesar" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]