Symfony Profiler

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_39,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_40,
  t0.albums_display_configuration_id AS albums_display_configuration_id_41
FROM
  koi_user t0
WHERE
  t0.username = ?
  AND (
    (
      t0.id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.visibility = 'public')
  )
LIMIT
  1

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_39, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_40, t0.albums_display_configuration_id AS albums_display_configuration_id_41 FROM koi_user t0 WHERE t0.username = 'FieserOstfriese' AND ((t0.id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.visibility = 'public')) LIMIT 1;

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_18,
  t0.parent_id AS parent_id_19,
  t0.owner_id AS owner_id_20,
  t0.items_display_configuration_id AS items_display_configuration_id_21,
  t0.items_default_template_id AS items_default_template_id_22
FROM
  koi_collection t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.final_visibility = 'public')
  )

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_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.id = '019c096c-a9da-7a7c-a64b-4b9ea73c82d0' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'));

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_16
FROM
  koi_display_configuration t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_16 FROM koi_display_configuration t0 WHERE t0.id = '019c096c-a9da-7ac8-a64b-4b9ea7c917e7' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

SELECT
  k0_.id AS id_0,
  k0_.title AS title_1,
  k0_.color AS color_2,
  k0_.image AS image_3,
  k0_.seen_counter AS seen_counter_4,
  k0_.cached_values AS cached_values_5,
  k0_.visibility AS visibility_6,
  k0_.parent_visibility AS parent_visibility_7,
  k0_.final_visibility AS final_visibility_8,
  k0_.scraped_from_url AS scraped_from_url_9,
  k0_.created_at AS created_at_10,
  k0_.updated_at AS updated_at_11,
  k0_.children_display_configuration_id AS children_display_configuration_id_12,
  k0_.parent_id AS parent_id_13,
  k0_.owner_id AS owner_id_14,
  k0_.items_display_configuration_id AS items_display_configuration_id_15,
  k0_.items_default_template_id AS items_default_template_id_16
FROM
  koi_collection k0_
WHERE
  (k0_.parent_id = ?)
  AND (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k0_.final_visibility = 'public')

SELECT k0_.id AS id_0, k0_.title AS title_1, k0_.color AS color_2, k0_.image AS image_3, k0_.seen_counter AS seen_counter_4, k0_.cached_values AS cached_values_5, k0_.visibility AS visibility_6, k0_.parent_visibility AS parent_visibility_7, k0_.final_visibility AS final_visibility_8, k0_.scraped_from_url AS scraped_from_url_9, k0_.created_at AS created_at_10, k0_.updated_at AS updated_at_11, k0_.children_display_configuration_id AS children_display_configuration_id_12, k0_.parent_id AS parent_id_13, k0_.owner_id AS owner_id_14, k0_.items_display_configuration_id AS items_display_configuration_id_15, k0_.items_default_template_id AS items_default_template_id_16 FROM koi_collection k0_ WHERE (k0_.parent_id = '019c096c-a9da-7a7c-a64b-4b9ea73c82d0') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public');

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_16
FROM
  koi_display_configuration t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_16 FROM koi_display_configuration t0 WHERE t0.id = '019c096c-a9da-7adc-a64b-4b9ea8a47757' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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

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 ('Sprache', 'USK/FSK', 'Erscheinungsdatum', 'Plattform', 'Medium') OR k2_.id IS NULL) WHERE (k0_.collection_id = '019c096c-a9da-7a7c-a64b-4b9ea73c82d0') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k2_.position ASC;

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_18,
  t0.parent_id AS parent_id_19,
  t0.owner_id AS owner_id_20,
  t0.items_display_configuration_id AS items_display_configuration_id_21,
  t0.items_default_template_id AS items_default_template_id_22
FROM
  koi_collection t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.final_visibility = 'public')
  )

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_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.id = '019c0a25-34d5-7028-9417-c1fa47fbe03d' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'));

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5,
  t0.currency AS currency_6,
  t0.image AS image_7,
  t0.image_small_thumbnail AS image_small_thumbnail_8,
  t0.image_large_thumbnail AS image_large_thumbnail_9,
  t0.file AS file_10,
  t0.video AS video_11,
  t0.original_filename AS original_filename_12,
  t0.visibility AS visibility_13,
  t0.parent_visibility AS parent_visibility_14,
  t0.final_visibility AS final_visibility_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.item_id AS item_id_22,
  t0.collection_id AS collection_id_23,
  t0.choice_list_id AS choice_list_id_24,
  t0.owner_id AS owner_id_25
FROM
  koi_datum t0
WHERE
  t0.collection_id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.final_visibility = 'public')
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5, t0.currency AS currency_6, t0.image AS image_7, t0.image_small_thumbnail AS image_small_thumbnail_8, t0.image_large_thumbnail AS image_large_thumbnail_9, t0.file AS file_10, t0.video AS video_11, t0.original_filename AS original_filename_12, t0.visibility AS visibility_13, t0.parent_visibility AS parent_visibility_14, t0.final_visibility AS final_visibility_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.item_id AS item_id_22, t0.collection_id AS collection_id_23, t0.choice_list_id AS choice_list_id_24, t0.owner_id AS owner_id_25 FROM koi_datum t0 WHERE t0.collection_id = '019c096c-a9da-7a7c-a64b-4b9ea73c82d0' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.position ASC;

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_7
FROM
  koi_choice_list t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_7 FROM koi_choice_list t0 WHERE t0.id = '019c08f6-955c-793f-91d1-c1846386e293' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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_7
FROM
  koi_choice_list t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_7 FROM koi_choice_list t0 WHERE t0.id = '019c08e8-1c8c-718b-b342-36f7460cc4fe' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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_7
FROM
  koi_choice_list t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_7 FROM koi_choice_list t0 WHERE t0.id = '019c0898-4858-7b18-9e12-b848c9319a9f' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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_7
FROM
  koi_choice_list t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_7 FROM koi_choice_list t0 WHERE t0.id = '019c08d1-9d6b-738b-aed5-23ee1ca129f0' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

UPDATE
  koi_collection
SET
  seen_counter = seen_counter + 1
WHERE
  id = ?

UPDATE koi_collection SET seen_counter = seen_counter + 1 WHERE id = '019c096c-a9da-7a7c-a64b-4b9ea73c82d0';