Query Metrics
6
Database Queries
6
Different statements
2.67 ms
Query time
4
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.73 ms (27.37%) |
1 |
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:
[
274
]
|
|
0.67 ms (25.27%) |
1 |
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:
[
"274"
]
|
|
0.33 ms (12.26%) |
1 |
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:
[
124
]
|
|
0.32 ms (12.00%) |
1 |
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:
[
274
]
|
|
0.32 ms (11.89%) |
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.event_id AS event_id_9 FROM event_reference t0 WHERE t0.event_id = ?
Parameters:
[
274
]
|
|
0.30 ms (11.21%) |
1 |
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:
[
274
]
|
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 | 1 |
| App\Entity\Location | 1 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ChangeableEntity | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\User |
|
| App\Entity\Location | No errors. |
| App\Entity\EventSwap | No errors. |
| App\Entity\EventPerson | No errors. |
| App\Entity\Traits\BaseReference |
|
| App\Entity\EventReference |
|
| App\Entity\EventLink | No errors. |
| App\Entity\TravelPath | No errors. |
| App\Entity\GeoObject | No errors. |
| App\Entity\Translation\EventTranslation | No errors. |
| App\Entity\LocationReference |
|
| App\Entity\Translation\LocationTranslation | No errors. |
| App\Entity\Reference | No errors. |
| App\Entity\Person | No errors. |