Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "idle_connection_ttl" => 600
    "host" => "db"
    "port" => 3306
    "user" => "pimcore"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "mariadb-10.11.7"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_unicode_520_ci"
    ]
    "dbname" => "pimcore"
  ]
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "site_domain_adeed58c813042afcfff7bdb229c9a10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)"
  "params" => [
    1 => 1788867813
    2 => "system\x01tags\x01"
    3 => "site\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1412}
  ]
]

[
  "key" => "site_domain_adeed58c813042afcfff7bdb229c9a10"
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "maintenance_mode"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "key" => "maintenance_mode"
]

[
  "route" => "_pimcore_service_common_files"
  "route_parameters" => [
    "_route" => "_pimcore_service_common_files"
    "_controller" => "Pimcore\Bundle\CoreBundle\Controller\PublicServicesController::commonFilesAction"
    "filename" => "favicon.ico"
  ]
  "request_uri" => "https://pim.demo.kare.design/favicon.ico"
  "method" => "GET"
]

[
  "path" => "/favicon.ico"
  "context" => "default"
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => "favicon.ico"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1412}
  ]
]

[
  "sql" => "SELECT id FROM documents_page WHERE prettyUrl = ? ORDER BY id LIMIT 1"
  "params" => [
    1 => "/favicon.ico"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?"
  "params" => [
    1 => "/"
    2 => ""
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1412}
  ]
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "document_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "document_1\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "key" => "document_1"
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "document_properties_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)"
  "params" => [
    1 => 1788867813
    2 => "\x00tags\x00document_properties_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1403
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

[
  "key" => "document_properties_1"
]

[
  "sql" => """
    SELECT * FROM properties WHERE\n
                                 (\n
                                     (cid IN (1) AND inheritable = 1) OR cid = ?\n
                                 ) AND ctype='document'
    """
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1412
      +name: "STRING"
    }
  ]
]

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\CorsSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\RateLimitSubscriber::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" => "Pimcore\Bundle\CoreBundle\EventListener\MaintenancePageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\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" => "Pimcore\Bundle\CoreBundle\EventListener\PimcoreContextListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\ApiContextSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Pimcore\Bundle\StudioUiBundle\EventSubscriber\EditmodeSubscriber::onKernelRequest"
]

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\Bundle\CustomReport\EventSubscriber\StudioContextPermissionsSubscriber::addContextPermissions"
]

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

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\Bundle\DataHubBundle\EventSubscriber\StudioContextPermissionsSubscriber::addContextPermissions"
]

[
  "event" => "kernel.controller"
  "listener" => "Pimcore\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" => "Pimcore\Bundle\CoreBundle\EventListener\ResponseHeaderListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\SessionCloseSubscriber::onKernelControllerArguments"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\CoreBundle\EventListener\ResponseStackListener::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\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\GenericDataIndexBundle\EventSubscriber\DebugSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\CorsSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\StudioUiBundle\EventSubscriber\EditmodeSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\StudioUiBundle\EventSubscriber\Csp\CspHeaderSubscriber::onKernelResponse"
]

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\StudioBackendBundle\EventSubscriber\RateLimitSubscriber::onKernelResponse"
]

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

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

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