JW Marriott

Dubai

$0.00

Product Details

Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface. It has survived not only five centuries, but also the leap into electronic typesetting, rema... Read More

Quantity :

Share It

Related products

Messages Timeline Exceptions Views15 Route Queries152 Models195 Mails Gate Session Request

7.4.33236ms19MBGET {vendor?}/product/{id?}

Booting (52.34ms)
Application (184ms)
1 x Application (77.85%)
184ms
1 x Booting (22.15%)
52.34ms

15 templates were rendered

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


productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct

Params
0	`productAvailability`
1	`productAttributes`
2	`pickup_time`
3	`drop_time`
4	`user_vendor`
5	`shareComponent`
6	`sets`
7	`vendor_info`
8	`product`
9	`navCategories`
10	`newProducts`
11	`rating_details`
12	`is_inwishlist_btn`
13	`category`
14	`product_in_cart`
15	`is_available`
16	`getAdditionalPreference`
17	`suggested_category_products`
18	`suggested_brand_products`
19	`suggested_vendor_products`
20	`coupon_list`
21	`attr_array`
22	`set_template`
23	`current_time_response`
24	`processorProduct`

frontend.included_files.products_breadcrumb (resources/views/frontend/included_files/products_breadcrumb.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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData

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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`

frontend.product-part.product-variant (resources/views/frontend/product-part/product-variant.blade.php)58blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore

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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`

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


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`

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


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`

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


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`demo`

layouts.shared.variables-constant-js (resources/views/layouts/shared/variables-constant-js.blade.php)86blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`

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


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`

layouts.store.left-sidebar-template-one (resources/views/layouts/store/left-sidebar-template-one.blade.php)86blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`

layouts.store.topbar-template-one (resources/views/layouts/store/topbar-template-one.blade.php)91blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
type
urlImg
compId
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`
86	`urlImg`
87	`compId`
88	`languageList`
89	`currencyList`
90	`pages`

layouts.store.search_template (resources/views/layouts/store/search_template.blade.php)92blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
type
urlImg
compId
languageList
currencyList
pages
searchPlaceholder

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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`
86	`urlImg`
87	`compId`
88	`languageList`
89	`currencyList`
90	`pages`
91	`searchPlaceholder`

layouts.store.search_template (resources/views/layouts/store/search_template.blade.php)92blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
type
urlImg
compId
languageList
currencyList
pages
searchPlaceholder

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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`
86	`urlImg`
87	`compId`
88	`languageList`
89	`currencyList`
90	`pages`
91	`searchPlaceholder`

layouts.store.remove_cart_model (resources/views/layouts/store/remove_cart_model.blade.php)93blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
type
urlImg
compId
languageList
currencyList
pages
searchPlaceholder
cate

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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`
86	`urlImg`
87	`compId`
88	`languageList`
89	`currencyList`
90	`pages`
91	`searchPlaceholder`
92	`cate`

layouts.store.footer-content-template-one (resources/views/layouts/store/footer-content-template-one.blade.php)86blade


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`

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


__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
data_trans_script_url
errors
productAvailability
productAttributes
pickup_time
drop_time
user_vendor
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
getAdditionalPreference
suggested_category_products
suggested_brand_products
suggested_vendor_products
coupon_list
attr_array
set_template
current_time_response
processorProduct
clientData
category_name
img
additionalPreference
__currentLoopData
image
k
loop
content
maxContentLength
fullContent
readMore
checkSlot
product_quantity_in_cart
__empty_1
related_product
user
user_type
to_message
from_message
chat_type
startChatype
apiPre
rePre
fetchDe
title
meta_title
meta_keyword
meta_description
set_common_business_type
dark_mode
analytics
getOnDemandPricingRule
is_ondemand_multi_pricing
body_class
left_sidebar
footer_content
selectedTemplate
p2pClass
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	`data_trans_script_url`
20	`errors`
21	`productAvailability`
22	`productAttributes`
23	`pickup_time`
24	`drop_time`
25	`user_vendor`
26	`shareComponent`
27	`sets`
28	`vendor_info`
29	`product`
30	`navCategories`
31	`newProducts`
32	`rating_details`
33	`is_inwishlist_btn`
34	`category`
35	`product_in_cart`
36	`is_available`
37	`getAdditionalPreference`
38	`suggested_category_products`
39	`suggested_brand_products`
40	`suggested_vendor_products`
41	`coupon_list`
42	`attr_array`
43	`set_template`
44	`current_time_response`
45	`processorProduct`
46	`clientData`
47	`category_name`
48	`img`
49	`additionalPreference`
50	`__currentLoopData`
51	`image`
52	`k`
53	`loop`
54	`content`
55	`maxContentLength`
56	`fullContent`
57	`readMore`
58	`checkSlot`
59	`product_quantity_in_cart`
60	`__empty_1`
61	`related_product`
62	`user`
63	`user_type`
64	`to_message`
65	`from_message`
66	`chat_type`
67	`startChatype`
68	`apiPre`
69	`rePre`
70	`fetchDe`
71	`title`
72	`meta_title`
73	`meta_keyword`
74	`meta_description`
75	`set_common_business_type`
76	`dark_mode`
77	`analytics`
78	`getOnDemandPricingRule`
79	`is_ondemand_multi_pricing`
80	`body_class`
81	`left_sidebar`
82	`footer_content`
83	`selectedTemplate`
84	`p2pClass`
85	`type`

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:34-466

152 statements were executed, 65 of which were duplicated, 87 unique57.67ms

select * from `client_preferences` where `client_code` = '37447b' limit 1

1.33msmiddleware::domain:79royo_trendsetter

Metadata
Bindings	0. 37447b
Backtrace	15. middleware::domain:79 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

350μsmiddleware::domain:89royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:89 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

340μsmiddleware::domain:99royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:99 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

480μsmiddleware::domain:104royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:104 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` = 147 limit 1

250μsmiddleware::domain:119royo_trendsetter

Metadata
Bindings	0. 147
Backtrace	15. middleware::domain:119 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

310μsmiddleware::domain:128royo_trendsetter

Metadata
Backtrace	18. middleware::domain:128 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` = 1

350μsmiddleware::domain:129royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	14. middleware::domain:129 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 * from `clients` limit 1

250μs/app/helpers.php:27royo_trendsetter

Metadata
Backtrace	18. /app/helpers.php:27 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_price_by_role')

290μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_price_by_role
Backtrace	14. /app/helpers.php:69 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

260μs/app/Http/Controllers/Front/ProductController.php:45royo_trendsetter

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

select `business_type`, `p2p_check` from `client_preferences` limit 1

200μs/app/helpers.php:1340royo_trendsetter

Metadata
Backtrace	15. /app/helpers.php:1340 17. /app/Http/Controllers/Front/FrontController.php:212 18. /app/Http/Controllers/Front/ProductController.php:53 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 17. /app/Http/Controllers/Front/FrontController.php:212 18. /app/Http/Controllers/Front/ProductController.php:53 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 17. /app/Http/Controllers/Front/FrontController.php:212 18. /app/Http/Controllers/Front/ProductController.php:53 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')

310μs/app/helpers.php:1418royo_trendsetter

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1418 15. /app/Http/Controllers/Front/FrontController.php:212 16. /app/Http/Controllers/Front/ProductController.php:53 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

210μs/app/Http/Controllers/Front/FrontController.php:298royo_trendsetter

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:298 16. /app/Http/Controllers/Front/FrontController.php:212 17. /app/Http/Controllers/Front/ProductController.php:53 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

570μs/app/Http/Controllers/Front/FrontController.php:425royo_trendsetter

Metadata
Bindings	0. 0
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:425 16. /app/Http/Controllers/Front/FrontController.php:315 17. /app/Http/Controllers/Front/FrontController.php:212 18. /app/Http/Controllers/Front/ProductController.php:53 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('vendor_online_status')

250μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. vendor_online_status
Backtrace	14. /app/helpers.php:69 24. /app/Http/Controllers/Front/FrontController.php:433 25. /app/Http/Controllers/Front/FrontController.php:315 26. /app/Http/Controllers/Front/FrontController.php:212 27. /app/Http/Controllers/Front/ProductController.php:53

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

440μs/app/Http/Controllers/Front/FrontController.php:465royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:465 15. /app/Http/Controllers/Front/FrontController.php:315 16. /app/Http/Controllers/Front/FrontController.php:212 17. /app/Http/Controllers/Front/ProductController.php:53 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 (2, 3, 4, 5, 6) 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 `categories`.`id` order by `position` asc, `categories`.`parent_id` asc

1.02ms/app/Http/Controllers/Front/FrontController.php:348royo_trendsetter

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 2 7. 3 8. 4 9. 5 10. 6 11. 1 12. 4 13. 8 14. 1 15. 5 16. 1 17. 1 18. 1 19. 2 20. 1 21. 1 22. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:348 15. /app/Http/Controllers/Front/FrontController.php:212 16. /app/Http/Controllers/Front/ProductController.php:53 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

910μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 18. /app/Http/Controllers/Front/ProductController.php:61 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 column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

830μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 18. /app/Http/Controllers/Front/ProductController.php:61 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`, `vendor_id`, `security_amount` from `products` where `url_slug` = 'jw' and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'dubai' and `status` = 1) and `products`.`deleted_at` is null limit 1

550μs/app/Http/Controllers/Front/ProductController.php:67royo_trendsetter

Metadata
Bindings	0. jw 1. dubai 2. 1
Backtrace	16. /app/Http/Controllers/Front/ProductController.php:67 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 `product_attributes` where `product_attributes`.`product_id` in (95) and `key_name` in ('Cabins', 'Berths', 'Baths')

380μs/app/Http/Controllers/Front/ProductController.php:67royo_trendsetter

Metadata
Bindings	0. Cabins 1. Berths 2. Baths
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:67 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 `processor_products` where `product_id` = 95 limit 1

410μs/app/Http/Controllers/Front/ProductController.php:69royo_trendsetter

Metadata
Bindings	0. 95
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:69 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 `cart_products` where (`product_id` = 95) and exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and (`unique_identifier` = 'C27X5y1pzSGtcfEZ3LXU9X5r8RNm9AbFp5CvBhzG')) limit 1

630μs/app/Http/Controllers/Front/ProductController.php:80royo_trendsetter

Metadata
Bindings	0. 95 1. C27X5y1pzSGtcfEZ3LXU9X5r8RNm9AbFp5CvBhzG
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:80 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 information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'product_attributes' and table_type = 'BASE TABLE'

830μs/app/helpers.php:1537royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. product_attributes
Backtrace	10. /app/helpers.php:1537 12. /app/Http/Controllers/Front/ProductController.php:95 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

240μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 16. /app/Http/Controllers/Front/ProductController.php:95 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 column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

820μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 18. /app/Http/Traits/ProductTrait.php:81 19. /app/Http/Controllers/Front/ProductController.php:95 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

790μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 18. /app/Http/Traits/ProductTrait.php:81 19. /app/Http/Controllers/Front/ProductController.php:95 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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`, `is_long_term_service`, `service_duration`, `returnable`, `replaceable`, `return_days`, `same_day_delivery`, `next_day_delivery`, `hyper_local_delivery`, `is_recurring_booking`, `security_amount`, `captain_name`, `calories`, `captain_profile`, `captain_description` from `products` where exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'dubai' and `status` = 1) and `url_slug` = 'jw' and `is_live` = 1 and `products`.`deleted_at` is null limit 1

480μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. dubai 1. 1 2. jw 3. 1
Backtrace	16. /app/Http/Traits/ProductTrait.php:83 17. /app/Http/Controllers/Front/ProductController.php:95 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 * from `product_availability` where `product_availability`.`product_id` in (95)

330μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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`, `minimum_duration`, `week_price`, `month_price` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (95) group by `product_id` order by `id` asc

440μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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 (99)

510μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	26. /app/Http/Traits/ProductTrait.php:83 27. /app/Http/Controllers/Front/ProductController.php:95 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_variant_id`, `product_image_id` from `product_variant_images` where `product_variant_images`.`product_variant_id` in (99)

310μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	26. /app/Http/Traits/ProductTrait.php:83 27. /app/Http/Controllers/Front/ProductController.php:95 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

820μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

790μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `slug`, `name`, `name_ar`, `desc`, `desc_ar`, `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`, `need_sync_with_order`, `is_seller`, `fixed_service_charge`, `service_charge_amount`, `pick_drop`, `return_request`, `phone_no`, `dial_code`, `same_day_delivery`, `next_day_delivery`, `hyper_local_delivery`, `cutOff_time`, `service_fee_percent`, `service_charges_tax_id`, `service_charges_tax`, `orders_per_slot` from `vendors` where `status` = 1 and `vendors`.`id` in (6)

330μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (95)

350μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (253, 254, 255, 256, 257)

350μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	26. /app/Http/Traits/ProductTrait.php:83 27. /app/Http/Controllers/Front/ProductController.php:95 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (95) and `language_id` = 1

410μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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 (95) and `set`.`status` = 1 and `ast`.`language_id` = 1

580μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /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`, `vr`.`position` 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 (95) and `vt`.`language_id` = 1 and `product_variant_sets`.`product_id` = 95 and `vr`.`status` = 1 group by `variant_type_id` order by `product_variant_id` asc, `vr`.`position` asc

510μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Bindings	0. 1 1. 95 2. 1
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (95)

330μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `categories` where `deleted_at` is null and `categories`.`id` in (26) and `categories`.`deleted_at` is null

390μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	26. /app/Http/Traits/ProductTrait.php:83 27. /app/Http/Controllers/Front/ProductController.php:95 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

210μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	31. /app/Http/Traits/ProductTrait.php:83 32. /app/Http/Controllers/Front/ProductController.php:95 33. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 34. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 35. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

170μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	36. /app/Http/Traits/ProductTrait.php:83 37. /app/Http/Controllers/Front/ProductController.php:95 38. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 39. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 40. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `long_term_service_periods` where `long_term_service_periods`.`product_id` in (95)

290μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `role_id`, `product_id`, `product_variant_id`, `amount`, `quantity` from `product_variant_by_roles` where `product_variant_by_roles`.`product_id` in (95)

330μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `product_attributes` where `product_attributes`.`product_id` in (95)

320μs/app/Http/Traits/ProductTrait.php:83royo_trendsetter

Metadata
Backtrace	21. /app/Http/Traits/ProductTrait.php:83 22. /app/Http/Controllers/Front/ProductController.php:95 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `order_vendor_products` where `order_vendor_products`.`product_id` = 95 and `order_vendor_products`.`product_id` is not null

460μs/app/Http/Controllers/Front/ProductController.php:98royo_trendsetter

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

select DATE_FORMAT(date_time, "%Y-%m-%d") as formatted_date from `product_availability` where `product_id` = 95 and `not_available` = 0

360μs/app/Http/Controllers/Front/ProductController.php:131royo_trendsetter

Metadata
Bindings	0. 95 1. 0
Backtrace	13. /app/Http/Controllers/Front/ProductController.php:131 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

340μs/app/Http/Traits/ProductActionTrait.php:157royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	15. /app/Http/Traits/ProductActionTrait.php:157 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

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

360μs/app/Http/Controllers/Front/ProductController.php:137royo_trendsetter

Metadata
Bindings	0. 147
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:137 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 `product_id`, `related_product_id` from `product_related` where `product_related`.`product_id` = 95 and `product_related`.`product_id` is not null

390μs/app/Http/Controllers/Front/ProductController.php:144royo_trendsetter

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

select `id`, `sku`, `averageRating`, `url_slug`, `is_new`, `is_featured`, `vendor_id`, `inquiry_only`, `minimum_order_count`, `batch_count` from `products` where `id` in (96, 97, 98) and `category_id` is not null and `products`.`deleted_at` is null

480μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Bindings	0. 96 1. 97 2. 98
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:607 15. /app/Http/Controllers/Front/ProductController.php:144 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_id`, `category_id` from `product_categories` where `product_categories`.`product_id` in (96, 97, 98)

230μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 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

select * from `categories` where `deleted_at` is null and `categories`.`id` in (27, 28, 29) and `categories`.`deleted_at` is null

310μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Backtrace	24. /app/Http/Controllers/Front/FrontController.php:607 25. /app/Http/Controllers/Front/ProductController.php:144 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

730μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	29. /app/Http/Controllers/Front/FrontController.php:607 30. /app/Http/Controllers/Front/ProductController.php:144 31. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 33. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

1.01ms/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_trendsetter' and table_name = 'vendors'

850μs/app/helpers.php:42royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. vendors
Backtrace	11. /app/helpers.php:42 19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `slug`, `name`, `name_ar`, `desc`, `desc_ar`, `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`, `need_sync_with_order`, `is_seller`, `fixed_service_charge`, `service_charge_amount`, `pick_drop`, `return_request`, `phone_no`, `dial_code`, `same_day_delivery`, `next_day_delivery`, `hyper_local_delivery`, `cutOff_time`, `service_fee_percent`, `service_charges_tax_id`, `service_charges_tax`, `orders_per_slot` from `vendors` where `status` = 1 and `vendors`.`id` in (6)

490μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 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

select `id`, `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (96, 97, 98) group by `product_id`

360μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 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

select `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (259, 260, 261)

340μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Backtrace	24. /app/Http/Controllers/Front/FrontController.php:607 25. /app/Http/Controllers/Front/ProductController.php:144 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `product_id`, `title`, `body_html`, `meta_title`, `meta_keyword`, `meta_description` from `product_translations` where `product_translations`.`product_id` in (96, 97, 98) and `language_id` = 1

430μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 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

select `sku`, `product_id`, `quantity`, `price`, `barcode` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (96, 97, 98) group by `product_id` order by `id` asc

450μs/app/Http/Controllers/Front/FrontController.php:607royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:607 20. /app/Http/Controllers/Front/ProductController.php:144 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

select `vendor_id`, `tax_category_id` from `products` where `id` = 96 and `products`.`deleted_at` is null limit 1

270μs/app/Models/ProductVariant.php:163royo_trendsetter

Metadata
Bindings	0. 96
Backtrace	15. /app/Models/ProductVariant.php:163 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 19. /app/Models/ProductVariant.php:164 25. /app/Http/Controllers/Front/FrontController.php:622

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

240μs/app/Models/ProductVariant.php:168royo_trendsetter

Metadata
Bindings	0. 6
Backtrace	16. /app/Models/ProductVariant.php:168 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 20. /app/Models/ProductVariant.php:169 26. /app/Http/Controllers/Front/FrontController.php:622

select `vendor_id`, `tax_category_id` from `products` where `id` = 97 and `products`.`deleted_at` is null limit 1

290μs/app/Models/ProductVariant.php:163royo_trendsetter

Metadata
Bindings	0. 97
Backtrace	15. /app/Models/ProductVariant.php:163 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 19. /app/Models/ProductVariant.php:164 25. /app/Http/Controllers/Front/FrontController.php:622

select `vendor_id`, `tax_category_id` from `products` where `id` = 98 and `products`.`deleted_at` is null limit 1

280μs/app/Models/ProductVariant.php:163royo_trendsetter

Metadata
Bindings	0. 98
Backtrace	15. /app/Models/ProductVariant.php:163 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 19. /app/Models/ProductVariant.php:164 25. /app/Http/Controllers/Front/FrontController.php:622

select *, `created_at` as `time_zone_created_at` from `order_product_ratings` where (`product_id` = 95)

370μs/app/Http/Controllers/Front/ProductController.php:146royo_trendsetter

Metadata
Bindings	0. 95
Backtrace	14. /app/Http/Controllers/Front/ProductController.php:146 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` = 147 limit 1

280μs/app/Http/Controllers/Front/FrontController.php:526royo_trendsetter

Metadata
Bindings	0. 147
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:526 16. /app/Http/Controllers/Front/ProductController.php:173 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`, `p2p_check` from `client_preferences` limit 1

300μs/app/helpers.php:1340royo_trendsetter

Metadata
Backtrace	15. /app/helpers.php:1340 25. /app/Http/Controllers/Front/FrontController.php:528 26. /app/Http/Controllers/Front/ProductController.php:173 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

270μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 25. /app/Http/Controllers/Front/FrontController.php:528 26. /app/Http/Controllers/Front/ProductController.php:173 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

240μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 25. /app/Http/Controllers/Front/FrontController.php:528 26. /app/Http/Controllers/Front/ProductController.php:173 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')

330μs/app/helpers.php:1418royo_trendsetter

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

580μs/app/Http/Controllers/Front/FrontController.php:552royo_trendsetter

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 6 8. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:552 15. /app/Http/Controllers/Front/ProductController.php:173 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 `categories` where `id` = 26 and `categories`.`deleted_at` is null limit 1

310μs/app/Http/Controllers/Front/ProductController.php:183royo_trendsetter

Metadata
Bindings	0. 26
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:183 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` = 95

380μs/app/Http/Controllers/Front/ProductController.php:189royo_trendsetter

Metadata
Bindings	0. 95
Backtrace	14. /app/Http/Controllers/Front/ProductController.php:189 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` = 6 limit 1

420μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter

Metadata
Bindings	0. 6
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:253 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

320μs/app/Models/Vendor.php:107royo_trendsetter

Metadata
Backtrace	18. /app/Models/Vendor.php:107 26. /app/Http/Controllers/Front/ProductController.php:253 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

300μs/app/Models/VendorSlot.php:13royo_trendsetter

Metadata
Backtrace	18. /app/Models/VendorSlot.php:13 26. /app/Models/Vendor.php:110 34. /app/Http/Controllers/Front/ProductController.php:253 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` = 6) and `start_time` < '09:19:42' and `end_time` > '09:19:42' and `vendor_slots`.`vendor_id` in (6)

690μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter

Metadata
Bindings	0. 6 1. 09:19:42 2. 09:19:42
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:253 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

300μs/app/Models/Vendor.php:133royo_trendsetter

Metadata
Backtrace	18. /app/Models/Vendor.php:133 26. /app/Http/Controllers/Front/ProductController.php:253 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-07-11' and `start_time` < '09:19:42' and `end_time` > '09:19:42' and `vendor_slot_dates`.`vendor_id` in (6)

500μs/app/Http/Controllers/Front/ProductController.php:253royo_trendsetter

Metadata
Bindings	0. 2025-07-11 1. 09:19:42 2. 09:19:42
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:253 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

470μs/app/Http/Controllers/Front/ProductController.php:294royo_trendsetter

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

300μs/app/helpers.php:401royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. /app/helpers.php:401 21. /app/Http/Controllers/Front/ProductController.php:353 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `promocodes`.`name`, `promocodes`.`short_desc`, `promo_types`.`title` as `promo_type_title`, `promocodes`.`amount`, `promocodes`.`promo_type_id` from `promocodes` inner join `promocode_details` on `promocode_details`.`promocode_id` = `promocodes`.`id` inner join `promo_types` on `promo_types`.`id` = `promocodes`.`promo_type_id` where date(`expiry_date`) >= '2025-07-11 09:19:42' and (`promocodes`.`promo_visibility` = 'public') and `promocodes`.`restriction_on` = '0' and `promocode_details`.`refrence_id` = 95

640μs/app/Http/Controllers/Front/PromoCodeController.php:407royo_trendsetter

Metadata
Bindings	0. 2025-07-11 09:19:42 1. public 2. 0 3. 95
Backtrace	14. /app/Http/Controllers/Front/PromoCodeController.php:407 15. /app/Http/Controllers/Front/ProductController.php:353 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 `promocodes`.`name`, `promocodes`.`short_desc`, `promo_types`.`title` as `promo_type_title`, `promocodes`.`amount`, `promocodes`.`promo_type_id` from `promocodes` inner join `promocode_details` on `promocode_details`.`promocode_id` = `promocodes`.`id` inner join `promo_types` on `promo_types`.`id` = `promocodes`.`promo_type_id` where date(`expiry_date`) >= '2025-07-11 09:19:42' and (`promocodes`.`promo_visibility` = 'public') and `promocodes`.`restriction_on` = '1' and `promocode_details`.`refrence_id` = 6

340μs/app/Http/Controllers/Front/PromoCodeController.php:410royo_trendsetter

Metadata
Bindings	0. 2025-07-11 09:19:42 1. public 2. 1 3. 6
Backtrace	14. /app/Http/Controllers/Front/PromoCodeController.php:410 15. /app/Http/Controllers/Front/ProductController.php:353 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 information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'product_attributes' and table_type = 'BASE TABLE'

1.06ms/app/helpers.php:1537royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. product_attributes
Backtrace	10. /app/helpers.php:1537 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from information_schema.tables where table_schema = 'royo_trendsetter' and table_name = 'attributes' and table_type = 'BASE TABLE'

900μs/app/helpers.php:1537royo_trendsetter

Metadata
Bindings	0. royo_trendsetter 1. attributes
Backtrace	10. /app/helpers.php:1537 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `product_bookings` where exists (select * from `order_vendor_products` where `product_bookings`.`id` = `order_vendor_products`.`product_id` and exists (select * from `products` where `order_vendor_products`.`product_id` = `products`.`id` and `vendor_id` = 6)) and `product_bookings`.`deleted_at` is null

630μs/app/Http/Controllers/Front/ProductController.php:447royo_trendsetter

Metadata
Bindings	0. 6
Backtrace	15. /app/Http/Controllers/Front/ProductController.php:447 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 `is_selected` = '1' limit 1

230μs/app/Http/Controllers/Front/ProductController.php:448royo_trendsetter

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

200μsview::260b530978e2d26a05e9deffacb2be4fe2714a92:2royo_trendsetter

Metadata
Backtrace	15. view::260b530978e2d26a05e9deffacb2be4fe2714a92: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 `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` = 26 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc

720μsview::ca7331e0bfe740c9224affdf4010864bad4c04ee:4royo_trendsetter

Metadata
Bindings	0. 26 1. 1
Backtrace	19. view::ca7331e0bfe740c9224affdf4010864bad4c04ee: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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_token_currency_enable', 'token_currency', 'add_to_cart_btn')

240μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_token_currency_enable 1. token_currency 2. add_to_cart_btn
Backtrace	14. /app/helpers.php:69 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 `vendor_id`, `tax_category_id` from `products` where `id` = 95 and `products`.`deleted_at` is null limit 1

260μs/app/Models/ProductVariant.php:163royo_trendsetter

Metadata
Bindings	0. 95
Backtrace	15. /app/Models/ProductVariant.php:163 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:391 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 19. /app/Models/ProductVariant.php:164 25. view::260b530978e2d26a05e9deffacb2be4fe2714a92:269

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_attribute
Backtrace	14. /app/helpers.php:69 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 `p2p_check` from `client_preferences` limit 1

290μs/app/helpers.php:1641royo_trendsetter

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

select `p2p_check` from `client_preferences` limit 1

210μs/app/helpers.php:1641royo_trendsetter

Metadata
Backtrace	18. /app/helpers.php:1641 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')

220μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_attribute
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')

220μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_attribute
Backtrace	14. /app/helpers.php:69 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 `p2p_check` from `client_preferences` limit 1

210μs/app/helpers.php:1641royo_trendsetter

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

select `p2p_check` from `client_preferences` limit 1

190μs/app/helpers.php:1641royo_trendsetter

Metadata
Backtrace	18. /app/helpers.php:1641 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_rental_weekly_monthly_price')

220μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_rental_weekly_monthly_price
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')

260μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_attribute
Backtrace	14. /app/helpers.php:69 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 `p2p_check` from `client_preferences` limit 1

190μs/app/helpers.php:1641royo_trendsetter

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

select `p2p_check` from `client_preferences` limit 1

200μs/app/helpers.php:1641royo_trendsetter

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

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

300μsview::bb0070d6e826c961912540be5a168503b5efb22b:2royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	15. view::bb0070d6e826c961912540be5a168503b5efb22b: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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')

260μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. enable_pwa
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_enable_google_analytics')

220μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_enable_google_analytics
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('gtag_id', 'fpixel_id', 'is_service_product_price_from_dispatch', 'is_service_price_selection')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. gtag_id 1. fpixel_id 2. is_service_product_price_from_dispatch 3. is_service_price_selection
Backtrace	14. /app/helpers.php:69 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

260μsview::41442c3efe13e76810609d24351acde26798236b:4royo_trendsetter

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

240μsview::41442c3efe13e76810609d24351acde26798236b:21royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	14. view::41442c3efe13e76810609d24351acde26798236b:21 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, 8)

220μsview::41442c3efe13e76810609d24351acde26798236b:21royo_trendsetter

Metadata
Backtrace	19. view::41442c3efe13e76810609d24351acde26798236b:21 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

340μsview::41442c3efe13e76810609d24351acde26798236b:24royo_trendsetter

Metadata
Backtrace	14. view::41442c3efe13e76810609d24351acde26798236b:24 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, 147)

330μsview::41442c3efe13e76810609d24351acde26798236b:24royo_trendsetter

Metadata
Backtrace	19. view::41442c3efe13e76810609d24351acde26798236b:24 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

620μsview::41442c3efe13e76810609d24351acde26798236b:34royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::41442c3efe13e76810609d24351acde26798236b:34 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, 3, 4, 5) and `language_id` = 1

320μsview::41442c3efe13e76810609d24351acde26798236b:34royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. view::41442c3efe13e76810609d24351acde26798236b:34 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

250μsview::f220542288b705a90d5521ad395f8225d7ef8a76:2royo_trendsetter

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

230μsview::f220542288b705a90d5521ad395f8225d7ef8a76:4royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	14. view::f220542288b705a90d5521ad395f8225d7ef8a76: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, 8)

250μsview::f220542288b705a90d5521ad395f8225d7ef8a76:4royo_trendsetter

Metadata
Backtrace	19. view::f220542288b705a90d5521ad395f8225d7ef8a76: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

210μsview::f220542288b705a90d5521ad395f8225d7ef8a76:5royo_trendsetter

Metadata
Backtrace	14. view::f220542288b705a90d5521ad395f8225d7ef8a76: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 (1, 147)

210μsview::f220542288b705a90d5521ad395f8225d7ef8a76:5royo_trendsetter

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

380μsview::f220542288b705a90d5521ad395f8225d7ef8a76:6royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::f220542288b705a90d5521ad395f8225d7ef8a76: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, 3, 4, 5) and `language_id` = 1

320μsview::f220542288b705a90d5521ad395f8225d7ef8a76:6royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. view::f220542288b705a90d5521ad395f8225d7ef8a76: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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_user_pre_signup')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_user_pre_signup
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_attribute')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_attribute
Backtrace	14. /app/helpers.php:69 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 `p2p_check` from `client_preferences` limit 1

200μs/app/helpers.php:1641royo_trendsetter

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

select `p2p_check` from `client_preferences` limit 1

190μs/app/helpers.php:1641royo_trendsetter

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

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

330μs/app/helpers.php:380royo_trendsetter

Metadata
Bindings	0. %Search%
Backtrace	15. /app/helpers.php:380 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 (13) and `language_id` = 1

360μs/app/helpers.php:380royo_trendsetter

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

230μs/app/helpers.php:380royo_trendsetter

Metadata
Bindings	0. %Search product, vendor, item%
Backtrace	15. /app/helpers.php:380 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

320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:2royo_trendsetter

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

390μsview::89b38f5c702e4146c7d59b11d7934d7718826251:4royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::89b38f5c702e4146c7d59b11d7934d7718826251: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, 3, 4, 5) and `language_id` = 1

330μsview::89b38f5c702e4146c7d59b11d7934d7718826251:4royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. view::89b38f5c702e4146c7d59b11d7934d7718826251: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

250μsview::89b38f5c702e4146c7d59b11d7934d7718826251:9royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	14. view::89b38f5c702e4146c7d59b11d7934d7718826251: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, 8)

220μsview::89b38f5c702e4146c7d59b11d7934d7718826251:9royo_trendsetter

Metadata
Backtrace	19. view::89b38f5c702e4146c7d59b11d7934d7718826251: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

210μsview::89b38f5c702e4146c7d59b11d7934d7718826251:10royo_trendsetter

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

220μsview::89b38f5c702e4146c7d59b11d7934d7718826251:10royo_trendsetter

Metadata
Backtrace	19. view::89b38f5c702e4146c7d59b11d7934d7718826251:10 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

330μsview::89b38f5c702e4146c7d59b11d7934d7718826251:12royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	14. view::89b38f5c702e4146c7d59b11d7934d7718826251: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 * from `client_preference_additional` where `key_name` = 'bottom_name' limit 1

240μsview::89b38f5c702e4146c7d59b11d7934d7718826251:13royo_trendsetter

Metadata
Bindings	0. bottom_name
Backtrace	15. view::89b38f5c702e4146c7d59b11d7934d7718826251:13 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 `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

330μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter

Metadata
Bindings	0. 1 1. 1
Backtrace	21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85 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

320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter

Metadata
Bindings	0. 2 1. 1
Backtrace	21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85 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` = 3 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter

Metadata
Bindings	0. 3 1. 1
Backtrace	21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85 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` = 4 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter

Metadata
Bindings	0. 4 1. 1
Backtrace	21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85 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` = 5 and `page_translations`.`page_id` is not null and `cl`.`is_primary` = 1 limit 1

320μsview::89b38f5c702e4146c7d59b11d7934d7718826251:85royo_trendsetter

Metadata
Bindings	0. 5 1. 1
Backtrace	21. view::89b38f5c702e4146c7d59b11d7934d7718826251:85 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 `show_subscription_plan_on_signups` where `show_subscription_plan_on_signups`.`id` = 1 limit 1

360μs/app/helpers.php:184royo_trendsetter

Metadata
Bindings	0. 1
Backtrace	19. /app/helpers.php:184 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_map_search_perticular_country')

230μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. is_map_search_perticular_country
Backtrace	14. /app/helpers.php:69 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('is_service_product_price_from_dispatch', 'is_service_price_selection')

240μs/app/helpers.php:69royo_trendsetter

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

300μs/app/helpers.php:443royo_trendsetter

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

240μs/app/helpers.php:456royo_trendsetter

Metadata
Bindings	0. khalti 1. 1
Backtrace	15. /app/helpers.php:456 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 `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('enable_pwa')

220μs/app/helpers.php:69royo_trendsetter

Metadata
Bindings	0. enable_pwa
Backtrace	14. /app/helpers.php:69 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

App\Models\ShowSubscriptionPlanOnSignup: 1
App\Models\Language: 7
App\Models\ClientCurrency: 9
App\Models\Currency: 7
App\Models\Client: 11
App\Models\Country: 1
App\Models\ClientPreferenceAdditional: 18
App\Models\Type: 12
App\Models\Vendor: 9
App\Models\Category: 10
App\Models\Product: 9
App\Models\ProcessorProduct: 1
App\Models\ClientLanguage: 8
App\Models\ProductVariant: 4
App\Models\VendorMedia: 8
App\Models\ProductTranslation: 4
App\Models\ProductCategory: 4
App\Models\WebStylingOption: 4
App\Models\ProductRelated: 3
App\Models\Category_translation: 4
App\Models\Page: 15
App\Models\PageTranslation: 20
App\Models\Nomenclature: 1
App\Models\PaymentMethod: 5
App\Models\ProductImage: 8
App\Models\ClientPreference: 12

_token: C27X5y1pzSGtcfEZ3LXU9X5r8RNm9AbFp5CvBhzG
client_config: {#4384 +"name": "trendsetter" +"email": "admin@trendsetter.com" +"phone_number": "07887898989"...
login_user_type: client
customerLanguage: 1
applocale: en
client_primary_currency: USD
customerCurrency: 147
currencySymbol: $
currencyMultiplier: 1.00000000
iso_code: USD
selectedAddress: Chandigarh, Punjab, India
vendorType: delivery
default_country_code: AF
default_country_phonecode: 93
preferences: App\Models\ClientPreference {#4004 #fillable: array:102 [ 0 => "client_code" 1 => "theme_a...
clientdata: App\Models\Client {#4386 #guard: "client" #fillable: array:28 [ 0 => "name" 1 => "email"...
userCode: 37447b
vendors: array:5 [ 0 => 2 1 => 3 2 => 4 3 => 5 4 => 6 ]
_previous: array:1 [ "url" => "https://trendsetter.ae/dubai/product/jw" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/dubai/product/jw

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 => "trendsetter.ae"
  ]
]

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" => "trendsetter.ae"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "trendsetter.ae"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "10.0.0.72"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "47493"
  "REMOTE_ADDR" => "216.73.216.171"
  "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/trendsetter_order/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/dubai/product/jw"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/html/order/trendsetter_order/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1752225582.3078
  "REQUEST_TIME" => 1752225582
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 11 Jul 2025 09:19:42 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJKWUFqMGY2VGF4VGp0N21GNU41enc9PSIsInZhbHVlIjoiR2ZtWE5hTTZYWjFBZEtmeUh6a1duOExiYVdjdGpVcGdyaEVzS1NJTjVqUDBzTnp0ZjBzNUpRMDdVWTB3eXVsZTUyREt5S1U2V2pmbGtTMmcxa1ZYUkVPT0Z2UVRYWkFwZElKbTR3SWtLS25PUGgxbnhmZXpEMU8weUpBQldTOVIiLCJtYWMiOiJhNjdiNzE5YWYzODdlOTdmN2NjM2FkOWEwODQwM2M0OGJiNzI4ZWMwZGJjNjQ3MzRiYzRkMDdjYWY1OGZhNjU1IiwidGFnIjoiIn0%3D; expires=Sat, 11-Jul-2026 09:19:42 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJKWUFqMGY2VGF4VGp0N21GNU41enc9PSIsInZhbHVlIjoiR2ZtWE5hTTZYWjFBZEtmeUh6a1duOExiYVdjdGpVcGdyaEVzS1NJTjVqUDBzTnp0ZjBzNUpRMDdVWTB3eXVsZTUyREt5S ▶"
    1 => "trendsetter_session=eyJpdiI6IjVZbGxoYXdONzlOV1VmNWpoZTY1SVE9PSIsInZhbHVlIjoiWjlXdXlNTENKeVdCTVR3ME5OZnFsTUZ6L2h0S2FQcHU3NHAvWEFwK1o3NytEQ1RrdWZrSUx5dVRtV3lXbUFqdmpUNDUxaFZ5Qm5mVzNROWhiMUhTWjNFcmluRlAxT29DeXVORWx3OS9yNUw4cStXRVZ0U1RQU1VWdVdvREt6NHkiLCJtYWMiOiJjYzdiYWVlYmM4ODU4YmI3NDhmY2YxOTg2ZmQ2Y2E1NWNmMTY4NGUwMmE3NWU0MWEzNjZiMjA4YWY2Nzk1OTdlIiwidGFnIjoiIn0%3D; expires=Sat, 11-Jul-2026 09:19:42 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀trendsetter_session=eyJpdiI6IjVZbGxoYXdONzlOV1VmNWpoZTY1SVE9PSIsInZhbHVlIjoiWjlXdXlNTENKeVdCTVR3ME5OZnFsTUZ6L2h0S2FQcHU3NHAvWEFwK1o3NytEQ1RrdWZrSUx5dVRtV3lXbUFq ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJKWUFqMGY2VGF4VGp0N21GNU41enc9PSIsInZhbHVlIjoiR2ZtWE5hTTZYWjFBZEtmeUh6a1duOExiYVdjdGpVcGdyaEVzS1NJTjVqUDBzTnp0ZjBzNUpRMDdVWTB3eXVsZTUyREt5S1U2V2pmbGtTMmcxa1ZYUkVPT0Z2UVRYWkFwZElKbTR3SWtLS25PUGgxbnhmZXpEMU8weUpBQldTOVIiLCJtYWMiOiJhNjdiNzE5YWYzODdlOTdmN2NjM2FkOWEwODQwM2M0OGJiNzI4ZWMwZGJjNjQ3MzRiYzRkMDdjYWY1OGZhNjU1IiwidGFnIjoiIn0%3D; expires=Sat, 11-Jul-2026 09:19:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJKWUFqMGY2VGF4VGp0N21GNU41enc9PSIsInZhbHVlIjoiR2ZtWE5hTTZYWjFBZEtmeUh6a1duOExiYVdjdGpVcGdyaEVzS1NJTjVqUDBzTnp0ZjBzNUpRMDdVWTB3eXVsZTUyREt5S ▶"
    1 => "trendsetter_session=eyJpdiI6IjVZbGxoYXdONzlOV1VmNWpoZTY1SVE9PSIsInZhbHVlIjoiWjlXdXlNTENKeVdCTVR3ME5OZnFsTUZ6L2h0S2FQcHU3NHAvWEFwK1o3NytEQ1RrdWZrSUx5dVRtV3lXbUFqdmpUNDUxaFZ5Qm5mVzNROWhiMUhTWjNFcmluRlAxT29DeXVORWx3OS9yNUw4cStXRVZ0U1RQU1VWdVdvREt6NHkiLCJtYWMiOiJjYzdiYWVlYmM4ODU4YmI3NDhmY2YxOTg2ZmQ2Y2E1NWNmMTY4NGUwMmE3NWU0MWEzNjZiMjA4YWY2Nzk1OTdlIiwidGFnIjoiIn0%3D; expires=Sat, 11-Jul-2026 09:19:42 GMT; path=/; httponly ◀trendsetter_session=eyJpdiI6IjVZbGxoYXdONzlOV1VmNWpoZTY1SVE9PSIsInZhbHVlIjoiWjlXdXlNTENKeVdCTVR3ME5OZnFsTUZ6L2h0S2FQcHU3NHAvWEFwK1o3NytEQ1RrdWZrSUx5dVRtV3lXbUFq ▶"
  ]
]

session_attributes

  0 of 0   
array:21 [▼
  "_token" => "C27X5y1pzSGtcfEZ3LXU9X5r8RNm9AbFp5CvBhzG"
  "client_config" => {#4384 ▶
    +"name": "trendsetter"
    +"email": "admin@trendsetter.com"
    +"phone_number": "07887898989"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#4385 ▶
      +"proxy_url": "https://images.royoorders.com/insecure/fill/"
      +"image_path": "/ce/0/plain/https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/default/default_logo.png@webp"
      +"image_fit": "https://images.royoorders.com/insecure/fit/"
      +"original": "https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/default/default_logo.png"
      +"logo_db_value": "default/default_logo.png"
    }
    +"company_name": "trendsetter"
    +"company_address": "CDCL Building, 28B, Sector 28, Chandigarh, India"
    +"status": 1
    +"code": "37447b"
    +"database_name": "trendsetter"
    +"database_host": "localhost"
    +"database_port": "3306"
    +"database_username": "root"
    +"database_password": "adg78t82g8iio92"
    +"custom_domain": "trendsetter.ae"
    +"sub_domain": "trendsetter"
  }
  "login_user_type" => "client"
  "customerLanguage" => 1
  "applocale" => "en"
  "client_primary_currency" => "USD"
  "customerCurrency" => 147
  "currencySymbol" => "$"
  "currencyMultiplier" => "1.00000000"
  "iso_code" => "USD"
  "selectedAddress" => "Chandigarh, Punjab, India"
  "vendorType" => "delivery"
  "default_country_code" => "AF"
  "default_country_phonecode" => 93
  "preferences" => App\Models\ClientPreference {#4004 ▶
    #fillable: array:102 [▶
      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 => "map_key_for_ios_app"
      64 => "vendor_fcm_server_key"
      65 => "concise_signup"
      66 => "slots_with_service_area"
      67 => "is_service_area_for_banners"
      68 => "stop_order_acceptance_for_users"
      69 => "map_on_search_screen"
      70 => "is_tax_price_inclusive"
      71 => "rating_check"
      72 => "dashboard_theme_color"
      73 => "enquire_mode"
      74 => "pharmacy_check"
      75 => "isolate_single_vendor_order"
      76 => "subscription_mode"
      77 => "subscription_tab_taxi"
      78 => "auto_implement_5_percent_tip"
      79 => "gifting"
      80 => "pickup_delivery_service_area"
      81 => "minimum_order_batch"
      82 => "static_delivey_fee"
      83 => "max_safety_mod"
      84 => "hide_order_address"
      85 => "category_kyc_documents"
      86 => "vendor_return_request"
      87 => "hide_order_prepare_time"
      88 => "is_cancel_order_user"
      89 => "book_for_friend"
      90 => "is_static_dropoff"
      91 => "is_scan_qrcode_bag"
      92 => "is_vendor_tags"
      93 => "dinein_check"
      94 => "takeaway_check"
      95 => "delivery_check"
      96 => "rental_check"
      97 => "pick_drop_check"
      98 => "on_demand_check"
      99 => "laundry_check"
      100 => "appointment_check"
      101 => "p2p_check"
    ]
    #connection: "royo_trendsetter"
    #table: "client_preferences"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:197 [▶
      "id" => 1
      "business_type" => "food_grocery_ecommerce"
      "rating_check" => 0
      "enquire_mode" => 0
      "hide_nav_bar" => 0
      "show_dark_mode" => 2
      "show_payment_icons" => 0
      "loyalty_check" => 0
      "show_icons" => 0
      "show_wishlist" => 0
      "show_contact_us" => 0
      "age_restriction" => 0
      "age_restriction_title" => null
      "subscription_mode" => 0
      "cart_enable" => 0
      "client_code" => "37447b"
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "language_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 1
      "fb_client_id" => "admin@trendsetter.com"
      "fb_client_secret" => "12345678"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => "admin@trendsetter.com"
      "twitter_client_secret" => "12345678"
      "twitter_client_url" => null
      "google_login" => 1
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 1
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Chandigarh, Punjab, India"
      "Default_latitude" => "30.538994400000"
      "Default_longitude" => "75.955032900000"
      "map_provider" => 1
      "map_key" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "map_secret" => null
      "sms_provider" => 1
      "sms_key" => "AC6025a83ef123b62b06c5454a8b40c28b"
      "sms_secret" => "34748004eca0c04b23391454549d2e33"
      "sms_from" => "TrendSetter"
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => 1
      "app_template_id" => 2
      "personal_access_token_v1" => null
      "personal_access_token_v2" => null
      "mail_type" => "smtp"
      "mail_driver" => null
      "mail_host" => null
      "mail_port" => null
      "mail_username" => null
      "mail_password" => null
      "mail_encryption" => null
      "mail_from" => null
      "is_hyperlocal" => 0
      "need_delivery_service" => 0
      "need_dispacher_ride" => 0
      "delivery_service_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "site_top_header_color" => "#4c4c4c"
      "dispatcher_key" => null
      "created_at" => null
      "updated_at" => "2024-10-09 11:16:32"
      "celebrity_check" => 0
      "delivery_service_key_url" => null
      "delivery_service_key_code" => null
      "reffered_by_amount" => "0.00000000"
      "reffered_to_amount" => "0.00000000"
      "favicon" => null
      "web_color" => null
      "pharmacy_check" => 0
      "dinein_check" => 0
      "takeaway_check" => 0
      "delivery_check" => 1
      "rental_check" => 0
      "car_rental_check" => 0
      "pick_drop_check" => 0
      "on_demand_check" => 0
      "laundry_check" => 0
      "appointment_check" => 0
      "pickup_delivery_service_key" => null
      "pickup_delivery_service_key_url" => null
      "pickup_delivery_service_key_code" => null
      "need_dispacher_home_other_service" => null
      "dispacher_home_other_service_key" => null
      "dispacher_home_other_service_key_url" => null
      "dispacher_home_other_service_key_code" => null
      "last_mile_team" => null
      "tip_before_order" => 0
      "tip_after_order" => 0
      "off_scheduling_at_cart" => 0
      "isolate_single_vendor_order" => 0
      "fcm_server_key" => null
      "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" => null
      "distance_to_time_multiplier" => 0
      "android_app_link" => null
      "ios_link" => null
      "single_vendor" => 0
      "stripe_connect" => 0
      "need_laundry_service" => 0
      "laundry_service_key" => null
      "laundry_service_key_url" => null
      "laundry_service_key_code" => null
      "laundry_pickup_team" => null
      "laundry_dropoff_team" => null
      "admin_email" => null
      "delay_order" => 0
      "gifting" => 0
      "product_order_form" => 0
      "sms_credentials" => "{"sms_key": "AC6025a83ef123b62b06c5454a8b40c28b", "sms_from": "TrendSetter", "sms_secret": "34748004eca0c04b23391454549d2e33", "static_otp": 0}"
      "pickup_delivery_service_area" => 0
      "customer_support" => null
      "customer_support_key" => null
      "customer_support_application_id" => null
      "shipping_mode" => 0
      "minimum_order_batch" => 0
      "is_edit_order_admin" => 0
      "is_edit_order_vendor" => 0
      "is_edit_order_driver" => 0
      "static_delivey_fee" => 0
      "header_quick_link" => 0
      "get_estimations" => 0
      "view_get_estimation_in_category" => 0
      "tools_mode" => 0
      "max_safety_mod" => 0
      "hide_order_address" => 0
      "digit_after_decimal" => 2
      "is_cancel_order_user" => 1
      "age_restriction_on_product_mode" => 0
      "show_qr_on_footer" => 0
      "auto_implement_5_percent_tip" => 0
      "need_xero" => 0
      "category_kyc_documents" => 0
      "vendor_return_request" => 1
      "db_audit_logs" => 0
      "deliveryicon" => null
      "dineinicon" => null
      "takewayicon" => null
      "rentalicon" => null
      "pick_dropicon" => null
      "on_demandicon" => null
      "laundryicon" => null
      "p2picon" => null
      "appointmenticon" => null
      "third_party_accounting" => 0
      "hide_order_prepare_time" => 0
      "map_key_for_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "map_key_for_ios_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "subscription_tab_taxi" => 0
      "need_inventory_service" => 0
      "inventory_service_key" => null
      "inventory_service_key_url" => null
      "inventory_service_key_code" => null
      "enable_inventory_service" => 0
      "scheduling_with_slots" => 0
      "same_day_delivery_for_schedule" => 0
      "same_day_orders_for_rescheduing" => 0
      "book_for_friend" => 0
      "order_cancellation_time" => null
      "cancellation_percentage" => null
      "estimation_matching_logic" => null
      "vendor_fcm_server_key" => null
      "sos" => 0
      "sos_police_contact" => null
      "sos_ambulance_contact" => null
      "concise_signup" => 0
      "is_static_dropoff" => 0
      "is_scan_qrcode_bag" => 0
      "slots_with_service_area" => 0
      "is_vendor_tags" => 0
      "is_service_area_for_banners" => 0
      "stop_order_acceptance_for_users" => 0
      "need_appointment_service" => null
      "appointment_service_key" => null
      "appointment_service_key_url" => null
      "appointment_service_key_code" => null
      "signup_image" => null
      "map_on_search_screen" => 0
      "p2p_check" => 0
      "dashboard_theme_color" => "#4c4c4c"
      "is_hourly_pickup_rental" => 0
    ]
    #original: array:197 [▶
      "id" => 1
      "business_type" => "food_grocery_ecommerce"
      "rating_check" => 0
      "enquire_mode" => 0
      "hide_nav_bar" => 0
      "show_dark_mode" => 2
      "show_payment_icons" => 0
      "loyalty_check" => 0
      "show_icons" => 0
      "show_wishlist" => 0
      "show_contact_us" => 0
      "age_restriction" => 0
      "age_restriction_title" => null
      "subscription_mode" => 0
      "cart_enable" => 0
      "client_code" => "37447b"
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "language_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 1
      "fb_client_id" => "admin@trendsetter.com"
      "fb_client_secret" => "12345678"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => "admin@trendsetter.com"
      "twitter_client_secret" => "12345678"
      "twitter_client_url" => null
      "google_login" => 1
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 1
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Chandigarh, Punjab, India"
      "Default_latitude" => "30.538994400000"
      "Default_longitude" => "75.955032900000"
      "map_provider" => 1
      "map_key" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "map_secret" => null
      "sms_provider" => 1
      "sms_key" => "AC6025a83ef123b62b06c5454a8b40c28b"
      "sms_secret" => "34748004eca0c04b23391454549d2e33"
      "sms_from" => "TrendSetter"
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => 1
      "app_template_id" => 2
      "personal_access_token_v1" => null
      "personal_access_token_v2" => null
      "mail_type" => "smtp"
      "mail_driver" => null
      "mail_host" => null
      "mail_port" => null
      "mail_username" => null
      "mail_password" => null
      "mail_encryption" => null
      "mail_from" => null
      "is_hyperlocal" => 0
      "need_delivery_service" => 0
      "need_dispacher_ride" => 0
      "delivery_service_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "site_top_header_color" => "#4c4c4c"
      "dispatcher_key" => null
      "created_at" => null
      "updated_at" => "2024-10-09 11:16:32"
      "celebrity_check" => 0
      "delivery_service_key_url" => null
      "delivery_service_key_code" => null
      "reffered_by_amount" => "0.00000000"
      "reffered_to_amount" => "0.00000000"
      "favicon" => null
      "web_color" => null
      "pharmacy_check" => 0
      "dinein_check" => 0
      "takeaway_check" => 0
      "delivery_check" => 1
      "rental_check" => 0
      "car_rental_check" => 0
      "pick_drop_check" => 0
      "on_demand_check" => 0
      "laundry_check" => 0
      "appointment_check" => 0
      "pickup_delivery_service_key" => null
      "pickup_delivery_service_key_url" => null
      "pickup_delivery_service_key_code" => null
      "need_dispacher_home_other_service" => null
      "dispacher_home_other_service_key" => null
      "dispacher_home_other_service_key_url" => null
      "dispacher_home_other_service_key_code" => null
      "last_mile_team" => null
      "tip_before_order" => 0
      "tip_after_order" => 0
      "off_scheduling_at_cart" => 0
      "isolate_single_vendor_order" => 0
      "fcm_server_key" => null
      "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" => null
      "distance_to_time_multiplier" => 0
      "android_app_link" => null
      "ios_link" => null
      "single_vendor" => 0
      "stripe_connect" => 0
      "need_laundry_service" => 0
      "laundry_service_key" => null
      "laundry_service_key_url" => null
      "laundry_service_key_code" => null
      "laundry_pickup_team" => null
      "laundry_dropoff_team" => null
      "admin_email" => null
      "delay_order" => 0
      "gifting" => 0
      "product_order_form" => 0
      "sms_credentials" => "{"sms_key": "AC6025a83ef123b62b06c5454a8b40c28b", "sms_from": "TrendSetter", "sms_secret": "34748004eca0c04b23391454549d2e33", "static_otp": 0}"
      "pickup_delivery_service_area" => 0
      "customer_support" => null
      "customer_support_key" => null
      "customer_support_application_id" => null
      "shipping_mode" => 0
      "minimum_order_batch" => 0
      "is_edit_order_admin" => 0
      "is_edit_order_vendor" => 0
      "is_edit_order_driver" => 0
      "static_delivey_fee" => 0
      "header_quick_link" => 0
      "get_estimations" => 0
      "view_get_estimation_in_category" => 0
      "tools_mode" => 0
      "max_safety_mod" => 0
      "hide_order_address" => 0
      "digit_after_decimal" => 2
      "is_cancel_order_user" => 1
      "age_restriction_on_product_mode" => 0
      "show_qr_on_footer" => 0
      "auto_implement_5_percent_tip" => 0
      "need_xero" => 0
      "category_kyc_documents" => 0
      "vendor_return_request" => 1
      "db_audit_logs" => 0
      "deliveryicon" => null
      "dineinicon" => null
      "takewayicon" => null
      "rentalicon" => null
      "pick_dropicon" => null
      "on_demandicon" => null
      "laundryicon" => null
      "p2picon" => null
      "appointmenticon" => null
      "third_party_accounting" => 0
      "hide_order_prepare_time" => 0
      "map_key_for_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "map_key_for_ios_app" => "AIzaSyAgsZO6KnHM-3nb-LoUXRSHj3BLDhk8qZo"
      "subscription_tab_taxi" => 0
      "need_inventory_service" => 0
      "inventory_service_key" => null
      "inventory_service_key_url" => null
      "inventory_service_key_code" => null
      "enable_inventory_service" => 0
      "scheduling_with_slots" => 0
      "same_day_delivery_for_schedule" => 0
      "same_day_orders_for_rescheduing" => 0
      "book_for_friend" => 0
      "order_cancellation_time" => null
      "cancellation_percentage" => null
      "estimation_matching_logic" => null
      "vendor_fcm_server_key" => null
      "sos" => 0
      "sos_police_contact" => null
      "sos_ambulance_contact" => null
      "concise_signup" => 0
      "is_static_dropoff" => 0
      "is_scan_qrcode_bag" => 0
      "slots_with_service_area" => 0
      "is_vendor_tags" => 0
      "is_service_area_for_banners" => 0
      "stop_order_acceptance_for_users" => 0
      "need_appointment_service" => null
      "appointment_service_key" => null
      "appointment_service_key_url" => null
      "appointment_service_key_code" => null
      "signup_image" => null
      "map_on_search_screen" => 0
      "p2p_check" => 0
      "dashboard_theme_color" => "#4c4c4c"
      "is_hourly_pickup_rental" => 0
    ]
    #changes: []
    #casts: []
    #classCastCache: []
    #attributeCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "clientdata" => App\Models\Client {#4386 ▶
    #guard: "client"
    #fillable: array:28 [▶
      0 => "name"
      1 => "email"
      2 => "password"
      3 => "encpass"
      4 => "phone_number"
      5 => "database_path"
      6 => "database_name"
      7 => "database_username"
      8 => "database_password"
      9 => "logo"
      10 => "company_name"
      11 => "company_address"
      12 => "custom_domain"
      13 => "status"
      14 => "code"
      15 => "country_id"
      16 => "timezone"
      17 => "is_deleted"
      18 => "is_blocked"
      19 => "sub_domain"
      20 => "socket_url"
      21 => "admin_chat"
      22 => "driver_chat"
      23 => "customer_chat"
      24 => "dark_logo"
      25 => "lumen_timestamp"
      26 => "is_lumen_key_expired"
      27 => "contact_email"
    ]
    #hidden: array:1 [▶
      0 => "remember_token"
    ]
    #casts: array:1 [▶
      "email_verified_at" => "datetime"
    ]
    #connection: "royo_trendsetter"
    #table: "clients"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:42 [▶
      "id" => 1
      "name" => "trendsetter"
      "email" => "admin@trendsetter.com"
      "phone_number" => "07887898989"
      "password" => "$2y$10$WIFJni0hHBjqwzyjq2EbsOSUZKw4BQCJIDEuuetgSr3pDHKdnLb/G"
      "encpass" => null
      "country_id" => 1
      "timezone" => "Africa/Abidjan"
      "custom_domain" => "trendsetter.ae"
      "sub_domain" => "trendsetter"
      "is_deleted" => 0
      "is_blocked" => 0
      "database_path" => ""
      "database_name" => "trendsetter"
      "database_username" => "root"
      "database_password" => "adg78t82g8iio92"
      "logo" => "Clientlogo/664c4518ba101.png"
      "company_name" => "trendsetter"
      "company_address" => "CDCL Building, 28B, Sector 28, Chandigarh, India"
      "language_id" => null
      "status" => 1
      "code" => "37447b"
      "contact_email" => null
      "contact_address" => null
      "contact_phone_number" => null
      "created_at" => null
      "updated_at" => "2024-05-21 06:54:16"
      "database_host" => "localhost"
      "database_port" => "3306"
      "is_superadmin" => 1
      "whatsapp_url" => null
      "socket_url" => null
      "admin_chat" => 2
      "driver_chat" => 2
      "customer_chat" => 2
      "dark_logo" => "Clientlogo/664c4518c83d7.png"
      "is_lumen_enabled" => 0
      "lumen_access_token" => null
      "campaign_service" => 1
      "lumen_timestamp" => null
      "is_lumen_key_expired" => 0
      "logo_image_url" => "https://s3.us-west-2.amazonaws.com/royoorders2.0-assets/Clientlogo/664c4518ba101.png"
    ]
    #original: array:41 [▶
      "id" => 1
      "name" => "trendsetter"
      "email" => "admin@trendsetter.com"
      "phone_number" => "07887898989"
      "password" => "$2y$10$WIFJni0hHBjqwzyjq2EbsOSUZKw4BQCJIDEuuetgSr3pDHKdnLb/G"
      "encpass" => null
      "country_id" => 1
      "timezone" => "Africa/Abidjan"
      "custom_domain" => "trendsetter.ae"
      "sub_domain" => "trendsetter"
      "is_deleted" => 0
      "is_blocked" => 0
      "database_path" => ""
      "database_name" => "trendsetter"
      "database_username" => "root"
      "database_password" => "adg78t82g8iio92"
      "logo" => "Clientlogo/664c4518ba101.png"
      "company_name" => "trendsetter"
      "company_address" => "CDCL Building, 28B, Sector 28, Chandigarh, India"
      "language_id" => null
      "status" => 1
      "code" => "37447b"
      "contact_email" => null
      "contact_address" => null
      "contact_phone_number" => null
      "created_at" => null
      "updated_at" => "2024-05-21 06:54:16"
      "database_host" => "localhost"
      "database_port" => "3306"
      "is_superadmin" => 1
      "whatsapp_url" => null
      "socket_url" => null
      "admin_chat" => 2
      "driver_chat" => 2
      "customer_chat" => 2
      "dark_logo" => "Clientlogo/664c4518c83d7.png"
      "is_lumen_enabled" => 0
      "lumen_access_token" => null
      "campaign_service" => 1
      "lumen_timestamp" => null
      "is_lumen_key_expired" => 0
    ]
    #changes: []
    #classCastCache: []
    #attributeCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
    #rememberTokenName: "remember_token"
    #excludedAttributes: []
    +auditEvent: null
    +auditCustomOld: null
    +auditCustomNew: null
    +isCustomEvent: false
    +preloadedResolverData: []
  }
  "userCode" => "37447b"
  "vendors" => array:5 [▶
    0 => 2
    1 => 3
    2 => 4
    3 => 5
    4 => 6
  ]
  "_previous" => array:1 [▶
    "url" => "https://trendsetter.ae/dubai/product/jw"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

language

currency

Change Theme

language

currency

Change Theme

JW Marriott

Dubai

$0.00

Product Details

Quantity :

Share It

Related products

Apidays LIVE Australia 2021 - Accelerating Digital

Jumeirah Beach

Tresind Dubai

Find Our App On Mobile

Quick Links

1 x Application (77.85%)	184ms
1 x Booting (22.15%)	52.34ms

language

currency

Change Theme

language

currency

Change Theme

JW Marriott

Dubai

$0.00

Product Details

Quantity :

Share It

Related products

Remove Cart

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