Shop Page

Messages2 Timeline Exceptions Views38 Route Queries53 Models236 Mails Gate Session Request

Request history8.2.42.01s47MBGET shopView/{id}

warninglog[03:15:47] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[03:15:47] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...

Booting (461ms)time
Application (1.55s)time
1 x Application (77.06%)
1.55s
1 x Booting (22.94%)
461ms

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

53 statements were executed (20 duplicates)Show only duplicates98.68ms

GuestMiddleware.php#24mappyfy6.24ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.221.229.47', '2025-06-01 03:15:47', '2025-06-01 03:15:47')

Bindings	0: 18.221.229.47 1: 2025-06-01 03:15:47 2: 2025-06-01 03:15:47
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#424mappyfy2.72msselect * 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#429mappyfy2.54msselect * 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#85mappyfy1.32msselect * 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#2340mappyfy4.42ms

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#2340mappyfy1.36ms

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#2340mappyfy2.25ms

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#2340mappyfy6.26ms

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.48ms

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#1920mappyfy1.84ms

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#1926mappyfy1.12ms

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#1934mappyfy740μ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#1738mappyfy8.85ms

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.57msselect * 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#1738mappyfy770μ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#1738mappyfy1.25ms

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#1738mappyfy1.8msselect * 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#1738mappyfy980μ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#1738mappyfy1.49ms

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-01' and date(`duration_end_date`) >= '2025-06-01' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '03:15:47' and time(`offer_active_range_end`) >= '03:15:47') 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-01 5: 2025-06-01 6: specific_time 7: 03:15:47 8: 03:15:47 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#1738mappyfy550μ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#472mappyfy2.15ms

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#472mappyfy7.11ms

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#472mappyfy1.65ms

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, 111, 112, 113, 114, 115, 116, 117, 118) 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#472mappyfy1.01ms

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, 111, 112, 113, 114, 115, 116, 117, 118) 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#472mappyfy780μ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#472mappyfy1.19ms

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#472mappyfy560μ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#472mappyfy1.15ms

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#472mappyfy700μ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.97ms

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#505mappyfy5.02ms

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#505mappyfy1.04ms

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#505mappyfy610μ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#505mappyfy940μ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.96ms

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#1821mappyfy2ms

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#1863mappyfy1.57ms

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#1886mappyfy630μ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.38ms

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#46mappyfy830μ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#54mappyfy1.08ms

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#55mappyfy950μ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#66mappyfy2msselect * 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.37ms

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-01' and date(`duration_end_date`) >= '2025-06-01' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '03:15:47' and time(`offer_active_range_end`) >= '03:15:47') 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-01 5: 2025-06-01 6: specific_time 7: 03:15:47 8: 03:15:47 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#95mappyfy660μ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#37mappyfy1.23msselect * 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.71ms

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` = 20109 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: 20109 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#67mappyfy640μ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#128mappyfy1.01ms

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` = 20109 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: 20109 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#67mappyfy520μ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

_footer.blade.php#109mappyfy1.48ms

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

Bindings	0: 1 1: flash_deal 2: 2025-06-01 3: 2025-06-01
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: 208Product.php#?
App\Models\Category: 10Category.php#?
App\Models\Review: 6Review.php#?
App\Models\Shop: 5Shop.php#?
App\Models\Seller: 3Seller.php#?
App\Models\Currency: 3Currency.php#?
App\Models\Brand: 1Brand.php#?

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

path_info

/shopView/7

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

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 => "Sun, 01 Jun 2025 03:15:47 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRFZUIwaHQ4TzJHZlE3SkF5RkFyWkE9PSIsInZhbHVlIjoibEhvSCtsUU9CbFZyZ2lmOTREY2p0cjFGQjhZY3ZKcHpUMjE4RFVITG92UlE1M2dQNFpYWFdOWENiWGhwRDUwelVkem1VdVk1cnlYMXhlR1pEc25CcGQ2VDdvaGQ3R29CUmNHT2UzY1YzOWpwM0I5U1NDcFJjbjlqV2FvWEtxM0ciLCJtYWMiOiIzNDMzZjAzOGE3ZDdlNTQ5MWE1YTRjMDljNmI0ZTFhZDNmNjg2MDI2ZWE3NzZiNzc3ZjI5MzQyNzc2NjYwZmU2IiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 04:15:48 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRFZUIwaHQ4TzJHZlE3SkF5RkFyWkE9PSIsInZhbHVlIjoibEhvSCtsUU9CbFZyZ2lmOTREY2p0cjFGQjhZY3ZKcHpUMjE4RFVITG92UlE1M2dQNFpYWFdOWENiWGhwRDUwelVkem1Vd ▶"
    1 => "6valley1736933341_session=eyJpdiI6IjhHUCs3eGlVNE9PcHV0aGdnVzFYSWc9PSIsInZhbHVlIjoiMUJoY0F2SkkvWlhiYTNlKzk5ZS9CV0tpbStLdnlFeDhSMWNrRWdKVU1MSVU0OVhMaENBY0Z6aHplVFl5Ly9sOWxMSTlPeUhGTGQyUUgvYmVLNmRTOEROTVFuaGpCQzN3d1NDTDh6TkxQY0d0TkdON0pKaVNWWUpOQlFydktEU2giLCJtYWMiOiIxNDQ0YjA3MGM1MzVkNzZkMDFkNTQ3MzQ1OTgzMzg0ZDBmYjk5MTYyYjQ4OWQ0MGE4Y2RlYTQwMjQ2NjJiNzhkIiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 04:15:48 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6IjhHUCs3eGlVNE9PcHV0aGdnVzFYSWc9PSIsInZhbHVlIjoiMUJoY0F2SkkvWlhiYTNlKzk5ZS9CV0tpbStLdnlFeDhSMWNrRWdKVU1MSVU0OVhMaENBY0Z6aHplVF ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRFZUIwaHQ4TzJHZlE3SkF5RkFyWkE9PSIsInZhbHVlIjoibEhvSCtsUU9CbFZyZ2lmOTREY2p0cjFGQjhZY3ZKcHpUMjE4RFVITG92UlE1M2dQNFpYWFdOWENiWGhwRDUwelVkem1VdVk1cnlYMXhlR1pEc25CcGQ2VDdvaGQ3R29CUmNHT2UzY1YzOWpwM0I5U1NDcFJjbjlqV2FvWEtxM0ciLCJtYWMiOiIzNDMzZjAzOGE3ZDdlNTQ5MWE1YTRjMDljNmI0ZTFhZDNmNjg2MDI2ZWE3NzZiNzc3ZjI5MzQyNzc2NjYwZmU2IiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 04:15:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRFZUIwaHQ4TzJHZlE3SkF5RkFyWkE9PSIsInZhbHVlIjoibEhvSCtsUU9CbFZyZ2lmOTREY2p0cjFGQjhZY3ZKcHpUMjE4RFVITG92UlE1M2dQNFpYWFdOWENiWGhwRDUwelVkem1Vd ▶"
    1 => "6valley1736933341_session=eyJpdiI6IjhHUCs3eGlVNE9PcHV0aGdnVzFYSWc9PSIsInZhbHVlIjoiMUJoY0F2SkkvWlhiYTNlKzk5ZS9CV0tpbStLdnlFeDhSMWNrRWdKVU1MSVU0OVhMaENBY0Z6aHplVFl5Ly9sOWxMSTlPeUhGTGQyUUgvYmVLNmRTOEROTVFuaGpCQzN3d1NDTDh6TkxQY0d0TkdON0pKaVNWWUpOQlFydktEU2giLCJtYWMiOiIxNDQ0YjA3MGM1MzVkNzZkMDFkNTQ3MzQ1OTgzMzg0ZDBmYjk5MTYyYjQ4OWQ0MGE4Y2RlYTQwMjQ2NjJiNzhkIiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 04:15:48 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6IjhHUCs3eGlVNE9PcHV0aGdnVzFYSWc9PSIsInZhbHVlIjoiMUJoY0F2SkkvWlhiYTNlKzk5ZS9CV0tpbStLdnlFeDhSMWNrRWdKVU1MSVU0OVhMaENBY0Z6aHplVF ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#2150 ▶
    #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" => "f9YenszvrOZL56R40Qoc0H9oUgA36tB3rg1U2d7k"
  "guest_id" => 20109
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://mappyfy.com/shopView/7"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-01 03:15:48	GET	/shopView/7	2 38 53 236

Educational Toys

Wooden Toys

Electronic Toys

Soft Toys

Art and Craft Toys

Music Instruments

Sports Toys

Special

Account & shipping info

Newsletter

1 x Application (77.06%)	1.55s
1 x Booting (22.94%)	461ms

Shopping cart

Educational Toys

Wooden Toys

Electronic Toys

Soft Toys

Art and Craft Toys

Music Instruments

Sports Toys

Out of stock

Product added to wishlist

Please Sign in

Delete this address?