New & Antique Decorative Rugs Since 1904
| 1 x Application (98.59%) | 1.43s |
| 1 x Booting (1.4%) | 20.27ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
Rust Persian Tabriz 10' X 15'
Salmon Color Vintage Persian Mahal 10'8'' X 13'8''
select * from `subcategories`8.56ms/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `subcategories` (SIMPLE)1041| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 104 |
| filtered | 100 |
| Extra | null |
select * from `subcategories` where `subcategories`.`id` = '8' limit 11.06ms/app/Repositories/BaseRepository.php:33pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | const |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | const |
| rows | 1 |
| filtered | 100 |
| Extra | null |
select * from `categories`1.14ms/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `categories` (SIMPLE)341| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 34 |
| filtered | 100 |
| Extra | null |
select * from `styles`1.68ms/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `styles` (SIMPLE)2101| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 210 |
| filtered | 100 |
| Extra | null |
select * from `materials`1.19ms/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `materials` (SIMPLE)531| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 53 |
| filtered | 100 |
| Extra | null |
select * from `weaves`960μs/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `weaves` (SIMPLE)161| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 16 |
| filtered | 100 |
| Extra | null |
select * from `colors`1.28ms/app/Repositories/BaseRepository.php:15pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `colors` (SIMPLE)1031| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 103 |
| filtered | 100 |
| Extra | null |
select count(*) as aggregate from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 160.6ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `order_table` (SIMPLE)92801| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | order_table |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9280 |
| filtered | 100 |
| Extra | null |
- EXPLAIN # 1: `products` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.order_table.product_id |
| rows | 1 |
| filtered | 5 |
| Extra | Using where |
select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 095.85ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `order_table` (SIMPLE)92801| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | order_table |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9280 |
| filtered | 100 |
| Extra | Using filesort |
- EXPLAIN # 1: `products` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.order_table.product_id |
| rows | 1 |
| filtered | 5 |
| Extra | Using where |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc15.26ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 0.10000000149011612 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc10.76ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 0.10000000149011612 |
| Extra | Using where |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc12.03ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 0.10000000149011612 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc14.61ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 0.10000000149011612 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc17.8ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 0.10000000149011612 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `colors`.* from `products` inner join `product_colors` as `color_list_table` on `color_list_table`.`product_id` = `products`.`id` inner join `colors` on `colors`.`id` = `color_list_table`.`color_id` where `products`.`type` = 'rug' and `products`.`subcategory_id` = '8' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc53.11ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `color_list_table` (SIMPLE)149511| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | color_list_table |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 14951 |
| filtered | 100 |
| Extra | Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.color_list_table.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
- EXPLAIN # 1: `products` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.color_list_table.product_id |
| rows | 1 |
| filtered | 5 |
| Extra | Using where |
select * from `subcategories` where `subcategories`.`id` = '8' limit 11ms/app/Repositories/BaseRepository.php:33pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | const |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | const |
| rows | 1 |
| filtered | 100 |
| Extra | null |
select * from `product_sizes` where `product_sizes`.`product_id` = 2368 and `product_sizes`.`product_id` is not null5.65msview::frontend.products.index:362pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)92801| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | product_sizes |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9280 |
| filtered | 10 |
| Extra | Using where |
select * from `product_sizes` where `product_sizes`.`product_id` = 4193 and `product_sizes`.`product_id` is not null5.35msview::frontend.products.index:362pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)92801| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | product_sizes |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9280 |
| filtered | 10 |
| Extra | Using where |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc17.22ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc26.47ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc26.73ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc27.22ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc22.76ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.53ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc17.19ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'lighting' group by `products`.`category_id` order by `categories`.`category` asc13.82ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.93ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.34ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc16ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.59ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.93ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc10.01ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' group by `products`.`category_id` order by `categories`.`category` asc11.47ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc18.18ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.4ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.4ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc17.09ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.65ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc10.81ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'furniture' group by `products`.`category_id` order by `categories`.`category` asc9.89ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc10.84ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.88ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc10ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc9.66ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc10.41ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc11.52ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
select * from `settings`1.1ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `settings` (SIMPLE)91| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | settings |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9 |
| filtered | 100 |
| Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4034_cart_items' limit 11.09ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | null |
| partitions | null |
| type | null |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | null |
| filtered | null |
| Extra | no matching row in const table |
select * from `cart_storage` where `cart_storage`.`id` = '4034_cart_items' limit 11.12ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | null |
| partitions | null |
| type | null |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | null |
| filtered | null |
| Extra | no matching row in const table |
select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc17.81ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc20.81ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc16.92ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc14.06ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc13.15ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.63ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc17.27ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using 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.32ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.27ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc23.48ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc20.96ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc27.84ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc19.95ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc23.67ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using 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` asc19.32ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc25.66ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc19.59ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc17.02ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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.14ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc12.33ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc10.95ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using 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` asc14.17ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `categories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | categories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.category_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc15.87ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `subcategories` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | subcategories |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.subcategory_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc13.45ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `styles` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | styles |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.style_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc15.1ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `materials` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | materials |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.material_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc9.29ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `weaves` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | weaves |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.weave_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using 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` asc8.99ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
- EXPLAIN # 1: `colors` (SIMPLE)11| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | colors |
| partitions | null |
| type | eq_ref |
| possible_keys | PRIMARY |
| key | PRIMARY |
| key_len | 4 |
| ref | pasargad_dc.products.color_id |
| rows | 1 |
| filtered | 100 |
| Extra | Using where |
select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc9.34ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)67721| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | products |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 6772 |
| filtered | 10 |
| Extra | Using where; Using temporary; Using filesort |
select * from `settings`1.16ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `settings` (SIMPLE)91| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | settings |
| partitions | null |
| type | ALL |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | 9 |
| filtered | 100 |
| Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4034_cart_items' limit 11.15ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Metadata | |
|---|---|
| id | 1 |
| select_type | SIMPLE |
| table | null |
| partitions | null |
| type | null |
| possible_keys | null |
| key | null |
| key_len | null |
| ref | null |
| rows | null |
| filtered | null |
| Extra | no matching row in const table |
200
0 of 0array:2 [▶ "collection" => "8" "type" => "rug" ]
0 of 0array:2 [▶ "collection" => "8" "type" => "rug" ]
0 of 0array: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" ] ]
0 of 0array: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" => "13173" "REDIRECT_URL" => "/products" "REDIRECT_QUERY_STRING" => "collection=8&type=rug" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "collection=8&type=rug" "REQUEST_URI" => "/products?collection=8&type=rug" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755120935.5617 "REQUEST_TIME" => 1755120935 ]
[]
0 of 0array: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 21:35:35 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjU0WU8veFJmcFdDaVZlZUMxNjY4cUE9PSIsInZhbHVlIjoieDRUQmFJRTd2UXA4a3NaUk5JTFYrcjNWbzR5cnpIMm9NN1g5VXhpQnZMM2tpdU1JdG5CQW5BWnFwY1pHRzRCdzJES0FhRnhPczJzS1FwQkw3WHk2RktQZG9FL2hWTWhPZU1PM1MxUjJpMGZNYVQ2eTYxSUg3RWdFcTdiclhiUUIiLCJtYWMiOiI3M2MxNDY5Yjc0ZTg0NTYyMGYzNGQ1ZDdlN2IzNzExMjI0YjUyMDY0MjM3MGRjZWQxNGNjMGU4ZTQyNDhlNDEyIn0%3D; expires=Thu, 25-Nov-2027 05:35:37 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6IjU0WU8veFJmcFdDaVZlZUMxNjY4cUE9PSIsInZhbHVlIjoieDRUQmFJRTd2UXA4a3NaUk5JTFYrcjNWbzR5cnpIMm9NN1g5VXhpQnZMM2tpdU1JdG5CQW5BWnFwY1pHRzRCdzJES0FhR ▶" 1 => "laravel_session=eyJpdiI6IklUaGhDUUxFY2lLb3V2UXFRb2xvZGc9PSIsInZhbHVlIjoibzdqb3VtV1lJNlZrNXlPRnhBU2lvcFJtaHpWSjNncm1XREY4VWpQVVBWcExMbTVXVEFvT3NQcEpLelphUXlCK0U0N3dKdVVzRmp2RWVETnNwYytLRTMyeVFScmdiSlNFWmFLbFVoay9ydFR3bUQvRzNuMExXOUZSc0VNN2NRTksiLCJtYWMiOiJkYWZhYTJkNDA1NjFhNDU3YzU1MGY2OWEwMzJkZmM3MWQyMTkwODdkOTI4NjdiMTQ0NjdhMGJjNTZiMzE1NGM3In0%3D; expires=Thu, 25-Nov-2027 05:35:37 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6IklUaGhDUUxFY2lLb3V2UXFRb2xvZGc9PSIsInZhbHVlIjoibzdqb3VtV1lJNlZrNXlPRnhBU2lvcFJtaHpWSjNncm1XREY4VWpQVVBWcExMbTVXVEFvT3NQcEpLelphUXlCK0U0 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjU0WU8veFJmcFdDaVZlZUMxNjY4cUE9PSIsInZhbHVlIjoieDRUQmFJRTd2UXA4a3NaUk5JTFYrcjNWbzR5cnpIMm9NN1g5VXhpQnZMM2tpdU1JdG5CQW5BWnFwY1pHRzRCdzJES0FhRnhPczJzS1FwQkw3WHk2RktQZG9FL2hWTWhPZU1PM1MxUjJpMGZNYVQ2eTYxSUg3RWdFcTdiclhiUUIiLCJtYWMiOiI3M2MxNDY5Yjc0ZTg0NTYyMGYzNGQ1ZDdlN2IzNzExMjI0YjUyMDY0MjM3MGRjZWQxNGNjMGU4ZTQyNDhlNDEyIn0%3D; expires=Thu, 25-Nov-2027 05:35:37 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjU0WU8veFJmcFdDaVZlZUMxNjY4cUE9PSIsInZhbHVlIjoieDRUQmFJRTd2UXA4a3NaUk5JTFYrcjNWbzR5cnpIMm9NN1g5VXhpQnZMM2tpdU1JdG5CQW5BWnFwY1pHRzRCdzJES0FhR ▶" 1 => "laravel_session=eyJpdiI6IklUaGhDUUxFY2lLb3V2UXFRb2xvZGc9PSIsInZhbHVlIjoibzdqb3VtV1lJNlZrNXlPRnhBU2lvcFJtaHpWSjNncm1XREY4VWpQVVBWcExMbTVXVEFvT3NQcEpLelphUXlCK0U0N3dKdVVzRmp2RWVETnNwYytLRTMyeVFScmdiSlNFWmFLbFVoay9ydFR3bUQvRzNuMExXOUZSc0VNN2NRTksiLCJtYWMiOiJkYWZhYTJkNDA1NjFhNDU3YzU1MGY2OWEwMzJkZmM3MWQyMTkwODdkOTI4NjdiMTQ0NjdhMGJjNTZiMzE1NGM3In0%3D; expires=Thu, 25-Nov-2027 05:35:37 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IklUaGhDUUxFY2lLb3V2UXFRb2xvZGc9PSIsInZhbHVlIjoibzdqb3VtV1lJNlZrNXlPRnhBU2lvcFJtaHpWSjNncm1XREY4VWpQVVBWcExMbTVXVEFvT3NQcEpLelphUXlCK0U0 ▶" ] ]
0 of 0array:5 [▶ "_token" => "tgWCTZM7OomFr1Kb2h1ijAmW8NOTx5YdpF1PZWyw" "cartSessionId" => 4034 "_previous" => array:1 [▶ "url" => "https://www.pasargad.com/products?collection=8&type=rug" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]