HomeController.php#635satt_satt_mobile_app150μsselect `id`, `name` from `categories` where `categories`.`id` in (95) and `categories`.`deleted_at` isnull
HomeController.php#213satt_satt_mobile_app560μ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_app620μ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_app340μ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.73msselect `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_app11.01msselect `id`, `name`, `num_of_mcq` as `question_count` from `subjects` where (`main_category_id` ='3'and `parent_id` isnull) and `subjects`.`deleted_at` isnull