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

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 > 1772132961 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 '/de/obstsorte/birnen/' AND `key` = BINARY 'roemische-schmalzbirne';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte/birnen/roemische-schmalzbirne';

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

SELECT id FROM documents WHERE `path` = BINARY '/de/obstsorte/birnen/' AND `key` = BINARY 'roemische-schmalzbirne';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte/birnen/roemische-schmalzbirne';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte/birnen';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte';

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

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

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/de/obstsorte/birnen/roemische-schmalzbirne'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/obstsorte/birnen/roemische-schmalzbirne' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';

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

SELECT id FROM documents WHERE `path` = BINARY '/de/obstsorte/birnen/' AND `key` = BINARY 'roemische-schmalzbirne';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte/birnen/roemische-schmalzbirne';

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/de/obstsorte/birnen';

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

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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties
tags
', 'document_6
tags
');

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '2';

SELECT
  object_2.id as id,
  object_2.type as `type`
FROM
  object_2
WHERE
  (
    `slug` = 'birnen'
    AND object_2.type IN ('variant', 'object')
  )
  AND object_2.published = 1
LIMIT
  1

SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (`slug` = 'birnen'  AND  object_2.type IN ('variant','object')) AND object_2.published = 1 LIMIT 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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_11');

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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_11
tags
', 'class_2
tags
', 'asset_457
tags
');

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

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 11;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 11;

SELECT
  *
FROM
  object_store_2
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_2 WHERE oo_id = 11 FOR UPDATE;

select
  `infos`
from
  object_store_2
where
  oo_id = 11

select `infos` from object_store_2 where oo_id  = 11;

select
  `images`
from
  object_store_2
where
  oo_id = 11

select `images` from object_store_2 where oo_id  = 11;

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

SELECT
  *
FROM
  object_relations_2
WHERE
  src_id = ?

SELECT * FROM object_relations_2 WHERE src_id = 11;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '1';

SELECT
  object_1.id as id,
  object_1.type as `type`
FROM
  object_1
WHERE
  (
    `slug` = 'roemische-schmalzbirne'
    AND object_1.type IN ('variant', 'object')
  )
  AND object_1.published = 1

SELECT object_1.id as id, object_1.type as `type` FROM object_1 WHERE (`slug` = 'roemische-schmalzbirne'  AND  object_1.type IN ('variant','object')) AND object_1.published = 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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_613');

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

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

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

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

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

SELECT id FROM objects WHERE `path` = BINARY '/Obstsorten/birnen/' AND `key` = BINARY 'roemische-schmalzbirne';

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

SELECT id FROM objects WHERE `path` = BINARY '/Obstsorten/birnen/' AND `key` = BINARY 'roemische-schmalzbirne';

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 613 FOR UPDATE;

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

SELECT MAX(versionCount) FROM versions WHERE cid = 613 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 > 1772132961 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 > 1772132961 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 = 613;

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 ('/Obstsorten/birnen/', 613, 1669375352, 1772132961, 74, 0, 0, 5264, 'object', 'roemische-schmalzbirne', 0, NULL, NULL, '1', 1, 'Obstsorte');

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` = '/Obstsorten/birnen/', `id` = 613, `creationDate` = 1669375352, `modificationDate` = 1772132961, `versionCount` = 74, `userOwner` = 0, `userModification` = 0, `parentId` = 5264, `type` = 'object', `key` = 'roemische-schmalzbirne', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = '1', `published` = 1, `className` = 'Obstsorte' WHERE `id` = 613;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

SELECT
  id
FROM
  object_brick_store_Birnen_1
WHERE
  id = ?
LIMIT
  1

SELECT id FROM object_brick_store_Birnen_1 WHERE id = 613 LIMIT 1;

UPDATE
  object_brick_store_Birnen_1
SET
  `id` = ?,
  `fieldname` = ?,
  `form_laengs` = ?,
  `kelchgrube_tiefe` = ?,
  `laenge_der_frucht` = ?,
  `stielgrube_tiefe` = ?,
  `form_quer` = ?,
  `symmetrie` = ?,
  `durchmesser_der_frucht` = ?,
  `verhaeltnis_laenge_durchmesser` = ?,
  `seitenform_der_frucht` = ?,
  `position_des_maximalen_durchmessers` = ?,
  `kelchgrube_breite` = ?,
  `stielgrube_breite` = ?,
  `relief` = ?,
  `form_kelchseite` = ?,
  `form_stielseite` = ?,
  `fruchtgroesse_g` = ?,
  `schale_bereifung` = ?,
  `druckfestigkeit` = ?,
  `schale_grundfarbe` = ?,
  `schale_deckfarbenanteil` = ?,
  `schale_deckfarbe` = ?,
  `schale_deckfarben_intensitaet` = ?,
  `schale_deckfarben_auspraegung` = ?,
  `schale_dicke` = ?,
  `schalen_oberflaeche_aussehen` = ?,
  `schalen_geruch` = ?,
  `schalen_oberflaeche_griffigkeit` = ?,
  `kelch_kelchblaetter_groesse` = ?,
  `kelchumgebung` = ?,
  `kelch_kelchblaetter_anordnung` = ?,
  `kelchhoehle_groesse` = ?,
  `kelchhoehle_kelchroehre` = ?,
  `kelch_groesse` = ?,
  `kelch_oeffnung` = ?,
  `kelchhoehle_form` = ?,
  `kelchhoehle_staubfaden_ansaetze` = ?,
  `stiel_form` = ?,
  `stiel_laenge` = ?,
  `stiel_dicke` = ?,
  `stielstand` = ?,
  `stielfarbe` = ?,
  `stiel_relative_laenge` = ?,
  `erntereife` = ?,
  `haltbarkeit` = ?,
  `kernhaus_groesse_der_kerne` = ?,
  `kernhaus_steinzellenkranz` = ?,
  `kernhaus_oeffnung_der_kernfaecher` = ?,
  `kernhaus_entwicklung_der_kerne` = ?,
  `kernhaus_anzahl_der_kerne` = ?,
  `kernhaus_form_der_kerne` = ?,
  `kernhaus_groesse` = ?,
  `fruchtfleisch_farbe` = ?,
  `fruchtfleisch_festigkeit` = ?,
  `fruchtfleisch_textur` = ?,
  `fruchtfleisch_saftigkeit` = ?,
  `fruchtfleisch_geschmack` = ?,
  `fruchtfleisch_art_des_geschmacks` = ?,
  `fruchtfleisch_adstringenz` = ?,
  `fruchtfleisch_saeure` = ?,
  `fruchtfleisch_suesse` = ?,
  `schalenpunkte` = ?,
  `berostung_kelchgrube` = ?,
  `berostung_wangen` = ?,
  `berostung_stielgrube` = ?,
  `berostung_form` = ?,
  `berostung_farbe` = ?,
  `berostung_struktur` = ?,
  `schalenpunkte_groesse` = ?,
  `schalenpunkte_hoefe_groesse` = ?,
  `fruchtform_mostbirnen_1` = ?,
  `deckfarbe_mostbirnen_1` = ?,
  `stiellaenge_mostbirnen_1` = ?,
  `reifezeit_mostbirnen_2` = ?,
  `fruchtgroesse_mostbirnen_2` = ?,
  `haeufigkeit` = ?,
  `reifezeit_einf` = ?,
  `fruchtgroesse_einf` = ?,
  `stielbereich_einf` = ?,
  `grundfarbe_einf` = ?,
  `deckfarbe_einf` = ?,
  `form_einf` = ?,
  `stiellaenge_einf` = ?,
  `kelchbereich_einf` = ?,
  `namen_herkunft` = ?,
  `urspruengliche_verbreitung` = ?
WHERE
  id = ?

UPDATE object_brick_store_Birnen_1 SET `id` = 613, `fieldname` = 'attribute', `form_laengs` = NULL, `kelchgrube_tiefe` = NULL, `laenge_der_frucht` = NULL, `stielgrube_tiefe` = NULL, `form_quer` = NULL, `symmetrie` = NULL, `durchmesser_der_frucht` = NULL, `verhaeltnis_laenge_durchmesser` = NULL, `seitenform_der_frucht` = NULL, `position_des_maximalen_durchmessers` = NULL, `kelchgrube_breite` = NULL, `stielgrube_breite` = NULL, `relief` = NULL, `form_kelchseite` = NULL, `form_stielseite` = NULL, `fruchtgroesse_g` = NULL, `schale_bereifung` = '', `druckfestigkeit` = '', `schale_grundfarbe` = NULL, `schale_deckfarbenanteil` = NULL, `schale_deckfarbe` = NULL, `schale_deckfarben_intensitaet` = NULL, `schale_deckfarben_auspraegung` = NULL, `schale_dicke` = '', `schalen_oberflaeche_aussehen` = NULL, `schalen_geruch` = NULL, `schalen_oberflaeche_griffigkeit` = NULL, `kelch_kelchblaetter_groesse` = NULL, `kelchumgebung` = '', `kelch_kelchblaetter_anordnung` = NULL, `kelchhoehle_groesse` = NULL, `kelchhoehle_kelchroehre` = NULL, `kelch_groesse` = NULL, `kelch_oeffnung` = NULL, `kelchhoehle_form` = '', `kelchhoehle_staubfaden_ansaetze` = NULL, `stiel_form` = NULL, `stiel_laenge` = NULL, `stiel_dicke` = NULL, `stielstand` = NULL, `stielfarbe` = NULL, `stiel_relative_laenge` = NULL, `erntereife` = NULL, `haltbarkeit` = NULL, `kernhaus_groesse_der_kerne` = NULL, `kernhaus_steinzellenkranz` = NULL, `kernhaus_oeffnung_der_kernfaecher` = NULL, `kernhaus_entwicklung_der_kerne` = NULL, `kernhaus_anzahl_der_kerne` = NULL, `kernhaus_form_der_kerne` = NULL, `kernhaus_groesse` = NULL, `fruchtfleisch_farbe` = NULL, `fruchtfleisch_festigkeit` = NULL, `fruchtfleisch_textur` = NULL, `fruchtfleisch_saftigkeit` = NULL, `fruchtfleisch_geschmack` = '', `fruchtfleisch_art_des_geschmacks` = NULL, `fruchtfleisch_adstringenz` = '', `fruchtfleisch_saeure` = NULL, `fruchtfleisch_suesse` = NULL, `schalenpunkte` = '', `berostung_kelchgrube` = NULL, `berostung_wangen` = NULL, `berostung_stielgrube` = NULL, `berostung_form` = NULL, `berostung_farbe` = NULL, `berostung_struktur` = NULL, `schalenpunkte_groesse` = NULL, `schalenpunkte_hoefe_groesse` = NULL, `fruchtform_mostbirnen_1` = 'id_alt_1438', `deckfarbe_mostbirnen_1` = 'id_alt_1440', `stiellaenge_mostbirnen_1` = 'id_alt_1442', `reifezeit_mostbirnen_2` = 'id_alt_1446', `fruchtgroesse_mostbirnen_2` = 'id_alt_1451', `haeufigkeit` = NULL, `reifezeit_einf` = NULL, `fruchtgroesse_einf` = NULL, `stielbereich_einf` = NULL, `grundfarbe_einf` = NULL, `deckfarbe_einf` = NULL, `form_einf` = 'id_alt_1861,id_alt_1862', `stiellaenge_einf` = NULL, `kelchbereich_einf` = NULL, `namen_herkunft` = '', `urspruengliche_verbreitung` = NULL WHERE id = 613;

SELECT
  *
FROM
  object_brick_query_Birnen_1
WHERE
  id = ?

SELECT * FROM object_brick_query_Birnen_1 WHERE id = 613;

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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_brick_query_Birnen_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 > 1772132961 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_brick_query_Birnen_1');

SHOW COLUMNS
FROM
  object_brick_query_Birnen_1

SHOW COLUMNS FROM object_brick_query_Birnen_1;

INSERT INTO object_brick_query_Birnen_1 (
  `id`, `fieldname`, `form_laengs`,
  `kelchgrube_tiefe`, `laenge_der_frucht`,
  `stielgrube_tiefe`, `form_quer`,
  `symmetrie`, `durchmesser_der_frucht`,
  `verhaeltnis_laenge_durchmesser`,
  `seitenform_der_frucht`, `position_des_maximalen_durchmessers`,
  `kelchgrube_breite`, `stielgrube_breite`,
  `relief`, `form_kelchseite`, `form_stielseite`,
  `fruchtgroesse_g`, `schale_bereifung`,
  `druckfestigkeit`, `schale_grundfarbe`,
  `schale_deckfarbenanteil`, `schale_deckfarbe`,
  `schale_deckfarben_intensitaet`,
  `schale_deckfarben_auspraegung`,
  `schale_dicke`, `schalen_oberflaeche_aussehen`,
  `schalen_geruch`, `schalen_oberflaeche_griffigkeit`,
  `kelch_kelchblaetter_groesse`,
  `kelchumgebung`, `kelch_kelchblaetter_anordnung`,
  `kelchhoehle_groesse`, `kelchhoehle_kelchroehre`,
  `kelch_groesse`, `kelch_oeffnung`,
  `kelchhoehle_form`, `kelchhoehle_staubfaden_ansaetze`,
  `stiel_form`, `stiel_laenge`, `stiel_dicke`,
  `stielstand`, `stielfarbe`, `stiel_relative_laenge`,
  `erntereife`, `haltbarkeit`, `kernhaus_groesse_der_kerne`,
  `kernhaus_steinzellenkranz`, `kernhaus_oeffnung_der_kernfaecher`,
  `kernhaus_entwicklung_der_kerne`,
  `kernhaus_anzahl_der_kerne`, `kernhaus_form_der_kerne`,
  `kernhaus_groesse`, `fruchtfleisch_farbe`,
  `fruchtfleisch_festigkeit`, `fruchtfleisch_textur`,
  `fruchtfleisch_saftigkeit`, `fruchtfleisch_geschmack`,
  `fruchtfleisch_art_des_geschmacks`,
  `fruchtfleisch_adstringenz`, `fruchtfleisch_saeure`,
  `fruchtfleisch_suesse`, `schalenpunkte`,
  `berostung_kelchgrube`, `berostung_wangen`,
  `berostung_stielgrube`, `berostung_form`,
  `berostung_farbe`, `berostung_struktur`,
  `schalenpunkte_groesse`, `schalenpunkte_hoefe_groesse`,
  `fruchtform_mostbirnen_1`, `deckfarbe_mostbirnen_1`,
  `stiellaenge_mostbirnen_1`, `reifezeit_mostbirnen_2`,
  `fruchtgroesse_mostbirnen_2`, `haeufigkeit`,
  `reifezeit_einf`, `fruchtgroesse_einf`,
  `stielbereich_einf`, `grundfarbe_einf`,
  `deckfarbe_einf`, `form_einf`, `stiellaenge_einf`,
  `kelchbereich_einf`, `namen_herkunft`,
  `urspruengliche_verbreitung`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_brick_query_Birnen_1 (`id`, `fieldname`, `form_laengs`, `kelchgrube_tiefe`, `laenge_der_frucht`, `stielgrube_tiefe`, `form_quer`, `symmetrie`, `durchmesser_der_frucht`, `verhaeltnis_laenge_durchmesser`, `seitenform_der_frucht`, `position_des_maximalen_durchmessers`, `kelchgrube_breite`, `stielgrube_breite`, `relief`, `form_kelchseite`, `form_stielseite`, `fruchtgroesse_g`, `schale_bereifung`, `druckfestigkeit`, `schale_grundfarbe`, `schale_deckfarbenanteil`, `schale_deckfarbe`, `schale_deckfarben_intensitaet`, `schale_deckfarben_auspraegung`, `schale_dicke`, `schalen_oberflaeche_aussehen`, `schalen_geruch`, `schalen_oberflaeche_griffigkeit`, `kelch_kelchblaetter_groesse`, `kelchumgebung`, `kelch_kelchblaetter_anordnung`, `kelchhoehle_groesse`, `kelchhoehle_kelchroehre`, `kelch_groesse`, `kelch_oeffnung`, `kelchhoehle_form`, `kelchhoehle_staubfaden_ansaetze`, `stiel_form`, `stiel_laenge`, `stiel_dicke`, `stielstand`, `stielfarbe`, `stiel_relative_laenge`, `erntereife`, `haltbarkeit`, `kernhaus_groesse_der_kerne`, `kernhaus_steinzellenkranz`, `kernhaus_oeffnung_der_kernfaecher`, `kernhaus_entwicklung_der_kerne`, `kernhaus_anzahl_der_kerne`, `kernhaus_form_der_kerne`, `kernhaus_groesse`, `fruchtfleisch_farbe`, `fruchtfleisch_festigkeit`, `fruchtfleisch_textur`, `fruchtfleisch_saftigkeit`, `fruchtfleisch_geschmack`, `fruchtfleisch_art_des_geschmacks`, `fruchtfleisch_adstringenz`, `fruchtfleisch_saeure`, `fruchtfleisch_suesse`, `schalenpunkte`, `berostung_kelchgrube`, `berostung_wangen`, `berostung_stielgrube`, `berostung_form`, `berostung_farbe`, `berostung_struktur`, `schalenpunkte_groesse`, `schalenpunkte_hoefe_groesse`, `fruchtform_mostbirnen_1`, `deckfarbe_mostbirnen_1`, `stiellaenge_mostbirnen_1`, `reifezeit_mostbirnen_2`, `fruchtgroesse_mostbirnen_2`, `haeufigkeit`, `reifezeit_einf`, `fruchtgroesse_einf`, `stielbereich_einf`, `grundfarbe_einf`, `deckfarbe_einf`, `form_einf`, `stiellaenge_einf`, `kelchbereich_einf`, `namen_herkunft`, `urspruengliche_verbreitung`) VALUES (613, 'attribute', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ',id_alt_1438,', ',id_alt_1440,', ',id_alt_1442,', ',id_alt_1446,', ',id_alt_1451,', NULL, NULL, NULL, NULL, NULL, NULL, ',id_alt_1861,id_alt_1862,', NULL, NULL, '', NULL);

UPDATE
  object_brick_query_Birnen_1
SET
  `id` = ?,
  `fieldname` = ?,
  `form_laengs` = ?,
  `kelchgrube_tiefe` = ?,
  `laenge_der_frucht` = ?,
  `stielgrube_tiefe` = ?,
  `form_quer` = ?,
  `symmetrie` = ?,
  `durchmesser_der_frucht` = ?,
  `verhaeltnis_laenge_durchmesser` = ?,
  `seitenform_der_frucht` = ?,
  `position_des_maximalen_durchmessers` = ?,
  `kelchgrube_breite` = ?,
  `stielgrube_breite` = ?,
  `relief` = ?,
  `form_kelchseite` = ?,
  `form_stielseite` = ?,
  `fruchtgroesse_g` = ?,
  `schale_bereifung` = ?,
  `druckfestigkeit` = ?,
  `schale_grundfarbe` = ?,
  `schale_deckfarbenanteil` = ?,
  `schale_deckfarbe` = ?,
  `schale_deckfarben_intensitaet` = ?,
  `schale_deckfarben_auspraegung` = ?,
  `schale_dicke` = ?,
  `schalen_oberflaeche_aussehen` = ?,
  `schalen_geruch` = ?,
  `schalen_oberflaeche_griffigkeit` = ?,
  `kelch_kelchblaetter_groesse` = ?,
  `kelchumgebung` = ?,
  `kelch_kelchblaetter_anordnung` = ?,
  `kelchhoehle_groesse` = ?,
  `kelchhoehle_kelchroehre` = ?,
  `kelch_groesse` = ?,
  `kelch_oeffnung` = ?,
  `kelchhoehle_form` = ?,
  `kelchhoehle_staubfaden_ansaetze` = ?,
  `stiel_form` = ?,
  `stiel_laenge` = ?,
  `stiel_dicke` = ?,
  `stielstand` = ?,
  `stielfarbe` = ?,
  `stiel_relative_laenge` = ?,
  `erntereife` = ?,
  `haltbarkeit` = ?,
  `kernhaus_groesse_der_kerne` = ?,
  `kernhaus_steinzellenkranz` = ?,
  `kernhaus_oeffnung_der_kernfaecher` = ?,
  `kernhaus_entwicklung_der_kerne` = ?,
  `kernhaus_anzahl_der_kerne` = ?,
  `kernhaus_form_der_kerne` = ?,
  `kernhaus_groesse` = ?,
  `fruchtfleisch_farbe` = ?,
  `fruchtfleisch_festigkeit` = ?,
  `fruchtfleisch_textur` = ?,
  `fruchtfleisch_saftigkeit` = ?,
  `fruchtfleisch_geschmack` = ?,
  `fruchtfleisch_art_des_geschmacks` = ?,
  `fruchtfleisch_adstringenz` = ?,
  `fruchtfleisch_saeure` = ?,
  `fruchtfleisch_suesse` = ?,
  `schalenpunkte` = ?,
  `berostung_kelchgrube` = ?,
  `berostung_wangen` = ?,
  `berostung_stielgrube` = ?,
  `berostung_form` = ?,
  `berostung_farbe` = ?,
  `berostung_struktur` = ?,
  `schalenpunkte_groesse` = ?,
  `schalenpunkte_hoefe_groesse` = ?,
  `fruchtform_mostbirnen_1` = ?,
  `deckfarbe_mostbirnen_1` = ?,
  `stiellaenge_mostbirnen_1` = ?,
  `reifezeit_mostbirnen_2` = ?,
  `fruchtgroesse_mostbirnen_2` = ?,
  `haeufigkeit` = ?,
  `reifezeit_einf` = ?,
  `fruchtgroesse_einf` = ?,
  `stielbereich_einf` = ?,
  `grundfarbe_einf` = ?,
  `deckfarbe_einf` = ?,
  `form_einf` = ?,
  `stiellaenge_einf` = ?,
  `kelchbereich_einf` = ?,
  `namen_herkunft` = ?,
  `urspruengliche_verbreitung` = ?
WHERE
  `id` = ?
  AND `fieldname` = ?

UPDATE object_brick_query_Birnen_1 SET `id` = 613, `fieldname` = 'attribute', `form_laengs` = NULL, `kelchgrube_tiefe` = NULL, `laenge_der_frucht` = NULL, `stielgrube_tiefe` = NULL, `form_quer` = NULL, `symmetrie` = NULL, `durchmesser_der_frucht` = NULL, `verhaeltnis_laenge_durchmesser` = NULL, `seitenform_der_frucht` = NULL, `position_des_maximalen_durchmessers` = NULL, `kelchgrube_breite` = NULL, `stielgrube_breite` = NULL, `relief` = NULL, `form_kelchseite` = NULL, `form_stielseite` = NULL, `fruchtgroesse_g` = NULL, `schale_bereifung` = '', `druckfestigkeit` = '', `schale_grundfarbe` = NULL, `schale_deckfarbenanteil` = NULL, `schale_deckfarbe` = NULL, `schale_deckfarben_intensitaet` = NULL, `schale_deckfarben_auspraegung` = NULL, `schale_dicke` = '', `schalen_oberflaeche_aussehen` = NULL, `schalen_geruch` = NULL, `schalen_oberflaeche_griffigkeit` = NULL, `kelch_kelchblaetter_groesse` = NULL, `kelchumgebung` = '', `kelch_kelchblaetter_anordnung` = NULL, `kelchhoehle_groesse` = NULL, `kelchhoehle_kelchroehre` = NULL, `kelch_groesse` = NULL, `kelch_oeffnung` = NULL, `kelchhoehle_form` = '', `kelchhoehle_staubfaden_ansaetze` = NULL, `stiel_form` = NULL, `stiel_laenge` = NULL, `stiel_dicke` = NULL, `stielstand` = NULL, `stielfarbe` = NULL, `stiel_relative_laenge` = NULL, `erntereife` = NULL, `haltbarkeit` = NULL, `kernhaus_groesse_der_kerne` = NULL, `kernhaus_steinzellenkranz` = NULL, `kernhaus_oeffnung_der_kernfaecher` = NULL, `kernhaus_entwicklung_der_kerne` = NULL, `kernhaus_anzahl_der_kerne` = NULL, `kernhaus_form_der_kerne` = NULL, `kernhaus_groesse` = NULL, `fruchtfleisch_farbe` = NULL, `fruchtfleisch_festigkeit` = NULL, `fruchtfleisch_textur` = NULL, `fruchtfleisch_saftigkeit` = NULL, `fruchtfleisch_geschmack` = '', `fruchtfleisch_art_des_geschmacks` = NULL, `fruchtfleisch_adstringenz` = '', `fruchtfleisch_saeure` = NULL, `fruchtfleisch_suesse` = NULL, `schalenpunkte` = '', `berostung_kelchgrube` = NULL, `berostung_wangen` = NULL, `berostung_stielgrube` = NULL, `berostung_form` = NULL, `berostung_farbe` = NULL, `berostung_struktur` = NULL, `schalenpunkte_groesse` = NULL, `schalenpunkte_hoefe_groesse` = NULL, `fruchtform_mostbirnen_1` = ',id_alt_1438,', `deckfarbe_mostbirnen_1` = ',id_alt_1440,', `stiellaenge_mostbirnen_1` = ',id_alt_1442,', `reifezeit_mostbirnen_2` = ',id_alt_1446,', `fruchtgroesse_mostbirnen_2` = ',id_alt_1451,', `haeufigkeit` = NULL, `reifezeit_einf` = NULL, `fruchtgroesse_einf` = NULL, `stielbereich_einf` = NULL, `grundfarbe_einf` = NULL, `deckfarbe_einf` = NULL, `form_einf` = ',id_alt_1861,id_alt_1862,', `stiellaenge_einf` = NULL, `kelchbereich_einf` = NULL, `namen_herkunft` = '', `urspruengliche_verbreitung` = NULL WHERE `id` = 613 AND `fieldname` = 'attribute';