Pasargad

Messages Timeline Exceptions Views6 Route Queries91 Models1643 Mails Auth Gate Session Request

7.3.231.44s8MBGET products

Booting (18.64ms)
Application (1.42s)
1 x Application (98.69%)
1.42s
1 x Booting (1.3%)
18.64ms

6 templates were rendered

frontend.products.index (resources/views/frontend/products/index.blade.php)13blade


products
categoryList
collectionList
styleList
materialList
weaveList
colorList
filterData
categoryId
filterDisplay
categoryData
collectionData
logged_in_user

pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)3blade
Params
0
paginator
1
elements
2
logged_in_user

Params
0	`products`
1	`categoryList`
2	`collectionList`
3	`styleList`
4	`materialList`
5	`weaveList`
6	`colorList`
7	`filterData`
8	`categoryId`
9	`filterDisplay`
10	`categoryData`
11	`collectionData`
12	`logged_in_user`

Params
0	`paginator`
1	`elements`
2	`logged_in_user`

frontend.layouts.master (resources/views/frontend/layouts/master.blade.php)25blade


__env
app
errors
products
categoryList
collectionList
styleList
materialList
weaveList
colorList
filterData
categoryId
filterDisplay
categoryData
collectionData
logged_in_user
__currentLoopData
single
loop
product
isSoldOut
finalPrice
sale_price
images
queryParams

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`categoryList`
5	`collectionList`
6	`styleList`
7	`materialList`
8	`weaveList`
9	`colorList`
10	`filterData`
11	`categoryId`
12	`filterDisplay`
13	`categoryData`
14	`collectionData`
15	`logged_in_user`
16	`__currentLoopData`
17	`single`
18	`loop`
19	`product`
20	`isSoldOut`
21	`finalPrice`
22	`sale_price`
23	`images`
24	`queryParams`

frontend.includes.header (resources/views/frontend/includes/header.blade.php)25blade


__env
app
errors
products
categoryList
collectionList
styleList
materialList
weaveList
colorList
filterData
categoryId
filterDisplay
categoryData
collectionData
logged_in_user
__currentLoopData
single
loop
product
isSoldOut
finalPrice
sale_price
images
queryParams

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`categoryList`
5	`collectionList`
6	`styleList`
7	`materialList`
8	`weaveList`
9	`colorList`
10	`filterData`
11	`categoryId`
12	`filterDisplay`
13	`categoryData`
14	`collectionData`
15	`logged_in_user`
16	`__currentLoopData`
17	`single`
18	`loop`
19	`product`
20	`isSoldOut`
21	`finalPrice`
22	`sale_price`
23	`images`
24	`queryParams`

includes.partials.messages (resources/views/includes/partials/messages.blade.php)25blade


__env
app
errors
products
categoryList
collectionList
styleList
materialList
weaveList
colorList
filterData
categoryId
filterDisplay
categoryData
collectionData
logged_in_user
__currentLoopData
single
loop
product
isSoldOut
finalPrice
sale_price
images
queryParams

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`categoryList`
5	`collectionList`
6	`styleList`
7	`materialList`
8	`weaveList`
9	`colorList`
10	`filterData`
11	`categoryId`
12	`filterDisplay`
13	`categoryData`
14	`collectionData`
15	`logged_in_user`
16	`__currentLoopData`
17	`single`
18	`loop`
19	`product`
20	`isSoldOut`
21	`finalPrice`
22	`sale_price`
23	`images`
24	`queryParams`

frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)25blade


__env
app
errors
products
categoryList
collectionList
styleList
materialList
weaveList
colorList
filterData
categoryId
filterDisplay
categoryData
collectionData
logged_in_user
__currentLoopData
single
loop
product
isSoldOut
finalPrice
sale_price
images
queryParams

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`categoryList`
5	`collectionList`
6	`styleList`
7	`materialList`
8	`weaveList`
9	`colorList`
10	`filterData`
11	`categoryId`
12	`filterDisplay`
13	`categoryData`
14	`collectionData`
15	`logged_in_user`
16	`__currentLoopData`
17	`single`
18	`loop`
19	`product`
20	`isSoldOut`
21	`finalPrice`
22	`sale_price`
23	`images`
24	`queryParams`

uri: GET products
middleware: web
controller: App\Http\Controllers\Frontend\Product\ProductController@index
as: frontend.product.product-by-type
namespace: App\Http\Controllers\Frontend\Product
prefix
where
file: app/Http/Controllers/Frontend/Product/ProductController.php:62-431

91 statements were executed, 66 of which were duplicated, 25 unique1.18s

select * from `subcategories`7.5ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:88 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `subcategories` (SIMPLE)1041
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 104
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	subcategories
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	104
filtered	100
Extra	null

select * from `subcategories` where `subcategories`.`id` = '23' limit 11.33ms/app/Repositories/BaseRepository.php:33pasargad_dc

Metadata
Bindings	0. 23
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Repositories/BaseRepository.php:33 17. /app/Http/Controllers/Frontend/Product/ProductController.php:93 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	subcategories
partitions	null
type	const
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	const
rows	1
filtered	100
Extra	null

select * from `categories`1.72ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:96 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `categories` (SIMPLE)341
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 34
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	categories
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	34
filtered	100
Extra	null

select * from `styles`1.82ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:97 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `styles` (SIMPLE)2101
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 210
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	styles
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	210
filtered	100
Extra	null

select * from `materials`1.45ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:98 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `materials` (SIMPLE)531
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 53
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	materials
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	53
filtered	100
Extra	null

select * from `weaves`1.54ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:99 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `weaves` (SIMPLE)161
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 16
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	weaves
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	16
filtered	100
Extra	null

select * from `colors`1.73ms/app/Repositories/BaseRepository.php:15pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php:100 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `colors` (SIMPLE)1031
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 103
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	colors
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	103
filtered	100
Extra	null

select count(*) as aggregate from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1

59.77ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc

Metadata
Bindings	0. 23 1. 1
Backtrace	15. /app/Http/Controllers/Frontend/Product/ProductController.php:308 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `order_table` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table order_table
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 100
Extra null
- EXPLAIN # 1: `products` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table products
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.order_table.product_id
rows 1
filtered 5
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	order_table
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	9280
filtered	100
Extra	null

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.order_table.product_id
rows	1
filtered	5
Extra	Using where

select `products`.* from `products` inner join `product_sizes` as `order_table` on `order_table`.`product_id` = `products`.`id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 0

93.81ms/app/Http/Controllers/Frontend/Product/ProductController.php:308pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Http/Controllers/Frontend/Product/ProductController.php:308 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `order_table` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table order_table
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 100
Extra Using filesort
- EXPLAIN # 1: `products` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table products
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.order_table.product_id
rows 1
filtered 5
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	order_table
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	9280
filtered	100
Extra	Using filesort

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.order_table.product_id
rows	1
filtered	5
Extra	Using where

select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc

10.73ms/app/Http/Controllers/Frontend/Product/ProductController.php:312pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:312 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 1.0000001192092896
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6772
filtered	1.0000001192092896
Extra	Using where; Using temporary; Using filesort

Metadata
id	1
select_type	SIMPLE
table	categories
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.products.category_id
rows	1
filtered	100
Extra	Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

9.56ms/app/Http/Controllers/Frontend/Product/ProductController.php:314pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:314 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 1.0000001192092896
Extra Using where
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6772
filtered	1.0000001192092896
Extra	Using where

Metadata
id	1
select_type	SIMPLE
table	subcategories
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.products.subcategory_id
rows	1
filtered	100
Extra	Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc

12.22ms/app/Http/Controllers/Frontend/Product/ProductController.php:316pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:316 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 1.0000001192092896
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6772
filtered	1.0000001192092896
Extra	Using where; Using temporary; Using filesort

Metadata
id	1
select_type	SIMPLE
table	styles
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.products.style_id
rows	1
filtered	100
Extra	Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc

16.53ms/app/Http/Controllers/Frontend/Product/ProductController.php:318pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:318 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 1.0000001192092896
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6772
filtered	1.0000001192092896
Extra	Using where; Using temporary; Using filesort

Metadata
id	1
select_type	SIMPLE
table	materials
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.products.material_id
rows	1
filtered	100
Extra	Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc

10.52ms/app/Http/Controllers/Frontend/Product/ProductController.php:320pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:320 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 1.0000001192092896
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6772
filtered	1.0000001192092896
Extra	Using where; Using temporary; Using filesort

Metadata
id	1
select_type	SIMPLE
table	weaves
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.products.weave_id
rows	1
filtered	100
Extra	Using where

select `colors`.* from `products` inner join `product_colors` as `color_list_table` on `color_list_table`.`product_id` = `products`.`id` inner join `colors` on `colors`.`id` = `color_list_table`.`color_id` where `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc

86.65ms/app/Http/Controllers/Frontend/Product/ProductController.php:324pasargad_dc

Metadata
Bindings	0. 23 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/Product/ProductController.php:324 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:691

- EXPLAIN # 1: `color_list_table` (SIMPLE)149511
Metadata
id 1
select_type SIMPLE
table color_list_table
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 14951
filtered 100
Extra Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.color_list_table.color_id
rows 1
filtered 100
Extra Using where
- EXPLAIN # 1: `products` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table products
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.color_list_table.product_id
rows 1
filtered 5
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	color_list_table
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	14951
filtered	100
Extra	Using temporary; Using filesort

Metadata
id	1
select_type	SIMPLE
table	colors
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.color_list_table.color_id
rows	1
filtered	100
Extra	Using where

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	pasargad_dc.color_list_table.product_id
rows	1
filtered	5
Extra	Using where

select * from `subcategories` where `subcategories`.`id` = '23' limit 11.31ms/app/Repositories/BaseRepository.php:33pasargad_dc

Metadata
Bindings	0. 23
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Repositories/BaseRepository.php:33 17. /app/Http/Controllers/Frontend/Product/ProductController.php:361 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:255 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

Metadata
id	1
select_type	SIMPLE
table	subcategories
partitions	null
type	const
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	const
rows	1
filtered	100
Extra	null

select * from `product_sizes` where `product_sizes`.`product_id` = 9271 and `product_sizes`.`product_id` is not null7.91msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 9271
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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

Metadata
id	1
select_type	SIMPLE
table	product_sizes
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	9280
filtered	10
Extra	Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 2134 and `product_sizes`.`product_id` is not null5.66msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 2134
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 1016 and `product_sizes`.`product_id` is not null8.84msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1016
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 1018 and `product_sizes`.`product_id` is not null9.18msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1018
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 1017 and `product_sizes`.`product_id` is not null9.07msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1017
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 6167 and `product_sizes`.`product_id` is not null7.01msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 6167
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 2315 and `product_sizes`.`product_id` is not null9.22msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 2315
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 2317 and `product_sizes`.`product_id` is not null8.71msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 2317
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 6157 and `product_sizes`.`product_id` is not null7.2msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 6157
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 8595 and `product_sizes`.`product_id` is not null8.4msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8595
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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` = 1524 and `product_sizes`.`product_id` is not null9.04msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1524
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::frontend.products.index:362 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/laravel/framework/src/Illuminate/View/View.php:139

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
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.87ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:87 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

21.45ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:88 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc

28.67ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:89 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc

21.7ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:90 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc

21.06ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:91 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc

16.09ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:92 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc

10.86ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc

Metadata
Bindings	0. rug
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:93 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.77ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:96 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

10.51ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:97 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc

9.97ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:98 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc

9.92ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:99 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc

9.77ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:100 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc

9.74ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:101 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc

10.55ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc

Metadata
Bindings	0. lighting
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:102 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.88ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:104 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

12.43ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:105 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc

11.79ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:106 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc

11.69ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:107 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc

16.53ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:108 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc

15.23ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:109 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc

16.61ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc

Metadata
Bindings	0. accessories
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:110 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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

14.4ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:112 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

14.58ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:113 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc

14.05ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:114 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc

14.71ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:115 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc

9.1ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:116 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc

9.36ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:117 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc

10.07ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc

Metadata
Bindings	0. furniture
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:118 15. view::frontend.includes.header:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Helpers/Frontend/MenuHelper.php:130 18. view::frontend.includes.header:3 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `settings` (SIMPLE)91
Metadata
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` = '5839_cart_items' limit 11.37ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:18 20. /app/DatabaseStorage.php:22 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 22. /app/Helpers/Frontend/MenuHelper.php:160

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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` = '5839_cart_items' limit 11.24ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:24 20. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 21. /app/Helpers/Frontend/MenuHelper.php:160 22. view::frontend.includes.header:3

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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` = '5839_cart_items' limit 11.49ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:18 20. /app/DatabaseStorage.php:22 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 22. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:657

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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` = '5839_cart_items' limit 11.22ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:24 20. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:657 22. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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

24.75ms/app/Helpers/Frontend/MenuHelper.php:87pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:87 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'rug' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

33.02ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:88 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'rug' group by `products`.`style_id` order by `styles`.`name` asc

25.7ms/app/Helpers/Frontend/MenuHelper.php:89pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:89 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'rug' group by `products`.`material_id` order by `materials`.`name` asc

22.13ms/app/Helpers/Frontend/MenuHelper.php:90pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:90 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'rug' group by `products`.`weave_id` order by `weaves`.`name` asc

21.06ms/app/Helpers/Frontend/MenuHelper.php:91pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:91 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'rug' group by `products`.`color_id` order by `colors`.`name` asc

9.74ms/app/Helpers/Frontend/MenuHelper.php:92pasargad_dc

Metadata
Bindings	0. rug
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:92 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'rug' group by `products`.`shape` order by `products`.`shape` asc

11.51ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc

Metadata
Bindings	0. rug
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:93 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.28ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:96 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'lighting' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

14.45ms/app/Helpers/Frontend/MenuHelper.php:97pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:97 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'lighting' group by `products`.`style_id` order by `styles`.`name` asc

10.77ms/app/Helpers/Frontend/MenuHelper.php:98pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:98 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'lighting' group by `products`.`material_id` order by `materials`.`name` asc

10.61ms/app/Helpers/Frontend/MenuHelper.php:99pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:99 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'lighting' group by `products`.`weave_id` order by `weaves`.`name` asc

10.12ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:100 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'lighting' group by `products`.`color_id` order by `colors`.`name` asc

9.58ms/app/Helpers/Frontend/MenuHelper.php:101pasargad_dc

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:101 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'lighting' group by `products`.`shape` order by `products`.`shape` asc

10.24ms/app/Helpers/Frontend/MenuHelper.php:102pasargad_dc

Metadata
Bindings	0. lighting
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:102 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.94ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:104 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'accessories' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

12.28ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:105 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'accessories' group by `products`.`style_id` order by `styles`.`name` asc

11.51ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:106 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'accessories' group by `products`.`material_id` order by `materials`.`name` asc

11.11ms/app/Helpers/Frontend/MenuHelper.php:107pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:107 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'accessories' group by `products`.`weave_id` order by `weaves`.`name` asc

11.47ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:108 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'accessories' group by `products`.`color_id` order by `colors`.`name` asc

9.61ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:109 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'accessories' group by `products`.`shape` order by `products`.`shape` asc

10.36ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc

Metadata
Bindings	0. accessories
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:110 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.78ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:112 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `categories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table categories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.category_id
rows 1
filtered 100
Extra Using where

select `subcategories`.* from `products` inner join `subcategories` on `subcategories`.`id` = `products`.`subcategory_id` where `products`.`type` = 'furniture' group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

10.23ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:113 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `subcategories` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table subcategories
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.subcategory_id
rows 1
filtered 100
Extra Using where

select `styles`.* from `products` inner join `styles` on `styles`.`id` = `products`.`style_id` where `products`.`type` = 'furniture' group by `products`.`style_id` order by `styles`.`name` asc

10.33ms/app/Helpers/Frontend/MenuHelper.php:114pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:114 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `styles` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table styles
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.style_id
rows 1
filtered 100
Extra Using where

select `materials`.* from `products` inner join `materials` on `materials`.`id` = `products`.`material_id` where `products`.`type` = 'furniture' group by `products`.`material_id` order by `materials`.`name` asc

10ms/app/Helpers/Frontend/MenuHelper.php:115pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:115 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `materials` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table materials
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.material_id
rows 1
filtered 100
Extra Using where

select `weaves`.* from `products` inner join `weaves` on `weaves`.`id` = `products`.`weave_id` where `products`.`type` = 'furniture' group by `products`.`weave_id` order by `weaves`.`name` asc

10.46ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:116 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `weaves` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table weaves
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.weave_id
rows 1
filtered 100
Extra Using where

select `colors`.* from `products` inner join `colors` on `colors`.`id` = `products`.`color_id` where `products`.`type` = 'furniture' group by `products`.`color_id` order by `colors`.`name` asc

9.9ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc

Metadata
Bindings	0. furniture
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:117 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6772
filtered 10
Extra Using where; Using temporary; Using filesort
- EXPLAIN # 1: `colors` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table colors
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref pasargad_dc.products.color_id
rows 1
filtered 100
Extra Using where

select `products`.`shape` from `products` where `products`.`type` = 'furniture' group by `products`.`shape` order by `products`.`shape` asc

9.95ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc

Metadata
Bindings	0. furniture
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:118 15. view::frontend.includes.footer:25 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

- EXPLAIN # 1: `products` (SIMPLE)67721
Metadata
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.28ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Helpers/Frontend/MenuHelper.php:130 18. view::frontend.includes.footer:25 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `settings` (SIMPLE)91
Metadata
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` = '5839_cart_items' limit 12.69ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:18 20. /app/DatabaseStorage.php:22 21. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 22. /app/Helpers/Frontend/MenuHelper.php:160

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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` = '5839_cart_items' limit 11.32ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 5839_cart_items
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/DatabaseStorage.php:24 20. /vendor/darryldecode/cart/src/Darryldecode/Cart/Cart.php:675 21. /app/Helpers/Frontend/MenuHelper.php:160 22. view::frontend.includes.footer:25

- EXPLAIN # 1: `cart_storage` (SIMPLE)11
Metadata
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

App\DatabaseStorageModel: 6
App\Models\Setting\Setting: 18
App\Models\Product\ProductSize: 11
App\Models\Product\Product: 1067
App\Models\Color\Color: 103
App\Models\Weave\Weave: 16
App\Models\Material\Material: 54
App\Models\Style\Style: 219
App\Models\Categories\Category: 38
App\Models\SubCategories\SubCategory: 111

web: null
api: null

_token: cHnzf9rftQOGAHw2E99yxw5GqCCGNE2c1OTyyPOh
cartSessionId: 5839
_previous: array:1 [ "url" => "https://www.pasargad.com/products?collection=23" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▶
  "collection" => "23"
]

request_request

  0 of 0   
array:1 [▶
  "collection" => "23"
]

request_headers

  0 of 0   
array:15 [▶
  "host" => array:1 [▶
    0 => "www.pasargad.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:72 [▶
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "www.pasargad.com"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "www.pasargad.com"
  "SSL_SERVER_S_DN_CN" => "pasargad.com"
  "SSL_SERVER_I_DN_C" => "GB"
  "SSL_SERVER_I_DN_ST" => "Greater Manchester"
  "SSL_SERVER_I_DN_L" => "Salford"
  "SSL_SERVER_I_DN_O" => "Sectigo Limited"
  "SSL_SERVER_I_DN_CN" => "Sectigo RSA Domain Validation Secure Server CA"
  "SSL_SERVER_SAN_DNS_0" => "pasargad.com"
  "SSL_SERVER_SAN_DNS_1" => "www.pasargad.com"
  "SSL_VERSION_INTERFACE" => "mod_ssl/2.4.61"
  "SSL_VERSION_LIBRARY" => "OpenSSL/1.0.2k-fips"
  "SSL_PROTOCOL" => "TLSv1.2"
  "SSL_SECURE_RENEG" => "true"
  "SSL_COMPRESS_METHOD" => "NULL"
  "SSL_CIPHER" => "ECDHE-RSA-AES256-GCM-SHA384"
  "SSL_CIPHER_EXPORT" => "false"
  "SSL_CIPHER_USEKEYSIZE" => "256"
  "SSL_CIPHER_ALGKEYSIZE" => "256"
  "SSL_CLIENT_VERIFY" => "NONE"
  "SSL_SERVER_M_VERSION" => "3"
  "SSL_SERVER_M_SERIAL" => "3478FEF50BD9E58CBAB269F74C65E144"
  "SSL_SERVER_V_START" => "Sep 17 00:00:00 2024 GMT"
  "SSL_SERVER_V_END" => "Sep 17 23:59:59 2025 GMT"
  "SSL_SERVER_S_DN" => "CN=pasargad.com"
  "SSL_SERVER_I_DN" => "CN=Sectigo RSA Domain Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB"
  "SSL_SERVER_A_KEY" => "******"
  "SSL_SERVER_A_SIG" => "sha256WithRSAEncryption"
  "SSL_SESSION_RESUMED" => "Initial"
  "HTTP_HOST" => "www.pasargad.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/sbin:/usr/sbin:/bin:/usr/bin"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache/2.4.61 (Amazon) OpenSSL/1.0.2k-fips PHP/7.3.23"
  "SERVER_NAME" => "www.pasargad.com"
  "SERVER_ADDR" => "172.31.30.213"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "216.73.216.40"
  "DOCUMENT_ROOT" => "/var/www/html/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/public"
  "SERVER_ADMIN" => "root@localhost"
  "SCRIPT_FILENAME" => "/var/www/html/public/index.php"
  "REMOTE_PORT" => "25414"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "collection=23"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "collection=23"
  "REQUEST_URI" => "/products?collection=23"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755061926.1689
  "REQUEST_TIME" => 1755061926
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 05:12:06 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJTT2dPSDlwaXJBb2tIQzlBV2lxQlE9PSIsInZhbHVlIjoiTXJpWG1KUDF5RWd6aU8rL1MvL2lnanhGSXZnUXVTdEsyMEZ0Q2RCdTBBZ3ZWT2NLTWdKbVM0Wkd3QUFTV0h6TWRDRDBUVGJpZXkvanZuMXl2Q0tCREphR2tOZllLLzJZb3BsWnpzMWpsRW5sWWF5QU1vd09EODBOdU5KMENuY0giLCJtYWMiOiJhOTBhYTVjYjBkMmZlZDAwNTg5NGM1NjExMDQ1OTljYTJlYjc3MDhiYWUzYzYwZjI5ZjI0ZDZhZTMxM2Q2N2VhIn0%3D; expires=Wed, 24-Nov-2027 13:12:07 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6InJTT2dPSDlwaXJBb2tIQzlBV2lxQlE9PSIsInZhbHVlIjoiTXJpWG1KUDF5RWd6aU8rL1MvL2lnanhGSXZnUXVTdEsyMEZ0Q2RCdTBBZ3ZWT2NLTWdKbVM0Wkd3QUFTV0h6TWRDRDBUV ▶"
    1 => "laravel_session=eyJpdiI6ImxSMlkwTllaUUhLWWI4SjZ3UXYyb2c9PSIsInZhbHVlIjoiS3BvUXF5RHdudllvNXRTd1RBQjJic0Z3dHJ2blY1bFoxRlJrbmc0TjdiOWdqcDFIV3N4MzZnSXNLQ2RqQ0Y4a2hJZVNTVUNrQXVmRjlnOVR0TUNDQW9OVmdEVVlXL3BDaHBFS2dJZ3h1Tk5xSFpLSnF6VFNoZlAxWFJCNC84Uk0iLCJtYWMiOiIzZDY2Mjk3MzUwZmFlNTllZGRiZGVhMDEwMGVmNzVmZDU5Y2M5NDdhZDJlYzAyZTBiNjhiZTkzZjY1ZDE4YjY3In0%3D; expires=Wed, 24-Nov-2027 13:12:07 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6ImxSMlkwTllaUUhLWWI4SjZ3UXYyb2c9PSIsInZhbHVlIjoiS3BvUXF5RHdudllvNXRTd1RBQjJic0Z3dHJ2blY1bFoxRlJrbmc0TjdiOWdqcDFIV3N4MzZnSXNLQ2RqQ0Y4a2hJ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJTT2dPSDlwaXJBb2tIQzlBV2lxQlE9PSIsInZhbHVlIjoiTXJpWG1KUDF5RWd6aU8rL1MvL2lnanhGSXZnUXVTdEsyMEZ0Q2RCdTBBZ3ZWT2NLTWdKbVM0Wkd3QUFTV0h6TWRDRDBUVGJpZXkvanZuMXl2Q0tCREphR2tOZllLLzJZb3BsWnpzMWpsRW5sWWF5QU1vd09EODBOdU5KMENuY0giLCJtYWMiOiJhOTBhYTVjYjBkMmZlZDAwNTg5NGM1NjExMDQ1OTljYTJlYjc3MDhiYWUzYzYwZjI5ZjI0ZDZhZTMxM2Q2N2VhIn0%3D; expires=Wed, 24-Nov-2027 13:12:07 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJTT2dPSDlwaXJBb2tIQzlBV2lxQlE9PSIsInZhbHVlIjoiTXJpWG1KUDF5RWd6aU8rL1MvL2lnanhGSXZnUXVTdEsyMEZ0Q2RCdTBBZ3ZWT2NLTWdKbVM0Wkd3QUFTV0h6TWRDRDBUV ▶"
    1 => "laravel_session=eyJpdiI6ImxSMlkwTllaUUhLWWI4SjZ3UXYyb2c9PSIsInZhbHVlIjoiS3BvUXF5RHdudllvNXRTd1RBQjJic0Z3dHJ2blY1bFoxRlJrbmc0TjdiOWdqcDFIV3N4MzZnSXNLQ2RqQ0Y4a2hJZVNTVUNrQXVmRjlnOVR0TUNDQW9OVmdEVVlXL3BDaHBFS2dJZ3h1Tk5xSFpLSnF6VFNoZlAxWFJCNC84Uk0iLCJtYWMiOiIzZDY2Mjk3MzUwZmFlNTllZGRiZGVhMDEwMGVmNzVmZDU5Y2M5NDdhZDJlYzAyZTBiNjhiZTkzZjY1ZDE4YjY3In0%3D; expires=Wed, 24-Nov-2027 13:12:07 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImxSMlkwTllaUUhLWWI4SjZ3UXYyb2c9PSIsInZhbHVlIjoiS3BvUXF5RHdudllvNXRTd1RBQjJic0Z3dHJ2blY1bFoxRlJrbmc0TjdiOWdqcDFIV3N4MzZnSXNLQ2RqQ0Y4a2hJ ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "cHnzf9rftQOGAHw2E99yxw5GqCCGNE2c1OTyyPOh"
  "cartSessionId" => 5839
  "_previous" => array:1 [▶
    "url" => "https://www.pasargad.com/products?collection=23"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Products

Categories

Collections

Styles

Materials

Weaves

Colors

Size

Shape

1 x Application (98.69%)	1.42s
1 x Booting (1.3%)	18.64ms