Shopping Cart

Dominos E-Gift (Instant Voucher)

$0.00

Sold Byh: Daisy

(Available)
Quantity

SKU: MF-2443-LTGZM


0.00

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Submit Your Review

Please login to write review!

Upload photos
You can upload up to 6 photos, each photo maximum size is 2048 kilobytes
8.1.23PHP Version733msRequest Duration45MBMemory UsageGET products/{slug}RouteAuth status
  • warninglog[02:34:30] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • Booting (302ms)
  • Application (430ms)
  • 1 x Application (58.72%)
    430.22ms
    1 x Booting (41.25%)
    302.20ms
    41 templates were rendered
    • theme.martfury::views.ecommerce.product (platform/themes/martfury/views/ecommerce/product.blade.php)5bladefile
      Params
      0
      product
      1
      selectedAttrs
      2
      productImages
      3
      productVariation
      4
      vendorproduct
    • theme.martfury::partials.header-product-page (platform/themes/martfury/partials/header-product-page.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.footer-product-page (platform/themes/martfury/partials/footer-product-page.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.header-mobile-product (platform/themes/martfury/partials/header-mobile-product.blade.php)0bladefile
    • theme.martfury::partials.cart (platform/themes/martfury/partials/cart.blade.php)0bladefile
    • theme.martfury::views.ecommerce.attributes.swatches-renderer (platform/themes/martfury/views/ecommerce/attributes/swatches-renderer.blade.php)6bladefile
      Params
      0
      attributeSets
      1
      attributes
      2
      product
      3
      selected
      4
      productVariationsInfo
      5
      productVariations
    • theme.martfury::views.ecommerce.attributes._layouts.dropdown (platform/themes/martfury/views/ecommerce/attributes/_layouts/dropdown.blade.php)15bladefile
      Params
      0
      __env
      1
      app
      2
      errors
      3
      attributeSets
      4
      attributes
      5
      product
      6
      selected
      7
      productVariationsInfo
      8
      productVariations
      9
      key
      10
      variationInfo
      11
      variationNextIds
      12
      __currentLoopData
      13
      set
      14
      loop
    • packages/theme::partials.facebook-comments (platform/packages/theme/resources/views/partials/facebook-comments.blade.php)0bladefile
    • plugins/ads::partials.ad-display (platform/plugins/ads/resources/views/partials/ad-display.blade.php)2bladefile
      Params
      0
      data
      1
      attributes
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::partials.product-item (platform/themes/martfury/partials/product-item.blade.php)1bladefile
      Params
      0
      product
    • theme.martfury::layouts.default (platform/themes/martfury/layouts/default.blade.php)0bladefile
    • theme.martfury::partials.header (platform/themes/martfury/partials/header.blade.php)0bladefile
    • packages/theme::partials.header (platform/packages/theme/resources/views/partials/header.blade.php)0bladefile
    • plugins/captcha::header-meta (platform/plugins/captcha/resources/views/header-meta.blade.php)0bladefile
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.cart (platform/themes/martfury/partials/cart.blade.php)0bladefile
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.language-switcher (platform/themes/martfury/partials/language-switcher.blade.php)0bladefile
    • theme.martfury::partials.cart (platform/themes/martfury/partials/cart.blade.php)0bladefile
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.menu (platform/themes/martfury/partials/menu.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::partials.breadcrumbs (platform/themes/martfury/partials/breadcrumbs.blade.php)0bladefile
    • theme.martfury::partials.footer (platform/themes/martfury/partials/footer.blade.php)0bladefile
    • packages/widget::widgets.text.frontend (platform/packages/widget/resources/views/widgets/text/frontend.blade.php)4bladefile
      Params
      0
      config
      1
      sidebar
      2
      position
      3
      widgetId
    • theme.martfury::/../widgets/custom-menu/templates.frontend (platform/themes/martfury/widgets/custom-menu/templates/frontend.blade.php)4bladefile
      Params
      0
      config
      1
      sidebar
      2
      position
      3
      widgetId
    • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::/../widgets/custom-menu/templates.frontend (platform/themes/martfury/widgets/custom-menu/templates/frontend.blade.php)4bladefile
      Params
      0
      config
      1
      sidebar
      2
      position
      3
      widgetId
    • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • theme.martfury::/../widgets/custom-menu/templates.frontend (platform/themes/martfury/widgets/custom-menu/templates/frontend.blade.php)4bladefile
      Params
      0
      config
      1
      sidebar
      2
      position
      3
      widgetId
    • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3bladefile
      Params
      0
      menu
      1
      menu_nodes
      2
      options
    • packages/theme::partials.footer (platform/packages/theme/resources/views/partials/footer.blade.php)0bladefile
    • packages/theme::partials.facebook-integration (platform/packages/theme/resources/views/partials/facebook-integration.blade.php)0bladefile
    • plugins/cookie-consent::index (platform/plugins/cookie-consent/resources/views/index.blade.php)2bladefile
      Params
      0
      alreadyConsentedWithCookies
      1
      cookieConsentConfig
    uri
    GET products/{slug}
    middleware
    web, core, localeSessionRedirect, localizationRedirect
    as
    public.product
    controller
    Botble\Ecommerce\Http\Controllers\Fronts\PublicProductController@getProduct
    namespace
    Botble\Ecommerce\Http\Controllers\Fronts
    prefix
    /
    where
    file
    platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:87-224
    71 statements were executed, 14 of which were duplicated, 57 unique. Show only duplicated41.78ms
    • select * from `slugs` where (`key` = 'dominos-e-gift-instant-voucher' and `prefix` = 'products') limit 1
      760μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. dominos-e-gift-instant-voucher
      • 1. products
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 17. /platform/packages/slug/src/SlugHelper.php:157
      • 19. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:89
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `ec_currencies` order by `order` asc
      490μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:107
      • 17. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:41
      • 18. /platform/plugins/ecommerce/helpers/currencies.php:141
      • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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
      1.22ms/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. published
      • 1. published
      • 2. published
      • 3. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 17. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 18. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 19. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 20. /platform/plugins/ecommerce/helpers/products.php:46
    • select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (106) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'
      450μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Ecommerce\Models\Product
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 25. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (106)
      410μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 25. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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)
      520μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 24. /platform/plugins/ecommerce/helpers/products.php:46
    • 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)
      400μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 24. /platform/plugins/ecommerce/helpers/products.php:46
    • select * from `mp_stores` where `mp_stores`.`id` in (29)
      470μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 25. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (29) and `slugs`.`reference_type` = 'Botble\Marketplace\Models\Store'
      400μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Marketplace\Models\Store
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 27. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 29. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 30. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
    • 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)
      390μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 24. /platform/plugins/ecommerce/helpers/products.php:46
    • 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)
      390μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 24. /platform/plugins/ecommerce/helpers/products.php:46
    • select * from `ec_options` where `ec_options`.`product_id` in (106) order by `order` asc
      370μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 25. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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))
      560μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. promotion
      • 1. 2025-05-19 02:34:30
      • 2. 2025-05-19 02:34:30
      • 3. all-orders
      • 4. amount-minimum-order
      • 5. customer
      • 6. group-products
      • 7. products-by-category
      • 8. specific-product
      • 9. product-variant
      • 10. 1
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/DiscountRepository.php:50
      • 17. /platform/plugins/ecommerce/src/Supports/DiscountSupport.php:98
      • 18. /platform/plugins/ecommerce/src/Supports/DiscountSupport.php:41
      • 19. /platform/plugins/ecommerce/src/Models/Product.php:415
    • select * from `ec_flash_sales` where date(`end_date`) >= '2025-05-19' and `status` = 'published' order by `created_at` desc
      450μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 2025-05-19
      • 1. published
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/FlashSaleRepository.php:22
      • 17. /platform/plugins/ecommerce/src/Supports/FlashSaleSupport.php:46
      • 18. /platform/plugins/ecommerce/src/Supports/FlashSaleSupport.php:16
      • 19. /platform/plugins/ecommerce/src/Models/Product.php:400
    • update `ec_products` set `views` = `views` + 1 where `id` = 106
      1.31ms/platform/core/base/src/Supports/Helper.php:34shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 17. /platform/core/base/src/Supports/Helper.php:34
      • 20. /platform/core/base/src/Supports/Helper.php:34
      • 22. /platform/core/base/src/Supports/Helper.php:34
      • 23. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:154
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • select * from `ec_products` where `ec_products`.`id` = 106 limit 1
      620μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 18. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 19. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 20. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 23. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
    • select * from `ec_product_variations` where `ec_product_variations`.`is_default` = 1 and `ec_product_variations`.`configurable_product_id` in (106)
      440μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 22. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 23. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 26. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
    • 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)
      440μs/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109shopping
      Metadata
      Backtrace
      • 19. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 20. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 24. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
      • 25. /vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:102
    • 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)
      390μs/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109shopping
      Metadata
      Backtrace
      • 19. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 20. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 24. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
      • 25. /vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:102
    • 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)
      430μs/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109shopping
      Metadata
      Backtrace
      • 19. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 20. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 24. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
      • 25. /vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:102
    • 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)
      530μs/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109shopping
      Metadata
      Backtrace
      • 19. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 20. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 24. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
      • 25. /vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:102
    • select * from `ec_options` where `ec_options`.`product_id` in (106) order by `order` asc
      490μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:109
      • 22. /vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php:62
      • 23. /vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php:93
      • 26. /vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php:60
    • insert into `ec_product_views` (`date`, `product_id`, `views`) values ('2025-05-19', 106, 1) on duplicate key update `views` = views + 1
      1.54ms/platform/plugins/ecommerce/src/Listeners/UpdateProductView.php:27shopping
      Metadata
      Bindings
      • 0. 2025-05-19
      • 1. 106
      • 2. 1
      Backtrace
      • 11. /platform/plugins/ecommerce/src/Listeners/UpdateProductView.php:27
      • 13. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
      • 14. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
      • 15. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
    • 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'
      450μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Ecommerce\Models\Product
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 24. /platform/packages/seo-helper/src/Providers/HookServiceProvider.php:72
      • 28. /platform/core/base/helpers/action-filter.php:46
      • 30. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
      • 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 106 and `ec_product_variations`.`configurable_product_id` is not null
      400μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseModel.php:28
      • 22. /platform/plugins/ecommerce/src/Supports/EcommerceHelper.php:699
      • 24. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:192
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 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
      540μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 76
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Supports/EcommerceHelper.php:707
      • 23. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:192
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • 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
      700μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      • 1. 11
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 17. /platform/plugins/ecommerce/src/Models/ProductVariation.php:90
      • 18. /platform/plugins/ecommerce/src/Supports/EcommerceHelper.php:736
      • 20. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:192
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • select * from `ec_product_variation_items` where `ec_product_variation_items`.`variation_id` in (76)
      410μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/plugins/ecommerce/src/Models/ProductVariation.php:90
      • 24. /platform/plugins/ecommerce/src/Supports/EcommerceHelper.php:736
      • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:192
    • 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
      520μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      • 1. 76
      • 2. published
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 17. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:346
      • 18. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:200
      • 19. /platform/plugins/ecommerce/src/Supports/EcommerceHelper.php:759
      • 21. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:192
    • 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
      380μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 107
      • 1. 1
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/base/src/Models/BaseModel.php:28
      • 23. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:197
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `ec_products` where `ec_products`.`id` = 107 limit 1
      460μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 107
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/base/src/Models/BaseModel.php:28
      • 23. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:202
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
      • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • 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
      740μsview::theme.martfury::views.ecommerce.product:89shopping
      Metadata
      Bindings
      • 0. 106
      • 1. published
      • 2. 2025-05-19
      Backtrace
      • 16. view::theme.martfury::views.ecommerce.product:89
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:207
    • 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
      400μsview::theme.martfury::views.ecommerce.product:122shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 19. view::theme.martfury::views.ecommerce.product:122
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:207
    • 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
      520μs/platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:34shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 15. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:34
      • 16. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • 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
      670μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:65
      • 17. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:36
      • 18. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select * from `ec_product_variations` where `configurable_product_id` = 106
      390μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:41
      • 17. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 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)
      510μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 20. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:41
      • 21. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `ec_products` where `ec_products`.`id` in (107, 108, 109, 110, 111)
      670μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:41
      • 23. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • 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)
      620μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 76
      • 1. 77
      • 2. 78
      • 3. 79
      • 4. 80
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ecommerce/src/Models/ProductVariationItem.php:47
      • 17. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:43
      • 18. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select * from `ec_product_variations` where `ec_product_variations`.`id` in (76, 77, 78, 79, 80)
      380μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:46
      • 24. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `ec_products` where `ec_products`.`id` in (107, 108, 109, 110, 111)
      480μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 24. /platform/plugins/ecommerce/src/Supports/RenderProductSwatchesSupport.php:46
      • 25. /platform/plugins/ecommerce/helpers/product-variations.php:30
      • 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `ads`
      480μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/plugins/ads/src/Supports/AdsManager.php:54
      • 17. /platform/plugins/ads/src/Supports/AdsManager.php:45
      • 18. /platform/plugins/ads/src/Supports/AdsManager.php:29
      • 20. view::theme.martfury::views.ecommerce.product:463
    • 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
      720μs/platform/plugins/ecommerce/helpers/products.php:289shopping
      Metadata
      Bindings
      • 0. published
      • 1. published
      • 2. 106
      • 3. published
      Backtrace
      • 15. /platform/plugins/ecommerce/helpers/products.php:289
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select `to_product_id` from `ec_product_related_relations` where `ec_product_related_relations`.`from_product_id` = 106
      340μs/platform/plugins/ecommerce/helpers/products.php:262shopping
      Metadata
      Bindings
      • 0. 106
      Backtrace
      • 14. /platform/plugins/ecommerce/helpers/products.php:262
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:207
    • 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
      3.78ms/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. published
      • 1. published
      • 2. published
      • 3. 0
      • 4. 106
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 17. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 18. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 19. /platform/plugins/ecommerce/helpers/products.php:270
    • 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'
      500μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Ecommerce\Models\Product
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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)
      430μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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)
      550μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 23. /platform/plugins/ecommerce/helpers/products.php:270
    • 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)
      430μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 19. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 22. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
      • 23. /platform/plugins/ecommerce/helpers/products.php:270
    • select * from `mp_stores` where `mp_stores`.`id` in (2, 29, 41)
      520μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 23. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
      • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:88
    • 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'
      520μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Marketplace\Models\Store
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 27. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 28. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:348
      • 29. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:641
    • 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
      520μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 279
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • 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
      470μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 266
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • 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
      470μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 253
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • 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
      560μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 150
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • 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
      550μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 119
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • 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
      510μs/platform/core/base/src/Models/BaseModel.php:28shopping
      Metadata
      Bindings
      • 0. 118
      Backtrace
      • 20. /platform/core/base/src/Models/BaseModel.php:28
      • 21. /platform/plugins/ecommerce/src/Models/Product.php:415
      • 22. /platform/plugins/ecommerce/src/Models/Product.php:331
      • 29. /platform/core/base/src/Models/BaseModel.php:28
      • 30. view::theme.martfury::partials.product-item:15
    • select * from `ec_brands` where `ec_brands`.`id` = 0 limit 1
      550μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. 0
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/core/base/src/Models/BaseModel.php:28
      • 23. /platform/plugins/ecommerce/src/Providers/HookServiceProvider.php:373
      • 27. /platform/core/base/helpers/action-filter.php:39
      • 30. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select * from `meta_boxes` where (`meta_key` = 'faq_schema_config' and `reference_id` = 106 and `reference_type` = 'Botble\Ecommerce\Models\Product') limit 1
      450μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. faq_schema_config
      • 1. 106
      • 2. Botble\Ecommerce\Models\Product
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 17. /platform/core/base/src/Supports/MetaBox.php:177
      • 18. /platform/core/base/src/Supports/MetaBox.php:159
      • 20. /platform/plugins/ecommerce/src/Providers/HookServiceProvider.php:314
      • 24. /platform/core/base/helpers/action-filter.php:39
    • 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')
      970μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. published
      • 1. Botble\Menu\Models\Menu
      • 2. en_US
      • 3. en_US
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/packages/menu/src/Menu.php:211
      • 17. /platform/packages/menu/src/Menu.php:194
      • 18. /platform/packages/menu/src/Menu.php:162
      • 20. view::theme.martfury::partials.header:90
    • select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9)
      580μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/packages/menu/src/Menu.php:211
      • 23. /platform/packages/menu/src/Menu.php:194
      • 24. /platform/packages/menu/src/Menu.php:162
    • 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
      650μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 27. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 28. /platform/packages/menu/src/Menu.php:211
      • 29. /platform/packages/menu/src/Menu.php:194
    • 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'
      460μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Menu\Models\MenuNode
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 27. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 33. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 34. /platform/packages/menu/src/Menu.php:211
    • 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'
      560μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Menu\Models\MenuNode
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 27. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 28. /platform/packages/menu/src/Menu.php:211
      • 29. /platform/packages/menu/src/Menu.php:194
    • select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9)
      510μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 22. /platform/packages/menu/src/Menu.php:211
      • 23. /platform/packages/menu/src/Menu.php:194
      • 24. /platform/packages/menu/src/Menu.php:162
    • select * from `pages` where `pages`.`id` in (8)
      510μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/packages/menu/src/Menu.php:254
      • 24. /platform/packages/menu/src/Menu.php:172
      • 26. view::theme.martfury::partials.header:90
      • 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (8) and `slugs`.`reference_type` = 'Botble\Page\Models\Page'
      460μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Page\Models\Page
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 29. /platform/packages/menu/src/Menu.php:254
      • 30. /platform/packages/menu/src/Menu.php:172
      • 32. view::theme.martfury::partials.header:90
    • select * from `ec_product_categories` where `ec_product_categories`.`id` in (15)
      380μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/packages/menu/src/Menu.php:254
      • 25. view::theme.martfury::partials.menu:13
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `widgets` where (`theme` = 'martfury')
      630μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. martfury
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 16. /platform/packages/widget/src/WidgetGroupCollection.php:92
      • 17. /platform/packages/widget/src/WidgetGroupCollection.php:79
      • 18. /platform/packages/widget/src/WidgetGroupCollection.php:65
      • 20. /platform/packages/widget/helpers/helpers.php:32
    • select * from `pages` where `pages`.`id` in (15, 13, 14)
      510μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 23. /platform/packages/menu/src/Menu.php:254
      • 25. view::theme.martfury::/../widgets/custom-menu/templates.frontend:3
      • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 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'
      500μs/platform/core/base/src/Models/BaseQueryBuilder.php:52shopping
      Metadata
      Bindings
      • 0. Botble\Page\Models\Page
      Backtrace
      • 15. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 21. /platform/core/base/src/Models/BaseQueryBuilder.php:52
      • 29. /platform/packages/menu/src/Menu.php:254
      • 31. view::theme.martfury::/../widgets/custom-menu/templates.frontend:3
      • 33. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    Botble\Widget\Models\Widget
    10
    Botble\Page\Models\Page
    4
    Botble\Menu\Models\MenuLocation
    1
    Botble\Menu\Models\MenuNode
    31
    Botble\Menu\Models\Menu
    9
    Botble\Ecommerce\Models\ProductCollection
    2
    Botble\Ads\Models\Ads
    9
    Botble\Ecommerce\Models\ProductAttributeSet
    1
    Botble\Ecommerce\Models\ProductVariationItem
    6
    Botble\Ecommerce\Models\ProductAttribute
    11
    Botble\Marketplace\Models\Store
    4
    Botble\Ecommerce\Models\ProductVariation
    21
    Botble\Ecommerce\Models\Product
    21
    Botble\Ecommerce\Models\Currency
    3
    Botble\Slug\Models\Slug
    18
    web
    null
    sanctum
    null
    customer
    null
      _token
      VQGsN8QqROgFKvv0vBC8GcallJ5J4LRoHO201s6y
      language
      en
      viewed_product
      array:1 [ 106 => 1747622070 ]
      cart
      array:2 [ "recently_viewed_updated_at" => Carbon\Carbon @1747622070 {#3434 #endOfTime: false ...
      _previous
      array:1 [ "url" => "https://yuonqdmmxh.drink2drink.com/products/dominos-e-gift-instant-voucher" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /products/dominos-e-gift-instant-voucher
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      []
      
      request_request
      []
      
      request_headers
      0 of 0
      array: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" ] ]
      request_server
      0 of 0
      array: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" ]
      request_cookies
      []
      
      response_headers
      0 of 0
      array: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=laxXSRF-TOKEN=eyJpdiI6Im1UWkJ4ellnUXF4UndFMUNzUUxwc2c9PSIsInZhbHVlIjoieGNlYU5oUUw5R1l0cmFsaFIzSzZYZUxFOGxwSmFvMXVabDNVNDVpTGJNVDg4L0h3TVlwc1hkZ2hqWVZ3ejJBMDdlZkMyY" 1 => "botble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMUkhrQVExbHRMdVVacnBTMG5OY1prdkhKdm5IRGF4RUlad1FTRnpYWG9SSDk1Rk9LaFJYaFdxQVZaNDRuR24iLCJtYWMiOiI3MjUwNGUyYjEwMWZmYjdiYzFiYjYzNjUyNDQ4MjIwYjE0OWFlOTE5YTI5NzA0ZmJiMDA3NWNjYzk2ZDIwMjI5IiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 04:34:31 GMT; Max-Age=7200; path=/; httponly; samesite=laxbotble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMU" 2 => "botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5XYmpualhmcWxqTTVLb0NpQWFyVkRPYWt6R3Y0WEl6SFdnckZSSlNWMnBTMW1XbjN5VWNSLzJMUjl5REFmNEZuUkJ6RGciLCJtYWMiOiJhNWIwOTc5Yjk3MjE0NWZjNWMyYjRhMjNiYmU0ZmQ2ZWQ0MmE5OGE5MjgwNmQ3YmQ3NjAwMjE1MGI0YTUyY2NlIiwidGFnIjoiIn0%3D; expires=Mon, 13 Jul 2026 02:34:30 GMT; Max-Age=36287999; path=/; httponly; samesite=laxbotble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5" 3 => "botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUjlxK3pFNU82bGV5eGd6cGEyWG1sdW9LQWZOOG5wK3hKTVZrdE95aTFkaEZaOVNmVnhZbUIydXFzUnlzTERQS0NNdVZYeTVWaUkrOVNmSUpCeVh2MENLZXMvbmdJRTZ2MHNWS0VhNnI3N3pFQW4wdmZUTXNDdWlGREk3QTVFV2tJQWlaRHdrd0VoRmRtL0luOVNVdVBqUkE4K0gyLzVKa2RuMXh5RXZwRmcvckNUckRzM2NlY2pDNTZuVzNOaXNoUEhCV1RhaEZsdmZFaUUrVHNzZVkrYlBxYktURXZ1aGtpTEh6QSt6T0h2Mm1kMUNSVVdOaE1pQ1p5bDFPbU0yVElOZVNjd3hhTmtySFJNOTJiaU9QTFN1ODJNVGZTdTlkYUVZSkhTVFdmRTZsU21ZNHNIeVVCc011b3ZTdXFqdFlpVWM2NlNoOTdWbkJ0V0lxQ256SnVjK3JCVTFZMDhmdVQ4Zk1GMWVUM1l2VklOVHhZMkFLb1hhd0FvOVBURDUwSmIyc0tzaGlqWmh3M2QyeGg3QmhyenpPNUJZUU9JTDR6ZTJEMzRsbTlvMnNWM1kvdnVaL1NYaVpxUFZDb08wMm1tcUdzWlUwN3ZmZ1VBc1N0L3BINHpvbnV2SXlsaTJuK29RVjY3WW1XditsMm5jNDdnSjJ1bzdRVGo0enQxQWpGVkluL1VRa0ZNIiwibWFjIjoiMjY4NjdmOTM2M2E3Y2JmYTJiOGZiNTA2NWRjZDllZjUwZTgyNTY5ODAwY2Y0YmIwYmJiN2I3NmUxYWNjZTk1ZSIsInRhZyI6IiJ9; expires=Mon, 13 Jul 2026 02:34:30 GMT; Max-Age=36287999; path=/; httponly; samesite=laxbotble_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=/; httponlybotble_session=eyJpdiI6IlRKNkpNVHE3NjUvSnlMdXhselNIQ3c9PSIsInZhbHVlIjoiQzRPb2JHWSs1WnozQlhHZHpnNURWeCtLOU9HWmMycVpsUS9qMHRpMjJSa2hyU0MvMlMvcnRqVHc2WGNmc04wZWxMU" 2 => "botble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5XYmpualhmcWxqTTVLb0NpQWFyVkRPYWt6R3Y0WEl6SFdnckZSSlNWMnBTMW1XbjN5VWNSLzJMUjl5REFmNEZuUkJ6RGciLCJtYWMiOiJhNWIwOTc5Yjk3MjE0NWZjNWMyYjRhMjNiYmU0ZmQ2ZWQ0MmE5OGE5MjgwNmQ3YmQ3NjAwMjE1MGI0YTUyY2NlIiwidGFnIjoiIn0%3D; expires=Mon, 13-Jul-2026 02:34:30 GMT; path=/; httponlybotble_footprints_cookie=eyJpdiI6Im5sU0lHdTVhRk91OU5BYmtZVkt2Q2c9PSIsInZhbHVlIjoiOUlMZ3lBMno0bFc2ZEdDUlBNWEdFajJtRldVK0ZUNlowSEMyNDBhVkpkcW9WRTQ3ODE1dWlUYkQzOE5" 3 => "botble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUjlxK3pFNU82bGV5eGd6cGEyWG1sdW9LQWZOOG5wK3hKTVZrdE95aTFkaEZaOVNmVnhZbUIydXFzUnlzTERQS0NNdVZYeTVWaUkrOVNmSUpCeVh2MENLZXMvbmdJRTZ2MHNWS0VhNnI3N3pFQW4wdmZUTXNDdWlGREk3QTVFV2tJQWlaRHdrd0VoRmRtL0luOVNVdVBqUkE4K0gyLzVKa2RuMXh5RXZwRmcvckNUckRzM2NlY2pDNTZuVzNOaXNoUEhCV1RhaEZsdmZFaUUrVHNzZVkrYlBxYktURXZ1aGtpTEh6QSt6T0h2Mm1kMUNSVVdOaE1pQ1p5bDFPbU0yVElOZVNjd3hhTmtySFJNOTJiaU9QTFN1ODJNVGZTdTlkYUVZSkhTVFdmRTZsU21ZNHNIeVVCc011b3ZTdXFqdFlpVWM2NlNoOTdWbkJ0V0lxQ256SnVjK3JCVTFZMDhmdVQ4Zk1GMWVUM1l2VklOVHhZMkFLb1hhd0FvOVBURDUwSmIyc0tzaGlqWmh3M2QyeGg3QmhyenpPNUJZUU9JTDR6ZTJEMzRsbTlvMnNWM1kvdnVaL1NYaVpxUFZDb08wMm1tcUdzWlUwN3ZmZ1VBc1N0L3BINHpvbnV2SXlsaTJuK29RVjY3WW1XditsMm5jNDdnSjJ1bzdRVGo0enQxQWpGVkluL1VRa0ZNIiwibWFjIjoiMjY4NjdmOTM2M2E3Y2JmYTJiOGZiNTA2NWRjZDllZjUwZTgyNTY5ODAwY2Y0YmIwYmJiN2I3NmUxYWNjZTk1ZSIsInRhZyI6IiJ9; expires=Mon, 13-Jul-2026 02:34:30 GMT; path=/; httponlybotble_footprints_cookie_data=eyJpdiI6Iit6TDZ2ZWxnS0tFVVAvYUVpcW8xY0E9PSIsInZhbHVlIjoiVVZFdElmbWRaVi9YYmIybWRVaWpxYTlSTkgyL05PRE1pb1NGN0FxdU1DbndPYnFhRHRzTkxLUj" ] ]
      session_attributes
      0 of 0
      array: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" => [] ]