Latest Products

Messages Timeline Exceptions Views33 Route Queries62 Models837 Mails Gate Session Request

Request history8.2.187.82s20MBGET products

Booting (6.02s)time
Application (1.8s)time
1 x Booting (76.94%)
6.02s
1 x Application (23.06%)
1.80s

33 templates were rendered

web-views.products.viewview.blade.php#?blade
web-views.products._ajax-products_ajax-products.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
pagination::bootstrap-4bootstrap-4.blade.php#?blade
layouts.front-end.appapp.blade.php#?blade
web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
layouts.front-end.partials._modals_modals.blade.php#?blade
layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
layouts.front-end.partials._header_header.blade.php#?blade
layouts.front-end.partials._cart_cart.blade.php#?blade
layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
layouts.front-end.partials._footer_footer.blade.php#?blade
layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade

uri: GET products
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\ProductListController@products
namespace: App\Http\Controllers\Web
prefix
where
as: products
file: app/Http/Controllers/Web/ProductListController.php:34-44

62 statements were executed, 32 of which were duplicates, 30 unique. Show only duplicated1.03s

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

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

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.118.114.72', '2025-04-23 23:01:09', '2025-04-23 23:01:09')

51.66msdarelkha_aaaGuestMiddleware.php#24

Bindings	0: 18.118.114.72 1: 2025-04-23 23:01:09 2: 2025-04-23 23:01:09
Backtrace	22. middleware::guestCheck:24 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 24. middleware::maintenance_mode:27 25. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 26. middleware::api_lang:22

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

26.9msdarelkha_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/ProductListController.php:48 17. app/Http/Controllers/Web/ProductListController.php:39 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')

604msdarelkha_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/ProductListController.php:48 22. app/Http/Controllers/Web/ProductListController.php:39 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'

1.27msdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Utils/category-manager.php:82 26. app/Http/Controllers/Web/ProductListController.php:48 27. app/Http/Controllers/Web/ProductListController.php:39 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.05msdarelkha_aaacategory-manager.php#82

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:82 26. app/Http/Controllers/Web/ProductListController.php:48 27. app/Http/Controllers/Web/ProductListController.php:39 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

4.41msdarelkha_aaacategory-manager.php#82

Bindings	0: 1
Backtrace	20. app/Utils/category-manager.php:82 21. app/Http/Controllers/Web/ProductListController.php:48 22. app/Http/Controllers/Web/ProductListController.php:39 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

8.35msdarelkha_aaacategory-manager.php#82

Bindings	0: 2
Backtrace	25. app/Utils/category-manager.php:82 26. app/Http/Controllers/Web/ProductListController.php:48 27. app/Http/Controllers/Web/ProductListController.php:39 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'

6.76msdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
Backtrace	30. app/Utils/category-manager.php:82 31. app/Http/Controllers/Web/ProductListController.php:48 32. app/Http/Controllers/Web/ProductListController.php:39 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'

2.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/ProductListController.php:48 27. app/Http/Controllers/Web/ProductListController.php:39 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'

3.48msdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Utils/category-manager.php:82 21. app/Http/Controllers/Web/ProductListController.php:48 22. app/Http/Controllers/Web/ProductListController.php:39 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.04msdarelkha_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/ProductListController.php:48 20. app/Http/Controllers/Web/ProductListController.php:39 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

6.6msdarelkha_aaasettings.php#16

Bindings	0: brand_list_priority
Backtrace	16. app/Utils/settings.php:16 18. app/Utils/brand-manager.php:33 19. app/Http/Controllers/Web/ProductListController.php:49 20. app/Http/Controllers/Web/ProductListController.php:39 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

9.66msdarelkha_aaabrand-manager.php#58

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1
Backtrace	15. app/Utils/brand-manager.php:58 16. app/Utils/brand-manager.php:33 17. app/Http/Controllers/Web/ProductListController.php:49 18. app/Http/Controllers/Web/ProductListController.php:39 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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'

960μsdarelkha_aaabrand-manager.php#58

Bindings	0: App\Models\Brand 1: en
Backtrace	20. app/Utils/brand-manager.php:58 21. app/Utils/brand-manager.php:33 22. app/Http/Controllers/Web/ProductListController.php:49 23. app/Http/Controllers/Web/ProductListController.php:39 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` 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

13.09msdarelkha_aaaProductListController.php#90

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 8: physical
Backtrace	15. app/Http/Controllers/Web/ProductListController.php:90 16. app/Http/Controllers/Web/ProductListController.php:39 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, 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

2.26msdarelkha_aaaProductListController.php#90

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/ProductListController.php:90 21. app/Http/Controllers/Web/ProductListController.php:39 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, 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 `status` = 1 group by `product_id`

1msdarelkha_aaaProductListController.php#90

Bindings	0: 1
Backtrace	20. app/Http/Controllers/Web/ProductListController.php:90 21. app/Http/Controllers/Web/ProductListController.php:39 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 `sellers` where `sellers`.`id` in (1, 3)

700μsdarelkha_aaaProductListController.php#90

Backtrace

20. app/Http/Controllers/Web/ProductListController.php:90
21. app/Http/Controllers/Web/ProductListController.php:39
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 `shops` where `shops`.`seller_id` in (1, 3)

1.5msdarelkha_aaaProductListController.php#90

Backtrace

25. app/Http/Controllers/Web/ProductListController.php:90
26. app/Http/Controllers/Web/ProductListController.php:39
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 `wishlists` where `wishlists`.`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 `customer_id` = 0

720μsdarelkha_aaaProductListController.php#90

Bindings	0: 0
Backtrace	20. app/Http/Controllers/Web/ProductListController.php:90 21. app/Http/Controllers/Web/ProductListController.php:39 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 `product_compares` where `product_compares`.`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 `user_id` = 0

168msdarelkha_aaaProductListController.php#90

Bindings	0: 0
Backtrace	20. app/Http/Controllers/Web/ProductListController.php:90 21. app/Http/Controllers/Web/ProductListController.php:39 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, 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'

5.15msdarelkha_aaaProductListController.php#90

Bindings	0: App\Models\Product 1: en
Backtrace	20. app/Http/Controllers/Web/ProductListController.php:90 21. app/Http/Controllers/Web/ProductListController.php:39 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 `currencies` where (`code` = 'USD') limit 1

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

1.95msdarelkha_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` = 'google_search_console_code') limit 1

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

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

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

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

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

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

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

3.25msdarelkha_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` = 59886 and `is_guest` = 1) group by `cart_group_id`

970μsdarelkha_aaacart-manager.php#100

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

3.36msdarelkha_aaacart-manager.php#65

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1
Backtrace	15. app/Utils/cart-manager.php:65 16. view::layouts.front-end.partials._cart:5 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

1.02msdarelkha_aaacart-manager.php#100

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

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

750μsdarelkha_aaacart-manager.php#65

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1
Backtrace	15. app/Utils/cart-manager.php:65 16. view::layouts.front-end.partials._cart:14 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

4.4msdarelkha_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. view::layouts.front-end.partials._header:235 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (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')

15.61msdarelkha_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. view::layouts.front-end.partials._header:235 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `translations` where `translations`.`translationable_id` in (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'

710μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Product 1: en
Backtrace	25. app/Utils/category-manager.php:82 26. view::layouts.front-end.partials._header:235 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `reviews` where `reviews`.`product_id` in (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

520μsdarelkha_aaacategory-manager.php#82

Bindings	0: 1
Backtrace	25. app/Utils/category-manager.php:82 26. view::layouts.front-end.partials._header:235 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 4, 5, 88) and `position` = 1 order by `priority` asc

7.36msdarelkha_aaacategory-manager.php#82

Bindings	0: 1
Backtrace	20. app/Utils/category-manager.php:82 21. view::layouts.front-end.partials._header:235 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

5.98msdarelkha_aaacategory-manager.php#82

Bindings	0: 2
Backtrace	25. app/Utils/category-manager.php:82 26. view::layouts.front-end.partials._header:235 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `translations` where `translations`.`translationable_id` in (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'

730μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
Backtrace	30. app/Utils/category-manager.php:82 31. view::layouts.front-end.partials._header:235 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 34. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `translations` where `translations`.`translationable_id` in (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'

560μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
Backtrace	25. app/Utils/category-manager.php:82 26. view::layouts.front-end.partials._header:235 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `translations` where `translations`.`translationable_id` in (1, 4, 5, 88) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'

410μsdarelkha_aaacategory-manager.php#82

Bindings	0: App\Models\Category 1: en
Backtrace	20. app/Utils/category-manager.php:82 21. view::layouts.front-end.partials._header:235 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

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

430μsdarelkha_aaasettings.php#16

Bindings	0: category_list_priority
Backtrace	16. app/Utils/settings.php:16 18. app/Utils/category-manager.php:82 19. view::layouts.front-end.partials._header:235 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

540μsdarelkha_aaasettings.php#16

Bindings	0: brand_list_priority
Backtrace	16. app/Utils/settings.php:16 18. app/Utils/brand-manager.php:33 19. view::layouts.front-end.partials._header:336 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

9.67msdarelkha_aaabrand-manager.php#58

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 1
Backtrace	15. app/Utils/brand-manager.php:58 16. app/Utils/brand-manager.php:33 17. view::layouts.front-end.partials._header:336 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `translations` where `translations`.`translationable_id` in (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'

1.4msdarelkha_aaabrand-manager.php#58

Bindings	0: App\Models\Brand 1: en
Backtrace	20. app/Utils/brand-manager.php:58 21. app/Utils/brand-manager.php:33 22. view::layouts.front-end.partials._header:336 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `products` where 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.92msdarelkha_aaa_header.blade.php#366

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: 0
Backtrace	16. view::layouts.front-end.partials._header:366 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 21. vendor/laravel/framework/src/Illuminate/View/View.php:207

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

470μsdarelkha_aaasettings.php#16

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

560μsdarelkha_aaasettings.php#16

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

640μsdarelkha_aaasettings.php#16

Bindings	0: country_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 `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-23' and date(`end_date`) >= '2025-04-23' limit 1

550μsdarelkha_aaa_footer.blade.php#109

Bindings	0: 1 1: flash_deal 2: 2025-04-23 3: 2025-04-23
Backtrace	16. view::layouts.front-end.partials._footer:109 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 21. vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `business_settings` where (`type` = 'refund-policy') limit 1

520μsdarelkha_aaasettings.php#16

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

680μsdarelkha_aaasettings.php#16

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

430μsdarelkha_aaasettings.php#16

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

340μsdarelkha_aaasettings.php#16

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

290μsdarelkha_aaasettings.php#16

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

340μsdarelkha_aaasettings.php#16

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

380μsdarelkha_aaasettings.php#16

Bindings	0: whatsapp
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

App\Models\Product: 672Product.php#?
App\Models\Category: 96Category.php#?
App\Models\Brand: 44Brand.php#?
App\Models\BusinessSetting: 20BusinessSetting.php#?
App\Models\Seller: 2Seller.php#?
App\Models\Currency: 2Currency.php#?
App\Models\Shop: 1Shop.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 {#3630 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: EGP
currency_symbol: EGP
currency_exchange_rate: 1
_token: 5JTQprPRfzZeXLRvxctxhFriGvhaRfqCzrztaATt
guest_id: 59886
usd: 0.019665683382498
currency_symbol_position: left
company_email: info@autocartstore.com
_previous: array:1 [ "url" => "https://autocartstore.com/products?data_from=latest&page=9&page_no=1" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:3 [▼
  "data_from" => "latest"
  "page" => "9"
  "page_no" => "1"
]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "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"
  ]
  "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

[]

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 => "Wed, 23 Apr 2025 21:01:10 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjFYYjdMRDd1M21lc2dSY2JXZkt3RWc9PSIsInZhbHVlIjoibTJFejMyMVpDQ3hxMk8xRXBicTUwQktydUEySmd5NXl5eG1FbDVLUTdLMm1yMVFNSDZWczVWTHkvVk93VGhQT2FnMTFDcFVjKzEvYjk3OHNUUittWE41dnE4S3A3dnZoOE5yWnlBYnhKVDZuOEt3bEU4TXMwWG9ubWJibStWRVAiLCJtYWMiOiJlZGM5ZjAyMjM5NmJmMjhmZDJmNzBjYmUyOTFjMDE2NzE2ODYxMTNhMjdhOWI5MWVhOWQ5ZGEwZTAzYTQ0ZWExIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 22:01:10 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IjFYYjdMRDd1M21lc2dSY2JXZkt3RWc9PSIsInZhbHVlIjoibTJFejMyMVpDQ3hxMk8xRXBicTUwQktydUEySmd5NXl5eG1FbDVLUTdLMm1yMVFNSDZWczVWTHkvVk93VGhQT2FnMTFDc ▶"
    1 => "6valley1725977827_session=eyJpdiI6ImF0dEkrMVlwa0E1OEgyeXZDUHlFalE9PSIsInZhbHVlIjoiRWJzQ01Eb1ZoY05HTkZsdTlSMjRQWDI3VzFBVUV6MkxYWTZjeUJRalR5aWQ1T0xQUndiNG1xOW54NGpmbmlVTnp2dDg1ZWhPWExOMXQ3MnowOFhmS3Y3RWoyNXJMRnJqcWdIdXBqN244bFYvVmpHY3YySEJQUDk0WVhEV05kODIiLCJtYWMiOiIwYjJhMzBlMDNmYmUyOTVmYWY2NDU0Y2FlYzJlNGMyMmNiZmUyMmUwZTFhZWM2N2ZmZTRjYzliOWRiN2U3NjdhIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 22:01:10 GMT; Max-Age=3600; path=/; httponly ◀6valley1725977827_session=eyJpdiI6ImF0dEkrMVlwa0E1OEgyeXZDUHlFalE9PSIsInZhbHVlIjoiRWJzQ01Eb1ZoY05HTkZsdTlSMjRQWDI3VzFBVUV6MkxYWTZjeUJRalR5aWQ1T0xQUndiNG1xOW54NG ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjFYYjdMRDd1M21lc2dSY2JXZkt3RWc9PSIsInZhbHVlIjoibTJFejMyMVpDQ3hxMk8xRXBicTUwQktydUEySmd5NXl5eG1FbDVLUTdLMm1yMVFNSDZWczVWTHkvVk93VGhQT2FnMTFDcFVjKzEvYjk3OHNUUittWE41dnE4S3A3dnZoOE5yWnlBYnhKVDZuOEt3bEU4TXMwWG9ubWJibStWRVAiLCJtYWMiOiJlZGM5ZjAyMjM5NmJmMjhmZDJmNzBjYmUyOTFjMDE2NzE2ODYxMTNhMjdhOWI5MWVhOWQ5ZGEwZTAzYTQ0ZWExIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 22:01:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjFYYjdMRDd1M21lc2dSY2JXZkt3RWc9PSIsInZhbHVlIjoibTJFejMyMVpDQ3hxMk8xRXBicTUwQktydUEySmd5NXl5eG1FbDVLUTdLMm1yMVFNSDZWczVWTHkvVk93VGhQT2FnMTFDc ▶"
    1 => "6valley1725977827_session=eyJpdiI6ImF0dEkrMVlwa0E1OEgyeXZDUHlFalE9PSIsInZhbHVlIjoiRWJzQ01Eb1ZoY05HTkZsdTlSMjRQWDI3VzFBVUV6MkxYWTZjeUJRalR5aWQ1T0xQUndiNG1xOW54NGpmbmlVTnp2dDg1ZWhPWExOMXQ3MnowOFhmS3Y3RWoyNXJMRnJqcWdIdXBqN244bFYvVmpHY3YySEJQUDk0WVhEV05kODIiLCJtYWMiOiIwYjJhMzBlMDNmYmUyOTVmYWY2NDU0Y2FlYzJlNGMyMmNiZmUyMmUwZTFhZWM2N2ZmZTRjYzliOWRiN2U3NjdhIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 22:01:10 GMT; path=/; httponly ◀6valley1725977827_session=eyJpdiI6ImF0dEkrMVlwa0E1OEgyeXZDUHlFalE9PSIsInZhbHVlIjoiRWJzQ01Eb1ZoY05HTkZsdTlSMjRQWDI3VzFBVUV6MkxYWTZjeUJRalR5aWQ1T0xQUndiNG1xOW54NG ▶"
  ]
]

session_attributes

  0 of 0   
array:23 [▼
  "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 {#3630 ▶
    #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" => "5JTQprPRfzZeXLRvxctxhFriGvhaRfqCzrztaATt"
  "guest_id" => 59886
  "usd" => "0.019665683382498"
  "currency_symbol_position" => "left"
  "company_email" => "info@autocartstore.com"
  "_previous" => array:1 [▶
    "url" => "https://autocartstore.com/products?data_from=latest&page=9&page_no=1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-23 23:01:10	GET	/products?data_from=latest&page=9&page_no=1	33 62 837

Special

Account & shipping info

Newsletter

1 x Booting (76.94%)	6.02s
1 x Application (23.06%)	1.80s

Shopping cart

Latest Products

Out of stock

Product added to wishlist

Please Sign in

Delete this address?