Symfony Profiler

[
  "route" => "front_video_videos"
  "route_parameters" => [
    "_route" => "front_video_videos"
    "page" => "1"
    "filters" => "p:megadrive,p:nintendo-3ds,p:wii,u:metroid,u:ori,u:picross,u:power-rangers,u:professeur-layton,u:resident-evil,u:star-wars,u:streets-of-rage,u:super-mario,u:tetris-99,u:we-were-here,v:short"
    "_controller" => "App\Controller\Front\Video\Videos"
  ]
  "request_uri" => "https://sebii.dev/videos/1/p:megadrive,p:nintendo-3ds,p:wii,u:metroid,u:ori,u:picross,u:power-rangers,u:professeur-layton,u:resident-evil,u:star-wars,u:streets-of-rage,u:super-mario,u:tetris-99,u:we-were-here,v:short"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "postgres"
    "port" => 5432
    "user" => "sebii"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "sebii"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "sebii.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "class" => "App\Messenger\Message\Security\AnalyticMessage"
  "alias" => "security_analytic"
  "sender" => "Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport"
]

[
  "sql" => "INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id"
  "params" => [
    1 => "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-02 18:08:36.772297\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:199:\"/videos/1/p:megadrive,p:nintendo-3ds,p:wii,u:metroid,u:ori,u:picross,u:power-rangers,u:professeur-layton,u:resident-evil,u:star-wars,u:streets-of-rage,u:super-mario,u:tetris-99,u:we-were-here,v:short\";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:102:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)\";s:56:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0referrer\";N;}}"
    2 => "[]"
    3 => "security_analytic"
    4 => "2025-05-02 18:08:36"
    5 => "2025-05-02 18:08:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Event\EventSubscriber\Kernel\UniverseSubscriber::detectUniverse"
]

[
  "event" => "kernel.request"
  "listener" => "App\Event\EventSubscriber\RequestSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sonata\AdminBundle\EventListener\ConfigureCRUDControllerListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container12h7JF2\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => "megadrive"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "nintendo-3ds"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "wii"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "metroid"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "ori"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "picross"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "power-rangers"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "professeur-layton"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "resident-evil"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "star-wars"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "streets-of-rage"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "super-mario"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "tetris-99"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "we-were-here"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC) dctrn_result) dctrn_table"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#2200
      #uid: "018fdadf-36d1-7196-b8a9-0be4d80935ec"
      toBase58: "1CBq5A4KnGcx9FVtpzHBdm"
      toBase32: "01HZDDYDPHE6BBHA8BWKC0JDFC"
      time: "2024-06-02 21:33:32.753000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#2083
      #uid: "018fdadf-371e-736a-b0cf-d2fb58894645"
      toBase58: "1CBq5A4esq2GAmwkhg2Uzx"
      toBase32: "01HZDDYDRYEDNB1KYJZDC8JHJ5"
      time: "2024-06-02 21:33:32.830000 UTC"
    }
    3 => Symfony\Component\Uid\UuidV7 {#2137
      #uid: "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
      toBase58: "1CBq5A4QzayodKNNKR5c9Z"
      toBase32: "01HZDDYDQ6ETGBDEXEKH7KTXQW"
      time: "2024-06-02 21:33:32.774000 UTC"
    }
    4 => Symfony\Component\Uid\UuidV7 {#2148
      #uid: "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
      toBase58: "1CBq5A4UiCcdxPcnNWLfmw"
      toBase32: "01HZDDYDQNEHPBEEP6M3Z4SF1E"
      time: "2024-06-02 21:33:32.789000 UTC"
    }
    5 => Symfony\Component\Uid\UuidV7 {#2342
      #uid: "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
      toBase58: "1CBq5A4YgjJZERnkrUhP8i"
      toBase32: "01HZDDYDR5FERSKP44QXEEFN57"
      time: "2024-06-02 21:33:32.805000 UTC"
    }
    6 => Symfony\Component\Uid\UuidV7 {#2349
      #uid: "018fdadf-372a-7b9a-8587-71faf340653d"
      toBase58: "1CBq5A4hrsx7JZGdxERTKJ"
      toBase32: "01HZDDYDSAFED8B1VHZBSM0S9X"
      time: "2024-06-02 21:33:32.842000 UTC"
    }
    7 => Symfony\Component\Uid\UuidV7 {#2359
      #uid: "0193a711-4ee4-7608-b08c-6d48a733dc86"
      toBase58: "1CHzV4e8FsyU4YrNK5xG3X"
      toBase32: "01JEKH2KQ4ER4B133D92KK7Q46"
      time: "2024-12-08 16:19:09.668000 UTC"
    }
    8 => Symfony\Component\Uid\UuidV7 {#2369
      #uid: "0193a74c-9939-7a9b-b764-36522f7ef385"
      toBase58: "1CHza14xif33vxErWYTctk"
      toBase32: "01JEKMS69SFADVES1PA8QQXWW5"
      time: "2024-12-08 17:23:55.321000 UTC"
    }
    9 => Symfony\Component\Uid\UuidV7 {#2379
      #uid: "018fdadf-36ec-79ef-9f78-2435f8366fe4"
      toBase58: "1CBq5A4SV4tLEp3UsU42aX"
      toBase32: "01HZDDYDQCF7QSYY146QW3CVZ4"
      time: "2024-06-02 21:33:32.780000 UTC"
    }
    10 => Symfony\Component\Uid\UuidV7 {#2311
      #uid: "018fdadf-371b-742c-a432-d7b87a705008"
      toBase58: "1CBq5A4e8ivojqeKx9QKEP"
      toBase32: "01HZDDYDRVEGPA8CPQQ1X70M08"
      time: "2024-06-02 21:33:32.827000 UTC"
    }
    11 => Symfony\Component\Uid\UuidV7 {#2392
      #uid: "018fdadf-36f8-75aa-ba7e-406feae1e93b"
      toBase58: "1CBq5A4VTRE4KDD4e36PV4"
      toBase32: "01HZDDYDQREPNBMZJ0DZNE3T9V"
      time: "2024-06-02 21:33:32.792000 UTC"
    }
    12 => Symfony\Component\Uid\UuidV7 {#2044
      #uid: "019084b1-8d10-72d0-991d-2a49650fb265"
      toBase58: "1CCuWDzVc2eJoYtRcKPt2G"
      toBase32: "01J22B338GEB89J79A95JGZCK5"
      time: "2024-07-05 20:59:06.896000 UTC"
    }
    13 => Symfony\Component\Uid\UuidV7 {#2252
      #uid: "0193a609-ca87-7053-ac50-0598a3ea3059"
      toBase58: "1CHz77c5zLiZSY7wCT3tpx"
      toBase32: "01JEK0KJM7E19TRM05K2HYMC2S"
      time: "2024-12-08 11:31:19.815000 UTC"
    }
    14 => Symfony\Component\Uid\UuidV7 {#2236
      #uid: "01907fce-0f43-7b76-9959-9878a254fa03"
      toBase58: "1CCshz7RabVvCXbJX77onA"
      toBase32: "01J1ZWW3T3FDV9JPCRF2H59YG3"
      time: "2024-07-04 22:12:09.155000 UTC"
    }
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => "sebii.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM "sebii__video__video" s0_ WHERE s0_.type = ?"
  "params" => [
    1 => "live"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT id_5, MIN(sclr_68) 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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67, ROW_NUMBER() OVER(ORDER BY s0_.recorded_at DESC, s2_.name ASC) AS sclr_68 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 24"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#2200
      #uid: "018fdadf-36d1-7196-b8a9-0be4d80935ec"
      toBase58: "1CBq5A4KnGcx9FVtpzHBdm"
      toBase32: "01HZDDYDPHE6BBHA8BWKC0JDFC"
      time: "2024-06-02 21:33:32.753000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#2083
      #uid: "018fdadf-371e-736a-b0cf-d2fb58894645"
      toBase58: "1CBq5A4esq2GAmwkhg2Uzx"
      toBase32: "01HZDDYDRYEDNB1KYJZDC8JHJ5"
      time: "2024-06-02 21:33:32.830000 UTC"
    }
    3 => Symfony\Component\Uid\UuidV7 {#2137
      #uid: "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
      toBase58: "1CBq5A4QzayodKNNKR5c9Z"
      toBase32: "01HZDDYDQ6ETGBDEXEKH7KTXQW"
      time: "2024-06-02 21:33:32.774000 UTC"
    }
    4 => Symfony\Component\Uid\UuidV7 {#2148
      #uid: "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
      toBase58: "1CBq5A4UiCcdxPcnNWLfmw"
      toBase32: "01HZDDYDQNEHPBEEP6M3Z4SF1E"
      time: "2024-06-02 21:33:32.789000 UTC"
    }
    5 => Symfony\Component\Uid\UuidV7 {#2342
      #uid: "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
      toBase58: "1CBq5A4YgjJZERnkrUhP8i"
      toBase32: "01HZDDYDR5FERSKP44QXEEFN57"
      time: "2024-06-02 21:33:32.805000 UTC"
    }
    6 => Symfony\Component\Uid\UuidV7 {#2349
      #uid: "018fdadf-372a-7b9a-8587-71faf340653d"
      toBase58: "1CBq5A4hrsx7JZGdxERTKJ"
      toBase32: "01HZDDYDSAFED8B1VHZBSM0S9X"
      time: "2024-06-02 21:33:32.842000 UTC"
    }
    7 => Symfony\Component\Uid\UuidV7 {#2359
      #uid: "0193a711-4ee4-7608-b08c-6d48a733dc86"
      toBase58: "1CHzV4e8FsyU4YrNK5xG3X"
      toBase32: "01JEKH2KQ4ER4B133D92KK7Q46"
      time: "2024-12-08 16:19:09.668000 UTC"
    }
    8 => Symfony\Component\Uid\UuidV7 {#2369
      #uid: "0193a74c-9939-7a9b-b764-36522f7ef385"
      toBase58: "1CHza14xif33vxErWYTctk"
      toBase32: "01JEKMS69SFADVES1PA8QQXWW5"
      time: "2024-12-08 17:23:55.321000 UTC"
    }
    9 => Symfony\Component\Uid\UuidV7 {#2379
      #uid: "018fdadf-36ec-79ef-9f78-2435f8366fe4"
      toBase58: "1CBq5A4SV4tLEp3UsU42aX"
      toBase32: "01HZDDYDQCF7QSYY146QW3CVZ4"
      time: "2024-06-02 21:33:32.780000 UTC"
    }
    10 => Symfony\Component\Uid\UuidV7 {#2311
      #uid: "018fdadf-371b-742c-a432-d7b87a705008"
      toBase58: "1CBq5A4e8ivojqeKx9QKEP"
      toBase32: "01HZDDYDRVEGPA8CPQQ1X70M08"
      time: "2024-06-02 21:33:32.827000 UTC"
    }
    11 => Symfony\Component\Uid\UuidV7 {#2392
      #uid: "018fdadf-36f8-75aa-ba7e-406feae1e93b"
      toBase58: "1CBq5A4VTRE4KDD4e36PV4"
      toBase32: "01HZDDYDQREPNBMZJ0DZNE3T9V"
      time: "2024-06-02 21:33:32.792000 UTC"
    }
    12 => Symfony\Component\Uid\UuidV7 {#2044
      #uid: "019084b1-8d10-72d0-991d-2a49650fb265"
      toBase58: "1CCuWDzVc2eJoYtRcKPt2G"
      toBase32: "01J22B338GEB89J79A95JGZCK5"
      time: "2024-07-05 20:59:06.896000 UTC"
    }
    13 => Symfony\Component\Uid\UuidV7 {#2252
      #uid: "0193a609-ca87-7053-ac50-0598a3ea3059"
      toBase58: "1CHz77c5zLiZSY7wCT3tpx"
      toBase32: "01JEK0KJM7E19TRM05K2HYMC2S"
      time: "2024-12-08 11:31:19.815000 UTC"
    }
    14 => Symfony\Component\Uid\UuidV7 {#2236
      #uid: "01907fce-0f43-7b76-9959-9878a254fa03"
      toBase58: "1CCshz7RabVvCXbJX77onA"
      toBase32: "01J1ZWW3T3FDV9JPCRF2H59YG3"
      time: "2024-07-04 22:12:09.155000 UTC"
    }
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "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, s6_.checksum AS checksum_58, s6_.id AS id_59, s6_.api_id AS api_id_60, s6_.created_at AS created_at_61, s6_.updated_at AS updated_at_62, s6_.file_metadata_name AS file_metadata_name_63, s6_.file_metadata_original_name AS file_metadata_original_name_64, s6_.file_metadata_mime_type AS file_metadata_mime_type_65, s6_.file_metadata_size AS file_metadata_size_66, s6_.file_metadata_dimensions AS file_metadata_dimensions_67, s0_.thumbnail__sebii__file__media__id AS thumbnail__sebii__file__media__id_68, s1_.cover__sebii__file__media__id AS cover__sebii__file__media__id_69, s1_.background__sebii__file__media__id AS background__sebii__file__media__id_70, s2_.cover__sebii__file__media__id AS cover__sebii__file__media__id_71, s2_.background__sebii__file__media__id AS background__sebii__file__media__id_72, s3_.sebii__category__category__id AS sebii__category__category__id_73, s3_.sebii__category__platform__id AS sebii__category__platform__id_74, s3_.cover__sebii__file__media__id AS cover__sebii__file__media__id_75, s4_.logo__sebii__file__media__id AS logo__sebii__file__media__id_76 FROM "sebii__video__video" s0_ LEFT JOIN sebii__video__video_category s7_ ON s0_.id = s7_.sebii__video__video__id LEFT JOIN "sebii__category__category" s1_ ON s1_.id = s7_.sebii__category__category__id LEFT JOIN sebii__category__category_universe s8_ ON s1_.id = s8_.sebii__category__category__id LEFT JOIN "sebii__category__universe" s2_ ON s2_.id = s8_.sebii__category__universe__id LEFT JOIN sebii__video__video_release s9_ ON s0_.id = s9_.sebii__video__video__id LEFT JOIN "sebii__category__release" s3_ ON s3_.id = s9_.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 LEFT JOIN "sebii__file__media" s6_ ON s1_.cover__sebii__file__media__id = s6_.id WHERE s0_.displayed = true AND s2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s3_.sebii__category__platform__id IN (?, ?, ?) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.recorded_at DESC, s2_.name ASC"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#2200
      #uid: "018fdadf-36d1-7196-b8a9-0be4d80935ec"
      toBase58: "1CBq5A4KnGcx9FVtpzHBdm"
      toBase32: "01HZDDYDPHE6BBHA8BWKC0JDFC"
      time: "2024-06-02 21:33:32.753000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#2083
      #uid: "018fdadf-371e-736a-b0cf-d2fb58894645"
      toBase58: "1CBq5A4esq2GAmwkhg2Uzx"
      toBase32: "01HZDDYDRYEDNB1KYJZDC8JHJ5"
      time: "2024-06-02 21:33:32.830000 UTC"
    }
    3 => Symfony\Component\Uid\UuidV7 {#2137
      #uid: "018fdadf-36e6-76a0-b6bb-ae9c4f3d76fc"
      toBase58: "1CBq5A4QzayodKNNKR5c9Z"
      toBase32: "01HZDDYDQ6ETGBDEXEKH7KTXQW"
      time: "2024-06-02 21:33:32.774000 UTC"
    }
    4 => Symfony\Component\Uid\UuidV7 {#2148
      #uid: "018fdadf-36f5-746c-b73a-c6a0fe4cbc2e"
      toBase58: "1CBq5A4UiCcdxPcnNWLfmw"
      toBase32: "01HZDDYDQNEHPBEEP6M3Z4SF1E"
      time: "2024-06-02 21:33:32.789000 UTC"
    }
    5 => Symfony\Component\Uid\UuidV7 {#2342
      #uid: "018fdadf-3705-7bb1-99d8-84bf5ce7d4a7"
      toBase58: "1CBq5A4YgjJZERnkrUhP8i"
      toBase32: "01HZDDYDR5FERSKP44QXEEFN57"
      time: "2024-06-02 21:33:32.805000 UTC"
    }
    6 => Symfony\Component\Uid\UuidV7 {#2349
      #uid: "018fdadf-372a-7b9a-8587-71faf340653d"
      toBase58: "1CBq5A4hrsx7JZGdxERTKJ"
      toBase32: "01HZDDYDSAFED8B1VHZBSM0S9X"
      time: "2024-06-02 21:33:32.842000 UTC"
    }
    7 => Symfony\Component\Uid\UuidV7 {#2359
      #uid: "0193a711-4ee4-7608-b08c-6d48a733dc86"
      toBase58: "1CHzV4e8FsyU4YrNK5xG3X"
      toBase32: "01JEKH2KQ4ER4B133D92KK7Q46"
      time: "2024-12-08 16:19:09.668000 UTC"
    }
    8 => Symfony\Component\Uid\UuidV7 {#2369
      #uid: "0193a74c-9939-7a9b-b764-36522f7ef385"
      toBase58: "1CHza14xif33vxErWYTctk"
      toBase32: "01JEKMS69SFADVES1PA8QQXWW5"
      time: "2024-12-08 17:23:55.321000 UTC"
    }
    9 => Symfony\Component\Uid\UuidV7 {#2379
      #uid: "018fdadf-36ec-79ef-9f78-2435f8366fe4"
      toBase58: "1CBq5A4SV4tLEp3UsU42aX"
      toBase32: "01HZDDYDQCF7QSYY146QW3CVZ4"
      time: "2024-06-02 21:33:32.780000 UTC"
    }
    10 => Symfony\Component\Uid\UuidV7 {#2311
      #uid: "018fdadf-371b-742c-a432-d7b87a705008"
      toBase58: "1CBq5A4e8ivojqeKx9QKEP"
      toBase32: "01HZDDYDRVEGPA8CPQQ1X70M08"
      time: "2024-06-02 21:33:32.827000 UTC"
    }
    11 => Symfony\Component\Uid\UuidV7 {#2392
      #uid: "018fdadf-36f8-75aa-ba7e-406feae1e93b"
      toBase58: "1CBq5A4VTRE4KDD4e36PV4"
      toBase32: "01HZDDYDQREPNBMZJ0DZNE3T9V"
      time: "2024-06-02 21:33:32.792000 UTC"
    }
    12 => Symfony\Component\Uid\UuidV7 {#2044
      #uid: "019084b1-8d10-72d0-991d-2a49650fb265"
      toBase58: "1CCuWDzVc2eJoYtRcKPt2G"
      toBase32: "01J22B338GEB89J79A95JGZCK5"
      time: "2024-07-05 20:59:06.896000 UTC"
    }
    13 => Symfony\Component\Uid\UuidV7 {#2252
      #uid: "0193a609-ca87-7053-ac50-0598a3ea3059"
      toBase58: "1CHz77c5zLiZSY7wCT3tpx"
      toBase32: "01JEK0KJM7E19TRM05K2HYMC2S"
      time: "2024-12-08 11:31:19.815000 UTC"
    }
    14 => Symfony\Component\Uid\UuidV7 {#2236
      #uid: "01907fce-0f43-7b76-9959-9878a254fa03"
      toBase58: "1CCshz7RabVvCXbJX77onA"
      toBase32: "01J1ZWW3T3FDV9JPCRF2H59YG3"
      time: "2024-07-04 22:12:09.155000 UTC"
    }
    15 => "018fe01e-d0e1-7936-aec8-4d86d7a1b765"
    16 => "018fe01e-d478-75cd-b694-b07e48558217"
    17 => "018fe01e-ba79-7636-9708-98d4ea29c2e2"
    18 => "018fe4bf-78f9-7eff-8543-719aa44ff05c"
    19 => "018fe01e-aeac-7404-a385-9dc7c54d760c"
    20 => "018fe01e-b754-773a-9d44-c961caacca81"
    21 => "01902301-aafa-7efe-8a56-a43e9684e546"
    22 => "01902312-c9ba-77da-97a1-210a05339672"
    23 => "01902310-7980-72a5-8bcf-84baf5449382"
    24 => "0190230d-cb74-7698-9cd0-211db7d366d5"
    25 => "01902308-9187-70d8-8f10-6b4f5f5df1bc"
    26 => "01902305-74b4-7bc4-8e25-770d1a5b6b0b"
    27 => "019022f8-6633-70d5-80e6-d9566de4e62a"
    28 => "019022fe-59c3-724f-a4ed-afbcc6cce008"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SurrogateListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]