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

Query Metrics

3 Database Queries
3 Different statements
0.77 ms Query time
5 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 ms
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:
[
  "%lux%"
]
2 0.15 ms
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:
[
  428
]
3 0.10 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.surname AS surname_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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 3
App\Entity\User 1

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.
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\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\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.