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

[]

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

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

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