"What is the admission criteria of Parul University?"

"Admissions are either based on merit scores in the qualifying exam or national/state level entrance exams conducted for that particular course."

"What is the application mode of Parul University?"

"The application mode of Parul University is online. Candidates can apply online via official website."

"How are student facilities at Parul University?"

"Parul University has an excellent campus spread around 150+ acres. The campus has well established library, gymnasium, swimming pool, open-air theatre, hostel services, banking service and a hospital ."

"What is the establishment year of Parul University?"

"Parul University commenced its establishment in 2015."

"What are the entrance exam accepted by the university for MBA Course?"

"Parul University accepts CAT, MAT, XAT, CMAT etc score for MBA admission."

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

Parul University, Valsad

Reviews

Private University

Parul University, Valsad Reviews

Valsad, Gujarat
ESTD 1989

Shortlist

Brochure

+11 Photos & Videos

Student's Rating for Parul University , Valsad

Student Reviews & Ratings

3.3/5

57% Positive reviews

Component Ratings

Faculty Rating

Internship/Placement Rating

3.5

Infrastructure Rating

4.3

Canteen Rating

4.7

Hostel/Dorm Rating

4.2

College Fest Rating

4.3

Fashion Rating

4.5

Sports Rating

3.5

Write a Review >

Student's Reviews for Parul University, Valsad

Courses

Contact Details

Address

P.O.Limda, Ta.Waghodia , Dist. Vadodara, Valsad, Gujarat, 391760

College Contact

02668 - 26XXXXXX04

pixxxet@xxxin

Get Contact Details

Parul University , Valsad

3.3/5 (33 reviews)

Shortlist

Brochure

Parul University, Valsad

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 Queries59 Models281 Mails Gate Session Request

Request history8.3.19698ms5MBGET university/{slug}/{tab}

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

Booting (6.5ms)time
Application (691ms)time
1 x Application (99.07%)
691ms
1 x Booting (0.93%)
6.50ms

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 university/{slug}/{tab}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfileTab
namespace
prefix
where
as: cp.univtabs
file: app/Http/Controllers/CollegeController.php:715-2899

59 statements were executed, 16 of which were duplicates, 43 unique. Show only duplicated386ms

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` = '/university/parul-university-valsad/reviews' and `status` = 1 limit 1

9.26msdb_collegesearchCacheService.php#460

Bindings	0: /university/parul-university-valsad/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` = 'parul-university-valsad' and `status` = 'Active' limit 1

1.53msdb_collegesearchCacheService.php#492

Bindings	0: parul-university-valsad 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` = 'parul-university-valsad') limit 1

5.1msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: parul-university-valsad
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.51msdb_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` = 9866 and `institute_courses`.`institute_id` is not null

4.88msdb_collegesearchCollegeController.php#771

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

203msdb_collegesearchCollegeController.php#780

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

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

890μsdb_collegesearchCollegeController.php#807

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

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

2.86msdb_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 (6, 9)

750μsdb_collegesearchCollegeController.php#807

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

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

1.13msdb_collegesearchInstitute.php#210

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

3.43msdb_collegesearchCollegeController.php#837

Bindings	0: 9866
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 (9866) and `status` = 'active' order by `course_type` asc limit 5

17.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.8msdb_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 (9866) 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

890μ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` = 9866

5.66msdb_collegesearchCollegeController.php#1430

Bindings	0: 9866
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 = 9866 and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc limit 0,5

2.17msdb_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 = 9866 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

3.06msdb_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 (2622,978,1099,3268,6127)

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

16.68msdb_collegesearchCollegeController.php#1483

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

8.06msdb_collegesearchCollegeController.php#1511

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

14.04msdb_collegesearchCollegeController.php#1547

Bindings	0: Active 1: 9866
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` = 9866 order by `added_date` desc limit 10 offset 0

6.62msdb_collegesearchCollegeController.php#1547

Bindings	0: Active 1: 9866
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 (68424, 68446, 69384, 71449, 73118, 74166, 74702, 78847, 84868, 85792) order by `vote_up` desc

1.44msdb_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, 7)

1.62msdb_collegesearchCollegeController.php#1547

Bindings	0: 0 1: 1 2: 2 3: 7
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` = 9866 and `intern_rating` != '' and `placement_desc` != ''

2.61msdb_collegesearchCollegeController.php#1576

Bindings	0: Active 1: 9866 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` = 9866 and `intern_rating` != '' and `placement_desc` != '' order by `added_date` desc limit 10 offset 0

1.29msdb_collegesearchCollegeController.php#1576

Bindings	0: Active 1: 9866 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 (9368, 9413, 28967, 28968, 30772, 44951, 45474, 52413, 54881, 85792) order by `vote_up` desc

3.39msdb_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 (1, 2, 74)

1.96msdb_collegesearchCollegeController.php#1576

Bindings	0: 1 1: 2 2: 74
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` = 9866 and `teacher_rating` != '' and `teacher_desc` != ''

2.01msdb_collegesearchCollegeController.php#1606

Bindings	0: Active 1: 9866 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` = 9866 and `teacher_rating` != '' and `teacher_desc` != '' order by `added_date` desc limit 10 offset 0

3.81msdb_collegesearchCollegeController.php#1606

Bindings	0: Active 1: 9866 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 (28967, 28968, 30772, 44834, 44951, 45474, 52413, 54881, 62433, 85792) order by `vote_up` desc

8.23msdb_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 (1, 2, 7)

700μsdb_collegesearchCollegeController.php#1606

Bindings	0: 1 1: 2 2: 7
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` = 9866 and `admission_rating` != '' and `admission_desc` != ''

1.33msdb_collegesearchCollegeController.php#1636

Bindings	0: Active 1: 9866 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` = 9866 and `admission_rating` != '' and `admission_desc` != '' order by `added_date` desc limit 10 offset 0

2.91msdb_collegesearchCollegeController.php#1636

Bindings	0: Active 1: 9866 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 (9368, 9413, 28967, 28968, 30772) order by `vote_up` desc

1.49msdb_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, 2, 74)

1.65msdb_collegesearchCollegeController.php#1636

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

820μsdb_collegesearchCollegeController.php#1648

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

1.29msdb_collegesearchCollegeController.php#1661

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

1.45msdb_collegesearchCollegeController.php#2682

Bindings	0: 9866 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` = 'university/parul-university-valsad/reviews' and `status` = 'Y' limit 1

870μsdb_collegesearchCollegeController.php#2693

Bindings	0: university/parul-university-valsad/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` = 9866 and `images`.`deleted_at` is null limit 1

910μsdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 9866
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 (38)

2.22msdb_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 (38)

1.02msdb_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 (38)

1.08msdb_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 (38)

720μ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` = 9866 and `expiry_date` > '2025-04-08 07:38:37' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

4.3msdb_collegesearchhelpers.php#1695

Bindings	0: 9866 1: 2025-04-08 07:38:37
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 ('38') and `expiry_date` > '2025-04-08 07:38:37' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

2.29msdb_collegesearchhelpers.php#1712

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

2.52msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 1 3: 2 4: 2 5: 4 6: 2025-04-08 07:38:37
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` = 9866 and `admin_reporting`.`institute_id` is not null

1.63msdb_collegesearchCollegeController.php#2749

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

1.7msdb_collegesearchCollegeController.php#2802

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

2msdb_collegesearchCollegeController.php#2835

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

620μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 1
Backtrace	15. app/Service/Breadcrumb.php:167 16. app/Service/Breadcrumb.php:37 17. app/Http/Controllers/CollegeController.php: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` = 9866 and `collaboration`.`institute_id` is not null

1.14msdb_collegesearchCollegeController.php#2867

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

1.06msdb_collegesearchCollegeController.php#2877

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

1.18msdb_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 (38)

750μsdb_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` = 9866 and `user_reviews`.`institute_id` is not null

1.81msdb_collegesearchhero_section.blade.php#27

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

3.7msdb_collegesearchnavbar.blade.php#31

Bindings	0: 9866
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.14msdb_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: 115UserReview.php#?
App\Models\InstituteCourse: 82InstituteCourse.php#?
App\Models\UserReviewsVoteUp: 33UserReviewsVoteUp.php#?
App\Models\CourseType: 15CourseType.php#?
App\Models\Image: 11Image.php#?
App\Models\AdminReporting: 8AdminReporting.php#?
App\Models\Criteria: 6Criteria.php#?
App\Models\InstituteFaqs: 5InstituteFaqs.php#?
App\Models\Collaboration: 3Collaboration.php#?
App\Models\Institute: 2Institute.php#?
App\Models\State: 1State.php#?

_token: 1d4FiicbnP3FVlYPbxUhQf0o3AI83ML1SY2Ek2N4
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/university/parul-university-valsad/reviews" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/university/parul-university-valsad/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 02:08:37 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9EVWxYU04zK0ZuTjQ4aVlOb0kzOVE9PSIsInZhbHVlIjoid1R5alorUGpWQ2xrNjEzZUNBOEhzc1JLRVZOV3RNaE0zZGtNSTFCOFA0ZzEybGxCbjJWN1lnRTBTS3dvc3J0N1RsSXpIT2hCRWRrNEJUTTYxM1ZyUEhCTUZSRzBmWlJmcGluM2VlU3BqZDFRSWY3SlVQQTNBK3BCdk9xV2VMTWYiLCJtYWMiOiIxNzZmNTIzYzZmMjg3YjFiM2FhNmIxMjQ0MGZkODBkNGQ3YzE2ZTRiODNmYzExNzlkZmQ5ZTRjNDZhYjIwYTYwIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 04:08:37 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik9EVWxYU04zK0ZuTjQ4aVlOb0kzOVE9PSIsInZhbHVlIjoid1R5alorUGpWQ2xrNjEzZUNBOEhzc1JLRVZOV3RNaE0zZGtNSTFCOFA0ZzEybGxCbjJWN1lnRTBTS3dvc3J0N1RsSXpIT ▶"
    1 => "cs_dev_session=eyJpdiI6Ik1OMzIreDVCRzdGT09ScGxMTjhlVXc9PSIsInZhbHVlIjoiMzJqSklYTlAySTVIZEYyTjZ6TjljT1NCUFJzd1Zld1VlY2VOdFdpcktTZU9LNHp3cDZCd2twQVFZcFhQTTZhRlhjVjl2enlBZng4Z0tMeThuZ29mU2lucEo4VzFFRFMyT0FnelNLNjBnaUs1L1ZWN1phamhDRHFRZDBmckRrVmYiLCJtYWMiOiI2YjExZmVjMzAxMmE0YzhiNjFiMGI2OTYxMmVhZmQwMThiYzlhZWFhNmM3NzYxZTZhYTJjYzljNTZkNmNjZGFiIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 04:08:37 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6Ik1OMzIreDVCRzdGT09ScGxMTjhlVXc9PSIsInZhbHVlIjoiMzJqSklYTlAySTVIZEYyTjZ6TjljT1NCUFJzd1Zld1VlY2VOdFdpcktTZU9LNHp3cDZCd2twQVFZcFhQTTZhRlhjV ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9EVWxYU04zK0ZuTjQ4aVlOb0kzOVE9PSIsInZhbHVlIjoid1R5alorUGpWQ2xrNjEzZUNBOEhzc1JLRVZOV3RNaE0zZGtNSTFCOFA0ZzEybGxCbjJWN1lnRTBTS3dvc3J0N1RsSXpIT2hCRWRrNEJUTTYxM1ZyUEhCTUZSRzBmWlJmcGluM2VlU3BqZDFRSWY3SlVQQTNBK3BCdk9xV2VMTWYiLCJtYWMiOiIxNzZmNTIzYzZmMjg3YjFiM2FhNmIxMjQ0MGZkODBkNGQ3YzE2ZTRiODNmYzExNzlkZmQ5ZTRjNDZhYjIwYTYwIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 04:08:37 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9EVWxYU04zK0ZuTjQ4aVlOb0kzOVE9PSIsInZhbHVlIjoid1R5alorUGpWQ2xrNjEzZUNBOEhzc1JLRVZOV3RNaE0zZGtNSTFCOFA0ZzEybGxCbjJWN1lnRTBTS3dvc3J0N1RsSXpIT ▶"
    1 => "cs_dev_session=eyJpdiI6Ik1OMzIreDVCRzdGT09ScGxMTjhlVXc9PSIsInZhbHVlIjoiMzJqSklYTlAySTVIZEYyTjZ6TjljT1NCUFJzd1Zld1VlY2VOdFdpcktTZU9LNHp3cDZCd2twQVFZcFhQTTZhRlhjVjl2enlBZng4Z0tMeThuZ29mU2lucEo4VzFFRFMyT0FnelNLNjBnaUs1L1ZWN1phamhDRHFRZDBmckRrVmYiLCJtYWMiOiI2YjExZmVjMzAxMmE0YzhiNjFiMGI2OTYxMmVhZmQwMThiYzlhZWFhNmM3NzYxZTZhYTJjYzljNTZkNmNjZGFiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 04:08:37 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6Ik1OMzIreDVCRzdGT09ScGxMTjhlVXc9PSIsInZhbHVlIjoiMzJqSklYTlAySTVIZEYyTjZ6TjljT1NCUFJzd1Zld1VlY2VOdFdpcktTZU9LNHp3cDZCd2twQVFZcFhQTTZhRlhjV ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "1d4FiicbnP3FVlYPbxUhQf0o3AI83ML1SY2Ek2N4"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/university/parul-university-valsad/reviews"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 07:38:37	GET	/university/parul-university-valsad/reviews	2 18 59 281

1 x Application (99.07%)	691ms
1 x Booting (0.93%)	6.50ms