Page MenuHomePhabricator
Paste P45729

phabricator selecting a maniphest task - mysql log
ActivePublic
Actions

Authored by Dzahn on Mar 11 2023, 12:50 AM.
Tags
None
Referenced Files
F36905718: phabricator selecting a maniphest task - mysql log
Mar 11 2023, 12:50 AM
Subscribers
None
102952 Query SELECT `task`.* FROM `maniphest_task` task WHERE (task.id in (1)) ORDER BY `task`.`id` DESC
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('21'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('1', '11', '38', '51', '52', '62'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102952 Query SELECT `x`.* FROM `maniphest_transaction` `x` WHERE (x.objectPHID IN ('PHID-TASK-qrwadcbqndxztsztatld')) ORDER BY `x`.`id` DESC LIMIT 101
102952 Query SELECT `xcomment`.* FROM `maniphest_transaction_comment` `xcomment` WHERE (`xcomment`.phid IN ('PHID-XCMT-gkjfkmmcbygfhhbvuzpl')) ORDER BY `xcomment`.`id` DESC
102952 Query SELECT `task`.* FROM `maniphest_task` task WHERE ((`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-qrwadcbqndxztsztatld'))) ORDER BY `task`.`id` DESC
102950 Query SELECT `user`.* FROM `user` `user` WHERE (user.phid IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')) ORDER BY `user`.`id` DESC
102950 Query SELECT * FROM `phabricator_user`.`user_profile` WHERE userPHID IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')
102950 Query SELECT cacheKey, userPHID, cacheData, cacheType FROM `user_cache`
WHERE cacheIndex IN ('y_FPXujT93U3') AND userPHID IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')
102952 Query SELECT `task`.* FROM `maniphest_task` task WHERE ((`task`.spacePHID IS NULL) AND (task.phid in ('PHID-TASK-qrwadcbqndxztsztatld'))) ORDER BY `task`.`id` DESC
102953 Connect root@localhost on phabricator_search using Socket
102953 Query SET NAMES utf8mb4
102953 Query SELECT * FROM `search_editengineconfiguration` WHERE (engineKey IN ('maniphest.task')) ORDER BY `id` DESC
102949 Query SELECT * FROM `phabricator_cache`.`cache_markupcache` WHERE cacheKey IN ('remarkup(cSnfXpiJCQzN, GsQsT4XwhXMx)@21@7VwBk7PApozc')
102954 Connect root@localhost on phabricator_file using Socket
102954 Query SET NAMES utf8mb4
102954 Query SELECT `attachments`.* FROM `file_attachment` `attachments` WHERE (attachments.objectPHID IN ('PHID-TASK-qrwadcbqndxztsztatld')) ORDER BY `attachments`.`id` DESC LIMIT 101
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('41'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('21'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102950 Query SELECT `user`.* FROM `user` `user` WHERE (user.phid IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')) ORDER BY `user`.`id` DESC
102955 Connect root@localhost on phabricator_token using Socket
102955 Query SET NAMES utf8mb4
102955 Query SELECT * FROM `token_given` WHERE (objectPHID IN ('PHID-TASK-qrwadcbqndxztsztatld')) ORDER BY `id` DESC
102953 Query SELECT * FROM `search_editengineconfiguration` WHERE ((engineKey IN ('maniphest.task')) AND (subtype IN ('default'))) ORDER BY `id` DESC
102953 Query SELECT * FROM `search_editengineconfiguration` WHERE ((engineKey IN ('maniphest.task')) AND (subtype IN ('default'))) ORDER BY `id` DESC
102956 Connect root@localhost on phabricator_draft using Socket
102956 Query SET NAMES utf8mb4
102956 Query SELECT * FROM `phabricator_draft`.`draft_versioneddraft` WHERE objectPHID = 'PHID-TASK-qrwadcbqndxztsztatld' AND authorPHID = 'PHID-USER-iwt6im6hqz2lpzwbid5o' ORDER BY version DESC LIMIT 1
102952 Query SELECT id AS version FROM `maniphest_transaction`
WHERE objectPHID = 'PHID-TASK-qrwadcbqndxztsztatld' AND authorPHID = 'PHID-USER-iwt6im6hqz2lpzwbid5o'
ORDER BY id DESC LIMIT 1
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('41'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102952 Query SELECT edge.* FROM `edge` edge WHERE ((edge.src IN ('PHID-TASK-qrwadcbqndxztsztatld')) AND (edge.type IN ('4', '3', '1'))) ORDER BY edge.dateCreated DESC, edge.seq DESC
102957 Connect root@localhost on phabricator_project using Socket
102957 Query SET NAMES utf8mb4
102957 Query SELECT `project`.* FROM `project` `project` JOIN `edge` e ON e.src = project.phid AND e.type = 60 WHERE ((`project`.spacePHID IS NULL) AND (project.status IN ('0')) AND (e.dst IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')) AND (project.milestoneNumber IS NULL)) GROUP BY `project`.phid ORDER BY `project`.`name` ASC LIMIT 5
102950 Query SELECT `user`.* FROM `user` `user` WHERE (user.phid IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')) ORDER BY `user`.`id` DESC
102950 Query SELECT * FROM `phabricator_user`.`user_profile` WHERE userPHID IN ('PHID-USER-iwt6im6hqz2lpzwbid5o')
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL