GET https://bibletimemaps.org/de/person/2189

Query Metrics

7 Database Queries
7 Different statements
3.52 ms Query time
3 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.02 ms
(28.95%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.person_id AS person_id_3, t0.version_id AS version_id_4 FROM person_version t0 WHERE t0.person_id = ?
Parameters:
[
  2189
]
0.61 ms
(17.26%)
1
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.name AS name_3, t0.born AS born_4, t0.died AS died_5, t0.born_estimated AS born_estimated_6, t0.died_estimated AS died_estimated_7, t0.gender AS gender_8, t0.alternate_names AS alternate_names_9, t0.url AS url_10, t0.image AS image_11, t0.is_abstract AS is_abstract_12, t0.leaf_start AS leaf_start_13, t0.leaf_out AS leaf_out_14, t0.leaf_level AS leaf_level_15, t0.born_calculated AS born_calculated_16, t0.died_calculated AS died_calculated_17, t0.born_at_father_age AS born_at_father_age_18, t0.description AS description_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_22, t0.folk_id AS folk_id_23, t0.owner_id AS owner_id_24, t0.lived_at_time_of_person_id AS lived_at_time_of_person_id_25, t0.update_of_id AS update_of_id_26 FROM person t0 WHERE t0.id = ?
Parameters:
[
  "2189"
]
0.58 ms
(16.52%)
1
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.child_id = ?
Parameters:
[
  2189
]
0.40 ms
(11.43%)
1
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6, t0.owner_id AS owner_id_7, t0.reference_id AS reference_id_8, t0.person_id AS person_id_9 FROM person_reference t0 WHERE t0.person_id = ?
Parameters:
[
  2189
]
0.33 ms
(9.42%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.approved AS approved_5, t0.type AS type_6, t0.died AS died_7, t0.father_folk_id AS father_folk_id_8 FROM folk t0 INNER JOIN person_folk ON t0.id = person_folk.folk_id WHERE person_folk.person_id = ?
Parameters:
[
  2189
]
0.29 ms
(8.33%)
1
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.parent_id AS parent_id_3, t0.child_id AS child_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM person_link t0 WHERE t0.parent_id = ?
Parameters:
[
  2189
]
0.28 ms
(8.10%)
1
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:
[
  2529
]

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\Person 1
App\Entity\PersonVersion 1
App\Entity\BibleVersion 1
App\Entity\PersonReference 1
App\Entity\Reference 1
App\Entity\BibleBooks 1

Entities Mapping

Class Mapping errors
App\Entity\ChangeableEntity No errors.
App\Entity\Person No errors.
App\Entity\User
  • The mappings App\Entity\User#taggedEventsForDelete and App\Entity\Event#taggedForDeleteBy are inconsistent with each other.
App\Entity\Folk No errors.
App\Entity\EventPerson No errors.
App\Entity\Traits\BaseReference
  • The mappings App\Entity\Traits\BaseReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\PersonReference
  • The mappings App\Entity\PersonReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\Job No errors.
App\Entity\PersonLink No errors.
App\Entity\PersonVersion No errors.
App\Entity\Translation\PersonTranslation No errors.
App\Entity\BibleVersion No errors.
App\Entity\Reference No errors.
App\Entity\BibleBooks No errors.