Post Graduate Diploma in Business Management (PGDBM) Human Resources in XLRI Jamshedpur, Jamshedpur Fees Breakup, Total Fees, Eligibility.

Post Graduate Diploma in Business Management (PGDBM) Human Resources XLRI Jamshedpur, Jamshedpur Overview

Post Graduate Diploma in Business Management (PGDBM) Human Resources is a 2 year course at XLRI Jamshedpur, Jamshedpur. The total fees for Post Graduate Diploma in Business Management (PGDBM) Human Resources at XLRI Jamshedpur, Jamshedpur is -. To get admission in Post Graduate Diploma in Business Management (PGDBM) Human Resources at XLRI Jamshedpur, Jamshedpur, students must meet some eligibility requirements, that is Hold a minimum of three years Bachelor's Degree from a recognized University in India/abroad in any discipline. This program helps students with the necessary skills to build a successful career in the Management.

Post Graduate Diploma in Business Management (PGDBM) Human Resources XLRI Jamshedpur, Jamshedpur Highlights

Particular	Details
Total Seats	180
Course Fee	N/A
Duration	2 Years
Accepted Exams	CMAT, TNEA, CAT

About Post Graduate Diploma in Business Management (PGDBM) Human Resources

Program Duration
Full Time ,2 Years

Course Type
PG , Management

Eligibility
Hold a minimum of three years Bachelor's Degree from a recognized University in India/abroad in any discipline Read More

Post Graduate Diploma in Business Management (PGDBM) Human Resources XLRI Jamshedpur, Jamshedpur Fee Structure

Post Graduate Diploma in Business Management (PGDBM) Human Resources 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:

Post Graduate Diploma in Business Management (PGDBM) Human Resources Fee Breakup

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

Post Graduate Diploma in Business Management (PGDBM) Human Resources XLRI Jamshedpur, Jamshedpur Eligibility

Students who are seeking admission in 2 year MBA / PGDM Post Graduate Diploma in Business Management (PGDBM) Human Resources program at the XLRI Jamshedpur, Jamshedpur should meet the following eligibility criteria.

Hold a minimum of three years Bachelor's Degree from a recognized University in India/abroad in any discipline

Popular Exams

CMAT MBA / PGDM

Exam Month

N/A

Accepting Colleges

Last Date to Apply

N/A

TNEA MBA / PGDM

Exam Month

N/A

Accepting Colleges

Last Date to Apply

N/A

CAT MBA / PGDM

Exam Month

November

Accepting Colleges

Last Date to Apply

29th November, 2025

Post Graduate Diploma in Business Management (PGDBM) Human Resources 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)

Post Graduate Diploma in Business Management (PGDBM) Human Resources 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)

Messages1 Timeline Exceptions Views12 Route Queries66 Models275 Mails Gate Session Request

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

warninglog[16:22:19] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...

Booting (26.78ms)time
Application (216ms)time
1 x Application (88.97%)
216ms
1 x Booting (11.03%)
26.78ms

12 templates were rendered

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

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

66 statements were executed (9 duplicates)Show only duplicates129ms

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_new9.09ms

select * from `seo_redirects` where `redirect_from` = '/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245' limit 1

Bindings	0: /colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245
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.38ms

select * from `meta_tags` where `slug` = 'colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245 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_new2.25ms

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

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

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

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

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_new1.15ms

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

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

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

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_new700μ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.82ms

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_new710μ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.34ms

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_new1.36ms

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_new990μ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_new990μ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: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.6ms

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_new1.83ms

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

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

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_new680μ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_new2.03ms

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

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_new2.61msselect `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_new1.06ms

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

Bindings	0: 2772 1: 5245 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_new960μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5245) 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_new690μs

select `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5245) 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_new590μsselect * 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.46msselect * 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.22msselect * 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_new730μs

select * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (5245) 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_new570μ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_new590μs

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

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

select `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21, 93, 2240) 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.3ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21, 93, 2240) 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_new2.11ms

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

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

Bindings	0: 93 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php: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.6ms

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

Bindings	0: 2240 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php: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_new900μs

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

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

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_new980μsselect * 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.9ms

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

Bindings	0: 2 1: 2772 2: 5245 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.22ms

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_new1ms

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

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

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

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

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_new26.44ms

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_new1.25ms

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_new1.59ms

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

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

Bindings	0: 5245 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_new950μ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.69ms

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_new1.14ms

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

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-27 16:22:19' 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-27 16:22:19
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_new3.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 ('93', '2240', '21', '132', '23', '15', '116') and `expiry_date` > '2025-04-27 16:22:19' 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-27 16:22:19
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.62ms

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-27 16:22:19' 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-27 16:22:19
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.51ms

select * from `meta_tags` where `slug` = 'colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245 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_new7.73msselect * 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: 10InstituteProgramExamMapping.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\Exam: 3Exam.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\InstituteRank: 1InstituteRank.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: GCBQ41ccryPpkJ6eZMNFDCLgbemhEeNiqIog53GT
_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-mba-pgdm-human-resources-5245

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 => "Sun, 27 Apr 2025 16:22:19 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im5aZXc5TEpPTTVZMllaQ2tjVzdsNVE9PSIsInZhbHVlIjoib0tvMEdCN0N1TkxDMWlIVzhTTVFXbWM4M3FLVjROb1lhaW1udG9mZ2RGM3FRYjViQW9VZkVVeUs4NmFKZm9yNTRuNVhBenZOREk5YVZyNThTT2Q0bWs0SHhGanRjZm5PNGNPVkZZVTE4QlV5Vll1N29jYm4zU2M5S1VXN1lPOUkiLCJtYWMiOiI2NGMyN2ZkODBhMDM4Mjc5NDc1MDU5OGNkYjljZWQ4YTE2YjQyZjUzMGMwNjYwZTM5MTQ2NjE5MmYzZjhiYmY4IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 18:22:19 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im5aZXc5TEpPTTVZMllaQ2tjVzdsNVE9PSIsInZhbHVlIjoib0tvMEdCN0N1TkxDMWlIVzhTTVFXbWM4M3FLVjROb1lhaW1udG9mZ2RGM3FRYjViQW9VZkVVeUs4NmFKZm9yNTRuNVhBe ▶"
    1 => "laravel_session=eyJpdiI6InBYZG83eldaWWMzZTR3dEJDTUlTZ0E9PSIsInZhbHVlIjoiVm1MbnYrTXZmci9mUFZ1YVg1UGpwc0ZzSFVoUzNsS3FJZ1ZNZFl6SkY2a3hHSEVSb0NTVzBPWHk5djl2a3EyVFlKRTM0QzBhZkhlVGw4emdLUUJ2VnBORHdPRUJDNDRjUmh1YmE5MFEvd000RFRVNmdjSitHeEVnV2gyS2JyU0EiLCJtYWMiOiIzM2FkYzA1OGI4MDMxMTRiNTgyNjVmYWIxYTA1M2NmNjRkZWYwMDQ0MDgyMDAzYThmNjUzZGJmMGVmODIzMzgwIiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 18:22:19 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6InBYZG83eldaWWMzZTR3dEJDTUlTZ0E9PSIsInZhbHVlIjoiVm1MbnYrTXZmci9mUFZ1YVg1UGpwc0ZzSFVoUzNsS3FJZ1ZNZFl6SkY2a3hHSEVSb0NTVzBPWHk5djl2a3EyVFlK ▶"
    2 => "course_id=2; expires=Mon, 27 Apr 2026 16:22:19 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MBA%20%2F%20PGDM; expires=Mon, 27 Apr 2026 16:22:19 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B2772%5D; expires=Tue, 27 May 2025 16:22:19 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im5aZXc5TEpPTTVZMllaQ2tjVzdsNVE9PSIsInZhbHVlIjoib0tvMEdCN0N1TkxDMWlIVzhTTVFXbWM4M3FLVjROb1lhaW1udG9mZ2RGM3FRYjViQW9VZkVVeUs4NmFKZm9yNTRuNVhBenZOREk5YVZyNThTT2Q0bWs0SHhGanRjZm5PNGNPVkZZVTE4QlV5Vll1N29jYm4zU2M5S1VXN1lPOUkiLCJtYWMiOiI2NGMyN2ZkODBhMDM4Mjc5NDc1MDU5OGNkYjljZWQ4YTE2YjQyZjUzMGMwNjYwZTM5MTQ2NjE5MmYzZjhiYmY4IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 18:22:19 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im5aZXc5TEpPTTVZMllaQ2tjVzdsNVE9PSIsInZhbHVlIjoib0tvMEdCN0N1TkxDMWlIVzhTTVFXbWM4M3FLVjROb1lhaW1udG9mZ2RGM3FRYjViQW9VZkVVeUs4NmFKZm9yNTRuNVhBe ▶"
    1 => "laravel_session=eyJpdiI6InBYZG83eldaWWMzZTR3dEJDTUlTZ0E9PSIsInZhbHVlIjoiVm1MbnYrTXZmci9mUFZ1YVg1UGpwc0ZzSFVoUzNsS3FJZ1ZNZFl6SkY2a3hHSEVSb0NTVzBPWHk5djl2a3EyVFlKRTM0QzBhZkhlVGw4emdLUUJ2VnBORHdPRUJDNDRjUmh1YmE5MFEvd000RFRVNmdjSitHeEVnV2gyS2JyU0EiLCJtYWMiOiIzM2FkYzA1OGI4MDMxMTRiNTgyNjVmYWIxYTA1M2NmNjRkZWYwMDQ0MDgyMDAzYThmNjUzZGJmMGVmODIzMzgwIiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 18:22:19 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6InBYZG83eldaWWMzZTR3dEJDTUlTZ0E9PSIsInZhbHVlIjoiVm1MbnYrTXZmci9mUFZ1YVg1UGpwc0ZzSFVoUzNsS3FJZ1ZNZFl6SkY2a3hHSEVSb0NTVzBPWHk5djl2a3EyVFlK ▶"
    2 => "course_id=2; expires=Mon, 27-Apr-2026 16:22:19 GMT; path=/"
    3 => "course_name=MBA+%2F+PGDM; expires=Mon, 27-Apr-2026 16:22:19 GMT; path=/"
    4 => "viewed_colleges=%5B2772%5D; expires=Tue, 27-May-2025 16:22:19 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "GCBQ41ccryPpkJ6eZMNFDCLgbemhEeNiqIog53GT"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-27 16:22:19	GET	/colleges/xlri-xavier-school-of-management-jamshedpur/courses-fees/mba-mba-pgdm-human-resources-5245	1 12 66 275

1 x Application (88.97%)	216ms
1 x Booting (11.03%)	26.78ms