GET https://mining.dighist.ddnsfree.com/page/view/13934

Query Metrics

7 Database Queries
5 Different statements
3.29 ms Query time
5 Invalid entities
75 Managed entities

Queries

Group similar statements

# Time Info
1 0.27 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:
[
  "13934"
]
2 0.93 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:
[
  5
  6
]
3 0.54 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:
[
  5
  8
]
4 0.14 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:
[
  5
]
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:
[
  13934
]
6 0.74 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:
[
  46486
]
7 0.54 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:
[
  46487
]

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 68
App\Entity\Page 3
App\Entity\Region 2
App\Entity\Volume 1
App\Entity\Series 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.