CollegeController.php#130db_collegesearch_new1.44msselect `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` ='amity-business-school-noida'and `institutes`.`deleted_at` isnulland `status` ='active' limit 1
CollegeController.php#130db_collegesearch_new920μsselect `id`, `name` from `courses` where `courses`.`id` in (2, 7) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#130db_collegesearch_new2.77msselect*from `institute_recruiters` where `institute_recruiters`.`institute_id` in (1401) and `institute_recruiters`.`deleted_at` isnulland `status` ='active'
CollegeController.php#635db_collegesearch_new1.13msselect course_id, GROUP_CONCAT(id) as ids from `institute_programs` where `institute_id` =1401and `institute_programs`.`deleted_at` isnulland `status` ='active'groupby `course_id`
CollegeController.php#635db_collegesearch_new790μsselect `id`, `name` from `courses` where `courses`.`id` in (2, 7) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#646db_collegesearch_new820μsselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in ('4124', '4125', '4126', '4127', '4128', '4129', '4130', '4131', '47890') and `institute_program_placements`.`deleted_at` isnulland `status` ='active'groupby `institute_program_id`
CollegeController.php#1044db_collegesearch_new1.07msselectdistinct `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` =1401