Flag

Contact Zaheer Ahmed

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

$16.50/h
Pakistan
online

Zaheer Ahmed

skills:

GIS, Remote Sensing, ArcGIS

language(s)

English

skills:

GIS, Remote Sensing, ArcGIS

language(s)

English

$16.50/hour
Response time Usually responds in less than 1 hour
Response time The tutor doesn't have available time slots for the next 24 hours.
About Zaheer
10+ Years of multidimensional experience in the field of GITs including activities like geospatial data capture & management, map production, GIS implementation, spatial data modeling & analysis, satellite data handling, image processing & analysis, field surveys, research supervision, trainings and teaching.
Show more Arrow down Show less Arrow up
Employment Education
From
2010
To
2016
Employer
Agriculture Department, Punjab
Position
Research Officer ( Remote Sensing )
From
2011
To
2019
Employer
College of Information Technology, University of the Punjab
Position
Visiting Faculty Member ( in GIS )
From
2016
To
2020
Employer
Irrigation Department, Punjab
Position
Assistant Director (GIS)
From
2004
To
2008
Institution
University of the Punjab
Degree
BS (Hons) Computational Physics
From
2008
To
2010
Institution
National University of Sciences & Technology (NUST), Islamabad, Pakistan
Degree
MS (GIS & Remote Sensing)
$16.50/hour
Response time Usually responds in less than 1 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

July 2025

Wed16 JulThu17 JulFri18 JulSat19 JulSun20 JulMon21 JulTue22 Jul
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
Jul 2025
  •   Wed Thu Fri Sat Sun Mon Tue
    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 .
    Didn't find the time you were looking for? the teacher directly to book a class out of this schedule.
    Reviews
    0.0
    0 review

    No reviews yet.

    7.4.3PHP Version6.98sRequest Duration7MBMemory UsageGET {path}Route
      • Booting (31.6ms)
      • Application (6.95s)
      • 1 x Application (99.54%)
        6.95s
        1 x Booting (0.45%)
        31.60ms
        19 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)34blade
          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
          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
          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
          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
          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
        • 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)34blade
          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
          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
          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
          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
          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
          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
          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
          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
        • 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:13-16
        13 statements were executed, 2 of which were duplicated, 11 unique99.01ms
        • select * from `account_attachments` where `account_id` = 10172
          5.42ms/legacy/modules/Coaches.php:497lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172
          18.96ms/legacy/modules/Coaches.php:526lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172 and `reviewer_id` is null) as `exists`
          1.03ms/legacy/modules/Coaches.php:556lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172 limit 1
          1.42ms/legacy/modules/Coaches.php:579lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172
          1.18ms/legacy/modules/Coaches.php:579lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172 limit 1
          880μs/legacy/modules/Coaches.php:581lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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` = 10172 order by `lessons_count` desc limit 1
          1.01ms/legacy/modules/Coaches.php:581lrnkey_stage
          Metadata
          Bindings
          • 0. 10172
          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 '%Information Technology%' or `lesson_categories`.`category_name` like '%Information Technology%'
          2.81ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:356lrnkey_stage
          Metadata
          Bindings
          • 0. %Information Technology%
          • 1. %Information Technology%
          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 15:47:37') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 and FIND_IN_SET(account_subjects.subject_id,'407,408,409,410,411,412,413,414,415,416,417,418,419,651,652,663') group by `accounts`.`account_id`
          52.44ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:568lrnkey_stage
          Metadata
          Bindings
          • 0. 5
          • 1. 5
          • 2. 220
          • 3. Active
          • 4. Pending
          • 5. 2025-07-15 15:47:37
          • 6. 1
          • 7. 407,408,409,410,411,412,413,414,415,416,417,418,419,651,652,663
          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 (10129, 10143, 10153, 10159, 10172, 10211, 10232, 10244, 10329, 10383, 10384, 10495, 11814, 11821, 12056, 12803, 12808, 13653, 14027, 14045, 14107, 14120, 14137, 14242, 14838, 14994, 15326, 15445, 15519) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc
          6.7ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. 1.1
          • 1. 5
          • 2. 220
          • 3. 10129
          • 4. 10143
          • 5. 10153
          • 6. 10159
          • 7. 10172
          • 8. 10211
          • 9. 10232
          • 10. 10244
          • 11. 10329
          • 12. 10383
          • 13. 10384
          • 14. 10495
          • 15. 11814
          • 16. 11821
          • 17. 12056
          • 18. 12803
          • 19. 12808
          • 20. 13653
          • 21. 14027
          • 22. 14045
          • 23. 14107
          • 24. 14120
          • 25. 14137
          • 26. 14242
          • 27. 14838
          • 28. 14994
          • 29. 15326
          • 30. 15445
          • 31. 15519
          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 (10129, 10143, 10153, 10159, 10172, 10211, 10232, 10244, 10329, 10383, 10384, 10495, 11814, 11821, 12056, 12803, 12808, 13653, 14027, 14045, 14107, 14120, 14137, 14242, 14838, 14994, 15326, 15445, 15519)
          2.15ms/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 (10129, 10143, 10153, 10159, 10172, 10211, 10232, 10244, 10329, 10383, 10384, 10495, 11814, 11821, 12056, 12803, 12808, 13653, 14027, 14045, 14107, 14120, 14137, 14242, 14838, 14994, 15326, 15445, 15519)
          2.19ms/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 (10129, 10143, 10153, 10159, 10172, 10211, 10232, 10244, 10329, 10383, 10384, 10495, 11814, 11821, 12056, 12803, 12808, 13653, 14027, 14045, 14107, 14120, 14137, 14242, 14838, 14994, 15326, 15445, 15519) and `start_time` > '2025-07-16 15:47:37' and `start_time` <= '2025-07-23 15:47:37' order by `start_time` asc
          2.82ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. Declined
          • 1. Cancelled
          • 2. 2025-07-16 15:47:37
          • 3. 2025-07-23 15:47:37
          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\AccountAttachment
        3
        App\Models\LessonSubjects
        93
        App\Models\Account
        60
            _token
            uhD8l8z85e5NgUL4OMhcFaca8zqDlnCHMjBgx8IB
            _previous
            array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/zaheer-ahmed-269" ]
            _flash
            array:2 [ "old" => [] "new" => [] ]
            PHPDEBUGBAR_STACK_DATA
            []
            path_info
            /find-online-tutor/zaheer-ahmed-269
            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/zaheer-ahmed-269" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/find-online-tutor/zaheer-ahmed-269" "REMOTE_PORT" => "1533" "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.173" "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" => "225741-1287-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" => "225741-1287-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" => 1752680850.7444 "REQUEST_TIME" => 1752680850 ]
            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 15:47:37 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBRUDlIREROVDNUYk95L0JuMWs0cWc9PSIsInZhbHVlIjoibWE5V09GTVhGeTR2OHhKL2VybkxFejR4TWFVR01nZFhpM0UreVhYK2dEOGQrT1A0am9JdWIyeFRNOGxiRnZMSldJUisxOHVnbTlXUldIcEQ2QzVWSnp0a2tlU1V2ZkdMbHg1TXp5ZTAyZFBsSWhSZE4vQWNnYWM3UWVqcE50OU8iLCJtYWMiOiJjZTc2NmY5N2YyOTdmYzIwMDI4Y2E0M2JjZmJmMTcwNWI2ODdlZGIyZjVhMWFmODkwMGMxN2Q0MmQxZTNlZGZlIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 15:47:37 GMT; Max-Age=31536000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlBRUDlIREROVDNUYk95L0JuMWs0cWc9PSIsInZhbHVlIjoibWE5V09GTVhGeTR2OHhKL2VybkxFejR4TWFVR01nZFhpM0UreVhYK2dEOGQrT1A0am9JdWIyeFRNOGxiRnZMSldJUisxO" 1 => "lrnkey_session=eyJpdiI6Ik5PUlpNZ1NJdGYxQUk3YjJYMEpoSlE9PSIsInZhbHVlIjoiclFkK25WUkM5b0Y2VWFIQThOeGFhRjE5OUc3TWhrYjRkNSs1aUdOd0kxTkpoZTR0MFJUTXdpN1ZRbmVROGhLbVU1bWIzYXVGSWlXMDU1REhGQXgxcXljYnYzWDlNOGhpcDcvQ1gwM3ovQWNjcGFHRFhtbXoxS2l5SUdHS1VaM0siLCJtYWMiOiJhZWIyMTYyNWQ0MWJiNjYwMmQzZjlkNTgyZjlhZDZlNjMxN2M4NmJhNzRiZjdiYjk4YzRhOGU1Yzg5MTNiYWZjIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 15:47:37 GMT; Max-Age=31536000; path=/; httponly; samesite=laxlrnkey_session=eyJpdiI6Ik5PUlpNZ1NJdGYxQUk3YjJYMEpoSlE9PSIsInZhbHVlIjoiclFkK25WUkM5b0Y2VWFIQThOeGFhRjE5OUc3TWhrYjRkNSs1aUdOd0kxTkpoZTR0MFJUTXdpN1ZRbmVROGhLbVU1b" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBRUDlIREROVDNUYk95L0JuMWs0cWc9PSIsInZhbHVlIjoibWE5V09GTVhGeTR2OHhKL2VybkxFejR4TWFVR01nZFhpM0UreVhYK2dEOGQrT1A0am9JdWIyeFRNOGxiRnZMSldJUisxOHVnbTlXUldIcEQ2QzVWSnp0a2tlU1V2ZkdMbHg1TXp5ZTAyZFBsSWhSZE4vQWNnYWM3UWVqcE50OU8iLCJtYWMiOiJjZTc2NmY5N2YyOTdmYzIwMDI4Y2E0M2JjZmJmMTcwNWI2ODdlZGIyZjVhMWFmODkwMGMxN2Q0MmQxZTNlZGZlIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 15:47:37 GMT; path=/XSRF-TOKEN=eyJpdiI6IlBRUDlIREROVDNUYk95L0JuMWs0cWc9PSIsInZhbHVlIjoibWE5V09GTVhGeTR2OHhKL2VybkxFejR4TWFVR01nZFhpM0UreVhYK2dEOGQrT1A0am9JdWIyeFRNOGxiRnZMSldJUisxO" 1 => "lrnkey_session=eyJpdiI6Ik5PUlpNZ1NJdGYxQUk3YjJYMEpoSlE9PSIsInZhbHVlIjoiclFkK25WUkM5b0Y2VWFIQThOeGFhRjE5OUc3TWhrYjRkNSs1aUdOd0kxTkpoZTR0MFJUTXdpN1ZRbmVROGhLbVU1bWIzYXVGSWlXMDU1REhGQXgxcXljYnYzWDlNOGhpcDcvQ1gwM3ovQWNjcGFHRFhtbXoxS2l5SUdHS1VaM0siLCJtYWMiOiJhZWIyMTYyNWQ0MWJiNjYwMmQzZjlkNTgyZjlhZDZlNjMxN2M4NmJhNzRiZjdiYjk4YzRhOGU1Yzg5MTNiYWZjIiwidGFnIjoiIn0%3D; expires=Thu, 16-Jul-2026 15:47:37 GMT; path=/; httponlylrnkey_session=eyJpdiI6Ik5PUlpNZ1NJdGYxQUk3YjJYMEpoSlE9PSIsInZhbHVlIjoiclFkK25WUkM5b0Y2VWFIQThOeGFhRjE5OUc3TWhrYjRkNSs1aUdOd0kxTkpoZTR0MFJUTXdpN1ZRbmVROGhLbVU1b" ] ]
            session_attributes
            0 of 0
            array:4 [ "_token" => "uhD8l8z85e5NgUL4OMhcFaca8zqDlnCHMjBgx8IB" "_previous" => array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/zaheer-ahmed-269" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]