Query Metrics

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

Queries

Group similar statements

audit connection

# Time Info
1 3.12 ms
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
  "216.73.216.168"
]
2 1.05 ms
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
]
3 2.70 ms
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM  tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
  "216.73.216.168"
]
4 1.09 ms
UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;
Parameters:
[
  "vt6kaap2h08qqdn8dsfapj6o8s"
]

core connection

# Time Info
1 0.38 ms
SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC
Parameters:
[
  "%showModule%"
]
2 0.32 ms
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.