Master of Computer Applications (MCA) in Sai School of Architecture, Amritsar Fees Breakup, Total Fees, Eligibility.

Particular	Details
Total Seats	60
Course Fee	1,65,000
Duration	2 Years
Accepted Exams	Not Mentioned

Fees (Rs.)	Year 1
Tuition Fees	₹ 75,000

Messages1 Timeline Exceptions Views10 Route Queries51 Models121 Mails Gate Session Request

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

warninglog[18:41:37] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...

Booting (13.58ms)time
Application (209ms)time
1 x Application (93.89%)
209ms
1 x Booting (6.1%)
13.58ms

10 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.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:104-202

51 statements were executed (4 duplicates)Show only duplicates112ms

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_new9ms

select * from `seo_redirects` where `redirect_from` = '/colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082' limit 1

Bindings	0: /colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082
Backtrace	app/Http/Middleware/SoftRedirects.php:22 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

MetaChecker.php#20db_collegesearch_new1.7ms

select * from `meta_tags` where `slug` = 'colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082 1: active
Backtrace	app/Http/Middleware/MetaChecker.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SoftRedirects.php:28 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51

CollegeController.php#129db_collegesearch_new2.89ms

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` = 'sai-school-of-architecture-amritsar' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: sai-school-of-architecture-amritsar 2: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new2.45ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new810μs

select `id`, `name` from `programs` where `programs`.`id` in (3404, 3411, 3423, 3437, 3458, 3475, 3711, 4530, 5130, 5239, 5736, 6197, 7225, 7234, 7472, 7481, 7515, 7616, 7630, 7680, 7693, 7716, 8406, 8451, 9982, 10030, 10117, 10214) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new1.61ms

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 7, 8, 10, 13, 15, 23, 40, 108, 117) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new3.55ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (97046, 97047, 97048, 97049, 97050, 97051, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97059, 97060, 97061, 97062, 97064, 97066, 97068, 97070, 97072, 97074, 97076, 97078, 97079, 97081, 97082) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new1.06ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (97046, 97047, 97048, 97049, 97050, 97051, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97059, 97060, 97061, 97062, 97064, 97066, 97068, 97070, 97072, 97074, 97076, 97078, 97079, 97081, 97082) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#129db_collegesearch_new2.57ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (97046, 97047, 97048, 97049, 97050, 97051, 97052, 97053, 97054, 97055, 97056, 97057, 97058, 97059, 97060, 97061, 97062, 97064, 97066, 97068, 97070, 97072, 97074, 97076, 97078, 97079, 97081, 97082) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:129 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

Institute.php#174db_collegesearch_new810μs

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

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

Institute.php#189db_collegesearch_new3.11ms

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

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

CollegeController.php#744db_collegesearch_new1.14ms

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

Bindings	0: 7412 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:744 app/Http/Controllers/CollegeController.php:314 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#315db_collegesearch_new2.07ms

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

Bindings	0: 7412
Backtrace	app/Http/Controllers/CollegeController.php:315 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#315db_collegesearch_new1.51ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:315 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#780db_collegesearch_new3.31ms

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

Bindings	0: 7412 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:780 app/Http/Controllers/CollegeController.php:316 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#791db_collegesearch_new2.11ms

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:791 app/Http/Controllers/CollegeController.php:316 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new4.73ms

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

Bindings	0: 7412 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:792 app/Http/Controllers/CollegeController.php:316 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#793db_collegesearch_new1.01ms

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:793 app/Http/Controllers/CollegeController.php:316 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.74ms

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

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

Institute.php#138db_collegesearch_new1.04ms

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

Institute.php#151db_collegesearch_new1.48ms

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

Institute.php#138db_collegesearch_new910μs

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

Institute.php#151db_collegesearch_new920μs

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

Institute.php#138db_collegesearch_new780μs

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

Institute.php#151db_collegesearch_new1.18ms

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

CollegeController.php#532db_collegesearch_new1.28ms

select * from `institute_programs` where `institute_id` = 7412 and `institute_programs`.`id` = '97082' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 7412 1: 97082 2: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new2.07ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new690μs

select `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (97082) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new990μsselect * from `courses` where `courses`.`id` in (8) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new1.23msselect * 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:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new760μsselect * from `streams` where `streams`.`id` in (10) and `streams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 10 1: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new600μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:532 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new480μsselect * from `fees_types` where `fees_types`.`id` in (2)

Backtrace

app/Http/Controllers/CollegeController.php:532
app/Http/Controllers/CollegeController.php:139
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#532db_collegesearch_new650μs

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (97082)

Backtrace

app/Http/Controllers/CollegeController.php:532
app/Http/Controllers/CollegeController.php:139
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#276db_collegesearch_new1.13ms

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

Bindings	0: 7412 1: cs 2: nirf 3: 8 4: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:543 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#553db_collegesearch_new1.25ms

select `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 8 and `institute_id` = 7412) and `id` != '97082' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3

Bindings	0: 8 1: 7412 2: 97082 3: active
Backtrace	app/Http/Controllers/CollegeController.php:553 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#557db_collegesearch_new860μs

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:557 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#562db_collegesearch_new2.71ms

select `id` from `institute_programs` where `institute_id` = 7412 and `course_id` = 8 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7412 1: 8 2: active
Backtrace	app/Http/Controllers/CollegeController.php:562 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#570db_collegesearch_new840μs

select institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (97082) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 97082 1: active
Backtrace	app/Http/Controllers/CollegeController.php:570 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#225db_collegesearch_new25.52ms

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

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

CollegeController.php#694db_collegesearch_new1.62ms

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:694 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#695db_collegesearch_new900μs

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:695 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#278db_collegesearch_new1.16ms

select `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '97082' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 97082 1: active
Backtrace	app/Http/Controllers/CollegeController.php:278 app/Http/Controllers/CollegeController.php:158 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#278db_collegesearch_new1.8ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:278 app/Http/Controllers/CollegeController.php:158 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#1007db_collegesearch_new2.66ms

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

Bindings	0: 7412 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1007 app/Http/Controllers/CollegeController.php:159 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#1013db_collegesearch_new1.47ms

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

Bindings	0: 7412
Backtrace	app/Http/Controllers/CollegeController.php:1013 app/Http/Controllers/CollegeController.php:159 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#491db_collegesearch_new1.78ms

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-program-specific%' and `module_id` = 7412 and `expiry_date` > '2025-04-12 18:41:37' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 7412 3: 2025-04-12 18:41:37
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:159 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#506db_collegesearch_new1.97ms

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 ('2009', '2008', '2342', '21') and `expiry_date` > '2025-04-12 18:41:37' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 2009 3: 2008 4: 2342 5: 21 6: 2025-04-12 18:41:37
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:159 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#520db_collegesearch_new1.85ms

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 ('23', '1', '15', '7', '13', '108', '40', '117', '10', '2', '8') and `sub_type` like '%about%' and `expiry_date` > '2025-04-12 18:41:37' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 23 2: 1 3: 15 4: 7 5: 13 6: 108 7: 40 8: 117 9: 10 10: 2 11: 8 12: %about% 13: 2025-04-12 18:41:37
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:159 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#859db_collegesearch_new1ms

select * from `meta_tags` where `slug` = 'colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082 1: active
Backtrace	app/Http/Controllers/CollegeController.php:859 app/Http/Controllers/CollegeController.php:171 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#156db_collegesearch_new1.59msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

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

App\Models\InstituteProgram: 42InstituteProgram.php#?
App\Models\Program: 28Program.php#?
App\Models\InstituteProgramFeesSummary: 22InstituteProgramFeesSummary.php#?
App\Models\Course: 13Course.php#?
App\Models\InstituteProgramExamMapping: 4InstituteProgramExamMapping.php#?
App\Models\Branding: 3Branding.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\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\InstituteProgramFee: 1InstituteProgramFee.php#?
App\Models\FeesType: 1FeesType.php#?

_token: Si6yQZ2hzNpPfQCgWwnqcwoHPPEAgau9h80MNAuq
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/sai-school-of-architecture-amritsar/...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 12 Apr 2025 18:41:37 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illodzh2MWV0aTVZK1p3aGt5ek12RlE9PSIsInZhbHVlIjoiUkhOcnBKbi8wOUJTVURNdlg1aVF3UkJvTS9jR3hFQWlrSDdRVlN6RzFjTjExbC9FaVBIeURXYzJURzFORDZSa3dJUVJaVHZtaGZzS0Y2VkFrQnhzSmdPdjk3UlRSWWQrS1ROUUI0MFc0QmVIbkVlYUNxVmdFWG83djRlTlVRNkMiLCJtYWMiOiI4ZTJmY2VmYTE1N2FmMzg2MjRjZWRiZDcxYmJkNTdmZmNkM2NjNTEwMTRhNWQ4MjE0MjE5NTlhNzcxOGM1NTlhIiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 20:41:37 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Illodzh2MWV0aTVZK1p3aGt5ek12RlE9PSIsInZhbHVlIjoiUkhOcnBKbi8wOUJTVURNdlg1aVF3UkJvTS9jR3hFQWlrSDdRVlN6RzFjTjExbC9FaVBIeURXYzJURzFORDZSa3dJUVJaV ▶"
    1 => "laravel_session=eyJpdiI6ImQ2SnlPUkJOS1QxVEVkMi9YclVUV0E9PSIsInZhbHVlIjoibHdqZHY0TDJJemxCL1VBZk9rNHRnVXRzSGlXV3Z2Y2RIb3UxYSsvVTBBOXVQU2hMUXVvdGg4YldMRm95dkFXRmJ0ZTJPWG1uRE1oR3hUNCtBdHJ6d05UT1RiWGtzZ0ozZElzeXlnckFPKzZQY0ZSc3ZkSy8xNXB4YUJ4SkpZYmkiLCJtYWMiOiJiOTFlNjBhNDg5NjhkYWFiZDdlNzg4MjZjMDdjYWRlZDRhZTFiYWM3ZjRiMGFjYjNmNWI3MjliM2RmZWJkOTFmIiwidGFnIjoiIn0%3D; expires=Sat, 12 Apr 2025 20:41:37 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImQ2SnlPUkJOS1QxVEVkMi9YclVUV0E9PSIsInZhbHVlIjoibHdqZHY0TDJJemxCL1VBZk9rNHRnVXRzSGlXV3Z2Y2RIb3UxYSsvVTBBOXVQU2hMUXVvdGg4YldMRm95dkFXRmJ0 ▶"
    2 => "course_id=8; expires=Sun, 12 Apr 2026 18:41:37 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MCA%20%2F%20MCM; expires=Sun, 12 Apr 2026 18:41:37 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B7412%5D; expires=Mon, 12 May 2025 18:41:37 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Illodzh2MWV0aTVZK1p3aGt5ek12RlE9PSIsInZhbHVlIjoiUkhOcnBKbi8wOUJTVURNdlg1aVF3UkJvTS9jR3hFQWlrSDdRVlN6RzFjTjExbC9FaVBIeURXYzJURzFORDZSa3dJUVJaVHZtaGZzS0Y2VkFrQnhzSmdPdjk3UlRSWWQrS1ROUUI0MFc0QmVIbkVlYUNxVmdFWG83djRlTlVRNkMiLCJtYWMiOiI4ZTJmY2VmYTE1N2FmMzg2MjRjZWRiZDcxYmJkNTdmZmNkM2NjNTEwMTRhNWQ4MjE0MjE5NTlhNzcxOGM1NTlhIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 20:41:37 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Illodzh2MWV0aTVZK1p3aGt5ek12RlE9PSIsInZhbHVlIjoiUkhOcnBKbi8wOUJTVURNdlg1aVF3UkJvTS9jR3hFQWlrSDdRVlN6RzFjTjExbC9FaVBIeURXYzJURzFORDZSa3dJUVJaV ▶"
    1 => "laravel_session=eyJpdiI6ImQ2SnlPUkJOS1QxVEVkMi9YclVUV0E9PSIsInZhbHVlIjoibHdqZHY0TDJJemxCL1VBZk9rNHRnVXRzSGlXV3Z2Y2RIb3UxYSsvVTBBOXVQU2hMUXVvdGg4YldMRm95dkFXRmJ0ZTJPWG1uRE1oR3hUNCtBdHJ6d05UT1RiWGtzZ0ozZElzeXlnckFPKzZQY0ZSc3ZkSy8xNXB4YUJ4SkpZYmkiLCJtYWMiOiJiOTFlNjBhNDg5NjhkYWFiZDdlNzg4MjZjMDdjYWRlZDRhZTFiYWM3ZjRiMGFjYjNmNWI3MjliM2RmZWJkOTFmIiwidGFnIjoiIn0%3D; expires=Sat, 12-Apr-2025 20:41:37 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImQ2SnlPUkJOS1QxVEVkMi9YclVUV0E9PSIsInZhbHVlIjoibHdqZHY0TDJJemxCL1VBZk9rNHRnVXRzSGlXV3Z2Y2RIb3UxYSsvVTBBOXVQU2hMUXVvdGg4YldMRm95dkFXRmJ0 ▶"
    2 => "course_id=8; expires=Sun, 12-Apr-2026 18:41:37 GMT; path=/"
    3 => "course_name=MCA+%2F+MCM; expires=Sun, 12-Apr-2026 18:41:37 GMT; path=/"
    4 => "viewed_colleges=%5B7412%5D; expires=Mon, 12-May-2025 18:41:37 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Si6yQZ2hzNpPfQCgWwnqcwoHPPEAgau9h80MNAuq"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-12 18:41:37	GET	/colleges/sai-school-of-architecture-amritsar/courses-fees/mca-master-of-computer-application-97082	1 10 51 121

Master of Computer Applications (MCA) in Sai School of Architecture, Amritsar Fees Breakup, Total Fees, Eligibility.

Master of Computer Applications (MCA) Sai School of Architecture, Amritsar Overview

Master of Computer Applications (MCA) Sai School of Architecture, Amritsar Highlights

Master of Computer Applications (MCA) Sai School of Architecture, Amritsar Fee Structure

Master of Computer Applications (MCA) Fee Breakup

Master of Computer Applications (MCA) Fee Payment Options

Sai School of Architecture, Amritsar Program Offered

Contact Details

1 x Application (93.89%)	209ms
1 x Booting (6.1%)	13.58ms