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=1430795&nearbySearchLat=47.44453&nearbySearchLong=13.58243&page=6&randSeed=204&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1430795&nearbySearchLat=47.44453&nearbySearchLong=13.58243&page=6&randSeed=204&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=1430795&nearbySearchLat=47.44453&nearbySearchLong=13.58243&page=6&randSeed=204&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=1430795&nearbySearchLat=47.44453&nearbySearchLong=13.58243&page=6&randSeed=204&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 = ?

[
  "68"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '68';

SELECT name FROM classes WHERE id = ?

[
  "20"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '20';

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 * 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(204)

[]

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(204)

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(204) ;

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