Symfony Profiler

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "defaultSiteConfig"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'defaultSiteConfig'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  1
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT name FROM classes WHERE id = ?

[
  "SiteConfig"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SiteConfig';

SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC

[
  "mainBlogPortal"
  null
  null
]

SELECT
  *
FROM
  website_settings
WHERE
  name = ?
  AND (
    siteId IS NULL
    OR siteId = 0
    OR siteId = ?
  )
  AND (
    language IS NULL
    OR language = ''
    OR language = ?
  )
ORDER BY
  CONCAT(siteId, language) DESC,
  siteId DESC,
  language DESC

SELECT *
            FROM website_settings
            WHERE name = 'mainBlogPortal'
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = NULL
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = NULL
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;

SELECT * FROM website_settings WHERE id = ?

[
  8
]

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 8;

SELECT name FROM classes WHERE id = ?

[
  "BlogPortal"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'BlogPortal';

SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC

[
  "sourcePath" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
  "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1580740&nearbySearchLat=47.38108&nearbySearchLong=15.17938&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1580740&nearbySearchLat=47.38108&nearbySearchLong=15.17938&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = :sourcePath
      AND (
        `type` = :typePath
        OR `type` = :typeAuto
      )
    )
    OR (
      source = :sourcePathQuery
      AND `type` = :typePathQuery
    )
    OR (
      source = :sourceEntireUri
      AND `type` = :typeEntireUri
    )
  )
  AND active = 1
  AND regex IS NULL
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite = '6'
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1580740&nearbySearchLat=47.38108&nearbySearchLong=15.17938&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1580740&nearbySearchLat=47.38108&nearbySearchLong=15.17938&sorting=nearbySearchAsc' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "reports"
  "scope" => "pimcore"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Unterkuenfte"
  "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1

[]

SELECT
  id
FROM
  targeting_target_groups
UNION
SELECT
  id
FROM
  targeting_rules
LIMIT
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT name FROM classes WHERE id = ?

[
  "21"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '21';

SELECT * FROM documents_editables WHERE documentId = ?

[
  7159
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7159;

SELECT name FROM classes WHERE id = ?

[
  "31"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '31';

SELECT name FROM classes WHERE id = ?

[
  "59"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '59';

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1

[]

select
  o_id,
  contentScore,
  priority,
  bookable
from
  object_8
where
  o_published = 1

select o_id,contentScore,priority,bookable  from object_8 where o_published = 1;

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  11189
]

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11189 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

SELECT name FROM classes WHERE id = ?

[
  "72"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '72';

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

[
  11408
]

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  (
    o_parentId = ?
    AND objects.o_type IN ('object', 'folder')
  )
  AND objects.o_published = 1
ORDER BY
  `o_key` ASC

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 11408 AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC  ;

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL

[]

select
  o_id as id,
  position__longitude as lon,
  position__latitude as lat
from
  object_8
WHERE
  position__longitude IS NOT NULL
  AND position__latitude IS NOT NULL

select o_id as id, position__longitude as lon,  position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL;

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT * FROM translations_messages LIMIT 1;

[]

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT name FROM classes WHERE id = ?

[
  "Region"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Region';

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT sourceId FROM documents_translations WHERE id = ?

[
  7159
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 7159;

SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7159
  7159
  7159
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(7159, 7159) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;

SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7930
  7930
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId = ?
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId = 7930 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Urlaub-planen"
  "path" => "/de/Schladming-Dachstein/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/de/Schladming-Dachstein/' AND `key` = BINARY 'Urlaub-planen';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/de/Schladming-Dachstein/Urlaub-planen"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein/Urlaub-planen';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "Schladming-Dachstein"
  "path" => "/de/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/de/' AND `key` = BINARY 'Schladming-Dachstein';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de/Schladming-Dachstein"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de/Schladming-Dachstein';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/de/Schladming-Dachstein"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Schladming-Dachstein';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => "de"
  "path" => "/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'de';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/de"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/de';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  "/de"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de';

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/steiermark.com/%"
  ""
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '';

SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key

[
  "key" => ""
  "path" => "/"
]

SELECT
  id
FROM
  documents
WHERE
  path = BINARY :path
  AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT id FROM settings_store WHERE scope = ?

[
  "pimcore_staticroutes"
]

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "1"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "2"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '2' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "3"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '3' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "4"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '4' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "5"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '5' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "6"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '6' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "7"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '7' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "8"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '8' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "9"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '9' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "10"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '10' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "11"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '11' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "12"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '12' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "13"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '13' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "15"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '15' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "16"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '16' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "17"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '17' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "18"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '18' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "19"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '19' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "20"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '20' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "21"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '21' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "22"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '22' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "23"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '23' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "24"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '24' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "25"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '25' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "26"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '26' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "27"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '27' AND scope = 'pimcore_staticroutes';

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "28"
  "scope" => "pimcore_staticroutes"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = '28' AND scope = 'pimcore_staticroutes';

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 1524019
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1524019;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT id FROM sites

[]

SELECT
  id
FROM
  sites

SELECT id FROM sites;

SELECT name FROM classes WHERE id = ?

[
  "AlpsteinTour"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'AlpsteinTour';

SELECT name FROM classes WHERE id = ?

[
  "8"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '8';

SELECT name FROM classes WHERE id = ?

[
  "18"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '18';

SELECT name FROM classes WHERE id = ?

[
  "51"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '51';

SELECT name FROM classes WHERE id = ?

[
  "30"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '30';

SELECT name FROM classes WHERE id = ?

[
  "68"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '68';

SELECT * FROM documents_editables WHERE documentId = ?

[
  8152
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 8152;

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC

[
  5882755
  "datepickerInfoTexts"
]

SELECT
  *
FROM
  object_collection_demiDatePickerInfoText_21
WHERE
  o_id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = 5882755 AND fieldname = 'datepickerInfoTexts' ORDER BY `index` ASC;

SELECT * FROM documents_editables WHERE documentId = ?

[
  6887
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 6887;

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

[
  "id" => "footer-logo"
  "scope" => "pimcore_image_thumbnails"
]

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'footer-logo' AND scope = 'pimcore_image_thumbnails';

SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid

[
  "cid" => 3189171
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = :cid

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3189171;

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(1)

[]

SELECT
  dacco.isTop,
  dacco.bookable,
  dacco.oo_id oo_id
FROM
  `steiermark`.object_8 dacco
WHERE
  dacco.o_published = 1
  AND (
    dacco.town__id IN (
      11195, 11196, 11191, 11194, 11190, 3192509,
      11197, 11409
    )
  )
GROUP BY
  dacco.oo_id
ORDER BY
  RAND(1)

SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(1) ;

SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
              FROM    `steiermark_vacancies`.price_template pt
                   INNER JOIN
                      `steiermark_vacancies`.price_template_base_prices bp
                   ON bp.price_template_id = pt.id
             WHERE     pt.acco_id IN (254574,255823,9700382,229095,107057,106040,75414,91777,170725,22892603,114786,262376,80881,199275,74757,212020,91383,264448,187073,103499,134094,211891,147869,266061,212066,145258,227403,158648,39995931,108052,156882,245659,136526,145614,145685,154821,202896,7780777,125397,155984,242014,170790,382743,145494,222266,73645,4791488,108664,4061779,210718,44869050,102558,172344,228081,197310,109501,179767,192284,181884,245784,228125,171116,12253627,147033,149007,247967,212164,138437,150008,84693,226215,200126,244970,191210,145830,250387,189874,109234,231694,178599,72773,149642,8695139,218293,87340,99114,89565,182314,196171,208109,171978,115150,154608,5315087,177157,383578,79212,267023,176897,1173892,101873,97682,182728,9700325,228856,260387,178962,9395965,198994,3224895,159735,98309,262579,219157,168086,203729,101798,185888,228572,141729,166311,103365,41214843,180387,242919,251865,190401,179813,185208,21237158,147609,240971,228197,126702,178677,174987,186209,162257,418173,21211748,47202201,180717,161664,168884,197713,74427,223395,250658,207430,90455,208831,125739,78974,257470,72611,202554,13400949,240386,223285,81720,10655859,245240,81984,113408,207780,181045,23945599,263186,136036,190546,118447,79610,265255,195558,15668814,211686,174091,143537,147191,115132,110779,183391,254301,3176489,109827,2977929,133247,117802,124694,88291,26648317,245836,107672,21161019,256037,119809,75898,9282725,224332,38050667,44224029,219765,90791,99420,118392,4442181,80940,265066,166123,139252,204651,170518,142897,226499,164573,173273,193837,147969,183290,144517,157149,148079,130267,160845,196249,213537,154051,5160340,150639,130026,199295,84906,76562,213283,33664677,22568743,383118,157428,145003,183075,7967625,174798,213869,209807,225007,21273299,383826,262837,149098,72528,128321,150724,164436,220914,125055,261487,107364,118621,212320,265305,27076239,209213,267186,259359,91679,4580718,115484,4442214,143202,384050,120394,229314,129814,180007,186236,146129,176068,383292,257732,90162,135829,229645,183531,265965,3118747,261158,227765,85349,115545,266661,41796413,104583,382988,4061468,135012,227481,188163,111003,383286,269473,20059276,166076,197835,191937,73689,4442184,114251,241089,100207,2470567,95652,80548,267678,3411816,163692,143682,244552,208902,73395,185598,251659,218235,244956,164627,79926,195022,240156,128612,117438,246876,222458,162948,206854,226049,117646,188477,4061851,156762,76900,14557855,103592,20512295,75009,247897,115416,29649833,155598,41680612,198380,143950,186795,88601,74030,73343,17058949,242964,2367452,174338,1173158,108105,6771981,94404,218076,224525,171224,151492,160614,218867,77357,202479,162969,26898515,18810410,195136,198187,261943,8566620,162361,198814,41024653,142948,227647,199975,110254,154301,218521,11367104,383256,213063,209589,125661,87518,246469,89886,144112,5957905,190383,181278,130455,190819,111091,169612,43751656,195386,171085,88890,238918,105369,154758,187757,83605,100524,7941416,106445,107555,244042,4791491,147152,79424,191428,203636,219804,202099,102814,134210,3379819,91582,149059,84605,129096,228288,112984,140833,218423,269658,228789,191407,162100,256266,120883,134133,114320,120627,267851,86434,107859,193372,192523,155356,139824,121533,178916,148211,194917,176727,34037741,132704,162327,83126,81639,92309,133887,160203,1173353,145409,383360,35241603,268018,179886,51216654,243999,5315068,240436,90672,27808362,157401,110677,128888,31215812,250245,204855,26244429,219501,4061616,2566227,383006,146703,255495,180136,30148041,7715980,206198,10039806,198498,110435,90325,256958,182441,178500,125266,106770,212715,252832,4791485,164711,142528,175232,228246,250829,174941,244711,200906,203394,77540,227270,89972,27808188,223044,86586,263121,262061,213843,130799,9517217,115753,129031,13377190,176992,148975,87124,108520,80793,85117,250696,38621717,384041,31419712,162656,77134,135953,96500,221173,73556,201802,174544,156724,96112,35522295,130955,128777,156225,257803,42358761,225195,189617,164198,383139,17877742,260687,86366,128254,202441,31719532,101260,129206,249659,1173254,204204,220348,205199,116231,74473,9290160,150197,163958,101969,204776,131774,15659243,156556,204745,208283,212689,7016779,110374,89261,132963,120483,263995,127120,262167,80315,154459,9517247,221094,34719290,198592,94870,90285,1173491,177240,268711,108780,205363,263475,265584,220948,165805,203485,115604,206964,179735,121323,195537,212929,191815,199934,31077769,200772,261338,37667633,228314,267530,151587,250060,220483,145447,227732,122527,213326,204161,119097,38622028,149216,116102,8722785,22882595,89456,209445,250318,158547,243956,260733,80345,187911,218829,203308,87970,170902,244217,201789,254825,203617,225267,178544,242815,197565,182482,207942,206894,261005,178337,214433,154873,172317,141562,90363,146397,107023,128052,261973,91149,194960,104781,168651,74534,130741,220693,141808,84542,210702,240646,23455826,114734,72244,170765,264308,192804,89073,4061962,186869,98143,78778,138609,267501,178215,98021,151636,176678,260613,144028,139146,246306,37366700,155523,8388408,260943,201425,151300,195752,208746,176244,133017,199742,132768,98451,108989,193028,128992,102976,259743,148602,168114,110467,98483,140325,229144,187460,74091,169035,139042,209194,265378,176457,255957,119029,204973,89549,157061,144833,209292,132281,91299,141472,14669428,179171,95803,192660,201863,109732,243243,6614248,103833,213358,168606,212729,186921,169959,101549,81217,84734,88121,169666,75106,82308,170268,192033,146288,136181,191455,214424,214015,199700,245886,115902,111742,227572,98180,142776,383672,171164,213047,134322,21308116,143260,102697,262617,79030,33267404,212576,245508,121463,207573,4149175,211808,157541,220655,139671,74297,98382,222990,139639,20627345,102372,241827,229397,185045,151225,13818591,268989,206591,46236871,89349,193149,188894,12371222,197250,124237,195314,105154,161142,257550,92398,23185284,38723937,9872791,105761,81346,116132,134714,20972969,135730,160247,91914,139875,265878,219299,102266,176975,157283,156918,227190,253165,269401,9700388,144062,223510,36566491,266814,78111,128141,192391,164234,263716,16306657,131135,6771978,190634,183196,175147,161406,268917,120959,249148,140362,87409,266442,8618578,191155,185864,163032,187408,45539296,200435,150874,254246,171662,117916,189271,17275737,192306,83792,97982,131085,23106643,6775934,177510,82521,181966,179118,182129,229040,206641,200283,76033,15243082,73900,143785,164309,27486615,199850,105712,252403,173923,201732,98121,269445,129501,186259,138736,208378,9290146,87071,210768,4442187,136555,243839,174035,193204,106094,228944,31789631,159064,122780,268162,191516,207463,5957896,77798,37868209,204342,2853495,251064,136066,245352,205836,48897409,223733,13723644,189797,74121,194565,171549,160801,211759,18332685,261287,27808178,223466,190920,223355,267700,170037,225374,126658,81094,169799,101745,156617,221211,189988,79494,173543,29311567,81316,98441,223333,162146,127946,91812,109374,164670,217376,267314,198307,260291,175902,247180,126485,267580,157224,189598,5957902,134439,170491,5315084,123820,209921,241752,100682,77069,96781,162891,101590,265768,260508,166027,263240,37038521,124606,180306,170382,266112,150752,84439,101229,7599929,77403,108551,97625,138331,10261747,248414,154226,94738,150268,266691,180460,146486,220755,177255,7541413,259974,223652,106657,193693,135345,383497,27224568,124337,203882,96059,267915,113392,1173693,51503593,73318,179201,234239,115353,38008495,1904411,240120,226977,242786,262446,39599857,89745,99548,251539,136200,212394,263334,187530,94222,144374,226339,148779,104153,156120,119873,247088,207109,199364,171586,242085,168676,177439,199099,251478,124829,194884,142256,155492,261585,93789,18810400,138273,221593,208002,241860,95872,245060,119718,384128,194797,208932,103051,240534,135125,141656,146150,113160,37868894,190874,101813,106889,99228,222748,113462,208516,204827,383494,241209,100623,220200,154116,220238,18355899,145352,210638,190504,144248,261090,160274,153833,173849,193952,78857,212470,171353,221442,122810,147332,189226,221136,209483,114609,171766,220403,75190,46904829,209054,158905,191266,118221,193518,250174,254732,81753,7599407,9129444,208674,218375,88688,111651,41634802,122718,39225141,181441,185439,245591,189123,211866,3379737,43581664,157109,82604,255905,205753,222898,268384,190061,182335,150070,178433,159538,177852,39558144,197379,217510,218042,139974,91521,188200,131018,106287,110842,108881,190210,143596,122101,207763,74347,227892,162295,8722782,11213840,31665450,173880,202800,150701,18323640,187180,156464,26684056,164128,224446,266888,196083,171431,76091,227046,126983,1173124,122838,249871,135403,79763,32742951,142573,128526,49169351,91180,155681,187810,13979961,1173603,142725,266341,3379718,134831,227134,31514436,210522,77600,221512,192842,105395,152590,38300874,43349109,265468,124000,239049,33072200,33072197,119054,260555,156310,209351,75680,114017,141037,93903,83176,266549,242072,135205,136417,164042,86746,249733,176296,111521,139070,91479,77676,81527,111071,97550,225114,90830,99678,186176,233730,175690,114455,179242,87467,157359,190150,204528,218032,172618,269773,195113,1173653,4061766,241333,7186183,8870626,384186,199831,144556,165005,131790,166529,223447,213132,261823,194307,143038,135252,107594,15050850,94129,142318,244648,135685,263799,125952,199538,255713,243765,213925,87314,246836,132156,259576,7217358,180504,1173742,121033,219686,49539259,128649,96266,205493,103348,267623,146183,80083,383027,20708505,135519,181569,252258,96544,35700277,220877,87012,241967,147531,227558,88772,1173121,124718,85808,1173251,174737,147221,192003,176200,78602,157521,149455,252035,268951,156680,151568,151031,86879,141880,268424,110338,79701,14623690,241670,7678621,138939,261224,120314,262206,104513,141995,243209,202332,73764,122139,259918,124869,90081,131839,171964,235840,143736,185961,94373,105748,241513,146572,220531,87899,256865,223613,259830,253939,384102,9700322,127993,47158244,187735,95383,195918,76427,23184951,34636746,202588,188963,114925,160120,172217,159639,185795,118332,195225,188297,27807955,107333,264897,77223,147915,102868,27199439,8591193,202690,166611,149700,196032,9700358,205629,148899,27808352,191047,203901,205724,148562,157466,91843,160345,198534,30765443,74880,84306,103526,382826,46461361,136496,265826,197648,176111,4061812,132556,27128134,46237639,251348,248735,78233,194713,253709,222689,80509,75853,201319,82805,106347,143351,203147,98639,186088,101167,72285,221382,402843,170704,173602,85437,44404593,252859,48897791,23106697,185698,139196,181329,181736,114041,200867,192120,173082,220170,268304,2655510,28138429,84203,113085,79343,140245,1173161,85536,100061,155228,167765,197746,255407,222491,101403,144860,186138,170874,177391,83429,102508,203577,210439,246756,383375,121638,266243,3029831,178072,186109,242703,185065,163153,161875,87856,261884,268279,174181,162820,130049,129250,22452518,189670,169525,22892606,95945,202202,210887,187883,111370,260788,240404,263626,268827,165965,7599993,154180,229470,129897,142376,227604,38670305,50388225,4061656,100829,88849,210751,224600,205800,179680,130324,34219679,97423,219645,148376,260577,167903,383021,111233,175610,265930,165025,141272,96354,98352,87380,5160343,139730,113819,256818,124113,177333,266360,195347,156053,96924,111341,75643,87219,143448,109291,225305,219012,211155,103317,158731,256504,189166,176637,105477,168470,174680,39355239,160168,73135,92184,180106,129533,9887645,194023,117486,41752708,192497,268647,193068,256553,199572,223960,89709,138703,97116,22840856,115223,1173542,122580,1845849,97332,158481,108003,149155,245926,146259,26970115,147399,122307,47294199,242260,218149,42105593,239438,175319,175792,132606,214160,139584,97583,8388337,172512,167986,117877,194471,210612,131179,151257,249413,36278962,75959,161033,172278,23220930,225967,176007,163837,95043,17594470,82419,163235,146983,32979456,200595,6797421,113751,224773,174583,3224898,111604,149400,247473,188242,220546,150349,114505,203131,108195,269023,211256,193721,75600,96619,173474,205897,49539249,113626,257010,76116,140059,166413,165937,151676,209859,226395,75482,168744)
                  
                   AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
                   AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
                   order by minPrice