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

J.C. Bose University of Science and Technology YMCA, Faridabad

Public College

J.C. Bose University of Science and Technology YMCA, Faridabad

Faridabad, Haryana
ESTD 1969

Shortlist

Brochure

J.C. Bose University of Science and Technology YMCA , Faridabad Campus

J.C. Bose University of Science and Technology YMCA , Faridabad convocation

+6 Photos & Videos

Chetna Verma

Updated on 27th February, 2023

J.C. Bose University of Science and Technology YMCA , Faridabad Highlights 2025

J.C. Bose University of Science and Technology Highlights

Particular	Detail
Establishment Year	1969
Type	State University
Approved By	AICTE
Accredited By	NAAC
Recognized by	UGC
Admission Mode	Online
Courses Offered	UG – BTech, BCA, BSc, BBA, BCom, BSW, BA, B.Voc PG -MTech, MSc, MA, MBA
Website	https://jcboseust.ac.in/

J.C. Bose University of Science and Technology YMCA , Faridabad Popular Courses

3.4

Bachelor of Technology (B.Tech)

1 Courses
4 Years
#143/200 NIRF 2022

Total Fees

₹ 3,35,840

Highest Package

Admission 2024 View Brochure

J.C. Bose University of Science and Technology YMCA B.Tech Applications Open

Apply Now

3.4

Master of Business Administration(MBA)

1 Courses
2 Years
#76/100 NIRF 2021

Total Fees

₹ 1,91,860

Highest Package

Admission 2024 View Brochure

J.C. Bose University of Science and Technology YMCA MBA Applications Open

Apply Now

3.4

Master of Computer Application

1 Courses
3 Years

Total Fees

₹ 1,75,575

Highest Package

Admission 2024 View Brochure

J.C. Bose University of Science and Technology YMCA MCA Applications Open

Apply Now

3.4

Master of Technology (M.Tech)

1 Courses
2 Years

Total Fees

₹ 3,09,835

Highest Package

Admission 2024 View Brochure

J.C. Bose University of Science and Technology YMCA M.Tech Applications Open

Apply Now

3.4

Master of Science(M.Sc.)

1 Courses
2 Years

Total Fees

₹ 1,01,575

Highest Package

Admission 2024 View Brochure

J.C. Bose University of Science and Technology YMCA M.Sc Applications Open

Apply Now

View All 7 Courses >

J.C. Bose University of Science and Technology YMCA Rankings

J.C. Bose University of Science and Technology YMCA, Faridabad B.Tech / B.E. Rankings

Publisher	Year	Ranking
NIRF	2022	143 / 200
NIRF	2021	127 / 300
NIRF	2018	151 / 200

J.C. Bose University of Science and Technology YMCA, Faridabad MBA / PGDM Rankings

Publisher	Year	Ranking
NIRF	2021	76 / 100
NIRF	2020	76 / 200

Student's Rating for J.C. Bose University of Science and Technology YMCA , Faridabad

Student Reviews & Ratings

3.4/5

60% Positive reviews

Component Ratings

Faculty Rating

3.3

Internship/Placement Rating

3.1

Infrastructure Rating

3.1

Canteen Rating

4.1

Hostel/Dorm Rating

2.5

College Fest Rating

3.6

Fashion Rating

3.4

Sports Rating

1.8

Write a Review >

Student's Reviews for J.C. Bose University of Science and Technology YMCA , Faridabad

Placement

Faculty

Admissions

28-03-2018

Shul bhat
B.Tech / B.E. Student

3.5 Infrastructure

3.5 Internship/Placement

4.0 Faculty

A Good college!!!

Placement: University provides good placement opportunities to the deserving students with decent packages.
Faculty: The faculty of the college is good and there is fixed number of faculty members in the college.
College: YMCA is a nice college. It is a state university located in Faridabad providing best education to the students under various courses.

Read Full Review

Was this Review Helpful?

28-03-2018

Shul bhat
B.Tech / B.E. Student

3.5 Infrastructure

4.0 Internship/Placement

4.0 Faculty

A Good college!!!

Read Full Review

Was this Review Helpful?

28-03-2018

Shul bhat
B.Tech / B.E. Student

3.5 Infrastructure

3.5 Internship/Placement

4.0 Faculty

A Good college!!!

Faculty: The faculty of the college is good and there is fixed number of faculty members in the college.
Placement: University provides good placement opportunities to the deserving students with decent packages.
College: YMCA is a nice college. It is a state university located in Faridabad providing best education to the students under various courses.

Read Full Review

Was this Review Helpful?

28-03-2018

Shul bhat
B.Tech / B.E. Student

3.5 Infrastructure

4.0 Internship/Placement

4.0 Faculty

A Good college!!!

Read Full Review

Was this Review Helpful?

20-03-2017

Vikas Singh
Electrical engineering Student

1.5 Canteen

1.5 Infrastructure

0.5 Sports

3.5 Events

5.0 Society / Clubs

0.5 Bus/Travel

2.0 PG

2.0 Hostel

2.0 Internship/Placement

0.5 Faculty

1.5 Exam/Admission

The battle of 1st year and initial struggle for new students.

Exam: State / National Entrance Exams
Placement: Good to cs/it and mechanical only.
Faculty: I don’t found any of them good.
College: College is red building Looks like a government building. Which it actually is. Atmosphere is brilliant. Only problem is the attitude and dominating nature of university Faculty. Girls are in large numbers but already committed so boys feel lonely. Clubs and club members are hardworking and real reason for growth of college. Authorities are very poor functioning and are very arrogant. Students are brilliant and intelligent that’s why they are popular and successful pepole in future. College campus is small in size still. We all use the space very efficiently. Academic levels is very hard. It is not so easy to score in examination. Most students suffer backlogs and remain in tensed mood.

Read Full Review

Was this Review Helpful?

12-04-2016

Deepak
B.Tech/B.E Student

3.0 Canteen

3.5 Infrastructure

1.0 Sports

3.5 Events

3.5 Society / Clubs

3.5 Bus/Travel

3.0 Hostel

3.5 Internship/Placement

3.5 Faculty

3.0 Exam/Admission

Exam: Based on School / 12th Class Result
College: YMCA is good college overall. It can be much much better. There are lots of assignments and exams and classes. I dont have time for anything else. We need good marks for placements. Placement is good.

Read Full Review

Was this Review Helpful?

View All 15 Reviews

Contact Details

Address

NH-2, Sector-6, Mathura Road,, Faridabad, Haryana, 121006

College Contact

0129 - 23XXXXXX26

coxxxct@xxxin

Get Contact Details

J.C. Bose University of Science and Technology YMCA , Faridabad

3.4/5 (15 reviews)

Shortlist

Brochure

J.C. Bose University of Science and Technology YMCA, Faridabad

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

Messages1 Timeline Exceptions Views26 Route Queries63 Models144 Mails Gate Session Request

Request history8.3.19562ms5MBGET colleges/{slug}

warninglog[12:23:32] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (16.72ms)time
Application (545ms)time
1 x Application (97.02%)
545ms
1 x Booting (2.98%)
16.72ms

26 templates were rendered

pages.college_v2.indexindex.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.popular_programpopular_program.blade.php#?blade
pages.college_v2.partials.admission_datesadmission_dates.blade.php#?blade
pages.college_v2.partials.cutoffcutoff.blade.php#?blade
pages.college_v2.partials.placementplacement.blade.php#?blade
pages.college_v2.partials.rankingranking.blade.php#?blade
pages.college_v2.partials.course_and_feecourse_and_fee.blade.php#?blade
pages.college_v2.partials.scholarshipscholarship.blade.php#?blade
pages.college_v2.partials.gallerygallery.blade.php#?blade
pages.college_v2.partials.facultyfaculty.blade.php#?blade
pages.college_v2.partials.awards_v2awards_v2.blade.php#?blade
pages.college_v2.partials.alumnialumni.blade.php#?blade
pages.college_v2.partials.partnershippartnership.blade.php#?blade
pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
pages.college_v2.partials.deatailed_review_sectiondeatailed_review_section.blade.php#?blade
pages.college_v2.partials.contactcontact.blade.php#?blade
pages.college_v2.partials.right_side_clgright_side_clg.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}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfile
namespace
prefix
where
as: cp.collegeinfo
file: app/Http/Controllers/CollegeController.php:39-713

63 statements were executed, 12 of which were duplicates, 51 unique. Show only duplicated408ms

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/ymca-university-of-science-and-technology-faridabad' and `status` = 1 limit 1

9.31msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/ymca-university-of-science-and-technology-faridabad 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 `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'ymca-university-of-science-and-technology-faridabad') limit 1

1.18msdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: ymca-university-of-science-and-technology-faridabad
Backtrace	15. app/Http/Controllers/CollegeController.php:52 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 `institutes`.*, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `campus_videos` where `institutes`.`id` = `campus_videos`.`institute_id` limit 1) as `campus_video_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` = 'info') as `institute_faqs_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institute_insights` where `institutes`.`id` = `institute_insights`.`institute_id` and `status` = 'Y' and `institute_insights`.`deleted_at` is null) as `insights_count`, (select count(*) from `institute_toc` where `institutes`.`id` = `institute_toc`.`institute_id` and `institute_toc`.`deleted_at` is null) as `toc_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 `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 `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institute_impressions_data` where `institutes`.`id` = `institute_impressions_data`.`institute_id` and `location` = 'college_profile' and `date` > '2025-03-07 12:23:32') as `institute_impressions_data_count`, (select count(*) from `requests_new` where `institutes`.`id` = `requests_new`.`institute_id`) as `requests_new_count`, (select count(*) from `student_status` where `institutes`.`id` = `student_status`.`institute_id` and `status` = 'admitted') as `student_status_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `ics_link_2` = 'ymca-university-of-science-and-technology-faridabad' and `status` = 'Active' limit 1

163msdb_collegesearchCollegeController.php#239

Bindings	0: info 1: Y 2: 43 3: 4: 5: 0 6: 7: 0 8: Alumni 9: 10: college_profile 11: 2025-03-07 12:23:32 12: admitted 13: ymca-university-of-science-and-technology-faridabad 14: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:239 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 `institute_courses`.*, (select count(*) from `institute_courses` as `laravel_reserved_2` where `institute_courses`.`course_type` = `laravel_reserved_2`.`course_type` and `institute_id` = 270) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (270) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6

4.66msdb_collegesearchCollegeController.php#239

Bindings	0: 270 1: active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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 `sub_course` where `sub_course`.`id` in (1, 2, 3, 8, 10, 237)

1.11msdb_collegesearchCollegeController.php#239

Bindings	0: 1 1: 2 2: 3 3: 8 4: 10 5: 237
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (1, 2, 3, 8, 10, 25)

910μsdb_collegesearchCollegeController.php#239

Bindings	0: 1 1: 2 2: 3 3: 8 4: 10 5: 25
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `ranks` where `ranks`.`course_type` in (1, 2, 8, 10, 25) and `institute_id` = 270 order by `year` desc

1.07msdb_collegesearchCollegeController.php#239

Bindings	0: 270
Backtrace	30. app/Http/Controllers/CollegeController.php:239 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (253, 1041, 18167, 18169, 18170, 18171) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

1.03msdb_collegesearchCollegeController.php#239

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

select `institute_id`, `name`, `first_page`, `title`, `doc_type` from `document` where `document`.`institute_id` in (270)

1.65msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
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_courses` where `institute_courses`.`institute_id` in (270) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc

1.27msdb_collegesearchCollegeController.php#239

Bindings	0: active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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_insights` where `institute_insights`.`institute_id` in (270) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.5msdb_collegesearchCollegeController.php#239

Bindings	0: Y
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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_toc` where `institute_toc`.`institute_id` in (270) and `institute_toc`.`deleted_at` is null order by `id` desc

30.96msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
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 `images` where `images`.`institute_id` in (270) 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

4.36msdb_collegesearchCollegeController.php#239

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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 `institute_id`, `video`, `description` from `video_verdict` where `video_verdict`.`institute_id` in (270) and `status` = '1' order by `id` desc

820μsdb_collegesearchCollegeController.php#239

Bindings	0: 1
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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 `campus_videos` where `campus_videos`.`institute_id` in (270) order by `id` desc limit 1

880μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
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 `states` where `states`.`StateID` in (75)

1.39msdb_collegesearchCollegeController.php#239

Bindings	0: 75
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `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 `user_reviews`.`institute_id` in (270) and `status` = 'Active' limit 10

1.25msdb_collegesearchCollegeController.php#239

Bindings	0: Active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (3323, 9410, 10348, 13695, 30899, 44809, 44825, 62456, 65588, 70933) order by `vote_up` desc

830μsdb_collegesearchCollegeController.php#239

Backtrace

25. app/Http/Controllers/CollegeController.php:239
26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (270) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc

690μsdb_collegesearchCollegeController.php#239

Backtrace

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

950μsdb_collegesearchCollegeController.php#239

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

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (270) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc, `year` desc

950μsdb_collegesearchCollegeController.php#239

Backtrace

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

1.19msdb_collegesearchCollegeController.php#239

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

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

980μsdb_collegesearchCollegeController.php#239

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:239 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 session_user_id , institute_id , date_format(ADDTIME(last_modified, '5:30'),'%D %M, %Y') as last_modifi from `admin_reporting` where `admin_reporting`.`institute_id` in (270) order by `ID` desc limit 1

720μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
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 `admin` where `admin`.`ID` in (241)

980μsdb_collegesearchCollegeController.php#239

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

select * from `writers_profile` where `writers_profile`.`admin_id` in (241)

1.27msdb_collegesearchCollegeController.php#239

Bindings	0: 241
Backtrace	30. app/Http/Controllers/CollegeController.php:239 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (270)

1.22msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
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` from `institute_toc` where `institute_id` = 270 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc

20.66msdb_collegesearchCollegeController.php#246

Bindings	0: 270 1: admission
Backtrace	14. app/Http/Controllers/CollegeController.php:246 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 `id` from `institute_courses` where `institute_id` = 270

1.3msdb_collegesearchCollegeController.php#248

Bindings	0: 270
Backtrace	13. app/Http/Controllers/CollegeController.php:248 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 270 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc

24.34msdb_collegesearchCollegeController.php#250

Bindings	0: 270 1: cutoff
Backtrace	14. app/Http/Controllers/CollegeController.php:250 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 `cutoff_new_shagun_json` where `institute_course_id` in (253, 1041, 18167, 18169, 18170, 18171, 18173) and (`round_id` = 1 and `status` = 1)

11.52msdb_collegesearchCollegeController.php#268

Bindings	0: 253 1: 1041 2: 18167 3: 18169 4: 18170 5: 18171 6: 18173 7: 1 8: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:268 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 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) limit 12

8.22msdb_collegesearchCollegeController.php#297

Backtrace

10. app/Http/Controllers/CollegeController.php:297
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 `id` from `institute_courses` where `institute_id` = 270

1.63msdb_collegesearchCollegeController.php#316

Bindings	0: 270
Backtrace	13. app/Http/Controllers/CollegeController.php:316 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `h_package`, `l_package`, `a_package`, `ic`.`id`, `ic`.`course_type`, `ct`.`alternate_name` as `ctype`, `year_placement` from `placement_course` left join `institute_courses` as `ic` on `ic`.`id` = `placement_course`.`institute_course_id` left join `course_type` as `ct` on `ct`.`id` = `ic`.`course_type` where `institute_course_id` in (253, 1041, 18167, 18169, 18170, 18171, 18173) and `placement_course`.`deleted_at` is null order by `year_placement` desc

800μsdb_collegesearchCollegeController.php#325

Bindings	0: 253 1: 1041 2: 18167 3: 18169 4: 18170 5: 18171 6: 18173
Backtrace	14. app/Http/Controllers/CollegeController.php:325 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 `id`, `title`, `desc` from `institute_toc` where `institute_id` = 270 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc

20.51msdb_collegesearchCollegeController.php#342

Bindings	0: 270 1: placement
Backtrace	14. app/Http/Controllers/CollegeController.php:342 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 `id`, `title`, `desc` from `institute_insights` where `institute_id` = 270 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

3.77msdb_collegesearchCollegeController.php#345

Bindings	0: 270 1: key_highlights_placement 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:345 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 `id`, `title`, `desc` from `institute_toc` where `institute_id` = 270 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc

20.45msdb_collegesearchCollegeController.php#351

Bindings	0: 270 1: ranking
Backtrace	14. app/Http/Controllers/CollegeController.php:351 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` = 270

2.52msdb_collegesearchCollegeController.php#388

Bindings	0: 270
Backtrace	14. app/Http/Controllers/CollegeController.php:388 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 `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` = 270 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

4.39msdb_collegesearchCollegeController.php#415

Bindings	0: Active 1: 270 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:415 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 `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (44809, 44825) order by `vote_up` desc

1.92msdb_collegesearchCollegeController.php#415

Backtrace

19. app/Http/Controllers/CollegeController.php:415
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 `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` = 270 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.96msdb_collegesearchCollegeController.php#433

Bindings	0: Active 1: 270 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:433 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 `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (44809, 44825) order by `vote_up` desc

2.31msdb_collegesearchCollegeController.php#433

Backtrace

19. app/Http/Controllers/CollegeController.php:433
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 `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` = 270 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

4.36msdb_collegesearchCollegeController.php#451

Bindings	0: Active 1: 270 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:451 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 `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (13695, 30899) order by `vote_up` desc

630μsdb_collegesearchCollegeController.php#451

Backtrace

19. app/Http/Controllers/CollegeController.php:451
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 `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 270 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

640μsdb_collegesearchCollegeController.php#455

Bindings	0: 270 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:455 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/ymca-university-of-science-and-technology-faridabad' and `status` = 'Y' limit 1

2.37msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/ymca-university-of-science-and-technology-faridabad 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:549 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_faqs` where `institute_faqs`.`institute_id` = 270 and `institute_faqs`.`institute_id` is not null

1.63msdb_collegesearchCollegeController.php#613

Bindings	0: 270
Backtrace	19. app/Http/Controllers/CollegeController.php:613 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

780μ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:631 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `id`, `is_sunstone` from `inst_campaign_bharat_2022` where `institute_id` = 270 limit 1

1.93msdb_collegesearchCollegeController.php#637

Bindings	0: 270
Backtrace	15. app/Http/Controllers/CollegeController.php:637 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 `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` = 270 group by `course_type`.`id`

11.37msdb_collegesearchCollegeController.php#658

Bindings	0: 270
Backtrace	14. app/Http/Controllers/CollegeController.php:658 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` = 270 and date(`start_date`) <= '2025-04-07' and date(`end_date`) >= '2025-04-07'

2.84msdb_collegesearchCollegeController.php#670

Bindings	0: 270 1: 2025-04-07 2: 2025-04-07
Backtrace	14. app/Http/Controllers/CollegeController.php:670 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 `institute_courses` where `institute_courses`.`institute_id` = 270 and `institute_courses`.`institute_id` is not null limit 1

2.32msdb_collegesearchCollegeController.php#672

Bindings	0: 270
Backtrace	21. app/Http/Controllers/CollegeController.php:672 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 (161)

1.26msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:672
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 (161)

1.38msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:672
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 (161)

1.05msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:693
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 (161)

910μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:694
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-info%' and `module_link_id` = 270 and `expiry_date` > '2025-04-07 12:23:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

3.79msdb_collegesearchhelpers.php#1695

Bindings	0: 270 1: 2025-04-07 12:23:32
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 ('161') and `expiry_date` > '2025-04-07 12:23:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.92msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 161 2: 2025-04-07 12:23:32
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', '3', '8', '10', '25') and `expiry_date` > '2025-04-07 12:23:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

860μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 2 3: 3 4: 8 5: 10 6: 25 7: 2025-04-07 12:23:32
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 `user_reviews` where `user_reviews`.`institute_id` = 270 and `user_reviews`.`institute_id` is not null

2.11msdb_collegesearchhero_section.blade.php#27

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

1.79msdb_collegesearchnavbar.blade.php#31

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

1.53msdb_collegesearchawards_v2.blade.php#2

Bindings	0: 270
Backtrace	19. view::pages.college_v2.partials.awards_v2:2 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' and `brandings`.`deleted_at` is null

800μsdb_collegesearchhelpers.php#970

Bindings	0: cp
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: 53UserReview.php#?
App\Models\InstituteCourse: 27InstituteCourse.php#?
App\Models\Rank: 15Rank.php#?
App\Models\UserReviewsVoteUp: 15UserReviewsVoteUp.php#?
App\Models\CourseType: 10CourseType.php#?
App\Models\Image: 6Image.php#?
App\Models\SubCourse: 5SubCourse.php#?
App\Models\Criteria: 4Criteria.php#?
App\Models\Institute: 2Institute.php#?
App\Models\Document: 1Document.php#?
App\Models\InstituteToc: 1InstituteToc.php#?
App\Models\State: 1State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\InstituteProfile: 1InstituteProfile.php#?

_token: NRiKi3cUQSBlNRYEtiOiS9IB0bMNtHMeNRQbruSU
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/ymca-university-of-science-and-techn...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/ymca-university-of-science-and-technology-faridabad

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 => "Mon, 07 Apr 2025 06:53:32 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdZb3ZNNTdVa1pKTkFCUGdkY1ZydFE9PSIsInZhbHVlIjoicjJ1RjE1VkhibGZTRzRsVEhoWEVoWlZ6d0xOc0ZXM1hseE1RNFQyQmxFa2o1TTFlLzkyeHJFMDFaYTNxM0lrcEYvekxnWHBKbkdlMXhHUTI2bS9LSll3L0oxWTZoaGFrVFFYTlJ5Yk8vSnBEbG13VDl2NWRVVnN0N2E0RW56UjgiLCJtYWMiOiI4OTU3OGYyMDIwNjJkM2U0MTQ4MmMxZDNlYTAyOThiZmRlYTM5YWM3YzYyMTZhMWNmYWUwNGQ3YWZiMGEyYmU3IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 08:53:33 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkdZb3ZNNTdVa1pKTkFCUGdkY1ZydFE9PSIsInZhbHVlIjoicjJ1RjE1VkhibGZTRzRsVEhoWEVoWlZ6d0xOc0ZXM1hseE1RNFQyQmxFa2o1TTFlLzkyeHJFMDFaYTNxM0lrcEYvekxnW ▶"
    1 => "cs_dev_session=eyJpdiI6IjNoTFlJRmJSSXRnZ3JvcHNRNk9nT1E9PSIsInZhbHVlIjoibEozZ3oxdG8zb1dMK2VrTDdhWlZiMWxLNHJZMS8va1l4cUVqUmQ5OU5lMC9qNkhRUVIrUHdmQ0w3Zm44NXZZMjdXaHR4cFd5cUZZQkY3Q1dhMTduV0FXbEkvZFg5WFo0bDErd1F5TCtwQkpmRXVMNll5eUlrTUpSYmxtV0k2Y24iLCJtYWMiOiIyZjdhZjYzMWNiN2EzNjZkNjNiOGY2ZmExMjk5MmZkNjMyMDAzZjVhN2MwN2M1YmY2ZTBjOWU4OTM1ZjU4NGIxIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 08:53:33 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IjNoTFlJRmJSSXRnZ3JvcHNRNk9nT1E9PSIsInZhbHVlIjoibEozZ3oxdG8zb1dMK2VrTDdhWlZiMWxLNHJZMS8va1l4cUVqUmQ5OU5lMC9qNkhRUVIrUHdmQ0w3Zm44NXZZMjdXa ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdZb3ZNNTdVa1pKTkFCUGdkY1ZydFE9PSIsInZhbHVlIjoicjJ1RjE1VkhibGZTRzRsVEhoWEVoWlZ6d0xOc0ZXM1hseE1RNFQyQmxFa2o1TTFlLzkyeHJFMDFaYTNxM0lrcEYvekxnWHBKbkdlMXhHUTI2bS9LSll3L0oxWTZoaGFrVFFYTlJ5Yk8vSnBEbG13VDl2NWRVVnN0N2E0RW56UjgiLCJtYWMiOiI4OTU3OGYyMDIwNjJkM2U0MTQ4MmMxZDNlYTAyOThiZmRlYTM5YWM3YzYyMTZhMWNmYWUwNGQ3YWZiMGEyYmU3IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 08:53:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkdZb3ZNNTdVa1pKTkFCUGdkY1ZydFE9PSIsInZhbHVlIjoicjJ1RjE1VkhibGZTRzRsVEhoWEVoWlZ6d0xOc0ZXM1hseE1RNFQyQmxFa2o1TTFlLzkyeHJFMDFaYTNxM0lrcEYvekxnW ▶"
    1 => "cs_dev_session=eyJpdiI6IjNoTFlJRmJSSXRnZ3JvcHNRNk9nT1E9PSIsInZhbHVlIjoibEozZ3oxdG8zb1dMK2VrTDdhWlZiMWxLNHJZMS8va1l4cUVqUmQ5OU5lMC9qNkhRUVIrUHdmQ0w3Zm44NXZZMjdXaHR4cFd5cUZZQkY3Q1dhMTduV0FXbEkvZFg5WFo0bDErd1F5TCtwQkpmRXVMNll5eUlrTUpSYmxtV0k2Y24iLCJtYWMiOiIyZjdhZjYzMWNiN2EzNjZkNjNiOGY2ZmExMjk5MmZkNjMyMDAzZjVhN2MwN2M1YmY2ZTBjOWU4OTM1ZjU4NGIxIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 08:53:33 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IjNoTFlJRmJSSXRnZ3JvcHNRNk9nT1E9PSIsInZhbHVlIjoibEozZ3oxdG8zb1dMK2VrTDdhWlZiMWxLNHJZMS8va1l4cUVqUmQ5OU5lMC9qNkhRUVIrUHdmQ0w3Zm44NXZZMjdXa ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "NRiKi3cUQSBlNRYEtiOiS9IB0bMNtHMeNRQbruSU"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/ymca-university-of-science-and-technology-faridabad"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 12:23:33	GET	/colleges/ymca-university-of-science-and-technology-faridabad	1 26 63 144

1 x Application (97.02%)	545ms
1 x Booting (2.98%)	16.72ms