Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.default_locale AS default_locale_5,
  t0.locales AS locales_6,
  t0.disk AS disk_7,
  t0.public_api AS public_api_8,
  t0.storage_strategy AS storage_strategy_9,
  t0.settings AS settings_10,
  t0.jwt_access_ttl AS jwt_access_ttl_11,
  t0.jwt_refresh_ttl AS jwt_refresh_ttl_12,
  t0.preview_url AS preview_url_13,
  t0.preview_mode AS preview_mode_14,
  t0.preview_enabled AS preview_enabled_15
FROM
  project t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.default_locale AS default_locale_5, t0.locales AS locales_6, t0.disk AS disk_7, t0.public_api AS public_api_8, t0.storage_strategy AS storage_strategy_9, t0.settings AS settings_10, t0.jwt_access_ttl AS jwt_access_ttl_11, t0.jwt_refresh_ttl AS jwt_refresh_ttl_12, t0.preview_url AS preview_url_13, t0.preview_mode AS preview_mode_14, t0.preview_enabled AS preview_enabled_15 FROM project t0 WHERE t0.uuid = 0xFF5D0BB8BAD846D18BC00D6314B776B2 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.description AS description_4,
  c0_.is_singleton AS is_singleton_5,
  c0_.`order` AS order_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.settings AS settings_8,
  c0_.project_id AS project_id_9
FROM
  `collection` c0_
WHERE
  c0_.project_id = ?
  AND c0_.slug = ?
  AND c0_.deleted_at IS NULL

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.is_singleton AS is_singleton_5, c0_.`order` AS order_6, c0_.deleted_at AS deleted_at_7, c0_.settings AS settings_8, c0_.project_id AS project_id_9 FROM `collection` c0_ WHERE c0_.project_id = 4 AND c0_.slug = 'setting' AND c0_.deleted_at IS NULL;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_4
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.uuid AS uuid_1,
          c0_.locale AS locale_2,
          c0_.status AS status_3,
          c0_.created_at AS created_at_4,
          c0_.updated_at AS updated_at_5,
          c0_.deleted_at AS deleted_at_6,
          c0_.published_at AS published_at_7,
          c0_.scheduled_at AS scheduled_at_8,
          c0_.meta_title AS meta_title_9,
          c0_.meta_description AS meta_description_10,
          c0_.slug AS slug_11,
          c0_.canonical_url AS canonical_url_12,
          c0_.og_image AS og_image_13,
          c0_.seo_score AS seo_score_14,
          c0_.seo_scored_at AS seo_scored_at_15,
          c1_.id AS id_16,
          c1_.field_type AS field_type_17,
          c1_.text_value AS text_value_18,
          c1_.number_value AS number_value_19,
          c1_.boolean_value AS boolean_value_20,
          c1_.date_value AS date_value_21,
          c1_.datetime_value AS datetime_value_22,
          c1_.json_value AS json_value_23,
          u2_.id AS id_24,
          u2_.uuid AS uuid_25,
          u2_.email AS email_26,
          u2_.roles AS roles_27,
          u2_.password AS password_28,
          u2_.name AS name_29,
          u2_.locale AS locale_30,
          u2_.two_factor_enabled AS two_factor_enabled_31,
          u2_.two_factor_method AS two_factor_method_32,
          u2_.two_factor_secret AS two_factor_secret_33,
          u2_.two_factor_backup_codes AS two_factor_backup_codes_34,
          u2_.two_factor_confirmed_at AS two_factor_confirmed_at_35,
          u2_.google_id AS google_id_36,
          u2_.microsoft_id AS microsoft_id_37,
          u2_.github_id AS github_id_38,
          u2_.gitlab_id AS gitlab_id_39,
          u2_.oidc_sub AS oidc_sub_40,
          u2_.oidc_issuer AS oidc_issuer_41,
          u2_.created_at AS created_at_42,
          u3_.id AS id_43,
          u3_.uuid AS uuid_44,
          u3_.email AS email_45,
          u3_.roles AS roles_46,
          u3_.password AS password_47,
          u3_.name AS name_48,
          u3_.locale AS locale_49,
          u3_.two_factor_enabled AS two_factor_enabled_50,
          u3_.two_factor_method AS two_factor_method_51,
          u3_.two_factor_secret AS two_factor_secret_52,
          u3_.two_factor_backup_codes AS two_factor_backup_codes_53,
          u3_.two_factor_confirmed_at AS two_factor_confirmed_at_54,
          u3_.google_id AS google_id_55,
          u3_.microsoft_id AS microsoft_id_56,
          u3_.github_id AS github_id_57,
          u3_.gitlab_id AS gitlab_id_58,
          u3_.oidc_sub AS oidc_sub_59,
          u3_.oidc_issuer AS oidc_issuer_60,
          u3_.created_at AS created_at_61,
          u4_.id AS id_62,
          u4_.uuid AS uuid_63,
          u4_.email AS email_64,
          u4_.roles AS roles_65,
          u4_.password AS password_66,
          u4_.name AS name_67,
          u4_.locale AS locale_68,
          u4_.two_factor_enabled AS two_factor_enabled_69,
          u4_.two_factor_method AS two_factor_method_70,
          u4_.two_factor_secret AS two_factor_secret_71,
          u4_.two_factor_backup_codes AS two_factor_backup_codes_72,
          u4_.two_factor_confirmed_at AS two_factor_confirmed_at_73,
          u4_.google_id AS google_id_74,
          u4_.microsoft_id AS microsoft_id_75,
          u4_.github_id AS github_id_76,
          u4_.gitlab_id AS gitlab_id_77,
          u4_.oidc_sub AS oidc_sub_78,
          u4_.oidc_issuer AS oidc_issuer_79,
          u4_.created_at AS created_at_80
        FROM
          content_entry c0_
          LEFT JOIN content_field_value c1_ ON c0_.id = c1_.content_entry_id
          LEFT JOIN `user` u2_ ON c0_.created_by_id = u2_.id
          LEFT JOIN `user` u3_ ON c0_.updated_by_id = u3_.id
          LEFT JOIN `user` u4_ ON c0_.assigned_to_id = u4_.id
        WHERE
          c0_.collection_id = ?
          AND c0_.deleted_at IS NULL
          AND c0_.locale = ?
          AND c0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_4 DESC
  ) dctrn_result
LIMIT
  100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_4 FROM (SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.locale AS locale_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.deleted_at AS deleted_at_6, c0_.published_at AS published_at_7, c0_.scheduled_at AS scheduled_at_8, c0_.meta_title AS meta_title_9, c0_.meta_description AS meta_description_10, c0_.slug AS slug_11, c0_.canonical_url AS canonical_url_12, c0_.og_image AS og_image_13, c0_.seo_score AS seo_score_14, c0_.seo_scored_at AS seo_scored_at_15, c1_.id AS id_16, c1_.field_type AS field_type_17, c1_.text_value AS text_value_18, c1_.number_value AS number_value_19, c1_.boolean_value AS boolean_value_20, c1_.date_value AS date_value_21, c1_.datetime_value AS datetime_value_22, c1_.json_value AS json_value_23, u2_.id AS id_24, u2_.uuid AS uuid_25, u2_.email AS email_26, u2_.roles AS roles_27, u2_.password AS password_28, u2_.name AS name_29, u2_.locale AS locale_30, u2_.two_factor_enabled AS two_factor_enabled_31, u2_.two_factor_method AS two_factor_method_32, u2_.two_factor_secret AS two_factor_secret_33, u2_.two_factor_backup_codes AS two_factor_backup_codes_34, u2_.two_factor_confirmed_at AS two_factor_confirmed_at_35, u2_.google_id AS google_id_36, u2_.microsoft_id AS microsoft_id_37, u2_.github_id AS github_id_38, u2_.gitlab_id AS gitlab_id_39, u2_.oidc_sub AS oidc_sub_40, u2_.oidc_issuer AS oidc_issuer_41, u2_.created_at AS created_at_42, u3_.id AS id_43, u3_.uuid AS uuid_44, u3_.email AS email_45, u3_.roles AS roles_46, u3_.password AS password_47, u3_.name AS name_48, u3_.locale AS locale_49, u3_.two_factor_enabled AS two_factor_enabled_50, u3_.two_factor_method AS two_factor_method_51, u3_.two_factor_secret AS two_factor_secret_52, u3_.two_factor_backup_codes AS two_factor_backup_codes_53, u3_.two_factor_confirmed_at AS two_factor_confirmed_at_54, u3_.google_id AS google_id_55, u3_.microsoft_id AS microsoft_id_56, u3_.github_id AS github_id_57, u3_.gitlab_id AS gitlab_id_58, u3_.oidc_sub AS oidc_sub_59, u3_.oidc_issuer AS oidc_issuer_60, u3_.created_at AS created_at_61, u4_.id AS id_62, u4_.uuid AS uuid_63, u4_.email AS email_64, u4_.roles AS roles_65, u4_.password AS password_66, u4_.name AS name_67, u4_.locale AS locale_68, u4_.two_factor_enabled AS two_factor_enabled_69, u4_.two_factor_method AS two_factor_method_70, u4_.two_factor_secret AS two_factor_secret_71, u4_.two_factor_backup_codes AS two_factor_backup_codes_72, u4_.two_factor_confirmed_at AS two_factor_confirmed_at_73, u4_.google_id AS google_id_74, u4_.microsoft_id AS microsoft_id_75, u4_.github_id AS github_id_76, u4_.gitlab_id AS gitlab_id_77, u4_.oidc_sub AS oidc_sub_78, u4_.oidc_issuer AS oidc_issuer_79, u4_.created_at AS created_at_80 FROM content_entry c0_ LEFT JOIN content_field_value c1_ ON c0_.id = c1_.content_entry_id LEFT JOIN `user` u2_ ON c0_.created_by_id = u2_.id LEFT JOIN `user` u3_ ON c0_.updated_by_id = u3_.id LEFT JOIN `user` u4_ ON c0_.assigned_to_id = u4_.id WHERE c0_.collection_id = 52 AND c0_.deleted_at IS NULL AND c0_.locale = 'en' AND c0_.status = 'published') dctrn_result_inner ORDER BY created_at_4 DESC) dctrn_result LIMIT 100;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  content_entry c0_
  LEFT JOIN content_field_value c1_ ON c0_.id = c1_.content_entry_id
WHERE
  c0_.collection_id = ?
  AND c0_.deleted_at IS NULL
  AND c0_.locale = ?
  AND c0_.status = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM content_entry c0_ LEFT JOIN content_field_value c1_ ON c0_.id = c1_.content_entry_id WHERE c0_.collection_id = 52 AND c0_.deleted_at IS NULL AND c0_.locale = 'en' AND c0_.status = 'published';