Messages1 Timeline Exceptions Views14 Route Queries50 Models193 Mails Gate Session Request

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

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

Booting (13.91ms)time
Application (722ms)time
1 x Application (98.11%)
722ms
1 x Booting (1.89%)
13.91ms

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 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

50 statements were executed, 8 of which were duplicates, 42 unique. Show only duplicated544ms

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/asian-academy-of-film-and-television-aaft/diploma-3d-animation-vfx' and `status` = 1 limit 1

10.95msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/asian-academy-of-film-and-television-aaft/diploma-3d-animation-vfx 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` = 'asian-academy-of-film-and-television-aaft' and `status` = 'Active' limit 1

1.25msdb_collegesearchCacheService.php#492

Bindings	0: asian-academy-of-film-and-television-aaft 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` = 'asian-academy-of-film-and-television-aaft') limit 1

2.88msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: asian-academy-of-film-and-television-aaft
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` = 'diploma-3d-animation-vfx' limit 1

3.55msdb_collegesearchCollegeController.php#746

Bindings	0: diploma-3d-animation-vfx
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 `course_type` where `course_type`.`id` in (23)

950μsdb_collegesearchCollegeController.php#746

Bindings	0: 23
Backtrace	20. app/Http/Controllers/CollegeController.php:746 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 (13737)

213msdb_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 (72)

1.23msdb_collegesearchCollegeController.php#807

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

11.2msdb_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 (12)

2.4msdb_collegesearchCollegeController.php#807

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

1.54msdb_collegesearchInstitute.php#210

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

4.06msdb_collegesearchCollegeController.php#837

Bindings	0: 13737
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 (13737)

81.88msdb_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 (13737) and `status` = 'active' and `sub_course_id` = 3419 order by `course_type` asc

83.11msdb_collegesearchCollegeController.php#1139

Bindings	0: active 1: 3419
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 (3419)

1msdb_collegesearchCollegeController.php#1139

Bindings	0: 3419
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 (23)

1.22msdb_collegesearchCollegeController.php#1139

Bindings	0: 23
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 (48982) order by `reservation_id` asc

2.72msdb_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 (48982)

27.38msdb_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 (13)

1.87msdb_collegesearchCollegeController.php#1139

Bindings	0: 13
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 (48982) order by `id` asc

7.18msdb_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 (48982) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc limit 1

2.31msdb_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 (48982) and `average_package` != '' and `highest_package` != '' order by `year` desc limit 1

4.22msdb_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 (48982)

740μsdb_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 `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 (23) and `institute_id` = 13737 and `college_desc` != '' and length(college_desc) > 10 and `status` = 'Active' order by `overall_rating` asc, length(college_desc) desc

1.01msdb_collegesearchCollegeController.php#1139

Bindings	0: 23 1: 13737 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 (13737) and `status` = 'active' and `course_type` != 3419

19.1msdb_collegesearchCollegeController.php#1139

Bindings	0: active 1: 3419
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 (12, 19, 20, 23, 25, 29, 30, 33, 48, 50, 51, 80, 81, 89, 123)

1.32msdb_collegesearchCollegeController.php#1139

Bindings	0: 12 1: 19 2: 20 3: 23 4: 25 5: 29 6: 30 7: 33 8: 48 9: 50 10: 51 11: 80 12: 81 13: 89 14: 123
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 (12, 278, 316, 487, 707, 962, 963, 1012, 1028, 1036, 1702, 1771, 1954, 2209, 2250, 2271, 2406, 2592, 3092, 3357, 3378, 3379, 3380, 3381, 3382, 3383, 3384, 3385, 3386, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3417, 3418, 3419, 3420, 3422)

1.64msdb_collegesearchCollegeController.php#1139

Bindings

0: 12
1: 278
2: 316
3: 487
4: 707
5: 962
6: 963
7: 1012
8: 1028
9: 1036
10: 1702
11: 1771
12: 1954
13: 2209
14: 2250
15: 2271
16: 2406
17: 2592
18: 3092
19: 3357
20: 3378
21: 3379
22: 3380
23: 3381
24: 3382
25: 3383
26: 3384
27: 3385
28: 3386
29: 3387
30: 3388
31: 3389
32: 3390
33: 3391
34: 3392
35: 3393
36: 3394
37: 3395
38: 3398
39: 3399
40: 3400
41: 3401
42: 3402
43: 3403
44: 3404
45: 3405
46: 3406
47: 3407
48: 3408
49: 3409
50: 3410
51: 3411
52: 3412
53: 3413
54: 3414
55: 3415
56: 3416
57: 3417
58: 3418
59: 3419
60: 3420
61: 3422

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 (13737) 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

880μ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` = 13737 and `institute_courses`.`institute_id` is not null limit 1

1.03msdb_collegesearchCollegeController.php#1225

Bindings	0: 13737
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 * from `inst_campaign_bharat_2022` where `institute_id` = 13737 and date(`start_date`) <= '2025-04-08' and date(`end_date`) >= '2025-04-08'

2.2msdb_collegesearchCollegeController.php#1229

Bindings	0: 13737 1: 2025-04-08 2: 2025-04-08
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 (5317,5256,1705,983,2952,6292,6251,2695,6203,2648,6452,3694)

7.02msdb_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` = 13737 group by `course_type`.`id`

17.03msdb_collegesearchCollegeController.php#1260

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

1.14msdb_collegesearchCollegeController.php#1288

Bindings	0: 13737
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` = 13737 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 23 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

1.24msdb_collegesearchCollegeController.php#1313

Bindings	0: Active 1: 13737 2: 3: 4: 23
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` = 13737 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 23 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

880μsdb_collegesearchCollegeController.php#1331

Bindings	0: Active 1: 13737 2: 3: 4: 23
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` = 13737 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 23 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.49msdb_collegesearchCollegeController.php#1349

Bindings	0: Active 1: 13737 2: 3: 4: 23
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` = 13737 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.72msdb_collegesearchCollegeController.php#1353

Bindings	0: 13737 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` = 13737 and date(`start_date`) <= '2025-04-08' and date(`end_date`) >= '2025-04-08'

1.77msdb_collegesearchCollegeController.php#2682

Bindings	0: 13737 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/asian-academy-of-film-and-television-aaft/courses-fee-specific' and `status` = 'Y' limit 1

1.26msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/asian-academy-of-film-and-television-aaft/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` = 13737 and `images`.`deleted_at` is null limit 1

1.07msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 13737
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` = 13737 and `expiry_date` > '2025-04-08 14:07:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.42msdb_collegesearchhelpers.php#1695

Bindings	0: 13737 1: 2025-04-08 14:07:40
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-08 14:07:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.15msdb_collegesearchhelpers.php#1712

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

940μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 23 2: 2025-04-08 14:07:40
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` = 13737 and `admin_reporting`.`institute_id` is not null

1.34msdb_collegesearchCollegeController.php#2749

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

1.32msdb_collegesearchCollegeController.php#2802

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

620μsdb_collegesearchCollegeController.php#2835

Bindings	0: 13737
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` = 23 limit 1

630μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 23
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` = 13737 and `collaboration`.`institute_id` is not null

4.92msdb_collegesearchCollegeController.php#2867

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

900μsdb_collegesearchhero_section.blade.php#27

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

1.49msdb_collegesearchnavbar.blade.php#31

Bindings	0: 13737
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.18msdb_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: 81InstituteCourse.php#?
App\Models\SubCourse: 63SubCourse.php#?
App\Models\CourseType: 19CourseType.php#?
App\Models\AdminReporting: 10AdminReporting.php#?
App\Models\Image: 6Image.php#?
App\Models\Collaboration: 5Collaboration.php#?
App\Models\Institute: 3Institute.php#?
App\Models\UserReview: 3UserReview.php#?
App\Models\State: 1State.php#?
App\Models\CourseFees: 1CourseFees.php#?
App\Models\FeesType: 1FeesType.php#?

_token: hwzqs1zUuPERgQxnuhRKfHsn7T7xKhoGyZhG69qP
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/asian-academy-of-film-and-television...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/asian-academy-of-film-and-television-aaft/diploma-3d-animation-vfx

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 08:37:40 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imx0cXRXSG94WDhGaHZXRDgyQmZNRnc9PSIsInZhbHVlIjoiSjUrTGJNRXBzU21Rc1pHRzAxVURiRHpxTFBwS3lKK1NUbTZ6blFSQ1ZqcUYwVVJ6SE1HbEUxd2RnZFhETDBFUW85Ykw5T1J1R1dQVVQ0U0c5N3E2cGNwT2RpS1lXWUFUb1hyV0NVeGJaeVlSaTQxVDFKTEhtT2pKWU1oTnB4MFUiLCJtYWMiOiJkYjZkNzkyODFhZmU5MDA5Y2U1NGI1MDQ4OGYwYjMyZjM1YjgzMDQ4NjMxMjQzNGM0ZTcyZjU3NTc0ZDNjODI1IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:37:40 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Imx0cXRXSG94WDhGaHZXRDgyQmZNRnc9PSIsInZhbHVlIjoiSjUrTGJNRXBzU21Rc1pHRzAxVURiRHpxTFBwS3lKK1NUbTZ6blFSQ1ZqcUYwVVJ6SE1HbEUxd2RnZFhETDBFUW85Ykw5T ▶"
    1 => "cs_dev_session=eyJpdiI6Imt4VzRjUEIrRDFMa25JL2ZWTjVwVGc9PSIsInZhbHVlIjoiWnNidzNZdnpoQlhycndyTzZYb2JKdGhkTFJYbkpuSW9pTnFXM1dQUkMyVmMrMkJTeS9CN1B0WkFiYnlDbEdjemI4aWx1ektXZlRQcEdFQnc0OWVHV2VnOFdvKzEyZUc5Vk10VlJ2MjBBQ2hYUjBJOTVLaFYzY0EzRXczNCt1aisiLCJtYWMiOiI0MDgxNjM5NWRmOGM0ZTdmZmRkZDY1ZDY3NmY4YWM4NDNkMmMyOGZlMmI0OWY2YTg3MDI4NGY0NmM5ZTZjYjA4IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:37:40 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6Imt4VzRjUEIrRDFMa25JL2ZWTjVwVGc9PSIsInZhbHVlIjoiWnNidzNZdnpoQlhycndyTzZYb2JKdGhkTFJYbkpuSW9pTnFXM1dQUkMyVmMrMkJTeS9CN1B0WkFiYnlDbEdjemI4a ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imx0cXRXSG94WDhGaHZXRDgyQmZNRnc9PSIsInZhbHVlIjoiSjUrTGJNRXBzU21Rc1pHRzAxVURiRHpxTFBwS3lKK1NUbTZ6blFSQ1ZqcUYwVVJ6SE1HbEUxd2RnZFhETDBFUW85Ykw5T1J1R1dQVVQ0U0c5N3E2cGNwT2RpS1lXWUFUb1hyV0NVeGJaeVlSaTQxVDFKTEhtT2pKWU1oTnB4MFUiLCJtYWMiOiJkYjZkNzkyODFhZmU5MDA5Y2U1NGI1MDQ4OGYwYjMyZjM1YjgzMDQ4NjMxMjQzNGM0ZTcyZjU3NTc0ZDNjODI1IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:37:40 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Imx0cXRXSG94WDhGaHZXRDgyQmZNRnc9PSIsInZhbHVlIjoiSjUrTGJNRXBzU21Rc1pHRzAxVURiRHpxTFBwS3lKK1NUbTZ6blFSQ1ZqcUYwVVJ6SE1HbEUxd2RnZFhETDBFUW85Ykw5T ▶"
    1 => "cs_dev_session=eyJpdiI6Imt4VzRjUEIrRDFMa25JL2ZWTjVwVGc9PSIsInZhbHVlIjoiWnNidzNZdnpoQlhycndyTzZYb2JKdGhkTFJYbkpuSW9pTnFXM1dQUkMyVmMrMkJTeS9CN1B0WkFiYnlDbEdjemI4aWx1ektXZlRQcEdFQnc0OWVHV2VnOFdvKzEyZUc5Vk10VlJ2MjBBQ2hYUjBJOTVLaFYzY0EzRXczNCt1aisiLCJtYWMiOiI0MDgxNjM5NWRmOGM0ZTdmZmRkZDY1ZDY3NmY4YWM4NDNkMmMyOGZlMmI0OWY2YTg3MDI4NGY0NmM5ZTZjYjA4IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:37:40 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6Imt4VzRjUEIrRDFMa25JL2ZWTjVwVGc9PSIsInZhbHVlIjoiWnNidzNZdnpoQlhycndyTzZYb2JKdGhkTFJYbkpuSW9pTnFXM1dQUkMyVmMrMkJTeS9CN1B0WkFiYnlDbEdjemI4a ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "hwzqs1zUuPERgQxnuhRKfHsn7T7xKhoGyZhG69qP"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/asian-academy-of-film-and-television-aaft/diploma-3d-animation-vfx"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 14:07:40	GET	/colleges/asian-academy-of-film-and-television-aaft/diploma-3d-animation-vfx	1 14 50 193

School of Animation
Name of Course	Plan-A			Plan-B						O.T Pmt
Name of Course	6 Instalment Plan			5 Instalment Plan
	Duration	Per Inst.	Total	1st July 2019	1st Dec 2019	1st May 2020	1st Oct 2020	1st Mar 2021	Total	Total
Bachelor	3 Years	68000	408000	130000	60000	60000	60000	60000	370000	350000
University fees	3 Years	10000	60000	20000	10000	10000	10000	10000	60000	60000

6 Instalment Plan
Due Date	Duration	1st July 2019	1st Dec 2019	1st May 2020	1st Oct 2020	1st Mar 2021	1st Aug 2021 Total
Bachelor	3 Year	68000	68000	68000	68000	68000	68000	408000
University fees	3 Year	10000	10000	10000	10000	10000	10000	60000

Name of Course	4 Installment Plan			3 Installment Plan				O.T Pmt
Name of Course	Duration	Per Inst.	Total	1st July 2019	1st Dec 2019	1st May 2020 Total		Total
Master	2 Years	80000	320000	140000	75000	75000	290000	280000
University fees	2 Years	10000	40000	20000	10000	10000	40000	40000

4 Instalment Plan
Due Date	Duration	1st July 2019	1st Dec 2019	1st May 2020	1st Oct 2020	Total
Master	2 Years	80000	80000	80000	80000	320000
University fees	2 Years	10000	10000	10000	10000	40000

Course	1st July 2019	1st Dec 2019	Total	O.T Pmt
Diploma in 3D Animation & VFX	80000	80000	160000	145000
Diploma in Multimedia & Digital Marketing	60000	60000	120000	112000

Diploma in 3D Animation & VFX at Asian Academy of Film and Television (AAFT), Noida

Diploma in 3D Animation & VFX Fees Details

Detailed Fees Breakup

Diploma in 3D Animation & VFX Branch Fees Details

Asian Academy of Film and Television (AAFT), Noida Admission Details

Asian Academy of Film and Television (AAFT), Noida Top Recruiters

Student's Rating for Asian Academy of Film and Television (AAFT) , Noida

Contact Details

1 x Application (98.11%)	722ms
1 x Booting (1.89%)	13.91ms