Query Metrics
15
Database Queries
9
Different statements
2.01 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.17 ms |
SELECT t0.id AS id_1, t0.date_time AS date_time_2, t0.content AS content_3, t0.place_origin_id AS place_origin_id_4, t0.playable_entity_origin_id AS playable_entity_origin_id_5 FROM message t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
2 | 0.14 ms |
SELECT 'main'
Parameters:
[] |
3 | 0.23 ms |
SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name
Parameters:
[] |
4 | 0.10 ms |
SELECT 'main'
Parameters:
[] |
5 | 0.17 ms |
SELECT name AS table_name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name
Parameters:
[] |
6 | 0.10 ms |
SELECT 'main'
Parameters:
[] |
7 | 0.12 ms |
SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ?
Parameters:
[
"doctrine_migration_versions"
]
|
8 | 0.16 ms |
SELECT t.name AS table_name, p.* FROM sqlite_master t JOIN pragma_foreign_key_list(t.name) p ON p."seq" != "-1" WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, p.id DESC, p.seq
Parameters:
[
"doctrine_migration_versions"
]
|
9 | 0.16 ms |
SELECT t.name AS table_name, c.* FROM sqlite_master t JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, c.cid
Parameters:
[
"doctrine_migration_versions"
]
|
10 | 0.11 ms |
SELECT sql FROM ( SELECT * FROM sqlite_master UNION ALL SELECT * FROM sqlite_temp_master ) WHERE type = 'table' AND name = ?
Parameters:
[
"doctrine_migration_versions"
]
|
11 | 0.08 ms |
SELECT 'main'
Parameters:
[] |
12 | 0.14 ms |
SELECT t.name AS table_name, i.* FROM sqlite_master t JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = ? ORDER BY t.name, i.seq
Parameters:
[
"doctrine_migration_versions"
]
|
13 | 0.12 ms |
SELECT * FROM PRAGMA_TABLE_INFO (?)
Parameters:
[
"doctrine_migration_versions"
]
|
14 | 0.13 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
15 | 0.09 ms |
SELECT 'main'
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Message | No errors. |
App\Entity\Place | No errors. |
App\Entity\PlayableEntity | No errors. |
App\Entity\Postman | No errors. |
App\Entity\Path | No errors. |
App\Entity\UnplayableEntity | No errors. |
App\Entity\ArtifactEntity |
|
App\Entity\PlaceDescription | No errors. |
App\Entity\Log |
|
App\Entity\Ppa | No errors. |
App\Entity\Item | No errors. |
App\Entity\User | No errors. |
App\Entity\PlayableEntityDescription | No errors. |