GET https://bibletimemaps.org/es/event/153

Query Metrics

7 Database Queries
7 Different statements
3.97 ms Query time
5 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.91 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:
[
  "153"
]
2 0.83 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:
[
  153
]
3 0.36 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:
[
  153
]
4 0.39 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.name AS name_3, t0.lat AS lat_4, t0.lon AS lon_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.coordinate_source AS coordinate_source_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.owner_id AS owner_id_14, t0.update_of_id AS update_of_id_15 FROM location t0 WHERE t0.id = ?
Parameters:
[
  14
]
5 0.45 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:
[
  153
]
6 0.59 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:
[
  153
]
7 0.43 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:
[
  1245
]

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\Location 1
App\Entity\User 1
App\Entity\EventReference 1
App\Entity\Reference 1
App\Entity\EventPerson 1
App\Entity\Person 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\LocationReference
  • The mappings App\Entity\LocationReference#owner and App\Entity\User#checks are inconsistent with each other.
App\Entity\Translation\LocationTranslation No errors.
App\Entity\Reference 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.