| 0.0004 |
SET SESSION sql_mode="STRICT_ALL_TABLES" |
| 0.0008 |
SELECT *
FROM (`bf_templates`)
WHERE `aktif` = 'Y'Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 1 - Extra: Using where |
| 0.0007 |
INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('fdd257bd7e9660758be1849128d3d615', '3.235.108.188', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1614336842, '') |
| 0.0008 |
SELECT *
FROM (`bf_settings`)Speed: 0.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
| 0.1062 |
UPDATE `bf_sessions` SET `last_activity` = 1614336842, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = 'fdd257bd7e9660758be1849128d3d615' |
| 0.0007 |
SELECT *
FROM (`bf_templates`)
WHERE `aktif` = 'Y'Speed: 0.0007 - 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.0042 |
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.0023 |
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.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.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,4 |
| 0.0026 |
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.0008 |
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.0008 - Possible keys: - Key Used: - Type: system - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_blogroll`)Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 6 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_multimedia`)
ORDER BY `id` desc
LIMIT 4Speed: 0.0006 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 4 - Extra: |
| 0.0008 |
select * from bf_arsip where post_category='8' and tgl_akhir >= '2021-02-27' order by tgl_awal asc limit 3 |
| 0.0005 |
select * from bf_arsip where post_category='28' order by tgl_arsip desc limit 3 |
| 0.0005 |
select * from bf_arsip where post_category='10' order by tgl_arsip desc limit 3 |
| 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 <> 24 and a.deleted=0 and a.status_tampil=0
order by a.created_on desc limit 5
|
| 0.0007 |
select * from bf_agenda order by tgl_agenda desc limit 5 |
| 0.0006 |
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.0008 |
select * from bf_arsip where post_category in (40) order by tgl_arsip desc limit 4 |
| 0.0005 |
select * from bf_arsip where post_category in (1) order by tgl_arsip desc limit 3 |
| 0.0005 |
select * from bf_arsip where post_category in (29) order by tgl_arsip desc limit 3 |
| 0.0005 |
select * from bf_arsip where post_category in (30) order by tgl_arsip desc limit 3 |
| 0.0005 |
SELECT *
FROM (`bf_widget_social_media`)
WHERE `bf_widget_social_media`.`id` = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 0.0006 |
select
a.*
from
bf_galeri_foto a
where
a.flag=1
order by a.id desc limit 3
|
| 0.0007 |
select * from bf_banners order by urut asc |
| 0.0005 |
select * from komoditas |
| 0.0009 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = 375
ORDER BY `created_on` DESCSpeed: 0.0009 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM (`bf_m_kategori`)
WHERE `bf_m_kategori`.`id` = '35'Speed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0020 |
SELECT *
FROM (`bf_hit_popular`)
WHERE `id_posts` = 375Speed: 0.0020 - Possible keys: idx_id_posts - Key Used: idx_id_posts - Type: ref - Rows: 1 - Extra: |
| 0.0023 |
UPDATE `bf_hit_popular` SET `id_posts` = 375, `jml_hit` = 1065, `tanggal` = '2021-02-27' WHERE `id_posts` = 375 |
| 0.0123 |
UPDATE `bf_post_meta` SET `baca` = 1061 WHERE `id` = 375 |
| 0.0309 |
select * from bf_hit_popular a, bf_post_meta b
where
a.id_posts=b.id and
a.jml_hit > 5 and
b.deleted=0 and
b.status_tampil=0 and
DATEDIFF(CURDATE() ,a.tanggal) < 30
order by b.created_on desc
limit 0, 15 |
| 0.0027 |
select * from bf_post_meta where id <> '375'
and post_category='35' and deleted=0 and status_tampil=0 order by created_on desc limit 5 |
| 0.0013 |
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.0013 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 0.0007 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '1'Speed: 0.0007 - 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: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '1'Speed: 0.0005 - 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: 52 - Extra: Using where; Using filesort |
| 0.0061 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0061 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0014 |
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.0014 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0007 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '3'Speed: 0.0007 - 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: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '4'Speed: 0.0006 - 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: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '5'Speed: 0.0005 - 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: 52 - Extra: Using where; Using filesort |
| 0.0097 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '6'Speed: 0.0097 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0034 |
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.0034 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0007 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '7'Speed: 0.0007 - 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: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '7'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: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '8'Speed: 0.0005 - 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: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '9'Speed: 0.0005 - 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - 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: 52 - 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: 52 - Extra: Using where; Using filesort |
| 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: 52 - Extra: Using where; Using filesort |
| 0.0007 |
select * from bf_scrolltext where flag_scroll=1 order by id desc |
| 0.0006 |
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.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 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.0007 |
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.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `url_posts` = '375'Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where |
| 0.0008 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = '375'Speed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0008 |
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.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using temporary; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '46'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '1'Speed: 0.0005 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '51'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0074 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '6'Speed: 0.0074 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0033 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '50'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0033 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '5'Speed: 0.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '49'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '4'Speed: 0.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '48'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '3'Speed: 0.0006 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '47'
AND `location_index` = '10'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0051 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0051 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
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.0005 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 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` = 11
AND `tipe_lokasi` = 3
AND `flag_hide` = 0
ORDER BY `list_urutan` asc
LIMIT 10Speed: 0.0004 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables |
| 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` = 12
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.0004 |
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.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` = '12'
AND `parent_id` = 0
AND `flag_hide` = 0
ORDER BY `rang` ascSpeed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `url_posts` = '375'Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where |
| 0.0008 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = '375'Speed: 0.0008 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0008 |
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.0008 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using temporary; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '58'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '62'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0006 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '61'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0006 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '60'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.0005 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '59'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 52 - Extra: Using where; Using filesort |
| 0.2638 |
Total Query Execution Time |
KEMENTERIAN PERDAGANGAN
DINAS PERINDAG PROVINSI JABAR
BANDUNG PUSAT
KADIN KOTA BANDUNG
KEMENTRIAN PERINDUSTRIAN
LAPOR
