Pasargad

Messages Timeline Exceptions Views6 Route Queries107 Models1700 Mails Auth Gate Session Request

7.3.231.53s8MBGET products

Booting (19.58ms)
Application (1.51s)
1 x Application (98.71%)
1.51s
1 x Booting (1.28%)
19.58ms

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

107 statements were executed, 64 of which were duplicated, 43 unique1.26s

select * from `subcategories`8.08ms/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 `categories`1.31ms/app/Repositories/BaseRepository.php:15pasargad_dc

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

select `categories`.* from `products` inner join `categories` on `categories`.`id` = `products`.`category_id` where `products`.`type` = 'accessories' and `products`.`shape` = 'Oval' and `products`.`status` = 1 group by `products`.`category_id` order by `categories`.`category` asc

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

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

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

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

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' and `products`.`shape` = 'Oval' and `products`.`status` = 1 group by `products`.`subcategory_id` order by `subcategories`.`subcategory` asc

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

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

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

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

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' and `products`.`shape` = 'Oval' and `products`.`status` = 1 group by `products`.`style_id` order by `styles`.`name` asc

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

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

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

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

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' and `products`.`shape` = 'Oval' and `products`.`status` = 1 group by `products`.`material_id` order by `materials`.`name` asc

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

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

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

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

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' and `products`.`shape` = 'Oval' and `products`.`status` = 1 group by `products`.`weave_id` order by `weaves`.`name` asc

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

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

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

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

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

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

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

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

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

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

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

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

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

select * from `product_sizes` where `product_sizes`.`product_id` = 1748 and `product_sizes`.`product_id` is not null9.23msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

select * from `product_sizes` where `product_sizes`.`product_id` = 1749 and `product_sizes`.`product_id` is not null8.04msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

select * from `product_sizes` where `product_sizes`.`product_id` = 1750 and `product_sizes`.`product_id` is not null9.15msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 1751 and `product_sizes`.`product_id` is not null9.19msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 75 and `product_sizes`.`product_id` is not null9.11msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 79 and `product_sizes`.`product_id` is not null9.15msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 5455 and `product_sizes`.`product_id` is not null11.36msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

select * from `product_sizes` where `product_sizes`.`product_id` = 5457 and `product_sizes`.`product_id` is not null8.05msview::frontend.products.index:362pasargad_dc

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

- EXPLAIN # 1: `product_sizes` (SIMPLE)92801
Metadata
id 1
select_type SIMPLE
table product_sizes
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 9280
filtered 10
Extra Using where

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

App\DatabaseStorageModel: 6
App\Models\Setting\Setting: 18
App\Models\Product\ProductSize: 29
App\Models\Product\Product: 1108
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: 109

web: null
api: null

_token: FW1BtZrcGiKvhXXIkHzQLN2t8xgpex32b4do4N9L
cartSessionId: 8043
_previous: array:1 [ "url" => "https://www.pasargad.com/products?shape=Oval&type=accessories" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "shape" => "Oval"
  "type" => "accessories"
]

request_request

  0 of 0   
array:2 [▶
  "shape" => "Oval"
  "type" => "accessories"
]

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.136"
  "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" => "24159"
  "REDIRECT_URL" => "/products"
  "REDIRECT_QUERY_STRING" => "shape=Oval&type=accessories"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "shape=Oval&type=accessories"
  "REQUEST_URI" => "/products?shape=Oval&type=accessories"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1755082330.0931
  "REQUEST_TIME" => 1755082330
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 13 Aug 2025 10:52:10 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBqYTkzUFFvb2ppVjhvOGxlZmh1YlE9PSIsInZhbHVlIjoidG0vRUorblhqdkNydmJ5S3JEc0lEdXhFaWh3NTl0NGJjN2xIbnUvZDVIVS95cXRuRkJoQWRFbWpyakNpZk94TXYzSlFxZWtuOS9QVXBxSUszMFNqY2R3ZEZOTDRJLzZUSHdYU0JZcnhoVjZEdXpoZ0VRR2FJaStCTmExLzRORXIiLCJtYWMiOiIzNGQ1M2IwODYyYTBjYTI5NzE3NGYzMmY2ODFjMGVjNDRlMmY5M2JjODUwZmY2MTBkMjM1YzFmMjJjNmJkYjg4In0%3D; expires=Wed, 24-Nov-2027 18:52:11 GMT; Max-Age=72000000; path=/ ◀XSRF-TOKEN=eyJpdiI6InBqYTkzUFFvb2ppVjhvOGxlZmh1YlE9PSIsInZhbHVlIjoidG0vRUorblhqdkNydmJ5S3JEc0lEdXhFaWh3NTl0NGJjN2xIbnUvZDVIVS95cXRuRkJoQWRFbWpyakNpZk94TXYzSlFxZ ▶"
    1 => "laravel_session=eyJpdiI6InNib2ZrMXRkRXBsYUVBa1dXc29XbUE9PSIsInZhbHVlIjoiM2htaXNNQ2ZTUWEyQTd4SzdkQ0RBZGlYUWNic3ZYcUw2T2RlVHFlTkNVUVhOa0R0R3hTUkpOaXJhSlF4dlhpV1FDdzVEdjIrN2IzYkR6aUZ2N002N3VxRUlDckNvUGpYUXQrc3lNd2U0b3JwdXQzcEk0d0VPTWVNWWdhWWVIaW8iLCJtYWMiOiIyZmNmYjEwNzNmM2MwZjA5YjI3ZmZkMTIzNzk5MDA4ZjhlZThjYWI5OTJmYTQwNGI3MzRhOWViODQxNzJhODg0In0%3D; expires=Wed, 24-Nov-2027 18:52:11 GMT; Max-Age=72000000; path=/; httponly ◀laravel_session=eyJpdiI6InNib2ZrMXRkRXBsYUVBa1dXc29XbUE9PSIsInZhbHVlIjoiM2htaXNNQ2ZTUWEyQTd4SzdkQ0RBZGlYUWNic3ZYcUw2T2RlVHFlTkNVUVhOa0R0R3hTUkpOaXJhSlF4dlhpV1FD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBqYTkzUFFvb2ppVjhvOGxlZmh1YlE9PSIsInZhbHVlIjoidG0vRUorblhqdkNydmJ5S3JEc0lEdXhFaWh3NTl0NGJjN2xIbnUvZDVIVS95cXRuRkJoQWRFbWpyakNpZk94TXYzSlFxZWtuOS9QVXBxSUszMFNqY2R3ZEZOTDRJLzZUSHdYU0JZcnhoVjZEdXpoZ0VRR2FJaStCTmExLzRORXIiLCJtYWMiOiIzNGQ1M2IwODYyYTBjYTI5NzE3NGYzMmY2ODFjMGVjNDRlMmY5M2JjODUwZmY2MTBkMjM1YzFmMjJjNmJkYjg4In0%3D; expires=Wed, 24-Nov-2027 18:52:11 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InBqYTkzUFFvb2ppVjhvOGxlZmh1YlE9PSIsInZhbHVlIjoidG0vRUorblhqdkNydmJ5S3JEc0lEdXhFaWh3NTl0NGJjN2xIbnUvZDVIVS95cXRuRkJoQWRFbWpyakNpZk94TXYzSlFxZ ▶"
    1 => "laravel_session=eyJpdiI6InNib2ZrMXRkRXBsYUVBa1dXc29XbUE9PSIsInZhbHVlIjoiM2htaXNNQ2ZTUWEyQTd4SzdkQ0RBZGlYUWNic3ZYcUw2T2RlVHFlTkNVUVhOa0R0R3hTUkpOaXJhSlF4dlhpV1FDdzVEdjIrN2IzYkR6aUZ2N002N3VxRUlDckNvUGpYUXQrc3lNd2U0b3JwdXQzcEk0d0VPTWVNWWdhWWVIaW8iLCJtYWMiOiIyZmNmYjEwNzNmM2MwZjA5YjI3ZmZkMTIzNzk5MDA4ZjhlZThjYWI5OTJmYTQwNGI3MzRhOWViODQxNzJhODg0In0%3D; expires=Wed, 24-Nov-2027 18:52:11 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InNib2ZrMXRkRXBsYUVBa1dXc29XbUE9PSIsInZhbHVlIjoiM2htaXNNQ2ZTUWEyQTd4SzdkQ0RBZGlYUWNic3ZYcUw2T2RlVHFlTkNVUVhOa0R0R3hTUkpOaXJhSlF4dlhpV1FD ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "FW1BtZrcGiKvhXXIkHzQLN2t8xgpex32b4do4N9L"
  "cartSessionId" => 8043
  "_previous" => array:1 [▶
    "url" => "https://www.pasargad.com/products?shape=Oval&type=accessories"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Products

Categories

Collections

Styles

Materials

Weaves

Colors

Size

Shape

1 x Application (98.71%)	1.51s
1 x Booting (1.28%)	19.58ms