Top MCA in MCA (Master of Computer Applications) + Ph.D Colleges in India 2025 : Fees, Rankings, Placements, Admissions

Messages Timeline Exceptions Views11 Route Queries28 Models1726 Mails Gate Session Request

Request history8.3.19558ms8MBGET {course}/colleges-{filters}

Booting (14.12ms)time
Application (544ms)time
1 x Application (97.47%)
544ms
1 x Booting (2.53%)
14.12ms

11 templates were rendered

pages.search-result.indexindex.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
pages.search-result.filtersfilters.blade.php#?blade
components.storiesstories.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 {course}/colleges-{filters}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\SearchController@index
as: sr.filters
namespace
prefix
where
file: app/Http/Controllers/SearchController.php:34-84

28 statements were executed299ms

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_new6.77msselect * from `seo_redirects` where `redirect_from` = '/mca/colleges-mca-master-of-computer-applications-phd' limit 1

Bindings	0: /mca/colleges-mca-master-of-computer-applications-phd
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.52ms

select * from `meta_tags` where `slug` = 'mca/colleges-mca-master-of-computer-applications-phd' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: mca/colleges-mca-master-of-computer-applications-phd 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_new2.17ms

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

Bindings	0: sr 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

SearchController.php#153db_collegesearch_new1.14ms

select `id`, `name`, `slug` from `exams` where `slug` in ('mca', 'master', 'of', 'computer', 'applications', 'phd', 'mca-master', 'master-of', 'of-computer', 'computer-applications', 'applications-phd', 'mca-master-of', 'master-of-computer', 'of-computer-applications', 'computer-applications-phd', 'mca-master-of-computer', 'master-of-computer-applications', 'of-computer-applications-phd', 'mca-master-of-computer-applications', 'master-of-computer-applications-phd', 'mca-master-of-computer-applications-phd') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings

0: mca
1: master
2: of
3: computer
4: applications
5: phd
6: mca-master
7: master-of
8: of-computer
9: computer-applications
10: applications-phd
11: mca-master-of
12: master-of-computer
13: of-computer-applications
14: computer-applications-phd
15: mca-master-of-computer
16: master-of-computer-applications
17: of-computer-applications-phd
18: mca-master-of-computer-applications
19: master-of-computer-applications-phd
20: mca-master-of-computer-applications-phd
21: active

Backtrace

app/Http/Controllers/SearchController.php:153
app/Http/Controllers/SearchController.php:51
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

SearchController.php#153db_collegesearch_new1.74ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('mca', 'master', 'of', 'computer', 'applications', 'phd', 'mca-master', 'master-of', 'of-computer', 'computer-applications', 'applications-phd', 'mca-master-of', 'master-of-computer', 'of-computer-applications', 'computer-applications-phd', 'mca-master-of-computer', 'master-of-computer-applications', 'of-computer-applications-phd', 'mca-master-of-computer-applications', 'master-of-computer-applications-phd', 'mca-master-of-computer-applications-phd') and `country_id` = 2 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc

Bindings

0: mca
1: master
2: of
3: computer
4: applications
5: phd
6: mca-master
7: master-of
8: of-computer
9: computer-applications
10: applications-phd
11: mca-master-of
12: master-of-computer
13: of-computer-applications
14: computer-applications-phd
15: mca-master-of-computer
16: master-of-computer-applications
17: of-computer-applications-phd
18: mca-master-of-computer-applications
19: master-of-computer-applications-phd
20: mca-master-of-computer-applications-phd
21: 2
22: active
23: 2

Backtrace

app/Http/Controllers/SearchController.php:153
app/Http/Controllers/SearchController.php:51
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

SearchController.php#153db_collegesearch_new2.3ms

select `id`, `name`, `shortname` from `cities` where `shortname` in ('mca', 'master', 'of', 'computer', 'applications', 'phd', 'mca-master', 'master-of', 'of-computer', 'computer-applications', 'applications-phd', 'mca-master-of', 'master-of-computer', 'of-computer-applications', 'computer-applications-phd', 'mca-master-of-computer', 'master-of-computer-applications', 'of-computer-applications-phd', 'mca-master-of-computer-applications', 'master-of-computer-applications-phd', 'mca-master-of-computer-applications-phd') and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings

0: mca
1: master
2: of
3: computer
4: applications
5: phd
6: mca-master
7: master-of
8: of-computer
9: computer-applications
10: applications-phd
11: mca-master-of
12: master-of-computer
13: of-computer-applications
14: computer-applications-phd
15: mca-master-of-computer
16: master-of-computer-applications
17: of-computer-applications-phd
18: mca-master-of-computer-applications
19: master-of-computer-applications-phd
20: mca-master-of-computer-applications-phd
21: active

Backtrace

app/Http/Controllers/SearchController.php:153
app/Http/Controllers/SearchController.php:51
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

SearchController.php#153db_collegesearch_new6.6ms

select `id`, `name`, `slug` from `programs` where `slug` in ('mca', 'master', 'of', 'computer', 'applications', 'phd', 'mca-master', 'master-of', 'of-computer', 'computer-applications', 'applications-phd', 'mca-master-of', 'master-of-computer', 'of-computer-applications', 'computer-applications-phd', 'mca-master-of-computer', 'master-of-computer-applications', 'of-computer-applications-phd', 'mca-master-of-computer-applications', 'master-of-computer-applications-phd', 'mca-master-of-computer-applications-phd') and `programs`.`deleted_at` is null and `status` = 'active'

Bindings

0: mca
1: master
2: of
3: computer
4: applications
5: phd
6: mca-master
7: master-of
8: of-computer
9: computer-applications
10: applications-phd
11: mca-master-of
12: master-of-computer
13: of-computer-applications
14: computer-applications-phd
15: mca-master-of-computer
16: master-of-computer-applications
17: of-computer-applications-phd
18: mca-master-of-computer-applications
19: master-of-computer-applications-phd
20: mca-master-of-computer-applications-phd
21: active

Backtrace

app/Http/Controllers/SearchController.php:153
app/Http/Controllers/SearchController.php:51
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

SearchController.php#186db_collegesearch_new690μs

select `id`, `display_name` from `courses` where `slug` = 'mca' and `courses`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: mca 1: active
Backtrace	app/Http/Controllers/SearchController.php:186 app/Http/Controllers/SearchController.php:51 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

SearchController.php#636db_collegesearch_new10.88ms

select count(*) as aggregate from (select * from `institute_programs` where `program_id` in (4831) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (8) group by `institute_id`) as `aggregate_table`

Bindings	0: 4831 1: active 2: 8
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new10.63ms

select * from `institute_programs` where `program_id` in (4831) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (8) group by `institute_id` order by CASE WHEN (select `rank` from `institute_ranks` where `institute_ranks`.`institute_id` = `institute_programs`.`institute_id` and `ranking_body` = 'nirf' and `year` = 2024 and `rank` > 0 and `course_id` in (8) and `deleted_at` is null and `status` = 'active' and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `rank` asc limit 1) IS NOT NULL THEN 0 ELSE 1 END ASC, COALESCE((select `rank` from `institute_ranks` where `institute_ranks`.`institute_id` = `institute_programs`.`institute_id` and `ranking_body` = 'nirf' and `year` = 2024 and `rank` > 0 and `course_id` in (8) and `deleted_at` is null and `status` = 'active' and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `rank` asc limit 1), 9999999) ASC, COALESCE((select `rank` from `institute_ranks` where `institute_ranks`.`institute_id` = `institute_programs`.`institute_id` and `ranking_body` = 'cs' and `rank` > 0 and `course_id` in (8) and `deleted_at` is null and `status` = 'active' and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `rank` asc limit 1), 9999999) ASC limit 20 offset 0

Bindings	0: 4831 1: active 2: 8 3: nirf 4: 2024 5: 0 6: 8 7: active 8: active 9: nirf 10: 2024 11: 0 12: 8 13: active 14: active 15: cs 16: 0 17: 8 18: active 19: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new3.07ms

select `institutes`.*, (select count(*) from `institute_programs` where `institutes`.`id` = `institute_programs`.`institute_id` and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (8)) as `programs_count`, (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 `institutes`.`id` in (46852, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47812, 47939, 48002, 48135, 48155, 48156, 48186, 48200, 48234, 48366, 48405) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 8 2: active 3: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new3.91ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (46852, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47812, 47939, 48002, 48135, 48155, 48156, 48186, 48200, 48234, 48366, 48405) and `course_id` in (8) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 8
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new1.21ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (35, 55, 68, 80, 84, 141, 197, 213, 438) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new3.43ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (64, 74, 80, 82, 83, 88, 90, 93, 97) and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc

Bindings	0: active 1: 2
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new7.72ms

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (46852, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47812, 47939, 48002, 48135, 48155, 48156, 48186, 48200, 48234, 48366, 48405) and `institute_ratings`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new11.13ms

select * from (select *, row_number() over (partition by `institute_images`.`institute_id` order by `is_featured` desc, `created_at` desc) as `laravel_row` from `institute_images` where `institute_images`.`institute_id` in (46852, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47812, 47939, 48002, 48135, 48155, 48156, 48186, 48200, 48234, 48366, 48405) and `media_type` = 'image' and `institute_images`.`deleted_at` is null and `status` = 'active') as `laravel_table` where `laravel_row` <= 1 order by `laravel_row`

Bindings	0: image 1: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new3.18ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#636db_collegesearch_new6.6ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (164824, 164881, 165011, 165040, 165080, 165202, 165315, 165980, 166292, 166601, 166752, 167082, 167685, 167698, 167857, 167890, 168040, 168183, 168585, 168755)

Backtrace

app/Http/Controllers/SearchController.php:636
app/Http/Controllers/SearchController.php:57
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

SearchController.php#636db_collegesearch_new7.81ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (46852, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47812, 47939, 48002, 48135, 48155, 48156, 48186, 48200, 48234, 48366, 48405) and `ranking_body` = 'nirf' and `course_id` in (8) and `year` = 2024 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc, `rank` desc

Bindings	0: 46852 1: 47512 2: 47520 3: 47526 4: 47558 5: 47570 6: 47622 7: 47715 8: 47729 9: 47812 10: 47939 11: 48002 12: 48135 13: 48155 14: 48156 15: 48186 16: 48200 17: 48234 18: 48366 19: 48405 20: nirf 21: 8 22: 2024 23: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 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

SearchController.php#394db_collegesearch_new11.68ms

select * from `institute_programs` where `program_id` in (4831) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (8) group by `institute_id`

Bindings	0: 4831 1: active 2: 8
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 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

SearchController.php#394db_collegesearch_new7.52ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (17240, 36392, 36393, 36412, 36453, 36538, 36573, 36639, 36706, 36738, 36841, 36842, 36845, 36858, 36948, 37012, 37017, 37079, 37128, 37157, 37192, 37279, 37284, 37301, 37410, 37442, 37535, 37553, 37578, 38131, 38178, 38266, 38361, 38385, 38387, 38457, 38521, 38531, 38614, 38655, 38673, 38675, 38677, 38899, 38941, 38964, 39002, 39091, 39093, 39127, 39237, 39252, 39343, 39353, 39447, 39473, 39480, 39490, 39497, 39558, 39614, 39639, 39651, 39789, 39863, 39918, 39945, 39946, 40041, 40043, 40187, 40302, 40368, 40468, 40493, 40516, 40517, 40561, 40577, 40583, 40601, 40911, 40986, 41080, 41149, 41310, 41577, 41579, 41661, 41663, 41671, 41711, 41861, 41885, 41912, 41999, 42131, 42134, 42144, 42179, 42201, 42202, 42212, 42215, 42216, 42234, 42238, 42248, 42258, 42435, 42482, 42718, 42788, 42842, 42843, 42860, 42899, 42913, 42942, 42974, 42990, 43150, 43176, 43291, 43393, 43400, 43426, 43487, 43888, 44212, 44311, 44315, 44359, 44366, 44367, 44374, 44380, 44418, 44645, 44650, 44681, 44688, 44753, 44773, 44792, 44878, 44956, 44965, 44996, 45005, 45063, 45147, 45150, 45152, 45357, 45376, 45436, 45500, 45523, 45525, 45555, 45578, 45666, 45744, 45758, 45771, 45794, 45811, 45867, 45879, 46005, 46009, 46017, 46021, 46024, 46159, 46173, 46235, 46244, 46316, 46379, 46419, 46461, 46517, 46540, 46566, 46576, 46689, 46691, 46702, 46705, 46719, 46756, 46821, 46852, 46924, 47094, 47260, 47411, 47426, 47512, 47520, 47526, 47558, 47570, 47622, 47715, 47729, 47790, 47812, 47832, 47850, 47915, 47939, 48002, 48089, 48135, 48155, 48156, 48186, 48189, 48191, 48200, 48234, 48235, 48366, 48405, 48479, 48509, 48651, 48687, 48689, 48717, 48766, 48775, 48795, 48847, 48884, 49157, 49200, 49288, 49313, 49325, 49332, 49480, 49482, 49706, 49726, 49813, 49944, 49965, 49986, 50089, 50102, 50132, 50181, 50182, 50234, 50317, 50609, 50652, 50718, 50747, 50886, 50892, 50922, 50964, 50966, 51015, 51027, 51030, 51039, 51117, 51148, 51162, 51198, 51234, 51236, 51274, 51332, 51523, 51565, 51591, 51630, 51636, 51717, 51941, 51942, 52127, 52164, 52245, 52273, 52277, 52286, 52294, 52397, 52440, 52495, 52581, 52592, 52609, 52634, 52660, 52883, 52887, 53089, 53090, 53108, 53116, 53118, 53126, 53157, 53160, 53177, 53178) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 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

SearchController.php#394db_collegesearch_new13.19ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (2, 3, 6, 12, 17, 20, 22, 24, 31, 32, 35, 36, 37, 38, 44, 48, 52, 55, 56, 57, 58, 61, 62, 63, 64, 65, 66, 68, 72, 80, 83, 84, 85, 88, 91, 93, 95, 104, 108, 110, 116, 117, 118, 119, 125, 131, 132, 141, 152, 153, 154, 157, 158, 165, 168, 169, 170, 182, 186, 192, 193, 195, 196, 197, 198, 204, 211, 213, 226, 233, 235, 240, 242, 245, 247, 260, 263, 277, 278, 281, 282, 284, 289, 302, 303, 304, 325, 347, 356, 361, 383, 385, 390, 410, 427, 435, 438, 444, 476, 478, 487, 493, 496, 523, 534, 558, 560, 578, 580, 594, 607, 612, 617, 621, 639, 644, 683, 691, 701, 704, 708, 741, 765, 768, 803, 840) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 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

SearchController.php#394db_collegesearch_new12.36ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (64, 66, 67, 69, 72, 74, 75, 76, 77, 78, 79, 80, 82, 83, 85, 86, 88, 89, 90, 91, 93, 95, 96, 97, 98) and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc

Bindings	0: active 1: 2
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 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

SearchController.php#394db_collegesearch_new11.64ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (78041, 111993, 112274, 112520, 112592, 113189, 113200, 113248, 113325, 113737, 114029, 114091, 114426, 114663, 114803, 115441, 115477, 115609, 116041, 116164, 116337, 117017, 117462, 118737, 118809, 118859, 119009, 119188, 119663, 120036, 120311, 120330, 120723, 121231, 121512, 121532, 122501, 122633, 122726, 122907, 122995, 123424, 123440, 123796, 124006, 124047, 124321, 124437, 124822, 124890, 124905, 124978, 125041, 125321, 125573, 125768, 126348, 126679, 126789, 126814, 126834, 127085, 127109, 127660, 128149, 128385, 129003, 129035, 129556, 129829, 130102, 130135, 130150, 130283, 130492, 131870, 131883, 134006, 134043, 135157, 135368, 135686, 136323, 136344, 136374, 136716, 136782, 136789, 137644, 137896, 138302, 138315, 138413, 139032, 139310, 139338, 139369, 139473, 139476, 139532, 139587, 139590, 139612, 139613, 139749, 139764, 139837, 139893, 139915, 140815, 140977, 142135, 142599, 142638, 142738, 142845, 143009, 143278, 143374, 144173, 144305, 144494, 144835, 145498, 145571, 145883, 146597, 148957, 149342, 149388, 149624, 149657, 149671, 149738, 149851, 150005, 151077, 151189, 151403, 151442, 151564, 151630, 152003, 152305, 152329, 152426, 152515, 152553, 152943, 153025, 153252, 153287, 153810, 154374, 154549, 154840, 154966, 155231, 155428, 155559, 155900, 156001, 156453, 156562, 156756, 156911, 157171, 157270, 157675, 157716, 157733, 157858, 158503, 158626, 158837, 159375, 159760, 159798, 160041, 160188, 160411, 160525, 160655, 160726, 161241, 161278, 161301, 161358, 161483, 161554, 161561, 161632, 162387, 163162, 163881, 164454, 164504, 164824, 164881, 165011, 165040, 165080, 165202, 165315, 165980, 166292, 166601, 166752, 167082, 167685, 167698, 167857, 167890, 168040, 168183, 168585, 168755, 169124, 169286, 169715, 169920, 169972, 169988, 170132, 170433, 170537, 170747, 170847, 171538, 171720, 171869, 172182, 172345, 172366, 172900, 172904, 173672, 173686, 173708, 173768, 173820, 174101, 174119, 174562, 174761, 174807, 174837, 175297, 175371, 175464, 175723, 175741, 175974, 176063, 176837, 177517, 177646, 177745, 177852, 177918, 178044, 178236, 178561, 178897, 178961, 179068, 179348, 179421, 179480, 179490, 179536, 179589, 179875, 179968, 180410, 180696, 180856, 182124, 182248, 182373, 182439, 182497, 182798, 183920, 183943, 184213, 184741, 184959, 185419, 185427, 185502, 185544, 185566, 185664, 185910, 186302, 186482, 186791, 187138, 187183, 187228, 187332, 187432, 188272, 188357, 189677, 189701, 189960, 190087, 190110, 190171, 190926, 191025, 191470, 191472)

Backtrace

app/Http/Controllers/SearchController.php:394
app/Http/Controllers/SearchController.php:64
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

SearchController.php#394db_collegesearch_new2.51ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 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

SearchController.php#398db_collegesearch_new9.69ms

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

Bindings	0: active 1: 2
Backtrace	app/Http/Controllers/SearchController.php:398 app/Http/Controllers/SearchController.php:64 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

SearchController.php#410db_collegesearch_new135ms

select `id`, `name`, `shortname` from `cities` where `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:410 app/Http/Controllers/SearchController.php:64 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#157db_collegesearch_new1.88msselect * from `brandings` where `section` = 'sr' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: sr 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\City: 982City.php#?
App\Models\InstituteProgram: 335InstituteProgram.php#?
App\Models\Institute: 335Institute.php#?
App\Models\State: 69State.php#?
App\Models\Program: 2Program.php#?
App\Models\Course: 2Course.php#?
App\Models\DefaultMetaTag: 1DefaultMetaTag.php#?

_token: TfpXo9xOJEi9ayU52q9xyTXWb9KPHRSBAcWa0wql
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/mca/colleges-mca-master-of-computer-applicati...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/mca/colleges-mca-master-of-computer-applications-phd

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "branch_id" => array:1 [▶
    0 => "4831"
  ]
]

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_id=20; course_name=MA; viewed_colleges=%5B343%2C13649%2C13188%5D; XSRF-TOKEN=eyJpdiI6Ii9BK2lFc1NrZGhPbW15QkhSam5iRUE9PSIsInZhbHVlIjoiQVVpWGtlV3JQckovUUx5cTZjMktlQ01weVVudjhvZDljSGx0cjFhRHlxVVlpZk1QdEp0TGsrM215SkJsdk9xUVpIMlhBQlhtMmRNc3Q2bkNiVzhtL0taU3RzQWlYWWhoZld0ck5XSkxrWlFoNjh6ZTh1VDRIZFgreXdqR3pnWlEiLCJtYWMiOiI5ZjFjYzQ0OTE0MmJkZDVlN2U1MWVmNzExYjIxNGRkZDA5YTZjNjEwYTZiZGEyZTc3ZDhmNjhiNWIzZThkOWU0IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Ii9YcXRJUytnV3JDaDN0bkZMNTY5eWc9PSIsInZhbHVlIjoiVktVRzczTVZyWTMweVpjMjk3ZlRpbnhmWkdhb1ljWWZSS1RteFBSbHZrK3Yveit6V3RDaXhVNlVzYXUxMDBjRDc5UjN6THloYkxDOHdGNmN2dFZhaHhDc0FzOFlRemk5dXl4VGFFZ1ZBZFNZdlp1aWx1azl1cVVXWUVZdTA0Rm8iLCJtYWMiOiI4YTkzZmYzNjNkNTFlMjM5YzUwNTU1MmY4M2YxN2M5N2UwMzhkY2RmNGI2YzlhZjVmY2Q1YjA0NDc1ZWJjZDU5IiwidGFnIjoiIn0%3D ◀course_id=20; course_name=MA; viewed_colleges=%5B343%2C13649%2C13188%5D; XSRF-TOKEN=eyJpdiI6Ii9BK2lFc1NrZGhPbW15QkhSam5iRUE9PSIsInZhbHVlIjoiQVVpWGtlV3JQckovUUx5 ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

  0 of 0   
array:5 [▼
  "course_id" => "20"
  "course_name" => "MA"
  "viewed_colleges" => "[343,13649,13188]"
  "XSRF-TOKEN" => "TfpXo9xOJEi9ayU52q9xyTXWb9KPHRSBAcWa0wql"
  "laravel_session" => "nIZWvYJCIEeZVJkx0XFEhsBXFHOsSrcB8mpNKfxQ"
]

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 => "Fri, 06 Jun 2025 00:04:24 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlB1blRwb1NRa2Jqc0huNXVTTTZhaGc9PSIsInZhbHVlIjoiV3FDZkFHdUlOeTNRdmRiMDJ2bFZZa051Z0NsNDh6ZFFHeDZ2eUh0RFlNRnFFYU1teWpZK0JZcmo1T0dTUm4xRzNOM1dyVk9QNFdlTmthWHpVVFVOdkl0dS9GMjlsRGJsZ1IxOHBFaWRYaE0zRkpnenlaVS9YZXJ0MDZ2WFVialYiLCJtYWMiOiIwMGJiNmUxOGU4ZWE5MmYwZjQ1YjBhYzI3OWE2MjhkM2M4ZDQ0M2Y5NmU2ZmMyMzRlN2E3NjU0ZmQ5MTNlZDIxIiwidGFnIjoiIn0%3D; expires=Fri, 06 Jun 2025 02:04:24 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlB1blRwb1NRa2Jqc0huNXVTTTZhaGc9PSIsInZhbHVlIjoiV3FDZkFHdUlOeTNRdmRiMDJ2bFZZa051Z0NsNDh6ZFFHeDZ2eUh0RFlNRnFFYU1teWpZK0JZcmo1T0dTUm4xRzNOM1dyV ▶"
    1 => "laravel_session=eyJpdiI6IlNEVmNlbVgyeWtzK2dMeld3LzhCckE9PSIsInZhbHVlIjoiTmlrM2t0V2dmZkV5akFEVHdPMm1mMngxeFlqQVM0TUZqNzNoQmVvd211c2VRYlNDRlJCRHVWbmdrL1p3WHFiVkZ3RGt1cDlPUVNyREJGY3k4cWc5bzBnTGZRTFpHckhXNlVkZm1DdlFIUjVjV0pML2ZVTExSa1pwWVZsY0x1MHQiLCJtYWMiOiI2ZmRmNzE4OTdmM2RlOGYyNzBjNjY3YWYxNDZhZjVhYmY0YWI2MDc0NTZiN2RiMTE2MmE5Yjg3NzE3ZGRiZjY4IiwidGFnIjoiIn0%3D; expires=Fri, 06 Jun 2025 02:04:24 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlNEVmNlbVgyeWtzK2dMeld3LzhCckE9PSIsInZhbHVlIjoiTmlrM2t0V2dmZkV5akFEVHdPMm1mMngxeFlqQVM0TUZqNzNoQmVvd211c2VRYlNDRlJCRHVWbmdrL1p3WHFiVkZ3 ▶"
    2 => "course_id=8; expires=Sat, 06 Jun 2026 00:04:23 GMT; Max-Age=31535999; path=/; samesite=lax"
    3 => "course_name=MCA; expires=Sat, 06 Jun 2026 00:04:23 GMT; Max-Age=31535999; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlB1blRwb1NRa2Jqc0huNXVTTTZhaGc9PSIsInZhbHVlIjoiV3FDZkFHdUlOeTNRdmRiMDJ2bFZZa051Z0NsNDh6ZFFHeDZ2eUh0RFlNRnFFYU1teWpZK0JZcmo1T0dTUm4xRzNOM1dyVk9QNFdlTmthWHpVVFVOdkl0dS9GMjlsRGJsZ1IxOHBFaWRYaE0zRkpnenlaVS9YZXJ0MDZ2WFVialYiLCJtYWMiOiIwMGJiNmUxOGU4ZWE5MmYwZjQ1YjBhYzI3OWE2MjhkM2M4ZDQ0M2Y5NmU2ZmMyMzRlN2E3NjU0ZmQ5MTNlZDIxIiwidGFnIjoiIn0%3D; expires=Fri, 06-Jun-2025 02:04:24 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlB1blRwb1NRa2Jqc0huNXVTTTZhaGc9PSIsInZhbHVlIjoiV3FDZkFHdUlOeTNRdmRiMDJ2bFZZa051Z0NsNDh6ZFFHeDZ2eUh0RFlNRnFFYU1teWpZK0JZcmo1T0dTUm4xRzNOM1dyV ▶"
    1 => "laravel_session=eyJpdiI6IlNEVmNlbVgyeWtzK2dMeld3LzhCckE9PSIsInZhbHVlIjoiTmlrM2t0V2dmZkV5akFEVHdPMm1mMngxeFlqQVM0TUZqNzNoQmVvd211c2VRYlNDRlJCRHVWbmdrL1p3WHFiVkZ3RGt1cDlPUVNyREJGY3k4cWc5bzBnTGZRTFpHckhXNlVkZm1DdlFIUjVjV0pML2ZVTExSa1pwWVZsY0x1MHQiLCJtYWMiOiI2ZmRmNzE4OTdmM2RlOGYyNzBjNjY3YWYxNDZhZjVhYmY0YWI2MDc0NTZiN2RiMTE2MmE5Yjg3NzE3ZGRiZjY4IiwidGFnIjoiIn0%3D; expires=Fri, 06-Jun-2025 02:04:24 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IlNEVmNlbVgyeWtzK2dMeld3LzhCckE9PSIsInZhbHVlIjoiTmlrM2t0V2dmZkV5akFEVHdPMm1mMngxeFlqQVM0TUZqNzNoQmVvd211c2VRYlNDRlJCRHVWbmdrL1p3WHFiVkZ3 ▶"
    2 => "course_id=8; expires=Sat, 06-Jun-2026 00:04:23 GMT; path=/"
    3 => "course_name=MCA; expires=Sat, 06-Jun-2026 00:04:23 GMT; path=/"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "TfpXo9xOJEi9ayU52q9xyTXWb9KPHRSBAcWa0wql"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/mca/colleges-mca-master-of-computer-applications-phd?branch_id%5B0%5D=4831"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-06 00:04:24	GET	/mca/colleges-mca-master-of-computer-applications-phd?branch_id%5B%5D=4831	11 28 1726

1 x Application (97.47%)	544ms
1 x Booting (2.53%)	14.12ms