Welcome To Aryvala integration LLP Home

Messages7 Timeline Exceptions Views57 Route Queries115 Models177 Mails Gate Session Request

Request history8.3.14840ms10MBGET /

warninglog[01:46:57] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[01:46:57] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[01:46:57] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[01:46:57] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[01:46:58] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[01:46:58] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
warninglog[01:46:58] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...

Booting (66.18ms)time
Application (773ms)time
1 x Application (92.12%)
773ms
1 x Booting (7.88%)
66.18ms

57 templates were rendered

1x web-views.homehome.blade.php#?blade
1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
4x web-views.partials._feature-product_feature-product.blade.php#?blade
1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
1x web-views.partials._top-sellers_top-sellers.blade.php#?blade
1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
8x web-views.partials._inline-single-product_inline-single-product.blade.php#?blade
8x web-views.partials._product-card-2_product-card-2.blade.php#?blade
1x web-views.partials._best-selling_best-selling.blade.php#?blade
1x web-views.partials._top-rated_top-rated.blade.php#?blade
2x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
16x web-views.partials._category-single-product_category-single-product.blade.php#?blade
1x web-views.partials._company-reliability_company-reliability.blade.php#?blade
1x layouts.front-end.appapp.blade.php#?blade
1x web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
1x layouts.front-end.partials._modals_modals.blade.php#?blade
1x layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
1x layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
1x layouts.front-end.partials._header_header.blade.php#?blade
1x layouts.front-end.partials._cart_cart.blade.php#?blade
1x layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
1x layouts.front-end.partials._footer_footer.blade.php#?blade
1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
1x layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET /
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\HomeController@index
namespace: App\Http\Controllers\Web
prefix
where
as: home
file: app/Http/Controllers/Web/HomeController.php:49-58

115 statements were executed, 36 of which were duplicates, 79 unique. Show only duplicated50.74ms

# Query soft limit for Debugbar is reached after 100 queries, additional 15 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` 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

590μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0
Backtrace	15. app/Utils/category-manager.php:86 16. app/Http/Controllers/Web/HomeController.php:62 17. app/Http/Controllers/Web/HomeController.php:53 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 (11, 24, 25, 27) 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')

880μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:62 22. app/Http/Controllers/Web/HomeController.php:53 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 (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

350μs6valleycategory-manager.php#86

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:62 27. app/Http/Controllers/Web/HomeController.php:53 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 (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `delivery_man_id` is null and `status` = 1

270μs6valleycategory-manager.php#86

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:62 27. app/Http/Controllers/Web/HomeController.php:53 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 (`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 (11, 24, 25, 27) and `position` = 1 order by `priority` asc

1.48ms6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:62 22. app/Http/Controllers/Web/HomeController.php:53 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 (`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 (12, 14, 28, 29, 30) and `position` = 2 order by `priority` asc

460μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 2
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:62 27. app/Http/Controllers/Web/HomeController.php:53 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 (13) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

300μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	30. app/Utils/category-manager.php:86 31. app/Http/Controllers/Web/HomeController.php:62 32. app/Http/Controllers/Web/HomeController.php:53 33. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 34. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (12, 14, 28, 29, 30) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

810μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	25. app/Utils/category-manager.php:86 26. app/Http/Controllers/Web/HomeController.php:62 27. app/Http/Controllers/Web/HomeController.php:53 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 (11, 24, 25, 27) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

220μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Utils/category-manager.php:86 21. app/Http/Controllers/Web/HomeController.php:62 22. app/Http/Controllers/Web/HomeController.php:53 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

280μs6valleysettings.php#15

Bindings	0: category_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Utils/category-manager.php:86 19. app/Http/Controllers/Web/HomeController.php:62 20. app/Http/Controllers/Web/HomeController.php:53 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `flash_deals`.*, (select count(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` = 'flash_deal' and `status` = 1) and date(`start_date`) <= '2025-04-16' and date(`end_date`) >= '2025-04-16' limit 1

340μs6valleyproduct-manager.php#1472

Bindings	0: flash_deal 1: 1 2: 2025-04-16 3: 2025-04-16
Backtrace	16. app/Utils/product-manager.php:1472 17. app/Http/Controllers/Web/HomeController.php:64 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where `type` = 'product_brand' limit 1

210μs6valleyHomeController.php#67

Bindings	0: product_brand
Backtrace	16. app/Http/Controllers/Web/HomeController.php:67 17. app/Http/Controllers/Web/HomeController.php:53 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 `categories` where `home_status` = 1 order by `priority` asc

270μs6valleyHomeController.php#68

Bindings	0: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:68 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (11, 24) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

260μs6valleyHomeController.php#68

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Http/Controllers/Web/HomeController.php:68 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

310μs6valleysettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:74 23. app/Http/Controllers/Web/HomeController.php:69 24. app/Http/Controllers/Web/HomeController.php:53 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`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 `category_ids` like '%\"11\"%'

830μs6valleyproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"11"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:74 22. app/Http/Controllers/Web/HomeController.php:69 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

280μs6valleysettings.php#15

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:74 23. app/Http/Controllers/Web/HomeController.php:69 24. app/Http/Controllers/Web/HomeController.php:53 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select count(*) as aggregate from `products` where (`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 `category_ids` like '%\"24\"%'

390μs6valleyproduct-manager.php#1298

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: %"24"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:74 22. app/Http/Controllers/Web/HomeController.php:69 23. app/Http/Controllers/Web/HomeController.php:53 24. 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 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 (`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 `category_ids` like '%\"24\"%' order by `order_details_count` desc limit 12 offset 0

2.09ms6valleyproduct-manager.php#1298

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: %"24"%
Backtrace	16. app/Utils/product-manager.php:1298 17. app/Http/Controllers/Web/HomeController.php:74 22. app/Http/Controllers/Web/HomeController.php:69 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `translations` where `translations`.`translationable_id` in (10, 11, 12, 13, 15, 30, 31, 32, 33, 35, 36, 37) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

740μs6valleyproduct-manager.php#1298

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:74 27. app/Http/Controllers/Web/HomeController.php:69 28. app/Http/Controllers/Web/HomeController.php:53 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `reviews` where `reviews`.`product_id` in (10, 11, 12, 13, 15, 30, 31, 32, 33, 35, 36, 37) and `delivery_man_id` is null and `status` = 1

240μs6valleyproduct-manager.php#1298

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1298 22. app/Http/Controllers/Web/HomeController.php:74 27. app/Http/Controllers/Web/HomeController.php:69 28. app/Http/Controllers/Web/HomeController.php:53 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` 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` = 'seller' and `status` = 1 and `request_status` = 1)) as `products_count` from `shops` where exists (select * from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` = 'approved'))

500μs6valleyHomeController.php#90

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: seller 8: 1 9: 1 10: approved
Backtrace	15. app/Http/Controllers/Web/HomeController.php:90 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `sellers`.*, (select count(*) from `orders` where `sellers`.`id` = `orders`.`seller_id`) as `orders_count` from `sellers` where `sellers`.`id` in (2)

300μs6valleyHomeController.php#90

Backtrace

20. app/Http/Controllers/Web/HomeController.php:90
21. app/Http/Controllers/Web/HomeController.php:53
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `products` where (`added_by` = 'seller') and `products`.`user_id` in (2) 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')

910μs6valleyHomeController.php#90

Bindings	0: seller 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical
Backtrace	25. app/Http/Controllers/Web/HomeController.php:90 26. app/Http/Controllers/Web/HomeController.php:53 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 29. 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 (`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')

750μs6valleyHomeController.php#108

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: admin
Backtrace	15. app/Http/Controllers/Web/HomeController.php:108 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `reviews` where `reviews`.`product_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `delivery_man_id` is null and `status` = 1

280μs6valleyHomeController.php#108

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/HomeController.php:108 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `status` = 1 group by `product_id`

330μs6valleyHomeController.php#108

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/HomeController.php:108 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

280μs6valleyHomeController.php#108

Bindings	0: App\Models\Product 1: en
Backtrace	20. app/Http/Controllers/Web/HomeController.php:108 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `status` = 1

260μs6valleyHomeController.php#112

Bindings	0: 1 1: 10 2: 11 3: 12 4: 13 5: 15 6: 18 7: 19 8: 20 9: 22 10: 23 11: 24 12: 25 13: 26 14: 27 15: 28 16: 29 17: 30 18: 31 19: 32 20: 33 21: 35 22: 36 23: 37 24: 1
Backtrace	16. app/Http/Controllers/Web/HomeController.php:112 17. app/Http/Controllers/Web/HomeController.php:53 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 `rating` from `reviews` where `status` = 1 and `product_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `status` = 1

210μs6valleyHomeController.php#114

Bindings	0: 1 1: 10 2: 11 3: 12 4: 13 5: 15 6: 18 7: 19 8: 20 9: 22 10: 23 11: 24 12: 25 13: 26 14: 27 15: 28 16: 29 17: 30 18: 31 19: 32 20: 33 21: 35 22: 36 23: 37 24: 1
Backtrace	14. app/Http/Controllers/Web/HomeController.php:114 15. app/Http/Controllers/Web/HomeController.php:53 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'vacation_add') limit 1

660μs6valleysettings.php#15

Bindings	0: vacation_add
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'company_name') limit 1

270μs6valleysettings.php#15

Bindings	0: company_name
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'shop_address') limit 1

250μs6valleysettings.php#15

Bindings	0: shop_address
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'company_phone') limit 1

230μs6valleysettings.php#15

Bindings	0: company_phone
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'company_fav_icon') limit 1

230μs6valleysettings.php#15

Bindings	0: company_fav_icon
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'bottom_banner') limit 1

310μs6valleysettings.php#15

Bindings	0: bottom_banner
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'offer_banner') limit 1

310μs6valleysettings.php#15

Bindings	0: offer_banner
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'temporary_close') limit 1

240μs6valleysettings.php#15

Bindings	0: temporary_close
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'temporary_close') limit 1

240μs6valleysettings.php#15

Bindings	0: temporary_close
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'shop_banner') limit 1

250μs6valleysettings.php#15

Bindings	0: shop_banner
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:118 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `admins` where (`id` = 1) limit 1

260μs6valleyInHouseTrait.php#43

Bindings	0: 1
Backtrace	16. app/Traits/InHouseTrait.php:43 17. app/Http/Controllers/Web/HomeController.php:118 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `admins` where (`id` = 1) limit 1

280μs6valleyInHouseTrait.php#43

Bindings	0: 1
Backtrace	16. app/Traits/InHouseTrait.php:43 17. app/Http/Controllers/Web/HomeController.php:118 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `status` = 1

240μs6valleyHomeController.php#123

Bindings	0: 1 1: 10 2: 11 3: 12 4: 13 5: 15 6: 18 7: 19 8: 20 9: 22 10: 23 11: 24 12: 25 13: 26 14: 27 15: 28 16: 29 17: 30 18: 31 19: 32 20: 33 21: 35 22: 36 23: 37 24: 1
Backtrace	16. app/Http/Controllers/Web/HomeController.php:123 17. app/Http/Controllers/Web/HomeController.php:53 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 count(*) as aggregate from `orders` where (`seller_is` = 'admin')

260μs6valleyHomeController.php#125

Bindings	0: admin
Backtrace	16. app/Http/Controllers/Web/HomeController.php:125 17. app/Http/Controllers/Web/HomeController.php:53 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 `business_settings` where (`type` = 'top_vendor_list_priority') limit 1

310μs6valleysettings.php#15

Bindings	0: top_vendor_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:128 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `business_settings` where (`type` = 'featured_product_priority') limit 1

300μs6valleysettings.php#15

Bindings	0: featured_product_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:130 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select count(*) as aggregate from `products` where (`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 (`featured` = 1)

1.46ms6valleyproduct-manager.php#990

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	16. app/Utils/product-manager.php:990 17. app/Http/Controllers/Web/HomeController.php:130 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.*, (select count(*) from `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 (`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 (`featured` = 1) order by `id` desc limit 12 offset 0

850μs6valleyproduct-manager.php#990

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 8: physical 9: 1
Backtrace	16. app/Utils/product-manager.php:990 17. app/Http/Controllers/Web/HomeController.php:130 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (10, 11, 15, 35) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

300μs6valleyproduct-manager.php#990

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:990 22. app/Http/Controllers/Web/HomeController.php:130 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `reviews` where `reviews`.`product_id` in (10, 11, 15, 35) and `delivery_man_id` is null and `status` = 1

230μs6valleyproduct-manager.php#990

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:990 22. app/Http/Controllers/Web/HomeController.php:130 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `products` where (`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') order by `id` desc limit 8

520μs6valleyHomeController.php#132

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	15. app/Http/Controllers/Web/HomeController.php:132 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `reviews` where `reviews`.`product_id` in (29, 30, 31, 32, 33, 35, 36, 37) and `delivery_man_id` is null and `status` = 1

220μs6valleyHomeController.php#132

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/HomeController.php:132 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (29, 30, 31, 32, 33, 35, 36, 37) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

260μs6valleyHomeController.php#132

Bindings	0: App\Models\Product 1: en
Backtrace	20. app/Http/Controllers/Web/HomeController.php:132 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1

570μs6valleysettings.php#15

Bindings	0: new_arrival_product_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Http/Controllers/Web/HomeController.php:133 19. app/Http/Controllers/Web/HomeController.php:53 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select count(*) as aggregate from `products` where (`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')

390μs6valleyproduct-manager.php#1218

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	16. app/Utils/product-manager.php:1218 17. app/Http/Controllers/Web/HomeController.php:133 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.*, (select count(*) from `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 (`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') order by `order_details_count` desc limit 8 offset 0

1.06ms6valleyproduct-manager.php#1218

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 8: physical
Backtrace	16. app/Utils/product-manager.php:1218 17. app/Http/Controllers/Web/HomeController.php:133 18. app/Http/Controllers/Web/HomeController.php:53 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `translations` where `translations`.`translationable_id` in (10, 11, 12, 13, 15, 29, 30, 31) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

280μs6valleyproduct-manager.php#1218

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Utils/product-manager.php:1218 22. app/Http/Controllers/Web/HomeController.php:133 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `reviews` where `reviews`.`product_id` in (10, 11, 12, 13, 15, 29, 30, 31) and `delivery_man_id` is null and `status` = 1

220μs6valleyproduct-manager.php#1218

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1218 22. app/Http/Controllers/Web/HomeController.php:133 23. app/Http/Controllers/Web/HomeController.php:53 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `brands` where `status` = 1 limit 15

240μs6valleyHomeController.php#135

Bindings	0: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:135 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (5) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'

230μs6valleyHomeController.php#135

Bindings	0: App\Models\Brand 1: en
Backtrace	20. app/Http/Controllers/Web/HomeController.php:135 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` 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) group by `product_id` order by `count` desc limit 6

520μs6valleyHomeController.php#145

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:145 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\Models\OrderDetail'

270μs6valleyHomeController.php#145

Bindings	0: App\Models\OrderDetail
Backtrace	20. app/Http/Controllers/Web/HomeController.php:145 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `products` where `status` = 1 and `products`.`id` in (10, 11, 12, 13, 15)

390μs6valleyHomeController.php#145

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/HomeController.php:145 21. app/Http/Controllers/Web/HomeController.php:53 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `reviews` where `reviews`.`product_id` in (10, 11, 12, 13, 15) and `delivery_man_id` is null and `status` = 1

260μs6valleyHomeController.php#145

Bindings	0: 1
Backtrace	25. app/Http/Controllers/Web/HomeController.php:145 26. app/Http/Controllers/Web/HomeController.php:53 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (10, 11, 12, 13, 15) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

260μs6valleyHomeController.php#145

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Http/Controllers/Web/HomeController.php:145 26. app/Http/Controllers/Web/HomeController.php:53 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where `reviews`.`product_id` = `products`.`id` 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 group by `product_id` order by `count` desc limit 6

340μs6valleyHomeController.php#155

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:155 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1

270μs6valleyHomeController.php#165

Bindings	0: 1 1: 1
Backtrace	16. app/Http/Controllers/Web/HomeController.php:165 17. app/Http/Controllers/Web/HomeController.php:53 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 `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc

250μs6valleyHomeController.php#166

Bindings	0: Main Banner 1: default 2: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:166 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1

1.4ms6valleyHomeController.php#167

Bindings	0: Main Section Banner 1: default 2: 1
Backtrace	16. app/Http/Controllers/Web/HomeController.php:167 17. app/Http/Controllers/Web/HomeController.php:53 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 `products` where (`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') order by RAND() limit 1

1.02ms6valleyHomeController.php#169

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	16. app/Http/Controllers/Web/HomeController.php:169 17. app/Http/Controllers/Web/HomeController.php:53 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 `translations` where `translations`.`translationable_id` in (36) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

310μs6valleyHomeController.php#169

Bindings	0: App\Models\Product 1: en
Backtrace	21. app/Http/Controllers/Web/HomeController.php:169 22. app/Http/Controllers/Web/HomeController.php:53 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 `reviews` where `reviews`.`product_id` in (36) and `delivery_man_id` is null and `status` = 1

230μs6valleyHomeController.php#169

Bindings	0: 1
Backtrace	21. app/Http/Controllers/Web/HomeController.php:169 22. app/Http/Controllers/Web/HomeController.php:53 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 `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc

220μs6valleyHomeController.php#170

Bindings	0: Footer Banner 1: default 2: 1
Backtrace	15. app/Http/Controllers/Web/HomeController.php:170 16. app/Http/Controllers/Web/HomeController.php:53 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 1 and `storages`.`data_id` is not null

310μs6valleyBanner.php#61

Bindings	0: App\Models\Banner 1: 1
Backtrace	20. app/Models/Banner.php:61 26. view::web-views.partials._home-top-slider:45 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` = 'currency_symbol_position') limit 1

850μs6valleysettings.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` = 'shop_banner') limit 1

500μs6valleysettings.php#15

Bindings	0: shop_banner
Backtrace	16. app/Utils/settings.php:15 23. view::web-views.partials._top-sellers:29 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `business_settings` where (`type` = 'company_fav_icon') limit 1

610μs6valleysettings.php#15

Bindings	0: company_fav_icon
Backtrace	16. app/Utils/settings.php:15 23. view::web-views.partials._top-sellers:35 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `business_settings` where (`type` = 'company_reliability') limit 1

430μs6valleysettings.php#15

Bindings	0: company_reliability
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_search_console_code') limit 1

320μs6valleysettings.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

290μs6valleysettings.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

280μs6valleysettings.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

270μs6valleysettings.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

260μs6valleysettings.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

270μs6valleysettings.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 `business_settings` where (`type` = 'announcement') limit 1

240μs6valleysettings.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 `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` 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` = 11531 and `is_guest` = 1) group by `cart_group_id`

420μs6valleycart-manager.php#100

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 11531 9: 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:21

select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` 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

330μs6valleycart-manager.php#65

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	15. app/Utils/cart-manager.php:65 16. view::layouts.front-end.partials._cart:21 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 (`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` = 11531 and `is_guest` = 1) group by `cart_group_id`

580μs6valleycart-manager.php#100

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 11531 9: 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:31

select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` 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

240μs6valleycart-manager.php#65

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	15. app/Utils/cart-manager.php:65 16. view::layouts.front-end.partials._cart:31 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 (`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

530μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0
Backtrace	15. app/Utils/category-manager.php:86 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 (11, 24, 25, 27) 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')

1.13ms6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	20. app/Utils/category-manager.php:86 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 (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

310μs6valleycategory-manager.php#86

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Utils/category-manager.php:86 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 (10, 11, 12, 13, 15, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37) and `delivery_man_id` is null and `status` = 1

240μs6valleycategory-manager.php#86

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:86 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 (`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 (11, 24, 25, 27) and `position` = 1 order by `priority` asc

520μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	20. app/Utils/category-manager.php:86 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 (`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 (12, 14, 28, 29, 30) and `position` = 2 order by `priority` asc

750μs6valleycategory-manager.php#86

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 2
Backtrace	25. app/Utils/category-manager.php:86 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 (13) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

260μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	30. app/Utils/category-manager.php:86 31. view::layouts.front-end.partials._header:235 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 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 (12, 14, 28, 29, 30) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

250μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	25. app/Utils/category-manager.php:86 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 (11, 24, 25, 27) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

230μs6valleycategory-manager.php#86

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Utils/category-manager.php:86 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

270μs6valleysettings.php#15

Bindings	0: category_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Utils/category-manager.php:86 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

680μs6valleysettings.php#15

Bindings	0: brand_list_priority
Backtrace	16. app/Utils/settings.php:15 18. app/Utils/brand-manager.php:35 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 (`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 (`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
520μs6valley
select * from `translations` where `translations`.`translationable_id` in (5) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
230μs6valley
select count(*) as aggregate from `products` where (`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
390μs6valley
select * from `business_settings` where (`type` = 'seller_registration') limit 1
830μs6valley
select * from `business_settings` where (`type` = 'loader_gif') limit 1
270μs6valley
select * from `business_settings` where (`type` = 'country_code') limit 1
230μs6valley
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-16' and date(`end_date`) >= '2025-04-16' limit 1
250μs6valley
select * from `business_settings` where (`type` = 'refund-policy') limit 1
230μs6valley
select * from `business_settings` where (`type` = 'return-policy') limit 1
200μs6valley
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
770μs6valley
select * from `business_settings` where (`type` = 'shipping-policy') limit 1
270μs6valley
select * from `business_settings` where (`type` = 'company_email') limit 1
920μs6valley
select * from `business_settings` where (`type` = 'shop_address') limit 1
220μs6valley
select * from `business_settings` where (`type` = 'whatsapp') limit 1
780μs6valley
select * from `business_settings` where (`type` = 'fcm_credentials') limit 1
630μs6valley

App\Models\Product: 107Product.php#?
App\Models\BusinessSetting: 35BusinessSetting.php#?
App\Models\Category: 22Category.php#?
App\Models\OrderDetail: 5OrderDetail.php#?
App\Models\Admin: 2Admin.php#?
App\Models\Brand: 2Brand.php#?
App\Models\Shop: 1Shop.php#?
App\Models\Seller: 1Seller.php#?
App\Models\Banner: 1Banner.php#?
App\Models\Storage: 1Storage.php#?

local: en
direction: ltr
system_default_currency_info: App\Models\Currency {#3621 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: INR
currency_symbol: ₹
currency_exchange_rate: 1
usd: 1
_token: kT6ItSyWXLb4O4ztsLZzC59ZGdw12XrfpwGqbUIA
guest_id: 11531
_flash: array:2 [ "new" => [] "old" => [] ]
_previous: array:1 [ "url" => "https://ujjwalbhaarat.com" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlhcFByZFdneXRVVC9Ia2Q0RlhIT2c9PSIsInZhbHVlIjoiTmt0K1ZkaTYrNHE5Y0ZWakQxNGZBazY3N3p5QXZWMm92c1FDaWhjTG51N0lmbmFCb0R6bnBqYXVNK0dZWjJ0Z2lTWXVuVVQzQldBNzRsbFRaZXZqMFUvQjZ3S21sZEdwZTdHU1pjLzBvVldmOTNPdU56SXRxSERxWng0ZGtpYVkiLCJtYWMiOiI2NWZjMjRiNTBkYTAzYTZjMGJkMGQ2MTM0MGNkNzBiZGUzOGJkNDIwNGY0ZDcxZDc0NmM4MjA3MGJkZWY0NGEwIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkVHQTVudTVVTDV4MDZTeXFjNDBuMEE9PSIsInZhbHVlIjoiNU1LUUEzb3FRQ0w2Ky8xRERNcnlENzFrczdKU3BMZ2RZcVpSWXZuNzFJZ295WW0xUGt2Y2pZaFYweVhKc3NyZ2UwQkxyTy8rM3B3aG1qTFZTYUlpYlphY0xHVDdYM08wL2V2ZnY1UFRXTjZwQWRsYU1scEk1amJsbStzZWRPOGkiLCJtYWMiOiI1ZDc0ZjYwZDcxMjQ1ZmFmY2NhNDEyMGE3NzNjZmNhOTk4NjY0ZjEzYWNjMzdlYmU4Njc3ZTA0NTM0MmRkNDc1IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImlhcFByZFdneXRVVC9Ia2Q0RlhIT2c9PSIsInZhbHVlIjoiTmt0K1ZkaTYrNHE5Y0ZWakQxNGZBazY3N3p5QXZWMm92c1FDaWhjTG51N0lmbmFCb0R6bnBqYXVNK0dZWjJ0Z2lTWXVuV ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "ujjwalbhaarat.com"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "kT6ItSyWXLb4O4ztsLZzC59ZGdw12XrfpwGqbUIA"
  "laravel_session" => "tm2ywIdjI8FiE6ytPmqqj4bOOSQVUnvltCKInVQO"
]

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 => "Tue, 15 Apr 2025 20:16:57 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpPUDE5S2ZFZFVyRnNiVE9heWlOY2c9PSIsInZhbHVlIjoibS8wbWpXa0R5bjQvTk9lYVI2ZTZHcTM5Z1pBVEoweE8wRWp3YU80MjZmcFpieU43NFdHSGtzMkllOU5lRmpLNkdPTU9aZ01TZkxQOS90eG1sWjJyTGNzQ3pJZDNVWnpJRm0vaHhvTGM3cjdWc3BzNkl0dnRHcEpWUllpdXpmM2kiLCJtYWMiOiI2NGIzYzJmM2I5YjRiNGEwM2NlMWY0NTk1ZWM2OTE5MWZjZmUwYmEyNzlhMzE4ZWNhMDM5MTFmMDQwODZlNDYwIiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 22:16:58 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpPUDE5S2ZFZFVyRnNiVE9heWlOY2c9PSIsInZhbHVlIjoibS8wbWpXa0R5bjQvTk9lYVI2ZTZHcTM5Z1pBVEoweE8wRWp3YU80MjZmcFpieU43NFdHSGtzMkllOU5lRmpLNkdPTU9aZ ▶"
    1 => "laravel_session=eyJpdiI6ImU4NUFnTXBDendQd1VJUW96K0pQVEE9PSIsInZhbHVlIjoicGdlcGpJZjVzUnh6dDI3MzFpZW5Fa2Y4YzZpUGc0bVVWNzFIc1VJL29kSmhlMkJISkZnRUt3R2EzMWNCcElicjZaek1nRXFXZFJ3cjdpSm8xT1ZxWk5PZlpmaXYzT1kwTU9QR2ZkYWtDUFdlOEZuTTNrV1UyQjVkb1VOa3kxWlkiLCJtYWMiOiIyN2E4OTE0YzM0ZGZlOWZhNzM2MDAzYmZiYzEyZTA3ODU1ZWYwOTM3MmRjZmRjMzE3ZDI2MDAwOTQwMzlkNTJkIiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 22:16:58 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImU4NUFnTXBDendQd1VJUW96K0pQVEE9PSIsInZhbHVlIjoicGdlcGpJZjVzUnh6dDI3MzFpZW5Fa2Y4YzZpUGc0bVVWNzFIc1VJL29kSmhlMkJISkZnRUt3R2EzMWNCcElicjZa ▶"
    2 => "popup_banner=eyJpdiI6IjljeVBXd1FOYmVURlBzRDVpWkFaRUE9PSIsInZhbHVlIjoiL2doSUVOU3RNeENrRnMyaXlLOTJYRDFVWWZlY2NEWUtzaEhYSFJnQjJIcUg3dzNhRklZb2gxTHlLMlRVeVVDSiIsIm1hYyI6IjJlYzdmMmNjZWM4YTI0YjYyYjg1NmQ5Y2VlY2E5OGNlYzU5ZDI4MTBiNjQxNmIyOWU4Zjg3OTViODJjZDQ2ZmIiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 15 Apr 2025 20:17:58 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6IjljeVBXd1FOYmVURlBzRDVpWkFaRUE9PSIsInZhbHVlIjoiL2doSUVOU3RNeENrRnMyaXlLOTJYRDFVWWZlY2NEWUtzaEhYSFJnQjJIcUg3dzNhRklZb2gxTHlLMlRVeVVDSiIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpPUDE5S2ZFZFVyRnNiVE9heWlOY2c9PSIsInZhbHVlIjoibS8wbWpXa0R5bjQvTk9lYVI2ZTZHcTM5Z1pBVEoweE8wRWp3YU80MjZmcFpieU43NFdHSGtzMkllOU5lRmpLNkdPTU9aZ01TZkxQOS90eG1sWjJyTGNzQ3pJZDNVWnpJRm0vaHhvTGM3cjdWc3BzNkl0dnRHcEpWUllpdXpmM2kiLCJtYWMiOiI2NGIzYzJmM2I5YjRiNGEwM2NlMWY0NTk1ZWM2OTE5MWZjZmUwYmEyNzlhMzE4ZWNhMDM5MTFmMDQwODZlNDYwIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 22:16:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpPUDE5S2ZFZFVyRnNiVE9heWlOY2c9PSIsInZhbHVlIjoibS8wbWpXa0R5bjQvTk9lYVI2ZTZHcTM5Z1pBVEoweE8wRWp3YU80MjZmcFpieU43NFdHSGtzMkllOU5lRmpLNkdPTU9aZ ▶"
    1 => "laravel_session=eyJpdiI6ImU4NUFnTXBDendQd1VJUW96K0pQVEE9PSIsInZhbHVlIjoicGdlcGpJZjVzUnh6dDI3MzFpZW5Fa2Y4YzZpUGc0bVVWNzFIc1VJL29kSmhlMkJISkZnRUt3R2EzMWNCcElicjZaek1nRXFXZFJ3cjdpSm8xT1ZxWk5PZlpmaXYzT1kwTU9QR2ZkYWtDUFdlOEZuTTNrV1UyQjVkb1VOa3kxWlkiLCJtYWMiOiIyN2E4OTE0YzM0ZGZlOWZhNzM2MDAzYmZiYzEyZTA3ODU1ZWYwOTM3MmRjZmRjMzE3ZDI2MDAwOTQwMzlkNTJkIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 22:16:58 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImU4NUFnTXBDendQd1VJUW96K0pQVEE9PSIsInZhbHVlIjoicGdlcGpJZjVzUnh6dDI3MzFpZW5Fa2Y4YzZpUGc0bVVWNzFIc1VJL29kSmhlMkJISkZnRUt3R2EzMWNCcElicjZa ▶"
    2 => "popup_banner=eyJpdiI6IjljeVBXd1FOYmVURlBzRDVpWkFaRUE9PSIsInZhbHVlIjoiL2doSUVOU3RNeENrRnMyaXlLOTJYRDFVWWZlY2NEWUtzaEhYSFJnQjJIcUg3dzNhRklZb2gxTHlLMlRVeVVDSiIsIm1hYyI6IjJlYzdmMmNjZWM4YTI0YjYyYjg1NmQ5Y2VlY2E5OGNlYzU5ZDI4MTBiNjQxNmIyOWU4Zjg3OTViODJjZDQ2ZmIiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 15-Apr-2025 20:17:58 GMT; path=/; httponly ◀popup_banner=eyJpdiI6IjljeVBXd1FOYmVURlBzRDVpWkFaRUE9PSIsInZhbHVlIjoiL2doSUVOU3RNeENrRnMyaXlLOTJYRDFVWWZlY2NEWUtzaEhYSFJnQjJIcUg3dzNhRklZb2gxTHlLMlRVeVVDSiIsIm1 ▶"
  ]
]

session_attributes

  0 of 0   
array:12 [▼
  "local" => "en"
  "direction" => "ltr"
  "system_default_currency_info" => App\Models\Currency {#3621 ▶
    #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" => "1"
      "status" => 1
      "created_at" => "2020-10-15 17:23:04"
      "updated_at" => "2024-11-09 13:29:16"
    ]
    #original: array:8 [▶
      "id" => 3
      "name" => "Indian Rupi"
      "symbol" => "₹"
      "code" => "INR"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2020-10-15 17:23:04"
      "updated_at" => "2024-11-09 13:29:16"
    ]
    #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" => "kT6ItSyWXLb4O4ztsLZzC59ZGdw12XrfpwGqbUIA"
  "guest_id" => 11531
  "_flash" => array:2 [▶
    "new" => []
    "old" => []
  ]
  "_previous" => array:1 [▶
    "url" => "https://ujjwalbhaarat.com"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-16 01:46:58	GET	/	7 57 115 177

1 x Application (92.12%)	773ms
1 x Booting (7.88%)	66.18ms

Shopping cart

Top sellers

Aryvala integration LLP

0.0

0

23

my farm

0.0

0

0

Aryvala integration LLP

0.0

0

23

my farm

0.0

0

0

Aryvala integration LLP

0.0

0

23

my farm

0.0

0

0

Aryvala integration LLP

0.0

0

23

my farm

0.0

0

0

Aryvala integration LLP

0.0

0

23

my farm

0.0

0

0

Recommended product

vatana

tomato

coriander

spinech

potato

onion

tomato

coriander

spinech

potato

onion

Out of stock

Product added to wishlist

Please Sign in

Delete this address?