Master of Pharmacy Drug Regulatory Affairs in Charotar University of Science and Technology (CHARUSAT), Anand Fees Breakup, Total Fees, Eligibility.

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Overview

Master of Pharmacy Drug Regulatory Affairs is a 2 year course at Charotar University of Science and Technology (CHARUSAT), Anand. The total fees for Master of Pharmacy Drug Regulatory Affairs at Charotar University of Science and Technology (CHARUSAT), Anand is 3,40,000. To get admission in Master of Pharmacy Drug Regulatory Affairs at Charotar University of Science and Technology (CHARUSAT), Anand, students must meet some eligibility requirements, that is B.Pharm. with 55% (50% for SC/ST) or equivalent grade in branch.. This program helps students with the necessary skills to build a successful career in the Pharmacy.

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Highlights

Particular	Details
Total Seats	N/A
Course Fee	3,40,000
Duration	2 Years
Accepted Exams	JEE Main

About Master of Pharmacy Drug Regulatory Affairs

Program Duration
Full Time ,2 Years

Course Type
PG , Pharmacy

Eligibility
B.Pharm. with 55% (50% for SC/ST) or equivalent grade in branch. Read More

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Fee Structure

Master of Pharmacy Drug Regulatory Affairs fees for Charotar University of Science and Technology (CHARUSAT), Anand is further divided into categories like registration fees, tuition fees, hostel fees, other expenses, and total fees. We have mentioned these details in the table below:

Master of Pharmacy Drug Regulatory Affairs Fee Breakup

Fees (Rs.)	Year 1	Year 2
Tuition Fees	₹ 1,70,000	₹ 1,70,000

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Eligibility

Students who are seeking admission in 2 year M.Pharm Master of Pharmacy Drug Regulatory Affairs program at the Charotar University of Science and Technology (CHARUSAT), Anand should meet the following eligibility criteria.

B.Pharm. with 55% (50% for SC/ST) or equivalent grade in branch.

Popular Exams

JEE Main M.Pharm

Exam Month

April

Accepting Colleges

Last Date to Apply

01st April, 2025

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Admission Process

To take admission in Master of Pharmacy Drug Regulatory Affairs at Charotar University of Science and Technology (CHARUSAT), Anand, candidates must possess a valid score in JEE Main or any other state-level examination.

Admission based on GPAT examination.

Master of Pharmacy Drug Regulatory Affairs Fee Payment Options

Charotar University of Science and Technology (CHARUSAT), Anand fees for various courses should be paid by students at the time of counseling to confirm their admission:

The payment of fees should be made either in cash or a Demand Draft issued in favor of Charotar University of Science and Technology (CHARUSAT), Anand.
Candidates need to issue a draft in favor of the university to pay the course fee.
The college also accepts Internet banking or payment through debit and credit cards.
Candidates can directly transfer money from their bank account to the university's bank account through NEFT, RTGS, and IMPS without physically visiting the Charotar University of Science and Technology (CHARUSAT), Anand campus.
Delay in fee payment can cause a fine as per Charotar University of Science and Technology (CHARUSAT), Anand rules and regulations.

Charotar University of Science and Technology (CHARUSAT), Anand Fees Inquiry

Contact Information for students to find out more about the Charotar University of Science and Technology (CHARUSAT), Anand Fees

Contact Number - 265011/265021, 265011
E-mail at: dilipgosai.pr@charusat.ac.in
Admission Block Address - CHARUSAT Campus, Changa, Off. Petlad- Nadiad Highway, Taluka: Petlad, District : Anand

Master of Pharmacy Drug Regulatory Affairs Placement in Charotar University of Science and Technology (CHARUSAT), Anand

Master of Pharmacy Drug Regulatory Affairs Charotar University of Science and Technology (CHARUSAT), Anand Top Recruiters

TCS

Airtel

L&T ECC

infosys

Igate

Tech Mahindra

GALAXY

Indusa

Adani group

Collabera

tata

Indian Navy

samsung

Asian Paints

View All Recruiters Details

Student's Rating for Charotar University of Science and Technology (CHARUSAT), Anand

Student Reviews & Ratings

4.6/5 Based on 28 Verified Reviews

Component Ratings

Faculty Rating 4.6

Infrastructure Rating 4.8

Placements Rating 5

Admission Rating 4

Hostel Rating 4.6

Club Rating 4.3

Student's Reviews for Charotar University of Science and Technology (CHARUSAT), Anand

Admission

Placement

Faculty

5 Overall 10-03-2023

Anonymous User
MBA Student

This college has a large campus and the types of course it offers is very wide. Also, this college is very popular for the computer field.

Admission: Through ACPC and with a score of Jee mains. Also, there is a management quota for admission.

5 Overall 10-03-2023

Anonymous User
MBA Student

5 Infrastructure 3.5 Faculty 4 Admission 4 Hostel 5 Club 4.5 Mess

My UNIVERSITY for me is very important. College infrastructure is very good. According to me this college comes in top 5 colleges for engineering in Gujarat. And I am studying engineering. All faculties of colleges are fabulous. College curriculum is goo

Placement: Here, there are many opportunities for campus placement. Every year various multinational companies are coming for placement.

Faculty: My favorite teacher is of IT field. He taught us Java, Web technologies subjects. He is completed M Tech. He is very good at teaching.

Admission: Based on School / 12th Class Result, State / National Entrance Exams

Club: Band club of our college is very popular.

5 Overall 10-03-2023

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4.5 Club 5 Mess

While choosing college/university we take some parameters in an account. Accordingly, I am explaining each in a parameter in CHARUSAT. 1. Placement: In this era of competition, there are lot many engineering colleges and those colleges produce great b

Placement: In this era of competition, there are lot many engineering colleges and those colleges produce great bulk of engineering graduates. Now, it becomes a very sensitive point to get a job just after graduation. Placement is a way of getting a job even before

Faculty: All faculty members with minimum Masters degree and with minimum one research area identified and working on. Not good only at academic but also very supporting ad approachable.

Admission: Based on School / 12th Class Result

Club: Technical like ACM, IEEE as well as study groups such as Android Developer Club, Machine Learning Group etc.

5 Overall 10-03-2023

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4.5 Club 4 Mess

Good environment with full of resources. Excellent teaching staff who motivates you till then end of your last semester.Very good infrastructure and library facility.Every year so many events,workshops, seminars and training programs organized on Gujarat

Placement: Lots of opportunities We get for Internship and placement. Average 30 companies are visiting every year for placements and for internship

Faculty: Specifically I had more contact with Faculties of department of Information Technology.All faculties are very supportive throughout my Btech

Admission: Based on School / 12th Class Result

Club: IEEE student chapter,CSI student chapter and ACM Student chapter is running actively

5 Overall 10-03-2023

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4.5 Club 5 Mess

Faculty: All faculty members with minimum Masters degree and with minimum one research area identified and working on. Not good only at academic but also very supporting ad approachable.

Admission: Based on School / 12th Class Result

Club: Technical like ACM, IEEE as well as study groups such as Android Developer Club, Machine Learning Group etc.

5 Overall 10-03-2023

Anonymous User
MBA Student

5 Infrastructure 5 Faculty 5 Hostel 4.5 Club 4 Mess

Placement: Lots of opportunities We get for Internship and placement. Average 30 companies are visiting every year for placements and for internship

Faculty: Specifically I had more contact with Faculties of department of Information Technology.All faculties are very supportive throughout my Btech

Admission: Based on School / 12th Class Result

Club: IEEE student chapter,CSI student chapter and ACM Student chapter is running actively

View All 28 Reviews

Gallery

4 Images

Charotar University of Science and Technology (CHARUSAT), Anand Program Offered

4.5 Master of Pharmacy Pharmacology

2 Years

Total Fees

₹3,40,000

Highest Package

N/A

4.5 Master of Pharmacy Pharmaceutics

2 Years

Total Fees

₹3,40,000

Highest Package

N/A

4.5 Master of Pharmacy Quality Assurance

2 Years

Total Fees

₹3,40,000

Highest Package

N/A

View All Programs

Contact Details

Address

CHARUSAT Campus, Changa, Off. Petlad- Nadiad Highway, Taluka: Petlad, District : Anand

College Contact

26XXXXXX21

diXXXXXXin

Messages Timeline Exceptions Views13 Route Queries63 Models358 Mails Gate Session Request

Request history8.3.19228ms4MBGET {type}/{slug}/{tab}/{tab2}

Booting (9.29ms)time
Application (218ms)time
1 x Application (95.92%)
218ms
1 x Booting (4.08%)
9.29ms

13 templates were rendered

pages.college-profile.descriptiondescription.blade.php#?blade
components.breadcrumbbreadcrumb.blade.php#?blade
components.navbarnavbar.blade.php#?blade
components.total-reviewtotal-review.blade.php#?blade
components.detailed-reviewsdetailed-reviews.blade.php#?blade
components.videoslistingvideoslisting.blade.php#?blade
components.registrationregistration.blade.php#?blade
layouts.webweb.blade.php#?blade
partials.headhead.blade.php#?blade
partials.headerheader.blade.php#?blade
partials.footerfooter.blade.php#?blade
components.sucessesModalsucessesModal.blade.php#?blade
partials.bottomfooterbottomfooter.blade.php#?blade

uri: GET {type}/{slug}/{tab}/{tab2}
middleware: web
domain: www.dev.collegesearch.in
controller: App\Http\Controllers\CollegeController@description
as: colleges_university.profile.tabs2
namespace
prefix: /{type}
where
file: app/Http/Controllers/CollegeController.php:41-169

63 statements were executed (7 duplicates)Show only duplicates126ms

SoftRedirects.php#22db_collegesearch_newConnection Established

Backtrace

app/Http/Middleware/SoftRedirects.php:22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

SoftRedirects.php#22db_collegesearch_new7.23ms

select * from `seo_redirects` where `redirect_from` = '/university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622' limit 1

Bindings	0: /university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622
Backtrace	app/Http/Middleware/SoftRedirects.php:22 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

MetaChecker.php#20db_collegesearch_new780μs

select * from `meta_tags` where `slug` = 'university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622 1: active
Backtrace	app/Http/Middleware/MetaChecker.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SoftRedirects.php:28 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:51

helpers.php#722db_collegesearch_new1.13ms

select * from `default_meta_tags` where `module` = 'college' and `default_meta_tags`.`deleted_at` is null and `status` = 'active'

Bindings	0: college 1: active
Backtrace	app/helpers.php:722 vendor/laravel/framework/src/Illuminate/Container/Container.php:989 vendor/laravel/framework/src/Illuminate/Container/Container.php:819 vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1048 vendor/laravel/framework/src/Illuminate/Container/Container.php:755

CollegeController.php#66db_collegesearch_new960μs

select `institutes`.*, (select count(*) from `institute_reviews` where `institutes`.`id` = `institute_reviews`.`institute_id` and `institute_reviews`.`deleted_at` is null and `status` = 'active') as `reviews_count` from `institutes` where `slug` = 'charotar-university-of-science-and-technology-charusat-anand' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: charotar-university-of-science-and-technology-charusat-anand 2: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.96ms

select `id`, `course_id`, `program_id`, `institute_id`, `institute_course_name`, `duration`, `total_seats`, `description`, `eligibility_content` from `institute_programs` where `institute_programs`.`institute_id` in (7666) and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.32ms

select `id`, `name` from `programs` where `programs`.`id` in (14, 15, 17, 19, 20, 49, 956, 1484, 1485, 1488, 1491, 1494, 1590, 1597, 1608, 1628, 1629, 1647, 1686, 1898, 1899, 2753, 2754, 2756, 2757, 2758, 2759, 2776, 2791, 2796, 2801, 2809, 2812, 2822, 2840, 2841, 2842, 3410, 3411, 3437, 3443, 3458, 3465, 3595, 3636, 3652, 3706, 4428, 4645, 4712, 4994, 5158, 5159, 5160, 5161, 5196) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.71ms

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 8, 10, 11, 13, 14, 23, 25, 41, 43, 59, 60, 70, 120) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.92ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10330, 10331, 10332, 10333, 10334, 10618, 10619, 10620, 10621, 10622, 15782, 15783, 15784, 15785, 15786, 15787, 15788, 15789, 15790, 15791, 15792, 33859, 33860, 33861, 33862, 33863, 33864, 59156, 59157, 59158, 59159, 59160, 59161, 59162, 59163, 59164, 59165, 59166, 59167, 59168, 59169, 59170, 59171, 59172, 59173, 59174) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.79ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10330, 10331, 10332, 10333, 10334, 10618, 10619, 10620, 10621, 10622, 15782, 15783, 15784, 15785, 15786, 15787, 15788, 15789, 15790, 15791, 15792, 33859, 33860, 33861, 33862, 33863, 33864, 59156, 59157, 59158, 59159, 59160, 59161, 59162, 59163, 59164, 59165, 59166, 59167, 59168, 59169, 59170, 59171, 59172, 59173, 59174) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

CollegeController.php#66db_collegesearch_new1.12ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (10320, 10321, 10322, 10323, 10324, 10325, 10326, 10327, 10328, 10329, 10330, 10331, 10332, 10333, 10334, 10618, 10619, 10620, 10621, 10622, 15782, 15783, 15784, 15785, 15786, 15787, 15788, 15789, 15790, 15791, 15792, 33859, 33860, 33861, 33862, 33863, 33864, 59156, 59157, 59158, 59159, 59160, 59161, 59162, 59163, 59164, 59165, 59166, 59167, 59168, 59169, 59170, 59171, 59172, 59173, 59174) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:66 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

Institute.php#174db_collegesearch_new1.04ms

select `name` from `cities` where `id` = 162 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1

Bindings	0: 162 1: active
Backtrace	app/Models/Institute.php:174 app/Http/Controllers/CollegeController.php:279 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#189db_collegesearch_new1.56ms

select `name` from `states` where `id` = 74 and `states`.`deleted_at` is null and `states`.`status` = 'active' and `states`.`country_id` = 2 order by `states`.`name` asc limit 1

Bindings	0: 74 1: active 2: 2
Backtrace	app/Models/Institute.php:189 app/Http/Controllers/CollegeController.php:279 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#711db_collegesearch_new980μs

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 7666 and `institute_contents`.`institute_id` is not null and `type` = 'course-fees-program-specific' and `institute_contents`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 7666 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:711 app/Http/Controllers/CollegeController.php:281 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#282db_collegesearch_new1.66ms

select * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 7666 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null

Bindings	0: 7666
Backtrace	app/Http/Controllers/CollegeController.php:282 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#282db_collegesearch_new1.07ms

select `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (3) and `institute_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:282 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#747db_collegesearch_new1.31ms

select `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 7666 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:747 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#758db_collegesearch_new820μs

select count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7666 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:758 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new1.27ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7666 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 7666 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:759 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#760db_collegesearch_new720μs

select `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 7666 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:760 app/Http/Controllers/CollegeController.php:283 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#210db_collegesearch_new1.15ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 7666 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active' order by `updated_at` desc

Bindings	0: 7666 1: active
Backtrace	app/Models/Institute.php:210 app/Http/Controllers/CollegeController.php:285 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new2.51ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.38ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `admission_review` is not null and `admission_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(admission_review) DESC, `created_at` desc limit 2

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.85msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:289
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.98ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.18ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `placement_review` is not null and `placement_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(placement_review) DESC, `created_at` desc limit 2

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new4.7msselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:289
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new980μs

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new970μs

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 7666 and `institute_reviews`.`institute_id` is not null and `faculty_review` is not null and `faculty_review` != '' and `institute_reviews`.`deleted_at` is null and `status` = 'active' order by LENGTH(faculty_review) DESC, `created_at` desc limit 2

Bindings	0: 7666 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:289 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new760μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)

Backtrace

app/Models/Institute.php:151
app/Http/Controllers/CollegeController.php:289
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#499db_collegesearch_new710μs

select * from `institute_programs` where `institute_id` = 7666 and `institute_programs`.`id` = '10622' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 7666 1: 10622 2: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new620μs

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (10622) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new640μs

select `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (10622) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new1.03msselect * from `courses` where `courses`.`id` in (14) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new680μsselect * from `degrees` where `degrees`.`id` in (2) and `degrees`.`deleted_at` is null and `status` = 'Active'

Bindings	0: 2 1: Active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new630μsselect * from `streams` where `streams`.`id` in (8) and `streams`.`deleted_at` is null and `status` = 'active'

Bindings	0: 8 1: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new610μs

select * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (10622) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new940μsselect * from `fees_types` where `fees_types`.`id` in (2)

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new540μs

select `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (10622)

Backtrace

app/Http/Controllers/CollegeController.php:499
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new1.01ms

select `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (161) and `exams`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new1.04ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (161) and exists (select * from `exam_features` where `exam_feature_mappings`.`exam_feature_id` = `exam_features`.`id` and `type` like '%date%' and `exam_features`.`deleted_at` is null and `status` = 'active') and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active'

Bindings	0: %date% 1: active 2: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#499db_collegesearch_new2.35ms

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (2, 3, 7, 9, 10, 11, 17) and `exam_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:499 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Exam.php#58db_collegesearch_new6.42ms

select `exam_feature_mappings`.`value`, `exam_feature_mappings`.`exam_feature_id` from `exam_feature_mappings` inner join `exam_features` on `exam_features`.`id` = `exam_feature_mappings`.`exam_feature_id` where `exam_feature_mappings`.`exam_id` = 161 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

Bindings	0: 161 1: exam_date 2: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Exam.php#58db_collegesearch_new610μs

select `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9) and `exam_features`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Models/Exam.php:58 app/Http/Controllers/CollegeController.php:500 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#277db_collegesearch_new1.52ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 7666 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 14 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1

Bindings	0: 7666 1: cs 2: nirf 3: 14 4: active
Backtrace	app/Models/Institute.php:277 app/Http/Controllers/CollegeController.php:510 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#520db_collegesearch_new1.38ms

select `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 14 and `institute_id` = 7666) and `id` != '10622' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3

Bindings	0: 14 1: 7666 2: 10622 3: active
Backtrace	app/Http/Controllers/CollegeController.php:520 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#520db_collegesearch_new2.33ms

select `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (10618, 10619, 10620) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:520 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#524db_collegesearch_new1.64ms

select distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 7666 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:524 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#524db_collegesearch_new1.02ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (68, 112, 127, 128, 911, 965, 1109, 1354, 1937, 2111, 2244, 2785, 6077, 6460)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#524db_collegesearch_new750μs

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (5, 6, 15, 20, 22, 29, 50, 345)

Backtrace

app/Http/Controllers/CollegeController.php:524
app/Http/Controllers/CollegeController.php:76
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#529db_collegesearch_new1.51ms

select `id` from `institute_programs` where `institute_id` = 7666 and `course_id` = 14 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: 14 2: active
Backtrace	app/Http/Controllers/CollegeController.php:529 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#537db_collegesearch_new920μs

select institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (10618, 10619, 10620, 10621, 10622) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 10618 1: 10619 2: 10620 3: 10621 4: 10622 5: active
Backtrace	app/Http/Controllers/CollegeController.php:537 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

Institute.php#226db_collegesearch_new31.57ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 7666 and `faqs`.`faq_id` is not null and `sub_type` = 'course-fees-program-specific' and `faq_type` = 'institute' and `faqs`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: 7666 2: course-fees-program-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:226 app/Http/Controllers/CollegeController.php:660 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#661db_collegesearch_new2ms

select * from `institute_ratings` where `institute_ratings`.`institute_id` = 7666 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:661 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#662db_collegesearch_new970μs

select * from `institute_documents` where `institute_documents`.`institute_id` = 7666 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:662 app/Http/Controllers/CollegeController.php:76 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#245db_collegesearch_new1.21ms

select `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '10622' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: 10622 1: active
Backtrace	app/Http/Controllers/CollegeController.php:245 app/Http/Controllers/CollegeController.php:95 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#245db_collegesearch_new770μs

select `id`, `name`, `slug` from `courses` where `courses`.`id` in (14) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:245 app/Http/Controllers/CollegeController.php:95 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#974db_collegesearch_new1.8ms

select distinct `course_id` from `institute_programs` where `institute_id` = 7666 and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: 7666 1: active
Backtrace	app/Http/Controllers/CollegeController.php:974 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#980db_collegesearch_new1.91ms

select distinct `exam_id` from `institute_program_exam_mappings` inner join `institute_programs` on `institute_programs`.`id` = `institute_program_exam_mappings`.`institute_program_id` where `institute_programs`.`institute_id` = 7666

Bindings	0: 7666
Backtrace	app/Http/Controllers/CollegeController.php:980 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#496db_collegesearch_new2.23ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%cp%' and `sub_type` like '%course-fees-program-specific%' and `module_id` = 7666 and `expiry_date` > '2025-07-24 08:49:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 7666 3: 2025-07-24 08:49:40
Backtrace	app/helpers.php:496 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#511db_collegesearch_new2.44ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%exam%' and `sub_type` like '%about%' and `module_id` in ('132', '2240', '23', '2342', '90', '116', '161', '2008', '30', '21') and `expiry_date` > '2025-07-24 08:49:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 132 3: 2240 4: 23 5: 2342 6: 90 7: 116 8: 161 9: 2008 10: 30 11: 21 12: 2025-07-24 08:49:40
Backtrace	app/helpers.php:511 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#525db_collegesearch_new2.01ms

select `module_type`, `module_id`, `description`, `created_by`, `created_at`, `updated_by`, `updated_at`, `expiry_date`, `deleted_at` from `latest_updates_widgets` where `module_type` like '%course%' and `module_id` in ('1', '10', '14', '23', '25', '60', '11', '2', '8', '59', '70', '13', '41', '120', '43') and `sub_type` like '%about%' and `expiry_date` > '2025-07-24 08:49:40' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 1 2: 10 3: 14 4: 23 5: 25 6: 60 7: 11 8: 2 9: 8 10: 59 11: 70 12: 13 13: 41 14: 120 15: 43 16: %about% 17: 2025-07-24 08:49:40
Backtrace	app/helpers.php:525 app/Http/Controllers/CollegeController.php:96 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

CollegeController.php#826db_collegesearch_new640μs

select * from `meta_tags` where `slug` = 'university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622 1: active
Backtrace	app/Http/Controllers/CollegeController.php:826 app/Http/Controllers/CollegeController.php:128 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

helpers.php#157db_collegesearch_new1.28msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: active
Backtrace	app/helpers.php:157 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

App\Models\InstituteProgram: 81InstituteProgram.php#?
App\Models\InstituteProgramFeesSummary: 60InstituteProgramFeesSummary.php#?
App\Models\Program: 56Program.php#?
App\Models\InstituteProgramPlacement: 34InstituteProgramPlacement.php#?
App\Models\Course: 17Course.php#?
App\Models\InstituteRecruiter: 14InstituteRecruiter.php#?
App\Models\Recruiter: 14Recruiter.php#?
App\Models\DefaultMetaTag: 13DefaultMetaTag.php#?
App\Models\InstituteProgramExamMapping: 11InstituteProgramExamMapping.php#?
App\Models\InstituteImage: 8InstituteImage.php#?
App\Models\ExamFeatureMapping: 8ExamFeatureMapping.php#?
App\Models\ExamFeature: 8ExamFeature.php#?
App\Models\RecruiterIndustryType: 8RecruiterIndustryType.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\InstituteFaculty: 2InstituteFaculty.php#?
App\Models\InstituteProgramFee: 2InstituteProgramFee.php#?
App\Models\Institute: 1Institute.php#?
App\Models\City: 1City.php#?
App\Models\State: 1State.php#?
App\Models\InstituteFeatureMapping: 1InstituteFeatureMapping.php#?
App\Models\InstituteFeature: 1InstituteFeature.php#?
App\Models\Degree: 1Degree.php#?
App\Models\Stream: 1Stream.php#?
App\Models\FeesType: 1FeesType.php#?
App\Models\Exam: 1Exam.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: 6xroQoO0MGk0v5ozOsqluAyDgICrKXuZdrYHR88s
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/university/charotar-university-of-science-and...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImprSFlJL3dGSDNEdEVIOUhNcWhEYnc9PSIsInZhbHVlIjoiZ0VjVDVERnlKd0lEUjJra3MvYlFzQzhkVlBVSkNCNkREc21EVUM5UUtlTS9TZmUwcUhFeEdQeWlETW5MbXNyaG5YUUI4R3ArMVdkM1VwSklIYlg3K0lBL3p2N2lpSzlrdzg2Y1J6Q1ByWDZwTDE1ZFdmQ0krU3g3d01lNWs4dm8iLCJtYWMiOiI1OTcxNjkzODRlNjZmNGJkYzI3Y2FiNTNiZGE3Nzk5NzgzMmNlODllOGIxYTc2MzE1NDg2MGY4ZjM4Mjg4NzYyIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IktYSmd2d2JwdHR5akRRQksrODNRYWc9PSIsInZhbHVlIjoiS1VuTEprR0VVeE5oUTcrUER4NktBZzNVNXdxbVVTSlVCSkgxVE9GbThIeWxnSUtlZ1FnSXhFNjdmRTlkSjZmamZyQnpCUWY0c0doODZiampJSmpBd29WUmloNU5WVUtrWnh6dFNWYTIyMmpoVkoxY0h4QlVxa2RVbS9UMWNzamwiLCJtYWMiOiIxZmNkMTQ3Mzk5NDU2ODExZTdjZDIxMjM0NDZlZTVlOTBkZjk1ZTY5NTkwM2Q4ZDdjY2EzZjA3MTdmYmIzZDIzIiwidGFnIjoiIn0%3D; course_id=15; course_name=B.Arch; viewed_colleges=%5B13064%2C38954%2C7760%5D ◀XSRF-TOKEN=eyJpdiI6ImprSFlJL3dGSDNEdEVIOUhNcWhEYnc9PSIsInZhbHVlIjoiZ0VjVDVERnlKd0lEUjJra3MvYlFzQzhkVlBVSkNCNkREc21EVUM5UUtlTS9TZmUwcUhFeEdQeWlETW5MbXNyaG5YUUI4R ▶"
  ]
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

  0 of 0   
array:5 [▼
  "XSRF-TOKEN" => "6xroQoO0MGk0v5ozOsqluAyDgICrKXuZdrYHR88s"
  "laravel_session" => "jb2VORHiJqwaWrq8bcONJdijNqaGqItCGeWzpuQO"
  "course_id" => "15"
  "course_name" => "B.Arch"
  "viewed_colleges" => "[13064,38954,7760]"
]

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 => "Thu, 24 Jul 2025 08:49:40 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNtZDIzTDRLRmt3WC9IcDVXZjNNc2c9PSIsInZhbHVlIjoiN2VxNFFjQ0c2K3hqU2hreFo4NUlsN2RIaWUyL09kRitFa0ExWlNUYVFoemMvZUZiUVowNDF0UExWUFhCN1U5Nk80RHloN09lKy9DSlBNSVRTSzJzUmRpNWc3TWM0YTR2RFJGamphd1RzUWZVZWh5Q0xlT1dTQXM5Z3AvSG1qWXoiLCJtYWMiOiJjNjQwZDE2ZmJjMGEyMzM0Zjc2NTAwZDEzNzhhMjk2ODk0ODFjNDc1ZDNkZDQ5NDA2YTBmOWIyZDBhNzgxNWJlIiwidGFnIjoiIn0%3D; expires=Thu, 24 Jul 2025 10:49:40 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InNtZDIzTDRLRmt3WC9IcDVXZjNNc2c9PSIsInZhbHVlIjoiN2VxNFFjQ0c2K3hqU2hreFo4NUlsN2RIaWUyL09kRitFa0ExWlNUYVFoemMvZUZiUVowNDF0UExWUFhCN1U5Nk80RHloN ▶"
    1 => "laravel_session=eyJpdiI6ImlOSVB1OTVGTXpzK294b1Vod1Z5NkE9PSIsInZhbHVlIjoiRFF2emJzVjZxWVhQbzZpenZvTGVpaHpPSFlFY0NoR0E3eCt2L2wwbk81OWp0Z3VzbVdDTTlQYXZlOVd0QWMrRTFLdmdGMkFwVXNLeGhvT3JxSWppbG9maUFGSjh2ZXVIMUJRTHMwRnY4eEFhTVQ1RGl5TVJhTzJnZmc3aUo4RTciLCJtYWMiOiJkMGY2MDU1MmU0NGM3MjYzMDc5YmY3ODkwMWIwN2JkNzQwYzhkYzI4ZDE4MDdjM2VlOTQ5OWQ5NjUyMWFiNzY0IiwidGFnIjoiIn0%3D; expires=Thu, 24 Jul 2025 10:49:40 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImlOSVB1OTVGTXpzK294b1Vod1Z5NkE9PSIsInZhbHVlIjoiRFF2emJzVjZxWVhQbzZpenZvTGVpaHpPSFlFY0NoR0E3eCt2L2wwbk81OWp0Z3VzbVdDTTlQYXZlOVd0QWMrRTFL ▶"
    2 => "course_id=14; expires=Fri, 24 Jul 2026 08:49:40 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=M.Pharm; expires=Fri, 24 Jul 2026 08:49:40 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B13064%2C38954%2C7760%2C7666%5D; expires=Sat, 23 Aug 2025 08:49:40 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNtZDIzTDRLRmt3WC9IcDVXZjNNc2c9PSIsInZhbHVlIjoiN2VxNFFjQ0c2K3hqU2hreFo4NUlsN2RIaWUyL09kRitFa0ExWlNUYVFoemMvZUZiUVowNDF0UExWUFhCN1U5Nk80RHloN09lKy9DSlBNSVRTSzJzUmRpNWc3TWM0YTR2RFJGamphd1RzUWZVZWh5Q0xlT1dTQXM5Z3AvSG1qWXoiLCJtYWMiOiJjNjQwZDE2ZmJjMGEyMzM0Zjc2NTAwZDEzNzhhMjk2ODk0ODFjNDc1ZDNkZDQ5NDA2YTBmOWIyZDBhNzgxNWJlIiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 10:49:40 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InNtZDIzTDRLRmt3WC9IcDVXZjNNc2c9PSIsInZhbHVlIjoiN2VxNFFjQ0c2K3hqU2hreFo4NUlsN2RIaWUyL09kRitFa0ExWlNUYVFoemMvZUZiUVowNDF0UExWUFhCN1U5Nk80RHloN ▶"
    1 => "laravel_session=eyJpdiI6ImlOSVB1OTVGTXpzK294b1Vod1Z5NkE9PSIsInZhbHVlIjoiRFF2emJzVjZxWVhQbzZpenZvTGVpaHpPSFlFY0NoR0E3eCt2L2wwbk81OWp0Z3VzbVdDTTlQYXZlOVd0QWMrRTFLdmdGMkFwVXNLeGhvT3JxSWppbG9maUFGSjh2ZXVIMUJRTHMwRnY4eEFhTVQ1RGl5TVJhTzJnZmc3aUo4RTciLCJtYWMiOiJkMGY2MDU1MmU0NGM3MjYzMDc5YmY3ODkwMWIwN2JkNzQwYzhkYzI4ZDE4MDdjM2VlOTQ5OWQ5NjUyMWFiNzY0IiwidGFnIjoiIn0%3D; expires=Thu, 24-Jul-2025 10:49:40 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6ImlOSVB1OTVGTXpzK294b1Vod1Z5NkE9PSIsInZhbHVlIjoiRFF2emJzVjZxWVhQbzZpenZvTGVpaHpPSFlFY0NoR0E3eCt2L2wwbk81OWp0Z3VzbVdDTTlQYXZlOVd0QWMrRTFL ▶"
    2 => "course_id=14; expires=Fri, 24-Jul-2026 08:49:40 GMT; path=/"
    3 => "course_name=M.Pharm; expires=Fri, 24-Jul-2026 08:49:40 GMT; path=/"
    4 => "viewed_colleges=%5B13064%2C38954%2C7760%2C7666%5D; expires=Sat, 23-Aug-2025 08:49:40 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "6xroQoO0MGk0v5ozOsqluAyDgICrKXuZdrYHR88s"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622 ◀https://www.dev.collegesearch.in/university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-1062 ▶"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-07-24 08:49:40	GET	/university/charotar-university-of-science-and-technology-charusat-anand/courses-fees/mpharm-mpharm-drug-regulatory-affairs-10622	13 63 358

1 x Application (95.92%)	218ms
1 x Booting (4.08%)	9.29ms