http://e-proc.pdam-makassar.com/

Query Metrics

7 Database Queries
4 Different statements
5.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.content AS content_4, t0.created_date AS created_date_5, t0.created_by AS created_by_6, t0.gambar AS gambar_7 FROM announcement t0
Parameters:
[]
2 0.62 ms
SELECT t0.id AS id_1, t0.kode AS kode_2, t0.nama AS nama_3 FROM jenis_pengadaan t0
Parameters:
[]
3 0.62 ms
SELECT t0.id AS id_1, t0.exist AS exist_2, t0.tender_id AS tender_id_3, t0.user_id AS user_id_4 FROM tender_publish_pokja t0
Parameters:
[]
4 0.97 ms
SELECT t0.id AS id_1, t0.nama_tender AS nama_tender_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.tahun_anggaran AS tahun_anggaran_5, t0.pagu AS pagu_6, t0.hps AS hps_7, t0.syarat_kualifikasi AS syarat_kualifikasi_8, t0.akhir_pendaftaran AS akhir_pendaftaran_9, t0.jenis_kontrak AS jenis_kontrak_10, t0.lokasi_pekerjaan AS lokasi_pekerjaan_11, t0.kualifikasi_usaha AS kualifikasi_usaha_12, t0.dokumen_pemilihan AS dokumen_pemilihan_13, t0.bobot_teknis AS bobot_teknis_14, t0.bobot_biaya AS bobot_biaya_15, t0.masa_berlaku_penawaran AS masa_berlaku_penawaran_16, t0.tahapan_saat_ini AS tahapan_saat_ini_17, t0.kategori_tahapan AS kategori_tahapan_18, t0.gambar AS gambar_19, t0.publish AS publish_20, t0.kode_tender_id AS kode_tender_id_21, t0.id_rup_id AS id_rup_id_22, t0.id_jenis_pengadaan_id AS id_jenis_pengadaan_id_23, t0.metode_pengadaan_id AS metode_pengadaan_id_24, t0.master_jenis_kontrak_id AS master_jenis_kontrak_id_25, t0.group_pokja_id AS group_pokja_id_26 FROM tender t0 WHERE t0.id_jenis_pengadaan_id = ?
Parameters:
[
  1
]
5 0.92 ms
SELECT t0.id AS id_1, t0.nama_tender AS nama_tender_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.tahun_anggaran AS tahun_anggaran_5, t0.pagu AS pagu_6, t0.hps AS hps_7, t0.syarat_kualifikasi AS syarat_kualifikasi_8, t0.akhir_pendaftaran AS akhir_pendaftaran_9, t0.jenis_kontrak AS jenis_kontrak_10, t0.lokasi_pekerjaan AS lokasi_pekerjaan_11, t0.kualifikasi_usaha AS kualifikasi_usaha_12, t0.dokumen_pemilihan AS dokumen_pemilihan_13, t0.bobot_teknis AS bobot_teknis_14, t0.bobot_biaya AS bobot_biaya_15, t0.masa_berlaku_penawaran AS masa_berlaku_penawaran_16, t0.tahapan_saat_ini AS tahapan_saat_ini_17, t0.kategori_tahapan AS kategori_tahapan_18, t0.gambar AS gambar_19, t0.publish AS publish_20, t0.kode_tender_id AS kode_tender_id_21, t0.id_rup_id AS id_rup_id_22, t0.id_jenis_pengadaan_id AS id_jenis_pengadaan_id_23, t0.metode_pengadaan_id AS metode_pengadaan_id_24, t0.master_jenis_kontrak_id AS master_jenis_kontrak_id_25, t0.group_pokja_id AS group_pokja_id_26 FROM tender t0 WHERE t0.id_jenis_pengadaan_id = ?
Parameters:
[
  2
]
6 0.91 ms
SELECT t0.id AS id_1, t0.nama_tender AS nama_tender_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.tahun_anggaran AS tahun_anggaran_5, t0.pagu AS pagu_6, t0.hps AS hps_7, t0.syarat_kualifikasi AS syarat_kualifikasi_8, t0.akhir_pendaftaran AS akhir_pendaftaran_9, t0.jenis_kontrak AS jenis_kontrak_10, t0.lokasi_pekerjaan AS lokasi_pekerjaan_11, t0.kualifikasi_usaha AS kualifikasi_usaha_12, t0.dokumen_pemilihan AS dokumen_pemilihan_13, t0.bobot_teknis AS bobot_teknis_14, t0.bobot_biaya AS bobot_biaya_15, t0.masa_berlaku_penawaran AS masa_berlaku_penawaran_16, t0.tahapan_saat_ini AS tahapan_saat_ini_17, t0.kategori_tahapan AS kategori_tahapan_18, t0.gambar AS gambar_19, t0.publish AS publish_20, t0.kode_tender_id AS kode_tender_id_21, t0.id_rup_id AS id_rup_id_22, t0.id_jenis_pengadaan_id AS id_jenis_pengadaan_id_23, t0.metode_pengadaan_id AS metode_pengadaan_id_24, t0.master_jenis_kontrak_id AS master_jenis_kontrak_id_25, t0.group_pokja_id AS group_pokja_id_26 FROM tender t0 WHERE t0.id_jenis_pengadaan_id = ?
Parameters:
[
  3
]
7 0.88 ms
SELECT t0.id AS id_1, t0.nama_tender AS nama_tender_2, t0.created_date AS created_date_3, t0.updated_date AS updated_date_4, t0.tahun_anggaran AS tahun_anggaran_5, t0.pagu AS pagu_6, t0.hps AS hps_7, t0.syarat_kualifikasi AS syarat_kualifikasi_8, t0.akhir_pendaftaran AS akhir_pendaftaran_9, t0.jenis_kontrak AS jenis_kontrak_10, t0.lokasi_pekerjaan AS lokasi_pekerjaan_11, t0.kualifikasi_usaha AS kualifikasi_usaha_12, t0.dokumen_pemilihan AS dokumen_pemilihan_13, t0.bobot_teknis AS bobot_teknis_14, t0.bobot_biaya AS bobot_biaya_15, t0.masa_berlaku_penawaran AS masa_berlaku_penawaran_16, t0.tahapan_saat_ini AS tahapan_saat_ini_17, t0.kategori_tahapan AS kategori_tahapan_18, t0.gambar AS gambar_19, t0.publish AS publish_20, t0.kode_tender_id AS kode_tender_id_21, t0.id_rup_id AS id_rup_id_22, t0.id_jenis_pengadaan_id AS id_jenis_pengadaan_id_23, t0.metode_pengadaan_id AS metode_pengadaan_id_24, t0.master_jenis_kontrak_id AS master_jenis_kontrak_id_25, t0.group_pokja_id AS group_pokja_id_26 FROM tender t0 WHERE t0.id_jenis_pengadaan_id = ?
Parameters:
[
  7
]

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
App\Entity\Announcement No errors.
App\Entity\JenisPengadaan No errors.
App\Entity\Tender No errors.
App\Entity\TenderPublishPokja No errors.
App\Entity\User No errors.
App\Entity\Rup No errors.
App\Entity\TenderMetodePenyampaianDokumenPenawaran No errors.
App\Entity\MetodePengadaan No errors.
App\Entity\JenisKontrak No errors.
App\Entity\PokjaGroup No errors.
App\Entity\VendorTender No errors.
App\Entity\TenderTahapan No errors.
App\Entity\TenderKualifikasi No errors.
App\Entity\TenderDokumenPenawaran No errors.
App\Entity\TenderIzinUsaha No errors.
App\Entity\TenderKak No errors.
App\Entity\TenderRancanganKontrak No errors.
App\Entity\TenderSyaratTenagaAhli No errors.
App\Entity\TenderSyaratTenagaTerampil No errors.
App\Entity\TenderKemampuanPeralatan No errors.
App\Entity\TenderPokja No errors.
App\Entity\TenderHps No errors.
App\Entity\TenderDokumenPanduan No errors.