| 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'
|
