Bachelor in Hotel Management (BHM) Bakery and Confectionery in AIMS Institutes, Bangalore Fees Breakup, Total Fees, Eligibility.

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Overview

Bachelor in Hotel Management (BHM) Bakery and Confectionery is a 4 year course at AIMS Institutes, Bangalore. The total fees for Bachelor in Hotel Management (BHM) Bakery and Confectionery at AIMS Institutes, Bangalore is 4,70,000. To get admission in Bachelor in Hotel Management (BHM) Bakery and Confectionery at AIMS Institutes, Bangalore, students must meet some eligibility requirements, that is The candidate seeking admission in the BHM from AIMS Bangalore should have done XII from a recognized institute.. This program helps students with the necessary skills to build a successful career in the Hotel Management.

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Highlights

Particular	Details
Total Seats	120
Course Fee	4,70,000
Duration	4 Years
Accepted Exams	GATE, , , NCHMCT JEE

About Bachelor in Hotel Management (BHM) Bakery and Confectionery

Program Duration
Full Time ,4 Years

Course Type
UG , Hotel Management

Eligibility
The candidate seeking admission in the BHM from AIMS Bangalore should have done XII from a recognized institute. Read More

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Fee Structure

Bachelor in Hotel Management (BHM) Bakery and Confectionery fees for AIMS Institutes, Bangalore 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 in Hotel Management (BHM) Bakery and Confectionery Fee Breakup

Fees (Rs.)	Year 1	Year 2	Year 3	Year 4
Tuition Fees	₹ 1,17,500	₹ 1,17,500	₹ 1,17,500	₹ 1,17,500

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Eligibility

Students who are seeking admission in 4 year BHM Bachelor in Hotel Management (BHM) Bakery and Confectionery program at the AIMS Institutes, Bangalore should meet the following eligibility criteria.

The candidate seeking admission in the BHM from AIMS Bangalore should have done XII from a recognized institute.

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Admission Process

To take admission in Bachelor in Hotel Management (BHM) Bakery and Confectionery at AIMS Institutes, Bangalore, candidates must possess a valid score in GATE, , , NCHMCT JEE or any other state-level examination.

The admission in the AIMS Bangalore for BHM is as per university norms.

Bachelor in Hotel Management (BHM) Bakery and Confectionery Fee Payment Options

AIMS Institutes, Bangalore 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 AIMS Institutes, Bangalore.
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 AIMS Institutes, Bangalore campus.
Delay in fee payment can cause a fine as per AIMS Institutes, Bangalore rules and regulations.

AIMS Institutes, Bangalore Fees Inquiry

Contact Information for students to find out more about the AIMS Institutes, Bangalore Fees

Contact Number - 8150001994, 9845175757
E-mail at: marketing@theaims.ac.in
Admission Block Address - 1st cross, 1st stage, Peenya

Bachelor in Hotel Management (BHM) Bakery and Confectionery AIMS Institutes, Bangalore Top Recruiters

Federal Bank

IndusInd Bank

Karvy

Deloitte

HSBC Bank

IDBI Bank

ING Vysya Bank

Iffco Tokio General Insurance

havells

JP Morgan

Ford India Ltd

Bharti Airtel

Blue Star

SHOPPERS STOP

Aditya Birla Group

Oberoi Hotels

Taj Group of Hotels

Leela Hotel

TNT

Accenture

Kotak Mahindra Bank

HDFC Bank

Angel Broking

KPMG India

99acres.com

IBM

ICICI Bank

Coca Cola

Dabur India Ltd.

Eureka Forbes

View All Recruiters Details

Student's Rating for AIMS Institutes, Bangalore

Student Reviews & Ratings

3.9/5 Based on 31 Verified Reviews

Component Ratings

Faculty Rating 4.3

Infrastructure Rating 4.1

Placements Rating 3

Hostel Rating 4

Club Rating 4

Student's Reviews for AIMS Institutes, Bangalore

Admission

Placement

Faculty

1.5 Overall 05-04-2024

Anonymous User
MBA Student

1 Placement 2 Faculty

There’s nothing good about the college so I request everyone to please not join the college. It is just a money making business ran by a bunch of greedy and corrupt people. The management is the worst and do not even get me started with the faciliti

Placement: The students aren’t even taught how to present themselves in an interview, there’s no proper structure for the course and talking about placements, just 5-10 students get somewhat good job and the rest have to search for themselves and get sat

Admission: Students will obviously know what they need to do but one thing I want to suggest for future ASPIRANTS is that PLEASE DO NOT GET INTO THIS COLLEGE. IT’S A REQUEST.

4 Overall 25-07-2021

Anonymous User
MBA Student

It’s the worst college for management professionals. No appropriate channels of information flow. No infrastructure and Not even basic facilities like - Toilet.

Admission: Only you Need to Have 9 lacks in year hand, No one can stop you from taking admission, Not even your Poor academic’s.

1.5 Overall 05-04-2024

Anonymous User
MBA Student

1 Placement 2 Faculty

Admission: Students will obviously know what they need to do but one thing I want to suggest for future ASPIRANTS is that PLEASE DO NOT GET INTO THIS COLLEGE. IT’S A REQUEST.

5 Overall 25-07-2021

Anonymous User
MBA Student

Aims campus is in good environment and the canteen provide good time spending area and for any kind of event auditorium provides good place to meet the requirements of users. and with good sound effects and improved environments and provide various facili

Placement: In AIMS, placement and job opportunities provide good facilities from AIMS Placement cell. If any activities conducted in any top IT Companies the students can participate and they will be rewarded for every activities. placement’s also available fo

Faculty: Hemanth Sir HOD of MCA Dept. the teaching style and there experience we love to listen there lecture

Club: In AIMS the fee structure varies for Management seats(Payment) and Government seats(PGCET). For payment seats there cost 3-3.5lac per annum for government seats they cost 90,000-1lac. and separate fees for Bus facilities and some extra workshop’s...

5 Overall 25-07-2021

Anonymous User
MBA Student

I chose to go to a AIMS college because I like being part of a large group and diverse student body. The world is a big place, just as my college and the parallels between the two would better help prepare me for post-college life in the real world. Also,

Placement: YES, the stipend is good for every student those who gets an internship. After I heard about the experience in the company it is good for all student they provide a comfortable environment to a student in an internship.

Faculty: Creating assignments,creating exam,using classroom assessment techniques ,using concept maps, using concept tests using Creating assignments, creating group activity work, involve everyone to every activity, motivation to everyone, friendly nature with ev

Admission: State / National Entrance Exams

Club: In this institute, there is no difference between a student that all are equals for all. its give high comfort facility in campus. Students can play with different game simultaneously. it is also organized group discussion with another department studen

5 Overall 25-07-2021

Anonymous User
MBA Student

good ambience , best facilities, and this college provides the best opportunities for every student to explore there talents and bring out the best in them , and its student centric , and near by or the surrounding of this college is good and strictly mai

Placement: yes this college provides the internship for students at the final year to gain the knowledge outside . when the students are into end of their curriculum this college provides the best job opportunities . they assess students according to their capab

Faculty: Faculties here are very dedicated and punctual they teach and train students very well and make sure that the students understand each and every concepts in depth and not only about studies teachers here understands students when it comes to there persona

Admission: State / National Entrance Exams

View All 31 Reviews

Gallery

30 Images

AIMS Institutes, Bangalore Program Offered

4.5 Bachelor in Hotel Management (BHM) Hospitality & Hotel Administration

120 Seats 4 Years

Total Fees

₹4,70,000

Highest Package

N/A

4.5 Bachelor in Hotel Management (BHM) Catering Technology & Tourism

120 Seats 4 Years

Total Fees

₹4,70,000

Highest Package

N/A

4.5 Bachelor in Hotel Management (BHM) Hospitality Management

120 Seats 4 Years

Total Fees

₹4,70,000

Highest Package

N/A

View All Programs

Contact Details

Address

1st cross, 1st stage, Peenya

College Contact

81XXXXXX94

maXXXXXXin

Messages Timeline Exceptions Views13 Route Queries65 Models399 Mails Gate Session Request

Request history8.3.19322ms4MBGET {type}/{slug}/{tab}/{tab2}

Booting (16.94ms)time
Application (305ms)time
1 x Application (94.74%)
305ms
1 x Booting (5.26%)
16.94ms

13 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.blade.php#?blade
components.total-reviewtotal-review.blade.php#?blade
components.detailed-reviewsdetailed-reviews.blade.php#?blade
components.videoslistingvideoslisting.blade.php#?blade
components.registrationregistration.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.headerheader.blade.php#?blade
partials.footerfooter.blade.php#?blade
components.sucessesModalsucessesModal.blade.php#?blade
partials.bottomfooterbottomfooter.blade.php#?blade

uri: GET {type}/{slug}/{tab}/{tab2}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs2
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:110-238

65 statements were executed (7 duplicates)Show only duplicates173ms

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_new5.88ms

select * from `seo_redirects` where `redirect_from` = '/colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376' limit 1

Bindings	0: /colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376
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.01ms

select * from `meta_tags` where `slug` = 'colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376 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.33ms

select * 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.5ms

select `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` = 'aims-institutes-bangalore' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: aims-institutes-bangalore 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.2ms

select `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 (2542) 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.31ms

select `id`, `name` from `programs` where `programs`.`id` in (638, 642, 657, 658, 659, 820, 898, 899, 902, 903, 904, 905, 906, 907, 908, 909, 932, 933, 1074, 2264, 2265, 2267, 2270, 2306, 2348, 2772, 3410, 3437, 3458, 3600, 3625, 3661, 4529, 4735, 5393, 5672, 5673, 5674) 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_new1.46ms

select `id`, `name` from `courses` where `courses`.`id` in (2, 7, 8, 12, 13, 19, 21, 22, 23, 25, 45, 49, 65, 73, 106) 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.49ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5091, 5092, 5093, 5094, 5095, 5096, 5375, 5376, 5377, 18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378, 23498, 33962, 33963, 33964, 36912, 36913, 36914, 50841, 50842, 50843, 50844, 50845, 50846, 50847, 50848, 50849, 50850, 50851, 50852) 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_new1.05ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (5091, 5092, 5093, 5094, 5095, 5096, 5375, 5376, 5377, 18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378, 23498, 33962, 33963, 33964, 36912, 36913, 36914, 50841, 50842, 50843, 50844, 50845, 50846, 50847, 50848, 50849, 50850, 50851, 50852) 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.04ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5091, 5092, 5093, 5094, 5095, 5096, 5375, 5376, 5377, 18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378, 23498, 33962, 33963, 33964, 36912, 36913, 36914, 50841, 50842, 50843, 50844, 50845, 50846, 50847, 50848, 50849, 50850, 50851, 50852) 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_new940μs

select `name` from `cities` where `id` = 24 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1

Bindings	0: 24 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.02ms

select `name` from `states` where `id` = 79 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1

Bindings	0: 79 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_new1.21ms

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 2542 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: 2542 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_new1.61ms

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 2542 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null

Bindings	0: 2542
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_new8.81ms

select `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: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_new1.7ms

select `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 2542 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2542 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_new1.26msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (324) 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_new1.52ms

select count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 2542 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 2542 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_new3.66ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2542 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: 2542 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_new3.11ms

select `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 2542 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2542 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.83ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2542 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: 2542 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_new2.59ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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_new2.84ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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#151db_collegesearch_new1.16msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

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_new2.68ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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_new4.69ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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#151db_collegesearch_new710μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

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_new1ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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.71ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2542 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: 2542 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#151db_collegesearch_new1.07msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

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.4ms

select * from `institute_programs` where `institute_id` = 2542 and `institute_programs`.`id` = '18376' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 2542 1: 18376 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.36ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (18376) 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_new7.58ms

select `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (18376) 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_new1.62msselect * 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: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.19msselect * 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_new2.72msselect * 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: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.75ms

select * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (18376) 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_new4.07msselect * 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_new3.96ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (18376)

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μs

select `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (116, 131, 2198, 2222) 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.34ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (116, 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: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_new680μs

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (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.74ms

select `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` = 116 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 116 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_new5.8ms

select `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.52ms

select `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: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_new2.57ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 2542 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: 2542 1: cs 2: nirf 3: 12 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_new1.86ms

select `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 12 and `institute_id` = 2542) and `id` != '18376' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3

Bindings	0: 12 1: 2542 2: 18376 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#589db_collegesearch_new1.39ms

select `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (18369, 18370, 18371) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: 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_new5.68ms

select distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 2542 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 2542 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#593db_collegesearch_new1.75ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (1, 32, 60, 61, 69, 92, 491, 647, 833, 930, 1367, 1585, 1899, 1921, 2018, 2118, 2206, 2648, 3022, 3088, 3127, 3128, 3598, 3967, 4308, 4463, 5020, 5038, 5144, 5341)

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#593db_collegesearch_new5.34ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 3, 4, 6, 15, 24, 29, 50, 66, 93, 109, 212, 266, 336, 345)

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_new3.55ms

select `id` from `institute_programs` where `institute_id` = 2542 and `course_id` = 12 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2542 1: 12 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_new980μs

select institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (18369, 18370, 18371, 18372, 18373, 18374, 18375, 18376, 18377, 18378) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 18369 1: 18370 2: 18371 3: 18372 4: 18373 5: 18374 6: 18375 7: 18376 8: 18377 9: 18378 10: 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_new29.3ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 2542 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: 2542 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_new800μs

select * from `institute_ratings` where `institute_ratings`.`institute_id` = 2542 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 2542 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_new660μs

select * from `institute_documents` where `institute_documents`.`institute_id` = 2542 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc

Bindings	0: 2542 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_new860μs

select `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '18376' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 18376 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_new2.94ms

select `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: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.14ms

select distinct `course_id` from `institute_programs` where `institute_id` = 2542 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2542 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_new3.11ms

select 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` = 2542

Bindings	0: 2542
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.46ms

select `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` = 2542 and `expiry_date` > '2025-06-14 14:05:01' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 2542 3: 2025-06-14 14:05:01
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_new4.23ms

select `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', '23', '48', '2240', '2008', '2342', '2198', '131', '116', '2222', '2389', '26') and `expiry_date` > '2025-06-14 14:05:01' 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: 23 5: 48 6: 2240 7: 2008 8: 2342 9: 2198 10: 131 11: 116 12: 2222 13: 2389 14: 26 15: 2025-06-14 14:05:01
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.16ms

select `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 ('2', '7', '12', '21', '49', '25', '23', '13', '8', '45', '19', '22', '65', '106', '73') and `sub_type` like '%about%' and `expiry_date` > '2025-06-14 14:05:01' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 2 2: 7 3: 12 4: 21 5: 49 6: 25 7: 23 8: 13 9: 8 10: 45 11: 19 12: 22 13: 65 14: 106 15: 73 16: %about% 17: 2025-06-14 14:05:01
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_new770μs

select * from `meta_tags` where `slug` = 'colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376 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_new1.37msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: active
Backtrace	app/helpers.php:157 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

App\Models\InstituteProgram: 68InstituteProgram.php#?
App\Models\InstituteImage: 60InstituteImage.php#?
App\Models\InstituteProgramFeesSummary: 42InstituteProgramFeesSummary.php#?
App\Models\Program: 38Program.php#?
App\Models\InstituteRecruiter: 30InstituteRecruiter.php#?
App\Models\Recruiter: 30Recruiter.php#?
App\Models\Course: 17Course.php#?
App\Models\InstituteProgramExamMapping: 17InstituteProgramExamMapping.php#?
App\Models\RecruiterIndustryType: 15RecruiterIndustryType.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramPlacement: 12InstituteProgramPlacement.php#?
App\Models\InstituteContent: 10InstituteContent.php#?
App\Models\ExamFeatureMapping: 7ExamFeatureMapping.php#?
App\Models\ExamFeature: 7ExamFeature.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\InstituteProgramFee: 4InstituteProgramFee.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Exam: 2Exam.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\Admin: 1Admin.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\FeesType: 1FeesType.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: C5Rik34Kc7PXxN7h81519oGsyJKXiMKaMWKOiWVq
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/aims-institutes-bangalore/courses-fe...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376

status_code

status_text

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=eyJpdiI6IkxUTWVHUDFNVFA1ZmlETFlUaGZtN1E9PSIsInZhbHVlIjoieTZ3MUo2dzlaODNzekNIdFNCU1VmWlNvL0c0SGFhU0NqT1EvTEc0TEEwblNMY3lGbVh4VWR3TDA3VVVJQ3VGaVR3SHlBaU9MT0szRldkemZFaG1mcDJMdGE2K09tZ3BiZVFiNnNwbnpaSzAvOEFhOWVIV1NuVC9uK0NlSm1sVXAiLCJtYWMiOiI0YjVmM2JlNDgwOTk5NTI5MDU1MjM3NWU0MGZiY2IyNTgwOWQzZTJjNDNjOTA0N2RiZjczMGM5ZWVlN2I1ZmIzIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Im9zZko4VE1qNTBxNFVreWVsb0pPUGc9PSIsInZhbHVlIjoicDJUcU1SQytFY3FDWlhLRUIreERuZTFsWktuckdXNFVTQ2ZOSXFxTmZQT2dPd0ZFTVlwV2dSYy9jNkx6VDc5UlgwTy9DaERYU3paUDJ5Wmk4MHNzYlZGd3k5S1BlcXIxbVM2dUtPSktzcTNlUW1ZbzQ5eE9vbEVNS1lLVXpBbnkiLCJtYWMiOiI5Mzk2YTc0NGY3OTRjMzgwZDM3NWNhNTBmN2Y5NzY2YTFlYzk1N2NkMjVhMzNlNzc4MDY5MDE3YmU1YzlkNGMxIiwidGFnIjoiIn0%3D; course_id=2; course_name=MBA%20%2F%20PGDM; viewed_colleges=%5B9975%2C8111%2C30599%2C13167%2C2074%5D ◀XSRF-TOKEN=eyJpdiI6IkxUTWVHUDFNVFA1ZmlETFlUaGZtN1E9PSIsInZhbHVlIjoieTZ3MUo2dzlaODNzekNIdFNCU1VmWlNvL0c0SGFhU0NqT1EvTEc0TEEwblNMY3lGbVh4VWR3TDA3VVVJQ3VGaVR3SHlBa ▶"
  ]
  "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" => "C5Rik34Kc7PXxN7h81519oGsyJKXiMKaMWKOiWVq"
  "laravel_session" => "EADIHKCztHbJsa3sXqTFMpuiYp77oPjj5iZmAb36"
  "course_id" => "2"
  "course_name" => "MBA / PGDM"
  "viewed_colleges" => "[9975,8111,30599,13167,2074]"
]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 14 Jun 2025 14:05:01 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InI0UHQwWG85UjBQd3o5UGdsaWNIUHc9PSIsInZhbHVlIjoiVlVZMXVuVnQzZ0haY2ZlV2ZUeWdvY0pnaEt0ODJYWUZ1QzU5S3dPOXRSVDI4N1YvRWVCOGpMQ2JrUzAzd1dSeU5YTTRwKys2NlY3TE05emg3dSt3cHRJUzlXcHdGRk1CMXVWWi80dGRjNDBSY1hDVUFkTmdyQmxiRVF1dzk3TEgiLCJtYWMiOiIxNDlhZTc2NjVkMTFhZGEyNjkyNWNhM2Y3MDgxNzM5NjczNGE2NTg3N2E5NWM5YmIyMjc0MmMwMjM5NzNmZjNhIiwidGFnIjoiIn0%3D; expires=Sat, 14 Jun 2025 16:05:01 GMT; Max-Age=7199; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InI0UHQwWG85UjBQd3o5UGdsaWNIUHc9PSIsInZhbHVlIjoiVlVZMXVuVnQzZ0haY2ZlV2ZUeWdvY0pnaEt0ODJYWUZ1QzU5S3dPOXRSVDI4N1YvRWVCOGpMQ2JrUzAzd1dSeU5YTTRwK ▶"
    1 => "laravel_session=eyJpdiI6ImM1Yk1QQmIwZzFERVVrdXEzUEZaQXc9PSIsInZhbHVlIjoiSjFGdjUzZ0RiZjVuQXk4ckFtL0VxWkphSW9UVmpvbVZUNGxrTjVLYnVhUkEvVWVvd3BqMXEvb25YSUcvMFA4WTVrOVVtS1M0RjI3MitBS2tDakt1RThFdW1mbjJtMWh3cVZwTElaRGpuQ1YvL0hDWnlPWGpBcTNueEwxSnNMUmgiLCJtYWMiOiJlYjRkODQzNjA0NzYzNTVjNTBiYWMwMTAwZGFlODAxNDJlNmFhMzUxZTkyYjk2MzM0ZWU1ZGY0ZDg2Mjg3YzE3IiwidGFnIjoiIn0%3D; expires=Sat, 14 Jun 2025 16:05:01 GMT; Max-Age=7199; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImM1Yk1QQmIwZzFERVVrdXEzUEZaQXc9PSIsInZhbHVlIjoiSjFGdjUzZ0RiZjVuQXk4ckFtL0VxWkphSW9UVmpvbVZUNGxrTjVLYnVhUkEvVWVvd3BqMXEvb25YSUcvMFA4WTVr ▶"
    2 => "course_id=12; expires=Sun, 14 Jun 2026 14:05:01 GMT; Max-Age=31535999; path=/; samesite=lax"
    3 => "course_name=BHM; expires=Sun, 14 Jun 2026 14:05:01 GMT; Max-Age=31535999; path=/; samesite=lax"
    4 => "viewed_colleges=%5B9975%2C8111%2C30599%2C13167%2C2074%2C2542%5D; expires=Mon, 14 Jul 2025 14:05:01 GMT; Max-Age=2591999; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InI0UHQwWG85UjBQd3o5UGdsaWNIUHc9PSIsInZhbHVlIjoiVlVZMXVuVnQzZ0haY2ZlV2ZUeWdvY0pnaEt0ODJYWUZ1QzU5S3dPOXRSVDI4N1YvRWVCOGpMQ2JrUzAzd1dSeU5YTTRwKys2NlY3TE05emg3dSt3cHRJUzlXcHdGRk1CMXVWWi80dGRjNDBSY1hDVUFkTmdyQmxiRVF1dzk3TEgiLCJtYWMiOiIxNDlhZTc2NjVkMTFhZGEyNjkyNWNhM2Y3MDgxNzM5NjczNGE2NTg3N2E5NWM5YmIyMjc0MmMwMjM5NzNmZjNhIiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 16:05:01 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InI0UHQwWG85UjBQd3o5UGdsaWNIUHc9PSIsInZhbHVlIjoiVlVZMXVuVnQzZ0haY2ZlV2ZUeWdvY0pnaEt0ODJYWUZ1QzU5S3dPOXRSVDI4N1YvRWVCOGpMQ2JrUzAzd1dSeU5YTTRwK ▶"
    1 => "laravel_session=eyJpdiI6ImM1Yk1QQmIwZzFERVVrdXEzUEZaQXc9PSIsInZhbHVlIjoiSjFGdjUzZ0RiZjVuQXk4ckFtL0VxWkphSW9UVmpvbVZUNGxrTjVLYnVhUkEvVWVvd3BqMXEvb25YSUcvMFA4WTVrOVVtS1M0RjI3MitBS2tDakt1RThFdW1mbjJtMWh3cVZwTElaRGpuQ1YvL0hDWnlPWGpBcTNueEwxSnNMUmgiLCJtYWMiOiJlYjRkODQzNjA0NzYzNTVjNTBiYWMwMTAwZGFlODAxNDJlNmFhMzUxZTkyYjk2MzM0ZWU1ZGY0ZDg2Mjg3YzE3IiwidGFnIjoiIn0%3D; expires=Sat, 14-Jun-2025 16:05:01 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImM1Yk1QQmIwZzFERVVrdXEzUEZaQXc9PSIsInZhbHVlIjoiSjFGdjUzZ0RiZjVuQXk4ckFtL0VxWkphSW9UVmpvbVZUNGxrTjVLYnVhUkEvVWVvd3BqMXEvb25YSUcvMFA4WTVr ▶"
    2 => "course_id=12; expires=Sun, 14-Jun-2026 14:05:01 GMT; path=/"
    3 => "course_name=BHM; expires=Sun, 14-Jun-2026 14:05:01 GMT; path=/"
    4 => "viewed_colleges=%5B9975%2C8111%2C30599%2C13167%2C2074%2C2542%5D; expires=Mon, 14-Jul-2025 14:05:01 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "C5Rik34Kc7PXxN7h81519oGsyJKXiMKaMWKOiWVq"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-14 14:05:01	GET	/colleges/aims-institutes-bangalore/courses-fees/bhm-bhm-bakery-and-confectionery-18376	13 65 399

1 x Application (94.74%)	305ms
1 x Booting (5.26%)	16.94ms