Query Metrics
9
Database Queries
9
Different statements
6.59 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.78 ms |
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:
[
"27"
]
|
2 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.38 ms |
UPDATE t_infografik SET view = ? WHERE id = ?
Parameters:
[ 87 27 ] |
4 | 1.29 ms |
"COMMIT"
Parameters:
[] |
5 | 0.93 ms |
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:
[ "27" "INFOGRAFIK" "pdf" ] |
6 | 0.42 ms |
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:
[ "27" "INFOGRAFIK" "pdf" ] |
7 | 0.44 ms |
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:
[ "27" "INFOGRAFIK" ] |
8 | 0.64 ms |
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:
[] |
9 | 0.51 ms |
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:
[
9
]
|
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. |