Symfony Profiler

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/webhook/' AND `key` = BINARY 'update-live-data';

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 (5549, 'de', 'contentblocks', 0, 'Detailbeschreibung', '<p>Der Lünersee, einst als einer der größten natürlichen Bergseen der Ostalpen bekannt, liegt auf knapp 2.000 Metern Höhe und bildet das Talende des Brandnertals. Die Natur rund um den See bietet für Familien, Bergbegeisterte und Aktive viele Möglichkeiten. <br /><br /> Als Ausgangspunkt für Wanderungen, unter anderem zur Schesaplana – dem höchsten Gipfel im Rätikon- , für einen Spaziergang rund um den See oder für Klettertouren. <br /><br /> Auch für Fischer bietet der kristallklare See optimale Bedingungen. </p>
', 'a:0:{}');

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 = 5549 AND language IN ('de','en') AND `fieldname` = 'openingHours' AND `index` = 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` = 'f6fe46d4-4ce8-4885-abce-696c70ac6a9c'
    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` = 'f6fe46d4-4ce8-4885-abce-696c70ac6a9c'  AND  object_localized_vcloud_poi_en.type IN ('variant','object')) AND object_localized_vcloud_poi_en.published = 1 LIMIT 1;

UPDATE
  object_store_vcloud_poi
SET
  `oo_id` = ?,
  `reference` = ?,
  `feratelReference` = ?,
  `outdoorActiveReference` = ?,
  `redirectReference` = ?,
  `isActive` = ?,
  `isAccommodation` = ?,
  `isBookable` = ?,
  `isOpen` = ?,
  `openingStatus` = ?,
  `guestCardIncluded` = ?,
  `guestCardDiscounted` = ?,
  `guestCardPremium` = ?,
  `guestCardAlpenregion` = ?,
  `guestCardWalsertalSummer` = ?,
  `guestCardWalsertalWinter` = ?,
  `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` = 5549, `reference` = 'f6fe46d4-4ce8-4885-abce-696c70ac6a9c', `feratelReference` = 'cf041a49-3d45-40ec-a8ed-338b6c7ba95c', `outdoorActiveReference` = NULL, `redirectReference` = NULL, `isActive` = 1, `isAccommodation` = 0, `isBookable` = 0, `isOpen` = 0, `openingStatus` = 'closed', `guestCardIncluded` = 0, `guestCardDiscounted` = 0, `guestCardPremium` = 0, `guestCardAlpenregion` = 0, `guestCardWalsertalSummer` = 0, `guestCardWalsertalWinter` = 0, `numberOfRooms` = NULL, `totalNumberOfBeds` = NULL, `checkinTime` = NULL, `checkinTimeMax` = NULL, `checkoutTimeMin` = NULL, `checkoutTime` = NULL, `logo__images` = '', `logo__hotspots` = 'a:0:{}', `gallery__images` = ',23023,', `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` = 5549;

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

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

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

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

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

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

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

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'vcloud_poi';

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

SELECT id FROM objects WHERE `path` = BINARY '/VCloud/Poi/' AND `key` = BINARY 'Lünerseebahn_f6fe46d4-4ce8-4885-abce-696c70ac6a9c';

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` = 5549, `language` = 'de', `email` = 'info@gsl-tourismus.at', `telephone` = '+43 5556 701 83167', `url` = 'http://www.luenersee.at' WHERE `ooo_id` = 5549 AND `language` = 'de';

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;

INSERT INTO object_store_vcloud_poi (
  `oo_id`, `reference`, `feratelReference`,
  `outdoorActiveReference`, `redirectReference`,
  `isActive`, `isAccommodation`, `isBookable`,
  `isOpen`, `openingStatus`, `guestCardIncluded`,
  `guestCardDiscounted`, `guestCardPremium`,
  `guestCardAlpenregion`, `guestCardWalsertalSummer`,
  `guestCardWalsertalWinter`, `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`, `numberOfRooms`, `totalNumberOfBeds`, `checkinTime`, `checkinTimeMax`, `checkoutTimeMin`, `checkoutTime`, `logo__images`, `logo__hotspots`, `gallery__images`, `gallery__hotspots`) VALUES (5549, 'f6fe46d4-4ce8-4885-abce-696c70ac6a9c', 'cf041a49-3d45-40ec-a8ed-338b6c7ba95c', NULL, NULL, 1, 0, 0, 0, 'closed', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', 'a:0:{}', ',23023,', 'a:1:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}');

INSERT INTO object_collection_vcloudExternalLink_vcloud_poi (
  `id`, `index`, `fieldname`, `reference`,
  `linkType`
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudExternalLink_vcloud_poi (`id`, `index`, `fieldname`, `reference`, `linkType`) VALUES (5549, 0, 'externalLinks', '39132d07-00d8-4bb9-b87d-0db7afe6dc33', 'externalLink');

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

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

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 = 5549 AND language IN ('de','en') AND `fieldname` = 'contentblocks' AND `index` = 0;

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

INSERT INTO object_localized_query_vcloud_poi_de (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `description`) VALUES (5549, 'de', 'Lünerseebahn', 'luenerseebahn-1-v6ysfreo', 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', NULL, 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', NULL, NULL, NULL, 'Die Lünerseebahn ist nicht nur ein Transportmittel, sondern ein Tor zu einem der atemberaubendsten Naturerlebnisse.');

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/', 5549, 1741246432, 1775556559, 4, 0, 0, 1727, 'object', 'Lünerseebahn_f6fe46d4-4ce8-4885-abce-696c70ac6a9c', 0, NULL, NULL, 'vcloud_poi', 1, 'Poi');

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

UPDATE object_localized_data_vcloud_poi SET `ooo_id` = 5549, `language` = 'de', `title` = 'Lünerseebahn', `slug` = 'luenerseebahn-1-v6ysfreo', `guestCardIncludedText` = 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', `guestCardDiscountedText` = NULL, `guestCardPremiumText` = 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `description` = 'Die Lünerseebahn ist nicht nur ein Transportmittel, sondern ein Tor zu einem der atemberaubendsten Naturerlebnisse.' WHERE `ooo_id` = 5549 AND `language` = 'de';

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

select `links` from object_collection_vcloudContentblock_localized_vcloud_poi where language = 'en' and  ooo_id  = 5549 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` = 5549, `creationDate` = 1741246432, `modificationDate` = 1775556559, `versionCount` = 4, `userOwner` = 0, `userModification` = 0, `parentId` = 1727, `type` = 'object', `key` = 'Lünerseebahn_f6fe46d4-4ce8-4885-abce-696c70ac6a9c', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'vcloud_poi', `published` = 1, `className` = 'Poi' WHERE `id` = 5549;

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 (5549, 0, 'contentblocks', '', 'a:0:{}');

"ROLLBACK"

"ROLLBACK";

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

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

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

INSERT INTO object_localized_data_vcloud_poi (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `description`) VALUES (5549, 'de', 'Lünerseebahn', 'luenerseebahn-1-v6ysfreo', 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', NULL, 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', NULL, NULL, NULL, 'Die Lünerseebahn ist nicht nur ein Transportmittel, sondern ein Tor zu einem der atemberaubendsten Naturerlebnisse.');

INSERT INTO object_collection_vcloudExternalLink_localized_vcloud_poi (
  `ooo_id`, `language`, `fieldname`,
  `index`, `name`, `url`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_vcloudExternalLink_localized_vcloud_poi (`ooo_id`, `language`, `fieldname`, `index`, `name`, `url`) VALUES (5549, 'de', 'externalLinks', 0, 'Homepage', 'http://www.luenersee.at');

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 = 5549 AND language IN ('de','en') AND `fieldname` = 'externalLinks' AND `index` = 0;

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

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

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` = 5549, `language` = 'de', `fieldname` = 'address', `index` = 0, `email` = 'info@gsl-tourismus.at', `telephone` = '+43 5556 701 83167', `url` = 'http://www.luenersee.at' WHERE `ooo_id` = 5549 AND `index` = 0 AND `fieldname` = 'address' AND `language` = 'de';

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

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

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 (5549, 'de', 'address', 0, 'info@gsl-tourismus.at', '+43 5556 701 83167', 'http://www.luenersee.at');

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

INSERT INTO object_collection_vcloudOpeningHours_localized_vcloud_poi (`ooo_id`, `language`, `fieldname`, `index`, `description`) VALUES (5549, 'de', 'openingHours', 0, NULL);

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

UPDATE object_localized_query_vcloud_poi_en SET `ooo_id` = 5549, `language` = 'en', `title` = 'Lünersee Cable Car', `slug` = 'luenersee-cable-car-vk8xl128', `guestCardIncludedText` = 'With the Guest Card Premium Klostertal, Bludenz, the mountain railway ride for pedestrians is included.', `guestCardDiscountedText` = NULL, `guestCardPremiumText` = 'With the Guest Card Premium Klostertal, Bludenz, the mountain railway ride for pedestrians is included.', `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `description` = '<p>The Lünerseebahn is not just a means of transportation, but a gateway to one of nature\'s most breathtaking experiences.</p>' WHERE `ooo_id` = 5549 AND `language` = 'en';

DELETE FROM
  object_collection_vcloudContentblock_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudContentblock_localized_vcloud_poi WHERE ooo_id = 5549 AND fieldname = 'contentblocks';

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

INSERT INTO object_localized_query_vcloud_poi_en (`ooo_id`, `language`, `title`, `slug`, `guestCardIncludedText`, `guestCardDiscountedText`, `guestCardPremiumText`, `guestCardAlpenregionText`, `guestCardWalsertalSummerText`, `guestCardWalsertalWinterText`, `description`) VALUES (5549, 'en', 'Lünersee Cable Car', 'luenersee-cable-car-vk8xl128', 'With the Guest Card Premium Klostertal, Bludenz, the mountain railway ride for pedestrians is included.', NULL, 'With the Guest Card Premium Klostertal, Bludenz, the mountain railway ride for pedestrians is included.', NULL, NULL, NULL, '<p>The Lünerseebahn is not just a means of transportation, but a gateway to one of nature\'s most breathtaking experiences.</p>');

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

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

SELECT
  *
FROM
  object_query_vcloud_poi
WHERE
  oo_id = ?

SELECT * FROM object_query_vcloud_poi WHERE oo_id = 5549;

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

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

SELECT
  *
FROM
  object_relations_vcloud_poi
WHERE
  src_id = ?

SELECT * FROM object_relations_vcloud_poi WHERE src_id = 5549;

DELETE FROM
  object_collection_vcloudExternalLink_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudExternalLink_localized_vcloud_poi WHERE ooo_id = 5549 AND fieldname = 'externalLinks';

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

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

SELECT
  `id`
FROM
  `object_collection_vcloudExternalLink_vcloud_poi`
WHERE
  `id` = '5549'
  AND `fieldname` = 'externalLinks'
LIMIT
  1

SELECT `id` FROM `object_collection_vcloudExternalLink_vcloud_poi` WHERE `id` = '5549' AND `fieldname` = 'externalLinks' LIMIT 1;

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

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

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

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

SELECT
  *
FROM
  object_brick_query_Address_vcloud_poi
WHERE
  id = ?

SELECT * FROM object_brick_query_Address_vcloud_poi WHERE id = 5549;

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` = 5549, `language` = 'en', `email` = 'info@gsl-tourismus.at', `telephone` = '+43 5556 701 83167', `url` = 'http://www.luenersee.at' WHERE `ooo_id` = 5549 AND `language` = 'en';

DELETE FROM
  object_collection_vcloudOpeningHours_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?

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

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 (5549, 'en', 'info@gsl-tourismus.at', '+43 5556 701 83167', 'http://www.luenersee.at');

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

UPDATE object_localized_query_vcloud_poi_de SET `ooo_id` = 5549, `language` = 'de', `title` = 'Lünerseebahn', `slug` = 'luenerseebahn-1-v6ysfreo', `guestCardIncludedText` = 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', `guestCardDiscountedText` = NULL, `guestCardPremiumText` = 'Mit der Gästekarte Premium Klostertal, Bludenz ist die Bergbahnfahrt inkludiert.', `guestCardAlpenregionText` = NULL, `guestCardWalsertalSummerText` = NULL, `guestCardWalsertalWinterText` = NULL, `description` = 'Die Lünerseebahn ist nicht nur ein Transportmittel, sondern ein Tor zu einem der atemberaubendsten Naturerlebnisse.' WHERE `ooo_id` = 5549 AND `language` = 'de';

INSERT INTO object_query_vcloud_poi (
  `reference`, `feratelReference`,
  `outdoorActiveReference`, `redirectReference`,
  `isActive`, `isAccommodation`, `isBookable`,
  `isOpen`, `openingStatus`, `guestCardIncluded`,
  `guestCardDiscounted`, `guestCardPremium`,
  `guestCardAlpenregion`, `guestCardWalsertalSummer`,
  `guestCardWalsertalWinter`, `numberOfRooms`,
  `totalNumberOfBeds`, `checkinTime`,
  `checkinTimeMax`, `checkoutTimeMin`,
  `checkoutTime`, `logo__images`,
  `logo__hotspots`, `gallery__images`,
  `gallery__hotspots`, `infrastructures`,
  `municipality`, `categories`, `tags`,
  `places`, `linkedThings`, `features`,
  `poiFeatures`, `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO object_query_vcloud_poi (`reference`, `feratelReference`, `outdoorActiveReference`, `redirectReference`, `isActive`, `isAccommodation`, `isBookable`, `isOpen`, `openingStatus`, `guestCardIncluded`, `guestCardDiscounted`, `guestCardPremium`, `guestCardAlpenregion`, `guestCardWalsertalSummer`, `guestCardWalsertalWinter`, `numberOfRooms`, `totalNumberOfBeds`, `checkinTime`, `checkinTimeMax`, `checkoutTimeMin`, `checkoutTime`, `logo__images`, `logo__hotspots`, `gallery__images`, `gallery__hotspots`, `infrastructures`, `municipality`, `categories`, `tags`, `places`, `linkedThings`, `features`, `poiFeatures`, `oo_id`) VALUES ('f6fe46d4-4ce8-4885-abce-696c70ac6a9c', 'cf041a49-3d45-40ec-a8ed-338b6c7ba95c', NULL, NULL, 1, 0, 0, 0, 'closed', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '', 'a:0:{}', ',23023,', 'a:1:{i:0;s:63:\"a:3:{s:8:\"hotspots\";a:0:{}s:6:\"marker\";a:0:{}s:4:\"crop\";a:0:{}}\";}', ',5800,5817,', ',4853,4879,', ',1422,', NULL, ',672,', NULL, NULL, NULL, 5549);

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 5549 FOR UPDATE;

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

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

DELETE FROM
  object_collection_vcloudContentblock_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudContentblock_vcloud_poi WHERE id = 5549 AND fieldname = 'contentblocks';

DELETE FROM
  object_collection_vcloudOpeningHours_localized_vcloud_poi
WHERE
  ooo_id = ?
  AND fieldname = ?

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

SELECT
  id
FROM
  object_brick_store_Address_vcloud_poi
WHERE
  id = ?
LIMIT
  1

SELECT id FROM object_brick_store_Address_vcloud_poi WHERE id = 5549 LIMIT 1;

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

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

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

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

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 1;

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

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

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

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

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

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

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

DELETE FROM
  object_collection_vcloudExternalLink_vcloud_poi
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_vcloudExternalLink_vcloud_poi WHERE id = 5549 AND fieldname = 'externalLinks';

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'de'
  and ooo_id = 5549
  and fieldname = 'contentblocks'
  and `index` = 0

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

select
  `links`
from
  object_collection_vcloudContentblock_localized_vcloud_poi
where
  language = 'en'
  and ooo_id = 5549
  and fieldname = 'contentblocks'
  and `index` = 0

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

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

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

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

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

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

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

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

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

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` = 5549, `fieldname` = 'address', `coordinates__longitude` = 9.7544204413086, `coordinates__latitude` = 47.067723191317, `country` = 'AT', `locality` = 'Brand', `postalCode` = '6708', `street` = 'Schattenlagant' WHERE id = 5549;