| 0.0005 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'site_name'
|
| 0.0003 |
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.0003 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'office_phone'
|
| 0.0003 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'site_favicon_16'
|
| 0.0003 |
SELECT *
FROM `setting`
WHERE `setting_name` = 'site_favicon_32'
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `menu_status` = 1
ORDER BY `menu_order` ASC
|
| 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.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
|
| 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.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_date` DESC
|
| 0.0003 |
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.0005 |
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.0003 |
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.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.0003 |
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'
|
