No product found
busy...
Shop 03
Display Name > Business 03 (Online)

We're just one step away! Please login to start the conversation. Login

8.1.32PHP Version96.3msRequest Duration5MBMemory UsageGET shop/{slug}/productsRoute
    • Booting (35.76ms)
    • Application (60.35ms)
    • 1 x Application (62.67%)
      60.35ms
      1 x Booting (37.14%)
      35.76ms
      36 templates were rendered
      • theme::shop (public/themes/default/views/shop.blade.php)2blade
        Params
        0
        shop
        1
        products
      • theme::banners.shop_cover (public/themes/default/views/banners/shop_cover.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::layouts.ratings (public/themes/default/views/layouts/ratings.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        ratings
        12
        count
      • theme::headers.shop_page (public/themes/default/views/headers/shop_page.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::headers.lists.home (public/themes/default/views/headers/lists/home.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::headers.lists.shop (public/themes/default/views/headers/lists/shop.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::contents.shop_products (public/themes/default/views/contents/shop_products.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::sections.recent_views (public/themes/default/views/sections/recent_views.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • liveChat::livechat (packages/liveChat/resources/views/livechat.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        agent
        12
        agent_status
      • theme::layouts.main (public/themes/default/views/layouts/main.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • meta (resources/views/meta.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::nav.main (public/themes/default/views/nav/main.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • searchAutocomplete::_autoComplete (packages/searchAutocomplete/resources/views/_autoComplete.blade.php)16blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        __currentLoopData
        12
        lang
        13
        loop
        14
        search_category_grp
        15
        search_category
      • theme::nav.mobile (public/themes/default/views/nav/mobile.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::nav.footer (public/themes/default/views/nav/footer.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::nav.copyright (public/themes/default/views/nav/copyright.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        __currentLoopData
        12
        page
        13
        loop
        14
        social_media_links
        15
        link
        16
        social_media
        17
        trust_badge
      • theme::auth.modals (public/themes/default/views/auth/modals.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::auth._social_login (public/themes/default/views/auth/_social_login.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::auth._social_login (public/themes/default/views/auth/_social_login.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::notifications (public/themes/default/views/notifications.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::scripts.appjs (public/themes/default/views/scripts/appjs.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • searchAutocomplete::scripts (packages/searchAutocomplete/resources/views/scripts.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • wishlist::script (packages/wishlist/resources/views/script.blade.php)11blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • theme::layouts.notification (public/themes/default/views/layouts/notification.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        promotional_tagline
        4
        pages
        5
        all_categories
        6
        search_category_list
        7
        recently_viewed_items
        8
        cart_item_count
        9
        shop
        10
        products
        11
        message
        12
        type
        13
        icon
      • analytic_script (resources/views/analytic_script.blade.php)0blade
      • cookie_consent (resources/views/cookie_consent.blade.php)0blade
      uri
      GET shop/{slug}/products
      middleware
      web, storefront
      controller
      App\Http\Controllers\Storefront\HomeController@shopProducts
      namespace
      Storefront
      prefix
      where
      as
      shop.products
      file
      app/Http/Controllers/Storefront/HomeController.php:470-492
      22 statements were executed20.36ms
      • select `id`, `name`, `slug`, `icon` from `category_groups` where exists (select * from `category_sub_groups` where `category_groups`.`id` = `category_sub_groups`.`category_group_id` and exists (select * from `categories` where `category_sub_groups`.`id` = `categories`.`category_sub_group_id` and exists (select * from `products` inner join `category_product` on `products`.`id` = `category_product`.`product_id` where `categories`.`id` = `category_product`.`category_id` and exists (select * from `inventories` where `products`.`id` = `inventories`.`product_id` and `inventories`.`deleted_at` is null) and `products`.`deleted_at` is null) and `categories`.`deleted_at` is null) and `category_sub_groups`.`deleted_at` is null) and `active` = 1 and `category_groups`.`deleted_at` is null order by `order` asc
        3.36ms/app/Helpers/ListHelper.php:343demoadmin_smb
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 14. /app/Helpers/ListHelper.php:343
        • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 18. /app/Helpers/ListHelper.php:344
        • 19. middleware::storefront:44
      • select `id`, `path`, `imageable_id`, `imageable_type` from `images` where `type` = 'logo' and `images`.`imageable_id` in (1, 5) and `images`.`imageable_type` = 'App\Models\CategoryGroup'
        1ms/app/Helpers/ListHelper.php:343demoadmin_smb
        Metadata
        Bindings
        • 0. logo
        • 1. App\Models\CategoryGroup
        Backtrace
        • 19. /app/Helpers/ListHelper.php:343
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 21. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 23. /app/Helpers/ListHelper.php:344
        • 24. middleware::storefront:44
      • select `id`, `path`, `imageable_id`, `imageable_type` from `images` where `type` = 'background' and `images`.`imageable_id` in (1, 5) and `images`.`imageable_type` = 'App\Models\CategoryGroup'
        940μs/app/Helpers/ListHelper.php:343demoadmin_smb
        Metadata
        Bindings
        • 0. background
        • 1. App\Models\CategoryGroup
        Backtrace
        • 19. /app/Helpers/ListHelper.php:343
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 21. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 23. /app/Helpers/ListHelper.php:344
        • 24. middleware::storefront:44
      • select `id`, `slug`, `category_group_id`, `name`, (select count(*) from `categories` where `category_sub_groups`.`id` = `categories`.`category_sub_group_id` and `categories`.`deleted_at` is null) as `categories_count` from `category_sub_groups` where `category_sub_groups`.`category_group_id` in (1, 5) and `active` = 1 and exists (select * from `categories` where `category_sub_groups`.`id` = `categories`.`category_sub_group_id` and exists (select * from `products` inner join `category_product` on `products`.`id` = `category_product`.`product_id` where `categories`.`id` = `category_product`.`category_id` and exists (select * from `inventories` where `products`.`id` = `inventories`.`product_id` and `inventories`.`deleted_at` is null) and `products`.`deleted_at` is null) and `categories`.`deleted_at` is null) and `category_sub_groups`.`deleted_at` is null order by `order` asc, `categories_count` desc
        950μs/app/Helpers/ListHelper.php:343demoadmin_smb
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/Helpers/ListHelper.php:343
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 21. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 23. /app/Helpers/ListHelper.php:344
        • 24. middleware::storefront:44
      • select `id`, `category_sub_group_id`, `name`, `slug`, `description` from `categories` where `categories`.`category_sub_group_id` in (27, 28, 37) and `active` = 1 and exists (select * from `products` inner join `category_product` on `products`.`id` = `category_product`.`product_id` where `categories`.`id` = `category_product`.`category_id` and exists (select * from `inventories` where `products`.`id` = `inventories`.`product_id` and `inventories`.`deleted_at` is null) and `products`.`deleted_at` is null) and `categories`.`deleted_at` is null order by `order` asc
        430μs/app/Helpers/ListHelper.php:343demoadmin_smb
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 24. /app/Helpers/ListHelper.php:343
        • 25. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 26. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 28. /app/Helpers/ListHelper.php:344
        • 29. middleware::storefront:44
      • select `id`, `name`, `slug` from `category_groups` where exists (select * from `category_sub_groups` where `category_groups`.`id` = `category_sub_groups`.`category_group_id` and `active` = 1 and `category_sub_groups`.`deleted_at` is null) and `active` = 1 and `category_groups`.`deleted_at` is null order by `order` desc
        370μs/app/Helpers/ListHelper.php:408demoadmin_smb
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 14. /app/Helpers/ListHelper.php:408
        • 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 18. /app/Helpers/ListHelper.php:409
        • 19. middleware::storefront:45
      • select `name`, `slug`, `category_group_id` from `category_sub_groups` where `category_sub_groups`.`category_group_id` in (1, 2, 3, 4, 5, 11, 12, 13) and `active` = 1 and `category_sub_groups`.`deleted_at` is null order by `order` asc
        320μs/app/Helpers/ListHelper.php:408demoadmin_smb
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 19. /app/Helpers/ListHelper.php:408
        • 20. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391
        • 21. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 23. /app/Helpers/ListHelper.php:409
        • 24. middleware::storefront:45
      • select count(*) as aggregate from `carts` inner join `cart_items` on `cart_items`.`cart_id` = `carts`.`id` where `customer_id` is null and `deleted_at` is null and `ip_address` = '3.143.244.80'
        610μs/app/Helpers/Functions.php:1586demoadmin_smb
        Metadata
        Bindings
        • 0. 3.143.244.80
        Backtrace
        • 14. /app/Helpers/Functions.php:1586
        • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 17. /app/Http/Middleware/CookieConsentMiddleware.php:21
        • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
        • 19. /app/Http/Middleware/Language.php:64
      • select * from `visitors` where `visitors`.`ip` = '3.143.244.80' limit 1
        300μs/app/Jobs/UpdateVisitorTable.php:42demoadmin_smb
        Metadata
        Bindings
        • 0. 3.143.244.80
        Backtrace
        • 16. /app/Jobs/UpdateVisitorTable.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 20. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
      • insert into `visitors` (`ip`, `hits`, `page_views`, `updated_at`, `created_at`) values ('3.143.244.80', 1, 1, '2025-04-15 00:50:15', '2025-04-15 00:50:15')
        1.69ms/app/Jobs/UpdateVisitorTable.php:60demoadmin_smb
        Metadata
        Bindings
        • 0. 3.143.244.80
        • 1. 1
        • 2. 1
        • 3. 2025-04-15 00:50:15
        • 4. 2025-04-15 00:50:15
        Backtrace
        • 13. /app/Jobs/UpdateVisitorTable.php:60
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 15. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
      • select * from `shops` where `slug` = 'peda-ting-ting' and `active` = 1 and exists (select * from `addresses` where `shops`.`id` = `addresses`.`addressable_id` and `addresses`.`addressable_type` = 'App\Models\Shop') and exists (select * from `configs` where `shops`.`id` = `configs`.`shop_id` and `maintenance_mode` != 1 and `active_ecommerce` = 1) and exists (select * from `payment_methods` inner join `shop_payment_methods` on `payment_methods`.`id` = `shop_payment_methods`.`payment_method_id` where `shops`.`id` = `shop_payment_methods`.`shop_id`) and `shops`.`deleted_at` is null limit 1
        620μs/app/Http/Controllers/Storefront/HomeController.php:472demoadmin_smb
        Metadata
        Bindings
        • 0. peda-ting-ting
        • 1. 1
        • 2. App\Models\Shop
        • 3. 1
        • 4. 1
        Backtrace
        • 16. /app/Http/Controllers/Storefront/HomeController.php:472
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `maintenance_mode` from `configs` where `shop_id` = 3 limit 1
        230μs/app/Helpers/SystemHelper.php:237demoadmin_smb
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 14. /app/Helpers/SystemHelper.php:237
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select count(*) as aggregate from (select `inventories`.*, (select count(*) from `orders` inner join `order_items` on `orders`.`id` = `order_items`.`order_id` where `inventories`.`id` = `order_items`.`inventory_id` and `order_items`.`created_at` >= '2025-04-14 00:50:15' and `orders`.`deleted_at` is null) as `orders_count` from `inventories` where `shop_id` = 3 and exists (select * from `shops` where `inventories`.`shop_id` = `shops`.`id` and `active` = 1 and exists (select * from `addresses` where `shops`.`id` = `addresses`.`addressable_id` and `addresses`.`addressable_type` = 'App\Models\Shop') and exists (select * from `configs` where `shops`.`id` = `configs`.`shop_id` and `maintenance_mode` != 1 and `active_ecommerce` = 1) and exists (select * from `payment_methods` inner join `shop_payment_methods` on `payment_methods`.`id` = `shop_payment_methods`.`payment_method_id` where `shops`.`id` = `shop_payment_methods`.`shop_id`) and `shops`.`deleted_at` is null) and (`active` = 1 and `stock_quantity` > 0 and `available_from` <= '2025-04-15 00:50:15') and exists (select * from `shops` where `inventories`.`shop_id` = `shops`.`id` and exists (select * from `addresses` where `shops`.`id` = `addresses`.`addressable_id` and `addresses`.`addressable_type` = 'App\Models\Shop' and `zip_code` is null) and `shops`.`deleted_at` is null) and `inventories`.`deleted_at` is null group by `product_id`) as `aggregate_table`
        3.01ms/app/Http/Controllers/Storefront/HomeController.php:489demoadmin_smb
        Metadata
        Bindings
        • 0. 2025-04-14 00:50:15
        • 1. 3
        • 2. 1
        • 3. App\Models\Shop
        • 4. 1
        • 5. 1
        • 6. 1
        • 7. 0
        • 8. 2025-04-15 00:50:15
        • 9. App\Models\Shop
        Backtrace
        • 15. /app/Http/Controllers/Storefront/HomeController.php:489
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `images` where `images`.`imageable_type` = 'App\Models\Shop' and `images`.`imageable_id` = 3 and `images`.`imageable_id` is not null and `type` = 'cover' limit 1
        1.04ms/app/Helpers/Functions.php:701demoadmin_smb
        Metadata
        Bindings
        • 0. App\Models\Shop
        • 1. 3
        • 2. cover
        Backtrace
        • 21. /app/Helpers/Functions.php:701
        • 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 27. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `images` where `images`.`imageable_type` = 'App\Models\Shop' and `images`.`imageable_id` = 3 and `images`.`imageable_id` is not null and `type` = 'logo' limit 1
        950μsview::5e49d96201841cd0924449514bd8e84e14aa37a5:4demoadmin_smb
        Metadata
        Bindings
        • 0. App\Models\Shop
        • 1. 3
        • 2. logo
        Backtrace
        • 20. view::5e49d96201841cd0924449514bd8e84e14aa37a5:4
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `feedbacks` where `feedbacks`.`feedbackable_type` = 'App\Models\Shop' and `feedbacks`.`feedbackable_id` = 3 and `feedbacks`.`feedbackable_id` is not null order by `created_at` desc
        440μsview::5e49d96201841cd0924449514bd8e84e14aa37a5:11demoadmin_smb
        Metadata
        Bindings
        • 0. App\Models\Shop
        • 1. 3
        Backtrace
        • 19. view::5e49d96201841cd0924449514bd8e84e14aa37a5:11
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `configs` where `configs`.`shop_id` = 3 and `configs`.`shop_id` is not null limit 1
        480μs/app/Helpers/Functions.php:2236demoadmin_smb
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 20. /app/Helpers/Functions.php:2236
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `users` where `users`.`id` = 5 limit 1
        410μsview::27d8a1c5278045296502b19486db59f5dd4f170d:25demoadmin_smb
        Metadata
        Bindings
        • 0. 5
        Backtrace
        • 20. view::27d8a1c5278045296502b19486db59f5dd4f170d:25
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `images` where `images`.`imageable_type` = 'App\Models\Shop' and `images`.`imageable_id` = 3 and `images`.`imageable_id` is not null order by `order` asc limit 1
        790μsview::a9979ea04ab30397c7e625e95c919d62ba0355b6:6demoadmin_smb
        Metadata
        Bindings
        • 0. App\Models\Shop
        • 1. 3
        Backtrace
        • 20. view::a9979ea04ab30397c7e625e95c919d62ba0355b6:6
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `option_value` from `options` where `option_name` = 'theme_custom_styling' limit 1
        270μs/app/Helpers/Functions.php:1847demoadmin_smb
        Metadata
        Bindings
        • 0. theme_custom_styling
        Backtrace
        • 13. /app/Helpers/Functions.php:1847
        • 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `systems` order by `id` asc limit 1
        560μs/app/Helpers/Functions.php:747demoadmin_smb
        Metadata
        Backtrace
        • 15. /app/Helpers/Functions.php:747
        • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 19. /app/Helpers/Functions.php:754
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `images` where `images`.`imageable_type` = 'App\Models\System' and `images`.`imageable_id` = 1 and `images`.`imageable_id` is not null and `type` = 'feature' limit 1
        1.59ms/app/Helpers/Functions.php:749demoadmin_smb
        Metadata
        Bindings
        • 0. App\Models\System
        • 1. 1
        • 2. feature
        Backtrace
        • 20. /app/Helpers/Functions.php:749
        • 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418
        • 24. /app/Helpers/Functions.php:754
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      App\Models\System
      1
      App\Models\User
      1
      App\Models\Config
      1
      App\Models\Feedback
      14
      App\Models\Shop
      1
      App\Models\Category
      3
      App\Models\CategorySubGroup
      20
      App\Models\Image
      5
      App\Models\CategoryGroup
      10
          _token
          WxraAvV7fdI0CBHWMT1v2zFyGjSnfDgTxGrXvVwD
          _previous
          array:1 [ "url" => "https://smb-demos.com/shop/peda-ting-ting/products" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /shop/peda-ting-ting/products
          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:20 [ "x-https" => array:1 [ 0 => "1" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-real-ip" => array:1 [ 0 => "3.143.244.80" ] "x-forwarded-server" => array:1 [ 0 => "smb-demos.com" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-host" => array:1 [ 0 => "smb-demos.com" ] "x-forwarded-for" => array:1 [ 0 => "3.143.244.80" ] "host" => array:1 [ 0 => "smb-demos.com" ] ]
          request_server
          0 of 0
          array:65 [ "USER" => "demoadmin" "HOME" => "/home/demoadmin" "SCRIPT_NAME" => "/zcart/public/index.php" "REQUEST_URI" => "/shop/peda-ting-ting/products" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/zcart/public/shop/peda-ting-ting/products" "REMOTE_PORT" => "46656" "SCRIPT_FILENAME" => "/home/demoadmin/public_html/zcart/public/index.php" "SERVER_ADMIN" => "webmaster@smb-demos.com" "CONTEXT_DOCUMENT_ROOT" => "/home/demoadmin/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/demoadmin/public_html" "REMOTE_ADDR" => "3.143.244.80" "SERVER_PORT" => "443" "SERVER_ADDR" => "50.62.182.215" "SERVER_NAME" => "smb-demos.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi" "HTTP_X_HTTPS" => "1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "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" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_X_REAL_IP" => "3.143.244.80" "HTTP_X_FORWARDED_SERVER" => "smb-demos.com" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_HOST" => "smb-demos.com" "HTTP_X_FORWARDED_FOR" => "3.143.244.80" "HTTP_HOST" => "smb-demos.com" "proxy-nokeepalive" => "1" "HTTPS" => "on" "SCRIPT_URI" => "https://smb-demos.com/shop/peda-ting-ting/products" "SCRIPT_URL" => "/shop/peda-ting-ting/products" "UNIQUE_ID" => "Z_4Pt9U6WrHHcnNKNjmWWAAAAAM" "REDIRECT_STATUS" => "200" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://smb-demos.com/shop/peda-ting-ting/products" "REDIRECT_SCRIPT_URL" => "/shop/peda-ting-ting/products" "REDIRECT_UNIQUE_ID" => "Z_4Pt9U6WrHHcnNKNjmWWAAAAAM" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_SCRIPT_URI" => "https://smb-demos.com/shop/peda-ting-ting/products" "REDIRECT_REDIRECT_SCRIPT_URL" => "/shop/peda-ting-ting/products" "REDIRECT_REDIRECT_isproxyrequest" => "1" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z_4Pt9U6WrHHcnNKNjmWWAAAAAM" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/zcart/public/index.php" "REQUEST_TIME_FLOAT" => 1744703415.2709 "REQUEST_TIME" => 1744703415 "argv" => [] "argc" => 0 ]
          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, 15 Apr 2025 07:50:15 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5hT3lrUUtYeXlFRGx6bWp3S2FxMnc9PSIsInZhbHVlIjoiRnpueUVEUFc5SnBLUS90NHhCcnRsWUNFZ0RQcVZ6U1lMUy8yWE16K1ByekpFMEtHcGR1MElTWWVocDllRTdheEVDc1hIZHQ5QlJNWGp1L2xVczBHcWlrbndDZXZPd1lnVVhsL25aRzFhMzBuUDhLVUJBNHdUc1hLRFFzZElVek4iLCJtYWMiOiIxNjg2ODg5YTA0YzM4OTljOTYwYmE5NzEwNzU3MTMyNzgwNDJjODM3YjAzOTkxNWRlNDA3NGYwYjFlZGUzODk0IiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 09:50:15 GMT; Max-Age=7200; path=/; secure; samesite=noneXSRF-TOKEN=eyJpdiI6Ik5hT3lrUUtYeXlFRGx6bWp3S2FxMnc9PSIsInZhbHVlIjoiRnpueUVEUFc5SnBLUS90NHhCcnRsWUNFZ0RQcVZ6U1lMUy8yWE16K1ByekpFMEtHcGR1MElTWWVocDllRTdheEVDc1hIZ" 1 => "zcart_marketplace_session=eyJpdiI6IkNDaVFtSmV0WEpyRmVCSVdYREphcFE9PSIsInZhbHVlIjoid3ptT2VGMG9jd2FlaC93Zld4UTlaZ05HWUNHdDY1TzdhRmpyMHdDQUF3d0puWHhhejNYSTRXRTcyNCtNLzRjN09NUDhuQXRmejV4VmF1NXJldEN6SVpTS2UvVXRBaDFmTVkyVXFTR2VKd1JTYkhZY1lycjRBQkNzTSt0YTJVU0MiLCJtYWMiOiJiM2JmYTYwODM2ZDM1NjkxZTUzZWRjMGJjYTg1NGQyMmZkYjczMWExYTlkYjZiODM3ZjM1YWJlMjcyODVhNmYzIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 09:50:15 GMT; Max-Age=7200; path=/; secure; httponly; samesite=nonezcart_marketplace_session=eyJpdiI6IkNDaVFtSmV0WEpyRmVCSVdYREphcFE9PSIsInZhbHVlIjoid3ptT2VGMG9jd2FlaC93Zld4UTlaZ05HWUNHdDY1TzdhRmpyMHdDQUF3d0puWHhhejNYSTRXRTcyNC" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5hT3lrUUtYeXlFRGx6bWp3S2FxMnc9PSIsInZhbHVlIjoiRnpueUVEUFc5SnBLUS90NHhCcnRsWUNFZ0RQcVZ6U1lMUy8yWE16K1ByekpFMEtHcGR1MElTWWVocDllRTdheEVDc1hIZHQ5QlJNWGp1L2xVczBHcWlrbndDZXZPd1lnVVhsL25aRzFhMzBuUDhLVUJBNHdUc1hLRFFzZElVek4iLCJtYWMiOiIxNjg2ODg5YTA0YzM4OTljOTYwYmE5NzEwNzU3MTMyNzgwNDJjODM3YjAzOTkxNWRlNDA3NGYwYjFlZGUzODk0IiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 09:50:15 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ik5hT3lrUUtYeXlFRGx6bWp3S2FxMnc9PSIsInZhbHVlIjoiRnpueUVEUFc5SnBLUS90NHhCcnRsWUNFZ0RQcVZ6U1lMUy8yWE16K1ByekpFMEtHcGR1MElTWWVocDllRTdheEVDc1hIZ" 1 => "zcart_marketplace_session=eyJpdiI6IkNDaVFtSmV0WEpyRmVCSVdYREphcFE9PSIsInZhbHVlIjoid3ptT2VGMG9jd2FlaC93Zld4UTlaZ05HWUNHdDY1TzdhRmpyMHdDQUF3d0puWHhhejNYSTRXRTcyNCtNLzRjN09NUDhuQXRmejV4VmF1NXJldEN6SVpTS2UvVXRBaDFmTVkyVXFTR2VKd1JTYkhZY1lycjRBQkNzTSt0YTJVU0MiLCJtYWMiOiJiM2JmYTYwODM2ZDM1NjkxZTUzZWRjMGJjYTg1NGQyMmZkYjczMWExYTlkYjZiODM3ZjM1YWJlMjcyODVhNmYzIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 09:50:15 GMT; path=/; secure; httponlyzcart_marketplace_session=eyJpdiI6IkNDaVFtSmV0WEpyRmVCSVdYREphcFE9PSIsInZhbHVlIjoid3ptT2VGMG9jd2FlaC93Zld4UTlaZ05HWUNHdDY1TzdhRmpyMHdDQUF3d0puWHhhejNYSTRXRTcyNC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "WxraAvV7fdI0CBHWMT1v2zFyGjSnfDgTxGrXvVwD" "_previous" => array:1 [ "url" => "https://smb-demos.com/shop/peda-ting-ting/products" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]