BBA with Aviation in Galgotias University Fees Breakup, Total Fees, Eligibility.

Particular	Details
Total Seats	N/A
Course Fee	75,000
Duration	3 Years
Accepted Exams	CBSE 12th Board Exam, CBSE 12th Board Exam, CUET

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

Messages1 Timeline Exceptions Views12 Route Queries66 Models810 Mails Gate Session Request

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

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

Booting (9.52ms)time
Application (259ms)time
1 x Application (96.45%)
259ms
1 x Booting (3.55%)
9.52ms

12 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.blade.php#?blade
components.total-reviewtotal-review.blade.php#?blade
components.detailed-reviewsdetailed-reviews.blade.php#?blade
components.registrationregistration.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.headerheader.blade.php#?blade
partials.footerfooter.blade.php#?blade
components.sucessesModalsucessesModal.blade.php#?blade
partials.bottomfooterbottomfooter.blade.php#?blade

uri: GET {type}/{slug}/{tab}/{tab2}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs2
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:110-238

66 statements were executed (9 duplicates)Show only duplicates145ms

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_new9.66ms

select * from `seo_redirects` where `redirect_from` = '/university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034' limit 1

Bindings	0: /university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034
Backtrace	app/Http/Middleware/SoftRedirects.php:22 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

MetaChecker.php#20db_collegesearch_new2.48ms

select * from `meta_tags` where `slug` = 'university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034 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.65ms

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

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

CollegeController.php#135db_collegesearch_new1.84ms

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` = 'galgotias-university-greater-noida' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: galgotias-university-greater-noida 2: active
Backtrace	app/Http/Controllers/CollegeController.php:135 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#135db_collegesearch_new2.56ms

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

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

CollegeController.php#135db_collegesearch_new1.99ms

select `id`, `name` from `programs` where `programs`.`id` in (14, 15, 16, 17, 22, 23, 24, 26, 33, 49, 51, 61, 79, 141, 264, 275, 281, 282, 283, 440, 444, 448, 460, 493, 662, 663, 679, 732, 759, 820, 837, 922, 933, 940, 956, 971, 1002, 1003, 1014, 1039, 1173, 1224, 1250, 1430, 1434, 1436, 1588, 1597, 1598, 1603, 1608, 1631, 1647, 1651, 1666, 1699, 1701, 1707, 1721, 1738, 1950, 1954, 2032, 2035, 2038, 2040, 2051, 2052, 2150, 2263, 2771, 2774, 2779, 2797, 2817, 2834, 2872, 2915, 2945, 3085, 3087, 3088, 3093, 3095, 3102, 3107, 3109, 3118, 3123, 3131, 3147, 3156, 3160, 3168, 3171, 3174, 3201, 3245, 3411, 3420, 3423, 3437, 3438, 3443, 3447, 3455, 3458, 3462, 3469, 3475, 3479, 3484, 3534, 3550, 3587, 3597, 3600, 3622, 3625, 3634, 3644, 3652, 4273, 4696, 4706, 4824, 4826, 4854, 4855, 4856, 4857, 4858, 4859, 4860, 5115, 5141, 5265, 5294, 5339, 5516, 5708, 6137, 6151, 6497, 6511, 6539, 6828, 6863, 7016, 7257, 7369, 7510, 7531, 7579, 8400, 9113, 9256, 10021, 10180) and `programs`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#135db_collegesearch_new1.4ms

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18, 19, 20, 21, 22, 23, 24, 25, 26, 33, 40, 43, 45, 59, 80, 81, 92, 93, 119, 137) and `courses`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#135db_collegesearch_new4.19ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (26469, 26470, 26471, 26472, 26473, 26474, 26475, 26476, 26477, 26478, 26479, 26480, 26481, 26482, 26483, 26484, 26485, 26486, 26487, 26488, 26489, 26490, 26491, 26492, 26561, 26562, 26563, 26564, 26565, 26566, 26567, 26568, 26574, 26575, 26576, 26577, 26578, 26579, 26580, 68008, 68009, 68010, 68011, 68012, 68013, 68014, 68015, 68016, 68017, 68018, 68019, 68020, 68021, 68022, 68023, 68024, 68025, 68026, 68027, 68028, 68029, 68030, 68031, 68032, 68033, 68034, 110116, 110117, 110118, 110119, 110120, 110121, 110122, 110123, 110124, 110125, 110126, 110127, 110128, 110129, 110130, 110131, 110132, 110133, 110134, 110135, 110136, 110137, 110138, 110139, 110140, 110141, 110142, 110143, 110144, 110145, 110146, 110147, 110148, 110149, 110150, 110151, 110152, 110153, 110154, 110159, 110160, 110161, 110162, 110163, 110164, 110165, 110166, 110167, 110168, 110169, 110170, 110171, 110172, 110173, 110174, 110175, 110176, 110177, 110178, 110179, 110180, 110181, 110182, 110183, 110184, 110185, 110186, 110196, 110197, 110198, 110199, 110200, 110201, 110202, 110203, 110204, 110205, 110206, 110207, 110208, 110209, 110210, 110211, 110212, 110213, 110214, 110215, 110216, 110217, 110218, 110219, 110220, 110221) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#135db_collegesearch_new4.44ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (26469, 26470, 26471, 26472, 26473, 26474, 26475, 26476, 26477, 26478, 26479, 26480, 26481, 26482, 26483, 26484, 26485, 26486, 26487, 26488, 26489, 26490, 26491, 26492, 26561, 26562, 26563, 26564, 26565, 26566, 26567, 26568, 26574, 26575, 26576, 26577, 26578, 26579, 26580, 68008, 68009, 68010, 68011, 68012, 68013, 68014, 68015, 68016, 68017, 68018, 68019, 68020, 68021, 68022, 68023, 68024, 68025, 68026, 68027, 68028, 68029, 68030, 68031, 68032, 68033, 68034, 110116, 110117, 110118, 110119, 110120, 110121, 110122, 110123, 110124, 110125, 110126, 110127, 110128, 110129, 110130, 110131, 110132, 110133, 110134, 110135, 110136, 110137, 110138, 110139, 110140, 110141, 110142, 110143, 110144, 110145, 110146, 110147, 110148, 110149, 110150, 110151, 110152, 110153, 110154, 110159, 110160, 110161, 110162, 110163, 110164, 110165, 110166, 110167, 110168, 110169, 110170, 110171, 110172, 110173, 110174, 110175, 110176, 110177, 110178, 110179, 110180, 110181, 110182, 110183, 110184, 110185, 110186, 110196, 110197, 110198, 110199, 110200, 110201, 110202, 110203, 110204, 110205, 110206, 110207, 110208, 110209, 110210, 110211, 110212, 110213, 110214, 110215, 110216, 110217, 110218, 110219, 110220, 110221) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#135db_collegesearch_new1.54ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (26469, 26470, 26471, 26472, 26473, 26474, 26475, 26476, 26477, 26478, 26479, 26480, 26481, 26482, 26483, 26484, 26485, 26486, 26487, 26488, 26489, 26490, 26491, 26492, 26561, 26562, 26563, 26564, 26565, 26566, 26567, 26568, 26574, 26575, 26576, 26577, 26578, 26579, 26580, 68008, 68009, 68010, 68011, 68012, 68013, 68014, 68015, 68016, 68017, 68018, 68019, 68020, 68021, 68022, 68023, 68024, 68025, 68026, 68027, 68028, 68029, 68030, 68031, 68032, 68033, 68034, 110116, 110117, 110118, 110119, 110120, 110121, 110122, 110123, 110124, 110125, 110126, 110127, 110128, 110129, 110130, 110131, 110132, 110133, 110134, 110135, 110136, 110137, 110138, 110139, 110140, 110141, 110142, 110143, 110144, 110145, 110146, 110147, 110148, 110149, 110150, 110151, 110152, 110153, 110154, 110159, 110160, 110161, 110162, 110163, 110164, 110165, 110166, 110167, 110168, 110169, 110170, 110171, 110172, 110173, 110174, 110175, 110176, 110177, 110178, 110179, 110180, 110181, 110182, 110183, 110184, 110185, 110186, 110196, 110197, 110198, 110199, 110200, 110201, 110202, 110203, 110204, 110205, 110206, 110207, 110208, 110209, 110210, 110211, 110212, 110213, 110214, 110215, 110216, 110217, 110218, 110219, 110220, 110221) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

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

Institute.php#174db_collegesearch_new1.01ms

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

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

Institute.php#189db_collegesearch_new2.36ms

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

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

CollegeController.php#780db_collegesearch_new2.09ms

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

CollegeController.php#351db_collegesearch_new850μs

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

Bindings	0: 11749
Backtrace	app/Http/Controllers/CollegeController.php:351 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#351db_collegesearch_new1.19ms

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

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

CollegeController.php#816db_collegesearch_new1.58ms

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

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

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

Backtrace

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

CollegeController.php#827db_collegesearch_new1.52ms

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

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

Institute.php#209db_collegesearch_new840μs

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

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

CollegeController.php#829db_collegesearch_new1.52ms

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

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

Institute.php#209db_collegesearch_new960μs

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

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

Institute.php#138db_collegesearch_new1.32ms

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

Institute.php#151db_collegesearch_new1.28ms

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

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

Backtrace

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

Institute.php#138db_collegesearch_new1.15ms

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

Institute.php#151db_collegesearch_new3.12ms

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

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

Backtrace

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

Institute.php#138db_collegesearch_new1.14ms

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

Institute.php#151db_collegesearch_new1.68ms

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

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

Backtrace

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

CollegeController.php#568db_collegesearch_new1.24ms

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

Bindings	0: 11749 1: 68034 2: active
Backtrace	app/Http/Controllers/CollegeController.php:568 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#568db_collegesearch_new660μs

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

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

CollegeController.php#568db_collegesearch_new670μs

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

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

CollegeController.php#568db_collegesearch_new2.72msselect * from `courses` where `courses`.`id` in (7) and `courses`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#568db_collegesearch_new960μsselect * 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:568 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#568db_collegesearch_new2.24msselect * from `streams` where `streams`.`id` in (2) and `streams`.`deleted_at` is null and `status` = 'active'

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

CollegeController.php#568db_collegesearch_new900μs

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

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

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

Backtrace

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

CollegeController.php#568db_collegesearch_new1.97ms

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

Backtrace

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

CollegeController.php#568db_collegesearch_new990μs

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

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

CollegeController.php#568db_collegesearch_new1.64ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (2008, 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:568 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#568db_collegesearch_new1.02ms

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:568 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Exam.php#58db_collegesearch_new1.32ms

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:569 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new2.32ms

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:569 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new3ms

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:569 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new650μs

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:569 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.22ms

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

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

CollegeController.php#589db_collegesearch_new2.38ms

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

Bindings	0: 7 1: 11749 2: 68034 3: active
Backtrace	app/Http/Controllers/CollegeController.php:589 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#589db_collegesearch_new2.31ms

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

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

CollegeController.php#593db_collegesearch_new960μs

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

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

CollegeController.php#593db_collegesearch_new3.29ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (12, 60, 106, 112, 121, 593, 627, 911, 930, 1002, 1099, 1600, 1805, 2118, 3010, 3037, 3047, 3102, 3132, 3161, 3504, 5198, 6239)

Backtrace

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

CollegeController.php#593db_collegesearch_new1.02ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 4, 5, 8, 13, 15, 16, 41, 50, 63, 93, 212, 345)

Backtrace

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

CollegeController.php#598db_collegesearch_new2.61ms

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

Bindings	0: 11749 1: 7 2: active
Backtrace	app/Http/Controllers/CollegeController.php:598 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#606db_collegesearch_new990μ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 (26482, 68023, 68026, 68027, 68028, 68034, 110120, 110121, 110122, 110127, 110128) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 26482 1: 68023 2: 68026 3: 68027 4: 68028 5: 68034 6: 110120 7: 110121 8: 110122 9: 110127 10: 110128 11: active
Backtrace	app/Http/Controllers/CollegeController.php:606 app/Http/Controllers/CollegeController.php:145 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#225db_collegesearch_new25.98ms

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

CollegeController.php#730db_collegesearch_new1.79ms

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

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

CollegeController.php#731db_collegesearch_new790μs

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

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

CollegeController.php#314db_collegesearch_new2.04ms

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

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

CollegeController.php#314db_collegesearch_new1.01ms

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

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

CollegeController.php#1043db_collegesearch_new2.08ms

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

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

CollegeController.php#1049db_collegesearch_new1.69ms

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

Bindings	0: 11749
Backtrace	app/Http/Controllers/CollegeController.php:1049 app/Http/Controllers/CollegeController.php:165 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#496db_collegesearch_new3.35ms

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` = 11749 and `expiry_date` > '2025-05-22 23:15:23' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 11749 3: 2025-05-22 23:15:23
Backtrace	app/helpers.php:496 app/Http/Controllers/CollegeController.php:165 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#511db_collegesearch_new2.28ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('2008', '2342', '21', '117', '161', '2198', '131', '2343', '2240', '2022') and `expiry_date` > '2025-05-22 23:15:23' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 2008 3: 2342 4: 21 5: 117 6: 161 7: 2198 8: 131 9: 2343 10: 2240 11: 2022 12: 2025-05-22 23:15:23
Backtrace	app/helpers.php:511 app/Http/Controllers/CollegeController.php:165 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#525db_collegesearch_new2.43ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%course%' and `module_id` in ('23', '1', '7', '10', '21', '19', '25', '20', '24', '80', '12', '13', '9', '11', '59', '8', '2', '45', '6', '18', '14', '81', '15', '92', '93', '33', '119', '40', '22', '26', '137', '43') and `sub_type` like '%about%' and `expiry_date` > '2025-05-22 23:15:23' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 23 2: 1 3: 7 4: 10 5: 21 6: 19 7: 25 8: 20 9: 24 10: 80 11: 12 12: 13 13: 9 14: 11 15: 59 16: 8 17: 2 18: 45 19: 6 20: 18 21: 14 22: 81 23: 15 24: 92 25: 93 26: 33 27: 119 28: 40 29: 22 30: 26 31: 137 32: 43 33: %about% 34: 2025-05-22 23:15:23
Backtrace	app/helpers.php:525 app/Http/Controllers/CollegeController.php:165 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#895db_collegesearch_new1.15ms

select * from `meta_tags` where `slug` = 'university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034 1: active
Backtrace	app/Http/Controllers/CollegeController.php:895 app/Http/Controllers/CollegeController.php:197 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#157db_collegesearch_new710μsselect * 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: 207InstituteProgram.php#?
App\Models\InstituteProgramFeesSummary: 163InstituteProgramFeesSummary.php#?
App\Models\Program: 159Program.php#?
App\Models\InstituteProgramPlacement: 95InstituteProgramPlacement.php#?
App\Models\Course: 34Course.php#?
App\Models\InstituteRecruiter: 23InstituteRecruiter.php#?
App\Models\Recruiter: 23Recruiter.php#?
App\Models\InstituteImage: 16InstituteImage.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramExamMapping: 13InstituteProgramExamMapping.php#?
App\Models\RecruiterIndustryType: 13RecruiterIndustryType.php#?
App\Models\ExamFeatureMapping: 9ExamFeatureMapping.php#?
App\Models\InstituteContent: 8InstituteContent.php#?
App\Models\ExamFeature: 7ExamFeature.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Admin: 2Admin.php#?
App\Models\Exam: 2Exam.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\InstituteFaculty: 1InstituteFaculty.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: Huwq5b91nig45QfIiWftDKD5dxWrQqHaYAdqThYV
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/university/galgotias-university-greater-noida...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034

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 => "XSRF-TOKEN=eyJpdiI6Ikovby94N05KUnlqUzdTek1YZWg5Y2c9PSIsInZhbHVlIjoialpYSDBLTzVTOEF3dlZnYnFrcUVNcWRuWno2RlZIRlkvVXhYSi9kWVdITS9DUzNDNEN0S3BhOURTem43Z2NZZWJyZ2Q1SUlxaVY0UjB0WVQrNGlheDFiN0lZN1lWTUdWSWdXRy9LcndkdUdpdm40M2tyL2Y5OTNWOTZTUFhkYVUiLCJtYWMiOiJkMTg1M2FjYTU3Mjc1YzZhNDc2MWY2ZDEwMzJjZDAxZWEwM2I0MGEyOGI3ZGUwOTY2MjJiZTBlOTc4NjUzYWE2IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IndvRTBQY3ZPUmhmVUFiV1hhY2l2b0E9PSIsInZhbHVlIjoiT0ZFMlNVUldzT0dFMURlWEpwczhZc0p5eXliNlRCLzZ5cHk4Z1JHYitlQXY4c3ozYjl1aHllYkVtNG4yOGlLQjNBVjdvNlJjSTB2OUV5bUpXSVQ4ak9sSEE5RlJvV2NIV3lSdzgxQ2VVR0V6S3FycVpRZWUzTXU0NjVWeTZRNEciLCJtYWMiOiI5YWFkOTVkNzhkNzU5ZDFhMDgxMTI2OTM1MDc2M2I0MWVmYzNkYzg3YjU5ZWE2ZmViZDI4ODFiYmU1NDQ3ZDYyIiwidGFnIjoiIn0%3D; course_id=74; course_name=Polytechnic%20Course; viewed_colleges=%5B19546%2C8663%5D ◀XSRF-TOKEN=eyJpdiI6Ikovby94N05KUnlqUzdTek1YZWg5Y2c9PSIsInZhbHVlIjoialpYSDBLTzVTOEF3dlZnYnFrcUVNcWRuWno2RlZIRlkvVXhYSi9kWVdITS9DUzNDNEN0S3BhOURTem43Z2NZZWJyZ2Q1S ▶"
  ]
  "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 [▼
  "XSRF-TOKEN" => "Huwq5b91nig45QfIiWftDKD5dxWrQqHaYAdqThYV"
  "laravel_session" => "rJpe3ySgEj5QKhEGVTAsnT7ZmJUQ5s8z7logG5cQ"
  "course_id" => "74"
  "course_name" => "Polytechnic Course"
  "viewed_colleges" => "[19546,8663]"
]

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 => "Thu, 22 May 2025 23:15:23 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjA2RVNIallaUnhqeDF4ZGxNT09rZGc9PSIsInZhbHVlIjoiZzBJRFMxVWJHL1dQVXU0dDVEVkpFaDdJaXYxRzgxTCtuNmJPeFNFUTlLQTdLTkFtQVI2eC9Mb0poTlpsZG1Xc04rd0dTNVpmZlRPckRyZnRFcGJRWkY5WWNXLzlWdnA1SWRCZzN0SHVjSnFNSVNwQ0Q5Ylc5YnNCbWJxRW1KUjIiLCJtYWMiOiI5Mzg0YWYzMTQ1MzM1NjQxMzQyZDdiZmEzMWQzOTk3ZmQ2ZmU3NjVlYjRkYjNlMjkzYmFlNjhhYjc1NjFiZmRhIiwidGFnIjoiIn0%3D; expires=Fri, 23 May 2025 01:15:23 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjA2RVNIallaUnhqeDF4ZGxNT09rZGc9PSIsInZhbHVlIjoiZzBJRFMxVWJHL1dQVXU0dDVEVkpFaDdJaXYxRzgxTCtuNmJPeFNFUTlLQTdLTkFtQVI2eC9Mb0poTlpsZG1Xc04rd0dTN ▶"
    1 => "laravel_session=eyJpdiI6ImUvRXFMU09GNEVUNFU5QldXREk2K1E9PSIsInZhbHVlIjoiY2o0QnFkc2ZiTkN6K1g3M1MzYmRNQnlITUFNZGw0UkFnNmdyems2YWlMNFRhblBPUXhSVDFuLzdhdzRnTU1hcHh3bEJuUTJiRGl0Y041RTlObjE3eEx2OHBhTlRSNlhqZmRmVktxSHFYV1NiSU9aQlQya0hmdUpoRHlWU2Q4U2ciLCJtYWMiOiJjOGZmYWZmNDJjNjc4ZGQ3ZTUzYzQxMjE0MWY3NTQ3NGE5Y2MyODc3ZDI3MjgxZTBmNTI2Zjg2YTM5NDZmY2VhIiwidGFnIjoiIn0%3D; expires=Fri, 23 May 2025 01:15:23 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImUvRXFMU09GNEVUNFU5QldXREk2K1E9PSIsInZhbHVlIjoiY2o0QnFkc2ZiTkN6K1g3M1MzYmRNQnlITUFNZGw0UkFnNmdyems2YWlMNFRhblBPUXhSVDFuLzdhdzRnTU1hcHh3 ▶"
    2 => "course_id=7; expires=Fri, 22 May 2026 23:15:23 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=BBA%20%2F%20BBM%20%2F%20BBS; expires=Fri, 22 May 2026 23:15:23 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B19546%2C8663%2C11749%5D; expires=Sat, 21 Jun 2025 23:15:23 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjA2RVNIallaUnhqeDF4ZGxNT09rZGc9PSIsInZhbHVlIjoiZzBJRFMxVWJHL1dQVXU0dDVEVkpFaDdJaXYxRzgxTCtuNmJPeFNFUTlLQTdLTkFtQVI2eC9Mb0poTlpsZG1Xc04rd0dTNVpmZlRPckRyZnRFcGJRWkY5WWNXLzlWdnA1SWRCZzN0SHVjSnFNSVNwQ0Q5Ylc5YnNCbWJxRW1KUjIiLCJtYWMiOiI5Mzg0YWYzMTQ1MzM1NjQxMzQyZDdiZmEzMWQzOTk3ZmQ2ZmU3NjVlYjRkYjNlMjkzYmFlNjhhYjc1NjFiZmRhIiwidGFnIjoiIn0%3D; expires=Fri, 23-May-2025 01:15:23 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjA2RVNIallaUnhqeDF4ZGxNT09rZGc9PSIsInZhbHVlIjoiZzBJRFMxVWJHL1dQVXU0dDVEVkpFaDdJaXYxRzgxTCtuNmJPeFNFUTlLQTdLTkFtQVI2eC9Mb0poTlpsZG1Xc04rd0dTN ▶"
    1 => "laravel_session=eyJpdiI6ImUvRXFMU09GNEVUNFU5QldXREk2K1E9PSIsInZhbHVlIjoiY2o0QnFkc2ZiTkN6K1g3M1MzYmRNQnlITUFNZGw0UkFnNmdyems2YWlMNFRhblBPUXhSVDFuLzdhdzRnTU1hcHh3bEJuUTJiRGl0Y041RTlObjE3eEx2OHBhTlRSNlhqZmRmVktxSHFYV1NiSU9aQlQya0hmdUpoRHlWU2Q4U2ciLCJtYWMiOiJjOGZmYWZmNDJjNjc4ZGQ3ZTUzYzQxMjE0MWY3NTQ3NGE5Y2MyODc3ZDI3MjgxZTBmNTI2Zjg2YTM5NDZmY2VhIiwidGFnIjoiIn0%3D; expires=Fri, 23-May-2025 01:15:23 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImUvRXFMU09GNEVUNFU5QldXREk2K1E9PSIsInZhbHVlIjoiY2o0QnFkc2ZiTkN6K1g3M1MzYmRNQnlITUFNZGw0UkFnNmdyems2YWlMNFRhblBPUXhSVDFuLzdhdzRnTU1hcHh3 ▶"
    2 => "course_id=7; expires=Fri, 22-May-2026 23:15:23 GMT; path=/"
    3 => "course_name=BBA+%2F+BBM+%2F+BBS; expires=Fri, 22-May-2026 23:15:23 GMT; path=/"
    4 => "viewed_colleges=%5B19546%2C8663%2C11749%5D; expires=Sat, 21-Jun-2025 23:15:23 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Huwq5b91nig45QfIiWftDKD5dxWrQqHaYAdqThYV"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-22 23:15:23	GET	/university/galgotias-university-greater-noida/courses-fees/bba-bba-with-aviation-68034	1 12 66 810

BBA with Aviation in Galgotias University Fees Breakup, Total Fees, Eligibility.

BBA with Aviation Galgotias University Overview

BBA with Aviation Galgotias University Highlights

BBA with Aviation Galgotias University Fee Structure

BBA with Aviation Fee Breakup

Popular Exams

BBA with Aviation Fee Payment Options

BBA with Aviation Placement in Galgotias University

BBA with Aviation Galgotias University Top Recruiters

Student's Rating for Galgotias University

Student's Reviews for Galgotias University

Gallery

Galgotias University Program Offered

Contact Details

1 x Application (96.45%)	259ms
1 x Booting (3.55%)	9.52ms