Corte General | Petludos

Service Details

Fecha y hora

Payment

Do you have any specific instructions?

SERVICE DETAILS

;

Messages Timeline Exceptions Views10 Route Queries97 Models952 Mails Gate Session Request

7.4.33708ms16MBGET category/{slug?}

Booting (87.52ms)
Application (620ms)
1 x Application (87.63%)
620ms
1 x Booting (12.37%)
87.52ms

10 templates were rendered

frontend.ondemand.index (resources/views/frontend/ondemand/index.blade.php)11blade


clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories

Params
0	`clientCurrency`
1	`time_slots`
2	`period`
3	`cartData`
4	`addresses`
5	`countries`
6	`subscription_features`
7	`guest_user`
8	`listData`
9	`category`
10	`navCategories`

frontend.ondemand.ondemandSection (resources/views/frontend/ondemand/ondemandSection.blade.php)31blade


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories

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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`demo`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`
43	`clientData`
44	`urlImg`
45	`languageList`
46	`currencyList`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

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


__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
clientCurrency
time_slots
period
cartData
addresses
countries
subscription_features
guest_user
listData
category
navCategories
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	`clientCurrency`
21	`time_slots`
22	`period`
23	`cartData`
24	`addresses`
25	`countries`
26	`subscription_features`
27	`guest_user`
28	`listData`
29	`category`
30	`navCategories`
31	`title`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

uri: GET category/{slug?}
middleware: web, languageSwitch, subdomain, domain
domain: {domain}
controller: App\Http\Controllers\Front\CategoryController@categoryProduct
namespace: App\Http\Controllers
prefix
where
as: categoryDetail
file: app/Http/Controllers/Front/CategoryController.php:28-204

97 statements were executed, 42 of which were duplicated, 55 unique182ms

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

3.74msmiddleware::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

680μsmiddleware::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

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

720μsmiddleware::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

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

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

650μ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`, `icon`, `image`, `slug`, `type_id`, `can_add_products`, `parent_id`, `sub_cat_banners` from `categories` where `slug` = 'corte_general' and `categories`.`deleted_at` is null limit 1

670μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Bindings	0. corte_general
Backtrace	16. /app/Http/Controllers/Front/CategoryController.php:49 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 `category_id`, `tag` from `category_tags` where `category_tags`.`category_id` in (1042)

680μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `brand_categories`.`category_id`, `brand_categories`.`brand_id`, `brands`.`id`, `brands`.`image` from `brand_categories` inner join `brands` on `brands`.`id` = `brand_categories`.`brand_id` where `brand_categories`.`category_id` in (1042)

660μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `id`, `title` as `redirect_to`, `service_type` from `types` where `types`.`id` in (12)

780μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`image`, `type_id`, `types`.`title` as `redirect_to` from `categories` inner join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`parent_id` in (1042) and `categories`.`deleted_at` is null order by `position` asc

680μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `category_translations`.`name`, `category_translations`.`meta_title`, `category_translations`.`meta_description`, `category_translations`.`meta_keywords`, `category_translations`.`category_id` 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 (1042) and `category_translations`.`language_id` = 148 order by `cl`.`is_primary` desc

820μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (990) and `categories`.`deleted_at` is null

660μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:49 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 `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (985) and `categories`.`deleted_at` is null

660μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	26. /app/Http/Controllers/Front/CategoryController.php:49 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 `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (984) and `categories`.`deleted_at` is null

670μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	31. /app/Http/Controllers/Front/CategoryController.php:49 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 35. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `slug`, `parent_id` from `categories` where `categories`.`id` in (1) and `categories`.`deleted_at` is null

770μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	36. /app/Http/Controllers/Front/CategoryController.php:49 37. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 38. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 39. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 40. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `slug`, `parent_id` from `categories` where 0 = 1 and `categories`.`deleted_at` is null

700μs/app/Http/Controllers/Front/CategoryController.php:49royo_farma

Metadata
Backtrace	41. /app/Http/Controllers/Front/CategoryController.php:49 42. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 43. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 44. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 45. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

1.46ms/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/CategoryController.php:58 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.27ms/app/Http/Controllers/Front/FrontController.php:327royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:327 15. /app/Http/Controllers/Front/CategoryController.php:58 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)

1.11ms/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/CategoryController.php:58 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 `vendor_id` from `vendor_categories` where `category_id` = 1042 and `status` = 1

1.2ms/app/Http/Controllers/Front/CategoryController.php:80royo_farma

Metadata
Bindings	0. 1042 1. 1
Backtrace	14. /app/Http/Controllers/Front/CategoryController.php:80 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

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

Metadata
Backtrace	15. /app/helpers.php:1044 17. /app/Http/Controllers/Front/CategoryController.php:103 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')

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

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 15. /app/Http/Controllers/Front/CategoryController.php:103 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

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

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:164 16. /app/Http/Controllers/Front/CategoryController.php:103 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

1.95ms/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/CategoryController.php:103 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`

4.99ms/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/CategoryController.php:103 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)

2.01ms/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/CategoryController.php:103 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

6.4ms/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/CategoryController.php:103 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 `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 `vr`.`status` = 1 and `product_variant_sets`.`product_id` in (select `product_id` from `product_categories` where `category_id` = 1042) group by `product_variant_sets`.`variant_type_id`

1.84ms/app/Http/Controllers/Front/CategoryController.php:131royo_farma

Metadata
Bindings	0. 148 1. 1 2. 1042
Backtrace	14. /app/Http/Controllers/Front/CategoryController.php:131 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 `client_currencies` where `currency_id` = 98 limit 1

960μs/app/Http/Controllers/Front/CategoryController.php:285royo_farma

Metadata
Bindings	0. 98
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:285 16. /app/Http/Controllers/Front/CategoryController.php:135 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 count(*) as aggregate from `products` where `products`.`is_live` = 1 and `products`.`category_id` = 1042 and `products`.`vendor_id` in (75) and `products`.`deleted_at` is null

670μs/app/Http/Controllers/Front/CategoryController.php:309royo_farma

Metadata
Bindings	0. 1 1. 1042 2. 75
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:309 16. /app/Http/Controllers/Front/CategoryController.php:135 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_currencies` where `currency_id` = 98 limit 1

580μs/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/CategoryController.php:140 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

590μ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/CategoryController.php:140 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')

480μ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/CategoryController.php:140 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 `category_id` in (1042) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6

930μs/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. 1042 9. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:416 15. /app/Http/Controllers/Front/CategoryController.php:140 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 `clients` limit 1

600μs/app/Http/Controllers/Front/FrontController.php:756royo_farma

Metadata
Backtrace	18. /app/Http/Controllers/Front/FrontController.php:756 19. /app/Http/Controllers/Front/CategoryController.php:161 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

select * from `countries`

1.39ms/app/Http/Controllers/Front/FrontController.php:757royo_farma

Metadata
Backtrace	17. /app/Http/Controllers/Front/FrontController.php:757 18. /app/Http/Controllers/Front/CategoryController.php:161 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `is_gift`, `item_count`, `scheduled_date_time` from `carts` where `status` = '0' and `unique_identifier` = 'TJXKUfaLAseFQ9SJh32l5LdDFz2GK0GoUD2DM9BZ' limit 1

1.78ms/app/Http/Controllers/Front/FrontController.php:765royo_farma

Metadata
Bindings	0. 0 1. TJXKUfaLAseFQ9SJh32l5LdDFz2GK0GoUD2DM9BZ
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:765 16. /app/Http/Controllers/Front/CategoryController.php:161 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

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

Metadata
Backtrace	15. /app/helpers.php:1044 17. /app/Http/Controllers/Front/FrontController.php:772 18. /app/Http/Controllers/Front/CategoryController.php:161 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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

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

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 15. /app/Http/Controllers/Front/FrontController.php:772 16. /app/Http/Controllers/Front/CategoryController.php:161 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `client_languages` order by `is_primary` desc limit 1

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

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:164 16. /app/Http/Controllers/Front/FrontController.php:772 17. /app/Http/Controllers/Front/CategoryController.php:161 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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

1.19ms/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/FrontController.php:772 18. /app/Http/Controllers/Front/CategoryController.php:161 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

7.09ms/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/FrontController.php:772 17. /app/Http/Controllers/Front/CategoryController.php:161 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

830μs/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/FrontController.php:772 17. /app/Http/Controllers/Front/CategoryController.php:161 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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.39ms/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/FrontController.php:772 16. /app/Http/Controllers/Front/CategoryController.php:161 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `client_currencies` where `currency_id` = 98 limit 1

1.07ms/app/Http/Controllers/Front/CategoryController.php:182royo_farma

Metadata
Bindings	0. 98
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:182 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 `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1

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

1msview::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

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

3.42msview::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

8.46msview::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.57msview::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

18.67msview::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

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

2.76msview::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

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

3.68msview::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.63msview::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.46msview::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

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

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

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

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

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

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

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

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

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

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

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

670μ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 '%Laundry%' limit 1

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

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

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

570μ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 '%Search%' limit 1

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

580μ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 `clients` where `id` > 0 limit 1

1.1msview::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

840μsview::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

830μsview::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

1.03msview::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

930μsview::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.04msview::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

790μ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.3msview::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

570μs/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.17ms/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')

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

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

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

580μ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.1ms/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

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

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

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

860μ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: 8
App\Models\Country: 254
App\Models\Category: 501
App\Models\Type: 19
App\Models\ClientLanguage: 7
App\Models\Category_translation: 1
App\Models\VendorCategory: 6
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\Vendor: 96
App\Models\ClientPreference: 11

_token: TJXKUfaLAseFQ9SJh32l5LdDFz2GK0GoUD2DM9BZ
client_config: {#3719 +"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 ]
skip_addons: 1
_previous: array:1 [ "url" => "https://petludos.com/category/corte_general?dataset=1&step=2" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/category/corte_general

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

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

request_request

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

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InhTNFQwNDlDNUVOVjU5OFhZcVFwb2c9PSIsInZhbHVlIjoiTGJHNUVwQk1kVndxVnJlNFh4bWlybHE5d29DendiSEhLRkYxdERYbm1Jam1FRCtWdVJxWDZxQ0VIbFhsYURpNnlOYTdBaVlnU2NsL2ZWNS9XMis5RXJuV3FtZnBXcHhuelVva01VOThDdDQ4NHE0d1Zqekt4VTlvbEdhSEVJRUciLCJtYWMiOiIwNDBjYzBkYzk5NWM3NDAyMTk1ZTBhMWVkMDgwNTdmYzZmNTZkOGMwMDUzYTAzZmQ2MmEwMjgxOWUxMGY1ODZiIiwidGFnIjoiIn0%3D; farmaya_session=eyJpdiI6IjlwQlVTK0JRczBRS2diUFJrNEhMbEE9PSIsInZhbHVlIjoiYmVxSUFETHdBQjJTUVdnWjBiRmx2SVIvWHRSMjBPdkp3empZVXRzdCtGTmxxMHBOVlo1NlljK3lOVk03K3YxZFhORFBUQVpIZ1gxRFBnRmk0OUltQ0tVR0lOb3M3V0Vvckp3ck1PU1lUam15T09iUW1xRks4ZEdXUEJOSCsxaDIiLCJtYWMiOiI4ZWQzYWFkMmRiOGMzOGYxNWU5YjA3MTg0MTFmODM1YTRkYzE5ZmU4NTM1NjhlNDE0MDkwYzk3ZWUzYzVlNjIxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InhTNFQwNDlDNUVOVjU5OFhZcVFwb2c9PSIsInZhbHVlIjoiTGJHNUVwQk1kVndxVnJlNFh4bWlybHE5d29DendiSEhLRkYxdERYbm1Jam1FRCtWdVJxWDZxQ0VIbFhsYURpNnlOYTdBa ▶"
  ]
  "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:44 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6InhTNFQwNDlDNUVOVjU5OFhZcVFwb2c9PSIsInZhbHVlIjoiTGJHNUVwQk1kVndxVnJlNFh4bWlybHE5d29DendiSEhLRkYxdERYbm1Jam1FRCtWdVJxWDZxQ0VIbFhsYURpNnlOYTdBaVlnU2NsL2ZWNS9XMis5RXJuV3FtZnBXcHhuelVva01VOThDdDQ4NHE0d1Zqekt4VTlvbEdhSEVJRUciLCJtYWMiOiIwNDBjYzBkYzk5NWM3NDAyMTk1ZTBhMWVkMDgwNTdmYzZmNTZkOGMwMDUzYTAzZmQ2MmEwMjgxOWUxMGY1ODZiIiwidGFnIjoiIn0%3D; farmaya_session=eyJpdiI6IjlwQlVTK0JRczBRS2diUFJrNEhMbEE9PSIsInZhbHVlIjoiYmVxSUFETHdBQjJTUVdnWjBiRmx2SVIvWHRSMjBPdkp3empZVXRzdCtGTmxxMHBOVlo1NlljK3lOVk03K3YxZFhORFBUQVpIZ1gxRFBnRmk0OUltQ0tVR0lOb3M3V0Vvckp3ck1PU1lUam15T09iUW1xRks4ZEdXUEJOSCsxaDIiLCJtYWMiOiI4ZWQzYWFkMmRiOGMzOGYxNWU5YjA3MTg0MTFmODM1YTRkYzE5ZmU4NTM1NjhlNDE0MDkwYzk3ZWUzYzVlNjIxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InhTNFQwNDlDNUVOVjU5OFhZcVFwb2c9PSIsInZhbHVlIjoiTGJHNUVwQk1kVndxVnJlNFh4bWlybHE5d29DendiSEhLRkYxdERYbm1Jam1FRCtWdVJxWDZxQ0VIbFhsYURpNnlOYTdBa ▶"
  "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" => "34225"
  "REMOTE_ADDR" => "3.141.244.160"
  "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" => "/category/corte_general?step=2&dataset=1"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "step=2&dataset=1"
  "SCRIPT_FILENAME" => "/var/www/html/order_web/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744140824.5368
  "REQUEST_TIME" => 1744140824
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "TJXKUfaLAseFQ9SJh32l5LdDFz2GK0GoUD2DM9BZ"
  "farmaya_session" => "jamx8qd4zUe297fOBPDsfc5IB9oIe6IGEbLjsotu"
]

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 => "Tue, 08 Apr 2025 19:33:44 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illub2E1L09GZnF2bkxHU0ZQaDBkTHc9PSIsInZhbHVlIjoiRVZvT01pRytNOHJKZlY5blp5RFVmdnRpdXRPak9LL1Z1OHZBb2NWYkJjc3dTdE9KdkhUZlczVUxkY0FOUDdWMmpsemc5ZjdtZ0R4SnpsZEcrRkV1QnpIME45aGNHRS9ubjVXRXlNeTF6RXdvbXBHN08vNEdNRGhHVXNQN21wNFgiLCJtYWMiOiI4MzVkMTQ3NjBjNmNhOTA4ZmZkMmNmYTQzNTBjZGMxZmJmMjIwM2Q1OTQ4Y2ZkYjkwMmExM2ViYzk1NGUzMzQyIiwidGFnIjoiIn0%3D; expires=Wed, 08-Apr-2026 19:33:45 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Illub2E1L09GZnF2bkxHU0ZQaDBkTHc9PSIsInZhbHVlIjoiRVZvT01pRytNOHJKZlY5blp5RFVmdnRpdXRPak9LL1Z1OHZBb2NWYkJjc3dTdE9KdkhUZlczVUxkY0FOUDdWMmpsemc5Z ▶"
    1 => "farmaya_session=eyJpdiI6Iml5Sm5SdzRpT2piUVM1QUFNL0tXeFE9PSIsInZhbHVlIjoiTHRIVGh2QkpWUndDd285VUNxd2M2c0VWRXZtS1BrVlI2Wlc3Y0NnU2c0TEtRRjVXUWpmUEhmYVFkQzBpWjVQZHpkRFdpVmhMejhELzV6ZXNDV0wxMzBZT3BzQ2twdW1LMElueEdxekJSNk9BNHZvRjN1N2JYNk8zS2lxM3phUHIiLCJtYWMiOiJiODYzNmVjNjNjMDQxOWU3OGM2YjdlYjg1OGExMmIzZGE2NmIzZTRjODk5ZTRjOGJjMzcyNGYxMDllZWZkMmM0IiwidGFnIjoiIn0%3D; expires=Wed, 08-Apr-2026 19:33:45 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀farmaya_session=eyJpdiI6Iml5Sm5SdzRpT2piUVM1QUFNL0tXeFE9PSIsInZhbHVlIjoiTHRIVGh2QkpWUndDd285VUNxd2M2c0VWRXZtS1BrVlI2Wlc3Y0NnU2c0TEtRRjVXUWpmUEhmYVFkQzBpWjVQZHpk ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illub2E1L09GZnF2bkxHU0ZQaDBkTHc9PSIsInZhbHVlIjoiRVZvT01pRytNOHJKZlY5blp5RFVmdnRpdXRPak9LL1Z1OHZBb2NWYkJjc3dTdE9KdkhUZlczVUxkY0FOUDdWMmpsemc5ZjdtZ0R4SnpsZEcrRkV1QnpIME45aGNHRS9ubjVXRXlNeTF6RXdvbXBHN08vNEdNRGhHVXNQN21wNFgiLCJtYWMiOiI4MzVkMTQ3NjBjNmNhOTA4ZmZkMmNmYTQzNTBjZGMxZmJmMjIwM2Q1OTQ4Y2ZkYjkwMmExM2ViYzk1NGUzMzQyIiwidGFnIjoiIn0%3D; expires=Wed, 08-Apr-2026 19:33:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Illub2E1L09GZnF2bkxHU0ZQaDBkTHc9PSIsInZhbHVlIjoiRVZvT01pRytNOHJKZlY5blp5RFVmdnRpdXRPak9LL1Z1OHZBb2NWYkJjc3dTdE9KdkhUZlczVUxkY0FOUDdWMmpsemc5Z ▶"
    1 => "farmaya_session=eyJpdiI6Iml5Sm5SdzRpT2piUVM1QUFNL0tXeFE9PSIsInZhbHVlIjoiTHRIVGh2QkpWUndDd285VUNxd2M2c0VWRXZtS1BrVlI2Wlc3Y0NnU2c0TEtRRjVXUWpmUEhmYVFkQzBpWjVQZHpkRFdpVmhMejhELzV6ZXNDV0wxMzBZT3BzQ2twdW1LMElueEdxekJSNk9BNHZvRjN1N2JYNk8zS2lxM3phUHIiLCJtYWMiOiJiODYzNmVjNjNjMDQxOWU3OGM2YjdlYjg1OGExMmIzZGE2NmIzZTRjODk5ZTRjOGJjMzcyNGYxMDllZWZkMmM0IiwidGFnIjoiIn0%3D; expires=Wed, 08-Apr-2026 19:33:45 GMT; path=/; httponly ◀farmaya_session=eyJpdiI6Iml5Sm5SdzRpT2piUVM1QUFNL0tXeFE9PSIsInZhbHVlIjoiTHRIVGh2QkpWUndDd285VUNxd2M2c0VWRXZtS1BrVlI2Wlc3Y0NnU2c0TEtRRjVXUWpmUEhmYVFkQzBpWjVQZHpk ▶"
  ]
]

session_attributes

  0 of 0   
array:20 [▼
  "_token" => "TJXKUfaLAseFQ9SJh32l5LdDFz2GK0GoUD2DM9BZ"
  "client_config" => {#3719 ▶
    +"name": "Farma Ya"
    +"email": "admin@farma.com"
    +"phone_number": "+971559339644"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#3720 ▶
      +"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
  ]
  "skip_addons" => "1"
  "_previous" => array:1 [▶
    "url" => "https://petludos.com/category/corte_general?dataset=1&step=2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

Ciudad de México, CDMX, México

Idioma

Divisa

Cambiar de tema

Do you have any specific instructions?

SERVICE DETAILS

Enlaces

Contáctanos

Descarga nuestra app

1 x Application (87.63%)	620ms
1 x Booting (12.37%)	87.52ms

Idioma

Divisa

Cambiar de tema

Do you have any specific instructions?

SERVICE DETAILS

Cantidad total:

Eliminar carrito

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