Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_5
    FROM
      (
        SELECT
          s0_.name AS name_0,
          s0_.type AS type_1,
          s0_.description AS description_2,
          s0_.recorded_at AS recorded_at_3,
          s0_.duration AS duration_4,
          s0_.id AS id_5,
          s0_.api_id AS api_id_6,
          s0_.displayed AS displayed_7,
          s0_.created_at AS created_at_8,
          s0_.updated_at AS updated_at_9,
          s1_.name AS name_10,
          s1_.invisible_complement_name AS invisible_complement_name_11,
          s1_.slug AS slug_12,
          s1_.type AS type_13,
          s1_.is_compilation AS is_compilation_14,
          s1_.first_released_at AS first_released_at_15,
          s1_.id AS id_16,
          s1_.api_id AS api_id_17,
          s1_.displayed AS displayed_18,
          s1_.created_at AS created_at_19,
          s1_.updated_at AS updated_at_20,
          s2_.name AS name_21,
          s2_.slug AS slug_22,
          s2_.customized_route AS customized_route_23,
          s2_.customized_domain AS customized_domain_24,
          s2_.iconify_code AS iconify_code_25,
          s2_.id AS id_26,
          s2_.api_id AS api_id_27,
          s2_.created_at AS created_at_28,
          s2_.updated_at AS updated_at_29,
          s3_.name AS name_30,
          s3_.released_at AS released_at_31,
          s3_.date_type AS date_type_32,
          s3_.status AS status_33,
          s3_.id AS id_34,
          s3_.api_id AS api_id_35,
          s4_.name AS name_36,
          s4_.slug AS slug_37,
          s4_.abbreviation AS abbreviation_38,
          s4_.type AS type_39,
          s4_.family AS family_40,
          s4_.iconify_code AS iconify_code_41,
          s4_.id AS id_42,
          s4_.api_id AS api_id_43,
          s4_.displayed AS displayed_44,
          s4_.color AS color_45,
          s4_.created_at AS created_at_46,
          s4_.updated_at AS updated_at_47,
          s5_.checksum AS checksum_48,
          s5_.id AS id_49,
          s5_.api_id AS api_id_50,
          s5_.created_at AS created_at_51,
          s5_.updated_at AS updated_at_52,
          s5_.file_metadata_name AS file_metadata_name_53,
          s5_.file_metadata_original_name AS file_metadata_original_name_54,
          s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
          s5_.file_metadata_size AS file_metadata_size_56,
          s5_.file_metadata_dimensions AS file_metadata_dimensions_57
        FROM
          "sebii__video__video" s0_
          LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
          LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
          LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
          LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
          LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
          LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
          LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
          LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
        WHERE
          s0_.displayed = true
          AND s2_.id IN (?, ?, ?, ?)
        ORDER BY
          s0_.recorded_at DESC,
          s2_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.description AS description_2, s0_.recorded_at AS recorded_at_3, s0_.duration AS duration_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.displayed AS displayed_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.name AS name_10, s1_.invisible_complement_name AS invisible_complement_name_11, s1_.slug AS slug_12, s1_.type AS type_13, s1_.is_compilation AS is_compilation_14, s1_.first_released_at AS first_released_at_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.displayed AS displayed_18, s1_.created_at AS created_at_19, s1_.updated_at AS updated_at_20, s2_.name AS name_21, s2_.slug AS slug_22, s2_.customized_route AS customized_route_23, s2_.customized_domain AS customized_domain_24, s2_.iconify_code AS iconify_code_25, s2_.id AS id_26, s2_.api_id AS api_id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true AND s2_.id IN ('018fdadf-36f2-71d3-af4b-5138bfb34c7d', '0193a6e1-6953-750c-ba8f-5162e1a0b6c2', '018fdadf-371e-736a-b0cf-d2fb58894645', '018fdadf-36e9-7997-b243-3dc250181dfb') ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table;

SELECT
  s0_.name AS name_0,
  s0_.type AS type_1,
  s0_.description AS description_2,
  s0_.recorded_at AS recorded_at_3,
  s0_.duration AS duration_4,
  s0_.id AS id_5,
  s0_.api_id AS api_id_6,
  s0_.displayed AS displayed_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s1_.name AS name_10,
  s1_.invisible_complement_name AS invisible_complement_name_11,
  s1_.slug AS slug_12,
  s1_.type AS type_13,
  s1_.is_compilation AS is_compilation_14,
  s1_.first_released_at AS first_released_at_15,
  s1_.id AS id_16,
  s1_.api_id AS api_id_17,
  s1_.displayed AS displayed_18,
  s1_.created_at AS created_at_19,
  s1_.updated_at AS updated_at_20,
  s2_.name AS name_21,
  s2_.slug AS slug_22,
  s2_.customized_route AS customized_route_23,
  s2_.customized_domain AS customized_domain_24,
  s2_.iconify_code AS iconify_code_25,
  s2_.id AS id_26,
  s2_.api_id AS api_id_27,
  s2_.created_at AS created_at_28,
  s2_.updated_at AS updated_at_29,
  s3_.name AS name_30,
  s3_.released_at AS released_at_31,
  s3_.date_type AS date_type_32,
  s3_.status AS status_33,
  s3_.id AS id_34,
  s3_.api_id AS api_id_35,
  s4_.name AS name_36,
  s4_.slug AS slug_37,
  s4_.abbreviation AS abbreviation_38,
  s4_.type AS type_39,
  s4_.family AS family_40,
  s4_.iconify_code AS iconify_code_41,
  s4_.id AS id_42,
  s4_.api_id AS api_id_43,
  s4_.displayed AS displayed_44,
  s4_.color AS color_45,
  s4_.created_at AS created_at_46,
  s4_.updated_at AS updated_at_47,
  s5_.checksum AS checksum_48,
  s5_.id AS id_49,
  s5_.api_id AS api_id_50,
  s5_.created_at AS created_at_51,
  s5_.updated_at AS updated_at_52,
  s5_.file_metadata_name AS file_metadata_name_53,
  s5_.file_metadata_original_name AS file_metadata_original_name_54,
  s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
  s5_.file_metadata_size AS file_metadata_size_56,
  s5_.file_metadata_dimensions AS file_metadata_dimensions_57,
  s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_58,
  s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_59,
  s1_.background__sebii__file__media__id AS background__sebii__file__media__id_60,
  s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_61,
  s2_.background__sebii__file__media__id AS background__sebii__file__media__id_62,
  s3_.sebii__category__category__id AS sebii__category__category__id_63,
  s3_.sebii__category__platform__id AS sebii__category__platform__id_64,
  s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_65,
  s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_66
FROM
  "sebii__video__video" s0_
  LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
  LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
  LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
  LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
  LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
  LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
  LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
  LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
WHERE
  s0_.displayed = true
  AND s2_.id IN (?, ?, ?, ?)
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.recorded_at DESC,
  s2_.name ASC

SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.description AS description_2, s0_.recorded_at AS recorded_at_3, s0_.duration AS duration_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.displayed AS displayed_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.name AS name_10, s1_.invisible_complement_name AS invisible_complement_name_11, s1_.slug AS slug_12, s1_.type AS type_13, s1_.is_compilation AS is_compilation_14, s1_.first_released_at AS first_released_at_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.displayed AS displayed_18, s1_.created_at AS created_at_19, s1_.updated_at AS updated_at_20, s2_.name AS name_21, s2_.slug AS slug_22, s2_.customized_route AS customized_route_23, s2_.customized_domain AS customized_domain_24, s2_.iconify_code AS iconify_code_25, s2_.id AS id_26, s2_.api_id AS api_id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_58, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_59, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_60, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_61, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_62, s3_.sebii__category__category__id AS sebii__category__category__id_63, s3_.sebii__category__platform__id AS sebii__category__platform__id_64, s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_65, s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_66 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true AND s2_.id IN ('018fdadf-36f2-71d3-af4b-5138bfb34c7d', '0193a6e1-6953-750c-ba8f-5162e1a0b6c2', '018fdadf-371e-736a-b0cf-d2fb58894645', '018fdadf-36e9-7997-b243-3dc250181dfb') AND s0_.id IN ('019104c9-1307-7066-8a7e-6cc436ac00ca', '019104ca-b2b5-736f-9560-ada79bc868dd', '019104cd-6a15-76b6-9027-a913bc0c3362', '0190bd5f-25bd-7840-ab6b-6a1af839069a', '0190bd5c-1499-7307-a734-7ac1fcf94e43', '018fe01e-e3e8-7bdd-9832-33a1c5f3aa93', '018fe01e-e79a-778b-9c8a-fda221470f15', '018fe01e-b066-705c-afc7-b688db2e2de1', '018fe01e-ce16-72cd-bfa3-9b80ca91b6f6', '018fe01e-d5c9-7ec9-a3b6-c2d5eafe00c6', '018fe01f-432d-77e4-8b50-8e7a5ad1f28b', '018fe01e-b083-7c44-9157-3bca5ca2f7a1', '018fe01e-debf-73ca-8906-5fe3c68b15cf', '018fe01e-ef1c-7ce8-b9b5-973960297c99', '018fe01f-3958-7018-b450-e055e758ded3', '018fe01e-bbc2-7f92-a0b1-911e4049ab20', '018fe01e-b767-7925-96e7-e38a0b403a0f', '018fe01e-d459-77db-812d-adb37d1491fa', '018fe4bf-9c70-7bba-b7b3-f414cbb370fe', '018fe01e-ce2e-703f-9732-969e1167c8bf', '018fe01e-d889-7528-b667-3423170c00d0', '018fe01e-e182-783b-8bdd-55679e16eb1d', '018fe01e-e002-7b7d-aa1d-8b55296b5f59', '018fe01f-40a9-7967-954a-7a4d8fa2c63c') ORDER BY s0_.recorded_at DESC, s2_.name ASC;

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.customized_route AS customized_route_2,
  s0_.customized_domain AS customized_domain_3,
  s0_.iconify_code AS iconify_code_4,
  s0_.id AS id_5,
  s0_.api_id AS api_id_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s1_.checksum AS checksum_9,
  s1_.id AS id_10,
  s1_.api_id AS api_id_11,
  s1_.created_at AS created_at_12,
  s1_.updated_at AS updated_at_13,
  s1_.file_metadata_name AS file_metadata_name_14,
  s1_.file_metadata_original_name AS file_metadata_original_name_15,
  s1_.file_metadata_mime_type AS file_metadata_mime_type_16,
  s1_.file_metadata_size AS file_metadata_size_17,
  s1_.file_metadata_dimensions AS file_metadata_dimensions_18,
  s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_19,
  s0_.background__sebii__file__media__id AS background__sebii__file__media__id_20
FROM
  "sebii__category__universe" s0_
  LEFT JOIN "sebii__file__media" s1_ ON s0_.cover__sebii__file__media__id = s1_.id
WHERE
  s0_.slug = ?

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.checksum AS checksum_9, s1_.id AS id_10, s1_.api_id AS api_id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.file_metadata_name AS file_metadata_name_14, s1_.file_metadata_original_name AS file_metadata_original_name_15, s1_.file_metadata_mime_type AS file_metadata_mime_type_16, s1_.file_metadata_size AS file_metadata_size_17, s1_.file_metadata_dimensions AS file_metadata_dimensions_18, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_19, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_20 FROM "sebii__category__universe" s0_ LEFT JOIN "sebii__file__media" s1_ ON s0_.cover__sebii__file__media__id = s1_.id WHERE s0_.slug = 'halo';

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.customized_route AS customized_route_3,
  t0.customized_domain AS customized_domain_4,
  t0.iconify_code AS iconify_code_5,
  t0.id AS id_6,
  t0.api_id AS api_id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10,
  t0.background__sebii__file__media__id AS background__sebii__file__media__id_11
FROM
  "sebii__category__universe" t0
WHERE
  t0.customized_domain = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = 'sebii.dev' LIMIT 1;

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.customized_route AS customized_route_2,
  s0_.customized_domain AS customized_domain_3,
  s0_.iconify_code AS iconify_code_4,
  s0_.id AS id_5,
  s0_.api_id AS api_id_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s1_.name AS name_9,
  s1_.invisible_complement_name AS invisible_complement_name_10,
  s1_.slug AS slug_11,
  s1_.type AS type_12,
  s1_.is_compilation AS is_compilation_13,
  s1_.first_released_at AS first_released_at_14,
  s1_.id AS id_15,
  s1_.api_id AS api_id_16,
  s1_.displayed AS displayed_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20,
  s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21,
  s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22,
  s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23
FROM
  "sebii__category__universe" s0_
  LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id
  LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id
ORDER BY
  s0_.name ASC,
  s1_.name ASC

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.customized_route AS customized_route_2, s0_.customized_domain AS customized_domain_3, s0_.iconify_code AS iconify_code_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.name AS name_9, s1_.invisible_complement_name AS invisible_complement_name_10, s1_.slug AS slug_11, s1_.type AS type_12, s1_.is_compilation AS is_compilation_13, s1_.first_released_at AS first_released_at_14, s1_.id AS id_15, s1_.api_id AS api_id_16, s1_.displayed AS displayed_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_20, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_21, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_22, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_23 FROM "sebii__category__universe" s0_ LEFT JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__universe__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s2_.sebii__category__category__id ORDER BY s0_.name ASC, s1_.name ASC;

SELECT
  DISTINCT id_5,
  MIN(sclr_58) AS dctrn_minrownum
FROM
  (
    SELECT
      s0_.name AS name_0,
      s0_.type AS type_1,
      s0_.description AS description_2,
      s0_.recorded_at AS recorded_at_3,
      s0_.duration AS duration_4,
      s0_.id AS id_5,
      s0_.api_id AS api_id_6,
      s0_.displayed AS displayed_7,
      s0_.created_at AS created_at_8,
      s0_.updated_at AS updated_at_9,
      s1_.name AS name_10,
      s1_.invisible_complement_name AS invisible_complement_name_11,
      s1_.slug AS slug_12,
      s1_.type AS type_13,
      s1_.is_compilation AS is_compilation_14,
      s1_.first_released_at AS first_released_at_15,
      s1_.id AS id_16,
      s1_.api_id AS api_id_17,
      s1_.displayed AS displayed_18,
      s1_.created_at AS created_at_19,
      s1_.updated_at AS updated_at_20,
      s2_.name AS name_21,
      s2_.slug AS slug_22,
      s2_.customized_route AS customized_route_23,
      s2_.customized_domain AS customized_domain_24,
      s2_.iconify_code AS iconify_code_25,
      s2_.id AS id_26,
      s2_.api_id AS api_id_27,
      s2_.created_at AS created_at_28,
      s2_.updated_at AS updated_at_29,
      s3_.name AS name_30,
      s3_.released_at AS released_at_31,
      s3_.date_type AS date_type_32,
      s3_.status AS status_33,
      s3_.id AS id_34,
      s3_.api_id AS api_id_35,
      s4_.name AS name_36,
      s4_.slug AS slug_37,
      s4_.abbreviation AS abbreviation_38,
      s4_.type AS type_39,
      s4_.family AS family_40,
      s4_.iconify_code AS iconify_code_41,
      s4_.id AS id_42,
      s4_.api_id AS api_id_43,
      s4_.displayed AS displayed_44,
      s4_.color AS color_45,
      s4_.created_at AS created_at_46,
      s4_.updated_at AS updated_at_47,
      s5_.checksum AS checksum_48,
      s5_.id AS id_49,
      s5_.api_id AS api_id_50,
      s5_.created_at AS created_at_51,
      s5_.updated_at AS updated_at_52,
      s5_.file_metadata_name AS file_metadata_name_53,
      s5_.file_metadata_original_name AS file_metadata_original_name_54,
      s5_.file_metadata_mime_type AS file_metadata_mime_type_55,
      s5_.file_metadata_size AS file_metadata_size_56,
      s5_.file_metadata_dimensions AS file_metadata_dimensions_57,
      ROW_NUMBER() OVER(
        ORDER BY
          s0_.recorded_at DESC,
          s2_.name ASC
      ) AS sclr_58
    FROM
      "sebii__video__video" s0_
      LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id
      LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id
      LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id
      LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id
      LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id
      LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id
      LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id
      LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id
    WHERE
      s0_.displayed = true
      AND s2_.id IN (?, ?, ?, ?)
  ) dctrn_result
GROUP BY
  id_5
ORDER BY
  dctrn_minrownum ASC
LIMIT
  24

SELECT DISTINCT id_5, MIN(sclr_58) AS dctrn_minrownum FROM (SELECT s0_.name AS name_0, s0_.type AS type_1, s0_.description AS description_2, s0_.recorded_at AS recorded_at_3, s0_.duration AS duration_4, s0_.id AS id_5, s0_.api_id AS api_id_6, s0_.displayed AS displayed_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.name AS name_10, s1_.invisible_complement_name AS invisible_complement_name_11, s1_.slug AS slug_12, s1_.type AS type_13, s1_.is_compilation AS is_compilation_14, s1_.first_released_at AS first_released_at_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.displayed AS displayed_18, s1_.created_at AS created_at_19, s1_.updated_at AS updated_at_20, s2_.name AS name_21, s2_.slug AS slug_22, s2_.customized_route AS customized_route_23, s2_.customized_domain AS customized_domain_24, s2_.iconify_code AS iconify_code_25, s2_.id AS id_26, s2_.api_id AS api_id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s3_.name AS name_30, s3_.released_at AS released_at_31, s3_.date_type AS date_type_32, s3_.status AS status_33, s3_.id AS id_34, s3_.api_id AS api_id_35, s4_.name AS name_36, s4_.slug AS slug_37, s4_.abbreviation AS abbreviation_38, s4_.type AS type_39, s4_.family AS family_40, s4_.iconify_code AS iconify_code_41, s4_.id AS id_42, s4_.api_id AS api_id_43, s4_.displayed AS displayed_44, s4_.color AS color_45, s4_.created_at AS created_at_46, s4_.updated_at AS updated_at_47, s5_.checksum AS checksum_48, s5_.id AS id_49, s5_.api_id AS api_id_50, s5_.created_at AS created_at_51, s5_.updated_at AS updated_at_52, s5_.file_metadata_name AS file_metadata_name_53, s5_.file_metadata_original_name AS file_metadata_original_name_54, s5_.file_metadata_mime_type AS file_metadata_mime_type_55, s5_.file_metadata_size AS file_metadata_size_56, s5_.file_metadata_dimensions AS file_metadata_dimensions_57, ROW_NUMBER() OVER(ORDER BY s0_.recorded_at DESC, s2_.name ASC) AS sclr_58 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s6_ ON s0_.id = s6_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s6_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s7_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s7_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s8_ ON s0_.id = s8_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s8_.sebii__category__release__id LEFT JOIN "sebii__category__platform" s4_ ON s3_.sebii__category__platform__id = s4_.id LEFT JOIN "sebii__file__media" s5_ ON s0_.thumbnail__sebii__file__media__id = s5_.id WHERE s0_.displayed = true AND s2_.id IN ('018fdadf-36f2-71d3-af4b-5138bfb34c7d', '0193a6e1-6953-750c-ba8f-5162e1a0b6c2', '018fdadf-371e-736a-b0cf-d2fb58894645', '018fdadf-36e9-7997-b243-3dc250181dfb')) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24;

INSERT INTO sebii__messenger__message (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?) RETURNING id

INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:46:\\\"App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\\":6:{s:50:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0at\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-04-20 09:14:57.458520\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:39:\\\"/videos/1/u:halo,u:kirby,u:ori,u:pikmin\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:9:\\\"sebii.dev\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0ipAddress\\\";s:10:\\\"172.19.0.1\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0userAgent\\\";s:103:\\\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\\\";s:56:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0referrer\\\";N;}}', '[]', 'security_analytic', '2025-04-20 09:14:57', '2025-04-20 09:14:57') RETURNING id;

SELECT
  t0.checksum AS checksum_1,
  t0.id AS id_2,
  t0.api_id AS api_id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.file_metadata_name AS file_metadata_name_6,
  t0.file_metadata_original_name AS file_metadata_original_name_7,
  t0.file_metadata_mime_type AS file_metadata_mime_type_8,
  t0.file_metadata_size AS file_metadata_size_9,
  t0.file_metadata_dimensions AS file_metadata_dimensions_10
FROM
  "sebii__file__media" t0
WHERE
  t0.id = ?

SELECT t0.checksum AS checksum_1, t0.id AS id_2, t0.api_id AS api_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_metadata_name AS file_metadata_name_6, t0.file_metadata_original_name AS file_metadata_original_name_7, t0.file_metadata_mime_type AS file_metadata_mime_type_8, t0.file_metadata_size AS file_metadata_size_9, t0.file_metadata_dimensions AS file_metadata_dimensions_10 FROM "sebii__file__media" t0 WHERE t0.id = '018fe009-a8b8-763a-96b7-8768708340ee';

SELECT
  s0_.type AS type_0,
  s0_.name AS name_1,
  s0_.url AS url_2,
  s0_.head_position AS head_position_3,
  s0_.id AS id_4,
  s0_.api_id AS api_id_5
FROM
  "sebii__social__item" s0_
WHERE
  s0_.head_position IS NOT NULL
ORDER BY
  s0_.head_position ASC