Pasargad

Messages Timeline Exceptions Views6 Route Queries88 Models1637 Mails Auth Gate Session Request

7.3.232.07s8MBGET products

Booting (15.2ms)
Application (2.05s)
1 x Application (99.26%)
2.05s
1 x Booting (0.73%)
15.20ms

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

88 statements were executed, 63 of which were duplicated, 25 unique1.72s

select * from `subcategories`8.34ms/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.12ms/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`6.6ms/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`9.03ms/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`2.65ms/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`7.04ms/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.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: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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1

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

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

- EXPLAIN # 1: `order_table` (SIMPLE)92811
Metadata
id 1
select_type SIMPLE
table order_table
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
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	9281
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 0

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

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

- EXPLAIN # 1: `order_table` (SIMPLE)92811
Metadata
id 1
select_type SIMPLE
table order_table
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
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	9281
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc

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

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

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

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6773
filtered	0.10000000149011612
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

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

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

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

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6773
filtered	0.10000000149011612
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc

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

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

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

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6773
filtered	0.10000000149011612
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc

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

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

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

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6773
filtered	0.10000000149011612
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc

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

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

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

Metadata
id	1
select_type	SIMPLE
table	products
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	6773
filtered	0.10000000149011612
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`.`type` = 'rug' and `products`.`subcategory_id` = '23' and `products`.`status` = 1 group by `colors`.`id` order by `colors`.`name` asc

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

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

- EXPLAIN # 1: `color_list_table` (SIMPLE)149521
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 14952
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	14952
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 14.98ms/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 null10.05msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
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	9281
filtered	10
Extra	Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 2134 and `product_sizes`.`product_id` is not null14.35msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 1016 and `product_sizes`.`product_id` is not null12.13msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 1018 and `product_sizes`.`product_id` is not null14.7msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 1017 and `product_sizes`.`product_id` is not null18.77msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 6167 and `product_sizes`.`product_id` is not null13.85msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 2315 and `product_sizes`.`product_id` is not null11.91msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 2317 and `product_sizes`.`product_id` is not null6.35msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 6157 and `product_sizes`.`product_id` is not null5.67msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 8595 and `product_sizes`.`product_id` is not null9.24msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 1524 and `product_sizes`.`product_id` is not null9.33msview::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)92811
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9281
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

28.88ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

22.8ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.69ms/app/Helpers/Frontend/MenuHelper.php:110pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.82ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.85ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.69ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.02ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
filtered 10
Extra Using where; Using temporary; Using filesort

select * from `settings`1.46ms/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` = '7073_cart_items' limit 11.06ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

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

- EXPLAIN # 1: `` (SIMPLE)1
Metadata
id 1
select_type SIMPLE
table null
partitions null
type null
possible_keys null
key null
key_len null
ref null
rows null
filtered null
Extra no matching row in const table

select * from `cart_storage` where `cart_storage`.`id` = '7073_cart_items' limit 11.03ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

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

- EXPLAIN # 1: `` (SIMPLE)1
Metadata
id 1
select_type SIMPLE
table null
partitions null
type null
possible_keys null
key null
key_len null
ref null
rows null
filtered null
Extra no matching row in const table

select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'rug' group by `products`.`category_id` order by `categories`.`category` asc

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.01ms/app/Helpers/Frontend/MenuHelper.php:88pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.79ms/app/Helpers/Frontend/MenuHelper.php:93pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.52ms/app/Helpers/Frontend/MenuHelper.php:96pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.15ms/app/Helpers/Frontend/MenuHelper.php:100pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.79ms/app/Helpers/Frontend/MenuHelper.php:104pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.1ms/app/Helpers/Frontend/MenuHelper.php:105pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.38ms/app/Helpers/Frontend/MenuHelper.php:106pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.84ms/app/Helpers/Frontend/MenuHelper.php:108pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.4ms/app/Helpers/Frontend/MenuHelper.php:109pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.87ms/app/Helpers/Frontend/MenuHelper.php:112pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.14ms/app/Helpers/Frontend/MenuHelper.php:113pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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

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

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.18ms/app/Helpers/Frontend/MenuHelper.php:116pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.43ms/app/Helpers/Frontend/MenuHelper.php:117pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
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.51ms/app/Helpers/Frontend/MenuHelper.php:118pasargad_dc

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

- EXPLAIN # 1: `products` (SIMPLE)67731
Metadata
id 1
select_type SIMPLE
table products
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 6773
filtered 10
Extra Using where; Using temporary; Using filesort

select * from `settings`1.19ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Helpers/Frontend/MenuHelper.php:130 18. view::frontend.includes.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` = '7073_cart_items' limit 11.16ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

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

- EXPLAIN # 1: `` (SIMPLE)1
Metadata
id 1
select_type SIMPLE
table null
partitions null
type null
possible_keys null
key null
key_len null
ref null
rows null
filtered null
Extra no matching row in const table

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: GOgpnjtmAduwhFd1wLtMo4qbiDA3YqBqLdNh5rZJ
cartSessionId: 7073
_previous: array:1 [ "url" => "https://www.pasargad.com/products?collection=23&type=rug" ]
_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:2 [▶
  "collection" => "23"
  "type" => "rug"
]

request_request

  0 of 0   
array:2 [▶
  "collection" => "23"
  "type" => "rug"
]

request_headers

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

request_server

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 14 Aug 2025 07:29:43 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9wS3VWb1lxYkJIbFU2Qzh5RXRXeUE9PSIsInZhbHVlIjoiSXE1WXFrVkVRU3lsaTVnQ0hPYXJLM0lCbVlwQjBCVVY1S0FTMXZFWXNJSjJ3cHJEODJ0RTBycHEwbitsNlA5S1R0dWhDdytUZi9VRkNzZ1hQTVlSZTN1SmtuaFVqZEdicGh2amlkR3FmNHBQWm5NTUYzZFozV1lUenlucUdVcUQiLCJtYWMiOiIyM2MwMGJjMDVmN2YwN2U2NDNkMTZjNDQ2OWZlOTY0Yzc4ZDc1NjY1MWY5NzAxNGVjOTQ4NWExYTRlY2RiNzk1In0%3D; expires=Thu, 25-Nov-2027 15:29:45 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9wS3VWb1lxYkJIbFU2Qzh5RXRXeUE9PSIsInZhbHVlIjoiSXE1WXFrVkVRU3lsaTVnQ0hPYXJLM0lCbVlwQjBCVVY1S0FTMXZFWXNJSjJ3cHJEODJ0RTBycHEwbitsNlA5S1R0dWhDd ▶"
    1 => "laravel_session=eyJpdiI6ImpkQ0VoQmQ4dHdtWXMydnVpYjJBSmc9PSIsInZhbHVlIjoibUUzdk0ydjYyWS9uOG1FYndjMU1RV0JMU00zZUtCUGhkVDRVR1lVdENVc2RWeit2ZEJSS1FLNkFCWkVrNitzS3k2U3dNK2FxZyt0cWJGcFhzeEEzUlBMTDlHWGt2aVBXeVBGUUNlUGJsejQxMGNwVzRYR0h1V2llSjZIK0NvbWEiLCJtYWMiOiJjNTUyODQyNGVkMTdlYWY3YTUyM2JiYzFlYmVjZDI1MDllZmFjYjg5YmFkZWYyZTRhYmQ3ZDQwYjk2ZTU2ZDgyIn0%3D; expires=Thu, 25-Nov-2027 15:29:45 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6ImpkQ0VoQmQ4dHdtWXMydnVpYjJBSmc9PSIsInZhbHVlIjoibUUzdk0ydjYyWS9uOG1FYndjMU1RV0JMU00zZUtCUGhkVDRVR1lVdENVc2RWeit2ZEJSS1FLNkFCWkVrNitzS3k2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9wS3VWb1lxYkJIbFU2Qzh5RXRXeUE9PSIsInZhbHVlIjoiSXE1WXFrVkVRU3lsaTVnQ0hPYXJLM0lCbVlwQjBCVVY1S0FTMXZFWXNJSjJ3cHJEODJ0RTBycHEwbitsNlA5S1R0dWhDdytUZi9VRkNzZ1hQTVlSZTN1SmtuaFVqZEdicGh2amlkR3FmNHBQWm5NTUYzZFozV1lUenlucUdVcUQiLCJtYWMiOiIyM2MwMGJjMDVmN2YwN2U2NDNkMTZjNDQ2OWZlOTY0Yzc4ZDc1NjY1MWY5NzAxNGVjOTQ4NWExYTRlY2RiNzk1In0%3D; expires=Thu, 25-Nov-2027 15:29:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9wS3VWb1lxYkJIbFU2Qzh5RXRXeUE9PSIsInZhbHVlIjoiSXE1WXFrVkVRU3lsaTVnQ0hPYXJLM0lCbVlwQjBCVVY1S0FTMXZFWXNJSjJ3cHJEODJ0RTBycHEwbitsNlA5S1R0dWhDd ▶"
    1 => "laravel_session=eyJpdiI6ImpkQ0VoQmQ4dHdtWXMydnVpYjJBSmc9PSIsInZhbHVlIjoibUUzdk0ydjYyWS9uOG1FYndjMU1RV0JMU00zZUtCUGhkVDRVR1lVdENVc2RWeit2ZEJSS1FLNkFCWkVrNitzS3k2U3dNK2FxZyt0cWJGcFhzeEEzUlBMTDlHWGt2aVBXeVBGUUNlUGJsejQxMGNwVzRYR0h1V2llSjZIK0NvbWEiLCJtYWMiOiJjNTUyODQyNGVkMTdlYWY3YTUyM2JiYzFlYmVjZDI1MDllZmFjYjg5YmFkZWYyZTRhYmQ3ZDQwYjk2ZTU2ZDgyIn0%3D; expires=Thu, 25-Nov-2027 15:29:45 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImpkQ0VoQmQ4dHdtWXMydnVpYjJBSmc9PSIsInZhbHVlIjoibUUzdk0ydjYyWS9uOG1FYndjMU1RV0JMU00zZUtCUGhkVDRVR1lVdENVc2RWeit2ZEJSS1FLNkFCWkVrNitzS3k2 ▶"
  ]
]

session_attributes

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

Products

Categories

Collections

Styles

Materials

Weaves

Colors

Size

Shape

1 x Application (99.26%)	2.05s
1 x Booting (0.73%)	15.20ms