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

Query Metrics

55 Database Queries
2 Different statements
8.82 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 5.38 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.date AS date_2, s0_.date_accuracy AS date_accuracy_3, s0_.excerpt_swe AS excerpt_swe_4, s0_.transcription AS transcription_5, s0_.research_notes AS research_notes_6, s0_.place_in_volume AS place_in_volume_7, s0_.status AS status_8, s0_.book AS book_9, s0_.pages AS pages_10, s0_.alvin_id AS alvin_id_11, s0_.type AS type_12, s0_.updated_at AS updated_at_13, s0_.language AS language_14, s0_.excerpt_eng AS excerpt_eng_15, s0_.short_excerpt_swe AS short_excerpt_swe_16, s0_.short_excerpt_eng AS short_excerpt_eng_17, s0_.transcription_modern_sve AS transcription_modern_sve_18, s0_.excerpt_eng_proofed AS excerpt_eng_proofed_19, s0_.excerpt_swe_proofed AS excerpt_swe_proofed_20, s0_.short_excerpt_eng_proofed AS short_excerpt_eng_proofed_21, s0_.short_excerpt_swe_proofed AS short_excerpt_swe_proofed_22, s0_.parent_id AS parent_id_23, s0_.volume_id AS volume_id_24, s0_.updated_by_id AS updated_by_id_25 FROM sources s0_ LEFT JOIN volumes v1_ ON (s0_.volume_id = v1_.id) WHERE YEAR(s0_.date) = ? AND v1_.published <> 0 ORDER BY s0_.date ASC
Parameters:
[
  "1740"
]
2 0.13 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6832
]
3 0.08 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6833
]
4 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6834
]
5 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6835
]
6 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6836
]
7 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6837
]
8 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6838
]
9 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6839
]
10 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6840
]
11 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6841
]
12 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6842
]
13 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6843
]
14 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6844
]
15 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6845
]
16 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6846
]
17 0.08 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6847
]
18 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6848
]
19 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6849
]
20 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6850
]
21 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6851
]
22 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6852
]
23 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6853
]
24 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6854
]
25 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6855
]
26 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6856
]
27 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6857
]
28 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6858
]
29 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6859
]
30 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6860
]
31 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6861
]
32 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6862
]
33 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6863
]
34 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6864
]
35 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6865
]
36 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6866
]
37 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6867
]
38 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6868
]
39 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6869
]
40 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6870
]
41 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6871
]
42 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6872
]
43 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6873
]
44 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6874
]
45 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6875
]
46 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6876
]
47 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6877
]
48 0.07 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6878
]
49 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6879
]
50 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6880
]
51 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6881
]
52 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6882
]
53 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6883
]
54 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6884
]
55 0.06 ms
SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.release_date AS release_date_3, t0.user_id AS user_id_4, t0.source_id AS source_id_5 FROM `lock` t0 WHERE t0.source_id = ?
Parameters:
[
  6885
]

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.
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\Action No errors.
App\Entity\SourceTopic 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\Lock No errors.