CollegeController.php#135db_collegesearch_new1.45msselect `institutes`.*, (selectcount(*) from `institute_reviews` where `institutes`.`id` = `institute_reviews`.`institute_id` and `institute_reviews`.`deleted_at` isnulland `status` ='active') as `reviews_count` from `institutes` where `slug` ='chandigarh-engineering-college-mohali'and `institutes`.`deleted_at` isnulland `status` ='active' limit 1
CollegeController.php#135db_collegesearch_new800μsselect `id`, `name` from `programs` where `programs`.`id` in (15, 17, 19, 20, 3441) and `programs`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new880μsselect `id`, `name` from `courses` where `courses`.`id` in (1, 10) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new1.34msselect*from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (6542, 6543, 6544, 6545, 48948) and `institute_program_fees_summaries`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new940μsselect*from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (6542, 6543, 6544, 6545, 48948) and `institute_program_placements`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new780μsselect*from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (6542, 6543, 6544, 6545, 48948) and `institute_program_contents`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new1.98msselect*from `institute_recruiters` where `institute_recruiters`.`institute_id` in (1862) and `institute_recruiters`.`deleted_at` isnulland `status` ='active'
CollegeController.php#816db_collegesearch_new4.41msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (261) and `admins`.`deleted_at` isnull
CollegeController.php#640db_collegesearch_new1.23msselect course_id, GROUP_CONCAT(id) as ids from `institute_programs` where `institute_id` =1862and `institute_programs`.`deleted_at` isnulland `status` ='active'groupby `course_id`
CollegeController.php#640db_collegesearch_new1.01msselect `id`, `name` from `courses` where `courses`.`id` in (1, 10) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#651db_collegesearch_new1.13msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in ('6542', '6543', '6544', '6545', '48948') and `institute_program_placements`.`deleted_at` isnulland `status` ='active'groupby `institute_program_id`
CollegeController.php#1049db_collegesearch_new1.56msselectdistinct `exam_id` from `institute_program_exam_mappings` innerjoin `institute_programs` on `institute_programs`.`id` = `institute_program_exam_mappings`.`institute_program_id` where `institute_programs`.`institute_id` =1862