Jaya Group of Institutions Courses and Fee Structure 2025

Course	Total Fees
Bachelor of Technology (B.Tech) 4 Years \| Fulltime \| On Campus	₹ 2,00,000 Fees Details
Bachelor of Engineering 4 Years \| Fulltime \| On Campus	-
Master of Business Administration(MBA) 2 Years \| Fulltime \| On Campus	-
Bachelor of Medicine, Bachelor of Surgery (MBBS) 5 Years \| Fulltime \| On Campus	-
Bachelor of Business Administration (BBA) 3 Years \| Fulltime \| On Campus	-
Master of Computer Application 3 Years \| Fulltime \| On Campus	-
Master of Engineering 2 Years \| Fulltime \| On Campus	-
Master of Technology (M.Tech) 2 Years \| Fulltime \| On Campus	-
Bachelor of Computer Application (BCA) 3 Years \| Fulltime \| On Campus	-
Doctor of Medicine (MD) 3 Years \| Fulltime \| On Campus	-
Bachelor of Arts (BA) 3 Years \| Fulltime \| On Campus	-
Bachelor of Commerce(B.Com.) 3 Years \| Fulltime \| On Campus	-
Master of Commerce 2 Years \| Fulltime \| On Campus	-
B.Sc Nursing 4 Years \| Fulltime \| On Campus	-
Bachelor of Science (B.Sc) 3 Years \| Fulltime \| On Campus	-
B.Sc. Post Basic Nursing 2 Years \| Fulltime \| On Campus	-
B.Ed 1 Years \| Fulltime \| On Campus	-
M.Sc Nursing 2 Years \| Fulltime \| On Campus	-
Master of Science(M.Sc.) 2 Years \| Fulltime \| On Campus	-
Bachelor of Dental Surgery 5 Years \| Fulltime \| On Campus	-
Master of Dental Surgery 3 Years \| Fulltime \| On Campus	-

Messages1 Timeline Exceptions Views14 Route Queries62 Models231 Mails Gate Session Request

Request history8.3.19987ms6MBGET colleges/{slug}/{tab}

warninglog[12:23:48] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (10.34ms)time
Application (977ms)time
1 x Application (98.95%)
977ms
1 x Booting (1.05%)
10.34ms

14 templates were rendered

pages.college_v2.courses-feescourses-fees.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.latest_updateslatest_updates.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.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}/{tab}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfileTab
namespace
prefix
where
as: cp.collegetabs
file: app/Http/Controllers/CollegeController.php:715-2899

62 statements were executed, 18 of which were duplicates, 44 unique. Show only duplicated512ms

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/jaya-group-of-institutions-chennai/courses-fees' and `status` = 1 limit 1

7.59msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/jaya-group-of-institutions-chennai/courses-fees 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` = 'jaya-group-of-institutions-chennai' and `status` = 'Active' limit 1

1.81msdb_collegesearchCacheService.php#492

Bindings	0: jaya-group-of-institutions-chennai 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 * from `institutes` where (`status` = 'Active' and `ics_link_2` = 'jaya-group-of-institutions-chennai') limit 1

2.02msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: jaya-group-of-institutions-chennai
Backtrace	15. app/Http/Controllers/CollegeController.php:723 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 `sub_course` where `sub_course_url` = 'courses-fees' limit 1

3.47msdb_collegesearchCollegeController.php#746

Bindings	0: courses-fees
Backtrace	15. app/Http/Controllers/CollegeController.php:746 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_courses` where `institute_courses`.`institute_id` = 11765 and `institute_courses`.`institute_id` is not null

2.81msdb_collegesearchCollegeController.php#771

Bindings	0: 11765
Backtrace	20. app/Http/Controllers/CollegeController.php:771 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`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_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 `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` LIKE '%cutoff%') as `institute_faqs_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_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 `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `institutes`.`id` in (11765)

219msdb_collegesearchCollegeController.php#780

Bindings	0: 43 1: 2: %cutoff% 3: Alumni 4: 5: 6: 0 7: 8: 0
Backtrace	17. app/Http/Controllers/CollegeController.php:780 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

770μsdb_collegesearchCollegeController.php#807

Bindings	0: 93
Backtrace	19. app/Http/Controllers/CollegeController.php:807 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 * from `institute_courses` where `institute_courses`.`institute_id` in (11765) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2

3.03msdb_collegesearchCollegeController.php#807

Bindings	0: active 1: yes
Backtrace	19. app/Http/Controllers/CollegeController.php:807 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 * from `course_type` where `course_type`.`id` in (4, 23)

820μsdb_collegesearchCollegeController.php#807

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

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

2.23msdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 11765
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:822 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 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` = 11765

5.06msdb_collegesearchCollegeController.php#837

Bindings	0: 11765
Backtrace	15. app/Http/Controllers/CollegeController.php:837 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 `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institutes` as `laravel_reserved_2` where `institutes`.`old_univ_id` = `laravel_reserved_2`.`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 `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_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 `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count` from `institutes` where `id` = 11765 and `status` = 'Active' limit 1

133msdb_collegesearchCollegeController.php#970

Bindings	0: 1: 0 2: 3: 0 4: 43 5: 6: Alumni 7: 8: 11765 9: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:970 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 `images` where `images`.`institute_id` in (11765) 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

3.02msdb_collegesearchCollegeController.php#970

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (11765) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

4.52msdb_collegesearchCollegeController.php#970

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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, 23, 24, 53)

1.18msdb_collegesearchCollegeController.php#970

Bindings	0: 4 1: 23 2: 24 3: 53
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 (11765) order by `ID` desc limit 1

1.03msdb_collegesearchCollegeController.php#970

Backtrace

20. app/Http/Controllers/CollegeController.php:970
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 (11765) and `status` = 'active' order by `course_type` asc

11.78msdb_collegesearchCollegeController.php#970

Bindings	0: active
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (1, 2, 4, 7, 8, 10, 13, 17, 73, 79, 233, 235, 236, 237, 238, 251, 306, 307, 356, 357, 441)

1.01msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 4 3: 7 4: 8 5: 10 6: 13 7: 17 8: 73 9: 79 10: 233 11: 235 12: 236 13: 237 14: 238 15: 251 16: 306 17: 307 18: 356 19: 357 20: 441
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 (1, 2, 4, 7, 8, 10, 13, 17, 19, 21, 22, 23, 24, 25, 52, 53)

1.01msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 4 3: 7 4: 8 5: 10 6: 13 7: 17 8: 19 9: 21 10: 22 11: 23 12: 24 13: 25 14: 52 15: 53
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_fees` where `course_fees`.`institute_course_id` in (34663, 34664, 34665, 34668, 34669, 34670, 34672, 34673, 34674, 34675, 34676, 34677, 34678, 34680, 34681, 34682, 34683, 34684, 34685, 34686, 34687) and `fees_name` = 'Total All Fees'

29.64msdb_collegesearchCollegeController.php#970

Bindings	0: Total All Fees
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_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 (34663, 34664, 34665, 34668, 34669, 34670, 34672, 34673, 34674, 34675, 34676, 34677, 34678, 34680, 34681, 34682, 34683, 34684, 34685, 34686, 34687) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

1.03msdb_collegesearchCollegeController.php#970

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_course_id`, `highest_package`, `lowest_package`, `average_package`, `year` from `placement` where `placement`.`institute_course_id` in (34663, 34664, 34665, 34668, 34669, 34670, 34672, 34673, 34674, 34675, 34676, 34677, 34678, 34680, 34681, 34682, 34683, 34684, 34685, 34686, 34687) and `average_package` != '' and `highest_package` != '' order by `year` desc limit 1

5.05msdb_collegesearchCollegeController.php#970

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 `seats` where `seats`.`institute_course_id` in (34663, 34664, 34665, 34668, 34669, 34670, 34672, 34673, 34674, 34675, 34676, 34677, 34678, 34680, 34681, 34682, 34683, 34684, 34685, 34686, 34687)

1.45msdb_collegesearchCollegeController.php#970

Backtrace

25. app/Http/Controllers/CollegeController.php:970
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 `courses` where `courses`.`id` in (1, 2, 3, 4, 5, 6, 10, 11, 41, 48, 57, 78, 121, 159, 160, 162, 164, 168, 171, 173, 332, 379, 380, 381, 403, 405, 410, 411, 412, 418, 420, 429, 430, 443, 451, 452, 462, 466, 482, 493, 559, 614, 616, 617, 618, 621, 837, 1018, 1616) order by `sequence` asc

1.82msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 3 3: 4 4: 5 5: 6 6: 10 7: 11 8: 41 9: 48 10: 57 11: 78 12: 121 13: 159 14: 160 15: 162 16: 164 17: 168 18: 171 19: 173 20: 332 21: 379 22: 380 23: 381 24: 403 25: 405 26: 410 27: 411 28: 412 29: 418 30: 420 31: 429 32: 430 33: 443 34: 451 35: 452 36: 462 37: 466 38: 482 39: 493 40: 559 41: 614 42: 616 43: 617 44: 618 45: 621 46: 837 47: 1018 48: 1616
Backtrace	30. app/Http/Controllers/CollegeController.php:970 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 `id`, `course_type`, `course_name`, `student_name`, `college_desc`, `added_date`, `year_of_study`, `overall_rating` from `user_reviews` where `user_reviews`.`course_type` in (1, 2, 4, 7, 8, 10, 13, 17, 19, 21, 22, 23, 24, 25, 52, 53) and `institute_id` = 11765 and `college_desc` != '' and length(college_desc) > 10 and `status` = 'Active' order by `overall_rating` asc, length(college_desc) desc

1.85msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 4 3: 7 4: 8 5: 10 6: 13 7: 17 8: 19 9: 21 10: 22 11: 23 12: 24 13: 25 14: 52 15: 53 16: 11765 17: 18: 10 19: Active
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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`, `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 (11765) and `status` = 'Active' and `college_desc` != '' order by `sequence` asc, length(college_desc) desc limit 10

730μsdb_collegesearchCollegeController.php#970

Bindings	0: Active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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_faqs` where `institute_faqs`.`institute_id` in (11765) and `section` LIKE '%courses%'

2.37msdb_collegesearchCollegeController.php#970

Bindings	0: %courses%
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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`, `name`, `description`, `type`, `webp_image`, `logo`, `twitter_link` from `collaboration` where `collaboration`.`institute_id` in (11765) and `type` in ('Award', 'Alumni') and `description` != '' order by `seq` asc, `id` asc limit 20

900μsdb_collegesearchCollegeController.php#970

Bindings	0: Award 1: Alumni 2:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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` = 11765 and `institute_courses`.`institute_id` is not null limit 1

1.88msdb_collegesearchCollegeController.php#995

Bindings	0: 11765
Backtrace	21. app/Http/Controllers/CollegeController.php:995 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`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

1.28msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:995
23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

750μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:995
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

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 (930,1600,3504,11,1615,2752,139,911,5198,3739,112,12,121,5760,3298,3409,6079,1338,5836,4471,2267,1289,6152,3226)

3.7msdb_collegesearchCollegeController.php#996

Backtrace

10. app/Http/Controllers/CollegeController.php:996
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 * from `states` where `states`.`StateID` = 93 and `states`.`StateID` is not null limit 1

710μsdb_collegesearchCollegeController.php#1004

Bindings	0: 93
Backtrace	20. app/Http/Controllers/CollegeController.php:1004 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_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` = 11765 group by `course_type`.`id`

13.9msdb_collegesearchCollegeController.php#1018

Bindings	0: 11765
Backtrace	14. app/Http/Controllers/CollegeController.php:1018 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` = 11765

1.51msdb_collegesearchCollegeController.php#1046

Bindings	0: 11765
Backtrace	14. app/Http/Controllers/CollegeController.php:1046 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` = 11765 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

960μsdb_collegesearchCollegeController.php#1071

Bindings	0: Active 1: 11765 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1071 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` = 11765 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

1.55msdb_collegesearchCollegeController.php#1089

Bindings	0: Active 1: 11765 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1089 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` = 11765 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

990μsdb_collegesearchCollegeController.php#1107

Bindings	0: Active 1: 11765 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1107 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` = 11765 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

820μsdb_collegesearchCollegeController.php#1111

Bindings	0: 11765 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:1111 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` = 11765 and date(`start_date`) <= '2025-04-08' and date(`end_date`) >= '2025-04-08'

2.84msdb_collegesearchCollegeController.php#2682

Bindings	0: 11765 1: 2025-04-08 2: 2025-04-08
Backtrace	14. app/Http/Controllers/CollegeController.php:2682 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 `metatags` where `PageID` = 'colleges/jaya-group-of-institutions-chennai/courses-fees' and `status` = 'Y' limit 1

1.05msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/jaya-group-of-institutions-chennai/courses-fees 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:2693 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` = 11765 and `images`.`deleted_at` is null limit 1

880μsdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 11765
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:2705 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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

1.33msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

640μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (184)

720μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (184)

720μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (90)

880μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (90)

1.11msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (132)

1.12msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (132)

1.54msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (132)

1.24msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (132)

680μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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

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-inner-courses-fees%' and `module_link_id` = 11765 and `expiry_date` > '2025-04-08 12:23:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.11msdb_collegesearchhelpers.php#1695

Bindings	0: 11765 1: 2025-04-08 12:23:49
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 ('13', '184', '90', '132') and `expiry_date` > '2025-04-08 12:23:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.77msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 13 2: 184 3: 90 4: 132 5: 2025-04-08 12:23:49
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 ('1', '1', '2', '4', '7', '8', '10', '10', '13', '17', '19', '21', '22', '23', '23', '23', '24', '25', '25', '52', '53') and `expiry_date` > '2025-04-08 12:23:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.04msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 1 3: 2 4: 4 5: 7 6: 8 7: 10 8: 10 9: 13 10: 17 11: 19 12: 21 13: 22 14: 23 15: 23 16: 23 17: 24 18: 25 19: 25 20: 52 21: 53 22: 2025-04-08 12:23:49
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 `ranks` where `ranks`.`institute_id` = 11765 and `ranks`.`institute_id` is not null

8.38msdb_collegesearchCollegeController.php#2835

Bindings	0: 11765
Backtrace	19. app/Http/Controllers/CollegeController.php:2835 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` = 1 limit 1

1.33msdb_collegesearchBreadcrumb.php#167

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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

1.12msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:2877
23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (13)

770μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2877
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

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

1.26msdb_collegesearchhero_section.blade.php#27

Bindings	0: 11765
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` = 11765 and `user_reviews`.`institute_id` is not null

1.54msdb_collegesearchnavbar.blade.php#31

Bindings	0: 11765
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 `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp-inner-courses-fees' and `brandings`.`deleted_at` is null

1.36msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-courses-fees
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: 65InstituteCourse.php#?
App\Models\Seat: 49Seat.php#?
App\Models\Course: 48Course.php#?
App\Models\CourseType: 23CourseType.php#?
App\Models\SubCourse: 21SubCourse.php#?
App\Models\Criteria: 14Criteria.php#?
App\Models\Image: 5Image.php#?
App\Models\Institute: 3Institute.php#?
App\Models\State: 2State.php#?
App\Models\UserReview: 1UserReview.php#?

_token: yYy3DUSYZNuDitjPgM4xnY3O83dRZ61rYYJEj5eA
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/jaya-group-of-institutions-chennai/c...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/jaya-group-of-institutions-chennai/courses-fees

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 => "Tue, 08 Apr 2025 06:53:49 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZ5NzB3QUdFcklxa3QzcWx2N2g2R0E9PSIsInZhbHVlIjoiblRsNGVRU2g3bS9XRUUrUm5VczVJVHhLQkVBTXhwY2JxYk1IUjdZWThFYnhHczFjNCsvdzd6ekNsck9uSTYranRkTFg3NXFCRGpYcTZmaXJxbnlNdGRITFFJcUpMTnBHRDY3Tm1kZFVoU0hLQ3FSTGJNaForS0xrMmVyUVRlMkYiLCJtYWMiOiJmZDNmODM0NGVjNTUyODk3NzkyZmNhMzUwNDgyZmVkYTNhOTQ5YjM5ZjliYjVkZjA4MjZjMmZhOGMzYjA4MThlIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 08:53:49 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjZ5NzB3QUdFcklxa3QzcWx2N2g2R0E9PSIsInZhbHVlIjoiblRsNGVRU2g3bS9XRUUrUm5VczVJVHhLQkVBTXhwY2JxYk1IUjdZWThFYnhHczFjNCsvdzd6ekNsck9uSTYranRkTFg3N ▶"
    1 => "cs_dev_session=eyJpdiI6Ik1hdWVuVUJNZFFPeXE5eXdGUGd2NGc9PSIsInZhbHVlIjoiZUVBY3NtQ0ViV3lFczg5OVhjSGtWYjhNRHFKZkFubllYYWtUYVVnQVE0a2x1NUp1YVlNaXE5WTBOOVJFT3doVTN4VG9vb2dPTG8vMlo5VXNmTGE2ai9POFdPdHF6OGJubVdqRkdYWXhlQTRMeDJxMTNoc0d4N3lZQXBnRHdMK3UiLCJtYWMiOiJiNWViODc0NGY0ZTdmMmQ3ZDk4Y2MxYmI2YWI0YjgxMzlhYjNmM2ZmMjNiZDk1MTA3NmI0YjdmMGFkNDFiMDYxIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 08:53:49 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6Ik1hdWVuVUJNZFFPeXE5eXdGUGd2NGc9PSIsInZhbHVlIjoiZUVBY3NtQ0ViV3lFczg5OVhjSGtWYjhNRHFKZkFubllYYWtUYVVnQVE0a2x1NUp1YVlNaXE5WTBOOVJFT3doVTN4V ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZ5NzB3QUdFcklxa3QzcWx2N2g2R0E9PSIsInZhbHVlIjoiblRsNGVRU2g3bS9XRUUrUm5VczVJVHhLQkVBTXhwY2JxYk1IUjdZWThFYnhHczFjNCsvdzd6ekNsck9uSTYranRkTFg3NXFCRGpYcTZmaXJxbnlNdGRITFFJcUpMTnBHRDY3Tm1kZFVoU0hLQ3FSTGJNaForS0xrMmVyUVRlMkYiLCJtYWMiOiJmZDNmODM0NGVjNTUyODk3NzkyZmNhMzUwNDgyZmVkYTNhOTQ5YjM5ZjliYjVkZjA4MjZjMmZhOGMzYjA4MThlIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 08:53:49 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjZ5NzB3QUdFcklxa3QzcWx2N2g2R0E9PSIsInZhbHVlIjoiblRsNGVRU2g3bS9XRUUrUm5VczVJVHhLQkVBTXhwY2JxYk1IUjdZWThFYnhHczFjNCsvdzd6ekNsck9uSTYranRkTFg3N ▶"
    1 => "cs_dev_session=eyJpdiI6Ik1hdWVuVUJNZFFPeXE5eXdGUGd2NGc9PSIsInZhbHVlIjoiZUVBY3NtQ0ViV3lFczg5OVhjSGtWYjhNRHFKZkFubllYYWtUYVVnQVE0a2x1NUp1YVlNaXE5WTBOOVJFT3doVTN4VG9vb2dPTG8vMlo5VXNmTGE2ai9POFdPdHF6OGJubVdqRkdYWXhlQTRMeDJxMTNoc0d4N3lZQXBnRHdMK3UiLCJtYWMiOiJiNWViODc0NGY0ZTdmMmQ3ZDk4Y2MxYmI2YWI0YjgxMzlhYjNmM2ZmMjNiZDk1MTA3NmI0YjdmMGFkNDFiMDYxIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 08:53:49 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6Ik1hdWVuVUJNZFFPeXE5eXdGUGd2NGc9PSIsInZhbHVlIjoiZUVBY3NtQ0ViV3lFczg5OVhjSGtWYjhNRHFKZkFubllYYWtUYVVnQVE0a2x1NUp1YVlNaXE5WTBOOVJFT3doVTN4V ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "yYy3DUSYZNuDitjPgM4xnY3O83dRZ61rYYJEj5eA"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/jaya-group-of-institutions-chennai/courses-fees"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 12:23:49	GET	/colleges/jaya-group-of-institutions-chennai/courses-fees	1 14 62 231

Course	Total Fees
Bachelor of Technology (B.Tech) 4 Years \| Fulltime \| On Campus	₹ 2,00,000 Fees Details
Bachelor of Engineering 4 Years \| Fulltime \| On Campus	-
Master of Business Administration(MBA) 2 Years \| Fulltime \| On Campus	-
Bachelor of Medicine, Bachelor of Surgery (MBBS) 5 Years \| Fulltime \| On Campus	-
Bachelor of Business Administration (BBA) 3 Years \| Fulltime \| On Campus	-
Master of Computer Application 3 Years \| Fulltime \| On Campus	-
Master of Engineering 2 Years \| Fulltime \| On Campus	-
Master of Technology (M.Tech) 2 Years \| Fulltime \| On Campus	-
Bachelor of Computer Application (BCA) 3 Years \| Fulltime \| On Campus	-
Doctor of Medicine (MD) 3 Years \| Fulltime \| On Campus	-
Bachelor of Arts (BA) 3 Years \| Fulltime \| On Campus	-
Bachelor of Commerce(B.Com.) 3 Years \| Fulltime \| On Campus	-
Master of Commerce 2 Years \| Fulltime \| On Campus	-
B.Sc Nursing 4 Years \| Fulltime \| On Campus	-
Bachelor of Science (B.Sc) 3 Years \| Fulltime \| On Campus	-
B.Sc. Post Basic Nursing 2 Years \| Fulltime \| On Campus	-
B.Ed 1 Years \| Fulltime \| On Campus	-
M.Sc Nursing 2 Years \| Fulltime \| On Campus	-
Master of Science(M.Sc.) 2 Years \| Fulltime \| On Campus	-
Bachelor of Dental Surgery 5 Years \| Fulltime \| On Campus	-
Master of Dental Surgery 3 Years \| Fulltime \| On Campus	-

Jaya Group of Institutions, Chennai Course and Fees

Jaya Group of Institutions, Chennai Courses and Fees

Jaya Group of Institutions , Chennai Courses

Recommended Colleges

Jaya Group of Institutions, Chennai Top Recruiters

Student's Rating for Jaya Group of Institutions , Chennai

Contact Details

1 x Application (98.95%)	977ms
1 x Booting (1.05%)	10.34ms