6a3a2ec20050d: POST https://beta.jinchangxiao.com/v2/task/save-edit-group at 2026-06-23 02:59:13 pm by 223.104.40.22
Database Queries
总计234条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:59:14.006 | 0.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC' |
| 14:59:14.008 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:14.010 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='106' |
| 14:59:14.013 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1000) AND ("task_group_id"=106) |
| 14:59:14.015 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982') |
| 14:59:14.016 | 1.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1018') |
| 14:59:14.018 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 14:59:14.018 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 14:59:14.020 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:14.021 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:14.022 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:14.022 | 6.2 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_object_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:59:14.029 | 4.5 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_object_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:59:14.035 | 24.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'target_completed_at', 106, 102, 1000, 'now()', '["2027-03-01 00:00:00"]', '["2027-03-01 23:59:00"]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u622a\u6b62\u65e5\u671f","d4":["2027-03-01 23:59:00 <b>\u53d8\u4e3a<\/b> 2027-03-01 00:00:00"]}'), (2, 'situation', 106, 102, 1000, 'now()', '["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1a"]', '["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u60c5\u51b5\u8bf4\u660e","d4":["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1 <b>\u53d8\u4e3a<\/b> 2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1a"]}'), (2, 'progress', 106, 102, 1000, 'now()', '[0]', '[89]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee\u8fdb\u5ea6","d4":["89 <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}') |
| 14:59:14.060 | 3.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=982, "target_completed_at"='2027-03-01', "updated_at"='now()', "situation"='2020年2月开发部任务a', "start_at"='2020-02-10', "project_id"=1018, "progress"=0 WHERE "id"=106 |
| 14:59:14.065 | 3.3 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:59:14.068 | 4.0 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:59:14.073 | 21.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 106, 'a:3:{s:19:"target_completed_at";s:19:"2027-03-01 00:00:00";s:8:"progress";i:89;s:9:"situation";s:27:"2020年2月开发部任务a";}', '', 1000, '223.104.40.22') |
| 14:59:14.095 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=106 |
| 14:59:14.095 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5461, 5064) |
| 14:59:14.096 | 1.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=106 |
| 14:59:14.098 | 12.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (106, 1000), (106, 5064), (106, 5250), (106, 5461) |
| 14:59:14.111 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=106 |
| 14:59:14.112 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 1000, 5461, 5250) |
| 14:59:14.112 | 3.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=106 |
| 14:59:14.116 | 6.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (106, 1000), (106, 5250), (106, 5461), (106, 5064) |
| 14:59:14.123 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=106) AND ("status"=0) AND ("head_of" NOT IN ('1000', '5064', '5250', '5461')) |
| 14:59:14.124 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
| 14:59:14.163 | 6.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982 |
| 14:59:14.176 | 1535.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:59:15.712 | 4.1 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_client_am_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:59:15.717 | 4.8 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_client_am_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:59:15.723 | 3.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
| 14:59:15.727 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 200024, 'a:5:{s:2:"id";i:200024;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.40.22') |
| 14:59:15.728 | 1.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:15.730 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:15.731 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 982, 10, 106, 102, 1000, '[106]', '[106]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"]}') RETURNING "id" |
| 14:59:15.734 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 642485, 'a:13:{s:2:"id";i:642485;s:9:"object_id";s:3:"982";s:11:"object_type";i:10;s:9:"target_id";i:106;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[106]";s:9:"new_value";s:5:"[106]";s:11:"description";s:130:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.40.22') |
| 14:59:15.736 | 4.2 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_projects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:59:15.741 | 6.5 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_projects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:59:15.748 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1018' |
| 14:59:15.751 | 3.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=1018 |
| 14:59:15.757 | 9.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=1018) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:59:15.766 | 3.3 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_project_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:59:15.770 | 4.6 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_project_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:59:15.775 | 2.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 1018, 'a:1:{s:6:"end_at";s:19:"2022-08-02 11:44:02";}', '', 1000, '223.104.40.22') |
| 14:59:15.778 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 14:59:15.779 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:59:15.780 | 1.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 1018, 1, 106, 102, 1000, '[106]', '[106]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"]}') RETURNING "id" |
| 14:59:15.782 | 2.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 642486, 'a:13:{s:2:"id";i:642486;s:9:"object_id";s:4:"1018";s:11:"object_type";i:1;s:9:"target_id";i:106;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[106]";s:9:"new_value";s:5:"[106]";s:11:"description";s:130:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.40.22') |
| 14:59:15.785 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=106) |
| 14:59:15.787 | 3.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1353, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:02";}', '', 1000, '223.104.40.22') |
| 14:59:15.790 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1353 |
| 14:59:15.791 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1353, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:02";}', '', 1000, '223.104.40.22') |
| 14:59:15.792 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.793 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1353, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:02";}', '', 1000, '223.104.40.22') |
| 14:59:15.795 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1723, 'a:1:{s:12:"completed_at";s:19:"2026-06-12 17:07:05";}', '', 1000, '223.104.40.22') |
| 14:59:15.797 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1723 |
| 14:59:15.797 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1723, 'a:1:{s:12:"completed_at";s:19:"2026-06-12 17:07:05";}', '', 1000, '223.104.40.22') |
| 14:59:15.799 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.800 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1723, 'a:1:{s:12:"completed_at";s:19:"2026-06-12 17:07:05";}', '', 1000, '223.104.40.22') |
| 14:59:15.801 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1356, 'a:1:{s:12:"completed_at";s:19:"2020-02-22 00:10:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.802 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1356 |
| 14:59:15.803 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1356, 'a:1:{s:12:"completed_at";s:19:"2020-02-22 00:10:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.805 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.805 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1356, 'a:1:{s:12:"completed_at";s:19:"2020-02-22 00:10:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.807 | 1.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1357, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:19:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.809 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1357 |
| 14:59:15.809 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1357, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:19:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.812 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.812 | 3.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1357, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:19:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.816 | 4.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1350, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.820 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1350 |
| 14:59:15.821 | 3.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1350, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.825 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.826 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1350, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.828 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1349, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:16";}', '', 1000, '223.104.40.22') |
| 14:59:15.830 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1349 |
| 14:59:15.831 | 2.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1349, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:16";}', '', 1000, '223.104.40.22') |
| 14:59:15.834 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.835 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1349, 'a:1:{s:12:"completed_at";s:19:"2020-02-29 00:20:16";}', '', 1000, '223.104.40.22') |
| 14:59:15.837 | 2.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1358, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:41";}', '', 1000, '223.104.40.22') |
| 14:59:15.839 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1358 |
| 14:59:15.840 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1358, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:41";}', '', 1000, '223.104.40.22') |
| 14:59:15.842 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.843 | 3.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1358, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:41";}', '', 1000, '223.104.40.22') |
| 14:59:15.846 | 3.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1347, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.850 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1347 |
| 14:59:15.851 | 3.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1347, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.854 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.855 | 2.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1347, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.858 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1338, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:04";}', '', 1000, '223.104.40.22') |
| 14:59:15.859 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1338 |
| 14:59:15.860 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1338, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:04";}', '', 1000, '223.104.40.22') |
| 14:59:15.861 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.862 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1338, 'a:1:{s:12:"completed_at";s:19:"2020-12-23 14:04:04";}', '', 1000, '223.104.40.22') |
| 14:59:15.863 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1348, 'a:1:{s:12:"completed_at";s:19:"2020-02-14 23:02:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.865 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1348 |
| 14:59:15.865 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1348, 'a:1:{s:12:"completed_at";s:19:"2020-02-14 23:02:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.867 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.867 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1348, 'a:1:{s:12:"completed_at";s:19:"2020-02-14 23:02:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.870 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1359, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:39";}', '', 1000, '223.104.40.22') |
| 14:59:15.872 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1359 |
| 14:59:15.873 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1359, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:39";}', '', 1000, '223.104.40.22') |
| 14:59:15.874 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.875 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1359, 'a:1:{s:12:"completed_at";s:19:"2020-03-05 19:06:39";}', '', 1000, '223.104.40.22') |
| 14:59:15.876 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1586, 'a:1:{s:12:"completed_at";s:19:"2026-04-23 23:53:09";}', '', 1000, '223.104.40.22') |
| 14:59:15.878 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1586 |
| 14:59:15.879 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1586, 'a:1:{s:12:"completed_at";s:19:"2026-04-23 23:53:09";}', '', 1000, '223.104.40.22') |
| 14:59:15.880 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.880 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1586, 'a:1:{s:12:"completed_at";s:19:"2026-04-23 23:53:09";}', '', 1000, '223.104.40.22') |
| 14:59:15.882 | 1.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=100 WHERE "id"=1647 |
| 14:59:15.883 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1647, 'a:5:{s:19:"target_completed_at";s:19:"2026-06-16 00:00:00";s:12:"completed_at";s:19:"2026-06-16 09:16:08";s:8:"progress";i:100;s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-16 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.885 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1647 |
| 14:59:15.886 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1702, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 10:00:51";}', '', 1000, '223.104.40.22') |
| 14:59:15.888 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1693, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 09:59:22";}', '', 1000, '223.104.40.22') |
| 14:59:15.890 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1691, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:30:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.891 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1694, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 09:59:45";}', '', 1000, '223.104.40.22') |
| 14:59:15.893 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1650, 'a:1:{s:12:"completed_at";s:19:"2026-05-31 16:36:11";}', '', 1000, '223.104.40.22') |
| 14:59:15.894 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1651, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:12:35";}', '', 1000, '223.104.40.22') |
| 14:59:15.896 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1689, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:24:47";}', '', 1000, '223.104.40.22') |
| 14:59:15.897 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1690, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:26:42";}', '', 1000, '223.104.40.22') |
| 14:59:15.900 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1648, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:25:07";}', '', 1000, '223.104.40.22') |
| 14:59:15.901 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1692, 'a:1:{s:12:"completed_at";s:19:"2026-06-07 15:28:04";}', '', 1000, '223.104.40.22') |
| 14:59:15.902 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1701, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 10:00:17";}', '', 1000, '223.104.40.22') |
| 14:59:15.904 | 1.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1688, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:15.906 | 2.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=92 WHERE "id"=1647 |
| 14:59:15.908 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1647, 'a:5:{s:19:"target_completed_at";s:19:"2026-06-16 00:00:00";s:12:"completed_at";s:19:"2026-06-16 09:16:08";s:8:"progress";i:92;s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-16 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.910 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.911 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1647, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-16 00:00:00";s:12:"completed_at";s:19:"2026-06-16 09:16:08";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-16 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.913 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.914 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1652 |
| 14:59:15.915 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1654, 'a:1:{s:12:"completed_at";s:19:"2026-05-31 17:04:24";}', '', 1000, '223.104.40.22') |
| 14:59:15.917 | 2.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1653, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-08 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:43";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.919 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.921 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.922 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.925 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1686 |
| 14:59:15.926 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1686, 'a:3:{s:19:"target_completed_at";s:19:"2026-06-08 00:00:00";s:8:"start_at";s:19:"2026-06-07 00:00:00";s:6:"end_at";s:19:"2026-06-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.928 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.928 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1686, 'a:3:{s:19:"target_completed_at";s:19:"2026-06-08 00:00:00";s:8:"start_at";s:19:"2026-06-07 00:00:00";s:6:"end_at";s:19:"2026-06-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.930 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1684, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:09:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.931 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1684 |
| 14:59:15.932 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1684, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:09:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.935 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.936 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1684, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:09:13";}', '', 1000, '223.104.40.22') |
| 14:59:15.937 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1683, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:07:03";}', '', 1000, '223.104.40.22') |
| 14:59:15.939 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1683 |
| 14:59:15.940 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1683, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:07:03";}', '', 1000, '223.104.40.22') |
| 14:59:15.941 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.942 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1683, 'a:1:{s:12:"completed_at";s:19:"2026-06-06 11:07:03";}', '', 1000, '223.104.40.22') |
| 14:59:15.943 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1687, 'a:1:{s:12:"completed_at";s:19:"2026-06-09 21:13:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.944 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1687 |
| 14:59:15.945 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1687, 'a:1:{s:12:"completed_at";s:19:"2026-06-09 21:13:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.947 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.948 | 4.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1687, 'a:1:{s:12:"completed_at";s:19:"2026-06-09 21:13:34";}', '', 1000, '223.104.40.22') |
| 14:59:15.953 | 3.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1697, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-08 00:00:00";s:12:"completed_at";s:19:"2026-06-09 21:00:46";s:8:"start_at";s:19:"2026-06-08 00:00:00";s:6:"end_at";s:19:"2026-08-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.957 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1697 |
| 14:59:15.958 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1697, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-08 00:00:00";s:12:"completed_at";s:19:"2026-06-09 21:00:46";s:8:"start_at";s:19:"2026-06-08 00:00:00";s:6:"end_at";s:19:"2026-08-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.959 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.960 | 1.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1697, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-08 00:00:00";s:12:"completed_at";s:19:"2026-06-09 21:00:46";s:8:"start_at";s:19:"2026-06-08 00:00:00";s:6:"end_at";s:19:"2026-08-08 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.961 | 2.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1696, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 21:40:48";}', '', 1000, '223.104.40.22') |
| 14:59:15.964 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1696 |
| 14:59:15.965 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1696, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 21:40:48";}', '', 1000, '223.104.40.22') |
| 14:59:15.966 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.967 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1696, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 21:40:48";}', '', 1000, '223.104.40.22') |
| 14:59:15.969 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1641, 'a:4:{s:19:"target_completed_at";s:19:"2026-05-31 00:00:00";s:12:"completed_at";s:19:"2026-06-10 21:53:45";s:8:"start_at";s:19:"2026-05-29 00:00:00";s:6:"end_at";s:19:"2026-05-31 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.970 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1641 |
| 14:59:15.971 | 1.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1657, 'a:1:{s:12:"completed_at";s:19:"2026-06-10 09:59:12";}', '', 1000, '223.104.40.22') |
| 14:59:15.973 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1641, 'a:4:{s:19:"target_completed_at";s:19:"2026-05-31 00:00:00";s:12:"completed_at";s:19:"2026-06-10 21:53:45";s:8:"start_at";s:19:"2026-05-29 00:00:00";s:6:"end_at";s:19:"2026-05-31 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.974 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.975 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1641, 'a:4:{s:19:"target_completed_at";s:19:"2026-05-31 00:00:00";s:12:"completed_at";s:19:"2026-06-10 21:53:45";s:8:"start_at";s:19:"2026-05-29 00:00:00";s:6:"end_at";s:19:"2026-05-31 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.976 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=100 WHERE "id"=1772 |
| 14:59:15.977 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1772, 'a:2:{s:12:"completed_at";s:19:"2026-06-23 14:01:25";s:8:"progress";i:100;}', '', 1000, '223.104.40.22') |
| 14:59:15.979 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1772 |
| 14:59:15.980 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1773, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:15.981 | 1.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=0 WHERE "id"=1772 |
| 14:59:15.983 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1772, 'a:2:{s:12:"completed_at";s:19:"2026-06-23 14:01:25";s:8:"progress";i:100;}', '', 1000, '223.104.40.22') |
| 14:59:15.985 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.985 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1772, 'a:1:{s:12:"completed_at";s:19:"2026-06-23 14:01:25";}', '', 1000, '223.104.40.22') |
| 14:59:15.987 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1754, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-18 00:00:00";s:12:"completed_at";s:19:"2026-06-18 16:18:12";s:8:"start_at";s:19:"2026-06-18 00:00:00";s:6:"end_at";s:19:"2026-08-18 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.988 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1754 |
| 14:59:15.989 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1755, 'a:1:{s:12:"completed_at";s:19:"2026-06-18 16:17:44";}', '', 1000, '223.104.40.22') |
| 14:59:15.991 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1754, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-18 00:00:00";s:12:"completed_at";s:19:"2026-06-18 16:18:12";s:8:"start_at";s:19:"2026-06-18 00:00:00";s:6:"end_at";s:19:"2026-08-18 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.992 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:15.992 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1754, 'a:4:{s:19:"target_completed_at";s:19:"2026-08-18 00:00:00";s:12:"completed_at";s:19:"2026-06-18 16:18:12";s:8:"start_at";s:19:"2026-06-18 00:00:00";s:6:"end_at";s:19:"2026-08-18 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.994 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1596 |
| 14:59:15.994 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1713, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:15.996 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1767, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:15.998 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1596, 'a:3:{s:19:"target_completed_at";s:19:"2026-05-30 00:00:00";s:8:"start_at";s:19:"2026-05-14 00:00:00";s:6:"end_at";s:19:"2026-05-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:15.999 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.000 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1596, 'a:3:{s:19:"target_completed_at";s:19:"2026-05-30 00:00:00";s:8:"start_at";s:19:"2026-05-14 00:00:00";s:6:"end_at";s:19:"2026-05-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.002 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1735, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-21 00:00:00";s:12:"completed_at";s:19:"2026-06-15 17:24:17";s:8:"start_at";s:19:"2026-06-15 00:00:00";s:6:"end_at";s:19:"2026-06-21 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.003 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1735 |
| 14:59:16.004 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1735, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-21 00:00:00";s:12:"completed_at";s:19:"2026-06-15 17:24:17";s:8:"start_at";s:19:"2026-06-15 00:00:00";s:6:"end_at";s:19:"2026-06-21 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.006 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.007 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1735, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-21 00:00:00";s:12:"completed_at";s:19:"2026-06-15 17:24:17";s:8:"start_at";s:19:"2026-06-15 00:00:00";s:6:"end_at";s:19:"2026-06-21 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.008 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1768 |
| 14:59:16.009 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1768, 'a:3:{s:19:"target_completed_at";s:19:"2026-06-22 00:00:00";s:8:"start_at";s:19:"2026-06-20 00:00:00";s:6:"end_at";s:19:"2026-06-22 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.011 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.011 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1768, 'a:3:{s:19:"target_completed_at";s:19:"2026-06-22 00:00:00";s:8:"start_at";s:19:"2026-06-20 00:00:00";s:6:"end_at";s:19:"2026-06-22 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.013 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1751, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:44:46";}', '', 1000, '223.104.40.22') |
| 14:59:16.014 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1751 |
| 14:59:16.015 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1752, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:44:37";}', '', 1000, '223.104.40.22') |
| 14:59:16.016 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1751, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:44:46";}', '', 1000, '223.104.40.22') |
| 14:59:16.017 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.018 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1751, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:44:46";}', '', 1000, '223.104.40.22') |
| 14:59:16.020 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1746, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:45:04";}', '', 1000, '223.104.40.22') |
| 14:59:16.021 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1746 |
| 14:59:16.022 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1746, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:45:04";}', '', 1000, '223.104.40.22') |
| 14:59:16.023 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.024 | 1.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1746, 'a:1:{s:12:"completed_at";s:19:"2026-06-16 20:45:04";}', '', 1000, '223.104.40.22') |
| 14:59:16.026 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1734 |
| 14:59:16.027 | 3.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1734, 'a:3:{s:19:"target_completed_at";s:19:"2026-07-15 00:00:00";s:8:"start_at";s:19:"2026-06-15 00:00:00";s:6:"end_at";s:19:"2026-07-15 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.031 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.031 | 3.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1734, 'a:3:{s:19:"target_completed_at";s:19:"2026-07-15 00:00:00";s:8:"start_at";s:19:"2026-06-15 00:00:00";s:6:"end_at";s:19:"2026-07-15 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.035 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1745 |
| 14:59:16.036 | 3.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1745, 'a:1:{s:8:"start_at";s:19:"2026-02-16 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.040 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.041 | 2.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1745, 'a:1:{s:8:"start_at";s:19:"2026-02-16 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.043 | 1.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=100 WHERE "id"=1769 |
| 14:59:16.045 | 1.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1769, 'a:5:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-23 13:57:47";s:8:"start_at";s:19:"2026-06-23 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";s:8:"progress";i:100;}', '', 1000, '223.104.40.22') |
| 14:59:16.047 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1769 |
| 14:59:16.048 | 1.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1770, 'a:0:{}', '', 1000, '223.104.40.22') |
| 14:59:16.050 | 4.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=0 WHERE "id"=1769 |
| 14:59:16.055 | 2.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1769, 'a:5:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-23 13:57:47";s:8:"progress";i:100;s:8:"start_at";s:19:"2026-06-23 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.057 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.057 | 1.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1769, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-23 13:57:47";s:8:"start_at";s:19:"2026-06-23 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 14:59:16.059 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 14:59:16.060 | 0.6 ms | SELECT | SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND ("status"=1) |
| 14:59:16.061 | 0.5 ms | SELECT | SELECT "status", "progress" FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND (parent_id is null) |
| 14:59:16.062 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_task_groups" SET "progress"=89 WHERE "id"=106 |
| 14:59:16.063 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 106, 'a:1:{s:8:"progress";i:89;}', '', 1000, '223.104.40.22') |
| 14:59:16.066 | 1.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1160, 'v2/task/save-edit-group', '{"TaskGroups":{"client_id":"982","description":"","id":"106","progress":"","project_id":"1018","situation":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1a","start_at":"2020-02-10","target_completed_at":"2027-03-01","taskGroupHeads":["1000","5250","5461","5064"],"taskGroupUsers":["1000","5064","5250","5461"],"title":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1"},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1782198016","token":"fc93b57abd0924aabfc13dc2c353691b","version_code":"1160"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"ip":"223.104.40.22","ua":"jinchangxiao\/2.3.157 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-23 14:59:16', 2063357952) RETURNING "id" |