Query Metrics
12
Database Queries
10
Different statements
165.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
60.55 ms (36.64%) |
2 |
"COMMIT"
Parameters:
[] |
|
58.95 ms (35.67%) |
1 |
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('PG') AND t.sumber_dana ='investasi' LIMIT 10
Parameters:
[] |
|
40.97 ms (24.79%) |
1 |
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('PG') AND t.sumber_dana ='investasi'
Parameters:
[] |
|
1.57 ms (0.95%) |
1 |
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"
]
|
|
1.33 ms (0.80%) |
1 |
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"
]
|
|
0.69 ms (0.42%) |
1 |
INSERT INTO user_activity (id, created_at, name, route, path, method, description, person_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 30820 2 => "2026-06-10 17:13:20" 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" ] |
|
0.37 ms (0.22%) |
1 |
SELECT NEXTVAL('user_activity_id_seq')
Parameters:
[] |
|
0.34 ms (0.20%) |
1 |
INSERT INTO tracking_page_view (id, url, created, session_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => 13596133 2 => "https://dashboard-sgn.appdev.web.id/backend/laporan/detail_data_table?p=backend%2Flaporan%2Fdetail_data_table" 3 => "2026-06-10 17:13:20" 4 => 1007085 ] |
|
0.27 ms (0.16%) |
1 |
SELECT NEXTVAL('tracking_page_view_id_seq')
Parameters:
[] |
|
0.22 ms (0.14%) |
2 |
"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 |
|---|---|
| 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. |