GET https://mining.dighist.se/autocomplete/place?term=Gui

Query Metrics

3 Database Queries
2 Different statements
0.74 ms Query time
2 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.53 ms
(71.23%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.lat AS lat_2, p0_.lng AS lng_3, p0_.alt_names AS alt_names_4, p0_.alvin_id AS alvin_id_5, p0_.type AS type_6, p0_.approximate_location AS approximate_location_7, p0_.location_precision AS location_precision_8, p0_.description AS description_9, p0_.wikidata_id AS wikidata_id_10, p0_.mindat_id AS mindat_id_11, p0_.updated_at AS updated_at_12, p0_.parent_id AS parent_id_13 FROM places p0_ WHERE p0_.name LIKE ?
Parameters:
[
  "%Gui%"
]
0.21 ms
(28.77%)
2
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:
[
  59
]

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 5

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.