https://dashboard-sgn.appdev.web.id/login?p=login

Query Metrics

12 Database Queries
8 Different statements
85.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
36.10 ms
(42.26%)
3
"COMMIT"
Parameters:
[]
15.89 ms
(18.60%)
1
INSERT INTO tracking_page_view (id, url, created, session_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => 4492470
  2 => "https://dashboard-sgn.appdev.web.id/login?p=login"
  3 => "2026-03-09 20:01:35"
  4 => 13061
]
12.07 ms
(14.13%)
1
SELECT NEXTVAL('tracking_lifetime_id_seq')
Parameters:
[]
10.87 ms
(12.72%)
1
SELECT NEXTVAL('tracking_page_view_id_seq')
Parameters:
[]
8.33 ms
(9.75%)
1
SELECT NEXTVAL('session_id_seq')
Parameters:
[]
1.07 ms
(1.26%)
1
INSERT INTO SESSION (id, ip, referrer, user_agent, query_string, utm_source, utm_medium, utm_campaign, utm_term, utm_content, loan_term, rep_apr, created, lifetime_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => 13061
  2 => "47.128.99.161"
  3 => ""
  4 => "Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)"
  5 => "p=login"
  6 => ""
  7 => ""
  8 => ""
  9 => ""
  10 => ""
  11 => ""
  12 => ""
  13 => "2026-03-09 20:01:35"
  14 => 12792
]
0.71 ms
(0.83%)
3
"START TRANSACTION"
Parameters:
[]
0.38 ms
(0.45%)
1
INSERT INTO tracking_lifetime (id, created) VALUES (?, ?)
Parameters:
[
  1 => 12792
  2 => "2026-03-09 20:01:35"
]

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\Lifetime No errors.
Kematjaya\VisitorTrackingBundle\Entity\Session No errors.
Kematjaya\VisitorTrackingBundle\Entity\Seed No errors.
Kematjaya\VisitorTrackingBundle\Entity\PageView No errors.
Kematjaya\VisitorTrackingBundle\Entity\Device No errors.
App\Entity\DocumentUpload No errors.