وضع السمة
العملة
0
  • دينموهات وغطاسات
مسح الكل

هل لديك مشروع أو طلبية كبيرة؟

اطلب عرض سعر خاص لمشروعك الآن عبر الواتساب.😊✅

01
توصيل سريع لكل المحافظات
نصل بطلبك إلى باب بيتك أو مشروعك أينما كنت في اليمن
02
جودة عالية ومضمونة
نتعامل مع أفضل الموردين والوكلاء لنضمن لك منتجات أصلية تدوم طويلاً.
03
استشارة فنية متخصصة
فريقنا من الخبراء جاهز لمساعدتك في اختيار المنتجات المناسبة لمشروعك. تواصل معنا!
04
كل ما تحتاجه في مكان واحد
تصفح آلاف المنتجات من مواد بناء، سباكة، كهرباء، وديكورات لتغطية كل احتياجات مشروعك.
05
أسعار تنافسية وعروض مستمرة
نقدم لك أفضل الأسعار في السوق مع عروض خاصة للمقاولين وأصحاب المشاريع.
06
اطلب بسهولة وأمان
تجربة تسوق إلكترونية سهلة مع خيارات دفع متنوعة وآمنة تناسب الجميع.
لافتة
منتجات أصلية ومضمونة
نضمن جودة وأصالة كل منتجاتنا.
لافتة
دعم فني متواجد
فريقنا جاهز لمساعدتك في أي وقت.
لافتة
دفع آمن 100%
خيارات دفع متنوعة ومؤمنة بالكامل.
لافتة
سياسة إرجاع مرنة
رضاك هو أولويتنا
دردشة معنا على واتساب
SettingsRequest history8.3.24PHP Version6.9sRequest Duration1GBMemory UsageGET products
status
200 OK
full_url
http://awin-ye.com/products?category_id=420&data_from=category&page=1
action_name
products
controller_action
App\Http\Controllers\Web\ProductListController@products
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
status
200 OK
full_url
http://awin-ye.com/products?category_id=420&data_from=category&page=1
action_name
products
controller_action
App\Http\Controllers\Web\ProductListController@products
uri
GET products
controller
App\Http\Controllers\Web\ProductListController@products
namespace
App\Http\Controllers\Web
file
app/Http/Controllers/Web/ProductListController.php:40-52
middleware
web, websiteFeatureMiddleware, maintenance_mode, guestCheck
duration
6.91s
peak_memory
1.4GB
response
text/html; charset=UTF-8
request_format
html
request_query
0 of 0
array:3 [ "category_id" => "420" "data_from" => "category" "page" => "1" ]
request_request
[]
request_headers
0 of 0
array:18 [ "host" => array:1 [ 0 => "awin-ye.com" ] "scheme" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "216.73.216.41" ] "connection" => array:1 [ 0 => "close" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 04 Sep 2025 00:09:52 GMT" ] ]
session_attributes
0 of 0
array:9 [ "_token" => "iJT0aybmXzf4iFKxWyjRR9hqOFtinpS1XDDJ5Cvs" "guest_id" => 14810 "local" => "ar" "direction" => "rtl" "system_default_currency_info" => App\Models\Currency {#341930 #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" => 8 "name" => "ريال يمني" "symbol" => "YER" "code" => "YER" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-02-04 23:56:28" "updated_at" => "2025-08-28 00:37:31" ] #original: array:8 [ "id" => 8 "name" => "ريال يمني" "symbol" => "YER" "code" => "YER" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-02-04 23:56:28" "updated_at" => "2025-08-28 00:37:31" ] #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" => "YER" "currency_symbol" => "YER" "currency_exchange_rate" => "1" "usd" => 0.0018719580681393 ]
    • Booting (3.03ms)time
    • Application (6.9s)time
    • Routing (1.81ms)
    • Preparing Response (5.99s)
    • 1 x Application (99.96%)
      6.90s
      1 x Preparing Response (86.69%)
      5.99s
      1 x Booting (0.04%)
      3.03ms
      1 x Routing (0.03%)
      1.81ms
      400 templates were rendered
      • 1x theme-views.product.viewview.blade.php#?blade
      • 2x livewire.placeholderplaceholder.blade.php#?blade
      • 2x __components::df162b49d022848d5015386a951ebf17df162b49d022848d5015386a951ebf17.blade.php#?blade
      • 1x theme-views.partials._categories_categories.blade.php#?blade
      • 1x theme-views.partials.products._products-list-aside_products-list-aside.blade.php#?blade
      • 1x livewire.theme_fashion.categories.categories-in-sidebarcategories-in-sidebar.blade.php#?blade
      • 365x theme-views.partials.products.aside_child_categoriesaside_child_categories.blade.php#?blade
      • 1x livewire.theme_fashion.colors.colors-in-sidebarcolors-in-sidebar.blade.php#?blade
      • 1x theme-views.product._selected_filter_tags_selected_filter_tags.blade.php#?blade
      • 1x theme-views.product._ajax-products_ajax-products.blade.php#?blade
      • 6x theme-views.partials._products-list-single-card_products-list-single-card.blade.php#?blade
      • 1x theme-views.partials._how-to-section_how-to-section.blade.php#?blade
      • 1x theme-views.layouts.appapp.blade.php#?blade
      • 1x theme-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
      • 1x laravelpwa::metameta.blade.php#?blade
      • 1x theme-views.loadingloading.blade.php#?blade
      • 1x theme-views.layouts.partials._header_header.blade.php#?blade
      • 1x theme-views.layouts.partials._cart_cart.blade.php#?blade
      • 1x theme-views.layouts.partials._mobile-top-cart_mobile-top-cart.blade.php#?blade
      • 1x theme-views.layouts.partials.modal._quick-view_quick-view.blade.php#?blade
      • 1x theme-views.layouts.partials.modal._buy-now_buy-now.blade.php#?blade
      • 1x partials.modals.install-app-modalinstall-app-modal.blade.php#?blade
      • 1x theme-views.layouts.partials._cart-floating_cart-floating.blade.php#?blade
      • 1x theme-views.layouts.partials._alert-message_alert-message.blade.php#?blade
      • 1x theme-views.layouts.partials.modal._initial_initial.blade.php#?blade
      • 1x theme-views.layouts.partials.modal._alert_alert.blade.php#?blade
      • 1x theme-views.layouts.partials._app-bar_app-bar.blade.php#?blade
      • 1x theme-views.layouts.partials._footer_footer.blade.php#?blade
      • 1x shard.shard_jsshard_js.blade.php#?blade
      uri
      GET products
      middleware
      web, websiteFeatureMiddleware, maintenance_mode, guestCheck
      controller
      App\Http\Controllers\Web\ProductListController@products
      namespace
      App\Http\Controllers\Web
      as
      products
      file
      app/Http/Controllers/Web/ProductListController.php:40-52
      40 statements were executed (15 duplicates)Show only duplicates135ms
      • GuestMiddleware.php#24awin1.69msinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.41', '2025-09-04 03:09:52', '2025-09-04 03:09:52')
        Bindings
        • 0: 216.73.216.41
        • 1: 2025-09-04 03:09:52
        • 2: 2025-09-04 03:09:52
        Backtrace
        • middleware::guestCheck:24
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • middleware::maintenance_mode:30
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • middleware::websiteFeatureMiddleware:21
      • BuildsAdjacencyListQueries.php#26awin620μsselect `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 ('physical')) as `product_count` from `categories` where `parent_id` = '420' and `status` = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: physical
        • 7: 420
        • 8: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • app/Utils/category-manager.php:183
        • app/Http/Controllers/Web/ProductListController.php:209
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • settings.php#18awin700μsselect * from `business_settings`
        Backtrace
        • app/Utils/settings.php:18
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Utils/settings.php:17
        • app/Utils/category-manager.php:185
        • app/Http/Controllers/Web/ProductListController.php:209
      • ProductListController.php#211awin540μsselect * from `business_settings` where (`type` = 'banner_product_list_page') and json_contains(`value`, '{\"status\":\"1\"}') limit 1
        Bindings
        • 0: banner_product_list_page
        • 1: {"status":"1"}
        Backtrace
        • app/Http/Controllers/Web/ProductListController.php:211
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • BuildsAdjacencyListQueries.php#26awin350μsselect `id`, `name` from `categories` where `id` = '420' and `status` = 1
        Bindings
        • 0: 420
        • 1: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • app/Http/Controllers/Web/ProductListController.php:224
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • ProductListController.php#224awin400μsselect * from `translations` where `translations`.`translationable_id` in (420) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Category
        • 1: ar
        Backtrace
        • app/Http/Controllers/Web/ProductListController.php:224
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • product-manager.php#1901awin750μsselect `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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 ('physical') order by `priority` desc)) as `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`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 ('physical') order by `priority` desc))
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: physical
        • 7: 1
        • 8: 1
        • 9: 1
        • 10: approved
        • 11: admin
        • 12: 1
        • 13: physical
        Backtrace
        • app/Utils/product-manager.php:1901
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1910awin22.75msselect `id` from `products` where (`product_type` = 'digital') and 1 = 1 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 ('physical') order by `priority` desc
        Bindings
        • 0: digital
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/product-manager.php:1910
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1916awin590μsselect `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`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 ('physical') order by `priority` desc)) as `digital_product_author_count` from `authors`
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: approved
        • 4: admin
        • 5: 1
        • 6: physical
        Backtrace
        • app/Utils/product-manager.php:1916
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • product-manager.php#1924awin20.69msselect `id` from `products` where (`product_type` = 'digital') and 1 = 1 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 ('physical') order by `priority` desc
        Bindings
        • 0: digital
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/product-manager.php:1924
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BuildsAdjacencyListQueries.php#26awin330μsselect * from `categories` where `id` in ('420') and `status` = 1
        Bindings
        • 0: 420
        • 1: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • app/Utils/product-manager.php:1978
        • app/Utils/product-manager.php:1973
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/product-manager.php:1968
      • product-manager.php#1978awin350μsselect * from `translations` where `translations`.`translationable_id` in (420) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Category
        • 1: ar
        Backtrace
        • app/Utils/product-manager.php:1978
        • app/Utils/product-manager.php:1973
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/product-manager.php:1968
        • app/Http/Controllers/Web/ProductListController.php:242
      • product-manager.php#1299awin60.67msselect `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (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 (`category_id` in (420) or exists (select * from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `products`.`id` = `product_categories`.`product_id` and (`category_id` in (420)) and `status` = 1)) 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 ('physical') order by `reviews_avg_rating` desc, `reviews_avg_rating` desc, `priority` desc
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 420
        • 4: 420
        • 5: 1
        • 6: 1
        • 7: 1
        • 8: 1
        • 9: approved
        • 10: admin
        • 11: 1
        • 12: physical
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BuildsAdjacencyListQueries.php#26awin320μsselect * from `categories` where `categories`.`id` in (341) and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
      • product-manager.php#1299awin330μsselect * from `translations` where `translations`.`translationable_id` in (341) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Category
        • 1: ar
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BuildsAdjacencyListQueries.php#26awin490μsselect `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
      • product-manager.php#1299awin360μsselect * from `translations` where `translations`.`translationable_id` in (367, 420) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Category
        • 1: ar
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin380μsselect * from `reviews` where `reviews`.`product_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `delivery_man_id` is null and `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin410μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `status` = 1 group by `product_id`
        Bindings
        • 0: 1
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin320μsselect * from `sellers` where `sellers`.`id` in (36)
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin390μsselect * from `shops` where `shops`.`seller_id` in (36)
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin600μsselect * from `wishlists` where `wishlists`.`product_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `customer_id` = 0
        Bindings
        • 0: 0
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin310μsselect * from `product_compares` where `product_compares`.`product_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `user_id` = 0
        Bindings
        • 0: 0
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • product-manager.php#1299awin340μsselect * from `translations` where `translations`.`translationable_id` in (9475, 9476, 9477, 9478, 9479, 9480) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Product
        • 1: ar
        Backtrace
        • app/Utils/product-manager.php:1299
        • app/Utils/product-manager.php:2327
        • app/Http/Controllers/Web/ProductListController.php:242
        • app/Http/Controllers/Web/ProductListController.php:49
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BuildsAdjacencyListQueries.php#26awin370μsselect * from `categories` where `categories`.`id` = '420' and `status` = 1 limit 1
        Bindings
        • 0: 420
        • 1: 1
        Backtrace
        • vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:26
        • view::theme-views.product.view:21
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • view.blade.php#21awin350μsselect * from `translations` where `translations`.`translationable_id` in (420) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'ar'
        Bindings
        • 0: App\Models\Category
        • 1: ar
        Backtrace
        • view::theme-views.product.view:21
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • view.blade.php#21awin360μsselect `banners`.*, `category_banners`.`category_id` as `pivot_category_id`, `category_banners`.`banner_id` as `pivot_banner_id` from `banners` inner join `category_banners` on `banners`.`id` = `category_banners`.`banner_id` where `category_banners`.`category_id` = 420
        Bindings
        • 0: 420
        Backtrace
        • view::theme-views.product.view:21
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • product-manager.php#961awin14.3msselect `colors` from `products` where `colors` != '[]' 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 ('physical') order by `priority` desc
        Bindings
        • 0: []
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/product-manager.php:961
        • app/Livewire/Colors/ColorsInSidebar.php:24
        • vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • currency.php#15awin420μsselect * from `currencies` where `currencies`.`id` = '8' limit 1
        Bindings
        • 0: 8
        Backtrace
        • app/Utils/currency.php:15
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • currency.php#145awin320μsselect * from `currencies` where `code` = 'usd' limit 1
        Bindings
        • 0: usd
        Backtrace
        • app/Utils/currency.php:145
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • _header.blade.php#152awin420μsselect count(*) as aggregate from `brands`
        Backtrace
        • view::theme-views.layouts.partials._header:152
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • cart-manager.php#94awin580μsselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and (`customer_id` = 14810 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 14810
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:94
        • app/Utils/cart-manager.php:53
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:52
        • view::theme-views.layouts.partials._cart:2
      • cart-manager.php#61awin360μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and 0 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/cart-manager.php:61
        • view::theme-views.layouts.partials._cart:2
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • cart-manager.php#94awin500μsselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and (`customer_id` = 14810 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 14810
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:94
        • app/Utils/cart-manager.php:53
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:52
        • view::theme-views.layouts.partials._mobile-top-cart:1
      • cart-manager.php#61awin330μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and 0 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/cart-manager.php:61
        • view::theme-views.layouts.partials._mobile-top-cart:1
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • _header.blade.php#498awin300μsselect count(*) as aggregate from `brands`
        Backtrace
        • view::theme-views.layouts.partials._header:498
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • cart-manager.php#94awin610μsselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and (`customer_id` = 14810 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 14810
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:94
        • app/Utils/cart-manager.php:53
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:52
        • view::theme-views.layouts.partials._cart-floating:1
      • cart-manager.php#61awin350μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and 0 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/cart-manager.php:61
        • view::theme-views.layouts.partials._cart-floating:1
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      • cart-manager.php#94awin540μsselect `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and (`customer_id` = 14810 and `is_guest` = 1) group by `cart_group_id`
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 14810
        • 9: 1
        Backtrace
        • app/Utils/cart-manager.php:94
        • app/Utils/cart-manager.php:53
        • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • app/Utils/cart-manager.php:52
        • view::theme-views.layouts.partials._app-bar:58
      • cart-manager.php#61awin550μsselect * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and `status` = 1 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 ('physical') order by `priority` desc) and 0 = 1
        Bindings
        • 0: 1
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • app/Utils/cart-manager.php:61
        • view::theme-views.layouts.partials._app-bar:58
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22
      Retrieved205Created1UpdatedDeleted
      App\Models\BusinessSetting179BusinessSetting.php#?
      App\Models\Category16Category.php#?
      App\Models\Product6Product.php#?
      App\Models\Currency2Currency.php#?
      App\Models\GuestUser1GuestUser.php#?
      App\Models\Seller1Seller.php#?
      App\Models\Shop1Shop.php#?
      categories.categories-in-sidebar #VimSJr2jEhcQ0JQ1xzX9
      array:4 [ "data" => array:1 [ "categorySelectedId" => "420" ] "name" => "categories.catego...
      colors.colors-in-sidebar #hErPXryMUrx64RXMu8qU
      array:4 [ "data" => [] "name" => "colors.colors-in-sidebar" "component" => "App\Livewire\Color...
          _token
          iJT0aybmXzf4iFKxWyjRR9hqOFtinpS1XDDJ5Cvs
          guest_id
          14810
          local
          ar
          direction
          rtl
          system_default_currency_info
          App\Models\Currency {#341930 #connection: "mysql" #table: "currencies" #primaryKey: "id" #ke...
          currency_code
          YER
          currency_symbol
          YER
          currency_exchange_rate
          1
          usd
          0.0018719580681393
          ClearShow all
          Date ↕MethodURLData
          #12025-09-04 03:09:58GET/products?category_id=420&data_from=category&page=1400402062