Sona is a tutor of Accounting in Armenia with huge experience at Lrnkey

Messages Timeline Exceptions Views19 Route Queries13 Models125 Mails Gate Session Request

7.4.3214ms7MBGET {path}

Booting (35.47ms)
Application (178ms)
1 x Application (83.28%)
178.26ms
1 x Booting (16.57%)
35.47ms

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:13-16

13 statements were executed, 2 of which were duplicated, 11 unique70.45ms

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

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

Metadata
Bindings	0. 13359
Backtrace	14. /legacy/modules/Coaches.php:497 18. /app/Http/Controllers/LegacyController.php:15 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` = 13359

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

Metadata
Bindings	0. 13359
Backtrace	12. /legacy/modules/Coaches.php:526 16. /app/Http/Controllers/LegacyController.php:15 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` = 13359 and `reviewer_id` is null) as `exists`

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

Metadata
Bindings	0. 13359
Backtrace	10. /legacy/modules/Coaches.php:556 14. /app/Http/Controllers/LegacyController.php:15 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` = 13359 limit 1

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

Metadata
Bindings	0. 13359
Backtrace	19. /legacy/modules/Coaches.php:579 23. /app/Http/Controllers/LegacyController.php:15 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` = 13359

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

Metadata
Bindings	0. 13359
Backtrace	19. /legacy/modules/Coaches.php:579 23. /app/Http/Controllers/LegacyController.php:15 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` = 13359 limit 1

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

Metadata
Bindings	0. 13359
Backtrace	19. /legacy/modules/Coaches.php:581 23. /app/Http/Controllers/LegacyController.php:15 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` = 13359 order by `lessons_count` desc limit 1

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

Metadata
Bindings	0. 13359
Backtrace	15. /legacy/modules/Coaches.php:581 19. /app/Http/Controllers/LegacyController.php:15 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 '%Finances%' or `lesson_categories`.`category_name` like '%Finances%'

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

Metadata
Bindings	0. %Finances% 1. %Finances%
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-13 11:22:18') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 and FIND_IN_SET(account_subjects.subject_id,'447,448,449,450,451,452,453,611,612,613,650,684,685,687,706,707') group by `accounts`.`account_id`

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

Metadata
Bindings	0. 5 1. 5 2. 220 3. Active 4. Pending 5. 2025-07-13 11:22:18 6. 1 7. 447,448,449,450,451,452,453,611,612,613,650,684,685,687,706,707
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 (10438, 10909, 11033, 11650, 11946, 12190, 12566, 12835, 12883, 13359, 13773, 13851, 13922, 13937, 14070, 14172, 14473, 14845, 14926, 14960, 15056, 15576, 15742) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc

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

Metadata
Bindings	0. 1.1 1. 5 2. 220 3. 10438 4. 10909 5. 11033 6. 11650 7. 11946 8. 12190 9. 12566 10. 12835 11. 12883 12. 13359 13. 13773 14. 13851 15. 13922 16. 13937 17. 14070 18. 14172 19. 14473 20. 14845 21. 14926 22. 14960 23. 15056 24. 15576 25. 15742
Backtrace	14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115 15. /legacy/modules/Coaches.php:590 19. /app/Http/Controllers/LegacyController.php:15 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 (10438, 10909, 11033, 11650, 11946, 12190, 12566, 12835, 12883, 13359, 13773, 13851, 13922, 13937, 14070, 14172, 14473, 14845, 14926, 14960, 15056, 15576, 15742)

1.47ms/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:15 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 (10438, 10909, 11033, 11650, 11946, 12190, 12566, 12835, 12883, 13359, 13773, 13851, 13922, 13937, 14070, 14172, 14473, 14845, 14926, 14960, 15056, 15576, 15742)

1.38ms/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:15 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 (10438, 10909, 11033, 11650, 11946, 12190, 12566, 12835, 12883, 13359, 13773, 13851, 13922, 13937, 14070, 14172, 14473, 14845, 14926, 14960, 15056, 15576, 15742) and `start_time` > '2025-07-14 11:22:18' and `start_time` <= '2025-07-21 11:22:18' order by `start_time` asc

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

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

App\Models\LessonSubjects: 70
App\Models\Account: 48
App\Models\AccountAttachment: 7

_token: IrR57CF1C4d4nYNQsTVoAOsWSBugBy4cUKHu3D3e
_previous: array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/sona-avanesyan-3456" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/find-online-tutor/sona-avanesyan-3456

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/sona-avanesyan-3456"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/find-online-tutor/sona-avanesyan-3456"
  "REMOTE_PORT" => "60187"
  "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.204"
  "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" => "4080744-1381-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" => "4080744-1381-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" => 1752492138.3088
  "REQUEST_TIME" => 1752492138
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 14 Jul 2025 11:22:18 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im05UGoveEFhYlZzRDREREdpVm1odlE9PSIsInZhbHVlIjoic3JMRzdHZ3BIZnJrTkhSelk1cDZYRTNRSWo2ZkxURlhjQTh4V2pvY2RHT3RBbUkxeW9pektrMmtpRjVrVmQvdG5VVGNqVmRrZGdJTHpMTzhKSTBCZkJsdS9QcjYyVkR2VHNHN3VFOGp2SWdIK256cjV0YjZFMC9MdUZsMHB1TnYiLCJtYWMiOiIwZDU0ZWNiMWY1NDZmNzZkNzQzYzNiZjc5MTFkMDlmMmY0NjJlOWJkZDg4YTE5YjkyMDVjNmJlNDk3MmE0NmMzIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 11:22:18 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im05UGoveEFhYlZzRDREREdpVm1odlE9PSIsInZhbHVlIjoic3JMRzdHZ3BIZnJrTkhSelk1cDZYRTNRSWo2ZkxURlhjQTh4V2pvY2RHT3RBbUkxeW9pektrMmtpRjVrVmQvdG5VVGNqV ▶"
    1 => "lrnkey_session=eyJpdiI6Ikxxa29mVEVqODdyWm41TTB2M0V0OEE9PSIsInZhbHVlIjoiZnpqQ3ZWZDZRTDM4alZ6QWd6L25YTUJQMmVoa2RzSmtkbkUwS0JUT3F1djhxYSs3SDJIeW9aNFpIOXpFd2x2UnkrbXY5Z2x4WWUyekhma3pYYlpiNDdJUG1sZWkyL05EL0E4d1l0U01QaS9LUElYRC8wT0s4OEZCaTR4WUxmYVgiLCJtYWMiOiJkYmE3NjBhYjIzOGVmNzcxNzYyYWQ0OGFjNmRjNWQ1MzdjZTg0M2IzZWY0MjM4ZWJkYWVlOTNmZWU0ZDEwZTcyIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 11:22:18 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀lrnkey_session=eyJpdiI6Ikxxa29mVEVqODdyWm41TTB2M0V0OEE9PSIsInZhbHVlIjoiZnpqQ3ZWZDZRTDM4alZ6QWd6L25YTUJQMmVoa2RzSmtkbkUwS0JUT3F1djhxYSs3SDJIeW9aNFpIOXpFd2x2Unkrb ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im05UGoveEFhYlZzRDREREdpVm1odlE9PSIsInZhbHVlIjoic3JMRzdHZ3BIZnJrTkhSelk1cDZYRTNRSWo2ZkxURlhjQTh4V2pvY2RHT3RBbUkxeW9pektrMmtpRjVrVmQvdG5VVGNqVmRrZGdJTHpMTzhKSTBCZkJsdS9QcjYyVkR2VHNHN3VFOGp2SWdIK256cjV0YjZFMC9MdUZsMHB1TnYiLCJtYWMiOiIwZDU0ZWNiMWY1NDZmNzZkNzQzYzNiZjc5MTFkMDlmMmY0NjJlOWJkZDg4YTE5YjkyMDVjNmJlNDk3MmE0NmMzIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 11:22:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im05UGoveEFhYlZzRDREREdpVm1odlE9PSIsInZhbHVlIjoic3JMRzdHZ3BIZnJrTkhSelk1cDZYRTNRSWo2ZkxURlhjQTh4V2pvY2RHT3RBbUkxeW9pektrMmtpRjVrVmQvdG5VVGNqV ▶"
    1 => "lrnkey_session=eyJpdiI6Ikxxa29mVEVqODdyWm41TTB2M0V0OEE9PSIsInZhbHVlIjoiZnpqQ3ZWZDZRTDM4alZ6QWd6L25YTUJQMmVoa2RzSmtkbkUwS0JUT3F1djhxYSs3SDJIeW9aNFpIOXpFd2x2UnkrbXY5Z2x4WWUyekhma3pYYlpiNDdJUG1sZWkyL05EL0E4d1l0U01QaS9LUElYRC8wT0s4OEZCaTR4WUxmYVgiLCJtYWMiOiJkYmE3NjBhYjIzOGVmNzcxNzYyYWQ0OGFjNmRjNWQ1MzdjZTg0M2IzZWY0MjM4ZWJkYWVlOTNmZWU0ZDEwZTcyIiwidGFnIjoiIn0%3D; expires=Tue, 14-Jul-2026 11:22:18 GMT; path=/; httponly ◀lrnkey_session=eyJpdiI6Ikxxa29mVEVqODdyWm41TTB2M0V0OEE9PSIsInZhbHVlIjoiZnpqQ3ZWZDZRTDM4alZ6QWd6L25YTUJQMmVoa2RzSmtkbkUwS0JUT3F1djhxYSs3SDJIeW9aNFpIOXpFd2x2Unkrb ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "IrR57CF1C4d4nYNQsTVoAOsWSBugBy4cUKHu3D3e"
  "_previous" => array:1 [▶
    "url" => "https://test.lrnkey.com/find-online-tutor/sona-avanesyan-3456"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

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

Sona Avanesyan

Accounting in Armenia

Հայերեն

Accounting in Armenia

Հայերեն

1 x Application (83.28%)	178.26ms
1 x Booting (16.57%)	35.47ms

Contact Sona Avanesyan

Sona Avanesyan

Accounting in Armenia

Հայերեն

Accounting in Armenia

Հայերեն

July 2025

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