Symfony Profiler

[
  "sql" => "SELECT * FROM settings_store WHERE id = ? AND scope = ?"
  "params" => [
    1 => "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
    2 => "pimcore"
  ]
  "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 => "/_fragment"
    2 => "path"
    3 => "auto_create"
    4 => "/_fragment?_path=_format=html&_locale=ar&_controller=App%5CController%5CDefaultController%3A%3AlastModifiedDate"
    5 => "path_query"
    6 => "https://devncmpublic.centricdxb.com/_fragment?_path=_format=html&_locale=ar&_controller=App%5CController%5CDefaultController%3A%3AlastModifiedDate"
    7 => "entire_uri"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
  ]
]

[
  "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" => "App\EventSubscriber\AdminHtpasswdBasicAuthSubscriber::onKernelRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "App\EventSubscriber\PimcoreFullPageCacheAuthorizationBypassSubscriber::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"
]

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

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

[
  "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" => "ContainerCOi2k1W\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT COUNT(*) FROM objects WHERE ( objects.type IN ('object','variant','folder')) AND objects.published = 1"
]

[
  "sql" => "SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `modificationDate` DESC   LIMIT 1"
]

[
  "key" => "object_346922"
]

[
  "sql" => "SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?"
  "params" => [
    1 => 346922
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT objects.*, tree_locks.locked as locked FROM objects\n
                LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'\n
                    WHERE objects.id = ?
    """
  "params" => [
    1 => 346922
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_store_MannedAlertLog WHERE oo_id = ? FOR UPDATE"
  "params" => [
    1 => 346922
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT name FROM classes WHERE id = ?"
  "params" => [
    1 => "MannedAlertLog"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM object_relations_MannedAlertLog WHERE src_id = ?"
  "params" => [
    1 => 346922
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM documents WHERE published = 1"
]

[
  "sql" => "SELECT documents.id, documents.type FROM documents WHERE published = 1 ORDER BY `modificationDate` DESC   LIMIT 1"
]

[
  "key" => "document_25"
]

[
  "sql" => """
    SELECT documents.*, tree_locks.locked FROM documents\n
                LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'\n
                    WHERE documents.id = ?
    """
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT documents.*, documents_page.*, tree_locks.locked FROM documents\n
                LEFT JOIN documents_page ON documents.id = documents_page.id\n
                LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'\n
                    WHERE documents.id = ?
    """
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Extendmate\Pimcore\LoginTracker\EventSubscriber\LoginTrackerSubscriber::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" => "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" => "App\EventSubscriber\PimcoreFullPageCacheUnifiedDeviceSubscriber::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" => "App\EventSubscriber\RemoveHeadersSubscriber::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\PimcoreOutputCachePublicCacheControlSubscriber::onKernelResponse"
]

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