Dinas Perdagangan dan Perindustrian Kota Bandung

Queries

0.0001	SET SESSION sql_mode="STRICT_ALL_TABLES"
0.0003	SELECT * FROM (`bf_templates`) WHERE `aktif` = 'Y'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where
0.0003	INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('7c3a8c6efc419371f84c9938607a304a', '34.229.131.158', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686236532, '')
0.0003	SELECT * FROM (`bf_settings`)Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra:
0.0295	UPDATE `bf_sessions` SET `last_activity` = 1686236532, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = '7c3a8c6efc419371f84c9938607a304a'
0.0006	SELECT * FROM (`bf_templates`) WHERE `aktif` = 'Y'Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where
0.0005	SELECT * FROM (`bf_widget`) WHERE `column_sidebar` = 3 ORDER BY `sort_no` ascSpeed: 0.0005 - 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.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.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,4
0.0019	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.0075	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.0075 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE* noticed after reading const tables*
0.0003	SELECT * FROM (`bf_blogroll`)Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 6 - Extra:
0.0003	SELECT * FROM (`bf_multimedia`) ORDER BY `id` desc LIMIT 4Speed: 0.0003 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 4 - Extra:
0.0004	select * from bf_arsip where post_category='8' and tgl_akhir >= '2023-06-09' order by tgl_awal asc limit 3
0.0003	select * from bf_arsip where post_category='28' order by tgl_arsip desc limit 3
0.0003	select * from bf_arsip where post_category='10' order by tgl_arsip desc limit 3
0.0015	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.0101	select * from bf_agenda order by tgl_agenda desc limit 5
0.0004	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.0005	select * from bf_arsip where post_category in (40) order by tgl_arsip desc limit 4
0.0003	select * from bf_arsip where post_category in (1) order by tgl_arsip desc limit 3
0.0003	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.0003	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.0002	select * from komoditas
0.0068	UPDATE `bf_sessions` SET `last_activity` = 1686236532, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";s:6:\"pageid\";i:21;}' WHERE `session_id` = '7c3a8c6efc419371f84c9938607a304a'
0.0008	SELECT `bf_pages_meta`., `bf_pages_meta`.`judul` as judul_page_bahasa, `bf_pages_meta`.`isi` as isi_page_bahasa FROM* (`bf_pages_meta`) WHERE `bf_pages_meta`.`id` = 21 AND `bf_pages_meta`.`deleted` IN (0, 2) ORDER BY `created_on` DESC LIMIT 1Speed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0465	UPDATE `bf_pages_meta` SET `baca` = 1386 WHERE `id` = 21
0.0005	select count(*) as jml from bf_pages_meta where parent_id='21'
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.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` = '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.0030	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '2'Speed: 0.0030 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0009	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.0009 - 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.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` = '4'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` = '5'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.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.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '10'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.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '7'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.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '7'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '8'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0004	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.0004 - 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.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0004	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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0003	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.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0003	select * from bf_scrolltext where flag_scroll=1 order by id desc
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.0001	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.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` = '10' 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.0003	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_pages` = '21' AND `tipe_lokasi` = 3 ORDER BY `rang` ascSpeed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using temporary; Using filesort
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '46' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0001	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '1'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '51' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '6'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '50' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0001	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '5'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '49' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '4'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '48' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0002	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '3'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:
0.0002	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '47' AND `location_index` = '10' ORDER BY `rang`Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0017	SELECT * FROM (`bf_pages_meta`) WHERE `id` = '2'Speed: 0.0017 - 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` = 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.0001	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.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE* noticed after reading const tables*
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.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.0003	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_pages` = '21' AND `tipe_lokasi` = 3 ORDER BY `rang` ascSpeed: 0.0003 - 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` = '58' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0003	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '62' AND `location_index` = '12' ORDER BY `rang`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort
0.0003	SELECT * FROM (`bf_meta_menu`) WHERE `parent_id` = '61' 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` = '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.1417	Total Query Execution Time

Loading Time: Base Classes	150 ms
Controller Execution Time ( Pages / Detail )	283 ms
Total Execution Time	433 ms

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 ( [description] => Modul Kelola Halaman Beta 1.0 [name] => Halaman [version] => Beta 1.0 [author] => Harry Ridwan Ramadan )
upload_config	Array ( [upload_path_file] => ./application/modules/pages/files/ [upload_path_image] => ./application/modules/pages/images/ )

Penandatangan kesepakatan bersama antara Pemerintah Kota Bandung dengan instansi pengisi Mall Pelayanan Publik

Monitoring Gerai Layanan Publik

Kunjungan Kerja dari DPRD Kota Jayapura

Bandung Hijab Festival 2021

Penerimaan Tenaga Operator Control Room

Penyelenggaraan Pasar Lelang Forward Komoditi Agro Jawa Barat

Persyaratan Pendaftaran Merk HKI UKM/IKM

Rapat penyusunan target triwulan I s.d. IV Perjanjian kinerja dan penyusunan cascading esselon 3 dan 4 dilingkungan Dinas KUKM Perindag Kota Bandung

Festival Food Etnik

Persiapan kegiatan Bimtek peningkatan kewirausahaan…

Rekap pengajuan kartu tanda pengenal dari kecamatan

Rapat evaluasi Satgasus PKL, ruang rapat Wakil Walikota…

Permohonan ketersediaan LPG 3 kg di pangkalan-pangkalan…

Polling

Bidang Distribusi Perdagangan dan Pengembangan e-Commerce

Console

Memory Usage

Benchmarks

Queries

Session User Data

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Files

session_id	7c3a8c6efc419371f84c9938607a304a
ip_address	34.229.131.158
user_agent	CCBot/2.0 (https://commoncrawl.org/faq/)
last_activity	1686236532
user_data
site_lang	indonesia
pageid	21