GET https://bibletimemaps.org/de/event/725

Query Metrics

8 Database Queries
7 Different statements
5.37 ms Query time
4 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 1.56 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.year AS year_3, t0.name AS name_4, t0.image AS image_5, t0.year_calculated AS year_calculated_6, t0.year_estimated AS year_estimated_7, t0.event_source AS event_source_8, t0.hide AS hide_9, t0.relative_time AS relative_time_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_13, t0.location_id AS location_id_14, t0.owner_id AS owner_id_15, t16.id AS id_17, t16.created_at AS created_at_18, t16.updated_at AS updated_at_19, t16.event_one_id AS event_one_id_20, t16.event_two_id AS event_two_id_21, t16.owner_id AS owner_id_22, t23.id AS id_24, t23.created_at AS created_at_25, t23.updated_at AS updated_at_26, t23.event_one_id AS event_one_id_27, t23.event_two_id AS event_two_id_28, t23.owner_id AS owner_id_29, t0.update_of_id AS update_of_id_30 FROM event t0 LEFT JOIN event_swap t16 ON t16.event_one_id = t0.id LEFT JOIN event_swap t23 ON t23.event_two_id = t0.id WHERE t0.id = ?
Parameters:
[
  "725"
]
2 0.54 ms
SELECT t0.id AS id_1, t0.order_index AS order_index_2, t0.link_from_id AS link_from_id_3, t0.link_to_id AS link_to_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM event_link t0 WHERE t0.link_to_id = ?
Parameters:
[
  725
]
3 0.33 ms
SELECT t0.id AS id_1, t0.order_index AS order_index_2, t0.link_from_id AS link_from_id_3, t0.link_to_id AS link_to_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM event_link t0 WHERE t0.link_from_id = ?
Parameters:
[
  725
]
4 0.63 ms
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.event_id AS event_id_9 FROM event_reference t0 WHERE t0.event_id = ?
Parameters:
[
  725
]
5 0.66 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:
[
  3479
]
6 0.72 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.event_id AS event_id_3, t0.person_id AS person_id_4, t0.owner_id AS owner_id_5, t0.tagged_for_delete_by_id AS tagged_for_delete_by_id_6 FROM event_person t0 WHERE t0.event_id = ?
Parameters:
[
  725
]
7 0.48 ms
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:
[
  3189
]
8 0.45 ms
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:
[
  4339
]

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\Event 3
App\Entity\EventLink 2
App\Entity\EventPerson 2
App\Entity\Person 2
App\Entity\EventReference 1
App\Entity\Reference 1
App\Entity\BibleBooks 1

Entities Mapping

Class Mapping errors
App\Entity\ChangeableEntity No errors.
App\Entity\Event No errors.
App\Entity\User
  • The mappings App\Entity\User#taggedEventsForDelete and App\Entity\Event#taggedForDeleteBy are inconsistent with each other.
App\Entity\Location No errors.
App\Entity\EventSwap 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\EventReference
  • The mappings App\Entity\EventReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\EventLink No errors.
App\Entity\TravelPath No errors.
App\Entity\GeoObject No errors.
App\Entity\Translation\EventTranslation No errors.
App\Entity\Reference No errors.
App\Entity\BibleBooks No errors.
App\Entity\Person No errors.
App\Entity\Folk No errors.
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.