Veterinaria San Juan

Messages Timeline Exceptions Views10 Route Queries169 Models1326 Mails Gate Session Request

7.4.33941ms21MBGET vendor/{id?}

Booting (162ms)
Application (779ms)
1 x Application (82.75%)
779ms
1 x Booting (17.25%)
162ms

10 templates were rendered

frontend.vendor-products (resources/views/frontend/vendor-products.blade.php)17blade


show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate

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

Params
0	`show_range`
1	`tags`
2	`socialMediaUrls`
3	`range_products`
4	`vendor`
5	`listData`
6	`navCategories`
7	`newProducts`
8	`variantSets`
9	`brands`
10	`is_vendor_closed`
11	`cartData`
12	`period`
13	`time_slots`
14	`Map_vendors`
15	`vendorMultiBanner`
16	`taxes_rate`

Params
0	`paginator`
1	`elements`

layouts.store (resources/views/layouts/store.blade.php)46blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`

layouts.store.title-meta (resources/views/layouts/store/title-meta.blade.php)48blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`

layouts.store.head-content (resources/views/layouts/store/head-content.blade.php)49blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
demo

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`demo`

layouts.language (resources/views/layouts/language.blade.php)57blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
socket_url
admin_chat
driver_chat
customer_chat
db
auth_id
authData
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`socket_url`
49	`admin_chat`
50	`driver_chat`
51	`customer_chat`
52	`db`
53	`auth_id`
54	`authData`
55	`dark_mode`
56	`body_class`

layouts.store.left-sidebar-template-two (resources/views/layouts/store/left-sidebar-template-two.blade.php)57blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
socket_url
admin_chat
driver_chat
customer_chat
db
auth_id
authData
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`socket_url`
49	`admin_chat`
50	`driver_chat`
51	`customer_chat`
52	`db`
53	`auth_id`
54	`authData`
55	`dark_mode`
56	`body_class`

layouts.store.topbar-template-two (resources/views/layouts/store/topbar-template-two.blade.php)61blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
socket_url
admin_chat
driver_chat
customer_chat
db
auth_id
authData
dark_mode
body_class
clientData
urlImg
languageList
currencyList

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`socket_url`
49	`admin_chat`
50	`driver_chat`
51	`customer_chat`
52	`db`
53	`auth_id`
54	`authData`
55	`dark_mode`
56	`body_class`
57	`clientData`
58	`urlImg`
59	`languageList`
60	`currencyList`

layouts.store.footer-content-template-two (resources/views/layouts/store/footer-content-template-two.blade.php)57blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
socket_url
admin_chat
driver_chat
customer_chat
db
auth_id
authData
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`socket_url`
49	`admin_chat`
50	`driver_chat`
51	`customer_chat`
52	`db`
53	`auth_id`
54	`authData`
55	`dark_mode`
56	`body_class`

layouts.store.footer (resources/views/layouts/store/footer.blade.php)57blade


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
stripe_ideal_publishable_key
khalti_api_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
show_range
tags
socialMediaUrls
range_products
vendor
listData
navCategories
newProducts
variantSets
brands
is_vendor_closed
cartData
period
time_slots
Map_vendors
vendorMultiBanner
taxes_rate
checkSlot
__currentLoopData
val
key
loop
v
k
data
title
set_template
set_common_business_type
socket_url
admin_chat
driver_chat
customer_chat
db
auth_id
authData
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`show_range`
21	`tags`
22	`socialMediaUrls`
23	`range_products`
24	`vendor`
25	`listData`
26	`navCategories`
27	`newProducts`
28	`variantSets`
29	`brands`
30	`is_vendor_closed`
31	`cartData`
32	`period`
33	`time_slots`
34	`Map_vendors`
35	`vendorMultiBanner`
36	`taxes_rate`
37	`checkSlot`
38	`__currentLoopData`
39	`val`
40	`key`
41	`loop`
42	`v`
43	`k`
44	`data`
45	`title`
46	`set_template`
47	`set_common_business_type`
48	`socket_url`
49	`admin_chat`
50	`driver_chat`
51	`customer_chat`
52	`db`
53	`auth_id`
54	`authData`
55	`dark_mode`
56	`body_class`

uri: GET vendor/{id?}
middleware: web, languageSwitch, subdomain, domain
domain: {domain}
controller: App\Http\Controllers\Front\VendorController@vendorProducts
namespace: App\Http\Controllers
prefix
where
as: vendorDetail
file: app/Http/Controllers/Front/VendorController.php:87-325

169 statements were executed, 85 of which were duplicated, 84 unique362ms

select `theme_admin`, `distance_unit`, `currency_id`, `date_format`, `time_format`, `fb_login`, `fb_client_id`, `fb_client_secret`, `fb_client_url`, `twitter_login`, `twitter_client_id`, `twitter_client_secret`, `twitter_client_url`, `google_login`, `google_client_id`, `google_client_secret`, `google_client_url`, `apple_login`, `apple_client_id`, `apple_client_secret`, `apple_client_url`, `Default_location_name`, `Default_latitude`, `Default_longitude`, `map_provider`, `map_key`, `sms_provider`, `verify_email`, `verify_phone`, `web_template_id`, `is_hyperlocal`, `need_delivery_service`, `need_dispacher_ride`, `delivery_service_key`, `dispatcher_key`, `primary_color`, `secondary_color`, `fcm_api_key`, `fcm_auth_domain`, `fcm_project_id`, `fcm_storage_bucket`, `fcm_messaging_sender_id`, `fcm_app_id`, `fcm_measurement_id`, `distance_unit_for_time`, `distance_to_time_multiplier`, `delay_order`, `product_order_form`, `digit_after_decimal`, `dinein_check`, `takeaway_check`, `delivery_check`, `concise_signup`, `rental_check`, `pick_drop_check`, `on_demand_check`, `laundry_check`, `appointment_check`, `slots_with_service_area`, `is_vendor_tags`, `signup_image`, `map_on_search_screen` from `client_preferences` where `client_code` = 'fe4568' limit 1

4.65msmiddleware::domain:77royo_farma

Metadata
Bindings	0. fe4568
Backtrace	15. middleware::domain:77 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select `language_id`, `is_primary` from `client_languages` where `is_primary` = 1 limit 1

1.33msmiddleware::domain:87royo_farma

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:87 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `languages` where `id` = 148 limit 1

830μsmiddleware::domain:97royo_farma

Metadata
Bindings	0. 148
Backtrace	15. middleware::domain:97 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `client_currencies` inner join `currencies` as `cu` on `cu`.`id` = `client_currencies`.`currency_id` where `client_currencies`.`is_primary` = 1 limit 1

1.05msmiddleware::domain:102royo_farma

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:102 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `currencies` where `id` = 98 limit 1

750μsmiddleware::domain:117royo_farma

Metadata
Bindings	0. 98
Backtrace	15. middleware::domain:117 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `clients` limit 1

840μsmiddleware::domain:126royo_farma

Metadata
Backtrace	18. middleware::domain:126 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 20. middleware::subdomain:22 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 22. middleware::languageSwitch:26

select * from `countries` where `id` = 138

700μsmiddleware::domain:127royo_farma

Metadata
Bindings	0. 138
Backtrace	14. middleware::domain:127 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 16. middleware::subdomain:22 17. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 18. middleware::languageSwitch:26

select `id`, `email`, `name`, `slug`, `desc`, `short_desc`, `logo`, `banner`, `address`, `latitude`, `longitude`, `order_min_amount`, `order_pre_time`, `auto_reject_time`, `dine_in`, `takeaway`, `delivery`, `vendor_templete_id`, `is_show_vendor_details`, `website`, `show_slot`, `closed_store_order_scheduled`, `instagram_url`, `country`, `state`, `dynamic_html` from `vendors` where `slug` = 'veterinaria-san-juan' and `status` = 1 limit 1

780μs/app/Http/Controllers/Front/VendorController.php:105royo_farma

Metadata
Bindings	0. veterinaria-san-juan 1. 1
Backtrace	16. /app/Http/Controllers/Front/VendorController.php:105 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 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `clients` limit 1

790μs/app/Models/Vendor.php:29royo_farma

Metadata
Backtrace	18. /app/Models/Vendor.php:29 27. /app/Http/Controllers/Front/VendorController.php:105 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `clients` limit 1

700μs/app/Models/VendorSlot.php:13royo_farma

Metadata
Backtrace	18. /app/Models/VendorSlot.php:13 26. /app/Models/Vendor.php:32 35. /app/Http/Controllers/Front/VendorController.php:105 36. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 37. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `vendor_slots` where exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 2) and `start_time` < '07:16:54' and `end_time` > '07:16:54' and `vendor_slots`.`vendor_id` in (75)

8.7ms/app/Http/Controllers/Front/VendorController.php:105royo_farma

Metadata
Bindings	0. 2 1. 07:16:54 2. 07:16:54
Backtrace	21. /app/Http/Controllers/Front/VendorController.php:105 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `clients` limit 1

1.06ms/app/Models/Vendor.php:55royo_farma

Metadata
Backtrace	18. /app/Models/Vendor.php:55 27. /app/Http/Controllers/Front/VendorController.php:105 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `vendor_slot_dates` where `specific_date` = '2025-04-07' and `start_time` < '07:16:54' and `end_time` > '07:16:54' and `vendor_slot_dates`.`vendor_id` in (75)

5.95ms/app/Http/Controllers/Front/VendorController.php:105royo_farma

Metadata
Bindings	0. 2025-04-07 1. 07:16:54 2. 07:16:54
Backtrace	21. /app/Http/Controllers/Front/VendorController.php:105 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `products` where `is_live` = '1' and `products`.`vendor_id` in (75) and `products`.`deleted_at` is null

10.04ms/app/Http/Controllers/Front/VendorController.php:105royo_farma

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Controllers/Front/VendorController.php:105 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `order_product_ratings` where `order_product_ratings`.`product_id` in (4248, 4249, 4250, 4251, 4252, 4253, 4254, 4255, 4256, 4257, 4258, 4259, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4286, 4287, 4288, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4374, 4375, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4384, 4385, 4386, 4387, 4388, 4389, 4390, 4391, 4392, 4393, 4394, 4395, 4396, 4397, 4398, 4399, 4400, 4401, 4402, 4403, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4414, 4415, 4416, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4424, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4453, 4454, 4455, 4456, 4457, 4458, 4459, 4460, 4461, 4462, 4463, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4472, 4473, 4474, 4475, 4476, 4477)

17.62ms/app/Http/Controllers/Front/VendorController.php:105royo_farma

Metadata
Backtrace	26. /app/Http/Controllers/Front/VendorController.php:105 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `vendors` where exists (select * from `products` where `vendors`.`id` = `products`.`vendor_id` and exists (select * from `order_product_ratings` where `products`.`id` = `order_product_ratings`.`product_id`) and `is_live` = '1' and `products`.`deleted_at` is null)

3.48ms/app/Http/Controllers/Front/VendorController.php:121royo_farma

Metadata
Bindings	0. 1
Backtrace	15. /app/Http/Controllers/Front/VendorController.php:121 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 `client_currencies` where `currency_id` = 98 limit 1

980μs/app/Http/Controllers/Front/VendorController.php:138royo_farma

Metadata
Bindings	0. 98
Backtrace	15. /app/Http/Controllers/Front/VendorController.php:138 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 `brand_id` from `products` where `vendor_id` = 75 and `brand_id` > 0 and `products`.`deleted_at` is null group by `brand_id`

5.68ms/app/Http/Controllers/Front/VendorController.php:142royo_farma

Metadata
Bindings	0. 75 1. 0
Backtrace	14. /app/Http/Controllers/Front/VendorController.php:142 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 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `image` from `brands` where `brands`.`id` in (311, 317, 318, 319, 320, 321, 323, 324, 325, 326, 327, 328, 333, 334, 335, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346)

950μs/app/Http/Controllers/Front/VendorController.php:142royo_farma

Metadata
Backtrace	19. /app/Http/Controllers/Front/VendorController.php:142 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `title`, `brand_id` from `brand_translations` inner join `languages` on `brand_translations`.`language_id` = `languages`.`id` where `brand_translations`.`brand_id` in (311, 317, 318, 319, 320, 321, 323, 324, 325, 326, 327, 328, 333, 334, 335, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346) and `brand_translations`.`language_id` = 148

11.11ms/app/Http/Controllers/Front/VendorController.php:142royo_farma

Metadata
Bindings	0. 148
Backtrace	24. /app/Http/Controllers/Front/VendorController.php:142 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `product_variant_sets`.`product_id`, `product_variant_sets`.`product_variant_id`, `product_variant_sets`.`variant_type_id`, `vr`.`type`, `vt`.`title` from `product_variant_sets` inner join `variants` as `vr` on `product_variant_sets`.`variant_type_id` = `vr`.`id` inner join `variant_translations` as `vt` on `vt`.`variant_id` = `vr`.`id` where `vt`.`language_id` = 148 and `product_id` in (select `id` from `products` where `vendor_id` = 75) group by `product_variant_sets`.`variant_type_id`

4.51ms/app/Http/Controllers/Front/VendorController.php:158royo_farma

Metadata
Bindings	0. 148 1. 75
Backtrace	14. /app/Http/Controllers/Front/VendorController.php:158 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 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `business_type` from `client_preferences` limit 1

1.89ms/app/helpers.php:1044royo_farma

Metadata
Backtrace	15. /app/helpers.php:1044 17. /app/Http/Controllers/Front/VendorController.php:159 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id` from `types` where `service_type` in ('products_service')

1.2ms/app/helpers.php:1073royo_farma

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 15. /app/Http/Controllers/Front/VendorController.php:159 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 * from `client_languages` order by `is_primary` desc limit 1

770μs/app/Http/Controllers/Front/FrontController.php:164royo_farma

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:164 16. /app/Http/Controllers/Front/VendorController.php:159 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 `client_preferences` where `id` > 0 limit 1

2.7ms/app/Http/Controllers/Front/FrontController.php:289royo_farma

Metadata
Bindings	0. 0
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:289 16. /app/Http/Controllers/Front/FrontController.php:182 17. /app/Http/Controllers/Front/VendorController.php:159 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendors`.*, (select count(*) from `products` where `vendors`.`id` = `products`.`vendor_id` and `products`.`deleted_at` is null) as `products_count` from `vendors`

5.83ms/app/Http/Controllers/Front/FrontController.php:327royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:327 15. /app/Http/Controllers/Front/FrontController.php:182 16. /app/Http/Controllers/Front/VendorController.php:159 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1 and `id` in (75, 77, 78, 79, 81, 85, 86, 87)

1.19ms/app/Http/Controllers/Front/FrontController.php:331royo_farma

Metadata
Bindings	0. 1 1. 1 2. 75 3. 77 4. 78 5. 79 6. 81 7. 85 8. 86 9. 87
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:331 15. /app/Http/Controllers/Front/FrontController.php:182 16. /app/Http/Controllers/Front/VendorController.php:159 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name`, `categories`.`type_id` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `vendor_categories` as `vct` on `categories`.`id` = `vct`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`type_id` in (1, 3, 4, 5, 6, 11) and (`vct`.`vendor_id` in (75) and `vct`.`status` = 1 or (`categories`.`type_id` in (4, 8))) and `categories`.`id` > '1' and `categories`.`type_id` is not null and `categories`.`type_id` != 5 and `categories`.`id` > '1' and `categories`.`is_visible` = 1 and `categories`.`is_core` = 1 and `categories`.`status` != 2 and `cts`.`language_id` = 148 and (`cts`.`language_id` = 148 or `cts`.`language_id` = 148) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `id` order by `position` asc, `categories`.`parent_id` asc

8.48ms/app/Http/Controllers/Front/FrontController.php:214royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 75 7. 1 8. 4 9. 8 10. 1 11. 5 12. 1 13. 1 14. 1 15. 2 16. 148 17. 148 18. 148
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:214 15. /app/Http/Controllers/Front/VendorController.php:159 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 * from `client_currencies` where `currency_id` = 98 limit 1

1.19ms/app/Http/Controllers/Front/FrontController.php:382royo_farma

Metadata
Bindings	0. 98
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:382 16. /app/Http/Controllers/Front/VendorController.php:162 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 `business_type` from `client_preferences` limit 1

710μs/app/helpers.php:1044royo_farma

Metadata
Backtrace	15. /app/helpers.php:1044 25. /app/Http/Controllers/Front/FrontController.php:384 26. /app/Http/Controllers/Front/VendorController.php:162 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id` from `types` where `service_type` in ('products_service')

740μs/app/helpers.php:1073royo_farma

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 23. /app/Http/Controllers/Front/FrontController.php:384 24. /app/Http/Controllers/Front/VendorController.php:162 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `sku`, `url_slug`, `weight_unit`, `weight`, `vendor_id`, `has_variant`, `has_inventory`, `sell_when_out_of_stock`, `requires_shipping`, `Requires_last_mile`, `averageRating`, `inquiry_only`, `minimum_order_count`, `batch_count`, `minimum_duration_min` from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and `is_new` = 1 and `vendor_id` in (75) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6

1.05ms/app/Http/Controllers/Front/FrontController.php:416royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 75 8. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:416 15. /app/Http/Controllers/Front/VendorController.php:162 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 * from `client_currencies` where `currency_id` = 98 limit 1

710μs/app/Http/Controllers/Front/VendorController.php:597royo_farma

Metadata
Bindings	0. 98
Backtrace	15. /app/Http/Controllers/Front/VendorController.php:597 16. /app/Http/Controllers/Front/VendorController.php:170 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 `business_type` from `client_preferences` limit 1

680μs/app/helpers.php:1044royo_farma

Metadata
Backtrace	15. /app/helpers.php:1044 25. /app/Http/Controllers/Front/VendorController.php:598 26. /app/Http/Controllers/Front/VendorController.php:170 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id` from `types` where `service_type` in ('products_service')

800μs/app/helpers.php:1073royo_farma

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 23. /app/Http/Controllers/Front/VendorController.php:598 24. /app/Http/Controllers/Front/VendorController.php:170 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select count(*) as aggregate from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `delivery` = 1) and `is_live` = 1 and `vendor_id` = 75 and `products`.`deleted_at` is null

4.28ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 1 8. 75
Backtrace	15. /app/Http/Controllers/Front/VendorController.php:618 16. /app/Http/Controllers/Front/VendorController.php:170 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 `id`, `sku`, `description`, `requires_shipping`, `sell_when_out_of_stock`, `url_slug`, `weight_unit`, `weight`, `vendor_id`, `has_variant`, `has_inventory`, `Requires_last_mile`, `averageRating`, `inquiry_only` from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `delivery` = 1) and `is_live` = 1 and `vendor_id` = 75 and `products`.`deleted_at` is null limit 12 offset 48

1.95ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 1 8. 75
Backtrace	15. /app/Http/Controllers/Front/VendorController.php:618 16. /app/Http/Controllers/Front/VendorController.php:170 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 `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307)

6.9ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Backtrace	20. /app/Http/Controllers/Front/VendorController.php:618 21. /app/Http/Controllers/Front/VendorController.php:170 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 `deleted_at` is null and `categories`.`id` in (884, 886, 887, 888) and `categories`.`deleted_at` is null

1.04ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Backtrace	25. /app/Http/Controllers/Front/VendorController.php:618 26. /app/Http/Controllers/Front/VendorController.php:170 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `category_translations`.*, `languages`.`id` as `langId`, `languages`.`name` as `langName`, `cl`.`is_primary` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `cl`.`is_active` = 1 and `category_translations`.`category_id` in (884, 886, 887, 888) and `category_translations`.`language_id` = 148 order by `cl`.`is_primary` desc

1.29ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	30. /app/Http/Controllers/Front/VendorController.php:618 31. /app/Http/Controllers/Front/VendorController.php:170 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307)

2.73ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Backtrace	20. /app/Http/Controllers/Front/VendorController.php:618 21. /app/Http/Controllers/Front/VendorController.php:170 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 `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (4166, 4167, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4176, 4177)

2.33ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Backtrace	25. /app/Http/Controllers/Front/VendorController.php:618 26. /app/Http/Controllers/Front/VendorController.php:170 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307) and `language_id` = 148

2.47ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/Http/Controllers/Front/VendorController.php:618 21. /app/Http/Controllers/Front/VendorController.php:170 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 `sku`, `product_id`, `quantity`, `price`, `markup_price`, `barcode` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307) group by `product_id`

9.13ms/app/Http/Controllers/Front/VendorController.php:618royo_farma

Metadata
Bindings	0. 1
Backtrace	20. /app/Http/Controllers/Front/VendorController.php:618 21. /app/Http/Controllers/Front/VendorController.php:170 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 `vendor_id` from `products` where `id` = 4296 and `products`.`deleted_at` is null limit 1

1.47ms/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4296
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

910μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4297 and `products`.`deleted_at` is null limit 1

770μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4297
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

1.18ms/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4298 and `products`.`deleted_at` is null limit 1

950μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4298
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

880μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4299 and `products`.`deleted_at` is null limit 1

2.76ms/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4299
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

2.15ms/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4300 and `products`.`deleted_at` is null limit 1

1.8ms/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4300
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

1.1ms/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4301 and `products`.`deleted_at` is null limit 1

1.54ms/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4301
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

1.61ms/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4302 and `products`.`deleted_at` is null limit 1

1.01ms/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4302
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

710μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4303 and `products`.`deleted_at` is null limit 1

690μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4303
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

720μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4304 and `products`.`deleted_at` is null limit 1

690μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4304
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

670μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4305 and `products`.`deleted_at` is null limit 1

720μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4305
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

690μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4306 and `products`.`deleted_at` is null limit 1

780μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4306
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

700μs/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vendor_id` from `products` where `id` = 4307 and `products`.`deleted_at` is null limit 1

750μs/app/Models/ProductVariant.php:123royo_farma

Metadata
Bindings	0. 4307
Backtrace	16. /app/Models/ProductVariant.php:123 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `add_markup_price` from `vendors` where `id` = 75 limit 1

2.92ms/app/Models/ProductVariant.php:124royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/ProductVariant.php:124 22. /app/Http/Controllers/Front/VendorController.php:624 23. /app/Http/Controllers/Front/VendorController.php:170 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `business_type` from `client_preferences` limit 1

740μs/app/helpers.php:1044royo_farma

Metadata
Backtrace	15. /app/helpers.php:1044 25. /app/Http/Controllers/Front/VendorController.php:187 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id` from `types` where `service_type` in ('products_service')

1.83ms/app/helpers.php:1073royo_farma

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 23. /app/Http/Controllers/Front/VendorController.php:187 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `products` inner join `product_variants` on `product_variants`.`product_id` = `products`.`id` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `delivery` = 1) and `is_live` = 1 and `vendor_id` = 75 and `products`.`deleted_at` is null order by `product_variants`.`price` desc

18.4ms/app/Http/Controllers/Front/VendorController.php:190royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 1 8. 75
Backtrace	14. /app/Http/Controllers/Front/VendorController.php:190 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 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `product_tags` where `product_tags`.`product_id` in (4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4472, 4473, 4474, 4475, 4476, 4477, 4478, 4479, 4480, 4481, 4482, 4483, 4484, 4485, 4486, 4487, 4488, 4489, 4490, 4491, 4492, 4493, 4494, 4495, 4496, 4497, 4498, 4499, 4500, 4501, 4502, 4503, 4504, 4505, 4506, 4507, 4508, 4509, 4510, 4511, 4512, 4513, 4514, 4515, 4516, 4517, 4518, 4519, 4520, 4521, 4522, 4523, 4524, 4525, 4526, 4527, 4528, 4529, 4530, 4531, 4532, 4533, 4534, 4535, 4536, 4537, 4538, 4539, 4540, 4541, 4542, 4543, 4544, 4545, 4546, 4547, 4548, 4549, 4550, 4551, 4552, 4553, 4554, 4555, 4556, 4557, 4558, 4559, 4560, 4561, 4562, 4563, 4564, 4565, 4566, 4567, 4568, 4569, 4570, 4571, 4572, 4573, 4574, 4575, 4576, 4577, 4578, 4579, 4580, 4581, 4582, 4583, 4584, 4585, 4586, 4587, 4588, 4589, 4590, 4591, 4592, 4593, 4594, 4595, 4596, 4597, 4598, 4599, 4600, 4601, 4602, 4603, 4604, 4605, 4606, 4607, 4608, 4609, 4610, 4611, 4612, 4613, 4614, 4615, 4616, 4617, 4618, 4619, 4620, 4621, 4622, 4623, 4624, 4625, 4626, 4627, 4628, 4629, 4630, 4631, 4632, 4633, 4634, 4635, 4636, 4637, 4638, 4639, 4640, 4641, 4642, 4643, 4644, 4645, 4646, 4647, 4648, 4649, 4650, 4651, 4652, 4653, 4654, 4655, 4656, 4657, 4658, 4659, 4660, 4661, 4662, 4663, 4664, 4665, 4666, 4667, 4668, 4669, 4670, 4671, 4672, 4673, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693)

10.92ms/app/Http/Controllers/Front/VendorController.php:190royo_farma

Metadata
Backtrace	19. /app/Http/Controllers/Front/VendorController.php:190 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `client_preferences` where `id` > 0 limit 1

4.37ms/app/Http/Controllers/Front/FrontController.php:289royo_farma

Metadata
Bindings	0. 0
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:289 16. /app/Http/Controllers/Front/VendorController.php:305 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 `vendors`.*, (select count(*) from `products` where `vendors`.`id` = `products`.`vendor_id` and `products`.`deleted_at` is null) as `products_count` from `vendors`

5.87ms/app/Http/Controllers/Front/FrontController.php:327royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:327 15. /app/Http/Controllers/Front/VendorController.php:305 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 `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1 and `id` in (75, 77, 78, 79, 81, 85, 86, 87)

1ms/app/Http/Controllers/Front/FrontController.php:331royo_farma

Metadata
Bindings	0. 1 1. 1 2. 75 3. 77 4. 78 5. 79 6. 81 7. 85 8. 86 9. 87
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:331 15. /app/Http/Controllers/Front/VendorController.php:305 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 `business_type` from `client_preferences` limit 1

1.91ms/app/helpers.php:1044royo_farma

Metadata
Backtrace	15. /app/helpers.php:1044 25. /app/Http/Controllers/Front/VendorController.php:317 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id` from `types` where `service_type` in ('products_service')

1.08ms/app/helpers.php:1073royo_farma

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 23. /app/Http/Controllers/Front/VendorController.php:317 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id` from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and `vendor_id` = 75 and `is_live` = 1 and `products`.`deleted_at` is null

3.31ms/app/Http/Controllers/Front/VendorController.php:317royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 75 7. 1
Backtrace	13. /app/Http/Controllers/Front/VendorController.php:317 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `tag_id` from `product_tags` where `product_id` in (4248, 4249, 4250, 4251, 4252, 4253, 4254, 4255, 4256, 4257, 4258, 4259, 4260, 4261, 4262, 4263, 4264, 4265, 4266, 4267, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4286, 4287, 4288, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4301, 4302, 4303, 4304, 4305, 4306, 4307, 4308, 4309, 4310, 4311, 4312, 4313, 4314, 4315, 4316, 4317, 4318, 4319, 4320, 4321, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347, 4348, 4349, 4350, 4351, 4352, 4353, 4354, 4355, 4356, 4357, 4358, 4359, 4360, 4361, 4362, 4363, 4364, 4365, 4366, 4367, 4368, 4369, 4370, 4371, 4372, 4373, 4374, 4375, 4376, 4377, 4378, 4379, 4380, 4381, 4382, 4383, 4384, 4385, 4386, 4387, 4388, 4389, 4390, 4391, 4392, 4393, 4394, 4395, 4396, 4397, 4398, 4399, 4400, 4401, 4402, 4403, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4414, 4415, 4416, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4424, 4425, 4426, 4427, 4428, 4429, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4439, 4440, 4441, 4442, 4443, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4453, 4454, 4455, 4456, 4457, 4458, 4459, 4460, 4461, 4462, 4463, 4464, 4465, 4466, 4467, 4468, 4469, 4470, 4471, 4472, 4473, 4474, 4475, 4476, 4477)

2.02ms/app/Http/Controllers/Front/VendorController.php:318royo_farma

Metadata

Bindings

0. 4248
1. 4249
2. 4250
3. 4251
4. 4252
5. 4253
6. 4254
7. 4255
8. 4256
9. 4257
10. 4258
11. 4259
12. 4260
13. 4261
14. 4262
15. 4263
16. 4264
17. 4265
18. 4266
19. 4267
20. 4268
21. 4269
22. 4270
23. 4271
24. 4272
25. 4273
26. 4274
27. 4275
28. 4276
29. 4277
30. 4278
31. 4279
32. 4280
33. 4281
34. 4282
35. 4283
36. 4284
37. 4285
38. 4286
39. 4287
40. 4288
41. 4289
42. 4290
43. 4291
44. 4292
45. 4293
46. 4294
47. 4295
48. 4296
49. 4297
50. 4298
51. 4299
52. 4300
53. 4301
54. 4302
55. 4303
56. 4304
57. 4305
58. 4306
59. 4307
60. 4308
61. 4309
62. 4310
63. 4311
64. 4312
65. 4313
66. 4314
67. 4315
68. 4316
69. 4317
70. 4318
71. 4319
72. 4320
73. 4321
74. 4322
75. 4323
76. 4324
77. 4325
78. 4326
79. 4327
80. 4328
81. 4329
82. 4330
83. 4331
84. 4332
85. 4333
86. 4334
87. 4335
88. 4336
89. 4337
90. 4338
91. 4339
92. 4340
93. 4341
94. 4342
95. 4343
96. 4344
97. 4345
98. 4346
99. 4347
100. 4348
101. 4349
102. 4350
103. 4351
104. 4352
105. 4353
106. 4354
107. 4355
108. 4356
109. 4357
110. 4358
111. 4359
112. 4360
113. 4361
114. 4362
115. 4363
116. 4364
117. 4365
118. 4366
119. 4367
120. 4368
121. 4369
122. 4370
123. 4371
124. 4372
125. 4373
126. 4374
127. 4375
128. 4376
129. 4377
130. 4378
131. 4379
132. 4380
133. 4381
134. 4382
135. 4383
136. 4384
137. 4385
138. 4386
139. 4387
140. 4388
141. 4389
142. 4390
143. 4391
144. 4392
145. 4393
146. 4394
147. 4395
148. 4396
149. 4397
150. 4398
151. 4399
152. 4400
153. 4401
154. 4402
155. 4403
156. 4404
157. 4405
158. 4406
159. 4407
160. 4408
161. 4409
162. 4410
163. 4411
164. 4412
165. 4413
166. 4414
167. 4415
168. 4416
169. 4417
170. 4418
171. 4419
172. 4420
173. 4421
174. 4422
175. 4423
176. 4424
177. 4425
178. 4426
179. 4427
180. 4428
181. 4429
182. 4430
183. 4431
184. 4432
185. 4433
186. 4434
187. 4435
188. 4436
189. 4437
190. 4438
191. 4439
192. 4440
193. 4441
194. 4442
195. 4443
196. 4444
197. 4445
198. 4446
199. 4447
200. 4448
201. 4449
202. 4450
203. 4451
204. 4452
205. 4453
206. 4454
207. 4455
208. 4456
209. 4457
210. 4458
211. 4459
212. 4460
213. 4461
214. 4462
215. 4463
216. 4464
217. 4465
218. 4466
219. 4467
220. 4468
221. 4469
222. 4470
223. 4471
224. 4472
225. 4473
226. 4474
227. 4475
228. 4476
229. 4477

Backtrace

13. /app/Http/Controllers/Front/VendorController.php:318
14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `tags` where 0 = 1

4.25ms/app/Http/Controllers/Front/VendorController.php:319royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/VendorController.php:319 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 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `vendor_social_media_urls` where `vendor_id` = 75

6.63ms/app/Http/Controllers/Front/VendorController.php:321royo_farma

Metadata
Bindings	0. 75
Backtrace	14. /app/Http/Controllers/Front/VendorController.php:321 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 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `tax_rates`

10.19ms/app/Http/Traits/CartManager.php:131royo_farma

Metadata
Backtrace	15. /app/Http/Traits/CartManager.php:131 16. /app/Http/Controllers/Front/VendorController.php:322 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 `tax_categories`

5.8ms/app/Http/Traits/CartManager.php:132royo_farma

Metadata
Backtrace	15. /app/Http/Traits/CartManager.php:132 16. /app/Http/Controllers/Front/VendorController.php:322 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 `slot_minutes` from `vendors` where `id` = 75 limit 1

2.08ms/app/helpers.php:562royo_farma

Metadata
Bindings	0. 75
Backtrace	15. /app/helpers.php:562 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `timezone` from `clients` limit 1

2.82ms/app/helpers.php:566royo_farma

Metadata
Backtrace	15. /app/helpers.php:566 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` limit 1

1.59ms/app/helpers.php:567royo_farma

Metadata
Backtrace	18. /app/helpers.php:567 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 `vendor_slots` where `vendor_id` = 75 and exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 2 and `delivery` = '1')

5.42ms/app/helpers.php:586royo_farma

Metadata
Bindings	0. 75 1. 2 2. 1
Backtrace	14. /app/helpers.php:586 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `slot_minutes` from `vendors` where `id` = 75 limit 1

830μs/app/helpers.php:562royo_farma

Metadata
Bindings	0. 75
Backtrace	15. /app/helpers.php:562 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `timezone` from `clients` limit 1

710μs/app/helpers.php:566royo_farma

Metadata
Backtrace	15. /app/helpers.php:566 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` limit 1

1.21ms/app/helpers.php:567royo_farma

Metadata
Backtrace	18. /app/helpers.php:567 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 `vendor_slots` where `vendor_id` = 75 and exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 3 and `delivery` = '1')

890μs/app/helpers.php:586royo_farma

Metadata
Bindings	0. 75 1. 3 2. 1
Backtrace	14. /app/helpers.php:586 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `slot_minutes` from `vendors` where `id` = 75 limit 1

1.95ms/app/helpers.php:562royo_farma

Metadata
Bindings	0. 75
Backtrace	15. /app/helpers.php:562 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `timezone` from `clients` limit 1

780μs/app/helpers.php:566royo_farma

Metadata
Backtrace	15. /app/helpers.php:566 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` limit 1

1.54ms/app/helpers.php:567royo_farma

Metadata
Backtrace	18. /app/helpers.php:567 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 `vendor_slots` where `vendor_id` = 75 and exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 4 and `delivery` = '1')

1.06ms/app/helpers.php:586royo_farma

Metadata
Bindings	0. 75 1. 4 2. 1
Backtrace	14. /app/helpers.php:586 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `slot_minutes` from `vendors` where `id` = 75 limit 1

1.02ms/app/helpers.php:562royo_farma

Metadata
Bindings	0. 75
Backtrace	15. /app/helpers.php:562 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `timezone` from `clients` limit 1

1.02ms/app/helpers.php:566royo_farma

Metadata
Backtrace	15. /app/helpers.php:566 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` limit 1

2.24ms/app/helpers.php:567royo_farma

Metadata
Backtrace	18. /app/helpers.php:567 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 `vendor_slots` where `vendor_id` = 75 and exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 5 and `delivery` = '1')

910μs/app/helpers.php:586royo_farma

Metadata
Bindings	0. 75 1. 5 2. 1
Backtrace	14. /app/helpers.php:586 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

780μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

1.25msview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

920μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

760μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

760μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

750μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

740μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

1.62msview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

790μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

760μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

2.29msview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `add_markup_price`, `latitude`, `longitude` from `vendors` where `vendors`.`id` = 75 limit 1

950μsview::2b1725105349269a69e4dda78f1e6c74994ac2e8:294royo_farma

Metadata
Bindings	0. 75
Backtrace	20. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:294 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 `vendor_id` from `products` where `id` = 4400 and `products`.`deleted_at` is null limit 1

810μs/app/Models/Product.php:314royo_farma

Metadata
Bindings	0. 4400
Backtrace	16. /app/Models/Product.php:314 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:419 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `add_markup_price` from `vendors` where `id` = 75 limit 1

790μs/app/Models/Product.php:315royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/Product.php:315 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:419 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `vendor_id` from `products` where `id` = 4469 and `products`.`deleted_at` is null limit 1

730μs/app/Models/Product.php:314royo_farma

Metadata
Bindings	0. 4469
Backtrace	16. /app/Models/Product.php:314 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:420 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `add_markup_price` from `vendors` where `id` = 75 limit 1

790μs/app/Models/Product.php:315royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/Product.php:315 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:420 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `vendor_id` from `products` where `id` = 4400 and `products`.`deleted_at` is null limit 1

790μs/app/Models/Product.php:314royo_farma

Metadata
Bindings	0. 4400
Backtrace	16. /app/Models/Product.php:314 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:421 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `add_markup_price` from `vendors` where `id` = 75 limit 1

930μs/app/Models/Product.php:315royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/Product.php:315 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:421 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `vendor_id` from `products` where `id` = 4469 and `products`.`deleted_at` is null limit 1

960μs/app/Models/Product.php:314royo_farma

Metadata
Bindings	0. 4469
Backtrace	16. /app/Models/Product.php:314 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:422 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select `add_markup_price` from `vendors` where `id` = 75 limit 1

780μs/app/Models/Product.php:315royo_farma

Metadata
Bindings	0. 75
Backtrace	16. /app/Models/Product.php:315 22. view::2b1725105349269a69e4dda78f1e6c74994ac2e8:422 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

select * from `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1

980μsview::7fe8350a773c95649c81a6a807585448b67211e1:2royo_farma

Metadata
Bindings	0. 1 1. 1
Backtrace	15. view::7fe8350a773c95649c81a6a807585448b67211e1: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 `id`, `logo`, `dark_logo` from `clients` where `id` > 0 limit 1

2.42msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:2royo_farma

Metadata
Bindings	0. 0
Backtrace	15. view::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a: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 `client_languages` where `is_active` = 1 order by `is_primary` desc

1.03msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8royo_farma

Metadata
Bindings	0. 1
Backtrace	14. view::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8 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 `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 148)

1.25msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8royo_farma

Metadata
Backtrace	19. view::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8 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 `client_currencies` order by `is_primary` desc

1.39msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:9royo_farma

Metadata
Backtrace	14. view::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a: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 `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (98)

1.8msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:9royo_farma

Metadata
Backtrace	19. view::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a: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 `id`, `logo` from `clients` where `id` > 0 limit 1

800μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:2royo_farma

Metadata
Bindings	0. 0
Backtrace	15. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b: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 `client_languages` where `is_active` = 1 order by `is_primary` desc

3.15msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4royo_farma

Metadata
Bindings	0. 1
Backtrace	14. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4 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 `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 148)

910μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4royo_farma

Metadata
Backtrace	19. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4 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 `client_currencies` order by `is_primary` desc

720μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:5royo_farma

Metadata
Backtrace	14. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:5 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 `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (98)

700μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:5royo_farma

Metadata
Backtrace	19. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b: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 `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 148)) order by `order_by` asc

1.08msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	14. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6 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 `page_translations` where `page_translations`.`page_id` in (1, 2, 7) and `language_id` = 148

1.23msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6royo_farma

Metadata
Bindings	0. 148
Backtrace	19. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b: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 `nomenclatures` where `label` LIKE '%Delivery%' limit 1

2.37ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Delivery%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (9) and `language_id` = 148

920μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Dine-In%' limit 1

840μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Dine-In%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (8) and `language_id` = 148

870μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Takeaway%' limit 1

900μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Takeaway%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (5) and `language_id` = 148

830μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Rentals%' limit 1

740μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Rentals%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (15) and `language_id` = 148

1.18ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Pick & Drop%' limit 1

780μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Pick & Drop%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (16) and `language_id` = 148

1.06ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Services%' limit 1

2.45ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Services%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (17) and `language_id` = 148

4.35ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Laundry%' limit 1

2.29ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Laundry%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (18) and `language_id` = 148

900μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Appointment%' limit 1

810μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Appointment%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (20) and `language_id` = 148

2.35ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures` where `label` LIKE '%Search%' limit 1

730μs/app/helpers.php:237royo_farma

Metadata
Bindings	0. %Search%
Backtrace	15. /app/helpers.php:237 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (6) and `language_id` = 148

1.02ms/app/helpers.php:237royo_farma

Metadata
Bindings	0. 148
Backtrace	20. /app/helpers.php:237 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `clients` where `id` > 0 limit 1

2.55msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:3royo_farma

Metadata
Bindings	0. 0
Backtrace	15. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:3 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 20. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `payment_methods` where `is_show` = 1

1.12msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:10royo_farma

Metadata
Bindings	0. 1
Backtrace	14. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:10 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 `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 148)) order by `order_by` asc

1.17msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	14. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11 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 `page_translations` where `page_translations`.`page_id` in (1, 2, 7) and `language_id` = 148

2.09msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11royo_farma

Metadata
Bindings	0. 148
Backtrace	19. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11 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 `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 1 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

2.21msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

Metadata
Bindings	0. 1 1. 1
Backtrace	21. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 2 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

1.19msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

Metadata
Bindings	0. 2 1. 1
Backtrace	21. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `page_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `page_translations`.`language_id` where `page_translations`.`page_id` = 7 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

920μsview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

Metadata
Bindings	0. 7 1. 1
Backtrace	21. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` where (`id` = 1) limit 1

1.37msview::3c1c7b3b62a0ba2dd5955b8a22e47aaac5bde2dd:17royo_farma

Metadata
Bindings	0. 1
Backtrace	15. view::3c1c7b3b62a0ba2dd5955b8a22e47aaac5bde2dd:17 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 `clients` limit 1

2.07ms/app/helpers.php:45royo_farma

Metadata
Backtrace	18. /app/helpers.php:45 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 column_name as `column_name` from information_schema.columns where table_schema = 'royo_farma' and table_name = 'client_preference_additional'

1.1ms/app/helpers.php:29royo_farma

Metadata
Bindings	0. royo_farma 1. client_preference_additional
Backtrace	11. /app/helpers.php:29 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('gtag_id', 'fpixel_id') and (`client_code` = 'fe4568')

790μs/app/helpers.php:49royo_farma

Metadata
Bindings	0. gtag_id 1. fpixel_id 2. fe4568
Backtrace	14. /app/helpers.php:49 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 `show_subscription_plan_on_signups` where `show_subscription_plan_on_signups`.`id` = 1 limit 1

1.17ms/app/helpers.php:72royo_farma

Metadata
Bindings	0. 1
Backtrace	19. /app/helpers.php:72 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 `credentials`, `test_mode` from `payment_options` where `code` = 'razorpay' and `status` = 1 limit 1

1.23ms/app/helpers.php:299royo_farma

Metadata
Bindings	0. razorpay 1. 1
Backtrace	15. /app/helpers.php:299 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `credentials`, `test_mode` from `payment_options` where `code` = 'khalti' and `status` = 1 limit 1

860μs/app/helpers.php:312royo_farma

Metadata
Bindings	0. khalti 1. 1
Backtrace	15. /app/helpers.php:312 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_preferences` limit 1

1.25ms/app/helpers.php:278royo_farma

Metadata
Backtrace	18. /app/helpers.php:278 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 `client_preferences` limit 1

1.28ms/app/helpers.php:278royo_farma

Metadata
Backtrace	18. /app/helpers.php:278 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 `client_preferences` limit 1

1.11ms/app/helpers.php:278royo_farma

Metadata
Backtrace	18. /app/helpers.php:278 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 `clients` limit 1

920μs/app/helpers.php:290royo_farma

Metadata
Backtrace	18. /app/helpers.php:290 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 `clients` limit 1

800μs/app/helpers.php:290royo_farma

Metadata
Backtrace	18. /app/helpers.php:290 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

App\Models\ShowSubscriptionPlanOnSignup: 1
App\Models\Language: 5
App\Models\ClientCurrency: 6
App\Models\Currency: 3
App\Models\Client: 14
App\Models\Country: 1
App\Models\Vendor: 97
App\Models\Product: 743
App\Models\Brand: 25
App\Models\BrandTranslation: 25
App\Models\Type: 30
App\Models\Category: 252
App\Models\ProductCategory: 12
App\Models\ClientLanguage: 6
App\Models\Category_translation: 4
App\Models\VendorMedia: 12
App\Models\ProductTranslation: 12
App\Models\ProductVariant: 12
App\Models\TaxRate: 2
App\Models\TaxCategory: 2
App\Models\WebStylingOption: 1
App\Models\Page: 6
App\Models\PageTranslation: 9
App\Models\Nomenclature: 9
App\Models\NomenclatureTranslation: 6
App\Models\PaymentMethod: 3
App\Models\ProductImage: 12
App\Models\ClientPreference: 16

_token: nI1fvgKqhO0WuCdnm9f6TDHLWphJoVggarpgfHEc
client_config: {#3723 +"name": "Farma Ya" +"email": "admin@farma.com" +"phone_number": "+971559339644" +"is...
login_user_type: client
customerLanguage: 148
applocale: es
client_primary_currency: MXN
customerCurrency: 98
currencySymbol: $
currencyMultiplier: 1.00000000
iso_code: MXN
vendorType: delivery
selectedAddress: Ciudad de México, CDMX, México
default_country_code: MX
default_country_phonecode: 52
preferences: App\Models\ClientPreference {#3422 #fillable: array:69 [ 0 => "client_code" 1 => "theme_ad...
vendors: array:1 [ 0 => 75 ]
_previous: array:1 [ "url" => "https://petludos.com/vendor/veterinaria-san-juan?page=5" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/vendor/veterinaria-san-juan

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

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

request_request

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

request_headers

  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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"
  ]
  "host" => array:1 [▶
    0 => "petludos.com"
  ]
]

request_server

  0 of 0   
array:43 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_PRIORITY" => "u=0, i"
  "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_HOST" => "petludos.com"
  "PATH_INFO" => ""
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "petludos.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.8.125"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "15128"
  "REMOTE_ADDR" => "3.147.49.219"
  "SERVER_SOFTWARE" => "nginx/1.24.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/html/order_web/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/vendor/veterinaria-san-juan?page=5"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=5"
  "SCRIPT_FILENAME" => "/var/www/html/order_web/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744031814.2759
  "REQUEST_TIME" => 1744031814
]

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 => "Mon, 07 Apr 2025 13:16:54 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImhzekdQSUNhTUMyeVNGTjlvVGVmaFE9PSIsInZhbHVlIjoiVmlVTTB1WUxwVlZiRnBwbytzTDJ2NUh5YUp1cXB2QW5mNXhDaDBTZ3Rib1JIeEF6WWRUSDlGSHZhTXRwRFdWT00xY0hOUzBYN2xGdjBRcVF2eDlHU3MvRHh3d0tKc3FxTUZvb3JWZ1R5M1E4SmlSRlJySGRzSWRJajlZenRFcUciLCJtYWMiOiJkMDRhYjZjODg4MWEwOTQwNmM5ODNiZjljMzZlNTg4NmZiYWU4YmNkNGE5Njc5Nzc5YWY2MmYyNDg4YTNjMzM0IiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 13:16:55 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImhzekdQSUNhTUMyeVNGTjlvVGVmaFE9PSIsInZhbHVlIjoiVmlVTTB1WUxwVlZiRnBwbytzTDJ2NUh5YUp1cXB2QW5mNXhDaDBTZ3Rib1JIeEF6WWRUSDlGSHZhTXRwRFdWT00xY0hOU ▶"
    1 => "farmaya_session=eyJpdiI6IjVXWnZkZ3RIYWIzTUdWVS96NHpFNEE9PSIsInZhbHVlIjoiQXVlQnZzMEFkRkVWVVE2elBQVHYzclY4WVJTL01lengxdDEyaDlWNVVGTUMzV0VjeUFUK3h6M2QvT2hyVGpFbWRDUTVGbm13amxuUEpnZDlndlk3Ym5CZmwyd1FVWmtwdk80UHU5OVNkenNRV2Z5SnNwa3QwanZVWjlEWUxMU08iLCJtYWMiOiI3YTM2YWZlYjQyMjAyNDQwYTdjYzg2ZGZkZTc2ZjlkMmFhNjkwMDA4YWU4YjI1Nzg1MzdlMmFmMmZmMDk3MjBjIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 13:16:55 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀farmaya_session=eyJpdiI6IjVXWnZkZ3RIYWIzTUdWVS96NHpFNEE9PSIsInZhbHVlIjoiQXVlQnZzMEFkRkVWVVE2elBQVHYzclY4WVJTL01lengxdDEyaDlWNVVGTUMzV0VjeUFUK3h6M2QvT2hyVGpFbWRD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImhzekdQSUNhTUMyeVNGTjlvVGVmaFE9PSIsInZhbHVlIjoiVmlVTTB1WUxwVlZiRnBwbytzTDJ2NUh5YUp1cXB2QW5mNXhDaDBTZ3Rib1JIeEF6WWRUSDlGSHZhTXRwRFdWT00xY0hOUzBYN2xGdjBRcVF2eDlHU3MvRHh3d0tKc3FxTUZvb3JWZ1R5M1E4SmlSRlJySGRzSWRJajlZenRFcUciLCJtYWMiOiJkMDRhYjZjODg4MWEwOTQwNmM5ODNiZjljMzZlNTg4NmZiYWU4YmNkNGE5Njc5Nzc5YWY2MmYyNDg4YTNjMzM0IiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 13:16:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImhzekdQSUNhTUMyeVNGTjlvVGVmaFE9PSIsInZhbHVlIjoiVmlVTTB1WUxwVlZiRnBwbytzTDJ2NUh5YUp1cXB2QW5mNXhDaDBTZ3Rib1JIeEF6WWRUSDlGSHZhTXRwRFdWT00xY0hOU ▶"
    1 => "farmaya_session=eyJpdiI6IjVXWnZkZ3RIYWIzTUdWVS96NHpFNEE9PSIsInZhbHVlIjoiQXVlQnZzMEFkRkVWVVE2elBQVHYzclY4WVJTL01lengxdDEyaDlWNVVGTUMzV0VjeUFUK3h6M2QvT2hyVGpFbWRDUTVGbm13amxuUEpnZDlndlk3Ym5CZmwyd1FVWmtwdk80UHU5OVNkenNRV2Z5SnNwa3QwanZVWjlEWUxMU08iLCJtYWMiOiI3YTM2YWZlYjQyMjAyNDQwYTdjYzg2ZGZkZTc2ZjlkMmFhNjkwMDA4YWU4YjI1Nzg1MzdlMmFmMmZmMDk3MjBjIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 13:16:55 GMT; path=/; httponly ◀farmaya_session=eyJpdiI6IjVXWnZkZ3RIYWIzTUdWVS96NHpFNEE9PSIsInZhbHVlIjoiQXVlQnZzMEFkRkVWVVE2elBQVHYzclY4WVJTL01lengxdDEyaDlWNVVGTUMzV0VjeUFUK3h6M2QvT2hyVGpFbWRD ▶"
  ]
]

session_attributes

  0 of 0   
array:19 [▼
  "_token" => "nI1fvgKqhO0WuCdnm9f6TDHLWphJoVggarpgfHEc"
  "client_config" => {#3723 ▶
    +"name": "Farma Ya"
    +"email": "admin@farma.com"
    +"phone_number": "+971559339644"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#3724 ▶
      +"proxy_url": "https://images.farma-ya.com/insecure/fill/"
      +"image_path": "/sm/0/plain/https://farma-assets.s3.amazonaws.com/default/default_logo.png@webp"
      +"image_fit": "https://images.farma-ya.com/insecure/fit/"
      +"original": "https://farma-assets.s3.amazonaws.com/default/default_logo.png"
      +"logo_db_value": "default/default_logo.png"
    }
    +"company_name": "Farma Ya"
    +"company_address": "UK"
    +"status": 1
    +"code": "fe4568"
    +"database_name": "farma"
    +"database_host": "farma-db-prod.cn0iw2kcmmnd.us-east-1.rds.amazonaws.com"
    +"database_port": "3306"
    +"database_username": "farmaadmin"
    +"database_password": "cVaXi2Y6ukH11LheKir1"
    +"custom_domain": "farma-ya.com"
    +"sub_domain": "petludos"
  }
  "login_user_type" => "client"
  "customerLanguage" => 148
  "applocale" => "es"
  "client_primary_currency" => "MXN"
  "customerCurrency" => 98
  "currencySymbol" => "$"
  "currencyMultiplier" => "1.00000000"
  "iso_code" => "MXN"
  "vendorType" => "delivery"
  "selectedAddress" => "Ciudad de México, CDMX, México"
  "default_country_code" => "MX"
  "default_country_phonecode" => 52
  "preferences" => App\Models\ClientPreference {#3422 ▶
    #fillable: array:69 [▶
      0 => "client_code"
      1 => "theme_admin"
      2 => "distance_unit"
      3 => "currency_id"
      4 => "language_id"
      5 => "date_format"
      6 => "time_format"
      7 => "fb_client_id"
      8 => "fb_client_secret"
      9 => "fb_client_url"
      10 => "twitter_client_id"
      11 => "twitter_client_secret"
      12 => "twitter_client_url"
      13 => "google_client_id"
      14 => "google_client_secret"
      15 => "google_client_url"
      16 => "apple_client_id"
      17 => "apple_client_secret"
      18 => "apple_client_url"
      19 => "Default_location_name"
      20 => "Default_latitude"
      21 => "Default_longitude"
      22 => "map_provider"
      23 => "map_key"
      24 => "map_secret"
      25 => "sms_provider"
      26 => "sms_key"
      27 => "sms_secret"
      28 => "sms_from"
      29 => "verify_email"
      30 => "verify_phone"
      31 => "pharmacy_check"
      32 => "web_template_id"
      33 => "app_template_id"
      34 => "is_hyperlocal"
      35 => "need_delivery_service"
      36 => "dispatcher_key_1"
      37 => "dispatcher_key_2"
      38 => "need_dispacher_home_other_service"
      39 => "dispacher_home_other_service_key"
      40 => "dispacher_home_other_service_key_url"
      41 => "dispacher_home_other_service_key_code"
      42 => "last_mile_team"
      43 => "tip_before_order"
      44 => "tip_after_order"
      45 => "off_scheduling_at_cart"
      46 => "distance_unit_for_time"
      47 => "distance_to_time_multiplier"
      48 => "business_type"
      49 => "need_laundry_service"
      50 => "laundry_service_key"
      51 => "laundry_service_key_url"
      52 => "laundry_service_key_code"
      53 => "laundry_pickup_team"
      54 => "laundry_dropoff_team"
      55 => "delay_order"
      56 => "product_order_form"
      57 => "sms_credentials"
      58 => "is_edit_order_admin"
      59 => "is_edit_order_vendor"
      60 => "is_edit_order_driver"
      61 => "tools_mode"
      62 => "map_key_for_app"
      63 => "vendor_fcm_server_key"
      64 => "concise_signup"
      65 => "slots_with_service_area"
      66 => "is_service_area_for_banners"
      67 => "stop_order_acceptance_for_users"
      68 => "map_on_search_screen"
    ]
    #connection: "royo_farma"
    #table: "client_preferences"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:62 [▶
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "DD-MM-YYYY"
      "time_format" => "12"
      "fb_login" => 0
      "fb_client_id" => "admin@farma.com"
      "fb_client_secret" => "123456"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 1
      "google_client_id" => "655016437664-ac92jhacjmrpe2bfe1pq8fcu1e3j4g0h.apps.googleusercontent.com"
      "google_client_secret" => "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"
      "google_client_url" => "https://farma-ya.com/auth/callback/google"
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Ciudad de México, CDMX, México"
      "Default_latitude" => "19.432607700000"
      "Default_longitude" => "-99.133208000000"
      "map_provider" => 1
      "map_key" => "AIzaSyDdQU61eBjVX7g9HigVm7ujK-MbEU0PjeA"
      "sms_provider" => 1
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => 1
      "is_hyperlocal" => 1
      "need_delivery_service" => 1
      "need_dispacher_ride" => 0
      "delivery_service_key" => "1k3INvF70rWcyIjUGbOpF2yNTerYT9"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => null
      "fcm_auth_domain" => null
      "fcm_project_id" => null
      "fcm_storage_bucket" => null
      "fcm_messaging_sender_id" => null
      "fcm_app_id" => null
      "fcm_measurement_id" => null
      "distance_unit_for_time" => "kilometer"
      "distance_to_time_multiplier" => 2
      "delay_order" => 0
      "product_order_form" => 1
      "digit_after_decimal" => 2
      "dinein_check" => 1
      "takeaway_check" => 0
      "delivery_check" => 1
      "concise_signup" => 1
      "rental_check" => 0
      "pick_drop_check" => 0
      "on_demand_check" => 0
      "laundry_check" => 0
      "appointment_check" => 0
      "slots_with_service_area" => 0
      "is_vendor_tags" => 0
      "signup_image" => null
      "map_on_search_screen" => 1
    ]
    #original: array:62 [▶
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "DD-MM-YYYY"
      "time_format" => "12"
      "fb_login" => 0
      "fb_client_id" => "admin@farma.com"
      "fb_client_secret" => "123456"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 1
      "google_client_id" => "655016437664-ac92jhacjmrpe2bfe1pq8fcu1e3j4g0h.apps.googleusercontent.com"
      "google_client_secret" => "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"
      "google_client_url" => "https://farma-ya.com/auth/callback/google"
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Ciudad de México, CDMX, México"
      "Default_latitude" => "19.432607700000"
      "Default_longitude" => "-99.133208000000"
      "map_provider" => 1
      "map_key" => "AIzaSyDdQU61eBjVX7g9HigVm7ujK-MbEU0PjeA"
      "sms_provider" => 1
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => 1
      "is_hyperlocal" => 1
      "need_delivery_service" => 1
      "need_dispacher_ride" => 0
      "delivery_service_key" => "1k3INvF70rWcyIjUGbOpF2yNTerYT9"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => null
      "fcm_auth_domain" => null
      "fcm_project_id" => null
      "fcm_storage_bucket" => null
      "fcm_messaging_sender_id" => null
      "fcm_app_id" => null
      "fcm_measurement_id" => null
      "distance_unit_for_time" => "kilometer"
      "distance_to_time_multiplier" => 2
      "delay_order" => 0
      "product_order_form" => 1
      "digit_after_decimal" => 2
      "dinein_check" => 1
      "takeaway_check" => 0
      "delivery_check" => 1
      "concise_signup" => 1
      "rental_check" => 0
      "pick_drop_check" => 0
      "on_demand_check" => 0
      "laundry_check" => 0
      "appointment_check" => 0
      "slots_with_service_area" => 0
      "is_vendor_tags" => 0
      "signup_image" => null
      "map_on_search_screen" => 1
    ]
    #changes: []
    #casts: []
    #classCastCache: []
    #attributeCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "vendors" => array:1 [▶
    0 => 75
  ]
  "_previous" => array:1 [▶
    "url" => "https://petludos.com/vendor/veterinaria-san-juan?page=5"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Ciudad de México, CDMX, México

Idioma

Divisa

Cambiar de tema

Veterinaria San Juan

Royal Canin Gastro-Intestinal Low Fat Lata 0.385 KG

$105.00

Royal Canin Gastro-Intestinal Low Fat 3 KG

$899.00

Royal Canin Gastro-Intestinal Low Fat 8 KG

$1899.00

Royal Canin Gastro-Intestinal Low Fat 13 KG

$2689.00

Royal Canin GI Moderate calorie Lata 0.085 KG

$57.00

Royal Canin GI Moderate calorie 3.5 KG

$1349.00

Royal Canin ICU Liquid Recovery Canine/Feline (pack 4) 240 ML

$865.00

Royal Canin ICU Liquid Renal Support Canine (pack 4) 240 ML

$865.00

Royal Canin ICU Liquid GI Low Fat Canine (pack 4) 240 ML

$865.00

Royal Canin Recovery Lata 145 G

$89.00

Royal Canin Hepatic Lata 410 G

$105.00

Royal Canin Hepatic Lata 390 G

$105.00

Enlaces

Contáctanos

Descarga nuestra app

1 x Application (82.75%)	779ms
1 x Booting (17.25%)	162ms

Idioma

Divisa

Cambiar de tema

Veterinaria San Juan

Royal Canin Gastro-Intestinal Low Fat Lata 0.385 KG

$105.00

Royal Canin Gastro-Intestinal Low Fat 3 KG

$899.00

Royal Canin Gastro-Intestinal Low Fat 8 KG

$1899.00

Royal Canin Gastro-Intestinal Low Fat 13 KG

$2689.00

Royal Canin GI Moderate calorie Lata 0.085 KG

$57.00

Royal Canin GI Moderate calorie 3.5 KG

$1349.00

Royal Canin ICU Liquid Recovery Canine/Feline (pack 4) 240 ML

$865.00

Royal Canin ICU Liquid Renal Support Canine (pack 4) 240 ML

$865.00

Royal Canin ICU Liquid GI Low Fat Canine (pack 4) 240 ML

$865.00

Royal Canin Recovery Lata 145 G

$89.00

Royal Canin Hepatic Lata 410 G

$105.00

Royal Canin Hepatic Lata 390 G

$105.00

Eliminar carrito

You can only buy products for single vendor. Do you want to remove all your cart products to continue ?