Query Metrics
9
Database Queries
9
Different statements
8.12 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.52 ms (43.37%) |
1 |
"COMMIT"
Parameters:
[] |
1.63 ms (20.09%) |
1 |
SELECT t0.id AS id_1, t0.judul AS judul_2, t0.deskripsi AS deskripsi_3, t0.view AS view_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.sumber AS sumber_7, t0.is_arsip AS is_arsip_8, t0.release_date AS release_date_9, t0.div_id AS div_id_10 FROM t_infografik t0 WHERE t0.id = ?
Parameters:
[
"22"
]
|
0.78 ms (9.64%) |
1 |
SELECT t0_.id AS id_0, t0_.nama AS nama_1, t0_.path AS path_2, t0_.deskripsi AS deskripsi_3, t0_.reff_id AS reff_id_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.reff_name AS reff_name_7, t0_.file_type AS file_type_8 FROM t_dokumen t0_ WHERE t0_.reff_id = ? AND t0_.reff_name = ? AND t0_.file_type <> ?
Parameters:
[ "22" "INFOGRAFIK" "pdf" ] |
0.56 ms (6.89%) |
1 |
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 WHERE t0.id = ?
Parameters:
[
4
]
|
0.45 ms (5.50%) |
1 |
SELECT t0.id AS id_1, t0.nama AS nama_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.icon AS icon_5 FROM m_kategori t0 ORDER BY t0.id ASC
Parameters:
[] |
0.40 ms (4.97%) |
1 |
SELECT t0.id AS id_1, t0.reff_id AS reff_id_2, t0.reff_name AS reff_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.urusan_id AS urusan_id_6 FROM m_urusan_detail t0 WHERE t0.reff_id = ? AND t0.reff_name = ?
Parameters:
[ "22" "INFOGRAFIK" ] |
0.36 ms (4.48%) |
1 |
UPDATE t_infografik SET view = ? WHERE id = ?
Parameters:
[ 36 22 ] |
0.30 ms (3.73%) |
1 |
SELECT t0_.id AS id_0, t0_.nama AS nama_1, t0_.path AS path_2, t0_.deskripsi AS deskripsi_3, t0_.reff_id AS reff_id_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.reff_name AS reff_name_7, t0_.file_type AS file_type_8 FROM t_dokumen t0_ WHERE t0_.reff_id = ? AND t0_.reff_name = ? AND t0_.file_type = ?
Parameters:
[ "22" "INFOGRAFIK" "pdf" ] |
0.11 ms (1.31%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\TInfografik | No errors. |
App\Entity\TDokumen | No errors. |
App\Entity\MKategoriDetail | No errors. |
App\Entity\MUrusanDetail |
|
App\Entity\TDiv | No errors. |
App\Entity\MBidang | No errors. |
App\Entity\MUrusan |
|
App\Entity\MKategori | No errors. |
App\Entity\MSektor | No errors. |
App\Entity\TPublikasi | No errors. |