Top B Pharmacy Colleges in India 2025 : Fees, Rankings, Placements, Admissions

Messages1 Timeline Exceptions Views11 Route Queries30 Models6159 Mails Gate Session Request

Request history8.3.19633ms16MBGET {course}-colleges-india

warninglog[09:13:04] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...

Booting (11.21ms)time
Application (622ms)time
1 x Application (98.23%)
622ms
1 x Booting (1.77%)
11.21ms

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-india
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\SearchController@index
as: sr.india
namespace
prefix
where
file: app/Http/Controllers/SearchController.php:24-74

30 statements were executed413ms

SoftRedirects.php#22db_collegesearch_newConnection Established

Backtrace

app/Http/Middleware/SoftRedirects.php:22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

SoftRedirects.php#22db_collegesearch_new9.18msselect * from `seo_redirects` where `redirect_from` = '/bpharm-colleges-india' limit 1

Bindings	0: /bpharm-colleges-india
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.67ms

select * from `meta_tags` where `slug` = 'bpharm-colleges-india' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: bpharm-colleges-india 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.64msselect `id`, `name`, `slug` from `exams` where `slug` in ('') and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1: 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_new1.51ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('') 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: 1: 2 2: active 3: 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_new3.04ms

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

Bindings	0: 1: 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_new5.57ms

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

Bindings	0: 1: 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_new1.33ms

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

Bindings	0: bpharm 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_new18.84ms

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

Bindings	0: active 1: 11
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_new59.93ms

select * from `institute_programs` where `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (11) 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 (11) 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 (11) 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 (11) 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: active 1: 11 2: nirf 3: 2024 4: 0 5: 11 6: active 7: active 8: nirf 9: 2024 10: 0 11: 11 12: active 13: active 14: cs 15: 0 16: 11 17: active 18: 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_new12.4ms

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 (11)) 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 (248, 296, 493, 1047, 1057, 1888, 2405, 2742, 2756, 3902, 3903, 4030, 4062, 4123, 7723, 11585, 11798, 13311, 17434, 19205) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 11 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_new2.35ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (248, 296, 493, 1047, 1057, 1888, 2405, 2742, 2756, 3902, 3903, 4030, 4062, 4123, 7723, 11585, 11798, 13311, 17434, 19205) and `course_id` in (11) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 11
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.07ms

select `id`, `name`, `duration` from `courses` where `courses`.`id` in (11) 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.67ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (10, 39, 44, 57, 61, 64, 80, 85, 103, 105, 109, 148, 150, 157, 285, 292) 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.55ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (72, 74, 75, 76, 79, 83, 90, 91, 93, 95, 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: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.52ms

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (248, 296, 493, 1047, 1057, 1888, 2405, 2742, 2756, 3902, 3903, 4030, 4062, 4123, 7723, 11585, 11798, 13311, 17434, 19205) 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_new4.27ms

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 (248, 296, 493, 1047, 1057, 1888, 2405, 2742, 2756, 3902, 3903, 4030, 4062, 4123, 7723, 11585, 11798, 13311, 17434, 19205) 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.84ms

select `id`, `name`, `slug` from `courses` where `courses`.`id` in (11) 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_new2.25ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (36338, 45552, 45684, 46064, 47308, 47331, 49060, 50451, 51336, 51393, 54246, 54249, 54553, 54596, 54709, 67457, 68322, 71540, 78316, 111259)

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.38ms

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (20, 21, 22, 23, 26, 27, 47, 93, 116, 2009) 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.4ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (248, 296, 493, 1047, 1057, 1888, 2405, 2742, 2756, 3902, 3903, 4030, 4062, 4123, 7723, 11585, 11798, 13311, 17434, 19205) and `ranking_body` = 'nirf' and `course_id` in (11) and `year` = 2024 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc, `rank` desc

Bindings	0: 248 1: 296 2: 493 3: 1047 4: 1057 5: 1888 6: 2405 7: 2742 8: 2756 9: 3902 10: 3903 11: 4030 12: 4062 13: 4123 14: 7723 15: 11585 16: 11798 17: 13311 18: 17434 19: 19205 20: nirf 21: 11 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_new19.16ms

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

Bindings	0: active 1: 11
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.23ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (31, 49, 63, 125, 172, 177, 186, 224, 241, 246, 248, 252, 257, 290, 296, 451, 464, 493, 557, 559, 567, 653, 673, 702, 934, 939, 948, 952, 954, 956, 957, 962, 965, 967, 970, 971, 972, 973, 976, 977, 980, 983, 1000, 1033, 1047, 1051, 1057, 1066, 1137, 1419, 1457, 1577, 1583, 1606, 1645, 1802, 1873, 1876, 1877, 1888, 1919, 1920, 1927, 1941, 2087, 2096, 2105, 2128, 2140, 2156, 2167, 2209, 2221, 2227, 2231, 2253, 2254, 2259, 2272, 2289, 2294, 2304, 2305, 2313, 2327, 2328, 2365, 2405, 2416, 2424, 2486, 2513, 2535, 2551, 2558, 2570, 2576, 2602, 2668, 2675, 2681, 2696, 2707, 2711, 2717, 2728, 2730, 2742, 2756, 2785, 2795, 2838, 3059, 3126, 3139, 3154, 3215, 3300, 3302, 3577, 3611, 3663, 3736, 3737, 3738, 3879, 3881, 3882, 3883, 3884, 3885, 3886, 3887, 3888, 3889, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3898, 3899, 3901, 3902, 3903, 3904, 3906, 3907, 3908, 3910, 3911, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3920, 3922, 3923, 3924, 3925, 3926, 3927, 3928, 3929, 3930, 3931, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3939, 3940, 3942, 3943, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3952, 3953, 3954, 3955, 3957, 3958, 3959, 3960, 3962, 3963, 3964, 3965, 3966, 3967, 3968, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3987, 3988, 3989, 3990, 3991, 3992, 3994, 3995, 3996, 3997, 3998, 3999, 4001, 4002, 4007, 4008, 4009, 4010, 4011, 4012, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4023, 4024, 4025, 4026, 4027, 4029, 4030, 4031, 4032, 4033, 4034, 4035, 4037, 4038, 4039, 4040, 4041, 4044, 4046, 4047, 4048, 4049, 4055, 4057, 4058, 4059, 4060, 4061, 4062, 4063, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4072, 4073, 4075, 4076, 4077, 4078, 4080, 4081, 4082, 4083, 4084, 4085, 4086, 4087, 4088, 4089, 4090, 4091, 4092, 4094, 4095, 4096, 4098, 4099, 4100, 4101, 4103, 4104, 4106, 4107, 4108, 4109, 4110, 4112, 4113, 4114, 4115, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4133, 4134, 4135, 4136, 4138, 4139, 4140, 4141, 4142, 4143, 4144, 4145, 4146, 4148, 4149, 4150, 4151, 4153, 4154, 4155, 4156, 4158, 4159, 4160, 4161, 4162, 4163, 4164, 4165, 4166, 4167, 4168, 4175, 4319, 4388, 4393, 4400, 4410, 4448, 4691, 4788, 4837, 4993, 5011, 5089, 5097, 5140, 5199, 5294, 5397, 5404, 5471, 5715, 5755, 6100, 6191, 6268, 6614, 6918, 7102, 7123, 7137, 7202, 7309, 7365, 7375, 7400, 7413, 7417, 7418, 7427, 7460, 7467, 7476, 7506, 7534, 7597, 7608, 7632, 7638, 7644, 7645, 7659, 7665, 7666, 7683, 7707, 7723, 7730, 7736, 7756, 7760, 7801, 7822, 8018, 8083, 8121, 8282, 8311, 8419, 8555, 8561, 8571, 8605, 8610, 8613, 8658, 8670, 8751, 8753, 8779, 8782, 8783, 8796, 8809, 8822, 8827, 8837, 8851, 8877, 8906, 8913, 8916, 8929, 8981, 8987, 8994, 8999, 9004, 9006, 9009, 9028, 9030, 9033, 9036, 9037, 9038, 9041, 9046, 9052, 9054, 9056, 9057, 9058, 9059, 9060, 9062, 9063, 9064, 9065, 9066, 9067, 9069, 9073, 9074, 9078, 9079, 9080, 9085, 9103, 9155, 9161, 9166, 9173, 9189, 9249, 9252, 9254, 9343, 9363, 9383, 9406, 9412, 9420, 9433, 9437, 9454, 9470, 9474, 9481, 9490, 9501, 9512, 9517, 9521, 9522, 9523, 9524, 9525, 9526, 9528, 9529, 9532, 9533, 9552, 9553, 9554, 9558, 9564, 9566, 9567, 9569, 9598, 9599, 9604, 9606, 9608, 9609, 9613, 9615, 9622, 9626, 9627, 9628, 9629, 9641, 9652, 9655, 9660, 9661, 9664, 9665, 9667, 9669, 9670, 9676, 9679, 9681, 9682, 9683, 9685, 9686, 9688, 9689, 9691, 9693, 9694, 9695, 9697, 9703, 9704, 9706, 9708, 9710, 9711, 9712, 9713, 9714, 9717, 9720, 9723, 9740, 9741, 9744, 9792, 9800, 9833, 9834, 9835, 9836, 9837, 9839, 9841, 9842, 9843, 9861, 9866, 9882, 9885, 9907, 9911, 9913, 9955, 9959, 9997, 10032, 10039, 10042, 10043, 10044, 10057, 10070, 10076, 10077, 10083, 10087, 10104, 10111, 10112, 10115, 10118, 10119, 10127, 10131, 10135, 10136, 10138, 10139, 10142, 10151, 10152, 10153, 10159, 10164, 10169, 10170, 10171, 10175, 10176, 10178, 10179, 10183, 10189, 10193, 10197, 10201, 10205, 10207, 10215, 10216, 10221, 10235, 10242, 10244, 10247, 10254, 10255, 10256, 10261, 10302, 10310, 10312, 10429, 10430, 10439, 10443, 10444, 10445, 10446, 10534, 11059, 11143, 11360, 11386, 11391, 11412, 11421, 11424, 11428, 11430, 11431, 11436, 11437, 11443, 11447, 11455, 11570, 11580, 11585, 11596, 11631, 11672, 11712, 11716, 11717, 11718, 11735, 11749, 11780, 11781, 11784, 11785, 11786, 11787, 11790, 11797, 11798, 11805, 11810, 11822, 11973, 11996, 11998, 12001, 12003, 12008, 12010, 12012, 12037, 12038, 12039, 12041, 12044, 12046, 12047, 12054, 12060, 12063, 12064, 12078, 12079, 12090, 12097, 12108, 12113, 12139, 12143, 12145, 12147, 12148, 12158, 12160, 12177, 12183, 12185, 12187, 12189, 12192, 12204, 12222, 12531, 12537, 12628, 12629, 12670, 12719, 12757, 12984, 13004, 13126, 13167, 13192, 13214, 13249, 13304, 13311, 13341, 13407, 13432, 13445, 13462, 13481, 13522, 13551, 13628, 13631, 13649, 13658, 13684, 13685, 13691, 13702, 13771, 13787, 13903, 13932, 13965, 13983, 14142, 14213, 14217, 14241, 14250, 14253, 14255, 14285, 14290, 14299, 14303, 14316, 14388, 14448, 14573, 14588, 14600, 14607, 14609, 14680, 14718, 14745, 14793, 14862, 14882, 14886, 14910, 14930, 14933, 14946, 14966, 14971, 14985, 14986, 15011, 15052, 15053, 15055, 15057, 15068, 15275, 15684, 15967, 16087, 16207, 16232, 16245, 16701, 16726, 16908, 17122, 17158, 17163, 17179, 17182, 17197, 17214, 17224, 17235, 17236, 17251, 17259, 17273, 17285, 17290, 17293, 17294, 17426, 17434, 17738, 17743, 17754, 17779, 17782, 17789, 17806, 17827, 17965, 17974, 17978, 17994, 18041, 18043, 18091, 18156, 18174, 18214, 18288, 18302, 18304, 18313, 18347, 18391, 18410, 18414, 18437, 18462, 18472, 18473, 18489, 18557, 18604, 18635, 18687, 18688, 18710, 18736, 18742, 18773, 18779, 18847, 18869, 18884, 18895, 18927, 18937, 18978, 19002, 19023, 19025, 19081, 19097, 19121, 19145, 19154, 19166, 19187, 19205, 19237, 19238, 19275, 19340, 19351, 19370, 19423, 19486, 19516, 19528, 19584, 19800, 20069, 20304, 20341, 20431, 20466, 20487, 20488, 20518, 20554, 20555, 29800, 29883, 29968, 29998, 30004, 30016, 30102, 30185, 30186, 30321, 30413, 30599, 30648, 31034, 31615, 31652, 31952, 31986, 32040, 32095, 32096, 32101, 32168, 32472, 32934, 33893, 33896, 33899, 33900, 33901, 33903, 33904, 33905, 33912, 33913, 33916, 33917, 33918, 33919, 33920, 33921, 33923, 33926, 33928, 33934, 33936, 34031, 34165, 34189, 34467, 34468, 34492, 34541, 34578, 34587, 34626, 34767, 34934, 35101, 35163, 35191, 35368, 35391, 35644, 35855, 36151, 36297, 36372, 36393, 36395, 36396, 36397, 36398, 36399, 36400, 36401, 36418, 36425, 36428, 36441, 36444, 36455, 36461, 36506, 36527, 36550, 36605, 36607, 36626, 36633, 36642, 36663, 36666, 36673, 36680, 36717, 36721, 36735, 36736, 36749, 36751, 36763, 36815, 36850, 36866, 36895, 36898, 36954, 36987, 37009, 37012, 37017, 37030, 37048, 37101, 37127, 37145, 37156, 37158, 37169, 37176, 37226, 37231, 37239, 37316, 37333, 37342, 37375, 37381, 37409, 37429, 37446, 37453, 37456, 37457, 37459, 37497, 37521, 37522, 37527, 37598, 37711, 37767, 37796, 37800, 37829, 37848, 37876, 37913, 38014, 38018, 38044, 38053, 38054, 38058, 38108, 38115, 38125, 38141, 38176, 38180, 38181, 38184, 38212, 38213, 38225, 38228, 38250, 38284, 38336, 38392, 38397, 38410, 38450, 38461, 38470, 38472, 38490, 38536, 38613, 38651, 38661, 38666, 38684, 38742, 38743, 38757, 38776, 38786, 38806, 38830, 38852, 38875, 38985, 38996, 39001, 39006, 39102, 39197, 39198, 39199, 39200, 39201, 39202, 39239, 39255, 39263, 39274, 39283, 39295, 39306, 39307, 39309, 39327, 39364, 39406, 39426, 39447, 39469, 39485, 39497, 39505, 39527, 39528, 39556, 39565, 39615, 39628, 39633, 39650, 39699, 39711, 39731, 39736, 39745, 39747, 39748, 39752, 39767, 39811, 39818, 39823, 39827, 39828, 39829, 39832, 39840, 39841, 39845, 39851, 39861, 39886, 39951, 39965, 39982, 40004, 40015, 40016, 40026, 40050, 40080, 40096, 40110, 40121, 40159, 40171, 40175, 40247, 40276, 40357, 40383, 40404, 40416, 40426, 40451, 40459, 40500, 40510, 40519, 40520, 40541, 40542, 40543, 40577, 40584, 40593, 40597, 40605, 40608, 40609, 40610, 40615, 40626, 40940, 40941, 40942, 40943, 40944, 41120, 41168, 41350, 41351, 41454, 41487, 41499, 41505, 41516, 41594, 41606, 41628, 41653, 41663, 41664, 41667, 41731, 41742, 41773, 41794, 41813, 41868, 41881, 41882, 41883, 41897, 41913, 41960, 41985, 41986, 42020, 42030, 42037, 42060, 42065, 42117, 42132, 42146, 42169, 42227, 42228, 42229, 42235, 42254, 42270, 42275, 42302, 42305, 42311, 42315, 42345, 42399, 42401, 42415, 42476, 42483, 42490, 42493, 42496, 42516, 42534, 42537, 42558, 42627, 42629, 42639, 42644, 42647, 42655, 42685, 42697, 42721, 42727, 42778, 42785, 42789, 42804, 42825, 42849, 42852, 42871, 42939, 42978, 42979, 42992, 43133, 43146, 43153, 43160, 43194, 43222, 43231, 43263, 43295, 43306, 43334, 43352, 43386, 43411, 43419, 43420, 43457, 43464, 43510, 43519, 43523, 43524, 43538, 43541, 43561, 43620, 43622, 43651, 43685, 43695, 43737, 43739, 43767, 43786, 43796, 43828, 43846, 43855, 43883, 43937, 43947, 43958, 43959, 43967, 44013, 44091, 44097, 44106, 44218, 44302, 44304, 44374, 44385, 44406, 44417, 44447, 44453, 44458, 44473, 44511, 44528, 44600, 44618, 44629, 44634, 44644, 44686, 44825, 44878, 44883, 44887, 44893, 44907, 44912, 44916, 44925, 44952, 45002, 45012, 45020, 45078, 45122, 45139, 45189, 45191, 45217, 45232, 45234, 45235, 45253, 45262, 45275, 45304, 45330, 45408, 45473, 45504, 45516, 45528, 45538, 45698, 45707, 45710, 45736, 45746, 45791, 45812, 45844, 45860, 45864, 45876, 45879, 45895, 45907, 45929, 45931, 45961, 45964, 45974, 45978, 45996, 46005, 46006, 46011, 46022, 46092, 46135, 46165, 46198, 46209, 46242, 46266, 46267, 46301, 46406, 46474, 46477, 46478, 46485, 46493, 46526, 46537, 46544, 46547, 46562, 46589, 46592, 46601, 46684, 46752, 46762, 46763, 46766, 46770, 46774, 46775, 46776, 46778, 46779, 46923, 46924, 46925, 46928, 46942, 46960, 46963, 46978, 46982, 46987, 46992, 47045, 47046, 47085, 47121, 47135, 47184, 47307, 47308, 47367, 47412, 47425, 47449, 47460, 47461, 47465, 47479, 47481, 47499, 47524, 47534, 47560, 47563, 47567, 47575, 47584, 47593, 47596, 47618, 47641, 47664, 47665, 47667, 47707, 47714, 47784, 47872, 47938, 47966, 48008, 48014, 48017, 48029, 48060, 48065, 48072, 48083, 48091, 48107, 48163, 48166, 48178, 48215, 48226, 48253, 48255, 48260, 48267, 48280, 48285, 48317, 48318, 48370, 48411, 48476, 48477, 48502, 48512, 48557, 48575, 48602, 48655, 48664, 48669, 48695, 48698, 48703, 48714, 48725, 48757, 48774, 48790, 48798, 48822, 48828, 48842, 48867, 48902, 48903, 48931, 48945, 49020, 49021, 49026, 49053, 49074, 49082, 49109, 49121, 49189, 49207, 49211, 49253, 49337, 49419, 49425, 49662, 49704, 49705, 49712, 49730, 49747, 49761, 49762, 49764, 49765, 49770, 49792, 49798, 49807, 49826, 49968, 49979, 49980, 49981, 50017, 50018, 50036, 50046, 50109, 50110, 50122, 50124, 50140, 50142, 50144, 50169, 50191, 50194, 50263, 50266, 50304, 50337, 50358, 50533, 50563, 50575, 50588, 50600, 50605, 50609, 50610, 50617, 50621, 50696, 50714, 50806, 50827, 50852, 50869, 50872, 50948, 50965, 50969, 51021, 51022, 51024, 51032, 51058, 51072, 51085, 51121, 51151, 51228, 51237, 51252, 51257, 51301, 51316, 51320, 51351, 51356, 51358, 51366, 51393, 51452, 51483, 51495, 51510, 51521, 51537, 51554, 51555, 51587, 51616, 51622, 51630, 51634, 51699, 51708, 51733, 51734, 51765, 51774, 51799, 51802, 51863, 51880, 51890, 51929, 51930, 51943, 51948, 51981, 51990, 51999, 52052, 52134, 52150, 52226, 52235, 52250, 52271, 52273, 52304, 52334, 52344, 52363, 52364, 52365, 52373, 52429, 52436, 52453, 52468, 52502, 52515, 52614, 52627, 52628, 52630, 52641, 52656, 52667, 52675, 52676, 52691, 52692, 52727, 52776, 52783, 52786, 52819, 52848, 52921, 52943, 53005, 53010, 53011, 53016, 53018, 53023, 53025, 53034, 53048, 53071, 53082, 53087, 53088, 53089, 53102, 53108, 53130, 53137, 53146, 53157, 53160) 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_new101ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (2, 3, 5, 6, 10, 12, 13, 15, 16, 17, 19, 20, 22, 24, 25, 28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 43, 44, 45, 47, 48, 50, 51, 52, 53, 55, 56, 57, 58, 59, 60, 61, 63, 64, 65, 66, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 82, 83, 85, 87, 88, 89, 90, 91, 92, 94, 95, 96, 97, 99, 102, 103, 104, 105, 107, 108, 109, 110, 112, 114, 116, 117, 118, 119, 120, 122, 123, 125, 126, 127, 128, 129, 131, 132, 133, 135, 137, 138, 140, 141, 143, 146, 147, 148, 150, 152, 153, 155, 156, 157, 158, 159, 161, 162, 163, 165, 167, 168, 169, 170, 171, 172, 173, 174, 175, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 200, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 220, 221, 222, 224, 225, 226, 227, 228, 229, 230, 231, 233, 237, 239, 240, 241, 242, 244, 245, 246, 247, 248, 251, 254, 260, 261, 263, 265, 270, 273, 277, 278, 281, 282, 285, 292, 294, 297, 299, 302, 304, 305, 312, 313, 319, 321, 324, 325, 326, 332, 336, 337, 339, 347, 353, 357, 359, 360, 361, 362, 364, 365, 366, 368, 371, 373, 374, 375, 377, 380, 381, 382, 383, 384, 385, 386, 392, 393, 394, 398, 400, 401, 402, 403, 405, 406, 409, 410, 412, 417, 427, 429, 430, 433, 435, 438, 442, 444, 451, 453, 462, 463, 466, 469, 470, 471, 472, 476, 478, 480, 482, 490, 491, 493, 497, 502, 508, 523, 549, 550, 551, 552, 553, 555, 557, 558, 560, 562, 563, 566, 567, 568, 576, 585, 587, 591, 593, 594, 606, 607, 608, 610, 612, 613, 614, 615, 623, 629, 640, 644, 683, 689, 691, 700, 702, 704, 707, 716, 719, 731, 734, 741, 742, 756, 760, 777, 798, 804, 833, 834, 835, 836, 837, 840, 841) 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.52ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (64, 66, 67, 69, 70, 72, 73, 74, 75, 76, 77, 78, 79, 80, 82, 83, 86, 88, 89, 90, 91, 92, 93, 94, 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: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_new11.66ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (5854, 5855, 10841, 11083, 25733, 36338, 45171, 45188, 45301, 45383, 45396, 45431, 45494, 45521, 45545, 45552, 45594, 45614, 45666, 45684, 45963, 46026, 46064, 46174, 46392, 46454, 46521, 46988, 46996, 47019, 47026, 47060, 47068, 47079, 47083, 47092, 47096, 47102, 47112, 47118, 47126, 47135, 47154, 47187, 47271, 47308, 47331, 47360, 47412, 47946, 48051, 48357, 48391, 48442, 48559, 48987, 49009, 49021, 49060, 49138, 49143, 49178, 49218, 49535, 49561, 49576, 49666, 49701, 49726, 49832, 49862, 49928, 49944, 49979, 50036, 50059, 50126, 50134, 50152, 50182, 50197, 50357, 50451, 50517, 50535, 50681, 50815, 50873, 50889, 50908, 50917, 51127, 51171, 51199, 51270, 51283, 51336, 51393, 51563, 51904, 52064, 52105, 52131, 52266, 53586, 53688, 53764, 54206, 54209, 54212, 54218, 54221, 54224, 54226, 54229, 54232, 54234, 54238, 54240, 54242, 54244, 54246, 54249, 54274, 54277, 54280, 54284, 54288, 54293, 54297, 54300, 54303, 54305, 54307, 54308, 54312, 54317, 54318, 54324, 54325, 54330, 54337, 54338, 54340, 54343, 54349, 54353, 54358, 54361, 54366, 54369, 54372, 54373, 54376, 54378, 54383, 54388, 54396, 54397, 54401, 54404, 54411, 54417, 54420, 54425, 54428, 54431, 54435, 54439, 54443, 54447, 54453, 54456, 54457, 54461, 54465, 54468, 54470, 54471, 54479, 54486, 54489, 54493, 54507, 54514, 54519, 54520, 54521, 54525, 54528, 54531, 54533, 54535, 54538, 54540, 54543, 54547, 54549, 54553, 54554, 54559, 54565, 54577, 54578, 54579, 54586, 54589, 54596, 54599, 54602, 54608, 54611, 54620, 54621, 54628, 54630, 54636, 54639, 54645, 54647, 54650, 54652, 54655, 54658, 54661, 54664, 54669, 54673, 54677, 54681, 54682, 54687, 54688, 54692, 54694, 54696, 54705, 54707, 54709, 54710, 54713, 54716, 54720, 54724, 54725, 54728, 54729, 54730, 54734, 54737, 54738, 54744, 54747, 54748, 54750, 54751, 54752, 54755, 54759, 54763, 54766, 54767, 54768, 54785, 54787, 54789, 54795, 54797, 54799, 54800, 55152, 56327, 56493, 56534, 56593, 56630, 56712, 56793, 56804, 56946, 57032, 57324, 57747, 57818, 57969, 58317, 58405, 58473, 58490, 58512, 58571, 58621, 58737, 58777, 58829, 58933, 58948, 59054, 59086, 59107, 59108, 59153, 59156, 59207, 59297, 59352, 59395, 59443, 59462, 59545, 59564, 59705, 59749, 59787, 59858, 59881, 60116, 60306, 60356, 60439, 60549, 60626, 60841, 60842, 60846, 60880, 60916, 60964, 61047, 61102, 61189, 61194, 61216, 61235, 61240, 61245, 61274, 61285, 61296, 61304, 61307, 61324, 61330, 61331, 61337, 61342, 61345, 61351, 61353, 61357, 61369, 61373, 61376, 61377, 61393, 61449, 61569, 61607, 61640, 61700, 61705, 61951, 61996, 62063, 62159, 62195, 62271, 62321, 62392, 62402, 62412, 62438, 62477, 62521, 62532, 62534, 62537, 62539, 62543, 62573, 62576, 62578, 62631, 62712, 62717, 62720, 62721, 62727, 62748, 62758, 62767, 62798, 62799, 62805, 62810, 62812, 62816, 62824, 62830, 62833, 62837, 62845, 62846, 62849, 62850, 62856, 62857, 62861, 62869, 62871, 62873, 62874, 62877, 62878, 62885, 62886, 62918, 62921, 62991, 63006, 63053, 63058, 63061, 63068, 63125, 63141, 63193, 63221, 63225, 63231, 63304, 63308, 63375, 63417, 63422, 63426, 63436, 63487, 63490, 63507, 63508, 63513, 63514, 63538, 63546, 63553, 63558, 63572, 63573, 63583, 63586, 63588, 63593, 63600, 63602, 63606, 63612, 63635, 63653, 63676, 63684, 63694, 63698, 63709, 63957, 63958, 63972, 63980, 63982, 66022, 66309, 66886, 66930, 66958, 66963, 66976, 66982, 66983, 66988, 67335, 67422, 67457, 67549, 67655, 67735, 67847, 67911, 67920, 67972, 68014, 68146, 68154, 68171, 68215, 68226, 68250, 68258, 68300, 68322, 68359, 68390, 68439, 68772, 68784, 68812, 68851, 68855, 68876, 68888, 68896, 68960, 68992, 69042, 69047, 69050, 69052, 69100, 69109, 69136, 69145, 69155, 69159, 69226, 70095, 70344, 70464, 70516, 70995, 71019, 71275, 71339, 71379, 71417, 71518, 71540, 71623, 71799, 71837, 71880, 71943, 72014, 72084, 72265, 72304, 72345, 72383, 72450, 72500, 72812, 72861, 73209, 73253, 73346, 73394, 73778, 73800, 73843, 73850, 73924, 73969, 74084, 74263, 74468, 74507, 74529, 74548, 74667, 74739, 74775, 74843, 74956, 74993, 75003, 75064, 75121, 75150, 75200, 75215, 75217, 75235, 75248, 75289, 75310, 75319, 75385, 75402, 75764, 77091, 77150, 77209, 77237, 77250, 77498, 77523, 77587, 77704, 77725, 77736, 77824, 77836, 77909, 77927, 77982, 77992, 78051, 78066, 78095, 78143, 78164, 78176, 78185, 78280, 78316, 78418, 78437, 78491, 78535, 78559, 78579, 78611, 78661, 78732, 78781, 78790, 78872, 78879, 78945, 79079, 79182, 79298, 79317, 79535, 79552, 79688, 79743, 79746, 79793, 79815, 79905, 79945, 80024, 80144, 80157, 80261, 80345, 80367, 80532, 80787, 80913, 81087, 81106, 81248, 81285, 81299, 81342, 81381, 81386, 81540, 81554, 81661, 81675, 81711, 81746, 81748, 81789, 81861, 81889, 82068, 82218, 82225, 82308, 82338, 82393, 82437, 82452, 82497, 82587, 82674, 82818, 82902, 82910, 82912, 82914, 82916, 82920, 82923, 82930, 82935, 82937, 82944, 82948, 83001, 83091, 83097, 83164, 83179, 83187, 83254, 83343, 83384, 83447, 83526, 83546, 83638, 83719, 83743, 83788, 83806, 83899, 83974, 84010, 84029, 84382, 84458, 85070, 85117, 86404, 87109, 87288, 87340, 87369, 88376, 89270, 89350, 89654, 89710, 90110, 90155, 91669, 91677, 93066, 93193, 93273, 93592, 93595, 93601, 93605, 93613, 93618, 93621, 93639, 93644, 93650, 93660, 93668, 93683, 93689, 93697, 93701, 93706, 93714, 93722, 93724, 93729, 93733, 93738, 93745, 93748, 93757, 93764, 93766, 93769, 93773, 93776, 93780, 93785, 93792, 93794, 93800, 93813, 93817, 93842, 93845, 93846, 93853, 93857, 93863, 93868, 93871, 93875, 93883, 93887, 93889, 93893, 93898, 93902, 93909, 93922, 93927, 93932, 93935, 93939, 93940, 93949, 93973, 93978, 93985, 93995, 93997, 94001, 94003, 94006, 94010, 94021, 94027, 94031, 94038, 94042, 94046, 94050, 94057, 94060, 94070, 94075, 94077, 94097, 94375, 94539, 94552, 94631, 95266, 95525, 95576, 95922, 96035, 96090, 96104, 96331, 96645, 96681, 96984, 97154, 97276, 97632, 97697, 97707, 97890, 97915, 98015, 98033, 98042, 98056, 98058, 98061, 98102, 98131, 98133, 98138, 98157, 98173, 98184, 98187, 98190, 98199, 98257, 98283, 98372, 98479, 98500, 98512, 98513, 98521, 98526, 98534, 98542, 98554, 98555, 98561, 98571, 98574, 98581, 98587, 98590, 98593, 98607, 98641, 98645, 98648, 98652, 98653, 98656, 98661, 98664, 98673, 98678, 98733, 98738, 98741, 98745, 98750, 98771, 98812, 98813, 98825, 98828, 98832, 98847, 98859, 98862, 98868, 98879, 98884, 98889, 98895, 98902, 98918, 98931, 98932, 98938, 98962, 98965, 98980, 98986, 99000, 99064, 99080, 99082, 99278, 99285, 99451, 100075, 100085, 100095, 100102, 100105, 100107, 100389, 100409, 100419, 100430, 100436, 100450, 100457, 100460, 100463, 100467, 100499, 100508, 100511, 100515, 100530, 100562, 100572, 100577, 100593, 100886, 101002, 101381, 101682, 101810, 101821, 102132, 102205, 102207, 102237, 102241, 102287, 102513, 102668, 103158, 103400, 103790, 104426, 104904, 105047, 105149, 105313, 105386, 105401, 105424, 105453, 105480, 105856, 105932, 106130, 106197, 106235, 106398, 106495, 106534, 106613, 106700, 106816, 106866, 106973, 107002, 107067, 107133, 107148, 107224, 107291, 107509, 107639, 107894, 107901, 108025, 108947, 109497, 109515, 109617, 109736, 109737, 109738, 109739, 109741, 109745, 109748, 109750, 109752, 110237, 110262, 110276, 110348, 110427, 111087, 111259, 111788, 111909, 112079, 112083, 112208, 112220, 112278, 112396, 112414, 112442, 112459, 112565, 112642, 112643, 112656, 112691, 112701, 112751, 112868, 112996, 113278, 113340, 113384, 113510, 113527, 113783, 113909, 114019, 114080, 114114, 114137, 114257, 114490, 114628, 114719, 114778, 114804, 114869, 114914, 115025, 115228, 115240, 115268, 115678, 115745, 115773, 115888, 115900, 115988, 116107, 116173, 116204, 116210, 116217, 116234, 116429, 116561, 116697, 116730, 116885, 117067, 117409, 117421, 117659, 117765, 117916, 118429, 118437, 118548, 118572, 118575, 118600, 118831, 118937, 118956, 118980, 119065, 119167, 119179, 119192, 119198, 119355, 119359, 119439, 119451, 119537, 119743, 120008, 120241, 120336, 120384, 120492, 120689, 120743, 120794, 120802, 120974, 121087, 121253, 121437, 121464, 121476, 121575, 121689, 121724, 121727, 121821, 121919, 121958, 122066, 122097, 122276, 122361, 123022, 123138, 123181, 123474, 123844, 123847, 123851, 123853, 123857, 124028, 124056, 124085, 124109, 124160, 124205, 124263, 124606, 124684, 124811, 124856, 124864, 124950, 125033, 125068, 125151, 125153, 125300, 125343, 125574, 125617, 125637, 125762, 126050, 126084, 126125, 126137, 126202, 126237, 126239, 126240, 126242, 126257, 126262, 126289, 126598, 126608, 126670, 126791, 126958, 127014, 127016, 127038, 127066, 127068, 127166, 127223, 127226, 127250, 127301, 127329, 127389, 127536, 127568, 127576, 127628, 127643, 127856, 127905, 127990, 128096, 128223, 128281, 128285, 128590, 128845, 129351, 129449, 129471, 129535, 129665, 129759, 129807, 129985, 130055, 130153, 130159, 130247, 130249, 130254, 130334, 130448, 130503, 130555, 130585, 130603, 130613, 130632, 130657, 130678, 130849, 132468, 132473, 132477, 134443, 134444, 134445, 134446, 134447, 134448, 135417, 135746, 135942, 135947, 136075, 136165, 136489, 136524, 136622, 136717, 136777, 136783, 136787, 136916, 137043, 137112, 137221, 137300, 137408, 137679, 137730, 137732, 137736, 137768, 137900, 138175, 138330, 138360, 138530, 138635, 138685, 138863, 138893, 138951, 139215, 139322, 139372, 139716, 139718, 139774, 139900, 139999, 140020, 140193, 140264, 140308, 140558, 140632, 140666, 140669, 140707, 140922, 140955, 140992, 141000, 141006, 141090, 141154, 141156, 141277, 141626, 141631, 141774, 141801, 141968, 142030, 142044, 142143, 142172, 142439, 142464, 142499, 142584, 142605, 142731, 142989, 143023, 143128, 143292, 143295, 143384, 144067, 144133, 144181, 144233, 144374, 144505, 144538, 144553, 144693, 144855, 144913, 145102, 145277, 145421, 145439, 145515, 145557, 145558, 145738, 145759, 145997, 146086, 146095, 146103, 146185, 146346, 146364, 146568, 146577, 146598, 146750, 146796, 146820, 146980, 147001, 147172, 147309, 147347, 147404, 147448, 147509, 147599, 147718, 147789, 147809, 147835, 147839, 147876, 147916, 148426, 148458, 148973, 149303, 149307, 149724, 149865, 149994, 149998, 150126, 150215, 150334, 150414, 150739, 150897, 150981, 151019, 151078, 151220, 151825, 151999, 152019, 152021, 152030, 152118, 152152, 152167, 152191, 152287, 152562, 152596, 152624, 152915, 152973, 153173, 153227, 153374, 153377, 153481, 153504, 153520, 153526, 153602, 153632, 153716, 153724, 153916, 153982, 154412, 154689, 154845, 154891, 154979, 155016, 156138, 156167, 156176, 156262, 156313, 156536, 156788, 156913, 157070, 157147, 157165, 157245, 157317, 157408, 157435, 157518, 157522, 157615, 157623, 157648, 157655, 157677, 157728, 157851, 157859, 158188, 158364, 158528, 158690, 158713, 158884, 159052, 159277, 159922, 159953, 160258, 160267, 160297, 160302, 160304, 160336, 160441, 160490, 160572, 160587, 160659, 160761, 160996, 161048, 161212, 161455, 161513, 161515, 161590, 161652, 161667, 161768, 162029, 162284, 162293, 162332, 162403, 162450, 162504, 162530, 162614, 162619, 162667, 162674, 162957, 162963, 163103, 163106, 163278, 163380, 163608, 164044, 164058, 164456, 164601, 164621, 164643, 164645, 164657, 164683, 164697, 164796, 164831, 164889, 164935, 165027, 165048, 165049, 165054, 165067, 165118, 165145, 165171, 165204, 165212, 165296, 165486, 165494, 165497, 165836, 166239, 166778, 166900, 167134, 167164, 167166, 167197, 167422, 167479, 167532, 167728, 167746, 167765, 167806, 167930, 167986, 168107, 168145, 168156, 168191, 168198, 168273, 168290, 168388, 168589, 168790, 168914, 169040, 169044, 169207, 169235, 169465, 169519, 169588, 169849, 169877, 170029, 170076, 170109, 170160, 170347, 170424, 170487, 170550, 170657, 170674, 170798, 170830, 170917, 170921, 170989, 171055, 171141, 171304, 171306, 171311, 171317, 171389, 171458, 171477, 171565, 171872, 171873, 171878, 171894, 171911, 171949, 172034, 172086, 172133, 172230, 172386, 172485, 172651, 172655, 172697, 173097, 173495, 173546, 173689, 173690, 173692, 173696, 173709, 173772, 173854, 173860, 173912, 173915, 173917, 173944, 174028, 174047, 174127, 174826, 174828, 174890, 175030, 175315, 175323, 175389, 175402, 175494, 175506, 175509, 175645, 175755, 175775, 176122, 176125, 176130, 176166, 176382, 176560, 177051, 177131, 177277, 177333, 177338, 177392, 177433, 177463, 177507, 177525, 177556, 177580, 178030, 178572, 178657, 178726, 178801, 178814, 179177, 179258, 179278, 179499, 179502, 179510, 179669, 179689, 179739, 179882, 180022, 180352, 180386, 180415, 180507, 180517, 180643, 180736, 180746, 181131, 181243, 181292, 181345, 181591, 181676, 181874, 181901, 181997, 182076, 182080, 182162, 182203, 182205, 182354, 182419, 182443, 182447, 182494, 182508, 182705, 182737, 182888, 182891, 183052, 183105, 183209, 183468, 183535, 183566, 183878, 183879, 183944, 183969, 184081, 184118, 184588, 184781, 184891, 184988, 185222, 185236, 185281, 185364, 185752, 185945, 186105, 186153, 186159, 186164, 186171, 186410, 186424, 186525, 186604, 186685, 186841, 186863, 187097, 187233, 187272, 187294, 187355, 187391, 187448, 187471, 187478, 187537, 187544, 187694, 187810, 187918, 187930, 188109, 188176, 188389, 188599, 188758, 189009, 189031, 189040, 189043, 189045, 189053, 189056, 189086, 189221, 189338, 189553, 189655, 189864, 189913, 190284, 190405, 190504, 190726, 190763, 190866, 191003)

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.85ms

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (8, 9, 12, 14, 15, 20, 21, 22, 23, 26, 27, 30, 31, 33, 34, 47, 56, 57, 89, 92, 93, 99, 100, 107, 110, 116, 128, 131, 132, 135, 137, 140, 147, 161, 162, 171, 175, 2008, 2009, 2016, 2022, 2033, 2042, 2068, 2070, 2079, 2120, 2173, 2195, 2209, 2222, 2223, 2240, 2249, 2257, 2288, 2307, 2321, 2326, 2336, 2341, 2342, 2343, 2346, 2353, 2366, 2403, 2418) 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.45ms

select `id`, `name`, `slug` from `programs` where `programs`.`id` in (10, 11, 12, 13, 3443, 3444, 3445, 3466, 3485, 3580, 4708, 4805, 4998, 5236, 6970, 6972, 6974, 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.32ms

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_new128ms

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: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.21msselect * 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\InstituteProgram: 1797InstituteProgram.php#?
App\Models\Institute: 1758Institute.php#?
App\Models\City: 1202City.php#?
App\Models\InstituteProgramExamMapping: 1178InstituteProgramExamMapping.php#?
App\Models\State: 74State.php#?
App\Models\Exam: 50Exam.php#?
App\Models\InstituteCourseSummary: 20InstituteCourseSummary.php#?
App\Models\InstituteImage: 20InstituteImage.php#?
App\Models\InstituteRank: 20InstituteRank.php#?
App\Models\InstituteRating: 19InstituteRating.php#?
App\Models\Program: 18Program.php#?
App\Models\Course: 3Course.php#?

_token: nxmckT8yGMKOpkPXaKN7Y2cdNes88sahoiT6lH0d
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/bpharm-colleges-india" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/bpharm-colleges-india

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 => "Tue, 08 Apr 2025 09:13:04 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBEYnhSYm1vVFRoaXVLVDdiMC9vcWc9PSIsInZhbHVlIjoiQlByanBFMkp4TVRyVjZxc2hUYjM3T2RpZWE5a1lVOEVNUHUrU2Z3NG44Zk1VZ1RaMVBEMk5CQ2xZVEtCTURpQkd2T05LZ1lZMFFXa3lnMW5HVWk2K1lpSnl2RUtBZVVvOVN1TzZ5dVlEV1dvL3JsMm1sbW9VUmttbGh1YUk0VE0iLCJtYWMiOiJhODBkZWNjMDIxMWY2N2NkYzE5Mzk4N2Y1NzcxNjYwODU1ODQwNTY1YWI1NGM2NzdhMWY2OWJlYjI4MzczMmMzIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 11:13:04 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InBEYnhSYm1vVFRoaXVLVDdiMC9vcWc9PSIsInZhbHVlIjoiQlByanBFMkp4TVRyVjZxc2hUYjM3T2RpZWE5a1lVOEVNUHUrU2Z3NG44Zk1VZ1RaMVBEMk5CQ2xZVEtCTURpQkd2T05LZ ▶"
    1 => "laravel_session=eyJpdiI6IkhVaUp2NEY1bmVyeTlTaGIxcGIvNGc9PSIsInZhbHVlIjoid3RQMGtMWWJsbGtsTWNzaFliNzQ4UzA1bVFYZXZkSjZlS0VEeFIwUGZGK21VNm10SU1hbVRCZWxXSzhQa1FtTk84anBLS0dpYm9SVExPenZtMEhxMXIwY3R2WWxnWTFXbkNDNE8yUGtabXBZaVVGcXdJcFU1bDdXNkRwY1hJYkgiLCJtYWMiOiI0MmE2N2UyYWQzYzNlZGE4Nzc0NGI0ZTM5OTE3ZjJjMGEzOTgwN2E4ZjkyYjYyMDczNDJhZTNkMTgxMDczZTVmIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 11:13:04 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkhVaUp2NEY1bmVyeTlTaGIxcGIvNGc9PSIsInZhbHVlIjoid3RQMGtMWWJsbGtsTWNzaFliNzQ4UzA1bVFYZXZkSjZlS0VEeFIwUGZGK21VNm10SU1hbVRCZWxXSzhQa1FtTk84 ▶"
    2 => "course_id=11; expires=Wed, 08 Apr 2026 09:13:04 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=B%20Pharmacy; expires=Wed, 08 Apr 2026 09:13:04 GMT; Max-Age=31536000; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBEYnhSYm1vVFRoaXVLVDdiMC9vcWc9PSIsInZhbHVlIjoiQlByanBFMkp4TVRyVjZxc2hUYjM3T2RpZWE5a1lVOEVNUHUrU2Z3NG44Zk1VZ1RaMVBEMk5CQ2xZVEtCTURpQkd2T05LZ1lZMFFXa3lnMW5HVWk2K1lpSnl2RUtBZVVvOVN1TzZ5dVlEV1dvL3JsMm1sbW9VUmttbGh1YUk0VE0iLCJtYWMiOiJhODBkZWNjMDIxMWY2N2NkYzE5Mzk4N2Y1NzcxNjYwODU1ODQwNTY1YWI1NGM2NzdhMWY2OWJlYjI4MzczMmMzIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 11:13:04 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InBEYnhSYm1vVFRoaXVLVDdiMC9vcWc9PSIsInZhbHVlIjoiQlByanBFMkp4TVRyVjZxc2hUYjM3T2RpZWE5a1lVOEVNUHUrU2Z3NG44Zk1VZ1RaMVBEMk5CQ2xZVEtCTURpQkd2T05LZ ▶"
    1 => "laravel_session=eyJpdiI6IkhVaUp2NEY1bmVyeTlTaGIxcGIvNGc9PSIsInZhbHVlIjoid3RQMGtMWWJsbGtsTWNzaFliNzQ4UzA1bVFYZXZkSjZlS0VEeFIwUGZGK21VNm10SU1hbVRCZWxXSzhQa1FtTk84anBLS0dpYm9SVExPenZtMEhxMXIwY3R2WWxnWTFXbkNDNE8yUGtabXBZaVVGcXdJcFU1bDdXNkRwY1hJYkgiLCJtYWMiOiI0MmE2N2UyYWQzYzNlZGE4Nzc0NGI0ZTM5OTE3ZjJjMGEzOTgwN2E4ZjkyYjYyMDczNDJhZTNkMTgxMDczZTVmIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 11:13:04 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IkhVaUp2NEY1bmVyeTlTaGIxcGIvNGc9PSIsInZhbHVlIjoid3RQMGtMWWJsbGtsTWNzaFliNzQ4UzA1bVFYZXZkSjZlS0VEeFIwUGZGK21VNm10SU1hbVRCZWxXSzhQa1FtTk84 ▶"
    2 => "course_id=11; expires=Wed, 08-Apr-2026 09:13:04 GMT; path=/"
    3 => "course_name=B+Pharmacy; expires=Wed, 08-Apr-2026 09:13:04 GMT; path=/"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 09:13:04	GET	/bpharm-colleges-india	1 11 30 6159

1 x Application (98.23%)	622ms
1 x Booting (1.77%)	11.21ms