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=1430599&nearbySearchLat=47.50492&nearbySearchLong=14.10239&sorting=nearbySearchAsc&page=10&randSeed=142"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1430599&nearbySearchLat=47.50492&nearbySearchLong=14.10239&page=10&randSeed=142&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=1430599&nearbySearchLat=47.50492&nearbySearchLong=14.10239&sorting=nearbySearchAsc&page=10&randSeed=142' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1430599&nearbySearchLat=47.50492&nearbySearchLong=14.10239&page=10&randSeed=142&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 id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC

[]

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(path)
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;

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 * 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 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 = ?

[
  "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 = ?

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

[]

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

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

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