Check our Offers Page X
المنتجات المميزة
أفضل البائعين

المنتجات الموصى بها

أحدث المنتجات
10.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
المنتجات الجديدة
العلامات التجارية
أدوات الهواء
إنتهى من المخزن
إنتهى من المخزن
منتجات القماش المشمع و PVC
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
التركيبات الصحية
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
0.000KWD
إنتهى من المخزن
0.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
GI Wire و Wire Netting
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
اسطوانة الباب
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
التحكم التلقائي
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
شريط لاصق
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات الطاقة
إنتهى من المخزن
12.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات يدوية
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات الحديقة
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
غير موجود
Request history8.3.11PHP Version1.79sRequest Duration14MBMemory UsageGET /Route
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:11] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[23:51:12] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (79.87ms)time
  • Application (1.71s)time
  • 1 x Application (95.54%)
    1.71s
    1 x Booting (4.46%)
    79.87ms
    216 templates were rendered
    • 1x web-views.homehome.blade.php#?blade
    • 1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
    • 7x web-views.partials._feature-product_feature-product.blade.php#?blade
    • 1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
    • 1x web-views.partials._top-sellers_top-sellers.blade.php#?blade
    • 1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
    • 8x web-views.partials._inline-single-product_inline-single-product.blade.php#?blade
    • 8x web-views.partials._product-card-2_product-card-2.blade.php#?blade
    • 1x web-views.partials._best-selling_best-selling.blade.php#?blade
    • 1x web-views.partials._top-rated_top-rated.blade.php#?blade
    • 21x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
    • 154x web-views.partials._category-single-product_category-single-product.blade.php#?blade
    • 1x web-views.partials._company-reliability_company-reliability.blade.php#?blade
    • 1x layouts.front-end.appapp.blade.php#?blade
    • 1x web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
    • 1x layouts.front-end.partials._modals_modals.blade.php#?blade
    • 1x layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
    • 1x layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
    • 1x layouts.front-end.partials._header_header.blade.php#?blade
    • 1x layouts.front-end.partials._cart_cart.blade.php#?blade
    • 1x layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
    • 1x layouts.front-end.partials._footer_footer.blade.php#?blade
    • 1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
    uri
    GET /
    middleware
    web, maintenance_mode, guestCheck
    controller
    App\Http\Controllers\Web\HomeController@index
    namespace
    App\Http\Controllers\Web
    where
    as
    home
    file
    app/Http/Controllers/Web/HomeController.php:49-58
    207 statements were executed, 37 of which were duplicates, 170 unique. Show only duplicated1.36s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 107 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
      470μslaravelhelpers.php#168
      Bindings
      • 0: maintenance_mode
      Backtrace
      • 16. app/Utils/helpers.php:168
      • 17. middleware::maintenance_mode:20
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 19. middleware::api_lang:22
      • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and 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
      33.69mslaravelcategory-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 (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) 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')
      9.65mslaravelcategory-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 (2, 2549) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      470μslaravelcategory-manager.php#82
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:62
      • 27. app/Http/Controllers/Web/HomeController.php:53
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `reviews` where `reviews`.`product_id` in (2, 2549) and `delivery_man_id` is null and `status` = 1
      340μslaravelcategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:62
      • 27. app/Http/Controllers/Web/HomeController.php:53
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` = 1 order by `priority` asc
      143mslaravelcategory-manager.php#82
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. app/Http/Controllers/Web/HomeController.php:62
      • 22. app/Http/Controllers/Web/HomeController.php:53
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `position` = 2 order by `priority` asc
      95.09mslaravelcategory-manager.php#82
      Bindings
      • 0: 2
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:62
      • 27. app/Http/Controllers/Web/HomeController.php:53
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (6, 8, 9, 11, 12, 16, 18, 20, 22, 24, 29, 31, 32, 33, 36, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 58, 60, 68, 70, 71, 73, 75, 80, 85, 87, 88, 95, 96, 99, 101, 102, 103, 104, 105, 107, 108, 113, 114, 115, 116, 119, 120, 121, 123, 136, 137, 138, 139, 141, 147, 149, 151, 156) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      1.17mslaravelcategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: kw
      Backtrace
      • 30. app/Utils/category-manager.php:82
      • 31. app/Http/Controllers/Web/HomeController.php:62
      • 32. app/Http/Controllers/Web/HomeController.php:53
      • 33. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 34. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      1.16mslaravelcategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: kw
      Backtrace
      • 25. app/Utils/category-manager.php:82
      • 26. app/Http/Controllers/Web/HomeController.php:62
      • 27. app/Http/Controllers/Web/HomeController.php:53
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `translations` where `translations`.`translationable_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      590μslaravelcategory-manager.php#82
      Bindings
      • 0: App\Models\Category
      • 1: kw
      Backtrace
      • 20. app/Utils/category-manager.php:82
      • 21. app/Http/Controllers/Web/HomeController.php:62
      • 22. app/Http/Controllers/Web/HomeController.php:53
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
      450μslaravelsettings.php#16
      Bindings
      • 0: category_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Utils/category-manager.php:82
      • 19. app/Http/Controllers/Web/HomeController.php:62
      • 20. app/Http/Controllers/Web/HomeController.php:53
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `flash_deals`.*, (select count(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` = 'flash_deal' and `status` = 1) and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09' limit 1
      460μslaravelproduct-manager.php#1318
      Bindings
      • 0: flash_deal
      • 1: 1
      • 2: 2025-04-09
      • 3: 2025-04-09
      Backtrace
      • 16. app/Utils/product-manager.php:1318
      • 17. app/Http/Controllers/Web/HomeController.php:64
      • 18. app/Http/Controllers/Web/HomeController.php:53
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `business_settings` where `type` = 'product_brand' limit 1
      330μslaravelHomeController.php#67
      Bindings
      • 0: product_brand
      Backtrace
      • 16. app/Http/Controllers/Web/HomeController.php:67
      • 17. app/Http/Controllers/Web/HomeController.php:53
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `categories` where `home_status` = 1 order by `priority` asc
      590μslaravelHomeController.php#68
      Bindings
      • 0: 1
      Backtrace
      • 15. app/Http/Controllers/Web/HomeController.php:68
      • 16. app/Http/Controllers/Web/HomeController.php:53
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `translations` where `translations`.`translationable_id` in (9, 11, 15, 26, 39, 45, 67, 86, 96, 111, 135, 157, 158, 159, 161, 162, 163, 164, 165, 166, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      930μslaravelHomeController.php#68
      Bindings
      • 0: App\Models\Category
      • 1: kw
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:68
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      520μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"11\"%'
      12.91mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"11"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"11\"%' order by `order_details_count` desc limit 12 offset 0
      17.2mslaravelproduct-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: %"11"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (644, 826) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      410μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (644, 826) and `delivery_man_id` is null and `status` = 1
      380μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      380μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"135\"%'
      12.38mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"135"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"135\"%' order by `order_details_count` desc limit 12 offset 0
      16.97mslaravelproduct-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: %"135"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1725, 2172, 2202, 2203) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      530μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1725, 2172, 2202, 2203) and `delivery_man_id` is null and `status` = 1
      300μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      390μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"111\"%'
      12.3mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"111"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"111\"%' order by `order_details_count` desc limit 12 offset 0
      19.42mslaravelproduct-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: %"111"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (364, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649, 1651, 1967, 2491) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      620μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (364, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649, 1651, 1967, 2491) and `delivery_man_id` is null and `status` = 1
      410μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      450μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"96\"%'
      12.71mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"96"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `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 '%\"96\"%' order by `order_details_count` desc limit 12 offset 0
      29.39mslaravelproduct-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: %"96"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1634, 1635, 1636, 1637, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      770μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1634, 1635, 1636, 1637, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649) and `delivery_man_id` is null and `status` = 1
      490μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      680μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"86\"%'
      21.8mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"86"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      770μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"67\"%'
      10.89mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"67"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"67\"%' order by `order_details_count` desc limit 12 offset 0
      17.22mslaravelproduct-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: %"67"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (54, 272, 2454) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      560μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (54, 272, 2454) and `delivery_man_id` is null and `status` = 1
      370μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      430μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"45\"%'
      12.53mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"45"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"45\"%' order by `order_details_count` desc limit 12 offset 0
      24.63mslaravelproduct-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: %"45"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (773, 774, 775, 776, 821, 822, 823, 824, 1165, 1166, 1206, 1208) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      590μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (773, 774, 775, 776, 821, 822, 823, 824, 1165, 1166, 1206, 1208) and `delivery_man_id` is null and `status` = 1
      440μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      370μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"39\"%'
      17.92mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"39"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `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 '%\"39\"%' order by `order_details_count` desc limit 12 offset 0
      28.4mslaravelproduct-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: %"39"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (124, 344, 664, 1958, 1959, 1960, 1961) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      570μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (124, 344, 664, 1958, 1959, 1960, 1961) and `delivery_man_id` is null and `status` = 1
      360μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      450μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"26\"%'
      14.73mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"26"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `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 '%\"26\"%' order by `order_details_count` desc limit 12 offset 0
      18.77mslaravelproduct-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: %"26"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1277, 1829, 2055, 2056, 2057, 2058) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      900μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1277, 1829, 2055, 2056, 2057, 2058) and `delivery_man_id` is null and `status` = 1
      410μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      510μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"15\"%'
      15.46mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"15"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `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 '%\"15\"%' order by `order_details_count` desc limit 12 offset 0
      24.19mslaravelproduct-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: %"15"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (148, 321, 327, 2280, 2377, 2386, 2477, 2478, 2479, 2480, 2481, 2482) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      790μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (148, 321, 327, 2280, 2377, 2386, 2477, 2478, 2479, 2480, 2481, 2482) and `delivery_man_id` is null and `status` = 1
      380μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      360μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"9\"%'
      12.03mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"9"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"9\"%' order by `order_details_count` desc limit 12 offset 0
      14.58mslaravelproduct-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: %"9"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (266, 564, 565, 784, 1486) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      450μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (266, 564, 565, 784, 1486) and `delivery_man_id` is null and `status` = 1
      270μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      360μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"157\"%'
      9.87mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"157"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      520μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"158\"%'
      14.48mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"158"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"158\"%' order by `order_details_count` desc limit 12 offset 0
      32.13mslaravelproduct-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: %"158"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1111, 1168, 1169, 1170, 1171, 1187, 1188, 1189, 1202, 1203, 1206, 1207) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      570μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1111, 1168, 1169, 1170, 1171, 1187, 1188, 1189, 1202, 1203, 1206, 1207) and `delivery_man_id` is null and `status` = 1
      370μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      560μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"159\"%'
      12.36mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"159"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      640μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"161\"%'
      10.36mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"161"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"161\"%' order by `order_details_count` desc limit 12 offset 0
      18.93mslaravelproduct-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: %"161"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (1264, 1265, 1266, 1316, 1380, 1409, 1410, 1411, 1473, 1474, 1475, 1665) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      450μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (1264, 1265, 1266, 1316, 1380, 1409, 1410, 1411, 1473, 1474, 1475, 1665) and `delivery_man_id` is null and `status` = 1
      270μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      500μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"162\"%'
      9.49mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"162"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      400μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"163\"%'
      9.33mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"163"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      560μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"164\"%'
      11.85mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"164"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where 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 '%\"164\"%' order by `order_details_count` desc limit 12 offset 0
      13.99mslaravelproduct-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: %"164"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `translations` where `translations`.`translationable_id` in (244, 659, 992, 1040, 1872, 1973) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      380μslaravelproduct-manager.php#1144
      Bindings
      • 0: App\Models\Product
      • 1: kw
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `reviews` where `reviews`.`product_id` in (244, 659, 992, 1040, 1872, 1973) and `delivery_man_id` is null and `status` = 1
      250μslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      Backtrace
      • 21. app/Utils/product-manager.php:1144
      • 22. app/Http/Controllers/Web/HomeController.php:74
      • 27. app/Http/Controllers/Web/HomeController.php:69
      • 28. app/Http/Controllers/Web/HomeController.php:53
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      310μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"165\"%'
      10.71mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"165"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      330μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"166\"%'
      10.19mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"166"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `business_settings` where (`type` = 'category_wise_product_list_priority') limit 1
      350μslaravelsettings.php#16
      Bindings
      • 0: category_wise_product_list_priority
      Backtrace
      • 16. app/Utils/settings.php:16
      • 18. app/Http/Controllers/Web/HomeController.php:74
      • 23. app/Http/Controllers/Web/HomeController.php:69
      • 24. app/Http/Controllers/Web/HomeController.php:53
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select count(*) as aggregate from `products` where 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 '%\"168\"%'
      8.34mslaravelproduct-manager.php#1144
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: %"168"%
      Backtrace
      • 16. app/Utils/product-manager.php:1144
      • 17. app/Http/Controllers/Web/HomeController.php:74
      • 22. app/Http/Controllers/Web/HomeController.php:69
      • 23. app/Http/Controllers/Web/HomeController.php:53
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `shops`.*, (select count(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and 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'))
      45.96mslaravelHomeController.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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
      1.21mslaravelHomeController.php#90
      Backtrace
      • 20. app/Http/Controllers/Web/HomeController.php:90
      • 21. app/Http/Controllers/Web/HomeController.php:53
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `products` where (`added_by` = 'seller') and `products`.`user_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) and 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')
      14.65mslaravelHomeController.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 (2, 12, 13, 14, 15, 16, 33, 38, 43, 44, 45, 54, 61, 70, 71, 92, 94, 120, 123, 124, 134, 135, 136, 148, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 165, 166, 167, 176, 177, 178, 179, 181, 182, 185, 187, 188, 189, 190, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 228, 232, 237, 249, 250, 279, 280, 281, 282, 283, 284, 285, 286, 287, 290, 291, 299, 300, 303, 304, 308, 312, 313, 318, 321, 327, 334, 344, 353, 355, 361, 362, 364, 394, 397, 401, 402, 422, 430, 465, 537, 538, 552, 553, 554, 555, 565, 580, 592, 594, 597, 598, 599, 600, 601, 602, 603, 605, 606, 609, 610, 613, 615, 616, 617, 619, 620, 621, 622, 623, 624, 625, 626, 628, 629, 630, 631, 632, 633, 634, 639, 640, 641, 644, 645, 647, 648, 652, 662, 664, 724, 725, 732, 739, 740, 741, 744, 745, 746, 747, 766, 770, 772, 773, 774, 775, 794, 795, 801, 804, 805, 806, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 821, 822, 824, 826, 827, 829, 836, 839, 842, 843, 868, 885, 887, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 1010, 1026, 1027, 1037, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1058, 1066, 1072, 1077, 1099, 1106, 1110, 1112, 1129, 1130, 1131, 1137, 1138, 1139, 1140, 1154, 1157, 1159, 1165, 1166, 1167, 1171, 1277, 1283, 1289, 1293, 1294, 1296, 1297, 1298, 1299, 1300, 1301, 1317, 1327, 1374, 1375, 1376, 1380, 1386, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1433, 1477, 1478, 1507, 1540, 1541, 1551, 1555, 1556, 1564, 1566, 1599, 1600, 1601, 1602, 1603, 1629, 1630, 1634, 1635, 1636, 1637, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649, 1651, 1655, 1658, 1660, 1667, 1682, 1718, 1721, 1748, 1757, 1760, 1764, 1765, 1775, 1781, 1822, 1829, 1852, 1855, 1856, 1861, 1862, 1879, 1882, 1883, 1887, 1892, 1894, 1908, 1916, 1917, 1918, 1921, 1922, 1930, 1933, 1937, 1938, 1939, 1940, 1949, 1956, 1958, 1959, 1960, 1961, 1967, 1973, 1978, 1979, 1987, 1988, 1989, 1994, 2055, 2056, 2057, 2058, 2087, 2112, 2113, 2114, 2115, 2122, 2123, 2126, 2127, 2128, 2138, 2161, 2162, 2172, 2178, 2186, 2194, 2197, 2202, 2203, 2220, 2221, 2222, 2225, 2242, 2264, 2266, 2268, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2285, 2286, 2323, 2324, 2362, 2363, 2364, 2365, 2366, 2367, 2368, 2373, 2375, 2376, 2377, 2378, 2381, 2383, 2384, 2385, 2386, 2395, 2405, 2409, 2410, 2411, 2412, 2413, 2414, 2415, 2427, 2428, 2433, 2465, 2466, 2467, 2468, 2475, 2476, 2477, 2478, 2479, 2480, 2481, 2482, 2483, 2484, 2485, 2486, 2487, 2488, 2489, 2490, 2491, 2492, 2493, 2494) and `delivery_man_id` is null and `status` = 1
      970μslaravelHomeController.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 (2, 12, 13, 14, 15, 16, 33, 38, 43, 44, 45, 54, 61, 70, 71, 92, 94, 120, 123, 124, 134, 135, 136, 148, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 165, 166, 167, 176, 177, 178, 179, 181, 182, 185, 187, 188, 189, 190, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 228, 232, 237, 249, 250, 279, 280, 281, 282, 283, 284, 285, 286, 287, 290, 291, 299, 300, 303, 304, 308, 312, 313, 318, 321, 327, 334, 344, 353, 355, 361, 362, 364, 394, 397, 401, 402, 422, 430, 465, 537, 538, 552, 553, 554, 555, 565, 580, 592, 594, 597, 598, 599, 600, 601, 602, 603, 605, 606, 609, 610, 613, 615, 616, 617, 619, 620, 621, 622, 623, 624, 625, 626, 628, 629, 630, 631, 632, 633, 634, 639, 640, 641, 644, 645, 647, 648, 652, 662, 664, 724, 725, 732, 739, 740, 741, 744, 745, 746, 747, 766, 770, 772, 773, 774, 775, 794, 795, 801, 804, 805, 806, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 821, 822, 824, 826, 827, 829, 836, 839, 842, 843, 868, 885, 887, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 1010, 1026, 1027, 1037, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1058, 1066, 1072, 1077, 1099, 1106, 1110, 1112, 1129, 1130, 1131, 1137, 1138, 1139, 1140, 1154, 1157, 1159, 1165, 1166, 1167, 1171, 1277, 1283, 1289, 1293, 1294, 1296, 1297, 1298, 1299, 1300, 1301, 1317, 1327, 1374, 1375, 1376, 1380, 1386, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1433, 1477, 1478, 1507, 1540, 1541, 1551, 1555, 1556, 1564, 1566, 1599, 1600, 1601, 1602, 1603, 1629, 1630, 1634, 1635, 1636, 1637, 1638, 1639, 1641, 1644, 1645, 1646, 1648, 1649, 1651, 1655, 1658, 1660, 1667, 1682, 1718, 1721, 1748, 1757, 1760, 1764, 1765, 1775, 1781, 1822, 1829, 1852, 1855, 1856, 1861, 1862, 1879, 1882, 1883, 1887, 1892, 1894, 1908, 1916, 1917, 1918, 1921, 1922, 1930, 1933, 1937, 1938, 1939, 1940, 1949, 1956, 1958, 1959, 1960, 1961, 1967, 1973, 1978, 1979, 1987, 1988, 1989, 1994, 2055, 2056, 2057, 2058, 2087, 2112, 2113, 2114, 2115, 2122, 2123, 2126, 2127, 2128, 2138, 2161, 2162, 2172, 2178, 2186, 2194, 2197, 2202, 2203, 2220, 2221, 2222, 2225, 2242, 2264, 2266, 2268, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2285, 2286, 2323, 2324, 2362, 2363, 2364, 2365, 2366, 2367, 2368, 2373, 2375, 2376, 2377, 2378, 2381, 2383, 2384, 2385, 2386, 2395, 2405, 2409, 2410, 2411, 2412, 2413, 2414, 2415, 2427, 2428, 2433, 2465, 2466, 2467, 2468, 2475, 2476, 2477, 2478, 2479, 2480, 2481, 2482, 2483, 2484, 2485, 2486, 2487, 2488, 2489, 2490, 2491, 2492, 2493, 2494) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      1.29mslaravel
    • 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')
      14.08mslaravel
    • select * from `reviews` where `reviews`.`product_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `delivery_man_id` is null and `status` = 1
      470μslaravel
    • select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `status` = 1 group by `product_id`
      750μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      800μslaravel
    • select count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `status` = 1
      620μslaravel
    • select `rating` from `reviews` where `status` = 1 and `product_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `status` = 1
      540μslaravel
    • select * from `business_settings` where (`type` = 'vacation_add') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'company_name') limit 1
      210μslaravel
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      240μslaravel
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      220μslaravel
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      200μslaravel
    • select * from `business_settings` where (`type` = 'bottom_banner') limit 1
      330μslaravel
    • select * from `business_settings` where (`type` = 'offer_banner') limit 1
      280μslaravel
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      240μslaravel
    • select * from `admins` where (`id` = 1) limit 1
      260μslaravel
    • select * from `admins` where (`id` = 1) limit 1
      240μslaravel
    • select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (175, 180, 206, 233, 239, 240, 244, 245, 246, 247, 257, 259, 260, 265, 266, 272, 277, 288, 289, 292, 293, 316, 317, 319, 328, 329, 330, 333, 352, 354, 359, 374, 376, 381, 382, 383, 385, 396, 398, 399, 415, 417, 418, 425, 428, 453, 467, 468, 474, 534, 540, 559, 560, 561, 562, 564, 572, 607, 608, 611, 612, 627, 642, 659, 661, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 699, 700, 703, 704, 726, 728, 729, 752, 757, 771, 776, 777, 778, 779, 780, 784, 793, 803, 823, 825, 828, 830, 865, 874, 876, 880, 890, 991, 992, 1016, 1017, 1018, 1020, 1022, 1028, 1038, 1040, 1044, 1054, 1055, 1057, 1059, 1063, 1068, 1073, 1082, 1083, 1084, 1090, 1095, 1098, 1105, 1107, 1108, 1109, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1145, 1146, 1161, 1162, 1163, 1168, 1169, 1170, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1264, 1265, 1266, 1278, 1279, 1288, 1295, 1316, 1373, 1409, 1410, 1411, 1413, 1473, 1474, 1475, 1476, 1485, 1486, 1488, 1489, 1550, 1568, 1569, 1572, 1573, 1574, 1583, 1597, 1643, 1662, 1665, 1666, 1670, 1671, 1672, 1676, 1717, 1719, 1720, 1725, 1727, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1749, 1750, 1761, 1768, 1773, 1774, 1812, 1813, 1814, 1816, 1817, 1818, 1820, 1821, 1826, 1827, 1828, 1851, 1853, 1859, 1872, 1884, 1885, 1886, 1888, 1893, 1901, 1913, 1914, 1915, 1920, 1923, 1929, 1931, 1951, 1952, 1955, 1962, 1971, 1993, 1998, 2013, 2015, 2016, 2046, 2047, 2048, 2049, 2085, 2090, 2096, 2101, 2104, 2116, 2117, 2139, 2154, 2155, 2156, 2157, 2158, 2159, 2188, 2198, 2204, 2206, 2208, 2209, 2240, 2249, 2261, 2263, 2272, 2374, 2420, 2421, 2434, 2441, 2442, 2454, 2496, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `status` = 1
      630μslaravel
    • select count(*) as aggregate from `orders` where (`seller_is` = 'admin')
      340μslaravel
    • select * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
      320μslaravel
    • select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
      300μslaravel
    • 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)
      8.33mslaravel
    • 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') and (`featured` = 1) order by `id` desc limit 12 offset 0
      12.68mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (257, 259, 774, 944, 1215, 1216, 2117) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      360μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (257, 259, 774, 944, 1215, 1216, 2117) and `delivery_man_id` is null and `status` = 1
      350μslaravel
    • 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
      700μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `delivery_man_id` is null and `status` = 1
      240μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      330μslaravel
    • select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
      290μslaravel
    • 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')
      8.67mslaravel
    • 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
      32.92mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2, 1413, 1478, 1485, 1486, 1488, 1507, 1540) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      480μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2, 1413, 1478, 1485, 1486, 1488, 1507, 1540) and `delivery_man_id` is null and `status` = 1
      260μslaravel
    • select * from `brands` where `status` = 1 limit 15
      250μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (105, 106, 108, 109, 110, 113, 115, 117, 122, 124, 125, 126, 127, 128, 129) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'kw'
      340μslaravel
    • select `product_id`, COUNT(product_id) as count from `order_details` where exists (select * from `products` where `order_details`.`product_id` = `products`.`id` and 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
      620μslaravel
    • select * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\Models\OrderDetail'
      260μslaravel
    • select * from `products` where `status` = 1 and `products`.`id` in (2)
      330μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2) and `delivery_man_id` is null and `status` = 1
      270μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      290μslaravel
    • 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
      420μslaravel
    • select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1
      440μslaravel
    • select * from `banners` where (`banner_type` = 'Main Banner' and `theme` = 'default' and `published` = 1) order by `created_at` desc
      390μslaravel
    • select * from `banners` where (`banner_type` = 'Main Section Banner' and `theme` = 'default' and `published` = 1) order by `id` desc, `created_at` desc limit 1
      360μslaravel
    • 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
      19.32mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (1893) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      370μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (1893) and `delivery_man_id` is null and `status` = 1
      310μslaravel
    • select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
      480μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 23 and `storages`.`data_id` is not null
      630μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 22 and `storages`.`data_id` is not null
      410μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 21 and `storages`.`data_id` is not null
      330μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 20 and `storages`.`data_id` is not null
      270μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 19 and `storages`.`data_id` is not null
      320μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 18 and `storages`.`data_id` is not null
      400μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 17 and `storages`.`data_id` is not null
      340μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 16 and `storages`.`data_id` is not null
      340μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 15 and `storages`.`data_id` is not null
      390μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 14 and `storages`.`data_id` is not null
      360μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 13 and `storages`.`data_id` is not null
      290μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 12 and `storages`.`data_id` is not null
      340μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 8 and `storages`.`data_id` is not null
      320μslaravel
    • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
      310μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 7 and `storages`.`data_id` is not null
      460μslaravel
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      380μslaravel
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      280μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 10 and `storages`.`data_id` is not null
      410μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 9 and `storages`.`data_id` is not null
      320μslaravel
    • select * from `business_settings` where (`type` = 'company_reliability') limit 1
      510μslaravel
    • select * from `business_settings` where (`type` = 'google_search_console_code') limit 1
      310μslaravel
    • select * from `business_settings` where (`type` = 'bing_webmaster_code') limit 1
      310μslaravel
    • select * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
      260μslaravel
    • select * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
      320μslaravel
    • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
      250μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 11 and `storages`.`data_id` is not null
      290μslaravel
    • select * from `business_settings` where (`type` = 'announcement') limit 1
      230μslaravel
    • select `cart_group_id` from `carts` where (`customer_id` = 226508 and `is_guest` = 1) group by `cart_group_id`
      310μslaravel
    • select * from `carts` where 0 = 1
      250μslaravel
    • select `cart_group_id` from `carts` where (`customer_id` = 226508 and `is_guest` = 1) group by `cart_group_id`
      250μslaravel
    • select * from `carts` where 0 = 1
      170μslaravel
    • 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
      24.09mslaravel
    • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` = 1)) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')
      6.69mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2, 2549) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      420μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2, 2549) and `delivery_man_id` is null and `status` = 1
      260μslaravel
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` = 1 order by `priority` asc
      88.25mslaravel
    • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `position` = 2 order by `priority` asc
      62.51mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (6, 8, 9, 11, 12, 16, 18, 20, 22, 24, 29, 31, 32, 33, 36, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 58, 60, 68, 70, 71, 73, 75, 80, 85, 87, 88, 95, 96, 99, 101, 102, 103, 104, 105, 107, 108, 113, 114, 115, 116, 119, 120, 121, 123, 136, 137, 138, 139, 141, 147, 149, 151, 156) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      890μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (7, 10, 13, 14, 15, 17, 19, 21, 23, 26, 27, 28, 30, 40, 48, 49, 50, 52, 53, 54, 55, 56, 57, 59, 61, 62, 63, 65, 66, 67, 69, 72, 74, 76, 77, 78, 79, 82, 83, 84, 86, 89, 90, 91, 94, 97, 98, 100, 106, 109, 110, 111, 112, 117, 118, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 140, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 158, 161, 164, 169) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      660μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'kw'
      340μslaravel
    • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
      290μslaravel
    • select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
      310μslaravel
    • 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
      125mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (105, 106, 108, 109, 110, 113, 115, 117, 122, 124, 125, 126, 127, 128, 129, 131, 132, 133, 134, 135, 136, 137, 138, 139, 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, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'kw'
      980μslaravel
    • 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
      7.06mslaravel
    • select * from `business_settings` where (`type` = 'seller_registration') limit 1
      310μslaravel
    • select * from `business_settings` where (`type` = 'loader_gif') limit 1
      470μslaravel
    • select * from `business_settings` where (`type` = 'country_code') limit 1
      240μslaravel
    • select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09' limit 1
      280μslaravel
    • select * from `business_settings` where (`type` = 'refund-policy') limit 1
      300μslaravel
    • select * from `business_settings` where (`type` = 'return-policy') limit 1
      260μslaravel
    • select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
      230μslaravel
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      220μslaravel
    • select * from `business_settings` where (`type` = 'company_email') limit 1
      210μslaravel
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      220μslaravel
    • select * from `business_settings` where (`type` = 'whatsapp') limit 1
      250μslaravel
    App\Models\Product
    1073Product.php#?
    App\Models\Translation
    451Translation.php#?
    App\Models\Category
    343Category.php#?
    App\Models\Brand
    98Brand.php#?
    App\Models\BusinessSetting
    54BusinessSetting.php#?
    App\Models\Shop
    26Shop.php#?
    App\Models\Seller
    26Seller.php#?
    App\Models\Storage
    17Storage.php#?
    App\Models\Banner
    16Banner.php#?
    App\Models\Admin
    2Admin.php#?
    App\Models\OrderDetail
    1OrderDetail.php#?
        storage_connection_type
        public
        company_web_logo
        array:3 [ "key" => "2024-10-06-6702a7946cf56.webp" "path" => "/storage/company/2024-10-06-6702a7...
        decimal_point_settings
        3
        product_brand
        1
        digital_product
        1
        business_mode
        multi
        currency_model
        single_currency
        language
        array:3 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
        local
        kw
        direction
        rtl
        system_default_currency
        12
        system_default_currency_info
        App\Models\Currency {#1562 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        KWD
        currency_symbol
        KWD
        currency_exchange_rate
        1
        _token
        m15sffZbbk0hrgHOGK6nky3LCiJEDeTUbnmXXK7p
        guest_id
        226508
        _flash
        array:2 [ "new" => [] "old" => [] ]
        _previous
        array:1 [ "url" => "https://mybunyan.com" ]
        company_name
        Souq Bunyan
        currency_symbol_position
        right
        company_email
        info@bunyan.shop
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InNveU5RNFowd3ZTdi9qZTR4bnRGTWc9PSIsInZhbHVlIjoiUEpEb3pLMUZpNkN2bW0ybEMxRjZ0Qkk3aW4rdkdNemN4UkcxMzd3SThvOWtNemFUK2JUelQ4a01RWCtYRkFkQVNiR2xnZDhpd1IzRmxCVEs0VGt2MndZQ2ltSEVMUE5qUDRQeHhlS1JQZWVBVCtDVDhveTl4Smx0eHpJNnAwWUciLCJtYWMiOiJmZTA3MjRmNWZkZTIzYzU0Yzc5YmFmZWVhMWFkMGRlNDI4ZTdmYjY2NDQ1YTE0ODU5ZWZjYjU0OWJhYmYzZDZlIiwidGFnIjoiIn0%3D; 6valley1724088324_session=eyJpdiI6InNaVG1OOXE1dWo4dENGTU1zMGpDSFE9PSIsInZhbHVlIjoiSTFaL1ZSQTRnRnR2bjRHUzcxRm5sWHpaMSs5VGNTWDZHRU9HdTJvay8yY1ZOMUpMUFRuVnVOalRUOEMzb1NXWHhienBtY01meDJFQ0ZTazFzblJuODg1dGx3OHFta0I0REhieklldjEyL2YrVExyaDVUMFVteW5EODFuZmdydDciLCJtYWMiOiIyNGRlMDRiODU3NDY5MWYwNTczZjU3YmU3NjhkMGMwOGExOGY0YzVkNjE0YzEzNzE0YTJjNzdkYzczYWVjNGE1IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InNveU5RNFowd3ZTdi9qZTR4bnRGTWc9PSIsInZhbHVlIjoiUEpEb3pLMUZpNkN2bW0ybEMxRjZ0Qkk3aW4rdkdNemN4UkcxMzd3SThvOWtNemFUK2JUelQ4a01RWCtYRkFkQVNiR2xnZ" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "mybunyan.com" ] ]
        request_cookies
        0 of 0
        array:2 [ "XSRF-TOKEN" => "m15sffZbbk0hrgHOGK6nky3LCiJEDeTUbnmXXK7p" "6valley1724088324_session" => "H1vT7dQQNsgsFRuNNiRoQNULfXewRu8qra3k1aXA" ]
        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, 09 Apr 2025 20:51:11 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImJKbFlmWFZJTmVZQW5lVXFOSlI3Z2c9PSIsInZhbHVlIjoiV2lnZ1BOdGQ3SkRZMWZZbUV6R1pSZmU1SGozQnppQ2NacGFkdkFVYkhYUE8wM08yWTVFSnFPai9xcjlBUEN3dTJtYVAzMFBvRzBhdXNROUU2d3owQXk2b0g0ZkRvanNrb2lNUWFqWHd0NXB2ZHdyZDYwZ1J1dnhlWkl1K2N5QTciLCJtYWMiOiJjNTczMGFiOTJhOGRmYjVlMmJkMDdjNzFjNDM3Zjc1ZTg2MWY5MGUyZTQ5MTdlODBmMWI1ZDJiNzgwMmM5ZGYzIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:51:12 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6ImJKbFlmWFZJTmVZQW5lVXFOSlI3Z2c9PSIsInZhbHVlIjoiV2lnZ1BOdGQ3SkRZMWZZbUV6R1pSZmU1SGozQnppQ2NacGFkdkFVYkhYUE8wM08yWTVFSnFPai9xcjlBUEN3dTJtYVAzM" 1 => "6valley1724088324_session=eyJpdiI6IjBCSGk0RTZ1WEEydHVJWnh1K1VHVWc9PSIsInZhbHVlIjoibzBiWHBTK1k3RklTa09lSjF5TVpzaVdDdE43UXRMMFhjRnFjYzhKano1aDRyVjhUQ3FTQnlIV1pHL2llMXNLc0FFdUJRbXg1M3pld2RxVG0zNERIeGhZR0duNlhYaU5UMDN1MDA2b1Y2em5tZktXVHZnV05rZTJvMVhpdWc3aFciLCJtYWMiOiI5OTNmZDEwYWI4NzMyMjYwOTljZTg0ZjJlM2ZjNjQ5MzliYzIxZjdkZDI0NTYyOTg4ZDY1NzllYjk3MDM4NTdkIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:51:12 GMT; Max-Age=3600; path=/; httponly6valley1724088324_session=eyJpdiI6IjBCSGk0RTZ1WEEydHVJWnh1K1VHVWc9PSIsInZhbHVlIjoibzBiWHBTK1k3RklTa09lSjF5TVpzaVdDdE43UXRMMFhjRnFjYzhKano1aDRyVjhUQ3FTQnlIV1pHL2" 2 => "popup_banner=eyJpdiI6IkszQkhsY2ZUa1llYW54elYycnAwMkE9PSIsInZhbHVlIjoibUlRcmFZUDVMRG8wTHlKUlJjTGdkcmFlakczcnJYTUY5UlhoL2lpQklmbG9kSnFLT3F2c0tBVWZFSTFkRlVoUyIsIm1hYyI6IjBjNTUwMDI0NjE4MTkxZmJhNmMyMDM2MzAxNTNiODRiMDY1ZTQzMTYwOGNmODk3YjIyMDE0NTMyZThiZTY5MzgiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 09 Apr 2025 20:52:12 GMT; Max-Age=60; path=/; httponlypopup_banner=eyJpdiI6IkszQkhsY2ZUa1llYW54elYycnAwMkE9PSIsInZhbHVlIjoibUlRcmFZUDVMRG8wTHlKUlJjTGdkcmFlakczcnJYTUY5UlhoL2lpQklmbG9kSnFLT3F2c0tBVWZFSTFkRlVoUyIsIm1" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImJKbFlmWFZJTmVZQW5lVXFOSlI3Z2c9PSIsInZhbHVlIjoiV2lnZ1BOdGQ3SkRZMWZZbUV6R1pSZmU1SGozQnppQ2NacGFkdkFVYkhYUE8wM08yWTVFSnFPai9xcjlBUEN3dTJtYVAzMFBvRzBhdXNROUU2d3owQXk2b0g0ZkRvanNrb2lNUWFqWHd0NXB2ZHdyZDYwZ1J1dnhlWkl1K2N5QTciLCJtYWMiOiJjNTczMGFiOTJhOGRmYjVlMmJkMDdjNzFjNDM3Zjc1ZTg2MWY5MGUyZTQ5MTdlODBmMWI1ZDJiNzgwMmM5ZGYzIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:51:12 GMT; path=/XSRF-TOKEN=eyJpdiI6ImJKbFlmWFZJTmVZQW5lVXFOSlI3Z2c9PSIsInZhbHVlIjoiV2lnZ1BOdGQ3SkRZMWZZbUV6R1pSZmU1SGozQnppQ2NacGFkdkFVYkhYUE8wM08yWTVFSnFPai9xcjlBUEN3dTJtYVAzM" 1 => "6valley1724088324_session=eyJpdiI6IjBCSGk0RTZ1WEEydHVJWnh1K1VHVWc9PSIsInZhbHVlIjoibzBiWHBTK1k3RklTa09lSjF5TVpzaVdDdE43UXRMMFhjRnFjYzhKano1aDRyVjhUQ3FTQnlIV1pHL2llMXNLc0FFdUJRbXg1M3pld2RxVG0zNERIeGhZR0duNlhYaU5UMDN1MDA2b1Y2em5tZktXVHZnV05rZTJvMVhpdWc3aFciLCJtYWMiOiI5OTNmZDEwYWI4NzMyMjYwOTljZTg0ZjJlM2ZjNjQ5MzliYzIxZjdkZDI0NTYyOTg4ZDY1NzllYjk3MDM4NTdkIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:51:12 GMT; path=/; httponly6valley1724088324_session=eyJpdiI6IjBCSGk0RTZ1WEEydHVJWnh1K1VHVWc9PSIsInZhbHVlIjoibzBiWHBTK1k3RklTa09lSjF5TVpzaVdDdE43UXRMMFhjRnFjYzhKano1aDRyVjhUQ3FTQnlIV1pHL2" 2 => "popup_banner=eyJpdiI6IkszQkhsY2ZUa1llYW54elYycnAwMkE9PSIsInZhbHVlIjoibUlRcmFZUDVMRG8wTHlKUlJjTGdkcmFlakczcnJYTUY5UlhoL2lpQklmbG9kSnFLT3F2c0tBVWZFSTFkRlVoUyIsIm1hYyI6IjBjNTUwMDI0NjE4MTkxZmJhNmMyMDM2MzAxNTNiODRiMDY1ZTQzMTYwOGNmODk3YjIyMDE0NTMyZThiZTY5MzgiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 09-Apr-2025 20:52:12 GMT; path=/; httponlypopup_banner=eyJpdiI6IkszQkhsY2ZUa1llYW54elYycnAwMkE9PSIsInZhbHVlIjoibUlRcmFZUDVMRG8wTHlKUlJjTGdkcmFlakczcnJYTUY5UlhoL2lpQklmbG9kSnFLT3F2c0tBVWZFSTFkRlVoUyIsIm1" ] ]
        session_attributes
        0 of 0
        array:23 [ "storage_connection_type" => "public" "company_web_logo" => array:3 [ "key" => "2024-10-06-6702a7946cf56.webp" "path" => "/storage/company/2024-10-06-6702a7946cf56.webp" "status" => 200 ] "decimal_point_settings" => 3 "product_brand" => 1 "digital_product" => 1 "business_mode" => "multi" "currency_model" => "single_currency" "language" => array:3 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => false ] 1 => array:6 [ "id" => 2 "name" => "Arabic" "direction" => "rtl" "code" => "ae" "status" => 0 "default" => false ] 2 => array:6 [ "id" => 3 "name" => "العربية" "direction" => "rtl" "code" => "kw" "status" => 1 "default" => true ] ] "local" => "kw" "direction" => "rtl" "system_default_currency" => 12 "system_default_currency_info" => App\Models\Currency {#1562 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #escapeWhenCastingToString: false #attributes: array:8 [ "id" => 12 "name" => "Kwait dainar" "symbol" => "KWD" "code" => "KWD" "exchange_rate" => "1" "status" => 1 "created_at" => "2021-06-27 13:39:37" "updated_at" => "2021-06-27 13:39:37" ] #original: array:8 [ "id" => 12 "name" => "Kwait dainar" "symbol" => "KWD" "code" => "KWD" "exchange_rate" => "1" "status" => 1 "created_at" => "2021-06-27 13:39:37" "updated_at" => "2021-06-27 13:39:37" ] #changes: [] #casts: array:4 [ "id" => "integer" "status" => "boolean" "created_at" => "datetime" "updated_at" => "datetime" ] #classCastCache: [] #attributeCastCache: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true +usesUniqueIds: false #hidden: [] #visible: [] #fillable: array:5 [ 0 => "name" 1 => "symbol" 2 => "code" 3 => "exchange_rate" 4 => "status" ] #guarded: array:1 [ 0 => "*" ] } "currency_code" => "KWD" "currency_symbol" => "KWD" "currency_exchange_rate" => "1" "_token" => "m15sffZbbk0hrgHOGK6nky3LCiJEDeTUbnmXXK7p" "guest_id" => 226508 "_flash" => array:2 [ "new" => [] "old" => [] ] "_previous" => array:1 [ "url" => "https://mybunyan.com" ] "company_name" => "Souq Bunyan" "currency_symbol_position" => "right" "company_email" => "info@bunyan.shop" "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-09 23:51:12GET/682162072107