Master of Pharmacy Pharmaceutics in BITS Pilani Fees Breakup, Total Fees, Eligibility.

Master of Pharmacy Pharmaceutics BITS Pilani Overview

Master of Pharmacy Pharmaceutics is a 2 year course at BITS Pilani. The total fees for Master of Pharmacy Pharmaceutics at BITS Pilani is -. To get admission in Master of Pharmacy Pharmaceutics at BITS Pilani, students must meet some eligibility requirements, that is M.Pharm (Pharmaceutics/Pharmaceutical Chemistry):- Candidate should have passed the integrated first degree of BITS in Pharmacy or its equivalent.. This program helps students with the necessary skills to build a successful career in the Pharmacy.

Master of Pharmacy Pharmaceutics BITS Pilani Highlights

Particular	Details
Total Seats	30
Course Fee	N/A
Duration	2 Years
Accepted Exams	GATE,

About Master of Pharmacy Pharmaceutics

Program Duration
Full Time ,2 Years

Course Type
PG , Pharmacy

Eligibility
M.Pharm (Pharmaceutics/Pharmaceutical Chemistry):- Candidate should have passed the integrated first degree of BITS in Pharmacy or its equivalent. Read More

Master of Pharmacy Pharmaceutics BITS Pilani Fee Structure

Master of Pharmacy Pharmaceutics fees for BITS Pilani 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 Pharmaceutics Fee Breakup

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

Master of Pharmacy Pharmaceutics BITS Pilani Eligibility

Students who are seeking admission in 2 year M.Pharm Master of Pharmacy Pharmaceutics program at the BITS Pilani should meet the following eligibility criteria.

M.Pharm (Pharmaceutics/Pharmaceutical Chemistry):- Candidate should have passed the integrated first degree of BITS in Pharmacy or its equivalent.

Master of Pharmacy Pharmaceutics BITS Pilani Admission Process

To take admission in Master of Pharmacy Pharmaceutics at BITS Pilani, candidates must possess a valid score in GATE, or any other state-level examination.

Admission will be on the basis of the qualifying exam (GPAT).

Master of Pharmacy Pharmaceutics Fee Payment Options

BITS Pilani 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 BITS Pilani.
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 BITS Pilani campus.
Delay in fee payment can cause a fine as per BITS Pilani rules and regulations.

BITS Pilani Fees Inquiry

Contact Information for students to find out more about the BITS Pilani Fees

Contact Number - 242179, 2850100
E-mail at: mmsanand@bits-pilani.ac.in
Admission Block Address - Vidya Vihar, Pilani

Master of Pharmacy Pharmaceutics BITS Pilani Top Recruiters

Aditya Birla Group

Adobe

Amazon

Arista Networks

Atrenta

Avery Dennison

B & S Engineering Consultants

BAIN

Barclays Technology

BeeHyv Software Solutions Pvt. Ltd

Bank of America

BOCL

Brahmos Aerospace

Bravo Lucy

Broadcom India research Pvt Ltd

Brocade

CA Technologies

Cadence Design Systems

Capital IQ

Capital One Financial Services

Carrier Aircon

Caterpillar

Chambal Fertilisers and Chemicals Limited

Cisco

Citicorp Finance India Ltd.

Citrix

Cognizant

CommVault Systems India Pvt. Ltd., Hyderabad

Concept Management Consulting Limited

Converteam (GE Energy)

View All Recruiters Details

Student's Rating for BITS Pilani

Student Reviews & Ratings

3.9/5 Based on 15 Verified Reviews

Component Ratings

Faculty Rating 4.3

Infrastructure Rating 4.6

Placements Rating 4.5

Admission Rating 3.9

Hostel Rating 4.3

Club Rating 4.2

Student's Reviews for BITS Pilani

Admission

Placement

Faculty

4.5 Overall 09-02-2024

Anonymous User
MBA Student

4.5 Placement 4.5 Faculty 4 Admission

The college has stellar reputation and often provides good placement opportunities to the students. $The college is unable to provide great opportunities of placements and internships to all students equally.

Placement: The placement procedure begins in the third semester. There is a practice school at BITS Pilani. Its purpose is to train students on the job, and students are sent to different companies for training. Various organizations, including HSBC, Barclays, Accen

Infrastructure: Amenities, sporting facilities, and stunning campus. Temples and friendly people on and around campus.

Admission: Candidates must fill out the form available on the university’s official website. They must upload all necessary paperwork. Applicants must provide their GATE/GPAT score (if applicable) and their selected test center. The completed application form,

4 Overall 25-01-2024

Anonymous User
MBA Student

5 Infrastructure 4 Faculty 4.5 Admission 3.5 Hostel

The best thing about our college is the placements and the recruiters and the worst thing is that the there is no minimum attendance required for appearing in exams which usually discourages the students and teachers. The Meera Bhawan Girls’ Hostel

Placement: The placement drive occurs in the fourth year. The motivation is fairly strong, and around 80% of the students are placed. The average package for chemical engineering is 13 lpa. The highest package is yet to be disclosed after the placements rounds are

Faculty: Teachers are highly qualified, with some having graduated from prestigious international colleges. However, based on the course requirements, each professor’s teaching approaches are different in their own way.

Admission: Our College provides four integrated first-degree courses in Science, Technology, Pharmacy, Management, and Humanities. These courses include BE, BPharm, MSc, and MSc (Tech). Aside from these, BITS Pilani offers three higher degree courses as well includi

4.5 Overall 09-02-2024

Anonymous User
MBA Student

4.5 Placement 4.5 Faculty 4 Admission

Infrastructure: Amenities, sporting facilities, and stunning campus. Temples and friendly people on and around campus.

4 Overall 25-01-2024

Anonymous User
MBA Student

5 Infrastructure 4 Faculty 4.5 Admission 3.5 Hostel

4 Overall 25-01-2024

Anonymous User
MBA Student

5 Infrastructure 4 Faculty 4.5 Admission 3.5 Hostel

5 Overall 25-07-2021

Anonymous User
MBA Student

4.5 Infrastructure 5 Faculty 4.5 Mess

Best engineering college in india, one of the topmost rated college for engineering studies. The students and faculties all are nice and helpful. Great college overall.

Placement: I was already secured with a job and that is why I Haven’t taken it otherwise the placement is great maximum package goes to 10-12 Lacs PA.

Faculty: The education of the college is at the top level and the college having educated faculties.

Admission: State / National Entrance Exams

View All 15 Reviews

Gallery

10 Images

BITS Pilani Program Offered

4.5 Master of Pharmacy Pharmaceutical Chemistry

30 Seats 2 Years

Total Fees

₹-

Highest Package

N/A

View All Programs

Contact Details

Address

Vidya Vihar, Pilani

College Contact

24XXXXXX79

mmXXXXXXin

Messages Timeline Exceptions Views12 Route Queries64 Models346 Mails Gate Session Request

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

Booting (18.51ms)time
Application (229ms)time
1 x Application (92.51%)
229ms
1 x Booting (7.49%)
18.51ms

12 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.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:105-233

64 statements were executed (9 duplicates)Show only duplicates148ms

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_new8.45ms

select * from `seo_redirects` where `redirect_from` = '/university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271' limit 1

Bindings	0: /university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271
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_new1.27ms

select * from `meta_tags` where `slug` = 'university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271 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

CollegeController.php#130db_collegesearch_new3.1ms

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` = 'bits-pilani-birla-institute-of-technology-science-pilani' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: active 1: bits-pilani-birla-institute-of-technology-science-pilani 2: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new2.27ms

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 (1047) and `institute_programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.11ms

select `id`, `name` from `programs` where `programs`.`id` in (14, 16, 17, 18, 20, 21, 79, 103, 123, 191, 202, 918, 920, 922, 995, 1013, 1483, 1484, 1588, 1593, 1594, 1595, 1596, 1597, 1621, 1629, 1632, 1637, 1663, 1699, 1707, 1708, 1709, 2264, 2265, 2267, 2772, 2773, 2775, 2834, 2912, 3475, 3485, 3595, 5983) and `programs`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.55ms

select `id`, `name` from `courses` where `courses`.`id` in (1, 2, 10, 11, 14, 15, 23, 25, 43, 93) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.95ms

select * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (3756, 3757, 3758, 3759, 3760, 3761, 3762, 3763, 3764, 4516, 4517, 4518, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5638, 5639, 10271, 10272, 28594, 28595, 28596, 28597, 28598, 35180, 35181, 35182, 35183, 35184, 47308, 47309, 47310, 84239, 110536, 110537, 110538, 110539, 110540, 110541, 110542) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.48ms

select * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (3756, 3757, 3758, 3759, 3760, 3761, 3762, 3763, 3764, 4516, 4517, 4518, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5638, 5639, 10271, 10272, 28594, 28595, 28596, 28597, 28598, 35180, 35181, 35182, 35183, 35184, 47308, 47309, 47310, 84239, 110536, 110537, 110538, 110539, 110540, 110541, 110542) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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#130db_collegesearch_new1.27ms

select * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (3756, 3757, 3758, 3759, 3760, 3761, 3762, 3763, 3764, 4516, 4517, 4518, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5638, 5639, 10271, 10272, 28594, 28595, 28596, 28597, 28598, 35180, 35181, 35182, 35183, 35184, 47308, 47309, 47310, 84239, 110536, 110537, 110538, 110539, 110540, 110541, 110542) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:130 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.99ms

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

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

Institute.php#189db_collegesearch_new1.9ms

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

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

CollegeController.php#775db_collegesearch_new2.08ms

select `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 1047 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: 1047 1: course-fees-program-specific 2: active
Backtrace	app/Http/Controllers/CollegeController.php:775 app/Http/Controllers/CollegeController.php:345 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#346db_collegesearch_new1.67ms

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

Bindings	0: 1047
Backtrace	app/Http/Controllers/CollegeController.php:346 app/Http/Controllers/CollegeController.php:140 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#346db_collegesearch_new1.3ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:346 app/Http/Controllers/CollegeController.php:140 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#811db_collegesearch_new1.5ms

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

Bindings	0: 1047 1: about 2: active
Backtrace	app/Http/Controllers/CollegeController.php:811 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#811db_collegesearch_new1.22msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285, 324) and `admins`.`deleted_at` is null

Backtrace

app/Http/Controllers/CollegeController.php:811
app/Http/Controllers/CollegeController.php:347
app/Http/Controllers/CollegeController.php:140
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#822db_collegesearch_new1.04ms

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:822 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.85ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 1047 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1047 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:823 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47

CollegeController.php#824db_collegesearch_new980μs

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:824 app/Http/Controllers/CollegeController.php:347 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#209db_collegesearch_new1.36ms

select `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 1047 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'

Bindings	0: 1047 1: active
Backtrace	app/Models/Institute.php:209 app/Http/Controllers/CollegeController.php:349 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#138db_collegesearch_new1.76ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new2.79ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

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

Backtrace

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

Institute.php#138db_collegesearch_new1.6ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new1.54ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

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

Backtrace

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

Institute.php#138db_collegesearch_new1.86ms

select count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:138 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#151db_collegesearch_new2.27ms

select * from `institute_reviews` where `institute_reviews`.`institute_id` = 1047 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: 1047 1: 2: active
Backtrace	app/Models/Institute.php:151 app/Http/Controllers/CollegeController.php:353 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

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

Backtrace

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

CollegeController.php#563db_collegesearch_new1.81ms

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

Bindings	0: 1047 1: 10271 2: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new1.98ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new2.96ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new720μsselect * 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:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new1.6msselect * 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:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new8.35msselect * 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:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new1.37ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new1.72msselect * from `fees_types` where `fees_types`.`id` in (2)

Backtrace

app/Http/Controllers/CollegeController.php:563
app/Http/Controllers/CollegeController.php:140
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#563db_collegesearch_new1.78ms

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

Backtrace

app/Http/Controllers/CollegeController.php:563
app/Http/Controllers/CollegeController.php:140
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#563db_collegesearch_new1.4ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new1.33ms

select * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (116) 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:563 app/Http/Controllers/CollegeController.php:140 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#563db_collegesearch_new920μs

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:563 app/Http/Controllers/CollegeController.php:140 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_new2.67ms

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` = 116 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1

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

Exam.php#58db_collegesearch_new1.93ms

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:564 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.21ms

select * from `institute_ranks` where `institute_ranks`.`institute_id` = 1047 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: 1047 1: cs 2: nirf 3: 14 4: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:574 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

Institute.php#276db_collegesearch_new1.32msselect * from `courses` where `courses`.`id` in (14) and `courses`.`deleted_at` is null and `status` = 'active'

Bindings	0: active
Backtrace	app/Models/Institute.php:276 app/Http/Controllers/CollegeController.php:574 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#584db_collegesearch_new1.57ms

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

Bindings	0: 14 1: 1047 2: 10271 3: active
Backtrace	app/Http/Controllers/CollegeController.php:584 app/Http/Controllers/CollegeController.php:140 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#584db_collegesearch_new1.47ms

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

Bindings	0: active
Backtrace	app/Http/Controllers/CollegeController.php:584 app/Http/Controllers/CollegeController.php:140 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#588db_collegesearch_new1.23ms

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:588 app/Http/Controllers/CollegeController.php:140 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#588db_collegesearch_new2ms

select `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (2, 9, 11, 12, 14, 499, 519, 991, 998, 1367, 1494, 1668, 2996, 2997, 3211, 3234, 3239, 3287, 3489, 3711, 3796, 3854, 3867, 3870, 3875, 3965, 3997, 4142, 4147, 4148)

Backtrace

app/Http/Controllers/CollegeController.php:588
app/Http/Controllers/CollegeController.php:140
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#588db_collegesearch_new820μs

select `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (1, 2, 5, 6, 24, 27, 29, 30, 54, 66, 93, 105, 107, 108, 150, 193, 203, 204, 214, 345)

Backtrace

app/Http/Controllers/CollegeController.php:588
app/Http/Controllers/CollegeController.php:140
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#593db_collegesearch_new1.9ms

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

Bindings	0: 1047 1: 14 2: active
Backtrace	app/Http/Controllers/CollegeController.php:593 app/Http/Controllers/CollegeController.php:140 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#601db_collegesearch_new1.14ms

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 (10271, 10272) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`

Bindings	0: 10271 1: 10272 2: active
Backtrace	app/Http/Controllers/CollegeController.php:601 app/Http/Controllers/CollegeController.php:140 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#225db_collegesearch_new26.78ms

select `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 1047 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: 1047 2: course-fees-program-specific 3: institute 4: active
Backtrace	app/Models/Institute.php:225 app/Http/Controllers/CollegeController.php:724 app/Http/Controllers/CollegeController.php:140 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266

CollegeController.php#725db_collegesearch_new1.07ms

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:725 app/Http/Controllers/CollegeController.php:140 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#726db_collegesearch_new1.84ms

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:726 app/Http/Controllers/CollegeController.php:140 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#309db_collegesearch_new920μs

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

Bindings	0: 10271 1: active
Backtrace	app/Http/Controllers/CollegeController.php:309 app/Http/Controllers/CollegeController.php:159 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#309db_collegesearch_new1.29ms

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:309 app/Http/Controllers/CollegeController.php:159 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#1038db_collegesearch_new960μs

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

Bindings	0: 1047 1: active
Backtrace	app/Http/Controllers/CollegeController.php:1038 app/Http/Controllers/CollegeController.php:160 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#1044db_collegesearch_new2.09ms

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` = 1047

Bindings	0: 1047
Backtrace	app/Http/Controllers/CollegeController.php:1044 app/Http/Controllers/CollegeController.php:160 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#491db_collegesearch_new3.31ms

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` = 1047 and `expiry_date` > '2025-04-23 15:43:44' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2

Bindings	0: %cp% 1: %course-fees-program-specific% 2: 1047 3: 2025-04-23 15:43:44
Backtrace	app/helpers.php:491 app/Http/Controllers/CollegeController.php:160 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#506db_collegesearch_new3.54ms

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 ('15', '21', '22', '23', '51', '93', '116', '132', '2240', '2008', '2342', '27') and `expiry_date` > '2025-04-23 15:43:44' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4

Bindings	0: %exam% 1: %about% 2: 15 3: 21 4: 22 5: 23 6: 51 7: 93 8: 116 9: 132 10: 2240 11: 2008 12: 2342 13: 27 14: 2025-04-23 15:43:44
Backtrace	app/helpers.php:506 app/Http/Controllers/CollegeController.php:160 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#520db_collegesearch_new2.07ms

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', '2', '10', '14', '23', '25', '11', '43', '93', '15') and `sub_type` like '%about%' and `expiry_date` > '2025-04-23 15:43:44' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1

Bindings	0: %course% 1: 1 2: 2 3: 10 4: 14 5: 23 6: 25 7: 11 8: 43 9: 93 10: 15 11: %about% 12: 2025-04-23 15:43:44
Backtrace	app/helpers.php:520 app/Http/Controllers/CollegeController.php:160 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#890db_collegesearch_new2.61ms

select * from `meta_tags` where `slug` = 'university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1

Bindings	0: university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271 1: active
Backtrace	app/Http/Controllers/CollegeController.php:890 app/Http/Controllers/CollegeController.php:192 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#156db_collegesearch_new1.17msselect * from `brandings` where `section` = 'institute' and `brandings`.`deleted_at` is null and `status` = 'active'

Bindings	0: institute 1: active
Backtrace	app/helpers.php:156 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: 60InstituteProgram.php#?
App\Models\Program: 45Program.php#?
App\Models\InstituteProgramFeesSummary: 45InstituteProgramFeesSummary.php#?
App\Models\InstituteRecruiter: 30InstituteRecruiter.php#?
App\Models\Recruiter: 30Recruiter.php#?
App\Models\InstituteProgramPlacement: 20InstituteProgramPlacement.php#?
App\Models\InstituteImage: 20InstituteImage.php#?
App\Models\RecruiterIndustryType: 20RecruiterIndustryType.php#?
App\Models\InstituteProgramExamMapping: 14InstituteProgramExamMapping.php#?
App\Models\Course: 13Course.php#?
App\Models\InstituteContent: 7InstituteContent.php#?
App\Models\InstituteReview: 6InstituteReview.php#?
App\Models\InstituteFaculty: 5InstituteFaculty.php#?
App\Models\ExamFeatureMapping: 5ExamFeatureMapping.php#?
App\Models\ExamFeature: 5ExamFeature.php#?
App\Models\User: 3User.php#?
App\Models\Branding: 3Branding.php#?
App\Models\Admin: 2Admin.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\InstituteRank: 1InstituteRank.php#?
App\Models\InstituteRating: 1InstituteRating.php#?

_token: g082dWSnVWObicmKSAqPubyzmosdv8oVvoHV8hju
_previous: array:1 [ "url" => "https://www.dev.collegesearch.in/university/bits-pilani-birla-institute-of-tec...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "www.dev.collegesearch.in"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 23 Apr 2025 15:43:44 GMT"
  ]
  "set-cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpHdFpFK2s4Zzc4SjIwQ0VxYTdzUEE9PSIsInZhbHVlIjoiblJTV2NhSE5qa1Z4UURFNnBYNjV5ejFSTmNGQ0ZPUFBGY1l4Y3doR3M4TmxmK00xR3UweFpBY0pycHhpOSthNHFKbDVGaThDM1hZWFFLeTNjd0JEcXRrK1gwa0JCNXY5NFNXZWd0a1pkcDZjaWNzRUJ0bVQvUW1uV3VxaGNDay8iLCJtYWMiOiJiODZmZGUyMzc3YmE5NDNhMWE3OTU2YmU3NjlhMGQ5NWQzNmQ4ZDk2MTFjYjJmNjRiYmFiNzMxODJlMzJhYTBjIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 17:43:44 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImpHdFpFK2s4Zzc4SjIwQ0VxYTdzUEE9PSIsInZhbHVlIjoiblJTV2NhSE5qa1Z4UURFNnBYNjV5ejFSTmNGQ0ZPUFBGY1l4Y3doR3M4TmxmK00xR3UweFpBY0pycHhpOSthNHFKbDVGa ▶"
    1 => "laravel_session=eyJpdiI6IlNNL2dMbFRWbWVTTlRTTXNNZ0RvRnc9PSIsInZhbHVlIjoiN1pDSmhwdmUvajhvb2F0M1VvL3BmdnpncVRUeTA0dWptVDliTU9uekw0VFBvMEl1akRzdVdjbWhwRWQzWEJsMFkvSGcxWTc1bGhrazVOeUVsdUl6VjZvYkJ0YWo1bWFWOFl2SC9DdkUvSm1vMlhOTUo0bERUclFDWk9Ub0plSm4iLCJtYWMiOiJmY2RhMGE1MDczOTUzZWQ2NWIzNWQxN2Y2NjAxODM3YjU4Zjg1NjgwMmU3ZGUxN2RkZGVkOWY2MTU1MjNjNjEzIiwidGFnIjoiIn0%3D; expires=Wed, 23 Apr 2025 17:43:44 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlNNL2dMbFRWbWVTTlRTTXNNZ0RvRnc9PSIsInZhbHVlIjoiN1pDSmhwdmUvajhvb2F0M1VvL3BmdnpncVRUeTA0dWptVDliTU9uekw0VFBvMEl1akRzdVdjbWhwRWQzWEJsMFkv ▶"
    2 => "course_id=14; expires=Thu, 23 Apr 2026 15:43:44 GMT; Max-Age=31536000; path=/; samesite=lax"
    3 => "course_name=M.Pharm; expires=Thu, 23 Apr 2026 15:43:44 GMT; Max-Age=31536000; path=/; samesite=lax"
    4 => "viewed_colleges=%5B1047%5D; expires=Fri, 23 May 2025 15:43:44 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax"
  ]
  "Set-Cookie" => array:5 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpHdFpFK2s4Zzc4SjIwQ0VxYTdzUEE9PSIsInZhbHVlIjoiblJTV2NhSE5qa1Z4UURFNnBYNjV5ejFSTmNGQ0ZPUFBGY1l4Y3doR3M4TmxmK00xR3UweFpBY0pycHhpOSthNHFKbDVGaThDM1hZWFFLeTNjd0JEcXRrK1gwa0JCNXY5NFNXZWd0a1pkcDZjaWNzRUJ0bVQvUW1uV3VxaGNDay8iLCJtYWMiOiJiODZmZGUyMzc3YmE5NDNhMWE3OTU2YmU3NjlhMGQ5NWQzNmQ4ZDk2MTFjYjJmNjRiYmFiNzMxODJlMzJhYTBjIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 17:43:44 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImpHdFpFK2s4Zzc4SjIwQ0VxYTdzUEE9PSIsInZhbHVlIjoiblJTV2NhSE5qa1Z4UURFNnBYNjV5ejFSTmNGQ0ZPUFBGY1l4Y3doR3M4TmxmK00xR3UweFpBY0pycHhpOSthNHFKbDVGa ▶"
    1 => "laravel_session=eyJpdiI6IlNNL2dMbFRWbWVTTlRTTXNNZ0RvRnc9PSIsInZhbHVlIjoiN1pDSmhwdmUvajhvb2F0M1VvL3BmdnpncVRUeTA0dWptVDliTU9uekw0VFBvMEl1akRzdVdjbWhwRWQzWEJsMFkvSGcxWTc1bGhrazVOeUVsdUl6VjZvYkJ0YWo1bWFWOFl2SC9DdkUvSm1vMlhOTUo0bERUclFDWk9Ub0plSm4iLCJtYWMiOiJmY2RhMGE1MDczOTUzZWQ2NWIzNWQxN2Y2NjAxODM3YjU4Zjg1NjgwMmU3ZGUxN2RkZGVkOWY2MTU1MjNjNjEzIiwidGFnIjoiIn0%3D; expires=Wed, 23-Apr-2025 17:43:44 GMT; path=/; secure; httponly ◀laravel_session=eyJpdiI6IlNNL2dMbFRWbWVTTlRTTXNNZ0RvRnc9PSIsInZhbHVlIjoiN1pDSmhwdmUvajhvb2F0M1VvL3BmdnpncVRUeTA0dWptVDliTU9uekw0VFBvMEl1akRzdVdjbWhwRWQzWEJsMFkv ▶"
    2 => "course_id=14; expires=Thu, 23-Apr-2026 15:43:44 GMT; path=/"
    3 => "course_name=M.Pharm; expires=Thu, 23-Apr-2026 15:43:44 GMT; path=/"
    4 => "viewed_colleges=%5B1047%5D; expires=Fri, 23-May-2025 15:43:44 GMT; path=/; secure; httponly"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "g082dWSnVWObicmKSAqPubyzmosdv8oVvoHV8hju"
  "_previous" => array:1 [▶
    "url" => "https://www.dev.collegesearch.in/university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-23 15:43:44	GET	/university/bits-pilani-birla-institute-of-technology-science-pilani/courses-fees/mpharm-mpharm-pharmaceutics-10271	12 64 346

1 x Application (92.51%)	229ms
1 x Booting (7.49%)	18.51ms