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

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

أحدث المنتجات
10.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
المنتجات الجديدة
العلامات التجارية
أدوات الهواء
إنتهى من المخزن
إنتهى من المخزن
منتجات القماش المشمع و PVC
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
التركيبات الصحية
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
0.000KWD
إنتهى من المخزن
0.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
GI Wire و Wire Netting
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
اسطوانة الباب
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
التحكم التلقائي
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
شريط لاصق
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات الطاقة
إنتهى من المخزن
12.000KWD
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات يدوية
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
أدوات الحديقة
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
إنتهى من المخزن
غير موجود
Request history8.3.11PHP Version1.75sRequest Duration14MBMemory UsageGET /Route
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: number_format(): Passing null to parameter #1 ($num) of type float is deprec...
  • warninglog[22:16:45] LOG.warning: addslashes(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (88.34ms)time
  • Application (1.66s)time
  • 1 x Application (94.96%)
    1.66s
    1 x Booting (5.04%)
    88.34ms
    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.33s
    • # 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
      510μ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
      45.17mslaravelcategory-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')
      10.06mslaravelcategory-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'
      490μ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
      290μ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
      157mslaravelcategory-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
      101mslaravelcategory-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.2mslaravelcategory-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.05mslaravelcategory-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'
      620μ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
      490μ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
      500μ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'
      460μ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
      290μ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.33mslaravelproduct-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
      16.67mslaravelproduct-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'
      370μ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
      290μ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
      460μ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\"%'
      10.2mslaravelproduct-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
      15.83mslaravelproduct-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'
      320μ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
      280μ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
      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 '%\"111\"%'
      12.01mslaravelproduct-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
      14.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: %"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'
      460μ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
      260μ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 '%\"96\"%'
      9.1mslaravelproduct-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
      13.16mslaravelproduct-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'
      440μ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
      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
      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 '%\"86\"%'
      9.98mslaravelproduct-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
      990μ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.63mslaravelproduct-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
      14.61mslaravelproduct-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'
      460μ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
      260μ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
      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 '%\"45\"%'
      8.63mslaravelproduct-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
      13.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: %"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'
      610μ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
      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
      280μ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\"%'
      7.94mslaravelproduct-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
      12.49mslaravelproduct-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'
      420μ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
      220μ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
      270μ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\"%'
      10.88mslaravelproduct-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
      15.71mslaravelproduct-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'
      330μ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
      220μ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
      270μ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\"%'
      9mslaravelproduct-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
      15.75mslaravelproduct-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'
      480μ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
      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
      340μ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\"%'
      10.92mslaravelproduct-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
      18.06mslaravelproduct-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'
      430μ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
      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
      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 '%\"157\"%'
      9.36mslaravelproduct-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
      460μ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\"%'
      8.96mslaravelproduct-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
      20.11mslaravelproduct-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'
      440μ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
      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
      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 '%\"159\"%'
      8.73mslaravelproduct-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
      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 '%\"161\"%'
      9.11mslaravelproduct-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
      16.56mslaravelproduct-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'
      470μ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
      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
      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 '%\"162\"%'
      9.81mslaravelproduct-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
      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 '%\"163\"%'
      11.11mslaravelproduct-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
      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 '%\"164\"%'
      11.14mslaravelproduct-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.67mslaravelproduct-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'
      370μ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
      260μ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\"%'
      9.59mslaravelproduct-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
      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 '%\"166\"%'
      9.78mslaravelproduct-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
      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 '%\"168\"%'
      9.17mslaravelproduct-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'))
      68.14mslaravelHomeController.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.02mslaravelHomeController.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')
      18.31mslaravelHomeController.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
      940μ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.23mslaravel
    • 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.94mslaravel
    • 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
      700μ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`
      570μ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'
      1.02mslaravel
    • 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
      770μ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
      570μslaravel
    • select * from `business_settings` where (`type` = 'vacation_add') limit 1
      300μslaravel
    • select * from `business_settings` where (`type` = 'company_name') limit 1
      200μslaravel
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      240μslaravel
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      210μslaravel
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      200μslaravel
    • select * from `business_settings` where (`type` = 'bottom_banner') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'offer_banner') limit 1
      240μslaravel
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      220μslaravel
    • select * from `business_settings` where (`type` = 'temporary_close') limit 1
      230μslaravel
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      240μslaravel
    • select * from `admins` where (`id` = 1) limit 1
      280μslaravel
    • select * from `admins` where (`id` = 1) limit 1
      270μ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
      620μslaravel
    • select count(*) as aggregate from `orders` where (`seller_is` = 'admin')
      230μslaravel
    • select * from `business_settings` where (`type` = 'top_vendor_list_priority') limit 1
      350μslaravel
    • select * from `business_settings` where (`type` = 'featured_product_priority') limit 1
      260μ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.95mslaravel
    • 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
      14.1mslaravel
    • 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'
      560μ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
      290μ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
      940μ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
      300μ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'
      340μslaravel
    • select * from `business_settings` where (`type` = 'new_arrival_product_list_priority') limit 1
      350μ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.87mslaravel
    • 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
      30.03mslaravel
    • 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'
      390μ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
      230μslaravel
    • select * from `brands` where `status` = 1 limit 15
      260μ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'
      360μ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
      540μslaravel
    • select * from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` = 'App\Models\OrderDetail'
      290μslaravel
    • select * from `products` where `status` = 1 and `products`.`id` in (2)
      360μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2) and `delivery_man_id` is null and `status` = 1
      240μslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      310μ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
      440μ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
      260μ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
      330μ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
      20.73mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (699) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      480μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (699) and `delivery_man_id` is null and `status` = 1
      250μslaravel
    • select * from `banners` where `banner_type` = 'Footer Banner' and `theme` = 'default' and `published` = 1 order by `id` desc
      270μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 23 and `storages`.`data_id` is not null
      480μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 22 and `storages`.`data_id` is not null
      280μ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
      300μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 18 and `storages`.`data_id` is not null
      260μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 17 and `storages`.`data_id` is not null
      280μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 16 and `storages`.`data_id` is not null
      300μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 15 and `storages`.`data_id` is not null
      260μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 14 and `storages`.`data_id` is not null
      260μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 13 and `storages`.`data_id` is not null
      260μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 12 and `storages`.`data_id` is not null
      270μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 8 and `storages`.`data_id` is not null
      270μslaravel
    • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
      450μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 7 and `storages`.`data_id` is not null
      390μslaravel
    • select * from `business_settings` where (`type` = 'shop_banner') limit 1
      350μslaravel
    • select * from `business_settings` where (`type` = 'company_fav_icon') limit 1
      230μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 10 and `storages`.`data_id` is not null
      740μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 9 and `storages`.`data_id` is not null
      290μslaravel
    • select * from `business_settings` where (`type` = 'company_reliability') limit 1
      420μ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
      360μslaravel
    • select * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
      340μslaravel
    • select * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
      320μslaravel
    • select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
      310μslaravel
    • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 11 and `storages`.`data_id` is not null
      320μslaravel
    • select * from `business_settings` where (`type` = 'announcement') limit 1
      250μslaravel
    • select `cart_group_id` from `carts` where (`customer_id` = 226430 and `is_guest` = 1) group by `cart_group_id`
      310μslaravel
    • select * from `carts` where 0 = 1
      220μslaravel
    • select `cart_group_id` from `carts` where (`customer_id` = 226430 and `is_guest` = 1) group by `cart_group_id`
      290μslaravel
    • select * from `carts` where 0 = 1
      180μ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
      29.05mslaravel
    • 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')
      5.95mslaravel
    • select * from `translations` where `translations`.`translationable_id` in (2, 2549) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'kw'
      490μslaravel
    • select * from `reviews` where `reviews`.`product_id` in (2, 2549) and `delivery_man_id` is null and `status` = 1
      280μ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
      114mslaravel
    • 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
      68.93mslaravel
    • 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.06mslaravel
    • 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'
      720μ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'
      420μ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
      430μ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
      142mslaravel
    • 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'
      1.02mslaravel
    • 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
      8.47mslaravel
    • select * from `business_settings` where (`type` = 'seller_registration') limit 1
      340μslaravel
    • select * from `business_settings` where (`type` = 'loader_gif') limit 1
      540μslaravel
    • select * from `business_settings` where (`type` = 'country_code') limit 1
      290μ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
      320μslaravel
    • select * from `business_settings` where (`type` = 'refund-policy') limit 1
      400μslaravel
    • select * from `business_settings` where (`type` = 'return-policy') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
      310μslaravel
    • select * from `business_settings` where (`type` = 'company_phone') limit 1
      240μslaravel
    • select * from `business_settings` where (`type` = 'company_email') limit 1
      230μslaravel
    • select * from `business_settings` where (`type` = 'shop_address') limit 1
      270μslaravel
    • select * from `business_settings` where (`type` = 'whatsapp') limit 1
      270μ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
        tkY1Hw7oDbF4v4T5rxWyHjZAtjXNrczzI2THNWzD
        guest_id
        226430
        _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=eyJpdiI6InludExHQWo1NmJyc3dUYmsrY0FHZkE9PSIsInZhbHVlIjoiYUtmM1ExM0l3TTRIR1U3UEFHVjlkOW9mUk11SzY3ZmpBMVM5NkZBdE0xd0JnbTBNTFRRbWM1aVk3MndsODZHRFZBYUxKNHlnZFgzQjhLNWNmRVlVY3AwWFJIZEpaQVNPeVFDZ1p4Y3RneTJmTktFTlp2MTc4Sm9XdXlCTUd3ZVMiLCJtYWMiOiI0ODA0YmE1NWVjZjIzOTEzYmZlZjQ0ZjgzMjRiYjA5NjE4MWUxNWRjN2Y4NmRjZWZmYzY0NTk5ZTBkNThhNzYyIiwidGFnIjoiIn0%3D; 6valley1724088324_session=eyJpdiI6IkRtdFZMd0dkMW05YUdJc2YyRkdBenc9PSIsInZhbHVlIjoiQTFPS0JLMDJIdnNxZnNzbW10Z2ZmVWJWYjFKaks4RnVhaU03WFhmcExwQWJNQjBiYVJwNGgrZFIwWG1ubVhBdTBEYW1xa3ltRGNSeThwSVg0TUgzYTJydHp5U1FwUnlMa0RrT0FJczBnWEozSWFtMFYvQ05iRW5QUFZ2T3VTaVEiLCJtYWMiOiI2YTlkOGNkMzc1MDU2NmI0YmU1NDczMDk4ZmFiYzAyNjk3ZTBiOWJlMDA3Y2NiMjBhODRlN2I3N2Q2OGEwMDdhIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InludExHQWo1NmJyc3dUYmsrY0FHZkE9PSIsInZhbHVlIjoiYUtmM1ExM0l3TTRIR1U3UEFHVjlkOW9mUk11SzY3ZmpBMVM5NkZBdE0xd0JnbTBNTFRRbWM1aVk3MndsODZHRFZBYUxKN" ] "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" => "tkY1Hw7oDbF4v4T5rxWyHjZAtjXNrczzI2THNWzD" "6valley1724088324_session" => "XGBx9aCZGyWBxmv3oUtrYR16r96CSS0U1sqtZ2j1" ]
        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 19:16:45 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjYvalpzbDJLN2VsOE93REppc3pQZ0E9PSIsInZhbHVlIjoiK3lHMFlEVDNUaDV2Nm1hRGdoU2djOVRNMHdHQmhNNHg2UEdJT3RxV3VVcnJMOUFQZzJuS0JEZ1pMa0NQcUFnbFpIQ1hzQUVOYllLOTgyV1pzeDBQZFE5UVo4RTVjYlYxd1B3V2tLbklFY21kL294VDk0Z3VWZTNjOEJXMlJlV2kiLCJtYWMiOiI3YWYwZGVmNjQyYzM3MTFkOWE2ZjA4NThhNjI0MDIxYjYxMmM2NzVmODgwODAwZjlhODg0ODBiNDBlNDUzMzcwIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 20:16:45 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IjYvalpzbDJLN2VsOE93REppc3pQZ0E9PSIsInZhbHVlIjoiK3lHMFlEVDNUaDV2Nm1hRGdoU2djOVRNMHdHQmhNNHg2UEdJT3RxV3VVcnJMOUFQZzJuS0JEZ1pMa0NQcUFnbFpIQ1hzQ" 1 => "6valley1724088324_session=eyJpdiI6IldTMEJRSXZNOGl3M1ZGWWs2VG5PSFE9PSIsInZhbHVlIjoieUU2Z3I0MGJrbXlIRDZDcGNDUDdkUjlOUWlpWWtpd2hZZ0xyUHFUMnVjdnVSK0Rsc2FDVzVWR24vdk9CK3Nnai9NaU8rNnNPWWcxMiswZjhReGFuNzNuRmRrWUVzWlhHUVFBS0RSenFWZ0tCK01XVUZZQzY0MG11T0haZmN5RVIiLCJtYWMiOiIxOWRmZGU5Zjk1ZDliNDRhODdlZWZlZDc1NTlhZjZkNDkxMzE0OWU2OWE5NDg3MzZmNDcwNDdiNjNmMDE4OGI4IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 20:16:45 GMT; Max-Age=3600; path=/; httponly6valley1724088324_session=eyJpdiI6IldTMEJRSXZNOGl3M1ZGWWs2VG5PSFE9PSIsInZhbHVlIjoieUU2Z3I0MGJrbXlIRDZDcGNDUDdkUjlOUWlpWWtpd2hZZ0xyUHFUMnVjdnVSK0Rsc2FDVzVWR24vdk" 2 => "popup_banner=eyJpdiI6IlliUVNiVHg1MnNMejJ6NFFTaGdaeWc9PSIsInZhbHVlIjoiK1NaVGdXajZxUTgwb04rUHlVZ2JNKzEvOWMzN3hPV1NBT0JpeVlaNXJVQ01iUzZWMGg3ZUw3OEozTWpPWkJBLyIsIm1hYyI6IjVhNTFjMGM1MTNhYTI4YjI0MGZmYzFmYTY3MDE4NDBkNDIzMjRhYjU0MGE5YTY4N2ZmZWU2YmIwMGU2ZmZkYzAiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 09 Apr 2025 19:17:45 GMT; Max-Age=60; path=/; httponlypopup_banner=eyJpdiI6IlliUVNiVHg1MnNMejJ6NFFTaGdaeWc9PSIsInZhbHVlIjoiK1NaVGdXajZxUTgwb04rUHlVZ2JNKzEvOWMzN3hPV1NBT0JpeVlaNXJVQ01iUzZWMGg3ZUw3OEozTWpPWkJBLyIsIm1" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjYvalpzbDJLN2VsOE93REppc3pQZ0E9PSIsInZhbHVlIjoiK3lHMFlEVDNUaDV2Nm1hRGdoU2djOVRNMHdHQmhNNHg2UEdJT3RxV3VVcnJMOUFQZzJuS0JEZ1pMa0NQcUFnbFpIQ1hzQUVOYllLOTgyV1pzeDBQZFE5UVo4RTVjYlYxd1B3V2tLbklFY21kL294VDk0Z3VWZTNjOEJXMlJlV2kiLCJtYWMiOiI3YWYwZGVmNjQyYzM3MTFkOWE2ZjA4NThhNjI0MDIxYjYxMmM2NzVmODgwODAwZjlhODg0ODBiNDBlNDUzMzcwIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 20:16:45 GMT; path=/XSRF-TOKEN=eyJpdiI6IjYvalpzbDJLN2VsOE93REppc3pQZ0E9PSIsInZhbHVlIjoiK3lHMFlEVDNUaDV2Nm1hRGdoU2djOVRNMHdHQmhNNHg2UEdJT3RxV3VVcnJMOUFQZzJuS0JEZ1pMa0NQcUFnbFpIQ1hzQ" 1 => "6valley1724088324_session=eyJpdiI6IldTMEJRSXZNOGl3M1ZGWWs2VG5PSFE9PSIsInZhbHVlIjoieUU2Z3I0MGJrbXlIRDZDcGNDUDdkUjlOUWlpWWtpd2hZZ0xyUHFUMnVjdnVSK0Rsc2FDVzVWR24vdk9CK3Nnai9NaU8rNnNPWWcxMiswZjhReGFuNzNuRmRrWUVzWlhHUVFBS0RSenFWZ0tCK01XVUZZQzY0MG11T0haZmN5RVIiLCJtYWMiOiIxOWRmZGU5Zjk1ZDliNDRhODdlZWZlZDc1NTlhZjZkNDkxMzE0OWU2OWE5NDg3MzZmNDcwNDdiNjNmMDE4OGI4IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 20:16:45 GMT; path=/; httponly6valley1724088324_session=eyJpdiI6IldTMEJRSXZNOGl3M1ZGWWs2VG5PSFE9PSIsInZhbHVlIjoieUU2Z3I0MGJrbXlIRDZDcGNDUDdkUjlOUWlpWWtpd2hZZ0xyUHFUMnVjdnVSK0Rsc2FDVzVWR24vdk" 2 => "popup_banner=eyJpdiI6IlliUVNiVHg1MnNMejJ6NFFTaGdaeWc9PSIsInZhbHVlIjoiK1NaVGdXajZxUTgwb04rUHlVZ2JNKzEvOWMzN3hPV1NBT0JpeVlaNXJVQ01iUzZWMGg3ZUw3OEozTWpPWkJBLyIsIm1hYyI6IjVhNTFjMGM1MTNhYTI4YjI0MGZmYzFmYTY3MDE4NDBkNDIzMjRhYjU0MGE5YTY4N2ZmZWU2YmIwMGU2ZmZkYzAiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 09-Apr-2025 19:17:45 GMT; path=/; httponlypopup_banner=eyJpdiI6IlliUVNiVHg1MnNMejJ6NFFTaGdaeWc9PSIsInZhbHVlIjoiK1NaVGdXajZxUTgwb04rUHlVZ2JNKzEvOWMzN3hPV1NBT0JpeVlaNXJVQ01iUzZWMGg3ZUw3OEozTWpPWkJBLyIsIm1" ] ]
        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" => "tkY1Hw7oDbF4v4T5rxWyHjZAtjXNrczzI2THNWzD" "guest_id" => 226430 "_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 22:16:45GET/682162072107