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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_280718');

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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_280718
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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_267364');

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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_267364
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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262079');

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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262079
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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262026');

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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262026
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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262023');

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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_262023
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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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 > 1758573212 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, 267364, 262079, 262026, 262023, 15,
    2, 1, 280718
  )
  AND configuration = 'Material'
  AND `update` = 1
ORDER BY
  LENGTH(cpath) DESC
LIMIT
  1

SELECT `update` FROM plugin_datahub_workspaces_object WHERE cid IN (1,267364,262079,262026,262023,15,2,1,280718) 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 = 267364;

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

SELECT id FROM objects WHERE `path` = BINARY '/SAP-ROOT/MATERIALMASTER/20/2021/202190/2021900004/' AND `key` = BINARY 'S2021900004000';

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

SELECT id FROM objects WHERE `path` = BINARY '/SAP-ROOT/MATERIALMASTER/20/2021/202190/2021900004/' AND `key` = BINARY 'S2021900004000';

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 280718;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 267364;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 262079;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 262026;

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

SELECT * FROM object_collection_DekorverbundBoardManufacturer_1 WHERE id = 280718 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 = 280718 AND fieldname = 'PaperPrinter' ORDER BY `index` ASC;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 280718 FOR UPDATE;

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

SELECT MAX(versionCount) FROM versions WHERE cid = 280718 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 > 1758573212 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 > 1758573212 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'resource
tags
');

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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

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

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/20/2021/202190/2021900004/', 280718, 1637018020, 1758573212, 24, 0, 0, 267364, 'object', 'S2021900004000', 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/20/2021/202190/2021900004/', `id` = 280718, `creationDate` = 1637018020, `modificationDate` = 1758573212, `versionCount` = 24, `userOwner` = 0, `userModification` = 0, `parentId` = 267364, `type` = 'object', `key` = 'S2021900004000', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = '1', `published` = 1, `className` = 'SapMaterial' WHERE `id` = 280718;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 280718 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 > 1758573212 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 > 1758573212 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 (280718, 'en', '', 'SK-HG GLOSS PURPLE', '', '', '', '', '', 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` = 280718, `language` = 'en', `MarketingTextLocalized` = '', `SapShortTextLocalized` = 'SK-HG GLOSS PURPLE', `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` = 280718 AND `language` = 'en';

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

SELECT * FROM object_localized_query_1_en WHERE ooo_id = 280718 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 = 267364 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 > 1758573212 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 > 1758573212 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 (280718, 'en', 'VISUAL COMMUNICATION', 'SK-HG GLOSS PURPLE', 'VISUAL COMMUNICATION', 'SIGN', 'American Blend colours', '', '', 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` = 280718, `language` = 'en', `MarketingTextLocalized` = 'VISUAL COMMUNICATION', `SapShortTextLocalized` = 'SK-HG GLOSS PURPLE', `BusinessUnitTitle` = 'VISUAL COMMUNICATION', `BusinessAreaTitle` = 'SIGN', `ApplicationAreaTitle` = 'American Blend colours', `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` = 280718 AND `language` = 'en';

WITH
  RECURSIVE cte(id, classId) as (
    SELECT
      c.id AS id,
      c.classId AS classId
    FROM
      objects c
    WHERE
      c.parentid = 280718
    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 = 280718
                        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 = 280718;

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 (280718, 'de', '', 'SK-HG GLOSS PURPLE', '', '', '', '', '', 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` = ?