Corte de Pelo

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

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`
25	`__currentLoopData`
26	`loop`
27	`cate`
28	`title`
29	`meta_title`
30	`meta_keyword`
31	`meta_description`

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

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

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`
25	`__currentLoopData`
26	`loop`
27	`cate`
28	`title`
29	`meta_title`
30	`meta_keyword`
31	`meta_description`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`
25	`__currentLoopData`
26	`loop`
27	`cate`
28	`title`
29	`meta_title`
30	`meta_keyword`
31	`meta_description`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

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

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`
25	`__currentLoopData`
26	`loop`
27	`cate`
28	`title`
29	`meta_title`
30	`meta_keyword`
31	`meta_description`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

Params
0	`__env`
1	`app`
2	`last_mile_common_set`
3	`favicon`
4	`client_head`
5	`mod_count`
6	`social_media_details`
7	`stripe_publishable_key`
8	`stripe_fpx_publishable_key`
9	`stripe_oxxo_publishable_key`
10	`stripe_ideal_publishable_key`
11	`khalti_api_key`
12	`yoco_public_key`
13	`checkout_public_key`
14	`client_preference_detail`
15	`client_payment_options`
16	`cashfree_test_mode`
17	`payphone_id`
18	`payPhoneToken`
19	`errors`
20	`listData`
21	`category`
22	`navCategories`
23	`newProducts`
24	`variantSets`
25	`__currentLoopData`
26	`loop`
27	`cate`
28	`title`
29	`meta_title`
30	`meta_keyword`
31	`meta_description`
32	`set_template`
33	`set_common_business_type`
34	`socket_url`
35	`admin_chat`
36	`driver_chat`
37	`customer_chat`
38	`db`
39	`auth_id`
40	`authData`
41	`dark_mode`
42	`body_class`

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

4.72msmiddleware::domain:77royo_farma

Metadata
Bindings	0. fe4568
Backtrace	15. middleware::domain:77 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select `language_id`, `is_primary` from `client_languages` where `is_primary` = 1 limit 1

1.05msmiddleware::domain:87royo_farma

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:87 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `languages` where `id` = 148 limit 1

950μsmiddleware::domain:97royo_farma

Metadata
Bindings	0. 148
Backtrace	15. middleware::domain:97 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `client_currencies` inner join `currencies` as `cu` on `cu`.`id` = `client_currencies`.`currency_id` where `client_currencies`.`is_primary` = 1 limit 1

3.1msmiddleware::domain:102royo_farma

Metadata
Bindings	0. 1
Backtrace	15. middleware::domain:102 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `currencies` where `id` = 98 limit 1

760μsmiddleware::domain:117royo_farma

Metadata
Bindings	0. 98
Backtrace	15. middleware::domain:117 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 17. middleware::subdomain:22 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 19. middleware::languageSwitch:26

select * from `clients` limit 1

650μsmiddleware::domain:126royo_farma

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

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

520μsmiddleware::domain:127royo_farma

Metadata
Bindings	0. 138
Backtrace	14. middleware::domain:127 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 16. middleware::subdomain:22 17. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167 18. middleware::languageSwitch:26

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

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

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

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

4.3ms/app/Http/Controllers/Front/CategoryController.php:49royo_farma

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

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

7.53ms/app/Http/Controllers/Front/CategoryController.php:49royo_farma

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

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

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

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

select `categories`.`id`, `categories`.`slug`, `categories`.`parent_id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`image`, `type_id`, `types`.`title` as `redirect_to` from `categories` inner join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`parent_id` in (990) and `categories`.`deleted_at` is null order by `position` asc

4.33ms/app/Http/Controllers/Front/CategoryController.php:49royo_farma

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

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

4.45ms/app/Http/Controllers/Front/CategoryController.php:49royo_farma

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

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

5.4ms/app/Http/Controllers/Front/CategoryController.php:49royo_farma

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2.26ms/app/Http/Controllers/Front/FrontController.php:289royo_farma

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

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

14.07ms/app/Http/Controllers/Front/FrontController.php:327royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:327 15. /app/Http/Controllers/Front/CategoryController.php:58 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

2.31ms/app/Http/Controllers/Front/FrontController.php:331royo_farma

Metadata
Bindings	0. 1 1. 1 2. 75 3. 77 4. 78 5. 79 6. 81 7. 85 8. 86 9. 87
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:331 15. /app/Http/Controllers/Front/CategoryController.php:58 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `vendor_categories` where `category_id` = 1042 and `status` = 1 limit 1

990μs/app/Http/Controllers/Front/CategoryController.php:71royo_farma

Metadata
Bindings	0. 1042 1. 1
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:71 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 `vendor_categories` where `category_id` = 1043 and `status` = 1 limit 1

2.56ms/app/Http/Controllers/Front/CategoryController.php:71royo_farma

Metadata
Bindings	0. 1043 1. 1
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:71 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 `vendor_categories` where `category_id` = 1044 and `status` = 1 limit 1

1.6ms/app/Http/Controllers/Front/CategoryController.php:71royo_farma

Metadata
Bindings	0. 1044 1. 1
Backtrace	15. /app/Http/Controllers/Front/CategoryController.php:71 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 `vendor_id` from `vendor_categories` where `category_id` = 990 and `status` = 1

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

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

select `business_type` from `client_preferences` limit 1

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

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

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

1.65ms/app/helpers.php:1073royo_farma

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

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

1.32ms/app/Http/Controllers/Front/FrontController.php:164royo_farma

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

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

1.33ms/app/Http/Controllers/Front/FrontController.php:289royo_farma

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

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

5.91ms/app/Http/Controllers/Front/FrontController.php:327royo_farma

Metadata
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:327 15. /app/Http/Controllers/Front/FrontController.php:182 16. /app/Http/Controllers/Front/CategoryController.php:103 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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

930μs/app/Http/Controllers/Front/FrontController.php:331royo_farma

Metadata
Bindings	0. 1 1. 1 2. 75 3. 77 4. 78 5. 79 6. 81 7. 85 8. 86 9. 87
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:331 15. /app/Http/Controllers/Front/FrontController.php:182 16. /app/Http/Controllers/Front/CategoryController.php:103 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select distinct `categories`.`id`, `categories`.`icon`, `categories`.`icon_two`, `categories`.`slug`, `categories`.`parent_id`, `cts`.`name`, `categories`.`type_id` from `categories` inner join `category_translations` as `cts` on `categories`.`id` = `cts`.`category_id` left join `vendor_categories` as `vct` on `categories`.`id` = `vct`.`category_id` left join `types` on `types`.`id` = `categories`.`type_id` where `categories`.`type_id` in (1, 3, 4, 5, 6, 11) and (`vct`.`vendor_id` in (75) and `vct`.`status` = 1 or (`categories`.`type_id` in (4, 8))) and `categories`.`id` > '1' and `categories`.`type_id` is not null and `categories`.`type_id` != 5 and `categories`.`id` > '1' and `categories`.`is_visible` = 1 and `categories`.`is_core` = 1 and `categories`.`status` != 2 and `cts`.`language_id` = 148 and (`cts`.`language_id` = 148 or `cts`.`language_id` = 148) and `categories`.`vendor_id` is null and `categories`.`deleted_at` is null group by `id` order by `position` asc, `categories`.`parent_id` asc

7.97ms/app/Http/Controllers/Front/FrontController.php:214royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 75 7. 1 8. 4 9. 8 10. 1 11. 5 12. 1 13. 1 14. 1 15. 2 16. 148 17. 148 18. 148
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:214 15. /app/Http/Controllers/Front/CategoryController.php:103 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

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

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

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

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

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

select count(*) as aggregate from `products` where `products`.`is_live` = 1 and `products`.`category_id` = 990 and `products`.`vendor_id` in (75) and `products`.`deleted_at` is null

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

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

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

610μs/app/Http/Controllers/Front/FrontController.php:382royo_farma

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

select `business_type` from `client_preferences` limit 1

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

Metadata
Backtrace	15. /app/helpers.php:1044 25. /app/Http/Controllers/Front/FrontController.php:384 26. /app/Http/Controllers/Front/CategoryController.php:140 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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

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

Metadata
Bindings	0. products_service
Backtrace	13. /app/helpers.php:1073 23. /app/Http/Controllers/Front/FrontController.php:384 24. /app/Http/Controllers/Front/CategoryController.php:140 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `id`, `sku`, `url_slug`, `weight_unit`, `weight`, `vendor_id`, `has_variant`, `has_inventory`, `sell_when_out_of_stock`, `requires_shipping`, `Requires_last_mile`, `averageRating`, `inquiry_only`, `minimum_order_count`, `batch_count`, `minimum_duration_min` from `products` where exists (select * from `categories` where `products`.`category_id` = `categories`.`id` and `type_id` in (1, 3, 4, 5, 6, 11) and `categories`.`deleted_at` is null) and `is_new` = 1 and `vendor_id` in (75) and `category_id` in (1042, 1043, 1044) and `is_live` = 1 and `category_id` is not null and `products`.`deleted_at` is null limit 6

2.31ms/app/Http/Controllers/Front/FrontController.php:416royo_farma

Metadata
Bindings	0. 1 1. 3 2. 4 3. 5 4. 6 5. 11 6. 1 7. 75 8. 1042 9. 1043 10. 1044 11. 1
Backtrace	14. /app/Http/Controllers/Front/FrontController.php:416 15. /app/Http/Controllers/Front/CategoryController.php:140 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

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

2.59msview::c863c85b7e431383c81545f7658f2192ef2ca1c2:8royo_farma

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

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

1.76msview::c863c85b7e431383c81545f7658f2192ef2ca1c2:8royo_farma

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

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

5.78msview::7fe8350a773c95649c81a6a807585448b67211e1:2royo_farma

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

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

4.44msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:2royo_farma

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

select * from `client_languages` where `is_active` = 1 order by `is_primary` desc

2.84msview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8royo_farma

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

select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 148)

890μsview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:8royo_farma

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

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

710μsview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:9royo_farma

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

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

830μsview::b5ca5505df61eb3e47ea3647d66f7a7e82c42a1a:9royo_farma

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

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

830μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:2royo_farma

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

select * from `client_languages` where `is_active` = 1 order by `is_primary` desc

1.37msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4royo_farma

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

select `id`, `name`, `sort_code`, `nativeName` from `languages` where `languages`.`id` in (1, 148)

800μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:4royo_farma

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

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

920μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:5royo_farma

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

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

750μsview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:5royo_farma

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

select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 148)) order by `order_by` asc

3.29msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	14. view::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 7) and `language_id` = 148

5.43msview::fd52faaf43b1ca623f9ac62dfb9492bcf857d41b:6royo_farma

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

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

2.44ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (9) and `language_id` = 148

2.52ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures` where `label` LIKE '%Dine-In%' limit 1

1.6ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (8) and `language_id` = 148

1.52ms/app/helpers.php:237royo_farma

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

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

990μs/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (5) and `language_id` = 148

770μs/app/helpers.php:237royo_farma

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

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

740μs/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (15) and `language_id` = 148

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

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

select * from `nomenclatures` where `label` LIKE '%Pick & Drop%' limit 1

2.19ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (16) and `language_id` = 148

1.29ms/app/helpers.php:237royo_farma

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

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

1.35ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (17) and `language_id` = 148

530μs/app/helpers.php:237royo_farma

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

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

460μs/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (18) and `language_id` = 148

1.02ms/app/helpers.php:237royo_farma

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

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

2.25ms/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (20) and `language_id` = 148

1.7ms/app/helpers.php:237royo_farma

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

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

720μs/app/helpers.php:237royo_farma

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

select * from `nomenclatures_translations` where `nomenclatures_translations`.`nomenclature_id` in (6) and `language_id` = 148

1.42ms/app/helpers.php:237royo_farma

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

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

5.81msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:3royo_farma

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

select * from `payment_methods` where `is_show` = 1

2.13msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:10royo_farma

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

select * from `pages` where exists (select * from `page_translations` where `pages`.`id` = `page_translations`.`page_id` and (`is_published` = 1 and `language_id` = 148)) order by `order_by` asc

1.09msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11royo_farma

Metadata
Bindings	0. 1 1. 148
Backtrace	14. view::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 19. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `page_translations` where `page_translations`.`page_id` in (1, 2, 7) and `language_id` = 148

1.02msview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:11royo_farma

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

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

900μsview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

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

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

780μsview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

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

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

760μsview::0c26f84b5972e1e8208fd27d51b26d0aa134b6bf:42royo_farma

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

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

1.23msview::3c1c7b3b62a0ba2dd5955b8a22e47aaac5bde2dd:17royo_farma

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

select * from `clients` limit 1

600μs/app/helpers.php:45royo_farma

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

select column_name as `column_name` from information_schema.columns where table_schema = 'royo_farma' and table_name = 'client_preference_additional'

1.27ms/app/helpers.php:29royo_farma

Metadata
Bindings	0. royo_farma 1. client_preference_additional
Backtrace	11. /app/helpers.php:29 15. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 16. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 18. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select `key_name`, `key_value` from `client_preference_additional` where `key_name` in ('gtag_id', 'fpixel_id') and (`client_code` = 'fe4568')

660μs/app/helpers.php:49royo_farma

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

select * from `show_subscription_plan_on_signups` where `show_subscription_plan_on_signups`.`id` = 1 limit 1

580μs/app/helpers.php:72royo_farma

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

select `credentials`, `test_mode` from `payment_options` where `code` = 'razorpay' and `status` = 1 limit 1

760μs/app/helpers.php:299royo_farma

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

select `credentials`, `test_mode` from `payment_options` where `code` = 'khalti' and `status` = 1 limit 1

3.03ms/app/helpers.php:312royo_farma

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

select * from `client_preferences` limit 1

1.9ms/app/helpers.php:278royo_farma

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

select * from `client_preferences` limit 1

8.1ms/app/helpers.php:278royo_farma

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

select * from `client_preferences` limit 1

3.61ms/app/helpers.php:278royo_farma

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

select * from `clients` limit 1

1.07ms/app/helpers.php:290royo_farma

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

select * from `clients` limit 1

1.57ms/app/helpers.php:290royo_farma

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

1 x Application (76.57%)	561ms
1 x Booting (23.43%)	172ms

Ciudad de México, CDMX, México

Idioma

Divisa

Cambiar de tema

Nuevo producto Atrás

Corte General

Desenredado de Pelaje

Zonas Específicas

Enlaces

Contáctanos

Descarga nuestra app

Idioma

Divisa

Cambiar de tema

Corte de Pelo

Nuevo producto Atrás

Corte General

Desenredado de Pelaje

Zonas Específicas

Eliminar carrito

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