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_42,
  t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_43,
  t0.albums_display_configuration_id AS albums_display_configuration_id_44
FROM
  koi_user t0
WHERE
  t0.id = ?

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_42, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_43, t0.albums_display_configuration_id AS albums_display_configuration_id_44 FROM koi_user t0 WHERE t0.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_.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'
  )
  LEFT JOIN koi_collection k2_ ON k0_.collection_id = k2_.id
  AND (
    k2_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  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'
  )
WHERE
  (k0_.id = ?)
  AND (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
ORDER BY
  k1_.position ASC,
  k3_.label 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_.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') LEFT JOIN koi_collection k2_ ON k0_.collection_id = k2_.id AND (k2_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') 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') WHERE (k0_.id = '019c0887-d7d1-739a-8cf6-bdce0319d11f') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') ORDER BY k1_.position ASC, k3_.label ASC;

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_15
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_15 FROM koi_display_configuration t0 WHERE t0.id = '019c069c-1868-7713-85d0-acd2608a4f72' 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'
  )

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 = '019c069c-1868-75d3-85d0-acd25fad1f31') AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253');

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_13,
  t0.parent_id AS parent_id_14,
  t0.owner_id AS owner_id_15,
  t0.items_display_configuration_id AS items_display_configuration_id_16,
  t0.items_default_template_id AS items_default_template_id_17
FROM
  koi_collection t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
  )

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_13, t0.parent_id AS parent_id_14, t0.owner_id AS owner_id_15, t0.items_display_configuration_id AS items_display_configuration_id_16, t0.items_default_template_id AS items_default_template_id_17 FROM koi_collection t0 WHERE t0.id = '019c0688-c713-75a5-978b-4985aad181ea' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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_10,
  t0.category_id AS category_id_11,
  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_19,
  t0.items_display_configuration_id AS items_display_configuration_id_20
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'
    )
  )

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_10, t0.category_id AS category_id_11, 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_19, t0.items_display_configuration_id AS items_display_configuration_id_20 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 ('Activision Blizzard', 'Xbox One', '2018-06-29', '5030917236617', 'nein') AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'));

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_14,
  t0.owner_id AS owner_id_15
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'
    )
  )
ORDER BY
  t0.name ASC

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_14, t0.owner_id AS owner_id_15 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 = '019c0887-d7d1-739a-8cf6-bdce0319d11f' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253')) ORDER BY t0.name ASC;

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_14,
  t0.owner_id AS owner_id_15
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'
    )
  )
ORDER BY
  t0.name ASC

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_14, t0.owner_id AS owner_id_15 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 = '019c0887-d7d1-739a-8cf6-bdce0319d11f' AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253')) ORDER BY t0.name ASC;

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

UPDATE koi_item SET seen_counter = seen_counter + 1 WHERE id = '019c0887-d7d1-739a-8cf6-bdce0319d11f';