Query Metrics

6 Database Queries
5 Different statements
40.44 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

audit connection

Time Count Info
19.87 ms
(49.13%)
2
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
  "216.73.216.171"
]
18.21 ms
(45.04%)
1
INSERT INTO tbl_incoming_actions (`ipAddress`, `attempts`, `createdDate`, `updatedDate`,`expiryTime`, `oneMinAttempts`, `fiveMinAttempts`, `oneHourAttempts`) values(?, ?, now(),now(), ?, ?, ?, 0);
Parameters:
[
  "216.73.216.171"
  0
  0
  0
  0
]
1.36 ms
(3.38%)
1
UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;
Parameters:
[
  "r5i5q7r42o476eis3spo0dah6q"
]

core connection

Time Count Info
0.52 ms
(1.28%)
1
SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC
Parameters:
[
  "%showModule%"
]
0.47 ms
(1.17%)
1
SELECT * FROM tbl_organizations WHERE orgDomain=?;
Parameters:
[
  "stage.centralstage.io"
]

Database Connections

Name Service
core doctrine.dbal.core_connection
data doctrine.dbal.data_connection
audit doctrine.dbal.audit_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.