Symfony Profiler

Query Metrics

153 Database Queries

43 Different statements

40.67 ms Query time

0 Invalid 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 tmp_store WHERE id = ?
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 * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE modificationDate >= 1577889604 AND product_type = 'simple' AND SKU IN ('2600.070', '2600.055', '2600.012', '2600.067', '2174.156', '2174.157', '2174.158', '2174.159', '2174.160', '3020.055', '3020.056', '3020.057', '3020.058', '3020.059', '3010.001', '3010.002', '3500.030', '3500.010') AND  object_3.type IN ('object','variant','folder') ORDER BY `SKU` ASC   LIMIT 200
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 objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 WHERE oo_id = ?
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 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 object_relations_3 WHERE src_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 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 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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 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 (?, ?)
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 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 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 object_relations_3 WHERE src_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 objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 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 (?, ?)
SELECT * FROM object_relations_3 WHERE src_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 objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 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 (?, ?)
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 object_relations_3 WHERE src_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 objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 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 (?, ?)
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 * FROM object_relations_3 WHERE src_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 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 objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 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 (?, ?)
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 object_relations_3 WHERE src_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 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 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 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 assets WHERE `path` = BINARY ? AND `filename` = 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 id FROM assets WHERE `path` = BINARY ? AND `filename` = 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 id FROM assets WHERE `path` = BINARY ? AND `filename` = 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 assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ?
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
"START TRANSACTION"
SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ?
SELECT versionCount FROM assets WHERE id = ? FOR UPDATE
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset'
UPDATE assets SET customSettings = ? WHERE id = ?
SELECT CONCAT(`path`,filename) as `path` FROM assets 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 * FROM properties WHERE
                             (
                                 (cid IN (1,559,320) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
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 assets_metadata WHERE cid = ? LIMIT 1
INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ?
DELETE FROM tree_locks WHERE id = ? AND type = ?
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
DELETE FROM schedule_tasks WHERE `cid` = '51934' AND `ctype` = 'asset'
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 IFNULL(binaryFileId, id) FROM versions WHERE binaryFileHash = ? AND cid = ? AND storageType = ? ORDER BY id ASC LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
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 (?, ?)
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 (?, ?)
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)

#▲	Time	Info
1	0.46 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: [`1781016004 "\x01tags\x01site_domain_5697fdaa597cea67f1e131aac3a6b701" "site_domain_5697fdaa597cea67f1e131aac3a6b701"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssite_domain_5697fdaa597cea67f1e131aac3a6b701', 'site_domain_5697fdaa597cea67f1e131aac3a6b701');
2	0.24 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: [`1781016004 "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.22 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';
4	0.10 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/api/magento/" "import"`] 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 '/api/magento/' AND `key` = BINARY 'import';
5	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/api/magento/import"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/api/magento/import';
6	0.07 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/api/" "magento"`] 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 '/api/' AND `key` = BINARY 'magento';
7	0.07 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/api/magento"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/api/magento';
8	0.07 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "api"`] 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 'api';
9	0.07 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/api';
10	0.06 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 '';
11	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: [`1781016004 "\x01tags\x01document_1" "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_1', 'document_1');
12	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: [`1781016004 "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
13	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: [`1781016004 "\x01tags\x01document_properties_1" "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_properties_1', 'document_properties_1');
14	0.08 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = 1 ) AND ctype='document';
15	1.54 ms	SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE modificationDate >= 1577889604 AND product_type = 'simple' AND SKU IN ('2600.070', '2600.055', '2600.012', '2600.067', '2174.156', '2174.157', '2174.158', '2174.159', '2174.160', '3020.055', '3020.056', '3020.057', '3020.058', '3020.059', '3010.001', '3010.002', '3500.030', '3500.010') AND object_3.type IN ('object','variant','folder') ORDER BY `SKU` ASC LIMIT 200 Parameters: [] View formatted query View runnable query Explain query SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE modificationDate >= 1577889604 AND product_type = 'simple' AND SKU IN ( '2600.070', '2600.055', '2600.012', '2600.067', '2174.156', '2174.157', '2174.158', '2174.159', '2174.160', '3020.055', '3020.056', '3020.057', '3020.058', '3020.059', '3010.001', '3010.002', '3500.030', '3500.010' ) AND object_3.type IN ('object', 'variant', 'folder') ORDER BY `SKU` ASC LIMIT 200 SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE modificationDate >= 1577889604 AND product_type = 'simple' AND SKU IN ('2600.070', '2600.055', '2600.012', '2600.067', '2174.156', '2174.157', '2174.158', '2174.159', '2174.160', '3020.055', '3020.056', '3020.057', '3020.058', '3020.059', '3010.001', '3010.002', '3500.030', '3500.010') AND object_3.type IN ('object','variant','folder') ORDER BY `SKU` ASC LIMIT 200;
16	0.27 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: [`1781016004 "\x01tags\x01object_34867" "object_34867"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34867', 'object_34867');
17	0.25 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: [`1781016004 "object_34867\x01tags\x01" "class_3\x01tags\x01" "asset_570\x01tags\x01" "asset_38047\x01tags\x01" "asset_38048\x01tags\x01" "asset_38046\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34867tags', 'class_3tags', 'asset_570tags', 'asset_38047tags', 'asset_38048tags', 'asset_38046tags');
18	0.16 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`34867`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 34867;
19	0.29 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`34867`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 34867;
20	0.46 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`34867`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 34867;
21	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '3';
22	0.30 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: [`1781016004 "\x01tags\x01asset_570" "asset_570"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_570', 'asset_570');
23	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: [`1781016004 "\x01tags\x01asset_38047" "asset_38047"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_38047', 'asset_38047');
24	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: [`1781016004 "\x01tags\x01asset_38048" "asset_38048"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_38048', 'asset_38048');
25	0.24 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: [`1781016004 "\x01tags\x01asset_38046" "asset_38046"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_38046', 'asset_38046');
26	0.42 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`34867`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 34867;
27	0.30 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: [`1781016004 "\x01tags\x01object_34868" "object_34868"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34868', 'object_34868');
28	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: [`1781016004 "object_34868\x01tags\x01" "class_3\x01tags\x01" "asset_571\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34868tags', 'class_3tags', 'asset_571tags');
29	0.24 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: [`1781016004 "\x01tags\x01object_34869" "object_34869"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34869', 'object_34869');
30	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: [`1781016004 "object_34869\x01tags\x01" "class_3\x01tags\x01" "asset_572\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34869tags', 'class_3tags', 'asset_572tags');
31	0.25 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: [`1781016004 "\x01tags\x01object_34870" "object_34870"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34870', 'object_34870');
32	0.27 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: [`1781016004 "object_34870\x01tags\x01" "class_3\x01tags\x01" "asset_573\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34870tags', 'class_3tags', 'asset_573tags');
33	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: [`1781016004 "\x01tags\x01object_34871" "object_34871"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34871', 'object_34871');
34	0.32 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: [`1781016004 "object_34871\x01tags\x01" "class_3\x01tags\x01" "asset_591\x01tags\x01" "asset_38050\x01tags\x01" "asset_38051\x01tags\x01" "asset_38049\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34871tags', 'class_3tags', 'asset_591tags', 'asset_38050tags', 'asset_38051tags', 'asset_38049tags');
35	0.24 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: [`1781016004 "\x01tags\x01object_30865" "object_30865"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_30865', 'object_30865');
36	0.30 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: [`1781016004 "object_30865\x01tags\x01" "class_3\x01tags\x01" "asset_592\x01tags\x01" "asset_598\x01tags\x01" "asset_599\x01tags\x01" "asset_593\x01tags\x01" "asset_594\x01tags\x01" "asset_595\x01tags\x01" "asset_596\x01tags\x01" "asset_40042\x01tags\x01" "asset_40043\x01tags\x01" "asset_40044\x01tags\x01" "asset_40045\x01tags\x01" "asset_40046\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30865tags', 'class_3tags', 'asset_592tags', 'asset_598tags', 'asset_599tags', 'asset_593tags', 'asset_594tags', 'asset_595tags', 'asset_596tags', 'asset_40042tags', 'asset_40043tags', 'asset_40044tags', 'asset_40045tags', 'asset_40046tags');
37	0.18 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30865`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30865;
38	0.23 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`30865`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 30865;
39	0.43 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`30865`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 30865;
40	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: [`1781016004 "\x01tags\x01asset_592" "asset_592"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_592', 'asset_592');
41	0.25 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: [`1781016004 "\x01tags\x01asset_598" "asset_598"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_598', 'asset_598');
42	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: [`1781016004 "\x01tags\x01asset_599" "asset_599"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_599', 'asset_599');
43	0.24 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: [`1781016004 "\x01tags\x01asset_593" "asset_593"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_593', 'asset_593');
44	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: [`1781016004 "\x01tags\x01asset_594" "asset_594"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_594', 'asset_594');
45	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: [`1781016004 "\x01tags\x01asset_595" "asset_595"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_595', 'asset_595');
46	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: [`1781016004 "\x01tags\x01asset_596" "asset_596"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_596', 'asset_596');
47	0.37 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: [`1781016004 "\x01tags\x01asset_40042" "asset_40042"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40042', 'asset_40042');
48	0.25 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: [`1781016004 "\x01tags\x01asset_40043" "asset_40043"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40043', 'asset_40043');
49	0.24 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: [`1781016004 "\x01tags\x01asset_40044" "asset_40044"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40044', 'asset_40044');
50	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: [`1781016004 "\x01tags\x01asset_40045" "asset_40045"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40045', 'asset_40045');
51	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: [`1781016004 "\x01tags\x01asset_40046" "asset_40046"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40046', 'asset_40046');
52	0.27 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`30865`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 30865;
53	0.27 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: [`1781016004 "\x01tags\x01object_30892" "object_30892"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_30892', 'object_30892');
54	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: [`1781016004 "object_30892\x01tags\x01" "class_3\x01tags\x01" "asset_40154\x01tags\x01" "asset_40155\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30892tags', 'class_3tags', 'asset_40154tags', 'asset_40155tags');
55	0.20 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30892`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30892;
56	0.22 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`30892`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 30892;
57	0.39 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`30892`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 30892;
58	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: [`1781016004 "\x01tags\x01asset_40154" "asset_40154"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40154', 'asset_40154');
59	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: [`1781016004 "\x01tags\x01asset_40155" "asset_40155"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40155', 'asset_40155');
60	0.21 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`30892`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 30892;
61	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: [`1781016004 "\x01tags\x01object_30901" "object_30901"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_30901', 'object_30901');
62	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: [`1781016004 "object_30901\x01tags\x01" "class_3\x01tags\x01" "asset_40193\x01tags\x01" "asset_40194\x01tags\x01" "asset_40195\x01tags\x01" "asset_40196\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30901tags', 'class_3tags', 'asset_40193tags', 'asset_40194tags', 'asset_40195tags', 'asset_40196tags');
63	0.16 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30901`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30901;
64	0.20 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`30901`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 30901;
65	0.38 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`30901`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 30901;
66	0.27 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: [`1781016004 "\x01tags\x01asset_40193" "asset_40193"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40193', 'asset_40193');
67	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: [`1781016004 "\x01tags\x01asset_40194" "asset_40194"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40194', 'asset_40194');
68	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: [`1781016004 "\x01tags\x01asset_40195" "asset_40195"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40195', 'asset_40195');
69	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: [`1781016004 "\x01tags\x01asset_40196" "asset_40196"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40196', 'asset_40196');
70	0.23 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`30901`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 30901;
71	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: [`1781016004 "\x01tags\x01object_30904" "object_30904"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_30904', 'object_30904');
72	0.25 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: [`1781016004 "object_30904\x01tags\x01" "class_3\x01tags\x01" "asset_578\x01tags\x01" "asset_579\x01tags\x01" "asset_580\x01tags\x01" "asset_40202\x01tags\x01" "asset_40203\x01tags\x01" "asset_40204\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_30904tags', 'class_3tags', 'asset_578tags', 'asset_579tags', 'asset_580tags', 'asset_40202tags', 'asset_40203tags', 'asset_40204tags');
73	0.16 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`30904`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 30904;
74	0.20 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`30904`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 30904;
75	0.38 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`30904`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 30904;
76	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: [`1781016004 "\x01tags\x01asset_578" "asset_578"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_578', 'asset_578');
77	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: [`1781016004 "\x01tags\x01asset_579" "asset_579"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_579', 'asset_579');
78	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: [`1781016004 "\x01tags\x01asset_580" "asset_580"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_580', 'asset_580');
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: [`1781016004 "\x01tags\x01asset_40202" "asset_40202"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40202', 'asset_40202');
80	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: [`1781016004 "\x01tags\x01asset_40203" "asset_40203"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40203', 'asset_40203');
81	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: [`1781016004 "\x01tags\x01asset_40204" "asset_40204"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40204', 'asset_40204');
82	0.24 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`30904`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 30904;
83	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: [`1781016004 "\x01tags\x01object_31068" "object_31068"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_31068', 'object_31068');
84	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: [`1781016004 "object_31068\x01tags\x01" "class_3\x01tags\x01" "asset_40796\x01tags\x01" "asset_40797\x01tags\x01" "asset_40798\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31068tags', 'class_3tags', 'asset_40796tags', 'asset_40797tags', 'asset_40798tags');
85	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: [`1781016004 "\x01tags\x01object_31069" "object_31069"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_31069', 'object_31069');
86	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: [`1781016004 "object_31069\x01tags\x01" "class_3\x01tags\x01" "asset_40800\x01tags\x01" "asset_40801\x01tags\x01" "asset_40802\x01tags\x01" "asset_40803\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31069tags', 'class_3tags', 'asset_40800tags', 'asset_40801tags', 'asset_40802tags', 'asset_40803tags');
87	1.94 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`31069`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 31069;
88	0.24 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`31069`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 31069;
89	0.41 ms	SELECT * FROM object_store_3 WHERE oo_id = ? Parameters: [`31069`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? SELECT * FROM object_store_3 WHERE oo_id = 31069;
90	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: [`1781016004 "\x01tags\x01asset_40800" "asset_40800"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40800', 'asset_40800');
91	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: [`1781016004 "\x01tags\x01asset_40801" "asset_40801"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40801', 'asset_40801');
92	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: [`1781016004 "\x01tags\x01asset_40802" "asset_40802"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40802', 'asset_40802');
93	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: [`1781016004 "\x01tags\x01asset_40803" "asset_40803"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_40803', 'asset_40803');
94	0.22 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`31069`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 31069;
95	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: [`1781016004 "\x01tags\x01object_34981" "object_34981"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34981', 'object_34981');
96	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: [`1781016004 "object_34981\x01tags\x01" "class_3\x01tags\x01" "asset_1918\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34981tags', 'class_3tags', 'asset_1918tags');
97	0.24 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: [`1781016004 "\x01tags\x01object_34982" "object_34982"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34982', 'object_34982');
98	0.27 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: [`1781016004 "object_34982\x01tags\x01" "class_3\x01tags\x01" "asset_1919\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34982tags', 'class_3tags', 'asset_1919tags');
99	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: [`1781016004 "\x01tags\x01object_34983" "object_34983"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34983', 'object_34983');
100	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: [`1781016004 "object_34983\x01tags\x01" "class_3\x01tags\x01" "asset_1920\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34983tags', 'class_3tags', 'asset_1920tags');
101	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: [`1781016004 "\x01tags\x01object_34984" "object_34984"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34984', 'object_34984');
102	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: [`1781016004 "object_34984\x01tags\x01" "class_3\x01tags\x01" "asset_1921\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34984tags', 'class_3tags', 'asset_1921tags');
103	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: [`1781016004 "\x01tags\x01object_34985" "object_34985"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_34985', 'object_34985');
104	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: [`1781016004 "object_34985\x01tags\x01" "class_3\x01tags\x01" "asset_1922\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34985tags', 'class_3tags', 'asset_1922tags');
105	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: [`1781016004 "\x01tags\x01object_31341" "object_31341"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_31341', 'object_31341');
106	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: [`1781016004 "object_31341\x01tags\x01" "class_3\x01tags\x01" "asset_41681\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31341tags', 'class_3tags', 'asset_41681tags');
107	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: [`1781016004 "\x01tags\x01object_31349" "object_31349"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_31349', 'object_31349');
108	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: [`1781016004 "object_31349\x01tags\x01" "class_3\x01tags\x01" "asset_41714\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_31349tags', 'class_3tags', 'asset_41714tags');
109	0.17 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/" "Logs"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/' AND `filename` = BINARY 'Logs';
110	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: [`1781016004 "\x01tags\x01asset_320" "asset_320"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_320', 'asset_320');
111	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: [`1781016004 "asset_320\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_320tags');
112	0.14 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/Logs/" "Magento"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/Logs/' AND `filename` = BINARY 'Magento';
113	0.16 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: [`1781016004 "\x01tags\x01asset_559" "asset_559"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_559', 'asset_559');
114	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: [`1781016004 "asset_559\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_559tags');
115	0.15 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/Logs/Magento/" "2026-06-09.log"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/Logs/Magento/' AND `filename` = BINARY '2026-06-09.log';
116	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: [`1781016004 "\x01tags\x01asset_51934" "asset_51934"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_51934', 'asset_51934');
117	0.17 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`51934`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 51934;
118	0.07 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`51934`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 51934;
119	0.15 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`559`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 559;
120	0.09 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/Logs/Magento/" "2026-06-09.log"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/Logs/Magento/' AND `filename` = BINARY '2026-06-09.log';
121	0.08 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/Logs/Magento/" "2026-06-09.log"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/Logs/Magento/' AND `filename` = BINARY '2026-06-09.log';
122	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
123	0.14 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`51934`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 51934;
124	0.12 ms	SELECT versionCount FROM assets WHERE id = ? FOR UPDATE Parameters: [`51934`] View formatted query View runnable query Explain query SELECT versionCount FROM assets WHERE id = ? FOR UPDATE SELECT versionCount FROM assets WHERE id = 51934 FOR UPDATE;
125	0.45 ms	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset' Parameters: [`51934`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'asset' SELECT MAX(versionCount) FROM versions WHERE cid = 51934 AND ctype = 'asset';
126	1.00 ms	UPDATE assets SET customSettings = ? WHERE id = ? Parameters: [`"a:1:{s:8:"checksum";s:32:"eb1173a04192c32a0950171fb448d6cd";}" 51934`] View formatted query View runnable query Explain query UPDATE assets SET customSettings = ? WHERE id = ? UPDATE assets SET customSettings = 'a:1:{s:8:\"checksum\";s:32:\"eb1173a04192c32a0950171fb448d6cd\";}' WHERE id = 51934;
127	0.14 ms	SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = ? Parameters: [`51934`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, filename) as `path` FROM assets WHERE id = ? SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 51934;
128	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: [`1781016004 "\x01tags\x01asset_properties_51934" "asset_properties_51934"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_properties_51934', 'asset_properties_51934');
129	0.25 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: [`1781016004 "\x01tags\x01asset_1" "asset_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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_1', 'asset_1');
130	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: [`1781016004 "asset_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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_1tags');
131	0.08 ms	SELECT * FROM properties WHERE ( (cid IN (1,559,320) AND inheritable = 1) OR cid = ? ) AND ctype='asset' Parameters: [`51934`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 559, 320) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'asset' SELECT * FROM properties WHERE ( (cid IN (1,559,320) AND inheritable = 1) OR cid = 51934 ) AND ctype='asset';
132	0.08 ms	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"asset" 51934`] 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= 'asset' AND sourceId = 51934;
133	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: [`1781016004 "\x01tags\x01system_resource_columns_assets" "system_resource_columns_assets"`] 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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssystem_resource_columns_assets', 'system_resource_columns_assets');
134	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: [`1781016004 "system\x01tags\x01" "resource\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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
135	0.10 ms	SELECT `name` FROM assets_metadata WHERE cid = ? LIMIT 1 Parameters: [`51934`] View formatted query View runnable query Explain query SELECT `name` FROM assets_metadata WHERE cid = ? LIMIT 1 SELECT `name` FROM assets_metadata WHERE cid = 51934 LIMIT 1;
136	0.27 ms	INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"/Logs/Magento/" 51934 1780963202 1781016004 115 0 0 559 "text" "2026-06-09.log" "text/plain" "a:1:{s:8:"checksum";s:32:"eb1173a04192c32a0950171fb448d6cd";}" 0 1781016004`] View formatted query View runnable query Explain query INSERT INTO assets ( `path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES ('/Logs/Magento/', 51934, 1780963202, 1781016004, 115, 0, 0, 559, 'text', '2026-06-09.log', 'text/plain', 'a:1:{s:8:\"checksum\";s:32:\"eb1173a04192c32a0950171fb448d6cd\";}', 0, 1781016004);
137	0.22 ms	UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ? Parameters: [`"/Logs/Magento/" 51934 1780963202 1781016004 115 0 0 559 "text" "2026-06-09.log" "text/plain" "a:1:{s:8:"checksum";s:32:"eb1173a04192c32a0950171fb448d6cd";}" 0 1781016004 51934`] View formatted query View runnable query Explain query UPDATE assets SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `filename` = ?, `mimetype` = ?, `customSettings` = ?, `hasMetaData` = ?, `dataModificationDate` = ? WHERE `id` = ? UPDATE assets SET `path` = '/Logs/Magento/', `id` = 51934, `creationDate` = 1780963202, `modificationDate` = 1781016004, `versionCount` = 115, `userOwner` = 0, `userModification` = 0, `parentId` = 559, `type` = 'text', `filename` = '2026-06-09.log', `mimetype` = 'text/plain', `customSettings` = 'a:1:{s:8:\"checksum\";s:32:\"eb1173a04192c32a0950171fb448d6cd\";}', `hasMetaData` = 0, `dataModificationDate` = 1781016004 WHERE `id` = 51934;
138	0.18 ms	DELETE FROM tree_locks WHERE id = ? AND type = ? Parameters: [`51934 "asset"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND type = ? DELETE FROM tree_locks WHERE id = 51934 AND type = 'asset';
139	0.11 ms	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`51934 "asset"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 51934 AND `ctype` = 'asset' ;
140	0.15 ms	DELETE FROM schedule_tasks WHERE `cid` = '51934' AND `ctype` = 'asset' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = '51934' AND `ctype` = 'asset' DELETE FROM schedule_tasks WHERE `cid` = '51934' AND `ctype` = 'asset';
141	0.12 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;
142	0.12 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;
143	0.09 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;
144	0.11 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;
145	0.72 ms	SELECT IFNULL(binaryFileId, id) FROM versions WHERE binaryFileHash = ? AND cid = ? AND storageType = ? ORDER BY id ASC LIMIT 1 Parameters: [`"a3672d212b31e102e061461229e4e43c9dbb983308150a32bbb16f73ea98685f1407818ab1c5aa24b18925764ba6199141244e4bb61d3e77496f0e8fa1f3c1d3" 51934 "fs"`] View formatted query View runnable query Explain query SELECT IFNULL(binaryFileId, id) FROM versions WHERE binaryFileHash = ? AND cid = ? AND storageType = ? ORDER BY id ASC LIMIT 1 SELECT IFNULL(binaryFileId, id) FROM versions WHERE binaryFileHash = 'a3672d212b31e102e061461229e4e43c9dbb983308150a32bbb16f73ea98685f1407818ab1c5aa24b18925764ba6199141244e4bb61d3e77496f0e8fa1f3c1d3' AND cid = 51934 AND storageType = 'fs' ORDER BY id ASC LIMIT 1;
146	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: [`1781016004 "\x01tags\x01system_resource_columns_versions" "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssystem_resource_columns_versions', 'system_resource_columns_versions');
147	1.72 ms	INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [null 51934 "asset" 0 "" 1781016004 0 1 """ #0 /var/www/public_html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\Model\Version->save()\n #1 /var/www/public_html/vendor/pimcore/pimcore/models/Asset.php(852): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n #2 /var/www/public_html/vendor/pimcore/pimcore/models/Asset.php(544): Pimcore\Model\Asset->saveVersion()\n #3 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Service/IntegrateAssetLogger.php(43): Pimcore\Model\Asset->save()\n #4 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Service/IntegrateAssetLogger.php(53): Integrate\ImportApiBundle\Service\IntegrateAssetLogger->log()\n #5 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Controller/MagentoController.php(333): Integrate\ImportApiBundle\Service\IntegrateAssetLogger->info()\n #6 /var/www/public_html/vendor/symfony/http-kernel/HttpKernel.php(181): Integrate\ImportApiBundle\Controller\MagentoController->indexAction()\n #7 /var/www/public_html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n #8 /var/www/public_html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()\n #9 /var/www/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n #10 /var/www/public_html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n #11 /var/www/public_html/public/index.php(19): require_once('...')\n #12 {main} """ 115 "a3672d212b31e102e061461229e4e43c9dbb983308150a32bbb16f73ea98685f1407818ab1c5aa24b18925764ba6199141244e4bb61d3e77496f0e8fa1f3c1d3" 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, 51934, 'asset', 0, '', 1781016004, 0, 1, '#0 /var/www/public_html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(596): Pimcore\\Model\\Version->save() #1 /var/www/public_html/vendor/pimcore/pimcore/models/Asset.php(852): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion() #2 /var/www/public_html/vendor/pimcore/pimcore/models/Asset.php(544): Pimcore\\Model\\Asset->saveVersion() #3 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Service/IntegrateAssetLogger.php(43): Pimcore\\Model\\Asset->save() #4 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Service/IntegrateAssetLogger.php(53): Integrate\\ImportApiBundle\\Service\\IntegrateAssetLogger->log() #5 /var/www/public_html/bundles/Integrate/ImportApiBundle/src/Controller/MagentoController.php(333): Integrate\\ImportApiBundle\\Service\\IntegrateAssetLogger->info() #6 /var/www/public_html/vendor/symfony/http-kernel/HttpKernel.php(181): Integrate\\ImportApiBundle\\Controller\\MagentoController->indexAction() #7 /var/www/public_html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() #8 /var/www/public_html/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle() #9 /var/www/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle() #10 /var/www/public_html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run() #11 /var/www/public_html/public/index.php(19): require_once(\'...\') #12 {main}', 115, 'a3672d212b31e102e061461229e4e43c9dbb983308150a32bbb16f73ea98685f1407818ab1c5aa24b18925764ba6199141244e4bb61d3e77496f0e8fa1f3c1d3', NULL, 0, 'fs');
148	0.21 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
149	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: [`1781016004 "\x01tags\x01system_cache_write_lock" "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssystem_cache_write_lock', 'system_cache_write_lock');
150	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: [`1781016004 "\x01tags\x01system_cache_write_lock" "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 > 1781016004 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssystem_cache_write_lock', 'system_cache_write_lock');
151	2.92 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 => 1781016004 0 => "system_cache_write_lock" 1 => b"\x00\x00\x00\x02\x17\x01©\x14\x01\x11\x06[‚ê\x07À\x1E\nj(%Ä"`] 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 ('system_cache_write_lock', 0x000000021701A9140111065B82EA07C01E0A6A2825C4, 30, 1781016004) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
152	0.21 ms	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"asset_51934\x01tags\x01" "asset_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 ('asset_51934tags', 'asset_propertiestags');
153	0.25 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:5:\"asset\";s:5:\"\0\0id\";i:51934;}}" "[]" "pimcore_search_backend_message" "2026-06-09 14:40:04" "2026-06-09 14:40:04"] 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:5:\\\"asset\\\";s:5:\\\"\\0\\0id\\\";i:51934;}}', '[]', 'pimcore_search_backend_message', '2026-06-09 14:40:04', '2026-06-09 14:40:04');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.

Symfony Profiler

POST https://pim.tecnafood.it/api/magento/import

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping