Cơ hội kiếm ngàn $$$ cùng VIHCS
  • Cần giúp đỡ? Hãy gọi:   0945.318.916
Nước hoa
Bộ lọc
8.0.28PHP Version1.39sRequest Duration12MBMemory UsageGET danh-muc-san-pham/{slug}Route
    • Booting (538ms)
    • Application (855ms)
    • 1 x Application (61.36%)
      855ms
      1 x Booting (38.63%)
      538ms
      30 templates were rendered
      • theme.nest::views.ecommerce.product-category (platform/themes/nest/views/ecommerce/product-category.blade.php)2blade
        Params
        0
        category
        1
        products
      • theme.nest::views.ecommerce.products (platform/themes/nest/views/ecommerce/products.blade.php)6blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        filterURL
      • theme.nest::views/ecommerce/includes/filters (platform/themes/nest/views/ecommerce/includes/filters.blade.php)8blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        filterURL
        6
        layout
        7
        requestLayout
      • theme.nest::views.ecommerce.includes.product-items (platform/themes/nest/views/ecommerce/includes/product-items.blade.php)8blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        filterURL
        6
        layout
        7
        requestLayout
      • theme.nest::views/ecommerce/includes/sort (platform/themes/nest/views/ecommerce/includes/sort.blade.php)8blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        filterURL
        6
        layout
        7
        requestLayout
      • theme.nest::views.ecommerce.includes.product-item (platform/themes/nest/views/ecommerce/includes/product-item.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        filterURL
        6
        layout
        7
        requestLayout
        8
        __empty_1
        9
        __currentLoopData
        10
        product
        11
        loop
      • theme.nest::partials.custom-pagination (platform/themes/nest/partials/custom-pagination.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • theme.nest::layouts.product-left-sidebar (platform/themes/nest/layouts/product-left-sidebar.blade.php)0blade
      • theme.nest::partials.header (platform/themes/nest/partials/header.blade.php)0blade
      • packages/theme::partials.header (platform/packages/theme/resources/views/partials/header.blade.php)0blade
      • theme.nest::partials.preloader (platform/themes/nest/partials/preloader.blade.php)0blade
      • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::partials.cart-panel (platform/themes/nest/partials/cart-panel.blade.php)0blade
      • theme.nest::partials.main-menu (platform/themes/nest/partials/main-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::partials.main-menu (platform/themes/nest/partials/main-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::partials.cart-panel (platform/themes/nest/partials/cart-panel.blade.php)0blade
      • theme.nest::partials.mobile-menu (platform/themes/nest/partials/mobile-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::partials.mobile-menu (platform/themes/nest/partials/mobile-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::partials.breadcrumb (platform/themes/nest/partials/breadcrumb.blade.php)0blade
      • theme.nest::partials.footer (platform/themes/nest/partials/footer.blade.php)0blade
      • theme.nest::/../widgets/site-features/templates.frontend (platform/themes/nest/widgets/site-features/templates/frontend.blade.php)2blade
        Params
        0
        config
        1
        sidebar
      • theme.nest::/../widgets/site-info/templates.frontend (platform/themes/nest/widgets/site-info/templates/frontend.blade.php)2blade
        Params
        0
        config
        1
        sidebar
      • theme.nest::/../widgets/custom-menu/templates.frontend (platform/themes/nest/widgets/custom-menu/templates/frontend.blade.php)2blade
        Params
        0
        config
        1
        sidebar
      • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::/../widgets/custom-menu/templates.frontend (platform/themes/nest/widgets/custom-menu/templates/frontend.blade.php)2blade
        Params
        0
        config
        1
        sidebar
      • packages/menu::partials.default (platform/packages/menu/resources/views/partials/default.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.nest::/../widgets/install-app/templates.frontend (platform/themes/nest/widgets/install-app/templates/frontend.blade.php)2blade
        Params
        0
        config
        1
        sidebar
      • packages/theme::partials.footer (platform/packages/theme/resources/views/partials/footer.blade.php)0blade
      • theme.nest::partials.facebook-integration (platform/themes/nest/partials/facebook-integration.blade.php)0blade
      • plugins/cookie-consent::index (platform/plugins/cookie-consent/resources/views/index.blade.php)2blade
        Params
        0
        alreadyConsentedWithCookies
        1
        cookieConsentConfig
      uri
      GET danh-muc-san-pham/{slug}
      middleware
      web, core
      as
      public.product-category
      controller
      Botble\Ecommerce\Http\Controllers\Fronts\PublicProductController@getProductCategory
      namespace
      Botble\Ecommerce\Http\Controllers\Fronts
      prefix
      where
      file
      platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:397-497
      47 statements were executed60.57ms
      • select * from `slugs` where `key` = 'cham-soc-ca-nhan' and `reference_type` = 'Botble\Ecommerce\Models\ProductCategory' and `prefix` = 'danh-muc-san-pham' limit 1
        10.64ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262ezlife_cssk
        Metadata
        Bindings
        • 0. cham-soc-ca-nhan
        • 1. Botble\Ecommerce\Models\ProductCategory
        • 2. danh-muc-san-pham
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262
        • 18. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 19. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:407
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `ec_product_categories` where `ec_product_categories`.`id` = 99 and `ec_product_categories`.`status` = 'published' limit 1
        1.66ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262ezlife_cssk
        Metadata
        Bindings
        • 0. 99
        • 1. published
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262
        • 18. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 19. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:423
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `slugs` where `slugs`.`reference_id` in (99) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        8.19ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:262
        • 23. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 24. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:423
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 99 and `ec_product_categories`.`parent_id` is not null
        820μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 99
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 180 and `ec_product_categories`.`parent_id` is not null
        660μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 180
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 181 and `ec_product_categories`.`parent_id` is not null
        900μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 181
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 182 and `ec_product_categories`.`parent_id` is not null
        1.01ms/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 182
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 183 and `ec_product_categories`.`parent_id` is not null
        760μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 183
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 184 and `ec_product_categories`.`parent_id` is not null
        550μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 184
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 185 and `ec_product_categories`.`parent_id` is not null
        850μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 185
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 186 and `ec_product_categories`.`parent_id` is not null
        740μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 186
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 187 and `ec_product_categories`.`parent_id` is not null
        490μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 187
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 188 and `ec_product_categories`.`parent_id` is not null
        770μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 188
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 189 and `ec_product_categories`.`parent_id` is not null
        570μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 189
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 190 and `ec_product_categories`.`parent_id` is not null
        540μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 190
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 191 and `ec_product_categories`.`parent_id` is not null
        760μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 191
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 192 and `ec_product_categories`.`parent_id` is not null
        510μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 192
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 194 and `ec_product_categories`.`parent_id` is not null
        590μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 194
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `id` from `ec_product_categories` where `ec_product_categories`.`parent_id` = 230 and `ec_product_categories`.`parent_id` is not null
        670μs/platform/plugins/ecommerce/src/Models/ProductCategory.php:96ezlife_cssk
        Metadata
        Bindings
        • 0. 230
        Backtrace
        • 15. /platform/plugins/ecommerce/src/Models/ProductCategory.php:96
        • 16. /platform/plugins/ecommerce/src/Models/ProductCategory.php:101
        • 17. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:445
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `ec_currencies` order by `order` asc
        710μs/platform/plugins/ecommerce/src/Repositories/Eloquent/CurrencyRepository.php:18ezlife_cssk
        Metadata
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/CurrencyRepository.php:18
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/CurrencyCacheDecorator.php:15
        • 18. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:121
        • 19. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:52
        • 20. /platform/plugins/ecommerce/helpers/currencies.php:159
      • select count(*) as aggregate from `ec_products` inner join ( SELECT DISTINCT `ec_products`.id, CASE WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price <> 0 ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price = 0 ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ( ec_products.start_date > '2025-01-12 19:24:35' OR ec_products.end_date < '2025-01-12 19:24:35' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-01-12 19:24:35' AND ec_products.end_date >= '2025-01-12 19:24:35' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-01-12 19:24:35' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-01-12 19:24:35' AND ec_products.end_date IS NULL ) THEN ec_products.sale_price ELSE ec_products.price END AS final_price FROM `ec_products` ) AS products_with_final_price on `products_with_final_price`.`id` = `ec_products`.`id` where exists (select * from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_products`.`id` = `ec_product_category_product`.`product_id` and `ec_product_category_product`.`category_id` in (99, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 194, 230)) and `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0
        3.46ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Bindings
        • 0. 99
        • 1. 180
        • 2. 181
        • 3. 182
        • 4. 183
        • 5. 184
        • 6. 185
        • 7. 186
        • 8. 187
        • 9. 188
        • 10. 189
        • 11. 190
        • 12. 191
        • 13. 192
        • 14. 194
        • 15. 230
        • 16. published
        • 17. 0
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 19. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 20. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 21. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select distinct `ec_products`.*, `products_with_final_price`.`final_price`, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(star) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg` from `ec_products` inner join ( SELECT DISTINCT `ec_products`.id, CASE WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price <> 0 ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price = 0 ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ( ec_products.start_date > '2025-01-12 19:24:35' OR ec_products.end_date < '2025-01-12 19:24:35' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-01-12 19:24:35' AND ec_products.end_date >= '2025-01-12 19:24:35' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-01-12 19:24:35' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-01-12 19:24:35' AND ec_products.end_date IS NULL ) THEN ec_products.sale_price ELSE ec_products.price END AS final_price FROM `ec_products` ) AS products_with_final_price on `products_with_final_price`.`id` = `ec_products`.`id` where exists (select * from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_products`.`id` = `ec_product_category_product`.`product_id` and `ec_product_category_product`.`category_id` in (99, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 194, 230)) and `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 60 offset 0
        6.52ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Bindings
        • 0. published
        • 1. published
        • 2. 99
        • 3. 180
        • 4. 181
        • 5. 182
        • 6. 183
        • 7. 184
        • 8. 185
        • 9. 186
        • 10. 187
        • 11. 188
        • 12. 189
        • 13. 190
        • 14. 191
        • 15. 192
        • 16. 194
        • 17. 230
        • 18. published
        • 19. 0
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 19. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 20. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 21. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select * from `slugs` where `slugs`.`reference_id` in (11556) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'
        540μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\Product
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (11556)
        410μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` in (11556)
        610μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 20. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 23. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 24. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 25. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select `ec_product_attributes`.*, `ec_product_variations`.*, `ec_product_variation_items`.*, `ec_product_attribute_sets`.*, `ec_product_attributes`.`title` as `attribute_title` from `ec_product_variations` inner join `ec_product_variation_items` on `ec_product_variation_items`.`variation_id` = `ec_product_variations`.`id` inner join `ec_product_attributes` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` inner join `ec_product_attribute_sets` on `ec_product_attribute_sets`.`id` = `ec_product_attributes`.`attribute_set_id` where `ec_product_attribute_sets`.`status` = 'published' and `ec_product_attribute_sets`.`is_use_in_product_listing` = 1 and `ec_product_variations`.`configurable_product_id` in (11556)
        2.86ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Bindings
        • 0. published
        • 1. 1
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` in (11556)
        550μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 20. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 23. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 24. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 25. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select * from `mp_stores` where `mp_stores`.`id` in (0)
        620μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434ezlife_cssk
        Metadata
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:434
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:669
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:89
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:161
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:447
      • select * from `ec_product_categories` where `ec_product_categories`.`id` = 0 limit 1
        640μs/platform/core/base/src/Models/BaseModel.php:26ezlife_cssk
        Metadata
        Bindings
        • 0. 0
        Backtrace
        • 20. /platform/core/base/src/Models/BaseModel.php:26
        • 21. /platform/plugins/ecommerce/src/Models/ProductCategory.php:73
        • 27. /platform/core/base/src/Models/BaseModel.php:26
        • 28. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:465
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
      • select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (99) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        700μs/platform/packages/seo-helper/src/Providers/HookServiceProvider.php:79ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 22. /platform/packages/seo-helper/src/Providers/HookServiceProvider.php:79
        • 26. /platform/core/base/helpers/action-filter.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` in (11556)
        670μs/vendor/laravel/framework/src/Illuminate/Pagination/AbstractPaginator.php:770ezlife_cssk
        Metadata
        Backtrace
        • 21. /vendor/laravel/framework/src/Illuminate/Pagination/AbstractPaginator.php:770
        • 22. view::f3edcdefa665ac319ba7c3f5425c9045d920f5f4:16
        • 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
      • select * from `slugs` where `slugs`.`reference_id` in (99, 184) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        550μs/vendor/laravel/framework/src/Illuminate/Pagination/AbstractPaginator.php:770ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 23. /vendor/laravel/framework/src/Illuminate/Pagination/AbstractPaginator.php:770
        • 24. view::f3edcdefa665ac319ba7c3f5425c9045d920f5f4:16
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `ec_product_categories` order by `order` asc, `created_at` desc
        500μs/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:134ezlife_cssk
        Metadata
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:134
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 18. /platform/plugins/ecommerce/src/Supports/ProductCategoryHelper.php:26
        • 19. /platform/plugins/ecommerce/src/Supports/ProductCategoryHelper.php:85
        • 21. view::998fee29c3fe5ff38e9642d3d3306d861bbfa3b6:11
      • select *, (select count(*) from `ec_products` where `ec_brands`.`id` = `ec_products`.`brand_id` and `is_variation` = 0 and `status` = 'published') as `products_count` from `ec_brands` where `status` = 'published' order by `order` asc, `created_at` desc
        1.17ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:437ezlife_cssk
        Metadata
        Bindings
        • 0. 0
        • 1. published
        • 2. published
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:437
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 18. /platform/plugins/ecommerce/helpers/brands.php:48
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select *, (select count(*) from `ec_products` inner join `ec_product_tag_product` on `ec_products`.`id` = `ec_product_tag_product`.`product_id` where `ec_product_tags`.`id` = `ec_product_tag_product`.`tag_id` and `is_variation` = 0) as `products_count` from `ec_product_tags` where `status` = 'published' order by `products_count` desc limit 20
        1.02ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:421ezlife_cssk
        Metadata
        Bindings
        • 0. 0
        • 1. published
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:421
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 18. view::998fee29c3fe5ff38e9642d3d3306d861bbfa3b6:65
        • 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2025-01-12 19:24:35' and (`end_date` is null or `end_date` >= '2025-01-12 19:24:35') and (`target` in ('all-orders', 'amount-minimum-order') or (`target` in ('customer', 'group-products', 'specific-product', 'product-variant') and `product_quantity` = 1))
        880μs/platform/plugins/ecommerce/src/Repositories/Eloquent/DiscountRepository.php:54ezlife_cssk
        Metadata
        Bindings
        • 0. promotion
        • 1. 2025-01-12 19:24:35
        • 2. 2025-01-12 19:24:35
        • 3. all-orders
        • 4. amount-minimum-order
        • 5. customer
        • 6. group-products
        • 7. specific-product
        • 8. product-variant
        • 9. 1
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/DiscountRepository.php:54
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/DiscountCacheDecorator.php:15
        • 18. /platform/plugins/ecommerce/src/Supports/DiscountSupport.php:68
        • 19. /platform/plugins/ecommerce/src/Supports/DiscountSupport.php:22
        • 20. /platform/plugins/ecommerce/src/Models/Product.php:453
      • select * from `ec_flash_sales` where `status` = 'published' and date(`end_date`) > '2025-01-12' order by `created_at` desc
        560μs/platform/plugins/ecommerce/src/Repositories/Eloquent/FlashSaleRepository.php:25ezlife_cssk
        Metadata
        Bindings
        • 0. published
        • 1. 2025-01-12
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/FlashSaleRepository.php:25
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/FlashSaleCacheDecorator.php:15
        • 18. /platform/plugins/ecommerce/src/Supports/FlashSaleSupport.php:56
        • 19. /platform/plugins/ecommerce/src/Supports/FlashSaleSupport.php:23
        • 20. /platform/plugins/ecommerce/src/Models/Product.php:432
      • select * from `ec_taxes` where `ec_taxes`.`id` = 1 limit 1
        570μs/platform/core/base/src/Models/BaseModel.php:26ezlife_cssk
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 20. /platform/core/base/src/Models/BaseModel.php:26
        • 21. /platform/plugins/ecommerce/src/Models/Product.php:655
        • 27. /platform/core/base/src/Models/BaseModel.php:26
        • 28. view::a360c7e3b379e41cb0c8d8afa24205d0f97ed9e9:66
        • 30. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • select * from `menus` where `status` = 'published'
        540μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159ezlife_cssk
        Metadata
        Bindings
        • 0. published
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:192
        • 18. /platform/packages/menu/src/Menu.php:267
        • 19. /platform/packages/menu/src/Menu.php:257
        • 20. /platform/packages/menu/src/Menu.php:215
      • select * from `menu_nodes` where `menu_nodes`.`menu_id` in (6, 7, 8, 9, 10)
        680μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159ezlife_cssk
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159
        • 22. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:192
        • 23. /platform/packages/menu/src/Menu.php:267
        • 24. /platform/packages/menu/src/Menu.php:257
        • 25. /platform/packages/menu/src/Menu.php:215
      • select * from `menu_locations` where `menu_locations`.`menu_id` in (6, 7, 8, 9, 10)
        360μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159ezlife_cssk
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159
        • 22. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:192
        • 23. /platform/packages/menu/src/Menu.php:267
        • 24. /platform/packages/menu/src/Menu.php:257
        • 25. /platform/packages/menu/src/Menu.php:215
      • select * from `slugs` where `slugs`.`reference_id` in (63, 99, 100, 238) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        590μsview::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 21. view::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173
        • 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 `ec_product_categories` where `ec_product_categories`.`parent_id` in (63, 99, 100, 238)
        550μsview::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173ezlife_cssk
        Metadata
        Backtrace
        • 21. view::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173
        • 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 `slugs` where `slugs`.`reference_id` in (180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 194, 195, 196, 197, 198, 199, 200, 201, 202, 220, 230, 233, 234, 235, 239, 240, 241) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        720μsview::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 22. view::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173
        • 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 `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (63, 99, 100, 238) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        600μsview::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173ezlife_cssk
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 21. view::7dc456776fce2dac44bb40011b815ed5f0fd5e3d:173
        • 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 `menu_nodes` where `menu_nodes`.`parent_id` = 118 and `menu_nodes`.`parent_id` is not null order by `position` asc
        470μs/platform/core/base/src/Models/BaseModel.php:26ezlife_cssk
        Metadata
        Bindings
        • 0. 118
        Backtrace
        • 19. /platform/core/base/src/Models/BaseModel.php:26
        • 20. view::16af2773a86b7a4f93ca6321444cbeca6bba39f1:16
        • 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
      • select * from `widgets` where `theme` = 'nest'
        840μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159ezlife_cssk
        Metadata
        Bindings
        • 0. nest
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:192
        • 18. /platform/packages/widget/src/WidgetGroupCollection.php:146
        • 19. /platform/packages/widget/src/WidgetGroupCollection.php:130
        • 20. /platform/packages/widget/src/WidgetGroupCollection.php:111
      Botble\Widget\Models\Widget
      9
      Botble\Menu\Models\MenuLocation
      2
      Botble\Menu\Models\MenuNode
      26
      Botble\Menu\Models\Menu
      5
      Botble\Ecommerce\Models\Tax
      1
      Botble\Ecommerce\Models\ProductTag
      7
      Botble\Ecommerce\Models\Brand
      5
      Botble\Base\Models\MetaBox
      15
      Botble\Ecommerce\Models\Product
      1
      Botble\Ecommerce\Models\Currency
      1
      Botble\Ecommerce\Models\ProductCategory
      83
      Botble\Slug\Models\Slug
      38
          _token
          BKpaFdoMWYl1vKrF0xobJI6XpNeu9lkdQJ0UcbVE
          _previous
          array:1 [ "url" => "https://vienkhoahocchamsocsuckhoevietnam.com/danh-muc-san-pham/cham-soc-ca-nha...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /danh-muc-san-pham/cham-soc-ca-nhan
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "categories" => array:16 [ 0 => 99 1 => 180 4 => 181 8 => 182 13 => 183 19 => 184 26 => 185 34 => 186 43 => 187 53 => 188 64 => 189 76 => 190 89 => 191 103 => 192 118 => 194 134 => 230 ] ]
          request_request
          0 of 0
          array:1 [ "categories" => array:16 [ 0 => 99 1 => 180 4 => 181 8 => 182 13 => 183 19 => 184 26 => 185 34 => 186 43 => 187 53 => 188 64 => 189 76 => 190 89 => 191 103 => 192 118 => 194 134 => 230 ] ]
          request_headers
          0 of 0
          array:15 [ "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [ 0 => "vienkhoahocchamsocsuckhoevietnam.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
          request_server
          0 of 0
          array:44 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/bin:/usr/bin" "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_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "vienkhoahocchamsocsuckhoevietnam.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/ezlife/domains/vienkhoahocchamsocsuckhoevietnam.com/private_html" "REMOTE_ADDR" => "3.136.18.14" "REMOTE_PORT" => "40379" "SERVER_ADDR" => "103.74.117.184" "SERVER_NAME" => "vienkhoahocchamsocsuckhoevietnam.com" "SERVER_ADMIN" => "webmaster@vienkhoahocchamsocsuckhoevietnam.com" "SERVER_PORT" => "443" "REQUEST_URI" => "/danh-muc-san-pham/cham-soc-ca-nhan" "REDIRECT_URL" => "/public/danh-muc-san-pham/cham-soc-ca-nhan" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_CHACHA20_POLY1305_SHA256" "SSL_CIPHER_USEKEYSIZE" => "256" "SSL_CIPHER_ALGKEYSIZE" => "256" "LSWS_EDITION" => "Openlitespeed 1.7.16" "X-LSCACHE" => "on,crawler" "SCRIPT_FILENAME" => "/home/ezlife/domains/vienkhoahocchamsocsuckhoevietnam.com/private_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1736684674.4494 "REQUEST_TIME" => 1736684674 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:8 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 12 Jan 2025 12:24:35 GMT" ] "cms-version" => array:1 [ 0 => "5.26.2" ] "authorization-at" => array:1 [ 0 => "2024-07-03 08:55:12" ] "activated-license" => array:1 [ 0 => "Yes" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhmNnNoY1ZuYmt6OEw5UUdqUHp3UEE9PSIsInZhbHVlIjoid1B5dW4zNEtGbjlpb2dER09nRE9TVEFZMnVVWk9aamQvbE41eXVuUHVVUmI0NjZaWENaUVBxWmFUcXVEdmlSZ1RRRXE4MlJlekxCUHZuNVg3VHhGMlBGQzFQL292U1M2c2xTWVN0Mm1WWmhtUG93Y0t4c3p2elh2bzBKWmMxOEUiLCJtYWMiOiIzMjdkYWYzZjNmZTA2M2E4M2Y3YTY2ZjM5OGVkYmRlZDNiYTE2OTEwMWU4OWY4YTRjMDI1Yzc1MjYyOGMwOGMyIiwidGFnIjoiIn0%3D; expires=Sun, 12-Jan-2025 14:24:35 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlhmNnNoY1ZuYmt6OEw5UUdqUHp3UEE9PSIsInZhbHVlIjoid1B5dW4zNEtGbjlpb2dER09nRE9TVEFZMnVVWk9aamQvbE41eXVuUHVVUmI0NjZaWENaUVBxWmFUcXVEdmlSZ1RRRXE4M" 1 => "botble_session=eyJpdiI6IktUTTJ5M1RqMmVXRkFNUU4vOW9qREE9PSIsInZhbHVlIjoiV0d3eDYwdDNJNVEzL2RaQm9sOXNmQ2tRcGE4YnZyYnRjY25tdEFCdllFVGtidnBJY2U0M3ljSk5SODNyYWpDbXRYeUVLZktrVjRaSlZBdkdWWlN4d3ZpbHU2M2drODRUemZVcFlJNnFoZTJGdno4eEhtN1RyTVMwWjBqTGEySWwiLCJtYWMiOiJkYWZjYWZmOTBhYWMzMDlmMmRjN2U3Y2I1YmRlODFkZjE4ZWM0Y2FlYWE4MGNiNzY1NDZhNzdhMDQzMzIxMzNjIiwidGFnIjoiIn0%3D; expires=Sun, 12-Jan-2025 14:24:35 GMT; Max-Age=7200; path=/; httponly; samesite=laxbotble_session=eyJpdiI6IktUTTJ5M1RqMmVXRkFNUU4vOW9qREE9PSIsInZhbHVlIjoiV0d3eDYwdDNJNVEzL2RaQm9sOXNmQ2tRcGE4YnZyYnRjY25tdEFCdllFVGtidnBJY2U0M3ljSk5SODNyYWpDbXRYe" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhmNnNoY1ZuYmt6OEw5UUdqUHp3UEE9PSIsInZhbHVlIjoid1B5dW4zNEtGbjlpb2dER09nRE9TVEFZMnVVWk9aamQvbE41eXVuUHVVUmI0NjZaWENaUVBxWmFUcXVEdmlSZ1RRRXE4MlJlekxCUHZuNVg3VHhGMlBGQzFQL292U1M2c2xTWVN0Mm1WWmhtUG93Y0t4c3p2elh2bzBKWmMxOEUiLCJtYWMiOiIzMjdkYWYzZjNmZTA2M2E4M2Y3YTY2ZjM5OGVkYmRlZDNiYTE2OTEwMWU4OWY4YTRjMDI1Yzc1MjYyOGMwOGMyIiwidGFnIjoiIn0%3D; expires=Sun, 12-Jan-2025 14:24:35 GMT; path=/XSRF-TOKEN=eyJpdiI6IlhmNnNoY1ZuYmt6OEw5UUdqUHp3UEE9PSIsInZhbHVlIjoid1B5dW4zNEtGbjlpb2dER09nRE9TVEFZMnVVWk9aamQvbE41eXVuUHVVUmI0NjZaWENaUVBxWmFUcXVEdmlSZ1RRRXE4M" 1 => "botble_session=eyJpdiI6IktUTTJ5M1RqMmVXRkFNUU4vOW9qREE9PSIsInZhbHVlIjoiV0d3eDYwdDNJNVEzL2RaQm9sOXNmQ2tRcGE4YnZyYnRjY25tdEFCdllFVGtidnBJY2U0M3ljSk5SODNyYWpDbXRYeUVLZktrVjRaSlZBdkdWWlN4d3ZpbHU2M2drODRUemZVcFlJNnFoZTJGdno4eEhtN1RyTVMwWjBqTGEySWwiLCJtYWMiOiJkYWZjYWZmOTBhYWMzMDlmMmRjN2U3Y2I1YmRlODFkZjE4ZWM0Y2FlYWE4MGNiNzY1NDZhNzdhMDQzMzIxMzNjIiwidGFnIjoiIn0%3D; expires=Sun, 12-Jan-2025 14:24:35 GMT; path=/; httponlybotble_session=eyJpdiI6IktUTTJ5M1RqMmVXRkFNUU4vOW9qREE9PSIsInZhbHVlIjoiV0d3eDYwdDNJNVEzL2RaQm9sOXNmQ2tRcGE4YnZyYnRjY25tdEFCdllFVGtidnBJY2U0M3ljSk5SODNyYWpDbXRYe" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "BKpaFdoMWYl1vKrF0xobJI6XpNeu9lkdQJ0UcbVE" "_previous" => array:1 [ "url" => "https://vienkhoahocchamsocsuckhoevietnam.com/danh-muc-san-pham/cham-soc-ca-nhan" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]