Gujarat National Law University (GNLU), Gandhinagar : Courses, Fees, Admissions 2025, Rankings, Placements, Cutoff

25th March, 2025

Table of Content

Gujarat National Law University (GNLU), Gandhinagar Highlights

Gujarat National Law University GNLU Gandhinagar Highlights

Gujarat National Law University is a member of the NLUs founded by the Indian government. It is a public law school that was founded in accordance with the GNLU Act of 2003. The university offers UG programs in five streams, PG programs with more than ten specializations, and an interdisciplinary and law Ph.D. program.

The faculty-to-student ratio at the university is an excellent 1:19. The average age of faculty members at the university is 38 years, and 79% of them have PhDs. The University submits about 1,000 students a year, and of those, 44% are female students.

Aside from this, the University's 50.64-acre campus is home to all essential amenities, including a library, internet access, labs, moot courtrooms, an auditorium, and many more. There are about 60 teaching and research faculty members at the university's 12 research centers.

The university gives out about Rs 2 crore in scholarships and financial aid to its students each year. Nine distinct chair/fellowship programs in the field of law are available through the university in addition to degree programs. More than 30 prestigious foreign universities participate in the university's student exchange program. Universities like the University of Cologne in Germany, the University of Barcelona, the World Trade Institute in Switzerland, the Osaka University, and many more have collaborated with one another.

Year Of Establishment	2003
Type	Government
Approved by	Bar Council of India (BCI)
Recognition	Gujarat National Law University Act
Courses Offered	8 Courses across 3 streams
Application Mode	Online
Application criteria	Entrance-based
Official Website	https://www.gnlu.ac.in/GNLU/Home
NIRF ranking 2022	8th among the top law schools in India.

Gujarat National Law University GNLU Gandhinagar Courses And Fees

The university offers more than ten undergraduate, graduate, diploma, and postgraduate programs in a variety of specializations. Candidates who want to practice law in India must pass the All India Bar Exam (AIBE), which is administered by BCI. Lawyers who pass the AIBE exam are given a "Certificate of Practice," which is required to practice as an advocate in India.

Courses

Total tuition Fees

Eligibility

Exams

BBA LL.B. (Hons)

INR 6 L

(for 5 years)

10+2: 45 %

CLAT

LL.M.

INR 1.2 L

(for 1 year)

10+2: 45 %

Merit-Based

LL.B.

INR 6 L

(for 5 years)

10+2: 45 %

CLAT

B.Com LL.B

INR 6 L

(for 5 years)

10+2: 45 %

CLAT

B.A. LL.B. (Hons)

INR 6 L

10+2: 45 %

CLAT

PG Diploma

INR 15 K

Graduation

Courses	Total tuition Fees	Eligibility	Exams
BBA LL.B. (Hons)	INR 6 L (for 5 years)	10+2: 45 %	CLAT
LL.M.	INR 1.2 L (for 1 year)	10+2: 45 %	Merit-Based
LL.B.	INR 6 L (for 5 years)	10+2: 45 %	CLAT
B.Com LL.B	INR 6 L (for 5 years)	10+2: 45 %	CLAT
B.A. LL.B. (Hons)	INR 6 L	10+2: 45 %	CLAT
PG Diploma	INR 15 K	Graduation	Merit-Based
B.Sc. LL.B	INR 6 L	10+2: 45 %	CLAT
GNM	INR 1.95 L - 2.46 L	10+2: 45 %	Merit Based
ANM	INR 68 K - 1.16 L	10+2: 45 %	Merit Based
Ph.D.	INR 5.07 L (for 3 years)	Graduation	UG cet
B.Sc.	INR 3.4 L (for 4 years)	10+2: 45 %	Merit Based

Gujarat National Law University (GNLU), Gandhinagar Popular Courses

BBA / BBM / BBS

1 Programs 3 Years

Average Fees
₹6,00,000

Highest Package
-

BBA / BBM / BBS Application Open

LLM

5 Programs 2 Years

Average Fees
₹6,00,000

Highest Package
₹5 LPA

LLM Application Open

1 Programs 3 Years

Average Fees
₹6,00,000

Highest Package
-

BA Application Open

BCom

1 Programs 3 Years

Average Fees
₹6,00,000

Highest Package
-

BCom Application Open

View All 10 Courses

Top Recruiters

AMSS

AZB & Partners

Bajaj Allianz

Bharucha & Partners

Dave & Girish

DSK Legal

Economic Law Practice

Ernst & Young

G.C. Garg & Co.

Gujarat Electricity Regulatory Commission

Gujarat Industrial Development Corporation

Gujarat Mineral Development Corporation (GMDC)

Gujarat State Financial Corporation

Gujarat State Petroleum Corporation Limited (GSPC)

Gujarat State Power Corporation

HDFC Bank

Hindustan Zinc Limited (HZL)

Juris Corp

Khaitan & Co.

Kings & Partridge

Kochhar & Co.

KPMG India

Lakshmikumaran & Sridharan

Lal Lahiri & Salhotra

Lexygen

Nishith Desai and Associates

OSC

pangea3 LLC

Paras Kuhad & Associates

Punjab & Haryana High Court

Quislex

Rajinder Narain & Co.

sbicaps

SEBI

Seth Dua & Co.

Shah & Kishore Law Offices

Singhi & Co.

Supreme Court of India

Thakker & Thakker

Torrent Pharmaceuticals

Trilegal

Union Bank of India

Vaish and Associates

Wadia and Ghandy

Y.J. Trivedi & Co.

View All Recruiters Details

Gujarat National Law University (GNLU), Gandhinagar Integrated Law Rankings

Publisher	Year	Ranking
nirf	2024	8 / 40
itoday	2024	3 / 66
nirf	2023	7 / 100
itoday	2023	4 / 66
nirf	2021	6 / 30
nirf	2020	7 / 200

Gujarat National Law University (GNLU), Gandhinagar LLB Rankings

Publisher	Year	Ranking
nirf	2024	8 / 40

Student's Rating for Gujarat National Law University (GNLU), Gandhinagar

Student Reviews & Ratings

4.6/5 Based on 8 Verified Reviews

Component Ratings

Faculty Rating 4.2

Infrastructure Rating 4.7

Placements Rating 5

Admission Rating 4.5

Hostel Rating 4.6

Club Rating 4.1

Student's Reviews for Gujarat National Law University (GNLU), Gandhinagar

Admission

Placement

Faculty

4 Overall 25-07-2021

Anonymous User
MBA Student

4 Infrastructure 4 Faculty 4 Hostel 4 Club 4 Mess

It is one of the best university for law. I took admission in this college as it was quite well known college for studying law. It has good faculty ti student ratio. Good Infrastructure also.

Placement: Yes, students are placed in big law firms

Faculty: Well experienced teachers

Admission: Based on School / 12th Class Result

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 4 Faculty 5 Admission 4.5 Hostel 5 Club 4.5 Mess

Gnlu is a premier law college which provide quality education in law. The placements are awesome and the atmosphere is just too good.

Admission: State / National Entrance Exams

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4 Club 5 Mess

The infrastructure is great. All the buildings, be it our college buildings or our hostels, they all are perfect according to what students today need. Wi-Fi is available. Labs, classrooms and libraries all are good with loads of books for almost any and

Placement: Placement here in Gujarat National Law University is great. Almost 90% students here get the placement. The previous batch, that is, our senior batch had a great placement. Many have got great salary offers also. It is great to be a part of this universit

Faculty: My favourite teacher is Roshni mam.She tries to explain very well.

Admission: State / National Entrance Exams

Club: Different clubs of students who works for students related problems & tries to solve & raise voice for students in front of management.I give 9 grade.

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4.5 Mess

I have taken admission here on the CLAT Examination and the score of mine was 32 and my name came in the admission after the 4th List and this LLM Course was of 1 year which started in the year 2016 and ended in the year 2017 and the total fee of the coll

Placement: IT is more in the UG Course than the PG Course.

Faculty: Some of the faculties were 10 on 10 and some were 8 to 9.

Admission: State / National Entrance Exams

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4 Club 5 Mess

Faculty: My favourite teacher is Roshni mam.She tries to explain very well.

Admission: State / National Entrance Exams

Club: Different clubs of students who works for students related problems & tries to solve & raise voice for students in front of management.I give 9 grade.

4 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 4.5 Faculty 4.5 Mess

Placement: IT is more in the UG Course than the PG Course.

Faculty: Some of the faculties were 10 on 10 and some were 8 to 9.

Admission: State / National Entrance Exams

View All 8 Reviews

Gallery

7 Images

Contact Details

Address

Attalika Avenue, Knowledge Corridor, Koba

College Contact

23XXXXXX12

laXXXXXXom

Gujarat National Law University (GNLU), Gandhinagar 4.6/5 (8 reviews)

Compare colleges effortlessly

Get personalised expert counselling

Stay informed with timely updates

Reset Your Password

We will email you instructions to reset your password.

Please enter your full name

+91

Please enter valid Mobile Number

Please enter your Email address

Please enter your Course

B.Tech / B.E. is your Current Course.

Change

Continue with GoogleContinue with Google

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

Messages Timeline Exceptions Views16 Route Queries68 Models254 Mails Gate Session Request

Request history8.3.19243ms4MBGET {type}/{slug}

Booting (10.81ms)time
Application (232ms)time
1 x Application (95.55%)
232ms
1 x Booting (4.45%)
10.81ms

16 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.total-reviewtotal-review.blade.php#?blade
components.detailed-reviewsdetailed-reviews.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:105-233

68 statements were executed (13 duplicates)Show only duplicates154ms

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_new6.62ms

select * from `seo_redirects` where `redirect_from` = '/university/gujarat-national-law-university-gnlu-gandhinagar' limit 1

Bindings	0: /university/gujarat-national-law-university-gnlu-gandhinagar
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.18ms

select * from `meta_tags` where `slug` = 'university/gujarat-national-law-university-gnlu-gandhinagar' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/gujarat-national-law-university-gnlu-gandhinagar 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#130db_collegesearch_new1.65ms

select `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` = 'gujarat-national-law-university-gnlu-gandhinagar' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: gujarat-national-law-university-gnlu-gandhinagar 2: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new13.14ms

select `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `type` != 'about' and `institute_contents`.`institute_id` in (5040) and `institute_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: about 1: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.14msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:130
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#130db_collegesearch_new1.36ms

select `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` in (5040) and `institute_faculties`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.32ms

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` in (5040) and `institute_feature_mappings`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:130
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#130db_collegesearch_new1.19ms

select `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (3) and `institute_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new2.78ms

select `id`, `infrastructure_id`, `institute_id` from `institute_infrastructures` where `institute_infrastructures`.`institute_id` in (5040) and `institute_infrastructures`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.05msselect `id`, `name` from `infrastructures` where `infrastructures`.`id` in (1, 2, 3, 4, 5, 9)

Backtrace

app/Http/Controllers/CollegeController.php:130
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#130db_collegesearch_new1.23ms

select `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` in (5040) and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new2.18ms

select * from `institute_recruiters` where `institute_recruiters`.`institute_id` in (5040) and `institute_recruiters`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.72ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (114, 621, 1416, 1833, 2018, 2819, 3068, 3127, 3323, 3444, 3763, 4635, 4636, 4639, 4640, 4642, 4645, 4647, 4652, 4655, 4656, 4657, 4671, 4672, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694)

Backtrace

app/Http/Controllers/CollegeController.php:130
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#130db_collegesearch_new1.39ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 4, 6, 8, 19, 41, 66, 93, 123, 128, 189)

Backtrace

app/Http/Controllers/CollegeController.php:130
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#130db_collegesearch_new1.91ms

select * from `institute_ratings` where `institute_ratings`.`institute_id` in (5040) and `institute_ratings`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.05ms

select * from `institute_alumnis` where `institute_alumnis`.`institute_id` in (5040) and `institute_alumnis`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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_new1.11ms

select `name` from `cities` where `id` = 183 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1

Bindings	0: 183 1: active
Backtrace	app/Models/Institute.php:174 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#189db_collegesearch_new880μs

select `name` from `states` where `id` = 74 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1

Bindings	0: 74 1: active 2: 2
Backtrace	app/Models/Institute.php:189 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#775db_collegesearch_new14.3ms

select `institute_id`, `title`, `info_description`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 5040 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: 5040 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:775 app/Http/Controllers/CollegeController.php:345 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new1.64ms

select `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` = 5040 and `institute_programs`.`institute_id` is not null and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 5040 1: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new640μs

select `id`, `name` from `programs` where `programs`.`id` in (3440, 3479) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new740μs

select `id`, `name` from `courses` where `courses`.`id` in (9, 18) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new790μs

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (56390, 56391) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new610μs

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (56390, 56391) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#820db_collegesearch_new680μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (56390, 56391) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#822db_collegesearch_new850μs

select count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 5040 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 5040 1: active
Backtrace	app/Http/Controllers/CollegeController.php:822 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.01ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 5040 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 5040 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:823 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

Institute.php#209db_collegesearch_new800μs

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 5040 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 5040 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new680μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new860μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new670μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new870μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new790μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new480μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new600μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new720μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 5040 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: 5040 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new440μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#361db_collegesearch_new1.5ms

select count(distinct `course_id`) as aggregate from `institute_course_summaries` where `institute_id` = 5040 and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 5040
Backtrace	app/Http/Controllers/CollegeController.php:361 app/Http/Controllers/CollegeController.php:140 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#371db_collegesearch_new1.2ms

select * from `institute_course_summaries` where `institute_id` = 5040 and `institute_course_summaries`.`deleted_at` is null group by `course_id` limit 4

Bindings	0: 5040
Backtrace	app/Http/Controllers/CollegeController.php:371 app/Http/Controllers/CollegeController.php:140 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#371db_collegesearch_new690μs

select * from `courses` where `courses`.`id` in (7, 18, 19, 21) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:371 app/Http/Controllers/CollegeController.php:140 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_new1.01ms

select * from `institute_programs` where `id` in ('127476') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 127476 1: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new2.41ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (127476) 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:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#48db_collegesearch_new1.45msselect `id`, `name`, `slug` from `exams` where `id` in ('') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1: active
Backtrace	app/Models/InstituteCourseSummary.php:48 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.23ms

select * from `institute_programs` where `id` in ('127471', '127472', '127473', '127474', '127475') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 127471 1: 127472 2: 127473 3: 127474 4: 127475 5: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.97ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (127471, 127472, 127473, 127474) 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:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#48db_collegesearch_new7.54msselect `id`, `name`, `slug` from `exams` where `id` in ('') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1: active
Backtrace	app/Models/InstituteCourseSummary.php:48 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.27ms

select * from `institute_programs` where `id` in ('127470') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 127470 1: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.25ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (127470) 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:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#48db_collegesearch_new530μsselect `id`, `name`, `slug` from `exams` where `id` in ('') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1: active
Backtrace	app/Models/InstituteCourseSummary.php:48 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new530μs

select * from `institute_programs` where `id` in ('127477') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 127477 1: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.98ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (127477) 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:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#48db_collegesearch_new690μsselect `id`, `name`, `slug` from `exams` where `id` in ('') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1: active
Backtrace	app/Models/InstituteCourseSummary.php:48 app/Http/Controllers/CollegeController.php:374 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#238db_collegesearch_new730μs

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 5040 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: 5040 1: cs 2: active
Backtrace	app/Models/Institute.php:238 app/Http/Controllers/CollegeController.php:376 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#238db_collegesearch_new660μsselect * from `courses` where `courses`.`id` in (6, 9) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Models/Institute.php:238 app/Http/Controllers/CollegeController.php:376 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#377db_collegesearch_new2.64ms

select `id`, `name`, `description`, `year`, `institute_id` from `institute_awards` where `institute_awards`.`institute_id` = 5040 and `institute_awards`.`institute_id` is not null and `institute_awards`.`deleted_at` is null and `status` = 'active' order by `year` desc

Bindings	0: 5040 1: active
Backtrace	app/Http/Controllers/CollegeController.php:377 app/Http/Controllers/CollegeController.php:140 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_new1.4ms

select count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 5040 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 5040 1: active
Backtrace	app/Models/Institute.php:102 app/Http/Controllers/CollegeController.php:391 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#105db_collegesearch_new2.51ms

select distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 5040 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 5040 1: active
Backtrace	app/Models/Institute.php:105 app/Http/Controllers/CollegeController.php:391 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#105db_collegesearch_new1.42ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (621, 1416, 1833, 2018, 3127, 3323, 3763, 4635, 4636, 4640, 4642, 4645, 4647, 4655, 4672, 4674, 4675, 4676, 4677, 4678, 4679, 4680, 4681, 4682, 4688, 4689, 4690, 4691, 4692, 4693)

Backtrace

app/Models/Institute.php:105
app/Http/Controllers/CollegeController.php:391
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#105db_collegesearch_new660μs

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (4, 8, 19, 66, 93, 123, 128, 189)

Backtrace

app/Models/Institute.php:105
app/Http/Controllers/CollegeController.php:391
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#225db_collegesearch_new26.43ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 5040 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: 5040 2: info 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:724 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#726db_collegesearch_new9.12ms

select * from `institute_documents` where `institute_documents`.`institute_id` = 5040 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc

Bindings	0: 5040 1: active
Backtrace	app/Http/Controllers/CollegeController.php:726 app/Http/Controllers/CollegeController.php:140 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#1038db_collegesearch_new1.19ms

select distinct `course_id` from `institute_programs` where `institute_id` = 5040 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 5040 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1038 app/Http/Controllers/CollegeController.php:160 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#1044db_collegesearch_new1.08ms

select 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` = 5040

Bindings	0: 5040
Backtrace	app/Http/Controllers/CollegeController.php:1044 app/Http/Controllers/CollegeController.php:160 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_new3.88ms

select `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` = 5040 and `expiry_date` > '2025-04-27 18:30:30' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %info% 2: 5040 3: 2025-04-27 18:30:30
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:160 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_new3ms

select `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 ('2008') and `expiry_date` > '2025-04-27 18:30:30' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 2008 3: 2025-04-27 18:30:30
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:160 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_new1.81ms

select `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 ('9', '18') and `sub_type` like '%about%' and `expiry_date` > '2025-04-27 18:30:30' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 9 2: 18 3: %about% 4: 2025-04-27 18:30:30
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:160 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#890db_collegesearch_new550μs

select * from `meta_tags` where `slug` = 'university/gujarat-national-law-university-gnlu-gandhinagar' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/gujarat-national-law-university-gnlu-gandhinagar 1: active
Backtrace	app/Http/Controllers/CollegeController.php:890 app/Http/Controllers/CollegeController.php:192 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_new730μsselect * 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\InstituteRecruiter: 75InstituteRecruiter.php#?
App\Models\Recruiter: 75Recruiter.php#?
App\Models\RecruiterIndustryType: 19RecruiterIndustryType.php#?
App\Models\InstituteImage: 14InstituteImage.php#?
App\Models\InstituteProgram: 11InstituteProgram.php#?
App\Models\Course: 8Course.php#?
App\Models\InstituteRank: 7InstituteRank.php#?
App\Models\InstituteInfrastructure: 6InstituteInfrastructure.php#?
App\Models\Infrastructure: 6Infrastructure.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\InstituteCourseSummary: 4InstituteCourseSummary.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Program: 2Program.php#?
App\Models\Institute: 1Institute.php#?
App\Models\InstituteContent: 1InstituteContent.php#?
App\Models\Admin: 1Admin.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\InstituteProgramPlacement: 1InstituteProgramPlacement.php#?
App\Models\InstituteProgramExamMapping: 1InstituteProgramExamMapping.php#?

_token: E1qxAGQ7G3KR8J6azFpu7Sd6b5H4PcIGX6z6inDa
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/university/gujarat-national-law-university-gn...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/university/gujarat-national-law-university-gnlu-gandhinagar

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 27 Apr 2025 18:30:30 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklPYUoyMVJEZ2dFSzNIYXcyR0k1cVE9PSIsInZhbHVlIjoicUN2YU0vRnlQSG5pWDByZUhIOFhGZWRxSUdnbUMrYW0zakFWYlhNcThBYlIwbjBld0NkU01Hb0xoa1hJaW1hSVVBSXRsRmZxOCtZUlZCM2c5TUFBMVgzSEVXSGwrQUdKa2pubHpqM25nOHRxUERJN1dUVjhkLzZhYllZbXpMbWYiLCJtYWMiOiI1Y2UzNjU4OGVjMzEwMWFjYWI2YWQ0NGRjZmU1ODFmNGEwZWFkMjllNTFkZjFjOTY4NWNhNWZhMWUzOWQxODE2IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 20:30:30 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IklPYUoyMVJEZ2dFSzNIYXcyR0k1cVE9PSIsInZhbHVlIjoicUN2YU0vRnlQSG5pWDByZUhIOFhGZWRxSUdnbUMrYW0zakFWYlhNcThBYlIwbjBld0NkU01Hb0xoa1hJaW1hSVVBSXRsR ▶"
    1 => "laravel_session=eyJpdiI6IktjSDRKMmhqMjZGcEMvWnhwTWdrNXc9PSIsInZhbHVlIjoiNnZHVjh0Q21ZSm9oSFZnZ0tLUXIyWEhMVmROdHFDbVBVWDJlMUF3bTlGelRBa29kNnNmdE1WakVmdHZ5dEFQMkc3Vmo0Qms0WEFTRnYxLzA0c0lrdFU5M0xhTzBnM1N4R3FoTnFIT0I3VUhRam96b0FMN0ptQjdDV3JXRldJaWEiLCJtYWMiOiIyYzY0MGExYWU0Y2IwOTk3M2Q3ZGI5ZTIwYmIxYjE1YzIzODc4MTM1MGNhNDhkZDYwMzNmNDk1ODg3YzU0MzM5IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 20:30:30 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IktjSDRKMmhqMjZGcEMvWnhwTWdrNXc9PSIsInZhbHVlIjoiNnZHVjh0Q21ZSm9oSFZnZ0tLUXIyWEhMVmROdHFDbVBVWDJlMUF3bTlGelRBa29kNnNmdE1WakVmdHZ5dEFQMkc3 ▶"
    2 => "viewed_colleges=%5B5040%5D; expires=Tue, 27 May 2025 18:30:30 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklPYUoyMVJEZ2dFSzNIYXcyR0k1cVE9PSIsInZhbHVlIjoicUN2YU0vRnlQSG5pWDByZUhIOFhGZWRxSUdnbUMrYW0zakFWYlhNcThBYlIwbjBld0NkU01Hb0xoa1hJaW1hSVVBSXRsRmZxOCtZUlZCM2c5TUFBMVgzSEVXSGwrQUdKa2pubHpqM25nOHRxUERJN1dUVjhkLzZhYllZbXpMbWYiLCJtYWMiOiI1Y2UzNjU4OGVjMzEwMWFjYWI2YWQ0NGRjZmU1ODFmNGEwZWFkMjllNTFkZjFjOTY4NWNhNWZhMWUzOWQxODE2IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 20:30:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IklPYUoyMVJEZ2dFSzNIYXcyR0k1cVE9PSIsInZhbHVlIjoicUN2YU0vRnlQSG5pWDByZUhIOFhGZWRxSUdnbUMrYW0zakFWYlhNcThBYlIwbjBld0NkU01Hb0xoa1hJaW1hSVVBSXRsR ▶"
    1 => "laravel_session=eyJpdiI6IktjSDRKMmhqMjZGcEMvWnhwTWdrNXc9PSIsInZhbHVlIjoiNnZHVjh0Q21ZSm9oSFZnZ0tLUXIyWEhMVmROdHFDbVBVWDJlMUF3bTlGelRBa29kNnNmdE1WakVmdHZ5dEFQMkc3Vmo0Qms0WEFTRnYxLzA0c0lrdFU5M0xhTzBnM1N4R3FoTnFIT0I3VUhRam96b0FMN0ptQjdDV3JXRldJaWEiLCJtYWMiOiIyYzY0MGExYWU0Y2IwOTk3M2Q3ZGI5ZTIwYmIxYjE1YzIzODc4MTM1MGNhNDhkZDYwMzNmNDk1ODg3YzU0MzM5IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 20:30:30 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IktjSDRKMmhqMjZGcEMvWnhwTWdrNXc9PSIsInZhbHVlIjoiNnZHVjh0Q21ZSm9oSFZnZ0tLUXIyWEhMVmROdHFDbVBVWDJlMUF3bTlGelRBa29kNnNmdE1WakVmdHZ5dEFQMkc3 ▶"
    2 => "viewed_colleges=%5B5040%5D; expires=Tue, 27-May-2025 18:30:30 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "E1qxAGQ7G3KR8J6azFpu7Sd6b5H4PcIGX6z6inDa"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/university/gujarat-national-law-university-gnlu-gandhinagar"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-27 18:30:30	GET	/university/gujarat-national-law-university-gnlu-gandhinagar	16 68 254

1 x Application (95.55%)	232ms
1 x Booting (4.45%)	10.81ms