phabricator@us-west-tails-02:/phab_path/phabricator$ bin/search index T173111 --trace --force
>>> [2] <connect> phabricator_maniphest
<<< [2] <connect> 1,322 us
>>> [3] <query> SELECT `task`.*, 0 _ft_rank FROM `maniphest_task` task WHERE (task.id in (173111)) ORDER BY `task`.`id` DESC
<<< [3] <query> 4,904 us
NOTE Run this workflow with "--background" to queue tasks for the daemon workers.
Indexing 1 object of type TASK.
>>> [4] <query> SELECT `task`.*, 0 _ft_rank FROM `maniphest_task` task WHERE (task.phid in ('PHID-TASK-qu7uyufufku4m6wui6a4')) ORDER BY `task`.`id` DESC
<<< [4] <query> 3,099 us
>>> [5] <query> SELECT id FROM `maniphest_transaction` WHERE objectPHID = 'PHID-TASK-qu7uyufufku4m6wui6a4'
ORDER BY id DESC LIMIT 1
<<< [5] <query> 986 us
>>> [6] <query> SELECT c.id FROM `maniphest_transaction` x JOIN `maniphest_transaction_comment` c
ON x.phid = c.transactionPHID
WHERE x.objectPHID = 'PHID-TASK-qu7uyufufku4m6wui6a4'
ORDER BY c.id DESC LIMIT 1
<<< [6] <query> 1,525 us
>>> [7] <lock> ph:phabric-6rILUDHKjHKu:index.PHID-TASK-qu7uyufufku4m6wui6a4
>>> [8] <connect> phabricator_repository
<<< [8] <connect> 2,679 us
>>> [9] <query> SET wait_timeout = 2147483
<<< [9] <query> 499 us
>>> [10] <query> SELECT GET_LOCK('ph:phabric-6rILUDHKjHKu:index.PHID-TASK-qu7uyufufku4m6wui6a4', 1)
<<< [10] <query> 193 us
>>> [11] <query> SELECT `task`.*, 0 _ft_rank FROM `maniphest_task` task WHERE (task.phid in ('PHID-TASK-qu7uyufufku4m6wui6a4')) ORDER BY `task`.`id` DESC
<<< [11] <query> 2,418 us
>>> [12] <query> SELECT objectPHID, fieldIndex, fieldValue FROM `maniphest_customfieldstorage`
WHERE objectPHID IN ('PHID-TASK-qu7uyufufku4m6wui6a4') AND fieldIndex IN ('HM7OnUvLVKfV', 'jFbnggOLne6L', 'Fdg9lqf7BdCB')
<<< [12] <query> 537 us
>>> [13] <connect> phabricator_maniphest
<<< [13] <connect> 967 us
>>> [14] <query> START TRANSACTION
<<< [14] <query> 494 us
>>> [15] <query> DELETE FROM `maniphest_customfieldstringindex` WHERE objectPHID = 'PHID-TASK-qu7uyufufku4m6wui6a4' AND indexKey IN ('HM7OnUvLVKfV', 'jFbnggOLne6L', 'Fdg9lqf7BdCB')
<<< [15] <query> 503 us
>>> [16] <query> INSERT INTO `maniphest_customfieldstringindex` (objectPHID, indexKey, indexValue) VALUES ('PHID-TASK-qu7uyufufku4m6wui6a4', 'jFbnggOLne6L', 'dropbox:blank')
<<< [16] <query> 360 us
>>> [17] <query> COMMIT
<<< [17] <query> 2,991 us
>>> [18] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-TASK-qu7uyufufku4m6wui6a4')) AND (edge.type IN ('41')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [18] <query> 520 us
>>> [19] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-TASK-qu7uyufufku4m6wui6a4')) AND (edge.type IN ('21')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [19] <query> 403 us
>>> [20] <connect> phabricator_user
<<< [20] <connect> 2,036 us
>>> [21] <query> SELECT `user`.*, 0 _ft_rank FROM `user` user WHERE (user.phid IN ('PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-n3ptyalaqthg6hw6il6q', 'PHID-USER-zktz4iow24kuw44gjdkx')) ORDER BY `user`.`id` DESC
<<< [21] <query> 489 us
>>> [22] <query> SELECT * FROM `user_profile` WHERE userPHID IN ('PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-zktz4iow24kuw44gjdkx', 'PHID-USER-n3ptyalaqthg6hw6il6q')
<<< [22] <query> 312 us
>>> [23] <query> SELECT cacheKey, userPHID, cacheData, cacheType FROM `user_cache`
WHERE cacheIndex IN ('y_FPXujT93U3') AND userPHID IN ('PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-zktz4iow24kuw44gjdkx', 'PHID-USER-n3ptyalaqthg6hw6il6q')
<<< [23] <query> 404 us
>>> [24] <connect> phabricator_project
<<< [24] <connect> 1,803 us
>>> [25] <query> SELECT `p`.*, 0 _ft_rank FROM `project` p WHERE (phid IN ('PHID-PROJ-es5s4qnngvhi5uv5cbdd')) ORDER BY `p`.`name` ASC
<<< [25] <query> 645 us
>>> [26] <connect> phabricator_file
<<< [26] <connect> 3,494 us
>>> [27] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-x3hs5ofvi7om5yfb2k2i')) ORDER BY `f`.`id` DESC
<<< [27] <query> 373 us
>>> [28] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-x3hs5ofvi7om5yfb2k2i')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [28] <query> 1,333 us
>>> [29] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-x3hs5ofvi7om5yfb2k2i')
<<< [29] <query> 337 us
>>> [30] <query> SELECT * FROM `maniphest_transaction` x WHERE (objectPHID IN ('PHID-TASK-qu7uyufufku4m6wui6a4')) ORDER BY `id` DESC
<<< [30] <query> 6,577 us
>>> [31] <query> SELECT * FROM `maniphest_transaction_comment` xcomment WHERE (xcomment.phid IN ('PHID-XCMT-hq5f7pct3vcrxzmqiz7u', 'PHID-XCMT-4un3osc5zie7yb4hajnb', 'PHID-XCMT-oniw2dlgfrovjqp65h3t', 'PHID-XCMT-flujt2snhusccbfnmmjy')) ORDER BY `id` DESC
<<< [31] <query> 483 us
>>> [32] <query> SELECT `task`.*, 0 _ft_rank FROM `maniphest_task` task WHERE (task.phid in ('PHID-TASK-qu7uyufufku4m6wui6a4')) ORDER BY `task`.`id` DESC
<<< [32] <query> 3,468 us
>>> [33] <query> SELECT `user`.*, 0 _ft_rank FROM `user` user WHERE (user.phid IN ('PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-n3ptyalaqthg6hw6il6q', 'PHID-USER-zktz4iow24kuw44gjdkx', 'PHID-USER-t3uydzeibumume2atweg', 'PHID-USER-czb57xdfpfyawq24o2k7')) ORDER BY `user`.`id` DESC
<<< [33] <query> 648 us
>>> [34] <query> SELECT * FROM `user_profile` WHERE userPHID IN ('PHID-USER-czb57xdfpfyawq24o2k7', 'PHID-USER-t3uydzeibumume2atweg', 'PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-zktz4iow24kuw44gjdkx', 'PHID-USER-n3ptyalaqthg6hw6il6q')
<<< [34] <query> 351 us
>>> [35] <query> SELECT cacheKey, userPHID, cacheData, cacheType FROM `user_cache`
WHERE cacheIndex IN ('y_FPXujT93U3') AND userPHID IN ('PHID-USER-czb57xdfpfyawq24o2k7', 'PHID-USER-t3uydzeibumume2atweg', 'PHID-USER-rbzqnywzbssqy6bui2s4', 'PHID-USER-tt3hf62sajgc4d7ymmib', 'PHID-USER-zktz4iow24kuw44gjdkx', 'PHID-USER-n3ptyalaqthg6hw6il6q')
<<< [35] <query> 408 us
>>> [36] <query> SELECT `task`.*, 0 _ft_rank FROM `maniphest_task` task WHERE (task.phid in ('PHID-TASK-qu7uyufufku4m6wui6a4')) ORDER BY `task`.`id` DESC
<<< [36] <query> 2,834 us
>>> [37] <query> SELECT `p`.*, 0 _ft_rank FROM `project` p WHERE (phid IN ('PHID-PROJ-es5s4qnngvhi5uv5cbdd', 'PHID-PROJ-eyn2ql4ptzvzxgj44s4f', 'PHID-PROJ-whqp5rckl5es6zudgjj6', 'PHID-PROJ-kjsdtq7wjq64kwngq67b', 'PHID-PROJ-piq5zbrwiqtzc4zdpxym', 'PHID-PROJ-6rl56xdfhlq324fwkh46')) ORDER BY `p`.`name` ASC
<<< [37] <query> 423 us
>>> [38] <query> SELECT `f`.* FROM `file` f WHERE (f.phid IN ('PHID-FILE-huqh6tcokla3yk3mduoe', 'PHID-FILE-x3hs5ofvi7om5yfb2k2i', 'PHID-FILE-fa466shdx6qoloty72ts', 'PHID-FILE-zojh7zkqmzgsrpsy6e2i')) ORDER BY `f`.`id` DESC
<<< [38] <query> 880 us
>>> [39] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-x3hs5ofvi7om5yfb2k2i', 'PHID-FILE-huqh6tcokla3yk3mduoe', 'PHID-FILE-fa466shdx6qoloty72ts', 'PHID-FILE-zojh7zkqmzgsrpsy6e2i')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [39] <query> 458 us
>>> [40] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-x3hs5ofvi7om5yfb2k2i', 'PHID-FILE-huqh6tcokla3yk3mduoe', 'PHID-FILE-fa466shdx6qoloty72ts', 'PHID-FILE-zojh7zkqmzgsrpsy6e2i')
<<< [40] <query> 786 us
>>> [41] <query> SELECT `f`.* FROM `file` f WHERE (builtinKey IN ('builtin:disk(name=projects/v3/brief-NWkZoO7qrtMi')) ORDER BY `f`.`id` DESC
<<< [41] <query> 329 us
>>> [42] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-fgsltz64x5cvnl5zvbeb')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [42] <query> 904 us
>>> [43] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-fgsltz64x5cvnl5zvbeb')
<<< [43] <query> 956 us
>>> [44] <query> SELECT `f`.* FROM `file` f WHERE (builtinKey IN ('builtin:disk(name=projects/v3/tag.p-vb_VkcHxourC')) ORDER BY `f`.`id` DESC
<<< [44] <query> 289 us
>>> [45] <query> SELECT edge.* FROM `edge` edge WHERE (edge.src IN ('PHID-FILE-k644wyzpfyez4adhgf3u')) AND (edge.type IN ('26')) ORDER BY edge.dateCreated DESC, edge.seq DESC
<<< [45] <query> 293 us
>>> [46] <query> SELECT * FROM `file_transformedfile` WHERE transformedPHID IN ('PHID-FILE-k644wyzpfyez4adhgf3u')
<<< [46] <query> 256 us