"Is Dev Bonomi Group of Institutions, Dehradun government college?"

"No, Dev Bhoomi Group of Institutions is a private institute offering various courses."

"What are the top recruiters of Dev Bhoomi Group of Institutions?"

"Dev Bhoomi Group of Institutions has good placement record. The top recruiters of the college are Softrix Web Solutions, Accademia Guru, Justdial, Paytm, Karvy, Apollo Munich, Concentrix, etc."

"What is the establishment year of Dev Bhoomi Group of Institutions?"

"Dev Bhoomi Group of Institutions was established in 2005."

"Does Dev Bhoomi Group of Institutions offer scholarships?"

"A. Yes, Dev Bhoomi Group of Institutions offers scholarships to the students."

"What are the approving bodies of Dev Bhoomi Group of Institutions?"

"Dev Bhoomi Group of Institutions is approved by All India Council of Technical Education (AICTE), Council of Architecture (CoA), Pharmacy Council of India (PCI) and Central Council of Indian Medicine (CCIM)."

Join CollegeSearch Family

Register & enjoy the perks of a Universal College Application, Easy Process, Time-saving, and Free Contact details and Brochures.

20 Lakhs+

Monthly Users

1.75 Lakh+

Monthly Applications

30K +

Admissions

info@collegesearch.in +91 92281 51258

Popular Colleges by Branches

MBA/PGDM MCA B.Tech / B.E B.Sc BCA BBA B.COM

Trending Search

Top MBA Colleges in Delhi/NCR

Top MBA Colleges in Bangalore

Top Engineering Colleges in Delhi/NCR

Top Engineering Colleges in Bangalore

No Result Found

Dev Bhoomi Group of Institutions, Dehradun

Reviews

Private College

Dev Bhoomi Group of Institutions, Dehradun Reviews

Dehradun, Uttarakhand
ESTD 2005

Shortlist

Brochure

Dev Bhoomi Group of Institutions , Dehradun campus

Dev Bhoomi Group of Institutions , Dehradun Technical Event

+30 Photos & Videos

Student's Rating for Dev Bhoomi Group of Institutions , Dehradun

Student Reviews & Ratings

3.8/5

51% Positive reviews

Component Ratings

Faculty Rating

3.4

Internship/Placement Rating

3.8

Infrastructure Rating

3.2

Canteen Rating

2.8

Hostel/Dorm Rating

3.9

College Fest Rating

3.9

Fashion Rating

3.8

Sports Rating

3.2

Write a Review >

Student's Reviews for Dev Bhoomi Group of Institutions, Dehradun

Courses

Contact Details

Address

Dev Bhoomi Campus, Chakrata Road Navgaon, Manduwala,, Dehradun, Uttarakhand, 248007

College Contact

0135 - 26XXXXXX43

adxxxon@xxxin

Get Contact Details

Dev Bhoomi Group of Institutions , Dehradun

3.8/5 (31 reviews)

Shortlist

Brochure

Dev Bhoomi Group of Institutions, Dehradun

Reviews

Popular Searches

Popular Colleges/Universities

LPU (Lovely Professional University), Jalandhar Amity University, Noida Chandigarh University (CU), Chandigarh Indian Institute of Management (IIM), Bangalore Indian Institute of Technology, Delhi Ajeenkya DY Patil University Powered by Sunstone

Top Colleges by Courses

Top Engineering Colleges in India Top MBA/PGDM Colleges in India Top MCA Colleges in India Top BCA Colleges in India Top BBA Colleges in India Top Msc Colleges in India Top Bsc Colleges in India

Top Exams

JEE Main JEE Advanced CAT CUET SNAP XAT KCET

Top Courses

BTech MBA BBA BCA BCom MCA BSc

Top Boards

CBSE 12th Board CBSE 10th Board UP 12th Board Punjab 12th Board West Bengal 12th Board Maharashtra 12th Board

Messages2 Timeline Exceptions Views18 Route Queries57 Models263 Mails Gate Session Request

Request history8.3.19598ms5MBGET colleges/{slug}/{tab}

warninglog[07:03:09] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
warninglog[07:03:10] LOG.warning: parse_url(): Passing null to parameter #1 ($url) of type string is deprecate...

Booting (12.66ms)time
Application (586ms)time
1 x Application (97.88%)
586ms
1 x Booting (2.12%)
12.66ms

18 templates were rendered

pages.college_v2.reviewsreviews.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_section-reviewdeatailed_review_section-review.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.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

57 statements were executed, 14 of which were duplicates, 43 unique. Show only duplicated393ms

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/dev-bhoomi-group-of-institutions-dehradun/reviews' and `status` = 1 limit 1

11.78msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/dev-bhoomi-group-of-institutions-dehradun/reviews 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 * from `institutes` where (`status` = 'Active' and `ics_link_2` = 'dev-bhoomi-group-of-institutions-dehradun') limit 1

4.42msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: dev-bhoomi-group-of-institutions-dehradun
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` = 'reviews' limit 1

3.16msdb_collegesearchCollegeController.php#746

Bindings	0: reviews
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` = 2328 and `institute_courses`.`institute_id` is not null

3.49msdb_collegesearchCollegeController.php#771

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

213msdb_collegesearchCollegeController.php#780

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

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

5.63msdb_collegesearchCollegeController.php#807

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

3.61msdb_collegesearchCollegeController.php#807

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

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

960μsdb_collegesearchCollegeController.php#807

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

select * from `institute_courses` where `institute_courses`.`institute_id` in (2328) and `status` = 'active' order by `course_type` asc limit 5

21.79msdb_collegesearchCollegeController.php#1373

Bindings	0: active
Backtrace	19. app/Http/Controllers/CollegeController.php:1373 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 `institutes` where `institutes`.`aff_univ_id` in ('') and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)

1.59msdb_collegesearchCollegeController.php#1373

Bindings	0: 1: 2: 0 3: 4: 0
Backtrace	19. app/Http/Controllers/CollegeController.php:1373 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 `images` where `images`.`institute_id` in (2328) 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

10.22msdb_collegesearchCollegeController.php#1373

Bindings	0: 0
Backtrace	19. app/Http/Controllers/CollegeController.php:1373 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 (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` = 2328

2.18msdb_collegesearchCollegeController.php#1430

Bindings	0: 2328
Backtrace	14. app/Http/Controllers/CollegeController.php:1430 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(user_reviews.id) as num,course_type,course_type.id,course_type.alternate_name from user_reviews
inner join course_type on course_type.id = user_reviews.course_type  where user_reviews.status = 'Active' and user_reviews.institute_id = 2328 and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc limit 0,5

1.49msdb_collegesearchCollegeController.php#1440

Backtrace

10. app/Http/Controllers/CollegeController.php:1440
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 count(user_reviews.id) as num,course_type,course_type.id,course_type.alternate_name from user_reviews
inner join course_type on course_type.id = user_reviews.course_type  where user_reviews.status = 'Active' and user_reviews.institute_id = 2328 and user_reviews.placement_desc !='' and user_reviews.teacher_desc !='' and user_reviews.college_desc !='' and user_reviews.admission_desc !=''  and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc

1.97msdb_collegesearchCollegeController.php#1453

Backtrace

10. app/Http/Controllers/CollegeController.php:1453
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 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 (68,139,1600,2244,2785,2201,1105,3,106,1227,1309,5198,139,930,1106,3462,6266,3084,1227,1119,1105,3462,60,6020,2759,5198,105,1952)

2.5msdb_collegesearchCollegeController.php#1461

Backtrace

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

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

24.9msdb_collegesearchCollegeController.php#1483

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

2.38msdb_collegesearchCollegeController.php#1511

Bindings	0: 2328
Backtrace	14. app/Http/Controllers/CollegeController.php:1511 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 `user_reviews` where `status` = 'Active' and `institute_id` = 2328

11.31msdb_collegesearchCollegeController.php#1547

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

select `id`, `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` = 2328 order by `added_date` desc limit 10 offset 0

1.39msdb_collegesearchCollegeController.php#1547

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

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (75133, 75134, 75135, 75363, 75448, 75524, 77298, 79223, 94474, 94808) order by `vote_up` desc

1.27msdb_collegesearchCollegeController.php#1547

Backtrace

20. app/Http/Controllers/CollegeController.php:1547
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 `course_name`, `id` from `course_type` where `course_type`.`id` in (0, 1, 2, 11)

1.23msdb_collegesearchCollegeController.php#1547

Bindings	0: 0 1: 1 2: 2 3: 11
Backtrace	20. app/Http/Controllers/CollegeController.php:1547 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 count(*) as aggregate from `user_reviews` where `status` = 'Active' and `institute_id` = 2328 and `intern_rating` != '' and `placement_desc` != ''

1.33msdb_collegesearchCollegeController.php#1576

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

select `id`, `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` = 2328 and `intern_rating` != '' and `placement_desc` != '' order by `added_date` desc limit 10 offset 0

1.55msdb_collegesearchCollegeController.php#1576

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

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (14460, 28951, 40332, 52356, 94474, 94808) order by `vote_up` desc

1.86msdb_collegesearchCollegeController.php#1576

Backtrace

20. app/Http/Controllers/CollegeController.php:1576
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 `course_name`, `id` from `course_type` where `course_type`.`id` in (0, 1, 19)

800μsdb_collegesearchCollegeController.php#1576

Bindings	0: 0 1: 1 2: 19
Backtrace	20. app/Http/Controllers/CollegeController.php:1576 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 count(*) as aggregate from `user_reviews` where `status` = 'Active' and `institute_id` = 2328 and `teacher_rating` != '' and `teacher_desc` != ''

940μsdb_collegesearchCollegeController.php#1606

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

select `id`, `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` = 2328 and `teacher_rating` != '' and `teacher_desc` != '' order by `added_date` desc limit 10 offset 0

1.37msdb_collegesearchCollegeController.php#1606

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

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (28951, 40332, 41707, 52356, 75019, 94474, 94808) order by `vote_up` desc

1.36msdb_collegesearchCollegeController.php#1606

Backtrace

20. app/Http/Controllers/CollegeController.php:1606
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 `course_name`, `id` from `course_type` where `course_type`.`id` in (0, 1, 15, 19)

1.86msdb_collegesearchCollegeController.php#1606

Bindings	0: 0 1: 1 2: 15 3: 19
Backtrace	20. app/Http/Controllers/CollegeController.php:1606 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 count(*) as aggregate from `user_reviews` where `status` = 'Active' and `institute_id` = 2328 and `admission_rating` != '' and `admission_desc` != ''

1.58msdb_collegesearchCollegeController.php#1636

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

select `id`, `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` = 2328 and `admission_rating` != '' and `admission_desc` != '' order by `added_date` desc limit 10 offset 0

1.61msdb_collegesearchCollegeController.php#1636

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

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

750μsdb_collegesearchCollegeController.php#1636

Backtrace

20. app/Http/Controllers/CollegeController.php:1636
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 `course_name`, `id` from `course_type` where `course_type`.`id` in (1)

1.5msdb_collegesearchCollegeController.php#1636

Bindings	0: 1
Backtrace	20. app/Http/Controllers/CollegeController.php:1636 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`, `type` from `institute_insights` where `institute_id` = 2328 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.34msdb_collegesearchCollegeController.php#1648

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

1.79msdb_collegesearchCollegeController.php#1661

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

1.98msdb_collegesearchCollegeController.php#2682

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

select * from `metatags` where `PageID` = 'colleges/dev-bhoomi-group-of-institutions-dehradun/reviews' and `status` = 'Y' limit 1

2.61msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/dev-bhoomi-group-of-institutions-dehradun/reviews 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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (117)

1.2msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

6.12msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

2msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

1.17msdb_collegesearchInstituteCourse.php#30

Backtrace

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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (21,93,23,22)

1.43msdb_collegesearchInstituteCourse.php#30

Backtrace

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

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (21,93,23,22)

840μsdb_collegesearchInstituteCourse.php#30

Backtrace

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

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where modulename like '%cp-inner-reviews%' and `module_link_id` = 2328 and `expiry_date` > '2025-04-08 07:03:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.41msdb_collegesearchhelpers.php#1695

Bindings	0: 2328 1: 2025-04-08 07:03:10
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 ('117', '21', '22', '23', '93') and `expiry_date` > '2025-04-08 07:03:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.21msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 117 2: 21 3: 22 4: 23 5: 93 6: 2025-04-08 07:03:10
Backtrace	14. app/helpers.php:1712 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('1', '1', '1', '2', '7') and `expiry_date` > '2025-04-08 07:03:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

3.14msdb_collegesearchhelpers.php#1726

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

select * from `admin_reporting` where `admin_reporting`.`institute_id` = 2328 and `admin_reporting`.`institute_id` is not null

940μsdb_collegesearchCollegeController.php#2749

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

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

2.17msdb_collegesearchCollegeController.php#2802

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

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

1.66msdb_collegesearchCollegeController.php#2835

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

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

1.47msdb_collegesearchBreadcrumb.php#167

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

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

1.52msdb_collegesearchCollegeController.php#2867

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

2.55msdb_collegesearchCollegeController.php#2877

Bindings	0: 2328
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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (117)

1.43msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

1.81msdb_collegesearchInstituteCourse.php#30

Backtrace

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

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

2.3msdb_collegesearchhero_section.blade.php#27

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

3.59msdb_collegesearchnavbar.blade.php#31

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

1.2msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-reviews
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\UserReview: 106UserReview.php#?
App\Models\InstituteCourse: 67InstituteCourse.php#?
App\Models\Image: 29Image.php#?
App\Models\UserReviewsVoteUp: 15UserReviewsVoteUp.php#?
App\Models\Criteria: 14Criteria.php#?
App\Models\CourseType: 11CourseType.php#?
App\Models\AdminReporting: 10AdminReporting.php#?
App\Models\InstituteFaqs: 5InstituteFaqs.php#?
App\Models\Collaboration: 3Collaboration.php#?
App\Models\Institute: 2Institute.php#?
App\Models\State: 1State.php#?

_token: JU7RHFds0iwOUDHMImUsr21rJHFlAvo6CZJRAj0O
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/dev-bhoomi-group-of-institutions-deh...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/dev-bhoomi-group-of-institutions-dehradun/reviews

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 01:33:10 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNFYUYydjBXaDlVK2hJSEQrNXUyZkE9PSIsInZhbHVlIjoiNEJCT1VwRHh6MG5TSDE4MkpzVmM1dm12aUM3dkNDc2RPOFZCZjFubVJjTlNvNjFDdCtuZUN6MEplbWRyanUyMSswcEtlR1IzQUNtVHIxVnpFL01KQXhiRm51SHRjd3ZaUjNIdk9xK25JRWd4RkZEWCtNMXFBZzkzajdKN0EyVWMiLCJtYWMiOiI0NmUzMGUxNGM4ZGYzOTIwMWZiYjhjY2I1YmMwMjhiOWNlNWFkMmJjMDA0ZDg3ODk3NTBmZGJkN2UyODg4ODViIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 03:33:10 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkNFYUYydjBXaDlVK2hJSEQrNXUyZkE9PSIsInZhbHVlIjoiNEJCT1VwRHh6MG5TSDE4MkpzVmM1dm12aUM3dkNDc2RPOFZCZjFubVJjTlNvNjFDdCtuZUN6MEplbWRyanUyMSswcEtlR ▶"
    1 => "cs_dev_session=eyJpdiI6IlV0MUd1NGtyWkJKOFlMaVd6czJYT2c9PSIsInZhbHVlIjoiWVZpcG5RRGNRMDFjZ0NlQllhOTl5cmFJY09ZakNubXBXVnNpRExqRlVXMDl1d2pibTZoVnlEVys3N1JCbGM4UEU1WE1NNGs0Z1ZXVWYwcHVyNFprNnZsZVNQSDBSaHp2TzcvNnROU2ZoQlhacWNnSXU0ditQeG5PbjlNb09uNUIiLCJtYWMiOiI0YjkwZjQ3M2M3NWMzYTU1MGJiNTM5MmYwM2JkZTRlOGY5YjBhYWRmZDYxN2U1ZjdjYzI4OWM5NzYzNjQ3NTg5IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 03:33:10 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IlV0MUd1NGtyWkJKOFlMaVd6czJYT2c9PSIsInZhbHVlIjoiWVZpcG5RRGNRMDFjZ0NlQllhOTl5cmFJY09ZakNubXBXVnNpRExqRlVXMDl1d2pibTZoVnlEVys3N1JCbGM4UEU1W ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNFYUYydjBXaDlVK2hJSEQrNXUyZkE9PSIsInZhbHVlIjoiNEJCT1VwRHh6MG5TSDE4MkpzVmM1dm12aUM3dkNDc2RPOFZCZjFubVJjTlNvNjFDdCtuZUN6MEplbWRyanUyMSswcEtlR1IzQUNtVHIxVnpFL01KQXhiRm51SHRjd3ZaUjNIdk9xK25JRWd4RkZEWCtNMXFBZzkzajdKN0EyVWMiLCJtYWMiOiI0NmUzMGUxNGM4ZGYzOTIwMWZiYjhjY2I1YmMwMjhiOWNlNWFkMmJjMDA0ZDg3ODk3NTBmZGJkN2UyODg4ODViIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 03:33:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkNFYUYydjBXaDlVK2hJSEQrNXUyZkE9PSIsInZhbHVlIjoiNEJCT1VwRHh6MG5TSDE4MkpzVmM1dm12aUM3dkNDc2RPOFZCZjFubVJjTlNvNjFDdCtuZUN6MEplbWRyanUyMSswcEtlR ▶"
    1 => "cs_dev_session=eyJpdiI6IlV0MUd1NGtyWkJKOFlMaVd6czJYT2c9PSIsInZhbHVlIjoiWVZpcG5RRGNRMDFjZ0NlQllhOTl5cmFJY09ZakNubXBXVnNpRExqRlVXMDl1d2pibTZoVnlEVys3N1JCbGM4UEU1WE1NNGs0Z1ZXVWYwcHVyNFprNnZsZVNQSDBSaHp2TzcvNnROU2ZoQlhacWNnSXU0ditQeG5PbjlNb09uNUIiLCJtYWMiOiI0YjkwZjQ3M2M3NWMzYTU1MGJiNTM5MmYwM2JkZTRlOGY5YjBhYWRmZDYxN2U1ZjdjYzI4OWM5NzYzNjQ3NTg5IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 03:33:10 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IlV0MUd1NGtyWkJKOFlMaVd6czJYT2c9PSIsInZhbHVlIjoiWVZpcG5RRGNRMDFjZ0NlQllhOTl5cmFJY09ZakNubXBXVnNpRExqRlVXMDl1d2pibTZoVnlEVys3N1JCbGM4UEU1W ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "JU7RHFds0iwOUDHMImUsr21rJHFlAvo6CZJRAj0O"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/dev-bhoomi-group-of-institutions-dehradun/reviews"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 07:03:10	GET	/colleges/dev-bhoomi-group-of-institutions-dehradun/reviews	2 18 57 263

1 x Application (97.88%)	586ms
1 x Booting (2.12%)	12.66ms