Top MA in M.A in Sociology Colleges in India 2025 : Fees, Rankings, Placements, Admissions

Messages Timeline Exceptions Views11 Route Queries29 Models2361 Mails Gate Session Request

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

Booting (13.2ms)time
Application (492ms)time
1 x Application (97.38%)
492ms
1 x Booting (2.61%)
13.20ms

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:28-78

29 statements were executed270ms

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_new8.18msselect * from `seo_redirects` where `redirect_from` = '/ma/colleges-ma-in-sociology' limit 1

Bindings	0: /ma/colleges-ma-in-sociology
Backtrace	app/Http/Middleware/SoftRedirects.php:22 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

MetaChecker.php#20db_collegesearch_new1.13ms

select * from `meta_tags` where `slug` = 'ma/colleges-ma-in-sociology' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: ma/colleges-ma-in-sociology 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_new3.06ms

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#147db_collegesearch_new6.28ms

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

Bindings	0: ma 1: in 2: sociology 3: ma-in 4: in-sociology 5: ma-in-sociology 6: active
Backtrace	app/Http/Controllers/SearchController.php:147 app/Http/Controllers/SearchController.php:45 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#147db_collegesearch_new2.43ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('ma', 'in', 'sociology', 'ma-in', 'in-sociology', 'ma-in-sociology') 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: ma 1: in 2: sociology 3: ma-in 4: in-sociology 5: ma-in-sociology 6: 2 7: active 8: 2
Backtrace	app/Http/Controllers/SearchController.php:147 app/Http/Controllers/SearchController.php:45 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#147db_collegesearch_new1.8ms

select `id`, `name`, `shortname` from `cities` where `shortname` in ('ma', 'in', 'sociology', 'ma-in', 'in-sociology', 'ma-in-sociology') and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: ma 1: in 2: sociology 3: ma-in 4: in-sociology 5: ma-in-sociology 6: active
Backtrace	app/Http/Controllers/SearchController.php:147 app/Http/Controllers/SearchController.php:45 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#147db_collegesearch_new6.74ms

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

Bindings	0: ma 1: in 2: sociology 3: ma-in 4: in-sociology 5: ma-in-sociology 6: active
Backtrace	app/Http/Controllers/SearchController.php:147 app/Http/Controllers/SearchController.php:45 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#180db_collegesearch_new6.46ms

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

Bindings	0: ma 1: active
Backtrace	app/Http/Controllers/SearchController.php:180 app/Http/Controllers/SearchController.php:45 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#630db_collegesearch_new12.32ms

select count(*) as aggregate from (select * from `institute_programs` where `program_id` in (8929, 9067, 10346) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (20) group by `institute_id`) as `aggregate_table`

Bindings	0: 8929 1: 9067 2: 10346 3: active 4: 20
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new17.69ms

select * from `institute_programs` where `program_id` in (8929, 9067, 10346) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (20) 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 (20) 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 (20) 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 (20) 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: 8929 1: 9067 2: 10346 3: active 4: 20 5: nirf 6: 2024 7: 0 8: 20 9: active 10: active 11: nirf 12: 2024 13: 0 14: 20 15: active 16: active 17: cs 18: 0 19: 20 20: active 21: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new3.52ms

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 (20)) 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 (49402, 49421, 49423, 49443, 49499, 49511, 49528, 49532, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 51636) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 20 2: active 3: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new7.54ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (49402, 49421, 49423, 49443, 49499, 49511, 49528, 49532, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 51636) and `course_id` in (20) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 20
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new790μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new760μs

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (3, 69, 73, 85, 156, 194, 360, 370, 371, 385, 386, 397, 455, 553) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new1.2ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (74, 83, 91, 95, 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:630 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#630db_collegesearch_new780μs

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (49402, 49421, 49423, 49443, 49499, 49511, 49528, 49532, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 51636) and `institute_ratings`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new1.2ms

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 (49402, 49421, 49423, 49443, 49499, 49511, 49528, 49532, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 51636) 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:630 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#630db_collegesearch_new1.69ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#630db_collegesearch_new1.5ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (172601, 172682, 172695, 172754, 172981, 173013, 173060, 173068, 173565, 173573, 173844, 174165, 174288, 174393, 174445, 174729, 174930, 175044, 175057, 175091)

Backtrace

app/Http/Controllers/SearchController.php:630
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#630db_collegesearch_new1.12ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (49402, 49421, 49423, 49443, 49499, 49511, 49528, 49532, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 51636) and `ranking_body` = 'nirf' and `course_id` in (20) and `year` = 2024 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc, `rank` desc

Bindings	0: 49402 1: 49421 2: 49423 3: 49443 4: 49499 5: 49511 6: 49528 7: 49532 8: 49666 9: 49671 10: 49744 11: 49840 12: 49873 13: 49895 14: 49904 15: 50023 16: 50053 17: 50056 18: 50065 19: 51636 20: nirf 21: 20 22: 2024 23: active
Backtrace	app/Http/Controllers/SearchController.php:630 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#388db_collegesearch_new6.66ms

select * from `institute_programs` where `program_id` in (8929, 9067, 10346) and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (20) group by `institute_id`

Bindings	0: 8929 1: 9067 2: 10346 3: active 4: 20
Backtrace	app/Http/Controllers/SearchController.php:388 app/Http/Controllers/SearchController.php:58 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#388db_collegesearch_new7.81ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (1228, 1696, 2978, 3294, 3378, 3737, 4413, 4423, 4545, 4546, 4548, 4549, 4571, 4572, 4581, 4583, 4585, 4587, 4724, 4731, 4767, 4768, 4838, 4849, 4852, 4858, 4912, 4937, 4948, 4959, 4974, 4996, 6848, 8310, 8405, 8452, 8514, 8515, 8540, 8543, 9275, 10114, 10620, 10658, 10678, 10705, 10713, 13085, 13295, 13469, 13935, 14064, 15363, 15414, 15464, 15467, 15482, 15539, 15553, 15670, 15701, 15775, 17947, 17956, 17969, 17979, 18044, 18068, 18142, 18174, 18184, 18290, 18299, 18323, 18362, 18534, 18666, 18694, 18865, 19012, 19249, 19284, 19313, 19343, 19390, 19401, 19427, 19466, 19515, 19633, 19637, 19660, 19681, 19746, 19786, 19875, 19945, 20438, 20443, 20499, 20562, 20635, 21706, 36393, 36417, 36458, 36492, 36508, 36513, 36598, 36615, 36635, 36657, 36688, 36775, 36851, 36976, 37293, 37365, 37430, 37487, 37488, 37533, 37546, 37566, 37578, 37607, 37608, 37611, 37653, 37717, 37744, 37759, 37763, 37774, 37780, 37788, 37792, 37809, 37815, 37820, 37850, 37864, 37936, 37965, 37989, 38104, 38133, 38134, 38138, 38159, 38242, 38243, 38276, 38278, 38447, 38558, 38582, 38593, 38605, 38629, 38689, 38701, 38705, 38745, 38801, 38829, 38832, 38869, 38892, 38895, 38929, 38980, 39353, 39359, 39375, 39423, 39430, 39445, 39514, 39583, 39638, 39641, 39668, 39691, 39738, 39739, 39814, 39822, 39851, 39876, 39881, 39899, 39929, 39977, 39980, 39990, 40020, 40066, 40245, 40246, 40332, 40333, 40349, 40371, 40380, 40399, 40400, 40421, 40431, 40434, 40443, 40649, 40707, 40710, 40717, 40740, 40791, 40834, 40886, 40898, 40992, 41004, 41005, 41014, 41016, 41043, 41046, 41068, 41070, 41077, 41128, 41166, 41171, 41181, 41184, 41223, 41224, 41236, 41239, 41244, 41246, 41248, 41249, 41250, 41255, 41266, 41267, 41271, 41277, 41281, 41287, 41291, 41292, 41297, 41298, 41300, 41302, 41306, 41307, 41309, 41318, 41322, 41324, 41326, 41332, 41339, 41341, 41342, 41344, 41345, 41347, 41349, 41357, 41362, 41369, 41373, 41379, 41380, 41382, 41384, 41385, 41415, 41417, 41428, 41429, 41430, 41431, 41437, 41441, 41443, 41445, 41482, 41510, 41517, 41520, 41535, 41585, 41761, 41808, 41811, 41824, 41844, 41858, 41906, 41970, 41973, 42000, 42001, 42106, 42332, 42362, 42380, 42423, 42451, 42470, 42488, 42568, 42574, 42578, 42618, 42658, 42675, 42829, 42953, 43052, 43068, 43078, 43117, 43122, 43141, 43272, 43273, 43370, 43372, 43377, 43439, 43489, 43513, 43524, 43552, 43558, 43559, 43587, 43638, 43680, 43686, 43700, 43711, 43763, 43774, 43775, 43852, 43902, 43916, 43930, 44001, 44043, 44071, 44090, 44120, 44164, 44172, 44217, 44317, 44355, 44370, 44389, 44413, 44461, 44492, 44502, 44516, 44517, 44518, 44521, 44561, 44596, 44649, 45105, 45196, 45242, 45250, 45278, 45294, 45318, 45329, 45385, 45494, 45549, 45555, 45608, 45610, 45658, 45677, 45702, 45703, 45712, 45826, 45950, 46017, 46020, 46047, 46076, 46217, 46239, 46264, 46279, 46305, 46311, 46479, 46541, 46585, 46615, 46622, 46630, 46645, 46646, 46652, 46661, 46662, 46663, 46665, 46680, 46719, 46745, 46816, 46823, 46924, 46968, 47004, 47014, 47015, 47075, 47090, 47159, 47168, 47183, 47189, 47214, 47216, 47228, 47240, 47244, 47247, 47251, 47252, 47278, 47285, 47291, 47296, 47315, 47335, 47340, 47346, 47350, 47352, 47357, 47368, 47381, 47424, 47501, 47546, 47582, 47602, 47615, 47645, 47716, 47781, 47806, 47909, 47910, 47940, 47948, 48031, 48054, 48237, 48243, 48332, 48339, 48458, 48498, 48520, 48534, 48566, 48619, 48631, 48635, 48724, 48737, 48750, 48804, 48808, 48823, 48824, 48999, 49004, 49051, 49165, 49266, 49298, 49316, 49363, 49384, 49402, 49421, 49423, 49428, 49443, 49499, 49511, 49528, 49532, 49541, 49598, 49666, 49671, 49744, 49840, 49873, 49895, 49904, 50023, 50053, 50056, 50065, 50066, 50159, 50237, 50315, 50378, 50396, 50431, 50465, 50475, 50495, 50508, 50510, 50515, 50572, 50681, 50684, 50702, 50703, 50720, 50755, 50775, 50786, 50820, 50904, 50913, 50926, 50962, 50971, 50996, 50997, 51070, 51071, 51108, 51109, 51173, 51229, 51328, 51461, 51482, 51499, 51636, 51648, 51668, 51710, 51719, 51740, 51748, 51781, 51788, 51794, 51795, 51825, 51829, 51837, 51889, 51922, 52175, 52273, 52307, 52380, 52410, 52413, 52469, 52479, 52622, 52647, 52666, 52700, 52703, 52716, 52734, 52755, 52756, 52799, 52947, 52984, 53068, 53085, 53087, 53091, 53126, 53131, 53134, 53136, 53148, 53157, 53170) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:388 app/Http/Controllers/SearchController.php:58 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#388db_collegesearch_new4.54ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (3, 16, 30, 35, 36, 37, 38, 48, 60, 69, 70, 71, 72, 73, 75, 76, 85, 95, 97, 110, 118, 119, 122, 123, 125, 129, 132, 133, 138, 140, 141, 144, 154, 156, 157, 158, 159, 160, 161, 167, 170, 174, 175, 180, 183, 185, 186, 187, 188, 191, 192, 194, 197, 200, 209, 211, 213, 214, 221, 222, 224, 226, 231, 240, 241, 243, 248, 251, 253, 273, 274, 278, 281, 297, 360, 361, 362, 364, 365, 366, 367, 368, 370, 371, 372, 373, 374, 375, 376, 377, 380, 381, 382, 383, 384, 385, 386, 388, 390, 391, 392, 393, 394, 395, 397, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 411, 412, 413, 414, 449, 455, 456, 460, 469, 478, 496, 519, 549, 551, 553, 563, 565, 567, 568, 571, 577, 578, 583, 585, 588, 589, 590, 595, 599, 629, 639, 644, 701, 738, 741, 742, 743, 746, 750, 751, 754, 755, 761, 765, 804, 809, 837) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:388 app/Http/Controllers/SearchController.php:58 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#388db_collegesearch_new9.14ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (64, 66, 67, 69, 74, 75, 76, 78, 79, 80, 82, 83, 84, 87, 88, 90, 91, 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:388 app/Http/Controllers/SearchController.php:58 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#388db_collegesearch_new4.18ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (85533, 86346, 90627, 91657, 91768, 93211, 94565, 94587, 94841, 94870, 94882, 94903, 94956, 94975, 95080, 95096, 95120, 95135, 95341, 95386, 95451, 95478, 95599, 95631, 95648, 95665, 95753, 95799, 95843, 95874, 95910, 95994, 96577, 97451, 97496, 97504, 97535, 97544, 97574, 97596, 98452, 98857, 99522, 99540, 99561, 99589, 99606, 101361, 101557, 101703, 101966, 102077, 102849, 102880, 102919, 102939, 102995, 103024, 103041, 103146, 103178, 103231, 103725, 103759, 103783, 103802, 103888, 103985, 104308, 104433, 104461, 104871, 104901, 105087, 105192, 105812, 106067, 106112, 106462, 106837, 107258, 107304, 107397, 107418, 107569, 107601, 107655, 107786, 107888, 108123, 108139, 108208, 108242, 108265, 108288, 108407, 108495, 108970, 109005, 109108, 109197, 109469, 109482, 111512, 111630, 111730, 112057, 112140, 112252, 112376, 112486, 112802, 113289, 113867, 115527, 115847, 116114, 116394, 116402, 116544, 116728, 116796, 116895, 116996, 117096, 117190, 117218, 117265, 117305, 117326, 117353, 117382, 117490, 117518, 117551, 117690, 117753, 118036, 118176, 118351, 118713, 118848, 118924, 119017, 119033, 119059, 119125, 119497, 119517, 119716, 119727, 119793, 120679, 121326, 121569, 121625, 121635, 121759, 122056, 122199, 122205, 122335, 122700, 123059, 124429, 124489, 124560, 124680, 124712, 124794, 125098, 125403, 125657, 125677, 125866, 125967, 126158, 126167, 126562, 126574, 126605, 126691, 126799, 126970, 127336, 127361, 127374, 127424, 127593, 127727, 128743, 128748, 128866, 129224, 129299, 129414, 129443, 129528, 129623, 129684, 129694, 129729, 130792, 130901, 130910, 130928, 130981, 131202, 131300, 131314, 131549, 131569, 131705, 131860, 132123, 132136, 132240, 132291, 132315, 132513, 132526, 132645, 132728, 132773, 132804, 132855, 132872, 133284, 133295, 133474, 133501, 133522, 133529, 133547, 133578, 133594, 133639, 133647, 133668, 133725, 133764, 133804, 133813, 133861, 133878, 133911, 133938, 133968, 133981, 133989, 134018, 134042, 134174, 134196, 134234, 134263, 134278, 134302, 134324, 134376, 134421, 134651, 134699, 134740, 134787, 134807, 134859, 134912, 134957, 134983, 135004, 135044, 135092, 135109, 135185, 135215, 135234, 135243, 135346, 135373, 135427, 135452, 135527, 135547, 135565, 135596, 135628, 135868, 136022, 136057, 136069, 136139, 136425, 136456, 137188, 137383, 137389, 137445, 137520, 137611, 137818, 138263, 138282, 138433, 139086, 140115, 140182, 140443, 140734, 140808, 140854, 140894, 140989, 141310, 141361, 141382, 141596, 141749, 141824, 141902, 142296, 142911, 143223, 143662, 143749, 143793, 143847, 144020, 144054, 144105, 144719, 144727, 145359, 145371, 145394, 145626, 145913, 146063, 146114, 146282, 146327, 146332, 146481, 146524, 146674, 146936, 146972, 147020, 147073, 147244, 147278, 147285, 147497, 147644, 147703, 147747, 147780, 148127, 148317, 148355, 148421, 148449, 148677, 148822, 148837, 148972, 149396, 149580, 149691, 149903, 149978, 150159, 150305, 150349, 150354, 150360, 150383, 150544, 150735, 151096, 153104, 153415, 153566, 153588, 153755, 153896, 153954, 153981, 154796, 155203, 155588, 155681, 155688, 156035, 156163, 156191, 156510, 157001, 157580, 157715, 158398, 158424, 158733, 158868, 159049, 159181, 159317, 159335, 160278, 160553, 160822, 160908, 160960, 161003, 161073, 161082, 161107, 161133, 161142, 161148, 161154, 161208, 161349, 161436, 161510, 162371, 162555, 162772, 162779, 163083, 163124, 163336, 163447, 163524, 163578, 163602, 163620, 163651, 163702, 163714, 163745, 163788, 163809, 163818, 163826, 163832, 163967, 163986, 163999, 164011, 164075, 164135, 164160, 164199, 164211, 164226, 164242, 164294, 164347, 164497, 164502, 164758, 164821, 164984, 165141, 165232, 165291, 165415, 165812, 165949, 166539, 166550, 166582, 166764, 166826, 167351, 168102, 168469, 168501, 168978, 169200, 169315, 169350, 169462, 169639, 169732, 169767, 170175, 170226, 170295, 170414, 170569, 170591, 170663, 170670, 171229, 171246, 171387, 171749, 171932, 172126, 172263, 172315, 172470, 172538, 172601, 172682, 172695, 172754, 172981, 173013, 173060, 173068, 173565, 173573, 173844, 174165, 174288, 174393, 174445, 174729, 174930, 175044, 175057, 175091, 175101, 175602, 176073, 176283, 176441, 176524, 176630, 176680, 176766, 176805, 176848, 176925, 176954, 177045, 177142, 177318, 177938, 177965, 178013, 178017, 178081, 178266, 178371, 178424, 178634, 178714, 178745, 179014, 179057, 179091, 179217, 179286, 179369, 179382, 179783, 179832, 179840, 180210, 180395, 180918, 181803, 181873, 181935, 182531, 182603, 182752, 182811, 182930, 182999, 183130, 183154, 183185, 183193, 183351, 183365, 183564, 183779, 184322, 185029, 185839, 185961, 186213, 186353, 186362, 186403, 186612, 186680, 187252, 187371, 187446, 187577, 187595, 187648, 187768, 187838, 187998, 188505, 188748, 189604, 189713, 190046, 190166, 190391, 190469, 190497, 190782, 190919, 191299)

Backtrace

app/Http/Controllers/SearchController.php:388
app/Http/Controllers/SearchController.php:58
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#388db_collegesearch_new4.71ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:388 app/Http/Controllers/SearchController.php:58 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#392db_collegesearch_new1.25ms

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:392 app/Http/Controllers/SearchController.php:58 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#404db_collegesearch_new144ms

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:404 app/Http/Controllers/SearchController.php:58 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.47msselect * 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: 1023City.php#?
App\Models\InstituteProgram: 633InstituteProgram.php#?
App\Models\Institute: 633Institute.php#?
App\Models\State: 61State.php#?
App\Models\Program: 5Program.php#?
App\Models\Course: 3Course.php#?
App\Models\InstituteCourseSummary: 2InstituteCourseSummary.php#?
App\Models\DefaultMetaTag: 1DefaultMetaTag.php#?

_token: d8nXsi78G3Win4FiE0QEaGwLSePGt3Cp8Ydvb0AD
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/ma/colleges-ma-in-sociology?branch_id%5B0%5D=...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/ma/colleges-ma-in-sociology

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 => "9067"
  ]
]

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=17; course_name=MD; XSRF-TOKEN=eyJpdiI6IlBFZFBJTzU5QjhuMDYyUHF6MW1TaGc9PSIsInZhbHVlIjoiencyZjRNZXFQWE1kdHg2bjZScVVBNFJJY080YXl4OCtPdk1TSXptMElLVUZQT3pxWTFuR1ZhWTdwRG15bTR5dU83M1A2VG1XbGhYNHBDdmY3REUrUk5abzBYbThvNE96RW1xeWxONWdyeUJoZFFGYkdmSG5DM3NSWXkyVWFINysiLCJtYWMiOiI4NTZkYzFkYmM3NTc4MDE1MzI2ZTUxNWU2ZTRmZWZlYmNmNmNiZThlOGNmZjNiYTEyNTg4OTYxN2ExMjljMzM1IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6InVjc01tSE16Ymw0eXhKV2pnTjR6S2c9PSIsInZhbHVlIjoiZFlTWE00dmtrU0ZYdGdteU1QdEpsazhUNjhHTnF4Z3ZEUXI2T0hvdmNZakxuU3NZMkJ5bHR2UEJwdkdqSkd5YjhYREtEMFlaa1FBN3AzK0k5ci9UeVN1eStGaXVyb0trNHpodGhWTWZhR05JMGtzMWFFdzl0SW9YblNHMHQ5ZGMiLCJtYWMiOiI3ZTFhNjA3MDM5N2Y4N2IzNTM1ODEyZmZmOTdiOTIwNGQyYzllN2EzYjliMWFhZDZkYzc3YjIwYTlhNGRjMTg0IiwidGFnIjoiIn0%3D; viewed_colleges=%5B11570%2C2601%2C3643%5D ◀course_id=17; course_name=MD; XSRF-TOKEN=eyJpdiI6IlBFZFBJTzU5QjhuMDYyUHF6MW1TaGc9PSIsInZhbHVlIjoiencyZjRNZXFQWE1kdHg2bjZScVVBNFJJY080YXl4OCtPdk1TSXptMElLVUZQT3p ▶"
  ]
  "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" => "17"
  "course_name" => "MD"
  "XSRF-TOKEN" => "d8nXsi78G3Win4FiE0QEaGwLSePGt3Cp8Ydvb0AD"
  "laravel_session" => "wP7duzpyBpp2mDY9awKFYdoZ97Vd78HeqhfBuaSb"
  "viewed_colleges" => "[11570,2601,3643]"
]

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 => "Wed, 18 Jun 2025 07:18:51 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdHekdBMFdUTmFoU3FaSkpHTlJHUlE9PSIsInZhbHVlIjoieUxvY2FYL1J6LzBNUlViSVVsakxXM1Nya3ptVTR3L1ZqQ3RkazhJM28vOXBmcG1ZbXNDM3BrQ092SytaM2I1cGttSUxrd3pGN3BLWUxPRC9WSkVPOEdTSlY2d0EwemFqa3FsejBXZk93ZXJ5bjNLc3dpbU5UYy9ldUxYeHF2UkIiLCJtYWMiOiI0NjUwNzE5NzlkZWY0MDNjMWUxODFhYjI3NTgzYjIzNzY2MzRiYTAyZDJlMGNjMzkwYTFmMmIwZTFhNTc0MGRkIiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 09:18:51 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkdHekdBMFdUTmFoU3FaSkpHTlJHUlE9PSIsInZhbHVlIjoieUxvY2FYL1J6LzBNUlViSVVsakxXM1Nya3ptVTR3L1ZqQ3RkazhJM28vOXBmcG1ZbXNDM3BrQ092SytaM2I1cGttSUxrd ▶"
    1 => "laravel_session=eyJpdiI6IktudWtyUzlSRnBjSzdSMmVkMDFxV3c9PSIsInZhbHVlIjoidlZ6STZVWGJTbW85dEVKTEFqYUxkK1ZLempHb0RYelhTckxNV0VmbDZ0cERxcE8yY0hZaDhnL3ZVL0xwSlFCaGZJd29PSmE2ems2QzlBOTRyWVhVZjE2M2hQOHFEVGx2bU5jVVlwa2lXMWdFa2RyRlk3NGtqbyt5ZHVKUlkvVVciLCJtYWMiOiJmNmJiNDhmMjNjYTNlZWNmZTAwNjdlMDIwOTAwYzAxODVjODIxNzFkMDQ5YTU1ZjYzNTk0ZTY3YTlkODQ2ZDYwIiwidGFnIjoiIn0%3D; expires=Wed, 18 Jun 2025 09:18:51 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IktudWtyUzlSRnBjSzdSMmVkMDFxV3c9PSIsInZhbHVlIjoidlZ6STZVWGJTbW85dEVKTEFqYUxkK1ZLempHb0RYelhTckxNV0VmbDZ0cERxcE8yY0hZaDhnL3ZVL0xwSlFCaGZJ ▶"
    2 => "course_id=20; expires=Thu, 18 Jun 2026 07:18:51 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=MA; expires=Thu, 18 Jun 2026 07:18:51 GMT; Max-Age=31536000; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdHekdBMFdUTmFoU3FaSkpHTlJHUlE9PSIsInZhbHVlIjoieUxvY2FYL1J6LzBNUlViSVVsakxXM1Nya3ptVTR3L1ZqQ3RkazhJM28vOXBmcG1ZbXNDM3BrQ092SytaM2I1cGttSUxrd3pGN3BLWUxPRC9WSkVPOEdTSlY2d0EwemFqa3FsejBXZk93ZXJ5bjNLc3dpbU5UYy9ldUxYeHF2UkIiLCJtYWMiOiI0NjUwNzE5NzlkZWY0MDNjMWUxODFhYjI3NTgzYjIzNzY2MzRiYTAyZDJlMGNjMzkwYTFmMmIwZTFhNTc0MGRkIiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 09:18:51 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkdHekdBMFdUTmFoU3FaSkpHTlJHUlE9PSIsInZhbHVlIjoieUxvY2FYL1J6LzBNUlViSVVsakxXM1Nya3ptVTR3L1ZqQ3RkazhJM28vOXBmcG1ZbXNDM3BrQ092SytaM2I1cGttSUxrd ▶"
    1 => "laravel_session=eyJpdiI6IktudWtyUzlSRnBjSzdSMmVkMDFxV3c9PSIsInZhbHVlIjoidlZ6STZVWGJTbW85dEVKTEFqYUxkK1ZLempHb0RYelhTckxNV0VmbDZ0cERxcE8yY0hZaDhnL3ZVL0xwSlFCaGZJd29PSmE2ems2QzlBOTRyWVhVZjE2M2hQOHFEVGx2bU5jVVlwa2lXMWdFa2RyRlk3NGtqbyt5ZHVKUlkvVVciLCJtYWMiOiJmNmJiNDhmMjNjYTNlZWNmZTAwNjdlMDIwOTAwYzAxODVjODIxNzFkMDQ5YTU1ZjYzNTk0ZTY3YTlkODQ2ZDYwIiwidGFnIjoiIn0%3D; expires=Wed, 18-Jun-2025 09:18:51 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IktudWtyUzlSRnBjSzdSMmVkMDFxV3c9PSIsInZhbHVlIjoidlZ6STZVWGJTbW85dEVKTEFqYUxkK1ZLempHb0RYelhTckxNV0VmbDZ0cERxcE8yY0hZaDhnL3ZVL0xwSlFCaGZJ ▶"
    2 => "course_id=20; expires=Thu, 18-Jun-2026 07:18:51 GMT; path=/"
    3 => "course_name=MA; expires=Thu, 18-Jun-2026 07:18:51 GMT; path=/"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "d8nXsi78G3Win4FiE0QEaGwLSePGt3Cp8Ydvb0AD"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/ma/colleges-ma-in-sociology?branch_id%5B0%5D=9067"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-18 07:18:51	GET	/ma/colleges-ma-in-sociology?branch_id%5B%5D=9067	11 29 2361

1 x Application (97.38%)	492ms
1 x Booting (2.61%)	13.20ms