BSc in Joy University, Kanyakumari Branch-wise Fees, Fee Breakups, Eligibility

Messages Timeline Exceptions Views15 Route Queries57 Models394 Mails Gate Session Request

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

Booting (10.51ms)time
Application (248ms)time
1 x Application (95.94%)
248ms
1 x Booting (4.06%)
10.51ms

15 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.blade.php#?blade
components.new-updatesnew-updates.blade.php#?blade
components.ask-aiask-ai.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

57 statements were executed (6 duplicates)Show only duplicates154ms

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_new10.32msselect * from `seo_redirects` where `redirect_from` = '/colleges/joy-university-kanyakumari/courses-fees/bsc' limit 1

Bindings	0: /colleges/joy-university-kanyakumari/courses-fees/bsc
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_new950μs

select * from `meta_tags` where `slug` = 'colleges/joy-university-kanyakumari/courses-fees/bsc' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/joy-university-kanyakumari/courses-fees/bsc 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#726db_collegesearch_new1.93ms

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:726 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.51ms

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

Bindings	0: active 1: joy-university-kanyakumari 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_new2.96ms

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 (34467) 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_new1.47ms

select `id`, `name` from `programs` where `programs`.`id` in (14, 17, 19, 20, 22, 23, 25, 32, 79, 94, 126, 153, 187, 201, 268, 360, 440, 441, 444, 446, 447, 454, 477, 598, 662, 663, 672, 711, 725, 787, 793, 800, 804, 920, 936, 943, 967, 988, 1039, 1092, 1096, 1153, 1160, 1165, 1228, 1251, 1256, 1270, 2264, 2267, 2279, 2291, 2313, 2437, 2574, 2597, 2602, 2604, 2608, 2783, 3440, 3443, 3462, 3484, 3587, 3591, 3652, 3653, 4428, 4527, 4579, 5397, 5595) 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.19ms

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 6, 7, 8, 9, 10, 11, 13, 19, 21, 23, 24, 25, 33, 59, 60, 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_new2.81ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (41904, 41905, 41906, 41907, 41908, 41909, 41910, 41911, 41912, 41913, 41914, 41915, 41916, 41917, 41918, 41919, 41920, 41921, 41922, 41923, 41924, 41925, 41926, 41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938, 41939, 41940, 41941, 41942, 41943, 41944, 41945, 41946, 41947, 41948, 41949, 41950, 41951, 41952, 41953, 41954, 41955, 41956, 41957, 41958, 41959, 41960, 41961, 41962, 44323, 83156, 83157, 83158, 83159, 83160, 83161, 83162, 83163, 83164, 83165, 83166, 83167, 83168) 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_new2.73ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (41904, 41905, 41906, 41907, 41908, 41909, 41910, 41911, 41912, 41913, 41914, 41915, 41916, 41917, 41918, 41919, 41920, 41921, 41922, 41923, 41924, 41925, 41926, 41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938, 41939, 41940, 41941, 41942, 41943, 41944, 41945, 41946, 41947, 41948, 41949, 41950, 41951, 41952, 41953, 41954, 41955, 41956, 41957, 41958, 41959, 41960, 41961, 41962, 44323, 83156, 83157, 83158, 83159, 83160, 83161, 83162, 83163, 83164, 83165, 83166, 83167, 83168) 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.44ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (41904, 41905, 41906, 41907, 41908, 41909, 41910, 41911, 41912, 41913, 41914, 41915, 41916, 41917, 41918, 41919, 41920, 41921, 41922, 41923, 41924, 41925, 41926, 41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938, 41939, 41940, 41941, 41942, 41943, 41944, 41945, 41946, 41947, 41948, 41949, 41950, 41951, 41952, 41953, 41954, 41955, 41956, 41957, 41958, 41959, 41960, 41961, 41962, 44323, 83156, 83157, 83158, 83159, 83160, 83161, 83162, 83163, 83164, 83165, 83166, 83167, 83168) 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.24ms

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

Bindings	0: 247 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_new1.8ms

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

Bindings	0: 93 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_new2.16ms

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

Bindings	0: 34467 1: course-fees-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_new2.74ms

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

Bindings	0: 34467
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_new830μs

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_new1.05ms

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

Bindings	0: 34467 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#747db_collegesearch_new720μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261) and `admins`.`deleted_at` is null

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_new1.55ms

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

Bindings	0: 34467 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_new830μs

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 34467 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: 34467 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_new910μs

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

Bindings	0: 34467 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_new1.14ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 34467 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: 34467 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.47ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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_new2.06ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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#138db_collegesearch_new5.26ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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_new2.99ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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#138db_collegesearch_new5.56ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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.67ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 34467 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: 34467 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

CollegeController.php#356db_collegesearch_new810μsselect * from `courses` where `slug` = 'bsc' and `courses`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: bsc 1: active
Backtrace	app/Http/Controllers/CollegeController.php:356 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#356db_collegesearch_new1.91msselect * 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:356 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#356db_collegesearch_new770μsselect * from `streams` where `streams`.`id` in (5) and `streams`.`deleted_at` is null and `status` = 'active'

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

DatabaseStore.php#129db_collegesearch_new1.6msselect * from `cache` where `key` in ('cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23')

Bindings	0: cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23
Backtrace	vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:129 vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:117 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:88 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:453

DatabaseStore.php#409db_collegesearch_new9.78ms

delete from `cache` where `key` in ('cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23', 'cs-newilluminate:cache:flexible:created:college_institute_34467_course-fees-specific_grouped_courses_23') and `expiration` <= 1761484851

Bindings	0: cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23 1: cs-newilluminate:cache:flexible:created:college_institute_34467_course-fees-specific_grouped_courses_23 2: 1761484851
Backtrace	vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:409 vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:144 vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:117 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:88

CollegeController.php#360db_collegesearch_new2.04ms

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

Bindings	0: 34467 1: 23
Backtrace	app/Http/Controllers/CollegeController.php:360 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#360db_collegesearch_new1.34msselect * from `courses` where `courses`.`id` in (23) and `courses`.`deleted_at` is null and `status` = 'active'

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

DatabaseStore.php#189db_collegesearch_new10.26ms

insert into `cache` (`expiration`, `key`, `value`) values (1761486651, 'cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23', 'O:39:\"Illuminate\Database\Eloquent\Collection\":2:{s:8:\"?*?items\";a:1:{i:0;O:33:\"App\Models\InstituteCourseSummary\":31:{s:13:\"?*?connection\";s:5:\"mysql\";s:8:\"?*?table\";s:26:\"institute_course_summaries\";s:13:\"?*?primaryKey\";s:2:\"id\";s:10:\"?*?keyType\";s:3:\"int\";s:12:\"incrementing\";b:1;s:7:\"?*?with\";a:0:{}s:12:\"?*?withCount\";a:0:{}s:19:\"preventsLazyLoading\";b:0;s:10:\"?*?perPage\";i:15;s:6:\"exists\";b:1;s:18:\"wasRecentlyCreated\";b:0;s:28:\"?*?escapeWhenCastingToString\";b:0;s:13:\"?*?attributes\";a:17:{s:2:\"id\";i:50652;s:12:\"institute_id\";i:34467;s:9:\"course_id\";i:23;s:21:\"institute_program_ids\";s:71:\"41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41937,41938\";s:35:\"institute_exams_mappings_unique_ids\";s:6:\"8,2240\";s:27:\"institute_program_ids_count\";i:12;s:41:\"institute_exams_mappings_unique_ids_count\";i:2;s:30:\"institute_program_average_fees\";s:9:\"315000.00\";s:28:\"institute_document_file_name\";s:0:\"\";s:25:\"institute_image_file_name\";s:39:\"240415051349_Joy_University_sports.webp\";s:24:\"institute_placement_year\";i:0;s:35:\"institute_placement_highest_package\";s:4:\"0.00\";s:35:\"institute_placement_average_package\";s:4:\"0.00\";s:34:\"institute_placement_lowest_package\";s:4:\"0.00\";s:10:\"created_at\";N;s:10:\"updated_at\";N;s:10:\"deleted_at\";N;}s:11:\"?*?original\";a:17:{s:2:\"id\";i:50652;s:12:\"institute_id\";i:34467;s:9:\"course_id\";i:23;s:21:\"institute_program_ids\";s:71:\"41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41937,41938\";s:35:\"institute_exams_mappings_unique_ids\";s:6:\"8,2240\";s:27:\"institute_program_ids_count\";i:12;s:41:\"institute_exams_mappings_unique_ids_count\";i:2;s:30:\"institute_program_average_fees\";s:9:\"315000.00\";s:28:\"institute_document_file_name\";s:0:\"\";s:25:\"institute_image_file_name\";s:39:\"240415051349_Joy_University_sports.webp\";s:24:\"institute_placement_year\";i:0;s:35:\"institute_placement_highest_package\";s:4:\"0.00\";s:35:\"institute_placement_average_package\";s:4:\"0.00\";s:34:\"institute_placement_lowest_package\";s:4:\"0.00\";s:10:\"created_at\";N;s:10:\"updated_at\";N;s:10:\"deleted_at\";N;}s:10:\"?*?changes\";a:0:{}s:8:\"?*?casts\";a:1:{s:10:\"deleted_at\";s:8:\"datetime\";}s:17:\"?*?classCastCache\";a:0:{}s:21:\"?*?attributeCastCache\";a:0:{}s:13:\"?*?dateFormat\";N;s:10:\"?*?appends\";a:0:{}s:19:\"?*?dispatchesEvents\";a:0:{}s:14:\"?*?observables\";a:0:{}s:12:\"?*?relations\";a:1:{s:6:\"course\";O:17:\"App\Models\Course\":31:{s:13:\"?*?connection\";s:5:\"mysql\";s:8:\"?*?table\";s:7:\"courses\";s:13:\"?*?primaryKey\";s:2:\"id\";s:10:\"?*?keyType\";s:3:\"int\";s:12:\"incrementing\";b:1;s:7:\"?*?with\";a:0:{}s:12:\"?*?withCount\";a:0:{}s:19:\"preventsLazyLoading\";b:0;s:10:\"?*?perPage\";i:15;s:6:\"exists\";b:1;s:18:\"wasRecentlyCreated\";b:0;s:28:\"?*?escapeWhenCastingToString\";b:0;s:13:\"?*?attributes\";a:20:{s:2:\"id\";i:23;s:9:\"degree_id\";i:1;s:9:\"stream_id\";i:5;s:4:\"name\";s:3:\"BSc\";s:10:\"short_name\";s:3:\"BSc\";s:4:\"slug\";s:3:\"bsc\";s:4:\"mode\";s:7:\"offline\";s:16:\"eligibility_desc\";s:0:\"\";s:8:\"sequence\";i:21;s:8:\"duration\";s:2:\"36\";s:4:\"icon\";s:5:\"5.svg\";s:15:\"elig_marks_12th\";N;s:15:\"elig_marks_10th\";N;s:13:\"elig_marks_ug\";N;s:14:\"further_pg_ids\";N;s:6:\"status\";s:6:\"active\";s:10:\"created_at\";s:19:\"2024-11-29 11:10:34\";s:10:\"updated_at\";s:19:\"2024-11-29 11:10:34\";s:10:\"deleted_at\";N;s:12:\"display_name\";s:3:\"Bsc\";}s:11:\"?*?original\";a:20:{s:2:\"id\";i:23;s:9:\"degree_id\";i:1;s:9:\"stream_id\";i:5;s:4:\"name\";s:3:\"BSc\";s:10:\"short_name\";s:3:\"BSc\";s:4:\"slug\";s:3:\"bsc\";s:4:\"mode\";s:7:\"offline\";s:16:\"eligibility_desc\";s:0:\"\";s:8:\"sequence\";i:21;s:8:\"duration\";s:2:\"36\";s:4:\"icon\";s:5:\"5.svg\";s:15:\"elig_marks_12th\";N;s:15:\"elig_marks_10th\";N;s:13:\"elig_marks_ug\";N;s:14:\"further_pg_ids\";N;s:6:\"status\";s:6:\"active\";s:10:\"created_at\";s:19:\"2024-11-29 11:10:34\";s:10:\"updated_at\";s:19:\"2024-11-29 11:10:34\";s:10:\"deleted_at\";N;s:12:\"display_name\";s:3:\"Bsc\";}s:10:\"?*?changes\";a:0:{}s:8:\"?*?casts\";a:1:{s:10:\"deleted_at\";s:8:\"datetime\";}s:17:\"?*?classCastCache\";a:0:{}s:21:\"?*?attributeCastCache\";a:0:{}s:13:\"?*?dateFormat\";N;s:10:\"?*?appends\";a:0:{}s:19:\"?*?dispatchesEvents\";a:0:{}s:14:\"?*?observables\";a:0:{}s:12:\"?*?relations\";a:0:{}s:10:\"?*?touches\";a:0:{}s:10:\"timestamps\";b:1;s:13:\"usesUniqueIds\";b:0;s:9:\"?*?hidden\";a:0:{}s:10:\"?*?visible\";a:0:{}s:11:\"?*?fillable\";a:0:{}s:10:\"?*?guarded\";a:1:{i:0;s:1:\"*\";}s:16:\"?*?forceDeleting\";b:0;}}s:10:\"?*?touches\";a:0:{}s:10:\"timestamps\";b:1;s:13:\"usesUniqueIds\";b:0;s:9:\"?*?hidden\";a:0:{}s:10:\"?*?visible\";a:0:{}s:11:\"?*?fillable\";a:0:{}s:10:\"?*?guarded\";a:1:{i:0;s:1:\"*\";}s:16:\"?*?forceDeleting\";b:0;}}s:28:\"?*?escapeWhenCastingToString\";b:0;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)

Bindings

0: 1761486651
1: cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23
2: O:39:"Illuminate\Database\Eloquent\Collection":2:{s:8:"*items";a:1:{i:0;O:33:"App\Models\InstituteCourseSummary":31:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:26:"institute_course_summaries";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:17:{s:2:"id";i:50652;s:12:"institute_id";i:34467;s:9:"course_id";i:23;s:21:"institute_program_ids";s:71:"41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41937,41938";s:35:"institute_exams_mappings_unique_ids";s:6:"8,2240";s:27:"institute_program_ids_count";i:12;s:41:"institute_exams_mappings_unique_ids_count";i:2;s:30:"institute_program_average_fees";s:9:"315000.00";s:28:"institute_document_file_name";s:0:"";s:25:"institute_image_file_name";s:39:"240415051349_Joy_University_sports.webp";s:24:"institute_placement_year";i:0;s:35:"institute_placement_highest_package";s:4:"0.00";s:35:"institute_placement_average_package";s:4:"0.00";s:34:"institute_placement_lowest_package";s:4:"0.00";s:10:"created_at";N;s:10:"updated_at";N;s:10:"deleted_at";N;}s:11:"*original";a:17:{s:2:"id";i:50652;s:12:"institute_id";i:34467;s:9:"course_id";i:23;s:21:"institute_program_ids";s:71:"41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41937,41938";s:35:"institute_exams_mappings_unique_ids";s:6:"8,2240";s:27:"institute_program_ids_count";i:12;s:41:"institute_exams_mappings_unique_ids_count";i:2;s:30:"institute_program_average_fees";s:9:"315000.00";s:28:"institute_document_file_name";s:0:"";s:25:"institute_image_file_name";s:39:"240415051349_Joy_University_sports.webp";s:24:"institute_placement_year";i:0;s:35:"institute_placement_highest_package";s:4:"0.00";s:35:"institute_placement_average_package";s:4:"0.00";s:34:"institute_placement_lowest_package";s:4:"0.00";s:10:"created_at";N;s:10:"updated_at";N;s:10:"deleted_at";N;}s:10:"*changes";a:0:{}s:8:"*casts";a:1:{s:10:"deleted_at";s:8:"datetime";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:1:{s:6:"course";O:17:"App\Models\Course":31:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:7:"courses";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:20:{s:2:"id";i:23;s:9:"degree_id";i:1;s:9:"stream_id";i:5;s:4:"name";s:3:"BSc";s:10:"short_name";s:3:"BSc";s:4:"slug";s:3:"bsc";s:4:"mode";s:7:"offline";s:16:"eligibility_desc";s:0:"";s:8:"sequence";i:21;s:8:"duration";s:2:"36";s:4:"icon";s:5:"5.svg";s:15:"elig_marks_12th";N;s:15:"elig_marks_10th";N;s:13:"elig_marks_ug";N;s:14:"further_pg_ids";N;s:6:"status";s:6:"active";s:10:"created_at";s:19:"2024-11-29 11:10:34";s:10:"updated_at";s:19:"2024-11-29 11:10:34";s:10:"deleted_at";N;s:12:"display_name";s:3:"Bsc";}s:11:"*original";a:20:{s:2:"id";i:23;s:9:"degree_id";i:1;s:9:"stream_id";i:5;s:4:"name";s:3:"BSc";s:10:"short_name";s:3:"BSc";s:4:"slug";s:3:"bsc";s:4:"mode";s:7:"offline";s:16:"eligibility_desc";s:0:"";s:8:"sequence";i:21;s:8:"duration";s:2:"36";s:4:"icon";s:5:"5.svg";s:15:"elig_marks_12th";N;s:15:"elig_marks_10th";N;s:13:"elig_marks_ug";N;s:14:"further_pg_ids";N;s:6:"status";s:6:"active";s:10:"created_at";s:19:"2024-11-29 11:10:34";s:10:"updated_at";s:19:"2024-11-29 11:10:34";s:10:"deleted_at";N;s:12:"display_name";s:3:"Bsc";}s:10:"*changes";a:0:{}s:8:"*casts";a:1:{s:10:"deleted_at";s:8:"datetime";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:0:{}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:16:"*forceDeleting";b:0;}}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:0:{}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:16:"*forceDeleting";b:0;}}s:28:"*escapeWhenCastingToString";b:0;}

Backtrace

vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:189
vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:166
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:237
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:453
app/Http/Controllers/CollegeController.php:359

DatabaseStore.php#129db_collegesearch_new680μsselect * from `cache` where `key` in ('cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23')

Bindings	0: cs-newcollege_institute_34467_course-fees-specific_grouped_courses_23
Backtrace	vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:129 vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:117 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:453 app/Http/Controllers/CollegeController.php:363

InstituteCourseSummary.php#26db_collegesearch_new1.37ms

select * from `institute_programs` where `id` in ('41927', '41928', '41929', '41930', '41931', '41932', '41933', '41934', '41935', '41936', '41937', '41938') and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 4

Bindings	0: 41927 1: 41928 2: 41929 3: 41930 4: 41931 5: 41932 6: 41933 7: 41934 8: 41935 9: 41936 10: 41937 11: 41938 12: active
Backtrace	app/Models/InstituteCourseSummary.php:26 app/Http/Controllers/CollegeController.php:363 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

InstituteCourseSummary.php#26db_collegesearch_new1.23ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (41927, 41928, 41929, 41930) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

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

InstituteCourseSummary.php#48db_collegesearch_new1.01ms

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

Bindings	0: 8 1: 2240 2: active
Backtrace	app/Models/InstituteCourseSummary.php:48 app/Http/Controllers/CollegeController.php:363 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.3ms

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` = 8 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 8 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:363 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.18msselect `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:363
app/Http/Controllers/CollegeController.php:76

Exam.php#58db_collegesearch_new940μs

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:363 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.57ms

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

Bindings	0: 34467 1: cs 2: nirf 3: 23 4: active
Backtrace	app/Models/Institute.php:277 app/Http/Controllers/CollegeController.php:364 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#365db_collegesearch_new1.1ms

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

Bindings	0: 23 1: 34467 2: active
Backtrace	app/Http/Controllers/CollegeController.php:365 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#365db_collegesearch_new1.3ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

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

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (41927, 41928, 41929, 41930, 41931, 41932, 41933, 41934, 41935, 41936, 41937, 41938) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

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

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

Bindings	0: institute 1: 34467 2: course-fees-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_new3.5ms

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

Bindings	0: 34467 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_new4.17ms

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

Bindings	0: 34467 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#228db_collegesearch_new630μs

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

Bindings	0: bsc 1: active
Backtrace	app/Http/Controllers/CollegeController.php:228 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_new990μs

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

Bindings	0: 34467 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_new1.52ms

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

Bindings	0: 34467
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#500db_collegesearch_new3.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 '%cp%' and `sub_type` like '%course-fees-specific%' and `module_id` = 34467 and `expiry_date` > '2025-10-26 13:20:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-specific% 2: 34467 3: 2025-10-26 13:20:51
Backtrace	app/helpers.php:500 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#515db_collegesearch_new3.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', '2009', '2342', '8', '2240', '21', '23', '93', '184', '2333') and `expiry_date` > '2025-10-26 13:20:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 2008 3: 2009 4: 2342 5: 8 6: 2240 7: 21 8: 23 9: 93 10: 184 11: 2333 12: 2025-10-26 13:20:51
Backtrace	app/helpers.php:515 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#529db_collegesearch_new3.11ms

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 ('1', '13', '8', '23', '25', '19', '33', '7', '2', '10', '59', '24', '21', '6', '9', '11', '60', '120') and `sub_type` like '%about%' and `expiry_date` > '2025-10-26 13:20:51' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 1 2: 13 3: 8 4: 23 5: 25 6: 19 7: 33 8: 7 9: 2 10: 10 11: 59 12: 24 13: 21 14: 6 15: 9 16: 11 17: 60 18: 120 19: %about% 20: 2025-10-26 13:20:51
Backtrace	app/helpers.php:529 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_new630μs

select * from `meta_tags` where `slug` = 'colleges/joy-university-kanyakumari/courses-fees/bsc' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/joy-university-kanyakumari/courses-fees/bsc 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#161db_collegesearch_new2.7msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: active
Backtrace	app/helpers.php:161 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: 107InstituteProgram.php#?
App\Models\InstituteProgramFeesSummary: 89InstituteProgramFeesSummary.php#?
App\Models\Program: 73Program.php#?
App\Models\InstituteImage: 30InstituteImage.php#?
App\Models\InstituteProgramPlacement: 24InstituteProgramPlacement.php#?
App\Models\Course: 21Course.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramExamMapping: 10InstituteProgramExamMapping.php#?
App\Models\InstituteFaculty: 8InstituteFaculty.php#?
App\Models\Branding: 3Branding.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\InstituteContent: 1InstituteContent.php#?
App\Models\Admin: 1Admin.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\InstituteCourseSummary: 1InstituteCourseSummary.php#?
App\Models\ExamFeatureMapping: 1ExamFeatureMapping.php#?
App\Models\ExamFeature: 1ExamFeature.php#?
App\Models\InstituteRating: 1InstituteRating.php#?
App\Models\LatestUpdatesWidget: 1LatestUpdatesWidget.php#?

_token: EypfEuspjEeiKJP1XY6vHKEb4WfvyfHhSZNxe9Xs
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/joy-university-kanyakumari/courses-f...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/joy-university-kanyakumari/courses-fees/bsc

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=MSc; XSRF-TOKEN=eyJpdiI6ImJiQ3FCRlJNOThaVUJOUngyVDVibXc9PSIsInZhbHVlIjoiSFFWTzBRcW9OZkFPRDNZZGo1ODZJNGRoSlBLWkppWE95NUVUdFVqUVM4K2lBU1BzK2xuSjh2R2tEVktTRmNXY1F4Ym85c0UxdlFBekhCYjhJMGFaYXdHa1V1cEpFejFmZnNpRDRPOWoxQVlrcklRUUprSFNvRitROXRLV2VlVGciLCJtYWMiOiI0NjZkOWVkMTM4NDg2OGI0NTdmMmUzMDA3Yzk0MmQ4ZDQ1OThjNWRhZjdmZWQxZDM4MjBkYmIwM2UyYmQwMTQwIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IlNOcnh2b2UzcTlpNVJSSzVqSUhyK2c9PSIsInZhbHVlIjoiOGY0K3EwNEl6SFM1MGtxMVFUbm93LzZKN0FYWVZNWVZsd3RoZitQWkI4bVl4bVl6SWJLZnBCRCt1SGpTeXpxeWg4QXdpR3lEdEY1eUVxTEI0bjd1aThoZVdaUFBhUS8weHFQckVLemk2L2h5MGY2VzFraFJLd1lmWVNnWmpRdE8iLCJtYWMiOiIyMTUxMGVlNjA2NTUyZDc1YzllNzZkODU1ZjkwYjgwNmQ4ZTFiZGFjNzA2YzIwZTFjNDg1ZGIzMmI4MWY3NjdlIiwidGFnIjoiIn0%3D; course_id=20; viewed_colleges=%5B8108%2C2801%2C35586%2C1430%2C3543%5D; g_state={"i_l":0,"i_ll":1761484849805,"i_b":"cmwglsA99Qt70XgqWLhZ6BzgPPDhR4xusRGyR8MwYCc"} ◀course_name=MSc; XSRF-TOKEN=eyJpdiI6ImJiQ3FCRlJNOThaVUJOUngyVDVibXc9PSIsInZhbHVlIjoiSFFWTzBRcW9OZkFPRDNZZGo1ODZJNGRoSlBLWkppWE95NUVUdFVqUVM4K2lBU1BzK2xuSjh2R2tE ▶"
  ]
  "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:6 [▼
  "course_name" => "MSc"
  "XSRF-TOKEN" => "EypfEuspjEeiKJP1XY6vHKEb4WfvyfHhSZNxe9Xs"
  "laravel_session" => "hdUlBXQxxqt3pldzup0ZxJrt2JINZUsKwbLenqr3"
  "course_id" => "20"
  "viewed_colleges" => "[8108,2801,35586,1430,3543]"
  "g_state" => null
]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 26 Oct 2025 13:20:51 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImYzN1ZmcUpYWnVucnp1dUZxM1dpQ2c9PSIsInZhbHVlIjoicVBneUtocTViazQ4UWxMRlhoemt1R3B3R3hUZVhpR1ROdkZZeWtwQWx6NUJ4NVp2MVFEQlFiZHdqZEM4N0duck5Fald5NUpWL1FEdVkvUWdINXoxWnNXYmo5aitiTkY4MTJuSmlmdExVMXROdVNMUWtEZXVzS09qODV0OCs1V3QiLCJtYWMiOiJlYWZhMWFjMmI5YzNiNzdjMjgwZjRjNTE2Njk5ODk3YjIyMWEwMjI2NTIzZDBlMWI0ZTk5ZTI5MmE3MTUxMGIxIiwidGFnIjoiIn0%3D; expires=Sun, 26 Oct 2025 15:20:51 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImYzN1ZmcUpYWnVucnp1dUZxM1dpQ2c9PSIsInZhbHVlIjoicVBneUtocTViazQ4UWxMRlhoemt1R3B3R3hUZVhpR1ROdkZZeWtwQWx6NUJ4NVp2MVFEQlFiZHdqZEM4N0duck5Fald5N ▶"
    1 => "laravel_session=eyJpdiI6IjY3MUZVblRaUXJDNzhwdDZKMTRqdUE9PSIsInZhbHVlIjoiemRzUHRPaVBHaW5pNGozbm5sTVB2cVJVNGIvSkNDNXhVcGhKOU5GYTdrRndGSXF2dEJQdVY3YzBBQUU2UmlwcHVpZkt6RE5FREZTSjlKSGx3VCtQd1VVQVdYanJOY1JMNTRqRkVwbnFFRW9PRHprM2xncnQ5elRSMnhHWkJERHgiLCJtYWMiOiI0YzcwODFiN2RmZTdhODE2MTI1Mjc5OGE2ODBjZDc1YjQ5YWVjZWM3ODg0MTRlN2JjNzg4NmY4NjZkNjA2ZDRmIiwidGFnIjoiIn0%3D; expires=Sun, 26 Oct 2025 15:20:51 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjY3MUZVblRaUXJDNzhwdDZKMTRqdUE9PSIsInZhbHVlIjoiemRzUHRPaVBHaW5pNGozbm5sTVB2cVJVNGIvSkNDNXhVcGhKOU5GYTdrRndGSXF2dEJQdVY3YzBBQUU2UmlwcHVp ▶"
    2 => "course_id=23; expires=Mon, 26 Oct 2026 13:20:51 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=BSc; expires=Mon, 26 Oct 2026 13:20:51 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B8108%2C2801%2C35586%2C1430%2C3543%2C34467%5D; expires=Tue, 25 Nov 2025 13:20:51 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImYzN1ZmcUpYWnVucnp1dUZxM1dpQ2c9PSIsInZhbHVlIjoicVBneUtocTViazQ4UWxMRlhoemt1R3B3R3hUZVhpR1ROdkZZeWtwQWx6NUJ4NVp2MVFEQlFiZHdqZEM4N0duck5Fald5NUpWL1FEdVkvUWdINXoxWnNXYmo5aitiTkY4MTJuSmlmdExVMXROdVNMUWtEZXVzS09qODV0OCs1V3QiLCJtYWMiOiJlYWZhMWFjMmI5YzNiNzdjMjgwZjRjNTE2Njk5ODk3YjIyMWEwMjI2NTIzZDBlMWI0ZTk5ZTI5MmE3MTUxMGIxIiwidGFnIjoiIn0%3D; expires=Sun, 26-Oct-2025 15:20:51 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImYzN1ZmcUpYWnVucnp1dUZxM1dpQ2c9PSIsInZhbHVlIjoicVBneUtocTViazQ4UWxMRlhoemt1R3B3R3hUZVhpR1ROdkZZeWtwQWx6NUJ4NVp2MVFEQlFiZHdqZEM4N0duck5Fald5N ▶"
    1 => "laravel_session=eyJpdiI6IjY3MUZVblRaUXJDNzhwdDZKMTRqdUE9PSIsInZhbHVlIjoiemRzUHRPaVBHaW5pNGozbm5sTVB2cVJVNGIvSkNDNXhVcGhKOU5GYTdrRndGSXF2dEJQdVY3YzBBQUU2UmlwcHVpZkt6RE5FREZTSjlKSGx3VCtQd1VVQVdYanJOY1JMNTRqRkVwbnFFRW9PRHprM2xncnQ5elRSMnhHWkJERHgiLCJtYWMiOiI0YzcwODFiN2RmZTdhODE2MTI1Mjc5OGE2ODBjZDc1YjQ5YWVjZWM3ODg0MTRlN2JjNzg4NmY4NjZkNjA2ZDRmIiwidGFnIjoiIn0%3D; expires=Sun, 26-Oct-2025 15:20:51 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IjY3MUZVblRaUXJDNzhwdDZKMTRqdUE9PSIsInZhbHVlIjoiemRzUHRPaVBHaW5pNGozbm5sTVB2cVJVNGIvSkNDNXhVcGhKOU5GYTdrRndGSXF2dEJQdVY3YzBBQUU2UmlwcHVp ▶"
    2 => "course_id=23; expires=Mon, 26-Oct-2026 13:20:51 GMT; path=/"
    3 => "course_name=BSc; expires=Mon, 26-Oct-2026 13:20:51 GMT; path=/"
    4 => "viewed_colleges=%5B8108%2C2801%2C35586%2C1430%2C3543%2C34467%5D; expires=Tue, 25-Nov-2025 13:20:51 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "EypfEuspjEeiKJP1XY6vHKEb4WfvyfHhSZNxe9Xs"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/joy-university-kanyakumari/courses-fees/bsc"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-10-26 13:20:51	GET	/colleges/joy-university-kanyakumari/courses-fees/bsc	15 57 394

BSc in Joy University, Kanyakumari Branch-wise Fees, Fee Breakups, Eligibility

New Updates About Joy University, Kanyakumari

What Does Joy University Offer?

BSc Programs Offered

Student's Rating for Joy University, Kanyakumari

Student's Reviews for Joy University, Kanyakumari

Gallery

Contact Details

1 x Application (95.94%)	248ms
1 x Booting (4.06%)	10.51ms