Home

Search

Bag 0

Login

Contact
Collection : Pure Silk Product : Rug
  • Filters
Clear Filter
Item Fine Hand Knotted Persian pure silk Qum 1'11'' X 3'
SKU# D14253
$2331.00 $1631.70
Item Fine Hand knotted Persian Pure silk Qum rug 2' X 2'11''
SKU# D14254
$2954.00 $2067.80
Item Navy Blue Fine Hand knotted Persian Pure silk Qum 2' X 3'
SKU# D14259
$2400.00 $1680.00
Item Ivory Sino Tabriz Pure silk 2'7"x4'
SKU# D14582
$1656.00 $1159.20
Item Persian Fine Hand Pure silk Qum rug 2'8'' X 3'11''
SKU# D11951
$469.10 $328.37
Item Fine Hand knotted Persian Pure silk Qum rug 3'3'' X 4'9''
SKU# D14250
$4957.08 $3469.96
Item Double-Sided Persian Hand-knotted Silk Quchan Rug 3'4'' X 5'1''
SKU# D14268
$7615.20 $5330.64
Item Red Persian Pure silk Qum 3'3'' X 4'9''
SKU# D03954
$4851.00 $3395.70
Item Navy Persian Kashan all silk 3'4'' X 5'3''
SKU# D05512
$3877.40 $2714.18
Item Double-Sided Persian Hand-knotted ALL Silk Quchan Rug 4'2'' X 6'
SKU# D14267
$7236.00 $5065.20
Item Fine Hand knotted Pure silk Qum design 4'5'' X 6'5''
SKU# D10074
$2450.25 $1715.18
Item Double-Sided Persian Hand-knotted Silk Quchan Rug 4'6'' X 6'9''
SKU# D14252
$9890.16 $6923.11
Item Green Persian Qum Pure Silk 4'2" X 6'6"
SKU# D09276
$3647.40 $2553.18
Item Multi Color fine Hand Knotted Pure Silk Kashmir Rug 4'3'' X 5'11''
SKU# D11340
$1927.47 $1349.23
Item Fine Hand Knotted Pure silk Qum rug 4'3'' X 6'5''
SKU# D10868
$6987.50 $4891.25
Item Ivory Fine Persian Pure Silk Qum 4'3'' X 6'7''
SKU# D03046
$9199.32 $6439.52
Item Fine Hand knotted Persian Pure silk Qum rug 6'6'' X 10'1''
SKU# D14257
$15165.15 $10615.61
Item Rust Persian Sumak Silk 6'3" X 9'1"
SKU# D08079
$2514.49 $1760.14
Item Fine Hand knotted Persian Pure silk Quchan rug 7' X 10'
SKU# D14260
$14000.00 $9800.00
Item Multi Color Fine Hand knotted Pure silk Persian Qum Rug 7'11'' X 11'7''
SKU# D14261
$23612.31 $16528.62
Item Fine Hand Knotted Persian pure silk Qum 9'8"x13'
SKU# D14579
$17706.00 $12394.20
MessagesTimelineExceptionsViews6RouteQueries121Models1712MailsAuthGateSessionRequest
7.3.23PHP Version5.04sRequest Duration9MBMemory UsageGET productsRouteAuth status
    • Booting (282ms)
    • Application (4.76s)
    • 1 x Application (94.41%)
      4.76s
      1 x Booting (5.59%)
      281.96ms
      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
      121 statements were executed, 63 of which were duplicated, 58 unique3.3s
      pasargad_dc
      • select * from `subcategories`74.22ms/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` = '13' limit 134.43ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 13
        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`10.7ms/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`71.32ms/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`50.11ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php: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`34.64ms/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`27.92ms/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` = '13' and `products`.`status` = 1101ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered100
        Extranull
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 0138ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered100
        ExtraUsing filesort
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc23.77ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:312
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc18.95ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:314
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        ExtraUsing where
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc18.72ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:316
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc16.3ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:318
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc29.33ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:320
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered0.10000000149011612
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `product_colors` as `color_list_table` on `color_list_table`.`product_id` = `products`.`id` inner join `colors` on `colors`.`id` = `color_list_table`.`color_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '13' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc116ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc
        Metadata
        Bindings
        • 0. rug
        • 1. 13
        • 2. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:324
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `color_list_table` (SIMPLE)149531
        Metadata
        id1
        select_typeSIMPLE
        tablecolor_list_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows14953
        filtered100
        ExtraUsing temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.color_id
        rows1
        filtered100
        ExtraUsing where
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.color_list_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select * from `subcategories` where `subcategories`.`id` = '13' limit 11.21ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 13
        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` = 4862 and `product_sizes`.`product_id` is not null5.64msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4862
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7558 and `product_sizes`.`product_id` is not null5.54msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7558
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7559 and `product_sizes`.`product_id` is not null12.02msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7559
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3352 and `product_sizes`.`product_id` is not null12.15msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3352
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7600 and `product_sizes`.`product_id` is not null23.79msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7600
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8245 and `product_sizes`.`product_id` is not null14.36msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8245
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4578 and `product_sizes`.`product_id` is not null27.21msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4578
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5051 and `product_sizes`.`product_id` is not null23.4msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5051
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3184 and `product_sizes`.`product_id` is not null31.43msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3184
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4863 and `product_sizes`.`product_id` is not null16.22msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4863
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4944 and `product_sizes`.`product_id` is not null19.25msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4944
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4984 and `product_sizes`.`product_id` is not null23.44msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4984
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7618 and `product_sizes`.`product_id` is not null24.6msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7618
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7552 and `product_sizes`.`product_id` is not null27.32msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7552
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 6151 and `product_sizes`.`product_id` is not null23.15msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 6151
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7551 and `product_sizes`.`product_id` is not null18.91msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7551
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7598 and `product_sizes`.`product_id` is not null26.48msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7598
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7555 and `product_sizes`.`product_id` is not null6.16msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7555
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4943 and `product_sizes`.`product_id` is not null16.16msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4943
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2560 and `product_sizes`.`product_id` is not null31.07msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2560
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5097 and `product_sizes`.`product_id` is not null17.68msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5097
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2024 and `product_sizes`.`product_id` is not null22.42msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2024
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2457 and `product_sizes`.`product_id` is not null12.98msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2457
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3213 and `product_sizes`.`product_id` is not null33.05msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3213
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 3215 and `product_sizes`.`product_id` is not null14.46msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 3215
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4571 and `product_sizes`.`product_id` is not null30.44msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4571
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1428 and `product_sizes`.`product_id` is not null19.42msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1428
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1597 and `product_sizes`.`product_id` is not null27.39msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1597
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7619 and `product_sizes`.`product_id` is not null9.48msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7619
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 9173 and `product_sizes`.`product_id` is not null33.19msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 9173
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7556 and `product_sizes`.`product_id` is not null29.81msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7556
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 130 and `product_sizes`.`product_id` is not null29.43msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 130
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4198 and `product_sizes`.`product_id` is not null34.55msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4198
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 6585 and `product_sizes`.`product_id` is not null32.18msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 6585
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 2449 and `product_sizes`.`product_id` is not null13.71msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 2449
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 5098 and `product_sizes`.`product_id` is not null26.57msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 5098
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 4079 and `product_sizes`.`product_id` is not null18msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 4079
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7597 and `product_sizes`.`product_id` is not null13.17msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7597
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7560 and `product_sizes`.`product_id` is not null25.89msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7560
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 485 and `product_sizes`.`product_id` is not null25.72msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 485
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 1132 and `product_sizes`.`product_id` is not null8.33msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 1132
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7602 and `product_sizes`.`product_id` is not null32.71msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7602
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7604 and `product_sizes`.`product_id` is not null25.18msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7604
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 8247 and `product_sizes`.`product_id` is not null16.53msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 8247
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. view::frontend.products.index:362
        • 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139
      • - EXPLAIN # 1: `product_sizes` (SIMPLE)92821
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9282
        filtered10
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc37.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.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc30.06ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc34.05ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc25.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.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc42.32ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc9.8ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc12.06ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc11.46ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.77ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc14.02ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc18.64ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc50.54ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc28.36ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc10.02ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc14.81ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.48ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc25.93ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:106
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc35.53ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:107
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc26.48ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc16.79ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc21.54ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc15.24ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc16.32ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc22.4ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc24.99ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc39.31ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc23.31ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc18.02ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`28.44ms/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` = '4670_cart_items' limit 150.81ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 4670_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` = '4670_cart_items' limit 115.36ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 4670_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` asc80.8ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:87
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc25.25ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc81.62ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:89
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc48.53ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:90
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc31.73ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:91
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc21.6ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:92
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc20.58ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:93
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc11.14ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:96
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc19.99ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc12.35ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:98
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc15.59ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:99
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc14.79ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc31.41ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:101
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc23.28ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:102
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc30.05ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:104
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc17.24ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:105
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc52.29ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:106
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc41.49ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:107
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc26.83ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:108
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc15.25ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:109
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc30.61ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc
        Metadata
        Bindings
        • 0. accessories
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:110
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc19.92ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:112
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc21.95ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:113
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc17.62ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:114
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc21.94ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:115
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc14.3ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:116
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc20.96ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:117
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc30.39ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc
        Metadata
        Bindings
        • 0. furniture
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:118
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67741
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6774
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`31.34ms/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` = '4670_cart_items' limit 115.2ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 4670_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
      44
      App\Models\Product\Product
      1109
      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
          u3T8rYOwIXDiETPpqziZ8WNbbcxFzgjBQUibmzsh
          cartSessionId
          4670
          _previous
          array:1 [ "url" => "https://www.pasargad.com/products?collection=13&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" => "13"
  "type" => "rug"
]
          request_request
            0 of 0   
          array:2 [▶
  "collection" => "13"
  "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.117"
  "DOCUMENT_ROOT" => "/var/www/html/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/public"
  "SERVER_ADMIN" => "root@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/public/index.php"
  "REMOTE_PORT" => "42947"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "collection=13&type=rug"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "collection=13&type=rug"
  "REQUEST_URI" => "/products?collection=13&type=rug"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755214755.5033
  "REQUEST_TIME" => 1755214755
]
          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 => "Thu, 14 Aug 2025 23:39:16 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlrdFpZZkhZbXArRGN5RHNUTXVhVnc9PSIsInZhbHVlIjoiZjluUTFBSW1DMUJaMGpiVUUwYWp6Y1ZjZ3owTm43ZlNjMk9ZR3FxQ0xrVnZybVg4dklQcGo4K25NTDVOeE5uZFNVek44YldrYUFVUWVlR2V0OVlReUNVdTJ3cURHSXBhb0FHbm13K3YyWTlaZWZ6Mm5rbElmMDJMUDJBbVVCNjIiLCJtYWMiOiIxMzgzODhjMjg0YjIzYjU3NTUyMmIzZjdjNWZhZGY4NTc4MjU2YjhmMWJiYTEzZTMyNzM2OTE2NjZmYmU4OWVmIn0%3D; expires=Fri, 26-Nov-2027 07:39:20 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6InlrdFpZZkhZbXArRGN5RHNUTXVhVnc9PSIsInZhbHVlIjoiZjluUTFBSW1DMUJaMGpiVUUwYWp6Y1ZjZ3owTm43ZlNjMk9ZR3FxQ0xrVnZybVg4dklQcGo4K25NTDVOeE5uZFNVek44Y ▶"
    1 => "laravel_session=eyJpdiI6IlIrRjdzYjhnRUNRdXdKT0dGaFlsamc9PSIsInZhbHVlIjoiVTE0Vm41bVN4QXBRbkRjbjVGTkM2bWtHcXRqcTFZcmR0eDJBT3pKeGFxWVBoL0hPQ1RSRVNFZytKanNBaWZQMkR2TlMzUGN5dk9XRW1leDB0Tk40N2tLUWRmWlZTRWNkTWJDYVdVSWU3RVdpUTc1Y3oyTVdXQy94UVIwa2xQeE0iLCJtYWMiOiI1MDQxMTY4MjNhZjcxNTBmMTc4YWNkMDljMjUwOTRlYzVlMzFjNjhlZjkwNzNiMjBmYjZiZTI0MzNjYTVhOWJjIn0%3D; expires=Fri, 26-Nov-2027 07:39:20 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6IlIrRjdzYjhnRUNRdXdKT0dGaFlsamc9PSIsInZhbHVlIjoiVTE0Vm41bVN4QXBRbkRjbjVGTkM2bWtHcXRqcTFZcmR0eDJBT3pKeGFxWVBoL0hPQ1RSRVNFZytKanNBaWZQMkR2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlrdFpZZkhZbXArRGN5RHNUTXVhVnc9PSIsInZhbHVlIjoiZjluUTFBSW1DMUJaMGpiVUUwYWp6Y1ZjZ3owTm43ZlNjMk9ZR3FxQ0xrVnZybVg4dklQcGo4K25NTDVOeE5uZFNVek44YldrYUFVUWVlR2V0OVlReUNVdTJ3cURHSXBhb0FHbm13K3YyWTlaZWZ6Mm5rbElmMDJMUDJBbVVCNjIiLCJtYWMiOiIxMzgzODhjMjg0YjIzYjU3NTUyMmIzZjdjNWZhZGY4NTc4MjU2YjhmMWJiYTEzZTMyNzM2OTE2NjZmYmU4OWVmIn0%3D; expires=Fri, 26-Nov-2027 07:39:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InlrdFpZZkhZbXArRGN5RHNUTXVhVnc9PSIsInZhbHVlIjoiZjluUTFBSW1DMUJaMGpiVUUwYWp6Y1ZjZ3owTm43ZlNjMk9ZR3FxQ0xrVnZybVg4dklQcGo4K25NTDVOeE5uZFNVek44Y ▶"
    1 => "laravel_session=eyJpdiI6IlIrRjdzYjhnRUNRdXdKT0dGaFlsamc9PSIsInZhbHVlIjoiVTE0Vm41bVN4QXBRbkRjbjVGTkM2bWtHcXRqcTFZcmR0eDJBT3pKeGFxWVBoL0hPQ1RSRVNFZytKanNBaWZQMkR2TlMzUGN5dk9XRW1leDB0Tk40N2tLUWRmWlZTRWNkTWJDYVdVSWU3RVdpUTc1Y3oyTVdXQy94UVIwa2xQeE0iLCJtYWMiOiI1MDQxMTY4MjNhZjcxNTBmMTc4YWNkMDljMjUwOTRlYzVlMzFjNjhlZjkwNzNiMjBmYjZiZTI0MzNjYTVhOWJjIn0%3D; expires=Fri, 26-Nov-2027 07:39:20 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlIrRjdzYjhnRUNRdXdKT0dGaFlsamc9PSIsInZhbHVlIjoiVTE0Vm41bVN4QXBRbkRjbjVGTkM2bWtHcXRqcTFZcmR0eDJBT3pKeGFxWVBoL0hPQ1RSRVNFZytKanNBaWZQMkR2 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:5 [▶
  "_token" => "u3T8rYOwIXDiETPpqziZ8WNbbcxFzgjBQUibmzsh"
  "cartSessionId" => 4670
  "_previous" => array:1 [▶
    "url" => "https://www.pasargad.com/products?collection=13&type=rug"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]