Query Metrics
22
Database Queries
6
Different statements
21.43 ms
Query time
2
Invalid entities
474
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.86 ms (32.00%) |
7 |
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:
[
34
]
|
|
6.60 ms (30.81%) |
7 |
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:
[
62
]
|
|
4.68 ms (21.82%) |
5 |
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:
[
64
]
|
|
1.20 ms (5.59%) |
1 |
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:
[
"16"
]
|
|
1.11 ms (5.19%) |
1 |
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:
[] |
|
0.98 ms (4.59%) |
1 |
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:
[
16
]
|
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 | 114 |
| App\Entity\Pegawai | 100 |
| App\Entity\Penempatan | 20 |
| App\Entity\Jawatan | 12 |
| 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 |
|
| 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 |
|