GET https://mining.dighist.se/json/place/overlay/820

Query Metrics

2 Database Queries
2 Different statements
0.36 ms Query time
2 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.23 ms
(62.78%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = ?
Parameters:
[
  "820"
]
0.13 ms
(37.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.place_id AS place_id_4 FROM map_overlays t0 WHERE t0.place_id = ?
Parameters:
[
  820
]

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\Place 2

Entities Mapping

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