"Is PSG Institute of Medical Sciences a public college?"

"No, PSG Institute of Medical Sciences is a private college."

"Which courses are offered by the PSG Institute of Medical Sciences?"

"PSG Institute of Medical Sciences offers MBBS, MS, MD, BPT, B Pharm, B. Sc."

"Is PSG Institute of Medical Sciences MCI approved?"

"Yes, PSG Institute of Medical Sciences is approved by the MCI."

"How to get admission in PSG Institute of Medical Sciences courses?"

"PSG Institute of Medical Sciences admissions are based upon merit and entrance. Accepted entrance for admission is NEET UG and NEET PG."

"Does PSG Institute of Medical Sciences provide hostel facilities?"

"Yes, PSG Institute of Medical Sciences does provide hostel facilities."

PSG Institute of Medical Sciences and Research Coimbatore

Publisher	Year	Ranking
NIRF	2018	21 / 200

Publisher	Year	Ranking
NIRF	2022	35 / 200

Messages1 Timeline Exceptions Views26 Route Queries61 Models52 Mails Gate Session Request

Request history8.3.19541ms4MBGET colleges/{slug}

warninglog[07:01:17] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (10.66ms)time
Application (530ms)time
1 x Application (98.03%)
530ms
1 x Booting (1.97%)
10.66ms

26 templates were rendered

pages.college_v2.indexindex.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
pages.college_v2.partials.navbarnavbar.blade.php#?blade
pages.college_v2.partials.popular_programpopular_program.blade.php#?blade
pages.college_v2.partials.admission_datesadmission_dates.blade.php#?blade
pages.college_v2.partials.cutoffcutoff.blade.php#?blade
pages.college_v2.partials.placementplacement.blade.php#?blade
pages.college_v2.partials.rankingranking.blade.php#?blade
pages.college_v2.partials.course_and_feecourse_and_fee.blade.php#?blade
pages.college_v2.partials.scholarshipscholarship.blade.php#?blade
pages.college_v2.partials.gallerygallery.blade.php#?blade
pages.college_v2.partials.facultyfaculty.blade.php#?blade
pages.college_v2.partials.awards_v2awards_v2.blade.php#?blade
pages.college_v2.partials.alumnialumni.blade.php#?blade
pages.college_v2.partials.partnershippartnership.blade.php#?blade
pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
pages.college_v2.partials.deatailed_review_sectiondeatailed_review_section.blade.php#?blade
pages.college_v2.partials.contactcontact.blade.php#?blade
pages.college_v2.partials.right_side_clgright_side_clg.blade.php#?blade
pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
partials.footerfooter.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade

uri: GET colleges/{slug}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfile
namespace
prefix
where
as: cp.collegeinfo
file: app/Http/Controllers/CollegeController.php:39-713

61 statements were executed, 8 of which were duplicates, 53 unique. Show only duplicated350ms

Connection Establisheddb_collegesearchCacheService.php#460

Backtrace

13. app/Service/CacheService.php:460
14. app/Service/CacheService.php:446
15. middleware::softRedirects:76
16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
17. middleware::crossAppSync:53

select * from `seo_redirects` where `redirect_from` = '/colleges/psg-institute-of-medical-sciences-coimbatore' and `status` = 1 limit 1

8.71msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/psg-institute-of-medical-sciences-coimbatore 1: 1
Backtrace	15. app/Service/CacheService.php:460 16. app/Service/CacheService.php:446 17. middleware::softRedirects:76 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select `ics_link_2` from `institutes` where `ics_link` = 'psg-institute-of-medical-sciences-coimbatore' and `status` = 'Active' limit 1

930μsdb_collegesearchCacheService.php#492

Bindings	0: psg-institute-of-medical-sciences-coimbatore 1: Active
Backtrace	15. app/Service/CacheService.php:492 16. app/Service/CacheService.php:478 17. middleware::softRedirects:88 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'psg-institute-of-medical-sciences-coimbatore') limit 1

1.13msdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: psg-institute-of-medical-sciences-coimbatore
Backtrace	15. app/Http/Controllers/CollegeController.php:52 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institutes`.*, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `campus_videos` where `institutes`.`id` = `campus_videos`.`institute_id` limit 1) as `campus_video_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` = 'info') as `institute_faqs_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institute_insights` where `institutes`.`id` = `institute_insights`.`institute_id` and `status` = 'Y' and `institute_insights`.`deleted_at` is null) as `insights_count`, (select count(*) from `institute_toc` where `institutes`.`id` = `institute_toc`.`institute_id` and `institute_toc`.`deleted_at` is null) as `toc_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institute_impressions_data` where `institutes`.`id` = `institute_impressions_data`.`institute_id` and `location` = 'college_profile' and `date` > '2025-03-09 07:01:17') as `institute_impressions_data_count`, (select count(*) from `requests_new` where `institutes`.`id` = `requests_new`.`institute_id`) as `requests_new_count`, (select count(*) from `student_status` where `institutes`.`id` = `student_status`.`institute_id` and `status` = 'admitted') as `student_status_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `ics_link_2` = 'psg-institute-of-medical-sciences-coimbatore' and `status` = 'Active' limit 1

166msdb_collegesearchCollegeController.php#239

Bindings	0: info 1: Y 2: 43 3: 4: 5: 0 6: 7: 0 8: Alumni 9: 10: college_profile 11: 2025-03-09 07:01:17 12: admitted 13: psg-institute-of-medical-sciences-coimbatore 14: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:239 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_courses`.*, (select count(*) from `institute_courses` as `laravel_reserved_2` where `institute_courses`.`course_type` = `laravel_reserved_2`.`course_type` and `institute_id` = 2747) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (2747) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6

3.61msdb_collegesearchCollegeController.php#239

Bindings	0: 2747 1: active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `sub_course` where `sub_course`.`id` in (4, 17, 2534)

1.78msdb_collegesearchCollegeController.php#239

Bindings	0: 4 1: 17 2: 2534
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (4, 17, 141)

1.39msdb_collegesearchCollegeController.php#239

Bindings	0: 4 1: 17 2: 141
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `ranks` where `ranks`.`course_type` in (4, 17, 141) and `institute_id` = 2747 order by `year` desc

2.09msdb_collegesearchCollegeController.php#239

Bindings	0: 2747
Backtrace	30. app/Http/Controllers/CollegeController.php:239 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (2695, 8493, 53583) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

920μsdb_collegesearchCollegeController.php#239

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_id`, `name`, `first_page`, `title`, `doc_type` from `document` where `document`.`institute_id` in (2747)

1.02msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` in (2747) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc

1.2msdb_collegesearchCollegeController.php#239

Bindings	0: active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_insights` where `institute_insights`.`institute_id` in (2747) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

960μsdb_collegesearchCollegeController.php#239

Bindings	0: Y
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_toc` where `institute_toc`.`institute_id` in (2747) and `institute_toc`.`deleted_at` is null order by `id` desc

19.34msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `images` where `images`.`institute_id` in (2747) and `student_featured` = 0 and `images`.`deleted_at` is null order by case when (is_featured = 1) then 0 when (category = 'campus') then 2 else 3 end, id desc

1.3msdb_collegesearchCollegeController.php#239

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_id`, `video`, `description` from `video_verdict` where `video_verdict`.`institute_id` in (2747) and `status` = '1' order by `id` desc

1.08msdb_collegesearchCollegeController.php#239

Bindings	0: 1
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `campus_videos` where `campus_videos`.`institute_id` in (2747) order by `id` desc limit 1

1.44msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `states` where `states`.`StateID` in (93)

990μsdb_collegesearchCollegeController.php#239

Bindings	0: 93
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `user_reviews`.`institute_id` in (2747) and `status` = 'Active' limit 10

1.71msdb_collegesearchCollegeController.php#239

Bindings	0: Active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (2747) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc

1.66msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (4, 999)

1.56msdb_collegesearchCollegeController.php#239

Bindings	0: 4 1: 999
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (2747) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc, `year` desc

980μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (4, 999)

840μsdb_collegesearchCollegeController.php#239

Bindings	0: 4 1: 999
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` in (2747) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

1.22msdb_collegesearchCollegeController.php#239

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (4)

1.99msdb_collegesearchCollegeController.php#239

Bindings	0: 4
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select session_user_id , institute_id , date_format(ADDTIME(last_modified, '5:30'),'%D %M, %Y') as last_modifi from `admin_reporting` where `admin_reporting`.`institute_id` in (2747) order by `ID` desc limit 1

1.54msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `admin` where `admin`.`ID` in (189)

1.76msdb_collegesearchCollegeController.php#239

Bindings	0: 189
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `writers_profile` where `writers_profile`.`admin_id` in (189)

2.08msdb_collegesearchCollegeController.php#239

Bindings	0: 189
Backtrace	30. app/Http/Controllers/CollegeController.php:239 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (2747)

660μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 2747 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc

19.15msdb_collegesearchCollegeController.php#246

Bindings	0: 2747 1: admission
Backtrace	14. app/Http/Controllers/CollegeController.php:246 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id` from `institute_courses` where `institute_id` = 2747

910μsdb_collegesearchCollegeController.php#248

Bindings	0: 2747
Backtrace	13. app/Http/Controllers/CollegeController.php:248 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 2747 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc

18.08msdb_collegesearchCollegeController.php#250

Bindings	0: 2747 1: cutoff
Backtrace	14. app/Http/Controllers/CollegeController.php:250 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `cutoff_new_shagun_json` where `institute_course_id` in (2695, 8493, 53583) and (`round_id` = 1 and `status` = 1)

3.5msdb_collegesearchCollegeController.php#268

Bindings	0: 2695 1: 8493 2: 53583 3: 1 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:268 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select top_recruiter.name,ro.name as org_name,ri.name as industry_name , rc.city_name ,image, webp_image from top_recruiter
left JOIN recruiter_organization ro on top_recruiter.recuiter_organization_id = ro.id
left JOIN recruiter_industry ri on top_recruiter.recuiter_industry_id = ri.id
left JOIN city rc on top_recruiter.city_id = rc.id WHERE top_recruiter.id IN (0) limit 12

1.12msdb_collegesearchCollegeController.php#297

Backtrace

10. app/Http/Controllers/CollegeController.php:297
11. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
12. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
13. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
14. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id` from `institute_courses` where `institute_id` = 2747

610μsdb_collegesearchCollegeController.php#316

Bindings	0: 2747
Backtrace	13. app/Http/Controllers/CollegeController.php:316 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `h_package`, `l_package`, `a_package`, `ic`.`id`, `ic`.`course_type`, `ct`.`alternate_name` as `ctype`, `year_placement` from `placement_course` left join `institute_courses` as `ic` on `ic`.`id` = `placement_course`.`institute_course_id` left join `course_type` as `ct` on `ct`.`id` = `ic`.`course_type` where `institute_course_id` in (2695, 8493, 53583) and `placement_course`.`deleted_at` is null order by `year_placement` desc

650μsdb_collegesearchCollegeController.php#325

Bindings	0: 2695 1: 8493 2: 53583
Backtrace	14. app/Http/Controllers/CollegeController.php:325 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 2747 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc

17.78msdb_collegesearchCollegeController.php#342

Bindings	0: 2747 1: placement
Backtrace	14. app/Http/Controllers/CollegeController.php:342 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_insights` where `institute_id` = 2747 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

860μsdb_collegesearchCollegeController.php#345

Bindings	0: 2747 1: key_highlights_placement 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:345 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 2747 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc

17.86msdb_collegesearchCollegeController.php#351

Bindings	0: 2747 1: ranking
Backtrace	14. app/Http/Controllers/CollegeController.php:351 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select (SUM(CASE WHEN (overall_rating = '5.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS excellent_count,
(SUM(CASE WHEN (overall_rating = '4.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS good_count,
(SUM(CASE WHEN (overall_rating = '3.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS average_count,
(SUM(CASE WHEN (overall_rating = '2.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS bad_count,
(SUM(CASE WHEN (overall_rating = '1.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS worst_count,
(SUM(CASE WHEN status = 'Rejected' THEN 1 ELSE 0 END)) AS rejected_review,
(SUM(CASE WHEN (fashion_rating >0 AND fashion_rating != '' AND status = 'Active') THEN fashion_rating ELSE 0 END)) AS fashion_review_average,
(SUM(CASE WHEN (sports_rating >0 AND sports_rating != '' AND status = 'Active') THEN sports_rating ELSE 0 END)) AS sports_review_average,
(SUM(CASE WHEN (event_rating >0 AND event_rating != '' AND status = 'Active') THEN event_rating ELSE 0 END)) AS event_review_average,
(SUM(CASE WHEN (hostel_rating >0 AND hostel_rating != '' AND status = 'Active') THEN hostel_rating ELSE 0 END)) AS hostel_review_average,
(SUM(CASE WHEN (canteen_rating >0 AND canteen_rating != '' AND status = 'Active') THEN canteen_rating ELSE 0 END)) AS canteen_review_average,
(SUM(CASE WHEN (infra_rating >0 AND status = 'Active') THEN infra_rating ELSE 0 END)) AS infra_review_average,
(SUM(CASE WHEN (intern_rating >0 AND status = 'Active') THEN intern_rating ELSE 0 END)) AS intern_review_average,
(SUM(CASE WHEN (teacher_rating >0 AND status = 'Active') THEN teacher_rating ELSE 0 END)) AS teacher_review_average,
(SUM(CASE WHEN (admission_rating >0 AND status = 'Active') THEN admission_rating ELSE 0 END)) AS admission_review_average,
(SUM(CASE WHEN (infra_rating > 0 AND infra_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS infra_review_count,
(SUM(CASE WHEN (intern_rating > 0 AND intern_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS intern_review_count,
(SUM(CASE WHEN (admission_rating > 0 AND admission_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS admission_review_count,
(SUM(CASE WHEN (teacher_rating > 0 AND teacher_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS teacher_rating_count,
(SUM(CASE WHEN (fashion_rating > 0 AND fashion_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS fashion_review_count,
(SUM(CASE WHEN (sports_rating > 0 AND sports_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS sports_review_count,
(SUM(CASE WHEN (event_rating > 0 AND event_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS event_review_count,
(SUM(CASE WHEN (hostel_rating > 0 AND hostel_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS hostel_review_count,
(SUM(CASE WHEN (canteen_rating > 0 AND canteen_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS canteen_review_count from `user_reviews` where `institute_id` = 2747

1.07msdb_collegesearchCollegeController.php#388

Bindings	0: 2747
Backtrace	14. app/Http/Controllers/CollegeController.php:388 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 2747 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 4 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

960μsdb_collegesearchCollegeController.php#415

Bindings	0: Active 1: 2747 2: 3: 4: 4
Backtrace	14. app/Http/Controllers/CollegeController.php:415 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 2747 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 4 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.9msdb_collegesearchCollegeController.php#433

Bindings	0: Active 1: 2747 2: 3: 4: 4
Backtrace	14. app/Http/Controllers/CollegeController.php:433 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 2747 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 4 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

840μsdb_collegesearchCollegeController.php#451

Bindings	0: Active 1: 2747 2: 3: 4: 4
Backtrace	14. app/Http/Controllers/CollegeController.php:451 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 2747 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

2.2msdb_collegesearchCollegeController.php#455

Bindings	0: 2747 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:455 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `cutoff_new_shagun_json` left join `institute_courses` on `institute_courses`.`id` = `cutoff_new_shagun_json`.`institute_course_id` where `institute_id` = 2747

2.5msdb_collegesearchCollegeController.php#477

Bindings	0: 2747
Backtrace	15. app/Http/Controllers/CollegeController.php:477 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `name` from `images` where `is_desktop` = 1 and `institute_id` = 2747 and `images`.`deleted_at` is null limit 1

900μsdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 2747
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:527 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `name` from `images` where `is_desktop` = 1 and `institute_id` = 2747 and `images`.`deleted_at` is null limit 1

1.1msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 2747
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:536 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `metatags` where `PageID` = 'colleges/psg-institute-of-medical-sciences-coimbatore' and `status` = 'Y' limit 1

1.2msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/psg-institute-of-medical-sciences-coimbatore 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:549 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_faqs` where `institute_faqs`.`institute_id` = 2747 and `institute_faqs`.`institute_id` is not null

1.02msdb_collegesearchCollegeController.php#613

Bindings	0: 2747
Backtrace	19. app/Http/Controllers/CollegeController.php:613 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `header_name` from `course_type` where `id` = 4 limit 1

670μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 4
Backtrace	15. app/Service/Breadcrumb.php:167 16. app/Service/Breadcrumb.php:37 17. app/Http/Controllers/CollegeController.php:631 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `id`, `is_sunstone` from `inst_campaign_bharat_2022` where `institute_id` = 2747 limit 1

2.83msdb_collegesearchCollegeController.php#637

Bindings	0: 2747
Backtrace	15. app/Http/Controllers/CollegeController.php:637 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_courses`.`course_type`, `course_type`.`course_name`, `course_type`.`id`, `sub_course`.`sub_course_url` from `institute_courses` inner join `course_type` on `institute_courses`.`course_type` = `course_type`.`id` inner join `sub_course` on `institute_courses`.`course_type` = `sub_course`.`course_type_id` where `institute_id` = 2747 group by `course_type`.`id`

9.24msdb_collegesearchCollegeController.php#658

Bindings	0: 2747
Backtrace	14. app/Http/Controllers/CollegeController.php:658 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `inst_campaign_bharat_2022` where `institute_id` = 2747 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'

1.57msdb_collegesearchCollegeController.php#670

Bindings	0: 2747 1: 2025-04-09 2: 2025-04-09
Backtrace	14. app/Http/Controllers/CollegeController.php:670 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` = 2747 and `institute_courses`.`institute_id` is not null limit 1

2.08msdb_collegesearchCollegeController.php#672

Bindings	0: 2747
Backtrace	21. app/Http/Controllers/CollegeController.php:672 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_name_2`, `inst_city`, `inst_state` from `institutes` where `id` = '91'

880μsdb_collegesearchCollegeController.php#686

Bindings	0: 91
Backtrace	14. app/Http/Controllers/CollegeController.php:686 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where modulename like '%cp-info%' and `module_link_id` = 2747 and `expiry_date` > '2025-04-09 07:01:18' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

950μsdb_collegesearchhelpers.php#1695

Bindings	0: 2747 1: 2025-04-09 07:01:18
Backtrace	14. app/helpers.php:1695 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%exam%' and `module_link_id` in ('') and `expiry_date` > '2025-04-09 07:01:18' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

970μsdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 2: 2025-04-09 07:01:18
Backtrace	14. app/helpers.php:1712 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('4', '17', '141') and `expiry_date` > '2025-04-09 07:01:18' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.05msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 4 2: 17 3: 141 4: 2025-04-09 07:01:18
Backtrace	14. app/helpers.php:1726 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `user_reviews` where `user_reviews`.`institute_id` = 2747 and `user_reviews`.`institute_id` is not null

850μsdb_collegesearchhero_section.blade.php#27

Bindings	0: 2747
Backtrace	20. view::pages.college_v2.partials.hero_section:27 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 25. vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `user_reviews` where `user_reviews`.`institute_id` = 2747 and `user_reviews`.`institute_id` is not null

2.16msdb_collegesearchnavbar.blade.php#31

Bindings	0: 2747
Backtrace	19. view::pages.college_v2.partials.navbar:31 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `collaboration` where `collaboration`.`institute_id` = 2747 and `collaboration`.`institute_id` is not null

1.44msdb_collegesearchawards_v2.blade.php#2

Bindings	0: 2747
Backtrace	19. view::pages.college_v2.partials.awards_v2:2 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. vendor/laravel/framework/src/Illuminate/View/View.php:195

select `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp' and `brandings`.`deleted_at` is null

1.42msdb_collegesearchhelpers.php#970

Bindings	0: cp
Backtrace	14. app/helpers.php:970 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 20. vendor/laravel/framework/src/Illuminate/View/View.php:195

App\Models\InstituteCourse: 14InstituteCourse.php#?
App\Models\CourseType: 9CourseType.php#?
App\Models\Rank: 5Rank.php#?
App\Models\Image: 5Image.php#?
App\Models\InstituteFaqs: 5InstituteFaqs.php#?
App\Models\Institute: 3Institute.php#?
App\Models\SubCourse: 3SubCourse.php#?
App\Models\InstituteToc: 1InstituteToc.php#?
App\Models\State: 1State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\InstituteProfile: 1InstituteProfile.php#?
App\Models\UserReview: 1UserReview.php#?
App\Models\MetaTag: 1MetaTag.php#?

_token: w33vZClkK3h1sOyT0XLMbAJyXE92O7sLNxD1Xs3s
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/psg-institute-of-medical-sciences-co...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/psg-institute-of-medical-sciences-coimbatore

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.new.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 => "Wed, 09 Apr 2025 01:31:18 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1SeFFKQjlHRHB2SnVLdEtlWC8rREE9PSIsInZhbHVlIjoidldxVnF2UEhtck1vVEl4eUhJSDdhc1dqam5pTXhmb2VRcy8zREE1N0pyOCtsZE9ScHNXd0pHZ2N1cFAxdDZPZHpFOThiTHd3SlhYQmxFUUpIQTkwbDVXUmt3L09CQW10L0QyWlVDRU9pUnRwQVNGdjBOd01CUnp4eHI1WmNFVTgiLCJtYWMiOiI0YzllOWI3OTkwYjJhMGY3YTk1ZmU3ZjdkNjJkMzkzNjZlMGZlNjNkOTNiMDRiMzZiZTI4OGE1MDA4MTgxNmUyIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 03:31:18 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik1SeFFKQjlHRHB2SnVLdEtlWC8rREE9PSIsInZhbHVlIjoidldxVnF2UEhtck1vVEl4eUhJSDdhc1dqam5pTXhmb2VRcy8zREE1N0pyOCtsZE9ScHNXd0pHZ2N1cFAxdDZPZHpFOThiT ▶"
    1 => "cs_dev_session=eyJpdiI6IkY5QnJibzhvN3ZNQ1pGdWtyeWJzbGc9PSIsInZhbHVlIjoiNnUvUFBlS0loY3oyNG52MDdoK1liVDE1UDdFbXpLSWJYL3d6V0hBeHZITjA4VVVkZjcvSDdLNkNmSU5YOGpDN2ZWdCtFZDBqM0l0bGZGTzAxRjc4Y0hLcmNlQ3NoNWF2UXptOEJPaGRaczZUYURrUENlUGdqSW5yZkgwMWZHc3YiLCJtYWMiOiI2MzhmMDUxOTg0ODQzNWExNjgxN2EwNTc5MTEzZTlkNDRhN2E5MWZjNzRhN2VmMWRiYmVjZGUyMjM5YjBhYzA5IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 03:31:18 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IkY5QnJibzhvN3ZNQ1pGdWtyeWJzbGc9PSIsInZhbHVlIjoiNnUvUFBlS0loY3oyNG52MDdoK1liVDE1UDdFbXpLSWJYL3d6V0hBeHZITjA4VVVkZjcvSDdLNkNmSU5YOGpDN2ZWd ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1SeFFKQjlHRHB2SnVLdEtlWC8rREE9PSIsInZhbHVlIjoidldxVnF2UEhtck1vVEl4eUhJSDdhc1dqam5pTXhmb2VRcy8zREE1N0pyOCtsZE9ScHNXd0pHZ2N1cFAxdDZPZHpFOThiTHd3SlhYQmxFUUpIQTkwbDVXUmt3L09CQW10L0QyWlVDRU9pUnRwQVNGdjBOd01CUnp4eHI1WmNFVTgiLCJtYWMiOiI0YzllOWI3OTkwYjJhMGY3YTk1ZmU3ZjdkNjJkMzkzNjZlMGZlNjNkOTNiMDRiMzZiZTI4OGE1MDA4MTgxNmUyIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 03:31:18 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik1SeFFKQjlHRHB2SnVLdEtlWC8rREE9PSIsInZhbHVlIjoidldxVnF2UEhtck1vVEl4eUhJSDdhc1dqam5pTXhmb2VRcy8zREE1N0pyOCtsZE9ScHNXd0pHZ2N1cFAxdDZPZHpFOThiT ▶"
    1 => "cs_dev_session=eyJpdiI6IkY5QnJibzhvN3ZNQ1pGdWtyeWJzbGc9PSIsInZhbHVlIjoiNnUvUFBlS0loY3oyNG52MDdoK1liVDE1UDdFbXpLSWJYL3d6V0hBeHZITjA4VVVkZjcvSDdLNkNmSU5YOGpDN2ZWdCtFZDBqM0l0bGZGTzAxRjc4Y0hLcmNlQ3NoNWF2UXptOEJPaGRaczZUYURrUENlUGdqSW5yZkgwMWZHc3YiLCJtYWMiOiI2MzhmMDUxOTg0ODQzNWExNjgxN2EwNTc5MTEzZTlkNDRhN2E5MWZjNzRhN2VmMWRiYmVjZGUyMjM5YjBhYzA5IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 03:31:18 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IkY5QnJibzhvN3ZNQ1pGdWtyeWJzbGc9PSIsInZhbHVlIjoiNnUvUFBlS0loY3oyNG52MDdoK1liVDE1UDdFbXpLSWJYL3d6V0hBeHZITjA4VVVkZjcvSDdLNkNmSU5YOGpDN2ZWd ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "w33vZClkK3h1sOyT0XLMbAJyXE92O7sLNxD1Xs3s"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/psg-institute-of-medical-sciences-coimbatore"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 07:01:18	GET	/colleges/psg-institute-of-medical-sciences-coimbatore	1 26 61 52

Particular	Detail
Type \| Establishment Year	Private \| 1985
Affiliated To	The TamilNadu Dr. M.G.R. Medical University
Approved By	MCI
Admission Mode	Online & Offline
Admission Criteria	Merit & Entrance Based
Entrance Accepted	NEET UG
Courses Offered	UG - B. Sc, BPT, B Pharm, D Pharm, MBBS PG - MS, MD PG Diploma
Facilities	Library, Hostel, Cafeteria
Website	https://psgimsr.ac.in/

PSG Institute of Medical Sciences, Coimbatore

PSG Institute of Medical Sciences , Coimbatore Highlights 2025

PSGIMSR Highlights

PSG Institute of Medical Sciences , Coimbatore Popular Courses

PSG Institute of Medical Sciences Rankings

PSG Institute of Medical Sciences, Coimbatore MBBS Rankings

PSG Institute of Medical Sciences, Coimbatore All Courses Rankings

Student's Rating for PSG Institute of Medical Sciences , Coimbatore

PSG Institute of Medical Sciences, Coimbatore Frequently Asked Questions

Is PSG Institute of Medical Sciences a public college?

Which courses are offered by the PSG Institute of Medical Sciences?

Is PSG Institute of Medical Sciences MCI approved?

How to get admission in PSG Institute of Medical Sciences courses?

Does PSG Institute of Medical Sciences provide hostel facilities?

Contact Details

1 x Application (98.03%)	530ms
1 x Booting (1.97%)	10.66ms