Query Metrics
11
Database Queries
9
Different statements
41.22 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.92 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:
[
"7372"
]
|
| 2 | 0.83 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:
[
"1ed35617-b8d3-68ca-9889-992233484e41"
]
|
| 3 | 0.25 ms |
SELECT NEXTVAL('user_activity_id_seq')
Parameters:
[] |
| 4 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.43 ms |
INSERT INTO user_activity (id, created_at, name, route, path, method, description, person_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 30749 2 => "2026-03-06 07:38:09" 3 => "dashboard_dates" 4 => "dashboard_dates" 5 => "/backend/dashboard/getPostingDates" 6 => "GET" 7 => "getPostingDates" 8 => "1ed35617-b8d3-68ca-9889-992233484e41" ] |
| 6 | 28.82 ms |
"COMMIT"
Parameters:
[] |
| 7 | 1.40 ms |
SELECT t0_.tanggal AS tanggal_0 FROM t_posting_laporan t0_
Parameters:
[] |
| 8 | 0.79 ms |
SELECT NEXTVAL('tracking_page_view_id_seq')
Parameters:
[] |
| 9 | 0.38 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 1.74 ms |
INSERT INTO tracking_page_view (id, url, created, session_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => 4482273 2 => "https://dashboard-sgn.appdev.web.id/backend/dashboard/getPostingDates?p=backend%2Fdashboard%2FgetPostingDates" 3 => "2026-03-06 07:38:09" 4 => 7372 ] |
| 11 | 5.53 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\TPostingLaporan | No errors. |
| App\Entity\MPlant | No errors. |
| App\Entity\DocumentUpload | No errors. |