Pravara Rural College of Architecture Reviews: Campus, Placement, Admission Reviews by Students | CollegeSearch
college search  Private College

Pravara Rural College of Architecture, Ahmednagar Reviews

  • college search Ahmednagar, Maharashtra
  • college search ESTD 1996
Pravara Rural College of Architecture , Ahmednagar  campus
Pravara Rural College of Architecture , Ahmednagar  campus

Recommended Colleges

Amity University- Mumbai  3.5
Amity University- Mumbai
  • Amity University- MumbaiMumbai
  •  Private College
Course Offered

B.Arch

Fees (5 Years)

Amity University- Mumbai10,50,000

Exams Accepted

NATA, JEE Mains

Highest Package

-

  • Chhatrapati Shivaji Maharaj UniversityMumbai
  •   University
Course Offered

B.Arch

Fees (5 Years)

Chhatrapati Shivaji Maharaj University6,50,000

Exams Accepted

-

Highest Package

-

Student's Rating for Pravara Rural College of Architecture , Ahmednagar

Student Reviews & Ratings
Pravara Rural College of Architecture

5/5

100% Positive reviews
Component Ratings

Faculty Rating

college search   1

Internship/Placement Rating

college search   4.5

Infrastructure Rating

college search   5

Canteen Rating

college search   5

Hostel/Dorm Rating

college search   5

College Fest Rating

college search   5

Fashion Rating

college search   4

Sports Rating

college search   5

Write a Review >

Student's Reviews for Pravara Rural College of Architecture, Ahmednagar

Courses

Tags

Overall
Placement
Faculty

Sort by

college search   5 Overall

30-05-2019
A

Anonymous
B.Arch Student

college search  5.0 Canteen

college search  5.0 Infrastructure

college search  5.0 Sports

college search  5.0 Events

college search  3.5 PG

college search  5.0 Hostel

college search  4.5 Internship/Placement

college search  1.0 Faculty

Good place for building career and quality learning - A good place to learn new things in Architectural life.

Placement: Internship and good jobs/placements
Faculty: Helpful and good faculty
College: Good place for building career and quality learning - A good place to learn new things in Architectural life.The exposure and fun that this college provides is remarkable. Our college has a good library, classrooms, and a satisfactory workshop area. The faculty is helpful, humble and kind. Every semester the Cultural + Architectural events are held in our college.
Exam: Through CAP GOVT round

Read Full Review

college search   5 Overall

02-08-2018
H

Harish dabhade
B.Arch Student

Read Full Review

college search   5 Overall

30-05-2019
A

Anonymous
B.Arch Student

college search  5.0 Canteen

college search  5.0 Infrastructure

college search  5.0 Sports

college search  5.0 Events

college search  3.5 PG

college search  5.0 Hostel

college search  4.5 Internship/Placement

college search  1.0 Faculty

Good place for building career and quality learning - A good place to learn new things in Architectural life.

Placement: Internship and good jobs/placements

Read Full Review

college search   5 Overall

30-05-2019
A

Anonymous
B.Arch Student

college search  5.0 Canteen

college search  5.0 Infrastructure

college search  5.0 Sports

college search  5.0 Events

college search  3.5 PG

college search  5.0 Hostel

college search  4.5 Internship/Placement

college search  1.0 Faculty

Good place for building career and quality learning - A good place to learn new things in Architectural life.

Faculty: Helpful and good faculty

Read Full Review

Contact Details

Address

Post.: Loni Kd., Tal.: Rahata, Ahmednagar, Maharashtra, 413736

College Contact

02422 - 27XXXXXX68

Email

inxxxfo@xxxrg

Get Contact Details

Pravara Rural College of Architecture , Ahmednagar

college search 5/5 (2 reviews)
Request history8.3.13PHP Version270msRequest Duration4MBMemory UsageGET colleges/{slug}/{tab}Route
  • warninglog[03:50:33] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
  • warninglog[03:50:34] LOG.warning: parse_url(): Passing null to parameter #1 ($url) of type string is deprecate...
  • Booting (5.18ms)time
  • Application (264ms)time
  • 1 x Application (98.08%)
    264ms
    1 x Booting (1.92%)
    5.18ms
    17 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
    • 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.dev.collegesearch.in
    controller
    App\Http\Controllers\CollegeController@collegeProfileTab
    namespace
    prefix
    where
    as
    cp.collegetabs
    file
    app/Http/Controllers/CollegeController.php:715-2899
    53 statements were executed, 17 of which were duplicates, 36 unique. Show only duplicated193ms
    • 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/pravara-rural-college-of-architecture-ahmednagar/reviews' and `status` = 1 limit 1
      7.67msdb_collegesearchCacheService.php#460
      Bindings
      • 0: /colleges/pravara-rural-college-of-architecture-ahmednagar/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 `ics_link_2` from `institutes` where `ics_link` = 'pravara-rural-college-of-architecture-ahmednagar' and `status` = 'Active' limit 1
      1.21msdb_collegesearchCacheService.php#492
      Bindings
      • 0: pravara-rural-college-of-architecture-ahmednagar
      • 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` = 'pravara-rural-college-of-architecture-ahmednagar') limit 1
      2msdb_collegesearchCollegeController.php#723
      Bindings
      • 0: Active
      • 1: pravara-rural-college-of-architecture-ahmednagar
      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.26msdb_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` = 7312 and `institute_courses`.`institute_id` is not null
      990μsdb_collegesearchCollegeController.php#771
      Bindings
      • 0: 7312
      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 (7312)
      123msdb_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 (83)
      1.48msdb_collegesearchCollegeController.php#807
      Bindings
      • 0: 83
      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 (7312) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2
      1.44msdb_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` = 7312 and `images`.`deleted_at` is null limit 1
      1.91msdb_collegesearchInstitute.php#210
      Bindings
      • 0: 1
      • 1: 7312
      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` = 7312
      3msdb_collegesearchCollegeController.php#837
      Bindings
      • 0: 7312
      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 * from `institute_courses` where `institute_courses`.`institute_id` in (7312) and `status` = 'active' order by `course_type` asc limit 5
      1.15msdb_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)
      2.21msdb_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 (7312) 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
      970μsdb_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` = 7312
      940μsdb_collegesearchCollegeController.php#1430
      Bindings
      • 0: 7312
      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 = 7312 and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc limit 0,5
      930μsdb_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 = 7312 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
      810μsdb_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 (0)
      580μsdb_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` = 7312 group by `course_type`.`id`
      2.35msdb_collegesearchCollegeController.php#1483
      Bindings
      • 0: 7312
      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` = 7312
      1.16msdb_collegesearchCollegeController.php#1511
      Bindings
      • 0: 7312
      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` = 7312
      650μsdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: Active
      • 1: 7312
      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` = 7312 order by `added_date` desc limit 10 offset 0
      760μsdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: Active
      • 1: 7312
      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 (58871, 82211) order by `vote_up` desc
      570μsdb_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 (15)
      460μsdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: 15
      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` = 7312 and `intern_rating` != '' and `placement_desc` != ''
      640μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: Active
      • 1: 7312
      • 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` = 7312 and `intern_rating` != '' and `placement_desc` != '' order by `added_date` desc limit 10 offset 0
      910μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: Active
      • 1: 7312
      • 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 (82211) order by `vote_up` desc
      620μsdb_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 (15)
      570μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: 15
      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` = 7312 and `teacher_rating` != '' and `teacher_desc` != ''
      650μsdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: Active
      • 1: 7312
      • 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` = 7312 and `teacher_rating` != '' and `teacher_desc` != '' order by `added_date` desc limit 10 offset 0
      850μsdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: Active
      • 1: 7312
      • 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 (82211) order by `vote_up` desc
      510μsdb_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 (15)
      570μsdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: 15
      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` = 7312 and `admission_rating` != '' and `admission_desc` != ''
      610μsdb_collegesearchCollegeController.php#1636
      Bindings
      • 0: Active
      • 1: 7312
      • 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`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 7312 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      650μsdb_collegesearchCollegeController.php#1648
      Bindings
      • 0: 7312
      • 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` = 7312 and date(`start_date`) <= '2025-01-03' and date(`end_date`) >= '2025-01-03'
      1.21msdb_collegesearchCollegeController.php#1661
      Bindings
      • 0: 7312
      • 1: 2025-01-03
      • 2: 2025-01-03
      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` = 7312 and date(`start_date`) <= '2025-01-03' and date(`end_date`) >= '2025-01-03'
      1.44msdb_collegesearchCollegeController.php#2682
      Bindings
      • 0: 7312
      • 1: 2025-01-03
      • 2: 2025-01-03
      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/pravara-rural-college-of-architecture-ahmednagar/reviews' and `status` = 'Y' limit 1
      620μsdb_collegesearchCollegeController.php#2693
      Bindings
      • 0: colleges/pravara-rural-college-of-architecture-ahmednagar/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 `name` from `images` where `is_desktop` = 1 and `institute_id` = 7312 and `images`.`deleted_at` is null limit 1
      730μsdb_collegesearchInstitute.php#224
      Bindings
      • 0: 1
      • 1: 7312
      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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2006,190,162)
      710μsdb_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 (2006,190,162)
      1.41msdb_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` = 7312 and `expiry_date` > '2025-01-03 03:50:34' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      1.53msdb_collegesearchhelpers.php#1695
      Bindings
      • 0: 7312
      • 1: 2025-01-03 03:50:34
      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 ('162', '190', '2006') and `expiry_date` > '2025-01-03 03:50:34' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      890μsdb_collegesearchhelpers.php#1712
      Bindings
      • 0: %exam%
      • 1: 162
      • 2: 190
      • 3: 2006
      • 4: 2025-01-03 03:50:34
      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 ('15') and `expiry_date` > '2025-01-03 03:50:34' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      1.07msdb_collegesearchhelpers.php#1726
      Bindings
      • 0: %course%
      • 1: 15
      • 2: 2025-01-03 03:50:34
      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` = 7312 and `admin_reporting`.`institute_id` is not null
      1.91msdb_collegesearchCollegeController.php#2749
      Bindings
      • 0: 7312
      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` = 7312 and `institute_faqs`.`institute_id` is not null
      2.45msdb_collegesearchCollegeController.php#2802
      Bindings
      • 0: 7312
      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` = 7312 and `ranks`.`institute_id` is not null
      1.42msdb_collegesearchCollegeController.php#2835
      Bindings
      • 0: 7312
      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` = 15 limit 1
      700μsdb_collegesearchBreadcrumb.php#167
      Bindings
      • 0: 15
      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` = 7312 and `collaboration`.`institute_id` is not null
      1.48msdb_collegesearchCollegeController.php#2867
      Bindings
      • 0: 7312
      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` = 7312 and `institute_courses`.`institute_id` is not null limit 1
      1.98msdb_collegesearchCollegeController.php#2877
      Bindings
      • 0: 7312
      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 (2006,190,162)
      2.25msdb_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 (2006,190,162)
      1.25msdb_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` = 7312 and `user_reviews`.`institute_id` is not null
      1.37msdb_collegesearchhero_section.blade.php#27
      Bindings
      • 0: 7312
      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` = 7312 and `user_reviews`.`institute_id` is not null
      1.45msdb_collegesearchnavbar.blade.php#31
      Bindings
      • 0: 7312
      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.5msdb_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
    14UserReview.php#?
    App\Models\Criteria
    12Criteria.php#?
    App\Models\InstituteCourse
    4InstituteCourse.php#?
    App\Models\CourseType
    4CourseType.php#?
    App\Models\UserReviewsVoteUp
    3UserReviewsVoteUp.php#?
    App\Models\Institute
    2Institute.php#?
    App\Models\Image
    2Image.php#?
    App\Models\State
    1State.php#?
        _token
        9PbGfE68jLl9bNFB4MSoGTaR7elSA1WXfBnnXS3t
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/pravara-rural-college-of-architectur...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /colleges/pravara-rural-college-of-architecture-ahmednagar/reviews
        status_code
        200
        
        status_text
        OK
        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.dev.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 => "Thu, 02 Jan 2025 22:20:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBuOFA1WlNIWHAwalpZZVNmRjRWdEE9PSIsInZhbHVlIjoia243VStpdE9ubU4yU2F0MjdBRDZLVjdOVVc4K0I0ZVpYd2wyUGZjc1Mrak82dytERFNmTG5BMEhqRHBvSUFHTkQ0SmlHVE9ZRTRMY2R6bmtRVDBsZkJjUW5aWTNpYTgrcWIxaE1FQnRXYlgrR2VCbSs3NVZnaUJMSkZTT05ET3oiLCJtYWMiOiJjZjZkODg3NTQ4YTM0MGJlZTY4ZTczZTQ5OTk5ZWNhMzI5NjZhOTRkMmVlMjQ1Nzk2MDgxNGJmY2M5ZDY5MzdjIiwidGFnIjoiIn0%3D; expires=Fri, 03 Jan 2025 00:20:34 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6InBuOFA1WlNIWHAwalpZZVNmRjRWdEE9PSIsInZhbHVlIjoia243VStpdE9ubU4yU2F0MjdBRDZLVjdOVVc4K0I0ZVpYd2wyUGZjc1Mrak82dytERFNmTG5BMEhqRHBvSUFHTkQ0SmlHV" 1 => "cs_dev_session=eyJpdiI6InBjZnBVR2xtcys3TFlTMjZ3Sng1NlE9PSIsInZhbHVlIjoiaVFrNmF1WFJJa3FuQ0NPWGFSRHZ3aEN4NEhmaXNId1A3TEpjOHdUZHJDTUpWRTdGcndncVJjUStWU0tHZGRQS3QyY2UvdkpnMXdXQmJYb1MwaG5zeUhja1VSTFlNZFBGT1NMWEtZK2hDZy9iNmZYQUZXVG5kOHA0RkFmN3FDa1oiLCJtYWMiOiI1OGM0ZDdjNmQ4MGM2ZTNmYmQ3MGMzYjIxZWFjZGYxMWU3YjU1NTYxODg2MTI2YTQxMzc5ODNiYTcxYTRjNmYwIiwidGFnIjoiIn0%3D; expires=Fri, 03 Jan 2025 00:20:34 GMT; Max-Age=7200; path=/; httponly; samesite=laxcs_dev_session=eyJpdiI6InBjZnBVR2xtcys3TFlTMjZ3Sng1NlE9PSIsInZhbHVlIjoiaVFrNmF1WFJJa3FuQ0NPWGFSRHZ3aEN4NEhmaXNId1A3TEpjOHdUZHJDTUpWRTdGcndncVJjUStWU0tHZGRQS3QyY" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InBuOFA1WlNIWHAwalpZZVNmRjRWdEE9PSIsInZhbHVlIjoia243VStpdE9ubU4yU2F0MjdBRDZLVjdOVVc4K0I0ZVpYd2wyUGZjc1Mrak82dytERFNmTG5BMEhqRHBvSUFHTkQ0SmlHVE9ZRTRMY2R6bmtRVDBsZkJjUW5aWTNpYTgrcWIxaE1FQnRXYlgrR2VCbSs3NVZnaUJMSkZTT05ET3oiLCJtYWMiOiJjZjZkODg3NTQ4YTM0MGJlZTY4ZTczZTQ5OTk5ZWNhMzI5NjZhOTRkMmVlMjQ1Nzk2MDgxNGJmY2M5ZDY5MzdjIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 00:20:34 GMT; path=/XSRF-TOKEN=eyJpdiI6InBuOFA1WlNIWHAwalpZZVNmRjRWdEE9PSIsInZhbHVlIjoia243VStpdE9ubU4yU2F0MjdBRDZLVjdOVVc4K0I0ZVpYd2wyUGZjc1Mrak82dytERFNmTG5BMEhqRHBvSUFHTkQ0SmlHV" 1 => "cs_dev_session=eyJpdiI6InBjZnBVR2xtcys3TFlTMjZ3Sng1NlE9PSIsInZhbHVlIjoiaVFrNmF1WFJJa3FuQ0NPWGFSRHZ3aEN4NEhmaXNId1A3TEpjOHdUZHJDTUpWRTdGcndncVJjUStWU0tHZGRQS3QyY2UvdkpnMXdXQmJYb1MwaG5zeUhja1VSTFlNZFBGT1NMWEtZK2hDZy9iNmZYQUZXVG5kOHA0RkFmN3FDa1oiLCJtYWMiOiI1OGM0ZDdjNmQ4MGM2ZTNmYmQ3MGMzYjIxZWFjZGYxMWU3YjU1NTYxODg2MTI2YTQxMzc5ODNiYTcxYTRjNmYwIiwidGFnIjoiIn0%3D; expires=Fri, 03-Jan-2025 00:20:34 GMT; path=/; httponlycs_dev_session=eyJpdiI6InBjZnBVR2xtcys3TFlTMjZ3Sng1NlE9PSIsInZhbHVlIjoiaVFrNmF1WFJJa3FuQ0NPWGFSRHZ3aEN4NEhmaXNId1A3TEpjOHdUZHJDTUpWRTdGcndncVJjUStWU0tHZGRQS3QyY" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "9PbGfE68jLl9bNFB4MSoGTaR7elSA1WXfBnnXS3t" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/pravara-rural-college-of-architecture-ahmednagar/reviews" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-03 03:50:34GET/colleges/pravara-rural-college-of-architecture-ahmednagar/reviews2175342