Indian Institute of Tourism and Travel Management, Noida: Admission 2025, Courses, Fees
college search  Public College

Indian Institute of Tourism and Travel Management (IITTM), Noida

  • college search Noida, Uttar Pradesh
  • college search ESTD 1983
Indian Institute of Tourism and Travel Management (IITTM) , Noida  campus
Indian Institute of Tourism and Travel Management (IITTM) , Noida  campus
Indian Institute of Tourism and Travel Management (IITTM), Noida campus
Indian Institute of Tourism and Travel Management (IITTM) , Noida campus
+8 Photos & Videos
Indian Institute of Tourism and Travel Management (IITTM)
Rachna Jha Indian Institute of Tourism and Travel Management (IITTM)

Indian Institute of Tourism and Travel Management (IITTM) , Noida Highlights 2025

IITTM Noida Highlights

Particular

Detail

College

Indian Institute of Tourism and Travel Management (IITTM)

Establishment Year | Type

2007 | Public

Approved By

UGC

Affiliated To 

Indira Gandhi National Tribal University

Admission mode

Online 

Admission Criteria

Entrance-Based and Merit-Based

Entrance Accepted

CAT/CMAT/GMAT/MAT/XAT/ATMA

Courses Offered

UG - BBA

PG -  MBA

Top Recruiters

Goibibo, Yatra, Makemytrip, IRCTC, Travel Guru, Zenith, Nexus

Facilities 

Hostel, Computer Lab, Classrooms, Library

Website

https://www.iittmnoida.ac.in/

IITTM Noida Key Facts:

  • IITTM Noida boasts a renowned faculty with extensive experience in their respective fields. 
  • IITTM Noida recognizes the dynamic nature of the tourism industry and keeps its curriculum adaptable and relevant.
  • IITTM Noida actively fosters connections with industries that provide students with valuable research opportunities and open doors to exciting internships and placement prospects. 
  • IITTM Noida boasts excellent infrastructure, that provides students with modern resources and facilities to enhance their learning experience. 
  • IITM Noida involves an online application, while postgraduate programs typically require candidates to appear for entrance exams like CAT, MAT, or XAT. For the MBA program, the institute conducts its own entrance exam IIAT. 

IITTM Noida Courses

IITTM Noida courses include a BBA in Tourism and Travel and an MBA in Tourism. The courses are mentioned below along with their eligibility criteria and duration: 

 

Courses

Eligibility

Duration

BBA (Tourism & Travel)

10+2 in any stream with a minimum of 50%

3 years

MBA (Tourism & Travel Management)

Graduation in any discipline with a minimum of 50%

 

A valid score in CAT/CMAT/GMAT/MAT/XAT/ATMA

2 years

 

Read More

Indian Institute of Tourism and Travel Management (IITTM) , Noida Admission 2024

IITTM Noida Admissions 2024

IITTM Noida seeks admission based on merit and entrance examination. MBA requires a valid score in any of these exams, CAT, CMAT, GMAT, XAT, MAT, ATMA, or IIAT (examination conducted by the college).

How To Apply?

Step 1 - Interested candidates can apply to the college by registering on its official website.

Step 2 - Candidates must fill in all the details and upload recent scanned passport-size color photographs and scanned signatures.

Step 3 - Process the payment of the application fee through Debit/Credit Card/Bank Transfer.

Step 4 - Keep a photocopy of the application form for future reference.

Step 5 - Make sure to send a complete application form, otherwise it can lead to cancellation of the application.

Step 6 - Shortlisted candidates will be contacted for counseling through mail or message.

Indian Institute of Tourism and Travel Management (IITTM) , Noida Placement Details

IITTM Noida Placements

Most of the students are placed by some of the leading recruiters in the tourism, travel, and service sectors. IITTM Noida has a solid reputation for placement in all of its previous batches. Some of its top recruiters are given below:

Top Recruiters

FICCI

Tripver

Social Buzz

Back Pack Clan

All Ok Done

Zostel

Aitheworld.com

My Value Travel

Wander On

India Hikes

Holiday Experts 

Capture a Trip

Course Wise Highest Salary

Course Wise Avg Salary

Indian Institute of Tourism and Travel Management (IITTM), Noida Top Recruiters

Thomas Cook Thomas Cook
IRCTC IRCTC
Yatra Online Pvt Ltd Yatra Online Pvt Ltd
View All Recruiters Details

Indian Institute of Tourism and Travel Management (IITTM) Placement 2025 Sector-Wise Recruiters , Noida

Student's Rating for Indian Institute of Tourism and Travel Management (IITTM) , Noida

Student Reviews & Ratings
Indian Institute of Tourism and Travel Management (IITTM)

4.8/5

100% Positive reviews
Component Ratings

Faculty Rating

college search   4.8

Internship/Placement Rating

college search   5

Infrastructure Rating

college search   4.7

Canteen Rating

college search   7

Hostel/Dorm Rating

college search   4.5

College Fest Rating

college search   4.2

Fashion Rating

college search   5

Sports Rating

college search   3.8

Write a Review >

Student's Reviews for Indian Institute of Tourism and Travel Management (IITTM) , Noida

Placement
Faculty

college search   5

13-04-2018
S

Sriharsha HK
MBA / PGDM Student

college search  5.0 Canteen

college search  5.0 Infrastructure

college search  2.5 Sports

college search  3.0 Events

college search  2.5 Society / Clubs

college search  5.0 PG

college search  4.0 Hostel

college search  5.0 Internship/Placement

college search  5.0 Faculty

A review on the MBA (Travel & Tourism) course at IITTM Noida

Placement: * More than reading my words, I urge you to read this article by the director of IITTM, Mr.Sandeep Kulshreshta to know what you can do in the Tourism industry here - (http://www.iittm.ac.in/New%20Dos/Career_in_Tourism%20&%20Travel%20Industry_IITTM.pdf) * Tourism as an industry is highly fragmented, hence the oppurtunity to be an Entreprneur is huge! * The industry is in highly need of skilled resources (I can bet my arse on this after networking with some of the Industry experts). By skilled I basically mean - Passionate, Empathtic, Amazing chaps who are creative.
Faculty: * Just like every college, you get a mixed bag. * I personally love the teaching of some of the faculty which is practical and industry oriented. * I would recommend you to visit the college and have a talk with the faculty yourself to get a clear picture. * In an MBA level course, teachers are there to guide you mainly to check if you are in the rght direction. If you still expect spoon feeding in Post graduation level, probably you should go back to school and wait until you are an adult.
College: Review of IITTM - A student’s perspective Disclaimer: I’m a current student of the MBA batch who was just curious as you to know about this college before you joined. Hence I’m writing this review to make it easy to make a decision. You can read the facts about the college at the official website- www.iittmnoida.ac.in. This is just my take on the experience in the college as of now. If you are highly passionate about travelling (well, who isn’t!) and more than that passionate to make people travel to show the world through your lens, you should read further. What is IITTM? * Indian Institute of Tourism and Travel Management is an autonomous body under the Ministry of Tourism, Govt of India. * Headquartered at Gwalior but also has centres at Noida (The one I’m studying in right now and the one with the highest exposure to the industry), Bhubaneshwar, Nellore and Goa. *Founded in 1983 by the Ministry of tourism to be an apex skill centre for the tourism industry and eventually into an apex educational body for Tourism education in India. *If you enter the tourism industry, you are bound to bump into students from IITTM everywhere! *It acts as a think tank to the Govt of India for Tourism projects and even the students get to be a part of it! * It’s the only college chain in the country under the Tourism Ministry to focus only on Tourism Education! **How I found the college?** With an Engineering background in E&C and a job in the IT industry, I started to look out for a career shift. Having travelled across the country during my Engineering times, I decided to enter the Tourism Industry and make a career out of it. With no formal education in Tourism, after a good research, I zeroed in on IITTM Noida to start my MBA in Travel&Tourism. Courses offered? * IITTM offers a 2-year full-time MBA and a 3 Year full-time BBA course in the Travel and Tourism Niche. * The MBA is offered in collaboration with IGNTUniversity, Amarkantak, MP. * The MBA curriculum is completely focused on Tourism as a subject. How to get admissions? * The yearly session starts in July and the admission process begins during May. * For more details please refer - http://iittm.ac.in/main/admission%202015-2017.htm Who should join? * If you are highly passionate about the lucrative Travel industry and want to go deep into the field. * Passionate people who wants to think out of the Box and highly creative. * To be a part of an industry where you work for the happiness of people. * Get to travel while making people travel. NOTE: During the MBA course, you are required to study about travelling and not just travel :) Why MBA? * To be an Entreprenuer. * To learn to be a an effective Manager in the Tourism Industry. * To network with the industry experts and learn the nuances of the trade before you enter the industry. Why a Niche MBA? In a specialised MBA like HR, Finance, Operations, Marketing you get to specialize in those fields only. You start viewing all industries from the lens of those speciality. However I lean more towards having a Niche MBA. You get to view a single field (Tourism) under the lens of HR, Finance, Operations, Marketing giving you a wholesome view of the industry. You get to specialize in an industry than in a work profile! What do you exactly study? Listing out some of the subjects I’m currently studying- * Geography * Accounts * HRM * Business Communication * History * Spanish * Tour and Travel Operations * International Tourism * Manegerial Economics * Marketing (Yet to study) * Principle of Management Please do look into the entire syllabus and get a fell of what you’ll be doing during the course of 2 years. (For the full list of syllabus- http://www.iittm.ac.in/New%20Dos/MBA%20TTM%20%202017-19%20Syllabus.pdf) You also get to do a mandatory 2 months internship in the industry after the 1st year (For which I’m gearing up as I’m writing this). What about infrastructure? As a college, I found the infrastructure to be great. We have clean classrooms with AC and a serene lawn. I love the building mainly for its symmetrical design! Well, you could check out the pictures here for a clear picture. Regarding the hostel, The food is great and also the rooms are clean and good. Again, hostel is how you make of it. What about the faculty? * Just like every college, you get a mixed bag. * I personally love the teaching of some of the faculty which is practical and industry oriented. * I would recommend you to visit the college and have a talk with the faculty yourself to get a clear picture. * In an MBA level course, teachers are there to guide you mainly to check if you are in the rght direction. If you still expect spoon feeding in Post graduation level, probably you should go back to school and wait until you are an adult. How are the students? * Again a mixed bag here. * I get to interact with some of the passionate class mates who have travelled the country and are from diverse backgrounds and regions. I would however love to see a betterment in this aspect. Again, the youth of India still hasn’t realised tourism as an important career prospect yet. * The best part is you get an huge oppurtunity to learn and experiment in this aspect. * If you are someone who is passionate about travelling, join the college and be a the change you want to see in the world. Career growth * More than reading my words, I urge you to read this article by the director of IITTM, Mr.Sandeep Kulshreshta to know what you can do in the Tourism industry here - (http://www.iittm.ac.in/New%20Dos/Career_in_Tourism%20&%20Travel%20Industry_IITTM.pdf) * Tourism as an industry is highly fragmented, hence the oppurtunity to be an Entreprneur is huge! * The industry is in highly need of skilled resources (I can bet my arse on this after networking with some of the Industry experts). By skilled I basically mean - Passionate, Empathtic, Amazing chaps who are creative. Finally why should you join IITTM? * Travel is an art and a science. If you are someone who is analytical and love to think beyond the box, IITTM is one of the best place to be in for the industry exposure and for the chance to experiment. * You get to work on some of the projects of Ministry of Tourism! You get to directly impact tourism industry at the apex level. * If you have read till here, then you should defintely join since you seem to be intrested :) If you are still confused, you can drop in an email to me at sriharsha.hk12[at]gmail[dot]com with your queries. [Please don’t spam me with questions for which you can find answers on the website or internet!]
Exam: Group Discussion / Personal Interview

Read Full Review

college search   5

03-04-2018
A

Amit Kumar Singh
MBA / PGDM Student

college search  4.0 Canteen

college search  4.0 Infrastructure

college search  4.0 Sports

college search  4.5 Events

college search  4.0 Society / Clubs

college search  5.0 Internship/Placement

college search  4.5 Faculty

College to study

Placement: I have placed in a top mnc with a great salary package.
Faculty: Like my UG college faculties of this college to are trained professionals.
College: IITTM is the best college in the Noida, in my opinion, this college was made for providing education related to travel and tourism but now there are many courses in the college and my college is also one of that If we talk about the sports then we have only indoor games in the college.
Exam: State / National Entrance Exams

Read Full Review

college search   5

13-04-2018
S

Sriharsha HK
MBA / PGDM Student

college search  5.0 Canteen

college search  5.0 Infrastructure

college search  2.5 Sports

college search  3.0 Events

college search  2.5 Society / Clubs

college search  5.0 PG

college search  4.0 Hostel

college search  5.0 Internship/Placement

college search  5.0 Faculty

A review on the MBA (Travel & Tourism) course at IITTM Noida

Faculty: * Just like every college, you get a mixed bag. * I personally love the teaching of some of the faculty which is practical and industry oriented. * I would recommend you to visit the college and have a talk with the faculty yourself to get a clear picture. * In an MBA level course, teachers are there to guide you mainly to check if you are in the rght direction. If you still expect spoon feeding in Post graduation level, probably you should go back to school and wait until you are an adult.
Placement: * More than reading my words, I urge you to read this article by the director of IITTM, Mr.Sandeep Kulshreshta to know what you can do in the Tourism industry here - (http://www.iittm.ac.in/New%20Dos/Career_in_Tourism%20&%20Travel%20Industry_IITTM.pdf) * Tourism as an industry is highly fragmented, hence the oppurtunity to be an Entreprneur is huge! * The industry is in highly need of skilled resources (I can bet my arse on this after networking with some of the Industry experts). By skilled I basically mean - Passionate, Empathtic, Amazing chaps who are creative.
College: Review of IITTM - A student’s perspective Disclaimer: I’m a current student of the MBA batch who was just curious as you to know about this college before you joined. Hence I’m writing this review to make it easy to make a decision. You can read the facts about the college at the official website- www.iittmnoida.ac.in. This is just my take on the experience in the college as of now. If you are highly passionate about travelling (well, who isn’t!) and more than that passionate to make people travel to show the world through your lens, you should read further. What is IITTM? * Indian Institute of Tourism and Travel Management is an autonomous body under the Ministry of Tourism, Govt of India. * Headquartered at Gwalior but also has centres at Noida (The one I’m studying in right now and the one with the highest exposure to the industry), Bhubaneshwar, Nellore and Goa. *Founded in 1983 by the Ministry of tourism to be an apex skill centre for the tourism industry and eventually into an apex educational body for Tourism education in India. *If you enter the tourism industry, you are bound to bump into students from IITTM everywhere! *It acts as a think tank to the Govt of India for Tourism projects and even the students get to be a part of it! * It’s the only college chain in the country under the Tourism Ministry to focus only on Tourism Education! **How I found the college?** With an Engineering background in E&C and a job in the IT industry, I started to look out for a career shift. Having travelled across the country during my Engineering times, I decided to enter the Tourism Industry and make a career out of it. With no formal education in Tourism, after a good research, I zeroed in on IITTM Noida to start my MBA in Travel&Tourism. Courses offered? * IITTM offers a 2-year full-time MBA and a 3 Year full-time BBA course in the Travel and Tourism Niche. * The MBA is offered in collaboration with IGNTUniversity, Amarkantak, MP. * The MBA curriculum is completely focused on Tourism as a subject. How to get admissions? * The yearly session starts in July and the admission process begins during May. * For more details please refer - http://iittm.ac.in/main/admission%202015-2017.htm Who should join? * If you are highly passionate about the lucrative Travel industry and want to go deep into the field. * Passionate people who wants to think out of the Box and highly creative. * To be a part of an industry where you work for the happiness of people. * Get to travel while making people travel. NOTE: During the MBA course, you are required to study about travelling and not just travel :) Why MBA? * To be an Entreprenuer. * To learn to be a an effective Manager in the Tourism Industry. * To network with the industry experts and learn the nuances of the trade before you enter the industry. Why a Niche MBA? In a specialised MBA like HR, Finance, Operations, Marketing you get to specialize in those fields only. You start viewing all industries from the lens of those speciality. However I lean more towards having a Niche MBA. You get to view a single field (Tourism) under the lens of HR, Finance, Operations, Marketing giving you a wholesome view of the industry. You get to specialize in an industry than in a work profile! What do you exactly study? Listing out some of the subjects I’m currently studying- * Geography * Accounts * HRM * Business Communication * History * Spanish * Tour and Travel Operations * International Tourism * Manegerial Economics * Marketing (Yet to study) * Principle of Management Please do look into the entire syllabus and get a fell of what you’ll be doing during the course of 2 years. (For the full list of syllabus- http://www.iittm.ac.in/New%20Dos/MBA%20TTM%20%202017-19%20Syllabus.pdf) You also get to do a mandatory 2 months internship in the industry after the 1st year (For which I’m gearing up as I’m writing this). What about infrastructure? As a college, I found the infrastructure to be great. We have clean classrooms with AC and a serene lawn. I love the building mainly for its symmetrical design! Well, you could check out the pictures here for a clear picture. Regarding the hostel, The food is great and also the rooms are clean and good. Again, hostel is how you make of it. What about the faculty? * Just like every college, you get a mixed bag. * I personally love the teaching of some of the faculty which is practical and industry oriented. * I would recommend you to visit the college and have a talk with the faculty yourself to get a clear picture. * In an MBA level course, teachers are there to guide you mainly to check if you are in the rght direction. If you still expect spoon feeding in Post graduation level, probably you should go back to school and wait until you are an adult. How are the students? * Again a mixed bag here. * I get to interact with some of the passionate class mates who have travelled the country and are from diverse backgrounds and regions. I would however love to see a betterment in this aspect. Again, the youth of India still hasn’t realised tourism as an important career prospect yet. * The best part is you get an huge oppurtunity to learn and experiment in this aspect. * If you are someone who is passionate about travelling, join the college and be a the change you want to see in the world. Career growth * More than reading my words, I urge you to read this article by the director of IITTM, Mr.Sandeep Kulshreshta to know what you can do in the Tourism industry here - (http://www.iittm.ac.in/New%20Dos/Career_in_Tourism%20&%20Travel%20Industry_IITTM.pdf) * Tourism as an industry is highly fragmented, hence the oppurtunity to be an Entreprneur is huge! * The industry is in highly need of skilled resources (I can bet my arse on this after networking with some of the Industry experts). By skilled I basically mean - Passionate, Empathtic, Amazing chaps who are creative. Finally why should you join IITTM? * Travel is an art and a science. If you are someone who is analytical and love to think beyond the box, IITTM is one of the best place to be in for the industry exposure and for the chance to experiment. * You get to work on some of the projects of Ministry of Tourism! You get to directly impact tourism industry at the apex level. * If you have read till here, then you should defintely join since you seem to be intrested :) If you are still confused, you can drop in an email to me at sriharsha.hk12[at]gmail[dot]com with your queries. [Please don’t spam me with questions for which you can find answers on the website or internet!]
Exam: Group Discussion / Personal Interview

Read Full Review

college search   5

03-04-2018
A

Amit Kumar Singh
MBA / PGDM Student

college search  4.0 Canteen

college search  4.0 Infrastructure

college search  4.0 Sports

college search  4.5 Events

college search  4.0 Society / Clubs

college search  5.0 Internship/Placement

college search  4.5 Faculty

College to study

Faculty: Like my UG college faculties of this college to are trained professionals.
Placement: I have placed in a top mnc with a great salary package.
College: IITTM is the best college in the Noida, in my opinion, this college was made for providing education related to travel and tourism but now there are many courses in the college and my college is also one of that If we talk about the sports then we have only indoor games in the college.
Exam: State / National Entrance Exams

Read Full Review
View All 4 Reviews

Indian Institute of Tourism and Travel Management (IITTM), Noida Frequently Asked Questions

What is the establishment year of IITM Noida?

IITM Noida was established in 2007.

Which courses are offered by the IITTM, Noida?

IITTM, Noida offers BBA and MBA in Travel & Tourism.

Which are the accepting exams in IITTM, Noida?

IITTM Noida accepts CAT, XAT, CMAT, GMAT, MAT, XAT,ATMA and IIAT.

Who are the recruiters of IITTM Noida?

Recruiters of IITTM Noida are MakeMyTrip, Yatra.Com, IRCTC, Pick Your Trail, Crowne Plaza, etc.

Does IITTM Noida provides hostel facilities?

Yes, IITTM Noida does provide hostel facilities.

Contact Details

Address

A 35-36, Sector 62, Noida, Gautam Buddha Nagar, Noida, Uttar Pradesh, 201301

College Contact

0120 - 24XXXXXX02

Email

iixxxtm@xxxin

Get Contact Details

Indian Institute of Tourism and Travel Management (IITTM) , Noida

college search 4.8/5 (4 reviews)
Request history8.3.19PHP Version610msRequest Duration5MBMemory UsageGET colleges/{slug}Route
  • warninglog[18:18:54] LOG.warning: Creation of dynamic property App\Http\Controllers\CollegeController::$module...
  • Booting (8.03ms)time
  • Application (602ms)time
  • 1 x Application (98.68%)
    602ms
    1 x Booting (1.32%)
    8.03ms
    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
    64 statements were executed, 12 of which were duplicates, 52 unique. Show only duplicated365ms
    • 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/indian-institute-of-tourism-and-travel-management-iittm-noida' and `status` = 1 limit 1
      8.11msdb_collegesearchCacheService.php#460
      Bindings
      • 0: /colleges/indian-institute-of-tourism-and-travel-management-iittm-noida
      • 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` = 'indian-institute-of-tourism-and-travel-management-iittm-noida' and `status` = 'Active' limit 1
      1.62msdb_collegesearchCacheService.php#492
      Bindings
      • 0: indian-institute-of-tourism-and-travel-management-iittm-noida
      • 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` = 'indian-institute-of-tourism-and-travel-management-iittm-noida') limit 1
      990μsdb_collegesearchCollegeController.php#52
      Bindings
      • 0: Active
      • 1: indian-institute-of-tourism-and-travel-management-iittm-noida
      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-06 18:18:54') 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` = 'indian-institute-of-tourism-and-travel-management-iittm-noida' and `status` = 'Active' limit 1
      158msdb_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-06 18:18:54
      • 12: admitted
      • 13: indian-institute-of-tourism-and-travel-management-iittm-noida
      • 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` = 1612) as `grouped_courses_count` from `institute_courses` where `institute_courses`.`institute_id` in (1612) and `status` = 'active' group by `course_type` order by `course_type` asc limit 6
      1.89msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1612
      • 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 (1944, 2071)
      1.83msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1944
      • 1: 2071
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `course_type` where `course_type`.`id` in (2, 7)
      1.65msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 2
      • 1: 7
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `ranks` where `ranks`.`course_type` in (2, 7) and `institute_id` = 1612 order by `year` desc
      1.94msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 1612
      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 (42838, 51598) and `a_package` != '' and `h_package` != '' and `placement_course`.`deleted_at` is null order by `year` desc
      1.1msdb_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 (1612)
      940μ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 (1612) and `status` = 'active' and `admission_dates` != '' group by `course_type` order by `course_type` asc
      1.87msdb_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 (1612) and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      530μ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 (1612) and `institute_toc`.`deleted_at` is null order by `id` desc
      19.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 `images` where `images`.`institute_id` in (1612) 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.49msdb_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 (1612) and `status` = '1' order by `id` desc
      1.85msdb_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 (1612) order by `id` desc limit 1
      1.1msdb_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 (95)
      1.57msdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 95
      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 (1612) and `status` = 'Active' limit 10
      7.8msdb_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 (40002, 45361, 46092, 71120) order by `vote_up` desc
      860μ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 (1612) 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
      610μ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 (1612) 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.57msdb_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 (1612) and `status` = 'active' and `approved` = 'yes' group by `course_type` order by `course_type` asc
      5.91msdb_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 (1612) order by `ID` desc limit 1
      760μ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 `admin` where `admin`.`ID` in (189)
      900μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 189
      Backtrace
      • 25. app/Http/Controllers/CollegeController.php:239
      • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 27. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `writers_profile` where `writers_profile`.`admin_id` in (189)
      830μsdb_collegesearchCollegeController.php#239
      Bindings
      • 0: 189
      Backtrace
      • 30. app/Http/Controllers/CollegeController.php:239
      • 31. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 32. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 34. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `app_type`, `institute_id` from `institute_profile` where `institute_profile`.`institute_id` in (1612)
      1.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 `id`, `title`, `desc` from `institute_toc` where `institute_id` = 1612 and `type` = 'admission' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.82msdb_collegesearchCollegeController.php#246
      Bindings
      • 0: 1612
      • 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` = 1612
      1.28msdb_collegesearchCollegeController.php#248
      Bindings
      • 0: 1612
      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` = 1612 and `type` = 'cutoff' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.21msdb_collegesearchCollegeController.php#250
      Bindings
      • 0: 1612
      • 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 (42838, 51598) and (`round_id` = 1 and `status` = 1)
      4.63msdb_collegesearchCollegeController.php#268
      Bindings
      • 0: 42838
      • 1: 51598
      • 2: 1
      • 3: 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 (3122,4275,842) limit 12
      1.29msdb_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` = 1612
      780μsdb_collegesearchCollegeController.php#316
      Bindings
      • 0: 1612
      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 (42838, 51598) and `placement_course`.`deleted_at` is null order by `year_placement` desc
      870μsdb_collegesearchCollegeController.php#325
      Bindings
      • 0: 42838
      • 1: 51598
      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` = 1612 and `type` = 'placement' and `institute_toc`.`deleted_at` is null order by `id` desc
      18.21msdb_collegesearchCollegeController.php#342
      Bindings
      • 0: 1612
      • 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` = 1612 and `type` = 'key_highlights_placement' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      740μsdb_collegesearchCollegeController.php#345
      Bindings
      • 0: 1612
      • 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` = 1612 and `type` = 'ranking' and `institute_toc`.`deleted_at` is null order by `id` desc
      19.22msdb_collegesearchCollegeController.php#351
      Bindings
      • 0: 1612
      • 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` = 1612
      3.08msdb_collegesearchCollegeController.php#388
      Bindings
      • 0: 1612
      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` = 1612 and `intern_rating` != '' and `placement_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      1.6msdb_collegesearchCollegeController.php#415
      Bindings
      • 0: Active
      • 1: 1612
      • 2: 
      • 3: 
      • 4: 2
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:415
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (45361, 46092) order by `vote_up` desc
      1.56msdb_collegesearchCollegeController.php#415
      Backtrace
      • 19. app/Http/Controllers/CollegeController.php:415
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 1612 and `teacher_rating` != '' and `teacher_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      2.02msdb_collegesearchCollegeController.php#433
      Bindings
      • 0: Active
      • 1: 1612
      • 2: 
      • 3: 
      • 4: 2
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:433
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `review_id`, `vote_up` from `user_reviews_vote_up` where `user_reviews_vote_up`.`review_id` in (45361, 46092) order by `vote_up` desc
      960μsdb_collegesearchCollegeController.php#433
      Backtrace
      • 19. app/Http/Controllers/CollegeController.php:433
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `institute_id`, `title`, `course_type`, `student_name`, `course_name`, `added_date`, `canteen_rating`, `infra_rating`, `sports_rating`, `event_rating`, `society_rating`, `fashion_rating`, `travel_rating`, `pg_nearby_rating`, `hostel_rating`, `teacher_desc`, `placement_desc`, `overall_rating`, `college_desc`, `intern_rating`, `salary_package`, `teacher_rating`, `admission_rating`, `admission_desc`, `entrance_exams`, `college_selection` from `user_reviews` where `status` = 'Active' and `institute_id` = 1612 and `admission_rating` != '' and `admission_desc` != '' and `course_type` = 2 order by `added_date` desc, `overall_rating` asc, length(college_desc) desc limit 2
      1.14msdb_collegesearchCollegeController.php#451
      Bindings
      • 0: Active
      • 1: 1612
      • 2: 
      • 3: 
      • 4: 2
      Backtrace
      • 14. app/Http/Controllers/CollegeController.php:451
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `title`, `desc`, `type` from `institute_insights` where `institute_id` = 1612 and `type` LIKE '%ked_review%' and `status` = 'Y' and `institute_insights`.`deleted_at` is null order by `id` desc
      720μsdb_collegesearchCollegeController.php#455
      Bindings
      • 0: 1612
      • 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` = 1612
      4.58msdb_collegesearchCollegeController.php#477
      Bindings
      • 0: 1612
      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` = 1612 and `images`.`deleted_at` is null limit 1
      1.22msdb_collegesearchInstitute.php#210
      Bindings
      • 0: 1
      • 1: 1612
      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` = 1612 and `images`.`deleted_at` is null limit 1
      1.08msdb_collegesearchInstitute.php#224
      Bindings
      • 0: 1
      • 1: 1612
      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/indian-institute-of-tourism-and-travel-management-iittm-noida' and `status` = 'Y' limit 1
      1.73msdb_collegesearchCollegeController.php#549
      Bindings
      • 0: colleges/indian-institute-of-tourism-and-travel-management-iittm-noida
      • 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` = 1612 and `institute_faqs`.`institute_id` is not null
      1.37msdb_collegesearchCollegeController.php#613
      Bindings
      • 0: 1612
      Backtrace
      • 19. app/Http/Controllers/CollegeController.php:613
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `header_name` from `course_type` where `id` = 2 limit 1
      690μsdb_collegesearchBreadcrumb.php#167
      Bindings
      • 0: 2
      Backtrace
      • 15. app/Service/Breadcrumb.php:167
      • 16. app/Service/Breadcrumb.php:37
      • 17. app/Http/Controllers/CollegeController.php:631
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `is_sunstone` from `inst_campaign_bharat_2022` where `institute_id` = 1612 limit 1
      2.39msdb_collegesearchCollegeController.php#637
      Bindings
      • 0: 1612
      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` = 1612 group by `course_type`.`id`
      10.61msdb_collegesearchCollegeController.php#658
      Bindings
      • 0: 1612
      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` = 1612 and date(`start_date`) <= '2025-04-06' and date(`end_date`) >= '2025-04-06'
      2.62msdb_collegesearchCollegeController.php#670
      Bindings
      • 0: 1612
      • 1: 2025-04-06
      • 2: 2025-04-06
      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` = 1612 and `institute_courses`.`institute_id` is not null limit 1
      1.36msdb_collegesearchCollegeController.php#672
      Bindings
      • 0: 1612
      Backtrace
      • 21. app/Http/Controllers/CollegeController.php:672
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (21)
      780μ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 (21)
      1.54msdb_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 (21)
      770μsdb_collegesearchInstituteCourse.php#30
      Backtrace
      • 14. app/Models/InstituteCourse.php:30
      • 21. app/Http/Controllers/CollegeController.php:693
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • select `id`, `name`, `display_name`, `short_name`, `exam_image`, `description` from `criteria` where id IN (21)
      1.67msdb_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` = 1612 and `expiry_date` > '2025-04-06 18:18:55' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      1.04msdb_collegesearchhelpers.php#1695
      Bindings
      • 0: 1612
      • 1: 2025-04-06 18:18:55
      Backtrace
      • 14. app/helpers.php:1695
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%exam%' and `module_link_id` in ('21') and `expiry_date` > '2025-04-06 18:18:55' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      710μsdb_collegesearchhelpers.php#1712
      Bindings
      • 0: %exam%
      • 1: 21
      • 2: 2025-04-06 18:18:55
      Backtrace
      • 14. app/helpers.php:1712
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `modulename`, `module_link_id`, `update_description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `modulename` like '%course%' and `module_link_id` in ('2', '7') and `expiry_date` > '2025-04-06 18:18:55' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      1.05msdb_collegesearchhelpers.php#1726
      Bindings
      • 0: %course%
      • 1: 2
      • 2: 7
      • 3: 2025-04-06 18:18:55
      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` = 1612 and `user_reviews`.`institute_id` is not null
      1.87msdb_collegesearchhero_section.blade.php#27
      Bindings
      • 0: 1612
      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` = 1612 and `user_reviews`.`institute_id` is not null
      1.84msdb_collegesearchnavbar.blade.php#31
      Bindings
      • 0: 1612
      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` = 1612 and `collaboration`.`institute_id` is not null
      1.32msdb_collegesearchawards_v2.blade.php#2
      Bindings
      • 0: 1612
      Backtrace
      • 19. view::pages.college_v2.partials.awards_v2:2
      • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
      • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
      • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
    • select `get_site_id`, `position`, `sub_section`, `section`, `type` from `brandings` where `section` = 'cp' and `brandings`.`deleted_at` is null
      1.01msdb_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\UserReview
    19UserReview.php#?
    App\Models\InstituteCourse
    9InstituteCourse.php#?
    App\Models\Image
    8Image.php#?
    App\Models\UserReviewsVoteUp
    7UserReviewsVoteUp.php#?
    App\Models\InstituteToc
    5InstituteToc.php#?
    App\Models\InstituteFaqs
    5InstituteFaqs.php#?
    App\Models\PlacementCourse
    4PlacementCourse.php#?
    App\Models\Criteria
    4Criteria.php#?
    App\Models\CourseType
    3CourseType.php#?
    App\Models\Institute
    2Institute.php#?
    App\Models\SubCourse
    2SubCourse.php#?
    App\Models\Document
    1Document.php#?
    App\Models\State
    1State.php#?
    App\Models\AdminReporting
    1AdminReporting.php#?
    App\Models\Admin
    1Admin.php#?
    App\Models\WriterProfile
    1WriterProfile.php#?
    App\Models\InstituteProfile
    1InstituteProfile.php#?
    App\Models\MetaTag
    1MetaTag.php#?
        _token
        ugclQd2HRelYt6J6gQNXXiMU9QencLEQ8zOaJ6NP
        _previous
        array:1 [ "url" => "https://www.new.collegesearch.in/colleges/indian-institute-of-tourism-and-trav...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /colleges/indian-institute-of-tourism-and-travel-management-iittm-noida
        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 => "Sun, 06 Apr 2025 12:48:55 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZQRFM0RWRENkFHYnZaS3hqSlV3NUE9PSIsInZhbHVlIjoiK1FzeElQQ2FsT0ZjK01rRyt2amZWT1ZpN0RrenhXcFd3QnUzeFVLaDZkdnR3Qks2NmxaOCsyMXBSUDZDUENLd25qTC9pOGRMdjRlcU9relhKNXdDTFZTUDJPUTZKdCs3Wmwyak5mNXM1cU14RE01M2p0Sndrakpmb28vcDljdzgiLCJtYWMiOiI0N2Y3OGNjNDc2ODlhMjNkNGI3ODM1NTZmOTQyMmZiMGZlMTdjNWExYWNjNDNmYjA4MWFlNDEwZDZjMTEzZjAxIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 14:48:55 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkZQRFM0RWRENkFHYnZaS3hqSlV3NUE9PSIsInZhbHVlIjoiK1FzeElQQ2FsT0ZjK01rRyt2amZWT1ZpN0RrenhXcFd3QnUzeFVLaDZkdnR3Qks2NmxaOCsyMXBSUDZDUENLd25qTC9pO" 1 => "cs_dev_session=eyJpdiI6IkRzbUcrZDlxeE5pWVpGV1Jvb3cyZ0E9PSIsInZhbHVlIjoiRmxkVThvWGVlS1VDbEFoN3NRbmtHYmhPMVNaWmdoVDdnR3pJMEE4VTdTektzQUcveFptbm4vM2ZFVmZPeXZlRmFka3RKZVRRbTNJaS9EcjhVbnlsb1FKK0NHdEpVTm9qT1podG5DYXplWXFaZE1YUzVJQ295MXMzdTJ6aE1VbWEiLCJtYWMiOiI3YTJhMzNjYzdkNTkyODc1NWY0ZGY5OTY4MzFkNmZmNDQwNWY3YmZiMzA3MTNmODRmOWRlYzQ0MGNhMzE5NzMyIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 14:48:55 GMT; Max-Age=7200; path=/; httponly; samesite=laxcs_dev_session=eyJpdiI6IkRzbUcrZDlxeE5pWVpGV1Jvb3cyZ0E9PSIsInZhbHVlIjoiRmxkVThvWGVlS1VDbEFoN3NRbmtHYmhPMVNaWmdoVDdnR3pJMEE4VTdTektzQUcveFptbm4vM2ZFVmZPeXZlRmFka" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZQRFM0RWRENkFHYnZaS3hqSlV3NUE9PSIsInZhbHVlIjoiK1FzeElQQ2FsT0ZjK01rRyt2amZWT1ZpN0RrenhXcFd3QnUzeFVLaDZkdnR3Qks2NmxaOCsyMXBSUDZDUENLd25qTC9pOGRMdjRlcU9relhKNXdDTFZTUDJPUTZKdCs3Wmwyak5mNXM1cU14RE01M2p0Sndrakpmb28vcDljdzgiLCJtYWMiOiI0N2Y3OGNjNDc2ODlhMjNkNGI3ODM1NTZmOTQyMmZiMGZlMTdjNWExYWNjNDNmYjA4MWFlNDEwZDZjMTEzZjAxIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 14:48:55 GMT; path=/XSRF-TOKEN=eyJpdiI6IkZQRFM0RWRENkFHYnZaS3hqSlV3NUE9PSIsInZhbHVlIjoiK1FzeElQQ2FsT0ZjK01rRyt2amZWT1ZpN0RrenhXcFd3QnUzeFVLaDZkdnR3Qks2NmxaOCsyMXBSUDZDUENLd25qTC9pO" 1 => "cs_dev_session=eyJpdiI6IkRzbUcrZDlxeE5pWVpGV1Jvb3cyZ0E9PSIsInZhbHVlIjoiRmxkVThvWGVlS1VDbEFoN3NRbmtHYmhPMVNaWmdoVDdnR3pJMEE4VTdTektzQUcveFptbm4vM2ZFVmZPeXZlRmFka3RKZVRRbTNJaS9EcjhVbnlsb1FKK0NHdEpVTm9qT1podG5DYXplWXFaZE1YUzVJQ295MXMzdTJ6aE1VbWEiLCJtYWMiOiI3YTJhMzNjYzdkNTkyODc1NWY0ZGY5OTY4MzFkNmZmNDQwNWY3YmZiMzA3MTNmODRmOWRlYzQ0MGNhMzE5NzMyIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 14:48:55 GMT; path=/; httponlycs_dev_session=eyJpdiI6IkRzbUcrZDlxeE5pWVpGV1Jvb3cyZ0E9PSIsInZhbHVlIjoiRmxkVThvWGVlS1VDbEFoN3NRbmtHYmhPMVNaWmdoVDdnR3pJMEE4VTdTektzQUcveFptbm4vM2ZFVmZPeXZlRmFka" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "ugclQd2HRelYt6J6gQNXXiMU9QencLEQ8zOaJ6NP" "_previous" => array:1 [ "url" => "https://www.new.collegesearch.in/colleges/indian-institute-of-tourism-and-travel-management-iittm-noida" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-06 18:18:55GET/colleges/indian-institute-of-tourism-and-travel-management-iittm-noida1266475