"What is the tuition fee for undergraduate courses at NLU Delhi?"

"The tuition fee for undergraduate courses (BA LLB Hons) at NLU Delhi is INR 2,20,000 per annum."

"What are the hostel fees at NLU Delhi?"

"The hostel fees at NLU Delhi is INR 1,05,000 per annum, which includes room rent, mess charges, and other facilities such as laundry, wifi, and sports facilities."

"Are the fees for NLU Delhi the same every year?"

"No, the fees for NLU Delhi are subject to change every year and may increase slightly. Students are advised to check the official website of NLU Delhi for the latest fees structure."

"Is it possible to pay the NLU Delhi fees in instalments?"

"Yes, NLU Delhi allows students to pay the fees in instalments. However, students need to check the specific rules and regulations regarding fee payment with the University’s finance department."

Join CollegeSearch Family

Register & enjoy the perks of a Universal College Application, Easy Process, Time-saving, and Free Contact details and Brochures.

20 Lakhs+

Monthly Users

1.75 Lakh+

Monthly Applications

30K +

Admissions

info@collegesearch.in +91 92281 51258

Popular Colleges by Branches

MBA/PGDM MCA B.Tech / B.E B.Sc BCA BBA B.COM

Trending Search

Top MBA Colleges in Delhi/NCR

Top MBA Colleges in Bangalore

Top Engineering Colleges in Delhi/NCR

Top Engineering Colleges in Bangalore

No Result Found

Home

Integrated Law

Integrated Law Colleges

Delhi NCR

NLUD- National Law University, Delhi

Courses Fees

Public College

NLU Fees Structure 2025 for 5 Years - B.A.LL.B.(Hons.) & LLM

Q: "Are there any scholarships available for students studying at NLU Delhi?"

"Yes, NLU Delhi provides scholarships and financial assistance to meritorious and economically weaker students. The University offers scholarships such as the Smt. Savitri Jindal Scholarship, the Justice T.P.S. Chawla Scholarship, and the L&T Build India Scholarship."

Delhi, Delhi NCR
ESTD 2008

Shortlist

Brochure

NLUD- National Law University , Delhi Campus

+8 Photos & Videos

Nupur Yadav

Updated on 17th April, 2023

NLUD- National Law University, Delhi Courses and Fees Details

NLU Fees -

National Law University Delhi (NLU Delhi) is one of the top-ranked law schools in India, known for its exceptional faculty, rigorous curriculum, and state-of-the-art facilities. If you’re considering pursuing a legal education at NLU Delhi, it’s essential to understand the fee structure before applying. The fee structure of NLU Delhi, including the tuition fees, hostel fees, and other expenses.

NLUs Fee Structure 2024

Since NLU Delhi offers a three-year LLB program, the following is the cost breakdown for UG and PG course:

NLU Delhi Fees	UG fees	PG Fees
NLUD	INR 3.80 LPA	INR 2.47 LPA

NLU Entrance Exams Application Fees -

Following are the NLU application fees details for CLAT and AILET exams -

CLAT Exam -

CLAT Application Fee 2024
General/ OBC/ PWD/ NRI/ PIO/ OCI candidates	INR 4,000
SC/ST/BPL	INR 3,500
Additional fee (if any)	INR 500 for old question papers request

AILET Exam -

AILET application fee 2024
General Category/ Kashmiri Migrants/ Resident of Jammu & Kashmir	INR 3,050
PWD/SC/ST category	INR 1,050
Below Poverty Line candidates from SC/ ST category	No application fee

NLU Fee Structure

NLU name	UG Fees	PG Fees
NLSIU Bengaluru	INR 4.10 LPA	INR 4.10 LPA
NALSAR Hyderabad	INR 2.70 LPA	INR 1.75 LPA
NLIU Bhopal	INR 3.30 LPA	INR 2.45 LPA
WBNUJS Kolkata	INR 3.85 LPA	INR 2.72 LPA
NLU Jodhpur	INR 3.06 LPA	INR 2.28 LPA
HNLU Raipur	INR 2.15 LPA	INR 1.65 LPA
GNLU Gandhinagar	INR 2.58 LPA	INR 2.62 LPA
GNLU Silvassa Campus	INR 2.58 LPA	INR 2.62 LPA

Eligibility criteria for NLU Delhi -

Course	Eligibility	Fees	Course Duration	Entrance Exam
BA LLB (Hons)	10+2 with 50% marks (45% for SC/ST candidates)	INR 3.80 LPA	5 years	AILET
LLM (1 Year)	LLB or equivalent degree with 50% marks (45% for SC/ST candidates)	INR 1 LPA - INR 4 LPA	1 year	AILET (PG) or CLAT (PG)
PhD	LLM degree with 55% marks (50% for SC/ST candidates)	-	3-5 years	Entrance Exam and Interview

Tuition Fees at NLU Delhi

The tuition fees for the undergraduate program (BA LLB Hons) at NLU Delhi is INR 2,20,000 per annum. The tuition fees for the postgraduate program (LLM) are INR 1,80,000 per annum. It’s worth noting that these fees are subject to change every year and may increase slightly.

Hostel Fees at NLU Delhi

NLU Delhi provides on-campus accommodation for its students, and the hostel fees are INR 1,05,000 per annum. The hostel fees include room rent, mess charges, and other facilities such as laundry, Wifi, and sports facilities. NLU Delhi also has separate hostels for boys and girls.

Other Expenses at NLU Delhi

Apart from the tuition and hostel fees, there are other expenses that students must consider while studying at NLU Delhi. These include:

Library Fees: INR 5,000 per annum
Moot Court Fees: INR 5,000 per annum
Insurance Fees: INR 1,000 per annum
Examination Fees: INR 5,000 per annum
Caution Money (refundable): INR 10,000 (one time)
Scholarships and Financial Assistance

NLU Delhi provides scholarships and financial assistance to meritorious and economically weaker students. The University offers scholarships such as the Smt. Savitri Jindal Scholarship, the Justice T.P.S. Chawla Scholarship, and the L&T Build India Scholarship.

Additionally, NLU Delhi has tie-ups with various banks, which provide education loans to students at lower interest rates.

In conclusion, NLU Delhi is a prestigious law school that offers excellent legal education, but the fees can be a significant factor in deciding whether or not to apply. We hope this article has given you a better understanding of the fees structure at NLU Delhi and other expenses that you need to consider before applying.

Also read - Best Law Colleges in India

Course	Total Fees
BA.LLB (HONS) 5 Years \| Fulltime \| On Campus	₹ 7,60,000 Fees Details
Master of Law (LLM) 2 Years \| Fulltime \| On Campus	₹ 3,48,100 Fees Details
Post Graduate Diploma in Urban Environmental Management and Law (PGDUEML) 2 Years \| Fulltime \| On Campus	₹ 13,000 Fees Details
PGD in Tourism and Environmental Law (PGDTEL) 1 Years \| Fulltime \| On Campus	₹ 13,000 Fees Details

NLUD- National Law University , Delhi Courses

BA.LLB (HONS)

5 Years

Total Fees

₹ 7,60,000

Highest Package

Admission 2024 View Brochure

NLUD- National Law University BA.LLB (HONS) Applications Open

Apply Now

Master of Law (LLM)

2 Years

Total Fees

₹ 3,48,100

Highest Package

Admission 2024 View Brochure

NLUD- National Law University LLM Applications Open

Apply Now

Post Graduate Diploma in Urban Environmental Management and Law (PGDUEML)

2 Years

Total Fees

₹ 13,000

Highest Package

Admission 2024 View Brochure

NLUD- National Law University PGDUEML Applications Open

Apply Now

PGD in Tourism and Environmental Law (PGDTEL)

1 Years

Total Fees

₹ 13,000

Highest Package

Admission 2024 View Brochure

NLUD- National Law University PGDTEL Applications Open

Apply Now

NLUD- National Law University, Delhi Top Recruiters

Wipro Limited Consumer Care & Lighting Division

Luthra and Luthra Law Offices

Bajaj Finserve

Vakil -Mehta Sheth (VMS)

ICICI Direct

View All Recruiters Details

Student's Rating for NLUD- National Law University , Delhi

Student Reviews & Ratings

4/5

100% Positive reviews

Component Ratings

Write a Review >

Contact Details

Address

Sector 14, Dwarka, Delhi, Delhi NCR, 110078

College Contact

011 - 28XXXXXX55

rexxxar@xxxin

Get Contact Details

NLUD- National Law University , Delhi

4/5 (1 reviews)

Shortlist

Brochure

Home

Integrated Law

Integrated Law Colleges

Delhi NCR

NLUD- National Law University, Delhi

Courses Fees

Popular Searches

Popular Colleges/Universities

LPU (Lovely Professional University), Jalandhar Amity University, Noida Chandigarh University (CU), Chandigarh Indian Institute of Management (IIM), Bangalore Indian Institute of Technology, Delhi Ajeenkya DY Patil University Powered by Sunstone

Top Colleges by Courses

Top Engineering Colleges in India Top MBA/PGDM Colleges in India Top MCA Colleges in India Top BCA Colleges in India Top BBA Colleges in India Top Msc Colleges in India Top Bsc Colleges in India

Top Exams

JEE Main JEE Advanced CAT CUET SNAP XAT KCET

Top Courses

BTech MBA BBA BCA BCom MCA BSc

Top Boards

CBSE 12th Board CBSE 10th Board UP 12th Board Punjab 12th Board West Bengal 12th Board Maharashtra 12th Board

Messages1 Timeline Exceptions Views14 Route Queries58 Models65 Mails Gate Session Request

Request history8.3.19651ms4MBGET colleges/{slug}/{tab}

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

Booting (7.31ms)time
Application (643ms)time
1 x Application (98.88%)
643ms
1 x Booting (1.12%)
7.31ms

14 templates were rendered

pages.college_v2.courses-feescourses-fees.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
pages.college_v2.partials.navbarnavbar.blade.php#?blade
pages.college_v2.partials.latest_updateslatest_updates.blade.php#?blade
pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
pages.college_v2.partials.deatailed_review_sectiondeatailed_review_section.blade.php#?blade
pages.college_v2.partials.contactcontact.blade.php#?blade
pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
partials.footerfooter.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade

uri: GET colleges/{slug}/{tab}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfileTab
namespace
prefix
where
as: cp.collegetabs
file: app/Http/Controllers/CollegeController.php:715-2899

58 statements were executed, 14 of which were duplicates, 44 unique. Show only duplicated544ms

Connection Establisheddb_collegesearchCacheService.php#460

Backtrace

13. app/Service/CacheService.php:460
14. app/Service/CacheService.php:446
15. middleware::softRedirects:76
16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
17. middleware::crossAppSync:53

select * from `seo_redirects` where `redirect_from` = '/colleges/national-law-university-nlud-delhi/courses-fees' and `status` = 1 limit 1

9.81msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/national-law-university-nlud-delhi/courses-fees 1: 1
Backtrace	15. app/Service/CacheService.php:460 16. app/Service/CacheService.php:446 17. middleware::softRedirects:76 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select `ics_link_2` from `institutes` where `ics_link` = 'national-law-university-nlud-delhi' and `status` = 'Active' limit 1

1.38msdb_collegesearchCacheService.php#492

Bindings	0: national-law-university-nlud-delhi 1: Active
Backtrace	15. app/Service/CacheService.php:492 16. app/Service/CacheService.php:478 17. middleware::softRedirects:88 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select * from `institutes` where (`status` = 'Active' and `ics_link_2` = 'national-law-university-nlud-delhi') limit 1

3.22msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: national-law-university-nlud-delhi
Backtrace	15. app/Http/Controllers/CollegeController.php:723 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `sub_course` where `sub_course_url` = 'courses-fees' limit 1

3.68msdb_collegesearchCollegeController.php#746

Bindings	0: courses-fees
Backtrace	15. app/Http/Controllers/CollegeController.php:746 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` = 5072 and `institute_courses`.`institute_id` is not null

7.04msdb_collegesearchCollegeController.php#771

Bindings	0: 5072
Backtrace	20. app/Http/Controllers/CollegeController.php:771 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` LIKE '%cutoff%') as `institute_faqs_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `institutes`.`id` in (5072)

258msdb_collegesearchCollegeController.php#780

Bindings	0: 43 1: 2: %cutoff% 3: Alumni 4: 5: 6: 0 7: 8: 0
Backtrace	17. app/Http/Controllers/CollegeController.php:780 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `states` where `states`.`StateID` in (72)

4.22msdb_collegesearchCollegeController.php#807

Bindings	0: 72
Backtrace	19. app/Http/Controllers/CollegeController.php:807 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

1.21msdb_collegesearchCollegeController.php#807

Bindings	0: active 1: yes
Backtrace	19. app/Http/Controllers/CollegeController.php:807 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (9)

970μsdb_collegesearchCollegeController.php#807

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

select `name` from `images` where `is_desktop` = 1 and `institute_id` = 5072 and `images`.`deleted_at` is null limit 1

1.42msdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 5072
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:822 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select count(*) as aggregate from `cutoff_new_shagun_json` left join `institute_courses` on `institute_courses`.`id` = `cutoff_new_shagun_json`.`institute_course_id` where `institute_id` = 5072

7.42msdb_collegesearchCollegeController.php#837

Bindings	0: 5072
Backtrace	15. app/Http/Controllers/CollegeController.php:837 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institutes`.*, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institutes` as `laravel_reserved_2` where `institutes`.`old_univ_id` = `laravel_reserved_2`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count` from `institutes` where `id` = 5072 and `status` = 'Active' limit 1

131msdb_collegesearchCollegeController.php#970

Bindings	0: 1: 0 2: 3: 0 4: 43 5: 6: Alumni 7: 8: 5072 9: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:970 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `images` where `images`.`institute_id` in (5072) and `student_featured` = 0 and `images`.`deleted_at` is null order by case when (is_featured = 1) then 0 when (category = 'campus') then 2 else 3 end, id desc

2.51msdb_collegesearchCollegeController.php#970

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

1.65msdb_collegesearchCollegeController.php#970

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (9)

910μsdb_collegesearchCollegeController.php#970

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

select session_user_id , institute_id , date_format(ADDTIME(last_modified, '5:30'),'%D %M, %Y') as last_modifi from `admin_reporting` where `admin_reporting`.`institute_id` in (5072) order by `ID` desc limit 1

1.47msdb_collegesearchCollegeController.php#970

Backtrace

20. app/Http/Controllers/CollegeController.php:970
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `admin` where `admin`.`ID` in (238)

6.25msdb_collegesearchCollegeController.php#970

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

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

2.12msdb_collegesearchCollegeController.php#970

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

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

1.67msdb_collegesearchCollegeController.php#970

Bindings	0: active
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `sub_course` where `sub_course`.`id` in (18, 96, 97, 202)

850μsdb_collegesearchCollegeController.php#970

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

select * from `course_type` where `course_type`.`id` in (9, 18)

1.99msdb_collegesearchCollegeController.php#970

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

select * from `course_fees` where `course_fees`.`institute_course_id` in (5902, 8977, 29831, 29833) and `fees_name` = 'Total All Fees'

30.64msdb_collegesearchCollegeController.php#970

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

select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (5902, 8977, 29831, 29833) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

880μsdb_collegesearchCollegeController.php#970

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

select `institute_course_id`, `highest_package`, `lowest_package`, `average_package`, `year` from `placement` where `placement`.`institute_course_id` in (5902, 8977, 29831, 29833) and `average_package` != '' and `highest_package` != '' order by `year` desc limit 1

4.78msdb_collegesearchCollegeController.php#970

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

select * from `seats` where `seats`.`institute_course_id` in (5902, 8977, 29831, 29833)

1.22msdb_collegesearchCollegeController.php#970

Backtrace

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

select `id`, `course_type`, `course_name`, `student_name`, `college_desc`, `added_date`, `year_of_study`, `overall_rating` from `user_reviews` where `user_reviews`.`course_type` in (9, 18) and `institute_id` = 5072 and `college_desc` != '' and length(college_desc) > 10 and `status` = 'Active' order by `overall_rating` asc, length(college_desc) desc

820μsdb_collegesearchCollegeController.php#970

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

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `user_reviews`.`institute_id` in (5072) and `status` = 'Active' and `college_desc` != '' order by `sequence` asc, length(college_desc) desc limit 10

900μsdb_collegesearchCollegeController.php#970

Bindings	0: Active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (58979) order by `vote_up` desc

1.08msdb_collegesearchCollegeController.php#970

Backtrace

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

select * from `institute_faqs` where `institute_faqs`.`institute_id` in (5072) and `section` LIKE '%courses%'

660μsdb_collegesearchCollegeController.php#970

Bindings	0: %courses%
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_id`, `name`, `description`, `type`, `webp_image`, `logo`, `twitter_link` from `collaboration` where `collaboration`.`institute_id` in (5072) and `type` in ('Award', 'Alumni') and `description` != '' order by `seq` asc, `id` asc limit 20

1.42msdb_collegesearchCollegeController.php#970

Bindings	0: Award 1: Alumni 2:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` = 5072 and `institute_courses`.`institute_id` is not null limit 1

2.12msdb_collegesearchCollegeController.php#995

Bindings	0: 5072
Backtrace	21. app/Http/Controllers/CollegeController.php:995 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

1.49msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:995
23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

7.55msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:995
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select top_recruiter.name,ro.name as org_name,ri.name as industry_name , rc.city_name ,image,    webp_image from top_recruiter
left JOIN recruiter_organization ro on top_recruiter.recuiter_organization_id = ro.id
left JOIN recruiter_industry ri on top_recruiter.recuiter_industry_id = ri.id
left JOIN city rc on top_recruiter.city_id = rc.id WHERE top_recruiter.id IN (5281,6182,4653,3864,5859)

2.06msdb_collegesearchCollegeController.php#996

Backtrace

10. app/Http/Controllers/CollegeController.php:996
11. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
12. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
13. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
14. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `states` where `states`.`StateID` = 72 and `states`.`StateID` is not null limit 1

2.53msdb_collegesearchCollegeController.php#1004

Bindings	0: 72
Backtrace	20. app/Http/Controllers/CollegeController.php:1004 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_courses`.`course_type`, `course_type`.`course_name`, `course_type`.`id`, `sub_course`.`sub_course_url` from `institute_courses` inner join `course_type` on `institute_courses`.`course_type` = `course_type`.`id` inner join `sub_course` on `institute_courses`.`course_type` = `sub_course`.`course_type_id` where `institute_id` = 5072 group by `course_type`.`id`

8.68msdb_collegesearchCollegeController.php#1018

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

select (SUM(CASE WHEN (overall_rating = '5.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS excellent_count,
(SUM(CASE WHEN (overall_rating = '4.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS good_count,
(SUM(CASE WHEN (overall_rating = '3.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS average_count,
(SUM(CASE WHEN (overall_rating = '2.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS bad_count,
(SUM(CASE WHEN (overall_rating = '1.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS worst_count,
(SUM(CASE WHEN status = 'Rejected' THEN 1 ELSE 0 END)) AS rejected_review,
(SUM(CASE WHEN (fashion_rating >0 AND fashion_rating != '' AND status = 'Active') THEN fashion_rating ELSE 0 END)) AS fashion_review_average,
(SUM(CASE WHEN (sports_rating >0 AND sports_rating != '' AND status = 'Active') THEN sports_rating ELSE 0 END)) AS sports_review_average,
(SUM(CASE WHEN (event_rating >0 AND event_rating != '' AND status = 'Active') THEN event_rating ELSE 0 END)) AS event_review_average,
(SUM(CASE WHEN (hostel_rating >0 AND hostel_rating != '' AND status = 'Active') THEN hostel_rating ELSE 0 END)) AS hostel_review_average,
(SUM(CASE WHEN (canteen_rating >0 AND canteen_rating != '' AND status = 'Active') THEN canteen_rating ELSE 0 END)) AS canteen_review_average,
(SUM(CASE WHEN (infra_rating >0 AND status = 'Active') THEN infra_rating ELSE 0 END)) AS infra_review_average,
(SUM(CASE WHEN (intern_rating >0 AND status = 'Active') THEN intern_rating ELSE 0 END)) AS intern_review_average,
(SUM(CASE WHEN (teacher_rating >0 AND status = 'Active') THEN teacher_rating ELSE 0 END)) AS teacher_review_average,
(SUM(CASE WHEN (admission_rating >0 AND status = 'Active') THEN admission_rating ELSE 0 END)) AS admission_review_average,
(SUM(CASE WHEN (infra_rating > 0 AND infra_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS infra_review_count,
(SUM(CASE WHEN (intern_rating > 0 AND intern_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS intern_review_count,
(SUM(CASE WHEN (admission_rating > 0 AND admission_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS admission_review_count,
(SUM(CASE WHEN (teacher_rating > 0 AND teacher_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS teacher_rating_count,
(SUM(CASE WHEN (fashion_rating > 0 AND fashion_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS fashion_review_count,
(SUM(CASE WHEN (sports_rating > 0 AND sports_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS sports_review_count,
(SUM(CASE WHEN (event_rating > 0 AND event_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS event_review_count,
(SUM(CASE WHEN (hostel_rating > 0 AND hostel_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS hostel_review_count,
(SUM(CASE WHEN (canteen_rating > 0 AND canteen_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS canteen_review_count from `user_reviews` where `institute_id` = 5072

1.21msdb_collegesearchCollegeController.php#1046

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

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 5072 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 9 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

1.31msdb_collegesearchCollegeController.php#1071

Bindings	0: Active 1: 5072 2: 3: 4: 9
Backtrace	14. app/Http/Controllers/CollegeController.php:1071 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 5072 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 9 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

1.2msdb_collegesearchCollegeController.php#1089

Bindings	0: Active 1: 5072 2: 3: 4: 9
Backtrace	14. app/Http/Controllers/CollegeController.php:1089 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 5072 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 9 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

1.46msdb_collegesearchCollegeController.php#1107

Bindings	0: Active 1: 5072 2: 3: 4: 9
Backtrace	14. app/Http/Controllers/CollegeController.php:1107 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 5072 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

980μsdb_collegesearchCollegeController.php#1111

Bindings	0: 5072 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:1111 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `inst_campaign_bharat_2022` where `institute_id` = 5072 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'

1.3msdb_collegesearchCollegeController.php#2682

Bindings	0: 5072 1: 2025-04-09 2: 2025-04-09
Backtrace	14. app/Http/Controllers/CollegeController.php:2682 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `metatags` where `PageID` = 'colleges/national-law-university-nlud-delhi/courses-fees' and `status` = 'Y' limit 1

1.21msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/national-law-university-nlud-delhi/courses-fees 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:2693 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `name` from `images` where `is_desktop` = 1 and `institute_id` = 5072 and `images`.`deleted_at` is null limit 1

1.3msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 5072
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:2705 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

1.55msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

2.08msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

1.43msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

1.7msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where modulename like '%cp-inner-courses-fees%' and `module_link_id` = 5072 and `expiry_date` > '2025-04-09 12:07:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.23msdb_collegesearchhelpers.php#1695

Bindings	0: 5072 1: 2025-04-09 12:07:10
Backtrace	14. app/helpers.php:1695 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%exam%' and `module_link_id` in ('2045') and `expiry_date` > '2025-04-09 12:07:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

890μsdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 2045 2: 2025-04-09 12:07:10
Backtrace	14. app/helpers.php:1712 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('9', '18', '18', '18') and `expiry_date` > '2025-04-09 12:07:10' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.05msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 9 2: 18 3: 18 4: 18 5: 2025-04-09 12:07:10
Backtrace	14. app/helpers.php:1726 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `ranks` where `ranks`.`institute_id` = 5072 and `ranks`.`institute_id` is not null

1.04msdb_collegesearchCollegeController.php#2835

Bindings	0: 5072
Backtrace	19. app/Http/Controllers/CollegeController.php:2835 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `header_name` from `course_type` where `id` = 9 limit 1

1.91msdb_collegesearchBreadcrumb.php#167

Bindings	0: 9
Backtrace	15. app/Service/Breadcrumb.php:167 16. app/Service/Breadcrumb.php:37 17. app/Http/Controllers/CollegeController.php:2848 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

1.04msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:2877
23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2045)

620μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2877
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `user_reviews` where `user_reviews`.`institute_id` = 5072 and `user_reviews`.`institute_id` is not null

1.32msdb_collegesearchhero_section.blade.php#27

Bindings	0: 5072
Backtrace	20. view::pages.college_v2.partials.hero_section:27 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 25. vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `user_reviews` where `user_reviews`.`institute_id` = 5072 and `user_reviews`.`institute_id` is not null

980μsdb_collegesearchnavbar.blade.php#31

Bindings	0: 5072
Backtrace	19. view::pages.college_v2.partials.navbar:31 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. vendor/laravel/framework/src/Illuminate/View/View.php:195

select `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp-inner-courses-fees' and `brandings`.`deleted_at` is null

1.31msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-courses-fees
Backtrace	14. app/helpers.php:970 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 20. vendor/laravel/framework/src/Illuminate/View/View.php:195

App\Models\InstituteCourse: 13InstituteCourse.php#?
App\Models\Image: 8Image.php#?
App\Models\Criteria: 8Criteria.php#?
App\Models\CourseType: 5CourseType.php#?
App\Models\UserReview: 5UserReview.php#?
App\Models\InstituteFaqs: 5InstituteFaqs.php#?
App\Models\SubCourse: 4SubCourse.php#?
App\Models\Rank: 4Rank.php#?
App\Models\Institute: 3Institute.php#?
App\Models\CourseFees: 3CourseFees.php#?
App\Models\State: 2State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\UserReviewsVoteUp: 1UserReviewsVoteUp.php#?
App\Models\MetaTag: 1MetaTag.php#?

_token: AvYFizot7yjy48E83afdukwCgNP57dgTVk4l6wnX
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/national-law-university-nlud-delhi/c...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/national-law-university-nlud-delhi/courses-fees

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 06:37:10 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik83TXAvYmprTDlWM2VxUkY1OUZZelE9PSIsInZhbHVlIjoiKzBVVXlwNFFwTUxteXBFV2U1a2ptU3lOeDRPeXlFSXUxVFJVa25sODlVMHhMdm5EdjBvMG1scC9Dcld6dG1rQTRZUlZZd0tJN0NLVVU3aWsyczRabHhKc2wrbkFWTnY4T1A5NG5aamRGU3JTZXR4Q3g2ZjU2M096YnRxQzUyaGoiLCJtYWMiOiI3OWIzMGYyYzg5YWQ2YjNiZDllYWYxZmViMDk1NjdiYjIxYzI0NGYxNzVmNDEwZWQ2YTNmZGI4YWFiZmRiNTYzIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 08:37:10 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik83TXAvYmprTDlWM2VxUkY1OUZZelE9PSIsInZhbHVlIjoiKzBVVXlwNFFwTUxteXBFV2U1a2ptU3lOeDRPeXlFSXUxVFJVa25sODlVMHhMdm5EdjBvMG1scC9Dcld6dG1rQTRZUlZZd ▶"
    1 => "cs_dev_session=eyJpdiI6Im1ybHp1dTVyNmsxRWgzMjBnWkVsc1E9PSIsInZhbHVlIjoiYTRhYWRxRm5RempUL3BqbnVMdW5ZVExKQnNpaXpwTTAyWHhBMmxiamZjcU1NRUFJWFdlS1g1T3c0UGthbTh6TTNiTVcyMUU2TWlVd3luTk9td3BIVUNQTWQ2UHNtZUhjUFI5a0xQUEtZZ1JzdjlOWTI4SFF6blFEeFRmcGFjNFAiLCJtYWMiOiI3NWM5N2E5ZWM1MmJjZmNlMWZhNWNhZDY2NWI3ZjhmZTJmM2FiZjZlNzViOGQ4ZTliMmZkNGU0YWM0NDZmN2VmIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 08:37:10 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6Im1ybHp1dTVyNmsxRWgzMjBnWkVsc1E9PSIsInZhbHVlIjoiYTRhYWRxRm5RempUL3BqbnVMdW5ZVExKQnNpaXpwTTAyWHhBMmxiamZjcU1NRUFJWFdlS1g1T3c0UGthbTh6TTNiT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik83TXAvYmprTDlWM2VxUkY1OUZZelE9PSIsInZhbHVlIjoiKzBVVXlwNFFwTUxteXBFV2U1a2ptU3lOeDRPeXlFSXUxVFJVa25sODlVMHhMdm5EdjBvMG1scC9Dcld6dG1rQTRZUlZZd0tJN0NLVVU3aWsyczRabHhKc2wrbkFWTnY4T1A5NG5aamRGU3JTZXR4Q3g2ZjU2M096YnRxQzUyaGoiLCJtYWMiOiI3OWIzMGYyYzg5YWQ2YjNiZDllYWYxZmViMDk1NjdiYjIxYzI0NGYxNzVmNDEwZWQ2YTNmZGI4YWFiZmRiNTYzIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 08:37:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik83TXAvYmprTDlWM2VxUkY1OUZZelE9PSIsInZhbHVlIjoiKzBVVXlwNFFwTUxteXBFV2U1a2ptU3lOeDRPeXlFSXUxVFJVa25sODlVMHhMdm5EdjBvMG1scC9Dcld6dG1rQTRZUlZZd ▶"
    1 => "cs_dev_session=eyJpdiI6Im1ybHp1dTVyNmsxRWgzMjBnWkVsc1E9PSIsInZhbHVlIjoiYTRhYWRxRm5RempUL3BqbnVMdW5ZVExKQnNpaXpwTTAyWHhBMmxiamZjcU1NRUFJWFdlS1g1T3c0UGthbTh6TTNiTVcyMUU2TWlVd3luTk9td3BIVUNQTWQ2UHNtZUhjUFI5a0xQUEtZZ1JzdjlOWTI4SFF6blFEeFRmcGFjNFAiLCJtYWMiOiI3NWM5N2E5ZWM1MmJjZmNlMWZhNWNhZDY2NWI3ZjhmZTJmM2FiZjZlNzViOGQ4ZTliMmZkNGU0YWM0NDZmN2VmIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 08:37:10 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6Im1ybHp1dTVyNmsxRWgzMjBnWkVsc1E9PSIsInZhbHVlIjoiYTRhYWRxRm5RempUL3BqbnVMdW5ZVExKQnNpaXpwTTAyWHhBMmxiamZjcU1NRUFJWFdlS1g1T3c0UGthbTh6TTNiT ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "AvYFizot7yjy48E83afdukwCgNP57dgTVk4l6wnX"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/national-law-university-nlud-delhi/courses-fees"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 12:07:10	GET	/colleges/national-law-university-nlud-delhi/courses-fees	1 14 58 65

1 x Application (98.88%)	643ms
1 x Booting (1.12%)	7.31ms