Top M Pharm Colleges in India 2025 : Fees, Rankings, Placements, Admissions

Showing 1110 colleges for you

Clear All Filters

Jamia Hamdard University 3.5 (21)

Delhi, Delhi NCR #1/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 4,53,500

Exams Accepted

Highest Package

View College

National Institute of Pharmaceutical Educational and Research (NIPER) 4.9 (7)

Mohali, Punjab #2/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

Exams Accepted

12th Board

Highest Package

₹ 9 LPA

View College

Birla Institute of Technology and Science - BITS 3.9 (15)

Pilani, Rajasthan #3/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 10,00,000

Exams Accepted

GATE

Highest Package

View College

JSS College of Pharmacy -Tamilnadu 4 (4)

Ooty, Tamil Nadu #4/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 4,00,000

Exams Accepted

Highest Package

View College

Institute of Chemical Technology (ICT) 3.4 (2)

Mumbai, Maharashtra #5/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,02,000

Exams Accepted

JEE Main

Highest Package

₹ 12 LPA

View College

Panjab University 4.5 (22)

Chandigarh, Punjab #7/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 64,500

Exams Accepted

Highest Package

View College

Manipal University - Manipal Academy of Higher Education 4.3 (47)

Manipal, Karnataka #8/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 7,40,000

Exams Accepted

Highest Package

View College

Narsee Monjee Institute of Management Studies (NMIMS) 4.1 (26)

Mumbai, Maharashtra #10/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 10,00,000

Exams Accepted

CAT

Highest Package

₹ 22 LPA

View College

Amrita Vishwa Vidyapeetham University 4.2 (9)

Coimbatore, Tamil Nadu #13/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,30,000

Exams Accepted

Highest Package

View College

Delhi Institute Pharmaceutical Science & Research (DIPSR) 3.8 (4)

Delhi, Delhi NCR #16/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,57,000

Exams Accepted

Highest Package

View College

Lovely Professional University 4.1 (586)

Jalandhar, Punjab #16/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 4,53,500

Exams Accepted

TNEA

Highest Package

₹ 9 LPA

View College

Jadavpur University 4.5 (7)

Kolkata, West Bengal #18/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

Exams Accepted

CAT

Highest Package

View College

Chitkara University 4.1 (29)

Chandigarh, Punjab #19/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,97,500

Exams Accepted

UPSEE

Highest Package

View College

Chandigarh University (CU) 4.3 (327)

Chandigarh, Punjab #20/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 3,86,500

Exams Accepted

Highest Package

₹ 10 LPA

View College

Babasaheb Bhimrao Ambedkar University 2.5 (2)

Lucknow, Uttar Pradesh #21/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 40,000

Exams Accepted

Highest Package

View College

Amity University-Noida 4 (118)

Noida, Uttar Pradesh #22/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 6,41,000

Exams Accepted

Highest Package

View College

Maharishi Markandeshwar University - MMU 3.8 (22)

Ambala, Haryana #26/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,40,000

Exams Accepted

Highest Package

View College

Banasthali Vidyapith 4.5 (32)

Jaipur, Rajasthan #28/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 2,34,500

Exams Accepted

Highest Package

View College

Central university of Rajasthan

Ajmer, Rajasthan #29/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

Exams Accepted

CLAT

Highest Package

₹ 8 LPA

View College

Shoolini University 3.5 (10)

Solan, Himachal Pradesh #30/100 (NIRF 2024)

Course Offered

M.Pharm

Fees (2 Years)

₹ 4,50,000

Exams Accepted

Highest Package

View College

Messages1 Timeline Exceptions Views11 Route Queries30 Models3867 Mails Gate Session Request

Request history8.3.19557ms10MBGET {course}-colleges-india

warninglog[06:08:15] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...

Booting (12.11ms)time
Application (544ms)time
1 x Application (97.82%)
544ms
1 x Booting (2.18%)
12.11ms

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 executed402ms

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_new7.1msselect * from `seo_redirects` where `redirect_from` = '/mpharm-colleges-india' limit 1

Bindings	0: /mpharm-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_new790μs

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

Bindings	0: mpharm-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.2msselect `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.12ms

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

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

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_new570μs

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

Bindings	0: mpharm 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_new16.89ms

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

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

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

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 (14)) 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, 1872, 1888, 2405, 2742, 3840, 3902, 3903, 4123, 7723, 11585, 11798, 13311, 14890, 17271, 17434, 19205) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 14 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_new3.16ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (248, 296, 493, 1047, 1872, 1888, 2405, 2742, 3840, 3902, 3903, 4123, 7723, 11585, 11798, 13311, 14890, 17271, 17434, 19205) and `course_id` in (14) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 14
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_new1ms

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

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (10, 39, 57, 64, 72, 80, 103, 105, 109, 148, 150, 154, 157, 196, 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_new980μs

select `id`, `name`, `shortname` from `states` where `states`.`id` in (72, 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_new1.39ms

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (248, 296, 493, 1047, 1872, 1888, 2405, 2742, 3840, 3902, 3903, 4123, 7723, 11585, 11798, 13311, 14890, 17271, 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_new3.66ms

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, 1872, 1888, 2405, 2742, 3840, 3902, 3903, 4123, 7723, 11585, 11798, 13311, 14890, 17271, 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_new720μs

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

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (7176, 10271, 11244, 11583, 12129, 13546, 22224, 22780, 30007, 33140, 34781, 40548, 48982, 49048, 54247, 54250, 75014, 78094, 78318, 80191)

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

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (14, 21, 116, 128, 132, 161, 2008, 2009, 2240) 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_new3.07ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (248, 296, 493, 1047, 1872, 1888, 2405, 2742, 3840, 3902, 3903, 4123, 7723, 11585, 11798, 13311, 14890, 17271, 17434, 19205) and `ranking_body` = 'nirf' and `course_id` in (14) 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: 1872 5: 1888 6: 2405 7: 2742 8: 3840 9: 3902 10: 3903 11: 4123 12: 7723 13: 11585 14: 11798 15: 13311 16: 14890 17: 17271 18: 17434 19: 19205 20: nirf 21: 14 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_new14.88ms

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

Bindings	0: active 1: 14
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_new8.06ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (49, 63, 125, 161, 172, 177, 224, 241, 246, 248, 290, 296, 451, 464, 493, 557, 559, 653, 934, 948, 952, 956, 957, 965, 970, 972, 973, 976, 980, 983, 1000, 1047, 1057, 1066, 1161, 1307, 1358, 1457, 1577, 1586, 1802, 1872, 1873, 1876, 1877, 1888, 1919, 1920, 1941, 2105, 2128, 2167, 2221, 2231, 2259, 2272, 2294, 2304, 2313, 2327, 2328, 2365, 2394, 2398, 2399, 2405, 2416, 2418, 2420, 2421, 2424, 2428, 2432, 2443, 2446, 2447, 2449, 2450, 2451, 2452, 2454, 2456, 2461, 2462, 2463, 2465, 2466, 2469, 2471, 2472, 2476, 2494, 2506, 2508, 2513, 2516, 2526, 2535, 2538, 2540, 2541, 2543, 2545, 2548, 2551, 2552, 2555, 2558, 2559, 2560, 2561, 2569, 2573, 2579, 2583, 2585, 2587, 2600, 2602, 2603, 2604, 2605, 2606, 2607, 2608, 2609, 2642, 2654, 2655, 2656, 2657, 2664, 2668, 2669, 2672, 2675, 2681, 2694, 2695, 2700, 2707, 2709, 2710, 2711, 2717, 2725, 2728, 2729, 2730, 2742, 2745, 2746, 2753, 2754, 2757, 2763, 2765, 2779, 2783, 2785, 2791, 2795, 2814, 2815, 2818, 2820, 2822, 2835, 2839, 2852, 2853, 2981, 3126, 3166, 3215, 3663, 3736, 3737, 3738, 3840, 3879, 3881, 3883, 3885, 3886, 3887, 3888, 3889, 3890, 3891, 3892, 3893, 3894, 3895, 3896, 3897, 3899, 3901, 3902, 3903, 3904, 3906, 3907, 3908, 3910, 3911, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3923, 3924, 3926, 3928, 3929, 3930, 3932, 3933, 3934, 3935, 3936, 3937, 3938, 3940, 3941, 3942, 3943, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3952, 3953, 3954, 3955, 3958, 3959, 3960, 3962, 3964, 3965, 3966, 3967, 3968, 3970, 3971, 3972, 3973, 3974, 3975, 3976, 3977, 3978, 3979, 3980, 3981, 3982, 3984, 3985, 3989, 3991, 3992, 3994, 3995, 3996, 3997, 3999, 4001, 4007, 4008, 4009, 4010, 4013, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4023, 4024, 4025, 4026, 4027, 4029, 4030, 4031, 4033, 4034, 4035, 4037, 4038, 4039, 4040, 4044, 4046, 4049, 4055, 4058, 4059, 4060, 4061, 4062, 4064, 4065, 4066, 4067, 4068, 4069, 4070, 4071, 4073, 4075, 4077, 4078, 4081, 4082, 4083, 4084, 4085, 4086, 4087, 4088, 4089, 4090, 4091, 4092, 4094, 4095, 4096, 4098, 4100, 4101, 4104, 4107, 4108, 4109, 4110, 4112, 4113, 4114, 4115, 4119, 4121, 4122, 4123, 4125, 4126, 4127, 4128, 4129, 4131, 4134, 4135, 4136, 4139, 4140, 4141, 4142, 4145, 4146, 4149, 4151, 4153, 4154, 4155, 4156, 4158, 4159, 4162, 4163, 4164, 4166, 4168, 4393, 4691, 5011, 5089, 5140, 5199, 5294, 5397, 5404, 5471, 5755, 6144, 6145, 6614, 7123, 7202, 7413, 7417, 7418, 7460, 7476, 7597, 7632, 7638, 7645, 7659, 7665, 7666, 7723, 7730, 7760, 7801, 8083, 8121, 8311, 8566, 8605, 8670, 8782, 8796, 8877, 8981, 8987, 8994, 9004, 9006, 9009, 9028, 9033, 9037, 9038, 9046, 9052, 9054, 9056, 9057, 9058, 9060, 9062, 9064, 9065, 9066, 9069, 9073, 9074, 9078, 9080, 9155, 9173, 9189, 9224, 9252, 9254, 9363, 9383, 9406, 9412, 9420, 9433, 9454, 9470, 9474, 9481, 9490, 9496, 9501, 9512, 9521, 9522, 9523, 9524, 9525, 9526, 9528, 9529, 9548, 9552, 9554, 9558, 9566, 9567, 9569, 9598, 9599, 9604, 9609, 9613, 9615, 9626, 9627, 9652, 9655, 9664, 9667, 9670, 9676, 9679, 9681, 9682, 9683, 9685, 9686, 9688, 9689, 9691, 9694, 9704, 9706, 9710, 9712, 9717, 9740, 9834, 9835, 9836, 9837, 9839, 9841, 9843, 9866, 9882, 9885, 9907, 9913, 9955, 9959, 10042, 10057, 10070, 10076, 10077, 10083, 10087, 10112, 10119, 10127, 10131, 10135, 10136, 10139, 10151, 10152, 10153, 10164, 10169, 10175, 10178, 10179, 10183, 10189, 10193, 10205, 10207, 10221, 10235, 10242, 10244, 10247, 10256, 10302, 10430, 10439, 10444, 10534, 11059, 11143, 11284, 11360, 11386, 11391, 11412, 11428, 11437, 11443, 11447, 11455, 11570, 11580, 11585, 11596, 11631, 11717, 11718, 11735, 11749, 11780, 11784, 11797, 11798, 11805, 11810, 11822, 11996, 11998, 12001, 12008, 12010, 12012, 12037, 12038, 12039, 12041, 12046, 12047, 12054, 12060, 12078, 12090, 12108, 12113, 12139, 12143, 12145, 12147, 12148, 12158, 12160, 12177, 12183, 12185, 12187, 12189, 12192, 12204, 12537, 12628, 13004, 13126, 13166, 13167, 13214, 13249, 13304, 13311, 13341, 13407, 13432, 13462, 13481, 13628, 13649, 13658, 13684, 13685, 13691, 13702, 13771, 13787, 13903, 13932, 13965, 13983, 14241, 14250, 14253, 14290, 14299, 14303, 14316, 14388, 14573, 14588, 14600, 14607, 14609, 14616, 14680, 14793, 14848, 14886, 14890, 14910, 14930, 14933, 14966, 14971, 14985, 15052, 15053, 15055, 15239, 15275, 15967, 16087, 16232, 16245, 16908, 17158, 17163, 17197, 17236, 17271, 17273, 17284, 17285, 17290, 17294, 17426, 17434, 17437, 17743, 17789, 17806, 17827, 17978, 17980, 18091, 18156, 18268, 18302, 18313, 18391, 18437, 18462, 18635, 18687, 18710, 18742, 18773, 18779, 18847, 18879, 18895, 18978, 19002, 19025, 19097, 19121, 19145, 19166, 19205, 19275, 19370, 19528, 19575, 19584, 19616, 20341, 20431, 20487, 20488, 20518, 20555, 29800, 29883, 30102, 30321, 30599, 31034, 31986, 32040, 32095, 32168, 33893, 33896, 33899, 33901, 33912, 33916, 33919, 33920, 33936, 34189, 34492, 34541, 34578, 34587, 35163, 36393, 36395, 36396, 36397, 36399, 36400, 36401, 36418, 36425, 36428, 36441, 36444, 36455, 36461, 36527, 36550, 36605, 36633, 36642, 36666, 36673, 36680, 36717, 36736, 36749, 36751, 36763, 36895, 36954, 37127, 37156, 37158, 37231, 37316, 37446, 37456, 37457, 37497, 37598, 37767, 37829, 37876, 38044, 38053, 38058, 38184, 38212, 38213, 38250, 38284, 38397, 38450, 38461, 38613, 38661, 38742, 38743, 38776, 38786, 38806, 38852, 38996, 39006, 39197, 39200, 39201, 39202, 39263, 39295, 39327, 39364, 39406, 39447, 39497, 39628, 39731, 39752, 39829, 39886, 40004, 40015, 40016, 40026, 40050, 40110, 40121, 40175, 40416, 40510, 40519, 40542, 40543, 40597, 40605, 40608, 40609, 40615, 40944, 41120, 41168, 41351, 41487, 41628, 41653, 41868, 41881, 41882, 41897, 41960, 41985, 41986, 42060, 42192, 42232, 42235, 42239, 42270, 42302, 42305, 42415, 42496, 42516, 42537, 42558, 42627, 42629, 42647, 42702, 42721, 42727, 42778, 42849, 42852, 42939, 42978, 43146, 43153, 43306, 43411, 43457, 43464, 43523, 43622, 43685, 43739, 43796, 43846, 43937, 43958, 44013, 44091, 44106, 44374, 44385, 44406, 44417, 44447, 44458, 44473, 44600, 44618, 44629, 44634, 44893, 44912, 44916, 44925, 45139, 45191, 45232, 45235, 45275, 45304, 45473, 45516, 45528, 45538, 45698, 45710, 45791, 45844, 45876, 45879, 45961, 46006, 46092, 46242, 46301, 46406, 46474, 46477, 46493, 46526, 46537, 46544, 46547, 46601, 46684, 46752, 46779, 46960, 47045, 47046, 47135, 47367, 47412, 47425, 47449, 47481, 47534, 47593, 47664, 47707, 47784, 47872, 47966, 48017, 48029, 48060, 48065, 48215, 48226, 48253, 48260, 48267, 48285, 48317, 48318, 48370, 48557, 48664, 48695, 48714, 48725, 48757, 48774, 48790, 48842, 48902, 49026, 49053, 49074, 49109, 49253, 49337, 49419, 49662, 49712, 49747, 49765, 49770, 49826, 49968, 49981, 50109, 50110, 50169, 50191, 50194, 50304, 50337, 50358, 50617, 50621, 50806, 50827, 50852, 50872, 50969, 51021, 51022, 51024, 51058, 51072, 51085, 51121, 51151, 51228, 51237, 51301, 51316, 51356, 51358, 51366, 51393, 51483, 51510, 51521, 51537, 51555, 51622, 51634, 51708, 51733, 51765, 51774, 51799, 51802, 51890, 51930, 51943, 51948, 51999, 52052, 52134, 52275, 52344, 52363, 52364, 52365, 52371, 52373, 52394, 52429, 52436, 52440, 52468, 52515, 52628, 52630, 52641, 52656, 52675, 52676, 52692, 52727, 52776, 52786, 52819, 52848, 53005, 53025, 53087, 53089, 53130, 53137, 53142, 53146, 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_new105ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (2, 3, 5, 6, 7, 10, 12, 13, 15, 16, 19, 20, 22, 24, 25, 26, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 43, 44, 45, 47, 48, 50, 51, 52, 53, 55, 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, 93, 94, 95, 96, 97, 99, 102, 103, 104, 105, 106, 107, 108, 109, 110, 112, 114, 117, 118, 119, 122, 123, 125, 127, 128, 129, 131, 132, 137, 138, 140, 141, 143, 147, 148, 150, 152, 153, 154, 155, 156, 157, 158, 159, 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, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 219, 220, 221, 222, 224, 225, 227, 228, 229, 231, 233, 237, 240, 242, 244, 246, 248, 251, 254, 260, 261, 263, 265, 277, 281, 282, 285, 292, 295, 297, 299, 302, 304, 305, 312, 313, 319, 321, 324, 325, 326, 332, 342, 353, 357, 368, 375, 385, 393, 433, 435, 438, 442, 444, 451, 462, 463, 469, 472, 476, 478, 480, 482, 490, 491, 493, 497, 502, 508, 523, 558, 560, 568, 576, 587, 591, 607, 608, 610, 615, 616, 617, 640, 683, 689, 702, 704, 707, 710, 719, 734, 833, 834, 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_new2.17ms

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_new6.18ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (6899, 6904, 6906, 6908, 6931, 6947, 7013, 7018, 7029, 7039, 7042, 7046, 7053, 7058, 7064, 7104, 7109, 7115, 7119, 7143, 7148, 7163, 7167, 7171, 7176, 7194, 7205, 7210, 7377, 7380, 7388, 7393, 7397, 9353, 9361, 10271, 10313, 10598, 10618, 10704, 10771, 10922, 10974, 11085, 11100, 11244, 11583, 11593, 11911, 12025, 12096, 12129, 12137, 12217, 12263, 12267, 12340, 12341, 12350, 12402, 12410, 12568, 12684, 13217, 13418, 13425, 13546, 14683, 14694, 14711, 14725, 15649, 15666, 15702, 15706, 15827, 15856, 16106, 16236, 16795, 16859, 16934, 16949, 18443, 19447, 19498, 19622, 19648, 19650, 19657, 19659, 19824, 19891, 20499, 20748, 21727, 22224, 22289, 22519, 22780, 23031, 23358, 23513, 23675, 23714, 24090, 24589, 24730, 24734, 24812, 25059, 25750, 25947, 25982, 26152, 26244, 27542, 27554, 27753, 28030, 28588, 28647, 28659, 28718, 28818, 28966, 29141, 29313, 29500, 29530, 29598, 30007, 30318, 31128, 31619, 32717, 32824, 33014, 33090, 33140, 33508, 33842, 34759, 34781, 36172, 36333, 36847, 36971, 38025, 38282, 38522, 38647, 38880, 39082, 39577, 39780, 40027, 40426, 40548, 40591, 40756, 40787, 41072, 41194, 41974, 43045, 43664, 43866, 44153, 44266, 44440, 44828, 45172, 45189, 45302, 45497, 45524, 45546, 45976, 46393, 47020, 47113, 47122, 47137, 47158, 47188, 47361, 47426, 47702, 47833, 48052, 48359, 48982, 48989, 49008, 49024, 49048, 49139, 49145, 49219, 49578, 49725, 49838, 49945, 50128, 50153, 50773, 51128, 51273, 51284, 51732, 52065, 52267, 53765, 54219, 54222, 54235, 54239, 54247, 54250, 54275, 54281, 54285, 54289, 54294, 54301, 54304, 54319, 54326, 54331, 54341, 54344, 54346, 54350, 54359, 54362, 54367, 54370, 54374, 54379, 54384, 54389, 54398, 54402, 54405, 54418, 54432, 54436, 54440, 54444, 54448, 54455, 54458, 54462, 54472, 54480, 54488, 54508, 54515, 54522, 54526, 54529, 54532, 54534, 54536, 54539, 54541, 54544, 54548, 54566, 54580, 54597, 54603, 54609, 54612, 54622, 54631, 54637, 54640, 54646, 54648, 54653, 54656, 54665, 54670, 54674, 54678, 54683, 54689, 54714, 54717, 54721, 54726, 54731, 54739, 54753, 54760, 54788, 54790, 54796, 54801, 56334, 56494, 56713, 56805, 57325, 57970, 58695, 58738, 58935, 59087, 59471, 59883, 60643, 60843, 60879, 61190, 61218, 61236, 61246, 61275, 61308, 61326, 61332, 61338, 61344, 61346, 61352, 61359, 61371, 61375, 61379, 61613, 61706, 61998, 62064, 62160, 62196, 62322, 62394, 62403, 62413, 62440, 62447, 62479, 62522, 62533, 62535, 62538, 62574, 62632, 62811, 62813, 62817, 62825, 62831, 62847, 62864, 62872, 62875, 63059, 63142, 63222, 63232, 63305, 63309, 63423, 63437, 63488, 63491, 63516, 63554, 63559, 63587, 63589, 63594, 63614, 63659, 63677, 63685, 63700, 63960, 63973, 66026, 66887, 66931, 67431, 67551, 67656, 67921, 67973, 68021, 68172, 68395, 68450, 68773, 68813, 68852, 68856, 68889, 69051, 69101, 69160, 71020, 71210, 71380, 71636, 71801, 71838, 72384, 73349, 73396, 73779, 73874, 73970, 74086, 74469, 74514, 74538, 74556, 74844, 74922, 75014, 75076, 75216, 75294, 75312, 75690, 77238, 77260, 77598, 77726, 77737, 77910, 77995, 78094, 78096, 78139, 78151, 78165, 78182, 78282, 78318, 78566, 78613, 78674, 78782, 78784, 78965, 79081, 79690, 79794, 79816, 79914, 80158, 80191, 81286, 81388, 81712, 81788, 81890, 82340, 82394, 82438, 82593, 82908, 82911, 82913, 82918, 82924, 82932, 82939, 83104, 83260, 83354, 83385, 85084, 86098, 86406, 87113, 87597, 87618, 87642, 87662, 87695, 87720, 87748, 87774, 87836, 87871, 87890, 87912, 87943, 87973, 87991, 88016, 88045, 88074, 88115, 88144, 88162, 88182, 88204, 88224, 88243, 88265, 88297, 88310, 88328, 88383, 88399, 88428, 88442, 88467, 88489, 88509, 88538, 88561, 88589, 88626, 88642, 88656, 88686, 88716, 88747, 88768, 88801, 88826, 88871, 88917, 88936, 88964, 88980, 89003, 89037, 89064, 89127, 89142, 89157, 89196, 89228, 89258, 89290, 89317, 89340, 89360, 89519, 89533, 89561, 89606, 89632, 89687, 89727, 89787, 89807, 89848, 89873, 89903, 89960, 89988, 90047, 90068, 90090, 90100, 90122, 90138, 90165, 90195, 90209, 90224, 90245, 90259, 90272, 90307, 90371, 90414, 91135, 93104, 93214, 93285, 93593, 93597, 93602, 93606, 93614, 93620, 93623, 93641, 93645, 93657, 93662, 93671, 93685, 93691, 93695, 93699, 93703, 93709, 93716, 93726, 93731, 93735, 93740, 93747, 93750, 93759, 93767, 93771, 93775, 93778, 93781, 93786, 93793, 93796, 93802, 93815, 93818, 93843, 93847, 93855, 93859, 93865, 93869, 93878, 93884, 93891, 93894, 93900, 93904, 93912, 93924, 93929, 93933, 93937, 93951, 93974, 93980, 93987, 93999, 94004, 94007, 94012, 94023, 94029, 94033, 94040, 94044, 94047, 94052, 94063, 94072, 94079, 95275, 96036, 96093, 96105, 96397, 96427, 97277, 98136, 98140, 98160, 98188, 98201, 98259, 98354, 98374, 98481, 98503, 98514, 98522, 98528, 98543, 98556, 98563, 98572, 98575, 98582, 98588, 98591, 98609, 98643, 98646, 98650, 98654, 98658, 98662, 98665, 98674, 98679, 98734, 98739, 98742, 98746, 98751, 98772, 98826, 98830, 98834, 98864, 98870, 98881, 98887, 98896, 98924, 98934, 98940, 98964, 98982, 98988, 99070, 99281, 99453, 100045, 100076, 100086, 100096, 100103, 100106, 100110, 100411, 100431, 100438, 100451, 100458, 100464, 100468, 100510, 100517, 100531, 100563, 100573, 100578, 100594, 101383, 101684, 101812, 101822, 102239, 102288, 102515, 103473, 104832, 105050, 105318, 105427, 105454, 106131, 106237, 106399, 106536, 106702, 106820, 106867, 107004, 107068, 107135, 107293, 107511, 107903, 108008, 108028, 108062, 108949, 109742, 109753, 110286, 110353, 110431, 110999, 111092, 111791, 111910, 112099, 112224, 112281, 112416, 112445, 112461, 112644, 112660, 112695, 112705, 112761, 112870, 113514, 113531, 113785, 114632, 114780, 114806, 115027, 115242, 115680, 116174, 116213, 116219, 116431, 117768, 118549, 118574, 118601, 118849, 119200, 119356, 119361, 119538, 119745, 120243, 120385, 120695, 120745, 121256, 121465, 121725, 121728, 121922, 121959, 122069, 122098, 122279, 123141, 123850, 123855, 123858, 124089, 124207, 124264, 124608, 124814, 124859, 125037, 125618, 126127, 126259, 126610, 127018, 127040, 127070, 127537, 127570, 127579, 127644, 127868, 128100, 128286, 129472, 130058, 130155, 130250, 130256, 130336, 130586, 130605, 130617, 130658, 130850, 132470, 132475, 132479, 134450, 135419, 135944, 136167, 136624, 136718, 136918, 137681, 137731, 137734, 137771, 138185, 138331, 138364, 138866, 139721, 139776, 139780, 140003, 140266, 140709, 141008, 141093, 141158, 141278, 141628, 141632, 141776, 142047, 142050, 142146, 142174, 142441, 142501, 142585, 143130, 143294, 144135, 144183, 144540, 144915, 145518, 145740, 145762, 146098, 146571, 146578, 146600, 146798, 146982, 147349, 147449, 147720, 147791, 147838, 147918, 148427, 149727, 149867, 149996, 150000, 150128, 150217, 150740, 150899, 150984, 151022, 152032, 152159, 152168, 152193, 152928, 153229, 153379, 153505, 153529, 153718, 153725, 153918, 154413, 154691, 154893, 154982, 155019, 155330, 156139, 156177, 156790, 157071, 157256, 157617, 157861, 158191, 158885, 159280, 159955, 160260, 160307, 160338, 160443, 160492, 160574, 160589, 160773, 161213, 161459, 161770, 162508, 162959, 162965, 163105, 163381, 164458, 164605, 164686, 164797, 164936, 165028, 165206, 165490, 165838, 166903, 167168, 167199, 167932, 167988, 168108, 168158, 168192, 168200, 168293, 168395, 168591, 169237, 169466, 169850, 170111, 170161, 170350, 170427, 170489, 170919, 171143, 171318, 171392, 171459, 171570, 171880, 171950, 172088, 172388, 172486, 172654, 173548, 173694, 173710, 173855, 173862, 173950, 174129, 174830, 175317, 175326, 175647, 175757, 175777, 176128, 176170, 176383, 176571, 177053, 177558, 177583, 178575, 178658, 178727, 178817, 179279, 179501, 179503, 179511, 179670, 179691, 179740, 179883, 180026, 180389, 180417, 180644, 180738, 181247, 181293, 181348, 181592, 181876, 182000, 182078, 182084, 182165, 182206, 182445, 182449, 182509, 182738, 182890, 183053, 183106, 183213, 183570, 183881, 183946, 183970, 184589, 184782, 184990, 185506, 186156, 186161, 186167, 186172, 186180, 186263, 186413, 186425, 186468, 186607, 186702, 186864, 187274, 187296, 187356, 187394, 187474, 187480, 187550, 187698, 187811, 187933, 188111, 188178, 188390, 189011, 189058, 189611, 189678, 190333, 190517, 190631, 190736, 191028)

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

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (9, 11, 12, 14, 15, 21, 22, 23, 24, 25, 26, 27, 30, 34, 35, 36, 56, 57, 91, 93, 97, 105, 106, 116, 128, 131, 132, 137, 140, 153, 161, 162, 171, 174, 184, 2008, 2009, 2036, 2042, 2048, 2070, 2148, 2198, 2223, 2226, 2240, 2250, 2326, 2342, 2353, 2403, 2422) 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.84ms

select `id`, `name`, `slug` from `programs` where `programs`.`id` in (1482, 1483, 1484, 1485, 1486, 1487, 1488, 1491, 1492, 1493, 1494, 1497, 1501, 1504, 1508, 3469, 3572, 3582, 3663, 3755, 4619, 4830, 5226, 5481, 8889, 9367, 9368, 9370, 9373, 9374, 9376, 9377, 9378, 9379, 9380, 9381, 9385, 9386, 9387, 9388, 9390, 9391, 9392, 9394, 9395, 9396, 9397, 9398, 9399) 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.31ms

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.57msselect * 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: 1130InstituteProgram.php#?
App\Models\Institute: 1120Institute.php#?
App\Models\City: 1119City.php#?
App\Models\InstituteProgramExamMapping: 249InstituteProgramExamMapping.php#?
App\Models\State: 73State.php#?
App\Models\Program: 49Program.php#?
App\Models\Exam: 46Exam.php#?
App\Models\InstituteCourseSummary: 20InstituteCourseSummary.php#?
App\Models\InstituteRank: 20InstituteRank.php#?
App\Models\InstituteRating: 19InstituteRating.php#?
App\Models\InstituteImage: 19InstituteImage.php#?
App\Models\Course: 3Course.php#?

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

path_info

/mpharm-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 => "Mon, 07 Apr 2025 06:08:16 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJmWVVHbXh3NFZOdzVmQzNDWGd0Ymc9PSIsInZhbHVlIjoiVkpKa0xZWHdkRmxoNWd6RjZtRCtJMVRac0Y3dS90WlU1Y3dPV095UTJ2cFhYN2QySDNOZmRtQ2Nub0tWQno0bHNoTUtXdk53UXFObEVmQVp2dDdwcWJaVityV0UrUWU2Mk1PUGgyYUlzOXFydnpLRWZPOGZuc2ZUWGt2NW9rNkwiLCJtYWMiOiI0N2UyNGM5ZGIwZDNiYzNhMWUxN2QzYTIyNDQwOGIwYzU1MjM4YTQ2OWIxYmJiOWM1NDMzMTY0ZWRkYTU5OTUwIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 08:08:16 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJmWVVHbXh3NFZOdzVmQzNDWGd0Ymc9PSIsInZhbHVlIjoiVkpKa0xZWHdkRmxoNWd6RjZtRCtJMVRac0Y3dS90WlU1Y3dPV095UTJ2cFhYN2QySDNOZmRtQ2Nub0tWQno0bHNoTUtXd ▶"
    1 => "laravel_session=eyJpdiI6ImtLTHVhbU51ckxsQjQ1ZmhDamVHK1E9PSIsInZhbHVlIjoiemdDaUxTT3RTKzB0WUgyZlVCSVJsZ0hvcmQ3dnFiZHlqZEN3QlNONXQrTGxCWEpVRUFxY3d0SDVwbmRVZlF5Sk5rNWs1ZDZxQlhjZ1RlZTRrTzBYRzdzYkJKZVdkSGNXSE8xMElUWTUzRjJTOW9vNUpiTWoxY0Z0eGlXY05hWkciLCJtYWMiOiI3ZmRkNjA0NmY1N2I5NTVhNzA2OTBkMjVkNGM5ZjM4Y2U2ZGEyMzg4OTllMDQ2YTFiY2FjNDQ5MDY5M2NlNTE4IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 08:08:16 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImtLTHVhbU51ckxsQjQ1ZmhDamVHK1E9PSIsInZhbHVlIjoiemdDaUxTT3RTKzB0WUgyZlVCSVJsZ0hvcmQ3dnFiZHlqZEN3QlNONXQrTGxCWEpVRUFxY3d0SDVwbmRVZlF5Sk5r ▶"
    2 => "course_id=14; expires=Tue, 07 Apr 2026 06:08:15 GMT; Max-Age=31535999; path=/; samesite=lax"
    3 => "course_name=M%20Pharm; expires=Tue, 07 Apr 2026 06:08:15 GMT; Max-Age=31535999; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJmWVVHbXh3NFZOdzVmQzNDWGd0Ymc9PSIsInZhbHVlIjoiVkpKa0xZWHdkRmxoNWd6RjZtRCtJMVRac0Y3dS90WlU1Y3dPV095UTJ2cFhYN2QySDNOZmRtQ2Nub0tWQno0bHNoTUtXdk53UXFObEVmQVp2dDdwcWJaVityV0UrUWU2Mk1PUGgyYUlzOXFydnpLRWZPOGZuc2ZUWGt2NW9rNkwiLCJtYWMiOiI0N2UyNGM5ZGIwZDNiYzNhMWUxN2QzYTIyNDQwOGIwYzU1MjM4YTQ2OWIxYmJiOWM1NDMzMTY0ZWRkYTU5OTUwIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 08:08:16 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InJmWVVHbXh3NFZOdzVmQzNDWGd0Ymc9PSIsInZhbHVlIjoiVkpKa0xZWHdkRmxoNWd6RjZtRCtJMVRac0Y3dS90WlU1Y3dPV095UTJ2cFhYN2QySDNOZmRtQ2Nub0tWQno0bHNoTUtXd ▶"
    1 => "laravel_session=eyJpdiI6ImtLTHVhbU51ckxsQjQ1ZmhDamVHK1E9PSIsInZhbHVlIjoiemdDaUxTT3RTKzB0WUgyZlVCSVJsZ0hvcmQ3dnFiZHlqZEN3QlNONXQrTGxCWEpVRUFxY3d0SDVwbmRVZlF5Sk5rNWs1ZDZxQlhjZ1RlZTRrTzBYRzdzYkJKZVdkSGNXSE8xMElUWTUzRjJTOW9vNUpiTWoxY0Z0eGlXY05hWkciLCJtYWMiOiI3ZmRkNjA0NmY1N2I5NTVhNzA2OTBkMjVkNGM5ZjM4Y2U2ZGEyMzg4OTllMDQ2YTFiY2FjNDQ5MDY5M2NlNTE4IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 08:08:16 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImtLTHVhbU51ckxsQjQ1ZmhDamVHK1E9PSIsInZhbHVlIjoiemdDaUxTT3RTKzB0WUgyZlVCSVJsZ0hvcmQ3dnFiZHlqZEN3QlNONXQrTGxCWEpVRUFxY3d0SDVwbmRVZlF5Sk5r ▶"
    2 => "course_id=14; expires=Tue, 07-Apr-2026 06:08:15 GMT; path=/"
    3 => "course_name=M+Pharm; expires=Tue, 07-Apr-2026 06:08:15 GMT; path=/"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 06:08:16	GET	/mpharm-colleges-india	1 11 30 3867

1 x Application (97.82%)	544ms
1 x Booting (2.18%)	12.11ms