Bachelor of Hotel Management & Catering Technology (BHMCT) in Rayat Bahra University, Mohali Fees Breakup, Total Fees, Eligibility.

Particular	Details
Total Seats	60
Course Fee	4,00,000
Duration	4 Years
Accepted Exams	, NCHMCT JEE

Messages Timeline Exceptions Views12 Route Queries61 Models1499 Mails Gate Session Request

Request history8.3.19254ms6MBGET {type}/{slug}/{tab}/{tab2}

Booting (6.93ms)time
Application (247ms)time
1 x Application (97.27%)
247ms
1 x Booting (2.73%)
6.93ms

12 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.blade.php#?blade
components.total-reviewtotal-review.blade.php#?blade
components.detailed-reviewsdetailed-reviews.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 {type}/{slug}/{tab}/{tab2}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs2
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:105-229

61 statements were executed (7 duplicates)Show only duplicates128ms

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

select * from `seo_redirects` where `redirect_from` = '/university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320' limit 1

Bindings	0: /university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320
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_new940μs

select * from `meta_tags` where `slug` = 'university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320 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

CollegeController.php#130db_collegesearch_new4.25ms

select `institutes`.*, (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 `slug` = 'rayat-bahra-university-mohali' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: rayat-bahra-university-mohali 2: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new3.11ms

select `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` in (15055) and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new2.33ms

select `id`, `name` from `programs` where `programs`.`id` in (14, 15, 17, 20, 23, 24, 26, 28, 32, 36, 38, 49, 50, 51, 58, 150, 153, 201, 216, 273, 347, 439, 440, 444, 446, 448, 454, 456, 460, 461, 467, 479, 482, 512, 662, 711, 784, 786, 787, 789, 807, 916, 918, 919, 920, 922, 924, 927, 928, 931, 943, 944, 954, 973, 1000, 1002, 1006, 1014, 1016, 1021, 1038, 1039, 1040, 1077, 1107, 1143, 1147, 1153, 1167, 1170, 1211, 1230, 1231, 1232, 1484, 1485, 1592, 1595, 1597, 1598, 1601, 1626, 1629, 1636, 1732, 1778, 1799, 1903, 2015, 2032, 2035, 2036, 2037, 2038, 2040, 2041, 2042, 2043, 2049, 2051, 2101, 2264, 2265, 2266, 2278, 2279, 2287, 2291, 2296, 2299, 2300, 2303, 2312, 2313, 2320, 2325, 2328, 2338, 2356, 2361, 2387, 2389, 2398, 2400, 2446, 2456, 2469, 2560, 2602, 2745, 2746, 2748, 2751, 2753, 2772, 2773, 2775, 2779, 2791, 2798, 2802, 2807, 2808, 2816, 2822, 2828, 2832, 2845, 2857, 2872, 2901, 2946, 2961, 2963, 2976, 3102, 3119, 3156, 3171, 3198, 3202, 3212, 3430, 3437, 3438, 3440, 3443, 3445, 3446, 3447, 3461, 3465, 3479, 3486, 3493, 3531, 3586, 3587, 3588, 3591, 3595, 3597, 3600, 3615, 3622, 3634, 3644, 3652, 3705, 3777, 3846, 3932, 4220, 4428, 4497, 4517, 4696, 4744, 4761, 4765, 4805, 4806, 4807, 4808, 4812, 4843, 4898, 4916, 4940, 4944, 5038, 5039, 5042, 5058, 5131, 5196, 5197, 5369, 5424, 5515, 5559, 5577, 5720, 5727, 5903, 6014, 6102, 6103, 6106, 6113, 6119, 6133, 6134, 6135, 6136, 6137, 6138, 6139, 6191, 6453, 6498, 6501, 6527, 6545, 6549, 6550, 6552, 6575, 6795, 6850, 6885, 7021, 7055, 7088, 7139, 7140, 7142, 7277, 7285, 7430, 7480, 8206, 8269, 8418, 8496, 8575, 8581, 8597, 8619, 8910, 9048, 9535, 9591, 9595, 9597, 9628, 9655, 9668, 9757, 9835, 9837, 9840, 9844, 9869, 9903, 9915, 9958, 9993, 10033, 10067, 10074, 10229, 10379, 10718, 10719, 10720, 10727, 10730, 10740) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new980μs

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 6, 7, 8, 9, 10, 11, 12, 13, 14, 18, 19, 20, 21, 22, 23, 24, 25, 26, 33, 40, 41, 43, 59, 60, 73, 74, 80, 81, 93, 118, 120, 126, 137, 142) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new3.04ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (29568, 29569, 29570, 29571, 29572, 29573, 29574, 29578, 29579, 29580, 29581, 29582, 29583, 29584, 29585, 29586, 29587, 29588, 29589, 29590, 29591, 29592, 29593, 29594, 29595, 29596, 29597, 29598, 29599, 29600, 29601, 29602, 29603, 29604, 29605, 29606, 29607, 29608, 29609, 29610, 29611, 29612, 33416, 33417, 33418, 33419, 33420, 33421, 33422, 33423, 33424, 33425, 33426, 33427, 33428, 33429, 33430, 33431, 33432, 33433, 33434, 33435, 41116, 41117, 41118, 41119, 41120, 41121, 41122, 41123, 41124, 41125, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 42604, 42605, 42606, 42607, 42608, 42609, 42610, 42611, 42612, 42613, 42614, 42615, 42616, 42617, 42618, 42619, 42620, 42621, 42622, 42623, 42624, 42625, 42626, 42627, 42628, 42629, 42630, 42631, 42632, 42633, 42634, 42635, 42636, 42637, 42638, 42639, 42640, 42641, 42642, 42643, 42644, 42645, 42646, 42647, 42648, 42649, 42650, 42651, 42652, 42653, 44079, 44080, 44081, 44082, 44083, 44272, 44273, 44274, 44275, 44276, 44277, 44278, 44279, 44280, 44281, 44282, 44283, 44284, 44285, 44286, 44287, 44288, 44289, 44290, 44291, 44292, 44293, 44296, 44298, 44299, 44300, 44302, 44303, 44304, 44305, 44306, 44307, 44308, 44309, 44310, 44468, 75318, 75319, 75320, 75321, 75322, 75323, 75324, 75325, 75326, 75327, 75328, 75329, 75330, 75331, 75332, 75333, 75334, 75335, 75336, 75337, 75338, 75339, 75340, 75341, 75342, 75343, 75345, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362, 75363, 75364, 75365, 75366, 75367, 75368, 75369, 75370, 75371, 75372, 75373, 75374, 75375, 75376, 75377, 110938, 110939, 110940, 110941, 110942, 110943, 110944, 110945, 110946, 110947, 110948, 110949, 110950, 110951, 110952, 110953, 110954, 110955, 110956, 110957, 110958, 110959, 110960, 110962, 110963, 110964, 110965, 110966, 110967, 110968, 110969, 110970, 111097, 111098, 111099, 111100, 111101, 111102, 111103, 111104, 111105, 111106, 111107, 111108, 111109, 111110, 111111, 111112, 111113, 111114, 111115, 111116, 111117, 111118, 111119, 111120, 111121, 111122, 111123, 111124, 111125, 111126, 111127, 111128, 111129, 111130, 111131, 111132, 111133, 111134, 111135, 111136, 111137, 111138, 111139, 111140, 111141, 111142, 111143, 111144, 111145, 111146, 111147, 111148, 111149, 111150, 111151, 111152, 111153, 111154, 111155, 111156, 111157, 111158, 111159, 111160, 111161, 111162, 111163, 111164, 111165, 111166, 111167, 111168, 111169, 111170, 111171, 111172, 111173, 111174, 111175, 111176, 111177, 111178, 111179, 111180, 111181, 111182, 111183, 111184, 111185, 111186, 111187, 111188, 111189, 111190, 111191, 111192, 111193, 111194, 111195, 111196, 111197, 111198, 111199) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new3.59ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (29568, 29569, 29570, 29571, 29572, 29573, 29574, 29578, 29579, 29580, 29581, 29582, 29583, 29584, 29585, 29586, 29587, 29588, 29589, 29590, 29591, 29592, 29593, 29594, 29595, 29596, 29597, 29598, 29599, 29600, 29601, 29602, 29603, 29604, 29605, 29606, 29607, 29608, 29609, 29610, 29611, 29612, 33416, 33417, 33418, 33419, 33420, 33421, 33422, 33423, 33424, 33425, 33426, 33427, 33428, 33429, 33430, 33431, 33432, 33433, 33434, 33435, 41116, 41117, 41118, 41119, 41120, 41121, 41122, 41123, 41124, 41125, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 42604, 42605, 42606, 42607, 42608, 42609, 42610, 42611, 42612, 42613, 42614, 42615, 42616, 42617, 42618, 42619, 42620, 42621, 42622, 42623, 42624, 42625, 42626, 42627, 42628, 42629, 42630, 42631, 42632, 42633, 42634, 42635, 42636, 42637, 42638, 42639, 42640, 42641, 42642, 42643, 42644, 42645, 42646, 42647, 42648, 42649, 42650, 42651, 42652, 42653, 44079, 44080, 44081, 44082, 44083, 44272, 44273, 44274, 44275, 44276, 44277, 44278, 44279, 44280, 44281, 44282, 44283, 44284, 44285, 44286, 44287, 44288, 44289, 44290, 44291, 44292, 44293, 44296, 44298, 44299, 44300, 44302, 44303, 44304, 44305, 44306, 44307, 44308, 44309, 44310, 44468, 75318, 75319, 75320, 75321, 75322, 75323, 75324, 75325, 75326, 75327, 75328, 75329, 75330, 75331, 75332, 75333, 75334, 75335, 75336, 75337, 75338, 75339, 75340, 75341, 75342, 75343, 75345, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362, 75363, 75364, 75365, 75366, 75367, 75368, 75369, 75370, 75371, 75372, 75373, 75374, 75375, 75376, 75377, 110938, 110939, 110940, 110941, 110942, 110943, 110944, 110945, 110946, 110947, 110948, 110949, 110950, 110951, 110952, 110953, 110954, 110955, 110956, 110957, 110958, 110959, 110960, 110962, 110963, 110964, 110965, 110966, 110967, 110968, 110969, 110970, 111097, 111098, 111099, 111100, 111101, 111102, 111103, 111104, 111105, 111106, 111107, 111108, 111109, 111110, 111111, 111112, 111113, 111114, 111115, 111116, 111117, 111118, 111119, 111120, 111121, 111122, 111123, 111124, 111125, 111126, 111127, 111128, 111129, 111130, 111131, 111132, 111133, 111134, 111135, 111136, 111137, 111138, 111139, 111140, 111141, 111142, 111143, 111144, 111145, 111146, 111147, 111148, 111149, 111150, 111151, 111152, 111153, 111154, 111155, 111156, 111157, 111158, 111159, 111160, 111161, 111162, 111163, 111164, 111165, 111166, 111167, 111168, 111169, 111170, 111171, 111172, 111173, 111174, 111175, 111176, 111177, 111178, 111179, 111180, 111181, 111182, 111183, 111184, 111185, 111186, 111187, 111188, 111189, 111190, 111191, 111192, 111193, 111194, 111195, 111196, 111197, 111198, 111199) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#130db_collegesearch_new1.81ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (29568, 29569, 29570, 29571, 29572, 29573, 29574, 29578, 29579, 29580, 29581, 29582, 29583, 29584, 29585, 29586, 29587, 29588, 29589, 29590, 29591, 29592, 29593, 29594, 29595, 29596, 29597, 29598, 29599, 29600, 29601, 29602, 29603, 29604, 29605, 29606, 29607, 29608, 29609, 29610, 29611, 29612, 33416, 33417, 33418, 33419, 33420, 33421, 33422, 33423, 33424, 33425, 33426, 33427, 33428, 33429, 33430, 33431, 33432, 33433, 33434, 33435, 41116, 41117, 41118, 41119, 41120, 41121, 41122, 41123, 41124, 41125, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 42604, 42605, 42606, 42607, 42608, 42609, 42610, 42611, 42612, 42613, 42614, 42615, 42616, 42617, 42618, 42619, 42620, 42621, 42622, 42623, 42624, 42625, 42626, 42627, 42628, 42629, 42630, 42631, 42632, 42633, 42634, 42635, 42636, 42637, 42638, 42639, 42640, 42641, 42642, 42643, 42644, 42645, 42646, 42647, 42648, 42649, 42650, 42651, 42652, 42653, 44079, 44080, 44081, 44082, 44083, 44272, 44273, 44274, 44275, 44276, 44277, 44278, 44279, 44280, 44281, 44282, 44283, 44284, 44285, 44286, 44287, 44288, 44289, 44290, 44291, 44292, 44293, 44296, 44298, 44299, 44300, 44302, 44303, 44304, 44305, 44306, 44307, 44308, 44309, 44310, 44468, 75318, 75319, 75320, 75321, 75322, 75323, 75324, 75325, 75326, 75327, 75328, 75329, 75330, 75331, 75332, 75333, 75334, 75335, 75336, 75337, 75338, 75339, 75340, 75341, 75342, 75343, 75345, 75346, 75347, 75348, 75349, 75350, 75351, 75352, 75353, 75354, 75355, 75356, 75357, 75358, 75359, 75360, 75361, 75362, 75363, 75364, 75365, 75366, 75367, 75368, 75369, 75370, 75371, 75372, 75373, 75374, 75375, 75376, 75377, 110938, 110939, 110940, 110941, 110942, 110943, 110944, 110945, 110946, 110947, 110948, 110949, 110950, 110951, 110952, 110953, 110954, 110955, 110956, 110957, 110958, 110959, 110960, 110962, 110963, 110964, 110965, 110966, 110967, 110968, 110969, 110970, 111097, 111098, 111099, 111100, 111101, 111102, 111103, 111104, 111105, 111106, 111107, 111108, 111109, 111110, 111111, 111112, 111113, 111114, 111115, 111116, 111117, 111118, 111119, 111120, 111121, 111122, 111123, 111124, 111125, 111126, 111127, 111128, 111129, 111130, 111131, 111132, 111133, 111134, 111135, 111136, 111137, 111138, 111139, 111140, 111141, 111142, 111143, 111144, 111145, 111146, 111147, 111148, 111149, 111150, 111151, 111152, 111153, 111154, 111155, 111156, 111157, 111158, 111159, 111160, 111161, 111162, 111163, 111164, 111165, 111166, 111167, 111168, 111169, 111170, 111171, 111172, 111173, 111174, 111175, 111176, 111177, 111178, 111179, 111180, 111181, 111182, 111183, 111184, 111185, 111186, 111187, 111188, 111189, 111190, 111191, 111192, 111193, 111194, 111195, 111196, 111197, 111198, 111199) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

Institute.php#174db_collegesearch_new900μs

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

Bindings	0: 196 1: active
Backtrace	app/Models/Institute.php:174 app/Http/Controllers/CollegeController.php:339 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#189db_collegesearch_new1.39ms

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

Bindings	0: 90 1: active 2: 2
Backtrace	app/Models/Institute.php:189 app/Http/Controllers/CollegeController.php:339 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#771db_collegesearch_new1.92ms

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 15055 and `institute_contents`.`institute_id` is not null and `type` = 'course-fees-program-specific' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 15055 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:771 app/Http/Controllers/CollegeController.php:341 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#342db_collegesearch_new870μs

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 15055 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null

Bindings	0: 15055
Backtrace	app/Http/Controllers/CollegeController.php:342 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#342db_collegesearch_new830μs

select `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (1) and `institute_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:342 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#807db_collegesearch_new1.64ms

select `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 15055 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:807 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#807db_collegesearch_new1.69msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:807
app/Http/Controllers/CollegeController.php:343
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#818db_collegesearch_new2.69ms

select count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 15055 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:818 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new960μs

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 15055 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:819 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#820db_collegesearch_new990μs

select `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 15055 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:820 app/Http/Controllers/CollegeController.php:343 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.08ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 15055 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:345 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.15ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.01ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(admission_review) DESC, `created_at` desc limit 2

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.07msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:349
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.43ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.48ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(placement_review) DESC, `created_at` desc limit 2

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new880μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:349
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new950μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.41ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 15055 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(faculty_review) DESC, `created_at` desc limit 2

Bindings	0: 15055 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new800μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:349
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#559db_collegesearch_new1.17ms

select * from `institute_programs` where `institute_id` = 15055 and `institute_programs`.`id` = '75320' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 15055 1: 75320 2: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new940μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (75320) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new950μs

select `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (75320) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new2.2msselect * from `courses` where `courses`.`id` in (12) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new530μsselect * from `degrees` where `degrees`.`id` in (1) and `degrees`.`deleted_at` is null and `status` = 'Active'

Bindings	0: 1 1: Active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new1.03msselect * from `streams` where `streams`.`id` in (6) and `streams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 6 1: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new980μs

select * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (75320) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new1.62ms

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (75320)

Backtrace

app/Http/Controllers/CollegeController.php:559
app/Http/Controllers/CollegeController.php:140
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

CollegeController.php#559db_collegesearch_new1.07ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new1.74ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (131) and exists (select * from `exam_features` where `exam_feature_mappings`.`exam_feature_id` = `exam_features`.`id` and `type` like '%date%' and `exam_features`.`deleted_at` is null and `status` = 'active') and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active'

Bindings	0: %date% 1: active 2: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#559db_collegesearch_new1.19ms

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (13, 26) and `exam_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:559 app/Http/Controllers/CollegeController.php:140 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

Exam.php#58db_collegesearch_new1.07ms

select `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 131 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 131 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:560 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.64ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 15055 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 12 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1

Bindings	0: 15055 1: cs 2: nirf 3: 12 4: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:570 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#580db_collegesearch_new1.94ms

select `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 12 and `institute_id` = 15055) and `id` != '75320' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3

Bindings	0: 12 1: 15055 2: 75320 3: active
Backtrace	app/Http/Controllers/CollegeController.php:580 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#580db_collegesearch_new1ms

select `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (75323, 75365) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:580 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#584db_collegesearch_new1.36ms

select distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 15055 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:584 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#584db_collegesearch_new890μs

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (12, 97, 106, 128, 139, 833, 1089, 1099, 1440, 1613, 2851, 3052, 3161, 4463, 5020, 6169)

Backtrace

app/Http/Controllers/CollegeController.php:584
app/Http/Controllers/CollegeController.php:140
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

CollegeController.php#584db_collegesearch_new1.3ms

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (2, 4, 5, 6, 8, 15, 24, 336, 345)

Backtrace

app/Http/Controllers/CollegeController.php:584
app/Http/Controllers/CollegeController.php:140
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

CollegeController.php#589db_collegesearch_new1.96ms

select `id` from `institute_programs` where `institute_id` = 15055 and `course_id` = 12 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: 12 2: active
Backtrace	app/Http/Controllers/CollegeController.php:589 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#597db_collegesearch_new1.34ms

select institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (75320, 75323, 75365) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 75320 1: 75323 2: 75365 3: active
Backtrace	app/Http/Controllers/CollegeController.php:597 app/Http/Controllers/CollegeController.php:140 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

Institute.php#225db_collegesearch_new25.54ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 15055 and `faqs`.`faq_id` is not null and `sub_type` = 'course-fees-program-specific' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: 15055 2: course-fees-program-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:720 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#721db_collegesearch_new980μs

select * from `institute_ratings` where `institute_ratings`.`institute_id` = 15055 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:721 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#722db_collegesearch_new1.79ms

select * from `institute_documents` where `institute_documents`.`institute_id` = 15055 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:722 app/Http/Controllers/CollegeController.php:140 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

CollegeController.php#305db_collegesearch_new1.98ms

select `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '75320' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 75320 1: active
Backtrace	app/Http/Controllers/CollegeController.php:305 app/Http/Controllers/CollegeController.php:159 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

CollegeController.php#305db_collegesearch_new2.34ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:305 app/Http/Controllers/CollegeController.php:159 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

CollegeController.php#1034db_collegesearch_new2.14ms

select distinct `course_id` from `institute_programs` where `institute_id` = 15055 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 15055 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1034 app/Http/Controllers/CollegeController.php:160 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

CollegeController.php#1040db_collegesearch_new2.87ms

select distinct `exam_id` from `institute_program_exam_mappings` inner join `institute_programs` on `institute_programs`.`id` = `institute_program_exam_mappings`.`institute_program_id` where `institute_programs`.`institute_id` = 15055

Bindings	0: 15055
Backtrace	app/Http/Controllers/CollegeController.php:1040 app/Http/Controllers/CollegeController.php:160 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#491db_collegesearch_new2.94ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%cp%' and `sub_type` like '%course-fees-program-specific%' and `module_id` = 15055 and `expiry_date` > '2025-04-17 23:54:46' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 15055 3: 2025-04-17 23:54:46
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:160 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#506db_collegesearch_new3.59ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('21', '23', '93', '38', '2008', '2342', '2140', '161', '2240', '8', '2288', '128', '2249', '22', '26', '162', '137', '116', '2198', '131', '153', '2410', '2321', '2324', '2323', '27', '47', '20') and `expiry_date` > '2025-04-17 23:54:46' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 21 3: 23 4: 93 5: 38 6: 2008 7: 2342 8: 2140 9: 161 10: 2240 11: 8 12: 2288 13: 128 14: 2249 15: 22 16: 26 17: 162 18: 137 19: 116 20: 2198 21: 131 22: 153 23: 2410 24: 2321 25: 2324 26: 2323 27: 27 28: 47 29: 20 30: 2025-04-17 23:54:46
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:160 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#520db_collegesearch_new3.28ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%course%' and `module_id` in ('1', '10', '2', '7', '13', '14', '23', '20', '25', '19', '126', '43', '60', '21', '11', '12', '9', '24', '18', '22', '26', '8', '118', '6', '73', '80', '120', '74', '93', '59', '81', '142', '40', '41', '33', '137') and `sub_type` like '%about%' and `expiry_date` > '2025-04-17 23:54:46' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 1 2: 10 3: 2 4: 7 5: 13 6: 14 7: 23 8: 20 9: 25 10: 19 11: 126 12: 43 13: 60 14: 21 15: 11 16: 12 17: 9 18: 24 19: 18 20: 22 21: 26 22: 8 23: 118 24: 6 25: 73 26: 80 27: 120 28: 74 29: 93 30: 59 31: 81 32: 142 33: 40 34: 41 35: 33 36: 137 37: %about% 38: 2025-04-17 23:54:46
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:160 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

CollegeController.php#886db_collegesearch_new740μs

select * from `meta_tags` where `slug` = 'university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320 1: active
Backtrace	app/Http/Controllers/CollegeController.php:886 app/Http/Controllers/CollegeController.php:192 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.23msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 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: 410InstituteProgram.php#?
App\Models\InstituteProgramFeesSummary: 359InstituteProgramFeesSummary.php#?
App\Models\Program: 299Program.php#?
App\Models\InstituteProgramPlacement: 280InstituteProgramPlacement.php#?
App\Models\Course: 38Course.php#?
App\Models\InstituteProgramExamMapping: 30InstituteProgramExamMapping.php#?
App\Models\InstituteRecruiter: 16InstituteRecruiter.php#?
App\Models\Recruiter: 16Recruiter.php#?
App\Models\InstituteContent: 9InstituteContent.php#?
App\Models\RecruiterIndustryType: 9RecruiterIndustryType.php#?
App\Models\InstituteImage: 6InstituteImage.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\ExamFeatureMapping: 2ExamFeatureMapping.php#?
App\Models\ExamFeature: 2ExamFeature.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\Admin: 1Admin.php#?
App\Models\InstituteFaculty: 1InstituteFaculty.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\Exam: 1Exam.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: I8MGU1X0isQgaa1hiVJLGSo8pOfO7h1tMkFrlTka
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/university/rayat-bahra-university-mohali/cour...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "cookie" => array:1 [▶
    0 => "viewed_colleges=%5B3444%5D; XSRF-TOKEN=eyJpdiI6IjBuQ3ZTQXRLMXBEbm42c09VRWhmQ3c9PSIsInZhbHVlIjoiVnAzNmxkM0xuNXZnSnlnL01XaldtM2NHR2Q3d3d4bE1SZFpYcUpBMXViQ0dlNnY2Sm1ua3NXN05ScU5GWEFrcjl2VVk2cE1CaUlYbmV6SkpFT2lEMERYUDhFVzZjTnEyWDRoZVQweHNLZGd5bzc2SVp5U3U2Rm5BcTgvQnd0bWsiLCJtYWMiOiIxMGU2NjMyZGFlNmYyZDM2YTljNWExNjE5Y2I2ZmY2ZDNjNzY1N2M3YzViNjBjZjk0MDA5ZWIxNDhhNDk5NDkwIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkhCTms2WUFNVU1zRVBUemQ2ekxzSmc9PSIsInZhbHVlIjoiVmpYenZmTFBONDcwRWMwWk8rdGUyTEJQc2lXVDlMa1RDMTBpWDNQRS9CMjN1cVJVcVNUWEtyOXVIbkhnYUp4d29iWWN0Q29ucTVZdzRGK3QveCtzZ2lrdjBiRStpTHZRSU1FSTY2MzhZd3NQa0NNTnhkZWIrNU5DdUFwTzFqWXAiLCJtYWMiOiJiNDAwZTdkM2U4MTE0Y2JlODRmYjVkNWFlZTE5YmY0NjUxNzc4ZjFmNWMzOTNhY2ZkNTI5NmRmMWRlNzlhMDcyIiwidGFnIjoiIn0%3D; course_id=14; course_name=M%20Pharm ◀viewed_colleges=%5B3444%5D; XSRF-TOKEN=eyJpdiI6IjBuQ3ZTQXRLMXBEbm42c09VRWhmQ3c9PSIsInZhbHVlIjoiVnAzNmxkM0xuNXZnSnlnL01XaldtM2NHR2Q3d3d4bE1SZFpYcUpBMXViQ0dlNnY2S ▶"
  ]
  "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

  0 of 0   
array:5 [▼
  "viewed_colleges" => "[3444]"
  "XSRF-TOKEN" => "I8MGU1X0isQgaa1hiVJLGSo8pOfO7h1tMkFrlTka"
  "laravel_session" => "AV0K1xDnSwu0TOHfAhtEQUJukHSpOwni59ObIaKJ"
  "course_id" => "14"
  "course_name" => "M Pharm"
]

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 => "Thu, 17 Apr 2025 23:54:46 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkRPU3BXMUw5Umt6V0VNNThCMm1EOFE9PSIsInZhbHVlIjoiSTRKTlVVTUlGdGcrTXdSOGdyck8zdEdkU2JTM081Z1NpMVl6SWZFaXplMU9NUFRIRFMwY0UwZUtlaWZmTm42RTBodDRld1ZtU0lqU3J1NURldXB3UnN4UlRwMTdCTmxtNW5ERWFhZXA1WU9aRFM1cWdvYlU0Q2NpM0dtdHlUSmwiLCJtYWMiOiI3YzkyNGJhNjc0ZTY3NzJjNmU3NDcxOWYzNDQxZTI4ODUwZGJlNzQxM2FjMzZiZjE1OWQxNWFjZjUyNWZiYjk5IiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 01:54:46 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkRPU3BXMUw5Umt6V0VNNThCMm1EOFE9PSIsInZhbHVlIjoiSTRKTlVVTUlGdGcrTXdSOGdyck8zdEdkU2JTM081Z1NpMVl6SWZFaXplMU9NUFRIRFMwY0UwZUtlaWZmTm42RTBodDRld ▶"
    1 => "laravel_session=eyJpdiI6ImRUcnNBTTZ5MlM0VnNmWmVnWWdvdGc9PSIsInZhbHVlIjoiR0hNYkgxUWRSOEw0eUZRall4Wkw1dEVwRmFEWi9SV3llRUxQT0UzaXVaOXRWaGZZQmU5M3dhbVRvVWNJaDZvam5FQWhSUWNnNXIzcnBxMmNhRmJWZ2tWaDB1aEpNb1FvOXU3d3NvYkV3Ui96YUpUQ0hkY0RrUHJIY0pORytSeU0iLCJtYWMiOiIzMDc0NzYyYWEyZTAxM2ZkNDcxNzQxYjY0MWY4MGFmMGViNTE0YmEwMzExMmQ4YzQ2NTkzYjVhNDdmNDRmNDAxIiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 01:54:46 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImRUcnNBTTZ5MlM0VnNmWmVnWWdvdGc9PSIsInZhbHVlIjoiR0hNYkgxUWRSOEw0eUZRall4Wkw1dEVwRmFEWi9SV3llRUxQT0UzaXVaOXRWaGZZQmU5M3dhbVRvVWNJaDZvam5F ▶"
    2 => "course_id=12; expires=Fri, 17 Apr 2026 23:54:46 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=BHM; expires=Fri, 17 Apr 2026 23:54:46 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B3444%2C15055%5D; expires=Sat, 17 May 2025 23:54:46 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkRPU3BXMUw5Umt6V0VNNThCMm1EOFE9PSIsInZhbHVlIjoiSTRKTlVVTUlGdGcrTXdSOGdyck8zdEdkU2JTM081Z1NpMVl6SWZFaXplMU9NUFRIRFMwY0UwZUtlaWZmTm42RTBodDRld1ZtU0lqU3J1NURldXB3UnN4UlRwMTdCTmxtNW5ERWFhZXA1WU9aRFM1cWdvYlU0Q2NpM0dtdHlUSmwiLCJtYWMiOiI3YzkyNGJhNjc0ZTY3NzJjNmU3NDcxOWYzNDQxZTI4ODUwZGJlNzQxM2FjMzZiZjE1OWQxNWFjZjUyNWZiYjk5IiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 01:54:46 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkRPU3BXMUw5Umt6V0VNNThCMm1EOFE9PSIsInZhbHVlIjoiSTRKTlVVTUlGdGcrTXdSOGdyck8zdEdkU2JTM081Z1NpMVl6SWZFaXplMU9NUFRIRFMwY0UwZUtlaWZmTm42RTBodDRld ▶"
    1 => "laravel_session=eyJpdiI6ImRUcnNBTTZ5MlM0VnNmWmVnWWdvdGc9PSIsInZhbHVlIjoiR0hNYkgxUWRSOEw0eUZRall4Wkw1dEVwRmFEWi9SV3llRUxQT0UzaXVaOXRWaGZZQmU5M3dhbVRvVWNJaDZvam5FQWhSUWNnNXIzcnBxMmNhRmJWZ2tWaDB1aEpNb1FvOXU3d3NvYkV3Ui96YUpUQ0hkY0RrUHJIY0pORytSeU0iLCJtYWMiOiIzMDc0NzYyYWEyZTAxM2ZkNDcxNzQxYjY0MWY4MGFmMGViNTE0YmEwMzExMmQ4YzQ2NTkzYjVhNDdmNDRmNDAxIiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 01:54:46 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImRUcnNBTTZ5MlM0VnNmWmVnWWdvdGc9PSIsInZhbHVlIjoiR0hNYkgxUWRSOEw0eUZRall4Wkw1dEVwRmFEWi9SV3llRUxQT0UzaXVaOXRWaGZZQmU5M3dhbVRvVWNJaDZvam5F ▶"
    2 => "course_id=12; expires=Fri, 17-Apr-2026 23:54:46 GMT; path=/"
    3 => "course_name=BHM; expires=Fri, 17-Apr-2026 23:54:46 GMT; path=/"
    4 => "viewed_colleges=%5B3444%2C15055%5D; expires=Sat, 17-May-2025 23:54:46 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "I8MGU1X0isQgaa1hiVJLGSo8pOfO7h1tMkFrlTka"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-17 23:54:46	GET	/university/rayat-bahra-university-mohali/courses-fees/bhm-bachelor-of-hotel-management-catering-technology-bhmct-75320	12 61 1499

Bachelor of Hotel Management & Catering Technology (BHMCT) in Rayat Bahra University, Mohali Fees Breakup, Total Fees, Eligibility.

Bachelor of Hotel Management & Catering Technology (BHMCT) Rayat Bahra University, Mohali Overview

Bachelor of Hotel Management & Catering Technology (BHMCT) Rayat Bahra University, Mohali Highlights

Bachelor of Hotel Management & Catering Technology (BHMCT) Rayat Bahra University, Mohali Eligibility

Bachelor of Hotel Management & Catering Technology (BHMCT) Rayat Bahra University, Mohali Admission Process

Bachelor of Hotel Management & Catering Technology (BHMCT) Fee Payment Options

Bachelor of Hotel Management & Catering Technology (BHMCT) Rayat Bahra University, Mohali Top Recruiters

Student's Rating for Rayat Bahra University, Mohali

Student's Reviews for Rayat Bahra University, Mohali

Gallery

Rayat Bahra University, Mohali Program Offered

Contact Details

1 x Application (97.27%)	247ms
1 x Booting (2.73%)	6.93ms