Welcome To سوق بنيان Home

Messages55 Timeline Exceptions Views172 Route Queries183 Models1588 Mails Gate Session Request

Request history8.3.111.43s14MBGET /

warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:42:59] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[00:43:00] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...

Booting (93.74ms)time
Application (1.34s)time
1 x Application (93.46%)
1.34s
1 x Booting (6.54%)
93.74ms

172 templates were rendered

1x web-views.homehome.blade.php#?blade
1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
1x web-views.partials._deal-of-the-day_deal-of-the-day.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
21x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
126x 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

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

183 statements were executed, 33 of which were duplicates, 150 unique. Show only duplicated986ms

# Query soft limit for Debugbar is reached after 100 queries, additional 83 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 * from `business_settings` where (`type` = 'maintenance_mode') limit 1

640μslaravelhelpers.php#168

Bindings	0: maintenance_mode
Backtrace	16. app/Utils/helpers.php:168 17. middleware::maintenance_mode:20 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 19. middleware::api_lang:22 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')) as `product_count` from `categories` where `position` = 0

32.74mslaravelcategory-manager.php#82

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: 0
Backtrace	15. app/Utils/category-manager.php:82 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 (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')

7.81mslaravelcategory-manager.php#82

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical
Backtrace	20. app/Utils/category-manager.php:82 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 (2550, 2551) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

560μslaravelcategory-manager.php#82

Bindings	0: App\Models\Product 1: kw
Backtrace	25. app/Utils/category-manager.php:82 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 (2550, 2551) and `delivery_man_id` is null and `status` = 1

380μslaravelcategory-manager.php#82

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:82 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`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` = 1 order by `priority` asc

111mslaravelcategory-manager.php#82

Bindings	0: 1
Backtrace	20. app/Utils/category-manager.php:82 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`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `position` = 2 order by `priority` asc

84.12mslaravelcategory-manager.php#82

Bindings	0: 2
Backtrace	25. app/Utils/category-manager.php:82 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 (6, 8, 9, 11, 12, 16, 18, 20, 22, 24, 29, 31, 32, 33, 36, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 58, 60, 68, 70, 71, 73, 75, 80, 85, 87, 88, 95, 96, 99, 101, 102, 103, 104, 105, 107, 108, 113, 114, 115, 116, 119, 120, 121, 123, 136, 137, 138, 139, 141, 147, 149, 151, 156) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'

1.26mslaravelcategory-manager.php#82

Bindings	0: App\Models\Category 1: kw
Backtrace	30. app/Utils/category-manager.php:82 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 (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'

1.07mslaravelcategory-manager.php#82

Bindings	0: App\Models\Category 1: kw
Backtrace	25. app/Utils/category-manager.php:82 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 (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'

570μslaravelcategory-manager.php#82

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

520μslaravelsettings.php#16

Bindings	0: category_list_priority
Backtrace	16. app/Utils/settings.php:16 18. app/Utils/category-manager.php:82 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-05-06' and date(`end_date`) >= '2025-05-06' limit 1

540μslaravelproduct-manager.php#1318

Bindings	0: flash_deal 1: 1 2: 2025-05-06 3: 2025-05-06
Backtrace	16. app/Utils/product-manager.php:1318 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

510μslaravelHomeController.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

780μslaravelHomeController.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 (9, 11, 15, 26, 39, 45, 67, 86, 96, 111, 135, 157, 158, 159, 161, 162, 163, 164, 165, 166, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'

780μslaravelHomeController.php#68

Bindings	0: App\Models\Category 1: kw
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

630μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"11\"%'

7.44mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"11"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"11\"%' order by `order_details_count` desc limit 12 offset 0

13.99mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"11"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (750, 1508, 1509, 1510, 1542, 2062, 2063) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

620μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (750, 1508, 1509, 1510, 1542, 2062, 2063) and `delivery_man_id` is null and `status` = 1

660μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

660μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"135\"%'

9.11mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"135"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"135\"%' order by `order_details_count` desc limit 12 offset 0

16.58mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"135"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (96, 1563, 1659, 1753, 1890, 2173, 2174, 2175, 2396) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

680μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (96, 1563, 1659, 1753, 1890, 2173, 2174, 2175, 2396) and `delivery_man_id` is null and `status` = 1

470μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

540μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"111\"%'

8.26mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"111"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"111\"%' order by `order_details_count` desc limit 12 offset 0

16.47mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"111"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (550, 551, 1009, 1481, 1482) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

490μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (550, 551, 1009, 1481, 1482) and `delivery_man_id` is null and `status` = 1

320μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

500μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"96\"%'

4.73mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"96"%
Backtrace	16. app/Utils/product-manager.php:1144 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

470μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"86\"%'

5.95mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"86"%
Backtrace	16. app/Utils/product-manager.php:1144 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

660μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"67\"%'

5.75mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"67"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"67\"%' order by `order_details_count` desc limit 12 offset 0

10.55mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"67"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (271, 273, 1032, 1033, 1034, 1035, 1966, 2451, 2452) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

520μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (271, 273, 1032, 1033, 1034, 1035, 1966, 2451, 2452) and `delivery_man_id` is null and `status` = 1

340μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

510μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"45\"%'

6.15mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"45"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"45\"%' order by `order_details_count` desc limit 12 offset 0

11.77mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"45"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (275, 276, 994, 1081, 1511, 1512, 1543, 1544, 1545, 1912) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

570μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (275, 276, 994, 1081, 1511, 1512, 1543, 1544, 1545, 1912) and `delivery_man_id` is null and `status` = 1

340μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

440μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"39\"%'

5.45mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"39"%
Backtrace	16. app/Utils/product-manager.php:1144 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

450μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"26\"%'

6.65mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"26"%
Backtrace	16. app/Utils/product-manager.php:1144 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

470μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"15\"%'

5.95mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"15"%
Backtrace	16. app/Utils/product-manager.php:1144 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

500μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"9\"%'

7.78mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"9"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"9\"%' order by `order_details_count` desc limit 12 offset 0

11.99mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"9"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (420, 421, 769, 785, 834, 835, 1285, 2106, 2107, 2108) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

630μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (420, 421, 769, 785, 834, 835, 1285, 2106, 2107, 2108) and `delivery_man_id` is null and `status` = 1

420μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

510μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"157\"%'

5.34mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"157"%
Backtrace	16. app/Utils/product-manager.php:1144 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

540μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"158\"%'

5.43mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"158"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"158\"%' order by `order_details_count` desc limit 12 offset 0

16.35mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"158"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (1515, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1553, 1554, 1653, 1729) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

770μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (1515, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1553, 1554, 1653, 1729) and `delivery_man_id` is null and `status` = 1

500μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

640μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"159\"%'

8.71mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"159"%
Backtrace	16. app/Utils/product-manager.php:1144 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

640μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"161\"%'

5.6mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"161"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"161\"%' order by `order_details_count` desc limit 12 offset 0

12.23mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"161"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (1747, 1758, 1854, 1871, 1874, 1899, 1902, 1909, 1948, 1950, 1953, 1954) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

680μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (1747, 1758, 1854, 1871, 1874, 1899, 1902, 1909, 1948, 1950, 1953, 1954) and `delivery_man_id` is null and `status` = 1

330μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

430μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"162\"%'

5.94mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"162"%
Backtrace	16. app/Utils/product-manager.php:1144 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

470μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"163\"%'

8.02mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"163"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"163\"%' order by `order_details_count` desc limit 12 offset 0

16.5mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"163"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (2550, 2551) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

850μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (2550, 2551) and `delivery_man_id` is null and `status` = 1

450μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

640μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"164\"%'

6.23mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"164"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"164\"%' order by `order_details_count` desc limit 12 offset 0

16.51mslaravelproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: admin 4: 1 5: 1 6: 1 7: approved 8: admin 9: 1 10: physical 11: %"164"%
Backtrace	16. app/Utils/product-manager.php:1144 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 (1041, 1042, 1043, 1141, 1142, 1290, 1524, 1769, 1770, 1972, 1974, 1975) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

500μslaravelproduct-manager.php#1144

Bindings	0: App\Models\Product 1: kw
Backtrace	21. app/Utils/product-manager.php:1144 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 (1041, 1042, 1043, 1141, 1142, 1290, 1524, 1769, 1770, 1972, 1974, 1975) and `delivery_man_id` is null and `status` = 1

320μslaravelproduct-manager.php#1144

Bindings	0: 1
Backtrace	21. app/Utils/product-manager.php:1144 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 `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1

370μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"165\"%'

4.88mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"165"%
Backtrace	16. app/Utils/product-manager.php:1144 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

420μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"166\"%'

4.58mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"166"%
Backtrace	16. app/Utils/product-manager.php:1144 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

560μslaravelsettings.php#16

Bindings	0: category_wise_product_list_priority
Backtrace	16. app/Utils/settings.php:16 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `category_ids` like '%\"168\"%'

7.92mslaravelproduct-manager.php#1144

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: %"168"%
Backtrace	16. app/Utils/product-manager.php:1144 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 `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'seller' and `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'))

63.96mslaravelHomeController.php#90

Bindings	0: admin 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: physical 8: seller 9: 1 10: 1 11: 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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)

1.57mslaravelHomeController.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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')

8.51mslaravelHomeController.php#90

Bindings	0: seller 1: admin 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: 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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`added_by` = 'admin')

18.66mslaravelHomeController.php#108

Bindings	0: 1 1: admin 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: physical 9: 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 (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `delivery_man_id` is null and `status` = 1

1.67mslaravelHomeController.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 (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `status` = 1 group by `product_id`

1.38mslaravelHomeController.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 (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'

1.97mslaravelHomeController.php#108

Bindings	0: App\Models\Product 1: kw
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 (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `status` = 1

1.28mslaravelHomeController.php#112

Bindings

0: 1
1: 4
2: 9
3: 29
4: 40
5: 47
6: 57
7: 69
8: 91
9: 93
10: 96
11: 112
12: 114
13: 131
14: 138
15: 139
16: 170
17: 171
18: 184
19: 193
20: 229
21: 231
22: 235
23: 238
24: 242
25: 248
26: 253
27: 254
28: 255
29: 256
30: 263
31: 264
32: 267
33: 268
34: 271
35: 273
36: 274
37: 275
38: 276
39: 278
40: 294
41: 297
42: 307
43: 310
44: 311
45: 315
46: 320
47: 331
48: 332
49: 350
50: 351
51: 356
52: 357
53: 358
54: 365
55: 367
56: 368
57: 369
58: 378
59: 379
60: 386
61: 390
62: 391
63: 392
64: 393
65: 400
66: 405
67: 419
68: 420
69: 421
70: 424
71: 426
72: 427
73: 429
74: 450
75: 451
76: 452
77: 454
78: 455
79: 456
80: 457
81: 458
82: 459
83: 466
84: 469
85: 475
86: 476
87: 477
88: 478
89: 479
90: 480
91: 481
92: 482
93: 483
94: 484
95: 485
96: 486
97: 487
98: 488
99: 489
100: 490
101: 491
102: 492
103: 493
104: 494
105: 495
106: 496
107: 497
108: 498
109: 499
110: 500
111: 501
112: 502
113: 503
114: 504
115: 505
116: 506
117: 507
118: 508
119: 509
120: 510
121: 511
122: 512
123: 513
124: 514
125: 515
126: 516
127: 517
128: 518
129: 519
130: 520
131: 521
132: 522
133: 523
134: 524
135: 525
136: 527
137: 533
138: 535
139: 539
140: 545
141: 546
142: 547
143: 548
144: 549
145: 550
146: 551
147: 571
148: 573
149: 576
150: 581
151: 582
152: 583
153: 584
154: 591
155: 651
156: 657
157: 660
158: 663
159: 692
160: 693
161: 694
162: 695
163: 696
164: 697
165: 698
166: 720
167: 727
168: 731
169: 733
170: 734
171: 735
172: 736
173: 737
174: 749
175: 750
176: 753
177: 754
178: 758
179: 759
180: 762
181: 763
182: 765
183: 767
184: 768
185: 769
186: 782
187: 783
188: 785
189: 788
190: 792
191: 800
192: 807
193: 819
194: 820
195: 832
196: 833
197: 834
198: 835
199: 838
200: 844
201: 845
202: 846
203: 847
204: 848
205: 849
206: 850
207: 851
208: 852
209: 853
210: 854
211: 856
212: 861
213: 862
214: 863
215: 864
216: 867
217: 870
218: 871
219: 875
220: 881
221: 882
222: 883
223: 889
224: 891
225: 986
226: 987
227: 988
228: 989
229: 990
230: 993
231: 994
232: 1007
233: 1009
234: 1014
235: 1015
236: 1019
237: 1021
238: 1023
239: 1024
240: 1025
241: 1031
242: 1032
243: 1033
244: 1034
245: 1035
246: 1039
247: 1041
248: 1042
249: 1043
250: 1052
251: 1053
252: 1056
253: 1075
254: 1078
255: 1079
256: 1081
257: 1086
258: 1113
259: 1121
260: 1123
261: 1126
262: 1128
263: 1132
264: 1141
265: 1142
266: 1143
267: 1144
268: 1147
269: 1148
270: 1149
271: 1151
272: 1152
273: 1153
274: 1164
275: 1172
276: 1173
277: 1174
278: 1175
279: 1176
280: 1177
281: 1225
282: 1226
283: 1268
284: 1269
285: 1270
286: 1271
287: 1285
288: 1290
289: 1291
290: 1292
291: 1302
292: 1303
293: 1304
294: 1305
295: 1306
296: 1313
297: 1315
298: 1324
299: 1330
300: 1349
301: 1377
302: 1378
303: 1385
304: 1388
305: 1389
306: 1390
307: 1391
308: 1392
309: 1394
310: 1419
311: 1466
312: 1467
313: 1468
314: 1471
315: 1481
316: 1482
317: 1484
318: 1493
319: 1494
320: 1495
321: 1496
322: 1498
323: 1499
324: 1506
325: 1508
326: 1509
327: 1510
328: 1511
329: 1512
330: 1514
331: 1515
332: 1524
333: 1538
334: 1542
335: 1543
336: 1544
337: 1545
338: 1546
339: 1547
340: 1548
341: 1549
342: 1552
343: 1553
344: 1554
345: 1557
346: 1563
347: 1567
348: 1571
349: 1575
350: 1582
351: 1585
352: 1586
353: 1587
354: 1588
355: 1591
356: 1594
357: 1595
358: 1631
359: 1632
360: 1653
361: 1659
362: 1673
363: 1674
364: 1677
365: 1678
366: 1679
367: 1684
368: 1685
369: 1686
370: 1687
371: 1690
372: 1692
373: 1693
374: 1694
375: 1695
376: 1696
377: 1698
378: 1699
379: 1700
380: 1701
381: 1702
382: 1703
383: 1704
384: 1705
385: 1707
386: 1709
387: 1710
388: 1711
389: 1712
390: 1714
391: 1715
392: 1716
393: 1724
394: 1726
395: 1729
396: 1730
397: 1744
398: 1745
399: 1746
400: 1747
401: 1752
402: 1753
403: 1758
404: 1767
405: 1769
406: 1770
407: 1771
408: 1772
409: 1776
410: 1815
411: 1819
412: 1824
413: 1825
414: 1838
415: 1839
416: 1840
417: 1841
418: 1846
419: 1854
420: 1864
421: 1866
422: 1868
423: 1869
424: 1871
425: 1874
426: 1877
427: 1890
428: 1891
429: 1899
430: 1902
431: 1903
432: 1909
433: 1910
434: 1912
435: 1919
436: 1926
437: 1927
438: 1932
439: 1934
440: 1935
441: 1944
442: 1946
443: 1947
444: 1948
445: 1950
446: 1953
447: 1954
448: 1957
449: 1963
450: 1964
451: 1966
452: 1972
453: 1974
454: 1975
455: 1976
456: 1980
457: 1983
458: 1991
459: 1992
460: 1996
461: 2001
462: 2002
463: 2003
464: 2004
465: 2005
466: 2006
467: 2007
468: 2008
469: 2010
470: 2011
471: 2012
472: 2014
473: 2050
474: 2051
475: 2062
476: 2063
477: 2068
478: 2078
479: 2079
480: 2081
481: 2082
482: 2083
483: 2097
484: 2098
485: 2099
486: 2102
487: 2103
488: 2106
489: 2107
490: 2108
491: 2109
492: 2110
493: 2129
494: 2130
495: 2131
496: 2132
497: 2133
498: 2134
499: 2135
500: 2136
501: 2137
502: 2140
503: 2141
504: 2142
505: 2143
506: 2144
507: 2145
508: 2146
509: 2147
510: 2148
511: 2149
512: 2150
513: 2173
514: 2174
515: 2175
516: 2179
517: 2180
518: 2181
519: 2182
520: 2183
521: 2184
522: 2189
523: 2190
524: 2193
525: 2196
526: 2205
527: 2207
528: 2210
529: 2211
530: 2212
531: 2217
532: 2219
533: 2231
534: 2234
535: 2238
536: 2241
537: 2243
538: 2247
539: 2248
540: 2253
541: 2254
542: 2255
543: 2257
544: 2271
545: 2284
546: 2290
547: 2315
548: 2316
549: 2354
550: 2355
551: 2357
552: 2361
553: 2379
554: 2380
555: 2382
556: 2387
557: 2388
558: 2389
559: 2390
560: 2391
561: 2392
562: 2393
563: 2394
564: 2396
565: 2399
566: 2407
567: 2408
568: 2416
569: 2417
570: 2418
571: 2419
572: 2430
573: 2432
574: 2435
575: 2436
576: 2439
577: 2443
578: 2446
579: 2448
580: 2449
581: 2450
582: 2451
583: 2452
584: 2453
585: 2459
586: 2464
587: 2472
588: 2473
589: 2474
590: 2513
591: 2516
592: 2517
593: 2518
594: 2519
595: 2520
596: 2521
597: 2522
598: 2523
599: 2524
600: 2525
601: 2526
602: 2527
603: 2528
604: 2530
605: 2531
606: 2532
607: 2533
608: 2534
609: 2535
610: 2536
611: 2537
612: 2538
613: 2539
614: 2540
615: 2550
616: 2551
617: 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 (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `status` = 1

1.08mslaravelHomeController.php#114

Bindings

0: 1
1: 4
2: 9
3: 29
4: 40
5: 47
6: 57
7: 69
8: 91
9: 93
10: 96
11: 112
12: 114
13: 131
14: 138
15: 139
16: 170
17: 171
18: 184
19: 193
20: 229
21: 231
22: 235
23: 238
24: 242
25: 248
26: 253
27: 254
28: 255
29: 256
30: 263
31: 264
32: 267
33: 268
34: 271
35: 273
36: 274
37: 275
38: 276
39: 278
40: 294
41: 297
42: 307
43: 310
44: 311
45: 315
46: 320
47: 331
48: 332
49: 350
50: 351
51: 356
52: 357
53: 358
54: 365
55: 367
56: 368
57: 369
58: 378
59: 379
60: 386
61: 390
62: 391
63: 392
64: 393
65: 400
66: 405
67: 419
68: 420
69: 421
70: 424
71: 426
72: 427
73: 429
74: 450
75: 451
76: 452
77: 454
78: 455
79: 456
80: 457
81: 458
82: 459
83: 466
84: 469
85: 475
86: 476
87: 477
88: 478
89: 479
90: 480
91: 481
92: 482
93: 483
94: 484
95: 485
96: 486
97: 487
98: 488
99: 489
100: 490
101: 491
102: 492
103: 493
104: 494
105: 495
106: 496
107: 497
108: 498
109: 499
110: 500
111: 501
112: 502
113: 503
114: 504
115: 505
116: 506
117: 507
118: 508
119: 509
120: 510
121: 511
122: 512
123: 513
124: 514
125: 515
126: 516
127: 517
128: 518
129: 519
130: 520
131: 521
132: 522
133: 523
134: 524
135: 525
136: 527
137: 533
138: 535
139: 539
140: 545
141: 546
142: 547
143: 548
144: 549
145: 550
146: 551
147: 571
148: 573
149: 576
150: 581
151: 582
152: 583
153: 584
154: 591
155: 651
156: 657
157: 660
158: 663
159: 692
160: 693
161: 694
162: 695
163: 696
164: 697
165: 698
166: 720
167: 727
168: 731
169: 733
170: 734
171: 735
172: 736
173: 737
174: 749
175: 750
176: 753
177: 754
178: 758
179: 759
180: 762
181: 763
182: 765
183: 767
184: 768
185: 769
186: 782
187: 783
188: 785
189: 788
190: 792
191: 800
192: 807
193: 819
194: 820
195: 832
196: 833
197: 834
198: 835
199: 838
200: 844
201: 845
202: 846
203: 847
204: 848
205: 849
206: 850
207: 851
208: 852
209: 853
210: 854
211: 856
212: 861
213: 862
214: 863
215: 864
216: 867
217: 870
218: 871
219: 875
220: 881
221: 882
222: 883
223: 889
224: 891
225: 986
226: 987
227: 988
228: 989
229: 990
230: 993
231: 994
232: 1007
233: 1009
234: 1014
235: 1015
236: 1019
237: 1021
238: 1023
239: 1024
240: 1025
241: 1031
242: 1032
243: 1033
244: 1034
245: 1035
246: 1039
247: 1041
248: 1042
249: 1043
250: 1052
251: 1053
252: 1056
253: 1075
254: 1078
255: 1079
256: 1081
257: 1086
258: 1113
259: 1121
260: 1123
261: 1126
262: 1128
263: 1132
264: 1141
265: 1142
266: 1143
267: 1144
268: 1147
269: 1148
270: 1149
271: 1151
272: 1152
273: 1153
274: 1164
275: 1172
276: 1173
277: 1174
278: 1175
279: 1176
280: 1177
281: 1225
282: 1226
283: 1268
284: 1269
285: 1270
286: 1271
287: 1285
288: 1290
289: 1291
290: 1292
291: 1302
292: 1303
293: 1304
294: 1305
295: 1306
296: 1313
297: 1315
298: 1324
299: 1330
300: 1349
301: 1377
302: 1378
303: 1385
304: 1388
305: 1389
306: 1390
307: 1391
308: 1392
309: 1394
310: 1419
311: 1466
312: 1467
313: 1468
314: 1471
315: 1481
316: 1482
317: 1484
318: 1493
319: 1494
320: 1495
321: 1496
322: 1498
323: 1499
324: 1506
325: 1508
326: 1509
327: 1510
328: 1511
329: 1512
330: 1514
331: 1515
332: 1524
333: 1538
334: 1542
335: 1543
336: 1544
337: 1545
338: 1546
339: 1547
340: 1548
341: 1549
342: 1552
343: 1553
344: 1554
345: 1557
346: 1563
347: 1567
348: 1571
349: 1575
350: 1582
351: 1585
352: 1586
353: 1587
354: 1588
355: 1591
356: 1594
357: 1595
358: 1631
359: 1632
360: 1653
361: 1659
362: 1673
363: 1674
364: 1677
365: 1678
366: 1679
367: 1684
368: 1685
369: 1686
370: 1687
371: 1690
372: 1692
373: 1693
374: 1694
375: 1695
376: 1696
377: 1698
378: 1699
379: 1700
380: 1701
381: 1702
382: 1703
383: 1704
384: 1705
385: 1707
386: 1709
387: 1710
388: 1711
389: 1712
390: 1714
391: 1715
392: 1716
393: 1724
394: 1726
395: 1729
396: 1730
397: 1744
398: 1745
399: 1746
400: 1747
401: 1752
402: 1753
403: 1758
404: 1767
405: 1769
406: 1770
407: 1771
408: 1772
409: 1776
410: 1815
411: 1819
412: 1824
413: 1825
414: 1838
415: 1839
416: 1840
417: 1841
418: 1846
419: 1854
420: 1864
421: 1866
422: 1868
423: 1869
424: 1871
425: 1874
426: 1877
427: 1890
428: 1891
429: 1899
430: 1902
431: 1903
432: 1909
433: 1910
434: 1912
435: 1919
436: 1926
437: 1927
438: 1932
439: 1934
440: 1935
441: 1944
442: 1946
443: 1947
444: 1948
445: 1950
446: 1953
447: 1954
448: 1957
449: 1963
450: 1964
451: 1966
452: 1972
453: 1974
454: 1975
455: 1976
456: 1980
457: 1983
458: 1991
459: 1992
460: 1996
461: 2001
462: 2002
463: 2003
464: 2004
465: 2005
466: 2006
467: 2007
468: 2008
469: 2010
470: 2011
471: 2012
472: 2014
473: 2050
474: 2051
475: 2062
476: 2063
477: 2068
478: 2078
479: 2079
480: 2081
481: 2082
482: 2083
483: 2097
484: 2098
485: 2099
486: 2102
487: 2103
488: 2106
489: 2107
490: 2108
491: 2109
492: 2110
493: 2129
494: 2130
495: 2131
496: 2132
497: 2133
498: 2134
499: 2135
500: 2136
501: 2137
502: 2140
503: 2141
504: 2142
505: 2143
506: 2144
507: 2145
508: 2146
509: 2147
510: 2148
511: 2149
512: 2150
513: 2173
514: 2174
515: 2175
516: 2179
517: 2180
518: 2181
519: 2182
520: 2183
521: 2184
522: 2189
523: 2190
524: 2193
525: 2196
526: 2205
527: 2207
528: 2210
529: 2211
530: 2212
531: 2217
532: 2219
533: 2231
534: 2234
535: 2238
536: 2241
537: 2243
538: 2247
539: 2248
540: 2253
541: 2254
542: 2255
543: 2257
544: 2271
545: 2284
546: 2290
547: 2315
548: 2316
549: 2354
550: 2355
551: 2357
552: 2361
553: 2379
554: 2380
555: 2382
556: 2387
557: 2388
558: 2389
559: 2390
560: 2391
561: 2392
562: 2393
563: 2394
564: 2396
565: 2399
566: 2407
567: 2408
568: 2416
569: 2417
570: 2418
571: 2419
572: 2430
573: 2432
574: 2435
575: 2436
576: 2439
577: 2443
578: 2446
579: 2448
580: 2449
581: 2450
582: 2451
583: 2452
584: 2453
585: 2459
586: 2464
587: 2472
588: 2473
589: 2474
590: 2513
591: 2516
592: 2517
593: 2518
594: 2519
595: 2520
596: 2521
597: 2522
598: 2523
599: 2524
600: 2525
601: 2526
602: 2527
603: 2528
604: 2530
605: 2531
606: 2532
607: 2533
608: 2534
609: 2535
610: 2536
611: 2537
612: 2538
613: 2539
614: 2540
615: 2550
616: 2551
617: 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

420μslaravelsettings.php#16

Bindings	0: vacation_add
Backtrace	16. app/Utils/settings.php:16 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

470μslaravelsettings.php#16

Bindings	0: company_name
Backtrace	16. app/Utils/settings.php:16 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

360μslaravelsettings.php#16

Bindings	0: shop_address
Backtrace	16. app/Utils/settings.php:16 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

250μslaravelsettings.php#16

Bindings	0: company_phone
Backtrace	16. app/Utils/settings.php:16 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
260μslaravel
select * from `business_settings` where (`type` = 'bottom_banner') limit 1
360μslaravel
select * from `business_settings` where (`type` = 'offer_banner') limit 1
290μslaravel
select * from `business_settings` where (`type` = 'temporary_close') limit 1
300μslaravel
select * from `business_settings` where (`type` = 'temporary_close') limit 1
350μslaravel
select * from `business_settings` where (`type` = 'shop_banner') limit 1
270μslaravel
select * from `admins` where (`id` = 1) limit 1
340μslaravel
select * from `admins` where (`id` = 1) limit 1
410μslaravel
select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (4, 9, 29, 40, 47, 57, 69, 91, 93, 96, 112, 114, 131, 138, 139, 170, 171, 184, 193, 229, 231, 235, 238, 242, 248, 253, 254, 255, 256, 263, 264, 267, 268, 271, 273, 274, 275, 276, 278, 294, 297, 307, 310, 311, 315, 320, 331, 332, 350, 351, 356, 357, 358, 365, 367, 368, 369, 378, 379, 386, 390, 391, 392, 393, 400, 405, 419, 420, 421, 424, 426, 427, 429, 450, 451, 452, 454, 455, 456, 457, 458, 459, 466, 469, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 527, 533, 535, 539, 545, 546, 547, 548, 549, 550, 551, 571, 573, 576, 581, 582, 583, 584, 591, 651, 657, 660, 663, 692, 693, 694, 695, 696, 697, 698, 720, 727, 731, 733, 734, 735, 736, 737, 749, 750, 753, 754, 758, 759, 762, 763, 765, 767, 768, 769, 782, 783, 785, 788, 792, 800, 807, 819, 820, 832, 833, 834, 835, 838, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 856, 861, 862, 863, 864, 867, 870, 871, 875, 881, 882, 883, 889, 891, 986, 987, 988, 989, 990, 993, 994, 1007, 1009, 1014, 1015, 1019, 1021, 1023, 1024, 1025, 1031, 1032, 1033, 1034, 1035, 1039, 1041, 1042, 1043, 1052, 1053, 1056, 1075, 1078, 1079, 1081, 1086, 1113, 1121, 1123, 1126, 1128, 1132, 1141, 1142, 1143, 1144, 1147, 1148, 1149, 1151, 1152, 1153, 1164, 1172, 1173, 1174, 1175, 1176, 1177, 1225, 1226, 1268, 1269, 1270, 1271, 1285, 1290, 1291, 1292, 1302, 1303, 1304, 1305, 1306, 1313, 1315, 1324, 1330, 1349, 1377, 1378, 1385, 1388, 1389, 1390, 1391, 1392, 1394, 1419, 1466, 1467, 1468, 1471, 1481, 1482, 1484, 1493, 1494, 1495, 1496, 1498, 1499, 1506, 1508, 1509, 1510, 1511, 1512, 1514, 1515, 1524, 1538, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1552, 1553, 1554, 1557, 1563, 1567, 1571, 1575, 1582, 1585, 1586, 1587, 1588, 1591, 1594, 1595, 1631, 1632, 1653, 1659, 1673, 1674, 1677, 1678, 1679, 1684, 1685, 1686, 1687, 1690, 1692, 1693, 1694, 1695, 1696, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1707, 1709, 1710, 1711, 1712, 1714, 1715, 1716, 1724, 1726, 1729, 1730, 1744, 1745, 1746, 1747, 1752, 1753, 1758, 1767, 1769, 1770, 1771, 1772, 1776, 1815, 1819, 1824, 1825, 1838, 1839, 1840, 1841, 1846, 1854, 1864, 1866, 1868, 1869, 1871, 1874, 1877, 1890, 1891, 1899, 1902, 1903, 1909, 1910, 1912, 1919, 1926, 1927, 1932, 1934, 1935, 1944, 1946, 1947, 1948, 1950, 1953, 1954, 1957, 1963, 1964, 1966, 1972, 1974, 1975, 1976, 1980, 1983, 1991, 1992, 1996, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2010, 2011, 2012, 2014, 2050, 2051, 2062, 2063, 2068, 2078, 2079, 2081, 2082, 2083, 2097, 2098, 2099, 2102, 2103, 2106, 2107, 2108, 2109, 2110, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2173, 2174, 2175, 2179, 2180, 2181, 2182, 2183, 2184, 2189, 2190, 2193, 2196, 2205, 2207, 2210, 2211, 2212, 2217, 2219, 2231, 2234, 2238, 2241, 2243, 2247, 2248, 2253, 2254, 2255, 2257, 2271, 2284, 2290, 2315, 2316, 2354, 2355, 2357, 2361, 2379, 2380, 2382, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2396, 2399, 2407, 2408, 2416, 2417, 2418, 2419, 2430, 2432, 2435, 2436, 2439, 2443, 2446, 2448, 2449, 2450, 2451, 2452, 2453, 2459, 2464, 2472, 2473, 2474, 2513, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2527, 2528, 2530, 2531, 2532, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `status` = 1
1.47mslaravel
select count(*) as aggregate from `orders` where (`seller_is` = 'admin')
360μslaravel
select * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
440μslaravel
select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
410μslaravel
select count(*) as aggregate from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`featured` = 1)
6.62mslaravel
select * from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') order by `id` desc limit 8
770μslaravel
select * from `reviews` where `reviews`.`product_id` in (2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `delivery_man_id` is null and `status` = 1
350μslaravel
select * from `translations` where `translations`.`translationable_id` in (2535, 2536, 2537, 2538, 2539, 2540, 2550, 2551) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
530μslaravel
select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
440μslaravel
select count(*) as aggregate from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')
6.34mslaravel
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 (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') order by `order_details_count` desc limit 8 offset 0
30.4mslaravel
select * from `translations` where `translations`.`translationable_id` in (1770, 1771, 1772, 1815, 1819, 1824, 1825, 1838) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
760μslaravel
select * from `reviews` where `reviews`.`product_id` in (1770, 1771, 1772, 1815, 1819, 1824, 1825, 1838) and `delivery_man_id` is null and `status` = 1
350μslaravel
select * from `brands` where `status` = 1 limit 15
370μslaravel
select * from `translations` where `translations`.`translationable_id` in (105, 106, 108, 109, 110, 113, 115, 117, 122, 124, 125, 126, 127, 128, 129) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'kw'
670μslaravel
select `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) group by `product_id` order by `count` desc limit 6
630μslaravel
select `product_id`, AVG(rating) as count from `reviews` where exists (select * from `products` where `reviews`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')) and `status` = 1 group by `product_id` order by `count` desc limit 6
510μslaravel
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
300μslaravel
select * from `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
410μslaravel
select * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
380μslaravel
select * from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') order by RAND() limit 1
19.09mslaravel
select * from `translations` where `translations`.`translationable_id` in (2182) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
600μslaravel
select * from `reviews` where `reviews`.`product_id` in (2182) and `delivery_man_id` is null and `status` = 1
360μslaravel
select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
420μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 23 and `storages`.`data_id` is not null
780μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 22 and `storages`.`data_id` is not null
450μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 21 and `storages`.`data_id` is not null
410μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 20 and `storages`.`data_id` is not null
420μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 19 and `storages`.`data_id` is not null
460μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 18 and `storages`.`data_id` is not null
400μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 17 and `storages`.`data_id` is not null
400μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 16 and `storages`.`data_id` is not null
390μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 15 and `storages`.`data_id` is not null
410μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 14 and `storages`.`data_id` is not null
430μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 13 and `storages`.`data_id` is not null
440μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 12 and `storages`.`data_id` is not null
440μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 8 and `storages`.`data_id` is not null
390μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 7 and `storages`.`data_id` is not null
530μslaravel
select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
410μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 10 and `storages`.`data_id` is not null
430μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 9 and `storages`.`data_id` is not null
370μslaravel
select * from `business_settings` where (`type` = 'company_reliability') limit 1
990μslaravel
select * from `business_settings` where (`type` = 'google_search_console_code') limit 1
450μslaravel
select * from `business_settings` where (`type` = 'bing_webmaster_code') limit 1
280μslaravel
select * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
240μslaravel
select * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
370μslaravel
select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
300μslaravel
select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
290μslaravel
select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 11 and `storages`.`data_id` is not null
360μslaravel
select * from `business_settings` where (`type` = 'announcement') limit 1
240μslaravel
select `cart_group_id` from `carts` where (`customer_id` = 266134 and `is_guest` = 1) group by `cart_group_id`
310μslaravel
select * from `carts` where 0 = 1
200μslaravel
select `cart_group_id` from `carts` where (`customer_id` = 266134 and `is_guest` = 1) group by `cart_group_id`
220μslaravel
select * from `carts` where 0 = 1
200μslaravel
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')) as `product_count` from `categories` where `position` = 0
30.4mslaravel
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 (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')
6.97mslaravel
select * from `translations` where `translations`.`translationable_id` in (2550, 2551) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
380μslaravel
select * from `reviews` where `reviews`.`product_id` in (2550, 2551) and `delivery_man_id` is null and `status` = 1
240μslaravel
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` = 1 order by `priority` asc
104mslaravel
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `position` = 2 order by `priority` asc
98.62mslaravel
select * from `translations` where `translations`.`translationable_id` in (6, 8, 9, 11, 12, 16, 18, 20, 22, 24, 29, 31, 32, 33, 36, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 58, 60, 68, 70, 71, 73, 75, 80, 85, 87, 88, 95, 96, 99, 101, 102, 103, 104, 105, 107, 108, 113, 114, 115, 116, 119, 120, 121, 123, 136, 137, 138, 139, 141, 147, 149, 151, 156) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
1.3mslaravel
select * from `translations` where `translations`.`translationable_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
1.19mslaravel
select * from `translations` where `translations`.`translationable_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
480μslaravel
select * from `business_settings` where (`type` = 'category_list_priority') limit 1
530μslaravel
select count(*) as aggregate from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `discount` != 0
4.57mslaravel
select * from `business_settings` where (`type` = 'loader_gif') limit 1
950μslaravel
select * from `business_settings` where (`type` = 'country_code') limit 1
660μslaravel
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-05-06' and date(`end_date`) >= '2025-05-06' limit 1
580μslaravel
select * from `business_settings` where (`type` = 'refund-policy') limit 1
420μslaravel
select * from `business_settings` where (`type` = 'return-policy') limit 1
340μslaravel
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
310μslaravel
select * from `business_settings` where (`type` = 'company_phone') limit 1
260μslaravel
select * from `business_settings` where (`type` = 'company_email') limit 1
280μslaravel
select * from `business_settings` where (`type` = 'shop_address') limit 1
300μslaravel
select * from `business_settings` where (`type` = 'whatsapp') limit 1
280μslaravel

App\Models\Product: 725Product.php#?
App\Models\Translation: 368Translation.php#?
App\Models\Category: 343Category.php#?
App\Models\BusinessSetting: 50BusinessSetting.php#?
App\Models\Shop: 26Shop.php#?
App\Models\Seller: 26Seller.php#?
App\Models\Storage: 17Storage.php#?
App\Models\Banner: 16Banner.php#?
App\Models\Brand: 15Brand.php#?
App\Models\Admin: 2Admin.php#?

storage_connection_type: public
company_web_logo: array:3 [ "key" => "2024-10-06-6702a7946cf56.webp" "path" => "/storage/company/2024-10-06-6702a7...
decimal_point_settings: 3
product_brand: 0
digital_product: 0
business_mode: single
currency_model: single_currency
language: array:3 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
local: kw
direction: rtl
system_default_currency: 12
system_default_currency_info: App\Models\Currency {#1562 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: KWD
currency_symbol: KWD
currency_exchange_rate: 1
_token: NnOrQLcLIwnkcvahVKVZjZYKGN2ZkCv9pWDEn7w5
guest_id: 266134
_flash: array:2 [ "new" => [] "old" => [] ]
_previous: array:1 [ "url" => "https://mybunyan.com" ]
company_name: سوق بنيان
currency_symbol_position: right
company_email: info@bunyan.shop
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=eyJpdiI6InB1NndNaVoyNjlsRzNnZVFiYy83SGc9PSIsInZhbHVlIjoiNUc2RldKN0VvckxmTnBTemE5enkrTUIweWt4dUZZWUJYTjZ0eC9kNkI5UVM4M1d6bU84R3JKOGNYNGFuYWNNU3Vob0xDQ2RieFRNdUw5NFJiTDhDUDJhY0VPY2JWdThRUXFNM2ZjdE9HeGM0QjlFQ1J4WnNrTlNKL2NSZ1Nqa3EiLCJtYWMiOiJlYzkzN2FiNzUwYTMwMmE1Y2Q4ZTg3ZWI3ZWMxNWIyYmM2NmZjNDU3Mzc2OWQ4OWQzOTlmNDZhNzM5NzUzNzdkIiwidGFnIjoiIn0%3D; 6valley1724088324_session=eyJpdiI6IklzNVZuR2ZYRlFvb2duaFVJT2tGa2c9PSIsInZhbHVlIjoiY1lzaldEd09EZ0tkNmpCRUFRQy9yMWN3VU9QQW1yUlRkaUtmbHVVeExBUzB5QndTblkxYzZjODJNVm9oYkw5UnV4dy9ieTFRTnV0ZStvcXVMK3h1Z3RlSDhqNlpEQmlSZlpMaEhTVzBNSy94WHFvS3g4Rzg5cWJuaG5tVTc4a0giLCJtYWMiOiJkZWJjZDkzNDhiNGY4ZmZmYmFkNjRhOGY2YTgxMTIwN2ViNzBiYjczYjA0NGYzZmMxMjA5MWU5ZDJiZWE2MjVjIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InB1NndNaVoyNjlsRzNnZVFiYy83SGc9PSIsInZhbHVlIjoiNUc2RldKN0VvckxmTnBTemE5enkrTUIweWt4dUZZWUJYTjZ0eC9kNkI5UVM4M1d6bU84R3JKOGNYNGFuYWNNU3Vob0xDQ ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "mybunyan.com"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "NnOrQLcLIwnkcvahVKVZjZYKGN2ZkCv9pWDEn7w5"
  "6valley1724088324_session" => "a1pvvFdPJw0XeR59P1WjmTDbQKiITPultZsX8t1p"
]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 21:42:59 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjNvSStGeFJVdVFHUEdmOXFFd3BUNXc9PSIsInZhbHVlIjoianBqQ05MVnFEc3l6OUJhUWI4akNoOUxJUUdhU2NQeVh0aThDSGltRlVGSk1HWEpBZjdidkFFbm5ENmNMbUZxWlk5OU9wK3grVGE4TGh4SmNjQXZEMlVqSzV1SU1SUGF4d29IK3N2ZDNyaTZCcjF1M012NitoV09BaTh6VUZGRXEiLCJtYWMiOiIwNWFiZDllZmY3NjMxYjNiOTcyOTQ1MGVkNjc4OTVkNjdhODZiMWE0MjM3NTc4YjVmY2RlZmJkMjI3OGI1ZTM1IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 22:43:00 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IjNvSStGeFJVdVFHUEdmOXFFd3BUNXc9PSIsInZhbHVlIjoianBqQ05MVnFEc3l6OUJhUWI4akNoOUxJUUdhU2NQeVh0aThDSGltRlVGSk1HWEpBZjdidkFFbm5ENmNMbUZxWlk5OU9wK ▶"
    1 => "6valley1724088324_session=eyJpdiI6IlpsVWxDUUlTek9zeUc3a05hb1ljalE9PSIsInZhbHVlIjoiL0NHRzBVdkNaN2R3VjNwVFZMNjBTbWJTOU5BZ3paTEFMTFZHSHVQLy9zSkx1LzIza1YzcTJIcWpUL2NDNzBjdnFqV3h0Q25HSGtjbkVZdytMMklGR0srVTJTRmljT25NcmFrRXBSWldXQ0xSbnBpWWJVM2d5cGI3dkplMHRSbXUiLCJtYWMiOiIxMzAwNjY0OGRjNDQ2YjlhYzU5N2UwNzE3MzNiNGViMzhlMjQ3MTIwOWQyYjc0NjlmOTM5Y2JjODdmYjRkOWY5IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 22:43:00 GMT; Max-Age=3600; path=/; httponly ◀6valley1724088324_session=eyJpdiI6IlpsVWxDUUlTek9zeUc3a05hb1ljalE9PSIsInZhbHVlIjoiL0NHRzBVdkNaN2R3VjNwVFZMNjBTbWJTOU5BZ3paTEFMTFZHSHVQLy9zSkx1LzIza1YzcTJIcWpUL2 ▶"
    2 => "popup_banner=eyJpdiI6Ik5IVTNhY0FJanc1QVk2NEVYWVR5RlE9PSIsInZhbHVlIjoiTFdZaEdGbXZXckRJVTRkOTNzU3ZLQ0xMMWZ5RWRsUVdxRVR1R0RldWsxb1RUZ09zTGoxQWpmb09VTEN4b01yMCIsIm1hYyI6IjEwM2Y4Yjg0ZDliNGM1Y2E2OTVmN2M0NDQ2MmZjMGNlYmRlM2YzYmExMzY1ZjllNTBjNzI0MzIwZGY0MjI2MTIiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 05 May 2025 21:44:00 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6Ik5IVTNhY0FJanc1QVk2NEVYWVR5RlE9PSIsInZhbHVlIjoiTFdZaEdGbXZXckRJVTRkOTNzU3ZLQ0xMMWZ5RWRsUVdxRVR1R0RldWsxb1RUZ09zTGoxQWpmb09VTEN4b01yMCIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjNvSStGeFJVdVFHUEdmOXFFd3BUNXc9PSIsInZhbHVlIjoianBqQ05MVnFEc3l6OUJhUWI4akNoOUxJUUdhU2NQeVh0aThDSGltRlVGSk1HWEpBZjdidkFFbm5ENmNMbUZxWlk5OU9wK3grVGE4TGh4SmNjQXZEMlVqSzV1SU1SUGF4d29IK3N2ZDNyaTZCcjF1M012NitoV09BaTh6VUZGRXEiLCJtYWMiOiIwNWFiZDllZmY3NjMxYjNiOTcyOTQ1MGVkNjc4OTVkNjdhODZiMWE0MjM3NTc4YjVmY2RlZmJkMjI3OGI1ZTM1IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 22:43:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjNvSStGeFJVdVFHUEdmOXFFd3BUNXc9PSIsInZhbHVlIjoianBqQ05MVnFEc3l6OUJhUWI4akNoOUxJUUdhU2NQeVh0aThDSGltRlVGSk1HWEpBZjdidkFFbm5ENmNMbUZxWlk5OU9wK ▶"
    1 => "6valley1724088324_session=eyJpdiI6IlpsVWxDUUlTek9zeUc3a05hb1ljalE9PSIsInZhbHVlIjoiL0NHRzBVdkNaN2R3VjNwVFZMNjBTbWJTOU5BZ3paTEFMTFZHSHVQLy9zSkx1LzIza1YzcTJIcWpUL2NDNzBjdnFqV3h0Q25HSGtjbkVZdytMMklGR0srVTJTRmljT25NcmFrRXBSWldXQ0xSbnBpWWJVM2d5cGI3dkplMHRSbXUiLCJtYWMiOiIxMzAwNjY0OGRjNDQ2YjlhYzU5N2UwNzE3MzNiNGViMzhlMjQ3MTIwOWQyYjc0NjlmOTM5Y2JjODdmYjRkOWY5IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 22:43:00 GMT; path=/; httponly ◀6valley1724088324_session=eyJpdiI6IlpsVWxDUUlTek9zeUc3a05hb1ljalE9PSIsInZhbHVlIjoiL0NHRzBVdkNaN2R3VjNwVFZMNjBTbWJTOU5BZ3paTEFMTFZHSHVQLy9zSkx1LzIza1YzcTJIcWpUL2 ▶"
    2 => "popup_banner=eyJpdiI6Ik5IVTNhY0FJanc1QVk2NEVYWVR5RlE9PSIsInZhbHVlIjoiTFdZaEdGbXZXckRJVTRkOTNzU3ZLQ0xMMWZ5RWRsUVdxRVR1R0RldWsxb1RUZ09zTGoxQWpmb09VTEN4b01yMCIsIm1hYyI6IjEwM2Y4Yjg0ZDliNGM1Y2E2OTVmN2M0NDQ2MmZjMGNlYmRlM2YzYmExMzY1ZjllNTBjNzI0MzIwZGY0MjI2MTIiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 05-May-2025 21:44:00 GMT; path=/; httponly ◀popup_banner=eyJpdiI6Ik5IVTNhY0FJanc1QVk2NEVYWVR5RlE9PSIsInZhbHVlIjoiTFdZaEdGbXZXckRJVTRkOTNzU3ZLQ0xMMWZ5RWRsUVdxRVR1R0RldWsxb1RUZ09zTGoxQWpmb09VTEN4b01yMCIsIm1 ▶"
  ]
]

session_attributes

  0 of 0   
array:23 [▼
  "storage_connection_type" => "public"
  "company_web_logo" => array:3 [▶
    "key" => "2024-10-06-6702a7946cf56.webp"
    "path" => "/storage/company/2024-10-06-6702a7946cf56.webp"
    "status" => 200
  ]
  "decimal_point_settings" => 3
  "product_brand" => 0
  "digital_product" => 0
  "business_mode" => "single"
  "currency_model" => "single_currency"
  "language" => array:3 [▶
    0 => array:6 [▶
      "id" => "1"
      "name" => "english"
      "direction" => "ltr"
      "code" => "en"
      "status" => 1
      "default" => false
    ]
    1 => array:6 [▶
      "id" => 2
      "name" => "Arabic"
      "direction" => "rtl"
      "code" => "ae"
      "status" => 0
      "default" => false
    ]
    2 => array:6 [▶
      "id" => 3
      "name" => "العربية"
      "direction" => "rtl"
      "code" => "kw"
      "status" => 1
      "default" => true
    ]
  ]
  "local" => "kw"
  "direction" => "rtl"
  "system_default_currency" => 12
  "system_default_currency_info" => App\Models\Currency {#1562 ▶
    #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" => 12
      "name" => "Kwait dainar"
      "symbol" => "KWD"
      "code" => "KWD"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2021-06-27 13:39:37"
      "updated_at" => "2021-06-27 13:39:37"
    ]
    #original: array:8 [▶
      "id" => 12
      "name" => "Kwait dainar"
      "symbol" => "KWD"
      "code" => "KWD"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2021-06-27 13:39:37"
      "updated_at" => "2021-06-27 13:39:37"
    ]
    #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" => "KWD"
  "currency_symbol" => "KWD"
  "currency_exchange_rate" => "1"
  "_token" => "NnOrQLcLIwnkcvahVKVZjZYKGN2ZkCv9pWDEn7w5"
  "guest_id" => 266134
  "_flash" => array:2 [▶
    "new" => []
    "old" => []
  ]
  "_previous" => array:1 [▶
    "url" => "https://mybunyan.com"
  ]
  "company_name" => "سوق بنيان"
  "currency_symbol_position" => "right"
  "company_email" => "info@bunyan.shop"
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 00:43:00	GET	/	55 172 183 1588

1 x Application (93.46%)	1.34s
1 x Booting (6.54%)	93.74ms

السلة