Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "7472c_oakas"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "7472c_oakas"
    "serverVersion" => "8.0.27"
    "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/okas-lane/routes/en/privacy-policy"
    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/okas-lane/routes/en/privacy-policy"
    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" => """
    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 => "4abe7f12-d905-4f1d-bf07-093707b325ad"
  ]
  "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/okas-lane/contents/privacy-policy"
    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/okas-lane/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/okas-lane/contents"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "route" => "privacyPolicy_4abe7f12-d905-4f1d-bf07-093707b325ad"
  "route_parameters" => [
    "_controller" => "Sulu\Bundle\WebsiteBundle\Controller\DefaultController::indexAction"
    "structure" => Sulu\Component\Content\Compat\Structure\PageBridge {#2694
      #structure: Sulu\Component\Content\Metadata\StructureMetadata {#2664 …}
      #document: Sulu\Bundle\PageBundle\Document\PageDocument {#2099 …}
      #inspector: Sulu\Bundle\DocumentManagerBundle\Bridge\DocumentInspector {#434 …}
      -propertyFactory: Sulu\Component\Content\Compat\Structure\LegacyPropertyFactory {#1402 …}
      -loadedProperties: [
        "title" => Sulu\Component\Content\Compat\Property {#2959
          -name: "title"
          -metadata: Sulu\Component\Content\Compat\Metadata {#2956 …}
          -mandatory: true
          -multilingual: true
          -minOccurs: null
          -maxOccurs: null
          -contentTypeName: "text_line"
          -params: [
            "headline" => Sulu\Component\Content\Compat\PropertyParameter {#2931
              -name: "headline"
              -value: true
              -type: "string"
              -metadata: Sulu\Component\Content\Compat\Metadata {#2957 …}
            }
          ]
          -tags: [
            "sulu.rlp.part" => Sulu\Component\Content\Compat\PropertyTag {#2960
              -name: "sulu.rlp.part"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          -value: null
          -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#2967 …}
          #types: []
          #properties: []
          #defaultTypeName: null
        }
        "url" => Sulu\Component\Content\Compat\Property {#2968
          -name: "url"
          -metadata: Sulu\Component\Content\Compat\Metadata {#2969 …}
          -mandatory: true
          -multilingual: true
          -minOccurs: null
          -maxOccurs: null
          -contentTypeName: "resource_locator"
          -params: []
          -tags: [
            "sulu.rlp" => Sulu\Component\Content\Compat\PropertyTag {#2970
              -name: "sulu.rlp"
              -priority: null
              -attributes: []
            }
          ]
          -colSpan: 12
          -value: null
          -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#2977 …}
          #types: []
          #properties: []
          #defaultTypeName: null
        }
        "blocks" => Sulu\Component\Content\Compat\Block\BlockProperty {#2978
          -name: "blocks"
          -metadata: Sulu\Component\Content\Compat\Metadata {#2979 …}
          -mandatory: false
          -multilingual: true
          -minOccurs: null
          -maxOccurs: null
          -contentTypeName: "block"
          -params: []
          -tags: []
          -colSpan: 12
          -value: null
          -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
          #propertyValue: Sulu\Component\Content\Document\Structure\PropertyValue {#3019 …}
          #types: [
            "heroSection" => Sulu\Component\Content\Compat\Block\BlockPropertyType {#2980
              -name: "heroSection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#2981 …}
              -childProperties: [
                Sulu\Component\Content\Compat\Property {#2982
                  -name: "heroSectionSubTitle"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2983 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_line"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: null
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#2984
                  -name: "heroSectionTitle"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2985 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_line"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: null
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#2986
                  -name: "heroSectionDescription"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2987 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_editor"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: null
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#2988
                  -name: "heroSectionImage"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2989 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "single_media_selection"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: null
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
              ]
              -settings: []
            }
            "privacyPolicySection" => Sulu\Component\Content\Compat\Block\BlockPropertyType {#2990
              -name: "privacyPolicySection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#2991 …}
              -childProperties: [
                Sulu\Component\Content\Compat\Property {#2992
                  -name: "description"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2993 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_editor"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: null
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
              ]
              -settings: []
            }
          ]
          #properties: [
            Sulu\Component\Content\Compat\Block\BlockPropertyType {#3020
              -name: "heroSection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#2981 …}
              -childProperties: [
                Sulu\Component\Content\Compat\Property {#3017
                  -name: "heroSectionSubTitle"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2983 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_line"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: "OAKS LANE"
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#3018
                  -name: "heroSectionTitle"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2985 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_line"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: "Privacy Policy"
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#3015
                  -name: "heroSectionDescription"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2987 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_editor"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: ""
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
                Sulu\Component\Content\Compat\Property {#3016
                  -name: "heroSectionImage"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2989 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "single_media_selection"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: [
                    "displayOption" => null
                    "id" => 25
                  ]
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
              ]
              -settings: {#3026 …}
            }
            Sulu\Component\Content\Compat\Block\BlockPropertyType {#3031
              -name: "privacyPolicySection"
              -metadata: Sulu\Component\Content\Compat\Metadata {#2991 …}
              -childProperties: [
                Sulu\Component\Content\Compat\Property {#3032
                  -name: "description"
                  -metadata: Sulu\Component\Content\Compat\Metadata {#2993 …}
                  -mandatory: false
                  -multilingual: true
                  -minOccurs: null
                  -maxOccurs: null
                  -contentTypeName: "text_editor"
                  -params: []
                  -tags: []
                  -colSpan: 12
                  -value: "<p><strong>1. INTRODUCTION</strong></p><p style="text-align:justify;">By accessing our website, you are likely to provide us with data such as: your name and surname (physical person), business name (legal person), residence and home address or your postal address, your home office, your e-mail address, your profession and professional status (employee or self-employed), your function within your company, your age and gender, and the IP address from which you connected to the Internet. These data and their processing are protected by the Swiss Federal Law on Data Protection of June 19, 1992 (LPD) and, to the extent applicable, by the new General Data Protection Regulation (GDPR) entered into force on May 25, 2018. Data protection is a key concern for us. This privacy statement is intended to help you understand how we may use the data you provide to us as a user of our site.</p><p><strong>2. LEGAL BASIS</strong></p><p style="text-align:justify;">This privacy policy is based on the Federal Data Protection Act (FADP) and the European General Data Protection Regulation (GDPR) entered into force on May 25, 2018</p><p><strong>3. UPDATE</strong></p><p style="text-align:justify;">Our privacy policy may require periodic updates, including as part of the evolving regulatory framework for data protection. We invite you to check this page regularly to make sure you have read the latest version.</p><p>Last update: 18<sup>th</sup>&nbsp;of December 2022</p><p><strong>4. OUR SITE URL</strong></p><p>www.oakslane.ch&nbsp;</p><p><strong>5. DEFINITIONS</strong></p><p style="text-align:justify;"><strong>Personal data</strong></p><p style="text-align:justify;">Any information relating to an identified or identifiable natural person (data subject). In particular by reference to an identifier such as the name, the first name or the address, the email, the telephone number, etc.</p><p style="text-align:justify;"><strong>CMS</strong></p><p style="text-align:justify;">CMS is the acronym for Content Management System. This is the system for managing the content displayed on a website.</p><p style="text-align:justify;"><strong>Consent</strong></p><p style="text-align:justify;">Consent means any freely given, specific, informed and unambiguous indication of the data subject’s wishes by which he or she, by a statement or by a clear affirmative action, signifies agreement to the processing of personal data relating to him or her.</p><p style="text-align:justify;"><strong>Cookies</strong></p><p style="text-align:justify;">A cookie is a text file that the site you are visiting stores on the hard disk or in the browser memory of the computer that you use to access the internet. A cookie allows your computer to store various technical data allowing the general control of public access to a site (number of visits, duration of the visit, connection to other sites, etc.) or the customisation of the displayed pages for your next interactions with the same site (your account, the most visited pages, etc.)</p><p style="text-align:justify;"><strong>Privacy Impact Assessment (PIA)</strong></p><p style="text-align:justify;">A PIA is a detailed study to establish the risk to privacy that a personal data processing could have on the privacy of the data subject should an incident occur.</p><p style="text-align:justify;"><strong>Purpose of processing</strong></p><p style="text-align:justify;">The purpose of processing is the reason why the data is collected.</p><p style="text-align:justify;"><strong>Plugins&nbsp;</strong></p><p style="text-align:justify;">A plugin or plug-in is a computer program designed to add functionality to other software (called host software). For example, the buttons of social networks. Equivalent terms; "Plug-in", "Add in", "Add on".</p><p style="text-align:justify;"><strong>Data subject</strong></p><p style="text-align:justify;">Any natural person subject to a processing of personal data.</p><p style="text-align:justify;"><strong>Controller</strong></p><p style="text-align:justify;">The controller is the natural person or legal person on whose behalf the treatment is carried out. It determines alone or jointly the purposes of the treatment.</p><p style="text-align:justify;"><strong>Processor</strong></p><p style="text-align:justify;">The processor is any natural or legal person, public authority, service or other body that processes personal data on behalf of the controller. For example, a web host or an online service provider.</p><p style="text-align:justify;"><br><strong>Tag</strong></p><p style="text-align:justify;">Tag or HTML tags are the basic elements of the HTML coding of a web page. They are invisible to the user (except by activating the display of the source code). They are interpreted by the browser for the composition of the page. They allow the formatting and structuring of content and some are specifically taken into account by the algorithms of search engines for setting the score of the page on a query and the return of results.</p><p style="text-align:justify;"><strong>Processing</strong></p><p style="text-align:justify;">Any transaction or set of transactions involving personal data, whether or not performed using automated processes, including the collection, recording, organisation, retention, adaptation, modification extraction, consultation, use, communication by transmission, dissemination or any other form of provision, reconciliation or interconnection and limitation, erasure or destruction.</p><p><strong>6. PROCESSING YOUR DATA</strong></p><p style="text-align:justify;">We only process data that you choose to transmit to us and for which you explicitly consent to the treatment.</p><p><strong>Contact form</strong></p><p>Through our website, you can fill out a contact form. The following personal data will be requested:</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Last name</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; First Name</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E-mail</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Address</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Phone number</p><p style="text-align:justify;">You have the opportunity to write a message related to your contact request. We recommend that you remain concise in your message and not provide us with any personal information.</p><p style="text-align:justify;"><strong>Newsletter</strong></p><p style="text-align:justify;">You can also choose to receive our newsletter by ticking the option provided for this purpose. You will then receive a request for consent by email which will clearly indicate the purposes of processing your personal data that you can accept or refuse selectively. If you have subscribed to our newsletter and do not wish to receive it anymore, you can unsubscribe by clicking on the "unsubscribe" link at the bottom of the newsletter. By doing so, you will receive an automatic confirmation of unsubscription and your data will be automatically deleted from the file provided for this purpose.</p><p><strong>7. PURPOSES OF TREATMENT</strong></p><p style="text-align:justify;">We treat your data only in order to best meet your expectations. By collecting some of your personal data, two purposes stand out:</p><ul><li><strong>Operational purposes</strong></li></ul><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Respond to requests for contacts or information</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Establishment of an offer(s)</p><ul><li><strong>Marketing purposes</strong></li></ul><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sending newsletters</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sending commercial offers</p><p><strong>8. DURATION OF CONSERVATION OF PERSONAL DATA</strong></p><p style="text-align:justify;">Your data is stored in our systems for the time necessary for the intended treatment. After processing, the data is archived and anonymised or destroyed.</p><p><strong>9. TRANSFER OF YOUR DATA</strong></p><p style="text-align:justify;">To process your data, as well as for the maintenance and support of our IT systems, we use subcontractors (service providers) based in Switzerland and abroad. When the servers of our subcontractors are located abroad we ensure that they are located in a state whose data protection legislation is equivalent to the FADP and the GDPR and that our subcontractors apply organisational and technical measures consistent with the FADP and the GDPR. As part of the implementation of this privacy policy, we use subcontractors, processors based in Switzerland and abroad to execute our various data processing. We draw your attention to the fact that the servers of our subcontractors, processors may be located in states whose legislation does not include data protection rules appropriate or equivalent to the LPD or the GDPR. If this is the case, we ensure that our subcontractors, processors, provide data protection safeguards and that they apply equivalent or GDPR-compliant standards, regardless of the geolocation of their servers.</p><p><strong>10. DATA PROTECTION MEASURES</strong></p><p style="text-align:justify;">We strive to maintain a high level of security in the collection, processing and retention of data by relying on organisational and technical measures and taking the necessary precautions regarding the nature of the personal data that you are likely to communicate to us and the risks presented by their treatment in order to preserve its security and prevent such that they are altered, damaged, destroyed or that unauthorised third parties have access to it.</p><p><strong>11. COOKIES &amp; PLUGINS</strong></p><p style="text-align:justify;">Our web site uses plugins and cookies that may automatically record information. Their use aims to make the use of the site more pleasant by improving its ergonomics from the data collected. This data can also be used for statistical measurement, user behaviour analysis and geolocation analysis, in order to personalise our commercial offer. When you browse our site, the computer you use will interact with a server that provides all the requested resources by automatically saving each operation to a specific file in which the computer used is identified by its IP address. This is how the browser that you use gives us some standard data, including the browser used and its features, the operating system of the computer, tablet or smartphone used, third-party sites (Facebook, Linkedin etc.) from which you may have logged in as well as the dates and times of access to our site. This data and in particular the IP address from which you logged in do not allow us to identify you by name.</p><p><strong>Marketing analysis and targeting plugins</strong></p><p style="text-align:justify;">Our site uses marketing analysis and targeting services. His services use cookies. The data generated by the cookie about your use of the website, including your IP address is transmitted and stored on servers that may be located abroad, including in a country offering a lower level of data protection compared to Switzerland or the European Union. The provider will use this information for the purpose of evaluating your use of the site, compiling reports on website activity and providing other services relating to website activity and internet usage. The supplier is likely to communicate this data to third parties in case of legal obligation or when these third parties process these data for their own account, including in particular the publisher of the site.&nbsp;</p><p style="text-align:justify;">Our site uses the following analytics and advertising services:</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Smartlook de Smartsupp.com, s.r.o</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Google Universal 4 from Google Inc.&nbsp;</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Google Maps de Google Inc.</p><p><strong>Plugins of social networks</strong></p><p style="text-align:justify;">Our website uses social plugins ("plugins"). These plugins are marked with logos. If you open a page of our website containing one of these plugins, your Internet browser then establishes a direct link with the servers of the social network concerned. The content of the plugin is directly transmitted by the social network concerned to your Internet browser and integrated into the web page by it. Thanks to the inclusion of cookies on the pages of our site, the social network concerned is informed that you have consulted one or more pages of our website. If you are connected to a social network when you visit our site, it is able to attribute your visit to our site to your account at home. If you interact with plugins, eg. By clicking on the "Like" button or by entering a comment, the corresponding information is sent directly by your Internet browser to the social network and saved on their servers. To know the purposes and scope of the collection and processing of data by the social networks of which you are a member, as well as your rights in this area and the possibilities of setting up your account to protect your privacy, we recommend that you consult their privacy policy.</p><p>The following social plugins are installed on our site:</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Plus.google.com de Google Inc.</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Facebook.com de Facebook Inc.</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Linkedin.com de Linkedin Corporation</p><p>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Twitter.com de Twitter Inc.</p><p><strong>12. MEANS YOU HAVE TO CONTROL YOUR TRACES</strong></p><p style="text-align:justify;">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; You have the option to disable plugins and cookies via the console provided for this purpose. This is accessible through the cookies banner that appears on the bottom of the home page when you visit our website. To customise or disable plugins and cookies, select the "customise" button.</p><p style="text-align:justify;">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Recent versions of the main browsers allow not only to oppose the registration of cookies but also to perform browsing sessions at the end of which all cookies installed during this session are automatically deleted regardless of their lifespan provided, thus providing better protection for traces.</p><p><strong>13. YOUR RIGHTS</strong></p><p><strong>Right of information</strong></p><p style="text-align:justify;">You have the right to be informed about your personal data, including the nature of the data and the purpose of the processing.</p><p><strong>Right to access data</strong></p><p>You have the right to request access to your data at any time.</p><p><strong>Right to rectify data</strong></p><p>You have the right to request the correction or updating of your data.</p><p><strong>Right to data erasure (Right to be forgotten)</strong></p><p style="text-align:justify;">Under the GDPR EU nationals can request the complete and definitive erasure of their data. In order to apply the measures that are most favorable to you, we extend this right to Swiss residents.</p><p><strong>Right of limitation of data processing</strong></p><p style="text-align:justify;">You have the right to limit the processing of your data, particularly as regards the nature, purpose and duration of processing.</p><p><strong>Right to portability of data (transmitted to a third party on your instruction)</strong></p><p style="text-align:justify;">Under the GDPR, EU nationals have the right to request that their data be passed on to third parties. In order to apply the measures that are most favorable to you, we extend this right to Swiss residents.</p><p><strong>Right to oppose data processing</strong></p><p>You have the right to oppose at any time the processing of your data.</p><p><strong>Right not to be subject to an automated individual decision</strong></p><p style="text-align:justify;">You have the right not to be subject to a decision resulting exclusively from automated processing that has legal effects that affect you or affect you significantly. Profiling is expressly included.</p><p><strong>14. EXERCISE YOUR RIGHTS &amp; INFORMATION</strong></p><p style="text-align:justify;">You can exercise your rights or request information by contacting us via the email address contact@oakslane.ch or by post to the address below. We will do what is necessary to answer you as soon as possible.</p><p>Data controller:&nbsp;OAKS LANE SA</p><p>Address:&nbsp;Quai Gustave-Ador 62 -&nbsp;1207 Geneva - Switzerland</p>"
                  -structure: Sulu\Component\Content\Compat\Structure\PageBridge {#2694}
                  #propertyValue: null
                  #types: []
                  #properties: []
                  #defaultTypeName: null
                }
              ]
              -settings: {#3030 …}
            }
          ]
          #defaultTypeName: "heroSection"
        }
      ]
      #locale: null
    }
    "partial" => false
    "_route" => "privacyPolicy_4abe7f12-d905-4f1d-bf07-093707b325ad"
  ]
  "request_uri" => "http://oakas-lane.ewm.dev/en/privacy-policy"
  "method" => "GET"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                  SELECT * FROM phpcr_nodes\n
                  WHERE path = ?\n
                    AND workspace_name = ?\n
                  ORDER BY depth, sort_order ASC
    """
  "params" => [
    1 => "/cmf/okas-lane"
    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/okas-lane"
    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 => "4db61803-c733-49e4-b340-121c480e2726"
  ]
  "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/logos/logos"
    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/logos"
    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/logos"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
  "params" => [
    1 => 95
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
  "params" => [
    1 => 96
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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()="topLeft"]) > 0')) AND n0.path LIKE '/cmf/okas-lane/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 = ?) ORDER BY sort_order ASC
    """
  "params" => [
    1 => "default_live"
    2 => "/cmf/okas-lane/contents/agency"
    3 => "/cmf/okas-lane/contents/services"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

[
  "sql" => "SELECT DATABASE()"
]

[
  "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()="topRight"]) > 0')) AND n0.path LIKE '/cmf/okas-lane/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 = ?) ORDER BY sort_order ASC
    """
  "params" => [
    1 => "default_live"
    2 => "/cmf/okas-lane/contents/news"
    3 => "/cmf/okas-lane/contents/contact"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/okas-lane/contents/news"
    2 => "/cmf/okas-lane/contents/contact"
    3 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 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 => "4b290c7f-44c0-4b4b-81dd-6d6586924d06"
  ]
  "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/ContactInformations/contact-informations"
    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/ContactInformations"
    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/ContactInformations"
    2 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ?"
  "params" => [
    1 => 37
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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()="burger"]) > 0')) AND n0.path LIKE '/cmf/okas-lane/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 = ?) ORDER BY sort_order ASC
    """
  "params" => [
    1 => "default_live"
    2 => "/cmf/okas-lane/contents/projects"
    3 => "/cmf/okas-lane/contents/estimate"
    4 => "/cmf/okas-lane/contents/faq"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC"
  "params" => [
    1 => "/cmf/okas-lane/contents/projects"
    2 => "/cmf/okas-lane/contents/estimate"
    3 => "/cmf/okas-lane/contents/faq"
    4 => "default_live"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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()="footer"]) > 0')) AND n0.path LIKE '/cmf/okas-lane/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
  ]
]