Join CollegeSearch Family

Register & enjoy the perks of a Universal College Application, Easy Process, Time-saving, and Free Contact details and Brochures.

20 Lakhs+

Monthly Users

1.75 Lakh+

Monthly Applications

30K +

Admissions

info@collegesearch.in +91 92281 51258

Popular Colleges by Branches

MBA/PGDM MCA B.Tech / B.E B.Sc BCA BBA B.COM

Trending Search

Top MBA Colleges in Delhi/NCR

Top MBA Colleges in Bangalore

Top Engineering Colleges in Delhi/NCR

Top Engineering Colleges in Bangalore

No Result Found

T John College of Pharmacy, Bangalore

Private College

T John College of Pharmacy, Bangalore

Item: T John College of Pharmacy, Bangalore
Rating: 4
Author: BISMA PARVAIZ

Bangalore, Karnataka
ESTD 2004

Shortlist

Brochure

+10 Photos & Videos

CollegeSearch Team T John College of Pharmacy

T John College of Pharmacy, Bangalore Highlights 2025

Particular	Details
Year of establishment	2004
Approval	AICTE
Exams accepted	KCET
Website	T John College of Pharmacy
Total Number of courses offered	2 Courses

T John College of Pharmacy , Bangalore Popular Courses

4.4

Bachelor of Pharmacy

1 Courses
4 Years

Total Fees

₹ 4,75,000

Highest Package

Admission 2024 View Brochure

T John College of Pharmacy B.Pharm Applications Open

Apply Now

4.4

Master of Pharmacy

1 Courses
2 Years

Total Fees

₹ 2,06,000

Highest Package

Admission 2024 View Brochure

T John College of Pharmacy M.Pharm Applications Open

Apply Now

View All 2 Courses >

Student's Rating for T John College of Pharmacy , Bangalore

Student Reviews & Ratings

4.4/5

85% Positive reviews

Component Ratings

Faculty Rating

4.6

Internship/Placement Rating

4.3

Infrastructure Rating

4.9

Canteen Rating

4.9

Hostel/Dorm Rating

3.9

College Fest Rating

4.9

Fashion Rating

4.4

Sports Rating

3.6

Write a Review >

Student's Reviews for T John College of Pharmacy , Bangalore

Placement

Faculty

Admissions

14-09-2017

Aamir Hussain Naikoo
Student

5.0 Canteen

5.0 Infrastructure

2.0 Sports

4.5 Events

4.0 Society / Clubs

4.5 Bus/Travel

4.0 PG

5.0 Hostel

4.0 Internship/Placement

5.0 Faculty

0.5 Exam/Admission

one of the best college in bengaluru...

Placement: So many companies are visiting during the final year for selecting the students in there companies..
Faculty: Mr. Ranjit sir... Because of hardworking he is doing to maintain the all necessities of college...
College: I have done my b.pharma from this college during the session 2013-17. I have no words to speak about this college ...I love this college, the faculty members of this college, and all the non teaching staff members....at last I will say I miss my college and oll the members of this college...
Exam: Based on School / 12th Class Result

Read Full Review

Was this Review Helpful?

05-06-2017

Sindhu.R
B.pharma Student

4.5 Canteen

5.0 Infrastructure

4.0 Sports

5.0 Events

4.5 Society / Clubs

4.5 Bus/Travel

4.0 PG

4.5 Hostel

4.0 Internship/Placement

5.0 Faculty

4.0 Exam/Admission

T.John college of pharmacy review

Placement: It is mandatory to complete the internship in any pharmacies or of industries.
Faculty: My favorite teacher is Dr.Panner selvam..It is because the way he teaches appears in front of the eyes when he is teaching..and also very skillful.
College: This is the place where we can be educated to the peak with great knowledge and skills...hope this the right place to be in this age..
Exam: Based on School / 12th Class Result

Read Full Review

Was this Review Helpful?

14-09-2017

Aamir Hussain Naikoo
Student

5.0 Canteen

5.0 Infrastructure

2.0 Sports

4.5 Events

4.0 Society / Clubs

4.5 Bus/Travel

4.0 PG

5.0 Hostel

4.0 Internship/Placement

5.0 Faculty

0.5 Exam/Admission

one of the best college in bengaluru...

Faculty: Mr. Ranjit sir... Because of hardworking he is doing to maintain the all necessities of college...
Placement: So many companies are visiting during the final year for selecting the students in there companies..
College: I have done my b.pharma from this college during the session 2013-17. I have no words to speak about this college ...I love this college, the faculty members of this college, and all the non teaching staff members....at last I will say I miss my college and oll the members of this college...
Exam: Based on School / 12th Class Result

Read Full Review

Was this Review Helpful?

05-06-2017

Sindhu.R
B.pharma Student

4.5 Canteen

5.0 Infrastructure

4.0 Sports

5.0 Events

4.5 Society / Clubs

4.5 Bus/Travel

4.0 PG

4.5 Hostel

4.0 Internship/Placement

5.0 Faculty

4.0 Exam/Admission

T.John college of pharmacy review

Faculty: My favorite teacher is Dr.Panner selvam..It is because the way he teaches appears in front of the eyes when he is teaching..and also very skillful.
Placement: It is mandatory to complete the internship in any pharmacies or of industries.
College: This is the place where we can be educated to the peak with great knowledge and skills...hope this the right place to be in this age..
Exam: Based on School / 12th Class Result

Read Full Review

Was this Review Helpful?

14-09-2017

Aamir Hussain Naikoo
Student

5.0 Canteen

5.0 Infrastructure

2.0 Sports

4.5 Events

4.0 Society / Clubs

4.5 Bus/Travel

4.0 PG

5.0 Hostel

4.0 Internship/Placement

5.0 Faculty

0.5 Exam/Admission

one of the best college in bengaluru...

Exam: Based on School / 12th Class Result
Placement: So many companies are visiting during the final year for selecting the students in there companies..
Faculty: Mr. Ranjit sir... Because of hardworking he is doing to maintain the all necessities of college...
College: I have done my b.pharma from this college during the session 2013-17. I have no words to speak about this college ...I love this college, the faculty members of this college, and all the non teaching staff members....at last I will say I miss my college and oll the members of this college...

Read Full Review

Was this Review Helpful?

05-06-2017

Sindhu.R
B.pharma Student

4.5 Canteen

5.0 Infrastructure

4.0 Sports

5.0 Events

4.5 Society / Clubs

4.5 Bus/Travel

4.0 PG

4.5 Hostel

4.0 Internship/Placement

5.0 Faculty

4.0 Exam/Admission

T.John college of pharmacy review

Exam: Based on School / 12th Class Result
Placement: It is mandatory to complete the internship in any pharmacies or of industries.
Faculty: My favorite teacher is Dr.Panner selvam..It is because the way he teaches appears in front of the eyes when he is teaching..and also very skillful.
College: This is the place where we can be educated to the peak with great knowledge and skills...hope this the right place to be in this age..

Read Full Review

Was this Review Helpful?

View All 7 Reviews

Gallery

10 Images

Campus

Library

Computer lab

Lab

Other

Library

Campus

Show All Images & Videos >

Contact Details

Address

T. John College of Pharmacy, Gottigere post, Bannerghatta Road, Bangalore - 560083, Bangalore, Karnataka, 560083

College Contact

080 - 40XXXXXX08

tjxxxal@xxxom

Get Contact Details

T John College of Pharmacy , Bangalore

4.4/5 (7 reviews)

Shortlist

Brochure

View Contact Details

4.4/5

7 Ratings

Enquire College

Brochure

Retry Again >

Successfully Logged in

T John College of Pharmacy, Bangalore

Popular Searches

Popular Colleges/Universities

LPU (Lovely Professional University), Jalandhar Amity University, Noida Chandigarh University (CU), Chandigarh Indian Institute of Management (IIM), Bangalore Indian Institute of Technology, Delhi Ajeenkya DY Patil University Powered by Sunstone

Top Colleges by Courses

Top Engineering Colleges in India Top MBA/PGDM Colleges in India Top MCA Colleges in India Top BCA Colleges in India Top BBA Colleges in India Top Msc Colleges in India Top Bsc Colleges in India

Top Exams

JEE Main JEE Advanced CAT CUET SNAP XAT KCET

Top Courses

BTech MBA BBA BCA BCom MCA BSc

Top Boards

CBSE 12th Board CBSE 10th Board UP 12th Board Punjab 12th Board West Bengal 12th Board Maharashtra 12th Board

Messages1 Timeline Exceptions Views26 Route Queries61 Models69 Mails Gate Session Request

Request history8.3.19602ms4MBGET colleges/{slug}

warninglog[17:07:44] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (7.48ms)time
Application (594ms)time
1 x Application (98.76%)
594ms
1 x Booting (1.24%)
7.48ms

26 templates were rendered

pages.college_v2.indexindex.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
pages.college_v2.partials.navbarnavbar.blade.php#?blade
pages.college_v2.partials.popular_programpopular_program.blade.php#?blade
pages.college_v2.partials.admission_datesadmission_dates.blade.php#?blade
pages.college_v2.partials.cutoffcutoff.blade.php#?blade
pages.college_v2.partials.placementplacement.blade.php#?blade
pages.college_v2.partials.rankingranking.blade.php#?blade
pages.college_v2.partials.course_and_feecourse_and_fee.blade.php#?blade
pages.college_v2.partials.scholarshipscholarship.blade.php#?blade
pages.college_v2.partials.gallerygallery.blade.php#?blade
pages.college_v2.partials.facultyfaculty.blade.php#?blade
pages.college_v2.partials.awards_v2awards_v2.blade.php#?blade
pages.college_v2.partials.alumnialumni.blade.php#?blade
pages.college_v2.partials.partnershippartnership.blade.php#?blade
pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
pages.college_v2.partials.deatailed_review_sectiondeatailed_review_section.blade.php#?blade
pages.college_v2.partials.contactcontact.blade.php#?blade
pages.college_v2.partials.right_side_clgright_side_clg.blade.php#?blade
pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
partials.footerfooter.blade.php#?blade
pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade

uri: GET colleges/{slug}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfile
namespace
prefix
where
as: cp.collegeinfo
file: app/Http/Controllers/CollegeController.php:39-713

61 statements were executed, 13 of which were duplicates, 48 unique. Show only duplicated449ms

Connection Establisheddb_collegesearchCacheService.php#460

Backtrace

13. app/Service/CacheService.php:460
14. app/Service/CacheService.php:446
15. middleware::softRedirects:76
16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
17. middleware::crossAppSync:53

select * from `seo_redirects` where `redirect_from` = '/colleges/t-john-college-of-pharmacy-bangalore' and `status` = 1 limit 1

9.7msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/t-john-college-of-pharmacy-bangalore 1: 1
Backtrace	15. app/Service/CacheService.php:460 16. app/Service/CacheService.php:446 17. middleware::softRedirects:76 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 19. middleware::crossAppSync:53

select `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 't-john-college-of-pharmacy-bangalore') limit 1

1.27msdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: t-john-college-of-pharmacy-bangalore
Backtrace	15. app/Http/Controllers/CollegeController.php:52 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institutes`.*, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `campus_videos` where `institutes`.`id` = `campus_videos`.`institute_id` limit 1) as `campus_video_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` = 'info') as `institute_faqs_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institute_insights` where `institutes`.`id` = `institute_insights`.`institute_id` and `status` = 'Y' and `institute_insights`.`deleted_at` is null) as `insights_count`, (select count(*) from `institute_toc` where `institutes`.`id` = `institute_toc`.`institute_id` and `institute_toc`.`deleted_at` is null) as `toc_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institute_impressions_data` where `institutes`.`id` = `institute_impressions_data`.`institute_id` and `location` = 'college_profile' and `date` > '2025-03-09 17:07:44') as `institute_impressions_data_count`, (select count(*) from `requests_new` where `institutes`.`id` = `requests_new`.`institute_id`) as `requests_new_count`, (select count(*) from `student_status` where `institutes`.`id` = `student_status`.`institute_id` and `status` = 'admitted') as `student_status_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `ics_link_2` = 't-john-college-of-pharmacy-bangalore' and `status` = 'Active' limit 1

172msdb_collegesearchCollegeController.php#239

Bindings	0: info 1: Y 2: 43 3: 4: 5: 0 6: 7: 0 8: Alumni 9: 10: college_profile 11: 2025-03-09 17:07:44 12: admitted 13: t-john-college-of-pharmacy-bangalore 14: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:239 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_courses`.*, (select count(*) from `institute_courses` as `laravel_reserved_2` where `institute_courses`.`course_type` = `laravel_reserved_2`.`course_type` and `institute_id` = 17163) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (17163) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6

3.72msdb_collegesearchCollegeController.php#239

Bindings	0: 17163 1: active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `sub_course` where `sub_course`.`id` in (11, 14)

1.19msdb_collegesearchCollegeController.php#239

Bindings	0: 11 1: 14
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `course_type` where `course_type`.`id` in (11, 14)

880μsdb_collegesearchCollegeController.php#239

Bindings	0: 11 1: 14
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `ranks` where `ranks`.`course_type` in (11, 14) and `institute_id` = 17163 order by `year` desc

630μsdb_collegesearchCollegeController.php#239

Bindings	0: 17163
Backtrace	30. app/Http/Controllers/CollegeController.php:239 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (39711, 39712) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

840μsdb_collegesearchCollegeController.php#239

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:239 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_id`, `name`, `first_page`, `title`, `doc_type` from `document` where `document`.`institute_id` in (17163)

960μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` in (17163) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc

2.13msdb_collegesearchCollegeController.php#239

Bindings	0: active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_insights` where `institute_insights`.`institute_id` in (17163) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

870μsdb_collegesearchCollegeController.php#239

Bindings	0: Y
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_toc` where `institute_toc`.`institute_id` in (17163) and `institute_toc`.`deleted_at` is null order by `id` desc

18.82msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `images` where `images`.`institute_id` in (17163) and `student_featured` = 0 and `images`.`deleted_at` is null order by case when (is_featured = 1) then 0 when (category = 'campus') then 2 else 3 end, id desc

5.84msdb_collegesearchCollegeController.php#239

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_id`, `video`, `description` from `video_verdict` where `video_verdict`.`institute_id` in (17163) and `status` = '1' order by `id` desc

900μsdb_collegesearchCollegeController.php#239

Bindings	0: 1
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `campus_videos` where `campus_videos`.`institute_id` in (17163) order by `id` desc limit 1

700μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `states` where `states`.`StateID` in (79)

1.13msdb_collegesearchCollegeController.php#239

Bindings	0: 79
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `user_reviews`.`institute_id` in (17163) and `status` = 'Active' limit 10

1.9msdb_collegesearchCollegeController.php#239

Bindings	0: Active
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (30276, 30479, 30480, 30481, 34323, 34324, 38880) order by `vote_up` desc

910μsdb_collegesearchCollegeController.php#239

Backtrace

25. app/Http/Controllers/CollegeController.php:239
26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (17163) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc

900μsdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (17163) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc, `year` desc

1.42msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` in (17163) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

1.27msdb_collegesearchCollegeController.php#239

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:239 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select session_user_id , institute_id , date_format(ADDTIME(last_modified, '5:30'),'%D %M, %Y') as last_modifi from `admin_reporting` where `admin_reporting`.`institute_id` in (17163) order by `ID` desc limit 1

1.79msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (17163)

1.26msdb_collegesearchCollegeController.php#239

Backtrace

20. app/Http/Controllers/CollegeController.php:239
21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 17163 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc

28.57msdb_collegesearchCollegeController.php#246

Bindings	0: 17163 1: admission
Backtrace	14. app/Http/Controllers/CollegeController.php:246 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id` from `institute_courses` where `institute_id` = 17163

2.45msdb_collegesearchCollegeController.php#248

Bindings	0: 17163
Backtrace	13. app/Http/Controllers/CollegeController.php:248 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 17163 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc

36.15msdb_collegesearchCollegeController.php#250

Bindings	0: 17163 1: cutoff
Backtrace	14. app/Http/Controllers/CollegeController.php:250 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `cutoff_new_shagun_json` where `institute_course_id` in (39711, 39712) and (`round_id` = 1 and `status` = 1)

9.28msdb_collegesearchCollegeController.php#268

Bindings	0: 39711 1: 39712 2: 1 3: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:268 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select top_recruiter.name,ro.name as org_name,ri.name as industry_name , rc.city_name ,image, webp_image from top_recruiter
left JOIN recruiter_organization ro on top_recruiter.recuiter_organization_id = ro.id
left JOIN recruiter_industry ri on top_recruiter.recuiter_industry_id = ri.id
left JOIN city rc on top_recruiter.city_id = rc.id WHERE top_recruiter.id IN (3263,5597,2678,1638,1265,930,1324,3605,null,null,null) limit 12

5.21msdb_collegesearchCollegeController.php#297

Backtrace

10. app/Http/Controllers/CollegeController.php:297
11. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
12. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
13. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
14. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id` from `institute_courses` where `institute_id` = 17163

1.07msdb_collegesearchCollegeController.php#316

Bindings	0: 17163
Backtrace	13. app/Http/Controllers/CollegeController.php:316 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `h_package`, `l_package`, `a_package`, `ic`.`id`, `ic`.`course_type`, `ct`.`alternate_name` as `ctype`, `year_placement` from `placement_course` left join `institute_courses` as `ic` on `ic`.`id` = `placement_course`.`institute_course_id` left join `course_type` as `ct` on `ct`.`id` = `ic`.`course_type` where `institute_course_id` in (39711, 39712) and `placement_course`.`deleted_at` is null order by `year_placement` desc

940μsdb_collegesearchCollegeController.php#325

Bindings	0: 39711 1: 39712
Backtrace	14. app/Http/Controllers/CollegeController.php:325 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 17163 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc

33.73msdb_collegesearchCollegeController.php#342

Bindings	0: 17163 1: placement
Backtrace	14. app/Http/Controllers/CollegeController.php:342 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_insights` where `institute_id` = 17163 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

3.12msdb_collegesearchCollegeController.php#345

Bindings	0: 17163 1: key_highlights_placement 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:345 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 17163 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc

26.31msdb_collegesearchCollegeController.php#351

Bindings	0: 17163 1: ranking
Backtrace	14. app/Http/Controllers/CollegeController.php:351 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select (SUM(CASE WHEN (overall_rating = '5.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS excellent_count,
(SUM(CASE WHEN (overall_rating = '4.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS good_count,
(SUM(CASE WHEN (overall_rating = '3.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS average_count,
(SUM(CASE WHEN (overall_rating = '2.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS bad_count,
(SUM(CASE WHEN (overall_rating = '1.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS worst_count,
(SUM(CASE WHEN status = 'Rejected' THEN 1 ELSE 0 END)) AS rejected_review,
(SUM(CASE WHEN (fashion_rating >0 AND fashion_rating != '' AND status = 'Active') THEN fashion_rating ELSE 0 END)) AS fashion_review_average,
(SUM(CASE WHEN (sports_rating >0 AND sports_rating != '' AND status = 'Active') THEN sports_rating ELSE 0 END)) AS sports_review_average,
(SUM(CASE WHEN (event_rating >0 AND event_rating != '' AND status = 'Active') THEN event_rating ELSE 0 END)) AS event_review_average,
(SUM(CASE WHEN (hostel_rating >0 AND hostel_rating != '' AND status = 'Active') THEN hostel_rating ELSE 0 END)) AS hostel_review_average,
(SUM(CASE WHEN (canteen_rating >0 AND canteen_rating != '' AND status = 'Active') THEN canteen_rating ELSE 0 END)) AS canteen_review_average,
(SUM(CASE WHEN (infra_rating >0 AND status = 'Active') THEN infra_rating ELSE 0 END)) AS infra_review_average,
(SUM(CASE WHEN (intern_rating >0 AND status = 'Active') THEN intern_rating ELSE 0 END)) AS intern_review_average,
(SUM(CASE WHEN (teacher_rating >0 AND status = 'Active') THEN teacher_rating ELSE 0 END)) AS teacher_review_average,
(SUM(CASE WHEN (admission_rating >0 AND status = 'Active') THEN admission_rating ELSE 0 END)) AS admission_review_average,
(SUM(CASE WHEN (infra_rating > 0 AND infra_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS infra_review_count,
(SUM(CASE WHEN (intern_rating > 0 AND intern_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS intern_review_count,
(SUM(CASE WHEN (admission_rating > 0 AND admission_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS admission_review_count,
(SUM(CASE WHEN (teacher_rating > 0 AND teacher_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS teacher_rating_count,
(SUM(CASE WHEN (fashion_rating > 0 AND fashion_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS fashion_review_count,
(SUM(CASE WHEN (sports_rating > 0 AND sports_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS sports_review_count,
(SUM(CASE WHEN (event_rating > 0 AND event_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS event_review_count,
(SUM(CASE WHEN (hostel_rating > 0 AND hostel_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS hostel_review_count,
(SUM(CASE WHEN (canteen_rating > 0 AND canteen_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS canteen_review_count from `user_reviews` where `institute_id` = 17163

2.77msdb_collegesearchCollegeController.php#388

Bindings	0: 17163
Backtrace	14. app/Http/Controllers/CollegeController.php:388 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 17163 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 11 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

3.5msdb_collegesearchCollegeController.php#415

Bindings	0: Active 1: 17163 2: 3: 4: 11
Backtrace	14. app/Http/Controllers/CollegeController.php:415 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (34324, 38880) order by `vote_up` desc

1.13msdb_collegesearchCollegeController.php#415

Backtrace

19. app/Http/Controllers/CollegeController.php:415
20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 17163 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 11 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

2.45msdb_collegesearchCollegeController.php#433

Bindings	0: Active 1: 17163 2: 3: 4: 11
Backtrace	14. app/Http/Controllers/CollegeController.php:433 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (34324, 38880) order by `vote_up` desc

1.13msdb_collegesearchCollegeController.php#433

Backtrace

19. app/Http/Controllers/CollegeController.php:433
20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 17163 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 11 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.65msdb_collegesearchCollegeController.php#451

Bindings	0: Active 1: 17163 2: 3: 4: 11
Backtrace	14. app/Http/Controllers/CollegeController.php:451 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (34324, 38880) order by `vote_up` desc

2.85msdb_collegesearchCollegeController.php#451

Backtrace

19. app/Http/Controllers/CollegeController.php:451
20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 17163 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.95msdb_collegesearchCollegeController.php#455

Bindings	0: 17163 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:455 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `metatags` where `PageID` = 'colleges/t-john-college-of-pharmacy-bangalore' and `status` = 'Y' limit 1

3.6msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/t-john-college-of-pharmacy-bangalore 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:549 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_faqs` where `institute_faqs`.`institute_id` = 17163 and `institute_faqs`.`institute_id` is not null

980μsdb_collegesearchCollegeController.php#613

Bindings	0: 17163
Backtrace	19. app/Http/Controllers/CollegeController.php:613 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `header_name` from `course_type` where `id` = 11 limit 1

720μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 11
Backtrace	15. app/Service/Breadcrumb.php:167 16. app/Service/Breadcrumb.php:37 17. app/Http/Controllers/CollegeController.php:631 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `id`, `is_sunstone` from `inst_campaign_bharat_2022` where `institute_id` = 17163 limit 1

2.56msdb_collegesearchCollegeController.php#637

Bindings	0: 17163
Backtrace	15. app/Http/Controllers/CollegeController.php:637 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `institute_courses`.`course_type`, `course_type`.`course_name`, `course_type`.`id`, `sub_course`.`sub_course_url` from `institute_courses` inner join `course_type` on `institute_courses`.`course_type` = `course_type`.`id` inner join `sub_course` on `institute_courses`.`course_type` = `sub_course`.`course_type_id` where `institute_id` = 17163 group by `course_type`.`id`

13.24msdb_collegesearchCollegeController.php#658

Bindings	0: 17163
Backtrace	14. app/Http/Controllers/CollegeController.php:658 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `inst_campaign_bharat_2022` where `institute_id` = 17163 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'

6.45msdb_collegesearchCollegeController.php#670

Bindings	0: 17163 1: 2025-04-09 2: 2025-04-09
Backtrace	14. app/Http/Controllers/CollegeController.php:670 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `institute_courses` where `institute_courses`.`institute_id` = 17163 and `institute_courses`.`institute_id` is not null limit 1

8.36msdb_collegesearchCollegeController.php#672

Bindings	0: 17163
Backtrace	21. app/Http/Controllers/CollegeController.php:672 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (144)

1.55msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:672
23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (144)

1.01msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:672
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (144)

860μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:693
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (144)

1.68msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:694
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (137)

3.36msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:693
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (137)

920μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:694
22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where modulename like '%cp-info%' and `module_link_id` = 17163 and `expiry_date` > '2025-04-09 17:07:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.61msdb_collegesearchhelpers.php#1695

Bindings	0: 17163 1: 2025-04-09 17:07:45
Backtrace	14. app/helpers.php:1695 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%exam%' and `module_link_id` in ('144', '137') and `expiry_date` > '2025-04-09 17:07:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.26msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 144 2: 137 3: 2025-04-09 17:07:45
Backtrace	14. app/helpers.php:1712 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('11', '14') and `expiry_date` > '2025-04-09 17:07:45' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

800μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 11 2: 14 3: 2025-04-09 17:07:45
Backtrace	14. app/helpers.php:1726 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `user_reviews` where `user_reviews`.`institute_id` = 17163 and `user_reviews`.`institute_id` is not null

1.84msdb_collegesearchhero_section.blade.php#27

Bindings	0: 17163
Backtrace	20. view::pages.college_v2.partials.hero_section:27 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 25. vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `user_reviews` where `user_reviews`.`institute_id` = 17163 and `user_reviews`.`institute_id` is not null

1.23msdb_collegesearchnavbar.blade.php#31

Bindings	0: 17163
Backtrace	19. view::pages.college_v2.partials.navbar:31 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `collaboration` where `collaboration`.`institute_id` = 17163 and `collaboration`.`institute_id` is not null

1.14msdb_collegesearchawards_v2.blade.php#2

Bindings	0: 17163
Backtrace	19. view::pages.college_v2.partials.awards_v2:2 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. vendor/laravel/framework/src/Illuminate/View/View.php:195

select `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp' and `brandings`.`deleted_at` is null

820μsdb_collegesearchhelpers.php#970

Bindings	0: cp
Backtrace	14. app/helpers.php:970 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 20. vendor/laravel/framework/src/Illuminate/View/View.php:195

App\Models\UserReview: 28UserReview.php#?
App\Models\Image: 10Image.php#?
App\Models\InstituteCourse: 9InstituteCourse.php#?
App\Models\UserReviewsVoteUp: 6UserReviewsVoteUp.php#?
App\Models\Criteria: 6Criteria.php#?
App\Models\CourseType: 3CourseType.php#?
App\Models\Institute: 2Institute.php#?
App\Models\SubCourse: 2SubCourse.php#?
App\Models\Document: 1Document.php#?
App\Models\State: 1State.php#?
App\Models\InstituteProfile: 1InstituteProfile.php#?

_token: GTTuEWnBS8is3pe1n2sESuELk5ocxnETSbQHIu5e
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/t-john-college-of-pharmacy-bangalore...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/t-john-college-of-pharmacy-bangalore

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 11:37:45 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRXd0FCMmQ3OUpENlEzQkdlV0NlK3c9PSIsInZhbHVlIjoiTHE2anNZeGszQjB0bXpxTlAvb1pKM242d0FtVmtqSmdoRE9LcFdkV1dxdVhjUW1ZUVhUOU5zQUNENSs4ck5kYk1vTGR2T0VyUW83UUM2RUx5WHIwNSsyWUJnODh4TjZPZjNvM1Myd1RXZ1JMZlRQdDVuVXZGcUhZeGJkTHZMUG4iLCJtYWMiOiIwNGUyMjNiN2U4NDM2ZDg1MjAyZWZkZTNkYjA3ZGI0NjU2MDg2YWVhNDEwN2EzYzg5MDE3Yjk5ZGVlNWY1OWNmIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 13:37:45 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlRXd0FCMmQ3OUpENlEzQkdlV0NlK3c9PSIsInZhbHVlIjoiTHE2anNZeGszQjB0bXpxTlAvb1pKM242d0FtVmtqSmdoRE9LcFdkV1dxdVhjUW1ZUVhUOU5zQUNENSs4ck5kYk1vTGR2T ▶"
    1 => "cs_dev_session=eyJpdiI6ImxJTnNjV3RmalRxNUxhRnhoSHUybkE9PSIsInZhbHVlIjoiUEc4bTUzY2hxYTdsc1o5dlFvWHNxN096UmtxUmtmRGhLcE9vWm9kenVWMmZoMVdaaE5oSklSY201clNEOTg4RS9ZZDFkTnoreksyV2Z4a0xxdkVYTFNBUGtFZUxiQkYyTzhoMWJJc2Y2cDZGZFFPV2pHQ0s5bGdoVzFReHorU08iLCJtYWMiOiI5ZWY1MTkzNTQxYTAzY2NiM2Q0NzQ1YTY1ODFjNDA5MTJjOGFmY2IzY2M4OGE4NTJlZjU2ZTgwNzE4NmU1NTVmIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 13:37:45 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6ImxJTnNjV3RmalRxNUxhRnhoSHUybkE9PSIsInZhbHVlIjoiUEc4bTUzY2hxYTdsc1o5dlFvWHNxN096UmtxUmtmRGhLcE9vWm9kenVWMmZoMVdaaE5oSklSY201clNEOTg4RS9ZZ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRXd0FCMmQ3OUpENlEzQkdlV0NlK3c9PSIsInZhbHVlIjoiTHE2anNZeGszQjB0bXpxTlAvb1pKM242d0FtVmtqSmdoRE9LcFdkV1dxdVhjUW1ZUVhUOU5zQUNENSs4ck5kYk1vTGR2T0VyUW83UUM2RUx5WHIwNSsyWUJnODh4TjZPZjNvM1Myd1RXZ1JMZlRQdDVuVXZGcUhZeGJkTHZMUG4iLCJtYWMiOiIwNGUyMjNiN2U4NDM2ZDg1MjAyZWZkZTNkYjA3ZGI0NjU2MDg2YWVhNDEwN2EzYzg5MDE3Yjk5ZGVlNWY1OWNmIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 13:37:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRXd0FCMmQ3OUpENlEzQkdlV0NlK3c9PSIsInZhbHVlIjoiTHE2anNZeGszQjB0bXpxTlAvb1pKM242d0FtVmtqSmdoRE9LcFdkV1dxdVhjUW1ZUVhUOU5zQUNENSs4ck5kYk1vTGR2T ▶"
    1 => "cs_dev_session=eyJpdiI6ImxJTnNjV3RmalRxNUxhRnhoSHUybkE9PSIsInZhbHVlIjoiUEc4bTUzY2hxYTdsc1o5dlFvWHNxN096UmtxUmtmRGhLcE9vWm9kenVWMmZoMVdaaE5oSklSY201clNEOTg4RS9ZZDFkTnoreksyV2Z4a0xxdkVYTFNBUGtFZUxiQkYyTzhoMWJJc2Y2cDZGZFFPV2pHQ0s5bGdoVzFReHorU08iLCJtYWMiOiI5ZWY1MTkzNTQxYTAzY2NiM2Q0NzQ1YTY1ODFjNDA5MTJjOGFmY2IzY2M4OGE4NTJlZjU2ZTgwNzE4NmU1NTVmIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 13:37:45 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6ImxJTnNjV3RmalRxNUxhRnhoSHUybkE9PSIsInZhbHVlIjoiUEc4bTUzY2hxYTdsc1o5dlFvWHNxN096UmtxUmtmRGhLcE9vWm9kenVWMmZoMVdaaE5oSklSY201clNEOTg4RS9ZZ ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "GTTuEWnBS8is3pe1n2sESuELk5ocxnETSbQHIu5e"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/t-john-college-of-pharmacy-bangalore"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 17:07:45	GET	/colleges/t-john-college-of-pharmacy-bangalore	1 26 61 69

1 x Application (98.76%)	594ms
1 x Booting (1.24%)	7.48ms