Top-rated Products
1 Items found
Request history8.2.27PHP Version496msRequest Duration15MBMemory UsageGET productsRoute
    • Booting (319ms)time
    • Application (176ms)time
    • 1 x Booting (64.44%)
      319ms
      1 x Application (35.56%)
      176ms
      15 templates were rendered
      • web-views.products.viewview.blade.php#?blade
      • web-views.products._ajax-products_ajax-products.blade.php#?blade
      • web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • layouts.front-end.appapp.blade.php#?blade
      • web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
      • layouts.front-end.partials._modals_modals.blade.php#?blade
      • layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
      • layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
      • layouts.front-end.partials._header_header.blade.php#?blade
      • layouts.front-end.partials._cart_cart.blade.php#?blade
      • layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
      • layouts.front-end.partials._footer_footer.blade.php#?blade
      • layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
      • layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade
      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:39-49
      79 statements were executed, 44 of which were duplicates, 35 unique. Show only duplicated17ms
      • insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.222.112.64', '2025-04-05 05:38:38', '2025-04-05 05:38:38')
        190μsu723709977_jodhasbyrekhaGuestMiddleware.php#24
        Bindings
        • 0: 18.222.112.64
        • 1: 2025-04-05 05:38:38
        • 2: 2025-04-05 05:38:38
        Backtrace
        • 21. middleware::guestCheck:24
        • 22. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 23. middleware::maintenance_mode:30
        • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 25. middleware::api_lang:22
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0 and `home_status` = 1
        410μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 0
        • 9: 1
        Backtrace
        • 15. app/Utils/category-manager.php:90
        • 16. app/Http/Controllers/Web/ProductListController.php:53
        • 17. app/Http/Controllers/Web/ProductListController.php:44
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (23, 27, 30) and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
        440μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. app/Http/Controllers/Web/ProductListController.php:53
        • 22. app/Http/Controllers/Web/ProductListController.php:44
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (7, 8, 9, 10, 12, 14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        160μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. app/Http/Controllers/Web/ProductListController.php:53
        • 27. app/Http/Controllers/Web/ProductListController.php:44
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `reviews` where `reviews`.`product_id` in (7, 8, 9, 10, 12, 14) and `delivery_man_id` is null and `status` = 1
        140μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: 1
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. app/Http/Controllers/Web/ProductListController.php:53
        • 27. app/Http/Controllers/Web/ProductListController.php:44
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (23, 27, 30) and `position` = 1 order by `priority` asc
        270μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. app/Http/Controllers/Web/ProductListController.php:53
        • 22. app/Http/Controllers/Web/ProductListController.php:44
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (59) and `position` = 2 order by `priority` asc
        270μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 2
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. app/Http/Controllers/Web/ProductListController.php:53
        • 27. app/Http/Controllers/Web/ProductListController.php:44
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (59) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        130μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. app/Http/Controllers/Web/ProductListController.php:53
        • 27. app/Http/Controllers/Web/ProductListController.php:44
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (23, 27, 30) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        120μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. app/Http/Controllers/Web/ProductListController.php:53
        • 22. app/Http/Controllers/Web/ProductListController.php:44
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: category_list_priority
        Backtrace
        • 16. app/Utils/settings.php:15
        • 18. app/Utils/category-manager.php:90
        • 19. app/Http/Controllers/Web/ProductListController.php:53
        • 20. app/Http/Controllers/Web/ProductListController.php:44
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: brand_list_priority
        Backtrace
        • 16. app/Utils/settings.php:15
        • 18. app/Utils/brand-manager.php:62
        • 19. app/Http/Controllers/Web/ProductListController.php:54
        • 20. app/Http/Controllers/Web/ProductListController.php:44
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        310μsu723709977_jodhasbyrekhabrand-manager.php#87
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: admin
        • 9: 1
        • 10: 1
        • 11: approved
        • 12: admin
        • 13: 1
        • 14: digital
        • 15: physical
        • 16: 1
        Backtrace
        • 15. app/Utils/brand-manager.php:87
        • 16. app/Utils/brand-manager.php:62
        • 17. app/Http/Controllers/Web/ProductListController.php:54
        • 18. app/Http/Controllers/Web/ProductListController.php:44
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `translations` where `translations`.`translationable_id` in (6) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        140μsu723709977_jodhasbyrekhabrand-manager.php#87
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • 20. app/Utils/brand-manager.php:87
        • 21. app/Utils/brand-manager.php:62
        • 22. app/Http/Controllers/Web/ProductListController.php:54
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical'))) as `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')))
        330μsu723709977_jodhasbyrekhaproduct-manager.php#1974
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: admin
        • 9: 1
        • 10: 1
        • 11: approved
        • 12: admin
        • 13: 1
        • 14: digital
        • 15: physical
        Backtrace
        • 15. app/Utils/product-manager.php:1974
        • 16. app/Http/Controllers/Web/ProductListController.php:70
        • 17. app/Http/Controllers/Web/ProductListController.php:44
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `id` from `products` where (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`product_type` = 'digital') and 1 = 1
        260μsu723709977_jodhasbyrekhaproduct-manager.php#1983
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: digital
        Backtrace
        • 14. app/Utils/product-manager.php:1983
        • 15. app/Http/Controllers/Web/ProductListController.php:70
        • 16. app/Http/Controllers/Web/ProductListController.php:44
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical'))) as `digital_product_author_count` from `authors`
        240μsu723709977_jodhasbyrekhaproduct-manager.php#1989
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        Backtrace
        • 15. app/Utils/product-manager.php:1989
        • 16. app/Http/Controllers/Web/ProductListController.php:70
        • 17. app/Http/Controllers/Web/ProductListController.php:44
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `id` from `products` where (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`product_type` = 'digital') and 1 = 1
        210μsu723709977_jodhasbyrekhaproduct-manager.php#1997
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: digital
        Backtrace
        • 14. app/Utils/product-manager.php:1997
        • 15. app/Http/Controllers/Web/ProductListController.php:70
        • 16. app/Http/Controllers/Web/ProductListController.php:44
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `product_id`, AVG(rating) as count from `reviews` where `status` = 1 group by `product_id`
        160μsu723709977_jodhasbyrekhaproduct-manager.php#2167
        Bindings
        • 0: 1
        Backtrace
        • 15. app/Utils/product-manager.php:2167
        • 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • 17. app/Utils/product-manager.php:2166
        • 18. app/Http/Controllers/Web/ProductListController.php:70
        • 19. app/Http/Controllers/Web/ProductListController.php:44
      • select * from `business_settings` where (`type` = 'top_rated_product_list_priority') limit 1
        180μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: top_rated_product_list_priority
        Backtrace
        • 16. app/Utils/settings.php:15
        • 18. app/Utils/product-manager.php:2232
        • 19. app/Http/Controllers/Web/ProductListController.php:70
        • 20. app/Http/Controllers/Web/ProductListController.php:44
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `id` in (1, 6, 14) order by `reviews_count` desc
        1.5msu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: admin
        • 4: 1
        • 5: 1
        • 6: approved
        • 7: admin
        • 8: 1
        • 9: digital
        • 10: physical
        • 11: 1
        • 12: 6
        • 13: 14
        Backtrace
        • 15. app/Utils/product-manager.php:1206
        • 16. app/Utils/product-manager.php:2232
        • 17. app/Http/Controllers/Web/ProductListController.php:70
        • 18. app/Http/Controllers/Web/ProductListController.php:44
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `categories` where `categories`.`id` in (27)
        150μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `translations` where `translations`.`translationable_id` in (27) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        140μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 25. app/Utils/product-manager.php:1206
        • 26. app/Utils/product-manager.php:2232
        • 27. app/Http/Controllers/Web/ProductListController.php:70
        • 28. app/Http/Controllers/Web/ProductListController.php:44
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `reviews` where `reviews`.`product_id` in (14) and `delivery_man_id` is null and `status` = 1
        130μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: 1
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (14) and `status` = 1 group by `product_id`
        120μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: 1
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `sellers` where `sellers`.`id` in (1)
        180μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `wishlists` where `wishlists`.`product_id` in (14) and `customer_id` = 0
        110μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: 0
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `product_compares` where `product_compares`.`product_id` in (14) and `user_id` = 0
        300μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: 0
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `translations` where `translations`.`translationable_id` in (14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        150μsu723709977_jodhasbyrekhaproduct-manager.php#1206
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 20. app/Utils/product-manager.php:1206
        • 21. app/Utils/product-manager.php:2232
        • 22. app/Http/Controllers/Web/ProductListController.php:70
        • 23. app/Http/Controllers/Web/ProductListController.php:44
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select * from `products` where `products`.`id` = 14 limit 1
        290μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: 14
        Backtrace
        • 20. app/Utils/product.php:19
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `translations` where `translations`.`translationable_id` in (14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        160μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. app/Utils/product.php:19
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `reviews` where `reviews`.`product_id` in (14) and `delivery_man_id` is null and `status` = 1
        150μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: 1
        Backtrace
        • 25. app/Utils/product.php:19
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `price` from `db_gold_price` where `purity` = '20' order by `id` desc limit 1
        120μsu723709977_jodhasbyrekhaproduct.php#25
        Bindings
        • 0: 20
        Backtrace
        • 17. app/Utils/product.php:25
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `price` from `db_silver` where `status` = 1 order by `id` desc limit 1
        130μsu723709977_jodhasbyrekhaproduct.php#26
        Bindings
        • 0: 1
        Backtrace
        • 17. app/Utils/product.php:26
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `price` from `db_stone` where `id` = 23 order by `id` desc limit 1
        110μsu723709977_jodhasbyrekhaproduct.php#27
        Bindings
        • 0: 23
        Backtrace
        • 17. app/Utils/product.php:27
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `products` where `products`.`id` = 14 limit 1
        200μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: 14
        Backtrace
        • 20. app/Utils/product.php:19
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `translations` where `translations`.`translationable_id` in (14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        130μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. app/Utils/product.php:19
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `reviews` where `reviews`.`product_id` in (14) and `delivery_man_id` is null and `status` = 1
        130μsu723709977_jodhasbyrekhaproduct.php#19
        Bindings
        • 0: 1
        Backtrace
        • 25. app/Utils/product.php:19
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `price` from `db_gold_price` where `purity` = '20' order by `id` desc limit 1
        110μsu723709977_jodhasbyrekhaproduct.php#25
        Bindings
        • 0: 20
        Backtrace
        • 17. app/Utils/product.php:25
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `price` from `db_silver` where `status` = 1 order by `id` desc limit 1
        100μsu723709977_jodhasbyrekhaproduct.php#26
        Bindings
        • 0: 1
        Backtrace
        • 17. app/Utils/product.php:26
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `price` from `db_stone` where `id` = 23 order by `id` desc limit 1
        110μsu723709977_jodhasbyrekhaproduct.php#27
        Bindings
        • 0: 23
        Backtrace
        • 17. app/Utils/product.php:27
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 23. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
        170μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: currency_symbol_position
        Backtrace
        • 16. app/Utils/settings.php:15
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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_search_console_code') limit 1
        170μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: google_search_console_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'bing_webmaster_code') limit 1
        140μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: bing_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'baidu_webmaster_code') limit 1
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: baidu_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'yandex_webmaster_code') limit 1
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: yandex_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        140μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: google_tag_manager_id
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: pixel_analytics
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 24 and `storages`.`data_id` is not null
        140μsu723709977_jodhasbyrekhaBanner.php#61
        Bindings
        • 0: App\Models\Banner
        • 1: 24
        Backtrace
        • 20. app/Models/Banner.php:61
        • 26. view::layouts.front-end.partials._modals:12
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'announcement') limit 1
        120μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: announcement
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `currencies` where `status` = 1
        130μsu723709977_jodhasbyrekha_header.blade.php#39
        Bindings
        • 0: 1
        Backtrace
        • 15. view::layouts.front-end.partials._header:39
        • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 8797 and `is_guest` = 1) group by `cart_group_id`
        330μsu723709977_jodhasbyrekhacart-manager.php#100
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        • 9: 8797
        • 10: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:100
        • 15. app/Utils/cart-manager.php:57
        • 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • 17. app/Utils/cart-manager.php:56
        • 18. view::layouts.front-end.partials._cart:5
      • select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1
        220μsu723709977_jodhasbyrekhacart-manager.php#65
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        Backtrace
        • 15. app/Utils/cart-manager.php:65
        • 16. view::layouts.front-end.partials._cart:5
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 8797 and `is_guest` = 1) group by `cart_group_id`
        240μsu723709977_jodhasbyrekhacart-manager.php#100
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        • 9: 8797
        • 10: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:100
        • 15. app/Utils/cart-manager.php:57
        • 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • 17. app/Utils/cart-manager.php:56
        • 18. view::layouts.front-end.partials._cart:14
      • select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1
        190μsu723709977_jodhasbyrekhacart-manager.php#65
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        Backtrace
        • 15. app/Utils/cart-manager.php:65
        • 16. view::layouts.front-end.partials._cart:14
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `product_count` from `categories` where `position` = 0 and `home_status` = 1
        340μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 0
        • 9: 1
        Backtrace
        • 15. app/Utils/category-manager.php:90
        • 16. view::layouts.front-end.partials._header:235
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (23, 27, 30) and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
        440μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (7, 8, 9, 10, 12, 14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        160μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `reviews` where `reviews`.`product_id` in (7, 8, 9, 10, 12, 14) and `delivery_man_id` is null and `status` = 1
        140μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: 1
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (23, 27, 30) and `position` = 1 order by `priority` asc
        300μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 1
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (59) and `position` = 2 order by `priority` asc
        260μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 2
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 (59) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        140μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:90
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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 (23, 27, 30) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        220μsu723709977_jodhasbyrekhacategory-manager.php#90
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 20. app/Utils/category-manager.php:90
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'category_list_priority') limit 1
        220μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: category_list_priority
        Backtrace
        • 16. app/Utils/settings.php:15
        • 18. app/Utils/category-manager.php:90
        • 19. view::layouts.front-end.partials._header:235
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
        240μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: brand_list_priority
        Backtrace
        • 16. app/Utils/settings.php:15
        • 18. app/Utils/brand-manager.php:62
        • 19. view::layouts.front-end.partials._header:336
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        460μsu723709977_jodhasbyrekhabrand-manager.php#87
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: admin
        • 9: 1
        • 10: 1
        • 11: approved
        • 12: admin
        • 13: 1
        • 14: digital
        • 15: physical
        • 16: 1
        Backtrace
        • 15. app/Utils/brand-manager.php:87
        • 16. app/Utils/brand-manager.php:62
        • 17. view::layouts.front-end.partials._header:336
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `translations` where `translations`.`translationable_id` in (6) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        190μsu723709977_jodhasbyrekhabrand-manager.php#87
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • 20. app/Utils/brand-manager.php:87
        • 21. app/Utils/brand-manager.php:62
        • 22. view::layouts.front-end.partials._header:336
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select count(*) as aggregate from `products` where (`added_by` = 'admin') and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `discount` != 0
        330μsu723709977_jodhasbyrekha_header.blade.php#366
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: digital
        • 7: physical
        • 8: 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:366
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        270μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: loader_gif
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        130μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: country_code
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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-05' and date(`end_date`) >= '2025-04-05' limit 1
        240μsu723709977_jodhasbyrekha_footer.blade.php#109
        Bindings
        • 0: 1
        • 1: flash_deal
        • 2: 2025-04-05
        • 3: 2025-04-05
        Backtrace
        • 16. view::layouts.front-end.partials._footer:109
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        210μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: refund-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        190μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: return-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        180μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: cancellation-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'shipping-policy') limit 1
        230μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: shipping-policy
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        170μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: company_phone
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        190μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: company_email
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        190μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: shop_address
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
        220μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: whatsapp
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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` = 'fcm_credentials') limit 1
        220μsu723709977_jodhasbyrekhasettings.php#15
        Bindings
        • 0: fcm_credentials
        Backtrace
        • 16. app/Utils/settings.php:15
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 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
      21BusinessSetting.php#?
      App\Models\Product
      15Product.php#?
      App\Models\Category
      9Category.php#?
      App\Models\Review
      9Review.php#?
      App\Models\Brand
      2Brand.php#?
      App\Models\Gold
      2Gold.php#?
      App\Models\Silver
      2Silver.php#?
      App\Models\Stone
      2Stone.php#?
      App\Models\Currency
      2Currency.php#?
      App\Models\Storage
      1Storage.php#?
          local
          en
          direction
          ltr
          system_default_currency_info
          App\Models\Currency {#3783 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
          currency_code
          INR
          currency_symbol
          currency_exchange_rate
          1
          usd
          1
          _token
          EK3WtR8PVJxyob4veYyfpRmlk82CbjZnzdaM6on2
          guest_id
          8797
          _previous
          array:1 [ "url" => "https://jodhasbyrekha.com/products?data_from=top-rated&page=1" ]
          _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:2 [ "data_from" => "top-rated" "page" => "1" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:22 [ "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 => "br" ] "host" => array:1 [ 0 => "jodhasbyrekha.com" ] "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" ] "x-forwarded-for" => array:1 [ 0 => "18.222.112.64" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "18.222.112.64" ] "x-real-port" => array:1 [ 0 => "28763" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-port" => array:1 [ 0 => "443" ] "x-lscache" => array:1 [ 0 => "1" ] "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_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 => "Sat, 05 Apr 2025 05:38:38 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InVxVUwyRXp2bFVlYkFDQW1zWFhBamc9PSIsInZhbHVlIjoiblFrNTNFOGFpUlhPWkpFa1VhMmNVd0JQdlAwVVZ5MWZRczluSGhXWUpYdWlSTmtaWFZrYzNTTU04YktFWTU1d0FXbHhnTWtMNHA4VmtSYkI4ejJCamJiZzEzL01oV0tQK1VOVW05S0dRRzN0dXdMTFR6SlhzZ0doRjZhdU9XN2giLCJtYWMiOiJhZGZlN2E5Y2Y2NjJjYmM1NDViNDA0MDE3YWI1NWI1YjUwYzQwNjU1NDIzNmZhZDYwMzQzNjVlZDNlOTgxMWViIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 06:38:38 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6InVxVUwyRXp2bFVlYkFDQW1zWFhBamc9PSIsInZhbHVlIjoiblFrNTNFOGFpUlhPWkpFa1VhMmNVd0JQdlAwVVZ5MWZRczluSGhXWUpYdWlSTmtaWFZrYzNTTU04YktFWTU1d0FXbHhnT" 1 => "6valley1728386024_session=eyJpdiI6IlFORlRKNGdibEhRWVY2T1p1K0IvaVE9PSIsInZhbHVlIjoiWDh3Yi9yYUdHYzY5T0Nyay9DSzR6YmUxbXo0dHNxSlRORVhJTUdaTS81aktBeUt2VWx0VkxyQXI4bFU1NHNNWEs5K2xGV3hBUmV2dmx5YVlUM2N2YUlMbnRrYjFZS2w0NmJuQU15K2Fwb0pjTmhFMnZWRkVaTXEyTmdXb3JmYlMiLCJtYWMiOiJjMzY1NWQ5ZjhiNDkyMWUxY2U4ZjM2NmY2OWY3YTRlNjhhOTM3NTMyMzJiYjI0NjI5NWZlYTYwYjU5OGM2YzA3IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 06:38:38 GMT; Max-Age=3600; path=/; httponly6valley1728386024_session=eyJpdiI6IlFORlRKNGdibEhRWVY2T1p1K0IvaVE9PSIsInZhbHVlIjoiWDh3Yi9yYUdHYzY5T0Nyay9DSzR6YmUxbXo0dHNxSlRORVhJTUdaTS81aktBeUt2VWx0VkxyQXI4bF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InVxVUwyRXp2bFVlYkFDQW1zWFhBamc9PSIsInZhbHVlIjoiblFrNTNFOGFpUlhPWkpFa1VhMmNVd0JQdlAwVVZ5MWZRczluSGhXWUpYdWlSTmtaWFZrYzNTTU04YktFWTU1d0FXbHhnTWtMNHA4VmtSYkI4ejJCamJiZzEzL01oV0tQK1VOVW05S0dRRzN0dXdMTFR6SlhzZ0doRjZhdU9XN2giLCJtYWMiOiJhZGZlN2E5Y2Y2NjJjYmM1NDViNDA0MDE3YWI1NWI1YjUwYzQwNjU1NDIzNmZhZDYwMzQzNjVlZDNlOTgxMWViIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 06:38:38 GMT; path=/XSRF-TOKEN=eyJpdiI6InVxVUwyRXp2bFVlYkFDQW1zWFhBamc9PSIsInZhbHVlIjoiblFrNTNFOGFpUlhPWkpFa1VhMmNVd0JQdlAwVVZ5MWZRczluSGhXWUpYdWlSTmtaWFZrYzNTTU04YktFWTU1d0FXbHhnT" 1 => "6valley1728386024_session=eyJpdiI6IlFORlRKNGdibEhRWVY2T1p1K0IvaVE9PSIsInZhbHVlIjoiWDh3Yi9yYUdHYzY5T0Nyay9DSzR6YmUxbXo0dHNxSlRORVhJTUdaTS81aktBeUt2VWx0VkxyQXI4bFU1NHNNWEs5K2xGV3hBUmV2dmx5YVlUM2N2YUlMbnRrYjFZS2w0NmJuQU15K2Fwb0pjTmhFMnZWRkVaTXEyTmdXb3JmYlMiLCJtYWMiOiJjMzY1NWQ5ZjhiNDkyMWUxY2U4ZjM2NmY2OWY3YTRlNjhhOTM3NTMyMzJiYjI0NjI5NWZlYTYwYjU5OGM2YzA3IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 06:38:38 GMT; path=/; httponly6valley1728386024_session=eyJpdiI6IlFORlRKNGdibEhRWVY2T1p1K0IvaVE9PSIsInZhbHVlIjoiWDh3Yi9yYUdHYzY5T0Nyay9DSzR6YmUxbXo0dHNxSlRORVhJTUdaTS81aktBeUt2VWx0VkxyQXI4bF" ] ]
          session_attributes
          0 of 0
          array:12 [ "local" => "en" "direction" => "ltr" "system_default_currency_info" => App\Models\Currency {#3783 #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" => "INR" "symbol" => "" "code" => "INR" "exchange_rate" => "1" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2025-01-10 05:22:49" ] #original: array:8 [ "id" => 3 "name" => "INR" "symbol" => "" "code" => "INR" "exchange_rate" => "1" "status" => 1 "created_at" => "2020-10-15 17:23:04" "updated_at" => "2025-01-10 05:22:49" ] #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" => "1" "usd" => 1 "_token" => "EK3WtR8PVJxyob4veYyfpRmlk82CbjZnzdaM6on2" "guest_id" => 8797 "_previous" => array:1 [ "url" => "https://jodhasbyrekha.com/products?data_from=top-rated&page=1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-05 05:38:38GET/products?data_from=top-rated&page=1157965