KelasUserQuery.php#676futureskills_fs_asn_pre_prod2.69msselect `kelases`.*, (select `kelas_configs`.`metode_pembelajaran` from `kelas_configs` where `kelases`.`id` = `kelas_configs`.`kelas_id` limit 1) as `config_metode_belajar`, (select
(CASEWHEN config_metode_belajar ISNULLTHEN "online" ELSE config_metode_belajar END) AS metode_pembelajaran) as `metode_pembelajaran` from `kelases` where `slug` ='konten-b'and `status` notin ('trash', 'draft', 'minta_diterbitkan') and ((exists (select*from `kelas_metas` where `kelases`.`id` = `kelas_metas`.`kelas_id` and `value` in ('aktif', 'tidak_terdaftar') and `name` ='visibilitas') ornotexists (select*from `kelas_metas` where `kelases`.`id` = `kelas_metas`.`kelas_id` and `name` ='visibilitas'))) and `kelases`.`deleted_at` isnull limit 1
LandingPageController.php#76futureskills_fs_asn_pre_prod280μsselect*from `kelas_jadwals` where `kelas_jadwals`.`kelas_id` in (117) and `kelas_jadwals`.`deleted_at` isnullorderbycasewhen `order` =NULLthen `id`
else `order`
endasc
Kelases.php#1009futureskills_fs_asn_pre_prod440μsselect status, count(*) as total from `kelas_pendaftar` where `kelas_pendaftar`.`kelas_id` =117and `kelas_pendaftar`.`kelas_id` isnotnulland `kelas_pendaftar`.`deleted_at` isnullgroupby `status`
Kelases.php#1018futureskills_fs_asn_pre_prod430μsselectcount(*) as aggregate from `ecommerce_product_orders` innerjoin `ecommerce_products` on `ecommerce_products`.`id` = `ecommerce_product_orders`.`product_id` where `ecommerce_products`.`productable_id` =117and `productable_type` ='Pijar\\MasterData\\Models\\Kelases'and `ecommerce_product_orders`.`status` ='pending'
Kelases.php#1107futureskills_fs_asn_pre_prod540μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='dokumen'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_dokumen_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1107futureskills_fs_asn_pre_prod410μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='pdf'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_pdf_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1107futureskills_fs_asn_pre_prod470μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='link'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_link_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1107futureskills_fs_asn_pre_prod430μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='teks'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_teks_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1107futureskills_fs_asn_pre_prod550μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='kuis'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_kuis_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1107futureskills_fs_asn_pre_prod370μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `tipe` ='video'and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_video_count` from `kelases` where `kelases`.`id` in (117)
Kelases.php#1114futureskills_fs_asn_pre_prod380μsselect `id`, (selectcount(*) from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelases`.`id` = `kelas_asinkron_aktivitas_topiks`.`kelas_id` and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull) as `aktivitas_semua_count` from `kelases` where `kelases`.`id` in (117)
job-role.blade.php#8futureskills_fs_asn_pre_prod620μsselect `job_roles`.*, `kelas_job_roles`.`kelas_id` as `pivot_kelas_id`, `kelas_job_roles`.`job_role_id` as `pivot_job_role_id`, `kelas_job_roles`.`created_at` as `pivot_created_at`, `kelas_job_roles`.`updated_at` as `pivot_updated_at` from `job_roles` innerjoin `kelas_job_roles` on `job_roles`.`id` = `kelas_job_roles`.`job_role_id` where `kelas_job_roles`.`kelas_id` =117and `job_roles`.`deleted_at` isnull
body.blade.php#21futureskills_fs_asn_pre_prod450μsselect `kelases`.*, `kelas_groupings`.`kelas_id` as `laravel_through_key` from `kelases` innerjoin `kelas_groupings` on `kelas_groupings`.`kelas_grouping_id` = `kelases`.`id` where `kelas_groupings`.`kelas_id` =117and `kelases`.`deleted_at` isnulland `kelas_groupings`.`deleted_at` isnull
category.blade.php#8futureskills_fs_asn_pre_prod460μsselect `kategoris`.*, `kelas_inovasis`.`kelas_id` as `pivot_kelas_id`, `kelas_inovasis`.`kategori_id` as `pivot_kategori_id` from `kategoris` innerjoin `kelas_inovasis` on `kategoris`.`id` = `kelas_inovasis`.`kategori_id` where `kelas_inovasis`.`kelas_id` =117
Kelases.php#254futureskills_fs_asn_pre_prod670μsselect `kelas_asinkron_aktivitas_items`.*, `kelas_asinkron_aktivitas_topiks`.`kelas_id` as `laravel_through_key` from `kelas_asinkron_aktivitas_items` innerjoin `kelas_asinkron_aktivitas_topiks` on `kelas_asinkron_aktivitas_topiks`.`id` = `kelas_asinkron_aktivitas_items`.`topik_id` where `kelas_asinkron_aktivitas_topiks`.`kelas_id` =117and `kelas_asinkron_aktivitas_items`.`deleted_at` isnulland `kelas_asinkron_aktivitas_topiks`.`deleted_at` isnull