Symfony Profiler

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

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/webhook/' AND `key` = BINARY 'update-live-data';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook/update-live-data';

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

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/' AND `key` = BINARY 'webhook';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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

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

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1;

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

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

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 = '/vcloud/v1/webhook/update-live-data' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/vcloud/v1/webhook/update-live-data' AND `type` = 'path_query') OR
                (source = 'https://alpenregion-staging.conecto.rocks/vcloud/v1/webhook/update-live-data' 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
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/webhook/' AND `key` = BINARY 'update-live-data';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook/update-live-data';

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

SELECT id FROM documents WHERE `path` = BINARY '/vcloud/v1/' AND `key` = BINARY 'webhook';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1/webhook';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/vcloud/v1';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_poi';

SELECT
  object_localized_vcloud_poi_en.id as id,
  object_localized_vcloud_poi_en.type as `type`
FROM
  object_localized_vcloud_poi_en
WHERE
  (
    `reference` = 'd33f5596-ce04-49d5-998a-9453bc9dde51'
    AND object_localized_vcloud_poi_en.type IN ('variant', 'object')
  )
  AND object_localized_vcloud_poi_en.published = 1
LIMIT
  1

SELECT object_localized_vcloud_poi_en.id as id, object_localized_vcloud_poi_en.type as `type` FROM object_localized_vcloud_poi_en WHERE (`reference` = 'd33f5596-ce04-49d5-998a-9453bc9dde51'  AND  object_localized_vcloud_poi_en.type IN ('variant','object')) AND object_localized_vcloud_poi_en.published = 1 LIMIT 1;

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 1727;

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

SELECT id FROM objects WHERE `path` = BINARY '/VCloud/Poi/' AND `key` = BINARY 'Mannheimer Hütte_d33f5596-ce04-49d5-998a-9453bc9dde51';

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

SELECT id FROM objects WHERE `path` = BINARY '/VCloud/Poi/' AND `key` = BINARY 'Mannheimer Hütte_d33f5596-ce04-49d5-998a-9453bc9dde51';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 5594;

SELECT
  *
FROM
  object_relations_vcloud_poi
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_poi WHERE src_id = 5594;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_concept';

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 672;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 672;

SELECT
  *
FROM
  object_store_vcloud_concept
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_vcloud_concept WHERE oo_id = 672 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_vcloud_concept
WHERE
  ooo_id = ?
  AND language IN ('de', 'en')

SELECT * FROM object_localized_data_vcloud_concept WHERE ooo_id = 672 AND language IN ('de','en');

SELECT
  *
FROM
  object_relations_vcloud_concept
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_concept WHERE src_id = 672;

SELECT
  *
FROM
  object_collection_vcloudOpeningHours_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vcloudOpeningHours_vcloud_poi WHERE id = 5594 AND fieldname = 'openingHours' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_vcloudOpeningHours_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND language IN ('de', 'en')
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_vcloudOpeningHours_localized_vcloud_poi WHERE ooo_id = 5594 AND language IN ('de','en') AND `fieldname` = 'openingHours' AND `index` = 0;

SELECT
  *
FROM
  object_collection_vcloudExternalLink_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vcloudExternalLink_vcloud_poi WHERE id = 5594 AND fieldname = 'externalLinks' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_collection_vcloudExternalLink_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND language IN ('de', 'en')
  AND `fieldname` = ?
  AND `index` = ?

SELECT * FROM object_collection_vcloudExternalLink_localized_vcloud_poi WHERE ooo_id = 5594 AND language IN ('de','en') AND `fieldname` = 'externalLinks' AND `index` = 0;

SELECT
  *
FROM
  object_collection_vcloudContentblock_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_vcloudContentblock_vcloud_poi WHERE id = 5594 AND fieldname = 'contentblocks' ORDER BY `index` ASC;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 5594 FOR UPDATE;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 5594 AND ctype = 'object';

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SELECT
  type,
  classId,
  className
FROM
  objects
WHERE
  id = ?

SELECT type,classId,className FROM objects WHERE id = 5594;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/VCloud/Poi/', 5594, 1741246466, 1791182886, 0, 0, 0, 1727, 'object', 'Mannheimer Hütte_d33f5596-ce04-49d5-998a-9453bc9dde51', 0, NULL, NULL, 'vcloud_poi', 1, 'Poi');

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/VCloud/Poi/', `id` = 5594, `creationDate` = 1741246466, `modificationDate` = 1791182886, `versionCount` = 0, `userOwner` = 0, `userModification` = 0, `parentId` = 1727, `type` = 'object', `key` = 'Mannheimer Hütte_d33f5596-ce04-49d5-998a-9453bc9dde51', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'vcloud_poi', `published` = 1, `className` = 'Poi' WHERE `id` = 5594;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 5594 AND type = 'object';

SHOW COLUMNS
FROM
  object_localized_data_vcloud_poi

SHOW COLUMNS FROM object_localized_data_vcloud_poi;

INSERT INTO object_localized_data_vcloud_poi (
  `ooo_id`, `language`, `title`, `slug`,
  `guestCardIncludedText`, `guestCardDiscountedText`,
  `guestCardPremiumText`, `guestCardAlpenregionText`,
  `guestCardWalsertalSummerText`,
  `guestCardWalsertalWinterText`,
  `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`,
  `description`, `text`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_data_vcloud_poi (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`, `description`, `text`) VALUES (5594, 'de', 'Mannheimer Hütte', 'mannheimerhuette-2-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Spektakulärer Ausblick, herzliche Atmosphäre und ein Sonnenuntergang, den Du nie vergisst.', '<p>Auf dem Verbindungsgrat zwischen Panüelerkopf und Wildberg thront die Mannheimer Hütte – spektakulär exponiert und mit einem der beeindruckendsten Ausblicke in den Alpen. Von der großzügigen Sonnenterrasse reicht der Blick über den Brandner Gletscher bis weit hinein in die Gipfelwelt rundherum. Besonders am Abend, wenn die Sonne langsam hinter den Bergen versinkt, zeigt sich hier ein Schauspiel, das seinesgleichen sucht.<br><br>Die Hütte verfügt über zwei gemütliche Gasträume, in denen warme und kalte Speisen sowie Getränke serviert werden. Für alle, die über Nacht bleiben möchten, stehen nach vorheriger Reservierung Zimmer- und Matratzenlager zur Verfügung.<br><br><b>Wichtig:</b> Auf der Hütte ist nur Barzahlung möglich.</p>');

UPDATE
  object_localized_data_vcloud_poi
SET
  `ooo_id` = ?,
  `language` = ?,
  `title` = ?,
  `slug` = ?,
  `guestCardIncludedText` = ?,
  `guestCardDiscountedText` = ?,
  `guestCardPremiumText` = ?,
  `guestCardAlpenregionText` = ?,
  `guestCardWalsertalSummerText` = ?,
  `guestCardWalsertalWinterText` = ?,
  `guestCardBrandnertalText` = ?,
  `guestCardPremiumBrandnertalText` = ?,
  `description` = ?,
  `text` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_data_vcloud_poi SET `ooo_id` = 5594, `language` = 'de', `title` = 'Mannheimer Hütte', `slug` = 'mannheimerhuette-2-1', `guestCardIncludedText` = NULL, `guestCardDiscountedText` = NULL, `guestCardPremiumText` = NULL, `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = NULL, `description` = 'Spektakulärer Ausblick, herzliche Atmosphäre und ein Sonnenuntergang, den Du nie vergisst.', `text` = '<p>Auf dem Verbindungsgrat zwischen Panüelerkopf und Wildberg thront die Mannheimer Hütte – spektakulär exponiert und mit einem der beeindruckendsten Ausblicke in den Alpen. Von der großzügigen Sonnenterrasse reicht der Blick über den Brandner Gletscher bis weit hinein in die Gipfelwelt rundherum. Besonders am Abend, wenn die Sonne langsam hinter den Bergen versinkt, zeigt sich hier ein Schauspiel, das seinesgleichen sucht.<br><br>Die Hütte verfügt über zwei gemütliche Gasträume, in denen warme und kalte Speisen sowie Getränke serviert werden. Für alle, die über Nacht bleiben möchten, stehen nach vorheriger Reservierung Zimmer- und Matratzenlager zur Verfügung.<br><br><b>Wichtig:</b> Auf der Hütte ist nur Barzahlung möglich.</p>' WHERE `ooo_id` = 5594 AND `language` = 'de';

SELECT
  *
FROM
  object_localized_query_vcloud_poi_de
WHERE
  ooo_id = 5594
  AND language = 'de'

SELECT * FROM object_localized_query_vcloud_poi_de WHERE ooo_id = 5594 AND language = 'de';

SHOW COLUMNS
FROM
  object_localized_query_vcloud_poi_de

SHOW COLUMNS FROM object_localized_query_vcloud_poi_de;

INSERT INTO object_localized_query_vcloud_poi_de (
  `ooo_id`, `language`, `title`, `slug`,
  `guestCardIncludedText`, `guestCardDiscountedText`,
  `guestCardPremiumText`, `guestCardAlpenregionText`,
  `guestCardWalsertalSummerText`,
  `guestCardWalsertalWinterText`,
  `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`,
  `description`, `text`, `search_index`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_query_vcloud_poi_de (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`, `description`, `text`, `search_index`) VALUES (5594, 'de', 'Mannheimer Hütte', 'mannheimerhuette-2-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Spektakulärer Ausblick, herzliche Atmosphäre und ein Sonnenuntergang, den Du nie vergisst.', '<p>Auf dem Verbindungsgrat zwischen Panüelerkopf und Wildberg thront die Mannheimer Hütte – spektakulär exponiert und mit einem der beeindruckendsten Ausblicke in den Alpen. Von der großzügigen Sonnenterrasse reicht der Blick über den Brandner Gletscher bis weit hinein in die Gipfelwelt rundherum. Besonders am Abend, wenn die Sonne langsam hinter den Bergen versinkt, zeigt sich hier ein Schauspiel, das seinesgleichen sucht.<br><br>Die Hütte verfügt über zwei gemütliche Gasträume, in denen warme und kalte Speisen sowie Getränke serviert werden. Für alle, die über Nacht bleiben möchten, stehen nach vorheriger Reservierung Zimmer- und Matratzenlager zur Verfügung.<br><br><b>Wichtig:</b> Auf der Hütte ist nur Barzahlung möglich.</p>', '');

UPDATE
  object_localized_query_vcloud_poi_de
SET
  `ooo_id` = ?,
  `language` = ?,
  `title` = ?,
  `slug` = ?,
  `guestCardIncludedText` = ?,
  `guestCardDiscountedText` = ?,
  `guestCardPremiumText` = ?,
  `guestCardAlpenregionText` = ?,
  `guestCardWalsertalSummerText` = ?,
  `guestCardWalsertalWinterText` = ?,
  `guestCardBrandnertalText` = ?,
  `guestCardPremiumBrandnertalText` = ?,
  `description` = ?,
  `text` = ?,
  `search_index` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_query_vcloud_poi_de SET `ooo_id` = 5594, `language` = 'de', `title` = 'Mannheimer Hütte', `slug` = 'mannheimerhuette-2-1', `guestCardIncludedText` = NULL, `guestCardDiscountedText` = NULL, `guestCardPremiumText` = NULL, `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = NULL, `description` = 'Spektakulärer Ausblick, herzliche Atmosphäre und ein Sonnenuntergang, den Du nie vergisst.', `text` = '<p>Auf dem Verbindungsgrat zwischen Panüelerkopf und Wildberg thront die Mannheimer Hütte – spektakulär exponiert und mit einem der beeindruckendsten Ausblicke in den Alpen. Von der großzügigen Sonnenterrasse reicht der Blick über den Brandner Gletscher bis weit hinein in die Gipfelwelt rundherum. Besonders am Abend, wenn die Sonne langsam hinter den Bergen versinkt, zeigt sich hier ein Schauspiel, das seinesgleichen sucht.<br><br>Die Hütte verfügt über zwei gemütliche Gasträume, in denen warme und kalte Speisen sowie Getränke serviert werden. Für alle, die über Nacht bleiben möchten, stehen nach vorheriger Reservierung Zimmer- und Matratzenlager zur Verfügung.<br><br><b>Wichtig:</b> Auf der Hütte ist nur Barzahlung möglich.</p>', `search_index` = '' WHERE `ooo_id` = 5594 AND `language` = 'de';

INSERT INTO object_localized_data_vcloud_poi (
  `ooo_id`, `language`, `title`, `slug`,
  `guestCardIncludedText`, `guestCardDiscountedText`,
  `guestCardPremiumText`, `guestCardAlpenregionText`,
  `guestCardWalsertalSummerText`,
  `guestCardWalsertalWinterText`,
  `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`,
  `description`, `text`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_data_vcloud_poi (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`, `description`, `text`) VALUES (5594, 'en', NULL, 'mannheimerhuette-3-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Breathtaking views, warm hospitality, and a sunset you’ll never forget.', '<p>Perched on the exposed ridge between Panüler and Wildberg, the Mannheimer Hütte offers one of the most stunning panoramic views in the Alps. From the spacious sun terrace, you can take in sweeping vistas of the Brandner Glacier and the surrounding peaks. As evening falls, the sunset here becomes an unforgettable spectacle.<br><br>The hut features two cozy dining rooms where hot and cold meals and drinks are served. Overnight stays are possible with a reservation.<br><br><b>Please note:</b> Cash payment only.</p>');

UPDATE
  object_localized_data_vcloud_poi
SET
  `ooo_id` = ?,
  `language` = ?,
  `title` = ?,
  `slug` = ?,
  `guestCardIncludedText` = ?,
  `guestCardDiscountedText` = ?,
  `guestCardPremiumText` = ?,
  `guestCardAlpenregionText` = ?,
  `guestCardWalsertalSummerText` = ?,
  `guestCardWalsertalWinterText` = ?,
  `guestCardBrandnertalText` = ?,
  `guestCardPremiumBrandnertalText` = ?,
  `description` = ?,
  `text` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_data_vcloud_poi SET `ooo_id` = 5594, `language` = 'en', `title` = NULL, `slug` = 'mannheimerhuette-3-1', `guestCardIncludedText` = NULL, `guestCardDiscountedText` = NULL, `guestCardPremiumText` = NULL, `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = NULL, `description` = 'Breathtaking views, warm hospitality, and a sunset you’ll never forget.', `text` = '<p>Perched on the exposed ridge between Panüler and Wildberg, the Mannheimer Hütte offers one of the most stunning panoramic views in the Alps. From the spacious sun terrace, you can take in sweeping vistas of the Brandner Glacier and the surrounding peaks. As evening falls, the sunset here becomes an unforgettable spectacle.<br><br>The hut features two cozy dining rooms where hot and cold meals and drinks are served. Overnight stays are possible with a reservation.<br><br><b>Please note:</b> Cash payment only.</p>' WHERE `ooo_id` = 5594 AND `language` = 'en';

SELECT
  *
FROM
  object_localized_query_vcloud_poi_en
WHERE
  ooo_id = 5594
  AND language = 'en'

SELECT * FROM object_localized_query_vcloud_poi_en WHERE ooo_id = 5594 AND language = 'en';

SHOW COLUMNS
FROM
  object_localized_query_vcloud_poi_en

SHOW COLUMNS FROM object_localized_query_vcloud_poi_en;

INSERT INTO object_localized_query_vcloud_poi_en (
  `ooo_id`, `language`, `title`, `slug`,
  `guestCardIncludedText`, `guestCardDiscountedText`,
  `guestCardPremiumText`, `guestCardAlpenregionText`,
  `guestCardWalsertalSummerText`,
  `guestCardWalsertalWinterText`,
  `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`,
  `description`, `text`, `search_index`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_localized_query_vcloud_poi_en (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `guestCardBrandnertalText`, `guestCardPremiumBrandnertalText`, `description`, `text`, `search_index`) VALUES (5594, 'en', 'Mannheimer Hütte', 'mannheimerhuette-3-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Breathtaking views, warm hospitality, and a sunset you’ll never forget.', '<p>Perched on the exposed ridge between Panüler and Wildberg, the Mannheimer Hütte offers one of the most stunning panoramic views in the Alps. From the spacious sun terrace, you can take in sweeping vistas of the Brandner Glacier and the surrounding peaks. As evening falls, the sunset here becomes an unforgettable spectacle.<br><br>The hut features two cozy dining rooms where hot and cold meals and drinks are served. Overnight stays are possible with a reservation.<br><br><b>Please note:</b> Cash payment only.</p>', '');

UPDATE
  object_localized_query_vcloud_poi_en
SET
  `ooo_id` = ?,
  `language` = ?,
  `title` = ?,
  `slug` = ?,
  `guestCardIncludedText` = ?,
  `guestCardDiscountedText` = ?,
  `guestCardPremiumText` = ?,
  `guestCardAlpenregionText` = ?,
  `guestCardWalsertalSummerText` = ?,
  `guestCardWalsertalWinterText` = ?,
  `guestCardBrandnertalText` = ?,
  `guestCardPremiumBrandnertalText` = ?,
  `description` = ?,
  `text` = ?,
  `search_index` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_query_vcloud_poi_en SET `ooo_id` = 5594, `language` = 'en', `title` = 'Mannheimer Hütte', `slug` = 'mannheimerhuette-3-1', `guestCardIncludedText` = NULL, `guestCardDiscountedText` = NULL, `guestCardPremiumText` = NULL, `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = NULL, `description` = 'Breathtaking views, warm hospitality, and a sunset you’ll never forget.', `text` = '<p>Perched on the exposed ridge between Panüler and Wildberg, the Mannheimer Hütte offers one of the most stunning panoramic views in the Alps. From the spacious sun terrace, you can take in sweeping vistas of the Brandner Glacier and the surrounding peaks. As evening falls, the sunset here becomes an unforgettable spectacle.<br><br>The hut features two cozy dining rooms where hot and cold meals and drinks are served. Overnight stays are possible with a reservation.<br><br><b>Please note:</b> Cash payment only.</p>', `search_index` = '' WHERE `ooo_id` = 5594 AND `language` = 'en';

SELECT
  id
FROM
  object_brick_store_Address_vcloud_poi
WHERE
  id = ?
LIMIT
  1

SELECT id FROM object_brick_store_Address_vcloud_poi WHERE id = 5594 LIMIT 1;

SHOW COLUMNS
FROM
  object_brick_localized_Address_vcloud_poi

SHOW COLUMNS FROM object_brick_localized_Address_vcloud_poi;

INSERT INTO object_brick_localized_Address_vcloud_poi (
  `ooo_id`, `language`, `fieldname`,
  `index`, `email`, `telephone`, `url`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_brick_localized_Address_vcloud_poi (`ooo_id`, `language`, `fieldname`, `index`, `email`, `telephone`, `url`) VALUES (5594, 'de', 'address', 0, 'mannheimer.oberzalimhuette@gmail.com', '+43 664 19 00 691', 'https://mannheimerhuette.co.at/');

UPDATE
  object_brick_localized_Address_vcloud_poi
SET
  `ooo_id` = ?,
  `language` = ?,
  `fieldname` = ?,
  `index` = ?,
  `email` = ?,
  `telephone` = ?,
  `url` = ?
WHERE
  `ooo_id` = ?
  AND `index` = ?
  AND `fieldname` = ?
  AND `language` = ?

UPDATE object_brick_localized_Address_vcloud_poi SET `ooo_id` = 5594, `language` = 'de', `fieldname` = 'address', `index` = 0, `email` = 'mannheimer.oberzalimhuette@gmail.com', `telephone` = '+43 664 19 00 691', `url` = 'https://mannheimerhuette.co.at/' WHERE `ooo_id` = 5594 AND `index` = 0 AND `fieldname` = 'address' AND `language` = 'de';

SELECT
  *
FROM
  object_brick_localized_query_Address_vcloud_poi_de
WHERE
  ooo_id = 5594
  AND language = 'de'

SELECT * FROM object_brick_localized_query_Address_vcloud_poi_de WHERE ooo_id = 5594 AND language = 'de';

SHOW COLUMNS
FROM
  object_brick_localized_query_Address_vcloud_poi_de

SHOW COLUMNS FROM object_brick_localized_query_Address_vcloud_poi_de;

INSERT INTO object_brick_localized_query_Address_vcloud_poi_de (
  `ooo_id`, `language`, `email`, `telephone`,
  `url`
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO object_brick_localized_query_Address_vcloud_poi_de (`ooo_id`, `language`, `email`, `telephone`, `url`) VALUES (5594, 'de', 'mannheimer.oberzalimhuette@gmail.com', '+43 664 19 00 691', 'https://mannheimerhuette.co.at/');

UPDATE
  object_brick_localized_query_Address_vcloud_poi_de
SET
  `ooo_id` = ?,
  `language` = ?,
  `email` = ?,
  `telephone` = ?,
  `url` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_brick_localized_query_Address_vcloud_poi_de SET `ooo_id` = 5594, `language` = 'de', `email` = 'mannheimer.oberzalimhuette@gmail.com', `telephone` = '+43 664 19 00 691', `url` = 'https://mannheimerhuette.co.at/' WHERE `ooo_id` = 5594 AND `language` = 'de';

INSERT INTO object_brick_localized_Address_vcloud_poi (
  `ooo_id`, `language`, `fieldname`,
  `index`, `email`, `telephone`, `url`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_brick_localized_Address_vcloud_poi (`ooo_id`, `language`, `fieldname`, `index`, `email`, `telephone`, `url`) VALUES (5594, 'en', 'address', 0, 'mannheimer.oberzalimhuette@gmail.com', '+43 664 19 00 691', 'https://mannheimerhuette.co.at/');

UPDATE
  object_brick_localized_Address_vcloud_poi
SET
  `ooo_id` = ?,
  `language` = ?,
  `fieldname` = ?,
  `index` = ?,
  `email` = ?,
  `telephone` = ?,
  `url` = ?
WHERE
  `ooo_id` = ?
  AND `index` = ?
  AND `fieldname` = ?
  AND `language` = ?

UPDATE object_brick_localized_Address_vcloud_poi SET `ooo_id` = 5594, `language` = 'en', `fieldname` = 'address', `index` = 0, `email` = 'mannheimer.oberzalimhuette@gmail.com', `telephone` = '+43 664 19 00 691', `url` = 'https://mannheimerhuette.co.at/' WHERE `ooo_id` = 5594 AND `index` = 0 AND `fieldname` = 'address' AND `language` = 'en';

SELECT
  *
FROM
  object_brick_localized_query_Address_vcloud_poi_en
WHERE
  ooo_id = 5594
  AND language = 'en'

SELECT * FROM object_brick_localized_query_Address_vcloud_poi_en WHERE ooo_id = 5594 AND language = 'en';

SHOW COLUMNS
FROM
  object_brick_localized_query_Address_vcloud_poi_en

SHOW COLUMNS FROM object_brick_localized_query_Address_vcloud_poi_en;

INSERT INTO object_brick_localized_query_Address_vcloud_poi_en (
  `ooo_id`, `language`, `email`, `telephone`,
  `url`
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO object_brick_localized_query_Address_vcloud_poi_en (`ooo_id`, `language`, `email`, `telephone`, `url`) VALUES (5594, 'en', 'mannheimer.oberzalimhuette@gmail.com', '+43 664 19 00 691', 'https://mannheimerhuette.co.at/');

UPDATE
  object_brick_localized_query_Address_vcloud_poi_en
SET
  `ooo_id` = ?,
  `language` = ?,
  `email` = ?,
  `telephone` = ?,
  `url` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_brick_localized_query_Address_vcloud_poi_en SET `ooo_id` = 5594, `language` = 'en', `email` = 'mannheimer.oberzalimhuette@gmail.com', `telephone` = '+43 664 19 00 691', `url` = 'https://mannheimerhuette.co.at/' WHERE `ooo_id` = 5594 AND `language` = 'en';

UPDATE
  object_brick_store_Address_vcloud_poi
SET
  `id` = ?,
  `fieldname` = ?,
  `coordinates__longitude` = ?,
  `coordinates__latitude` = ?,
  `country` = ?,
  `locality` = ?,
  `postalCode` = ?,
  `street` = ?
WHERE
  id = ?

UPDATE object_brick_store_Address_vcloud_poi SET `id` = 5594, `fieldname` = 'address', `coordinates__longitude` = 9.6935784816742, `coordinates__latitude` = 47.065678715109, `country` = 'AT', `locality` = 'Brand', `postalCode` = '6708', `street` = 'Brand' WHERE id = 5594;

SELECT
  *
FROM
  object_brick_query_Address_vcloud_poi
WHERE
  id = ?

SELECT * FROM object_brick_query_Address_vcloud_poi WHERE id = 5594;

SHOW COLUMNS
FROM
  object_brick_query_Address_vcloud_poi

SHOW COLUMNS FROM object_brick_query_Address_vcloud_poi;

INSERT INTO object_brick_query_Address_vcloud_poi (
  `id`, `fieldname`, `coordinates__longitude`,
  `coordinates__latitude`, `country`,
  `locality`, `postalCode`, `street`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_brick_query_Address_vcloud_poi (`id`, `fieldname`, `coordinates__longitude`, `coordinates__latitude`, `country`, `locality`, `postalCode`, `street`) VALUES (5594, 'address', 9.6935784816742, 47.065678715109, 'AT', 'Brand', '6708', 'Brand');

UPDATE
  object_brick_query_Address_vcloud_poi
SET
  `id` = ?,
  `fieldname` = ?,
  `coordinates__longitude` = ?,
  `coordinates__latitude` = ?,
  `country` = ?,
  `locality` = ?,
  `postalCode` = ?,
  `street` = ?
WHERE
  `id` = ?
  AND `fieldname` = ?

UPDATE object_brick_query_Address_vcloud_poi SET `id` = 5594, `fieldname` = 'address', `coordinates__longitude` = 9.6935784816742, `coordinates__latitude` = 47.065678715109, `country` = 'AT', `locality` = 'Brand', `postalCode` = '6708', `street` = 'Brand' WHERE `id` = 5594 AND `fieldname` = 'address';

SELECT
  `id`
FROM
  `object_collection_vcloudOpeningHours_vcloud_poi`
WHERE
  `id` = '5594'
  AND `fieldname` = 'openingHours'
LIMIT
  1

SELECT `id` FROM `object_collection_vcloudOpeningHours_vcloud_poi` WHERE `id` = '5594' AND `fieldname` = 'openingHours' LIMIT 1;

DELETE FROM
  object_collection_vcloudOpeningHours_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudOpeningHours_vcloud_poi WHERE id = 5594 AND fieldname = 'openingHours';

SELECT
  `ooo_id`
FROM
  `object_collection_vcloudOpeningHours_localized_vcloud_poi`
WHERE
  `ooo_id` = '5594'
  AND `fieldname` = 'openingHours'
LIMIT
  1

SELECT `ooo_id` FROM `object_collection_vcloudOpeningHours_localized_vcloud_poi` WHERE
         `ooo_id` = '5594' AND `fieldname` = 'openingHours' LIMIT 1 ;

DELETE FROM
  object_collection_vcloudOpeningHours_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudOpeningHours_localized_vcloud_poi WHERE ooo_id = 5594 AND fieldname = 'openingHours';

DELETE FROM
  object_relations_vcloud_poi
WHERE
  (
    ownertype = 'fieldcollection'
    AND ownername = 'openingHours'
    AND src_id = '5594'
  )

DELETE FROM object_relations_vcloud_poi WHERE (ownertype = 'fieldcollection' AND ownername = 'openingHours' AND src_id = '5594');

DELETE FROM
  object_relations_vcloud_poi
WHERE
  (
    ownertype = 'localizedfield'
    AND ownername LIKE '/fieldcollection~openingHours/%'
    AND src_id = '5594'
  )

DELETE FROM object_relations_vcloud_poi WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~openingHours/%' AND src_id = '5594');

DELETE FROM
  object_relations_vcloud_poi
WHERE
  src_id = '5594'
  AND ownertype = 'localizedfield'
  AND ownername LIKE '/fieldcollection~openingHours/0/%'

DELETE FROM object_relations_vcloud_poi WHERE src_id = '5594' AND ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~openingHours/0/%';

SHOW COLUMNS
FROM
  object_collection_vcloudOpeningHours_localized_vcloud_poi

SHOW COLUMNS FROM object_collection_vcloudOpeningHours_localized_vcloud_poi;

INSERT INTO object_collection_vcloudOpeningHours_localized_vcloud_poi (
  `ooo_id`, `language`, `fieldname`,
  `index`, `description`
)
VALUES
  (?, ?, ?, ?, ?)