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

St Aloysius College, Jabalpur

Reviews

Private College

St Aloysius College, Jabalpur Reviews

Item: St Aloysius College, Jabalpur
Rating: 4
Author: sharan Hazari

Jabalpur, Madhya Pradesh
ESTD 1951

Shortlist

Brochure

St Aloysius College , Jabalpur College Campus

+16 Photos & Videos

Student's Rating for St Aloysius College , Jabalpur

Student Reviews & Ratings

4/5

66% Positive reviews

Component Ratings

Faculty Rating

3.8

Internship/Placement Rating

3.8

Infrastructure Rating

4.1

Canteen Rating

4.1

Hostel/Dorm Rating

2.3

College Fest Rating

Fashion Rating

Sports Rating

3.3

Write a Review >

Student's Reviews for St Aloysius College, Jabalpur

Courses

Contact Details

Address

1, Ahilya Bai Marg, Pentinaka Chowk, Sadar, Jabalpur, Madhya Pradesh, 482001

College Contact

0761 - 26XXXXXX38

stxxx51@xxxom

Get Contact Details

St Aloysius College , Jabalpur

4/5 (9 reviews)

Shortlist

Brochure

St Aloysius College, Jabalpur

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 Queries54 Models94 Mails Gate Session Request

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

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

Booting (15.11ms)time
Application (417ms)time
1 x Application (96.51%)
417ms
1 x Booting (3.49%)
15.11ms

18 templates were rendered

pages.college_v2.reviewsreviews.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
pages.college_v2.partials.navbarnavbar.blade.php#?blade
pages.college_v2.partials.latest_updateslatest_updates.blade.php#?blade
pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
pages.college_v2.partials.deatailed_review_section-reviewdeatailed_review_section-review.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
pages.college_v2.partials.contactcontact.blade.php#?blade
pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
partials.footerfooter.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade

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

54 statements were executed, 12 of which were duplicates, 42 unique. Show only duplicated285ms

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/st-aloysius-college-jabalpur/reviews' and `status` = 1 limit 1

8.9msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/st-aloysius-college-jabalpur/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` = 'st-aloysius-college-jabalpur' and `status` = 'Active' limit 1

960μsdb_collegesearchCacheService.php#492

Bindings	0: st-aloysius-college-jabalpur 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` = 'st-aloysius-college-jabalpur') limit 1

1.78msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: st-aloysius-college-jabalpur
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

6.27msdb_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` = 13194 and `institute_courses`.`institute_id` is not null

1.3msdb_collegesearchCollegeController.php#771

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

187msdb_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 (82)

7.16msdb_collegesearchCollegeController.php#807

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

1.13msdb_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` = 13194 and `images`.`deleted_at` is null limit 1

890μsdb_collegesearchInstitute.php#210

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

4.04msdb_collegesearchCollegeController.php#837

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

1.44msdb_collegesearchCollegeController.php#1373

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

select * from `institutes` where `institutes`.`aff_univ_id` in ('') and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)

1.64msdb_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 (13194) 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

930μ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` = 13194

1.41msdb_collegesearchCollegeController.php#1430

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

1.03msdb_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 = 13194 and user_reviews.placement_desc !='' and user_reviews.teacher_desc !='' and user_reviews.college_desc !='' and user_reviews.admission_desc !=''  and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc

1.47msdb_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)

780μ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` = 13194 group by `course_type`.`id`

10.94msdb_collegesearchCollegeController.php#1483

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

1.6msdb_collegesearchCollegeController.php#1511

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

850μsdb_collegesearchCollegeController.php#1547

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

1.28msdb_collegesearchCollegeController.php#1547

Bindings	0: Active 1: 13194
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 (8084, 30817, 41817, 41972, 53778, 56490, 61486, 70434, 73568) order by `vote_up` desc

870μ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 (0, 7, 19, 21)

780μsdb_collegesearchCollegeController.php#1547

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

680μsdb_collegesearchCollegeController.php#1576

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

970μsdb_collegesearchCollegeController.php#1576

Bindings	0: Active 1: 13194 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 (30817, 53778) order by `vote_up` desc

630μ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 (21)

790μsdb_collegesearchCollegeController.php#1576

Bindings	0: 21
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` = 13194 and `teacher_rating` != '' and `teacher_desc` != ''

850μsdb_collegesearchCollegeController.php#1606

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

2.91msdb_collegesearchCollegeController.php#1606

Bindings	0: Active 1: 13194 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 (30817, 41972, 56490) order by `vote_up` desc

1.25msdb_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 (7, 21)

1.9msdb_collegesearchCollegeController.php#1606

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

920μsdb_collegesearchCollegeController.php#1636

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

1.25msdb_collegesearchCollegeController.php#1636

Bindings	0: Active 1: 13194 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 (30817) order by `vote_up` desc

710μsdb_collegesearchCollegeController.php#1636

Backtrace

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

select `course_name`, `id` from `course_type` where `course_type`.`id` in (21)

820μsdb_collegesearchCollegeController.php#1636

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

890μsdb_collegesearchCollegeController.php#1648

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

1.7msdb_collegesearchCollegeController.php#1661

Bindings	0: 13194 1: 2025-04-09 2: 2025-04-09
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` = 13194 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'

1.97msdb_collegesearchCollegeController.php#2682

Bindings	0: 13194 1: 2025-04-09 2: 2025-04-09
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/st-aloysius-college-jabalpur/reviews' and `status` = 'Y' limit 1

3.39msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/st-aloysius-college-jabalpur/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` = 13194 and `images`.`deleted_at` is null limit 1

1.28msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 13194
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 (2008)

2.3msdb_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 (2008)

1.05msdb_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` = 13194 and `expiry_date` > '2025-04-09 19:21:50' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.52msdb_collegesearchhelpers.php#1695

Bindings	0: 13194 1: 2025-04-09 19:21:50
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 ('2008') and `expiry_date` > '2025-04-09 19:21:50' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

790μsdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 2008 2: 2025-04-09 19:21:50
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 ('7', '13', '19', '20', '21') and `expiry_date` > '2025-04-09 19:21:50' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

920μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 7 2: 13 3: 19 4: 20 5: 21 6: 2025-04-09 19:21:50
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` = 13194 and `admin_reporting`.`institute_id` is not null

1.46msdb_collegesearchCollegeController.php#2749

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

520μsdb_collegesearchCollegeController.php#2802

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

1.25msdb_collegesearchCollegeController.php#2835

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

2.13msdb_collegesearchBreadcrumb.php#167

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

1.24msdb_collegesearchCollegeController.php#2867

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

1.45msdb_collegesearchCollegeController.php#2877

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

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

1.21msdb_collegesearchhero_section.blade.php#27

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

1.24msdb_collegesearchnavbar.blade.php#31

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

730μsdb_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: 37UserReview.php#?
App\Models\InstituteCourse: 21InstituteCourse.php#?
App\Models\Image: 16Image.php#?
App\Models\CourseType: 8CourseType.php#?
App\Models\UserReviewsVoteUp: 7UserReviewsVoteUp.php#?
App\Models\Institute: 2Institute.php#?
App\Models\Criteria: 2Criteria.php#?
App\Models\State: 1State.php#?

_token: sobtlRXRE5jKBRbzvv6jh3fuGxIhi7iTcT6hXeai
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/st-aloysius-college-jabalpur/reviews...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/st-aloysius-college-jabalpur/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 => "Wed, 09 Apr 2025 13:51:51 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVMKzVHNFlEMTFScy9oR2pGQWYvd1E9PSIsInZhbHVlIjoic0lnU0JRS2ppR3kvUHoxbGhKZEdzcDNxNkVsdCtkZktXM1ZGOHIrV2ZWaU9aNThYcmZ5UkFRRitrRDBSYTk3ZldWWjVHeVB0dzhCV2ZzUkVkT2JUSHNLVEExWjFKNWN0Qzc1QUVMa2hNSjM1dk1qdGd0cnNDNDl3dDhLeERnT3ciLCJtYWMiOiJmYTkzZGVhN2UzM2EyZmFjM2IzYWE5NTJiZWNkZTdlMTFjMmYyMWYzOTIxMDhhNzE5N2JiYzVjOWFiZWQ0NGM0IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 15:51:51 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjVMKzVHNFlEMTFScy9oR2pGQWYvd1E9PSIsInZhbHVlIjoic0lnU0JRS2ppR3kvUHoxbGhKZEdzcDNxNkVsdCtkZktXM1ZGOHIrV2ZWaU9aNThYcmZ5UkFRRitrRDBSYTk3ZldWWjVHe ▶"
    1 => "cs_dev_session=eyJpdiI6IjBGQTNGd09FR1gwTUhMVnVmZjFGemc9PSIsInZhbHVlIjoiUVJjUitjamFCRFdrMDZSRXlsbFlMb0N1NkYyUXlTa0FTT0dRNU9jY2ZQMjhTTWhYUmFCTEkxZHY3MmIrRmNETEgrM0pEcDdYWnhOS1RaSmxtRm1NUlc2YzBtSUJObXNkVjhsbHlCcWVQa2hseHJTUnFLbnNibnFRYzMvQ05YUEQiLCJtYWMiOiIxYzI4ZTExMDQ2YjNhYjIxZTA5ZTkxYWIyODMzM2Q0YjMzNjM1NDdhZWI3M2MyMmNlODIyZDlkMjg5ODJhMDA3IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 15:51:51 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IjBGQTNGd09FR1gwTUhMVnVmZjFGemc9PSIsInZhbHVlIjoiUVJjUitjamFCRFdrMDZSRXlsbFlMb0N1NkYyUXlTa0FTT0dRNU9jY2ZQMjhTTWhYUmFCTEkxZHY3MmIrRmNETEgrM ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVMKzVHNFlEMTFScy9oR2pGQWYvd1E9PSIsInZhbHVlIjoic0lnU0JRS2ppR3kvUHoxbGhKZEdzcDNxNkVsdCtkZktXM1ZGOHIrV2ZWaU9aNThYcmZ5UkFRRitrRDBSYTk3ZldWWjVHeVB0dzhCV2ZzUkVkT2JUSHNLVEExWjFKNWN0Qzc1QUVMa2hNSjM1dk1qdGd0cnNDNDl3dDhLeERnT3ciLCJtYWMiOiJmYTkzZGVhN2UzM2EyZmFjM2IzYWE5NTJiZWNkZTdlMTFjMmYyMWYzOTIxMDhhNzE5N2JiYzVjOWFiZWQ0NGM0IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 15:51:51 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVMKzVHNFlEMTFScy9oR2pGQWYvd1E9PSIsInZhbHVlIjoic0lnU0JRS2ppR3kvUHoxbGhKZEdzcDNxNkVsdCtkZktXM1ZGOHIrV2ZWaU9aNThYcmZ5UkFRRitrRDBSYTk3ZldWWjVHe ▶"
    1 => "cs_dev_session=eyJpdiI6IjBGQTNGd09FR1gwTUhMVnVmZjFGemc9PSIsInZhbHVlIjoiUVJjUitjamFCRFdrMDZSRXlsbFlMb0N1NkYyUXlTa0FTT0dRNU9jY2ZQMjhTTWhYUmFCTEkxZHY3MmIrRmNETEgrM0pEcDdYWnhOS1RaSmxtRm1NUlc2YzBtSUJObXNkVjhsbHlCcWVQa2hseHJTUnFLbnNibnFRYzMvQ05YUEQiLCJtYWMiOiIxYzI4ZTExMDQ2YjNhYjIxZTA5ZTkxYWIyODMzM2Q0YjMzNjM1NDdhZWI3M2MyMmNlODIyZDlkMjg5ODJhMDA3IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 15:51:51 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IjBGQTNGd09FR1gwTUhMVnVmZjFGemc9PSIsInZhbHVlIjoiUVJjUitjamFCRFdrMDZSRXlsbFlMb0N1NkYyUXlTa0FTT0dRNU9jY2ZQMjhTTWhYUmFCTEkxZHY3MmIrRmNETEgrM ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "sobtlRXRE5jKBRbzvv6jh3fuGxIhi7iTcT6hXeai"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/st-aloysius-college-jabalpur/reviews"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 19:21:51	GET	/colleges/st-aloysius-college-jabalpur/reviews	2 18 54 94

1 x Application (96.51%)	417ms
1 x Booting (3.49%)	15.11ms