8825441128
8825441128
INR ₹
  • USD
  • BDT
  • Indian Rupee
english english
mappyfy mappyfy
Cancel
Expand Menu
0
Sign in
Sign up
0 My cart 0.00₹
Shopping cart
Cart

Your Cart is Empty!

Click to view
Giggles and Gadjets
(0) 0 Reviews
3 Orders
Chat
Giggles and Gadjets
(0) 0 Reviews
3 Orders
Chat
Messages4TimelineExceptionsViews28RouteQueries53Models168MailsGateSessionRequest
Request history8.2.4PHP Version1.63sRequest Duration48MBMemory UsageGET shopView/{id}Route
  • warninglog[05:56:44] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[05:56:44] LOG.warning: strtotime(): Passing null to parameter #1 ($datetime) of type string is depr...
  • warninglog[05:56:44] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
  • warninglog[05:56:44] LOG.warning: round(): Passing null to parameter #1 ($num) of type int|float is deprecated...
  • Booting (410ms)time
  • Application (1.22s)time
  • 1 x Application (74.81%)
    1.22s
    1 x Booting (25.19%)
    410ms
    28 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
    • 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 duplicates70.09ms
    • GuestMiddleware.php#24mappyfy4.08msinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('216.73.216.11', '2025-06-10 05:56:44', '2025-06-10 05:56:44')
      Bindings
      • 0: 216.73.216.11
      • 1: 2025-06-10 05:56:44
      • 2: 2025-06-10 05:56:44
      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#424mappyfy720μsselect * from `shops` where `id` = '14' limit 1
      Bindings
      • 0: 14
      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#429mappyfy480μsselect * from `sellers` where (`status` = 'approved') and `sellers`.`id` = 19 limit 1
      Bindings
      • 0: approved
      • 1: 19
      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#85mappyfy400μsselect * from `shops` where `id` = '14' limit 1
      Bindings
      • 0: 14
      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.51msselect `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` = 19)
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: approved
      • 4: admin
      • 5: 1
      • 6: digital
      • 7: physical
      • 8: seller
      • 9: 19
      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μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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.02msselect * from `translations` where `translations`.`translationable_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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#2340mappyfy340μsselect * from `reviews` where `reviews`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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.21msselect `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#1920mappyfy520μsselect `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#1926mappyfy850μsselect `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#1934mappyfy450μsselect `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#1738mappyfy4.39msselect `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` = 19) 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: 19
      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#1738mappyfy930μsselect * from `categories` where `categories`.`id` in (4, 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#1738mappyfy350μsselect * from `translations` where `translations`.`translationable_id` in (4, 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#1738mappyfy320μsselect * from `reviews` where `reviews`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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#1738mappyfy380μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `reviews`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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#1738mappyfy560μsselect * from `sellers` where `sellers`.`id` in (19)
      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#1738mappyfy660μsselect * from `shops` where `shops`.`seller_id` in (19)
      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.09msselect * from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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-10' and date(`duration_end_date`) >= '2025-06-10' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '05:56:44' and time(`offer_active_range_end`) >= '05:56:44') 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-10
      • 5: 2025-06-10
      • 6: specific_time
      • 7: 05:56:44
      • 8: 05:56:44
      • 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#1738mappyfy380μsselect * from `translations` where `translations`.`translationable_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1738
      • app/Utils/product-manager.php:2288
      • app/Http/Controllers/Web/ShopViewController.php:87
      • app/Http/Controllers/Web/ShopViewController.php:75
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • ShopViewController.php#472mappyfy1.57msselect `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', '4', '4', '4', '4', '4', '4', '4', '4', '18')
      Bindings
      • 0: 1
      • 1: 1
      • 2: approved
      • 3: admin
      • 4: 1
      • 5: digital
      • 6: physical
      • 7: 0
      • 8: 18
      • 9: 4
      • 10: 4
      • 11: 4
      • 12: 4
      • 13: 4
      • 14: 4
      • 15: 4
      • 16: 4
      • 17: 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#472mappyfy2.11msselect `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4, 18) 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#472mappyfy560μsselect * from `translations` where `translations`.`translationable_id` in (29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145) 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#472mappyfy450μsselect * from `reviews` where `reviews`.`product_id` in (29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 71, 72, 73, 74, 75, 76, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145) 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#472mappyfy760μsselect * from `categories` where `categories`.`parent_id` in (4, 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#472mappyfy790μsselect `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#472mappyfy390μsselect * 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#472mappyfy540μsselect * 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#472mappyfy260μsselect * from `translations` where `translations`.`translationable_id` in (4, 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#505mappyfy1.6msselect `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` = 19) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) as `brand_products_count` from `brands` where `status` = 1 and `id` in (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: 19
      • 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
      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#505mappyfy2.06msselect `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` = 19)
      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: 19
      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#505mappyfy420μsselect * from `translations` where `translations`.`translationable_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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#505mappyfy260μsselect * from `reviews` where `reviews`.`product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) 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#505mappyfy270μsselect * 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.52msselect `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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 and `added_by` = 'seller')))
      Bindings
      • 0: 1
      • 1: 1
      • 2: approved
      • 3: admin
      • 4: 1
      • 5: digital
      • 6: physical
      • 7: digital
      • 8: 110
      • 9: 111
      • 10: 112
      • 11: 113
      • 12: 114
      • 13: 115
      • 14: 116
      • 15: 117
      • 16: 118
      • 17: 119
      • 18: 19
      • 19: seller
      • 20: 1
      • 21: 1
      • 22: approved
      • 23: admin
      • 24: 1
      • 25: digital
      • 26: physical
      • 27: digital
      • 28: 110
      • 29: 111
      • 30: 112
      • 31: 113
      • 32: 114
      • 33: 115
      • 34: 116
      • 35: 117
      • 36: 118
      • 37: 119
      • 38: 19
      • 39: 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#1821mappyfy900μsselect 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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 and `added_by` = 'seller')
      Bindings
      • 0: 1
      • 1: 1
      • 2: approved
      • 3: admin
      • 4: 1
      • 5: digital
      • 6: physical
      • 7: digital
      • 8: 110
      • 9: 111
      • 10: 112
      • 11: 113
      • 12: 114
      • 13: 115
      • 14: 116
      • 15: 117
      • 16: 118
      • 17: 119
      • 18: 19
      • 19: 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.29msselect `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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 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: 110
      • 9: 111
      • 10: 112
      • 11: 113
      • 12: 114
      • 13: 115
      • 14: 116
      • 15: 117
      • 16: 118
      • 17: 119
      • 18: 19
      • 19: seller
      • 20: 1
      • 21: 1
      • 22: approved
      • 23: admin
      • 24: 1
      • 25: digital
      • 26: physical
      • 27: digital
      • 28: 110
      • 29: 111
      • 30: 112
      • 31: 113
      • 32: 114
      • 33: 115
      • 34: 116
      • 35: 117
      • 36: 118
      • 37: 119
      • 38: 19
      • 39: 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#1886mappyfy550μsselect 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 (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and (`user_id` = 19 and `added_by` = 'seller')
      Bindings
      • 0: 1
      • 1: 1
      • 2: approved
      • 3: admin
      • 4: 1
      • 5: digital
      • 6: physical
      • 7: digital
      • 8: 110
      • 9: 111
      • 10: 112
      • 11: 113
      • 12: 114
      • 13: 115
      • 14: 116
      • 15: 117
      • 16: 118
      • 17: 119
      • 18: 19
      • 19: 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.2msselect count(*) as aggregate from `orders` where (`seller_is` = 'seller' and `seller_id` = 19) and `order_type` = 'default_type'
      Bindings
      • 0: seller
      • 1: 19
      • 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#46mappyfy580μsselect * from `shops` where `id` = '14' limit 1
      Bindings
      • 0: 14
      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#52mappyfy460μsselect * from `shops` where `id` = '14' limit 1
      Bindings
      • 0: 14
      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#54mappyfy550μsselect avg(`rating`) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and `status` = 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 110
      • 3: 111
      • 4: 112
      • 5: 113
      • 6: 114
      • 7: 115
      • 8: 116
      • 9: 117
      • 10: 118
      • 11: 119
      • 12: 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#55mappyfy330μsselect count(*) as aggregate from `reviews` where `status` = 1 and `status` = 1 and `product_id` in (110, 111, 112, 113, 114, 115, 116, 117, 118, 119) and `status` = 1
      Bindings
      • 0: 1
      • 1: 1
      • 2: 110
      • 3: 111
      • 4: 112
      • 5: 113
      • 6: 114
      • 7: 115
      • 8: 116
      • 9: 117
      • 10: 118
      • 11: 119
      • 12: 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#66mappyfy790μsselect * from `sellers` where `sellers`.`id` = 19 limit 1
      Bindings
      • 0: 19
      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#94mappyfy900μsselect 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-10' and date(`duration_end_date`) >= '2025-06-10' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '05:56:44' and time(`offer_active_range_end`) >= '05:56:44') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null))) and (`shop_id` = '14')
      Bindings
      • 0: 1
      • 1: admin
      • 2: vendor
      • 3: 1
      • 4: 2025-06-10
      • 5: 2025-06-10
      • 6: specific_time
      • 7: 05:56:44
      • 8: 05:56:44
      • 9: always
      • 10: 14
      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#95mappyfy610μsselect * from `stock_clearance_setups` where (`shop_id` = '14') limit 1
      Bindings
      • 0: 14
      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#37mappyfy910μsselect * from `currencies` where `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • view::layouts.front-end.partials._header:37
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • cart-manager.php#128mappyfy19.98msselect `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` = 22829 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: 22829
      • 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#67mappyfy1.13msselect * 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#128mappyfy550μsselect `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` = 22829 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: 22829
      • 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#67mappyfy430μsselect * 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#109mappyfy790μsselect * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-06-10' and date(`end_date`) >= '2025-06-10' limit 1
      Bindings
      • 0: 1
      • 1: flash_deal
      • 2: 2025-06-10
      • 3: 2025-06-10
      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
    142Product.php#?
    App\Models\Category
    12Category.php#?
    App\Models\Shop
    5Shop.php#?
    App\Models\Seller
    3Seller.php#?
    App\Models\Currency
    3Currency.php#?
    App\Models\Review
    2Review.php#?
    App\Models\Brand
    1Brand.php#?
        system_default_currency_info
        App\Models\Currency {#2206 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        INR
        currency_symbol
        ₹
        currency_exchange_rate
        1
        usd
        0.016666666666667
        _token
        CDsJOZtQ6jCeV0WDaZit9XLdvzeua0960fXuwBOr
        guest_id
        22829
        local
        en
        direction
        ltr
        _previous
        array:1 [ "url" => "https://mappyfy.com/shopView/14" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /shopView/14
        status_code
        200
        status_text
        OK
        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 => "Tue, 10 Jun 2025 05:56:44 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJKcW55MnEzVVNqZmpsNjRNb2IrdGc9PSIsInZhbHVlIjoiaDBGdk96QUFBRnFlQkFUeVBHT01DblA5ck10WjROblZUaHJ5R1NiMmpza29wTGxVSnhhYkxHZkw4VHp3eGVDcHovT2xENThNVklYakdiTEZ2VWNRdDhrVUpOWlBmYW00aVk5TllsZ1dMMm16bGo5YzFkMHM1NjM2aU9seFBtMVQiLCJtYWMiOiJjNDcxMDVjMjI1MTY0OTNkMTI2ODhmMzI4NjYyYzY4NTRlMTJjYzE5YzlmMGIyOWUzZjRiNTkyZjM0MjhmMjUzIiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 06:56:45 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6InJKcW55MnEzVVNqZmpsNjRNb2IrdGc9PSIsInZhbHVlIjoiaDBGdk96QUFBRnFlQkFUeVBHT01DblA5ck10WjROblZUaHJ5R1NiMmpza29wTGxVSnhhYkxHZkw4VHp3eGVDcHovT2xEN ▶"
    1 => "6valley1736933341_session=eyJpdiI6ImhSQ3VtV2h3U1RuYWNOSFBpM3N2bFE9PSIsInZhbHVlIjoiYlU2clpVR0FMZ216bW96RTZVdGZQZHRUTllWTENjdUt6cit4bjZLSjFWNDl4c1Z3N2pIczNKTmRDRkZTcUtRcnV6L1Z3WDhTak1VOW4ybHNoNFpPRE5QdVNEMW5MUUZySzFCMDJqWlh2Y3QzUFVnOGk2Q2JHOVJVWkpsTTAzVVYiLCJtYWMiOiJiODI5OTYxMWE3NjhkNDZkNjI0YTFkOTE4NTgwYWM1OTZjMGIzOTE2N2RhMzYzMjkzYWM3MTUwNmVjZWI1NzYxIiwidGFnIjoiIn0%3D; expires=Tue, 10 Jun 2025 06:56:45 GMT; Max-Age=3600; path=/; httponly ◀6valley1736933341_session=eyJpdiI6ImhSQ3VtV2h3U1RuYWNOSFBpM3N2bFE9PSIsInZhbHVlIjoiYlU2clpVR0FMZ216bW96RTZVdGZQZHRUTllWTENjdUt6cit4bjZLSjFWNDl4c1Z3N2pIczNKTmRDRk ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJKcW55MnEzVVNqZmpsNjRNb2IrdGc9PSIsInZhbHVlIjoiaDBGdk96QUFBRnFlQkFUeVBHT01DblA5ck10WjROblZUaHJ5R1NiMmpza29wTGxVSnhhYkxHZkw4VHp3eGVDcHovT2xENThNVklYakdiTEZ2VWNRdDhrVUpOWlBmYW00aVk5TllsZ1dMMm16bGo5YzFkMHM1NjM2aU9seFBtMVQiLCJtYWMiOiJjNDcxMDVjMjI1MTY0OTNkMTI2ODhmMzI4NjYyYzY4NTRlMTJjYzE5YzlmMGIyOWUzZjRiNTkyZjM0MjhmMjUzIiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 06:56:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJKcW55MnEzVVNqZmpsNjRNb2IrdGc9PSIsInZhbHVlIjoiaDBGdk96QUFBRnFlQkFUeVBHT01DblA5ck10WjROblZUaHJ5R1NiMmpza29wTGxVSnhhYkxHZkw4VHp3eGVDcHovT2xEN ▶"
    1 => "6valley1736933341_session=eyJpdiI6ImhSQ3VtV2h3U1RuYWNOSFBpM3N2bFE9PSIsInZhbHVlIjoiYlU2clpVR0FMZ216bW96RTZVdGZQZHRUTllWTENjdUt6cit4bjZLSjFWNDl4c1Z3N2pIczNKTmRDRkZTcUtRcnV6L1Z3WDhTak1VOW4ybHNoNFpPRE5QdVNEMW5MUUZySzFCMDJqWlh2Y3QzUFVnOGk2Q2JHOVJVWkpsTTAzVVYiLCJtYWMiOiJiODI5OTYxMWE3NjhkNDZkNjI0YTFkOTE4NTgwYWM1OTZjMGIzOTE2N2RhMzYzMjkzYWM3MTUwNmVjZWI1NzYxIiwidGFnIjoiIn0%3D; expires=Tue, 10-Jun-2025 06:56:45 GMT; path=/; httponly ◀6valley1736933341_session=eyJpdiI6ImhSQ3VtV2h3U1RuYWNOSFBpM3N2bFE9PSIsInZhbHVlIjoiYlU2clpVR0FMZ216bW96RTZVdGZQZHRUTllWTENjdUt6cit4bjZLSjFWNDl4c1Z3N2pIczNKTmRDRk ▶"
  ]
]
        session_attributes
          0 of 0   
        array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#2206 ▶
    #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" => "CDsJOZtQ6jCeV0WDaZit9XLdvzeua0960fXuwBOr"
  "guest_id" => 22829
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://mappyfy.com/shopView/14"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-10 05:56:45GET/shopView/1442853168