Query Metrics
12
Database Queries
10
Different statements
177.26 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.65 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.referrer AS referrer_3, t0.user_agent AS user_agent_4, t0.query_string AS query_string_5, t0.utm_source AS utm_source_6, t0.utm_medium AS utm_medium_7, t0.utm_campaign AS utm_campaign_8, t0.utm_term AS utm_term_9, t0.utm_content AS utm_content_10, t0.loan_term AS loan_term_11, t0.rep_apr AS rep_apr_12, t0.created AS created_13, t0.lifetime_id AS lifetime_id_14 FROM SESSION t0 WHERE t0.id = ?
Parameters:
[
"1007085"
]
|
| 2 | 1.63 ms |
SELECT t0.id AS id_3, t0.username AS username_4, t0.name AS name_5, t0.password AS password_6, t0.roles AS roles_7, t0.is_active AS is_active_8, t0.type, t1.email AS email_9, t1.telp AS telp_10, t1.login AS login_11, t1.last_login AS last_login_12, t1.user_agent AS user_agent_13, t1.div_akses AS div_akses_14, t1.kota_id AS kota_id_15, t1.div_id AS div_id_16 FROM kmj_user t0 LEFT JOIN m_user t1 ON t0.id = t1.id LEFT JOIN kmj_default_user t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
"1f09ce3c-07e4-66d0-807a-9511b5b4e666"
]
|
| 3 | 0.43 ms |
SELECT NEXTVAL('user_activity_id_seq')
Parameters:
[] |
| 4 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.78 ms |
INSERT INTO user_activity (id, created_at, name, route, path, method, description, person_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 30813 2 => "2026-06-10 17:11:04" 3 => "laporan_detail_datatable" 4 => "laporan_detail_datatable" 5 => "/backend/laporan/detail_data_table" 6 => "POST" 7 => "dataset_table" 8 => "1f09ce3c-07e4-66d0-807a-9511b5b4e666" ] |
| 6 | 48.28 ms |
"COMMIT"
Parameters:
[] |
| 7 | 65.84 ms |
SELECT * FROM v_cleansing_pk_vendor t WHERE t.kategori_tahap !='' AND tahun_anggaran = '2026' AND t.kategori_tahap='Dalam proses (pemilihan penyedia)' AND UPPER(t.kategori_plant) = UPPER('MKSO') AND t.sumber_dana ='eksploitasi' LIMIT 10
Parameters:
[] |
| 8 | 41.01 ms |
SELECT * FROM v_cleansing_pk_vendor t WHERE t.kategori_tahap !='' AND tahun_anggaran = '2026' AND t.kategori_tahap='Dalam proses (pemilihan penyedia)' AND UPPER(t.kategori_plant) = UPPER('MKSO') AND t.sumber_dana ='eksploitasi'
Parameters:
[] |
| 9 | 0.26 ms |
SELECT NEXTVAL('tracking_page_view_id_seq')
Parameters:
[] |
| 10 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.38 ms |
INSERT INTO tracking_page_view (id, url, created, session_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => 13595909 2 => "https://dashboard-sgn.appdev.web.id/backend/laporan/detail_data_table?p=backend%2Flaporan%2Fdetail_data_table" 3 => "2026-06-10 17:11:04" 4 => 1007085 ] |
| 12 | 16.68 ms |
"COMMIT"
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 |
|---|---|
| App\Entity\UserActivity | No errors. |
| Kematjaya\VisitorTrackingBundle\Entity\Session | No errors. |
| Kematjaya\VisitorTrackingBundle\Entity\Lifetime | No errors. |
| Kematjaya\VisitorTrackingBundle\Entity\PageView | No errors. |
| Kematjaya\VisitorTrackingBundle\Entity\Device | No errors. |
| Kematjaya\UserBundle\Entity\KmjUser | No errors. |
| Kematjaya\UserBundle\Entity\DefaultUser | No errors. |
| App\Entity\MUser | No errors. |
| App\Entity\MKota | No errors. |
| App\Entity\TDiv | No errors. |
| App\Entity\MFeedback | No errors. |
| App\Entity\FeedbackIsi | No errors. |
| App\Entity\DocumentUpload | No errors. |