Auroras Engineering College (AURB) Reviews: Campus, Placement, Admission Reviews by Students | CollegeSearch
college search  Private College

Auroras Engineering College (AURB), Hyderabad Reviews

  • college search Hyderabad, Telangana
  • college search ESTD 1998
Auroras Engineering College (AURB) , Hyderabad  Campus
Auroras Engineering College (AURB) , Hyderabad  Campus
Auroras Engineering College (AURB), Hyderabad Campus
Auroras Engineering College (AURB) , Hyderabad Campus
+4 Photos & Videos

Student's Rating for Auroras Engineering College (AURB) , Hyderabad

Student Reviews & Ratings
Auroras Engineering College (AURB)

4.3/5

100% Positive reviews
Component Ratings

Faculty Rating

college search   2.5

Internship/Placement Rating

college search   3.5

Infrastructure Rating

college search   3.5

Canteen Rating

college search   3.5

Hostel/Dorm Rating

college search   2.3

College Fest Rating

college search   3.5

Fashion Rating

college search   2

Sports Rating

college search   2.5

Write a Review >

Student's Reviews for Auroras Engineering College (AURB), Hyderabad

Courses

Tags

Overall
Placement
Faculty

Sort by

college search   4 Overall

20-07-2018
A

Anonymous
Student

college search  5.0 Canteen

college search  3.5 Infrastructure

college search  0.5 Sports

college search  3.5 Events

college search  0.5 PG

college search  3.0 Hostel

college search  2.5 Faculty

Placement: Last year and this year they did not provided much placement only three companies were came for placements
Faculty: Faculties are good. Scholarship is not yet came in applied in August last year only but still they did not give the scholarship
College: College is good only for studies but not for extra curricular activities always torturing to study full day on Saturdays
Exam: Based on School / 12th Class Result

Read Full Review

college search   5 Overall

05-06-2018
A

Annonmyus
B.Tech / B.E. Student

college search  3.5 Canteen

college search  3.5 Infrastructure

college search  4.0 Sports

college search  1.5 Faculty

College Description

Placement: There are also no jobs were presnet there
Faculty: It’s better that we should not talk about them they were not well experienced and the Btech pass outs were teaching us.
College: This college is in the outskirts of the Hyderabad and for taking here I have cleared the state level MCET examinations and the subject of the graduation of mine was Civil Engineering and from 2011 to 2015 I have studied here but there were many issues which I have faced in this college which I will discuss further.
Exam: State / National Entrance Exams

Read Full Review

college search   4 Overall

16-04-2018
S

Swetha b
B.Tech / B.E. Student

college search  2.5 Canteen

college search  3.5 Infrastructure

college search  3.0 Sports

college search  3.5 Events

college search  3.0 Society / Clubs

college search  1.5 PG

college search  1.5 Hostel

college search  3.5 Internship/Placement

college search  3.5 Faculty

One of the best colleges

Placement: Ample companies come for placements.
Faculty: Ramesh sir. One of the best teachers available in the electrical department.
College: best college with the best infrastructure. Has experienced tutors unlike mtech freshers. Good equipment for practicals.
Exam: State / National Entrance Exams

Read Full Review

college search   4 Overall

23-03-2018
S

Sanya kalsi
Student

Best university in terms of education

Read Full Review

college search   4 Overall

16-04-2018
S

Swetha b
B.Tech / B.E. Student

college search  2.5 Canteen

college search  3.5 Infrastructure

college search  3.0 Sports

college search  3.5 Events

college search  3.0 Society / Clubs

college search  1.5 PG

college search  1.5 Hostel

college search  3.5 Internship/Placement

college search  3.5 Faculty

One of the best colleges

Placement: Ample companies come for placements.

Read Full Review

college search   4 Overall

20-07-2018
A

Anonymous
Student

college search  5.0 Canteen

college search  3.5 Infrastructure

college search  0.5 Sports

college search  3.5 Events

college search  0.5 PG

college search  3.0 Hostel

college search  2.5 Faculty

Faculty: Faculties are good. Scholarship is not yet came in applied in August last year only but still they did not give the scholarship

Read Full Review

college search   5 Overall

05-06-2018
A

Annonmyus
B.Tech / B.E. Student

college search  3.5 Canteen

college search  3.5 Infrastructure

college search  4.0 Sports

college search  1.5 Faculty

College Description

Faculty: It’s better that we should not talk about them they were not well experienced and the Btech pass outs were teaching us.

Read Full Review

college search   4 Overall

16-04-2018
S

Swetha b
B.Tech / B.E. Student

college search  2.5 Canteen

college search  3.5 Infrastructure

college search  3.0 Sports

college search  3.5 Events

college search  3.0 Society / Clubs

college search  1.5 PG

college search  1.5 Hostel

college search  3.5 Internship/Placement

college search  3.5 Faculty

One of the best colleges

Faculty: Ramesh sir. One of the best teachers available in the electrical department.

Read Full Review

Contact Details

Address

Bhuvanagiri, Nalonda Dist, Hyderabad, Telangana, 508116

College Contact

8685 - 20XXXXXX62

Email

inxxxfo@xxxin

Get Contact Details

Auroras Engineering College (AURB) , Hyderabad

college search 4.3/5 (4 reviews)
Request history8.3.13PHP Version415msRequest Duration5MBMemory UsageGET colleges/{slug}/{tab}Route
  • warninglog[03:25:56] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
  • warninglog[03:25:57] LOG.warning: parse_url(): Passing null to parameter #1 ($url) of type string is deprecate...
  • Booting (9.22ms)time
  • Application (406ms)time
  • 1 x Application (97.78%)
    406ms
    1 x Booting (2.22%)
    9.22ms
    17 templates were rendered
    • pages.college_v2.reviewsreviews.blade.php#?blade
    • pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
    • pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
    • pages.college_v2.partials.navbarnavbar.blade.php#?blade
    • pages.college_v2.partials.latest_updateslatest_updates.blade.php#?blade
    • pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
    • pages.college_v2.partials.deatailed_review_section-reviewdeatailed_review_section-review.blade.php#?blade
    • vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
    • vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
    • vendor.pagination.bootstrap-5bootstrap-5.blade.php#?blade
    • pages.college_v2.partials.contactcontact.blade.php#?blade
    • pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
    • layouts.webweb.blade.php#?blade
    • partials.headhead.blade.php#?blade
    • partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
    • partials.footerfooter.blade.php#?blade
    • pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
    uri
    GET colleges/{slug}/{tab}
    middleware
    web, crossAppSync, softRedirects, AB
    domain
    www.dev.collegesearch.in
    controller
    App\Http\Controllers\CollegeController@collegeProfileTab
    namespace
    prefix
    where
    as
    cp.collegetabs
    file
    app/Http/Controllers/CollegeController.php:715-2899
    59 statements were executed, 20 of which were duplicates, 39 unique. Show only duplicated232ms
    • 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/auroras-engineering-college-aurb/reviews' and `status` = 1 limit 1
      10.57msdb_collegesearchCacheService.php#460
      Bindings
      • 0: /colleges/auroras-engineering-college-aurb/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` = 'auroras-engineering-college-aurb' and `status` = 'Active' limit 1
      1.43msdb_collegesearchCacheService.php#492
      Bindings
      • 0: auroras-engineering-college-aurb
      • 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` = 'auroras-engineering-college-aurb') limit 1
      1.57msdb_collegesearchCollegeController.php#723
      Bindings
      • 0: Active
      • 1: auroras-engineering-college-aurb
      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.3msdb_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` = 12 and `institute_courses`.`institute_id` is not null
      1.39msdb_collegesearchCollegeController.php#771
      Bindings
      • 0: 12
      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 (12)
      120msdb_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 (98)
      2.7msdb_collegesearchCollegeController.php#807
      Bindings
      • 0: 98
      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 (12) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2
      1.38msdb_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` = 12 and `images`.`deleted_at` is null limit 1
      1.44msdb_collegesearchInstitute.php#210
      Bindings
      • 0: 1
      • 1: 12
      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` = 12
      2.82msdb_collegesearchCollegeController.php#837
      Bindings
      • 0: 12
      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 (12) and `status` = 'active' order by `course_type` asc limit 5
      1.2msdb_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.13msdb_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 (12) 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
      1msdb_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` = 12
      8.75msdb_collegesearchCollegeController.php#1430
      Bindings
      • 0: 12
      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 = 12 and user_reviews.course_type > 0 group by user_reviews.course_type order by num desc limit 0,5
      1.37msdb_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 = 12 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
      2.8msdb_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 (2289,807,2619,128,86,1665,68,2862,1954,139,2136,1725,877,2610,3102,2693,12,2066,5198,5,5111,5961,930,2740,5781,3,60,2615,6066)
      3.3msdb_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` = 12 group by `course_type`.`id`
      10.96msdb_collegesearchCollegeController.php#1483
      Bindings
      • 0: 12
      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` = 12
      1.64msdb_collegesearchCollegeController.php#1511
      Bindings
      • 0: 12
      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` = 12
      10.9msdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: Active
      • 1: 12
      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` = 12 order by `added_date` desc limit 10 offset 0
      1.11msdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: Active
      • 1: 12
      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 (44489, 46246, 50753, 57616) order by `vote_up` desc
      810μ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 (1, 7)
      690μsdb_collegesearchCollegeController.php#1547
      Bindings
      • 0: 1
      • 1: 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` = 12 and `intern_rating` != '' and `placement_desc` != ''
      900μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: Active
      • 1: 12
      • 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` = 12 and `intern_rating` != '' and `placement_desc` != '' order by `added_date` desc limit 10 offset 0
      980μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: Active
      • 1: 12
      • 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 (46246) order by `vote_up` desc
      890μ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 (1)
      610μsdb_collegesearchCollegeController.php#1576
      Bindings
      • 0: 1
      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` = 12 and `teacher_rating` != '' and `teacher_desc` != ''
      940μsdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: Active
      • 1: 12
      • 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` = 12 and `teacher_rating` != '' and `teacher_desc` != '' order by `added_date` desc limit 10 offset 0
      1.17msdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: Active
      • 1: 12
      • 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 (46246, 50753, 57616) order by `vote_up` desc
      770μsdb_collegesearchCollegeController.php#1606
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:1606
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `course_name`, `id` from `course_type` where `course_type`.`id` in (1)
      960μsdb_collegesearchCollegeController.php#1606
      Bindings
      • 0: 1
      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` = 12 and `admission_rating` != '' and `admission_desc` != ''
      1.02msdb_collegesearchCollegeController.php#1636
      Bindings
      • 0: Active
      • 1: 12
      • 2: 
      • 3: 
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:1636
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 12 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      1.11msdb_collegesearchCollegeController.php#1648
      Bindings
      • 0: 12
      • 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` = 12 and date(`start_date`) <= '2024-12-31' and date(`end_date`) >= '2024-12-31'
      1.56msdb_collegesearchCollegeController.php#1661
      Bindings
      • 0: 12
      • 1: 2024-12-31
      • 2: 2024-12-31
      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` = 12 and date(`start_date`) <= '2024-12-31' and date(`end_date`) >= '2024-12-31'
      1.66msdb_collegesearchCollegeController.php#2682
      Bindings
      • 0: 12
      • 1: 2024-12-31
      • 2: 2024-12-31
      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/auroras-engineering-college-aurb/reviews' and `status` = 'Y' limit 1
      1.31msdb_collegesearchCollegeController.php#2693
      Bindings
      • 0: colleges/auroras-engineering-college-aurb/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` = 12 and `images`.`deleted_at` is null limit 1
      840μsdb_collegesearchInstitute.php#224
      Bindings
      • 0: 1
      • 1: 12
      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 (30)
      1msdb_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 (30)
      960μ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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (36)
      760μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:2715
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (36)
      1.28msdb_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 (99)
      950μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:2715
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (99)
      1.42msdb_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 (116)
      1.17msdb_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 (116)
      1.16msdb_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` = 12 and `expiry_date` > '2024-12-31 03:25:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      2.12msdb_collegesearchhelpers.php#1695
      Bindings
      • 0: 12
      • 1: 2024-12-31 03:25:57
      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 ('30', '36', '99', '116') and `expiry_date` > '2024-12-31 03:25:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      1.05msdb_collegesearchhelpers.php#1712
      Bindings
      • 0: %exam%
      • 1: 30
      • 2: 36
      • 3: 99
      • 4: 116
      • 5: 2024-12-31 03:25:57
      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', '2', '8', '10') and `expiry_date` > '2024-12-31 03:25:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      1.58msdb_collegesearchhelpers.php#1726
      Bindings
      • 0: %course%
      • 1: 1
      • 2: 2
      • 3: 8
      • 4: 10
      • 5: 2024-12-31 03:25:57
      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` = 12 and `admin_reporting`.`institute_id` is not null
      1.45msdb_collegesearchCollegeController.php#2749
      Bindings
      • 0: 12
      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` = 12 and `institute_faqs`.`institute_id` is not null
      930μsdb_collegesearchCollegeController.php#2802
      Bindings
      • 0: 12
      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` = 12 and `ranks`.`institute_id` is not null
      840μsdb_collegesearchCollegeController.php#2835
      Bindings
      • 0: 12
      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
      850μ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` = 12 and `collaboration`.`institute_id` is not null
      950μsdb_collegesearchCollegeController.php#2867
      Bindings
      • 0: 12
      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` = 12 and `institute_courses`.`institute_id` is not null limit 1
      1.6msdb_collegesearchCollegeController.php#2877
      Bindings
      • 0: 12
      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 (30)
      820μsdb_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 (30)
      590μ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` = 12 and `user_reviews`.`institute_id` is not null
      1.32msdb_collegesearchhero_section.blade.php#27
      Bindings
      • 0: 12
      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` = 12 and `user_reviews`.`institute_id` is not null
      1.36msdb_collegesearchnavbar.blade.php#31
      Bindings
      • 0: 12
      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
      820μ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
    80UserReview.php#?
    App\Models\InstituteCourse
    13InstituteCourse.php#?
    App\Models\Criteria
    10Criteria.php#?
    App\Models\CourseType
    5CourseType.php#?
    App\Models\Image
    4Image.php#?
    App\Models\UserReviewsVoteUp
    3UserReviewsVoteUp.php#?
    App\Models\Collaboration
    3Collaboration.php#?
    App\Models\Institute
    2Institute.php#?
    App\Models\State
    1State.php#?
        _token
        56ONnHnYQQNU6yoPUPRtThzThJOFjdhlyjfI4NFf
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/auroras-engineering-college-aurb/rev...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /colleges/auroras-engineering-college-aurb/reviews
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "www.dev.collegesearch.in" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 30 Dec 2024 21:55:57 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJNOXAxbmFQMU0zSDdyMWdodVNERkE9PSIsInZhbHVlIjoiaUFralZwZHJqZnI5N0ZpOWQ1emY0cTZ4ZitSY2NNb08wcXpNZmxTYjQrVWRlSXZuQ2ZCRVNHak5CTUtwSU1mSXBDRlgyazhqdjJMOURwYlhpeUhyYlBuWFJpdE5yay9aZ2FxVUR1NWY3eXZCVHZ1a2ZCdWptblNZT204RHppVGwiLCJtYWMiOiJmM2U1ODY5M2YyOTI3YThiNDcxMDk0YzNhY2UyNTJiZmYwMmE1NWJmNDZkZWVlZThmMDljMjY1M2UyODUyMWM3IiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 23:55:57 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkJNOXAxbmFQMU0zSDdyMWdodVNERkE9PSIsInZhbHVlIjoiaUFralZwZHJqZnI5N0ZpOWQ1emY0cTZ4ZitSY2NNb08wcXpNZmxTYjQrVWRlSXZuQ2ZCRVNHak5CTUtwSU1mSXBDRlgya" 1 => "cs_dev_session=eyJpdiI6InFYdmQxSHo2a2I1TE5vMlBDRzMzSkE9PSIsInZhbHVlIjoiUjN2M01LcEE2R3YxUzhkV0NYNzhwbnR2dExTL2J1WU4zOXVqRWpKelZGR2krUHIxSi84MlBYUXp6VnhnNnJ5T2tsbEEzWUtLdmRjUFNKSUgvc3hPYVhHTnhPalFzckswVG5TVkZFeGdJUGlLckNKVGtrak50TkEwQm9tSks2K0giLCJtYWMiOiJjZjI3NWI1ZTljMzRhMGVkMGZlZDc1NDE1YTkzMDdjMWYxZTJjYzFlMGRkZjlhYTA0NmEzNzAxMDY4N2JkMmFhIiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 23:55:57 GMT; Max-Age=7200; path=/; httponly; samesite=laxcs_dev_session=eyJpdiI6InFYdmQxSHo2a2I1TE5vMlBDRzMzSkE9PSIsInZhbHVlIjoiUjN2M01LcEE2R3YxUzhkV0NYNzhwbnR2dExTL2J1WU4zOXVqRWpKelZGR2krUHIxSi84MlBYUXp6VnhnNnJ5T2tsb" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJNOXAxbmFQMU0zSDdyMWdodVNERkE9PSIsInZhbHVlIjoiaUFralZwZHJqZnI5N0ZpOWQ1emY0cTZ4ZitSY2NNb08wcXpNZmxTYjQrVWRlSXZuQ2ZCRVNHak5CTUtwSU1mSXBDRlgyazhqdjJMOURwYlhpeUhyYlBuWFJpdE5yay9aZ2FxVUR1NWY3eXZCVHZ1a2ZCdWptblNZT204RHppVGwiLCJtYWMiOiJmM2U1ODY5M2YyOTI3YThiNDcxMDk0YzNhY2UyNTJiZmYwMmE1NWJmNDZkZWVlZThmMDljMjY1M2UyODUyMWM3IiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 23:55:57 GMT; path=/XSRF-TOKEN=eyJpdiI6IkJNOXAxbmFQMU0zSDdyMWdodVNERkE9PSIsInZhbHVlIjoiaUFralZwZHJqZnI5N0ZpOWQ1emY0cTZ4ZitSY2NNb08wcXpNZmxTYjQrVWRlSXZuQ2ZCRVNHak5CTUtwSU1mSXBDRlgya" 1 => "cs_dev_session=eyJpdiI6InFYdmQxSHo2a2I1TE5vMlBDRzMzSkE9PSIsInZhbHVlIjoiUjN2M01LcEE2R3YxUzhkV0NYNzhwbnR2dExTL2J1WU4zOXVqRWpKelZGR2krUHIxSi84MlBYUXp6VnhnNnJ5T2tsbEEzWUtLdmRjUFNKSUgvc3hPYVhHTnhPalFzckswVG5TVkZFeGdJUGlLckNKVGtrak50TkEwQm9tSks2K0giLCJtYWMiOiJjZjI3NWI1ZTljMzRhMGVkMGZlZDc1NDE1YTkzMDdjMWYxZTJjYzFlMGRkZjlhYTA0NmEzNzAxMDY4N2JkMmFhIiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 23:55:57 GMT; path=/; httponlycs_dev_session=eyJpdiI6InFYdmQxSHo2a2I1TE5vMlBDRzMzSkE9PSIsInZhbHVlIjoiUjN2M01LcEE2R3YxUzhkV0NYNzhwbnR2dExTL2J1WU4zOXVqRWpKelZGR2krUHIxSi84MlBYUXp6VnhnNnJ5T2tsb" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "56ONnHnYQQNU6yoPUPRtThzThJOFjdhlyjfI4NFf" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/auroras-engineering-college-aurb/reviews" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12024-12-31 03:25:57GET/colleges/auroras-engineering-college-aurb/reviews21759121