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

Home

Architecture

Architecture Colleges

Delhi NCR

School of Planning & Architecture (SPA), Delhi

Faculty

Public College

School of Planning & Architecture (SPA), Delhi Faculty

Delhi, Delhi NCR
ESTD 1941

Shortlist

Brochure

School of Planning & Architecture (SPA) , Delhi Campus

School of Planning & Architecture (SPA) , Delhi ATHLOS 2013

School of Planning & Architecture (SPA) , Delhi Convocation Exhibition 2013

+5 Photos & Videos

Faculty Details of School of Planning & Architecture (SPA)

Faculty of School of Planning & Architecture (SPA) are as follows:

Faculty Name	Particular
Prof. Sandeep Sancheti Principal	Prof. Sandeep Sancheti is Principal, School of Planning & Architecture (SPA)
Mandeep Singh HOD - Dept. of Architecture	Mandeep Singh is HOD - Dept. of Architecture, School of Planning & Architecture (SPA) Education: Ph.D., M.U.D., B. Arch. F.I.I.A, AIIID
Mayank Mathur HOD - Department of Physical Planning	Mayank Mathur is HOD - Department of Physical Planning, School of Planning & Architecture (SPA) Education: Ph.D., M. Housing, PG Dip. (Housing Planning and Building) (The Netherlands), B. Arch.
Dr. Priyaleen Singh HOD - Department of Architectural Conservation	Dr. Priyaleen Singh is HOD - Department of Architectural Conservation, School of Planning & Architecture (SPA) Education: Ph.D.(UK)., Cert In RM&HC (Italy), M.A. Cons. (UK), MLA., B.Arch.
Dr. P.S.N. Rao HOD - Department of Housing	Dr. P.S.N. Rao is HOD - Department of Housing, School of Planning & Architecture (SPA) Education: Ph.D., M.P.(Housing), Cert. A. App, Cert. U. Mgt., B.E.(Civil), AIIA (by Examination), FITP, FIV

Recommended Colleges

4.4

GD Goenka University

Gurgaon
Private University

Course Offered

B.Arch

Fees (5 Years)

GD Goenka University 25,00,000

Exams Accepted

NATA, GATA

Highest Package

GD Goenka University 3.5 LPA

Brochure Apply Now

4.5

Sharda University

Greater Noida
Private University

Course Offered

B.Arch

Fees (5 Years)

Sharda University 10,93,682

Exams Accepted

NATA

Highest Package

Brochure Apply Now

4.8

St Andrews Institute of Technology and Management - SAITM

Gurgaon
Private College

Brochure Apply Now

Student's Rating for School of Planning & Architecture (SPA) , Delhi

Student Reviews & Ratings

4/5

70% Positive reviews

Component Ratings

Faculty Rating

4.8

Internship/Placement Rating

4.4

Infrastructure Rating

4.1

Canteen Rating

4.1

Hostel/Dorm Rating

4.5

College Fest Rating

4.6

Fashion Rating

4.2

Sports Rating

3.5

Write a Review >

Student's Reviews for School of Planning & Architecture (SPA) , Delhi

Placement

Faculty

Admissions

04-05-2018

Ashutosh Singh
B.Arch Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

4.5 Society / Clubs

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

best college for b arch

Placement: job opportunity is good and also lots of placements

Was this Review Helpful?

21-06-2017

Anonymous
Architecture Student

4.5 Canteen

4.5 Infrastructure

4.0 Sports

4.0 Events

3.5 Society / Clubs

3.5 Bus/Travel

4.0 PG

4.5 Hostel

4.5 Internship/Placement

4.5 Faculty

4.0 Exam/Admission

Architecture in SPA

Placement: The job opportunities after we get out are a lot, but I would like to speak about the amount of research projects that we are allowed to participate that give us immense knowledge.

Read Full Review

Was this Review Helpful?

04-05-2018

Ashutosh Singh
B.Arch Student

5.0 Canteen

5.0 Infrastructure

5.0 Sports

5.0 Events

4.5 Society / Clubs

5.0 PG

5.0 Hostel

5.0 Internship/Placement

5.0 Faculty

best college for b arch

Faculty: faculty is awseome and very supportive

Was this Review Helpful?

21-06-2017

Anonymous
Architecture Student

4.5 Canteen

4.5 Infrastructure

4.0 Sports

4.0 Events

3.5 Society / Clubs

3.5 Bus/Travel

4.0 PG

4.5 Hostel

4.5 Internship/Placement

4.5 Faculty

4.0 Exam/Admission

Architecture in SPA

Faculty: All the faculty in the college are very cooperative and supporting.

Was this Review Helpful?

21-06-2017

Anonymous
Architecture Student

4.5 Canteen

4.5 Infrastructure

4.0 Sports

4.0 Events

3.5 Society / Clubs

3.5 Bus/Travel

4.0 PG

4.5 Hostel

4.5 Internship/Placement

4.5 Faculty

4.0 Exam/Admission

Architecture in SPA

Exam: Based on School / 12th Class Result

Was this Review Helpful?

31-05-2016

Anonymous
B.arch Student

3.5 Canteen

3.0 Infrastructure

1.5 Sports

5.0 Events

4.5 Society / Clubs

1.5 Bus/Travel

4.0 PG

4.0 Hostel

3.5 Internship/Placement

4.5 Faculty

4.0 Exam/Admission

Exam: State / National Entrance Exams

Was this Review Helpful?

View All 10 Reviews

Gallery

5 Images

Other

Other

Workshop Integration of Renewable (Solar) Energy Systems

Other

Show All Images & Videos >

Contact Details

Address

4-Block-B, Indraprastha Estate, Delhi, Delhi NCR, 110002

College Contact

011 - 23XXXXXX76

asxxxpa@xxxom

Get Contact Details

School of Planning & Architecture (SPA) , Delhi

4/5 (10 reviews)

Shortlist

Brochure

View Contact Details

4/5

10 Ratings

Enquire College

Brochure

Retry Again >

Successfully Logged in

Home

Architecture

Architecture Colleges

Delhi NCR

School of Planning & Architecture (SPA), Delhi

Faculty

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 Queries50 Models76 Mails Gate Session Request

Request history8.3.19359ms4MBGET colleges/{slug}/{tab}

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

Booting (14.57ms)time
Application (345ms)time
1 x Application (95.94%)
345ms
1 x Booting (4.05%)
14.57ms

14 templates were rendered

pages.college_v2.facultyfaculty.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

50 statements were executed, 16 of which were duplicates, 34 unique. Show only duplicated256ms

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/school-of-planning-architecture-spa-delhi/faculty' and `status` = 1 limit 1

12.49msdb_collegesearchCacheService.php#460

Bindings	0: /colleges/school-of-planning-architecture-spa-delhi/faculty 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` = 'school-of-planning-architecture-spa-delhi' and `status` = 'Active' limit 1

1.09msdb_collegesearchCacheService.php#492

Bindings	0: school-of-planning-architecture-spa-delhi 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` = 'school-of-planning-architecture-spa-delhi') limit 1

1.99msdb_collegesearchCollegeController.php#723

Bindings	0: Active 1: school-of-planning-architecture-spa-delhi
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` = 'faculty' limit 1

3.29msdb_collegesearchCollegeController.php#746

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

1.48msdb_collegesearchCollegeController.php#771

Bindings	0: 7350
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 (7350)

129msdb_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)

1.81msdb_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 (7350) and `status` = 'active' and `approved` = 'yes' order by `course_type` asc limit 2

1.51msdb_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 * from `course_type` where `course_type`.`id` in (15)

1.59msdb_collegesearchCollegeController.php#807

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

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

1.58msdb_collegesearchInstitute.php#210

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

4.08msdb_collegesearchCollegeController.php#837

Bindings	0: 7350
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 * from `institute_courses` where `institute_courses`.`institute_id` in (7350) and `status` = 'active' order by `course_type` asc limit 1

1.3msdb_collegesearchCollegeController.php#2514

Bindings	0: active
Backtrace	19. app/Http/Controllers/CollegeController.php:2514 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 `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` = 7350 group by `course_type`.`id`

11.59msdb_collegesearchCollegeController.php#2530

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

1.74msdb_collegesearchCollegeController.php#2565

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

1.18msdb_collegesearchCollegeController.php#2592

Bindings	0: Active 1: 7350 2: 3: 4: 15
Backtrace	14. app/Http/Controllers/CollegeController.php:2592 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 (38332, 47832) order by `vote_up` desc

1.24msdb_collegesearchCollegeController.php#2592

Backtrace

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

1.61msdb_collegesearchCollegeController.php#2610

Bindings	0: Active 1: 7350 2: 3: 4: 15
Backtrace	14. app/Http/Controllers/CollegeController.php:2610 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 (38332, 47832) order by `vote_up` desc

770μsdb_collegesearchCollegeController.php#2610

Backtrace

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

1.16msdb_collegesearchCollegeController.php#2628

Bindings	0: Active 1: 7350 2: 3: 4: 15
Backtrace	14. app/Http/Controllers/CollegeController.php:2628 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 (25574, 38332) order by `vote_up` desc

760μsdb_collegesearchCollegeController.php#2628

Backtrace

19. app/Http/Controllers/CollegeController.php:2628
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 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 (0)

650μsdb_collegesearchCollegeController.php#2630

Backtrace

10. app/Http/Controllers/CollegeController.php:2630
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`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (162)

860μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
44. app/Http/Controllers/CollegeController.php:2643
45. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
46. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
47. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

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

2.57msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
44. app/Http/Controllers/CollegeController.php:2643
45. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
46. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
47. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

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

5.04msdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
44. app/Http/Controllers/CollegeController.php:2643
45. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
46. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
47. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

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

860μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
46. app/Http/Controllers/CollegeController.php:2643
47. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
48. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
49. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

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

800μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
46. app/Http/Controllers/CollegeController.php:2643
47. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
48. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
49. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

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

900μsdb_collegesearchInstituteCourse.php#30

Backtrace

14. app/Models/InstituteCourse.php:30
46. app/Http/Controllers/CollegeController.php:2643
47. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
48. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
49. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = '{\"id\":7350,\"cate_id\":\"0\",\"contact_name\":\"principal\",\"college_email\":\"assistantregistrarspa@gmail.com\",\"contact_designation\":\"\",\"institute_name\":\"School of Planning & Architecture (SPA)\",\"othername\":\"SPA, spa delhi\",\"email\":\"admission@spa.ac.in\",\"notification_email\":\"\",\"password_temp1\":\"pn\/kEFMYlCQc76iCGdltK\/zgm3bbL3FlIcbz2jOz38A=\",\"password_r\":\"spa12\",\"ics_link\":\"School_of_Planning_&_Architecture\",\"last_login\":\"2023-03-13 01:44:00\",\"show_all_courses\":\"0\",\"othername_old\":null,\"institute_name_old\":\"School of Planning & Architecture (SPA)\",\"address\":\"4-Block-B, Indraprastha Estate\",\"city_id\":10,\"state\":72,\"state_ids\":\"\",\"city_ids\":\"\",\"state2\":0,\"inst_state\":\"Delhi NCR\",\"inst_city\":\"Delhi\",\"latitude\":\"0.000000000000\",\"longitude\":\"0.000000000000\",\"aff_univ_id\":\"\",\"department_id\":0,\"contact_phone\":\"\",\"phone\":\"23702375 , 23702376\",\"established\":\"1941\",\"pv_style\":\"Public\",\"description\":\"\",\"new_updates\":null,\"url\":\"http:\/\/www.spa.ac.in\",\"logo\":\"130808031634_jyhfg.webp\",\"desig\":\"Principal\",\"principal\":\"Prof. Sandeep Sancheti\",\"strength\":\"32\",\"added_date\":\"2024-06-20 17:45:03\",\"register_date\":\"\",\"featured\":\"N\",\"status\":\"Active\",\"email_status\":\"Y\",\"code\":\"\",\"clicks\":65535,\"clicks_bef_nov\":0,\"impression\":935921,\"impression_inst\":0,\"mail_sent\":\"N\",\"subcat\":\"Basic\",\"nearest_railway_station\":\"\",\"nearest_airport\":\"\",\"coed_convent\":\"yes\",\"type_of_minority\":\"\",\"is_minority\":\"no\",\"aff_url\":\"\",\"acreditation\":\"no\",\"college_area\":\"\",\"boys_hostel\":\"yes\",\"girls_hostel\":\"yes\",\"medical_facility\":\"yes\",\"library_facility\":\"yes\",\"cafeteria\":\"yes\",\"computer_lab\":\"yes\",\"lab\":\"yes\",\"gym\":\"yes\",\"sports\":\"yes\",\"audi\":\"yes\",\"wifi\":\"no\",\"transport\":\"no\",\"loan\":\"no\",\"no_of_faculty_phd\":\"\",\"no_of_faculty_regular\":\"\",\"no_of_faculty_visiting\":\"\",\"pincode\":\"110002\",\"phone_code\":\"011\",\"ugc\":\"no\",\"contact_phone_code\":\"\",\"additional_info\":\"\",\"boys_hostel_num\":\"\",\"girls_hostel_num\":\"\",\"video1\":\"\",\"part_cutoff_desc\":\"\",\"video2\":\"\",\"common_eligibility\":\"\",\"videos_multiple\":null,\"volume\":\"\",\"featured_name\":\"\",\"admin_comment_6\":\"\",\"admin_comment_7\":\"done\",\"admin_comment_8\":\"\",\"college_verified_phone\":\"\",\"college_verified_phone_code\":\"\",\"admin_info\":\"\",\"user_type\":\"College\",\"university_id\":0,\"is_documents\":\"yes\",\"form_price\":\"\",\"is_gallery\":\"yes\",\"mail_request\":\"daily\",\"weekly_summary\":\"Y\",\"is_auto\":\"N\",\"is_deemed\":\"Y\",\"is_cu_type\":\"N\",\"is_verified_images\":\"N\",\"top_rec_ids\":\"\",\"top_rec_course_type\":0,\"rec_college_course\":\"college\",\"research\":\"2\",\"is_paid\":\"N\",\"accept_tc\":\"N\",\"univ_type\":\"\",\"apply_status\":\"N\",\"prev_ics_link\":\"\",\"cons_college\":0,\"cons_univ\":0,\"is_salesforce\":\"\",\"is_salesforce_admin\":0,\"profile_completed\":\"40\",\"acreditation_naac\":\"no\",\"acreditation_naac_type\":\"\",\"acreditation_nba\":\"N\",\"marketing_contact\":\"\",\"profile_monitoring_contact\":\"\",\"counsellor_contact\":\"\",\"sr_rating\":96,\"type_ret_ent\":\"None\",\"email_clicks\":0,\"designation\":0,\"apply_link\":\"\",\"is_verify_contact\":\"N\",\"review_count\":10,\"review_val\":4,\"institute_name_2\":\"School of Planning & Architecture (SPA)\",\"ics_link_2\":\"school-of-planning-architecture-spa-delhi\",\"inst_district\":null,\"pipeline_status\":null,\"notification_email_2\":null,\"last_login_source\":\"email\",\"last_login_device\":\"Desktop\",\"old_univ_id\":0,\"show_desc\":\"no\",\"cate_type\":\"C\",\"usp\":\"\",\"common_elig\":\"\",\"medical_desc\":\"\",\"library_desc\":\"\",\"cafeteria_desc\":\"\",\"computer_lab_desc\":\"\",\"lab_desc\":\"\",\"gym_desc\":\"\",\"sports_desc\":\"\",\"audi_desc\":\"\",\"wifi_desc\":\"\",\"transport_desc\":\"\",\"loan_desc\":\"\",\"infra_desc\":null,\"unique_feature\":\"\",\"data_source_image\":\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAADkAAAAxCAYAAABgSwHoAAAJHUlEQVRogdVaW0hU3Rf\/zThalmVa+WClkWFG9WAlaSEEUXQVFKIH0ayg+92XqOhCmEVqYRFI0Y2ietCKooLUIijpIkUXtRtdtBszXcRGx2Zm\/f4P3ze7meOcccYmv\/4LFufstc\/ea629rnPmGESEcAODwQDSg\/R\/Dwb+qxFJGAwG3Qc7mw8G+OLxO\/wNWksGvIHG8n+jJ5iCYR1ve\/xpqwcCRuAfV3A\/fdfYH5q\/z\/u66tH0eHm7+ppTMdldcOvWLYSFhSElJaXbeAakpF7w+5sURARpaWkIDw\/H9evXVfz+iWSjZUxfSNLnfCB44sQJAiAAnj9\/3u91vysD2E3w48cPDh48WCmZlJTEnz9\/dgtvI\/1MAN7Q3a2067VYVFSEpqYmtaahoQGHDx\/2K3HozXnj63V9sFzRFzY2NrJXr14EwB07dtBoNBIAY2Ji2Nzc\/Mf5K3d1+b47uNO8zevNacc5OTkEwClTplBEuHDhQuW2mzZt8mufznh4m3NdEezkosU7d+7QaDTSaDSytraWIsIPHz6wT58+BMBevXrx3bt3Ae0ZqLx+Jx5fJ6cHTqeTkyZNIgDm5OR4MC4oKFDWzMvLC3jvQOTxcFetmfVoWkZ6686cOUMADA8P59u3bykiLC8v56VLl9ja2sqhQ4cSAI1GIx88eBAQfz3rauc8lAw2uCuxYcMGkqTNZmNCQgJHjx5Nh8PBs2fPKmtOnTq1S97iD3hNPL6spjd20bTuOHDgQH7\/\/p0kWVxcrJQ6cuQInU4n09PTFe3y5cu6e+vx8ke2P1JC3BPL\/v37KSI0m82MiopSCg0ZMoStra28d++eKiljxoyh3W4Pujx\/RMlFixYRABMTE9ne3k4R4apVqwiAffr0UTVz9+7dFBHOnz9fKX\/48OHuV1Lrhp0lhdraWoaEhBAAKyoqKCJsaGhgaGioagY2btxIAIyKiqLFYmFTUxMjIiIIgLGxsWxpaemw728p2anzBwAiwsmTJxMA09PTFZOMjAwC4ODBg2m1Wvnt2zf279+fAJifn0+S3LFjh7Lm9u3bgymWfuLRs5T2Gff78vJyAqDBYGBNTQ1FhFVVVUr4Y8eOqfVFRUUEwJ49e\/LNmze0Wq2Mj49XLv3hwwddft5kcQftOGgx2dbWxuHDhxMA582bRxGhw+FgcnIyATA5OZkOh0M939rayri4OAJgbm4uRYSnT59WB7J48eLui0l\/cc+ePQTAHj168OXLlxQRHjlyRAldVVVFEeGzZ8\/46tUrigiPHj2qmoGHDx96dEgmk4lPnjwJjpJdcPEO8PnzZ\/br148AuH79epJkS0sLY2NjCYCzZ89WDGfMmMGMjAySpN1u56hRowiA06dPp8ivXhcAZ82a1cH1ugJBUXLp0qUEwOjoaFosFpLkli1blEWePn1Kkrxw4YKy7JUrVzrQKisrKSLMzc31oP0ueCgZSKJxXR89ekSTyUQALC4uJkk2Njayd+\/eBMBly5apGExISFDCjxgxgjabjSKiXDQlJYVOp5ONjY2qpIwbN07FslZWbYL0JjMZhMQzbdo0AuCwYcPY1tZGkV\/FvW\/fvvz06RNFxKNEuNDVDNy8eVPRTp8+TRHh9u3bFe3EiRPBicmu+P7FixeVIGfOnCFJ3r9\/X8VUQUEBSfLt27eqy5k4cSJTU1NVqWhqaqKIcM6cOQTA4cOH02az8cePHyr7xsfH02q1+i2XVpcuW7K9vZ1JSUkEwAkTJtDpdFLkVzMQFxdHq9VKEeHcuXMJgCEhIaytreWDBw+Ui2dnZyu3d3VKpaWlFBGeOnVKHWJhYWGHkPGG3ua6nHj27dunCv\/NmzdJkhUVFR4uRpKVlZWK5opPEeHatWs91ru7eUxMDL9\/\/06n08m0tDQCYGRkJD9\/\/twlWTu8\/nDda6\/u92azWbVlmZmZFBHabDYmJiZ6JIv29nZVIgYMGECLxaL2am5u5qBBg1SjYLfb+fr1a\/bs2ZMAuHnzZooIa2pqlPuvXLlSCa5nNW\/ydsldV69eTQAMDQ1lQ0MDRYR79+5VFquurqaIsKSkRNHKyso67PPo0SOWl5ezvLycX79+pYhw3bp1BMCIiAi+f\/+eIsLs7GwCYFhYmOL324lHa0l3qKurU78oVqxYQZK0WCyMjo4mAGZkZFBE+PHjR0ZGRhIAx48fT4fDoRKKL3zz5o0qH0uWLCFJvnv3TpWkrKwsn2XD27iDJb25gDvOmjXLI0ZEhGvWrFGWrauro4gwLy9PtWw1NTVsbW1VDbi\/aDKZWF9fTxHh1q1bO8RwwJb0B65evaoE2LlzJ0myoaGBYWFhBMDly5eTJG\/fvq3iaOHChRQRFhYWBqSgC10x39LSwiFDhhAAU1NT6XQ6\/Zbb4LKoC1z\/IrlorrHdbsfYsWPx5MkTxMXFob6+HuHh4cjKysL58+cRGRmJ58+fo3\/\/\/khNTcX9+\/cRFRWF+vp6xMTE4Nq1a2hpaUGgYDAYMGfOHJhMJpw6dQo5OTkAgLNnz2Lu3Ln+beLvaRw8eFCd7vHjx0mS1dXVNBgMqo6RZFlZmXqutLTU79P2BxwOh2okEhIS2NbW5tc6rx9GuN8DwLdv3zBixAiYzWaMHTsWd+\/eBQBMmDABtbW1iI+PR11dHWw2G5KSkmA2mxESEoK8vDwYDAY4nU6FDofDYxwozWKx4MuXLwCAkpISrF27tvP\/TP0J3Pz8\/A6\/FI4dO6ZoJ0+epIhwxYoVXYq7rmJ0dDS\/fPnSqfyd\/tP84sULjBkzBu3t7Zg5cyYuXboEq9WKkSNHoqmpCSkpKaipqUFzczMWL14Mu93uOz6CDPPnz0dWVpbvh\/S6GxdmZmaqdP748WOS5LZt21Q6v3HjRkB9pD+oXaeVz9u+vubUJy7aKwBcv34d586dAwAsWLAAo0ePxvv371FUVAQASE5ORo8ePXDnzp2gWyhQcMkCePm8xpWBtCfi\/hLKvcVasGBBt8adv3jgwAFdq+smnkOHDqkNtm3bRpF\/Xhy7ivzfhnFxcepNQwd31TN\/bGwsdu3aBbPZjPz8fABAfHw86uvr9Zb8tdDtHyv9F2D8rwXoDlBKuhuU2k9E\/r3XG7vuOxtr99Tj6++cdk+96\/8A138I4Of0Rw4AAAAASUVORK5CYII=\",\"hostel_desc\":\"\",\"password\":\"$2y$10$p7gty6PdRvNzKNBiBetOq.ygb0nV\/uZAsONQbKHTKf78aX9X2MTZ6\",\"part_common_elig\":\"\",\"nirf\":\"0\",\"naac\":\"0\",\"placement_desc\":\"\",\"cutoff_desc\":\"\",\"etc\":0,\"pay_after_placement\":null,\"passwordtoken\":null,\"passupdated\":0,\"logo_new\":\"130808031634_jyhfg.webp\",\"created_at\":null,\"updated_at\":\"2024-06-20T12:15:03.000000Z\",\"deleted_at\":null,\"calendly_url\":null,\"current_page\":\"\",\"images_count\":5,\"collection_dess_count\":0,\"inst_latest_devs_count\":0,\"inst_articles_count\":0,\"institute_facultys_count\":5,\"documents_count\":1,\"institute_faqs_count\":0,\"collaborations_count\":3,\"affiliate_count\":0,\"departments_count\":0,\"headerInstituteImage\":\"{{ Vite::asset(\'resources\/images\/generic-background.webp\') }}\",\"pathInfo\":\"colleges\/school-of-planning-architecture-spa-delhi\",\"cutoffNewShagunJson\":\"0\",\"institute_courses_req\":[{\"course_type\":15,\"course_name\":\"B.Arch\",\"id\":15,\"sub_course_url\":\"bachelor-of-architecture\"},{\"course_type\":16,\"course_name\":\"M.Arch\",\"id\":16,\"sub_course_url\":\"master-of-architecture\"},{\"course_type\":43,\"course_name\":\"P.hd\",\"id\":43,\"sub_course_url\":\"doctor-of-philosophy\"},{\"course_type\":89,\"course_name\":\"Design - PG\",\"id\":89,\"sub_course_url\":\"post-graduation-in-product-design-and-graphic-design\"}],\"course_type_id_passed\":15,\"reviewRating\":[{\"excellent_count\":\"4\",\"good_count\":\"3\",\"average_count\":\"0\",\"bad_count\":\"1\",\"worst_count\":\"0\",\"rejected_review\":\"0\",\"fashion_review_average\":\"25\",\"sports_review_average\":\"21\",\"event_review_average\":\"37\",\"hostel_review_average\":\"27\",\"canteen_review_average\":\"34\",\"infra_review_average\":\"33\",\"intern_review_average\":\"35\",\"teacher_review_average\":\"38\",\"admission_review_average\":\"16\",\"infra_review_count\":\"4\",\"intern_review_count\":\"4\",\"admission_review_count\":\"2\",\"teacher_rating_count\":\"4\",\"fashion_review_count\":\"3\",\"sports_review_count\":\"3\",\"event_review_count\":\"4\",\"hostel_review_count\":\"3\",\"canteen_review_count\":\"4\"}],\"recruiters\":[],\"recruiters_i\":[],\"recruiters_o\":[],\"recruiters_c\":[],\"recruiters_count\":0,\"courses\":[{\"id\":8891,\"fees\":\"\",\"institute_id\":7350,\"course_type\":15,\"sub_course_id\":15,\"aff_univ_id\":\"\",\"duration\":\"3\",\"duration_month\":\"0\",\"duration_hours\":\"0\",\"duration_day\":\"0\",\"duration_year\":\"0\",\"approved\":\"yes\",\"mci_recog\":\"no\",\"bci_app\":\"no\",\"fulltime_partime\":\"yes\",\"oncampus_distance\":\"yes\",\"eligibility\":\"&lt;p&gt;\n\tCandidates shall be eligible for admission to the First Year of the Bachelors&amp;#39; Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.&lt;\/p&gt;\",\"admission_dates\":null,\"tenth\":\"N\",\"twelfth\":\"PCM\",\"twelfth_marks\":50,\"grad\":0,\"grad_marks\":0,\"commencement\":\"6\",\"commencement2\":\"\",\"commencement3\":\"\",\"examination_system\":\"Semester\",\"criteria\":{\"162\":{\"id\":162,\"name\":\"NATA - Exam\",\"display_name\":\"NATA\",\"short_name\":\"nata\",\"exam_image\":\"121213055959_nata.jpg\",\"description\":\"National Aptitude Test in Architecture \"}},\"criteria_marks\":\"\",\"admission_procedure\":\"\",\"group_discussion\":\"N\",\"personal_interview\":\"N\",\"top_recruiters\":\"\",\"sc_reservation\":\"no\",\"st_reservation\":\"no\",\"obc_reservation\":\"no\",\"is_degree\":\"yes\",\"total_seats\":105,\"show_seats\":\"no\",\"show_lateral_seats\":\"no\",\"total_lateral_seats\":0,\"profile_id\":\"1\",\"profile_name\":\"Basic\",\"city\":\"no\",\"state\":\"no\",\"region\":\"no\",\"mixed\":\"no\",\"state_ids\":\"\",\"city_ids\":\"\",\"sequence\":0,\"features\":\"no\",\"date\":\"2012-09-19 12:26:23\",\"course_field\":\"no\",\"featured_field\":\"\",\"full_breakup\":\"breakup\",\"top_rec_ids\":\"\",\"course_specific_name\":\"\",\"is_dept\":\"N\",\"is_lateral\":\"N\",\"lateral_fees\":\"\",\"lateral_seats\":0,\"mint_rank_2015\":0,\"mint_rank_2016\":0,\"mint_rank_2017\":0,\"mint_rank_2018\":0,\"itoday_rank_2015\":0,\"itoday_rank_2016\":0,\"itoday_rank_2017\":0,\"itoday_rank_2018\":0,\"outlook_rank_2015\":0,\"outlook_rank_2016\":0,\"outlook_rank_2017\":2,\"outlook_rank_2018\":0,\"nirf_rank_2017\":\"0\",\"nirf_rank_2018\":\"3\",\"nirf_rank_2019\":\"\",\"nirf_rank_2020\":\"5\",\"branch_ids\":\"\",\"start_date_apply\":\"\",\"end_date_apply\":\"\",\"is_apply_now\":\"Y\",\"applynow_start_date\":\"\",\"applynow_end_date\":\"\",\"sr_rating\":87,\"pr_rating\":0,\"response_time_quater\":500,\"total_fees_sorting\":314500,\"is_cp_featured\":\"N\",\"cp_state_ids\":null,\"is_cp_national\":\"N\",\"pwd_reservation\":\"no\",\"apply_link\":\"\",\"is_grad\":\"N\",\"fees_text\":\"\",\"status\":\"active\",\"course_type_2\":\"\",\"apply_link2\":\"\",\"highest_package\":\"\",\"average_package\":\"\",\"placement_rating\":99,\"campus_rating\":88,\"faculty_rating\":50,\"reputation_rating\":91,\"landing_page\":\"\",\"course_details\":\"\",\"created_at\":null,\"updated_at\":null,\"deleted_at\":null,\"tier\":null}],\"state_info\":{\"StateID\":72,\"CountryID\":\"2\",\"State\":\"Delhi NCR\",\"state_ipaddress_name\":\"National Capital Territory of Delhi\",\"shortname\":\"delhi-ncr\",\"Status\":1,\"region\":\"N\",\"sequence\":1,\"top_other\":\"t\",\"category\":\"A\",\"priority\":\"A\",\"mu_stateid\":7,\"gibs_stateid\":10,\"count_inst\":456,\"latitude\":\"28.6882438\",\"longitude\":\"77.1212148\"},\"header_courses\":[{\"id\":8891,\"fees\":\"\",\"institute_id\":7350,\"course_type\":15,\"sub_course_id\":15,\"aff_univ_id\":\"\",\"duration\":\"3\",\"duration_month\":\"0\",\"duration_hours\":\"0\",\"duration_day\":\"0\",\"duration_year\":\"0\",\"approved\":\"yes\",\"mci_recog\":\"no\",\"bci_app\":\"no\",\"fulltime_partime\":\"yes\",\"oncampus_distance\":\"yes\",\"eligibility\":\"&lt;p&gt;\n\tCandidates shall be eligible for admission to the First Year of the Bachelors&amp;#39; Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.&lt;\/p&gt;\",\"admission_dates\":null,\"tenth\":\"N\",\"twelfth\":\"PCM\",\"twelfth_marks\":50,\"grad\":0,\"grad_marks\":0,\"commencement\":\"6\",\"commencement2\":\"\",\"commencement3\":\"\",\"examination_system\":\"Semester\",\"criteria\":{\"162\":{\"id\":162,\"name\":\"NATA - Exam\",\"display_name\":\"NATA\",\"short_name\":\"nata\",\"exam_image\":\"121213055959_nata.jpg\",\"description\":\"National Aptitude Test in Architecture \"}},\"criteria_marks\":\"\",\"admission_procedure\":\"\",\"group_discussion\":\"N\",\"personal_interview\":\"N\",\"top_recruiters\":\"\",\"sc_reservation\":\"no\",\"st_reservation\":\"no\",\"obc_reservation\":\"no\",\"is_degree\":\"yes\",\"total_seats\":105,\"show_seats\":\"no\",\"show_lateral_seats\":\"no\",\"total_lateral_seats\":0,\"profile_id\":\"1\",\"profile_name\":\"Basic\",\"city\":\"no\",\"state\":\"no\",\"region\":\"no\",\"mixed\":\"no\",\"state_ids\":\"\",\"city_ids\":\"\",\"sequence\":0,\"features\":\"no\",\"date\":\"2012-09-19 12:26:23\",\"course_field\":\"no\",\"featured_field\":\"\",\"full_breakup\":\"breakup\",\"top_rec_ids\":\"\",\"course_specific_name\":\"\",\"is_dept\":\"N\",\"is_lateral\":\"N\",\"lateral_fees\":\"\",\"lateral_seats\":0,\"mint_rank_2015\":0,\"mint_rank_2016\":0,\"mint_rank_2017\":0,\"mint_rank_2018\":0,\"itoday_rank_2015\":0,\"itoday_rank_2016\":0,\"itoday_rank_2017\":0,\"itoday_rank_2018\":0,\"outlook_rank_2015\":0,\"outlook_rank_2016\":0,\"outlook_rank_2017\":2,\"outlook_rank_2018\":0,\"nirf_rank_2017\":\"0\",\"nirf_rank_2018\":\"3\",\"nirf_rank_2019\":\"\",\"nirf_rank_2020\":\"5\",\"branch_ids\":\"\",\"start_date_apply\":\"\",\"end_date_apply\":\"\",\"is_apply_now\":\"Y\",\"applynow_start_date\":\"\",\"applynow_end_date\":\"\",\"sr_rating\":87,\"pr_rating\":0,\"response_time_quater\":500,\"total_fees_sorting\":314500,\"is_cp_featured\":\"N\",\"cp_state_ids\":null,\"is_cp_national\":\"N\",\"pwd_reservation\":\"no\",\"apply_link\":\"\",\"is_grad\":\"N\",\"fees_text\":\"\",\"status\":\"active\",\"course_type_2\":\"\",\"apply_link2\":\"\",\"highest_package\":\"\",\"average_package\":\"\",\"placement_rating\":99,\"campus_rating\":88,\"faculty_rating\":50,\"reputation_rating\":91,\"landing_page\":\"\",\"course_details\":\"\",\"created_at\":null,\"updated_at\":null,\"deleted_at\":null,\"tier\":null,\"course_types\":[{\"id\":15,\"course_name\":\"B.Arch\",\"sequence\":13,\"status\":\"Y\",\"related_sub_course\":0,\"related_branch\":0,\"shortname\":\"architecture\",\"alternate_name\":\"B.Arch\",\"alternate_name2\":\"Bachelor of Architecture\",\"header_name\":\"Architecture\",\"price_category\":\"B\",\"ug_pg\":\"UG\",\"cat_type\":\"architecture_cat\",\"duration\":\"5\",\"session_starts\":\"July\",\"show_degree_field\":\"yes\",\"is_branches\":\"yes\",\"default_show_branches\":\"yes\",\"is_main\":\"N\",\"course_specific\":\"\",\"fees_calc\":\"t\",\"affiliation\":\"COA Approved\",\"logo\":\"sprite_arch\",\"content\":\"-\",\"colleges_num\":\"350\",\"stream\":\"science\",\"elig_12th\":\"Y\",\"elig_marks_12th\":\"\",\"elig_marks_grad\":\"\",\"elig_grad_text\":\"\",\"elig_12th_sub\":\"\",\"elig_grad_ug_ids\":\"\",\"further_pg_ids\":\"\",\"alternate_course_ids\":\"\",\"course_image\":\"150923060935_B.arch.jpg\",\"course_category\":4,\"is_course_page\":\"Y\",\"highest_package\":\"6\",\"average_package\":\"3.6\",\"cat_full_name\":\"Architecture\",\"icon\":\"fa-building\",\"eligibility_desc\":\"\",\"category_new\":1,\"exams_num\":null,\"what_after\":\"\",\"recruiters\":\"\",\"career\":\"\",\"further_studies\":\"\",\"test_column\":null}]},{\"id\":12674,\"fees\":\"\",\"institute_id\":7350,\"course_type\":15,\"sub_course_id\":309,\"aff_univ_id\":\"\",\"duration\":\"4\",\"duration_month\":\"0\",\"duration_hours\":\"0\",\"duration_day\":\"0\",\"duration_year\":\"0\",\"approved\":\"yes\",\"mci_recog\":\"no\",\"bci_app\":\"no\",\"fulltime_partime\":\"yes\",\"oncampus_distance\":\"yes\",\"eligibility\":\"&lt;p&gt;\n\tCandidates shall be eligible for admission to the First Year of the Bachelors&amp;#39; Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.&lt;\/p&gt;\",\"admission_dates\":null,\"tenth\":\"N\",\"twelfth\":\"PCM\",\"twelfth_marks\":50,\"grad\":0,\"grad_marks\":0,\"commencement\":\"6\",\"commencement2\":\"\",\"commencement3\":\"\",\"examination_system\":\"\",\"criteria\":{\"162\":{\"id\":162,\"name\":\"NATA - Exam\",\"display_name\":\"NATA\",\"short_name\":\"nata\",\"exam_image\":\"121213055959_nata.jpg\",\"description\":\"National Aptitude Test in Architecture \"}},\"criteria_marks\":\"\",\"admission_procedure\":\"\",\"group_discussion\":\"N\",\"personal_interview\":\"N\",\"top_recruiters\":\"\",\"sc_reservation\":\"no\",\"st_reservation\":\"no\",\"obc_reservation\":\"no\",\"is_degree\":\"yes\",\"total_seats\":35,\"show_seats\":\"no\",\"show_lateral_seats\":\"no\",\"total_lateral_seats\":0,\"profile_id\":\"1\",\"profile_name\":\"Basic\",\"city\":\"no\",\"state\":\"no\",\"region\":\"no\",\"mixed\":\"no\",\"state_ids\":\"\",\"city_ids\":\"\",\"sequence\":0,\"features\":\"no\",\"date\":\"2013-08-08 15:32:06\",\"course_field\":\"no\",\"featured_field\":\"\",\"full_breakup\":\"breakup\",\"top_rec_ids\":\"\",\"course_specific_name\":\"\",\"is_dept\":\"N\",\"is_lateral\":\"N\",\"lateral_fees\":\"\",\"lateral_seats\":0,\"mint_rank_2015\":0,\"mint_rank_2016\":0,\"mint_rank_2017\":0,\"mint_rank_2018\":0,\"itoday_rank_2015\":0,\"itoday_rank_2016\":0,\"itoday_rank_2017\":0,\"itoday_rank_2018\":0,\"outlook_rank_2015\":0,\"outlook_rank_2016\":0,\"outlook_rank_2017\":0,\"outlook_rank_2018\":0,\"nirf_rank_2017\":\"0\",\"nirf_rank_2018\":\"0\",\"nirf_rank_2019\":\"\",\"nirf_rank_2020\":\"0\",\"branch_ids\":\"\",\"start_date_apply\":\"\",\"end_date_apply\":\"\",\"is_apply_now\":\"Y\",\"applynow_start_date\":\"\",\"applynow_end_date\":\"\",\"sr_rating\":91,\"pr_rating\":0,\"response_time_quater\":500,\"total_fees_sorting\":253600,\"is_cp_featured\":\"N\",\"cp_state_ids\":null,\"is_cp_national\":\"N\",\"pwd_reservation\":\"no\",\"apply_link\":\"\",\"is_grad\":\"N\",\"fees_text\":\"\",\"status\":\"active\",\"course_type_2\":\"\",\"apply_link2\":\"\",\"highest_package\":\"\",\"average_package\":\"\",\"placement_rating\":99,\"campus_rating\":88,\"faculty_rating\":50,\"reputation_rating\":96,\"landing_page\":\"\",\"course_details\":\"\",\"created_at\":null,\"updated_at\":null,\"deleted_at\":null,\"tier\":null,\"course_types\":[{\"id\":15,\"course_name\":\"B.Arch\",\"sequence\":13,\"status\":\"Y\",\"related_sub_course\":0,\"related_branch\":0,\"shortname\":\"architecture\",\"alternate_name\":\"B.Arch\",\"alternate_name2\":\"Bachelor of Architecture\",\"header_name\":\"Architecture\",\"price_category\":\"B\",\"ug_pg\":\"UG\",\"cat_type\":\"architecture_cat\",\"duration\":\"5\",\"session_starts\":\"July\",\"show_degree_field\":\"yes\",\"is_branches\":\"yes\",\"default_show_branches\":\"yes\",\"is_main\":\"N\",\"course_specific\":\"\",\"fees_calc\":\"t\",\"affiliation\":\"COA Approved\",\"logo\":\"sprite_arch\",\"content\":\"-\",\"colleges_num\":\"350\",\"stream\":\"science\",\"elig_12th\":\"Y\",\"elig_marks_12th\":\"\",\"elig_marks_grad\":\"\",\"elig_grad_text\":\"\",\"elig_12th_sub\":\"\",\"elig_grad_ug_ids\":\"\",\"further_pg_ids\":\"\",\"alternate_course_ids\":\"\",\"course_image\":\"150923060935_B.arch.jpg\",\"course_category\":4,\"is_course_page\":\"Y\",\"highest_package\":\"6\",\"average_package\":\"3.6\",\"cat_full_name\":\"Architecture\",\"icon\":\"fa-building\",\"eligibility_desc\":\"\",\"category_new\":1,\"exams_num\":null,\"what_after\":\"\",\"recruiters\":\"\",\"career\":\"\",\"further_studies\":\"\",\"test_column\":null}]}]}' and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc

16.82msdb_collegesearchCollegeController.php#2643

Bindings

0: {"id":7350,"cate_id":"0","contact_name":"principal","college_email":"assistantregistrarspa@gmail.com","contact_designation":"","institute_name":"School of Planning & Architecture (SPA)","othername":"SPA, spa delhi","email":"admission@spa.ac.in","notification_email":"","password_temp1":"pn\/kEFMYlCQc76iCGdltK\/zgm3bbL3FlIcbz2jOz38A=","password_r":"spa12","ics_link":"School_of_Planning_&_Architecture","last_login":"2023-03-13 01:44:00","show_all_courses":"0","othername_old":null,"institute_name_old":"School of Planning & Architecture (SPA)","address":"4-Block-B, Indraprastha Estate","city_id":10,"state":72,"state_ids":"","city_ids":"","state2":0,"inst_state":"Delhi NCR","inst_city":"Delhi","latitude":"0.000000000000","longitude":"0.000000000000","aff_univ_id":"","department_id":0,"contact_phone":"","phone":"23702375 , 23702376","established":"1941","pv_style":"Public","description":"","new_updates":null,"url":"http:\/\/www.spa.ac.in","logo":"130808031634_jyhfg.webp","desig":"Principal","principal":"Prof. Sandeep Sancheti","strength":"32","added_date":"2024-06-20 17:45:03","register_date":"","featured":"N","status":"Active","email_status":"Y","code":"","clicks":65535,"clicks_bef_nov":0,"impression":935921,"impression_inst":0,"mail_sent":"N","subcat":"Basic","nearest_railway_station":"","nearest_airport":"","coed_convent":"yes","type_of_minority":"","is_minority":"no","aff_url":"","acreditation":"no","college_area":"","boys_hostel":"yes","girls_hostel":"yes","medical_facility":"yes","library_facility":"yes","cafeteria":"yes","computer_lab":"yes","lab":"yes","gym":"yes","sports":"yes","audi":"yes","wifi":"no","transport":"no","loan":"no","no_of_faculty_phd":"","no_of_faculty_regular":"","no_of_faculty_visiting":"","pincode":"110002","phone_code":"011","ugc":"no","contact_phone_code":"","additional_info":"","boys_hostel_num":"","girls_hostel_num":"","video1":"","part_cutoff_desc":"","video2":"","common_eligibility":"","videos_multiple":null,"volume":"","featured_name":"","admin_comment_6":"","admin_comment_7":"done","admin_comment_8":"","college_verified_phone":"","college_verified_phone_code":"","admin_info":"","user_type":"College","university_id":0,"is_documents":"yes","form_price":"","is_gallery":"yes","mail_request":"daily","weekly_summary":"Y","is_auto":"N","is_deemed":"Y","is_cu_type":"N","is_verified_images":"N","top_rec_ids":"","top_rec_course_type":0,"rec_college_course":"college","research":"2","is_paid":"N","accept_tc":"N","univ_type":"","apply_status":"N","prev_ics_link":"","cons_college":0,"cons_univ":0,"is_salesforce":"","is_salesforce_admin":0,"profile_completed":"40","acreditation_naac":"no","acreditation_naac_type":"","acreditation_nba":"N","marketing_contact":"","profile_monitoring_contact":"","counsellor_contact":"","sr_rating":96,"type_ret_ent":"None","email_clicks":0,"designation":0,"apply_link":"","is_verify_contact":"N","review_count":10,"review_val":4,"institute_name_2":"School of Planning & Architecture (SPA)","ics_link_2":"school-of-planning-architecture-spa-delhi","inst_district":null,"pipeline_status":null,"notification_email_2":null,"last_login_source":"email","last_login_device":"Desktop","old_univ_id":0,"show_desc":"no","cate_type":"C","usp":"","common_elig":"","medical_desc":"","library_desc":"","cafeteria_desc":"","computer_lab_desc":"","lab_desc":"","gym_desc":"","sports_desc":"","audi_desc":"","wifi_desc":"","transport_desc":"","loan_desc":"","infra_desc":null,"unique_feature":"","data_source_image":"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAADkAAAAxCAYAAABgSwHoAAAJHUlEQVRogdVaW0hU3Rf\/zThalmVa+WClkWFG9WAlaSEEUXQVFKIH0ayg+92XqOhCmEVqYRFI0Y2ietCKooLUIijpIkUXtRtdtBszXcRGx2Zm\/f4P3ze7meOcccYmv\/4LFufstc\/ea629rnPmGESEcAODwQDSg\/R\/Dwb+qxFJGAwG3Qc7mw8G+OLxO\/wNWksGvIHG8n+jJ5iCYR1ve\/xpqwcCRuAfV3A\/fdfYH5q\/z\/u66tH0eHm7+ppTMdldcOvWLYSFhSElJaXbeAakpF7w+5sURARpaWkIDw\/H9evXVfz+iWSjZUxfSNLnfCB44sQJAiAAnj9\/3u91vysD2E3w48cPDh48WCmZlJTEnz9\/dgtvI\/1MAN7Q3a2067VYVFSEpqYmtaahoQGHDx\/2K3HozXnj63V9sFzRFzY2NrJXr14EwB07dtBoNBIAY2Ji2Nzc\/Mf5K3d1+b47uNO8zevNacc5OTkEwClTplBEuHDhQuW2mzZt8mufznh4m3NdEezkosU7d+7QaDTSaDSytraWIsIPHz6wT58+BMBevXrx3bt3Ae0ZqLx+Jx5fJ6cHTqeTkyZNIgDm5OR4MC4oKFDWzMvLC3jvQOTxcFetmfVoWkZ6686cOUMADA8P59u3bykiLC8v56VLl9ja2sqhQ4cSAI1GIx88eBAQfz3rauc8lAw2uCuxYcMGkqTNZmNCQgJHjx5Nh8PBs2fPKmtOnTq1S97iD3hNPL6spjd20bTuOHDgQH7\/\/p0kWVxcrJQ6cuQInU4n09PTFe3y5cu6e+vx8ke2P1JC3BPL\/v37KSI0m82MiopSCg0ZMoStra28d++eKiljxoyh3W4Pujx\/RMlFixYRABMTE9ne3k4R4apVqwiAffr0UTVz9+7dFBHOnz9fKX\/48OHuV1Lrhp0lhdraWoaEhBAAKyoqKCJsaGhgaGioagY2btxIAIyKiqLFYmFTUxMjIiIIgLGxsWxpaemw728p2anzBwAiwsmTJxMA09PTFZOMjAwC4ODBg2m1Wvnt2zf279+fAJifn0+S3LFjh7Lm9u3bgymWfuLRs5T2Gff78vJyAqDBYGBNTQ1FhFVVVUr4Y8eOqfVFRUUEwJ49e\/LNmze0Wq2Mj49XLv3hwwddft5kcQftOGgx2dbWxuHDhxMA582bRxGhw+FgcnIyATA5OZkOh0M939rayri4OAJgbm4uRYSnT59WB7J48eLui0l\/cc+ePQTAHj168OXLlxQRHjlyRAldVVVFEeGzZ8\/46tUrigiPHj2qmoGHDx96dEgmk4lPnjwJjpJdcPEO8PnzZ\/br148AuH79epJkS0sLY2NjCYCzZ89WDGfMmMGMjAySpN1u56hRowiA06dPp8ivXhcAZ82a1cH1ugJBUXLp0qUEwOjoaFosFpLkli1blEWePn1Kkrxw4YKy7JUrVzrQKisrKSLMzc31oP0ueCgZSKJxXR89ekSTyUQALC4uJkk2Njayd+\/eBMBly5apGExISFDCjxgxgjabjSKiXDQlJYVOp5ONjY2qpIwbN07FslZWbYL0JjMZhMQzbdo0AuCwYcPY1tZGkV\/FvW\/fvvz06RNFxKNEuNDVDNy8eVPRTp8+TRHh9u3bFe3EiRPBicmu+P7FixeVIGfOnCFJ3r9\/X8VUQUEBSfLt27eqy5k4cSJTU1NVqWhqaqKIcM6cOQTA4cOH02az8cePHyr7xsfH02q1+i2XVpcuW7K9vZ1JSUkEwAkTJtDpdFLkVzMQFxdHq9VKEeHcuXMJgCEhIaytreWDBw+Ui2dnZyu3d3VKpaWlFBGeOnVKHWJhYWGHkPGG3ua6nHj27dunCv\/NmzdJkhUVFR4uRpKVlZWK5opPEeHatWs91ru7eUxMDL9\/\/06n08m0tDQCYGRkJD9\/\/twlWTu8\/nDda6\/u92azWbVlmZmZFBHabDYmJiZ6JIv29nZVIgYMGECLxaL2am5u5qBBg1SjYLfb+fr1a\/bs2ZMAuHnzZooIa2pqlPuvXLlSCa5nNW\/ydsldV69eTQAMDQ1lQ0MDRYR79+5VFquurqaIsKSkRNHKyso67PPo0SOWl5ezvLycX79+pYhw3bp1BMCIiAi+f\/+eIsLs7GwCYFhYmOL324lHa0l3qKurU78oVqxYQZK0WCyMjo4mAGZkZFBE+PHjR0ZGRhIAx48fT4fDoRKKL3zz5o0qH0uWLCFJvnv3TpWkrKwsn2XD27iDJb25gDvOmjXLI0ZEhGvWrFGWrauro4gwLy9PtWw1NTVsbW1VDbi\/aDKZWF9fTxHh1q1bO8RwwJb0B65evaoE2LlzJ0myoaGBYWFhBMDly5eTJG\/fvq3iaOHChRQRFhYWBqSgC10x39LSwiFDhhAAU1NT6XQ6\/Zbb4LKoC1z\/IrlorrHdbsfYsWPx5MkTxMXFob6+HuHh4cjKysL58+cRGRmJ58+fo3\/\/\/khNTcX9+\/cRFRWF+vp6xMTE4Nq1a2hpaUGgYDAYMGfOHJhMJpw6dQo5OTkAgLNnz2Lu3Ln+beLvaRw8eFCd7vHjx0mS1dXVNBgMqo6RZFlZmXqutLTU79P2BxwOh2okEhIS2NbW5tc6rx9GuN8DwLdv3zBixAiYzWaMHTsWd+\/eBQBMmDABtbW1iI+PR11dHWw2G5KSkmA2mxESEoK8vDwYDAY4nU6FDofDYxwozWKx4MuXLwCAkpISrF27tvP\/TP0J3Pz8\/A6\/FI4dO6ZoJ0+epIhwxYoVXYq7rmJ0dDS\/fPnSqfyd\/tP84sULjBkzBu3t7Zg5cyYuXboEq9WKkSNHoqmpCSkpKaipqUFzczMWL14Mu93uOz6CDPPnz0dWVpbvh\/S6GxdmZmaqdP748WOS5LZt21Q6v3HjRkB9pD+oXaeVz9u+vubUJy7aKwBcv34d586dAwAsWLAAo0ePxvv371FUVAQASE5ORo8ePXDnzp2gWyhQcMkCePm8xpWBtCfi\/hLKvcVasGBBt8adv3jgwAFdq+smnkOHDqkNtm3bRpF\/Xhy7ivzfhnFxcepNQwd31TN\/bGwsdu3aBbPZjPz8fABAfHw86uvr9Zb8tdDtHyv9F2D8rwXoDlBKuhuU2k9E\/r3XG7vuOxtr99Tj6++cdk+96\/8A138I4Of0Rw4AAAAASUVORK5CYII=","hostel_desc":"","password":"$2y$10$p7gty6PdRvNzKNBiBetOq.ygb0nV\/uZAsONQbKHTKf78aX9X2MTZ6","part_common_elig":"","nirf":"0","naac":"0","placement_desc":"","cutoff_desc":"","etc":0,"pay_after_placement":null,"passwordtoken":null,"passupdated":0,"logo_new":"130808031634_jyhfg.webp","created_at":null,"updated_at":"2024-06-20T12:15:03.000000Z","deleted_at":null,"calendly_url":null,"current_page":"","images_count":5,"collection_dess_count":0,"inst_latest_devs_count":0,"inst_articles_count":0,"institute_facultys_count":5,"documents_count":1,"institute_faqs_count":0,"collaborations_count":3,"affiliate_count":0,"departments_count":0,"headerInstituteImage":"{{ Vite::asset('resources\/images\/generic-background.webp') }}","pathInfo":"colleges\/school-of-planning-architecture-spa-delhi","cutoffNewShagunJson":"0","institute_courses_req":[{"course_type":15,"course_name":"B.Arch","id":15,"sub_course_url":"bachelor-of-architecture"},{"course_type":16,"course_name":"M.Arch","id":16,"sub_course_url":"master-of-architecture"},{"course_type":43,"course_name":"P.hd","id":43,"sub_course_url":"doctor-of-philosophy"},{"course_type":89,"course_name":"Design - PG","id":89,"sub_course_url":"post-graduation-in-product-design-and-graphic-design"}],"course_type_id_passed":15,"reviewRating":[{"excellent_count":"4","good_count":"3","average_count":"0","bad_count":"1","worst_count":"0","rejected_review":"0","fashion_review_average":"25","sports_review_average":"21","event_review_average":"37","hostel_review_average":"27","canteen_review_average":"34","infra_review_average":"33","intern_review_average":"35","teacher_review_average":"38","admission_review_average":"16","infra_review_count":"4","intern_review_count":"4","admission_review_count":"2","teacher_rating_count":"4","fashion_review_count":"3","sports_review_count":"3","event_review_count":"4","hostel_review_count":"3","canteen_review_count":"4"}],"recruiters":[],"recruiters_i":[],"recruiters_o":[],"recruiters_c":[],"recruiters_count":0,"courses":[{"id":8891,"fees":"","institute_id":7350,"course_type":15,"sub_course_id":15,"aff_univ_id":"","duration":"3","duration_month":"0","duration_hours":"0","duration_day":"0","duration_year":"0","approved":"yes","mci_recog":"no","bci_app":"no","fulltime_partime":"yes","oncampus_distance":"yes","eligibility":"<p>\n\tCandidates shall be eligible for admission to the First Year of the Bachelors' Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.<\/p>","admission_dates":null,"tenth":"N","twelfth":"PCM","twelfth_marks":50,"grad":0,"grad_marks":0,"commencement":"6","commencement2":"","commencement3":"","examination_system":"Semester","criteria":{"162":{"id":162,"name":"NATA - Exam","display_name":"NATA","short_name":"nata","exam_image":"121213055959_nata.jpg","description":"National Aptitude Test in Architecture "}},"criteria_marks":"","admission_procedure":"","group_discussion":"N","personal_interview":"N","top_recruiters":"","sc_reservation":"no","st_reservation":"no","obc_reservation":"no","is_degree":"yes","total_seats":105,"show_seats":"no","show_lateral_seats":"no","total_lateral_seats":0,"profile_id":"1","profile_name":"Basic","city":"no","state":"no","region":"no","mixed":"no","state_ids":"","city_ids":"","sequence":0,"features":"no","date":"2012-09-19 12:26:23","course_field":"no","featured_field":"","full_breakup":"breakup","top_rec_ids":"","course_specific_name":"","is_dept":"N","is_lateral":"N","lateral_fees":"","lateral_seats":0,"mint_rank_2015":0,"mint_rank_2016":0,"mint_rank_2017":0,"mint_rank_2018":0,"itoday_rank_2015":0,"itoday_rank_2016":0,"itoday_rank_2017":0,"itoday_rank_2018":0,"outlook_rank_2015":0,"outlook_rank_2016":0,"outlook_rank_2017":2,"outlook_rank_2018":0,"nirf_rank_2017":"0","nirf_rank_2018":"3","nirf_rank_2019":"","nirf_rank_2020":"5","branch_ids":"","start_date_apply":"","end_date_apply":"","is_apply_now":"Y","applynow_start_date":"","applynow_end_date":"","sr_rating":87,"pr_rating":0,"response_time_quater":500,"total_fees_sorting":314500,"is_cp_featured":"N","cp_state_ids":null,"is_cp_national":"N","pwd_reservation":"no","apply_link":"","is_grad":"N","fees_text":"","status":"active","course_type_2":"","apply_link2":"","highest_package":"","average_package":"","placement_rating":99,"campus_rating":88,"faculty_rating":50,"reputation_rating":91,"landing_page":"","course_details":"","created_at":null,"updated_at":null,"deleted_at":null,"tier":null}],"state_info":{"StateID":72,"CountryID":"2","State":"Delhi NCR","state_ipaddress_name":"National Capital Territory of Delhi","shortname":"delhi-ncr","Status":1,"region":"N","sequence":1,"top_other":"t","category":"A","priority":"A","mu_stateid":7,"gibs_stateid":10,"count_inst":456,"latitude":"28.6882438","longitude":"77.1212148"},"header_courses":[{"id":8891,"fees":"","institute_id":7350,"course_type":15,"sub_course_id":15,"aff_univ_id":"","duration":"3","duration_month":"0","duration_hours":"0","duration_day":"0","duration_year":"0","approved":"yes","mci_recog":"no","bci_app":"no","fulltime_partime":"yes","oncampus_distance":"yes","eligibility":"<p>\n\tCandidates shall be eligible for admission to the First Year of the Bachelors' Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.<\/p>","admission_dates":null,"tenth":"N","twelfth":"PCM","twelfth_marks":50,"grad":0,"grad_marks":0,"commencement":"6","commencement2":"","commencement3":"","examination_system":"Semester","criteria":{"162":{"id":162,"name":"NATA - Exam","display_name":"NATA","short_name":"nata","exam_image":"121213055959_nata.jpg","description":"National Aptitude Test in Architecture "}},"criteria_marks":"","admission_procedure":"","group_discussion":"N","personal_interview":"N","top_recruiters":"","sc_reservation":"no","st_reservation":"no","obc_reservation":"no","is_degree":"yes","total_seats":105,"show_seats":"no","show_lateral_seats":"no","total_lateral_seats":0,"profile_id":"1","profile_name":"Basic","city":"no","state":"no","region":"no","mixed":"no","state_ids":"","city_ids":"","sequence":0,"features":"no","date":"2012-09-19 12:26:23","course_field":"no","featured_field":"","full_breakup":"breakup","top_rec_ids":"","course_specific_name":"","is_dept":"N","is_lateral":"N","lateral_fees":"","lateral_seats":0,"mint_rank_2015":0,"mint_rank_2016":0,"mint_rank_2017":0,"mint_rank_2018":0,"itoday_rank_2015":0,"itoday_rank_2016":0,"itoday_rank_2017":0,"itoday_rank_2018":0,"outlook_rank_2015":0,"outlook_rank_2016":0,"outlook_rank_2017":2,"outlook_rank_2018":0,"nirf_rank_2017":"0","nirf_rank_2018":"3","nirf_rank_2019":"","nirf_rank_2020":"5","branch_ids":"","start_date_apply":"","end_date_apply":"","is_apply_now":"Y","applynow_start_date":"","applynow_end_date":"","sr_rating":87,"pr_rating":0,"response_time_quater":500,"total_fees_sorting":314500,"is_cp_featured":"N","cp_state_ids":null,"is_cp_national":"N","pwd_reservation":"no","apply_link":"","is_grad":"N","fees_text":"","status":"active","course_type_2":"","apply_link2":"","highest_package":"","average_package":"","placement_rating":99,"campus_rating":88,"faculty_rating":50,"reputation_rating":91,"landing_page":"","course_details":"","created_at":null,"updated_at":null,"deleted_at":null,"tier":null,"course_types":[{"id":15,"course_name":"B.Arch","sequence":13,"status":"Y","related_sub_course":0,"related_branch":0,"shortname":"architecture","alternate_name":"B.Arch","alternate_name2":"Bachelor of Architecture","header_name":"Architecture","price_category":"B","ug_pg":"UG","cat_type":"architecture_cat","duration":"5","session_starts":"July","show_degree_field":"yes","is_branches":"yes","default_show_branches":"yes","is_main":"N","course_specific":"","fees_calc":"t","affiliation":"COA Approved","logo":"sprite_arch","content":"-","colleges_num":"350","stream":"science","elig_12th":"Y","elig_marks_12th":"","elig_marks_grad":"","elig_grad_text":"","elig_12th_sub":"","elig_grad_ug_ids":"","further_pg_ids":"","alternate_course_ids":"","course_image":"150923060935_B.arch.jpg","course_category":4,"is_course_page":"Y","highest_package":"6","average_package":"3.6","cat_full_name":"Architecture","icon":"fa-building","eligibility_desc":"","category_new":1,"exams_num":null,"what_after":"","recruiters":"","career":"","further_studies":"","test_column":null}]},{"id":12674,"fees":"","institute_id":7350,"course_type":15,"sub_course_id":309,"aff_univ_id":"","duration":"4","duration_month":"0","duration_hours":"0","duration_day":"0","duration_year":"0","approved":"yes","mci_recog":"no","bci_app":"no","fulltime_partime":"yes","oncampus_distance":"yes","eligibility":"<p>\n\tCandidates shall be eligible for admission to the First Year of the Bachelors' Degree programme in Architecture and Planning if they have obtained at least 50% marks in aggregate, with Mathematics as a subject of the examination at the Higher Secondary or equivalent (10+2)level.<\/p>","admission_dates":null,"tenth":"N","twelfth":"PCM","twelfth_marks":50,"grad":0,"grad_marks":0,"commencement":"6","commencement2":"","commencement3":"","examination_system":"","criteria":{"162":{"id":162,"name":"NATA - Exam","display_name":"NATA","short_name":"nata","exam_image":"121213055959_nata.jpg","description":"National Aptitude Test in Architecture "}},"criteria_marks":"","admission_procedure":"","group_discussion":"N","personal_interview":"N","top_recruiters":"","sc_reservation":"no","st_reservation":"no","obc_reservation":"no","is_degree":"yes","total_seats":35,"show_seats":"no","show_lateral_seats":"no","total_lateral_seats":0,"profile_id":"1","profile_name":"Basic","city":"no","state":"no","region":"no","mixed":"no","state_ids":"","city_ids":"","sequence":0,"features":"no","date":"2013-08-08 15:32:06","course_field":"no","featured_field":"","full_breakup":"breakup","top_rec_ids":"","course_specific_name":"","is_dept":"N","is_lateral":"N","lateral_fees":"","lateral_seats":0,"mint_rank_2015":0,"mint_rank_2016":0,"mint_rank_2017":0,"mint_rank_2018":0,"itoday_rank_2015":0,"itoday_rank_2016":0,"itoday_rank_2017":0,"itoday_rank_2018":0,"outlook_rank_2015":0,"outlook_rank_2016":0,"outlook_rank_2017":0,"outlook_rank_2018":0,"nirf_rank_2017":"0","nirf_rank_2018":"0","nirf_rank_2019":"","nirf_rank_2020":"0","branch_ids":"","start_date_apply":"","end_date_apply":"","is_apply_now":"Y","applynow_start_date":"","applynow_end_date":"","sr_rating":91,"pr_rating":0,"response_time_quater":500,"total_fees_sorting":253600,"is_cp_featured":"N","cp_state_ids":null,"is_cp_national":"N","pwd_reservation":"no","apply_link":"","is_grad":"N","fees_text":"","status":"active","course_type_2":"","apply_link2":"","highest_package":"","average_package":"","placement_rating":99,"campus_rating":88,"faculty_rating":50,"reputation_rating":96,"landing_page":"","course_details":"","created_at":null,"updated_at":null,"deleted_at":null,"tier":null,"course_types":[{"id":15,"course_name":"B.Arch","sequence":13,"status":"Y","related_sub_course":0,"related_branch":0,"shortname":"architecture","alternate_name":"B.Arch","alternate_name2":"Bachelor of Architecture","header_name":"Architecture","price_category":"B","ug_pg":"UG","cat_type":"architecture_cat","duration":"5","session_starts":"July","show_degree_field":"yes","is_branches":"yes","default_show_branches":"yes","is_main":"N","course_specific":"","fees_calc":"t","affiliation":"COA Approved","logo":"sprite_arch","content":"-","colleges_num":"350","stream":"science","elig_12th":"Y","elig_marks_12th":"","elig_marks_grad":"","elig_grad_text":"","elig_12th_sub":"","elig_grad_ug_ids":"","further_pg_ids":"","alternate_course_ids":"","course_image":"150923060935_B.arch.jpg","course_category":4,"is_course_page":"Y","highest_package":"6","average_package":"3.6","cat_full_name":"Architecture","icon":"fa-building","eligibility_desc":"","category_new":1,"exams_num":null,"what_after":"","recruiters":"","career":"","further_studies":"","test_column":null}]}]}
1: %ked_review%
2: Y

Backtrace

14. app/Http/Controllers/CollegeController.php:2643
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(no_of_seats * duration)  + (select sum(total_seats * duration) from institute_courses where institute_id = 7350) as total FROM seats s INNER JOIN course_type ct ON ct.id = s.course_type and  institute_id = 7350

1.14msdb_collegesearchCollegeController.php#2656

Backtrace

10. app/Http/Controllers/CollegeController.php:2656
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 `inst_campaign_bharat_2022` where `institute_id` = 7350 and date(`start_date`) <= '2025-04-15' and date(`end_date`) >= '2025-04-15'

1.81msdb_collegesearchCollegeController.php#2682

Bindings	0: 7350 1: 2025-04-15 2: 2025-04-15
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/school-of-planning-architecture-spa-delhi/faculty' and `status` = 'Y' limit 1

1.99msdb_collegesearchCollegeController.php#2693

Bindings	0: colleges/school-of-planning-architecture-spa-delhi/faculty 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` = 7350 and `images`.`deleted_at` is null limit 1

1.05msdb_collegesearchInstitute.php#224

Bindings	0: 1 1: 7350
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 (162)

1.04msdb_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 (162)

790μsdb_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-faculty%' and `module_link_id` = 7350 and `expiry_date` > '2025-04-15 16:01:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

4.6msdb_collegesearchhelpers.php#1695

Bindings	0: 7350 1: 2025-04-15 16:01:49
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 ('162') and `expiry_date` > '2025-04-15 16:01:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

830μsdb_collegesearchhelpers.php#1712

Bindings	0: %exam% 1: 162 2: 2025-04-15 16:01:49
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 ('15') and `expiry_date` > '2025-04-15 16:01:49' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

1.09msdb_collegesearchhelpers.php#1726

Bindings	0: %course% 1: 15 2: 2025-04-15 16:01:49
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 `admin_reporting` where `admin_reporting`.`institute_id` = 7350 and `admin_reporting`.`institute_id` is not null

1.51msdb_collegesearchCollegeController.php#2749

Bindings	0: 7350
Backtrace	20. app/Http/Controllers/CollegeController.php:2749 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_faqs` where `institute_faqs`.`institute_id` = 7350 and `institute_faqs`.`institute_id` is not null

990μsdb_collegesearchCollegeController.php#2802

Bindings	0: 7350
Backtrace	20. app/Http/Controllers/CollegeController.php:2802 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 `ranks` where `ranks`.`institute_id` = 7350 and `ranks`.`institute_id` is not null

3msdb_collegesearchCollegeController.php#2835

Bindings	0: 7350
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` = 15 limit 1

820μsdb_collegesearchBreadcrumb.php#167

Bindings	0: 15
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 * from `collaboration` where `collaboration`.`institute_id` = 7350 and `collaboration`.`institute_id` is not null

1.46msdb_collegesearchCollegeController.php#2867

Bindings	0: 7350
Backtrace	19. app/Http/Controllers/CollegeController.php:2867 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` = 7350 and `institute_courses`.`institute_id` is not null limit 1

7.67msdb_collegesearchCollegeController.php#2877

Bindings	0: 7350
Backtrace	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 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 (162)

1.72msdb_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 (162)

1.97msdb_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` = 7350 and `user_reviews`.`institute_id` is not null

1.56msdb_collegesearchhero_section.blade.php#27

Bindings	0: 7350
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 `images` where `images`.`institute_id` = 7350 and `images`.`institute_id` is not null and `images`.`deleted_at` is null

4.36msdb_collegesearchhero_section.blade.php#266

Bindings	0: 7350
Backtrace	19. view::pages.college_v2.partials.hero_section:266 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 `user_reviews` where `user_reviews`.`institute_id` = 7350 and `user_reviews`.`institute_id` is not null

1.57msdb_collegesearchnavbar.blade.php#31

Bindings	0: 7350
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 `institute_faculty` where `institute_faculty`.`institute_id` = 7350 and `institute_faculty`.`institute_id` is not null

4.36msdb_collegesearchfaculty.blade.php#18

Bindings	0: 7350
Backtrace	19. view::pages.college_v2.faculty:18 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-faculty' and `brandings`.`deleted_at` is null

1.48msdb_collegesearchhelpers.php#970

Bindings	0: cp-inner-faculty
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: 23UserReview.php#?
App\Models\InstituteCourse: 15InstituteCourse.php#?
App\Models\Criteria: 10Criteria.php#?
App\Models\UserReviewsVoteUp: 6UserReviewsVoteUp.php#?
App\Models\Image: 5Image.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\Rank: 4Rank.php#?
App\Models\Collaboration: 3Collaboration.php#?
App\Models\Institute: 2Institute.php#?
App\Models\CourseType: 2CourseType.php#?
App\Models\State: 1State.php#?

_token: lN98TXhqE6LtovRM646ekaATqypidAl7EQ8L7c7X
_previous: array:1 [ "url" => "https://www.new.collegesearch.in/colleges/school-of-planning-architecture-spa-...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/colleges/school-of-planning-architecture-spa-delhi/faculty

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, 15 Apr 2025 10:31:49 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikc0SmE2Y1hGZUZUSmtnV1AzV1lVSlE9PSIsInZhbHVlIjoiby9pc09kVHE1OFBGdW9kbUZQbWZ1VkQwc0lKQ2dxenRBNlRuZi82YnhIRjhhak8yYnVnUEhKbDFwOGp2WU44blpXamlzQkk0NVdlaHZ4diswYW5uRnZLWVhDNzNPTm12b3BwY0Z0NWJGVWZmaWpSUmpxSE42SWc4eDZ3Q0dZRDYiLCJtYWMiOiI5YzMwMjZmMThiYTY5NjAyOTg3OWY2OTVlYzk4NjkzM2U2YmI0NmFlYjI4NzRiNjY0NjhhNzc2ZGI3ODQ5ODRmIiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 12:31:49 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ikc0SmE2Y1hGZUZUSmtnV1AzV1lVSlE9PSIsInZhbHVlIjoiby9pc09kVHE1OFBGdW9kbUZQbWZ1VkQwc0lKQ2dxenRBNlRuZi82YnhIRjhhak8yYnVnUEhKbDFwOGp2WU44blpXamlzQ ▶"
    1 => "cs_dev_session=eyJpdiI6IjV2YllmeGhDL21yVWdrZkRIb0FUeGc9PSIsInZhbHVlIjoiMFlKdmhxVHloL2FzbkRFTyt3NXlZRjJ0RkJUb2QwNWpzN1p1ajA2N1NFR2pLdUNIU2xwUzN2MDNBUnYra1FUYWFEU1BrcW5wUG82czVpYW5KL3VmRFptbmpKNnJORkk0aUpFbTZQRzlvQmtnYUZTTlRYV2tONVVzb0dpUU9rd0YiLCJtYWMiOiI5OTY1MGZkMjk4MzY2ZWZhZjc0YmQ5MzljOTdhZGQyYzdhMzk3MzA5NzAwYTJhZjY2ZWM5NDQ3NDdiMmYyY2I2IiwidGFnIjoiIn0%3D; expires=Tue, 15 Apr 2025 12:31:49 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IjV2YllmeGhDL21yVWdrZkRIb0FUeGc9PSIsInZhbHVlIjoiMFlKdmhxVHloL2FzbkRFTyt3NXlZRjJ0RkJUb2QwNWpzN1p1ajA2N1NFR2pLdUNIU2xwUzN2MDNBUnYra1FUYWFEU ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikc0SmE2Y1hGZUZUSmtnV1AzV1lVSlE9PSIsInZhbHVlIjoiby9pc09kVHE1OFBGdW9kbUZQbWZ1VkQwc0lKQ2dxenRBNlRuZi82YnhIRjhhak8yYnVnUEhKbDFwOGp2WU44blpXamlzQkk0NVdlaHZ4diswYW5uRnZLWVhDNzNPTm12b3BwY0Z0NWJGVWZmaWpSUmpxSE42SWc4eDZ3Q0dZRDYiLCJtYWMiOiI5YzMwMjZmMThiYTY5NjAyOTg3OWY2OTVlYzk4NjkzM2U2YmI0NmFlYjI4NzRiNjY0NjhhNzc2ZGI3ODQ5ODRmIiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 12:31:49 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikc0SmE2Y1hGZUZUSmtnV1AzV1lVSlE9PSIsInZhbHVlIjoiby9pc09kVHE1OFBGdW9kbUZQbWZ1VkQwc0lKQ2dxenRBNlRuZi82YnhIRjhhak8yYnVnUEhKbDFwOGp2WU44blpXamlzQ ▶"
    1 => "cs_dev_session=eyJpdiI6IjV2YllmeGhDL21yVWdrZkRIb0FUeGc9PSIsInZhbHVlIjoiMFlKdmhxVHloL2FzbkRFTyt3NXlZRjJ0RkJUb2QwNWpzN1p1ajA2N1NFR2pLdUNIU2xwUzN2MDNBUnYra1FUYWFEU1BrcW5wUG82czVpYW5KL3VmRFptbmpKNnJORkk0aUpFbTZQRzlvQmtnYUZTTlRYV2tONVVzb0dpUU9rd0YiLCJtYWMiOiI5OTY1MGZkMjk4MzY2ZWZhZjc0YmQ5MzljOTdhZGQyYzdhMzk3MzA5NzAwYTJhZjY2ZWM5NDQ3NDdiMmYyY2I2IiwidGFnIjoiIn0%3D; expires=Tue, 15-Apr-2025 12:31:49 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IjV2YllmeGhDL21yVWdrZkRIb0FUeGc9PSIsInZhbHVlIjoiMFlKdmhxVHloL2FzbkRFTyt3NXlZRjJ0RkJUb2QwNWpzN1p1ajA2N1NFR2pLdUNIU2xwUzN2MDNBUnYra1FUYWFEU ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "lN98TXhqE6LtovRM646ekaATqypidAl7EQ8L7c7X"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/school-of-planning-architecture-spa-delhi/faculty"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-15 16:01:49	GET	/colleges/school-of-planning-architecture-spa-delhi/faculty	1 14 50 76

1 x Application (95.94%)	345ms
1 x Booting (4.05%)	14.57ms