GET https://mining.dighist.se/page/view/12786

Query Metrics

10 Database Queries
6 Different statements
2.17 ms Query time
7 Invalid entities
55 Managed entities

Queries

Group similar statements

# Time Info
1 0.26 ms
SELECT t0.id AS id_1, t0.ra_id AS ra_id_2, t0.thumbnail AS thumbnail_3, t0.updated_at AS updated_at_4, t0.reading_order AS reading_order_5, t0.width AS width_6, t0.height AS height_7, t0.text_equiv AS text_equiv_8, t0.volume_id AS volume_id_9 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  "12786"
]
2 0.29 ms
SELECT p0_.id AS id_0, p0_.ra_id AS ra_id_1, p0_.thumbnail AS thumbnail_2, p0_.updated_at AS updated_at_3, p0_.reading_order AS reading_order_4, p0_.width AS width_5, p0_.height AS height_6, p0_.text_equiv AS text_equiv_7, p0_.volume_id AS volume_id_8 FROM pages p0_ WHERE p0_.volume_id = ? AND p0_.reading_order = ?
Parameters:
[
  4
  24
]
3 0.19 ms
SELECT p0_.id AS id_0, p0_.ra_id AS ra_id_1, p0_.thumbnail AS thumbnail_2, p0_.updated_at AS updated_at_3, p0_.reading_order AS reading_order_4, p0_.width AS width_5, p0_.height AS height_6, p0_.text_equiv AS text_equiv_7, p0_.volume_id AS volume_id_8 FROM pages p0_ WHERE p0_.volume_id = ? AND p0_.reading_order = ?
Parameters:
[
  4
  26
]
4 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.ra_id AS ra_id_3, t0.abbreviation AS abbreviation_4, t0.external_link AS external_link_5, t0.start_date AS start_date_6, t0.start_date_accuracy AS start_date_accuracy_7, t0.end_date AS end_date_8, t0.end_date_accuracy AS end_date_accuracy_9, t0.description AS description_10, t0.research_notes AS research_notes_11, t0.status AS status_12, t0.updated_at AS updated_at_13, t0.series_id AS series_id_14, t0.author_id AS author_id_15, t0.updated_by_id AS updated_by_id_16 FROM volumes t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 0.12 ms
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.reading_order AS reading_order_3, t0.structural_tag AS structural_tag_4, t0.coordinates AS coordinates_5, t0.updated_at AS updated_at_6, t0.page_id AS page_id_7 FROM regions t0 WHERE t0.page_id = ?
Parameters:
[
  12786
]
6 0.13 ms
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.reading_order AS reading_order_3, t0.text_equiv AS text_equiv_4, t0.updated_at AS updated_at_5, t0.coordinates AS coordinates_6, t0.baseline_coordinates AS baseline_coordinates_7, t0.region_id AS region_id_8, t0.updated_by_id AS updated_by_id_9 FROM textLines t0 WHERE t0.region_id = ? ORDER BY t0.reading_order ASC
Parameters:
[
  44314
]
7 0.59 ms
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.reading_order AS reading_order_3, t0.text_equiv AS text_equiv_4, t0.updated_at AS updated_at_5, t0.coordinates AS coordinates_6, t0.baseline_coordinates AS baseline_coordinates_7, t0.region_id AS region_id_8, t0.updated_by_id AS updated_by_id_9 FROM textLines t0 WHERE t0.region_id = ? ORDER BY t0.reading_order ASC
Parameters:
[
  44315
]
8 0.12 ms
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.reading_order AS reading_order_3, t0.text_equiv AS text_equiv_4, t0.updated_at AS updated_at_5, t0.coordinates AS coordinates_6, t0.baseline_coordinates AS baseline_coordinates_7, t0.region_id AS region_id_8, t0.updated_by_id AS updated_by_id_9 FROM textLines t0 WHERE t0.region_id = ? ORDER BY t0.reading_order ASC
Parameters:
[
  44316
]
9 0.16 ms
SELECT t0.id AS id_1, t0.xml_id AS xml_id_2, t0.reading_order AS reading_order_3, t0.text_equiv AS text_equiv_4, t0.updated_at AS updated_at_5, t0.coordinates AS coordinates_6, t0.baseline_coordinates AS baseline_coordinates_7, t0.region_id AS region_id_8, t0.updated_by_id AS updated_by_id_9 FROM textLines t0 WHERE t0.region_id = ? ORDER BY t0.reading_order ASC
Parameters:
[
  44317
]
10 0.19 ms
SELECT t0.id AS id_1, t0.surname AS surname_2, t0.first_name AS first_name_3, t0.birthdate AS birthdate_4, t0.birthdate_accuracy AS birthdate_accuracy_5, t0.date_of_death AS date_of_death_6, t0.date_of_death_accuracy AS date_of_death_accuracy_7, t0.sv_description AS sv_description_8, t0.en_description AS en_description_9, t0.research_notes AS research_notes_10, t0.gender AS gender_11, t0.alt_surnames AS alt_surnames_12, t0.alt_first_names AS alt_first_names_13, t0.alvin_id AS alvin_id_14, t0.updated_at AS updated_at_15, t0.wikidata_id AS wikidata_id_16, t0.sbl_id AS sbl_id_17, t0.literature_bank_id AS literature_bank_id_18, t0.runeberg_id AS runeberg_id_19, t0.sv_wikipedia_link AS sv_wikipedia_link_20, t0.en_wikipedia_link AS en_wikipedia_link_21, t0.sv_wikisource_link AS sv_wikisource_link_22, t0.en_wikisource_link AS en_wikisource_link_23, t0.commons_wiki_link AS commons_wiki_link_24, t0.display_on_frontpage AS display_on_frontpage_25, t0.birth_place_id AS birth_place_id_26, t0.place_of_death_id AS place_of_death_id_27, t28.id AS id_29, t28.actor_id AS actor_id_30, t28.institution_id AS institution_id_31, t0.updated_by_id AS updated_by_id_32, t33.id AS id_34, t33.type AS type_35, t33.name AS name_36, t33.size AS size_37, t33.updated_at AS updated_at_38, t33.path AS path_39, t33.description AS description_40, t33.source_id AS source_id_41, t33.place_id AS place_id_42, t33.actor_id AS actor_id_43 FROM actors t0 LEFT JOIN correspondents t28 ON t28.actor_id = t0.id LEFT JOIN files t33 ON t33.actor_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\TextLine 44
App\Entity\Region 4
App\Entity\Page 3
App\Entity\Volume 1
App\Entity\Series 1
App\Entity\Actor 1
App\Entity\Correspondent 1

Entities Mapping

Class Mapping errors
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 mappings App\Entity\Actor#volumes and App\Entity\Volume#author are inconsistent with each other.
  • The mappings App\Entity\Actor#updated_by and App\Entity\User#edited_actors are inconsistent with each other.
App\Entity\Page No errors.
App\Entity\Volume
  • The association App\Entity\Volume#author refers to the inverse side field App\Entity\Actor#authoredVolumes which does not exist.
  • The mappings App\Entity\Volume#updated_by and App\Entity\User#edited_actors are inconsistent with each other.
App\Entity\Region
  • The mappings App\Entity\Region#textLines and App\Entity\TextLine#region are inconsistent with each other.
App\Entity\Series No errors.
App\Entity\User
  • The association App\Entity\User#edited_volumes refers to the owning side field App\Entity\Volume#updatedBy which does not exist.
  • The association App\Entity\User#edited_actors refers to the owning side field App\Entity\Actor#updatedBy which does not exist.
  • The association App\Entity\User#edited_text_lines refers to the owning side field App\Entity\TextLine#updatedBy which does not exist.
App\Entity\Source No errors.
App\Entity\TextLine
  • The association App\Entity\TextLine#region refers to the inverse side field App\Entity\Region#lines which does not exist.
  • The mappings App\Entity\TextLine#updated_by and App\Entity\User#edited_text_lines are inconsistent with each other.
App\Entity\Place No errors.
App\Entity\Correspondent No errors.
App\Entity\Institution No errors.
App\Entity\DatabaseFile
  • The association App\Entity\DatabaseFile#place refers to the inverse side field App\Entity\Place#image which does not exist.
App\Entity\Relationship No errors.
App\Entity\ActorOccupation No errors.
App\Entity\Mention
  • The association App\Entity\Mention#startTextLine refers to the inverse side field App\Entity\TextLine#annotations which does not exist.
  • The association App\Entity\Mention#endTextLine refers to the inverse side field App\Entity\TextLine#annotations which does not exist.
  • The association App\Entity\Mention#volume refers to the inverse side field App\Entity\Volume#mentions which does not exist.
  • The association App\Entity\Mention#page refers to the inverse side field App\Entity\Page#mentions which does not exist.
  • 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\Action No errors.