CollegeController.php#135db_collegesearch_new2.53msselect `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` ='school-of-computer-and-information-sciences-university-of-hyderabadscis-uoh-hyderabad'and `institutes`.`deleted_at` isnulland `status` ='active' limit 1
CollegeController.php#135db_collegesearch_new1.11msselect `id`, `name` from `programs` where `programs`.`id` in (1597, 1628, 1799, 3437) and `programs`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new620μsselect `id`, `name` from `courses` where `courses`.`id` in (8, 10) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new880μsselect*from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (6443, 6444, 6445, 56735) and `institute_program_fees_summaries`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new890μsselect*from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (6443, 6444, 6445, 56735) and `institute_program_placements`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new1.11msselect*from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (6443, 6444, 6445, 56735) and `institute_program_contents`.`deleted_at` isnulland `status` ='active'
CollegeController.php#135db_collegesearch_new1msselect*from `institute_recruiters` where `institute_recruiters`.`institute_id` in (5587) and `institute_recruiters`.`deleted_at` isnulland `status` ='active'
CollegeController.php#816db_collegesearch_new3.19msselect `id`, `name`, `email`, `image` from `admins` where `admins`.`id` in (285) and `admins`.`deleted_at` isnull
CollegeController.php#640db_collegesearch_new1.05msselect course_id, GROUP_CONCAT(id) as ids from `institute_programs` where `institute_id` =5587and `institute_programs`.`deleted_at` isnulland `status` ='active'groupby `course_id`
CollegeController.php#640db_collegesearch_new910μsselect `id`, `name` from `courses` where `courses`.`id` in (8, 10) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#651db_collegesearch_new1.06msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in ('56735', '6443', '6444', '6445') and `institute_program_placements`.`deleted_at` isnulland `status` ='active'groupby `institute_program_id`
CollegeController.php#1049db_collegesearch_new1.05msselectdistinct `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` =5587