This site uses cookies for a more convenient user experience. By continuing to browse the pages of the site, you agree to using cookies

Agree
8.1.8PHP Version77.29msRequest Duration3MBMemory UsageGET webstore/{alias}/{filter}Route
    • Booting (8.45ms)
    • Application (68.78ms)
    • controller___construct (7.35ms)
    • 1 x Application (88.99%)
      68.78ms
      1 x Booting (10.94%)
      8.45ms
      1 x controller___construct (9.51%)
      7.35ms
      7 templates were rendered
      • categories.index (resources/views/categories/index.blade.php)0blade
      • elements.breadcrumbs (resources/views/elements/breadcrumbs.blade.php)45blade
        Params
        0
        __env
        1
        app
        2
        admin_link
        3
        noindex_follow
        4
        noindex_nofollow
        5
        curr_lang
        6
        public_storage
        7
        user_info
        8
        nav_menu
        9
        footer_menu
        10
        isDesktop
        11
        isMobile
        12
        isPhone
        13
        categories
        14
        dev_user
        15
        default_shipping_params
        16
        current_currency_info
        17
        meta_title
        18
        meta_description
        19
        meta_keywords
        20
        add_page_class
        21
        not_paid_orders
        22
        add_maincontent_class
        23
        lang_list
        24
        currency_list
        25
        rel_canonical
        26
        cart_list
        27
        body_backrgound_color
        28
        og_image
        29
        errors
        30
        og_title
        31
        og_description
        32
        data
        33
        sort_array
        34
        sort_ord
        35
        filters
        36
        filter_array
        37
        filter_group_array
        38
        direction_ord
        39
        variant_features
        40
        category
        41
        breadcrumbs
        42
        breadcrumbs_count
        43
        breadcrumbs_list
        44
        cat0
      • categories.product_item (resources/views/categories/product_item.blade.php)60blade
        Params
        0
        __env
        1
        app
        2
        admin_link
        3
        noindex_follow
        4
        noindex_nofollow
        5
        curr_lang
        6
        public_storage
        7
        user_info
        8
        nav_menu
        9
        footer_menu
        10
        isDesktop
        11
        isMobile
        12
        isPhone
        13
        categories
        14
        dev_user
        15
        default_shipping_params
        16
        current_currency_info
        17
        meta_title
        18
        meta_description
        19
        meta_keywords
        20
        add_page_class
        21
        not_paid_orders
        22
        add_maincontent_class
        23
        lang_list
        24
        currency_list
        25
        rel_canonical
        26
        cart_list
        27
        body_backrgound_color
        28
        og_image
        29
        errors
        30
        og_title
        31
        og_description
        32
        data
        33
        sort_array
        34
        sort_ord
        35
        filters
        36
        filter_array
        37
        filter_group_array
        38
        direction_ord
        39
        variant_features
        40
        category
        41
        breadcrumbs
        42
        breadcrumbs_count
        43
        breadcrumbs_list
        44
        cat0
        45
        __currentLoopData
        46
        cat
        47
        loop
        48
        group
        49
        value
        50
        iter
        51
        value_title
        52
        add_params
        53
        f
        54
        sort
        55
        group_iter
        56
        group_title
        57
        product_class_grid
        58
        product
        59
        add_class
      • categories.product_item (resources/views/categories/product_item.blade.php)60blade
        Params
        0
        __env
        1
        app
        2
        admin_link
        3
        noindex_follow
        4
        noindex_nofollow
        5
        curr_lang
        6
        public_storage
        7
        user_info
        8
        nav_menu
        9
        footer_menu
        10
        isDesktop
        11
        isMobile
        12
        isPhone
        13
        categories
        14
        dev_user
        15
        default_shipping_params
        16
        current_currency_info
        17
        meta_title
        18
        meta_description
        19
        meta_keywords
        20
        add_page_class
        21
        not_paid_orders
        22
        add_maincontent_class
        23
        lang_list
        24
        currency_list
        25
        rel_canonical
        26
        cart_list
        27
        body_backrgound_color
        28
        og_image
        29
        errors
        30
        og_title
        31
        og_description
        32
        data
        33
        sort_array
        34
        sort_ord
        35
        filters
        36
        filter_array
        37
        filter_group_array
        38
        direction_ord
        39
        variant_features
        40
        category
        41
        breadcrumbs
        42
        breadcrumbs_count
        43
        breadcrumbs_list
        44
        cat0
        45
        __currentLoopData
        46
        cat
        47
        loop
        48
        group
        49
        value
        50
        iter
        51
        value_title
        52
        add_params
        53
        f
        54
        sort
        55
        group_iter
        56
        group_title
        57
        product_class_grid
        58
        product
        59
        add_class
      • categories.product_item (resources/views/categories/product_item.blade.php)60blade
        Params
        0
        __env
        1
        app
        2
        admin_link
        3
        noindex_follow
        4
        noindex_nofollow
        5
        curr_lang
        6
        public_storage
        7
        user_info
        8
        nav_menu
        9
        footer_menu
        10
        isDesktop
        11
        isMobile
        12
        isPhone
        13
        categories
        14
        dev_user
        15
        default_shipping_params
        16
        current_currency_info
        17
        meta_title
        18
        meta_description
        19
        meta_keywords
        20
        add_page_class
        21
        not_paid_orders
        22
        add_maincontent_class
        23
        lang_list
        24
        currency_list
        25
        rel_canonical
        26
        cart_list
        27
        body_backrgound_color
        28
        og_image
        29
        errors
        30
        og_title
        31
        og_description
        32
        data
        33
        sort_array
        34
        sort_ord
        35
        filters
        36
        filter_array
        37
        filter_group_array
        38
        direction_ord
        39
        variant_features
        40
        category
        41
        breadcrumbs
        42
        breadcrumbs_count
        43
        breadcrumbs_list
        44
        cat0
        45
        __currentLoopData
        46
        cat
        47
        loop
        48
        group
        49
        value
        50
        iter
        51
        value_title
        52
        add_params
        53
        f
        54
        sort
        55
        group_iter
        56
        group_title
        57
        product_class_grid
        58
        product
        59
        add_class
      • pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • layouts.frontend (resources/views/layouts/frontend.blade.php)59blade
        Params
        0
        __env
        1
        app
        2
        admin_link
        3
        noindex_follow
        4
        noindex_nofollow
        5
        curr_lang
        6
        public_storage
        7
        user_info
        8
        nav_menu
        9
        footer_menu
        10
        isDesktop
        11
        isMobile
        12
        isPhone
        13
        categories
        14
        dev_user
        15
        default_shipping_params
        16
        current_currency_info
        17
        meta_title
        18
        meta_description
        19
        meta_keywords
        20
        add_page_class
        21
        not_paid_orders
        22
        add_maincontent_class
        23
        lang_list
        24
        currency_list
        25
        rel_canonical
        26
        cart_list
        27
        body_backrgound_color
        28
        og_image
        29
        errors
        30
        og_title
        31
        og_description
        32
        data
        33
        sort_array
        34
        sort_ord
        35
        filters
        36
        filter_array
        37
        filter_group_array
        38
        direction_ord
        39
        variant_features
        40
        category
        41
        breadcrumbs
        42
        breadcrumbs_count
        43
        breadcrumbs_list
        44
        cat0
        45
        __currentLoopData
        46
        cat
        47
        loop
        48
        group
        49
        value
        50
        iter
        51
        value_title
        52
        add_params
        53
        f
        54
        sort
        55
        group_iter
        56
        group_title
        57
        product_class_grid
        58
        product
      uri
      GET webstore/{alias}/{filter}
      middleware
      web, localize, localizationRedirect
      controller
      App\Http\Controllers\CategoriesController@index
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/CategoriesController.php:26-413
      46 statements were executed27.19ms
      • select `title`, `code` from `langs` where `show_in_site` = 1
        1.52ms/app/Http/Controllers/Controller.php:134dot_db
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 13. /app/Http/Controllers/Controller.php:134
        • 14. /app/Http/Controllers/CategoriesController.php:23
        • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:915
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:756
        • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:860
      • select * from `currencies` where `is_active` = 1 and `is_default` = 1 limit 1
        320μs/app/Http/Controllers/Controller.php:183dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 15. /app/Http/Controllers/Controller.php:183
        • 16. /app/Http/Controllers/CategoriesController.php:23
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:915
        • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:756
        • 20. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:860
      • select * from `orders` where `visitor_id` = '0' and `payment_id` != 15 and `payment_status` = 0 and `show_notify` = 1 order by `id` desc limit 1
        460μs/app/Http/Controllers/Controller.php:297dot_db
        Metadata
        Bindings
        • 0. 0
        • 1. 15
        • 2. 0
        • 3. 1
        Backtrace
        • 14. /app/Http/Controllers/Controller.php:297
        • 15. /app/Http/Controllers/CategoriesController.php:23
        • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:915
        • 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:756
        • 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:860
      • select * from `categories` where `is_active` = 1 and `alias` = 'knitwear' limit 1
        490μs/app/Http/Controllers/CategoriesController.php:51dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. knitwear
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:51
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select * from `categories` where (12 between `categories`.`_lft` and `categories`.`_rgt` and `categories`.`id` <> 97)
        430μs/vendor/kalnoy/nestedset/src/NodeTrait.php:935dot_db
        Metadata
        Bindings
        • 0. 12
        • 1. 97
        Backtrace
        • 15. /vendor/kalnoy/nestedset/src/NodeTrait.php:935
        • 16. /app/Http/Controllers/CategoriesController.php:57
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select * from `categories` where `categories`.`_lft` between 12 and 12
        340μs/vendor/kalnoy/nestedset/src/BaseRelation.php:132dot_db
        Metadata
        Bindings
        • 0. 12
        • 1. 12
        Backtrace
        • 14. /vendor/kalnoy/nestedset/src/BaseRelation.php:132
        • 19. /app/Http/Controllers/CategoriesController.php:127
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select `feature_group_values`.`id`, `feature_group_values`.`feature_group_id`, `feature_group_values`.`title_en`, `feature_group_values`.`title_ua`, `feature_groups`.`title_en` as `group_name` from `feature_group_values` left join `feature_groups` on `feature_group_values`.`feature_group_id` = `feature_groups`.`id` where `feature_group_values`.`alias` = 'size_l' or `feature_group_values`.`id` = 'size_l' limit 1
        360μs/app/Http/Controllers/CategoriesController.php:207dot_db
        Metadata
        Bindings
        • 0. size_l
        • 1. size_l
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:207
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select `products`.*, (price > 0) as bool_price, (in_stock > 0) as bool_stock from `products` where `is_active` = 1 and `products`.`category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and `parent_id` is null order by `is_new` desc, `bool_price` desc, `bool_stock` desc, `sort` asc, `id` desc
        990μs/app/Http/Controllers/CategoriesController.php:260dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        Backtrace
        • 14. /app/Http/Controllers/CategoriesController.php:260
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select `feature_group_id` from `feature_groups_show_in_category` where `category_id` > 0 and `category_id` = 97
        370μs/app/Http/Controllers/CategoriesController.php:431dot_db
        Metadata
        Bindings
        • 0. 0
        • 1. 97
        Backtrace
        • 13. /app/Http/Controllers/CategoriesController.php:431
        • 14. /app/Http/Controllers/CategoriesController.php:262
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select * from `feature_groups` where `show_in_filters` = 1 and `id` in (39, 40, 41, 42, 43) order by `sort` asc, `title_en` asc
        600μs/app/Http/Controllers/CategoriesController.php:438dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 39
        • 2. 40
        • 3. 41
        • 4. 42
        • 5. 43
        Backtrace
        • 14. /app/Http/Controllers/CategoriesController.php:438
        • 15. /app/Http/Controllers/CategoriesController.php:262
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select * from `feature_group_values` where `feature_group_values`.`feature_group_id` in (39, 40, 41, 42, 43) order by `sort` asc, CAST(title_en AS UNSIGNED) asc, `title_en` asc
        550μs/app/Http/Controllers/CategoriesController.php:438dot_db
        Metadata
        Backtrace
        • 19. /app/Http/Controllers/CategoriesController.php:438
        • 20. /app/Http/Controllers/CategoriesController.php:262
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%' or `feature_group_value_id` LIKE 1217 or `feature_group_value_id` LIKE '%,1217,%' or `feature_group_value_id` LIKE '%,1217' or `feature_group_value_id` LIKE '1217,%')
        650μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1217
        • 7. %,1217,%
        • 8. %,1217
        • 9. 1217,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%' or `feature_group_value_id` LIKE 1214 or `feature_group_value_id` LIKE '%,1214,%' or `feature_group_value_id` LIKE '%,1214' or `feature_group_value_id` LIKE '1214,%')
        570μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1214
        • 7. %,1214,%
        • 8. %,1214
        • 9. 1214,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%' or `feature_group_value_id` LIKE 1215 or `feature_group_value_id` LIKE '%,1215,%' or `feature_group_value_id` LIKE '%,1215' or `feature_group_value_id` LIKE '1215,%')
        560μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1215
        • 7. %,1215,%
        • 8. %,1215
        • 9. 1215,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%')
        560μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1236 or `feature_group_value_id` LIKE '%,1236,%' or `feature_group_value_id` LIKE '%,1236' or `feature_group_value_id` LIKE '1236,%')
        570μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1236
        • 7. %,1236,%
        • 8. %,1236
        • 9. 1236,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1237 or `feature_group_value_id` LIKE '%,1237,%' or `feature_group_value_id` LIKE '%,1237' or `feature_group_value_id` LIKE '1237,%')
        560μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1237
        • 7. %,1237,%
        • 8. %,1237
        • 9. 1237,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1235 or `feature_group_value_id` LIKE '%,1235,%' or `feature_group_value_id` LIKE '%,1235' or `feature_group_value_id` LIKE '1235,%')
        550μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1235
        • 7. %,1235,%
        • 8. %,1235
        • 9. 1235,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1240 or `feature_group_value_id` LIKE '%,1240,%' or `feature_group_value_id` LIKE '%,1240' or `feature_group_value_id` LIKE '1240,%')
        620μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1240
        • 7. %,1240,%
        • 8. %,1240
        • 9. 1240,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1238 or `feature_group_value_id` LIKE '%,1238,%' or `feature_group_value_id` LIKE '%,1238' or `feature_group_value_id` LIKE '1238,%')
        780μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1238
        • 7. %,1238,%
        • 8. %,1238
        • 9. 1238,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1234 or `feature_group_value_id` LIKE '%,1234,%' or `feature_group_value_id` LIKE '%,1234' or `feature_group_value_id` LIKE '1234,%')
        750μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1234
        • 7. %,1234,%
        • 8. %,1234
        • 9. 1234,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1241 or `feature_group_value_id` LIKE '%,1241,%' or `feature_group_value_id` LIKE '%,1241' or `feature_group_value_id` LIKE '1241,%')
        730μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1241
        • 7. %,1241,%
        • 8. %,1241
        • 9. 1241,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1233 or `feature_group_value_id` LIKE '%,1233,%' or `feature_group_value_id` LIKE '%,1233' or `feature_group_value_id` LIKE '1233,%')
        760μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1233
        • 7. %,1233,%
        • 8. %,1233
        • 9. 1233,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1239 or `feature_group_value_id` LIKE '%,1239,%' or `feature_group_value_id` LIKE '%,1239' or `feature_group_value_id` LIKE '1239,%')
        710μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1239
        • 7. %,1239,%
        • 8. %,1239
        • 9. 1239,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1219 or `feature_group_value_id` LIKE '%,1219,%' or `feature_group_value_id` LIKE '%,1219' or `feature_group_value_id` LIKE '1219,%')
        720μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1219
        • 7. %,1219,%
        • 8. %,1219
        • 9. 1219,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1220 or `feature_group_value_id` LIKE '%,1220,%' or `feature_group_value_id` LIKE '%,1220' or `feature_group_value_id` LIKE '1220,%')
        720μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1220
        • 7. %,1220,%
        • 8. %,1220
        • 9. 1220,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1223 or `feature_group_value_id` LIKE '%,1223,%' or `feature_group_value_id` LIKE '%,1223' or `feature_group_value_id` LIKE '1223,%')
        730μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1223
        • 7. %,1223,%
        • 8. %,1223
        • 9. 1223,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1242 or `feature_group_value_id` LIKE '%,1242,%' or `feature_group_value_id` LIKE '%,1242' or `feature_group_value_id` LIKE '1242,%')
        670μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1242
        • 7. %,1242,%
        • 8. %,1242
        • 9. 1242,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1222 or `feature_group_value_id` LIKE '%,1222,%' or `feature_group_value_id` LIKE '%,1222' or `feature_group_value_id` LIKE '1222,%')
        680μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1222
        • 7. %,1222,%
        • 8. %,1222
        • 9. 1222,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1218 or `feature_group_value_id` LIKE '%,1218,%' or `feature_group_value_id` LIKE '%,1218' or `feature_group_value_id` LIKE '1218,%')
        720μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1218
        • 7. %,1218,%
        • 8. %,1218
        • 9. 1218,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1224 or `feature_group_value_id` LIKE '%,1224,%' or `feature_group_value_id` LIKE '%,1224' or `feature_group_value_id` LIKE '1224,%')
        720μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1224
        • 7. %,1224,%
        • 8. %,1224
        • 9. 1224,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1221 or `feature_group_value_id` LIKE '%,1221,%' or `feature_group_value_id` LIKE '%,1221' or `feature_group_value_id` LIKE '1221,%')
        700μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1221
        • 7. %,1221,%
        • 8. %,1221
        • 9. 1221,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1225 or `feature_group_value_id` LIKE '%,1225,%' or `feature_group_value_id` LIKE '%,1225' or `feature_group_value_id` LIKE '1225,%')
        710μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1225
        • 7. %,1225,%
        • 8. %,1225
        • 9. 1225,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1226 or `feature_group_value_id` LIKE '%,1226,%' or `feature_group_value_id` LIKE '%,1226' or `feature_group_value_id` LIKE '1226,%')
        490μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1226
        • 7. %,1226,%
        • 8. %,1226
        • 9. 1226,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1227 or `feature_group_value_id` LIKE '%,1227,%' or `feature_group_value_id` LIKE '%,1227' or `feature_group_value_id` LIKE '1227,%')
        470μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1227
        • 7. %,1227,%
        • 8. %,1227
        • 9. 1227,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1228 or `feature_group_value_id` LIKE '%,1228,%' or `feature_group_value_id` LIKE '%,1228' or `feature_group_value_id` LIKE '1228,%')
        480μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1228
        • 7. %,1228,%
        • 8. %,1228
        • 9. 1228,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1229 or `feature_group_value_id` LIKE '%,1229,%' or `feature_group_value_id` LIKE '%,1229' or `feature_group_value_id` LIKE '1229,%')
        500μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1229
        • 7. %,1229,%
        • 8. %,1229
        • 9. 1229,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1230 or `feature_group_value_id` LIKE '%,1230,%' or `feature_group_value_id` LIKE '%,1230' or `feature_group_value_id` LIKE '1230,%')
        460μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1230
        • 7. %,1230,%
        • 8. %,1230
        • 9. 1230,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1231 or `feature_group_value_id` LIKE '%,1231,%' or `feature_group_value_id` LIKE '%,1231' or `feature_group_value_id` LIKE '1231,%')
        470μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1231
        • 7. %,1231,%
        • 8. %,1231
        • 9. 1231,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `parent_id` is null and `category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and (`feature_group_value_id` LIKE 1232 or `feature_group_value_id` LIKE '%,1232,%' or `feature_group_value_id` LIKE '%,1232' or `feature_group_value_id` LIKE '1232,%')
        460μs/app/Http/Controllers/CategoriesController.php:503dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        • 6. 1232
        • 7. %,1232,%
        • 8. %,1232
        • 9. 1232,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:503
        • 16. /app/Http/Controllers/CategoriesController.php:262
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • select count(*) as aggregate from `products` where `is_active` = 1 and `products`.`category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and `parent_id` is null
        470μs/app/Http/Controllers/CategoriesController.php:316dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:316
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select distinct `products`.*, (price > 0) as bool_price, (in_stock > 0) as bool_stock from `products` where `is_active` = 1 and `products`.`category_id` in (97) and (`feature_group_value_id` LIKE 1216 or `feature_group_value_id` LIKE '%,1216,%' or `feature_group_value_id` LIKE '%,1216' or `feature_group_value_id` LIKE '1216,%') and `parent_id` is null order by `is_new` desc, `bool_price` desc, `bool_stock` desc, `sort` asc, `id` desc limit 20 offset 0
        780μs/app/Http/Controllers/CategoriesController.php:316dot_db
        Metadata
        Bindings
        • 0. 1
        • 1. 97
        • 2. 1216
        • 3. %,1216,%
        • 4. %,1216
        • 5. 1216,%
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:316
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select * from `categories` where `categories`.`id` in (97)
        350μs/app/Http/Controllers/CategoriesController.php:316dot_db
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CategoriesController.php:316
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select * from `product_images` where `product_images`.`product_id` in (153895, 153951, 153956) order by `sort` asc, `id` asc
        370μs/app/Http/Controllers/CategoriesController.php:316dot_db
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CategoriesController.php:316
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select `feature_group_values`.* from `feature_group_values` left join `feature_groups` on `feature_groups`.`id` = `feature_group_values`.`feature_group_id` where `feature_groups`.`show_in_variant` = 1 order by `feature_groups`.`sort` asc, `feature_group_values`.`sort` asc
        430μs/app/Http/Controllers/CategoriesController.php:327dot_db
        Metadata
        Bindings
        • 0. 1
        Backtrace
        • 13. /app/Http/Controllers/CategoriesController.php:327
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      • select * from `seo` where `url` = '/webstore/knitwear/size_l/?direction=desc' limit 1
        290μs/app/Http/Controllers/CategoriesController.php:363dot_db
        Metadata
        Bindings
        • 0. /webstore/knitwear/size_l/?direction=desc
        Backtrace
        • 15. /app/Http/Controllers/CategoriesController.php:363
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:204
      App\Models\ProductImage
      12
      App\Models\FeatureGroup
      5
      App\Models\Product
      6
      App\Models\FeatureGroupValue
      30
      App\Models\Category
      2
      App\Models\Currency
      1
        _token
        bMe3NcO6ZgX2BGwBvg7Uqt0QMjwGhpHke3HZdek0
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /webstore/knitwear/size_l/
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "direction" => "desc" ]
        request_request
        []
        
        request_headers
        0 of 0
        array:24 [ "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "cf-connecting-ip" => array:1 [ 0 => "18.217.156.194" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "18.217.156.194" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "cf-ray" => array:1 [ 0 => "94712c0c6d26115d-ORD" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "priority" => array:1 [ 0 => "u=0, i" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "host" => array:1 [ 0 => "dotbrand.store" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
        request_server
        0 of 0
        array:53 [ "TEMP" => "/home/dot/tmp" "TMPDIR" => "/home/dot/tmp" "TMP" => "/home/dot/tmp" "PATH" => "/usr/local/bin:/usr/bin:/bin" "HOSTNAME" => "" "USER" => "dot" "HOME" => "/home/dot" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_CF_CONNECTING_IP" => "18.217.156.194" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "18.217.156.194" "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_CF_RAY" => "94712c0c6d26115d-ORD" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_PRIORITY" => "u=0, i" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_HOST" => "dotbrand.store" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "dotbrand.store" "SERVER_PORT" => "443" "SERVER_ADDR" => "159.69.30.138" "REMOTE_PORT" => "" "REMOTE_ADDR" => "18.217.156.194" "SERVER_SOFTWARE" => "nginx/1.23.1" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/home/dot/web/dotbrand.store/public_html" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/webstore/knitwear/size_l/?direction=desc" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "direction=desc" "SCRIPT_FILENAME" => "/home/dot/web/dotbrand.store/public_html/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1748471170.3231 "REQUEST_TIME" => 1748471170 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 28 May 2025 22:26:10 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ6YTlHOHFUZldROWVwbmNPVWJwZkE9PSIsInZhbHVlIjoiRW9pYmN6bXlDVk9yQS9RWC9GZUFCTHVRTlhXMEc2TWVyQjNFaGc0blZLWFZJTW53V0VrNXVqVklhSjFEbTB2aUltKzZ0YnNJRUtYR0R5WUxVUnV2Yjl1eEY5RU5jL2ErYlNDMFpaa0tsaWlJRCszN2hIZTJ3N3FkR1dCVWFtRFgiLCJtYWMiOiJmZTRkMjgxMjUzZWIwMjg1ZWRlMjkyOTIyNzBkMjUyN2ViNjNjZDE0ZTU0MzBhMmFhNjE1YTg2NmRlMDZmNWMzIiwidGFnIjoiIn0%3D; expires=Thu, 29 May 2025 02:26:10 GMT; Max-Age=14400; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlJ6YTlHOHFUZldROWVwbmNPVWJwZkE9PSIsInZhbHVlIjoiRW9pYmN6bXlDVk9yQS9RWC9GZUFCTHVRTlhXMEc2TWVyQjNFaGc0blZLWFZJTW53V0VrNXVqVklhSjFEbTB2aUltKzZ0Y" 1 => "current_currency_code=EUR; expires=Mon, 11 Aug 2025 22:26:10 GMT; Max-Age=6480000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ6YTlHOHFUZldROWVwbmNPVWJwZkE9PSIsInZhbHVlIjoiRW9pYmN6bXlDVk9yQS9RWC9GZUFCTHVRTlhXMEc2TWVyQjNFaGc0blZLWFZJTW53V0VrNXVqVklhSjFEbTB2aUltKzZ0YnNJRUtYR0R5WUxVUnV2Yjl1eEY5RU5jL2ErYlNDMFpaa0tsaWlJRCszN2hIZTJ3N3FkR1dCVWFtRFgiLCJtYWMiOiJmZTRkMjgxMjUzZWIwMjg1ZWRlMjkyOTIyNzBkMjUyN2ViNjNjZDE0ZTU0MzBhMmFhNjE1YTg2NmRlMDZmNWMzIiwidGFnIjoiIn0%3D; expires=Thu, 29-May-2025 02:26:10 GMT; path=/XSRF-TOKEN=eyJpdiI6IlJ6YTlHOHFUZldROWVwbmNPVWJwZkE9PSIsInZhbHVlIjoiRW9pYmN6bXlDVk9yQS9RWC9GZUFCTHVRTlhXMEc2TWVyQjNFaGc0blZLWFZJTW53V0VrNXVqVklhSjFEbTB2aUltKzZ0Y" 1 => "current_currency_code=EUR; expires=Mon, 11-Aug-2025 22:26:10 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:2 [ "_token" => "bMe3NcO6ZgX2BGwBvg7Uqt0QMjwGhpHke3HZdek0" "PHPDEBUGBAR_STACK_DATA" => [] ]