PG Diploma in Human Resource Management (PGDHRM) Human Resources in Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Fees Breakup, Total Fees, Eligibility.

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Overview

PG Diploma in Human Resource Management (PGDHRM) Human Resources is a 2 year course at Xavier Institute of Social Service (XISS) - Ranchi, Ranchi. The total fees for PG Diploma in Human Resource Management (PGDHRM) Human Resources at Xavier Institute of Social Service (XISS) - Ranchi, Ranchi is 8,90,000. To get admission in PG Diploma in Human Resource Management (PGDHRM) Human Resources at Xavier Institute of Social Service (XISS) - Ranchi, Ranchi, students must meet some eligibility requirements, that is Minimum qualification for admission to the two years full-time post-graduate management programs - PGDM at the Institute is three / four years bachelor’s degree with minimum 50% marks in aggregate (45% for SC/ST) in any discipline recognized by Association of Indian Universities. However preference will be given to Engineering, Economics, Commerce, Management and Computer Science graduates and candidates with relevant work experience.. This program helps students with the necessary skills to build a successful career in the Management.

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Highlights

Particular	Details
Total Seats	N/A
Course Fee	8,90,000
Duration	2 Years
Accepted Exams	CAT, TANCET, TNEA

About PG Diploma in Human Resource Management (PGDHRM) Human Resources

Program Duration
Full Time ,2 Years

Course Type
PG , Management

Eligibility
Minimum qualification for admission to the two years full-time post-graduate management programs - PGDM at the Institute is three / four years bachelor’s degree with minimum 50% marks in aggregate (45% for SC/ST) in any discipline recognized by Association of Indian Universities. However preference will be given to Engineering, Economics, Commerce, Management and Computer Science graduates and candidates with relevant work experience. Read More

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Fee Structure

PG Diploma in Human Resource Management (PGDHRM) Human Resources fees for Xavier Institute of Social Service (XISS) - Ranchi, Ranchi 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:

PG Diploma in Human Resource Management (PGDHRM) Human Resources Fee Breakup

Fees (Rs.)	Year 1	Year 2
Total Fees	₹ 4,45,000	₹ 4,45,000

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Eligibility

Students who are seeking admission in 2 year MBA / PGDM PG Diploma in Human Resource Management (PGDHRM) Human Resources program at the Xavier Institute of Social Service (XISS) - Ranchi, Ranchi should meet the following eligibility criteria.

Minimum qualification for admission to the two years full-time post-graduate management programs - PGDM at the Institute is three / four years bachelor’s degree with minimum 50% marks in aggregate (45% for SC/ST) in any discipline recognized by Association of Indian Universities. However preference will be given to Engineering, Economics, Commerce, Management and Computer Science graduates and candidates with relevant work experience.

Popular Exams

CAT MBA / PGDM

Exam Month

November

Accepting Colleges

Last Date to Apply

29th November, 2025

TANCET MBA / PGDM

Exam Month

March

Accepting Colleges

Last Date to Apply

22nd March, 2025

TNEA MBA / PGDM

Exam Month

N/A

Accepting Colleges

Last Date to Apply

N/A

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Admission Process

To take admission in PG Diploma in Human Resource Management (PGDHRM) Human Resources at Xavier Institute of Social Service (XISS) - Ranchi, Ranchi, candidates must possess a valid score in CAT, TANCET, TNEA or any other state-level examination.

As per University norms

PG Diploma in Human Resource Management (PGDHRM) Human Resources Fee Payment Options

Xavier Institute of Social Service (XISS) - Ranchi, Ranchi 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 Xavier Institute of Social Service (XISS) - Ranchi, Ranchi.
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 Xavier Institute of Social Service (XISS) - Ranchi, Ranchi campus.
Delay in fee payment can cause a fine as per Xavier Institute of Social Service (XISS) - Ranchi, Ranchi rules and regulations.

Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Fees Inquiry

Contact Information for students to find out more about the Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Fees

Contact Number - 2200873,2204456,
E-mail at: rohitvishal@xiss.ac.in
Admission Block Address - Dr. Camil Bulcke Path (Purulia Road), Post BOX - 7

PG Diploma in Human Resource Management (PGDHRM) Human Resources Placement in Xavier Institute of Social Service (XISS) - Ranchi, Ranchi

PG Diploma in Human Resource Management (PGDHRM) Human Resources Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Top Recruiters

ACC Limited

HDFC Bank

Bharat Petroleum Corporation Limited (BPCL)

Crompton Greaves Ltd.

Federal Bank

maruti suzuki

Jet Airways

JINDAL POWER AND STEEL

Idea Cellular

ICICI Prudential

TCS

TATA MOTORS

Oracle

Trident Group

WNS Group

UCO Bank

View All Recruiters Details

Student's Rating for Xavier Institute of Social Service (XISS) - Ranchi, Ranchi

Student Reviews & Ratings

4/5 Based on 6 Verified Reviews

Component Ratings

Faculty Rating 4

Infrastructure Rating 3.8

Hostel Rating 3

Club Rating 3

Student's Reviews for Xavier Institute of Social Service (XISS) - Ranchi, Ranchi

Admission

Placement

Faculty

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4.5 Mess

Just 15 days ago I have joined this college and right now I am exploring this college and I am pursuing my PGDM in IT from this college and this college accepts the result of each and every examination whether it is CAT, XAT, MAT or any other The total

Placement: Not all get placed but the majority of the students gets placed

Faculty: The College faculties are too good

Admission: State / National Entrance Exams

4 Overall 25-07-2021

Anonymous User
MBA Student

3 Infrastructure 3.5 Faculty 3 Hostel 3 Club

overall xiss is good for mba. its ROI is much better than some private college. for rural development it is one of best college in India

Admission: State / National Entrance Exams

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4.5 Mess

Placement: Not all get placed but the majority of the students gets placed

Faculty: The College faculties are too good

Admission: State / National Entrance Exams

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4.5 Mess

Placement: Not all get placed but the majority of the students gets placed

Faculty: The College faculties are too good

Admission: State / National Entrance Exams

View All 6 Reviews

Gallery

30 Images

Xavier Institute of Social Service (XISS) - Ranchi, Ranchi Program Offered

4.5 PG Diploma in Human Resource Management (PGDHRM) Marketing

2 Years

Total Fees

₹8,90,000

Highest Package

N/A

4.5 PG Diploma in Human Resource Management (PGDHRM) Financial Services

2 Years

Total Fees

₹8,90,000

Highest Package

N/A

4.5 PG Diploma in Human Resource Management (PGDHRM) Rural Management

2 Years

Total Fees

₹8,90,000

Highest Package

N/A

View All Programs

Contact Details

Address

Dr. Camil Bulcke Path (Purulia Road), Post BOX - 7

College Contact

22XXXXXX56

roXXXXXXin

Messages Timeline Exceptions Views13 Route Queries67 Models246 Mails Gate Session Request

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

Booting (11.05ms)time
Application (441ms)time
1 x Application (97.55%)
441ms
1 x Booting (2.44%)
11.05ms

13 templates were rendered

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

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

67 statements were executed (9 duplicates)Show only duplicates306ms

SoftRedirects.php#22db_collegesearch_newConnection Established

Backtrace

app/Http/Middleware/SoftRedirects.php:22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

SoftRedirects.php#22db_collegesearch_new7.04ms

select * from `seo_redirects` where `redirect_from` = '/colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239' limit 1

Bindings	0: /colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239
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_new960μs

select * from `meta_tags` where `slug` = 'colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239 1: active
Backtrace	app/Http/Middleware/MetaChecker.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SoftRedirects.php:28 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51

helpers.php#722db_collegesearch_new1.18ms

select * from `default_meta_tags` where `module` = 'college' and `default_meta_tags`.`deleted_at` is null and `status` = 'active'

Bindings	0: college 1: active
Backtrace	app/helpers.php:722 vendor/laravel/framework/src/Illuminate/Container/Container.php:989 vendor/laravel/framework/src/Illuminate/Container/Container.php:819 vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048 vendor/laravel/framework/src/Illuminate/Container/Container.php:755

CollegeController.php#66db_collegesearch_new1.71ms

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` = 'xavier-institute-of-social-service-xiss-ranchi' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: xavier-institute-of-social-service-xiss-ranchi 2: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new1.02ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new1.97ms

select `id`, `name` from `programs` where `programs`.`id` in (2265, 2267, 2289, 2327, 3422, 3517, 3553, 3561, 5104) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new1.46ms

select `id`, `name` 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:66 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#66db_collegesearch_new7.45ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5238, 5239, 5240, 5241, 51422, 51423, 51424, 51425, 51426) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new880μs

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (5238, 5239, 5240, 5241, 51422, 51423, 51424, 51425, 51426) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new710μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5238, 5239, 5240, 5241, 51422, 51423, 51424, 51425, 51426) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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_new680μs

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

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

Institute.php#189db_collegesearch_new860μ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:279 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#711db_collegesearch_new23.28ms

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

CollegeController.php#282db_collegesearch_new1.21ms

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

Bindings	0: 2771
Backtrace	app/Http/Controllers/CollegeController.php:282 app/Http/Controllers/CollegeController.php:76 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#282db_collegesearch_new720μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:282 app/Http/Controllers/CollegeController.php:76 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#747db_collegesearch_new12.08ms

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

Bindings	0: 2771 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:747 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#747db_collegesearch_new1.41msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:747
app/Http/Controllers/CollegeController.php:283
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#758db_collegesearch_new16.57ms

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:758 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new1.42ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2771 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 2771 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:759 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#760db_collegesearch_new3.76ms

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:760 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new1.12ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 2771 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 2771 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:285 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new4.18ms

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

Institute.php#151db_collegesearch_new1.19ms

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

Institute.php#151db_collegesearch_new2.87msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

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

Institute.php#138db_collegesearch_new4.45ms

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

Institute.php#151db_collegesearch_new8.14ms

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

Institute.php#151db_collegesearch_new2.48msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

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

Institute.php#138db_collegesearch_new4.07ms

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

Institute.php#151db_collegesearch_new6.2ms

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

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

Backtrace

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

CollegeController.php#499db_collegesearch_new7.26ms

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

Bindings	0: 2771 1: 5239 2: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new7.23ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new4.14ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new7.29msselect * 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:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new4.06msselect * 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:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new3.12msselect * 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:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new4.35ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new5.13msselect * from `fees_types` where `fees_types`.`id` in (12)

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
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#499db_collegesearch_new4.54ms

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

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
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#499db_collegesearch_new4.48ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new3.35ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21, 184, 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:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new4.98ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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_new8.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:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new800μs

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

Exam.php#58db_collegesearch_new6.45ms

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

Bindings	0: 184 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new2.97ms

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

Exam.php#58db_collegesearch_new4.58ms

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

Institute.php#277db_collegesearch_new4.66ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 2771 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: 2771 1: cs 2: nirf 3: 2 4: active
Backtrace	app/Models/Institute.php:277 app/Http/Controllers/CollegeController.php:510 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#520db_collegesearch_new890μs

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

Bindings	0: 2 1: 2771 2: 5239 3: active
Backtrace	app/Http/Controllers/CollegeController.php:520 app/Http/Controllers/CollegeController.php:76 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#520db_collegesearch_new1.94ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:520 app/Http/Controllers/CollegeController.php:76 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#524db_collegesearch_new7.66ms

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:524 app/Http/Controllers/CollegeController.php:76 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#524db_collegesearch_new2.01ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (82, 128, 229, 1098, 1336, 1579, 1688, 1899, 2018, 2086, 2176, 2773, 3158, 4155, 6003, 6368)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
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#524db_collegesearch_new1.26ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (4, 6, 10, 15, 19, 38, 63, 253, 266, 345)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
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#529db_collegesearch_new6.71ms

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

Bindings	0: 2771 1: 2 2: active
Backtrace	app/Http/Controllers/CollegeController.php:529 app/Http/Controllers/CollegeController.php:76 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#537db_collegesearch_new7.21ms

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 (5238, 5239, 5240, 5241, 51422, 51423, 51424, 51425, 51426) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 5238 1: 5239 2: 5240 3: 5241 4: 51422 5: 51423 6: 51424 7: 51425 8: 51426 9: active
Backtrace	app/Http/Controllers/CollegeController.php:537 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#226db_collegesearch_new32.73ms

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

CollegeController.php#661db_collegesearch_new970μs

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:661 app/Http/Controllers/CollegeController.php:76 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#662db_collegesearch_new970μs

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:662 app/Http/Controllers/CollegeController.php:76 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#245db_collegesearch_new650μs

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

Bindings	0: 5239 1: active
Backtrace	app/Http/Controllers/CollegeController.php:245 app/Http/Controllers/CollegeController.php:95 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#245db_collegesearch_new720μ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:245 app/Http/Controllers/CollegeController.php:95 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#974db_collegesearch_new11.04ms

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

Bindings	0: 2771 1: active
Backtrace	app/Http/Controllers/CollegeController.php:974 app/Http/Controllers/CollegeController.php:96 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#980db_collegesearch_new2.35ms

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

Bindings	0: 2771
Backtrace	app/Http/Controllers/CollegeController.php:980 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#496db_collegesearch_new3.58ms

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` = 2771 and `expiry_date` > '2025-06-18 09:53:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 2771 3: 2025-06-18 09:53:45
Backtrace	app/helpers.php:496 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#511db_collegesearch_new2.69ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('21', '184', '2240', '2063') and `expiry_date` > '2025-06-18 09:53:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 21 3: 184 4: 2240 5: 2063 6: 2025-06-18 09:53:45
Backtrace	app/helpers.php:511 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#525db_collegesearch_new2.32ms

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') and `sub_type` like '%about%' and `expiry_date` > '2025-06-18 09:53:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 2 2: %about% 3: 2025-06-18 09:53:45
Backtrace	app/helpers.php:525 app/Http/Controllers/CollegeController.php:96 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#826db_collegesearch_new730μs

select * from `meta_tags` where `slug` = 'colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239 1: active
Backtrace	app/Http/Controllers/CollegeController.php:826 app/Http/Controllers/CollegeController.php:128 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#157db_collegesearch_new9.85msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

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

App\Models\InstituteImage: 60InstituteImage.php#?
App\Models\InstituteProgram: 24InstituteProgram.php#?
App\Models\InstituteProgramPlacement: 18InstituteProgramPlacement.php#?
App\Models\InstituteRecruiter: 16InstituteRecruiter.php#?
App\Models\Recruiter: 16Recruiter.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramFeesSummary: 13InstituteProgramFeesSummary.php#?
App\Models\InstituteContent: 12InstituteContent.php#?
App\Models\ExamFeatureMapping: 10ExamFeatureMapping.php#?
App\Models\RecruiterIndustryType: 10RecruiterIndustryType.php#?
App\Models\Program: 9Program.php#?
App\Models\ExamFeature: 9ExamFeature.php#?
App\Models\InstituteProgramExamMapping: 7InstituteProgramExamMapping.php#?
App\Models\InstituteReview: 4InstituteReview.php#?
App\Models\Course: 3Course.php#?
App\Models\User: 3User.php#?
App\Models\Exam: 3Exam.php#?
App\Models\Branding: 3Branding.php#?
App\Models\InstituteProgramFee: 2InstituteProgramFee.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\Admin: 1Admin.php#?
App\Models\InstituteFaculty: 1InstituteFaculty.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\FeesType: 1FeesType.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: 5op9Y8D41OZZTf8AU7XpOKnWPH2yL3dJh753uipW
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/xavier-institute-of-social-service-x...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239

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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

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 => "Wed, 18 Jun 2025 09:53:45 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllwZ0QxN1NXUVgvRlE2b1pZNm5yckE9PSIsInZhbHVlIjoiT3I5ZTJOT1JGR2c4dGhqMlZoaWFvK1VYODdiaEZscnFFSHBRWDIrd2dGUFBVTU1YUUYzeWU4K2ZXK0gyakNVeERoK1Y4anU1YXdyOHpXV2t3ZStXcHM3WmthU3ZDT1k3OHJna0MrMUdJaWxna21PVlZUWVhsUUNXQk1uWGgwYm0iLCJtYWMiOiJkYTYwZDNiYmM4YjNkMGU4NzUzZjhjZjc1NmYyMGVmNTUzZDFiZDEzNmI0YWZmZjU5Y2U4ZTM1NDM3ZjY1MzY3IiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 11:53:45 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IllwZ0QxN1NXUVgvRlE2b1pZNm5yckE9PSIsInZhbHVlIjoiT3I5ZTJOT1JGR2c4dGhqMlZoaWFvK1VYODdiaEZscnFFSHBRWDIrd2dGUFBVTU1YUUYzeWU4K2ZXK0gyakNVeERoK1Y4a ▶"
    1 => "laravel_session=eyJpdiI6InI2Q29idVhXZ1Q1RE9wS0FqbjlHTWc9PSIsInZhbHVlIjoiMW92OGdoeWJCbTJpYkMvS0NRTEpzU01XNVl1eSt3cXJiSUl1RS9qeGVCL2ZmM0t5YmRuUTNLUjBEaFhUMkI2anFOYjZCU0xRMGRwNmhHK0RYNVh6b0RDN3dnaGhqZml2ZXZvWDJhWmVxQW5ydWFpdEpZSktVM0J1aW5JV2VHeUUiLCJtYWMiOiI4YzExMmU0NWI3YzIxMWE3MjdjOGEzMGE2YzYzM2JiNzhhMDU5M2RiM2M5NmJlMWI1NzBiMmFlODkzZjU4ZWJjIiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 11:53:45 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6InI2Q29idVhXZ1Q1RE9wS0FqbjlHTWc9PSIsInZhbHVlIjoiMW92OGdoeWJCbTJpYkMvS0NRTEpzU01XNVl1eSt3cXJiSUl1RS9qeGVCL2ZmM0t5YmRuUTNLUjBEaFhUMkI2anFO ▶"
    2 => "course_id=2; expires=Thu, 18 Jun 2026 09:53:45 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MBA%20%2F%20PGDM; expires=Thu, 18 Jun 2026 09:53:45 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B2771%5D; expires=Fri, 18 Jul 2025 09:53:45 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllwZ0QxN1NXUVgvRlE2b1pZNm5yckE9PSIsInZhbHVlIjoiT3I5ZTJOT1JGR2c4dGhqMlZoaWFvK1VYODdiaEZscnFFSHBRWDIrd2dGUFBVTU1YUUYzeWU4K2ZXK0gyakNVeERoK1Y4anU1YXdyOHpXV2t3ZStXcHM3WmthU3ZDT1k3OHJna0MrMUdJaWxna21PVlZUWVhsUUNXQk1uWGgwYm0iLCJtYWMiOiJkYTYwZDNiYmM4YjNkMGU4NzUzZjhjZjc1NmYyMGVmNTUzZDFiZDEzNmI0YWZmZjU5Y2U4ZTM1NDM3ZjY1MzY3IiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 11:53:45 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IllwZ0QxN1NXUVgvRlE2b1pZNm5yckE9PSIsInZhbHVlIjoiT3I5ZTJOT1JGR2c4dGhqMlZoaWFvK1VYODdiaEZscnFFSHBRWDIrd2dGUFBVTU1YUUYzeWU4K2ZXK0gyakNVeERoK1Y4a ▶"
    1 => "laravel_session=eyJpdiI6InI2Q29idVhXZ1Q1RE9wS0FqbjlHTWc9PSIsInZhbHVlIjoiMW92OGdoeWJCbTJpYkMvS0NRTEpzU01XNVl1eSt3cXJiSUl1RS9qeGVCL2ZmM0t5YmRuUTNLUjBEaFhUMkI2anFOYjZCU0xRMGRwNmhHK0RYNVh6b0RDN3dnaGhqZml2ZXZvWDJhWmVxQW5ydWFpdEpZSktVM0J1aW5JV2VHeUUiLCJtYWMiOiI4YzExMmU0NWI3YzIxMWE3MjdjOGEzMGE2YzYzM2JiNzhhMDU5M2RiM2M5NmJlMWI1NzBiMmFlODkzZjU4ZWJjIiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 11:53:45 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6InI2Q29idVhXZ1Q1RE9wS0FqbjlHTWc9PSIsInZhbHVlIjoiMW92OGdoeWJCbTJpYkMvS0NRTEpzU01XNVl1eSt3cXJiSUl1RS9qeGVCL2ZmM0t5YmRuUTNLUjBEaFhUMkI2anFO ▶"
    2 => "course_id=2; expires=Thu, 18-Jun-2026 09:53:45 GMT; path=/"
    3 => "course_name=MBA+%2F+PGDM; expires=Thu, 18-Jun-2026 09:53:45 GMT; path=/"
    4 => "viewed_colleges=%5B2771%5D; expires=Fri, 18-Jul-2025 09:53:45 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "5op9Y8D41OZZTf8AU7XpOKnWPH2yL3dJh753uipW"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-18 09:53:45	GET	/colleges/xavier-institute-of-social-service-xiss-ranchi/courses-fees/mba-mba-pgdm-human-resources-5239	13 67 246

1 x Application (97.55%)	441ms
1 x Booting (2.44%)	11.05ms