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

St Andrews Institute of Technology and Management - SAITM, Gurgaon

Courses Fees

Private College

St Andrews Institute of Technology and Management - SAITM, Gurgaon Course and Fees

Gurgaon, Delhi NCR
ESTD 2012

Shortlist

Brochure

St Andrews Institute of Technology and Management - SAITM , Gurgaon Garden

St Andrews Institute of Technology and Management - SAITM , Gurgaon Gallery

St Andrews Institute of Technology and Management - SAITM, Gurgaon Reception

St Andrews Institute of Technology and Management - SAITM , Gurgaon Campus

+44 Photos & Videos

heeranshi

Updated on 20th March, 2023

St Andrews Institute of Technology and Management - SAITM, Gurgaon Courses and Fees Details

Hostel Fee for boys:-

Hostel Type	Fees (Lodging + Mess)
Double Sharing AC	1,20,000 INR
Triple Sharing AC	80,000 INR
Triple Sharing Non-AC	60,000 INR

Hostel fee for girls:-

Hostel Type	Fees (Lodging + Mess)
Double Sharing AC	1,00,000 INR
Triple Sharing AC	70,000 INR
Triple Sharing Non-AC	60,000 INR

Course	Total Fees
Bachelor of Technology (B.Tech) 4 Years \| Fulltime \| On Campus	₹ 3,68,000 Fees Details
Master of Business Administration(MBA) 2 Years \| Fulltime \| On Campus	₹ 2,50,000 Fees Details
Bachelor of Business Administration (BBA) 3 Years \| Fulltime \| On Campus	₹ 2,16,000 Fees Details
Bachelor of Computer Application (BCA) 3 Years \| Fulltime \| On Campus	₹ 2,16,000 Fees Details

St Andrews Institute of Technology and Management - SAITM , Gurgaon Courses

4.8

Bachelor of Technology (B.Tech)

4 Years

Total Fees

₹ 3,68,000

Highest Package

₹ 12 L.P.A

Admission 2024 View Brochure

St Andrews Institute of Technology and Management - SAITM B.Tech Applications Open

Apply Now

4.8

Master of Business Administration(MBA)

2 Years

Total Fees

₹ 2,50,000

Highest Package

₹ 12 L.P.A

Admission 2024 View Brochure

St Andrews Institute of Technology and Management - SAITM MBA Applications Open

Apply Now

4.8

Bachelor of Business Administration (BBA)

3 Years

Total Fees

₹ 2,16,000

Highest Package

₹ 12 L.P.A

Admission 2024 View Brochure

St Andrews Institute of Technology and Management - SAITM BBA Applications Open

Apply Now

4.8

Bachelor of Computer Application (BCA)

3 Years

Total Fees

₹ 2,16,000

Highest Package

₹ 12 L.P.A

Admission 2024 View Brochure

St Andrews Institute of Technology and Management - SAITM BCA Applications Open

Apply Now

St Andrews Institute of Technology and Management - SAITM, Gurgaon Top Recruiters

Dell

Amazon

Deloitte

Deutsche Bank

IBM

infosys

maruti suzuki

TCS

Wipro

Alcatel-Lucent

Accenture

Asian Paints

HONDA

Huawei

Volvo Eiocher

Bharat Sanchar Nigam Limited (BSNL)

Genpact

HDFC Bank

Hero Honda Motors

Capgemini

Tech Mahindra

L&T Ltd.

Apple

Wipro InfoTech

HCL

Safexpress

Calvin Klein

KUKA

BYJU’S

View All Recruiters Details

Student's Rating for St Andrews Institute of Technology and Management - SAITM , Gurgaon

Student Reviews & Ratings

4.8/5

96% Positive reviews

Component Ratings

Faculty Rating

4.8

Internship/Placement Rating

4.7

Infrastructure Rating

4.7

Canteen Rating

4.9

Hostel/Dorm Rating

4.6

College Fest Rating

4.6

Fashion Rating

4.5

Sports Rating

4.5

Write a Review >

Student's Reviews for St Andrews Institute of Technology and Management - SAITM , Gurgaon

Placement

Faculty

Admissions

11-01-2020

Deepa singh
B.Tech / B.E Student

4.0 Canteen

4.0 Infrastructure

4.0 Sports

4.0 Events

4.0 PG

4.0 Hostel

4.0 Internship/Placement

4.0 Faculty

REASON WHY I CHOSE THIS COLLEGE

Placement: Our college offers great placement opportunity in very good reputed companies like amazon,wipro,tech mahindra and many more with excellent package offers. My college offers approx 80-85% placement in the college.

Read Full Review

Was this Review Helpful?

11-01-2020

Upasana
B.Tech / B.E Student

4.0 Canteen

4.0 Infrastructure

4.5 Sports

3.5 Events

4.5 PG

4.5 Hostel

4.0 Internship/Placement

4.0 Faculty

The college is very good and a nice place to study

Placement: I got the internship opportunity from my college side. Our college provide this facility to the students for internship in very good companies. There i learned so many things about my course and it enhanced my practical knowledge.

Read Full Review

Was this Review Helpful?

30-11-2018

Rakhi
B.Tech Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

the college has a huge lush green campus, fully wi-fi, online & offline library accessibility, grounds available differently for different sports, cultural events celebrated in a proper traditional way, all students equally participate.

Placement: Yes, every student get the opportunity for summer internships. In the case of stipend, it depends on companies norms and procedures that how much a fresher would get in his/her sip.

Read Full Review

Was this Review Helpful?

30-11-2018

Rahul
B.Tech Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

Placement: Yes, my college provide best internship on live projects where I can get some money as my stipend. they provide internships every year.

Read Full Review

Was this Review Helpful?

30-11-2018

Ridhiverma
B.Tech Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

Placement: Yes, every students gets the opportunity for summer internships. In the case of stipend it depends on companies norms and procedures that how much a fresher would get in his/ her sip.

Read Full Review

Was this Review Helpful?

28-11-2018

Manisha sharma
B.Tech Student

5.0 Events

5.0 Internship/Placement

5.0 Faculty

Placement: Placements in college are quite good. They give exposure to a wide range of industries in multinational firms, for example, maruti, honda, amazon etc. They also give us training and help us to learn skills.

Read Full Review

Was this Review Helpful?

11-01-2020

Tanuja srihan
B.Tech / B.E Student

4.0 Canteen

4.5 Infrastructure

3.5 Sports

4.0 Events

3.5 PG

3.5 Hostel

4.0 Faculty

CONVERGENCE OF ARTIFICIAL INTELLIGENCE WITH TRANSPORTATION INDUSTRY

Faculty: The faculty is very supportive of our college. Their teaching style included real life references from around the world. It helped us to relate and better understand the topics. The faculty also helped us with our projects and gave us the possible future options to explore.

Read Full Review

Was this Review Helpful?

11-01-2020

Deepa singh
B.Tech / B.E Student

4.0 Canteen

4.0 Infrastructure

4.0 Sports

4.0 Events

4.0 PG

4.0 Hostel

4.0 Internship/Placement

4.0 Faculty

REASON WHY I CHOSE THIS COLLEGE

Faculty: In our college most of the faculties are higher in their qualification, almost all the faculties did their education in top most universities and they never hesitate to clear the students doubts at any time, they are very friendly with students.they maintain very pleasant atmosphere while taking the class. Most of the faculty members can teach practicals and theoretical classes.

Read Full Review

Was this Review Helpful?

11-01-2020

Upasana
B.Tech / B.E Student

4.0 Canteen

4.0 Infrastructure

4.5 Sports

3.5 Events

4.5 PG

4.5 Hostel

4.0 Internship/Placement

4.0 Faculty

The college is very good and a nice place to study

Faculty: All the faculty members are well educated.The faculty members in our college are helpful. They go out of the way to help students, and they never regret to answer the doubts of students.

Read Full Review

Was this Review Helpful?

30-11-2018

Rakhi
B.Tech Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

Faculty: Best part of the college was its faculty- pool of talent and experienced professors and guest lecturers were also good.

Read Full Review

Was this Review Helpful?

30-11-2018

Neha
B.Tech Student

5.0 Faculty

Faculty: All the faculties are well educated. They taught us very well and if you have any doubt they will sure it will get clear and if you don’t understand something in class then you can ask it from them where their lecture will be free they will surely help you.

Read Full Review

Was this Review Helpful?

30-11-2018

Rahul
B.Tech Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

Faculty: All the faculty members are well educated they teach a very good and in well and esleye manner. They all are very interactive with the students. Their nature is very good.

Read Full Review

Was this Review Helpful?

04-05-2017

ANJALI SINGH
CSE Student

5.0 Canteen

5.0 Infrastructure

2.5 Sports

5.0 Events

5.0 Society / Clubs

5.0 Bus/Travel

4.5 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

2.0 Exam/Admission

A place for exploring oneself

Exam: Based on School / 12th Class Result

Was this Review Helpful?

View All 158 Reviews

Contact Details

Address

Khurrampur, Farrukh Nagar, Haily Mandi Road, Gurgaon, Delhi (NCR), Gurgaon, Delhi NCR, 122506

College Contact

+91 - 85XXXXXX72

adxxxns@xxxrg

Get Contact Details

St Andrews Institute of Technology and Management - SAITM , Gurgaon

4.8/5 (158 reviews)

Shortlist

Brochure

St Andrews Institute of Technology and Management - SAITM, Gurgaon

Courses Fees

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 Views14 Route Queries58 Models626 Mails Gate Session Request

Request history8.3.19680ms9MBGET colleges/{slug}/{tab}

warninglog[08:48:31] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...

Booting (11.8ms)time
Application (669ms)time
1 x Application (98.26%)
669ms
1 x Booting (1.73%)
11.80ms

14 templates were rendered

pages.college_v2.courses-feescourses-fees.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.latest_updateslatest_updates.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.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}/{tab}
middleware: web, crossAppSync, softRedirects, AB
domain: www.new.collegesearch.in
controller: App\Http\Controllers\CollegeController@collegeProfileTab
namespace
prefix
where
as: cp.collegetabs
file: app/Http/Controllers/CollegeController.php:715-2899

58 statements were executed, 10 of which were duplicates, 48 unique. Show only duplicated554ms

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/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees' and `status` = 1 limit 1

9.54msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees 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` = 'st-andrews-institute-of-technology-and-management-gurgaon' and `status` = 'Active' limit 1

1.08msdb_collegesearchCacheService.php#492

Bindings	0: st-andrews-institute-of-technology-and-management-gurgaon 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 * from `institutes` where (`status` = 'Active' and `ics_link_2` = 'st-andrews-institute-of-technology-and-management-gurgaon') limit 1

3.7msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: st-andrews-institute-of-technology-and-management-gurgaon
Backtrace	15. app/Http/Controllers/CollegeController.php:723 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 `sub_course` where `sub_course_url` = 'courses-fees' limit 1

4msdb_collegesearchCollegeController.php#746

Bindings	0: courses-fees
Backtrace	15. app/Http/Controllers/CollegeController.php:746 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_courses` where `institute_courses`.`institute_id` = 17122 and `institute_courses`.`institute_id` is not null

8.03msdb_collegesearchCollegeController.php#771

Bindings	0: 17122
Backtrace	20. app/Http/Controllers/CollegeController.php:771 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`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_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 `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` LIKE '%cutoff%') as `institute_faqs_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_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 `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `institutes`.`id` in (17122)

246msdb_collegesearchCollegeController.php#780

Bindings	0: 43 1: 2: %cutoff% 3: Alumni 4: 5: 6: 0 7: 8: 0
Backtrace	17. app/Http/Controllers/CollegeController.php:780 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

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

8.33msdb_collegesearchCollegeController.php#807

Bindings	0: 72
Backtrace	19. app/Http/Controllers/CollegeController.php:807 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 * from `institute_courses` where `institute_courses`.`institute_id` in (17122) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2

1.62msdb_collegesearchCollegeController.php#807

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

900μsdb_collegesearchInstitute.php#210

Bindings	0: 1 1: 17122
Backtrace	15. app/Models/Institute.php:210 16. app/Http/Controllers/CollegeController.php:822 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 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` = 17122

2.92msdb_collegesearchCollegeController.php#837

Bindings	0: 17122
Backtrace	15. app/Http/Controllers/CollegeController.php:837 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 `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institutes` as `laravel_reserved_2` where `institutes`.`old_univ_id` = `laravel_reserved_2`.`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 `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_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 `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count` from `institutes` where `id` = 17122 and `status` = 'Active' limit 1

72.71msdb_collegesearchCollegeController.php#970

Bindings	0: 1: 0 2: 3: 0 4: 43 5: 6: Alumni 7: 8: 17122 9: Active
Backtrace	15. app/Http/Controllers/CollegeController.php:970 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 `images` where `images`.`institute_id` in (17122) 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

12.15msdb_collegesearchCollegeController.php#970

Bindings	0: 0
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (17122) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc

7.79msdb_collegesearchCollegeController.php#970

Bindings	0: active 1: yes
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (17122) order by `ID` desc limit 1

1.09msdb_collegesearchCollegeController.php#970

Backtrace

20. app/Http/Controllers/CollegeController.php:970
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 (249)

1.49msdb_collegesearchCollegeController.php#970

Bindings	0: 249
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 (249)

1.38msdb_collegesearchCollegeController.php#970

Bindings	0: 249
Backtrace	30. app/Http/Controllers/CollegeController.php:970 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 * from `institute_courses` where `institute_courses`.`institute_id` in (17122) and `status` = 'active' order by `course_type` asc

1.41msdb_collegesearchCollegeController.php#970

Bindings	0: active
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (1, 2, 7, 13)

1.62msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 7 3: 13
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 (1, 2, 7, 13)

980μsdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 7 3: 13
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_fees` where `course_fees`.`institute_course_id` in (39549, 39550, 39551, 49216) and `fees_name` = 'Total All Fees'

28.88msdb_collegesearchCollegeController.php#970

Bindings	0: Total All Fees
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_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 (39549, 39550, 39551, 49216) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc

1.13msdb_collegesearchCollegeController.php#970

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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_course_id`, `highest_package`, `lowest_package`, `average_package`, `year` from `placement` where `placement`.`institute_course_id` in (39549, 39550, 39551, 49216) and `average_package` != '' and `highest_package` != '' order by `year` desc limit 1

4.84msdb_collegesearchCollegeController.php#970

Bindings	0: 1:
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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 `seats` where `seats`.`institute_course_id` in (39549, 39550, 39551, 49216)

880μsdb_collegesearchCollegeController.php#970

Backtrace

25. app/Http/Controllers/CollegeController.php:970
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 `courses` where `courses`.`id` in (1, 5, 819, 3638) order by `sequence` asc

1.22msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 5 2: 819 3: 3638
Backtrace	30. app/Http/Controllers/CollegeController.php:970 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 `id`, `course_type`, `course_name`, `student_name`, `college_desc`, `added_date`, `year_of_study`, `overall_rating` from `user_reviews` where `user_reviews`.`course_type` in (1, 2, 7, 13) and `institute_id` = 17122 and `college_desc` != '' and length(college_desc) > 10 and `status` = 'Active' order by `overall_rating` asc, length(college_desc) desc

12.87msdb_collegesearchCollegeController.php#970

Bindings	0: 1 1: 2 2: 7 3: 13 4: 17122 5: 6: 10 7: Active
Backtrace	25. app/Http/Controllers/CollegeController.php:970 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`, `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 (17122) and `status` = 'Active' and `college_desc` != '' order by `sequence` asc, length(college_desc) desc limit 10

15.13msdb_collegesearchCollegeController.php#970

Bindings	0: Active 1:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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 (40650, 47057, 65356, 67510, 70114, 70115, 70118, 70129, 70223, 70259) order by `vote_up` desc

1.12msdb_collegesearchCollegeController.php#970

Backtrace

25. app/Http/Controllers/CollegeController.php:970
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 `institute_faqs` where `institute_faqs`.`institute_id` in (17122) and `section` LIKE '%courses%'

1.07msdb_collegesearchCollegeController.php#970

Bindings	0: %courses%
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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`, `name`, `description`, `type`, `webp_image`, `logo`, `twitter_link` from `collaboration` where `collaboration`.`institute_id` in (17122) and `type` in ('Award', 'Alumni') and `description` != '' order by `seq` asc, `id` asc limit 20

1.42msdb_collegesearchCollegeController.php#970

Bindings	0: Award 1: Alumni 2:
Backtrace	20. app/Http/Controllers/CollegeController.php:970 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` = 17122 and `institute_courses`.`institute_id` is not null limit 1

2.03msdb_collegesearchCollegeController.php#995

Bindings	0: 17122
Backtrace	21. app/Http/Controllers/CollegeController.php:995 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 (161,2327)

4.36msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:995
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 (161,2327)

910μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:995
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 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 (3,2025,1306,139,930,34,2018,60,1629,82,1086,5198,156,34,6231,6317,4595,null,null,9,3608,1954,1089,3338,2785,965,6303,32,128,68,6603,930,2533,9)

2.28msdb_collegesearchCollegeController.php#996

Backtrace

10. app/Http/Controllers/CollegeController.php:996
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 * from `states` where `states`.`StateID` = 72 and `states`.`StateID` is not null limit 1

890μsdb_collegesearchCollegeController.php#1004

Bindings	0: 72
Backtrace	20. app/Http/Controllers/CollegeController.php:1004 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_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` = 17122 group by `course_type`.`id`

11.59msdb_collegesearchCollegeController.php#1018

Bindings	0: 17122
Backtrace	14. app/Http/Controllers/CollegeController.php:1018 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` = 17122

2.94msdb_collegesearchCollegeController.php#1046

Bindings	0: 17122
Backtrace	14. app/Http/Controllers/CollegeController.php:1046 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` = 17122 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

12.88msdb_collegesearchCollegeController.php#1071

Bindings	0: Active 1: 17122 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1071 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 (70118, 70223, 70224, 70259, 88166, 88171) order by `vote_up` desc

2.03msdb_collegesearchCollegeController.php#1071

Backtrace

19. app/Http/Controllers/CollegeController.php:1071
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` = 17122 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

11.92msdb_collegesearchCollegeController.php#1089

Bindings	0: Active 1: 17122 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1089 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 (70224, 70237, 70259, 88166, 88171, 88174) order by `vote_up` desc

4.65msdb_collegesearchCollegeController.php#1089

Backtrace

19. app/Http/Controllers/CollegeController.php:1089
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` = 17122 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 6

12.36msdb_collegesearchCollegeController.php#1107

Bindings	0: Active 1: 17122 2: 3: 4: 1
Backtrace	14. app/Http/Controllers/CollegeController.php:1107 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 (31237) order by `vote_up` desc

820μsdb_collegesearchCollegeController.php#1107

Backtrace

19. app/Http/Controllers/CollegeController.php:1107
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` = 17122 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

1.96msdb_collegesearchCollegeController.php#1111

Bindings	0: 17122 1: %ked_review% 2: Y
Backtrace	14. app/Http/Controllers/CollegeController.php:1111 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` = 17122 and date(`start_date`) <= '2025-04-07' and date(`end_date`) >= '2025-04-07'

1.75msdb_collegesearchCollegeController.php#2682

Bindings	0: 17122 1: 2025-04-07 2: 2025-04-07
Backtrace	14. app/Http/Controllers/CollegeController.php:2682 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/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees' and `status` = 'Y' limit 1

870μsdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees 1: Y
Backtrace	15. app/Http/Controllers/CollegeController.php:2693 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` = 17122 and `images`.`deleted_at` is null limit 1

1.18msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 17122
Backtrace	15. app/Models/Institute.php:224 16. app/Http/Controllers/CollegeController.php:2705 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 `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (161,2327)

1.3msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2715
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 (161,2327)

1.05msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2716
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-inner-courses-fees%' and `module_link_id` = 17122 and `expiry_date` > '2025-04-07 08:48:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

2.25msdb_collegesearchhelpers.php#1695

Bindings	0: 17122 1: 2025-04-07 08:48:32
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 ('161', '2327') and `expiry_date` > '2025-04-07 08:48:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

1.75msdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 161 2: 2327 3: 2025-04-07 08:48:32
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 ('1', '2', '7', '13') and `expiry_date` > '2025-04-07 08:48:32' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

2.28msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 1 2: 2 3: 7 4: 13 5: 2025-04-07 08:48:32
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 `ranks` where `ranks`.`institute_id` = 17122 and `ranks`.`institute_id` is not null

680μsdb_collegesearchCollegeController.php#2835

Bindings	0: 17122
Backtrace	19. app/Http/Controllers/CollegeController.php:2835 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` = 1 limit 1

670μsdb_collegesearchBreadcrumb.php#167

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

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

1.56msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
22. app/Http/Controllers/CollegeController.php:2877
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 (161,2327)

770μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
21. app/Http/Controllers/CollegeController.php:2877
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 * from `user_reviews` where `user_reviews`.`institute_id` = 17122 and `user_reviews`.`institute_id` is not null

4.09msdb_collegesearchhero_section.blade.php#27

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

4.94msdb_collegesearchnavbar.blade.php#31

Bindings	0: 17122
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 `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp-inner-courses-fees' and `brandings`.`deleted_at` is null

2.37msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-courses-fees
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: 501UserReview.php#?
App\Models\Image: 45Image.php#?
App\Models\InstituteCourse: 13InstituteCourse.php#?
App\Models\Criteria: 12Criteria.php#?
App\Models\UserReviewsVoteUp: 11UserReviewsVoteUp.php#?
App\Models\PlacementCourse: 8PlacementCourse.php#?
App\Models\Collaboration: 6Collaboration.php#?
App\Models\CourseType: 5CourseType.php#?
App\Models\SubCourse: 4SubCourse.php#?
App\Models\CourseFees: 4CourseFees.php#?
App\Models\Seat: 4Seat.php#?
App\Models\Course: 4Course.php#?
App\Models\Institute: 3Institute.php#?
App\Models\State: 2State.php#?
App\Models\AdminReporting: 1AdminReporting.php#?
App\Models\Admin: 1Admin.php#?
App\Models\WriterProfile: 1WriterProfile.php#?
App\Models\Rank: 1Rank.php#?

_token: LbBFFKt63FPLkbiULZFkoQ9sAlRRLfemSDTOiM9g
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/st-andrews-institute-of-technology-a...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees

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 => "Mon, 07 Apr 2025 03:18:32 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJFRE80WkhxemJQUXcrNzhBYk50VkE9PSIsInZhbHVlIjoiZCtzUEo4WHNVV0lVd0tXQ2wrTTlRSkhXSXpxeUpYcnNUaU5zNXVBTU82THRnenFMS09IMDRLTTY4S1p1OWtmam5mVi9CbjBFNEpVN215ZXpBYnMzUEhKZDB4ajhDRjYwZDNWZE5zL091ZmQ2ZkZUQnF3UUVleE1UOFZ0QjRxYzEiLCJtYWMiOiIyM2E1NTI3M2ZlM2VjZjVhZDE1MDQ5YzdiNDA2OWUxNTE0MDc3MmJmYThiZDljMTlmMDQwOGI0MjJiNWE4YzRmIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 05:18:32 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImJFRE80WkhxemJQUXcrNzhBYk50VkE9PSIsInZhbHVlIjoiZCtzUEo4WHNVV0lVd0tXQ2wrTTlRSkhXSXpxeUpYcnNUaU5zNXVBTU82THRnenFMS09IMDRLTTY4S1p1OWtmam5mVi9Cb ▶"
    1 => "cs_dev_session=eyJpdiI6ImovakVnWm51TXRmZjk4MEdkNDhIbkE9PSIsInZhbHVlIjoiNTRjSzNSZ3J1NHloemt5VU56MG1keHJtWHJ3d1lUOHFsOEU3dHVxQWFLVldGVWtxR2t4YzJGMnpzdUp0d1o0L25WODM1TXNXZUxLd0hvd0pxRWlUQjZ6eHU1STJZa1hqdnRnajJrdGVhaFZpT21CVkRiN0FUeXA1VllvdmVSNGUiLCJtYWMiOiJiMTVkZDE4NjA4ZDQ4NzgzYmE4NjBmNWNjMjc2NDVkOTgxNDU5NDYwYzdlN2NlMTM0NDdmNDUwYzE0ZTk4ZGEzIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 05:18:32 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6ImovakVnWm51TXRmZjk4MEdkNDhIbkE9PSIsInZhbHVlIjoiNTRjSzNSZ3J1NHloemt5VU56MG1keHJtWHJ3d1lUOHFsOEU3dHVxQWFLVldGVWtxR2t4YzJGMnpzdUp0d1o0L25WO ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJFRE80WkhxemJQUXcrNzhBYk50VkE9PSIsInZhbHVlIjoiZCtzUEo4WHNVV0lVd0tXQ2wrTTlRSkhXSXpxeUpYcnNUaU5zNXVBTU82THRnenFMS09IMDRLTTY4S1p1OWtmam5mVi9CbjBFNEpVN215ZXpBYnMzUEhKZDB4ajhDRjYwZDNWZE5zL091ZmQ2ZkZUQnF3UUVleE1UOFZ0QjRxYzEiLCJtYWMiOiIyM2E1NTI3M2ZlM2VjZjVhZDE1MDQ5YzdiNDA2OWUxNTE0MDc3MmJmYThiZDljMTlmMDQwOGI0MjJiNWE4YzRmIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 05:18:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImJFRE80WkhxemJQUXcrNzhBYk50VkE9PSIsInZhbHVlIjoiZCtzUEo4WHNVV0lVd0tXQ2wrTTlRSkhXSXpxeUpYcnNUaU5zNXVBTU82THRnenFMS09IMDRLTTY4S1p1OWtmam5mVi9Cb ▶"
    1 => "cs_dev_session=eyJpdiI6ImovakVnWm51TXRmZjk4MEdkNDhIbkE9PSIsInZhbHVlIjoiNTRjSzNSZ3J1NHloemt5VU56MG1keHJtWHJ3d1lUOHFsOEU3dHVxQWFLVldGVWtxR2t4YzJGMnpzdUp0d1o0L25WODM1TXNXZUxLd0hvd0pxRWlUQjZ6eHU1STJZa1hqdnRnajJrdGVhaFZpT21CVkRiN0FUeXA1VllvdmVSNGUiLCJtYWMiOiJiMTVkZDE4NjA4ZDQ4NzgzYmE4NjBmNWNjMjc2NDVkOTgxNDU5NDYwYzdlN2NlMTM0NDdmNDUwYzE0ZTk4ZGEzIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 05:18:32 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6ImovakVnWm51TXRmZjk4MEdkNDhIbkE9PSIsInZhbHVlIjoiNTRjSzNSZ3J1NHloemt5VU56MG1keHJtWHJ3d1lUOHFsOEU3dHVxQWFLVldGVWtxR2t4YzJGMnpzdUp0d1o0L25WO ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "LbBFFKt63FPLkbiULZFkoQ9sAlRRLfemSDTOiM9g"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 08:48:32	GET	/colleges/st-andrews-institute-of-technology-and-management-gurgaon/courses-fees	1 14 58 626

1 x Application (98.26%)	669ms
1 x Booting (1.73%)	11.80ms