Symfony Profiler

SELECT
  id
FROM
  object_brick_store_Address_vcloud_poi
WHERE
  id = ?
LIMIT
  1

SELECT id FROM object_brick_store_Address_vcloud_poi WHERE id = 5522 LIMIT 1;

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

SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_poi WHERE ooo_id = 5522 AND language IN ('de','en') AND `fieldname` = 'contentblocks' AND `index` = 0;

INSERT INTO object_collection_vcloudContentblock_localized_vcloud_poi (
  `ooo_id`, `language`, `fieldname`,
  `index`, `header`, `description`,
  `links`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudContentblock_localized_vcloud_poi (`ooo_id`, `language`, `fieldname`, `index`, `header`, `description`, `links`) VALUES (5522, 'de', 'contentblocks', 0, 'Gästekartenleistungen', '<p>Mit der Gästekarte Premium Bludenz &amp; Klostertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
', 'a:0:{}');

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 (5522, 'de', 'Loischkopfbahn', 'loischkopfbahn-5', 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', NULL, 'Mit der Gästekarte Premium Bludenz & Klostertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', NULL, NULL, NULL, NULL, 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', 'Die Loischkopfbahn befördert&nbsp;Dich in wenigen Minuten auf 1.785 m Seehöhe.', 'Die Loischkopfbahn ist der ideale Ausgangspunkt für Wanderungen und Mountainbike-Touren im Brandnertal. Der Loischkopf ist einer der schönsten Aussichtpunkte in Vorarlberg. Vom Gipfel hast Du einen Rundblick vom Bodensee, Walgau, Klostertal, dem Rätikon Gebirge bis zur Schesaplana. <br><br><a href=\"https://www.vorarlberg-alpenregion.at/de/brandnertal/bergbahnen-brandnertal-oeffnungszeiten.html\">Hier</a> geht es zu den aktuellen Betriebszeiten.<br><br><b>Technische Daten<br></b><br><b>Bahntyp:&nbsp;</b>Einseilumlaufbahn mit 10er-Kabinen (Doppelmayr)<br><b>Länge:</b>&nbsp;1.708 m<br><b>Höhendifferenz:&nbsp;</b>617 m<br><b>Fahrzeit:&nbsp;</b>8 Minuten<br><b>Förderleistung:&nbsp;</b>bis zu 3.200 Pers./Std.', '<p>Mit der Gästekarte Premium Bludenz &amp; Klostertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
<p>Mit der Gästekarte Premium Brandnertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
');

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';

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 (5522, 'de', 'address', 0, 'station@brandnertal.at', '+43 5559 2240', 'https://www.vorarlberg-alpenregion.at/brandnertal/bergbahnen/');

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_collection_vcloudContentblock_vcloud_poi (
  `id`, `index`, `fieldname`, `gallery__images`,
  `gallery__hotspots`
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudContentblock_vcloud_poi (`id`, `index`, `fieldname`, `gallery__images`, `gallery__hotspots`) VALUES (5522, 0, 'contentblocks', '', 'a:0:{}');

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` = '2080b209-9424-4583-b56d-65649d50bc4e'
    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` = '2080b209-9424-4583-b56d-65649d50bc4e'  AND  object_localized_vcloud_poi_en.type IN ('variant','object')) AND object_localized_vcloud_poi_en.published = 1 LIMIT 1;

SELECT
  *
FROM
  object_relations_vcloud_concept
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_concept WHERE src_id = 1422;

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/', 5522, 1741246393, 1791189509, 4, 0, 0, 1727, 'object', 'Loischkopfbahn_2080b209-9424-4583-b56d-65649d50bc4e', 0, NULL, NULL, 'vcloud_poi', 1, 'Poi');

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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 = 5522;

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

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

"COMMIT"

"COMMIT";

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 = 1422 AND language IN ('de','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 (5522, 'en', 'station@brandnertal.at', '+43 5559 2240', 'https://www.vorarlberg-alpenregion.at/brandnertal/bergbahnen/');

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

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

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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
  object_brick_localized_query_Address_vcloud_poi_en
WHERE
  ooo_id = 5522
  AND language = 'en'

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

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'en'
  and ooo_id = 5522
  and fieldname = 'contentblocks'
  and `index` = 2

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'en' and  ooo_id  = 5522 and fieldname = 'contentblocks' and `index` =  2;

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` = 5522, `creationDate` = 1741246393, `modificationDate` = 1791189509, `versionCount` = 4, `userOwner` = 0, `userModification` = 0, `parentId` = 1727, `type` = 'object', `key` = 'Loischkopfbahn_2080b209-9424-4583-b56d-65649d50bc4e', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'vcloud_poi', `published` = 1, `className` = 'Poi' WHERE `id` = 5522;

SHOW COLUMNS
FROM
  object_localized_data_vcloud_poi

SHOW COLUMNS FROM object_localized_data_vcloud_poi;

SHOW COLUMNS
FROM
  object_collection_vcloudContentblock_localized_vcloud_poi

SHOW COLUMNS FROM object_collection_vcloudContentblock_localized_vcloud_poi;

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 (5522, 'en', 'Loischkopfbahn', 'loischkopfbahn-1-1', 'With the Guest Card Premium Bludenz & Klostertal, the mountain railway ride for pedestrians is included.', NULL, 'With the Guest Card Premium Bludenz & Klostertal&nbsp;the mountain railway ride for pedestrians is included.', NULL, NULL, NULL, NULL, 'With the Guest Card Premium Bludenz & Klostertal, the mountain railway ride for pedestrians is included.', 'The Loischkopfbahn takes you up to 1,785 m above sea level in just a few minutes.', 'The Loischkopfbahn is the ideal starting point for hikes and mountain bike tours in the Brandnertal. The Loischkopf is one of the most beautiful vantage points in Vorarlberg. From the summit you have a panoramic view from Lake Constance, Walgau, Klostertal, the Rätikon mountains to the Schesaplana. <br><br>Click <a href=\"https://www.vorarlberg-alpenregion.at/en/brandnertal/bergbahnen-brandnertal-opening-hours.html\">here</a> for the current operating times.<br><br><b>Technical data<br><br>Type of cableway:&nbsp;</b>Monocable gondola with 10-person cabin (Doppelmayr)<br><b>Length:</b>&nbsp;1,708 m<br><b>Height difference:&nbsp;</b>617 m<br><b>Travel Time:&nbsp;</b>8 minutes<br><b>Transportation capacity:&nbsp;</b>to 3,200 ppl/hr', '<p>Mit der Gästekarte Premium Bludenz &amp; Klostertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
<p>Mit der Gästekarte Premium Brandnertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
<p>With the Guest Card Premium Bludenz &amp; Klostertal the mountain railway ride for pedestrians is included.</p>
<p>With the Guest Card Premium Bludenz &amp; Klostertal, the mountain railway ride for pedestrians is included.</p>
');

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 (5522, 'de', 'Loischkopfbahn', 'loischkopfbahn-5', 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', NULL, 'Mit der Gästekarte Premium Bludenz & Klostertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', NULL, NULL, NULL, NULL, 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', 'Die Loischkopfbahn befördert&nbsp;Dich in wenigen Minuten auf 1.785 m Seehöhe.', 'Die Loischkopfbahn ist der ideale Ausgangspunkt für Wanderungen und Mountainbike-Touren im Brandnertal. Der Loischkopf ist einer der schönsten Aussichtpunkte in Vorarlberg. Vom Gipfel hast Du einen Rundblick vom Bodensee, Walgau, Klostertal, dem Rätikon Gebirge bis zur Schesaplana. <br><br><a href=\"https://www.vorarlberg-alpenregion.at/de/brandnertal/bergbahnen-brandnertal-oeffnungszeiten.html\">Hier</a> geht es zu den aktuellen Betriebszeiten.<br><br><b>Technische Daten<br></b><br><b>Bahntyp:&nbsp;</b>Einseilumlaufbahn mit 10er-Kabinen (Doppelmayr)<br><b>Länge:</b>&nbsp;1.708 m<br><b>Höhendifferenz:&nbsp;</b>617 m<br><b>Fahrzeit:&nbsp;</b>8 Minuten<br><b>Förderleistung:&nbsp;</b>bis zu 3.200 Pers./Std.');

SELECT
  *
FROM
  object_store_vcloud_concept
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_vcloud_concept WHERE oo_id = 1422 FOR UPDATE;

SHOW COLUMNS
FROM
  object_localized_query_vcloud_poi_de

SHOW COLUMNS FROM object_localized_query_vcloud_poi_de;

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` = 5522, `language` = 'en', `email` = 'station@brandnertal.at', `telephone` = '+43 5559 2240', `url` = 'https://www.vorarlberg-alpenregion.at/brandnertal/bergbahnen/' WHERE `ooo_id` = 5522 AND `language` = 'en';

SHOW COLUMNS
FROM
  object_brick_localized_Address_vcloud_poi

SHOW COLUMNS FROM object_brick_localized_Address_vcloud_poi;

SELECT
  `ooo_id`
FROM
  `object_collection_vcloudContentblock_localized_vcloud_poi`
WHERE
  `ooo_id` = '5522'
  AND `fieldname` = 'contentblocks'
LIMIT
  1

SELECT `ooo_id` FROM `object_collection_vcloudContentblock_localized_vcloud_poi` WHERE
         `ooo_id` = '5522' AND `fieldname` = 'contentblocks' LIMIT 1 ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_poi';

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` = 5522, `language` = 'de', `title` = 'Loischkopfbahn', `slug` = 'loischkopfbahn-5', `guestCardIncludedText` = 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `guestCardDiscountedText` = NULL, `guestCardPremiumText` = 'Mit der Gästekarte Premium Bludenz & Klostertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `description` = 'Die Loischkopfbahn befördert&nbsp;Dich in wenigen Minuten auf 1.785 m Seehöhe.', `text` = 'Die Loischkopfbahn ist der ideale Ausgangspunkt für Wanderungen und Mountainbike-Touren im Brandnertal. Der Loischkopf ist einer der schönsten Aussichtpunkte in Vorarlberg. Vom Gipfel hast Du einen Rundblick vom Bodensee, Walgau, Klostertal, dem Rätikon Gebirge bis zur Schesaplana. <br><br><a href=\"https://www.vorarlberg-alpenregion.at/de/brandnertal/bergbahnen-brandnertal-oeffnungszeiten.html\">Hier</a> geht es zu den aktuellen Betriebszeiten.<br><br><b>Technische Daten<br></b><br><b>Bahntyp:&nbsp;</b>Einseilumlaufbahn mit 10er-Kabinen (Doppelmayr)<br><b>Länge:</b>&nbsp;1.708 m<br><b>Höhendifferenz:&nbsp;</b>617 m<br><b>Fahrzeit:&nbsp;</b>8 Minuten<br><b>Förderleistung:&nbsp;</b>bis zu 3.200 Pers./Std.' WHERE `ooo_id` = 5522 AND `language` = 'de';

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

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

UPDATE
  object_store_vcloud_poi
SET
  `oo_id` = ?,
  `reference` = ?,
  `feratelReference` = ?,
  `outdoorActiveReference` = ?,
  `redirectReference` = ?,
  `isActive` = ?,
  `isAccommodation` = ?,
  `isBookable` = ?,
  `isOpen` = ?,
  `openingStatus` = ?,
  `guestCardIncluded` = ?,
  `guestCardDiscounted` = ?,
  `guestCardPremium` = ?,
  `guestCardAlpenregion` = ?,
  `guestCardWalsertalSummer` = ?,
  `guestCardWalsertalWinter` = ?,
  `guestCardBrandnertal` = ?,
  `guestCardPremiumBrandnertal` = ?,
  `numberOfRooms` = ?,
  `totalNumberOfBeds` = ?,
  `checkinTime` = ?,
  `checkinTimeMax` = ?,
  `checkoutTimeMin` = ?,
  `checkoutTime` = ?,
  `logo__images` = ?,
  `logo__hotspots` = ?,
  `gallery__images` = ?,
  `gallery__hotspots` = ?
WHERE
  `oo_id` = ?

UPDATE object_store_vcloud_poi SET `oo_id` = 5522, `reference` = '2080b209-9424-4583-b56d-65649d50bc4e', `feratelReference` = 'f07fd865-f6a5-4a34-88cd-e8b2a0905fb9', `outdoorActiveReference` = NULL, `redirectReference` = NULL, `isActive` = 1, `isAccommodation` = 0, `isBookable` = 0, `isOpen` = 1, `openingStatus` = 'open', `guestCardIncluded` = 1, `guestCardDiscounted` = 0, `guestCardPremium` = 1, `guestCardAlpenregion` = 0, `guestCardWalsertalSummer` = 0, `guestCardWalsertalWinter` = 0, `guestCardBrandnertal` = 0, `guestCardPremiumBrandnertal` = 1, `numberOfRooms` = NULL, `totalNumberOfBeds` = NULL, `checkinTime` = NULL, `checkinTimeMax` = NULL, `checkoutTimeMin` = NULL, `checkoutTime` = NULL, `logo__images` = '', `logo__hotspots` = 'a:0:{}', `gallery__images` = ',30994,', `gallery__hotspots` = 'a:1:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}' WHERE `oo_id` = 5522;

SHOW COLUMNS
FROM
  object_store_vcloud_poi

SHOW COLUMNS FROM object_store_vcloud_poi;

SHOW COLUMNS
FROM
  object_localized_query_vcloud_poi_en

SHOW COLUMNS FROM object_localized_query_vcloud_poi_en;

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'en'
  and ooo_id = 5522
  and fieldname = 'contentblocks'
  and `index` = 1

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'en' and  ooo_id  = 5522 and fieldname = 'contentblocks' and `index` =  1;

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 = 30994;

SELECT
  name,
  type,
  data,
  cid,
  inheritable,
  cpath
FROM
  properties
WHERE
  (
    (
      cid IN (1, 1727, 518)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,1727,518) AND inheritable = 1)
                         OR cid = 5522 ) AND ctype='object';

SHOW COLUMNS
FROM
  object_brick_localized_query_Address_vcloud_poi_en

SHOW COLUMNS FROM object_brick_localized_query_Address_vcloud_poi_en;

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

SELECT id FROM objects WHERE `path` = BINARY '/VCloud/Poi/' AND `key` = BINARY 'Loischkopfbahn_2080b209-9424-4583-b56d-65649d50bc4e';

SHOW COLUMNS
FROM
  object_query_vcloud_poi

SHOW COLUMNS FROM object_query_vcloud_poi;

SHOW COLUMNS
FROM
  object_brick_query_Address_vcloud_poi

SHOW COLUMNS FROM object_brick_query_Address_vcloud_poi;

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` = 5522, `language` = 'de', `fieldname` = 'address', `index` = 0, `email` = 'station@brandnertal.at', `telephone` = '+43 5559 2240', `url` = 'https://www.vorarlberg-alpenregion.at/brandnertal/bergbahnen/' WHERE `ooo_id` = 5522 AND `index` = 0 AND `fieldname` = 'address' AND `language` = 'de';

SELECT
  id,
  targetType,
  targetId
FROM
  dependencies
WHERE
  sourceType = ?
  AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 5522;

UPDATE
  object_query_vcloud_poi
SET
  `reference` = ?,
  `feratelReference` = ?,
  `outdoorActiveReference` = ?,
  `redirectReference` = ?,
  `isActive` = ?,
  `isAccommodation` = ?,
  `isBookable` = ?,
  `isOpen` = ?,
  `openingStatus` = ?,
  `municipality` = ?,
  `categories` = ?,
  `infrastructures` = ?,
  `places` = ?,
  `portals` = ?,
  `guestCardIncluded` = ?,
  `guestCardDiscounted` = ?,
  `guestCardPremium` = ?,
  `guestCardAlpenregion` = ?,
  `guestCardWalsertalSummer` = ?,
  `guestCardWalsertalWinter` = ?,
  `guestCardBrandnertal` = ?,
  `guestCardPremiumBrandnertal` = ?,
  `numberOfRooms` = ?,
  `totalNumberOfBeds` = ?,
  `checkinTime` = ?,
  `checkinTimeMax` = ?,
  `checkoutTimeMin` = ?,
  `checkoutTime` = ?,
  `logo__images` = ?,
  `logo__hotspots` = ?,
  `gallery__images` = ?,
  `gallery__hotspots` = ?,
  `features` = ?,
  `poiFeatures` = ?,
  `events` = ?,
  `oo_id` = ?
WHERE
  `oo_id` = ?

UPDATE object_query_vcloud_poi SET `reference` = '2080b209-9424-4583-b56d-65649d50bc4e', `feratelReference` = 'f07fd865-f6a5-4a34-88cd-e8b2a0905fb9', `outdoorActiveReference` = NULL, `redirectReference` = NULL, `isActive` = 1, `isAccommodation` = 0, `isBookable` = 0, `isOpen` = 1, `openingStatus` = 'open', `municipality` = ',4853,4877,8006,', `categories` = ',1422,', `infrastructures` = ',5800,5817,', `places` = ',671,', `portals` = NULL, `guestCardIncluded` = 1, `guestCardDiscounted` = 0, `guestCardPremium` = 1, `guestCardAlpenregion` = 0, `guestCardWalsertalSummer` = 0, `guestCardWalsertalWinter` = 0, `guestCardBrandnertal` = 0, `guestCardPremiumBrandnertal` = 1, `numberOfRooms` = NULL, `totalNumberOfBeds` = NULL, `checkinTime` = NULL, `checkinTimeMax` = NULL, `checkoutTimeMin` = NULL, `checkoutTime` = NULL, `logo__images` = '', `logo__hotspots` = 'a:0:{}', `gallery__images` = ',30994,', `gallery__hotspots` = 'a:1:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', `features` = NULL, `poiFeatures` = NULL, `events` = NULL, `oo_id` = 5522 WHERE `oo_id` = 5522;

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

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

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'de'
  and ooo_id = 5522
  and fieldname = 'contentblocks'
  and `index` = 1

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'de' and  ooo_id  = 5522 and fieldname = 'contentblocks' and `index` =  1;

SELECT
  *
FROM
  object_query_vcloud_poi
WHERE
  oo_id = ?

SELECT * FROM object_query_vcloud_poi WHERE oo_id = 5522;

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` = 5522, `language` = 'de', `title` = 'Loischkopfbahn', `slug` = 'loischkopfbahn-5', `guestCardIncludedText` = 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `guestCardDiscountedText` = NULL, `guestCardPremiumText` = 'Mit der Gästekarte Premium Bludenz & Klostertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `guestCardBrandnertalText` = NULL, `guestCardPremiumBrandnertalText` = 'Mit der Gästekarte Premium Brandnertal ist die&nbsp;Bergbahnfahrt für Fußgänger:innen inkludiert.', `description` = 'Die Loischkopfbahn befördert&nbsp;Dich in wenigen Minuten auf 1.785 m Seehöhe.', `text` = 'Die Loischkopfbahn ist der ideale Ausgangspunkt für Wanderungen und Mountainbike-Touren im Brandnertal. Der Loischkopf ist einer der schönsten Aussichtpunkte in Vorarlberg. Vom Gipfel hast Du einen Rundblick vom Bodensee, Walgau, Klostertal, dem Rätikon Gebirge bis zur Schesaplana. <br><br><a href=\"https://www.vorarlberg-alpenregion.at/de/brandnertal/bergbahnen-brandnertal-oeffnungszeiten.html\">Hier</a> geht es zu den aktuellen Betriebszeiten.<br><br><b>Technische Daten<br></b><br><b>Bahntyp:&nbsp;</b>Einseilumlaufbahn mit 10er-Kabinen (Doppelmayr)<br><b>Länge:</b>&nbsp;1.708 m<br><b>Höhendifferenz:&nbsp;</b>617 m<br><b>Fahrzeit:&nbsp;</b>8 Minuten<br><b>Förderleistung:&nbsp;</b>bis zu 3.200 Pers./Std.', `search_index` = '<p>Mit der Gästekarte Premium Bludenz &amp; Klostertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
<p>Mit der Gästekarte Premium Brandnertal ist die Bergbahnfahrt für Fußgänger:innen inkludiert.</p>
' WHERE `ooo_id` = 5522 AND `language` = 'de';

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` = 5522, `fieldname` = 'address', `coordinates__longitude` = 9.7526425083984, `coordinates__latitude` = 47.139335231208, `country` = 'AT', `locality` = 'Bürserberg', `postalCode` = '6707', `street` = 'Tschengla 3' WHERE `id` = 5522 AND `fieldname` = 'address';

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

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

INSERT INTO object_store_vcloud_poi (
  `oo_id`, `reference`, `feratelReference`,
  `outdoorActiveReference`, `redirectReference`,
  `isActive`, `isAccommodation`, `isBookable`,
  `isOpen`, `openingStatus`, `guestCardIncluded`,
  `guestCardDiscounted`, `guestCardPremium`,
  `guestCardAlpenregion`, `guestCardWalsertalSummer`,
  `guestCardWalsertalWinter`, `guestCardBrandnertal`,
  `guestCardPremiumBrandnertal`,
  `numberOfRooms`, `totalNumberOfBeds`,
  `checkinTime`, `checkinTimeMax`,
  `checkoutTimeMin`, `checkoutTime`,
  `logo__images`, `logo__hotspots`,
  `gallery__images`, `gallery__hotspots`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_store_vcloud_poi (`oo_id`, `reference`, `feratelReference`, `outdoorActiveReference`, `redirectReference`, `isActive`, `isAccommodation`, `isBookable`, `isOpen`, `openingStatus`, `guestCardIncluded`, `guestCardDiscounted`, `guestCardPremium`, `guestCardAlpenregion`, `guestCardWalsertalSummer`, `guestCardWalsertalWinter`, `guestCardBrandnertal`, `guestCardPremiumBrandnertal`, `numberOfRooms`, `totalNumberOfBeds`, `checkinTime`, `checkinTimeMax`, `checkoutTimeMin`, `checkoutTime`, `logo__images`, `logo__hotspots`, `gallery__images`, `gallery__hotspots`) VALUES (5522, '2080b209-9424-4583-b56d-65649d50bc4e', 'f07fd865-f6a5-4a34-88cd-e8b2a0905fb9', NULL, NULL, 1, 0, 0, 1, 'open', 1, 0, 1, 0, 0, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, '', 'a:0:{}', ',30994,', 'a:1:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}');

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'de'
  and ooo_id = 5522
  and fieldname = 'contentblocks'
  and `index` = 2

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'de' and  ooo_id  = 5522 and fieldname = 'contentblocks' and `index` =  2;

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

SELECT * FROM object_brick_localized_Address_vcloud_poi WHERE ooo_id = 5522 AND language IN ('de','en') AND `fieldname` = 'address';

SELECT
  `ooo_id`
FROM
  `object_collection_vcloudExternalLink_localized_vcloud_poi`
WHERE
  `ooo_id` = '5522'
  AND `fieldname` = 'externalLinks'
LIMIT
  1

SELECT `ooo_id` FROM `object_collection_vcloudExternalLink_localized_vcloud_poi` WHERE
         `ooo_id` = '5522' AND `fieldname` = 'externalLinks' LIMIT 1 ;

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` = 5522, `fieldname` = 'address', `coordinates__longitude` = 9.7526425083984, `coordinates__latitude` = 47.139335231208, `country` = 'AT', `locality` = 'Bürserberg', `postalCode` = '6707', `street` = 'Tschengla 3' WHERE id = 5522;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 0;

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'de'
  and ooo_id = 5522
  and fieldname = 'contentblocks'
  and `index` = 3

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'de' and  ooo_id  = 5522 and fieldname = 'contentblocks' and `index` =  3;

SELECT
  `id`
FROM
  `object_collection_vcloudContentblock_vcloud_poi`
WHERE
  `id` = '5522'
  AND `fieldname` = 'contentblocks'
LIMIT
  1

SELECT `id` FROM `object_collection_vcloudContentblock_vcloud_poi` WHERE `id` = '5522' AND `fieldname` = 'contentblocks' LIMIT 1;

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

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

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

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

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 (5522, 'address', 9.7526425083984, 47.139335231208, 'AT', 'Bürserberg', '6707', 'Tschengla 3');

SELECT
  *
FROM
  object_store_vcloud_poi
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_vcloud_poi WHERE oo_id = 5522 FOR UPDATE;

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 (5522, 'de', 'station@brandnertal.at', '+43 5559 2240', 'https://www.vorarlberg-alpenregion.at/brandnertal/bergbahnen/');

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

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

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 5522 FOR UPDATE;