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

Som Lalit College, Ahmedabad

Private College

Som Lalit College, Ahmedabad

Item: Som Lalit College, Ahmedabad
Rating: 3
Author: Pratik turakhiya

Ahmedabad, Gujarat
ESTD 1996

Shortlist

Brochure

+6 Photos & Videos

Rachna Jha

Updated on 22nd November, 2022

Som Lalit College , Ahmedabad Highlights 2025

Som Lalit College Highlights

Particular	Detail
Type \| Establishment Year	Private \| 1996
Approval	AICTE
Affiliation	Gujarat Technological University
Admission mode	Online
Admission Criteria	Entrance Based
Accepted Entrance	CMAT
Courses Offered	MBA & PGDM
Highest CTC	INR 10 LPA
Average CTC	INR 5 LPA
Top Recruiters	Indigo, Axis Bank, ICICI, HDFC, Kotak, L & T, Adani, Oyo, Decathalon
Website	https://www.somlalitcollege.org/

Som Lalit College Courses

Som Lalit College offers management courses, that is 2-year MBA course in 3 different specializations, namely MBA general, MBA in Finance, and MBA in IT. Students who have completed graduation with a 50% aggregate can apply for MBA courses at Som Lalit Institute of Business Management.

Name of the Course	Eligibility	Seat Intake
MBA	Graduation with 50% aggregate (45% for SC/ST/OBC) + valid score in CMAT	180
MBA in Finance		60
MBA in IT		30

Som Lalit College , Ahmedabad Popular Courses

3.6

Master of Business Administration(MBA)

2 Courses
2 Years

Total Fees

Highest Package

Admission 2024 View Brochure

Som Lalit College MBA Applications Open

Apply Now

3.6

Bachelor of Business Administration (BBA)

1 Courses
3 Years

Total Fees

Highest Package

Admission 2024 View Brochure

Som Lalit College BBA Applications Open

Apply Now

3.6

Bachelor of Computer Application (BCA)

1 Courses
3 Years

Total Fees

Highest Package

Admission 2024 View Brochure

Som Lalit College BCA Applications Open

Apply Now

3.6

Bachelor of Commerce(B.Com.)

1 Courses
3 Years

Total Fees

Highest Package

Admission 2024 View Brochure

Som Lalit College B.Com Applications Open

Apply Now

View All 5 Courses >

Som Lalit College , Ahmedabad Admission 2024

Som Lalit College Admission 2024

Admission Mode at Som Lalit College is Online. Students must visit the official website of the college to apply for the MBA and PGDM courses online. Admission to these programs is determined by the entrance exams and candidates’ performance in the last qualifying examination.

Tabulated Below are the important details about the admission process:

Particulars	Details
Admission Mode	Online
Admission Criteria	Entrance based
Accepted Entrance Exams	CMAT
Application Fees	Rs 350

For more details about the admission process, read here Som Lalit College Admission

Admission Details for All Details >

Som Lalit College , Ahmedabad Placement Details

Som Lalit College Placements

Som Lalit College has a decent placement cell that works hard to help students land jobs in their dream companies. As per the college reports for 2022 sessions, the highest package offered was INR 10 LPA, with an average package of INR 5 LPA. 90+ recruiting companies visit the campus for placement opportunities.

Listed below are important details about the placements:

Particulars	Details
Highest Package	INR 10 LPA
Average Package	INR 5 LPA
Top Recruiters	Asian Paints, S&P Global, ICICI Bank/ICICI Prudential/ICICI Securities, MRF, Kotak Mahindra Bank, Nestle, Aditya Birla Fashion and Retail

Course Wise Highest Salary

Course Wise Avg Salary

Som Lalit College, Ahmedabad Top Recruiters

TCS

India today group

Mafatlal Industries Ltd

Radio Mirchi

JINDAL

Adani group

Bajaj Allianz

Bharti Airtel

Axis Bank

View All Recruiters Details

Som Lalit College Placement 2025 Sector-Wise Recruiters , Ahmedabad

Student's Rating for Som Lalit College , Ahmedabad

Student Reviews & Ratings

3.6/5

60% Positive reviews

Component Ratings

Faculty Rating

3.8

Internship/Placement Rating

3.9

Infrastructure Rating

2.9

Canteen Rating

3.8

Hostel/Dorm Rating

2.3

College Fest Rating

2.8

Fashion Rating

3.5

Sports Rating

Write a Review >

Student's Reviews for Som Lalit College , Ahmedabad

Placement

Faculty

Admissions

13-02-2017

Anonymous
PGDM Student

1.0 Canteen

2.0 Infrastructure

0.5 Sports

2.0 Events

1.5 Society / Clubs

4.0 Bus/Travel

3.5 PG

1.5 Hostel

3.5 Internship/Placement

2.5 Faculty

1.0 Exam/Admission

Review of son lalit institute of management studies

Placement: Not much U have to manage some of the things by yourself
Faculty: Two faculties are good Roopa mam and neha mam
College: Son lalit is known to be good college only for B.Com. There are several educational program is running in the college, PGDM is one of them. Except 2 facilities , all the other faculties are not good enough for the management. I can not recommend it.
Exam: State / National Entrance Exams, Group Discussion / Personal Interview

Read Full Review

Was this Review Helpful?

13-02-2017

Anonymous
PGDM Student

1.0 Canteen

2.0 Infrastructure

0.5 Sports

2.0 Events

1.5 Society / Clubs

4.0 Bus/Travel

3.5 PG

1.5 Hostel

3.5 Internship/Placement

2.5 Faculty

1.0 Exam/Admission

Review of son lalit institute of management studies

Faculty: Two faculties are good Roopa mam and neha mam
Placement: Not much U have to manage some of the things by yourself
College: Son lalit is known to be good college only for B.Com. There are several educational program is running in the college, PGDM is one of them. Except 2 facilities , all the other faculties are not good enough for the management. I can not recommend it.
Exam: State / National Entrance Exams, Group Discussion / Personal Interview

Read Full Review

Was this Review Helpful?

13-02-2017

Anonymous
PGDM Student

1.0 Canteen

2.0 Infrastructure

0.5 Sports

2.0 Events

1.5 Society / Clubs

4.0 Bus/Travel

3.5 PG

1.5 Hostel

3.5 Internship/Placement

2.5 Faculty

1.0 Exam/Admission

Review of son lalit institute of management studies

Exam: State / National Entrance Exams, Group Discussion / Personal Interview
Placement: Not much U have to manage some of the things by yourself
Faculty: Two faculties are good Roopa mam and neha mam
College: Son lalit is known to be good college only for B.Com. There are several educational program is running in the college, PGDM is one of them. Except 2 facilities , all the other faculties are not good enough for the management. I can not recommend it.

Read Full Review

Was this Review Helpful?

View All 5 Reviews

Contact Details

Address

SLIMS Campus, St. Xavier’s Corner, University Road, Navarangpura, Ahmedabad, Gujarat, 380009

College Contact

079 - 26XXXXXX03

inxxxfo@xxxrg

Get Contact Details

Som Lalit College , Ahmedabad

3.6/5 (5 reviews)

Shortlist

Brochure

Som Lalit College, Ahmedabad

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 Queries68 Models86 Mails Gate Session Request

Request history8.3.19721ms5MBGET colleges/{slug}

warninglog[01:56:52] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (9.73ms)time
Application (711ms)time
1 x Application (98.65%)
711ms
1 x Booting (1.35%)
9.73ms

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

68 statements were executed, 15 of which were duplicates, 53 unique. Show only duplicated440ms

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/som-lalit-college-ahmedabad' and `status` = 1 limit 1

9.66msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/som-lalit-college-ahmedabad 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 `ics_link_2` from `institutes` where `ics_link` = 'som-lalit-college-ahmedabad' and `status` = 'Active' limit 1

900μsdb_collegesearchCacheService.php#492

Bindings	0: som-lalit-college-ahmedabad 1: Active
Backtrace	15. app/Service/CacheService.php:492 16. app/Service/CacheService.php:478 17. middleware::softRedirects:88 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` = 'som-lalit-college-ahmedabad') limit 1

1.07msdb_collegesearchCollegeController.php#52

Bindings	0: Active 1: som-lalit-college-ahmedabad
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 01:56:52') 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` = 'som-lalit-college-ahmedabad' and `status` = 'Active' limit 1

231msdb_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 01:56:52 12: admitted 13: som-lalit-college-ahmedabad 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` = 1391) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (1391) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6

1.61msdb_collegesearchCollegeController.php#239

Bindings	0: 1391 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 (2, 7, 13, 236)

780μsdb_collegesearchCollegeController.php#239

Bindings	0: 2 1: 7 2: 13 3: 236
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 (2, 7, 13, 21)

850μsdb_collegesearchCollegeController.php#239

Bindings	0: 2 1: 7 2: 13 3: 21
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 (2, 7, 13, 21) and `institute_id` = 1391 order by `year` desc

570μsdb_collegesearchCollegeController.php#239

Bindings	0: 1391
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 (1258, 3390, 8548, 15985) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

910μ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 (1391)

710μ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 (1391) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc

990μsdb_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 (1391) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

750μ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 (1391) and `institute_toc`.`deleted_at` is null order by `id` desc

21.74msdb_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 (1391) 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

1.59msdb_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 (1391) and `status` = '1' order by `id` desc

2.09msdb_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 (1391) order by `id` desc limit 1

820μ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 (74)

630μsdb_collegesearchCollegeController.php#239

Bindings	0: 74
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 (1391) and `status` = 'Active' limit 10

1.06msdb_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 (29486, 31108, 41065, 48878, 64517) order by `vote_up` desc

1.38msdb_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 (1391) 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

1.15msdb_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 (1391) 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.12msdb_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 (1391) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

1.55msdb_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 (1391) order by `ID` desc limit 1

1.45msdb_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 `admin` where `admin`.`ID` in (189)

980μsdb_collegesearchCollegeController.php#239

Bindings	0: 189
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 `writers_profile` where `writers_profile`.`admin_id` in (189)

1.35msdb_collegesearchCollegeController.php#239

Bindings	0: 189
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 `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (1391)

1.13msdb_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` = 1391 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc

23.02msdb_collegesearchCollegeController.php#246

Bindings	0: 1391 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` = 1391

690μsdb_collegesearchCollegeController.php#248

Bindings	0: 1391
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` = 1391 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc

21.75msdb_collegesearchCollegeController.php#250

Bindings	0: 1391 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 (1258, 3390, 8548, 10810, 15985) and (`round_id` = 1 and `status` = 1)

6.01msdb_collegesearchCollegeController.php#268

Bindings	0: 1258 1: 3390 2: 8548 3: 10810 4: 15985 5: 1 6: 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 (1354,1145,3161,1416,128,650,697,1585,771) limit 12

3.72msdb_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` = 1391

1.43msdb_collegesearchCollegeController.php#316

Bindings	0: 1391
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 (1258, 3390, 8548, 10810, 15985) and `placement_course`.`deleted_at` is null order by `year_placement` desc

2.19msdb_collegesearchCollegeController.php#325

Bindings	0: 1258 1: 3390 2: 8548 3: 10810 4: 15985
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` = 1391 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc

19.95msdb_collegesearchCollegeController.php#342

Bindings	0: 1391 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` = 1391 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

900μsdb_collegesearchCollegeController.php#345

Bindings	0: 1391 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` = 1391 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc

17.05msdb_collegesearchCollegeController.php#351

Bindings	0: 1391 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` = 1391

2.84msdb_collegesearchCollegeController.php#388

Bindings	0: 1391
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` = 1391 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.14msdb_collegesearchCollegeController.php#415

Bindings	0: Active 1: 1391 2: 3: 4: 2
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 (29486) order by `vote_up` desc

2.1msdb_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` = 1391 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1.87msdb_collegesearchCollegeController.php#433

Bindings	0: Active 1: 1391 2: 3: 4: 2
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 (29486) order by `vote_up` desc

1msdb_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` = 1391 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2

1msdb_collegesearchCollegeController.php#451

Bindings	0: Active 1: 1391 2: 3: 4: 2
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 (29486) order by `vote_up` desc

810μsdb_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` = 1391 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.02msdb_collegesearchCollegeController.php#455

Bindings	0: 1391 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 count(*) as aggregate from `cutoff_new_shagun_json` left join `institute_courses` on `institute_courses`.`id` = `cutoff_new_shagun_json`.`institute_course_id` where `institute_id` = 1391

2.7msdb_collegesearchCollegeController.php#477

Bindings	0: 1391
Backtrace	15. app/Http/Controllers/CollegeController.php:477 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 `name` from `images` where `is_desktop` = 1 and `institute_id` = 1391 and `images`.`deleted_at` is null limit 1

790μsdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 1391
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:527 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `name` from `images` where `is_desktop` = 1 and `institute_id` = 1391 and `images`.`deleted_at` is null limit 1

1.08msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 1391
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:536 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select * from `metatags` where `PageID` = 'colleges/som-lalit-college-ahmedabad' and `status` = 'Y' limit 1

1.35msdb_collegesearchCollegeController.php#549

Bindings	0: colleges/som-lalit-college-ahmedabad 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` = 1391 and `institute_faqs`.`institute_id` is not null

850μsdb_collegesearchCollegeController.php#613

Bindings	0: 1391
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` = 2 limit 1

720μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 2
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` = 1391 limit 1

3.52msdb_collegesearchCollegeController.php#637

Bindings	0: 1391
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` = 1391 group by `course_type`.`id`

13.2msdb_collegesearchCollegeController.php#658

Bindings	0: 1391
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` = 1391 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'

1.43msdb_collegesearchCollegeController.php#670

Bindings	0: 1391 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` = 1391 and `institute_courses`.`institute_id` is not null limit 1

1.81msdb_collegesearchCollegeController.php#672

Bindings	0: 1391
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 (21,23)

2.32msdb_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 (21,23)

960μsdb_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`, `institute_name_2`, `inst_city`, `inst_state` from `institutes` where `id` = '107'

1.2msdb_collegesearchCollegeController.php#686

Bindings	0: 107
Backtrace	14. app/Http/Controllers/CollegeController.php:686 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`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (21,23)

730μ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 (21,23)

1.47msdb_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 (2010)

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 (2010)

660μ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` = 1391 and `expiry_date` > '2025-04-09 01:56:52' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

1.15msdb_collegesearchhelpers.php#1695

Bindings	0: 1391 1: 2025-04-09 01:56:52
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 ('21', '23', '2010') and `expiry_date` > '2025-04-09 01:56:52' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.13msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 21 2: 23 3: 2010 4: 2025-04-09 01:56:52
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 ('2', '7', '13', '21') and `expiry_date` > '2025-04-09 01:56:52' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

950μsdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 2 2: 7 3: 13 4: 21 5: 2025-04-09 01:56:52
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` = 1391 and `user_reviews`.`institute_id` is not null

1.54msdb_collegesearchhero_section.blade.php#27

Bindings	0: 1391
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` = 1391 and `user_reviews`.`institute_id` is not null

930μsdb_collegesearchnavbar.blade.php#31

Bindings	0: 1391
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` = 1391 and `collaboration`.`institute_id` is not null

860μsdb_collegesearchawards_v2.blade.php#2

Bindings	0: 1391
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

1.19msdb_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\InstituteCourse: 19InstituteCourse.php#?
App\Models\UserReview: 19UserReview.php#?
App\Models\Criteria: 10Criteria.php#?
App\Models\UserReviewsVoteUp: 8UserReviewsVoteUp.php#?
App\Models\Image: 6Image.php#?
App\Models\CourseType: 5CourseType.php#?
App\Models\InstituteToc: 5InstituteToc.php#?
App\Models\SubCourse: 4SubCourse.php#?
App\Models\Institute: 3Institute.php#?
App\Models\Document: 1Document.php#?
App\Models\State: 1State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\InstituteProfile: 1InstituteProfile.php#?
App\Models\MetaTag: 1MetaTag.php#?

_token: dQ5beR6YfGJqcy3pl0znq92VDgyN7k124scGU9hk
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/som-lalit-college-ahmedabad" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/som-lalit-college-ahmedabad

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 => "Tue, 08 Apr 2025 20:26:52 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJkRGNuNG5peTdoMExkb3d5S1RjaHc9PSIsInZhbHVlIjoiMHh1Y05IRlpoR1BGcmdpbHlXK1dWUk5jVUN4L2labWdvdG1ZSko2V3ZtOG5aS0RDbVVWOXZrVytKVG01NUg5VFV0Wi9laFhpUzVqKzRjWUxBSlNNNkNTdzJ0T0tLNGgzK1RBbUJSSG1wRzg4OEdkY0FjUC80MFJOME80Z3kvNkMiLCJtYWMiOiJmYzc5N2I3ZmMxNWE5NDgxYzhhYWNkMWE2MDA3NzI5YjVhMzcyZGY0MGU1YzBlZGZjOWQwMTdmM2JiMmViMDIwIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 22:26:52 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJkRGNuNG5peTdoMExkb3d5S1RjaHc9PSIsInZhbHVlIjoiMHh1Y05IRlpoR1BGcmdpbHlXK1dWUk5jVUN4L2labWdvdG1ZSko2V3ZtOG5aS0RDbVVWOXZrVytKVG01NUg5VFV0Wi9la ▶"
    1 => "cs_dev_session=eyJpdiI6InlUK2Zxb09EMUZCdmg4ODlUazZWV3c9PSIsInZhbHVlIjoiRm9FQ3hRdjVmdFBETnEwdkMzOUZqMVBLdEdLdFRXT0xCRjZhcmlETjc5NzZraFZRYzdqK2hKaTc0UzdCMDZiZ0lseDgrSkhOeUxmQmFmLzZsZUt3YWVaLzVtTlMyL2xlUEpxU2xPWmJicWgxSHBVS1lYUjlqdmJBaW9QOVJ1N00iLCJtYWMiOiI1NmViYzgxYmM1ZGIwYjY2MGI3ZDFlZTA3ZWEyZjljYzBlNWI4M2E5NTFkYjA1NmE0NzRiMGVlZTJhYzVjOTMzIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 22:26:52 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6InlUK2Zxb09EMUZCdmg4ODlUazZWV3c9PSIsInZhbHVlIjoiRm9FQ3hRdjVmdFBETnEwdkMzOUZqMVBLdEdLdFRXT0xCRjZhcmlETjc5NzZraFZRYzdqK2hKaTc0UzdCMDZiZ0lse ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJkRGNuNG5peTdoMExkb3d5S1RjaHc9PSIsInZhbHVlIjoiMHh1Y05IRlpoR1BGcmdpbHlXK1dWUk5jVUN4L2labWdvdG1ZSko2V3ZtOG5aS0RDbVVWOXZrVytKVG01NUg5VFV0Wi9laFhpUzVqKzRjWUxBSlNNNkNTdzJ0T0tLNGgzK1RBbUJSSG1wRzg4OEdkY0FjUC80MFJOME80Z3kvNkMiLCJtYWMiOiJmYzc5N2I3ZmMxNWE5NDgxYzhhYWNkMWE2MDA3NzI5YjVhMzcyZGY0MGU1YzBlZGZjOWQwMTdmM2JiMmViMDIwIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 22:26:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJkRGNuNG5peTdoMExkb3d5S1RjaHc9PSIsInZhbHVlIjoiMHh1Y05IRlpoR1BGcmdpbHlXK1dWUk5jVUN4L2labWdvdG1ZSko2V3ZtOG5aS0RDbVVWOXZrVytKVG01NUg5VFV0Wi9la ▶"
    1 => "cs_dev_session=eyJpdiI6InlUK2Zxb09EMUZCdmg4ODlUazZWV3c9PSIsInZhbHVlIjoiRm9FQ3hRdjVmdFBETnEwdkMzOUZqMVBLdEdLdFRXT0xCRjZhcmlETjc5NzZraFZRYzdqK2hKaTc0UzdCMDZiZ0lseDgrSkhOeUxmQmFmLzZsZUt3YWVaLzVtTlMyL2xlUEpxU2xPWmJicWgxSHBVS1lYUjlqdmJBaW9QOVJ1N00iLCJtYWMiOiI1NmViYzgxYmM1ZGIwYjY2MGI3ZDFlZTA3ZWEyZjljYzBlNWI4M2E5NTFkYjA1NmE0NzRiMGVlZTJhYzVjOTMzIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 22:26:52 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6InlUK2Zxb09EMUZCdmg4ODlUazZWV3c9PSIsInZhbHVlIjoiRm9FQ3hRdjVmdFBETnEwdkMzOUZqMVBLdEdLdFRXT0xCRjZhcmlETjc5NzZraFZRYzdqK2hKaTc0UzdCMDZiZ0lse ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "dQ5beR6YfGJqcy3pl0znq92VDgyN7k124scGU9hk"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/som-lalit-college-ahmedabad"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-09 01:56:52	GET	/colleges/som-lalit-college-ahmedabad	1 26 68 86

1 x Application (98.65%)	711ms
1 x Booting (1.35%)	9.73ms