Products (Electronic Gadgets)
42 Items found
Request history8.2.4PHP Version1.83sRequest Duration48MBMemory UsageGET productsRoute
  • warninglog[06:45:47] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • Booting (430ms)time
  • Application (1.4s)time
  • 1 x Application (76.55%)
    1.40s
    1 x Booting (23.45%)
    430ms
    35 templates were rendered
    • web-views.products.viewview.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 products
    middleware
    web, maintenance_mode, guestCheck
    controller
    App\Http\Controllers\Web\ProductListController@products
    namespace
    App\Http\Controllers\Web
    prefix
    where
    as
    products
    file
    app/Http/Controllers/Web/ProductListController.php:24-33
    28 statements were executed (9 duplicates)Show only duplicates69.33ms
    • GuestMiddleware.php#24mappyfy13.05msinsert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.217.19.206', '2025-06-02 06:45:47', '2025-06-02 06:45:47')
      Bindings
      • 0: 18.217.19.206
      • 1: 2025-06-02 06:45:47
      • 2: 2025-06-02 06:45:47
      Backtrace
      • middleware::guestCheck:24
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • middleware::maintenance_mode:30
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • middleware::api_lang:22
    • ProductListController.php#42mappyfy4.42msselect * from `categories` where `categories`.`id` = 18 limit 1
      Bindings
      • 0: 18
      Backtrace
      • app/Http/Controllers/Web/ProductListController.php:42
      • app/Http/Controllers/Web/ProductListController.php:29
      • 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
    • ProductListController.php#42mappyfy6.03msselect * 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/ProductListController.php:42
      • app/Http/Controllers/Web/ProductListController.php:29
      • 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#1911mappyfy5.35msselect `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/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1920mappyfy3.58msselect `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/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1926mappyfy2.83msselect `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/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1934mappyfy1.52msselect `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/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • product-manager.php#1981mappyfy1.96msselect * from `categories`
      Backtrace
      • app/Utils/product-manager.php:1981
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1981mappyfy780μsselect * from `translations` where `translations`.`translationable_id` in (4, 5, 6, 7, 8, 9, 10, 11, 17, 18) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
      Bindings
      • 0: App\Models\Category
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1981
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1987mappyfy410μsselect * from `categories` where `id` in ('18')
      Bindings
      • 0: 18
      Backtrace
      • app/Utils/product-manager.php:1987
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1987mappyfy2.74msselect * 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:1987
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1988mappyfy370μsselect * from `categories` where `id` in (null)
      Bindings
      • 0: 
      Backtrace
      • app/Utils/product-manager.php:1988
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1989mappyfy330μsselect * from `categories` where `id` in (null)
      Bindings
      • 0: 
      Backtrace
      • app/Utils/product-manager.php:1989
      • vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
      • app/Utils/product-manager.php:1977
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
    • product-manager.php#1345mappyfy10.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 `category_id` in (18) and (`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')) or (0 = 1 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')) or (0 = 1 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')) order by `order_details_count` desc
      Bindings
      • 0: 1
      • 1: 1
      • 2: 1
      • 3: 1
      • 4: 1
      • 5: approved
      • 6: admin
      • 7: 1
      • 8: digital
      • 9: physical
      • 10: 18
      • 11: 18
      • 12: 1
      • 13: 1
      • 14: approved
      • 15: admin
      • 16: 1
      • 17: digital
      • 18: physical
      • 19: 1
      • 20: 1
      • 21: approved
      • 22: admin
      • 23: 1
      • 24: digital
      • 25: physical
      • 26: 1
      • 27: 1
      • 28: approved
      • 29: admin
      • 30: 1
      • 31: digital
      • 32: physical
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy2.18msselect * from `categories` where `categories`.`id` in (18)
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy540μsselect * 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:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy710μsselect * 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, 110, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133) and `delivery_man_id` is null and `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy670μsselect avg(rating) average, product_id from `reviews` where `delivery_man_id` is null and `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, 110, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133) and `status` = 1 group by `product_id`
      Bindings
      • 0: 1
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy510μsselect * from `sellers` where `sellers`.`id` in (14, 19, 20)
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy600μsselect * from `shops` where `shops`.`seller_id` in (14, 19, 20)
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy4.11msselect * from `stock_clearance_products` where `stock_clearance_products`.`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, 110, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133) 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-02' and date(`duration_end_date`) >= '2025-06-02' and ((`offer_active_time` = 'specific_time' and time(`offer_active_range_start`) <= '06:45:47' and time(`offer_active_range_end`) >= '06:45:47') or (`offer_active_time` = 'always' and `offer_active_range_start` is null and `offer_active_range_end` is null)))
      Bindings
      • 0: 1
      • 1: admin
      • 2: vendor
      • 3: 1
      • 4: 2025-06-02
      • 5: 2025-06-02
      • 6: specific_time
      • 7: 06:45:47
      • 8: 06:45:47
      • 9: always
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • product-manager.php#1345mappyfy690μsselect * 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, 110, 119, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'en'
      Bindings
      • 0: App\Models\Product
      • 1: en
      Backtrace
      • app/Utils/product-manager.php:1345
      • app/Utils/product-manager.php:2274
      • app/Http/Controllers/Web/ProductListController.php:53
      • app/Http/Controllers/Web/ProductListController.php:29
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • _header.blade.php#37mappyfy1.23msselect * from `currencies` where `status` = 1
      Bindings
      • 0: 1
      Backtrace
      • view::layouts.front-end.partials._header:37
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • cart-manager.php#128mappyfy2.1msselect `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` = 20440 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: 20440
      • 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#67mappyfy500μ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
      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#128mappyfy420μ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` = 20440 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: 20440
      • 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#109mappyfy880μsselect * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-06-02' and date(`end_date`) >= '2025-06-02' limit 1
      Bindings
      • 0: 1
      • 1: flash_deal
      • 2: 2025-06-02
      • 3: 2025-06-02
      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
    42Product.php#?
    App\Models\Category
    13Category.php#?
    App\Models\Seller
    3Seller.php#?
    App\Models\Shop
    3Shop.php#?
    App\Models\Currency
    3Currency.php#?
    App\Models\Review
    2Review.php#?
        system_default_currency_info
        App\Models\Currency {#2168 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
        currency_code
        INR
        currency_symbol
        currency_exchange_rate
        1
        usd
        0.016666666666667
        _token
        0YxMpn5T8dXnuNc1AvcSBGrtDSdrE5ZEGFNUwu96
        guest_id
        20440
        local
        en
        direction
        ltr
        _previous
        array:1 [ "url" => "https://mappyfy.com/products?category_id=18&data_from=category&page=1" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /products
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:3 [ "category_id" => "18" "data_from" => "category" "page" => "1" ]
        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 => "Mon, 02 Jun 2025 06:45:47 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNzOWlrMkI5QlZTNDlXL1ZXR2d0TkE9PSIsInZhbHVlIjoiVkJsbHlKcUFxRXJFVmVhUTFiYW5rdVArTzFPMi84UzRZSDRiVFVGaXpKRCtkOTdpbkNXVmFEZEtPQ1gxRE5ZTmRpMWxTMkVQbjkrWldLWVRrcFozTlI0bGp3SlQrY2lJUVZjMkFRYlcwa2tvRmcyVmYrM3VCT1dZbENCdlNpcFIiLCJtYWMiOiI5YmVlYWFkYTg2NWMxYzMyMDMyYjQxY2Q5ZjdlY2RhMDdmYzk0MjVhYzhlMjU4MGNjNGM0OTY5MzlkMGE4ZDEzIiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 07:45:48 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6IkNzOWlrMkI5QlZTNDlXL1ZXR2d0TkE9PSIsInZhbHVlIjoiVkJsbHlKcUFxRXJFVmVhUTFiYW5rdVArTzFPMi84UzRZSDRiVFVGaXpKRCtkOTdpbkNXVmFEZEtPQ1gxRE5ZTmRpMWxTM" 1 => "6valley1736933341_session=eyJpdiI6IjMxancwVUhIb0x3ZzNxT2ZONWtJcEE9PSIsInZhbHVlIjoiRVlWOEkySURzTkRGZmwvTmlJM3dTREVPWG9wb01teFJXMVBSTjgvTDhON1FqSW4xcDJKNEZGdmw2MDB4cGVtdWgxYnIxMGFUZGVaVUlRWUdpb2FrNHMycGVIZXBSY1VtRDVOdHVqTDVEK25XWTU0ZUZwQyt2ZWRQWXRvdnhhWmoiLCJtYWMiOiJjNDdjODExNDQxZGJiZGMxMzhkMmFiMmVmYzk3NDE3OTYxNmI2ODIwYTZhODQ3ZWUxYTdlM2RkMjQ2NGFiYmY4IiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 07:45:48 GMT; Max-Age=3600; path=/; httponly6valley1736933341_session=eyJpdiI6IjMxancwVUhIb0x3ZzNxT2ZONWtJcEE9PSIsInZhbHVlIjoiRVlWOEkySURzTkRGZmwvTmlJM3dTREVPWG9wb01teFJXMVBSTjgvTDhON1FqSW4xcDJKNEZGdmw2MD" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNzOWlrMkI5QlZTNDlXL1ZXR2d0TkE9PSIsInZhbHVlIjoiVkJsbHlKcUFxRXJFVmVhUTFiYW5rdVArTzFPMi84UzRZSDRiVFVGaXpKRCtkOTdpbkNXVmFEZEtPQ1gxRE5ZTmRpMWxTMkVQbjkrWldLWVRrcFozTlI0bGp3SlQrY2lJUVZjMkFRYlcwa2tvRmcyVmYrM3VCT1dZbENCdlNpcFIiLCJtYWMiOiI5YmVlYWFkYTg2NWMxYzMyMDMyYjQxY2Q5ZjdlY2RhMDdmYzk0MjVhYzhlMjU4MGNjNGM0OTY5MzlkMGE4ZDEzIiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 07:45:48 GMT; path=/XSRF-TOKEN=eyJpdiI6IkNzOWlrMkI5QlZTNDlXL1ZXR2d0TkE9PSIsInZhbHVlIjoiVkJsbHlKcUFxRXJFVmVhUTFiYW5rdVArTzFPMi84UzRZSDRiVFVGaXpKRCtkOTdpbkNXVmFEZEtPQ1gxRE5ZTmRpMWxTM" 1 => "6valley1736933341_session=eyJpdiI6IjMxancwVUhIb0x3ZzNxT2ZONWtJcEE9PSIsInZhbHVlIjoiRVlWOEkySURzTkRGZmwvTmlJM3dTREVPWG9wb01teFJXMVBSTjgvTDhON1FqSW4xcDJKNEZGdmw2MDB4cGVtdWgxYnIxMGFUZGVaVUlRWUdpb2FrNHMycGVIZXBSY1VtRDVOdHVqTDVEK25XWTU0ZUZwQyt2ZWRQWXRvdnhhWmoiLCJtYWMiOiJjNDdjODExNDQxZGJiZGMxMzhkMmFiMmVmYzk3NDE3OTYxNmI2ODIwYTZhODQ3ZWUxYTdlM2RkMjQ2NGFiYmY4IiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 07:45:48 GMT; path=/; httponly6valley1736933341_session=eyJpdiI6IjMxancwVUhIb0x3ZzNxT2ZONWtJcEE9PSIsInZhbHVlIjoiRVlWOEkySURzTkRGZmwvTmlJM3dTREVPWG9wb01teFJXMVBSTjgvTDhON1FqSW4xcDJKNEZGdmw2MD" ] ]
        session_attributes
        0 of 0
        array:11 [ "system_default_currency_info" => App\Models\Currency {#2168 #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" => "0YxMpn5T8dXnuNc1AvcSBGrtDSdrE5ZEGFNUwu96" "guest_id" => 20440 "local" => "en" "direction" => "ltr" "_previous" => array:1 [ "url" => "https://mappyfy.com/products?category_id=18&data_from=category&page=1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-02 06:45:48GET/products?category_id=18&data_from=category&page=11352866