http://history.bk-entwicklungen.de/de/location/621

Query Metrics

4 Database Queries
3 Different statements
0.42 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.approved AS approved_5, t0.type AS type_6, t0.description AS description_7, t0.image AS image_8, t0.today_known_as AS today_known_as_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.owner_id AS owner_id_12, t0.update_of_id AS update_of_id_13, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_14 FROM location t0 WHERE t0.id = ?
Parameters:
[
  "621"
]
2 0.11 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.approved AS approved_4, t0.type AS type_5, t0.location_id AS location_id_6, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_7, t0.owner_id AS owner_id_8, t0.reference_id AS reference_id_9 FROM location_reference t0 WHERE t0.location_id = ?
Parameters:
[
  621
]
3 0.10 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.chapter AS chapter_3, t0.verse AS verse_4, t0.is_bible_ref AS is_bible_ref_5, t0.book_id AS book_id_6 FROM reference t0 WHERE t0.id = ?
Parameters:
[
  1003
]
4 0.08 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.chapter AS chapter_3, t0.verse AS verse_4, t0.is_bible_ref AS is_bible_ref_5, t0.book_id AS book_id_6 FROM reference t0 WHERE t0.id = ?
Parameters:
[
  1330
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#travelPaths refers to the owning side field App\Entity\TravelPath#user which does not exist.
App\Entity\Location
  • The association App\Entity\Location#taggedForDeleteBy refers to the inverse side field App\Entity\User#taggedDeleteLocations which does not exist.
App\Entity\Event No errors.
App\Entity\LocationReference No errors.
App\Entity\TravelPath
  • The association App\Entity\TravelPath#travelPathReferences refers to the owning side field App\Entity\TravelPathReference#travelpath which does not exist.
  • The mappings App\Entity\TravelPath#owner and App\Entity\User#travelPaths are inconsistent with each other.
App\Entity\Reference No errors.
App\Entity\BibleBooks No errors.