Shamrock Equi-Li

Messages Timeline Exceptions Views16 Route Queries89 Models220 Mails Auth Gate Session Request

7.3.33993ms32MBGET products/{slug}

Booting (449ms)
Application (541ms)
1 x Application (54.53%)
541.31ms
1 x Booting (45.23%)
449.06ms

16 templates were rendered

templates.product_single (resources/themes/reflex/templates/product_single.blade.php)2blade
Params
0
product
1
availableForCheckout

Params
0	`product`
1	`availableForCheckout`

partials.tabs.desc (resources/themes/reflex/partials/tabs/desc.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

partials.tabs.specifications (resources/themes/reflex/partials/tabs/specifications.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

partials.tabs.reviews (resources/themes/reflex/partials/tabs/reviews.blade.php)21blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
reviews
rating
rating_count

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`reviews`
19	`rating`
20	`rating_count`

partials.tabs.faqs (resources/themes/reflex/partials/tabs/faqs.blade.php)19blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
faqs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`faqs`

partials.tabs.images (resources/themes/reflex/partials/tabs/images.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

partials.tabs.desc (resources/themes/reflex/partials/tabs/desc.blade.php)19blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
img

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`img`

partials.tabs.specifications (resources/themes/reflex/partials/tabs/specifications.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

partials.tabs.reviews (resources/themes/reflex/partials/tabs/reviews.blade.php)21blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
reviews
rating
rating_count

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`reviews`
19	`rating`
20	`rating_count`

partials.tabs.faqs (resources/themes/reflex/partials/tabs/faqs.blade.php)19blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
faqs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`faqs`

partials.tabs.images (resources/themes/reflex/partials/tabs/images.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

layouts.master (resources/themes/reflex/layouts/master.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

partials.header (resources/themes/reflex/partials/header.blade.php)19blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
homepage

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`homepage`

partials..components.mobile_menu (resources/themes/reflex/partials/components/mobile_menu.blade.php)20blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
homepage
menu

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`homepage`
19	`menu`

partials.footer (resources/themes/reflex/partials/footer.blade.php)18blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`

components.modal (resources/themes/reflex/components/modal.blade.php)19blade


obLevel
__env
app
top_level_cats
buy_now_cats
errors
title_singular
title
resource_url
product
availableForCheckout
__currentLoopData
category
loop
medias
key
row
sku
id

Params
0	`obLevel`
1	`__env`
2	`app`
3	`top_level_cats`
4	`buy_now_cats`
5	`errors`
6	`title_singular`
7	`title`
8	`resource_url`
9	`product`
10	`availableForCheckout`
11	`__currentLoopData`
12	`category`
13	`loop`
14	`medias`
15	`key`
16	`row`
17	`sku`
18	`id`

uri: GET products/{slug}
middleware: web
as: products.show
controller: Corals\Modules\Ecommerce\Http\Controllers\ShopPublicController@show
namespace: Corals\Modules\Ecommerce\Http\Controllers
prefix: /products
where
file: Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:499-662

89 statements were executed, 22 of which were duplicated, 67 unique52.23ms

select * from `ecommerce_categories` where (`parent_id` = 0 and `status` = 'active') order by `name` asc1.04ms/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:21farmcompare_staging

Metadata
Bindings	0. 0 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:21 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 179 and `status` = 'active') order by `name` asc620μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 179 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 13 and `status` = 'active') order by `name` asc630μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 13 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 112 and `status` = 'active') order by `name` asc510μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 112 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 178 and `status` = 'active') order by `name` asc540μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 178 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 70 and `status` = 'active') order by `name` asc600μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 70 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 146 and `status` = 'active') order by `name` asc670μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 146 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 29 and `status` = 'active') order by `name` asc720μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 29 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 19 and `status` = 'active') order by `name` asc700μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 19 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 60 and `status` = 'active') order by `name` asc650μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 60 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 323 and `status` = 'active') order by `name` asc620μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 323 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 114 and `status` = 'active') order by `name` asc750μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 114 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 299 and `status` = 'active') order by `name` asc680μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 299 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 245 and `status` = 'active') order by `name` asc650μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 245 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 302 and `status` = 'active') order by `name` asc590μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 302 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 123 and `status` = 'active') order by `name` asc640μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 123 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 258 and `status` = 'active') order by `name` asc510μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 258 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 51 and `status` = 'active') order by `name` asc680μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 51 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 22 and `status` = 'active') order by `name` asc610μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 22 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 45 and `status` = 'active') order by `name` asc630μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 45 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 180 and `status` = 'active') order by `name` asc590μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 180 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 247 and `status` = 'active') order by `name` asc600μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 247 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 2 and `status` = 'active') order by `name` asc710μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23farmcompare_staging

Metadata
Bindings	0. 2 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:23 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `ecommerce_categories` where (`parent_id` = 51 and `status` = 'active') order by `name` asc640μs/Corals/core/Foundation/Http/Controllers/PublicBaseController.php:32farmcompare_staging

Metadata
Bindings	0. 51 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/core/Foundation/Http/Controllers/PublicBaseController.php:32 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:812 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:658 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:609 19. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:759

select * from `currencies`1.26ms/vendor/torann/currency/src/Drivers/Database.php:62farmcompare_staging

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	12. /vendor/torann/currency/src/Drivers/Database.php:62 13. /vendor/torann/currency/src/Currency.php:242 14. /vendor/torann/currency/src/Currency.php:230 15. /vendor/torann/currency/src/Currency.php:215 16. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:47

select * from `ecommerce_products` where `slug` = 'shamrock-equi-li' limit 1450μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:501farmcompare_staging

Metadata
Bindings	0. shamrock-equi-li
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:501 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_extras_product` where `ecommerce_extras_product`.`product_id` = 2147 and `ecommerce_extras_product`.`product_id` is not null

880μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:507 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 2147 and `ecommerce_categories`.`status` = 'active'

600μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147 1. active
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:519 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `ecommerce_tags`.*, `ecommerce_product_tag`.`product_id` as `pivot_product_id`, `ecommerce_product_tag`.`tag_id` as `pivot_tag_id` from `ecommerce_tags` inner join `ecommerce_product_tag` on `ecommerce_tags`.`id` = `ecommerce_product_tag`.`tag_id` where `ecommerce_product_tag`.`product_id` = 2147 and `ecommerce_tags`.`status` = 'active'

480μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147 1. active
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:520 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `media` where `media`.`model_id` = 2147 and `media`.`model_id` is not null and `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Product'

510μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /vendor/spatie/laravel-medialibrary/src/HasMedia/HasMediaTrait.php:508 22. /vendor/spatie/laravel-medialibrary/src/MediaRepository.php:34 23. /vendor/spatie/laravel-medialibrary/src/HasMedia/HasMediaTrait.php:237

select `label`, `id` from `ecommerce_attributes` where (`use_as_filter` = 1)1.16ms/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:543farmcompare_staging

Metadata
Bindings	0. 1
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:543 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_sku` where `ecommerce_sku`.`product_id` = 2147 and `ecommerce_sku`.`product_id` is not null and `ecommerce_sku`.`status` = 'active'

450μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147 1. active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:544 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `ecommerce_sku_options` where `ecommerce_sku_options`.`sku_id` = 2184 and `ecommerce_sku_options`.`sku_id` is not null

460μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2184
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:544 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `label` from `ecommerce_attributes` where `id` = '740'260μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548farmcompare_staging

Metadata
Bindings	0. 740
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `hide_from_view` from `ecommerce_attributes` where `id` = '740'240μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549farmcompare_staging

Metadata
Bindings	0. 740
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4340' limit 1300μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4340
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4340' limit 1280μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4340
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `label` from `ecommerce_attributes` where `id` = '741'240μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548farmcompare_staging

Metadata
Bindings	0. 741
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `hide_from_view` from `ecommerce_attributes` where `id` = '741'260μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549farmcompare_staging

Metadata
Bindings	0. 741
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4626' limit 1310μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4626
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4626' limit 1300μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4626
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `label` from `ecommerce_attributes` where `id` = '742'240μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548farmcompare_staging

Metadata
Bindings	0. 742
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `hide_from_view` from `ecommerce_attributes` where `id` = '742'240μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549farmcompare_staging

Metadata
Bindings	0. 742
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4621' limit 1260μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4621
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4621' limit 1300μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4621
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `label` from `ecommerce_attributes` where `id` = '743'250μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548farmcompare_staging

Metadata
Bindings	0. 743
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:548 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `hide_from_view` from `ecommerce_attributes` where `id` = '743'250μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549farmcompare_staging

Metadata
Bindings	0. 743
Backtrace	13. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:549 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4622' limit 1300μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4622
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4622' limit 1240μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550farmcompare_staging

Metadata
Bindings	0. 4622
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:550 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_sku_options` where `ecommerce_sku_options`.`sku_id` = 2184 and `ecommerce_sku_options`.`sku_id` is not null

380μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:558farmcompare_staging

Metadata
Bindings	0. 2184
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:558 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4340' limit 1280μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561farmcompare_staging

Metadata
Bindings	0. 4340
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4626' limit 1300μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561farmcompare_staging

Metadata
Bindings	0. 4626
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4621' limit 1290μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561farmcompare_staging

Metadata
Bindings	0. 4621
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_attribute_options` where `id` = '4622' limit 1280μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561farmcompare_staging

Metadata
Bindings	0. 4622
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:561 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `ecommerce_categories`.*, `ecommerce_category_product`.`product_id` as `pivot_product_id`, `ecommerce_category_product`.`category_id` as `pivot_category_id` from `ecommerce_categories` inner join `ecommerce_category_product` on `ecommerce_categories`.`id` = `ecommerce_category_product`.`category_id` where `ecommerce_category_product`.`product_id` = 2147

430μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 21. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:575 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `ecommerce_categories` where `id` = '245' limit 1320μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:604farmcompare_staging

Metadata
Bindings	0. 245
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	15. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:604 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_product_video` where `product_id` = 21472.04ms/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:609farmcompare_staging

Metadata
Bindings	0. 2147
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:609 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `id` from `ecommerce_categories` where `ecommerce_categories`.`id` = 294 or (`ecommerce_categories`.`parent_id` = 294 and `ecommerce_categories`.`parent_id` <> 0) or `ecommerce_categories`.`slug` = 294

720μs/Corals/modules/Ecommerce/Classes/Shop.php:271farmcompare_staging

Metadata
Bindings	0. 294 1. 294 2. 0 3. 294
Backtrace	13. /Corals/modules/Ecommerce/Classes/Shop.php:271 14. /Corals/modules/Ecommerce/Classes/Shop.php:339 15. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237 16. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:644 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `ecommerce_products`.* from `ecommerce_products` inner join `ecommerce_category_product` on `ecommerce_category_product`.`product_id` = `ecommerce_products`.`id` inner join `ecommerce_categories` on `ecommerce_category_product`.`category_id` = `ecommerce_categories`.`id` where exists (select * from `ecommerce_sku` where `ecommerce_products`.`id` = `ecommerce_sku`.`product_id` and `ecommerce_sku`.`status` = 'active') and `ecommerce_products`.`status` = 'active' and (`ecommerce_categories`.`id` in (294) or `ecommerce_categories`.`parent_id` in (294)) and `ecommerce_categories`.`status` = 'active'

1.43ms/Corals/modules/Ecommerce/Classes/Shop.php:347farmcompare_staging

Metadata
Bindings	0. active 1. active 2. 294 3. 294 4. active
Backtrace	14. /Corals/modules/Ecommerce/Classes/Shop.php:347 15. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237 16. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:644 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 1659 limit 1640μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 1659
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 1663 limit 1650μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 1663
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2020 limit 1630μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2020
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2021 limit 1650μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2021
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2022 limit 1620μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2022
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2023 limit 1650μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2023
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2024 limit 1600μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2024
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2025 limit 1650μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2025
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2027 limit 1630μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2027
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2028 limit 1630μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2028
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2029 limit 1610μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2029
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2030 limit 1620μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2030
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2031 limit 1590μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2031
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2032 limit 1640μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2032
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2033 limit 1620μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2033
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2034 limit 1680μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2034
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2035 limit 1610μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2035
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2144 limit 1620μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2144
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2145 limit 1640μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2145
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2146 limit 1620μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2146
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select count(*) as aggregate from `ecommerce_extras_product` where `product_id` = 2147 limit 1640μs/Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648farmcompare_staging

Metadata
Bindings	0. 2147
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /Corals/modules/Ecommerce/Http/Controllers/ShopPublicController.php:648 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select * from `ecommerce_brands` where `ecommerce_brands`.`id` = '78' limit 1360μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 78
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	19. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 21. /Corals/core/Foundation/Traits/Hookable.php:128 22. view::templates.product_single:68 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 25. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select * from `media` where `media`.`model_id` = 78 and `media`.`model_id` is not null and `media`.`model_type` = 'Corals\Modules\Ecommerce\Models\Brand'

490μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 78 1. Corals\Modules\Ecommerce\Models\Brand
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. /vendor/spatie/laravel-medialibrary/src/HasMedia/HasMediaTrait.php:508 22. /vendor/spatie/laravel-medialibrary/src/MediaRepository.php:34 23. /vendor/spatie/laravel-medialibrary/src/HasMedia/HasMediaTrait.php:237

select * from `utility_ratings` where `utility_ratings`.`reviewrateable_id` = 2147 and `utility_ratings`.`reviewrateable_id` is not null and `utility_ratings`.`reviewrateable_type` = 'Corals\Modules\Ecommerce\Models\Product' order by `created_at` desc

570μs/Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Corals/core/Settings/Traits/CustomFieldsModelTrait.php:268 20. /Corals/core/Foundation/Traits/Hookable.php:128 21. view::templates.product_single:292 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select ROUND(AVG(rating), 1) as averageReviewRateable from `utility_ratings` where `utility_ratings`.`reviewrateable_id` = 2147 and `utility_ratings`.`reviewrateable_id` is not null and `utility_ratings`.`reviewrateable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_ratings`.`status` = 'approved' order by `created_at` desc

490μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product 2. approved
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 15. /Corals/modules/Utility/Traits/Rating/ReviewRateable.php:62 16. view::templates.product_single:293 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select count(rating) as countReviewRateable from `utility_ratings` where `utility_ratings`.`reviewrateable_id` = 2147 and `utility_ratings`.`reviewrateable_id` is not null and `utility_ratings`.`reviewrateable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_ratings`.`status` = 'approved' order by `created_at` desc

410μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product 2. approved
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 15. /Corals/modules/Utility/Traits/Rating/ReviewRateable.php:78 16. view::templates.product_single:294 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select * from `ecommerce_product_post` inner join `posts` on `ecommerce_product_post`.`post_id` = `posts`.`id` where `product_id` = 2147

1.66ms/Corals/modules/Ecommerce/Models/Product.php:262farmcompare_staging

Metadata
Bindings	0. 2147
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /Corals/modules/Ecommerce/Models/Product.php:262 13. view::templates.product_single:303 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 16. /vendor/laravel/framework/src/Illuminate/View/View.php:142 17. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select ROUND(AVG(rating), 1) as averageReviewRateable from `utility_ratings` where `utility_ratings`.`reviewrateable_id` = 2147 and `utility_ratings`.`reviewrateable_id` is not null and `utility_ratings`.`reviewrateable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_ratings`.`status` = 'approved' order by `created_at` desc

430μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product 2. approved
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 15. /Corals/modules/Utility/Traits/Rating/ReviewRateable.php:62 16. view::templates.product_single:373 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select count(rating) as countReviewRateable from `utility_ratings` where `utility_ratings`.`reviewrateable_id` = 2147 and `utility_ratings`.`reviewrateable_id` is not null and `utility_ratings`.`reviewrateable_type` = 'Corals\Modules\Ecommerce\Models\Product' and `utility_ratings`.`status` = 'approved' order by `created_at` desc

410μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23farmcompare_staging

Metadata
Bindings	0. 2147 1. Corals\Modules\Ecommerce\Models\Product 2. approved
Backtrace	13. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 15. /Corals/modules/Utility/Traits/Rating/ReviewRateable.php:78 16. view::templates.product_single:374 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select * from `ecommerce_product_post` inner join `posts` on `ecommerce_product_post`.`post_id` = `posts`.`id` where `product_id` = 2147

1.6ms/Corals/modules/Ecommerce/Models/Product.php:262farmcompare_staging

Metadata
Bindings	0. 2147
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /Corals/modules/Ecommerce/Models/Product.php:262 13. view::templates.product_single:384 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 16. /vendor/laravel/framework/src/Illuminate/View/View.php:142 17. /vendor/laravel/framework/src/Illuminate/View/View.php:125

Corals\Modules\Ecommerce\Models\Brand: 1
Corals\Modules\Ecommerce\Models\AttributeOption: 12
Corals\Modules\Ecommerce\Models\Attribute: 4
Corals\Modules\Ecommerce\Models\SKUOption: 8
Corals\Modules\Ecommerce\Models\SKU: 1
Spatie\MediaLibrary\Models\Media: 3
Corals\Modules\Ecommerce\Models\Product: 22
Corals\Modules\Ecommerce\Models\Category: 169

web: null
api: null

_token: jlWl0Nk6j8Ql4QhU8EFaNWdHfZJcLh8NwTcMYaGg
currency: GBP
shoppingcart: array:2 [ "instance" => "default" "instances" => array:1 [ 0 => "default" ] ]
_previous: array:1 [ "url" => "https://www.staging.farmcompare.com/products/shamrock-equi-li?currency=GBP" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products/shamrock-equi-li

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▶
  "currency" => "GBP"
]

request_request

  0 of 0   
array:1 [▶
  "currency" => "GBP"
]

request_headers

  0 of 0   
array:15 [▶
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "www.staging.farmcompare.com"
  ]
]

request_server

  0 of 0   
array:53 [▶
  "USER" => "farmcompare"
  "HOME" => "/home/farmcompare"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/products/shamrock-equi-li?currency=GBP"
  "QUERY_STRING" => "currency=GBP"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "currency=GBP"
  "REDIRECT_URL" => "/products/shamrock-equi-li"
  "REMOTE_PORT" => "2909"
  "SCRIPT_FILENAME" => "/home/farmcompare/staging.farmcompare.com/index.php"
  "SERVER_ADMIN" => "webmaster@staging.farmcompare.com"
  "CONTEXT_DOCUMENT_ROOT" => "/home/farmcompare/staging.farmcompare.com"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/farmcompare/staging.farmcompare.com"
  "REMOTE_ADDR" => "18.189.170.45"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "185.211.22.175"
  "SERVER_NAME" => "www.staging.farmcompare.com"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "www.staging.farmcompare.com"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "www.staging.farmcompare.com"
  "HTTPS" => "on"
  "UNIQUE_ID" => "aBo1wEs3FvASeuk1q7Z8ygAAAA4"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "www.staging.farmcompare.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_UNIQUE_ID" => "aBo1wEs3FvASeuk1q7Z8ygAAAA4"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746548160.7813
  "REQUEST_TIME" => 1746548160
  "argv" => array:1 [▶
    0 => "currency=GBP"
  ]
  "argc" => 1
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 16:16:01 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilo5SjNYV0dkRDJkdE84TmttODZqTEE9PSIsInZhbHVlIjoiRkJPYzJlemNvWmFPSXRlTzhRV0JJQ1puelVCcUVlUDB4WnFCN08rMEpKdkdvXC9PWWY4cnFLaGhvN1JHN3pGQjMiLCJtYWMiOiJiZDhhYTc2ZmYxNjkxZWUzYTljYjhiYWRkOTAxMDM5YmNiM2E4NGM1NjFiMTY0NWQ0YjJlNTVjZmQ2MTE4ZmI4In0%3D; expires=Tue, 06-May-2025 18:16:01 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ilo5SjNYV0dkRDJkdE84TmttODZqTEE9PSIsInZhbHVlIjoiRkJPYzJlemNvWmFPSXRlTzhRV0JJQ1puelVCcUVlUDB4WnFCN08rMEpKdkdvXC9PWWY4cnFLaGhvN1JHN3pGQjMiLCJtY ▶"
    1 => "farmcompare_session=eyJpdiI6ImVrM1lRZHR2NmdhRk02UHVQdytGcnc9PSIsInZhbHVlIjoiTWNTdTFBYUN4XC9ncGRpUzdZZWJnTHNkcUxvWFZtb0RvWEVtK090UUtKTTBGbDVlNlhpUGN2b2cyaUJrOWY2RFMiLCJtYWMiOiI4NWY4MDc0ODZlZWJkYzU1NDkyMzc4MzU4ODI1OTUzM2NkOTI0NTQ2MjAwMTRkNjU2MGVjNTA4YjQ0MjMwYjgyIn0%3D; expires=Tue, 06-May-2025 18:16:01 GMT; Max-Age=7200; path=/; httponly ◀farmcompare_session=eyJpdiI6ImVrM1lRZHR2NmdhRk02UHVQdytGcnc9PSIsInZhbHVlIjoiTWNTdTFBYUN4XC9ncGRpUzdZZWJnTHNkcUxvWFZtb0RvWEVtK090UUtKTTBGbDVlNlhpUGN2b2cyaUJrOWY2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ilo5SjNYV0dkRDJkdE84TmttODZqTEE9PSIsInZhbHVlIjoiRkJPYzJlemNvWmFPSXRlTzhRV0JJQ1puelVCcUVlUDB4WnFCN08rMEpKdkdvXC9PWWY4cnFLaGhvN1JHN3pGQjMiLCJtYWMiOiJiZDhhYTc2ZmYxNjkxZWUzYTljYjhiYWRkOTAxMDM5YmNiM2E4NGM1NjFiMTY0NWQ0YjJlNTVjZmQ2MTE4ZmI4In0%3D; expires=Tue, 06-May-2025 18:16:01 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ilo5SjNYV0dkRDJkdE84TmttODZqTEE9PSIsInZhbHVlIjoiRkJPYzJlemNvWmFPSXRlTzhRV0JJQ1puelVCcUVlUDB4WnFCN08rMEpKdkdvXC9PWWY4cnFLaGhvN1JHN3pGQjMiLCJtY ▶"
    1 => "farmcompare_session=eyJpdiI6ImVrM1lRZHR2NmdhRk02UHVQdytGcnc9PSIsInZhbHVlIjoiTWNTdTFBYUN4XC9ncGRpUzdZZWJnTHNkcUxvWFZtb0RvWEVtK090UUtKTTBGbDVlNlhpUGN2b2cyaUJrOWY2RFMiLCJtYWMiOiI4NWY4MDc0ODZlZWJkYzU1NDkyMzc4MzU4ODI1OTUzM2NkOTI0NTQ2MjAwMTRkNjU2MGVjNTA4YjQ0MjMwYjgyIn0%3D; expires=Tue, 06-May-2025 18:16:01 GMT; path=/; httponly ◀farmcompare_session=eyJpdiI6ImVrM1lRZHR2NmdhRk02UHVQdytGcnc9PSIsInZhbHVlIjoiTWNTdTFBYUN4XC9ncGRpUzdZZWJnTHNkcUxvWFZtb0RvWEVtK090UUtKTTBGbDVlNlhpUGN2b2cyaUJrOWY2 ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "jlWl0Nk6j8Ql4QhU8EFaNWdHfZJcLh8NwTcMYaGg"
  "currency" => "GBP"
  "shoppingcart" => array:2 [▶
    "instance" => "default"
    "instances" => array:1 [▶
      0 => "default"
    ]
  ]
  "_previous" => array:1 [▶
    "url" => "https://www.staging.farmcompare.com/products/shamrock-equi-li?currency=GBP"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Browse products

Search Farm Compare:

Buy Now

Shamrock Equi-Li

Specification for Shamrock Equi-Li

Leave a Review

Ask a Question

Description

Specifications

Reviews

Leave a Review

Q&A's

Ask a Question

Images

Get in touch

1 x Application (54.53%)	541.31ms
1 x Booting (45.23%)	449.06ms