Untitled
unknown
plain_text
12 days ago
118 kB
6
Indexable
[2025-03-10 11:59:33] [debug] ###############################################
[2025-03-10 11:00:02] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2025-03-10 12:00:02] [debug] \Kanboard\Plugin\Mailmagik\Action\ConvertEmailToTask(column_id='37'|color_id='yellow') [mailmagik.fetchmail] => executable=true exec_success=NULL
[2025-03-10 12:00:02] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:02] [debug] SQL: param[1]: 'wiki'
[2025-03-10 12:00:02] [debug] SQL: query_duration=0.00016880035400391
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00016880035400391
[2025-03-10 12:00:02] [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"
[2025-03-10 12:00:02] [debug] SQL: query_duration=0.00012803077697754
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00029683113098145
[2025-03-10 12:00:02] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:02] [debug] SQL: param[1]: 'templatemanager'
[2025-03-10 12:00:02] [debug] SQL: query_duration=6.3896179199219E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00036072731018066
[2025-03-10 12:00:02] [debug] SQL: SELECT 1 FROM "settings" WHERE "option" = ?
[2025-03-10 12:00:02] [debug] SQL: param[1]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:02] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00040173530578613
[2025-03-10 12:00:02] [debug] SQL: UPDATE "settings" SET "value"=?, "changed_on"=?, "changed_by"=? WHERE "option" = ?
[2025-03-10 12:00:02] [debug] SQL: param[1]: ''
[2025-03-10 12:00:02] [debug] SQL: param[2]: '1741604402'
[2025-03-10 12:00:02] [debug] SQL: param[3]: '0'
[2025-03-10 12:00:02] [debug] SQL: param[4]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:02] [debug] SQL: query_duration=8.1062316894531E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00048279762268066
[2025-03-10 12:00:02] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:02] [debug] SQL: param[1]: 'subtaskdate'
[2025-03-10 12:00:02] [debug] SQL: query_duration=9.5844268798828E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00057864189147949
[2025-03-10 12:00:02] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:02] [debug] SQL: param[1]: 'starredprojects'
[2025-03-10 12:00:02] [debug] SQL: query_duration=4.8160552978516E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00062680244445801
[2025-03-10 12:00:02] [debug] SQL: SELECT * FROM "actions"
[2025-03-10 12:00:02] [debug] SQL: query_duration=7.3909759521484E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00070071220397949
[2025-03-10 12:00:02] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:02] [debug] SQL: query_duration=3.9100646972656E-5
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00073981285095215
[2025-03-10 12:00:02] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:02] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:02] [debug] SQL: query_duration=0.0001978874206543
[2025-03-10 12:00:02] [debug] SQL: total_execution_time=0.00093770027160645
[2025-03-10 12:00:02] [debug] APP: nb_queries=10
[2025-03-10 12:00:02] [debug] APP: rendering_time=0.61124801635742
[2025-03-10 12:00:02] [debug] APP: memory_usage=11.94M
[2025-03-10 12:00:02] [debug] APP: uri=
[2025-03-10 12:00:02] [debug] ###############################################
[2025-03-10 11:00:24] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2025-03-10 11:00:24] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2025-03-10 12:00:24] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2025-03-10 12:00:24] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2025-03-10 12:00:24] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2025-03-10 12:00:24] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2025-03-10 12:00:24] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\BoardViewController::show
[2025-03-10 12:00:24] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: 'wiki'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00015902519226074
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00015902519226074
[2025-03-10 12:00:24] [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00011205673217773
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00027108192443848
[2025-03-10 12:00:24] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: 'templatemanager'
[2025-03-10 12:00:24] [debug] SQL: query_duration=5.7220458984375E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00032830238342285
[2025-03-10 12:00:24] [debug] SQL: SELECT 1 FROM "settings" WHERE "option" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.504753112793E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00036334991455078
[2025-03-10 12:00:24] [debug] SQL: UPDATE "settings" SET "value"=?, "changed_on"=?, "changed_by"=? WHERE "option" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: ''
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1741604424'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '0'
[2025-03-10 12:00:24] [debug] SQL: param[4]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.6014785766602E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00040936470031738
[2025-03-10 12:00:24] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: 'subtaskdate'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.7206878662109E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00045657157897949
[2025-03-10 12:00:24] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: 'starredprojects'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.0054321289062E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00049662590026855
[2025-03-10 12:00:24] [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? AND "expire_at" > ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1741604424'
[2025-03-10 12:00:24] [debug] SQL: query_duration=8.9168548583984E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00058579444885254
[2025-03-10 12:00:24] [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 (?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.0095062255859E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0006558895111084
[2025-03-10 12:00:24] [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 (?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=9.7990036010742E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00075387954711914
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" IN (?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:24] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:24] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:24] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.6968460083008E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00080084800720215
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:24] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:24] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:24] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:24] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:24] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:24] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:24] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:24] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:24] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:24] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:24] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:24] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:24] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:24] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:24] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:24] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:24] [debug] SQL: param[21]: '30'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.6014785766602E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00084686279296875
[2025-03-10 12:00:24] [debug] SQL: SELECT 1 FROM "users" WHERE "id" = ? AND "is_active" = ? AND "role" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[3]: 'app-admin'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.4822692871094E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00089168548583984
[2025-03-10 12:00:24] [debug] SQL: SELECT projects.*, users.username AS owner_username, users.name AS owner_name, (SELECT count(*) FROM tasks WHERE tasks.project_id=projects.id AND tasks.is_active='1') AS nb_active_tasks FROM "projects" LEFT JOIN "users" ON "users"."id"="projects"."owner_id" LEFT JOIN "tasks" ON "tasks"."project_id"="projects"."id" WHERE projects.id = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00028491020202637
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0011765956878662
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=6.3896179199219E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0012404918670654
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "swimlanes" WHERE "project_id" = ? AND "is_active" = ? ORDER BY "position" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.8160552978516E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0012886524200439
[2025-03-10 12:00:24] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00013184547424316
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0014204978942871
[2025-03-10 12:00:24] [debug] SQL: SELECT (SELECT COUNT(*) FROM comments WHERE task_id=tasks.id) AS nb_comments, (SELECT COUNT(*) FROM task_has_files WHERE task_id=tasks.id) AS nb_files, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id) AS nb_subtasks, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id AND status=2) AS nb_completed_subtasks, (SELECT COUNT(*) FROM task_has_links WHERE task_has_links.task_id = tasks.id) AS nb_links, (SELECT COUNT(*) FROM task_has_external_links WHERE task_has_external_links.task_id = tasks.id) AS nb_external_links, (SELECT DISTINCT 1 FROM task_has_links tl JOIN links l ON tl.link_id = l.id WHERE tl.task_id = tasks.id AND l.label = 'is a milestone of') AS is_milestone, tasks.id, tasks.reference, tasks.title, tasks.description, tasks.date_creation, tasks.date_modification, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.color_id, tasks.project_id, tasks.column_id, tasks.swimlane_id, tasks.owner_id, tasks.creator_id, tasks.position, tasks.is_active, tasks.score, tasks.category_id, tasks.priority, tasks.date_moved, tasks.recurrence_status, tasks.recurrence_trigger, tasks.recurrence_factor, tasks.recurrence_timeframe, tasks.recurrence_basedate, tasks.recurrence_parent, tasks.recurrence_child, tasks.time_estimated, tasks.time_spent, tasks.reference, users.username AS assignee_username, users.name AS assignee_name, users.email AS assignee_email, users.avatar_path AS assignee_avatar_path, project_has_categories.name AS category_name, project_has_categories.description AS category_description, project_has_categories.color_id AS category_color_id, columns.title AS column_name, columns.position AS column_position, swimlanes.name AS swimlane_name, projects.name AS project_name 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.is_active = ? AND tasks.project_id = ? ORDER BY tasks.position ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00033092498779297
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0017514228820801
[2025-03-10 12:00:24] [debug] SQL: SELECT tags.id, tags.name, tags.color_id, task_has_tags.task_id FROM "tags" LEFT JOIN "task_has_tags" ON "task_has_tags"."tag_id"="tags"."id" WHERE task_has_tags.task_id IN (?, ?, ?, ?, ?, ?) ORDER BY tags.name ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '225'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '227'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '228'
[2025-03-10 12:00:24] [debug] SQL: param[4]: '229'
[2025-03-10 12:00:24] [debug] SQL: param[5]: '230'
[2025-03-10 12:00:24] [debug] SQL: param[6]: '231'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.8916549682617E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0018303394317627
[2025-03-10 12:00:24] [debug] SQL: SELECT "project_has_users"."role" FROM "project_has_users" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.7908554077148E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0018682479858398
[2025-03-10 12:00:24] [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 (?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0019092559814453
[2025-03-10 12:00:24] [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 (?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=6.5088272094727E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.00197434425354
[2025-03-10 12:00:24] [debug] SQL: SELECT "project_has_categories"."id", "project_has_categories"."name" FROM "project_has_categories" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0020103454589844
[2025-03-10 12:00:24] [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 != ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[3]: 'project-viewer'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0020513534545898
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[3]: 'project-viewer'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00012993812561035
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0021812915802002
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=8.1777572631836E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.002263069152832
[2025-03-10 12:00:24] [debug] SQL: SELECT "user_has_metadata"."name", "user_has_metadata"."value" FROM "user_has_metadata" WHERE "user_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.9114227294922E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.002312183380127
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.57763671875E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0023579597473145
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=5.6028366088867E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0024139881134033
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.6954879760742E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0024509429931641
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.6954879760742E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0024878978729248
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?)
[2025-03-10 12:00:24] [debug] SQL: param[1]: '30'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.504753112793E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0025229454040527
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: query_duration=5.3167343139648E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0025761127471924
[2025-03-10 12:00:24] [debug] SQL: SELECT "tags"."id", "tags"."name" FROM "tags" WHERE ("project_id" = ? OR "project_id" = ?) ORDER BY "name" ASC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '0'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.9114227294922E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0026252269744873
[2025-03-10 12:00:24] [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" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'project-manager'
[2025-03-10 12:00:24] [debug] SQL: query_duration=5.2928924560547E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0026781558990479
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '225'
[2025-03-10 12:00:24] [debug] SQL: query_duration=8.5115432739258E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0027632713317871
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '225'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.6968460083008E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0028102397918701
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '227'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.8916549682617E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0028891563415527
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '227'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.0054321289062E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0029292106628418
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '228'
[2025-03-10 12:00:24] [debug] SQL: query_duration=8.1062316894531E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0030102729797363
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '228'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0030462741851807
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '229'
[2025-03-10 12:00:24] [debug] SQL: query_duration=8.1062316894531E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0031273365020752
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '229'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=2.9087066650391E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0031564235687256
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '230'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.2002410888672E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0032284259796143
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '230'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=2.6941299438477E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0032553672790527
[2025-03-10 12:00:24] [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
[2025-03-10 12:00:24] [debug] SQL: param[1]: '231'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.2956085205078E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0033283233642578
[2025-03-10 12:00:24] [debug] SQL: SELECT "task_has_metadata"."value" FROM "task_has_metadata" WHERE "task_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '231'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'coverimage'
[2025-03-10 12:00:24] [debug] SQL: query_duration=2.8133392333984E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0033564567565918
[2025-03-10 12:00:24] [debug] SQL: SELECT 1 FROM "user_has_unread_notifications" WHERE "user_id" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=7.6055526733398E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0034325122833252
[2025-03-10 12:00:24] [debug] SQL: SELECT tasks.id, tasks.title, projects.name AS project_name FROM "tasks" LEFT JOIN "projects" ON "projects"."id"="tasks"."project_id" WHERE projects.is_active = ? AND tasks.is_active = ? AND tasks.owner_id = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=5.3167343139648E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0034856796264648
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "starred_projects" LEFT JOIN "projects" ON "projects"."id"="starred_projects"."project_id" WHERE "user_id" = ? ORDER BY projects.last_modified DESC
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: query_duration=0.00011610984802246
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0036017894744873
[2025-03-10 12:00:24] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:24] [debug] SQL: query_duration=4.7922134399414E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0036497116088867
[2025-03-10 12:00:24] [debug] SQL: SELECT "user_has_metadata"."value" FROM "user_has_metadata" WHERE "user_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'starredprojects_only_starred_in_project_selector'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0036857128143311
[2025-03-10 12:00:24] [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:24] [debug] SQL: query_duration=2.8133392333984E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.003713846206665
[2025-03-10 12:00:24] [debug] SQL: UPDATE "sessions" SET "expire_at"=?, "data"=? WHERE "id" = ?
[2025-03-10 12:00:24] [debug] SQL: param[1]: '1741605864'
[2025-03-10 12:00:24] [debug] SQL: param[2]: 'user|a:24:{s:2:"id";i:1;s:8:"username";s:5:"admin";s:12:"is_ldap_user";b:0;s:4:"name";s:12:"Herz Hermann";s:5:"email";s:19:"heart1010@gmail.com";s:9:"google_id";N;s:9:"github_id";N;s:21:"notifications_enabled";i:1;s:8:"timezone";s:13:"Europe/Berlin";s:8:"language";s:8:"de_DE_du";s:18:"disable_login_form";i:0;s:19:"twofactor_activated";b:0;s:16:"twofactor_secret";N;s:5:"token";s:0:"";s:20:"notifications_filter";i:4;s:15:"nb_failed_login";i:0;s:20:"lock_expiration_date";i:0;s:9:"gitlab_id";N;s:4:"role";s:9:"app-admin";s:9:"is_active";i:1;s:11:"avatar_path";s:50:"avatars/1/dba1e55a8250a0afdb5f073e2a88704a9413f17d";s:16:"api_access_token";N;s:6:"filter";s:0:"";s:5:"theme";s:5:"light";}postAuthenticationValidated|b:1;filters:7|s:11:"status:open";pcsrf_key|s:64:"fc28b67d8ff5e88085b590467bdc9231792ef5da845e814ac834f16782b9e830";csrf_key|s:64:"214ef4a1a5f7e52a8fac76d5a1a6854d5d0a5353dfdc27007a013b7a95330ddd";hasSubtaskInProgress|b:0;filters:2|s:11:"status:open";filters:4|s:11:"status:open";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";filters:1|s:11:"status:open";'
[2025-03-10 12:00:24] [debug] SQL: param[3]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:24] [debug] SQL: query_duration=3.0040740966797E-5
[2025-03-10 12:00:24] [debug] SQL: total_execution_time=0.0037438869476318
[2025-03-10 12:00:24] [debug] APP: nb_queries=54
[2025-03-10 12:00:24] [debug] APP: rendering_time=0.17370796203613
[2025-03-10 12:00:24] [debug] APP: memory_usage=1.67M
[2025-03-10 12:00:24] [debug] APP: uri=/board/7
[2025-03-10 12:00:24] [debug] ###############################################
[2025-03-10 11:00:27] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2025-03-10 11:00:27] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2025-03-10 12:00:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2025-03-10 12:00:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2025-03-10 12:00:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2025-03-10 12:00:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2025-03-10 12:00:27] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\DashboardController::show
[2025-03-10 12:00:27] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: 'wiki'
[2025-03-10 12:00:27] [debug] SQL: query_duration=9.3936920166016E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=9.3936920166016E-5
[2025-03-10 12:00:27] [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00010919570922852
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00020313262939453
[2025-03-10 12:00:27] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: 'templatemanager'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.0067901611328E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00025320053100586
[2025-03-10 12:00:27] [debug] SQL: SELECT 1 FROM "settings" WHERE "option" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.2186508178711E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00028538703918457
[2025-03-10 12:00:27] [debug] SQL: UPDATE "settings" SET "value"=?, "changed_on"=?, "changed_by"=? WHERE "option" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: ''
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1741604427'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[4]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.6968460083008E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00033235549926758
[2025-03-10 12:00:27] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: 'subtaskdate'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00037336349487305
[2025-03-10 12:00:27] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: 'starredprojects'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.7908554077148E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0004112720489502
[2025-03-10 12:00:27] [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? AND "expire_at" > ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1741604427'
[2025-03-10 12:00:27] [debug] SQL: query_duration=8.392333984375E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00049519538879395
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.2942504882812E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00055813789367676
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=7.7962875366211E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00063610076904297
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" IN (?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.9100646972656E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00067520141601562
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:27] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:27] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:27] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:27] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:27] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:27] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:27] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:27] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:27] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:27] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:27] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:27] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:27] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:27] [debug] SQL: param[21]: '30'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.4107437133789E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00071930885314941
[2025-03-10 12:00:27] [debug] SQL: SELECT 1 FROM "users" WHERE "id" = ? AND "is_active" = ? AND "role" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: 'app-admin'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.3167343139648E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00077247619628906
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "users" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=8.1062316894531E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00085353851318359
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.6041946411133E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00091958045959473
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=9.7990036010742E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0010175704956055
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00035309791564941
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0013706684112549
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00018906593322754
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0015597343444824
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00016999244689941
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0017297267913818
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00018596649169922
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0019156932830811
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00017380714416504
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0020895004272461
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00015711784362793
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.002246618270874
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00015497207641602
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.00240159034729
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.2227249145508E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0024638175964355
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.8902969360352E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0025327205657959
[2025-03-10 12:00:27] [debug] SQL: SELECT COUNT(*) FROM "projects" LEFT JOIN "users" ON "users"."id"="projects"."owner_id" WHERE projects.id IN (?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.5074691772461E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0025877952575684
[2025-03-10 12:00:27] [debug] SQL: SELECT "tags"."id", "tags"."name" FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '0'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.2928924560547E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0026407241821289
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" LEFT JOIN "projects" ON "projects"."id"="starred_projects"."project_id" WHERE "user_id" = ? ORDER BY projects.last_modified DESC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00012087821960449
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0027616024017334
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.5803527832031E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0028274059295654
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.5074691772461E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0028824806213379
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.6028366088867E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0029385089874268
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.1975250244141E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0029904842376709
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.2200088500977E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0030326843261719
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:27] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:27] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:27] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:27] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:27] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:27] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:27] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:27] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:27] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:27] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:27] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:27] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:27] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.103515625E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0030937194824219
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.3153762817383E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0031368732452393
[2025-03-10 12:00:27] [debug] SQL: SELECT projects.*, users.username AS owner_username, users.name AS owner_name FROM "projects" LEFT JOIN "users" ON "users"."id"="projects"."owner_id" WHERE projects.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY projects.name ASC LIMIT 10
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00014281272888184
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0032796859741211
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00057005882263184
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0038497447967529
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00029802322387695
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0041477680206299
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00034999847412109
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.004497766494751
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00018000602722168
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0046777725219727
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00017905235290527
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0048568248748779
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00028491020202637
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0051417350769043
[2025-03-10 12:00:27] [debug] SQL: SELECT "columns"."id", "columns"."title", "columns"."position", "columns"."task_limit", "columns"."description", "columns"."hide_in_dashboard", "columns"."project_id", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='1') AS "nb_open_tasks", (SELECT COUNT(*) FROM tasks WHERE column_id=columns.id AND is_active='0') AS "nb_closed_tasks" FROM "columns" WHERE "project_id" = ? ORDER BY "position" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00029492378234863
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0054366588592529
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0054776668548584
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0055186748504639
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.2200088500977E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0055608749389648
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0994415283203E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.005591869354248
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:27] [debug] SQL: query_duration=1.5974044799805E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0056078433990479
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.7908554077148E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.005645751953125
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.7894973754883E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0056736469268799
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.6968460083008E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0057206153869629
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.1021575927734E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0057716369628906
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.1988830566406E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.005833625793457
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0058696269989014
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:27] [debug] SQL: query_duration=1.5020370483398E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0058846473693848
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1961669921875E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0059266090393066
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.005962610244751
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.887580871582E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0060114860534668
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.1021575927734E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0060625076293945
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0994415283203E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0060935020446777
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0040740966797E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0061235427856445
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:27] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:27] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:27] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:27] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:27] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:27] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:27] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:27] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:27] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:27] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:27] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:27] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:27] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:27] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.3882598876953E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0061774253845215
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1961669921875E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0062193870544434
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.8862228393555E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0062582492828369
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.5061111450195E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0063033103942871
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.7922134399414E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0063512325286865
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.9087066650391E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0063803195953369
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0064163208007812
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.6941299438477E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0064432621002197
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0064842700958252
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0040740966797E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.006514310836792
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.2915344238281E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0065572261810303
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.9815902709961E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0065970420837402
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.598762512207E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0066230297088623
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.9815902709961E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0066628456115723
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:27] [debug] SQL: query_duration=1.5020370483398E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0066778659820557
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.7894973754883E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0067057609558105
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.3126602172852E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0067288875579834
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0040740966797E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0067589282989502
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.8848648071289E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0067877769470215
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.3126602172852E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0068109035491943
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.4080276489258E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0068349838256836
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '30'
[2025-03-10 12:00:27] [debug] SQL: query_duration=1.978874206543E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.006854772567749
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.7894973754883E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0068826675415039
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.2172927856445E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0069048404693604
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "tags" WHERE "project_id" = ? ORDER BY "name" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0069408416748047
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "predefined_task_descriptions" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0994415283203E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0069718360900879
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "comment_templates" WHERE "project_id" = ? ORDER BY "title" ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.3126602172852E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0069949626922607
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.5061111450195E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0070400238037109
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "action_has_params"
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.6941299438477E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0070669651031494
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_metadata"."value" FROM "project_has_metadata" WHERE "project_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'prjcoverimage'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.6014785766602E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.007112979888916
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.6941299438477E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0071399211883545
[2025-03-10 12:00:27] [debug] SQL: SELECT (SELECT COUNT(*) FROM comments WHERE task_id=tasks.id) AS nb_comments, (SELECT COUNT(*) FROM task_has_files WHERE task_id=tasks.id) AS nb_files, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id) AS nb_subtasks, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id AND status=2) AS nb_completed_subtasks, (SELECT COUNT(*) FROM task_has_links WHERE task_has_links.task_id = tasks.id) AS nb_links, (SELECT COUNT(*) FROM task_has_external_links WHERE task_has_external_links.task_id = tasks.id) AS nb_external_links, (SELECT DISTINCT 1 FROM task_has_links tl JOIN links l ON tl.link_id = l.id WHERE tl.task_id = tasks.id AND l.label = 'is a milestone of') AS is_milestone, tasks.id, tasks.reference, tasks.title, tasks.description, tasks.date_creation, tasks.date_modification, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.color_id, tasks.project_id, tasks.column_id, tasks.swimlane_id, tasks.owner_id, tasks.creator_id, tasks.position, tasks.is_active, tasks.score, tasks.category_id, tasks.priority, tasks.date_moved, tasks.recurrence_status, tasks.recurrence_trigger, tasks.recurrence_factor, tasks.recurrence_timeframe, tasks.recurrence_basedate, tasks.recurrence_parent, tasks.recurrence_child, tasks.time_estimated, tasks.time_spent, tasks.reference, users.username AS assignee_username, users.name AS assignee_name, users.email AS assignee_email, users.avatar_path AS assignee_avatar_path, project_has_categories.name AS category_name, project_has_categories.description AS category_description, project_has_categories.color_id AS category_color_id, columns.title AS column_name, columns.position AS column_position, swimlanes.name AS swimlane_name, projects.name AS project_name 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC, tasks.date_due ASC LIMIT 15
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00036501884460449
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.007504940032959
[2025-03-10 12:00:27] [debug] SQL: SELECT tags.id, tags.name, tags.color_id, task_has_tags.task_id FROM "tags" LEFT JOIN "task_has_tags" ON "task_has_tags"."tag_id"="tags"."id" WHERE task_has_tags.task_id IN (?, ?) ORDER BY tags.name ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '9'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '222'
[2025-03-10 12:00:27] [debug] SQL: query_duration=7.7009201049805E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0075819492340088
[2025-03-10 12:00:27] [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" IN (?, ?) AND subtasks.user_id = ? ORDER BY subtasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '9'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '222'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00012516975402832
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0077071189880371
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_users"."role" FROM "project_has_users" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.0054321289062E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0077471733093262
[2025-03-10 12:00:27] [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" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'project-manager'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.1021575927734E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0077981948852539
[2025-03-10 12:00:27] [debug] SQL: SELECT (SELECT COUNT(*) FROM comments WHERE task_id=tasks.id) AS nb_comments, (SELECT COUNT(*) FROM task_has_files WHERE task_id=tasks.id) AS nb_files, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id) AS nb_subtasks, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id AND status=2) AS nb_completed_subtasks, (SELECT COUNT(*) FROM task_has_links WHERE task_has_links.task_id = tasks.id) AS nb_links, (SELECT COUNT(*) FROM task_has_external_links WHERE task_has_external_links.task_id = tasks.id) AS nb_external_links, (SELECT DISTINCT 1 FROM task_has_links tl JOIN links l ON tl.link_id = l.id WHERE tl.task_id = tasks.id AND l.label = 'is a milestone of') AS is_milestone, tasks.id, tasks.reference, tasks.title, tasks.description, tasks.date_creation, tasks.date_modification, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.color_id, tasks.project_id, tasks.column_id, tasks.swimlane_id, tasks.owner_id, tasks.creator_id, tasks.position, tasks.is_active, tasks.score, tasks.category_id, tasks.priority, tasks.date_moved, tasks.recurrence_status, tasks.recurrence_trigger, tasks.recurrence_factor, tasks.recurrence_timeframe, tasks.recurrence_basedate, tasks.recurrence_parent, tasks.recurrence_child, tasks.time_estimated, tasks.time_spent, tasks.reference, users.username AS assignee_username, users.name AS assignee_name, users.email AS assignee_email, users.avatar_path AS assignee_avatar_path, project_has_categories.name AS category_name, project_has_categories.description AS category_description, project_has_categories.color_id AS category_color_id, columns.title AS column_name, columns.position AS column_position, swimlanes.name AS swimlane_name, projects.name AS project_name 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC, tasks.date_due ASC LIMIT 15
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00028800964355469
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0080862045288086
[2025-03-10 12:00:27] [debug] SQL: SELECT tags.id, tags.name, tags.color_id, task_has_tags.task_id FROM "tags" LEFT JOIN "task_has_tags" ON "task_has_tags"."tag_id"="tags"."id" WHERE task_has_tags.task_id IN (?) ORDER BY tags.name ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '203'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.103515625E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0081472396850586
[2025-03-10 12:00:27] [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" IN (?) AND subtasks.user_id = ? ORDER BY subtasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '203'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=8.5115432739258E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0082323551177979
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_users"."role" FROM "project_has_users" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '5'
[2025-03-10 12:00:27] [debug] SQL: query_duration=2.9087066650391E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0082614421844482
[2025-03-10 12:00:27] [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" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '5'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'project-manager'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.3882598876953E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0083153247833252
[2025-03-10 12:00:27] [debug] SQL: SELECT (SELECT COUNT(*) FROM comments WHERE task_id=tasks.id) AS nb_comments, (SELECT COUNT(*) FROM task_has_files WHERE task_id=tasks.id) AS nb_files, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id) AS nb_subtasks, (SELECT COUNT(*) FROM subtasks WHERE subtasks.task_id=tasks.id AND status=2) AS nb_completed_subtasks, (SELECT COUNT(*) FROM task_has_links WHERE task_has_links.task_id = tasks.id) AS nb_links, (SELECT COUNT(*) FROM task_has_external_links WHERE task_has_external_links.task_id = tasks.id) AS nb_external_links, (SELECT DISTINCT 1 FROM task_has_links tl JOIN links l ON tl.link_id = l.id WHERE tl.task_id = tasks.id AND l.label = 'is a milestone of') AS is_milestone, tasks.id, tasks.reference, tasks.title, tasks.description, tasks.date_creation, tasks.date_modification, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.color_id, tasks.project_id, tasks.column_id, tasks.swimlane_id, tasks.owner_id, tasks.creator_id, tasks.position, tasks.is_active, tasks.score, tasks.category_id, tasks.priority, tasks.date_moved, tasks.recurrence_status, tasks.recurrence_trigger, tasks.recurrence_factor, tasks.recurrence_timeframe, tasks.recurrence_basedate, tasks.recurrence_parent, tasks.recurrence_child, tasks.time_estimated, tasks.time_spent, tasks.reference, users.username AS assignee_username, users.name AS assignee_name, users.email AS assignee_email, users.avatar_path AS assignee_avatar_path, project_has_categories.name AS category_name, project_has_categories.description AS category_description, project_has_categories.color_id AS category_color_id, columns.title AS column_name, columns.position AS column_position, swimlanes.name AS swimlane_name, projects.name AS project_name 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.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id='1')) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY CASE WHEN tasks.date_due = 0 THEN 1 ELSE 0 END, tasks.date_due ASC, tasks.priority DESC, tasks.position ASC, tasks.date_due ASC LIMIT 15
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[4]: '0'
[2025-03-10 12:00:27] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=0.00026679039001465
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0085821151733398
[2025-03-10 12:00:27] [debug] SQL: SELECT tags.id, tags.name, tags.color_id, task_has_tags.task_id FROM "tags" LEFT JOIN "task_has_tags" ON "task_has_tags"."tag_id"="tags"."id" WHERE task_has_tags.task_id IN (?) ORDER BY tags.name ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '225'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.2942504882812E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0086450576782227
[2025-03-10 12:00:27] [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" IN (?) AND subtasks.user_id = ? ORDER BY subtasks.position ASC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '225'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=9.2983245849609E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0087380409240723
[2025-03-10 12:00:27] [debug] SQL: SELECT "project_has_users"."role" FROM "project_has_users" WHERE "user_id" = ? AND "project_id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '7'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.0040740966797E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0087680816650391
[2025-03-10 12:00:27] [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" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'project-manager'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1961669921875E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0088100433349609
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.887580871582E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0088589191436768
[2025-03-10 12:00:27] [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 (?)
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=5.1975250244141E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0089108943939209
[2025-03-10 12:00:27] [debug] SQL: SELECT 1 FROM "user_has_unread_notifications" WHERE "user_id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=9.2983245849609E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0090038776397705
[2025-03-10 12:00:27] [debug] SQL: SELECT tasks.id, tasks.title, projects.name AS project_name FROM "tasks" LEFT JOIN "projects" ON "projects"."id"="tasks"."project_id" WHERE projects.is_active = ? AND tasks.is_active = ? AND tasks.owner_id = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=6.2227249145508E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.009066104888916
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "starred_projects" LEFT JOIN "projects" ON "projects"."id"="starred_projects"."project_id" WHERE "user_id" = ? ORDER BY projects.last_modified DESC
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: query_duration=9.0837478637695E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0091569423675537
[2025-03-10 12:00:27] [debug] SQL: SELECT * FROM "projects" WHERE "id" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '2'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.4107437133789E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0092010498046875
[2025-03-10 12:00:27] [debug] SQL: SELECT "user_has_metadata"."value" FROM "user_has_metadata" WHERE "user_id" = ? AND "name" = ? LIMIT 1
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'starredprojects_only_starred_in_project_selector'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.1007995605469E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.009242057800293
[2025-03-10 12:00:27] [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=3.1948089599609E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0092740058898926
[2025-03-10 12:00:27] [debug] SQL: UPDATE "sessions" SET "expire_at"=?, "data"=? WHERE "id" = ?
[2025-03-10 12:00:27] [debug] SQL: param[1]: '1741605867'
[2025-03-10 12:00:27] [debug] SQL: param[2]: 'user|a:24:{s:2:"id";i:1;s:8:"username";s:5:"admin";s:12:"is_ldap_user";b:0;s:4:"name";s:12:"Herz Hermann";s:5:"email";s:19:"heart1010@gmail.com";s:9:"google_id";N;s:9:"github_id";N;s:21:"notifications_enabled";i:1;s:8:"timezone";s:13:"Europe/Berlin";s:8:"language";s:8:"de_DE_du";s:18:"disable_login_form";i:0;s:19:"twofactor_activated";b:0;s:16:"twofactor_secret";N;s:5:"token";s:0:"";s:20:"notifications_filter";i:4;s:15:"nb_failed_login";i:0;s:20:"lock_expiration_date";i:0;s:9:"gitlab_id";N;s:4:"role";s:9:"app-admin";s:9:"is_active";i:1;s:11:"avatar_path";s:50:"avatars/1/dba1e55a8250a0afdb5f073e2a88704a9413f17d";s:16:"api_access_token";N;s:6:"filter";s:0:"";s:5:"theme";s:5:"light";}postAuthenticationValidated|b:1;filters:7|s:11:"status:open";pcsrf_key|s:64:"fc28b67d8ff5e88085b590467bdc9231792ef5da845e814ac834f16782b9e830";csrf_key|s:64:"214ef4a1a5f7e52a8fac76d5a1a6854d5d0a5353dfdc27007a013b7a95330ddd";hasSubtaskInProgress|b:0;filters:2|s:11:"status:open";filters:4|s:11:"status:open";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";filters:1|s:11:"status:open";'
[2025-03-10 12:00:27] [debug] SQL: param[3]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:27] [debug] SQL: query_duration=4.2200088500977E-5
[2025-03-10 12:00:27] [debug] SQL: total_execution_time=0.0093162059783936
[2025-03-10 12:00:27] [debug] APP: nb_queries=116
[2025-03-10 12:00:27] [debug] APP: rendering_time=0.17834615707397
[2025-03-10 12:00:27] [debug] APP: memory_usage=1.79M
[2025-03-10 12:00:27] [debug] APP: uri=/plugins/TodoNotes/Template/notifications/service_worker.php
[2025-03-10 12:00:27] [debug] ###############################################
[2025-03-10 11:00:35] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2025-03-10 11:00:35] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2025-03-10 12:00:35] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2025-03-10 12:00:35] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2025-03-10 12:00:35] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2025-03-10 12:00:35] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2025-03-10 12:00:35] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\BoardAjaxController::check
[2025-03-10 12:00:35] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:35] [debug] SQL: param[1]: 'wiki'
[2025-03-10 12:00:35] [debug] SQL: query_duration=0.00011301040649414
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00011301040649414
[2025-03-10 12:00:35] [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"
[2025-03-10 12:00:35] [debug] SQL: query_duration=0.00010800361633301
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00022101402282715
[2025-03-10 12:00:35] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:35] [debug] SQL: param[1]: 'templatemanager'
[2025-03-10 12:00:35] [debug] SQL: query_duration=7.0095062255859E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00029110908508301
[2025-03-10 12:00:35] [debug] SQL: SELECT 1 FROM "settings" WHERE "option" = ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:35] [debug] SQL: query_duration=3.0994415283203E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00032210350036621
[2025-03-10 12:00:35] [debug] SQL: UPDATE "settings" SET "value"=?, "changed_on"=?, "changed_by"=? WHERE "option" = ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: ''
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1741604435'
[2025-03-10 12:00:35] [debug] SQL: param[3]: '0'
[2025-03-10 12:00:35] [debug] SQL: param[4]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:35] [debug] SQL: query_duration=3.6001205444336E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00035810470581055
[2025-03-10 12:00:35] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:35] [debug] SQL: param[1]: 'subtaskdate'
[2025-03-10 12:00:35] [debug] SQL: query_duration=4.9114227294922E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00040721893310547
[2025-03-10 12:00:35] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:35] [debug] SQL: param[1]: 'starredprojects'
[2025-03-10 12:00:35] [debug] SQL: query_duration=4.0054321289062E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00044727325439453
[2025-03-10 12:00:35] [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? AND "expire_at" > ? LIMIT 1
[2025-03-10 12:00:35] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1741604435'
[2025-03-10 12:00:35] [debug] SQL: query_duration=7.9154968261719E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00052642822265625
[2025-03-10 12:00:35] [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 (?)
[2025-03-10 12:00:35] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:35] [debug] SQL: query_duration=0.0001060962677002
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00063252449035645
[2025-03-10 12:00:35] [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 (?)
[2025-03-10 12:00:35] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:35] [debug] SQL: query_duration=8.8930130004883E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00072145462036133
[2025-03-10 12:00:35] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" IN (?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:35] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:35] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:35] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:35] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:35] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:35] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:35] [debug] SQL: query_duration=4.887580871582E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00077033042907715
[2025-03-10 12:00:35] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:35] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:35] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:35] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:35] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:35] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:35] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:35] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:35] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:35] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:35] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:35] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:35] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:35] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:35] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:35] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:35] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:35] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:35] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:35] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:35] [debug] SQL: param[21]: '30'
[2025-03-10 12:00:35] [debug] SQL: query_duration=6.0081481933594E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00083041191101074
[2025-03-10 12:00:35] [debug] SQL: SELECT 1 FROM "users" WHERE "id" = ? AND "is_active" = ? AND "role" = ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:35] [debug] SQL: param[3]: 'app-admin'
[2025-03-10 12:00:35] [debug] SQL: query_duration=4.6014785766602E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00087642669677734
[2025-03-10 12:00:35] [debug] SQL: SELECT COUNT(*) FROM "projects" WHERE "id" = ? AND "last_modified" > ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:35] [debug] SQL: param[2]: '1741604424'
[2025-03-10 12:00:35] [debug] SQL: query_duration=4.0054321289062E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00091648101806641
[2025-03-10 12:00:35] [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:35] [debug] SQL: query_duration=2.6941299438477E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00094342231750488
[2025-03-10 12:00:35] [debug] SQL: UPDATE "sessions" SET "expire_at"=?, "data"=? WHERE "id" = ?
[2025-03-10 12:00:35] [debug] SQL: param[1]: '1741605875'
[2025-03-10 12:00:35] [debug] SQL: param[2]: 'user|a:24:{s:2:"id";i:1;s:8:"username";s:5:"admin";s:12:"is_ldap_user";b:0;s:4:"name";s:12:"Herz Hermann";s:5:"email";s:19:"heart1010@gmail.com";s:9:"google_id";N;s:9:"github_id";N;s:21:"notifications_enabled";i:1;s:8:"timezone";s:13:"Europe/Berlin";s:8:"language";s:8:"de_DE_du";s:18:"disable_login_form";i:0;s:19:"twofactor_activated";b:0;s:16:"twofactor_secret";N;s:5:"token";s:0:"";s:20:"notifications_filter";i:4;s:15:"nb_failed_login";i:0;s:20:"lock_expiration_date";i:0;s:9:"gitlab_id";N;s:4:"role";s:9:"app-admin";s:9:"is_active";i:1;s:11:"avatar_path";s:50:"avatars/1/dba1e55a8250a0afdb5f073e2a88704a9413f17d";s:16:"api_access_token";N;s:6:"filter";s:0:"";s:5:"theme";s:5:"light";}postAuthenticationValidated|b:1;filters:7|s:11:"status:open";pcsrf_key|s:64:"fc28b67d8ff5e88085b590467bdc9231792ef5da845e814ac834f16782b9e830";csrf_key|s:64:"214ef4a1a5f7e52a8fac76d5a1a6854d5d0a5353dfdc27007a013b7a95330ddd";hasSubtaskInProgress|b:0;filters:2|s:11:"status:open";filters:4|s:11:"status:open";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";filters:1|s:11:"status:open";'
[2025-03-10 12:00:35] [debug] SQL: param[3]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:35] [debug] SQL: query_duration=3.0994415283203E-5
[2025-03-10 12:00:35] [debug] SQL: total_execution_time=0.00097441673278809
[2025-03-10 12:00:35] [debug] APP: nb_queries=16
[2025-03-10 12:00:35] [debug] APP: rendering_time=0.12364411354065
[2025-03-10 12:00:35] [debug] APP: memory_usage=1.43M
[2025-03-10 12:00:35] [debug] APP: uri=/?controller=BoardAjaxController&action=check&project_id=7×tamp=1741604424&csrf_token=fcef17b5fa0c4095a3ef55bfb99737c4ba38bb76b54da3d6651b51789417af09&_=1741604434869
[2025-03-10 12:00:35] [debug] ###############################################
[2025-03-10 11:00:45] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[2025-03-10 11:00:45] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2025-03-10 12:00:45] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[2025-03-10 12:00:45] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[2025-03-10 12:00:45] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[2025-03-10 12:00:45] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[2025-03-10 12:00:45] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\BoardAjaxController::check
[2025-03-10 12:00:45] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:45] [debug] SQL: param[1]: 'wiki'
[2025-03-10 12:00:45] [debug] SQL: query_duration=0.00015115737915039
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00015115737915039
[2025-03-10 12:00:45] [debug] SQL: SELECT "settings"."option", "settings"."value" FROM "settings"
[2025-03-10 12:00:45] [debug] SQL: query_duration=0.00012302398681641
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.0002741813659668
[2025-03-10 12:00:45] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:45] [debug] SQL: param[1]: 'templatemanager'
[2025-03-10 12:00:45] [debug] SQL: query_duration=6.4849853515625E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00033903121948242
[2025-03-10 12:00:45] [debug] SQL: SELECT 1 FROM "settings" WHERE "option" = ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:45] [debug] SQL: query_duration=6.3896179199219E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00040292739868164
[2025-03-10 12:00:45] [debug] SQL: UPDATE "settings" SET "value"=?, "changed_on"=?, "changed_by"=? WHERE "option" = ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: ''
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1741604445'
[2025-03-10 12:00:45] [debug] SQL: param[3]: '0'
[2025-03-10 12:00:45] [debug] SQL: param[4]: 'mailmagik_exclude_files_pattern'
[2025-03-10 12:00:45] [debug] SQL: query_duration=4.2915344238281E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00044584274291992
[2025-03-10 12:00:45] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:45] [debug] SQL: param[1]: 'subtaskdate'
[2025-03-10 12:00:45] [debug] SQL: query_duration=4.9114227294922E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00049495697021484
[2025-03-10 12:00:45] [debug] SQL: SELECT "plugin_schema_versions"."version" FROM "plugin_schema_versions" WHERE "plugin" = ? LIMIT 1
[2025-03-10 12:00:45] [debug] SQL: param[1]: 'starredprojects'
[2025-03-10 12:00:45] [debug] SQL: query_duration=5.0067901611328E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00054502487182617
[2025-03-10 12:00:45] [debug] SQL: SELECT "sessions"."data" FROM "sessions" WHERE "id" = ? AND "expire_at" > ? LIMIT 1
[2025-03-10 12:00:45] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1741604445'
[2025-03-10 12:00:45] [debug] SQL: query_duration=8.9168548583984E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00063419342041016
[2025-03-10 12:00:45] [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 (?)
[2025-03-10 12:00:45] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:45] [debug] SQL: query_duration=7.8916549682617E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00071310997009277
[2025-03-10 12:00:45] [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 (?)
[2025-03-10 12:00:45] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:45] [debug] SQL: query_duration=9.2029571533203E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00080513954162598
[2025-03-10 12:00:45] [debug] SQL: SELECT * FROM "actions" WHERE "project_id" IN (?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:45] [debug] SQL: param[1]: '4'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '3'
[2025-03-10 12:00:45] [debug] SQL: param[3]: '2'
[2025-03-10 12:00:45] [debug] SQL: param[4]: '5'
[2025-03-10 12:00:45] [debug] SQL: param[5]: '6'
[2025-03-10 12:00:45] [debug] SQL: param[6]: '7'
[2025-03-10 12:00:45] [debug] SQL: param[7]: '1'
[2025-03-10 12:00:45] [debug] SQL: query_duration=5.1021575927734E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00085616111755371
[2025-03-10 12:00:45] [debug] SQL: SELECT * FROM "action_has_params" WHERE "action_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2025-03-10 12:00:45] [debug] SQL: param[1]: '3'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '4'
[2025-03-10 12:00:45] [debug] SQL: param[3]: '5'
[2025-03-10 12:00:45] [debug] SQL: param[4]: '6'
[2025-03-10 12:00:45] [debug] SQL: param[5]: '7'
[2025-03-10 12:00:45] [debug] SQL: param[6]: '8'
[2025-03-10 12:00:45] [debug] SQL: param[7]: '9'
[2025-03-10 12:00:45] [debug] SQL: param[8]: '17'
[2025-03-10 12:00:45] [debug] SQL: param[9]: '18'
[2025-03-10 12:00:45] [debug] SQL: param[10]: '19'
[2025-03-10 12:00:45] [debug] SQL: param[11]: '20'
[2025-03-10 12:00:45] [debug] SQL: param[12]: '21'
[2025-03-10 12:00:45] [debug] SQL: param[13]: '22'
[2025-03-10 12:00:45] [debug] SQL: param[14]: '23'
[2025-03-10 12:00:45] [debug] SQL: param[15]: '24'
[2025-03-10 12:00:45] [debug] SQL: param[16]: '25'
[2025-03-10 12:00:45] [debug] SQL: param[17]: '26'
[2025-03-10 12:00:45] [debug] SQL: param[18]: '27'
[2025-03-10 12:00:45] [debug] SQL: param[19]: '28'
[2025-03-10 12:00:45] [debug] SQL: param[20]: '29'
[2025-03-10 12:00:45] [debug] SQL: param[21]: '30'
[2025-03-10 12:00:45] [debug] SQL: query_duration=6.2942504882812E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.00091910362243652
[2025-03-10 12:00:45] [debug] SQL: SELECT 1 FROM "users" WHERE "id" = ? AND "is_active" = ? AND "role" = ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: '1'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1'
[2025-03-10 12:00:45] [debug] SQL: param[3]: 'app-admin'
[2025-03-10 12:00:45] [debug] SQL: query_duration=5.6982040405273E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.0009760856628418
[2025-03-10 12:00:45] [debug] SQL: SELECT COUNT(*) FROM "projects" WHERE "id" = ? AND "last_modified" > ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: '7'
[2025-03-10 12:00:45] [debug] SQL: param[2]: '1741604424'
[2025-03-10 12:00:45] [debug] SQL: query_duration=4.5061111450195E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.001021146774292
[2025-03-10 12:00:45] [debug] SQL: SELECT 1 FROM "sessions" WHERE "id" = ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:45] [debug] SQL: query_duration=3.2186508178711E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.0010533332824707
[2025-03-10 12:00:45] [debug] SQL: UPDATE "sessions" SET "expire_at"=?, "data"=? WHERE "id" = ?
[2025-03-10 12:00:45] [debug] SQL: param[1]: '1741605885'
[2025-03-10 12:00:45] [debug] SQL: param[2]: 'user|a:24:{s:2:"id";i:1;s:8:"username";s:5:"admin";s:12:"is_ldap_user";b:0;s:4:"name";s:12:"Herz Hermann";s:5:"email";s:19:"heart1010@gmail.com";s:9:"google_id";N;s:9:"github_id";N;s:21:"notifications_enabled";i:1;s:8:"timezone";s:13:"Europe/Berlin";s:8:"language";s:8:"de_DE_du";s:18:"disable_login_form";i:0;s:19:"twofactor_activated";b:0;s:16:"twofactor_secret";N;s:5:"token";s:0:"";s:20:"notifications_filter";i:4;s:15:"nb_failed_login";i:0;s:20:"lock_expiration_date";i:0;s:9:"gitlab_id";N;s:4:"role";s:9:"app-admin";s:9:"is_active";i:1;s:11:"avatar_path";s:50:"avatars/1/dba1e55a8250a0afdb5f073e2a88704a9413f17d";s:16:"api_access_token";N;s:6:"filter";s:0:"";s:5:"theme";s:5:"light";}postAuthenticationValidated|b:1;filters:7|s:11:"status:open";pcsrf_key|s:64:"fc28b67d8ff5e88085b590467bdc9231792ef5da845e814ac834f16782b9e830";csrf_key|s:64:"214ef4a1a5f7e52a8fac76d5a1a6854d5d0a5353dfdc27007a013b7a95330ddd";hasSubtaskInProgress|b:0;filters:2|s:11:"status:open";filters:4|s:11:"status:open";filters:3|s:11:"status:open";filters:5|s:11:"status:open";filters:6|s:11:"status:open";filters:1|s:11:"status:open";'
[2025-03-10 12:00:45] [debug] SQL: param[3]: '6ar0mte3i9n96ib3q93sqc47b6'
[2025-03-10 12:00:45] [debug] SQL: query_duration=5.2928924560547E-5
[2025-03-10 12:00:45] [debug] SQL: total_execution_time=0.0011062622070312
[2025-03-10 12:00:45] [debug] APP: nb_queries=16
[2025-03-10 12:00:45] [debug] APP: rendering_time=0.11653304100037
[2025-03-10 12:00:45] [debug] APP: memory_usage=1.43M
[2025-03-10 12:00:45] [debug] APP: uri=/?controller=BoardAjaxController&action=check&project_id=7×tamp=1741604424&csrf_token=fcef17b5fa0c4095a3ef55bfb99737c4ba38bb76b54da3d6651b51789417af09&_=1741604434870
[2025-03-10 12:00:45] [debug] ###############################################
^C
Editor is loading...
Leave a Comment