GET https://bibletimemaps.org/es/location/409

Response
200 OK
IP
216.73.216.24
Profiled on
Token
3b24b9

Query Metrics

29 Database Queries
3 Different statements
9.95 ms Query time
3 Invalid entities
59 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.70 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: 
[
  "409"
]
View formatted query    View runnable query    Explain query
2 1.09 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.location_id AS location_id_9 FROM location_reference t0 WHERE t0.location_id = ?
Parameters: 
[
  409
]
View formatted query    View runnable query    Explain query
3 0.95 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: 
[
  1126
]
View formatted query    View runnable query    Explain query
4 0.69 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: 
[
  1127
]
View formatted query    View runnable query    Explain query
5 0.37 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: 
[
  1128
]
View formatted query    View runnable query    Explain query
6 0.28 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: 
[
  1129
]
View formatted query    View runnable query    Explain query
7 0.25 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: 
[
  1130
]
View formatted query    View runnable query    Explain query
8 0.26 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: 
[
  1131
]
View formatted query    View runnable query    Explain query
9 0.25 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: 
[
  1132
]
View formatted query    View runnable query    Explain query
10 0.24 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: 
[
  1133
]
View formatted query    View runnable query    Explain query
11 0.26 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: 
[
  1134
]
View formatted query    View runnable query    Explain query
12 0.27 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: 
[
  1135
]
View formatted query    View runnable query    Explain query
13 0.27 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: 
[
  1136
]
View formatted query    View runnable query    Explain query
14 0.26 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: 
[
  1137
]
View formatted query    View runnable query    Explain query
15 0.24 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: 
[
  1138
]
View formatted query    View runnable query    Explain query
16 0.25 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: 
[
  1139
]
View formatted query    View runnable query    Explain query
17 0.24 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: 
[
  1140
]
View formatted query    View runnable query    Explain query
18 0.26 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: 
[
  1141
]
View formatted query    View runnable query    Explain query
19 0.29 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: 
[
  1142
]
View formatted query    View runnable query    Explain query
20 0.23 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: 
[
  1143
]
View formatted query    View runnable query    Explain query
21 0.25 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: 
[
  1144
]
View formatted query    View runnable query    Explain query
22 0.25 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: 
[
  1145
]
View formatted query    View runnable query    Explain query
23 0.27 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: 
[
  1146
]
View formatted query    View runnable query    Explain query
24 0.25 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: 
[
  1147
]
View formatted query    View runnable query    Explain query
25 0.23 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: 
[
  1148
]
View formatted query    View runnable query    Explain query
26 0.29 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: 
[
  1149
]
View formatted query    View runnable query    Explain query
27 0.25 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: 
[
  1150
]
View formatted query    View runnable query    Explain query
28 0.27 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: 
[
  1151
]
View formatted query    View runnable query    Explain query
29 0.26 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: 
[
  1152
]
View formatted query    View runnable query    Explain query

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\LocationReference 27
App\Entity\Reference 27
App\Entity\BibleBooks 4
App\Entity\Location 1

Entities Mapping

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