Mace Powder (મેસ પાવડર)
(0) 0 Reviews 0 Orders 0 Wish listed
Price : ₹85 (26 % Off)MRP : ₹115
Size :
(₹2.3 / 1 Gm)
(₹2.3 / 1 Gm)
Quantity :
Total price :
  (Tax included : )

Mace Powder

No review given yet!

Fast Delivery all across the country
Safe Payment
100% Authentic Products
126 Reviews
25 Products
More from the store
dfdf
₹50
5% Off
Coffee powder123
₹100 ₹95
Test Digital payment
₹1
Garam Penner masala
₹100
29% Off
Peepramul Powder (પીપરમુલ પાવડર)
₹49 ₹35
Total price :
  (Tax : )
Top
8.2.19PHP Version900msRequest Duration35MBMemory UsageGET product/{slug}Route
  • warninglog[02:59:19] LOG.warning: Optional parameter $globalScope declared before required parameter $whereHas...
  • warninglog[02:59:19] LOG.warning: Optional parameter $globalScope declared before required parameter $whereHas...
  • Booting (203ms)time
  • Application (697ms)time
  • 1 x Application (77.44%)
    697ms
    1 x Booting (22.56%)
    203ms
    27 templates were rendered
    • web-views.products.detailsdetails.blade.phpblade
    • web-views.partials._product-reviews_product-reviews.blade.phpblade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.phpblade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.phpblade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.phpblade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.phpblade
    • web-views.partials._seller-products-product-details_seller-products-product-details.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • web-views.partials._inline-single-product_inline-single-product.blade.phpblade
    • layouts.front-end.partials.modal._chatting_chatting.blade.phpblade
    • layouts.front-end.appapp.blade.phpblade
    • layouts.front-end.partials._modals_modals.blade.phpblade
    • layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.phpblade
    • layouts.front-end.partials._header_header.blade.phpblade
    • layouts.front-end.partials._cart_cart.blade.phpblade
    • layouts.front-end.partials._footer_footer.blade.phpblade
    • layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.phpblade
    uri
    GET product/{slug}
    middleware
    web
    controller
    App\Http\Controllers\Web\ProductDetailsController@index
    namespace
    App\Http\Controllers\Web
    prefix
    where
    as
    product
    file
    app/Http/Controllers/Web/ProductDetailsController.php:49-59
    74 statements were executed, 14 of which were duplicates, 60 unique. Show only duplicated82.35ms
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      610μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 25. app/Repositories/ProductRepository.php:76
      • 26. app/Http/Controllers/Web/ProductDetailsController.php:63
      • 27. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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` = 'mace-powder-9TJOZJ') limit 1
      1.86msshankar_betaProductRepository.php#76
      Bindings
      • 0: 1
      • 1: admin
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: mace-powder-9TJOZJ
      Backtrace
      • 16. app/Repositories/ProductRepository.php:76
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:63
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (219) and `delivery_man_id` is null and `status` = 1
      1.64msshankar_betaProductRepository.php#76
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Repositories/ProductRepository.php:76
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:63
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `sellers` where `sellers`.`id` in (1)
      700μsshankar_betaProductRepository.php#76
      Backtrace
      • 21. app/Repositories/ProductRepository.php:76
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:63
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (219) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      270μsshankar_betaProductRepository.php#76
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Repositories/ProductRepository.php:76
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:63
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `wishlists` where (`product_id` = 219)
      400μsshankar_betaWishlistRepository.php#62
      Bindings
      • 0: 219
      Backtrace
      • 16. app/Repositories/WishlistRepository.php:62
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:66
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `reviews` where (`product_id` = 219) and `status` = 1
      740μsshankar_betaReviewRepository.php#70
      Bindings
      • 0: 219
      • 1: 1
      Backtrace
      • 16. app/Repositories/ReviewRepository.php:70
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:67
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      560μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 23. app/Repositories/ProductRepository.php:274
      • 24. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • 25. app/Repositories/ProductRepository.php:273
      • 26. app/Http/Controllers/Web/ProductDetailsController.php:75
    • select count(*) as aggregate from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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` = 'admin') and `user_id` = 1 and `id` not in (219)
      2.1msshankar_betaProductRepository.php#309
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: admin
      • 10: 1
      • 11: 219
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:75
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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` = 'admin') and `user_id` = 1 and `id` not in (219) order by `id` desc limit 5 offset 0
      1.47msshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      • 1: admin
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: admin
      • 11: 1
      • 12: 219
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:75
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (260, 263, 265, 266, 267) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      790μsshankar_betaProductRepository.php#309
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:75
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (260, 263, 265, 266, 267) and `delivery_man_id` is null and `status` = 1
      620μsshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:75
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      280μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 23. app/Repositories/ProductRepository.php:274
      • 24. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • 25. app/Repositories/ProductRepository.php:273
      • 26. app/Http/Controllers/Web/ProductDetailsController.php:91
    • select count(*) as aggregate from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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` = 'admin') and `user_id` = 1
      1.34msshankar_betaProductRepository.php#309
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: admin
      • 10: 1
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:91
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1 and `status` = 1) as `reviews_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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` = 'admin') and `user_id` = 1 limit 25 offset 0
      7.97msshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: admin
      • 4: 1
      • 5: 1
      • 6: 1
      • 7: 1
      • 8: approved
      • 9: admin
      • 10: 1
      • 11: physical
      • 12: admin
      • 13: 1
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:91
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.64msshankar_betaProductRepository.php#309
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:91
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29) and `delivery_man_id` is null and `status` = 1
      3.33msshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:91
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `order_details` where (`product_id` = 219)
      1.34msshankar_betaOrderDetailRepository.php#59
      Bindings
      • 0: 219
      Backtrace
      • 16. app/Repositories/OrderDetailRepository.php:59
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:102
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from `wishlists` where (`product_id` = 219)
      240μsshankar_betaWishlistRepository.php#62
      Bindings
      • 0: 219
      Backtrace
      • 16. app/Repositories/WishlistRepository.php:62
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:103
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      580μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 23. app/Repositories/ProductRepository.php:274
      • 24. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • 25. app/Repositories/ProductRepository.php:273
      • 26. app/Http/Controllers/Web/ProductDetailsController.php:104
    • select count(*) as aggregate from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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 `id` not in (219)
      1.82msshankar_betaProductRepository.php#309
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: 219
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:104
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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 `id` not in (219) limit 12 offset 0
      2.44msshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      • 1: admin
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: 1
      • 6: approved
      • 7: admin
      • 8: 1
      • 9: physical
      • 10: 219
      Backtrace
      • 16. app/Repositories/ProductRepository.php:309
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:104
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      1.01msshankar_betaProductRepository.php#309
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:104
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14) and `delivery_man_id` is null and `status` = 1
      1.31msshankar_betaProductRepository.php#309
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Repositories/ProductRepository.php:309
      • 22. app/Http/Controllers/Web/ProductDetailsController.php:104
      • 23. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `deal_of_the_days` where (`product_id` = 219 and `status` = 1) limit 1
      660μsshankar_betaDealOfTheDayRepository.php#24
      Bindings
      • 0: 219
      • 1: 1
      Backtrace
      • 16. app/Repositories/DealOfTheDayRepository.php:24
      • 17. app/Http/Controllers/Web/ProductDetailsController.php:112
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      700μsshankar_betasettings.php#15
      Bindings
      • 0: temporary_close
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 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
    • select * from `business_settings` where (`type` = 'vacation_add') limit 1
      650μsshankar_betasettings.php#15
      Bindings
      • 0: vacation_add
      Backtrace
      • 16. app/Utils/settings.php:15
      • 18. app/Http/Controllers/Web/ProductDetailsController.php:54
      • 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
    • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
      820μsshankar_betasettings.php#15
      Bindings
      • 0: currency_symbol_position
      Backtrace
      • 16. app/Utils/settings.php:15
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'company_reliability') limit 1
      430μsshankar_betasettings.php#15
      Bindings
      • 0: company_reliability
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
      1.55msshankar_betasettings.php#15
      Bindings
      • 0: google_tag_manager_id
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
      790μsshankar_betasettings.php#15
      Bindings
      • 0: pixel_analytics
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `shipping_addresses` where `id` is null limit 1
      1.23msshankar_beta_modals.blade.php#34
      Backtrace
      • 16. view::layouts.front-end.partials._modals:34
      • 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 * from `countries`
      1.28msshankar_beta_modals.blade.php#102
      Backtrace
      • 16. view::layouts.front-end.partials._modals:102
      • 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 * from `states` where `country_id` = 101 order by `name` asc
      1.64msshankar_beta_modals.blade.php#115
      Bindings
      • 0: 101
      Backtrace
      • 15. view::layouts.front-end.partials._modals:115
      • 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 * from `cities` where `state_id` is null order by `name` asc
      2.84msshankar_beta_modals.blade.php#132
      Backtrace
      • 15. view::layouts.front-end.partials._modals:132
      • 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 * from `business_settings` where (`type` = 'map_api_key') limit 1
      910μsshankar_betasettings.php#15
      Bindings
      • 0: map_api_key
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'announcement') limit 1
      780μsshankar_betasettings.php#15
      Bindings
      • 0: announcement
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select `cart_group_id` from `carts` where (`customer_id` = 0 and `is_guest` = 1) group by `cart_group_id`
      1.32msshankar_betacart-manager.php#87
      Bindings
      • 0: 0
      • 1: 1
      Backtrace
      • 14. app/Utils/cart-manager.php:87
      • 15. app/Utils/cart-manager.php:47
      • 16. view::layouts.front-end.partials._cart:5
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `carts` where exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')
      800μsshankar_betacart-manager.php#47
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: guest-6MjsR-1716359425
      Backtrace
      • 15. app/Utils/cart-manager.php:47
      • 16. view::layouts.front-end.partials._cart:5
      • 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
    • select `cart_group_id` from `carts` where (`customer_id` = 0 and `is_guest` = 1) group by `cart_group_id`
      1.12msshankar_betacart-manager.php#87
      Bindings
      • 0: 0
      • 1: 1
      Backtrace
      • 14. app/Utils/cart-manager.php:87
      • 15. app/Utils/cart-manager.php:47
      • 16. view::layouts.front-end.partials._cart:14
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `carts` where exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and `status` = 1) and `cart_group_id` in ('guest-6MjsR-1716359425')
      540μsshankar_betacart-manager.php#47
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: guest-6MjsR-1716359425
      Backtrace
      • 15. app/Utils/cart-manager.php:47
      • 16. view::layouts.front-end.partials._cart:14
      • 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
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 15 limit 1
      910μsshankar_beta_cart.blade.php#73
      Bindings
      • 0: 1
      • 1: 15
      Backtrace
      • 20. view::layouts.front-end.partials._cart:73
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      640μsshankar_beta_cart.blade.php#73
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 25. view::layouts.front-end.partials._cart:73
      • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `reviews` where `reviews`.`product_id` in (15) and `delivery_man_id` is null and `status` = 1
      720μsshankar_beta_cart.blade.php#73
      Bindings
      • 0: 1
      Backtrace
      • 25. view::layouts.front-end.partials._cart:73
      • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `products`.`id` = 1 limit 1
      1.37msshankar_beta_cart.blade.php#73
      Bindings
      • 0: 1
      • 1: 1
      Backtrace
      • 20. view::layouts.front-end.partials._cart:73
      • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
      320μsshankar_beta_cart.blade.php#73
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • 25. view::layouts.front-end.partials._cart:73
      • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` is null and `status` = 1
      590μsshankar_beta_cart.blade.php#73
      Bindings
      • 0: 1
      Backtrace
      • 25. view::layouts.front-end.partials._cart:73
      • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 28. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 30. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'free_delivery_status') limit 1
      620μsshankar_betahelpers.php#167
      Bindings
      • 0: free_delivery_status
      Backtrace
      • 16. app/Utils/helpers.php:167
      • 17. app/Utils/order-manager.php:1206
      • 18. view::layouts.front-end.partials._cart:162
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `business_settings` where (`type` = 'free_delivery_responsibility') limit 1
      300μsshankar_betahelpers.php#167
      Bindings
      • 0: free_delivery_responsibility
      Backtrace
      • 16. app/Utils/helpers.php:167
      • 17. app/Utils/order-manager.php:1207
      • 18. view::layouts.front-end.partials._cart:162
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `business_settings` where (`type` = 'free_delivery_over_amount') limit 1
      240μsshankar_betahelpers.php#167
      Bindings
      • 0: free_delivery_over_amount
      Backtrace
      • 16. app/Utils/helpers.php:167
      • 17. app/Utils/order-manager.php:1208
      • 18. view::layouts.front-end.partials._cart:162
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `business_settings` where (`type` = 'free_delivery_over_amount_seller') limit 1
      370μsshankar_betahelpers.php#167
      Bindings
      • 0: free_delivery_over_amount_seller
      Backtrace
      • 16. app/Utils/helpers.php:167
      • 17. app/Utils/order-manager.php:1209
      • 18. view::layouts.front-end.partials._cart:162
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as aggregate from `categories` where `position` = 0 and `status` = 1
      1.6msshankar_beta_header.blade.php#257
      Bindings
      • 0: 0
      • 1: 1
      Backtrace
      • 16. view::layouts.front-end.partials._header:257
      • 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 * from `categories` where `position` = 0 and `status` = 1 order by `priority` asc limit 11 offset 0
      1.51msshankar_beta_header.blade.php#257
      Bindings
      • 0: 0
      • 1: 1
      Backtrace
      • 16. view::layouts.front-end.partials._header:257
      • 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 * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8) order by `priority` asc
      590μsshankar_beta_header.blade.php#257
      Backtrace
      • 21. view::layouts.front-end.partials._header:257
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `categories` where `categories`.`parent_id` in (15) order by `priority` asc
      300μsshankar_beta_header.blade.php#257
      Backtrace
      • 26. view::layouts.front-end.partials._header:257
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 31. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      330μsshankar_beta_header.blade.php#257
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 31. view::layouts.front-end.partials._header:257
      • 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 34. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 36. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      760μsshankar_beta_header.blade.php#257
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 26. view::layouts.front-end.partials._header:257
      • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 31. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
      270μsshankar_beta_header.blade.php#257
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • 21. view::layouts.front-end.partials._header:257
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      1.13msshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 26. app/Models/Brand.php:42
      • 32. app/Utils/brand-manager.php:33
      • 33. view::layouts.front-end.partials._header:344
      • 35. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      360μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 26. app/Models/Brand.php:42
      • 34. app/Utils/brand-manager.php:33
      • 35. view::layouts.front-end.partials._header:344
      • 37. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
    • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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')) as `brand_products_count` from `brands` where `status` = 1 and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1) and ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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')) order by `created_at` desc
      4.1msshankar_betabrand-manager.php#35
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: 1
      • 10: 1
      • 11: 1
      • 12: admin
      • 13: 1
      • 14: 1
      • 15: 1
      • 16: 1
      • 17: approved
      • 18: admin
      • 19: 1
      • 20: physical
      Backtrace
      • 15. app/Utils/brand-manager.php:35
      • 16. view::layouts.front-end.partials._header:344
      • 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
    • select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
      1.39msshankar_betabrand-manager.php#35
      Bindings
      • 0: App\Models\Brand
      • 1: en
      Backtrace
      • 20. app/Utils/brand-manager.php:35
      • 21. view::layouts.front-end.partials._header:344
      • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select * from `business_settings` where (`type` = 'business_mode') limit 1
      390μsshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 23. view::layouts.front-end.partials._header:371
      • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select count(*) as aggregate from `products` where ((`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) or (`brand_id` is null and `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 `discount` != 0
      1.44msshankar_beta_header.blade.php#371
      Bindings
      • 0: admin
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: physical
      • 9: 0
      Backtrace
      • 16. view::layouts.front-end.partials._header:371
      • 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 * from `business_settings` where (`type` = 'business_mode') limit 1
      2.04msshankar_betasettings.php#15
      Bindings
      • 0: business_mode
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'loader_gif') limit 1
      1.07msshankar_betasettings.php#15
      Bindings
      • 0: loader_gif
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `flash_deals` where exists (select * from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id` and exists (select *, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as `reviews_count` from `products` where `flash_deal_products`.`product_id` = `products`.`id` and exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `status` = 1))) and (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-06-02' and date(`end_date`) >= '2025-06-02' limit 1
      540μsshankar_beta_footer.blade.php#105
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: flash_deal
      • 4: 2025-06-02
      • 5: 2025-06-02
      Backtrace
      • 16. view::layouts.front-end.partials._footer:105
      • 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 * from `business_settings` where (`type` = 'refund-policy') limit 1
      380μsshankar_betasettings.php#15
      Bindings
      • 0: refund-policy
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'return-policy') limit 1
      670μsshankar_betasettings.php#15
      Bindings
      • 0: return-policy
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
      650μsshankar_betasettings.php#15
      Bindings
      • 0: cancellation-policy
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      350μsshankar_betasettings.php#15
      Bindings
      • 0: company_phone
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'company_email') limit 1
      970μsshankar_betasettings.php#15
      Bindings
      • 0: company_email
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      1.87msshankar_betasettings.php#15
      Bindings
      • 0: shop_address
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    • select * from `business_settings` where (`type` = 'whatsapp') limit 1
      440μsshankar_betasettings.php#15
      Bindings
      • 0: whatsapp
      Backtrace
      • 16. app/Utils/settings.php:15
      • 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
      • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
    App\Models\Review
    200
    App\Models\Product
    45
    App\Models\State
    36
    App\Models\BusinessSetting
    26
    App\Models\Category
    10
    App\Models\Cart
    4
    App\Models\Country
    1
    App\Models\Brand
    1
        decimal_point_settings
        0
        product_brand
        1
        digital_product
        0
        currency_model
        single_currency
        language
        array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
        local
        en
        direction
        ltr
        system_default_currency
        3
        system_default_currency_info
        App\Models\Currency {#3678 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        INR
        currency_symbol
        currency_exchange_rate
        60
        _token
        fRL2FvchwgbDuzFpS9IkIvxBYI5Cp8z6XYGQmV7p
        currency_symbol_position
        left
        company_email
        info@shankarmasala.com
        _previous
        array:1 [ "url" => "https://shankar-beta.mydemoapp.us/product/mace-powder-9TJOZJ" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /product/mace-powder-9TJOZJ
        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 => "shankar-beta.mydemoapp.us" ] ]
        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 => "Sun, 01 Jun 2025 21:29:19 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik1BYmdHNUhWeTFOQlV4cHNDN3g3bnc9PSIsInZhbHVlIjoiZ2JWcTFyb3Jvbk1NSGtLczRIM0pPZHNFQlpSK1M0ZUhYOEZVbEdzK0d5VjdRMUppaUNZQ2RSYkRPYnJBUlN4RW14aDRsaFpDUUZrMHZwY2lXYnZrd1BQTklLYmhOQU1peTRwcXJGM0lydTBaN0lVUGNDcmVmMXl3ZHdmbENJT04iLCJtYWMiOiJiNjIwYTUwNGYwYjcyYjU3OTc1NjI2ZDkzZjU0YjkzOTY5Mzk4MzkyMDA5ZDY3Mzk3M2ZhNzM3NzhkMDI1NDliIiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 23:29:19 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Ik1BYmdHNUhWeTFOQlV4cHNDN3g3bnc9PSIsInZhbHVlIjoiZ2JWcTFyb3Jvbk1NSGtLczRIM0pPZHNFQlpSK1M0ZUhYOEZVbEdzK0d5VjdRMUppaUNZQ2RSYkRPYnJBUlN4RW14aDRsa" 1 => "laravel_session=eyJpdiI6IjBrdmRaRWZJQmV0VDNpREcxRUFtV2c9PSIsInZhbHVlIjoiTURLS0ZoMEozRkIyLzJCRDd5akRZSjJ2bjViQmYwVG5lVFFVcjJmUFhEWEVFMWVZckE5Y3FzUUM3QTlTZE56MG0ySngyS3pHWVV0Tm5XeXAxYVhiS2pKNmtaY2RHS01KS3lZOTZKMXNUVVpYVGl4MXlZSk14NnJTYkNpei9kRWEiLCJtYWMiOiIxMzg0OWM2NGVkMjk1NzQ0Yzg2N2ZlMTMxZTEzMGNhMzdhY2Q2OWIyYTljNmQwNWNlZGQ3ODkzOTE0MjY3ZTE2IiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 23:29:19 GMT; Max-Age=7200; path=/; httponlylaravel_session=eyJpdiI6IjBrdmRaRWZJQmV0VDNpREcxRUFtV2c9PSIsInZhbHVlIjoiTURLS0ZoMEozRkIyLzJCRDd5akRZSjJ2bjViQmYwVG5lVFFVcjJmUFhEWEVFMWVZckE5Y3FzUUM3QTlTZE56MG0y" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik1BYmdHNUhWeTFOQlV4cHNDN3g3bnc9PSIsInZhbHVlIjoiZ2JWcTFyb3Jvbk1NSGtLczRIM0pPZHNFQlpSK1M0ZUhYOEZVbEdzK0d5VjdRMUppaUNZQ2RSYkRPYnJBUlN4RW14aDRsaFpDUUZrMHZwY2lXYnZrd1BQTklLYmhOQU1peTRwcXJGM0lydTBaN0lVUGNDcmVmMXl3ZHdmbENJT04iLCJtYWMiOiJiNjIwYTUwNGYwYjcyYjU3OTc1NjI2ZDkzZjU0YjkzOTY5Mzk4MzkyMDA5ZDY3Mzk3M2ZhNzM3NzhkMDI1NDliIiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 23:29:19 GMT; path=/XSRF-TOKEN=eyJpdiI6Ik1BYmdHNUhWeTFOQlV4cHNDN3g3bnc9PSIsInZhbHVlIjoiZ2JWcTFyb3Jvbk1NSGtLczRIM0pPZHNFQlpSK1M0ZUhYOEZVbEdzK0d5VjdRMUppaUNZQ2RSYkRPYnJBUlN4RW14aDRsa" 1 => "laravel_session=eyJpdiI6IjBrdmRaRWZJQmV0VDNpREcxRUFtV2c9PSIsInZhbHVlIjoiTURLS0ZoMEozRkIyLzJCRDd5akRZSjJ2bjViQmYwVG5lVFFVcjJmUFhEWEVFMWVZckE5Y3FzUUM3QTlTZE56MG0ySngyS3pHWVV0Tm5XeXAxYVhiS2pKNmtaY2RHS01KS3lZOTZKMXNUVVpYVGl4MXlZSk14NnJTYkNpei9kRWEiLCJtYWMiOiIxMzg0OWM2NGVkMjk1NzQ0Yzg2N2ZlMTMxZTEzMGNhMzdhY2Q2OWIyYTljNmQwNWNlZGQ3ODkzOTE0MjY3ZTE2IiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 23:29:19 GMT; path=/; httponlylaravel_session=eyJpdiI6IjBrdmRaRWZJQmV0VDNpREcxRUFtV2c9PSIsInZhbHVlIjoiTURLS0ZoMEozRkIyLzJCRDd5akRZSjJ2bjViQmYwVG5lVFFVcjJmUFhEWEVFMWVZckE5Y3FzUUM3QTlTZE56MG0y" ] ]
        session_attributes
        0 of 0
        array:18 [ "decimal_point_settings" => 0 "product_brand" => 1 "digital_product" => 0 "currency_model" => "single_currency" "language" => array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] 1 => array:6 [ "id" => 2 "name" => "Hindi" "direction" => "ltr" "code" => "in" "status" => 1 "default" => false ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#3678 #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 22:53:04" "updated_at" => "2021-06-04 23:56:38" ] #original: array:8 [ "id" => 3 "name" => "Indian Rupi" "symbol" => "" "code" => "INR" "exchange_rate" => "60" "status" => 1 "created_at" => "2020-10-15 22:53:04" "updated_at" => "2021-06-04 23:56: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" "_token" => "fRL2FvchwgbDuzFpS9IkIvxBYI5Cp8z6XYGQmV7p" "currency_symbol_position" => "left" "company_email" => "info@shankarmasala.com" "_previous" => array:1 [ "url" => "https://shankar-beta.mydemoapp.us/product/mace-powder-9TJOZJ" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]