API tools faq
paste
Advertisement
Guest User

kanboard logs

a guest
Apr 16th, 2023
24
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 33.46 KB | None | 0 0
raw download clone embed print report
  1. [2023-04-16 18:14:23] [critical] old: Unable to load this plugin class: \Kanboard\Plugin\old\Plugin
  2. [2023-04-16 18:14:23] [critical] EAR: Unable to load this plugin class: \Kanboard\Plugin\EAR\Plugin
  3. [2023-04-16 18:14:23] [critical] old2: Unable to load this plugin class: \Kanboard\Plugin\old2\Plugin
  4. [2023-04-16 18:14:23] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
  5. [2023-04-16 18:14:23] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
  6. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
  7. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
  8. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
  9. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
  10. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\TaskModificationController::update
  11. [2023-04-16 20:14:23] [debug] SQL: SELECT `plugin_schema_versions`.`version` FROM `plugin_schema_versions` WHERE `plugin` = ? LIMIT 1
  12. [2023-04-16 20:14:23] [debug] SQL: param[1]: 'updatenotifier'
  13. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00038313865661621
  14. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.00038313865661621
  15. [2023-04-16 20:14:23] [debug] SQL: SELECT `settings`.`option`, `settings`.`value` FROM `settings`
  16. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00022697448730469
  17. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0006101131439209
  18. [2023-04-16 20:14:23] [debug] SQL: SELECT `sessions`.`data` FROM `sessions` WHERE `id` = ? LIMIT 1
  19. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00018906593322754
  20. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.00079917907714844
  21. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_users` ON `project_has_users`.`project_id`=`projects`.`id` WHERE project_has_users.user_id = ? AND projects.is_active IN (?)
  22. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  23. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  24. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00023388862609863
  25. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0010330677032471
  26. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_groups` ON `project_has_groups`.`project_id`=`projects`.`id` LEFT JOIN `group_has_users` ON `group_has_users`.`group_id`=`project_has_groups`.`group_id` WHERE group_has_users.user_id = ? AND projects.is_active IN (?)
  27. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  28. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  29. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00024294853210449
  30. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0012760162353516
  31. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `actions` WHERE `project_id` IN (?, ?, ?, ?, ?, ?)
  32. [2023-04-16 20:14:23] [debug] SQL: param[1]: '7'
  33. [2023-04-16 20:14:23] [debug] SQL: param[2]: '5'
  34. [2023-04-16 20:14:23] [debug] SQL: param[3]: '1'
  35. [2023-04-16 20:14:23] [debug] SQL: param[4]: '3'
  36. [2023-04-16 20:14:23] [debug] SQL: param[5]: '2'
  37. [2023-04-16 20:14:23] [debug] SQL: param[6]: '6'
  38. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00014710426330566
  39. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0014231204986572
  40. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `action_has_params`
  41. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00038790702819824
  42. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0018110275268555
  43. [2023-04-16 20:14:23] [debug] SQL: SELECT 1 FROM `users` WHERE `id` = ? AND `is_active` = ? AND `role` = ?
  44. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  45. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  46. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'app-admin'
  47. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00020003318786621
  48. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0020110607147217
  49. [2023-04-16 20:14:23] [debug] SQL: SELECT `tasks`.`project_id` FROM `tasks` WHERE `id` = ? LIMIT 1
  50. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  51. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013494491577148
  52. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0021460056304932
  53. [2023-04-16 20:14:23] [debug] SQL: SELECT tasks.*, project_has_categories.name AS category_name, swimlanes.name AS swimlane_name, projects.name AS project_name, columns.title AS column_title, users.username AS assignee_username, users.name AS assignee_name, uc.username AS creator_username, uc.name AS creator_name, project_has_categories.description AS category_description, columns.position AS column_position FROM `tasks` LEFT JOIN `users` ON `users`.`id`=`tasks`.`owner_id` LEFT JOIN `users` AS `uc` ON `uc`.`id`=`tasks`.`creator_id` LEFT JOIN `project_has_categories` ON `project_has_categories`.`id`=`tasks`.`category_id` LEFT JOIN `columns` ON `columns`.`id`=`tasks`.`column_id` LEFT JOIN `swimlanes` ON `swimlanes`.`id`=`tasks`.`swimlane_id` LEFT JOIN `projects` ON `projects`.`id`=`tasks`.`project_id` WHERE tasks.id = ? LIMIT 1
  54. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  55. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00034499168395996
  56. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0024909973144531
  57. [2023-04-16 20:14:23] [debug] SQL: SELECT `project_has_users`.`role` FROM `project_has_users` WHERE `user_id` = ? AND `project_id` = ? LIMIT 1
  58. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  59. [2023-04-16 20:14:23] [debug] SQL: param[2]: '2'
  60. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012898445129395
  61. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0026199817657471
  62. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `tasks` WHERE `id` = ? LIMIT 1
  63. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  64. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015807151794434
  65. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0027780532836914
  66. [2023-04-16 20:14:23] [debug] SQL: SELECT tags.id, tags.name, tags.color_id FROM `tags` LEFT JOIN `task_has_tags` ON `task_has_tags`.`tag_id`=`tags`.`id` WHERE task_has_tags.task_id = ?
  67. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  68. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00021600723266602
  69. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0029940605163574
  70. [2023-04-16 20:14:23] [debug] SQL: SELECT `tags`.`id` FROM `tags` WHERE (`project_id` = ? OR `project_id` = ?) AND `name` LIKE ? ORDER BY `project_id` ASC LIMIT 1
  71. [2023-04-16 20:14:23] [debug] SQL: param[1]: '0'
  72. [2023-04-16 20:14:23] [debug] SQL: param[2]: '2'
  73. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'Client'
  74. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00016903877258301
  75. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0031630992889404
  76. [2023-04-16 20:14:23] [debug] SQL: SELECT `tags`.`id` FROM `tags` WHERE (`project_id` = ? OR `project_id` = ?) AND `name` LIKE ? ORDER BY `project_id` ASC LIMIT 1
  77. [2023-04-16 20:14:23] [debug] SQL: param[1]: '0'
  78. [2023-04-16 20:14:23] [debug] SQL: param[2]: '2'
  79. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'Models'
  80. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00014400482177734
  81. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0033071041107178
  82. [2023-04-16 20:14:23] [debug] SQL: UPDATE `tasks` SET `title`=?, `description`=?, `color_id`=?, `owner_id`=?, `category_id`=?, `priority`=?, `date_due`=?, `date_started`=?, `time_estimated`=?, `time_spent`=?, `score`=?, `reference`=?, `project_id`=?, `date_modification`=? WHERE `id` = ?
  83. [2023-04-16 20:14:23] [debug] SQL: param[1]: 'Eyelids flatshaded'
  84. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'Characters with this issue:
  85. * Goku SSJ1
  86. * Goku SSJ2'
  87. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'red'
  88. [2023-04-16 20:14:23] [debug] SQL: param[4]: '2'
  89. [2023-04-16 20:14:23] [debug] SQL: param[5]: '6'
  90. [2023-04-16 20:14:23] [debug] SQL: param[6]: '0'
  91. [2023-04-16 20:14:23] [debug] SQL: param[7]: '0'
  92. [2023-04-16 20:14:23] [debug] SQL: param[8]: '0'
  93. [2023-04-16 20:14:23] [debug] SQL: param[9]: '0'
  94. [2023-04-16 20:14:23] [debug] SQL: param[10]: '0'
  95. [2023-04-16 20:14:23] [debug] SQL: param[11]: '0'
  96. [2023-04-16 20:14:23] [debug] SQL: param[12]: ''
  97. [2023-04-16 20:14:23] [debug] SQL: param[13]: '2'
  98. [2023-04-16 20:14:23] [debug] SQL: param[14]: '1681668863'
  99. [2023-04-16 20:14:23] [debug] SQL: param[15]: '206'
  100. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0021400451660156
  101. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0054471492767334
  102. [2023-04-16 20:14:23] [debug] SQL: SELECT 1 FROM `sessions` WHERE `id` = ?
  103. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0003199577331543
  104. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0057671070098877
  105. [2023-04-16 20:14:23] [debug] SQL: UPDATE `sessions` SET `expire_at`=?, `data`=? WHERE `id` = ?
  106. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1681670303'
  107. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'csrf_key|s:64:";filters:2|s:11:"status:open";flash|a:1:{s:7:"success";s:26:"Task updated successfully.";}filters:1|s:7:"youtube";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";'
  108. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00026988983154297
  109. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0060369968414307
  110. [2023-04-16 20:14:23] [debug] APP: nb_queries=18
  111. [2023-04-16 20:14:23] [debug] APP: rendering_time=0.021581172943115
  112. [2023-04-16 18:14:23] [critical] old: Unable to load this plugin class: \Kanboard\Plugin\old\Plugin
  113. [2023-04-16 18:14:23] [critical] EAR: Unable to load this plugin class: \Kanboard\Plugin\EAR\Plugin
  114. [2023-04-16 18:14:23] [critical] old2: Unable to load this plugin class: \Kanboard\Plugin\old2\Plugin
  115. [2023-04-16 18:14:23] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
  116. [2023-04-16 18:14:23] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
  117. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
  118. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
  119. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
  120. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
  121. [2023-04-16 20:14:23] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\TaskViewController::show
  122. [2023-04-16 20:14:23] [debug] SQL: SELECT `plugin_schema_versions`.`version` FROM `plugin_schema_versions` WHERE `plugin` = ? LIMIT 1
  123. [2023-04-16 20:14:23] [debug] SQL: param[1]: 'updatenotifier'
  124. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00027608871459961
  125. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.00027608871459961
  126. [2023-04-16 20:14:23] [debug] SQL: SELECT `settings`.`option`, `settings`.`value` FROM `settings`
  127. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00027918815612793
  128. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.00055527687072754
  129. [2023-04-16 20:14:23] [debug] SQL: SELECT `sessions`.`data` FROM `sessions` WHERE `id` = ? LIMIT 1
  130. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00026798248291016
  131. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0008232593536377
  132. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_users` ON `project_has_users`.`project_id`=`projects`.`id` WHERE project_has_users.user_id = ? AND projects.is_active IN (?)
  133. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  134. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  135. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00024914741516113
  136. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0010724067687988
  137. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_groups` ON `project_has_groups`.`project_id`=`projects`.`id` LEFT JOIN `group_has_users` ON `group_has_users`.`group_id`=`project_has_groups`.`group_id` WHERE group_has_users.user_id = ? AND projects.is_active IN (?)
  138. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  139. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  140. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00022983551025391
  141. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0013022422790527
  142. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `actions` WHERE `project_id` IN (?, ?, ?, ?, ?, ?)
  143. [2023-04-16 20:14:23] [debug] SQL: param[1]: '7'
  144. [2023-04-16 20:14:23] [debug] SQL: param[2]: '5'
  145. [2023-04-16 20:14:23] [debug] SQL: param[3]: '1'
  146. [2023-04-16 20:14:23] [debug] SQL: param[4]: '3'
  147. [2023-04-16 20:14:23] [debug] SQL: param[5]: '2'
  148. [2023-04-16 20:14:23] [debug] SQL: param[6]: '6'
  149. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001521110534668
  150. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0014543533325195
  151. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `action_has_params`
  152. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001070499420166
  153. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0015614032745361
  154. [2023-04-16 20:14:23] [debug] SQL: SELECT 1 FROM `users` WHERE `id` = ? AND `is_active` = ? AND `role` = ?
  155. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  156. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  157. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'app-admin'
  158. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00016188621520996
  159. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0017232894897461
  160. [2023-04-16 20:14:23] [debug] SQL: SELECT `tasks`.`project_id` FROM `tasks` WHERE `id` = ? LIMIT 1
  161. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  162. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015497207641602
  163. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0018782615661621
  164. [2023-04-16 20:14:23] [debug] SQL: SELECT tasks.*, project_has_categories.name AS category_name, swimlanes.name AS swimlane_name, projects.name AS project_name, columns.title AS column_title, users.username AS assignee_username, users.name AS assignee_name, uc.username AS creator_username, uc.name AS creator_name, project_has_categories.description AS category_description, columns.position AS column_position FROM `tasks` LEFT JOIN `users` ON `users`.`id`=`tasks`.`owner_id` LEFT JOIN `users` AS `uc` ON `uc`.`id`=`tasks`.`creator_id` LEFT JOIN `project_has_categories` ON `project_has_categories`.`id`=`tasks`.`category_id` LEFT JOIN `columns` ON `columns`.`id`=`tasks`.`column_id` LEFT JOIN `swimlanes` ON `swimlanes`.`id`=`tasks`.`swimlane_id` LEFT JOIN `projects` ON `projects`.`id`=`tasks`.`project_id` WHERE tasks.id = ? LIMIT 1
  165. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  166. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00029897689819336
  167. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0021772384643555
  168. [2023-04-16 20:14:23] [debug] SQL: SELECT subtasks.*, users.username, users.name, (SELECT `subtask_time_tracking`.`start` FROM `subtask_time_tracking` WHERE `subtask_time_tracking`.`user_id` = 1 AND `subtask_time_tracking`.`end` = 0 AND `subtask_time_tracking`.`subtask_id` = subtasks.id LIMIT 1) AS `timer_start_date` FROM `subtasks` LEFT JOIN `users` ON `users`.`id`=`subtasks`.`user_id` WHERE `task_id` = ? ORDER BY subtasks.position ASC
  169. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  170. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00026702880859375
  171. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0024442672729492
  172. [2023-04-16 20:14:23] [debug] SQL: SELECT `user_has_metadata`.`name`, `user_has_metadata`.`value` FROM `user_has_metadata` WHERE `user_id` = ? ORDER BY `name` ASC
  173. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  174. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001828670501709
  175. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0026271343231201
  176. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `projects` WHERE `id` = ? LIMIT 1
  177. [2023-04-16 20:14:23] [debug] SQL: param[1]: '2'
  178. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00018310546875
  179. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0028102397918701
  180. [2023-04-16 20:14:23] [debug] SQL: SELECT task_has_files.id, task_has_files.name, task_has_files.path, task_has_files.is_image, task_has_files.task_id, task_has_files.date, task_has_files.user_id, task_has_files.size, users.username, users.name as user_name FROM `task_has_files` LEFT JOIN `users` ON `users`.`id`=`task_has_files`.`user_id` WHERE `task_id` = ? AND `is_image` = ? ORDER BY task_has_files.name ASC
  181. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  182. [2023-04-16 20:14:23] [debug] SQL: param[2]: '0'
  183. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00025010108947754
  184. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0030603408813477
  185. [2023-04-16 20:14:23] [debug] SQL: SELECT task_has_files.id, task_has_files.name, task_has_files.path, task_has_files.is_image, task_has_files.task_id, task_has_files.date, task_has_files.user_id, task_has_files.size, users.username, users.name as user_name FROM `task_has_files` LEFT JOIN `users` ON `users`.`id`=`task_has_files`.`user_id` WHERE `task_id` = ? AND `is_image` = ? ORDER BY task_has_files.name ASC
  186. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  187. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  188. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00027012825012207
  189. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0033304691314697
  190. [2023-04-16 20:14:23] [debug] SQL: SELECT comments.id, comments.date_creation, comments.date_modification, comments.task_id, comments.user_id, comments.comment, users.username, users.name, users.email, users.avatar_path FROM `comments` LEFT JOIN `users` ON `users`.`id`=`comments`.`user_id` WHERE comments.task_id = ? ORDER BY comments.date_creation ASC, comments.id ASC
  191. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  192. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00024199485778809
  193. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0035724639892578
  194. [2023-04-16 20:14:23] [debug] SQL: SELECT task_has_links.id, task_has_links.opposite_task_id AS task_id, links.label, tasks.title, tasks.is_active, tasks.project_id, tasks.column_id, tasks.color_id, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.time_spent AS task_time_spent, tasks.time_estimated AS task_time_estimated, tasks.owner_id AS task_assignee_id, users.username AS task_assignee_username, users.name AS task_assignee_name, columns.title AS column_title, projects.name AS project_name FROM `task_has_links` LEFT JOIN `links` ON `links`.`id`=`task_has_links`.`link_id` LEFT JOIN `tasks` ON `tasks`.`id`=`task_has_links`.`opposite_task_id` LEFT JOIN `columns` ON `columns`.`id`=`tasks`.`column_id` LEFT JOIN `users` ON `users`.`id`=`tasks`.`owner_id` LEFT JOIN `projects` ON `projects`.`id`=`tasks`.`project_id` WHERE task_has_links.task_id = ? ORDER BY links.id ASC, columns.position DESC, tasks.is_active DESC, tasks.position ASC, tasks.id ASC
  195. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  196. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00095319747924805
  197. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0045256614685059
  198. [2023-04-16 20:14:23] [debug] SQL: SELECT task_has_external_links.*, users.name AS creator_name, users.username AS creator_username FROM `task_has_external_links` LEFT JOIN `users` ON `users`.`id`=`task_has_external_links`.`creator_id` WHERE `task_id` = ? ORDER BY `title` ASC
  199. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  200. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0002291202545166
  201. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0047547817230225
  202. [2023-04-16 20:14:23] [debug] SQL: SELECT `links`.`id`, `links`.`label` FROM `links` WHERE `id` != ? ORDER BY `id` ASC
  203. [2023-04-16 20:14:23] [debug] SQL: param[1]: '0'
  204. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015807151794434
  205. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0049128532409668
  206. [2023-04-16 20:14:23] [debug] SQL: SELECT tags.id, tags.name, tags.color_id FROM `tags` LEFT JOIN `task_has_tags` ON `task_has_tags`.`tag_id`=`tags`.`id` WHERE task_has_tags.task_id = ?
  207. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  208. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00016999244689941
  209. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0050828456878662
  210. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  211. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  212. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  213. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001828670501709
  214. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0052657127380371
  215. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  216. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  217. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00017809867858887
  218. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.005443811416626
  219. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  220. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  221. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  222. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015807151794434
  223. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0056018829345703
  224. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  225. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  226. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015091896057129
  227. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0057528018951416
  228. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  229. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  230. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  231. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013494491577148
  232. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0058877468109131
  233. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  234. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  235. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012302398681641
  236. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0060107707977295
  237. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  238. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  239. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  240. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012707710266113
  241. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0061378479003906
  242. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  243. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  244. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012087821960449
  245. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0062587261199951
  246. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  247. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  248. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  249. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00050497055053711
  250. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0067636966705322
  251. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  252. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  253. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001978874206543
  254. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0069615840911865
  255. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  256. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  257. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  258. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013184547424316
  259. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0070934295654297
  260. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  261. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  262. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012302398681641
  263. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0072164535522461
  264. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  265. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  266. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  267. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012898445129395
  268. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.00734543800354
  269. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  270. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  271. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013208389282227
  272. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0074775218963623
  273. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  274. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  275. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  276. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012588500976562
  277. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0076034069061279
  278. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  279. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  280. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012111663818359
  281. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0077245235443115
  282. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  283. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  284. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  285. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013089179992676
  286. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0078554153442383
  287. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  288. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  289. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00015711784362793
  290. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0080125331878662
  291. [2023-04-16 20:14:23] [debug] SQL: SELECT `task_has_metadata`.`value` FROM `task_has_metadata` WHERE `task_id` = ? AND `name` = ? LIMIT 1
  292. [2023-04-16 20:14:23] [debug] SQL: param[1]: '206'
  293. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'coverimage'
  294. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00024294853210449
  295. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0082554817199707
  296. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `task_has_files` WHERE `id` = ? LIMIT 1
  297. [2023-04-16 20:14:23] [debug] SQL: param[1]: '123'
  298. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00013184547424316
  299. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0083873271942139
  300. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_users` ON `project_has_users`.`project_id`=`projects`.`id` WHERE project_has_users.user_id = ? AND projects.is_active IN (?)
  301. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  302. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  303. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00024795532226562
  304. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0086352825164795
  305. [2023-04-16 20:14:23] [debug] SQL: SELECT projects.id, projects.name FROM `projects` LEFT JOIN `project_has_groups` ON `project_has_groups`.`project_id`=`projects`.`id` LEFT JOIN `group_has_users` ON `group_has_users`.`group_id`=`project_has_groups`.`group_id` WHERE group_has_users.user_id = ? AND projects.is_active IN (?)
  306. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  307. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  308. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00023198127746582
  309. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0088672637939453
  310. [2023-04-16 20:14:23] [debug] SQL: SELECT `project_has_categories`.`id`, `project_has_categories`.`name` FROM `project_has_categories` WHERE `project_id` = ? ORDER BY `name` ASC
  311. [2023-04-16 20:14:23] [debug] SQL: param[1]: '2'
  312. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.0001530647277832
  313. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0090203285217285
  314. [2023-04-16 20:14:23] [debug] SQL: SELECT users.id, users.username, users.name FROM `project_has_users` LEFT JOIN `users` ON `users`.`id`=`project_has_users`.`user_id` WHERE users.is_active = ? AND project_has_users.project_id = ? AND project_has_users.role != ?
  315. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  316. [2023-04-16 20:14:23] [debug] SQL: param[2]: '2'
  317. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'project-viewer'
  318. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00027990341186523
  319. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0093002319335938
  320. [2023-04-16 20:14:23] [debug] SQL: SELECT users.id, users.username, users.name FROM `users` LEFT JOIN `group_has_users` ON `group_has_users`.`user_id`=`users`.`id` LEFT JOIN `project_has_groups` ON `project_has_groups`.`group_id`=`group_has_users`.`group_id` WHERE project_has_groups.project_id = ? AND users.is_active = ? AND project_has_groups.role != ? ORDER BY users.username ASC
  321. [2023-04-16 20:14:23] [debug] SQL: param[1]: '2'
  322. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  323. [2023-04-16 20:14:23] [debug] SQL: param[3]: 'project-viewer'
  324. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00033307075500488
  325. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0096333026885986
  326. [2023-04-16 20:14:23] [debug] SQL: SELECT users.name as owner_name, users.username as owner_username, custom_filters.id, custom_filters.user_id, custom_filters.project_id, custom_filters.filter, custom_filters.name, custom_filters.is_shared, custom_filters.append FROM `custom_filters` LEFT JOIN `users` ON `users`.`id`=`custom_filters`.`user_id` WHERE (`is_shared` = ? OR `user_id` = ?) AND `project_id` = ? ORDER BY custom_filters.name ASC
  327. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  328. [2023-04-16 20:14:23] [debug] SQL: param[2]: '1'
  329. [2023-04-16 20:14:23] [debug] SQL: param[3]: '2'
  330. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00020098686218262
  331. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0098342895507812
  332. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `actions` WHERE `project_id` = ?
  333. [2023-04-16 20:14:23] [debug] SQL: param[1]: '2'
  334. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00014591217041016
  335. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.0099802017211914
  336. [2023-04-16 20:14:23] [debug] SQL: SELECT * FROM `action_has_params`
  337. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00010490417480469
  338. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.010085105895996
  339. [2023-04-16 20:14:23] [debug] SQL: SELECT `project_has_users`.`role` FROM `project_has_users` WHERE `user_id` = ? AND `project_id` = ? LIMIT 1
  340. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  341. [2023-04-16 20:14:23] [debug] SQL: param[2]: '2'
  342. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012707710266113
  343. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.010212182998657
  344. [2023-04-16 20:14:23] [debug] SQL: SELECT `project_role_has_restrictions`.`restriction_id`, `project_role_has_restrictions`.`project_id`, `project_role_has_restrictions`.`role_id`, `project_role_has_restrictions`.`rule`, pr.role FROM `project_role_has_restrictions` LEFT JOIN `project_has_roles` AS `pr` ON `pr`.`role_id`=`project_role_has_restrictions`.`role_id` WHERE project_role_has_restrictions.project_id = ? AND `role` = ?
  345. [2023-04-16 20:14:23] [debug] SQL: param[1]: '2'
  346. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'project-manager'
  347. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00020098686218262
  348. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.01041316986084
  349. [2023-04-16 20:14:23] [debug] SQL: SELECT 1 FROM `user_has_unread_notifications` WHERE `user_id` = ?
  350. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1'
  351. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00012898445129395
  352. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.010542154312134
  353. [2023-04-16 20:14:23] [debug] SQL: SELECT 1 FROM `sessions` WHERE `id` = ?
  354. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00011897087097168
  355. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.010661125183105
  356. [2023-04-16 20:14:23] [debug] SQL: UPDATE `sessions` SET `expire_at`=?, `data`=? WHERE `id` = ?
  357. [2023-04-16 20:14:23] [debug] SQL: param[1]: '1681670303'
  358. [2023-04-16 20:14:23] [debug] SQL: param[2]: 'csrf_key|s:64:filters:1|s:7:"youtube";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";'
  359. [2023-04-16 20:14:23] [debug] SQL: query_duration=0.00018692016601562
  360. [2023-04-16 20:14:23] [debug] SQL: total_execution_time=0.010848045349121
  361. [2023-04-16 20:14:23] [debug] APP: nb_queries=53
  362. [2023-04-16 20:14:23] [debug] APP: rendering_time=0.032273054122925
  363. [2023-04-16 20:14:23] [debug] APP: memory_usage=1.57M
  364. [2023-04-16 20:14:23] [debug] APP: uri=/task/206
  365. [2023-04-16 20:14:23] [debug] ###############################################
  366.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!