Yatin is a tutor of Business English, English with huge experience at Lrnkey

Messages Timeline Exceptions Views19 Route Queries13 Models1280 Mails Gate Session Request

7.4.3344ms10MBGET {path}

Booting (36.16ms)
Application (307ms)
1 x Application (89.4%)
307.45ms
1 x Booting (10.51%)
36.16ms

19 templates were rendered

redesign.pages.tutor.show (resources/views/redesign/pages/tutor/show.blade.php)7blade


coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory

components.meta.meta-tag (resources/views/components/meta/meta-tag.blade.php)5blade
Params
0
metaData
1
componentName
2
attributes
3
slot
4
__laravel_slots
components.meta.tag (resources/views/components/meta/tag.blade.php)5blade
Params
0
tags
1
componentName
2
attributes
3
slot
4
__laravel_slots
components.tutor-box.image-flag (resources/views/components/tutor-box/image-flag.blade.php)10blade
Params
0
country
1
flag
2
photo
3
id
4
online
5
tooltipClasses
6
componentName
7
attributes
8
slot
9
__laravel_slots

Params
0	`coach`
1	`page_id`
2	`response_time`
3	`requiredToReview`
4	`auth_has_a_free_lesson`
5	`countOfLeLessonForNext24Hours`
6	`randomCoachesByCategory`

Params
0	`metaData`
1	`componentName`
2	`attributes`
3	`slot`
4	`__laravel_slots`

Params
0	`tags`
1	`componentName`
2	`attributes`
3	`slot`
4	`__laravel_slots`

Params
0	`country`
1	`flag`
2	`photo`
3	`id`
4	`online`
5	`tooltipClasses`
6	`componentName`
7	`attributes`
8	`slot`
9	`__laravel_slots`

redesign.pages.tutor.fullcalendar (resources/views/redesign/pages/tutor/fullcalendar.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
timeslots

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`timeslots`

redesign.pages.popups.fullcalendar.request-to-open-time-popup (resources/views/redesign/pages/popups/fullcalendar/request-to-open-time-popup.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
timeslots

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`timeslots`

redesign.pages.tutor.small-calendar (resources/views/redesign/pages/tutor/small-calendar.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
coach_schedule

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`coach_schedule`

components.star (resources/views/components/star.blade.php)34blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
rating
singleStar

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`rating`
33	`singleStar`

redesign.pages.popups.fullcalendar.warning-teacher-maybe-cant-see-booked-lesson-popup (resources/views/redesign/pages/popups/fullcalendar/warning-teacher-maybe-cant-see-booked-lesson-popup.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

components.popups.base-modal (resources/views/components/popups/base-modal.blade.php)4blade
Params
0
componentName
1
attributes
2
slot
3
__laravel_slots

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

Params
0	`componentName`
1	`attributes`
2	`slot`
3	`__laravel_slots`

redesign.layouts.app (resources/views/redesign/layouts/app.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.includes.js-service-attributes (resources/views/redesign/includes/js-service-attributes.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.includes.header (resources/views/redesign/includes/header.blade.php)34blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory
notification_badges

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`
33	`notification_badges`

redesign.pages.auth.login.login-popup (resources/views/redesign/pages/auth/login/login-popup.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.pages.popups.forgot-password (resources/views/redesign/pages/popups/forgot-password.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.pages.auth.registration.registration-popup (resources/views/redesign/pages/auth/registration/registration-popup.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.includes.footer (resources/views/redesign/includes/footer.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

redesign.pages.popups.loader (resources/views/redesign/pages/popups/loader.blade.php)33blade


__env
app
errors
coach
page_id
response_time
requiredToReview
auth_has_a_free_lesson
countOfLeLessonForNext24Hours
randomCoachesByCategory
profileVideo
showHidePackage
coachAvailableForVideoCall
coachAvailableForVideoCallStatusIsStuck
subjects
params
component
tags
countries
__currentLoopData
subject
loop
languages
userLanguages
item
secondVideoObject
checkAttachment
video
images_count
descImageWithoutVideo
is_employment_empty
is_education_empty
randomCoachByCategory

components.popups.recaptcha (resources/views/components/popups/recaptcha.blade.php)5blade
Params
0
modalId
1
componentName
2
attributes
3
slot
4
__laravel_slots

Params
0	`__env`
1	`app`
2	`errors`
3	`coach`
4	`page_id`
5	`response_time`
6	`requiredToReview`
7	`auth_has_a_free_lesson`
8	`countOfLeLessonForNext24Hours`
9	`randomCoachesByCategory`
10	`profileVideo`
11	`showHidePackage`
12	`coachAvailableForVideoCall`
13	`coachAvailableForVideoCallStatusIsStuck`
14	`subjects`
15	`params`
16	`component`
17	`tags`
18	`countries`
19	`__currentLoopData`
20	`subject`
21	`loop`
22	`languages`
23	`userLanguages`
24	`item`
25	`secondVideoObject`
26	`checkAttachment`
27	`video`
28	`images_count`
29	`descImageWithoutVideo`
30	`is_employment_empty`
31	`is_education_empty`
32	`randomCoachByCategory`

Params
0	`modalId`
1	`componentName`
2	`attributes`
3	`slot`
4	`__laravel_slots`

uri: GET {path}
middleware: web, full.registered.user, redirect.old.urls.to.new
controller: App\Http\Controllers\LegacyController@index
as: legacy.
namespace
prefix
where
file: app/Http/Controllers/LegacyController.php:12-15

13 statements were executed, 2 of which were duplicated, 11 unique124ms

select * from `account_attachments` where `account_id` = 12626

4.02ms/legacy/modules/Coaches.php:497lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	14. /legacy/modules/Coaches.php:497 18. /app/Http/Controllers/LegacyController.php:14 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select TIMESTAMPDIFF(MINUTE,(SELECT MAX(last_modified)
FROM message_thread_messages
WHERE thread_id = message_thread_recipients.thread_id
AND message_thread_messages.message_id =
(select MAX(message_id) from message_messages_read where message_messages_read.read_status = 1
&&  message_messages_read.account_id = message_thread_recipients.account_id
&& message_messages_read.thread_id = message_thread_messages.thread_id ORDER BY message_messages_read.last_modified LIMIT 1) ),
(select MAX(last_modified)   from message_messages_read
where message_messages_read.read_status = 1
&& message_messages_read.thread_id = message_thread_recipients.thread_id
&& message_messages_read.account_id = message_thread_recipients.account_id
ORDER BY message_messages_read.last_modified LIMIT 1)) AS diff_minutes from `message_thread_recipients` where `account_id` = 12626

15.96ms/legacy/modules/Coaches.php:526lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	12. /legacy/modules/Coaches.php:526 16. /app/Http/Controllers/LegacyController.php:14 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 exists(select * from `lesson_reviews` where `account_id` = 12626 and `reviewer_id` is null) as `exists`

1.24ms/legacy/modules/Coaches.php:556lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	10. /legacy/modules/Coaches.php:556 14. /app/Http/Controllers/LegacyController.php:14 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

select * from `accounts` where `accounts`.`account_id` = 12626 limit 1

1.15ms/legacy/modules/Coaches.php:579lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	19. /legacy/modules/Coaches.php:579 23. /app/Http/Controllers/LegacyController.php:14 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `packages`.*, `coach_packages`.`coach_id` as `pivot_coach_id`, `coach_packages`.`package_id` as `pivot_package_id` from `packages` inner join `coach_packages` on `packages`.`id` = `coach_packages`.`package_id` where `coach_packages`.`coach_id` = 12626

1.27ms/legacy/modules/Coaches.php:579lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	19. /legacy/modules/Coaches.php:579 23. /app/Http/Controllers/LegacyController.php:14 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `accounts` where `accounts`.`account_id` = 12626 limit 1

1.13ms/legacy/modules/Coaches.php:581lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	19. /legacy/modules/Coaches.php:581 23. /app/Http/Controllers/LegacyController.php:14 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `packages`.*, `coach_packages`.`coach_id` as `pivot_coach_id`, `coach_packages`.`package_id` as `pivot_package_id` from `packages` inner join `coach_packages` on `packages`.`id` = `coach_packages`.`package_id` where `coach_packages`.`coach_id` = 12626 order by `lessons_count` desc limit 1

1.25ms/legacy/modules/Coaches.php:581lrnkey_stage

Metadata
Bindings	0. 12626
Backtrace	15. /legacy/modules/Coaches.php:581 19. /app/Http/Controllers/LegacyController.php:14 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `subject_id` from `lesson_subjects` left join `lesson_categories` on `lesson_subjects`.`category_id` = `lesson_categories`.`category_id` where `subject_name` like '%Languages%' or `lesson_categories`.`category_name` like '%Languages%'

2.15ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:356lrnkey_stage

Metadata
Bindings	0. %Languages% 1. %Languages%
Backtrace	13. /app/Http/DataProviders/Tutor/TutorDataProvider.php:356 14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:269 15. /app/Http/DataProviders/Tutor/TutorDataProvider.php:176 16. /app/Http/DataProviders/Tutor/TutorDataProvider.php:111 17. /legacy/modules/Coaches.php:590

select `accounts`.`account_id` from `accounts` inner join `account_subjects` on `account_subjects`.`account_id` = `accounts`.`account_id` and `account_subjects`.`subject_id` is not null where exists (select * from `lesson_schedule` where `accounts`.`account_id` = `lesson_schedule`.`account_id`) and exists (select * from `account_permissions` where `accounts`.`account_id` = `account_permissions`.`account_id` and `role_id` = 5) and exists (select * from `lesson_pricing` where `accounts`.`account_id` = `lesson_pricing`.`account_id` and `price` is not null and ROUND(price * 1.1)  >= 5 and ROUND(price * 1.1)  <= 220) and exists (select * from `account_profiles` where `accounts`.`account_id` = `account_profiles`.`account_id` and `photo` is not null and `city` is not null and `timezone` is not null and `country` is not null) and (`accounts`.`status` = 'Active' or `accounts`.`status` = 'Pending' and `accounts`.`register_time` > '2025-07-08 11:32:55') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 and FIND_IN_SET(account_subjects.subject_id,'496,497,498,499,500,501,502,503,504,505,506,507,508,509,610,617,619,653,654,656,657,658,660,665,674,677,681,683,686,689,695,698,700,708,709,710') group by `accounts`.`account_id`

49.07ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:568lrnkey_stage

Metadata
Bindings	0. 5 1. 5 2. 220 3. Active 4. Pending 5. 2025-07-08 11:32:55 6. 1 7. 496,497,498,499,500,501,502,503,504,505,506,507,508,509,610,617,619,653,654,656,657,658,660,665,674,677,681,683,686,689,695,698,700,708,709,710
Backtrace	13. /app/Http/DataProviders/Tutor/TutorDataProvider.php:568 14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:359 15. /app/Http/DataProviders/Tutor/TutorDataProvider.php:269 16. /app/Http/DataProviders/Tutor/TutorDataProvider.php:176 17. /app/Http/DataProviders/Tutor/TutorDataProvider.php:111

select `account_profiles`.*, `accounts`.`verified`, `accounts`.`available_for_video_call`, `accounts`.`is_online`, `accounts`.`order_by_admin`, `accounts`.`ordering`, `accounts`.`register_time`, `lesson_pricing`.`duration`, `lesson_pricing`.`currency`, (SELECT trial FROM lesson_pricing WHERE account_id = accounts.account_id && trial = 1 LIMIT 1) as free_trial, CONCAT(account_profiles.first_name, account_profiles.last_name) AS full_name, CONCAT(account_profiles.first_name, "-" ,account_profiles.last_name ,"-",account_profiles.profile_id) AS page, (Select status From account_attachments
where account_id = accounts.account_id
&& status = 1
&& (type = 1
|| type = 5)
LIMIT 1) as video_status, (SELECT count(classroom_id) FROM lesson_classrooms
where coach_id = accounts.account_id && status = "Completed") as completed, (lesson_pricing.price * 1.1) as total_price, (SELECT SUM(subquery.total)/SUM(subquery.count) FROM (
SELECT  SUM(rating) as total, COUNT(*) as count FROM lesson_reviews where account_id = accounts.account_id && rating is not null
UNION ALL
SELECT  SUM(communication + preparing_lessons + understanding_needs + explains_subjects + customizes_lessons + teacher_experience) as total,
COUNT(*) * 6 as count FROM lesson_classroom_reviews where reviewer_id = accounts.account_id
) AS subquery) as rating from `accounts` left join `account_profiles` on `account_profiles`.`account_id` = `accounts`.`account_id` inner join `lesson_pricing` on `lesson_pricing`.`account_id` = `accounts`.`account_id` and `lesson_pricing`.`price` is not null where (lesson_pricing.price * 1.1) between 5 and 220 and `accounts`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc

30.97ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage

Metadata
Bindings	0. 1.1 1. 5 2. 220 3. 10076 4. 10161 5. 10197 6. 10323 7. 10502 8. 10529 9. 10591 10. 10664 11. 10812 12. 10861 13. 10901 14. 10907 15. 10909 16. 10920 17. 10971 18. 10986 19. 11212 20. 11258 21. 11380 22. 11382 23. 11407 24. 11465 25. 11481 26. 11496 27. 11497 28. 11507 29. 11514 30. 11635 31. 11830 32. 11833 33. 11836 34. 11863 35. 11879 36. 11923 37. 11957 38. 11960 39. 12111 40. 12197 41. 12215 42. 12232 43. 12242 44. 12254 45. 12268 46. 12300 47. 12400 48. 12456 49. 12459 50. 12474 51. 12490 52. 12517 53. 12531 54. 12596 55. 12612 56. 12626 57. 12629 58. 12638 59. 12640 60. 12646 61. 12653 62. 12661 63. 12665 64. 12671 65. 12708 66. 12738 67. 12745 68. 12773 69. 12780 70. 12790 71. 12814 72. 12817 73. 12818 74. 12826 75. 12832 76. 12845 77. 12863 78. 12864 79. 12866 80. 12870 81. 12876 82. 12884 83. 12885 84. 12897 85. 12918 86. 12929 87. 12937 88. 12941 89. 12946 90. 12950 91. 12952 92. 12960 93. 12982 94. 13016 95. 13034 96. 13055 97. 13060 98. 13064 99. 13081 100. 13087 101. 13090 102. 13096 103. 13101 104. 13118 105. 13119 106. 13122 107. 13136 108. 13138 109. 13148 110. 13182 111. 13188 112. 13223 113. 13231 114. 13232 115. 13246 116. 13252 117. 13259 118. 13274 119. 13276 120. 13288 121. 13289 122. 13294 123. 13296 124. 13300 125. 13303 126. 13320 127. 13339 128. 13351 129. 13368 130. 13373 131. 13377 132. 13407 133. 13414 134. 13416 135. 13434 136. 13454 137. 13464 138. 13469 139. 13474 140. 13475 141. 13481 142. 13483 143. 13496 144. 13497 145. 13612 146. 13614 147. 13615 148. 13627 149. 13629 150. 13634 151. 13635 152. 13655 153. 13662 154. 13736 155. 13787 156. 13790 157. 13845 158. 13849 159. 13851 160. 13860 161. 13974 162. 13999 163. 14011 164. 14017 165. 14092 166. 14098 167. 14124 168. 14128 169. 14211 170. 14228 171. 14248 172. 14267 173. 14302 174. 14324 175. 14330 176. 14331 177. 14395 178. 14423 179. 14438 180. 14528 181. 14571 182. 14589 183. 14610 184. 14684 185. 14693 186. 14698 187. 14702 188. 14704 189. 14714 190. 14719 191. 14720 192. 14730 193. 14744 194. 14759 195. 14792 196. 14801 197. 14820 198. 14831 199. 14839 200. 14845 201. 14850 202. 14855 203. 14901 204. 14926 205. 14930 206. 14940 207. 14954 208. 14989 209. 15045 210. 15059 211. 15092 212. 15156 213. 15162 214. 15169 215. 15220 216. 15335 217. 15341 218. 15343 219. 15372 220. 15399 221. 15414 222. 15423 223. 15426 224. 15433 225. 15440 226. 15442 227. 15449 228. 15452 229. 15454 230. 15499 231. 15542 232. 15546 233. 15550 234. 15555 235. 15576 236. 15642 237. 15648 238. 15656 239. 15658 240. 15659 241. 15674 242. 15675 243. 15685 244. 15689 245. 15696 246. 15699 247. 15724 248. 15730 249. 15752 250. 15780 251. 15861 252. 15916
Backtrace	14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115 15. /legacy/modules/Coaches.php:590 19. /app/Http/Controllers/LegacyController.php:14 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

Metadata

Bindings

0. 1.1
1. 5
2. 220
3. 10076
4. 10161
5. 10197
6. 10323
7. 10502
8. 10529
9. 10591
10. 10664
11. 10812
12. 10861
13. 10901
14. 10907
15. 10909
16. 10920
17. 10971
18. 10986
19. 11212
20. 11258
21. 11380
22. 11382
23. 11407
24. 11465
25. 11481
26. 11496
27. 11497
28. 11507
29. 11514
30. 11635
31. 11830
32. 11833
33. 11836
34. 11863
35. 11879
36. 11923
37. 11957
38. 11960
39. 12111
40. 12197
41. 12215
42. 12232
43. 12242
44. 12254
45. 12268
46. 12300
47. 12400
48. 12456
49. 12459
50. 12474
51. 12490
52. 12517
53. 12531
54. 12596
55. 12612
56. 12626
57. 12629
58. 12638
59. 12640
60. 12646
61. 12653
62. 12661
63. 12665
64. 12671
65. 12708
66. 12738
67. 12745
68. 12773
69. 12780
70. 12790
71. 12814
72. 12817
73. 12818
74. 12826
75. 12832
76. 12845
77. 12863
78. 12864
79. 12866
80. 12870
81. 12876
82. 12884
83. 12885
84. 12897
85. 12918
86. 12929
87. 12937
88. 12941
89. 12946
90. 12950
91. 12952
92. 12960
93. 12982
94. 13016
95. 13034
96. 13055
97. 13060
98. 13064
99. 13081
100. 13087
101. 13090
102. 13096
103. 13101
104. 13118
105. 13119
106. 13122
107. 13136
108. 13138
109. 13148
110. 13182
111. 13188
112. 13223
113. 13231
114. 13232
115. 13246
116. 13252
117. 13259
118. 13274
119. 13276
120. 13288
121. 13289
122. 13294
123. 13296
124. 13300
125. 13303
126. 13320
127. 13339
128. 13351
129. 13368
130. 13373
131. 13377
132. 13407
133. 13414
134. 13416
135. 13434
136. 13454
137. 13464
138. 13469
139. 13474
140. 13475
141. 13481
142. 13483
143. 13496
144. 13497
145. 13612
146. 13614
147. 13615
148. 13627
149. 13629
150. 13634
151. 13635
152. 13655
153. 13662
154. 13736
155. 13787
156. 13790
157. 13845
158. 13849
159. 13851
160. 13860
161. 13974
162. 13999
163. 14011
164. 14017
165. 14092
166. 14098
167. 14124
168. 14128
169. 14211
170. 14228
171. 14248
172. 14267
173. 14302
174. 14324
175. 14330
176. 14331
177. 14395
178. 14423
179. 14438
180. 14528
181. 14571
182. 14589
183. 14610
184. 14684
185. 14693
186. 14698
187. 14702
188. 14704
189. 14714
190. 14719
191. 14720
192. 14730
193. 14744
194. 14759
195. 14792
196. 14801
197. 14820
198. 14831
199. 14839
200. 14845
201. 14850
202. 14855
203. 14901
204. 14926
205. 14930
206. 14940
207. 14954
208. 14989
209. 15045
210. 15059
211. 15092
212. 15156
213. 15162
214. 15169
215. 15220
216. 15335
217. 15341
218. 15343
219. 15372
220. 15399
221. 15414
222. 15423
223. 15426
224. 15433
225. 15440
226. 15442
227. 15449
228. 15452
229. 15454
230. 15499
231. 15542
232. 15546
233. 15550
234. 15555
235. 15576
236. 15642
237. 15648
238. 15656
239. 15658
240. 15659
241. 15674
242. 15675
243. 15685
244. 15689
245. 15696
246. 15699
247. 15724
248. 15730
249. 15752
250. 15780
251. 15861
252. 15916

Backtrace

14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115
15. /legacy/modules/Coaches.php:590
19. /app/Http/Controllers/LegacyController.php:14
20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `lesson_subjects`.*, `account_subjects`.`account_id` as `pivot_account_id`, `account_subjects`.`subject_id` as `pivot_subject_id` from `lesson_subjects` inner join `account_subjects` on `lesson_subjects`.`subject_id` = `account_subjects`.`subject_id` where `account_subjects`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916)

9.11ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage

Metadata
Backtrace	18. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115 19. /legacy/modules/Coaches.php:590 23. /app/Http/Controllers/LegacyController.php:14 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `account_attachments` where `account_attachments`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916)

3.29ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage

Metadata
Backtrace	19. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115 20. /legacy/modules/Coaches.php:590 24. /app/Http/Controllers/LegacyController.php:14 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `lesson_schedule`.*, (SELECT COUNT(classroom_id) FROM lesson_classrooms
INNER JOIN lesson_orders ON lesson_classrooms.order_id = lesson_orders.order_id
&& lesson_orders.status = 1
WHERE lesson_classrooms.coach_id = lesson_schedule.account_id
&& (lesson_classrooms.status != 'Declined' && lesson_classrooms.status != 'Cancelled')
&& lesson_classrooms.start_time = lesson_schedule.start_time) as booked from `lesson_schedule` where `lesson_schedule`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916) and `start_time` > '2025-07-09 11:32:55' and `start_time` <= '2025-07-16 11:32:55' order by `start_time` asc

3.59ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage

Metadata
Bindings	0. Declined 1. Cancelled 2. 2025-07-09 11:32:55 3. 2025-07-16 11:32:55
Backtrace	19. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115 20. /legacy/modules/Coaches.php:590 24. /app/Http/Controllers/LegacyController.php:14 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

App\Models\LessonSchedule: 40
App\Models\AccountAttachment: 160
App\Models\LessonSubjects: 578
App\Models\Account: 502

_token: M7JVYGbnUbKZg8KaOZpGpsR5QNd8ccfD84NISbAf
_previous: array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/yatin-maharaj-2723" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/find-online-tutor/yatin-maharaj-2723

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "test.lrnkey.com"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_server

  0 of 0   
array:62 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/find-online-tutor/yatin-maharaj-2723"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/find-online-tutor/yatin-maharaj-2723"
  "REMOTE_PORT" => "45138"
  "SCRIPT_FILENAME" => "/var/www/lrnkey/staging/public/index.php"
  "SERVER_ADMIN" => "webmaster@localhost"
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/lrnkey/staging/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/var/www/lrnkey/staging/public"
  "REMOTE_ADDR" => "216.73.216.190"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "65.108.151.124"
  "SERVER_NAME" => "test.lrnkey.com"
  "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at test.lrnkey.com Port 443</address>\n"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "HTTP_HOST" => "test.lrnkey.com"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "test.lrnkey.com"
  "HTTPS" => "on"
  "H2_STREAM_TAG" => "3351602-1002-1"
  "H2_STREAM_ID" => "1"
  "H2_PUSHED_ON" => ""
  "H2_PUSHED" => ""
  "H2_PUSH" => "off"
  "H2PUSH" => "off"
  "HTTP2" => "on"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "test.lrnkey.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_H2_STREAM_TAG" => "3351602-1002-1"
  "REDIRECT_H2_STREAM_ID" => "1"
  "REDIRECT_H2_PUSHED_ON" => ""
  "REDIRECT_H2_PUSHED" => ""
  "REDIRECT_H2_PUSH" => "off"
  "REDIRECT_H2PUSH" => "off"
  "REDIRECT_HTTP2" => "on"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1752060775.1146
  "REQUEST_TIME" => 1752060775
]

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 => "Wed, 09 Jul 2025 11:32:55 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9hOFhiaVEveWxXc0VqdWdkLzl4TlE9PSIsInZhbHVlIjoicVptdk9vaXJTR201bFRXYUlEM28zZ003TnhQRHhDek1ZOWNweUJSNE5BZTJVWWlKbFRVQUlKdEdBK0pEd3BjYjNuRHFIeitNaTF4VVZ2RXRCK0hhWlcrTHRGU2tFbUoxLy9XMFl0dlcxTGtYUFdUVEJqNVNGTjkyeHA0czk1OTIiLCJtYWMiOiJkMDgxNWQ2N2I5Y2ZiYzU4ZDQzM2JhN2QxNTE3MTY1ZTQwZGIwMWFkY2RlYzkzNzQ5N2ViMTk5MzMyYzlkMzk1IiwidGFnIjoiIn0%3D; expires=Thu, 09-Jul-2026 11:32:55 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im9hOFhiaVEveWxXc0VqdWdkLzl4TlE9PSIsInZhbHVlIjoicVptdk9vaXJTR201bFRXYUlEM28zZ003TnhQRHhDek1ZOWNweUJSNE5BZTJVWWlKbFRVQUlKdEdBK0pEd3BjYjNuRHFIe ▶"
    1 => "lrnkey_session=eyJpdiI6InNjNGN3eURjUlRGZElMUE55ZGlNVkE9PSIsInZhbHVlIjoiaDN6dnJaWk9qS2FuQlp5b0t2dXpLT0V1Y0Y5UXY4cWR1NGVCK204UWw0UjE3dmNvQ1hnK3F1ZEEvL25zSWc4UDVnNmg2QnlJQXptMGlXamd3LzlGZTJoNGxSYUhWRWdyNkhnSmNzNzZ3UTJ2QmtHQVdtbFo5Q0tidlVFQXhkNWwiLCJtYWMiOiI3NGVhMTU3NGFmMzlkY2ZkN2I4YTg0NWNlYmZhNzcxNTg4ZTJhZDYwYTEwZDQxODkxZTczODcwNDg1NDYyOTcyIiwidGFnIjoiIn0%3D; expires=Thu, 09-Jul-2026 11:32:55 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀lrnkey_session=eyJpdiI6InNjNGN3eURjUlRGZElMUE55ZGlNVkE9PSIsInZhbHVlIjoiaDN6dnJaWk9qS2FuQlp5b0t2dXpLT0V1Y0Y5UXY4cWR1NGVCK204UWw0UjE3dmNvQ1hnK3F1ZEEvL25zSWc4UDVnN ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9hOFhiaVEveWxXc0VqdWdkLzl4TlE9PSIsInZhbHVlIjoicVptdk9vaXJTR201bFRXYUlEM28zZ003TnhQRHhDek1ZOWNweUJSNE5BZTJVWWlKbFRVQUlKdEdBK0pEd3BjYjNuRHFIeitNaTF4VVZ2RXRCK0hhWlcrTHRGU2tFbUoxLy9XMFl0dlcxTGtYUFdUVEJqNVNGTjkyeHA0czk1OTIiLCJtYWMiOiJkMDgxNWQ2N2I5Y2ZiYzU4ZDQzM2JhN2QxNTE3MTY1ZTQwZGIwMWFkY2RlYzkzNzQ5N2ViMTk5MzMyYzlkMzk1IiwidGFnIjoiIn0%3D; expires=Thu, 09-Jul-2026 11:32:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9hOFhiaVEveWxXc0VqdWdkLzl4TlE9PSIsInZhbHVlIjoicVptdk9vaXJTR201bFRXYUlEM28zZ003TnhQRHhDek1ZOWNweUJSNE5BZTJVWWlKbFRVQUlKdEdBK0pEd3BjYjNuRHFIe ▶"
    1 => "lrnkey_session=eyJpdiI6InNjNGN3eURjUlRGZElMUE55ZGlNVkE9PSIsInZhbHVlIjoiaDN6dnJaWk9qS2FuQlp5b0t2dXpLT0V1Y0Y5UXY4cWR1NGVCK204UWw0UjE3dmNvQ1hnK3F1ZEEvL25zSWc4UDVnNmg2QnlJQXptMGlXamd3LzlGZTJoNGxSYUhWRWdyNkhnSmNzNzZ3UTJ2QmtHQVdtbFo5Q0tidlVFQXhkNWwiLCJtYWMiOiI3NGVhMTU3NGFmMzlkY2ZkN2I4YTg0NWNlYmZhNzcxNTg4ZTJhZDYwYTEwZDQxODkxZTczODcwNDg1NDYyOTcyIiwidGFnIjoiIn0%3D; expires=Thu, 09-Jul-2026 11:32:55 GMT; path=/; httponly ◀lrnkey_session=eyJpdiI6InNjNGN3eURjUlRGZElMUE55ZGlNVkE9PSIsInZhbHVlIjoiaDN6dnJaWk9qS2FuQlp5b0t2dXpLT0V1Y0Y5UXY4cWR1NGVCK204UWw0UjE3dmNvQ1hnK3F1ZEEvL25zSWc4UDVnN ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "M7JVYGbnUbKZg8KaOZpGpsR5QNd8ccfD84NISbAf"
  "_previous" => array:1 [▶
    "url" => "https://test.lrnkey.com/find-online-tutor/yatin-maharaj-2723"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

	Wed	Thu	Fri	Sat	Sun	Mon	Tue
6:00 - 12:00
12:00 - 18:00
18:00 - 24:00
24:00 - 06:00

1 x Application (89.4%)	307.45ms
1 x Booting (10.51%)	36.16ms

Contact Yatin Maharaj

Yatin Maharaj

Business English, English

English

Business English, English

English

July 2025

Click on the request to send a message to the tutor to book a lesson at the selected time