GET https://eboard.mosti.gov.my/agensi/public/2

Response
200 OK
IP
10.21.31.118
Profiled on
Token
56aeac

Query Metrics

33 Database Queries
6 Different statements
28.24 ms Query time
2 Invalid entities
493 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.22 ms 
SELECT t0.id AS id_1, t0.nama_agensi AS nama_agensi_2, t0.singkatan_agensi AS singkatan_agensi_3, t0.nota AS nota_4, t0.info AS info_5, t0.fungsi AS fungsi_6, t0.manda AS manda_7, t0.kategory_syarat_pelantikan AS kategory_syarat_pelantikan_8, t0.kategori_id AS kategori_id_9, t0.status_agensi_id AS status_agensi_id_10, t0.pegawai_id AS pegawai_id_11, t0.status_id AS status_id_12 FROM agensi t0 WHERE t0.id = ?
Parameters: 
[
  "2"
]
View formatted query    View runnable query    Explain query
2 1.18 ms 
SELECT t0.id AS id_1, t0.nama_jawatan AS nama_jawatan_2, t0.susunan AS susunan_3, t0.singkatan_jawatan AS singkatan_jawatan_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.pegawai_id AS pegawai_id_7, t0.status_id AS status_id_8, t0.agensi_id AS agensi_id_9, t0.peranan_ketua_id AS peranan_ketua_id_10, t0.penempatan_id AS penempatan_id_11, t0.bahagianjawatan_id AS bahagianjawatan_id_12 FROM jawatan t0 WHERE t0.agensi_id = ? ORDER BY t0.susunan ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
3 1.09 ms 
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.pegawai_id AS pegawai_id_3, t0.kepakaran_id AS kepakaran_id_4 FROM kepakaran t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.82 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
5 0.92 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
6 0.78 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  111
]
View formatted query    View runnable query    Explain query
7 0.94 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
8 1.06 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
9 0.75 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  48
]
View formatted query    View runnable query    Explain query
10 0.80 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  90
]
View formatted query    View runnable query    Explain query
11 1.06 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  185
]
View formatted query    View runnable query    Explain query
12 0.77 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  78
]
View formatted query    View runnable query    Explain query
13 0.84 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  92
]
View formatted query    View runnable query    Explain query
14 0.83 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  41
]
View formatted query    View runnable query    Explain query
15 0.77 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query
16 0.70 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query
17 0.87 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  236
]
View formatted query    View runnable query    Explain query
18 0.72 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  475
]
View formatted query    View runnable query    Explain query
19 0.70 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  91
]
View formatted query    View runnable query    Explain query
20 0.77 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  235
]
View formatted query    View runnable query    Explain query
21 0.77 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  72
]
View formatted query    View runnable query    Explain query
22 0.69 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query
23 0.99 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  40
]
View formatted query    View runnable query    Explain query
24 0.73 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
25 0.80 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
26 1.01 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
27 0.77 ms 
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.rujukancode AS rujukancode_3, t0.flag_id AS flag_id_4 FROM rujukan t0 WHERE t0.id = ?
Parameters: 
[
  69
]
View formatted query    View runnable query    Explain query
28 0.81 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  96
]
View formatted query    View runnable query    Explain query
29 0.84 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  181
]
View formatted query    View runnable query    Explain query
30 0.77 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  121
]
View formatted query    View runnable query    Explain query
31 0.85 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  182
]
View formatted query    View runnable query    Explain query
32 0.77 ms 
SELECT t0.id AS id_1, t0.tarikh_mula AS tarikh_mula_2, t0.tarikh_tamat AS tarikh_tamat_3, t0.catatan AS catatan_4, t0.send_tamat_penempatan AS send_tamat_penempatan_5, t0.jawatan_id AS jawatan_id_6, t0.pegawai_id AS pegawai_id_7, t0.bahagian_id AS bahagian_id_8 FROM penempatan t0 WHERE t0.jawatan_id = ?
Parameters: 
[
  115
]
View formatted query    View runnable query    Explain query
33 0.85 ms 
SELECT t0.id AS id_1, t0.nama_pegawai AS nama_pegawai_2, t0.penempatan AS penempatan_3, t0.bidang AS bidang_4, t0.jawatan_disandang AS jawatan_disandang_5, t0.lampiran AS lampiran_6, t0.gambar AS gambar_7, t0.mykad AS mykad_8, t0.umur AS umur_9, t0.nohp AS nohp_10, t0.emel AS emel_11, t0.alamat AS alamat_12, t0.passport AS passport_13, t0.tarikh_lahir AS tarikh_lahir_14, t0.gelaran_id AS gelaran_id_15, t0.wakil_id AS wakil_id_16, t0.negeriasal_id AS negeriasal_id_17, t0.wakil_detail_id AS wakil_detail_id_18, t0.status_warganegara_id AS status_warganegara_id_19 FROM pegawai t0 WHERE t0.id = ?
Parameters: 
[
  186
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Kepakaran 226
App\Entity\Rujukan 117
App\Entity\Pegawai 103
App\Entity\Penempatan 25
App\Entity\Jawatan 20
App\Entity\Agensi 1
App\Entity\Flag 1

Entities Mapping

Class Mapping errors
App\Entity\Agensi No errors.
App\Entity\Rujukan No errors.
App\Entity\Pegawai No errors.
App\Entity\Jawatan
  • The association App\Entity\Jawatan#bahagianjawatan refers to the inverse side field App\Entity\Rujukan#bahagianjawatans which does not exist.
App\Entity\Penempatan No errors.
App\Entity\Permohonan No errors.
App\Entity\PeerReview No errors.
App\Entity\Kehadiran No errors.
App\Entity\Kepakaran No errors.
App\Entity\StatusProses No errors.
App\Entity\Akademik No errors.
App\Entity\Pekerjaan No errors.
App\Entity\Pengalaman No errors.
App\Entity\Pencapaian No errors.
App\Entity\Sumbangan No errors.
App\Entity\Jawatankuasa No errors.
App\Entity\Iktisas No errors.
App\Entity\Flag No errors.
App\Entity\ProfilAccount No errors.
App\Entity\Perakuan No errors.
App\Entity\SyaratPelantikan No errors.
App\Entity\Profil
  • The association App\Entity\Profil#perakuans refers to the owning side field App\Entity\Perakuan#profil which does not exist.
  • The association App\Entity\Profil#jawatans refers to the owning side field App\Entity\Jawatan#createdBy which does not exist.
  • The association App\Entity\Profil#jawatans1 refers to the owning side field App\Entity\Jawatan#updatedBy which does not exist.