Flag

Contact Vera Kozlova

Inquire about availability or tell the instructor about yourself, your requirements and learning goals.

$33.00/h
Russian Federation
online

Vera Kozlova Verified

My students speak 60% of the time of the lesson

 5.0 

skills:

English, English Conversation Practice

language(s)

English, Русский

skills:

English, English Conversation Practice

language(s)

English, Русский

$33.00/hour
Response time The tutor doesn't have available time slots for the next 24 hours.
About Vera
My lesson is a dialog, not a lecture. I listen to you attentively and give detailed feedback. I regularly talk to Americans, so I use "real" language.
Show more Arrow down Show less Arrow up
Employment Education
From
Feb 2021
To
Nov 2021
Employer
Skyeng
Position
English teacher
From
Jul 2015
To
Jun 2017
Institution
English First
Degree
Certificate of graduation with the advanced level
$33.00/hour
Response time The tutor doesn't have available time slots for the next 24 hours.
Timezone info Based on your time zone Full Schedule Show full schedule
Schedule
Please select your time slots

May 2025

Thu15 MayFri16 MaySat17 MaySun18 MayMon19 MayTue20 MayWed21 May
00:00
01:00
02:00
03:00
04:00
05:00
06:00
07:00
08:00
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00

Free time
Booked
Booked by you
Unavailable
Schedule
May 2025
  •   Thu Fri Sat Sun Mon Tue Wed
    6:00 - 12:00
    12:00 - 18:00
    18:00 - 24:00
    24:00 - 06:00
  • Timezone info Based on your time zone Full Schedule Arrow right
    Choose the time for your first lesson .
    Timezone info Based on your time zone
    Didn't find the time you were looking for? the teacher directly to book a class out of this schedule.
    Reviews
    5.0
    4 reviews
    Flag
    Amr Mostafa
    17 Jan 2021
    5.0
    Show more Show more arrow Show less Show less arrow
    Flag
    Kristina Bratanova
    24 Jan 2021
    5.0
    I really liked our first meeting with Vera. Vera presents the material in a very interesting and high-quality manner, corrects mistakes, offers options and helps to navigate. Our lesson was structured and cool. Vera seemed to me to be a very empathetic teacher who absolutely understands the student’s goals and helps them to realize them. I want to continue our meetings :)
    Show more Show more arrow Show less Show less arrow
    Flag
    Marina Poghosyan
    25 Jan 2021
    5.0
    Vera is an English teacher anybody would dream to have. Patient, calm and professional. She managed to explain to me the topic I was struggling with for years, she managed to explain in 30 minutes.
    Show more Show more arrow Show less Show less arrow
    Flag
    Tatiana Sirotkina
    26 Jan 2021
    5.0
    A very pleasant companion and teacher. In one hour we managed to discuss several topics. Vera supplemented my vocabulary with several more common synonyms. At the end of the lesson, we practiced writtings.
    Show more Show more arrow Show less Show less arrow
    7.4.3PHP Version293msRequest Duration10MBMemory UsageGET {path}Route
      • Booting (38.42ms)
      • Application (255ms)
      • 1 x Application (86.78%)
        254.64ms
        1 x Booting (13.09%)
        38.42ms
        23 templates were rendered
        • redesign.pages.tutor.show (resources/views/redesign/pages/tutor/show.blade.php)7blade
          Params
          0
          coach
          1
          page_id
          2
          response_time
          3
          requiredToReview
          4
          auth_has_a_free_lesson
          5
          countOfLeLessonForNext24Hours
          6
          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
        • redesign.pages.tutor.fullcalendar (resources/views/redesign/pages/tutor/fullcalendar.blade.php)36blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          timeslots
        • redesign.pages.popups.fullcalendar.request-to-open-time-popup (resources/views/redesign/pages/popups/fullcalendar/request-to-open-time-popup.blade.php)36blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          timeslots
        • redesign.pages.tutor.small-calendar (resources/views/redesign/pages/tutor/small-calendar.blade.php)36blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          coach_schedule
        • components.star (resources/views/components/star.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          rating
          36
          singleStar
        • components.star (resources/views/components/star.blade.php)38blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          rating
          37
          singleStar
        • components.star (resources/views/components/star.blade.php)38blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          rating
          37
          singleStar
        • components.star (resources/views/components/star.blade.php)38blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          rating
          37
          singleStar
        • components.star (resources/views/components/star.blade.php)38blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          rating
          37
          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)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • components.popups.base-modal (resources/views/components/popups/base-modal.blade.php)4blade
          Params
          0
          componentName
          1
          attributes
          2
          slot
          3
          __laravel_slots
        • redesign.layouts.app (resources/views/redesign/layouts/app.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.includes.js-service-attributes (resources/views/redesign/includes/js-service-attributes.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.includes.header (resources/views/redesign/includes/header.blade.php)38blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
          37
          notification_badges
        • redesign.pages.auth.login.login-popup (resources/views/redesign/pages/auth/login/login-popup.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.pages.popups.forgot-password (resources/views/redesign/pages/popups/forgot-password.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.pages.auth.registration.registration-popup (resources/views/redesign/pages/auth/registration/registration-popup.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.includes.footer (resources/views/redesign/includes/footer.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • redesign.pages.popups.loader (resources/views/redesign/pages/popups/loader.blade.php)37blade
          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
          image
          31
          idx
          32
          is_employment_empty
          33
          is_education_empty
          34
          emplayment
          35
          review
          36
          randomCoachByCategory
        • components.popups.recaptcha (resources/views/components/popups/recaptcha.blade.php)5blade
          Params
          0
          modalId
          1
          componentName
          2
          attributes
          3
          slot
          4
          __laravel_slots
        uri
        GET {path}
        middleware
        web, full.registered.user, redirect.old.urls.to.new
        controller
        App\Http\Controllers\LegacyController@index
        as
        legacy.
        namespace
        prefix
        where
        file
        app/Http/Controllers/LegacyController.php:12-15
        17 statements were executed, 2 of which were duplicated, 15 unique114ms
        • select * from `lesson_review_answers` where `review_id` = 63
          2.8ms/legacy/modules/Coaches.php:457lrnkey_stage
          Metadata
          Bindings
          • 0. 63
          Backtrace
          • 14. /legacy/modules/Coaches.php:457
          • 18. /app/Http/Controllers/LegacyController.php:14
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `lesson_review_answers` where `review_id` = 66
          580μs/legacy/modules/Coaches.php:457lrnkey_stage
          Metadata
          Bindings
          • 0. 66
          Backtrace
          • 14. /legacy/modules/Coaches.php:457
          • 18. /app/Http/Controllers/LegacyController.php:14
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `lesson_review_answers` where `review_id` = 68
          480μs/legacy/modules/Coaches.php:457lrnkey_stage
          Metadata
          Bindings
          • 0. 68
          Backtrace
          • 14. /legacy/modules/Coaches.php:457
          • 18. /app/Http/Controllers/LegacyController.php:14
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `lesson_review_answers` where `review_id` = 70
          500μs/legacy/modules/Coaches.php:457lrnkey_stage
          Metadata
          Bindings
          • 0. 70
          Backtrace
          • 14. /legacy/modules/Coaches.php:457
          • 18. /app/Http/Controllers/LegacyController.php:14
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `account_attachments` where `account_id` = 12826
          1.15ms/legacy/modules/Coaches.php:490lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 14. /legacy/modules/Coaches.php:490
          • 18. /app/Http/Controllers/LegacyController.php:14
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select TIMESTAMPDIFF(MINUTE,(SELECT MAX(last_modified) FROM message_thread_messages WHERE thread_id = message_thread_recipients.thread_id AND message_thread_messages.message_id = (select MAX(message_id) from message_messages_read where message_messages_read.read_status = 1 && message_messages_read.account_id = message_thread_recipients.account_id && message_messages_read.thread_id = message_thread_messages.thread_id ORDER BY message_messages_read.last_modified LIMIT 1) ), (select MAX(last_modified) from message_messages_read where message_messages_read.read_status = 1 && message_messages_read.thread_id = message_thread_recipients.thread_id && message_messages_read.account_id = message_thread_recipients.account_id ORDER BY message_messages_read.last_modified LIMIT 1)) AS diff_minutes from `message_thread_recipients` where `account_id` = 12826
          15.88ms/legacy/modules/Coaches.php:519lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 12. /legacy/modules/Coaches.php:519
          • 16. /app/Http/Controllers/LegacyController.php:14
          • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select exists(select * from `lesson_reviews` where `account_id` = 12826 and `reviewer_id` is null) as `exists`
          1.32ms/legacy/modules/Coaches.php:549lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 10. /legacy/modules/Coaches.php:549
          • 14. /app/Http/Controllers/LegacyController.php:14
          • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `accounts` where `accounts`.`account_id` = 12826 limit 1
          1.03ms/legacy/modules/Coaches.php:572lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 19. /legacy/modules/Coaches.php:572
          • 23. /app/Http/Controllers/LegacyController.php:14
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select `packages`.*, `coach_packages`.`coach_id` as `pivot_coach_id`, `coach_packages`.`package_id` as `pivot_package_id` from `packages` inner join `coach_packages` on `packages`.`id` = `coach_packages`.`package_id` where `coach_packages`.`coach_id` = 12826
          960μs/legacy/modules/Coaches.php:572lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 19. /legacy/modules/Coaches.php:572
          • 23. /app/Http/Controllers/LegacyController.php:14
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select * from `accounts` where `accounts`.`account_id` = 12826 limit 1
          870μs/legacy/modules/Coaches.php:574lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 19. /legacy/modules/Coaches.php:574
          • 23. /app/Http/Controllers/LegacyController.php:14
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select `packages`.*, `coach_packages`.`coach_id` as `pivot_coach_id`, `coach_packages`.`package_id` as `pivot_package_id` from `packages` inner join `coach_packages` on `packages`.`id` = `coach_packages`.`package_id` where `coach_packages`.`coach_id` = 12826 order by `lessons_count` desc limit 1
          1.17ms/legacy/modules/Coaches.php:574lrnkey_stage
          Metadata
          Bindings
          • 0. 12826
          Backtrace
          • 15. /legacy/modules/Coaches.php:574
          • 19. /app/Http/Controllers/LegacyController.php:14
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
        • select `subject_id` from `lesson_subjects` left join `lesson_categories` on `lesson_subjects`.`category_id` = `lesson_categories`.`category_id` where `subject_name` like '%Languages%' or `lesson_categories`.`category_name` like '%Languages%'
          3.05ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:356lrnkey_stage
          Metadata
          Bindings
          • 0. %Languages%
          • 1. %Languages%
          Backtrace
          • 13. /app/Http/DataProviders/Tutor/TutorDataProvider.php:356
          • 14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:269
          • 15. /app/Http/DataProviders/Tutor/TutorDataProvider.php:176
          • 16. /app/Http/DataProviders/Tutor/TutorDataProvider.php:111
          • 17. /legacy/modules/Coaches.php:583
        • 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) >= 0 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-05-14 16:39:50') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 and FIND_IN_SET(account_subjects.subject_id,'496,497,498,499,500,501,502,503,504,505,506,507,508,509,610,617,619,653,654,656,657,658,660,665,674,677,681,683,686,689,695,698,700,708,709,710') group by `accounts`.`account_id`
          44.64ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:568lrnkey_stage
          Metadata
          Bindings
          • 0. 5
          • 1. 0
          • 2. 220
          • 3. Active
          • 4. Pending
          • 5. 2025-05-14 16:39:50
          • 6. 1
          • 7. 496,497,498,499,500,501,502,503,504,505,506,507,508,509,610,617,619,653,654,656,657,658,660,665,674,677,681,683,686,689,695,698,700,708,709,710
          Backtrace
          • 13. /app/Http/DataProviders/Tutor/TutorDataProvider.php:568
          • 14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:359
          • 15. /app/Http/DataProviders/Tutor/TutorDataProvider.php:269
          • 16. /app/Http/DataProviders/Tutor/TutorDataProvider.php:176
          • 17. /app/Http/DataProviders/Tutor/TutorDataProvider.php:111
        • select `account_profiles`.*, `accounts`.`verified`, `accounts`.`available_for_video_call`, `accounts`.`is_online`, `accounts`.`order_by_admin`, `accounts`.`ordering`, `accounts`.`register_time`, `lesson_pricing`.`duration`, `lesson_pricing`.`currency`, (SELECT trial FROM lesson_pricing WHERE account_id = accounts.account_id && trial = 1 LIMIT 1) as free_trial, CONCAT(account_profiles.first_name, account_profiles.last_name) AS full_name, CONCAT(account_profiles.first_name, "-" ,account_profiles.last_name ,"-",account_profiles.profile_id) AS page, (Select status From account_attachments where account_id = accounts.account_id && status = 1 && (type = 1 || type = 5) LIMIT 1) as video_status, (SELECT count(classroom_id) FROM lesson_classrooms where coach_id = accounts.account_id && status = "Completed") as completed, (lesson_pricing.price * 1.1) as total_price, (SELECT SUM(subquery.total)/SUM(subquery.count) FROM ( SELECT SUM(rating) as total, COUNT(*) as count FROM lesson_reviews where account_id = accounts.account_id && rating is not null UNION ALL SELECT SUM(communication + preparing_lessons + understanding_needs + explains_subjects + customizes_lessons + teacher_experience) as total, COUNT(*) * 6 as count FROM lesson_classroom_reviews where reviewer_id = accounts.account_id ) AS subquery) as rating from `accounts` left join `account_profiles` on `account_profiles`.`account_id` = `accounts`.`account_id` inner join `lesson_pricing` on `lesson_pricing`.`account_id` = `accounts`.`account_id` and `lesson_pricing`.`price` is not null where (lesson_pricing.price * 1.1) between 0 and 220 and `accounts`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc
          24.42ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. 1.1
          • 1. 0
          • 2. 220
          • 3. 10076
          • 4. 10161
          • 5. 10197
          • 6. 10323
          • 7. 10502
          • 8. 10529
          • 9. 10591
          • 10. 10664
          • 11. 10812
          • 12. 10861
          • 13. 10901
          • 14. 10907
          • 15. 10909
          • 16. 10920
          • 17. 10971
          • 18. 10986
          • 19. 11212
          • 20. 11258
          • 21. 11380
          • 22. 11382
          • 23. 11407
          • 24. 11465
          • 25. 11481
          • 26. 11496
          • 27. 11497
          • 28. 11507
          • 29. 11514
          • 30. 11635
          • 31. 11830
          • 32. 11833
          • 33. 11836
          • 34. 11863
          • 35. 11879
          • 36. 11923
          • 37. 11957
          • 38. 11960
          • 39. 12111
          • 40. 12197
          • 41. 12215
          • 42. 12232
          • 43. 12242
          • 44. 12254
          • 45. 12268
          • 46. 12300
          • 47. 12400
          • 48. 12456
          • 49. 12459
          • 50. 12474
          • 51. 12490
          • 52. 12517
          • 53. 12531
          • 54. 12596
          • 55. 12612
          • 56. 12626
          • 57. 12629
          • 58. 12638
          • 59. 12640
          • 60. 12646
          • 61. 12653
          • 62. 12661
          • 63. 12665
          • 64. 12671
          • 65. 12708
          • 66. 12738
          • 67. 12745
          • 68. 12773
          • 69. 12780
          • 70. 12790
          • 71. 12814
          • 72. 12817
          • 73. 12818
          • 74. 12826
          • 75. 12832
          • 76. 12845
          • 77. 12863
          • 78. 12864
          • 79. 12866
          • 80. 12870
          • 81. 12876
          • 82. 12884
          • 83. 12885
          • 84. 12897
          • 85. 12918
          • 86. 12929
          • 87. 12937
          • 88. 12941
          • 89. 12946
          • 90. 12950
          • 91. 12952
          • 92. 12960
          • 93. 12982
          • 94. 13016
          • 95. 13034
          • 96. 13055
          • 97. 13060
          • 98. 13064
          • 99. 13081
          • 100. 13087
          • 101. 13090
          • 102. 13096
          • 103. 13101
          • 104. 13118
          • 105. 13119
          • 106. 13122
          • 107. 13136
          • 108. 13138
          • 109. 13148
          • 110. 13182
          • 111. 13188
          • 112. 13223
          • 113. 13231
          • 114. 13232
          • 115. 13246
          • 116. 13252
          • 117. 13259
          • 118. 13274
          • 119. 13276
          • 120. 13288
          • 121. 13289
          • 122. 13294
          • 123. 13296
          • 124. 13300
          • 125. 13303
          • 126. 13320
          • 127. 13339
          • 128. 13351
          • 129. 13368
          • 130. 13373
          • 131. 13377
          • 132. 13407
          • 133. 13414
          • 134. 13416
          • 135. 13434
          • 136. 13454
          • 137. 13464
          • 138. 13469
          • 139. 13474
          • 140. 13475
          • 141. 13481
          • 142. 13483
          • 143. 13496
          • 144. 13497
          • 145. 13612
          • 146. 13614
          • 147. 13615
          • 148. 13627
          • 149. 13629
          • 150. 13634
          • 151. 13635
          • 152. 13655
          • 153. 13662
          • 154. 13736
          • 155. 13787
          • 156. 13790
          • 157. 13845
          • 158. 13849
          • 159. 13851
          • 160. 13860
          • 161. 13974
          • 162. 13999
          • 163. 14011
          • 164. 14017
          • 165. 14092
          • 166. 14098
          • 167. 14124
          • 168. 14128
          • 169. 14211
          • 170. 14228
          • 171. 14248
          • 172. 14267
          • 173. 14302
          • 174. 14324
          • 175. 14330
          • 176. 14331
          • 177. 14395
          • 178. 14423
          • 179. 14438
          • 180. 14528
          • 181. 14571
          • 182. 14589
          • 183. 14610
          • 184. 14684
          • 185. 14693
          • 186. 14698
          • 187. 14702
          • 188. 14704
          • 189. 14714
          • 190. 14719
          • 191. 14720
          • 192. 14730
          • 193. 14744
          • 194. 14759
          • 195. 14792
          • 196. 14801
          • 197. 14820
          • 198. 14831
          • 199. 14839
          • 200. 14845
          • 201. 14850
          • 202. 14855
          • 203. 14901
          • 204. 14926
          • 205. 14930
          • 206. 14940
          • 207. 14954
          • 208. 14989
          • 209. 15045
          • 210. 15059
          • 211. 15092
          • 212. 15156
          • 213. 15162
          • 214. 15169
          • 215. 15220
          • 216. 15335
          • 217. 15341
          • 218. 15343
          • 219. 15372
          • 220. 15399
          • 221. 15414
          • 222. 15423
          • 223. 15426
          • 224. 15433
          • 225. 15440
          • 226. 15442
          • 227. 15449
          • 228. 15452
          • 229. 15454
          • 230. 15499
          • 231. 15542
          • 232. 15546
          • 233. 15550
          • 234. 15555
          • 235. 15576
          • 236. 15642
          • 237. 15648
          • 238. 15656
          • 239. 15658
          • 240. 15659
          • 241. 15674
          • 242. 15675
          • 243. 15685
          • 244. 15689
          • 245. 15696
          • 246. 15699
          • 247. 15724
          • 248. 15730
          • 249. 15752
          • 250. 15780
          • 251. 15861
          • 252. 15916
          Backtrace
          • 14. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115
          • 15. /legacy/modules/Coaches.php:583
          • 19. /app/Http/Controllers/LegacyController.php:14
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • select `lesson_subjects`.*, `account_subjects`.`account_id` as `pivot_account_id`, `account_subjects`.`subject_id` as `pivot_subject_id` from `lesson_subjects` inner join `account_subjects` on `lesson_subjects`.`subject_id` = `account_subjects`.`subject_id` where `account_subjects`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916)
          4.96ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Backtrace
          • 18. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115
          • 19. /legacy/modules/Coaches.php:583
          • 23. /app/Http/Controllers/LegacyController.php:14
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • select * from `account_attachments` where `account_attachments`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916)
          4.71ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Backtrace
          • 19. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115
          • 20. /legacy/modules/Coaches.php:583
          • 24. /app/Http/Controllers/LegacyController.php:14
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • select `lesson_schedule`.*, (SELECT COUNT(classroom_id) FROM lesson_classrooms INNER JOIN lesson_orders ON lesson_classrooms.order_id = lesson_orders.order_id && lesson_orders.status = 1 WHERE lesson_classrooms.coach_id = lesson_schedule.account_id && (lesson_classrooms.status != 'Declined' && lesson_classrooms.status != 'Cancelled') && lesson_classrooms.start_time = lesson_schedule.start_time) as booked from `lesson_schedule` where `lesson_schedule`.`account_id` in (10076, 10161, 10197, 10323, 10502, 10529, 10591, 10664, 10812, 10861, 10901, 10907, 10909, 10920, 10971, 10986, 11212, 11258, 11380, 11382, 11407, 11465, 11481, 11496, 11497, 11507, 11514, 11635, 11830, 11833, 11836, 11863, 11879, 11923, 11957, 11960, 12111, 12197, 12215, 12232, 12242, 12254, 12268, 12300, 12400, 12456, 12459, 12474, 12490, 12517, 12531, 12596, 12612, 12626, 12629, 12638, 12640, 12646, 12653, 12661, 12665, 12671, 12708, 12738, 12745, 12773, 12780, 12790, 12814, 12817, 12818, 12826, 12832, 12845, 12863, 12864, 12866, 12870, 12876, 12884, 12885, 12897, 12918, 12929, 12937, 12941, 12946, 12950, 12952, 12960, 12982, 13016, 13034, 13055, 13060, 13064, 13081, 13087, 13090, 13096, 13101, 13118, 13119, 13122, 13136, 13138, 13148, 13182, 13188, 13223, 13231, 13232, 13246, 13252, 13259, 13274, 13276, 13288, 13289, 13294, 13296, 13300, 13303, 13320, 13339, 13351, 13368, 13373, 13377, 13407, 13414, 13416, 13434, 13454, 13464, 13469, 13474, 13475, 13481, 13483, 13496, 13497, 13612, 13614, 13615, 13627, 13629, 13634, 13635, 13655, 13662, 13736, 13787, 13790, 13845, 13849, 13851, 13860, 13974, 13999, 14011, 14017, 14092, 14098, 14124, 14128, 14211, 14228, 14248, 14267, 14302, 14324, 14330, 14331, 14395, 14423, 14438, 14528, 14571, 14589, 14610, 14684, 14693, 14698, 14702, 14704, 14714, 14719, 14720, 14730, 14744, 14759, 14792, 14801, 14820, 14831, 14839, 14845, 14850, 14855, 14901, 14926, 14930, 14940, 14954, 14989, 15045, 15059, 15092, 15156, 15162, 15169, 15220, 15335, 15341, 15343, 15372, 15399, 15414, 15423, 15426, 15433, 15440, 15442, 15449, 15452, 15454, 15499, 15542, 15546, 15550, 15555, 15576, 15642, 15648, 15656, 15658, 15659, 15674, 15675, 15685, 15689, 15696, 15699, 15724, 15730, 15752, 15780, 15861, 15916) and `start_time` > '2025-05-15 16:39:50' and `start_time` <= '2025-05-22 16:39:50' order by `start_time` asc
          5.37ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. Declined
          • 1. Cancelled
          • 2. 2025-05-15 16:39:50
          • 3. 2025-05-22 16:39:50
          Backtrace
          • 19. /app/Http/DataProviders/Tutor/TutorDataProvider.php:115
          • 20. /legacy/modules/Coaches.php:583
          • 24. /app/Http/Controllers/LegacyController.php:14
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        App\Models\LessonSchedule
        40
        App\Models\LessonSubjects
        578
        App\Models\Account
        502
        App\Models\AccountAttachment
        164
            _token
            k9qmT1FjB2eFu9gNkvj5fBTFRmolqowE2GKzcUUE
            _previous
            array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/vera-kozlova-2923" ]
            _flash
            array:2 [ "old" => [] "new" => [] ]
            PHPDEBUGBAR_STACK_DATA
            []
            path_info
            /find-online-tutor/vera-kozlova-2923
            status_code
            200
            
            status_text
            OK
            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/vera-kozlova-2923" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/find-online-tutor/vera-kozlova-2923" "REMOTE_PORT" => "35325" "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" => "18.116.38.6" "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" => "3686438-2244-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" => "3686438-2244-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" => 1747327190.409 "REQUEST_TIME" => 1747327190 ]
            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 => "Thu, 15 May 2025 16:39:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFMcEpCRzVYVm9DRmJEbXphWmt2Z1E9PSIsInZhbHVlIjoiTlVNalc3UFdUMVloQUlXSldvdXh6NWNZUFRXUVNCVXo0V05MU1RZMFQ4cDB5VUhFZ3duSkFTa0k2YnZSbUQrTDR0MWFiU2pNenN1a2dOVFF1cHp1RmJqWUh2Nm5SL0FNd0tiVW5uSW9SR1N0WE44cWFDVmQyNks0aDUrV2JIQ0MiLCJtYWMiOiIxZWQwNzQwNjRmMzU2MmQxYjM4MGUyMzg3ZWU1MDlmNTY2NmJiMTVhNzRjMThhMDVjMzYzODQzOTk1MDc5ZTA4IiwidGFnIjoiIn0%3D; expires=Fri, 15-May-2026 16:39:50 GMT; Max-Age=31536000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6ImFMcEpCRzVYVm9DRmJEbXphWmt2Z1E9PSIsInZhbHVlIjoiTlVNalc3UFdUMVloQUlXSldvdXh6NWNZUFRXUVNCVXo0V05MU1RZMFQ4cDB5VUhFZ3duSkFTa0k2YnZSbUQrTDR0MWFiU" 1 => "lrnkey_session=eyJpdiI6IjRzK1MzTzZTRHBpTWV2cThIakFldXc9PSIsInZhbHVlIjoiN25TZ1JBQk5aajdQME05dHp2NHJUd1VTYW9jSmlOTkZDZU5ScHQxUlNBSExMdXk1RjlQZGZpY3p4ZEREREh3Z21tM2JBeGtGcCt4WENTMVlGblVpZ29LYmNlcWo4TGJLSjI3d0VwdUNPRnBqR3FBLzVVZlZZeG9lWWV3K0VZaTMiLCJtYWMiOiJlNWIzYzQzYzZiY2VjMjE5NDcwZmFhNGQ3ODMyZDA2OWIzNjQ1YmU3YTRjNWI2OTI4NDFjY2UxZjlhMTU0NTQ5IiwidGFnIjoiIn0%3D; expires=Fri, 15-May-2026 16:39:50 GMT; Max-Age=31536000; path=/; httponly; samesite=laxlrnkey_session=eyJpdiI6IjRzK1MzTzZTRHBpTWV2cThIakFldXc9PSIsInZhbHVlIjoiN25TZ1JBQk5aajdQME05dHp2NHJUd1VTYW9jSmlOTkZDZU5ScHQxUlNBSExMdXk1RjlQZGZpY3p4ZEREREh3Z21tM" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFMcEpCRzVYVm9DRmJEbXphWmt2Z1E9PSIsInZhbHVlIjoiTlVNalc3UFdUMVloQUlXSldvdXh6NWNZUFRXUVNCVXo0V05MU1RZMFQ4cDB5VUhFZ3duSkFTa0k2YnZSbUQrTDR0MWFiU2pNenN1a2dOVFF1cHp1RmJqWUh2Nm5SL0FNd0tiVW5uSW9SR1N0WE44cWFDVmQyNks0aDUrV2JIQ0MiLCJtYWMiOiIxZWQwNzQwNjRmMzU2MmQxYjM4MGUyMzg3ZWU1MDlmNTY2NmJiMTVhNzRjMThhMDVjMzYzODQzOTk1MDc5ZTA4IiwidGFnIjoiIn0%3D; expires=Fri, 15-May-2026 16:39:50 GMT; path=/XSRF-TOKEN=eyJpdiI6ImFMcEpCRzVYVm9DRmJEbXphWmt2Z1E9PSIsInZhbHVlIjoiTlVNalc3UFdUMVloQUlXSldvdXh6NWNZUFRXUVNCVXo0V05MU1RZMFQ4cDB5VUhFZ3duSkFTa0k2YnZSbUQrTDR0MWFiU" 1 => "lrnkey_session=eyJpdiI6IjRzK1MzTzZTRHBpTWV2cThIakFldXc9PSIsInZhbHVlIjoiN25TZ1JBQk5aajdQME05dHp2NHJUd1VTYW9jSmlOTkZDZU5ScHQxUlNBSExMdXk1RjlQZGZpY3p4ZEREREh3Z21tM2JBeGtGcCt4WENTMVlGblVpZ29LYmNlcWo4TGJLSjI3d0VwdUNPRnBqR3FBLzVVZlZZeG9lWWV3K0VZaTMiLCJtYWMiOiJlNWIzYzQzYzZiY2VjMjE5NDcwZmFhNGQ3ODMyZDA2OWIzNjQ1YmU3YTRjNWI2OTI4NDFjY2UxZjlhMTU0NTQ5IiwidGFnIjoiIn0%3D; expires=Fri, 15-May-2026 16:39:50 GMT; path=/; httponlylrnkey_session=eyJpdiI6IjRzK1MzTzZTRHBpTWV2cThIakFldXc9PSIsInZhbHVlIjoiN25TZ1JBQk5aajdQME05dHp2NHJUd1VTYW9jSmlOTkZDZU5ScHQxUlNBSExMdXk1RjlQZGZpY3p4ZEREREh3Z21tM" ] ]
            session_attributes
            0 of 0
            array:4 [ "_token" => "k9qmT1FjB2eFu9gNkvj5fBTFRmolqowE2GKzcUUE" "_previous" => array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/vera-kozlova-2923" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]