Bachelor of Computer Application (BCA) in Sai Group of Institutions, Dehradun Fees Breakup, Total Fees, Eligibility.

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Overview

Bachelor of Computer Application (BCA) is a 3 year course at Sai Group of Institutions, Dehradun. The total fees for Bachelor of Computer Application (BCA) at Sai Group of Institutions, Dehradun is 1,35,000. To get admission in Bachelor of Computer Application (BCA) at Sai Group of Institutions, Dehradun, students must meet some eligibility requirements, that is Candidate should have passed their 10+2 with minimum 45% marks with Maths as a compulsory subject from any recognized board.. This program helps students with the necessary skills to build a successful career in the Computer Applications.

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Highlights

Particular	Details
Total Seats	60
Course Fee	1,35,000
Duration	3 Years
Accepted Exams	TNEA, CBSE 12th Board Exam, CUET

About Bachelor of Computer Application (BCA)

Program Duration
Full Time ,3 Years

Course Type
UG , Computer Applications

Eligibility
Candidate should have passed their 10+2 with minimum 45% marks with Maths as a compulsory subject from any recognized board. Read More

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Fee Structure

Bachelor of Computer Application (BCA) fees for Sai Group of Institutions, Dehradun is further divided into categories like registration fees, tuition fees, hostel fees, other expenses, and total fees. We have mentioned these details in the table below:

Bachelor of Computer Application (BCA) Fee Breakup

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

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Eligibility

Students who are seeking admission in 3 year BCA Bachelor of Computer Application (BCA) program at the Sai Group of Institutions, Dehradun should meet the following eligibility criteria.

Candidate should have passed their 10+2 with minimum 45% marks with Maths as a compulsory subject from any recognized board.

Popular Exams

TNEA BCA

Exam Month

N/A

Accepting Colleges

Last Date to Apply

N/A

CBSE 12th Board Exam BCA

Exam Month

N/A

Accepting Colleges

Last Date to Apply

N/A

CUET BCA

Exam Month

May

Accepting Colleges

Last Date to Apply

08th May, 2025

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Admission Process

To take admission in Bachelor of Computer Application (BCA) at Sai Group of Institutions, Dehradun, candidates must possess a valid score in TNEA, CBSE 12th Board Exam, CUET or any other state-level examination.

Admission will be on the basis of the personal interview.

Bachelor of Computer Application (BCA) Fee Payment Options

Sai Group of Institutions, Dehradun fees for various courses should be paid by students at the time of counseling to confirm their admission:

The payment of fees should be made either in cash or a Demand Draft issued in favor of Sai Group of Institutions, Dehradun.
Candidates need to issue a draft in favor of the university to pay the course fee.
The university also accepts Internet banking or payment through debit and credit cards.
Candidates can directly transfer money from their bank account to the university's bank account through NEFT, RTGS, and IMPS without physically visiting the Sai Group of Institutions, Dehradun campus.
Delay in fee payment can cause a fine as per Sai Group of Institutions, Dehradun rules and regulations.

Sai Group of Institutions, Dehradun Fees Inquiry

Contact Information for students to find out more about the Sai Group of Institutions, Dehradun Fees

Contact Number - 2743300, 2743200 081, 7055002403
E-mail at: admissions@sipas.edu.in
Admission Block Address - 26A, Rajpur Road, Adjacent Hotel Meedo Grand

Bachelor of Computer Application (BCA) Sai Group of Institutions, Dehradun Top Recruiters

ranbaxy

Coca-Cola India

Mankind Pharma

Cadila Pharmaceuticals Ltd

Dr.Reddy’s Laboratories Ltd

ZEE NETWORK

IPCA LABS

Airtel

Amazon

Aon Hewitt

Barclays Technology

capegemini

CSC India

Daffodil Software

ERICSSION

Hughes Systique

IBM

Maintech Technologies

Mando

Just Dial

View All Recruiters Details

Student's Rating for Sai Group of Institutions, Dehradun

Student Reviews & Ratings

3/5 Based on 4 Verified Reviews

Component Ratings

Faculty Rating 3.8

Infrastructure Rating 4.7

Hostel Rating 4.2

Club Rating 3.5

Student's Reviews for Sai Group of Institutions, Dehradun

Admission

Placement

Faculty

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 5 Mess

Great location. Quality faculty. Practical training. All at very reasonable fees. Highly recommend for career-oriented professional courses. The institution has a phenomenal track record since 2003.

Placement: The institution has a tie-up with top hospitals, media houses and companies for internships and job placements.

Faculty: Senior faculty in all courses. Practical training.

Admission: Admission on both merit and entrance test. Varies according to course and seat availability.

Club: Music and dance club. Debating society is my favorite.

5 Overall 25-07-2021

Anonymous User
MBA Student

4 Infrastructure 3 Faculty 3.5 Hostel 3.5 Club 3 Mess

Pros: the staff is good and well educated, reputed college as per name Cons: No proper class is provided by the college, there are merge class held, no proper class is held

Placement: there no good placement provided and they are also 10% only.

Faculty: there are no proper facilities provided by the college.

Admission: College’s Internal Written Exam

3 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 3.5 Faculty 4 Hostel 3.5 Club 3.5 Mess

The infrastructure is nice. University library is one of the best libraries. Some departments are average like ECE, but some newly built departments are good like UBS department, CS department. The sports infrastructure of the university is very nice. The

Placement: This university has decent placement records in electronics and communication branch. Computer science placements are slightly better. The average package of ECE was 3 LPA, and CS was 3.5 LPA. Not many companies visit here, and frequent recruiters include

Faculty: The teachers are qualified but are not up to the mark. They don’t have teaching skills. They just mug up and vomit on the board, but some teachers are willing to teach and show interest in the subject. You can find some teachers annoying and some gr

Admission: Based on School / 12th Class Result

Club: Sports club is very good all games is more opportunity.

5 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 5 Mess

Great location. Quality faculty. Practical training. All at very reasonable fees. Highly recommend for career-oriented professional courses. The institution has a phenomenal track record since 2003.

Placement: The institution has a tie-up with top hospitals, media houses and companies for internships and job placements.

Faculty: Senior faculty in all courses. Practical training.

Admission: Admission on both merit and entrance test. Varies according to course and seat availability.

Club: Music and dance club. Debating society is my favorite.

3 Overall 25-07-2021

Anonymous User
MBA Student

5 Infrastructure 3.5 Faculty 4 Hostel 3.5 Club 3.5 Mess

Admission: Based on School / 12th Class Result

Club: Sports club is very good all games is more opportunity.

5 Overall 25-07-2021

Anonymous User
MBA Student

4 Infrastructure 3 Faculty 3.5 Hostel 3.5 Club 3 Mess

Pros: the staff is good and well educated, reputed college as per name Cons: No proper class is provided by the college, there are merge class held, no proper class is held

Placement: there no good placement provided and they are also 10% only.

Faculty: there are no proper facilities provided by the college.

Admission: College’s Internal Written Exam

View All 4 Reviews

Gallery

5 Images

Sai Group of Institutions, Dehradun Program Offered

View All Programs

Contact Details

Address

26A, Rajpur Road, Adjacent Hotel Meedo Grand

College Contact

27XXXXXX81

adXXXXXXin

Messages Timeline Exceptions Views13 Route Queries64 Models271 Mails Gate Session Request

Request history8.3.19241ms4MBGET {type}/{slug}/{tab}/{tab2}

Booting (8.52ms)time
Application (233ms)time
1 x Application (96.47%)
233ms
1 x Booting (3.53%)
8.52ms

13 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.videoslistingvideoslisting.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:41-169

64 statements were executed (7 duplicates)Show only duplicates152ms

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_new5.57ms

select * from `seo_redirects` where `redirect_from` = '/colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830' limit 1

Bindings	0: /colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830
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.44ms

select * from `meta_tags` where `slug` = 'colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830 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.13ms

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#66db_collegesearch_new1.3ms

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-group-of-institutions-dehradun' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: sai-group-of-institutions-dehradun 2: active
Backtrace	app/Http/Controllers/CollegeController.php:66 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#66db_collegesearch_new820μs

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

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

select `id`, `name` from `programs` where `programs`.`id` in (2274, 2280, 2317, 2775, 2783, 2786, 2791, 2796, 2802, 2816, 2822, 2832, 2847, 3423, 3458, 3491, 3588, 3599, 3622, 3652, 3653, 3743, 3777, 3837, 4483, 4764, 4773, 5058, 5064, 5065, 5115, 5205) and `programs`.`deleted_at` is null and `status` = 'active'

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

select `id`, `name` from `courses` where `courses`.`id` in (2, 7, 13, 21, 23, 25, 59, 60, 80, 81, 120) and `courses`.`deleted_at` is null and `status` = 'active'

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

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (36020, 36021, 36022, 36023, 36024, 36025, 36026, 36027, 36028, 36029, 36038, 36039, 36040, 78823, 78824, 78825, 78826, 78827, 78828, 78829, 78830, 78831, 78832, 78833, 78834, 78835, 78836, 78837, 78838, 78839, 78840, 78841) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

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

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (36020, 36021, 36022, 36023, 36024, 36025, 36026, 36027, 36028, 36029, 36038, 36039, 36040, 78823, 78824, 78825, 78826, 78827, 78828, 78829, 78830, 78831, 78832, 78833, 78834, 78835, 78836, 78837, 78838, 78839, 78840, 78841) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

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

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (36020, 36021, 36022, 36023, 36024, 36025, 36026, 36027, 36028, 36029, 36038, 36039, 36040, 78823, 78824, 78825, 78826, 78827, 78828, 78829, 78830, 78831, 78832, 78833, 78834, 78835, 78836, 78837, 78838, 78839, 78840, 78841) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

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

Institute.php#174db_collegesearch_new1.34ms

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

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

Institute.php#189db_collegesearch_new700μs

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

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

CollegeController.php#711db_collegesearch_new1.04ms

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 18016 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: 18016 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:711 app/Http/Controllers/CollegeController.php:281 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#282db_collegesearch_new1.66ms

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

Bindings	0: 18016
Backtrace	app/Http/Controllers/CollegeController.php:282 app/Http/Controllers/CollegeController.php:76 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#282db_collegesearch_new1.16ms

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:282 app/Http/Controllers/CollegeController.php:76 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#747db_collegesearch_new2.95ms

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

Bindings	0: 18016 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:747 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#758db_collegesearch_new2.76ms

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

Bindings	0: 18016 1: active
Backtrace	app/Http/Controllers/CollegeController.php:758 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new1.22ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 18016 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 18016 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:759 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#760db_collegesearch_new1.7ms

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

Bindings	0: 18016 1: active
Backtrace	app/Http/Controllers/CollegeController.php:760 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new2.36ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 18016 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 18016 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:285 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.01ms

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

Institute.php#151db_collegesearch_new1.68ms

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

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

Backtrace

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

Institute.php#138db_collegesearch_new1.94ms

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

Institute.php#151db_collegesearch_new980μs

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

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

Backtrace

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

Institute.php#138db_collegesearch_new2.06ms

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

Institute.php#151db_collegesearch_new1.36ms

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

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

Backtrace

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

CollegeController.php#499db_collegesearch_new1.33ms

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

Bindings	0: 18016 1: 78830 2: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new2.55ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new950μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new5.22msselect * from `courses` where `courses`.`id` in (13) and `courses`.`deleted_at` is null and `status` = 'active'

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

Bindings	0: 1 1: Active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new2.83msselect * 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:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new2.76ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new860μsselect * from `fees_types` where `fees_types`.`id` in (2)

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
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#499db_collegesearch_new1ms

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

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
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#499db_collegesearch_new3.01ms

select `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (2008, 2240, 2342) and `exams`.`deleted_at` is null and `status` = 'active'

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

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (2008, 2240, 2342) and exists (select * from `exam_features` where `exam_feature_mappings`.`exam_feature_id` = `exam_features`.`id` and `type` like '%date%' and `exam_features`.`deleted_at` is null and `status` = 'active') and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active'

Bindings	0: %date% 1: active 2: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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#499db_collegesearch_new2.08ms

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (2, 3, 9, 10, 11, 17) and `exam_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 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

Exam.php#58db_collegesearch_new4.79ms

select `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 2240 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 2240 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new3.7ms

select `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 2008 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 2008 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new1.6ms

select `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 2342 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 2342 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new1.58ms

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

Bindings	0: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#277db_collegesearch_new1.6ms

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

Bindings	0: 18016 1: cs 2: nirf 3: 13 4: active
Backtrace	app/Models/Institute.php:277 app/Http/Controllers/CollegeController.php:510 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#520db_collegesearch_new1.19ms

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

Bindings	0: 13 1: 18016 2: 78830 3: active
Backtrace	app/Http/Controllers/CollegeController.php:520 app/Http/Controllers/CollegeController.php:76 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#524db_collegesearch_new980μs

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

Bindings	0: 18016 1: active
Backtrace	app/Http/Controllers/CollegeController.php:524 app/Http/Controllers/CollegeController.php:76 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#524db_collegesearch_new8.71ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (9, 35, 60, 105, 911, 1638, 1760, 2057, 2146, 2952, 2999, 3102, 3287, 3504, 4804, 4976, 5180, 5738, 6266, 6389)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
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#524db_collegesearch_new790μs

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (5, 8, 12, 15, 30, 70, 93, 345)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
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#529db_collegesearch_new2.45ms

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

Bindings	0: 18016 1: 13 2: active
Backtrace	app/Http/Controllers/CollegeController.php:529 app/Http/Controllers/CollegeController.php:76 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#537db_collegesearch_new1.28ms

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 (78830) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 78830 1: active
Backtrace	app/Http/Controllers/CollegeController.php:537 app/Http/Controllers/CollegeController.php:76 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#226db_collegesearch_new27.62ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 18016 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: 18016 2: course-fees-program-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:226 app/Http/Controllers/CollegeController.php:660 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#661db_collegesearch_new1.47ms

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

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

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

Bindings	0: 18016 1: active
Backtrace	app/Http/Controllers/CollegeController.php:662 app/Http/Controllers/CollegeController.php:76 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#245db_collegesearch_new830μs

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

Bindings	0: 78830 1: active
Backtrace	app/Http/Controllers/CollegeController.php:245 app/Http/Controllers/CollegeController.php:95 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#245db_collegesearch_new910μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:245 app/Http/Controllers/CollegeController.php:95 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#974db_collegesearch_new1.51ms

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

Bindings	0: 18016 1: active
Backtrace	app/Http/Controllers/CollegeController.php:974 app/Http/Controllers/CollegeController.php:96 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#980db_collegesearch_new7.78ms

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

Bindings	0: 18016
Backtrace	app/Http/Controllers/CollegeController.php:980 app/Http/Controllers/CollegeController.php:96 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.06ms

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` = 18016 and `expiry_date` > '2025-07-22 22:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 18016 3: 2025-07-22 22:13:06
Backtrace	app/helpers.php:496 app/Http/Controllers/CollegeController.php:96 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.18ms

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 ('2342', '2008', '21', '47', '2240', '2025', '2233') and `expiry_date` > '2025-07-22 22:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 2342 3: 2008 4: 21 5: 47 6: 2240 7: 2025 8: 2233 9: 2025-07-22 22:13:06
Backtrace	app/helpers.php:511 app/Http/Controllers/CollegeController.php:96 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.01ms

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 ('25', '2', '80', '59', '23', '60', '13', '7', '21', '81', '120') and `sub_type` like '%about%' and `expiry_date` > '2025-07-22 22:13:06' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 25 2: 2 3: 80 4: 59 5: 23 6: 60 7: 13 8: 7 9: 21 10: 81 11: 120 12: %about% 13: 2025-07-22 22:13:06
Backtrace	app/helpers.php:525 app/Http/Controllers/CollegeController.php:96 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#826db_collegesearch_new990μs

select * from `meta_tags` where `slug` = 'colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830 1: active
Backtrace	app/Http/Controllers/CollegeController.php:826 app/Http/Controllers/CollegeController.php:128 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.22msselect * 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: 46InstituteProgram.php#?
App\Models\InstituteProgramFeesSummary: 33InstituteProgramFeesSummary.php#?
App\Models\Program: 32Program.php#?
App\Models\InstituteProgramPlacement: 20InstituteProgramPlacement.php#?
App\Models\InstituteRecruiter: 20InstituteRecruiter.php#?
App\Models\Recruiter: 20Recruiter.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\Course: 13Course.php#?
App\Models\InstituteImage: 10InstituteImage.php#?
App\Models\InstituteProgramExamMapping: 10InstituteProgramExamMapping.php#?
App\Models\ExamFeatureMapping: 9ExamFeatureMapping.php#?
App\Models\RecruiterIndustryType: 8RecruiterIndustryType.php#?
App\Models\ExamFeature: 7ExamFeature.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\User: 3User.php#?
App\Models\Exam: 3Exam.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#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: rcWQxF29bMhvVIa4Ci4gAapZrp1qzc6p811Po5ql
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/sai-group-of-institutions-dehradun/c...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "cookie" => array:1 [▶
    0 => "course_name=M.Tech%20%2F%20M.E.; course_id=1; XSRF-TOKEN=eyJpdiI6Ilg5RFhKcG1RUTRpVTRVM016VjFHM3c9PSIsInZhbHVlIjoidVhFcTJOblNhOXdEek1rUWlGZUI4TFhOaVducDFwZU9MRW1QZzY0MUtYcU9ROFRZUzVWVWd4TXhmRzFoY3prRTlQdGJEd0QzbENSaWtsRGE2K3YwSWlWdWVzUXdjbTNrMVlZWC9meTZYaWo4M2g3ekV3VjRlSy9ick9iV1o4SEgiLCJtYWMiOiJiOGQ0YjcyM2ZlZjUxNGZmODM0ODAzYjY2MmMxNGVlMTlhM2ZiMWRkYzM2ZmE0YTgxM2YzNDE5ZTJlNzA4ZGEwIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Ikh6czRzdjBlTHh6Mk1DZzNXU3dtWHc9PSIsInZhbHVlIjoibmV1dGpiaVMrZzJRcGw3dFM5VXRqVjE1Ky9zZStKQTVaNnB0dDc4NmhMdWc3empZdGt1bXIwNHRDOENHTXJFdDkxS2x1VjZLVXQzRlM1RUxCRG5sQWhIZzh4Rno2T1NEU2NvNEd4RTZGYmt1WkZBZ0p4bkpSelpoNzhYOUlrd2UiLCJtYWMiOiJlMzZkNWZiMmI3YzgwMTViMzYxZDAzN2I3N2U1OGNiMWNmNzUzZTZjMTEwOTJjZmU2ZjE0NDlhNWMxNWYxNmFhIiwidGFnIjoiIn0%3D; viewed_colleges=%5B36412%2C46472%5D ◀course_name=M.Tech%20%2F%20M.E.; course_id=1; XSRF-TOKEN=eyJpdiI6Ilg5RFhKcG1RUTRpVTRVM016VjFHM3c9PSIsInZhbHVlIjoidVhFcTJOblNhOXdEek1rUWlGZUI4TFhOaVducDFwZU9MRW1 ▶"
  ]
  "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

  0 of 0   
array:5 [▼
  "course_name" => "M.Tech / M.E."
  "course_id" => "1"
  "XSRF-TOKEN" => "rcWQxF29bMhvVIa4Ci4gAapZrp1qzc6p811Po5ql"
  "laravel_session" => "Tc1Aa6ccCr93IcGeyfvFXLy8c101bXG5q3ytZ6Gz"
  "viewed_colleges" => "[36412,46472]"
]

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 => "Tue, 22 Jul 2025 22:13:06 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InR3bzAvQlJqUExncEUwRWJjaFpLQlE9PSIsInZhbHVlIjoiZGdyQVNXT3N4anM4cHEwOXBDRnlNS1VkQkkyMXBTZStUNXdKbjBtNnljUGZYZjZvMFRQYStUcXNLNWhaV1hHYXJBNmVRdU1KNWU5SEhTMGZIVjBLQ3M2NEE1WlJ6dWtDMGR2bjFEWnNvU2lGSk11ZU9YZmpQaWtBejBIRlYwcVQiLCJtYWMiOiI2YjNkYzk2OWY2MmJjY2YzZDFmNmNlNjM1ZmNkMzRjZGMyYjA5NjQzYTU1MTQ5NzlmM2Y5MTU3NDI3OWZkMWI1IiwidGFnIjoiIn0%3D; expires=Wed, 23 Jul 2025 00:13:06 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InR3bzAvQlJqUExncEUwRWJjaFpLQlE9PSIsInZhbHVlIjoiZGdyQVNXT3N4anM4cHEwOXBDRnlNS1VkQkkyMXBTZStUNXdKbjBtNnljUGZYZjZvMFRQYStUcXNLNWhaV1hHYXJBNmVRd ▶"
    1 => "laravel_session=eyJpdiI6ImRFNyt5aGR1emg3MHFhYnRLa3Z2QVE9PSIsInZhbHVlIjoiQTNqMmFjQThVaGN6UGhLc2RselhIUVpvalo0Y1NWNGcwK0gzdWRwWGg4eWJwV3JvajNpcVlzOU82Rmpld01iRm5Jc2J5aWU5UFlmVjRaVmI5WFBleDRqMitvWnZTcFhtTGtDT01yYWxzOFhSTlBJU0NpMXVPWDZjQzFRdjF6TDMiLCJtYWMiOiIyZWJjZjM1ZDM3YTg1MDgyMTczOWMwY2VlMjhiZTM3MjM3OTFlZWViY2UyOTQ0OTA0ZmExZWExMTExYjM4YzUwIiwidGFnIjoiIn0%3D; expires=Wed, 23 Jul 2025 00:13:06 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImRFNyt5aGR1emg3MHFhYnRLa3Z2QVE9PSIsInZhbHVlIjoiQTNqMmFjQThVaGN6UGhLc2RselhIUVpvalo0Y1NWNGcwK0gzdWRwWGg4eWJwV3JvajNpcVlzOU82Rmpld01iRm5J ▶"
    2 => "course_id=13; expires=Wed, 22 Jul 2026 22:13:06 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=BCA; expires=Wed, 22 Jul 2026 22:13:06 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B36412%2C46472%2C18016%5D; expires=Thu, 21 Aug 2025 22:13:06 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InR3bzAvQlJqUExncEUwRWJjaFpLQlE9PSIsInZhbHVlIjoiZGdyQVNXT3N4anM4cHEwOXBDRnlNS1VkQkkyMXBTZStUNXdKbjBtNnljUGZYZjZvMFRQYStUcXNLNWhaV1hHYXJBNmVRdU1KNWU5SEhTMGZIVjBLQ3M2NEE1WlJ6dWtDMGR2bjFEWnNvU2lGSk11ZU9YZmpQaWtBejBIRlYwcVQiLCJtYWMiOiI2YjNkYzk2OWY2MmJjY2YzZDFmNmNlNjM1ZmNkMzRjZGMyYjA5NjQzYTU1MTQ5NzlmM2Y5MTU3NDI3OWZkMWI1IiwidGFnIjoiIn0%3D; expires=Wed, 23-Jul-2025 00:13:06 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InR3bzAvQlJqUExncEUwRWJjaFpLQlE9PSIsInZhbHVlIjoiZGdyQVNXT3N4anM4cHEwOXBDRnlNS1VkQkkyMXBTZStUNXdKbjBtNnljUGZYZjZvMFRQYStUcXNLNWhaV1hHYXJBNmVRd ▶"
    1 => "laravel_session=eyJpdiI6ImRFNyt5aGR1emg3MHFhYnRLa3Z2QVE9PSIsInZhbHVlIjoiQTNqMmFjQThVaGN6UGhLc2RselhIUVpvalo0Y1NWNGcwK0gzdWRwWGg4eWJwV3JvajNpcVlzOU82Rmpld01iRm5Jc2J5aWU5UFlmVjRaVmI5WFBleDRqMitvWnZTcFhtTGtDT01yYWxzOFhSTlBJU0NpMXVPWDZjQzFRdjF6TDMiLCJtYWMiOiIyZWJjZjM1ZDM3YTg1MDgyMTczOWMwY2VlMjhiZTM3MjM3OTFlZWViY2UyOTQ0OTA0ZmExZWExMTExYjM4YzUwIiwidGFnIjoiIn0%3D; expires=Wed, 23-Jul-2025 00:13:06 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImRFNyt5aGR1emg3MHFhYnRLa3Z2QVE9PSIsInZhbHVlIjoiQTNqMmFjQThVaGN6UGhLc2RselhIUVpvalo0Y1NWNGcwK0gzdWRwWGg4eWJwV3JvajNpcVlzOU82Rmpld01iRm5J ▶"
    2 => "course_id=13; expires=Wed, 22-Jul-2026 22:13:06 GMT; path=/"
    3 => "course_name=BCA; expires=Wed, 22-Jul-2026 22:13:06 GMT; path=/"
    4 => "viewed_colleges=%5B36412%2C46472%2C18016%5D; expires=Thu, 21-Aug-2025 22:13:06 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "rcWQxF29bMhvVIa4Ci4gAapZrp1qzc6p811Po5ql"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-22 22:13:06	GET	/colleges/sai-group-of-institutions-dehradun/courses-fees/bca-bachelor-of-computer-application-bca-78830	13 64 271

1 x Application (96.47%)	233ms
1 x Booting (3.53%)	8.52ms