| 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 ('e383eec761f0ed0d181c9bb60b09652d', '34.229.131.158', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686237667, '') |
| 0.0005 |
SELECT *
FROM (`bf_settings`)Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
| 0.0071 |
UPDATE `bf_sessions` SET `last_activity` = 1686237667, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = 'e383eec761f0ed0d181c9bb60b09652d' |
| 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.0011 |
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.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.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.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.0011 |
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.0003 |
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.0003 |
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.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.0002 |
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.0061 |
UPDATE `bf_sessions` SET `last_activity` = 1686237667, `user_data` = 'a:3:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";s:6:\"pageid\";i:4;}' WHERE `session_id` = 'e383eec761f0ed0d181c9bb60b09652d' |
| 0.0005 |
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` = 4
AND `bf_pages_meta`.`deleted` IN (0, 2)
ORDER BY `created_on` DESC
LIMIT 1Speed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0185 |
UPDATE `bf_pages_meta` SET `baca` = 5321 WHERE `id` = 4 |
| 0.0005 |
select count(*) as jml from bf_pages_meta where parent_id='4' |
| 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.0029 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0029 - 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` = '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.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.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.0002 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '9'Speed: 0.0002 - 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` = 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.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 `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.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.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 `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 `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.0002 |
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.0002 - 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` = '4'
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.0001 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '4'Speed: 0.0001 - 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.0015 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0015 - 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` = 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` = 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` = '4'
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` = '58'
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` = '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.0669 |
Total Query Execution Time |
KEMENTERIAN PERDAGANGAN
DINAS PERINDAG PROVINSI JABAR
BANDUNG PUSAT
KADIN KOTA BANDUNG
KEMENTRIAN PERINDUSTRIAN
LAPOR
