Symfony Profiler

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql"
    "port" => 3306
    "user" => "usr_ArdT"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "ardent_db"
    "serverVersion" => "8.0.19"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT 1 FROM phpcr_workspaces WHERE name = ?"
  "params" => [
    1 => "default_live"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT prefix, uri FROM phpcr_namespaces"
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/website/routes/en/job/senior-hydraulic-modeller"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?"
  "params" => [
    1 => "/job/senior-hydraulic-modeller"
    2 => "en"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?"
  "params" => [
    1 => "c5de0951-1517-4686-86fc-ba52d9936950"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/articles/2025/10/senior-hydraulic-modeller"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
    SELECT\n
    phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\n
    phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\n
    phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\n
    phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\n
    phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\n
    phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\n
    phpcr_type_props.on_parent_version AS property_on_parent_version,\n
    phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\n
    phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\n
    phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\n
    phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\n
    phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\n
    phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\n
    phpcr_type_childs.primary_types AS child_primary_types\n
    FROM\n
    phpcr_type_nodes\n
    LEFT JOIN\n
    phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\n
    LEFT JOIN\n
    phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/articles/2025/10"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/articles/2025/10"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.target_id AS target_id_8, r0_.idUsersCreator AS idUsersCreator_9, r0_.idUsersChanger AS idUsersChanger_10 FROM ro_routes r0_ WHERE r0_.entity_class = ? AND r0_.entity_id = ? AND r0_.locale = ? AND r0_.history = 0"
  "params" => [
    1 => "Sulu\Bundle\ArticleBundle\Document\ArticleDocument"
    2 => "c5de0951-1517-4686-86fc-ba52d9936950"
    3 => "en"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.target_id AS target_id_8, r0_.idUsersCreator AS idUsersCreator_9, r0_.idUsersChanger AS idUsersChanger_10 FROM ro_routes r0_ WHERE r0_.entity_class = ? AND r0_.entity_id = ? AND r0_.locale = ? AND r0_.history = 0"
  "params" => [
    1 => "Sulu\Bundle\ArticleBundle\Document\ArticleDocument"
    2 => "c5de0951-1517-4686-86fc-ba52d9936950"
    3 => "en"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "route" => "sulu_route_91"
  "route_parameters" => [
    "object" => Sulu\Bundle\ArticleBundle\Document\ArticleDocument {#3845
      #uuid: "c5de0951-1517-4686-86fc-ba52d9936950"
      #nodeName: "senior-hydraulic-modeller"
      #path: "/cmf/articles/2025/10/senior-hydraulic-modeller"
      #parent: ProxyManagerGeneratedProxy\__PM__\Sulu\Component\DocumentManager\Document\UnknownDocument\Generated1cabbeff6f584f9c30a6fdf3818b6bfa {#4037 …}
      #title: "Senior Hydraulic Modeller"
      #pageTitle: null
      #pages: [
        [
          "uuid" => "c5de0951-1517-4686-86fc-ba52d9936950"
          "title" => "Senior Hydraulic Modeller"
          "routePath" => "/job/senior-hydraulic-modeller"
          "pageNumber" => 1
        ]
      ]
      #route: Sulu\Bundle\RouteBundle\Entity\Route {#3635 …}
      #routePath: "/job/senior-hydraulic-modeller"
      #locale: "en"
      #originalLocale: "en"
      #structureType: "job"
      #structure: Sulu\Component\Content\Document\Structure\ManagedStructure {#4348 …}
      #creator: 7
      #changer: 7
      #created: DateTime @1761317043 {#3833
        date: 2025-10-24 14:44:03.971 +00:00
      }
      #changed: DateTime @1769171045 {#3836
        date: 2026-01-23 12:24:05.257 +00:00
      }
      #lastModified: null
      #author: null
      #authored: DateTime @1761317043 {#3830
        date: 2025-10-24 14:44:03.0 +00:00
      }
      #extensions: Sulu\Component\Content\Document\Extension\ManagedExtensionContainer {#3853 …}
      #workflowStage: 2
      #published: DateTime @1761317043 {#3823
        date: 2025-10-24 14:44:03.985 +00:00
      }
      #versions: []
      #children: Sulu\Component\DocumentManager\Collection\ChildrenCollection {#4350 …}
      #shadowLocaleEnabled: false
      #shadowLocale: null
      #mainWebspace: null
      #additionalWebspaces: null
    }
    "view" => "articles/job"
    "pageNumber" => 1
    "structure" => Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344
      #structure: Sulu\Component\Content\Metadata\StructureMetadata {#4066 …}
      #inspector: Sulu\Bundle\DocumentManagerBundle\Bridge\DocumentInspector {#595 …}
      -loadedProperties: [
        "title" => Sulu\Component\Content\Compat\Property {#4876
          -metadata: Sulu\Component\Content\Compat\Metadata {#4878 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4889 …}
          #types: []
          #properties: []
          -name: "title"
          -contentTypeName: "text_line"
          -mandatory: true
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "headline" => Sulu\Component\Content\Compat\PropertyParameter {#4875
              -name: "headline"
              -value: true
              -type: "string"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4877 …}
            }
          ]
          -tags: [
            "sulu.rlp.part" => Sulu\Component\Content\Compat\PropertyTag {#4879
              -name: "sulu.rlp.part"
              -priority: null
              -attributes: []
            }
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#4880
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "routePath" => Sulu\Component\Content\Compat\Property {#4892
          -metadata: Sulu\Component\Content\Compat\Metadata {#4893 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4903 …}
          #types: []
          #properties: []
          -name: "routePath"
          -contentTypeName: "route"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "route_schema" => Sulu\Component\Content\Compat\PropertyParameter {#4890
              -name: "route_schema"
              -value: "/job/{implode('-', object)}"
              -type: "string"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4891 …}
            }
          ]
          -tags: [
            "sulu_article.article_route" => Sulu\Component\Content\Compat\PropertyTag {#4894
              -name: "sulu_article.article_route"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "form" => Sulu\Component\Content\Compat\Property {#4906
          -metadata: Sulu\Component\Content\Compat\Metadata {#4907 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4915 …}
          #types: []
          #properties: []
          -name: "form"
          -contentTypeName: "single_form_selection"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "resourceKey" => Sulu\Component\Content\Compat\PropertyParameter {#4904
              -name: "resourceKey"
              -value: "article"
              -type: "string"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4905 …}
            }
          ]
          -tags: []
          -colSpan: 12
          #defaultTypeName: null
        }
        "location" => Sulu\Component\Content\Compat\Property {#4920
          -metadata: Sulu\Component\Content\Compat\Metadata {#4921 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4931 …}
          #types: []
          #properties: []
          -name: "location"
          -contentTypeName: "single_select"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "default_value" => Sulu\Component\Content\Compat\PropertyParameter {#4916
              -name: "default_value"
              -value: "service('App\\Content\\Select\\LocationSelect').getSingleSelectDefaultValue()"
              -type: "expression"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4917 …}
            }
            "values" => Sulu\Component\Content\Compat\PropertyParameter {#4918
              -name: "values"
              -value: "service('App\\Content\\Select\\LocationSelect').getValues(locale)"
              -type: "expression"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4919 …}
            }
          ]
          -tags: []
          -colSpan: 6
          #defaultTypeName: null
        }
        "employmentType" => Sulu\Component\Content\Compat\Property {#4944
          -metadata: Sulu\Component\Content\Compat\Metadata {#4945 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4964 …}
          #types: []
          #properties: []
          -name: "employmentType"
          -contentTypeName: "single_select"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "default_values" => Sulu\Component\Content\Compat\PropertyParameter {#4936
              -name: "default_values"
              -value: [
                "full_time" => Sulu\Component\Content\Compat\PropertyParameter {#4932
                  -name: "full_time"
                  -value: null
                  -type: "string"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#4933 …}
                }
                "part_time" => Sulu\Component\Content\Compat\PropertyParameter {#4934
                  -name: "part_time"
                  -value: null
                  -type: "string"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#4935 …}
                }
              ]
              -type: "collection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4937 …}
            }
            "values" => Sulu\Component\Content\Compat\PropertyParameter {#4942
              -name: "values"
              -value: [
                "full_time" => Sulu\Component\Content\Compat\PropertyParameter {#4938
                  -name: "full_time"
                  -value: null
                  -type: "string"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#4939 …}
                }
                "part_time" => Sulu\Component\Content\Compat\PropertyParameter {#4940
                  -name: "part_time"
                  -value: null
                  -type: "string"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#4941 …}
                }
              ]
              -type: "collection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4943 …}
            }
          ]
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#4946
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 6
          #defaultTypeName: null
        }
        "department" => Sulu\Component\Content\Compat\Property {#4965
          -metadata: Sulu\Component\Content\Compat\Metadata {#4966 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4973 …}
          #types: []
          #properties: []
          -name: "department"
          -contentTypeName: "text_line"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#4967
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 6
          #defaultTypeName: null
        }
        "linkedin" => Sulu\Component\Content\Compat\Property {#4978
          -metadata: Sulu\Component\Content\Compat\Metadata {#4979 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4989 …}
          #types: []
          #properties: []
          -name: "linkedin"
          -contentTypeName: "url"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: [
            "schemes" => Sulu\Component\Content\Compat\PropertyParameter {#4976
              -name: "schemes"
              -value: [
                "https://" => Sulu\Component\Content\Compat\PropertyParameter {#4974
                  -name: "https://"
                  -value: null
                  -type: "string"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#4975 …}
                }
              ]
              -type: "collection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#4977 …}
            }
          ]
          -tags: []
          -colSpan: 6
          #defaultTypeName: null
        }
        "description" => Sulu\Component\Content\Compat\Property {#4990
          -metadata: Sulu\Component\Content\Compat\Metadata {#4991 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#4999 …}
          #types: []
          #properties: []
          -name: "description"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#4992
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "summary" => Sulu\Component\Content\Compat\Property {#4998
          -metadata: Sulu\Component\Content\Compat\Metadata {#5000 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#5008 …}
          #types: []
          #properties: []
          -name: "summary"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#5001
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "accountabilities" => Sulu\Component\Content\Compat\Property {#5007
          -metadata: Sulu\Component\Content\Compat\Metadata {#5009 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#5017 …}
          #types: []
          #properties: []
          -name: "accountabilities"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#5010
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "skills" => Sulu\Component\Content\Compat\Property {#5016
          -metadata: Sulu\Component\Content\Compat\Metadata {#5018 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#5026 …}
          #types: []
          #properties: []
          -name: "skills"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#5019
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "knowledge" => Sulu\Component\Content\Compat\Property {#5025
          -metadata: Sulu\Component\Content\Compat\Metadata {#5027 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#5035 …}
          #types: []
          #properties: []
          -name: "knowledge"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#5028
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
        "experience" => Sulu\Component\Content\Compat\Property {#5034
          -metadata: Sulu\Component\Content\Compat\Metadata {#5036 …}
          -value: null
          -structure: Sulu\Bundle\ArticleBundle\Document\Structure\ArticleBridge {#4344}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#5044 …}
          #types: []
          #properties: []
          -name: "experience"
          -contentTypeName: "text_editor"
          -mandatory: false
          -multilingual: true
          -maxOccurs: null
          -minOccurs: null
          -params: []
          -tags: [
            "sulu.search.field" => Sulu\Component\Content\Compat\PropertyTag {#5037
              -name: "sulu.search.field"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          #defaultTypeName: null
        }
      ]
      #locale: null
      -propertyFactory: Sulu\Component\Content\Compat\Structure\LegacyPropertyFactory {#1306 …}
      #document: Sulu\Bundle\ArticleBundle\Document\ArticleDocument {#3845}
      -webspaceKey: null
      -uuid: null
    }
    "_cacheLifetime" => 144000
    "_controller" => "App\Controller\Website\JobArticleController::indexAction"
    "_route" => "sulu_route_91"
  ]
  "request_uri" => "https://e.agileroutes.dev/job/senior-hydraulic-modeller"
  "method" => "GET"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "FOS\RestBundle\EventListener\ZoneMatcherListener::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" => "Sulu\Bundle\WebsiteBundle\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sulu\Bundle\WebsiteBundle\Routing\RequestListener::onRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sulu\Bundle\SecurityBundle\EventListener\SystemListener::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" => "Sulu\Bundle\WebsiteBundle\EventListener\TranslatorListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "FOS\RestBundle\EventListener\BodyListener::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" => "Sulu\Bundle\WebsiteBundle\EventListener\SecurityListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sulu\Bundle\FormBundle\Event\RequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "FOS\HttpCacheBundle\EventListener\AttributesListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sulu\Bundle\MediaBundle\FileInspector\UploadFileSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Sulu\Bundle\FormBundle\Event\ProtectedMediaSubscriber::onRequest"
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sulu\Bundle\SecurityBundle\EventListener\SuluSecurityListener::onKernelController"
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.account_id AS account_id_3 FROM co_account_locations t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
    SELECT\n
    phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\n
    phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\n
    phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\n
    phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\n
    phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\n
    phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\n
    phpcr_type_props.on_parent_version AS property_on_parent_version,\n
    phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\n
    phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\n
    phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\n
    phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\n
    phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\n
    phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\n
    phpcr_type_childs.primary_types AS child_primary_types\n
    FROM\n
    phpcr_type_nodes\n
    LEFT JOIN\n
    phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\n
    LEFT JOIN\n
    phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    \n
    SELECT\n
    phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\n
    phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\n
    phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\n
    phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\n
    phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\n
    phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\n
    phpcr_type_props.on_parent_version AS property_on_parent_version,\n
    phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\n
    phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\n
    phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\n
    phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\n
    phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\n
    phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\n
    phpcr_type_childs.primary_types AS child_primary_types\n
    FROM\n
    phpcr_type_nodes\n
    LEFT JOIN\n
    phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\n
    LEFT JOIN\n
    phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
    """
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/website/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC"
  "params" => [
    1 => "default_live"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order\n
                    FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
    """
  "params" => [
    1 => "default_live"
    2 => "/cmf/website/contents/what-we-do"
    3 => "/cmf/website/contents/our-work"
    4 => "/cmf/website/contents/what-we-do/sectors"
    5 => "/cmf/website/contents/our-company/company-history"
    6 => "/cmf/website/contents/opportunities/why-join-ardent"
    7 => "/cmf/website/contents/our-company"
    8 => "/cmf/website/contents/what-we-do/services"
    9 => "/cmf/website/contents/our-company/meet-the-team"
    10 => "/cmf/website/contents/opportunities/vacancies"
    11 => "/cmf/website/contents/opportunities"
    12 => "/cmf/website/contents/our-company/employee-owned"
    13 => "/cmf/website/contents/opportunities/early-career-professionals"
    14 => "/cmf/website/contents/our-company/making-a-difference"
    15 => "/cmf/website/contents/our-company/a-better-place-to-work"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/website/contents/opportunities/why-join-ardent"
    2 => "/cmf/website/contents/our-company/company-history"
    3 => "/cmf/website/contents/what-we-do"
    4 => "/cmf/website/contents/opportunities/vacancies"
    5 => "/cmf/website/contents/our-company/meet-the-team"
    6 => "/cmf/website/contents/our-work"
    7 => "/cmf/website/contents/our-company"
    8 => "/cmf/website/contents/our-company/employee-owned"
    9 => "/cmf/website/contents/what-we-do/sectors"
    10 => "/cmf/website/contents/opportunities"
    11 => "/cmf/website/contents/our-company/making-a-difference"
    12 => "/cmf/website/contents/our-company/a-better-place-to-work"
    13 => "/cmf/website/contents/what-we-do/services"
    14 => "/cmf/website/contents/opportunities/early-career-professionals"
    15 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/website/contents"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/website/contents"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/website"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/website"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order\n
                FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
    """
  "params" => [
    1 => "default_live"
    2 => "a7b66d3a-0455-4ea1-9604-39df657bd1c5"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/snippets/header/header-button"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/snippets/header"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/snippets/header"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]