Query Metrics
5
Database Queries
3
Different statements
2.24 ms
Query time
3
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.51 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:
[
"555"
]
|
| 2 | 0.72 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:
[
555
]
|
| 3 | 0.34 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:
[
1288
]
|
| 4 | 0.32 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:
[
782
]
|
| 5 | 0.34 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:
[
1289
]
|
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 | 3 |
| App\Entity\Reference | 3 |
| App\Entity\BibleBooks | 2 |
| App\Entity\Location | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ChangeableEntity | No errors. |
| App\Entity\Location | No errors. |
| App\Entity\User |
|
| App\Entity\Event | No errors. |
| App\Entity\Traits\BaseReference |
|
| App\Entity\LocationReference |
|
| App\Entity\TravelPath | No errors. |
| App\Entity\Translation\LocationTranslation | No errors. |
| App\Entity\Reference | No errors. |
| App\Entity\BibleBooks | No errors. |