Symfony Profiler

INSERT INTO pixel_dates (
  FunctionName, StartEnde, UpdateDatetime
)
VALUES
  (?, ?, ?)

INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime)
                VALUES('update/products','Start','2024-09-21 14:50:02');

INSERT INTO pixel_dates (
  FunctionName, StartEnde, UpdateDatetime
)
VALUES
  (?, ?, ?)

INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime)
                VALUES('update/products','ENDE','2024-09-21 14:50:02');

SELECT
  *,
  articles.material_id as material_id,
  articles.materialgroup_id as materialgroup_id,
  storages.id as storage_id,
  storages.stone_number AS product_number -- , CONCAT(storages.material_id, '_', storages.materialgroup_id) AS product_number_parent
  ,
  CONCAT(
    storages.material_id, '_', storages.materialgroup_id,
    '_'
  ) AS product_number_parent -- , COALESCE(NULLIF(storages.picture, ''), NULLIF(materials.picture, ''), 'default.jpg') AS picture--select picture
  ,
  storages.picture AS storages_picture,
  materials.picture AS materials_picture,
  storages.advice AS advice,
  materials.advice AS description_advice,
  COALESCE(
    NULLIF(materials.picture, ''),
    'default_art.jpg'
  ) AS picture_parent -- select picture
  ,
  key1.key_text AS color_text,
  key2.key_text AS einheit_2
FROM
  articles
  LEFT JOIN materials ON (
    articles.material_id = materials.material_id
    AND articles.materialgroup_id = materials.materialgroup_id
  ) -- LEFT JOIN articlegroups ON (articlegroups.articlegroup_id = articles.article_id)
  LEFT JOIN articlegroups ON (
    articles.articlegroup_id = articlegroups.articlegroup_id
  )
  LEFT JOIN materialgroups ON (
    materialgroups.materialgroup_id = articles.materialgroup_id
  )
  LEFT JOIN surfaces ON (
    surfaces.surface_id = articles.surface_id
    AND surfaces.materialgroup_id = articles.materialgroup_id
  )
  INNER JOIN storages ON (
    articles.article_id = storages.article_id
  )
  LEFT JOIN storagefaults ON (
    storages.fault_id = storagefaults.fault_id
  )
  LEFT JOIN materialcolors ON (
    articles.material_id = materialcolors.mar_id
    AND articles.materialgroup_id = materialcolors.mgr_id
  )
  LEFT JOIN `keys` key1 ON (
    materialcolors.color_id = key1.key_number
    AND key1.key_kind = 88
  )
  LEFT JOIN `keys` key2 ON (
    storages.quantity_unit_2 = key2.key_number
    AND key2.key_kind = 1
  )
  LEFT JOIN artikeldaten ON (
    artikeldaten.material_group = articles.materialgroup_id
    AND artikeldaten.material = articles.material_id
  )
WHERE
  storages.stone_number IS NOT NULL -- AND storages.stone_number = '219102526'
  -- AND articles.material_id = 'BEHA'
  -- AND materials.advice !=''
  AND storages.stone_number != ''
  AND storages.storage != 'ZULAUF' -- AND storages.upload_done IS NULL
  AND storages.upload_done = 4 -- OR storages.upload_done = 4
  -- AND articles.upload_done IS NULL
  AND storages.upload_failed IS NULL
  AND material_name IS NOT NULL -- AND block_advice IS NOT NULL
  -- AND block_advice != ''
ORDER BY
  storages.upload_done DESC,
  articles.id ASC
LIMIT
  5;

SELECT *
                , articles.material_id as material_id
                , articles.materialgroup_id as materialgroup_id
                , storages.id as storage_id
                , storages.stone_number AS product_number
                -- , CONCAT(storages.material_id, '_', storages.materialgroup_id) AS product_number_parent
                , CONCAT(storages.material_id, '_', storages.materialgroup_id, '_') AS product_number_parent
                -- , COALESCE(NULLIF(storages.picture, ''), NULLIF(materials.picture, ''), 'default.jpg') AS picture--select picture
                , storages.picture AS storages_picture
                , materials.picture AS materials_picture
                , storages.advice AS advice
                , materials.advice AS description_advice
                , COALESCE(NULLIF(materials.picture, ''), 'default_art.jpg') AS picture_parent   -- select picture
                , key1.key_text AS color_text
                , key2.key_text AS einheit_2
            FROM articles
            LEFT JOIN materials ON (articles.material_id = materials.material_id AND articles.materialgroup_id = materials.materialgroup_id )
            -- LEFT JOIN articlegroups ON (articlegroups.articlegroup_id = articles.article_id)
            LEFT JOIN articlegroups ON (articles.articlegroup_id = articlegroups.articlegroup_id)
            LEFT JOIN materialgroups ON (materialgroups.materialgroup_id = articles.materialgroup_id)
            LEFT JOIN surfaces ON (surfaces.surface_id = articles.surface_id AND surfaces.materialgroup_id = articles.materialgroup_id)
            INNER JOIN storages ON (articles.article_id = storages.article_id)
            LEFT JOIN storagefaults ON (storages.fault_id = storagefaults.fault_id)
            LEFT JOIN materialcolors  ON (articles.material_id = materialcolors.mar_id AND articles.materialgroup_id = materialcolors.mgr_id )
            LEFT JOIN `keys` key1 ON (materialcolors.color_id = key1.key_number AND key1.key_kind = 88)
            LEFT JOIN `keys` key2 ON (storages.quantity_unit_2 = key2.key_number AND key2.key_kind = 1)
            LEFT JOIN artikeldaten ON (artikeldaten.material_group = articles.materialgroup_id AND artikeldaten.material = articles.material_id)
            WHERE storages.stone_number IS NOT NULL
            -- AND storages.stone_number = '219102526'
            -- AND articles.material_id = 'BEHA'
            -- AND materials.advice !=''
            AND storages.stone_number !=''
            AND storages.storage != 'ZULAUF'
            -- AND storages.upload_done IS NULL
            AND storages.upload_done = 4
            -- OR storages.upload_done = 4
            -- AND articles.upload_done IS NULL
            AND storages.upload_failed IS NULL
            AND material_name IS NOT NULL
            -- AND block_advice IS NOT NULL
            -- AND block_advice != ''
            ORDER BY storages.upload_done DESC, articles.id ASC
            LIMIT 5
            ;;

UPDATE
  storages
SET
  upload_done = ?,
  upload_failed = ? -- WHERE stone_number = ''
WHERE
  (
    upload_done IS NULL
    AND upload_failed IS NULL
  )
  OR (
    upload_done = 4
    AND upload_failed IS NULL
  );

UPDATE storages SET
                upload_done = 1,
                upload_failed = 3
        -- WHERE stone_number = ''
        WHERE (upload_done IS NULL AND upload_failed IS NULL) OR (upload_done = 4 AND upload_failed IS NULL)
        ;;