Alard Group of Institutes Pune - Admission 2025, Courses, Fees, Review, Placements

Messages1 Timeline Exceptions Views26 Route Queries72 Models86 Mails Gate Session Request

Request history8.3.19577ms4MBGET colleges/{slug}

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

Booting (10.02ms)time
Application (567ms)time
1 x Application (98.26%)
567ms
1 x Booting (1.74%)
10.02ms

26 templates were rendered

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

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

72 statements were executed, 20 of which were duplicates, 52 unique. Show only duplicated453ms

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/alard-group-of-institutes-pune' and `status` = 1 limit 1

7.63msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/alard-group-of-institutes-pune 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` = 'alard-group-of-institutes-pune' and `status` = 'Active' limit 1

1msdb_collegesearchCacheService.php#492

Bindings	0: alard-group-of-institutes-pune 1: Active
Backtrace	15. app/Service/CacheService.php:492 16. app/Service/CacheService.php:478 17. middleware::softRedirects:88 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'alard-group-of-institutes-pune') limit 1

650μsdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: alard-group-of-institutes-pune
Backtrace	15. app/Http/Controllers/CollegeController.php:52 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

239msdb_collegesearchCollegeController.php#239

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

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

1.97msdb_collegesearchCollegeController.php#239

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

select * from `sub_course` where `sub_course`.`id` in (2, 8, 11, 14, 73, 79)

810μsdb_collegesearchCollegeController.php#239

Bindings	0: 2 1: 8 2: 11 3: 14 4: 73 5: 79
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (1, 2, 8, 10, 11, 14)

1.49msdb_collegesearchCollegeController.php#239

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

select * from `ranks` where `ranks`.`course_type` in (1, 2, 8, 10, 11, 14) and `institute_id` = 13249 order by `year` desc

610μsdb_collegesearchCollegeController.php#239

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

select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (28163, 28164, 28168, 28169, 28170, 28171) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

950μsdb_collegesearchCollegeController.php#239

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

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

590μsdb_collegesearchCollegeController.php#239

Backtrace

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

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

1.37msdb_collegesearchCollegeController.php#239

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

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

1.37msdb_collegesearchCollegeController.php#239

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

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

20.77msdb_collegesearchCollegeController.php#239

Backtrace

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

select * from `images` where `images`.`institute_id` in (13249) 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.65msdb_collegesearchCollegeController.php#239

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

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

2.01msdb_collegesearchCollegeController.php#239

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

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

990μsdb_collegesearchCollegeController.php#239

Backtrace

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

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

1.73msdb_collegesearchCollegeController.php#239

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

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

1.12msdb_collegesearchCollegeController.php#239

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

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (49480) order by `vote_up` desc

1.94msdb_collegesearchCollegeController.php#239

Backtrace

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

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

1.17msdb_collegesearchCollegeController.php#239

Backtrace

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

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

920μsdb_collegesearchCollegeController.php#239

Backtrace

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

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

1.33msdb_collegesearchCollegeController.php#239

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

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

1.51msdb_collegesearchCollegeController.php#239

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

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

1.14msdb_collegesearchCollegeController.php#239

Backtrace

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

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

1.02msdb_collegesearchCollegeController.php#239

Backtrace

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

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

18.01msdb_collegesearchCollegeController.php#246

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

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

840μsdb_collegesearchCollegeController.php#248

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

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

21.57msdb_collegesearchCollegeController.php#250

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

select * from `cutoff_new_shagun_json` where `institute_course_id` in (28163, 28164, 28165, 28166, 28167, 28168, 28169, 28170, 28171) and (`round_id` = 1 and `status` = 1)

6.11msdb_collegesearchCollegeController.php#268

Bindings	0: 28163 1: 28164 2: 28165 3: 28166 4: 28167 5: 28168 6: 28169 7: 28170 8: 28171 9: 1 10: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:268 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

970μsdb_collegesearchCollegeController.php#297

Backtrace

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

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

1.35msdb_collegesearchCollegeController.php#316

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

select `h_package`, `l_package`, `a_package`, `ic`.`id`, `ic`.`course_type`, `ct`.`alternate_name` as `ctype`, `year_placement` from `placement_course` left join `institute_courses` as `ic` on `ic`.`id` = `placement_course`.`institute_course_id` left join `course_type` as `ct` on `ct`.`id` = `ic`.`course_type` where `institute_course_id` in (28163, 28164, 28165, 28166, 28167, 28168, 28169, 28170, 28171) and `placement_course`.`deleted_at` is null order by `year_placement` desc

1.2msdb_collegesearchCollegeController.php#325

Bindings	0: 28163 1: 28164 2: 28165 3: 28166 4: 28167 5: 28168 6: 28169 7: 28170 8: 28171
Backtrace	14. app/Http/Controllers/CollegeController.php:325 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

20msdb_collegesearchCollegeController.php#342

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

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

1.15msdb_collegesearchCollegeController.php#345

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

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

20.13msdb_collegesearchCollegeController.php#351

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

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

2.47msdb_collegesearchCollegeController.php#388

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

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

1.31msdb_collegesearchCollegeController.php#415

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

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

2.84msdb_collegesearchCollegeController.php#433

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

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

1.64msdb_collegesearchCollegeController.php#451

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

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

1.01msdb_collegesearchCollegeController.php#455

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

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

3.63msdb_collegesearchCollegeController.php#477

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

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

1.47msdb_collegesearchInstitute.php#210

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

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

820μsdb_collegesearchInstitute.php#224

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

select * from `metatags` where `PageID` = 'colleges/alard-group-of-institutes-pune' and `status` = 'Y' limit 1

1.56msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/alard-group-of-institutes-pune 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:549 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

640μsdb_collegesearchCollegeController.php#613

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

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

790μsdb_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:631 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

1.61msdb_collegesearchCollegeController.php#637

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

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

12.97msdb_collegesearchCollegeController.php#658

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

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

1.51msdb_collegesearchCollegeController.php#670

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

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

2.4msdb_collegesearchCollegeController.php#672

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

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

2.33msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:672
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 (20)

1.6msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

740μsdb_collegesearchCollegeController.php#686

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

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

590μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

1.84msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:694
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 (21,22,23,27,28,47)

1.44msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:693
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 (21,22,23,27,28,47)

1.57msdb_collegesearchInstituteCourse.php#30

Backtrace

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

940μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

610μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

920μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

1.9msdb_collegesearchInstituteCourse.php#30

Backtrace

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

780μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

1.13msdb_collegesearchInstituteCourse.php#30

Backtrace

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

1.16msdb_collegesearchInstituteCourse.php#30

Backtrace

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

750μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:694
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-info%' and `module_link_id` = 13249 and `expiry_date` > '2025-04-08 22:18:01' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.2msdb_collegesearchhelpers.php#1695

Bindings	0: 13249 1: 2025-04-08 22:18:01
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 ('20', '21', '22', '23', '27', '28', '47', '102', '116', '134', '137') and `expiry_date` > '2025-04-08 22:18:01' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.15msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 20 2: 21 3: 22 4: 23 5: 27 6: 28 7: 47 8: 102 9: 116 10: 134 11: 137 12: 2025-04-08 22:18:01
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', '2', '8', '10', '11', '14') and `expiry_date` > '2025-04-08 22:18:01' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.41msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 2 3: 8 4: 10 5: 11 6: 14 7: 2025-04-08 22:18:01
Backtrace	14. app/helpers.php:1726 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

2.02msdb_collegesearchhero_section.blade.php#27

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

1.13msdb_collegesearchnavbar.blade.php#31

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

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

1.18msdb_collegesearchawards_v2.blade.php#2

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

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

1.42msdb_collegesearchhelpers.php#970

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

App\Models\InstituteCourse: 32InstituteCourse.php#?
App\Models\Criteria: 24Criteria.php#?
App\Models\CourseType: 8CourseType.php#?
App\Models\SubCourse: 6SubCourse.php#?
App\Models\Document: 4Document.php#?
App\Models\UserReview: 4UserReview.php#?
App\Models\Institute: 2Institute.php#?
App\Models\Image: 2Image.php#?
App\Models\InstituteToc: 1InstituteToc.php#?
App\Models\State: 1State.php#?
App\Models\UserReviewsVoteUp: 1UserReviewsVoteUp.php#?
App\Models\InstituteProfile: 1InstituteProfile.php#?

_token: hIqO5x1S0F8AprtJiuj2LbsYXvd5RaqDnRQU5G2P
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/alard-group-of-institutes-pune" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/alard-group-of-institutes-pune

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 16:48:01 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik5nU3U5cmZhUUxwOHVqYUNKL2c5N0E9PSIsInZhbHVlIjoidHBXdEgwVjdqSldrS2srUGhkZFpIYkx2NUFoalBkQUxobW4wN2tIM2xFQ1NUbXlFT202blpFaGJtNExWM3FuMG9VaDZzYmNHUGZrVkd3VDFHcjBFTGFrV0lvbldJQ3VNSHhMS2FOWDB3UXViM2NUUm4zay9YbkErbUtvU2FBd0kiLCJtYWMiOiI5ZWQ2NjZkYzU0NmNkMGI5YjA5MjU5MTY0N2M4ZjM3NTBiNmU2NDc5NmZlOWVhNmViNjIyZjJjNmExY2JkNmFmIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 18:48:02 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik5nU3U5cmZhUUxwOHVqYUNKL2c5N0E9PSIsInZhbHVlIjoidHBXdEgwVjdqSldrS2srUGhkZFpIYkx2NUFoalBkQUxobW4wN2tIM2xFQ1NUbXlFT202blpFaGJtNExWM3FuMG9VaDZzY ▶"
    1 => "cs_dev_session=eyJpdiI6IjkrbWl4RHNnUzQrMk1xZUQ5eE55Vnc9PSIsInZhbHVlIjoiUk0rbytLYUJsbFN4eWVTZFhHWnRnaDE4elE3dGFGeWdlSGlNSnZvdnBWOTBvcTR4b0cvZVVhUUtoR29vM3FwVFpRbjBPcUY1R01Fd09xdGUzSFVnR3NEWVZwUjI1aVlLVFM4ZGlEdHdBb25INDhoK1UyQVBFMlYvYTFBeWx1YmgiLCJtYWMiOiJiZWFmMmU0Nzk4NTVlNzQyMDhiZTBlZTM4NzNkZDM5NTBiOWM4MWY2ODA1MzIxOTRhMmMzNzUwMDJiYzJmZTE0IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 18:48:02 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IjkrbWl4RHNnUzQrMk1xZUQ5eE55Vnc9PSIsInZhbHVlIjoiUk0rbytLYUJsbFN4eWVTZFhHWnRnaDE4elE3dGFGeWdlSGlNSnZvdnBWOTBvcTR4b0cvZVVhUUtoR29vM3FwVFpRb ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik5nU3U5cmZhUUxwOHVqYUNKL2c5N0E9PSIsInZhbHVlIjoidHBXdEgwVjdqSldrS2srUGhkZFpIYkx2NUFoalBkQUxobW4wN2tIM2xFQ1NUbXlFT202blpFaGJtNExWM3FuMG9VaDZzYmNHUGZrVkd3VDFHcjBFTGFrV0lvbldJQ3VNSHhMS2FOWDB3UXViM2NUUm4zay9YbkErbUtvU2FBd0kiLCJtYWMiOiI5ZWQ2NjZkYzU0NmNkMGI5YjA5MjU5MTY0N2M4ZjM3NTBiNmU2NDc5NmZlOWVhNmViNjIyZjJjNmExY2JkNmFmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 18:48:02 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5nU3U5cmZhUUxwOHVqYUNKL2c5N0E9PSIsInZhbHVlIjoidHBXdEgwVjdqSldrS2srUGhkZFpIYkx2NUFoalBkQUxobW4wN2tIM2xFQ1NUbXlFT202blpFaGJtNExWM3FuMG9VaDZzY ▶"
    1 => "cs_dev_session=eyJpdiI6IjkrbWl4RHNnUzQrMk1xZUQ5eE55Vnc9PSIsInZhbHVlIjoiUk0rbytLYUJsbFN4eWVTZFhHWnRnaDE4elE3dGFGeWdlSGlNSnZvdnBWOTBvcTR4b0cvZVVhUUtoR29vM3FwVFpRbjBPcUY1R01Fd09xdGUzSFVnR3NEWVZwUjI1aVlLVFM4ZGlEdHdBb25INDhoK1UyQVBFMlYvYTFBeWx1YmgiLCJtYWMiOiJiZWFmMmU0Nzk4NTVlNzQyMDhiZTBlZTM4NzNkZDM5NTBiOWM4MWY2ODA1MzIxOTRhMmMzNzUwMDJiYzJmZTE0IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 18:48:02 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IjkrbWl4RHNnUzQrMk1xZUQ5eE55Vnc9PSIsInZhbHVlIjoiUk0rbytLYUJsbFN4eWVTZFhHWnRnaDE4elE3dGFGeWdlSGlNSnZvdnBWOTBvcTR4b0cvZVVhUUtoR29vM3FwVFpRb ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "hIqO5x1S0F8AprtJiuj2LbsYXvd5RaqDnRQU5G2P"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/alard-group-of-institutes-pune"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 22:18:02	GET	/colleges/alard-group-of-institutes-pune	1 26 72 86

Particulars	Statistics
Campus Location	Pune, Maharashtra
Courses Offered	UG and PG
Median Salary	INR 240,000
Fees Range	INR 12,000-840,000
No. of Seats	871

Alard Group of Institutes, Pune

Alard Group of Institutes , Pune Highlights 2025

Alard Group of Institutes Highlights 2024

Alard Group of Institutes , Pune Popular Courses

Student's Rating for Alard Group of Institutes , Pune

Contact Details

1 x Application (98.26%)	567ms
1 x Booting (1.74%)	10.02ms