CollegeController.php#129db_collegesearch_new1.8msselect `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` ='nalanda-institute-of-advanced-studies-kolkata'and `institutes`.`deleted_at` isnulland `status` ='active' limit 1
CollegeController.php#129db_collegesearch_new700μsselect `id`, `name` from `programs` where `programs`.`id` in (3411, 3423, 3437, 3458) and `programs`.`deleted_at` isnulland `status` ='active'
CollegeController.php#129db_collegesearch_new890μsselect `id`, `name` from `courses` where `courses`.`id` in (2, 7, 8, 13) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#129db_collegesearch_new1.56msselect*from `institute_program_fees_summaries` where `institute_program_fees_summaries`.`institute_program_id` in (13559, 19060, 19061, 19062) and `institute_program_fees_summaries`.`deleted_at` isnulland `status` ='active'
CollegeController.php#129db_collegesearch_new850μsselect*from `institute_program_placements` where `institute_program_placements`.`institute_program_id` in (13559, 19060, 19061, 19062) and `institute_program_placements`.`deleted_at` isnulland `status` ='active'
CollegeController.php#129db_collegesearch_new710μsselect*from `institute_program_contents` where `institute_program_contents`.`institute_program_id` in (13559, 19060, 19061, 19062) and `institute_program_contents`.`deleted_at` isnulland `status` ='active'
CollegeController.php#129db_collegesearch_new1.14msselect*from `institute_recruiters` where `institute_recruiters`.`institute_id` in (7204) and `institute_recruiters`.`deleted_at` isnulland `status` ='active'
CollegeController.php#589db_collegesearch_new1.12msselect course_id, GROUP_CONCAT(id) as ids from `institute_programs` where `institute_id` =7204and `institute_programs`.`deleted_at` isnulland `status` ='active'groupby `course_id`
CollegeController.php#589db_collegesearch_new1.02msselect `id`, `name` from `courses` where `courses`.`id` in (2, 7, 8, 13) and `courses`.`deleted_at` isnulland `status` ='active'
CollegeController.php#600db_collegesearch_new1.05msselect institute_program_id, AVG(average_package) as avg_package, AVG(highest_package) as highest_package from `institute_program_placements` where `institute_program_id` in ('19061', '19060', '19062', '13559') and `institute_program_placements`.`deleted_at` isnulland `status` ='active'groupby `institute_program_id`
CollegeController.php#988db_collegesearch_new920μsselectdistinct `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` =7204