Collection : Tropical
7.3.23PHP Version1.91sRequest Duration8MBMemory UsageGET productsRouteAuth status
    • Booting (15.12ms)
    • Application (1.9s)
    • 1 x Application (99.2%)
      1.90s
      1 x Booting (0.79%)
      15.12ms
      6 templates were rendered
      • frontend.products.index (resources/views/frontend/products/index.blade.php)13blade
        Params
        0
        products
        1
        categoryList
        2
        collectionList
        3
        styleList
        4
        materialList
        5
        weaveList
        6
        colorList
        7
        filterData
        8
        categoryId
        9
        filterDisplay
        10
        categoryData
        11
        collectionData
        12
        logged_in_user
      • pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)3blade
        Params
        0
        paginator
        1
        elements
        2
        logged_in_user
      • frontend.layouts.master (resources/views/frontend/layouts/master.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        categoryList
        5
        collectionList
        6
        styleList
        7
        materialList
        8
        weaveList
        9
        colorList
        10
        filterData
        11
        categoryId
        12
        filterDisplay
        13
        categoryData
        14
        collectionData
        15
        logged_in_user
        16
        __currentLoopData
        17
        single
        18
        loop
        19
        product
        20
        isSoldOut
        21
        finalPrice
        22
        sale_price
        23
        images
        24
        queryParams
      • frontend.includes.header (resources/views/frontend/includes/header.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        categoryList
        5
        collectionList
        6
        styleList
        7
        materialList
        8
        weaveList
        9
        colorList
        10
        filterData
        11
        categoryId
        12
        filterDisplay
        13
        categoryData
        14
        collectionData
        15
        logged_in_user
        16
        __currentLoopData
        17
        single
        18
        loop
        19
        product
        20
        isSoldOut
        21
        finalPrice
        22
        sale_price
        23
        images
        24
        queryParams
      • includes.partials.messages (resources/views/includes/partials/messages.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        categoryList
        5
        collectionList
        6
        styleList
        7
        materialList
        8
        weaveList
        9
        colorList
        10
        filterData
        11
        categoryId
        12
        filterDisplay
        13
        categoryData
        14
        collectionData
        15
        logged_in_user
        16
        __currentLoopData
        17
        single
        18
        loop
        19
        product
        20
        isSoldOut
        21
        finalPrice
        22
        sale_price
        23
        images
        24
        queryParams
      • frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)25blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        products
        4
        categoryList
        5
        collectionList
        6
        styleList
        7
        materialList
        8
        weaveList
        9
        colorList
        10
        filterData
        11
        categoryId
        12
        filterDisplay
        13
        categoryData
        14
        collectionData
        15
        logged_in_user
        16
        __currentLoopData
        17
        single
        18
        loop
        19
        product
        20
        isSoldOut
        21
        finalPrice
        22
        sale_price
        23
        images
        24
        queryParams
      uri
      GET products
      middleware
      web
      controller
      App\Http\Controllers\Frontend\Product\ProductController@index
      as
      frontend.product.product-by-type
      namespace
      App\Http\Controllers\Frontend\Product
      prefix
      where
      file
      app/Http/Controllers/Frontend/Product/ProductController.php:62-431
      90 statements were executed, 63 of which were duplicated, 27 unique1.57s
      • select * from `subcategories`8.11ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:88
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `subcategories` (SIMPLE)1041
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows104
        filtered100
        Extranull
      • select * from `subcategories` where `subcategories`.`id` = '45' limit 11.47ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Repositories/BaseRepository.php:33
        • 17. /app/Http/Controllers/Frontend/Product/ProductController.php:93
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `categories`1.23ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:96
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `categories` (SIMPLE)341
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows34
        filtered100
        Extranull
      • select * from `styles`1.46ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:97
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `styles` (SIMPLE)2101
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows210
        filtered100
        Extranull
      • select * from `materials`1.54ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:98
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `materials` (SIMPLE)531
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows53
        filtered100
        Extranull
      • select * from `weaves`1.08ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:99
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `weaves` (SIMPLE)161
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows16
        filtered100
        Extranull
      • select * from `colors`1.4ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:100
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `colors` (SIMPLE)1031
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows103
        filtered100
        Extranull
      • select count(*) as aggregate from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '45' and `products`.`status` = 159.43ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered100
        Extranull
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 095.94ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered100
        ExtraUsing filesort
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc10.44ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:312
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc10.95ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:314
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered1.0000001192092896
        ExtraUsing where
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc11ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:316
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc14.79ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:318
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc16.48ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:320
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `product_colors` as `color_list_table` on `color_list_table`.`product_id` = `products`.`id` inner join `colors` on `colors`.`id` = `color_list_table`.`color_id` where `products`.`subcategory_id` = '45' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc70.27ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc
        Metadata
        Bindings
        • 0. 45
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:324
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `color_list_table` (SIMPLE)149511
        Metadata
        id1
        select_typeSIMPLE
        tablecolor_list_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows14951
        filtered100
        ExtraUsing temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.color_id
        rows1
        filtered100
        ExtraUsing where
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select * from `subcategories` where `subcategories`.`id` = '45' limit 13.27ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Repositories/BaseRepository.php:33
        • 17. /app/Http/Controllers/Frontend/Product/ProductController.php:361
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8672 and `product_sizes`.`product_id` is not null6.94msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8672
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8673 and `product_sizes`.`product_id` is not null12.98msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8673
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8674 and `product_sizes`.`product_id` is not null5.75msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8674
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8676 and `product_sizes`.`product_id` is not null8.53msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8676
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8677 and `product_sizes`.`product_id` is not null12.9msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8677
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8377 and `product_sizes`.`product_id` is not null5.32msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8377
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8376 and `product_sizes`.`product_id` is not null8.83msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8376
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8675 and `product_sizes`.`product_id` is not null14.3msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8675
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8900 and `product_sizes`.`product_id` is not null5.39msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8900
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8678 and `product_sizes`.`product_id` is not null6.17msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8678
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8875 and `product_sizes`.`product_id` is not null8.6msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8875
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8878 and `product_sizes`.`product_id` is not null5.57msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8878
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8425 and `product_sizes`.`product_id` is not null6.06msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8425
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc44.26ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:87
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc40.31ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc41.33ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc23.85ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:90
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc34.13ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc13.96ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc11.79ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc18.3ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.06ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc16.34ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc15.61ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc14.27ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc14.8ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc12.89ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc11.75ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc26.2ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc27.46ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:106
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc25.27ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:107
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc29.62ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc29.48ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc24.01ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc26.06ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc27.1ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc26.2ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc27.25ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc16.04ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc15.96ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc15.43ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.11ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 17. /app/Helpers/Frontend/MenuHelper.php:130
        • 18. view::frontend.includes.header:3
        • 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • - EXPLAIN # 1: `settings` (SIMPLE)91
        Metadata
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9
        filtered100
        Extranull
      • select * from `cart_storage` where `cart_storage`.`id` = '5590_cart_items' limit 14.22ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 5590_cart_items
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 19. /app/DatabaseStorage.php:18
        • 20. /app/DatabaseStorage.php:22
        • 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675
        • 22. /app/Helpers/Frontend/MenuHelper.php:160
      • - EXPLAIN # 1: `` (SIMPLE)1
        Metadata
        id1
        select_typeSIMPLE
        tablenull
        partitionsnull
        typenull
        possible_keysnull
        keynull
        key_lennull
        refnull
        rowsnull
        filterednull
        Extrano matching row in const table
      • select * from `cart_storage` where `cart_storage`.`id` = '5590_cart_items' limit 13.8ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 5590_cart_items
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 19. /app/DatabaseStorage.php:18
        • 20. /app/DatabaseStorage.php:22
        • 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675
        • 22. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:657
      • - EXPLAIN # 1: `` (SIMPLE)1
        Metadata
        id1
        select_typeSIMPLE
        tablenull
        partitionsnull
        typenull
        possible_keysnull
        keynull
        key_lennull
        refnull
        rowsnull
        filterednull
        Extrano matching row in const table
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc27.96ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:87
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc62.53ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc44.95ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc25.47ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:90
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc21.92ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc16.04ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc22.32ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc18.84ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.57ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc23.79ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc14.21ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc9.85ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc15.59ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc15.93ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc12.3ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc13.03ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc11.87ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:106
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc11.7ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:107
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc11.7ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc16.11ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc17.28ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc10.99ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc10.66ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc10.21ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc10.56ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc9.87ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc9.57ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc10.33ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.37ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 17. /app/Helpers/Frontend/MenuHelper.php:130
        • 18. view::frontend.includes.footer:25
        • 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • - EXPLAIN # 1: `settings` (SIMPLE)91
        Metadata
        id1
        select_typeSIMPLE
        tablesettings
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9
        filtered100
        Extranull
      • select * from `cart_storage` where `cart_storage`.`id` = '5590_cart_items' limit 11.44ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 5590_cart_items
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 19. /app/DatabaseStorage.php:18
        • 20. /app/DatabaseStorage.php:22
        • 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675
        • 22. /app/Helpers/Frontend/MenuHelper.php:160
      • - EXPLAIN # 1: `` (SIMPLE)1
        Metadata
        id1
        select_typeSIMPLE
        tablenull
        partitionsnull
        typenull
        possible_keysnull
        keynull
        key_lennull
        refnull
        rowsnull
        filterednull
        Extrano matching row in const table
      App\Models\Setting\Setting
      18
      App\Models\Product\ProductSize
      13
      App\Models\Product\Product
      1071
      App\Models\Color\Color
      103
      App\Models\Weave\Weave
      16
      App\Models\Material\Material
      54
      App\Models\Style\Style
      219
      App\Models\Categories\Category
      38
      App\Models\SubCategories\SubCategory
      111
        web
        null
        api
        null
          _token
          T1OWWB63UbuvTQIHrWlpbZY7Q0p0SqPhHiqU0pnX
          cartSessionId
          5590
          _previous
          array:1 [ "url" => "https://www.pasargad.com/products?collection=45" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /products
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "collection" => "45" ]
          request_request
          0 of 0
          array:1 [ "collection" => "45" ]
          request_headers
          0 of 0
          array:15 [ "host" => array:1 [ 0 => "www.pasargad.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] ]
          request_server
          0 of 0
          array:72 [ "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "www.pasargad.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SSL_TLS_SNI" => "www.pasargad.com" "SSL_SERVER_S_DN_CN" => "pasargad.com" "SSL_SERVER_I_DN_C" => "GB" "SSL_SERVER_I_DN_ST" => "Greater Manchester" "SSL_SERVER_I_DN_L" => "Salford" "SSL_SERVER_I_DN_O" => "Sectigo Limited" "SSL_SERVER_I_DN_CN" => "Sectigo RSA Domain Validation Secure Server CA" "SSL_SERVER_SAN_DNS_0" => "pasargad.com" "SSL_SERVER_SAN_DNS_1" => "www.pasargad.com" "SSL_VERSION_INTERFACE" => "mod_ssl/2.4.61" "SSL_VERSION_LIBRARY" => "OpenSSL/1.0.2k-fips" "SSL_PROTOCOL" => "TLSv1.2" "SSL_SECURE_RENEG" => "true" "SSL_COMPRESS_METHOD" => "NULL" "SSL_CIPHER" => "ECDHE-RSA-AES256-GCM-SHA384" "SSL_CIPHER_EXPORT" => "false" "SSL_CIPHER_USEKEYSIZE" => "256" "SSL_CIPHER_ALGKEYSIZE" => "256" "SSL_CLIENT_VERIFY" => "NONE" "SSL_SERVER_M_VERSION" => "3" "SSL_SERVER_M_SERIAL" => "3478FEF50BD9E58CBAB269F74C65E144" "SSL_SERVER_V_START" => "Sep 17 00:00:00 2024 GMT" "SSL_SERVER_V_END" => "Sep 17 23:59:59 2025 GMT" "SSL_SERVER_S_DN" => "CN=pasargad.com" "SSL_SERVER_I_DN" => "CN=Sectigo RSA Domain Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB" "SSL_SERVER_A_KEY" => "******" "SSL_SERVER_A_SIG" => "sha256WithRSAEncryption" "SSL_SESSION_RESUMED" => "Initial" "HTTP_HOST" => "www.pasargad.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/sbin:/usr/sbin:/bin:/usr/bin" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache/2.4.61 (Amazon) OpenSSL/1.0.2k-fips PHP/7.3.23" "SERVER_NAME" => "www.pasargad.com" "SERVER_ADDR" => "172.31.30.213" "SERVER_PORT" => "443" "REMOTE_ADDR" => "216.73.216.21" "DOCUMENT_ROOT" => "/var/www/html/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/public" "SERVER_ADMIN" => "root@localhost" "SCRIPT_FILENAME" => "/var/www/html/public/index.php" "REMOTE_PORT" => "51968" "REDIRECT_URL" => "/products" "REDIRECT_QUERY_STRING" => "collection=45" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "collection=45" "REQUEST_URI" => "/products?collection=45" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755103640.7599 "REQUEST_TIME" => 1755103640 ]
          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, 13 Aug 2025 16:47:21 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpWa0I4SWg3VExXNnRIc2hRR1dyc2c9PSIsInZhbHVlIjoiY0lKbFdMSFdPbUpJV2ZKMHVoTmt0cElXSXBuQW5Pb2RabXEwNHFvRkxCTExRcFJFc0hxbjNNRE5KcEZvR2grNlhsTFJqNHFsd2lYamEzd1Q0OFE1RVczMHp6Zm9KYWRtdm9qT0cwdlNRbGd3NVh0MXZPSW1BUm53VjlXTmQyRDciLCJtYWMiOiI0NzgzYzhhZjMzZTcyZjQzMzk0NTAzNjkzNTdmM2EyMzQ1MTk4OGNiODRlYzU2NzRhMDUxYzAzMjJhM2VmM2VhIn0%3D; expires=Thu, 25-Nov-2027 00:47:22 GMT; Max-Age=72000000; path=/XSRF-TOKEN=eyJpdiI6ImpWa0I4SWg3VExXNnRIc2hRR1dyc2c9PSIsInZhbHVlIjoiY0lKbFdMSFdPbUpJV2ZKMHVoTmt0cElXSXBuQW5Pb2RabXEwNHFvRkxCTExRcFJFc0hxbjNNRE5KcEZvR2grNlhsTFJqN" 1 => "laravel_session=eyJpdiI6Im5NcVZDRXp3SUNtdks3T3R2UmN4alE9PSIsInZhbHVlIjoiNWJvcm9kVm1CN2kwa090ZkZsTkVMYVlkRTA0MHpnNURiU2FaSEZUNEE3MGcrOXhzR2kvKzlFVklBb0FRQk1EOGROLzZQaGlNN3F0ZTFwU3FuRk1nSnovOUF5N2luaExIL2ZaY1FVTUtYeDVXMG5OSDl2R3hEcFJaL0htd3VnU3kiLCJtYWMiOiI1MTNlZmViNWFlOWFlZTgxZDEzZDdiYjQ2M2UzOGM0OTQ0NzEyZGUwY2MzMzgxZTYyNDRmYWNhOWZlNjI3YTA3In0%3D; expires=Thu, 25-Nov-2027 00:47:22 GMT; Max-Age=72000000; path=/; httponlylaravel_session=eyJpdiI6Im5NcVZDRXp3SUNtdks3T3R2UmN4alE9PSIsInZhbHVlIjoiNWJvcm9kVm1CN2kwa090ZkZsTkVMYVlkRTA0MHpnNURiU2FaSEZUNEE3MGcrOXhzR2kvKzlFVklBb0FRQk1EOGRO" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpWa0I4SWg3VExXNnRIc2hRR1dyc2c9PSIsInZhbHVlIjoiY0lKbFdMSFdPbUpJV2ZKMHVoTmt0cElXSXBuQW5Pb2RabXEwNHFvRkxCTExRcFJFc0hxbjNNRE5KcEZvR2grNlhsTFJqNHFsd2lYamEzd1Q0OFE1RVczMHp6Zm9KYWRtdm9qT0cwdlNRbGd3NVh0MXZPSW1BUm53VjlXTmQyRDciLCJtYWMiOiI0NzgzYzhhZjMzZTcyZjQzMzk0NTAzNjkzNTdmM2EyMzQ1MTk4OGNiODRlYzU2NzRhMDUxYzAzMjJhM2VmM2VhIn0%3D; expires=Thu, 25-Nov-2027 00:47:22 GMT; path=/XSRF-TOKEN=eyJpdiI6ImpWa0I4SWg3VExXNnRIc2hRR1dyc2c9PSIsInZhbHVlIjoiY0lKbFdMSFdPbUpJV2ZKMHVoTmt0cElXSXBuQW5Pb2RabXEwNHFvRkxCTExRcFJFc0hxbjNNRE5KcEZvR2grNlhsTFJqN" 1 => "laravel_session=eyJpdiI6Im5NcVZDRXp3SUNtdks3T3R2UmN4alE9PSIsInZhbHVlIjoiNWJvcm9kVm1CN2kwa090ZkZsTkVMYVlkRTA0MHpnNURiU2FaSEZUNEE3MGcrOXhzR2kvKzlFVklBb0FRQk1EOGROLzZQaGlNN3F0ZTFwU3FuRk1nSnovOUF5N2luaExIL2ZaY1FVTUtYeDVXMG5OSDl2R3hEcFJaL0htd3VnU3kiLCJtYWMiOiI1MTNlZmViNWFlOWFlZTgxZDEzZDdiYjQ2M2UzOGM0OTQ0NzEyZGUwY2MzMzgxZTYyNDRmYWNhOWZlNjI3YTA3In0%3D; expires=Thu, 25-Nov-2027 00:47:22 GMT; path=/; httponlylaravel_session=eyJpdiI6Im5NcVZDRXp3SUNtdks3T3R2UmN4alE9PSIsInZhbHVlIjoiNWJvcm9kVm1CN2kwa090ZkZsTkVMYVlkRTA0MHpnNURiU2FaSEZUNEE3MGcrOXhzR2kvKzlFVklBb0FRQk1EOGRO" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "T1OWWB63UbuvTQIHrWlpbZY7Q0p0SqPhHiqU0pnX" "cartSessionId" => 5590 "_previous" => array:1 [ "url" => "https://www.pasargad.com/products?collection=45" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]