| 0.0046 |
SHOW TABLES FROM `desa-lasori-butontengah`
|
| 0.0006 |
SELECT *
FROM `setting_aplikasi`
ORDER BY `key`
|
| 0.0014 |
SHOW DATABASES
|
| 0.0015 |
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'desa-lasori-butontengah' AND table_name = 'user'
|
| 0.0006 |
SELECT *
FROM `migrasi`
WHERE `versi_database` = '2021090101'
|
| 0.0004 |
SELECT *
FROM `migrasi`
WHERE `versi_database` = '2021090101'
|
| 0.0750 |
SELECT (SELECT COUNT(b.id)
FROM `penduduk_hidup` `b`
JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
WHERE `a`.`dusun` = 'Labelenga'
AND `a`.`rw` = '-'
AND (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai` AND `akta_lahir` <> '' ) as jumlah, (SELECT COUNT(b.id)
FROM `penduduk_hidup` `b`
JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
WHERE `a`.`dusun` = 'Labelenga'
AND `a`.`rw` = '-'
AND `b`.`sex` = '1'
AND (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai` AND `akta_lahir` <> '' ) as laki, (SELECT COUNT(b.id)
FROM `penduduk_hidup` `b`
JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
WHERE `a`.`dusun` = 'Labelenga'
AND `a`.`rw` = '-'
AND `b`.`sex` = '2'
AND (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai` AND `akta_lahir` <> '' ) as perempuan, `u`.*, concat('UMUR ', `u`.`dari`, ' S/D ', `u`.`sampai`, ' TAHUN') as nama
FROM `tweb_penduduk_umur` `u`
WHERE `u`.`status` = '1'
|
| 0.0019 |
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan
FROM `penduduk_hidup` `b`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
WHERE `a`.`dusun` = 'Labelenga'
AND `a`.`rw` = '-'
|
| 0.0004 |
SELECT p.id, p.nama, p.sasaran, p.ndesc, p.sdate, p.edate, p.userid, p.status, CONCAT('50',p.id) as lap
FROM program p WHERE 1
|