Symfony Profiler

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,
  s1_.name AS name_11,
  s1_.slug AS slug_12,
  s1_.customized_route AS customized_route_13,
  s1_.customized_domain AS customized_domain_14,
  s1_.iconify_code AS iconify_code_15,
  s1_.id AS id_16,
  s1_.api_id AS api_id_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  s2_.name AS name_20,
  s2_.released_at AS released_at_21,
  s2_.date_type AS date_type_22,
  s2_.status AS status_23,
  s2_.id AS id_24,
  s2_.api_id AS api_id_25,
  s3_.name AS name_26,
  s3_.slug AS slug_27,
  s3_.abbreviation AS abbreviation_28,
  s3_.type AS type_29,
  s3_.family AS family_30,
  s3_.iconify_code AS iconify_code_31,
  s3_.id AS id_32,
  s3_.api_id AS api_id_33,
  s3_.displayed AS displayed_34,
  s3_.color AS color_35,
  s3_.created_at AS created_at_36,
  s3_.updated_at AS updated_at_37,
  s4_.checksum AS checksum_38,
  s4_.id AS id_39,
  s4_.api_id AS api_id_40,
  s4_.created_at AS created_at_41,
  s4_.updated_at AS updated_at_42,
  s4_.file_metadata_name AS file_metadata_name_43,
  s4_.file_metadata_original_name AS file_metadata_original_name_44,
  s4_.file_metadata_mime_type AS file_metadata_mime_type_45,
  s4_.file_metadata_size AS file_metadata_size_46,
  s4_.file_metadata_dimensions AS file_metadata_dimensions_47,
  s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_48,
  s0_.background__sebii__file__media__id AS background__sebii__file__media__id_49,
  s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_50,
  s1_.background__sebii__file__media__id AS background__sebii__file__media__id_51,
  s2_.sebii__category__category__id AS sebii__category__category__id_52,
  s2_.sebii__category__platform__id AS sebii__category__platform__id_53,
  s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_54,
  s3_.logo__sebii__file__media__id AS logo__sebii__file__media__id_55
FROM
  "sebii__category__category" s0_
  LEFT JOIN sebii__category__category_universe s5_ ON s0_.id = s5_.sebii__category__category__id
  LEFT JOIN "sebii__category__universe" s1_ ON s1_.id = s5_.sebii__category__universe__id
  LEFT JOIN "sebii__category__release" s2_ ON s0_.id = s2_.sebii__category__category__id
  LEFT JOIN "sebii__category__platform" s3_ ON s2_.sebii__category__platform__id = s3_.id
  LEFT JOIN "sebii__file__media" s4_ ON s0_.cover__sebii__file__media__id = s4_.id
WHERE
  s0_.type IN (?)
  AND s1_.id IN (?, ?, ?)
  AND s3_.id IN (?)
ORDER BY
  s0_.name ASC,
  s1_.name ASC,
  s2_.name ASC

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, s1_.name AS name_11, s1_.slug AS slug_12, s1_.customized_route AS customized_route_13, s1_.customized_domain AS customized_domain_14, s1_.iconify_code AS iconify_code_15, s1_.id AS id_16, s1_.api_id AS api_id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s2_.name AS name_20, s2_.released_at AS released_at_21, s2_.date_type AS date_type_22, s2_.status AS status_23, s2_.id AS id_24, s2_.api_id AS api_id_25, s3_.name AS name_26, s3_.slug AS slug_27, s3_.abbreviation AS abbreviation_28, s3_.type AS type_29, s3_.family AS family_30, s3_.iconify_code AS iconify_code_31, s3_.id AS id_32, s3_.api_id AS api_id_33, s3_.displayed AS displayed_34, s3_.color AS color_35, s3_.created_at AS created_at_36, s3_.updated_at AS updated_at_37, s4_.checksum AS checksum_38, s4_.id AS id_39, s4_.api_id AS api_id_40, s4_.created_at AS created_at_41, s4_.updated_at AS updated_at_42, s4_.file_metadata_name AS file_metadata_name_43, s4_.file_metadata_original_name AS file_metadata_original_name_44, s4_.file_metadata_mime_type AS file_metadata_mime_type_45, s4_.file_metadata_size AS file_metadata_size_46, s4_.file_metadata_dimensions AS file_metadata_dimensions_47, s0_.cover__sebii__file__media__id AS cover__sebii__file__media__id_48, s0_.background__sebii__file__media__id AS background__sebii__file__media__id_49, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_50, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_51, s2_.sebii__category__category__id AS sebii__category__category__id_52, s2_.sebii__category__platform__id AS sebii__category__platform__id_53, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_54, s3_.logo__sebii__file__media__id AS logo__sebii__file__media__id_55 FROM "sebii__category__category" s0_ LEFT JOIN sebii__category__category_universe s5_ ON s0_.id = s5_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s1_ ON s1_.id = s5_.sebii__category__universe__id LEFT JOIN "sebii__category__release" s2_ ON s0_.id = s2_.sebii__category__category__id LEFT JOIN "sebii__category__platform" s3_ ON s2_.sebii__category__platform__id = s3_.id LEFT JOIN "sebii__file__media" s4_ ON s0_.cover__sebii__file__media__id = s4_.id WHERE s0_.type IN ('build') AND s1_.id IN ('018fdadf-36f2-71d3-af4b-5138bfb34c7d', '018fdadf-36e9-7997-b243-3dc250181dfb', '018fdadf-3724-7c0e-b9cf-49eacc802547') AND s3_.id IN ('01939bb4-89da-75bd-921a-84395c214876') ORDER BY s0_.name ASC, s1_.name ASC, 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;

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-27 21:49:41.849915\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:59:\\\"/categories/p:playstation-4,t:build,u:halo,u:pikmin,u:wario\\\";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-27 21:49:41', '2025-04-27 21:49:41') RETURNING 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.slug = ?
LIMIT
  1

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.slug = 'playstation-4' 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
  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

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;

"COMMIT"

"COMMIT";

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.abbreviation AS abbreviation_2,
  s0_.type AS type_3,
  s0_.family AS family_4,
  s0_.iconify_code AS iconify_code_5,
  s0_.id AS id_6,
  s0_.api_id AS api_id_7,
  s0_.displayed AS displayed_8,
  s0_.color AS color_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.logo__sebii__file__media__id AS logo__sebii__file__media__id_12
FROM
  "sebii__category__platform" s0_
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.abbreviation AS abbreviation_2, s0_.type AS type_3, s0_.family AS family_4, s0_.iconify_code AS iconify_code_5, s0_.id AS id_6, s0_.api_id AS api_id_7, s0_.displayed AS displayed_8, s0_.color AS color_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.logo__sebii__file__media__id AS logo__sebii__file__media__id_12 FROM "sebii__category__platform" s0_ ORDER BY s0_.name ASC;

"START TRANSACTION"

"START TRANSACTION";