Shop Page

Messages45 Timeline Exceptions Views38 Route Queries49 Models266 Mails Gate Session Request

Request history8.2.41.66s51MBGET shopView/{id}

warninglog[06:40:33] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[06:40:33] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
warninglog[06:40:33] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
warninglog[06:40:33] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
infolog[06:40:33] LOG.info: 1,500.00₹
infolog[06:40:33] LOG.info: 892.20₹
infolog[06:40:33] LOG.info: 1,500.00₹
infolog[06:40:33] LOG.info: 435.90₹
infolog[06:40:33] LOG.info: 1,500.00₹
infolog[06:40:33] LOG.info: 816.60₹
infolog[06:40:33] LOG.info: 2,500.00₹
infolog[06:40:33] LOG.info: 1,096.00₹
infolog[06:40:33] LOG.info: 3,000.00₹
infolog[06:40:33] LOG.info: 1,170.30₹
infolog[06:40:33] LOG.info: 2,500.00₹
infolog[06:40:33] LOG.info: 1,200.50₹
infolog[06:40:33] LOG.info: 2,500.00₹
infolog[06:40:33] LOG.info: 1,096.00₹
infolog[06:40:33] LOG.info: 3,000.00₹
infolog[06:40:33] LOG.info: 1,386.60₹
infolog[06:40:33] LOG.info: 2,000.00₹
infolog[06:40:33] LOG.info: 726.40₹
infolog[06:40:33] LOG.info: 5,000.00₹
infolog[06:40:33] LOG.info: 3,000.00₹
infolog[06:40:33] LOG.info: 1,700.00₹
infolog[06:40:33] LOG.info: 1,190.00₹
infolog[06:40:33] LOG.info: 2,500.00₹
infolog[06:40:33] LOG.info: 1,590.75₹
infolog[06:40:33] LOG.info: 2,000.00₹
infolog[06:40:33] LOG.info: 1,350.60₹
infolog[06:40:33] LOG.info: 400.00₹
infolog[06:40:33] LOG.info: 359.68₹
infolog[06:40:33] LOG.info: 2,196.00₹
infolog[06:40:33] LOG.info: 1,998.36₹
infolog[06:40:33] LOG.info: 825.00₹
infolog[06:40:33] LOG.info: 676.58₹
infolog[06:40:33] LOG.info: 795.00₹
infolog[06:40:33] LOG.info: 723.45₹
infolog[06:40:33] LOG.info: 1,296.00₹
infolog[06:40:33] LOG.info: 1,205.28₹
infolog[06:40:33] LOG.info: 900.00₹
infolog[06:40:33] LOG.info: 630.09₹
infolog[06:40:33] LOG.info: 900.00₹
infolog[06:40:33] LOG.info: 576.00₹
infolog[06:40:33] LOG.info: 0.00₹

Booting (407ms)time
Application (1.25s)time
1 x Application (75.53%)
1.25s
1 x Booting (24.47%)
407ms

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

49 statements were executed (20 duplicates)Show only duplicates69.78ms

GuestMiddleware.php#24mappyfy2.54ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.64', '2025-06-22 06:40:33', '2025-06-22 06:40:33')

Bindings	0: 216.73.216.64 1: 2025-06-22 06:40:33 2: 2025-06-22 06:40:33
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#424mappyfy870μsselect * from `shops` where `id` = '15' limit 1

Bindings	0: 15
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#429mappyfy770μsselect * from `sellers` where (`status` = 'approved') and `sellers`.`id` = 20 limit 1

Bindings	0: approved 1: 20
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#85mappyfy240μsselect * from `shops` where `id` = '15' limit 1

Bindings	0: 15
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.2ms

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

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

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (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, 174, 175, 176, 177) 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.76ms

select * from `translations` where `translations`.`translationable_id` in (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, 174, 175, 176, 177) 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#2340mappyfy940μs

select * from `reviews` where `reviews`.`product_id` in (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, 174, 175, 176, 177) 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.21ms

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#1920mappyfy540μ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#1926mappyfy760μs

select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical'))) as `digital_product_author_count` from `authors`

Bindings	0: 1 1: 1 2: approved 3: admin 4: 1 5: digital 6: physical
Backtrace	app/Utils/product-manager.php:1926 app/Http/Controllers/Web/ShopViewController.php: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#1738mappyfy8.79ms

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` = 20) 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: 20
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#1738mappyfy800μsselect * from `categories` where `categories`.`id` in (18)

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 `translations` where `translations`.`translationable_id` in (18) 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#1738mappyfy490μs

select * from `reviews` where `reviews`.`product_id` in (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, 174, 175, 176, 177) 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#1738mappyfy760μs

select avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (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, 174, 175, 176, 177) 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#1738mappyfy770μsselect * from `sellers` where `sellers`.`id` in (20)

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μsselect * from `shops` where `shops`.`seller_id` in (20)

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

select * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (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, 174, 175, 176, 177) 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-22' and date(`duration_end_date`) >= '2025-06-22' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '06:40:33' and time(`offer_active_range_end`) >= '06:40:33') 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-22 5: 2025-06-22 6: specific_time 7: 06:40:33 8: 06:40:33 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#1738mappyfy470μs

select * from `translations` where `translations`.`translationable_id` in (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, 174, 175, 176, 177) 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.88ms

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

Bindings

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

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

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 (18) 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#472mappyfy730μs

select * from `translations` where `translations`.`translationable_id` in (64, 65, 66, 67, 68, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 95, 96, 97, 98, 99, 101, 102, 103, 104, 105, 106, 107, 108, 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, 174, 175, 176, 177) 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#472mappyfy960μs

select * from `reviews` where `reviews`.`product_id` in (64, 65, 66, 67, 68, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 95, 96, 97, 98, 99, 101, 102, 103, 104, 105, 106, 107, 108, 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, 174, 175, 176, 177) 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#472mappyfy750μsselect * from `categories` where `categories`.`parent_id` in (18) 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#472mappyfy590μs

select * from `translations` where `translations`.`translationable_id` in (18) 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#505mappyfy3.04ms

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` = 20) 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 (4, 4, 3, 3, 3, 4, 4, 4, 1, 1, 1, 1, 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 1, 5, 1, 1, 1, 1, 1, 1, 1, 1, 5, 5, 1, 1, 1, 1, 1, 1, 1, 4, 4, 2, 1, 5, 5, 5, 5, 5, 5, 5, 5, 5)

Bindings

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

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

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 (1, 2, 3, 4, 5, 6) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`added_by` = 'seller' and `user_id` = 20)

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: 20
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#505mappyfy490μs

select * from `translations` where `translations`.`translationable_id` in (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, 174, 175, 176, 177) 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#505mappyfy410μs

select * from `reviews` where `reviews`.`product_id` in (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, 174, 175, 176, 177) 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#505mappyfy560μs

select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6) 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.85ms

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 (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, 174, 175, 176, 177) and (`user_id` = 20 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 (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, 174, 175, 176, 177) and (`user_id` = 20 and `added_by` = 'seller')))

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 123
9: 124
10: 125
11: 126
12: 127
13: 128
14: 129
15: 130
16: 131
17: 132
18: 133
19: 134
20: 135
21: 136
22: 137
23: 138
24: 139
25: 140
26: 141
27: 142
28: 143
29: 144
30: 145
31: 146
32: 147
33: 148
34: 149
35: 150
36: 151
37: 152
38: 153
39: 154
40: 155
41: 156
42: 157
43: 158
44: 159
45: 160
46: 161
47: 162
48: 163
49: 164
50: 165
51: 166
52: 167
53: 168
54: 169
55: 170
56: 171
57: 172
58: 173
59: 174
60: 175
61: 176
62: 177
63: 20
64: seller
65: 1
66: 1
67: approved
68: admin
69: 1
70: digital
71: physical
72: digital
73: 123
74: 124
75: 125
76: 126
77: 127
78: 128
79: 129
80: 130
81: 131
82: 132
83: 133
84: 134
85: 135
86: 136
87: 137
88: 138
89: 139
90: 140
91: 141
92: 142
93: 143
94: 144
95: 145
96: 146
97: 147
98: 148
99: 149
100: 150
101: 151
102: 152
103: 153
104: 154
105: 155
106: 156
107: 157
108: 158
109: 159
110: 160
111: 161
112: 162
113: 163
114: 164
115: 165
116: 166
117: 167
118: 168
119: 169
120: 170
121: 171
122: 172
123: 173
124: 174
125: 175
126: 176
127: 177
128: 20
129: 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#1821mappyfy1.97ms

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 (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, 174, 175, 176, 177) and (`user_id` = 20 and `added_by` = 'seller')

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 123
9: 124
10: 125
11: 126
12: 127
13: 128
14: 129
15: 130
16: 131
17: 132
18: 133
19: 134
20: 135
21: 136
22: 137
23: 138
24: 139
25: 140
26: 141
27: 142
28: 143
29: 144
30: 145
31: 146
32: 147
33: 148
34: 149
35: 150
36: 151
37: 152
38: 153
39: 154
40: 155
41: 156
42: 157
43: 158
44: 159
45: 160
46: 161
47: 162
48: 163
49: 164
50: 165
51: 166
52: 167
53: 168
54: 169
55: 170
56: 171
57: 172
58: 173
59: 174
60: 175
61: 176
62: 177
63: 20
64: 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.63ms

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 (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, 174, 175, 176, 177) and (`user_id` = 20 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 (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, 174, 175, 176, 177) and (`user_id` = 20 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: 123
9: 124
10: 125
11: 126
12: 127
13: 128
14: 129
15: 130
16: 131
17: 132
18: 133
19: 134
20: 135
21: 136
22: 137
23: 138
24: 139
25: 140
26: 141
27: 142
28: 143
29: 144
30: 145
31: 146
32: 147
33: 148
34: 149
35: 150
36: 151
37: 152
38: 153
39: 154
40: 155
41: 156
42: 157
43: 158
44: 159
45: 160
46: 161
47: 162
48: 163
49: 164
50: 165
51: 166
52: 167
53: 168
54: 169
55: 170
56: 171
57: 172
58: 173
59: 174
60: 175
61: 176
62: 177
63: 20
64: seller
65: 1
66: 1
67: approved
68: admin
69: 1
70: digital
71: physical
72: digital
73: 123
74: 124
75: 125
76: 126
77: 127
78: 128
79: 129
80: 130
81: 131
82: 132
83: 133
84: 134
85: 135
86: 136
87: 137
88: 138
89: 139
90: 140
91: 141
92: 142
93: 143
94: 144
95: 145
96: 146
97: 147
98: 148
99: 149
100: 150
101: 151
102: 152
103: 153
104: 154
105: 155
106: 156
107: 157
108: 158
109: 159
110: 160
111: 161
112: 162
113: 163
114: 164
115: 165
116: 166
117: 167
118: 168
119: 169
120: 170
121: 171
122: 172
123: 173
124: 174
125: 175
126: 176
127: 177
128: 20
129: 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#1886mappyfy740μ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 (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, 174, 175, 176, 177) and (`user_id` = 20 and `added_by` = 'seller')

Bindings

0: 1
1: 1
2: approved
3: admin
4: 1
5: digital
6: physical
7: digital
8: 123
9: 124
10: 125
11: 126
12: 127
13: 128
14: 129
15: 130
16: 131
17: 132
18: 133
19: 134
20: 135
21: 136
22: 137
23: 138
24: 139
25: 140
26: 141
27: 142
28: 143
29: 144
30: 145
31: 146
32: 147
33: 148
34: 149
35: 150
36: 151
37: 152
38: 153
39: 154
40: 155
41: 156
42: 157
43: 158
44: 159
45: 160
46: 161
47: 162
48: 163
49: 164
50: 165
51: 166
52: 167
53: 168
54: 169
55: 170
56: 171
57: 172
58: 173
59: 174
60: 175
61: 176
62: 177
63: 20
64: 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.28ms

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

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

Bindings	0: 15
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#52mappyfy560μsselect * from `shops` where `id` = '15' limit 1

Bindings	0: 15
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#54mappyfy850μs

select avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (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, 174, 175, 176, 177) and `status` = 1

Bindings

0: 1
1: 1
2: 123
3: 124
4: 125
5: 126
6: 127
7: 128
8: 129
9: 130
10: 131
11: 132
12: 133
13: 134
14: 135
15: 136
16: 137
17: 138
18: 139
19: 140
20: 141
21: 142
22: 143
23: 144
24: 145
25: 146
26: 147
27: 148
28: 149
29: 150
30: 151
31: 152
32: 153
33: 154
34: 155
35: 156
36: 157
37: 158
38: 159
39: 160
40: 161
41: 162
42: 163
43: 164
44: 165
45: 166
46: 167
47: 168
48: 169
49: 170
50: 171
51: 172
52: 173
53: 174
54: 175
55: 176
56: 177
57: 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#55mappyfy580μs

select count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (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, 174, 175, 176, 177) and `status` = 1

Bindings

0: 1
1: 1
2: 123
3: 124
4: 125
5: 126
6: 127
7: 128
8: 129
9: 130
10: 131
11: 132
12: 133
13: 134
14: 135
15: 136
16: 137
17: 138
18: 139
19: 140
20: 141
21: 142
22: 143
23: 144
24: 145
25: 146
26: 147
27: 148
28: 149
29: 150
30: 151
31: 152
32: 153
33: 154
34: 155
35: 156
36: 157
37: 158
38: 159
39: 160
40: 161
41: 162
42: 163
43: 164
44: 165
45: 166
46: 167
47: 168
48: 169
49: 170
50: 171
51: 172
52: 173
53: 174
54: 175
55: 176
56: 177
57: 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#66mappyfy710μsselect * from `sellers` where `sellers`.`id` = 20 limit 1

Bindings	0: 20
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.55ms

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-22' and date(`duration_end_date`) >= '2025-06-22' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '06:40:33' and time(`offer_active_range_end`) >= '06:40:33') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and (`shop_id` = '15')

Bindings	0: 1 1: admin 2: vendor 3: 1 4: 2025-06-22 5: 2025-06-22 6: specific_time 7: 06:40:33 8: 06:40:33 9: always 10: 15
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#95mappyfy780μsselect * from `stock_clearance_setups` where (`shop_id` = '15') limit 1

Bindings	0: 15
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

cart-manager.php#128mappyfy1.45ms

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` = 27607 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: 27607 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#67mappyfy550μ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#128mappyfy610μ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` = 27607 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: 27607 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#67mappyfy740μ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.12ms

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

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

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

path_info

/shopView/15

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, 22 Jun 2025 06:40:33 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9wWmxSZ1RvSzVwSkZVWnErUE1aOVE9PSIsInZhbHVlIjoiMVQwcnArZ01FZ3EwMkhXNitkenBYWE9aWUdDZ2pjVUJJeTdmdXd0RW4xeW5DOU9zQXR4dXlaUUhnWGtpT0s3L0ZjZnFaQ3VzVm0yUGxlZXJCZHBUWlgrU3FUczBuVmxUTWljN3I5KzhOTStRVVZkczArMlI5bjREV3dCb0I1OWMiLCJtYWMiOiJjMDQ1NTFiMzE4ZjhlNjlhYTkyODAyMjVjOTg1ZTYwZmI3ZTQ4YTY3MTUyNTNhODM4NzhhYTMyYTc2MWVjZTQ0IiwidGFnIjoiIn0%3D; expires=Sun, 22 Jun 2025 07:40:34 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9wWmxSZ1RvSzVwSkZVWnErUE1aOVE9PSIsInZhbHVlIjoiMVQwcnArZ01FZ3EwMkhXNitkenBYWE9aWUdDZ2pjVUJJeTdmdXd0RW4xeW5DOU9zQXR4dXlaUUhnWGtpT0s3L0ZjZnFaQ ▶"
    1 => "6valley1736933341_session=eyJpdiI6InZiV1N3b2ZzblEzaUNtVzdYVjV1UlE9PSIsInZhbHVlIjoialB4Q1F5TjJ6a2VUV2Z6U3NRQXpVTnU0dmRsOXlvY3RxWmNENVBIS1kybHgwRk5zT0YwOUtINWp1dmkvcENkSlp4OThxdmF2YXRpSU5icnZSU0lVZmJRWlFSZktCY0pPaE9hUCs1Q0k1TG92TTB5cG9GdVNXTkdKb0lFVnBnQUciLCJtYWMiOiJkMTMwY2FmMDM2ZDc0NWJlZjY5OTc4YzE3Y2JhMzRhZDhmNTkwNzM5MDkyNzI4Y2Y1ZTY3NzljYjhlMDY0NDg2IiwidGFnIjoiIn0%3D; expires=Sun, 22 Jun 2025 07:40:34 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6InZiV1N3b2ZzblEzaUNtVzdYVjV1UlE9PSIsInZhbHVlIjoialB4Q1F5TjJ6a2VUV2Z6U3NRQXpVTnU0dmRsOXlvY3RxWmNENVBIS1kybHgwRk5zT0YwOUtINWp1dm ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9wWmxSZ1RvSzVwSkZVWnErUE1aOVE9PSIsInZhbHVlIjoiMVQwcnArZ01FZ3EwMkhXNitkenBYWE9aWUdDZ2pjVUJJeTdmdXd0RW4xeW5DOU9zQXR4dXlaUUhnWGtpT0s3L0ZjZnFaQ3VzVm0yUGxlZXJCZHBUWlgrU3FUczBuVmxUTWljN3I5KzhOTStRVVZkczArMlI5bjREV3dCb0I1OWMiLCJtYWMiOiJjMDQ1NTFiMzE4ZjhlNjlhYTkyODAyMjVjOTg1ZTYwZmI3ZTQ4YTY3MTUyNTNhODM4NzhhYTMyYTc2MWVjZTQ0IiwidGFnIjoiIn0%3D; expires=Sun, 22-Jun-2025 07:40:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9wWmxSZ1RvSzVwSkZVWnErUE1aOVE9PSIsInZhbHVlIjoiMVQwcnArZ01FZ3EwMkhXNitkenBYWE9aWUdDZ2pjVUJJeTdmdXd0RW4xeW5DOU9zQXR4dXlaUUhnWGtpT0s3L0ZjZnFaQ ▶"
    1 => "6valley1736933341_session=eyJpdiI6InZiV1N3b2ZzblEzaUNtVzdYVjV1UlE9PSIsInZhbHVlIjoialB4Q1F5TjJ6a2VUV2Z6U3NRQXpVTnU0dmRsOXlvY3RxWmNENVBIS1kybHgwRk5zT0YwOUtINWp1dmkvcENkSlp4OThxdmF2YXRpSU5icnZSU0lVZmJRWlFSZktCY0pPaE9hUCs1Q0k1TG92TTB5cG9GdVNXTkdKb0lFVnBnQUciLCJtYWMiOiJkMTMwY2FmMDM2ZDc0NWJlZjY5OTc4YzE3Y2JhMzRhZDhmNTkwNzM5MDkyNzI4Y2Y1ZTY3NzljYjhlMDY0NDg2IiwidGFnIjoiIn0%3D; expires=Sun, 22-Jun-2025 07:40:34 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6InZiV1N3b2ZzblEzaUNtVzdYVjV1UlE9PSIsInZhbHVlIjoialB4Q1F5TjJ6a2VUV2Z6U3NRQXpVTnU0dmRsOXlvY3RxWmNENVBIS1kybHgwRk5zT0YwOUtINWp1dm ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-22 06:40:34	GET	/shopView/15	45 38 49 266

Educational Toys

Wooden Toys

Electronic Toys

Soft Toys

Art and Craft Toys

Music Instruments

Sports Toys

Special

Account & shipping info

Newsletter

1 x Application (75.53%)	1.25s
1 x Booting (24.47%)	407ms

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?