6a47ca4222eb8: POST https://beta.jinchangxiao.com/vue/sales-contract/save-edit at 2026-07-03 10:42:10 pm by 111.194.208.14
Database Queries
总计299条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 22:42:10.148 | 0.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 22:42:10.150 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.154 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4486' |
| 22:42:10.160 | 0.9 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='2026-06-02-001' LIMIT 2 |
| 22:42:10.161 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462') |
| 22:42:10.162 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 22:42:10.162 | 3.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174') |
| 22:42:10.166 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 22:42:10.166 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 22:42:10.167 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174) |
| 22:42:10.169 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:10.170 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4174 |
| 22:42:10.171 | 5.9 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_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.177 | 8.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_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:10.187 | 3.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_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.190 | 8.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_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:10.199 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 22:42:10.200 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 22:42:10.200 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 22:42:10.201 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.202 | 13.4 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, 'projectProductTypes', 4174, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}') |
| 22:42:10.216 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:10.223 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.223 | 4.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_user_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.228 | 8.9 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_user_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:10.238 | 13.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProductTypes', 4174, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}') |
| 22:42:10.252 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4174 |
| 22:42:10.254 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.254 | 0.5 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, 'projectProductTypes', 4486, 7, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}') |
| 22:42:10.255 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4174 |
| 22:42:10.256 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 22:42:10.257 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 22:42:10.257 | 4.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4174, 5, '安全设备', '3399000', 10, '339900'), (4174, 7, '软件', '162000', 10, '16200') |
| 22:42:10.262 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4174 |
| 22:42:10.263 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4174 |
| 22:42:10.264 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4174 |
| 22:42:10.265 | 0.2 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4174 |
| 22:42:10.265 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1 |
| 22:42:10.265 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id" |
| 22:42:10.267 | 3.7 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_product_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.271 | 8.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_project_product_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:10.281 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171 |
| 22:42:10.282 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 22:42:10.282 | 3.0 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_product_units' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.286 | 8.1 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_product_units' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:10.294 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171' |
| 22:42:10.295 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 22:42:10.296 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='870' |
| 22:42:10.296 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 22:42:10.296 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232' |
| 22:42:10.297 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 22:42:10.297 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 22:42:10.298 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 22:42:10.298 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232' |
| 22:42:10.299 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 22:42:10.299 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='870' |
| 22:42:10.300 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 22:42:10.300 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.301 | 0.5 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, 'projectProducts', 4174, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 22:42:10.301 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.302 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProducts', 4174, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 22:42:10.303 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:42:10.303 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC |
| 22:42:10.305 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:10.306 | 1.4 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, 'erpSalesOrderProducts', 1711, 20007, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 22:42:10.308 | 0.4 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 |
| 22:42:10.308 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12138 |
| 22:42:10.310 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='18000', "number"=9, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='162000' WHERE "id"=12138 |
| 22:42:10.312 | 17.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\ProjectProductRels', 12138, 'a:2:{s:6:"number";s:1:"9";s:12:"total_amount";s:6:"162000";}', '', 1001, '111.194.208.14') |
| 22:42:10.329 | 3.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4174, 870, '1200', 9, '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2232, '210375', 9, '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 868, '1400', 9, '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2232, '210375', 7, '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 870, '1200', 8, '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 22:42:10.333 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1 |
| 22:42:10.944 | 3.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "budget"='3561000', "profit_pct"='10', "project_product_version_id"=NULL WHERE "id"=4174 |
| 22:42:10.950 | 14.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:10.965 | 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_project_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:10.969 | 8.3 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 |
| 22:42:10.979 | 4.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17878 |
| 22:42:10.983 | 0.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\ProjectChangeLogs', 17878, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '111.194.208.14') |
| 22:42:10.984 | 6.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4174, 3, '3561000', '10', '0', 'now()', NULL) RETURNING "id" |
| 22:42:10.991 | 0.6 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\ProjectChangeLogs', 17882, 'a:8:{s:2:"id";i:17882;s:10:"project_id";i:4174;s:14:"project_status";i:3;s:6:"budget";d:3561000;s:10:"profit_pct";d:10;s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14') |
| 22:42:10.992 | 0.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\Projects', 4174, 'a:2:{s:6:"budget";d:3561000;s:26:"project_product_version_id";i:1379;}', '', 1001, '111.194.208.14') |
| 22:42:10.992 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:10.993 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:10.994 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id" |
| 22:42:10.997 | 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_product_versions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.001 | 8.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_project_product_versions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.009 | 3.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (4174, 1001, '2026-07-03 22:42:10') RETURNING "id" |
| 22:42:11.013 | 0.3 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\ProjectProductVersions', 1380, 'a:4:{s:2:"id";i:1380;s:10:"project_id";i:4174;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-03 22:42:10";}', '', 1001, '111.194.208.14') |
| 22:42:11.014 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.015 | 0.4 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 (1, 'create', 4174, 1, 1380, 112, 1001, '[1380]', '[1380]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 22:42:11.015 | 0.3 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', 643153, 'a:13:{s:2:"id";i:643153;s:9:"object_id";i:4174;s:11:"object_type";i:1;s:9:"target_id";i:1380;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1380]";s:9:"new_value";s:6:"[1380]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.016 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4174 |
| 22:42:11.017 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.018 | 0.4 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 (1, 'create', 4486, 7, 4174, 112, 1001, '[4174]', '[4174]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 22:42:11.018 | 0.3 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', 643154, 'a:13:{s:2:"id";i:643154;s:9:"object_id";i:4486;s:11:"object_type";i:7;s:9:"target_id";i:4174;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4174]";s:9:"new_value";s:6:"[4174]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.020 | 1.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1380 WHERE "id"=4174 |
| 22:42:11.022 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.024 | 0.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\Projects', 4174, 'a:1:{s:26:"project_product_version_id";i:1380;}', '', 1001, '111.194.208.14') |
| 22:42:11.024 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.027 | 3.7 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_product_version_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.031 | 8.1 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_product_version_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.040 | 8.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_version_rels" ("project_product_version_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1380, 2171, '18000', 9, '162000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 870, '1200', 9, '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 2232, '210375', 9, '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 868, '1400', 9, '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 2232, '210375', 7, '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 870, '1200', 8, '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 22:42:11.049 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.050 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id" |
| 22:42:11.051 | 7.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4174) AND (erp_sales_outbound_id is not null) |
| 22:42:11.061 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.063 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.063 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.064 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC |
| 22:42:11.065 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.066 | 0.4 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, 'number', 1711, 20007, 1001, 'now()', '[51]', '["1"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6570\u91cf","d4":["1 <b>\u53d8\u4e3a<\/b> 51"]}'), (2, 'amount', 1711, 20007, 1001, 'now()', '[3561000]', '["18000"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u91d1\u989d","d4":["18000 <b>\u53d8\u4e3a<\/b> 3561000"]}') |
| 22:42:11.067 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='51', "amount"='3561000' WHERE "id"=1711 |
| 22:42:11.068 | 0.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\ErpSalesOrders', 1711, 'a:2:{s:6:"number";d:51;s:6:"amount";d:3561000;}', '', 1001, '111.194.208.14') |
| 22:42:11.068 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=3462, "amount"='3561000', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=4174, "expire_date"=NULL, "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_outbound"=FALSE, "is_draft"=TRUE WHERE "id"=4486 |
| 22:42:11.069 | 0.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\SalesContracts', 4486, 'a:3:{s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";s:6:"amount";d:3561000;}', '', 1001, '111.194.208.14') |
| 22:42:11.070 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462' |
| 22:42:11.070 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174' |
| 22:42:11.071 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id" |
| 22:42:11.072 | 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_erp_sales_order_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.076 | 8.1 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_erp_sales_order_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.085 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1711) AND ("status"=0) |
| 22:42:11.086 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.086 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.087 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1711 |
| 22:42:11.088 | 0.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\ErpSalesOrders', 1711, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '111.194.208.14') |
| 22:42:11.089 | 3.4 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_erp_sales_order_stop_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.092 | 8.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_erp_sales_order_stop_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.101 | 22.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_stop_products" ("erp_sales_order_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, NULL, 2171, '18000', '162000', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 870, '1200', '10800', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 2232, '210375', '1893375', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 868, '1400', '12600', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 2232, '210375', '1472625', '7', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 870, '1200', '9600', '8', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 22:42:11.124 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 22:42:11.126 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1711) AND ("status"=0) ORDER BY "id" |
| 22:42:11.126 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.127 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1711) ORDER BY "id" |
| 22:42:11.128 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.128 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1711 ORDER BY "id" |
| 22:42:11.129 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1711 |
| 22:42:11.130 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 22:42:11.131 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1711, '刘人诚通过了这个审批', TRUE, 'XSDD-20260602-00001') RETURNING "id" |
| 22:42:11.132 | 0.4 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\Comments', 221016, 'a:11:{s:2:"id";i:221016;s:9:"object_id";i:1711;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";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:19:"XSDD-20260602-00001";}', '', 1001, '111.194.208.14') |
| 22:42:11.132 | 0.2 ms | SELECT | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 22:42:11.133 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.134 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.136 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=2, "next_stop_verify_user"=NULL, "updated_at"='now()' WHERE "id"=1711 |
| 22:42:11.136 | 0.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\ErpSalesOrders', 1711, 'a:1:{s:6:"status";i:5;}', '', 1001, '111.194.208.14') |
| 22:42:11.137 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.138 | 5.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2171, '9', '18000', '162000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.144 | 0.3 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\ErpSalesOrderProducts', 2260, 'a:21:{s:2:"id";i:2260;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2171;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:5:"18000";s:12:"total_amount";s:6:"162000";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.144 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 870, '9', '1200', '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.145 | 0.3 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\ErpSalesOrderProducts', 2261, 'a:21:{s:2:"id";i:2261;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:870;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:4:"1200";s:12:"total_amount";s:5:"10800";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.146 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2232, '9', '210375', '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.146 | 0.3 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\ErpSalesOrderProducts', 2262, 'a:21:{s:2:"id";i:2262;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2232;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:6:"210375";s:12:"total_amount";s:7:"1893375";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.147 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 868, '9', '1400', '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.147 | 0.3 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\ErpSalesOrderProducts', 2263, 'a:21:{s:2:"id";i:2263;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:868;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:4:"1400";s:12:"total_amount";s:5:"12600";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.148 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2232, '7', '210375', '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.149 | 0.3 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\ErpSalesOrderProducts', 2264, 'a:21:{s:2:"id";i:2264;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2232;s:11:"description";s:0:"";s:6:"number";s:1:"7";s:8:"outbound";N;s:6:"amount";s:6:"210375";s:12:"total_amount";s:7:"1472625";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.149 | 0.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 870, '8', '1200', '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 22:42:11.150 | 0.3 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\ErpSalesOrderProducts', 2265, 'a:21:{s:2:"id";i:2265;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:870;s:11:"description";s:0:"";s:6:"number";s:1:"8";s:8:"outbound";N;s:6:"amount";s:4:"1200";s:12:"total_amount";s:4:"9600";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14') |
| 22:42:11.150 | 0.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\ErpSalesOrders', 1711, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.151 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2260, 2261, 2262, 2263, 2264, 2265)) AND ("erp_sales_order_id"=1711) |
| 22:42:11.152 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.152 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.153 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 |
| 22:42:11.153 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4174, 2260, 2171, '18000', '162000', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2261, 870, '1200', '10800', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2262, 2232, '210375', '1893375', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2263, 868, '1400', '12600', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2264, 2232, '210375', '1472625', 7, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2265, 870, '1200', '9600', 8, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 22:42:11.156 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.158 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.158 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.159 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:42:11.160 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4486 |
| 22:42:11.161 | 0.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\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.161 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.162 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.163 | 0.9 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 22:42:11.164 | 1.0 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5)) |
| 22:42:11.166 | 1.1 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 22:42:11.167 | 0.4 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.168 | 0.6 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.168 | 0.6 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.169 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.170 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.170 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.171 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='3561000', "erp_all_settle_amount"='0' WHERE "id"=4486 |
| 22:42:11.172 | 0.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\SalesContracts', 4486, 'a:1:{s:20:"erp_un_settle_amount";s:5:"18000";}', '', 1001, '111.194.208.14') |
| 22:42:11.173 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.174 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.174 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.176 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4174 |
| 22:42:11.177 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.179 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.180 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.182 | 3.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4174 ORDER BY "created_at" DESC |
| 22:42:11.186 | 3.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_project_status_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.189 | 8.1 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_status_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.198 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:42:11.199 | 2.7 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_sales_contract_payment_collection_remind_dates' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.202 | 7.1 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_sales_contract_payment_collection_remind_dates' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.210 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4486 |
| 22:42:11.210 | 0.4 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5, 1)) |
| 22:42:11.211 | 0.6 ms | SELECT | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5, 1)) |
| 22:42:11.212 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.212 | 0.4 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4486 |
| 22:42:11.215 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.217 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.217 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.218 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4486) AND (amount > paid_amount) ORDER BY "remind_date" |
| 22:42:11.219 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711 |
| 22:42:11.220 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2260, 2261, 2262, 2263, 2264, 2265) |
| 22:42:11.221 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2260 |
| 22:42:11.222 | 0.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\ErpSalesOrderProducts', 2260, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.222 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2260 |
| 22:42:11.223 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2261 |
| 22:42:11.223 | 0.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\ErpSalesOrderProducts', 2261, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.224 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2261 |
| 22:42:11.225 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2262 |
| 22:42:11.225 | 0.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\ErpSalesOrderProducts', 2262, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.226 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2262 |
| 22:42:11.226 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2263 |
| 22:42:11.227 | 0.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\ErpSalesOrderProducts', 2263, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.227 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2263 |
| 22:42:11.228 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2264 |
| 22:42:11.228 | 0.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\ErpSalesOrderProducts', 2264, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.229 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2264 |
| 22:42:11.230 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2265 |
| 22:42:11.230 | 0.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\ErpSalesOrderProducts', 2265, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.230 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2265 |
| 22:42:11.231 | 0.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\ErpSalesOrders', 1711, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.232 | 0.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\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.232 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.233 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.234 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.234 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:42:11.235 | 0.3 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 (11, 'status', 1711, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 22:42:11.237 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "contract_type"=1 WHERE "id"=4174 |
| 22:42:11.238 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.240 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.240 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.241 | 0.7 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4486 |
| 22:42:11.242 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 22:42:11.242 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 22:42:11.243 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.243 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4174 |
| 22:42:11.244 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4486 |
| 22:42:11.245 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC |
| 22:42:11.246 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711) |
| 22:42:11.247 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_outbound"=FALSE WHERE "id"=4486 |
| 22:42:11.247 | 0.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\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.248 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462' |
| 22:42:11.249 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174' |
| 22:42:11.249 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4486 |
| 22:42:11.250 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4486 |
| 22:42:11.251 | 7.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4174 |
| 22:42:11.260 | 3.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4486) |
| 22:42:11.263 | 3.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4486) |
| 22:42:11.267 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.268 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.268 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.269 | 2.9 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_sales_contract_payment_collection_remind_receivers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:42:11.272 | 8.2 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_sales_contract_payment_collection_remind_receivers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:42:11.282 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.282 | 6.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4486, 1001) RETURNING "id" |
| 22:42:11.289 | 0.3 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\SalesContractPaymentCollectionRemindReceivers', 10174, 'a:3:{s:2:"id";i:10174;s:11:"contract_id";i:4486;s:7:"user_id";s:4:"1001";}', '', 1001, '111.194.208.14') |
| 22:42:11.290 | 0.5 ms | SELECT | SELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4486 |
| 22:42:11.290 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4486) AND (0=1) |
| 22:42:11.291 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.291 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4486 |
| 22:42:11.292 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:42:11.292 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 22:42:11.293 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5)) |
| 22:42:11.294 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 22:42:11.295 | 0.4 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.295 | 0.6 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.296 | 0.6 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status"=1)) |
| 22:42:11.297 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.298 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.298 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (1, 2, 5)) |
| 22:42:11.299 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='3561000', "erp_all_settle_amount"='0' WHERE "id"=4486 |
| 22:42:11.300 | 0.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\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.301 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.301 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.302 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.304 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4174 |
| 22:42:11.305 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.307 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.308 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.308 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4174 ORDER BY "created_at" DESC |
| 22:42:11.309 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:42:11.310 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4486 |
| 22:42:11.310 | 0.4 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5, 1)) |
| 22:42:11.311 | 0.6 ms | SELECT | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4486) AND ("t"."status" IN (2, 5, 1)) |
| 22:42:11.312 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.312 | 0.3 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4486 |
| 22:42:11.314 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 22:42:11.317 | 0.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\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.317 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.318 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4486) AND (amount > paid_amount) ORDER BY "remind_date" |
| 22:42:11.318 | 3.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=106)) |
| 22:42:11.322 | 3.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=107)) |
| 22:42:11.325 | 2.9 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=105)) |
| 22:42:11.328 | 0.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\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:42:11.329 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:42:11.330 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:42:11.338 | 5.1 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/save-edit', '{"SalesContracts":{"id":"4486","client_id":"3462","project_id":"4174","project_name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","amount":"18000","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"2026-06-02-001","signed_at":"2026-06-02","budget":"18000","profit":"356100","profit_pct":"10.00","description":"","expire_date":"","expire_remind_ahead":"","project_product_version_id":"","salesContractPayments":{"new":[""]},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"sla":"","including_tax":"1","remind_ahead":"","is_draft":"1","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","projectContactPoints":"","projectContactPointRels":"","contractScans":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12138":{"product_id":"2171","amount":"18000","total_amount":"162000","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"new":{"4":{"product_id":"870","amount":"1200","total_amount":"10800","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"3":{"product_id":"2232","amount":"210375","total_amount":"1893375","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"2":{"product_id":"868","amount":"1400","total_amount":"12600","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"1":{"product_id":"2232","amount":"210375","total_amount":"1472625","number":"7","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"0":{"product_id":"870","amount":"1200","total_amount":"9600","number":"8","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}}},"salesContractInvoices":"","projectProductTypes":{"5":{"budget":"3399000","profit":"339900","pct":"10"},"7":{"budget":"162000","profit":"16200","pct":"10"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""}}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-03 22:42:11', 1194481152) RETURNING "id" |