8.2.0PHP Version730msRequest Duration2MBMemory UsageGET products/{slug}/{searchData?}Route
    • Booting (7.94ms)
    • Application (722ms)
    • 1 x Application (98.9%)
      721.66ms
      1 x Booting (1.09%)
      7.94ms
      29 templates were rendered
      • productfilterstatic (resources/views/productfilterstatic.blade.php)4bladefile
        Params
        0
        category
        1
        headers
        2
        count
        3
        wishlist_products
      • livewire.sidebar (resources/views/livewire/sidebar.blade.php)19bladefile
        Params
        0
        prices
        1
        categoriesProductCount
        2
        attributes
        3
        subCategories
        4
        subcategoriesProductCount
        5
        errors
        6
        _instance
        7
        baseUrl
        8
        per_page
        9
        search
        10
        featured
        11
        selected
        12
        wishlistProducts
        13
        staticCategories
        14
        page
        15
        paginators
        16
        headers
        17
        count
        18
        wishlist_products
      • partials.filter (resources/views/partials/filter.blade.php)21bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)24bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        prices
        5
        categoriesProductCount
        6
        attributes
        7
        subCategories
        8
        subcategoriesProductCount
        9
        baseUrl
        10
        per_page
        11
        search
        12
        featured
        13
        selected
        14
        wishlistProducts
        15
        staticCategories
        16
        page
        17
        paginators
        18
        headers
        19
        count
        20
        wishlist_products
        21
        __currentLoopData
        22
        loop
        23
        product
      • pagination (resources/views/pagination.blade.php)5bladefile
        Params
        0
        paginator
        1
        elements
        2
        headers
        3
        count
        4
        wishlist_products
      • layouts.master (resources/views/layouts/master.blade.php)10bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        category
        4
        headers
        5
        count
        6
        wishlist_products
        7
        header
        8
        name
        9
        html
      uri
      GET products/{slug}/{searchData?}
      middleware
      web, debug
      controller
      App\Http\Controllers\ProductController@index
      namespace
      prefix
      where
      as
      products.index
      file
      app/Http/Controllers/ProductController.php:22-234
      21 statements were executed, 2 of which were duplicated, 19 unique. Show only duplicated698ms
      • select * from `categories` where `slug` = 'more' limit 1
        410μs/app/Http/Controllers/ProductController.php:24kapasi
        Metadata
        Bindings
        • 0. more
        Backtrace
        • 15. /app/Http/Controllers/ProductController.php:24
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `slug` = 'more' limit 1
        310μs/app/Http/Livewire/Sidebar.php:59kapasi
        Metadata
        Bindings
        • 0. more
        Backtrace
        • 15. /app/Http/Livewire/Sidebar.php:59
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      • select `name`, `id` from `categories` where `top_cat_id` is null
        370μs/app/Http/Livewire/Sidebar.php:87kapasi
        Metadata
        Backtrace
        • 13. /app/Http/Livewire/Sidebar.php:87
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 15. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      • select CASE WHEN price < 500 THEN "Less than 500" WHEN price BETWEEN 500 AND 5000 THEN "500 - 5000" WHEN price BETWEEN 5000 AND 10000 THEN "5000 - 10000" WHEN price BETWEEN 10000 AND 20000 THEN "10000 - 20000" ELSE "More than 20000" END AS price_range, COUNT(products.id) as products_count from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(8, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 group by `price_range`
        53.05ms/app/Services/PriceService.php:65kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 14. /app/Services/PriceService.php:65
        • 15. /app/Services/PriceService.php:36
        • 16. /app/Http/Livewire/Sidebar.php:110
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
      • select * from `categories` where `top_cat_id` in (8) and `active` = 1 order by `name` asc
        830μs/app/Http/Livewire/Sidebar.php:120kapasi
        Metadata
        Bindings
        • 0. 8
        • 1. 1
        Backtrace
        • 14. /app/Http/Livewire/Sidebar.php:120
        • 15. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 16. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(8, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        28.51ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(27, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        31.44ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(39, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        36.85ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(40, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        52.8ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(41, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        42.76ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(42, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        28.72ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(43, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        57.19ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(44, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        35.69ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:128
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(46, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        30.45ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:154
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(48, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        44.77ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:154
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(47, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        30.09ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:154
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(45, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        27.44ms/app/Models/Category.php:50kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Models/Category.php:50
        • 16. /app/Http/Livewire/Sidebar.php:154
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select `attribute_name`, TRIM(value) as value, COUNT(distinct(product_id)) as product_count from `products_filter_attribute` where `active` = 1 and exists (select * from `products` where `products_filter_attribute`.`product_id` = `products`.`id` and exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(8, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 and `active` = 1) group by `attribute_name`, `value` order by CASE WHEN attribute_name = 'Material' THEN 1 WHEN attribute_name = 'Size' THEN 2 WHEN attribute_name = 'Finishing / Polishing' THEN 3 WHEN attribute_name = 'Availability' THEN 4 WHEN attribute_name = 'Occasion' THEN 5 WHEN attribute_name = 'Special features' THEN 6 ELSE 7 END
        97.99ms/app/Http/Livewire/Sidebar.php:196kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 
        • 3. 
        • 4. 1
        • 5. 1
        Backtrace
        • 14. /app/Http/Livewire/Sidebar.php:196
        • 15. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 16. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      • select `id` from `categories` where `top_cat_id` = 8
        610μs/app/Http/Livewire/Sidebar.php:240kapasi
        Metadata
        Bindings
        • 0. 8
        Backtrace
        • 13. /app/Http/Livewire/Sidebar.php:240
        • 14. /app/Http/Livewire/Sidebar.php:246
        • 15. /app/Http/Livewire/Sidebar.php:203
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
      • select count(*) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(8, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1
        30.41ms/app/Http/Livewire/Sidebar.php:232kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Http/Livewire/Sidebar.php:232
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      • select distinct * from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(8, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 order by `audit_created_date` desc, `id` desc limit 12 offset 0
        66.93ms/app/Http/Livewire/Sidebar.php:232kapasi
        Metadata
        Bindings
        • 0. 1
        • 1. 
        • 2. 
        • 3. 1
        Backtrace
        • 15. /app/Http/Livewire/Sidebar.php:232
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41
        • 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
        • 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35
      App\Models\ProductsFilterAttribute
      51
      App\Models\Product
      17
      App\Models\Category
      10
      sidebar #RCyylvdqaT8M0wEqltA2
      array:5 [ "data" => array:9 [ "baseUrl" => "https://kapasi-com-new.webmavens.com/products/more...
        _token
        W5KRAkgwWfKCGluCVq9J93HQJfo47cxNZG9c2JaI
        _previous
        array:1 [ "url" => "https://kapasi-com-new.webmavens.com/products/more/1" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /products/more/1
        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 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "kapasi-com-new.webmavens.com" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
        request_server
        0 of 0
        array:40 [ "USER" => "forge" "HOME" => "/home/forge" "HTTP_PRIORITY" => "u=0, i" "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_HOST" => "kapasi-com-new.webmavens.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SERVER_NAME" => "kapasi-com-new.webmavens.com" "SERVER_PORT" => "443" "SERVER_ADDR" => "161.35.1.11" "REMOTE_PORT" => "40304" "REMOTE_ADDR" => "3.144.33.74" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/home/forge/kapasi-com-new.webmavens.com/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/products/more/1" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/forge/kapasi-com-new.webmavens.com/public/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743784547.3859 "REQUEST_TIME" => 1743784547 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "max-age=0, must-revalidate, no-cache, no-store, private" ] "date" => array:1 [ 0 => "Fri, 04 Apr 2025 16:35:47 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "Fri, 01 Jan 1990 00:00:00 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik0ySEJCZ3VnZGIrbENNNlBmWVFTRXc9PSIsInZhbHVlIjoiektmMlhLVUZEWEhSZDIrUGh4M0VIVFNINUhzVFYzeWVqMStRMlZnMS9sUkhLSWY0QS9DRUJEMm5iL1NnSjFIaWoxVzNseWRHSnI1ZVdVWVVWZU05VXNqTlE1cUFabGVIaDc3QVZvcHQ2UWw2WHIrSFRKSXlHcEh1RUtCRFBLcm4iLCJtYWMiOiI3NTBiYjYwZGM0NzgzNzhkNGViYTMwYTQ2NzRiMGEwOGQzZTJhOTY4Y2I1NzQzODkwZjUzYTlhMTgxZTk4YmI5IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 18:35:48 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ik0ySEJCZ3VnZGIrbENNNlBmWVFTRXc9PSIsInZhbHVlIjoiektmMlhLVUZEWEhSZDIrUGh4M0VIVFNINUhzVFYzeWVqMStRMlZnMS9sUkhLSWY0QS9DRUJEMm5iL1NnSjFIaWoxVzNse" 1 => "kapasi_session=eyJpdiI6IkhFV25pbVA3aGwwY2o5ZU1Pd3oxOWc9PSIsInZhbHVlIjoiZTljZmRRRllibWpZcEVBWUlhaTJNSC9nekFBdDBwdlljZENJc2NtdVdTOG1jcmI0THRYblo3QlI3RG8xL1gvcXpXRy8vQVZoNnc1cXA4MzhON0tQY0JrMHgvRjVTakdiNXRJMG1nWUZ2STBXMVBPM0ZQczFaQlY1ZWNQd2tITUgiLCJtYWMiOiJhMjJjZjkwMTM4M2MwZmRmY2M1NjJmNGNiMmFjYWQ3MmNmOWEyZDBlMzQzMDNhNGJlODc3N2IzYjRiZTUyMzZiIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 18:35:48 GMT; Max-Age=7200; path=/; httponly; samesite=laxkapasi_session=eyJpdiI6IkhFV25pbVA3aGwwY2o5ZU1Pd3oxOWc9PSIsInZhbHVlIjoiZTljZmRRRllibWpZcEVBWUlhaTJNSC9nekFBdDBwdlljZENJc2NtdVdTOG1jcmI0THRYblo3QlI3RG8xL1gvcXpXR" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik0ySEJCZ3VnZGIrbENNNlBmWVFTRXc9PSIsInZhbHVlIjoiektmMlhLVUZEWEhSZDIrUGh4M0VIVFNINUhzVFYzeWVqMStRMlZnMS9sUkhLSWY0QS9DRUJEMm5iL1NnSjFIaWoxVzNseWRHSnI1ZVdVWVVWZU05VXNqTlE1cUFabGVIaDc3QVZvcHQ2UWw2WHIrSFRKSXlHcEh1RUtCRFBLcm4iLCJtYWMiOiI3NTBiYjYwZGM0NzgzNzhkNGViYTMwYTQ2NzRiMGEwOGQzZTJhOTY4Y2I1NzQzODkwZjUzYTlhMTgxZTk4YmI5IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 18:35:48 GMT; path=/XSRF-TOKEN=eyJpdiI6Ik0ySEJCZ3VnZGIrbENNNlBmWVFTRXc9PSIsInZhbHVlIjoiektmMlhLVUZEWEhSZDIrUGh4M0VIVFNINUhzVFYzeWVqMStRMlZnMS9sUkhLSWY0QS9DRUJEMm5iL1NnSjFIaWoxVzNse" 1 => "kapasi_session=eyJpdiI6IkhFV25pbVA3aGwwY2o5ZU1Pd3oxOWc9PSIsInZhbHVlIjoiZTljZmRRRllibWpZcEVBWUlhaTJNSC9nekFBdDBwdlljZENJc2NtdVdTOG1jcmI0THRYblo3QlI3RG8xL1gvcXpXRy8vQVZoNnc1cXA4MzhON0tQY0JrMHgvRjVTakdiNXRJMG1nWUZ2STBXMVBPM0ZQczFaQlY1ZWNQd2tITUgiLCJtYWMiOiJhMjJjZjkwMTM4M2MwZmRmY2M1NjJmNGNiMmFjYWQ3MmNmOWEyZDBlMzQzMDNhNGJlODc3N2IzYjRiZTUyMzZiIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 18:35:48 GMT; path=/; httponlykapasi_session=eyJpdiI6IkhFV25pbVA3aGwwY2o5ZU1Pd3oxOWc9PSIsInZhbHVlIjoiZTljZmRRRllibWpZcEVBWUlhaTJNSC9nekFBdDBwdlljZENJc2NtdVdTOG1jcmI0THRYblo3QlI3RG8xL1gvcXpXR" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "W5KRAkgwWfKCGluCVq9J93HQJfo47cxNZG9c2JaI" "_previous" => array:1 [ "url" => "https://kapasi-com-new.webmavens.com/products/more/1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]