0.0006 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_name'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_short_name'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_tagline'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_logo_big'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_phone'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_favicon_16'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_favicon_32'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'longitude'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'latitude'
|
0.0016 |
SELECT * FROM `media` WHERE `media_sts` = 'publish' AND `media_cat` = 'slideshow' ORDER BY `id_media` DESC LIMIT 6
|
0.0007 |
SELECT COUNT(*) as count FROM `media` WHERE `media_sts` = 'publish' AND `media_cat` = 'slideshow'
|
0.0045 |
SELECT `p`.*, `u`.*, `m`.* FROM `page` `p` LEFT JOIN `member` `m` ON `p`.`page_author` = `m`.`id` LEFT JOIN `user` `u` ON `p`.`page_operator` = `u`.`user_id` WHERE `page_slug` = 'selamat-datang'
|
0.0059 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 3
|
0.0008 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0031 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 1
|
0.0006 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0030 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 1, 2
|
0.0005 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0028 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 3, 2
|
0.0005 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0004 |
SELECT `c`.* FROM `comment` `c` ORDER BY `c`.`comment_postdate` DESC LIMIT 3
|
0.0006 |
SELECT `k`.* FROM `kategori` `k` WHERE `kat_type` = 'peraturan' ORDER BY `k`.`kat_type` ASC
|
0.0005 |
SELECT COUNT(a.artikel_id) AS count, `k`.`kat_nm`, `k`.`kat_id` FROM `artikel` `a` LEFT JOIN `kategori` `k` ON `a`.`artikel_kat` = `k`.`kat_id` WHERE `k`.`kat_type` = 'peraturan' AND `a`.`artikel_sts` != 'auto-draft' GROUP BY `k`.`kat_id` ORDER BY `k`.`kat_pos` ASC
|
0.0006 |
SELECT `a`.*, `k`.*, `u`.* FROM `artikel` `a` LEFT JOIN `kategori` `k` ON `a`.`artikel_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`artikel_usr` = `u`.`user_id` WHERE `a`.`artikel_sts` != 'auto-draft' ORDER BY `a`.`artikel_thn` DESC, `a`.`artikel_no` DESC LIMIT 10
|
0.0004 |
SELECT COUNT(*) as count FROM `artikel` `a` LEFT JOIN `kategori` `k` ON `a`.`artikel_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`artikel_usr` = `u`.`user_id` WHERE `a`.`artikel_sts` != 'auto-draft'
|
0.0004 |
SELECT `r`.*, `k`.*, `u`.* FROM `reference` `r` LEFT JOIN `kategori` `k` ON `r`.`ref_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `r`.`ref_usr` = `u`.`user_id` WHERE `r`.`ref_sts` != 'draft' ORDER BY `r`.`ref_date` DESC LIMIT 1
|
0.0004 |
SELECT COUNT(*) as count FROM `reference` `r` LEFT JOIN `kategori` `k` ON `r`.`ref_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `r`.`ref_usr` = `u`.`user_id` WHERE `r`.`ref_sts` != 'draft'
|
0.0003 |
SELECT `artikel_thn` FROM `artikel` WHERE `artikel_thn` >0 GROUP BY `artikel_thn` ORDER BY `artikel_thn` DESC
|
0.0004 |
SELECT * FROM `wise_word` WHERE `ww_sts` = 1
|
0.0009 |
SELECT `f`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `forum` `f` LEFT JOIN `kategori` `k` ON `f`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `f`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `f`.`forum_id` = `c`.`forum_id` WHERE `f`.`forum_sts` != 'auto-draft' GROUP BY `f`.`forum_id` ORDER BY `f`.`forum_date` DESC LIMIT 1
|
0.0003 |
SELECT COUNT(*) AS count FROM `forum` `f` LEFT JOIN `kategori` `k` ON `f`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `f`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `f`.`forum_id` = `c`.`forum_id` WHERE `f`.`forum_sts` != 'auto-draft'
|
0.0004 |
SELECT * FROM `media` WHERE `media_sts` = 'publish' AND `media_cat` = 'gallery' ORDER BY `id_media` DESC LIMIT 15
|
0.0006 |
SELECT COUNT(*) as count FROM `media` WHERE `media_sts` = 'publish' AND `media_cat` = 'gallery'
|
0.0005 |
SELECT * FROM `menu` WHERE `menu_status` = 1 ORDER BY `menu_order` ASC
|
0.0029 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 3
|
0.0004 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0027 |
SELECT `a`.*, `k`.*, `u`.*, COUNT(c.id_comment) AS comment FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 3
|
0.0005 |
SELECT COUNT(*) as count FROM `kegiatan` `a` LEFT JOIN `kategori` `k` ON `a`.`kat_id` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`user_id` = `u`.`user_id` LEFT JOIN `comment` `c` ON `a`.`kgt_id` = `c`.`kgt_id` WHERE `a`.`kgt_sts` != 'auto-draft'
|
0.0005 |
SELECT `a`.*, `k`.*, `u`.* FROM `artikel` `a` LEFT JOIN `kategori` `k` ON `a`.`artikel_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`artikel_usr` = `u`.`user_id` WHERE `a`.`artikel_sts` != 'auto-draft' ORDER BY `a`.`artikel_date` DESC
|
0.0004 |
SELECT COUNT(*) as count FROM `artikel` `a` LEFT JOIN `kategori` `k` ON `a`.`artikel_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `a`.`artikel_usr` = `u`.`user_id` WHERE `a`.`artikel_sts` != 'auto-draft'
|
0.0004 |
SELECT `r`.*, `k`.*, `u`.* FROM `reference` `r` LEFT JOIN `kategori` `k` ON `r`.`ref_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `r`.`ref_usr` = `u`.`user_id` WHERE `r`.`ref_sts` != 'draft' ORDER BY `r`.`ref_date` DESC
|
0.0004 |
SELECT COUNT(*) as count FROM `reference` `r` LEFT JOIN `kategori` `k` ON `r`.`ref_kat` = `k`.`kat_id` LEFT JOIN `user` `u` ON `r`.`ref_usr` = `u`.`user_id` WHERE `r`.`ref_sts` != 'draft'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_desc'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_url'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_address'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_regency'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_district'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_city'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_email'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_phone'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_fax'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'facebook'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'twitter'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'googleplus'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'instagram'
|