New & Antique Decorative Rugs Since 1904
1 x Application (99.21%) | 2.43s |
1 x Booting (0.78%) | 19.08ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
select count(*) as aggregate from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`status` = 1 and `is_sale` = 1
64.96ms/app/Http/Controllers/Frontend/Product/ProductController.php:551pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `order_table` (SIMPLE)
92801Metadata | |
---|---|
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)
11Metadata | |
---|---|
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`.`status` = 1 and `is_sale` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 7038
92.7ms/app/Http/Controllers/Frontend/Product/ProductController.php:551pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `order_table` (SIMPLE)
92801Metadata | |
---|---|
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)
11Metadata | |
---|---|
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' group by `products`.`category_id` order by `categories`.`category` asc
30.21ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
24.7ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
21.65ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
23.44ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
22.95ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
14.17ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
19.02ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
10.31ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.36ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.57ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
13.76ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
28.09ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
14.08ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
14.94ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
11.36ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.36ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
12.12ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.43ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.24ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.59ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.9ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
9.92ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.54ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
15.59ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.87ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.08ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.51ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.04ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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.22ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `settings` (SIMPLE)
91Metadata | |
---|---|
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` = '4724_cart_items' limit 1
1.51ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4724_cart_items' limit 1
1.3ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `product_sizes` where `product_sizes`.`product_id` = 4081 and `product_sizes`.`product_id` is not null
5.58msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4051 and `product_sizes`.`product_id` is not null
7.88msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1508 and `product_sizes`.`product_id` is not null
9.2msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3818 and `product_sizes`.`product_id` is not null
23.24msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3814 and `product_sizes`.`product_id` is not null
6.52msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1663 and `product_sizes`.`product_id` is not null
6.36msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 701 and `product_sizes`.`product_id` is not null
5.56msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1691 and `product_sizes`.`product_id` is not null
5.46msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 965 and `product_sizes`.`product_id` is not null
5.64msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3832 and `product_sizes`.`product_id` is not null
5.43msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4272 and `product_sizes`.`product_id` is not null
9.44msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1030 and `product_sizes`.`product_id` is not null
9.4msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 7930 and `product_sizes`.`product_id` is not null
7.69msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 577 and `product_sizes`.`product_id` is not null
9.59msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 910 and `product_sizes`.`product_id` is not null
9.4msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1540 and `product_sizes`.`product_id` is not null
5.74msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2028 and `product_sizes`.`product_id` is not null
9.38msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1118 and `product_sizes`.`product_id` is not null
6.67msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 7972 and `product_sizes`.`product_id` is not null
9.24msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2422 and `product_sizes`.`product_id` is not null
6.89msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3824 and `product_sizes`.`product_id` is not null
9.25msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1031 and `product_sizes`.`product_id` is not null
5.63msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1587 and `product_sizes`.`product_id` is not null
5.46msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3822 and `product_sizes`.`product_id` is not null
5.46msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2656 and `product_sizes`.`product_id` is not null
6.15msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4118 and `product_sizes`.`product_id` is not null
9.33msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4275 and `product_sizes`.`product_id` is not null
5.57msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4273 and `product_sizes`.`product_id` is not null
6.99msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 6013 and `product_sizes`.`product_id` is not null
5.61msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3003 and `product_sizes`.`product_id` is not null
13.38msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4295 and `product_sizes`.`product_id` is not null
6.81msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4402 and `product_sizes`.`product_id` is not null
9.19msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 6063 and `product_sizes`.`product_id` is not null
5.73msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1689 and `product_sizes`.`product_id` is not null
7.04msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1832 and `product_sizes`.`product_id` is not null
9.15msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1994 and `product_sizes`.`product_id` is not null
7.19msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 576 and `product_sizes`.`product_id` is not null
9.28msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3843 and `product_sizes`.`product_id` is not null
7.79msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2176 and `product_sizes`.`product_id` is not null
9.3msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4282 and `product_sizes`.`product_id` is not null
5.72msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4362 and `product_sizes`.`product_id` is not null
9.19msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4134 and `product_sizes`.`product_id` is not null
5.55msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3341 and `product_sizes`.`product_id` is not null
5.99msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1815 and `product_sizes`.`product_id` is not null
9.44msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4117 and `product_sizes`.`product_id` is not null
5.54msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5218 and `product_sizes`.`product_id` is not null
8.52msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1301 and `product_sizes`.`product_id` is not null
5.41msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 6014 and `product_sizes`.`product_id` is not null
7.42msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3601 and `product_sizes`.`product_id` is not null
8.83msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5059 and `product_sizes`.`product_id` is not null
5.68msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 7825 and `product_sizes`.`product_id` is not null
5.43msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1933 and `product_sizes`.`product_id` is not null
5.56msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2376 and `product_sizes`.`product_id` is not null
7.62msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3176 and `product_sizes`.`product_id` is not null
7.17msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3797 and `product_sizes`.`product_id` is not null
9.19msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4234 and `product_sizes`.`product_id` is not null
6.24msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5895 and `product_sizes`.`product_id` is not null
7.41msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2542 and `product_sizes`.`product_id` is not null
5.43msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2059 and `product_sizes`.`product_id` is not null
5.53msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4374 and `product_sizes`.`product_id` is not null
5.57msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5093 and `product_sizes`.`product_id` is not null
5.54msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5498 and `product_sizes`.`product_id` is not null
5.59msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5499 and `product_sizes`.`product_id` is not null
5.58msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 979 and `product_sizes`.`product_id` is not null
5.5msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3098 and `product_sizes`.`product_id` is not null
5.87msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2557 and `product_sizes`.`product_id` is not null
5.59msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5894 and `product_sizes`.`product_id` is not null
5.33msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2423 and `product_sizes`.`product_id` is not null
5.3msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3802 and `product_sizes`.`product_id` is not null
5.48msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3809 and `product_sizes`.`product_id` is not null
25.25msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3811 and `product_sizes`.`product_id` is not null
10.22msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4461 and `product_sizes`.`product_id` is not null
5.93msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5534 and `product_sizes`.`product_id` is not null
6.23msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1981 and `product_sizes`.`product_id` is not null
6.07msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3172 and `product_sizes`.`product_id` is not null
5.54msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3328 and `product_sizes`.`product_id` is not null
5.82msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4012 and `product_sizes`.`product_id` is not null
7.81msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3644 and `product_sizes`.`product_id` is not null
6.14msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5672 and `product_sizes`.`product_id` is not null
5.69msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5221 and `product_sizes`.`product_id` is not null
5.8msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 897 and `product_sizes`.`product_id` is not null
6.33msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 2175 and `product_sizes`.`product_id` is not null
5.77msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 740 and `product_sizes`.`product_id` is not null
5.88msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 884 and `product_sizes`.`product_id` is not null
10.73msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3004 and `product_sizes`.`product_id` is not null
6.4msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3794 and `product_sizes`.`product_id` is not null
5.69msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3436 and `product_sizes`.`product_id` is not null
5.78msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1686 and `product_sizes`.`product_id` is not null
5.58msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5915 and `product_sizes`.`product_id` is not null
5.48msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4596 and `product_sizes`.`product_id` is not null
5.51msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 880 and `product_sizes`.`product_id` is not null
5.7msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3796 and `product_sizes`.`product_id` is not null
5.9msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1533 and `product_sizes`.`product_id` is not null
5.68msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4469 and `product_sizes`.`product_id` is not null
6.01msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5164 and `product_sizes`.`product_id` is not null
5.57msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1762 and `product_sizes`.`product_id` is not null
7.33msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 1732 and `product_sizes`.`product_id` is not null
5.68msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3360 and `product_sizes`.`product_id` is not null
5.59msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 4205 and `product_sizes`.`product_id` is not null
5.61msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 3782 and `product_sizes`.`product_id` is not null
5.63msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5065 and `product_sizes`.`product_id` is not null
5.61msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` = 5232 and `product_sizes`.`product_id` is not null
5.51msview::frontend.products.sales-products:144pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `product_sizes` (SIMPLE)
92801Metadata | |
---|---|
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` asc
17.61ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
20.78ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
17.58ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
13.94ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
13.25ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.42ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.51ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
9.74ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.05ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.96ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.63ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.46ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.76ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.6ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
11.83ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
12.22ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.64ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.13ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
12.72ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.61ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.32ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
9.93ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.37ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.76ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.85ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.86ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.47ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.83ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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.23ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `settings` (SIMPLE)
91Metadata | |
---|---|
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` = '4724_cart_items' limit 1
1.28ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4724_cart_items' limit 1
1.29ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4724_cart_items' limit 1
1.09ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4724_cart_items' limit 1
1.2ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
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` asc
17.3ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
20.35ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
16.17ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
16.34ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
14.33ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.56ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.66ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
9.79ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.93ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.15ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.28ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.63ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.26ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.75ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
11.51ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
12.04ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.69ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
11.07ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.95ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.54ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.36ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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` asc
9.76ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.99ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.84ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.23ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.66ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
9.57ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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)
11Metadata | |
---|---|
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` asc
10.09ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dcMetadata | |
---|---|
Bindings |
|
Backtrace |
|
- EXPLAIN # 1: `products` (SIMPLE)
67721Metadata | |
---|---|
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.32ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `settings` (SIMPLE)
91Metadata | |
---|---|
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` = '4724_cart_items' limit 1
1.27ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
select * from `cart_storage` where `cart_storage`.`id` = '4724_cart_items' limit 1
1.2ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dcMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
- EXPLAIN # 1: `cart_storage` (SIMPLE)
11Metadata | |
---|---|
id | 1 |
select_type | SIMPLE |
table | cart_storage |
partitions | null |
type | const |
possible_keys | PRIMARY,cart_storage_id_index |
key | PRIMARY |
key_len | 766 |
ref | const |
rows | 1 |
filtered | 100 |
Extra | null |
200
0 of 0array:1 [▶ "page" => "70" ]
0 of 0array:1 [▶ "page" => "70" ]
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.21" "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" => "48199" "REDIRECT_URL" => "/products/sale" "REDIRECT_QUERY_STRING" => "page=70" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=70" "REQUEST_URI" => "/products/sale?page=70" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755091273.6771 "REQUEST_TIME" => 1755091273 ]
[]
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 13:21:13 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjUxQ215RnZJckJYckZVNHR6eCtKWmc9PSIsInZhbHVlIjoiTDRraXRGazNVSW5FZ0JYQ3JlVnV6NkEydlZCMTczYi9ORHJUeDk5U3BYdDU3Z3ZtODNxbHpmOFdVQ2k3bkwzOEZtUysvQVBYVUhYRmsraGZmazZPSWEweGtpOC9ZUzNqbEFRQkVOSzBDcDdiaGpqWEFsZWVZN1lrRGJLVXpwTjciLCJtYWMiOiJiMDQzZmZhMjI1NjlkNTFjMDJjYmMxYTYwM2M4ZmE1MjhmYTI1NWY0YjNkNjQ5MjI4ZDQxNTI3MmY2NjEzZjhmIn0%3D; expires=Wed, 24-Nov-2027 21:21:16 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6IjUxQ215RnZJckJYckZVNHR6eCtKWmc9PSIsInZhbHVlIjoiTDRraXRGazNVSW5FZ0JYQ3JlVnV6NkEydlZCMTczYi9ORHJUeDk5U3BYdDU3Z3ZtODNxbHpmOFdVQ2k3bkwzOEZtUysvQ ▶" 1 => "laravel_session=eyJpdiI6Ikc0SDY4SVdjYjJnZVdMTm5IUlRxa2c9PSIsInZhbHVlIjoiRnVuMUlGQU9Xdy95RUdBNm5xaXZsTDNyT1N0R05qNXpLZzNYNWMzQUhjcGhQY0VyME5LcVRjcGhmR3kxbHp6THEzVlZYdjl0aFhrbE1jNjVDSXErQnk1YmRhamNheGFNZS9VNW5LdFdzc3c0d09icGlyOU44Y2JNSi85Tk4weTciLCJtYWMiOiI0OTYwYjA0NGFlYTIzM2QzMjYwOTQ3MDdiYWFiMmU4ZDRiNmY0Y2E0NThiMmIwNTliYmY0NjE1NGExMmE3ODJiIn0%3D; expires=Wed, 24-Nov-2027 21:21:16 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6Ikc0SDY4SVdjYjJnZVdMTm5IUlRxa2c9PSIsInZhbHVlIjoiRnVuMUlGQU9Xdy95RUdBNm5xaXZsTDNyT1N0R05qNXpLZzNYNWMzQUhjcGhQY0VyME5LcVRjcGhmR3kxbHp6THEz ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjUxQ215RnZJckJYckZVNHR6eCtKWmc9PSIsInZhbHVlIjoiTDRraXRGazNVSW5FZ0JYQ3JlVnV6NkEydlZCMTczYi9ORHJUeDk5U3BYdDU3Z3ZtODNxbHpmOFdVQ2k3bkwzOEZtUysvQVBYVUhYRmsraGZmazZPSWEweGtpOC9ZUzNqbEFRQkVOSzBDcDdiaGpqWEFsZWVZN1lrRGJLVXpwTjciLCJtYWMiOiJiMDQzZmZhMjI1NjlkNTFjMDJjYmMxYTYwM2M4ZmE1MjhmYTI1NWY0YjNkNjQ5MjI4ZDQxNTI3MmY2NjEzZjhmIn0%3D; expires=Wed, 24-Nov-2027 21:21:16 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjUxQ215RnZJckJYckZVNHR6eCtKWmc9PSIsInZhbHVlIjoiTDRraXRGazNVSW5FZ0JYQ3JlVnV6NkEydlZCMTczYi9ORHJUeDk5U3BYdDU3Z3ZtODNxbHpmOFdVQ2k3bkwzOEZtUysvQ ▶" 1 => "laravel_session=eyJpdiI6Ikc0SDY4SVdjYjJnZVdMTm5IUlRxa2c9PSIsInZhbHVlIjoiRnVuMUlGQU9Xdy95RUdBNm5xaXZsTDNyT1N0R05qNXpLZzNYNWMzQUhjcGhQY0VyME5LcVRjcGhmR3kxbHp6THEzVlZYdjl0aFhrbE1jNjVDSXErQnk1YmRhamNheGFNZS9VNW5LdFdzc3c0d09icGlyOU44Y2JNSi85Tk4weTciLCJtYWMiOiI0OTYwYjA0NGFlYTIzM2QzMjYwOTQ3MDdiYWFiMmU4ZDRiNmY0Y2E0NThiMmIwNTliYmY0NjE1NGExMmE3ODJiIn0%3D; expires=Wed, 24-Nov-2027 21:21:16 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ikc0SDY4SVdjYjJnZVdMTm5IUlRxa2c9PSIsInZhbHVlIjoiRnVuMUlGQU9Xdy95RUdBNm5xaXZsTDNyT1N0R05qNXpLZzNYNWMzQUhjcGhQY0VyME5LcVRjcGhmR3kxbHp6THEz ▶" ] ]
0 of 0array:5 [▶ "_token" => "CCZHLYXbVrVjz28j2HpaDty6CKmCm3djgcqnHnLp" "cartSessionId" => 4724 "_previous" => array:1 [▶ "url" => "https://www.pasargad.com/products/sale?page=70" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]