Top Arts Colleges in Maharashtra 2025 : Fees, Rankings, Placements, Admissions

Messages Timeline Exceptions Views11 Route Queries30 Models5934 Mails Gate Session Request

Request history8.3.19494ms14MBGET {course}/colleges-{filters}

Booting (11.13ms)time
Application (483ms)time
1 x Application (97.75%)
483ms
1 x Booting (2.25%)
11.13ms

11 templates were rendered

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

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

30 statements were executed (2 duplicates)Show only duplicates336ms

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.14msselect * from `seo_redirects` where `redirect_from` = '/arts/colleges-maharashtra' limit 1

Bindings	0: /arts/colleges-maharashtra
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_new680μs

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

Bindings	0: arts/colleges-maharashtra 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_new1ms

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

Bindings	0: maharashtra 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.17ms

select `id`, `name`, `shortname` from `states` where `shortname` in ('maharashtra') 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: maharashtra 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_new860μs

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

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

SearchController.php#138db_collegesearch_new500μsselect `id`, `name`, `slug` from `programs` where 0 = 1 and `programs`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#171db_collegesearch_new590μs

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

select count(*) as aggregate from (select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 83 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: 83 1: active 2: active 3: 19
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_new110ms

select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 83 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: 83 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: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.99ms

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 (1799, 3316, 7245, 11113, 11198, 11687, 11700, 11704, 15478, 15613, 19800, 34626, 43917, 44287, 44309, 44314, 44315, 44413, 44431, 44438) and `institutes`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#569db_collegesearch_new1.52ms

select * from `institute_course_summaries` where `institute_course_summaries`.`institute_id` in (1799, 3316, 7245, 11113, 11198, 11687, 11700, 11704, 15478, 15613, 19800, 34626, 43917, 44287, 44309, 44314, 44315, 44413, 44431, 44438) and `course_id` in (19) and `institute_course_summaries`.`deleted_at` is null

Bindings	0: 19
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_new640μ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: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_new830μs

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (38, 39, 44, 127, 137, 138, 141) 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.11ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (83) 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_new730μs

select `institute_id`, `overall_rating` from `institute_ratings` where `institute_ratings`.`institute_id` in (1799, 3316, 7245, 11113, 11198, 11687, 11700, 11704, 15478, 15613, 19800, 34626, 43917, 44287, 44309, 44314, 44315, 44413, 44431, 44438) 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_new1.58ms

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 (1799, 3316, 7245, 11113, 11198, 11687, 11700, 11704, 15478, 15613, 19800, 34626, 43917, 44287, 44309, 44314, 44315, 44413, 44431, 44438) 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.04ms

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: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.02ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (18327, 18989, 39430, 42373, 48831, 52553, 58149, 66203, 67778, 67821, 76168, 76514, 147710, 149248, 149332, 149364, 149370, 149971, 150063, 150081)

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

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (21, 23, 106, 116, 2008, 2018, 2036, 2342) and `exams`.`deleted_at` is null and `status` = 'active'

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

SearchController.php#569db_collegesearch_new1.47ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` in (1799, 3316, 7245, 11113, 11198, 11687, 11700, 11704, 15478, 15613, 19800, 34626, 43917, 44287, 44309, 44314, 44315, 44413, 44431, 44438) 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: 1799 1: 3316 2: 7245 3: 11113 4: 11198 5: 11687 6: 11700 7: 11704 8: 15478 9: 15613 10: 19800 11: 34626 12: 43917 13: 44287 14: 44309 15: 44314 16: 44315 17: 44413 18: 44431 19: 44438 20: nirf 21: 19 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_new80.75ms

select * from `institute_programs` where exists (select * from `institutes` where `institute_programs`.`institute_id` = `institutes`.`id` and `state_id` = 83 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: 83 1: active 2: active 3: 19
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.71ms

select `id`, `city_id`, `state_id` from `institutes` where `institutes`.`id` in (559, 567, 1651, 1680, 1687, 1696, 1698, 1773, 1792, 1799, 2731, 2742, 3109, 3309, 3316, 3481, 3749, 3752, 4248, 4252, 4256, 4365, 4380, 4386, 4408, 4499, 4514, 4517, 4678, 4686, 4704, 4749, 4762, 4765, 4766, 4771, 4778, 4782, 4803, 4811, 4812, 4882, 4915, 4919, 4921, 4937, 5003, 5009, 5021, 5594, 6689, 6813, 7205, 7245, 7405, 7505, 7840, 8496, 10626, 10628, 10642, 10643, 10644, 10667, 10967, 10971, 10979, 11014, 11101, 11106, 11107, 11109, 11111, 11113, 11114, 11121, 11122, 11124, 11128, 11130, 11133, 11134, 11135, 11136, 11138, 11141, 11144, 11145, 11147, 11154, 11156, 11157, 11159, 11161, 11163, 11167, 11180, 11181, 11182, 11183, 11189, 11190, 11195, 11196, 11197, 11198, 11200, 11201, 11202, 11204, 11205, 11220, 11222, 11225, 11227, 11230, 11233, 11235, 11241, 11242, 11244, 11247, 11251, 11265, 11272, 11273, 11277, 11280, 11282, 11285, 11287, 11288, 11297, 11320, 11325, 11343, 11346, 11349, 11350, 11352, 11362, 11364, 11365, 11371, 11402, 11403, 11404, 11413, 11427, 11444, 11445, 11448, 11450, 11465, 11473, 11474, 11485, 11486, 11488, 11489, 11495, 11496, 11514, 11516, 11517, 11518, 11519, 11526, 11527, 11547, 11549, 11551, 11552, 11640, 11644, 11687, 11694, 11700, 11702, 11703, 11704, 11705, 11752, 11866, 11882, 11984, 11992, 11995, 12058, 12065, 12067, 12071, 12126, 12127, 12129, 12130, 12149, 12150, 12151, 12152, 12154, 12155, 12159, 12164, 12165, 12167, 12168, 12195, 12196, 12197, 12198, 12199, 12223, 12226, 12228, 12229, 12240, 12247, 12261, 12264, 12266, 12267, 12269, 12270, 12272, 12301, 12305, 12307, 12308, 12309, 12310, 12311, 12312, 12313, 12314, 12316, 12318, 12319, 12330, 12340, 12342, 12351, 12352, 12356, 12357, 12359, 12377, 12384, 12388, 12391, 12392, 12393, 12415, 12418, 12420, 12422, 12425, 12551, 12591, 12630, 12631, 12648, 12649, 12813, 12854, 13766, 13995, 14000, 14317, 14910, 15083, 15084, 15085, 15096, 15097, 15099, 15102, 15108, 15110, 15115, 15116, 15118, 15119, 15124, 15125, 15126, 15166, 15168, 15170, 15173, 15197, 15205, 15208, 15214, 15217, 15220, 15222, 15223, 15230, 15235, 15249, 15251, 15257, 15260, 15267, 15269, 15278, 15282, 15284, 15289, 15290, 15292, 15293, 15295, 15296, 15300, 15302, 15303, 15308, 15313, 15323, 15324, 15327, 15328, 15335, 15337, 15338, 15343, 15346, 15352, 15353, 15356, 15358, 15377, 15381, 15383, 15385, 15392, 15396, 15398, 15410, 15412, 15413, 15416, 15428, 15432, 15440, 15452, 15454, 15457, 15458, 15465, 15475, 15476, 15478, 15485, 15491, 15494, 15495, 15498, 15500, 15501, 15502, 15504, 15507, 15515, 15525, 15526, 15527, 15529, 15530, 15531, 15534, 15542, 15543, 15547, 15549, 15557, 15559, 15560, 15561, 15563, 15565, 15567, 15568, 15570, 15572, 15574, 15575, 15576, 15578, 15583, 15584, 15585, 15589, 15590, 15592, 15593, 15594, 15595, 15597, 15598, 15600, 15601, 15602, 15604, 15605, 15606, 15608, 15610, 15611, 15612, 15613, 15615, 15621, 15623, 15624, 15628, 15630, 15632, 15635, 15637, 15638, 15640, 15642, 15645, 15648, 15649, 15650, 15654, 15657, 15659, 15661, 15662, 15663, 15666, 15667, 15669, 15670, 15677, 15678, 15679, 15680, 15681, 15683, 15689, 15700, 15703, 15705, 15708, 15709, 15710, 15711, 15712, 15713, 15714, 15715, 15716, 15718, 15719, 15720, 15721, 15722, 15723, 15724, 15725, 15726, 15728, 15729, 15737, 15738, 15742, 15745, 15752, 15753, 15754, 15755, 15760, 15764, 15780, 15781, 15782, 15784, 15787, 15789, 15790, 15792, 15794, 15795, 15797, 15798, 15800, 15801, 15803, 15805, 15806, 15807, 15808, 15813, 16650, 16773, 17187, 17212, 17234, 17236, 17242, 17758, 17806, 17928, 18049, 18059, 18069, 18091, 18114, 18297, 18364, 18383, 18430, 18510, 18586, 18645, 18682, 18694, 18732, 18811, 18824, 18825, 18836, 18878, 19024, 19028, 19144, 19213, 19219, 19237, 19336, 19377, 19378, 19382, 19411, 19449, 19472, 19473, 19545, 19552, 19587, 19632, 19661, 19800, 20012, 20061, 20260, 20439, 20497, 20499, 20509, 20548, 20549, 20568, 20587, 20604, 33853, 34529, 34626, 35131, 35367, 36390, 36407, 36415, 36417, 36421, 36422, 36424, 36427, 36429, 36430, 36431, 36433, 36434, 36435, 36436, 36440, 36442, 36445, 36446, 36447, 36449, 36451, 36454, 36457, 36458, 36459, 36463, 36464, 36487, 36556, 36584, 36624, 36712, 36715, 36744, 36754, 36759, 36820, 36861, 36967, 36974, 36993, 37028, 37042, 37047, 37058, 37085, 37095, 37135, 37137, 37159, 37190, 37193, 37219, 37220, 37256, 37258, 37259, 37260, 37261, 37262, 37263, 37264, 37268, 37270, 37271, 37272, 37273, 37274, 37275, 37276, 37277, 37278, 37308, 37365, 37499, 37548, 37574, 37766, 37769, 37805, 37816, 37827, 37890, 37891, 37904, 37905, 37963, 37965, 37966, 38036, 38038, 38135, 38136, 38137, 38153, 38163, 38167, 38182, 38217, 38218, 38220, 38260, 38273, 38274, 38275, 38276, 38412, 38453, 38487, 38525, 38746, 38788, 38793, 38819, 38876, 38886, 38894, 38925, 38968, 39050, 39058, 39073, 39184, 39361, 39374, 39466, 39483, 39519, 39554, 39583, 39595, 39621, 39678, 39682, 39688, 39762, 39768, 39779, 39813, 39819, 39820, 39825, 39826, 39838, 39843, 39851, 39901, 39919, 39927, 39952, 39955, 39969, 39970, 39981, 39999, 40017, 40020, 40032, 40049, 40063, 40131, 40209, 40246, 40252, 40282, 40303, 40305, 40358, 40388, 40402, 40415, 40428, 40461, 40474, 40492, 40524, 40528, 40602, 40629, 40648, 41004, 41444, 41460, 41461, 41518, 41528, 41655, 41660, 41680, 41729, 41794, 41915, 41929, 41982, 41983, 42016, 42021, 42026, 42064, 42066, 42089, 42090, 42102, 42108, 42152, 42277, 42331, 42335, 42346, 42362, 42390, 42398, 42442, 42444, 42503, 42540, 42546, 42570, 42603, 42636, 42637, 42658, 42686, 42693, 42695, 42794, 42799, 42827, 42828, 42836, 42870, 42918, 42964, 42966, 42967, 42968, 42969, 42971, 42998, 43021, 43023, 43045, 43055, 43059, 43061, 43070, 43081, 43114, 43117, 43118, 43130, 43131, 43134, 43135, 43142, 43165, 43191, 43244, 43278, 43297, 43307, 43327, 43330, 43373, 43374, 43375, 43380, 43439, 43482, 43485, 43487, 43513, 43653, 43714, 43729, 43731, 43732, 43734, 43735, 43738, 43740, 43741, 43742, 43743, 43749, 43755, 43757, 43762, 43768, 43770, 43772, 43773, 43775, 43777, 43778, 43779, 43780, 43784, 43785, 43787, 43789, 43790, 43791, 43792, 43795, 43797, 43798, 43806, 43810, 43811, 43812, 43815, 43817, 43818, 43841, 43843, 43844, 43860, 43866, 43913, 43915, 43917, 43918, 43923, 43972, 44039, 44051, 44262, 44272, 44287, 44309, 44314, 44315, 44339, 44413, 44414, 44431, 44438, 44439, 44450, 44452, 44461, 44467, 44486, 44501, 44502, 44506, 44507, 44553, 44555, 44558, 44586, 44589, 44672, 44693, 44694, 44695, 44707, 44711, 44712, 44727, 44728, 44775, 44776, 44778, 44780, 44788, 44795, 44804, 44815, 44879, 44882, 44886, 44890, 44894, 44896, 44898, 44904, 44918, 44919, 44920, 44921, 44945, 44946, 45024, 45039, 45040, 45059, 45138, 45165, 45169, 45172, 45173, 45196, 45244, 45289, 45301, 45302, 45303, 45313, 45314, 45318, 45339, 45354, 45428, 45440, 45466, 45471, 45483, 45487, 45507, 45532, 45533, 45543, 45570, 45611, 45612, 45627, 45658, 45662, 45683, 45712, 45718, 45721, 45776, 45814, 45840, 45894, 45897, 45932, 45936, 45981, 45985, 45986, 45992, 45993, 46049, 46075, 46076, 46077, 46078, 46087, 46095, 46097, 46142, 46162, 46223, 46279, 46280, 46300, 46315, 46322, 46369, 46395, 46401, 46417, 46421, 46434, 46480, 46484, 46488, 46495, 46523, 46556, 46565, 46568, 46581, 46688, 46689, 46690, 46691, 46707, 46734, 46735, 46764, 46782, 46818, 46835, 46983, 47043, 47049, 47069, 47070, 47080, 47081, 47102, 47126, 47173, 47174, 47175, 47176, 47177, 47191, 47192, 47215, 47277, 47305, 47312, 47329, 47330, 47357, 47379, 47399, 47415, 47418, 47451, 47452, 47463, 47467, 47479, 47480, 47483, 47489, 47594, 47645, 47670, 47697, 47699, 47722, 47739, 47897, 47898, 47994, 48020, 48033, 48056, 48063, 48064, 48100, 48101, 48123, 48124, 48134, 48137, 48167, 48168, 48169, 48180, 48187, 48188, 48196, 48202, 48221, 48223, 48229, 48234, 48254, 48256, 48307, 48308, 48310, 48313, 48316, 48317, 48346, 48356, 48358, 48382, 48383, 48454, 48461, 48509, 48563, 48587, 48588, 48589, 48613, 48614, 48615, 48617, 48618, 48620, 48663, 48735, 48801, 48803, 48807, 48813, 48850, 48888, 48897, 48905, 48958, 48959, 48966, 48967, 48971, 48985, 49017, 49060, 49063, 49065, 49068, 49081, 49099, 49142, 49150, 49201, 49216, 49279, 49292, 49352, 49357, 49359, 49360, 49397, 49406, 49423, 49436, 49437, 49441, 49461, 49465, 49503, 49550, 49551, 49556, 49576, 49581, 49616, 49622, 49624, 49629, 49633, 49648, 49665, 49673, 49768, 49790, 49802, 49808, 49821, 49823, 49824, 49825, 49846, 49848, 49864, 49873, 49874, 49875, 49876, 49913, 49914, 49932, 49959, 49969, 49983, 49988, 49991, 49997, 49998, 49999, 50008, 50019, 50032, 50041, 50043, 50048, 50075, 50076, 50114, 50129, 50173, 50184, 50203, 50286, 50291, 50302, 50314, 50317, 50323, 50324, 50325, 50326, 50330, 50361, 50362, 50369, 50398, 50399, 50410, 50414, 50426, 50440, 50441, 50461, 50467, 50468, 50469, 50481, 50482, 50483, 50493, 50503, 50526, 50549, 50733, 50745, 50782, 50820, 50843, 50875, 50903, 50914, 50924, 50956, 51070, 51198, 51244, 51287, 51551, 51672, 51682, 51727, 51748, 51749, 51793, 51797, 51819, 51904, 51911, 51923, 51978, 51997, 52014, 52016, 52095, 52096, 52116, 52161, 52164, 52217, 52238, 52274, 52322, 52345, 52379, 52380, 52401, 52427, 52455, 52534, 52538, 52576, 52587, 52602, 52613, 52622, 52642, 52717, 52782, 52794, 52825, 52826, 52847, 52852, 52858, 52900, 52936, 52947, 52982, 52985, 52995, 53013, 53022, 53036, 53038, 53039, 53040, 53044, 53060, 53069, 53128) 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_new2.53ms

select `id`, `name`, `shortname` from `cities` where `cities`.`id` in (22, 37, 38, 39, 43, 44, 45, 47, 48, 50, 83, 123, 125, 126, 127, 128, 129, 131, 132, 133, 134, 135, 137, 138, 140, 141, 143, 179, 214, 215, 397, 466, 549, 550, 551, 552, 553, 554, 555, 557, 558, 559, 560, 561, 562, 604, 701) 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.19ms

select `id`, `name`, `shortname` from `states` where `states`.`id` in (83) 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_new18.22ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (17924, 18191, 18295, 18327, 18339, 18360, 18380, 18522, 18989, 18999, 19019, 19088, 19742, 19795, 19879, 19890, 19933, 19953, 20057, 20185, 20526, 20759, 20820, 24728, 25339, 25345, 27367, 30457, 30474, 30489, 30506, 30554, 30560, 30610, 30626, 30645, 30657, 30844, 30878, 30938, 31037, 31077, 31096, 31190, 31224, 31246, 31263, 31316, 31322, 31334, 31356, 31364, 31395, 31409, 31420, 31443, 31444, 31449, 31468, 31537, 31553, 31590, 31601, 31612, 31657, 31664, 31686, 31698, 31719, 31731, 31738, 31741, 31782, 31809, 31820, 31826, 31838, 31879, 31907, 31948, 31966, 31989, 32035, 32051, 32056, 32062, 32076, 32137, 32142, 32155, 32180, 32196, 32198, 32204, 32228, 32254, 32267, 32277, 32288, 32307, 32340, 32390, 33058, 36859, 36947, 37012, 38774, 39430, 39977, 41833, 42094, 42373, 42577, 44819, 44843, 48569, 48640, 48821, 48831, 52525, 52553, 53200, 53882, 53898, 54926, 55146, 55927, 56362, 56762, 57698, 58012, 58149, 60219, 64463, 64474, 64533, 64537, 64541, 64638, 65683, 65729, 65815, 66168, 66175, 66190, 66203, 66205, 66229, 66231, 66238, 66254, 66266, 66267, 66271, 66285, 66298, 66312, 66318, 66325, 66347, 66357, 66359, 66366, 66378, 66391, 66394, 66401, 66402, 66420, 66424, 66443, 66451, 66452, 66460, 66464, 66467, 66476, 66497, 66509, 66526, 66533, 66538, 66547, 66549, 66590, 66603, 66605, 66623, 66630, 66639, 66650, 66655, 66659, 66685, 66759, 66786, 66797, 66815, 66838, 66841, 66843, 66859, 66903, 66909, 66933, 66974, 67007, 67010, 67015, 67020, 67044, 67065, 67069, 67088, 67094, 67108, 67157, 67165, 67169, 67175, 67179, 67199, 67202, 67263, 67267, 67271, 67672, 67683, 67778, 67821, 67825, 68584, 68751, 68900, 68905, 69010, 69015, 69022, 69027, 69053, 69061, 69068, 69075, 69084, 69089, 69102, 69113, 69116, 69124, 69128, 69164, 69167, 69171, 69241, 69252, 69372, 69375, 69382, 69385, 69475, 69478, 69481, 69482, 69485, 69488, 69489, 69492, 69495, 69500, 69506, 69507, 69547, 69554, 69568, 69571, 69584, 69639, 69672, 69674, 69677, 69703, 69710, 70347, 70398, 70664, 70770, 73973, 75070, 75406, 75414, 75425, 75429, 75447, 75451, 75485, 75584, 75608, 75619, 75638, 75652, 75669, 75676, 75718, 75736, 75773, 75792, 75798, 75814, 75818, 75823, 75827, 75835, 75838, 75850, 75853, 75859, 75890, 75900, 75916, 75925, 75952, 75990, 75994, 76017, 76020, 76068, 76080, 76087, 76117, 76133, 76155, 76168, 76189, 76205, 76210, 76219, 76248, 76269, 76275, 76286, 76291, 76302, 76327, 76340, 76358, 76363, 76367, 76384, 76388, 76395, 76402, 76405, 76423, 76436, 76440, 76443, 76447, 76450, 76463, 76476, 76487, 76499, 76508, 76514, 76527, 76543, 76551, 76564, 76578, 76595, 76600, 76607, 76617, 76619, 76643, 76654, 76656, 76661, 76664, 76693, 76700, 76719, 76748, 76754, 76761, 76770, 76775, 76778, 76781, 76784, 76786, 76789, 76791, 76795, 76809, 76838, 76844, 76870, 76887, 76898, 76948, 76957, 76965, 76973, 76975, 76981, 76984, 76989, 76991, 76995, 76998, 77007, 77013, 77016, 77020, 77031, 77844, 77917, 77969, 77993, 78049, 78960, 79385, 79404, 79646, 79699, 80210, 80238, 80258, 80636, 81369, 81438, 83667, 85126, 86314, 86326, 86344, 90965, 94233, 94249, 94470, 94483, 94546, 94703, 94714, 94716, 95239, 95249, 95312, 95399, 95416, 95419, 95481, 95510, 95518, 95551, 95560, 95562, 95703, 95763, 95772, 95774, 95793, 96006, 96016, 97035, 97355, 99945, 99958, 99987, 99992, 100007, 100010, 100032, 100056, 100066, 100069, 100092, 100132, 100134, 100158, 100215, 100293, 100402, 100407, 100474, 100501, 100582, 100588, 100628, 100643, 100645, 100647, 100665, 100693, 100700, 100702, 100964, 102681, 102684, 102686, 102746, 102832, 103004, 103012, 103049, 103061, 103064, 103066, 103067, 103070, 103074, 103098, 103103, 103104, 103120, 103134, 103140, 103152, 103182, 103184, 103240, 103243, 103251, 103359, 103603, 103690, 103919, 103946, 103986, 104153, 104881, 105407, 105647, 106107, 106187, 106303, 106361, 106364, 106390, 106482, 106857, 106870, 107129, 107401, 107525, 107533, 107556, 107625, 107732, 107831, 107834, 107957, 107965, 108105, 108216, 108553, 108689, 108974, 109098, 109100, 109154, 109185, 109218, 109359, 109867, 111433, 111451, 111850, 111922, 112026, 112537, 112548, 112669, 112729, 113004, 113331, 113846, 113861, 113940, 114131, 114205, 114251, 114324, 114448, 114480, 114699, 114808, 115016, 115017, 115116, 115117, 115325, 115337, 115350, 115353, 115354, 115356, 115365, 115370, 115374, 115376, 115380, 115381, 115386, 115391, 115399, 115400, 115402, 115409, 115413, 115651, 115839, 115959, 116070, 116273, 116443, 116927, 117286, 117289, 117291, 117438, 117445, 117534, 117572, 117788, 117808, 117817, 117868, 117871, 118167, 118174, 118249, 118506, 119040, 119042, 119043, 119095, 119140, 119157, 119194, 119376, 119412, 119610, 119705, 119708, 119711, 120509, 120713, 120784, 120906, 121003, 121769, 121961, 121976, 122167, 122367, 122410, 122646, 122936, 123225, 123248, 123261, 123797, 123809, 124443, 124546, 124596, 124599, 124853, 124902, 125107, 125293, 125396, 125438, 125455, 125456, 125605, 125907, 125918, 125953, 126275, 126291, 126327, 126493, 126589, 126692, 126693, 126816, 126861, 126953, 127000, 127174, 127203, 127205, 127269, 127272, 127274, 127325, 127367, 127513, 127573, 127592, 127618, 127683, 128484, 128556, 128744, 128771, 128855, 128878, 128949, 129057, 129086, 129127, 129254, 129352, 129464, 129532, 129579, 129675, 129812, 129868, 129946, 130171, 130186, 130594, 130683, 130782, 131037, 135189, 135425, 135692, 135771, 135774, 135777, 136059, 136082, 136658, 136659, 136695, 136767, 136831, 137037, 137296, 137497, 137922, 137985, 138166, 138351, 138357, 138483, 138503, 138522, 138537, 138892, 138894, 139046, 139052, 139137, 139382, 140024, 140214, 140310, 140415, 140642, 140770, 140838, 141040, 141201, 141207, 141316, 141502, 141653, 141662, 141666, 141701, 141716, 141815, 141969, 142015, 142024, 142663, 142775, 142776, 142872, 143016, 143116, 143258, 143259, 143261, 143266, 143271, 143275, 143417, 143508, 143515, 143667, 143689, 143711, 143794, 143972, 143994, 144045, 144047, 144065, 144072, 144087, 144366, 144613, 144737, 144862, 144919, 145071, 145085, 145379, 145381, 145383, 145403, 145616, 145745, 145861, 145868, 145882, 146054, 146666, 146826, 147088, 147143, 147147, 147150, 147155, 147169, 147170, 147178, 147179, 147181, 147182, 147184, 147193, 147198, 147208, 147214, 147224, 147230, 147237, 147238, 147254, 147258, 147265, 147268, 147281, 147286, 147290, 147293, 147295, 147297, 147303, 147305, 147311, 147314, 147316, 147319, 147322, 147324, 147334, 147345, 147350, 147352, 147371, 147376, 147396, 147441, 147445, 147446, 147549, 147671, 147696, 147710, 147713, 147726, 147828, 147946, 148039, 148489, 148533, 149087, 149130, 149248, 149332, 149364, 149370, 149456, 149971, 149988, 150063, 150081, 150084, 150090, 150151, 150167, 150180, 150249, 150289, 150301, 150307, 150316, 150323, 150517, 150520, 150525, 150694, 151167, 151232, 151241, 151275, 151287, 151298, 151341, 151345, 151353, 151565, 151566, 151569, 151578, 151598, 151650, 151696, 151764, 152004, 152010, 152016, 152025, 152034, 152047, 152072, 152101, 152170, 152172, 152173, 152175, 152273, 152613, 152713, 152715, 152881, 153223, 153309, 153319, 153328, 153331, 153409, 153573, 153818, 153859, 153912, 153913, 153915, 153949, 154052, 154149, 154497, 154555, 154659, 154677, 154739, 154760, 154849, 154998, 154999, 155046, 155051, 155086, 155690, 155695, 155747, 155966, 156049, 156182, 156213, 156228, 156504, 156679, 156916, 157059, 157404, 157409, 157524, 157531, 157706, 157748, 157810, 157812, 158049, 158063, 158125, 158197, 158201, 158380, 158515, 158789, 159173, 159190, 159269, 159418, 159725, 159919, 159924, 159938, 160028, 160044, 160084, 160283, 160291, 160312, 160335, 160439, 160608, 160631, 160661, 160739, 160850, 161226, 161233, 161243, 161303, 161406, 161412, 161542, 161545, 161599, 161824, 162626, 162952, 162986, 163090, 163091, 163207, 163282, 163533, 163541, 163544, 163552, 163556, 163624, 163627, 163704, 163958, 164022, 164064, 164112, 164115, 164237, 164342, 164378, 164462, 164467, 164613, 164617, 164622, 164637, 164648, 164695, 164706, 164719, 164727, 165208, 165409, 165520, 165754, 165834, 166477, 166480, 166502, 166591, 166689, 166875, 167040, 167173, 167204, 167385, 167398, 167400, 167513, 167514, 167569, 167573, 167601, 167605, 167749, 167751, 167764, 167808, 167858, 167863, 167877, 167898, 167980, 167981, 167998, 168033, 168135, 168138, 168337, 168354, 168355, 168361, 168367, 168379, 168387, 168518, 168549, 168551, 168620, 168622, 168955, 168987, 169284, 169449, 169539, 169541, 169545, 169546, 169624, 169626, 169630, 169632, 169634, 169640, 170103, 170195, 170198, 170557, 170559, 170586, 170750, 170855, 170874, 170924, 171079, 171123, 171138, 171146, 171201, 171278, 171411, 171426, 171436, 171442, 171475, 171683, 171701, 171870, 171924, 172171, 172222, 172242, 172401, 172433, 172442, 172449, 172451, 172519, 172549, 172552, 172585, 172608, 172692, 172742, 172743, 172747, 172803, 172827, 172991, 173142, 173167, 173285, 173312, 173392, 173404, 173408, 173464, 173488, 173492, 173496, 173552, 173555, 173575, 173811, 173957, 174014, 174067, 174094, 174124, 174131, 174135, 174137, 174183, 174184, 174241, 174274, 174280, 174318, 174464, 174467, 174508, 174785, 174831, 174843, 174854, 174898, 174907, 174992, 175007, 175017, 175113, 175115, 175262, 175372, 175677, 175727, 175828, 176255, 176365, 176390, 176395, 176409, 176530, 176541, 176544, 176546, 176598, 176660, 176672, 176742, 176779, 176813, 176820, 176834, 176868, 176912, 176927, 176933, 176936, 176938, 176959, 176963, 176965, 176977, 176979, 176982, 176983, 177010, 177084, 177227, 178206, 178390, 178628, 178691, 178823, 179008, 179044, 179195, 180470, 180530, 180548, 180574, 181350, 182129, 182195, 182462, 182604, 182626, 182979, 182980, 182981, 183174, 183196, 183206, 183305, 183705, 183719, 183765, 184018, 184160, 184621, 184622, 184683, 184761, 184902, 184928, 184946, 185180, 185242, 185370, 185992, 186043, 186195, 186205, 186306, 186320, 186391, 186446, 186532, 186957, 186967, 187099, 187176, 187205, 187215, 187248, 187353, 187606, 187653, 187917, 187974, 188130, 188133, 188175, 188194, 188216, 188461, 188502, 188507, 188691, 188744, 188877, 188917, 188962, 189033, 189052, 189059, 189134, 189135, 189149, 189196, 189244, 189254, 189329, 189356, 190257)

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

select `id`, `name`, `slug` from `exams` where `exams`.`id` in (11, 12, 14, 15, 20, 21, 22, 23, 24, 25, 26, 27, 31, 36, 43, 47, 57, 60, 91, 93, 106, 116, 117, 128, 131, 137, 161, 165, 185, 2008, 2009, 2018, 2036, 2048, 2079, 2173, 2222, 2240, 2268, 2326, 2328, 2332, 2334, 2342, 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.28ms

select `id`, `name`, `slug` from `programs` where `programs`.`id` in (6, 440, 444, 446, 450, 453, 454, 467, 474, 477, 490, 494, 498, 499, 511, 517, 518, 520, 542, 553, 554, 562, 569, 572, 595, 602, 3460, 3475, 3589, 3769, 4194, 4822, 5095, 5360, 5516, 5523, 5537, 5676, 6463, 6465, 6469, 6473, 6475, 6476, 6485, 6491, 6494, 6495, 6560, 6582, 6583, 6585, 6588, 6592, 6594, 6596, 6610, 6626, 6627, 6637, 6672, 7073, 7854, 7855, 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_new1.12ms

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

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

helpers.php#156db_collegesearch_new1.51msselect * from `brandings` where `section` = 'sr' and `brandings`.`deleted_at` is null and `status` = 'active'

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

App\Models\InstituteProgramExamMapping: 2931InstituteProgramExamMapping.php#?
App\Models\InstituteProgram: 1361InstituteProgram.php#?
App\Models\Institute: 1361Institute.php#?
App\Models\City: 103City.php#?
App\Models\Program: 65Program.php#?
App\Models\State: 38State.php#?
App\Models\Exam: 36Exam.php#?
App\Models\InstituteCourseSummary: 16InstituteCourseSummary.php#?
App\Models\InstituteRating: 10InstituteRating.php#?
App\Models\InstituteImage: 10InstituteImage.php#?
App\Models\Course: 3Course.php#?

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

path_info

/arts/colleges-maharashtra

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 12:12:06 GMT"
  ]
  "set-cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjA5ZjliZHZoQ1B2NFBYcVFTaktITkE9PSIsInZhbHVlIjoic2xSajYrT3hnemlOZkRLTEVtb2hKU29iWDJJZXlBNUxGaC9KTnZOTUQxb2xSQ1g0dkxYL2N6THkrcWtMUEpvSmxNeUg0a2pzZFNydkJCdzlGQ0J3RWZhQVVKTXB4YzdhcTkxMU1ZWC9ieDB3UkwwWjN3NkIxTHNFWW5GWndXaTgiLCJtYWMiOiJlMjJlNThlNDBhZGEyYWE1NmNiZWFjMjI4NmNiMDE2ZDI5YjBkMmJhNzRjNTc0YmM2YjViOGQxZDRmZTdjYjEyIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 14:12:06 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjA5ZjliZHZoQ1B2NFBYcVFTaktITkE9PSIsInZhbHVlIjoic2xSajYrT3hnemlOZkRLTEVtb2hKU29iWDJJZXlBNUxGaC9KTnZOTUQxb2xSQ1g0dkxYL2N6THkrcWtMUEpvSmxNeUg0a ▶"
    1 => "laravel_session=eyJpdiI6Ikt4M2xTS2Z6endqekNFeTBKdHBSbXc9PSIsInZhbHVlIjoicndRUFhYYTJwU0U4UTZOeEN4anRiQ1VDei9yVFJrSkxxT3NISGJLUmpiaTh0bUlTczBBckdNNVdPM2ZsNm1SeUNCMTFwelRkc2xyallSUjhOK2hjU0RaVDZOcHJ3dmpjTmh4V3ZuTFlqdmFtakprYVptL216MVVUZTRhemtLSnIiLCJtYWMiOiJlYjU5MWRjMTUzNzUwMzA2YzMwYjM4ZjVmNTkxMDU5NGU0MzBkN2M1NmQzYTUyODY3OTg1ODc3MDIwMzUxMmE0IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 14:12:06 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ikt4M2xTS2Z6endqekNFeTBKdHBSbXc9PSIsInZhbHVlIjoicndRUFhYYTJwU0U4UTZOeEN4anRiQ1VDei9yVFJrSkxxT3NISGJLUmpiaTh0bUlTczBBckdNNVdPM2ZsNm1SeUNC ▶"
    2 => "course_id=19; expires=Wed, 08 Apr 2026 12:12:06 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=Arts; expires=Wed, 08 Apr 2026 12:12:06 GMT; Max-Age=31536000; path=/; samesite=lax"
  ]
  "Set-Cookie" => array:4 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjA5ZjliZHZoQ1B2NFBYcVFTaktITkE9PSIsInZhbHVlIjoic2xSajYrT3hnemlOZkRLTEVtb2hKU29iWDJJZXlBNUxGaC9KTnZOTUQxb2xSQ1g0dkxYL2N6THkrcWtMUEpvSmxNeUg0a2pzZFNydkJCdzlGQ0J3RWZhQVVKTXB4YzdhcTkxMU1ZWC9ieDB3UkwwWjN3NkIxTHNFWW5GWndXaTgiLCJtYWMiOiJlMjJlNThlNDBhZGEyYWE1NmNiZWFjMjI4NmNiMDE2ZDI5YjBkMmJhNzRjNTc0YmM2YjViOGQxZDRmZTdjYjEyIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 14:12:06 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjA5ZjliZHZoQ1B2NFBYcVFTaktITkE9PSIsInZhbHVlIjoic2xSajYrT3hnemlOZkRLTEVtb2hKU29iWDJJZXlBNUxGaC9KTnZOTUQxb2xSQ1g0dkxYL2N6THkrcWtMUEpvSmxNeUg0a ▶"
    1 => "laravel_session=eyJpdiI6Ikt4M2xTS2Z6endqekNFeTBKdHBSbXc9PSIsInZhbHVlIjoicndRUFhYYTJwU0U4UTZOeEN4anRiQ1VDei9yVFJrSkxxT3NISGJLUmpiaTh0bUlTczBBckdNNVdPM2ZsNm1SeUNCMTFwelRkc2xyallSUjhOK2hjU0RaVDZOcHJ3dmpjTmh4V3ZuTFlqdmFtakprYVptL216MVVUZTRhemtLSnIiLCJtYWMiOiJlYjU5MWRjMTUzNzUwMzA2YzMwYjM4ZjVmNTkxMDU5NGU0MzBkN2M1NmQzYTUyODY3OTg1ODc3MDIwMzUxMmE0IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 14:12:06 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6Ikt4M2xTS2Z6endqekNFeTBKdHBSbXc9PSIsInZhbHVlIjoicndRUFhYYTJwU0U4UTZOeEN4anRiQ1VDei9yVFJrSkxxT3NISGJLUmpiaTh0bUlTczBBckdNNVdPM2ZsNm1SeUNC ▶"
    2 => "course_id=19; expires=Wed, 08-Apr-2026 12:12:06 GMT; path=/"
    3 => "course_name=Arts; expires=Wed, 08-Apr-2026 12:12:06 GMT; path=/"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-08 12:12:06	GET	/arts/colleges-maharashtra	11 30 5934

1 x Application (97.75%)	483ms
1 x Booting (2.25%)	11.13ms