Messages2 Timeline Exceptions Views14 Route Queries45 Models73 Mails Gate Session Request

Request history8.3.19541ms4MBGET colleges/{slug}/{tab}

warninglog[12:37:14] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
warninglog[12:37:14] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...

Booting (12.44ms)time
Application (529ms)time
1 x Application (97.7%)
529ms
1 x Booting (2.3%)
12.44ms

14 templates were rendered

pages.college_v2.placementsplacements.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

45 statements were executed, 8 of which were duplicates, 37 unique. Show only duplicated415ms

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/unitedworld-institute-of-design-ahmedabad/placements' and `status` = 1 limit 1

6.83msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/unitedworld-institute-of-design-ahmedabad/placements 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` = 'unitedworld-institute-of-design-ahmedabad' and `status` = 'Active' limit 1

1.62msdb_collegesearchCacheService.php#492

Bindings	0: unitedworld-institute-of-design-ahmedabad 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` = 'unitedworld-institute-of-design-ahmedabad') limit 1

3.03msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: unitedworld-institute-of-design-ahmedabad
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` = 'placements' limit 1

4.43msdb_collegesearchCollegeController.php#746

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

select * from `institute_courses` where `institute_courses`.`institute_id` = 12437 and `institute_courses`.`institute_id` is not null

1.61msdb_collegesearchCollegeController.php#771

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

select `id`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` LIKE '%cutoff%') as `institute_faqs_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `institutes`.`id` in (12437)

214msdb_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 (74)

7.01msdb_collegesearchCollegeController.php#807

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

1.11msdb_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 `name` from `images` where `is_desktop` = 1 and `institute_id` = 12437 and `images`.`deleted_at` is null limit 1

1.69msdb_collegesearchInstitute.php#210

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

3.66msdb_collegesearchCollegeController.php#837

Bindings	0: 12437
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 h_package,a_package,l_package,institute_course_id,d.highest_package,d.average_package,course_name,alternate_name,e.sub_course_name as courseName FROM placement_course AS a LEFT JOIN institute_courses AS b ON a.institute_course_id=b.id LEFT JOIN course_type AS d ON b.course_type=d.id LEFT JOIN institutes AS c ON b.institute_id=c.id LEFT JOIN sub_course AS e ON b.sub_course_id=e.id WHERE c.id=12437 order by a.year_placement desc, b.sequence

1.37msdb_collegesearchCollegeController.php#1677

Backtrace

10. app/Http/Controllers/CollegeController.php:1677
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 `institutes`.*, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `institutes` as `laravel_reserved_2` where `institutes`.`old_univ_id` = `laravel_reserved_2`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count` from `institutes` where `id` = 12437 and `status` = 'Active' limit 1

89.38msdb_collegesearchCollegeController.php#1736

Bindings	0: 1: 0 2: 3: 0 4: 43 5: 6: 12437 7: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:1736 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 `document` where `document`.`institute_id` in (12437)

680μsdb_collegesearchCollegeController.php#1736

Backtrace

20. app/Http/Controllers/CollegeController.php:1736
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 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 (12437) order by `ID` desc limit 1

800μsdb_collegesearchCollegeController.php#1736

Backtrace

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

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

2.76msdb_collegesearchCollegeController.php#1736

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

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

3.79msdb_collegesearchCollegeController.php#1736

Bindings	0: 255
Backtrace	30. app/Http/Controllers/CollegeController.php:1736 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 * from `institute_courses` where `institute_courses`.`institute_id` in (12437) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

1.77msdb_collegesearchCollegeController.php#1736

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:1736 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 (12437) and `status` = 'Active' and `college_desc` != '' order by `sequence` asc, length(college_desc) desc limit 10

1.61msdb_collegesearchCollegeController.php#1736

Bindings	0: Active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:1736 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 (42150) order by `vote_up` desc

890μsdb_collegesearchCollegeController.php#1736

Backtrace

25. app/Http/Controllers/CollegeController.php:1736
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 `images` where `images`.`institute_id` in (12437) 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

25.72msdb_collegesearchCollegeController.php#1736

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

select * from `institute_faqs` where `institute_faqs`.`institute_id` in (12437) and `section` LIKE '%placements%'

1.24msdb_collegesearchCollegeController.php#1736

Bindings	0: %placements%
Backtrace	20. app/Http/Controllers/CollegeController.php:1736 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 (12437) and `status` = 'active' order by `course_type` asc limit 5

3.1msdb_collegesearchCollegeController.php#1736

Bindings	0: active
Backtrace	20. app/Http/Controllers/CollegeController.php:1736 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 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 (49,2485,2773,3441,1640,6068,2648,451,2817,5024,6483,6475)

2.02msdb_collegesearchCollegeController.php#1738

Backtrace

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

select * from `states` where `states`.`StateID` = 74 and `states`.`StateID` is not null limit 1

610μsdb_collegesearchCollegeController.php#1754

Bindings	0: 74
Backtrace	20. app/Http/Controllers/CollegeController.php:1754 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 (12437) and `status` = 'active' order by `course_type` asc limit 5

1.28msdb_collegesearchCollegeController.php#1760

Bindings	0: active
Backtrace	19. app/Http/Controllers/CollegeController.php:1760 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 `inst_campaign_bharat_2022` where `institute_id` = 12437 and date(`start_date`) <= '2025-04-12' and date(`end_date`) >= '2025-04-12'

1.7msdb_collegesearchCollegeController.php#1772

Bindings	0: 12437 1: 2025-04-12 2: 2025-04-12
Backtrace	14. app/Http/Controllers/CollegeController.php:1772 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 `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` = 12437 group by `course_type`.`id`

10.23msdb_collegesearchCollegeController.php#1803

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

1.17msdb_collegesearchCollegeController.php#1831

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

890μsdb_collegesearchCollegeController.php#1856

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

910μsdb_collegesearchCollegeController.php#1874

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

820μsdb_collegesearchCollegeController.php#1892

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

890μsdb_collegesearchCollegeController.php#1896

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

1.39msdb_collegesearchCollegeController.php#2682

Bindings	0: 12437 1: 2025-04-12 2: 2025-04-12
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/unitedworld-institute-of-design-ahmedabad/placements' and `status` = 'Y' limit 1

1.2msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/unitedworld-institute-of-design-ahmedabad/placements 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` = 12437 and `images`.`deleted_at` is null limit 1

1.06msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 12437
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-placements%' and `module_link_id` = 12437 and `expiry_date` > '2025-04-12 12:37:14' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.22msdb_collegesearchhelpers.php#1695

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

1.06msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 2: 2025-04-12 12:37:14
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', '33', '49', '89') and `expiry_date` > '2025-04-12 12:37:14' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

850μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 23 2: 33 3: 49 4: 89 5: 2025-04-12 12:37:14
Backtrace	14. app/helpers.php:1726 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `ranks` where `ranks`.`institute_id` = 12437 and `ranks`.`institute_id` is not null

1.11msdb_collegesearchCollegeController.php#2835

Bindings	0: 12437
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

840μ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` = 12437 and `collaboration`.`institute_id` is not null

1.7msdb_collegesearchCollegeController.php#2867

Bindings	0: 12437
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 `institute_courses` where `institute_courses`.`institute_id` = 12437 and `institute_courses`.`institute_id` is not null limit 1

1.07msdb_collegesearchCollegeController.php#2877

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

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

1.74msdb_collegesearchhero_section.blade.php#27

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

1.21msdb_collegesearchnavbar.blade.php#31

Bindings	0: 12437
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-placements' and `brandings`.`deleted_at` is null

1.61msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-placements
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\Image: 34Image.php#?
App\Models\InstituteCourse: 17InstituteCourse.php#?
App\Models\UserReview: 6UserReview.php#?
App\Models\Institute: 3Institute.php#?
App\Models\Document: 3Document.php#?
App\Models\Collaboration: 3Collaboration.php#?
App\Models\State: 2State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\UserReviewsVoteUp: 1UserReviewsVoteUp.php#?
App\Models\CourseType: 1CourseType.php#?

_token: RHlyxQWJ3kx7H3nkUzry8YlKMKydTQBwz7pFlNdq
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/unitedworld-institute-of-design-ahme...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/unitedworld-institute-of-design-ahmedabad/placements

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 => "Sat, 12 Apr 2025 07:07:14 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZha2RRUU5kNVBNL05zdFk3dy82dGc9PSIsInZhbHVlIjoic0xEQ0M1ZFE0Y1EwRmRjaG5mYWwvOUplRHV0c25xdTFEQitLWUdQb3crdW9qUjBrTGk1eU1oeWJTSW1uc1VVRUZRVUZtTUl6RlJwdy9XQVJpOXYzTDJ1eFJrUFNVb09EMVZmeUJ2dlc4K3VqTEN2eUxKUEwwdXJmZmZDeklrbzciLCJtYWMiOiJmMThjZDZiOGY1MTgzMjU5YTJkZWYzNDI2ZTNiYmFmNzEyOWYwMmZhZTdlNDhiYjhkNTJmYTI1ZjllOGQxMTc0IiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 09:07:14 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkZha2RRUU5kNVBNL05zdFk3dy82dGc9PSIsInZhbHVlIjoic0xEQ0M1ZFE0Y1EwRmRjaG5mYWwvOUplRHV0c25xdTFEQitLWUdQb3crdW9qUjBrTGk1eU1oeWJTSW1uc1VVRUZRVUZtT ▶"
    1 => "cs_dev_session=eyJpdiI6IkdYY2lOQXFhcTFGcWNkTGdUSkdCM1E9PSIsInZhbHVlIjoidE91bGx3M2cyWW9jZHdBMTlKbmRSODlWa2J2ODgvZStRMGZVUWx1QzdDNkYxa3ByR0YzbnRBb0hualRyVTdxMjA0YkVFa1kvWEZDZDlUOThvTkZwdkhrZmtFd0FXZEVYMkxHeDJ6NUxmNVRXclQ2aDUycVBLRU0wN0VObFdjSGciLCJtYWMiOiI0YzhlMTYwOGQxOWUwZmY4ZmM5OWY1MjI0Y2U4MDc2OTIzODhiOTVmOWIxMDNmOWU1YjBlNGI0OTBlZDUwYjVjIiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 09:07:14 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IkdYY2lOQXFhcTFGcWNkTGdUSkdCM1E9PSIsInZhbHVlIjoidE91bGx3M2cyWW9jZHdBMTlKbmRSODlWa2J2ODgvZStRMGZVUWx1QzdDNkYxa3ByR0YzbnRBb0hualRyVTdxMjA0Y ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZha2RRUU5kNVBNL05zdFk3dy82dGc9PSIsInZhbHVlIjoic0xEQ0M1ZFE0Y1EwRmRjaG5mYWwvOUplRHV0c25xdTFEQitLWUdQb3crdW9qUjBrTGk1eU1oeWJTSW1uc1VVRUZRVUZtTUl6RlJwdy9XQVJpOXYzTDJ1eFJrUFNVb09EMVZmeUJ2dlc4K3VqTEN2eUxKUEwwdXJmZmZDeklrbzciLCJtYWMiOiJmMThjZDZiOGY1MTgzMjU5YTJkZWYzNDI2ZTNiYmFmNzEyOWYwMmZhZTdlNDhiYjhkNTJmYTI1ZjllOGQxMTc0IiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 09:07:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkZha2RRUU5kNVBNL05zdFk3dy82dGc9PSIsInZhbHVlIjoic0xEQ0M1ZFE0Y1EwRmRjaG5mYWwvOUplRHV0c25xdTFEQitLWUdQb3crdW9qUjBrTGk1eU1oeWJTSW1uc1VVRUZRVUZtT ▶"
    1 => "cs_dev_session=eyJpdiI6IkdYY2lOQXFhcTFGcWNkTGdUSkdCM1E9PSIsInZhbHVlIjoidE91bGx3M2cyWW9jZHdBMTlKbmRSODlWa2J2ODgvZStRMGZVUWx1QzdDNkYxa3ByR0YzbnRBb0hualRyVTdxMjA0YkVFa1kvWEZDZDlUOThvTkZwdkhrZmtFd0FXZEVYMkxHeDJ6NUxmNVRXclQ2aDUycVBLRU0wN0VObFdjSGciLCJtYWMiOiI0YzhlMTYwOGQxOWUwZmY4ZmM5OWY1MjI0Y2U4MDc2OTIzODhiOTVmOWIxMDNmOWU1YjBlNGI0OTBlZDUwYjVjIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 09:07:14 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IkdYY2lOQXFhcTFGcWNkTGdUSkdCM1E9PSIsInZhbHVlIjoidE91bGx3M2cyWW9jZHdBMTlKbmRSODlWa2J2ODgvZStRMGZVUWx1QzdDNkYxa3ByR0YzbnRBb0hualRyVTdxMjA0Y ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "RHlyxQWJ3kx7H3nkUzry8YlKMKydTQBwz7pFlNdq"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/unitedworld-institute-of-design-ahmedabad/placements"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-12 12:37:14	GET	/colleges/unitedworld-institute-of-design-ahmedabad/placements	2 14 45 73

Particulars	Statistics (2022)
Total recruiters	200+
Average package (B Des)	INR 8 LPA to INR 12 LPA
Average package (M Des)	INR 10 LPA to INR 14 LPA

Unitedworld Institute of Design, Ahmedabad Placements

Unitedworld Institute of Design,Placement Highlights 2025

UID Ahmedabad Placement Report 2022: Highlights

Unitedworld Institute of Design Top Recruiters

Student's Rating for Unitedworld Institute of Design , Ahmedabad

Contact Details

1 x Application (97.7%)	529ms
1 x Booting (2.3%)	12.44ms