Query Metrics
7
Database Queries
5
Different statements
11.55 ms
Query time
0
Invalid entities
Queries
audit connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.04 ms |
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
"216.73.216.25"
]
|
| 2 | 1.06 ms |
INSERT INTO tbl_incoming_actions (`ipAddress`, `attempts`, `createdDate`, `updatedDate`,`expiryTime`, `oneMinAttempts`, `fiveMinAttempts`, `oneHourAttempts`) values(?, ?, now(),now(), ?, ?, ?, 0);
Parameters:
[ "216.73.216.25" 0 0 0 0 ] |
| 3 | 3.93 ms |
SELECT TIME_TO_SEC(TIMEDIFF( expiryTime, now() )) as remainingTime FROM tbl_incoming_actions WHERE ipAddress=?;
Parameters:
[
"216.73.216.25"
]
|
| 4 | 1.33 ms |
UPDATE tbl_user_sessions SET logoutDT=NOW() WHERE sessionID = ?;
Parameters:
[
"5e60lcp8a9qm1apljjl132b8n2"
]
|
core connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
SELECT * FROM tbl_bundle WHERE bundleDescription LIKE ? ORDER BY orderby ASC
Parameters:
[
"%showModule%"
]
|
| 2 | 0.34 ms |
SELECT * FROM tbl_organizations WHERE orgDomain=?;
Parameters:
[
"stage.centralstage.io"
]
|
| 3 | 0.39 ms |
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.