GET https://bibletimemaps.org/en/geoobject/list2

Response
200 OK
IP
216.73.216.24
Profiled on
Token
860f18

Query Metrics

25 Database Queries
4 Different statements
9.77 ms Query time
3 Invalid entities
61 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.65 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT g0_.id AS id_0, g0_.approved AS approved_1, g0_.start_year AS start_year_2, g0_.end_year AS end_year_3, g0_.name AS name_4, g0_.form_type AS form_type_5, g0_.geometry AS geometry_6, g0_.fill_color AS fill_color_7, g0_.label AS label_8, g0_.created_at AS created_at_9, g0_.updated_at AS updated_at_10 FROM geo_object g0_ WHERE g0_.approved > 0) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.85 ms 
SELECT DISTINCT id_0 FROM (SELECT g0_.id AS id_0, g0_.approved AS approved_1, g0_.start_year AS start_year_2, g0_.end_year AS end_year_3, g0_.name AS name_4, g0_.form_type AS form_type_5, g0_.geometry AS geometry_6, g0_.fill_color AS fill_color_7, g0_.label AS label_8, g0_.created_at AS created_at_9, g0_.updated_at AS updated_at_10 FROM geo_object g0_ WHERE g0_.approved > 0) dctrn_result LIMIT 50
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.80 ms 
SELECT g0_.id AS id_0, g0_.approved AS approved_1, g0_.start_year AS start_year_2, g0_.end_year AS end_year_3, g0_.name AS name_4, g0_.form_type AS form_type_5, g0_.geometry AS geometry_6, g0_.fill_color AS fill_color_7, g0_.label AS label_8, g0_.created_at AS created_at_9, g0_.updated_at AS updated_at_10, g0_.tagged_for_delete_by_id AS tagged_for_delete_by_id_11, g0_.start_event_id AS start_event_id_12, g0_.end_event_id AS end_event_id_13, g0_.owner_id AS owner_id_14, g0_.update_of_id AS update_of_id_15 FROM geo_object g0_ WHERE g0_.approved > 0 AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  2
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
]
View formatted query    View runnable query    Explain query
4 0.45 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: 
[
  32
]
View formatted query    View runnable query    Explain query
5 0.36 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: 
[
  16
]
View formatted query    View runnable query    Explain query
6 0.32 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: 
[
  1
]
View formatted query    View runnable query    Explain query
7 0.34 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: 
[
  51
]
View formatted query    View runnable query    Explain query
8 0.33 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: 
[
  236
]
View formatted query    View runnable query    Explain query
9 0.32 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: 
[
  69
]
View formatted query    View runnable query    Explain query
10 0.33 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: 
[
  53
]
View formatted query    View runnable query    Explain query
11 0.33 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: 
[
  74
]
View formatted query    View runnable query    Explain query
12 0.32 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: 
[
  219
]
View formatted query    View runnable query    Explain query
13 0.35 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: 
[
  232
]
View formatted query    View runnable query    Explain query
14 0.34 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: 
[
  237
]
View formatted query    View runnable query    Explain query
15 0.33 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: 
[
  70
]
View formatted query    View runnable query    Explain query
16 0.33 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: 
[
  213
]
View formatted query    View runnable query    Explain query
17 0.33 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: 
[
  208
]
View formatted query    View runnable query    Explain query
18 0.33 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: 
[
  206
]
View formatted query    View runnable query    Explain query
19 0.34 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: 
[
  39
]
View formatted query    View runnable query    Explain query
20 0.36 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: 
[
  55
]
View formatted query    View runnable query    Explain query
21 0.33 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: 
[
  62
]
View formatted query    View runnable query    Explain query
22 0.33 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: 
[
  89
]
View formatted query    View runnable query    Explain query
23 0.34 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: 
[
  270
]
View formatted query    View runnable query    Explain query
24 0.34 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: 
[
  273
]
View formatted query    View runnable query    Explain query
25 0.31 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: 
[
  3
]
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\Event 22
App\Entity\GeoObject 20
App\Entity\Location 16
App\Entity\User 3

Entities Mapping

Class Mapping errors
App\Entity\ChangeableEntity No errors.
App\Entity\GeoObject 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\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\Translation\EventTranslation No errors.