Bachelor of Science (B.Sc) Hospitality and Hotel Administration Saraswati College of Management & Computer Science, Mohali Overview

Bachelor of Science (B.Sc) Hospitality and Hotel Administration is a 3 year course at Saraswati College of Management & Computer Science, Mohali. The total fees for Bachelor of Science (B.Sc) Hospitality and Hotel Administration at Saraswati College of Management & Computer Science, Mohali is 75,000. To get admission in Bachelor of Science (B.Sc) Hospitality and Hotel Administration at Saraswati College of Management & Computer Science, Mohali, students must meet some eligibility requirements, that is 10+2 or any other equivalent in any stream (45% Marks). This program helps students with the necessary skills to build a successful career in the Science.

Bachelor of Science (B.Sc) Hospitality and Hotel Administration Saraswati College of Management & Computer Science, Mohali Highlights

Particular Details
Total Seats N/A
Course Fee 75,000
Duration 3 Years
Accepted Exams CAT, MAT, TANCET, XAT, TNEA, CBSE 12th Board Exam, CUET

About Bachelor of Science (B.Sc) Hospitality and Hotel Administration

Program Duration
Full Time ,3 Years

Course Type
UG , Science

Eligibility
10+2 or any other equivalent in any stream (45% Marks) Read More

Check Eligibility Brochure

Bachelor of Science (B.Sc) Hospitality and Hotel Administration Saraswati College of Management & Computer Science, Mohali Fee Structure

Bachelor of Science (B.Sc) Hospitality and Hotel Administration fees for Saraswati College of Management & Computer Science, Mohali 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 (B.Sc) Hospitality and Hotel Administration Fee Breakup

Fees (Rs.) Year 1
Tuition Fees ₹ 75,000

Bachelor of Science (B.Sc) Hospitality and Hotel Administration Saraswati College of Management & Computer Science, Mohali Eligibility

Students who are seeking admission in 3 year BSc Bachelor of Science (B.Sc) Hospitality and Hotel Administration program at the Saraswati College of Management & Computer Science, Mohali should meet the following eligibility criteria.

10+2 or any other equivalent in any stream (45% Marks)

Check Eligibility Brochure

Popular Exams

Exam Month

November

Accepting Colleges
Last Date to Apply

29th November, 2025

Apply Now
Exam Month

March

Accepting Colleges
Last Date to Apply

09th March, 2025

Apply Now
Exam Month

March

Accepting Colleges
Last Date to Apply

22nd March, 2025

Apply Now
Exam Month

January

Accepting Colleges
Last Date to Apply

05th January, 2025

Apply Now
Exam Month

N/A

Accepting Colleges
Last Date to Apply

N/A

Apply Now
Exam Month

N/A

Accepting Colleges
Last Date to Apply

N/A

Apply Now
Exam Month

May

Accepting Colleges
Last Date to Apply

08th May, 2025

Apply Now
admission

Admission Open

Apply in Saraswati College of Management & Computer Science, Mohali Now!
admission

Bachelor of Science (B.Sc) Hospitality and Hotel Administration Fee Payment Options

Saraswati College of Management & Computer Science, Mohali 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 Saraswati College of Management & Computer Science, Mohali.
  • 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 Saraswati College of Management & Computer Science, Mohali campus.
  • Delay in fee payment can cause a fine as per Saraswati College of Management & Computer Science, Mohali rules and regulations.

Saraswati College of Management & Computer Science, Mohali Fees Inquiry

Contact Information for students to find out more about the Saraswati College of Management & Computer Science, Mohali Fees

  • Contact Number - 9041002246, 9041002246
  • E-mail at: sgcmohali@gmail.com
  • Admission Block Address - Gharuan, Kharar-Morinda Road

Saraswati College of Management & Computer Science, Mohali Program Offered

View All Programs

Contact Details

Address

Gharuan, Kharar-Morinda Road

College Contact

90XXXXXX46

Email

sgXXXXXXom

Get Contact Details

Saraswati College of Management & Computer Science, Mohali

Shortlist

Brochure

Request history8.3.19PHP Version233msRequest Duration4MBMemory UsageGET {type}/{slug}/{tab}/{tab2}Route
  • warninglog[10:55:51] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • Booting (28.93ms)time
  • Application (205ms)time
  • 1 x Application (87.6%)
    205ms
    1 x Booting (12.39%)
    28.93ms
    11 templates were rendered
    • pages.college-profile.descriptiondescription.blade.php#?blade
    • components.breadcrumbbreadcrumb.blade.php#?blade
    • components.navbarnavbar.blade.php#?blade
    • components.videoslistingvideoslisting.blade.php#?blade
    • components.registrationregistration.blade.php#?blade
    • layouts.webweb.blade.php#?blade
    • partials.headhead.blade.php#?blade
    • partials.headerheader.blade.php#?blade
    • partials.footerfooter.blade.php#?blade
    • components.sucessesModalsucessesModal.blade.php#?blade
    • partials.bottomfooterbottomfooter.blade.php#?blade
    uri
    GET {type}/{slug}/{tab}/{tab2}
    middleware
    web
    domain
    www.dev.collegesearch.in
    controller
    App\Http\Controllers\CollegeController@description
    as
    colleges_university.profile.tabs2
    namespace
    prefix
    /{type}
    where
    file
    app/Http/Controllers/CollegeController.php:110-238
    68 statements were executed (9 duplicates)Show only duplicates118ms
    • 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.39msselect * from `seo_redirects` where `redirect_from` = '/colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680' limit 1
      Bindings
      • 0: /colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680
      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.88msselect * from `meta_tags` where `slug` = 'colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680
      • 1: active
      Backtrace
      • app/Http/Middleware/MetaChecker.php:20
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • app/Http/Middleware/SoftRedirects.php:28
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
    • helpers.php#722db_collegesearch_new1.72msselect * from `default_meta_tags` where `module` = 'college' and `default_meta_tags`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: college
      • 1: active
      Backtrace
      • app/helpers.php:722
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:989
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:819
      • vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048
      • vendor/laravel/framework/src/Illuminate/Container/Container.php:755
    • CollegeController.php#135db_collegesearch_new1.02msselect `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` = 'saraswati-college-of-management-computer-science-mohali' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: active
      • 1: saraswati-college-of-management-computer-science-mohali
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.43msselect `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 (9573) and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.01msselect `id`, `name` from `programs` where `programs`.`id` in (954, 3423, 3449, 3450, 3458, 3551, 3588, 3591) and `programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new860μsselect `id`, `name` from `courses` where `courses`.`id` in (7, 8, 12, 13, 21, 23, 25) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.44msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15680, 62639, 62640, 62641, 62642, 62643, 62644, 62645) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new950μsselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (15680, 62639, 62640, 62641, 62642, 62643, 62644, 62645) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.2msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (15680, 62639, 62640, 62641, 62642, 62643, 62644, 62645) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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.44msselect `name` from `cities` where `id` = 196 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
      Bindings
      • 0: 196
      • 1: active
      Backtrace
      • app/Models/Institute.php:174
      • app/Http/Controllers/CollegeController.php:348
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#189db_collegesearch_new1.09msselect `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:348
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#780db_collegesearch_new3.23msselect `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 9573 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: 9573
      • 1: course-fees-program-specific
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:780
      • app/Http/Controllers/CollegeController.php:350
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#351db_collegesearch_new690μsselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 9573 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null
      Bindings
      • 0: 9573
      Backtrace
      • app/Http/Controllers/CollegeController.php:351
      • app/Http/Controllers/CollegeController.php:145
      • 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#351db_collegesearch_new690μ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:351
      • app/Http/Controllers/CollegeController.php:145
      • 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#816db_collegesearch_new890μsselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 9573 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 9573
      • 1: about
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:816
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#816db_collegesearch_new910μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261) and `admins`.`deleted_at` is null
      Backtrace
      • app/Http/Controllers/CollegeController.php:816
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#827db_collegesearch_new780μsselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 9573 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:827
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#210db_collegesearch_new910μsselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 9573 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Models/Institute.php:210
      • app/Http/Controllers/CollegeController.php:828
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
    • CollegeController.php#829db_collegesearch_new2.12msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 9573 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:829
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#210db_collegesearch_new1.82msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 9573 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Models/Institute.php:210
      • app/Http/Controllers/CollegeController.php:354
      • app/Http/Controllers/CollegeController.php:145
      • 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` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.39msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • 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` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new950μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.42msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.19msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 9573 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: 9573
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#568db_collegesearch_new1.25msselect * from `institute_programs` where `institute_id` = 9573 and `institute_programs`.`id` = '15680' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 9573
      • 1: 15680
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.41msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (15680) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new900μsselect `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15680) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new660μsselect * from `courses` where `courses`.`id` in (23) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new970μsselect * 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:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.06msselect * from `streams` where `streams`.`id` in (5) and `streams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 5
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new790μsselect * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (15680) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new790μsselect * from `fees_types` where `fees_types`.`id` in (2)
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.04msselect `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (15680)
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.09msselect `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21, 22, 23, 184, 2008, 2240, 2342) and `exams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.62msselect * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21, 22, 23, 184, 2008, 2240, 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:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new620μsselect `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:568
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • Exam.php#58db_collegesearch_new1.69msselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 21 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 21
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.09msselect `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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.52msselect `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`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 23
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new760μ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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new760μ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` = 184 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 184
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new840μ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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new1.61msselect `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` = 22 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 22
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new620μ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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new720μ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` = 2240 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 2240
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new770μ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`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 2008
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new890μ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` = 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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new950μ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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#277db_collegesearch_new1.57msselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 9573 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 23 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1
      Bindings
      • 0: 9573
      • 1: cs
      • 2: nirf
      • 3: 23
      • 4: active
      Backtrace
      • app/Models/Institute.php:277
      • app/Http/Controllers/CollegeController.php:579
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#589db_collegesearch_new900μsselect `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 23 and `institute_id` = 9573) and `id` != '15680' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3
      Bindings
      • 0: 23
      • 1: 9573
      • 2: 15680
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:589
      • app/Http/Controllers/CollegeController.php:145
      • 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.16msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 9573 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:593
      • app/Http/Controllers/CollegeController.php:145
      • 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#598db_collegesearch_new860μsselect `id` from `institute_programs` where `institute_id` = 9573 and `course_id` = 23 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 9573
      • 1: 23
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:598
      • app/Http/Controllers/CollegeController.php:145
      • 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#606db_collegesearch_new850μsselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (15680) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`
      Bindings
      • 0: 15680
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:606
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • Institute.php#226db_collegesearch_new25.96msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 9573 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: 9573
      • 2: course-fees-program-specific
      • 3: institute
      • 4: active
      Backtrace
      • app/Models/Institute.php:226
      • app/Http/Controllers/CollegeController.php:729
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#730db_collegesearch_new1.25msselect * from `institute_ratings` where `institute_ratings`.`institute_id` = 9573 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:730
      • app/Http/Controllers/CollegeController.php:145
      • 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#731db_collegesearch_new3.31msselect * from `institute_documents` where `institute_documents`.`institute_id` = 9573 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:731
      • app/Http/Controllers/CollegeController.php:145
      • 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#314db_collegesearch_new1.3msselect `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '15680' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 15680
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:314
      • app/Http/Controllers/CollegeController.php:164
      • 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#314db_collegesearch_new810μsselect `id`, `name`, `slug` from `courses` where `courses`.`id` in (23) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:314
      • app/Http/Controllers/CollegeController.php:164
      • 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#1043db_collegesearch_new1.24msselect distinct `course_id` from `institute_programs` where `institute_id` = 9573 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 9573
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:1043
      • app/Http/Controllers/CollegeController.php:165
      • 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#1049db_collegesearch_new1msselect 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` = 9573
      Bindings
      • 0: 9573
      Backtrace
      • app/Http/Controllers/CollegeController.php:1049
      • app/Http/Controllers/CollegeController.php:165
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#496db_collegesearch_new2.09msselect `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` = 9573 and `expiry_date` > '2025-06-16 10:55:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      Bindings
      • 0: %cp%
      • 1: %course-fees-program-specific%
      • 2: 9573
      • 3: 2025-06-16 10:55:51
      Backtrace
      • app/helpers.php:496
      • app/Http/Controllers/CollegeController.php:165
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#511db_collegesearch_new2.98msselect `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 ('21', '23', '184', '22', '2240', '2008', '2342', '2198', '131') and `expiry_date` > '2025-06-16 10:55:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      Bindings
      • 0: %exam%
      • 1: %about%
      • 2: 21
      • 3: 23
      • 4: 184
      • 5: 22
      • 6: 2240
      • 7: 2008
      • 8: 2342
      • 9: 2198
      • 10: 131
      • 11: 2025-06-16 10:55:51
      Backtrace
      • app/helpers.php:511
      • app/Http/Controllers/CollegeController.php:165
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#525db_collegesearch_new2.59msselect `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 ('23', '7', '13', '21', '12', '8', '25') and `sub_type` like '%about%' and `expiry_date` > '2025-06-16 10:55:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      Bindings
      • 0: %course%
      • 1: 23
      • 2: 7
      • 3: 13
      • 4: 21
      • 5: 12
      • 6: 8
      • 7: 25
      • 8: %about%
      • 9: 2025-06-16 10:55:51
      Backtrace
      • app/helpers.php:525
      • app/Http/Controllers/CollegeController.php:165
      • 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#895db_collegesearch_new1.25msselect * from `meta_tags` where `slug` = 'colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:895
      • app/Http/Controllers/CollegeController.php:197
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • helpers.php#157db_collegesearch_new4.02msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: institute
      • 1: active
      Backtrace
      • app/helpers.php:157
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • vendor/laravel/framework/src/Illuminate/View/View.php:209
    App\Models\ExamFeatureMapping
    32ExamFeatureMapping.php#?
    App\Models\InstituteProgram
    18InstituteProgram.php#?
    App\Models\InstituteProgramExamMapping
    16InstituteProgramExamMapping.php#?
    App\Models\ExamFeature
    14ExamFeature.php#?
    App\Models\DefaultMetaTag
    13DefaultMetaTag.php#?
    App\Models\Course
    9Course.php#?
    App\Models\InstituteProgramFeesSummary
    9InstituteProgramFeesSummary.php#?
    App\Models\Program
    8Program.php#?
    App\Models\Exam
    7Exam.php#?
    App\Models\Branding
    3Branding.php#?
    App\Models\Institute
    1Institute.php#?
    App\Models\City
    1City.php#?
    App\Models\State
    1State.php#?
    App\Models\InstituteFeatureMapping
    1InstituteFeatureMapping.php#?
    App\Models\InstituteFeature
    1InstituteFeature.php#?
    App\Models\InstituteContent
    1InstituteContent.php#?
    App\Models\Admin
    1Admin.php#?
    App\Models\InstituteFaculty
    1InstituteFaculty.php#?
    App\Models\Degree
    1Degree.php#?
    App\Models\Stream
    1Stream.php#?
    App\Models\InstituteProgramFee
    1InstituteProgramFee.php#?
    App\Models\FeesType
    1FeesType.php#?
        _token
        5DW2arTH4JhUiEfpu1IiVZDHQF3L0J1hkw1YAEwd
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/saraswati-college-of-management-comp...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680
        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=eyJpdiI6Ims3UWZhMGVNZ0NYNnF3TDBwL1JaZkE9PSIsInZhbHVlIjoiOWtvM1liNDNyNG4zMTFOTVk3UU1Xb1BqR2VURUpJMjBtRFFyMnZ6VGFDam5SS2JNSTdFL3pocmwrUEl4bThLTkdqZ1A2cUtyeUV0N05zdjJRcDRvWlM0QkROTkRldllaNm5CN1NFWENJanlMck43cjdEYU1zOXVVT3ppNHlOTHgiLCJtYWMiOiI5MWE4N2RmN2U4MWQzODViNzUzNDMyNzk5MTAyODY2YzFlZGIzY2U2MDg5MWIzNzY0NWI2YjY0ZGJkYWIyZmIyIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkVpVElZdHdzUXdHUXRBMGU0SnFJSmc9PSIsInZhbHVlIjoiZnpNMVd0VFNhczg4RGM1UUpPUXJmeVVrdldyV1RHdFI0YmRJMUY4RWgycGltRWFZb3lia0g3a1NRTTFualg4ZGV0bkJOeFVZY1ZxVXJubnZIRlFOM08rTXhvTHpRdG9SM09oRFUrRDVHdnA5MHMvMnYzYkNtRTlFL1k5ZEJaVGgiLCJtYWMiOiI5YjdkNjVmYzIzMWY0YWM5NGRhNzQ1MDQ3ZjlkMGU5ODhjYjBiNGIxZWIwMzYwNzQxNGJjZjM0MzQ1ZTMxNzE1IiwidGFnIjoiIn0%3D; course_id=23; course_name=BSc; viewed_colleges=%5B35402%2C13150%2C39696%5DXSRF-TOKEN=eyJpdiI6Ims3UWZhMGVNZ0NYNnF3TDBwL1JaZkE9PSIsInZhbHVlIjoiOWtvM1liNDNyNG4zMTFOTVk3UU1Xb1BqR2VURUpJMjBtRFFyMnZ6VGFDam5SS2JNSTdFL3pocmwrUEl4bThLTkdqZ1A2c" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:5 [ "XSRF-TOKEN" => "5DW2arTH4JhUiEfpu1IiVZDHQF3L0J1hkw1YAEwd" "laravel_session" => "Yoi8Zo3rAwUEmob8i9UFu4aDNEYxuof5U6iZyHnM" "course_id" => "23" "course_name" => "BSc" "viewed_colleges" => "[35402,13150,39696]" ]
        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 => "Mon, 16 Jun 2025 10:55:51 GMT" ] "set-cookie" => array:4 [ 0 => "XSRF-TOKEN=eyJpdiI6ImdybFRRcUhRZm0vT1czZi83TWtnN2c9PSIsInZhbHVlIjoieC9sL2swWjY0MXZoZmpGRjkyNEUza20wOEVkQTFtWnBuVElHNGVTWVladDA5QVRhYVJYM0RWRjdOMEw0bzRUVlI0aXhNVWpZU2FuMVZNZUUrS1M5b2ZjcUhhaUVNYTlyTHE2NGdjcEd2SjdJTVNFRzkvSHZXNFh0bEFBRnFwVFkiLCJtYWMiOiJiOTE5NWEyZjRkNzI5NDRlMmE4MTExOTZlNTBmZGQxNTBiYjk2NzhhMzhlZmU1OTA1OTllZGQxZjJlMDI5NDcyIiwidGFnIjoiIn0%3D; expires=Mon, 16 Jun 2025 12:55:51 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImdybFRRcUhRZm0vT1czZi83TWtnN2c9PSIsInZhbHVlIjoieC9sL2swWjY0MXZoZmpGRjkyNEUza20wOEVkQTFtWnBuVElHNGVTWVladDA5QVRhYVJYM0RWRjdOMEw0bzRUVlI0aXhNV" 1 => "laravel_session=eyJpdiI6InYwbFJlODdSeFV0d1VSV0V5blJWTnc9PSIsInZhbHVlIjoiQVpLcmNyQUhsVjJWRlRYV2oxY3hTZUR3ZGhNQXplbURoLytEMXllTWNLMXlNeFBIUmJEZWE5THpxUUdKN3lkZlJWNURpVDgvMjFXVHZBeGFnUU5UNGFBYldxazQ0ZzRNMmc3Q3dXNlcrS1Y0emlCeTBJNzZ1b1loTDFITjgxMjgiLCJtYWMiOiI0MTIwZGU0MDc0NGNjNmMyMTM2ZmIyZjBkYWQyNjI4MDA3NzEyNTZmNzRmODMzNjg5NmVhYzk3NzM1OWYyZjc3IiwidGFnIjoiIn0%3D; expires=Mon, 16 Jun 2025 12:55:51 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6InYwbFJlODdSeFV0d1VSV0V5blJWTnc9PSIsInZhbHVlIjoiQVpLcmNyQUhsVjJWRlRYV2oxY3hTZUR3ZGhNQXplbURoLytEMXllTWNLMXlNeFBIUmJEZWE5THpxUUdKN3lkZlJW" 2 => "course_id=23; expires=Tue, 16 Jun 2026 10:55:50 GMT; Max-Age=31535999; path=/; samesite=lax" 3 => "viewed_colleges=%5B35402%2C13150%2C39696%2C9573%5D; expires=Wed, 16 Jul 2025 10:55:51 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:4 [ 0 => "XSRF-TOKEN=eyJpdiI6ImdybFRRcUhRZm0vT1czZi83TWtnN2c9PSIsInZhbHVlIjoieC9sL2swWjY0MXZoZmpGRjkyNEUza20wOEVkQTFtWnBuVElHNGVTWVladDA5QVRhYVJYM0RWRjdOMEw0bzRUVlI0aXhNVWpZU2FuMVZNZUUrS1M5b2ZjcUhhaUVNYTlyTHE2NGdjcEd2SjdJTVNFRzkvSHZXNFh0bEFBRnFwVFkiLCJtYWMiOiJiOTE5NWEyZjRkNzI5NDRlMmE4MTExOTZlNTBmZGQxNTBiYjk2NzhhMzhlZmU1OTA1OTllZGQxZjJlMDI5NDcyIiwidGFnIjoiIn0%3D; expires=Mon, 16-Jun-2025 12:55:51 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImdybFRRcUhRZm0vT1czZi83TWtnN2c9PSIsInZhbHVlIjoieC9sL2swWjY0MXZoZmpGRjkyNEUza20wOEVkQTFtWnBuVElHNGVTWVladDA5QVRhYVJYM0RWRjdOMEw0bzRUVlI0aXhNV" 1 => "laravel_session=eyJpdiI6InYwbFJlODdSeFV0d1VSV0V5blJWTnc9PSIsInZhbHVlIjoiQVpLcmNyQUhsVjJWRlRYV2oxY3hTZUR3ZGhNQXplbURoLytEMXllTWNLMXlNeFBIUmJEZWE5THpxUUdKN3lkZlJWNURpVDgvMjFXVHZBeGFnUU5UNGFBYldxazQ0ZzRNMmc3Q3dXNlcrS1Y0emlCeTBJNzZ1b1loTDFITjgxMjgiLCJtYWMiOiI0MTIwZGU0MDc0NGNjNmMyMTM2ZmIyZjBkYWQyNjI4MDA3NzEyNTZmNzRmODMzNjg5NmVhYzk3NzM1OWYyZjc3IiwidGFnIjoiIn0%3D; expires=Mon, 16-Jun-2025 12:55:51 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6InYwbFJlODdSeFV0d1VSV0V5blJWTnc9PSIsInZhbHVlIjoiQVpLcmNyQUhsVjJWRlRYV2oxY3hTZUR3ZGhNQXplbURoLytEMXllTWNLMXlNeFBIUmJEZWE5THpxUUdKN3lkZlJW" 2 => "course_id=23; expires=Tue, 16-Jun-2026 10:55:50 GMT; path=/" 3 => "viewed_colleges=%5B35402%2C13150%2C39696%2C9573%5D; expires=Wed, 16-Jul-2025 10:55:51 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "5DW2arTH4JhUiEfpu1IiVZDHQF3L0J1hkw1YAEwd" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-15680https://www.dev.collegesearch.in/colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-1568" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-16 10:55:51GET/colleges/saraswati-college-of-management-computer-science-mohali/courses-fees/bsc-bsc-hospitality-and-hotel-administration-1568011168141