HomeController.php#635satt_satt_mobile_app240μsselect `id`, `year` from `years` where `years`.`id` in (36, 37, 38, 39, 40, 41, 42, 43) and `years`.`deleted_at` isnull
HomeController.php#635satt_satt_mobile_app190μsselect `id`, `name` from `categories` where `categories`.`id` in (119, 120, 123) and `categories`.`deleted_at` isnull
HomeController.php#213satt_satt_mobile_app810μsselect `id`, `name`, `slug` from `subjects` where `parent_id` isnullandexists (select*from `courses` innerjoin `subjectables` on `courses`.`id` = `subjectables`.`subjectable_id` where `subjects`.`id` = `subjectables`.`subject_id` and `subjectables`.`subjectable_type` ='App\\Models\\Course'and `courses`.`deleted_at` isnull) and `subjects`.`deleted_at` isnullgroupby `name`
HomeController.php#239satt_satt_mobile_app850μsselect `id`, `name` from `subjects` where `parent_id` isnullandexists (select*from `books` innerjoin `subjectables` on `books`.`id` = `subjectables`.`subjectable_id` where `subjects`.`id` = `subjectables`.`subject_id` and `subjectables`.`subjectable_type` ='App\\Models\\Book'and `books`.`deleted_at` isnull) and `subjects`.`deleted_at` isnullgroupby `name`
HomeController.php#240satt_satt_mobile_app350μsselect `id`, `name`, `logo` from `businesses` whereexists (select*from `books` where `businesses`.`id` = `books`.`business_id` and `books`.`deleted_at` isnull) and `businesses`.`deleted_at` isnull
HomeController.php#245satt_satt_mobile_app3.96msselect `id`, `name`, `business_type`, `logo` from `businesses` whereexists (select*from `exams` where `businesses`.`id` = `exams`.`business_id` and `exams`.`deleted_at` isnull) and `businesses`.`deleted_at` isnull
HomeController.php#400satt_satt_mobile_app10.71msselect `id`, `name`, `num_of_mcq` as `question_count` from `subjects` where (`main_category_id` ='3'and `parent_id` isnull) and `subjects`.`deleted_at` isnull