Avantika University Ujjain - Admission 2025, Courses, Fees, Review, 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  Public College

Avantika University, Ujjain

  • college search Ujjain, Madhya Pradesh
  • college search ESTD 2017
Avantika University , Ujjain
Avantika University , Ujjain
Avantika University, Ujjain
Avantika University , Ujjain campus
+8 Photos & Videos
Avantika University
Nisha Singh Avantika University
Updated on 28th February, 2023

Avantika University, Ujjain Highlights 2025

Particular Details
Year of establishment

2017
Approval

AICTE
Exams accepted

JEE Main

Website Avantika University
Total Number of courses offered

6 Courses

Avantika University Details

Avantika University was established in the academic year of 2017 in Ujjain, Madhya Pradesh. It is a private university and India’s first designed Centered University that has been promoted by MIT Group of Institutions, Pune that has proven the legacy of more than 38 years in the field of education. The university offers various programs at the undergraduate and postgraduate levels. These programs are primarily offered in the field of Design and Engineering.

  • The university has been recognized by the University of Grants Commission (UGC).

Avantika University Highlights

Particular

Details

University

Avantika University

Established in

2017

Recognized by

UGC

Approved by

AICTE

Exams Accepted

MITID DAT, D-ART, JEE Main

Courses Offered

Undergraduate and Postgraduate

Application Mode

Online

Admission Criteria

Entrance Exam Based

Highest Salary

INR 8 LPA

Top Recruiters

UX Reactor, Capgemini Pune, Futuring Design, TCS DISQ, Tata Motors, TouchMagix, DOMS

Facilities Available

Computer Center, Design Studio, Board Rooms, Library, Amphitheater, Sports Ground

Official Website

https://www.avantikauniversity.edu.in/index.php

Avantika University Courses

Avantika University Courses include programs at the undergraduate as well as postgraduate levels. These programs are primarily offered in the field of Design, and Engineering. Below mentioned are the programs offered by the university along with their eligibility criteria and duration:

Courses

Eligibility

Duration

B. Tech

A pass in 12th class with PCM securing at least 60% marks in aggregate from a recognized board

They must also possess a valid score in JEE Main Exam

4 years

B. Design

A pass in 12th class securing at least 50% marks in aggregate from a recognized board

They must also possess a valid score in MIT Pune DAT/ D ART

4 years

M. Design

A bachelor’s degree in the relevant field securing at least 50% marks in aggregate from a recognized board

They must also possess a valid score in MIT Pune DAT/ D ART

2 years

BBA

A pass in 12th class securing at least 60% marks in aggregate from a recognized board

Candidates must qualify State Entrance Exam

3 years

B. Sc.

A pass in 12th class securing at least 60% marks in aggregate from a recognized board

Candidates must qualify State Entrance Exam

3 years

Avantika University Admission

The application mode of Avantika University is online. Candidates seeking admission are required to fill the application form available on the official website of the university.

  • For admission to Design programs, candidates must possess a valid score in MIT Pune DAT or D-ART.
  • Candidates seeking admission to B. Tech must possess a valid score in JEE Main Exam or the State level entrance examination.
  • For admission to BBA or B. Sc, candidates must qualify the state level entrance examination.

How to Apply for Admission to Avantika University?

For admission to Design or Fashion programs, candidates must follow the below mentioned steps:

  • Candidates must apply for and appear in the MIT Pune DATE online design aptitude test.
  • Candidates will be shortlisted for the second round.
  • Problem solving assignment and assessment of design inclination.
  • Review and grading of students’ portfolios is done by the university.
  • Final result is declared by the university.

For engineering programs, candidates are required to follow the following steps:

  • Candidates must apply for and appear in the JEE Main Exam conducted at the national level.
  • Candidates must fill the online application form and submit it after making the payment of application fees.
  • Shortlisted candidates will be called for a personal interview round.
  • After their profiles are evaluated, the status of the application is communicated to the candidates.

Avantika University Admission

The internship and placement opportunities offered by the university are done through a strategic recruitment program. Students applying for the recruitment process will be allowed to showcase their skills and harness the technology and power of design.

  • The highest salary package offered by the university has been recorded to be INR 8 LPA.

Avantika University Placement Statistics:

Particular

Detail

International placements

5

Number of students placed

108

Number of companies hired

52

Number of Project opportunities

457

Some of the major recruiters of Avantika University include Capgemini, TCS, Wipro, Infosys, Cognizant, Tata Motors, Larsen & Tourbo, etc.

Awards

Awards

Diamond Band under "India Academic Rankings 2023"

Awarded Diamond Band under "India Academic Rankings 2023" By R World Institutional Ranking
Awards

Employability & Start Up Ecosystem Ranking 2023

Awarded Gold Band under "Employability & Start Up Ecosystem Ranking 2023" By R World Institutional Ranking
Awards

designing the 3-D model of “Mahakal Lok”

Awarded appreciation by the Higher Education Minister-Govt of Madhya Pradesh for the contribution in designing the 3-D model of “Mahakal Lok”.
Awards

Stakeholder’s Satisfaction Survey 2022

Awarded with Gold Band in Stakeholder’s Satisfaction Survey 2022-R World Institutional Ranking
Awards

Emerging University of Central India

Awarded with the “Emerging University of Central India” at the 24th World Education Summit in Hyderabad

Student's Rating for Avantika University , Ujjain

Student Reviews & Ratings
Avantika University

5/5

100% Positive reviews
Component Ratings
Write a Review >

Contact Details

Address

Ujjain, Madhya Pradesh, Ujjain, Madhya Pradesh, 456006

College Contact

91 - 77XXXXXX59

Email

adxxxns@xxxin

Get Contact Details

Avantika University , Ujjain

college search 5/5 (1 reviews)
Shortlist Download Brochure Brochure
Messages1TimelineExceptionsViews26RouteQueries58Models75MailsGateSessionRequest
Request history8.3.19PHP Version676msRequest Duration5MBMemory UsageGET colleges/{slug}Route
  • warninglog[05:38:13] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
  • Booting (10.76ms)time
  • Application (665ms)time
  • 1 x Application (98.41%)
    665ms
    1 x Booting (1.59%)
    10.76ms
    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
    58 statements were executed, 8 of which were duplicates, 50 unique. Show only duplicated384ms
    • 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/avantika_university' and `status` = 1 limit 1
      7.9msdb_collegesearchCacheService.php#460
      Bindings
      • 0: /colleges/avantika_university
      • 1: 1
      Backtrace
      • 15. app/Service/CacheService.php:460
      • 16. app/Service/CacheService.php:446
      • 17. middleware::softRedirects:76
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
      • 19. middleware::crossAppSync:53
    • select `is_cu_type`, `id` from `institutes` where (`status` = 'Active' and `ics_link_2` = 'avantika_university') limit 1
      2.16msdb_collegesearchCollegeController.php#52
      Bindings
      • 0: Active
      • 1: avantika_university
      Backtrace
      • 15. app/Http/Controllers/CollegeController.php:52
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `institutes`.*, (select count(*) from `images` where `institutes`.`id` = `images`.`institute_id` and `images`.`deleted_at` is null) as `images_count`, (select count(*) from `campus_videos` where `institutes`.`id` = `campus_videos`.`institute_id` limit 1) as `campus_video_count`, (select count(*) from `institute_faqs` where `institutes`.`id` = `institute_faqs`.`institute_id` and `section` = 'info') as `institute_faqs_count`, (select count(*) from `document` where `institutes`.`id` = `document`.`institute_id`) as `documents_count`, (select count(*) from `institute_courses` where `institutes`.`id` = `institute_courses`.`institute_id`) as `courses_count`, (select count(*) from `institute_insights` where `institutes`.`id` = `institute_insights`.`institute_id` and `status` = 'Y' and `institute_insights`.`deleted_at` is null) as `insights_count`, (select count(*) from `institute_toc` where `institutes`.`id` = `institute_toc`.`institute_id` and `institute_toc`.`deleted_at` is null) as `toc_count`, (select count(*) from `collection_desc` where `institutes`.`id` = `collection_desc`.`college_id` and `collection_id` > 43 and `college_desc` != '') as `collection_dess_count`, (select count(*) from `inst_latest_dev` where `institutes`.`id` = `inst_latest_dev`.`institute_id`) as `inst_latest_devs_count`, (select count(*) from `inst_articles` where `institutes`.`id` = `inst_articles`.`institute_id`) as `inst_articles_count`, (select count(*) from `institute_faculty` where `institutes`.`id` = `institute_faculty`.`institute_id`) as `institute_facultys_count`, (select count(*) from `institutes` as `laravel_reserved_0` where `institutes`.`old_univ_id` = `laravel_reserved_0`.`aff_univ_id` and (`aff_univ_id` != '' and `aff_univ_id` != 0 and `old_univ_id` != '' and `old_univ_id` != 0)) as `affiliate_count`, (select count(*) from `collaboration` where `institutes`.`id` = `collaboration`.`institute_id` and `type` in ('Alumni') and `description` != '') as `collaborations_count`, (select count(*) from `institute_impressions_data` where `institutes`.`id` = `institute_impressions_data`.`institute_id` and `location` = 'college_profile' and `date` > '2025-03-09 05:38:13') 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` = 'avantika_university' and `status` = 'Active' limit 1
      173msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: info
      • 1: Y
      • 2: 43
      • 3: 
      • 4: 
      • 5: 0
      • 6: 
      • 7: 0
      • 8: Alumni
      • 9: 
      • 10: college_profile
      • 11: 2025-03-09 05:38:13
      • 12: admitted
      • 13: avantika_university
      • 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` = 17103) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (17103) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6
      1.57msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 17103
      • 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 (1, 2, 184, 295, 758, 2644)
      660μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1
      • 1: 2
      • 2: 184
      • 3: 295
      • 4: 758
      • 5: 2644
      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 (1, 2, 7, 23, 33, 89)
      950μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1
      • 1: 2
      • 2: 7
      • 3: 23
      • 4: 33
      • 5: 89
      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 (1, 2, 7, 23, 33, 89) and `institute_id` = 17103 order by `year` desc
      1.15msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 17103
      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 (39521, 39522, 39524, 49366, 49368, 50678) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc
      2.13msdb_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 (17103)
      660μ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 (17103) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc
      1.55msdb_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 (17103) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      1.29msdb_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 (17103) and `institute_toc`.`deleted_at` is null order by `id` desc
      20.02msdb_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 (17103) 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
      860μsdb_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 (17103) and `status` = '1' order by `id` desc
      990μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `campus_videos` where `campus_videos`.`institute_id` in (17103) order by `id` desc limit 1
      500μsdb_collegesearchCollegeController.php#239
      Backtrace
      • 20. app/Http/Controllers/CollegeController.php:239
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `states` where `states`.`StateID` in (82)
      1.53msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 82
      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 (17103) and `status` = 'Active' limit 10
      6.17msdb_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 (57150) order by `vote_up` desc
      980μ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 (17103) 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
      890μ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 (17103) order by CASE WHEN type ='nirf' then 0 WHEN type ='itoday' then 1 WHEN type ='outlook' then 2 WHEN type ='mint' then 3 else 4 END asc, `course_type` asc, `year` desc
      1.07msdb_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 (17103) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc
      1.26msdb_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 (17103) order by `ID` desc limit 1
      2.47msdb_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 (198)
      2.05msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 198
      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 (198)
      3.21msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 198
      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 (17103)
      1.38msdb_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` = 17103 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc
      21.34msdb_collegesearchCollegeController.php#246
      Bindings
      • 0: 17103
      • 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` = 17103
      850μsdb_collegesearchCollegeController.php#248
      Bindings
      • 0: 17103
      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` = 17103 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.04msdb_collegesearchCollegeController.php#250
      Bindings
      • 0: 17103
      • 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 (39521, 39522, 39524, 49366, 49368, 50678) and (`round_id` = 1 and `status` = 1)
      4.23msdb_collegesearchCollegeController.php#268
      Bindings
      • 0: 39521
      • 1: 39522
      • 2: 39524
      • 3: 49366
      • 4: 49368
      • 5: 50678
      • 6: 1
      • 7: 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 (6482,3531,12) limit 12
      3msdb_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` = 17103
      2.45msdb_collegesearchCollegeController.php#316
      Bindings
      • 0: 17103
      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 (39521, 39522, 39524, 49366, 49368, 50678) and `placement_course`.`deleted_at` is null order by `year_placement` desc
      1.76msdb_collegesearchCollegeController.php#325
      Bindings
      • 0: 39521
      • 1: 39522
      • 2: 39524
      • 3: 49366
      • 4: 49368
      • 5: 50678
      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` = 17103 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc
      24.2msdb_collegesearchCollegeController.php#342
      Bindings
      • 0: 17103
      • 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` = 17103 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      4.02msdb_collegesearchCollegeController.php#345
      Bindings
      • 0: 17103
      • 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` = 17103 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.93msdb_collegesearchCollegeController.php#351
      Bindings
      • 0: 17103
      • 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` = 17103
      2.3msdb_collegesearchCollegeController.php#388
      Bindings
      • 0: 17103
      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` = 17103 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      2.38msdb_collegesearchCollegeController.php#415
      Bindings
      • 0: Active
      • 1: 17103
      • 2: 
      • 3: 
      • 4: 1
      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` = 17103 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      3.32msdb_collegesearchCollegeController.php#433
      Bindings
      • 0: Active
      • 1: 17103
      • 2: 
      • 3: 
      • 4: 1
      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` = 17103 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 1 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      830μsdb_collegesearchCollegeController.php#451
      Bindings
      • 0: Active
      • 1: 17103
      • 2: 
      • 3: 
      • 4: 1
      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` = 17103 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      930μsdb_collegesearchCollegeController.php#455
      Bindings
      • 0: 17103
      • 1: %ked_review%
      • 2: Y
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:455
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `metatags` where `PageID` = 'colleges/Avantika_University' and `status` = 'Y' limit 1
      1.7msdb_collegesearchCollegeController.php#549
      Bindings
      • 0: colleges/Avantika_University
      • 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` = 17103 and `institute_faqs`.`institute_id` is not null
      1.63msdb_collegesearchCollegeController.php#613
      Bindings
      • 0: 17103
      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` = 1 limit 1
      730μsdb_collegesearchBreadcrumb.php#167
      Bindings
      • 0: 1
      Backtrace
      • 15. app/Service/Breadcrumb.php:167
      • 16. app/Service/Breadcrumb.php:37
      • 17. app/Http/Controllers/CollegeController.php: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` = 17103 limit 1
      770μsdb_collegesearchCollegeController.php#637
      Bindings
      • 0: 17103
      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` = 17103 group by `course_type`.`id`
      11.93msdb_collegesearchCollegeController.php#658
      Bindings
      • 0: 17103
      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` = 17103 and date(`start_date`) <= '2025-04-09' and date(`end_date`) >= '2025-04-09'
      2.66msdb_collegesearchCollegeController.php#670
      Bindings
      • 0: 17103
      • 1: 2025-04-09
      • 2: 2025-04-09
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:670
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `institute_courses` where `institute_courses`.`institute_id` = 17103 and `institute_courses`.`institute_id` is not null limit 1
      1.49msdb_collegesearchCollegeController.php#672
      Bindings
      • 0: 17103
      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 (161)
      820μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 22. app/Http/Controllers/CollegeController.php:672
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (161)
      1.68msdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:672
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (161)
      2.87msdb_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 (161)
      1.83msdb_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` = 17103 and `expiry_date` > '2025-04-09 05:38:13' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      2.07msdb_collegesearchhelpers.php#1695
      Bindings
      • 0: 17103
      • 1: 2025-04-09 05:38:13
      Backtrace
      • 14. app/helpers.php:1695
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%exam%' and `module_link_id` in ('161') and `expiry_date` > '2025-04-09 05:38:13' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      1.74msdb_collegesearchhelpers.php#1712
      Bindings
      • 0: %exam%
      • 1: 161
      • 2: 2025-04-09 05:38:13
      Backtrace
      • 14. app/helpers.php:1712
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('1', '2', '7', '23', '33', '89') and `expiry_date` > '2025-04-09 05:38:13' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      710μsdb_collegesearchhelpers.php#1726
      Bindings
      • 0: %course%
      • 1: 1
      • 2: 2
      • 3: 7
      • 4: 23
      • 5: 33
      • 6: 89
      • 7: 2025-04-09 05:38:13
      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` = 17103 and `user_reviews`.`institute_id` is not null
      1.23msdb_collegesearchhero_section.blade.php#27
      Bindings
      • 0: 17103
      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` = 17103 and `user_reviews`.`institute_id` is not null
      1.24msdb_collegesearchnavbar.blade.php#31
      Bindings
      • 0: 17103
      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` = 17103 and `collaboration`.`institute_id` is not null
      920μsdb_collegesearchawards_v2.blade.php#2
      Bindings
      • 0: 17103
      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
      810μsdb_collegesearchhelpers.php#970
      Bindings
      • 0: cp
      Backtrace
      • 14. app/helpers.php:970
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
    App\Models\InstituteCourse
    25InstituteCourse.php#?
    App\Models\Image
    8Image.php#?
    App\Models\CourseType
    7CourseType.php#?
    App\Models\SubCourse
    6SubCourse.php#?
    App\Models\Collaboration
    5Collaboration.php#?
    App\Models\Document
    4Document.php#?
    App\Models\UserReview
    4UserReview.php#?
    App\Models\Criteria
    4Criteria.php#?
    App\Models\Institute
    2Institute.php#?
    App\Models\PlacementCourse
    2PlacementCourse.php#?
    App\Models\InstituteToc
    1InstituteToc.php#?
    App\Models\State
    1State.php#?
    App\Models\UserReviewsVoteUp
    1UserReviewsVoteUp.php#?
    App\Models\AdminReporting
    1AdminReporting.php#?
    App\Models\Admin
    1Admin.php#?
    App\Models\WriterProfile
    1WriterProfile.php#?
    App\Models\InstituteProfile
    1InstituteProfile.php#?
    App\Models\InstCampaign
    1InstCampaign.php#?
        _token
        5PL8CCbrR8sewLvUERTgAV9MoRgr6IVoJD0o4Tur
        _previous
        array:1 [ "url" => "https://www.new.collegesearch.in/colleges/avantika_university" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /colleges/avantika_university
        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 => "Wed, 09 Apr 2025 00:08:13 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdJZFgwbU0wT0x0YjJRNDUxOEhkQ1E9PSIsInZhbHVlIjoiNk5uNDFXcEV0dWhVZXVQKzNBVzhOT3BmRzM0RThZVnNXVHAwZXRaR29sdzUvTGlKMW5rSHBzaDJZQ09HWGhFdEIrajdiV2taTnhKa083TzVkWGFEWTZWaUVuU3RUZEFhUzlrN0R2ZlZzTlVxNm8xRkw1amNFQVlYd00walVPcHIiLCJtYWMiOiI0ZGNjMjA2MmZiYjg1NWZhZmZlYzc5ZjJjOTYzZWM2NDYxMWQ2NWI1MmNhMTcyZTczNjk0MTNhMDA0NWVlNzA3IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 02:08:14 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkdJZFgwbU0wT0x0YjJRNDUxOEhkQ1E9PSIsInZhbHVlIjoiNk5uNDFXcEV0dWhVZXVQKzNBVzhOT3BmRzM0RThZVnNXVHAwZXRaR29sdzUvTGlKMW5rSHBzaDJZQ09HWGhFdEIrajdiV ▶"
    1 => "cs_dev_session=eyJpdiI6ImtVMVN5R2JTTUpwanNwUWg0WCtncXc9PSIsInZhbHVlIjoiZUk2bDB1dE5zYzYyb3kyeWc1NzBPQ21KWjBJWEIrUHYrQXFQeEpFeHVNVmFST3R6MDd2bENDcnFWZ2JsSnNQcE1Va2MyTkZZVVB3SXYzSDBrQVpnN3FCVkZEUy9yQTc3WC80WHI0TERpL09UK3JRWTZFSlV6MVdsZ1I4SnJyOVgiLCJtYWMiOiI2MzVkMmQxZDQzMGYxMjA5MjE1ZDEwZDQyZjU3M2EzNmUzODNjODk0ZmYwNDA1OTE1MTI0N2M2ZDY2MjRmNjcyIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 02:08:14 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀cs_dev_session=eyJpdiI6ImtVMVN5R2JTTUpwanNwUWg0WCtncXc9PSIsInZhbHVlIjoiZUk2bDB1dE5zYzYyb3kyeWc1NzBPQ21KWjBJWEIrUHYrQXFQeEpFeHVNVmFST3R6MDd2bENDcnFWZ2JsSnNQcE1Va ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdJZFgwbU0wT0x0YjJRNDUxOEhkQ1E9PSIsInZhbHVlIjoiNk5uNDFXcEV0dWhVZXVQKzNBVzhOT3BmRzM0RThZVnNXVHAwZXRaR29sdzUvTGlKMW5rSHBzaDJZQ09HWGhFdEIrajdiV2taTnhKa083TzVkWGFEWTZWaUVuU3RUZEFhUzlrN0R2ZlZzTlVxNm8xRkw1amNFQVlYd00walVPcHIiLCJtYWMiOiI0ZGNjMjA2MmZiYjg1NWZhZmZlYzc5ZjJjOTYzZWM2NDYxMWQ2NWI1MmNhMTcyZTczNjk0MTNhMDA0NWVlNzA3IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 02:08:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkdJZFgwbU0wT0x0YjJRNDUxOEhkQ1E9PSIsInZhbHVlIjoiNk5uNDFXcEV0dWhVZXVQKzNBVzhOT3BmRzM0RThZVnNXVHAwZXRaR29sdzUvTGlKMW5rSHBzaDJZQ09HWGhFdEIrajdiV ▶"
    1 => "cs_dev_session=eyJpdiI6ImtVMVN5R2JTTUpwanNwUWg0WCtncXc9PSIsInZhbHVlIjoiZUk2bDB1dE5zYzYyb3kyeWc1NzBPQ21KWjBJWEIrUHYrQXFQeEpFeHVNVmFST3R6MDd2bENDcnFWZ2JsSnNQcE1Va2MyTkZZVVB3SXYzSDBrQVpnN3FCVkZEUy9yQTc3WC80WHI0TERpL09UK3JRWTZFSlV6MVdsZ1I4SnJyOVgiLCJtYWMiOiI2MzVkMmQxZDQzMGYxMjA5MjE1ZDEwZDQyZjU3M2EzNmUzODNjODk0ZmYwNDA1OTE1MTI0N2M2ZDY2MjRmNjcyIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 02:08:14 GMT; path=/; httponly ◀cs_dev_session=eyJpdiI6ImtVMVN5R2JTTUpwanNwUWg0WCtncXc9PSIsInZhbHVlIjoiZUk2bDB1dE5zYzYyb3kyeWc1NzBPQ21KWjBJWEIrUHYrQXFQeEpFeHVNVmFST3R6MDd2bENDcnFWZ2JsSnNQcE1Va ▶"
  ]
]
        session_attributes
          0 of 0   
        array:4 [▼
  "_token" => "5PL8CCbrR8sewLvUERTgAV9MoRgr6IVoJD0o4Tur"
  "_previous" => array:1 [▶
    "url" => "https://www.new.collegesearch.in/colleges/avantika_university"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-09 05:38:14GET/colleges/avantika_university1265875