Home

Search

Bag 0

Login

Contact
Collection : Gloria
  • Filters
Clear Filter
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 33 A
$146.00
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 24 A
$146.00
Item Hand-Made Gloria Collection Pillows 16''
SKU# GL 25
$146.00
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 23 A
$146.00
Item Hand-Made Gloria Collection Pillows 16''
SKU# GL 22 A
$146.00
Item Hand-Made Gloria Collection Pillows 16''
SKU# GL 36
$146.00
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 35 A
$146.00
Item Hand-Made Gloria Collection Pillows 20"
SKU# GL 14 M
$195.00
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 15 A
$195.00
Item Hand-Made Gloria Collection Pillows 18"
SKU# GL 15 M
$185.00
Item Hand-Made Gloria Collection Pillows 20''
SKU# GL 16 A
$195.00
Item Hand-Made Gloria Collection Pillows 18''
SKU# GL 17 A
$190.00
Item Hand-Made Gloria Collection Pillows 20"
SKU# GL 18 A
$195.00
Item Hand-Made Gloria Collection Pillows 16''
SKU# GL 19 A
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16''
SKU# Gl 27 A
$145.00
Item Pasargad Handmade Gloria Collection Pillows 16"
SKU# Gl 28 A
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16"
SKU# Gl 29 A
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16"
SKU# GL 30 A
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16"
SKU# GL 31
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16"
SKU# GL 32
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 16"
SKU# GL 34
$145.00
Item Pasargad Hand-Made Gloria Collection Pillows 12"X 20"
SKU# GL 37A
$165.00
Item Pasargad Handmade Gloria Collection Pillows 10"x18"
SKU# GL 29
$145.00
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 10
$156.83
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 12
$157.91
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 1
$156.83
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 2
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 3
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 4
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 5
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 6
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# Gl 7
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 8
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 9
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# GL 11
$162.92
Item Hand-Made Gloria Collection Pillows 16"
SKU# Gl 13
$162.92
MessagesTimelineExceptionsViews6RouteQueries114Models1696MailsAuthGateSessionRequest
7.3.23PHP Version1.93sRequest Duration9MBMemory UsageGET productsRouteAuth status
    • Booting (22.98ms)
    • Application (1.91s)
    • 1 x Application (98.8%)
      1.91s
      1 x Booting (1.19%)
      22.98ms
      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
      114 statements were executed, 63 of which were duplicated, 51 unique1.62s
      pasargad_dc
      • select * from `subcategories`7.15ms/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` = '131' limit 11.18ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 131
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Repositories/BaseRepository.php:33
        • 17. /app/Http/Controllers/Frontend/Product/ProductController.php:93
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        filtered100
        Extranull
      • select * from `categories`1.23ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:96
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `categories` (SIMPLE)341
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows34
        filtered100
        Extranull
      • select * from `styles`1.67ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:97
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `styles` (SIMPLE)2101
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows210
        filtered100
        Extranull
      • select * from `materials`1.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:98
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `materials` (SIMPLE)531
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows53
        filtered100
        Extranull
      • select * from `weaves`1.26ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:99
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `weaves` (SIMPLE)161
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows16
        filtered100
        Extranull
      • select * from `colors`1.33ms/app/Repositories/BaseRepository.php:15pasargad_dc
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        • The SELECT statement has no WHERE clause and could examine many more rows than intended
        Backtrace
        • 14. /app/Repositories/BaseRepository.php:15
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:100
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
      • - EXPLAIN # 1: `colors` (SIMPLE)1031
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows103
        filtered100
        Extranull
      • select count(*) as aggregate from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '131' and `products`.`status` = 160.34ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92811
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered100
        Extranull
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 089.63ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 15. /app/Http/Controllers/Frontend/Product/ProductController.php:308
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `order_table` (SIMPLE)92811
        Metadata
        id1
        select_typeSIMPLE
        tableorder_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered100
        ExtraUsing filesort
      • - EXPLAIN # 1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.order_table.product_id
        rows1
        filtered5
        ExtraUsing where
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc15.29ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:312
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.72ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:314
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered1.0000001192092896
        ExtraUsing where
      • - EXPLAIN # 1: `subcategories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablesubcategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.subcategory_id
        rows1
        filtered100
        ExtraUsing where
      • select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc15.97ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:316
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc15.03ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:318
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc15.17ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:320
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered1.0000001192092896
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `product_colors` as `color_list_table` on `color_list_table`.`product_id` = `products`.`id` inner join `colors` on `colors`.`id` = `color_list_table`.`color_id` where `products`.`subcategory_id` = '131' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc84.95ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc
        Metadata
        Bindings
        • 0. 131
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/Frontend/Product/ProductController.php:324
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691
      • - EXPLAIN # 1: `color_list_table` (SIMPLE)149521
        Metadata
        id1
        select_typeSIMPLE
        tablecolor_list_table
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows14952
        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` = '131' limit 11.57ms/app/Repositories/BaseRepository.php:33pasargad_dc
        Metadata
        Bindings
        • 0. 131
        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` = 7142 and `product_sizes`.`product_id` is not null5.56msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7142
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7143 and `product_sizes`.`product_id` is not null5.78msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7143
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7144 and `product_sizes`.`product_id` is not null5.62msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7144
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7145 and `product_sizes`.`product_id` is not null5.62msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7145
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7146 and `product_sizes`.`product_id` is not null5.49msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7146
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7147 and `product_sizes`.`product_id` is not null5.36msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7147
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7148 and `product_sizes`.`product_id` is not null5.23msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7148
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7149 and `product_sizes`.`product_id` is not null6.85msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7149
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7150 and `product_sizes`.`product_id` is not null8.98msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7150
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7151 and `product_sizes`.`product_id` is not null6.96msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7151
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7152 and `product_sizes`.`product_id` is not null9.03msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7152
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7153 and `product_sizes`.`product_id` is not null5.48msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7153
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7154 and `product_sizes`.`product_id` is not null10.17msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7154
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7155 and `product_sizes`.`product_id` is not null8.48msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7155
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7164 and `product_sizes`.`product_id` is not null5.4msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7164
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7168 and `product_sizes`.`product_id` is not null7.61msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7168
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7171 and `product_sizes`.`product_id` is not null9.42msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7171
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7173 and `product_sizes`.`product_id` is not null5.67msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7173
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7174 and `product_sizes`.`product_id` is not null7.68msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7174
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7175 and `product_sizes`.`product_id` is not null10.4msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7175
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7179 and `product_sizes`.`product_id` is not null5.3msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7179
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7182 and `product_sizes`.`product_id` is not null6.87msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7182
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7375 and `product_sizes`.`product_id` is not null9.11msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7375
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7376 and `product_sizes`.`product_id` is not null6.72msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7376
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7066 and `product_sizes`.`product_id` is not null7.31msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7066
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7068 and `product_sizes`.`product_id` is not null8.91msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7068
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7056 and `product_sizes`.`product_id` is not null5.61msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7056
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7057 and `product_sizes`.`product_id` is not null8.67msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7057
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7058 and `product_sizes`.`product_id` is not null9.17msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7058
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7059 and `product_sizes`.`product_id` is not null6.53msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7059
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7061 and `product_sizes`.`product_id` is not null6.95msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7061
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7062 and `product_sizes`.`product_id` is not null7.3msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7062
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7063 and `product_sizes`.`product_id` is not null7.35msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7063
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7064 and `product_sizes`.`product_id` is not null7.03msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7064
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7065 and `product_sizes`.`product_id` is not null7.61msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7065
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7067 and `product_sizes`.`product_id` is not null6.97msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7067
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        filtered10
        ExtraUsing where
      • select * from `product_sizes` where `product_sizes`.`product_id` = 7069 and `product_sizes`.`product_id` is not null6.97msview::frontend.products.index:362pasargad_dc
        Metadata
        Bindings
        • 0. 7069
        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)92811
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_sizes
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows9281
        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` asc25.28ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc33.19ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc19.59ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc22.33ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc19.5ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc13.3ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc11.42ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc14.7ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc13.94ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc15.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.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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc9.95ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc9.91ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:100
        • 15. view::frontend.includes.header:3
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc9.5ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc14.69ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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.79ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc19.5ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc17.15ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc18.87ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc15.43ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc25.87ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc10.39ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc10.32ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc13.65ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc15.06ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc13.93ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `materials` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablematerials
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.material_id
        rows1
        filtered100
        ExtraUsing where
      • select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc15.4ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc15.66ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc14.77ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.19ms/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` = '538_cart_items' limit 11.17ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 538_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` = '538_cart_items' limit 11.11ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 538_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` asc26.81ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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.31ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc
        Metadata
        Bindings
        • 0. rug
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:88
        • 15. view::frontend.includes.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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc24.48ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc21.76ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc18.2ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc12.94ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc11.67ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc9.97ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc13.57ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc
        Metadata
        Bindings
        • 0. lighting
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Helpers/Frontend/MenuHelper.php:97
        • 15. view::frontend.includes.footer:25
        • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • - EXPLAIN # 1: `products` (SIMPLE)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc11.65ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `styles` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablestyles
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.style_id
        rows1
        filtered100
        ExtraUsing where
      • select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc13.68ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc15.45ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `weaves` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableweaves
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.weave_id
        rows1
        filtered100
        ExtraUsing where
      • select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc13.38ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc28.94ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc40.1ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `categories` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.category_id
        rows1
        filtered100
        ExtraUsing where
      • select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc39.52ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc32.42ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc16.36ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc18.23ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc10.03ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • - EXPLAIN # 1: `colors` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablecolors
        partitionsnull
        typeeq_ref
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refpasargad_dc.products.color_id
        rows1
        filtered100
        ExtraUsing where
      • select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc15.21ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc10.62ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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.14ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc35.82ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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.83ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc19.92ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc18.39ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        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` asc21.08ms/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)67731
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        partitionsnull
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows6773
        filtered10
        ExtraUsing where; Using temporary; Using filesort
      • select * from `settings`1.24ms/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` = '538_cart_items' limit 11.13ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc
        Metadata
        Bindings
        • 0. 538_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
      37
      App\Models\Product\Product
      1100
      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
          OZJ3ULoylEGkluJIWTM1yiIFjaNWQvZw0Co7pFVi
          cartSessionId
          538
          _previous
          array:1 [ "url" => "https://www.pasargad.com/products?collection=131" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /products
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
            0 of 0   
          array:1 [▶
  "collection" => "131"
]
          request_request
            0 of 0   
          array:1 [▶
  "collection" => "131"
]
          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.24"
  "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" => "58579"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "collection=131"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "collection=131"
  "REQUEST_URI" => "/products?collection=131"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755129587.3878
  "REQUEST_TIME" => 1755129587
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 23:59:47 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNNS3FaZjIwVEg5Zmd0Yk1HcHJRbVE9PSIsInZhbHVlIjoiRmNlQUIzcHZZZ3ZkUUd3QmxTY1FwOVJpN1dwakpzRm80SmdZdk04VVd2QUJ3RTF1Z2dVbmFZQ1RDcE40dmZYeFZ6US8wSVBTVDZwVWRnMHovQ2N1UEZDQmYrek9TTysrNDJRMTdTaFdOdUN4LzRUYlpZODFCZk45RmJzeFVVY3IiLCJtYWMiOiI1ZTlmZDUxZTQ4ZDRiNTM5NjM4ODQ4OGNkMzU0YjIxNjVjNmI5OTZjMTI0Mjg5MWJlNmJhOTNmMjdjOWNmNDFlIn0%3D; expires=Thu, 25-Nov-2027 07:59:49 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6InNNS3FaZjIwVEg5Zmd0Yk1HcHJRbVE9PSIsInZhbHVlIjoiRmNlQUIzcHZZZ3ZkUUd3QmxTY1FwOVJpN1dwakpzRm80SmdZdk04VVd2QUJ3RTF1Z2dVbmFZQ1RDcE40dmZYeFZ6US8wS ▶"
    1 => "laravel_session=eyJpdiI6InMvYlZvUmdqZXBBTityMGlIdGMrY1E9PSIsInZhbHVlIjoiSUlrWHFWTU03bGlTRTkvMVZETDJxT1hNWTh0d1l5Y2JDdnphWUJVZVAzUnY2ajdxVVpjTm1FUVpPUWRBTEtWZzVidzcwNnZYdTU0VktNL2FtMVJXOWMzeGtJQUhlSXVndnQ3ZXM2b012WFh6N0NHV1ZGaHBNaGRjT0FsV3l1SnYiLCJtYWMiOiJiZjY0ZmQ2YWM1OTk0NTY5MTdiYjIyZThlNjg3MGNjOWMxMTQwNzJlZDZiZmRhMDkwZjhmNzhmNzI5MDQzZjBmIn0%3D; expires=Thu, 25-Nov-2027 07:59:49 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6InMvYlZvUmdqZXBBTityMGlIdGMrY1E9PSIsInZhbHVlIjoiSUlrWHFWTU03bGlTRTkvMVZETDJxT1hNWTh0d1l5Y2JDdnphWUJVZVAzUnY2ajdxVVpjTm1FUVpPUWRBTEtWZzVi ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNNS3FaZjIwVEg5Zmd0Yk1HcHJRbVE9PSIsInZhbHVlIjoiRmNlQUIzcHZZZ3ZkUUd3QmxTY1FwOVJpN1dwakpzRm80SmdZdk04VVd2QUJ3RTF1Z2dVbmFZQ1RDcE40dmZYeFZ6US8wSVBTVDZwVWRnMHovQ2N1UEZDQmYrek9TTysrNDJRMTdTaFdOdUN4LzRUYlpZODFCZk45RmJzeFVVY3IiLCJtYWMiOiI1ZTlmZDUxZTQ4ZDRiNTM5NjM4ODQ4OGNkMzU0YjIxNjVjNmI5OTZjMTI0Mjg5MWJlNmJhOTNmMjdjOWNmNDFlIn0%3D; expires=Thu, 25-Nov-2027 07:59:49 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InNNS3FaZjIwVEg5Zmd0Yk1HcHJRbVE9PSIsInZhbHVlIjoiRmNlQUIzcHZZZ3ZkUUd3QmxTY1FwOVJpN1dwakpzRm80SmdZdk04VVd2QUJ3RTF1Z2dVbmFZQ1RDcE40dmZYeFZ6US8wS ▶"
    1 => "laravel_session=eyJpdiI6InMvYlZvUmdqZXBBTityMGlIdGMrY1E9PSIsInZhbHVlIjoiSUlrWHFWTU03bGlTRTkvMVZETDJxT1hNWTh0d1l5Y2JDdnphWUJVZVAzUnY2ajdxVVpjTm1FUVpPUWRBTEtWZzVidzcwNnZYdTU0VktNL2FtMVJXOWMzeGtJQUhlSXVndnQ3ZXM2b012WFh6N0NHV1ZGaHBNaGRjT0FsV3l1SnYiLCJtYWMiOiJiZjY0ZmQ2YWM1OTk0NTY5MTdiYjIyZThlNjg3MGNjOWMxMTQwNzJlZDZiZmRhMDkwZjhmNzhmNzI5MDQzZjBmIn0%3D; expires=Thu, 25-Nov-2027 07:59:49 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InMvYlZvUmdqZXBBTityMGlIdGMrY1E9PSIsInZhbHVlIjoiSUlrWHFWTU03bGlTRTkvMVZETDJxT1hNWTh0d1l5Y2JDdnphWUJVZVAzUnY2ajdxVVpjTm1FUVpPUWRBTEtWZzVi ▶"
  ]
]
          session_attributes
            0 of 0   
          array:5 [▶
  "_token" => "OZJ3ULoylEGkluJIWTM1yiIFjaNWQvZw0Co7pFVi"
  "cartSessionId" => 538
  "_previous" => array:1 [▶
    "url" => "https://www.pasargad.com/products?collection=131"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]