Welcome To Autocart Home

Messages10 Timeline Exceptions Views76 Route Queries128 Models924 Mails Gate Session Request

Request history8.2.181.38s21MBGET /

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

Booting (112ms)time
Application (1.27s)time
1 x Application (91.86%)
1.27s
1 x Booting (8.13%)
112ms

76 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._top-sellers_top-sellers.blade.php#?blade
1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
8x web-views.partials._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
4x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
46x 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
prefix
where
as: home
file: app/Http/Controllers/Web/HomeController.php:49-58

128 statements were executed, 16 of which were duplicates, 112 unique. Show only duplicated392ms

# Query soft limit for Debugbar is reached after 100 queries, additional 28 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

1.03msdarelkha_aaahelpers.php#167

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

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')) as `product_count` from `categories` where `position` = 0

3.39msdarelkha_aaacategory-manager.php#82

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 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 (1, 4, 5, 88) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')

12.02msdarelkha_aaacategory-manager.php#82

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

4.05msdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Product 1: en
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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `delivery_man_id` is null and `status` = 1

4.29msdarelkha_aaacategory-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 (1, 4, 5, 88) and `position` = 1 order by `priority` asc

4msdarelkha_aaacategory-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, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 20, 22, 23, 24, 33, 53, 56, 62, 68, 74, 75, 86) and `position` = 2 order by `priority` asc

3.61msdarelkha_aaacategory-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 (36, 37, 38, 39, 46, 47, 48, 49, 51, 52, 54, 57, 58, 59, 60, 61, 63, 69, 76, 81, 87) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

550μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
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, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 20, 22, 23, 24, 33, 53, 56, 62, 68, 74, 75, 86) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

420μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
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 (1, 4, 5, 88) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

360μsdarelkha_aaacategory-manager.php#82

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

390μsdarelkha_aaasettings.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-01' and date(`end_date`) >= '2025-05-01' limit 1

390μsdarelkha_aaaproduct-manager.php#1318

Bindings	0: flash_deal 1: 1 2: 2025-05-01 3: 2025-05-01
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

330μsdarelkha_aaaHomeController.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

340μsdarelkha_aaaHomeController.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 (1, 4, 5, 88) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

1.16msdarelkha_aaaHomeController.php#68

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

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

390μsdarelkha_aaasettings.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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"88\"%'

2.25msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: %"88"%
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

1.16msdarelkha_aaasettings.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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"5\"%'

3.26msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: %"5"%
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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"5\"%' order by `order_details_count` desc limit 12 offset 0

13.59msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: 1 6: approved 7: admin 8: 1 9: digital 10: physical 11: %"5"%
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 (59, 60, 89, 90, 91, 92, 93, 94, 95, 96) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

630μsdarelkha_aaaproduct-manager.php#1144

Bindings	0: App\Models\Product 1: en
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 (59, 60, 89, 90, 91, 92, 93, 94, 95, 96) and `delivery_man_id` is null and `status` = 1

430μsdarelkha_aaaproduct-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

590μsdarelkha_aaasettings.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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"4\"%'

2.66msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: %"4"%
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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"4\"%' order by `order_details_count` desc limit 12 offset 0

5.19msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: 1 6: approved 7: admin 8: 1 9: digital 10: physical 11: %"4"%
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 (61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

680μsdarelkha_aaaproduct-manager.php#1144

Bindings	0: App\Models\Product 1: en
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 (61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73) and `delivery_man_id` is null and `status` = 1

510μsdarelkha_aaaproduct-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

570μsdarelkha_aaasettings.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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"1\"%'

2.44msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: %"1"%
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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `category_ids` like '%\"1\"%' order by `order_details_count` desc limit 12 offset 0

18.41msdarelkha_aaaproduct-manager.php#1144

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: 1 6: approved 7: admin 8: 1 9: digital 10: physical 11: %"1"%
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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

840μsdarelkha_aaaproduct-manager.php#1144

Bindings	0: App\Models\Product 1: en
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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 14) and `delivery_man_id` is null and `status` = 1

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

2.51msdarelkha_aaaHomeController.php#90

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 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 (3, 4)

22.5msdarelkha_aaaHomeController.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 (3, 4) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')

17.15msdarelkha_aaaHomeController.php#90

Bindings	0: seller 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 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 * from `reviews` where `reviews`.`product_id` in (127, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `delivery_man_id` is null and `status` = 1

1.66msdarelkha_aaaHomeController.php#90

Bindings	0: 1
Backtrace	30. app/Http/Controllers/Web/HomeController.php:90 31. app/Http/Controllers/Web/HomeController.php:53 32. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 33. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `translations` where `translations`.`translationable_id` in (127, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

1.22msdarelkha_aaaHomeController.php#90

Bindings	0: App\Models\Product 1: en
Backtrace	30. app/Http/Controllers/Web/HomeController.php:90 31. app/Http/Controllers/Web/HomeController.php:53 32. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 33. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 34. 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 exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and (`added_by` = 'admin')

8.47msdarelkha_aaaHomeController.php#108

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `delivery_man_id` is null and `status` = 1

760μsdarelkha_aaaHomeController.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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `status` = 1 group by `product_id`

670μsdarelkha_aaaHomeController.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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

1.05msdarelkha_aaaHomeController.php#108

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

select count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `status` = 1

650μsdarelkha_aaaHomeController.php#112

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 13
13: 14
14: 15
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 24
22: 25
23: 26
24: 27
25: 28
26: 29
27: 30
28: 31
29: 32
30: 33
31: 34
32: 35
33: 36
34: 37
35: 38
36: 39
37: 40
38: 41
39: 42
40: 43
41: 44
42: 45
43: 48
44: 49
45: 50
46: 51
47: 52
48: 53
49: 54
50: 55
51: 56
52: 57
53: 58
54: 59
55: 60
56: 61
57: 62
58: 63
59: 64
60: 65
61: 66
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 76
71: 77
72: 78
73: 79
74: 80
75: 81
76: 82
77: 83
78: 84
79: 85
80: 86
81: 89
82: 90
83: 91
84: 92
85: 93
86: 94
87: 95
88: 96
89: 107
90: 126
91: 128
92: 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 (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `status` = 1

2.34msdarelkha_aaaHomeController.php#114

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 13
13: 14
14: 15
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 24
22: 25
23: 26
24: 27
25: 28
26: 29
27: 30
28: 31
29: 32
30: 33
31: 34
32: 35
33: 36
34: 37
35: 38
36: 39
37: 40
38: 41
39: 42
40: 43
41: 44
42: 45
43: 48
44: 49
45: 50
46: 51
47: 52
48: 53
49: 54
50: 55
51: 56
52: 57
53: 58
54: 59
55: 60
56: 61
57: 62
58: 63
59: 64
60: 65
61: 66
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 76
71: 77
72: 78
73: 79
74: 80
75: 81
76: 82
77: 83
78: 84
79: 85
80: 86
81: 89
82: 90
83: 91
84: 92
85: 93
86: 94
87: 95
88: 96
89: 107
90: 126
91: 128
92: 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

720μsdarelkha_aaasettings.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

1.15msdarelkha_aaasettings.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

620μsdarelkha_aaasettings.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

340μsdarelkha_aaasettings.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

640μsdarelkha_aaasettings.php#16

Bindings	0: company_fav_icon
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` = 'bottom_banner') limit 1

620μsdarelkha_aaasettings.php#16

Bindings	0: bottom_banner
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` = 'offer_banner') limit 1

990μsdarelkha_aaasettings.php#16

Bindings	0: offer_banner
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` = 'temporary_close') limit 1

440μsdarelkha_aaasettings.php#16

Bindings	0: temporary_close
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` = 'temporary_close') limit 1

400μsdarelkha_aaasettings.php#16

Bindings	0: temporary_close
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_banner') limit 1

410μsdarelkha_aaasettings.php#16

Bindings	0: shop_banner
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 `admins` where (`id` = 1) limit 1

41.86msdarelkha_aaaInHouseTrait.php#43

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

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

500μsdarelkha_aaaInHouseTrait.php#43

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

select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 128) and `status` = 1

600μsdarelkha_aaaHomeController.php#123

Bindings

0: 1
1: 1
2: 2
3: 3
4: 4
5: 5
6: 6
7: 8
8: 9
9: 10
10: 11
11: 12
12: 13
13: 14
14: 15
15: 18
16: 19
17: 20
18: 21
19: 22
20: 23
21: 24
22: 25
23: 26
24: 27
25: 28
26: 29
27: 30
28: 31
29: 32
30: 33
31: 34
32: 35
33: 36
34: 37
35: 38
36: 39
37: 40
38: 41
39: 42
40: 43
41: 44
42: 45
43: 48
44: 49
45: 50
46: 51
47: 52
48: 53
49: 54
50: 55
51: 56
52: 57
53: 58
54: 59
55: 60
56: 61
57: 62
58: 63
59: 64
60: 65
61: 66
62: 68
63: 69
64: 70
65: 71
66: 72
67: 73
68: 74
69: 75
70: 76
71: 77
72: 78
73: 79
74: 80
75: 81
76: 82
77: 83
78: 84
79: 85
80: 86
81: 89
82: 90
83: 91
84: 92
85: 93
86: 94
87: 95
88: 96
89: 107
90: 126
91: 128
92: 1

Backtrace

16. app/Http/Controllers/Web/HomeController.php:123
17. app/Http/Controllers/Web/HomeController.php:53
18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select count(*) as aggregate from `orders` where (`seller_is` = 'admin')

1.08msdarelkha_aaaHomeController.php#125

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

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

700μsdarelkha_aaasettings.php#16

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

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

700μsdarelkha_aaasettings.php#16

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

select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and (`featured` = 1)

2.45msdarelkha_aaaproduct-manager.php#836

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

select * from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') order by `id` desc limit 8

4.51msdarelkha_aaaHomeController.php#132

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

select * from `reviews` where `reviews`.`product_id` in (260, 261, 262, 263, 264, 265, 266, 267) and `delivery_man_id` is null and `status` = 1

360μsdarelkha_aaaHomeController.php#132

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

select * from `translations` where `translations`.`translationable_id` in (260, 261, 262, 263, 264, 265, 266, 267) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

1.44msdarelkha_aaaHomeController.php#132

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

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

1.2msdarelkha_aaasettings.php#16

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

select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')

6.48msdarelkha_aaaproduct-manager.php#1064

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

select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') order by `order_details_count` desc limit 8 offset 0

20.17msdarelkha_aaaproduct-manager.php#1064

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

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 14, 59, 60, 89, 93) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

500μsdarelkha_aaaproduct-manager.php#1064

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

select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 14, 59, 60, 89, 93) and `delivery_man_id` is null and `status` = 1

330μsdarelkha_aaaproduct-manager.php#1064

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

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

350μsdarelkha_aaaHomeController.php#135

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

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'

340μsdarelkha_aaaHomeController.php#135

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

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

1.12msdarelkha_aaaHomeController.php#145

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

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

2.38msdarelkha_aaaHomeController.php#145

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

select * from `products` where `status` = 1 and `products`.`id` in (1, 2, 3, 59, 89, 93)

1.38msdarelkha_aaaHomeController.php#145

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

select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 59, 89, 93) and `delivery_man_id` is null and `status` = 1

340μsdarelkha_aaaHomeController.php#145

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

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 59, 89, 93) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

480μsdarelkha_aaaHomeController.php#145

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

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

1.74msdarelkha_aaaHomeController.php#155

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

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

32.27msdarelkha_aaaHomeController.php#165

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

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

450μsdarelkha_aaaHomeController.php#166

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

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

310μsdarelkha_aaaHomeController.php#167

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

select * from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') order by RAND() limit 1

8.81msdarelkha_aaaHomeController.php#169

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

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

450μsdarelkha_aaaHomeController.php#169

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

select * from `reviews` where `reviews`.`product_id` in (135) and `delivery_man_id` is null and `status` = 1

290μsdarelkha_aaaHomeController.php#169

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

select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc

300μsdarelkha_aaaHomeController.php#170

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

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

810μsdarelkha_aaaBanner.php#61

Bindings	0: App\Models\Banner 1: 3
Backtrace	20. app/Models/Banner.php:61 26. view::web-views.partials._home-top-slider:45 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

740μsdarelkha_aaaBanner.php#61

Bindings	0: App\Models\Banner 1: 2
Backtrace	20. app/Models/Banner.php:61 26. view::web-views.partials._home-top-slider:45 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

540μsdarelkha_aaaBanner.php#61

Bindings	0: App\Models\Banner 1: 1
Backtrace	20. app/Models/Banner.php:61 26. view::web-views.partials._home-top-slider:45 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

710μsdarelkha_aaasettings.php#16

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

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

320μsdarelkha_aaasettings.php#16

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

select * from `currencies` where (`code` = 'USD') limit 1

490μsdarelkha_aaacurrency.php#92

Bindings	0: USD
Backtrace	16. app/Utils/currency.php:92 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

760μsdarelkha_aaasettings.php#16

Bindings	0: currency_symbol_position
Backtrace	16. app/Utils/settings.php:16 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 24. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

990μsdarelkha_aaasettings.php#16

Bindings	0: company_reliability
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

1.82msdarelkha_aaasettings.php#16

Bindings	0: google_search_console_code
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

630μsdarelkha_aaasettings.php#16

Bindings	0: bing_webmaster_code
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

620μsdarelkha_aaasettings.php#16

Bindings	0: baidu_webmaster_code
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

570μsdarelkha_aaasettings.php#16

Bindings	0: yandex_webmaster_code
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

1.35msdarelkha_aaasettings.php#16

Bindings	0: google_tag_manager_id
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

790μsdarelkha_aaasettings.php#16

Bindings	0: pixel_analytics
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

530μsdarelkha_aaasettings.php#16

Bindings	0: announcement
Backtrace	16. app/Utils/settings.php:16 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 22. vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `currencies` where `status` = 1

400μsdarelkha_aaa_header.blade.php#39

Bindings	0: 1
Backtrace	15. view::layouts.front-end.partials._header:39 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 20. vendor/laravel/framework/src/Illuminate/View/View.php:207

select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `status` = 1) and (`customer_id` = 61912 and `is_guest` = 1) group by `cart_group_id`

1.77msdarelkha_aaacart-manager.php#100

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1 9: 61912 10: 1
Backtrace	14. app/Utils/cart-manager.php:100 15. app/Utils/cart-manager.php:57 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 17. app/Utils/cart-manager.php:56 18. view::layouts.front-end.partials._cart:5

select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `status` = 1) and 0 = 1
780μsdarelkha_aaa
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `status` = 1) and (`customer_id` = 61912 and `is_guest` = 1) group by `cart_group_id`
800μsdarelkha_aaa
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `status` = 1) and 0 = 1
570μsdarelkha_aaa
select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')) as `product_count` from `categories` where `position` = 0
6.57msdarelkha_aaa
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 (1, 4, 5, 88) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')
34.6msdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
1.08msdarelkha_aaa
select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 89, 90, 91, 92, 93, 94, 95, 96, 107, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 209, 210, 211, 212, 214, 215, 216, 217, 218, 219, 221, 222, 223, 224, 225, 226, 228, 229, 230, 231, 232, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267) and `delivery_man_id` is null and `status` = 1
1.42msdarelkha_aaa
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 (1, 4, 5, 88) and `position` = 1 order by `priority` asc
9.16msdarelkha_aaa
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, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 20, 22, 23, 24, 33, 53, 56, 62, 68, 74, 75, 86) and `position` = 2 order by `priority` asc
3.87msdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (36, 37, 38, 39, 46, 47, 48, 49, 51, 52, 54, 57, 58, 59, 60, 61, 63, 69, 76, 81, 87) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
510μsdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 20, 22, 23, 24, 33, 53, 56, 62, 68, 74, 75, 86) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
840μsdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (1, 4, 5, 88) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
330μsdarelkha_aaa
select * from `business_settings` where (`type` = 'category_list_priority') limit 1
430μsdarelkha_aaa
select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
580μsdarelkha_aaa
select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
8.5msdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
600μsdarelkha_aaa
select count(*) as aggregate from `products` where exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 ('digital', 'physical') and `discount` != 0
3msdarelkha_aaa
select * from `business_settings` where (`type` = 'seller_registration') limit 1
420μsdarelkha_aaa
select * from `business_settings` where (`type` = 'loader_gif') limit 1
4.11msdarelkha_aaa
select * from `business_settings` where (`type` = 'country_code') limit 1
660μsdarelkha_aaa
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-05-01' and date(`end_date`) >= '2025-05-01' limit 1
7.15msdarelkha_aaa
select * from `business_settings` where (`type` = 'refund-policy') limit 1
600μsdarelkha_aaa
select * from `business_settings` where (`type` = 'return-policy') limit 1
460μsdarelkha_aaa
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
460μsdarelkha_aaa
select * from `business_settings` where (`type` = 'company_phone') limit 1
430μsdarelkha_aaa
select * from `business_settings` where (`type` = 'company_email') limit 1
310μsdarelkha_aaa
select * from `business_settings` where (`type` = 'shop_address') limit 1
420μsdarelkha_aaa
select * from `business_settings` where (`type` = 'whatsapp') limit 1
450μsdarelkha_aaa

App\Models\Product: 729Product.php#?
App\Models\Category: 100Category.php#?
App\Models\BusinessSetting: 38BusinessSetting.php#?
App\Models\Brand: 37Brand.php#?
App\Models\OrderDetail: 6OrderDetail.php#?
App\Models\Banner: 3Banner.php#?
App\Models\Storage: 3Storage.php#?
App\Models\Shop: 2Shop.php#?
App\Models\Seller: 2Seller.php#?
App\Models\Admin: 2Admin.php#?
App\Models\Currency: 2Currency.php#?

storage_connection_type: public
company_web_logo: array:3 [ "key" => "2024-09-11-66e0c5e7cfde3.webp" "path" => "https://autocartstore.com/storage/...
decimal_point_settings: 2
product_brand: 1
digital_product: 1
business_mode: multi
currency_model: multi_currency
language: array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
local: en
direction: ltr
system_default_currency: 9
system_default_currency_info: App\Models\Currency {#3602 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: EGP
currency_symbol: EGP
currency_exchange_rate: 1
_token: mKPuka1g6BymIW0nYibd2d99tLVamdE12lPkcgtA
guest_id: 61912
_flash: array:2 [ "new" => [] "old" => [] ]
_previous: array:1 [ "url" => "https://autocartstore.com" ]
company_name: Autocart
usd: 0.019665683382498
currency_symbol_position: left
company_email: info@autocartstore.com
PHPDEBUGBAR_STACK_DATA: []

path_info

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▼
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "content-length" => array:1 [▶
    0 => "0"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVhaG1vVzc1WWNTNkNiZklrVytUSmc9PSIsInZhbHVlIjoiYkxjbW5icWJub2ZZcmp5TGgxRThVVWlXeUNuTEJzSTFGaCtiTE5pVUFabGl2ejRRUXg2OE9taU0zZ2ROVHhWcE9iR1pFVEFQTGNZMW1RK3RLbStlMmhSdTR6OENjK2JpV3AycUxrcENGTjljOW5OUnNGY0xpT0tkenBaMXRqUXciLCJtYWMiOiIwOTM2OTA1ZDRhNTM0ZWYzZjgzMDJiNTNkOWQ2YWI5YjMyNDY2OTNjMGVlNDU4OTY5YTlmYTJjYTExMTMwMjRlIiwidGFnIjoiIn0%3D; 6valley1725977827_session=eyJpdiI6Im5MVDFSM0lWSXJPWGhTWmhaNVVSSkE9PSIsInZhbHVlIjoiejl2SjFIR1Y3UDk4VDlRbmpPMDVldTRUMWNpK2lTM1JaNEpnSTRrSDhKYmVlQzIzczh6K3BGajlGZGpMdkY2NzZzQm9ZS1EzeDJud3M2SWcvSWxhcmZ5cDRqV3NYTHFpV3NYTmNESGJmaFhmYWdXWUx2U0QrUnBwWSszaGVpNHYiLCJtYWMiOiJhOTgxMWFmYWM2YTc0NTQ1NTY0YWQ2NmJlYjJjN2ZiOTgyMDA3YTMxZjZjNjRhZDdmYzIxYTkxYjlmOWI5NzcwIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImVhaG1vVzc1WWNTNkNiZklrVytUSmc9PSIsInZhbHVlIjoiYkxjbW5icWJub2ZZcmp5TGgxRThVVWlXeUNuTEJzSTFGaCtiTE5pVUFabGl2ejRRUXg2OE9taU0zZ2ROVHhWcE9iR1pFV ▶"
  ]
  "host" => array:1 [▶
    0 => "autocartstore.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-https" => array:1 [▶
    0 => "1"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "mKPuka1g6BymIW0nYibd2d99tLVamdE12lPkcgtA"
  "6valley1725977827_session" => "UnKVZFu1rHpYo0u1RNkXAQHRm2uTDEPgdpRAq9Fc"
]

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 => "Thu, 01 May 2025 06:46:31 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVCYUlOMTUwOVFGQTIrTWp5ZE1WNEE9PSIsInZhbHVlIjoiV2VVTjBqcGZNVEpKTlQ4WitmaGw4TzVYYnRGNVMwWlRCajRWL1E1UEhQRnhPZ2FNYnF3VjBjWTF5WEZQVmhpQ3JrN3h0VEdFbmw0ZDEvRnAwL21ZNjFGNmQ4MCtYaWRUY2szWE5rNS85dFMyL0dyVUJLT1JhYURSNXdsb1NZakUiLCJtYWMiOiJmNWY2MmIxNjY4ZmJkNjM5ZTg1YWJjOTMwMjNjZTQxODM1YzlkOTgyNGM5YmJkYjMzZTZmNTg5ZmFmNDZmOWU0IiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 07:46:32 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVCYUlOMTUwOVFGQTIrTWp5ZE1WNEE9PSIsInZhbHVlIjoiV2VVTjBqcGZNVEpKTlQ4WitmaGw4TzVYYnRGNVMwWlRCajRWL1E1UEhQRnhPZ2FNYnF3VjBjWTF5WEZQVmhpQ3JrN3h0V ▶"
    1 => "6valley1725977827_session=eyJpdiI6InRuVTNKaTRaaTNFdFM1NjdQM3l4b3c9PSIsInZhbHVlIjoiSWVYa2Y0S0J5OUZqRWMyS0puRHk0TmpEQ3ZVSGZBR2tlM0ltV0JJOEZ1MW9JV2Vldy93QUIzKzdmelg4R21OWmRoTjE2aURBUCtFbTdUcW9XcE92WUxDUkZiTDZwMUxSMzR4MVJFZUd6V3ZIelZFLy93cFdzbXkrbGZoMnZRMW0iLCJtYWMiOiI1YmFhZDYzNzY0MzFlMTkxMmRjZmIxMmY0MGYwNmJiMTJjYzdiY2FjNjg0ZjMzYjI5MTlkMjVhOWQ2ZjMxMTAyIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 07:46:32 GMT; Max-Age=3600; path=/; httponly ◀6valley1725977827_session=eyJpdiI6InRuVTNKaTRaaTNFdFM1NjdQM3l4b3c9PSIsInZhbHVlIjoiSWVYa2Y0S0J5OUZqRWMyS0puRHk0TmpEQ3ZVSGZBR2tlM0ltV0JJOEZ1MW9JV2Vldy93QUIzKzdmel ▶"
    2 => "popup_banner=eyJpdiI6ImRuVHFBNmRCSXBGemtQcE93ZVJTZ2c9PSIsInZhbHVlIjoiTEhLVi9Eb256NzYvbVBaeTNvY2c1c2dpN3VYMWJwY0tHa1Rodk1KV3ViT00wTEZaNnRaSThldFhRTkFhTFB1TCIsIm1hYyI6IjMwM2JlOGYxYmI2NzE2ODk0NjgyYjk2N2E4MTA1MzllNWVhNDlkZGU4MjFjNjZhYWMxMjMyNmM3MWU3OGFlZTAiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 01 May 2025 06:47:32 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6ImRuVHFBNmRCSXBGemtQcE93ZVJTZ2c9PSIsInZhbHVlIjoiTEhLVi9Eb256NzYvbVBaeTNvY2c1c2dpN3VYMWJwY0tHa1Rodk1KV3ViT00wTEZaNnRaSThldFhRTkFhTFB1TCIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVCYUlOMTUwOVFGQTIrTWp5ZE1WNEE9PSIsInZhbHVlIjoiV2VVTjBqcGZNVEpKTlQ4WitmaGw4TzVYYnRGNVMwWlRCajRWL1E1UEhQRnhPZ2FNYnF3VjBjWTF5WEZQVmhpQ3JrN3h0VEdFbmw0ZDEvRnAwL21ZNjFGNmQ4MCtYaWRUY2szWE5rNS85dFMyL0dyVUJLT1JhYURSNXdsb1NZakUiLCJtYWMiOiJmNWY2MmIxNjY4ZmJkNjM5ZTg1YWJjOTMwMjNjZTQxODM1YzlkOTgyNGM5YmJkYjMzZTZmNTg5ZmFmNDZmOWU0IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 07:46:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVCYUlOMTUwOVFGQTIrTWp5ZE1WNEE9PSIsInZhbHVlIjoiV2VVTjBqcGZNVEpKTlQ4WitmaGw4TzVYYnRGNVMwWlRCajRWL1E1UEhQRnhPZ2FNYnF3VjBjWTF5WEZQVmhpQ3JrN3h0V ▶"
    1 => "6valley1725977827_session=eyJpdiI6InRuVTNKaTRaaTNFdFM1NjdQM3l4b3c9PSIsInZhbHVlIjoiSWVYa2Y0S0J5OUZqRWMyS0puRHk0TmpEQ3ZVSGZBR2tlM0ltV0JJOEZ1MW9JV2Vldy93QUIzKzdmelg4R21OWmRoTjE2aURBUCtFbTdUcW9XcE92WUxDUkZiTDZwMUxSMzR4MVJFZUd6V3ZIelZFLy93cFdzbXkrbGZoMnZRMW0iLCJtYWMiOiI1YmFhZDYzNzY0MzFlMTkxMmRjZmIxMmY0MGYwNmJiMTJjYzdiY2FjNjg0ZjMzYjI5MTlkMjVhOWQ2ZjMxMTAyIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 07:46:32 GMT; path=/; httponly ◀6valley1725977827_session=eyJpdiI6InRuVTNKaTRaaTNFdFM1NjdQM3l4b3c9PSIsInZhbHVlIjoiSWVYa2Y0S0J5OUZqRWMyS0puRHk0TmpEQ3ZVSGZBR2tlM0ltV0JJOEZ1MW9JV2Vldy93QUIzKzdmel ▶"
    2 => "popup_banner=eyJpdiI6ImRuVHFBNmRCSXBGemtQcE93ZVJTZ2c9PSIsInZhbHVlIjoiTEhLVi9Eb256NzYvbVBaeTNvY2c1c2dpN3VYMWJwY0tHa1Rodk1KV3ViT00wTEZaNnRaSThldFhRTkFhTFB1TCIsIm1hYyI6IjMwM2JlOGYxYmI2NzE2ODk0NjgyYjk2N2E4MTA1MzllNWVhNDlkZGU4MjFjNjZhYWMxMjMyNmM3MWU3OGFlZTAiLCJ0YWciOiIifQ%3D%3D; expires=Thu, 01-May-2025 06:47:32 GMT; path=/; httponly ◀popup_banner=eyJpdiI6ImRuVHFBNmRCSXBGemtQcE93ZVJTZ2c9PSIsInZhbHVlIjoiTEhLVi9Eb256NzYvbVBaeTNvY2c1c2dpN3VYMWJwY0tHa1Rodk1KV3ViT00wTEZaNnRaSThldFhRTkFhTFB1TCIsIm1 ▶"
  ]
]

session_attributes

  0 of 0   
array:24 [▼
  "storage_connection_type" => "public"
  "company_web_logo" => array:3 [▶
    "key" => "2024-09-11-66e0c5e7cfde3.webp"
    "path" => "https://autocartstore.com/storage/app/public/company/2024-09-11-66e0c5e7cfde3.webp"
    "status" => 200
  ]
  "decimal_point_settings" => 2
  "product_brand" => 1
  "digital_product" => 1
  "business_mode" => "multi"
  "currency_model" => "multi_currency"
  "language" => array:2 [▶
    0 => array:6 [▶
      "id" => "1"
      "name" => "english"
      "direction" => "ltr"
      "code" => "en"
      "status" => 1
      "default" => true
    ]
    1 => array:6 [▶
      "id" => 2
      "name" => "Arabic"
      "direction" => "rtl"
      "code" => "eg"
      "status" => 1
      "default" => false
    ]
  ]
  "local" => "en"
  "direction" => "ltr"
  "system_default_currency" => 9
  "system_default_currency_info" => App\Models\Currency {#3602 ▶
    #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" => 9
      "name" => "Egyptian Pound"
      "symbol" => "EGP"
      "code" => "EGP"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2025-01-02 14:35:20"
      "updated_at" => "2025-03-14 15:17:29"
    ]
    #original: array:8 [▶
      "id" => 9
      "name" => "Egyptian Pound"
      "symbol" => "EGP"
      "code" => "EGP"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2025-01-02 14:35:20"
      "updated_at" => "2025-03-14 15:17:29"
    ]
    #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" => "EGP"
  "currency_symbol" => "EGP"
  "currency_exchange_rate" => "1"
  "_token" => "mKPuka1g6BymIW0nYibd2d99tLVamdE12lPkcgtA"
  "guest_id" => 61912
  "_flash" => array:2 [▶
    "new" => []
    "old" => []
  ]
  "_previous" => array:1 [▶
    "url" => "https://autocartstore.com"
  ]
  "company_name" => "Autocart"
  "usd" => "0.019665683382498"
  "currency_symbol_position" => "left"
  "company_email" => "info@autocartstore.com"
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-01 09:46:32	GET	/	10 76 128 924

1 x Application (91.86%)	1.27s
1 x Booting (8.13%)	112ms

Shopping cart

Top sellers

Test

0.0

0

0

Autocart

0.0

0

91

Akm Egypt

0.0

0

133

Test

0.0

0

0

Autocart

0.0

0

91

Akm Egypt

0.0

0

133

Test

0.0

0

0

Autocart

0.0

0

91

Akm Egypt

0.0

0

133

Test

0.0

0

0

Autocart

0.0

0

91

2Rear Bumper

1Front Bumper

7

Taillights

3Grille

3

2Rear Bumper

1Front Bumper

7

Taillights

3Grille

3

Out of stock

Product added to wishlist

Please Sign in

Delete this address?