Top Bsc Colleges in Uttar Pradesh 2025 : Fees, Rankings, Placements, Admissions

Messages Timeline Exceptions Views11 Route Queries30 Models7443 Mails Gate Session Request

Request history8.3.19580ms17MBGET {course}/colleges-{filters}

Booting (11.09ms)time
Application (569ms)time
1 x Application (98.09%)
569ms
1 x Booting (1.91%)
11.09ms

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:24-74

30 statements were executed (2 duplicates)Show only duplicates391ms

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.56msselect * from `seo_redirects` where `redirect_from` = '/bsc/colleges-uttar-pradesh' limit 1

Bindings	0: /bsc/colleges-uttar-pradesh
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.9ms

select * from `meta_tags` where `slug` = 'bsc/colleges-uttar-pradesh' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: bsc/colleges-uttar-pradesh 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

SearchController.php#138db_collegesearch_new1.24ms

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

Bindings	0: uttar 1: pradesh 2: uttar-pradesh 3: active
Backtrace	app/Http/Controllers/SearchController.php:138 app/Http/Controllers/SearchController.php:41 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#138db_collegesearch_new2.53ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('uttar', 'pradesh', 'uttar-pradesh') 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: uttar 1: pradesh 2: uttar-pradesh 3: 2 4: active 5: 2
Backtrace	app/Http/Controllers/SearchController.php:138 app/Http/Controllers/SearchController.php:41 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#138db_collegesearch_new1.14ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:138 app/Http/Controllers/SearchController.php:41 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#138db_collegesearch_new920μsselect `id`, `name`, `slug` from `programs` where 0 = 1 and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:138 app/Http/Controllers/SearchController.php:41 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#171db_collegesearch_new830μs

select `id`, `display_name` 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/SearchController.php:171 app/Http/Controllers/SearchController.php:41 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#569db_collegesearch_new91.48ms

select count(*) as aggregate from (select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 95 and `institutes`.`deleted_at` is null and `status` = 'active') and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (23) group by `institute_id`) as `aggregate_table`

Bindings	0: 95 1: active 2: active 3: 23
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new132ms

select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 95 and `institutes`.`deleted_at` is null and `status` = 'active') and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (23) 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 (23) 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 (23) 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 (23) 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: 95 1: active 2: active 3: 23 4: nirf 5: 2024 6: 0 7: 23 8: active 9: active 10: nirf 11: 2024 12: 0 13: 23 14: active 15: active 16: cs 17: 0 18: 23 19: active 20: active
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new4.73ms

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 (23)) 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 (7202, 11749, 13167, 13311, 15357, 15691, 46952, 46969, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 23 2: active 3: active
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new1.59ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (7202, 11749, 13167, 13311, 15357, 15691, 46952, 46969, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158) and `course_id` in (23) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 23
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new970μs

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

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

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (72, 148, 153, 221, 273, 371, 374, 392, 395, 400, 412) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

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

select `id`, `name`, `shortname` from `states` where `states`.`id` in (95) 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:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new1.42ms

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (7202, 11749, 13167, 13311, 15357, 15691, 46952, 46969, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158) and `institute_ratings`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new2.04ms

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 (7202, 11749, 13167, 13311, 15357, 15691, 46952, 46969, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158) 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:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new1.36ms

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

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

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (22709, 26469, 32112, 39957, 41239, 75959, 154084, 162563, 162858, 163080, 163089, 163223, 163226, 163246, 163415, 163421, 163424, 163428, 163439, 163443)

Backtrace

app/Http/Controllers/SearchController.php:569
app/Http/Controllers/SearchController.php:47
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#569db_collegesearch_new860μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#569db_collegesearch_new2.26ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (7202, 11749, 13167, 13311, 15357, 15691, 46952, 46969, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158) and `ranking_body` = 'nirf' and `course_id` in (23) and `year` = 2024 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc, `rank` desc

Bindings	0: 7202 1: 11749 2: 13167 3: 13311 4: 15357 5: 15691 6: 46952 7: 46969 8: 47027 9: 47074 10: 47079 11: 47106 12: 47107 13: 47115 14: 47144 15: 47149 16: 47150 17: 47151 18: 47156 19: 47158 20: nirf 21: 23 22: 2024 23: active
Backtrace	app/Http/Controllers/SearchController.php:569 app/Http/Controllers/SearchController.php:47 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#327db_collegesearch_new87.83ms

select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 95 and `institutes`.`deleted_at` is null and `status` = 'active') and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (23) group by `institute_id`

Bindings	0: 95 1: active 2: active 3: 23
Backtrace	app/Http/Controllers/SearchController.php:327 app/Http/Controllers/SearchController.php:54 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#327db_collegesearch_new10.25ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (933, 952, 954, 957, 982, 1029, 2106, 2118, 2119, 2213, 2221, 2241, 2247, 2253, 2254, 2257, 2263, 2281, 2286, 2294, 2306, 2312, 2313, 2439, 2479, 2481, 2486, 2791, 3572, 3576, 3587, 3593, 3596, 3600, 3602, 4262, 4332, 4333, 4383, 4423, 4475, 4481, 4598, 4639, 4665, 4691, 4724, 4759, 4767, 4837, 4858, 4895, 4948, 4959, 4974, 4996, 6892, 7196, 7202, 7232, 7264, 7460, 7534, 7730, 8309, 8310, 8314, 8315, 8318, 8319, 8320, 8321, 8322, 8325, 8326, 8330, 8353, 8394, 8413, 8414, 8419, 8422, 8424, 8428, 8453, 8454, 8457, 8460, 8464, 8465, 8469, 8499, 8503, 8510, 8514, 8515, 8516, 8526, 8534, 8536, 8538, 8539, 8540, 8545, 8546, 8549, 8551, 8556, 8557, 8562, 8617, 8621, 8650, 8663, 8670, 8674, 8809, 9030, 9057, 9183, 9210, 9413, 9504, 9506, 9539, 9579, 9630, 9647, 9650, 9811, 9812, 9856, 9861, 9868, 9917, 9918, 9922, 10468, 10481, 10499, 10513, 10592, 10618, 10632, 10634, 10645, 10648, 10658, 10668, 10672, 10676, 10677, 10678, 10684, 10691, 11018, 11580, 11749, 11787, 11790, 12097, 12455, 12512, 12517, 12541, 12555, 12565, 12576, 12627, 13095, 13167, 13277, 13298, 13304, 13311, 13326, 13367, 13368, 13371, 13374, 13377, 13382, 13390, 13414, 13416, 13430, 13439, 13454, 13458, 13463, 13467, 13469, 13475, 13479, 13514, 13532, 13554, 13565, 13625, 13626, 13628, 13629, 13632, 13792, 13960, 13983, 14015, 14016, 14017, 14064, 14067, 14087, 14089, 14289, 14304, 14938, 14945, 15357, 15363, 15364, 15382, 15386, 15395, 15402, 15406, 15414, 15415, 15429, 15459, 15464, 15473, 15486, 15506, 15508, 15513, 15517, 15522, 15528, 15532, 15535, 15539, 15553, 15558, 15562, 15564, 15566, 15579, 15586, 15599, 15603, 15607, 15609, 15617, 15646, 15653, 15655, 15664, 15668, 15672, 15686, 15691, 15692, 15731, 15736, 15740, 15743, 15747, 15748, 15758, 15761, 15762, 16583, 16726, 16787, 17188, 17194, 17230, 17259, 17800, 17801, 17947, 17954, 17979, 18003, 18044, 18066, 18132, 18142, 18146, 18173, 18174, 18210, 18234, 18288, 18290, 18323, 18325, 18355, 18369, 18439, 18466, 18495, 18499, 18519, 18564, 18666, 18678, 18849, 18887, 18897, 18900, 18943, 18975, 18979, 18985, 18989, 18997, 19048, 19124, 19217, 19277, 19293, 19294, 19313, 19343, 19390, 19391, 19392, 19401, 19407, 19415, 19427, 19435, 19442, 19456, 19479, 19493, 19510, 19531, 19575, 19591, 19592, 19633, 19637, 19681, 19746, 19750, 19784, 19785, 19870, 19946, 19949, 20375, 20430, 20441, 20443, 20444, 20480, 20545, 20550, 20561, 20562, 20600, 20613, 20616, 20625, 29800, 30321, 30603, 31034, 31980, 32040, 32101, 33893, 34528, 34541, 34767, 35039, 36151, 36297, 36373, 36389, 36403, 36508, 36518, 36521, 36552, 36572, 36576, 36623, 36635, 36651, 36654, 36688, 36690, 36701, 36708, 36775, 36817, 36832, 36835, 36851, 36874, 36906, 36909, 36946, 36968, 36976, 36977, 36979, 36981, 36983, 37006, 37016, 37238, 37321, 37346, 37351, 37355, 37356, 37359, 37360, 37363, 37364, 37436, 37454, 37480, 37487, 37488, 37509, 37524, 37533, 37547, 37564, 37567, 37568, 37569, 37570, 37602, 37611, 37615, 37623, 37627, 37648, 37650, 37691, 37693, 37697, 37698, 37700, 37704, 37705, 37717, 37720, 37741, 37742, 37743, 37744, 37745, 37756, 37757, 37759, 37763, 37771, 37774, 37775, 37777, 37780, 37784, 37785, 37786, 37787, 37788, 37790, 37791, 37792, 37795, 37797, 37799, 37802, 37803, 37804, 37810, 37815, 37820, 37863, 37940, 37956, 37989, 37997, 38008, 38060, 38090, 38104, 38105, 38108, 38111, 38112, 38129, 38131, 38133, 38134, 38138, 38145, 38146, 38162, 38240, 38242, 38243, 38261, 38292, 38362, 38390, 38415, 38416, 38419, 38422, 38429, 38430, 38432, 38444, 38445, 38447, 38448, 38449, 38469, 38477, 38479, 38527, 38629, 38652, 38685, 38687, 38688, 38689, 38693, 38694, 38695, 38696, 38700, 38701, 38705, 38712, 38713, 38715, 38717, 38722, 38723, 38726, 38729, 38730, 38731, 38733, 38780, 38781, 38783, 38784, 38785, 38789, 38790, 38799, 38824, 38826, 38828, 38829, 38834, 38837, 38840, 38841, 38843, 38844, 38845, 38847, 38853, 38871, 39189, 39194, 39233, 39298, 39300, 39312, 39328, 39330, 39337, 39350, 39355, 39362, 39365, 39375, 39377, 39405, 39413, 39423, 39445, 39460, 39464, 39503, 39507, 39508, 39514, 39538, 39540, 39550, 39559, 39577, 39578, 39584, 39586, 39591, 39593, 39623, 39634, 39638, 39641, 39645, 39652, 39668, 39691, 39728, 39738, 39739, 39745, 39796, 39817, 39849, 39850, 39862, 39876, 39881, 39890, 39906, 39907, 39929, 39930, 39943, 39947, 39950, 39971, 39976, 39988, 39990, 39992, 39993, 40012, 40014, 40019, 40030, 40104, 40185, 40196, 40217, 40218, 40288, 40290, 40343, 40354, 40371, 40380, 40381, 40382, 40385, 40386, 40389, 40393, 40396, 40397, 40398, 40400, 40417, 40419, 40420, 40421, 40422, 40423, 40430, 40431, 40432, 40444, 40495, 40496, 40514, 40548, 40552, 40625, 40833, 40834, 40897, 40994, 41250, 41305, 41306, 41307, 41309, 41469, 41480, 41482, 41521, 41530, 41534, 41535, 41547, 41563, 41571, 41585, 41590, 41591, 41596, 41643, 41648, 41651, 41679, 41686, 41700, 41702, 41718, 41761, 41763, 41770, 41778, 41780, 41786, 41796, 41797, 41802, 41806, 41807, 41810, 41824, 41835, 41839, 41840, 41841, 41842, 41844, 41858, 41865, 41898, 41909, 41911, 41972, 42001, 42002, 42003, 42023, 42051, 42062, 42135, 42137, 42145, 42266, 42272, 42274, 42290, 42313, 42359, 42367, 42371, 42412, 42417, 42423, 42428, 42430, 42448, 42449, 42461, 42470, 42471, 42475, 42529, 42556, 42560, 42575, 42576, 42578, 42580, 42600, 42612, 42614, 42674, 42675, 42677, 42681, 42774, 42786, 42797, 42809, 42829, 42835, 42839, 42840, 42847, 42864, 42925, 42934, 42953, 42977, 42983, 42985, 43013, 43014, 43034, 43038, 43039, 43044, 43068, 43078, 43107, 43110, 43125, 43136, 43141, 43196, 43199, 43209, 43217, 43221, 43239, 43240, 43246, 43265, 43272, 43273, 43280, 43283, 43296, 43303, 43361, 43362, 43368, 43371, 43372, 43376, 43377, 43378, 43379, 43383, 43484, 43489, 43493, 43501, 43507, 43512, 43517, 43531, 43556, 43558, 43585, 43587, 43588, 43592, 43595, 43600, 43601, 43638, 43645, 43656, 43659, 43663, 43680, 43693, 43696, 43700, 43711, 43712, 43716, 43721, 43723, 43733, 43744, 43750, 43751, 43763, 43774, 43776, 43800, 43802, 43807, 43824, 43832, 43837, 43840, 43875, 43899, 43909, 43924, 43930, 43931, 43966, 44029, 44043, 44045, 44059, 44073, 44094, 44108, 44126, 44129, 44131, 44132, 44133, 44139, 44140, 44146, 44156, 44158, 44159, 44164, 44166, 44169, 44170, 44171, 44172, 44175, 44176, 44181, 44189, 44191, 44196, 44198, 44200, 44201, 44204, 44207, 44215, 44217, 44219, 44220, 44221, 44223, 44225, 44227, 44229, 44230, 44232, 44233, 44236, 44239, 44243, 44245, 44260, 44293, 44303, 44306, 44313, 44345, 44352, 44358, 44362, 44389, 44420, 44446, 44460, 44495, 44517, 44518, 44521, 44523, 44537, 44557, 44561, 44580, 44595, 44596, 44598, 44624, 44649, 44696, 44720, 44724, 44735, 44737, 44796, 44816, 44826, 44833, 44838, 44850, 44924, 44933, 44934, 44938, 45025, 45122, 45156, 45158, 45168, 45176, 45190, 45226, 45240, 45242, 45250, 45293, 45294, 45295, 45307, 45317, 45325, 45327, 45329, 45363, 45393, 45397, 45406, 45494, 45502, 45512, 45519, 45521, 45522, 45549, 45552, 45603, 45605, 45638, 45639, 45650, 45677, 45714, 45737, 45752, 45756, 45775, 45779, 45817, 45854, 45904, 45905, 45906, 45920, 45923, 45928, 45937, 45942, 45943, 45944, 45950, 45952, 45953, 45995, 46020, 46023, 46039, 46047, 46101, 46128, 46216, 46217, 46221, 46264, 46305, 46306, 46307, 46308, 46311, 46328, 46400, 46447, 46450, 46473, 46479, 46498, 46500, 46504, 46506, 46507, 46509, 46510, 46541, 46542, 46583, 46587, 46593, 46594, 46596, 46600, 46602, 46603, 46605, 46613, 46615, 46616, 46617, 46619, 46621, 46622, 46624, 46625, 46626, 46629, 46630, 46631, 46632, 46633, 46634, 46636, 46640, 46641, 46646, 46647, 46648, 46650, 46652, 46653, 46655, 46660, 46662, 46663, 46666, 46667, 46668, 46670, 46672, 46673, 46677, 46680, 46721, 46728, 46729, 46730, 46743, 46744, 46772, 46795, 46796, 46816, 46840, 46841, 46846, 46847, 46853, 46861, 46865, 46870, 46899, 46929, 46944, 46945, 46948, 46952, 46968, 46969, 46970, 46972, 46994, 47013, 47018, 47021, 47022, 47027, 47074, 47079, 47106, 47107, 47115, 47144, 47149, 47150, 47151, 47156, 47158, 47164, 47165, 47167, 47168, 47182, 47183, 47185, 47186, 47201, 47204, 47206, 47208, 47211, 47212, 47213, 47214, 47216, 47217, 47219, 47222, 47224, 47226, 47227, 47228, 47229, 47230, 47232, 47233, 47236, 47237, 47239, 47240, 47242, 47243, 47245, 47251, 47252, 47253, 47255, 47256, 47259, 47260, 47265, 47274, 47291, 47301, 47313, 47318, 47320, 47326, 47327, 47328, 47333, 47335, 47336, 47338, 47340, 47342, 47346, 47347, 47348, 47352, 47358, 47360, 47361, 47362, 47368, 47370, 47376, 47377, 47381, 47390, 47409, 47410, 47422, 47430, 47433, 47438, 47457, 47466, 47470, 47503, 47572, 47581, 47582, 47601, 47604, 47615, 47620, 47653, 47695, 47716, 47734, 47781, 47806, 47816, 47827, 47839, 47843, 47853, 47854, 47867, 47868, 47870, 47893, 47909, 47919, 47920, 47931, 47945, 47948, 48000, 48032, 48119, 48121, 48192, 48240, 48269, 48271, 48283, 48309, 48314, 48324, 48330, 48332, 48334, 48339, 48344, 48345, 48352, 48353, 48360, 48378, 48380, 48381, 48404, 48413, 48414, 48432, 48433, 48441, 48450, 48469, 48483, 48484, 48488, 48497, 48505, 48520, 48536, 48537, 48566, 48580, 48584, 48585, 48592, 48593, 48601, 48606, 48607, 48611, 48625, 48668, 48677, 48722, 48742, 48743, 48750, 48756, 48762, 48773, 48781, 48796, 48799, 48804, 48820, 48823, 48824, 48839, 48863, 48864, 48908, 48915, 48922, 48926, 48983, 48984, 48989, 48992, 48994, 48999, 49003, 49004, 49016, 49018, 49031, 49044, 49056, 49059, 49061, 49066, 49071, 49072, 49107, 49130, 49134, 49149, 49153, 49170, 49172, 49287, 49291, 49298, 49310, 49311, 49316, 49326, 49331, 49336, 49348, 49361, 49363, 49372, 49376, 49379, 49384, 49392, 49394, 49399, 49402, 49408, 49422, 49426, 49453, 49457, 49459, 49460, 49462, 49477, 49485, 49486, 49489, 49492, 49499, 49515, 49525, 49528, 49532, 49535, 49537, 49549, 49565, 49574, 49590, 49598, 49604, 49614, 49615, 49637, 49643, 49657, 49661, 49667, 49669, 49680, 49685, 49690, 49706, 49710, 49716, 49717, 49719, 49721, 49724, 49731, 49734, 49735, 49739, 49743, 49750, 49755, 49775, 49832, 49834, 49840, 49850, 49852, 49856, 49870, 49892, 49895, 49904, 49923, 49931, 49953, 49958, 49965, 49967, 50023, 50024, 50025, 50027, 50030, 50035, 50056, 50061, 50064, 50065, 50072, 50077, 50097, 50104, 50105, 50116, 50159, 50178, 50200, 50210, 50216, 50228, 50238, 50250, 50287, 50295, 50296, 50297, 50299, 50305, 50312, 50339, 50341, 50345, 50353, 50363, 50378, 50394, 50401, 50407, 50425, 50431, 50443, 50445, 50473, 50476, 50477, 50479, 50508, 50510, 50511, 50513, 50514, 50515, 50555, 50561, 50564, 50565, 50696, 50700, 50702, 50703, 50704, 50715, 50720, 50721, 50731, 50732, 50736, 50744, 50749, 50755, 50756, 50759, 50763, 50764, 50770, 50772, 50776, 50786, 50799, 50800, 50801, 50805, 50813, 50818, 50819, 50826, 50835, 50838, 50841, 50847, 50854, 50857, 50874, 50879, 50882, 50889, 50890, 50897, 50904, 50911, 50919, 50923, 50926, 50928, 50930, 50932, 50933, 50937, 50949, 50950, 50955, 50959, 50960, 50961, 50962, 50967, 50971, 50973, 50976, 50994, 50996, 50997, 51002, 51013, 51014, 51028, 51063, 51073, 51074, 51075, 51098, 51101, 51108, 51109, 51110, 51113, 51115, 51124, 51168, 51170, 51173, 51200, 51209, 51221, 51223, 51282, 51323, 51375, 51376, 51461, 51466, 51467, 51468, 51477, 51482, 51493, 51499, 51503, 51512, 51515, 51532, 51533, 51558, 51559, 51570, 51575, 51597, 51598, 51604, 51606, 51620, 51637, 51638, 51639, 51641, 51643, 51644, 51646, 51648, 51649, 51650, 51651, 51652, 51654, 51655, 51656, 51657, 51658, 51660, 51662, 51666, 51669, 51670, 51679, 51680, 51681, 51685, 51690, 51692, 51693, 51694, 51698, 51705, 51719, 51725, 51731, 51794, 51805, 51837, 51843, 51884, 51889, 51908, 51927, 51964, 51965, 51970, 51974, 51979, 51982, 52073, 52108, 52148, 52151, 52163, 52216, 52222, 52224, 52307, 52308, 52320, 52351, 52444, 52462, 52466, 52476, 52486, 52490, 52491, 52555, 52556, 52571, 52647, 52669, 52682, 52701, 52703, 52709, 52718, 52734, 52739, 52750, 52756, 52761, 52762, 52763, 52764, 52769, 52778, 52780, 52820, 52840, 52856, 52961, 52998, 53019, 53052) and `institutes`.`deleted_at` is null and `status` = 'active'

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

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (69, 70, 71, 72, 73, 74, 75, 76, 147, 148, 153, 162, 169, 170, 180, 185, 186, 187, 194, 221, 222, 239, 240, 241, 251, 273, 278, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 585, 809) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

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

select `id`, `name`, `shortname` from `states` where `states`.`id` in (95) 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:327 app/Http/Controllers/SearchController.php:54 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#327db_collegesearch_new19.54ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (13682, 13843, 13856, 13981, 14007, 16334, 17466, 17501, 18666, 19557, 19849, 20450, 20502, 20533, 20551, 20597, 20738, 22709, 22821, 23050, 23287, 23368, 23409, 23424, 23428, 23439, 23490, 23852, 23959, 23971, 23973, 24835, 25211, 25310, 25700, 26469, 26614, 28812, 29018, 29723, 29774, 30206, 31379, 31417, 31493, 31585, 31629, 31768, 31914, 32112, 32244, 32747, 34671, 35857, 36305, 36514, 37911, 38641, 39280, 39957, 40205, 40409, 40602, 40726, 41239, 41482, 41609, 42600, 43369, 43941, 44210, 44503, 47144, 49606, 49805, 49843, 49904, 49927, 49941, 53571, 53665, 55365, 55653, 55720, 55905, 57730, 59893, 59899, 59903, 59909, 59912, 59921, 59927, 59932, 59942, 59944, 60111, 60123, 60126, 60137, 60155, 60162, 60175, 60178, 60229, 60238, 60254, 60263, 60274, 60289, 60298, 60312, 60331, 60570, 60657, 60919, 61333, 61633, 61657, 62164, 62454, 62460, 62549, 62658, 62778, 62783, 63015, 63021, 63099, 63119, 63171, 63250, 63256, 64022, 64055, 64091, 64132, 64441, 64491, 64498, 64550, 64646, 64655, 64683, 64718, 64746, 65851, 69828, 71127, 71504, 71714, 71725, 71729, 71736, 71751, 71754, 71807, 71835, 71986, 72106, 72314, 73452, 73512, 73844, 75168, 75959, 76016, 76028, 76037, 76052, 76152, 76217, 76229, 76236, 76254, 76266, 76284, 76310, 76349, 76371, 76411, 76427, 76470, 76484, 76505, 76534, 76630, 76637, 76667, 76671, 76685, 76709, 76726, 76824, 76854, 76867, 76879, 76894, 77401, 77551, 77851, 77895, 77961, 78075, 78594, 78797, 78906, 79178, 79260, 79562, 79581, 79722, 79983, 80236, 80306, 80431, 80446, 80526, 80641, 80642, 80729, 81198, 81373, 81395, 81491, 81544, 81791, 81917, 82319, 82395, 83234, 83264, 84021, 87073, 87101, 87354, 87365, 87383, 87413, 87465, 87481, 88272, 90131, 92628, 92643, 92655, 92675, 92679, 94264, 94405, 94504, 94576, 95154, 95255, 95336, 95436, 95572, 95654, 95717, 95822, 95867, 95899, 95984, 96728, 96829, 96870, 97428, 97443, 97467, 97506, 97510, 97514, 97531, 97540, 97546, 97548, 97551, 97553, 97602, 97612, 97712, 97715, 97750, 98130, 98598, 99490, 99538, 99544, 101553, 101607, 101702, 101710, 101733, 101791, 102007, 102011, 102073, 102080, 102843, 102857, 102876, 102917, 103015, 103021, 103032, 103054, 103111, 103195, 103202, 103206, 103668, 103716, 103747, 103796, 103882, 104250, 104298, 104418, 104427, 104736, 104853, 105065, 105105, 105172, 105222, 105436, 105461, 105553, 105867, 106059, 106402, 106508, 106539, 106569, 106623, 106705, 106715, 106748, 106795, 106921, 107088, 107295, 107311, 107395, 107413, 107565, 107575, 107595, 107628, 107649, 107670, 107681, 107763, 107839, 107865, 107931, 107997, 108120, 108125, 108230, 108255, 108266, 108283, 108381, 108496, 108522, 108870, 108992, 108999, 109011, 109027, 109181, 109195, 109350, 109395, 109423, 109827, 110222, 110304, 110384, 110934, 111619, 111747, 111757, 111914, 111983, 112003, 112207, 112248, 112364, 112370, 112480, 112492, 112512, 112526, 112794, 113000, 113102, 113109, 113283, 113400, 113524, 113534, 113720, 113850, 113865, 113869, 113874, 113882, 113888, 113893, 114000, 114040, 115267, 115777, 115799, 115810, 115812, 115820, 115823, 115830, 115838, 116134, 116207, 116362, 116388, 116397, 116546, 116551, 116563, 116579, 116706, 116727, 116804, 116812, 116816, 116845, 116900, 116971, 116974, 117026, 117032, 117042, 117045, 117052, 117057, 117059, 117082, 117106, 117172, 117181, 117184, 117187, 117193, 117211, 117214, 117217, 117256, 117294, 117303, 117308, 117314, 117322, 117332, 117334, 117335, 117339, 117350, 117355, 117358, 117372, 117390, 117416, 117420, 117427, 117429, 117437, 117501, 117513, 117549, 117719, 118088, 118152, 118347, 118373, 118403, 118450, 118451, 118616, 118865, 118916, 118929, 118939, 118950, 118953, 118987, 118992, 119012, 119027, 119055, 119071, 119132, 119482, 119493, 119510, 119596, 119768, 120173, 120334, 120516, 120522, 120532, 120533, 120592, 120600, 120603, 120639, 120641, 120647, 120670, 120675, 120829, 120833, 121023, 121322, 121442, 121546, 121553, 121559, 121560, 121579, 121585, 121593, 121605, 121607, 121621, 121623, 121633, 121650, 121652, 121654, 121660, 121686, 121688, 121692, 121695, 121699, 121944, 121949, 121953, 121956, 121964, 121966, 122046, 122181, 122189, 122191, 122194, 122209, 122213, 122217, 122218, 122226, 122229, 122232, 122234, 122243, 122254, 122282, 122356, 123303, 123820, 123997, 124243, 124253, 124266, 124299, 124383, 124441, 124459, 124504, 124509, 124553, 124563, 124605, 124643, 124677, 124791, 124841, 124851, 125054, 125075, 125077, 125089, 125198, 125225, 125282, 125324, 125377, 125382, 125410, 125419, 125432, 125437, 125609, 125641, 125653, 125660, 125747, 125771, 125862, 125963, 126131, 126153, 126163, 126203, 126213, 126408, 126555, 126570, 126639, 126730, 126732, 126969, 126981, 127064, 127112, 127159, 127173, 127300, 127351, 127411, 127416, 127420, 127440, 127445, 127451, 127564, 127567, 127591, 127632, 127677, 128049, 128324, 128465, 128627, 128628, 129263, 129269, 129278, 129286, 129348, 129408, 129433, 129439, 129445, 129447, 129451, 129460, 129468, 129476, 129501, 129503, 129510, 129523, 129593, 129608, 129611, 129614, 129629, 129646, 129677, 129679, 129686, 129731, 129938, 129940, 130127, 130272, 130287, 130677, 133536, 133651, 133954, 133960, 133977, 133986, 134009, 134781, 135232, 135376, 135815, 135847, 135863, 136071, 136121, 136131, 136134, 136206, 136244, 136282, 136454, 136471, 136478, 136497, 136702, 136742, 136748, 136837, 136946, 136988, 136993, 137182, 137198, 137207, 137233, 137240, 137245, 137317, 137320, 137355, 137374, 137377, 137386, 137429, 137486, 137504, 137507, 137508, 137510, 137517, 137598, 137651, 137776, 137839, 137859, 138008, 138269, 138444, 138451, 138542, 138764, 138885, 139348, 139351, 139371, 139974, 140014, 140019, 140106, 140120, 140372, 140513, 140579, 140701, 140717, 140728, 140780, 140784, 140787, 140804, 140843, 140848, 140872, 140890, 140897, 140921, 141136, 141260, 141289, 141348, 141363, 141380, 141392, 141486, 141572, 141577, 141870, 141888, 141933, 141958, 142436, 142467, 142482, 142486, 142511, 142582, 142650, 142750, 142898, 143007, 143053, 143060, 143222, 143288, 143334, 143337, 143463, 143467, 143613, 143619, 143623, 143630, 143742, 143790, 143952, 144039, 144091, 144098, 144379, 144386, 144406, 144439, 144447, 144591, 144606, 144619, 144689, 144716, 144724, 144751, 144756, 144859, 144911, 145304, 145306, 145347, 145361, 145365, 145386, 145391, 145396, 145401, 145417, 145534, 145866, 145907, 145931, 145974, 145985, 146052, 146082, 146174, 146210, 146309, 146323, 146465, 146477, 146489, 146513, 146531, 146546, 146549, 146669, 146761, 146848, 146859, 146880, 146916, 146999, 147005, 147016, 147069, 147085, 147090, 147101, 147104, 147159, 147163, 147187, 147201, 147207, 147242, 147272, 147289, 147361, 147366, 147384, 147419, 147427, 147438, 147584, 147628, 147663, 147730, 147739, 147767, 147773, 147874, 148122, 148181, 148261, 148323, 148451, 148549, 148731, 148733, 148737, 148740, 148748, 148755, 148756, 148766, 148797, 148802, 148804, 148818, 148824, 148830, 148831, 148833, 148835, 148850, 148852, 148859, 148872, 148876, 148899, 148902, 148910, 148912, 148920, 148928, 148932, 148965, 148968, 148977, 148979, 148982, 148985, 148988, 148990, 148996, 149003, 149012, 149016, 149020, 149027, 149033, 149039, 149084, 149269, 149306, 149327, 149347, 149492, 149529, 149595, 149645, 149889, 150011, 150104, 150150, 150295, 150353, 150356, 150380, 150391, 150434, 150536, 150540, 150670, 150723, 150728, 150738, 150928, 151095, 151244, 151323, 151338, 151400, 151406, 151653, 151765, 151823, 151846, 151854, 151901, 152190, 152223, 152227, 152235, 152279, 152630, 153132, 153174, 153292, 153295, 153315, 153338, 153376, 153488, 153556, 153562, 153587, 153888, 153892, 153900, 153923, 153947, 153969, 153973, 153976, 154084, 154230, 154354, 154384, 154793, 154843, 154866, 154910, 154939, 154944, 155091, 155584, 155655, 155659, 155774, 155775, 155867, 155882, 156029, 156207, 156273, 156437, 156447, 156676, 156692, 157127, 157428, 157430, 157433, 157496, 157501, 157516, 157534, 157542, 157544, 157549, 157578, 157588, 157591, 157721, 157772, 157840, 158209, 158355, 158415, 158727, 158729, 158787, 159040, 159315, 159319, 159322, 159324, 159333, 159439, 159936, 160121, 160132, 160252, 160269, 160350, 160359, 160367, 160374, 160380, 160386, 160389, 160526, 160556, 160744, 160747, 160749, 160752, 160829, 160883, 160904, 160912, 160918, 160927, 160942, 160947, 160953, 160983, 160986, 160988, 160995, 160999, 161007, 161014, 161015, 161018, 161021, 161026, 161028, 161033, 161053, 161058, 161060, 161079, 161084, 161086, 161088, 161096, 161098, 161103, 161111, 161121, 161126, 161136, 161146, 161155, 161159, 161160, 161200, 161206, 161370, 161388, 161395, 161397, 161422, 161427, 161505, 161596, 161659, 161660, 161676, 161681, 161713, 161762, 161851, 161896, 161957, 162033, 162048, 162091, 162097, 162406, 162454, 162457, 162459, 162552, 162563, 162567, 162577, 162679, 162761, 162822, 162828, 162829, 162858, 163080, 163089, 163223, 163226, 163246, 163415, 163421, 163424, 163428, 163439, 163443, 163492, 163499, 163502, 163521, 163589, 163591, 163610, 163646, 163653, 163657, 163659, 163674, 163691, 163693, 163695, 163696, 163709, 163718, 163727, 163729, 163734, 163736, 163740, 163752, 163756, 163759, 163761, 163767, 163770, 163774, 163777, 163781, 163798, 163810, 163824, 163830, 163835, 163852, 163856, 163872, 163877, 163888, 163950, 163997, 164018, 164067, 164079, 164083, 164098, 164104, 164111, 164125, 164131, 164137, 164144, 164154, 164171, 164195, 164200, 164204, 164225, 164245, 164250, 164253, 164255, 164289, 164300, 164335, 164339, 164346, 164353, 164365, 164443, 164446, 164491, 164538, 164556, 164567, 164629, 164662, 164672, 164766, 165086, 165136, 165138, 165228, 165241, 165283, 165305, 165428, 165777, 165810, 165945, 166023, 166080, 166091, 166119, 166147, 166173, 166175, 166257, 166360, 166501, 166538, 166576, 166617, 166663, 166701, 166772, 166798, 166815, 167075, 167202, 167560, 167564, 167872, 168047, 168222, 168230, 168287, 168358, 168375, 168424, 168455, 168462, 168473, 168492, 168511, 168516, 168539, 168541, 168558, 168612, 168617, 168619, 168796, 168811, 168883, 168885, 168933, 168986, 169022, 169053, 169058, 169059, 169074, 169091, 169196, 169243, 169310, 169353, 169354, 169455, 169528, 169535, 169537, 169552, 169558, 169600, 169612, 169613, 169621, 169647, 169873, 169941, 170147, 170250, 170252, 170293, 170345, 170389, 170422, 170452, 170544, 170553, 170562, 170654, 170662, 170668, 170697, 170793, 170795, 170933, 170941, 170972, 170977, 171196, 171200, 171208, 171214, 171216, 171225, 171242, 171244, 171276, 171299, 171331, 171380, 171400, 171409, 171416, 171440, 171447, 171452, 171559, 171636, 171662, 171716, 171775, 171779, 172220, 172231, 172238, 172244, 172258, 172290, 172298, 172313, 172349, 172360, 172385, 172426, 172460, 172461, 172506, 172514, 172520, 172535, 172566, 172577, 172592, 172597, 172613, 172690, 172702, 172782, 172791, 172796, 172798, 172817, 172889, 172910, 172915, 172927, 172934, 172942, 172980, 173026, 173049, 173059, 173067, 173071, 173080, 173094, 173141, 173238, 173274, 173331, 173358, 173380, 173384, 173432, 173472, 173529, 173545, 173568, 173608, 173625, 173640, 173656, 173703, 173724, 173726, 173732, 173740, 173777, 173785, 173788, 173824, 173842, 173848, 173871, 173885, 173982, 173995, 174145, 174147, 174161, 174191, 174206, 174214, 174273, 174379, 174388, 174442, 174482, 174505, 174585, 174784, 174805, 174809, 174893, 174922, 174942, 174945, 174948, 174977, 174998, 175050, 175076, 175083, 175087, 175109, 175120, 175229, 175251, 175305, 175380, 175599, 175705, 175808, 175926, 175978, 176042, 176076, 176258, 176264, 176361, 176399, 176405, 176415, 176437, 176515, 176577, 176580, 176628, 176639, 176677, 176693, 176730, 176740, 176763, 176787, 176841, 176846, 176851, 176857, 176949, 176956, 176958, 176971, 177059, 177065, 177135, 177246, 177273, 177279, 177281, 178002, 178006, 178016, 178021, 178039, 178073, 178083, 178155, 178158, 178168, 178205, 178241, 178262, 178272, 178304, 178313, 178318, 178348, 178359, 178374, 178403, 178550, 178552, 178555, 178571, 178596, 178656, 178675, 178682, 178689, 178718, 178733, 178746, 178822, 178845, 178854, 178906, 178910, 178982, 179011, 179052, 179061, 179070, 179085, 179105, 179136, 179140, 179143, 179152, 179181, 179188, 179194, 179200, 179208, 179213, 179264, 179273, 179282, 179315, 179321, 179361, 179365, 179376, 179393, 179435, 179439, 179532, 179680, 179702, 179704, 179705, 179732, 179813, 179818, 179828, 179838, 179844, 179851, 179857, 179889, 180184, 180187, 180202, 180275, 180334, 180356, 180432, 180783, 181127, 181426, 181433, 181792, 181810, 181813, 181815, 181857, 181870, 181899, 181931, 181969, 182010, 182040, 182148, 182167, 182213, 182216, 182277, 182289, 182380, 182382, 182401, 182405, 182425, 182512, 182514, 182517, 182519, 182521, 182528, 182538, 182541, 182545, 182547, 182550, 182553, 182559, 182560, 182563, 182566, 182575, 182577, 182579, 182588, 182589, 182598, 182619, 182621, 182624, 182648, 182679, 182686, 182690, 182695, 182703, 182732, 182805, 182881, 183013, 183178, 183238, 183420, 183545, 183561, 183710, 183876, 184037, 184049, 184061, 184079, 184083, 184501, 184657, 184884, 184894, 184935, 185179, 185200, 185218, 185957, 185968, 185990, 186028, 186055, 186573, 186600, 186653, 186742, 186759, 186762, 187046, 187080, 187261, 187366, 187453, 187496, 187581, 187584, 187599, 187656, 187764, 187780, 187816, 187864, 187867, 187871, 187873, 187884, 187910, 187916, 188114, 188160, 188202, 188814, 188980, 189047, 189231)

Backtrace

app/Http/Controllers/SearchController.php:327
app/Http/Controllers/SearchController.php:54
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#327db_collegesearch_new1.95ms

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (11, 12, 14, 15, 21, 22, 23, 26, 27, 30, 38, 47, 48, 91, 93, 110, 116, 131, 140, 149, 153, 161, 174, 184, 185, 2008, 2009, 2018, 2222, 2240, 2342, 2366, 2395) and `exams`.`deleted_at` is null and `status` = 'active'

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

select `id`, `name`, `slug` from `programs` where `programs`.`id` in (916, 918, 919, 920, 922, 924, 926, 929, 930, 931, 933, 935, 943, 956, 960, 967, 980, 1003, 1005, 1030, 1042, 1057, 1059, 1063, 1070, 1077, 1091, 1092, 1169, 1205, 1209, 1231, 3448, 3586, 3599, 3620, 3665, 3672, 3704, 3764, 3777, 3937, 4696, 4764, 4846, 4907, 4959, 5064, 5240, 5538, 6080, 6253, 6453, 6538, 6977, 6978, 6980, 6981, 6988, 6990, 6991, 7003, 7009, 7011, 7052, 7078, 7101, 7104, 7110, 7130, 7134, 7136, 7138, 7148, 7150, 7171, 7177, 7204, 7211, 7213, 7215, 7222, 7231, 7244, 7250, 7276, 7277, 7326, 7332, 10741) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/SearchController.php:327 app/Http/Controllers/SearchController.php:54 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#331db_collegesearch_new1.66ms

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:331 app/Http/Controllers/SearchController.php:54 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#343db_collegesearch_new1.7ms

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

Bindings	0: 95 1: active
Backtrace	app/Http/Controllers/SearchController.php:343 app/Http/Controllers/SearchController.php:54 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#156db_collegesearch_new1.52msselect * from `brandings` where `section` = 'sr' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: sr 1: active
Backtrace	app/helpers.php:156 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\InstituteProgramExamMapping: 3592InstituteProgramExamMapping.php#?
App\Models\InstituteProgram: 1748InstituteProgram.php#?
App\Models\Institute: 1748Institute.php#?
App\Models\City: 174City.php#?
App\Models\Program: 90Program.php#?
App\Models\State: 38State.php#?
App\Models\Exam: 28Exam.php#?
App\Models\InstituteCourseSummary: 11InstituteCourseSummary.php#?
App\Models\InstituteImage: 6InstituteImage.php#?
App\Models\InstituteRating: 5InstituteRating.php#?
App\Models\Course: 3Course.php#?

_token: MF2sw3PKoNAyAPZkUl0YCEmrimncpPGrsrUst3B6
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/bsc/colleges-uttar-pradesh" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/bsc/colleges-uttar-pradesh

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

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, 09 Apr 2025 02:18:57 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9GdE0zUnRFbXlZWFcramlCcmcrdWc9PSIsInZhbHVlIjoiMUtOc0pCa2grZkprQTU2WXl3OGFpRGxSK09ZMEw5cFUyVmNMYXVPSEplYUhISVd3czkvdGgzc0FSVkEzYnlLWHlXS2V4ckVIS2IwT2xQQUVtQ3hVRzlPZUR3MmZPaUFPbmpIcFZzR2liTnZINCttWHVDcEJNajNKWWdOWWkwMVQiLCJtYWMiOiIxMTY3ZmY2N2UzMDZlMjI0MmJmMWRjZDBhYjFhNjY0YWRmZjk3ODIwOTNkZTFmNTg3MTVhZjhlMTQ3NWI1NzNkIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 04:18:57 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im9GdE0zUnRFbXlZWFcramlCcmcrdWc9PSIsInZhbHVlIjoiMUtOc0pCa2grZkprQTU2WXl3OGFpRGxSK09ZMEw5cFUyVmNMYXVPSEplYUhISVd3czkvdGgzc0FSVkEzYnlLWHlXS2V4c ▶"
    1 => "laravel_session=eyJpdiI6Ik5wWGxyVUhmYkhlMlJOSGZFVjZ1TUE9PSIsInZhbHVlIjoiOU10N2NYakdPTWc4TlhqMVZkWGZzTndpc3grQ21jRW5UWDU4d3VYYWhLOVJmeEhwbFFOSnBwTFRQMFB6OXRDekoyeGZydi9ud1VhWTJFTlFYVjBzbXBndXBHN3lneU1yTUREOFZZMDNWUVhKbWJ3TlRadktIaXQ0anhTODg5a2IiLCJtYWMiOiJiNWExZWFhMWE1ZTIzZWVlMTFkZDkwMjcyOWM2OGJiMWQzMDAyMmE1MzAyZGE2ZGViMGE0NmZlODQ2YWY1NGFkIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 04:18:57 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ik5wWGxyVUhmYkhlMlJOSGZFVjZ1TUE9PSIsInZhbHVlIjoiOU10N2NYakdPTWc4TlhqMVZkWGZzTndpc3grQ21jRW5UWDU4d3VYYWhLOVJmeEhwbFFOSnBwTFRQMFB6OXRDekoy ▶"
    2 => "course_id=23; expires=Thu, 09 Apr 2026 02:18:57 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=Bsc; expires=Thu, 09 Apr 2026 02:18:57 GMT; Max-Age=31536000; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9GdE0zUnRFbXlZWFcramlCcmcrdWc9PSIsInZhbHVlIjoiMUtOc0pCa2grZkprQTU2WXl3OGFpRGxSK09ZMEw5cFUyVmNMYXVPSEplYUhISVd3czkvdGgzc0FSVkEzYnlLWHlXS2V4ckVIS2IwT2xQQUVtQ3hVRzlPZUR3MmZPaUFPbmpIcFZzR2liTnZINCttWHVDcEJNajNKWWdOWWkwMVQiLCJtYWMiOiIxMTY3ZmY2N2UzMDZlMjI0MmJmMWRjZDBhYjFhNjY0YWRmZjk3ODIwOTNkZTFmNTg3MTVhZjhlMTQ3NWI1NzNkIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 04:18:57 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im9GdE0zUnRFbXlZWFcramlCcmcrdWc9PSIsInZhbHVlIjoiMUtOc0pCa2grZkprQTU2WXl3OGFpRGxSK09ZMEw5cFUyVmNMYXVPSEplYUhISVd3czkvdGgzc0FSVkEzYnlLWHlXS2V4c ▶"
    1 => "laravel_session=eyJpdiI6Ik5wWGxyVUhmYkhlMlJOSGZFVjZ1TUE9PSIsInZhbHVlIjoiOU10N2NYakdPTWc4TlhqMVZkWGZzTndpc3grQ21jRW5UWDU4d3VYYWhLOVJmeEhwbFFOSnBwTFRQMFB6OXRDekoyeGZydi9ud1VhWTJFTlFYVjBzbXBndXBHN3lneU1yTUREOFZZMDNWUVhKbWJ3TlRadktIaXQ0anhTODg5a2IiLCJtYWMiOiJiNWExZWFhMWE1ZTIzZWVlMTFkZDkwMjcyOWM2OGJiMWQzMDAyMmE1MzAyZGE2ZGViMGE0NmZlODQ2YWY1NGFkIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 04:18:57 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6Ik5wWGxyVUhmYkhlMlJOSGZFVjZ1TUE9PSIsInZhbHVlIjoiOU10N2NYakdPTWc4TlhqMVZkWGZzTndpc3grQ21jRW5UWDU4d3VYYWhLOVJmeEhwbFFOSnBwTFRQMFB6OXRDekoy ▶"
    2 => "course_id=23; expires=Thu, 09-Apr-2026 02:18:57 GMT; path=/"
    3 => "course_name=Bsc; expires=Thu, 09-Apr-2026 02:18:57 GMT; path=/"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "MF2sw3PKoNAyAPZkUl0YCEmrimncpPGrsrUst3B6"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/bsc/colleges-uttar-pradesh"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 02:18:57	GET	/bsc/colleges-uttar-pradesh	11 30 7443

1 x Application (98.09%)	569ms
1 x Booting (1.91%)	11.09ms