Master in Human Resource Development & Management (MHRDM) in XLRI Jamshedpur, Jamshedpur Fees Breakup, Total Fees, Eligibility.

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Overview

Master in Human Resource Development & Management (MHRDM) is a 2 year course at XLRI Jamshedpur, Jamshedpur. The total fees for Master in Human Resource Development & Management (MHRDM) at XLRI Jamshedpur, Jamshedpur is -. To get admission in Master in Human Resource Development & Management (MHRDM) at XLRI Jamshedpur, Jamshedpur, students must meet some eligibility requirements, that is Candidates who have completed three years of Bachelors degree or equivalent in any discipline, recognized by a University or a Deemed University are eligible to apply.. This program helps students with the necessary skills to build a successful career in the Management.

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Highlights

Particular	Details
Total Seats	120
Course Fee	N/A
Duration	2 Years
Accepted Exams	CAT

About Master in Human Resource Development & Management (MHRDM)

Program Duration
Full Time ,2 Years

Course Type
PG , Management

Eligibility
Candidates who have completed three years of Bachelors degree or equivalent in any discipline, recognized by a University or a Deemed University are eligible to apply. Read More

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Fee Structure

Master in Human Resource Development & Management (MHRDM) fees for XLRI Jamshedpur, Jamshedpur 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:

Master in Human Resource Development & Management (MHRDM) Fee Breakup

Fees (Rs.)	Year 1	Year 2
Total Fees	-	-

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Eligibility

Students who are seeking admission in 2 year MBA / PGDM Master in Human Resource Development & Management (MHRDM) program at the XLRI Jamshedpur, Jamshedpur should meet the following eligibility criteria.

Candidates who have completed three years of Bachelors degree or equivalent in any discipline, recognized by a University or a Deemed University are eligible to apply.

Popular Exams

CAT MBA / PGDM

Exam Month

November

Accepting Colleges

Last Date to Apply

29th November, 2025

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Admission Process

To take admission in Master in Human Resource Development & Management (MHRDM) at XLRI Jamshedpur, Jamshedpur, candidates must possess a valid score in CAT or any other state-level examination.

The candidates will have to appear for an aptitude test on 16 March 2014 (tentatively). The test will have a section on quantitative ability where the problems can be solved with mathematical concepts taught in standard IX and X. The other section will test the logical reasoning and english language skills. Candidates who have written any of the well-established, credible management entrance examination in the last two years, are encouraged to send the copy of the scores along with the application

Master in Human Resource Development & Management (MHRDM) Fee Payment Options

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

XLRI Jamshedpur, Jamshedpur Fees Inquiry

Contact Information for students to find out more about the XLRI Jamshedpur, Jamshedpur Fees

Contact Number - 3983333, 8092523500
E-mail at: crux@xlri.ac.in
Admission Block Address - Circuit House Area (East)

Master in Human Resource Development & Management (MHRDM) XLRI Jamshedpur, Jamshedpur Top Recruiters

A.T. Kearney India

ABB Limited

ABN AMRO Bank

ABN AMRO Group

Accenture

Aditya Birla Group

Agrotech

AIG Group

American Express

Apollo Tyres

Bank of America

Banque Nationale de Paris

BASF

Bharat Petroleum Corporation Limited (BPCL)

Bharti Enterprises Limited

BOC India Ltd

Britannia Industries

Cadbury

Cambridge Technology Partners

CAP Gemini

Citi Bank

Coca-Cola India

Cognizant

Colgate Palmolive India Ltd.

CRISIL

Dr.Reddy’s Laboratories Ltd

Ernst & Young

Eicher Goodearth

EXL Services

Ge Capital

View All Recruiters Details

Student's Rating for XLRI Jamshedpur, Jamshedpur

Student Reviews & Ratings

4.4/5 Based on 48 Verified Reviews

Component Ratings

Faculty Rating 4.2

Infrastructure Rating 4.5

Admission Rating 4.3

Hostel Rating 4.4

Club Rating 4.2

Student's Reviews for XLRI Jamshedpur, Jamshedpur

Admission

Placement

Faculty

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Admission 5 Hostel 4.5 Club 5 Mess

XLcesior â€œThe XL culture can only be experienced and cannot be explainedâ€ These words straight from our dean’s mouth are the most apt description for life at XLRI. In this article I’ll try to ’tangibilise’ Life at XLR

Placement: This year we saw a plethora of opportunities for our institution with a record 100% placement within 2.5 days. Some snippets for the same from our official report are â€“ Largest ever batch of 361 students was placed in a record time of 2.5 days â€“

Infrastructure: Gym, Laboratories, Green Campus theme, Behavioral Lab, State of the Art classrooms etc and it has been ranked for the best infrastructure college in India

Faculty: Termed as the "Finance God" on our campus it has to be Prof. Sabhyasachi Sengupta. With a bevy of degrees namely CA, CS and ICWAI he has immense knowledge on the subject. His pedagogy is the perfect blend of theory and practice and the experience of being

Admission: Based on School / 12th Class Result, State / National Entrance Exams, Group Discussion / Personal Interview, Video, Essay Writing & General Knowledge

Club: The Marketing Association of XLRI, or MAXI as it fondly known, is the oldest committee on campus. Started over thirty years ago, MAXI’s mandate is simple - popularize the field of Marketing at XLRI and ensure that fun and quirkiness is an integral p

Mess: Food, Ambience, Hospitality, Infrastructure

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4 Faculty 4 Admission 5 Hostel 4.5 Club 4.5 Mess

Placement: Our SIP (Summer internship process) and Final placement process are conducted for over 2-3 days wherein the whole batch gets placed. As part of college culture, we do not indulge in merry making till the whole batch gets placed and stand united. We have a

Faculty: Real life experience with over 20 years corporate exposure. Hence always keeps us abreast of the latest developments.

Admission: Based on School / 12th Class Result, State / National Entrance Exams, College’s Internal Written Exam, Group Discussion / Personal Interview

Club: Bodhi Tree - Enough said. Its songs have defined a generation and continue to inspire new budding talents. The club has ample resources and motivated students who continue spreading the awesome stuff

Mess: Food, Ambience, Hospitality, Infrastructure

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Admission 5 Hostel 4.5 Club 5 Mess

Infrastructure: Gym, Laboratories, Green Campus theme, Behavioral Lab, State of the Art classrooms etc and it has been ranked for the best infrastructure college in India

Admission: Based on School / 12th Class Result, State / National Entrance Exams, Group Discussion / Personal Interview, Video, Essay Writing & General Knowledge

Mess: Food, Ambience, Hospitality, Infrastructure

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4 Faculty 4 Admission 5 Hostel 4.5 Club 4.5 Mess

Faculty: Real life experience with over 20 years corporate exposure. Hence always keeps us abreast of the latest developments.

Admission: Based on School / 12th Class Result, State / National Entrance Exams, College’s Internal Written Exam, Group Discussion / Personal Interview

Mess: Food, Ambience, Hospitality, Infrastructure

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Admission 5 Hostel 4.5 Club 5 Mess

Infrastructure: Gym, Laboratories, Green Campus theme, Behavioral Lab, State of the Art classrooms etc and it has been ranked for the best infrastructure college in India

Admission: Based on School / 12th Class Result, State / National Entrance Exams, Group Discussion / Personal Interview, Video, Essay Writing & General Knowledge

Mess: Food, Ambience, Hospitality, Infrastructure

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 4.5 Faculty 4 Admission 5 Hostel 5 Club 4.5 Mess

The best thing about XLRI is the unique XL Culture and the student boding that is shared amongst student. Throughout the year, there are lots of engaging activities happening which provide ample opportunities to student to have fun and interact with each

Placement: Excellent Internship opportunities mainly because of college reputation. Processes are completed in very short time and many reputed companies visit the campus and provide excellent job and internship opportunity

Infrastructure: Pool, Gym, Laboratories

Faculty: Manish Singhal, due to the style of teaching and vast knowledge and general interaction with students outside the classroom.

Admission: College’s Internal Written Exam, Group Discussion / Personal Interview, Video, Essay

Mess: Food, Ambience, Hospitality, Infrastructure

View All 48 Reviews

Gallery

28 Images

XLRI Jamshedpur, Jamshedpur Program Offered

4.5 Post Graduate Diploma in Business Management (PGDBM) Business Innovation & Strategy

180 Seats 2 Years

Total Fees

₹-

Highest Package

N/A

4.5 Post Graduate Diploma in Business Management (PGDBM) Business Law Innovation & Entrepreneurship International

180 Seats 2 Years

Total Fees

₹-

Highest Package

N/A

4.5 Post Graduate Diploma in Business Management (PGDBM) General Management

180 Seats 2 Years

Total Fees

₹-

Highest Package

N/A

View All Programs

Contact Details

Address

Circuit House Area (East)

College Contact

39XXXXXX33

crXXXXXXin

XLRI Jamshedpur, Jamshedpur 4.4/5 (48 reviews)

Messages Timeline Exceptions Views12 Route Queries64 Models271 Mails Gate Session Request

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

Booting (10.03ms)time
Application (194ms)time
1 x Application (95.08%)
194ms
1 x Booting (4.92%)
10.03ms

12 templates were rendered

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

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

64 statements were executed (9 duplicates)Show only duplicates122ms

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

select * from `seo_redirects` where `redirect_from` = '/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428' limit 1

Bindings	0: /colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428
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.68ms

select * from `meta_tags` where `slug` = 'colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428 1: active
Backtrace	app/Http/Middleware/MetaChecker.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SoftRedirects.php:28 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51

CollegeController.php#130db_collegesearch_new1.46ms

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` = 'xlri-xavier-school-of-management-jamshedpur' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: xlri-xavier-school-of-management-jamshedpur 2: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new1.37ms

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 (2772) and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new930μs

select `id`, `name` from `programs` where `programs`.`id` in (2265, 2276, 2291, 2300, 2392, 2393, 2394, 3083, 3084, 3489, 3496) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new1.25ms

select `id`, `name` from `courses` where `courses`.`id` in (2, 1023) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new1.8ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5242, 5243, 5244, 5245, 5246, 5247, 11222, 11223, 27355, 27356, 44750, 51427, 51428) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new740μs

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (5242, 5243, 5244, 5245, 5246, 5247, 11222, 11223, 27355, 27356, 44750, 51427, 51428) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new1.17ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5242, 5243, 5244, 5245, 5246, 5247, 11222, 11223, 27355, 27356, 44750, 51427, 51428) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

Institute.php#174db_collegesearch_new850μs

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

Bindings	0: 184 1: active
Backtrace	app/Models/Institute.php:174 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#189db_collegesearch_new1.24ms

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

Bindings	0: 78 1: active 2: 2
Backtrace	app/Models/Institute.php:189 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#775db_collegesearch_new1.37ms

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 2772 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: 2772 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:775 app/Http/Controllers/CollegeController.php:345 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#346db_collegesearch_new1.71ms

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

Bindings	0: 2772
Backtrace	app/Http/Controllers/CollegeController.php:346 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#346db_collegesearch_new870μs

select `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (1, 4, 5) and `institute_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:346 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#811db_collegesearch_new1.88ms

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

Bindings	0: 2772 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:811 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#811db_collegesearch_new780μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261, 285) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:811
app/Http/Controllers/CollegeController.php:347
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#822db_collegesearch_new1.53ms

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:822 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new870μs

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2772 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2772 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:823 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#824db_collegesearch_new950μs

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:824 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.27ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2772 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2772 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.38ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new4.72ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new860μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.06ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.45ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new750μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.34ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.15ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2772 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: 2772 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new690μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#563db_collegesearch_new870μs

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

Bindings	0: 2772 1: 51428 2: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new740μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (51428) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.26ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.51msselect * from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.37msselect * from `degrees` where `degrees`.`id` in (2) and `degrees`.`deleted_at` is null and `status` = 'Active'

Bindings	0: 2 1: Active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.47msselect * from `streams` where `streams`.`id` in (2) and `streams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2 1: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new3.66ms

select * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (51428) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new910μsselect * from `fees_types` where `fees_types`.`id` in (12)

Backtrace

app/Http/Controllers/CollegeController.php:563
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.09ms

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

Backtrace

app/Http/Controllers/CollegeController.php:563
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.82ms

select `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21) and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.15ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21) and exists (select * from `exam_features` where `exam_feature_mappings`.`exam_feature_id` = `exam_features`.`id` and `type` like '%date%' and `exam_features`.`deleted_at` is null and `status` = 'active') and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active'

Bindings	0: %date% 1: active 2: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#563db_collegesearch_new1.37ms

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9, 10) and `exam_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Exam.php#58db_collegesearch_new1.08ms

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` = 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:564 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new1.41ms

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:564 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.49ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 2772 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 2 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1

Bindings	0: 2772 1: cs 2: nirf 3: 2 4: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:574 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new2.77msselect * from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:574 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#584db_collegesearch_new1.95ms

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

Bindings	0: 2 1: 2772 2: 51428 3: active
Backtrace	app/Http/Controllers/CollegeController.php:584 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#584db_collegesearch_new1.08ms

select `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5242, 5243, 5244) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:584 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#588db_collegesearch_new1.22ms

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:588 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#588db_collegesearch_new1.47ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (10, 11, 12, 16, 35, 45, 312, 930, 1002, 1323, 1331, 1367, 1474, 1551, 1579, 1583, 1609, 1626, 1649, 1833, 2995, 2999, 3000, 3002, 3010, 3226, 3328, 3329, 3330, 3331)

Backtrace

app/Http/Controllers/CollegeController.php:588
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#588db_collegesearch_new1.39ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 3, 4, 5, 6, 8, 19, 29, 38, 50, 63, 66, 136, 345)

Backtrace

app/Http/Controllers/CollegeController.php:588
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#593db_collegesearch_new1.08ms

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

Bindings	0: 2772 1: 2 2: active
Backtrace	app/Http/Controllers/CollegeController.php:593 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#601db_collegesearch_new1.19ms

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 (5242, 5243, 5244, 5245, 5246, 5247, 27355, 27356, 44750, 51427, 51428) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 5242 1: 5243 2: 5244 3: 5245 4: 5246 5: 5247 6: 27355 7: 27356 8: 44750 9: 51427 10: 51428 11: active
Backtrace	app/Http/Controllers/CollegeController.php:601 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#225db_collegesearch_new27.11ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 2772 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: 2772 2: course-fees-program-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:724 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#725db_collegesearch_new930μs

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:725 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#726db_collegesearch_new840μs

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:726 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#309db_collegesearch_new1.36ms

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

Bindings	0: 51428 1: active
Backtrace	app/Http/Controllers/CollegeController.php:309 app/Http/Controllers/CollegeController.php:159 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#309db_collegesearch_new710μs

select `id`, `name`, `slug` from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:309 app/Http/Controllers/CollegeController.php:159 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#1038db_collegesearch_new1.18ms

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

Bindings	0: 2772 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1038 app/Http/Controllers/CollegeController.php:160 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#1044db_collegesearch_new930μs

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` = 2772

Bindings	0: 2772
Backtrace	app/Http/Controllers/CollegeController.php:1044 app/Http/Controllers/CollegeController.php:160 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#491db_collegesearch_new2.19ms

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` = 2772 and `expiry_date` > '2025-04-25 16:31:31' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 2772 3: 2025-04-25 16:31:31
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:160 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#506db_collegesearch_new2.15ms

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 ('93', '2240', '21', '132', '23', '15', '116') and `expiry_date` > '2025-04-25 16:31:31' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 93 3: 2240 4: 21 5: 132 6: 23 7: 15 8: 116 9: 2025-04-25 16:31:31
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:160 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#520db_collegesearch_new3.1ms

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', '1023') and `sub_type` like '%about%' and `expiry_date` > '2025-04-25 16:31:31' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 2 2: 1023 3: %about% 4: 2025-04-25 16:31:31
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:160 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#890db_collegesearch_new1.43ms

select * from `meta_tags` where `slug` = 'colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428 1: active
Backtrace	app/Http/Controllers/CollegeController.php:890 app/Http/Controllers/CollegeController.php:192 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#156db_collegesearch_new1.46msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

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

App\Models\InstituteImage: 70InstituteImage.php#?
App\Models\InstituteProgram: 31InstituteProgram.php#?
App\Models\InstituteRecruiter: 30InstituteRecruiter.php#?
App\Models\Recruiter: 30Recruiter.php#?
App\Models\InstituteProgramFeesSummary: 15InstituteProgramFeesSummary.php#?
App\Models\RecruiterIndustryType: 14RecruiterIndustryType.php#?
App\Models\Program: 11Program.php#?
App\Models\InstituteContent: 11InstituteContent.php#?
App\Models\InstituteProgramExamMapping: 8InstituteProgramExamMapping.php#?
App\Models\InstituteFeatureMapping: 7InstituteFeatureMapping.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\Course: 5Course.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\InstituteFeature: 3InstituteFeature.php#?
App\Models\User: 3User.php#?
App\Models\ExamFeatureMapping: 3ExamFeatureMapping.php#?
App\Models\ExamFeature: 3ExamFeature.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Admin: 2Admin.php#?
App\Models\InstituteProgramFee: 2InstituteProgramFee.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\FeesType: 1FeesType.php#?
App\Models\Exam: 1Exam.php#?
App\Models\InstituteRank: 1InstituteRank.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: Y1m8gHONKhMDsFze3Ydo1Qppn3s36m9PMMv5gzFY
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/xlri-xavier-school-of-management-jam...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 25 Apr 2025 16:31:31 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFnSGt1R2NRZVhITGE1Vzg5Y2thb0E9PSIsInZhbHVlIjoiQW9MaFRncml3TC9CaTJmLy9NL2pEaG5icGNFcjBQY0xNVjl1QWtkR1RXVHVnbUVDWWRERk1HZEVmSVN4VHpFQjdWb1hrV3NwaXFYM1pocGtsUlhjOEExWTJ6NHdxV29aS3V5STFDNzNpeEV6dmlwUmtIMFNLcUwwNDlCL1lqSnkiLCJtYWMiOiI3YWRjNmU1NGRjOTRjOTViZmQ3ZmZjYTZjY2I2ODc5MTE2ZDgwYWRjMjhlZDgyMDU1MTViZmVkZTIzMWJhNzBmIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 18:31:31 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlFnSGt1R2NRZVhITGE1Vzg5Y2thb0E9PSIsInZhbHVlIjoiQW9MaFRncml3TC9CaTJmLy9NL2pEaG5icGNFcjBQY0xNVjl1QWtkR1RXVHVnbUVDWWRERk1HZEVmSVN4VHpFQjdWb1hrV ▶"
    1 => "laravel_session=eyJpdiI6ImlreEkxTFJBalpHRTRKbll5d3pPQnc9PSIsInZhbHVlIjoiejY0MFY0UXU3Z05DY3M2UVkyYzV3Q1FTS3VTa1lGYy8vWHh1cTEvVkxNZGg5ZzFxUDZaNkI0SFJIdG8zTVNFTjBCNDJvckZIMDFyaHFSd3o0cWRSYUxUZjd2eVloRWVxUFY5aDh1R29BdzFnajAycVRCVHVhVlN5bjBTUzMvdU0iLCJtYWMiOiI2ZmNlYjQzY2Y1YjE4Y2Y1MjdkMDVhMDNmMGY3YjlkY2Y2OTNiZWNlNjM0MzIyYmZhZTkwOGEwZGZmMzg1ZDRiIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 18:31:31 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImlreEkxTFJBalpHRTRKbll5d3pPQnc9PSIsInZhbHVlIjoiejY0MFY0UXU3Z05DY3M2UVkyYzV3Q1FTS3VTa1lGYy8vWHh1cTEvVkxNZGg5ZzFxUDZaNkI0SFJIdG8zTVNFTjBC ▶"
    2 => "course_id=2; expires=Sat, 25 Apr 2026 16:31:31 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MBA%20%2F%20PGDM; expires=Sat, 25 Apr 2026 16:31:31 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B2772%5D; expires=Sun, 25 May 2025 16:31:31 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFnSGt1R2NRZVhITGE1Vzg5Y2thb0E9PSIsInZhbHVlIjoiQW9MaFRncml3TC9CaTJmLy9NL2pEaG5icGNFcjBQY0xNVjl1QWtkR1RXVHVnbUVDWWRERk1HZEVmSVN4VHpFQjdWb1hrV3NwaXFYM1pocGtsUlhjOEExWTJ6NHdxV29aS3V5STFDNzNpeEV6dmlwUmtIMFNLcUwwNDlCL1lqSnkiLCJtYWMiOiI3YWRjNmU1NGRjOTRjOTViZmQ3ZmZjYTZjY2I2ODc5MTE2ZDgwYWRjMjhlZDgyMDU1MTViZmVkZTIzMWJhNzBmIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 18:31:31 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlFnSGt1R2NRZVhITGE1Vzg5Y2thb0E9PSIsInZhbHVlIjoiQW9MaFRncml3TC9CaTJmLy9NL2pEaG5icGNFcjBQY0xNVjl1QWtkR1RXVHVnbUVDWWRERk1HZEVmSVN4VHpFQjdWb1hrV ▶"
    1 => "laravel_session=eyJpdiI6ImlreEkxTFJBalpHRTRKbll5d3pPQnc9PSIsInZhbHVlIjoiejY0MFY0UXU3Z05DY3M2UVkyYzV3Q1FTS3VTa1lGYy8vWHh1cTEvVkxNZGg5ZzFxUDZaNkI0SFJIdG8zTVNFTjBCNDJvckZIMDFyaHFSd3o0cWRSYUxUZjd2eVloRWVxUFY5aDh1R29BdzFnajAycVRCVHVhVlN5bjBTUzMvdU0iLCJtYWMiOiI2ZmNlYjQzY2Y1YjE4Y2Y1MjdkMDVhMDNmMGY3YjlkY2Y2OTNiZWNlNjM0MzIyYmZhZTkwOGEwZGZmMzg1ZDRiIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 18:31:31 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImlreEkxTFJBalpHRTRKbll5d3pPQnc9PSIsInZhbHVlIjoiejY0MFY0UXU3Z05DY3M2UVkyYzV3Q1FTS3VTa1lGYy8vWHh1cTEvVkxNZGg5ZzFxUDZaNkI0SFJIdG8zTVNFTjBC ▶"
    2 => "course_id=2; expires=Sat, 25-Apr-2026 16:31:31 GMT; path=/"
    3 => "course_name=MBA+%2F+PGDM; expires=Sat, 25-Apr-2026 16:31:31 GMT; path=/"
    4 => "viewed_colleges=%5B2772%5D; expires=Sun, 25-May-2025 16:31:31 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Y1m8gHONKhMDsFze3Ydo1Qppn3s36m9PMMv5gzFY"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428 ◀https://www.dev.collegesearch.in/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-514 ▶"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-25 16:31:31	GET	/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-master-in-human-resource-development-management-mhrdm-51428	12 64 271

1 x Application (95.08%)	194ms
1 x Booting (4.92%)	10.03ms