| 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.0004 |
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.0005 |
SELECT `k`.*
FROM `kategori` `k`
WHERE `kat_type` = 'peraturan'
ORDER BY `k`.`kat_type` ASC
|
| 0.0006 |
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.0004 |
SELECT `artikel_thn`
FROM `artikel`
WHERE `artikel_thn` >0
GROUP BY `artikel_thn`
ORDER BY `artikel_thn` DESC
|
| 0.0007 |
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 3
|
| 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.0036 |
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 `kgt_url` = 'rapat-paripurna-i-masa-persidangan-i-tahun-sidang-20222023-mengenai-ranperda'
|
| 0.0009 |
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_id` > '132'
AND `a`.`kgt_sts` = 'publish'
|
| 0.0013 |
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_id` < '132'
AND `a`.`kgt_sts` = 'publish'
|
| 0.0018 |
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'
AND `a`.`kat_id` = '5'
AND `a`.`kgt_sts` = 'publish'
AND `a`.`kgt_id` < '132'
GROUP BY `a`.`kgt_id`
ORDER BY `a`.`kgt_date` DESC
LIMIT 4
|
| 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'
AND `a`.`kat_id` = '5'
AND `a`.`kgt_sts` = 'publish'
AND `a`.`kgt_id` < '132'
|
| 0.0017 |
SELECT *
FROM `media`
WHERE `kgt_id` = '132'
AND `media_sts` = 'publish'
AND `media_cat` = 'gallery'
ORDER BY `id_media` DESC
|
| 0.0007 |
SELECT COUNT(*) as count
FROM `media`
WHERE `kgt_id` = '132'
AND `media_sts` = 'publish'
AND `media_cat` = 'gallery'
|
| 0.0004 |
SELECT `c`.*
FROM `comment` `c`
WHERE `c`.`kgt_id` = '132'
AND `c`.`comment_status` = 'publish'
ORDER BY `c`.`comment_postdate` DESC
|
| 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.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.0004 |
SELECT `c`.*
FROM `comment` `c`
ORDER BY `c`.`comment_postdate` DESC
LIMIT 3
|
| 0.0006 |
SELECT *
FROM `menu`
WHERE `menu_status` = 1
ORDER BY `menu_order` ASC
|
| 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 3
|
| 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.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
|
| 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.0008 |
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.0007 |
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.0003 |
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.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'site_desc'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'site_url'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_address'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_regency'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_district'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_city'
|
| 0.0003 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_email'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_phone'
|
| 0.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_fax'
|
| 0.0004 |
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.0004 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'instagram'
|
