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=1430381&nearbySearchLat=47.40699&nearbySearchLong=13.81504&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1430381&nearbySearchLat=47.40699&nearbySearchLong=13.81504&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=1430381&nearbySearchLat=47.40699&nearbySearchLong=13.81504&sorting=nearbySearchAsc' AND `type` = 'path_query') OR
                (source = 'https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1430381&nearbySearchLat=47.40699&nearbySearchLong=13.81504&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 * 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   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(549)

[]

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

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

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