Symfony Profiler

"COMMIT"

"COMMIT";

DELETE FROM
  cache_items
WHERE
  item_id IN (?, ?)

DELETE FROM cache_items WHERE item_id IN ('object_163885
tags
', 'object_properties
tags
');

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A221EB39406C01E223B693A313735383631353137353B7D, 30, 1758615175) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

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

SELECT
  object_localized_1_en.id as id,
  object_localized_1_en.type as `type`
FROM
  object_localized_1_en
WHERE
  (id = 163885)
  AND object_localized_1_en.type IN ('object', 'folder', 'variant')
LIMIT
  1

SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en WHERE (id =163885) AND  object_localized_1_en.type IN ('object','folder','variant') LIMIT 1;

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` = 163885, `language` = 'en', `MarketingTextLocalized` = '', `SapShortTextLocalized` = 'ANTIQUE WHITE SC CLASSIC', `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` = NULL, `Video_1` = NULL, `Video_2_Title` = NULL, `Video_2_Type` = NULL, `Video_2` = NULL, `PrintDataDokumentTitle` = NULL, `PrintDataDokumentDesc` = NULL WHERE `ooo_id` = 163885 AND `language` = '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 > 1758615175 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

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 (163885, 'en', '', 'ANTIQUE WHITE SC CLASSIC', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SHOW COLUMNS
FROM
  object_localized_query_1_en

SHOW COLUMNS FROM object_localized_query_1_en;

SHOW COLUMNS
FROM
  object_localized_query_1_tr

SHOW COLUMNS FROM object_localized_query_1_tr;

SHOW COLUMNS
FROM
  object_query_1

SHOW COLUMNS FROM object_query_1;

SHOW COLUMNS
FROM
  object_localized_query_1_nl

SHOW COLUMNS FROM object_localized_query_1_nl;

SHOW COLUMNS
FROM
  object_localized_query_1_pl

SHOW COLUMNS FROM object_localized_query_1_pl;

SHOW COLUMNS
FROM
  object_localized_query_1_cs

SHOW COLUMNS FROM object_localized_query_1_cs;

SHOW COLUMNS
FROM
  object_store_1

SHOW COLUMNS FROM object_store_1;

SHOW COLUMNS
FROM
  object_localized_data_1

SHOW COLUMNS FROM object_localized_data_1;

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

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

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

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

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

SELECT
  *
FROM
  object_localized_query_1_fr
WHERE
  ooo_id = 163885
  AND language = 'fr'

SELECT * FROM object_localized_query_1_fr WHERE ooo_id = 163885 AND language = 'fr';

SHOW COLUMNS
FROM
  object_localized_query_1_fr

SHOW COLUMNS FROM object_localized_query_1_fr;

SELECT
  `read`
FROM
  plugin_datahub_workspaces_object
WHERE
  cid IN (
    1, 147545, 138409, 138245, 62890, 15,
    2, 1, 163885
  )
  AND configuration = 'Material'
  AND `read` = 1
ORDER BY
  LENGTH(cpath) DESC
LIMIT
  1

SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,147545,138409,138245,62890,15,2,1,163885) AND configuration = 'Material' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1;

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:26:\\\"messenger.bus.pimcore-core\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:69:\\\"Pimcore\\\\Bundle\\\\SimpleBackendSearchBundle\\\\Message\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0*\\0type\\\";s:6:\\\"object\\\";s:5:\\\"\\0*\\0id\\\";i:163885;}}', '[]', 'pimcore_search_backend_message', '2025-09-23 08:12:55', '2025-09-23 08:12:55');

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

SHOW COLUMNS
FROM
  object_localized_query_1_es

SHOW COLUMNS FROM object_localized_query_1_es;

SHOW COLUMNS
FROM
  object_localized_query_1_de

SHOW COLUMNS FROM object_localized_query_1_de;

SHOW COLUMNS
FROM
  object_localized_query_1_it

SHOW COLUMNS FROM object_localized_query_1_it;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 163885;

WITH
  RECURSIVE cte(id, classId, parentId, path) as (
    SELECT
      c.id AS id,
      c.classId AS classId,
      c.parentid AS parentId,
      c.path as `path`
    FROM
      objects c
    WHERE
      c.parentid = 163885
    UNION ALL
    SELECT
      p.id AS id,
      p.classId AS classId,
      p.parentid AS parentId,
      p.path as `path`
    FROM
      objects p
      INNER JOIN cte on (p.parentid = cte.id)
  )
SELECT
  x.id AS id,
  x.classId AS classId,
  x.parentId AS parentId,
  `DigitCount`
FROM
  cte x
  LEFT JOIN object_store_1 a ON x.id = a.oo_id
GROUP BY
  x.id
ORDER BY
  x.path ASC

WITH RECURSIVE cte(id, classId, parentId, path) as (
                        SELECT c.id AS id, c.classId AS classId, c.parentid AS parentId, c.path as `path`
                        FROM objects c
                        WHERE c.parentid = 163885
                        UNION ALL
                        SELECT p.id AS id, p.classId AS classId, p.parentid AS parentId, p.path as `path`
                        FROM objects p
                        INNER JOIN cte on (p.parentid = cte.id)
                    )	SELECT x.id AS id,
                               x.classId AS classId,
                               x.parentId AS parentId
                               , `DigitCount`
                        FROM cte x
                        LEFT JOIN object_store_1 a ON x.id = a.oo_id
                        GROUP BY x.id
                        ORDER BY x.path ASC;

INSERT INTO versions (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 163885, 'object', 0, '', 1758615175, 0, 1, '#0 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\\Model\\DataObject\\Concrete->update()
#4 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\\Model\\DataObject\\AbstractObject->save()
#5 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/data-hub/src/GraphQL/Mutation/MutationType.php(1580): Pimcore\\Model\\DataObject\\Concrete->save()
#6 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/data-hub/src/GraphQL/Mutation/MutationType.php(899): Pimcore\\Bundle\\DataHubBundle\\GraphQL\\Mutation\\MutationType->saveElement()
#7 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(753): Pimcore\\Bundle\\DataHubBundle\\GraphQL\\Mutation\\MutationType::Pimcore\\Bundle\\DataHubBundle\\GraphQL\\Mutation\\{closure}()
#8 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(662): GraphQL\\Executor\\ReferenceExecutor->resolveFieldValueOrError()
#9 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(556): GraphQL\\Executor\\ReferenceExecutor->resolveField()
#10 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(993): GraphQL\\Executor\\ReferenceExecutor->GraphQL\\Executor\\{closure}()
#11 [internal function]: GraphQL\\Executor\\ReferenceExecutor->GraphQL\\Executor\\{closure}()
#12 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(986): array_reduce()
#13 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(575): GraphQL\\Executor\\ReferenceExecutor->promiseReduce()
#14 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(318): GraphQL\\Executor\\ReferenceExecutor->executeFieldsSerially()
#15 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php(258): GraphQL\\Executor\\ReferenceExecutor->executeOperation()
#16 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/Executor/Executor.php(184): GraphQL\\Executor\\ReferenceExecutor->doExecute()
#17 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/GraphQL.php(164): GraphQL\\Executor\\Executor::promiseToExecute()
#18 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/webonyx/graphql-php/src/GraphQL.php(98): GraphQL\\GraphQL::promiseToExecute()
#19 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/pimcore/data-hub/src/Controller/WebserviceController.php(204): GraphQL\\GraphQL::executeQuery()
#20 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\\Bundle\\DataHubBundle\\Controller\\WebserviceController->webonyxAction()
#21 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#22 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#23 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#24 /var/www/renolit-pimcore-10.426-upgrade.com/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#25 /var/www/renolit-pimcore-10.426-upgrade.com/public/index.php(19): require_once(\'...\')
#26 {main}', 35, NULL, NULL, 0, 'fs');

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/40/4040/404010/4040100016/', `id` = 163885, `creationDate` = 1550097449, `modificationDate` = 1758615175, `versionCount` = 35, `userOwner` = 0, `userModification` = 0, `parentId` = 147545, `type` = 'object', `key` = 'S4040100016000', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = '1', `published` = 1, `className` = 'SapMaterial' WHERE `id` = 163885;

UPDATE
  object_query_1
SET
  `MarketingText` = ?,
  `MaterialNumber` = ?,
  `MaterialNumberFormatted` = ?,
  `MaterialGroupNumber` = ?,
  `EAN` = ?,
  `StatisticalNumber` = ?,
  `SalesforceProductID` = ?,
  `RecordTypeID` = ?,
  `OriginArticle` = ?,
  `EvaluationType` = ?,
  `Embossing` = ?,
  `Design` = ?,
  `ColorCode` = ?,
  `ColorRecipe` = ?,
  `ColorCodeRal` = ?,
  `StatusGlobal` = ?,
  `EdgeTrim` = ?,
  `CreatedByCutting` = ?,
  `BasicRecipe` = ?,
  `Approach` = ?,
  `LeadingSemifinished` = ?,
  `HotColdEmbossing` = ?,
  `Waste` = ?,
  `Regenerate` = ?,
  `BaseUnit` = ?,
  `SalesUnit` = ?,
  `PackingUnit` = ?,
  `PackingUnitQuantity` = ?,
  `PackQuantity` = ?,
  `WidthValue` = ?,
  `WidthUnit` = ?,
  `HeightValue` = ?,
  `HeightUnit` = ?,
  `LengthValue` = ?,
  `LengthUnit` = ?,
  `WeightValue` = ?,
  `WeightUnit` = ?,
  `ThicknessValue` = ?,
  `ThicknessUnit` = ?,
  `PmmaThickness` = ?,
  `SpecificWeightValue` = ?,
  `SpecificWeightUnit` = ?,
  `CalculatedHardness` = ?,
  `Bukrs_md1` = ?,
  `Vkorg_md1` = ?,
  `Vtweg_md1` = ?,
  `Sparte_md1` = ?,
  `Vkbur_md1` = ?,
  `Vkgrp_md1` = ?,
  `Status_md1` = ?,
  `IsNew_md1` = ?,
  `IsSale_md1` = ?,
  `IsShopMandatoryRelevant_md1` = ?,
  `AdditionalText1_md1` = ?,
  `AdditionalText2_md1` = ?,
  `Factory_md1` = ?,
  `OriginCountry_md1` = ?,
  `OriginRegion_md1` = ?,
  `DeliveryUnit_md1` = ?,
  `MinAmount_md1` = ?,
  `MaxAmount_md1` = ?,
  `SalesUnit_md1` = ?,
  `BusinessUnitNumber` = ?,
  `BusinessAreaNumber` = ?,
  `ApplicationAreaNumber` = ?,
  `AccessoryMainNumber` = ?,
  `AccessorySubNumber` = ?,
  `InitialSMU` = ?,
  `UsedBySMUS` = ?,
  `IsArticleGroup` = ?,
  `IsArticle` = ?,
  `IsShopRelevant` = ?,
  `MaterialType` = ?,
  `key_LVL` = ?,
  `txt_LVL` = ?,
  `DigitCount` = ?,
  `DateLaunch` = ?,
  `DateCreate` = ?,
  `PriceCategory` = ?,
  `StockMto` = ?,
  `StockMTOSince` = ?,
  `StockMTOUntil` = ?,
  `InStock` = ?,
  `Status` = ?,
  `SalesStatusSince` = ?,
  `RawMaterials` = ?,
  `InformationShine` = ?,
  `InformationRoughness` = ?,
  `PrintRollSetName` = ?,
  `PrintRollSetCount` = ?,
  `PrintRollSetDate` = ?,
  `EngraverPrintRoll` = ?,
  `EngraverEmbossRoll` = ?,
  `EngraverDepthRoll` = ?,
  `RollSetShine` = ?,
  `RollSetProcedure` = ?,
  `RollSetDesignation` = ?,
  `IPMZone` = ?,
  `IPMStart` = ?,
  `Pic_1` = ?,
  `Pic_2` = ?,
  `Pic_3` = ?,
  `Pic_4` = ?,
  `Pic_5` = ?,
  `Pic_6` = ?,
  `Pic_7` = ?,
  `Pic_8` = ?,
  `Pic_9` = ?,
  `Quality` = ?,
  `ApplicationExterior` = ?,
  `GuaranteeCountryGroup1` = ?,
  `GuaranteeCountryGroup2` = ?,
  `GuaranteeCountryGroup3` = ?,
  `GuaranteeCountryGroup4` = ?,
  `GuaranteeCountryGroup5` = ?,
  `GuaranteeCountryGroup6` = ?,
  `GuaranteeInfo` = ?,
  `WeatheringClass` = ?,
  `FireProtectionClass` = ?,
  `HeatAbsorptionWhite` = ?,
  `HeatAbsorptionBlack` = ?,
  `TSRWhite` = ?,
  `TSRBlack` = ?,
  `EN410White` = ?,
  `EN410Black` = ?,
  `ColorimetricValuesL` = ?,
  `ColorimetricValuesA` = ?,
  `ColorimetricValuesB` = ?,
  `RalGfkp` = ?,
  `MatchingRALcolour` = ?,
  `ColorGroup` = ?,
  `DetailsRALcolour` = ?,
  `MatchingNCScolour` = ?,
  `QB33Certificate` = ?,
  `MatchingPencil__id` = ?,
  `MatchingPencil__type` = ?,
  `ProductDescription` = ?,
  `SkzScratchResistance` = ?,
  `SkzEmbossingStability` = ?,
  `SkzShrink` = ?,
  `SkzRubbingFastness` = ?,
  `SkzTensileStressBreak` = ?,
  `SkzElongationBreak` = ?,
  `SkzDimensionalChange` = ?,
  `SkzWeatherResistance` = ?,
  `SkzAbrasionResistance` = ?,
  `SkzWearResistance` = ?,
  `SkzMicroScratchResistance` = ?,
  `SkzSlipResistance` = ?,
  `SkzCertificateNo` = ?,
  `CollectionsExterior` = ?,
  `DesignGenre` = ?,
  `ApplicationInterior` = ?,
  `Exclusiveness` = ?,
  `MarketingMaterial` = ?,
  `Dekorverbundpartner` = ?,
  `InternalDecorAssemblage__id` = ?,
  `InternalDecorAssemblage__type` = ?,
  `InternalDecorAssemblage2__id` = ?,
  `InternalDecorAssemblage2__type` = ?,
  `CollectionsDesign` = ?,
  `InteriorProductDescription` = ?,
  `InternalInformation` = ?,
  `CopyrightOwner` = ?,
  `MeasurementLaborBoard` = ?,
  `MixedDesign` = ?,
  `ImoCertificate` = ?,
  `HorizontalPrint` = ?,
  `DigitalDataAvailability` = ?,
  `BuDesignFormulation` = ?,
  `SampleSaleable` = ?,
  `SampleDocument__id` = ?,
  `SampleDocument__type` = ?,
  `PrintDataSheet` = ?,
  `oo_id` = ?
WHERE
  `oo_id` = ?

UPDATE object_query_1 SET `MarketingText` = 'RENOLIT 3D THERMOLAMINATES CLASSIC', `MaterialNumber` = 'S4040100016000', `MaterialNumberFormatted` = 'S40.40.10.0016.000', `MaterialGroupNumber` = NULL, `EAN` = NULL, `StatisticalNumber` = '39204310', `SalesforceProductID` = NULL, `RecordTypeID` = NULL, `OriginArticle` = NULL, `EvaluationType` = 'IN HOUSE', `Embossing` = '505000', `Design` = NULL, `ColorCode` = NULL, `ColorRecipe` = '02.08.11.000394', `ColorCodeRal` = '0000', `StatusGlobal` = NULL, `EdgeTrim` = NULL, `CreatedByCutting` = NULL, `BasicRecipe` = '011102000001000000', `Approach` = 'A0140110015', `LeadingSemifinished` = 'S0140110015000', `HotColdEmbossing` = NULL, `Waste` = NULL, `Regenerate` = NULL, `BaseUnit` = 'M', `SalesUnit` = 'ST', `PackingUnit` = NULL, `PackingUnitQuantity` = 0, `PackQuantity` = 0, `WidthValue` = 1420, `WidthUnit` = 'mm', `HeightValue` = NULL, `HeightUnit` = NULL, `LengthValue` = NULL, `LengthUnit` = NULL, `WeightValue` = 779.9, `WeightUnit` = 'kg', `ThicknessValue` = 400, `ThicknessUnit` = 'µm', `PmmaThickness` = NULL, `SpecificWeightValue` = 1.373, `SpecificWeightUnit` = 'g/cm³', `CalculatedHardness` = 0, `Bukrs_md1` = NULL, `Vkorg_md1` = NULL, `Vtweg_md1` = NULL, `Sparte_md1` = '00', `Vkbur_md1` = 'VL3', `Vkgrp_md1` = 'VK4', `Status_md1` = NULL, `IsNew_md1` = 0, `IsSale_md1` = 0, `IsShopMandatoryRelevant_md1` = 0, `AdditionalText1_md1` = NULL, `AdditionalText2_md1` = NULL, `Factory_md1` = '1001', `OriginCountry_md1` = 'DE', `OriginRegion_md1` = '07', `DeliveryUnit_md1` = NULL, `MinAmount_md1` = NULL, `MaxAmount_md1` = NULL, `SalesUnit_md1` = NULL, `BusinessUnitNumber` = '40', `BusinessAreaNumber` = '4040', `ApplicationAreaNumber` = '404010', `AccessoryMainNumber` = '', `AccessorySubNumber` = '', `InitialSMU` = NULL, `UsedBySMUS` = NULL, `IsArticleGroup` = 0, `IsArticle` = 1, `IsShopRelevant` = 1, `MaterialType` = NULL, `key_LVL` = '404010', `txt_LVL` = NULL, `DigitCount` = '13', `DateLaunch` = NULL, `DateCreate` = NULL, `PriceCategory` = NULL, `StockMto` = NULL, `StockMTOSince` = NULL, `StockMTOUntil` = NULL, `InStock` = 0, `Status` = NULL, `SalesStatusSince` = NULL, `RawMaterials` = NULL, `InformationShine` = NULL, `InformationRoughness` = NULL, `PrintRollSetName` = NULL, `PrintRollSetCount` = NULL, `PrintRollSetDate` = NULL, `EngraverPrintRoll` = NULL, `EngraverEmbossRoll` = NULL, `EngraverDepthRoll` = NULL, `RollSetShine` = NULL, `RollSetProcedure` = NULL, `RollSetDesignation` = NULL, `IPMZone` = NULL, `IPMStart` = NULL, `Pic_1` = NULL, `Pic_2` = NULL, `Pic_3` = NULL, `Pic_4` = NULL, `Pic_5` = NULL, `Pic_6` = NULL, `Pic_7` = NULL, `Pic_8` = NULL, `Pic_9` = NULL, `Quality` = '404010', `ApplicationExterior` = NULL, `GuaranteeCountryGroup1` = NULL, `GuaranteeCountryGroup2` = NULL, `GuaranteeCountryGroup3` = NULL, `GuaranteeCountryGroup4` = NULL, `GuaranteeCountryGroup5` = NULL, `GuaranteeCountryGroup6` = NULL, `GuaranteeInfo` = NULL, `WeatheringClass` = NULL, `FireProtectionClass` = 0, `HeatAbsorptionWhite` = NULL, `HeatAbsorptionBlack` = NULL, `TSRWhite` = NULL, `TSRBlack` = NULL, `EN410White` = NULL, `EN410Black` = NULL, `ColorimetricValuesL` = NULL, `ColorimetricValuesA` = NULL, `ColorimetricValuesB` = NULL, `RalGfkp` = 0, `MatchingRALcolour` = NULL, `ColorGroup` = NULL, `DetailsRALcolour` = NULL, `MatchingNCScolour` = NULL, `QB33Certificate` = NULL, `MatchingPencil__id` = NULL, `MatchingPencil__type` = NULL, `ProductDescription` = NULL, `SkzScratchResistance` = NULL, `SkzEmbossingStability` = NULL, `SkzShrink` = NULL, `SkzRubbingFastness` = NULL, `SkzTensileStressBreak` = NULL, `SkzElongationBreak` = NULL, `SkzDimensionalChange` = NULL, `SkzWeatherResistance` = NULL, `SkzAbrasionResistance` = NULL, `SkzWearResistance` = NULL, `SkzMicroScratchResistance` = NULL, `SkzSlipResistance` = NULL, `SkzCertificateNo` = NULL, `CollectionsExterior` = NULL, `DesignGenre` = NULL, `ApplicationInterior` = NULL, `Exclusiveness` = NULL, `MarketingMaterial` = NULL, `Dekorverbundpartner` = NULL, `InternalDecorAssemblage__id` = NULL, `InternalDecorAssemblage__type` = NULL, `InternalDecorAssemblage2__id` = NULL, `InternalDecorAssemblage2__type` = NULL, `CollectionsDesign` = NULL, `InteriorProductDescription` = NULL, `InternalInformation` = NULL, `CopyrightOwner` = NULL, `MeasurementLaborBoard` = NULL, `MixedDesign` = NULL, `ImoCertificate` = 0, `HorizontalPrint` = 0, `DigitalDataAvailability` = 0, `BuDesignFormulation` = NULL, `SampleSaleable` = 0, `SampleDocument__id` = NULL, `SampleDocument__type` = NULL, `PrintDataSheet` = NULL, `oo_id` = 163885 WHERE `oo_id` = 163885;

UPDATE
  object_store_1
SET
  `oo_id` = ?,
  `MarketingText` = ?,
  `MaterialNumber` = ?,
  `MaterialNumberFormatted` = ?,
  `MaterialGroupNumber` = ?,
  `EAN` = ?,
  `StatisticalNumber` = ?,
  `SalesforceProductID` = ?,
  `RecordTypeID` = ?,
  `OriginArticle` = ?,
  `EvaluationType` = ?,
  `Embossing` = ?,
  `Design` = ?,
  `ColorCode` = ?,
  `ColorRecipe` = ?,
  `ColorCodeRal` = ?,
  `StatusGlobal` = ?,
  `EdgeTrim` = ?,
  `CreatedByCutting` = ?,
  `BasicRecipe` = ?,
  `Approach` = ?,
  `LeadingSemifinished` = ?,
  `HotColdEmbossing` = ?,
  `Waste` = ?,
  `Regenerate` = ?,
  `BaseUnit` = ?,
  `SalesUnit` = ?,
  `PackingUnit` = ?,
  `PackingUnitQuantity` = ?,
  `PackQuantity` = ?,
  `WidthValue` = ?,
  `WidthUnit` = ?,
  `HeightValue` = ?,
  `HeightUnit` = ?,
  `LengthValue` = ?,
  `LengthUnit` = ?,
  `WeightValue` = ?,
  `WeightUnit` = ?,
  `ThicknessValue` = ?,
  `ThicknessUnit` = ?,
  `PmmaThickness` = ?,
  `SpecificWeightValue` = ?,
  `SpecificWeightUnit` = ?,
  `CalculatedHardness` = ?,
  `Bukrs_md1` = ?,
  `Vkorg_md1` = ?,
  `Vtweg_md1` = ?,
  `Sparte_md1` = ?,
  `Vkbur_md1` = ?,
  `Vkgrp_md1` = ?,
  `Status_md1` = ?,
  `IsNew_md1` = ?,
  `IsSale_md1` = ?,
  `IsShopMandatoryRelevant_md1` = ?,
  `AdditionalText1_md1` = ?,
  `AdditionalText2_md1` = ?,
  `Factory_md1` = ?,
  `OriginCountry_md1` = ?,
  `OriginRegion_md1` = ?,
  `DeliveryUnit_md1` = ?,
  `MinAmount_md1` = ?,
  `MaxAmount_md1` = ?,
  `SalesUnit_md1` = ?,
  `BusinessUnitNumber` = ?,
  `BusinessAreaNumber` = ?,
  `ApplicationAreaNumber` = ?,
  `AccessoryMainNumber` = ?,
  `AccessorySubNumber` = ?,
  `InitialSMU` = ?,
  `UsedBySMUS` = ?,
  `IsArticleGroup` = ?,
  `IsArticle` = ?,
  `IsShopRelevant` = ?,
  `MaterialType` = ?,
  `key_LVL` = ?,
  `txt_LVL` = ?,
  `DigitCount` = ?,
  `DateLaunch` = ?,
  `DateCreate` = ?,
  `PriceCategory` = ?,
  `StockMto` = ?,
  `StockMTOSince` = ?,
  `StockMTOUntil` = ?,
  `InStock` = ?,
  `Status` = ?,
  `SalesStatusSince` = ?,
  `RawMaterials` = ?,
  `InformationShine` = ?,
  `InformationRoughness` = ?,
  `PrintRollSetName` = ?,
  `PrintRollSetCount` = ?,
  `PrintRollSetDate` = ?,
  `EngraverPrintRoll` = ?,
  `EngraverEmbossRoll` = ?,
  `EngraverDepthRoll` = ?,
  `RollSetShine` = ?,
  `RollSetProcedure` = ?,
  `RollSetDesignation` = ?,
  `IPMZone` = ?,
  `IPMStart` = ?,
  `Pic_1` = ?,
  `Pic_2` = ?,
  `Pic_3` = ?,
  `Pic_4` = ?,
  `Pic_5` = ?,
  `Pic_6` = ?,
  `Pic_7` = ?,
  `Pic_8` = ?,
  `Pic_9` = ?,
  `Quality` = ?,
  `ApplicationExterior` = ?,
  `GuaranteeCountryGroup1` = ?,
  `GuaranteeCountryGroup2` = ?,
  `GuaranteeCountryGroup3` = ?,
  `GuaranteeCountryGroup4` = ?,
  `GuaranteeCountryGroup5` = ?,
  `GuaranteeCountryGroup6` = ?,
  `GuaranteeInfo` = ?,
  `WeatheringClass` = ?,
  `FireProtectionClass` = ?,
  `HeatAbsorptionWhite` = ?,
  `HeatAbsorptionBlack` = ?,
  `TSRWhite` = ?,
  `TSRBlack` = ?,
  `EN410White` = ?,
  `EN410Black` = ?,
  `ColorimetricValuesL` = ?,
  `ColorimetricValuesA` = ?,
  `ColorimetricValuesB` = ?,
  `RalGfkp` = ?,
  `MatchingRALcolour` = ?,
  `ColorGroup` = ?,
  `DetailsRALcolour` = ?,
  `MatchingNCScolour` = ?,
  `QB33Certificate` = ?,
  `ProductDescription` = ?,
  `SkzScratchResistance` = ?,
  `SkzEmbossingStability` = ?,
  `SkzShrink` = ?,
  `SkzRubbingFastness` = ?,
  `SkzTensileStressBreak` = ?,
  `SkzElongationBreak` = ?,
  `SkzDimensionalChange` = ?,
  `SkzWeatherResistance` = ?,
  `SkzAbrasionResistance` = ?,
  `SkzWearResistance` = ?,
  `SkzMicroScratchResistance` = ?,
  `SkzSlipResistance` = ?,
  `SkzCertificateNo` = ?,
  `CollectionsExterior` = ?,
  `DesignGenre` = ?,
  `ApplicationInterior` = ?,
  `Exclusiveness` = ?,
  `MarketingMaterial` = ?,
  `Dekorverbundpartner` = ?,
  `CollectionsDesign` = ?,
  `InteriorProductDescription` = ?,
  `InternalInformation` = ?,
  `CopyrightOwner` = ?,
  `MeasurementLaborBoard` = ?,
  `MixedDesign` = ?,
  `ImoCertificate` = ?,
  `HorizontalPrint` = ?,
  `DigitalDataAvailability` = ?,
  `BuDesignFormulation` = ?,
  `SampleSaleable` = ?,
  `PrintDataSheet` = ?
WHERE
  `oo_id` = ?

UPDATE object_store_1 SET `oo_id` = 163885, `MarketingText` = 'RENOLIT 3D THERMOLAMINATES CLASSIC', `MaterialNumber` = 'S4040100016000', `MaterialNumberFormatted` = 'S40.40.10.0016.000', `MaterialGroupNumber` = NULL, `EAN` = NULL, `StatisticalNumber` = '', `SalesforceProductID` = NULL, `RecordTypeID` = NULL, `OriginArticle` = '', `EvaluationType` = '', `Embossing` = '', `Design` = '', `ColorCode` = '', `ColorRecipe` = '', `ColorCodeRal` = '', `StatusGlobal` = NULL, `EdgeTrim` = '', `CreatedByCutting` = '', `BasicRecipe` = '', `Approach` = '', `LeadingSemifinished` = '', `HotColdEmbossing` = '', `Waste` = '', `Regenerate` = '', `BaseUnit` = '', `SalesUnit` = '', `PackingUnit` = '', `PackingUnitQuantity` = NULL, `PackQuantity` = NULL, `WidthValue` = 1420, `WidthUnit` = 'mm', `HeightValue` = NULL, `HeightUnit` = NULL, `LengthValue` = NULL, `LengthUnit` = NULL, `WeightValue` = 779.9, `WeightUnit` = 'kg', `ThicknessValue` = NULL, `ThicknessUnit` = '', `PmmaThickness` = NULL, `SpecificWeightValue` = NULL, `SpecificWeightUnit` = '', `CalculatedHardness` = NULL, `Bukrs_md1` = NULL, `Vkorg_md1` = '', `Vtweg_md1` = '', `Sparte_md1` = '', `Vkbur_md1` = '', `Vkgrp_md1` = '', `Status_md1` = '', `IsNew_md1` = 0, `IsSale_md1` = 0, `IsShopMandatoryRelevant_md1` = 0, `AdditionalText1_md1` = '', `AdditionalText2_md1` = '', `Factory_md1` = '', `OriginCountry_md1` = '', `OriginRegion_md1` = '', `DeliveryUnit_md1` = NULL, `MinAmount_md1` = NULL, `MaxAmount_md1` = NULL, `SalesUnit_md1` = NULL, `BusinessUnitNumber` = '', `BusinessAreaNumber` = '', `ApplicationAreaNumber` = '', `AccessoryMainNumber` = '', `AccessorySubNumber` = '', `InitialSMU` = NULL, `UsedBySMUS` = NULL, `IsArticleGroup` = 0, `IsArticle` = 1, `IsShopRelevant` = 1, `MaterialType` = NULL, `key_LVL` = NULL, `txt_LVL` = NULL, `DigitCount` = '13', `DateLaunch` = NULL, `DateCreate` = NULL, `PriceCategory` = NULL, `StockMto` = NULL, `StockMTOSince` = NULL, `StockMTOUntil` = NULL, `InStock` = 0, `Status` = NULL, `SalesStatusSince` = NULL, `RawMaterials` = NULL, `InformationShine` = NULL, `InformationRoughness` = NULL, `PrintRollSetName` = NULL, `PrintRollSetCount` = NULL, `PrintRollSetDate` = NULL, `EngraverPrintRoll` = NULL, `EngraverEmbossRoll` = NULL, `EngraverDepthRoll` = NULL, `RollSetShine` = NULL, `RollSetProcedure` = NULL, `RollSetDesignation` = NULL, `IPMZone` = NULL, `IPMStart` = NULL, `Pic_1` = NULL, `Pic_2` = NULL, `Pic_3` = NULL, `Pic_4` = NULL, `Pic_5` = NULL, `Pic_6` = NULL, `Pic_7` = NULL, `Pic_8` = NULL, `Pic_9` = NULL, `Quality` = '404010', `ApplicationExterior` = NULL, `GuaranteeCountryGroup1` = NULL, `GuaranteeCountryGroup2` = NULL, `GuaranteeCountryGroup3` = NULL, `GuaranteeCountryGroup4` = NULL, `GuaranteeCountryGroup5` = NULL, `GuaranteeCountryGroup6` = NULL, `GuaranteeInfo` = NULL, `WeatheringClass` = NULL, `FireProtectionClass` = 0, `HeatAbsorptionWhite` = NULL, `HeatAbsorptionBlack` = NULL, `TSRWhite` = NULL, `TSRBlack` = NULL, `EN410White` = NULL, `EN410Black` = NULL, `ColorimetricValuesL` = NULL, `ColorimetricValuesA` = NULL, `ColorimetricValuesB` = NULL, `RalGfkp` = 0, `MatchingRALcolour` = NULL, `ColorGroup` = NULL, `DetailsRALcolour` = NULL, `MatchingNCScolour` = NULL, `QB33Certificate` = NULL, `ProductDescription` = NULL, `SkzScratchResistance` = NULL, `SkzEmbossingStability` = NULL, `SkzShrink` = NULL, `SkzRubbingFastness` = NULL, `SkzTensileStressBreak` = NULL, `SkzElongationBreak` = NULL, `SkzDimensionalChange` = NULL, `SkzWeatherResistance` = NULL, `SkzAbrasionResistance` = NULL, `SkzWearResistance` = NULL, `SkzMicroScratchResistance` = NULL, `SkzSlipResistance` = NULL, `SkzCertificateNo` = NULL, `CollectionsExterior` = NULL, `DesignGenre` = NULL, `ApplicationInterior` = NULL, `Exclusiveness` = NULL, `MarketingMaterial` = NULL, `Dekorverbundpartner` = NULL, `CollectionsDesign` = NULL, `InteriorProductDescription` = NULL, `InternalInformation` = NULL, `CopyrightOwner` = NULL, `MeasurementLaborBoard` = NULL, `MixedDesign` = NULL, `ImoCertificate` = 0, `HorizontalPrint` = 0, `DigitalDataAvailability` = 0, `BuDesignFormulation` = NULL, `SampleSaleable` = 0, `PrintDataSheet` = NULL WHERE `oo_id` = 163885;