Symfony Profiler

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "UTF8MB4"
    "host" => "localhost"
    "port" => 3306
    "user" => "pimcore"
    "password" => "<redacted>"
    "dbname" => "pimcore"
    "idle_connection_ttl" => 600
    "driverOptions" => [
      1002 => "SET sql_mode = '';"
    ]
    "serverVersion" => "8.0.45-0ubuntu0.24.04.1"
    "defaultTableOptions" => [
      "charset" => "UTF8MB4"
      "engine" => "InnoDB"
      "collate" => "utf8mb4_unicode_520_ci"
    ]
  ]
]

[
  "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 => 1774815268
    2 => "maintenance_mode"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "key" => "maintenance_mode"
]

[
  "route" => "pimcore_admin_dataobject_dataobject_gridproxy"
  "route_parameters" => [
    "_route" => "pimcore_admin_dataobject_dataobject_gridproxy"
    "_controller" => "Pimcore\Bundle\AdminBundle\Controller\Admin\DataObject\DataObjectController::gridProxyAction"
  ]
  "request_uri" => "https://pim.prostopromo.com.ua/admin/object/grid-proxy?_dc=1774815268192&classId=2&folderId=6&xaction=read"
  "method" => "POST"
]

[
  "path" => "/admin/object/grid-proxy"
  "context" => "admin"
]

[
  "key" => "_security_pimcore_admin"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "sql" => "SELECT * FROM users WHERE `type` = ? AND id = ?"
  "params" => [
    1 => "user"
    2 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1433}
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_asset WHERE userId = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_document WHERE userId = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT * FROM users_workspaces_object WHERE userId = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "provider" => "Pimcore\Security\User\UserProvider"
  "username" => "admin"
]

[
  "firewall_name" => "pimcore_admin"
  "authenticators" => 3
]

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

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

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

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

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

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

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

[
  "user" => "admin"
  "perspective" => "default"
]

[
  2
  "pimcore_admin_dataobject_dataobject_gridproxy"
  []
  [
    "classId" => "2"
    "folderId" => "6"
    "xaction" => "read"
    "language" => "en"
    "class" => "Category"
    "only_direct_children" => "false"
    "query" => ""
    "page" => "1"
    "start" => "0"
    "limit" => "25"
  ]
]

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

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

[
  "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" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

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

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

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

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

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

[
  "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" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "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" => "ContainerDztCiQz\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "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 => 1774815268
    2 => "object_6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +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 => 1774815268
    2 => "object_6\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "key" => "object_6"
]

[
  "sql" => "SELECT `id`, `name` FROM classes WHERE id = ? "
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder') ORDER BY `id` ASC   LIMIT 25"
]

[
  "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 => 1774815268
    2 => "object_12"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +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 => 1774815268
    2 => "object_12\x01tags\x01"
    3 => "class_2\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1433}
  ]
]

[
  "key" => "object_12"
]

[
  "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 => 1774815268
    2 => "object_18"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +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 => 1774815268
    2 => "object_18\x01tags\x01"
    3 => "class_2\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1433}
  ]
]

[
  "key" => "object_18"
]

[
  "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 => 1774815268
    2 => "object_1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +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 => 1774815268
    2 => "object_1\x01tags\x01"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1420
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "key" => "object_1"
]

[
  "sql" => "SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1"
  "params" => [
    1 => "/Categories/electronics/%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM tree_locks WHERE id IN (1,6) AND `type`='object' AND locked = 'propagate' LIMIT 1"
]

[
  "sql" => "SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE ? AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1"
  "params" => [
    1 => "/Categories/phone/%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1433
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT id FROM tree_locks WHERE id IN (1,6) AND `type`='object' AND locked = 'propagate' LIMIT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder')"
]

[
  "key" => "_security_pimcore_admin"
]

[
  "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" => "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" => "Pimcore\Bundle\AdminBundle\EventListener\AdminSecurityListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Pimcore\Bundle\AdminBundle\EventListener\EnablePreviewTimeSliderListener::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\EditmodeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Pimcore\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" => "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" => "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"
]