GET https://games.tenorweb.de/user/FieserOstfriese/items/019c09f8-e4a3-72ae-bf36-61c5e216bf8b

Response
200 OK
IP
216.73.216.40
Profiled on
Token
f0e099

Query Metrics

17 Database Queries
10 Different statements
14.45 ms Query time
0 Invalid entities
96 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.08 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.enabled AS enabled_6, t0.roles AS roles_7, t0.currency AS currency_8, t0.locale AS locale_9, t0.timezone AS timezone_10, t0.date_format AS date_format_11, t0.disk_space_allowed AS disk_space_allowed_12, t0.visibility AS visibility_13, t0.last_date_of_activity AS last_date_of_activity_14, t0.theme AS theme_15, t0.wishlists_feature_enabled AS wishlists_feature_enabled_16, t0.tags_feature_enabled AS tags_feature_enabled_17, t0.signs_feature_enabled AS signs_feature_enabled_18, t0.albums_feature_enabled AS albums_feature_enabled_19, t0.loans_feature_enabled AS loans_feature_enabled_20, t0.templates_feature_enabled AS templates_feature_enabled_21, t0.history_feature_enabled AS history_feature_enabled_22, t0.statistics_feature_enabled AS statistics_feature_enabled_23, t0.scraping_feature_enabled AS scraping_feature_enabled_24, t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25, t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26, t0.search_results_display_mode AS search_results_display_mode_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.collections_display_configuration_id AS collections_display_configuration_id_45, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_46, t0.albums_display_configuration_id AS albums_display_configuration_id_47 FROM koi_user t0 WHERE t0.username = ? AND ((t0.id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.visibility = 'public')) LIMIT 1
Parameters: 
[
  "FieserOstfriese"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.17 ms 
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.quantity AS quantity_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.image_large_thumbnail AS image_large_thumbnail_5, k0_.seen_counter AS seen_counter_6, k0_.visibility AS visibility_7, k0_.parent_visibility AS parent_visibility_8, k0_.final_visibility AS final_visibility_9, k0_.scraped_from_url AS scraped_from_url_10, k0_.created_at AS created_at_11, k0_.updated_at AS updated_at_12, k1_.id AS id_13, k1_.type AS type_14, k1_.label AS label_15, k1_.value AS value_16, k1_.position AS position_17, k1_.currency AS currency_18, k1_.image AS image_19, k1_.image_small_thumbnail AS image_small_thumbnail_20, k1_.image_large_thumbnail AS image_large_thumbnail_21, k1_.file AS file_22, k1_.video AS video_23, k1_.original_filename AS original_filename_24, k1_.visibility AS visibility_25, k1_.parent_visibility AS parent_visibility_26, k1_.final_visibility AS final_visibility_27, k1_.created_at AS created_at_28, k1_.updated_at AS updated_at_29, k2_.id AS id_30, k2_.title AS title_31, k2_.color AS color_32, k2_.image AS image_33, k2_.seen_counter AS seen_counter_34, k2_.cached_values AS cached_values_35, k2_.visibility AS visibility_36, k2_.parent_visibility AS parent_visibility_37, k2_.final_visibility AS final_visibility_38, k2_.scraped_from_url AS scraped_from_url_39, k2_.created_at AS created_at_40, k2_.updated_at AS updated_at_41, k3_.id AS id_42, k3_.label AS label_43, k3_.description AS description_44, k3_.image AS image_45, k3_.image_small_thumbnail AS image_small_thumbnail_46, k3_.seen_counter AS seen_counter_47, k3_.visibility AS visibility_48, k3_.created_at AS created_at_49, k3_.updated_at AS updated_at_50, k0_.collection_id AS collection_id_51, k0_.owner_id AS owner_id_52, k1_.item_id AS item_id_53, k1_.collection_id AS collection_id_54, k1_.choice_list_id AS choice_list_id_55, k1_.owner_id AS owner_id_56, k2_.children_display_configuration_id AS children_display_configuration_id_57, k2_.parent_id AS parent_id_58, k2_.owner_id AS owner_id_59, k2_.items_display_configuration_id AS items_display_configuration_id_60, k2_.items_default_template_id AS items_default_template_id_61, k3_.owner_id AS owner_id_62, k3_.category_id AS category_id_63, k3_.items_display_configuration_id AS items_display_configuration_id_64 FROM koi_item k0_ LEFT JOIN koi_datum k1_ ON k0_.id = k1_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.final_visibility = 'public') LEFT JOIN koi_collection k2_ ON k0_.collection_id = k2_.id AND (k2_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k2_.final_visibility = 'public') LEFT JOIN koi_item_tag k4_ ON k0_.id = k4_.item_id LEFT JOIN koi_tag k3_ ON k3_.id = k4_.tag_id AND (k3_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k3_.visibility = 'public') WHERE (k0_.id = ?) AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k1_.position ASC, k3_.label ASC
Parameters: 
[
  "019c09f8-e4a3-72ae-bf36-61c5e216bf8b"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.62 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_20 FROM koi_display_configuration t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c0990-6d56-7466-a5c4-1d7d7bdb3163"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.03 ms 
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.quantity AS quantity_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.image_large_thumbnail AS image_large_thumbnail_5, k0_.seen_counter AS seen_counter_6, k0_.visibility AS visibility_7, k0_.parent_visibility AS parent_visibility_8, k0_.final_visibility AS final_visibility_9, k0_.scraped_from_url AS scraped_from_url_10, k0_.created_at AS created_at_11, k0_.updated_at AS updated_at_12, k1_.id AS id_13, k1_.lent_to AS lent_to_14, k1_.lent_at AS lent_at_15, k1_.returned_at AS returned_at_16, k2_.id AS id_17, k2_.type AS type_18, k2_.label AS label_19, k2_.value AS value_20, k2_.position AS position_21, k2_.currency AS currency_22, k2_.image AS image_23, k2_.image_small_thumbnail AS image_small_thumbnail_24, k2_.image_large_thumbnail AS image_large_thumbnail_25, k2_.file AS file_26, k2_.video AS video_27, k2_.original_filename AS original_filename_28, k2_.visibility AS visibility_29, k2_.parent_visibility AS parent_visibility_30, k2_.final_visibility AS final_visibility_31, k2_.created_at AS created_at_32, k2_.updated_at AS updated_at_33, k0_.collection_id AS collection_id_34, k0_.owner_id AS owner_id_35, k1_.item_id AS item_id_36, k1_.owner_id AS owner_id_37, k2_.item_id AS item_id_38, k2_.collection_id AS collection_id_39, k2_.choice_list_id AS choice_list_id_40, k2_.owner_id AS owner_id_41 FROM koi_item k0_ LEFT JOIN koi_loan k1_ ON k0_.id = k1_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.returned_at IS NULL) LEFT JOIN koi_datum k2_ ON k0_.id = k2_.item_id AND (k2_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k2_.final_visibility = 'public') AND (k2_.label IN (?, ?, ?, ?) OR k2_.id IS NULL) WHERE (k0_.collection_id = ?) AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k2_.position ASC
Parameters: 
[
  "Plattform"
  "Medium"
  "Erscheinungsdatum"
  "USK/FSK"
  "019c0990-6d56-72c6-a5c4-1d7d7ac92a62"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.69 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_28, t0.parent_id AS parent_id_29, t0.owner_id AS owner_id_30, t0.items_display_configuration_id AS items_display_configuration_id_31, t0.items_default_template_id AS items_default_template_id_32 FROM koi_collection t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'))
Parameters: 
[
  "019c0a25-34d5-7028-9417-c1fa47fbe03d"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.89 ms 
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.image AS image_4, t0.image_small_thumbnail AS image_small_thumbnail_5, t0.seen_counter AS seen_counter_6, t0.visibility AS visibility_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.owner_id AS owner_id_29, t0.category_id AS category_id_30, t12.id AS id_13, t12.label AS label_14, t12.description AS description_15, t12.color AS color_16, t12.created_at AS created_at_17, t12.updated_at AS updated_at_18, t12.owner_id AS owner_id_31, t0.items_display_configuration_id AS items_display_configuration_id_32 FROM koi_tag t0 LEFT JOIN koi_tag_category t12 ON t0.category_id = t12.id AND ((t12.owner_id = '019c0687-41d4-74e8-8215-d23474287253')) WHERE t0.label IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.visibility = 'public'))
Parameters: 
[
  "Rollenspiel"
  "Japanese-Style"
  "Ghostlight"
  "Ltd."
  "Atlus"
  "PAL"
  "Playstation 2"
  "nein"
  "deutsch"
  "2005-07-01"
  "5036675005359"
  "SLES-53363"
  "nein"
  "DVD"
  "1"
  "18"
  "Schenkung"
  "Das Spiel ist angesiedelt im post-apokalyptischen Tokio. Fast die gesamte Menschheit wurde von einer globalen Katastrophe namens Die Empfängnis ausgelöscht. Jetzt fallen die dämonischen Streitkräfte in die Welt ein. Das Schicksal des Planeten lastet auf den Schultern eines einzigen Jungen"
  "der die dämonische Invasion bekämpfen und dadurch die Erde vor ihrer Zerstörung retten muss. Der junge Held wird im Spiel mehr als einhundert verschiedene Dämonen treffen und kann aus diesen das beste und mächtigste Team zusammenstellen. Diese Dämonen können zudem miteinander verschmolzen werden"
  "um neue Dämonen-Spezies zu erschaffen."
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.51 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c090a-a6e0-7750-bbb6-190c4a1ff9f9"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.47 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c0898-4858-7b18-9e12-b848c9319a9f"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.46 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08f6-955c-793f-91d1-c1846386e293"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.50 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08eb-9f03-7ee2-b9ee-aa3be0c05396"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.48 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08d1-9d6b-738b-aed5-23ee1ca129f0"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.47 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08db-b50d-774f-9846-595ca581c021"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.44 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08e8-1c8c-718b-b342-36f7460cc4fe"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.46 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_9 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))
Parameters: 
[
  "019c08d6-c274-7c26-a447-c1b9baeddde4"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.70 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.image AS image_4, t0.image_small_thumbnail AS image_small_thumbnail_5, t0.image_large_thumbnail AS image_large_thumbnail_6, t0.seen_counter AS seen_counter_7, t0.visibility AS visibility_8, t0.parent_visibility AS parent_visibility_9, t0.final_visibility AS final_visibility_10, t0.scraped_from_url AS scraped_from_url_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.collection_id AS collection_id_20, t0.owner_id AS owner_id_21 FROM koi_item t0 INNER JOIN koi_item_related_item ON t0.id = koi_item_related_item.related_item_id WHERE koi_item_related_item.item_id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.name ASC
Parameters: 
[
  "019c09f8-e4a3-72ae-bf36-61c5e216bf8b"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.70 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.image AS image_4, t0.image_small_thumbnail AS image_small_thumbnail_5, t0.image_large_thumbnail AS image_large_thumbnail_6, t0.seen_counter AS seen_counter_7, t0.visibility AS visibility_8, t0.parent_visibility AS parent_visibility_9, t0.final_visibility AS final_visibility_10, t0.scraped_from_url AS scraped_from_url_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.collection_id AS collection_id_20, t0.owner_id AS owner_id_21 FROM koi_item t0 INNER JOIN koi_item_related_item ON t0.id = koi_item_related_item.item_id WHERE koi_item_related_item.related_item_id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.name ASC
Parameters: 
[
  "019c09f8-e4a3-72ae-bf36-61c5e216bf8b"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.77 ms 
UPDATE koi_item SET seen_counter = seen_counter + 1 WHERE id = ?
Parameters: 
[
  "019c09f8-e4a3-72ae-bf36-61c5e216bf8b"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Datum 64
App\Entity\Item 13
App\Entity\ChoiceList 8
App\Entity\DisplayConfiguration 7
App\Entity\Collection 2
App\Entity\User 1
App\Entity\Template 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Configuration No errors.
App\Entity\DisplayConfiguration No errors.
App\Entity\Collection No errors.
App\Entity\Tag No errors.
App\Entity\TagCategory No errors.
App\Entity\Wishlist No errors.
App\Entity\Template No errors.
App\Entity\Log No errors.
App\Entity\Album No errors.
App\Entity\Inventory No errors.
App\Entity\Scraper No errors.
App\Entity\ChoiceList No errors.
App\Entity\Search No errors.
App\Entity\Item No errors.
App\Entity\Datum No errors.
App\Entity\Wish No errors.
App\Entity\Field No errors.
App\Entity\Photo No errors.
App\Entity\Path No errors.
App\Entity\SearchBlock No errors.
App\Entity\Loan No errors.
App\Entity\SearchFilter No errors.