Symfony Profiler

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

SELECT id FROM documents WHERE `path` = BINARY '/de/' AND `key` = BINARY 'panoramagasthof-kristberg-9_vc7443';

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 45277;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 45277;

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 3)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'asset'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = 4 )
                                 AND ctype='asset';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/de/panoramagasthof-kristberg-9_vc7443' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/de/panoramagasthof-kristberg-9_vc7443?cs=7463' AND `type` = 'path_query') OR
                (source = 'https://montafon-staging.conecto.rocks/de/panoramagasthof-kristberg-9_vc7443?cs=7463' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 2;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_webcam';

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 45276;

SELECT
  object_localized_vcloud_webcam_de.id as id,
  object_localized_vcloud_webcam_de.type as `type`
FROM
  object_localized_vcloud_webcam_de
WHERE
  (
    (
      id in (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    )
    AND object_localized_vcloud_webcam_de.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_vcloud_webcam_de.published = 1
ORDER BY
  `title` ASC

SELECT object_localized_vcloud_webcam_de.id as id, object_localized_vcloud_webcam_de.type as `type` FROM object_localized_vcloud_webcam_de WHERE ((id in (12302, 12299, 12300, 12301, 12303, 7335, 7332, 7333, 7454, 12304, 8089, 8088, 8087, 8086, 7452, 12305, 12308, 12306, 12307, 12309, 12310, 12311, 12312, 12313, 7337, 7450, 7447, 7449, 7336, 7445, 8090, 7448, 8085, 7334, 7455, 7453, 7444, 7446, 7338, 12297, 7451, 12298))  AND  object_localized_vcloud_webcam_de.type IN ('object','variant','folder')) AND object_localized_vcloud_webcam_de.published = 1 ORDER BY `title` ASC  ;

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/panoramagasthof-kristberg-9_vc7443';

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  COUNT(*)
FROM
  object_localized_vcloud_lift_de
WHERE
  (
    object_localized_vcloud_lift_de.type IN ('object', 'variant', 'folder')
  )
  AND object_localized_vcloud_lift_de.published = 1

SELECT COUNT(*) FROM object_localized_vcloud_lift_de WHERE ( object_localized_vcloud_lift_de.type IN ('object','variant','folder')) AND object_localized_vcloud_lift_de.published = 1;

SELECT
  COUNT(*)
FROM
  object_localized_vcloud_lift_de
WHERE
  (
    `isOpen` = '1'
    AND object_localized_vcloud_lift_de.type IN ('variant', 'object')
  )
  AND object_localized_vcloud_lift_de.published = 1

SELECT COUNT(*) FROM object_localized_vcloud_lift_de WHERE (`isOpen` = '1'  AND  object_localized_vcloud_lift_de.type IN ('variant','object')) AND object_localized_vcloud_lift_de.published = 1;

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 2;

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

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 14)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'asset'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,14) AND inheritable = 1) OR cid = 15 )
                                 AND ctype='asset';

SELECT
  documents.*,
  tree_locks.locked
FROM
  documents
  LEFT JOIN tree_locks ON documents.id = tree_locks.id
  AND tree_locks.type = 'document'
WHERE
  documents.id = ?

SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = 10;

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

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 26749)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'asset'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,26749) AND inheritable = 1) OR cid = 78645 )
                                 AND ctype='asset';

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 45276, 44746, 151)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'asset'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,45276,44746,151) AND inheritable = 1) OR cid = 45277 )
                                 AND ctype='asset';

SELECT
  *
FROM
  object_relations_vcloud_saved_search
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_saved_search WHERE src_id = 7463;

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;