C:\xampp\mysql\bin\mysqld.exe, Version: 10.4.28-MariaDB-log (mariadb.org binary distribution). started with:
TCP Port: 3306, Named Pipe: C:/xampp/mysql/mysql.sock
Time		    Id Command	Argument
# Time: 240313 16:03:45
# User@Host: root[root] @ localhost [::1]
# Thread_id: 41  Schema: espocrm2  QC_hit: No
# Query_time: 10.548493  Lock_time: 0.033966  Rows_sent: 1  Rows_examined: 188930
# Rows_affected: 0  Bytes_sent: 1764
use espocrm2;
SET timestamp=1710342225;
SELECT task.id AS `id`, task.name AS `name`, task.deleted AS `deleted`, task.status AS `status`, task.priority AS `priority`, task.date_start AS `dateStart`, task.date_end AS `dateEnd`, task.date_start_date AS `dateStartDate`, task.date_end_date AS `dateEndDate`, task.date_completed AS `dateCompleted`, task.description AS `description`, task.created_at AS `createdAt`, task.modified_at AS `modifiedAt`, task.parent_id AS `parentId`, task.parent_type AS `parentType`, task.account_id AS `accountId`, account.name AS `accountName`, task.contact_id AS `contactId`, NULLIF(TRIM(CONCAT(IFNULL(contact.first_name, ''), ' ', IFNULL(contact.last_name, ''))), '') AS `contactName`, task.created_by_id AS `createdById`, NULLIF(TRIM(CONCAT(IFNULL(createdBy.first_name, ''), ' ', IFNULL(createdBy.last_name, ''))), '') AS `createdByName`, task.modified_by_id AS `modifiedById`, NULLIF(TRIM(CONCAT(IFNULL(modifiedBy.first_name, ''), ' ', IFNULL(modifiedBy.last_name, ''))), '') AS `modifiedByName`, task.assigned_user_id AS `assignedUserId`, NULLIF(TRIM(CONCAT(IFNULL(assignedUser.first_name, ''), ' ', IFNULL(assignedUser.last_name, ''))), '') AS `assignedUserName`, task.email_id AS `emailId`, email.name AS `emailName` FROM `task` AS `task` LEFT JOIN `email` AS `email` ON task.email_id = email.id LEFT JOIN `contact` AS `contact` ON task.contact_id = contact.id LEFT JOIN `account` AS `account` ON task.account_id = account.id LEFT JOIN `user` AS `assignedUser` ON task.assigned_user_id = assignedUser.id LEFT JOIN `user` AS `modifiedBy` ON task.modified_by_id = modifiedBy.id LEFT JOIN `user` AS `createdBy` ON task.created_by_id = createdBy.id WHERE task.id = '65eb2094bcbdb6826' AND task.deleted = 0;
# Time: 240313 16:03:46
# User@Host: root[root] @ localhost [::1]
# Thread_id: 40  Schema: espocrm2  QC_hit: No
# Query_time: 10.148018  Lock_time: 0.000596  Rows_sent: 1  Rows_examined: 188930
# Rows_affected: 0  Bytes_sent: 1764
SET timestamp=1710342226;
SELECT task.id AS `id`, task.name AS `name`, task.deleted AS `deleted`, task.status AS `status`, task.priority AS `priority`, task.date_start AS `dateStart`, task.date_end AS `dateEnd`, task.date_start_date AS `dateStartDate`, task.date_end_date AS `dateEndDate`, task.date_completed AS `dateCompleted`, task.description AS `description`, task.created_at AS `createdAt`, task.modified_at AS `modifiedAt`, task.parent_id AS `parentId`, task.parent_type AS `parentType`, task.account_id AS `accountId`, account.name AS `accountName`, task.contact_id AS `contactId`, NULLIF(TRIM(CONCAT(IFNULL(contact.first_name, ''), ' ', IFNULL(contact.last_name, ''))), '') AS `contactName`, task.created_by_id AS `createdById`, NULLIF(TRIM(CONCAT(IFNULL(createdBy.first_name, ''), ' ', IFNULL(createdBy.last_name, ''))), '') AS `createdByName`, task.modified_by_id AS `modifiedById`, NULLIF(TRIM(CONCAT(IFNULL(modifiedBy.first_name, ''), ' ', IFNULL(modifiedBy.last_name, ''))), '') AS `modifiedByName`, task.assigned_user_id AS `assignedUserId`, NULLIF(TRIM(CONCAT(IFNULL(assignedUser.first_name, ''), ' ', IFNULL(assignedUser.last_name, ''))), '') AS `assignedUserName`, task.email_id AS `emailId`, email.name AS `emailName` FROM `task` AS `task` LEFT JOIN `email` AS `email` ON task.email_id = email.id LEFT JOIN `contact` AS `contact` ON task.contact_id = contact.id LEFT JOIN `account` AS `account` ON task.account_id = account.id LEFT JOIN `user` AS `assignedUser` ON task.assigned_user_id = assignedUser.id LEFT JOIN `user` AS `modifiedBy` ON task.modified_by_id = modifiedBy.id LEFT JOIN `user` AS `createdBy` ON task.created_by_id = createdBy.id WHERE task.id = '65eb2094bcbdb6826' AND task.deleted = 0 ORDER BY task.created_at DESC, task.id DESC LIMIT 0, 1;