http://opendata.kedirikab.go.id/publikasii/detail/29.html?p=publikasii%2Fdetail%2F29.html

Query Metrics

9 Database Queries
9 Different statements
10.77 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.59 ms
(24.04%)
1
"COMMIT"
Parameters:
[]
2.04 ms
(18.96%)
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:
[
  "29"
  "INFOGRAFIK"
  "pdf"
]
1.33 ms
(12.39%)
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:
[]
1.27 ms
(11.78%)
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:
[
  "29"
]
1.18 ms
(10.99%)
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:
[
  9
]
0.81 ms
(7.51%)
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:
[
  "29"
  "INFOGRAFIK"
]
0.71 ms
(6.55%)
1
UPDATE t_infografik SET view = ? WHERE id = ?
Parameters:
[
  28
  29
]
0.64 ms
(5.95%)
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:
[
  "29"
  "INFOGRAFIK"
  "pdf"
]
0.20 ms
(1.83%)
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
  • The mappings App\Entity\MUrusanDetail#urusan and App\Entity\MUrusan#mUrusanDetails are inconsistent with each other.
App\Entity\TDiv No errors.
App\Entity\MBidang No errors.
App\Entity\MUrusan
  • The association App\Entity\MUrusan#mUrusanDetails refers to the owning side field App\Entity\MUrusanDetail#urusan_id which does not exist.
App\Entity\MKategori No errors.
App\Entity\MSektor No errors.
App\Entity\TPublikasi No errors.