QUERY PROFILE SUMMARY FOR DATABASE /Users/USERNAME/Library/Caches/Adobe/Lightroom/Sync Data/user/oz-user-bfaa0ae6bf905c97b91529e26977630a
Count Min Max Total SQL
-------- -------- -------- ---------- -------------
4747 0.000 0.000 0.253 TOTALS
1053 0.000 0.011 0.154 SELECT docs.localDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence,
spaceId
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
fullDocId = ?
4 | 0 | 0 | SEARCH docs USING INDEX sqlite_autoindex_docs_1 (fullDocId=?)
11 | 0 | 0 | SEARCH revs USING INTEGER PRIMARY KEY (rowid=?)
1041 0.000 0.031 0.063 SELECT content FROM localDocs WHERE name == ?
3 | 0 | 0 | SEARCH localDocs USING INDEX sqlite_autoindex_localDocs_1 (name=?)
1054 0.000 0.000 0.014 BEGIN TRANSACTION
527 0.000 0.000 0.008 COMMIT :: queries were:
SELECT docs.localDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence,
spaceId
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
fullDocId = ?
SELECT labels.name FROM labels WHERE revSequence = ?
527 0.000 0.000 0.007 SELECT labels.name FROM labels WHERE revSequence = ?
3 | 0 | 0 | SEARCH labels USING INDEX labels_revSequence (revSequence=?)
524 0.000 0.000 0.005 COMMIT :: queries were:
SELECT docs.localDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence,
spaceId
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
fullDocId = ?
1 0.000 0.000 0.000 COMMIT :: queries were:
INSERT INTO revs( localDocId, revId, parentRevSequence, current, deleted, content )
VALUES( ?, ?, ?, ?, ?, ? )
SELECT docs.localDocId AS selectId, winningRevSequence,
deleted, annotation
FROM docs WHERE fullDocId = ?
SELECT docs.localDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence,
spaceId
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
fullDocId = ?
SELECT revId, sequence, deleted
FROM revs
WHERE localDocId = ? AND current = 1
ORDER BY ( sequence == ? ) DESC, deleted ASC, revId DESC
LIMIT 2
SELECT sequence, revId FROM revs
WHERE localDocId = ? AND revId = ? AND current = 1
ORDER BY sequence DESC LIMIT 1
UPDATE docs SET winningRevSequence = ?, mostRecentRevSequence = ?, deleted = ?, hasConflicts = ?, annotation = ? WHERE localDocId = ?
UPDATE revs SET current = 0 WHERE sequence = ?
1 0.000 0.000 0.000 COMMIT :: queries were:
INSERT INTO revs( localDocId, revId, parentRevSequence, current, deleted, content )
VALUES( ?, ?, ?, ?, ?, ? )
SELECT docs.localDocId AS selectId, winningRevSequence,
deleted, annotation
FROM docs WHERE fullDocId = ?
SELECT docs.localDocId AS selectIdCol, revId, sequence, content, annotation, hasConflicts,
docs.deleted AS deleted,
docs.mostRecentRevSequence AS mostRecentRevSequence,
spaceId
FROM revs
INNER JOIN docs ON docs.winningRevSequence = revs.sequence
WHERE
fullDocId = ?
SELECT revId, sequence, deleted
FROM revs
WHERE localDocId = ? AND current = 1
ORDER BY ( sequence == ? ) DESC, deleted ASC, revId DESC
LIMIT 2
SELECT sequence, revId FROM revs
WHERE localDocId = ? AND revId = ? AND current = 1
ORDER BY sequence DESC LIMIT 1
UPDATE docs SET winningRevSequence = ?, mostRecentRevSequence = ?, deleted = ?, hasConflicts = ?, annotation = ? WHERE localDocId = ?
UPDATE labels SET revSequence = ? WHERE revSequence = ?
UPDATE revs SET content = NULL WHERE
current == 0 AND sequence = ?
UPDATE revs SET current = 0 WHERE sequence = ?
2 0.000 0.000 0.000 INSERT INTO revs( localDocId, revId, parentRevSequence, current, deleted, content )
VALUES( ?, ?, ?, ?, ?, ? )
2 0.000 0.000 0.000 SELECT revId, sequence, deleted
FROM revs
WHERE localDocId = ? AND current = 1
ORDER BY ( sequence == ? ) DESC, deleted ASC, revId DESC
LIMIT 2
1 0.000 0.000 0.000 INSERT OR REPLACE INTO localDocs VALUES( ?, ? )
2 0.000 0.000 0.000 UPDATE docs SET winningRevSequence = ?, mostRecentRevSequence = ?, deleted = ?, hasConflicts = ?, annotation = ? WHERE localDocId = ?
1 0.000 0.000 0.000 COMMIT :: queries were:
INSERT OR REPLACE INTO localDocs VALUES( ?, ? )
2 0.000 0.000 0.000 SELECT sequence, revId FROM revs
WHERE localDocId = ? AND revId = ? AND current = 1
ORDER BY sequence DESC LIMIT 1
1 0.000 0.000 0.000 UPDATE revs SET content = NULL WHERE
current == 0 AND sequence = ?
2 0.000 0.000 0.000 SELECT docs.localDocId AS selectId, winningRevSequence,
deleted, annotation
FROM docs WHERE fullDocId = ?
1 0.000 0.000 0.000 UPDATE labels SET revSequence = ? WHERE revSequence = ?
1 0.000 0.000 0.000 SELECT tbl_name, sql FROM sqlite_master WHERE type == 'table'
2 0.000 0.000 0.000 UPDATE revs SET current = 0 WHERE sequence = ?
1 0.000 0.000 0.000 SELECT name, sql FROM sqlite_master WHERE type == 'index'
1 0.000 0.000 0.000 SELECT currentVersion, backwardCompatibleToVersion
FROM schemaVersion
6
Replies
AdChoices