ARCH College of Design & Business Jaipur - Admission 2025, Courses, Fees, Reviews, Placements | CollegeSearch

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
college search

Popular Colleges by Branches

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

Trending Search

college search

Top MBA Colleges in Delhi/NCR
college search

Top MBA Colleges in Bangalore
college search

Top Engineering Colleges in Delhi/NCR
college search

Top Engineering Colleges in Bangalore

No Result Found

college search  Private College

ARCH College of Design & Business, Jaipur

  • college search Jaipur, Rajasthan
  • college search ESTD 2000
ARCH College of Design & Business , Jaipur Top Header
ARCH College of Design & Business , Jaipur Event
ARCH College of Design & Business
Ritesh Srivastava ARCH College of Design & Business
Updated on 9th December, 2022

ARCH College of Design & Business, Jaipur Highlights 2025

Particular Details
Year of establishment

2000
Approval

AICTE
Website ARCH College of Design & Business
Total Number of courses offered

29 Courses

ARCH College of Design & Business Details

ARCH Institute of Design & Business commenced its establishment in 2000 by the Arch Educational Society. It is approved by the All India Council for Technical Education (AICTE) and affiliated with the University of Rajasthan and Rajasthan ILD Skill University. It offers UG, PG and Diploma courses in Fashion Design, Interior Design, Jewellery Design, Graphic, Digital, Photography and Product Design. Their flagship programs include B Des and M Vocational offered in several specializations.

ARCH Institute of Design & Business Highlights

Particular

Detail

College

ARCH Institute of Design & Business

Type

Private

Affiliated To

University of Rajasthan

Established in

2000

Approved By

AICTE

Admission mode

Online

Admission Criteria

Merit & Entrance Based

Entrance Accepted

AIEED (Conducted by Arch Institute of Design)

Courses Offered

UG - B Design, BBA Design, B Voc

PG - M. Voc

Recruiters

H&M, Lifestyle, Benetton, Shoppers Stop, Mangalam Arts, Amrapali, Gosil

Facilities

Cafe, Stitching & Embroidery Lab, Weaving Studio, Library, Seminar Hall, Stationery Shop

Admission Helpdesk

91 9351337770

Website

https://www.archedu.org/

ARCH Institute of Design & Business Courses

ARCH Institute of Design & Business offers diploma, undergraduate and postgraduate programs in Fashion Design, Interior Design, Jewellery Design, Graphic, Digital, Photography and Product Design. Courses are mentioned below along with its eligibility criteria and duration:

Courses

Eligibility

Duration

B Des

10+2 pass candidates + AIEED score

4 years

BA + MA in Design

4 years

BBA Design

3 years

M Voc

Graduate in any discipline

2 years

ARCH Institute of Design & Business Admission

Admission in Bachelor programs of ARCH Institute of Design & Business depends upon the All India Entrance Examination for design (AIEED) marks, an entrance conducted by the college. For postgraduate programs, admission is based on merit and last qualifying exam. Candidates will also need to undergo a screening process before counselling takes place and the offer letter for admission is sent.

How to Apply?

  • The application form is accepted through both online & offline mode.
  • Candidates must register themselves on the official website of the college to apply for admission.
  • Candidates must fill in all the details such as personal, educational, and other.
  • Process the payment of application fee through Debit/Credit Card or Demand Draft.
  • Keep a photocopy of the application form for future reference.
  • Courses that do not require an entrance test can also visit the campus for on the spot admission to their desired program.
  • Make sure to send a complete application form, otherwise it can lead to cancellation of the application.

ARCH organizes International Student & Staff Exchange Programme with following:

  • Middlesex University, London
  • De Montfort University, Leicester, UK
  • UDEM Universidad de Monterrey, Mexico
  • Teesside University, UK
  • Textila Gymnasiet in Stockholm, Sweden
  • University of Northampton
  • Ecole Boulle and Ecole Duperre, Paris, France

The campus is spread over an area of 60,000 sq. ft. with proximity to the World Trade Park and the Jaipur International Airport. The campus houses academic blocks, classrooms, library and resource center, auditorium, cafeteria, labs, hostels and many other facilities for the intellectual growth of the candidates.

Placements at ARCH:

The institutes provide 100 percent placement assistance and have developed as a centre of excellence in learning and innovation over time with more than 6,000 professionals and 2000 entrepreneurs in the industry. The average salary offered to the candidate varies between INR 4 Lakhs to INR 8 Lakhs per annum.

Scholarships at ARCH:

ARCH grants scholarships on the first come first served basis. According to the official website, once the scholarship is claimed, would not be considered for other students later. The candidate is required to fulfill all the requirements of scholarship before claiming it. The scholarship amount varies from INR 20,000 to INR 2,50,000.

Parameters for Scholarship:

  • AIEED Score of the candidate
  • Percentage in the Qualifying degree
  • Interview and Portfolio
  • Income status of the family
  • Ward of a single mother

Awards

Awards

Fiat Emozione Italiana

ARCH students Agantuk Singh, Pallavi Gupta, Ravi Ranjan, Sujit Kumar & Vinita Chandwani were the final five among 10 students selected.
Awards

Swarovski Elements Jewellery Design Award 2012

Rupal Gupta was a Finalist at the ‘Swarovski Elements Jewellery Design Award 2012’ with her piece ‘Medusa’
Awards

Fashion Design Awards India (FDAI)

Deepa Bhati won the ‘Fashion Design Awards India (FDAI)’ on the theme “Life is Beautiful. Her work was inspired from the Wall paintings of Amer Fort
Awards

World Gold Council Jewellery Design Award

Rita Burman won the ‘World Gold Council Jewellery Design Award’ for her Necklace and Earrings set
Awards

Society Interiors Design Award

Deepika Kumawat won the ‘Society Interiors Design Award’ for Tea-set holder inspired by Cycle

Student's Rating for ARCH College of Design & Business , Jaipur

Student Reviews & Ratings
ARCH College of Design & Business

4/5

83% Positive reviews
Component Ratings

Faculty Rating

college search   4.1

Internship/Placement Rating

college search   4.4

Infrastructure Rating

college search   3.6

Canteen Rating

college search   3.6

Hostel/Dorm Rating

college search   4.4

College Fest Rating

college search   4

Fashion Rating

college search   4.1

Sports Rating

college search   4.3

Write a Review >

Contact Details

Address

Plot No. 9, Govind Marg, Malviya Nagar Institutional Area, Malviya Nagar, Jaipur, Rajasthan, 302017

College Contact

0141 - 40XXXXXX78

Email

inxxxfo@xxxrg

Get Contact Details

ARCH College of Design & Business , Jaipur

college search 4/5 (6 reviews)
Shortlist Download Brochure Brochure
Messages1TimelineExceptionsViews26RouteQueries60Models173MailsGateSessionRequest
Request history8.3.19PHP Version674msRequest Duration5MBMemory UsageGET colleges/{slug}Route
  • warninglog[21:09:23] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
  • Booting (7ms)time
  • Application (667ms)time
  • 1 x Application (98.96%)
    667ms
    1 x Booting (1.04%)
    7.00ms
    26 templates were rendered
    • pages.college_v2.indexindex.blade.php#?blade
    • pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
    • pages.college_v2.partials.hero_sectionhero_section.blade.php#?blade
    • pages.college_v2.partials.navbarnavbar.blade.php#?blade
    • pages.college_v2.partials.popular_programpopular_program.blade.php#?blade
    • pages.college_v2.partials.admission_datesadmission_dates.blade.php#?blade
    • pages.college_v2.partials.cutoffcutoff.blade.php#?blade
    • pages.college_v2.partials.placementplacement.blade.php#?blade
    • pages.college_v2.partials.rankingranking.blade.php#?blade
    • pages.college_v2.partials.course_and_feecourse_and_fee.blade.php#?blade
    • pages.college_v2.partials.scholarshipscholarship.blade.php#?blade
    • pages.college_v2.partials.gallerygallery.blade.php#?blade
    • pages.college_v2.partials.facultyfaculty.blade.php#?blade
    • pages.college_v2.partials.awards_v2awards_v2.blade.php#?blade
    • pages.college_v2.partials.alumnialumni.blade.php#?blade
    • pages.college_v2.partials.partnershippartnership.blade.php#?blade
    • pages.college_v2.partials.review_sectionreview_section.blade.php#?blade
    • pages.college_v2.partials.deatailed_review_sectiondeatailed_review_section.blade.php#?blade
    • pages.college_v2.partials.contactcontact.blade.php#?blade
    • pages.college_v2.partials.right_side_clgright_side_clg.blade.php#?blade
    • pages.college_v2.partials.bottom_ctasbottom_ctas.blade.php#?blade
    • layouts.webweb.blade.php#?blade
    • partials.headhead.blade.php#?blade
    • partials.header_v2_mobileheader_v2_mobile.blade.php#?blade
    • partials.footerfooter.blade.php#?blade
    • pages.college_v2.partials.cp_breadcrumbcp_breadcrumb.blade.php#?blade
    uri
    GET colleges/{slug}
    middleware
    web, crossAppSync, softRedirects, AB
    domain
    www.new.collegesearch.in
    controller
    App\Http\Controllers\CollegeController@collegeProfile
    namespace
    prefix
    where
    as
    cp.collegeinfo
    file
    app/Http/Controllers/CollegeController.php:39-713
    60 statements were executed, 8 of which were duplicates, 52 unique. Show only duplicated477ms
    • 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/arch-academy-of-design-jaipur' and `status` = 1 limit 1
      14.27msdb_collegesearchCacheService.php#460
      Bindings
      • 0: /colleges/arch-academy-of-design-jaipur
      • 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` = 'arch-academy-of-design-jaipur' and `status` = 'Active' limit 1
      1.79msdb_collegesearchCacheService.php#492
      Bindings
      • 0: arch-academy-of-design-jaipur
      • 1: Active
      Backtrace
      • 15. app/Service/CacheService.php:492
      • 16. app/Service/CacheService.php:478
      • 17. middleware::softRedirects:88
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • 19. middleware::crossAppSync:53
    • select `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'arch-academy-of-design-jaipur') limit 1
      980μsdb_collegesearchCollegeController.php#52
      Bindings
      • 0: Active
      • 1: arch-academy-of-design-jaipur
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:52
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institutes`.*, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `campus_videos` where `institutes`.`id` = `campus_videos`.`institute_id` limit 1) as `campus_video_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` = 'info') as `institute_faqs_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institute_insights` where `institutes`.`id` = `institute_insights`.`institute_id` and `status` = 'Y' and `institute_insights`.`deleted_at` is null) as `insights_count`, (select count(*) from `institute_toc` where `institutes`.`id` = `institute_toc`.`institute_id` and `institute_toc`.`deleted_at` is null) as `toc_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institute_impressions_data` where `institutes`.`id` = `institute_impressions_data`.`institute_id` and `location` = 'college_profile' and `date` > '2025-03-07 21:09:23') as `institute_impressions_data_count`, (select count(*) from `requests_new` where `institutes`.`id` = `requests_new`.`institute_id`) as `requests_new_count`, (select count(*) from `student_status` where `institutes`.`id` = `student_status`.`institute_id` and `status` = 'admitted') as `student_status_count`, (select count(*) from `institutes` as `laravel_reserved_1` where `institutes`.`id` = `laravel_reserved_1`.`department_id`) as `departments_count` from `institutes` where `ics_link_2` = 'arch-academy-of-design-jaipur' and `status` = 'Active' limit 1
      187msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: info
      • 1: Y
      • 2: 43
      • 3: 
      • 4: 
      • 5: 0
      • 6: 
      • 7: 0
      • 8: Alumni
      • 9: 
      • 10: college_profile
      • 11: 2025-03-07 21:09:23
      • 12: admitted
      • 13: arch-academy-of-design-jaipur
      • 14: Active
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:239
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institute_courses`.*, (select count(*) from `institute_courses` as `laravel_reserved_2` where `institute_courses`.`course_type` = `laravel_reserved_2`.`course_type` and `institute_id` = 12475) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (12475) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6
      25.56msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 12475
      • 1: active
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `sub_course` where `sub_course`.`id` in (1771, 2206, 2211, 2219, 2274, 2275)
      1.83msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1771
      • 1: 2206
      • 2: 2211
      • 3: 2219
      • 4: 2274
      • 5: 2275
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `course_type` where `course_type`.`id` in (7, 19, 29, 30, 33, 49)
      1.77msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 7
      • 1: 19
      • 2: 29
      • 3: 30
      • 4: 33
      • 5: 49
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `ranks` where `ranks`.`course_type` in (7, 19, 29, 30, 33, 49) and `institute_id` = 12475 order by `year` desc
      870μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 12475
      Backtrace
      • 30. app/Http/Controllers/CollegeController.php:239
      • 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institute_course_id`, `h_package` as `highest_package`, `l_package` as `lowest_package`, `a_package` as `average_package`, `year_placement` as `year` from `placement_course` where `placement_course`.`institute_course_id` in (41557, 41561, 41562, 41571, 41906, 41907) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc
      840μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 
      • 1: 
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institute_id`, `name`, `first_page`, `title`, `doc_type` from `document` where `document`.`institute_id` in (12475)
      900μsdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_courses` where `institute_courses`.`institute_id` in (12475) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc
      14.56msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: active
      • 1: 
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_insights` where `institute_insights`.`institute_id` in (12475) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      750μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: Y
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_toc` where `institute_toc`.`institute_id` in (12475) and `institute_toc`.`deleted_at` is null order by `id` desc
      32.58msdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `images` where `images`.`institute_id` in (12475) and `student_featured` = 0 and `images`.`deleted_at` is null order by case when (is_featured = 1) then 0 when (category = 'campus') then 2 else 3 end, id desc
      1.5msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 0
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institute_id`, `video`, `description` from `video_verdict` where `video_verdict`.`institute_id` in (12475) and `status` = '1' order by `id` desc
      5.02msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `campus_videos` where `campus_videos`.`institute_id` in (12475) order by `id` desc limit 1
      1.18msdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `states` where `states`.`StateID` in (91)
      890μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 91
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `user_reviews`.`institute_id` in (12475) and `status` = 'Active' limit 10
      1.49msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: Active
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (43731, 43732, 44650, 45482, 45483, 64435) order by `vote_up` desc
      940μsdb_collegesearchCollegeController.php#239
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (12475) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc
      790μsdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `course_type`, `institute_id`, `rankings`, `year`, `type`, `out_of` from `ranks` where `ranks`.`institute_id` in (12475) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc, `year` desc
      720μsdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_courses` where `institute_courses`.`institute_id` in (12475) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc
      2.89msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: active
      • 1: yes
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select session_user_id , institute_id , date_format(ADDTIME(last_modified, '5:30'),'%D %M, %Y') as last_modifi from `admin_reporting` where `admin_reporting`.`institute_id` in (12475) order by `ID` desc limit 1
      1.19msdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `admin` where `admin`.`ID` in (178)
      880μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 178
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `writers_profile` where `writers_profile`.`admin_id` in (178)
      1.15msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 178
      Backtrace
      • 30. app/Http/Controllers/CollegeController.php:239
      • 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (12475)
      1.98msdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 12475 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.54msdb_collegesearchCollegeController.php#246
      Bindings
      • 0: 12475
      • 1: admission
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:246
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id` from `institute_courses` where `institute_id` = 12475
      3.92msdb_collegesearchCollegeController.php#248
      Bindings
      • 0: 12475
      Backtrace
      • 13. app/Http/Controllers/CollegeController.php:248
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 12475 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc
      26.71msdb_collegesearchCollegeController.php#250
      Bindings
      • 0: 12475
      • 1: cutoff
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:250
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `cutoff_new_shagun_json` where `institute_course_id` in (41557, 41558, 41559, 41560, 41561, 41562, 41563, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41577, 41578, 41579, 41580, 41581, 41582, 41906, 41907, 41908, 41909, 44133) and (`round_id` = 1 and `status` = 1)
      3.76msdb_collegesearchCollegeController.php#268
      Bindings
      • 0: 41557
      • 1: 41558
      • 2: 41559
      • 3: 41560
      • 4: 41561
      • 5: 41562
      • 6: 41563
      • 7: 41565
      • 8: 41566
      • 9: 41567
      • 10: 41568
      • 11: 41569
      • 12: 41570
      • 13: 41571
      • 14: 41572
      • 15: 41573
      • 16: 41574
      • 17: 41575
      • 18: 41577
      • 19: 41578
      • 20: 41579
      • 21: 41580
      • 22: 41581
      • 23: 41582
      • 24: 41906
      • 25: 41907
      • 26: 41908
      • 27: 41909
      • 28: 44133
      • 29: 1
      • 30: 1
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:268
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select top_recruiter.name,ro.name as org_name,ri.name as industry_name , rc.city_name ,image, webp_image from top_recruiter left JOIN recruiter_organization ro on top_recruiter.recuiter_organization_id = ro.id left JOIN recruiter_industry ri on top_recruiter.recuiter_industry_id = ri.id left JOIN city rc on top_recruiter.city_id = rc.id WHERE top_recruiter.id IN (3512,6179,3701,3097,2648,6308,5126,6422) limit 12
      28.14msdb_collegesearchCollegeController.php#297
      Backtrace
      • 10. app/Http/Controllers/CollegeController.php:297
      • 11. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 12. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id` from `institute_courses` where `institute_id` = 12475
      830μsdb_collegesearchCollegeController.php#316
      Bindings
      • 0: 12475
      Backtrace
      • 13. app/Http/Controllers/CollegeController.php:316
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `h_package`, `l_package`, `a_package`, `ic`.`id`, `ic`.`course_type`, `ct`.`alternate_name` as `ctype`, `year_placement` from `placement_course` left join `institute_courses` as `ic` on `ic`.`id` = `placement_course`.`institute_course_id` left join `course_type` as `ct` on `ct`.`id` = `ic`.`course_type` where `institute_course_id` in (41557, 41558, 41559, 41560, 41561, 41562, 41563, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41577, 41578, 41579, 41580, 41581, 41582, 41906, 41907, 41908, 41909, 44133) and `placement_course`.`deleted_at` is null order by `year_placement` desc
      1.61msdb_collegesearchCollegeController.php#325
      Bindings
      • 0: 41557
      • 1: 41558
      • 2: 41559
      • 3: 41560
      • 4: 41561
      • 5: 41562
      • 6: 41563
      • 7: 41565
      • 8: 41566
      • 9: 41567
      • 10: 41568
      • 11: 41569
      • 12: 41570
      • 13: 41571
      • 14: 41572
      • 15: 41573
      • 16: 41574
      • 17: 41575
      • 18: 41577
      • 19: 41578
      • 20: 41579
      • 21: 41580
      • 22: 41581
      • 23: 41582
      • 24: 41906
      • 25: 41907
      • 26: 41908
      • 27: 41909
      • 28: 44133
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:325
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 12475 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc
      18.12msdb_collegesearchCollegeController.php#342
      Bindings
      • 0: 12475
      • 1: placement
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:342
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc` from `institute_insights` where `institute_id` = 12475 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      1.39msdb_collegesearchCollegeController.php#345
      Bindings
      • 0: 12475
      • 1: key_highlights_placement
      • 2: Y
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:345
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc` from `institute_toc` where `institute_id` = 12475 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc
      18.83msdb_collegesearchCollegeController.php#351
      Bindings
      • 0: 12475
      • 1: ranking
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:351
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select (SUM(CASE WHEN (overall_rating = '5.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS excellent_count, (SUM(CASE WHEN (overall_rating = '4.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS good_count, (SUM(CASE WHEN (overall_rating = '3.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS average_count, (SUM(CASE WHEN (overall_rating = '2.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS bad_count, (SUM(CASE WHEN (overall_rating = '1.0' AND status = 'Active') THEN 1 ELSE 0 END)) AS worst_count, (SUM(CASE WHEN status = 'Rejected' THEN 1 ELSE 0 END)) AS rejected_review, (SUM(CASE WHEN (fashion_rating >0 AND fashion_rating != '' AND status = 'Active') THEN fashion_rating ELSE 0 END)) AS fashion_review_average, (SUM(CASE WHEN (sports_rating >0 AND sports_rating != '' AND status = 'Active') THEN sports_rating ELSE 0 END)) AS sports_review_average, (SUM(CASE WHEN (event_rating >0 AND event_rating != '' AND status = 'Active') THEN event_rating ELSE 0 END)) AS event_review_average, (SUM(CASE WHEN (hostel_rating >0 AND hostel_rating != '' AND status = 'Active') THEN hostel_rating ELSE 0 END)) AS hostel_review_average, (SUM(CASE WHEN (canteen_rating >0 AND canteen_rating != '' AND status = 'Active') THEN canteen_rating ELSE 0 END)) AS canteen_review_average, (SUM(CASE WHEN (infra_rating >0 AND status = 'Active') THEN infra_rating ELSE 0 END)) AS infra_review_average, (SUM(CASE WHEN (intern_rating >0 AND status = 'Active') THEN intern_rating ELSE 0 END)) AS intern_review_average, (SUM(CASE WHEN (teacher_rating >0 AND status = 'Active') THEN teacher_rating ELSE 0 END)) AS teacher_review_average, (SUM(CASE WHEN (admission_rating >0 AND status = 'Active') THEN admission_rating ELSE 0 END)) AS admission_review_average, (SUM(CASE WHEN (infra_rating > 0 AND infra_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS infra_review_count, (SUM(CASE WHEN (intern_rating > 0 AND intern_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS intern_review_count, (SUM(CASE WHEN (admission_rating > 0 AND admission_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS admission_review_count, (SUM(CASE WHEN (teacher_rating > 0 AND teacher_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS teacher_rating_count, (SUM(CASE WHEN (fashion_rating > 0 AND fashion_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS fashion_review_count, (SUM(CASE WHEN (sports_rating > 0 AND sports_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS sports_review_count, (SUM(CASE WHEN (event_rating > 0 AND event_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS event_review_count, (SUM(CASE WHEN (hostel_rating > 0 AND hostel_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS hostel_review_count, (SUM(CASE WHEN (canteen_rating > 0 AND canteen_rating !='' AND status = 'Active') THEN 1 ELSE 0 END)) AS canteen_review_count from `user_reviews` where `institute_id` = 12475
      1.11msdb_collegesearchCollegeController.php#388
      Bindings
      • 0: 12475
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:388
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 12475 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 7 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      1.48msdb_collegesearchCollegeController.php#415
      Bindings
      • 0: Active
      • 1: 12475
      • 2: 
      • 3: 
      • 4: 7
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:415
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `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` = 12475 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 7 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      1.01msdb_collegesearchCollegeController.php#433
      Bindings
      • 0: Active
      • 1: 12475
      • 2: 
      • 3: 
      • 4: 7
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:433
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `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` = 12475 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 7 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      2.95msdb_collegesearchCollegeController.php#451
      Bindings
      • 0: Active
      • 1: 12475
      • 2: 
      • 3: 
      • 4: 7
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:451
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 12475 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      960μsdb_collegesearchCollegeController.php#455
      Bindings
      • 0: 12475
      • 1: %ked_review%
      • 2: Y
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:455
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `cutoff_new_shagun_json` left join `institute_courses` on `institute_courses`.`id` = `cutoff_new_shagun_json`.`institute_course_id` where `institute_id` = 12475
      4.19msdb_collegesearchCollegeController.php#477
      Bindings
      • 0: 12475
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:477
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `name` from `images` where `is_desktop` = 1 and `institute_id` = 12475 and `images`.`deleted_at` is null limit 1
      730μsdb_collegesearchInstitute.php#210
      Bindings
      • 0: 1
      • 1: 12475
      Backtrace
      • 15. app/Models/Institute.php:210
      • 16. app/Http/Controllers/CollegeController.php:527
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `name` from `images` where `is_desktop` = 1 and `institute_id` = 12475 and `images`.`deleted_at` is null limit 1
      1msdb_collegesearchInstitute.php#224
      Bindings
      • 0: 1
      • 1: 12475
      Backtrace
      • 15. app/Models/Institute.php:224
      • 16. app/Http/Controllers/CollegeController.php:536
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select * from `metatags` where `PageID` = 'colleges/arch-academy-of-design-jaipur' and `status` = 'Y' limit 1
      900μsdb_collegesearchCollegeController.php#549
      Bindings
      • 0: colleges/arch-academy-of-design-jaipur
      • 1: Y
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:549
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_faqs` where `institute_faqs`.`institute_id` = 12475 and `institute_faqs`.`institute_id` is not null
      880μsdb_collegesearchCollegeController.php#613
      Bindings
      • 0: 12475
      Backtrace
      • 19. app/Http/Controllers/CollegeController.php:613
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `header_name` from `course_type` where `id` = 7 limit 1
      710μsdb_collegesearchBreadcrumb.php#167
      Bindings
      • 0: 7
      Backtrace
      • 15. app/Service/Breadcrumb.php:167
      • 16. app/Service/Breadcrumb.php:37
      • 17. app/Http/Controllers/CollegeController.php:631
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `is_sunstone` from `inst_campaign_bharat_2022` where `institute_id` = 12475 limit 1
      1.76msdb_collegesearchCollegeController.php#637
      Bindings
      • 0: 12475
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:637
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institute_courses`.`course_type`, `course_type`.`course_name`, `course_type`.`id`, `sub_course`.`sub_course_url` from `institute_courses` inner join `course_type` on `institute_courses`.`course_type` = `course_type`.`id` inner join `sub_course` on `institute_courses`.`course_type` = `sub_course`.`course_type_id` where `institute_id` = 12475 group by `course_type`.`id`
      12.07msdb_collegesearchCollegeController.php#658
      Bindings
      • 0: 12475
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:658
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `inst_campaign_bharat_2022` where `institute_id` = 12475 and date(`start_date`) <= '2025-04-07' and date(`end_date`) >= '2025-04-07'
      1.6msdb_collegesearchCollegeController.php#670
      Bindings
      • 0: 12475
      • 1: 2025-04-07
      • 2: 2025-04-07
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:670
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_courses` where `institute_courses`.`institute_id` = 12475 and `institute_courses`.`institute_id` is not null limit 1
      1.06msdb_collegesearchCollegeController.php#672
      Bindings
      • 0: 12475
      Backtrace
      • 21. app/Http/Controllers/CollegeController.php:672
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2086)
      990μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:693
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (2086)
      580μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:694
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where modulename like '%cp-info%' and `module_link_id` = 12475 and `expiry_date` > '2025-04-07 21:09:24' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      1.59msdb_collegesearchhelpers.php#1695
      Bindings
      • 0: 12475
      • 1: 2025-04-07 21:09:24
      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 ('2086') and `expiry_date` > '2025-04-07 21:09:24' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      1.29msdb_collegesearchhelpers.php#1712
      Bindings
      • 0: %exam%
      • 1: 2086
      • 2: 2025-04-07 21:09:24
      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 ('7', '19', '29', '30', '33', '49') and `expiry_date` > '2025-04-07 21:09:24' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      860μsdb_collegesearchhelpers.php#1726
      Bindings
      • 0: %course%
      • 1: 7
      • 2: 19
      • 3: 29
      • 4: 30
      • 5: 33
      • 6: 49
      • 7: 2025-04-07 21:09:24
      Backtrace
      • 14. app/helpers.php:1726
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `user_reviews` where `user_reviews`.`institute_id` = 12475 and `user_reviews`.`institute_id` is not null
      1.13msdb_collegesearchhero_section.blade.php#27
      Bindings
      • 0: 12475
      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` = 12475 and `user_reviews`.`institute_id` is not null
      1.12msdb_collegesearchnavbar.blade.php#31
      Bindings
      • 0: 12475
      Backtrace
      • 19. view::pages.college_v2.partials.navbar:31
      • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select * from `collaboration` where `collaboration`.`institute_id` = 12475 and `collaboration`.`institute_id` is not null
      6.04msdb_collegesearchawards_v2.blade.php#2
      Bindings
      • 0: 12475
      Backtrace
      • 19. view::pages.college_v2.partials.awards_v2:2
      • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp' and `brandings`.`deleted_at` is null
      3.46msdb_collegesearchhelpers.php#970
      Bindings
      • 0: cp
      Backtrace
      • 14. app/helpers.php:970
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    App\Models\InstituteCourse
    75InstituteCourse.php#?
    App\Models\PlacementCourse
    34PlacementCourse.php#?
    App\Models\UserReview
    19UserReview.php#?
    App\Models\Collaboration
    8Collaboration.php#?
    App\Models\CourseType
    7CourseType.php#?
    App\Models\UserReviewsVoteUp
    6UserReviewsVoteUp.php#?
    App\Models\SubCourse
    5SubCourse.php#?
    App\Models\InstituteFaqs
    5InstituteFaqs.php#?
    App\Models\Image
    4Image.php#?
    App\Models\Institute
    2Institute.php#?
    App\Models\Criteria
    2Criteria.php#?
    App\Models\Document
    1Document.php#?
    App\Models\InstituteToc
    1InstituteToc.php#?
    App\Models\State
    1State.php#?
    App\Models\AdminReporting
    1AdminReporting.php#?
    App\Models\Admin
    1Admin.php#?
    App\Models\InstituteProfile
    1InstituteProfile.php#?
        _token
        sts9CVF53fpgtVGpQr5j9SS0NuMStooAcoKPZjbX
        _previous
        array:1 [ "url" => "https://www.new.collegesearch.in/colleges/arch-academy-of-design-jaipur" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /colleges/arch-academy-of-design-jaipur
        status_code
        200
        status_text
        OK
        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 15:39:24 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVvUGUvRVhteG5vK1BiVjRKM0ZQRlE9PSIsInZhbHVlIjoiSlhBaEpkTzVoY0lJaElaQnRBWnh1TVBFWCt5dzdmYlh4SU50NGdnb1B0R2JFQ2h6MWFqL1JjeFhiZDJSaFJBMGNvdk1aakt3SEVoa3JhZEJoQml5eGIzNG9GdW1MdE10akg1eDF0RlhGcEZlZ3N0WllJREtTL0ZHMDFJRFBYY3YiLCJtYWMiOiI2OGJkZjk0NWNjYTAwMWM1NGNjOWJhMGYzZTdmMTNkZWRmNjgyY2M1NmNlZTQzYzk3ZmQ1NWFkZGE0MDg0Njc4IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 17:39:24 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InVvUGUvRVhteG5vK1BiVjRKM0ZQRlE9PSIsInZhbHVlIjoiSlhBaEpkTzVoY0lJaElaQnRBWnh1TVBFWCt5dzdmYlh4SU50NGdnb1B0R2JFQ2h6MWFqL1JjeFhiZDJSaFJBMGNvdk1aa ▶"
    1 => "cs_dev_session=eyJpdiI6IlRWVTJNcmVHTzI4dXlkUUk1b0JvdWc9PSIsInZhbHVlIjoiVFBLbG9mK2hWdmx0TEpwN2tsZVg2b0xsSWIxa1F4UmdCNVBnM1BCYU8xWlVhVlhHajkrSjRlUC9PTXJlc2YxYmRoZTY4RDRIcFV2aW5rL3A2enpMUGlDMkhQNlJvcTBwTkpjTm12ZnFxaXA4UGgxYWtMN2xpczdRN0NWSi94MUUiLCJtYWMiOiJhOGFmZTVmYzg4NzY4MWI0MjZkYjVmMzQxNjI4YWQzYjU3MzVmNmJhZWI4YTk2YWQ2OTQ5YmZkMmRiMDlhYzI3IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 17:39:24 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6IlRWVTJNcmVHTzI4dXlkUUk1b0JvdWc9PSIsInZhbHVlIjoiVFBLbG9mK2hWdmx0TEpwN2tsZVg2b0xsSWIxa1F4UmdCNVBnM1BCYU8xWlVhVlhHajkrSjRlUC9PTXJlc2YxYmRoZ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVvUGUvRVhteG5vK1BiVjRKM0ZQRlE9PSIsInZhbHVlIjoiSlhBaEpkTzVoY0lJaElaQnRBWnh1TVBFWCt5dzdmYlh4SU50NGdnb1B0R2JFQ2h6MWFqL1JjeFhiZDJSaFJBMGNvdk1aakt3SEVoa3JhZEJoQml5eGIzNG9GdW1MdE10akg1eDF0RlhGcEZlZ3N0WllJREtTL0ZHMDFJRFBYY3YiLCJtYWMiOiI2OGJkZjk0NWNjYTAwMWM1NGNjOWJhMGYzZTdmMTNkZWRmNjgyY2M1NmNlZTQzYzk3ZmQ1NWFkZGE0MDg0Njc4IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 17:39:24 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVvUGUvRVhteG5vK1BiVjRKM0ZQRlE9PSIsInZhbHVlIjoiSlhBaEpkTzVoY0lJaElaQnRBWnh1TVBFWCt5dzdmYlh4SU50NGdnb1B0R2JFQ2h6MWFqL1JjeFhiZDJSaFJBMGNvdk1aa ▶"
    1 => "cs_dev_session=eyJpdiI6IlRWVTJNcmVHTzI4dXlkUUk1b0JvdWc9PSIsInZhbHVlIjoiVFBLbG9mK2hWdmx0TEpwN2tsZVg2b0xsSWIxa1F4UmdCNVBnM1BCYU8xWlVhVlhHajkrSjRlUC9PTXJlc2YxYmRoZTY4RDRIcFV2aW5rL3A2enpMUGlDMkhQNlJvcTBwTkpjTm12ZnFxaXA4UGgxYWtMN2xpczdRN0NWSi94MUUiLCJtYWMiOiJhOGFmZTVmYzg4NzY4MWI0MjZkYjVmMzQxNjI4YWQzYjU3MzVmNmJhZWI4YTk2YWQ2OTQ5YmZkMmRiMDlhYzI3IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 17:39:24 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6IlRWVTJNcmVHTzI4dXlkUUk1b0JvdWc9PSIsInZhbHVlIjoiVFBLbG9mK2hWdmx0TEpwN2tsZVg2b0xsSWIxa1F4UmdCNVBnM1BCYU8xWlVhVlhHajkrSjRlUC9PTXJlc2YxYmRoZ ▶"
  ]
]
        session_attributes
          0 of 0   
        array:4 [▼
  "_token" => "sts9CVF53fpgtVGpQr5j9SS0NuMStooAcoKPZjbX"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/arch-academy-of-design-jaipur"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-07 21:09:24GET/colleges/arch-academy-of-design-jaipur12660173