https://yallanext.com/shopView/6

Click to view

mfit

(0)

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

0%

تقييم إيجابي

0

المنتجات

Search product

0 العنصر

ترتيب حسب :

Show product :

السعر

الحد الأدنى

الحد الأقصى

Product Type

المنتجات

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

التقييمات

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

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

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

Fast shipping

Fast shipping all across the country

منتجات أصلية

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

100% دفع امن

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

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

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

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

Booting (73.63ms)time
Application (136ms)time
1 x Application (64.81%)
136ms
1 x Booting (35.18%)
73.63ms

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

36 statements were executed (14 duplicates)Show only duplicates9.37ms

GuestMiddleware.php#24u195453480_yalla_n_db230μs

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('3.144.23.154', '2025-04-06 17:16:55', '2025-04-06 17:16:55')

Bindings	0: 3.144.23.154 1: 2025-04-06 17:16:55 2: 2025-04-06 17:16:55
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_db220μsselect * from `shops` where `id` = '6' limit 1

Bindings	0: 6
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` = 6 limit 1

Bindings	0: approved 1: 6
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_db160μsselect * from `shops` where `id` = '6' limit 1

Bindings	0: 6
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_db440μ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` = 6)

Bindings	0: 1 1: 1 2: 1 3: approved 4: admin 5: 1 6: digital 7: physical 8: seller 9: 6
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_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: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_db280μ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_db510μ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` = 6) 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: 6
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_db250μ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 0 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0
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_db310μ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` = 6) 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 0 = 1

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: seller 8: 6 9: 1 10: 1 11: approved 12: admin 13: 1 14: digital 15: physical 16: 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

product-manager.php#1797u195453480_yalla_n_db290μ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 (`user_id` = 6 and `added_by` = 'seller'))) as `publishing_house_products_count` from `publishing_houses`

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 6 9: 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_db360μ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 (`user_id` = 6 and `added_by` = 'seller')

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 6 9: 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_db310μ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 (`user_id` = 6 and `added_by` = 'seller'))) as `digital_product_author_count` from `authors` order by `name` asc

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 6 9: 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_db290μ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 (`user_id` = 6 and `added_by` = 'seller')

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: digital 8: 6 9: 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_db230μs

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

Bindings	0: seller 1: 6 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` = '6' limit 1

Bindings	0: 6
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` = '6' limit 1

Bindings	0: 6
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μsselect avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and 0 = 1 and `status` = 1

Bindings	0: 1 1: 1 2: 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_db110μsselect count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and 0 = 1 and `status` = 1

Bindings	0: 1 1: 1 2: 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_db160μsselect * from `sellers` where `sellers`.`id` = 6 limit 1

Bindings	0: 6
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_db110μsselect avg(`rating`) as aggregate from `reviews` where `status` = 1 and 0 = 1 and `status` = 1

Bindings	0: 1 1: 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_db100μsselect count(*) as aggregate from `reviews` where `status` = 1 and 0 = 1 and `status` = 1

Bindings	0: 1 1: 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_db100μsselect `rating` from `reviews` where `status` = 1 and 0 = 1 and `status` = 1

Bindings	0: 1 1: 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_db150μsselect * from `sellers` where `sellers`.`id` = '6' limit 1

Bindings	0: 6
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_db140μsselect * from `sellers` where `sellers`.`id` = '6' limit 1

Bindings	0: 6
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_db290μsselect * from `orders` where `orders`.`seller_id` = 6 and `orders`.`seller_id` is not null

Bindings	0: 6
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_db280μ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` = 6

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: seller 8: 6
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_db470μ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` = 6) 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: 6 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_db310μ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`) <= '17:16:55' and time(`offer_active_range_end`) >= '17:16:55') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and `shop_id` = '6'

Bindings	0: 1 1: admin 2: vendor 3: 1 4: 2025-04-06 5: 2025-04-06 6: specific_time 7: 17:16:55 8: 17:16:55 9: always 10: 6
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_db170μsselect * from `stock_clearance_setups` where (`shop_id` = '6') limit 1

Bindings	0: 6
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_db450μ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` = 121768 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: 121768 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_db390μ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` = 121768 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: 121768 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\Shop: 4Shop.php#?
App\Models\Seller: 4Seller.php#?
App\Models\Product: 2Product.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: GlWqRbPJbM9O4KX1dDih02oMoEjNpN4lvvrWPkjR
guest_id: 121768
local: qa
direction: rtl
_previous: array:1 [ "url" => "https://yallanext.com/shopView/6" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/shopView/6

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.144.23.154"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-real-ip" => array:1 [▶
    0 => "3.144.23.154"
  ]
  "x-real-port" => array:1 [▶
    0 => "22449"
  ]
  "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 14:16:55 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkhFVVJhakZYT3FCUEFqSEtnNFpWakE9PSIsInZhbHVlIjoiWlFoTHdZRDNzUC9waUtVL2JMTWNvVEh0amJwQkdPclZEUDIyaVZGRTMySytNNlVxS2tPVktuRk56dE5yVnhhRGUyalQxRUJXbnNsUUhQVGNnTGppSE1VKzNkT0lkS2dXaUk3ZUdTRlNURU43djNOZVkrUkoxMGF3NE5KZXA0VkkiLCJtYWMiOiJmMWIyMTJjZDQ2N2JmYzU5NjA0YTViNmNlZWYyNmE1NTIzYmY2Mzc5MDJmNzBhYjIwMGIyZjhkM2E1ZTY2NmI3IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 16:16:55 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkhFVVJhakZYT3FCUEFqSEtnNFpWakE9PSIsInZhbHVlIjoiWlFoTHdZRDNzUC9waUtVL2JMTWNvVEh0amJwQkdPclZEUDIyaVZGRTMySytNNlVxS2tPVktuRk56dE5yVnhhRGUyalQxR ▶"
    1 => "yalla_next_session=eyJpdiI6IlhvZ3dsNzkzRWlDeEhqN2V2UTMrZnc9PSIsInZhbHVlIjoibmZSM0VpNTQzMVVBTlQrTzRxNTB1ZG40K1RrMVZpMEw5dnZWUXJBZSt5ZXFTZ0pjYVgvNjA0NzlPR3ZaQk1ydDJNRWFzMXcxb3d5SUROZmQ2eUF4N2RHeHVxSUpkZmRYTitHV1pzSlhibkNmMDhOQ2M1SDVPSGN4b0trYUswd3AiLCJtYWMiOiJkZDA1YzRjNWRkZDY2MWY1N2MzZjUzNjBmY2UyYmM4Y2NhY2M2Y2Q0NWI0MjM5N2E0MGYzZTYxMjg3MzE4ZTI0IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 16:16:55 GMT; Max-Age=7200; path=/; httponly ◀yalla_next_session=eyJpdiI6IlhvZ3dsNzkzRWlDeEhqN2V2UTMrZnc9PSIsInZhbHVlIjoibmZSM0VpNTQzMVVBTlQrTzRxNTB1ZG40K1RrMVZpMEw5dnZWUXJBZSt5ZXFTZ0pjYVgvNjA0NzlPR3ZaQk1yd ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkhFVVJhakZYT3FCUEFqSEtnNFpWakE9PSIsInZhbHVlIjoiWlFoTHdZRDNzUC9waUtVL2JMTWNvVEh0amJwQkdPclZEUDIyaVZGRTMySytNNlVxS2tPVktuRk56dE5yVnhhRGUyalQxRUJXbnNsUUhQVGNnTGppSE1VKzNkT0lkS2dXaUk3ZUdTRlNURU43djNOZVkrUkoxMGF3NE5KZXA0VkkiLCJtYWMiOiJmMWIyMTJjZDQ2N2JmYzU5NjA0YTViNmNlZWYyNmE1NTIzYmY2Mzc5MDJmNzBhYjIwMGIyZjhkM2E1ZTY2NmI3IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:16:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkhFVVJhakZYT3FCUEFqSEtnNFpWakE9PSIsInZhbHVlIjoiWlFoTHdZRDNzUC9waUtVL2JMTWNvVEh0amJwQkdPclZEUDIyaVZGRTMySytNNlVxS2tPVktuRk56dE5yVnhhRGUyalQxR ▶"
    1 => "yalla_next_session=eyJpdiI6IlhvZ3dsNzkzRWlDeEhqN2V2UTMrZnc9PSIsInZhbHVlIjoibmZSM0VpNTQzMVVBTlQrTzRxNTB1ZG40K1RrMVZpMEw5dnZWUXJBZSt5ZXFTZ0pjYVgvNjA0NzlPR3ZaQk1ydDJNRWFzMXcxb3d5SUROZmQ2eUF4N2RHeHVxSUpkZmRYTitHV1pzSlhibkNmMDhOQ2M1SDVPSGN4b0trYUswd3AiLCJtYWMiOiJkZDA1YzRjNWRkZDY2MWY1N2MzZjUzNjBmY2UyYmM4Y2NhY2M2Y2Q0NWI0MjM5N2E0MGYzZTYxMjg3MzE4ZTI0IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 16:16:55 GMT; path=/; httponly ◀yalla_next_session=eyJpdiI6IlhvZ3dsNzkzRWlDeEhqN2V2UTMrZnc9PSIsInZhbHVlIjoibmZSM0VpNTQzMVVBTlQrTzRxNTB1ZG40K1RrMVZpMEw5dnZWUXJBZSt5ZXFTZ0pjYVgvNjA0NzlPR3ZaQk1yd ▶"
  ]
]

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-06 17:16:55	GET	/shopView/6	3 27 36 10

mfit

0%

0

Search product

السعر

المنتجات

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

التقييمات

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

Fast shipping

منتجات أصلية

100% دفع امن

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

الخط الساخن

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

الحسابات

روابط سريعة

آخر

1 x Application (64.81%)	136ms
1 x Booting (35.18%)	73.63ms

You have not added anything to your cart yet!

mfit

0%

0

Search product

السعر

المنتجات

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

التقييمات

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

Fast shipping

منتجات أصلية

100% دفع امن

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

سلة فارغة

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