Olay Regenerist Retinol 24 Night Face Cream Moisturiser Fragrance Free 50g

(0 reviews)
Brand
Olay

Inhouse product


Price
Rs8,950.00 /pc
Quantity
(1 available)
Total Price
Share

Reviews & Ratings

0 out of 5.0
(0 reviews)
There have been no reviews for this product yet.
  • General Information

    Olay Regenerist Retinol24 Facial Moisturizer penetrates deep into skin’s surface layers. Our proprietary blend of Niacinamide Retinol complex hydrates skin for 24 hours for a bounty of benefits. Renews and resurfaces skin as you sleep so you can wake up to plumper, younger looking skin. 24hr hydration. You’ll see visible improvements in fine lines & wrinkles, smoothness, brightness, firming, dark spots, and pores. This fragrance free and dye free moisturizer absorbs quickly and goes deep into your skin’s surface layers so you wake up to plumper, youthful looking skin*. Use with Olay Regenerist Luminous serum at night and see the skin transformation in 28 days. Disclaimer: *with regular use Size: 50g KEY FEATURES • Wake up to plumper, younger-looking skin with Olay Retinol24 Face Cream! • Renews and resurfaces skin as you sleep, with 24-hour hydration • With bioavailable Retinoid powered by Olay's NiacinamideTM • Suitable for daily use, without the tradeoffs or drying the skin

Frequently Bought Products

Request history8.2.13PHP Version3.12sRequest Duration12MBMemory UsageGET product/{slug}Route
  • warninglog[20:39:02] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • Booting (72.55ms)time
  • Application (3.05s)time
  • 1 x Application (97.68%)
    3.05s
    1 x Booting (2.32%)
    72.55ms
    21 templates were rendered
    • frontend.product_detailsproduct_details.blade.php#?blade
    • frontend.product_details.image_galleryimage_gallery.blade.php#?blade
    • frontend.product_details.detailsdetails.blade.php#?blade
    • frontend.product_details.seller_infoseller_info.blade.php#?blade
    • frontend.product_details.top_selling_productstop_selling_products.blade.php#?blade
    • frontend.product_details.review_sectionreview_section.blade.php#?blade
    • frontend.product_details.reviewsreviews.blade.php#?blade
    • pagination::bootstrap-4bootstrap-4.blade.php#?blade
    • frontend.product_details.descriptiondescription.blade.php#?blade
    • frontend.product_details.frequently_bought_productsfrequently_bought_products.blade.php#?blade
    • frontend.product_details.product_queriesproduct_queries.blade.php#?blade
    • frontend.product_details.top_selling_productstop_selling_products.blade.php#?blade
    • modals.size_chart_show_modalsize_chart_show_modal.blade.php#?blade
    • frontend.layouts.appapp.blade.php#?blade
    • frontend.inc.navnav.blade.php#?blade
    • frontend.partials.cart.cartcart.blade.php#?blade
    • frontend.metro.partials.category_menucategory_menu.blade.php#?blade
    • frontend.inc.footerfooter.blade.php#?blade
    • frontend.partials.modalmodal.blade.php#?blade
    • frontend.partials.login_modallogin_modal.blade.php#?blade
    • frontend.partials.account_delete_modalaccount_delete_modal.blade.php#?blade
    uri
    GET product/{slug}
    middleware
    web
    controller
    App\Http\Controllers\HomeController@product
    namespace
    prefix
    where
    as
    product
    file
    app/Http/Controllers/HomeController.php:255-335
    59 statements were executed, 29 of which were duplicates, 30 unique. Show only duplicated145ms
    • select * from `products` where `auction_product` = 0 and `slug` = 'olay-regenerist-retinol-24-night-face-moisturiser-5vfxv' and `approved` = 1 limit 1
      2.03msshoppingcenterHomeController.php#261
      Bindings
      • 0: 0
      • 1: olay-regenerist-retinol-24-night-face-moisturiser-5vfxv
      • 2: 1
      Backtrace
      • 15. app/Http/Controllers/HomeController.php:261
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `product_translations` where `product_translations`.`product_id` in (431)
      1.1msshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `product_taxes` where `product_taxes`.`product_id` in (431)
      910μsshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `uploads` where `uploads`.`id` in (1585) and `uploads`.`deleted_at` is null
      340μsshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `reviews` where `status` = 1 and `reviews`.`product_id` in (431)
      610μsshoppingcenterHomeController.php#261
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `brands` where `brands`.`id` in (3)
      700μsshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `brand_translations` where `brand_translations`.`brand_id` in (3)
      1.51msshoppingcenterHomeController.php#261
      Backtrace
      • 25. app/Http/Controllers/HomeController.php:261
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `product_stocks` where `product_stocks`.`product_id` in (431)
      1.03msshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `users` where `users`.`id` in (9)
      380μsshoppingcenterHomeController.php#261
      Backtrace
      • 20. app/Http/Controllers/HomeController.php:261
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `shops` where `shops`.`user_id` in (9)
      450μsshoppingcenterHomeController.php#261
      Backtrace
      • 25. app/Http/Controllers/HomeController.php:261
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `product_queries` where `product_id` = 431 and `customer_id` is not null
      490μsshoppingcenterHomeController.php#276
      Bindings
      • 0: 431
      Backtrace
      • 15. app/Http/Controllers/HomeController.php:276
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `product_queries` where `product_id` = 431
      1.02msshoppingcenterHomeController.php#277
      Bindings
      • 0: 431
      Backtrace
      • 15. app/Http/Controllers/HomeController.php:277
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `reviews` where `reviews`.`product_id` = 431 and `reviews`.`product_id` is not null and `status` = 1
      280μsshoppingcenterHomeController.php#278
      Bindings
      • 0: 431
      • 1: 1
      Backtrace
      • 18. app/Http/Controllers/HomeController.php:278
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `uploads` where `uploads`.`id` = '1585' and `uploads`.`deleted_at` is null limit 1
      500μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1585
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1585' and `uploads`.`deleted_at` is null limit 1
      480μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1585
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1585' and `uploads`.`deleted_at` is null limit 1
      1.83msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1585
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1585' and `uploads`.`deleted_at` is null limit 1
      2.23msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1585
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1585' and `uploads`.`deleted_at` is null limit 1
      1.25msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1585
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `categories`.`id` = 11 limit 1
      2.09msshoppingcenterdetails.blade.php#137
      Bindings
      • 0: 11
      Backtrace
      • 20. view::frontend.product_details.details:137
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `category_translations` where `category_translations`.`category_id` in (11)
      620μsshoppingcenterdetails.blade.php#137
      Backtrace
      • 25. view::frontend.product_details.details:137
      • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 30. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `size_charts` where `size_charts`.`category_id` = 11 limit 1
      1.35msshoppingcenterdetails.blade.php#137
      Bindings
      • 0: 11
      Backtrace
      • 20. view::frontend.product_details.details:137
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `products` where `user_id` = 9 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin' order by `num_of_sale` desc limit 6
      5.01msshoppingcenterHelpers.php#1759
      Bindings
      • 0: 9
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 0
      • 5: admin
      Backtrace
      • 14. app/Http/Helpers.php:1759
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `product_translations` where `product_translations`.`product_id` in (56, 451, 1007, 1050, 1075, 1100)
      24.8msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `product_taxes` where `product_taxes`.`product_id` in (56, 451, 1007, 1050, 1075, 1100)
      9.32msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (145, 1574, 1944, 2021, 2049, 2065) and `uploads`.`deleted_at` is null
      4.32msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1574' and `uploads`.`deleted_at` is null limit 1
      420μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1574
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2065' and `uploads`.`deleted_at` is null limit 1
      480μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2065
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2021' and `uploads`.`deleted_at` is null limit 1
      6msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2021
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2049' and `uploads`.`deleted_at` is null limit 1
      600μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2049
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '145' and `uploads`.`deleted_at` is null limit 1
      470μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 145
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1944' and `uploads`.`deleted_at` is null limit 1
      3.66msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1944
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
      770μsshoppingcenterHelpers.php#1168
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select `frequently_bought_product_id` from `frequently_bought_products` where `frequently_bought_products`.`product_id` = 431 and `frequently_bought_products`.`product_id` is not null and `category_id` is null
      850μsshoppingcenterHelpers.php#1902
      Bindings
      • 0: 431
      Backtrace
      • 16. app/Http/Helpers.php:1902
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `products` where 0 = 1 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin'
      6.35msshoppingcenterHelpers.php#1903
      Bindings
      • 0: 1
      • 1: 1
      • 2: 0
      • 3: 0
      • 4: admin
      Backtrace
      • 14. app/Http/Helpers.php:1903
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `products` where `user_id` = 9 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin' order by `num_of_sale` desc limit 6
      5.09msshoppingcenterHelpers.php#1759
      Bindings
      • 0: 9
      • 1: 1
      • 2: 1
      • 3: 0
      • 4: 0
      • 5: admin
      Backtrace
      • 14. app/Http/Helpers.php:1759
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `product_translations` where `product_translations`.`product_id` in (56, 451, 1007, 1050, 1075, 1100)
      4.77msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `product_taxes` where `product_taxes`.`product_id` in (56, 451, 1007, 1050, 1075, 1100)
      6.77msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (145, 1574, 1944, 2021, 2049, 2065) and `uploads`.`deleted_at` is null
      3.35msshoppingcenterHelpers.php#1759
      Backtrace
      • 19. app/Http/Helpers.php:1759
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1574' and `uploads`.`deleted_at` is null limit 1
      2.14msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1574
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2065' and `uploads`.`deleted_at` is null limit 1
      910μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2065
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2021' and `uploads`.`deleted_at` is null limit 1
      600μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2021
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2049' and `uploads`.`deleted_at` is null limit 1
      630μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2049
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '145' and `uploads`.`deleted_at` is null limit 1
      470μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 145
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1944' and `uploads`.`deleted_at` is null limit 1
      540μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1944
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `languages` where `code` = 'en' limit 1
      560μsshoppingcenterHelpers.php#1661
      Bindings
      • 0: en
      Backtrace
      • 15. app/Http/Helpers.php:1661
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 21. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '50' and `uploads`.`deleted_at` is null limit 1
      1.49msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 50
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `addons`
      410μsshoppingcenterColorCodeConverter.php#35
      Backtrace
      • 17. vendor/aiz-packages/color-code-converter/src/Services/ColorCodeConverter.php:35
      • 18. app/Http/Helpers.php:1277
      • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
    • select * from `languages` where `code` = 'en' limit 1
      450μsshoppingcenterHelpers.php#1642
      Bindings
      • 0: en
      Backtrace
      • 15. app/Http/Helpers.php:1642
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 21. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
      380μsshoppingcenterHelpers.php#1168
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '2' and `uploads`.`deleted_at` is null limit 1
      10.87msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 2
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `categories` where `level` = 0 order by `order_level` desc
      570μsshoppingcenterHelpers.php#1990
      Bindings
      • 0: 0
      Backtrace
      • 14. app/Http/Helpers.php:1990
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `category_translations` where `category_translations`.`category_id` in (1, 3, 10, 11, 12, 15, 16, 35, 36, 37, 38)
      480μsshoppingcenterHelpers.php#1990
      Backtrace
      • 19. app/Http/Helpers.php:1990
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (117, 118, 119, 120, 121, 122, 123, 176) and `uploads`.`deleted_at` is null
      5.31msshoppingcenterHelpers.php#1990
      Backtrace
      • 19. app/Http/Helpers.php:1990
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` in (56, 58, 89, 90, 91, 92, 93, 175) and `uploads`.`deleted_at` is null
      460μsshoppingcenterHelpers.php#1990
      Backtrace
      • 19. app/Http/Helpers.php:1990
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '51' and `uploads`.`deleted_at` is null limit 1
      500μsshoppingcenterHelpers.php#1168
      Bindings
      • 0: 51
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `uploads` where `uploads`.`id` = '1699' and `uploads`.`deleted_at` is null limit 1
      10.09msshoppingcenterHelpers.php#1168
      Bindings
      • 0: 1699
      Backtrace
      • 19. app/Http/Helpers.php:1168
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `custom_alerts` where `status` = 1 order by `id` asc
      1.27msshoppingcenterapp.blade.php#256
      Bindings
      • 0: 1
      Backtrace
      • 14. view::frontend.layouts.app:256
      • 16. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `dynamic_popups` where `status` = 1 order by `id` asc
      1.26msshoppingcenterapp.blade.php#297
      Bindings
      • 0: 1
      Backtrace
      • 14. view::frontend.layouts.app:297
      • 16. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 17. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 19. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `countries` where `status` = '1'
      1.01msshoppingcenterHelpers.php#123
      Bindings
      • 0: 1
      Backtrace
      • 14. app/Http/Helpers.php:123
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    App\Models\Upload
    50Upload.php#?
    App\Models\ProductTax
    26ProductTax.php#?
    App\Models\Product
    13Product.php#?
    App\Models\ProductTranslation
    13ProductTranslation.php#?
    App\Models\Category
    12Category.php#?
    App\Models\CategoryTranslation
    12CategoryTranslation.php#?
    App\Models\Language
    2Language.php#?
    App\Models\Brand
    1Brand.php#?
    App\Models\BrandTranslation
    1BrandTranslation.php#?
    App\Models\ProductStock
    1ProductStock.php#?
    App\Models\User
    1User.php#?
    App\Models\Addon
    1Addon.php#?
    App\Models\Country
    1Country.php#?
        _token
        wPFnuUscBJUuhW7nFAVlQiiPi8kToTTFywQlmgEJ
        locale
        en
        link
        https://shoppingcentre.lk/product/olay-regenerist-retinol-24-night-face-moisturiser-5vfxv
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /product/olay-regenerist-retinol-24-night-face-moisturiser-5vfxv
        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:15 [ "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" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "shoppingcentre.lk" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 07 May 2025 20:39:01 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=wPFnuUscBJUuhW7nFAVlQiiPi8kToTTFywQlmgEJ; expires=Wed, 07 May 2025 22:39:04 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=wPFnuUscBJUuhW7nFAVlQiiPi8kToTTFywQlmgEJ; expires=Wed, 07-May-2025 22:39:04 GMT; path=/" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "wPFnuUscBJUuhW7nFAVlQiiPi8kToTTFywQlmgEJ" "locale" => "en" "link" => "https://shoppingcentre.lk/product/olay-regenerist-retinol-24-night-face-moisturiser-5vfxv" "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-07 20:39:04GET/product/olay-regenerist-retinol-24-night-face-moisturiser-5vfxv12159134