Query Metrics
10
Database Queries
6
Different statements
8.83 ms
Query time
2
Invalid entities
34
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.00 ms |
SELECT t0.id AS id_1, t0.pendahuluan AS pendahuluan_2 FROM pendahuluan t0
Parameters:
[] |
| 2 | 0.73 ms |
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.jawatan AS jawatan_3, t0.notelpej AS notelpej_4, t0.nohp AS nohp_5, t0.emel AS emel_6, t0.gambar AS gambar_7, t0.gelaran_id AS gelaran_id_8 FROM hubungi t0
Parameters:
[] |
| 3 | 1.73 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.status_id = ?
Parameters:
[
14
]
|
| 4 | 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.flag_id = ?
Parameters:
[
2
]
|
| 5 | 0.89 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM agensi a0_ WHERE a0_.kategori_id IS NOT NULL AND a0_.status_id = ? AND a0_.kategori_id = ?
Parameters:
[ "14" "2" ] |
| 6 | 0.79 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM agensi a0_ WHERE a0_.kategori_id IS NOT NULL AND a0_.status_id = ? AND a0_.kategori_id = ?
Parameters:
[ "14" "3" ] |
| 7 | 0.72 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM agensi a0_ WHERE a0_.kategori_id IS NOT NULL AND a0_.status_id = ? AND a0_.kategori_id = ?
Parameters:
[ "14" "4" ] |
| 8 | 0.72 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM agensi a0_ WHERE a0_.kategori_id IS NOT NULL AND a0_.status_id = ? AND a0_.kategori_id = ?
Parameters:
[ "14" "5" ] |
| 9 | 0.80 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:
[
12
]
|
| 10 | 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:
[
13
]
|
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\Agensi | 15 |
| App\Entity\Rujukan | 12 |
| App\Entity\Hubungi | 4 |
| App\Entity\Flag | 2 |
| App\Entity\Pendahuluan | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Pendahuluan | No errors. |
| App\Entity\Hubungi | No errors. |
| App\Entity\Rujukan | No errors. |
| App\Entity\Agensi | 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\Flag | No errors. |
| App\Entity\StatusProses | No errors. |
| App\Entity\ProfilAccount | No errors. |
| App\Entity\Akademik | No errors. |
| App\Entity\Perakuan | No errors. |
| App\Entity\Kepakaran | No errors. |
| App\Entity\Iktisas | No errors. |
| App\Entity\SyaratPelantikan | No errors. |
| App\Entity\Profil |
|