Query Metrics
6
Database Queries
5
Different statements
6.66 ms
Query time
0
Invalid entities
Grouped Statements
audit connection
Time▼ | Count | Info |
---|---|---|
4.05 ms (60.81%) |
2 |
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
"65.49.1.222"
]
|
1.06 ms (15.88%) |
1 |
UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;
Parameters:
[
"c4fvdcvf5i27ld70o555o5st71"
]
|
0.82 ms (12.38%) |
1 |
INSERT INTO tbl_incoming_actions (`ipAddress`, `attempts`, `createdDate`, `updatedDate`,`expiryTime`, `oneMinAttempts`, `fiveMinAttempts`, `oneHourAttempts`) values(?, ?, now(),now(), ?, ?, ?, 0);
Parameters:
[ "65.49.1.222" 0 0 0 0 ] |
core connection
Time▼ | Count | Info |
---|---|---|
0.39 ms (5.80%) |
1 |
SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC
Parameters:
[
"%showModule%"
]
|
0.34 ms (5.14%) |
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.