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

[
  "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(51)

[]

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

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

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