GET https://mining.dighist.ddnsfree.com/volume/view/5/90

Query Metrics

4 Database Queries
2 Different statements
0.79 ms Query time
5 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(65.21%)
3
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:
[
  "863"
]
0.27 ms
(34.79%)
1
SELECT m0_.id AS id_0, m0_.date AS date_1, m0_.date_accuracy AS date_accuracy_2, m0_.description AS description_3, m0_.text_equiv AS text_equiv_4, m0_.context_window AS context_window_5, m0_.start_page AS start_page_6, m0_.end_page AS end_page_7, m0_.start_pos AS start_pos_8, m0_.end_pos AS end_pos_9, m0_.time AS time_10, m0_.verb AS verb_11, m0_.paragraph AS paragraph_12, m0_.continued AS continued_13, m0_.entity_text AS entity_text_14, m0_.mention_type AS mention_type_15, m0_.start_text_line_id AS start_text_line_id_16, m0_.end_text_line_id AS end_text_line_id_17, m0_.actor_id AS actor_id_18, m0_.institution_id AS institution_id_19, m0_.place_id AS place_id_20, m0_.volume_id AS volume_id_21, m0_.page_id AS page_id_22, m0_.action_id AS action_id_23, m0_.mentioned_source_id AS mentioned_source_id_24, m0_.info_source_id AS info_source_id_25, m0_.event_place_id AS event_place_id_26, m0_.secondary_mention_id AS secondary_mention_id_27, m0_.secondary_actor_id AS secondary_actor_id_28 FROM mentions m0_ INNER JOIN places p1_ ON m0_.place_id = p1_.id WHERE m0_.volume_id = ? AND m0_.place_id IS NOT NULL AND p1_.type <> ? AND p1_.type <> ?
Parameters:
[
  5
  1
  11
]

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\Volume 1
App\Entity\Series 1

Entities Mapping

Class Mapping errors
App\Entity\Place No 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\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\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\Institution No errors.
App\Entity\Page 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\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\Action No errors.