Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

22 Database Queries

4 Different statements

18.28 ms Query time

2 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6 FROM m_urusan t0 ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6, t0.urusan_id AS urusan_id_7 FROM m_sektor t0 WHERE t0.urusan_id = ?
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	1.10 ms	SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6 FROM m_urusan t0 ORDER BY t0.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6 FROM m_urusan t0 ORDER BY t0.id ASC SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6 FROM m_urusan t0 ORDER BY t0.id ASC;
2	0.64 ms	SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6, t0.urusan_id AS urusan_id_7 FROM m_sektor t0 WHERE t0.urusan_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6, t0.urusan_id AS urusan_id_7 FROM m_sektor t0 WHERE t0.urusan_id = ? SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.icon AS icon_6, t0.urusan_id AS urusan_id_7 FROM m_sektor t0 WHERE t0.urusan_id = 9;
3	1.66 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`47`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 47 ORDER BY t0.id DESC LIMIT 5;
4	1.68 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`46`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 46 ORDER BY t0.id DESC LIMIT 5;
5	1.19 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 45 ORDER BY t0.id DESC LIMIT 5;
6	1.10 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`44`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 44 ORDER BY t0.id DESC LIMIT 5;
7	1.25 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`43`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 43 ORDER BY t0.id DESC LIMIT 5;
8	1.43 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`42`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 42 ORDER BY t0.id DESC LIMIT 5;
9	0.75 ms	SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 Parameters: [`41`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = ? ORDER BY t0.id DESC LIMIT 5 SELECT t0.id AS id_1, t0.judul AS judul_2, t0.sumber AS sumber_3, t0.satuan AS satuan_4, t0.tahun AS tahun_5, t0.deskripsi AS deskripsi_6, t0.kode AS kode_7, t0.dimensi AS dimensi_8, t0.keyword AS keyword_9, t0.konsep AS konsep_10, t0.rumus AS rumus_11, t0.kegunaan AS kegunaan_12, t0.intepretasi AS intepretasi_13, t0.metodologi AS metodologi_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.view AS view_17, t0.reff_id AS reff_id_18, t0.tipe AS tipe_19, t0.jenis AS jenis_20, t0.jumlah_download AS jumlah_download_21, t0.periode_id AS periode_id_22, t0.status_id AS status_id_23, t0.wilayah_id AS wilayah_id_24, t0.div_id AS div_id_25, t0.urusan_id AS urusan_id_26, t0.sektor_id AS sektor_id_27, t28.id AS id_29, t28.judul AS judul_30, t28.tipe AS tipe_31, t28.axis_x AS axis_x_32, t28.axis_y AS axis_y_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.is_show AS is_show_36, t28.axis_y_ids AS axis_y_ids_37, t28.pub_id AS pub_id_38 FROM t_publikasi t0 LEFT JOIN t_grafik t28 ON t28.pub_id = t0.id WHERE t0.sektor_id = 41 ORDER BY t0.id DESC LIMIT 5;
10	1.25 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 7;
11	0.70 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`73`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 73;
12	0.56 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`58`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 58;
13	0.63 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 11;
14	0.53 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 26;
15	0.51 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 6;
16	0.50 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`65`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 65;
17	0.51 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`79`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 79;
18	0.50 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`56`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 56;
19	0.47 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 55;
20	0.44 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`91`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 91;
21	0.44 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`89`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 89;
22	0.44 ms	SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? Parameters: [`78`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.div_nama AS div_nama_2, t0.div_icon AS div_icon_3, t0.kode AS kode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.bidang_id AS bidang_id_7, t8.id AS id_9, t8.title_id AS title_id_10, t8.title AS title_11, t8.notes AS notes_12, t8.metadata_created AS metadata_created_13, t8.metadata_modified AS metadata_modified_14, t8.organization_id AS organization_id_15, t8.organization_name AS organization_name_16, t8.private AS private_17, t8.state AS state_18, t8.type AS type_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.div_id_id AS div_id_id_22, t8.kota_id AS kota_id_23 FROM t_div t0 LEFT JOIN t_ckan t8 ON t8.div_id_id = t0.id WHERE t0.id = 78;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Kematjaya\UserBundle\Entity\KmjUser	No errors.
Kematjaya\UserBundle\Entity\DefaultUser	No errors.
App\Entity\MUrusan	The association App\Entity\MUrusan#mUrusanDetails refers to the owning side field App\Entity\MUrusanDetail#urusan_id which does not exist.
App\Entity\MSektor	No errors.
App\Entity\TPublikasi	No errors.
App\Entity\MUrusanDetail	The mappings App\Entity\MUrusanDetail#urusan and App\Entity\MUrusan#mUrusanDetails are inconsistent with each other.
App\Entity\MSektorDetail	No errors.
App\Entity\MPeriode	No errors.
App\Entity\MStatus	No errors.
App\Entity\MWilayah	No errors.
App\Entity\TDiv	No errors.
App\Entity\TGrafik	No errors.
App\Entity\TVariabel	No errors.
App\Entity\TData	No errors.
App\Entity\TFile	No errors.
App\Entity\MBidang	No errors.
App\Entity\TCkan	No errors.
App\Entity\MKota	No errors.
App\Entity\TPermohonan	No errors.
App\Entity\TInfografik	No errors.
App\Entity\TUrl	No errors.
App\Entity\MUser	No errors.

Symfony Profiler

http://opendata.kedirikab.go.id/dataset/urusan/9?p=dataset%2Furusan%2F9

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping