MBA in Hotel management SGT University, Gurgaon Overview

MBA in Hotel management is a 2 year course at SGT University, Gurgaon. The total fees for MBA in Hotel management at SGT University, Gurgaon is 1,62,500. To get admission in MBA in Hotel management at SGT University, Gurgaon, students must meet some eligibility requirements, that is Graduate in any stream with minimum 50% marks. This program helps students with the necessary skills to build a successful career in the Management.

MBA in Hotel management SGT University, Gurgaon Highlights

Particular Details
Total Seats 40
Course Fee 1,62,500
Duration 2 Years
Accepted Exams CAT

About MBA in Hotel management

Program Duration
Full Time ,2 Years

Course Type
PG , Management

Eligibility
Graduate in any stream with minimum 50% marks Read More

Check Eligibility Brochure

MBA in Hotel management SGT University, Gurgaon Fee Structure

MBA in Hotel management fees for SGT University, Gurgaon is further divided into categories like registration fees, tuition fees, hostel fees, other expenses, and total fees. We have mentioned these details in the table below:

MBA in Hotel management Fee Breakup

Fees (Rs.) Year 1 Year 2
Tuition Fees ₹ 75,000 ₹ 75,000
Refundable Deposits ₹ 10,000 -
Alumini ₹ 2,500 -

MBA in Hotel management SGT University, Gurgaon Eligibility

Students who are seeking admission in 2 year MBA / PGDM MBA in Hotel management program at the SGT University, Gurgaon should meet the following eligibility criteria.

Graduate in any stream with minimum 50% marks

Check Eligibility Brochure

Popular Exams

Exam Month

November

Accepting Colleges
Last Date to Apply

29th November, 2025

Apply Now
admission

Admission Open

Apply in SGT University, Gurgaon Now!
admission

MBA in Hotel management Fee Payment Options

SGT University, Gurgaon fees for various courses should be paid by students at the time of counseling to confirm their admission:

  • The payment of fees should be made either in cash or a Demand Draft issued in favor of SGT University, Gurgaon.
  • Candidates need to issue a draft in favor of the university to pay the course fee.
  • The college also accepts Internet banking or payment through debit and credit cards.
  • Candidates can directly transfer money from their bank account to the university's bank account through NEFT, RTGS, and IMPS without physically visiting the SGT University, Gurgaon campus.
  • Delay in fee payment can cause a fine as per SGT University, Gurgaon rules and regulations.

SGT University, Gurgaon Fees Inquiry

Contact Information for students to find out more about the SGT University, Gurgaon Fees

  • Contact Number - 2278183, 2278186, 22, 9990300018
  • E-mail at: rohit_digitalmarketing@sgtuniversity.org
  • Admission Block Address - Chandu-Budhera, Gurgaon-Badli Raod

MBA in Hotel management SGT University, Gurgaon Top Recruiters

srf srf
NIIT NIIT
SONY INDIA SONY INDIA
Vatika Vatika
GEMALTO GEMALTO
View All Recruiters Details

Student's Rating for SGT University, Gurgaon

Student Reviews & Ratings
3.1/5 Based on 7 Verified Reviews
Component Ratings
Faculty Rating 4.5
Infrastructure Rating 4.8
Hostel Rating 4.2
Club Rating 4

Student's Reviews for SGT University, Gurgaon

Admission
Placement
Faculty
4 Overall 25-07-2021
A

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Hostel 3 Mess
the best college with great sports and other facilities, well-maintained classrooms, labs, etc

Placement: no idea about placements

Faculty: Teachers are very helpful

Admission: the admission procedure is on the basis of merit

Read More
1 Overall 25-07-2021
A

Anonymous User
MBA Student

Good college for students learning. Good inverment for study. Teacher are very carful for students

Admission: Easly admission in college

Read More
4 Overall 25-07-2021
A

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4.5 Mess
I am doing My PG in Nutrition and diet from this college and for taking admission in this college there is the need for the 12th result and Graduation result and the annual fees of this course is rs.. 1 Lac PA and if you have scored more than 70% marks in

Placement: There are many great and big hospitals in PAN India who comes here for the recruitment.

Read More
4 Overall 25-07-2021
A

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Hostel 3 Mess
the best college with great sports and other facilities, well-maintained classrooms, labs, etc

Placement: no idea about placements

Faculty: Teachers are very helpful

Admission: the admission procedure is on the basis of merit

Read More
4 Overall 25-07-2021
A

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Hostel 3 Mess
the best college with great sports and other facilities, well-maintained classrooms, labs, etc

Placement: no idea about placements

Faculty: Teachers are very helpful

Admission: the admission procedure is on the basis of merit

Read More
View All 7 Reviews

Gallery

36 Images
Library

Library

Library

Library

Library

Library

Library

Library

Classroom

Classroom

Classroom

Classroom

Classroom

Classroom

Classroom

Classroom

View All 36 Images

SGT University, Gurgaon Program Offered

View All Programs

Contact Details

Address

Chandu-Budhera, Gurgaon-Badli Raod

College Contact

22XXXXXX22

Email

roXXXXXXrg

Get Contact Details

SGT University, Gurgaon 3.1/5 (7 reviews)

Shortlist

Brochure

Request history8.3.19PHP Version288msRequest Duration4MBMemory UsageGET {type}/{slug}/{tab}/{tab2}Route
  • warninglog[09:13:06] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • Booting (22.34ms)time
  • Application (266ms)time
  • 1 x Application (92.24%)
    266ms
    1 x Booting (7.75%)
    22.34ms
    13 templates were rendered
    • pages.college-profile.descriptiondescription.blade.php#?blade
    • components.breadcrumbbreadcrumb.blade.php#?blade
    • components.navbarnavbar.blade.php#?blade
    • components.total-reviewtotal-review.blade.php#?blade
    • components.detailed-reviewsdetailed-reviews.blade.php#?blade
    • components.videoslistingvideoslisting.blade.php#?blade
    • components.registrationregistration.blade.php#?blade
    • layouts.webweb.blade.php#?blade
    • partials.headhead.blade.php#?blade
    • partials.headerheader.blade.php#?blade
    • partials.footerfooter.blade.php#?blade
    • components.sucessesModalsucessesModal.blade.php#?blade
    • partials.bottomfooterbottomfooter.blade.php#?blade
    uri
    GET {type}/{slug}/{tab}/{tab2}
    middleware
    web
    domain
    www.dev.collegesearch.in
    controller
    App\Http\Controllers\CollegeController@description
    as
    colleges_university.profile.tabs2
    namespace
    prefix
    /{type}
    where
    file
    app/Http/Controllers/CollegeController.php:41-169
    63 statements were executed (7 duplicates)Show only duplicates138ms
    • SoftRedirects.php#22db_collegesearch_newConnection Established
      Backtrace
      • app/Http/Middleware/SoftRedirects.php:22
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • SoftRedirects.php#22db_collegesearch_new6.74msselect * from `seo_redirects` where `redirect_from` = '/university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210' limit 1
      Bindings
      • 0: /university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210
      Backtrace
      • app/Http/Middleware/SoftRedirects.php:22
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • MetaChecker.php#20db_collegesearch_new1.07msselect * from `meta_tags` where `slug` = 'university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210
      • 1: active
      Backtrace
      • app/Http/Middleware/MetaChecker.php:20
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/SoftRedirects.php:28
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
    • helpers.php#722db_collegesearch_new1.26msselect * from `default_meta_tags` where `module` = 'college' and `default_meta_tags`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: college
      • 1: active
      Backtrace
      • app/helpers.php:722
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:989
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:819
      • vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:755
    • CollegeController.php#66db_collegesearch_new1.39msselect `institutes`.*, (select count(*) from `institute_reviews` where `institutes`.`id` = `institute_reviews`.`institute_id` and `institute_reviews`.`deleted_at` is null and `status` = 'active') as `reviews_count` from `institutes` where `slug` = 'sgt-university-gurgaon' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: active
      • 1: sgt-university-gurgaon
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new1.92msselect `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` in (11785) and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new1.33msselect `id`, `name` from `programs` where `programs`.`id` in (14, 15, 17, 19, 20, 153, 242, 299, 440, 448, 454, 477, 690, 921, 933, 944, 966, 1006, 1039, 1113, 1115, 1152, 1153, 1154, 1589, 1597, 1601, 1608, 2035, 2059, 2082, 2094, 2633, 2635, 2637, 2639, 2640, 2645, 2646, 2669, 2745, 2746, 2747, 2748, 2772, 2773, 2775, 2787, 2788, 2796, 2808, 2822, 2843, 2870, 2872, 2969, 3093, 3095, 3104, 3105, 3160, 3168, 3183, 3201, 3221, 3222, 3440, 3443, 3447, 3456, 3462, 3479, 3534, 3587, 3588, 3594, 3597, 3622, 3636, 3644, 3652, 3672, 3706, 3937, 4696, 4896, 4897, 4898, 4899, 4900) and `programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new1.33msselect `id`, `name` from `courses` where `courses`.`id` in (1, 2, 6, 7, 9, 10, 11, 12, 17, 18, 19, 20, 21, 23, 24, 25, 26, 42, 43, 59, 60, 70, 73, 80) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new2.33msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (29423, 29424, 29425, 29426, 29427, 29428, 29429, 29430, 29431, 29432, 29433, 29434, 29435, 29436, 29437, 29438, 29439, 29440, 29441, 29442, 29443, 29445, 29446, 29447, 29448, 29449, 29450, 29451, 29452, 29453, 29454, 29455, 29466, 34036, 34037, 34038, 34039, 34040, 34041, 34042, 34043, 34044, 34045, 34046, 34047, 35158, 35159, 35160, 35161, 35162, 35163, 35164, 35165, 35166, 35167, 35168, 35169, 35170, 35171, 35172, 35173, 35174, 35175, 35176, 35177, 35178, 68198, 68199, 68200, 68201, 68202, 68203, 68204, 68205, 68206, 68207, 68208, 68209, 68210, 68211, 68213, 68214, 68215, 68216, 68217, 68218, 68219, 68220, 68221, 68222) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new2.38msselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (29423, 29424, 29425, 29426, 29427, 29428, 29429, 29430, 29431, 29432, 29433, 29434, 29435, 29436, 29437, 29438, 29439, 29440, 29441, 29442, 29443, 29445, 29446, 29447, 29448, 29449, 29450, 29451, 29452, 29453, 29454, 29455, 29466, 34036, 34037, 34038, 34039, 34040, 34041, 34042, 34043, 34044, 34045, 34046, 34047, 35158, 35159, 35160, 35161, 35162, 35163, 35164, 35165, 35166, 35167, 35168, 35169, 35170, 35171, 35172, 35173, 35174, 35175, 35176, 35177, 35178, 68198, 68199, 68200, 68201, 68202, 68203, 68204, 68205, 68206, 68207, 68208, 68209, 68210, 68211, 68213, 68214, 68215, 68216, 68217, 68218, 68219, 68220, 68221, 68222) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • CollegeController.php#66db_collegesearch_new1.04msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (29423, 29424, 29425, 29426, 29427, 29428, 29429, 29430, 29431, 29432, 29433, 29434, 29435, 29436, 29437, 29438, 29439, 29440, 29441, 29442, 29443, 29445, 29446, 29447, 29448, 29449, 29450, 29451, 29452, 29453, 29454, 29455, 29466, 34036, 34037, 34038, 34039, 34040, 34041, 34042, 34043, 34044, 34045, 34046, 34047, 35158, 35159, 35160, 35161, 35162, 35163, 35164, 35165, 35166, 35167, 35168, 35169, 35170, 35171, 35172, 35173, 35174, 35175, 35176, 35177, 35178, 68198, 68199, 68200, 68201, 68202, 68203, 68204, 68205, 68206, 68207, 68208, 68209, 68210, 68211, 68213, 68214, 68215, 68216, 68217, 68218, 68219, 68220, 68221, 68222) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:66
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
    • Institute.php#174db_collegesearch_new1.22msselect `name` from `cities` where `id` = 16 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
      Bindings
      • 0: 16
      • 1: active
      Backtrace
      • app/Models/Institute.php:174
      • app/Http/Controllers/CollegeController.php:279
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#189db_collegesearch_new940μsselect `name` from `states` where `id` = 75 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1
      Bindings
      • 0: 75
      • 1: active
      • 2: 2
      Backtrace
      • app/Models/Institute.php:189
      • app/Http/Controllers/CollegeController.php:279
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#711db_collegesearch_new3.45msselect `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 11785 and `institute_contents`.`institute_id` is not null and `type` = 'course-fees-program-specific' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 11785
      • 1: course-fees-program-specific
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:711
      • app/Http/Controllers/CollegeController.php:281
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#282db_collegesearch_new1.45msselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 11785 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null
      Bindings
      • 0: 11785
      Backtrace
      • app/Http/Controllers/CollegeController.php:282
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#282db_collegesearch_new730μsselect `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (3) and `institute_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:282
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#747db_collegesearch_new3.82msselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 11785 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: about
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:747
      • app/Http/Controllers/CollegeController.php:283
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#747db_collegesearch_new1.13msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` is null
      Backtrace
      • app/Http/Controllers/CollegeController.php:747
      • app/Http/Controllers/CollegeController.php:283
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#758db_collegesearch_new880μsselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 11785 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:758
      • app/Http/Controllers/CollegeController.php:283
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#210db_collegesearch_new1.47msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 11785 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Models/Institute.php:210
      • app/Http/Controllers/CollegeController.php:759
      • app/Http/Controllers/CollegeController.php:283
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
    • CollegeController.php#760db_collegesearch_new1.42msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 11785 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:760
      • app/Http/Controllers/CollegeController.php:283
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#210db_collegesearch_new1.77msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 11785 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Models/Institute.php:210
      • app/Http/Controllers/CollegeController.php:285
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.26msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new2.51msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(admission_review) DESC, `created_at` desc limit 2
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.11msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.09msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new970μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(placement_review) DESC, `created_at` desc limit 2
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new930μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.03msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new860μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 11785 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(faculty_review) DESC, `created_at` desc limit 2
      Bindings
      • 0: 11785
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new610μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:289
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#499db_collegesearch_new840μsselect * from `institute_programs` where `institute_id` = 11785 and `institute_programs`.`id` = '68210' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 11785
      • 1: 68210
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new670μsselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (68210) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new940μsselect `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (68210) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new1.31msselect * from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new990μsselect * from `degrees` where `degrees`.`id` in (2) and `degrees`.`deleted_at` is null and `status` = 'Active'
      Bindings
      • 0: 2
      • 1: Active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new1.12msselect * from `streams` where `streams`.`id` in (2) and `streams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 2
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new1.65msselect * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (68210) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new530μsselect * from `fees_types` where `fees_types`.`id` in (2, 7, 35)
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new1.08msselect `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (68210)
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new1.34msselect `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21) and `exams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new940μsselect * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21) and exists (select * from `exam_features` where `exam_feature_mappings`.`exam_feature_id` = `exam_features`.`id` and `type` like '%date%' and `exam_features`.`deleted_at` is null and `status` = 'active') and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active'
      Bindings
      • 0: %date%
      • 1: active
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#499db_collegesearch_new980μsselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9, 10) and `exam_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:499
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • Exam.php#58db_collegesearch_new1.09msselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 21 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 21
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:500
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.42msselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9) and `exam_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:500
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#277db_collegesearch_new1.57msselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 11785 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 2 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1
      Bindings
      • 0: 11785
      • 1: cs
      • 2: nirf
      • 3: 2
      • 4: active
      Backtrace
      • app/Models/Institute.php:277
      • app/Http/Controllers/CollegeController.php:510
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#520db_collegesearch_new1.34msselect `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 2 and `institute_id` = 11785) and `id` != '68210' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3
      Bindings
      • 0: 2
      • 1: 11785
      • 2: 68210
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:520
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#524db_collegesearch_new2.02msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 11785 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:524
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#524db_collegesearch_new3.27msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (120, 1200, 1297, 2695, 5195)
      Backtrace
      • app/Http/Controllers/CollegeController.php:524
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#524db_collegesearch_new1.35msselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (6, 13, 14, 80)
      Backtrace
      • app/Http/Controllers/CollegeController.php:524
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#529db_collegesearch_new6.3msselect `id` from `institute_programs` where `institute_id` = 11785 and `course_id` = 2 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: 2
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:529
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#537db_collegesearch_new3.19msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (68210) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`
      Bindings
      • 0: 68210
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:537
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • Institute.php#226db_collegesearch_new32.1msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 11785 and `faqs`.`faq_id` is not null and `sub_type` = 'course-fees-program-specific' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: institute
      • 1: 11785
      • 2: course-fees-program-specific
      • 3: institute
      • 4: active
      Backtrace
      • app/Models/Institute.php:226
      • app/Http/Controllers/CollegeController.php:660
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#661db_collegesearch_new1.65msselect * from `institute_ratings` where `institute_ratings`.`institute_id` = 11785 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:661
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#662db_collegesearch_new2.19msselect * from `institute_documents` where `institute_documents`.`institute_id` = 11785 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:662
      • app/Http/Controllers/CollegeController.php:76
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#245db_collegesearch_new1.14msselect `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '68210' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 68210
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:245
      • app/Http/Controllers/CollegeController.php:95
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#245db_collegesearch_new2.66msselect `id`, `name`, `slug` from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:245
      • app/Http/Controllers/CollegeController.php:95
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#974db_collegesearch_new2.58msselect distinct `course_id` from `institute_programs` where `institute_id` = 11785 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 11785
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:974
      • app/Http/Controllers/CollegeController.php:96
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#980db_collegesearch_new1.35msselect distinct `exam_id` from `institute_program_exam_mappings` inner join `institute_programs` on `institute_programs`.`id` = `institute_program_exam_mappings`.`institute_program_id` where `institute_programs`.`institute_id` = 11785
      Bindings
      • 0: 11785
      Backtrace
      • app/Http/Controllers/CollegeController.php:980
      • app/Http/Controllers/CollegeController.php:96
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#496db_collegesearch_new3.01msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%cp%' and `sub_type` like '%course-fees-program-specific%' and `module_id` = 11785 and `expiry_date` > '2025-06-27 09:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      Bindings
      • 0: %cp%
      • 1: %course-fees-program-specific%
      • 2: 11785
      • 3: 2025-06-27 09:13:06
      Backtrace
      • app/helpers.php:496
      • app/Http/Controllers/CollegeController.php:96
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#511db_collegesearch_new2.55msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('9', '2008', '2342', '21', '174', '23', '2240', '116', '162', '186', '2198', '131', '161') and `expiry_date` > '2025-06-27 09:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      Bindings
      • 0: %exam%
      • 1: %about%
      • 2: 9
      • 3: 2008
      • 4: 2342
      • 5: 21
      • 6: 174
      • 7: 23
      • 8: 2240
      • 9: 116
      • 10: 162
      • 11: 186
      • 12: 2198
      • 13: 131
      • 14: 161
      • 15: 2025-06-27 09:13:06
      Backtrace
      • app/helpers.php:511
      • app/Http/Controllers/CollegeController.php:96
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#525db_collegesearch_new3.22msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%course%' and `module_id` in ('25', '23', '17', '60', '19', '20', '7', '1', '10', '43', '59', '21', '12', '80', '9', '6', '18', '73', '2', '24', '26', '11', '70', '42') and `sub_type` like '%about%' and `expiry_date` > '2025-06-27 09:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      Bindings
      • 0: %course%
      • 1: 25
      • 2: 23
      • 3: 17
      • 4: 60
      • 5: 19
      • 6: 20
      • 7: 7
      • 8: 1
      • 9: 10
      • 10: 43
      • 11: 59
      • 12: 21
      • 13: 12
      • 14: 80
      • 15: 9
      • 16: 6
      • 17: 18
      • 18: 73
      • 19: 2
      • 20: 24
      • 21: 26
      • 22: 11
      • 23: 70
      • 24: 42
      • 25: %about%
      • 26: 2025-06-27 09:13:06
      Backtrace
      • app/helpers.php:525
      • app/Http/Controllers/CollegeController.php:96
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#826db_collegesearch_new1.37msselect * from `meta_tags` where `slug` = 'university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:826
      • app/Http/Controllers/CollegeController.php:128
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#157db_collegesearch_new1.01msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: institute
      • 1: active
      Backtrace
      • app/helpers.php:157
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • vendor/laravel/framework/src/Illuminate/View/View.php:209
    App\Models\InstituteProgram
    117InstituteProgram.php#?
    App\Models\InstituteProgramFeesSummary
    91InstituteProgramFeesSummary.php#?
    App\Models\Program
    90Program.php#?
    App\Models\InstituteImage
    72InstituteImage.php#?
    App\Models\InstituteProgramPlacement
    40InstituteProgramPlacement.php#?
    App\Models\Course
    26Course.php#?
    App\Models\InstituteProgramExamMapping
    14InstituteProgramExamMapping.php#?
    App\Models\DefaultMetaTag
    13DefaultMetaTag.php#?
    App\Models\InstituteContent
    6InstituteContent.php#?
    App\Models\InstituteReview
    5InstituteReview.php#?
    App\Models\InstituteRecruiter
    5InstituteRecruiter.php#?
    App\Models\Recruiter
    5Recruiter.php#?
    App\Models\InstituteProgramFee
    4InstituteProgramFee.php#?
    App\Models\RecruiterIndustryType
    4RecruiterIndustryType.php#?
    App\Models\User
    3User.php#?
    App\Models\FeesType
    3FeesType.php#?
    App\Models\ExamFeatureMapping
    3ExamFeatureMapping.php#?
    App\Models\ExamFeature
    3ExamFeature.php#?
    App\Models\Branding
    3Branding.php#?
    App\Models\Institute
    1Institute.php#?
    App\Models\City
    1City.php#?
    App\Models\State
    1State.php#?
    App\Models\InstituteFeatureMapping
    1InstituteFeatureMapping.php#?
    App\Models\InstituteFeature
    1InstituteFeature.php#?
    App\Models\Admin
    1Admin.php#?
    App\Models\InstituteFaculty
    1InstituteFaculty.php#?
    App\Models\Degree
    1Degree.php#?
    App\Models\Stream
    1Stream.php#?
    App\Models\Exam
    1Exam.php#?
    App\Models\InstituteRating
    1InstituteRating.php#?
        _token
        ieiV4n6arSVYI8a1MZsdbPXjXQqY4cpN0sfVfQE5
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/university/sgt-university-gurgaon/courses-fee...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210
        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:16 [ "host" => array:1 [ 0 => "www.dev.collegesearch.in" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InBBeEJqSkxlZGFpNUZoc1hBczkzaVE9PSIsInZhbHVlIjoiNnIrTDdQLzNPM2o2OEV3eGRBYlpQQ3Z1N1hWVE93R1I4SGtmQURROUp0TE5kNDFEejgvVVlhdVF6Z0w3ZkJUTmJaYWJWdS8vVFlzdTdSVENmM1plUzloODQ5dHErcy96bUNCWUVWWG81QnYzd0xjTDVlQU5IQlBHR0N5bE50Mk4iLCJtYWMiOiJhNGRhZmI1MWM2YmMyNjA1MzgxMGI2NzVjMTExOTE2MTI4ODhmYjVjZTUxYmVkMjIyYmQ4Mzc3MGJjNGQ5OGE5IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Im1mUGFuUmJKNVR1bXE2NHZZblVmekE9PSIsInZhbHVlIjoiWEdxYUJod29MMW9IVlZtbWw5ZVp3cTV2S3Z1TVhsR0xPNTdvdE53c3Y0ellhelk0d1kxejJCTWpCWFY4VzJVQnl0N2dtNlFhWWJ6ZVRNL3pSdlJESE1nK1FlcEJnaTNlelFiUDFyK3A3YmovZ2J5RU15OTNoSXhvM1AzeXJpa1AiLCJtYWMiOiIwNjMzODhmNzBlYmM4MDQ2YjJjMzNlMjc3MzVhNDdiYmNmNjIxYzViMWU1NGI2NjJlMDc2ZTZkYzE1OWM2OGUwIiwidGFnIjoiIn0%3D; course_id=21; course_name=BCom; viewed_colleges=%5B6191%2C17546%2C9148%2C48996%2C52930%2C50840%2C817%2C16421%2C39687%5DXSRF-TOKEN=eyJpdiI6InBBeEJqSkxlZGFpNUZoc1hBczkzaVE9PSIsInZhbHVlIjoiNnIrTDdQLzNPM2o2OEV3eGRBYlpQQ3Z1N1hWVE93R1I4SGtmQURROUp0TE5kNDFEejgvVVlhdVF6Z0w3ZkJUTmJaYWJWd" ] "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_cookies
        0 of 0
        array:5 [ "XSRF-TOKEN" => "ieiV4n6arSVYI8a1MZsdbPXjXQqY4cpN0sfVfQE5" "laravel_session" => "CKRgcfE6imENrfzJB6pbDyEzYcOevDxnhKjfjklJ" "course_id" => "21" "course_name" => "BCom" "viewed_colleges" => "[6191,17546,9148,48996,52930,50840,817,16421,39687]" ]
        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, 27 Jun 2025 09:13:06 GMT" ] "set-cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IitOZytRVDlURGRJKytVTUYrMThpaXc9PSIsInZhbHVlIjoicFFvcUxMZ2RzUS85SGc5MlBrMWdmeWxSVlpzc3dCODc5a0YzNVQrR3ZlaCsrc09rTUVraGlsak9kRmdiQVdqVG55TVBNUlF6ZW1tMkZ2MDlZbzBzV3RtbjFVYVZwb1U2U05UcVp0L0pnejZ4NTBRTk1GemFPVHpMUzhFa0t6Q2IiLCJtYWMiOiI3ZDk4ZTE4NDRiZDJiODY5NWM3YmZmMGYyN2UzYTI0ZmY1NTg0MDMxZjBlMDc1MjA4NTRmODUyNGNhYTliZjk4IiwidGFnIjoiIn0%3D; expires=Fri, 27 Jun 2025 11:13:06 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IitOZytRVDlURGRJKytVTUYrMThpaXc9PSIsInZhbHVlIjoicFFvcUxMZ2RzUS85SGc5MlBrMWdmeWxSVlpzc3dCODc5a0YzNVQrR3ZlaCsrc09rTUVraGlsak9kRmdiQVdqVG55TVBNU" 1 => "laravel_session=eyJpdiI6IlFzQ3VLREhPbENWbDRIdktEWW5vZmc9PSIsInZhbHVlIjoiZW1FS2Y4ajlyRmxJcmFjNXdqTXB2cjBHWGpweU8vbUVNNFpyakFsNDIrcmVWYjJ6T3k0R2tLY3BNSjhZTkhIL0tQb2lQZTlwY3Qwb201cExBV2VDUDc3YjM5czI1MDhOTmhHbFF4ckRBbHpreDUxdUIvZU4vMk1sU0lCMVdpRE8iLCJtYWMiOiIyNDgxZDhlOWM0ODczNDU0YjYyZTI3NWYxY2MxNTc5OGFiOWU4NDdlYjViNGFmNjQ2MjdkZjQyNjNhNjQ2MDBlIiwidGFnIjoiIn0%3D; expires=Fri, 27 Jun 2025 11:13:06 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6IlFzQ3VLREhPbENWbDRIdktEWW5vZmc9PSIsInZhbHVlIjoiZW1FS2Y4ajlyRmxJcmFjNXdqTXB2cjBHWGpweU8vbUVNNFpyakFsNDIrcmVWYjJ6T3k0R2tLY3BNSjhZTkhIL0tQ" 2 => "course_id=2; expires=Sat, 27 Jun 2026 09:13:06 GMT; Max-Age=31536000; path=/; samesite=lax" 3 => "course_name=MBA%20%2F%20PGDM; expires=Sat, 27 Jun 2026 09:13:06 GMT; Max-Age=31536000; path=/; samesite=lax" 4 => "viewed_colleges=%5B6191%2C17546%2C9148%2C48996%2C52930%2C50840%2C817%2C16421%2C39687%2C11785%5D; expires=Sun, 27 Jul 2025 09:13:06 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=laxviewed_colleges=%5B6191%2C17546%2C9148%2C48996%2C52930%2C50840%2C817%2C16421%2C39687%2C11785%5D; expires=Sun, 27 Jul 2025 09:13:06 GMT; Max-Age=2592000; path=/;" ] "Set-Cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IitOZytRVDlURGRJKytVTUYrMThpaXc9PSIsInZhbHVlIjoicFFvcUxMZ2RzUS85SGc5MlBrMWdmeWxSVlpzc3dCODc5a0YzNVQrR3ZlaCsrc09rTUVraGlsak9kRmdiQVdqVG55TVBNUlF6ZW1tMkZ2MDlZbzBzV3RtbjFVYVZwb1U2U05UcVp0L0pnejZ4NTBRTk1GemFPVHpMUzhFa0t6Q2IiLCJtYWMiOiI3ZDk4ZTE4NDRiZDJiODY5NWM3YmZmMGYyN2UzYTI0ZmY1NTg0MDMxZjBlMDc1MjA4NTRmODUyNGNhYTliZjk4IiwidGFnIjoiIn0%3D; expires=Fri, 27-Jun-2025 11:13:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IitOZytRVDlURGRJKytVTUYrMThpaXc9PSIsInZhbHVlIjoicFFvcUxMZ2RzUS85SGc5MlBrMWdmeWxSVlpzc3dCODc5a0YzNVQrR3ZlaCsrc09rTUVraGlsak9kRmdiQVdqVG55TVBNU" 1 => "laravel_session=eyJpdiI6IlFzQ3VLREhPbENWbDRIdktEWW5vZmc9PSIsInZhbHVlIjoiZW1FS2Y4ajlyRmxJcmFjNXdqTXB2cjBHWGpweU8vbUVNNFpyakFsNDIrcmVWYjJ6T3k0R2tLY3BNSjhZTkhIL0tQb2lQZTlwY3Qwb201cExBV2VDUDc3YjM5czI1MDhOTmhHbFF4ckRBbHpreDUxdUIvZU4vMk1sU0lCMVdpRE8iLCJtYWMiOiIyNDgxZDhlOWM0ODczNDU0YjYyZTI3NWYxY2MxNTc5OGFiOWU4NDdlYjViNGFmNjQ2MjdkZjQyNjNhNjQ2MDBlIiwidGFnIjoiIn0%3D; expires=Fri, 27-Jun-2025 11:13:06 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6IlFzQ3VLREhPbENWbDRIdktEWW5vZmc9PSIsInZhbHVlIjoiZW1FS2Y4ajlyRmxJcmFjNXdqTXB2cjBHWGpweU8vbUVNNFpyakFsNDIrcmVWYjJ6T3k0R2tLY3BNSjhZTkhIL0tQ" 2 => "course_id=2; expires=Sat, 27-Jun-2026 09:13:06 GMT; path=/" 3 => "course_name=MBA+%2F+PGDM; expires=Sat, 27-Jun-2026 09:13:06 GMT; path=/" 4 => "viewed_colleges=%5B6191%2C17546%2C9148%2C48996%2C52930%2C50840%2C817%2C16421%2C39687%2C11785%5D; expires=Sun, 27-Jul-2025 09:13:06 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "ieiV4n6arSVYI8a1MZsdbPXjXQqY4cpN0sfVfQE5" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-68210" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-27 09:13:06GET/university/sgt-university-gurgaon/courses-fees/mba-mba-in-hotel-management-6821011363518