Last Updated at

Table of Content

Dr YSR National Institute of Tourism and Hospitality Management , Hyderabad Highlights

Dr YSR National Institute of Tourism and Hospitality Management was established in 2004 and is located in Hyderabad, Telangana.

It is a Coed College.

Dr YSR National Institute of Tourism and Hospitality Management offers various graduation and post-graduation courses.

The college offers courses namely (Discontinued June 2022)- PGDM in Tourism Management, B.Sc. in Hospitality and Hotel Administration, BBA in Tourism and Hospitality. Fees for various programs in Dr YSR National Institute of Tourism and Hospitality Management vary between 242000 and 375000.

Dr YSR National Institute of Tourism and Hospitality Management Courses and Fees

Courses Fees Seats Duration
(Discontinued June 2022)- PGDM in Tourism Management 0 0 2 Years
B.Sc. in Hospitality and Hotel Administration 0 120 3 Years
BBA in Tourism and Hospitality 375000 0 4 Years
MBA in Tourism and Hospitality Management 242000 0 2 Years

Dr YSR National Institute of Tourism and Hospitality Management Placement Details

Dr YSR National Institute of Tourism and Hospitality Management offered placement to its students in more than 6 companies. Top companies which recruited from this college are Hotel Green Park, Kingfisher Airlines, Radisson, Thomas Cook, GMR Group.

Read More

Dr YSR National Institute of Tourism and Hospitality Management , Hyderabad Popular Courses

MBA / PGDM
2 Programs 2 Years

Average Fees
-

Highest Package
₹10 LPA

Admission 2025

View Brochure
MBA / PGDM Application Open Apply Now
BBA / BBM / BBS
1 Programs 3 Years

Average Fees
-

Highest Package
₹7 LPA

Admission 2025

View Brochure
BBA / BBM / BBS Application Open Apply Now
BHM
1 Programs 3 Years

Average Fees
-

Highest Package
₹11 LPA

Admission 2025

View Brochure
BHM Application Open Apply Now
Hotel Management - PG
1 Programs 2 Years

Average Fees
-

Highest Package
-

Admission 2025

View Brochure
Hotel Management - PG Application Open Apply Now
View All 4 Courses

Top Recruiters

Cox & Kings Cox & Kings
GMR Group GMR Group
Hotel Green Park Hotel Green Park
Kingfisher Airlines Kingfisher Airlines
Radisson Radisson
Thomas Cook Thomas Cook
View All Recruiters Details

Dr YSR National Institute of Tourism and Hospitality Management Infrastructure Details

Boys Hostel

Girls Hostel

Medical Facility

Library Facility

Cafeteria

Computer Lab

Sports Facilities

Auditorium

Dr YSR National Institute of Tourism and Hospitality Management , Ahmedabad Faculty Details

Faculty Name Faculty Photo
Dr. P. Narayana Reddy
Position : Director
Speciality : N/A
Education : N/A
Dr. P. Narayana Reddy image
Read More

Student's Rating for Dr YSR National Institute of Tourism and Hospitality Management , Hyderabad

Student Reviews & Ratings
4/5 Based on 1 Verified Reviews
Component Ratings
Faculty Rating 4
Infrastructure Rating 3

Student's Reviews for Dr YSR National Institute of Tourism and Hospitality Management , Hyderabad

Admission
Placement
Faculty
4 Overall 25-07-2021
A

Anonymous User
MBA Student

3 Infrastructure 4 Faculty 3 Mess
My college is affilaited with the Jawaharlal Nehru Technological University of Hyderabad and I have done my MBA in Tourism and this college provides a degree in tourism only and for the admissions, I have given the ATMA Examination and I am in the 2nd yea

Placement: I have just entered in the 2nd year and that is why I am not right now aware of this

Faculty: Regular lectures are taken by the professors and that helps all of us

Admission: State / National Entrance Exams

Read More
4 Overall 25-07-2021
A

Anonymous User
MBA Student

3 Infrastructure 4 Faculty 3 Mess
My college is affilaited with the Jawaharlal Nehru Technological University of Hyderabad and I have done my MBA in Tourism and this college provides a degree in tourism only and for the admissions, I have given the ATMA Examination and I am in the 2nd yea

Placement: I have just entered in the 2nd year and that is why I am not right now aware of this

Faculty: Regular lectures are taken by the professors and that helps all of us

Admission: State / National Entrance Exams

Read More
4 Overall 25-07-2021
A

Anonymous User
MBA Student

3 Infrastructure 4 Faculty 3 Mess
My college is affilaited with the Jawaharlal Nehru Technological University of Hyderabad and I have done my MBA in Tourism and this college provides a degree in tourism only and for the admissions, I have given the ATMA Examination and I am in the 2nd yea

Placement: I have just entered in the 2nd year and that is why I am not right now aware of this

Faculty: Regular lectures are taken by the professors and that helps all of us

Admission: State / National Entrance Exams

Read More
View All 1 Reviews

Gallery

7 Images
Campus

Campus

Campus

Campus

Womens Day Celebrations

Womens Day Celebrations

Event

Event

Library

Library

Campus

Campus

Class

Class

View All 7 Images

Contact Details

Address

Telecom Nagar, Gachibowli

College Contact

23XXXXXX,

Email

deXXXXXXin

Get Contact Details

Dr YSR National Institute of Tourism and Hospitality Management college , Hyderabad
4/5 (1 reviews)

Shortlist

Brochure

Quick Links

Request history8.3.13PHP Version204msRequest Duration3MBMemory UsageGET {type}/{slug}Route
    • Booting (6.31ms)time
    • Application (198ms)time
    • 1 x Application (96.91%)
      198ms
      1 x Booting (3.09%)
      6.31ms
      16 templates were rendered
      • pages.college-profile.descriptiondescription.blade.php#?blade
      • components.breadcrumbbreadcrumb.blade.php#?blade
      • components.navbarnavbar.blade.php#?blade
      • components.author-detailsauthor-details.blade.php#?blade
      • components.toctoc.blade.php#?blade
      • components.college-contentcollege-content.blade.php#?blade
      • components.popular-coursespopular-courses.blade.php#?blade
      • components.total-reviewtotal-review.blade.php#?blade
      • components.detailed-reviewsdetailed-reviews.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}
      middleware
      web
      domain
      www.dev.collegesearch.in
      controller
      App\Http\Controllers\CollegeController@description
      as
      colleges_university.profile.description
      namespace
      prefix
      /{type}
      where
      file
      app/Http/Controllers/CollegeController.php:99-180
      74 statements were executed (13 duplicates)Show only duplicates142ms
      • 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_new7.42msselect * from `seo_redirects` where `redirect_from` = '/colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad' limit 1
        Bindings
        • 0: /colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad
        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.05msselect * from `meta_tags` where `slug` = 'colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad
        • 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
      • CollegeController.php#122db_collegesearch_new1.49msselect `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` = 'dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: active
        • 1: dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad
        • 2: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new5.04msselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `updated_at` from `institute_contents` where `type` != 'about' and `institute_contents`.`institute_id` in (7127) and `institute_contents`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: about
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new770μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (235) and `admins`.`deleted_at` is null
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new690μsselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` in (7127) and `institute_faculties`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new800μsselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` in (7127) and `institute_feature_mappings`.`deleted_at` is null
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new680μ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:122
        • 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#122db_collegesearch_new8.58msselect `id`, `infrastructure_id`, `institute_id` from `institute_infrastructures` where `institute_infrastructures`.`institute_id` in (7127) and `institute_infrastructures`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new1.9msselect `id`, `name` from `infrastructures` where `infrastructures`.`id` in (1, 2, 3, 4, 5, 6, 9, 10)
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new640μsselect `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` in (7127) and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new1.7msselect * from `institute_recruiters` where `institute_recruiters`.`institute_id` in (7127) and `institute_recruiters`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new1.51msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (634, 682, 772, 842, 3457, 5083)
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new3.82msselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (24, 25, 47, 68)
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new2.56msselect * from `institute_ratings` where `institute_ratings`.`institute_id` in (7127) and `institute_ratings`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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#122db_collegesearch_new1.69msselect * from `institute_alumnis` where `institute_alumnis`.`institute_id` in (7127) and `institute_alumnis`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:122
        • 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.23msselect `name` from `cities` where `id` = 3 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
        Bindings
        • 0: 3
        • 1: active
        Backtrace
        • app/Models/Institute.php:174
        • app/Http/Controllers/CollegeController.php:290
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#188db_collegesearch_new660μsselect `name` from `states` where `id` = 98 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1
        Bindings
        • 0: 98
        • 1: active
        • 2: 2
        Backtrace
        • app/Models/Institute.php:188
        • app/Http/Controllers/CollegeController.php:290
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#508db_collegesearch_new1.43msselect `institute_id`, `title`, `info_description`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 7127 and `institute_contents`.`institute_id` is not null and `type` = 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: 7127
        • 1: about
        • 2: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:508
        • app/Http/Controllers/CollegeController.php:292
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new810μsselect `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` = 7127 and `institute_programs`.`institute_id` is not null and `institute_programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new1.28msselect `id`, `name` from `programs` where `programs`.`id` in (668, 2320, 2336, 3450, 4767) and `programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new700μsselect `id`, `name` from `courses` where `courses`.`id` in (2, 7, 12, 73) and `courses`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new830μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (11196, 11197, 18950, 60996, 78777) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new810μsselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (11196, 11197, 18950, 60996, 78777) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#553db_collegesearch_new1.61msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (11196, 11197, 18950, 60996, 78777) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:553
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#555db_collegesearch_new880μsselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7127 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:555
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#208db_collegesearch_new1.02msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7127 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Models/Institute.php:208
        • app/Http/Controllers/CollegeController.php:556
        • app/Http/Controllers/CollegeController.php:294
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • Institute.php#208db_collegesearch_new1.2msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7127 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Models/Institute.php:208
        • app/Http/Controllers/CollegeController.php:296
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#138db_collegesearch_new1.33msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new1.3msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new1.3msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#138db_collegesearch_new1.01msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new1.32msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new520μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • 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` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new1.45msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7127 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: 7127
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new810μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:300
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#308db_collegesearch_new980μsselect count(distinct `course_id`) as aggregate from `institute_course_summaries` where `institute_id` = 7127 and `institute_course_summaries`.`deleted_at` is null
        Bindings
        • 0: 7127
        Backtrace
        • app/Http/Controllers/CollegeController.php:308
        • app/Http/Controllers/CollegeController.php:132
        • 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#316db_collegesearch_new950μsselect * from `institute_course_summaries` where `institute_id` = 7127 and `institute_course_summaries`.`deleted_at` is null group by `course_id` limit 4
        Bindings
        • 0: 7127
        Backtrace
        • app/Http/Controllers/CollegeController.php:316
        • app/Http/Controllers/CollegeController.php:132
        • 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#316db_collegesearch_new1.53msselect * from `courses` where `courses`.`id` in (2, 7, 12, 73) and `courses`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:316
        • app/Http/Controllers/CollegeController.php:132
        • 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
      • InstituteCourseSummary.php#26db_collegesearch_new1.12msselect * from `institute_programs` where `id` in ('11197', '60996') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 11197
        • 1: 60996
        • 2: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new890μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (11197, 60996) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new1.14msselect `id`, `name`, `slug` from `exams` where `id` in ('21', '23', '24', '27') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 21
        • 1: 23
        • 2: 24
        • 3: 27
        • 4: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new1.01msselect `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`.`status` = 'active' limit 1
        Bindings
        • 0: 21
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new1.39msselect `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` = 23 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 23
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new1.18msselect `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:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
      • Exam.php#57db_collegesearch_new1.42msselect `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` = 24 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 24
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new920μsselect `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` = 27 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 27
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new1.13msselect * from `institute_programs` where `id` in ('11196') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 11196
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new640μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (11196) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new710μsselect `id`, `name`, `slug` from `exams` where `id` in ('2008') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 2008
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new780μsselect `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` = 2008 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 2008
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new710μsselect * from `institute_programs` where `id` in ('18950') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 18950
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new730μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (18950) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new650μsselect `id`, `name`, `slug` from `exams` where `id` in ('131') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 131
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new2.36msselect `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` = 131 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 131
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new1.61msselect * from `institute_programs` where `id` in ('78777') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 78777
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new2.41msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (78777) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new770μsselect `id`, `name`, `slug` from `exams` where `id` in ('') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:317
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#237db_collegesearch_new960μsselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 7127 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: 7127
        • 1: cs
        • 2: active
        Backtrace
        • app/Models/Institute.php:237
        • app/Http/Controllers/CollegeController.php:319
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#320db_collegesearch_new2.79msselect `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` = 7127 and `institute_awards`.`institute_id` is not null and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:320
        • app/Http/Controllers/CollegeController.php:132
        • 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#102db_collegesearch_new1msselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7127 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Models/Institute.php:102
        • app/Http/Controllers/CollegeController.php:334
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new1.93msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7127 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:334
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new1.09msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (634, 682, 772, 842, 3457, 5083)
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:334
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new630μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (24, 25, 47, 68)
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:334
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#224db_collegesearch_new28.98msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 7127 and `faqs`.`faq_id` is not null and `sub_type` = 'info' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null
        Bindings
        • 0: institute
        • 1: 7127
        • 2: info
        • 3: institute
        Backtrace
        • app/Models/Institute.php:224
        • app/Http/Controllers/CollegeController.php:457
        • app/Http/Controllers/CollegeController.php:132
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#459db_collegesearch_new2.09msselect * from `institute_documents` where `institute_documents`.`institute_id` = 7127 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:459
        • app/Http/Controllers/CollegeController.php:132
        • 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#752db_collegesearch_new1.09msselect distinct `course_id` from `institute_programs` where `institute_id` = 7127 and `institute_programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7127
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:752
        • app/Http/Controllers/CollegeController.php:137
        • 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#758db_collegesearch_new940μsselect 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` = 7127
        Bindings
        • 0: 7127
        Backtrace
        • app/Http/Controllers/CollegeController.php:758
        • app/Http/Controllers/CollegeController.php:137
        • 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#479db_collegesearch_new2.07msselect `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 '%info%' and `module_id` = 7127 and `expiry_date` > '2025-01-07 15:35:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
        Bindings
        • 0: %cp%
        • 1: %info%
        • 2: 7127
        • 3: 2025-01-07 15:35:40
        Backtrace
        • app/helpers.php:479
        • app/Http/Controllers/CollegeController.php:137
        • 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#494db_collegesearch_new3.14msselect `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 ('2008', '24', '23', '131', '21', '27') and `expiry_date` > '2025-01-07 15:35:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
        Bindings
        • 0: %exam%
        • 1: %about%
        • 2: 2008
        • 3: 24
        • 4: 23
        • 5: 131
        • 6: 21
        • 7: 27
        • 8: 2025-01-07 15:35:40
        Backtrace
        • app/helpers.php:494
        • app/Http/Controllers/CollegeController.php:137
        • 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#508db_collegesearch_new3.36msselect `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 ('7', '2', '12', '73') and `sub_type` like '%about%' and `expiry_date` > '2025-01-07 15:35:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
        Bindings
        • 0: %course%
        • 1: 7
        • 2: 2
        • 3: 12
        • 4: 73
        • 5: %about%
        • 6: 2025-01-07 15:35:40
        Backtrace
        • app/helpers.php:508
        • app/Http/Controllers/CollegeController.php:137
        • 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#623db_collegesearch_new2.47msselect * from `meta_tags` where `slug` = 'colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:623
        • app/Http/Controllers/CollegeController.php:149
        • 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#144db_collegesearch_new1.17msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: institute
        • 1: active
        Backtrace
        • app/helpers.php:144
        • 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
      14InstituteProgram.php#?
      App\Models\InstituteImage
      14InstituteImage.php#?
      App\Models\InstituteRecruiter
      12InstituteRecruiter.php#?
      App\Models\Recruiter
      12Recruiter.php#?
      App\Models\InstituteInfrastructure
      8InstituteInfrastructure.php#?
      App\Models\Infrastructure
      8Infrastructure.php#?
      App\Models\RecruiterIndustryType
      8RecruiterIndustryType.php#?
      App\Models\Course
      8Course.php#?
      App\Models\Exam
      6Exam.php#?
      App\Models\InstituteProgramExamMapping
      6InstituteProgramExamMapping.php#?
      App\Models\Program
      5Program.php#?
      App\Models\InstituteCourseSummary
      4InstituteCourseSummary.php#?
      App\Models\InstituteProgramPlacement
      3InstituteProgramPlacement.php#?
      App\Models\InstituteReview
      3InstituteReview.php#?
      App\Models\User
      3User.php#?
      App\Models\Branding
      3Branding.php#?
      App\Models\Institute
      1Institute.php#?
      App\Models\InstituteContent
      1InstituteContent.php#?
      App\Models\Admin
      1Admin.php#?
      App\Models\InstituteFaculty
      1InstituteFaculty.php#?
      App\Models\InstituteFeatureMapping
      1InstituteFeatureMapping.php#?
      App\Models\InstituteFeature
      1InstituteFeature.php#?
      App\Models\InstituteRating
      1InstituteRating.php#?
      App\Models\City
      1City.php#?
      App\Models\State
      1State.php#?
      App\Models\ExamFeatureMapping
      1ExamFeatureMapping.php#?
      App\Models\ExamFeature
      1ExamFeature.php#?
          _token
          YPsj7pXXD64xR9XNuphPwc82Gr8mPCNGk0vZPEUm
          _previous
          array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/dr-ysr-national-institute-of-tourism...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad
          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=eyJpdiI6InUrVnlMUXErR1N1UUdiSVJHMmdUNnc9PSIsInZhbHVlIjoiUmZMb2JNdUo5WUUzMEhjQjNUZ2x2UFQybDNDVTQ3UUprWUZiQkVyeHNyZkhrb3lzdjJzaFZBamViV0RNaitFOEFYMmhyRFRFNXVHaG1qYnhzMkkveU55UVVDc0VqenFxeVFFWnMxSnNNc0F6V3dJTUc4Rmh3NEV1VitNK01PTWwiLCJtYWMiOiIxODJhZjI4Y2IxY2IwZjk3YmRlOGVmYjJjYjg0MjE4MzEwYTVmNTAxMWYyZWYyYTZiMGE5ZGRhNGE0OTc5NjkzIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6ImtpS3lRMDYzUHFJTTJsWDkrNGFWd0E9PSIsInZhbHVlIjoidXFRc0MrL1BuUWNTS1ptMUtPaGkyNkpFbmRQWFlyUmV1cEQyNml3dWpqMXptSHptYzVqWm1EUFJsNUJOK2M5VERQN0JPdU84eXpsNlBSWFd4eWVIR0kydzB6YkxlWVoreEdMT3M0L0xzcHRZUEVHclNNM1VBclg2eUhac1V0K1EiLCJtYWMiOiI3OWYwMTE5NzYyMmYwZTllNGI1NDM5Njg4YzFhNmQzNWY1NzhkYWFhZmU4ZDFjNWYxNWQ4ZjY3M2Q5YmQ5YTMwIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InUrVnlMUXErR1N1UUdiSVJHMmdUNnc9PSIsInZhbHVlIjoiUmZMb2JNdUo5WUUzMEhjQjNUZ2x2UFQybDNDVTQ3UUprWUZiQkVyeHNyZkhrb3lzdjJzaFZBamViV0RNaitFOEFYMmhyR" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "YPsj7pXXD64xR9XNuphPwc82Gr8mPCNGk0vZPEUm" "laravel_session" => "kbkgMk2OY0N3OhyQHZlXIkwiGJjLlJr1mNXIFPL1" ]
          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 => "Tue, 07 Jan 2025 15:35:40 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikp2UTFqUGdFQTV2NkVKSngvMnVEWFE9PSIsInZhbHVlIjoicnB1NWhNYjdnZTR0alhLNG5kUlR1OGRYMHJXMm5DUk15cUliRVBBSk54N0RPcGhqVnh1cnVyOHVmOGhuSkNNbnEyb1IrVGgrb3NqRTZBSm14NGNzSmh6anlRQnRYNXlma2lKUS9HVTRYcEM5Z2o2djRLVlhzWmtNZnRxVUpZSmkiLCJtYWMiOiJiYjg3YzYyYzRkMzBhMGY4N2JlNmQwNGM2ZDQwMmNiY2Y1NWFlMDQ3OTU4Mjc4M2UxYjQyMzgxZGZiNWZhNWI3IiwidGFnIjoiIn0%3D; expires=Tue, 07 Jan 2025 17:35:40 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ikp2UTFqUGdFQTV2NkVKSngvMnVEWFE9PSIsInZhbHVlIjoicnB1NWhNYjdnZTR0alhLNG5kUlR1OGRYMHJXMm5DUk15cUliRVBBSk54N0RPcGhqVnh1cnVyOHVmOGhuSkNNbnEyb1IrV" 1 => "laravel_session=eyJpdiI6ImJubkZrMWwxVklaYlJpQ3FhemZoV1E9PSIsInZhbHVlIjoiRHRqeVZnbHNMQ0c4enhrNUFZUkhEL2h6RlJVQWVRbHJjZ05UQkwxL1dqMStjOUR1MTNTRlBNcW1QbjhPNFdvb3QxbHlTUUtSOHcvckNtV0tES1gybXZhS0JUQXhsc3R1c3lCMTR1VG9ITS9ZQlROellPVEFjamNaa2VDdE5hSTAiLCJtYWMiOiJkMmVmMDVkNzBhM2ZlZDIwMjljN2FjMTU0NDU0ZTkxMWU4ZWQwODcwNjZkNzEyZDdiNjY4ZTk0ZTc2YWU3ZWRmIiwidGFnIjoiIn0%3D; expires=Tue, 07 Jan 2025 17:35:40 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6ImJubkZrMWwxVklaYlJpQ3FhemZoV1E9PSIsInZhbHVlIjoiRHRqeVZnbHNMQ0c4enhrNUFZUkhEL2h6RlJVQWVRbHJjZ05UQkwxL1dqMStjOUR1MTNTRlBNcW1QbjhPNFdvb3Qx" 2 => "viewed_colleges=%5B7127%5D; expires=Thu, 06 Feb 2025 15:35:40 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikp2UTFqUGdFQTV2NkVKSngvMnVEWFE9PSIsInZhbHVlIjoicnB1NWhNYjdnZTR0alhLNG5kUlR1OGRYMHJXMm5DUk15cUliRVBBSk54N0RPcGhqVnh1cnVyOHVmOGhuSkNNbnEyb1IrVGgrb3NqRTZBSm14NGNzSmh6anlRQnRYNXlma2lKUS9HVTRYcEM5Z2o2djRLVlhzWmtNZnRxVUpZSmkiLCJtYWMiOiJiYjg3YzYyYzRkMzBhMGY4N2JlNmQwNGM2ZDQwMmNiY2Y1NWFlMDQ3OTU4Mjc4M2UxYjQyMzgxZGZiNWZhNWI3IiwidGFnIjoiIn0%3D; expires=Tue, 07-Jan-2025 17:35:40 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ikp2UTFqUGdFQTV2NkVKSngvMnVEWFE9PSIsInZhbHVlIjoicnB1NWhNYjdnZTR0alhLNG5kUlR1OGRYMHJXMm5DUk15cUliRVBBSk54N0RPcGhqVnh1cnVyOHVmOGhuSkNNbnEyb1IrV" 1 => "laravel_session=eyJpdiI6ImJubkZrMWwxVklaYlJpQ3FhemZoV1E9PSIsInZhbHVlIjoiRHRqeVZnbHNMQ0c4enhrNUFZUkhEL2h6RlJVQWVRbHJjZ05UQkwxL1dqMStjOUR1MTNTRlBNcW1QbjhPNFdvb3QxbHlTUUtSOHcvckNtV0tES1gybXZhS0JUQXhsc3R1c3lCMTR1VG9ITS9ZQlROellPVEFjamNaa2VDdE5hSTAiLCJtYWMiOiJkMmVmMDVkNzBhM2ZlZDIwMjljN2FjMTU0NDU0ZTkxMWU4ZWQwODcwNjZkNzEyZDdiNjY4ZTk0ZTc2YWU3ZWRmIiwidGFnIjoiIn0%3D; expires=Tue, 07-Jan-2025 17:35:40 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6ImJubkZrMWwxVklaYlJpQ3FhemZoV1E9PSIsInZhbHVlIjoiRHRqeVZnbHNMQ0c4enhrNUFZUkhEL2h6RlJVQWVRbHJjZ05UQkwxL1dqMStjOUR1MTNTRlBNcW1QbjhPNFdvb3Qx" 2 => "viewed_colleges=%5B7127%5D; expires=Thu, 06-Feb-2025 15:35:40 GMT; path=/; secure; httponly" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "YPsj7pXXD64xR9XNuphPwc82Gr8mPCNGk0vZPEUm" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-01-07 15:35:40GET/colleges/dr-ysr-national-institute-of-tourism-and-hospitality-management-hyderabad1674128