Top Arts Colleges in Madhya Pradesh 2025 : Fees, Rankings, Placements, Admissions

Messages Timeline Exceptions Views11 Route Queries31 Models2209 Mails Gate Session Request

Request history8.3.19393ms6MBGET {course}/colleges-{filters}

Booting (21.12ms)time
Application (372ms)time
1 x Application (94.62%)
372ms
1 x Booting (5.38%)
21.12ms

11 templates were rendered

pages.search-result.indexindex.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
pages.search-result.filtersfilters.blade.php#?blade
components.storiesstories.blade.php#?blade
components.registrationregistration.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.headerheader.blade.php#?blade
partials.footerfooter.blade.php#?blade
components.sucessesModalsucessesModal.blade.php#?blade
partials.bottomfooterbottomfooter.blade.php#?blade

uri: GET {course}/colleges-{filters}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\SearchController@index
as: sr.filters
namespace
prefix
where
file: app/Http/Controllers/SearchController.php:34-84

31 statements were executed (2 duplicates)Show only duplicates215ms

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_new11.67msselect * from `seo_redirects` where `redirect_from` = '/arts/colleges-madhya-pradesh' limit 1

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

MetaChecker.php#20db_collegesearch_new1.47ms

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

Bindings	0: arts/colleges-madhya-pradesh 1: active
Backtrace	app/Http/Middleware/MetaChecker.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SoftRedirects.php:28 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51

helpers.php#722db_collegesearch_new2.4ms

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

Bindings	0: sr 1: active
Backtrace	app/helpers.php:722 vendor/laravel/framework/src/Illuminate/Container/Container.php:989 vendor/laravel/framework/src/Illuminate/Container/Container.php:819 vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048 vendor/laravel/framework/src/Illuminate/Container/Container.php:755

SearchController.php#153db_collegesearch_new3.39ms

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

Bindings	0: madhya 1: pradesh 2: madhya-pradesh 3: active
Backtrace	app/Http/Controllers/SearchController.php:153 app/Http/Controllers/SearchController.php:51 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#153db_collegesearch_new1.88ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('madhya', 'pradesh', 'madhya-pradesh') and `country_id` = 2 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc

Bindings	0: madhya 1: pradesh 2: madhya-pradesh 3: 2 4: active 5: 2
Backtrace	app/Http/Controllers/SearchController.php:153 app/Http/Controllers/SearchController.php:51 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#153db_collegesearch_new1.58ms

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

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

SearchController.php#153db_collegesearch_new2.69msselect `id`, `name`, `slug` from `programs` where 0 = 1 and `programs`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#186db_collegesearch_new2.23ms

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

Bindings	0: arts 1: active
Backtrace	app/Http/Controllers/SearchController.php:186 app/Http/Controllers/SearchController.php:51 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new42.59ms

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

Bindings	0: 82 1: active 2: active 3: 19
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new49.4ms

select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 82 and `institutes`.`deleted_at` is null and `status` = 'active') and `institute_programs`.`deleted_at` is null and `status` = 'active' and `course_id` in (19) 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 (19) 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 (19) 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 (19) 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: 82 1: active 2: active 3: 19 4: nirf 5: 2024 6: 0 7: 19 8: active 9: active 10: nirf 11: 2024 12: 0 13: 19 14: active 15: active 16: cs 17: 0 18: 19 19: active 20: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new2.9ms

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 (19)) 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 (8363, 13194, 13874, 41762, 41781, 41822, 41830, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691) and `institutes`.`deleted_at` is null and `status` = 'active'

Bindings	0: active 1: 19 2: active 3: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new2.03ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (8363, 13194, 13874, 41762, 41781, 41822, 41830, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691) and `course_id` in (19) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 19
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new950μs

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

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

SearchController.php#636db_collegesearch_new1.58ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (35, 36, 119, 574, 583, 594, 596, 603) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

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

SearchController.php#636db_collegesearch_new670μs

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

Bindings	0: active 1: 2
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new780μs

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (8363, 13194, 13874, 41762, 41781, 41822, 41830, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691) and `institute_ratings`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#636db_collegesearch_new1.37ms

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 (8363, 13194, 13874, 41762, 41781, 41822, 41830, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691) and `media_type` = 'image' and `institute_images`.`deleted_at` is null and `status` = 'active') as `laravel_table` where `laravel_row` <= 1 order by `laravel_row`

Bindings	0: image 1: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new650μs

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

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

SearchController.php#636db_collegesearch_new990μs

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (22385, 24971, 59999, 137190, 137250, 137427, 137474, 140158, 140589, 140695, 140862, 142600, 143061, 144676, 144696, 145806, 146179, 146533, 146910, 146986)

Backtrace

app/Http/Controllers/SearchController.php:636
app/Http/Controllers/SearchController.php:57
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#636db_collegesearch_new810μs

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

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

SearchController.php#636db_collegesearch_new1.16ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (8363, 13194, 13874, 41762, 41781, 41822, 41830, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691) and `ranking_body` = 'nirf' and `course_id` in (19) and `year` = 2024 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc, `rank` desc

Bindings	0: 8363 1: 13194 2: 13874 3: 41762 4: 41781 5: 41822 6: 41830 7: 42295 8: 42381 9: 42409 10: 42456 11: 42812 12: 43234 13: 43261 14: 43266 15: 43469 16: 43532 17: 43596 18: 43678 19: 43691 20: nirf 21: 19 22: 2024 23: active
Backtrace	app/Http/Controllers/SearchController.php:636 app/Http/Controllers/SearchController.php:57 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#394db_collegesearch_new43.45ms

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

Bindings	0: 82 1: active 2: active 3: 19
Backtrace	app/Http/Controllers/SearchController.php:394 app/Http/Controllers/SearchController.php:64 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#394db_collegesearch_new3.67ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (451, 1613, 1614, 1622, 1627, 2685, 3292, 3293, 3294, 3297, 3308, 3736, 3737, 3739, 3742, 4406, 4527, 4539, 4542, 4546, 4548, 4566, 4567, 4568, 4569, 4570, 4571, 4572, 4574, 4575, 4576, 4577, 4578, 4581, 4583, 4584, 4591, 4623, 4641, 4649, 4666, 4726, 4768, 4777, 4848, 4849, 4852, 4879, 4924, 4965, 5006, 6514, 6532, 6559, 6560, 6566, 6574, 7618, 8306, 8355, 8360, 8363, 8368, 8369, 8388, 8389, 9792, 9913, 10620, 10681, 10682, 10713, 11797, 12637, 13192, 13194, 13441, 13504, 13627, 13874, 13935, 13939, 14046, 14230, 14313, 14440, 14448, 14533, 14559, 14584, 14587, 14588, 14642, 14643, 14649, 14650, 14673, 14679, 14729, 14767, 14861, 14862, 15281, 15769, 15775, 15776, 17209, 17225, 17229, 17300, 17305, 17319, 17443, 17827, 17969, 18255, 18274, 18299, 18362, 18534, 18568, 18584, 18719, 18911, 19012, 19015, 19162, 19454, 19514, 19515, 19655, 19660, 20069, 20440, 20487, 20488, 20518, 20555, 30334, 31383, 32009, 32128, 32545, 35094, 36393, 36493, 36516, 36529, 36571, 36602, 36665, 36671, 36687, 36689, 36757, 36826, 36834, 36940, 37018, 37228, 37257, 37430, 37531, 37600, 37622, 37646, 37653, 37813, 37864, 38019, 38308, 38359, 38543, 38792, 38921, 38965, 39003, 39240, 39351, 39356, 39417, 39513, 39588, 39589, 39594, 39644, 39744, 39909, 40028, 40068, 40097, 40263, 40376, 40669, 40719, 40756, 40760, 40777, 40787, 40791, 40825, 40886, 40890, 40898, 40932, 40938, 40939, 40975, 41005, 41009, 41011, 41015, 41021, 41040, 41046, 41050, 41068, 41071, 41072, 41089, 41090, 41092, 41094, 41095, 41098, 41100, 41101, 41103, 41105, 41106, 41130, 41134, 41135, 41138, 41147, 41151, 41158, 41165, 41166, 41171, 41172, 41175, 41176, 41190, 41191, 41193, 41235, 41236, 41238, 41239, 41243, 41244, 41245, 41246, 41248, 41249, 41251, 41255, 41274, 41276, 41277, 41279, 41289, 41302, 41304, 41312, 41321, 41323, 41329, 41330, 41333, 41345, 41347, 41369, 41371, 41379, 41380, 41383, 41385, 41402, 41403, 41404, 41405, 41412, 41422, 41424, 41427, 41430, 41440, 41443, 41445, 41489, 41570, 41619, 41673, 41676, 41728, 41762, 41781, 41822, 41830, 41946, 42000, 42030, 42055, 42105, 42164, 42269, 42295, 42381, 42409, 42456, 42812, 43234, 43261, 43266, 43469, 43532, 43596, 43678, 43691, 43851, 43852, 43985, 44125, 44199, 44211, 44224, 44308, 44353, 44355, 44370, 44386, 44398, 44476, 44477, 44492, 45031, 45044, 45105, 45309, 45402, 45430, 45548, 45671, 45702, 45703, 45798, 45826, 45935, 45999, 46144, 46153, 46172, 46439, 46519, 46538, 46585, 46588, 46599, 46609, 46614, 46642, 46645, 46736, 46777, 46819, 46922, 46950, 46973, 46984, 47014, 47075, 47086, 47100, 47136, 47187, 47282, 47297, 47421, 47540, 47544, 47583, 47700, 47725, 47752, 47848, 47907, 47916, 47940, 48007, 48043, 48073, 48086, 48103, 48140, 48199, 48237, 48289, 48329, 48335, 48337, 48347, 48515, 48523, 48568, 48594, 48596, 48600, 48626, 48631, 48632, 48788, 49034, 49077, 49080, 49197, 49200, 49202, 49309, 49318, 49370, 49387, 49405, 49409, 49543, 49769, 49793, 49803, 49900, 49940, 50040, 50088, 50134, 50158, 50229, 50543, 50566, 51211, 51251, 51286, 51469, 51715, 51737, 51740, 51744, 51771, 51783, 51920, 51925, 52083, 52246, 52269, 52481, 52547, 52573, 52624, 52625, 52685, 52715, 52777, 52859, 52897, 53008, 53058, 53140, 53149) and `institutes`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#394db_collegesearch_new6.67ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (35, 36, 118, 119, 120, 121, 122, 169, 191, 197, 198, 235, 398, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 580, 581, 582, 583, 584, 585, 586, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 599, 601, 603) and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc

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

SearchController.php#394db_collegesearch_new1.27ms

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

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

SearchController.php#394db_collegesearch_new9.6ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (13699, 20797, 22360, 22385, 24971, 26088, 26997, 27340, 27478, 27546, 27697, 27713, 28437, 28787, 32357, 32911, 34062, 37113, 39582, 39614, 39689, 39747, 39772, 39824, 40306, 41186, 41330, 44482, 48454, 51146, 55199, 55515, 55521, 55530, 55544, 55618, 55662, 55847, 57221, 57237, 57267, 57279, 57295, 57311, 58989, 59866, 59993, 59999, 60032, 60036, 60069, 60080, 64703, 64709, 71845, 71966, 72240, 73279, 74505, 74581, 74618, 74619, 74660, 74763, 74817, 74941, 75783, 76930, 76939, 77916, 77955, 77959, 78193, 78197, 78220, 78326, 79221, 79624, 80151, 80918, 81828, 82144, 82695, 83600, 86200, 86207, 91629, 91643, 91650, 91663, 91688, 93057, 93166, 93318, 93367, 94736, 94800, 94825, 94859, 94877, 94928, 94942, 94945, 94963, 94987, 95000, 95020, 95036, 95067, 95087, 95103, 95145, 95213, 95228, 95470, 95502, 95614, 95627, 95636, 95684, 95778, 96009, 99511, 99600, 101953, 102023, 102381, 102549, 103224, 103780, 104886, 105188, 105802, 105891, 106168, 106578, 106827, 106851, 107744, 107875, 107884, 108187, 108203, 108988, 111441, 111522, 111732, 111973, 112062, 112399, 112429, 112469, 112488, 113111, 113691, 114093, 115218, 115358, 116109, 116624, 116838, 116967, 116990, 117497, 117746, 118455, 118813, 120174, 120247, 120709, 121175, 121968, 122634, 122908, 123186, 124010, 124017, 124387, 124448, 124661, 125083, 125421, 125424, 125434, 125742, 126174, 126736, 127648, 127739, 128820, 129430, 130892, 130893, 130912, 130972, 131316, 131517, 131529, 131558, 131708, 131722, 131735, 131736, 131793, 131815, 131851, 131852, 131872, 132052, 132053, 132067, 132083, 132096, 132118, 132158, 132196, 132204, 132216, 132261, 132264, 132279, 132282, 132333, 132341, 132344, 132354, 132373, 132519, 132545, 132550, 132553, 132560, 132604, 132680, 132681, 132710, 132724, 132729, 132737, 132740, 132743, 133466, 133470, 133493, 133508, 133509, 133520, 133524, 133533, 133572, 133579, 133656, 133684, 133687, 133707, 133783, 133917, 133922, 133949, 134023, 134186, 134201, 134274, 134293, 134295, 134303, 134310, 134325, 134763, 134824, 134881, 134903, 134943, 134951, 134994, 135027, 135086, 135171, 135178, 135193, 135202, 135236, 135335, 135337, 135440, 135531, 135536, 135545, 135551, 135558, 135573, 135584, 135642, 135885, 136275, 136589, 136800, 136823, 137035, 137190, 137250, 137427, 137474, 138111, 138428, 138607, 138775, 139438, 139987, 140158, 140589, 140695, 140862, 142600, 143061, 143816, 144676, 144696, 145806, 146179, 146533, 146910, 146986, 147477, 147490, 148723, 148903, 148937, 148986, 149329, 149530, 149537, 149685, 149870, 149929, 150182, 150193, 152647, 152725, 153096, 153123, 153928, 154365, 154519, 155079, 156004, 156158, 156838, 156853, 156995, 157528, 158392, 158469, 159129, 160094, 160420, 160497, 160817, 160866, 160890, 160976, 161062, 161066, 161150, 161415, 161702, 162280, 162470, 162579, 162634, 162765, 163081, 163193, 163384, 163568, 163615, 163979, 164012, 164282, 164484, 164808, 164950, 164965, 165142, 165770, 165873, 166209, 166540, 166555, 166564, 166760, 167130, 167423, 167488, 167521, 167617, 167885, 168301, 168451, 168475, 168479, 168523, 168957, 169324, 169473, 169563, 169568, 169590, 169648, 169730, 170473, 170480, 171332, 171472, 171865, 171871, 172318, 172500, 172546, 172572, 172605, 172618, 173099, 173438, 173963, 174030, 174063, 174407, 174541, 175004, 175196, 175468, 175593, 175712, 176043, 177180, 177282, 177518, 178049, 180493, 181310, 181816, 182764, 182919, 182924, 182954, 183094, 183133, 183752, 183755, 184560, 185271, 185359, 186728, 186999, 187082, 187257, 187263, 187501, 187639, 187904, 188219, 188431, 189019, 189248, 190571, 190804)

Backtrace

app/Http/Controllers/SearchController.php:394
app/Http/Controllers/SearchController.php:64
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

SearchController.php#394db_collegesearch_new6.63ms

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (21, 22, 23, 38, 93, 102, 116, 153, 161, 162, 199, 2002, 2008, 2009, 2063, 2240, 2328, 2342) and `exams`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#394db_collegesearch_new4.97ms

select `id`, `name`, `slug` from `programs` where `programs`.`id` in (440, 444, 446, 450, 466, 477, 482, 492, 493, 505, 520, 523, 541, 553, 3460, 3589, 4479, 4554, 4662, 4777, 4822, 5360, 5609, 6463, 6465, 6471, 6476, 6492, 6498, 6519, 6575, 6576, 6577, 6578, 6583, 6590, 6594, 6606, 6627, 6659, 6670, 7167, 7854, 9022, 10741) and `programs`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#398db_collegesearch_new1.29ms

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

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

SearchController.php#410db_collegesearch_new1.03ms

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

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

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

Bindings	0: sr 1: active
Backtrace	app/helpers.php:157 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

App\Models\InstituteProgramExamMapping: 1006InstituteProgramExamMapping.php#?
App\Models\InstituteProgram: 487InstituteProgram.php#?
App\Models\Institute: 487Institute.php#?
App\Models\City: 106City.php#?
App\Models\Program: 45Program.php#?
App\Models\State: 38State.php#?
App\Models\Exam: 16Exam.php#?
App\Models\InstituteCourseSummary: 14InstituteCourseSummary.php#?
App\Models\Course: 3Course.php#?
App\Models\InstituteRating: 3InstituteRating.php#?
App\Models\InstituteImage: 3InstituteImage.php#?
App\Models\DefaultMetaTag: 1DefaultMetaTag.php#?

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

path_info

/arts/colleges-madhya-pradesh

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

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 => "Sun, 08 Jun 2025 05:00:19 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklTUllUTk8vRzFpNXZ5RXg2aHhRbFE9PSIsInZhbHVlIjoiNVNLcDBRUFpuWC9CK21xeUpCblNMaWJ4RXF3SXkxZzIwalVEd3N6Y1ZmbFMxNHhudlAwOU5KalNwV3JLN3FtS3dJSU03dVltVjlWUzcwaWtsenB0MW82TzhtaldqbHcvZms5ZVBlMGdheWJ2QitSVWxxMU9ZeVovMW5obXd3WkEiLCJtYWMiOiJiN2I3MGQ3MzQ2YjQ2MTJkZDk0ZjIzNjI0YjcxOWUwNDZkM2I5NWUyMGE2MDc1NmFmNjY5OWQ2OTg2YzA1ZjY2IiwidGFnIjoiIn0%3D; expires=Sun, 08 Jun 2025 07:00:19 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IklTUllUTk8vRzFpNXZ5RXg2aHhRbFE9PSIsInZhbHVlIjoiNVNLcDBRUFpuWC9CK21xeUpCblNMaWJ4RXF3SXkxZzIwalVEd3N6Y1ZmbFMxNHhudlAwOU5KalNwV3JLN3FtS3dJSU03d ▶"
    1 => "laravel_session=eyJpdiI6IklLTzg1aCs1SzdydXRXakltMnVKTkE9PSIsInZhbHVlIjoibDRsQ3dQVjhlbldCaW1hSHVRRTNSekg4Mnd3VjRzZkZEWDNQRXhBQTJMem1jVGFUUTVWMFFwUEtBeGhjck1CSFprVzM5ZEEvdFV5VlJsYVRvQ0hTNlhiR2JYRlFRSFg1WFBUcWJveVlWZnRRQzZNQ01pU21vdERQS2tTNm5pZkEiLCJtYWMiOiI5YjgyY2VhYjU5MGYyYTFiMzUxZjFlYjQxNWRhNTM5MjliZmU5YTg4MTg1MzFjZWIxMDY0MTE5ZWNiODgxMGQwIiwidGFnIjoiIn0%3D; expires=Sun, 08 Jun 2025 07:00:19 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IklLTzg1aCs1SzdydXRXakltMnVKTkE9PSIsInZhbHVlIjoibDRsQ3dQVjhlbldCaW1hSHVRRTNSekg4Mnd3VjRzZkZEWDNQRXhBQTJMem1jVGFUUTVWMFFwUEtBeGhjck1CSFpr ▶"
    2 => "course_id=19; expires=Mon, 08 Jun 2026 05:00:19 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=Arts; expires=Mon, 08 Jun 2026 05:00:19 GMT; Max-Age=31536000; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklTUllUTk8vRzFpNXZ5RXg2aHhRbFE9PSIsInZhbHVlIjoiNVNLcDBRUFpuWC9CK21xeUpCblNMaWJ4RXF3SXkxZzIwalVEd3N6Y1ZmbFMxNHhudlAwOU5KalNwV3JLN3FtS3dJSU03dVltVjlWUzcwaWtsenB0MW82TzhtaldqbHcvZms5ZVBlMGdheWJ2QitSVWxxMU9ZeVovMW5obXd3WkEiLCJtYWMiOiJiN2I3MGQ3MzQ2YjQ2MTJkZDk0ZjIzNjI0YjcxOWUwNDZkM2I5NWUyMGE2MDc1NmFmNjY5OWQ2OTg2YzA1ZjY2IiwidGFnIjoiIn0%3D; expires=Sun, 08-Jun-2025 07:00:19 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IklTUllUTk8vRzFpNXZ5RXg2aHhRbFE9PSIsInZhbHVlIjoiNVNLcDBRUFpuWC9CK21xeUpCblNMaWJ4RXF3SXkxZzIwalVEd3N6Y1ZmbFMxNHhudlAwOU5KalNwV3JLN3FtS3dJSU03d ▶"
    1 => "laravel_session=eyJpdiI6IklLTzg1aCs1SzdydXRXakltMnVKTkE9PSIsInZhbHVlIjoibDRsQ3dQVjhlbldCaW1hSHVRRTNSekg4Mnd3VjRzZkZEWDNQRXhBQTJMem1jVGFUUTVWMFFwUEtBeGhjck1CSFprVzM5ZEEvdFV5VlJsYVRvQ0hTNlhiR2JYRlFRSFg1WFBUcWJveVlWZnRRQzZNQ01pU21vdERQS2tTNm5pZkEiLCJtYWMiOiI5YjgyY2VhYjU5MGYyYTFiMzUxZjFlYjQxNWRhNTM5MjliZmU5YTg4MTg1MzFjZWIxMDY0MTE5ZWNiODgxMGQwIiwidGFnIjoiIn0%3D; expires=Sun, 08-Jun-2025 07:00:19 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IklLTzg1aCs1SzdydXRXakltMnVKTkE9PSIsInZhbHVlIjoibDRsQ3dQVjhlbldCaW1hSHVRRTNSekg4Mnd3VjRzZkZEWDNQRXhBQTJMem1jVGFUUTVWMFFwUEtBeGhjck1CSFpr ▶"
    2 => "course_id=19; expires=Mon, 08-Jun-2026 05:00:19 GMT; path=/"
    3 => "course_name=Arts; expires=Mon, 08-Jun-2026 05:00:19 GMT; path=/"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-08 05:00:19	GET	/arts/colleges-madhya-pradesh	11 31 2209

1 x Application (94.62%)	372ms
1 x Booting (5.38%)	21.12ms