1 x Application (58.72%) | 430.22ms |
1 x Booting (41.25%) | 302.20ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
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` = 'dominos-e-gift-instant-voucher' 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-19 02:34:30' OR
ec_products.end_date < '2025-05-19 02:34:30'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-19 02:34:30' AND
ec_products.end_date >= '2025-05-19 02:34: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-05-19 02:34:30'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-19 02:34: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 `status` = 'published' and `ec_products`.`id` = 106 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 (106) 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 (106)
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 (106)
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 (106)
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 (106)
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 (106)
Metadata | |
---|---|
Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (106) order by `order` asc
Metadata | |
---|---|
Backtrace |
|
select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2025-05-19 02:34:30' and (`end_date` is null or `end_date` >= '2025-05-19 02:34: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))
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_flash_sales` where date(`end_date`) >= '2025-05-19' and `status` = 'published' order by `created_at` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
update `ec_products` set `views` = `views` + 1 where `id` = 106
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 106 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 (106)
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 (106)
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 (106)
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 (106)
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 (106)
Metadata | |
---|---|
Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (106) order by `order` asc
Metadata | |
---|---|
Backtrace |
|
insert into `ec_product_views` (`date`, `product_id`, `views`) values ('2025-05-19', 106, 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 (106) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\Product'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 106 and `ec_product_variations`.`configurable_product_id` is not null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ec_product_attributes`.*, `ec_product_variation_items`.`variation_id` as `pivot_variation_id`, `ec_product_variation_items`.`attribute_id` as `pivot_attribute_id` from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` where `ec_product_variation_items`.`variation_id` = 76
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variations` where `configurable_product_id` = 106 and (select count(*) from `ec_product_variation_items` where `ec_product_variations`.`id` = `ec_product_variation_items`.`variation_id` and `attribute_id` in (11)) = 1 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variation_items` where `ec_product_variation_items`.`variation_id` in (76)
Metadata | |
---|---|
Backtrace |
|
select `ec_products`.`id`, `ec_products`.`name`, `ec_products`.`quantity`, `ec_products`.`price`, `ec_products`.`sale_price`, `ec_products`.`allow_checkout_when_out_of_stock`, `ec_products`.`with_storehouse_management`, `ec_products`.`stock_status`, `ec_products`.`images`, `ec_products`.`sku`, `ec_products`.`barcode`, `ec_products`.`description`, `ec_products`.`is_variation` from `ec_products` inner join `ec_product_variations` on `ec_product_variations`.`product_id` = `ec_products`.`id` and `ec_product_variations`.`configurable_product_id` = 106 inner join `ec_products` as `original_products` on `ec_product_variations`.`configurable_product_id` = `original_products`.`id` where `ec_product_variations`.`id` = 76 and `original_products`.`status` = 'published' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 107 and `ec_product_variations`.`configurable_product_id` is not null and `ec_product_variations`.`is_default` = 1 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_products` where `ec_products`.`id` = 107 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` = 106 and `status` = 'published' and date(`end_date`) >= '2025-05-19' 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` = 106 and `ec_product_variations`.`configurable_product_id` is not null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ec_product_attribute_sets`.*, `ec_product_with_attribute_set`.`product_id` as `pivot_product_id`, `ec_product_with_attribute_set`.`attribute_set_id` as `pivot_attribute_set_id` from `ec_product_attribute_sets` inner join `ec_product_with_attribute_set` on `ec_product_attribute_sets`.`id` = `ec_product_with_attribute_set`.`attribute_set_id` where `ec_product_with_attribute_set`.`product_id` = 106 order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select distinct `ec_product_attributes`.* from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_variation_items`.`attribute_id` = `ec_product_attributes`.`id` inner join `ec_product_variations` on `ec_product_variation_items`.`variation_id` = `ec_product_variations`.`id` where `configurable_product_id` = 106
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variations` where `configurable_product_id` = 106
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ec_product_attributes`.*, `ec_product_variation_items`.`variation_id` as `pivot_variation_id`, `ec_product_variation_items`.`attribute_id` as `pivot_attribute_id` from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` where `ec_product_variation_items`.`variation_id` in (76, 77, 78, 79, 80)
Metadata | |
---|---|
Backtrace |
|
select * from `ec_products` where `ec_products`.`id` in (107, 108, 109, 110, 111)
Metadata | |
---|---|
Backtrace |
|
select distinct `ec_product_variation_items`.`variation_id`, `ec_product_attributes`.*, `ec_product_attribute_sets`.`title` as `attribute_set_title`, `ec_product_attribute_sets`.`slug` as `attribute_set_slug` from `ec_product_variation_items` inner join `ec_product_attributes` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` inner join `ec_product_attribute_sets` on `ec_product_attribute_sets`.`id` = `ec_product_attributes`.`attribute_set_id` where `ec_product_variation_items`.`variation_id` in (76, 77, 78, 79, 80)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`id` in (76, 77, 78, 79, 80)
Metadata | |
---|---|
Backtrace |
|
select * from `ec_products` where `ec_products`.`id` in (107, 108, 109, 110, 111)
Metadata | |
---|---|
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` = 106 and `status` = 'published' limit 7
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `to_product_id` from `ec_product_related_relations` where `ec_product_related_relations`.`from_product_id` = 106
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-19 02:34:30' OR
ec_products.end_date < '2025-05-19 02:34:30'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-19 02:34:30' AND
ec_products.end_date >= '2025-05-19 02:34: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-05-19 02:34:30'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-05-19 02:34: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 `status` = 'published' and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 106 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` = 106 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-682a98b6-410b927072b5448e517f3049" ] "host" => array:1 [▶ 0 => "yuonqdmmxh.drink2drink.com" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "52.15.253.106" ] ]
0 of 0array:51 [▼ "USER" => "apache" "HOME" => "/usr/share/httpd" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/products/dominos-e-gift-instant-voucher" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/products/dominos-e-gift-instant-voucher" "REMOTE_PORT" => "4442" "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.39.31" "SERVER_PORT" => "80" "SERVER_ADDR" => "172.31.39.111" "SERVER_NAME" => "yuonqdmmxh.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-682a98b6-410b927072b5448e517f3049" "HTTP_HOST" => "yuonqdmmxh.drink2drink.com" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "52.15.253.106" "proxy-nokeepalive" => "1" "UNIQUE_ID" => "aCqYtiAak_V8CNanUjQcsgAAAAE" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aCqYtiAak_V8CNanUjQcsgAAAAE" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1747622070.4042 "REQUEST_TIME" => 1747622070 "HTTPS" => "on" ]
[]
0 of 0array:8 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 19 May 2025 02:34:31 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=eyJpdiI6Im1UWkJ4ellnUXF4UndFMUNzUUxwc2c9PSIsInZhbHVlIjoieGNlYU5oUUw5R1l0cmFsaFIzSzZYZUxFOGxwSmFvMXVabDNVNDVpTGJNVDg4L0h3TVlwc1hkZ2hqWVZ3ejJBMDdlZkMyYTA1cTNTRE9kU09sanpOcHpXQWlnMm4zZGtuS1hNZmVqYm9HWExkVkpSeWl5UHFwdlVCcjdLRjhhMHgiLCJtYWMiOiI0YTIyNmVjMGRjOWI2ZmFjNzM0ZjA4MjczNjM4NTY2ODFmOTVmYTcyZDM4NzI0OTU3NmI4YjNhNGM1NmM1MzExIiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 04:34:31 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im1UWkJ4ellnUXF4UndFMUNzUUxwc2c9PSIsInZhbHVlIjoieGNlYU5oUUw5R1l0cmFsaFIzSzZYZUxFOGxwSmFvMXVabDNVNDVpTGJNVDg4L0h3TVlwc1hkZ2hqWVZ3ejJBMDdlZkMyY ▶" 1 => "botble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMUkhrQVExbHRMdVVacnBTMG5OY1prdkhKdm5IRGF4RUlad1FTRnpYWG9SSDk1Rk9LaFJYaFdxQVZaNDRuR24iLCJtYWMiOiI3MjUwNGUyYjEwMWZmYjdiYzFiYjYzNjUyNDQ4MjIwYjE0OWFlOTE5YTI5NzA0ZmJiMDA3NWNjYzk2ZDIwMjI5IiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 04:34:31 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMU ▶" 2 => "botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5XYmpualhmcWxqTTVLb0NpQWFyVkRPYWt6R3Y0WEl6SFdnckZSSlNWMnBTMW1XbjN5VWNSLzJMUjl5REFmNEZuUkJ6RGciLCJtYWMiOiJhNWIwOTc5Yjk3MjE0NWZjNWMyYjRhMjNiYmU0ZmQ2ZWQ0MmE5OGE5MjgwNmQ3YmQ3NjAwMjE1MGI0YTUyY2NlIiwidGFnIjoiIn0%3D; expires=Mon, 13 Jul 2026 02:34:30 GMT; Max-Age=36287999; path=/; httponly; samesite=lax ◀botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5 ▶" 3 => "botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUjlxK3pFNU82bGV5eGd6cGEyWG1sdW9LQWZOOG5wK3hKTVZrdE95aTFkaEZaOVNmVnhZbUIydXFzUnlzTERQS0NNdVZYeTVWaUkrOVNmSUpCeVh2MENLZXMvbmdJRTZ2MHNWS0VhNnI3N3pFQW4wdmZUTXNDdWlGREk3QTVFV2tJQWlaRHdrd0VoRmRtL0luOVNVdVBqUkE4K0gyLzVKa2RuMXh5RXZwRmcvckNUckRzM2NlY2pDNTZuVzNOaXNoUEhCV1RhaEZsdmZFaUUrVHNzZVkrYlBxYktURXZ1aGtpTEh6QSt6T0h2Mm1kMUNSVVdOaE1pQ1p5bDFPbU0yVElOZVNjd3hhTmtySFJNOTJiaU9QTFN1ODJNVGZTdTlkYUVZSkhTVFdmRTZsU21ZNHNIeVVCc011b3ZTdXFqdFlpVWM2NlNoOTdWbkJ0V0lxQ256SnVjK3JCVTFZMDhmdVQ4Zk1GMWVUM1l2VklOVHhZMkFLb1hhd0FvOVBURDUwSmIyc0tzaGlqWmh3M2QyeGg3QmhyenpPNUJZUU9JTDR6ZTJEMzRsbTlvMnNWM1kvdnVaL1NYaVpxUFZDb08wMm1tcUdzWlUwN3ZmZ1VBc1N0L3BINHpvbnV2SXlsaTJuK29RVjY3WW1XditsMm5jNDdnSjJ1bzdRVGo0enQxQWpGVkluL1VRa0ZNIiwibWFjIjoiMjY4NjdmOTM2M2E3Y2JmYTJiOGZiNTA2NWRjZDllZjUwZTgyNTY5ODAwY2Y0YmIwYmJiN2I3NmUxYWNjZTk1ZSIsInRhZyI6IiJ9; expires=Mon, 13 Jul 2026 02:34:30 GMT; Max-Age=36287999; path=/; httponly; samesite=lax ◀botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUj ▶" ] "Set-Cookie" => array:4 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im1UWkJ4ellnUXF4UndFMUNzUUxwc2c9PSIsInZhbHVlIjoieGNlYU5oUUw5R1l0cmFsaFIzSzZYZUxFOGxwSmFvMXVabDNVNDVpTGJNVDg4L0h3TVlwc1hkZ2hqWVZ3ejJBMDdlZkMyYTA1cTNTRE9kU09sanpOcHpXQWlnMm4zZGtuS1hNZmVqYm9HWExkVkpSeWl5UHFwdlVCcjdLRjhhMHgiLCJtYWMiOiI0YTIyNmVjMGRjOWI2ZmFjNzM0ZjA4MjczNjM4NTY2ODFmOTVmYTcyZDM4NzI0OTU3NmI4YjNhNGM1NmM1MzExIiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 04:34:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1UWkJ4ellnUXF4UndFMUNzUUxwc2c9PSIsInZhbHVlIjoieGNlYU5oUUw5R1l0cmFsaFIzSzZYZUxFOGxwSmFvMXVabDNVNDVpTGJNVDg4L0h3TVlwc1hkZ2hqWVZ3ejJBMDdlZkMyY ▶" 1 => "botble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMUkhrQVExbHRMdVVacnBTMG5OY1prdkhKdm5IRGF4RUlad1FTRnpYWG9SSDk1Rk9LaFJYaFdxQVZaNDRuR24iLCJtYWMiOiI3MjUwNGUyYjEwMWZmYjdiYzFiYjYzNjUyNDQ4MjIwYjE0OWFlOTE5YTI5NzA0ZmJiMDA3NWNjYzk2ZDIwMjI5IiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 04:34:31 GMT; path=/; httponly ◀botble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMU ▶" 2 => "botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5XYmpualhmcWxqTTVLb0NpQWFyVkRPYWt6R3Y0WEl6SFdnckZSSlNWMnBTMW1XbjN5VWNSLzJMUjl5REFmNEZuUkJ6RGciLCJtYWMiOiJhNWIwOTc5Yjk3MjE0NWZjNWMyYjRhMjNiYmU0ZmQ2ZWQ0MmE5OGE5MjgwNmQ3YmQ3NjAwMjE1MGI0YTUyY2NlIiwidGFnIjoiIn0%3D; expires=Mon, 13-Jul-2026 02:34:30 GMT; path=/; httponly ◀botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5 ▶" 3 => "botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUjlxK3pFNU82bGV5eGd6cGEyWG1sdW9LQWZOOG5wK3hKTVZrdE95aTFkaEZaOVNmVnhZbUIydXFzUnlzTERQS0NNdVZYeTVWaUkrOVNmSUpCeVh2MENLZXMvbmdJRTZ2MHNWS0VhNnI3N3pFQW4wdmZUTXNDdWlGREk3QTVFV2tJQWlaRHdrd0VoRmRtL0luOVNVdVBqUkE4K0gyLzVKa2RuMXh5RXZwRmcvckNUckRzM2NlY2pDNTZuVzNOaXNoUEhCV1RhaEZsdmZFaUUrVHNzZVkrYlBxYktURXZ1aGtpTEh6QSt6T0h2Mm1kMUNSVVdOaE1pQ1p5bDFPbU0yVElOZVNjd3hhTmtySFJNOTJiaU9QTFN1ODJNVGZTdTlkYUVZSkhTVFdmRTZsU21ZNHNIeVVCc011b3ZTdXFqdFlpVWM2NlNoOTdWbkJ0V0lxQ256SnVjK3JCVTFZMDhmdVQ4Zk1GMWVUM1l2VklOVHhZMkFLb1hhd0FvOVBURDUwSmIyc0tzaGlqWmh3M2QyeGg3QmhyenpPNUJZUU9JTDR6ZTJEMzRsbTlvMnNWM1kvdnVaL1NYaVpxUFZDb08wMm1tcUdzWlUwN3ZmZ1VBc1N0L3BINHpvbnV2SXlsaTJuK29RVjY3WW1XditsMm5jNDdnSjJ1bzdRVGo0enQxQWpGVkluL1VRa0ZNIiwibWFjIjoiMjY4NjdmOTM2M2E3Y2JmYTJiOGZiNTA2NWRjZDllZjUwZTgyNTY5ODAwY2Y0YmIwYmJiN2I3NmUxYWNjZTk1ZSIsInRhZyI6IiJ9; expires=Mon, 13-Jul-2026 02:34:30 GMT; path=/; httponly ◀botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUj ▶" ] ]
0 of 0array:7 [▼ "_token" => "VQGsN8QqROgFKvv0vBC8GcallJ5J4LRoHO201s6y" "language" => "en" "viewed_product" => array:1 [▶ 106 => 1747622070 ] "cart" => array:2 [▶ "recently_viewed_updated_at" => Carbon\Carbon @1747622070 {#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-19 02:34:30.800570 UTC (+00:00) } "recently_viewed" => Illuminate\Support\Collection {#3433 ▶ #items: array:1 [▶ "2b8a4f7f6e9b1dbdd1e9235e37b99f1a" => Botble\Ecommerce\Cart\CartItem {#3435 ▶ +rowId: "2b8a4f7f6e9b1dbdd1e9235e37b99f1a" +id: 106 +qty: 1 +name: "Dominos E-Gift (Instant Voucher)" +price: 0.0 +options: Botble\Ecommerce\Cart\CartItemOptions {#3431 ▶ #items: [] #escapeWhenCastingToString: false } #associatedModel: "Botble\Ecommerce\Models\Product" #taxRate: 0 +"created_at": Carbon\Carbon @1747622070 {#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-19 02:34:30.800513 UTC (+00:00) } +"updated_at": Carbon\Carbon @1747622070 {#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-19 02:34:30.800523 UTC (+00:00) } } ] #escapeWhenCastingToString: false } ] "_previous" => array:1 [▶ "url" => "https://yuonqdmmxh.drink2drink.com/products/dominos-e-gift-instant-voucher" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]