Discounted Products
333 Items found
-10.00₹
100.00₹
90.00₹
-7.00₹
12.00₹
5.00₹
-5.00₹
40.00₹
35.00₹
-10.00₹
70.00₹
60.00₹
-10.00₹
75.00₹
65.00₹
-7.00₹
12.00₹
5.00₹
-25.00₹
135.00₹
110.00₹
-10.00₹
70.00₹
60.00₹
-15.00₹
120.00₹
105.00₹
-5.00₹
-5.00₹
30.00₹
25.00₹
-5.00₹
30.00₹
25.00₹
-5.00₹
-2.00₹
7.00₹
5.00₹
-10.00₹
-2.00₹
7.00₹
5.00₹
-5.00₹
40.00₹
35.00₹
-10.00₹
75.00₹
65.00₹
-20.00₹
-5.00₹
Top
8.2.27PHP Version175msRequest Duration7MBMemory UsageGET productsRoute
    • Booting (74.14ms)time
    • Application (101ms)time
    • 1 x Application (57.74%)
      101ms
      1 x Booting (42.26%)
      74.14ms
      30 templates were rendered
      • web-views.products.viewview.blade.phpblade
      • web-views.products._ajax-products_ajax-products.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • web-views.partials._filter-single-product_filter-single-product.blade.phpblade
      • pagination::bootstrap-4bootstrap-4.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 products
      middleware
      web, maintenance_mode, guestCheck
      controller
      App\Http\Controllers\Web\ProductListController@products
      namespace
      App\Http\Controllers\Web
      prefix
      where
      as
      products
      file
      app/Http/Controllers/Web/ProductListController.php:24-34
      37 statements were executed, 10 of which were duplicated, 27 unique. Show only duplicated26.69ms
      • select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
        220μshelpers.php#167pust_db
        Metadata
        Bindings
        • 0. maintenance_mode
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. middleware::maintenance_mode:20
        • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 19. middleware::api_lang:22
        • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • insert into `guest_users` (`ip_address`, `created_at`) values ('3.15.145.105', '2025-04-14 21:03:12')
        1.14msGuestMiddleware.php#23pust_db
        Metadata
        Bindings
        • 0. 3.15.145.105
        • 1. 2025-04-14 21:03:12
        Backtrace
        • 16. middleware::guestCheck:23
        • 17. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 18. middleware::maintenance_mode:27
        • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 20. middleware::api_lang:22
      • 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 ('digital', 'physical') and `discount` != 0
        1.36msProductListController.php#174pust_db
        Metadata
        Bindings
        • 0. admin
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. 1
        • 5. approved
        • 6. admin
        • 7. 1
        • 8. digital
        • 9. physical
        • 10. 0
        Backtrace
        • 16. app/Http/Controllers/Web/ProductListController.php:174
        • 17. app/Http/Controllers/Web/ProductListController.php:29
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` 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 ('digital', 'physical') and `discount` != 0 order by `created_at` desc limit 20 offset 20
        1.34msProductListController.php#174pust_db
        Metadata
        Bindings
        • 0. 1
        • 1. admin
        • 2. 1
        • 3. 1
        • 4. 1
        • 5. 1
        • 6. approved
        • 7. admin
        • 8. 1
        • 9. digital
        • 10. physical
        • 11. 0
        Backtrace
        • 16. app/Http/Controllers/Web/ProductListController.php:174
        • 17. app/Http/Controllers/Web/ProductListController.php:29
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `reviews` where `reviews`.`product_id` in (471, 472, 479, 481, 483, 485, 486, 487, 488, 489, 490, 491, 492, 493, 498, 559, 562, 565, 566, 567) and `delivery_man_id` is null and `status` = 1
        190μsProductListController.php#174pust_db
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 21. app/Http/Controllers/Web/ProductListController.php:174
        • 22. app/Http/Controllers/Web/ProductListController.php:29
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `translations` where `translations`.`translationable_id` in (471, 472, 479, 481, 483, 485, 486, 487, 488, 489, 490, 491, 492, 493, 498, 559, 562, 565, 566, 567) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        230μsProductListController.php#174pust_db
        Metadata
        Bindings
        • 0. App\Models\Product
        • 1. en
        Backtrace
        • 21. app/Http/Controllers/Web/ProductListController.php:174
        • 22. app/Http/Controllers/Web/ProductListController.php:29
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 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 ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        6.44msbrand-manager.php#31pust_db
        Metadata
        Bindings
        • 0. admin
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. 1
        • 5. approved
        • 6. admin
        • 7. 1
        • 8. digital
        • 9. physical
        • 10. 1
        Backtrace
        • 15. app/Utils/brand-manager.php:31
        • 16. view::web-views.products.view:228
        • 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, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        230μsbrand-manager.php#31pust_db
        Metadata
        Bindings
        • 0. App\Models\Brand
        • 1. en
        Backtrace
        • 20. app/Utils/brand-manager.php:31
        • 21. view::web-views.products.view:228
        • 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 `categories` where `position` = 0 order by `priority` asc
        220μscategory-manager.php#13pust_db
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 15. app/Utils/category-manager.php:13
        • 16. view::web-views.products.view: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
      • select * from `categories` where `categories`.`parent_id` in (2, 3, 64) order by `priority` asc
        230μscategory-manager.php#13pust_db
        Metadata
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view: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
      • select * from `categories` where `categories`.`parent_id` in (37, 38, 39, 41, 42, 43, 44, 45, 70, 71, 73, 75, 76, 97, 98, 99, 100, 179, 181, 182, 184) order by `priority` asc
        420μscategory-manager.php#13pust_db
        Metadata
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view: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
      • select * from `translations` where `translations`.`translationable_id` in (46, 47, 48, 49, 50, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 89, 90, 91, 92, 93, 94, 95, 96, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 133, 144, 145, 146, 147, 148, 149, 150, 151, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        300μscategory-manager.php#13pust_db
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 30. app/Utils/category-manager.php:13
        • 31. view::web-views.products.view: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
      • select * from `translations` where `translations`.`translationable_id` in (37, 38, 39, 41, 42, 43, 44, 45, 70, 71, 73, 75, 76, 97, 98, 99, 100, 179, 181, 182, 184) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        710μscategory-manager.php#13pust_db
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 25. app/Utils/category-manager.php:13
        • 26. view::web-views.products.view: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
      • select * from `translations` where `translations`.`translationable_id` in (2, 3, 64) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        170μscategory-manager.php#13pust_db
        Metadata
        Bindings
        • 0. App\Models\Category
        • 1. en
        Backtrace
        • 20. app/Utils/category-manager.php:13
        • 21. view::web-views.products.view: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
      • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
        200μssettings.php#15pust_db
        Metadata
        Bindings
        • 0. currency_symbol_position
        Backtrace
        • 16. app/Utils/settings.php:15
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 24. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
        200μssettings.php#15pust_db
        Metadata
        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
        210μssettings.php#15pust_db
        Metadata
        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 `business_settings` where (`type` = 'announcement') limit 1
        180μssettings.php#15pust_db
        Metadata
        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` = 439157 and `is_guest` = 1) group by `cart_group_id`
        1.08mscart-manager.php#74pust_db
        Metadata
        Bindings
        • 0. 439157
        • 1. 1
        Backtrace
        • 14. app/Utils/cart-manager.php:74
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:21
        • 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 0 = 1
        140μscart-manager.php#43pust_db
        Metadata
        Backtrace
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:21
        • 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` = 439157 and `is_guest` = 1) group by `cart_group_id`
        260μscart-manager.php#74pust_db
        Metadata
        Bindings
        • 0. 439157
        • 1. 1
        Backtrace
        • 14. app/Utils/cart-manager.php:74
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:31
        • 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 0 = 1
        160μscart-manager.php#43pust_db
        Metadata
        Backtrace
        • 15. app/Utils/cart-manager.php:43
        • 16. view::layouts.front-end.partials._cart:31
        • 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 count(*) as aggregate from `categories` where `position` = 0
        170μs_header.blade.php#228pust_db
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:228
        • 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 order by `priority` asc limit 11 offset 11
        170μs_header.blade.php#228pust_db
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:228
        • 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 `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 ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        7.24msbrand-manager.php#31pust_db
        Metadata
        Bindings
        • 0. admin
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. 1
        • 5. approved
        • 6. admin
        • 7. 1
        • 8. digital
        • 9. physical
        • 10. 1
        Backtrace
        • 15. app/Utils/brand-manager.php:31
        • 16. view::layouts.front-end.partials._header:315
        • 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, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        260μsbrand-manager.php#31pust_db
        Metadata
        Bindings
        • 0. App\Models\Brand
        • 1. en
        Backtrace
        • 20. app/Utils/brand-manager.php:31
        • 21. view::layouts.front-end.partials._header:315
        • 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 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 ('digital', 'physical') and `discount` != 0
        760μs_header.blade.php#342pust_db
        Metadata
        Bindings
        • 0. admin
        • 1. 1
        • 2. 1
        • 3. 1
        • 4. 1
        • 5. approved
        • 6. admin
        • 7. 1
        • 8. digital
        • 9. physical
        • 10. 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:342
        • 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` = 'loader_gif') limit 1
        230μssettings.php#15pust_db
        Metadata
        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 `business_settings` where (`type` = 'country_code') limit 1
        180μssettings.php#15pust_db
        Metadata
        Bindings
        • 0. country_code
        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 (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-14' and date(`end_date`) >= '2025-04-14' limit 1
        510μs_footer.blade.php#104pust_db
        Metadata
        Bindings
        • 0. 1
        • 1. flash_deal
        • 2. 2025-04-14
        • 3. 2025-04-14
        Backtrace
        • 16. view::layouts.front-end.partials._footer:104
        • 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
        190μssettings.php#15pust_db
        Metadata
        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
        170μssettings.php#15pust_db
        Metadata
        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
        150μssettings.php#15pust_db
        Metadata
        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
        480μssettings.php#15pust_db
        Metadata
        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
        180μssettings.php#15pust_db
        Metadata
        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
        170μssettings.php#15pust_db
        Metadata
        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
        200μssettings.php#15pust_db
        Metadata
        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\BusinessSetting
      10
      App\Models\Category
      124
      App\Models\Brand
      60
      App\Models\Product
      20
          decimal_point_settings
          2
          product_brand
          1
          digital_product
          1
          business_mode
          single
          currency_model
          single_currency
          language
          array:1 [ 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 {#3667 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
          currency_code
          INR
          currency_symbol
          currency_exchange_rate
          60
          _token
          LhjmQMslgsROYlcgqp9tdRmeiwYTM0SfFz7m9b7t
          guest_id
          439157
          currency_symbol_position
          right
          company_email
          verify@pustaklab.in
          _previous
          array:1 [ "url" => "https://pustaklab.in/products?data_from=discounted&page=2&page_no=15" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /products
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:3 [ "data_from" => "discounted" "page" => "2" "page_no" => "15" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [ 0 => "pustaklab.in" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
          request_server
          0 of 0
          array:44 [ "PATH" => "/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "pustaklab.in" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/pustaklab.in/public_html" "REMOTE_ADDR" => "3.15.145.105" "REMOTE_PORT" => "50202" "SERVER_ADDR" => "172.31.0.192" "SERVER_NAME" => "pustaklab.in" "SERVER_ADMIN" => "iamnishanttyagi97@gmail.com" "SERVER_PORT" => "443" "REQUEST_URI" => "/products?data_from=discounted&page=2&page_no=15" "REDIRECT_URL" => "/products" "REDIRECT_QUERY_STRING" => "data_from=discounted&page=2&page_no=15" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "LSWS_EDITION" => "Openlitespeed 1.8.2" "X-LSCACHE" => "on,crawler" "SCRIPT_FILENAME" => "/home/pustaklab.in/public_html/index.php" "QUERY_STRING" => "data_from=discounted&page=2&page_no=15" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744644792.0674 "REQUEST_TIME" => 1744644792 ]
          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 => "Mon, 14 Apr 2025 15:33:12 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjlaS1FPY09wTmhUbHJnZ1VUblJjQ3c9PSIsInZhbHVlIjoiTlI1ZUEzZEIvSTViMWZkSHMxSGxsRUlHSEFBTWZ6S0pBaWp4S2NFUGJoclJoWDlRMm5RbEs2RlFmMXl3YzdKQlpwN0hDNDFPMko0a2ZkY3JrblljNmRlWUloTC9oT2c5Ylp3WnJFb2VLbFpybE1uU0Q4aWYxTGVxMEtldW5QTEIiLCJtYWMiOiJkYWU1NTRhOTNmNjY5N2MzNDU2Y2Y2N2ZhYTM5ZDMxZjdmNGI4YzhhMjNmYjVlYTkxMTI3MmMyZWY4NTAwM2FiIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 16:33:12 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IjlaS1FPY09wTmhUbHJnZ1VUblJjQ3c9PSIsInZhbHVlIjoiTlI1ZUEzZEIvSTViMWZkSHMxSGxsRUlHSEFBTWZ6S0pBaWp4S2NFUGJoclJoWDlRMm5RbEs2RlFmMXl3YzdKQlpwN0hDN" 1 => "6valley1730651901_session=eyJpdiI6IjRHcDJnTi81VXp0UzlRU1djZVdDWnc9PSIsInZhbHVlIjoiMGk0VkJzTktwVGlFVG95a1YySkg4bzVIeFIraHBhSDFoYkRMbmtFcDRlM3lwUS9uY01VWHY0aml1UDVMMGpQdi84a0djY1dxMTFrcDZPVWQwQVFMblY0STVhK201eHdtTG0xdVhhTTJaOER6YURaTTdWeXVsL2RaT25UQ1ZVc3oiLCJtYWMiOiI5NzMyNmRjN2EwYjM0NTZiOTEzNjcxYzI3NTI3OWMyMDZlOTc2ZDVkNTE1ZjZlZmZiNGYzMTQ4ZTQyMDY0MGUyIiwidGFnIjoiIn0%3D; expires=Mon, 14 Apr 2025 16:33:12 GMT; Max-Age=3600; path=/; httponly6valley1730651901_session=eyJpdiI6IjRHcDJnTi81VXp0UzlRU1djZVdDWnc9PSIsInZhbHVlIjoiMGk0VkJzTktwVGlFVG95a1YySkg4bzVIeFIraHBhSDFoYkRMbmtFcDRlM3lwUS9uY01VWHY0aml1UD" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjlaS1FPY09wTmhUbHJnZ1VUblJjQ3c9PSIsInZhbHVlIjoiTlI1ZUEzZEIvSTViMWZkSHMxSGxsRUlHSEFBTWZ6S0pBaWp4S2NFUGJoclJoWDlRMm5RbEs2RlFmMXl3YzdKQlpwN0hDNDFPMko0a2ZkY3JrblljNmRlWUloTC9oT2c5Ylp3WnJFb2VLbFpybE1uU0Q4aWYxTGVxMEtldW5QTEIiLCJtYWMiOiJkYWU1NTRhOTNmNjY5N2MzNDU2Y2Y2N2ZhYTM5ZDMxZjdmNGI4YzhhMjNmYjVlYTkxMTI3MmMyZWY4NTAwM2FiIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 16:33:12 GMT; path=/XSRF-TOKEN=eyJpdiI6IjlaS1FPY09wTmhUbHJnZ1VUblJjQ3c9PSIsInZhbHVlIjoiTlI1ZUEzZEIvSTViMWZkSHMxSGxsRUlHSEFBTWZ6S0pBaWp4S2NFUGJoclJoWDlRMm5RbEs2RlFmMXl3YzdKQlpwN0hDN" 1 => "6valley1730651901_session=eyJpdiI6IjRHcDJnTi81VXp0UzlRU1djZVdDWnc9PSIsInZhbHVlIjoiMGk0VkJzTktwVGlFVG95a1YySkg4bzVIeFIraHBhSDFoYkRMbmtFcDRlM3lwUS9uY01VWHY0aml1UDVMMGpQdi84a0djY1dxMTFrcDZPVWQwQVFMblY0STVhK201eHdtTG0xdVhhTTJaOER6YURaTTdWeXVsL2RaT25UQ1ZVc3oiLCJtYWMiOiI5NzMyNmRjN2EwYjM0NTZiOTEzNjcxYzI3NTI3OWMyMDZlOTc2ZDVkNTE1ZjZlZmZiNGYzMTQ4ZTQyMDY0MGUyIiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 16:33:12 GMT; path=/; httponly6valley1730651901_session=eyJpdiI6IjRHcDJnTi81VXp0UzlRU1djZVdDWnc9PSIsInZhbHVlIjoiMGk0VkJzTktwVGlFVG95a1YySkg4bzVIeFIraHBhSDFoYkRMbmtFcDRlM3lwUS9uY01VWHY0aml1UD" ] ]
          session_attributes
          0 of 0
          array:20 [ "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 1 "business_mode" => "single" "currency_model" => "single_currency" "language" => array:1 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 3 "system_default_currency_info" => App\Models\Currency {#3667 #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" "_token" => "LhjmQMslgsROYlcgqp9tdRmeiwYTM0SfFz7m9b7t" "guest_id" => 439157 "currency_symbol_position" => "right" "company_email" => "verify@pustaklab.in" "_previous" => array:1 [ "url" => "https://pustaklab.in/products?data_from=discounted&page=2&page_no=15" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]