0.0007 |
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.0005 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_phone'
|
0.0005 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_favicon_16'
|
0.0005 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_favicon_32'
|
0.0006 |
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.0006 |
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.0005 |
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.0070 |
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.0007 |
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 `c`.* FROM `comment` `c` ORDER BY `c`.`comment_postdate` DESC LIMIT 3
|
0.0034 |
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 `kgt_sts` = 'publish' GROUP BY `a`.`kgt_id` ORDER BY `a`.`kgt_date` DESC LIMIT 10, 10
|
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' AND `kgt_sts` = 'publish'
|
0.0006 |
SELECT * FROM `menu` WHERE `menu_status` = 1 ORDER BY `menu_order` ASC
|
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 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.0032 |
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.0007 |
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.0006 |
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.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_desc'
|
0.0003 |
SELECT * FROM `setting` WHERE `setting_name` = 'site_url'
|
0.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_address'
|
0.0003 |
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.0004 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_email'
|
0.0008 |
SELECT * FROM `setting` WHERE `setting_name` = 'office_phone'
|
0.0009 |
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'
|