Query Metrics
11
Database Queries
9
Different statements
38.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.92 ms (48.66%) |
1 |
SELECT NEXTVAL('user_activity_id_seq')
Parameters:
[] |
|
16.41 ms (42.21%) |
2 |
"COMMIT"
Parameters:
[] |
|
1.03 ms (2.66%) |
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"
]
|
|
0.78 ms (2.01%) |
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:
[
"6650747"
]
|
|
0.49 ms (1.26%) |
1 |
INSERT INTO user_activity (id, created_at, name, route, path, method, description, person_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 30913 2 => "2026-09-28 16:34:26" 3 => "t_raw_data" 4 => "t_raw_data_form_file" 5 => "/backend/t_raw_data/form_file" 6 => "GET" 7 => "form_file" 8 => "1f09ce3c-07e4-66d0-807a-9511b5b4e666" ] |
|
0.46 ms (1.18%) |
1 |
SELECT t0.id AS id_1, t0.tahun_anggaran AS tahun_anggaran_2, t0.tanggal AS tanggal_3, t0.data AS data_4, t0.created_by AS created_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.data_ungroup AS data_ungroup_8 FROM t_posting_laporan t0 ORDER BY t0.tanggal DESC LIMIT 1
Parameters:
[] |
|
0.38 ms (0.98%) |
1 |
INSERT INTO tracking_page_view (id, url, created, session_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => 27909239 2 => "https://dashboard-sgn.appdev.web.id/backend/t_raw_data/form_file?p=backend%2Ft_raw_data%2Fform_file" 3 => "2026-09-28 16:34:26" 4 => 6650747 ] |
|
0.21 ms (0.54%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.21 ms (0.53%) |
1 |
SELECT NEXTVAL('tracking_page_view_id_seq')
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\THeader | No errors. |
| App\Entity\TRawData | No errors. |
| App\Entity\TProgres | No errors. |
| App\Entity\TPostingLaporan | No errors. |
| App\Entity\DocumentUpload | No errors. |