Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) MICA, Ahmedabad Overview

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) is a 1 year course at MICA, Ahmedabad. The total fees for Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) at MICA, Ahmedabad is 1,30,000. This program helps students with the necessary skills to build a successful career in the Management.

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) MICA, Ahmedabad Highlights

Particular Details
Total Seats N/A
Course Fee 1,30,000
Duration 1 Years
Accepted Exams CAT

About Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR)

Program Duration
Full Time ,1 Years

Course Type
PG , Management

Eligibility
Read More

Check Eligibility Brochure

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) MICA, Ahmedabad Fee Structure

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) fees for MICA, Ahmedabad 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:

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) Fee Breakup

Fees (Rs.) Year 1
Total Fees ₹ 1,30,000

Popular Exams

Exam Month

November

Accepting Colleges
Last Date to Apply

29th November, 2025

Apply Now
admission

Admission Open

Apply in MICA, Ahmedabad Now!
admission

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) Fee Payment Options

MICA, Ahmedabad 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 MICA, Ahmedabad.
  • Candidates need to issue a draft in favor of the university to pay the course fee.
  • The university 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 MICA, Ahmedabad campus.
  • Delay in fee payment can cause a fine as per MICA, Ahmedabad rules and regulations.

MICA, Ahmedabad Fees Inquiry

Contact Information for students to find out more about the MICA, Ahmedabad Fees

  • Contact Number - 308250,
  • E-mail at: brahma.raval@micamail.in
  • Admission Block Address - Shela

Post Graduate Certificate Programme in Advertising Management and Public Relations (PGCPAMPR) MICA, Ahmedabad Top Recruiters

Wipro Wipro
Reckitt Benckiser (I) Pvt. Ltd Reckitt Benckiser (I) Pvt. Ltd
3M 3M
Hero cycles Pvt ltd Hero cycles Pvt ltd
Loreal Loreal
Britannia Industries Britannia Industries
tatamotors tatamotors
Cafe Coffee Day Cafe Coffee Day
Amazon Amazon
Google Google
Dabur India Ltd. Dabur India Ltd.
Amul Amul
AC Nielson AC Nielson
Ernst & Young Ernst & Young
UTV UTV
SONY INDIA SONY INDIA
Times Group Times Group
General Mills General Mills
Vodafone Vodafone
TNS India TNS India
TAM Media Research TAM Media Research
Millward Brown Millward Brown
Rediffussion Rediffussion
Viacom Viacom
Network 18 Network 18
Star TV Star TV
Cognizant Cognizant
FLIPKART FLIPKART
ICICI Bank ICICI Bank
microsoft microsoft
View All Recruiters Details

Student's Rating for MICA, Ahmedabad

Student Reviews & Ratings
4.5/5 Based on 2 Verified Reviews
Component Ratings
Faculty Rating 4
Infrastructure Rating 4.5
Admission Rating 3.5
Hostel Rating 5
Club Rating 4.2

Student's Reviews for MICA, Ahmedabad

Admission
Placement
Faculty
4 Overall 25-07-2021
A

Anonymous User
MBA Student

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

Admission: Based on School / 12th Class Result, State / National Entrance Exams, College’s Internal Written Exam, Group Discussion / Personal Interview

Club: There’s a niche for everyone.

Mess: Food, Ambience, Hospitality, Infrastructure

Read More
5 Overall 25-07-2021
A

Anonymous User
MBA Student

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

Admission: College’s Internal Written Exam, Group Discussion / Personal Interview

Mess: Ambience, Hospitality

Read More
View All 2 Reviews

Gallery

30 Images
Convocation

Convocation

Campus

Campus

Campus

Campus

Cultural Activity

Cultural Activity

Campus

Campus

Campus

Campus

Campus

Campus

MICA

MICA

View All 30 Images

MICA, Ahmedabad Program Offered

4.5 Fellow Programme in Management (FPM) Digital Marketing
2 Years
Total Fees

₹27,500

Admission 2025
Highest Package

N/A

Brochure
4.5 Fellow Programme in Management (FPM) Management
2 Years
Total Fees

₹27,500

Admission 2025
Highest Package

N/A

Brochure
4.5 Fellow Programme in Management (FPM) Marketing
2 Years
Total Fees

₹27,500

Admission 2025
Highest Package

N/A

Brochure
View All Programs

Contact Details

Address

Shela

College Contact

30XXXXXX50

Email

brXXXXXXin

Get Contact Details

MICA, Ahmedabad 4.5/5 (2 reviews)

Shortlist

Brochure

Request history8.3.19PHP Version199msRequest Duration4MBMemory UsageGET {type}/{slug}/{tab}/{tab2}Route
  • warninglog[13:27:26] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • Booting (6.66ms)time
  • Application (192ms)time
  • 1 x Application (96.64%)
    192ms
    1 x Booting (3.35%)
    6.66ms
    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:110-238
    63 statements were executed (6 duplicates)Show only duplicates130ms
    • 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.64msselect * from `seo_redirects` where `redirect_from` = '/colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855' limit 1
      Bindings
      • 0: /colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855
      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_new790μsselect * from `meta_tags` where `slug` = 'colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855
      • 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.1msselect * 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#135db_collegesearch_new990μsselect `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` = 'mudra-institute-of-communication-mica-ahmedabad' and `institutes`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: active
      • 1: mudra-institute-of-communication-mica-ahmedabad
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new950μsselect `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 (1375) and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.01msselect `id`, `name` from `programs` where `programs`.`id` in (2267, 2294, 2303, 2311, 2359, 2388, 2394, 2396, 2399, 2400, 2439, 2499, 2581, 2582, 2583, 2584, 5326, 5327) and `programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new990μsselect `id`, `name` from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.38msselect * from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (37572, 37573, 37574, 37575, 37576, 43303, 43304, 43305, 43306, 43307, 43308, 43309, 43310, 43311, 43312, 43313, 43363, 43364, 43365, 43366, 47854, 47855) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new1.18msselect * from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (37572, 37573, 37574, 37575, 37576, 43303, 43304, 43305, 43306, 43307, 43308, 43309, 43310, 43311, 43312, 43313, 43363, 43364, 43365, 43366, 47854, 47855) and `institute_program_placements`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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#135db_collegesearch_new980μsselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (37572, 37573, 37574, 37575, 37576, 43303, 43304, 43305, 43306, 43307, 43308, 43309, 43310, 43311, 43312, 43313, 43363, 43364, 43365, 43366, 47854, 47855) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:135
      • 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.67msselect `name` from `cities` where `id` = 85 and `cities`.`deleted_at` is null and `cities`.`status` = 'active' order by `cities`.`name` asc limit 1
      Bindings
      • 0: 85
      • 1: active
      Backtrace
      • app/Models/Institute.php:174
      • app/Http/Controllers/CollegeController.php:348
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#189db_collegesearch_new5.56msselect `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:348
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#780db_collegesearch_new1.21msselect `institute_id`, `title`, `subpage_description`, `created_by`, `updated_by`, `type`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 1375 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: 1375
      • 1: course-fees-program-specific
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:780
      • app/Http/Controllers/CollegeController.php:350
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#351db_collegesearch_new1.87msselect * from `institute_feature_mappings` where `institute_feature_mappings`.`institute_id` = 1375 and `institute_feature_mappings`.`institute_id` is not null and `institute_feature_mappings`.`deleted_at` is null
      Bindings
      • 0: 1375
      Backtrace
      • app/Http/Controllers/CollegeController.php:351
      • app/Http/Controllers/CollegeController.php:145
      • 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#351db_collegesearch_new2.06msselect `id`, `name`, `type` from `institute_features` where `institute_features`.`id` in (4, 5, 7) and `institute_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:351
      • app/Http/Controllers/CollegeController.php:145
      • 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#816db_collegesearch_new2.83msselect `institute_id`, `title`, `info_description`, `created_by`, `type`, `updated_by`, `created_at`, `updated_at` from `institute_contents` where `institute_contents`.`institute_id` = 1375 and `institute_contents`.`institute_id` is not null and `type` != 'about' and `institute_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: about
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:816
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#816db_collegesearch_new810μsselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261, 324) and `admins`.`deleted_at` is null
      Backtrace
      • app/Http/Controllers/CollegeController.php:816
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#827db_collegesearch_new1.01msselect count(*) as aggregate from `institute_recruiters` where `institute_recruiters`.`institute_id` = 1375 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:827
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#209db_collegesearch_new1.34msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 1375 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:828
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
    • CollegeController.php#829db_collegesearch_new1.21msselect `institute_id`, `name`, `position`, `education`, `speciality`, `icon` from `institute_faculties` where `institute_faculties`.`institute_id` = 1375 and `institute_faculties`.`institute_id` is not null and `institute_faculties`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:829
      • app/Http/Controllers/CollegeController.php:352
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#209db_collegesearch_new2.14msselect `id`, `institute_id`, `media_type`, `file_name`, `title` from `institute_images` where `institute_images`.`institute_id` = 1375 and `institute_images`.`institute_id` is not null and `institute_images`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Models/Institute.php:209
      • app/Http/Controllers/CollegeController.php:354
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.67msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new1.1msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new740μsselect `id`, `name`, `email`, `student_image` from `students` where `students`.`id` in (27943)
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.41msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new2.81msselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#138db_collegesearch_new1.35msselect count(*) as aggregate from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:138
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#151db_collegesearch_new930μsselect * from `institute_reviews` where `institute_reviews`.`institute_id` = 1375 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: 1375
      • 1: 
      • 2: active
      Backtrace
      • app/Models/Institute.php:151
      • app/Http/Controllers/CollegeController.php:358
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#568db_collegesearch_new2.49msselect * from `institute_programs` where `institute_id` = 1375 and `institute_programs`.`id` = '47855' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 1375
      • 1: 47855
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.26msselect * from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (47855) and `institute_program_contents`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.1msselect `id`, `institute_program_id`, `total_fees` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (47855) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new2.05msselect * from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.72msselect * 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:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new2.94msselect * from `streams` where `streams`.`id` in (2) and `streams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 2
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.27msselect * from `institute_program_fees` where `institute_program_fees`.`institute_program_id` in (47855) and `institute_program_fees`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.1msselect * from `fees_types` where `fees_types`.`id` in (12)
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.41msselect `id`, `exam_id`, `institute_program_id` from `institute_program_exam_mappings` where `institute_program_exam_mappings`.`institute_program_id` in (47855)
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new2.21msselect `id`, `name`, `display_name`, `slug`, `logo` from `exams` where `exams`.`id` in (21) and `exams`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new1.14msselect * from `exam_feature_mappings` where `exam_feature_mappings`.`exam_id` in (21) 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:568
      • app/Http/Controllers/CollegeController.php:145
      • 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#568db_collegesearch_new930μsselect `id`, `name`, `type` from `exam_features` where `exam_features`.`id` in (9, 10) and `exam_features`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:568
      • app/Http/Controllers/CollegeController.php:145
      • 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_new1.7msselect `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` = 21 and `exam_features`.`type` = 'exam_date' and `exam_feature_mappings`.`deleted_at` is null and `exam_feature_mappings`.`status` = 'active' limit 1
      Bindings
      • 0: 21
      • 1: exam_date
      • 2: active
      Backtrace
      • app/Models/Exam.php:58
      • app/Http/Controllers/CollegeController.php:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Exam.php#58db_collegesearch_new550μsselect `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:569
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#276db_collegesearch_new1.99msselect * from `institute_ranks` where `institute_ranks`.`institute_id` = 1375 and `institute_ranks`.`institute_id` is not null and `ranking_body` != 'cs' and `ranking_body` = 'nirf' and `course_id` = 2 and `institute_ranks`.`deleted_at` is null and `status` = 'active' order by `year` desc limit 1
      Bindings
      • 0: 1375
      • 1: cs
      • 2: nirf
      • 3: 2
      • 4: active
      Backtrace
      • app/Models/Institute.php:276
      • app/Http/Controllers/CollegeController.php:579
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • Institute.php#276db_collegesearch_new770μsselect * from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Models/Institute.php:276
      • app/Http/Controllers/CollegeController.php:579
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#589db_collegesearch_new1.59msselect `id`, `institute_course_name`, `duration`, `total_seats`, `slug` from `institute_programs` where (`course_id` = 2 and `institute_id` = 1375) and `id` != '47855' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 3
      Bindings
      • 0: 2
      • 1: 1375
      • 2: 47855
      • 3: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:589
      • app/Http/Controllers/CollegeController.php:145
      • 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#589db_collegesearch_new520μsselect `id`, `total_fees`, `institute_program_id` from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (37572, 37573, 37574) and `institute_program_fees_summaries`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:589
      • app/Http/Controllers/CollegeController.php:145
      • 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.69msselect distinct `institute_id`, `recruiter_id` from `institute_recruiters` where `institute_recruiters`.`institute_id` = 1375 and `institute_recruiters`.`institute_id` is not null and `institute_recruiters`.`deleted_at` is null and `status` = 'active' limit 30
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:593
      • app/Http/Controllers/CollegeController.php:145
      • 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.3msselect `id`, `name`, `icon`, `recruiter_industry_type_id` from `recruiters` where `recruiters`.`id` in (6, 9, 12, 61, 86, 89, 129, 139, 213, 783, 1335, 1450, 1626, 1640, 1833, 2329, 2695, 3298, 3447, 3636, 3674, 3677, 4444, 4463, 4713, 5147, 5243, 5256, 5441, 6166)
      Backtrace
      • app/Http/Controllers/CollegeController.php:593
      • app/Http/Controllers/CollegeController.php:145
      • 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_new660μsselect `id`, `name` from `recruiter_industry_types` where `recruiter_industry_types`.`id` in (4, 5, 8, 12, 21, 29, 30, 55, 80, 96, 138, 177, 336, 345)
      Backtrace
      • app/Http/Controllers/CollegeController.php:593
      • app/Http/Controllers/CollegeController.php:145
      • 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#598db_collegesearch_new1.82msselect `id` from `institute_programs` where `institute_id` = 1375 and `course_id` = 2 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: 2
      • 2: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:598
      • app/Http/Controllers/CollegeController.php:145
      • 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#606db_collegesearch_new1.16msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in (37572, 37573, 37574, 37575, 37576, 43303, 43304, 43305, 43306, 43307, 43308, 43309, 43310, 43311, 43312, 43313, 43363, 43364, 43365, 43366, 47854, 47855) and `institute_program_placements`.`deleted_at` is null and `status` = 'active' group by `institute_program_id`
      Bindings
      • 0: 37572
      • 1: 37573
      • 2: 37574
      • 3: 37575
      • 4: 37576
      • 5: 43303
      • 6: 43304
      • 7: 43305
      • 8: 43306
      • 9: 43307
      • 10: 43308
      • 11: 43309
      • 12: 43310
      • 13: 43311
      • 14: 43312
      • 15: 43313
      • 16: 43363
      • 17: 43364
      • 18: 43365
      • 19: 43366
      • 20: 47854
      • 21: 47855
      • 22: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:606
      • app/Http/Controllers/CollegeController.php:145
      • 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.25msselect `question`, `answer` from `faqs` where `faqs`.`faq_type` = 'institute' and `faqs`.`faq_id` = 1375 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: 1375
      • 2: course-fees-program-specific
      • 3: institute
      • 4: active
      Backtrace
      • app/Models/Institute.php:225
      • app/Http/Controllers/CollegeController.php:729
      • app/Http/Controllers/CollegeController.php:145
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
    • CollegeController.php#730db_collegesearch_new1.5msselect * from `institute_ratings` where `institute_ratings`.`institute_id` = 1375 and `institute_ratings`.`institute_id` is not null and `institute_ratings`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:730
      • app/Http/Controllers/CollegeController.php:145
      • 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#731db_collegesearch_new1.87msselect * from `institute_documents` where `institute_documents`.`institute_id` = 1375 and `institute_documents`.`institute_id` is not null and `institute_documents`.`deleted_at` is null and `status` = 'active' order by `id` desc
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:731
      • app/Http/Controllers/CollegeController.php:145
      • 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#314db_collegesearch_new1.09msselect `id`, `slug`, `institute_course_name`, `course_id` from `institute_programs` where `id` = '47855' and `institute_programs`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: 47855
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:314
      • app/Http/Controllers/CollegeController.php:164
      • 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#314db_collegesearch_new2.49msselect `id`, `name`, `slug` from `courses` where `courses`.`id` in (2) and `courses`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:314
      • app/Http/Controllers/CollegeController.php:164
      • 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#1043db_collegesearch_new1msselect distinct `course_id` from `institute_programs` where `institute_id` = 1375 and `institute_programs`.`deleted_at` is null and `status` = 'active'
      Bindings
      • 0: 1375
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:1043
      • app/Http/Controllers/CollegeController.php:165
      • 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#1049db_collegesearch_new1.64msselect 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` = 1375
      Bindings
      • 0: 1375
      Backtrace
      • app/Http/Controllers/CollegeController.php:1049
      • app/Http/Controllers/CollegeController.php:165
      • 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.41msselect `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` = 1375 and `expiry_date` > '2025-05-05 13:27:26' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 2
      Bindings
      • 0: %cp%
      • 1: %course-fees-program-specific%
      • 2: 1375
      • 3: 2025-05-05 13:27:26
      Backtrace
      • app/helpers.php:496
      • app/Http/Controllers/CollegeController.php:165
      • 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_new4.39msselect `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 ('136', '21') and `expiry_date` > '2025-05-05 13:27:26' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 4
      Bindings
      • 0: %exam%
      • 1: %about%
      • 2: 136
      • 3: 21
      • 4: 2025-05-05 13:27:26
      Backtrace
      • app/helpers.php:511
      • app/Http/Controllers/CollegeController.php:165
      • 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.15msselect `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 ('2') and `sub_type` like '%about%' and `expiry_date` > '2025-05-05 13:27:26' and `latest_updates_widgets`.`deleted_at` is null order by `updated_at` desc limit 1
      Bindings
      • 0: %course%
      • 1: 2
      • 2: %about%
      • 3: 2025-05-05 13:27:26
      Backtrace
      • app/helpers.php:525
      • app/Http/Controllers/CollegeController.php:165
      • 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#895db_collegesearch_new990μsselect * from `meta_tags` where `slug` = 'colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855' and `meta_tags`.`deleted_at` is null and `status` = 'active' limit 1
      Bindings
      • 0: colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855
      • 1: active
      Backtrace
      • app/Http/Controllers/CollegeController.php:895
      • app/Http/Controllers/CollegeController.php:197
      • 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.27msselect * 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\InstituteImage
    80InstituteImage.php#?
    App\Models\InstituteProgram
    50InstituteProgram.php#?
    App\Models\InstituteRecruiter
    30InstituteRecruiter.php#?
    App\Models\Recruiter
    30Recruiter.php#?
    App\Models\InstituteProgramFeesSummary
    26InstituteProgramFeesSummary.php#?
    App\Models\Program
    18Program.php#?
    App\Models\RecruiterIndustryType
    14RecruiterIndustryType.php#?
    App\Models\DefaultMetaTag
    13DefaultMetaTag.php#?
    App\Models\InstituteFaculty
    10InstituteFaculty.php#?
    App\Models\InstituteFeatureMapping
    9InstituteFeatureMapping.php#?
    App\Models\InstituteContent
    8InstituteContent.php#?
    App\Models\Course
    4Course.php#?
    App\Models\InstituteFeature
    3InstituteFeature.php#?
    App\Models\InstituteProgramExamMapping
    3InstituteProgramExamMapping.php#?
    App\Models\ExamFeatureMapping
    3ExamFeatureMapping.php#?
    App\Models\ExamFeature
    3ExamFeature.php#?
    App\Models\Branding
    3Branding.php#?
    App\Models\Admin
    2Admin.php#?
    App\Models\InstituteReview
    2InstituteReview.php#?
    App\Models\Institute
    1Institute.php#?
    App\Models\City
    1City.php#?
    App\Models\State
    1State.php#?
    App\Models\User
    1User.php#?
    App\Models\Degree
    1Degree.php#?
    App\Models\Stream
    1Stream.php#?
    App\Models\InstituteProgramFee
    1InstituteProgramFee.php#?
    App\Models\FeesType
    1FeesType.php#?
    App\Models\Exam
    1Exam.php#?
    App\Models\InstituteRank
    1InstituteRank.php#?
    App\Models\InstituteRating
    1InstituteRating.php#?
        _token
        pOJDfV0stzytp5tHkrpfXK0kegfZWBOm3vIM1Qch
        _previous
        array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/mudra-institute-of-communication-mic...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:16 [ "host" => array:1 [ 0 => "www.dev.collegesearch.in" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "course_id=13; course_name=BCA; viewed_colleges=%5B19443%5D; XSRF-TOKEN=eyJpdiI6IkM4ZlhuY0NXZFNGaUV3NzBsUCtQcWc9PSIsInZhbHVlIjoiZGxtVWk4Q0FSYzNaUjNrb2pvdzdxaGppMEFEenVLMmdUS0ZTMVNVc1RSa05RMFZGcmJCMVByeHBvUUpOcFBhOTZ3dlMreHBEd2JGdU1ET1NtUG5nZndrN2wvZXVPc216cXdIN3gvZVNGbENYRXhDNFBvdFdRbXRTT0htOVVnYkgiLCJtYWMiOiIxNGEyMGM0MzlkNjljMWM4Y2EwMTg2MzZkZWUwZGViMmQ1YjhkMTgwYTVkMDQxNTkwZjdhODgwZGJiOGU3OTg4IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IktrZU96NWRIUlMwQUN6UVZEeDFybUE9PSIsInZhbHVlIjoiaHFvWmRibzU0dVpNVStaTFdXTVI5SkNoYTgrbEFNRm91OEt4V3pmRDJYVkw3N1loVndua0RNa3BZckVWb1VCV2xDdVF4Q1BtWHF5NHdoK0J4QXhpYkYyVGxQdUxGUmVGUENxOUJxeHZIZW0vRjBBd1N2N1JuTEVyeW9JQzQ1dzAiLCJtYWMiOiJkOWZkYjNhNTdmOGE1YTJlN2RkMTJlMzU2ZDExOGZhZDEyOWMwMjFlNDNjOGQ3NDY3ZTlmNzFjZjJlNGJhYTIyIiwidGFnIjoiIn0%3Dcourse_id=13; course_name=BCA; viewed_colleges=%5B19443%5D; XSRF-TOKEN=eyJpdiI6IkM4ZlhuY0NXZFNGaUV3NzBsUCtQcWc9PSIsInZhbHVlIjoiZGxtVWk4Q0FSYzNaUjNrb2pvdzdxaGppM" ] "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 [ "course_id" => "13" "course_name" => "BCA" "viewed_colleges" => "[19443]" "XSRF-TOKEN" => "pOJDfV0stzytp5tHkrpfXK0kegfZWBOm3vIM1Qch" "laravel_session" => "YNJOY2jDma4ADXBfaQAoIEyttAFpachqMrSS8sMU" ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 05 May 2025 13:27:26 GMT" ] "set-cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVmVjFxaTZBbjdnM2JCSEt1SDJYNFE9PSIsInZhbHVlIjoiQWxBR1VYdGtza3hPZTRwOVEzVTRxNXVRUlRnU0oyWDFCRHJMYnVialYzZkU2UkFVVE1KaTlsemN3NVF4cHk4OWozVlVjY25jakJZZFJ3K084eS9WL0NmNisvN0J6UDBzaEFsOWVOMjNwb2g1czlLUXhXWUh3WU84NWY1RHJWN0IiLCJtYWMiOiJjNTY0OGE0YmMxNWUxODA3NjlmYzFmNzU5YTFkOGQ3MjEyMzhlNWVhODFlNTlkNjJjMDdjMjkwZTYxYTdiNDk0IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 15:27:26 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImVmVjFxaTZBbjdnM2JCSEt1SDJYNFE9PSIsInZhbHVlIjoiQWxBR1VYdGtza3hPZTRwOVEzVTRxNXVRUlRnU0oyWDFCRHJMYnVialYzZkU2UkFVVE1KaTlsemN3NVF4cHk4OWozVlVjY" 1 => "laravel_session=eyJpdiI6InpWck1hNGFQaGF6djhjZ0Fjb1RTbWc9PSIsInZhbHVlIjoiSi9TQ3EzZ0kvcE9WRW5ubFhYR21UN043L3Y2OGo1NVdBZXo4K2hHblV0eWRuTGo2SkIweW93UlRwdkpHbXVlUjRhVjRhcHlEUUtLeVJjU2ZVVEw5NWt4VklCWHVmdXNJaEQzRUFScm5yNldLRmFkQ0RTdldxTTZvQUZTY2ZWUjgiLCJtYWMiOiI1Zjk5ZTE1ZTBlZmFiNTYyMzM1NTQ3ZjkzMWQwNGE1Mjg3MGRlYmRlMmI3ZDUzMDdkOTAyNTdkOWE4OGY4NmUxIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 15:27:26 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxlaravel_session=eyJpdiI6InpWck1hNGFQaGF6djhjZ0Fjb1RTbWc9PSIsInZhbHVlIjoiSi9TQ3EzZ0kvcE9WRW5ubFhYR21UN043L3Y2OGo1NVdBZXo4K2hHblV0eWRuTGo2SkIweW93UlRwdkpHbXVlUjRh" 2 => "course_id=2; expires=Tue, 05 May 2026 13:27:26 GMT; Max-Age=31536000; path=/; samesite=lax" 3 => "course_name=MBA%20%2F%20PGDM; expires=Tue, 05 May 2026 13:27:26 GMT; Max-Age=31536000; path=/; samesite=lax" 4 => "viewed_colleges=%5B19443%2C1375%5D; expires=Wed, 04 Jun 2025 13:27:26 GMT; Max-Age=2592000; path=/; secure; httponly; samesite=lax" ] "Set-Cookie" => array:5 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVmVjFxaTZBbjdnM2JCSEt1SDJYNFE9PSIsInZhbHVlIjoiQWxBR1VYdGtza3hPZTRwOVEzVTRxNXVRUlRnU0oyWDFCRHJMYnVialYzZkU2UkFVVE1KaTlsemN3NVF4cHk4OWozVlVjY25jakJZZFJ3K084eS9WL0NmNisvN0J6UDBzaEFsOWVOMjNwb2g1czlLUXhXWUh3WU84NWY1RHJWN0IiLCJtYWMiOiJjNTY0OGE0YmMxNWUxODA3NjlmYzFmNzU5YTFkOGQ3MjEyMzhlNWVhODFlNTlkNjJjMDdjMjkwZTYxYTdiNDk0IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 15:27:26 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImVmVjFxaTZBbjdnM2JCSEt1SDJYNFE9PSIsInZhbHVlIjoiQWxBR1VYdGtza3hPZTRwOVEzVTRxNXVRUlRnU0oyWDFCRHJMYnVialYzZkU2UkFVVE1KaTlsemN3NVF4cHk4OWozVlVjY" 1 => "laravel_session=eyJpdiI6InpWck1hNGFQaGF6djhjZ0Fjb1RTbWc9PSIsInZhbHVlIjoiSi9TQ3EzZ0kvcE9WRW5ubFhYR21UN043L3Y2OGo1NVdBZXo4K2hHblV0eWRuTGo2SkIweW93UlRwdkpHbXVlUjRhVjRhcHlEUUtLeVJjU2ZVVEw5NWt4VklCWHVmdXNJaEQzRUFScm5yNldLRmFkQ0RTdldxTTZvQUZTY2ZWUjgiLCJtYWMiOiI1Zjk5ZTE1ZTBlZmFiNTYyMzM1NTQ3ZjkzMWQwNGE1Mjg3MGRlYmRlMmI3ZDUzMDdkOTAyNTdkOWE4OGY4NmUxIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 15:27:26 GMT; path=/; secure; httponlylaravel_session=eyJpdiI6InpWck1hNGFQaGF6djhjZ0Fjb1RTbWc9PSIsInZhbHVlIjoiSi9TQ3EzZ0kvcE9WRW5ubFhYR21UN043L3Y2OGo1NVdBZXo4K2hHblV0eWRuTGo2SkIweW93UlRwdkpHbXVlUjRh" 2 => "course_id=2; expires=Tue, 05-May-2026 13:27:26 GMT; path=/" 3 => "course_name=MBA+%2F+PGDM; expires=Tue, 05-May-2026 13:27:26 GMT; path=/" 4 => "viewed_colleges=%5B19443%2C1375%5D; expires=Wed, 04-Jun-2025 13:27:26 GMT; path=/; secure; httponly" ] ]
        session_attributes
        0 of 0
        array:3 [ "_token" => "pOJDfV0stzytp5tHkrpfXK0kegfZWBOm3vIM1Qch" "_previous" => array:1 [ "url" => "https://www.dev.collegesearch.in/colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-47855https://www.dev.collegesearch.in/colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-ma" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-05-05 13:27:26GET/colleges/mudra-institute-of-communication-mica-ahmedabad/courses-fees/mba-post-graduate-certificate-programme-in-advertising-management-and-public-relations-pgcpampr-4785511263322