Welcome To Autocart Home

Messages10 Timeline Exceptions Views76 Route Queries128 Models924 Mails Gate Session Request

Request history8.2.181.4s21MBGET /

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

Booting (104ms)time
Application (1.29s)time
1 x Application (92.55%)
1.29s
1 x Booting (7.45%)
104ms

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 duplicated390ms

# 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

750μsdarelkha_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.19msdarelkha_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.9msdarelkha_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'

910μsdarelkha_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

1.21msdarelkha_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

6.06msdarelkha_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

4.98msdarelkha_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'

7.74msdarelkha_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'

4.95msdarelkha_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'

6.81msdarelkha_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

2.83msdarelkha_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-04-22' and date(`end_date`) >= '2025-04-22' limit 1

1.06msdarelkha_aaaproduct-manager.php#1318

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

450μ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

540μ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'

590μsdarelkha_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

780μ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.7msdarelkha_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

790μ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 '%\"5\"%'

7.59msdarelkha_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

7.09msdarelkha_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'

540μ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

400μ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

600μ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\"%'

3.09msdarelkha_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

6.38msdarelkha_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'

490μ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

480μ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

780μ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\"%'

4.82msdarelkha_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

32.57msdarelkha_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'

490μ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

1.99msdarelkha_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'))

3.05msdarelkha_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)

21.53msdarelkha_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')

10.3msdarelkha_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

4.99msdarelkha_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'

2.68msdarelkha_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')

4.54msdarelkha_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

460μ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`

770μ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'

800μsdarelkha_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

520μ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

450μsdarelkha_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

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

300μsdarelkha_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

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

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

310μ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

380μ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

470μ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

490μ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

390μ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

390μ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

47.27msdarelkha_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

420μ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

1.36msdarelkha_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')

490μsdarelkha_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

670μ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

460μ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.31msdarelkha_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

1.21msdarelkha_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

380μ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'

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

420μsdarelkha_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')

2.22msdarelkha_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

13.44msdarelkha_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'

630μ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

470μ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

410μ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'

480μ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.08msdarelkha_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.09msdarelkha_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)

710μsdarelkha_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

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

660μ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

670μsdarelkha_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

21.77msdarelkha_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

690μ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

400μ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.4msdarelkha_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 (132) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'

700μ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 (132) and `delivery_man_id` is null and `status` = 1

460μ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

490μ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

1.1msdarelkha_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

1.01msdarelkha_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

920μ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

880μ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

640μ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

680μ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

630μ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

710μ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

590μsdarelkha_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

550μ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

980μ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

670μ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

490μsdarelkha_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

3.26msdarelkha_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

2.66msdarelkha_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

380μ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` = 59715 and `is_guest` = 1) group by `cart_group_id`

3.88msdarelkha_aaacart-manager.php#100

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1 9: 59715 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
710μ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` = 59715 and `is_guest` = 1) group by `cart_group_id`
760μ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
3.56msdarelkha_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
5.15msdarelkha_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')
26.23msdarelkha_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'
930μsdarelkha_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
670μsdarelkha_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
6.43msdarelkha_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
4.64msdarelkha_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'
640μ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'
610μsdarelkha_aaa
select * from `translations` where `translations`.`translationable_id` in (1, 4, 5, 88) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
360μsdarelkha_aaa
select * from `business_settings` where (`type` = 'category_list_priority') limit 1
840μ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
16.2msdarelkha_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'
2.43msdarelkha_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
2.51msdarelkha_aaa
select * from `business_settings` where (`type` = 'seller_registration') limit 1
540μsdarelkha_aaa
select * from `business_settings` where (`type` = 'loader_gif') limit 1
590μsdarelkha_aaa
select * from `business_settings` where (`type` = 'country_code') limit 1
530μsdarelkha_aaa
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-22' and date(`end_date`) >= '2025-04-22' limit 1
480μsdarelkha_aaa
select * from `business_settings` where (`type` = 'refund-policy') limit 1
670μsdarelkha_aaa
select * from `business_settings` where (`type` = 'return-policy') limit 1
300μsdarelkha_aaa
select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
360μsdarelkha_aaa
select * from `business_settings` where (`type` = 'company_phone') limit 1
350μsdarelkha_aaa
select * from `business_settings` where (`type` = 'company_email') limit 1
250μsdarelkha_aaa
select * from `business_settings` where (`type` = 'shop_address') limit 1
410μsdarelkha_aaa
select * from `business_settings` where (`type` = 'whatsapp') limit 1
430μ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: bVzCAJtz2lZ38ihLa50pLMSYgoLqMkgpOB6KlaOW
guest_id: 59715
_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=eyJpdiI6InhnYmJORzRTOXpkYlJZd0NzYUQvNUE9PSIsInZhbHVlIjoiY2drS3B2eElSWFc1LzdrMWw1bWdIZS9wNjRRM0RvaDR2TEl1TjdZNGdoRld3ZStEcFVoNFRNZURVM0FEU0xUL3Z0YU5ZZXFXS1o2REI4L1c0Q28yM01rM05ETVUwUEk4YWRSOGlNZnl0VVVmcTAwVWNEMnhEa3N6bDJKTVZGaWoiLCJtYWMiOiI0ZDk3NzRjODYxOTgwZmI3NDAwZTU2NTg2YWFlM2Q0YmQ2ZjMwNzFlNzc3YWE1OTI1NDdmMjU5Yjg4MTMwMWNmIiwidGFnIjoiIn0%3D; 6valley1725977827_session=eyJpdiI6IlpUWEV3aUlldjJYMUtQTm1EWnpJMWc9PSIsInZhbHVlIjoibkJKQ2hwT01xZTlPQW5qRHMxQ1N6a0VhZkdVT1dDSG43L0E0bkVLK2pPTzhoWWU4UFpFbG8zbzU2NVlBbVQ2SmRPakdsSDZwMEIveVpuQU1RVzV0M2dnM3dVcEpkbWdUOEwxcjdld0ZCWXlCWkYrOUlvSmx4dTRHQlVnNEhGRWoiLCJtYWMiOiJlMTY5ODJhOTk4OWIzN2Y1MTdlY2YyN2I4ZGNjZTNiYjI2NjAyZTM0NzZmMmQ5ZGU2MDE3MmY5YzUxNWFlYTNlIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InhnYmJORzRTOXpkYlJZd0NzYUQvNUE9PSIsInZhbHVlIjoiY2drS3B2eElSWFc1LzdrMWw1bWdIZS9wNjRRM0RvaDR2TEl1TjdZNGdoRld3ZStEcFVoNFRNZURVM0FEU0xUL3Z0YU5ZZ ▶"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-https" => array:1 [▶
    0 => "1"
  ]
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "bVzCAJtz2lZ38ihLa50pLMSYgoLqMkgpOB6KlaOW"
  "6valley1725977827_session" => "512ZU2oJxA6Pkf1N02pMYBplrioGtsl6wCMcLPnj"
]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 22 Apr 2025 18:24:10 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdWM25IWGlQem5yeHBZdTZsWUt5emc9PSIsInZhbHVlIjoiaVhvdWtlcys0b0xuK2ZXdkJBelZvVHlaeFI0UDRWdFVOTUtuQkRudW9yQ1lDeXMwblhtd1oyb2syREpNK0FhdE95QTZhbkl2ZlBRUzRTU1J0U0cvRXhjaE41cDE3V2F4SE50a0lVL244RUIvU1d5aXg0Z2lGcnpYbnptL3N4c0UiLCJtYWMiOiI5N2MwZjA3YThmODA2NGJjMTRiNDU4ZDY3MTA1MjIxOWQxOTlkNGNhMjlhMDA2N2JmOGEyYWVlYTE1ZGNmMTY2IiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 19:24:10 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdWM25IWGlQem5yeHBZdTZsWUt5emc9PSIsInZhbHVlIjoiaVhvdWtlcys0b0xuK2ZXdkJBelZvVHlaeFI0UDRWdFVOTUtuQkRudW9yQ1lDeXMwblhtd1oyb2syREpNK0FhdE95QTZhb ▶"
    1 => "6valley1725977827_session=eyJpdiI6Ik9hZGRMbmxxMjUwRjRNb2FIK0EyR0E9PSIsInZhbHVlIjoiMStBclcrUGdwMFlkTWZHdllUQWsvSXVPL1cwclVIU3Y4OUJNQVFZMUkzZUhMWHZnaXMxSUg4NVZsd09wc0lCMzE2SnVlMUZjdm40ZURpUXRrQXYweEM0N2RWWlQxMTlmam1rbitvZ0d2ZWREZWw2UHFRRyt4K2g2czRGT2FZY24iLCJtYWMiOiIyNmM3OWY2MzI1ZDZkNzM1MDc1YzQzMDIzZWExZGNiMzBmN2NkNzZlZjExYTJhNWVmNTgyMjBhNTE0ZmZiZWFhIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 19:24:10 GMT; Max-Age=3600; path=/; httponly ◀6valley1725977827_session=eyJpdiI6Ik9hZGRMbmxxMjUwRjRNb2FIK0EyR0E9PSIsInZhbHVlIjoiMStBclcrUGdwMFlkTWZHdllUQWsvSXVPL1cwclVIU3Y4OUJNQVFZMUkzZUhMWHZnaXMxSUg4NVZsd0 ▶"
    2 => "popup_banner=eyJpdiI6IjRsenNWZkNwTVFOcFZWbW5UektDZFE9PSIsInZhbHVlIjoiSVh3bmFscXJDakNuUjgrMXZFNmJ2WDVkdVZzcFg3SEt4N0JJS01ibWFBZGNuQkQ5MmhrUTRoOWdhL1FxRUN0WCIsIm1hYyI6ImY3NGNlNWYzNDMwZDczZmZhZmYwMmFhYmQxZjEwNGQ1OGJlNDcwNDM4YzZmNmMwNmY1MWE3YTljMzVlYTA5ZDEiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 22 Apr 2025 18:25:10 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6IjRsenNWZkNwTVFOcFZWbW5UektDZFE9PSIsInZhbHVlIjoiSVh3bmFscXJDakNuUjgrMXZFNmJ2WDVkdVZzcFg3SEt4N0JJS01ibWFBZGNuQkQ5MmhrUTRoOWdhL1FxRUN0WCIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdWM25IWGlQem5yeHBZdTZsWUt5emc9PSIsInZhbHVlIjoiaVhvdWtlcys0b0xuK2ZXdkJBelZvVHlaeFI0UDRWdFVOTUtuQkRudW9yQ1lDeXMwblhtd1oyb2syREpNK0FhdE95QTZhbkl2ZlBRUzRTU1J0U0cvRXhjaE41cDE3V2F4SE50a0lVL244RUIvU1d5aXg0Z2lGcnpYbnptL3N4c0UiLCJtYWMiOiI5N2MwZjA3YThmODA2NGJjMTRiNDU4ZDY3MTA1MjIxOWQxOTlkNGNhMjlhMDA2N2JmOGEyYWVlYTE1ZGNmMTY2IiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 19:24:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdWM25IWGlQem5yeHBZdTZsWUt5emc9PSIsInZhbHVlIjoiaVhvdWtlcys0b0xuK2ZXdkJBelZvVHlaeFI0UDRWdFVOTUtuQkRudW9yQ1lDeXMwblhtd1oyb2syREpNK0FhdE95QTZhb ▶"
    1 => "6valley1725977827_session=eyJpdiI6Ik9hZGRMbmxxMjUwRjRNb2FIK0EyR0E9PSIsInZhbHVlIjoiMStBclcrUGdwMFlkTWZHdllUQWsvSXVPL1cwclVIU3Y4OUJNQVFZMUkzZUhMWHZnaXMxSUg4NVZsd09wc0lCMzE2SnVlMUZjdm40ZURpUXRrQXYweEM0N2RWWlQxMTlmam1rbitvZ0d2ZWREZWw2UHFRRyt4K2g2czRGT2FZY24iLCJtYWMiOiIyNmM3OWY2MzI1ZDZkNzM1MDc1YzQzMDIzZWExZGNiMzBmN2NkNzZlZjExYTJhNWVmNTgyMjBhNTE0ZmZiZWFhIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 19:24:10 GMT; path=/; httponly ◀6valley1725977827_session=eyJpdiI6Ik9hZGRMbmxxMjUwRjRNb2FIK0EyR0E9PSIsInZhbHVlIjoiMStBclcrUGdwMFlkTWZHdllUQWsvSXVPL1cwclVIU3Y4OUJNQVFZMUkzZUhMWHZnaXMxSUg4NVZsd0 ▶"
    2 => "popup_banner=eyJpdiI6IjRsenNWZkNwTVFOcFZWbW5UektDZFE9PSIsInZhbHVlIjoiSVh3bmFscXJDakNuUjgrMXZFNmJ2WDVkdVZzcFg3SEt4N0JJS01ibWFBZGNuQkQ5MmhrUTRoOWdhL1FxRUN0WCIsIm1hYyI6ImY3NGNlNWYzNDMwZDczZmZhZmYwMmFhYmQxZjEwNGQ1OGJlNDcwNDM4YzZmNmMwNmY1MWE3YTljMzVlYTA5ZDEiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 22-Apr-2025 18:25:10 GMT; path=/; httponly ◀popup_banner=eyJpdiI6IjRsenNWZkNwTVFOcFZWbW5UektDZFE9PSIsInZhbHVlIjoiSVh3bmFscXJDakNuUjgrMXZFNmJ2WDVkdVZzcFg3SEt4N0JJS01ibWFBZGNuQkQ5MmhrUTRoOWdhL1FxRUN0WCIsIm1 ▶"
  ]
]

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" => "bVzCAJtz2lZ38ihLa50pLMSYgoLqMkgpOB6KlaOW"
  "guest_id" => 59715
  "_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-04-22 20:24:10	GET	/	10 76 128 924

1 x Application (92.55%)	1.29s
1 x Booting (7.45%)	104ms

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?