Hard n Soft

Click to view

Hard n Soft

(0)

0 التقييمات
6 الطلبات

0%

تقييم إيجابي

1

المنتجات

Search product

0 العنصر

ترتيب حسب :

Show product :

السعر

الحد الأدنى

الحد الأقصى

Product Type

المنتجات

أجهزة الكمبيوتر

العلامات التجارية

إيسوس 1

التقييمات

جميع المنتجات

عرض شبكي
عرض قائمة

لا يوجد منتجات!

Fast shipping

Fast shipping all across the country

منتجات أصلية

100% منتجات أصلية

100% دفع امن

نحن نضمن المعاملات الآمنة

24/7 مركز الدعم

نحن نضمن دعم الجودة

warninglog[22:17:40] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[22:17:40] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[22:17:40] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...

Booting (77.47ms)time
Application (192ms)time
1 x Application (71.22%)
192ms
1 x Booting (28.77%)
77.47ms

27 templates were rendered

theme-views.seller-views.shopviewshopview.blade.php#?blade
theme-views.seller-views.partials._shop-sidebar_shop-sidebar.blade.php#?blade
theme-views.partials._products_review_partials_products_review_partials.blade.php#?blade
theme-views.product._ajax-products_ajax-products.blade.php#?blade
theme-views.layouts.appapp.blade.php#?blade
theme-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
system-partials._analytics_script_analytics_script.blade.php#?blade
theme-views.layouts.partials._alert-message_alert-message.blade.php#?blade
theme-views.layouts.partials._header_header.blade.php#?blade
theme-views.layouts.partials._cart_cart.blade.php#?blade
theme-views.layouts.partials._settings-sidebar_settings-sidebar.blade.php#?blade
theme-views.layouts.partials._feature_feature.blade.php#?blade
theme-views.layouts.partials._footer_footer.blade.php#?blade
theme-views.layouts.partials._app-bar_app-bar.blade.php#?blade
theme-views.layouts.partials.modal._register_register.blade.php#?blade
theme-views.layouts.partials.modal._login_login.blade.php#?blade
theme-views.layouts.auth-partials._email_email.blade.php#?blade
theme-views.layouts.auth-partials._password_password.blade.php#?blade
theme-views.layouts.auth-partials._remember-me_remember-me.blade.php#?blade
theme-views.layouts.auth-partials._recaptcha_recaptcha.blade.php#?blade
theme-views.layouts.partials.modal._quick-view_quick-view.blade.php#?blade
theme-views.layouts.partials.modal._buy-now_buy-now.blade.php#?blade
theme-views.layouts.partials.modal._initial_initial.blade.php#?blade
theme-views.layouts.partials._translate-text-for-js_translate-text-for-js.blade.php#?blade
theme-views.layouts.partials._route-for-js_route-for-js.blade.php#?blade
theme-views.layouts.main-scriptmain-script.blade.php#?blade
theme-views.layouts._firebase-script_firebase-script.blade.php#?blade

uri: GET shopView/{id}
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\ShopViewController@seller_shop
namespace: App\Http\Controllers\Web
prefix
where
as: shopView
file: app/Http/Controllers/Web/ShopViewController.php:70-79

57 statements were executed (20 duplicates)Show only duplicates15.53ms

GuestMiddleware.php#24u195453480_yalla_n_db220μs

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.145.134.113', '2025-04-12 22:17:40', '2025-04-12 22:17:40')

Bindings	0: 3.145.134.113 1: 2025-04-12 22:17:40 2: 2025-04-12 22:17:40
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::api_lang:22

ShopViewController.php#424u195453480_yalla_n_db200μsselect * from `shops` where `id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:424 app/Http/Controllers/Web/ShopViewController.php:117 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#429u195453480_yalla_n_db170μsselect * from `sellers` where (`status` = 'approved') and `sellers`.`id` = 4 limit 1

Bindings	0: approved 1: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:429 app/Http/Controllers/Web/ShopViewController.php:117 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#119u195453480_yalla_n_db130μsselect * from `shops` where `id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:119 app/Http/Controllers/Web/ShopViewController.php:76 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#2340u195453480_yalla_n_db470μs

select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count` from `products` where (`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 `user_id` = 4)

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: seller 9: 4
Backtrace	app/Utils/product-manager.php:2340 app/Http/Controllers/Web/ShopViewController.php:120 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#2340u195453480_yalla_n_db170μs

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (27) and `status` = 1 group by `product_id`

Bindings	0: 1
Backtrace	app/Utils/product-manager.php:2340 app/Http/Controllers/Web/ShopViewController.php:120 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#2340u195453480_yalla_n_db210μs

select * from `translations` where `translations`.`translationable_id` in (27) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'qa'

Bindings	0: App\Models\Product 1: qa
Backtrace	app/Utils/product-manager.php:2340 app/Http/Controllers/Web/ShopViewController.php:120 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#2340u195453480_yalla_n_db150μsselect * from `reviews` where `reviews`.`product_id` in (27) and `delivery_man_id` is null and `status` = 1

Bindings	0: 1
Backtrace	app/Utils/product-manager.php:2340 app/Http/Controllers/Web/ShopViewController.php:120 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1911u195453480_yalla_n_db410μs

select `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 (`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 `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 (`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')))

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 1 9: approved 10: admin 11: 1 12: digital 13: physical
Backtrace	app/Utils/product-manager.php:1911 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1920u195453480_yalla_n_db390μs

select `id` from `products` where (`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 (`product_type` = 'digital') and 1 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital
Backtrace	app/Utils/product-manager.php:1920 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1926u195453480_yalla_n_db260μs

select `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 (`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 `digital_product_author_count` from `authors`

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	app/Utils/product-manager.php:1926 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1934u195453480_yalla_n_db300μs

select `id` from `products` where (`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 (`product_type` = 'digital') and 1 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital
Backtrace	app/Utils/product-manager.php:1934 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1981u195453480_yalla_n_db310μsselect * from `categories`

Backtrace

app/Utils/product-manager.php:1981
vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
app/Utils/product-manager.php:1977
app/Http/Controllers/Web/ShopViewController.php:121
app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1981u195453480_yalla_n_db410μs

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 11, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'qa'

Bindings	0: App\Models\Category 1: qa
Backtrace	app/Utils/product-manager.php:1981 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/product-manager.php:1977 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1987u195453480_yalla_n_db150μsselect * from `categories` where `id` in (null)

Bindings	0:
Backtrace	app/Utils/product-manager.php:1987 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/product-manager.php:1977 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1988u195453480_yalla_n_db130μsselect * from `categories` where `id` in (null)

Bindings	0:
Backtrace	app/Utils/product-manager.php:1988 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/product-manager.php:1977 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1989u195453480_yalla_n_db130μsselect * from `categories` where `id` in ('19')

Bindings	0: 19
Backtrace	app/Utils/product-manager.php:1989 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/product-manager.php:1977 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1989u195453480_yalla_n_db170μs

select * from `translations` where `translations`.`translationable_id` in (19) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'qa'

Bindings	0: App\Models\Category 1: qa
Backtrace	app/Utils/product-manager.php:1989 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/product-manager.php:1977 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76

product-manager.php#1345u195453480_yalla_n_db790μs

select `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 (`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 `user_id` = 4) and (`sub_sub_category_id` in (19) 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 `user_id` = 4)) or (0 = 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 `user_id` = 4)) or (0 = 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 `user_id` = 4)) order by `order_details_count` desc

Bindings	0: 1 1: 1 2: 1 3: 1 4: 1 5: approved 6: admin 7: 1 8: digital 9: physical 10: seller 11: 4 12: 19 13: 1 14: 1 15: approved 16: admin 17: 1 18: digital 19: physical 20: seller 21: 4 22: 1 23: 1 24: approved 25: admin 26: 1 27: digital 28: physical 29: seller 30: 4 31: 1 32: 1 33: approved 34: admin 35: 1 36: digital 37: physical 38: seller 39: 4
Backtrace	app/Utils/product-manager.php:1345 app/Utils/product-manager.php:2274 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

ShopViewController.php#472u195453480_yalla_n_db400μs

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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0 8: 1 9: 2
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db690μs

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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db300μs

select * from `translations` where `translations`.`translationable_id` in (1, 5, 11, 18, 23, 24, 25, 27, 28) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'qa'

Bindings	0: App\Models\Product 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db200μs

select * from `reviews` where `reviews`.`product_id` in (1, 5, 11, 18, 23, 24, 25, 27, 28) and `delivery_man_id` is null and `status` = 1

Bindings	0: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db190μsselect * from `categories` where `categories`.`parent_id` in (1) order by `priority` asc

Backtrace

app/Http/Controllers/Web/ShopViewController.php:472
app/Http/Controllers/Web/ShopViewController.php:122
app/Http/Controllers/Web/ShopViewController.php:76
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db450μs

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` 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 `categories`.`parent_id` in (2, 18, 51) order by `priority` asc

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db240μs

select * from `translations` where `translations`.`translationable_id` in (3, 4, 11, 19, 20, 21) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'qa'

Bindings	0: App\Models\Category 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db190μs

select * from `translations` where `translations`.`translationable_id` in (2, 18, 51) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'qa'

Bindings	0: App\Models\Category 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472u195453480_yalla_n_db180μs

select * from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'qa'

Bindings	0: App\Models\Category 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:122 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505u195453480_yalla_n_db440μs

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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: seller 8: 4 9: 1 10: 1 11: approved 12: admin 13: 1 14: digital 15: physical 16: 1 17: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:123 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505u195453480_yalla_n_db550μs

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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 1 9: approved 10: admin 11: 1 12: digital 13: physical 14: seller 15: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:123 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505u195453480_yalla_n_db200μs

select * from `translations` where `translations`.`translationable_id` in (27) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'qa'

Bindings	0: App\Models\Product 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:123 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505u195453480_yalla_n_db210μsselect * from `reviews` where `reviews`.`product_id` in (27) and `delivery_man_id` is null and `status` = 1

Bindings	0: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:123 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505u195453480_yalla_n_db200μs

select * from `translations` where `translations`.`translationable_id` in (7) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'qa'

Bindings	0: App\Models\Brand 1: qa
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:123 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1797u195453480_yalla_n_db420μs

select `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 (`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 `product_type` = 'digital' and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller'))) 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 (`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 `product_type` = 'digital' and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller')))

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 27 9: 4 10: seller 11: 1 12: 1 13: approved 14: admin 15: 1 16: digital 17: physical 18: digital 19: 27 20: 4 21: seller
Backtrace	app/Utils/product-manager.php:1797 app/Http/Controllers/Web/ShopViewController.php:124 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1821u195453480_yalla_n_db260μs

select count(*) as aggregate from `products` where (`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 (`product_type` = 'digital') and 1 = 1 and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller')

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 27 9: 4 10: seller
Backtrace	app/Utils/product-manager.php:1821 app/Http/Controllers/Web/ShopViewController.php:124 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1863u195453480_yalla_n_db410μs

select `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 (`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 `product_type` = 'digital' and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller'))) as `digital_product_author_count` from `authors` where exists (select * 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 (`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 `product_type` = 'digital' and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller'))) order by `name` asc

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 27 9: 4 10: seller 11: 1 12: 1 13: approved 14: admin 15: 1 16: digital 17: physical 18: digital 19: 27 20: 4 21: seller
Backtrace	app/Utils/product-manager.php:1863 app/Http/Controllers/Web/ShopViewController.php:125 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1886u195453480_yalla_n_db240μs

select count(*) as aggregate from `products` where (`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 (`product_type` = 'digital') and 1 = 1 and `id` in (27) and (`user_id` = 4 and `added_by` = 'seller')

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 27 9: 4 10: seller
Backtrace	app/Utils/product-manager.php:1886 app/Http/Controllers/Web/ShopViewController.php:125 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#38u195453480_yalla_n_db210μs

select count(*) as aggregate from `orders` where (`seller_is` = 'seller' and `seller_id` = 4) and `order_type` = 'default_type'

Bindings	0: seller 1: 4 2: default_type
Backtrace	app/Http/Controllers/Web/ShopViewController.php:38 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#46u195453480_yalla_n_db180μsselect * from `shops` where `id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:46 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#52u195453480_yalla_n_db150μsselect * from `shops` where `id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:52 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#54u195453480_yalla_n_db160μs

select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (27) and `status` = 1

Bindings	0: 1 1: 1 2: 27 3: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:54 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#55u195453480_yalla_n_db140μs

select count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (27) and `status` = 1

Bindings	0: 1 1: 1 2: 27 3: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:55 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#66u195453480_yalla_n_db170μsselect * from `sellers` where `sellers`.`id` = 4 limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:66 app/Http/Controllers/Web/ShopViewController.php:126 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#154u195453480_yalla_n_db140μsselect avg(`rating`) as aggregate from `reviews` where `status` = 1 and `product_id` in (27) and `status` = 1

Bindings	0: 1 1: 27 2: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:154 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#155u195453480_yalla_n_db130μsselect count(*) as aggregate from `reviews` where `status` = 1 and `product_id` in (27) and `status` = 1

Bindings	0: 1 1: 27 2: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:155 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#161u195453480_yalla_n_db130μsselect `rating` from `reviews` where `status` = 1 and `product_id` in (27) and `status` = 1

Bindings	0: 1 1: 27 2: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:161 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#185u195453480_yalla_n_db190μsselect * from `sellers` where `sellers`.`id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:185 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Http/Controllers/Web/ShopViewController.php:184 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

ShopViewController.php#193u195453480_yalla_n_db150μsselect * from `sellers` where `sellers`.`id` = '4' limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:193 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#194u195453480_yalla_n_db320μsselect * from `orders` where `orders`.`seller_id` = 4 and `orders`.`seller_id` is not null

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:194 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#195u195453480_yalla_n_db300μs

select count(*) as aggregate from `products` where (`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 `user_id` = 4

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: seller 8: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:195 app/Http/Controllers/Web/ShopViewController.php:76 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#1036u195453480_yalla_n_db510μs

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 (`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 `user_id` = 4) and (`featured` = 1) order by `id` desc, `id` desc

Bindings	0: 1 1: 1 2: 1 3: 1 4: approved 5: admin 6: 1 7: digital 8: physical 9: seller 10: 4 11: 1
Backtrace	app/Utils/product-manager.php:1036 app/Http/Controllers/Web/ShopViewController.php:198 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#200u195453480_yalla_n_db260μs

select count(*) as aggregate from `stock_clearance_products` where (`is_active` = 1) and `added_by` in ('admin', 'vendor') and exists (select * from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` = 1 and date(`duration_start_date`) <= '2025-04-12' and date(`duration_end_date`) >= '2025-04-12' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '22:17:40' and time(`offer_active_range_end`) >= '22:17:40') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and `shop_id` = '4'

Bindings	0: 1 1: admin 2: vendor 3: 1 4: 2025-04-12 5: 2025-04-12 6: specific_time 7: 22:17:40 8: 22:17:40 9: always 10: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:200 app/Http/Controllers/Web/ShopViewController.php:76 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

ShopViewController.php#201u195453480_yalla_n_db150μsselect * from `stock_clearance_setups` where (`shop_id` = '4') limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:201 app/Http/Controllers/Web/ShopViewController.php:76 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

cart-manager.php#128u195453480_yalla_n_db480μs

select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 124768 and `is_guest` = 1) group by `cart_group_id`

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 124768 9: 1
Backtrace	app/Utils/cart-manager.php:128 app/Utils/cart-manager.php:59 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/cart-manager.php:58 view::theme-views.layouts.partials._cart:10

cart-manager.php#67u195453480_yalla_n_db240μs

select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	app/Utils/cart-manager.php:67 view::theme-views.layouts.partials._cart:10 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

cart-manager.php#128u195453480_yalla_n_db350μs

select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 124768 and `is_guest` = 1) group by `cart_group_id`

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 124768 9: 1
Backtrace	app/Utils/cart-manager.php:128 app/Utils/cart-manager.php:59 vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34 app/Utils/cart-manager.php:58 view::theme-views.layouts.partials._app-bar:78

cart-manager.php#67u195453480_yalla_n_db230μs

select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	app/Utils/cart-manager.php:67 view::theme-views.layouts.partials._app-bar:78 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

App\Models\Translation: 108Translation.php#?
App\Models\Category: 85Category.php#?
App\Models\Product: 13Product.php#?
App\Models\Order: 6Order.php#?
App\Models\Shop: 4Shop.php#?
App\Models\Seller: 4Seller.php#?
App\Models\Review: 1Review.php#?
App\Models\Brand: 1Brand.php#?

system_default_currency_info: App\Models\Currency {#2380 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: QR
currency_symbol: QAR
currency_exchange_rate: 1
usd: 0.27397260273973
_token: mKfhua3xQUUJbU95Ty6ggfeJdHyjN0PINW9aWPHD
guest_id: 124768
local: qa
direction: rtl
_previous: array:1 [ "url" => "https://yallanext.com/shopView/4?data_from=category&page=1&sub_sub_category_id...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/shopView/4

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:3 [▼
  "data_from" => "category"
  "page" => "1"
  "sub_sub_category_id" => "19"
]

request_request

[]

request_headers

  0 of 0   
array:22 [▼
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "br"
  ]
  "host" => array:1 [▶
    0 => "yallanext.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.145.134.113"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "3.145.134.113"
  ]
  "x-real-port" => array:1 [▶
    0 => "51997"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-port" => array:1 [▶
    0 => "443"
  ]
  "x-lscache" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 12 Apr 2025 19:17:40 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ino1QnR0VkZGZFNZR0QvRmNoYjYvdXc9PSIsInZhbHVlIjoiNy9VNGVraTdvUVVzZ2NmYm1lZE9HYW5JanhjVzhuNDRjb3ppTmZteWJFeW14cjZKbk5EYnZlWHo3c0pUbldvdnhEK2hzRFd5YWYvd3dCRGIzSzd1MngydXo5WWJnU2xLMVdLQmI5ejZkdGN4ZDlBL2lJMWJQeFN6YUpuakxRNnQiLCJtYWMiOiIxZjk4NTk1NDZiNTEzZTJiYjFhZTI0MTI2M2FkOGI0M2RiZDlkYjVjM2U0MDA2MDQwYTRiNWNkNjc3YTQ0OTcyIiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 21:17:40 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ino1QnR0VkZGZFNZR0QvRmNoYjYvdXc9PSIsInZhbHVlIjoiNy9VNGVraTdvUVVzZ2NmYm1lZE9HYW5JanhjVzhuNDRjb3ppTmZteWJFeW14cjZKbk5EYnZlWHo3c0pUbldvdnhEK2hzR ▶"
    1 => "yalla_next_session=eyJpdiI6IlVTcUFqNGJCZkdGa2JjdGZSdlJCcmc9PSIsInZhbHVlIjoibDFZUjkrTmo0R2MwZ04yOGJCR0RuZnVvT2lWcVFrVExiT1FoWkRiSTdUS1F6b3FpaUk4OHVKTXJwT2h0KzlPVDQraGlEOTMvcFZVUkw1QVlteDNrTWRaaGltSEg0bFp4Zk82a2F5NkxRV0ZxbnFPZ3MrUWlaZ2V6dmxXWnpVbnoiLCJtYWMiOiJlZThjODllNDg1NmVmZmZkMWM0M2ExZGZjNjNjYjVhZTU5NDUwMGNjNDYxYTNkMjNkZTI2NWYzM2VkMDk3YjRhIiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 21:17:40 GMT; Max-Age=7200; path=/; httponly ◀yalla_next_session=eyJpdiI6IlVTcUFqNGJCZkdGa2JjdGZSdlJCcmc9PSIsInZhbHVlIjoibDFZUjkrTmo0R2MwZ04yOGJCR0RuZnVvT2lWcVFrVExiT1FoWkRiSTdUS1F6b3FpaUk4OHVKTXJwT2h0KzlPV ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ino1QnR0VkZGZFNZR0QvRmNoYjYvdXc9PSIsInZhbHVlIjoiNy9VNGVraTdvUVVzZ2NmYm1lZE9HYW5JanhjVzhuNDRjb3ppTmZteWJFeW14cjZKbk5EYnZlWHo3c0pUbldvdnhEK2hzRFd5YWYvd3dCRGIzSzd1MngydXo5WWJnU2xLMVdLQmI5ejZkdGN4ZDlBL2lJMWJQeFN6YUpuakxRNnQiLCJtYWMiOiIxZjk4NTk1NDZiNTEzZTJiYjFhZTI0MTI2M2FkOGI0M2RiZDlkYjVjM2U0MDA2MDQwYTRiNWNkNjc3YTQ0OTcyIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 21:17:40 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ino1QnR0VkZGZFNZR0QvRmNoYjYvdXc9PSIsInZhbHVlIjoiNy9VNGVraTdvUVVzZ2NmYm1lZE9HYW5JanhjVzhuNDRjb3ppTmZteWJFeW14cjZKbk5EYnZlWHo3c0pUbldvdnhEK2hzR ▶"
    1 => "yalla_next_session=eyJpdiI6IlVTcUFqNGJCZkdGa2JjdGZSdlJCcmc9PSIsInZhbHVlIjoibDFZUjkrTmo0R2MwZ04yOGJCR0RuZnVvT2lWcVFrVExiT1FoWkRiSTdUS1F6b3FpaUk4OHVKTXJwT2h0KzlPVDQraGlEOTMvcFZVUkw1QVlteDNrTWRaaGltSEg0bFp4Zk82a2F5NkxRV0ZxbnFPZ3MrUWlaZ2V6dmxXWnpVbnoiLCJtYWMiOiJlZThjODllNDg1NmVmZmZkMWM0M2ExZGZjNjNjYjVhZTU5NDUwMGNjNDYxYTNkMjNkZTI2NWYzM2VkMDk3YjRhIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 21:17:40 GMT; path=/; httponly ◀yalla_next_session=eyJpdiI6IlVTcUFqNGJCZkdGa2JjdGZSdlJCcmc9PSIsInZhbHVlIjoibDFZUjkrTmo0R2MwZ04yOGJCR0RuZnVvT2lWcVFrVExiT1FoWkRiSTdUS1F6b3FpaUk4OHVKTXJwT2h0KzlPV ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#2380 ▶
    #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" => "QAR"
      "symbol" => "QAR"
      "code" => "QR"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2023-12-19 01:15:35"
      "updated_at" => "2024-04-21 19:29:35"
    ]
    #original: array:8 [▶
      "id" => 8
      "name" => "QAR"
      "symbol" => "QAR"
      "code" => "QR"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2023-12-19 01:15:35"
      "updated_at" => "2024-04-21 19:29:35"
    ]
    #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" => "QR"
  "currency_symbol" => "QAR"
  "currency_exchange_rate" => "1"
  "usd" => 0.27397260273973
  "_token" => "mKfhua3xQUUJbU95Ty6ggfeJdHyjN0PINW9aWPHD"
  "guest_id" => 124768
  "local" => "qa"
  "direction" => "rtl"
  "_previous" => array:1 [▶
    "url" => "https://yallanext.com/shopView/4?data_from=category&page=1&sub_sub_category_id=19"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-12 22:17:40	GET	/shopView/4?data_from=category&page=1&sub_sub_category_id=19	3 27 57 222

Hard n Soft

0%

1

Search product

السعر

المنتجات

العلامات التجارية

التقييمات

لا يوجد منتجات!

Fast shipping

منتجات أصلية

100% دفع امن

24/7 مركز الدعم

الخط الساخن

النشرة البريدية

الحسابات

روابط سريعة

آخر

1 x Application (71.22%)	192ms
1 x Booting (28.77%)	77.47ms

You have not added anything to your cart yet!

Hard n Soft

0%

1

Search product

السعر

المنتجات

العلامات التجارية

التقييمات

لا يوجد منتجات!

Fast shipping

منتجات أصلية

100% دفع امن

24/7 مركز الدعم

سلة فارغة

خصوصيتك تهمنا