Symfony Profiler

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 = '019c0a25-34d5-71e4-9417-c1fa48ae981d' 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,
  k0_.collection_id AS collection_id_17,
  k0_.owner_id AS owner_id_18,
  k1_.item_id AS item_id_19,
  k1_.owner_id AS owner_id_20
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)
WHERE
  (k0_.collection_id = ?)
  AND (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k0_.final_visibility = 'public')

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, k0_.collection_id AS collection_id_17, k0_.owner_id AS owner_id_18, k1_.item_id AS item_id_19, k1_.owner_id AS owner_id_20 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) WHERE (k0_.collection_id = '019c0a25-34d5-7028-9417-c1fa47fbe03d') 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 = ?)
  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 = '019c0a25-34d5-7028-9417-c1fa47fbe03d') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public');

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

UPDATE koi_collection SET seen_counter = seen_counter + 1 WHERE id = '019c0a25-34d5-7028-9417-c1fa47fbe03d';

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')
  )

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 = '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.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.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.visibility = 'public')) LIMIT 1;

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 = '019c0a25-34d5-7028-9417-c1fa47fbe03d' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.position ASC;