• 0932343383
7.4.33PHP Version433msRequest Duration10MBMemory UsageGET product-categories/{slug}Route
    • Booting (192ms)
    • Application (241ms)
    • 1 x Application (55.55%)
      240.74ms
      1 x Booting (44.3%)
      192.00ms
      26 templates were rendered
      • theme.shopwise::views.ecommerce.product-category (platform/themes/shopwise/views/ecommerce/product-category.blade.php)2blade
        Params
        0
        category
        1
        products
      • theme.shopwise::views/ecommerce/includes/sort (platform/themes/shopwise/views/ecommerce/includes/sort.blade.php)5blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
      • theme.shopwise::partials.product-item-grid (platform/themes/shopwise/partials/product-item-grid.blade.php)1blade
        Params
        0
        product
      • pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • theme.shopwise::views/ecommerce/includes/filters (platform/themes/shopwise/views/ecommerce/includes/filters.blade.php)8blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        products
        5
        __currentLoopData
        6
        product
        7
        loop
      • theme.shopwise::views.ecommerce.attributes.attributes-filter-renderer (platform/themes/shopwise/views/ecommerce/attributes/attributes-filter-renderer.blade.php)1blade
        Params
        0
        attributeSets
      • theme.shopwise::views.ecommerce.attributes._layouts-filter.visual (platform/themes/shopwise/views/ecommerce/attributes/_layouts-filter/visual.blade.php)10blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        attributeSets
        4
        __currentLoopData
        5
        attributeSet
        6
        loop
        7
        set
        8
        attributes
        9
        selected
      • theme.shopwise::views.ecommerce.attributes._layouts-filter.text (platform/themes/shopwise/views/ecommerce/attributes/_layouts-filter/text.blade.php)10blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        attributeSets
        4
        __currentLoopData
        5
        attributeSet
        6
        loop
        7
        set
        8
        attributes
        9
        selected
      • theme.shopwise::layouts.default (platform/themes/shopwise/layouts/default.blade.php)0blade
      • theme.shopwise::partials.header (platform/themes/shopwise/partials/header.blade.php)0blade
      • packages/theme::partials.header (platform/packages/theme/resources/views/partials/header.blade.php)0blade
      • theme.shopwise::partials.menu (platform/themes/shopwise/partials/menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.shopwise::partials.sub-menu (platform/themes/shopwise/partials/sub-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.shopwise::partials.sub-menu (platform/themes/shopwise/partials/sub-menu.blade.php)3blade
        Params
        0
        menu
        1
        menu_nodes
        2
        options
      • theme.shopwise::partials.cart (platform/themes/shopwise/partials/cart.blade.php)0blade
      • theme.shopwise::partials.breadcrumbs (platform/themes/shopwise/partials/breadcrumbs.blade.php)0blade
      • theme.shopwise::partials.footer (platform/themes/shopwise/partials/footer.blade.php)0blade
      • theme.shopwise::/../widgets/custom-menu/templates.frontend (platform/themes/shopwise/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.shopwise::/../widgets/custom-menu/templates.frontend (platform/themes/shopwise/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.shopwise::/../widgets/custom-menu/templates.frontend (platform/themes/shopwise/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
      • packages/theme::partials.footer (platform/packages/theme/resources/views/partials/footer.blade.php)0blade
      • theme.shopwise::partials.facebook-integration (platform/themes/shopwise/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 product-categories/{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:429-527
      32 statements were executed, 2 of which were duplicated, 30 unique82.63ms
      • select * from `slugs` where `key` = 'chai-nhua-bong-den' and `reference_type` = 'Botble\Ecommerce\Models\ProductCategory' and `prefix` = 'product-categories' limit 1
        2.91ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260chainhuacaocap
        Metadata
        Bindings
        • 0. chai-nhua-bong-den
        • 1. Botble\Ecommerce\Models\ProductCategory
        • 2. product-categories
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260
        • 18. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 19. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:439
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:254
      • select * from `ec_product_categories` where `ec_product_categories`.`id` = 46 and `ec_product_categories`.`status` = 'published' limit 1
        1.3ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260chainhuacaocap
        Metadata
        Bindings
        • 0. 46
        • 1. published
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260
        • 18. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 19. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:455
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:254
      • select * from `slugs` where `slugs`.`reference_id` in (46) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        1.74ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260
        • 23. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 24. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:455
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:254
      • 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-04-02 11:49:41' OR ec_products.end_date < '2025-04-02 11:49:41' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-02 11:49:41' AND ec_products.end_date >= '2025-04-02 11:49:41' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-04-02 11:49:41' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-02 11:49:41' 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` left join `ec_product_category_product` on `ec_product_category_product`.`product_id` = `ec_products`.`id` where (`ec_product_category_product`.`category_id` in (46)) and `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0
        4.64ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. 46
        • 1. published
        • 2. 0
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 19. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 20. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 21. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select distinct `ec_products`.*, `products_with_final_price`.`final_price` 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-04-02 11:49:41' OR ec_products.end_date < '2025-04-02 11:49:41' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-02 11:49:41' AND ec_products.end_date >= '2025-04-02 11:49:41' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-04-02 11:49:41' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-04-02 11:49:41' 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` left join `ec_product_category_product` on `ec_product_category_product`.`product_id` = `ec_products`.`id` where (`ec_product_category_product`.`category_id` in (46)) and `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0 order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 12 offset 0
        2.69ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. 46
        • 1. published
        • 2. 0
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 16. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 19. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 20. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 21. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select * from `slugs` where `slugs`.`reference_id` in (149) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'
        3.57ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\Product
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` in (149)
        810μs/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • 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 (149)
        1.21ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 20. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 23. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 24. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 25. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • 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 (149)
        2.66ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. published
        • 1. 1
        Backtrace
        • 20. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 21. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 24. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 25. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 26. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select `ec_discounts`.*, `ec_discount_products`.`product_id` as `pivot_product_id`, `ec_discount_products`.`discount_id` as `pivot_discount_id` from `ec_discounts` inner join `ec_discount_products` on `ec_discounts`.`id` = `ec_discount_products`.`discount_id` left join `ec_discount_product_collections` on `ec_discounts`.`id` = `ec_discount_product_collections`.`discount_id` left join `ec_discount_customers` on `ec_discounts`.`id` = `ec_discount_customers`.`discount_id` where `type` = 'promotion' and `start_date` <= '2025-04-02 11:49:41' and (((`target` = 'specific-product' or `target` = 'product-variant') and `ec_discount_products`.`product_id` is null) or (`target` = 'group-products' and 0 = 1) or (`target` = 'customer' and `ec_discount_customers`.`customer_id` = -1)) and (`end_date` is null or `end_date` >= '2025-04-02 11:49:41') and `product_quantity` = 1 and `ec_discount_products`.`product_id` in (149)
        8.15ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. promotion
        • 1. 2025-04-02 11:49:41
        • 2. specific-product
        • 3. product-variant
        • 4. group-products
        • 5. customer
        • 6. -1
        • 7. 2025-04-02 11:49:41
        • 8. 1
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 20. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 23. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 24. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 25. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select `ec_flash_sales`.*, `ec_flash_sale_products`.`product_id` as `pivot_product_id`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`price` as `pivot_price`, `ec_flash_sale_products`.`quantity` as `pivot_quantity`, `ec_flash_sale_products`.`sold` as `pivot_sold` from `ec_flash_sales` inner join `ec_flash_sale_products` on `ec_flash_sales`.`id` = `ec_flash_sale_products`.`flash_sale_id` where `status` = 'published' and `end_date` >= '2025-04-02' and `ec_flash_sale_products`.`product_id` in (149) order by `created_at` desc
        1.49ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425chainhuacaocap
        Metadata
        Bindings
        • 0. published
        • 1. 2025-04-02
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:425
        • 20. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductRepository.php:873
        • 23. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCacheDecorator.php:256
        • 24. /platform/plugins/ecommerce/src/Services/Products/GetProductService.php:163
        • 25. /platform/plugins/ecommerce/src/Http/Controllers/Fronts/PublicProductController.php:488
      • select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (46) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        1.09ms/platform/packages/seo-helper/src/Providers/HookServiceProvider.php:79chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 22. /platform/packages/seo-helper/src/Providers/HookServiceProvider.php:79
        • 25. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 26. /platform/core/base/helpers/action-filter.php:56
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:48
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:254
      • select * from `ec_currencies` where `is_default` = 1 limit 1
        3.77ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260chainhuacaocap
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 15. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:260
        • 18. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:168
        • 19. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:82
        • 20. /platform/plugins/ecommerce/src/Supports/CurrencySupport.php:57
        • 21. /platform/plugins/ecommerce/helpers/currencies.php:147
      • select *, (select count(*) from `ec_products` where `ec_brands`.`id` = `ec_products`.`brand_id` and `is_variation` = 0) as `products_count` from `ec_brands` where `status` = 'published' order by `order` asc, `created_at` desc
        1.85ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428chainhuacaocap
        Metadata
        Bindings
        • 0. 0
        • 1. published
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428
        • 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 `ec_product_categories`.*, (select count(*) from `ec_products` inner join `ec_product_category_product` on `ec_products`.`id` = `ec_product_category_product`.`product_id` where `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` and `is_variation` = 0) as `products_count` from `ec_product_categories` where (`status` = 'published') and (`parent_id` is null or `parent_id` = 0 or `parent_id` = '') order by `order` asc, `created_at` desc
        3.37ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. 0
        • 1. published
        • 2. 0
        • 3. 
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 18. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 37, 68) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        1.74ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 19. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 22. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 23. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 27. /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 10
        2.49ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:414chainhuacaocap
        Metadata
        Bindings
        • 0. 0
        • 1. published
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:414
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 18. view::theme.shopwise::views/ecommerce/includes/filters:9
        • 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductTag'
        6.18ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:414chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductTag
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:414
        • 22. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 23. view::theme.shopwise::views/ecommerce/includes/filters:9
        • 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `ec_product_attribute_sets` where `status` = 'published' and `is_searchable` = 1 order by `order` asc
        1.23ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428chainhuacaocap
        Metadata
        Bindings
        • 0. published
        • 1. 1
        Backtrace
        • 14. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428
        • 17. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 18. /platform/plugins/ecommerce/src/Supports/RenderProductAttributeSetsOnSearchPageSupport.php:50
        • 19. /platform/plugins/ecommerce/helpers/product-variations.php:49
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • select * from `ec_product_attributes` where `ec_product_attributes`.`attribute_set_id` in (1, 2) order by `order` asc
        4.42ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428chainhuacaocap
        Metadata
        Backtrace
        • 19. /platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:428
        • 22. /platform/core/support/src/Repositories/Caches/CacheAbstractDecorator.php:272
        • 23. /platform/plugins/ecommerce/src/Supports/RenderProductAttributeSetsOnSearchPageSupport.php:50
        • 24. /platform/plugins/ecommerce/helpers/product-variations.php:49
        • 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • select * from `ec_product_categories` where (`status` = 'published') and (`parent_id` is null or `parent_id` = 0 or `parent_id` = '') order by `order` asc, `created_at` desc
        3.96ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. published
        • 1. 0
        • 2. 
        Backtrace
        • 14. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 17. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 18. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `slugs` where `slugs`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 37, 68) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        2.04ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 19. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 22. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 23. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `ec_product_categories` where `ec_product_categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 37, 68)
        1.1ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Backtrace
        • 19. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 22. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 23. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `slugs` where `slugs`.`reference_id` in (26, 31, 32, 33, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 67) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        1.05ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 24. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 27. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 28. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 31. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 32. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `meta_boxes` where `meta_key` = 'icon' and `meta_boxes`.`reference_id` in (1, 2, 3, 4, 5, 6, 7, 8, 37, 68) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
        1.08ms/platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133chainhuacaocap
        Metadata
        Bindings
        • 0. icon
        • 1. Botble\Ecommerce\Models\ProductCategory
        Backtrace
        • 19. /platform/plugins/ecommerce/src/Repositories/Eloquent/ProductCategoryRepository.php:133
        • 22. /platform/plugins/ecommerce/src/Repositories/Caches/ProductCategoryCacheDecorator.php:51
        • 23. /platform/plugins/ecommerce/helpers/product-categories.php:21
        • 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `ec_currencies` order by `order` asc
        1.01ms/platform/plugins/ecommerce/src/Repositories/Eloquent/CurrencyRepository.php:18chainhuacaocap
        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:116
        • 19. /platform/plugins/ecommerce/helpers/currencies.php:137
        • 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • select * from `menus` where `status` = 'published'
        1.3ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159chainhuacaocap
        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:249
        • 19. /platform/packages/menu/src/Menu.php:239
        • 20. /platform/packages/menu/src/Menu.php:215
      • select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3, 4)
        5.44ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159chainhuacaocap
        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:249
        • 24. /platform/packages/menu/src/Menu.php:239
        • 25. /platform/packages/menu/src/Menu.php:215
      • select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3, 4)
        1.84ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159chainhuacaocap
        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:249
        • 24. /platform/packages/menu/src/Menu.php:239
        • 25. /platform/packages/menu/src/Menu.php:215
      • select * from `menu_nodes` where `menu_nodes`.`parent_id` = 3 and `menu_nodes`.`parent_id` is not null order by `position` asc
        3.93ms/platform/core/base/src/Models/BaseModel.php:26chainhuacaocap
        Metadata
        Bindings
        • 0. 3
        Backtrace
        • 19. /platform/core/base/src/Models/BaseModel.php:26
        • 20. view::theme.shopwise::partials.menu:12
        • 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 `menu_nodes` where `menu_nodes`.`parent_id` = 8 and `menu_nodes`.`parent_id` is not null order by `position` asc
        1.45ms/platform/core/base/src/Models/BaseModel.php:26chainhuacaocap
        Metadata
        Bindings
        • 0. 8
        Backtrace
        • 19. /platform/core/base/src/Models/BaseModel.php:26
        • 20. view::theme.shopwise::partials.menu:12
        • 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` = 'shopwise'
        1.12ms/platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:159chainhuacaocap
        Metadata
        Bindings
        • 0. shopwise
        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
      3
      Botble\Menu\Models\MenuLocation
      1
      Botble\Menu\Models\MenuNode
      33
      Botble\Menu\Models\Menu
      4
      Botble\Ecommerce\Models\ProductAttribute
      13
      Botble\Ecommerce\Models\ProductAttributeSet
      2
      Botble\Ecommerce\Models\ProductTag
      6
      Botble\Ecommerce\Models\Currency
      2
      Botble\Base\Models\MetaBox
      11
      Botble\Ecommerce\Models\Product
      1
      Botble\Ecommerce\Models\ProductCategory
      53
      Botble\Slug\Models\Slug
      61
          _token
          ZORq5Ws8PHljLAi7a0s5kVdZQP6fLAFuV6CJz6Ax
          _previous
          array:1 [ "url" => "https://chainhuacaocap.com/product-categories/chai-nhua-bong-den" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /product-categories/chai-nhua-bong-den
          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:17 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "chainhuacaocap.com" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_server
          0 of 0
          array:43 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "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_CONNECTION" => "keep-alive" "HTTP_HOST" => "chainhuacaocap.com" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "chainhuacaocap.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "45.117.169.148" "REMOTE_USER" => "" "REMOTE_PORT" => "58174" "REMOTE_ADDR" => "3.141.104.233" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/chainhuacaocap/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/product-categories/chai-nhua-bong-den" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "SCRIPT_FILENAME" => "/var/www/chainhuacaocap/public/index.php" "PATH_INFO" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743569380.7962 "REQUEST_TIME" => 1743569380 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:8 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 02 Apr 2025 04:49:41 GMT" ] "cms-version" => array:1 [ 0 => "5.19.1" ] "authorization-at" => array:1 [ 0 => "2023-10-06 15:17:32" ] "activated-license" => array:1 [ 0 => "No" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJteWVTeW1XeGpFOW5heCtodlNJMUE9PSIsInZhbHVlIjoiWDEwcjZiNDFOWGFOL1RFVzAzMStjSWIvVFV1UVEzL21sTnpiYXdETzQzZlpRYjEzK2lHSWQxV3drOWozMjBiaWtGcUdic2NTMjRmdyttNGNJVW1CREk0VVJVUll4MzZMZ1VodHRDRE1ETFk1czB4dFNyQVYyZGlXS3JzS09iZWEiLCJtYWMiOiJhMTBjODg4ZWVhNjBlYzQyNTAzZTUwNjA3YzgxNWFkMzliOWZjODE3OTYxZmRlNTUwMTQ0ZDZkMzU4OGQzY2E1In0%3D; expires=Wed, 02-Apr-2025 06:49:41 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlJteWVTeW1XeGpFOW5heCtodlNJMUE9PSIsInZhbHVlIjoiWDEwcjZiNDFOWGFOL1RFVzAzMStjSWIvVFV1UVEzL21sTnpiYXdETzQzZlpRYjEzK2lHSWQxV3drOWozMjBiaWtGcUdic" 1 => "botble_session=eyJpdiI6Imw1K2Y3dVNOaWp6YzRzTjVJV2gyd2c9PSIsInZhbHVlIjoiVU5HemI2Wm1YYXZwZE1hRkNyRGdoZlExeVlQNXN5QlFrYXVXWGR5dnFEbXJVN2NZYmJ2dnR4enJxc2puRFJyQ3dFY2tnVkxkVFlld3ZlVDdaUTVtck00KzBZQ2I5NU9rQm1tQWRmWHZrcnF2bDB5MGpubVpIelN6TlQ1QkdXV3oiLCJtYWMiOiIwMjFkMjdkNWYwYjMxMGM2MDVmZDZjYWVhZjEwZjVjNzVjZTgzNmJmNjc0ZTQyNGM4NGVmMDRmZDhlOTUxMGE5In0%3D; expires=Wed, 02-Apr-2025 06:49:41 GMT; Max-Age=7200; path=/; httponly; samesite=laxbotble_session=eyJpdiI6Imw1K2Y3dVNOaWp6YzRzTjVJV2gyd2c9PSIsInZhbHVlIjoiVU5HemI2Wm1YYXZwZE1hRkNyRGdoZlExeVlQNXN5QlFrYXVXWGR5dnFEbXJVN2NZYmJ2dnR4enJxc2puRFJyQ3dFY" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJteWVTeW1XeGpFOW5heCtodlNJMUE9PSIsInZhbHVlIjoiWDEwcjZiNDFOWGFOL1RFVzAzMStjSWIvVFV1UVEzL21sTnpiYXdETzQzZlpRYjEzK2lHSWQxV3drOWozMjBiaWtGcUdic2NTMjRmdyttNGNJVW1CREk0VVJVUll4MzZMZ1VodHRDRE1ETFk1czB4dFNyQVYyZGlXS3JzS09iZWEiLCJtYWMiOiJhMTBjODg4ZWVhNjBlYzQyNTAzZTUwNjA3YzgxNWFkMzliOWZjODE3OTYxZmRlNTUwMTQ0ZDZkMzU4OGQzY2E1In0%3D; expires=Wed, 02-Apr-2025 06:49:41 GMT; path=/XSRF-TOKEN=eyJpdiI6IlJteWVTeW1XeGpFOW5heCtodlNJMUE9PSIsInZhbHVlIjoiWDEwcjZiNDFOWGFOL1RFVzAzMStjSWIvVFV1UVEzL21sTnpiYXdETzQzZlpRYjEzK2lHSWQxV3drOWozMjBiaWtGcUdic" 1 => "botble_session=eyJpdiI6Imw1K2Y3dVNOaWp6YzRzTjVJV2gyd2c9PSIsInZhbHVlIjoiVU5HemI2Wm1YYXZwZE1hRkNyRGdoZlExeVlQNXN5QlFrYXVXWGR5dnFEbXJVN2NZYmJ2dnR4enJxc2puRFJyQ3dFY2tnVkxkVFlld3ZlVDdaUTVtck00KzBZQ2I5NU9rQm1tQWRmWHZrcnF2bDB5MGpubVpIelN6TlQ1QkdXV3oiLCJtYWMiOiIwMjFkMjdkNWYwYjMxMGM2MDVmZDZjYWVhZjEwZjVjNzVjZTgzNmJmNjc0ZTQyNGM4NGVmMDRmZDhlOTUxMGE5In0%3D; expires=Wed, 02-Apr-2025 06:49:41 GMT; path=/; httponlybotble_session=eyJpdiI6Imw1K2Y3dVNOaWp6YzRzTjVJV2gyd2c9PSIsInZhbHVlIjoiVU5HemI2Wm1YYXZwZE1hRkNyRGdoZlExeVlQNXN5QlFrYXVXWGR5dnFEbXJVN2NZYmJ2dnR4enJxc2puRFJyQ3dFY" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "ZORq5Ws8PHljLAi7a0s5kVdZQP6fLAFuV6CJz6Ax" "_previous" => array:1 [ "url" => "https://chainhuacaocap.com/product-categories/chai-nhua-bong-den" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]