https://dashboard-sgn.appdev.web.id/backend/dashboard/getPostingDates?p=backend%2Fdashboard%2FgetPostingDates

Query Metrics

11 Database Queries
9 Different statements
41.22 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
34.35 ms
(83.33%)
2
"COMMIT"
Parameters:
[]
1.74 ms
(4.22%)
1
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
]
1.40 ms
(3.40%)
1
SELECT t0_.tanggal AS tanggal_0 FROM t_posting_laporan t0_
Parameters:
[]
0.92 ms
(2.24%)
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:
[
  "7372"
]
0.83 ms
(2.01%)
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:
[
  "1ed35617-b8d3-68ca-9889-992233484e41"
]
0.79 ms
(1.93%)
1
SELECT NEXTVAL('tracking_page_view_id_seq')
Parameters:
[]
0.50 ms
(1.22%)
2
"START TRANSACTION"
Parameters:
[]
0.43 ms
(1.04%)
1
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"
]
0.25 ms
(0.61%)
1
SELECT NEXTVAL('user_activity_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\TPostingLaporan No errors.
App\Entity\MPlant No errors.
App\Entity\DocumentUpload No errors.