Query Metrics

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

Grouped Statements

Show all queries

audit connection

Time Count Info
5.81 ms
(67.20%)
2
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
  "216.73.216.168"
]
1.09 ms
(12.59%)
1
UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;
Parameters:
[
  "vt6kaap2h08qqdn8dsfapj6o8s"
]
1.05 ms
(12.09%)
1
INSERT INTO tbl_incoming_actions (`ipAddress`, `attempts`, `createdDate`, `updatedDate`,`expiryTime`, `oneMinAttempts`, `fiveMinAttempts`, `oneHourAttempts`) values(?, ?, now(),now(), ?, ?, ?, 0);
Parameters:
[
  "216.73.216.168"
  0
  0
  0
  0
]

core connection

Time Count Info
0.38 ms
(4.43%)
1
SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC
Parameters:
[
  "%showModule%"
]
0.32 ms
(3.70%)
1
SELECT * FROM tbl_organizations WHERE orgDomain=?;
Parameters:
[
  "44.224.79.56"
]

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.