Last Updated at

Table of Content

UPES, Dehradun Highlights

UPES: What’s New?

  • CBSE Results 2025 Class 12 Check Online
  • The last date to apply for UPES Dehradun's 2025 MBA and BDes/MDes programs is January 21, 2025. The entrance exam for these programs will be held from January 23 to 25, 2025

About UPES 

Established through the UPES Act, 2003, of the State Legislature of Uttarakhand, UPES is a top-ranked, UGC-recognised, private university. Internationally, UPES is ranked 801-850 by the QS World University Rankings 2025 under the 'World University' category. As per the National Institutional Ranking Framework (NIRF) 2024, the Ministry of Education, Government of India, UPES has been ranked 46, with a rank of 42 in engineering, 41 in management and a rank of 28 in Law. In addition to this, the university has been ranked the No. 1 private university in academic reputation in India by the QS World University Rankings 2024 and is among the top 3% of universities in the world. UPES has also been accredited by NAAC with a grade ‘A’ and has received 5 stars on Employability (placements), by globally acclaimed QS Rating. The university has had 90%+ placements over the last five years. Forty-six (46) faculty members of UPES are among the world’s top 2% researchers as per Stanford University list.
UPES offers graduate and postgraduate programs through its seven schools: School of Advanced Engineering, School of Computer Science, School of Business, School of Law, School of Design, School of Health Sciences & Technology, and School of Liberal Studies & Media with 15000+ students and 1000+ faculty and staff members. 

Latest Update - UPES Dehradun admission session 2025 application process and exam date. Know more

UPES Highlights 2025

UPES Dehradun is enriched with salient features that are highlighted below:

UPES Dehradun Highlights

Established

2003

University Type

 Private University

Top Accreditations

 IACBE, NBA, and with an A Grade by NAAC
 

Recognized by

UGC, Bar Council of India, and Pharmacy Council of India
 

Entrance Exam accepted

National Level Entrance Exam -  CAT/ MAT/ CMAT/ GMAT/ NMAT/ JEE Main/ CLAT AIR/ UCEED

UPES Dehradun Entrance Exam  -  UPESEAT/ ULSAT/ UPES/ UPESMET/ UPESDAT

Courses Offered

UG, PG & Ph.D

Application Mode

Online, Offline in Dehradun

Affiliation

Global University Systems

Rankings

1 by QS Asia University Rankings 2024 under the Private University category
- 46 by NIRF 2024 for the 'University' Category
- 1 by QS Asia University Rankings under the Private University category
- 3 by QS Asia University Rankings under the Private University in India category
- 9 by QS Asia University Rankings under the University Overall category

UPES Dehradun Application form

INR 1750

Top Recruiters

Microsoft, Accenture, PwC, Deloitte, KPMG, Accenture, Dell, Maruti Suzuki, Hyundai, Shell, Reliance Industries, Samsung Research, L&T Infotech, and many others

Total Faculty and Staff

1000+

Total Student Actual Strength 

17000+

Total Campus Area

44 Acres

UPES: Reasons to Join

There are a plethora of reasons that make UPES Dehradun a leading educational institute and below listed are a few of them:

  1. 150 + specialized programs aimed at making specialists
  2. 94% Placement Record
  3. 17000+ Students 120+ Patents 2200+ Research Articles
  4. Esteemed faculty from IITs, IISc and Ivy League universities 
  5. Unmatched global exposure
  6. Industry alliances with IBM, Microsoft, Xebia, L&T, Tata Power, CISCO & more, offering placements and industry expertise
  7. Highest Package secured by an alumnus – 1.3Cr
  8. Lifetime Placement Assistance
  9. 45 faculty among the world’s top 2% researchers, as per the Stanford University list.

The university offers various programs at the undergraduate, postgraduate, and doctorate level that too under several specializations. Below mentioned are the academic schools of UPES Dehradun:

Academic Schools of UPES Dehradun

School of Advance EngineeringSchool of Computer Science
School of LawSchool of Design
School of BusinessSchool of Health Sciences and Technology
School of Liberal Studies and MediaDoctoral Programs
UPES Online 

UPES Courses and Fees

Let's have a look at the UPES fees and courses available:

Courses

Duration

Bachelor of Technology (B.Tech)

4 years

Integrated B.Tech. + M.B.A.

5 years

B.Tech CSE

4 years

B.tech (Hons.) Computer Science Engineering

4 years

Master of Business Administration (MBA)

2 years

MBA (KPMG)

2 years

Bachelor Of Legislative Law (LLB)

3 years

Bachelor of Technology + Bachelor of Laws(Hons)

6 years

Bachelor of Business Administration (BBA)

3 years

BA (Public Policy and Administration)

3 years

Integrated BBA+MBA

4 years

Integrated (B.Com (Hons)) - (MBA)

4 years

BBA in Event Mgmt & PR

3 years

Master of Computer Application

2 years

BA (Legal Studies)

3 years

B.Com LLB (Hons)

5 years

BBA LLB (Hons)

5 years

BA.LLB (HONS)

5 years

Master of Technology (M.Tech)

2 years

Integrated B.Pharm + MBA

4 years

Bachelor of Pharmacy

4 years

Bachelor of Computer Application (BCA)

3 years

Bachelor of Planning

4 years

Master of Law (LLM)

1 year

Bachelor of Arts (BA)

3 years

Bachelor of Arts (Hons)

3 years

BA (Hons) Economics

3 years

Master of Arts

2 years

Bachelor of Commerce (Hons)

3 years

Bachelor of Science (Hons)

3 years

Bachelor of Science (Hons)

4 years

Bachelor of Science (B.Sc)

3 years

Integrated B.Sc + M.Sc

5 years

Integrated M.Sc

2 years

Master of Science(M.Sc.)

2 years

BA (Digital and Mass Media)

3 years

B.Design

4 years

B.Design + M.Design

5 years

M. A. in Digital Media and Multimedia Communication

2 years

MBA (Events, Public Relations and Corporate Communications)

2 years

BA in Cinema Studies

3 years

BA (Communication Research, Public Health and Communication)

3 years

B.A. (Journalism and Mass Communication)

3 years

M.A (Journalism & Mass Communication)

2 years

Master of Design (M.Design)

2 years

Read More

UPES, Dehradun Popular Courses

B.Tech / B.E.
18 Programs 4 Years

Average Fees
₹10,00,000

Highest Package
₹17 LPA

Admission 2025

View Brochure
B.Tech / B.E. Application Open Apply Now
MBA / PGDM
12 Programs 2 Years

Average Fees
₹10,00,000

Highest Package
₹15 LPA

Admission 2025

View Brochure
MBA / PGDM Application Open Apply Now
LLB
2 Programs 3 Years

Average Fees
₹10,00,000

Highest Package
₹15 LPA

Admission 2025

View Brochure
LLB Application Open Apply Now
BBA / BBM / BBS
15 Programs 3 Years

Average Fees
₹10,00,000

Highest Package
₹36 LPA

Admission 2025

View Brochure
BBA / BBM / BBS Application Open Apply Now
View All 23 Courses

UPES, Dehradun Admission

UPES Dehradun offers various undergraduate and post graduate courses, along with this; university also offers fulltime and part time Ph.D. programs.

UPES Dehradun Course Admissions process is divided into two categories:

  • Admission based on UPES Entrance Examination
  • Admission without UPES Entrance Examination; based on merit or score in any national level examination. 

The application form for UPES Dehradun can be filled in both online as well as an offline mode. The application fee is INR 1350.

UPES Course Admissions Highlights 2025

University NameUPES Dehradun
University TypeState Private University
Admission CriteriaBoth Merit and entrance based
Application ModeOnline and offline
University Entrance Name

For B.tech - UPES Engineering Aptitude Test (UPESEAT)

For B.Plan - UPES Planning Aptitude Test (UPAT)
For B.Design  - UPES Design Aptitude Test (UPES DAT)
Integrated Law - ULSAT
For MBA - UPESMAT
For Ph.D. - Research Aptitude Test (RET)

Type of CounsellingCentralized Counselling
NIRF Rankings56th Ranks in Management Category

Also Check UPES Dehradun Fee Structure

Read More

UPES, Dehradun Placement

UPES Placements 2023 Report

UPES Placements 2025 are in process.  According to the most recent data, the highest package offered at UPES placements 2024 is INR 33 LPA. The average package at UPES placements 2024 is INR 7.02 LPA. Participating recruiters in the placement drive were Amazon, ONGC, Adani, Goorej, Maruti Suzuki, Boeing, Microsoft India, and other companies. Over the past five years, the university has placed more than 90% of students.

UPES Dehradun offers studies in various disciplines like Engineering, Science, Design, Law among others.

During the 2023 UPES placement drive, the institute witnessed an overall placement record of 94% as 2318 students got placed in more than 560 companies.
 

UPES Dehradun Placement Highlights

Placement Percentage

93.98%

Overall Students Placed

1905

No. of recruiters visited the campus

568

Highest Package

33 LPA

Average Package

7.02 LPA

Top Recruiters

Accenture, Adani, Amazon, Samsung, Genpact, McKinsey & Company

Know more about UPES Dehradun Placements

Read More

Top Recruiters

Adani group Adani group
Accenture Accenture
Adventity BPO India Pvt. Ltd. Adventity BPO India Pvt. Ltd.
Asia Motor Asia Motor
Blue Dart Express Ltd Blue Dart Express Ltd
CESC  Limited CESC Limited
Deloitte Deloitte
Honeywell Honeywell
infosys infosys
ITC ITC
JBM JBM
Kale Consultants(ACCELY KALE) Kale Consultants(ACCELY KALE)
L&T ECC L&T ECC
McKinsey & Co McKinsey & Co
Maples Maples
Motherson Sumi wires Ltd Motherson Sumi wires Ltd
PUNJ LLOYD PUNJ LLOYD
Reliance Reliance
TCS TCS
Technipp India Technipp India
Wipro Wipro
Amazon India Amazon India
General Motors General Motors
Tata group Tata group
schlumberger schlumberger
IBM IBM
Nestle India Nestle India
Bosch Ltd Bosch Ltd
microsoft microsoft
Nestle India Nestle India
Adani Power Limited Adani Power Limited
Croma Digital Croma Digital
Berger Berger
Genpact Genpact
ITC ITC
HDFC Bank HDFC Bank
JSW Steel Ltd JSW Steel Ltd
View All Recruiters Details

UPES, Dehradun LLB Rankings

Publisher Year Ranking
nirf 2024 28 / 40
nirf 2021 25 / 30

UPES, Dehradun M.Tech / M.E. Rankings

Publisher Year Ranking
nirf 2024 42 / 100

UPES, Dehradun Integrated Law Rankings

Publisher Year Ranking
nirf 2024 28 / 40

UPES, Dehradun MBA / PGDM Rankings

Publisher Year Ranking
nirf 2024 41 / 100
nirf 2023 39 / 100
nirf 2022 41 / 100
nirf 2021 46 / 100
itoday 2020 74 / 100
nirf 2020 66 / 100

UPES, Dehradun B.Tech / B.E. Rankings

Publisher Year Ranking
nirf 2024 42 / 100
nirf 2023 54 / 100
nirf 2022 61 / 200
nirf 2021 91 / 300
nirf 2020 167 / 200
nirf 2018 101 / 200

UPES, Dehradun All Courses Rankings

Publisher Year Ranking
nirf 2024 59 / 100
nirf 2021 100 / 200
nirf 2020 151 / 200

UPES, Dehradun BBA / BBM / BBS Rankings

Publisher Year Ranking
itoday 2021 22 / 178

UPES, Dehradun Scholarship

UPES Scholarships and Financial Assistance for Students

UPES Dehradun offers various scholarships and financial assistance for the students, mentioned below are the types of financial assistance provided to the students:

  • 20% Exclusive Scholarship for girls students
  • Upto 100% merit based Scholarship
  • 33% Tuition fee concession for Bonafide Uttarakhand residents.
  • Doctoral Research Fellowship
  • Industry Scholarships
Read More

UPES, Dehradun Infrastructure Details

UPES Alliance and Industry Interface

UPES Dehradun Alliance and Industry Interface

UPES Industry Alliance
  • UPES Faculty and Industry experts deliver and develop the courses.
  • Summer Internship is provided to the students.
  • Faculty Training by experts from the industry.

UPES Events

UPES Dehradun is involved in various events and collaborations, given below are some of the latest events of UPES Dehradun:

  • Resumption of Indian Tourism Industry - UPES Dehradun in association with the Ministry of Tourism, Government of India, organized an online National Conference on ‘Resumption of Indian Tourism Industry in the New Normal’.  
  • UPES launches Naman, an initiative to provide succor to martyrs’ families - UPES Dehradun has launched an initiative for the betterment of martyrs’ families. University is helping the families financially.

Boys Hostel

Girls Hostel

Medical Facility

Library Facility

Cafeteria

Computer Lab

Laboratory

Gymnasium

Sports Facilities

Auditorium

Wi-Fi Facility

Transport Facility

UPES, Dehradun Awards

Best Academic-Industry Interface

’Best Academic-Industry Interface’ by DNA (a leading Indian media house) in 2018

Best Industry-Academia Interface

Best Industry-Academia Interface at the 12th World Education Summit by Digital Learning & Elets Technomedia Pvt Ltd in 2018

Best University for Placements and Employability

Best University for Placements and Employability by Times Now- National Education Excellence Award 2018

India Best University for Innovation and Value based Education

India’s Best University for Innovation and Value based Education by the Corporate Council for Leadership & Awareness (CCLA)

Student's Rating for UPES, Dehradun

Student Reviews & Ratings
3.9/5 Based on 34 Verified Reviews
Component Ratings
Faculty Rating 4
Infrastructure Rating 4.2
Placements Rating 4.7
Admission Rating 4
Hostel Rating 4.1
Club Rating 3.8

Student's Reviews for UPES, Dehradun

Admission
Placement
Faculty
5 Overall 04-10-2021
A

Anonymous User
MBA Student

The college is perfect. There is an environment of learning and some of the events the college conduct are very useful for the overall development of the student

Admission: My admission procedure was a bit simple and easy. Only you have to take a test of upes and if u clear it u will be called for the counseling and the admission is done

5 Overall 04-10-2021
A

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4 Admission 4.5 Hostel 5 Club 4.5 Mess
Awsome. i miss my college

Placement: Great. Big brands & good exposure

Infrastructure: Gym, Laboratories

Faculty: Anupama Tadarmal- Intelligent and always helping supporting

Admission: State / National Entrance Exams, Group Discussion / Personal Interview

Club: N/A

Mess: Food, Ambience, Infrastructure

5 Overall 05-04-2024
A

Anonymous User
MBA Student

5 Placement 5 Faculty
Our college is situated in the mountains. There is Wi-Fi all over the campus. There is a huge library with a millions of books of each and every field. All the classrooms are very much spacious with smart Boards and labs are full of PC. Hostels are of dou

Placement: Overall placement of our college is 100% that is all the students who were eligible for the placement criteria got placed. Highest package was 50 lakhs and average package was 9 lakh per annum. Top recruiting companies that come to our college are Microso

4 Overall 04-10-2021
A

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 5 Mess
The placement of the college is excellent, the college ensures that the student is placed in good company. The only thing which concerns me is the high fees as everyone can not afford this much fees. Overall the college is good with a beautiful campus.

Placement: Excellent placement opportunities in the college. So many top companies came for placement. Student needs to ensure that they don’t have any backlog. Otherwise, it would affect the CGPA score and most of the companies doesn’t want a student wi

Faculty: The faculty of the college are great and knowledgeable. They help us in every aspect.

Admission: I got admission on the basis of JEE Main score

3 Overall 04-10-2021
A

Anonymous User
MBA Student

3 Infrastructure 3.5 Faculty 5 Admission 3 Hostel 3 Club 3 Mess
The overall management of the college is good enough to run a family of a huge number of students of the campus and provide a step forward in the betterment of their lifestyles.Though management wasn’t good, but they were also at the learning stage

Placement: Placements are nice.They have direct connection with companies like Xebia,IBM.Almost students gets placed who passes the eligbility criteria for placement

Faculty: The faculty is ok.some are really good and some are just ok.There are more than 10 faculties other than your own who is teaching you for a single subject.It was really good though it was in its initial stage but the faculty was really good and experienced

Admission: Based on School / 12th Class Result

4 Overall 04-10-2021
A

Anonymous User
MBA Student

4.5 Infrastructure 3.5 Faculty 3.5 Hostel 4 Club 3.5 Mess
I has taken Admission in computer science in My college before that I has also applied for the BCA where I got selected but tan I choose B.Tech . for dis i has given UPESEAT exam and their was no interview as well In the Infrastructure is concern their a

Placement: Placements are excellent around 80-88% students of dis college got placed in big companies like IBM, Infosys etc.. with Minimum Package of 4 lacs Per annum to 12 Lacs Per annum and in many cases it can go more up.

Faculty: Although Faculties are very Good over they give extra time for Students my favorite teachers are Dr. Aonal Hussain Mathematics and Dr. Ratnish Pandey of electronics who teaches us very well but when it comes to taking doubts and Proper Feedback Dr. Ratni

View All 34 Reviews

Frequently Asked Questions

Is UPES Dehradun Government College?

No, UPES Dehradun is a State Private University.

What is the fee structure of UPES Dehradun Engineering course?

UPES Dehradun btech fee is approx. 16LPA whereas for B.tech CSE (Hons.) fee is approx. 18LPA.

What is the Average Package received by the UPES Dehradun student?

UPES Dehradun average package is approx. 6.3 LPA.

What are UPES Dehradun rankings?

or MBA course UPES Dehradun ranking is 66 by NIRF in Management Category.

What is the contact number of UPES Dehradun?

UPES Dehradun contact numbers are as follows: 1800-102-8737 (TOLL-FREE), 0135-2770137/2776053/2776054.

What is the last date to apply for MBA programme in UPES Dehradun?",

The admission is based on UPSEMET 2021 entrance exam of UPES Dehradun. The last date to apply is 30th September 2021 and the entrance exam date is 2nd October 2021.

Can I get direct admission at UPES Dehradun 2021?

Yes, Candidates can take direct admission in various courses offered by UPES Dehradun 2021

Is UPES Dehradun very expensive?

The average fees of the all the courses is comparatively high and it also includes some extra charges. Although the ROI of the college is good and students are placed with comfortable package.

What is the hostel fee of UPES Dehradun?

UPES Dehradun Hostel fee is as follows : Rs. 1,70,000/- Regular Hostel for boys and girls at Bidholi and Kandoli Campus. Rs. 1,90,000/- for hostel room with attached washroom (only for girls) at the Kandholi campus and Rs. 2,13,500/- for hostel room with

What is UPES full form?

UPES full form is University of Petroleum and Energy Studies.

Show More

Gallery

41 Images
Campus

Campus

Campus

Campus

Campus

Campus

Campus

Campus

Computer lab

Computer lab

Hostel

Hostel

Lab

Lab

Campus

Campus

View All 41 Images

Contact Details

Address

Bidholi Campus Office Energy Acres, P.O. Bidholi Via-Prem Nagar

College Contact

21XXXXXX95

Email

RaXXXXXXin

Get Contact Details

UPES, Dehradun 3.9/5 (34 reviews)

Shortlist

Brochure

Quick Links

Request history8.3.19PHP Version274msRequest Duration4MBMemory UsageGET {type}/{slug}Route
    • Booting (7.3ms)time
    • Application (267ms)time
    • 1 x Application (97.34%)
      267ms
      1 x Booting (2.66%)
      7.30ms
      20 templates were rendered
      • pages.college-profile.descriptiondescription.blade.php#?blade
      • components.breadcrumbbreadcrumb.blade.php#?blade
      • components.navbarnavbar.blade.php#?blade
      • components.author-detailsauthor-details.blade.php#?blade
      • components.toctoc.blade.php#?blade
      • components.college-contentcollege-content.blade.php#?blade
      • components.popular-coursespopular-courses.blade.php#?blade
      • components.college-contentcollege-content.blade.php#?blade
      • components.college-contentcollege-content.blade.php#?blade
      • components.college-contentcollege-content.blade.php#?blade
      • components.total-reviewtotal-review.blade.php#?blade
      • components.detailed-reviewsdetailed-reviews.blade.php#?blade
      • components.faqfaq.blade.php#?blade
      • components.registrationregistration.blade.php#?blade
      • layouts.webweb.blade.php#?blade
      • partials.headhead.blade.php#?blade
      • partials.headerheader.blade.php#?blade
      • partials.footerfooter.blade.php#?blade
      • components.sucessesModalsucessesModal.blade.php#?blade
      • partials.bottomfooterbottomfooter.blade.php#?blade
      uri
      GET {type}/{slug}
      middleware
      web
      domain
      www.dev.collegesearch.in
      controller
      App\Http\Controllers\CollegeController@description
      as
      colleges_university.profile.description
      namespace
      prefix
      /{type}
      where
      file
      app/Http/Controllers/CollegeController.php:104-187
      72 statements were executed (9 duplicates)Show only duplicates137ms
      • SoftRedirects.php#22db_collegesearch_newConnection Established
        Backtrace
        • app/Http/Middleware/SoftRedirects.php:22
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
      • SoftRedirects.php#22db_collegesearch_new7.67msselect * from `seo_redirects` where `redirect_from` = '/university/university-of-petroleum-and-energy-studies-upes-dehradun' limit 1
        Bindings
        • 0: /university/university-of-petroleum-and-energy-studies-upes-dehradun
        Backtrace
        • app/Http/Middleware/SoftRedirects.php:22
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
      • MetaChecker.php#20db_collegesearch_new1.15msselect * from `meta_tags` where `slug` = 'university/university-of-petroleum-and-energy-studies-upes-dehradun' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: university/university-of-petroleum-and-energy-studies-upes-dehradun
        • 1: active
        Backtrace
        • app/Http/Middleware/MetaChecker.php:20
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • app/Http/Middleware/SoftRedirects.php:28
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
      • CollegeController.php#129db_collegesearch_new1.56msselect `institutes`.*, (select count(*) from `institute_reviews` where `institutes`.`id` = `institute_reviews`.`institute_id` and `institute_reviews`.`deleted_at` is null and `status` = 'active') as `reviews_count` from `institutes` where `slug` = 'university-of-petroleum-and-energy-studies-upes-dehradun' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: active
        • 1: university-of-petroleum-and-energy-studies-upes-dehradun
        • 2: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new960μsselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `updated_at` from `institute_contents` where `type` != 'about' and `institute_contents`.`institute_id` in (7506) and `institute_contents`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: about
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.14msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (235, 261) and `admins`.`deleted_at` is null
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new3.52msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` in (7506) and `institute_faculties`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new740μsselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` in (7506) and `institute_feature_mappings`.`deleted_at` is null
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new780μsselect `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (1) and `institute_features`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.36msselect `id`, `infrastructure_id`, `institute_id` from `institute_infrastructures` where `institute_infrastructures`.`institute_id` in (7506) and `institute_infrastructures`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.5msselect `id`, `name` from `infrastructures` where `infrastructures`.`id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.03msselect `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` in (7506) and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new800μsselect * from `institute_recruiters` where `institute_recruiters`.`institute_id` in (7506) and `institute_recruiters`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.86msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (32, 46, 60, 68, 73, 84, 86, 115, 128, 139, 341, 908, 930, 1354, 1355, 1435, 1604, 1613, 1687, 1954, 2018, 2044, 2172, 2187, 2244, 2346, 2397, 2564, 2789, 3380, 3593, 4090, 4788, 6218, 6465)
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new950μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (3, 4, 6, 8, 11, 17, 18, 19, 22, 24, 28, 29, 30, 35, 36, 47, 48, 217, 345)
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new1.37msselect * from `institute_ratings` where `institute_ratings`.`institute_id` in (7506) and `institute_ratings`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • CollegeController.php#129db_collegesearch_new890μsselect * from `institute_alumnis` where `institute_alumnis`.`institute_id` in (7506) and `institute_alumnis`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:129
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
        • vendor/laravel/framework/src/Illuminate/Routing/Router.php:808
      • Institute.php#174db_collegesearch_new710μsselect `name` from `cities` where `id` = 192 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
        Bindings
        • 0: 192
        • 1: active
        Backtrace
        • app/Models/Institute.php:174
        • app/Http/Controllers/CollegeController.php:297
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#189db_collegesearch_new950μsselect `name` from `states` where `id` = 96 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1
        Bindings
        • 0: 96
        • 1: active
        • 2: 2
        Backtrace
        • app/Models/Institute.php:189
        • app/Http/Controllers/CollegeController.php:297
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#729db_collegesearch_new1.25msselect `institute_id`, `title`, `info_description`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 7506 and `institute_contents`.`institute_id` is not null and `type` = 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: 7506
        • 1: about
        • 2: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:729
        • app/Http/Controllers/CollegeController.php:299
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new1.64msselect `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` = 7506 and `institute_programs`.`institute_id` is not null and `institute_programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new1.32msselect `id`, `name` from `programs` where `programs`.`id` in (15, 17, 20, 21, 32, 36, 49, 55, 79, 138, 213, 230, 231, 232, 233, 234, 479, 652, 657, 658, 659, 674, 677, 683, 684, 685, 686, 687, 784, 787, 918, 920, 921, 922, 932, 933, 963, 1215, 1251, 1256, 1265, 1266, 1267, 1268, 1269, 1270, 1271, 1310, 1311, 1315, 1324, 1325, 1407, 1408, 1409, 1410, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1427, 1443, 1444, 1799, 1888, 1892, 1893, 1894, 1895, 1896, 1897, 2035, 2264, 2265, 2267, 2279, 2280, 2296, 2298, 2300, 2305, 2404, 2405, 2406, 2772, 2773, 2774, 2775, 2779, 2798, 2823, 3070, 3071, 3430, 3437, 3443, 3466, 3484, 3534, 3622, 3639, 3851, 4245, 4422, 4479, 4695, 5031, 5811, 5855, 5856, 5857, 5858, 5859, 5860, 5861, 5862, 5863) and `programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new850μsselect `id`, `name` from `courses` where `courses`.`id` in (1, 2, 6, 7, 8, 9, 10, 11, 13, 15, 18, 19, 20, 21, 23, 25, 29, 33, 43, 48, 80, 81, 89) and `courses`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new2.2msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15613, 15614, 15615, 15616, 15617, 15618, 15619, 15620, 15621, 15622, 15623, 15624, 15625, 15626, 15627, 15628, 15629, 15630, 15631, 15632, 15633, 15634, 15635, 15636, 15637, 15638, 15639, 15640, 15641, 15642, 15643, 15644, 15645, 15646, 15647, 15648, 15649, 15650, 15651, 15652, 15653, 15654, 15655, 15656, 15657, 15658, 39641, 39642, 39643, 39644, 39645, 39646, 39647, 39648, 39649, 39650, 39651, 39652, 39653, 39654, 39655, 39656, 39657, 39658, 39659, 39660, 39661, 47474, 47475, 47476, 47478, 47479, 47481, 47482, 47483, 47484, 59334, 59335, 59336, 59978, 70428, 70429, 72736, 72737, 72738, 72739, 72801, 75213, 75214, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75225, 75227, 75229, 75230, 75232, 75233, 75234, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new2.11msselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (15613, 15614, 15615, 15616, 15617, 15618, 15619, 15620, 15621, 15622, 15623, 15624, 15625, 15626, 15627, 15628, 15629, 15630, 15631, 15632, 15633, 15634, 15635, 15636, 15637, 15638, 15639, 15640, 15641, 15642, 15643, 15644, 15645, 15646, 15647, 15648, 15649, 15650, 15651, 15652, 15653, 15654, 15655, 15656, 15657, 15658, 39641, 39642, 39643, 39644, 39645, 39646, 39647, 39648, 39649, 39650, 39651, 39652, 39653, 39654, 39655, 39656, 39657, 39658, 39659, 39660, 39661, 47474, 47475, 47476, 47478, 47479, 47481, 47482, 47483, 47484, 59334, 59335, 59336, 59978, 70428, 70429, 72736, 72737, 72738, 72739, 72801, 75213, 75214, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75225, 75227, 75229, 75230, 75232, 75233, 75234, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#774db_collegesearch_new1.14msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (15613, 15614, 15615, 15616, 15617, 15618, 15619, 15620, 15621, 15622, 15623, 15624, 15625, 15626, 15627, 15628, 15629, 15630, 15631, 15632, 15633, 15634, 15635, 15636, 15637, 15638, 15639, 15640, 15641, 15642, 15643, 15644, 15645, 15646, 15647, 15648, 15649, 15650, 15651, 15652, 15653, 15654, 15655, 15656, 15657, 15658, 39641, 39642, 39643, 39644, 39645, 39646, 39647, 39648, 39649, 39650, 39651, 39652, 39653, 39654, 39655, 39656, 39657, 39658, 39659, 39660, 39661, 47474, 47475, 47476, 47478, 47479, 47481, 47482, 47483, 47484, 59334, 59335, 59336, 59978, 70428, 70429, 72736, 72737, 72738, 72739, 72801, 75213, 75214, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75225, 75227, 75229, 75230, 75232, 75233, 75234, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:774
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#776db_collegesearch_new960μsselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7506 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:776
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#209db_collegesearch_new740μsselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7506 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Models/Institute.php:209
        • app/Http/Controllers/CollegeController.php:777
        • app/Http/Controllers/CollegeController.php:301
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • Institute.php#209db_collegesearch_new1.72msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7506 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Models/Institute.php:209
        • app/Http/Controllers/CollegeController.php:303
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#138db_collegesearch_new950μsselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new3.8msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(admission_review) DESC, `created_at` desc limit 2
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new590μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#138db_collegesearch_new1.25msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new2.31msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(placement_review) DESC, `created_at` desc limit 2
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new720μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#138db_collegesearch_new1.22msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:138
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new2.36msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 7506 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(faculty_review) DESC, `created_at` desc limit 2
        Bindings
        • 0: 7506
        • 1: 
        • 2: active
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#151db_collegesearch_new1.37msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
        Backtrace
        • app/Models/Institute.php:151
        • app/Http/Controllers/CollegeController.php:307
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#315db_collegesearch_new930μsselect count(distinct `course_id`) as aggregate from `institute_course_summaries` where `institute_id` = 7506 and `institute_course_summaries`.`deleted_at` is null
        Bindings
        • 0: 7506
        Backtrace
        • app/Http/Controllers/CollegeController.php:315
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • CollegeController.php#325db_collegesearch_new1.25msselect * from `institute_course_summaries` where `institute_id` = 7506 and `institute_course_summaries`.`deleted_at` is null group by `course_id` limit 4
        Bindings
        • 0: 7506
        Backtrace
        • app/Http/Controllers/CollegeController.php:325
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • CollegeController.php#325db_collegesearch_new1.56msselect * from `courses` where `courses`.`id` in (1, 2, 6, 7) and `courses`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:325
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • InstituteCourseSummary.php#26db_collegesearch_new990μsselect * from `institute_programs` where `id` in ('15613', '15614', '15615', '15616', '15617', '15618', '15619', '15620', '15621', '15622', '15623', '15624', '15625', '15626', '15627', '75232', '75233', '75352') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 15613
        • 1: 15614
        • 2: 15615
        • 3: 15616
        • 4: 15617
        • 5: 15618
        • 6: 15619
        • 7: 15620
        • 8: 15621
        • 9: 15622
        • 10: 15623
        • 11: 15624
        • 12: 15625
        • 13: 15626
        • 14: 15627
        • 15: 75232
        • 16: 75233
        • 17: 75352
        • 18: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new860μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15613, 15614, 15615, 15616) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new1.7msselect `id`, `name`, `slug` from `exams` where `id` in ('161', '2321') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 161
        • 1: 2321
        • 2: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new3.73msselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 161 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 161
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new1.21msselect * from `institute_programs` where `id` in ('15647', '15648', '15649', '15650', '15651', '15652', '15653', '15654', '15655', '15656', '15657', '15658') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 15647
        • 1: 15648
        • 2: 15649
        • 3: 15650
        • 4: 15651
        • 5: 15652
        • 6: 15653
        • 7: 15654
        • 8: 15655
        • 9: 15656
        • 10: 15657
        • 11: 15658
        • 12: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new1.68msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15647, 15648, 15649, 15650) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new760μsselect `id`, `name`, `slug` from `exams` where `id` in ('57', '2148') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 57
        • 1: 2148
        • 2: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new1.97msselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 57 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 57
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new920μsselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9) and `exam_features`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
      • InstituteCourseSummary.php#26db_collegesearch_new830μsselect * from `institute_programs` where `id` in ('59978', '75361') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 59978
        • 1: 75361
        • 2: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new880μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (59978, 75361) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new700μsselect `id`, `name`, `slug` from `exams` where `id` in ('2324') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 2324
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new1.08msselect * from `institute_programs` where `id` in ('15636', '15637', '15638', '15639', '15640', '15641', '15642', '15643', '15644', '15645', '15646', '75347', '75350', '75351', '75354') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4
        Bindings
        • 0: 15636
        • 1: 15637
        • 2: 15638
        • 3: 15639
        • 4: 15640
        • 5: 15641
        • 6: 15642
        • 7: 15643
        • 8: 15644
        • 9: 15645
        • 10: 15646
        • 11: 75347
        • 12: 75350
        • 13: 75351
        • 14: 75354
        • 15: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#26db_collegesearch_new730μsselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (15636, 15637, 15638, 15639) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:26
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • InstituteCourseSummary.php#48db_collegesearch_new710μsselect `id`, `name`, `slug` from `exams` where `id` in ('2342') and `exams`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 2342
        • 1: active
        Backtrace
        • app/Models/InstituteCourseSummary.php:48
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Exam.php#57db_collegesearch_new1.46msselect `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 2342 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
        Bindings
        • 0: 2342
        • 1: exam_date
        • 2: active
        Backtrace
        • app/Models/Exam.php:57
        • app/Http/Controllers/CollegeController.php:328
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#238db_collegesearch_new1.48msselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 7506 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: 7506
        • 1: cs
        • 2: active
        Backtrace
        • app/Models/Institute.php:238
        • app/Http/Controllers/CollegeController.php:330
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#238db_collegesearch_new860μsselect * from `courses` where `courses`.`id` in (1, 2, 6, 7, 9, 10, 999) and `courses`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: active
        Backtrace
        • app/Models/Institute.php:238
        • app/Http/Controllers/CollegeController.php:330
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#331db_collegesearch_new1.48msselect `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` = 7506 and `institute_awards`.`institute_id` is not null and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:331
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • Institute.php#102db_collegesearch_new820μsselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7506 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Models/Institute.php:102
        • app/Http/Controllers/CollegeController.php:345
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new2.39msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7506 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:345
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new1.2msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (32, 46, 60, 68, 73, 84, 86, 115, 128, 139, 341, 908, 930, 1354, 1355, 1435, 1604, 1613, 1687, 2044, 2172, 2244, 2346, 2397, 2564, 2789, 3380, 3593, 4788, 6218)
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:345
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#105db_collegesearch_new740μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (3, 6, 8, 11, 17, 18, 19, 22, 24, 28, 29, 30, 47, 48, 217, 345)
        Backtrace
        • app/Models/Institute.php:105
        • app/Http/Controllers/CollegeController.php:345
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • Institute.php#225db_collegesearch_new26.47msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 7506 and `faqs`.`faq_id` is not null and `sub_type` = 'info' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: institute
        • 1: 7506
        • 2: info
        • 3: institute
        • 4: active
        Backtrace
        • app/Models/Institute.php:225
        • app/Http/Controllers/CollegeController.php:678
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
      • CollegeController.php#680db_collegesearch_new850μsselect * from `institute_documents` where `institute_documents`.`institute_id` = 7506 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:680
        • app/Http/Controllers/CollegeController.php:139
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • CollegeController.php#982db_collegesearch_new1.57msselect distinct `course_id` from `institute_programs` where `institute_id` = 7506 and `institute_programs`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: 7506
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:982
        • app/Http/Controllers/CollegeController.php:144
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • CollegeController.php#988db_collegesearch_new7.31msselect distinct `exam_id` from `institute_program_exam_mappings` inner join `institute_programs` on `institute_programs`.`id` = `institute_program_exam_mappings`.`institute_program_id` where `institute_programs`.`institute_id` = 7506
        Bindings
        • 0: 7506
        Backtrace
        • app/Http/Controllers/CollegeController.php:988
        • app/Http/Controllers/CollegeController.php:144
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • helpers.php#491db_collegesearch_new2.56msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%cp%' and `sub_type` like '%info%' and `module_id` = 7506 and `expiry_date` > '2025-03-16 13:55:15' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
        Bindings
        • 0: %cp%
        • 1: %info%
        • 2: 7506
        • 3: 2025-03-16 13:55:15
        Backtrace
        • app/helpers.php:491
        • app/Http/Controllers/CollegeController.php:144
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • helpers.php#506db_collegesearch_new2.39msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('161', '2321', '116', '2342', '57', '2148', '128', '2088', '2322', '2008', '2323', '2324') and `expiry_date` > '2025-03-16 13:55:15' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
        Bindings
        • 0: %exam%
        • 1: %about%
        • 2: 161
        • 3: 2321
        • 4: 116
        • 5: 2342
        • 6: 57
        • 7: 2148
        • 8: 128
        • 9: 2088
        • 10: 2322
        • 11: 2008
        • 12: 2323
        • 13: 2324
        • 14: 2025-03-16 13:55:15
        Backtrace
        • app/helpers.php:506
        • app/Http/Controllers/CollegeController.php:144
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • helpers.php#520db_collegesearch_new2.18msselect `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%course%' and `module_id` in ('1', '10', '7', '2', '9', '18', '33', '89', '15', '19', '20', '6', '13', '23', '11', '25', '8', '80', '43', '21', '29', '81', '48') and `sub_type` like '%about%' and `expiry_date` > '2025-03-16 13:55:15' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
        Bindings
        • 0: %course%
        • 1: 1
        • 2: 10
        • 3: 7
        • 4: 2
        • 5: 9
        • 6: 18
        • 7: 33
        • 8: 89
        • 9: 15
        • 10: 19
        • 11: 20
        • 12: 6
        • 13: 13
        • 14: 23
        • 15: 11
        • 16: 25
        • 17: 8
        • 18: 80
        • 19: 43
        • 20: 21
        • 21: 29
        • 22: 81
        • 23: 48
        • 24: %about%
        • 25: 2025-03-16 13:55:15
        Backtrace
        • app/helpers.php:520
        • app/Http/Controllers/CollegeController.php:144
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • CollegeController.php#844db_collegesearch_new1.59msselect * from `meta_tags` where `slug` = 'university/university-of-petroleum-and-energy-studies-upes-dehradun' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
        Bindings
        • 0: university/university-of-petroleum-and-energy-studies-upes-dehradun
        • 1: active
        Backtrace
        • app/Http/Controllers/CollegeController.php:844
        • app/Http/Controllers/CollegeController.php:156
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
      • helpers.php#156db_collegesearch_new1.31msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'
        Bindings
        • 0: institute
        • 1: active
        Backtrace
        • app/helpers.php:156
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
        • vendor/laravel/framework/src/Illuminate/View/View.php:209
      App\Models\InstituteProgram
      160InstituteProgram.php#?
      App\Models\Program
      121Program.php#?
      App\Models\InstituteProgramPlacement
      115InstituteProgramPlacement.php#?
      App\Models\InstituteProgramFeesSummary
      114InstituteProgramFeesSummary.php#?
      App\Models\InstituteImage
      100InstituteImage.php#?
      App\Models\InstituteRecruiter
      67InstituteRecruiter.php#?
      App\Models\Recruiter
      65Recruiter.php#?
      App\Models\RecruiterIndustryType
      35RecruiterIndustryType.php#?
      App\Models\Course
      34Course.php#?
      App\Models\InstituteRank
      20InstituteRank.php#?
      App\Models\InstituteInfrastructure
      12InstituteInfrastructure.php#?
      App\Models\Infrastructure
      12Infrastructure.php#?
      App\Models\InstituteProgramExamMapping
      12InstituteProgramExamMapping.php#?
      App\Models\InstituteFaculty
      11InstituteFaculty.php#?
      App\Models\Faq
      10Faq.php#?
      App\Models\InstituteAward
      8InstituteAward.php#?
      App\Models\InstituteContent
      6InstituteContent.php#?
      App\Models\InstituteReview
      6InstituteReview.php#?
      App\Models\InstituteAlumni
      4InstituteAlumni.php#?
      App\Models\InstituteCourseSummary
      4InstituteCourseSummary.php#?
      App\Models\User
      3User.php#?
      App\Models\Exam
      3Exam.php#?
      App\Models\Branding
      3Branding.php#?
      App\Models\Admin
      2Admin.php#?
      App\Models\Institute
      1Institute.php#?
      App\Models\InstituteFeatureMapping
      1InstituteFeatureMapping.php#?
      App\Models\InstituteFeature
      1InstituteFeature.php#?
      App\Models\InstituteRating
      1InstituteRating.php#?
      App\Models\City
      1City.php#?
      App\Models\State
      1State.php#?
      App\Models\ExamFeatureMapping
      1ExamFeatureMapping.php#?
      App\Models\ExamFeature
      1ExamFeature.php#?
          _token
          8SEYadmhu3ZBXGTmHTGSmGJCa6ZaJV6ITQb24y95
          _previous
          array:1 [ "url" => "https://www.dev.collegesearch.in/university/university-of-petroleum-and-energy...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /university/university-of-petroleum-and-energy-studies-upes-dehradun
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:16 [ "host" => array:1 [ 0 => "www.dev.collegesearch.in" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "course_id=21; course_name=BCom; XSRF-TOKEN=eyJpdiI6Ik52OXViOXlaREUvZzJmS0txd1lkb0E9PSIsInZhbHVlIjoiWENEWkdRZVpZZG81REJ0TnQrT1NNN01XTE9VQnY3ejdPR2JITE92cFRlRFIySUN1M2hnK3JTNEtKZ3dFK3dJbXJFU3JwMzZLSzhEWVovdldYQVBZNUs0ckpEdE92MEdDc2R6dnkwNHZJKzVqQzdzTWdXY0UvaFZSeXBjRlNxd3UiLCJtYWMiOiI2MjM1MjdkMzEyYTY3MGEyMmY4NTg3M2MyMjFjMjdlMjdkMjk2ZmU5MDJkNzE3YTA1NjkxNjkwYTYzZTgwOTk1IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IjRtTjZrL0FVUVR5UE1TSDhsbWh1Snc9PSIsInZhbHVlIjoiS3RjZS81RG1OVVNBUVVDRXcrRE5PdFBwZ0pYMDVZcGwzZzVlREJ4OFZEaGlVekFZU1h3L25PQlB2RzROaVB6Rk9XOGtFMlFOOFR3Ym01ZGh0YzJsMTZ5eForUzJHVENxU3JZVDBoNTBuRnlYN0N4TUZkOEpTMDhSdFBLdTI0VlciLCJtYWMiOiIyODViODVlMDRmYmZhMTA0OTFmZDVlODIwNWE1ZDk5N2IzNmNmM2E5ZWRjY2JlZjNiZWFlM2JkYTBjYjMzMTJhIiwidGFnIjoiIn0%3D; viewed_colleges=%5B2742%2C11138%2C7400%2C10762%2C1588%2C30497%2C7334%2C8556%2C1608%2C7292%5Dcourse_id=21; course_name=BCom; XSRF-TOKEN=eyJpdiI6Ik52OXViOXlaREUvZzJmS0txd1lkb0E9PSIsInZhbHVlIjoiWENEWkdRZVpZZG81REJ0TnQrT1NNN01XTE9VQnY3ejdPR2JITE92cFRlRFIyS" ] "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
          0 of 0
          array:5 [ "course_id" => "21" "course_name" => "BCom" "XSRF-TOKEN" => "8SEYadmhu3ZBXGTmHTGSmGJCa6ZaJV6ITQb24y95" "laravel_session" => "6cbWk1ccmBbF0mXKVAsdd4g15MBh9gTmV2xwWGhx" "viewed_colleges" => "[2742,11138,7400,10762,1588,30497,7334,8556,1608,7292]" ]
          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 => "Sun, 16 Mar 2025 13:55:15 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFrcDdXVEsvdm1SVUlBd0lOWEJFZlE9PSIsInZhbHVlIjoicnFPaUpRRFpaYWZaTzR5ZCtOaEhMMnNZYUN2THozcldKRklJM1BHS3RDNk8wbFRFMDc4ZnhYdlpIbkh4b2JkUWdIaEtnWHZHc0VHVEIyQjJxQ243K1FyNHdGOEZHN2prQlFZZzM1WlkzcXBLRXZ0akkzWlVxdElDOHBuU25aZWIiLCJtYWMiOiIwNjk3Y2YyZDI0NzljOWY0NGRhMjhkZWVlNmU3NWU2OGRjM2E4NmFhZWFjMmNiZjMzMWMzMDA5NjNlODlkMjhhIiwidGFnIjoiIn0%3D; expires=Sun, 16 Mar 2025 15:55:15 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImFrcDdXVEsvdm1SVUlBd0lOWEJFZlE9PSIsInZhbHVlIjoicnFPaUpRRFpaYWZaTzR5ZCtOaEhMMnNZYUN2THozcldKRklJM1BHS3RDNk8wbFRFMDc4ZnhYdlpIbkh4b2JkUWdIaEtnW" 1 => "laravel_session=eyJpdiI6ImRhOFFmc01BelBUNU5vOHNQdFZKR2c9PSIsInZhbHVlIjoiSFNXMXl3T3U1QXEwanZqY3ArbFF3M0R4SHFRT3RYS3JBU1k0eGdYOG5vM1pneExaeUw0ZDRuakY1Ly9WUi9VZFN6WDZtUzZlOHRtZmlUOHZncDcvWGhmanBVQkhKZW1CVE5WcmViZE1kay9wNUozSDBVbGNFcm5kTlRKaklJT2QiLCJtYWMiOiIzNTk0MjUyYTcxZDM5ZTMzNjNkMDQ2YmU2YzZmZmQ0NzVlNGQ3ZjJhNTI1MThlYzU4ZmY3MDc1ZjliZmE4NzQxIiwidGFnIjoiIn0%3D; expires=Sun, 16 Mar 2025 15:55:15 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6ImRhOFFmc01BelBUNU5vOHNQdFZKR2c9PSIsInZhbHVlIjoiSFNXMXl3T3U1QXEwanZqY3ArbFF3M0R4SHFRT3RYS3JBU1k0eGdYOG5vM1pneExaeUw0ZDRuakY1Ly9WUi9VZFN6" 2 => "viewed_colleges=%5B2742%2C11138%2C7400%2C10762%2C1588%2C30497%2C7334%2C8556%2C1608%2C7292%2C7506%5D; expires=Tue, 15 Apr 2025 13:55:15 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=laxviewed_colleges=%5B2742%2C11138%2C7400%2C10762%2C1588%2C30497%2C7334%2C8556%2C1608%2C7292%2C7506%5D; expires=Tue, 15 Apr 2025 13:55:15 GMT; Max-Age=2592000; pat" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFrcDdXVEsvdm1SVUlBd0lOWEJFZlE9PSIsInZhbHVlIjoicnFPaUpRRFpaYWZaTzR5ZCtOaEhMMnNZYUN2THozcldKRklJM1BHS3RDNk8wbFRFMDc4ZnhYdlpIbkh4b2JkUWdIaEtnWHZHc0VHVEIyQjJxQ243K1FyNHdGOEZHN2prQlFZZzM1WlkzcXBLRXZ0akkzWlVxdElDOHBuU25aZWIiLCJtYWMiOiIwNjk3Y2YyZDI0NzljOWY0NGRhMjhkZWVlNmU3NWU2OGRjM2E4NmFhZWFjMmNiZjMzMWMzMDA5NjNlODlkMjhhIiwidGFnIjoiIn0%3D; expires=Sun, 16-Mar-2025 15:55:15 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImFrcDdXVEsvdm1SVUlBd0lOWEJFZlE9PSIsInZhbHVlIjoicnFPaUpRRFpaYWZaTzR5ZCtOaEhMMnNZYUN2THozcldKRklJM1BHS3RDNk8wbFRFMDc4ZnhYdlpIbkh4b2JkUWdIaEtnW" 1 => "laravel_session=eyJpdiI6ImRhOFFmc01BelBUNU5vOHNQdFZKR2c9PSIsInZhbHVlIjoiSFNXMXl3T3U1QXEwanZqY3ArbFF3M0R4SHFRT3RYS3JBU1k0eGdYOG5vM1pneExaeUw0ZDRuakY1Ly9WUi9VZFN6WDZtUzZlOHRtZmlUOHZncDcvWGhmanBVQkhKZW1CVE5WcmViZE1kay9wNUozSDBVbGNFcm5kTlRKaklJT2QiLCJtYWMiOiIzNTk0MjUyYTcxZDM5ZTMzNjNkMDQ2YmU2YzZmZmQ0NzVlNGQ3ZjJhNTI1MThlYzU4ZmY3MDc1ZjliZmE4NzQxIiwidGFnIjoiIn0%3D; expires=Sun, 16-Mar-2025 15:55:15 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6ImRhOFFmc01BelBUNU5vOHNQdFZKR2c9PSIsInZhbHVlIjoiSFNXMXl3T3U1QXEwanZqY3ArbFF3M0R4SHFRT3RYS3JBU1k0eGdYOG5vM1pneExaeUw0ZDRuakY1Ly9WUi9VZFN6" 2 => "viewed_colleges=%5B2742%2C11138%2C7400%2C10762%2C1588%2C30497%2C7334%2C8556%2C1608%2C7292%2C7506%5D; expires=Tue, 15-Apr-2025 13:55:15 GMT; path=/; secure; httponlyviewed_colleges=%5B2742%2C11138%2C7400%2C10762%2C1588%2C30497%2C7334%2C8556%2C1608%2C7292%2C7506%5D; expires=Tue, 15-Apr-2025 13:55:15 GMT; path=/; secure; http" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "8SEYadmhu3ZBXGTmHTGSmGJCa6ZaJV6ITQb24y95" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/university/university-of-petroleum-and-energy-studies-upes-dehradun" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-16 13:55:15GET/university/university-of-petroleum-and-energy-studies-upes-dehradun2072935