Symfony Profiler

SELECT
  COUNT(*)
FROM
  koi_item t0
WHERE
  (
    (
      t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
    )
    AND (t0.final_visibility = 'public')
  )

SELECT COUNT(*) FROM koi_item t0 WHERE ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'));

SELECT
  count(DISTINCT k0_.id) AS sclr_0
FROM
  koi_tag k0_
  INNER JOIN koi_item_tag k2_ ON k0_.id = k2_.tag_id
  INNER JOIN koi_item k1_ ON k1_.id = k2_.item_id
  AND (
    k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k1_.final_visibility = 'public')
WHERE
  (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k0_.visibility = 'public')
HAVING
  count(k1_.id) > 1

SELECT count(DISTINCT k0_.id) AS sclr_0 FROM koi_tag k0_ INNER JOIN koi_item_tag k2_ ON k0_.id = k2_.tag_id INNER JOIN koi_item k1_ ON k1_.id = k2_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.final_visibility = 'public') WHERE (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.visibility = 'public') HAVING count(k1_.id) > 1;

SELECT
  DISTINCT k0_.id AS id_0,
  k0_.label AS label_1,
  k0_.description AS description_2,
  k0_.image AS image_3,
  k0_.image_small_thumbnail AS image_small_thumbnail_4,
  k0_.seen_counter AS seen_counter_5,
  k0_.visibility AS visibility_6,
  k0_.created_at AS created_at_7,
  k0_.updated_at AS updated_at_8,
  count(DISTINCT k1_.id) AS sclr_9,
  (
    count(DISTINCT k1_.id) * 100.0 / ?
  ) AS sclr_10,
  k0_.owner_id AS owner_id_11,
  k0_.category_id AS category_id_12,
  k0_.items_display_configuration_id AS items_display_configuration_id_13
FROM
  koi_tag k0_
  LEFT JOIN koi_item_tag k2_ ON k0_.id = k2_.tag_id
  LEFT JOIN koi_item k1_ ON k1_.id = k2_.item_id
  AND (
    k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k1_.final_visibility = 'public')
WHERE
  (
    k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253'
  )
  AND (k0_.visibility = 'public')
GROUP BY
  k0_.id
HAVING
  count(k1_.id) > 0
ORDER BY
  sclr_9 DESC,
  k0_.label ASC
LIMIT
  15

SELECT DISTINCT k0_.id AS id_0, k0_.label AS label_1, k0_.description AS description_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.seen_counter AS seen_counter_5, k0_.visibility AS visibility_6, k0_.created_at AS created_at_7, k0_.updated_at AS updated_at_8, count(DISTINCT k1_.id) AS sclr_9, (count(DISTINCT k1_.id) * 100.0 / 41) AS sclr_10, k0_.owner_id AS owner_id_11, k0_.category_id AS category_id_12, k0_.items_display_configuration_id AS items_display_configuration_id_13 FROM koi_tag k0_ LEFT JOIN koi_item_tag k2_ ON k0_.id = k2_.tag_id LEFT JOIN koi_item k1_ ON k1_.id = k2_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.final_visibility = 'public') WHERE (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.visibility = 'public') GROUP BY k0_.id HAVING count(k1_.id) > 0 ORDER BY sclr_9 DESC, k0_.label ASC LIMIT 15;

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;