Symfony Profiler

[
  "route" => "app_shared_collection_show"
  "route_parameters" => [
    "_route" => "app_shared_collection_show"
    "_controller" => "App\Controller\CollectionController::show"
    "username" => "FieserOstfriese"
    "id" => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "request_uri" => "https://games.tenorweb.de/user/FieserOstfriese/collections/019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  "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"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.enabled AS enabled_6, t0.roles AS roles_7, t0.currency AS currency_8, t0.locale AS locale_9, t0.timezone AS timezone_10, t0.date_format AS date_format_11, t0.disk_space_allowed AS disk_space_allowed_12, t0.visibility AS visibility_13, t0.last_date_of_activity AS last_date_of_activity_14, t0.theme AS theme_15, t0.wishlists_feature_enabled AS wishlists_feature_enabled_16, t0.tags_feature_enabled AS tags_feature_enabled_17, t0.signs_feature_enabled AS signs_feature_enabled_18, t0.albums_feature_enabled AS albums_feature_enabled_19, t0.loans_feature_enabled AS loans_feature_enabled_20, t0.templates_feature_enabled AS templates_feature_enabled_21, t0.history_feature_enabled AS history_feature_enabled_22, t0.statistics_feature_enabled AS statistics_feature_enabled_23, t0.scraping_feature_enabled AS scraping_feature_enabled_24, t0.search_in_data_by_default_enabled AS search_in_data_by_default_enabled_25, t0.display_items_name_in_grid_view AS display_items_name_in_grid_view_26, t0.search_results_display_mode AS search_results_display_mode_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.collections_display_configuration_id AS collections_display_configuration_id_33, t0.wishlists_display_configuration_id AS wishlists_display_configuration_id_34, t0.albums_display_configuration_id AS albums_display_configuration_id_35 FROM koi_user t0 WHERE t0.username = ? AND ((t0.id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.visibility = 'public')) LIMIT 1"
  "params" => [
    1 => "FieserOstfriese"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "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\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "App\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" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ActivityListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\FilterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\TimezoneListener::onKernelRequest"
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'))"
  "params" => [
    1 => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

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

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_16 FROM koi_display_configuration t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))"
  "params" => [
    1 => "019c0a5b-a4e9-7f06-a183-8b5d8aff8c1f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT k0_.id AS id_0, k0_.title AS title_1, k0_.color AS color_2, k0_.image AS image_3, k0_.seen_counter AS seen_counter_4, k0_.cached_values AS cached_values_5, k0_.visibility AS visibility_6, k0_.parent_visibility AS parent_visibility_7, k0_.final_visibility AS final_visibility_8, k0_.scraped_from_url AS scraped_from_url_9, k0_.created_at AS created_at_10, k0_.updated_at AS updated_at_11, k0_.children_display_configuration_id AS children_display_configuration_id_12, k0_.parent_id AS parent_id_13, k0_.owner_id AS owner_id_14, k0_.items_display_configuration_id AS items_display_configuration_id_15, k0_.items_default_template_id AS items_default_template_id_16 FROM koi_collection k0_ WHERE (k0_.parent_id = ?) AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public')"
  "params" => [
    1 => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.display_mode AS display_mode_3, t0.sorting_property AS sorting_property_4, t0.sorting_type AS sorting_type_5, t0.sorting_direction AS sorting_direction_6, t0.show_visibility AS show_visibility_7, t0.show_actions AS show_actions_8, t0.show_number_of_children AS show_number_of_children_9, t0.show_number_of_items AS show_number_of_items_10, t0.show_item_quantities AS show_item_quantities_11, t0.columns AS columns_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_16 FROM koi_display_configuration t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))"
  "params" => [
    1 => "019c0a5b-a4e9-7f52-a183-8b5d8baa6453"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.quantity AS quantity_2, k0_.image AS image_3, k0_.image_small_thumbnail AS image_small_thumbnail_4, k0_.image_large_thumbnail AS image_large_thumbnail_5, k0_.seen_counter AS seen_counter_6, k0_.visibility AS visibility_7, k0_.parent_visibility AS parent_visibility_8, k0_.final_visibility AS final_visibility_9, k0_.scraped_from_url AS scraped_from_url_10, k0_.created_at AS created_at_11, k0_.updated_at AS updated_at_12, k1_.id AS id_13, k1_.lent_to AS lent_to_14, k1_.lent_at AS lent_at_15, k1_.returned_at AS returned_at_16, k2_.id AS id_17, k2_.type AS type_18, k2_.label AS label_19, k2_.value AS value_20, k2_.position AS position_21, k2_.currency AS currency_22, k2_.image AS image_23, k2_.image_small_thumbnail AS image_small_thumbnail_24, k2_.image_large_thumbnail AS image_large_thumbnail_25, k2_.file AS file_26, k2_.video AS video_27, k2_.original_filename AS original_filename_28, k2_.visibility AS visibility_29, k2_.parent_visibility AS parent_visibility_30, k2_.final_visibility AS final_visibility_31, k2_.created_at AS created_at_32, k2_.updated_at AS updated_at_33, k0_.collection_id AS collection_id_34, k0_.owner_id AS owner_id_35, k1_.item_id AS item_id_36, k1_.owner_id AS owner_id_37, k2_.item_id AS item_id_38, k2_.collection_id AS collection_id_39, k2_.choice_list_id AS choice_list_id_40, k2_.owner_id AS owner_id_41 FROM koi_item k0_ LEFT JOIN koi_loan k1_ ON k0_.id = k1_.item_id AND (k1_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k1_.returned_at IS NULL) LEFT JOIN koi_datum k2_ ON k0_.id = k2_.item_id AND (k2_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k2_.final_visibility = 'public') AND (k2_.label IN (?, ?, ?, ?) OR k2_.id IS NULL) WHERE (k0_.collection_id = ?) AND (k0_.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (k0_.final_visibility = 'public') ORDER BY k2_.position ASC"
  "params" => [
    1 => "Plattform"
    2 => "Medium"
    3 => "Erscheinungsdatum"
    4 => "USK/FSK"
    5 => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1207}
    3 => Doctrine\DBAL\ParameterType {#1207}
    4 => Doctrine\DBAL\ParameterType {#1207}
    5 => Doctrine\DBAL\ParameterType {#1207}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.image AS image_4, t0.seen_counter AS seen_counter_5, t0.cached_values AS cached_values_6, t0.visibility AS visibility_7, t0.parent_visibility AS parent_visibility_8, t0.final_visibility AS final_visibility_9, t0.scraped_from_url AS scraped_from_url_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.children_display_configuration_id AS children_display_configuration_id_18, t0.parent_id AS parent_id_19, t0.owner_id AS owner_id_20, t0.items_display_configuration_id AS items_display_configuration_id_21, t0.items_default_template_id AS items_default_template_id_22 FROM koi_collection t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public'))"
  "params" => [
    1 => "019c0a25-34d5-7028-9417-c1fa47fbe03d"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5, t0.currency AS currency_6, t0.image AS image_7, t0.image_small_thumbnail AS image_small_thumbnail_8, t0.image_large_thumbnail AS image_large_thumbnail_9, t0.file AS file_10, t0.video AS video_11, t0.original_filename AS original_filename_12, t0.visibility AS visibility_13, t0.parent_visibility AS parent_visibility_14, t0.final_visibility AS final_visibility_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.item_id AS item_id_22, t0.collection_id AS collection_id_23, t0.choice_list_id AS choice_list_id_24, t0.owner_id AS owner_id_25 FROM koi_datum t0 WHERE t0.collection_id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253') AND (t0.final_visibility = 'public')) ORDER BY t0.position ASC"
  "params" => [
    1 => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_7 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))"
  "params" => [
    1 => "019c0898-4858-7b18-9e12-b848c9319a9f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_7 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))"
  "params" => [
    1 => "019c08d1-9d6b-738b-aed5-23ee1ca129f0"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.choices AS choices_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.owner_id AS owner_id_7 FROM koi_choice_list t0 WHERE t0.id = ? AND ((t0.owner_id = '019c0687-41d4-74e8-8215-d23474287253'))"
  "params" => [
    1 => "019c08e8-1c8c-718b-b342-36f7460cc4fe"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "sql" => "UPDATE koi_collection SET seen_counter = seen_counter + 1 WHERE id = ?"
  "params" => [
    1 => "019c0a5b-a4e9-7e0e-a183-8b5d8ae8f5b6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1207
      +name: "STRING"
    }
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\PreLoadAssetsEventListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\RefreshCachedValuesQueueListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\SeenListener::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" => "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\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" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

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

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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