Q4. Nuoc Chanh Da - Iced Lime Juice

Pho City

AED18.00

Quantity:

Order Now

Product Details

A zesty blend of lime juice, sugar, and water, chilled with ice - this refreshing Vietnamese drink offers a perfect balance of tart and sweet to quench your thirst.

Share It

Messages Timeline Exceptions Views9 Route Queries91 Models319 Mails Gate Session Request

7.4.33306ms17MBGET {vendor?}/product/{id?}

Booting (120ms)
Application (186ms)
1 x Application (60.74%)
186ms
1 x Booting (39.26%)
120ms

9 templates were rendered

frontend.product (resources/views/frontend/product.blade.php)11blade


shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available

Params
0	`shareComponent`
1	`sets`
2	`vendor_info`
3	`product`
4	`navCategories`
5	`newProducts`
6	`rating_details`
7	`is_inwishlist_btn`
8	`category`
9	`product_in_cart`
10	`is_available`

frontend.included_files.products_breadcrumb (resources/views/frontend/included_files/products_breadcrumb.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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available

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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description

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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`

layouts.store.title-meta (resources/views/layouts/store/title-meta.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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`

layouts.store.head-content (resources/views/layouts/store/head-content.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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`
46	`demo`

layouts.store.left-sidebar-template-three (resources/views/layouts/store/left-sidebar-template-three.blade.php)55blade


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`
46	`socket_url`
47	`admin_chat`
48	`driver_chat`
49	`customer_chat`
50	`db`
51	`auth_id`
52	`authData`
53	`dark_mode`
54	`body_class`

layouts.store.topbar-template-three (resources/views/layouts/store/topbar-template-three.blade.php)60blade


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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
pages

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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`
46	`socket_url`
47	`admin_chat`
48	`driver_chat`
49	`customer_chat`
50	`db`
51	`auth_id`
52	`authData`
53	`dark_mode`
54	`body_class`
55	`clientData`
56	`urlImg`
57	`languageList`
58	`currencyList`
59	`pages`

layouts.store.footer-content-template-three (resources/views/layouts/store/footer-content-template-three.blade.php)55blade


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`
46	`socket_url`
47	`admin_chat`
48	`driver_chat`
49	`customer_chat`
50	`db`
51	`auth_id`
52	`authData`
53	`dark_mode`
54	`body_class`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
img
__currentLoopData
image
k
loop
selectedVariant
product_quantity_in_cart
checkSlot
user
title
meta_title
meta_keyword
meta_description
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	`shareComponent`
21	`sets`
22	`vendor_info`
23	`product`
24	`navCategories`
25	`newProducts`
26	`rating_details`
27	`is_inwishlist_btn`
28	`category`
29	`product_in_cart`
30	`is_available`
31	`img`
32	`__currentLoopData`
33	`image`
34	`k`
35	`loop`
36	`selectedVariant`
37	`product_quantity_in_cart`
38	`checkSlot`
39	`user`
40	`title`
41	`meta_title`
42	`meta_keyword`
43	`meta_description`
44	`set_template`
45	`set_common_business_type`
46	`socket_url`
47	`admin_chat`
48	`driver_chat`
49	`customer_chat`
50	`db`
51	`auth_id`
52	`authData`
53	`dark_mode`
54	`body_class`

uri: GET {vendor?}/product/{id?}
middleware: web, languageSwitch, subdomain, domain
domain: {domain}
controller: App\Http\Controllers\Front\ProductController@index
namespace: App\Http\Controllers
prefix
where
as: productDetail
file: app/Http/Controllers/Front/ProductController.php:28-284

91 statements were executed, 40 of which were duplicated, 51 unique98.06ms

select `theme_admin`, `bulk_orders_check`, `checkout_direct_check`, `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` = 'd0a063' limit 1

9.26msmiddleware::domain:77royo_spryton

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

510μsmiddleware::domain:87royo_spryton

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` = 1 limit 1

530μsmiddleware::domain:97royo_spryton

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

660μsmiddleware::domain:102royo_spryton

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` = 1 limit 1

580μsmiddleware::domain:117royo_spryton

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

590μsmiddleware::domain:126royo_spryton

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` = 224

420μsmiddleware::domain:127royo_spryton

Metadata
Bindings	0. 224
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 `business_type` from `client_preferences` limit 1

370μs/app/helpers.php:4064royo_spryton

Metadata
Backtrace	15. /app/helpers.php:4064 17. /app/Http/Controllers/Front/ProductController.php:41 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')

410μs/app/helpers.php:4092royo_spryton

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

430μs/app/Http/Controllers/Front/FrontController.php:124royo_spryton

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:124 16. /app/Http/Controllers/Front/ProductController.php:41 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.28ms/app/Http/Controllers/Front/FrontController.php:249royo_spryton

Metadata
Bindings	0. 0
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:249 16. /app/Http/Controllers/Front/FrontController.php:144 17. /app/Http/Controllers/Front/ProductController.php:41 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1

1.14ms/app/Http/Controllers/Front/FrontController.php:285royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:285 15. /app/Http/Controllers/Front/FrontController.php:144 16. /app/Http/Controllers/Front/ProductController.php:41 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 (1, 430, 434, 440, 444, 451, 454, 463, 464, 466, 467, 472, 474, 475, 482, 483, 487, 489, 490, 491, 492, 499, 501, 511, 512, 516, 518, 526, 548, 549, 550, 552, 553, 568, 578, 580, 587, 589, 590, 601, 602, 604, 605, 606, 607, 608, 609, 611, 615, 617, 618, 620, 625, 626, 628, 631, 632, 633, 635, 636, 637, 638, 640, 642, 643, 644, 645, 646, 648, 651, 652, 655, 656, 657, 659, 660, 662, 664, 666, 668, 671, 675, 679, 680, 681, 683, 684, 685, 687, 688, 690, 691, 694, 696, 698, 699, 700, 702, 703, 704, 708) 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` = 1 and (`cts`.`language_id` = 1 or `cts`.`language_id` = 1) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `id` order by `position` asc, `categories`.`parent_id` asc

1.7ms/app/Http/Controllers/Front/FrontController.php:174royo_spryton

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 430 8. 434 9. 440 10. 444 11. 451 12. 454 13. 463 14. 464 15. 466 16. 467 17. 472 18. 474 19. 475 20. 482 21. 483 22. 487 23. 489 24. 490 25. 491 26. 492 27. 499 28. 501 29. 511 30. 512 31. 516 32. 518 33. 526 34. 548 35. 549 36. 550 37. 552 38. 553 39. 568 40. 578 41. 580 42. 587 43. 589 44. 590 45. 601 46. 602 47. 604 48. 605 49. 606 50. 607 51. 608 52. 609 53. 611 54. 615 55. 617 56. 618 57. 620 58. 625 59. 626 60. 628 61. 631 62. 632 63. 633 64. 635 65. 636 66. 637 67. 638 68. 640 69. 642 70. 643 71. 644 72. 645 73. 646 74. 648 75. 651 76. 652 77. 655 78. 656 79. 657 80. 659 81. 660 82. 662 83. 664 84. 666 85. 668 86. 671 87. 675 88. 679 89. 680 90. 681 91. 683 92. 684 93. 685 94. 687 95. 688 96. 690 97. 691 98. 694 99. 696 100. 698 101. 699 102. 700 103. 702 104. 703 105. 704 106. 708 107. 1 108. 4 109. 8 110. 1 111. 5 112. 1 113. 1 114. 1 115. 2 116. 1 117. 1 118. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:174 15. /app/Http/Controllers/Front/ProductController.php:41 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

Metadata

Bindings

0. 1
1. 3
2. 4
3. 5
4. 6
5. 11
6. 1
7. 430
8. 434
9. 440
10. 444
11. 451
12. 454
13. 463
14. 464
15. 466
16. 467
17. 472
18. 474
19. 475
20. 482
21. 483
22. 487
23. 489
24. 490
25. 491
26. 492
27. 499
28. 501
29. 511
30. 512
31. 516
32. 518
33. 526
34. 548
35. 549
36. 550
37. 552
38. 553
39. 568
40. 578
41. 580
42. 587
43. 589
44. 590
45. 601
46. 602
47. 604
48. 605
49. 606
50. 607
51. 608
52. 609
53. 611
54. 615
55. 617
56. 618
57. 620
58. 625
59. 626
60. 628
61. 631
62. 632
63. 633
64. 635
65. 636
66. 637
67. 638
68. 640
69. 642
70. 643
71. 644
72. 645
73. 646
74. 648
75. 651
76. 652
77. 655
78. 656
79. 657
80. 659
81. 660
82. 662
83. 664
84. 666
85. 668
86. 671
87. 675
88. 679
89. 680
90. 681
91. 683
92. 684
93. 685
94. 687
95. 688
96. 690
97. 691
98. 694
99. 696
100. 698
101. 699
102. 700
103. 702
104. 703
105. 704
106. 708
107. 1
108. 4
109. 8
110. 1
111. 5
112. 1
113. 1
114. 1
115. 2
116. 1
117. 1
118. 1

Backtrace

14. /app/Http/Controllers/Front/FrontController.php:174
15. /app/Http/Controllers/Front/ProductController.php:41
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`, `vendor_id` from `products` where `url_slug` = 'nuoc-chanh-da---iced-lime-juice-620-7654' and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'pho-city50') limit 1

1.14ms/app/Http/Controllers/Front/ProductController.php:45royo_spryton

Metadata
Bindings	0. nuoc-chanh-da---iced-lime-juice-620-7654 1. pho-city50
Backtrace	16. /app/Http/Controllers/Front/ProductController.php:45 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 `cart_products` where (`product_id` = 45135) and exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and (`unique_identifier` = 'sAs0MoGO1uW81vy8p7rDBqird3acjKb9EXBrwGap')) limit 1

1.97ms/app/Http/Controllers/Front/ProductController.php:57royo_spryton

Metadata
Bindings	0. 45135 1. sAs0MoGO1uW81vy8p7rDBqird3acjKb9EXBrwGap
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:57 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_preferences` where `id` > 0 limit 1

2.75ms/app/Http/Controllers/Front/FrontController.php:249royo_spryton

Metadata
Bindings	0. 0
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:249 16. /app/Http/Controllers/Front/ProductController.php:62 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`, `show_slot` from `vendors` where `delivery` = 1 and `status` = 1

1.81ms/app/Http/Controllers/Front/FrontController.php:285royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:285 15. /app/Http/Controllers/Front/ProductController.php:62 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`, `sku`, `inquiry_only`, `url_slug`, `weight`, `weight_unit`, `vendor_id`, `has_variant`, `has_inventory`, `averageRating`, `sell_when_out_of_stock`, `minimum_order_count`, `batch_count`, `additional_increments_min`, `minimum_duration_min`, `buffer_time_duration_min`, `minimum_duration`, `additional_increments`, `buffer_time_duration`, `tags` from `products` where exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'pho-city50') and `url_slug` = 'nuoc-chanh-da---iced-lime-juice-620-7654' and `is_live` = 1 limit 1

1.87ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Bindings	0. pho-city50 1. nuoc-chanh-da---iced-lime-juice-620-7654 2. 1
Backtrace	16. /app/Http/Controllers/Front/ProductController.php:133 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 `id`, `sku`, `product_id`, `title`, `quantity`, `price`, `position`, `compare_at_price`, `barcode`, `cost_price`, `currency_id`, `tax_category_id`, `container_charges`, `markup_price`, `incremental_price`, `incremental_price_per_min` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (45135) group by `product_id`

1.75ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_variant_id`, `variant_option_id` from `product_variant_sets` inner join `variant_options` as `opt` on `opt`.`id` = `product_variant_sets`.`variant_option_id` inner join `variants` as `vari` on `vari`.`id` = `opt`.`variant_id` where `product_variant_sets`.`product_variant_id` in (43554)

740μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	26. /app/Http/Controllers/Front/ProductController.php:133 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 `product_variant_id`, `product_image_id` from `product_variant_images` where `product_variant_images`.`product_variant_id` in (43554)

1.38ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	26. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `related_product_id` from `product_related` where `product_related`.`product_id` in (45135)

700μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `upsell_product_id` from `product_up_sells` where `product_up_sells`.`product_id` in (45135)

3.52ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `cross_product_id` from `product_cross_sells` where `product_cross_sells`.`product_id` in (45135)

460μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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`, `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` in (620)

1.83ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (45135)

790μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (62955)

1.73ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	26. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (45135) and `language_id` = 1

560μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_addons`.`product_id`, `set`.`min_select`, `set`.`max_select`, `ast`.`title`, `product_addons`.`addon_id` from `product_addons` inner join `addon_sets` as `set` on `set`.`id` = `product_addons`.`addon_id` inner join `addon_set_translations` as `ast` on `ast`.`addon_id` = `set`.`id` where `product_addons`.`product_id` in (45135) and `set`.`status` = 1 and `ast`.`language_id` = 1

1.34ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `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 `product_variant_sets`.`product_id` in (45135) and `vt`.`language_id` = 1 and `product_variant_sets`.`product_id` = 45135 and `vr`.`status` = 1 group by `variant_type_id` order by `product_variant_id` asc

1.47ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Bindings	0. 1 1. 45135 2. 1
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (45135)

1.3ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:133 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 `categories` where `deleted_at` is null and `categories`.`id` in (5195) and `categories`.`deleted_at` is null

850μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	26. /app/Http/Controllers/Front/ProductController.php:133 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 (1) and `categories`.`deleted_at` is null

7.67ms/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	31. /app/Http/Controllers/Front/ProductController.php:133 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 0 = 1 and `categories`.`deleted_at` is null

750μs/app/Http/Controllers/Front/ProductController.php:133royo_spryton

Metadata
Backtrace	36. /app/Http/Controllers/Front/ProductController.php:133 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 * from `client_currencies` where `currency_id` = 1 limit 1

690μs/app/Http/Controllers/Front/ProductController.php:136royo_spryton

Metadata
Bindings	0. 1
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:136 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 `id`, `sku`, `averageRating`, `url_slug`, `is_new`, `is_featured`, `vendor_id`, `inquiry_only`, `minimum_order_count`, `batch_count` from `products` where 0 = 1 and `category_id` is not null

700μs/app/Http/Controllers/Front/FrontController.php:417royo_spryton

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:417 15. /app/Http/Controllers/Front/ProductController.php:143 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` = 1 limit 1

630μs/app/Http/Controllers/Front/FrontController.php:336royo_spryton

Metadata
Bindings	0. 1
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:336 16. /app/Http/Controllers/Front/ProductController.php:150 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

630μs/app/helpers.php:4064royo_spryton

Metadata
Backtrace	15. /app/helpers.php:4064 25. /app/Http/Controllers/Front/FrontController.php:338 26. /app/Http/Controllers/Front/ProductController.php:150 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')

620μs/app/helpers.php:4092royo_spryton

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:4092 23. /app/Http/Controllers/Front/FrontController.php:338 24. /app/Http/Controllers/Front/ProductController.php:150 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 (620) and `is_live` = 1 and `category_id` is not null limit 6

950μs/app/Http/Controllers/Front/FrontController.php:362royo_spryton

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 620 8. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:362 15. /app/Http/Controllers/Front/ProductController.php:150 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 *, `created_at` as `time_zone_created_at` from `order_product_ratings` where (`product_id` = 45135)

670μs/app/Http/Controllers/Front/ProductController.php:158royo_spryton

Metadata
Bindings	0. 45135
Backtrace	14. /app/Http/Controllers/Front/ProductController.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 * from `categories` where `id` = 5195 and `categories`.`deleted_at` is null limit 1

690μs/app/Http/Controllers/Front/ProductController.php:161royo_spryton

Metadata
Bindings	0. 5195
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:161 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `product_variant_sets` where `product_id` = 45135

660μs/app/Http/Controllers/Front/ProductController.php:167royo_spryton

Metadata
Bindings	0. 45135
Backtrace	14. /app/Http/Controllers/Front/ProductController.php:167 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 `vendors` where `id` = 620 limit 1

1.26ms/app/Http/Controllers/Front/ProductController.php:233royo_spryton

Metadata
Bindings	0. 620
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:233 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 `clients` limit 1

730μs/app/Models/Vendor.php:59royo_spryton

Metadata
Backtrace	18. /app/Models/Vendor.php:59 26. /app/Http/Controllers/Front/ProductController.php:233 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 * from `clients` limit 1

2.78ms/app/Models/VendorSlot.php:13royo_spryton

Metadata
Backtrace	18. /app/Models/VendorSlot.php:13 26. /app/Models/Vendor.php:62 34. /app/Http/Controllers/Front/ProductController.php:233 35. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 36. /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` = 1) and `start_time` < '12:17:28' and `end_time` > '12:17:28' and `vendor_slots`.`vendor_id` in (620)

830μs/app/Http/Controllers/Front/ProductController.php:233royo_spryton

Metadata
Bindings	0. 1 1. 12:17:28 2. 12:17:28
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:233 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `clients` limit 1

650μs/app/Models/Vendor.php:90royo_spryton

Metadata
Backtrace	18. /app/Models/Vendor.php:90 26. /app/Http/Controllers/Front/ProductController.php:233 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 * from `vendor_slot_dates` where `specific_date` = '2025-06-29' and `start_time` < '12:17:28' and `end_time` > '12:17:28' and `vendor_slot_dates`.`vendor_id` in (620)

660μs/app/Http/Controllers/Front/ProductController.php:233royo_spryton

Metadata
Bindings	0. 2025-06-29 1. 12:17:28 2. 12:17:28
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:233 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

780μs/app/Http/Controllers/Front/ProductController.php:274royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:274 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 `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 `category_translations`.`category_id` = 5195 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc

750μsview::80dfbc4acb19f18db635e361345077f252d0cfbf:4royo_spryton

Metadata
Bindings	0. 5195 1. 1
Backtrace	19. view::80dfbc4acb19f18db635e361345077f252d0cfbf: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 `vendor_id` from `products` where `id` = 45135 limit 1

730μs/app/Models/ProductVariant.php:131royo_spryton

Metadata
Bindings	0. 45135
Backtrace	16. /app/Models/ProductVariant.php:131 22. view::4eb4224e3fa29ec6f587254af32e082aaf5761b4:179 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` = 620 limit 1

620μs/app/Models/ProductVariant.php:132royo_spryton

Metadata
Bindings	0. 620
Backtrace	16. /app/Models/ProductVariant.php:132 22. view::4eb4224e3fa29ec6f587254af32e082aaf5761b4:179 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

670μsview::caf1c69dc48b23dd51c15835bc0f4f88238301ec:2royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	15. view::caf1c69dc48b23dd51c15835bc0f4f88238301ec: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

670μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:4royo_spryton

Metadata
Bindings	0. 0
Backtrace	15. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:4 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

660μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:13royo_spryton

Metadata
Bindings	0. 1
Backtrace	14. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:13 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)

630μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:13royo_spryton

Metadata
Backtrace	19. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:13 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

640μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:16royo_spryton

Metadata
Backtrace	14. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:16 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 (1)

660μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:16royo_spryton

Metadata
Backtrace	19. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:16 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` = 1)) order by `order_by` asc

810μsview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:26royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:26 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, 10, 11, 12, 13) and `language_id` = 1

1.5msview::662feec7ea4ba4081316d799ac303ccefa1a0b7c:26royo_spryton

Metadata
Bindings	0. 1
Backtrace	19. view::662feec7ea4ba4081316d799ac303ccefa1a0b7c:26 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

640μsview::da76fb434c6642a583379067338387c825604598:4royo_spryton

Metadata
Bindings	0. 0
Backtrace	15. view::da76fb434c6642a583379067338387c825604598:4 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

580μsview::da76fb434c6642a583379067338387c825604598:9royo_spryton

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

400μsview::da76fb434c6642a583379067338387c825604598:9royo_spryton

Metadata
Backtrace	19. view::da76fb434c6642a583379067338387c825604598:9 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `client_currencies` order by `is_primary` desc

430μsview::da76fb434c6642a583379067338387c825604598:12royo_spryton

Metadata
Backtrace	14. view::da76fb434c6642a583379067338387c825604598:12 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 (1)

540μsview::da76fb434c6642a583379067338387c825604598:12royo_spryton

Metadata
Backtrace	19. view::da76fb434c6642a583379067338387c825604598:12 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` = 1)) order by `order_by` asc

770μsview::da76fb434c6642a583379067338387c825604598:22royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::da76fb434c6642a583379067338387c825604598:22 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, 10, 11, 12, 13) and `language_id` = 1

1.02msview::da76fb434c6642a583379067338387c825604598:22royo_spryton

Metadata
Bindings	0. 1
Backtrace	19. view::da76fb434c6642a583379067338387c825604598:22 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 '%Search%' limit 1

580μs/app/helpers.php:3252royo_spryton

Metadata
Bindings	0. %Search%
Backtrace	15. /app/helpers.php:3252 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` = 1

550μs/app/helpers.php:3252royo_spryton

Metadata
Bindings	0. 1
Backtrace	20. /app/helpers.php:3252 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 product, vendor, item%' limit 1

540μs/app/helpers.php:3252royo_spryton

Metadata
Bindings	0. %Search product, vendor, item%
Backtrace	15. /app/helpers.php:3252 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 `clients` where `id` > 0 limit 1

660μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:2royo_spryton

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

800μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:4royo_spryton

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::14eeec689ee7aa315ea1b6920b41786a0f6ffd28: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 * from `page_translations` where `page_translations`.`page_id` in (1, 2, 7, 10, 11, 12, 13) and `language_id` = 1

1.26msview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:4royo_spryton

Metadata
Bindings	0. 1
Backtrace	19. view::14eeec689ee7aa315ea1b6920b41786a0f6ffd28: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_languages` where `is_active` = 1 order by `is_primary` desc

390μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:5royo_spryton

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

410μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:5royo_spryton

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

380μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:6royo_spryton

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

390μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:6royo_spryton

Metadata
Backtrace	19. view::14eeec689ee7aa315ea1b6920b41786a0f6ffd28: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 `payment_methods` where `is_show` = 1

380μsview::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:7royo_spryton

Metadata
Bindings	0. 1
Backtrace	14. view::14eeec689ee7aa315ea1b6920b41786a0f6ffd28:7 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 `client_preferences` where (`id` = 1) limit 1

1.38msview::35719249bf0fa434db61fcaf8128aa0db77b6068:17royo_spryton

Metadata
Bindings	0. 1
Backtrace	15. view::35719249bf0fa434db61fcaf8128aa0db77b6068: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

560μs/app/helpers.php:3013royo_spryton

Metadata
Backtrace	18. /app/helpers.php:3013 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_spryton' and table_name = 'client_preference_additional'

970μs/app/helpers.php:2996royo_spryton

Metadata
Bindings	0. royo_spryton 1. client_preference_additional
Backtrace	11. /app/helpers.php:2996 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` = 'd0a063')

460μs/app/helpers.php:3017royo_spryton

Metadata
Bindings	0. gtag_id 1. fpixel_id 2. d0a063
Backtrace	14. /app/helpers.php:3017 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

510μs/app/helpers.php:3042royo_spryton

Metadata
Bindings	0. 1
Backtrace	19. /app/helpers.php:3042 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

410μs/app/helpers.php:3315royo_spryton

Metadata
Bindings	0. razorpay 1. 1
Backtrace	15. /app/helpers.php:3315 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

490μs/app/helpers.php:3328royo_spryton

Metadata
Bindings	0. khalti 1. 1
Backtrace	15. /app/helpers.php:3328 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

2.91ms/app/helpers.php:3294royo_spryton

Metadata
Backtrace	18. /app/helpers.php:3294 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.12ms/app/helpers.php:3294royo_spryton

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

990μs/app/helpers.php:3294royo_spryton

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

480μs/app/helpers.php:3306royo_spryton

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

530μs/app/helpers.php:3306royo_spryton

Metadata
Backtrace	18. /app/helpers.php:3306 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\PaymentMethod: 5
App\Models\Language: 4
App\Models\ClientCurrency: 6
App\Models\Currency: 4
App\Models\Client: 10
App\Models\Country: 1
App\Models\Type: 12
App\Models\Vendor: 205
App\Models\Product: 3
App\Models\ProductVariant: 1
App\Models\ClientLanguage: 5
App\Models\ProductImage: 1
App\Models\ProductTranslation: 1
App\Models\ProductCategory: 1
App\Models\Category: 3
App\Models\VendorSlot: 1
App\Models\WebStylingOption: 2
App\Models\Category_translation: 1
App\Models\Page: 21
App\Models\PageTranslation: 21
App\Models\Nomenclature: 1
App\Models\VendorMedia: 1
App\Models\ClientPreference: 9

_token: sAs0MoGO1uW81vy8p7rDBqird3acjKb9EXBrwGap
client_config: {#5936 +"name": "Spryton" +"email": "admin@spryton.com" +"phone_number": "7897897867" +"is_d...
login_user_type: client
customerLanguage: 1
applocale: en
client_primary_currency: AED
customerCurrency: 1
currencySymbol: AED
currencyMultiplier: 1.00000000
iso_code: AED
vendorType: delivery
selectedAddress: Dubai - United Arab Emirates
default_country_code: AE
default_country_phonecode: 971
preferences: App\Models\ClientPreference {#5557 #fillable: array:96 [ 0 => "client_code" 1 => "theme_ad...
vendors: array:101 [ 0 => 1 1 => 430 2 => 434 3 => 440 4 => 444 5 => 451 6 => 454 7 => 463 ...
_previous: array:1 [ "url" => "https://spryntz.com/pho-city50/product/nuoc-chanh-da---iced-lime-juice-620-765...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/pho-city50/product/nuoc-chanh-da---iced-lime-juice-620-7654

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "spryntz.com"
  ]
]

request_server

  0 of 0   
array:42 [▼
  "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_HOST" => "spryntz.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "spryntz.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.33.15"
  "REMOTE_PORT" => "11788"
  "REMOTE_ADDR" => "216.73.216.89"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/html/order/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/pho-city50/product/nuoc-chanh-da---iced-lime-juice-620-7654"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/html/order/public/index.php"
  "PATH_INFO" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1751185048.1774
  "REQUEST_TIME" => 1751185048
]

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 => "Sun, 29 Jun 2025 08:17:28 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJqOFRSWEFFNEVNaFYvV1MvT3NRN1E9PSIsInZhbHVlIjoiN3pyOEt4eWQxRnorbHN4eGZlV1lBS21uRW8vWmJWU1JvREMzRnNEbTh1QVlOTHlTYjB3TE54a1UrUEY2TDAxUFRzY1N0dUdLYXVQRWl0UEYzRWlLMCtoNDlXT1h2SWgvR1N6NjlaWFZoNVFKbS9MZm1DejhyTzJOOXVQc0tTN3YiLCJtYWMiOiI5YjZhZjhhZGE4YTE4YWI4NjVjMGY3NTdhYjhiNDg0YWE3MzQ4ZTBlYWIyMzhlNDc4ZTA1ZWNlNDE1NjkwNzEwIiwidGFnIjoiIn0%3D; expires=Mon, 29-Jun-2026 08:17:28 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjJqOFRSWEFFNEVNaFYvV1MvT3NRN1E9PSIsInZhbHVlIjoiN3pyOEt4eWQxRnorbHN4eGZlV1lBS21uRW8vWmJWU1JvREMzRnNEbTh1QVlOTHlTYjB3TE54a1UrUEY2TDAxUFRzY1N0d ▶"
    1 => "royoorders_session=eyJpdiI6Ik5qL1lnOGptZ3pyZERYRVI0TSt4Tnc9PSIsInZhbHVlIjoiRGJtRHZwVmlnb2QwSk9FUS9id3NQeFN0eEZ4emQxZSt3LzFhOGJESTd1bXMxOEVBN0Y0Y28wbGM3OFIxMWR5V0M3Q0pzYnNlRzRKdVFkaXpJcEp6VG1JalYvVmxZeTMzMjkxd0xVSGg1V0FhWTV0QW0wTW5TZ0srN1BZNm0zNWYiLCJtYWMiOiJiNzA1N2RiMzVhMjExM2JlZjU5ZGU1NTkxNzhhMThmODcwODE5NGNkYWIzNTE0ODdhNmU4NjM3ZDhlYmYwNDM2IiwidGFnIjoiIn0%3D; expires=Mon, 29-Jun-2026 08:17:28 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀royoorders_session=eyJpdiI6Ik5qL1lnOGptZ3pyZERYRVI0TSt4Tnc9PSIsInZhbHVlIjoiRGJtRHZwVmlnb2QwSk9FUS9id3NQeFN0eEZ4emQxZSt3LzFhOGJESTd1bXMxOEVBN0Y0Y28wbGM3OFIxMWR5V ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJqOFRSWEFFNEVNaFYvV1MvT3NRN1E9PSIsInZhbHVlIjoiN3pyOEt4eWQxRnorbHN4eGZlV1lBS21uRW8vWmJWU1JvREMzRnNEbTh1QVlOTHlTYjB3TE54a1UrUEY2TDAxUFRzY1N0dUdLYXVQRWl0UEYzRWlLMCtoNDlXT1h2SWgvR1N6NjlaWFZoNVFKbS9MZm1DejhyTzJOOXVQc0tTN3YiLCJtYWMiOiI5YjZhZjhhZGE4YTE4YWI4NjVjMGY3NTdhYjhiNDg0YWE3MzQ4ZTBlYWIyMzhlNDc4ZTA1ZWNlNDE1NjkwNzEwIiwidGFnIjoiIn0%3D; expires=Mon, 29-Jun-2026 08:17:28 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjJqOFRSWEFFNEVNaFYvV1MvT3NRN1E9PSIsInZhbHVlIjoiN3pyOEt4eWQxRnorbHN4eGZlV1lBS21uRW8vWmJWU1JvREMzRnNEbTh1QVlOTHlTYjB3TE54a1UrUEY2TDAxUFRzY1N0d ▶"
    1 => "royoorders_session=eyJpdiI6Ik5qL1lnOGptZ3pyZERYRVI0TSt4Tnc9PSIsInZhbHVlIjoiRGJtRHZwVmlnb2QwSk9FUS9id3NQeFN0eEZ4emQxZSt3LzFhOGJESTd1bXMxOEVBN0Y0Y28wbGM3OFIxMWR5V0M3Q0pzYnNlRzRKdVFkaXpJcEp6VG1JalYvVmxZeTMzMjkxd0xVSGg1V0FhWTV0QW0wTW5TZ0srN1BZNm0zNWYiLCJtYWMiOiJiNzA1N2RiMzVhMjExM2JlZjU5ZGU1NTkxNzhhMThmODcwODE5NGNkYWIzNTE0ODdhNmU4NjM3ZDhlYmYwNDM2IiwidGFnIjoiIn0%3D; expires=Mon, 29-Jun-2026 08:17:28 GMT; path=/; httponly ◀royoorders_session=eyJpdiI6Ik5qL1lnOGptZ3pyZERYRVI0TSt4Tnc9PSIsInZhbHVlIjoiRGJtRHZwVmlnb2QwSk9FUS9id3NQeFN0eEZ4emQxZSt3LzFhOGJESTd1bXMxOEVBN0Y0Y28wbGM3OFIxMWR5V ▶"
  ]
]

session_attributes

  0 of 0   
array:19 [▼
  "_token" => "sAs0MoGO1uW81vy8p7rDBqird3acjKb9EXBrwGap"
  "client_config" => {#5936 ▶
    +"name": "Spryton"
    +"email": "admin@spryton.com"
    +"phone_number": "7897897867"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#5937 ▶
      +"proxy_url": "https://images.spryntz.com/insecure/fill/"
      +"image_path": "/sm/0/plain/https://spryton-assetss.s3.me-central-1.amazonaws.com/default/default_logo.png@webp"
      +"image_fit": "https://images.spryntz.com/insecure/fit/"
      +"original": "https://spryton-assetss.s3.me-central-1.amazonaws.com/default/default_logo.png"
      +"logo_db_value": "default/default_logo.png"
    }
    +"company_name": "Spryton"
    +"company_address": "UAE"
    +"status": 1
    +"code": "d0a063"
    +"database_name": "spryton"
    +"database_host": "spryton-db-cluster.cxalfljfjvsy.me-central-1.rds.amazonaws.com"
    +"database_port": "3306"
    +"database_username": "sprytonadmin"
    +"database_password": "YeJwBEbI7m6lCmPm"
    +"custom_domain": "spryntz.com"
    +"sub_domain": "spryton"
  }
  "login_user_type" => "client"
  "customerLanguage" => 1
  "applocale" => "en"
  "client_primary_currency" => "AED"
  "customerCurrency" => 1
  "currencySymbol" => "AED"
  "currencyMultiplier" => "1.00000000"
  "iso_code" => "AED"
  "vendorType" => "delivery"
  "selectedAddress" => "Dubai - United Arab Emirates"
  "default_country_code" => "AE"
  "default_country_phonecode" => 971
  "preferences" => App\Models\ClientPreference {#5557 ▶
    #fillable: array:96 [▶
      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"
      69 => "delivery_fee_sharing"
      70 => "bulk_order"
      71 => "table_reservation"
      72 => "bulk_order"
      73 => "fleet_software"
      74 => "festive_marketing"
      75 => "personalise_loyalty_program"
      76 => "day_of_month"
      77 => "award_program"
      78 => "meal_membership"
      79 => "order_notification_driver"
      80 => "show_dark_mode"
      81 => "android_version"
      82 => "ios_version"
      83 => "ig_access_token"
      84 => "ig_user_id"
      85 => "ig_token_updated_at"
      86 => "ig_token_last_updated_at"
      87 => "ig_token_expired_at"
      88 => "festival_orders_enabled"
      89 => "preorder_del_start_time"
      90 => "preorder_del_end_time"
      91 => "preorder_del_interval"
      92 => "gift_order"
      93 => "gift_a_person"
      94 => "share_at_location"
      95 => "pay_it_forward"
    ]
    #connection: "royo_spryton"
    #table: "client_preferences"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:64 [▶
      "theme_admin" => "light"
      "bulk_orders_check" => 1
      "checkout_direct_check" => 0
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 0
      "fb_client_id" => "admin@spryton.com"
      "fb_client_secret" => "admin@spryton"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 0
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Dubai - United Arab Emirates"
      "Default_latitude" => "25.204849300000"
      "Default_longitude" => "55.270782800000"
      "map_provider" => 1
      "map_key" => "AIzaSyAHprXhmbKH0U5-pwp2RIx0IaF5gN1V6X4"
      "sms_provider" => 1
      "verify_email" => 1
      "verify_phone" => 1
      "web_template_id" => 1
      "is_hyperlocal" => 1
      "need_delivery_service" => 1
      "need_dispacher_ride" => 0
      "delivery_service_key" => "uljP1uHfjNe5fdyyFGrkLsCZlcNXp3"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => "AIzaSyB5oM2jSaQrkUtpowA8iCxsNta0H2FbAPk"
      "fcm_auth_domain" => "spryntz-order-app-578cc.firebaseapp.com"
      "fcm_project_id" => "spryntz-order-app-578cc"
      "fcm_storage_bucket" => "spryntz-order-app-578cc.appspot.com"
      "fcm_messaging_sender_id" => "759058985163"
      "fcm_app_id" => "1:759058985163:web:fc42a084726ea0c3952b4e"
      "fcm_measurement_id" => "G-80KVT1XM19"
      "distance_unit_for_time" => "kilometer"
      "distance_to_time_multiplier" => 2
      "delay_order" => 0
      "product_order_form" => 0
      "digit_after_decimal" => 2
      "dinein_check" => 0
      "takeaway_check" => 0
      "delivery_check" => 1
      "concise_signup" => 0
      "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" => 0
    ]
    #original: array:64 [▶
      "theme_admin" => "light"
      "bulk_orders_check" => 1
      "checkout_direct_check" => 0
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 0
      "fb_client_id" => "admin@spryton.com"
      "fb_client_secret" => "admin@spryton"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 0
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Dubai - United Arab Emirates"
      "Default_latitude" => "25.204849300000"
      "Default_longitude" => "55.270782800000"
      "map_provider" => 1
      "map_key" => "AIzaSyAHprXhmbKH0U5-pwp2RIx0IaF5gN1V6X4"
      "sms_provider" => 1
      "verify_email" => 1
      "verify_phone" => 1
      "web_template_id" => 1
      "is_hyperlocal" => 1
      "need_delivery_service" => 1
      "need_dispacher_ride" => 0
      "delivery_service_key" => "uljP1uHfjNe5fdyyFGrkLsCZlcNXp3"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => "AIzaSyB5oM2jSaQrkUtpowA8iCxsNta0H2FbAPk"
      "fcm_auth_domain" => "spryntz-order-app-578cc.firebaseapp.com"
      "fcm_project_id" => "spryntz-order-app-578cc"
      "fcm_storage_bucket" => "spryntz-order-app-578cc.appspot.com"
      "fcm_messaging_sender_id" => "759058985163"
      "fcm_app_id" => "1:759058985163:web:fc42a084726ea0c3952b4e"
      "fcm_measurement_id" => "G-80KVT1XM19"
      "distance_unit_for_time" => "kilometer"
      "distance_to_time_multiplier" => 2
      "delay_order" => 0
      "product_order_form" => 0
      "digit_after_decimal" => 2
      "dinein_check" => 0
      "takeaway_check" => 0
      "delivery_check" => 1
      "concise_signup" => 0
      "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" => 0
    ]
    #changes: []
    #casts: []
    #classCastCache: []
    #attributeCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "vendors" => array:101 [▶
    0 => 1
    1 => 430
    2 => 434
    3 => 440
    4 => 444
    5 => 451
    6 => 454
    7 => 463
    8 => 464
    9 => 466
    10 => 467
    11 => 472
    12 => 474
    13 => 475
    14 => 482
    15 => 483
    16 => 487
    17 => 489
    18 => 490
    19 => 491
    20 => 492
    21 => 499
    22 => 501
    23 => 511
    24 => 512
    25 => 516
    26 => 518
    27 => 526
    28 => 548
    29 => 549
    30 => 550
    31 => 552
    32 => 553
    33 => 568
    34 => 578
    35 => 580
    36 => 587
    37 => 589
    38 => 590
    39 => 601
    40 => 602
    41 => 604
    42 => 605
    43 => 606
    44 => 607
    45 => 608
    46 => 609
    47 => 611
    48 => 615
    49 => 617
    50 => 618
    51 => 620
    52 => 625
    53 => 626
    54 => 628
    55 => 631
    56 => 632
    57 => 633
    58 => 635
    59 => 636
    60 => 637
    61 => 638
    62 => 640
    63 => 642
    64 => 643
    65 => 644
    66 => 645
    67 => 646
    68 => 648
    69 => 651
    70 => 652
    71 => 655
    72 => 656
    73 => 657
    74 => 659
    75 => 660
    76 => 662
    77 => 664
    78 => 666
    79 => 668
    80 => 671
    81 => 675
    82 => 679
    83 => 680
    84 => 681
    85 => 683
    86 => 684
    87 => 685
    88 => 687
    89 => 688
    90 => 690
    91 => 691
    92 => 694
    93 => 696
    94 => 698
    95 => 699
    96 => 700
    97 => 702
    98 => 703
    99 => 704
    100 => 708
  ]
  "_previous" => array:1 [▶
    "url" => "https://spryntz.com/pho-city50/product/nuoc-chanh-da---iced-lime-juice-620-7654"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

language

currency

Change Theme

language

currency

Change Theme