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

[
  "30"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '30';

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

[]

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

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

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