Symfony Profiler

SELECT 
  id, 
  (
    CASE WHEN expire IS NULL 
    OR expire > ? THEN data ELSE NULL END
  ) as data 
FROM 
  cache 
WHERE 
  id IN (?)

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > 1775291623 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('document_1097');

INSERT INTO cache (id, data, expire, mtime) 
VALUES 
  (: id, : data, : expire, : mtime) ON DUPLICATE KEY 
UPDATE 
  data = 
VALUES 
  (data), 
  expire = 
VALUES 
  (expire), 
  mtime = 
VALUES 
  (mtime)

INSERT INTO
    cache (id, data, expire, mtime) VALUES ('nav_e0599d72ef0a9269a7ca63baed6a221f', 's:16587:\"O:28:\"Pimcore\\Navigation\\Container\":3:{s:9:\"\0*\0_pages\";a:11:{s:32:\"000000000411b7d70000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1096;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:24:\"/Aiko/de/Unsere Produkte\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:26:\"/Aiko/de/Unsere%20Produkte\";s:9:\"\0*\0_label\";s:15:\"Unsere Produkte\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1096\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:4:{s:32:\"000000000411b7cb0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1099;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:34:\"/Aiko/de/Unsere Produkte/Sojasauce\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:36:\"/Aiko/de/Unsere%20Produkte/Sojasauce\";s:9:\"\0*\0_label\";s:9:\"Sojasauce\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1099\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:3;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b7fd0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1100;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:47:\"/Aiko/de/Unsere Produkte/Fairtrade Saucen 200ml\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:53:\"/Aiko/de/Unsere%20Produkte/Fairtrade%20Saucen%20200ml\";s:9:\"\0*\0_label\";s:16:\"Fairtrade Saucen\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1100\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:3;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:4:{s:32:\"000000000411b7900000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1103;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:66:\"/Aiko/de/Unsere Produkte/Fairtrade Saucen 200ml/Sweet Chilli Sauce\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:76:\"/Aiko/de/Unsere%20Produkte/Fairtrade%20Saucen%20200ml/Sweet%20Chilli%20Sauce\";s:9:\"\0*\0_label\";s:18:\"Sweet Chilli Sauce\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1103\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:53;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b7820000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1104;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:66:\"/Aiko/de/Unsere Produkte/Fairtrade Saucen 200ml/Sweet - Sour Sauce\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:78:\"/Aiko/de/Unsere%20Produkte/Fairtrade%20Saucen%20200ml/Sweet%20-%20Sour%20Sauce\";s:9:\"\0*\0_label\";s:18:\"Sweet & Sour Sauce\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1104\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:53;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b7b70000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1105;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:62:\"/Aiko/de/Unsere Produkte/Fairtrade Saucen 200ml/Teriyaki Sauce\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:70:\"/Aiko/de/Unsere%20Produkte/Fairtrade%20Saucen%20200ml/Teriyaki%20Sauce\";s:9:\"\0*\0_label\";s:14:\"Teriyaki Sauce\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1105\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:53;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b7b80000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1107;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:61:\"/Aiko/de/Unsere Produkte/Fairtrade Saucen 200ml/Bulgogi Sauce\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:69:\"/Aiko/de/Unsere%20Produkte/Fairtrade%20Saucen%20200ml/Bulgogi%20Sauce\";s:9:\"\0*\0_label\";s:13:\"Bulgogi Sauce\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1107\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:53;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}}s:9:\"\0*\0_index\";a:4:{s:32:\"000000000411b7900000000058902017\";N;s:32:\"000000000411b7820000000058902017\";N;s:32:\"000000000411b7b70000000058902017\";N;s:32:\"000000000411b7b80000000058902017\";N;}s:14:\"\0*\0_dirtyIndex\";b:1;}s:32:\"000000000411b7ad0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1101;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:44:\"/Aiko/de/Unsere Produkte/Dippen - Marinieren\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:50:\"/Aiko/de/Unsere%20Produkte/Dippen%20-%20Marinieren\";s:9:\"\0*\0_label\";s:19:\"Dippen & Marinieren\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1101\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:3;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b65e0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1102;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:46:\"/Aiko/de/Unsere Produkte/Für Großverbraucher\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:58:\"/Aiko/de/Unsere%20Produkte/F%C3%BCr%20Gro%C3%9Fverbraucher\";s:9:\"\0*\0_label\";s:21:\"Für Großverbraucher\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1102\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:3;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}}s:9:\"\0*\0_index\";a:4:{s:32:\"000000000411b7cb0000000058902017\";N;s:32:\"000000000411b7fd0000000058902017\";N;s:32:\"000000000411b7ad0000000058902017\";N;s:32:\"000000000411b65e0000000058902017\";N;}s:14:\"\0*\0_dirtyIndex\";b:1;}s:32:\"000000000411b6430000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:97;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:30:\"/Aiko/de/Rezepte - Inspiration\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:34:\"/Aiko/de/Rezepte%20-%20Inspiration\";s:9:\"\0*\0_label\";s:7:\"Rezepte\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"97\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:1:{s:32:\"000000000411b6660000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1112;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:54:\"/Aiko/de/Rezepte - Inspiration/Rezepte - Inspirationen\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:62:\"/Aiko/de/Rezepte%20-%20Inspiration/Rezepte%20-%20Inspirationen\";s:9:\"\0*\0_label\";s:23:\"Rezepte & Inspirationen\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1112\";s:9:\"\0*\0_class\";s:0:\"\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:245;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}}s:9:\"\0*\0_index\";a:1:{s:32:\"000000000411b6660000000058902017\";N;}s:14:\"\0*\0_dirtyIndex\";b:1;}s:32:\"000000000411b6680000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:89;s:15:\"\0*\0documentType\";s:4:\"link\";s:15:\"\0*\0realFullPath\";s:19:\"/Aiko/de/Startseite\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:8:\"/Aiko/de\";s:9:\"\0*\0_label\";s:4:\"Aiko\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"89\";s:9:\"\0*\0_class\";s:18:\"homepage-logo main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6040000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1097;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:18:\"/Aiko/de/Über uns\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:24:\"/Aiko/de/%C3%9Cber%20uns\";s:9:\"\0*\0_label\";s:9:\"Über uns\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1097\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b60f0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";N;s:12:\"\0*\0_tabindex\";N;s:12:\"\0*\0_relation\";N;s:14:\"\0*\0_documentId\";i:1098;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:16:\"/Aiko/de/Kontakt\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:16:\"/Aiko/de/Kontakt\";s:9:\"\0*\0_label\";s:7:\"Kontakt\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:4:\"1098\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";N;s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:1;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6300000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:94;s:15:\"\0*\0documentType\";s:4:\"link\";s:15:\"\0*\0realFullPath\";s:15:\"/Aiko/de/Saucen\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:8:\"/#saucen\";s:9:\"\0*\0_label\";s:6:\"Saucen\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"94\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6d20000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:93;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:16:\"/Aiko/de/kontakt\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:16:\"/Aiko/de/kontakt\";s:9:\"\0*\0_label\";s:7:\"Kontakt\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"93\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6cc0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:90;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:17:\"/Aiko/de/articles\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:17:\"/Aiko/de/articles\";s:9:\"\0*\0_label\";s:8:\"Articles\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"90\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6e60000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:91;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:18:\"/Aiko/de/Impressum\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:18:\"/Aiko/de/Impressum\";s:9:\"\0*\0_label\";s:9:\"impressum\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"91\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b6900000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:92;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:20:\"/Aiko/de/Datenschutz\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:20:\"/Aiko/de/Datenschutz\";s:9:\"\0*\0_label\";s:11:\"datenschutz\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:2:\"92\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:0:\"\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}s:32:\"000000000411b68a0000000058902017\";O:32:\"Pimcore\\Navigation\\Page\\Document\":25:{s:13:\"\0*\0_accesskey\";s:0:\"\";s:12:\"\0*\0_tabindex\";s:0:\"\";s:12:\"\0*\0_relation\";s:0:\"\";s:14:\"\0*\0_documentId\";i:200;s:15:\"\0*\0documentType\";s:4:\"page\";s:15:\"\0*\0realFullPath\";s:14:\"/Aiko/de/error\";s:17:\"\0*\0customSettings\";a:0:{}s:7:\"\0*\0_uri\";s:14:\"/Aiko/de/error\";s:9:\"\0*\0_label\";s:5:\"error\";s:12:\"\0*\0_fragment\";N;s:6:\"\0*\0_id\";s:3:\"200\";s:9:\"\0*\0_class\";s:5:\" main\";s:9:\"\0*\0_title\";s:3:\"404\";s:10:\"\0*\0_target\";N;s:7:\"\0*\0_rel\";a:0:{}s:7:\"\0*\0_rev\";a:0:{}s:9:\"\0*\0_order\";N;s:10:\"\0*\0_active\";b:0;s:11:\"\0*\0_visible\";b:0;s:10:\"\0*\0_parent\";r:1;s:14:\"\0*\0_properties\";a:0:{}s:21:\"\0*\0_customHtmlAttribs\";a:0:{}s:9:\"\0*\0_pages\";a:0:{}s:9:\"\0*\0_index\";a:0:{}s:14:\"\0*\0_dirtyIndex\";b:0;}}s:9:\"\0*\0_index\";a:11:{s:32:\"000000000411b7d70000000058902017\";N;s:32:\"000000000411b6430000000058902017\";N;s:32:\"000000000411b6680000000058902017\";N;s:32:\"000000000411b6040000000058902017\";N;s:32:\"000000000411b60f0000000058902017\";N;s:32:\"000000000411b6300000000058902017\";N;s:32:\"000000000411b6d20000000058902017\";N;s:32:\"000000000411b6cc0000000058902017\";N;s:32:\"000000000411b6e60000000058902017\";N;s:32:\"000000000411b6900000000058902017\";N;s:32:\"000000000411b68a0000000058902017\";N;}s:14:\"\0*\0_dirtyIndex\";b:1;}\";', 1777710823, 1775291623)
    ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime);

SELECT 
  * 
FROM 
  documents_elements 
WHERE 
  documentId = ?

SELECT * FROM documents_elements WHERE documentId = 1097;

SELECT 
  id 
FROM 
  documents 
WHERE 
  parentId = ? 
  AND published = 1 
LIMIT 
  1

SELECT id FROM documents WHERE parentId = 86 AND published = 1 LIMIT 1;

SELECT 
  `documents`.`id`, 
  `documents`.`type` 
FROM 
  `documents` 
WHERE 
  (
    (parentId = ?) 
    AND published = 1
  ) 
ORDER BY 
  `index` ASC

SELECT `documents`.`id`, `documents`.`type` FROM `documents` WHERE ( (parentId = 86) AND published = 1) ORDER BY `index` ASC;

SELECT 
  assets.*, 
  tree_locks.locked 
FROM 
  assets 
  LEFT JOIN tree_locks ON assets.id = tree_locks.id 
  AND tree_locks.type = 'asset' 
WHERE 
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 1443;

"COMMIT"

"COMMIT";

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

SELECT id FROM documents WHERE path = '/Aiko/de/' AND `key` = 'Über uns';

SELECT 
  * 
FROM 
  object_url_slugs 
WHERE 
  slug = '/Aiko/de/Über uns' 
  AND (
    siteId = 0 
    OR siteId = 0
  ) 
ORDER BY 
  siteId DESC 
LIMIT 
  1

SELECT * FROM object_url_slugs WHERE slug = '/Aiko/de/Über uns' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

DELETE FROM 
  cache_tags 
WHERE 
  id = ? 
  AND tag NOT IN (?)

DELETE FROM cache_tags WHERE id = 'nav_e0599d72ef0a9269a7ca63baed6a221f' AND tag NOT IN ('output', 'navigation');

INSERT INTO cache_tags (id, tag) 
VALUES 
  (?, ?) ON DUPLICATE KEY 
UPDATE 
  tag = 
VALUES 
  (tag)

INSERT INTO cache_tags (id, tag) VALUES ('nav_e0599d72ef0a9269a7ca63baed6a221f', 'output') ON DUPLICATE KEY UPDATE tag = VALUES(tag);

SELECT 
  object_EF_OSTC.o_id as o_id, 
  `object_EF_OSTC`.`o_type` 
FROM 
  `object_EF_OSTC` 
WHERE 
  (
    (
      (o_key LIKE ?) 
      AND object_EF_OSTC.o_type IN ('object', 'folder')
    ) 
    AND object_EF_OSTC.o_published = 1
  )

SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (((o_key LIKE '')  AND  object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1);

"START TRANSACTION"

"START TRANSACTION";

SELECT 
  id 
FROM 
  sites 
ORDER BY 
  (
    SELECT 
      LENGTH(path) 
    FROM 
      documents 
    WHERE 
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC ;

SELECT 
  object_EF_OSTC.o_id as o_id, 
  `object_EF_OSTC`.`o_type` 
FROM 
  `object_EF_OSTC` 
WHERE 
  (
    (
      (o_key LIKE ?) 
      AND object_EF_OSTC.o_type IN ('object', 'folder')
    ) 
    AND object_EF_OSTC.o_published = 1
  ) 
LIMIT 
  1

SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (((o_key LIKE '')  AND  object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1) LIMIT 1;

SELECT 
  object_EF_OSTC.o_id as o_id, 
  `object_EF_OSTC`.`o_type` 
FROM 
  `object_EF_OSTC` 
WHERE 
  (
    (
      object_EF_OSTC.o_type IN ('object', 'folder')
    ) 
    AND object_EF_OSTC.o_published = 1
  )

SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (( object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1);