Symfony Profiler

Query Metrics

131 Database Queries

48 Different statements

26.51 ms Query time

0 Invalid entities

0 Managed entities

Queries


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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 > ? 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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT id FROM targeting_rules WHERE active = 1  ORDER BY `prio` ASC
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM documents_editables WHERE documentId = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT * FROM targeting_target_groups WHERE id = ?
SELECT * FROM targeting_target_groups WHERE id = ?
SELECT * FROM targeting_target_groups WHERE id = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
"START TRANSACTION"
INSERT INTO objects (`key`, `path`) VALUES (?, ?)
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
SELECT MAX(versionCount) FROM versions WHERE cid = ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SHOW COLUMNS FROM objects
SELECT type,classId,className FROM objects WHERE id = ?
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ?
DELETE FROM tree_locks WHERE id = ? AND type = ?
SELECT * FROM object_relations_DOCA WHERE src_id = ?
INSERT INTO object_relations_DOCA (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO object_store_DOCA (`oo_id`, `TypeDocument`, `dateDocument`, `confiance`, `jsonExtraction`, `recommandations`, `resume`) VALUES (?, ?, ?, ?, ?, ?, ?)
SELECT * FROM object_query_DOCA WHERE oo_id = ?
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SHOW COLUMNS FROM object_query_DOCA
INSERT INTO object_query_DOCA (`TypeDocument`, `dateDocument`, `asset__id`, `asset__type`, `confiance`, `jsonExtraction`, `recommandations`, `resume`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
DELETE FROM schedule_tasks WHERE `cid` = 1379 AND `ctype` = 'object'
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
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 > ? 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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,1228) AND inheritable = 1)
                         OR cid = ? ) 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SHOW COLUMNS FROM versions
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 > ? 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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
DELETE FROM cache_items WHERE item_id IN (?, ?)
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?)
"START TRANSACTION"
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	0.84 ms	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 (?) Parameters: [`1765812837 "site_domain_cf04c2a2011e3966b8ddb91e1f38480f"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_cf04c2a2011e3966b8ddb91e1f38480f');
2	0.21 ms	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 (?, ?) Parameters: [`1765812837 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.27 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
4	0.22 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
5	0.35 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/en/upload/new/467" "path" "auto_create" "/en/upload/new/467" "path_query" "https://plateform.lab.fortesting2.fr/en/upload/new/467" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/en/upload/new/467' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/upload/new/467' AND `type` = 'path_query') OR (source = 'https://plateform.lab.fortesting2.fr/en/upload/new/467' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
6	0.21 ms	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 (?) Parameters: [`1765812837 "system_route_redirect"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
7	0.23 ms	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 (?, ?, ?) Parameters: [`1765812837 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
8	0.19 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
9	0.18 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
10	0.40 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/upload/new/" "467"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/en/upload/new/' AND `key` = BINARY '467';
11	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/upload/new/467"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/upload/new/467';
12	0.16 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/upload/" "new"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/en/upload/' AND `key` = BINARY 'new';
13	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/upload/new"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/upload/new';
14	0.13 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "upload"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/en/' AND `key` = BINARY 'upload';
15	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/upload"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/upload';
16	0.10 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "en"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'en';
17	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en';
18	0.11 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';
19	0.18 ms	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 (?) Parameters: [`1765812837 "document_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
20	0.18 ms	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 (?) Parameters: [`1765812837 "document_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
21	0.17 ms	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 (?) Parameters: [`1765812837 "document_properties_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1');
22	0.18 ms	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 (?, ?) Parameters: [`1765812837 "document_properties\x01tags\x01" "document_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_1tags');
23	0.24 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
24	0.23 ms	SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC;
25	0.16 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 1;
26	0.17 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 2;
27	0.15 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 3;
28	0.31 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 4;
29	0.15 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 6;
30	0.19 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 7;
31	0.16 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 8;
32	0.15 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 9;
33	0.13 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 10;
34	0.22 ms	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 (?) Parameters: [`1765812837 "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
35	0.19 ms	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 (?) Parameters: [`1765812837 "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
36	0.18 ms	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 (?) Parameters: [`1765812837 "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
37	0.18 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Customer Management/segments/calculated/Interest-Target-Groups/" "Sports-Cars-Fan"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Customer Management/segments/calculated/Interest-Target-Groups/' AND `key` = BINARY 'Sports-Cars-Fan';
38	0.13 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Customer Management/segments/calculated/VisitingCount/" "at least once"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Customer Management/segments/calculated/VisitingCount/' AND `key` = BINARY 'at least once';
39	0.12 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Customer Management/segments/calculated/VisitingCount/" "at least once"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Customer Management/segments/calculated/VisitingCount/' AND `key` = BINARY 'at least once';
40	0.15 ms	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 (?) Parameters: [`1765812837 "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
41	0.12 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Customer Management/segments/calculated/VisitingCount/" "at least once"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Customer Management/segments/calculated/VisitingCount/' AND `key` = BINARY 'at least once';
42	0.13 ms	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 (?) Parameters: [`1765812837 "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
43	0.12 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Customer Management/segments/calculated/VisitingCount/" "at least once"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Customer Management/segments/calculated/VisitingCount/' AND `key` = BINARY 'at least once';
44	0.17 ms	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 (?) Parameters: [`1765812837 "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1"`] View formatted query View runnable query Explain query 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 > 1765812837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
45	0.41 ms	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 (?) Parameters: [`1765812840 "document_target_groups_1"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_target_groups_1');
46	0.17 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00document_target_groups_1"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_1');
47	0.49 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1;
48	0.26 ms	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 (?) Parameters: [`1765812840 "object_58"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_58');
49	0.15 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_58"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_58');
50	0.17 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`58`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 58;
51	0.17 ms	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 (?) Parameters: [`1765812840 "object_114"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_114');
52	0.12 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_114"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_114');
53	0.19 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`114`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 114;
54	0.14 ms	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 (?) Parameters: [`1765812840 "object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30');
55	0.13 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_30');
56	0.10 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30;
57	0.20 ms	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 (?) Parameters: [`1765812840 "object_58"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_58');
58	0.12 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_58"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_58');
59	0.10 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`58`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 58;
60	0.15 ms	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 (?) Parameters: [`1765812840 "object_110"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_110');
61	0.11 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_110"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_110');
62	0.09 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`110`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 110;
63	0.14 ms	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 (?) Parameters: [`1765812840 "object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30');
64	0.17 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_30');
65	0.09 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30;
66	0.11 ms	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 (?) Parameters: [`1765812840 "object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30');
67	0.15 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00object_30"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_30');
68	0.10 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30;
69	0.41 ms	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 (?) Parameters: [`1765812840 "document_33"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_33');
70	0.21 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00document_33"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_33');
71	0.30 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 33;
72	0.18 ms	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 (?) Parameters: [`1765812840 "document_35"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_35');
73	0.17 ms	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 (?) Parameters: [`1765812840 "\x00tags\x00document_35"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_35');
74	0.20 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 35;
75	0.22 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 4;
76	0.14 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 5;
77	0.15 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 6;
78	0.35 ms	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 (?) Parameters: [`1765812840 "asset_467"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_467');
79	0.19 ms	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 (?) Parameters: [`1765812840 "asset_467\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_467tags');
80	0.43 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"DOCA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'DOCA';
81	0.36 ms	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 (?) Parameters: [`1765812850 "object_1228"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1228');
82	0.22 ms	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 (?) Parameters: [`1765812850 "object_1228\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1228tags');
83	0.16 ms	SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ? Parameters: [`1228`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, `key`) as `path` FROM objects WHERE id = ? SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 1228;
84	0.14 ms	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Analyses/" "doc_analyse_69402a6b05678"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Analyses/' AND `key` = BINARY 'doc_analyse_69402a6b05678';
85	0.07 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
86	0.24 ms	INSERT INTO objects (`key`, `path`) VALUES (?, ?) Parameters: [`"doc_analyse_69402a6b05678" "/Analyses/"`] View formatted query View runnable query Explain query INSERT INTO objects (`key`, `path`) VALUES (?, ?) INSERT INTO objects (`key`, `path`) VALUES ('doc_analyse_69402a6b05678', '/Analyses/');
87	0.12 ms	SELECT versionCount FROM objects WHERE id = ? FOR UPDATE Parameters: [`1379`] View formatted query View runnable query Explain query SELECT versionCount FROM objects WHERE id = ? FOR UPDATE SELECT versionCount FROM objects WHERE id = 1379 FOR UPDATE;
88	0.19 ms	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' Parameters: [`1379`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' SELECT MAX(versionCount) FROM versions WHERE cid = 1379 AND ctype = 'object';
89	0.14 ms	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 (?) Parameters: [`1765812850 "system_resource_columns_objects"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_objects');
90	0.11 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00system_resource_columns_objects"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_objects');
91	0.48 ms	SHOW COLUMNS FROM objects Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM objects SHOW COLUMNS FROM objects;
92	0.13 ms	SELECT type,classId,className FROM objects WHERE id = ? Parameters: [`1379`] View formatted query View runnable query Explain query SELECT type, classId, className FROM objects WHERE id = ? SELECT type,classId,className FROM objects WHERE id = 1379;
93	0.66 ms	INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"/Analyses/" 1379 1765812850 1765812850 1 0 0 1228 "object" "doc_analyse_69402a6b05678" 0 null null "DOCA" 1 "DocumentAnalyse"`] View formatted query View runnable query Explain query 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 ('/Analyses/', 1379, 1765812850, 1765812850, 1, 0, 0, 1228, 'object', 'doc_analyse_69402a6b05678', 0, NULL, NULL, 'DOCA', 1, 'DocumentAnalyse');
94	0.29 ms	UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ? Parameters: [`"/Analyses/" 1379 1765812850 1765812850 1 0 0 1228 "object" "doc_analyse_69402a6b05678" 0 null null "DOCA" 1 "DocumentAnalyse" 1379`] View formatted query View runnable query Explain query 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` = '/Analyses/', `id` = 1379, `creationDate` = 1765812850, `modificationDate` = 1765812850, `versionCount` = 1, `userOwner` = 0, `userModification` = 0, `parentId` = 1228, `type` = 'object', `key` = 'doc_analyse_69402a6b05678', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'DOCA', `published` = 1, `className` = 'DocumentAnalyse' WHERE `id` = 1379;
95	0.14 ms	DELETE FROM tree_locks WHERE id = ? AND type = ? Parameters: [`1379 "object"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND type = ? DELETE FROM tree_locks WHERE id = 1379 AND type = 'object';
96	0.14 ms	SELECT * FROM object_relations_DOCA WHERE src_id = ? Parameters: [`1379`] View formatted query View runnable query Explain query SELECT * FROM object_relations_DOCA WHERE src_id = ? SELECT * FROM object_relations_DOCA WHERE src_id = 1379;
97	0.12 ms	INSERT INTO object_relations_DOCA (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`467 "asset" "asset" 1379 "object" "" "0"`] View formatted query View runnable query Explain query INSERT INTO object_relations_DOCA ( `dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position` ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO object_relations_DOCA (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (467, 'asset', 'asset', 1379, 'object', '', '0');
98	0.24 ms	INSERT INTO object_store_DOCA (`oo_id`, `TypeDocument`, `dateDocument`, `confiance`, `jsonExtraction`, `recommandations`, `resume`) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [1379 "ordonnance" "2025-12-11" 92.0 """ {\n "type_document": "cantine",\n "confiance": 92,\n "texte_complet": "Docteur Anamaria Marin\nMédecine Générale\nN° RPPS\nN° AM\n10100872141\n851038539\n18 Grande Rue\n85300 Le Perrier\nTél. 02 51 60 63 30\nLe 11 12 2025\nSwan BERNARD\nHEC Pom nas\/cut T\/25g Non remboursable\n1 application matin et soir pendant 7 jours si epistaxis\nHELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\/125ml\n1 ca S 4 a5 fois par jour pdt 5 jours\nNASONEX 50 μg Susp pulv nas Fl\/140doses\n1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\nDOLIPRANE 1000 mg Gél Plq\/8\n1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\n01 Di\nMARIN 10\/0872141 Anamaria PERRIER\nPHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\nCIE\n51\n68\nINS 101 signée\nN.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\/06\/2010 - S:M - INS : 1 10 06 39 300 106 67\nconsultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\n4",\n "lignes": [\n "Docteur Anamaria Marin",\n "Médecine Générale",\n "N° RPPS",\n "N° AM",\n "10100872141",\n "851038539",\n "18 Grande Rue",\n "85300 Le Perrier",\n "Tél. 02 51 60 63 30",\n "Le 11 12 2025",\n "Swan BERNARD",\n "HEC Pom nas\/cut T\/25g Non remboursable",\n "1 application matin et soir pendant 7 jours si epistaxis",\n "HELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\/125ml",\n "1 ca S 4 a5 fois par jour pdt 5 jours",\n "NASONEX 50 μg Susp pulv nas Fl\/140doses",\n "1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours",\n "DOLIPRANE 1000 mg Gél Plq\/8",\n "1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours",\n "01 Di",\n "MARIN 10\/0872141 Anamaria PERRIER",\n "PHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816",\n "CIE",\n "51",\n "68",\n "INS 101 signée",\n "N.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\/06\/2010 - S:M - INS : 1 10 06 39 300 106 67",\n "consultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30",\n "4"\n ],\n "metadata": {\n "nombre_lignes": 29,\n "nombre_mots": 136,\n "fichier_source": "img_20251211_133527_1.jpg"\n },\n "details": {\n "dates_trouvees": [\n "26\/06\/2010",\n "02.51.60"\n ]\n }\n } """ null """ {\n "nom_document": "Ordonnance Dr Marin - Swan BERNARD - 11\/12\/2025",\n "type_document": "ordonnance",\n "confiance": 92,\n "date_document": "2025-12-11",\n "montant_ttc": null,\n "emetteur": "Docteur Anamaria Marin",\n "destinataire": "Swan BERNARD",\n "iban": null,\n "patient_concerne": "Swan BERNARD",\n "medecin": "Docteur Anamaria Marin - Médecine Générale",\n "pathologie": "Epistaxis (saignement de nez)",\n "medicaments": [\n {\n "nom": "HEC Pom nas\/cut T\/25g",\n "posologie": "1 application matin et soir",\n "duree": "7 jours si epistaxis"\n },\n {\n "nom": "HELICIDINE 10% Sirop sans sucre",\n "posologie": "1 cuillère à soupe 4 à 5 fois par jour",\n "duree": "5 jours"\n },\n {\n "nom": "NASONEX 50 μg Suspension pulvérisation nasale",\n "posologie": "1 pulvérisation (voie nasale) le matin, le midi et le soir",\n "duree": "5 jours"\n },\n {\n "nom": "DOLIPRANE 1000 mg Gélule",\n "posologie": "1 gélule (voie orale) 3 fois par jour pendant le repas",\n "duree": "3 jours"\n }\n ]\n } """] View formatted query View runnable query Explain query INSERT INTO object_store_DOCA ( `oo_id`, `TypeDocument`, `dateDocument`, `confiance`, `jsonExtraction`, `recommandations`, `resume` ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO object_store_DOCA (`oo_id`, `TypeDocument`, `dateDocument`, `confiance`, `jsonExtraction`, `recommandations`, `resume`) VALUES (1379, 'ordonnance', '2025-12-11', 92, '{ \"type_document\": \"cantine\", \"confiance\": 92, \"texte_complet\": \"Docteur Anamaria Marin\\nMédecine Générale\\nN° RPPS\\nN° AM\\n10100872141\\n851038539\\n18 Grande Rue\\n85300 Le Perrier\\nTél. 02 51 60 63 30\\nLe 11 12 2025\\nSwan BERNARD\\nHEC Pom nas\\/cut T\\/25g Non remboursable\\n1 application matin et soir pendant 7 jours si epistaxis\\nHELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\\/125ml\\n1 ca S 4 a5 fois par jour pdt 5 jours\\nNASONEX 50 μg Susp pulv nas Fl\\/140doses\\n1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\\nDOLIPRANE 1000 mg Gél Plq\\/8\\n1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\\n01 Di\\nMARIN 10\\/0872141 Anamaria PERRIER\\nPHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\\nCIE\\n51\\n68\\nINS 101 signée\\nN.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\\/06\\/2010 - S:M - INS : 1 10 06 39 300 106 67\\nconsultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\\n4\", \"lignes\": [ \"Docteur Anamaria Marin\", \"Médecine Générale\", \"N° RPPS\", \"N° AM\", \"10100872141\", \"851038539\", \"18 Grande Rue\", \"85300 Le Perrier\", \"Tél. 02 51 60 63 30\", \"Le 11 12 2025\", \"Swan BERNARD\", \"HEC Pom nas\\/cut T\\/25g Non remboursable\", \"1 application matin et soir pendant 7 jours si epistaxis\", \"HELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\\/125ml\", \"1 ca S 4 a5 fois par jour pdt 5 jours\", \"NASONEX 50 μg Susp pulv nas Fl\\/140doses\", \"1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\", \"DOLIPRANE 1000 mg Gél Plq\\/8\", \"1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\", \"01 Di\", \"MARIN 10\\/0872141 Anamaria PERRIER\", \"PHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\", \"CIE\", \"51\", \"68\", \"INS 101 signée\", \"N.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\\/06\\/2010 - S:M - INS : 1 10 06 39 300 106 67\", \"consultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\", \"4\" ], \"metadata\": { \"nombre_lignes\": 29, \"nombre_mots\": 136, \"fichier_source\": \"img_20251211_133527_1.jpg\" }, \"details\": { \"dates_trouvees\": [ \"26\\/06\\/2010\", \"02.51.60\" ] } }', NULL, '{ \"nom_document\": \"Ordonnance Dr Marin - Swan BERNARD - 11\\/12\\/2025\", \"type_document\": \"ordonnance\", \"confiance\": 92, \"date_document\": \"2025-12-11\", \"montant_ttc\": null, \"emetteur\": \"Docteur Anamaria Marin\", \"destinataire\": \"Swan BERNARD\", \"iban\": null, \"patient_concerne\": \"Swan BERNARD\", \"medecin\": \"Docteur Anamaria Marin - Médecine Générale\", \"pathologie\": \"Epistaxis (saignement de nez)\", \"medicaments\": [ { \"nom\": \"HEC Pom nas\\/cut T\\/25g\", \"posologie\": \"1 application matin et soir\", \"duree\": \"7 jours si epistaxis\" }, { \"nom\": \"HELICIDINE 10% Sirop sans sucre\", \"posologie\": \"1 cuillère à soupe 4 à 5 fois par jour\", \"duree\": \"5 jours\" }, { \"nom\": \"NASONEX 50 μg Suspension pulvérisation nasale\", \"posologie\": \"1 pulvérisation (voie nasale) le matin, le midi et le soir\", \"duree\": \"5 jours\" }, { \"nom\": \"DOLIPRANE 1000 mg Gélule\", \"posologie\": \"1 gélule (voie orale) 3 fois par jour pendant le repas\", \"duree\": \"3 jours\" } ] }');
99	0.13 ms	SELECT * FROM object_query_DOCA WHERE oo_id = ? Parameters: [`1379`] View formatted query View runnable query Explain query SELECT * FROM object_query_DOCA WHERE oo_id = ? SELECT * FROM object_query_DOCA WHERE oo_id = 1379;
100	0.11 ms	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 (?) Parameters: [`1765812850 "system_resource_columns_object_query_DOCA"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_object_query_DOCA');
101	0.13 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00system_resource_columns_object_query_DOCA"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_object_query_DOCA');
102	0.44 ms	SHOW COLUMNS FROM object_query_DOCA Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_query_DOCA SHOW COLUMNS FROM object_query_DOCA;
103	0.29 ms	INSERT INTO object_query_DOCA (`TypeDocument`, `dateDocument`, `asset__id`, `asset__type`, `confiance`, `jsonExtraction`, `recommandations`, `resume`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["ordonnance" "2025-12-11" 467 "asset" 92.0 """ {\n "type_document": "cantine",\n "confiance": 92,\n "texte_complet": "Docteur Anamaria Marin\nMédecine Générale\nN° RPPS\nN° AM\n10100872141\n851038539\n18 Grande Rue\n85300 Le Perrier\nTél. 02 51 60 63 30\nLe 11 12 2025\nSwan BERNARD\nHEC Pom nas\/cut T\/25g Non remboursable\n1 application matin et soir pendant 7 jours si epistaxis\nHELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\/125ml\n1 ca S 4 a5 fois par jour pdt 5 jours\nNASONEX 50 μg Susp pulv nas Fl\/140doses\n1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\nDOLIPRANE 1000 mg Gél Plq\/8\n1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\n01 Di\nMARIN 10\/0872141 Anamaria PERRIER\nPHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\nCIE\n51\n68\nINS 101 signée\nN.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\/06\/2010 - S:M - INS : 1 10 06 39 300 106 67\nconsultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\n4",\n "lignes": [\n "Docteur Anamaria Marin",\n "Médecine Générale",\n "N° RPPS",\n "N° AM",\n "10100872141",\n "851038539",\n "18 Grande Rue",\n "85300 Le Perrier",\n "Tél. 02 51 60 63 30",\n "Le 11 12 2025",\n "Swan BERNARD",\n "HEC Pom nas\/cut T\/25g Non remboursable",\n "1 application matin et soir pendant 7 jours si epistaxis",\n "HELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\/125ml",\n "1 ca S 4 a5 fois par jour pdt 5 jours",\n "NASONEX 50 μg Susp pulv nas Fl\/140doses",\n "1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours",\n "DOLIPRANE 1000 mg Gél Plq\/8",\n "1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours",\n "01 Di",\n "MARIN 10\/0872141 Anamaria PERRIER",\n "PHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816",\n "CIE",\n "51",\n "68",\n "INS 101 signée",\n "N.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\/06\/2010 - S:M - INS : 1 10 06 39 300 106 67",\n "consultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30",\n "4"\n ],\n "metadata": {\n "nombre_lignes": 29,\n "nombre_mots": 136,\n "fichier_source": "img_20251211_133527_1.jpg"\n },\n "details": {\n "dates_trouvees": [\n "26\/06\/2010",\n "02.51.60"\n ]\n }\n } """ null """ {\n "nom_document": "Ordonnance Dr Marin - Swan BERNARD - 11\/12\/2025",\n "type_document": "ordonnance",\n "confiance": 92,\n "date_document": "2025-12-11",\n "montant_ttc": null,\n "emetteur": "Docteur Anamaria Marin",\n "destinataire": "Swan BERNARD",\n "iban": null,\n "patient_concerne": "Swan BERNARD",\n "medecin": "Docteur Anamaria Marin - Médecine Générale",\n "pathologie": "Epistaxis (saignement de nez)",\n "medicaments": [\n {\n "nom": "HEC Pom nas\/cut T\/25g",\n "posologie": "1 application matin et soir",\n "duree": "7 jours si epistaxis"\n },\n {\n "nom": "HELICIDINE 10% Sirop sans sucre",\n "posologie": "1 cuillère à soupe 4 à 5 fois par jour",\n "duree": "5 jours"\n },\n {\n "nom": "NASONEX 50 μg Suspension pulvérisation nasale",\n "posologie": "1 pulvérisation (voie nasale) le matin, le midi et le soir",\n "duree": "5 jours"\n },\n {\n "nom": "DOLIPRANE 1000 mg Gélule",\n "posologie": "1 gélule (voie orale) 3 fois par jour pendant le repas",\n "duree": "3 jours"\n }\n ]\n } """ 1379] View formatted query View runnable query Explain query INSERT INTO object_query_DOCA ( `TypeDocument`, `dateDocument`, `asset__id`, `asset__type`, `confiance`, `jsonExtraction`, `recommandations`, `resume`, `oo_id` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO object_query_DOCA (`TypeDocument`, `dateDocument`, `asset__id`, `asset__type`, `confiance`, `jsonExtraction`, `recommandations`, `resume`, `oo_id`) VALUES ('ordonnance', '2025-12-11', 467, 'asset', 92, '{ \"type_document\": \"cantine\", \"confiance\": 92, \"texte_complet\": \"Docteur Anamaria Marin\\nMédecine Générale\\nN° RPPS\\nN° AM\\n10100872141\\n851038539\\n18 Grande Rue\\n85300 Le Perrier\\nTél. 02 51 60 63 30\\nLe 11 12 2025\\nSwan BERNARD\\nHEC Pom nas\\/cut T\\/25g Non remboursable\\n1 application matin et soir pendant 7 jours si epistaxis\\nHELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\\/125ml\\n1 ca S 4 a5 fois par jour pdt 5 jours\\nNASONEX 50 μg Susp pulv nas Fl\\/140doses\\n1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\\nDOLIPRANE 1000 mg Gél Plq\\/8\\n1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\\n01 Di\\nMARIN 10\\/0872141 Anamaria PERRIER\\nPHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\\nCIE\\n51\\n68\\nINS 101 signée\\nN.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\\/06\\/2010 - S:M - INS : 1 10 06 39 300 106 67\\nconsultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\\n4\", \"lignes\": [ \"Docteur Anamaria Marin\", \"Médecine Générale\", \"N° RPPS\", \"N° AM\", \"10100872141\", \"851038539\", \"18 Grande Rue\", \"85300 Le Perrier\", \"Tél. 02 51 60 63 30\", \"Le 11 12 2025\", \"Swan BERNARD\", \"HEC Pom nas\\/cut T\\/25g Non remboursable\", \"1 application matin et soir pendant 7 jours si epistaxis\", \"HELICIDINE 10 % Sirop sans sucre édulcoré à la saccharine sodique et maltitol FI PE\\/125ml\", \"1 ca S 4 a5 fois par jour pdt 5 jours\", \"NASONEX 50 μg Susp pulv nas Fl\\/140doses\", \"1 pulvérisation (voie nasale) le matin, le midi et le soir pendant 5 jours\", \"DOLIPRANE 1000 mg Gél Plq\\/8\", \"1 gélule (voie orale) 3 fois par jour pendant le repas, pendant 3 jours\", \"01 Di\", \"MARIN 10\\/0872141 Anamaria PERRIER\", \"PHARMA DHANE Y S5300 T31. T. CAP OCEAN CHALLANS 02 2107 Docteurs x en 10 652006816\", \"CIE\", \"51\", \"68\", \"INS 101 signée\", \"N.Nais. (NIR) : BERNARD - Pr. 1 : SWAN DDN : 26\\/06\\/2010 - S:M - INS : 1 10 06 39 300 106 67\", \"consultation sur RDV de 8h00~19h00 - tel 02.51.60.63.30\", \"4\" ], \"metadata\": { \"nombre_lignes\": 29, \"nombre_mots\": 136, \"fichier_source\": \"img_20251211_133527_1.jpg\" }, \"details\": { \"dates_trouvees\": [ \"26\\/06\\/2010\", \"02.51.60\" ] } }', NULL, '{ \"nom_document\": \"Ordonnance Dr Marin - Swan BERNARD - 11\\/12\\/2025\", \"type_document\": \"ordonnance\", \"confiance\": 92, \"date_document\": \"2025-12-11\", \"montant_ttc\": null, \"emetteur\": \"Docteur Anamaria Marin\", \"destinataire\": \"Swan BERNARD\", \"iban\": null, \"patient_concerne\": \"Swan BERNARD\", \"medecin\": \"Docteur Anamaria Marin - Médecine Générale\", \"pathologie\": \"Epistaxis (saignement de nez)\", \"medicaments\": [ { \"nom\": \"HEC Pom nas\\/cut T\\/25g\", \"posologie\": \"1 application matin et soir\", \"duree\": \"7 jours si epistaxis\" }, { \"nom\": \"HELICIDINE 10% Sirop sans sucre\", \"posologie\": \"1 cuillère à soupe 4 à 5 fois par jour\", \"duree\": \"5 jours\" }, { \"nom\": \"NASONEX 50 μg Suspension pulvérisation nasale\", \"posologie\": \"1 pulvérisation (voie nasale) le matin, le midi et le soir\", \"duree\": \"5 jours\" }, { \"nom\": \"DOLIPRANE 1000 mg Gélule\", \"posologie\": \"1 gélule (voie orale) 3 fois par jour pendant le repas\", \"duree\": \"3 jours\" } ] }', 1379);
104	0.16 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`1379 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 1379 AND `ctype` = 'object' ;
105	0.11 ms	DELETE FROM schedule_tasks WHERE `cid` = 1379 AND `ctype` = 'object' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = 1379 AND `ctype` = 'object' DELETE FROM schedule_tasks WHERE `cid` = 1379 AND `ctype` = 'object';
106	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"system_settings" "pimcore_system_settings"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'system_settings' AND scope = 'pimcore_system_settings';
107	0.22 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 0`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 0;
108	0.15 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 0;
109	0.13 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 0;
110	0.13 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 0;
111	0.13 ms	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 (?) Parameters: [`1765812850 "object_properties_1379"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_properties_1379');
112	0.11 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00object_properties_1379"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_properties_1379');
113	0.12 ms	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 (?) Parameters: [`1765812850 "object_1"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1');
114	0.13 ms	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 (?) Parameters: [`1765812850 "object_1\x01tags\x01"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1tags');
115	0.17 ms	SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,1228) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`1379`] View formatted query View runnable query Explain query SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 1228) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,1228) AND inheritable = 1) OR cid = 1379 ) AND ctype='object';
116	0.15 ms	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 (?) Parameters: [`1765812850 "system_resource_columns_versions"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_versions');
117	0.11 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00system_resource_columns_versions"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_versions');
118	0.46 ms	SHOW COLUMNS FROM versions Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM versions SHOW COLUMNS FROM versions;
119	0.25 ms	INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [null 1379 "object" 0 "" 1765812850 0 1 """ #0 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\Model\Version->save()\n #1 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\Model\DataObject\Concrete->saveVersion()\n #3 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\Model\DataObject\Concrete->update()\n #4 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\Model\DataObject\AbstractObject->save()\n #5 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/src/Controller/UploadController.php(748): Pimcore\Model\DataObject\Concrete->save()\n #6 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\UploadController->newAction()\n #7 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #8 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #9 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #10 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/public/index.php(20): require_once('...')\n #12 {main} """ 1 null null 0 "fs"] View formatted query View runnable query Explain query INSERT INTO versions ( `id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 1379, 'object', 0, '', 1765812850, 0, 1, '#0 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save() #1 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion() #2 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\\Model\\DataObject\\Concrete->saveVersion() #3 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\\Model\\DataObject\\Concrete->update() #4 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\\Model\\DataObject\\AbstractObject->save() #5 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/src/Controller/UploadController.php(748): Pimcore\\Model\\DataObject\\Concrete->save() #6 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(181): App\\Controller\\UploadController->newAction() #7 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() #8 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle() #9 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle() #10 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run() #11 /var/www/vhosts/plateform.lab.fortesting2.fr/httpdocs/public/index.php(20): require_once(\'...\') #12 {main}', 1, NULL, NULL, 0, 'fs');
120	0.76 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
121	0.15 ms	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 (?) Parameters: [`1765812850 "system_cache_write_lock"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
122	0.12 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00system_cache_write_lock"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
123	0.12 ms	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 (?) Parameters: [`1765812850 "system_cache_write_lock"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_cache_write_lock');
124	0.10 ms	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 (?) Parameters: [`1765812850 "\x00tags\x00system_cache_write_lock"`] View formatted query View runnable query Explain query 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 > 1765812850 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_cache_write_lock');
125	0.49 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 30 3 => 1765812850 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"\t‡\x02\x07À\x1E";i:1765812850;}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (30, 1765812850, 'system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A2209870207C01E223B693A313736353831323835303B7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
126	0.16 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"object_1379\x01tags\x01" "object_properties\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('object_1379tags', 'object_propertiestags');
127	0.21 ms	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"object" 1379`] View formatted query View runnable query Explain query SELECT id, targetType, targetId FROM dependencies WHERE sourceType = ? AND sourceId = ? SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 1379;
128	0.35 ms	INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (?, ?, ?, ?) Parameters: [`1379 "object" 467 "asset"`] View formatted query View runnable query Explain query INSERT INTO dependencies ( sourceid, sourcetype, targetid, targettype ) VALUES (?, ?, ?, ?) INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (1379, 'object', 467, 'asset');
129	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
130	0.19 ms	INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) Parameters: ["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:1379;}}" "[]" "pimcore_search_backend_message" "2025-12-15 15:34:10" "2025-12-15 15:34:10"] View formatted query View runnable query Explain query 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:1379;}}', '[]', 'pimcore_search_backend_message', '2025-12-15 15:34:10', '2025-12-15 15:34:10');
131	0.35 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

pimcore entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://plateform.lab.fortesting2.fr/en/upload/new/467

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

pimcore entity manager

Entities Mapping