| Loading Time: Base Classes | 53 ms |
| Controller Execution Time ( Agenda / Detail ) | 3876 ms |
| Total Execution Time | 3930 ms |
| 0.0001 | SET SESSION sql_mode="STRICT_ALL_TABLES" |
| 0.0002 | SELECT * FROM (`bf_templates`) WHERE `aktif` = 'Y'Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where |
| 0.0002 | INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('6f04543c126eb5fda219f1fd7e70849b', '34.229.131.158', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686239676, '') |
| 0.0003 | DELETE FROM `bf_sessions` WHERE `last_activity` < 1686232476 |
| 0.0007 | SELECT * FROM (`bf_settings`)Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
| 0.1073 | UPDATE `bf_sessions` SET `last_activity` = 1686239676, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = '6f04543c126eb5fda219f1fd7e70849b' |
| 0.0006 | SELECT * FROM (`bf_templates`) WHERE `aktif` = 'Y'Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where |
| 0.0007 | SELECT * FROM (`bf_widget`) WHERE `column_sidebar` = 3 ORDER BY `sort_no` ascSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 11 - Extra: Using where; Using filesort |
| 0.0013 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.post_category='108' and a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 5 |
| 0.0018 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.post_category='39' and a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,10 |
| 0.0014 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,4 |
| 0.0020 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.deleted=0 and a.status_tampil=0 order by a.baca desc limit 0,4 |
| 0.0100 | SELECT * FROM bf_polling where DATE_FORMAT(NOW(),"%Y-%m-%d") >= tgl_waktu_polling AND DATE_FORMAT(NOW(),"%Y-%m-%d") <= tgl_batas_pollingSpeed: 0.0100 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0002 | SELECT * FROM (`bf_blogroll`)Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 6 - Extra: |
| 0.0002 | SELECT * FROM (`bf_multimedia`) ORDER BY `id` desc LIMIT 4Speed: 0.0002 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 4 - Extra: |
| 0.0003 | select * from bf_arsip where post_category='8' and tgl_akhir >= '2023-06-09' order by tgl_awal asc limit 3 |
| 0.0002 | select * from bf_arsip where post_category='28' order by tgl_arsip desc limit 3 |
| 0.0002 | select * from bf_arsip where post_category='10' order by tgl_arsip desc limit 3 |
| 0.0012 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.post_category <> 24 and a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 5 |
| 0.0046 | select * from bf_agenda order by tgl_agenda desc limit 5 |
| 0.0003 | select *,a.id as id_post from bf_post_meta a inner join bf_m_kategori b on a.post_category=b.id where a.post_category=109 and a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 3 |
| 0.0004 | select * from bf_arsip where post_category in (40) order by tgl_arsip desc limit 4 |
| 0.0002 | select * from bf_arsip where post_category in (1) order by tgl_arsip desc limit 3 |
| 0.0002 | select * from bf_arsip where post_category in (29) order by tgl_arsip desc limit 3 |
| 0.0002 | select * from bf_arsip where post_category in (30) order by tgl_arsip desc limit 3 |
| 0.0002 | SELECT * FROM (`bf_widget_social_media`) WHERE `bf_widget_social_media`.`id` = 1Speed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0002 | select a.* from bf_galeri_foto a where a.flag=1 order by a.id desc limit 3 |
| 0.0002 | select * from bf_banners order by urut asc |
| 0.0001 | select * from komoditas |
| 0.0008 | SELECT `bf_m_kategori`.`kategori`, `bf_agenda`.`id` as id_agenda, `bf_agenda`.*, `bf_m_kategori`.`kategori` as kategori_bahasa, `bf_agenda`.`judul_agenda` as judul_agenda_bahasa, `bf_agenda`.`isi_agenda` as isi_agenda_bahasa FROM (`bf_agenda`) JOIN `bf_m_kategori` ON `bf_m_kategori`.`id`=`bf_agenda`.`post_category` WHERE `bf_agenda`.`id` = 181Speed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0010 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0010 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0007 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0004 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '1'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '1'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0029 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '2'Speed: 0.0029 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0008 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '3'Speed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0008 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0004 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '4'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '5'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '6'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '10'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '7'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '7'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '8'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '9'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = 7 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | select * from bf_scrolltext where flag_scroll=1 order by id desc |
| 0.0004 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 10 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 10 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = '10' AND `parent_id` = 0 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0006 | SELECT `bf_meta_menu`.`parent_id`, `bf_menu_lokasi`.`id` as id_lokasi, `bf_meta_menu`.`id` as id_menu, `bf_menu_lokasi`.`tipe_lokasi`, `bf_meta_menu`.`parent_id` FROM (`bf_meta_menu`) JOIN `bf_menu_lokasi` ON `bf_meta_menu`.`location_index`=`bf_menu_lokasi`.`id` WHERE `url_module` = 'agenda' AND `tipe_lokasi` = 3 ORDER BY `rang` ascSpeed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using temporary; Using filesort |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '46' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '1'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '51' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0004 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '6'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '50' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '5'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '49' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '4'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '48' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0004 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '3'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '47' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0027 | SELECT * FROM (`bf_pages_meta`) WHERE `id` = '2'Speed: 0.0027 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 11 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0003 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0002 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 11 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0002 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 12 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 | SELECT `bf_menu_lokasi`.`menu_lok` as menu_lok_bahasa, `bf_menu_lokasi`.`id` FROM (`bf_menu_lokasi`) WHERE `bf_menu_lokasi`.`id` = 12 AND `tipe_lokasi` = 3 AND `flag_hide` = 0 ORDER BY `list_urutan` asc LIMIT 10Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 | SELECT `bf_meta_menu`.*, `bf_meta_menu`.`name` as menu_bahasa, `bf_meta_menu`.`id` FROM (`bf_meta_menu`) WHERE `location_index` = '12' AND `parent_id` = 0 AND `flag_hide` = 0 ORDER BY `rang` ascSpeed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0004 | SELECT `bf_meta_menu`.`parent_id`, `bf_menu_lokasi`.`id` as id_lokasi, `bf_meta_menu`.`id` as id_menu, `bf_menu_lokasi`.`tipe_lokasi`, `bf_meta_menu`.`parent_id` FROM (`bf_meta_menu`) JOIN `bf_menu_lokasi` ON `bf_meta_menu`.`location_index`=`bf_menu_lokasi`.`id` WHERE `url_module` = 'agenda' AND `tipe_lokasi` = 3 ORDER BY `rang` ascSpeed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using temporary; Using filesort |
| 0.0003 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '58' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '62' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '61' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '60' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 | SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '59' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.1690 | Total Query Execution Time |
| session_id | 6f04543c126eb5fda219f1fd7e70849b |
| ip_address | 34.229.131.158 |
| user_agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
| last_activity | 1686239676 |
| user_data | |
| site_lang | indonesia |
| No GET data exists |
| No POST data exists |
| agenda/detail/181 |
| agenda/detail |
| HTTP_ACCEPT | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
| HTTP_USER_AGENT | CCBot/2.0 (https://commoncrawl.org/faq/) |
| HTTP_CONNECTION | Keep-Alive |
| SERVER_PORT | 443 |
| SERVER_NAME | disdagin.bandung.go.id |
| REMOTE_ADDR | 34.229.131.158 |
| SERVER_SOFTWARE | Apache |
| HTTP_ACCEPT_LANGUAGE | en-US,en;q=0.5 |
| SCRIPT_NAME | /index.php |
| REQUEST_METHOD | GET |
| HTTP_HOST | |
| REMOTE_HOST | |
| CONTENT_TYPE | |
| SERVER_PROTOCOL | HTTP/1.1 |
| QUERY_STRING | |
| HTTP_ACCEPT_ENCODING | br,gzip |
| HTTP_X_FORWARDED_FOR |
| modules_locations | Array ( [/home/kukmperindagband/public_html/application/modules/] => ../../application/modules/ [/home/kukmperindagband/public_html/bonfire/modules/] => ../../bonfire/modules/ ) |
| base_url | https://disdagin.bandung.go.id/ |
| index_page | |
| uri_protocol | AUTO |
| url_suffix | |
| language | english |
| charset | UTF-8 |
| enable_hooks | |
| subclass_prefix | MY_ |
| permitted_uri_chars | a-z 0-9~%\.\:_\- |
| allow_get_array | 1 |
| enable_query_strings | |
| controller_trigger | c |
| function_trigger | m |
| directory_trigger | d |
| log_threshold | 0 |
| log_path | ./application/logs/ |
| log_date_format | Y-m-d H:i:s |
| cache_path | ./application/cache/ |
| encryption_key | fa8449a4358a4b74d5da65254329958b |
| sess_cookie_name | bf_session |
| sess_expiration | 7200 |
| sess_expire_on_close | |
| sess_encrypt_cookie | 1 |
| sess_use_database | 1 |
| sess_table_name | sessions |
| sess_match_ip | 1 |
| sess_match_useragent | 1 |
| sess_time_to_update | 300 |
| cookie_prefix | |
| cookie_domain | |
| cookie_path | / |
| global_xss_filtering | |
| csrf_protection | |
| csrf_token_name | ci_csrf_token |
| csrf_cookie_name | ci_csrf_token |
| csrf_expire | 7200 |
| compress_output | |
| time_reference | gmt |
| rewrite_short_tags | |
| proxy_ips | |
| site.default_user_timezone | UM8 |
| site.backup_folder | archives/ |
| contexts | Array ( [0] => plugin [1] => transaksi [2] => content [3] => reports [4] => settings [5] => developer ) |
| enable_activity_logging | 1 |
| template.site_path | /home/kukmperindagband/public_html/ |
| template.theme_paths | Array ( [0] => themes ) |
| template.default_layout | index |
| template.ajax_layout | ajax |
| template.use_mobile_themes | |
| template.default_theme | perindag/ |
| template.admin_theme | admin |
| template.parse_views | |
| template.message_template | <div class="alert alert-block alert-{type} fade in notification"> <a data-dismiss="alert" class="close" href="#">&times;</a> <div>{message}</div> </div> |
| template.breadcrumb_symbol | : |
| assets.base_folder | assets |
| assets.asset_folders | Array ( [css] => css [js] => js [image] => images ) |
| assets.js_opener | $(document).ready(function(){ |
| assets.js_closer | }); |
| assets.js_combine | |
| assets.css_combine | |
| assets.encrypt_name | |
| assets.js_minify | |
| assets.css_minify | |
| assets.encode | |
| ui.current_shortcuts | Array ( [form_save] => Array ( [description] => Save any form in the admin area. [action] => $("input[name=save]").click();return false; ) [create_new] => Array ( [description] => Create a new record in the module. [action] => window.location.href=$("a#create_new").attr("href"); ) [select_all] => Array ( [description] => Select all records in an index page. [action] => $("table input[type=checkbox]").click();return false; ) [delete] => Array ( [description] => Delete the record(s). [action] => $("#delete-me.btn-danger").click(); ) [module_index] => Array ( [description] => Return to the index of the current module. [action] => window.location.href=$("a#list").attr("href"); ) [goto_content] => Array ( [description] => Jump to the Content context. [action] => window.location.href=$("#tb_content").attr("href") ) [goto_reports] => Array ( [description] => Jump to the Reports context. [action] => window.location.href=$("#tb_reports").attr("href") ) [goto_settings] => Array ( [description] => Jump to the Settings context. [action] => window.location.href=$("#tb_settings").attr("href") ) [goto_developer] => Array ( [description] => Jump to the Developer context. [action] => window.location.href=$("#tb_developer").attr("href") ) ) |
| emailer.write_to_file | |
| migrate.auto_core | |
| migrate.auto_app | |
| module_config | Array ( [module_path] => ./application/modules/datatable/ [description] => Modul Kelola Posting Beta 1.0 [name] => Posting [version] => Beta 1.0 [author] => Harry Ridwan Ramadan ) |
| upload_config | Array ( [upload_path_file] => ./application/modules/post/files/ [upload_path_image] => ./application/modules/post/images/ ) |
| application.php application/config/application.php |
| autoload.php application/config/autoload.php |
| config.php application/config/config.php |
| constants.php application/config/constants.php |
| database.php application/config/database.php |
| events.php application/config/events.php |
| mimes.php application/config/mimes.php |
| profiler.php application/config/profiler.php |
| routes.php application/config/routes.php |
| user_agents.php application/config/user_agents.php |
| Base_Controller.php application/core/Base_Controller.php |
| Front_Controller.php application/core/Front_Controller.php |
| MY_Lang.php application/core/MY_Lang.php |
| MY_Loader.php application/core/MY_Loader.php |
| MY_Model.php application/core/MY_Model.php |
| MY_Router.php application/core/MY_Router.php |
| MY_Security.php application/core/MY_Security.php |
| MY_file_helper.php application/helpers/MY_file_helper.php |
| MY_form_helper.php application/helpers/MY_form_helper.php |
| application_lang.php application/language/english/application_lang.php |
| datatable_lang.php application/language/english/datatable_lang.php |
| application_lang.php application/language/indonesia/application_lang.php |
| datatable_lang.php application/language/indonesia/datatable_lang.php |
| MY_Form_validation.php application/libraries/MY_Form_validation.php |
| Profiler.php application/libraries/Profiler.php |
| agenda.php application/modules/agenda/controllers/agenda.php |
| get_agenda_category_helper.php application/modules/agenda/helpers/get_agenda_category_helper.php |
| agenda_lang.php application/modules/agenda/language/english/agenda_lang.php |
| agenda_lang.php application/modules/agenda/language/indonesia/agenda_lang.php |
| agenda_model.php application/modules/agenda/models/agenda_model.php |
| evencal_model.php application/modules/agenda/models/evencal_model.php |
| detail.php application/modules/agenda/views/detail.php |
| home_lang.php application/modules/home/language/english/home_lang.php |
| home_lang.php application/modules/home/language/indonesia/home_lang.php |
| kategori_model.php application/modules/kategori/models/kategori_model.php |
| blog_header_helper.php application/modules/menuthemes/helpers/blog_header_helper.php |
| slug_menu_helper.php application/modules/menuthemes/helpers/slug_menu_helper.php |
| menu_lokasi_model.php application/modules/menuthemes/models/menu_lokasi_model.php |
| menu_model.php application/modules/menuthemes/models/menu_model.php |
| multimedia_model.php application/modules/multimedia/models/multimedia_model.php |
| config.php application/modules/post/config/config.php |
| sosmed_model.php application/modules/sosmed/models/sosmed_model.php |
| templates_model.php application/modules/templates/models/templates_model.php |
| widget_consistence.php application/modules/widget/libraries/widget_consistence.php |
| widget_custom.php application/modules/widget/libraries/widget_custom.php |
| widget_get.php application/modules/widget/libraries/widget_get.php |
| wgt_page_scrolltext.php application/modules/widget/views/widget_themes/wgt_page_scrolltext.php |
| Base.php application/third_party/MX/Base.php |
| Config.php application/third_party/MX/Config.php |
| Controller.php application/third_party/MX/Controller.php |
| Lang.php application/third_party/MX/Lang.php |
| Loader.php application/third_party/MX/Loader.php |
| Modules.php application/third_party/MX/Modules.php |
| Router.php application/third_party/MX/Router.php |
| Benchmark.php bonfire/codeigniter/core/Benchmark.php |
| CodeIgniter.php bonfire/codeigniter/core/CodeIgniter.php |
| Common.php bonfire/codeigniter/core/Common.php |
| Config.php bonfire/codeigniter/core/Config.php |
| Controller.php bonfire/codeigniter/core/Controller.php |
| Exceptions.php bonfire/codeigniter/core/Exceptions.php |
| Hooks.php bonfire/codeigniter/core/Hooks.php |
| Input.php bonfire/codeigniter/core/Input.php |
| Lang.php bonfire/codeigniter/core/Lang.php |
| Loader.php bonfire/codeigniter/core/Loader.php |
| Model.php bonfire/codeigniter/core/Model.php |
| Output.php bonfire/codeigniter/core/Output.php |
| Router.php bonfire/codeigniter/core/Router.php |
| Security.php bonfire/codeigniter/core/Security.php |
| URI.php bonfire/codeigniter/core/URI.php |
| Utf8.php bonfire/codeigniter/core/Utf8.php |
| DB.php bonfire/codeigniter/database/DB.php |
| DB_active_rec.php bonfire/codeigniter/database/DB_active_rec.php |
| DB_driver.php bonfire/codeigniter/database/DB_driver.php |
| DB_result.php bonfire/codeigniter/database/DB_result.php |
| mysql_driver.php bonfire/codeigniter/database/drivers/mysql/mysql_driver.php |
| mysql_result.php bonfire/codeigniter/database/drivers/mysql/mysql_result.php |
| cookie_helper.php bonfire/codeigniter/helpers/cookie_helper.php |
| directory_helper.php bonfire/codeigniter/helpers/directory_helper.php |
| file_helper.php bonfire/codeigniter/helpers/file_helper.php |
| form_helper.php bonfire/codeigniter/helpers/form_helper.php |
| html_helper.php bonfire/codeigniter/helpers/html_helper.php |
| language_helper.php bonfire/codeigniter/helpers/language_helper.php |
| string_helper.php bonfire/codeigniter/helpers/string_helper.php |
| text_helper.php bonfire/codeigniter/helpers/text_helper.php |
| url_helper.php bonfire/codeigniter/helpers/url_helper.php |
| calendar_lang.php bonfire/codeigniter/language/english/calendar_lang.php |
| profiler_lang.php bonfire/codeigniter/language/english/profiler_lang.php |
| Cache.php bonfire/codeigniter/libraries/Cache/Cache.php |
| Calendar.php bonfire/codeigniter/libraries/Calendar.php |
| Driver.php bonfire/codeigniter/libraries/Driver.php |
| Encrypt.php bonfire/codeigniter/libraries/Encrypt.php |
| Form_validation.php bonfire/codeigniter/libraries/Form_validation.php |
| Session.php bonfire/codeigniter/libraries/Session.php |
| User_agent.php bonfire/codeigniter/libraries/User_agent.php |
| application_helper.php bonfire/helpers/application_helper.php |
| config_file_helper.php bonfire/helpers/config_file_helper.php |
| Console.php bonfire/libraries/Console.php |
| assets.php bonfire/libraries/assets.php |
| events.php bonfire/libraries/events.php |
| template.php bonfire/libraries/template.php |
| settings_lib.php bonfire/modules/settings/libraries/settings_lib.php |
| settings_model.php bonfire/modules/settings/models/settings_model.php |
| users_lang.php bonfire/modules/users/language/english/users_lang.php |
| auth.php bonfire/modules/users/libraries/auth.php |
| user_model.php bonfire/modules/users/models/user_model.php |
| index.php index.php |
| footer.php themes/perindag/footer.php |
| head.php themes/perindag/head.php |
| index.php themes/perindag/index.php |
| navbar.php themes/perindag/navbar.php |
| sidebar.php themes/perindag/sidebar.php |
| top.php themes/perindag/top.php |
KEMENTERIAN PERDAGANGAN
DINAS PERINDAG PROVINSI JABAR
BANDUNG PUSAT
KADIN KOTA BANDUNG
KEMENTRIAN PERINDUSTRIAN
LAPOR
