Amr is a tutor of Photography, Project Management, PMP with huge experience at Lrnkey

Messages Timeline Exceptions Views19 Route Queries13 Models3425 Mails Gate Session Request

7.4.3441ms17MBGET {path}

Booting (30.77ms)
Application (410ms)
1 x Application (92.97%)
409.73ms
1 x Booting (6.98%)
30.77ms

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)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
emplayment
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	`emplayment`
33	`timeslots`

redesign.pages.popups.fullcalendar.request-to-open-time-popup (resources/views/redesign/pages/popups/fullcalendar/request-to-open-time-popup.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
emplayment
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	`emplayment`
33	`timeslots`

redesign.pages.tutor.small-calendar (resources/views/redesign/pages/tutor/small-calendar.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
emplayment
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	`emplayment`
33	`coach_schedule`

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


__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
emplayment
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	`emplayment`
33	`rating`
34	`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)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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

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

redesign.layouts.app (resources/views/redesign/layouts/app.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

redesign.includes.js-service-attributes (resources/views/redesign/includes/js-service-attributes.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

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


__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
emplayment
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	`emplayment`
33	`randomCoachByCategory`
34	`notification_badges`

redesign.pages.auth.login.login-popup (resources/views/redesign/pages/auth/login/login-popup.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

redesign.pages.popups.forgot-password (resources/views/redesign/pages/popups/forgot-password.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

redesign.pages.auth.registration.registration-popup (resources/views/redesign/pages/auth/registration/registration-popup.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

redesign.includes.footer (resources/views/redesign/includes/footer.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
emplayment
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	`emplayment`
33	`randomCoachByCategory`

redesign.pages.popups.loader (resources/views/redesign/pages/popups/loader.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
emplayment
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	`emplayment`
33	`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 unique192ms

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

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

Metadata
Bindings	0. 10930
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` = 10930

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

Metadata
Bindings	0. 10930
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` = 10930 and `reviewer_id` is null) as `exists`

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

Metadata
Bindings	0. 10930
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` = 10930 limit 1

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

Metadata
Bindings	0. 10930
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` = 10930

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

Metadata
Bindings	0. 10930
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` = 10930 limit 1

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

Metadata
Bindings	0. 10930
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` = 10930 order by `lessons_count` desc limit 1

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

Metadata
Bindings	0. 10930
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 '%Arts & Crafts%' or `lesson_categories`.`category_name` like '%Arts & Crafts%'

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

Metadata
Bindings	0. %Arts & Crafts% 1. %Arts & Crafts%
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-15 02:35:35') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 group by `accounts`.`account_id`

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

Metadata
Bindings	0. 5 1. 5 2. 220 3. Active 4. Pending 5. 2025-07-15 02:35:35 6. 1
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 (10063, 10065, 10066, 10075, 10076, 10082, 10090, 10098, 10099, 10104, 10119, 10126, 10129, 10143, 10149, 10153, 10159, 10161, 10171, 10172, 10191, 10197, 10211, 10217, 10225, 10229, 10231, 10232, 10237, 10244, 10249, 10250, 10257, 10258, 10263, 10265, 10291, 10307, 10323, 10327, 10329, 10362, 10369, 10383, 10384, 10422, 10436, 10438, 10474, 10486, 10495, 10502, 10529, 10583, 10591, 10620, 10633, 10653, 10657, 10659, 10664, 10700, 10755, 10765, 10812, 10854, 10861, 10877, 10883, 10900, 10901, 10906, 10907, 10909, 10920, 10930, 10964, 10971, 10986, 10988, 11002, 11005, 11033, 11047, 11054, 11101, 11103, 11182, 11202, 11212, 11231, 11243, 11258, 11326, 11336, 11338, 11344, 11353, 11359, 11380, 11382, 11383, 11407, 11410, 11430, 11454, 11460, 11465, 11468, 11473, 11481, 11483, 11495, 11496, 11497, 11502, 11504, 11507, 11514, 11541, 11557, 11572, 11597, 11610, 11620, 11633, 11635, 11636, 11650, 11682, 11684, 11689, 11691, 11697, 11699, 11712, 11743, 11752, 11754, 11760, 11775, 11776, 11780, 11783, 11784, 11796, 11814, 11821, 11827, 11829, 11830, 11833, 11836, 11837, 11850, 11857, 11863, 11879, 11888, 11890, 11903, 11908, 11918, 11923, 11940, 11946, 11957, 11960, 11964, 11966, 11970, 11976, 11982, 12006, 12009, 12015, 12018, 12042, 12048, 12056, 12057, 12063, 12075, 12090, 12091, 12098, 12105, 12111, 12123, 12125, 12159, 12164, 12170, 12177, 12178, 12183, 12190, 12197, 12199, 12203, 12204, 12205, 12207, 12212, 12214, 12215, 12217, 12219, 12232, 12242, 12251, 12254, 12256, 12260, 12261, 12262, 12267, 12268, 12269, 12273, 12284, 12300, 12301, 12302, 12314, 12316, 12318, 12327, 12370, 12378, 12379, 12390, 12391, 12393, 12400, 12409, 12425, 12428, 12429, 12450, 12456, 12459, 12467, 12474, 12477, 12482, 12484, 12485, 12488, 12490, 12492, 12514, 12515, 12516, 12517, 12520, 12531, 12545, 12566, 12586, 12596, 12603, 12612, 12614, 12626, 12629, 12637, 12638, 12640, 12646, 12647, 12653, 12661, 12665, 12671, 12708, 12715, 12721, 12731, 12738, 12745, 12756, 12773, 12776, 12780, 12790, 12796, 12802, 12803, 12807, 12808, 12814, 12817, 12818, 12826, 12829, 12832, 12835, 12838, 12841, 12845, 12849, 12856, 12860, 12863, 12864, 12866, 12870, 12876, 12883, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12943, 12946, 12949, 12950, 12952, 12953, 12960, 12982, 13016, 13034, 13055, 13057, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13105, 13118, 13119, 13122, 13136, 13138, 13148, 13152, 13182, 13187, 13188, 13202, 13223, 13231, 13232, 13246, 13252, 13256, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13311, 13315, 13320, 13339, 13351, 13359, 13368, 13373, 13377, 13396, 13402, 13407, 13414, 13416, 13432, 13434, 13439, 13447, 13454, 13455, 13458, 13459, 13462, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13499, 13539, 13556, 13579, 13590, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13648, 13653, 13655, 13659, 13662, 13685, 13736, 13747, 13773, 13787, 13790, 13845, 13849, 13851, 13859, 13860, 13872, 13888, 13900, 13905, 13918, 13922, 13934, 13937, 13938, 13974, 13977, 13987, 13989, 13991, 13999, 14011, 14017, 14026, 14027, 14029, 14045, 14070, 14071, 14092, 14098, 14107, 14120, 14124, 14128, 14137, 14147, 14148, 14169, 14172, 14174, 14185, 14195, 14207, 14211, 14219, 14220, 14228, 14230, 14242, 14248, 14266, 14267, 14284, 14302, 14310, 14324, 14328, 14330, 14331, 14348, 14359, 14364, 14395, 14400, 14418, 14423, 14438, 14449, 14473, 14509, 14515, 14520, 14528, 14531, 14566, 14571, 14573, 14575, 14578, 14589, 14607, 14610, 14671, 14672, 14677, 14678, 14680, 14682, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14740, 14744, 14759, 14762, 14786, 14789, 14792, 14801, 14805, 14820, 14822, 14828, 14831, 14836, 14838, 14839, 14840, 14845, 14850, 14855, 14874, 14879, 14889, 14897, 14901, 14925, 14926, 14930, 14933, 14939, 14940, 14954, 14957, 14960, 14965, 14980, 14984, 14989, 14994, 14997, 15044, 15045, 15046, 15056, 15059, 15062, 15065, 15066, 15068, 15074, 15092, 15099, 15117, 15144, 15156, 15162, 15169, 15175, 15176, 15192, 15211, 15220, 15231, 15248, 15287, 15291, 15315, 15326, 15327, 15332, 15335, 15341, 15343, 15363, 15372, 15392, 15399, 15407, 15413, 15414, 15416, 15423, 15424, 15426, 15428, 15433, 15440, 15442, 15445, 15447, 15449, 15452, 15454, 15460, 15461, 15492, 15499, 15504, 15505, 15506, 15507, 15509, 15514, 15515, 15519, 15529, 15535, 15542, 15545, 15546, 15550, 15555, 15562, 15576, 15582, 15622, 15627, 15629, 15630, 15642, 15648, 15654, 15656, 15658, 15659, 15672, 15674, 15675, 15680, 15685, 15688, 15689, 15696, 15699, 15717, 15724, 15730, 15742, 15752, 15754, 15780, 15799, 15813, 15814, 15822, 15861, 15878, 15887, 15888, 15894, 15909, 15912, 15914, 15915, 15916, 15917, 15941, 15944, 15950, 15960, 15967, 15968, 15969, 15980, 15981, 15982, 15988, 15989, 15993, 16000) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc

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

Metadata
Bindings	0. 1.1 1. 5 2. 220 3. 10063 4. 10065 5. 10066 6. 10075 7. 10076 8. 10082 9. 10090 10. 10098 11. 10099 12. 10104 13. 10119 14. 10126 15. 10129 16. 10143 17. 10149 18. 10153 19. 10159 20. 10161 21. 10171 22. 10172 23. 10191 24. 10197 25. 10211 26. 10217 27. 10225 28. 10229 29. 10231 30. 10232 31. 10237 32. 10244 33. 10249 34. 10250 35. 10257 36. 10258 37. 10263 38. 10265 39. 10291 40. 10307 41. 10323 42. 10327 43. 10329 44. 10362 45. 10369 46. 10383 47. 10384 48. 10422 49. 10436 50. 10438 51. 10474 52. 10486 53. 10495 54. 10502 55. 10529 56. 10583 57. 10591 58. 10620 59. 10633 60. 10653 61. 10657 62. 10659 63. 10664 64. 10700 65. 10755 66. 10765 67. 10812 68. 10854 69. 10861 70. 10877 71. 10883 72. 10900 73. 10901 74. 10906 75. 10907 76. 10909 77. 10920 78. 10930 79. 10964 80. 10971 81. 10986 82. 10988 83. 11002 84. 11005 85. 11033 86. 11047 87. 11054 88. 11101 89. 11103 90. 11182 91. 11202 92. 11212 93. 11231 94. 11243 95. 11258 96. 11326 97. 11336 98. 11338 99. 11344 100. 11353 101. 11359 102. 11380 103. 11382 104. 11383 105. 11407 106. 11410 107. 11430 108. 11454 109. 11460 110. 11465 111. 11468 112. 11473 113. 11481 114. 11483 115. 11495 116. 11496 117. 11497 118. 11502 119. 11504 120. 11507 121. 11514 122. 11541 123. 11557 124. 11572 125. 11597 126. 11610 127. 11620 128. 11633 129. 11635 130. 11636 131. 11650 132. 11682 133. 11684 134. 11689 135. 11691 136. 11697 137. 11699 138. 11712 139. 11743 140. 11752 141. 11754 142. 11760 143. 11775 144. 11776 145. 11780 146. 11783 147. 11784 148. 11796 149. 11814 150. 11821 151. 11827 152. 11829 153. 11830 154. 11833 155. 11836 156. 11837 157. 11850 158. 11857 159. 11863 160. 11879 161. 11888 162. 11890 163. 11903 164. 11908 165. 11918 166. 11923 167. 11940 168. 11946 169. 11957 170. 11960 171. 11964 172. 11966 173. 11970 174. 11976 175. 11982 176. 12006 177. 12009 178. 12015 179. 12018 180. 12042 181. 12048 182. 12056 183. 12057 184. 12063 185. 12075 186. 12090 187. 12091 188. 12098 189. 12105 190. 12111 191. 12123 192. 12125 193. 12159 194. 12164 195. 12170 196. 12177 197. 12178 198. 12183 199. 12190 200. 12197 201. 12199 202. 12203 203. 12204 204. 12205 205. 12207 206. 12212 207. 12214 208. 12215 209. 12217 210. 12219 211. 12232 212. 12242 213. 12251 214. 12254 215. 12256 216. 12260 217. 12261 218. 12262 219. 12267 220. 12268 221. 12269 222. 12273 223. 12284 224. 12300 225. 12301 226. 12302 227. 12314 228. 12316 229. 12318 230. 12327 231. 12370 232. 12378 233. 12379 234. 12390 235. 12391 236. 12393 237. 12400 238. 12409 239. 12425 240. 12428 241. 12429 242. 12450 243. 12456 244. 12459 245. 12467 246. 12474 247. 12477 248. 12482 249. 12484 250. 12485 251. 12488 252. 12490 253. 12492 254. 12514 255. 12515 256. 12516 257. 12517 258. 12520 259. 12531 260. 12545 261. 12566 262. 12586 263. 12596 264. 12603 265. 12612 266. 12614 267. 12626 268. 12629 269. 12637 270. 12638 271. 12640 272. 12646 273. 12647 274. 12653 275. 12661 276. 12665 277. 12671 278. 12708 279. 12715 280. 12721 281. 12731 282. 12738 283. 12745 284. 12756 285. 12773 286. 12776 287. 12780 288. 12790 289. 12796 290. 12802 291. 12803 292. 12807 293. 12808 294. 12814 295. 12817 296. 12818 297. 12826 298. 12829 299. 12832 300. 12835 301. 12838 302. 12841 303. 12845 304. 12849 305. 12856 306. 12860 307. 12863 308. 12864 309. 12866 310. 12870 311. 12876 312. 12883 313. 12884 314. 12885 315. 12897 316. 12918 317. 12929 318. 12937 319. 12941 320. 12943 321. 12946 322. 12949 323. 12950 324. 12952 325. 12953 326. 12960 327. 12982 328. 13016 329. 13034 330. 13055 331. 13057 332. 13060 333. 13064 334. 13081 335. 13087 336. 13090 337. 13096 338. 13101 339. 13105 340. 13118 341. 13119 342. 13122 343. 13136 344. 13138 345. 13148 346. 13152 347. 13182 348. 13187 349. 13188 350. 13202 351. 13223 352. 13231 353. 13232 354. 13246 355. 13252 356. 13256 357. 13259 358. 13274 359. 13276 360. 13288 361. 13289 362. 13294 363. 13296 364. 13300 365. 13303 366. 13311 367. 13315 368. 13320 369. 13339 370. 13351 371. 13359 372. 13368 373. 13373 374. 13377 375. 13396 376. 13402 377. 13407 378. 13414 379. 13416 380. 13432 381. 13434 382. 13439 383. 13447 384. 13454 385. 13455 386. 13458 387. 13459 388. 13462 389. 13464 390. 13469 391. 13474 392. 13475 393. 13481 394. 13483 395. 13496 396. 13497 397. 13499 398. 13539 399. 13556 400. 13579 401. 13590 402. 13612 403. 13614 404. 13615 405. 13627 406. 13629 407. 13634 408. 13635 409. 13648 410. 13653 411. 13655 412. 13659 413. 13662 414. 13685 415. 13736 416. 13747 417. 13773 418. 13787 419. 13790 420. 13845 421. 13849 422. 13851 423. 13859 424. 13860 425. 13872 426. 13888 427. 13900 428. 13905 429. 13918 430. 13922 431. 13934 432. 13937 433. 13938 434. 13974 435. 13977 436. 13987 437. 13989 438. 13991 439. 13999 440. 14011 441. 14017 442. 14026 443. 14027 444. 14029 445. 14045 446. 14070 447. 14071 448. 14092 449. 14098 450. 14107 451. 14120 452. 14124 453. 14128 454. 14137 455. 14147 456. 14148 457. 14169 458. 14172 459. 14174 460. 14185 461. 14195 462. 14207 463. 14211 464. 14219 465. 14220 466. 14228 467. 14230 468. 14242 469. 14248 470. 14266 471. 14267 472. 14284 473. 14302 474. 14310 475. 14324 476. 14328 477. 14330 478. 14331 479. 14348 480. 14359 481. 14364 482. 14395 483. 14400 484. 14418 485. 14423 486. 14438 487. 14449 488. 14473 489. 14509 490. 14515 491. 14520 492. 14528 493. 14531 494. 14566 495. 14571 496. 14573 497. 14575 498. 14578 499. 14589 500. 14607 501. 14610 502. 14671 503. 14672 504. 14677 505. 14678 506. 14680 507. 14682 508. 14684 509. 14693 510. 14698 511. 14702 512. 14704 513. 14714 514. 14719 515. 14720 516. 14730 517. 14740 518. 14744 519. 14759 520. 14762 521. 14786 522. 14789 523. 14792 524. 14801 525. 14805 526. 14820 527. 14822 528. 14828 529. 14831 530. 14836 531. 14838 532. 14839 533. 14840 534. 14845 535. 14850 536. 14855 537. 14874 538. 14879 539. 14889 540. 14897 541. 14901 542. 14925 543. 14926 544. 14930 545. 14933 546. 14939 547. 14940 548. 14954 549. 14957 550. 14960 551. 14965 552. 14980 553. 14984 554. 14989 555. 14994 556. 14997 557. 15044 558. 15045 559. 15046 560. 15056 561. 15059 562. 15062 563. 15065 564. 15066 565. 15068 566. 15074 567. 15092 568. 15099 569. 15117 570. 15144 571. 15156 572. 15162 573. 15169 574. 15175 575. 15176 576. 15192 577. 15211 578. 15220 579. 15231 580. 15248 581. 15287 582. 15291 583. 15315 584. 15326 585. 15327 586. 15332 587. 15335 588. 15341 589. 15343 590. 15363 591. 15372 592. 15392 593. 15399 594. 15407 595. 15413 596. 15414 597. 15416 598. 15423 599. 15424 600. 15426 601. 15428 602. 15433 603. 15440 604. 15442 605. 15445 606. 15447 607. 15449 608. 15452 609. 15454 610. 15460 611. 15461 612. 15492 613. 15499 614. 15504 615. 15505 616. 15506 617. 15507 618. 15509 619. 15514 620. 15515 621. 15519 622. 15529 623. 15535 624. 15542 625. 15545 626. 15546 627. 15550 628. 15555 629. 15562 630. 15576 631. 15582 632. 15622 633. 15627 634. 15629 635. 15630 636. 15642 637. 15648 638. 15654 639. 15656 640. 15658 641. 15659 642. 15672 643. 15674 644. 15675 645. 15680 646. 15685 647. 15688 648. 15689 649. 15696 650. 15699 651. 15717 652. 15724 653. 15730 654. 15742 655. 15752 656. 15754 657. 15780 658. 15799 659. 15813 660. 15814 661. 15822 662. 15861 663. 15878 664. 15887 665. 15888 666. 15894 667. 15909 668. 15912 669. 15914 670. 15915 671. 15916 672. 15917 673. 15941 674. 15944 675. 15950 676. 15960 677. 15967 678. 15968 679. 15969 680. 15980 681. 15981 682. 15982 683. 15988 684. 15989 685. 15993 686. 16000
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

Metadata

Bindings

0. 1.1
1. 5
2. 220
3. 10063
4. 10065
5. 10066
6. 10075
7. 10076
8. 10082
9. 10090
10. 10098
11. 10099
12. 10104
13. 10119
14. 10126
15. 10129
16. 10143
17. 10149
18. 10153
19. 10159
20. 10161
21. 10171
22. 10172
23. 10191
24. 10197
25. 10211
26. 10217
27. 10225
28. 10229
29. 10231
30. 10232
31. 10237
32. 10244
33. 10249
34. 10250
35. 10257
36. 10258
37. 10263
38. 10265
39. 10291
40. 10307
41. 10323
42. 10327
43. 10329
44. 10362
45. 10369
46. 10383
47. 10384
48. 10422
49. 10436
50. 10438
51. 10474
52. 10486
53. 10495
54. 10502
55. 10529
56. 10583
57. 10591
58. 10620
59. 10633
60. 10653
61. 10657
62. 10659
63. 10664
64. 10700
65. 10755
66. 10765
67. 10812
68. 10854
69. 10861
70. 10877
71. 10883
72. 10900
73. 10901
74. 10906
75. 10907
76. 10909
77. 10920
78. 10930
79. 10964
80. 10971
81. 10986
82. 10988
83. 11002
84. 11005
85. 11033
86. 11047
87. 11054
88. 11101
89. 11103
90. 11182
91. 11202
92. 11212
93. 11231
94. 11243
95. 11258
96. 11326
97. 11336
98. 11338
99. 11344
100. 11353
101. 11359
102. 11380
103. 11382
104. 11383
105. 11407
106. 11410
107. 11430
108. 11454
109. 11460
110. 11465
111. 11468
112. 11473
113. 11481
114. 11483
115. 11495
116. 11496
117. 11497
118. 11502
119. 11504
120. 11507
121. 11514
122. 11541
123. 11557
124. 11572
125. 11597
126. 11610
127. 11620
128. 11633
129. 11635
130. 11636
131. 11650
132. 11682
133. 11684
134. 11689
135. 11691
136. 11697
137. 11699
138. 11712
139. 11743
140. 11752
141. 11754
142. 11760
143. 11775
144. 11776
145. 11780
146. 11783
147. 11784
148. 11796
149. 11814
150. 11821
151. 11827
152. 11829
153. 11830
154. 11833
155. 11836
156. 11837
157. 11850
158. 11857
159. 11863
160. 11879
161. 11888
162. 11890
163. 11903
164. 11908
165. 11918
166. 11923
167. 11940
168. 11946
169. 11957
170. 11960
171. 11964
172. 11966
173. 11970
174. 11976
175. 11982
176. 12006
177. 12009
178. 12015
179. 12018
180. 12042
181. 12048
182. 12056
183. 12057
184. 12063
185. 12075
186. 12090
187. 12091
188. 12098
189. 12105
190. 12111
191. 12123
192. 12125
193. 12159
194. 12164
195. 12170
196. 12177
197. 12178
198. 12183
199. 12190
200. 12197
201. 12199
202. 12203
203. 12204
204. 12205
205. 12207
206. 12212
207. 12214
208. 12215
209. 12217
210. 12219
211. 12232
212. 12242
213. 12251
214. 12254
215. 12256
216. 12260
217. 12261
218. 12262
219. 12267
220. 12268
221. 12269
222. 12273
223. 12284
224. 12300
225. 12301
226. 12302
227. 12314
228. 12316
229. 12318
230. 12327
231. 12370
232. 12378
233. 12379
234. 12390
235. 12391
236. 12393
237. 12400
238. 12409
239. 12425
240. 12428
241. 12429
242. 12450
243. 12456
244. 12459
245. 12467
246. 12474
247. 12477
248. 12482
249. 12484
250. 12485
251. 12488
252. 12490
253. 12492
254. 12514
255. 12515
256. 12516
257. 12517
258. 12520
259. 12531
260. 12545
261. 12566
262. 12586
263. 12596
264. 12603
265. 12612
266. 12614
267. 12626
268. 12629
269. 12637
270. 12638
271. 12640
272. 12646
273. 12647
274. 12653
275. 12661
276. 12665
277. 12671
278. 12708
279. 12715
280. 12721
281. 12731
282. 12738
283. 12745
284. 12756
285. 12773
286. 12776
287. 12780
288. 12790
289. 12796
290. 12802
291. 12803
292. 12807
293. 12808
294. 12814
295. 12817
296. 12818
297. 12826
298. 12829
299. 12832
300. 12835
301. 12838
302. 12841
303. 12845
304. 12849
305. 12856
306. 12860
307. 12863
308. 12864
309. 12866
310. 12870
311. 12876
312. 12883
313. 12884
314. 12885
315. 12897
316. 12918
317. 12929
318. 12937
319. 12941
320. 12943
321. 12946
322. 12949
323. 12950
324. 12952
325. 12953
326. 12960
327. 12982
328. 13016
329. 13034
330. 13055
331. 13057
332. 13060
333. 13064
334. 13081
335. 13087
336. 13090
337. 13096
338. 13101
339. 13105
340. 13118
341. 13119
342. 13122
343. 13136
344. 13138
345. 13148
346. 13152
347. 13182
348. 13187
349. 13188
350. 13202
351. 13223
352. 13231
353. 13232
354. 13246
355. 13252
356. 13256
357. 13259
358. 13274
359. 13276
360. 13288
361. 13289
362. 13294
363. 13296
364. 13300
365. 13303
366. 13311
367. 13315
368. 13320
369. 13339
370. 13351
371. 13359
372. 13368
373. 13373
374. 13377
375. 13396
376. 13402
377. 13407
378. 13414
379. 13416
380. 13432
381. 13434
382. 13439
383. 13447
384. 13454
385. 13455
386. 13458
387. 13459
388. 13462
389. 13464
390. 13469
391. 13474
392. 13475
393. 13481
394. 13483
395. 13496
396. 13497
397. 13499
398. 13539
399. 13556
400. 13579
401. 13590
402. 13612
403. 13614
404. 13615
405. 13627
406. 13629
407. 13634
408. 13635
409. 13648
410. 13653
411. 13655
412. 13659
413. 13662
414. 13685
415. 13736
416. 13747
417. 13773
418. 13787
419. 13790
420. 13845
421. 13849
422. 13851
423. 13859
424. 13860
425. 13872
426. 13888
427. 13900
428. 13905
429. 13918
430. 13922
431. 13934
432. 13937
433. 13938
434. 13974
435. 13977
436. 13987
437. 13989
438. 13991
439. 13999
440. 14011
441. 14017
442. 14026
443. 14027
444. 14029
445. 14045
446. 14070
447. 14071
448. 14092
449. 14098
450. 14107
451. 14120
452. 14124
453. 14128
454. 14137
455. 14147
456. 14148
457. 14169
458. 14172
459. 14174
460. 14185
461. 14195
462. 14207
463. 14211
464. 14219
465. 14220
466. 14228
467. 14230
468. 14242
469. 14248
470. 14266
471. 14267
472. 14284
473. 14302
474. 14310
475. 14324
476. 14328
477. 14330
478. 14331
479. 14348
480. 14359
481. 14364
482. 14395
483. 14400
484. 14418
485. 14423
486. 14438
487. 14449
488. 14473
489. 14509
490. 14515
491. 14520
492. 14528
493. 14531
494. 14566
495. 14571
496. 14573
497. 14575
498. 14578
499. 14589
500. 14607
501. 14610
502. 14671
503. 14672
504. 14677
505. 14678
506. 14680
507. 14682
508. 14684
509. 14693
510. 14698
511. 14702
512. 14704
513. 14714
514. 14719
515. 14720
516. 14730
517. 14740
518. 14744
519. 14759
520. 14762
521. 14786
522. 14789
523. 14792
524. 14801
525. 14805
526. 14820
527. 14822
528. 14828
529. 14831
530. 14836
531. 14838
532. 14839
533. 14840
534. 14845
535. 14850
536. 14855
537. 14874
538. 14879
539. 14889
540. 14897
541. 14901
542. 14925
543. 14926
544. 14930
545. 14933
546. 14939
547. 14940
548. 14954
549. 14957
550. 14960
551. 14965
552. 14980
553. 14984
554. 14989
555. 14994
556. 14997
557. 15044
558. 15045
559. 15046
560. 15056
561. 15059
562. 15062
563. 15065
564. 15066
565. 15068
566. 15074
567. 15092
568. 15099
569. 15117
570. 15144
571. 15156
572. 15162
573. 15169
574. 15175
575. 15176
576. 15192
577. 15211
578. 15220
579. 15231
580. 15248
581. 15287
582. 15291
583. 15315
584. 15326
585. 15327
586. 15332
587. 15335
588. 15341
589. 15343
590. 15363
591. 15372
592. 15392
593. 15399
594. 15407
595. 15413
596. 15414
597. 15416
598. 15423
599. 15424
600. 15426
601. 15428
602. 15433
603. 15440
604. 15442
605. 15445
606. 15447
607. 15449
608. 15452
609. 15454
610. 15460
611. 15461
612. 15492
613. 15499
614. 15504
615. 15505
616. 15506
617. 15507
618. 15509
619. 15514
620. 15515
621. 15519
622. 15529
623. 15535
624. 15542
625. 15545
626. 15546
627. 15550
628. 15555
629. 15562
630. 15576
631. 15582
632. 15622
633. 15627
634. 15629
635. 15630
636. 15642
637. 15648
638. 15654
639. 15656
640. 15658
641. 15659
642. 15672
643. 15674
644. 15675
645. 15680
646. 15685
647. 15688
648. 15689
649. 15696
650. 15699
651. 15717
652. 15724
653. 15730
654. 15742
655. 15752
656. 15754
657. 15780
658. 15799
659. 15813
660. 15814
661. 15822
662. 15861
663. 15878
664. 15887
665. 15888
666. 15894
667. 15909
668. 15912
669. 15914
670. 15915
671. 15916
672. 15917
673. 15941
674. 15944
675. 15950
676. 15960
677. 15967
678. 15968
679. 15969
680. 15980
681. 15981
682. 15982
683. 15988
684. 15989
685. 15993
686. 16000

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 (10063, 10065, 10066, 10075, 10076, 10082, 10090, 10098, 10099, 10104, 10119, 10126, 10129, 10143, 10149, 10153, 10159, 10161, 10171, 10172, 10191, 10197, 10211, 10217, 10225, 10229, 10231, 10232, 10237, 10244, 10249, 10250, 10257, 10258, 10263, 10265, 10291, 10307, 10323, 10327, 10329, 10362, 10369, 10383, 10384, 10422, 10436, 10438, 10474, 10486, 10495, 10502, 10529, 10583, 10591, 10620, 10633, 10653, 10657, 10659, 10664, 10700, 10755, 10765, 10812, 10854, 10861, 10877, 10883, 10900, 10901, 10906, 10907, 10909, 10920, 10930, 10964, 10971, 10986, 10988, 11002, 11005, 11033, 11047, 11054, 11101, 11103, 11182, 11202, 11212, 11231, 11243, 11258, 11326, 11336, 11338, 11344, 11353, 11359, 11380, 11382, 11383, 11407, 11410, 11430, 11454, 11460, 11465, 11468, 11473, 11481, 11483, 11495, 11496, 11497, 11502, 11504, 11507, 11514, 11541, 11557, 11572, 11597, 11610, 11620, 11633, 11635, 11636, 11650, 11682, 11684, 11689, 11691, 11697, 11699, 11712, 11743, 11752, 11754, 11760, 11775, 11776, 11780, 11783, 11784, 11796, 11814, 11821, 11827, 11829, 11830, 11833, 11836, 11837, 11850, 11857, 11863, 11879, 11888, 11890, 11903, 11908, 11918, 11923, 11940, 11946, 11957, 11960, 11964, 11966, 11970, 11976, 11982, 12006, 12009, 12015, 12018, 12042, 12048, 12056, 12057, 12063, 12075, 12090, 12091, 12098, 12105, 12111, 12123, 12125, 12159, 12164, 12170, 12177, 12178, 12183, 12190, 12197, 12199, 12203, 12204, 12205, 12207, 12212, 12214, 12215, 12217, 12219, 12232, 12242, 12251, 12254, 12256, 12260, 12261, 12262, 12267, 12268, 12269, 12273, 12284, 12300, 12301, 12302, 12314, 12316, 12318, 12327, 12370, 12378, 12379, 12390, 12391, 12393, 12400, 12409, 12425, 12428, 12429, 12450, 12456, 12459, 12467, 12474, 12477, 12482, 12484, 12485, 12488, 12490, 12492, 12514, 12515, 12516, 12517, 12520, 12531, 12545, 12566, 12586, 12596, 12603, 12612, 12614, 12626, 12629, 12637, 12638, 12640, 12646, 12647, 12653, 12661, 12665, 12671, 12708, 12715, 12721, 12731, 12738, 12745, 12756, 12773, 12776, 12780, 12790, 12796, 12802, 12803, 12807, 12808, 12814, 12817, 12818, 12826, 12829, 12832, 12835, 12838, 12841, 12845, 12849, 12856, 12860, 12863, 12864, 12866, 12870, 12876, 12883, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12943, 12946, 12949, 12950, 12952, 12953, 12960, 12982, 13016, 13034, 13055, 13057, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13105, 13118, 13119, 13122, 13136, 13138, 13148, 13152, 13182, 13187, 13188, 13202, 13223, 13231, 13232, 13246, 13252, 13256, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13311, 13315, 13320, 13339, 13351, 13359, 13368, 13373, 13377, 13396, 13402, 13407, 13414, 13416, 13432, 13434, 13439, 13447, 13454, 13455, 13458, 13459, 13462, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13499, 13539, 13556, 13579, 13590, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13648, 13653, 13655, 13659, 13662, 13685, 13736, 13747, 13773, 13787, 13790, 13845, 13849, 13851, 13859, 13860, 13872, 13888, 13900, 13905, 13918, 13922, 13934, 13937, 13938, 13974, 13977, 13987, 13989, 13991, 13999, 14011, 14017, 14026, 14027, 14029, 14045, 14070, 14071, 14092, 14098, 14107, 14120, 14124, 14128, 14137, 14147, 14148, 14169, 14172, 14174, 14185, 14195, 14207, 14211, 14219, 14220, 14228, 14230, 14242, 14248, 14266, 14267, 14284, 14302, 14310, 14324, 14328, 14330, 14331, 14348, 14359, 14364, 14395, 14400, 14418, 14423, 14438, 14449, 14473, 14509, 14515, 14520, 14528, 14531, 14566, 14571, 14573, 14575, 14578, 14589, 14607, 14610, 14671, 14672, 14677, 14678, 14680, 14682, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14740, 14744, 14759, 14762, 14786, 14789, 14792, 14801, 14805, 14820, 14822, 14828, 14831, 14836, 14838, 14839, 14840, 14845, 14850, 14855, 14874, 14879, 14889, 14897, 14901, 14925, 14926, 14930, 14933, 14939, 14940, 14954, 14957, 14960, 14965, 14980, 14984, 14989, 14994, 14997, 15044, 15045, 15046, 15056, 15059, 15062, 15065, 15066, 15068, 15074, 15092, 15099, 15117, 15144, 15156, 15162, 15169, 15175, 15176, 15192, 15211, 15220, 15231, 15248, 15287, 15291, 15315, 15326, 15327, 15332, 15335, 15341, 15343, 15363, 15372, 15392, 15399, 15407, 15413, 15414, 15416, 15423, 15424, 15426, 15428, 15433, 15440, 15442, 15445, 15447, 15449, 15452, 15454, 15460, 15461, 15492, 15499, 15504, 15505, 15506, 15507, 15509, 15514, 15515, 15519, 15529, 15535, 15542, 15545, 15546, 15550, 15555, 15562, 15576, 15582, 15622, 15627, 15629, 15630, 15642, 15648, 15654, 15656, 15658, 15659, 15672, 15674, 15675, 15680, 15685, 15688, 15689, 15696, 15699, 15717, 15724, 15730, 15742, 15752, 15754, 15780, 15799, 15813, 15814, 15822, 15861, 15878, 15887, 15888, 15894, 15909, 15912, 15914, 15915, 15916, 15917, 15941, 15944, 15950, 15960, 15967, 15968, 15969, 15980, 15981, 15982, 15988, 15989, 15993, 16000)

7.71ms/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 (10063, 10065, 10066, 10075, 10076, 10082, 10090, 10098, 10099, 10104, 10119, 10126, 10129, 10143, 10149, 10153, 10159, 10161, 10171, 10172, 10191, 10197, 10211, 10217, 10225, 10229, 10231, 10232, 10237, 10244, 10249, 10250, 10257, 10258, 10263, 10265, 10291, 10307, 10323, 10327, 10329, 10362, 10369, 10383, 10384, 10422, 10436, 10438, 10474, 10486, 10495, 10502, 10529, 10583, 10591, 10620, 10633, 10653, 10657, 10659, 10664, 10700, 10755, 10765, 10812, 10854, 10861, 10877, 10883, 10900, 10901, 10906, 10907, 10909, 10920, 10930, 10964, 10971, 10986, 10988, 11002, 11005, 11033, 11047, 11054, 11101, 11103, 11182, 11202, 11212, 11231, 11243, 11258, 11326, 11336, 11338, 11344, 11353, 11359, 11380, 11382, 11383, 11407, 11410, 11430, 11454, 11460, 11465, 11468, 11473, 11481, 11483, 11495, 11496, 11497, 11502, 11504, 11507, 11514, 11541, 11557, 11572, 11597, 11610, 11620, 11633, 11635, 11636, 11650, 11682, 11684, 11689, 11691, 11697, 11699, 11712, 11743, 11752, 11754, 11760, 11775, 11776, 11780, 11783, 11784, 11796, 11814, 11821, 11827, 11829, 11830, 11833, 11836, 11837, 11850, 11857, 11863, 11879, 11888, 11890, 11903, 11908, 11918, 11923, 11940, 11946, 11957, 11960, 11964, 11966, 11970, 11976, 11982, 12006, 12009, 12015, 12018, 12042, 12048, 12056, 12057, 12063, 12075, 12090, 12091, 12098, 12105, 12111, 12123, 12125, 12159, 12164, 12170, 12177, 12178, 12183, 12190, 12197, 12199, 12203, 12204, 12205, 12207, 12212, 12214, 12215, 12217, 12219, 12232, 12242, 12251, 12254, 12256, 12260, 12261, 12262, 12267, 12268, 12269, 12273, 12284, 12300, 12301, 12302, 12314, 12316, 12318, 12327, 12370, 12378, 12379, 12390, 12391, 12393, 12400, 12409, 12425, 12428, 12429, 12450, 12456, 12459, 12467, 12474, 12477, 12482, 12484, 12485, 12488, 12490, 12492, 12514, 12515, 12516, 12517, 12520, 12531, 12545, 12566, 12586, 12596, 12603, 12612, 12614, 12626, 12629, 12637, 12638, 12640, 12646, 12647, 12653, 12661, 12665, 12671, 12708, 12715, 12721, 12731, 12738, 12745, 12756, 12773, 12776, 12780, 12790, 12796, 12802, 12803, 12807, 12808, 12814, 12817, 12818, 12826, 12829, 12832, 12835, 12838, 12841, 12845, 12849, 12856, 12860, 12863, 12864, 12866, 12870, 12876, 12883, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12943, 12946, 12949, 12950, 12952, 12953, 12960, 12982, 13016, 13034, 13055, 13057, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13105, 13118, 13119, 13122, 13136, 13138, 13148, 13152, 13182, 13187, 13188, 13202, 13223, 13231, 13232, 13246, 13252, 13256, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13311, 13315, 13320, 13339, 13351, 13359, 13368, 13373, 13377, 13396, 13402, 13407, 13414, 13416, 13432, 13434, 13439, 13447, 13454, 13455, 13458, 13459, 13462, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13499, 13539, 13556, 13579, 13590, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13648, 13653, 13655, 13659, 13662, 13685, 13736, 13747, 13773, 13787, 13790, 13845, 13849, 13851, 13859, 13860, 13872, 13888, 13900, 13905, 13918, 13922, 13934, 13937, 13938, 13974, 13977, 13987, 13989, 13991, 13999, 14011, 14017, 14026, 14027, 14029, 14045, 14070, 14071, 14092, 14098, 14107, 14120, 14124, 14128, 14137, 14147, 14148, 14169, 14172, 14174, 14185, 14195, 14207, 14211, 14219, 14220, 14228, 14230, 14242, 14248, 14266, 14267, 14284, 14302, 14310, 14324, 14328, 14330, 14331, 14348, 14359, 14364, 14395, 14400, 14418, 14423, 14438, 14449, 14473, 14509, 14515, 14520, 14528, 14531, 14566, 14571, 14573, 14575, 14578, 14589, 14607, 14610, 14671, 14672, 14677, 14678, 14680, 14682, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14740, 14744, 14759, 14762, 14786, 14789, 14792, 14801, 14805, 14820, 14822, 14828, 14831, 14836, 14838, 14839, 14840, 14845, 14850, 14855, 14874, 14879, 14889, 14897, 14901, 14925, 14926, 14930, 14933, 14939, 14940, 14954, 14957, 14960, 14965, 14980, 14984, 14989, 14994, 14997, 15044, 15045, 15046, 15056, 15059, 15062, 15065, 15066, 15068, 15074, 15092, 15099, 15117, 15144, 15156, 15162, 15169, 15175, 15176, 15192, 15211, 15220, 15231, 15248, 15287, 15291, 15315, 15326, 15327, 15332, 15335, 15341, 15343, 15363, 15372, 15392, 15399, 15407, 15413, 15414, 15416, 15423, 15424, 15426, 15428, 15433, 15440, 15442, 15445, 15447, 15449, 15452, 15454, 15460, 15461, 15492, 15499, 15504, 15505, 15506, 15507, 15509, 15514, 15515, 15519, 15529, 15535, 15542, 15545, 15546, 15550, 15555, 15562, 15576, 15582, 15622, 15627, 15629, 15630, 15642, 15648, 15654, 15656, 15658, 15659, 15672, 15674, 15675, 15680, 15685, 15688, 15689, 15696, 15699, 15717, 15724, 15730, 15742, 15752, 15754, 15780, 15799, 15813, 15814, 15822, 15861, 15878, 15887, 15888, 15894, 15909, 15912, 15914, 15915, 15916, 15917, 15941, 15944, 15950, 15960, 15967, 15968, 15969, 15980, 15981, 15982, 15988, 15989, 15993, 16000)

7.06ms/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 (10063, 10065, 10066, 10075, 10076, 10082, 10090, 10098, 10099, 10104, 10119, 10126, 10129, 10143, 10149, 10153, 10159, 10161, 10171, 10172, 10191, 10197, 10211, 10217, 10225, 10229, 10231, 10232, 10237, 10244, 10249, 10250, 10257, 10258, 10263, 10265, 10291, 10307, 10323, 10327, 10329, 10362, 10369, 10383, 10384, 10422, 10436, 10438, 10474, 10486, 10495, 10502, 10529, 10583, 10591, 10620, 10633, 10653, 10657, 10659, 10664, 10700, 10755, 10765, 10812, 10854, 10861, 10877, 10883, 10900, 10901, 10906, 10907, 10909, 10920, 10930, 10964, 10971, 10986, 10988, 11002, 11005, 11033, 11047, 11054, 11101, 11103, 11182, 11202, 11212, 11231, 11243, 11258, 11326, 11336, 11338, 11344, 11353, 11359, 11380, 11382, 11383, 11407, 11410, 11430, 11454, 11460, 11465, 11468, 11473, 11481, 11483, 11495, 11496, 11497, 11502, 11504, 11507, 11514, 11541, 11557, 11572, 11597, 11610, 11620, 11633, 11635, 11636, 11650, 11682, 11684, 11689, 11691, 11697, 11699, 11712, 11743, 11752, 11754, 11760, 11775, 11776, 11780, 11783, 11784, 11796, 11814, 11821, 11827, 11829, 11830, 11833, 11836, 11837, 11850, 11857, 11863, 11879, 11888, 11890, 11903, 11908, 11918, 11923, 11940, 11946, 11957, 11960, 11964, 11966, 11970, 11976, 11982, 12006, 12009, 12015, 12018, 12042, 12048, 12056, 12057, 12063, 12075, 12090, 12091, 12098, 12105, 12111, 12123, 12125, 12159, 12164, 12170, 12177, 12178, 12183, 12190, 12197, 12199, 12203, 12204, 12205, 12207, 12212, 12214, 12215, 12217, 12219, 12232, 12242, 12251, 12254, 12256, 12260, 12261, 12262, 12267, 12268, 12269, 12273, 12284, 12300, 12301, 12302, 12314, 12316, 12318, 12327, 12370, 12378, 12379, 12390, 12391, 12393, 12400, 12409, 12425, 12428, 12429, 12450, 12456, 12459, 12467, 12474, 12477, 12482, 12484, 12485, 12488, 12490, 12492, 12514, 12515, 12516, 12517, 12520, 12531, 12545, 12566, 12586, 12596, 12603, 12612, 12614, 12626, 12629, 12637, 12638, 12640, 12646, 12647, 12653, 12661, 12665, 12671, 12708, 12715, 12721, 12731, 12738, 12745, 12756, 12773, 12776, 12780, 12790, 12796, 12802, 12803, 12807, 12808, 12814, 12817, 12818, 12826, 12829, 12832, 12835, 12838, 12841, 12845, 12849, 12856, 12860, 12863, 12864, 12866, 12870, 12876, 12883, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12943, 12946, 12949, 12950, 12952, 12953, 12960, 12982, 13016, 13034, 13055, 13057, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13105, 13118, 13119, 13122, 13136, 13138, 13148, 13152, 13182, 13187, 13188, 13202, 13223, 13231, 13232, 13246, 13252, 13256, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13311, 13315, 13320, 13339, 13351, 13359, 13368, 13373, 13377, 13396, 13402, 13407, 13414, 13416, 13432, 13434, 13439, 13447, 13454, 13455, 13458, 13459, 13462, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13499, 13539, 13556, 13579, 13590, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13648, 13653, 13655, 13659, 13662, 13685, 13736, 13747, 13773, 13787, 13790, 13845, 13849, 13851, 13859, 13860, 13872, 13888, 13900, 13905, 13918, 13922, 13934, 13937, 13938, 13974, 13977, 13987, 13989, 13991, 13999, 14011, 14017, 14026, 14027, 14029, 14045, 14070, 14071, 14092, 14098, 14107, 14120, 14124, 14128, 14137, 14147, 14148, 14169, 14172, 14174, 14185, 14195, 14207, 14211, 14219, 14220, 14228, 14230, 14242, 14248, 14266, 14267, 14284, 14302, 14310, 14324, 14328, 14330, 14331, 14348, 14359, 14364, 14395, 14400, 14418, 14423, 14438, 14449, 14473, 14509, 14515, 14520, 14528, 14531, 14566, 14571, 14573, 14575, 14578, 14589, 14607, 14610, 14671, 14672, 14677, 14678, 14680, 14682, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14740, 14744, 14759, 14762, 14786, 14789, 14792, 14801, 14805, 14820, 14822, 14828, 14831, 14836, 14838, 14839, 14840, 14845, 14850, 14855, 14874, 14879, 14889, 14897, 14901, 14925, 14926, 14930, 14933, 14939, 14940, 14954, 14957, 14960, 14965, 14980, 14984, 14989, 14994, 14997, 15044, 15045, 15046, 15056, 15059, 15062, 15065, 15066, 15068, 15074, 15092, 15099, 15117, 15144, 15156, 15162, 15169, 15175, 15176, 15192, 15211, 15220, 15231, 15248, 15287, 15291, 15315, 15326, 15327, 15332, 15335, 15341, 15343, 15363, 15372, 15392, 15399, 15407, 15413, 15414, 15416, 15423, 15424, 15426, 15428, 15433, 15440, 15442, 15445, 15447, 15449, 15452, 15454, 15460, 15461, 15492, 15499, 15504, 15505, 15506, 15507, 15509, 15514, 15515, 15519, 15529, 15535, 15542, 15545, 15546, 15550, 15555, 15562, 15576, 15582, 15622, 15627, 15629, 15630, 15642, 15648, 15654, 15656, 15658, 15659, 15672, 15674, 15675, 15680, 15685, 15688, 15689, 15696, 15699, 15717, 15724, 15730, 15742, 15752, 15754, 15780, 15799, 15813, 15814, 15822, 15861, 15878, 15887, 15888, 15894, 15909, 15912, 15914, 15915, 15916, 15917, 15941, 15944, 15950, 15960, 15967, 15968, 15969, 15980, 15981, 15982, 15988, 15989, 15993, 16000) and `start_time` > '2025-07-16 02:35:35' and `start_time` <= '2025-07-23 02:35:35' order by `start_time` asc

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

Metadata
Bindings	0. Declined 1. Cancelled 2. 2025-07-16 02:35:35 3. 2025-07-23 02:35:35
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\LessonSchedule: 238
App\Models\AccountAttachment: 322
App\Models\LessonSubjects: 1495
App\Models\Account: 1370

_token: dUqz3WAJTbvE7RDe733IzkMsEfYPIiYj8hDwlAa7
_previous: array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/amr-miqdadi-1027" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/find-online-tutor/amr-miqdadi-1027

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/amr-miqdadi-1027"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/find-online-tutor/amr-miqdadi-1027"
  "REMOTE_PORT" => "45765"
  "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.124"
  "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" => "176038-470-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" => "176038-470-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" => 1752633334.9891
  "REQUEST_TIME" => 1752633334
]

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, 16 Jul 2025 02:35:35 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii96S3dBeTF6cGI1UGt6enc5dVR5VHc9PSIsInZhbHVlIjoibjEwWXpiUWVleU94NnUvZThjSmkyanZKTnp4TmZ3ZkxRZ00rMU5GcERMY0dTeG1kWnRlUmMvYUszeE9WRWp3L2hTMEYxa3NmMnFhL0ZsdzV2b3l1ZzdTYm5qZHNBUU42bXc3TEZLaTg5MjNlU0g5R1hyUEQxdjYwbnE0QzlGM3QiLCJtYWMiOiIyMWZkMjE0NjEzMTE4OTdiMGY1NTZkNTI0YmYxMThkNmQ5ZDNhZWFjMDRiNmJhZjExMjY0ODIwNTVlNTk2NzYyIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 02:35:35 GMT; Max-Age=31536000; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ii96S3dBeTF6cGI1UGt6enc5dVR5VHc9PSIsInZhbHVlIjoibjEwWXpiUWVleU94NnUvZThjSmkyanZKTnp4TmZ3ZkxRZ00rMU5GcERMY0dTeG1kWnRlUmMvYUszeE9WRWp3L2hTMEYxa ▶"
    1 => "lrnkey_session=eyJpdiI6Im8zVjNlMG1SVzZYZlpFaHRBRzFaUmc9PSIsInZhbHVlIjoiN1FWdmIzQXNVeDd0c09BOU9sTWQrZndrSmhVUGF3SHdwYzR2WWgzV2VmK0JRTVNlcUM5cDY5eVhsVVc4dG9STTEweW1VQ2JKOTlEU3hPcFczVkR1RWtyQkN5bFZ2U0tvWTl5K0tpaXQwNVVKNlFMeUxpbjF6MlRBVjdDem5QbC8iLCJtYWMiOiIxYWQzNTFjYzQxNzY3NmM2YWRiZmYwZDc5YjBjZjRhNzA1ZTcwNWM0ZmUzMzY0OWJhOGVkMzVlNGNmNDliZWM2IiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 02:35:35 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀lrnkey_session=eyJpdiI6Im8zVjNlMG1SVzZYZlpFaHRBRzFaUmc9PSIsInZhbHVlIjoiN1FWdmIzQXNVeDd0c09BOU9sTWQrZndrSmhVUGF3SHdwYzR2WWgzV2VmK0JRTVNlcUM5cDY5eVhsVVc4dG9STTEwe ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii96S3dBeTF6cGI1UGt6enc5dVR5VHc9PSIsInZhbHVlIjoibjEwWXpiUWVleU94NnUvZThjSmkyanZKTnp4TmZ3ZkxRZ00rMU5GcERMY0dTeG1kWnRlUmMvYUszeE9WRWp3L2hTMEYxa3NmMnFhL0ZsdzV2b3l1ZzdTYm5qZHNBUU42bXc3TEZLaTg5MjNlU0g5R1hyUEQxdjYwbnE0QzlGM3QiLCJtYWMiOiIyMWZkMjE0NjEzMTE4OTdiMGY1NTZkNTI0YmYxMThkNmQ5ZDNhZWFjMDRiNmJhZjExMjY0ODIwNTVlNTk2NzYyIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 02:35:35 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ii96S3dBeTF6cGI1UGt6enc5dVR5VHc9PSIsInZhbHVlIjoibjEwWXpiUWVleU94NnUvZThjSmkyanZKTnp4TmZ3ZkxRZ00rMU5GcERMY0dTeG1kWnRlUmMvYUszeE9WRWp3L2hTMEYxa ▶"
    1 => "lrnkey_session=eyJpdiI6Im8zVjNlMG1SVzZYZlpFaHRBRzFaUmc9PSIsInZhbHVlIjoiN1FWdmIzQXNVeDd0c09BOU9sTWQrZndrSmhVUGF3SHdwYzR2WWgzV2VmK0JRTVNlcUM5cDY5eVhsVVc4dG9STTEweW1VQ2JKOTlEU3hPcFczVkR1RWtyQkN5bFZ2U0tvWTl5K0tpaXQwNVVKNlFMeUxpbjF6MlRBVjdDem5QbC8iLCJtYWMiOiIxYWQzNTFjYzQxNzY3NmM2YWRiZmYwZDc5YjBjZjRhNzA1ZTcwNWM0ZmUzMzY0OWJhOGVkMzVlNGNmNDliZWM2IiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 02:35:35 GMT; path=/; httponly ◀lrnkey_session=eyJpdiI6Im8zVjNlMG1SVzZYZlpFaHRBRzFaUmc9PSIsInZhbHVlIjoiN1FWdmIzQXNVeDd0c09BOU9sTWQrZndrSmhVUGF3SHdwYzR2WWgzV2VmK0JRTVNlcUM5cDY5eVhsVVc4dG9STTEwe ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "dUqz3WAJTbvE7RDe733IzkMsEfYPIiYj8hDwlAa7"
  "_previous" => array:1 [▶
    "url" => "https://test.lrnkey.com/find-online-tutor/amr-miqdadi-1027"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

From 2003	To 2004	Employer DPK Consulting , USAID Funded Projects, Palestine	Position IT coordinator
From 2004	To 2008	Employer DPK Consulting, USAID Funded Projects, Jordan	Position Team Leader
From 2008	To 2010	Employer DPK Consulting , USAID Funded Projects, Palestine	Position IT Specialist
From 2010	To 2012	Employer Freelancer	Position Grants and project management
From 2012	To 2019	Employer Tetra Tech, State Dept. Funded Project	Position IT/Procurement component Manager
From 2019	To 2020	Employer Freelancer	Position Project Management & Leadership coach and mentor

From 1997	To 2002	Institution Near East University, Turkiye	Degree BA in Computer Engineering
From 2010	To 2010	Institution PMI	Degree PMP
From 2014	To 2014	Institution AAPM ® American Academy of Project Management	Degree Certified International Project Manager (CIPM)
From 2017	To 2017	Institution The University of Queensland, Australia	Degree MicroMasters In Leadership in Global Development
From 2019	To 2019	Institution University of Maryland	Degree Agile Leadership Principles
From 2020	To 2020	Institution PM4NGOs	Degree Program Management
From 2020	To 2020	Institution Philanthropy University	Degree Planning for Monitoring and Evaluation

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

Amr Miqdadi

Photography, Project Management, PMP

English, العربية

Photography, Project Management, PMP

English, العربية

1 x Application (92.97%)	409.73ms
1 x Booting (6.98%)	30.77ms

Contact Amr Miqdadi

Amr Miqdadi

Photography, Project Management, PMP

English, العربية

Photography, Project Management, PMP

English, العربية

July 2025

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