Home

Search

Bag 0

Login

Contact
Collection : Tapestry Product : Rug
  • Filters
Clear Filter
Item Genre Tapestry Landscape Romantic Vintage 1' X 1'3''
SKU# D12057-58
$156.00
Item Tapestry Jesus Wall Hanging 1'7'' X 2'3''
SKU# D11788-D11789-D11790-D11791
$547.40
Item Genre Tapestry Landscape Romantic Vintage 1'9'' X 2'4''
SKU# D12054
$273.60
Item Jesus and Samaritan Woman at the Well 2'6" X 3'3"
SKU# D12604
$1248.36
Item Flemish Wall Tapestry 2'4'' X 2'7''
SKU# D11687
$453.60
Item Flemish Wall Tapestry 2'4'' X 3'9''
SKU# D11689
$524.16
Item Flemish Wall Tapestry 2'4'' X 6'
SKU# D11770
$907.20
Item Flemish Wall Tapestry 2'4'' X 6'
SKU# D11772
$907.20
Item Flemish Wall Tapestry 2'4'' X 6'3''
SKU# D11773-D11774-D11775-D11776
$952.56
Item Flemish Wall Tapestry 2'4'' X 6'4''
SKU# D11686
$860.16
Item Flemish Wall Tapestry 2'4'' X 8'7''
SKU# D11685
$1169.28
Item Flemish Wall Tapestry 2'4'' X 3'9''
SKU# D11785
$759.50
Item City Covered with Snow Landscape Wall Tapestry 2'5'' X 4'1''
SKU# D11786
$717.50
Item Genre Tapestry Landscape Romantic Vintage 2'7'' X 4'1''
SKU# D12052
$664.20
Item Genre Tapestry Landscape Romantic Vintage 2'8'' X 4'2''
SKU# D12055
$705.60
Item Fine Vintage Turkey Tapestry 3'2"X 4'5"
SKU# D11731
$976.06
Item Antique French Floral 3'4" x 5'
SKU# D03169
$3391.50
Item Genre Tapestry Landscape Romantic Vintage 3'5'' X 3'6''
SKU# D12061
$756.00
Item Fine Vintage Tapestery 4'6"X 5'4"
SKU# D09704
$1841.62
Item Fine Hand Knotted Antique Tapestery 4'7" X 5'6''
SKU# D12603
$4118.84
Item Fine Hand Knotted Vintage Tapestery 4'9'' X 6'9''
SKU# D11972
$2873.85
Item Antique Fine Hand Knotted Tapestry 5' X 5'9''
SKU# D11093
$2950.00
Item Fine Vintage Tapestery 5'2"X 6'3"
SKU# D14937
$1513.53
MessagesTimelineExceptionsViews6RouteQueries118Models1719MailsAuthGateSessionRequest
7.3.23PHP Version1.76sRequest Duration9MBMemory UsageGET productsRouteAuth status
    • Booting (15.51ms)
    • Application (1.75s)
    • 1 x Application (99.12%)
      1.75s
      1 x Booting (0.88%)
      15.51ms
      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
      118 statements were executed, 63 of which were duplicated, 55 unique1.45s
      pasargad_dc
      • select * from `subcategories`8.78ms/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` = '25' limit 11.86ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 25
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Repositories/BaseRepository.php:33
        • 17. /app/Http/Controllers/Frontend/Product/ProductController.php:93
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `categories`1.41ms/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`7.65ms/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.72ms/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`4.6ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:99
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `weaves` (SIMPLE)161
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows16
        filtered100
        Extranull
      • select * from `colors`1.58ms/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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 143.93ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)92801
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered100
        Extranull
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 088.86ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)92801
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered100
        ExtraUsing filesort
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc11.26ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc13.49ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc17.88ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc23.5ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc22.58ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        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` = 'rug' and `products`.`subcategory_id` = '25' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc170ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 25
        • 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)149511
        Metadata
        id1
        select_typeSIMPLE
        tablecolor_list_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows14951
        filtered100
        ExtraUsing temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.color_id
        rows1
        filtered100
        ExtraUsing where
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select * from `subcategories` where `subcategories`.`id` = '25' limit 11.37ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 25
        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` = 5214 and `product_sizes`.`product_id` is not null7.06msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5214
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4627 and `product_sizes`.`product_id` is not null9.04msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4627
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5211 and `product_sizes`.`product_id` is not null5.87msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5211
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 6325 and `product_sizes`.`product_id` is not null9.1msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 6325
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3500 and `product_sizes`.`product_id` is not null5.64msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3500
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4605 and `product_sizes`.`product_id` is not null7.95msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4605
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4604 and `product_sizes`.`product_id` is not null9.21msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4604
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4613 and `product_sizes`.`product_id` is not null7.34msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4613
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4612 and `product_sizes`.`product_id` is not null8.56msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4612
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4621 and `product_sizes`.`product_id` is not null9.12msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4621
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4622 and `product_sizes`.`product_id` is not null6.74msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4622
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4623 and `product_sizes`.`product_id` is not null9.18msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4623
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4603 and `product_sizes`.`product_id` is not null5.66msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4603
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4602 and `product_sizes`.`product_id` is not null5.8msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4602
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4624 and `product_sizes`.`product_id` is not null5.52msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4624
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4625 and `product_sizes`.`product_id` is not null5.48msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4625
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4626 and `product_sizes`.`product_id` is not null5.56msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4626
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5216 and `product_sizes`.`product_id` is not null5.69msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5216
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5209 and `product_sizes`.`product_id` is not null5.56msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5209
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5208 and `product_sizes`.`product_id` is not null5.51msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5208
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5212 and `product_sizes`.`product_id` is not null5.33msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5212
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5210 and `product_sizes`.`product_id` is not null5.5msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5210
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 9024 and `product_sizes`.`product_id` is not null5.83msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 9024
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5213 and `product_sizes`.`product_id` is not null5.43msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5213
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 862 and `product_sizes`.`product_id` is not null5.5msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 862
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5217 and `product_sizes`.`product_id` is not null7.01msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5217
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 863 and `product_sizes`.`product_id` is not null5.33msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 863
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5630 and `product_sizes`.`product_id` is not null5.69msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5630
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4900 and `product_sizes`.`product_id` is not null5.36msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4900
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5394 and `product_sizes`.`product_id` is not null5.27msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5394
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 6563 and `product_sizes`.`product_id` is not null5.4msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 6563
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 9009 and `product_sizes`.`product_id` is not null5.58msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 9009
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 6319 and `product_sizes`.`product_id` is not null5.67msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 6319
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2214 and `product_sizes`.`product_id` is not null5.66msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2214
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 905 and `product_sizes`.`product_id` is not null5.73msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 905
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 170 and `product_sizes`.`product_id` is not null5.7msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 170
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4898 and `product_sizes`.`product_id` is not null10.01msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4898
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5648 and `product_sizes`.`product_id` is not null5.76msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5648
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8779 and `product_sizes`.`product_id` is not null5.52msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8779
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3952 and `product_sizes`.`product_id` is not null5.28msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3952
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1138 and `product_sizes`.`product_id` is not null5.46msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1138
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92801
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9280
        filtered10
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc17.64ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:87
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc21.47ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc21.27ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc21.82ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:90
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc21.07ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc13.69ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc16.91ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc13.64ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.25ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc13.45ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc13.31ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc13.91ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc13.11ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc19.01ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc17.08ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc17.9ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc16.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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc15.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.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc16.05ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc13.52ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc15.07ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc13.85ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc13.87ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc13.64ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc13.62ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc13.61ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc13.56ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc9.79ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.12ms/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` = '3894_cart_items' limit 11.17ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 3894_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` = '3894_cart_items' limit 11.31ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 3894_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` asc17.34ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:87
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc20.84ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc16.83ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc15.15ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:90
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc13.38ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc9.51ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc11.7ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc9.53ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc9.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)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc9.73ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc9.65ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc9.75ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc9.23ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc9.74ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc11.45ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc13.15ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc11.88ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:106
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc11.31ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:107
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc11.28ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc9.75ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc10.45ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc9.88ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.24ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc10.17ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc9.85ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc9.71ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc9.52ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc9.86ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67721
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6772
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.23ms/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` = '3894_cart_items' limit 11.16ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 3894_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
      41
      App\Models\Product\Product
      1119
      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
          E7pQ2uXOglPMRr1gXdQ1fGBkRtVykAQYdRQLENAF
          cartSessionId
          3894
          _previous
          array:1 [ "url" => "https://www.pasargad.com/products?collection=25&type=rug" ]
          _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" => "25"
  "type" => "rug"
]
          request_request
            0 of 0   
          array:2 [▶
  "collection" => "25"
  "type" => "rug"
]
          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.40"
  "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" => "35682"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "collection=25&type=rug"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "collection=25&type=rug"
  "REQUEST_URI" => "/products?collection=25&type=rug"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755061113.6468
  "REQUEST_TIME" => 1755061113
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 04:58:34 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlUyZi84dk40M0N0N0lmTVdQVU9MTVE9PSIsInZhbHVlIjoiQkxtS05mSWFKdEh2ODJhaE0rRFZBbHlWQTRjYXU4bHdCQk02UDRZMnhxUFBqTExVSjZ3Y1cweFBvcUsrc0c0UVN3UDJmRUhQaVFyWnZ5R2Rxck00eFZuYnFOT0VHN1NGeVVDM2VYY2FBUU43QWJXbFk5TjllaWk5L0hTeFRmWDEiLCJtYWMiOiJkMzZkOTE4ODY1YWRiMjQ0NzQ2MGI4NDljZWFjYTNlYzY5NmQyNGY4NTk5MzA4ZTk5NGZiMDNlYjdiNTIyMjAyIn0%3D; expires=Wed, 24-Nov-2027 12:58:35 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6IlUyZi84dk40M0N0N0lmTVdQVU9MTVE9PSIsInZhbHVlIjoiQkxtS05mSWFKdEh2ODJhaE0rRFZBbHlWQTRjYXU4bHdCQk02UDRZMnhxUFBqTExVSjZ3Y1cweFBvcUsrc0c0UVN3UDJmR ▶"
    1 => "laravel_session=eyJpdiI6IkMxTE9WUTU2NnltTFB5QkNhY2dFVlE9PSIsInZhbHVlIjoicXRjQVR5Sk1vYmp2bFJ0UTlBVFlkOGlLcWoxUis3TDlqOHEzK2hpVTN6MnZ6b214cWlpaklqbHR1VnVCMDltNVRIdC9iUGVXWFFlbVdDci9TeVBoak5GY2tlaHIvd2F4eStXTW9NdWZ4aWMzVjFUZDZxWGVxc3NaVUpTMDFad1giLCJtYWMiOiI5ZGJmYjA0ODNkM2ZlNjJkZjhkNDY4NjJhOGI1NDI5YjA3MzBhMDMwZGE1YzcxNTZkOGFjMTJhZWQ1MWMzMDg5In0%3D; expires=Wed, 24-Nov-2027 12:58:35 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6IkMxTE9WUTU2NnltTFB5QkNhY2dFVlE9PSIsInZhbHVlIjoicXRjQVR5Sk1vYmp2bFJ0UTlBVFlkOGlLcWoxUis3TDlqOHEzK2hpVTN6MnZ6b214cWlpaklqbHR1VnVCMDltNVRI ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlUyZi84dk40M0N0N0lmTVdQVU9MTVE9PSIsInZhbHVlIjoiQkxtS05mSWFKdEh2ODJhaE0rRFZBbHlWQTRjYXU4bHdCQk02UDRZMnhxUFBqTExVSjZ3Y1cweFBvcUsrc0c0UVN3UDJmRUhQaVFyWnZ5R2Rxck00eFZuYnFOT0VHN1NGeVVDM2VYY2FBUU43QWJXbFk5TjllaWk5L0hTeFRmWDEiLCJtYWMiOiJkMzZkOTE4ODY1YWRiMjQ0NzQ2MGI4NDljZWFjYTNlYzY5NmQyNGY4NTk5MzA4ZTk5NGZiMDNlYjdiNTIyMjAyIn0%3D; expires=Wed, 24-Nov-2027 12:58:35 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlUyZi84dk40M0N0N0lmTVdQVU9MTVE9PSIsInZhbHVlIjoiQkxtS05mSWFKdEh2ODJhaE0rRFZBbHlWQTRjYXU4bHdCQk02UDRZMnhxUFBqTExVSjZ3Y1cweFBvcUsrc0c0UVN3UDJmR ▶"
    1 => "laravel_session=eyJpdiI6IkMxTE9WUTU2NnltTFB5QkNhY2dFVlE9PSIsInZhbHVlIjoicXRjQVR5Sk1vYmp2bFJ0UTlBVFlkOGlLcWoxUis3TDlqOHEzK2hpVTN6MnZ6b214cWlpaklqbHR1VnVCMDltNVRIdC9iUGVXWFFlbVdDci9TeVBoak5GY2tlaHIvd2F4eStXTW9NdWZ4aWMzVjFUZDZxWGVxc3NaVUpTMDFad1giLCJtYWMiOiI5ZGJmYjA0ODNkM2ZlNjJkZjhkNDY4NjJhOGI1NDI5YjA3MzBhMDMwZGE1YzcxNTZkOGFjMTJhZWQ1MWMzMDg5In0%3D; expires=Wed, 24-Nov-2027 12:58:35 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkMxTE9WUTU2NnltTFB5QkNhY2dFVlE9PSIsInZhbHVlIjoicXRjQVR5Sk1vYmp2bFJ0UTlBVFlkOGlLcWoxUis3TDlqOHEzK2hpVTN6MnZ6b214cWlpaklqbHR1VnVCMDltNVRI ▶"
  ]
]
          session_attributes
            0 of 0   
          array:5 [▶
  "_token" => "E7pQ2uXOglPMRr1gXdQ1fGBkRtVykAQYdRQLENAF"
  "cartSessionId" => 3894
  "_previous" => array:1 [▶
    "url" => "https://www.pasargad.com/products?collection=25&type=rug"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]