| 0.0001 |
SET SESSION sql_mode="STRICT_ALL_TABLES" |
| 0.0005 |
SELECT *
FROM (`bf_templates`)
WHERE `aktif` = 'Y'Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where |
| 0.0004 |
INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('8e8a11201dae34f0d8cf3c712dda08b6', '34.229.131.158', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686236228, '') |
| 0.0004 |
SELECT *
FROM (`bf_settings`)Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
| 0.0067 |
UPDATE `bf_sessions` SET `last_activity` = 1686236228, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = '8e8a11201dae34f0d8cf3c712dda08b6' |
| 0.0004 |
SELECT *
FROM (`bf_templates`)
WHERE `aktif` = 'Y'Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where |
| 0.0004 |
SELECT *
FROM (`bf_widget`)
WHERE `column_sidebar` = 3
ORDER BY `sort_no` ascSpeed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 11 - Extra: Using where; Using filesort |
| 0.0009 |
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.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='39' and a.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,10 |
| 0.0009 |
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.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.baca desc limit 0,4 |
| 0.0002 |
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.0002 - 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.0002 |
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.0001 |
select * from bf_arsip where post_category='10' order by tgl_arsip desc limit 3 |
| 0.0007 |
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.0002 |
select * from bf_agenda order by tgl_agenda desc limit 5 |
| 0.0002 |
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.0002 |
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.0001 |
select * from bf_arsip where post_category in (29) order by tgl_arsip desc limit 3 |
| 0.0001 |
select * from bf_arsip where post_category in (30) order by tgl_arsip desc limit 3 |
| 0.0001 |
SELECT *
FROM (`bf_widget_social_media`)
WHERE `bf_widget_social_media`.`id` = 1Speed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0001 |
select
a.*
from
bf_galeri_foto a
where
a.flag=1
order by a.id desc limit 3
|
| 0.0001 |
select * from bf_banners order by urut asc |
| 0.0001 |
select * from komoditas |
| 0.0009 |
SELECT `bf_post_meta`.*, `bf_m_kategori`.`kategori` as kategori_bahasa, `bf_post_meta`.`judul` as judul_post_bahasa, `bf_post_meta`.`slug_judul` as slug_judul_post_bahasa, `bf_post_meta`.`isi` as isi_post_bahasa
FROM (`bf_post_meta`)
JOIN `bf_m_kategori` ON `bf_m_kategori`.`id`=`bf_post_meta`.`post_category`
WHERE `bf_post_meta`.`post_category` = '35'
AND `bf_post_meta`.`deleted` = 0
AND `bf_post_meta`.`status_tampil` = 0
ORDER BY `bf_post_meta`.`created_on` desc
LIMIT 1Speed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 308 - Extra: Using where; Using filesort |
| 0.0225 |
SELECT *
FROM (`bf_post_meta`)
WHERE `post_category` = '35'
AND `id` <> '410'
AND `status_tampil` = 0
AND `deleted` = 0
ORDER BY `created_on` DESCSpeed: 0.0225 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: range - Rows: 156 - Extra: Using where; Using filesort |
| 0.0011 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` <> '410'
AND `status_tampil` = 0
AND `deleted` = 0
AND `post_category` = '35'
ORDER BY `created_on` DESC
LIMIT 6Speed: 0.0011 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: range - Rows: 156 - Extra: Using where; Using filesort |
| 0.0002 |
SELECT `bf_m_kategori`.*, `bf_m_kategori`.`kategori` as judul_bahasa
FROM (`bf_m_kategori`)
WHERE `bf_m_kategori`.`id` = '35'
AND `bf_m_kategori`.`deleted` = 0
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0133 |
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.0133 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 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.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` = '1'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.0022 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0022 - 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.0003 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '3'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.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '4'Speed: 0.0005 - 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` = '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.0004 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '6'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.0002 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '10'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.0003 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '7'Speed: 0.0003 - 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` = '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.0427 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '8'Speed: 0.0427 - 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` = '9'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.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.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.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.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.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.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.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.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.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.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.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.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.0003 |
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.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` = '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_kategori` = '35'
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.0003 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '48'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0003 - 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.0003 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '47'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0026 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0026 - 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.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.0005 |
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.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0005 |
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_kategori` = '35'
AND `tipe_lokasi` = 3
ORDER BY `rang` ascSpeed: 0.0005 - 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.0003 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '60'
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` = '59'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.1296 |
Total Query Execution Time |
KEMENTERIAN PERDAGANGAN
DINAS PERINDAG PROVINSI JABAR
BANDUNG PUSAT
KADIN KOTA BANDUNG
KEMENTRIAN PERINDUSTRIAN
LAPOR
Pada hari Rabu, tanggal 14 April 2021. Kepala Dinas Perdagangan dan Perindustrian menenerima Kunjungan Kerja dari DPRD Kota Jayapura terkait dengan pengelolaan pasar dan Retribusi Metrologi Legal.
Selengkapnya
