Collection : Jar Product : Accessories
7.3.23PHP Version3.23sRequest Duration8MBMemory UsageGET productsRouteAuth status
    • Booting (17.78ms)
    • Application (3.21s)
    • 1 x Application (99.45%)
      3.21s
      1 x Booting (0.55%)
      17.78ms
      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
      95 statements were executed, 63 of which were duplicated, 32 unique2.71s
      • select * from `subcategories`18.21ms/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` = '50' limit 18.68ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 50
        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`7.28ms/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`6.48ms/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`2.66ms/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`5.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`6.5ms/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`.`type` = 'accessories' and `products`.`subcategory_id` = '50' and `products`.`status` = 1113ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        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`.`type` = 'accessories' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 0152ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        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`.`type` = 'accessories' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc28.16ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        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' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc32.9ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        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`.`type` = 'accessories' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc43.39ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        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' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc44.82ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        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' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc42.51ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        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`.`type` = 'accessories' and `products`.`subcategory_id` = '50' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc56.94ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        • 1. 50
        • 2. 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)149531
        Metadata
        id1
        select_typeSIMPLE
        tablecolor_list_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows14953
        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` = '50' limit 12.76ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 50
        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` = 1752 and `product_sizes`.`product_id` is not null15.35msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1752
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1748 and `product_sizes`.`product_id` is not null18.79msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1748
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1749 and `product_sizes`.`product_id` is not null13.1msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1749
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1613 and `product_sizes`.`product_id` is not null21msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1613
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 80 and `product_sizes`.`product_id` is not null14.19msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 80
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1750 and `product_sizes`.`product_id` is not null19.78msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1750
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1751 and `product_sizes`.`product_id` is not null26.3msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1751
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2187 and `product_sizes`.`product_id` is not null10.44msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2187
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4921 and `product_sizes`.`product_id` is not null21.7msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4921
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4961 and `product_sizes`.`product_id` is not null29.6msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4961
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 78 and `product_sizes`.`product_id` is not null9.83msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 78
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4969 and `product_sizes`.`product_id` is not null16.61msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4969
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4976 and `product_sizes`.`product_id` is not null18.81msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4976
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4977 and `product_sizes`.`product_id` is not null14.67msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4977
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4978 and `product_sizes`.`product_id` is not null10.35msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4978
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4979 and `product_sizes`.`product_id` is not null28.07msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4979
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5114 and `product_sizes`.`product_id` is not null21.86msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5114
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4965 and `product_sizes`.`product_id` is not null13.07msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4965
        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)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        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` asc53.05ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc53.29ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc42.58ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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.45ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc22.58ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc28.7ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc18.75ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc15.71ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc25.24ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc14.48ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc30.01ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc43.76ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc33.95ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc33.55ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc43.9ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc39.23ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc35.68ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc22.78ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc17.66ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc35.01ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc28.11ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc16.21ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc22.11ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc22.59ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc20.66ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc32.51ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc48.81ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`8.45ms/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` = '6781_cart_items' limit 15.19ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 6781_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` = '6781_cart_items' limit 16.05ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 6781_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` asc45.63ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc83.86ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc50.38ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc59.41ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc40.57ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc25.41ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc46ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc30.81ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc27.9ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc33.53ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc35.98ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc30.28ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc28.37ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc27.27ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc33.83ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc42.42ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc31.63ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc30.75ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc33.27ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc32.73ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc29.66ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc27.76ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc26.84ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc27.84ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc15.87ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc15.52ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc14.69ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        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` asc14.73ms/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)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.74ms/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` = '6781_cart_items' limit 14.12ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 6781_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
      18
      App\Models\Product\Product
      1073
      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
          9gx8RmdvC8j8Vor8YVfN4p2IiC6y0qEhXoVyER3D
          cartSessionId
          6781
          _previous
          array:1 [ "url" => "https://www.pasargad.com/products?collection=50&type=accessories" ]
          _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:2 [ "collection" => "50" "type" => "accessories" ]
          request_request
          0 of 0
          array:2 [ "collection" => "50" "type" => "accessories" ]
          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.117" "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" => "55323" "REDIRECT_URL" => "/products" "REDIRECT_QUERY_STRING" => "collection=50&type=accessories" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "collection=50&type=accessories" "REQUEST_URI" => "/products?collection=50&type=accessories" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755216264.7281 "REQUEST_TIME" => 1755216264 ]
          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 => "Fri, 15 Aug 2025 00:04:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpRVUtvN2xlM0FpRkRscE1DNnJOZ3c9PSIsInZhbHVlIjoiWGszeFhkbW5IOU5LYUNYUHdSVlZtRlh6dWdadzBta2ZRcFV3L0taUjVDdThQNk5WZ2tDT1hJR25RZkNqbUNsSUFWUnplWll2Y1MyS1l3K0diT0lsTnlza3lZSm12U0VJV1NLVjEveGkrVGYxSWhheE9SaE9zL0RoN2Qyb2kvSFQiLCJtYWMiOiIzMjYzOTdlZDY5ZDJjMWExZDYzMDExNWI1NDg0YTMxNDU2NjFhYTdjY2NjYWYzMzRhOGIyMDQ5ZTY2YzViNzFmIn0%3D; expires=Fri, 26-Nov-2027 08:04:27 GMT; Max-Age=72000000; path=/XSRF-TOKEN=eyJpdiI6ImpRVUtvN2xlM0FpRkRscE1DNnJOZ3c9PSIsInZhbHVlIjoiWGszeFhkbW5IOU5LYUNYUHdSVlZtRlh6dWdadzBta2ZRcFV3L0taUjVDdThQNk5WZ2tDT1hJR25RZkNqbUNsSUFWUnplW" 1 => "laravel_session=eyJpdiI6InYwSEVrNGNnRi9GVU4zT2RVc0hWWEE9PSIsInZhbHVlIjoiR1JZcWVrR0tFdHNrdkRyUHh5REJHUWF4eUJpVzQxdVRRbGRhMkwyQXpGVTBZNlpvL3ZCUDIrNVNmaC9HYXl2d0k3dytFdzNMZkhoVFhlS0Y0dlJwM3dqcndjcUJmRWRPMEJWU0pnWjJKcDMxVVhMbi85QnJCMXh6WkVlMTJwRloiLCJtYWMiOiIzYjRjNWMxYjYzYTQ3NjA4NWYwZjBiMjU0OTdkMDJhNDUwNmFmN2NjZjMzN2M5YzBmNTM2NDQyYWYwNGMxOTFiIn0%3D; expires=Fri, 26-Nov-2027 08:04:27 GMT; Max-Age=72000000; path=/; httponlylaravel_session=eyJpdiI6InYwSEVrNGNnRi9GVU4zT2RVc0hWWEE9PSIsInZhbHVlIjoiR1JZcWVrR0tFdHNrdkRyUHh5REJHUWF4eUJpVzQxdVRRbGRhMkwyQXpGVTBZNlpvL3ZCUDIrNVNmaC9HYXl2d0k3" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpRVUtvN2xlM0FpRkRscE1DNnJOZ3c9PSIsInZhbHVlIjoiWGszeFhkbW5IOU5LYUNYUHdSVlZtRlh6dWdadzBta2ZRcFV3L0taUjVDdThQNk5WZ2tDT1hJR25RZkNqbUNsSUFWUnplWll2Y1MyS1l3K0diT0lsTnlza3lZSm12U0VJV1NLVjEveGkrVGYxSWhheE9SaE9zL0RoN2Qyb2kvSFQiLCJtYWMiOiIzMjYzOTdlZDY5ZDJjMWExZDYzMDExNWI1NDg0YTMxNDU2NjFhYTdjY2NjYWYzMzRhOGIyMDQ5ZTY2YzViNzFmIn0%3D; expires=Fri, 26-Nov-2027 08:04:27 GMT; path=/XSRF-TOKEN=eyJpdiI6ImpRVUtvN2xlM0FpRkRscE1DNnJOZ3c9PSIsInZhbHVlIjoiWGszeFhkbW5IOU5LYUNYUHdSVlZtRlh6dWdadzBta2ZRcFV3L0taUjVDdThQNk5WZ2tDT1hJR25RZkNqbUNsSUFWUnplW" 1 => "laravel_session=eyJpdiI6InYwSEVrNGNnRi9GVU4zT2RVc0hWWEE9PSIsInZhbHVlIjoiR1JZcWVrR0tFdHNrdkRyUHh5REJHUWF4eUJpVzQxdVRRbGRhMkwyQXpGVTBZNlpvL3ZCUDIrNVNmaC9HYXl2d0k3dytFdzNMZkhoVFhlS0Y0dlJwM3dqcndjcUJmRWRPMEJWU0pnWjJKcDMxVVhMbi85QnJCMXh6WkVlMTJwRloiLCJtYWMiOiIzYjRjNWMxYjYzYTQ3NjA4NWYwZjBiMjU0OTdkMDJhNDUwNmFmN2NjZjMzN2M5YzBmNTM2NDQyYWYwNGMxOTFiIn0%3D; expires=Fri, 26-Nov-2027 08:04:27 GMT; path=/; httponlylaravel_session=eyJpdiI6InYwSEVrNGNnRi9GVU4zT2RVc0hWWEE9PSIsInZhbHVlIjoiR1JZcWVrR0tFdHNrdkRyUHh5REJHUWF4eUJpVzQxdVRRbGRhMkwyQXpGVTBZNlpvL3ZCUDIrNVNmaC9HYXl2d0k3" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "9gx8RmdvC8j8Vor8YVfN4p2IiC6y0qEhXoVyER3D" "cartSessionId" => 6781 "_previous" => array:1 [ "url" => "https://www.pasargad.com/products?collection=50&type=accessories" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]