Pure Organic Zone - Your Marketplace for 100% Natural & Organic Products. ||

Rosemary Leaves Water 200ml – Refreshing & Natural Hair & Skin Care Solution

(0) 0 Reviews 0 Orders 0 Wish listed
ml:
Quantity :
Total price :
  (Tax : )

Rosemary Leaves Water 200ml – Refreshing & Natural Hair & Skin Care Solution

"Nature’s Elixir for Radiant Hair and Skin."

Introduction

Discover the timeless magic of rosemary with our Rosemary Leaves Water, a 100% natural solution designed to elevate your hair and skincare routine. Carefully distilled, this refreshing spray unlocks the therapeutic properties of rosemary to rejuvenate your scalp, brighten your complexion, and leave you feeling refreshed. Whether you're tackling dry hair, irritated skin, or simply looking for a clean, natural beauty product, this versatile solution is the perfect addition to your daily regimen.


Key Features

  • 100% Natural Formula: Made with handpicked rosemary leaves, ensuring purity and effectiveness.
  • Multipurpose: Hydrates skin, soothes irritation, strengthens hair, and eliminates dryness.
  • Non-Greasy & Lightweight: Easily absorbed without leaving a sticky residue.
  • Refreshing Aroma: The earthy, herbal scent of rosemary uplifts your mood while calming your senses.
  • Calm & Nourish: Packed with antioxidants to combat free radicals and support a healthy, glowing you.
  • Safe for All Skin & Hair Types: Gentle enough for sensitive skin yet effective for all hair textures.

Benefits

For Hair

  • Promotes stronger, shinier hair by nourishing the scalp and reducing breakage.
  • Helps reduce flakiness and dryness, leaving your scalp refreshed and balanced.
  • Prolongs the life of hair color by revitalizing dull, treated locks.

For Skin

  • Naturally balances oily skin and reduces the appearance of pores.
  • Calms redness, irritation, and minor skin sensitivities.
  • Hydrates and refreshes for a radiant, glowing complexion.

For Wellness

  • The aromatic properties of rosemary provide a calming, spa-like experience that soothes your senses and promotes relaxation.

Usage Instructions

For Hair Care

  1. Spray directly onto your scalp and gently massage for a refreshed and hydrated feel.
  2. Use as a finishing spray to tame frizz and boost shine.

For Skincare

  1. Spray lightly onto your freshly cleansed face as a soothing toner.
  2. Use as a midday mist to hydrate and brighten your skin.

Pro Tip: Refrigerate for that extra refreshing boost on hot days!


Ingredients

Pure Distilled Rosemary Leaves Water: Extracted through natural distillation to retain maximum therapeutic properties.


Nutritional Information

  • Packed with natural antioxidants to fight free radicals.
  • Contains anti-inflammatory compounds to calm irritated skin and scalp.
  • Free from artificial additives, preservatives, or synthetic scents.

Additional Information

  • Net Volume: 200ml
  • Storage: Store in a cool, dry place, and keep out of direct sunlight. Refrigeration recommended for prolonged freshness.
  • Packaging: Eco-friendly, easy-to-use spray bottle to minimize waste.

Legal Disclaimer

For external use only. Avoid contact with eyes. Test on a small area of your skin before use. Discontinue use if irritation occurs. This product is not intended to diagnose, treat, cure, or prevent any disease.

Transform your daily beauty regimen with the natural goodness of rosemary. Add Rosemary Leaves Water to your routine today and experience the lasting benefits of nature’s wonder herb!

No review given yet!

Fast Delivery all across the country
Safe Payment
7 Days Return Policy
100% Authentic Products
More from the store
Indigo powder
₹170.00
Pathimukham / Sappan Wood
₹299.00
Wild Turmeric / Kasturi Powder 100 gm
₹170.00
Root Powder (Licorice)
₹170.00
Multani mitti powder
₹120.00
Total price :
  (Tax : )

Product Name

We’ll notify you once it’s available at your nearest store.

SettingsRequest history8.2.28PHP Version3.6sRequest Duration968MBMemory UsageGET product/{slug}
status
200 OK
full_url
https://orzanist.com/product/rosemary-leaves-water-200ml-refreshing-natural-hair-skin-care-solution-...
action_name
product
controller_action
App\Http\Controllers\Web\ProductDetailsController@index
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
status
200 OK
full_url
https://orzanist.com/product/rosemary-leaves-water-200ml-refreshing-natural-hair-skin-care-solution-...
action_name
product
controller_action
App\Http\Controllers\Web\ProductDetailsController@index
uri
GET product/{slug}
controller
App\Http\Controllers\Web\ProductDetailsController@index
namespace
App\Http\Controllers\Web
file
app/Http/Controllers/Web/ProductDetailsController.php:54-63
middleware
web, maintenance_mode, guestCheck
duration
3.62s
peak_memory
991MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
0 of 0
array:15 [ "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" ] "host" => array:1 [ 0 => "orzanist.com" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 31 Jul 2025 18:15:41 GMT" ] ]
session_attributes
0 of 0
array:9 [ "system_default_currency_info" => App\Models\Currency {#709 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2021-06-04 18:26:38" ] #changes: [] #casts: array:4 [ "id" => "integer" "status" => "boolean" "created_at" => "datetime" "updated_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:5 [ 0 => "name" 1 => "symbol" 2 => "code" 3 => "exchange_rate" 4 => "status" ] #guarded: array:1 [ 0 => "*" ] } "currency_code" => "INR" "currency_symbol" => "" "currency_exchange_rate" => "60" "usd" => 1 "_token" => "ZBcQCjBmuuYnhC6werlc6pQiKPN90l1fKF5jeh6o" "guest_id" => 1726065 "local" => "en" "direction" => "ltr" ]
  • warninglog[23:45:41] LOG.warning: Optional parameter $globalScope declared before required parameter $whereHas...
  • warninglog[23:45:41] LOG.warning: Optional parameter $globalScope declared before required parameter $whereHas...
  • Booting (1.79s)time
  • Application (1.82s)time
  • Routing (13.15ms)
  • Preparing Response (1.43s)
  • 1 x Application (50.43%)
    1.82s
    1 x Booting (49.57%)
    1.79s
    1 x Preparing Response (39.64%)
    1.43s
    1 x Routing (0.37%)
    13.15ms
    35 templates were rendered
    • web-views.products.detailsdetails.blade.php#?blade
    • web-views.partials._productSEOMetaContentData_productSEOMetaContentData.blade.php#?blade
    • web-views.partials._product-reviews_product-reviews.blade.php#?blade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
    • layouts.front-end.partials.modal._chatting_chatting.blade.php#?blade
    • layouts.front-end.appapp.blade.php#?blade
    • web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
    • layouts.front-end.partials._modals_modals.blade.php#?blade
    • layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
    • layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
    • layouts.front-end.partials._header_header.blade.php#?blade
    • layouts.front-end.partials._customer_auth_check_customer_auth_check.blade.php#?blade
    • layouts.front-end.partials._cart_cart.blade.php#?blade
    • layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
    • layouts.front-end.partials._footer_footer.blade.php#?blade
    • layouts.front-end.partials._footer-go-to-checkout-one_footer-go-to-checkout-one.blade.php#?blade
    • layouts.front-end.partials._footer-go-to-checkout-two_footer-go-to-checkout-two.blade.php#?blade
    • layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
    • layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade
    uri
    GET product/{slug}
    middleware
    web, maintenance_mode, guestCheck
    controller
    App\Http\Controllers\Web\ProductDetailsController@index
    namespace
    App\Http\Controllers\Web
    as
    product
    file
    app/Http/Controllers/Web/ProductDetailsController.php:54-63
    39 statements were executed (7 duplicates)Show only duplicates109ms
    • GuestMiddleware.php#24pureorg1.51msinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.220', '2025-07-31 23:45:41', '2025-07-31 23:45:41')
      Bindings
      • 0: 216.73.216.220
      • 1: 2025-07-31 23:45:41
      • 2: 2025-07-31 23:45:41
      Backtrace
      • middleware::guestCheck:24
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • middleware::maintenance_mode:30
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • ProductRepository.php#126pureorg10.37msselect * from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `slug` = 'rosemary-leaves-water-200ml-refreshing-natural-hair-skin-care-solution-rhvy71' limit 1
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: rosemary-leaves-water-200ml-refreshing-natural-hair-skin-care-solution-rhvy71
      Backtrace
      • app/Repositories/ProductRepository.php:126
      • app/Http/Controllers/Web/ProductDetailsController.php:67
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#126pureorg3.2msselect * from `translations` where `translations`.`translationable_id` in (1279) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Repositories/ProductRepository.php:126
      • app/Http/Controllers/Web/ProductDetailsController.php:67
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#126pureorg750μsselect * from `reviews` where `reviews`.`product_id` in (1279) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Repositories/ProductRepository.php:126
      • app/Http/Controllers/Web/ProductDetailsController.php:67
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductDetailsController.php#72pureorg10.42msselect * from `product_seos` where `product_seos`.`product_id` = 1279 limit 1
      Bindings
      • 0: 1279
      Backtrace
      • app/Http/Controllers/Web/ProductDetailsController.php:72
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ProductService.php#992pureorg1.03msselect * from `digital_product_authors` where `digital_product_authors`.`product_id` = 1279 and `digital_product_authors`.`product_id` is not null
      Bindings
      • 0: 1279
      Backtrace
      • app/Services/ProductService.php:992
      • app/Http/Controllers/Web/ProductDetailsController.php:73
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductService.php#1013pureorg860μsselect * from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` = 1279 and `digital_product_publishing_houses`.`product_id` is not null
      Bindings
      • 0: 1279
      Backtrace
      • app/Services/ProductService.php:1013
      • app/Http/Controllers/Web/ProductDetailsController.php:74
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • WishlistRepository.php#62pureorg1.64msselect count(*) as aggregate from `wishlists` where (`product_id` = 1279)
      Bindings
      • 0: 1279
      Backtrace
      • app/Repositories/WishlistRepository.php:62
      • app/Http/Controllers/Web/ProductDetailsController.php:77
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ReviewRepository.php#70pureorg790μsselect count(*) as aggregate from `reviews` where (`product_id` = 1279) and `status` = 1
      Bindings
      • 0: 1279
      • 1: 1
      Backtrace
      • app/Repositories/ReviewRepository.php:70
      • app/Http/Controllers/Web/ProductDetailsController.php:78
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg11.44msselect count(*) as aggregate from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'seller') and `user_id` = 38 and `id` not in (1279)
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: seller
      • 11: 38
      • 12: 1279
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:93
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg2.61msselect * from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'seller') and `user_id` = 38 and `id` not in (1279) order by `id` desc limit 5 offset 0
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: seller
      • 11: 38
      • 12: 1279
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:93
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg1.15msselect * from `translations` where `translations`.`translationable_id` in (1284, 1285, 1286, 1287, 1288) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:93
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg860μsselect * from `reviews` where `reviews`.`product_id` in (1284, 1285, 1286, 1287, 1288) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:93
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg2.16msselect count(*) as aggregate from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'seller') and `user_id` = 38
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: seller
      • 11: 38
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:103
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg2.25msselect `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1 and `status` = 1) as `reviews_count` from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'seller') and `user_id` = 38 limit 25 offset 0
      Bindings
      • 0: 1
      • 1: 1
      • 2: non_perishable
      • 3: both
      • 4: non_perishable
      • 5: 1
      • 6: 1
      • 7: 1
      • 8: approved
      • 9: admin
      • 10: 1
      • 11: physical
      • 12: seller
      • 13: 38
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:103
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg1.07msselect * from `translations` where `translations`.`translationable_id` in (1274, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:103
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg1.47msselect * from `reviews` where `reviews`.`product_id` in (1274, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:103
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • OrderDetailRepository.php#82pureorg490μsselect count(*) as aggregate from `order_details` where (`product_id` = 1279)
      Bindings
      • 0: 1279
      Backtrace
      • app/Repositories/OrderDetailRepository.php:82
      • app/Http/Controllers/Web/ProductDetailsController.php:120
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • WishlistRepository.php#62pureorg500μsselect count(*) as aggregate from `wishlists` where (`product_id` = 1279)
      Bindings
      • 0: 1279
      Backtrace
      • app/Repositories/WishlistRepository.php:62
      • app/Http/Controllers/Web/ProductDetailsController.php:121
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg14.58msselect count(*) as aggregate from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`category_id` = 24) and `id` not in (1279)
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 24
      • 11: 1279
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:122
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg6.39msselect * from `products` where (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`category_id` = 24) and `id` not in (1279) limit 12 offset 0
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 24
      • 11: 1279
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:122
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg1.41msselect * from `reviews` where `reviews`.`product_id` in (1278, 1281, 1282, 1283, 1284, 1285, 1288, 1466, 1469, 18505, 18506, 18507) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:122
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductRepository.php#347pureorg1.46msselect * from `translations` where `translations`.`translationable_id` in (1278, 1281, 1282, 1283, 1284, 1285, 1288, 1466, 1469, 18505, 18506, 18507) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Repositories/ProductRepository.php:347
      • app/Http/Controllers/Web/ProductDetailsController.php:122
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DealOfTheDayRepository.php#24pureorg1.55msselect * from `deal_of_the_days` where (`product_id` = 1279 and `status` = 1) limit 1
      Bindings
      • 0: 1279
      • 1: 1
      Backtrace
      • app/Repositories/DealOfTheDayRepository.php:24
      • app/Http/Controllers/Web/ProductDetailsController.php:130
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ProductDetailsController.php#132pureorg840μsselect * from `sellers` where `sellers`.`id` = 38 limit 1
      Bindings
      • 0: 38
      Backtrace
      • app/Http/Controllers/Web/ProductDetailsController.php:132
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ProductDetailsController.php#132pureorg560μsselect * from `shops` where `shops`.`seller_id` = 38 and `shops`.`seller_id` is not null limit 1
      Bindings
      • 0: 38
      Backtrace
      • app/Http/Controllers/Web/ProductDetailsController.php:132
      • app/Http/Controllers/Web/ProductDetailsController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ProductSeo.php#79pureorg18.94msselect * from `storages` where `storages`.`data_type` = 'App\\Models\\ProductSeo' and `storages`.`data_id` = 1138 and `storages`.`data_id` is not null
      Bindings
      • 0: App\Models\ProductSeo
      • 1: 1138
      Backtrace
      • app/Models/ProductSeo.php:79
      • view::web-views.partials._productSEOMetaContentData:30
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • app.blade.php#157pureorg580μsselect * from `delivery_zip_codes` where `zipcode` != ''
      Bindings
      • 0: 
      Backtrace
      • view::layouts.front-end.app:157
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • _header.blade.php#16pureorg560μsselect * from `blog_category`
      Backtrace
      • view::layouts.front-end.partials._header:16
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • _header.blade.php#17pureorg320μsselect * from `news_category`
      Backtrace
      • view::layouts.front-end.partials._header:17
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • _header.blade.php#18pureorg320μsselect * from `video_category`
      Backtrace
      • view::layouts.front-end.partials._header:18
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • product.php#24pureorg1.57msselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and `customer_id` = 1726065
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1726065
      Backtrace
      • app/Utils/product.php:24
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • cart-manager.php#100pureorg1.51msselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and (`customer_id` = 1726065 and `is_guest` = 1) group by `cart_group_id`
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1726065
      • 12: 1
      Backtrace
      • app/Utils/cart-manager.php:100
      • app/Utils/cart-manager.php:57
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/cart-manager.php:56
      • view::layouts.front-end.partials._cart:1
    • cart-manager.php#65pureorg480μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and 0 = 1
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      Backtrace
      • app/Utils/cart-manager.php:65
      • view::layouts.front-end.partials._cart:1
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • cart-manager.php#100pureorg760μsselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and (`customer_id` = 1726065 and `is_guest` = 1) group by `cart_group_id`
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1726065
      • 12: 1
      Backtrace
      • app/Utils/cart-manager.php:100
      • app/Utils/cart-manager.php:57
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/cart-manager.php:56
      • view::layouts.front-end.partials._cart:2
    • cart-manager.php#65pureorg700μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1
      Backtrace
      • app/Utils/cart-manager.php:65
      • view::layouts.front-end.partials._cart:2
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • product.php#24pureorg780μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and `customer_id` = 1726065
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1726065
      Backtrace
      • app/Utils/product.php:24
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • _footer.blade.php#122pureorg500μsselect * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-07-31' and date(`end_date`) >= '2025-07-31' limit 1
      Bindings
      • 0: 1
      • 1: flash_deal
      • 2: 2025-07-31
      • 3: 2025-07-31
      Backtrace
      • view::layouts.front-end.partials._footer:122
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • product.php#24pureorg930μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'non_perishable') or exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` = 'both') and `goods_type` = 'non_perishable') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and `status` = 1) and (`status` = 1 and `request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and `customer_id` = 1726065
      Bindings
      • 0: non_perishable
      • 1: both
      • 2: non_perishable
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 1
      • 11: 1726065
      Backtrace
      • app/Utils/product.php:24
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    Retrieved35Created1UpdatedDeleted
    App\Models\Product31Product.php#?
    App\Models\GuestUser1GuestUser.php#?
    App\Models\ProductSeo1ProductSeo.php#?
    App\Models\Seller1Seller.php#?
    App\Models\Shop1Shop.php#?
    App\Models\Storage1Storage.php#?
        system_default_currency_info
        App\Models\Currency {#709 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyTy...
        currency_code
        INR
        currency_symbol
        currency_exchange_rate
        60
        usd
        1
        _token
        ZBcQCjBmuuYnhC6werlc6pQiKPN90l1fKF5jeh6o
        guest_id
        1726065
        local
        en
        direction
        ltr
        ClearShow all
        Date ↕MethodURLData
        #12025-07-31 23:45:43GET/product/rosemary-leaves-water-200ml-refreshing-natural-hair-skin-care-solution-rhvy712353936