Bachelor of Science in Airlines, Tourism & Hospitality GNA University, Hosiarpur Overview

Bachelor of Science in Airlines, Tourism & Hospitality is a 3 year course at GNA University, Hosiarpur. The total fees for Bachelor of Science in Airlines, Tourism & Hospitality at GNA University, Hosiarpur is 36,000. To get admission in Bachelor of Science in Airlines, Tourism & Hospitality at GNA University, Hosiarpur, students must meet some eligibility requirements, that is 12th Any Stream. This program helps students with the necessary skills to build a successful career in the Hotel Management.

Bachelor of Science in Airlines, Tourism & Hospitality GNA University, Hosiarpur Highlights

Particular Details
Total Seats 60
Course Fee 36,000
Duration 3 Years
Accepted Exams UPCET, JEE Main, CUET, , NCHMCT JEE

About Bachelor of Science in Airlines, Tourism & Hospitality

Program Duration
Full Time ,3 Years

Course Type
UG , Hotel Management

Eligibility
12th Any Stream Read More

Check Eligibility Brochure

Bachelor of Science in Airlines, Tourism & Hospitality GNA University, Hosiarpur Fee Structure

Bachelor of Science in Airlines, Tourism & Hospitality fees for GNA University, Hosiarpur 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:

Bachelor of Science in Airlines, Tourism & Hospitality Fee Breakup

Fees (Rs.) Year 1
Tuition Fees ₹ 1,06,560

Bachelor of Science in Airlines, Tourism & Hospitality GNA University, Hosiarpur Eligibility

Students who are seeking admission in 3 year BHM Bachelor of Science in Airlines, Tourism & Hospitality program at the GNA University, Hosiarpur should meet the following eligibility criteria.

12th Any Stream

Check Eligibility Brochure
admission

Admission Open

Apply in GNA University, Hosiarpur Now!
admission

Bachelor of Science in Airlines, Tourism & Hospitality Fee Payment Options

GNA University, Hosiarpur 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 GNA University, Hosiarpur.
  • Candidates need to issue a draft in favor of the university to pay the course fee.
  • The university 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 GNA University, Hosiarpur campus.
  • Delay in fee payment can cause a fine as per GNA University, Hosiarpur rules and regulations.

GNA University, Hosiarpur Fees Inquiry

Contact Information for students to find out more about the GNA University, Hosiarpur Fees

  • Contact Number - 37842974084, 8558894201
  • E-mail at: monika.hanspal@gnauniversity.edu.in
  • Admission Block Address - Sri Hargobindgarh, Phagwara- Hoshiarpur Road,Phagwara,

Bachelor of Science in Airlines, Tourism & Hospitality GNA University, Hosiarpur Top Recruiters

Vodafone Vodafone
MUTHOOT GROUP MUTHOOT GROUP
ICICI Bank ICICI Bank
ranbaxy ranbaxy
Pidilite Industries Pidilite Industries
Airtel Airtel
IndusInd Bank IndusInd Bank
Swaraj Mazda Swaraj Mazda
OSWAL OSWAL
Radisson Radisson
infosys infosys
Wipro Wipro
Cipla Limited Cipla Limited
Accenture Accenture
tata tata
DLF DLF
Taj Group of Hotels Taj Group of Hotels
Hero cycles Pvt ltd Hero cycles Pvt ltd
Reliance Reliance
View All Recruiters Details

Student's Rating for GNA University, Hosiarpur

Student Reviews & Ratings
4.2/5 Based on 26 Verified Reviews
Component Ratings
Faculty Rating 4.6
Placements Rating 4.5

Student's Reviews for GNA University, Hosiarpur

Admission
Placement
Faculty
5 Overall 31-08-2023
A

Anonymous User
MBA Student

5 Placement 5 Faculty
GNA University is located in Phagwara, Punjab, India, and is renowned for its academic excellence and vibrant campus life. Nestled in the heart of Punjab, GNA University offers a diverse range of programs and a dynamic learning environment. The campus

Placement: Companies that are interested in recruiting from our university often conduct pre-placement talks. These talks provide students with insights into the company’s culture, job roles, and expectations. Students can interact with company representative

Admission: Consistent practice is key. Solve practice questions, previous years’ papers, and mock tests to familiarize yourself with the exam pattern and improve your problem-solving skills.

Read More
5 Overall 06-09-2023
A

Anonymous User
MBA Student

5 Placement 4.5 Faculty
Best in automation. Provide training on various design softwares. Supportive staff.

Admission: Always try to indulge yourself into various activities for your personal development.

Read More
4 Overall 11-09-2023
A

Anonymous User
MBA Student

4 Placement 4.5 Faculty
Preeti Mahi Wed, 30 Aug, 15:20 (12 days ago) to Pankaj I am Harmanpreet Kalsi, a student of Animation and Multimedia in GNA University . It gives me great pleasure to offer my endorsement for GNA University, where I had the honor of pursuing a three

Placement: The dedication of GNA University to placements is noteworthy. The placement cell put forth a lot of effort to attract reputable businesses, which provided students with excellent placement chances. I am appreciative of the institution for helping me make

Admission: Start revision early. Organise study time.

Read More
5 Overall 31-08-2023
A

Anonymous User
MBA Student

5 Placement 5 Faculty
I had the privilege of completing my M.Tech in CAD/CAM at GNA University, and my experience has been truly exceptional. The education provided here is top-notch, blending theoretical knowledge with practical application seamlessly. The university’s

Placement: GNA University excels not only in education but also in providing remarkable placement opportunities, internships, and training programs. The university’s strong industry connections ensure that students have access to a wide array of placements, al

Admission: Your previous education syllabus.

Read More
View All 26 Reviews

Gallery

23 Images
hostel

hostel

Campus

Campus

College campus

College campus

Cafeteria

Cafeteria

Lecture

Lecture

Seminar room

Seminar room

Auditorium

Auditorium

library

library

View All 23 Images

GNA University, Hosiarpur Program Offered

4.5 Bachelor in Hotel Management (BHM)
120 Seats 3 Years
Total Fees

₹3,19,680

Admission 2025
Highest Package

N/A

Brochure
4.5 B.Sc. in HM
120 Seats 3 Years
Total Fees

₹3,19,680

Admission 2025
Highest Package

N/A

Brochure
View All Programs

Contact Details

Address

Sri Hargobindgarh, Phagwara- Hoshiarpur Road,Phagwara,

College Contact

37XXXXXX84

Email

moXXXXXXin

Get Contact Details

GNA University, Hosiarpur 4.2/5 (26 reviews)

Shortlist

Brochure

Request history8.3.19PHP Version200msRequest Duration4MBMemory UsageGET {type}/{slug}/{tab}/{tab2}Route
  • warninglog[12:44:29] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • Booting (7.77ms)time
  • Application (192ms)time
  • 1 x Application (96.12%)
    192ms
    1 x Booting (3.88%)
    7.77ms
    12 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.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:105-233
    66 statements were executed (8 duplicates)Show only duplicates115ms
    • 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.54msselect * from `seo_redirects` where `redirect_from` = '/colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492' limit 1
      Bindings
      • 0: /colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492
      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_new850μsselect * from `meta_tags` where `slug` = 'colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492
      • 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#130db_collegesearch_new900μsselect `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` = 'gna-university-hosiarpur' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: active
      • 1: gna-university-hosiarpur
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new1.63msselect `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 (16701) and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new1.37msselect `id`, `name` from `programs` where `programs`.`id` in (14, 15, 17, 20, 26, 32, 36, 67, 172, 301, 918, 920, 922, 1597, 1629, 2032, 2264, 2265, 2266, 2295, 2300, 2305, 2315, 2317, 2339, 2447, 3088, 3343, 3423, 3437, 3443, 3447, 3450, 3458, 3588, 3589, 3622, 3635, 3652, 4479, 4670, 4672, 4697, 4756, 4917, 5490, 5680, 6113, 6114) and `programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new960μsselect `id`, `name` from `courses` where `courses`.`id` in (1, 2, 7, 8, 10, 11, 12, 13, 19, 20, 21, 23, 25, 33, 43, 59, 73, 74, 80) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new1.11msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (34208, 34209, 34210, 34211, 34212, 34213, 34214, 34215, 34216, 34217, 34221, 34222, 34223, 34224, 34225, 34226, 34227, 34228, 34229, 34230, 34231, 34232, 34233, 34234, 34235, 77489, 77490, 77491, 77492, 77493, 77494, 77495, 77496, 77497, 77498, 77499, 77500, 77501, 77502, 77503, 77504, 77505, 77506, 77507, 77508, 110799, 110800, 110801, 110802) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new1.44msselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (34208, 34209, 34210, 34211, 34212, 34213, 34214, 34215, 34216, 34217, 34221, 34222, 34223, 34224, 34225, 34226, 34227, 34228, 34229, 34230, 34231, 34232, 34233, 34234, 34235, 77489, 77490, 77491, 77492, 77493, 77494, 77495, 77496, 77497, 77498, 77499, 77500, 77501, 77502, 77503, 77504, 77505, 77506, 77507, 77508, 110799, 110800, 110801, 110802) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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#130db_collegesearch_new1.15msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (34208, 34209, 34210, 34211, 34212, 34213, 34214, 34215, 34216, 34217, 34221, 34222, 34223, 34224, 34225, 34226, 34227, 34228, 34229, 34230, 34231, 34232, 34233, 34234, 34235, 77489, 77490, 77491, 77492, 77493, 77494, 77495, 77496, 77497, 77498, 77499, 77500, 77501, 77502, 77503, 77504, 77505, 77506, 77507, 77508, 110799, 110800, 110801, 110802) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:130
      • 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_new750μsselect `name` from `cities` where `id` = 261 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
      Bindings
      • 0: 261
      • 1: active
      Backtrace
      • app/Models/Institute.php:174
      • app/Http/Controllers/CollegeController.php:343
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#189db_collegesearch_new590μsselect `name` from `states` where `id` = 90 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1
      Bindings
      • 0: 90
      • 1: active
      • 2: 2
      Backtrace
      • app/Models/Institute.php:189
      • app/Http/Controllers/CollegeController.php:343
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#775db_collegesearch_new1.05msselect `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 16701 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: 16701
      • 1: course-fees-program-specific
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:775
      • app/Http/Controllers/CollegeController.php:345
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#346db_collegesearch_new850μsselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 16701 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null
      Bindings
      • 0: 16701
      Backtrace
      • app/Http/Controllers/CollegeController.php:346
      • app/Http/Controllers/CollegeController.php:140
      • 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#346db_collegesearch_new1.31msselect `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:346
      • app/Http/Controllers/CollegeController.php:140
      • 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#811db_collegesearch_new2.07msselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 16701 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: about
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:811
      • app/Http/Controllers/CollegeController.php:347
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#811db_collegesearch_new820μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (324) and `admins`.`deleted_at` is null
      Backtrace
      • app/Http/Controllers/CollegeController.php:811
      • app/Http/Controllers/CollegeController.php:347
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#822db_collegesearch_new1.43msselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 16701 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:822
      • app/Http/Controllers/CollegeController.php:347
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#209db_collegesearch_new1.78msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 16701 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:823
      • app/Http/Controllers/CollegeController.php:347
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
    • CollegeController.php#824db_collegesearch_new1.02msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 16701 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:824
      • app/Http/Controllers/CollegeController.php:347
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#209db_collegesearch_new1.49msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 16701 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:349
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.34msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.55msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.1msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.16msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.26msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new670μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.05msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new910μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 16701 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: 16701
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#563db_collegesearch_new760μsselect * from `institute_programs` where `institute_id` = 16701 and `institute_programs`.`id` = '77492' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 16701
      • 1: 77492
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new520μsselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (77492) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.3msselect `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (77492) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.35msselect * from `courses` where `courses`.`id` in (12) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.01msselect * from `degrees` where `degrees`.`id` in (1) and `degrees`.`deleted_at` is null and `status` = 'Active'
      Bindings
      • 0: 1
      • 1: Active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.53msselect * from `streams` where `streams`.`id` in (6) and `streams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 6
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.2msselect * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (77492) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.13msselect * from `fees_types` where `fees_types`.`id` in (2)
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new760μsselect `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (77492)
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.15msselect `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (14, 131, 161, 2198, 2342) and `exams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.32msselect * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (14, 131, 161, 2342) 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:563
      • app/Http/Controllers/CollegeController.php:140
      • 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#563db_collegesearch_new1.84msselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (2, 3, 7, 9, 10, 11, 13, 17, 26) and `exam_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:563
      • app/Http/Controllers/CollegeController.php:140
      • 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_new2.11msselect `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` = 14 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 14
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new2.04msselect `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` = 161 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 161
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.46msselect `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:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.48msselect `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` = 2342 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 2342
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new790μsselect `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:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.18msselect `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`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 131
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:564
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#276db_collegesearch_new1.72msselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 16701 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 12 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1
      Bindings
      • 0: 16701
      • 1: cs
      • 2: nirf
      • 3: 12
      • 4: active
      Backtrace
      • app/Models/Institute.php:276
      • app/Http/Controllers/CollegeController.php:574
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#584db_collegesearch_new1.02msselect `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 12 and `institute_id` = 16701) and `id` != '77492' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3
      Bindings
      • 0: 12
      • 1: 16701
      • 2: 77492
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:584
      • app/Http/Controllers/CollegeController.php:140
      • 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#584db_collegesearch_new770μsselect `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (77490, 77491) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:584
      • app/Http/Controllers/CollegeController.php:140
      • 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#588db_collegesearch_new1.37msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 16701 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:588
      • app/Http/Controllers/CollegeController.php:140
      • 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#588db_collegesearch_new800μsselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (61, 68, 105, 127, 139, 742, 772, 832, 833, 911, 930, 1693, 1805, 2118, 2364, 2564, 3298, 4448, 6166)
      Backtrace
      • app/Http/Controllers/CollegeController.php:588
      • app/Http/Controllers/CollegeController.php:140
      • 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#588db_collegesearch_new740μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 4, 6, 12, 13, 15, 21, 24, 28, 29, 47, 70, 108, 212, 345)
      Backtrace
      • app/Http/Controllers/CollegeController.php:588
      • app/Http/Controllers/CollegeController.php:140
      • 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#593db_collegesearch_new1.49msselect `id` from `institute_programs` where `institute_id` = 16701 and `course_id` = 12 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: 12
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:593
      • app/Http/Controllers/CollegeController.php:140
      • 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#601db_collegesearch_new1.21msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (77490, 77491, 77492) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`
      Bindings
      • 0: 77490
      • 1: 77491
      • 2: 77492
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:601
      • app/Http/Controllers/CollegeController.php:140
      • 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#225db_collegesearch_new26.26msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 16701 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: 16701
      • 2: course-fees-program-specific
      • 3: institute
      • 4: active
      Backtrace
      • app/Models/Institute.php:225
      • app/Http/Controllers/CollegeController.php:724
      • app/Http/Controllers/CollegeController.php:140
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#725db_collegesearch_new960μsselect * from `institute_ratings` where `institute_ratings`.`institute_id` = 16701 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:725
      • app/Http/Controllers/CollegeController.php:140
      • 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#726db_collegesearch_new1.15msselect * from `institute_documents` where `institute_documents`.`institute_id` = 16701 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:726
      • app/Http/Controllers/CollegeController.php:140
      • 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#309db_collegesearch_new910μsselect `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '77492' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 77492
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:309
      • app/Http/Controllers/CollegeController.php:159
      • 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#309db_collegesearch_new630μsselect `id`, `name`, `slug` from `courses` where `courses`.`id` in (12) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:309
      • app/Http/Controllers/CollegeController.php:159
      • 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#1038db_collegesearch_new2.26msselect distinct `course_id` from `institute_programs` where `institute_id` = 16701 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 16701
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:1038
      • app/Http/Controllers/CollegeController.php:160
      • 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#1044db_collegesearch_new1.62msselect 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` = 16701
      Bindings
      • 0: 16701
      Backtrace
      • app/Http/Controllers/CollegeController.php:1044
      • app/Http/Controllers/CollegeController.php:160
      • 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#491db_collegesearch_new2.76msselect `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` = 16701 and `expiry_date` > '2025-04-26 12:44:29' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      Bindings
      • 0: %cp%
      • 1: %course-fees-program-specific%
      • 2: 16701
      • 3: 2025-04-26 12:44:29
      Backtrace
      • app/helpers.php:491
      • app/Http/Controllers/CollegeController.php:160
      • 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#506db_collegesearch_new2.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 '%exam%' and `sub_type` like '%about%' and `module_id` in ('2342', '2008', '21', '14', '161', '2198', '131') and `expiry_date` > '2025-04-26 12:44:29' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      Bindings
      • 0: %exam%
      • 1: %about%
      • 2: 2342
      • 3: 2008
      • 4: 21
      • 5: 14
      • 6: 161
      • 7: 2198
      • 8: 131
      • 9: 2025-04-26 12:44:29
      Backtrace
      • app/helpers.php:506
      • app/Http/Controllers/CollegeController.php:160
      • 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#520db_collegesearch_new1.94msselect `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 ('1', '23', '2', '10', '7', '12', '21', '19', '8', '73', '11', '59', '25', '80', '13', '74', '43', '33', '20') and `sub_type` like '%about%' and `expiry_date` > '2025-04-26 12:44:29' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      Bindings
      • 0: %course%
      • 1: 1
      • 2: 23
      • 3: 2
      • 4: 10
      • 5: 7
      • 6: 12
      • 7: 21
      • 8: 19
      • 9: 8
      • 10: 73
      • 11: 11
      • 12: 59
      • 13: 25
      • 14: 80
      • 15: 13
      • 16: 74
      • 17: 43
      • 18: 33
      • 19: 20
      • 20: %about%
      • 21: 2025-04-26 12:44:29
      Backtrace
      • app/helpers.php:520
      • app/Http/Controllers/CollegeController.php:160
      • 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#890db_collegesearch_new1.16msselect * from `meta_tags` where `slug` = 'colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:890
      • app/Http/Controllers/CollegeController.php:192
      • 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#156db_collegesearch_new3.08msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: institute
      • 1: active
      Backtrace
      • app/helpers.php:156
      • 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
    75InstituteProgram.php#?
    App\Models\Program
    49Program.php#?
    App\Models\InstituteProgramFeesSummary
    48InstituteProgramFeesSummary.php#?
    App\Models\InstituteImage
    46InstituteImage.php#?
    App\Models\InstituteProgramPlacement
    26InstituteProgramPlacement.php#?
    App\Models\Course
    21Course.php#?
    App\Models\ExamFeatureMapping
    19ExamFeatureMapping.php#?
    App\Models\InstituteRecruiter
    19InstituteRecruiter.php#?
    App\Models\Recruiter
    19Recruiter.php#?
    App\Models\RecruiterIndustryType
    15RecruiterIndustryType.php#?
    App\Models\InstituteProgramExamMapping
    12InstituteProgramExamMapping.php#?
    App\Models\ExamFeature
    11ExamFeature.php#?
    App\Models\InstituteContent
    5InstituteContent.php#?
    App\Models\InstituteReview
    4InstituteReview.php#?
    App\Models\Exam
    4Exam.php#?
    App\Models\Branding
    3Branding.php#?
    App\Models\User
    2User.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\Degree
    1Degree.php#?
    App\Models\Stream
    1Stream.php#?
    App\Models\InstituteProgramFee
    1InstituteProgramFee.php#?
    App\Models\FeesType
    1FeesType.php#?
    App\Models\InstituteRating
    1InstituteRating.php#?
        _token
        JVEtpBkFdAkoAem2LPyZwMVPIeVYH11usqHPda3T
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/gna-university-hosiarpur/courses-fee...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "www.dev.collegesearch.in" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""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
        []
        
        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 => "Sat, 26 Apr 2025 12:44:29 GMT" ] "set-cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFYYm5vUjJzaGFqczZPNm0rcithL0E9PSIsInZhbHVlIjoiclduejVLZGxQb2xFR1dEdk5PbDNKTjdidXk3VHFmcXFZbkRPc0RvL2hMbjJFRUszL1RUME1NVEE0K0ZJVFdsK0YzS0JsSWt2a2dNVzRLNnVDd2xkdzltREtTVllxL3ZFZXVYZmxCUGhSZE11UXh5WUI0SE9nSEtvNHVWZ1h5UVoiLCJtYWMiOiI4MWRjZGMxNjY0MjdlM2I3OTIwYzQxOTY5MTg5ZjBhZTMyNDFlYmY1NDc1NjA1MDNmYzAwNzgyMTRjMDkyNWVmIiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 14:44:29 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjFYYm5vUjJzaGFqczZPNm0rcithL0E9PSIsInZhbHVlIjoiclduejVLZGxQb2xFR1dEdk5PbDNKTjdidXk3VHFmcXFZbkRPc0RvL2hMbjJFRUszL1RUME1NVEE0K0ZJVFdsK0YzS0JsS" 1 => "laravel_session=eyJpdiI6IktZbEhNVDFKbzFZZkVvSVduR1NidXc9PSIsInZhbHVlIjoiQWhMcnljMzlMeGVRUHBtOVg4V01mVklLd01QY0k0Vk9ZM0NmSDUzTGh1N05rSyttdEtsM2J6bkU3UjFqZnFYYlZ5b3hRbHJaKzdlbzNacGtDZGZoVmphUDQzNlJ4TkRUVjdrRWRSMldOUVl0NFNEUjIyZTIwcktkeHZKVnk0enAiLCJtYWMiOiJkMDM2YzA5MjAwNDBlZTAzZWZjNDQ0ZGNkMDQzMTg5YTM0NWY4OGFjN2UzMGZjYTUwZWNjYTViZWI4M2E0ZWI3IiwidGFnIjoiIn0%3D; expires=Sat, 26 Apr 2025 14:44:29 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6IktZbEhNVDFKbzFZZkVvSVduR1NidXc9PSIsInZhbHVlIjoiQWhMcnljMzlMeGVRUHBtOVg4V01mVklLd01QY0k0Vk9ZM0NmSDUzTGh1N05rSyttdEtsM2J6bkU3UjFqZnFYYlZ5" 2 => "course_id=12; expires=Sun, 26 Apr 2026 12:44:28 GMT; Max-Age=31535999; path=/; samesite=lax" 3 => "course_name=BHM; expires=Sun, 26 Apr 2026 12:44:28 GMT; Max-Age=31535999; path=/; samesite=lax" 4 => "viewed_colleges=%5B16701%5D; expires=Mon, 26 May 2025 12:44:29 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFYYm5vUjJzaGFqczZPNm0rcithL0E9PSIsInZhbHVlIjoiclduejVLZGxQb2xFR1dEdk5PbDNKTjdidXk3VHFmcXFZbkRPc0RvL2hMbjJFRUszL1RUME1NVEE0K0ZJVFdsK0YzS0JsSWt2a2dNVzRLNnVDd2xkdzltREtTVllxL3ZFZXVYZmxCUGhSZE11UXh5WUI0SE9nSEtvNHVWZ1h5UVoiLCJtYWMiOiI4MWRjZGMxNjY0MjdlM2I3OTIwYzQxOTY5MTg5ZjBhZTMyNDFlYmY1NDc1NjA1MDNmYzAwNzgyMTRjMDkyNWVmIiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 14:44:29 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjFYYm5vUjJzaGFqczZPNm0rcithL0E9PSIsInZhbHVlIjoiclduejVLZGxQb2xFR1dEdk5PbDNKTjdidXk3VHFmcXFZbkRPc0RvL2hMbjJFRUszL1RUME1NVEE0K0ZJVFdsK0YzS0JsS" 1 => "laravel_session=eyJpdiI6IktZbEhNVDFKbzFZZkVvSVduR1NidXc9PSIsInZhbHVlIjoiQWhMcnljMzlMeGVRUHBtOVg4V01mVklLd01QY0k0Vk9ZM0NmSDUzTGh1N05rSyttdEtsM2J6bkU3UjFqZnFYYlZ5b3hRbHJaKzdlbzNacGtDZGZoVmphUDQzNlJ4TkRUVjdrRWRSMldOUVl0NFNEUjIyZTIwcktkeHZKVnk0enAiLCJtYWMiOiJkMDM2YzA5MjAwNDBlZTAzZWZjNDQ0ZGNkMDQzMTg5YTM0NWY4OGFjN2UzMGZjYTUwZWNjYTViZWI4M2E0ZWI3IiwidGFnIjoiIn0%3D; expires=Sat, 26-Apr-2025 14:44:29 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6IktZbEhNVDFKbzFZZkVvSVduR1NidXc9PSIsInZhbHVlIjoiQWhMcnljMzlMeGVRUHBtOVg4V01mVklLd01QY0k0Vk9ZM0NmSDUzTGh1N05rSyttdEtsM2J6bkU3UjFqZnFYYlZ5" 2 => "course_id=12; expires=Sun, 26-Apr-2026 12:44:28 GMT; path=/" 3 => "course_name=BHM; expires=Sun, 26-Apr-2026 12:44:28 GMT; path=/" 4 => "viewed_colleges=%5B16701%5D; expires=Mon, 26-May-2025 12:44:29 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "JVEtpBkFdAkoAem2LPyZwMVPIeVYH11usqHPda3T" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-77492" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-26 12:44:29GET/colleges/gna-university-hosiarpur/courses-fees/bhm-bachelor-of-science-in-airlines-tourism-hospitality-7749211266389