Shop Page

Messages2 Timeline Exceptions Views38 Route Queries65 Models378 Mails Gate Session Request

Request history8.2.41.73s48MBGET shopView/{id}

warninglog[01:34:42] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[01:34:42] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...

Booting (377ms)time
Application (1.35s)time
1 x Application (78.18%)
1.35s
1 x Booting (21.82%)
377ms

38 templates were rendered

web-views.seller-view.shopviewshopview.blade.php#?blade
web-views.seller-view.shop-info-cardshop-info-card.blade.php#?blade
web-views.seller-view.shop-info-cardshop-info-card.blade.php#?blade
web-views.seller-view.partials._shop-sidebar_shop-sidebar.blade.php#?blade
web-views.products._ajax-products_ajax-products.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
web-views.partials._filter-single-product_filter-single-product.blade.php#?blade
pagination::bootstrap-4bootstrap-4.blade.php#?blade
layouts.front-end.appapp.blade.php#?blade
web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
system-partials._analytics_script_analytics_script.blade.php#?blade
layouts.front-end.partials._modals_modals.blade.php#?blade
layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
layouts.front-end.partials._header_header.blade.php#?blade
layouts.front-end.partials._cart_cart.blade.php#?blade
layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
layouts.front-end.partials._footer_footer.blade.php#?blade
layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
layouts.front-end.partials._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

65 statements were executed (26 duplicates)Show only duplicates84.39ms

GuestMiddleware.php#24mappyfy2.63ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.217.3', '2025-06-18 01:34:42', '2025-06-18 01:34:42')

Bindings	0: 216.73.217.3 1: 2025-06-18 01:34:42 2: 2025-06-18 01:34:42
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#424mappyfy570μsselect * from `shops` where `id` = '7' limit 1

Bindings	0: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:424 app/Http/Controllers/Web/ShopViewController.php:83 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

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

ShopViewController.php#85mappyfy430μsselect * from `shops` where `id` = '7' limit 1

Bindings	0: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:85 app/Http/Controllers/Web/ShopViewController.php:75 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#2340mappyfy5.06ms

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` = 13)

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

product-manager.php#2340mappyfy750μs

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `status` = 1 group by `product_id`

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

product-manager.php#2340mappyfy1.09ms

select * from `translations` where `translations`.`translationable_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'

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

product-manager.php#2340mappyfy720μs

select * from `reviews` where `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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:86 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1911mappyfy1.06ms

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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1920mappyfy860μ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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1926mappyfy1ms

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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1934mappyfy560μ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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1738mappyfy13.42ms

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` = 13) 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: 13
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738mappyfy1.25msselect * from `categories` where `categories`.`id` in (4)

Backtrace

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

product-manager.php#1738mappyfy850μs

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

Bindings	0: App\Models\Category 1: en
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738mappyfy530μs

select * from `reviews` where `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738mappyfy610μs

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

Backtrace

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

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

Backtrace

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

product-manager.php#1738mappyfy690μs

select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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-06-18' and date(`duration_end_date`) >= '2025-06-18' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '01:34:42' and time(`offer_active_range_end`) >= '01:34:42') 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-06-18 5: 2025-06-18 6: specific_time 7: 01:34:42 8: 01:34:42 9: always
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

product-manager.php#1738mappyfy460μs

select * from `translations` where `translations`.`translationable_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'

Bindings	0: App\Models\Product 1: en
Backtrace	app/Utils/product-manager.php:1738 app/Utils/product-manager.php:2288 app/Http/Controllers/Web/ShopViewController.php:87 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

ShopViewController.php#472mappyfy1.55ms

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 ('4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4', '4')

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0 8: 4 9: 4 10: 4 11: 4 12: 4 13: 4 14: 4 15: 4 16: 4 17: 4 18: 4 19: 4 20: 4 21: 4 22: 4 23: 4 24: 4 25: 4 26: 4 27: 4 28: 4 29: 4 30: 4 31: 4 32: 4 33: 4 34: 4 35: 4 36: 4 37: 4 38: 4 39: 4 40: 4 41: 4 42: 4 43: 4 44: 4 45: 4 46: 4 47: 4 48: 4 49: 4 50: 4 51: 4 52: 4 53: 4 54: 4 55: 4 56: 4 57: 4
Backtrace	app/Http/Controllers/Web/ShopViewController.php:472 app/Http/Controllers/Web/ShopViewController.php:88 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472mappyfy4.19ms

select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4) 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:88 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472mappyfy490μs

select * from `translations` where `translations`.`translationable_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'

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

ShopViewController.php#472mappyfy480μs

select * from `reviews` where `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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:88 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Backtrace

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

ShopViewController.php#472mappyfy790μ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 (5, 6, 7, 8, 9, 10, 11) 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:88 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#472mappyfy310μs

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

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

ShopViewController.php#472mappyfy280μs

select * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 10, 11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'

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

ShopViewController.php#472mappyfy400μs

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

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

ShopViewController.php#505mappyfy2.86ms

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` = 13) 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 (2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2)

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: seller
8: 13
9: 1
10: 1
11: approved
12: admin
13: 1
14: digital
15: physical
16: 1
17: 2
18: 2
19: 2
20: 2
21: 2
22: 2
23: 2
24: 2
25: 2
26: 2
27: 2
28: 2
29: 2
30: 2
31: 2
32: 2
33: 2
34: 2
35: 2
36: 2
37: 2
38: 2
39: 2
40: 2
41: 2
42: 2
43: 2
44: 2
45: 2
46: 2
47: 2
48: 2
49: 2
50: 2
51: 2
52: 2
53: 2
54: 2
55: 2
56: 2
57: 2
58: 2
59: 2
60: 2
61: 2
62: 2
63: 2
64: 2
65: 2
66: 2

Backtrace

app/Http/Controllers/Web/ShopViewController.php:505
app/Http/Controllers/Web/ShopViewController.php:89
app/Http/Controllers/Web/ShopViewController.php:75
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505mappyfy4.58ms

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 (2) 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` = 13)

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: 13
Backtrace	app/Http/Controllers/Web/ShopViewController.php:505 app/Http/Controllers/Web/ShopViewController.php:89 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505mappyfy570μs

select * from `translations` where `translations`.`translationable_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'

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

ShopViewController.php#505mappyfy470μs

select * from `reviews` where `reviews`.`product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) 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:89 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#505mappyfy430μs

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

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

product-manager.php#1797mappyfy1.55ms

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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 and `added_by` = 'seller')))

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 29
9: 30
10: 31
11: 32
12: 33
13: 34
14: 35
15: 36
16: 37
17: 38
18: 39
19: 40
20: 41
21: 42
22: 43
23: 44
24: 45
25: 46
26: 47
27: 48
28: 49
29: 50
30: 51
31: 52
32: 53
33: 54
34: 55
35: 56
36: 57
37: 58
38: 59
39: 60
40: 61
41: 62
42: 63
43: 71
44: 83
45: 84
46: 85
47: 86
48: 87
49: 88
50: 89
51: 90
52: 91
53: 92
54: 93
55: 94
56: 100
57: 109
58: 13
59: seller
60: 1
61: 1
62: approved
63: admin
64: 1
65: digital
66: physical
67: digital
68: 29
69: 30
70: 31
71: 32
72: 33
73: 34
74: 35
75: 36
76: 37
77: 38
78: 39
79: 40
80: 41
81: 42
82: 43
83: 44
84: 45
85: 46
86: 47
87: 48
88: 49
89: 50
90: 51
91: 52
92: 53
93: 54
94: 55
95: 56
96: 57
97: 58
98: 59
99: 60
100: 61
101: 62
102: 63
103: 71
104: 83
105: 84
106: 85
107: 86
108: 87
109: 88
110: 89
111: 90
112: 91
113: 92
114: 93
115: 94
116: 100
117: 109
118: 13
119: seller

Backtrace

app/Utils/product-manager.php:1797
app/Http/Controllers/Web/ShopViewController.php:90
app/Http/Controllers/Web/ShopViewController.php:75
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1821mappyfy2.33ms

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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 and `added_by` = 'seller')

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 29
9: 30
10: 31
11: 32
12: 33
13: 34
14: 35
15: 36
16: 37
17: 38
18: 39
19: 40
20: 41
21: 42
22: 43
23: 44
24: 45
25: 46
26: 47
27: 48
28: 49
29: 50
30: 51
31: 52
32: 53
33: 54
34: 55
35: 56
36: 57
37: 58
38: 59
39: 60
40: 61
41: 62
42: 63
43: 71
44: 83
45: 84
46: 85
47: 86
48: 87
49: 88
50: 89
51: 90
52: 91
53: 92
54: 93
55: 94
56: 100
57: 109
58: 13
59: seller

Backtrace

app/Utils/product-manager.php:1821
app/Http/Controllers/Web/ShopViewController.php:90
app/Http/Controllers/Web/ShopViewController.php:75
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1863mappyfy2.05ms

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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 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: 29
9: 30
10: 31
11: 32
12: 33
13: 34
14: 35
15: 36
16: 37
17: 38
18: 39
19: 40
20: 41
21: 42
22: 43
23: 44
24: 45
25: 46
26: 47
27: 48
28: 49
29: 50
30: 51
31: 52
32: 53
33: 54
34: 55
35: 56
36: 57
37: 58
38: 59
39: 60
40: 61
41: 62
42: 63
43: 71
44: 83
45: 84
46: 85
47: 86
48: 87
49: 88
50: 89
51: 90
52: 91
53: 92
54: 93
55: 94
56: 100
57: 109
58: 13
59: seller
60: 1
61: 1
62: approved
63: admin
64: 1
65: digital
66: physical
67: digital
68: 29
69: 30
70: 31
71: 32
72: 33
73: 34
74: 35
75: 36
76: 37
77: 38
78: 39
79: 40
80: 41
81: 42
82: 43
83: 44
84: 45
85: 46
86: 47
87: 48
88: 49
89: 50
90: 51
91: 52
92: 53
93: 54
94: 55
95: 56
96: 57
97: 58
98: 59
99: 60
100: 61
101: 62
102: 63
103: 71
104: 83
105: 84
106: 85
107: 86
108: 87
109: 88
110: 89
111: 90
112: 91
113: 92
114: 93
115: 94
116: 100
117: 109
118: 13
119: seller

Backtrace

app/Utils/product-manager.php:1863
app/Http/Controllers/Web/ShopViewController.php:91
app/Http/Controllers/Web/ShopViewController.php:75
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

product-manager.php#1886mappyfy700μ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 (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and (`user_id` = 13 and `added_by` = 'seller')

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 29
9: 30
10: 31
11: 32
12: 33
13: 34
14: 35
15: 36
16: 37
17: 38
18: 39
19: 40
20: 41
21: 42
22: 43
23: 44
24: 45
25: 46
26: 47
27: 48
28: 49
29: 50
30: 51
31: 52
32: 53
33: 54
34: 55
35: 56
36: 57
37: 58
38: 59
39: 60
40: 61
41: 62
42: 63
43: 71
44: 83
45: 84
46: 85
47: 86
48: 87
49: 88
50: 89
51: 90
52: 91
53: 92
54: 93
55: 94
56: 100
57: 109
58: 13
59: seller

Backtrace

app/Utils/product-manager.php:1886
app/Http/Controllers/Web/ShopViewController.php:91
app/Http/Controllers/Web/ShopViewController.php:75
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#38mappyfy1.51ms

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

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

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

Bindings	0: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:46 app/Http/Controllers/Web/ShopViewController.php:92 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:52 app/Http/Controllers/Web/ShopViewController.php:92 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#54mappyfy810μs

select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `status` = 1

Bindings	0: 1 1: 1 2: 29 3: 30 4: 31 5: 32 6: 33 7: 34 8: 35 9: 36 10: 37 11: 38 12: 39 13: 40 14: 41 15: 42 16: 43 17: 44 18: 45 19: 46 20: 47 21: 48 22: 49 23: 50 24: 51 25: 52 26: 53 27: 54 28: 55 29: 56 30: 57 31: 58 32: 59 33: 60 34: 61 35: 62 36: 63 37: 71 38: 83 39: 84 40: 85 41: 86 42: 87 43: 88 44: 89 45: 90 46: 91 47: 92 48: 93 49: 94 50: 100 51: 109 52: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:54 app/Http/Controllers/Web/ShopViewController.php:92 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#55mappyfy510μs

select count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (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, 71, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 100, 109) and `status` = 1

Bindings	0: 1 1: 1 2: 29 3: 30 4: 31 5: 32 6: 33 7: 34 8: 35 9: 36 10: 37 11: 38 12: 39 13: 40 14: 41 15: 42 16: 43 17: 44 18: 45 19: 46 20: 47 21: 48 22: 49 23: 50 24: 51 25: 52 26: 53 27: 54 28: 55 29: 56 30: 57 31: 58 32: 59 33: 60 34: 61 35: 62 36: 63 37: 71 38: 83 39: 84 40: 85 41: 86 42: 87 43: 88 44: 89 45: 90 46: 91 47: 92 48: 93 49: 94 50: 100 51: 109 52: 1
Backtrace	app/Http/Controllers/Web/ShopViewController.php:55 app/Http/Controllers/Web/ShopViewController.php:92 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 13
Backtrace	app/Http/Controllers/Web/ShopViewController.php:66 app/Http/Controllers/Web/ShopViewController.php:92 app/Http/Controllers/Web/ShopViewController.php:75 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

ShopViewController.php#94mappyfy1.33ms

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-06-18' and date(`duration_end_date`) >= '2025-06-18' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '01:34:43' and time(`offer_active_range_end`) >= '01:34:43') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and (`shop_id` = '7')

Bindings	0: 1 1: admin 2: vendor 3: 1 4: 2025-06-18 5: 2025-06-18 6: specific_time 7: 01:34:43 8: 01:34:43 9: always 10: 7
Backtrace	app/Http/Controllers/Web/ShopViewController.php:94 app/Http/Controllers/Web/ShopViewController.php:75 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#95mappyfy840μsselect * from `stock_clearance_setups` where (`shop_id` = '7') limit 1

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

_header.blade.php#37mappyfy760μsselect * from `currencies` where `status` = 1

Bindings	0: 1
Backtrace	view::layouts.front-end.partials._header:37 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 vendor/laravel/framework/src/Illuminate/View/View.php:207

cart-manager.php#128mappyfy1.14ms

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` = 25787 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: 25787 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::layouts.front-end.partials._cart:1

cart-manager.php#67mappyfy350μ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::layouts.front-end.partials._cart:1 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#128mappyfy330μ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` = 25787 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: 25787 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::layouts.front-end.partials._cart:2

cart-manager.php#67mappyfy300μ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 and (`is_checked` = 1)

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1 8: 1
Backtrace	app/Utils/cart-manager.php:67 view::layouts.front-end.partials._cart:2 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

category-manager.php#111mappyfy540μ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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 0
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy2.39ms

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

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy1.01ms

select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (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, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173) 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-06-18' and date(`duration_end_date`) >= '2025-06-18' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '01:34:43' and time(`offer_active_range_end`) >= '01:34:43') 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-06-18 5: 2025-06-18 6: specific_time 7: 01:34:43 8: 01:34:43 9: always
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy440μs

select * from `translations` where `translations`.`translationable_id` in (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, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'

Bindings	0: App\Models\Product 1: en
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy870μs

select * from `reviews` where `reviews`.`product_id` in (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, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173) and `delivery_man_id` is null and `status` = 1

Bindings	0: 1
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy910μs

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_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 `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 18, 19) and `position` = 1 order by `priority` asc

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 1
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy690μs

select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_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 `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (5, 6, 7, 8, 9, 10, 11) and `position` = 2 order by `priority` asc

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical 7: 2
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy790μs

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

Bindings	0: App\Models\Category 1: en
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy420μs

select * from `translations` where `translations`.`translationable_id` in (5, 6, 7, 8, 9, 10, 11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'

Bindings	0: App\Models\Category 1: en
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

category-manager.php#111mappyfy1ms

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

Bindings	0: App\Models\Category 1: en
Backtrace	app/Utils/category-manager.php:111 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/category-manager.php:84 view::layouts.front-end.partials._header:236

brand-manager.php#82mappyfy3.86ms

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 (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc

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: 1
Backtrace	app/Utils/brand-manager.php:82 app/Utils/brand-manager.php:56 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/brand-manager.php:48

brand-manager.php#82mappyfy850μs

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7) and `translations`.`translationable_type` = 'App\\Models\\Brand' and `locale` = 'en'

Bindings	0: App\Models\Brand 1: en
Backtrace	app/Utils/brand-manager.php:82 app/Utils/brand-manager.php:56 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Utils/brand-manager.php:48

_footer.blade.php#109mappyfy1.47ms

select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-06-18' and date(`end_date`) >= '2025-06-18' limit 1

Bindings	0: 1 1: flash_deal 2: 2025-06-18 3: 2025-06-18
Backtrace	view::layouts.front-end.partials._footer:109 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 vendor/laravel/framework/src/Illuminate/View/View.php:207

App\Models\Product: 330Product.php#?
App\Models\Category: 21Category.php#?
App\Models\Review: 8Review.php#?
App\Models\Brand: 8Brand.php#?
App\Models\Shop: 5Shop.php#?
App\Models\Seller: 3Seller.php#?
App\Models\Currency: 3Currency.php#?

system_default_currency_info: App\Models\Currency {#2266 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: INR
currency_symbol: ₹
currency_exchange_rate: 1
usd: 0.016666666666667
_token: Ktg2ed7ssL7Azu9agcQ2dvDvgt1xS3JngRVAPLGb
guest_id: 25787
local: en
direction: ltr
_previous: array:1 [ "url" => "https://mappyfy.com/shopView/7?page=2" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/shopView/7

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "mappyfy.com"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

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 => "Wed, 18 Jun 2025 01:34:43 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikp6bCtNa2dYcjMrVXJMblpsNklsTUE9PSIsInZhbHVlIjoidFRCcEZLdzdjb042NklqQk96Q1NVVnhrdVZaRFdOQjh6dXVCaUFLSHF5RWdZY1Bvc25zL3dsZUxYSVNZQVVheXF5eWZxVHkxZVpTMUhFczJHcWU0emtYcUV2ZzBjOGxqdGhpOUdTakcvNktMbDFvMHZEMWlEWVloMzArVEsrSkUiLCJtYWMiOiI4NWNmZDlkZjkxNDhjYjk1Njc2MmIwZDdhNzAyMDk1ODlkMmYzODY4MjAxMjA1NzhhOTQ5MDdjMWRiZDM0MWFjIiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 02:34:44 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikp6bCtNa2dYcjMrVXJMblpsNklsTUE9PSIsInZhbHVlIjoidFRCcEZLdzdjb042NklqQk96Q1NVVnhrdVZaRFdOQjh6dXVCaUFLSHF5RWdZY1Bvc25zL3dsZUxYSVNZQVVheXF5eWZxV ▶"
    1 => "6valley1736933341_session=eyJpdiI6IkZoN3RBeXhXSTliVmtwM3JmSlRwY1E9PSIsInZhbHVlIjoiUERodXBwRnVKZ09UY1FrYTBBYjZYdzc4YjNZYTNVY29YTjkvaWVCY2RLbzBmZFJ3cFBQWktITy9GU2lpYXpkcUFmZW5sTkd0d0szZXdYdm5OT25naVdMd2RBaHpSeG5TVWRKS2Z4Q2JFZzlic01rL0g0aGhrRmZBMFd0SmJWdEsiLCJtYWMiOiIzZTEzZjdkNTQ4YTk3YjE0NDNlMTY3N2FmZjY1ZjkwMjU3MjU1M2MzNGY1MmE2NTQzNGU4ZDgyNTFhZTc1YWZkIiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 02:34:44 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6IkZoN3RBeXhXSTliVmtwM3JmSlRwY1E9PSIsInZhbHVlIjoiUERodXBwRnVKZ09UY1FrYTBBYjZYdzc4YjNZYTNVY29YTjkvaWVCY2RLbzBmZFJ3cFBQWktITy9GU2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikp6bCtNa2dYcjMrVXJMblpsNklsTUE9PSIsInZhbHVlIjoidFRCcEZLdzdjb042NklqQk96Q1NVVnhrdVZaRFdOQjh6dXVCaUFLSHF5RWdZY1Bvc25zL3dsZUxYSVNZQVVheXF5eWZxVHkxZVpTMUhFczJHcWU0emtYcUV2ZzBjOGxqdGhpOUdTakcvNktMbDFvMHZEMWlEWVloMzArVEsrSkUiLCJtYWMiOiI4NWNmZDlkZjkxNDhjYjk1Njc2MmIwZDdhNzAyMDk1ODlkMmYzODY4MjAxMjA1NzhhOTQ5MDdjMWRiZDM0MWFjIiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 02:34:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikp6bCtNa2dYcjMrVXJMblpsNklsTUE9PSIsInZhbHVlIjoidFRCcEZLdzdjb042NklqQk96Q1NVVnhrdVZaRFdOQjh6dXVCaUFLSHF5RWdZY1Bvc25zL3dsZUxYSVNZQVVheXF5eWZxV ▶"
    1 => "6valley1736933341_session=eyJpdiI6IkZoN3RBeXhXSTliVmtwM3JmSlRwY1E9PSIsInZhbHVlIjoiUERodXBwRnVKZ09UY1FrYTBBYjZYdzc4YjNZYTNVY29YTjkvaWVCY2RLbzBmZFJ3cFBQWktITy9GU2lpYXpkcUFmZW5sTkd0d0szZXdYdm5OT25naVdMd2RBaHpSeG5TVWRKS2Z4Q2JFZzlic01rL0g0aGhrRmZBMFd0SmJWdEsiLCJtYWMiOiIzZTEzZjdkNTQ4YTk3YjE0NDNlMTY3N2FmZjY1ZjkwMjU3MjU1M2MzNGY1MmE2NTQzNGU4ZDgyNTFhZTc1YWZkIiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 02:34:44 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6IkZoN3RBeXhXSTliVmtwM3JmSlRwY1E9PSIsInZhbHVlIjoiUERodXBwRnVKZ09UY1FrYTBBYjZYdzc4YjNZYTNVY29YTjkvaWVCY2RLbzBmZFJ3cFBQWktITy9GU2 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#2266 ▶
    #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" => 3
      "name" => "Indian Rupee"
      "symbol" => "₹"
      "code" => "INR"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2020-10-15 19:23:04"
      "updated_at" => "2025-05-08 12:50:01"
    ]
    #original: array:8 [▶
      "id" => 3
      "name" => "Indian Rupee"
      "symbol" => "₹"
      "code" => "INR"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2020-10-15 19:23:04"
      "updated_at" => "2025-05-08 12:50:01"
    ]
    #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" => "INR"
  "currency_symbol" => "₹"
  "currency_exchange_rate" => "1"
  "usd" => 0.016666666666667
  "_token" => "Ktg2ed7ssL7Azu9agcQ2dvDvgt1xS3JngRVAPLGb"
  "guest_id" => 25787
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://mappyfy.com/shopView/7?page=2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-18 01:34:44	GET	/shopView/7?page=2	2 38 65 378

Special

Account & shipping info

Newsletter

1 x Application (78.18%)	1.35s
1 x Booting (21.82%)	377ms

Shopping cart

Out of stock

Product added to wishlist

Please Sign in

Delete this address?