| 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.0002 |
INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('adb879141ce9a0e99ef56a6136151d9b', '34.229.131.158', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686237553, '') |
| 0.0003 |
SELECT *
FROM (`bf_settings`)Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 42 - Extra: |
| 0.0029 |
UPDATE `bf_sessions` SET `last_activity` = 1686237553, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:9:\"site_lang\";s:9:\"indonesia\";}' WHERE `session_id` = 'adb879141ce9a0e99ef56a6136151d9b' |
| 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 |
SELECT *
FROM (`bf_widget`)
WHERE `column_sidebar` = 3
ORDER BY `sort_no` ascSpeed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 11 - Extra: Using where; Using filesort |
| 0.0008 |
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.0010 |
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.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.deleted=0 and a.status_tampil=0 order by a.created_on desc limit 0,4 |
| 0.0010 |
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.0001 |
SELECT *
FROM (`bf_blogroll`)Speed: 0.0001 - 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.0001 |
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.0008 |
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.0002 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = 402
ORDER BY `created_on` DESCSpeed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM (`bf_m_kategori`)
WHERE `bf_m_kategori`.`id` = '36'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM (`bf_hit_popular`)
WHERE `id_posts` = 402Speed: 0.0001 - Possible keys: idx_id_posts - Key Used: idx_id_posts - Type: ref - Rows: 1 - Extra: |
| 0.0490 |
UPDATE `bf_hit_popular` SET `id_posts` = 402, `jml_hit` = 1067, `tanggal` = '2023-06-09' WHERE `id_posts` = 402 |
| 0.0158 |
UPDATE `bf_post_meta` SET `baca` = 1067 WHERE `id` = 402 |
| 0.0169 |
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.0009 |
select * from bf_post_meta where id <> '402'
and post_category='36' and deleted=0 and status_tampil=0 order by created_on desc limit 5 |
| 0.0012 |
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.0012 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - 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: 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.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.0031 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0031 - 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.0004 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '3'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` = '4'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.0003 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '5'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.0004 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '6'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` = '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.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` = '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.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 * from bf_scrolltext where flag_scroll=1 order by id desc |
| 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.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.0004 |
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.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0003 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `url_posts` = '402'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where |
| 0.0002 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = '402'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 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_kategori` = '36'
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.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.0002 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '1'Speed: 0.0002 - 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.0002 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '5'Speed: 0.0002 - 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.0018 |
SELECT *
FROM (`bf_pages_meta`)
WHERE `id` = '2'Speed: 0.0018 - 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.0002 |
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.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0002 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `url_posts` = '402'Speed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where |
| 0.0001 |
SELECT *
FROM (`bf_post_meta`)
WHERE `id` = '402'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 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_kategori` = '36'
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.0001 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '60'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.0001 |
SELECT *
FROM (`bf_meta_menu`)
WHERE `parent_id` = '59'
AND `location_index` = '12'
ORDER BY `rang`Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 53 - Extra: Using where; Using filesort |
| 0.1237 |
Total Query Execution Time |
KEMENTERIAN PERDAGANGAN
DINAS PERINDAG PROVINSI JABAR
BANDUNG PUSAT
KADIN KOTA BANDUNG
KEMENTRIAN PERINDUSTRIAN
LAPOR
