Messages1 Timeline Exceptions Views14 Route Queries53 Models220 Mails Gate Session Request

Request history8.3.19624ms6MBGET university/{slug}/{tab}

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

Booting (10.01ms)time
Application (614ms)time
1 x Application (98.39%)
614ms
1 x Booting (1.6%)
10.01ms

14 templates were rendered

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

53 statements were executed, 10 of which were duplicates, 43 unique. Show only duplicated521ms

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` = '/university/apeejay-stya-university-gurgaon/msc-clinical-research' and `status` = 1 limit 1

9.98msdb_collegesearchCacheService.php#460

Bindings	0: /university/apeejay-stya-university-gurgaon/msc-clinical-research 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` = 'apeejay-stya-university-gurgaon' and `status` = 'Active' limit 1

1.04msdb_collegesearchCacheService.php#492

Bindings	0: apeejay-stya-university-gurgaon 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` = 'apeejay-stya-university-gurgaon') limit 1

1.86msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: apeejay-stya-university-gurgaon
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 `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 (7632)

224msdb_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 (75)

1.07msdb_collegesearchCollegeController.php#807

Bindings	0: 75
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 (7632) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2

3.47msdb_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 (9)

3.07msdb_collegesearchCollegeController.php#807

Bindings	0: 9
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` = 7632 and `images`.`deleted_at` is null limit 1

800μsdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 7632
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` = 7632

4.35msdb_collegesearchCollegeController.php#837

Bindings	0: 7632
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 `id`, (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` from `institutes` where `institutes`.`id` in (7632)

90.68msdb_collegesearchCollegeController.php#1128

Bindings	0: 1: 0 2: 3: 0
Backtrace	17. app/Http/Controllers/CollegeController.php:1128 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 `institute_courses` where `institute_courses`.`institute_id` in (7632) and `status` = 'active' and `sub_course_id` = 1745 order by `course_type` asc

20.24msdb_collegesearchCollegeController.php#1139

Bindings	0: active 1: 1745
Backtrace	19. app/Http/Controllers/CollegeController.php:1139 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 `sub_course` where `sub_course`.`id` in (1745)

4.89msdb_collegesearchCollegeController.php#1139

Bindings	0: 1745
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `course_type` where `course_type`.`id` in (25)

1.33msdb_collegesearchCollegeController.php#1139

Bindings	0: 25
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `quota` where `quota`.`institute_course_id` in (39340) order by `reservation_id` asc

2.42msdb_collegesearchCollegeController.php#1139

Backtrace

24. app/Http/Controllers/CollegeController.php:1139
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 * from `course_fees` where `course_fees`.`institute_course_id` in (39340)

49.16msdb_collegesearchCollegeController.php#1139

Backtrace

24. app/Http/Controllers/CollegeController.php:1139
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 * from `fees_type` where `fees_type`.`id` in (2, 11, 13, 14)

1.14msdb_collegesearchCollegeController.php#1139

Bindings	0: 2 1: 11 2: 13 3: 14
Backtrace	29. app/Http/Controllers/CollegeController.php:1139 30. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 31. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 32. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `branch_fees` where `branch_fees`.`institute_course_id` in (39340) order by `id` asc

6.48msdb_collegesearchCollegeController.php#1139

Backtrace

24. app/Http/Controllers/CollegeController.php:1139
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 `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 (39340) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc limit 1

830μsdb_collegesearchCollegeController.php#1139

Bindings	0: 1:
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 `institute_course_id`, `highest_package`, `lowest_package`, `average_package`, `year` from `placement` where `placement`.`institute_course_id` in (39340) and `average_package` != '' and `highest_package` != '' order by `year` desc limit 1

5.91msdb_collegesearchCollegeController.php#1139

Bindings	0: 1:
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `seats` where `seats`.`institute_course_id` in (39340)

1.16msdb_collegesearchCollegeController.php#1139

Backtrace

24. app/Http/Controllers/CollegeController.php:1139
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 * from `courses` where `courses`.`id` in (569) order by `sequence` asc

1.49msdb_collegesearchCollegeController.php#1139

Bindings	0: 569
Backtrace	29. app/Http/Controllers/CollegeController.php:1139 30. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 31. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 32. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 33. 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 (25) and `institute_id` = 7632 and `college_desc` != '' and length(college_desc) > 10 and `status` = 'Active' order by `overall_rating` asc, length(college_desc) desc

1.11msdb_collegesearchCollegeController.php#1139

Bindings	0: 25 1: 7632 2: 3: 10 4: Active
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `institute_courses` where `institute_courses`.`institute_id` in (7632) and `status` = 'active' and `course_type` != 1745

17.3msdb_collegesearchCollegeController.php#1139

Bindings	0: active 1: 1745
Backtrace	19. app/Http/Controllers/CollegeController.php:1139 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 (1, 2, 7, 9, 10, 11, 14, 21, 23, 24, 25, 33, 43, 80, 81, 89)

1.17msdb_collegesearchCollegeController.php#1139

Bindings	0: 1 1: 2 2: 7 3: 9 4: 10 5: 11 6: 14 7: 21 8: 23 9: 24 10: 25 11: 33 12: 43 13: 80 14: 81 15: 89
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `sub_course` where `sub_course`.`id` in (1, 2, 11, 202, 238, 245, 295, 299, 301, 429, 1264, 1576, 1726, 1727, 1728, 1729, 1734, 1744, 1745, 1748, 1749, 1790, 1809, 2322, 3073, 3118, 3120, 3273, 3280)

1.28msdb_collegesearchCollegeController.php#1139

Bindings	0: 1 1: 2 2: 11 3: 202 4: 238 5: 245 6: 295 7: 299 8: 301 9: 429 10: 1264 11: 1576 12: 1726 13: 1727 14: 1728 15: 1729 16: 1734 17: 1744 18: 1745 19: 1748 20: 1749 21: 1790 22: 1809 23: 2322 24: 3073 25: 3118 26: 3120 27: 3273 28: 3280
Backtrace	24. app/Http/Controllers/CollegeController.php:1139 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 * from `images` where `images`.`institute_id` in (7632) 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

870μsdb_collegesearchCollegeController.php#1139

Bindings	0: 0
Backtrace	19. app/Http/Controllers/CollegeController.php:1139 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` = 7632 and `institute_courses`.`institute_id` is not null limit 1

990μsdb_collegesearchCollegeController.php#1225

Bindings	0: 7632
Backtrace	21. app/Http/Controllers/CollegeController.php:1225 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 (40,161)

970μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:1225
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 (40,161)

900μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:1225
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 `inst_campaign_bharat_2022` where `institute_id` = 7632 and date(`start_date`) <= '2025-04-07' and date(`end_date`) >= '2025-04-07'

2.12msdb_collegesearchCollegeController.php#1229

Bindings	0: 7632 1: 2025-04-07 2: 2025-04-07
Backtrace	14. app/Http/Controllers/CollegeController.php:1229 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 (3161,61,2018,3598,3102,2109,2768,119,1119,3666,1088,722,5198,112,1919,1142,2172,3504,2166,2455,1117,6033,5038,2548,4463,6222,42,1115,1629,3857,38,6255,1086,6194,3554,6500,6483,3263)

9.43msdb_collegesearchCollegeController.php#1238

Backtrace

10. app/Http/Controllers/CollegeController.php:1238
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 `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` = 7632 group by `course_type`.`id`

16.78msdb_collegesearchCollegeController.php#1260

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

3.07msdb_collegesearchCollegeController.php#1288

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

1.16msdb_collegesearchCollegeController.php#1313

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

1.08msdb_collegesearchCollegeController.php#1331

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

2.25msdb_collegesearchCollegeController.php#1349

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

930μsdb_collegesearchCollegeController.php#1353

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

2.41msdb_collegesearchCollegeController.php#2682

Bindings	0: 7632 1: 2025-04-07 2: 2025-04-07
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` = 'university/apeejay-stya-university-gurgaon/courses-fee-specific' and `status` = 'Y' limit 1

1.32msdb_collegesearchCollegeController.php#2693

Bindings	0: university/apeejay-stya-university-gurgaon/courses-fee-specific 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` = 7632 and `images`.`deleted_at` is null limit 1

640μsdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 7632
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 `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-fee-specific%' and `module_link_id` = 7632 and `expiry_date` > '2025-04-07 17:44:21' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

2.67msdb_collegesearchhelpers.php#1695

Bindings	0: 7632 1: 2025-04-07 17:44:21
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-07 17:44:21' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.47msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 2: 2025-04-07 17:44:21
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 ('25') and `expiry_date` > '2025-04-07 17:44:21' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.44msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 25 2: 2025-04-07 17:44:21
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 `admin_reporting` where `admin_reporting`.`institute_id` = 7632 and `admin_reporting`.`institute_id` is not null

1.16msdb_collegesearchCollegeController.php#2749

Bindings	0: 7632
Backtrace	20. app/Http/Controllers/CollegeController.php:2749 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` = 7632 and `institute_faqs`.`institute_id` is not null

1.35msdb_collegesearchCollegeController.php#2802

Bindings	0: 7632
Backtrace	20. app/Http/Controllers/CollegeController.php:2802 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 `ranks` where `ranks`.`institute_id` = 7632 and `ranks`.`institute_id` is not null

990μsdb_collegesearchCollegeController.php#2835

Bindings	0: 7632
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` = 25 limit 1

1.35msdb_collegesearchBreadcrumb.php#167

Bindings	0: 25
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 * from `collaboration` where `collaboration`.`institute_id` = 7632 and `collaboration`.`institute_id` is not null

1.78msdb_collegesearchCollegeController.php#2867

Bindings	0: 7632
Backtrace	19. app/Http/Controllers/CollegeController.php:2867 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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (40,161)

1.21msdb_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 (40,161)

1.5msdb_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` = 7632 and `user_reviews`.`institute_id` is not null

2msdb_collegesearchhero_section.blade.php#27

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

1.55msdb_collegesearchnavbar.blade.php#31

Bindings	0: 7632
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-fee-specific' and `brandings`.`deleted_at` is null

1.07msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-courses-fee-specific
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: 49InstituteCourse.php#?
App\Models\UserReview: 45UserReview.php#?
App\Models\Collaboration: 35Collaboration.php#?
App\Models\SubCourse: 30SubCourse.php#?
App\Models\Image: 20Image.php#?
App\Models\CourseType: 19CourseType.php#?
App\Models\Criteria: 8Criteria.php#?
App\Models\CourseFees: 4CourseFees.php#?
App\Models\FeesType: 4FeesType.php#?
App\Models\Institute: 3Institute.php#?
App\Models\State: 1State.php#?
App\Models\Seat: 1Seat.php#?
App\Models\Course: 1Course.php#?

_token: ORnV8VQhHwuu1CfWPINJ79vT7OKiiwE1aJtMjh2s
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/university/apeejay-stya-university-gurgaon/ms...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/university/apeejay-stya-university-gurgaon/msc-clinical-research

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 => "Mon, 07 Apr 2025 12:14:21 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik5sL0Y5LzVIUmdjN3lOUGtUTzN2eHc9PSIsInZhbHVlIjoiYUdVMW1nMzVwOTlmZkxlamtTa0V2by90WVd3NEF0aS9uV0JDdHVKcjllOCtoeTFvNDY2M0hUQVZKMTZUZHNjUTE2Wi9NWmNWWklKVW5Ya0U1UTA2SjNjK1dTY3M4Mi9GUkZRVDJiUXBtTnRtRDZlcWt2NmNpTmNBNS9vdDVsRXQiLCJtYWMiOiJjZDIzNzE1ZGVlODhjM2FlZDJlNGZkMmU2OTU0MzM1NGJmYTc2ZGUwMjdlMDQ3YTI3MmQ2ZGZkOTBlNWMwNWU0IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 14:14:21 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik5sL0Y5LzVIUmdjN3lOUGtUTzN2eHc9PSIsInZhbHVlIjoiYUdVMW1nMzVwOTlmZkxlamtTa0V2by90WVd3NEF0aS9uV0JDdHVKcjllOCtoeTFvNDY2M0hUQVZKMTZUZHNjUTE2Wi9NW ▶"
    1 => "cs_dev_session=eyJpdiI6IjVJOE5TemxIY25YRHVFbWQvLy9NVFE9PSIsInZhbHVlIjoiVjNSamVXcThhNkxkYWxZREhZYWNoaXMvd2svRTllcGVIbWQyYzJYYzh1aC9UaVQrNmc4YTVHSUJxN1FkeFdHZ1pkVFRVK3dDWGNSRm5QN3p6WlpDOGVuRy92a0x0T043OHJGZWNWamNkU3ZqcmJNeXNZUnpqaGY4dkkxTmtUME0iLCJtYWMiOiIyYjg3ZDM4OGQyN2E3YjZkYTEyNWI2YWNlNGU5MjQwOWVmMDlkMTYzZWZlZjZmODIzY2ZjNTI2ZDM0YzY4M2QwIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 14:14:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IjVJOE5TemxIY25YRHVFbWQvLy9NVFE9PSIsInZhbHVlIjoiVjNSamVXcThhNkxkYWxZREhZYWNoaXMvd2svRTllcGVIbWQyYzJYYzh1aC9UaVQrNmc4YTVHSUJxN1FkeFdHZ1pkV ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik5sL0Y5LzVIUmdjN3lOUGtUTzN2eHc9PSIsInZhbHVlIjoiYUdVMW1nMzVwOTlmZkxlamtTa0V2by90WVd3NEF0aS9uV0JDdHVKcjllOCtoeTFvNDY2M0hUQVZKMTZUZHNjUTE2Wi9NWmNWWklKVW5Ya0U1UTA2SjNjK1dTY3M4Mi9GUkZRVDJiUXBtTnRtRDZlcWt2NmNpTmNBNS9vdDVsRXQiLCJtYWMiOiJjZDIzNzE1ZGVlODhjM2FlZDJlNGZkMmU2OTU0MzM1NGJmYTc2ZGUwMjdlMDQ3YTI3MmQ2ZGZkOTBlNWMwNWU0IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 14:14:21 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5sL0Y5LzVIUmdjN3lOUGtUTzN2eHc9PSIsInZhbHVlIjoiYUdVMW1nMzVwOTlmZkxlamtTa0V2by90WVd3NEF0aS9uV0JDdHVKcjllOCtoeTFvNDY2M0hUQVZKMTZUZHNjUTE2Wi9NW ▶"
    1 => "cs_dev_session=eyJpdiI6IjVJOE5TemxIY25YRHVFbWQvLy9NVFE9PSIsInZhbHVlIjoiVjNSamVXcThhNkxkYWxZREhZYWNoaXMvd2svRTllcGVIbWQyYzJYYzh1aC9UaVQrNmc4YTVHSUJxN1FkeFdHZ1pkVFRVK3dDWGNSRm5QN3p6WlpDOGVuRy92a0x0T043OHJGZWNWamNkU3ZqcmJNeXNZUnpqaGY4dkkxTmtUME0iLCJtYWMiOiIyYjg3ZDM4OGQyN2E3YjZkYTEyNWI2YWNlNGU5MjQwOWVmMDlkMTYzZWZlZjZmODIzY2ZjNTI2ZDM0YzY4M2QwIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 14:14:21 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IjVJOE5TemxIY25YRHVFbWQvLy9NVFE9PSIsInZhbHVlIjoiVjNSamVXcThhNkxkYWxZREhZYWNoaXMvd2svRTllcGVIbWQyYzJYYzh1aC9UaVQrNmc4YTVHSUJxN1FkeFdHZ1pkV ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "ORnV8VQhHwuu1CfWPINJ79vT7OKiiwE1aJtMjh2s"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/university/apeejay-stya-university-gurgaon/msc-clinical-research"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 17:44:21	GET	/university/apeejay-stya-university-gurgaon/msc-clinical-research	1 14 53 220

Fees	Year 1	Year 2
Tuition Fees	1,70,000	1,70,000
Other	30,200	22,200
Total All Fees	2,00,200	1,92,200
Grand Total	3,92,400

Tuition Fee After Scholarship	For Students
Less than or equal to 60%	1,70,000
Greater than 60%	1,50,000
Additional Charges	30,200
Development Fee	INR 20,000 per annum
Security Fee	INR 5,000 One Time Payable (Refundable)
CRC	INR 3,000 One Time Payable with the 1^st Semester Fees
Online Library	INR 2,000 per annum
Group Insurance Accident policy	INR 200 per annum

M.Sc Clinical Research at Apeejay Stya University, Gurgaon

M.Sc Clinical Research Fees Details

Detailed Fees Breakup

M.Sc Clinical Research Branch Fees Details

Apeejay Stya University, Gurgaon Admission Details

Apeejay Stya University, Gurgaon Top Recruiters

Student's Rating for Apeejay Stya University , Gurgaon

Contact Details

1 x Application (98.39%)	614ms
1 x Booting (1.6%)	10.01ms