Medico Express

Messages Timeline Exceptions Views23 Route Queries54 Models721 Mails Gate Session Request

7.4.332.01s29MBGET search

Booting (322ms)
Application (1.69s)
1 x Application (83.85%)
1.69s
1 x Booting (16.01%)
322.17ms

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)26blade


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

Params
0	`paginator`
1	`elements`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`
26	`header_logo`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`
26	`header_logo`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`
26	`header_logo`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`
26	`header_logo`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`
26	`header_logo`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

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


__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
category
loop
key
attribute
attribute_value
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	`category`
20	`loop`
21	`key`
22	`attribute`
23	`attribute_value`
24	`brand`
25	`product`

uri: GET search
middleware: web, twofactor
controller: App\Http\Controllers\SearchController@index
namespace
prefix
where
as: search
file: app/Http/Controllers/SearchController.php:18-168

54 statements were executed, 35 of which were duplicated, 19 unique425ms

select * from `attributes`

4.72ms/app/Http/Controllers/SearchController.php:26medicoexpress_uat

Metadata
Backtrace	15. /app/Http/Controllers/SearchController.php:26 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 `attribute_translations` where `attribute_translations`.`attribute_id` in (12)

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

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:26 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 `colors`

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

Metadata
Backtrace	15. /app/Http/Controllers/SearchController.php:28 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 count(*) as aggregate from `products` where (`published` = 1) and `name` like '%' and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin'

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

Metadata
Bindings	0. 1 1. % 2. 1 3. 0 4. admin
Backtrace	15. /app/Http/Controllers/SearchController.php:165 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 `products` where (`published` = 1) and `name` like '%' and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin' order by `name` asc limit 12 offset 15408

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

Metadata
Bindings	0. 1 1. % 2. 1 3. 0 4. admin
Backtrace	15. /app/Http/Controllers/SearchController.php:165 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 `product_translations` where `product_translations`.`product_id` in (12224, 12225, 16100, 24263, 24978, 24979, 25011, 25012, 25013, 25014, 25015, 25016)

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

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:165 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 `product_taxes` where `product_taxes`.`product_id` in (12224, 12225, 16100, 24263, 24978, 24979, 25011, 25012, 25013, 25014, 25015, 25016)

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

Metadata
Backtrace	20. /app/Http/Controllers/SearchController.php:165 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 `categories` where `level` = 0

1.01msview::bd167636a4356626daa4a92c0ed24b14de7c0abc:61medicoexpress_uat

Metadata
Bindings	0. 0
Backtrace	14. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:61 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)

550μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:61medicoexpress_uat

Metadata
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:61 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 count(*) as aggregate from `products`

7.12msview::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`

600μ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`

6.81msview::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`

360μ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 `attribute_values` where `attribute_values`.`attribute_id` = 12 and `attribute_values`.`attribute_id` is not null

630μsview::bd167636a4356626daa4a92c0ed24b14de7c0abc:150medicoexpress_uat

Metadata
Bindings	0. 12
Backtrace	19. view::bd167636a4356626daa4a92c0ed24b14de7c0abc:150 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 `brands`

1.56msview::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)

1.3msview::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` = '' and `uploads`.`deleted_at` is null limit 1

870μs/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` = '' and `uploads`.`deleted_at` is null limit 1

700μs/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` = '' and `uploads`.`deleted_at` is null limit 1

900μs/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` = '' and `uploads`.`deleted_at` is null limit 1

750μs/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` = '102511' and `uploads`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 102511
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` = '102514' and `uploads`.`deleted_at` is null limit 1

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

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

870μs/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` = '' and `uploads`.`deleted_at` is null limit 1

810μs/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` = '' and `uploads`.`deleted_at` is null limit 1

750μs/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` = '' and `uploads`.`deleted_at` is null limit 1

710μs/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` = '' and `uploads`.`deleted_at` is null limit 1

650μs/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` = '' and `uploads`.`deleted_at` is null limit 1

830μs/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 `languages` where `code` = 'en' limit 1

860μ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

740μ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

590μ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

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 `uploads` where `uploads`.`id` = '676' and `uploads`.`deleted_at` is null limit 1

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

740μ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

660μs/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

780μsview::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)

440μ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

300μ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

770μs/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

540μ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

610μ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)

530μ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

410μ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

420μ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

600μsview::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)

350μ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

620μs/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)

440μ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

630μ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::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)

560μ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

730μ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

930μ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

700μs/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: 6
App\Models\BrandTranslation: 216
App\Models\Brand: 216
App\Models\AttributeValue: 14
App\Models\CategoryTranslation: 55
App\Models\Category: 55
App\Models\Product: 12
App\Models\Color: 143
App\Models\AttributeTranslation: 1
App\Models\Attribute: 1

_token: JfvISLQM9tcCdVEGS4Jfs69wM0u12DhL5Hq06S0m
locale: en
_previous: array:1 [ "url" => "https://ns1.medicoexpress.com/search?page=1285" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/search

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

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

request_request

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

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 => "ns1.medicoexpress.com"
  ]
]

request_server

  0 of 0   
array:58 [▼
  "USER" => "medicoexpress"
  "HOME" => "/home/medicoexpress"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/search?page=1285"
  "QUERY_STRING" => "page=1285"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "page=1285"
  "REDIRECT_URL" => "/search"
  "REMOTE_PORT" => "4087"
  "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" => "3.17.177.21"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "192.168.74.52"
  "SERVER_NAME" => "ns1.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" => "ns1.medicoexpress.com"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "ns1.medicoexpress.com"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://ns1.medicoexpress.com/search"
  "SCRIPT_URL" => "/search"
  "UNIQUE_ID" => "Z_jVdp-gXZ_EVWoToKlu5QAAAEs"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "ns1.medicoexpress.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://ns1.medicoexpress.com/search"
  "REDIRECT_SCRIPT_URL" => "/search"
  "REDIRECT_UNIQUE_ID" => "Z_jVdp-gXZ_EVWoToKlu5QAAAEs"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744360822.8663
  "REQUEST_TIME" => 1744360822
  "argv" => array:1 [▶
    0 => "page=1285"
  ]
  "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 08:40:23 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=JfvISLQM9tcCdVEGS4Jfs69wM0u12DhL5Hq06S0m; expires=Fri, 11-Apr-2025 10:40:24 GMT; Max-Age=7200; path=/"
    1 => "medico_express_online_pharmacy_session=wUu5FCgZ5lz7p1ZJz0V6iGvje5kdWGkJu0pDAl4F; expires=Fri, 11-Apr-2025 10:40:24 GMT; Max-Age=7200; path=/; httponly"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=JfvISLQM9tcCdVEGS4Jfs69wM0u12DhL5Hq06S0m; expires=Fri, 11-Apr-2025 10:40:24 GMT; path=/"
    1 => "medico_express_online_pharmacy_session=wUu5FCgZ5lz7p1ZJz0V6iGvje5kdWGkJu0pDAl4F; expires=Fri, 11-Apr-2025 10:40:24 GMT; path=/; httponly"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "JfvISLQM9tcCdVEGS4Jfs69wM0u12DhL5Hq06S0m"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://ns1.medicoexpress.com/search?page=1285"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

ZYNCET TAB 10S

ZYNDET BAR 125GM

ZYQ 200MG TAB 30S

ZYQ 300MG TAB 30S

ZyrCold Syrup 100 ml

Zyrcold Tablet 10's

ZYROVA 10MG TAB 10S

ZYROVA 20MG TAB 10S

ZYROVA 40MG TAB 10S

ZYROVA 5MG TAB 10S

ZYROVA ASP 75MG TAB 10S

ZYROVA C10 CAP 10S

Contact Info

Quick Links

My Account

1 x Application (83.85%)	1.69s
1 x Booting (16.01%)	322.17ms

Filters

All Products

Contact Info

Quick Links

My Account