Symfony Profiler

[
  "event" => "opendxp.system.configuration.get"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\AdminConfigListener::updateSystemConfiguration"
]

[
  "key" => "site_domain_bd64a12945e70130729bbaf9df1cb19b"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "host" => "127.0.0.1"
    "port" => "3306"
    "user" => "web-template-basic_dev"
    "password" => "<redacted>"
    "dbname" => "web-template-basic_dev"
    "idle_connection_ttl" => 600
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "10.11.14-MariaDB"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_general_ci"
    ]
  ]
]

[
  "sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
  "params" => [
    1 => "BUNDLE_INSTALLED__OpenDxp\Bundle\SeoBundle\OpenDxpSeoBundle"
    2 => "opendxp"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT * FROM redirects WHERE\n
                (\n
                    (source = ? AND (`type` = ? OR `type` = ?)) OR\n
                    (source = ? AND `type` = ?) OR\n
                    (source = ? AND `type` = ?)\n
                ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
    """
  "params" => [
    1 => "/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
    2 => "path"
    3 => "auto_create"
    4 => "/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
    5 => "path_query"
    6 => "https://web-template-basic.a4interactive.ch/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
    7 => "entire_uri"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
  ]
]

[
  "key" => "system_route_redirect"
]

[
  "sql" => "SELECT * FROM tmp_store WHERE id = ?"
  "params" => [
    1 => "maintenance_mode"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "route" => "_opendxp_service_thumbnail"
  "route_parameters" => [
    "_route" => "_opendxp_service_thumbnail"
    "_controller" => "OpenDxp\Bundle\CoreBundle\Controller\PublicServicesController::thumbnailAction"
    "prefix" => "images/14/"
    "type" => "image"
    "assetId" => "14"
    "thumbnailName" => "imageGallery"
    "filename" => "1467072-building-4588121_1920.2e33e022.jpg"
  ]
  "request_uri" => "https://web-template-basic.a4interactive.ch/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
  "method" => "GET"
]

[
  "path" => "/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
  "context" => "default"
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/images/14/image-thumb__14__imageGallery/"
    2 => "1467072-building-4588121_1920.2e33e022.jpg"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/images/14/image-thumb__14__imageGallery/1467072-building-4588121_1920.2e33e022.jpg"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/images/14/"
    2 => "image-thumb__14__imageGallery"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/images/14/image-thumb__14__imageGallery"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/images/"
    2 => "14"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/images/14"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => "images"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ?"
  "params" => [
    1 => "/images"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => ""
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "key" => "document_1"
]

[
  "key" => "document_properties_1"
]

[
  "editmode" => "false"
  "params" => [
    "param" => false
    "adminRequest" => false
    "user" => false
  ]
]

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

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\CustomAdminEntryPointCheckListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\RoutingListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\StaticPageGeneratorListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\SeoBundle\EventListener\RoutingListener::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" => "OpenDxp\Bundle\AdminBundle\EventListener\AdminSessionBagListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\MaintenancePageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\FullPageCacheListener::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" => "OpenDxp\Bundle\CoreBundle\EventListener\OpenDxpContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::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" => "OpenDxp\Bundle\AdminBundle\EventListener\CsrfProtectionListener::handleRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\UserPerspectiveListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\UsageStatisticsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\TranslationDebugListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\BlockStateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\EditmodeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\OutputTimestampListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.controller"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\DocumentFallbackListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\ElementListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\GlobalTemplateVariablesListener::onKernelController"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\EventedControllerListener::onKernelController"
]

[
  "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" => "OpenDxp\Bundle\CoreBundle\EventListener\ResponseHeaderListener::onKernelControllerArguments"
]

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

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

[
  "key" => "asset_14"
]

[
  "sql" => "SELECT customSettings FROM assets WHERE id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP(NOW(6)) + 300)"
  "params" => [
    1 => "ae1209fad9f819e0dd6362eab6609b951320f8d64602cbf0a814aced9cfe4c0e"
    2 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "resource" => Symfony\Component\Lock\Key {#1718
    -expiringTime: 1792318948.5854
    -state: [
      "Symfony\Component\Lock\Store\DoctrineDbalStore" => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
    ]
    -serializable: true
    -resource: "image_thumbnail_14_c80c25b82e6da81044e83d5057d61390"
  }
]

[
  "sql" => "UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP(NOW(6)) + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP(NOW(6)))"
  "params" => [
    1 => 300.0
    2 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
    3 => "ae1209fad9f819e0dd6362eab6609b951320f8d64602cbf0a814aced9cfe4c0e"
    4 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))"
  "params" => [
    1 => "ae1209fad9f819e0dd6362eab6609b951320f8d64602cbf0a814aced9cfe4c0e"
    2 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "resource" => Symfony\Component\Lock\Key {#1718
    -expiringTime: 1792318948.5854
    -state: [
      "Symfony\Component\Lock\Store\DoctrineDbalStore" => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
    ]
    -serializable: true
    -resource: "image_thumbnail_14_c80c25b82e6da81044e83d5057d61390"
  }
  "ttl" => 300.0
]

[
  "key" => "system_resource_columns_assets_image_thumbnail_cache"
]

[
  "sql" => "INSERT INTO assets_image_thumbnail_cache (`cid`, `name`, `filename`, `modificationDate`, `filesize`, `width`, `height`) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 14
    2 => "imageGallery"
    3 => "1467072-building-4588121_1920.2e33e022.jpg"
    4 => 1792318648
    5 => 25913
    6 => 535
    7 => 306
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
  ]
]

[
  "sql" => "DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?"
  "params" => [
    1 => "ae1209fad9f819e0dd6362eab6609b951320f8d64602cbf0a814aced9cfe4c0e"
    2 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP(NOW(6))"
  "params" => [
    1 => "ae1209fad9f819e0dd6362eab6609b951320f8d64602cbf0a814aced9cfe4c0e"
    2 => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "resource" => Symfony\Component\Lock\Key {#1718
    -expiringTime: 1792318948.5854
    -state: [
      "Symfony\Component\Lock\Store\DoctrineDbalStore" => "oqHCUPQdLLujMnxPSaPTH9h1hgWWfhQKHBChgtWpKLQ="
    ]
    -serializable: true
    -resource: "image_thumbnail_14_c80c25b82e6da81044e83d5057d61390"
  }
]

[
  "sql" => "SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\FullPageCacheListener::stopPropagationCheck"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\ResponseHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\ResponseStackListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Provider\TwoFactorProviderPreparationListener::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" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\AdminSecurityListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\AdminBundle\EventListener\EnablePreviewTimeSliderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\OpenDxpHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\LocaleListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\GlobalTemplateVariablesListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\HardlinkCanonicalListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\BlockStateListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\EventedControllerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\EditmodeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\InternalWysiwygHtmlAttributeFilterListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\FullPageCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "OpenDxp\Bundle\CoreBundle\EventListener\Frontend\StaticPageGeneratorListener::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"
]