MA in National Academy of Legal Studies and Research University (NALSAR), Hyderabad Branch-wise Fees, Fee Breakups, Eligibility

Messages Timeline Exceptions Views12 Route Queries53 Models102 Mails Gate Session Request

Request history8.3.19196ms3MBGET {type}/{slug}/{tab}/{tab2}

Booting (7.83ms)time
Application (189ms)time
1 x Application (96.01%)
189ms
1 x Booting (3.99%)
7.83ms

12 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.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}/{tab}/{tab2}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs2
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:110-239

53 statements were executed (7 duplicates)Show only duplicates130ms

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_new8.29ms

select * from `seo_redirects` where `redirect_from` = '/colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma' limit 1

Bindings	0: /colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma
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_new2.25ms

select * from `meta_tags` where `slug` = 'colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma 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

helpers.php#722db_collegesearch_new1.38ms

select * from `default_meta_tags` where `module` = 'college' and `default_meta_tags`.`deleted_at` is null and `status` = 'active'

Bindings	0: college 1: active
Backtrace	app/helpers.php:722 vendor/laravel/framework/src/Illuminate/Container/Container.php:989 vendor/laravel/framework/src/Illuminate/Container/Container.php:819 vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048 vendor/laravel/framework/src/Illuminate/Container/Container.php:755

CollegeController.php#135db_collegesearch_new1.83ms

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` = 'national-academy-of-legal-studies-and-research-university-nalsar' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: national-academy-of-legal-studies-and-research-university-nalsar 2: active
Backtrace	app/Http/Controllers/CollegeController.php:135 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#135db_collegesearch_new1.44ms

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` in (13593) and `institute_programs`.`deleted_at` is null and `status` = 'active'

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

select `id`, `name` from `programs` where `programs`.`id` in (1449, 1450, 1529, 3411, 3440, 3479, 5253, 5254) and `programs`.`deleted_at` is null and `status` = 'active'

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

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

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

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (23885, 23886, 23887, 72172, 72173, 72174, 72175, 72176) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:135 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#135db_collegesearch_new6.24ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (23885, 23886, 23887, 72172, 72173, 72174, 72175, 72176) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

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

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (23885, 23886, 23887, 72172, 72173, 72174, 72175, 72176) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:135 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_new3.25ms

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

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

Institute.php#189db_collegesearch_new1.08ms

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

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

CollegeController.php#781db_collegesearch_new780μs

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 13593 and `institute_contents`.`institute_id` is not null and `type` = 'course-fees-specific' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 13593 1: course-fees-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:781 app/Http/Controllers/CollegeController.php:351 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#352db_collegesearch_new1.1ms

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 13593 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null

Bindings	0: 13593
Backtrace	app/Http/Controllers/CollegeController.php:352 app/Http/Controllers/CollegeController.php:145 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#352db_collegesearch_new2.42ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:352 app/Http/Controllers/CollegeController.php:145 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#817db_collegesearch_new1.45ms

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

Bindings	0: 13593 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:817 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#817db_collegesearch_new1.75msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:817
app/Http/Controllers/CollegeController.php:353
app/Http/Controllers/CollegeController.php:145
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#828db_collegesearch_new900μs

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

Bindings	0: 13593 1: active
Backtrace	app/Http/Controllers/CollegeController.php:828 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new910μs

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

Bindings	0: 13593 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:829 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#830db_collegesearch_new1.16ms

select `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 13593 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'

Bindings	0: 13593 1: active
Backtrace	app/Http/Controllers/CollegeController.php:830 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.76ms

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

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

Institute.php#138db_collegesearch_new1.29ms

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

Institute.php#151db_collegesearch_new1.16ms

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

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

Backtrace

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

Institute.php#138db_collegesearch_new1.1ms

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

Institute.php#151db_collegesearch_new1.57ms

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

Institute.php#151db_collegesearch_new1.62msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

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

Institute.php#138db_collegesearch_new2.25ms

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

Institute.php#151db_collegesearch_new1.51ms

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

Institute.php#151db_collegesearch_new2.1msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

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

CollegeController.php#426db_collegesearch_new1.47msselect * from `courses` where `slug` = 'ma' and `courses`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: ma 1: active
Backtrace	app/Http/Controllers/CollegeController.php:426 app/Http/Controllers/CollegeController.php:145 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#426db_collegesearch_new790μsselect * from `degrees` where `degrees`.`id` in (2) and `degrees`.`deleted_at` is null and `status` = 'Active'

Bindings	0: 2 1: Active
Backtrace	app/Http/Controllers/CollegeController.php:426 app/Http/Controllers/CollegeController.php:145 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#426db_collegesearch_new1.2msselect * from `streams` where `streams`.`id` in (12) and `streams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 12 1: active
Backtrace	app/Http/Controllers/CollegeController.php:426 app/Http/Controllers/CollegeController.php:145 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#430db_collegesearch_new1.17ms

select * from `institute_course_summaries` where (`institute_id` = 13593 and `course_id` = 20) and `institute_course_summaries`.`deleted_at` is null group by `course_id`

Bindings	0: 13593 1: 20
Backtrace	app/Http/Controllers/CollegeController.php:430 app/Http/Controllers/CollegeController.php:145 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#430db_collegesearch_new2.19msselect * from `courses` where `courses`.`id` in (20) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:430 app/Http/Controllers/CollegeController.php:145 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.9ms

select * from `institute_programs` where `id` in ('138904', '138905', '138906', '138907', '138908') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 138904 1: 138905 2: 138906 3: 138907 4: 138908 5: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:433 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new6.58ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (138904, 138905, 138906, 138907) 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:433 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#48db_collegesearch_new830μ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:433 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.66ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 13593 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 20 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1

Bindings	0: 13593 1: cs 2: nirf 3: 20 4: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:434 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#435db_collegesearch_new1.52ms

select * from `institute_programs` where (`course_id` = 20 and `institute_id` = 13593) and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 20 1: 13593 2: active
Backtrace	app/Http/Controllers/CollegeController.php:435 app/Http/Controllers/CollegeController.php:145 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#435db_collegesearch_new1.1ms

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

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

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:435 app/Http/Controllers/CollegeController.php:145 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#225db_collegesearch_new28.86ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 13593 and `faqs`.`faq_id` is not null and `sub_type` = 'course-fees-specific' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: 13593 2: course-fees-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:730 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#731db_collegesearch_new2.49ms

select * from `institute_ratings` where `institute_ratings`.`institute_id` = 13593 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 13593 1: active
Backtrace	app/Http/Controllers/CollegeController.php:731 app/Http/Controllers/CollegeController.php:145 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#732db_collegesearch_new1.47ms

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

Bindings	0: 13593 1: active
Backtrace	app/Http/Controllers/CollegeController.php:732 app/Http/Controllers/CollegeController.php:145 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#298db_collegesearch_new1.14ms

select `name`, `slug` from `courses` where `slug` = 'ma' and `courses`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: ma 1: active
Backtrace	app/Http/Controllers/CollegeController.php:298 app/Http/Controllers/CollegeController.php:164 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_new930μs

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

Bindings	0: 13593 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1044 app/Http/Controllers/CollegeController.php:165 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#1050db_collegesearch_new1.06ms

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` = 13593

Bindings	0: 13593
Backtrace	app/Http/Controllers/CollegeController.php:1050 app/Http/Controllers/CollegeController.php:165 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#496db_collegesearch_new2.45ms

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 '%course-fees-specific%' and `module_id` = 13593 and `expiry_date` > '2025-06-01 05:25:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-specific% 2: 13593 3: 2025-06-01 05:25:51
Backtrace	app/helpers.php:496 app/Http/Controllers/CollegeController.php:165 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#511db_collegesearch_new2.48ms

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 ('14', '21') and `expiry_date` > '2025-06-01 05:25:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 14 3: 21 4: 2025-06-01 05:25:51
Backtrace	app/helpers.php:511 app/Http/Controllers/CollegeController.php:165 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#525db_collegesearch_new2.43ms

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 ('42', '18', '9', '2', '20') and `sub_type` like '%about%' and `expiry_date` > '2025-06-01 05:25:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 42 2: 18 3: 9 4: 2 5: 20 6: %about% 7: 2025-06-01 05:25:51
Backtrace	app/helpers.php:525 app/Http/Controllers/CollegeController.php:165 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#896db_collegesearch_new810μs

select * from `meta_tags` where `slug` = 'colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma 1: active
Backtrace	app/Http/Controllers/CollegeController.php:896 app/Http/Controllers/CollegeController.php:197 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#157db_collegesearch_new1.19msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: active
Backtrace	app/helpers.php:157 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

App\Models\InstituteProgram: 18InstituteProgram.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramFeesSummary: 13InstituteProgramFeesSummary.php#?
App\Models\Program: 8Program.php#?
App\Models\Course: 8Course.php#?
App\Models\InstituteImage: 8InstituteImage.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\InstituteProgramPlacement: 4InstituteProgramPlacement.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\InstituteProgramExamMapping: 2InstituteProgramExamMapping.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\InstituteContent: 1InstituteContent.php#?
App\Models\Admin: 1Admin.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\InstituteCourseSummary: 1InstituteCourseSummary.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: MUBBWs2XmItUjBjbU3ceWUWkaI9S8U7AZMpCXOd5
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/national-academy-of-legal-studies-an...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma

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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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, 01 Jun 2025 05:25:51 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InU4WDBiSFdYMHROZDFST05WQlpBdVE9PSIsInZhbHVlIjoiU1ZIUmE1NS9wRkdEeHF0dmkyZHNNQ2RVQ0VSbGltL1g5M3pGU3U5MkJQTHRWd2RZMkN1WTJQd1BveldjVm83bE9yL2plcHcvSTA2eWJBOW4zZ0EzOXVnNERabVdOK2pyb3FNdDB0RHEzem4xNzdtUThSTDRWcGdtajJzN29XL0YiLCJtYWMiOiI0MTZmNTUyODkyNDhmMmFiZjdkMjZhYjI0MjQxZTRlMjU4Mzk0ODFhMmQ0MWVmM2IyMzMwYWVhYTc4NzA2YjNmIiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 07:25:51 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InU4WDBiSFdYMHROZDFST05WQlpBdVE9PSIsInZhbHVlIjoiU1ZIUmE1NS9wRkdEeHF0dmkyZHNNQ2RVQ0VSbGltL1g5M3pGU3U5MkJQTHRWd2RZMkN1WTJQd1BveldjVm83bE9yL2plc ▶"
    1 => "laravel_session=eyJpdiI6IlhMdXJmckhraEVDWEUzNE1BOGI5aWc9PSIsInZhbHVlIjoiWXlmTHlzZFNnSUNiZ0JxbVRXMU1zbHJ0cGQrMytGNGJwZW81MGNaclF1QXZJREIxbE9GMm5CVWNzcWkxNzd5cFoyK1VHcWNVdlVCVWJBanMxMTdrZU1hTTZXVm5UNDE3VFhPdVY2bndKTnZsczZ4RURNMitGbitkaTY4QXJadFkiLCJtYWMiOiJhZTM0OGU2MDhjOTVkMWQ0MDRjZjVmZTU1MjY5MDEyZDI0ZDExMWFiYThiODU3OWFiMmFmZTMwYjVmOTEyOGY5IiwidGFnIjoiIn0%3D; expires=Sun, 01 Jun 2025 07:25:51 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlhMdXJmckhraEVDWEUzNE1BOGI5aWc9PSIsInZhbHVlIjoiWXlmTHlzZFNnSUNiZ0JxbVRXMU1zbHJ0cGQrMytGNGJwZW81MGNaclF1QXZJREIxbE9GMm5CVWNzcWkxNzd5cFoy ▶"
    2 => "course_id=20; expires=Mon, 01 Jun 2026 05:25:51 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MA; expires=Mon, 01 Jun 2026 05:25:51 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B13593%5D; expires=Tue, 01 Jul 2025 05:25:51 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InU4WDBiSFdYMHROZDFST05WQlpBdVE9PSIsInZhbHVlIjoiU1ZIUmE1NS9wRkdEeHF0dmkyZHNNQ2RVQ0VSbGltL1g5M3pGU3U5MkJQTHRWd2RZMkN1WTJQd1BveldjVm83bE9yL2plcHcvSTA2eWJBOW4zZ0EzOXVnNERabVdOK2pyb3FNdDB0RHEzem4xNzdtUThSTDRWcGdtajJzN29XL0YiLCJtYWMiOiI0MTZmNTUyODkyNDhmMmFiZjdkMjZhYjI0MjQxZTRlMjU4Mzk0ODFhMmQ0MWVmM2IyMzMwYWVhYTc4NzA2YjNmIiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 07:25:51 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InU4WDBiSFdYMHROZDFST05WQlpBdVE9PSIsInZhbHVlIjoiU1ZIUmE1NS9wRkdEeHF0dmkyZHNNQ2RVQ0VSbGltL1g5M3pGU3U5MkJQTHRWd2RZMkN1WTJQd1BveldjVm83bE9yL2plc ▶"
    1 => "laravel_session=eyJpdiI6IlhMdXJmckhraEVDWEUzNE1BOGI5aWc9PSIsInZhbHVlIjoiWXlmTHlzZFNnSUNiZ0JxbVRXMU1zbHJ0cGQrMytGNGJwZW81MGNaclF1QXZJREIxbE9GMm5CVWNzcWkxNzd5cFoyK1VHcWNVdlVCVWJBanMxMTdrZU1hTTZXVm5UNDE3VFhPdVY2bndKTnZsczZ4RURNMitGbitkaTY4QXJadFkiLCJtYWMiOiJhZTM0OGU2MDhjOTVkMWQ0MDRjZjVmZTU1MjY5MDEyZDI0ZDExMWFiYThiODU3OWFiMmFmZTMwYjVmOTEyOGY5IiwidGFnIjoiIn0%3D; expires=Sun, 01-Jun-2025 07:25:51 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IlhMdXJmckhraEVDWEUzNE1BOGI5aWc9PSIsInZhbHVlIjoiWXlmTHlzZFNnSUNiZ0JxbVRXMU1zbHJ0cGQrMytGNGJwZW81MGNaclF1QXZJREIxbE9GMm5CVWNzcWkxNzd5cFoy ▶"
    2 => "course_id=20; expires=Mon, 01-Jun-2026 05:25:51 GMT; path=/"
    3 => "course_name=MA; expires=Mon, 01-Jun-2026 05:25:51 GMT; path=/"
    4 => "viewed_colleges=%5B13593%5D; expires=Tue, 01-Jul-2025 05:25:51 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "MUBBWs2XmItUjBjbU3ceWUWkaI9S8U7AZMpCXOd5"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-01 05:25:51	GET	/colleges/national-academy-of-legal-studies-and-research-university-nalsar/courses-fees/ma	12 53 102

MA in National Academy of Legal Studies and Research University (NALSAR), Hyderabad Branch-wise Fees, Fee Breakups, Eligibility

MA Programs Offered

Student's Rating for National Academy of Legal Studies and Research University (NALSAR), Hyderabad

Student's Reviews for National Academy of Legal Studies and Research University (NALSAR), Hyderabad

Gallery

Contact Details

1 x Application (96.01%)	189ms
1 x Booting (3.99%)	7.83ms