GET https://protokoll-prod.dighist.se/

Query Metrics

13 Database Queries
3 Different statements
2.01 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.98 ms
(49.05%)
1
SELECT a0_.id AS id_0, a0_.surname AS surname_1, a0_.first_name AS first_name_2, a0_.birthdate AS birthdate_3, a0_.birthdate_accuracy AS birthdate_accuracy_4, a0_.date_of_death AS date_of_death_5, a0_.date_of_death_accuracy AS date_of_death_accuracy_6, a0_.sv_description AS sv_description_7, a0_.en_description AS en_description_8, a0_.research_notes AS research_notes_9, a0_.gender AS gender_10, a0_.alt_surnames AS alt_surnames_11, a0_.alt_first_names AS alt_first_names_12, a0_.alvin_id AS alvin_id_13, a0_.updated_at AS updated_at_14, a0_.wikidata_id AS wikidata_id_15, a0_.sbl_id AS sbl_id_16, a0_.literature_bank_id AS literature_bank_id_17, a0_.runeberg_id AS runeberg_id_18, a0_.sv_wikipedia_link AS sv_wikipedia_link_19, a0_.en_wikipedia_link AS en_wikipedia_link_20, a0_.sv_wikisource_link AS sv_wikisource_link_21, a0_.en_wikisource_link AS en_wikisource_link_22, a0_.commons_wiki_link AS commons_wiki_link_23, a0_.display_on_frontpage AS display_on_frontpage_24, a0_.automark_ignore AS automark_ignore_25, a0_.disambiguation_page AS disambiguation_page_26, a0_.birth_place_id AS birth_place_id_27, a0_.place_of_death_id AS place_of_death_id_28, a0_.updated_by_id AS updated_by_id_29, a0_.portrait_id AS portrait_id_30 FROM actors a0_ WHERE a0_.display_on_frontpage = 1 ORDER BY a0_.updated_at DESC LIMIT 6
Parameters:
[]
0.52 ms
(25.97%)
6
SELECT t0.id AS id_1, t0.actor_id AS actor_id_2, t0.institution_id AS institution_id_3 FROM correspondents t0 WHERE t0.actor_id = ?
Parameters:
[
  2579
]
0.50 ms
(24.98%)
6
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.size AS size_4, t0.updated_at AS updated_at_5, t0.path AS path_6, t0.description AS description_7, t0.source_id AS source_id_8, t0.place_id AS place_id_9, t0.actor_id AS actor_id_10 FROM files t0 WHERE t0.id = ?
Parameters:
[
  954
]

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\Actor
  • The field 'App\Entity\Actor#SBL_id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
  • The association App\Entity\Actor#updated_by refers to the inverse side field App\Entity\User#edited_actors which does not exist.
App\Entity\Place
  • The association App\Entity\Place#image refers to the inverse side field App\Entity\DatabaseFile#places 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.
App\Entity\User
  • The association App\Entity\User#editedSources refers to the owning side field App\Entity\Source#updatedBy which does not exist.
  • The association App\Entity\User#editedVolumes refers to the owning side field App\Entity\Volume#updatedBy which does not exist.
  • The association App\Entity\User#editedActors refers to the owning side field App\Entity\Actor#updatedBy which does not exist.
App\Entity\DatabaseFile
  • The field App\Entity\DatabaseFile#place is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Place#image does not contain the required 'mappedBy="place"' attribute.
  • If association App\Entity\DatabaseFile#place is many-to-one, then the inversed side App\Entity\Place#image has to be one-to-many.
  • The field App\Entity\DatabaseFile#actor is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Actor#portrait does not contain the required 'mappedBy="actor"' attribute.
App\Entity\Relationship No errors.
App\Entity\ActorOccupation No errors.
App\Entity\Correspondent No errors.
App\Entity\Institution No errors.
App\Entity\Action No errors.
App\Entity\Mention
  • The mappings App\Entity\Mention#mentioned_source and App\Entity\Source#mentions are inconsistent with each other.
  • The association App\Entity\Mention#secondaryMention refers to the inverse side field App\Entity\Mention#PrimaryMentions which does not exist.
  • The mappings App\Entity\Mention#primaryMentions and App\Entity\Mention#secondaryMention are inconsistent with each other.
App\Entity\ActorPlace No errors.
App\Entity\IgnoreActor No errors.