Medico Express | Online Pharmacy

Messages Timeline Exceptions Views23 Route Queries90 Models752 Mails Gate Session Request

7.4.331.94s29MBGET category/{category_slug}

Booting (247ms)
Application (1.69s)
1 x Application (87.11%)
1.69s
1 x Booting (12.74%)
246.95ms

23 templates were rendered

frontend.product_listing (resources/views/frontend/product_listing.blade.php)13blade


products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color

Params
0	`products`
1	`query`
2	`category_id`
3	`brand_id`
4	`sort_by`
5	`sort_by_a_z`
6	`seller_id`
7	`min_price`
8	`max_price`
9	`attributes`
10	`selected_attribute_values`
11	`colors`
12	`selected_color`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.product_box_1 (resources/views/frontend/partials/product_box_1.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

Params
0	`paginator`
1	`elements`

frontend.layouts.app (resources/views/frontend/layouts/app.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.inc.nav (resources/views/frontend/inc/nav.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.compare (resources/views/frontend/partials/compare.blade.php)25blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product
header_logo

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`
24	`header_logo`

frontend.partials.wishlist (resources/views/frontend/partials/wishlist.blade.php)25blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product
header_logo

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`
24	`header_logo`

frontend.partials.cart (resources/views/frontend/partials/cart.blade.php)25blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product
header_logo

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`
24	`header_logo`

frontend.partials.category_menu (resources/views/frontend/partials/category_menu.blade.php)25blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product
header_logo

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`
24	`header_logo`

frontend.partials.custom_category_menu (resources/views/frontend/partials/custom_category_menu.blade.php)25blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product
header_logo

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`
24	`header_logo`

frontend.inc.footer (resources/views/frontend/inc/footer.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

frontend.partials.modal (resources/views/frontend/partials/modal.blade.php)24blade


__env
app
errors
products
query
category_id
brand_id
sort_by
sort_by_a_z
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
meta_title
meta_description
__currentLoopData
loop
id
key
brand
product

Params
0	`__env`
1	`app`
2	`errors`
3	`products`
4	`query`
5	`category_id`
6	`brand_id`
7	`sort_by`
8	`sort_by_a_z`
9	`seller_id`
10	`min_price`
11	`max_price`
12	`attributes`
13	`selected_attribute_values`
14	`colors`
15	`selected_color`
16	`meta_title`
17	`meta_description`
18	`__currentLoopData`
19	`loop`
20	`id`
21	`key`
22	`brand`
23	`product`

uri: GET category/{category_slug}
middleware: web, twofactor
controller: App\Http\Controllers\SearchController@listingByCategory
namespace
prefix
where
as: products.category
file: app/Http/Controllers/SearchController.php:175-182

90 statements were executed, 57 of which were duplicated, 33 unique168ms

select * from `categories` where `slug` = 'health-care-g8kyo' limit 1

9.91ms/app/Http/Controllers/SearchController.php:177medicoexpress_uat

Metadata
Bindings	0. health-care-g8kyo
Backtrace	15. /app/Http/Controllers/SearchController.php:177 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `category_translations` where `category_translations`.`category_id` in (879)

670μs/app/Http/Controllers/SearchController.php:177medicoexpress_uat

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:177 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `attributes`

570μs/app/Http/Controllers/SearchController.php:26medicoexpress_uat

Metadata
Backtrace	15. /app/Http/Controllers/SearchController.php:26 16. /app/Http/Controllers/SearchController.php:179 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (12)

500μs/app/Http/Controllers/SearchController.php:26medicoexpress_uat

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:26 21. /app/Http/Controllers/SearchController.php:179 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `colors`

1.48ms/app/Http/Controllers/SearchController.php:28medicoexpress_uat

Metadata
Backtrace	15. /app/Http/Controllers/SearchController.php:28 16. /app/Http/Controllers/SearchController.php:179 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `categories` where `parent_id` = 879 order by `order_level` desc

930μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:35 16. /app/Utility/CategoryUtility.php:52 17. /app/Http/Controllers/SearchController.php:47 18. /app/Http/Controllers/SearchController.php:179

select * from `category_translations` where `category_translations`.`category_id` in (902, 903, 904)

510μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:35 21. /app/Utility/CategoryUtility.php:52 22. /app/Http/Controllers/SearchController.php:47 23. /app/Http/Controllers/SearchController.php:179

select * from `categories` where `parent_id` = 902 order by `order_level` desc

700μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 902
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:35 16. /app/Utility/CategoryUtility.php:41 17. /app/Utility/CategoryUtility.php:52 18. /app/Http/Controllers/SearchController.php:47

select * from `categories` where `parent_id` = 903 order by `order_level` desc

480μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 903
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:35 16. /app/Utility/CategoryUtility.php:41 17. /app/Utility/CategoryUtility.php:52 18. /app/Http/Controllers/SearchController.php:47

select * from `categories` where `parent_id` = 904 order by `order_level` desc

430μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 904
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:35 16. /app/Utility/CategoryUtility.php:41 17. /app/Utility/CategoryUtility.php:52 18. /app/Http/Controllers/SearchController.php:47

select `attribute_id` from `attribute_category` where `category_id` in (902, 903, 904, 879)

410μs/app/Http/Controllers/SearchController.php:52medicoexpress_uat

Metadata
Bindings	0. 902 1. 903 2. 904 3. 879
Backtrace	13. /app/Http/Controllers/SearchController.php:52 14. /app/Http/Controllers/SearchController.php:179 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `attributes` where 0 = 1

310μs/app/Http/Controllers/SearchController.php:53medicoexpress_uat

Metadata
Backtrace	14. /app/Http/Controllers/SearchController.php:53 15. /app/Http/Controllers/SearchController.php:179 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `products` where (`published` = 1) and `category_id` in (902, 903, 904, 879) and `name` like '%' and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin'

41.53ms/app/Http/Controllers/SearchController.php:165medicoexpress_uat

Metadata
Bindings	0. 1 1. 902 2. 903 3. 904 4. 879 5. % 6. 1 7. 0 8. admin
Backtrace	15. /app/Http/Controllers/SearchController.php:165 16. /app/Http/Controllers/SearchController.php:179 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `products` where (`published` = 1) and `category_id` in (902, 903, 904, 879) and `name` like '%' and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin' order by `name` asc limit 12 offset 12

33.82ms/app/Http/Controllers/SearchController.php:165medicoexpress_uat

Metadata
Bindings	0. 1 1. 902 2. 903 3. 904 4. 879 5. % 6. 1 7. 0 8. admin
Backtrace	15. /app/Http/Controllers/SearchController.php:165 16. /app/Http/Controllers/SearchController.php:179 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `product_translations` where `product_translations`.`product_id` in (9866, 9867, 9905, 9909, 10445, 10446, 10447, 10449, 10450, 10478, 12394, 13731)

1.17ms/app/Http/Controllers/SearchController.php:165medicoexpress_uat

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:165 21. /app/Http/Controllers/SearchController.php:179 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `product_taxes` where `product_taxes`.`product_id` in (9866, 9867, 9905, 9909, 10445, 10446, 10447, 10449, 10450, 10478, 12394, 13731)

680μs/app/Http/Controllers/SearchController.php:165medicoexpress_uat

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:165 21. /app/Http/Controllers/SearchController.php:179 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `categories` where `categories`.`id` = 879 limit 1

840μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:5medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:5 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

660μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:5medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:5 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

650μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:6medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:6 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

610μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:6medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:6 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

880μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:74medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:74 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

610μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:74medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:74 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

550μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:84medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:84 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

500μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:84medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:84 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

520μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:86medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:86 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

500μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:86medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:86 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `parent_id` = 879 order by `order_level` desc

770μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:90 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `category_translations` where `category_translations`.`category_id` in (902, 903, 904)

480μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:21 21. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:90 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `categories` where `categories`.`id` = 902 limit 1

520μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 902
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (902)

930μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 902 limit 1

430μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 902
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (902)

360μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 903 limit 1

390μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 903
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (903)

500μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 903 limit 1

490μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 903
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (903)

340μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 904 limit 1

510μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 904
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (904)

400μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 904 limit 1

590μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Bindings	0. 904
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (904)

410μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:92medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:92 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select count(*) as aggregate from `products`

8.21msview::bd167636a4356626daa4a92c0ed24b14de7c0abc:108medicoexpress_uat

Metadata
Backtrace	18. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:108 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select min(`unit_price`) as aggregate from `products`

720μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:108medicoexpress_uat

Metadata
Backtrace	18. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:108 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select count(*) as aggregate from `products`

8.24msview::bd167636a4356626daa4a92c0ed24b14de7c0abc:109medicoexpress_uat

Metadata
Backtrace	18. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:109 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select max(`unit_price`) as aggregate from `products`

640μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:109medicoexpress_uat

Metadata
Backtrace	18. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:109 20. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 21. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

970μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:215medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:215 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

400μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:215medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:215 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

320μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:215medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:215 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

290μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:215medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:215 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `categories`.`id` = 879 limit 1

410μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:225medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:225 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (879)

630μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:225medicoexpress_uat

Metadata
Backtrace	24. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:225 26. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 27. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 29. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `brands`

2.74msview::bd167636a4356626daa4a92c0ed24b14de7c0abc:246medicoexpress_uat

Metadata
Backtrace	15. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:246 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 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `brand_translations` where `brand_translations`.`brand_id` in (39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254)

2.88msview::bd167636a4356626daa4a92c0ed24b14de7c0abc:246medicoexpress_uat

Metadata
Backtrace	20. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:246 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '100864' and `uploads`.`deleted_at` is null limit 1

950μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 100864
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '100867' and `uploads`.`deleted_at` is null limit 1

810μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 100867
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '100870' and `uploads`.`deleted_at` is null limit 1

760μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 100870
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '100873' and `uploads`.`deleted_at` is null limit 1

760μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 100873
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '60584' and `uploads`.`deleted_at` is null limit 1

720μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 60584
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '99706' and `uploads`.`deleted_at` is null limit 1

860μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 99706
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '59225' and `uploads`.`deleted_at` is null limit 1

1.04ms/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 59225
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '100945' and `uploads`.`deleted_at` is null limit 1

930μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 100945
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '' and `uploads`.`deleted_at` is null limit 1

1.14ms/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0.
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '99790' and `uploads`.`deleted_at` is null limit 1

990μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 99790
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '99799' and `uploads`.`deleted_at` is null limit 1

650μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 99799
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '102841' and `uploads`.`deleted_at` is null limit 1

900μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 102841
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `languages` where `code` = 'en' limit 1

990μsview::3531c2674ebd00a5977981e229d09d99a32d4da4:2medicoexpress_uat

Metadata
Bindings	0. en
Backtrace	15. view::3531c2674ebd00a5977981e229d09d99a32d4da4:2 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 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

750μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

790μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

690μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '676' and `uploads`.`deleted_at` is null limit 1

1.07ms/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 676
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `languages` where `code` = 'en' limit 1

550μsview::3531c2674ebd00a5977981e229d09d99a32d4da4:56medicoexpress_uat

Metadata
Bindings	0. en
Backtrace	15. view::3531c2674ebd00a5977981e229d09d99a32d4da4:56 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 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '12' and `uploads`.`deleted_at` is null limit 1

1.57ms/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 12
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `level` = 0 order by `order_level` desc

1.18msview::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:9medicoexpress_uat

Metadata
Bindings	0. 0
Backtrace	14. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:9 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (878, 879, 880)

820μsview::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:9medicoexpress_uat

Metadata
Backtrace	19. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:9 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

600μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `parent_id` = 878 order by `order_level` desc

1.23ms/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 878
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:22 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `category_translations` where `category_translations`.`category_id` in (881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900)

510μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:21 21. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:22 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

920μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `parent_id` = 879 order by `order_level` desc

920μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:22 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `category_translations` where `category_translations`.`category_id` in (902, 903, 904)

560μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:21 21. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:22 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

720μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `parent_id` = 880 order by `order_level` desc

770μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 880
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::dd7a9efdf97c3f8b1b681797c5a067181c65ff16:22 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `categories` where `level` = 0 order by `order_level` desc

1.1msview::b2b6758a17494fd41f945cd6d64b0ea922e08a18:9medicoexpress_uat

Metadata
Bindings	0. 0
Backtrace	14. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:9 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `category_translations` where `category_translations`.`category_id` in (878, 879, 880)

860μsview::b2b6758a17494fd41f945cd6d64b0ea922e08a18:9medicoexpress_uat

Metadata
Backtrace	19. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:9 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/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `parent_id` = 878 order by `order_level` desc

1.38ms/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 878
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:14 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `category_translations` where `category_translations`.`category_id` in (881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900)

760μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:21 21. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:14 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `categories` where `parent_id` = 879 order by `order_level` desc

1.29ms/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 879
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:14 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `category_translations` where `category_translations`.`category_id` in (902, 903, 904)

640μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Backtrace	19. /app/Utility/CategoryUtility.php:12 20. /app/Utility/CategoryUtility.php:21 21. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:14 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `categories` where `parent_id` = 880 order by `order_level` desc

820μs/app/Utility/CategoryUtility.php:12medicoexpress_uat

Metadata
Bindings	0. 880
Backtrace	14. /app/Utility/CategoryUtility.php:12 15. /app/Utility/CategoryUtility.php:21 16. view::b2b6758a17494fd41f945cd6d64b0ea922e08a18:14 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `uploads` where `uploads`.`id` = '675' and `uploads`.`deleted_at` is null limit 1

890μs/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 675
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `uploads` where `uploads`.`id` = '71880' and `uploads`.`deleted_at` is null limit 1

1.05ms/app/Http/Helpers.php:950medicoexpress_uat

Metadata
Bindings	0. 71880
Backtrace	19. /app/Http/Helpers.php:950 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

App\Models\Language: 2
App\Models\Upload: 15
App\Models\BrandTranslation: 216
App\Models\Brand: 216
App\Models\Product: 12
App\Models\Color: 143
App\Models\AttributeTranslation: 1
App\Models\Attribute: 1
App\Models\CategoryTranslation: 73
App\Models\Category: 73

_token: jyjhGKUDSC5WgbAh1LpFuz47JDFPhcV7VcVtxtld
locale: en
_previous: array:1 [ "url" => "https://ns2.medicoexpress.com/category/health-care-g8kyo?page=2" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/category/health-care-g8kyo

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_request

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_headers

  0 of 0   
array:16 [▼
  "x-https" => array:1 [▶
    0 => "1"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "ns2.medicoexpress.com"
  ]
]

request_server

  0 of 0   
array:58 [▼
  "USER" => "medicoexpress"
  "HOME" => "/home/medicoexpress"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/category/health-care-g8kyo?page=2"
  "QUERY_STRING" => "page=2"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "page=2"
  "REDIRECT_URL" => "/category/health-care-g8kyo"
  "REMOTE_PORT" => "33181"
  "SCRIPT_FILENAME" => "/home/medicoexpress/public_html/index.php"
  "SERVER_ADMIN" => "webmaster@medicoexpress.com"
  "CONTEXT_DOCUMENT_ROOT" => "/home/medicoexpress/public_html"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/medicoexpress/public_html"
  "REMOTE_ADDR" => "18.191.4.164"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "192.168.74.52"
  "SERVER_NAME" => "ns2.medicoexpress.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_X_HTTPS" => "1"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "ns2.medicoexpress.com"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "ns2.medicoexpress.com"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://ns2.medicoexpress.com/category/health-care-g8kyo"
  "SCRIPT_URL" => "/category/health-care-g8kyo"
  "UNIQUE_ID" => "Z_kAPK9NCa4cQ_arfPcSIwAAAI8"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "ns2.medicoexpress.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://ns2.medicoexpress.com/category/health-care-g8kyo"
  "REDIRECT_SCRIPT_URL" => "/category/health-care-g8kyo"
  "REDIRECT_UNIQUE_ID" => "Z_kAPK9NCa4cQ_arfPcSIwAAAI8"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744371772.6647
  "REQUEST_TIME" => 1744371772
  "argv" => array:1 [▶
    0 => "page=2"
  ]
  "argc" => 1
]

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 => "Fri, 11 Apr 2025 11:42:53 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=jyjhGKUDSC5WgbAh1LpFuz47JDFPhcV7VcVtxtld; expires=Fri, 11-Apr-2025 13:42:54 GMT; Max-Age=7200; path=/"
    1 => "medico_express_online_pharmacy_session=DTJVvgK7mrZDsrYLuyYTeyqcRBRFMaU9q22rCUVD; expires=Fri, 11-Apr-2025 13:42:54 GMT; Max-Age=7200; path=/; httponly"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=jyjhGKUDSC5WgbAh1LpFuz47JDFPhcV7VcVtxtld; expires=Fri, 11-Apr-2025 13:42:54 GMT; path=/"
    1 => "medico_express_online_pharmacy_session=DTJVvgK7mrZDsrYLuyYTeyqcRBRFMaU9q22rCUVD; expires=Fri, 11-Apr-2025 13:42:54 GMT; path=/; httponly"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "jyjhGKUDSC5WgbAh1LpFuz47JDFPhcV7VcVtxtld"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://ns2.medicoexpress.com/category/health-care-g8kyo?page=2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Aquasoft Fc Cream 60 gm

Aquasoft Max 100 gm Cream

Aquasoft Max 150 gm Cream

Aquasoft Max Lotion 200 ml

Aquasoft Moisturising Lotion 100 ml

Ascabiol Emulsion 120ml Liq

Ascabiol Emulsion 50 ml Liquid

Blise Face Wash 100gm

Caladryl Lotion 65Ml

Candy Cop Bubblegum Flavour Tooth Paste 70gm

Canesten V6 Tablet 6's

Cetaphil cleansing & moisturising syndet bar 75gm

Contact Info

Quick Links

My Account

1 x Application (87.11%)	1.69s
1 x Booting (12.74%)	246.95ms

Filters

Health Care

Contact Info

Quick Links

My Account