Check St Johns Medical College, Bangalore Student's and Alumni reviews

Messages Timeline Exceptions Views15 Route Queries43 Models91 Mails Gate Session Request

Request history8.3.17192ms3MBGET {type}/{slug}/{tab}

Booting (9.32ms)time
Application (182ms)time
1 x Application (95.14%)
182ms
1 x Booting (4.86%)
9.32ms

15 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
vendor.pagination.defaultdefault.blade.php#?blade
vendor.pagination.defaultdefault.blade.php#?blade
vendor.pagination.defaultdefault.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}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:104-187

43 statements were executed (15 duplicates)Show only duplicates67.01ms

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_new4.45ms

select * from `seo_redirects` where `redirect_from` = '/colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews' limit 1

Bindings	0: /colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews
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_new530μs

select * from `meta_tags` where `slug` = 'colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews 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#129db_collegesearch_new850μs

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` = 'st-johns-medical-college-sj-medical-college-bangalore' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: st-johns-medical-college-sj-medical-college-bangalore 2: active
Backtrace	app/Http/Controllers/CollegeController.php:129 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#129db_collegesearch_new570μs

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` in (2389) and `institute_feature_mappings`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:129
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#129db_collegesearch_new500μ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:129 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_new550μs

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

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

Institute.php#189db_collegesearch_new1.08ms

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

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

CollegeController.php#729db_collegesearch_new610μs

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 2389 and `institute_contents`.`institute_id` is not null and `type` = 'reviews' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 2389 1: reviews 2: active
Backtrace	app/Http/Controllers/CollegeController.php:729 app/Http/Controllers/CollegeController.php:299 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#765db_collegesearch_new1.28ms

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

Bindings	0: 2389 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:765 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#765db_collegesearch_new510μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (235) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:765
app/Http/Controllers/CollegeController.php:301
app/Http/Controllers/CollegeController.php:139
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new1.36ms

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` = 2389 and `institute_programs`.`institute_id` is not null and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new590μs

select `id`, `name` from `programs` where `programs`.`id` in (2630, 2631, 2632, 2633, 2634, 2635, 2637, 2638, 2639, 2640, 2642, 2643, 2645, 2646, 2647, 2655, 2657, 2660, 2665, 2666, 2668, 3429, 5412) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new960μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new790μs

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (5936, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13759, 13760, 13761, 13762, 13763, 72403, 72404, 72405, 72406, 72407, 72408) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new720μs

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (5936, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13759, 13760, 13761, 13762, 13763, 72403, 72404, 72405, 72406, 72407, 72408) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#774db_collegesearch_new960μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (5936, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13759, 13760, 13761, 13762, 13763, 72403, 72404, 72405, 72406, 72407, 72408) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:774 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#776db_collegesearch_new670μs

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

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:776 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new660μs

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

Bindings	0: 2389 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:777 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#778db_collegesearch_new1.15ms

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

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:778 app/Http/Controllers/CollegeController.php:301 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new680μs

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

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

Institute.php#138db_collegesearch_new760μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new670μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new650μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new990μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new640μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new740μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:307 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new720μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#149db_collegesearch_new800μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:149 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new640μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#149db_collegesearch_new590μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:149 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new610μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#149db_collegesearch_new610μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 2389 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: 2389 1: 2: active
Backtrace	app/Models/Institute.php:149 app/Http/Controllers/CollegeController.php:637 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#729db_collegesearch_new740μs

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 2389 and `institute_contents`.`institute_id` is not null and `type` = 'reviews' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 2389 1: reviews 2: active
Backtrace	app/Http/Controllers/CollegeController.php:729 app/Http/Controllers/CollegeController.php:638 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#225db_collegesearch_new27.11ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 2389 and `faqs`.`faq_id` is not null and `sub_type` = 'reviews' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: 2389 2: reviews 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:678 app/Http/Controllers/CollegeController.php:139 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#679db_collegesearch_new700μs

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

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:679 app/Http/Controllers/CollegeController.php:139 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#680db_collegesearch_new1.11ms

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

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:680 app/Http/Controllers/CollegeController.php:139 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#982db_collegesearch_new760μs

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

Bindings	0: 2389 1: active
Backtrace	app/Http/Controllers/CollegeController.php:982 app/Http/Controllers/CollegeController.php:144 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#988db_collegesearch_new1.01ms

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` = 2389

Bindings	0: 2389
Backtrace	app/Http/Controllers/CollegeController.php:988 app/Http/Controllers/CollegeController.php:144 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_new1.88ms

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 '%reviews%' and `module_id` = 2389 and `expiry_date` > '2025-03-14 18:51:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %reviews% 2: 2389 3: 2025-03-14 18:51:57
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:144 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_new1.86ms

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 ('175', '185') and `expiry_date` > '2025-03-14 18:51:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 175 3: 185 4: 2025-03-14 18:51:57
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:144 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_new1.78ms

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 ('4', '17') and `sub_type` like '%about%' and `expiry_date` > '2025-03-14 18:51:57' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 4 2: 17 3: %about% 4: 2025-03-14 18:51:57
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:144 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#844db_collegesearch_new1.22ms

select * from `meta_tags` where `slug` = 'colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews 1: active
Backtrace	app/Http/Controllers/CollegeController.php:844 app/Http/Controllers/CollegeController.php:156 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_new950μsselect * 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: 25InstituteProgram.php#?
App\Models\Program: 23Program.php#?
App\Models\InstituteProgramPlacement: 17InstituteProgramPlacement.php#?
App\Models\InstituteImage: 10InstituteImage.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Course: 2Course.php#?
App\Models\InstituteProgramExamMapping: 2InstituteProgramExamMapping.php#?
App\Models\Institute: 1Institute.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteContent: 1InstituteContent.php#?
App\Models\Admin: 1Admin.php#?
App\Models\InstituteProgramFeesSummary: 1InstituteProgramFeesSummary.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: aMJGsH4qecISd8HJ3Ilsznlj3SkX2pZaRl3LtcMN
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/st-johns-medical-college-sj-medical-...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews

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 => "course_id=30; course_name=Fashion%20Design%20-%20UG; XSRF-TOKEN=eyJpdiI6IlJLR05CWnpFSlFTdTlqdU1tRjhKV1E9PSIsInZhbHVlIjoiekhvdS9aNjI0VFhqZnkwT2hLaVpHbXdYVVdOdWJ5a3UwNVVLR2hOOTZTeHA0NDFsVVNUUHdJUDJPK1B4YWxnSjRRakdDWHJvS0xxc3Q4MzFGV29GRVlYY3lEL2xYd3JGS3FQOTk3aFNTUHl2c3JJSU5OQk0wSW53ZnkrLzJIS0oiLCJtYWMiOiJlNGRhMGQyOTE1NDEyNWU3NWI0MDE3ZGQyZGIwMWM1MGU2YzgzZDU3YzFhMDdmZmYxZGYyNzE3ZTY0NmNmZjFhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Ink4V1hrZXpXNU1zZ05YTnBrWVE1aXc9PSIsInZhbHVlIjoiYVhrZFlyU0pmMHVLV2pDbGdkaXVOSEpadVIwVjhvMlBuaXBXT3hJZUpXOHl5NmYzT29aQjl4bzlJTWlzTzVUbFdDTENkckxMMy91N3g2cnpVcUEzY2xoRGV4NUZiMWtDamdpOXBJaEtSUU5GMFFiMnRESmxrWjN4YzJuNmVacmUiLCJtYWMiOiI4YTQ1OTE0MzU3MjMxOGExYWYwNTk2ODMyMTU0YmE0YTM1MzgxZDE5YjVjNDU4NThjNWI4YzNkNjYzNmVjODViIiwidGFnIjoiIn0%3D; viewed_colleges=%5B2207%2C3599%2C445%2C986%2C2305%2C11347%2C10207%2C10811%2C12041%2C11790%2C4049%2C14795%5D ◀course_id=30; course_name=Fashion%20Design%20-%20UG; XSRF-TOKEN=eyJpdiI6IlJLR05CWnpFSlFTdTlqdU1tRjhKV1E9PSIsInZhbHVlIjoiekhvdS9aNjI0VFhqZnkwT2hLaVpHbXdYVVdOdWJ5 ▶"
  ]
  "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 [▼
  "course_id" => "30"
  "course_name" => "Fashion Design - UG"
  "XSRF-TOKEN" => "aMJGsH4qecISd8HJ3Ilsznlj3SkX2pZaRl3LtcMN"
  "laravel_session" => "j8HMZptJ6yqzecl9NdR5fOAmdcYuCwbfoTgXpJMX"
  "viewed_colleges" => "[2207,3599,445,986,2305,11347,10207,10811,12041,11790,4049,14795]"
]

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 => "Fri, 14 Mar 2025 18:51:57 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1IeVd6aFJWQjV0UnlvaUxxWFB5L1E9PSIsInZhbHVlIjoiSVFxTFpKQ3BoOGowUFVycHhjQWtjeG8vVElOTGcwUlhyaDFWdEVKQ0ovZjRSM0RVOWE5dmR2SjduMzZPZnhHSWpnRmNMbWJqb1Q0VExtT1dCQUVZdVduSjFkSFphUFhhdkJrcFZZMVd6ejIzMHhlbVRXRnVXRFl0SDljS1h6K3oiLCJtYWMiOiI0MjgwMTBkMzYwYjAxZDQxNjE4YjNkNzEyMTliZjZlYjYxMDdjMTNlNDAyYjFlM2I5ODc3YTM2ZmRhZjQ2YmVkIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 20:51:57 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik1IeVd6aFJWQjV0UnlvaUxxWFB5L1E9PSIsInZhbHVlIjoiSVFxTFpKQ3BoOGowUFVycHhjQWtjeG8vVElOTGcwUlhyaDFWdEVKQ0ovZjRSM0RVOWE5dmR2SjduMzZPZnhHSWpnRmNMb ▶"
    1 => "laravel_session=eyJpdiI6ImhTamdJbTl1a05CZGVzR2NLVjRTSkE9PSIsInZhbHVlIjoiQ0p6cDR3OUxlZFY4TllYbmJya0lVdThDbk9CdG5pSUNVbHVlT0FwaHVhNk9waHZOc1dHTmxzdndKN1Jiekx1T0xQVFg5K3FsL0hQUnl3QTJxVkNPSy9Pait2ejdLZ2t5djNxb1JtQ01WQzkwUUtDVU16RkxWWUpUOEZwc1pEUm8iLCJtYWMiOiI3YTE4YzJlMDk2OTgzNWQ0YmFmMWQxOTY0MzFlODMyYzg1Y2ZiZWFmNzY3OWRlMjI1MDc0M2Y5MTUyMWE0ZjAwIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 20:51:57 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImhTamdJbTl1a05CZGVzR2NLVjRTSkE9PSIsInZhbHVlIjoiQ0p6cDR3OUxlZFY4TllYbmJya0lVdThDbk9CdG5pSUNVbHVlT0FwaHVhNk9waHZOc1dHTmxzdndKN1Jiekx1T0xQ ▶"
    2 => "viewed_colleges=%5B2207%2C3599%2C445%2C986%2C2305%2C11347%2C10207%2C10811%2C12041%2C11790%2C4049%2C14795%2C2389%5D; expires=Sun, 13 Apr 2025 18:51:57 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax ◀viewed_colleges=%5B2207%2C3599%2C445%2C986%2C2305%2C11347%2C10207%2C10811%2C12041%2C11790%2C4049%2C14795%2C2389%5D; expires=Sun, 13 Apr 2025 18:51:57 GMT; Max-A ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1IeVd6aFJWQjV0UnlvaUxxWFB5L1E9PSIsInZhbHVlIjoiSVFxTFpKQ3BoOGowUFVycHhjQWtjeG8vVElOTGcwUlhyaDFWdEVKQ0ovZjRSM0RVOWE5dmR2SjduMzZPZnhHSWpnRmNMbWJqb1Q0VExtT1dCQUVZdVduSjFkSFphUFhhdkJrcFZZMVd6ejIzMHhlbVRXRnVXRFl0SDljS1h6K3oiLCJtYWMiOiI0MjgwMTBkMzYwYjAxZDQxNjE4YjNkNzEyMTliZjZlYjYxMDdjMTNlNDAyYjFlM2I5ODc3YTM2ZmRhZjQ2YmVkIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 20:51:57 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ik1IeVd6aFJWQjV0UnlvaUxxWFB5L1E9PSIsInZhbHVlIjoiSVFxTFpKQ3BoOGowUFVycHhjQWtjeG8vVElOTGcwUlhyaDFWdEVKQ0ovZjRSM0RVOWE5dmR2SjduMzZPZnhHSWpnRmNMb ▶"
    1 => "laravel_session=eyJpdiI6ImhTamdJbTl1a05CZGVzR2NLVjRTSkE9PSIsInZhbHVlIjoiQ0p6cDR3OUxlZFY4TllYbmJya0lVdThDbk9CdG5pSUNVbHVlT0FwaHVhNk9waHZOc1dHTmxzdndKN1Jiekx1T0xQVFg5K3FsL0hQUnl3QTJxVkNPSy9Pait2ejdLZ2t5djNxb1JtQ01WQzkwUUtDVU16RkxWWUpUOEZwc1pEUm8iLCJtYWMiOiI3YTE4YzJlMDk2OTgzNWQ0YmFmMWQxOTY0MzFlODMyYzg1Y2ZiZWFmNzY3OWRlMjI1MDc0M2Y5MTUyMWE0ZjAwIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 20:51:57 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImhTamdJbTl1a05CZGVzR2NLVjRTSkE9PSIsInZhbHVlIjoiQ0p6cDR3OUxlZFY4TllYbmJya0lVdThDbk9CdG5pSUNVbHVlT0FwaHVhNk9waHZOc1dHTmxzdndKN1Jiekx1T0xQ ▶"
    2 => "viewed_colleges=%5B2207%2C3599%2C445%2C986%2C2305%2C11347%2C10207%2C10811%2C12041%2C11790%2C4049%2C14795%2C2389%5D; expires=Sun, 13-Apr-2025 18:51:57 GMT; path=/; secure; httponly ◀viewed_colleges=%5B2207%2C3599%2C445%2C986%2C2305%2C11347%2C10207%2C10811%2C12041%2C11790%2C4049%2C14795%2C2389%5D; expires=Sun, 13-Apr-2025 18:51:57 GMT; path= ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "aMJGsH4qecISd8HJ3Ilsznlj3SkX2pZaRl3LtcMN"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-14 18:51:57	GET	/colleges/st-johns-medical-college-sj-medical-college-bangalore/reviews	15 43 91

Check St Johns Medical College, Bangalore Student's and Alumni reviews

Student's Rating for St Johns Medical College, Bangalore

Student's Reviews for St Johns Medical College, Bangalore

Gallery

Contact Details

1 x Application (95.14%)	182ms
1 x Booting (4.86%)	9.32ms