Hard n Soft

Click to view

Hard n Soft

(0)

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

0%

تقييم إيجابي

1

المنتجات

Search product

1 العنصر

ترتيب حسب :

Show product :

السعر

الحد الأدنى

الحد الأقصى

Product Type

المنتجات

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

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

إيسوس 1

التقييمات

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

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

(0)

Hard n Soft

اسوس فيفو بوك 14 كمبيوتر محمول

QAR1,699

Fast shipping

Fast shipping all across the country

منتجات أصلية

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

100% دفع امن

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

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

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

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

Booting (308ms)time
Application (198ms)time
1 x Booting (60.86%)
308ms
1 x Application (39.14%)
198ms

29 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.partials._product-small-card_product-small-card.blade.php#?blade
pagination::bootstrap-4bootstrap-4.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

59 statements were executed (24 duplicates)Show only duplicates15.68ms

GuestMiddleware.php#24u195453480_yalla_n_db290μs

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.19.67.91', '2025-04-06 22:50:49', '2025-04-06 22:50:49')

Bindings	0: 3.19.67.91 1: 2025-04-06 22:50:49 2: 2025-04-06 22:50:49
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_db280μ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_db200μ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_db150μ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_db560μ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_db190μ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_db250μ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_db160μ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_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'))) 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_db340μ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_db290μ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_db290μ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#1738u195453480_yalla_n_db710μ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) order by `id` desc, `id` 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
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db160μsselect * from `categories` where `categories`.`id` in (1)

Backtrace

app/Utils/product-manager.php:1738
app/Utils/product-manager.php:2288
app/Http/Controllers/Web/ShopViewController.php:121
app/Http/Controllers/Web/ShopViewController.php:76
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_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/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_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:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db140μ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:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db160μsselect * from `sellers` where `sellers`.`id` in (4)

Backtrace

app/Utils/product-manager.php:1738
app/Utils/product-manager.php:2288
app/Http/Controllers/Web/ShopViewController.php:121
app/Http/Controllers/Web/ShopViewController.php:76
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db160μsselect * from `shops` where `shops`.`seller_id` in (4)

Backtrace

app/Utils/product-manager.php:1738
app/Utils/product-manager.php:2288
app/Http/Controllers/Web/ShopViewController.php:121
app/Http/Controllers/Web/ShopViewController.php:76
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db230μs

select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (27) and (`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-06' and date(`duration_end_date`) >= '2025-04-06' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '22:50:49' and time(`offer_active_range_end`) >= '22:50:49') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null)))

Bindings	0: 1 1: admin 2: vendor 3: 1 4: 2025-04-06 5: 2025-04-06 6: specific_time 7: 22:50:49 8: 22:50:49 9: always
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:121 app/Http/Controllers/Web/ShopViewController.php:76 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738u195453480_yalla_n_db160μ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:1738 app/Utils/product-manager.php:2288 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_db360μ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_db600μ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_db250μ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_db150μ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_db160μ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_db370μ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_db210μ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_db170μ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_db150μ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_db380μ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_db460μ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_db170μ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_db140μ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_db150μ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_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') 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_db250μ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_db250μ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_db200μ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_db180μ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_db170μ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_db160μ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_db210μ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_db170μ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_db160μ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_db150μ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_db210μ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_db180μ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_db350μ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_db320μ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_db520μ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_db280μ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-06' and date(`duration_end_date`) >= '2025-04-06' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '22:50:49' and time(`offer_active_range_end`) >= '22:50:49') 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-06 5: 2025-04-06 6: specific_time 7: 22:50:49 8: 22:50:49 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_db200μ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_db580μ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` = 121841 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: 121841 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_db260μ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_db370μ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` = 121841 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: 121841 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_db260μ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: 36Translation.php#?
App\Models\Product: 14Product.php#?
App\Models\Category: 11Category.php#?
App\Models\Order: 6Order.php#?
App\Models\Shop: 5Shop.php#?
App\Models\Seller: 5Seller.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: N5wzF8Bg8oFqPNNa5KIqEv9UwDHVOpqCFqPPlKL9
guest_id: 121841
local: qa
direction: rtl
_previous: array:1 [ "url" => "https://yallanext.com/shopView/4" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/shopView/4

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

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.19.67.91"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "3.19.67.91"
  ]
  "x-real-port" => array:1 [▶
    0 => "6889"
  ]
  "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 => "Sun, 06 Apr 2025 19:50:49 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illub0F1dzFUWXdCTzRwU3ZuSFJacFE9PSIsInZhbHVlIjoiYTE5ZkZEWlVlUFVaajFYWTlhNkM1VmlyMUd2TnV3cXJzTGpna3Q1cVUyWVN3cHkzR1E3N28zZXRpRGFMVW5wbXhBOTBIbi9rODd1K09kdHEvOXhGYzcvUGhnZFJqYmFvNitwR053ZnYrSi8rOU5mZVpUdk1JaktJTFZKaUVpeUsiLCJtYWMiOiJhYTcxNDg1MWQ4M2Y1MmJkNTllOGViMWNkNzBkNTg1MzE0MWJmYTAwNjZmOGM0MDljZTRhZjViNzZiODJkYzczIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 21:50:49 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Illub0F1dzFUWXdCTzRwU3ZuSFJacFE9PSIsInZhbHVlIjoiYTE5ZkZEWlVlUFVaajFYWTlhNkM1VmlyMUd2TnV3cXJzTGpna3Q1cVUyWVN3cHkzR1E3N28zZXRpRGFMVW5wbXhBOTBIb ▶"
    1 => "yalla_next_session=eyJpdiI6IkVzbWp4NDVwSTQxVzE2RzkxT2czVlE9PSIsInZhbHVlIjoiT05Ec0l0L2JTaEMycmtmU2RnaVdkb2ZmcHhBM0dKM2U0L2RQcE4zSzI2ZnBzSDd5cUJEQktTNXBKanhpa3cxQ1o5aXdJWU1pdG1ybVM0SldjbGFrNk9HTExxN09vdXRVR25HNzhpc05zKzE4cGwwYWR3eTZ5bWs3NXN2bS9VYmciLCJtYWMiOiJjYjkxZmRiNmUyZjRhOWQyN2ZkYjVjNDk3YTNjMTQyYTlmYWY3MTg1NDBlMTVkMWI4YzA5YWE4ZDcwOGU3MmNiIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 21:50:49 GMT; Max-Age=7200; path=/; httponly ◀yalla_next_session=eyJpdiI6IkVzbWp4NDVwSTQxVzE2RzkxT2czVlE9PSIsInZhbHVlIjoiT05Ec0l0L2JTaEMycmtmU2RnaVdkb2ZmcHhBM0dKM2U0L2RQcE4zSzI2ZnBzSDd5cUJEQktTNXBKanhpa3cxQ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illub0F1dzFUWXdCTzRwU3ZuSFJacFE9PSIsInZhbHVlIjoiYTE5ZkZEWlVlUFVaajFYWTlhNkM1VmlyMUd2TnV3cXJzTGpna3Q1cVUyWVN3cHkzR1E3N28zZXRpRGFMVW5wbXhBOTBIbi9rODd1K09kdHEvOXhGYzcvUGhnZFJqYmFvNitwR053ZnYrSi8rOU5mZVpUdk1JaktJTFZKaUVpeUsiLCJtYWMiOiJhYTcxNDg1MWQ4M2Y1MmJkNTllOGViMWNkNzBkNTg1MzE0MWJmYTAwNjZmOGM0MDljZTRhZjViNzZiODJkYzczIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 21:50:49 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Illub0F1dzFUWXdCTzRwU3ZuSFJacFE9PSIsInZhbHVlIjoiYTE5ZkZEWlVlUFVaajFYWTlhNkM1VmlyMUd2TnV3cXJzTGpna3Q1cVUyWVN3cHkzR1E3N28zZXRpRGFMVW5wbXhBOTBIb ▶"
    1 => "yalla_next_session=eyJpdiI6IkVzbWp4NDVwSTQxVzE2RzkxT2czVlE9PSIsInZhbHVlIjoiT05Ec0l0L2JTaEMycmtmU2RnaVdkb2ZmcHhBM0dKM2U0L2RQcE4zSzI2ZnBzSDd5cUJEQktTNXBKanhpa3cxQ1o5aXdJWU1pdG1ybVM0SldjbGFrNk9HTExxN09vdXRVR25HNzhpc05zKzE4cGwwYWR3eTZ5bWs3NXN2bS9VYmciLCJtYWMiOiJjYjkxZmRiNmUyZjRhOWQyN2ZkYjVjNDk3YTNjMTQyYTlmYWY3MTg1NDBlMTVkMWI4YzA5YWE4ZDcwOGU3MmNiIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 21:50:49 GMT; path=/; httponly ◀yalla_next_session=eyJpdiI6IkVzbWp4NDVwSTQxVzE2RzkxT2czVlE9PSIsInZhbHVlIjoiT05Ec0l0L2JTaEMycmtmU2RnaVdkb2ZmcHhBM0dKM2U0L2RQcE4zSzI2ZnBzSDd5cUJEQktTNXBKanhpa3cxQ ▶"
  ]
]

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" => "N5wzF8Bg8oFqPNNa5KIqEv9UwDHVOpqCFqPPlKL9"
  "guest_id" => 121841
  "local" => "qa"
  "direction" => "rtl"
  "_previous" => array:1 [▶
    "url" => "https://yallanext.com/shopView/4"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-06 22:50:49	GET	/shopView/4	3 29 59 79

Hard n Soft

0%

1

Search product

السعر

المنتجات

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

التقييمات

اسوس فيفو بوك 14 كمبيوتر محمول

Fast shipping

منتجات أصلية

100% دفع امن

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

الخط الساخن

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

الحسابات

روابط سريعة

آخر

1 x Booting (60.86%)	308ms
1 x Application (39.14%)	198ms

You have not added anything to your cart yet!

Hard n Soft

0%

1

Search product

السعر

المنتجات

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

التقييمات

اسوس فيفو بوك 14 كمبيوتر محمول

Fast shipping

منتجات أصلية

100% دفع امن

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

سلة فارغة

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