Johnson's Baby Kids Conditioner Shiny Drops 500ml

SpeedWay Super Market

د.إ27.50

Size
ml

Quantity:

Add To Cart

Product Details

Share It

Ratings & Reviews

No Result Found

Messages Timeline Exceptions Views9 Route Queries111 Models161 Mails Gate Session Request

7.4.29371ms14MBGET {vendor?}/product/{id?}

Booting (80.26ms)
Application (291ms)
1 x Application (78.39%)
291ms
1 x Booting (21.6%)
80.26ms

9 templates were rendered

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


shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available

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

frontend.included_files.products_breadcrumb (resources/views/frontend/included_files/products_breadcrumb.blade.php)29blade


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`

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


__env
app
last_mile_common_set
favicon
client_head
mod_count
social_media_details
stripe_publishable_key
stripe_fpx_publishable_key
stripe_oxxo_publishable_key
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
title
meta_title
meta_keyword
meta_description

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
title
meta_title
meta_keyword
meta_description
set_template
set_common_business_type
demo

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`
51	`demo`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`
51	`dark_mode`
52	`body_class`

layouts.store.topbar-template-one (resources/views/layouts/store/topbar-template-one.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
yoco_public_key
checkout_public_key
client_preference_detail
client_payment_options
cashfree_test_mode
payphone_id
payPhoneToken
errors
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`
51	`dark_mode`
52	`body_class`
53	`clientData`
54	`urlImg`
55	`languageList`
56	`currencyList`
57	`pages`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`
51	`dark_mode`
52	`body_class`

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


__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
shareComponent
sets
vendor_info
product
navCategories
newProducts
rating_details
is_inwishlist_btn
category
product_in_cart
is_available
__currentLoopData
image
k
loop
img
selectedVariant
variant
key
optn
var_id
opt_id
checked
product_quantity_in_cart
checkSlot
__empty_1
user
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	`shareComponent`
19	`sets`
20	`vendor_info`
21	`product`
22	`navCategories`
23	`newProducts`
24	`rating_details`
25	`is_inwishlist_btn`
26	`category`
27	`product_in_cart`
28	`is_available`
29	`__currentLoopData`
30	`image`
31	`k`
32	`loop`
33	`img`
34	`selectedVariant`
35	`variant`
36	`key`
37	`optn`
38	`var_id`
39	`opt_id`
40	`checked`
41	`product_quantity_in_cart`
42	`checkSlot`
43	`__empty_1`
44	`user`
45	`title`
46	`meta_title`
47	`meta_keyword`
48	`meta_description`
49	`set_template`
50	`set_common_business_type`
51	`dark_mode`
52	`body_class`

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

111 statements were executed, 47 of which were duplicated, 64 unique108ms

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

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

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

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

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

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

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

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

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

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

select 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.11ms/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/ProductController.php:41 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `id`, `vendor_id` from `products` where `url_slug` = 'Johnson\'s Baby Kids Conditioner Shiny Drops 500ml' and exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'speedway-super-market45') and `products`.`deleted_at` is null limit 1

910μs/app/Http/Controllers/Front/ProductController.php:45royo_ored

Metadata
Bindings	0. Johnson's Baby Kids Conditioner Shiny Drops 500ml 1. speedway-super-market45
Backtrace	16. /app/Http/Controllers/Front/ProductController.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `cart_products` where (`product_id` = 126) and exists (select * from `carts` where `cart_products`.`cart_id` = `carts`.`id` and (`unique_identifier` = 'BeBT5gyIU3sQJpOa3WehzUrq1sElM1B9w46l06bS')) limit 1

900μs/app/Http/Controllers/Front/ProductController.php:57royo_ored

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

select `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` from `products` where exists (select * from `vendors` where `products`.`vendor_id` = `vendors`.`id` and `slug` = 'speedway-super-market45') and `url_slug` = 'Johnson\'s Baby Kids Conditioner Shiny Drops 500ml' and `is_live` = 1 and `products`.`deleted_at` is null limit 1

890μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

Metadata
Bindings	0. speedway-super-market45 1. Johnson's Baby Kids Conditioner Shiny Drops 500ml 2. 1
Backtrace	16. /app/Http/Controllers/Front/ProductController.php:132 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `sku`, `product_id`, `title`, `quantity`, `price`, `position`, `compare_at_price`, `barcode`, `cost_price`, `currency_id`, `tax_category_id`, `container_charges` from `product_variants` where `status` = 1 and `product_variants`.`product_id` in (126) group by `product_id`

1.25ms/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_variant_id`, `variant_option_id` from `product_variant_sets` inner join `variant_options` as `opt` on `opt`.`id` = `product_variant_sets`.`variant_option_id` inner join `variants` as `vari` on `vari`.`id` = `opt`.`variant_id` where `product_variant_sets`.`product_variant_id` in (130)

780μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

920μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_id`, `related_product_id` from `product_related` where `product_related`.`product_id` in (126)

620μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_id`, `upsell_product_id` from `product_up_sells` where `product_up_sells`.`product_id` in (126)

850μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_id`, `cross_product_id` from `product_cross_sells` where `product_cross_sells`.`product_id` in (126)

530μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `id`, `slug`, `name`, `desc`, `logo`, `show_slot`, `status`, `closed_store_order_scheduled`, `need_container_charges`, `fixed_fee`, `fixed_fee_amount`, `price_bifurcation`, `fixed_fee_tax_id`, `hourly_rate_per_worker` from `vendors` where `vendors`.`id` in (1)

450μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

590μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `id`, `media_type`, `path` from `vendor_media` where `vendor_media`.`id` in (138)

1.01ms/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

690μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_addons`.`product_id`, `set`.`min_select`, `set`.`max_select`, `ast`.`title`, `product_addons`.`addon_id` from `product_addons` inner join `addon_sets` as `set` on `set`.`id` = `product_addons`.`addon_id` inner join `addon_set_translations` as `ast` on `ast`.`addon_id` = `set`.`id` where `product_addons`.`product_id` in (126) and `set`.`status` = 1 and `ast`.`language_id` = 1

700μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

select `product_variant_sets`.`product_id`, `product_variant_sets`.`product_variant_id`, `product_variant_sets`.`variant_type_id`, `vr`.`type`, `vt`.`title` from `product_variant_sets` inner join `variants` as `vr` on `product_variant_sets`.`variant_type_id` = `vr`.`id` inner join `variant_translations` as `vt` on `vt`.`variant_id` = `vr`.`id` where `product_variant_sets`.`product_id` in (126) and `vt`.`language_id` = 1 and `product_variant_sets`.`product_id` = 126 and `vr`.`status` = 1 group by `variant_type_id` order by `product_variant_id` asc

1.24ms/app/Http/Controllers/Front/ProductController.php:132royo_ored

Metadata
Bindings	0. 1 1. 126 2. 1
Backtrace	21. /app/Http/Controllers/Front/ProductController.php:132 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 `pvs`.`hexacode`, `vt`.`title`, `product_variant_sets`.`product_id`, `product_variant_sets`.`variant_type_id`, `product_variant_sets`.`variant_option_id`, `product_variant_sets`.`product_variant_id` from `product_variant_sets` inner join `variant_options` as `pvs` on `product_variant_sets`.`variant_option_id` = `pvs`.`id` inner join `variant_option_translations` as `vt` on `vt`.`variant_option_id` = `pvs`.`id` where `product_variant_sets`.`variant_type_id` in (4) and `vt`.`language_id` = 1 and `product_variant_sets`.`product_id` = 126 group by `product_variant_sets`.`variant_option_id`

730μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

8.58ms/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

3.74ms/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

600μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

380μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

460μs/app/Http/Controllers/Front/ProductController.php:132royo_ored

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

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

640μs/app/Http/Controllers/Front/ProductController.php:134royo_ored

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

select `id`, `sku`, `averageRating`, `url_slug`, `is_new`, `is_featured`, `vendor_id`, `inquiry_only`, `minimum_order_count`, `batch_count` from `products` where 0 = 1 and `category_id` is not null and `products`.`deleted_at` is null

480μs/app/Http/Controllers/Front/FrontController.php:341royo_ored

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:341 15. /app/Http/Controllers/Front/ProductController.php:141 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

840μ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/ProductController.php:148 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 (1) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6

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

Metadata
Bindings	0. 1 1. 1 2. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:288 15. /app/Http/Controllers/Front/ProductController.php:148 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 (116, 118, 119, 123, 124, 127)

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

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

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

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

960μs/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/ProductController.php:148 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 (1)

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

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/ProductController.php:148 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 (116, 118, 119, 123, 124, 127) group by `product_id`

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

Metadata
Backtrace	19. /app/Http/Controllers/Front/FrontController.php:288 20. /app/Http/Controllers/Front/ProductController.php:148 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 (128, 130, 131, 135, 136, 139)

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

Metadata
Backtrace	24. /app/Http/Controllers/Front/FrontController.php:288 25. /app/Http/Controllers/Front/ProductController.php:148 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 (116, 118, 119, 123, 124, 127) and `language_id` = 1

710μ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/ProductController.php:148 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 (116, 118, 119, 123, 124, 127) group by `product_id` order by `price` asc

850μ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/ProductController.php:148 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 *, `created_at` as `time_zone_created_at` from `order_product_ratings` where (`product_id` = 126)

740μs/app/Http/Controllers/Front/ProductController.php:156royo_ored

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

select * from `categories` where `id` = 34 and `categories`.`deleted_at` is null limit 1

1.3ms/app/Http/Controllers/Front/ProductController.php:159royo_ored

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

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

490μs/app/Http/Controllers/Front/ProductController.php:165royo_ored

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

790μs/app/Http/Controllers/Front/ProductController.php:227royo_ored

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

470μs/app/Models/Vendor.php:25royo_ored

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

560μs/app/Models/VendorSlot.php:13royo_ored

Metadata
Backtrace	18. /app/Models/VendorSlot.php:13 26. /app/Models/Vendor.php:28 34. /app/Http/Controllers/Front/ProductController.php:227 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` = 2) and `start_time` < '07:45:59' and `end_time` > '07:45:59' and `vendor_slots`.`vendor_id` in (1)

1.07ms/app/Http/Controllers/Front/ProductController.php:227royo_ored

Metadata
Bindings	0. 2 1. 07:45:59 2. 07:45:59
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:227 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

510μs/app/Models/Vendor.php:51royo_ored

Metadata
Backtrace	18. /app/Models/Vendor.php:51 26. /app/Http/Controllers/Front/ProductController.php:227 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-04-07' and `start_time` < '07:45:59' and `end_time` > '07:45:59' and `vendor_slot_dates`.`vendor_id` in (1)

590μs/app/Http/Controllers/Front/ProductController.php:227royo_ored

Metadata
Bindings	0. 2025-04-07 1. 07:45:59 2. 07:45:59
Backtrace	20. /app/Http/Controllers/Front/ProductController.php:227 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

570μs/app/Http/Controllers/Front/ProductController.php:268royo_ored

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

select `category_translations`.*, `languages`.`id` as `langId`, `languages`.`name` as `langName`, `cl`.`is_primary` from `category_translations` inner join `client_languages` as `cl` on `cl`.`language_id` = `category_translations`.`language_id` inner join `languages` on `category_translations`.`language_id` = `languages`.`id` where `category_translations`.`category_id` = 34 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc

850μsview::80dfbc4acb19f18db635e361345077f252d0cfbf:4royo_ored

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

select `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` = 4 and `category_translations`.`category_id` is not null and `cl`.`is_active` = 1 order by `cl`.`is_primary` desc

740μsview::80dfbc4acb19f18db635e361345077f252d0cfbf:9royo_ored

Metadata
Bindings	0. 4 1. 1
Backtrace	19. view::80dfbc4acb19f18db635e361345077f252d0cfbf: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 `slot_minutes` from `vendors` where `id` = 1 limit 1

600μs/app/helpers.php:375royo_ored

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

select `timezone` from `clients` limit 1

540μs/app/helpers.php:379royo_ored

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

select * from `client_preferences` limit 1

990μs/app/helpers.php:380royo_ored

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

select * from `vendor_slots` where `vendor_id` = 1 and exists (select * from `slot_days` where `vendor_slots`.`id` = `slot_days`.`slot_id` and `day` = 2 and `delivery` = '1')

750μs/app/helpers.php:398royo_ored

Metadata
Bindings	0. 1 1. 2 2. 1
Backtrace	14. /app/helpers.php:398 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 `cart_products` where `vendor_id` = 1

1.63ms/app/helpers.php:401royo_ored

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

select `id`, `title`, `sku`, `url_slug`, `is_live`, `weight`, `weight_unit`, `averageRating`, `brand_id`, `tax_category_id`, `Requires_last_mile`, `pharmacy_check`, `tags`, `mode_of_service`, `delay_order_hrs`, `delay_order_min`, `delay_order_hrs_for_dine_in`, `delay_order_min_for_dine_in`, `delay_order_hrs_for_takeway`, `delay_order_min_for_takeway`, `pickup_delay_order_hrs`, `pickup_delay_order_min`, `dropoff_delay_order_hrs`, `dropoff_delay_order_min`, `id` as `delay_hrs_min`, `id` as `pickup_delay_hrs_min`, `id` as `dropoff_delay_hrs_min`, `id` as `delay_order_time`, `sell_when_out_of_stock`, `minimum_order_count`, `batch_count`, `has_inventory`, `category_id`, `service_charges_tax`, `delivery_charges_tax`, `container_charges_tax`, `fixed_fee_tax`, `service_charges_tax_id`, `delivery_charges_tax_id`, `container_charges_tax_id`, `fixed_fee_tax_id` from `products` where `products`.`id` = 117 and `products`.`deleted_at` is null limit 1

830μs/app/helpers.php:404royo_ored

Metadata
Bindings	0. 117
Backtrace	21. /app/helpers.php:404 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 28. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `title`, `sku`, `url_slug`, `is_live`, `weight`, `weight_unit`, `averageRating`, `brand_id`, `tax_category_id`, `Requires_last_mile`, `pharmacy_check`, `tags`, `mode_of_service`, `delay_order_hrs`, `delay_order_min`, `delay_order_hrs_for_dine_in`, `delay_order_min_for_dine_in`, `delay_order_hrs_for_takeway`, `delay_order_min_for_takeway`, `pickup_delay_order_hrs`, `pickup_delay_order_min`, `dropoff_delay_order_hrs`, `dropoff_delay_order_min`, `id` as `delay_hrs_min`, `id` as `pickup_delay_hrs_min`, `id` as `dropoff_delay_hrs_min`, `id` as `delay_order_time`, `sell_when_out_of_stock`, `minimum_order_count`, `batch_count`, `has_inventory`, `category_id`, `service_charges_tax`, `delivery_charges_tax`, `container_charges_tax`, `fixed_fee_tax`, `service_charges_tax_id`, `delivery_charges_tax_id`, `container_charges_tax_id`, `fixed_fee_tax_id` from `products` where `products`.`id` = 116 and `products`.`deleted_at` is null limit 1

680μs/app/helpers.php:404royo_ored

Metadata
Bindings	0. 116
Backtrace	21. /app/helpers.php:404 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 28. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `slot_days` where `slot_days`.`slot_id` = 1 and `slot_days`.`slot_id` is not null limit 1

760μs/app/helpers.php:413royo_ored

Metadata
Bindings	0. 1
Backtrace	21. /app/helpers.php:413 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 28. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `timezone` from `clients` order by `id` desc limit 1

670μs/app/helpers.php:334royo_ored

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

select `date_format`, `time_format` from `client_preferences` where `id` > 0 limit 1

740μs/app/helpers.php:202royo_ored

Metadata
Bindings	0. 0
Backtrace	15. /app/helpers.php:202 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 `slot_days` where `slot_days`.`slot_id` = 5 and `slot_days`.`slot_id` is not null limit 1

690μs/app/helpers.php:413royo_ored

Metadata
Bindings	0. 5
Backtrace	21. /app/helpers.php:413 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 28. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `timezone` from `clients` order by `id` desc limit 1

460μs/app/helpers.php:334royo_ored

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

select `date_format`, `time_format` from `client_preferences` where `id` > 0 limit 1

460μs/app/helpers.php:202royo_ored

Metadata
Bindings	0. 0
Backtrace	15. /app/helpers.php:202 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 `slot_days` where `slot_days`.`slot_id` = 6 and `slot_days`.`slot_id` is not null limit 1

440μs/app/helpers.php:413royo_ored

Metadata
Bindings	0. 6
Backtrace	21. /app/helpers.php:413 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 28. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `id`, `timezone` from `clients` order by `id` desc limit 1

370μs/app/helpers.php:334royo_ored

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

select `date_format`, `time_format` from `client_preferences` where `id` > 0 limit 1

560μs/app/helpers.php:202royo_ored

Metadata
Bindings	0. 0
Backtrace	15. /app/helpers.php:202 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 `web_styling_options` where `web_styling_id` = 1 and `is_selected` = 1 limit 1

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

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

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

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

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

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

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

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

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

500μ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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

500μ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)

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

430μ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)

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

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

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

540μ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.39msview::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

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

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

900μ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 `clients` limit 1

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

640μ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: 13
App\Models\Country: 1
App\Models\Category: 26
App\Models\Product: 10
App\Models\ProductVariant: 7
App\Models\Vendor: 4
App\Models\ProductImage: 7
App\Models\ClientLanguage: 5
App\Models\VendorMedia: 7
App\Models\ProductVariantSet: 3
App\Models\ProductCategory: 7
App\Models\Category_translation: 4
App\Models\VendorSlot: 4
App\Models\WebStylingOption: 2
App\Models\CartProduct: 2
App\Models\SlotDay: 3
App\Models\Page: 9
App\Models\PageTranslation: 15
App\Models\ProductTranslation: 7
App\Models\ClientPreference: 8

_token: BeBT5gyIU3sQJpOa3WehzUrq1sElM1B9w46l06bS
client_config: {#3762 +"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/speedway-super-market45/product/Johnson%27s%20Baby%20Kids%20Co...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/speedway-super-market45/product/Johnson%27s%20Baby%20Kids%20Conditioner%20Shiny%20Drops%20500ml

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" => "1120"
  "REMOTE_ADDR" => "3.134.117.239"
  "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" => "/speedway-super-market45/product/Johnson%27s%20Baby%20Kids%20Conditioner%20Shiny%20Drops%20500ml"
  "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" => 1743993959.3401
  "REQUEST_TIME" => 1743993959
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 07 Apr 2025 02:45:59 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJvdVlJaHBUd3JHSmVuMFNza0cvaXc9PSIsInZhbHVlIjoiQU55dG5BQ3Nob0x6YTFwSkdMeE9kNW1CMjdDS0VGWXJaWHNDcFErRjRTZ0Y3U1hLNEZXRXo5SFBWRkRNU1pCck56dm5jblVORE5Tck5uRWJtNjVjZWU0SGZpUUVHZnVrak1kYTM3WGpXYnAyYkFaZER6Ri9nUGtuVGRaOFNTVUciLCJtYWMiOiJkZjJlZDhjNTM0MDUxZmJkZTgyZDAzNGQ4NTYwZWNlZTlhYWMzMTlkMmQzZmUwY2QxYmY4MDdiNmE2MDg5MGJlIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 02:45:59 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlJvdVlJaHBUd3JHSmVuMFNza0cvaXc9PSIsInZhbHVlIjoiQU55dG5BQ3Nob0x6YTFwSkdMeE9kNW1CMjdDS0VGWXJaWHNDcFErRjRTZ0Y3U1hLNEZXRXo5SFBWRkRNU1pCck56dm5jb ▶"
    1 => "royoorders_session=eyJpdiI6Im1tUi95dGlMcnZubFFoRGYvd3FpVVE9PSIsInZhbHVlIjoickFhK3pkVlJFVVhaanllZWpjSGhxWEJtSG44RVFyWkJpRC9GTkVTQkJWdS9tcnl3bVVCYUF4K0drMXRodDFESkZkQWV2cUg2WmhXSUZIWk1uMEtwc211bXRLQXRNVkluK2Z4QzF2azRzM1N0cmRlcGVEd0ZxT2l2b1daMHllTGQiLCJtYWMiOiI4NDFjZjA3ODY2ZDExOGQwNDRjYjM3NGJlM2VmMDExY2ViODEzNzVmMGVkOGUzMTY1NGY0YmU2NTliOTQ4NmJmIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 02:45:59 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀royoorders_session=eyJpdiI6Im1tUi95dGlMcnZubFFoRGYvd3FpVVE9PSIsInZhbHVlIjoickFhK3pkVlJFVVhaanllZWpjSGhxWEJtSG44RVFyWkJpRC9GTkVTQkJWdS9tcnl3bVVCYUF4K0drMXRodDFES ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJvdVlJaHBUd3JHSmVuMFNza0cvaXc9PSIsInZhbHVlIjoiQU55dG5BQ3Nob0x6YTFwSkdMeE9kNW1CMjdDS0VGWXJaWHNDcFErRjRTZ0Y3U1hLNEZXRXo5SFBWRkRNU1pCck56dm5jblVORE5Tck5uRWJtNjVjZWU0SGZpUUVHZnVrak1kYTM3WGpXYnAyYkFaZER6Ri9nUGtuVGRaOFNTVUciLCJtYWMiOiJkZjJlZDhjNTM0MDUxZmJkZTgyZDAzNGQ4NTYwZWNlZTlhYWMzMTlkMmQzZmUwY2QxYmY4MDdiNmE2MDg5MGJlIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 02:45:59 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlJvdVlJaHBUd3JHSmVuMFNza0cvaXc9PSIsInZhbHVlIjoiQU55dG5BQ3Nob0x6YTFwSkdMeE9kNW1CMjdDS0VGWXJaWHNDcFErRjRTZ0Y3U1hLNEZXRXo5SFBWRkRNU1pCck56dm5jb ▶"
    1 => "royoorders_session=eyJpdiI6Im1tUi95dGlMcnZubFFoRGYvd3FpVVE9PSIsInZhbHVlIjoickFhK3pkVlJFVVhaanllZWpjSGhxWEJtSG44RVFyWkJpRC9GTkVTQkJWdS9tcnl3bVVCYUF4K0drMXRodDFESkZkQWV2cUg2WmhXSUZIWk1uMEtwc211bXRLQXRNVkluK2Z4QzF2azRzM1N0cmRlcGVEd0ZxT2l2b1daMHllTGQiLCJtYWMiOiI4NDFjZjA3ODY2ZDExOGQwNDRjYjM3NGJlM2VmMDExY2ViODEzNzVmMGVkOGUzMTY1NGY0YmU2NTliOTQ4NmJmIiwidGFnIjoiIn0%3D; expires=Tue, 07-Apr-2026 02:45:59 GMT; path=/; httponly ◀royoorders_session=eyJpdiI6Im1tUi95dGlMcnZubFFoRGYvd3FpVVE9PSIsInZhbHVlIjoickFhK3pkVlJFVVhaanllZWpjSGhxWEJtSG44RVFyWkJpRC9GTkVTQkJWdS9tcnl3bVVCYUF4K0drMXRodDFES ▶"
  ]
]

session_attributes

  0 of 0   
array:15 [▼
  "_token" => "BeBT5gyIU3sQJpOa3WehzUrq1sElM1B9w46l06bS"
  "client_config" => {#3762 ▶
    +"name": "Ored"
    +"email": "admin@ored.com"
    +"phone_number": "501692300"
    +"is_deleted": 0
    +"is_blocked": 0
    +"logo": {#3763 ▶
      +"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/speedway-super-market45/product/Johnson%27s%20Baby%20Kids%20Conditioner%20Shiny%20Drops%20500ml"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

BESbswy

language

currency

Change Theme

language

currency

Change Theme