Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_bf340ca7d22ee2e1c8e31157b737807c');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

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 '/pimcore-graphql-webservices/' AND `key` = BINARY 'Material';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices/Material';

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'pimcore-graphql-webservices';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/pimcore-graphql-webservices';

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

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

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1');

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

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = 1
                             ) AND ctype='document';

SELECT
  id,
  name
FROM
  classes

SELECT id, name FROM classes;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'SapMaterial';

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'SapMaterial';

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_433730');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_433730
tags
', 'class_1
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_432550');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_432550
tags
', 'class_1
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_420558');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_420558
tags
', 'class_1
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_225498');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_225498
tags
', 'class_8
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_15
tags
', 'class_11
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2
tags
', 'class_7
tags
');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1
tags
');

SELECT
  `update`
FROM
  plugin_datahub_workspaces_object
WHERE
  cid IN (
    1, 432550, 420558, 225498, 15, 2, 1, 433730
  )
  AND configuration = 'Material'
  AND `update` = 1
ORDER BY
  LENGTH(cpath) DESC
LIMIT
  1

SELECT `update` FROM plugin_datahub_workspaces_object WHERE cid IN (1,432550,420558,225498,15,2,1,433730) AND configuration = 'Material' AND `update`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1;

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

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

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

SELECT id FROM objects WHERE `path` = BINARY '/SAP-ROOT/MATERIALMASTER/10/1040/104010/' AND `key` = BINARY '1040100550';

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

SELECT id FROM objects WHERE `path` = BINARY '/SAP-ROOT/MATERIALMASTER/10/1040/104010/' AND `key` = BINARY '1040100550';

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 433730;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 432550;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 420558;

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

SELECT * FROM object_collection_DekorverbundBoardManufacturer_1 WHERE id = 433730 AND fieldname = 'BoardManufacturer' ORDER BY `index` ASC;

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

SELECT * FROM object_collection_DekorverbundPaperPrinter_1 WHERE id = 433730 AND fieldname = 'PaperPrinter' ORDER BY `index` ASC;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 433730 FOR UPDATE;

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

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

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_objects');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects');

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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

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

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 ('/SAP-ROOT/MATERIALMASTER/10/1040/104010/', 433730, 1737665036, 1765008711, 6, 0, 0, 432550, 'object', '1040100550', 0, NULL, NULL, '1', 1, 'SapMaterial');

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` = '/SAP-ROOT/MATERIALMASTER/10/1040/104010/', `id` = 433730, `creationDate` = 1737665036, `modificationDate` = 1765008711, `versionCount` = 6, `userOwner` = 0, `userModification` = 0, `parentId` = 432550, `type` = 'object', `key` = '1040100550', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = '1', `published` = 1, `className` = 'SapMaterial' WHERE `id` = 433730;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_localized_data_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_localized_data_1');

SHOW COLUMNS
FROM
  object_localized_data_1

SHOW COLUMNS FROM object_localized_data_1;

INSERT INTO object_localized_data_1 (
  `ooo_id`, `language`, `MarketingTextLocalized`,
  `SapShortTextLocalized`, `BusinessUnitTitle`,
  `BusinessAreaTitle`, `ApplicationAreaTitle`,
  `AccessoryMainTitle`, `AccessorySubTitle`,
  `ShortDescription`, `LongDescription`,
  `SearchKeys`, `Document_1_Title`,
  `Document_2_Title`, `Document_3_Title`,
  `Document_4_Title`, `Video_1_Title`,
  `Video_1_Type`, `Video_1`, `Video_2_Title`,
  `Video_2_Type`, `Video_2`, `PrintDataDokumentTitle`,
  `PrintDataDokumentDesc`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_localized_data_1 (`ooo_id`, `language`, `MarketingTextLocalized`, `SapShortTextLocalized`, `BusinessUnitTitle`, `BusinessAreaTitle`, `ApplicationAreaTitle`, `AccessoryMainTitle`, `AccessorySubTitle`, `ShortDescription`, `LongDescription`, `SearchKeys`, `Document_1_Title`, `Document_2_Title`, `Document_3_Title`, `Document_4_Title`, `Video_1_Title`, `Video_1_Type`, `Video_1`, `Video_2_Title`, `Video_2_Type`, `Video_2`, `PrintDataDokumentTitle`, `PrintDataDokumentDesc`) VALUES (433730, 'en', 'RENOLIT PRODECO', 'WF-OPAK HANDELSWARE ROT', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);

UPDATE
  object_localized_data_1
SET
  `ooo_id` = ?,
  `language` = ?,
  `MarketingTextLocalized` = ?,
  `SapShortTextLocalized` = ?,
  `BusinessUnitTitle` = ?,
  `BusinessAreaTitle` = ?,
  `ApplicationAreaTitle` = ?,
  `AccessoryMainTitle` = ?,
  `AccessorySubTitle` = ?,
  `ShortDescription` = ?,
  `LongDescription` = ?,
  `SearchKeys` = ?,
  `Document_1_Title` = ?,
  `Document_2_Title` = ?,
  `Document_3_Title` = ?,
  `Document_4_Title` = ?,
  `Video_1_Title` = ?,
  `Video_1_Type` = ?,
  `Video_1` = ?,
  `Video_2_Title` = ?,
  `Video_2_Type` = ?,
  `Video_2` = ?,
  `PrintDataDokumentTitle` = ?,
  `PrintDataDokumentDesc` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_data_1 SET `ooo_id` = 433730, `language` = 'en', `MarketingTextLocalized` = 'RENOLIT PRODECO', `SapShortTextLocalized` = 'WF-OPAK HANDELSWARE ROT', `BusinessUnitTitle` = '', `BusinessAreaTitle` = '', `ApplicationAreaTitle` = '', `AccessoryMainTitle` = '', `AccessorySubTitle` = '', `ShortDescription` = NULL, `LongDescription` = NULL, `SearchKeys` = NULL, `Document_1_Title` = NULL, `Document_2_Title` = NULL, `Document_3_Title` = NULL, `Document_4_Title` = NULL, `Video_1_Title` = NULL, `Video_1_Type` = '', `Video_1` = NULL, `Video_2_Title` = NULL, `Video_2_Type` = '', `Video_2` = NULL, `PrintDataDokumentTitle` = NULL, `PrintDataDokumentDesc` = NULL WHERE `ooo_id` = 433730 AND `language` = 'en';

SELECT
  *
FROM
  object_localized_query_1_en
WHERE
  ooo_id = 433730
  AND language = 'en'

SELECT * FROM object_localized_query_1_en WHERE ooo_id = 433730 AND language = 'en';

SELECT
  *
FROM
  object_localized_query_1_en
WHERE
  ooo_id = ?
  AND language = ? FOR
UPDATE

SELECT * FROM object_localized_query_1_en WHERE ooo_id = 432550 AND language = 'en' FOR UPDATE;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_localized_query_1_en');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1765008711 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_localized_query_1_en');

SHOW COLUMNS
FROM
  object_localized_query_1_en

SHOW COLUMNS FROM object_localized_query_1_en;

INSERT INTO object_localized_query_1_en (
  `ooo_id`, `language`, `MarketingTextLocalized`,
  `SapShortTextLocalized`, `BusinessUnitTitle`,
  `BusinessAreaTitle`, `ApplicationAreaTitle`,
  `AccessoryMainTitle`, `AccessorySubTitle`,
  `ShortDescription`, `LongDescription`,
  `SearchKeys`, `Document_1__id`,
  `Document_1__type`, `Document_1_Title`,
  `Document_2__id`, `Document_2__type`,
  `Document_2_Title`, `Document_3__id`,
  `Document_3__type`, `Document_3_Title`,
  `Document_4__id`, `Document_4__type`,
  `Document_4_Title`, `Video_1_Title`,
  `Video_1_Type`, `Video_1`, `Video_2_Title`,
  `Video_2_Type`, `Video_2`, `SkzCertificateDocument__id`,
  `SkzCertificateDocument__type`,
  `PrintDataDokumentTitle`, `PrintDataDokumentDesc`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO object_localized_query_1_en (`ooo_id`, `language`, `MarketingTextLocalized`, `SapShortTextLocalized`, `BusinessUnitTitle`, `BusinessAreaTitle`, `ApplicationAreaTitle`, `AccessoryMainTitle`, `AccessorySubTitle`, `ShortDescription`, `LongDescription`, `SearchKeys`, `Document_1__id`, `Document_1__type`, `Document_1_Title`, `Document_2__id`, `Document_2__type`, `Document_2_Title`, `Document_3__id`, `Document_3__type`, `Document_3_Title`, `Document_4__id`, `Document_4__type`, `Document_4_Title`, `Video_1_Title`, `Video_1_Type`, `Video_1`, `Video_2_Title`, `Video_2_Type`, `Video_2`, `SkzCertificateDocument__id`, `SkzCertificateDocument__type`, `PrintDataDokumentTitle`, `PrintDataDokumentDesc`) VALUES (433730, 'en', 'RENOLIT PRODECO', 'WF-OPAK HANDELSWARE ROT', 'PROTECT', 'PRODECO SOFT PVC', 'Opaque', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL);

UPDATE
  object_localized_query_1_en
SET
  `ooo_id` = ?,
  `language` = ?,
  `MarketingTextLocalized` = ?,
  `SapShortTextLocalized` = ?,
  `BusinessUnitTitle` = ?,
  `BusinessAreaTitle` = ?,
  `ApplicationAreaTitle` = ?,
  `AccessoryMainTitle` = ?,
  `AccessorySubTitle` = ?,
  `ShortDescription` = ?,
  `LongDescription` = ?,
  `SearchKeys` = ?,
  `Document_1__id` = ?,
  `Document_1__type` = ?,
  `Document_1_Title` = ?,
  `Document_2__id` = ?,
  `Document_2__type` = ?,
  `Document_2_Title` = ?,
  `Document_3__id` = ?,
  `Document_3__type` = ?,
  `Document_3_Title` = ?,
  `Document_4__id` = ?,
  `Document_4__type` = ?,
  `Document_4_Title` = ?,
  `Video_1_Title` = ?,
  `Video_1_Type` = ?,
  `Video_1` = ?,
  `Video_2_Title` = ?,
  `Video_2_Type` = ?,
  `Video_2` = ?,
  `SkzCertificateDocument__id` = ?,
  `SkzCertificateDocument__type` = ?,
  `PrintDataDokumentTitle` = ?,
  `PrintDataDokumentDesc` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_query_1_en SET `ooo_id` = 433730, `language` = 'en', `MarketingTextLocalized` = 'RENOLIT PRODECO', `SapShortTextLocalized` = 'WF-OPAK HANDELSWARE ROT', `BusinessUnitTitle` = 'PROTECT', `BusinessAreaTitle` = 'PRODECO SOFT PVC', `ApplicationAreaTitle` = 'Opaque', `AccessoryMainTitle` = '', `AccessorySubTitle` = '', `ShortDescription` = NULL, `LongDescription` = NULL, `SearchKeys` = NULL, `Document_1__id` = NULL, `Document_1__type` = NULL, `Document_1_Title` = NULL, `Document_2__id` = NULL, `Document_2__type` = NULL, `Document_2_Title` = NULL, `Document_3__id` = NULL, `Document_3__type` = NULL, `Document_3_Title` = NULL, `Document_4__id` = NULL, `Document_4__type` = NULL, `Document_4_Title` = NULL, `Video_1_Title` = NULL, `Video_1_Type` = '', `Video_1` = NULL, `Video_2_Title` = NULL, `Video_2_Type` = '', `Video_2` = NULL, `SkzCertificateDocument__id` = NULL, `SkzCertificateDocument__type` = NULL, `PrintDataDokumentTitle` = NULL, `PrintDataDokumentDesc` = NULL WHERE `ooo_id` = 433730 AND `language` = 'en';

WITH
  RECURSIVE cte(id, classId) as (
    SELECT
      c.id AS id,
      c.classId AS classId
    FROM
      objects c
    WHERE
      c.parentid = 433730
    UNION ALL
    SELECT
      p.id AS id,
      p.classId AS classId
    FROM
      objects p
      INNER JOIN cte on (p.parentid = cte.id)
  )
select
  x.id
FROM
  cte x
  LEFT JOIN object_localized_query_1_en l on (x.id = l.ooo_id)
where
  x.classId = '1'
  AND l.ooo_id is null;

WITH RECURSIVE cte(id, classId) as (
                        SELECT c.id AS id, c.classId AS classId
                        FROM objects c
                        WHERE c.parentid = 433730
                        UNION ALL
                        SELECT p.id AS id, p.classId AS classId
                        FROM objects p
                        INNER JOIN cte on (p.parentid = cte.id)
                    ) select x.id
                    FROM cte x
                    LEFT JOIN object_localized_query_1_en l on (x.id = l.ooo_id)
                    where x.classId = '1'
                    AND l.ooo_id is null;
                ;

SELECT
  *
FROM
  object_localized_query_1_en
WHERE
  ooo_id = ?

SELECT * FROM object_localized_query_1_en WHERE ooo_id = 433730;

INSERT INTO object_localized_data_1 (
  `ooo_id`, `language`, `MarketingTextLocalized`,
  `SapShortTextLocalized`, `BusinessUnitTitle`,
  `BusinessAreaTitle`, `ApplicationAreaTitle`,
  `AccessoryMainTitle`, `AccessorySubTitle`,
  `ShortDescription`, `LongDescription`,
  `SearchKeys`, `Document_1_Title`,
  `Document_2_Title`, `Document_3_Title`,
  `Document_4_Title`, `Video_1_Title`,
  `Video_1_Type`, `Video_1`, `Video_2_Title`,
  `Video_2_Type`, `Video_2`, `PrintDataDokumentTitle`,
  `PrintDataDokumentDesc`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_localized_data_1 (`ooo_id`, `language`, `MarketingTextLocalized`, `SapShortTextLocalized`, `BusinessUnitTitle`, `BusinessAreaTitle`, `ApplicationAreaTitle`, `AccessoryMainTitle`, `AccessorySubTitle`, `ShortDescription`, `LongDescription`, `SearchKeys`, `Document_1_Title`, `Document_2_Title`, `Document_3_Title`, `Document_4_Title`, `Video_1_Title`, `Video_1_Type`, `Video_1`, `Video_2_Title`, `Video_2_Type`, `Video_2`, `PrintDataDokumentTitle`, `PrintDataDokumentDesc`) VALUES (433730, 'de', 'RENOLIT PRODECO', 'WF-OPAK HANDELSWARE ROT', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL);

UPDATE
  object_localized_data_1
SET
  `ooo_id` = ?,
  `language` = ?,
  `MarketingTextLocalized` = ?,
  `SapShortTextLocalized` = ?,
  `BusinessUnitTitle` = ?,
  `BusinessAreaTitle` = ?,
  `ApplicationAreaTitle` = ?,
  `AccessoryMainTitle` = ?,
  `AccessorySubTitle` = ?,
  `ShortDescription` = ?,
  `LongDescription` = ?,
  `SearchKeys` = ?,
  `Document_1_Title` = ?,
  `Document_2_Title` = ?,
  `Document_3_Title` = ?,
  `Document_4_Title` = ?,
  `Video_1_Title` = ?,
  `Video_1_Type` = ?,
  `Video_1` = ?,
  `Video_2_Title` = ?,
  `Video_2_Type` = ?,
  `Video_2` = ?,
  `PrintDataDokumentTitle` = ?,
  `PrintDataDokumentDesc` = ?
WHERE
  `ooo_id` = ?
  AND `language` = ?

UPDATE object_localized_data_1 SET `ooo_id` = 433730, `language` = 'de', `MarketingTextLocalized` = 'RENOLIT PRODECO', `SapShortTextLocalized` = 'WF-OPAK HANDELSWARE ROT', `BusinessUnitTitle` = '', `BusinessAreaTitle` = '', `ApplicationAreaTitle` = '', `AccessoryMainTitle` = '', `AccessorySubTitle` = '', `ShortDescription` = NULL, `LongDescription` = NULL, `SearchKeys` = NULL, `Document_1_Title` = NULL, `Document_2_Title` = NULL, `Document_3_Title` = NULL, `Document_4_Title` = NULL, `Video_1_Title` = NULL, `Video_1_Type` = '', `Video_1` = NULL, `Video_2_Title` = NULL, `Video_2_Type` = '', `Video_2` = NULL, `PrintDataDokumentTitle` = NULL, `PrintDataDokumentDesc` = NULL WHERE `ooo_id` = 433730 AND `language` = 'de';

SELECT
  *
FROM
  object_localized_query_1_de
WHERE
  ooo_id = 433730
  AND language = 'de'

SELECT * FROM object_localized_query_1_de WHERE ooo_id = 433730 AND language = 'de';

SELECT
  *
FROM
  object_localized_query_1_de
WHERE
  ooo_id = ?
  AND language = ? FOR
UPDATE

SELECT * FROM object_localized_query_1_de WHERE ooo_id = 432550 AND language = 'de' FOR UPDATE;