Query Metrics
7
Database Queries
7
Different statements
1.95 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 ms |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"opendxp_staticroutes"
]
|
| 2 | 0.24 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
| 3 | 0.41 ms |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 2 ] |
| 4 | 0.20 ms |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
2
]
|
| 5 | 0.11 ms |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
2
]
|
| 6 | 0.06 ms |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
2
]
|
| 7 | 0.59 ms |
SELECT g0_.id AS id_0, g0_.state AS state_1, g0_.currentStep AS currentStep_2, g0_.currentMessage AS currentMessage_3, g0_.log AS log_4, g0_.serializedJob AS serializedJob_5, g0_.context AS context_6, g0_.creationDate AS creationDate_7, g0_.modificationDate AS modificationDate_8, g0_.executionContext AS executionContext_9, g0_.totalElements AS totalElements_10, g0_.processedElementsForStep AS processedElementsForStep_11, g0_.jobName AS jobName_12, g0_.pendingOperations AS pendingOperations_13, g0_.dispatchedMessages AS dispatchedMessages_14, g0_.succeededMessages AS succeededMessages_15, g0_.failedMessages AS failedMessages_16, g0_.total AS total_17, g0_.progress AS progress_18, g0_.result AS result_19, g0_.ownerId AS ownerId_20 FROM generic_execution_engine_job_run g0_ WHERE g0_.ownerId = ? AND (g0_.state = ? OR (g0_.executionContext IN (?) AND g0_.state IN (?, ?))) ORDER BY g0_.id DESC LIMIT 30
Parameters:
[ 2 "running" "admin_grid_export" "finished" "finished_with_errors" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| ubeeo | doctrine.orm.ubeeo_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
ubeeo entity manager
| Class | Amount of managed objects |
|---|
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
ubeeo entity manager
No loaded entities.
default entity manager
| Class | Mapping errors |
|---|---|
| OpenDxp\Bundle\GenericExecutionEngineBundle\Entity\JobRun | No errors. |