Rye Bread
NET WT 67.6 FL OZ (2L.)
Vitamin A 0%
Calcium 0%
Iron 0%
Vitamin C 0%
Water, sugar, concentrated apple juice (min. 5%), concentrated grape juice (min. 4%), blueberry base (min. 1%), [sugar, water, concentrated hibiscus juice, concentrated blueberry juice, citric acid (E330), flavoring), acidity regulator: citric acid (E330), concentrated hibiscus juice (min. 0,6%), flavoring, sweeteners: aspartame (E951). acesulfame K (E950).
Enjoy your first time purchase
discount
of 10%
(for registered customers only)
Hurry Up!
| 1 x Application (97.11%) | 3.20s |
| 1 x Booting (2.89%) | 95.22ms |
English
# Query soft limit for Debugbar is reached after 100 queries, additional 46 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)select * from `slugs` where (`key` = 'bbb-fruit-drink-blueberry-2l' and `prefix` = 'products') or exists (select * from `slugs_translations` where `slugs`.`id` = `slugs_translations`.`slugs_id` and (`key` = 'bbb-fruit-drink-blueberry-2l' and `prefix` = 'products')) limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_currencies` order by `order` asc| Backtrace |
|
select distinct `ec_products`.* 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-03-26 07:18:30' OR
ec_products.end_date < '2025-03-26 07:18:30'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:30' AND
ec_products.end_date >= '2025-03-26 07:18:30'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-03-26 07:18:30'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:30' 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 `ec_products`.`id` = 16690 and `ec_products`.`status` = 'published' order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (16690) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product'| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (16690)| 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 (16690)| 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 (16690)| 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 (16690)| 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 (16690)| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (10, 14, 230) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (16690) order by `order` asc| Backtrace |
|
select `ec_products`.*, `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`, `ec_product_cross_sale_relations`.`price` as `pivot_price`, `ec_product_cross_sale_relations`.`price_type` as `pivot_price_type`, `ec_product_cross_sale_relations`.`apply_to_all_variations` as `pivot_apply_to_all_variations`, `ec_product_cross_sale_relations`.`is_variant` as `pivot_is_variant` 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` in (16690) and `ec_product_cross_sale_relations`.`is_variant` = 0| Bindings |
|
| Backtrace |
|
select * from `ec_flash_sales` where date(`end_date`) >= '2025-03-26' and `status` = 'published' order by `created_at` desc| Bindings |
|
| Backtrace |
|
select `ec_products`.*, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`product_id` as `pivot_product_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_products` inner join `ec_flash_sale_products` on `ec_products`.`id` = `ec_flash_sale_products`.`product_id` where `ec_flash_sale_products`.`flash_sale_id` in (1, 2)| Backtrace |
|
select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2025-03-26 07:18:30' and (`end_date` is null or `end_date` >= '2025-03-26 07:18:30') 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))| Bindings |
|
| Backtrace |
|
update `ec_products` set `views` = `views` + 1 where `id` = 16690| Bindings |
|
| Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 16690 limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (16690)| 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 (16690)| 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 (16690)| 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 (16690)| 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 (16690)| Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (16690) order by `order` asc| Backtrace |
|
select `ec_products`.*, `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`, `ec_product_cross_sale_relations`.`price` as `pivot_price`, `ec_product_cross_sale_relations`.`price_type` as `pivot_price_type`, `ec_product_cross_sale_relations`.`apply_to_all_variations` as `pivot_apply_to_all_variations`, `ec_product_cross_sale_relations`.`is_variant` as `pivot_is_variant` 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` in (16690)| Backtrace |
|
insert into `ec_product_views` (`date`, `product_id`, `views`) values ('2025-03-26', 16690, 1) on duplicate key update `views` = views + 1| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`id` = 0 and not `parent_id` = 230 limit 1| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (16690) and `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product'| 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` = 16690 limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 16690 and `ec_product_variations`.`configurable_product_id` is not null| Bindings |
|
| Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 16690 limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'layout' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 0 limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_custom_fields` where `status` = 'published' and `display_location` = 'product'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 16690 and `ec_product_variations`.`configurable_product_id` is not null| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'ingridient' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'nutrition' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'nutrition' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'nutrition' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'ingredient' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select * from `meta_boxes` where (`meta_key` = 'ingredient' and `reference_id` = 16690 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product') limit 1| Bindings |
|
| Backtrace |
|
select `ec_products`.*, `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`, `ec_product_cross_sale_relations`.`price` as `pivot_price`, `ec_product_cross_sale_relations`.`price_type` as `pivot_price_type`, `ec_product_cross_sale_relations`.`apply_to_all_variations` as `pivot_apply_to_all_variations`, `ec_product_cross_sale_relations`.`is_variant` as `pivot_is_variant` 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` = 16690 and `status` = 'published' limit 4| Bindings |
|
| Backtrace |
|
select `to_product_id` from `ec_product_related_relations` where `ec_product_related_relations`.`from_product_id` = 16690| Bindings |
|
| Backtrace |
|
select `ec_product_categories`.`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` = 16690| Bindings |
|
| Backtrace |
|
select distinct `ec_products`.* 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-03-26 07:18:31' OR
ec_products.end_date < '2025-03-26 07:18:31'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:31' AND
ec_products.end_date >= '2025-03-26 07:18:31'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-03-26 07:18:31'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:31' 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 exists (select * from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_products`.`id` = `ec_product_category_product`.`product_id` and `ec_product_category_product`.`category_id` in (230, 10, 14)) and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 16690 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 6| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (17090, 17135, 17136, 17137, 17138, 17139) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product'| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (17090, 17135, 17136, 17137, 17138, 17139)| 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 (17090, 17135, 17136, 17137, 17138, 17139)| 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 (17090, 17135, 17136, 17137, 17138, 17139)| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 449 limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Brand' and `slugs`.`reference_id` = 449 and `slugs`.`reference_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 449 limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Brand' and `slugs`.`reference_id` = 449 and `slugs`.`reference_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 449 limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Brand' and `slugs`.`reference_id` = 449 and `slugs`.`reference_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 449 limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Brand' and `slugs`.`reference_id` = 449 and `slugs`.`reference_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 0 limit 1| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 610 limit 1| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Brand' and `slugs`.`reference_id` = 610 and `slugs`.`reference_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select `language_meta`.`lang_meta_code`, `language_meta`.`reference_id` from `language_meta` inner join `language_meta` as `meta` on `meta`.`lang_meta_origin` = `language_meta`.`lang_meta_origin` where `language_meta`.`lang_meta_code` != 'en_US' and (`meta`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product' and `meta`.`reference_id` = 16690)| Bindings |
|
| Backtrace |
|
select `key`, `prefix`, `reference_id` from `slugs` where 0 = 1 and `reference_type` = 'Botble\\Ecommerce\\Models\\Product'| Bindings |
|
| Backtrace |
|
select `id`, `name`, `status`, `is_featured`, `image` from `ec_product_categories` order by `order` asc, `created_at` desc| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where not `id` is null and `ec_product_categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350)| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 25, 26, 27, 28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 47, 48, 49, 50, 51, 52, 53, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350) and `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories_translations` where `ec_product_categories_translations`.`ec_product_categories_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 25, 26, 27, 28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 47, 48, 49, 50, 51, 52, 53, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350)| 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')| Bindings |
|
| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3, 7)| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 29, 30, 31, 32, 33, 34, 67, 68, 69, 70, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118) order by `position` asc| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (2, 3, 4, 5, 7, 8, 9, 12, 13, 14, 16, 17, 18, 19, 20, 21, 69, 70) and `meta_boxes`.`reference_type` = 'Botble\\Menu\\Models\\MenuNode'| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 29, 30, 31, 32, 33, 34, 67, 68, 69, 70, 104, 105, 106, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118) and `meta_boxes`.`reference_type` = 'Botble\\Menu\\Models\\MenuNode'| Bindings |
|
| Backtrace |
|
select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3, 7)| Backtrace |
|
select * from `pages` where `pages`.`id` in (1, 5)| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 5) and `slugs`.`reference_type` = 'Botble\\Page\\Models\\Page'| Bindings |
|
| Backtrace |
|
select * from `pages` where `pages`.`id` in (7, 6)| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (6, 7) and `slugs`.`reference_type` = 'Botble\\Page\\Models\\Page'| Bindings |
|
| Backtrace |
|
select * from `widgets` where (`theme` = 'wowy')| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories`| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (23, 24, 33, 46, 54, 59, 78, 89, 108, 159, 182, 205, 230, 259, 289, 303) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `ec_product_categories`.`parent_id` in (23, 24, 33, 46, 54, 59, 78, 89, 108, 159, 182, 205, 230, 259, 289, 303)| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 7, 10, 15, 16, 20, 25, 26, 27, 28, 29, 30, 34, 35, 36, 37, 38, 39, 40, 41, 42, 47, 49, 53, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 90, 91, 101, 104, 109, 110, 111, 112, 121, 132, 133, 135, 147, 160, 163, 169, 172, 178, 183, 193, 201, 203, 206, 212, 216, 217, 226, 231, 232, 233, 234, 235, 236, 237, 238, 239, 260, 266, 270, 271, 281, 282, 283, 284, 285, 286, 287, 288, 290, 298, 304, 310, 314, 328, 348) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory' and `meta_boxes`.`reference_id` = 289 and `meta_boxes`.`reference_id` is not null| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (290, 298) order by `order` asc| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (291, 292, 293, 294, 295, 296, 297, 299, 300, 301, 302) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (291, 292, 293, 294, 295, 296, 297, 299, 300, 301, 302) order by `order` asc| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory' and `meta_boxes`.`reference_id` = 205 and `meta_boxes`.`reference_id` is not null| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (206, 212, 216, 217, 226) order by `order` asc| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (207, 208, 209, 210, 211, 213, 214, 215, 218, 219, 220, 221, 222, 223, 224, 225, 227, 228, 229) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (207, 208, 209, 210, 211, 213, 214, 215, 218, 219, 220, 221, 222, 223, 224, 225, 227, 228, 229) order by `order` asc| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory' and `meta_boxes`.`reference_id` = 303 and `meta_boxes`.`reference_id` is not null| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (304, 310) order by `order` asc| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (305, 306, 307, 308, 309, 311, 312, 313) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (305, 306, 307, 308, 309, 311, 312, 313) order by `order` asc| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory' and `meta_boxes`.`reference_id` = 23 and `meta_boxes`.`reference_id` is not null| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (30, 42, 47, 49, 53, 57, 81, 90, 91, 101, 104, 112, 121, 132, 133, 135, 147) order by `order` asc| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (31, 32, 43, 44, 45, 48, 50, 51, 52, 82, 83, 84, 85, 86, 87, 88, 92, 93, 94, 95, 96, 97, 98, 99, 100, 102, 103, 105, 106, 107, 113, 114, 115, 116, 117, 118, 119, 120, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 134, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158) and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory'| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (31, 32, 43, 44, 45, 48, 50, 51, 52, 82, 83, 84, 85, 86, 87, 88, 92, 93, 94, 95, 96, 97, 98, 99, 100, 102, 103, 105, 106, 107, 113, 114, 115, 116, 117, 118, 119, 120, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 134, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158) order by `order` asc| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = 'Botble\\Ecommerce\\Models\\ProductCategory' and `meta_boxes`.`reference_id` = 182 and `meta_boxes`.`reference_id` is not null| Bindings |
|
| Backtrace |
|
select `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = 'published' and `ec_product_categories`.`parent_id` in (183, 193, 201, 203) order by `order` asc| Bindings |
|
| Backtrace |
|
select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (184, 185, 186, 187, 188, 189, 190, 191, 192, 194, 195, 196, 197, 198, 199, 200, 202, 204) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (184, 185, 186, 187, 188, 189, 190, 191, 192, 194, 195, 196, 197, 198, 199, 200, 202, 204) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (55, 56, 58, 239) order by `order` ascselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (1, 2, 3, 7, 10, 15, 16, 20, 231, 232, 233, 234, 235, 236, 237, 238) order by `order` ascselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (4, 5, 6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 21, 22) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (4, 5, 6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 21, 22) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (314, 328, 348) order by `order` ascselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 349, 350) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 349, 350) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (281, 282, 283, 284, 285, 286, 287, 288) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (109, 110, 111) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (160, 163, 169, 172, 178) order by `order` ascselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (161, 162, 164, 165, 166, 167, 168, 170, 171, 173, 174, 175, 176, 177, 179, 180, 181) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (161, 162, 164, 165, 166, 167, 168, 170, 171, 173, 174, 175, 176, 177, 179, 180, 181) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (260, 266, 270, 271) order by `order` ascselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (261, 262, 263, 264, 265, 267, 268, 269, 272, 273, 274, 275, 276, 277, 278, 279, 280) and `slugs`.`reference_type` = ?select * from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (261, 262, 263, 264, 265, 267, 268, 269, 272, 273, 274, 275, 276, 277, 278, 279, 280) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (25, 26, 27, 28, 29) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (34, 35, 36, 37, 38, 39, 40, 41) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77) order by `order` ascselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_type` = ? and `meta_boxes`.`reference_id` = ? and `meta_boxes`.`reference_id` is not nullselect `id`, `name`, `parent_id` from `ec_product_categories` where not `id` is null and `status` = ? and `ec_product_categories`.`parent_id` in (79, 80) order by `order` ascselect distinct `ec_products`.* 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-03-26 07:18:33' OR
ec_products.end_date < '2025-03-26 07:18:33'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:33' AND
ec_products.end_date >= '2025-03-26 07:18:33'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-03-26 07:18:33'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-03-26 07:18:33' 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` = ? and `ec_products`.`is_featured` = ? and `ec_products`.`is_variation` = ? order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 15select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (3557, 10232, 17130, 17134, 17139, 17141, 17149, 17151, 17156, 17160, 17161, 17162, 17178, 17179, 18164) and `slugs`.`reference_type` = ?select * from `ec_product_variations` where `ec_product_variations`.`is_default` = ? and `ec_product_variations`.`configurable_product_id` in (3557, 10232, 17130, 17134, 17139, 17141, 17149, 17151, 17156, 17160, 17161, 17162, 17178, 17179, 18164)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 (3557, 10232, 17130, 17134, 17139, 17141, 17149, 17151, 17156, 17160, 17161, 17162, 17178, 17179, 18164)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 (3557, 10232, 17130, 17134, 17139, 17141, 17149, 17151, 17156, 17160, 17161, 17162, 17178, 17179, 18164)select `ec_brands`.*, (select count(*) from `ec_products` where `ec_brands`.`id` = `ec_products`.`brand_id` and `is_variation` = ? and `status` = ?) as `products_count` from `ec_brands` where `is_featured` = ? and `status` = ? order by `order` asc, `created_at` desc limit 10select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and `slugs`.`reference_type` = ?select * from `contact_custom_fields` where `status` = ? order by `order` ascselect * from `ec_product_categories` where `ec_product_categories`.`id` in (289, 281, 205, 182, 159, 23, 33, 78, 303, 89, 132)select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (23, 33, 78, 89, 132, 159, 182, 205, 281, 289, 303) and `slugs`.`reference_type` = ?select * from `pages` where `pages`.`id` in (6, 8, 9, 10, 11, 12)select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (6, 8, 9, 10, 11, 12) and `slugs`.`reference_type` = ?200
[]
[]
0 of 0array:16 [▼ "host" => array:1 [▶ 0 => "fortunasupermarket.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InM0cjNYOW1mWmx5U0xEc2NkVEtENFE9PSIsInZhbHVlIjoiZnBWQk5vT2psRFhKb2FPMGhnTkxsbGhaMnJpZzJ3bmtXRVRRaGR0N2VrQ1QvdDlEL0JmOVhxNmN3S0xyeU9lcHFLblM2cm9iZkt4QWUveHRqTTh0cE5DaDVicjh0ZmsweGFwOHZqd0FESCsyejRoVlpuTlFSTlFTNzBObmxXVGUiLCJtYWMiOiI3OTc1N2Y4YWIyY2RlMWJjNzE5YjNhODlhYmRkMzI0NWRmMDg1NmIwYzExNTIyODU3MGU1ODgzOWFlYTBiZmJmIiwidGFnIjoiIn0%3D; botble_session=eyJpdiI6ImhhZFNnV0JBNDhyRnFZQTZ6SEpQc2c9PSIsInZhbHVlIjoieEpmTXc2cnFXV3UvRkVLdzdVSDY2cldRVDRubFExVGJya0NjcDduMjdUZ0ZBQ0JUK2xKZnVlUFBDOFlIYXB6aHAyK3dmY2VvR2R0UFVUMTF5NWhjRUd2MldkT2hPTzhOdms0d1BESEEyZm9YOXM5MUJxYkRDcVJjN1FJQlBUZDUiLCJtYWMiOiI1NWYyZmE0MWFmNTE3OGNmZmQzYjJhNDAxNjYyMDUyY2U3ODBlYzZhYzMzNzZmMGVkYjQ2MWFkZGNhNGM0YmE1IiwidGFnIjoiIn0%3D; botble_footprints_cookie=eyJpdiI6Im5tTkFzd3Uxa2RGV05lUk1zbDNUbVE9PSIsInZhbHVlIjoiNWdlU05HTk1CdW1XdUNvWjVIektCc3FPMGtXdzI4eFpzVmN4Yy8yUmQvMDVtVHRaTFEzWFdCSVJaUUtkdEJLTXN1b21aM0FHMkNVVStvWHFJYW1PbEpsWDNIMTFOdUVxK0hRcjIrKzBSR2x1R0NrcGdtNVBRWkZHTUhFeTNJd2MiLCJtYWMiOiI4MTg0ZGU5ODRhYWRjZGIyNjBlMTQwYjRlMjUyMDU1ZWMxYTNkNzEzM2NlMjAzMWRkYTgxODNiYzEwZDhiMjhiIiwidGFnIjoiIn0%3D; botble_footprints_cookie_data=eyJpdiI6IllseG9ZQlRzaTdsM3RpZXhHOFczWFE9PSIsInZhbHVlIjoiZTRQMUNSeGEzd21tSzh3OGsxT2RDdjlhZnV3WGVxR3g3MmUrVEpyQ0FGTmxQc0xDaGlNTG1KK25JYllUUGRFa1puYlF0cktBRm5PbG1rTjM2SkFPZ1J2enQvZmdaek1JQkorc3JqZWhmdnl4eDU0YkpoeGRJOFVLWUloNlVZSC9VVlRaYUI4Q09ROWJRS05Fai9xd0dLWktDaElvU2x4UTN3MS8xS01kUDUxZkxFdW1UUzVvclROcnlJSGdQbDVYZFhtT3Znelk5RjNXQ0Q0c0l0VnR0QmZFVkdibUxySUdjL3dzQkJWbnJDR3hEQ2JTT2xUdm9uU0RBT2hqcVpTSThiOUo5ZGdGS0doU0NHeERialFrSTBuaTl3bGErSnJ0YXU2L1RJRzdyRFl6YnRhQkU4MHZRaG5WVDlwQVVTQjNXdkV1Vmp4M0FUeHFtVDhHdlgwUnJvd2NhYnY4Nnp2MzVvYUlOZjJncllmSmRIWVBqUUp1OVFoZTZsa2tPYnFtL0pHV3NkVm5PeEZwcG8rZGJLUzRaTnQzQkRHcHhjSzlXUWkzWGtPUlpjNXU4bnJra0wrV3dYdmhLdFBwN3YxWEVReVVobElLMDYzdzQ3a1ZvNFVmQXBuTEhPNFJOWEl3WmVNUEJlYWFKb3ZxNmlJbXpQWmF6SEQzMWQzVGdPcG82L01sSW5WWjQ0VWlock55R0ZuOFFBPT0iLCJtYWMiOiJlZmU3MjFmNWVmNGFjYzQ3MTNlNDVjOGFjOWExY2Q3NDExZTlkZmNmNTU5ZjA2NzRmYjM0M2NmYjNjYzg4YjNiIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InM0cjNYOW1mWmx5U0xEc2NkVEtENFE9PSIsInZhbHVlIjoiZnBWQk5vT2psRFhKb2FPMGhnTkxsbGhaMnJpZzJ3bmtXRVRRaGR0N2VrQ1QvdDlEL0JmOVhxNmN3S0xyeU9lcHFLblM2c ▶" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] ]
0 of 0array:4 [▼ "XSRF-TOKEN" => "b5f67BEw6IrxyMm2XWUYK2frmiKQxXoTlUoAoZMp" "botble_session" => "TkV9bNN3PSVBNxwnsILAMpHr67kqrnO7wYzDlsdD" "botble_footprints_cookie" => "5db4adca0b2e79f18255560495ffc46937384911" "botble_footprints_cookie_data" => "{"footprint":"5db4adca0b2e79f18255560495ffc46937384911","ip":"3.142.173.6","landing_domain":"fortunasupermarket.com","landing_page":"brands\/copra","landing_params":null,"referral":null,"gclid":null,"fclid":null,"utm_source":null,"utm_campaign":null,"utm_medium":null,"utm_term":null,"utm_content":null,"referrer_url":null,"referrer_domain":null} ◀{"footprint":"5db4adca0b2e79f18255560495ffc46937384911","ip":"3.142.173.6","landing_domain":"fortunasupermarket.com","landing_page":"brands\/copra","landing_par ▶" ]
0 of 0array:8 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 26 Mar 2025 11:18:34 GMT" ] "cms-version" => array:1 [▶ 0 => "7.4.3" ] "authorization-at" => array:1 [▶ 0 => "2025-02-02 16:48:36" ] "activated-license" => array:1 [▶ 0 => "No" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im5tcWwrYm9ZTklDRUxhdFNpM3I0aWc9PSIsInZhbHVlIjoiNlFvNlBEek1TZ28vU0pWMVdzRHpiOVlxUkxoUVdWQlNJd212dmZ0VEo4SC9IZm1NT01LbTFWM1VCWWw3THVWdURjTkpiaDBhVkdiT0RJSzlDYXlhaTczUEp1VmFuMFQzRlk3MHUwNXB1RUIwcUNzVDJOWDU4a0l2cVROWmM2b24iLCJtYWMiOiI0ZGQ2NTk5ODM4ZTk2ZDA2YTY5NTgzYjA0ZGEyZDQ0YjJhOGMwNjkyYzI4Njc0ZWYyZDJkYmIzOGIwNmJhMTJiIiwidGFnIjoiIn0%3D; expires=Wed, 26 Mar 2025 13:18:34 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im5tcWwrYm9ZTklDRUxhdFNpM3I0aWc9PSIsInZhbHVlIjoiNlFvNlBEek1TZ28vU0pWMVdzRHpiOVlxUkxoUVdWQlNJd212dmZ0VEo4SC9IZm1NT01LbTFWM1VCWWw3THVWdURjTkpia ▶" 1 => "botble_session=eyJpdiI6IjBldkp0bmpjSDhYb0hkc3cwVTA0ZVE9PSIsInZhbHVlIjoiSG5pd3JvbmtXcmNtQkZid1lGTUV3cThSMjRPUit6ZHMzQy9ZcjlnckdGekFRK2hTTDR6b3VhWjFBSGtOb240YkZwbFcwS3lDa2FLZVgrRzNpMjUyMHo0TytmeWwxVndINjR1QytXVWZSb2hseHBNdTI1M0RLbldsalM4UzdkMGEiLCJtYWMiOiI1MWRkMWFiODIzMThiYmJmYjkyNjEwMDI5YzRkMWEzOWRjMzQ2NzJmZDlmNzU2MjVkOWUyZTk2MzFkOGE3MjA4IiwidGFnIjoiIn0%3D; expires=Wed, 26 Mar 2025 13:18:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6IjBldkp0bmpjSDhYb0hkc3cwVTA0ZVE9PSIsInZhbHVlIjoiSG5pd3JvbmtXcmNtQkZid1lGTUV3cThSMjRPUit6ZHMzQy9ZcjlnckdGekFRK2hTTDR6b3VhWjFBSGtOb240YkZwb ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im5tcWwrYm9ZTklDRUxhdFNpM3I0aWc9PSIsInZhbHVlIjoiNlFvNlBEek1TZ28vU0pWMVdzRHpiOVlxUkxoUVdWQlNJd212dmZ0VEo4SC9IZm1NT01LbTFWM1VCWWw3THVWdURjTkpiaDBhVkdiT0RJSzlDYXlhaTczUEp1VmFuMFQzRlk3MHUwNXB1RUIwcUNzVDJOWDU4a0l2cVROWmM2b24iLCJtYWMiOiI0ZGQ2NTk5ODM4ZTk2ZDA2YTY5NTgzYjA0ZGEyZDQ0YjJhOGMwNjkyYzI4Njc0ZWYyZDJkYmIzOGIwNmJhMTJiIiwidGFnIjoiIn0%3D; expires=Wed, 26-Mar-2025 13:18:34 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im5tcWwrYm9ZTklDRUxhdFNpM3I0aWc9PSIsInZhbHVlIjoiNlFvNlBEek1TZ28vU0pWMVdzRHpiOVlxUkxoUVdWQlNJd212dmZ0VEo4SC9IZm1NT01LbTFWM1VCWWw3THVWdURjTkpia ▶" 1 => "botble_session=eyJpdiI6IjBldkp0bmpjSDhYb0hkc3cwVTA0ZVE9PSIsInZhbHVlIjoiSG5pd3JvbmtXcmNtQkZid1lGTUV3cThSMjRPUit6ZHMzQy9ZcjlnckdGekFRK2hTTDR6b3VhWjFBSGtOb240YkZwbFcwS3lDa2FLZVgrRzNpMjUyMHo0TytmeWwxVndINjR1QytXVWZSb2hseHBNdTI1M0RLbldsalM4UzdkMGEiLCJtYWMiOiI1MWRkMWFiODIzMThiYmJmYjkyNjEwMDI5YzRkMWEzOWRjMzQ2NzJmZDlmNzU2MjVkOWUyZTk2MzFkOGE3MjA4IiwidGFnIjoiIn0%3D; expires=Wed, 26-Mar-2025 13:18:34 GMT; path=/; httponly ◀botble_session=eyJpdiI6IjBldkp0bmpjSDhYb0hkc3cwVTA0ZVE9PSIsInZhbHVlIjoiSG5pd3JvbmtXcmNtQkZid1lGTUV3cThSMjRPUit6ZHMzQy9ZcjlnckdGekFRK2hTTDR6b3VhWjFBSGtOb240YkZwb ▶" ] ]
0 of 0array:6 [▼ "_token" => "b5f67BEw6IrxyMm2XWUYK2frmiKQxXoTlUoAoZMp" "language" => "en" "_previous" => array:1 [▶ "url" => "https://fortunasupermarket.com/products/bbb-fruit-drink-blueberry-2l" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "viewed_product" => array:1 [▶ 16690 => 1742987910 ] "cart" => array:2 [▶ "recently_viewed_updated_at" => Carbon\Carbon @1742987910 {#4324 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "00000000000010e40000000000000000" #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-03-26 07:18:30.979893 America/New_York (-04:00) } "recently_viewed" => Illuminate\Support\Collection {#4364 ▶ #items: array:1 [▶ "d4d1bab8a6fa7bb9db69b9856d93de53" => Botble\Ecommerce\Cart\CartItem {#3189 ▶ +rowId: "d4d1bab8a6fa7bb9db69b9856d93de53" +id: 16690 +qty: 1 +name: "BBB Fruit Drink Blueberry 2L." +price: 4.79 +options: Botble\Ecommerce\Cart\CartItemOptions {#3999 ▶ #items: [] #escapeWhenCastingToString: false } #associatedModel: "Botble\Ecommerce\Models\Product" #taxRate: 0.0 +"created_at": Carbon\Carbon @1742987910 {#3190 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000c760000000000000000" #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-03-26 07:18:30.979869 America/New_York (-04:00) } +"updated_at": Carbon\Carbon @1742987910 {#4375 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "00000000000011170000000000000000" #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-03-26 07:18:30.979875 America/New_York (-04:00) } } ] #escapeWhenCastingToString: false } ] ]