Symfony Profiler

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 = 'www.sebii.dev' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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-05-23 19:02:45.962900\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:14:\\\"/u/super-mario\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:13:\\\"www.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:139:\\\"Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1\\\";s:56:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0referrer\\\";N;}}', '[]', 'security_analytic', '2025-05-23 19:02:45', '2025-05-23 19:02:45') RETURNING id;

"COMMIT"

"COMMIT";

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.slug = ?
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.slug = 'super-mario' LIMIT 1;

SELECT
  s0_.name AS name_0,
  s0_.invisible_complement_name AS invisible_complement_name_1,
  s0_.slug AS slug_2,
  s0_.type AS type_3,
  s0_.is_compilation AS is_compilation_4,
  s0_.first_released_at AS first_released_at_5,
  s0_.id AS id_6,
  s0_.api_id AS api_id_7,
  s0_.displayed AS displayed_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_11,
  s0_.background__sebii__file__media__id AS background__sebii__file__media__id_12
FROM
  "sebii__category__category" s0_
  INNER JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__category__id
  INNER JOIN "sebii__category__universe" s1_ ON s1_.id = s2_.sebii__category__universe__id
WHERE
  s1_.id = ?

SELECT s0_.name AS name_0, s0_.invisible_complement_name AS invisible_complement_name_1, s0_.slug AS slug_2, s0_.type AS type_3, s0_.is_compilation AS is_compilation_4, s0_.first_released_at AS first_released_at_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_11, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_12 FROM "sebii__category__category" s0_ INNER JOIN sebii__category__category_universe s2_ ON s0_.id = s2_.sebii__category__category__id INNER JOIN "sebii__category__universe" s1_ ON s1_.id = s2_.sebii__category__universe__id WHERE s1_.id = '018fdadf-36ec-79ef-9f78-2435f8366fe4';

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,
  s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_30,
  s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_31,
  s1_.background__sebii__file__media__id AS background__sebii__file__media__id_32,
  s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_33,
  s2_.background__sebii__file__media__id AS background__sebii__file__media__id_34
FROM
  "sebii__video__video" s0_
  INNER JOIN sebii__video__video_category s3_ ON s0_.id = s3_.sebii__video__video__id
  INNER JOIN "sebii__category__category" s1_ ON s1_.id = s3_.sebii__category__category__id
  INNER JOIN sebii__category__category_universe s4_ ON s1_.id = s4_.sebii__category__category__id
  INNER JOIN "sebii__category__universe" s2_ ON s2_.id = s4_.sebii__category__universe__id
WHERE
  s2_.id = ?
ORDER BY
  s0_.recorded_at DESC,
  s2_.name ASC
LIMIT
  4

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, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_30, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_31, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_32, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_33, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_34 FROM "sebii__video__video" s0_ INNER JOIN sebii__video__video_category s3_ ON s0_.id = s3_.sebii__video__video__id INNER JOIN "sebii__category__category" s1_ ON s1_.id = s3_.sebii__category__category__id INNER JOIN sebii__category__category_universe s4_ ON s1_.id = s4_.sebii__category__category__id INNER JOIN "sebii__category__universe" s2_ ON s2_.id = s4_.sebii__category__universe__id WHERE s2_.id = '018fdadf-36ec-79ef-9f78-2435f8366fe4' ORDER BY s0_.recorded_at DESC, s2_.name ASC LIMIT 4;

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 = 'www.sebii.dev' LIMIT 1;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  "sebii__video__video" s0_
WHERE
  s0_.type = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = 'live';

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-a8d8-7252-a096-7967a6e09498';

SELECT
  t0.name AS name_1,
  t0.released_at AS released_at_2,
  t0.date_type AS date_type_3,
  t0.status AS status_4,
  t0.id AS id_5,
  t0.api_id AS api_id_6,
  t0.sebii__category__category__id AS sebii__category__category__id_7,
  t0.sebii__category__platform__id AS sebii__category__platform__id_8,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9
FROM
  "sebii__category__release" t0
WHERE
  t0.sebii__category__category__id = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 WHERE t0.sebii__category__category__id = '018fde62-4adf-717e-98a1-141004581723' ORDER BY t0.name ASC;

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.abbreviation AS abbreviation_3,
  t0.type AS type_4,
  t0.family AS family_5,
  t0.iconify_code AS iconify_code_6,
  t0.id AS id_7,
  t0.api_id AS api_id_8,
  t0.displayed AS displayed_9,
  t0.color AS color_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13
FROM
  "sebii__category__platform" t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.abbreviation AS abbreviation_3, t0.type AS type_4, t0.family AS family_5, t0.iconify_code AS iconify_code_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.color AS color_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13 FROM "sebii__category__platform" t0 WHERE t0.id = '019084f4-7647-792e-bb59-1de14ed6acb2';

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-b104-71e3-b409-3bf20b98a7f8';

SELECT
  t0.name AS name_1,
  t0.released_at AS released_at_2,
  t0.date_type AS date_type_3,
  t0.status AS status_4,
  t0.id AS id_5,
  t0.api_id AS api_id_6,
  t0.sebii__category__category__id AS sebii__category__category__id_7,
  t0.sebii__category__platform__id AS sebii__category__platform__id_8,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9
FROM
  "sebii__category__release" t0
WHERE
  t0.sebii__category__category__id = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 WHERE t0.sebii__category__category__id = '018fde62-5743-7ec4-b115-7499dbc04df2' ORDER BY t0.name ASC;

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.abbreviation AS abbreviation_3,
  t0.type AS type_4,
  t0.family AS family_5,
  t0.iconify_code AS iconify_code_6,
  t0.id AS id_7,
  t0.api_id AS api_id_8,
  t0.displayed AS displayed_9,
  t0.color AS color_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13
FROM
  "sebii__category__platform" t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.abbreviation AS abbreviation_3, t0.type AS type_4, t0.family AS family_5, t0.iconify_code AS iconify_code_6, t0.id AS id_7, t0.api_id AS api_id_8, t0.displayed AS displayed_9, t0.color AS color_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.logo__sebii__file__media__id AS logo__sebii__file__media__id_13 FROM "sebii__category__platform" t0 WHERE t0.id = '01908e25-9ef5-7888-9ae6-3489b3d3a3c2';

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-b113-7adb-b157-10a44992b81b';

SELECT
  t0.name AS name_1,
  t0.released_at AS released_at_2,
  t0.date_type AS date_type_3,
  t0.status AS status_4,
  t0.id AS id_5,
  t0.api_id AS api_id_6,
  t0.sebii__category__category__id AS sebii__category__category__id_7,
  t0.sebii__category__platform__id AS sebii__category__platform__id_8,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9
FROM
  "sebii__category__release" t0
WHERE
  t0.sebii__category__category__id = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 WHERE t0.sebii__category__category__id = '018fde62-5765-7f06-9644-f5dd6d523169' ORDER BY t0.name ASC;

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 = '01903b11-0e6e-786e-b8ff-c9e29d762733';

SELECT
  t0.name AS name_1,
  t0.released_at AS released_at_2,
  t0.date_type AS date_type_3,
  t0.status AS status_4,
  t0.id AS id_5,
  t0.api_id AS api_id_6,
  t0.sebii__category__category__id AS sebii__category__category__id_7,
  t0.sebii__category__platform__id AS sebii__category__platform__id_8,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9
FROM
  "sebii__category__release" t0
WHERE
  t0.sebii__category__category__id = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.released_at AS released_at_2, t0.date_type AS date_type_3, t0.status AS status_4, t0.id AS id_5, t0.api_id AS api_id_6, t0.sebii__category__category__id AS sebii__category__category__id_7, t0.sebii__category__platform__id AS sebii__category__platform__id_8, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_9 FROM "sebii__category__release" t0 WHERE t0.sebii__category__category__id = '018fde62-4804-7178-bbaa-a6b5f427ea89' ORDER BY t0.name ASC;