Symfony Profiler

"COMMIT"

"COMMIT";

DELETE FROM
  cache_items
WHERE
  item_id IN (?, ?)

DELETE FROM cache_items WHERE item_id IN ('object_433730
tags
', 'object_properties
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 ('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 = 433730)
  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 =433730) AND  object_localized_1_en.type IN ('object','folder','variant') LIMIT 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);

SHOW COLUMNS
FROM
  object_store_1

SHOW COLUMNS FROM object_store_1;

SHOW COLUMNS
FROM
  object_query_1

SHOW COLUMNS FROM object_query_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 ('system
tags
', 'site
tags
');

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

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

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

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

SHOW COLUMNS
FROM
  object_localized_query_1_sk

SHOW COLUMNS FROM object_localized_query_1_sk;

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SHOW COLUMNS
FROM
  object_localized_query_1_hu

SHOW COLUMNS FROM object_localized_query_1_hu;

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_de

SHOW COLUMNS FROM object_localized_query_1_de;

SHOW COLUMNS
FROM
  object_localized_query_1_tr

SHOW COLUMNS FROM object_localized_query_1_tr;

SHOW COLUMNS
FROM
  object_localized_query_1_en

SHOW COLUMNS FROM object_localized_query_1_en;

SHOW COLUMNS
FROM
  object_localized_query_1_fr

SHOW COLUMNS FROM object_localized_query_1_fr;

SHOW COLUMNS
FROM
  object_localized_query_1_nl

SHOW COLUMNS FROM object_localized_query_1_nl;

SHOW COLUMNS
FROM
  object_localized_query_1_es

SHOW COLUMNS FROM object_localized_query_1_es;

SHOW COLUMNS
FROM
  object_localized_query_1_it

SHOW COLUMNS FROM object_localized_query_1_it;

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_localized_data_1

SHOW COLUMNS FROM object_localized_data_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:433730;}}', '[]', 'pimcore_search_backend_message', '2025-12-06 08:11:51', '2025-12-06 08:11:51');

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

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

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

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

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` = ?,
  `LengthValue` = ?,
  `LengthUnit` = ?,
  `WidthValue` = ?,
  `WidthUnit` = ?,
  `HeightValue` = ?,
  `HeightUnit` = ?,
  `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` = ?,
  `MinimumOrderQuantitySAP` = ?,
  `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` = 433730, `MarketingText` = NULL, `MaterialNumber` = 'S1040100550', `MaterialNumberFormatted` = 'S10.40.10.0550.', `MaterialGroupNumber` = NULL, `EAN` = NULL, `StatisticalNumber` = '39204310', `SalesforceProductID` = NULL, `RecordTypeID` = NULL, `OriginArticle` = '', `EvaluationType` = 'EXTERNAL', `Embossing` = '', `Design` = '', `ColorCode` = '', `ColorRecipe` = '', `ColorCodeRal` = '0000', `StatusGlobal` = NULL, `EdgeTrim` = '', `CreatedByCutting` = '', `BasicRecipe` = '', `Approach` = '', `LeadingSemifinished` = '', `HotColdEmbossing` = '', `Waste` = '', `Regenerate` = '', `BaseUnit` = 'M', `SalesUnit` = 'M', `PackingUnit` = '', `PackingUnitQuantity` = 0, `PackQuantity` = 0, `LengthValue` = 0, `LengthUnit` = NULL, `WidthValue` = NULL, `WidthUnit` = '', `HeightValue` = NULL, `HeightUnit` = NULL, `WeightValue` = NULL, `WeightUnit` = '', `ThicknessValue` = 160, `ThicknessUnit` = 'µm', `PmmaThickness` = NULL, `SpecificWeightValue` = 1.3, `SpecificWeightUnit` = 'g/cm³', `CalculatedHardness` = 0, `Bukrs_md1` = NULL, `Vkorg_md1` = '', `Vtweg_md1` = '', `Sparte_md1` = '00', `Vkbur_md1` = '', `Vkgrp_md1` = '', `Status_md1` = '', `IsNew_md1` = NULL, `IsSale_md1` = NULL, `IsShopMandatoryRelevant_md1` = NULL, `AdditionalText1_md1` = '', `AdditionalText2_md1` = '', `Factory_md1` = '1001', `OriginCountry_md1` = 'DE', `OriginRegion_md1` = '07', `DeliveryUnit_md1` = NULL, `MinAmount_md1` = NULL, `MaxAmount_md1` = NULL, `SalesUnit_md1` = NULL, `BusinessUnitNumber` = '', `BusinessAreaNumber` = '', `ApplicationAreaNumber` = '', `AccessoryMainNumber` = '', `AccessorySubNumber` = '', `InitialSMU` = '', `UsedBySMUS` = NULL, `IsArticleGroup` = NULL, `IsArticle` = 1, `IsShopRelevant` = 1, `MaterialType` = NULL, `key_LVL` = NULL, `txt_LVL` = NULL, `DigitCount` = '10', `DateLaunch` = NULL, `DateCreate` = NULL, `PriceCategory` = '', `StockMto` = '', `StockMTOSince` = NULL, `StockMTOUntil` = NULL, `InStock` = NULL, `MinimumOrderQuantitySAP` = NULL, `Status` = '', `SalesStatusSince` = NULL, `RawMaterials` = '', `InformationShine` = NULL, `InformationRoughness` = NULL, `PrintRollSetName` = NULL, `PrintRollSetCount` = NULL, `PrintRollSetDate` = NULL, `EngraverPrintRoll` = '', `EngraverEmbossRoll` = '', `EngraverDepthRoll` = NULL, `RollSetShine` = NULL, `RollSetProcedure` = '', `RollSetDesignation` = NULL, `IPMZone` = '', `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` = '', `ApplicationExterior` = NULL, `GuaranteeCountryGroup1` = '', `GuaranteeCountryGroup2` = '', `GuaranteeCountryGroup3` = '', `GuaranteeCountryGroup4` = '', `GuaranteeCountryGroup5` = '', `GuaranteeCountryGroup6` = '', `GuaranteeInfo` = NULL, `WeatheringClass` = '', `FireProtectionClass` = NULL, `HeatAbsorptionWhite` = '', `HeatAbsorptionBlack` = '', `TSRWhite` = NULL, `TSRBlack` = NULL, `EN410White` = NULL, `EN410Black` = NULL, `ColorimetricValuesL` = NULL, `ColorimetricValuesA` = NULL, `ColorimetricValuesB` = NULL, `RalGfkp` = NULL, `MatchingRALcolour` = NULL, `ColorGroup` = '', `DetailsRALcolour` = '', `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` = '', `ApplicationInterior` = NULL, `Exclusiveness` = NULL, `MarketingMaterial` = NULL, `Dekorverbundpartner` = NULL, `CollectionsDesign` = NULL, `InteriorProductDescription` = NULL, `InternalInformation` = NULL, `CopyrightOwner` = NULL, `MeasurementLaborBoard` = NULL, `MixedDesign` = NULL, `ImoCertificate` = NULL, `HorizontalPrint` = NULL, `DigitalDataAvailability` = NULL, `BuDesignFormulation` = '', `SampleSaleable` = NULL, `PrintDataSheet` = NULL WHERE `oo_id` = 433730;

SELECT
  ooo_id AS id,
  `MarketingTextLocalized`,
  `SapShortTextLocalized`,
  `BusinessUnitTitle`,
  `BusinessAreaTitle`,
  `ApplicationAreaTitle`
FROM
  object_localized_data_1
WHERE
  ooo_id = ?

SELECT ooo_id AS id, `MarketingTextLocalized`,`SapShortTextLocalized`,`BusinessUnitTitle`,`BusinessAreaTitle`,`ApplicationAreaTitle` FROM object_localized_data_1 WHERE ooo_id = 433730;

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 = 433730
    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
  l.language AS `language`,
  x.id AS id,
  x.classId AS classId,
  x.parentId AS parentId,
  `MarketingTextLocalized`,
  `SapShortTextLocalized`,
  `BusinessUnitTitle`,
  `BusinessAreaTitle`,
  `ApplicationAreaTitle`
FROM
  cte x
  LEFT JOIN object_localized_data_1 l ON x.id = l.ooo_id
WHERE
  COALESCE(`language`, 'sk') = 'sk'
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 = 433730
                    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 l.language AS `language`,
                         x.id AS id,
                         x.classId AS classId,
                         x.parentId AS parentId
                         , `MarketingTextLocalized`,`SapShortTextLocalized`,`BusinessUnitTitle`,`BusinessAreaTitle`,`ApplicationAreaTitle`
                    FROM cte x
                    LEFT JOIN object_localized_data_1 l ON x.id = l.ooo_id
                   WHERE COALESCE(`language`, 'sk') = 'sk' ORDER BY x.path ASC;

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` = ?,
  `LengthValue` = ?,
  `LengthUnit` = ?,
  `WidthValue` = ?,
  `WidthUnit` = ?,
  `HeightValue` = ?,
  `HeightUnit` = ?,
  `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` = ?,
  `MinimumOrderQuantitySAP` = ?,
  `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` = NULL, `MaterialNumber` = 'S1040100550', `MaterialNumberFormatted` = 'S10.40.10.0550.', `MaterialGroupNumber` = NULL, `EAN` = NULL, `StatisticalNumber` = '39204310', `SalesforceProductID` = NULL, `RecordTypeID` = NULL, `OriginArticle` = NULL, `EvaluationType` = 'EXTERNAL', `Embossing` = NULL, `Design` = NULL, `ColorCode` = NULL, `ColorRecipe` = NULL, `ColorCodeRal` = '0000', `StatusGlobal` = NULL, `EdgeTrim` = NULL, `CreatedByCutting` = NULL, `BasicRecipe` = NULL, `Approach` = NULL, `LeadingSemifinished` = NULL, `HotColdEmbossing` = NULL, `Waste` = NULL, `Regenerate` = NULL, `BaseUnit` = 'M', `SalesUnit` = 'M', `PackingUnit` = NULL, `PackingUnitQuantity` = 0, `PackQuantity` = 0, `LengthValue` = 0, `LengthUnit` = NULL, `WidthValue` = NULL, `WidthUnit` = NULL, `HeightValue` = NULL, `HeightUnit` = NULL, `WeightValue` = 0, `WeightUnit` = NULL, `ThicknessValue` = 160, `ThicknessUnit` = 'µm', `PmmaThickness` = NULL, `SpecificWeightValue` = 1.3, `SpecificWeightUnit` = 'g/cm³', `CalculatedHardness` = 0, `Bukrs_md1` = NULL, `Vkorg_md1` = NULL, `Vtweg_md1` = NULL, `Sparte_md1` = '00', `Vkbur_md1` = NULL, `Vkgrp_md1` = NULL, `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` = '10', `BusinessAreaNumber` = '1040', `ApplicationAreaNumber` = '104010', `AccessoryMainNumber` = '', `AccessorySubNumber` = '', `InitialSMU` = '', `UsedBySMUS` = NULL, `IsArticleGroup` = 0, `IsArticle` = 1, `IsShopRelevant` = 1, `MaterialType` = NULL, `key_LVL` = NULL, `txt_LVL` = NULL, `DigitCount` = '10', `DateLaunch` = NULL, `DateCreate` = NULL, `PriceCategory` = '', `StockMto` = '', `StockMTOSince` = NULL, `StockMTOUntil` = NULL, `InStock` = 0, `MinimumOrderQuantitySAP` = NULL, `Status` = '', `SalesStatusSince` = NULL, `RawMaterials` = '', `InformationShine` = NULL, `InformationRoughness` = NULL, `PrintRollSetName` = NULL, `PrintRollSetCount` = NULL, `PrintRollSetDate` = NULL, `EngraverPrintRoll` = '', `EngraverEmbossRoll` = '', `EngraverDepthRoll` = NULL, `RollSetShine` = NULL, `RollSetProcedure` = '', `RollSetDesignation` = NULL, `IPMZone` = '', `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` = '', `ApplicationExterior` = NULL, `GuaranteeCountryGroup1` = '', `GuaranteeCountryGroup2` = '', `GuaranteeCountryGroup3` = '', `GuaranteeCountryGroup4` = '', `GuaranteeCountryGroup5` = '', `GuaranteeCountryGroup6` = '', `GuaranteeInfo` = NULL, `WeatheringClass` = '', `FireProtectionClass` = 0, `HeatAbsorptionWhite` = '', `HeatAbsorptionBlack` = '', `TSRWhite` = NULL, `TSRBlack` = NULL, `EN410White` = NULL, `EN410Black` = NULL, `ColorimetricValuesL` = NULL, `ColorimetricValuesA` = NULL, `ColorimetricValuesB` = NULL, `RalGfkp` = 0, `MatchingRALcolour` = NULL, `ColorGroup` = '', `DetailsRALcolour` = '', `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` = '', `ApplicationInterior` = NULL, `Exclusiveness` = 0, `MarketingMaterial` = 0, `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` = '', `SampleSaleable` = 0, `SampleDocument__id` = NULL, `SampleDocument__type` = NULL, `PrintDataSheet` = 0, `oo_id` = 433730 WHERE `oo_id` = 433730;