Flag

Contact Ganga Singh

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

$5.50/h
free_lesson
India
online

Ganga Singh

Learn Basic to Advanced Excel and Intermediate Level Photoshop

skills:

MS Excel, Photoshop

language(s)

English

skills:

MS Excel, Photoshop

language(s)

English

$5.50/hour
free_lesson
credit_card No credit card required
Response time The tutor doesn't have available time slots for the next 24 hours.
About Ganga
Here You will be able to learn Basic to Intermediate Level Photoshop (Don’t worry if you don’t have the photoshop app as all adobe apps 2021 version will be provided to you along with the course for free and with lifetime access) You will also learn Advanced Excel starting from level 0 (Best for Absolute Beginners and People who are looking to expand their knowledge base and learn new skills to enhance their carrier opportunities) I will be teaching with the help of a graphic tablet so that the students get the best possible online learning experience and grasp everything.
Show more Arrow down Show less Arrow up
Employment Education
From
2021-06
To
2021-10
Employer
Prime M2I Consulting Pvt Ltd
Position
Creating and Managing Data Studio Based Dashboards and Data Analysis in Excel and Google Sheets
From
2021-10
To
2021-10
Institution
Jaspal Kaur Public School
Degree
93%
From
2021-10
To
2021-10
Institution
Sri Guru Gobind Singh College of Commerce
Degree
9 cgpa
$5.50/hour
free_lesson
credit_card No credit card required
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

Fri9 MaySat10 MaySun11 MayMon12 MayTue13 MayWed14 MayThu15 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
  •   Fri Sat Sun Mon Tue Wed Thu
    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
    0.0
    0 review

    No reviews yet.

    7.4.3PHP Version238msRequest Duration7MBMemory UsageGET {path}Route
      • Booting (41.54ms)
      • Application (196ms)
      • 1 x Application (82.44%)
        196.15ms
        1 x Booting (17.46%)
        41.54ms
        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:12-15
        13 statements were executed, 2 of which were duplicated, 11 unique86.94ms
        • select * from `account_attachments` where `account_id` = 14925
          3.78ms/legacy/modules/Coaches.php:490lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925
          1.72ms/legacy/modules/Coaches.php:519lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925 and `reviewer_id` is null) as `exists`
          1.32ms/legacy/modules/Coaches.php:549lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925 limit 1
          1.25ms/legacy/modules/Coaches.php:572lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925
          1.49ms/legacy/modules/Coaches.php:572lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925 limit 1
          1.33ms/legacy/modules/Coaches.php:574lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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` = 14925 order by `lessons_count` desc limit 1
          1.46ms/legacy/modules/Coaches.php:574lrnkey_stage
          Metadata
          Bindings
          • 0. 14925
          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 '%Software%' or `lesson_categories`.`category_name` like '%Software%'
          2.89ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:356lrnkey_stage
          Metadata
          Bindings
          • 0. %Software%
          • 1. %Software%
          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-08 10:16:00') and `accounts`.`email` is not null and `accounts`.`show_status` = 1 and FIND_IN_SET(account_subjects.subject_id,'414,477,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,664,691,704,705') group by `accounts`.`account_id`
          36.61ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:568lrnkey_stage
          Metadata
          Bindings
          • 0. 5
          • 1. 0
          • 2. 220
          • 3. Active
          • 4. Pending
          • 5. 2025-05-08 10:16:00
          • 6. 1
          • 7. 414,477,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,664,691,704,705
          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 (10082, 10143, 10172, 10191, 10232, 10307, 10329, 10383, 10422, 10486, 10633, 12391, 12520, 12807, 13276, 13447, 13462, 13659, 13900, 14026, 14070, 14147, 14230, 14330, 14400, 14449, 14515, 14677, 14786, 14789, 14925, 15175, 15287, 15407, 15504, 15505, 15506, 15507, 15509, 15887, 15888, 15894, 15912, 15941, 15944, 15960, 15967, 15968, 15980, 15981, 15982, 15988, 15993) group by `accounts`.`account_id` order by `account_profiles`.`popular` desc, `rating` desc, `verified` desc, `video_status` desc, `lesson_pricing`.`trial` desc
          6.02ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. 1.1
          • 1. 0
          • 2. 220
          • 3. 10082
          • 4. 10143
          • 5. 10172
          • 6. 10191
          • 7. 10232
          • 8. 10307
          • 9. 10329
          • 10. 10383
          • 11. 10422
          • 12. 10486
          • 13. 10633
          • 14. 12391
          • 15. 12520
          • 16. 12807
          • 17. 13276
          • 18. 13447
          • 19. 13462
          • 20. 13659
          • 21. 13900
          • 22. 14026
          • 23. 14070
          • 24. 14147
          • 25. 14230
          • 26. 14330
          • 27. 14400
          • 28. 14449
          • 29. 14515
          • 30. 14677
          • 31. 14786
          • 32. 14789
          • 33. 14925
          • 34. 15175
          • 35. 15287
          • 36. 15407
          • 37. 15504
          • 38. 15505
          • 39. 15506
          • 40. 15507
          • 41. 15509
          • 42. 15887
          • 43. 15888
          • 44. 15894
          • 45. 15912
          • 46. 15941
          • 47. 15944
          • 48. 15960
          • 49. 15967
          • 50. 15968
          • 51. 15980
          • 52. 15981
          • 53. 15982
          • 54. 15988
          • 55. 15993
          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 (10082, 10143, 10172, 10191, 10232, 10307, 10329, 10383, 10422, 10486, 10633, 12391, 12520, 12807, 13276, 13447, 13462, 13659, 13900, 14026, 14070, 14147, 14230, 14330, 14400, 14449, 14515, 14677, 14786, 14789, 14925, 15175, 15287, 15407, 15504, 15505, 15506, 15507, 15509, 15887, 15888, 15894, 15912, 15941, 15944, 15960, 15967, 15968, 15980, 15981, 15982, 15988, 15993)
          1.62ms/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 (10082, 10143, 10172, 10191, 10232, 10307, 10329, 10383, 10422, 10486, 10633, 12391, 12520, 12807, 13276, 13447, 13462, 13659, 13900, 14026, 14070, 14147, 14230, 14330, 14400, 14449, 14515, 14677, 14786, 14789, 14925, 15175, 15287, 15407, 15504, 15505, 15506, 15507, 15509, 15887, 15888, 15894, 15912, 15941, 15944, 15960, 15967, 15968, 15980, 15981, 15982, 15988, 15993)
          1.22ms/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 (10082, 10143, 10172, 10191, 10232, 10307, 10329, 10383, 10422, 10486, 10633, 12391, 12520, 12807, 13276, 13447, 13462, 13659, 13900, 14026, 14070, 14147, 14230, 14330, 14400, 14449, 14515, 14677, 14786, 14789, 14925, 15175, 15287, 15407, 15504, 15505, 15506, 15507, 15509, 15887, 15888, 15894, 15912, 15941, 15944, 15960, 15967, 15968, 15980, 15981, 15982, 15988, 15993) and `start_time` > '2025-05-09 10:16:00' and `start_time` <= '2025-05-16 10:16:00' order by `start_time` asc
          26.23ms/app/Http/DataProviders/Tutor/TutorDataProvider.php:115lrnkey_stage
          Metadata
          Bindings
          • 0. Declined
          • 1. Cancelled
          • 2. 2025-05-09 10:16:00
          • 3. 2025-05-16 10:16:00
          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
        99
        App\Models\LessonSubjects
        136
        App\Models\Account
        108
        App\Models\AccountAttachment
        34
            _token
            2zBAK1lJQucyE8qzlgvICjw8ogtfizEVPPD9R9z5
            _previous
            array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/ganga-singh-5022" ]
            _flash
            array:2 [ "old" => [] "new" => [] ]
            PHPDEBUGBAR_STACK_DATA
            []
            path_info
            /find-online-tutor/ganga-singh-5022
            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/ganga-singh-5022" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/find-online-tutor/ganga-singh-5022" "REMOTE_PORT" => "47726" "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" => "3.137.170.78" "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" => "2923098-1497-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" => "2923098-1497-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" => 1746785760.0301 "REQUEST_TIME" => 1746785760 ]
            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 => "Fri, 09 May 2025 10:16:00 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InJFSjF1d0JiRWErWTlBWko4Qk5va0E9PSIsInZhbHVlIjoiQTdNMVpZNFJWM3VLcUNWdldiemd0UlBvNSt6VVhlQlhIdmx6bFB2TURIR1kxUUxXUWRidE1IbExEZzV4R2NZd0VaWVVEak92M0NZcnhLcEFXcC9ld2VaMTVjY1FmMXdZVmlnUXNvMUEyTFg1c3Y1aTlVdlhzcUc5T3dHUi9Sa2oiLCJtYWMiOiI3YzMwYmFmYzA5YzgwNDA4Y2I4NmZjYTI0ZWI1ZGFlOWI4MDhhZWZiNjFkNTM0YWI0MWY1ZmM5YzY1ZjkyYTA4IiwidGFnIjoiIn0%3D; expires=Sat, 09-May-2026 10:16:00 GMT; Max-Age=31536000; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6InJFSjF1d0JiRWErWTlBWko4Qk5va0E9PSIsInZhbHVlIjoiQTdNMVpZNFJWM3VLcUNWdldiemd0UlBvNSt6VVhlQlhIdmx6bFB2TURIR1kxUUxXUWRidE1IbExEZzV4R2NZd0VaWVVEa" 1 => "lrnkey_session=eyJpdiI6Imp5cFhIY1c0azM0SXMrY0dpYUdpb2c9PSIsInZhbHVlIjoicFJZbXdFeHlzankvanFnOVpZaTJ4cjd6eDJrNkdUaDBreHpnZzV4blRmckk1QVhHdW9aWG5IdW53eTYxNEFwZi94YjRSSVBxb3duTEs0U2JHem9MN2ZrLzdDVTQ2TVFxajgvd1RmTDhWZVVnL2tOMW54bjNUbmtkTHBjUWVPZ1kiLCJtYWMiOiI0MmFmMDljZmJlMWQ2MDE3MDRmNDY4NDcwZTY1YTEzNjczNTJjNTJhMGMyOWU0OTRjMDJmYTI1YWFlZDZlNTViIiwidGFnIjoiIn0%3D; expires=Sat, 09-May-2026 10:16:00 GMT; Max-Age=31536000; path=/; httponly; samesite=laxlrnkey_session=eyJpdiI6Imp5cFhIY1c0azM0SXMrY0dpYUdpb2c9PSIsInZhbHVlIjoicFJZbXdFeHlzankvanFnOVpZaTJ4cjd6eDJrNkdUaDBreHpnZzV4blRmckk1QVhHdW9aWG5IdW53eTYxNEFwZi94Y" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InJFSjF1d0JiRWErWTlBWko4Qk5va0E9PSIsInZhbHVlIjoiQTdNMVpZNFJWM3VLcUNWdldiemd0UlBvNSt6VVhlQlhIdmx6bFB2TURIR1kxUUxXUWRidE1IbExEZzV4R2NZd0VaWVVEak92M0NZcnhLcEFXcC9ld2VaMTVjY1FmMXdZVmlnUXNvMUEyTFg1c3Y1aTlVdlhzcUc5T3dHUi9Sa2oiLCJtYWMiOiI3YzMwYmFmYzA5YzgwNDA4Y2I4NmZjYTI0ZWI1ZGFlOWI4MDhhZWZiNjFkNTM0YWI0MWY1ZmM5YzY1ZjkyYTA4IiwidGFnIjoiIn0%3D; expires=Sat, 09-May-2026 10:16:00 GMT; path=/XSRF-TOKEN=eyJpdiI6InJFSjF1d0JiRWErWTlBWko4Qk5va0E9PSIsInZhbHVlIjoiQTdNMVpZNFJWM3VLcUNWdldiemd0UlBvNSt6VVhlQlhIdmx6bFB2TURIR1kxUUxXUWRidE1IbExEZzV4R2NZd0VaWVVEa" 1 => "lrnkey_session=eyJpdiI6Imp5cFhIY1c0azM0SXMrY0dpYUdpb2c9PSIsInZhbHVlIjoicFJZbXdFeHlzankvanFnOVpZaTJ4cjd6eDJrNkdUaDBreHpnZzV4blRmckk1QVhHdW9aWG5IdW53eTYxNEFwZi94YjRSSVBxb3duTEs0U2JHem9MN2ZrLzdDVTQ2TVFxajgvd1RmTDhWZVVnL2tOMW54bjNUbmtkTHBjUWVPZ1kiLCJtYWMiOiI0MmFmMDljZmJlMWQ2MDE3MDRmNDY4NDcwZTY1YTEzNjczNTJjNTJhMGMyOWU0OTRjMDJmYTI1YWFlZDZlNTViIiwidGFnIjoiIn0%3D; expires=Sat, 09-May-2026 10:16:00 GMT; path=/; httponlylrnkey_session=eyJpdiI6Imp5cFhIY1c0azM0SXMrY0dpYUdpb2c9PSIsInZhbHVlIjoicFJZbXdFeHlzankvanFnOVpZaTJ4cjd6eDJrNkdUaDBreHpnZzV4blRmckk1QVhHdW9aWG5IdW53eTYxNEFwZi94Y" ] ]
            session_attributes
            0 of 0
            array:4 [ "_token" => "2zBAK1lJQucyE8qzlgvICjw8ogtfizEVPPD9R9z5" "_previous" => array:1 [ "url" => "https://test.lrnkey.com/find-online-tutor/ganga-singh-5022" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]