Symfony Profiler

SELECT
  (
    SELECT
      COUNT(*)
    FROM
      koi_collection
    WHERE
      owner_id = ?
  ) AS collections,
  (
    SELECT
      COUNT(*)
    FROM
      koi_item
    WHERE
      owner_id = ?
  ) AS items,
  (
    SELECT
      COUNT(*)
    FROM
      koi_tag
    WHERE
      owner_id = ?
  ) AS tags,
  (
    SELECT
      COUNT(*)
    FROM
      koi_datum d
      LEFT JOIN koi_item i ON i.id = d.item_id
    WHERE
      i.owner_id = ?
      AND d.type = ?
  ) AS signs
FROM
  koi_user u
WHERE
  u.id = ?

SELECT (SELECT COUNT(*) FROM koi_collection WHERE owner_id = '019c0687-41d4-74e8-8215-d23474287253') AS collections, (SELECT COUNT(*) FROM koi_item WHERE owner_id = '019c0687-41d4-74e8-8215-d23474287253') AS items, (SELECT COUNT(*) FROM koi_tag WHERE owner_id = '019c0687-41d4-74e8-8215-d23474287253') AS tags, (SELECT COUNT(*) FROM koi_datum d LEFT JOIN koi_item i ON i.id = d.item_id WHERE i.owner_id = '019c0687-41d4-74e8-8215-d23474287253' AND d.type = 'sign') AS signs FROM koi_user u WHERE u.id = '019c0687-41d4-74e8-8215-d23474287253';

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

SELECT
  created_at AS date
FROM
  koi_item
WHERE
  owner_id = ?

SELECT created_at AS date FROM koi_item WHERE 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,
  k1_.id AS id_12,
  k1_.title AS title_13,
  k1_.color AS color_14,
  k1_.image AS image_15,
  k1_.seen_counter AS seen_counter_16,
  k1_.cached_values AS cached_values_17,
  k1_.visibility AS visibility_18,
  k1_.parent_visibility AS parent_visibility_19,
  k1_.final_visibility AS final_visibility_20,
  k1_.scraped_from_url AS scraped_from_url_21,
  k1_.created_at AS created_at_22,
  k1_.updated_at AS updated_at_23,
  k0_.children_display_configuration_id AS children_display_configuration_id_24,
  k0_.parent_id AS parent_id_25,
  k0_.owner_id AS owner_id_26,
  k0_.items_display_configuration_id AS items_display_configuration_id_27,
  k0_.items_default_template_id AS items_default_template_id_28,
  k1_.children_display_configuration_id AS children_display_configuration_id_29,
  k1_.parent_id AS parent_id_30,
  k1_.owner_id AS owner_id_31,
  k1_.items_display_configuration_id AS items_display_configuration_id_32,
  k1_.items_default_template_id AS items_default_template_id_33
FROM
  koi_collection k0_
  LEFT JOIN koi_collection k1_ ON k0_.id = k1_.parent_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_.final_visibility = 'public')
ORDER BY
  k0_.title ASC,
  k1_.title ASC

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, k1_.id AS id_12, k1_.title AS title_13, k1_.color AS color_14, k1_.image AS image_15, k1_.seen_counter AS seen_counter_16, k1_.cached_values AS cached_values_17, k1_.visibility AS visibility_18, k1_.parent_visibility AS parent_visibility_19, k1_.final_visibility AS final_visibility_20, k1_.scraped_from_url AS scraped_from_url_21, k1_.created_at AS created_at_22, k1_.updated_at AS updated_at_23, k0_.children_display_configuration_id AS children_display_configuration_id_24, k0_.parent_id AS parent_id_25, k0_.owner_id AS owner_id_26, k0_.items_display_configuration_id AS items_display_configuration_id_27, k0_.items_default_template_id AS items_default_template_id_28, k1_.children_display_configuration_id AS children_display_configuration_id_29, k1_.parent_id AS parent_id_30, k1_.owner_id AS owner_id_31, k1_.items_display_configuration_id AS items_display_configuration_id_32, k1_.items_default_template_id AS items_default_template_id_33 FROM koi_collection k0_ LEFT JOIN koi_collection k1_ ON k0_.id = k1_.parent_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_.final_visibility = 'public') ORDER BY k0_.title ASC, k1_.title ASC;

SELECT
  created_at as date
FROM
  koi_item
WHERE
  owner_id = ?

SELECT created_at as date FROM koi_item WHERE owner_id = '019c0687-41d4-74e8-8215-d23474287253';

SELECT
  logged_at AS date,
  type
FROM
  koi_log
WHERE
  owner_id = ?
  AND object_class = ?
  AND type IN (?, ?)
ORDER BY
  date

SELECT logged_at AS date, type FROM koi_log WHERE owner_id = '019c0687-41d4-74e8-8215-d23474287253' AND object_class = 'App\\Entity\\Item' AND type IN ('create', 'delete') ORDER BY date;