B.Sc. in HM Catering Technology & Tourism Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Overview

B.Sc. in HM Catering Technology & Tourism is a 3 year course at Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai. The total fees for B.Sc. in HM Catering Technology & Tourism at Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai is 75,000. To get admission in B.Sc. in HM Catering Technology & Tourism at Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai, students must meet some eligibility requirements, that is Pass is 12th std. of Maharashtra Board of Higher Secondary Education of its equivalent with minimum of 50% marks. This program helps students with the necessary skills to build a successful career in the Hotel Management.

B.Sc. in HM Catering Technology & Tourism Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Highlights

Particular Details
Total Seats N/A
Course Fee 75,000
Duration 3 Years
Accepted Exams CAT, CMAT, GMAT, MAT, NMAT, , NCHMCT JEE

About B.Sc. in HM Catering Technology & Tourism

Program Duration
Full Time ,3 Years

Course Type
UG , Hotel Management

Eligibility
Pass is 12th std. of Maharashtra Board of Higher Secondary Education of its equivalent with minimum of 50% marks Read More

Check Eligibility Brochure

B.Sc. in HM Catering Technology & Tourism Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Fee Structure

B.Sc. in HM Catering Technology & Tourism fees for Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai 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:

B.Sc. in HM Catering Technology & Tourism Fee Breakup

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

B.Sc. in HM Catering Technology & Tourism Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Eligibility

Students who are seeking admission in 3 year BHM B.Sc. in HM Catering Technology & Tourism program at the Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai should meet the following eligibility criteria.

Pass is 12th std. of Maharashtra Board of Higher Secondary Education of its equivalent with minimum of 50% marks

Check Eligibility Brochure
admission

Admission Open

Apply in Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Now!
admission

B.Sc. in HM Catering Technology & Tourism Fee Payment Options

Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai 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 Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai.
  • Candidates need to issue a draft in favor of the university to pay the course fee.
  • The college also accepts Internet banking or payment through debit and credit cards.
  • Candidates can directly transfer money from their bank account to the university's bank account through NEFT, RTGS, and IMPS without physically visiting the Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai campus.
  • Delay in fee payment can cause a fine as per Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai rules and regulations.

Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Fees Inquiry

Contact Information for students to find out more about the Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Fees

  • Contact Number - 27709270,
  • E-mail at: mca602@indiacollegesearch.com
  • Admission Block Address - Dr. D.Y. Patil Vidyanagar, Sector 7, Nerul, New Mumbai

B.Sc. in HM Catering Technology & Tourism Placement in Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai

B.Sc. in HM Catering Technology & Tourism Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Top Recruiters

Taj Group of Hotels Taj Group of Hotels
Oberoi Hotels Oberoi Hotels
Park Hotels Park Hotels
Grand Hyatt Grand Hyatt
View All Recruiters Details

Gallery

6 Images
Quantity Training Kitchen

Quantity Training Kitchen

Quantity Training Kitchen

Quantity Training Kitchen

Auditorium

Auditorium

Computer Lab

Computer Lab

Campus

Campus

campus

campus

View All 6 Images

Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai Program Offered

4.5 B.Sc. in HM Hospitality & Tourism Management
3 Years
Total Fees

₹75,000

Admission 2025
Highest Package

N/A

Brochure
View All Programs

Contact Details

Address

Dr. D.Y. Patil Vidyanagar, Sector 7, Nerul, New Mumbai

College Contact

27XXXXXX70

Email

mcXXXXXXom

Get Contact Details

Dr DY Patil Institute of Hotel Management & Catering Technology, Mumbai

Shortlist

Brochure

Request history8.3.19PHP Version204msRequest Duration3MBMemory UsageGET {type}/{slug}/{tab}/{tab2}Route
  • warninglog[21:06:40] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • Booting (11.76ms)time
  • Application (192ms)time
  • 1 x Application (94.23%)
    192ms
    1 x Booting (5.76%)
    11.76ms
    10 templates were rendered
    • pages.college-profile.descriptiondescription.blade.php#?blade
    • components.breadcrumbbreadcrumb.blade.php#?blade
    • components.navbarnavbar.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-239
    68 statements were executed (7 duplicates)Show only duplicates114ms
    • 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_new8.22msselect * from `seo_redirects` where `redirect_from` = '/university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893' limit 1
      Bindings
      • 0: /university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893
      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_new2.29msselect * from `meta_tags` where `slug` = 'university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893
      • 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_new2.52msselect * 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_new970μ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` = 'dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: active
      • 1: dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai
      • 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.26msselect `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 (4244) 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_new920μsselect `id`, `name` from `programs` where `programs`.`id` in (903, 906) 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_new760μsselect `id`, `name` 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: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.31msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5893, 5894) 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_new850μsselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (5893, 5894) 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_new790μsselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5893, 5894) 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.48msselect `name` from `cities` where `id` = 39 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
      Bindings
      • 0: 39
      • 1: active
      Backtrace
      • app/Models/Institute.php:174
      • app/Http/Controllers/CollegeController.php:349
      • 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_new880μsselect `name` from `states` where `id` = 83 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1
      Bindings
      • 0: 83
      • 1: active
      • 2: 2
      Backtrace
      • app/Models/Institute.php:189
      • app/Http/Controllers/CollegeController.php:349
      • 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#781db_collegesearch_new980μsselect `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 4244 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: 4244
      • 1: course-fees-program-specific
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:781
      • 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
    • CollegeController.php#352db_collegesearch_new720μsselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 4244 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null
      Bindings
      • 0: 4244
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#352db_collegesearch_new1.11msselect `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (1) and `institute_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#817db_collegesearch_new1.14msselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 4244 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: about
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:817
      • app/Http/Controllers/CollegeController.php:353
      • 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#817db_collegesearch_new890μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` is null
      Backtrace
      • app/Http/Controllers/CollegeController.php:817
      • app/Http/Controllers/CollegeController.php:353
      • 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#828db_collegesearch_new1.21msselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 4244 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:828
      • app/Http/Controllers/CollegeController.php:353
      • 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#209db_collegesearch_new1.63msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 4244 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:829
      • app/Http/Controllers/CollegeController.php:353
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
    • CollegeController.php#830db_collegesearch_new2.41msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 4244 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:830
      • app/Http/Controllers/CollegeController.php:353
      • 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#209db_collegesearch_new840μsselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 4244 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:355
      • 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.29msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:359
      • 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.35msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:359
      • 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_new900μsselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:359
      • 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.18msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:359
      • 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_new2.15msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:359
      • 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_new980μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 4244 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: 4244
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:359
      • 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#569db_collegesearch_new840μsselect * from `institute_programs` where `institute_id` = 4244 and `institute_programs`.`id` = '5893' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 4244
      • 1: 5893
      • 2: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.37msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5893) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new640μsselect `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5893) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.04msselect * 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: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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.3msselect * 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: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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.49msselect * 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: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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new710μsselect * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (5893) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.22msselect * from `fees_types` where `fees_types`.`id` in (2)
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.34msselect `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (5893)
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new670μsselect `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21, 23, 26, 57, 93, 131, 2198) and `exams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new1.82msselect * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21, 23, 26, 57, 93, 131) 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: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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • CollegeController.php#569db_collegesearch_new860μsselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (3, 7, 9, 10, 11, 13, 26) and `exam_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • 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
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
    • Exam.php#58db_collegesearch_new1.15msselect `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:570
      • 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.2msselect `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:570
      • 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.6msselect `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` = 93 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 93
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:570
      • 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.27msselect `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` = 26 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 26
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:570
      • 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.17msselect `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:570
      • 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_new990μ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:570
      • 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_new780μsselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 57 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 57
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:570
      • 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_new630μ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:570
      • 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_new860μ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` = 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:570
      • 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#276db_collegesearch_new870μsselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 4244 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: 4244
      • 1: cs
      • 2: nirf
      • 3: 12
      • 4: active
      Backtrace
      • app/Models/Institute.php:276
      • app/Http/Controllers/CollegeController.php:580
      • 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#590db_collegesearch_new1.31msselect `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 12 and `institute_id` = 4244) and `id` != '5893' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3
      Bindings
      • 0: 12
      • 1: 4244
      • 2: 5893
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:590
      • 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#590db_collegesearch_new820μsselect `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5894) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:590
      • 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#594db_collegesearch_new1.1msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 4244 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:594
      • 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#594db_collegesearch_new1.09msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (833, 5020, 5085, 6311)
      Backtrace
      • app/Http/Controllers/CollegeController.php:594
      • 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#594db_collegesearch_new670μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (24)
      Backtrace
      • app/Http/Controllers/CollegeController.php:594
      • 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#599db_collegesearch_new1.45msselect `id` from `institute_programs` where `institute_id` = 4244 and `course_id` = 12 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: 12
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:599
      • 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#607db_collegesearch_new1.17msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (5893, 5894) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`
      Bindings
      • 0: 5893
      • 1: 5894
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:607
      • 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#225db_collegesearch_new26.47msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 4244 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: 4244
      • 2: course-fees-program-specific
      • 3: institute
      • 4: active
      Backtrace
      • app/Models/Institute.php:225
      • 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
    • CollegeController.php#731db_collegesearch_new1.28msselect * from `institute_ratings` where `institute_ratings`.`institute_id` = 4244 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 4244
      • 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#732db_collegesearch_new1.2msselect * from `institute_documents` where `institute_documents`.`institute_id` = 4244 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:732
      • 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#315db_collegesearch_new680μsselect `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '5893' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 5893
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:315
      • 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#315db_collegesearch_new650μ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:315
      • 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#1044db_collegesearch_new1.63msselect distinct `course_id` from `institute_programs` where `institute_id` = 4244 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 4244
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:1044
      • 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#1050db_collegesearch_new1.05msselect 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` = 4244
      Bindings
      • 0: 4244
      Backtrace
      • app/Http/Controllers/CollegeController.php:1050
      • 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.26msselect `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` = 4244 and `expiry_date` > '2025-06-02 21:06:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      Bindings
      • 0: %cp%
      • 1: %course-fees-program-specific%
      • 2: 4244
      • 3: 2025-06-02 21:06:40
      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.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 '%exam%' and `sub_type` like '%about%' and `module_id` in ('21', '93', '26', '23', '57', '2198', '131', '58') and `expiry_date` > '2025-06-02 21:06:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      Bindings
      • 0: %exam%
      • 1: %about%
      • 2: 21
      • 3: 93
      • 4: 26
      • 5: 23
      • 6: 57
      • 7: 2198
      • 8: 131
      • 9: 58
      • 10: 2025-06-02 21:06:40
      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_new2msselect `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 ('12') and `sub_type` like '%about%' and `expiry_date` > '2025-06-02 21:06:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      Bindings
      • 0: %course%
      • 1: 12
      • 2: %about%
      • 3: 2025-06-02 21:06:40
      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#896db_collegesearch_new890μsselect * from `meta_tags` where `slug` = 'university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:896
      • 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_new860μsselect * 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\InstituteProgramExamMapping
    15InstituteProgramExamMapping.php#?
    App\Models\ExamFeatureMapping
    15ExamFeatureMapping.php#?
    App\Models\DefaultMetaTag
    13DefaultMetaTag.php#?
    App\Models\InstituteImage
    12InstituteImage.php#?
    App\Models\ExamFeature
    10ExamFeature.php#?
    App\Models\InstituteProgram
    8InstituteProgram.php#?
    App\Models\Exam
    6Exam.php#?
    App\Models\InstituteProgramFeesSummary
    4InstituteProgramFeesSummary.php#?
    App\Models\InstituteProgramPlacement
    4InstituteProgramPlacement.php#?
    App\Models\InstituteRecruiter
    4InstituteRecruiter.php#?
    App\Models\Recruiter
    4Recruiter.php#?
    App\Models\Course
    3Course.php#?
    App\Models\Branding
    3Branding.php#?
    App\Models\Program
    2Program.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#?
    App\Models\RecruiterIndustryType
    1RecruiterIndustryType.php#?
        _token
        XBlcALCvhYFi4IhKmBQy6thIuMXsX20FwfKy7KaF
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/university/dr-dy-patil-institute-of-hotel-man...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893
        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=eyJpdiI6InVhTGhxMUZNSEFWTDNsWUo1dTRxRHc9PSIsInZhbHVlIjoiMGhSNjBJVmhpaWs0eFh0TFEvRXBkQXlDRjMxc0p3ZkpKYmpmeW0rWDFMUUxGQWhtdnNvREdYY3hRUzJ0d0xjWGlpWnRTVUtMMjkrWmdld3hTc1YyVVhVRTQ4Y21SNDc5dytaSDllYmNHOXp1QjRjdHA4SlBuSXo3M0lIZXRRdHkiLCJtYWMiOiI5Njk2MWIzNjRkNDFkYTk5NzU3NzM3NTVlZTdjZDYzMDVhZDgxMWU1OTIwZTQyODE3YmIzODc2OTcxNmJmMGRlIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IktlVThTRlpoN1I3UHpwWXlIeHVHOUE9PSIsInZhbHVlIjoidjBDRlNKWjFEbTJndU51UXg4Y1JsSXV2bFJpTFBaUzJXdVhKSlhoNG51blZHV3hiNnN1S25RUjZJU0swODUxZkRBNVFMd0FMRE1ia0NMaDBWZEN6Wndqc1ZweHVQY3Btc29hYWYzQTJST1VVSVdVeXpTUEVZZVplVlVBaFUzNTQiLCJtYWMiOiI1MGRlZmU0N2UwNTUyNmE5ODNkMjVlYTVkZDk3Y2MyMmVmYjc2OWNmNDg1MWM0MjM3ZTFjY2FjZWViMmY5N2E2IiwidGFnIjoiIn0%3D; course_id=11; course_name=B.Pharm; viewed_colleges=%5B2536%2C16085%2C10104%5DXSRF-TOKEN=eyJpdiI6InVhTGhxMUZNSEFWTDNsWUo1dTRxRHc9PSIsInZhbHVlIjoiMGhSNjBJVmhpaWs0eFh0TFEvRXBkQXlDRjMxc0p3ZkpKYmpmeW0rWDFMUUxGQWhtdnNvREdYY3hRUzJ0d0xjWGlpWnRTV" ] "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" => "XBlcALCvhYFi4IhKmBQy6thIuMXsX20FwfKy7KaF" "laravel_session" => "xAM4sIoAeCrBP20BE43u8Y3FzLaQJXiwcXDXyTWe" "course_id" => "11" "course_name" => "B.Pharm" "viewed_colleges" => "[2536,16085,10104]" ]
        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, 02 Jun 2025 21:06:40 GMT" ] "set-cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhabTd5bG51L0ZhRTlhUzNpb3NkeFE9PSIsInZhbHVlIjoiRGZBVE43RTZBWjJUQkNnUUVRT205VlhPTmVNVHN3YXYxaG55dmNMbUQ5SW1xR1FaSDk1cFFMcjNGN2diQWYzelk5Qkh2VHBlTmNSdjBrR3BYSVdVQjZXbEpkbklnS0ZxWGh0ZlR6SVQ1UFZoMWZ3TSszWXRvRHE4OWw3ZVhKRXkiLCJtYWMiOiI1NjAwYWUxZWJhY2VmNjJkOGRlYWRlNWNjNTJlNWVlMDYwOTQ3MDE3MDYyZGUxZDUwZTYyOTE1YmVjMjEyZjY3IiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 23:06:40 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkhabTd5bG51L0ZhRTlhUzNpb3NkeFE9PSIsInZhbHVlIjoiRGZBVE43RTZBWjJUQkNnUUVRT205VlhPTmVNVHN3YXYxaG55dmNMbUQ5SW1xR1FaSDk1cFFMcjNGN2diQWYzelk5Qkh2V" 1 => "laravel_session=eyJpdiI6InVPUHRmYmFOc2RvZml1VVovZlVVVmc9PSIsInZhbHVlIjoiMW12c0ROS242bVVZdWVUc09XTVhaVDh6eVlHaXBVRnowMDdtc0x2UStyL1MwMWxaM2pJNkV5NVF2ZGN5NmZnVUVRYzhjbzRBa1B0eVZCRDVvWk5pR3VOYS9QR1IvODFkT2lrZXRITzN1b0ZZRktvYm56Z1dmdGJLRVk3ZWk4eUsiLCJtYWMiOiIxOGI2ZDgzNGJmMDMwMDFmNWIyMzI3MWM4ZDJkMjE0NzU2MWRhNTQ0NWYwZTBlMzNhZDI2MmNjY2UyMzUwY2FkIiwidGFnIjoiIn0%3D; expires=Mon, 02 Jun 2025 23:06:40 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6InVPUHRmYmFOc2RvZml1VVovZlVVVmc9PSIsInZhbHVlIjoiMW12c0ROS242bVVZdWVUc09XTVhaVDh6eVlHaXBVRnowMDdtc0x2UStyL1MwMWxaM2pJNkV5NVF2ZGN5NmZnVUVR" 2 => "course_id=12; expires=Tue, 02 Jun 2026 21:06:40 GMT; Max-Age=31536000; path=/; samesite=lax" 3 => "course_name=BHM; expires=Tue, 02 Jun 2026 21:06:40 GMT; Max-Age=31536000; path=/; samesite=lax" 4 => "viewed_colleges=%5B2536%2C16085%2C10104%2C4244%5D; expires=Wed, 02 Jul 2025 21:06:40 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhabTd5bG51L0ZhRTlhUzNpb3NkeFE9PSIsInZhbHVlIjoiRGZBVE43RTZBWjJUQkNnUUVRT205VlhPTmVNVHN3YXYxaG55dmNMbUQ5SW1xR1FaSDk1cFFMcjNGN2diQWYzelk5Qkh2VHBlTmNSdjBrR3BYSVdVQjZXbEpkbklnS0ZxWGh0ZlR6SVQ1UFZoMWZ3TSszWXRvRHE4OWw3ZVhKRXkiLCJtYWMiOiI1NjAwYWUxZWJhY2VmNjJkOGRlYWRlNWNjNTJlNWVlMDYwOTQ3MDE3MDYyZGUxZDUwZTYyOTE1YmVjMjEyZjY3IiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 23:06:40 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkhabTd5bG51L0ZhRTlhUzNpb3NkeFE9PSIsInZhbHVlIjoiRGZBVE43RTZBWjJUQkNnUUVRT205VlhPTmVNVHN3YXYxaG55dmNMbUQ5SW1xR1FaSDk1cFFMcjNGN2diQWYzelk5Qkh2V" 1 => "laravel_session=eyJpdiI6InVPUHRmYmFOc2RvZml1VVovZlVVVmc9PSIsInZhbHVlIjoiMW12c0ROS242bVVZdWVUc09XTVhaVDh6eVlHaXBVRnowMDdtc0x2UStyL1MwMWxaM2pJNkV5NVF2ZGN5NmZnVUVRYzhjbzRBa1B0eVZCRDVvWk5pR3VOYS9QR1IvODFkT2lrZXRITzN1b0ZZRktvYm56Z1dmdGJLRVk3ZWk4eUsiLCJtYWMiOiIxOGI2ZDgzNGJmMDMwMDFmNWIyMzI3MWM4ZDJkMjE0NzU2MWRhNTQ0NWYwZTBlMzNhZDI2MmNjY2UyMzUwY2FkIiwidGFnIjoiIn0%3D; expires=Mon, 02-Jun-2025 23:06:40 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6InVPUHRmYmFOc2RvZml1VVovZlVVVmc9PSIsInZhbHVlIjoiMW12c0ROS242bVVZdWVUc09XTVhaVDh6eVlHaXBVRnowMDdtc0x2UStyL1MwMWxaM2pJNkV5NVF2ZGN5NmZnVUVR" 2 => "course_id=12; expires=Tue, 02-Jun-2026 21:06:40 GMT; path=/" 3 => "course_name=BHM; expires=Tue, 02-Jun-2026 21:06:40 GMT; path=/" 4 => "viewed_colleges=%5B2536%2C16085%2C10104%2C4244%5D; expires=Wed, 02-Jul-2025 21:06:40 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "XBlcALCvhYFi4IhKmBQy6thIuMXsX20FwfKy7KaF" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-5893https://www.dev.collegesearch.in/university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-touris" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-06-02 21:06:40GET/university/dr-dy-patil-institute-of-hotel-management-catering-technology-mumbai/courses-fees/bhm-bhm-catering-technology-tourism-589311068116