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" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
  "sourcePathQuery" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853635&nearbySearchLat=47.38306&nearbySearchLong=13.66915&page=3&randSeed=530&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853635&nearbySearchLat=47.38306&nearbySearchLong=13.66915&page=3&randSeed=530&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 = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853635&nearbySearchLat=47.38306&nearbySearchLong=13.66915&page=3&randSeed=530&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=853635&nearbySearchLat=47.38306&nearbySearchLong=13.66915&page=3&randSeed=530&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" => "Accommodations"
  "path" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/"
]

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

SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND (
    siteId = 6
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' 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 = ?

[
  7930
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 7930;

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//en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Schladming-Dachstein/Vacation-planning/Accommodations' 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 = ?

[
  7930
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 7930;

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

[
  7159
  7930
  7930
]

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, 7930) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7930;

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,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  7159
  7159
]

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 = 7159 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 7159;

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

[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]

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

SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

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

[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]

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

SELECT id FROM documents WHERE path = BINARY '/en/Schladming-Dachstein/Vacation-planning/' AND `key` = BINARY 'Accommodations';

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

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/%"
  "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]

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 = '/en/Schladming-Dachstein/Vacation-planning/Accommodations';

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

[
  "key" => "Vacation-planning"
  "path" => "/en/Schladming-Dachstein/"
]

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/Schladming-Dachstein/Vacation-planning';

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/%"
  "/en/Schladming-Dachstein/Vacation-planning"
]

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 = '/en/Schladming-Dachstein/Vacation-planning';

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

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

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/en/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/%"
  "/en/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 = '/en/Schladming-Dachstein';

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

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

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

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

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

[
  "prettyUrl" => "/en"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = :prettyUrl

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

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/%"
  "/en"
]

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 = '/en';

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 = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' 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 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 = ?

[
  16088
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 16088;

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

[]

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

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

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