GET https://protokoll-prod.dighist.se/source/browse/decade/1800

Query Metrics

1 Database Queries
1 Different statements
1.57 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.57 ms
SELECT DISTINCT YEAR(s0_.date) AS sclr_0 FROM sources s0_ LEFT JOIN volumes v1_ ON (s0_.volume_id = v1_.id) WHERE v1_.published <> 0 ORDER BY YEAR(s0_.date) ASC
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\Source
  • The mappings App\Entity\Source#mentions_in_source and App\Entity\Mention#mentioned_source are inconsistent with each other.
  • The association App\Entity\Source#updated_by refers to the inverse side field App\Entity\User#edited_sources which does not exist.
App\Entity\Volume
  • The field 'App\Entity\Volume#published' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The association App\Entity\Volume#updated_by refers to the inverse side field App\Entity\User#edited_volumes which does not exist.