Pasargad

Messages Timeline Exceptions Views6 Route Queries102 Models1678 Mails Auth Gate Session Request

7.3.232.01s8MBGET products

Booting (18.84ms)
Application (1.99s)
1 x Application (99.06%)
1.99s
1 x Booting (0.94%)
18.84ms

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

102 statements were executed, 63 of which were duplicated, 39 unique1.7s

select * from `subcategories`9.71ms/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` = '92' limit 12.25ms/app/Repositories/BaseRepository.php:33pasargad_dc

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

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

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

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

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Repositories/BaseRepository.php:15 15. /app/Http/Controllers/Frontend/Product/ProductController.php: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`2.66ms/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.17ms/app/Repositories/BaseRepository.php:15pasargad_dc

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

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

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

select * from `weaves`1.74ms/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`2.38ms/app/Repositories/BaseRepository.php:15pasargad_dc

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

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

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

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

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

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

- EXPLAIN # 1: `order_table` (SIMPLE)92811
Metadata
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`.`subcategory_id` = '92' and `products`.`status` = 1 order by `order_table`.`width` asc, `order_table`.`length` asc limit 102 offset 0

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

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

- EXPLAIN # 1: `order_table` (SIMPLE)92811
Metadata
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`.`subcategory_id` = '92' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

- EXPLAIN # 1: `color_list_table` (SIMPLE)149521
Metadata
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` = '92' limit 11.31ms/app/Repositories/BaseRepository.php:33pasargad_dc

Metadata
Bindings	0. 92
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` = 8473 and `product_sizes`.`product_id` is not null15.24msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8473
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` = 8950 and `product_sizes`.`product_id` is not null12.3msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8950
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` = 9140 and `product_sizes`.`product_id` is not null12.09msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 9140
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` = 1856 and `product_sizes`.`product_id` is not null10.42msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1856
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` = 1857 and `product_sizes`.`product_id` is not null13.27msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1857
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` = 758 and `product_sizes`.`product_id` is not null7.87msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 758
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` = 753 and `product_sizes`.`product_id` is not null10.6msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 753
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` = 8474 and `product_sizes`.`product_id` is not null11.24msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8474
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` = 8954 and `product_sizes`.`product_id` is not null9.75msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8954
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` = 1846 and `product_sizes`.`product_id` is not null9.9msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1846
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` = 8475 and `product_sizes`.`product_id` is not null6.29msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8475
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` = 8647 and `product_sizes`.`product_id` is not null14.88msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8647
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` = 8408 and `product_sizes`.`product_id` is not null7.15msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8408
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` = 1853 and `product_sizes`.`product_id` is not null7.18msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1853
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` = 1854 and `product_sizes`.`product_id` is not null7.82msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1854
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` = 8946 and `product_sizes`.`product_id` is not null9.44msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8946
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` = 8952 and `product_sizes`.`product_id` is not null9.93msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 8952
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` = 1847 and `product_sizes`.`product_id` is not null5.64msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1847
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` = 1849 and `product_sizes`.`product_id` is not null9.39msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1849
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` = 6104 and `product_sizes`.`product_id` is not null6.5msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 6104
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` = 6105 and `product_sizes`.`product_id` is not null9.65msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 6105
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` = 1852 and `product_sizes`.`product_id` is not null9.89msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1852
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` = 1848 and `product_sizes`.`product_id` is not null6.07msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1848
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` = 1850 and `product_sizes`.`product_id` is not null18.55msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 1850
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` = 9080 and `product_sizes`.`product_id` is not null9.26msview::frontend.products.index:362pasargad_dc

Metadata
Bindings	0. 9080
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

23.83ms/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

28.11ms/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

23.5ms/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

21ms/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

13.47ms/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

19.91ms/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

16.51ms/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

24.93ms/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

31.68ms/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

32.63ms/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

32.03ms/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

26.66ms/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

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

Metadata
Bindings	0. lighting
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:101 15. view::frontend.includes.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

17.7ms/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

17.74ms/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

12.34ms/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

18.7ms/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

17.52ms/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

15.36ms/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

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

Metadata
Bindings	0. accessories
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/Frontend/MenuHelper.php:109 15. view::frontend.includes.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

12.66ms/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.48ms/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

15.28ms/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

15.66ms/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

14.31ms/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.8ms/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

16.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

14.17ms/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.27ms/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` = '9715_cart_items' limit 11.92ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 9715_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` = '9715_cart_items' limit 11.15ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 9715_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

19.34ms/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

24.18ms/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

27.33ms/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

14.17ms/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

18.9ms/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

13.85ms/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

18.34ms/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

14.51ms/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

14.22ms/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

14.8ms/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

15.14ms/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

14.56ms/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

15.48ms/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

10.05ms/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.22ms/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.59ms/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.75ms/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

16.49ms/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

16.32ms/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

10.98ms/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

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

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

- EXPLAIN # 1: `products` (SIMPLE)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.95ms/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.16ms/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.48ms/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.84ms/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

9.25ms/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.3ms/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

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

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

- EXPLAIN # 1: `products` (SIMPLE)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.25ms/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` = '9715_cart_items' limit 11.25ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pasargad_dc

Metadata
Bindings	0. 9715_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: 25
App\Models\Product\Product: 1094
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: 9c2MaQZce2TS02GCfpoASQZZYEFu4qOSBJDmyHiY
cartSessionId: 9715
_previous: array:1 [ "url" => "https://www.pasargad.com/products?collection=92" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

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

request_request

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

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" => "36848"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "collection=92"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "collection=92"
  "REQUEST_URI" => "/products?collection=92"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755154622.8438
  "REQUEST_TIME" => 1755154622
]

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 06:57:03 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IngxTEpvZDdVbEhOVkxkYWdnempLckE9PSIsInZhbHVlIjoiTjdzYmdUNzVFT3loZ01PTVlCcjJLbVhwMk1vdkhQOFNPVWs0YlIzVmtSMFYxWUk4cWg2QlNrSGh2a294d3hMaUhJU2p1dVlqV1VoWkJXU05zbkpvQjFJNFNtQ1BWdmhvclhpQ3FoSmd0RWl1NlVNWm9LQ3RrMS9RTzkxVStDTTciLCJtYWMiOiI2MGU3ZTczOTUzMDE5MGY1ODgyNTVlN2NjM2JlYzY0MzRhN2U5NWFhYWVlN2NjY2U3OWE2ZGQ4YjIwNzVmNjMyIn0%3D; expires=Thu, 25-Nov-2027 14:57:04 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6IngxTEpvZDdVbEhOVkxkYWdnempLckE9PSIsInZhbHVlIjoiTjdzYmdUNzVFT3loZ01PTVlCcjJLbVhwMk1vdkhQOFNPVWs0YlIzVmtSMFYxWUk4cWg2QlNrSGh2a294d3hMaUhJU2p1d ▶"
    1 => "laravel_session=eyJpdiI6ImlnUUU4WTB6Mm5pTWljQ2xwVGtxcVE9PSIsInZhbHVlIjoiVnJYYkJraHpWYVR4eURQdndoSncyMVJwM2drd29ucHcwSkhlNUZGbnV4aTdqYmtIN2NubHNvQ2kwZDlFaWlMbllHclZ4N1FjLzBZaTV4WDl3MUJQdUNwYTRCd1Y1b1lvaTlMbStna25zL1BjTlpsUXV3VWRucWk2Yk9BRW5OYjMiLCJtYWMiOiI3YWVmYzI1ZmEyZGMxZTAyYzNiYWI0YjJhYTJiM2Y2ODA0NWI2ZGJkMGRlMDVlMWFhNTcwYTQxN2QwN2Q4ZDgxIn0%3D; expires=Thu, 25-Nov-2027 14:57:04 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6ImlnUUU4WTB6Mm5pTWljQ2xwVGtxcVE9PSIsInZhbHVlIjoiVnJYYkJraHpWYVR4eURQdndoSncyMVJwM2drd29ucHcwSkhlNUZGbnV4aTdqYmtIN2NubHNvQ2kwZDlFaWlMbllH ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IngxTEpvZDdVbEhOVkxkYWdnempLckE9PSIsInZhbHVlIjoiTjdzYmdUNzVFT3loZ01PTVlCcjJLbVhwMk1vdkhQOFNPVWs0YlIzVmtSMFYxWUk4cWg2QlNrSGh2a294d3hMaUhJU2p1dVlqV1VoWkJXU05zbkpvQjFJNFNtQ1BWdmhvclhpQ3FoSmd0RWl1NlVNWm9LQ3RrMS9RTzkxVStDTTciLCJtYWMiOiI2MGU3ZTczOTUzMDE5MGY1ODgyNTVlN2NjM2JlYzY0MzRhN2U5NWFhYWVlN2NjY2U3OWE2ZGQ4YjIwNzVmNjMyIn0%3D; expires=Thu, 25-Nov-2027 14:57:04 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IngxTEpvZDdVbEhOVkxkYWdnempLckE9PSIsInZhbHVlIjoiTjdzYmdUNzVFT3loZ01PTVlCcjJLbVhwMk1vdkhQOFNPVWs0YlIzVmtSMFYxWUk4cWg2QlNrSGh2a294d3hMaUhJU2p1d ▶"
    1 => "laravel_session=eyJpdiI6ImlnUUU4WTB6Mm5pTWljQ2xwVGtxcVE9PSIsInZhbHVlIjoiVnJYYkJraHpWYVR4eURQdndoSncyMVJwM2drd29ucHcwSkhlNUZGbnV4aTdqYmtIN2NubHNvQ2kwZDlFaWlMbllHclZ4N1FjLzBZaTV4WDl3MUJQdUNwYTRCd1Y1b1lvaTlMbStna25zL1BjTlpsUXV3VWRucWk2Yk9BRW5OYjMiLCJtYWMiOiI3YWVmYzI1ZmEyZGMxZTAyYzNiYWI0YjJhYTJiM2Y2ODA0NWI2ZGJkMGRlMDVlMWFhNTcwYTQxN2QwN2Q4ZDgxIn0%3D; expires=Thu, 25-Nov-2027 14:57:04 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImlnUUU4WTB6Mm5pTWljQ2xwVGtxcVE9PSIsInZhbHVlIjoiVnJYYkJraHpWYVR4eURQdndoSncyMVJwM2drd29ucHcwSkhlNUZGbnV4aTdqYmtIN2NubHNvQ2kwZDlFaWlMbllH ▶"
  ]
]

session_attributes

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

Products

Categories

Collections

Styles

Materials

Weaves

Colors

Size

Shape

1 x Application (99.06%)	1.99s
1 x Booting (0.94%)	18.84ms