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

Private College

JSS, Noida

Q: "Is JSS Academy of Technical Education a private college?"

"Yes, JSS Academy of Technical Education is a private college."

Q: "Which entrance is accepted for admission in B. Tech in JSS Academy of Technical Education?"

"JSS Academy of Technical Education seeks admission in their B. Tech program based on JEE Mains score."

Q: "What is the highest salary offered at JSS Academy of Technical Education?"

"The highest salary offered at JSS Academy of Technical Education is INR 27.83 LPA."

Q: "Who are top recruiters of JSS Academy of Technical Education?"

"Top recruiters of JSS Academy of Technical Education areCS, Tech Mahindra, Infosys, Adobe, Accenture, Amazon, BYJUs, etc."

Q: "Does JSS Academy of Technical Education falls in NIRF Ranking?"

"Yes, JSS Academy of Technical Education has made it to the 250-300 band of NIRF Ranking in engineering category."

Noida, Uttar Pradesh
ESTD 1998

Shortlist

Brochure

+5 Photos & Videos

Rachna Jha

Updated on 5th August, 2022

JSS , Noida Highlights 2025

About JSS Noida

JSS Academy of Technical Education (JSSATE) or JSS Noida is said to have been founded in 1998 by the JSS Mahavidyapeetha in Noida. It is also affiliated to the Dr APJ Abdul Kalam Technical University and approved by the All India Council for Technical Education (AICTE). It has been ranked in the 251-300 category of engineering institutes by the NIRF and also accredited by the National Board of Accreditation.

JSS Noida offers multiple courses such as engineering, pharmacy, computer science, and business. JSS Noida admits students based on their respective scores in entrance exams such as JEE MAIN, GATE, CAT, and MAT. The students selected on the basis of their scores are then called in for counseling by JSS Noida. The students who are interested in joining JSS Noida this year, they can check their admission details here.

JSS Noida has a good track record of helping students in getting jobs, with the JSS Noida Highest Package being around 33.8 lakhs per year as revealed by the JSS Noida Placement Report. Many companies like Accenture, TCS Ninja, New Gen, JSW, Jackson, CRTD Technologies Pvt. Ltd, Hexaware, Byju’s, IBM, Jubilant Food Works, and Samsung came to JSS Noida to hire students.

JSS Noida also gives scholarships to its students. JSS Noida offers scholarships like Swanath Scholarship Scheme, Saksham Scholarship Scheme, and Pragati Scholarship Scheme to its students.

JSS Noida offers a range of B.Tech programs with affordable fee structures. For regular students, the first-year fees for JSS Noida B.Tech stands at INR 1.38 lakhs, while the students who are opting for lateral entry pay INR 1.35 lakhs for the first year.

These competitive fees make quality education accessible to aspiring engineers. Moreover, with a JSS Noida Cutoff ranges from 49,718 to 1,10,370, JSS Noida ensures that deserving students have the opportunity to embark on a rewarding academic journey.

JSS Academy of Technical Education (JSSATE) Highlights

Particular	Detail
Type \| Establishment Year	Private \| 1984
Affiliation	Dr APJ Abdul Kalam Technical University
Approved By	AICTE
Accredited By	NBA
Admission mode	Online & Offline
Admission Criteria	Entrance Based
Accepted Entrances	JEE Main, UPCET, UCET
Courses Offered	UG - B. Tech PG - M. Tech, MBA
Top Recruiters	TCS, Tech Mahindra, Infosys, Adobe, Accenture, Amazon, BYJUs, Birla Soft
Facilities	WiFi, Hostel, Sports, Cafeteria, Library
Website	https://jssaten.ac.in/

JSS Academy of Technical Education (JSSATE) Courses

JSS Academy of Technical Education (JSSATE) offers engineering and management courses at undergraduate and postgraduate levels. The JSS Noida Courses are B. Tech, M. Tech and MBA.

The engineering courses are offered in several specializations such as Computer Science, Information Technology, Civil, Electrical & Electronics, Electronics & Communication, Electrical & Mechanical. MBA is offered in four specializations, namely, Human Resource, Marketing, Financial and Information Technology.

The courses offered by JSS Noida are mentioned along with their eligibility criteria and duration. The students who are interested in knowing more about the JSS Noida Fee Structure the students it is with all the needed details related to JSS Noida Fee Structure

Courses	Eligibility	Courses	Selection Criteria	Fees
B. Tech	10+2 in PCM A valid JEE Main score	4 years	Based on the merit list of JEE-Main + UPTAC Counseling	Regular students: INR 1.38 L (1st year fees) For lateral entry: INR 1.35L (1st - year fees)
M. Tech	B. Tech/BE A valid UCET score	2 years	Based on the GATE/ GPAT/ CUET merit score followed by GD and PI.	INR 1.34L (1st- year fees)
MBA	Graduation in any discipline A valid UCET score	2 years	Merit score from CAT/MAT/CUET followed by UPTAC counseling	INR 1.38 L (1st-year fees)
MCA	Graduate with mathematics as a major	2 Years	Based on the merit score from the CUET PG exam.	INR 1.36 L (1st-year fees)

JSS Noida Cut-Off

JSS Cutoff 2023 for all programs will become available soon. Cutoffs for the same are said to be released solely on the basis of rank/marks that have been secured by the student in the entrance examination. The JSS Academy of Technical Education Cutoff 2023 for the students from the open category is as follows:

JSS Noida Important Dates

Events	Dates
JEE Mains
Round 1
Online Choice Filling and Locking	September 15- September 17, 2023
Seat Allotment	September 18, 2023
Payment of Seat Confirmation	September 18- September 20, 2023
Online Willingness (Freeze/Float)	September 18- September 20, 2023
CUET UG
Round 1
Online Choice Filling and Locking	September 16- September 18, 2023
Seat Allotment	September 19, 2023
Payment of Seat Confirmation	September 19- September 21, 2023
Online Willingness (Freeze/Float)	September 19- September 21, 2023
CUET PG
Round 1
Events	Dates
Online Choice Filling and Locking	September 16- September 18, 2023
Seat Allotment	September 19, 2023
Payment of Seat Confirmation	September 19- September 21, 2023
Online Willingness (Freeze/Float)	September 19- September 21, 2023

JSS Noida Hostel Fees

Here’s a detailed breakdown of the JSS Noida Hostel Fees for female students. The table provides insights into JSS Noida Hostel Fees including aspects like including hostel charges, mess charges, security deposit, and the total cost, helping students make informed decisions about JSS Noida Hostel Fees before taking admission into JSS Noida..

Hostel Charges	Mess Charges	Security Deposit	Hostel Type	Total
96,000	33,500	3,000	ISH (For Boys)	132,500
60,000	33,500	3,000	Boys Hostel	96,500

Hostel Type	Hostel Charges	Mess Charges	Security Deposit	Total
Girls Hostel	INR 60,000	INR 32,500	INR 3,000	INR 95,500 - INR 1.25 l
Girls Hostel with AC	INR 90,000	INR 32,500	INR 3,000	INR 1.25 l - INR 1.5 l

Also read
JSS Noida Admissions	JSS Noida Cutoff	JSS Noida Fees	JSS Noida Placements
JSS Noida BTech Fees	JSS Noida Average Package	JSS Noida Cutoff JEE Mains	JSS Noida Hostel Fees

JSS , Noida Popular Courses

3.2

Bachelor of Technology (B.Tech)

1 Courses
4 Years
#251/300 NIRF 2021

Total Fees

₹ 3,26,800

Highest Package

Admission 2024 Request Brochure

JSS B.Tech Applications Open

Apply Now

3.2

Master of Business Administration(MBA)

2 Courses
2 Years

Total Fees

₹ 1,63,400

Highest Package

Admission 2024 Request Brochure

JSS MBA Applications Open

Apply Now

3.2

Bachelor of Business Administration (BBA)

1 Courses
3 Years

Total Fees

₹ 2,25,000

Highest Package

Admission 2024 Request Brochure

JSS BBA Applications Open

Apply Now

3.2

Master of Computer Application

1 Courses
3 Years

Total Fees

₹ 2,45,100

Highest Package

Admission 2024 Request Brochure

JSS MCA Applications Open

Apply Now

3.2

Master of Technology (M.Tech)

1 Courses
2 Years

Total Fees

₹ 1,63,400

Highest Package

Admission 2024 Request Brochure

JSS M.Tech Applications Open

Apply Now

3.2

Bachelor of Computer Application (BCA)

1 Courses
3 Years

Total Fees

₹ 1,95,000

Highest Package

Admission 2024 Request Brochure

JSS BCA Applications Open

Apply Now

View All 7 Courses >

JSS , Noida Admission 2024

Direct Admission To JSS Noida

If the student needs to get Direct Admission To JSS Noida for 2023, for courses like B. Tech, B. Tech lateral entry, B. Pharma, M. Tech, MCA, and MBA, the student needs to have at least 80% overall marks in your 12th-grade exams along with a good rank in the specific entrance exams for the courses offered by JSS Noida and get Direct Admission To JSS Noida. To make the right choices for your career, the student need to attend JSS Noida’s Counseling Advisors’ sessions.

JSS Noida Admissions

Admissions in JSS Noida are based on the last qualifying exam and entrance. Accepted entrance for B. Tech is JEE Mains and for MBA and M. Tech candidates shall have a valid UCET score.

How To Apply?

Step 1 - JSS Noida accepts the application form is accepted both online & offline mode.

Step 2 - Candidates must register themselves on the official website of JSS Noida to apply for JSS Noida Admission.

Step 3 - Candidates must fill in all the details such as personal, educational, etc and submit their entrance score along with it.

Step 4 - Process the payment of application fee through Debit card/Credit Card/ Net Banking.

Step 5 - Keep a photocopy of the JSS Noida application form for future reference.

Step 6 - Make sure to send a complete application form, otherwise it can lead to cancellation of the application.

Step 7 - Shortlisted candidates will be contacted for counselling and personal interview through mail or message.

Admission Details for All Details >

JSS , Noida Cutoff

JSS Noida JEE Main Cutoff 2023 UPTAC

JSS Academy of Technical Education JEE Main Cutoff 2023 for the BTech has finally been published via the Uttar Pradesh Technical Admission Counselling (UPTAC). All the candidates who will meet the minimum JEE Main Cutoff Rank published by the college will get admission to BTech. This table below shows the detailed JSS JEE Main cutoff Round 4 2023 for the open category:

Program	Quota	Opening Rank	Closing Rank
Civil Engineering (Shift I)	All India	596407.00	596407.00
Computer Science and Engineering (Shift I)	Home State	77195.00	77764.00
Electrical & Electronics Engineering (Shift I)	All India	303432.00	305267.00
Electrical Engineering (Shift I)	All India	412341.00	437231.00
Electronics and Communication Engineering (Shift I)	All India	150685.00	152918.00

JSS Academy of Technical Education MCA Cutoff 2023 Update

The UPTAC counseling has recently unveiled the JSS Cutoff MCA 2023. Admissions to the MCA program of JSS Noida is said to be determined by CUET PG scores and subsequent UPTAC counseling. Below are the detailed cutoff ranks for MCA:

Program	Quota	Opening Rank	Closing Rank
Master of Computer Applications (Shift I)	All India	1507	2185
Master of Computer Applications (Shift I)	Home State	3558	4304

The table here provides the specifics of the JSS Cutoff for the Master of Computer Applications program of JSS Noida categorized by different quotas - All India and Home State.

View All Cut-Off >

JSS , Noida Placement Details

JSS Academy of Technical Education (JSSATE) Placements

JSS Noida helps students find good jobs. In 2023, many companies offered jobs to students there. The Highest Package of JSS Noida was offered by C2F0 and paid Rs. 33.8 LPA. Byju’s, IBM, Jubilant Food Works, and Samsung are some other companies that hire students from JSS Noida. JSS Noida Placement statistics of the college are mentioned below:

Particulars	Placement statistics 2023
Total Companies Visited	88
Total Offers made	678
Highest salary package	INR. 33.8 LPA
Top Recruiters	Accenture, TCS Ninja, New Gen, JSW, Jackson, CRTD Technologies Pvt. Ltd, Hexaware

Course Wise Highest Salary

Course Wise Avg Salary

JSS , Noida Rankings

JSS Noida Rankings

In 2020, JSS Noida was ranked between 201st to 250th according to NIRF. In Uttar Pradesh, JSS Noida has secured the 2nd position, and at the national level, JSS Noida was ranked 20th by Education World Magazine.

Additionally, JSS Noida received a 4.5-star ranking from the Ministry of Education’s Innovation Cell. JSS Noida got a Golden Star Ranking of 1.4.5. Here’s the information for JSS Noida Ranking in presented in a table:

Ranking Body	Ranking/Title	Course	Year
NIRF	251	B.Tech	2022
Outlook	86	B.Tech	2021
The Times Of India	123	B.Tech	2019

JSS, Noida B.Tech / B.E. Rankings

Publisher	Year	Ranking
NIRF	2021	251 / 300

JSS Details

JSS Noida Seats Intake

This data offers a concise overview of seat intake across several academic programs offered by JSS Noida. So the intake in JSS Noida BTech is around 60-180 seats, JSS Noida MTech stands around 9-18 seats, JSS Noida MCA seats are around 60 seats, while JSS Noida MBA is around 30-60 seats.

These figures will provide essential guidance for prospective students as JSS Noida will consider their educational choices and opportunities.

Course	Seat Intake
BTech	60-180
MTech	9-18
MCA	60
MBA	30-60

JSS , Noida Scholarships Details

JSS Noida Scholarship

To get scholarships, students should go to the official website www.scholarship.gov.in, and fill out a form. They should also give the necessary documents to the college office. Students who are willing to learn more about JSS Noida. Here’s a table with all the info for JSS Noida Scholarship.

Name of the Scholarship	Eligibility	Scholarship Amount
Swanath Scholarship Scheme	One of the scholarships available under JSS Noida Scholarships is for those students who lost their parents due to Covid-19 or whose parents were in the Armed forces and died in action. To be eligible, the family’s yearly income should be below Rs. 8 lakhs.	Rs. 50,000 per annum
Pragati Scholarship Scheme	JSS Noida Scholarships includes scholarships for girls who come from families with only two girls can apply for this scholarship. To be eligible, the family’s yearly income should be below Rs. 8 lakhs.	Rs. 50,000
Saksham Scholarship Scheme	JSS Noida Scholarships includes one for those specially-abled with a disability of more than 40% are eligible to apply for this JSS Noida Scholarship. Family income should be less than Rs.8L per annum.	Rs. 50,000

Additionally, the JSS Noida provides scholarships under JSS Noida Scholarships like the UP Post-matric Scholarship, Prime Minister Scholarship Scheme for JK Students, and Post Graduate Scholarship for Single Girl Child.

JSS Infrastructure Details

JSS College Noida Campus Life

JSS Noida has all the things the student would need on its Campus. JSS College Noida has a big library with over 100,000 books in different subjects, a gym, and a place to eat. JSS Noida also have computer rooms, a big room for events, places to play sports both inside and outside, an ATM, and Wi-Fi all over the campus. Plus, JSS Noida have doctors available 24/7 and buses to get around.

If the students need a place to stay, JSS Noida has dorms for both boys and girls. Besides all that, JSS Noida helps students with their careers. JSS Noida has programs for culture and tech stuff, and do things to help the community. JSS College Noida also have a team to stop bullying and groups to help students with problems or concerns.

Library

Computer Lab

Auditorium

Gym

Lab

Medical

Transport

Cafeteria

Hostel

Student's Rating for JSS , Noida

Student Reviews & Ratings

3.2/5

42% Positive reviews

Component Ratings

Faculty Rating

2.6

Internship/Placement Rating

2.6

Infrastructure Rating

3.1

Canteen Rating

3.1

Hostel/Dorm Rating

2.7

College Fest Rating

2.9

Fashion Rating

2.6

Sports Rating

2.6

Write a Review >

Student's Reviews for JSS , Noida

Placement

Faculty

Admissions

20-03-2017

HARSHIT VERMA
Student

2.0 Canteen

3.0 Infrastructure

2.0 Sports

3.0 Events

4.5 Society / Clubs

4.5 Bus/Travel

4.0 PG

4.5 Hostel

4.0 Internship/Placement

1.5 Faculty

1.5 Exam/Admission

Sharing the experience of the college

Placement: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.
Faculty: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.
College: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.
Exam: State / National Entrance Exams

Read Full Review

Was this Review Helpful?

21-05-2018

Gautam rishi prakash
B.Tech / B.E. Student

4.0 Canteen

4.0 Infrastructure

4.0 Events

3.5 Society / Clubs

3.5 Faculty

Batch 2012 to 2016

Faculty: The faculty of this college is on the top rank and today I am studying in IIT with there support.
Placement: I wanted to study further that is why I never went for the job.
College: This is a Private college in the city which is affiliated with the Dr. APJ Abdul Kalam University and there is an Examination known as UPSEE which I have given to take admission here and the annual fee of the course of mine was Rs 88,000 per year. The course of mine started in the year 2012 and ended in the year 2016.
Exam: College’s Internal Written Exam

Read Full Review

Was this Review Helpful?

10-04-2018

Shivangi Tomer
MBA / PGDM Student

2.5 Canteen

3.0 Infrastructure

4.5 Sports

3.5 Events

3.0 Society / Clubs

3.0 Faculty

In 1st year

Faculty: The faculties were not good nor bad they were average for us
Placement: There were no placements in the college.
College: This is the college of technical education but they also provide the courses for various others degrees and right now I am in the 1st year so i haven’t much explored the college and for taking admission here I have cleared the State level entrance exam UPSEE.
Exam: State / National Entrance Exams

Read Full Review

Was this Review Helpful?

20-03-2017

HARSHIT VERMA
Student

2.0 Canteen

3.0 Infrastructure

2.0 Sports

3.0 Events

4.5 Society / Clubs

4.5 Bus/Travel

4.0 PG

4.5 Hostel

4.0 Internship/Placement

1.5 Faculty

1.5 Exam/Admission

Sharing the experience of the college

Exam: State / National Entrance Exams
Placement: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.
Faculty: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.
College: It is a semi private college located in sector 62, noida. The location is quite good than other colleges. It us one of the best uptu colleges. The atmosphere here is amisble. A lot of it companies are situated here and being a computer science student its quite good for me.

Read Full Review

Was this Review Helpful?

12-04-2016

Anonymous
B.Tech/B.E Student

1.5 Canteen

1.5 Infrastructure

1.5 Sports

1.5 Events

1.5 Society / Clubs

2.0 Bus/Travel

2.0 PG

1.5 Hostel

2.0 Internship/Placement

1.5 Faculty

3.0 Exam/Admission

Exam: State / National Entrance Exams
Faculty: signal processing teacher ; d way of handling students
College: Boring :(

Read Full Review

Was this Review Helpful?

View All 14 Reviews

JSS, Noida Frequently Asked Questions

Is JSS Academy of Technical Education a private college?

Yes, JSS Academy of Technical Education is a private college.

Which entrance is accepted for admission in B. Tech in JSS Academy of Technical Education?

JSS Academy of Technical Education seeks admission in their B. Tech program based on JEE Mains score.

What is the highest salary offered at JSS Academy of Technical Education?

The highest salary offered at JSS Academy of Technical Education is INR 27.83 LPA.

Who are top recruiters of JSS Academy of Technical Education?

Top recruiters of JSS Academy of Technical Education areCS, Tech Mahindra, Infosys, Adobe, Accenture, Amazon, BYJUs, etc.

Does JSS Academy of Technical Education falls in NIRF Ranking?

Yes, JSS Academy of Technical Education has made it to the 250-300 band of NIRF Ranking in engineering category.

Gallery

5 Images

Other

Show All Images & Videos >

Contact Details

Address

C-20/1, Sector - 62, Noida, Uttar Pradesh, 201301

College Contact

0120 - 24XXXXXX15

jsxxxda@xxxom

Get Contact Details

JSS , Noida

3.2/5 (14 reviews)

Shortlist

Brochure

View Contact Details

3.2/5

14 Ratings

Enquire College

Brochure

Retry Again >

Successfully Logged in

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 Queries72 Models153 Mails Gate Session Request

Request history8.3.19743ms6MBGET colleges/{slug}

warninglog[14:19:09] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (7.13ms)time
Application (736ms)time
1 x Application (99.04%)
736ms
1 x Booting (0.96%)
7.13ms

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

72 statements were executed, 16 of which were duplicates, 56 unique. Show only duplicated477ms

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/jss-academy-of-technical-education-noida' and `status` = 1 limit 1

10.85msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/jss-academy-of-technical-education-noida 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` = 'jss-academy-of-technical-education-noida' and `status` = 'Active' limit 1

1.34msdb_collegesearchCacheService.php#492

Bindings	0: jss-academy-of-technical-education-noida 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 `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'jss-academy-of-technical-education-noida') limit 1

1.52msdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: jss-academy-of-technical-education-noida
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-08 14:19:09') 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` = 'jss-academy-of-technical-education-noida' and `status` = 'Active' limit 1

251msdb_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-08 14:19:09 12: admitted 13: jss-academy-of-technical-education-noida 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` = 963) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (963) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6

1.54msdb_collegesearchCollegeController.php#239

Bindings	0: 963 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, 7, 8, 10, 13)

1.15msdb_collegesearchCollegeController.php#239

Bindings	0: 1 1: 2 2: 7 3: 8 4: 10 5: 13
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, 7, 8, 10, 13)

1.64msdb_collegesearchCollegeController.php#239

Bindings	0: 1 1: 2 2: 7 3: 8 4: 10 5: 13
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, 7, 8, 10, 13) and `institute_id` = 963 order by `year` desc

1.22msdb_collegesearchCollegeController.php#239

Bindings	0: 963
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 (896, 2140, 7881, 28651, 37411, 37412) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

1.68msdb_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 (963)

970μ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 `institute_courses` where `institute_courses`.`institute_id` in (963) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc

1.62msdb_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 (963) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

650μsdb_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 (963) and `institute_toc`.`deleted_at` is null order by `id` desc

19.56msdb_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 (963) 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

1.22msdb_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 (963) and `status` = '1' order by `id` desc

2.53msdb_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 (963) order by `id` desc limit 1

1.09msdb_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 (95)

1.4msdb_collegesearchCollegeController.php#239

Bindings	0: 95
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 (963) and `status` = 'Active' limit 10

6.34msdb_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 (3396, 8108, 13677, 13686, 13688, 13694, 24875, 30652, 44231, 44612) order by `vote_up` desc

840μ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 (963) 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

960μ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)

890μsdb_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 `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (963) 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

560μ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)

1.45msdb_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 * from `institute_courses` where `institute_courses`.`institute_id` in (963) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

1.4msdb_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 (963) order by `ID` desc limit 1

1.43msdb_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 (189)

1.39msdb_collegesearchCollegeController.php#239

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

1msdb_collegesearchCollegeController.php#239

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

1.14msdb_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` = 963 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc

18.79msdb_collegesearchCollegeController.php#246

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

1.07msdb_collegesearchCollegeController.php#248

Bindings	0: 963
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` = 963 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc

19.92msdb_collegesearchCollegeController.php#250

Bindings	0: 963 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 (896, 2140, 7881, 28651, 28652, 37411, 37412) and (`round_id` = 1 and `status` = 1)

3.93msdb_collegesearchCollegeController.php#268

Bindings	0: 896 1: 2140 2: 7881 3: 28651 4: 28652 5: 37411 6: 37412 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

2.69msdb_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` = 963

1.58msdb_collegesearchCollegeController.php#316

Bindings	0: 963
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 (896, 2140, 7881, 28651, 28652, 37411, 37412) and `placement_course`.`deleted_at` is null order by `year_placement` desc

1.54msdb_collegesearchCollegeController.php#325

Bindings	0: 896 1: 2140 2: 7881 3: 28651 4: 28652 5: 37411 6: 37412
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` = 963 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc

19.27msdb_collegesearchCollegeController.php#342

Bindings	0: 963 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` = 963 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.09msdb_collegesearchCollegeController.php#345

Bindings	0: 963 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` = 963 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc

19.44msdb_collegesearchCollegeController.php#351

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

1.74msdb_collegesearchCollegeController.php#388

Bindings	0: 963
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` = 963 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.15msdb_collegesearchCollegeController.php#415

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

2.19msdb_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` = 963 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.69msdb_collegesearchCollegeController.php#433

Bindings	0: Active 1: 963 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 (45860, 49646) order by `vote_up` desc

1.49msdb_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` = 963 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

940μsdb_collegesearchCollegeController.php#451

Bindings	0: Active 1: 963 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 (13686, 30652) order by `vote_up` desc

970μ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` = 963 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

880μsdb_collegesearchCollegeController.php#455

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

3.77msdb_collegesearchCollegeController.php#477

Bindings	0: 963
Backtrace	15. app/Http/Controllers/CollegeController.php:477 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` = 963 and `images`.`deleted_at` is null limit 1

1.35msdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 963
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:527 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 `name` from `images` where `is_desktop` = 1 and `institute_id` = 963 and `images`.`deleted_at` is null limit 1

1.58msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 963
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:536 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 * from `metatags` where `PageID` = 'colleges/jss-academy-of-technical-education-noida' and `status` = 'Y' limit 1

1.96msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/jss-academy-of-technical-education-noida 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` = 963 and `institute_faqs`.`institute_id` is not null

1.95msdb_collegesearchCollegeController.php#613

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

1.73msdb_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` = 963 limit 1

2.18msdb_collegesearchCollegeController.php#637

Bindings	0: 963
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` = 963 group by `course_type`.`id`

13.45msdb_collegesearchCollegeController.php#658

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

1.62msdb_collegesearchCollegeController.php#670

Bindings	0: 963 1: 2025-04-08 2: 2025-04-08
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` = 963 and `institute_courses`.`institute_id` is not null limit 1

1.55msdb_collegesearchCollegeController.php#672

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

2.9msdb_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 (14)

850μsdb_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`, `institute_name_2`, `inst_city`, `inst_state` from `institutes` where `id` = '476'

970μsdb_collegesearchCollegeController.php#686

Bindings	0: 476
Backtrace	14. app/Http/Controllers/CollegeController.php:686 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`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (14)

2.23msdb_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 (14)

1.28msdb_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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (51)

610μsdb_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 (51)

2.91msdb_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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2002)

1.11msdb_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 (2002)

850μ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` = 963 and `expiry_date` > '2025-04-08 14:19:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.59msdb_collegesearchhelpers.php#1695

Bindings	0: 963 1: 2025-04-08 14:19:10
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 ('14', '51', '2002') and `expiry_date` > '2025-04-08 14:19:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.46msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 14 2: 51 3: 2002 4: 2025-04-08 14:19:10
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', '7', '8', '10', '13') and `expiry_date` > '2025-04-08 14:19:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

2.23msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 2 3: 7 4: 8 5: 10 6: 13 7: 2025-04-08 14:19:10
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` = 963 and `user_reviews`.`institute_id` is not null

3.66msdb_collegesearchhero_section.blade.php#27

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

1.55msdb_collegesearchnavbar.blade.php#31

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

1.33msdb_collegesearchawards_v2.blade.php#2

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

1.69msdb_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: 50UserReview.php#?
App\Models\InstituteCourse: 27InstituteCourse.php#?
App\Models\UserReviewsVoteUp: 15UserReviewsVoteUp.php#?
App\Models\InstituteToc: 13InstituteToc.php#?
App\Models\CourseType: 9CourseType.php#?
App\Models\Criteria: 8Criteria.php#?
App\Models\SubCourse: 6SubCourse.php#?
App\Models\Image: 5Image.php#?
App\Models\InstituteFaqs: 5InstituteFaqs.php#?
App\Models\Institute: 3Institute.php#?
App\Models\Rank: 3Rank.php#?
App\Models\Collaboration: 3Collaboration.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#?
App\Models\MetaTag: 1MetaTag.php#?

_token: CZtniho2nFYHNjuoAPNDU6K82qv6cz8vNZ8L32HR
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/jss-academy-of-technical-education-n...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/jss-academy-of-technical-education-noida

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "www.new.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 08 Apr 2025 08:49:10 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZPdkE1d0dna0Q2WTdmN0RNVEZyWWc9PSIsInZhbHVlIjoiUHdNN1VlcTQ2WFR5VTY0RHhkYjFUMFVFTlg4UFhhZm9mREUwWDc1a2ZFK1hxSVlCKytuL2RQdUNsYm03ZENKS0UyT2J5ckZmRWhJbys4eGRDdDk5eXRVckg4TGFYbTFZbnRSdkJza2VDb2FlVC96K2RDRkphOEs4UGlhdTJZTnIiLCJtYWMiOiJlZDk3ZGU5MjM3OWRjYTE0MjY4YmE3MzczOTZiY2Q0NTNlZmU4ZjUwNDZkYTZhZWNhYzNhZGFlMzA1ZTFlNTBkIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:49:10 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InZPdkE1d0dna0Q2WTdmN0RNVEZyWWc9PSIsInZhbHVlIjoiUHdNN1VlcTQ2WFR5VTY0RHhkYjFUMFVFTlg4UFhhZm9mREUwWDc1a2ZFK1hxSVlCKytuL2RQdUNsYm03ZENKS0UyT2J5c ▶"
    1 => "cs_dev_session=eyJpdiI6ImQyaVlvNDdHbTEyQzJ3bXN4UVdnT2c9PSIsInZhbHVlIjoiSjkyRXFuWGZHUUMwajBDSHhtUkNSN1gwOTBpc1FJbExENlo1ZUcrbS9GY2RtL2Y5S2lOaW1SSHRIai9yUEM0RGxZTHhvWHZmQzF1Z0pxZkxza2Zxdmd1MlVTb1lWZ1hTdEFNaWlna2JrTEJMTmhyNy8rL3R1T05qYmFlbFIxankiLCJtYWMiOiIwZWJiYmI4ODYzMzhkYTY2MTU5YjA4YmU2NTRlZjRmYjUxNjBmNWNiMDU0YzEwMDczMWMxMmY4MjQ1NTA2YjI5IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:49:10 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6ImQyaVlvNDdHbTEyQzJ3bXN4UVdnT2c9PSIsInZhbHVlIjoiSjkyRXFuWGZHUUMwajBDSHhtUkNSN1gwOTBpc1FJbExENlo1ZUcrbS9GY2RtL2Y5S2lOaW1SSHRIai9yUEM0RGxZT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZPdkE1d0dna0Q2WTdmN0RNVEZyWWc9PSIsInZhbHVlIjoiUHdNN1VlcTQ2WFR5VTY0RHhkYjFUMFVFTlg4UFhhZm9mREUwWDc1a2ZFK1hxSVlCKytuL2RQdUNsYm03ZENKS0UyT2J5ckZmRWhJbys4eGRDdDk5eXRVckg4TGFYbTFZbnRSdkJza2VDb2FlVC96K2RDRkphOEs4UGlhdTJZTnIiLCJtYWMiOiJlZDk3ZGU5MjM3OWRjYTE0MjY4YmE3MzczOTZiY2Q0NTNlZmU4ZjUwNDZkYTZhZWNhYzNhZGFlMzA1ZTFlNTBkIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:49:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InZPdkE1d0dna0Q2WTdmN0RNVEZyWWc9PSIsInZhbHVlIjoiUHdNN1VlcTQ2WFR5VTY0RHhkYjFUMFVFTlg4UFhhZm9mREUwWDc1a2ZFK1hxSVlCKytuL2RQdUNsYm03ZENKS0UyT2J5c ▶"
    1 => "cs_dev_session=eyJpdiI6ImQyaVlvNDdHbTEyQzJ3bXN4UVdnT2c9PSIsInZhbHVlIjoiSjkyRXFuWGZHUUMwajBDSHhtUkNSN1gwOTBpc1FJbExENlo1ZUcrbS9GY2RtL2Y5S2lOaW1SSHRIai9yUEM0RGxZTHhvWHZmQzF1Z0pxZkxza2Zxdmd1MlVTb1lWZ1hTdEFNaWlna2JrTEJMTmhyNy8rL3R1T05qYmFlbFIxankiLCJtYWMiOiIwZWJiYmI4ODYzMzhkYTY2MTU5YjA4YmU2NTRlZjRmYjUxNjBmNWNiMDU0YzEwMDczMWMxMmY4MjQ1NTA2YjI5IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:49:10 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6ImQyaVlvNDdHbTEyQzJ3bXN4UVdnT2c9PSIsInZhbHVlIjoiSjkyRXFuWGZHUUMwajBDSHhtUkNSN1gwOTBpc1FJbExENlo1ZUcrbS9GY2RtL2Y5S2lOaW1SSHRIai9yUEM0RGxZT ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "CZtniho2nFYHNjuoAPNDU6K82qv6cz8vNZ8L32HR"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/jss-academy-of-technical-education-noida"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 14:19:10	GET	/colleges/jss-academy-of-technical-education-noida	1 26 72 153

1 x Application (99.04%)	736ms
1 x Booting (0.96%)	7.13ms