Supermarket

New Product Back

Nescafe 2In1 Instant Coffee Mix Sugar Free 11.7g x 25 Pieces

Right Buy Supermarket

In Beverages

د.إ 30.00

Johnson's Conditioner No More Tangles Kids Conditioner 300ml

Right Buy Supermarket

In Baby Products

د.إ 18.75

Johnson's Oil Aloe Vera Oil 500ml

Right Buy Supermarket

In Baby Products

د.إ 40.70

Lurpak Butter Blocks 6x50g

Right Buy Supermarket

In Dairy and Eggs

د.إ 15.95

New Product >

No Product Found

Messages Timeline Exceptions Views10 Route Queries74 Models128 Mails Gate Session Request

7.4.29406ms13MBGET category/{slug1}/{slug2?}

Booting (97.57ms)
Application (308ms)
1 x Application (75.96%)
308ms
1 x Booting (24.04%)
97.57ms

10 templates were rendered

frontend.cate-products (resources/views/frontend/cate-products.blade.php)6blade
Params
0
listData
1
category
2
navCategories
3
newProducts
4
variantSets
5
vendor_id

Params
0	`listData`
1	`category`
2	`navCategories`
3	`newProducts`
4	`variantSets`
5	`vendor_id`

frontend.included_files.categories_breadcrumb (resources/views/frontend/included_files/categories_breadcrumb.blade.php)24blade


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id

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

Params
0	`__env`
1	`app`
2	`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	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`

Params
0	`paginator`
1	`elements`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
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	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
demo

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`
39	`demo`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`
39	`dark_mode`
40	`body_class`

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


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
dark_mode
body_class
clientData
urlImg
languageList
currencyList
pages

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`
39	`dark_mode`
40	`body_class`
41	`clientData`
42	`urlImg`
43	`languageList`
44	`currencyList`
45	`pages`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`
39	`dark_mode`
40	`body_class`

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


__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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
listData
category
navCategories
newProducts
variantSets
vendor_id
__currentLoopData
key
loop
sets
opt
ok
newProds
new
multiply
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
dark_mode
body_class

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`yoco_public_key`
11	`checkout_public_key`
12	`client_preference_detail`
13	`client_payment_options`
14	`cashfree_test_mode`
15	`payphone_id`
16	`payPhoneToken`
17	`errors`
18	`listData`
19	`category`
20	`navCategories`
21	`newProducts`
22	`variantSets`
23	`vendor_id`
24	`__currentLoopData`
25	`key`
26	`loop`
27	`sets`
28	`opt`
29	`ok`
30	`newProds`
31	`new`
32	`multiply`
33	`title`
34	`meta_title`
35	`meta_keyword`
36	`meta_description`
37	`set_template`
38	`set_common_business_type`
39	`dark_mode`
40	`body_class`

uri: GET category/{slug1}/{slug2?}
middleware: web, languageSwitch, subdomain, domain
domain: {domain}
controller: App\Http\Controllers\Front\CategoryController@categoryVendorProducts
namespace: App\Http\Controllers
prefix
where
as: categoryVendorProducts
file: app/Http/Controllers/Front/CategoryController.php:349-444

74 statements were executed, 33 of which were duplicated, 41 unique88.31ms

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

5.21msmiddleware::domain:80royo_ored

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

940μsmiddleware::domain:90royo_ored

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

670μsmiddleware::domain:100royo_ored

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

3.14msmiddleware::domain:105royo_ored

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

1.05msmiddleware::domain:128royo_ored

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

950μsmiddleware::domain:141royo_ored

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

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

580μsmiddleware::domain:142royo_ored

Metadata
Bindings	0. 224
Backtrace	14. middleware::domain:142 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 `client_languages` order by `is_primary` desc limit 1

870μs/app/Http/Controllers/Front/FrontController.php:102royo_ored

Metadata
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:102 16. /app/Http/Controllers/Front/CategoryController.php:360 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 distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`id` > '1' and `categories`.`type_id` is not null and `categories`.`type_id` != 5 and `categories`.`id` > '1' and `categories`.`is_visible` = 1 and `categories`.`is_core` = 1 and `categories`.`status` != 2 and `cts`.`language_id` = 1 and (`cts`.`language_id` = 1 or `cts`.`language_id` = 1) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `id` order by `position` asc, `categories`.`parent_id` asc

1.64ms/app/Http/Controllers/Front/FrontController.php:145royo_ored

Metadata
Bindings	0. 1 1. 5 2. 1 3. 1 4. 1 5. 2 6. 1 7. 1 8. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:145 15. /app/Http/Controllers/Front/CategoryController.php:360 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

670μs/app/Http/Controllers/Front/CategoryController.php:361royo_ored

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

select `id`, `icon`, `image`, `slug`, `type_id`, `can_add_products`, `parent_id` from `categories` where `slug` = 'Supermarket' and `categories`.`deleted_at` is null limit 1

1.32ms/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Bindings	0. Supermarket
Backtrace	16. /app/Http/Controllers/Front/CategoryController.php:381 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `category_id`, `tag` from `category_tags` where `category_tags`.`category_id` in (4)

520μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `brand_categories`.`category_id`, `brand_categories`.`brand_id`, `brands`.`id`, `brands`.`image` from `brand_categories` inner join `brands` on `brands`.`id` = `brand_categories`.`brand_id` where `brand_categories`.`category_id` in (4)

960μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title` as `redirect_to` from `types` where `types`.`id` in (3)

660μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `slug`, `parent_id`, `icon`, `icon_two`, `image`, `type_id` from `categories` where `categories`.`parent_id` in (4) and `categories`.`deleted_at` is null

980μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `category_translations`.`name`, `category_translations`.`meta_title`, `category_translations`.`meta_description`, `category_translations`.`meta_keywords`, `category_translations`.`category_id` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `cl`.`is_active` = 1 and `category_translations`.`category_id` in (8, 9, 10, 34, 37) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc

1.15ms/app/Http/Controllers/Front/CategoryController.php:381royo_ored

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

select `category_translations`.`name`, `category_translations`.`meta_title`, `category_translations`.`meta_description`, `category_translations`.`meta_keywords`, `category_translations`.`category_id` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `cl`.`is_active` = 1 and `category_translations`.`category_id` in (4) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc

1.19ms/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Bindings	0. 1 1. 1
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

490μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

Metadata
Backtrace	21. /app/Http/Controllers/Front/CategoryController.php:381 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

810μs/app/Http/Controllers/Front/CategoryController.php:381royo_ored

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

select `id`, `name` from `vendors` where `slug` = 'right-buy-supermarket58' and `status` = 1 limit 1

1ms/app/Http/Controllers/Front/CategoryController.php:387royo_ored

Metadata
Bindings	0. right-buy-supermarket58 1. 1
Backtrace	16. /app/Http/Controllers/Front/CategoryController.php:387 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 `product_variant_sets`.`product_id`, `product_variant_sets`.`product_variant_id`, `product_variant_sets`.`variant_type_id`, `vr`.`type`, `vt`.`title` from `product_variant_sets` inner join `variants` as `vr` on `product_variant_sets`.`variant_type_id` = `vr`.`id` inner join `variant_translations` as `vt` on `vt`.`variant_id` = `vr`.`id` where `vt`.`language_id` = 1 and `vr`.`status` = 1 and `product_variant_sets`.`product_id` in (select `product_id` from `product_categories` where `category_id` = 4) group by `product_variant_sets`.`variant_type_id`

930μs/app/Http/Controllers/Front/CategoryController.php:409royo_ored

Metadata
Bindings	0. 1 1. 1 2. 4
Backtrace	14. /app/Http/Controllers/Front/CategoryController.php:409 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 `variant_options`.*, `vt`.`title` from `variant_options` inner join `product_variant_sets` as `pvs` on `pvs`.`variant_option_id` = `variant_options`.`id` inner join `variant_option_translations` as `vt` on `vt`.`variant_option_id` = `variant_options`.`id` where `variant_options`.`variant_id` in (6) and `vt`.`language_id` = 1 group by `pvs`.`variant_option_id` order by `pvs`.`product_variant_id` asc

2.49ms/app/Http/Controllers/Front/CategoryController.php:409royo_ored

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

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

520μs/app/Http/Controllers/Front/FrontController.php:262royo_ored

Metadata
Bindings	0. 165
Backtrace	15. /app/Http/Controllers/Front/FrontController.php:262 16. /app/Http/Controllers/Front/CategoryController.php:411 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `sku`, `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` from `products` where `is_new` = 1 and `vendor_id` in (15) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6

1.19ms/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Bindings	0. 1 1. 15 2. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:288 15. /app/Http/Controllers/Front/CategoryController.php:411 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 (139, 141, 143, 147)

920μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/CategoryController.php:411 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 (10, 34, 37) and `categories`.`deleted_at` is null

760μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Backtrace	24. /app/Http/Controllers/Front/FrontController.php:288 25. /app/Http/Controllers/Front/CategoryController.php:411 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 (10, 34, 37) and `category_translations`.`language_id` = 1 order by `cl`.`is_primary` desc

1.1ms/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Bindings	0. 1 1. 1
Backtrace	29. /app/Http/Controllers/Front/FrontController.php:288 30. /app/Http/Controllers/Front/CategoryController.php:411 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 `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `hourly_rate_per_worker` from `vendors` where `vendors`.`id` in (15)

710μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/CategoryController.php:411 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 `product_id`, `media_id`, `is_default` from `product_images` where `product_images`.`product_id` in (139, 141, 143, 147) group by `product_id`

640μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/CategoryController.php:411 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 (153, 155, 157, 161)

470μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Backtrace	24. /app/Http/Controllers/Front/FrontController.php:288 25. /app/Http/Controllers/Front/CategoryController.php:411 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 (139, 141, 143, 147) and `language_id` = 1

720μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Bindings	0. 1
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/CategoryController.php:411 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 (139, 141, 143, 147) group by `product_id` order by `price` asc

680μs/app/Http/Controllers/Front/FrontController.php:288royo_ored

Metadata
Bindings	0. 1
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/CategoryController.php:411 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 count(*) as aggregate from `products` where `is_live` = 1 and `category_id` = 4 and `vendor_id` = 15 and `products`.`deleted_at` is null

990μs/app/Http/Controllers/Front/CategoryController.php:430royo_ored

Metadata
Bindings	0. 1 1. 4 2. 15
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:430 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

890μsview::caf1c69dc48b23dd51c15835bc0f4f88238301ec:2royo_ored

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

select `id`, `logo` from `clients` where `id` > 0 limit 1

3.31msview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:4royo_ored

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

2msview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:9royo_ored

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

1.51msview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:9royo_ored

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

3.06msview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:13royo_ored

Metadata
Backtrace	14. view::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:13 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `name`, `iso_code`, `symbol` from `currencies` where `currencies`.`id` in (165)

1.26msview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:13royo_ored

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

select * from `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

950μsview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:24royo_ored

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

860μsview::f78e5a556f64ecd3b7d239f0458f1643a5dab3bb:24royo_ored

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

1.67msview::3a9de0c191a5b99547cc50de3a43974e9837eec5:2royo_ored

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

680μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:4royo_ored

Metadata
Bindings	0. 1
Backtrace	14. view::3a9de0c191a5b99547cc50de3a43974e9837eec5: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)

670μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:4royo_ored

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

480μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:5royo_ored

Metadata
Backtrace	14. view::3a9de0c191a5b99547cc50de3a43974e9837eec5: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 (165)

730μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:5royo_ored

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

750μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:6royo_ored

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

730μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:6royo_ored

Metadata
Bindings	0. 1
Backtrace	19. view::3a9de0c191a5b99547cc50de3a43974e9837eec5:6 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `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

750μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:68royo_ored

Metadata
Bindings	0. 1 1. 1
Backtrace	21. view::3a9de0c191a5b99547cc50de3a43974e9837eec5:68 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

890μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:68royo_ored

Metadata
Bindings	0. 2 1. 1
Backtrace	21. view::3a9de0c191a5b99547cc50de3a43974e9837eec5:68 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

640μsview::3a9de0c191a5b99547cc50de3a43974e9837eec5:68royo_ored

Metadata
Bindings	0. 3 1. 1
Backtrace	21. view::3a9de0c191a5b99547cc50de3a43974e9837eec5:68 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 '%Delivery%' limit 1

450μs/app/helpers.php:132royo_ored

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

470μs/app/helpers.php:132royo_ored

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

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

410μs/app/helpers.php:132royo_ored

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

390μs/app/helpers.php:132royo_ored

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

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

790μs/app/helpers.php:132royo_ored

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

430μs/app/helpers.php:132royo_ored

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

390μs/app/helpers.php:132royo_ored

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

680μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:2royo_ored

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

990μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:4royo_ored

Metadata
Bindings	0. 1 1. 1
Backtrace	14. view::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff: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) and `language_id` = 1

740μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:4royo_ored

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

750μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:9royo_ored

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

390μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:9royo_ored

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

500μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:10royo_ored

Metadata
Backtrace	14. view::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff: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 (165)

380μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:10royo_ored

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

720μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:83royo_ored

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

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

1.48msview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:83royo_ored

Metadata
Bindings	0. 2 1. 1
Backtrace	21. view::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:83 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

780μsview::b821dbdbe262e8f5d40e0faf8c48e1d07c8a10ff:83royo_ored

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

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

1.27msview::35719249bf0fa434db61fcaf8128aa0db77b6068:20royo_ored

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

590μs/app/helpers.php:160royo_ored

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

select * from `client_preferences` limit 1

880μs/app/helpers.php:147royo_ored

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

select * from `client_preferences` limit 1

13.27ms/app/helpers.php:147royo_ored

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

select * from `clients` limit 1

2.11ms/app/helpers.php:154royo_ored

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

select * from `clients` limit 1

700μs/app/helpers.php:154royo_ored

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

App\Models\Nomenclature: 3
App\Models\Language: 4
App\Models\ClientCurrency: 6
App\Models\Currency: 4
App\Models\Client: 6
App\Models\Country: 1
App\Models\Category: 30
App\Models\Type: 1
App\Models\Category_translation: 9
App\Models\Vendor: 2
App\Models\ClientLanguage: 5
App\Models\ProductVariantSet: 1
App\Models\Product: 4
App\Models\ProductCategory: 4
App\Models\ProductImage: 4
App\Models\VendorMedia: 4
App\Models\ProductTranslation: 4
App\Models\ProductVariant: 4
App\Models\WebStylingOption: 1
App\Models\Page: 9
App\Models\PageTranslation: 15
App\Models\VariantOption: 3
App\Models\ClientPreference: 4

_token: p8i8AobSsQrnGV7qSEE7ERKacdBoDdmqes2uwFuO
client_config: {#3768 +"name": "Ored" +"email": "admin@ored.com" +"phone_number": "501692300" +"is_deleted"...
login_user_type: client
customerLanguage: 1
applocale: en
customerCurrency: 165
currencySymbol: د.إ
currencyMultiplier: 1.00000000
iso_code: AED
default_country_code: AE
default_country_phonecode: 971
preferences: App\Models\ClientPreference {#3366 #fillable: array:63 [ 0 => "client_code" 1 => "theme_ad...
_previous: array:1 [ "url" => "https://ored.co/category/Supermarket/right-buy-supermarket58" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/category/Supermarket/right-buy-supermarket58

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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "ored.co"
  ]
]

request_server

  0 of 0   
array:41 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_HOST" => "ored.co"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "ored.co"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.6.48"
  "REMOTE_PORT" => "29644"
  "REMOTE_ADDR" => "3.148.115.16"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/html/order/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/category/Supermarket/right-buy-supermarket58"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/html/order/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743977016.182
  "REQUEST_TIME" => 1743977016
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 06 Apr 2025 22:03:36 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImRKNHRraHd1b3pINFdua0lkNXM4NWc9PSIsInZhbHVlIjoici9NaThmQlVCZE0rc2EzZDFSaVhyWG5mV2NObmtaR1lQQS9tRkhNZFY1ZFp6U2w5VFVTNVZxOENoc3FXa3VodS80YTNiVzMzL3hzSURaQWNOckRpWER4KzhLVjhQcWZKZXBwSHFRV0tDUG9sQTBOaUp4a2xLSTZteGJzdWxSTWUiLCJtYWMiOiIwZTg3MzgxNWFiYjRmZjRjNGEzMDAwMTQwODY5ZjkyNWM4MmNhYjQzOTA5Y2JjZGNjOGJlYjIwNWEwYTM5OTJjIiwidGFnIjoiIn0%3D; expires=Mon, 06-Apr-2026 22:03:36 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImRKNHRraHd1b3pINFdua0lkNXM4NWc9PSIsInZhbHVlIjoici9NaThmQlVCZE0rc2EzZDFSaVhyWG5mV2NObmtaR1lQQS9tRkhNZFY1ZFp6U2w5VFVTNVZxOENoc3FXa3VodS80YTNiV ▶"
    1 => "royoorders_session=eyJpdiI6Imw5RkVvOEhJUmV0SDRTK2dlMzQ3VFE9PSIsInZhbHVlIjoibGRYSWcwajhmWTdmT0JQUHhmNFhhRldrakJ3TlorNlRPZFVKQXl3WDdndVZoR3VtNnpXb2I1bmRmYm8wNnpJbnNLTUtCdFV2bnc3cEIrVEcxU3pnUkFZMUlWdllRblVOMmpkMG9ydW1kNkpqMFR4anNta0l1M1ZMdTFGejF1MlkiLCJtYWMiOiI3MjhjMmYxZGQ0MTZkMTc0OTAxZWIwMDhlODFiMTNjMWE0OWNiNDhhOWNhODQ4ODI2M2M5ZDI0NWMwODRjZGY5IiwidGFnIjoiIn0%3D; expires=Mon, 06-Apr-2026 22:03:36 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀royoorders_session=eyJpdiI6Imw5RkVvOEhJUmV0SDRTK2dlMzQ3VFE9PSIsInZhbHVlIjoibGRYSWcwajhmWTdmT0JQUHhmNFhhRldrakJ3TlorNlRPZFVKQXl3WDdndVZoR3VtNnpXb2I1bmRmYm8wNnpJb ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImRKNHRraHd1b3pINFdua0lkNXM4NWc9PSIsInZhbHVlIjoici9NaThmQlVCZE0rc2EzZDFSaVhyWG5mV2NObmtaR1lQQS9tRkhNZFY1ZFp6U2w5VFVTNVZxOENoc3FXa3VodS80YTNiVzMzL3hzSURaQWNOckRpWER4KzhLVjhQcWZKZXBwSHFRV0tDUG9sQTBOaUp4a2xLSTZteGJzdWxSTWUiLCJtYWMiOiIwZTg3MzgxNWFiYjRmZjRjNGEzMDAwMTQwODY5ZjkyNWM4MmNhYjQzOTA5Y2JjZGNjOGJlYjIwNWEwYTM5OTJjIiwidGFnIjoiIn0%3D; expires=Mon, 06-Apr-2026 22:03:36 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImRKNHRraHd1b3pINFdua0lkNXM4NWc9PSIsInZhbHVlIjoici9NaThmQlVCZE0rc2EzZDFSaVhyWG5mV2NObmtaR1lQQS9tRkhNZFY1ZFp6U2w5VFVTNVZxOENoc3FXa3VodS80YTNiV ▶"
    1 => "royoorders_session=eyJpdiI6Imw5RkVvOEhJUmV0SDRTK2dlMzQ3VFE9PSIsInZhbHVlIjoibGRYSWcwajhmWTdmT0JQUHhmNFhhRldrakJ3TlorNlRPZFVKQXl3WDdndVZoR3VtNnpXb2I1bmRmYm8wNnpJbnNLTUtCdFV2bnc3cEIrVEcxU3pnUkFZMUlWdllRblVOMmpkMG9ydW1kNkpqMFR4anNta0l1M1ZMdTFGejF1MlkiLCJtYWMiOiI3MjhjMmYxZGQ0MTZkMTc0OTAxZWIwMDhlODFiMTNjMWE0OWNiNDhhOWNhODQ4ODI2M2M5ZDI0NWMwODRjZGY5IiwidGFnIjoiIn0%3D; expires=Mon, 06-Apr-2026 22:03:36 GMT; path=/; httponly ◀royoorders_session=eyJpdiI6Imw5RkVvOEhJUmV0SDRTK2dlMzQ3VFE9PSIsInZhbHVlIjoibGRYSWcwajhmWTdmT0JQUHhmNFhhRldrakJ3TlorNlRPZFVKQXl3WDdndVZoR3VtNnpXb2I1bmRmYm8wNnpJb ▶"
  ]
]

session_attributes

  0 of 0   
array:15 [▼
  "_token" => "p8i8AobSsQrnGV7qSEE7ERKacdBoDdmqes2uwFuO"
  "client_config" => {#3768 ▶
    +"name": "Ored"
    +"email": "admin@ored.com"
    +"phone_number": "501692300"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#3769 ▶
      +"proxy_url": "https://images.ored.co/insecure/fill/"
      +"image_path": "/ce/0/plain/https://ored-assets.s3.me-south-1.amazonaws.com/default/default_logo.png@webp"
      +"image_fit": "https://images.ored.co/insecure/fit/"
      +"original": "https://ored-assets.s3.me-south-1.amazonaws.com/default/default_logo.png"
      +"logo_db_value": "default/default_logo.png"
    }
    +"company_name": "Ored"
    +"company_address": "Chandigarh"
    +"status": 1
    +"code": "fb0df5"
    +"database_name": "ored"
    +"database_host": "ored-db-cluster.cjzxojwknufw.me-south-1.rds.amazonaws.com"
    +"database_port": "3306"
    +"database_username": "oredadmin"
    +"database_password": "pVc2StHd8xRJU3KX"
    +"custom_domain": "www.ored.co"
    +"sub_domain": "ored"
  }
  "login_user_type" => "client"
  "customerLanguage" => 1
  "applocale" => "en"
  "customerCurrency" => 165
  "currencySymbol" => "د.إ"
  "currencyMultiplier" => "1.00000000"
  "iso_code" => "AED"
  "default_country_code" => "AE"
  "default_country_phonecode" => 971
  "preferences" => App\Models\ClientPreference {#3366 ▶
    #fillable: array:63 [▶
      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"
    ]
    #connection: "royo_ored"
    #table: "client_preferences"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:49 [▶
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 0
      "fb_client_id" => "admin@ored.com"
      "fb_client_secret" => "admin@520"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 0
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Chandigarh, India"
      "Default_latitude" => "30.538994400000"
      "Default_longitude" => "75.955032900000"
      "map_provider" => null
      "map_key" => "AIzaSyBelgPz9p9_Wsej13kKZH-ApSnFjOxib_4"
      "sms_provider" => 1
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => null
      "is_hyperlocal" => 0
      "need_delivery_service" => 1
      "need_dispacher_ride" => 1
      "delivery_service_key" => "Obm8qdJU4aWpfgx2BwR4sT7GMM7UAB"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => "AIzaSyDvvgzrINlQu6cFrKf_UTrYFgOFqvTK9h4"
      "fcm_auth_domain" => "ored-2cc63.firebaseapp.com"
      "fcm_project_id" => "ored-2cc63"
      "fcm_storage_bucket" => "ored-2cc63.appspot.com"
      "fcm_messaging_sender_id" => "727222041107"
      "fcm_app_id" => "1:727222041107:web:c03af81d36e4979c425de6"
      "fcm_measurement_id" => "G-39YK60YKNJ"
      "distance_unit_for_time" => null
      "distance_to_time_multiplier" => 0
      "delay_order" => 0
      "product_order_form" => 1
      "digit_after_decimal" => 2
    ]
    #original: array:49 [▶
      "theme_admin" => "light"
      "distance_unit" => "metric"
      "currency_id" => null
      "date_format" => "YYYY-MM-DD"
      "time_format" => "24"
      "fb_login" => 0
      "fb_client_id" => "admin@ored.com"
      "fb_client_secret" => "admin@520"
      "fb_client_url" => null
      "twitter_login" => 0
      "twitter_client_id" => null
      "twitter_client_secret" => null
      "twitter_client_url" => null
      "google_login" => 0
      "google_client_id" => null
      "google_client_secret" => null
      "google_client_url" => null
      "apple_login" => 0
      "apple_client_id" => null
      "apple_client_secret" => null
      "apple_client_url" => null
      "Default_location_name" => "Chandigarh, India"
      "Default_latitude" => "30.538994400000"
      "Default_longitude" => "75.955032900000"
      "map_provider" => null
      "map_key" => "AIzaSyBelgPz9p9_Wsej13kKZH-ApSnFjOxib_4"
      "sms_provider" => 1
      "verify_email" => 0
      "verify_phone" => 0
      "web_template_id" => null
      "is_hyperlocal" => 0
      "need_delivery_service" => 1
      "need_dispacher_ride" => 1
      "delivery_service_key" => "Obm8qdJU4aWpfgx2BwR4sT7GMM7UAB"
      "dispatcher_key" => null
      "primary_color" => "#32B5FC"
      "secondary_color" => "#41A2E6"
      "fcm_api_key" => "AIzaSyDvvgzrINlQu6cFrKf_UTrYFgOFqvTK9h4"
      "fcm_auth_domain" => "ored-2cc63.firebaseapp.com"
      "fcm_project_id" => "ored-2cc63"
      "fcm_storage_bucket" => "ored-2cc63.appspot.com"
      "fcm_messaging_sender_id" => "727222041107"
      "fcm_app_id" => "1:727222041107:web:c03af81d36e4979c425de6"
      "fcm_measurement_id" => "G-39YK60YKNJ"
      "distance_unit_for_time" => null
      "distance_to_time_multiplier" => 0
      "delay_order" => 0
      "product_order_form" => 1
      "digit_after_decimal" => 2
    ]
    #changes: []
    #casts: []
    #classCastCache: []
    #attributeCastCache: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "_previous" => array:1 [▶
    "url" => "https://ored.co/category/Supermarket/right-buy-supermarket58"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

language

currency

Change Theme

language

currency

Change Theme

Supermarket

Size

New Product Back

Nescafe 2In1 Instant Coffee Mix Sugar Free 11.7g x 25 Pieces

Johnson's Conditioner No More Tangles Kids Conditioner 300ml

Johnson's Oil Aloe Vera Oil 500ml

Lurpak Butter Blocks 6x50g

No Product Found

Find Our App On Mobile

Quick Links

Contact Us

Connect

Payment Methods

Keep In Touch

1 x Application (75.96%)	308ms
1 x Booting (24.04%)	97.57ms

language

currency

Change Theme

language

currency

Change Theme

Supermarket

Size

New Product Back

Nescafe 2In1 Instant Coffee Mix Sugar Free 11.7g x 25 Pieces

Johnson's Conditioner No More Tangles Kids Conditioner 300ml

Johnson's Oil Aloe Vera Oil 500ml

Lurpak Butter Blocks 6x50g

No Product Found

Remove Cart

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