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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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

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

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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 > 1777309996 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 > 1777309996 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/thimo'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/de/obstsorte/birnen/thimo' 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 'thimo';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

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

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 > 1777309996 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 > 1777309996 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 > 1777309996 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 > 1777309996 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 > 1777309996 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` = 'thimo'
    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` = 'thimo'  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 > 1777309996 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3647');

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

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

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

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 = 3647;

SELECT
  *
FROM
  object_store_1
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_1 WHERE oo_id = 3647 FOR UPDATE;

select
  `synonyme`
from
  object_store_1
where
  oo_id = 3647

select `synonyme` from object_store_1 where oo_id  = 3647;

select
  `infos`
from
  object_store_1
where
  oo_id = 3647

select `infos` from object_store_1 where oo_id  = 3647;

SELECT
  *
FROM
  object_brick_store_Aepfel_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Aepfel_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Aprikosen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Aprikosen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Berberitzen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Berberitzen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Birnen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Birnen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Bocksdorne_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Bocksdorne_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Chinabeeren_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Chinabeeren_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Dorne_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Dorne_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Edelkastanien_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Edelkastanien_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Erdbeeren_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Erdbeeren_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Feigen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Feigen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Felsenbirnen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Felsenbirnen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Fruchtrosen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Fruchtrosen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Haselnuesse_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Haselnuesse_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Heckenkirschen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Heckenkirschen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Heidelbeerartige_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Heidelbeerartige_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_HimbeerenUndVerwandte_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_HimbeerenUndVerwandte_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Holunder_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Holunder_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_IndianerBananen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_IndianerBananen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_JohannisbeerenUndVerwandte_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_JohannisbeerenUndVerwandte_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Jujuben_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Jujuben_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Kaki_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Kaki_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Kirschen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Kirschen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Kiwi_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Kiwi_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Kornelkirschen_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Kornelkirschen_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Mahonien_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Mahonien_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Maibeeren_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Maibeeren_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Mandeln_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Mandeln_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Maulbeeren_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Maulbeeren_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Mispeln_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Mispeln_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Oelweiden_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Oelweiden_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Pfirsichartige_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Pfirsichartige_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Pflaumenartige_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Pflaumenartige_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Pimpernuesse_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Pimpernuesse_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Quitten_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Quitten_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Rhabarber_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Rhabarber_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Sanddorne_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Sanddorne_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Scheinquitten_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Scheinquitten_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Trauben_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Trauben_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_TraubenkirschenUndVerwandte_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_TraubenkirschenUndVerwandte_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Vogelbeerenartige_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Vogelbeerenartige_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Wacholder_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Wacholder_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_WalnuesseUndVerwandte_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_WalnuesseUndVerwandte_1 WHERE id = 3647 AND fieldname = 'attribute';

SELECT
  *
FROM
  object_brick_store_Apfelbeeren_1
WHERE
  id = ?
  AND fieldname = ?

SELECT * FROM object_brick_store_Apfelbeeren_1 WHERE id = 3647 AND fieldname = 'attribute';

select
  `images`
from
  object_store_1
where
  oo_id = 3647

select `images` from object_store_1 where oo_id  = 3647;

SELECT
  *
FROM
  object_relations_1
WHERE
  src_id = ?

SELECT * FROM object_relations_1 WHERE src_id = 3647;

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

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

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

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 3647 FOR UPDATE;

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

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

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/', 3647, 1669375965, 1777309996, 26, 0, 0, 5264, 'object', 'thimo', 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` = 3647, `creationDate` = 1669375965, `modificationDate` = 1777309996, `versionCount` = 26, `userOwner` = 0, `userModification` = 0, `parentId` = 5264, `type` = 'object', `key` = 'thimo', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = '1', `published` = 1, `className` = 'Obstsorte' WHERE `id` = 3647;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 3647 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 = 3647 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 = ?