ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68661cbcd688b: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-new-cost at 2025-07-03 02:01:32 pm by 114.254.1.137

Database Queries

总计53条数据
TimeDurationTypeQuery
  
14:01:32.8822.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:01:32.8850.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:01:32.8861.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:01:32.8891.0 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='646456456')

[+] Explain
14:01:32.8900.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431')

[+] Explain
14:01:32.8910.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')

[+] Explain
14:01:32.8910.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:01:32.8921.7 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_contracts" ("amount", "created_by", "signed_at", "cost_type", "contract_type", "supplier_id", "handler", "serial_no", "description", "including_tax", "payment_collection_remind_ahead") VALUES ('8768', 1001, '2025-07-03', 2, 3, 431, 1011, '646456456', '测试', TRUE, '0 day') RETURNING "id"

[+] Explain
14:01:32.8940.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContracts', 3847, 'a:21:{s:2:"id";i:3847;s:11:"supplier_id";s:3:"431";s:13:"contract_type";s:1:"3";s:9:"signed_at";s:10:"2025-07-03";s:6:"amount";s:4:"8768";s:7:"handler";s:4:"1011";s:11:"description";s:6:"测试";s:13:"contract_scan";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:9:"client_id";N;s:10:"project_id";N;s:9:"sales_rep";N;s:9:"serial_no";s:9:"646456456";s:31:"payment_collection_remind_ahead";s:5:"0 day";s:13:"including_tax";s:1:"1";s:18:"is_save_collection";N;s:18:"save_collection_at";N;s:13:"is_chargeback";N;s:9:"cost_type";i:2;}', '', 1001, '114.254.1.137')

[+] Explain
14:01:32.8950.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431'

[+] Explain
14:01:32.8950.3 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3847) AND ("term_id"=18) AND ("object_type"=8)

[+] Explain
14:01:32.8961.1 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 8, 349, '8768', '觉得很烦的很大姑回复对方好地方', 3847, 184)

[+] Explain
14:01:32.8971.3 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3847)

[+] Explain
14:01:32.8994.0 msSELECTSELECT 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_attachement_relationships' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
14:01:32.9038.1 msSELECTselect 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_attachement_relationships' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
14:01:32.9113.3 msINSERTINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (108, 3847, 24789)

[+] Explain
14:01:32.9151.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3847)

[+] Explain
14:01:32.9160.7 msINSERTINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (111, 3847, 24788)

[+] Explain
14:01:32.9170.4 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3847

[+] Explain
14:01:32.9180.3 msDELETEDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=3847

[+] Explain
14:01:32.9182.3 msSELECTSELECT 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_purchase_client_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
14:01:32.9219.4 msSELECTselect 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_purchase_client_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
14:01:32.9306.2 msINSERTINSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (3847, 2133, NULL) RETURNING "id"

[+] Explain
14:01:32.9370.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseClientRels', 3133, 'a:4:{s:2:"id";i:3133;s:11:"contract_id";i:3847;s:9:"client_id";s:4:"2133";s:10:"project_id";s:0:"";}', '', 1001, '114.254.1.137')

[+] Explain
14:01:32.9370.5 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=3847

[+] Explain
14:01:32.9380.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3847

[+] Explain
14:01:32.9380.1 msDELETEDELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1

[+] Explain
14:01:32.9400.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3847

[+] Explain
14:01:32.9410.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:01:32.9421.0 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '13', 3847, '刘人诚创建了一条费用合同：测试', TRUE, '采购合同：646456456') RETURNING "id"

[+] Explain
14:01:32.9430.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170192, 'a:11:{s:2:"id";i:170192;s:9:"object_id";i:3847;s:11:"object_type";s:2:"13";s:6:"parent";N;s:11:"description";s:45:"刘人诚创建了一条费用合同：测试";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:24:"采购合同：646456456";}', '', 1001, '114.254.1.137')

[+] Explain
14:01:32.9441.0 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (3847, '13', 170192, '1011')

[+] Explain
14:01:32.9450.2 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"='1011') AND ("id" != 1001) AND (channel_id IS NOT NULL)

[+] Explain
14:01:32.9460.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:01:32.9520.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3847

[+] Explain
14:01:32.9521.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 3847, 13, 1001, '2025-07-03 14:01:32', '{"id":3847,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"8768","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":null,"created_by":1001,"created_at":"2025-07-03 14:01:32","updated_at":"2025-07-03 14:01:32","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"646456456","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}', '{"id":3847,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"8768","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":null,"created_by":1001,"created_at":"2025-07-03 14:01:32","updated_at":"2025-07-03 14:01:32","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"646456456","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":[]}') RETURNING "id"

[+] Explain
14:01:32.9540.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509656, 'a:13:{s:2:"id";i:509656;s:9:"object_id";i:3847;s:11:"object_type";i:13;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:472:"{"id":3847,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"8768","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":null,"created_by":1001,"created_at":"2025-07-03 14:01:32","updated_at":"2025-07-03 14:01:32","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"646456456","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}";s:9:"new_value";s:472:"{"id":3847,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"8768","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":null,"created_by":1001,"created_at":"2025-07-03 14:01:32","updated_at":"2025-07-03 14:01:32","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"646456456","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-07-03 14:01:32";s:9:"is_delete";N;}', '', 1001, '114.254.1.137')

[+] Explain
14:01:32.9550.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3847 ORDER BY "id"

[+] Explain
14:01:32.9554.1 msSELECTSELECT 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_clients' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
14:01:32.96011.5 msSELECTselect 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_clients' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
14:01:32.9710.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2133

[+] Explain
14:01:32.9811.8 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2133

[+] Explain
14:01:32.98327.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2133) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
14:01:33.0113.8 msSELECTSELECT 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;

[+] Explain
14:01:33.01516.0 msSELECTselect 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

[+] Explain
14:01:33.0325.0 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2133, 5311, 'now()', NULL) RETURNING "id"

[+] Explain
14:01:33.0370.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165021, 'a:5:{s:2:"id";i:165021;s:9:"client_id";i:2133;s:9:"sales_rep";i:5311;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.254.1.137')

[+] Explain
14:01:33.0380.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2133, 'a:0:{}', '', 1001, '114.254.1.137')

[+] Explain
14:01:33.0390.9 msINSERTINSERT 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 (1, 'create', 2133, 10, 3847, 13, 1001, '[3847]', '[3847]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:646456456"]}') RETURNING "id"

[+] Explain
14:01:33.0400.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509657, 'a:13:{s:2:"id";i:509657;s:9:"object_id";i:2133;s:11:"object_type";i:10;s:9:"target_id";i:3847;s:18:"target_object_type";i:13;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[3847]";s:9:"new_value";s:6:"[3847]";s:11:"description";s:129:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:646456456"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')

[+] Explain
14:01:33.0410.8 msINSERTINSERT 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 (1, 'create', 431, 12, 3847, 13, 1001, '[3847]', '[3847]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:646456456"]}') RETURNING "id"

[+] Explain
14:01:33.0421.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509658, 'a:13:{s:2:"id";i:509658;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:3847;s:18:"target_object_type";i:13;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[3847]";s:9:"new_value";s:6:"[3847]";s:11:"description";s:129:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:646456456"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.254.1.137')

[+] Explain
14:01:33.0451.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/save-new-cost', '{"PurchaseContracts":{"id":"","supplier_id":"431","amount":"8768","handler":"1011","serial_no":"646456456","signed_at":"2025-07-03","description":"\u6d4b\u8bd5","including_tax":"1","contractScans":["24789"],"receiptScans":["24788"],"purchaseClientRels":[{"client_id":"2133","project_id":""}],"PurchaseContractInvoices":"","costContractAmounts":[{"id":"349","amount":"8768","description":"\u89c9\u5f97\u5f88\u70e6\u7684\u5f88\u5927\u59d1\u56de\u590d\u5bf9\u65b9\u597d\u5730\u65b9","parent_id":"184"}]},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"id":3847},"status":1,"msg":[{"name":"success","success":"\u65b0\u91c7\u8d2d\u5408\u540c\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-07-03 14:01:33') RETURNING "id"

[+] Explain