6a58a2a0459eb: POST https://beta.jinchangxiao.com/vue/sales-contract/save-edit at 2026-07-16 05:21:36 pm by 114.244.130.25
Database Queries
总计349条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:21:36.290 | 1.0 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1013 |
| 17:21:36.292 | 0.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:21:36.294 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.299 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4505' |
| 17:21:36.304 | 0.8 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='TSKJ&KTJT20260626001' LIMIT 2 |
| 17:21:36.305 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465') |
| 17:21:36.306 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 17:21:36.306 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183') |
| 17:21:36.307 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:21:36.308 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:21:36.308 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183) |
| 17:21:36.309 | 6.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_projects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:21:36.316 | 17.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_projects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:21:36.334 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.335 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183 |
| 17:21:36.337 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:21:36.337 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 17:21:36.338 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:21:36.338 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 17:21:36.338 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:21:36.339 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 17:21:36.339 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:21:36.340 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.341 | 0.8 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', 4183, 1, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:213600\u5143 10%","\u5b89\u5168\u8bbe\u5907:532950\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:213600\u5143 10%;\u5b89\u5168\u8bbe\u5907:532950\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%;"]}') |
| 17:21:36.342 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.343 | 4.8 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_clients' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:21:36.348 | 16.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_clients' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:21:36.366 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.367 | 0.7 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', 4183, 1, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:213600\u5143 10%","\u5b89\u5168\u8bbe\u5907:532950\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:213600\u5143 10%;\u5b89\u5168\u8bbe\u5907:532950\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%;"]}') |
| 17:21:36.368 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4183 |
| 17:21:36.369 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.369 | 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 (2, 'projectProductTypes', 4505, 7, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:213600\u5143 10%","\u5b89\u5168\u8bbe\u5907:532950\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:213600\u5143 10%;\u5b89\u5168\u8bbe\u5907:532950\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :347000\u5143 10%;"]}') |
| 17:21:36.370 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183 |
| 17:21:36.371 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:21:36.371 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 17:21:36.371 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:21:36.372 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 17:21:36.372 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4183, 7, '软件', '18000', 10, '1800'), (4183, 23, '礼品', '213600', 10, '21360'), (4183, 5, '安全设备', '532950', 10, '53295'), (4183, 4, '网络设备 ', '347000', 10, '34700') |
| 17:21:36.374 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183 |
| 17:21:36.375 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183 |
| 17:21:36.376 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183 |
| 17:21:36.377 | 0.2 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183 |
| 17:21:36.377 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1 |
| 17:21:36.378 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 17:21:36.380 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171 |
| 17:21:36.381 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:21:36.382 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267 |
| 17:21:36.382 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:21:36.383 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267 |
| 17:21:36.383 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:21:36.384 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=868 |
| 17:21:36.384 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 17:21:36.385 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232 |
| 17:21:36.385 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:21:36.386 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171' |
| 17:21:36.386 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:21:36.387 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267' |
| 17:21:36.387 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:21:36.387 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267' |
| 17:21:36.388 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:21:36.388 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 17:21:36.389 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 17:21:36.390 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232' |
| 17:21:36.390 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:21:36.391 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 17:21:36.392 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 17:21:36.392 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1373' |
| 17:21:36.393 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6 |
| 17:21:36.393 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2265' |
| 17:21:36.393 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=9 |
| 17:21:36.394 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 17:21:36.394 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 17:21:36.395 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='989' |
| 17:21:36.395 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:21:36.396 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1025' |
| 17:21:36.396 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6 |
| 17:21:36.397 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.397 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProducts', 4183, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \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 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 17:21:36.399 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.400 | 0.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, 'projectProducts', 4183, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \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 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 17:21:36.400 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 17:21:36.401 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 17:21:36.403 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.404 | 0.6 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', 1721, 20007, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \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 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\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 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \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.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u4e2a\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 42000.00\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5e74\u5143 \u5907\u6ce8:\u5b9e\u65bd\u670d\u52a1 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 10\u7c73:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:V3.0\u6807\u51c6\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u76d2\u5143 \u5907\u6ce8:V1.0\uff081\u5e74\uff09 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u5e74\u5143 \u5907\u6ce8:V3.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-400-RACKTRAY:\u5408\u540c\u5355\u4ef7 9247.79\u5143 \u6570\u91cf 10\u5957\u5143 \u5907\u6ce8:V6.0Base\u7248 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;FOC-1010:\u5408\u540c\u5355\u4ef7 332000.00\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002 \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 17:21:36.405 | 0.5 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 |
| 17:21:36.405 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12211 |
| 17:21:36.406 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='18000', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='18000.00' WHERE "id"=12211 |
| 17:21:36.407 | 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_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:21:36.411 | 11.4 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:21:36.423 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12211, 'a:1:{s:12:"total_amount";s:8:"18000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.425 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12212 |
| 17:21:36.426 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='42000', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='84000.00' WHERE "id"=12212 |
| 17:21:36.426 | 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\ProjectProductRels', 12212, 'a:1:{s:12:"total_amount";s:8:"84000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.427 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12213 |
| 17:21:36.428 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='99600', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='99600.00' WHERE "id"=12213 |
| 17:21:36.428 | 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\ProjectProductRels', 12213, 'a:1:{s:12:"total_amount";s:8:"99600.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.429 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12214 |
| 17:21:36.430 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=868, "amount"='42000', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='84000.00' WHERE "id"=12214 |
| 17:21:36.430 | 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\ProjectProductRels', 12214, 'a:1:{s:12:"total_amount";s:8:"84000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.431 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12215 |
| 17:21:36.432 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2232, "amount"='99600', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='99600.00' WHERE "id"=12215 |
| 17:21:36.432 | 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\ProjectProductRels', 12215, 'a:1:{s:12:"total_amount";s:8:"99600.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.433 | 2.0 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 (4183, 868, '83962.26', 1, '89000.00', '实施服务', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 1373, '13274.34', 1, '15000.00', 'V3.0标准版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2265, '2654.87', 10, '30000.00', 'V1.0（1年）', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 868, '13792.04', 10, '155850.00', 'V3.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 989, '9247.79', 10, '104500.00', 'V6.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 1025, '332000.00', 1, '332000.00', '2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:21:36.435 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1 |
| 17:21:36.438 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "budget"='1111550', "profit_pct"='10', "project_product_version_id"=1390 WHERE "id"=4183 |
| 17:21:36.439 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.442 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17897 |
| 17:21:36.443 | 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\ProjectChangeLogs', 17897, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '114.244.130.25') |
| 17:21:36.443 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4183, 3, '1111550', '10', '0', 'now()', NULL) RETURNING "id" |
| 17:21:36.444 | 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\ProjectChangeLogs', 17901, 'a:8:{s:2:"id";i:17901;s:10:"project_id";i:4183;s:14:"project_status";i:3;s:6:"budget";d:1111550;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, '114.244.130.25') |
| 17:21:36.444 | 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\Projects', 4183, 'a:1:{s:6:"budget";d:1111550;}', '', 1001, '114.244.130.25') |
| 17:21:36.445 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.445 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.446 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 17:21:36.448 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (4183, 1001, '2026-07-16 17:21:36') RETURNING "id" |
| 17:21:36.449 | 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', 1394, 'a:4:{s:2:"id";i:1394;s:10:"project_id";i:4183;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-16 17:21:36";}', '', 1001, '114.244.130.25') |
| 17:21:36.449 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.450 | 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', 4183, 1, 1394, 112, 1001, '[1394]', '[1394]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:21\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 17:21:36.450 | 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', 643573, 'a:13:{s:2:"id";i:643573;s:9:"object_id";i:4183;s:11:"object_type";i:1;s:9:"target_id";i:1394;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1394]";s:9:"new_value";s:6:"[1394]";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-16 17:21\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, '114.244.130.25') |
| 17:21:36.451 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4183 |
| 17:21:36.451 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.452 | 0.3 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', 4505, 7, 4183, 112, 1001, '[4183]', '[4183]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:21\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 17:21:36.452 | 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', 643574, 'a:13:{s:2:"id";i:643574;s:9:"object_id";i:4505;s:11:"object_type";i:7;s:9:"target_id";i:4183;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4183]";s:9:"new_value";s:6:"[4183]";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-16 17:21\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, '114.244.130.25') |
| 17:21:36.454 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1394 WHERE "id"=4183 |
| 17:21:36.455 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.458 | 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', 4183, 'a:1:{s:26:"project_product_version_id";i:1394;}', '', 1001, '114.244.130.25') |
| 17:21:36.458 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.460 | 1.6 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 (1394, 2171, '18000', 1, '18000.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 2267, '42000', 2, '84000.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 2267, '99600', 1, '99600.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 868, '42000', 2, '84000.00', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 2232, '99600', 1, '99600.00', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 868, '83962.26', 1, '89000.00', '实施服务', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 1373, '13274.34', 1, '15000.00', 'V3.0标准版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 2265, '2654.87', 10, '30000.00', 'V1.0（1年）', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 868, '13792.04', 10, '155850.00', 'V3.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 989, '9247.79', 10, '104500.00', 'V6.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1394, 1025, '332000.00', 1, '332000.00', '2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:21:36.461 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.462 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 17:21:36.463 | 4.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4183) AND (erp_sales_outbound_id is not null) |
| 17:21:36.469 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.471 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.472 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.473 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 17:21:36.474 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.474 | 1.0 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', 1721, 20007, 1001, 'now()', '[40]', '["7"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6570\u91cf","d4":["7 <b>\u53d8\u4e3a<\/b> 40"]}'), (2, 'amount', 1721, 20007, 1001, 'now()', '[1111550]', '["385200"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u91d1\u989d","d4":["385200 <b>\u53d8\u4e3a<\/b> 1111550"]}') |
| 17:21:36.476 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='40', "amount"='1111550' WHERE "id"=1721 |
| 17:21:36.477 | 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', 1721, 'a:2:{s:6:"number";d:40;s:6:"amount";d:1111550;}', '', 1001, '114.244.130.25') |
| 17:21:36.478 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=3465, "signed_at"='2026-07-14', "amount"='1111550', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=4183, "expire_date"='2026-07-17', "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_outbound"=FALSE, "is_draft"=FALSE, "is_edit_verify"=TRUE WHERE "id"=4505 |
| 17:21:36.479 | 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', 4505, 'a:5:{s:9:"signed_at";s:10:"2026-07-14";s:11:"expire_date";s:10:"2026-07-17";s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";s:6:"amount";d:1111550;}', '', 1001, '114.244.130.25') |
| 17:21:36.479 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465' |
| 17:21:36.480 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183' |
| 17:21:36.481 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 17:21:36.482 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1721) AND ("status"=0) |
| 17:21:36.483 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.483 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.484 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1721 |
| 17:21:36.485 | 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', 1721, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '114.244.130.25') |
| 17:21:36.486 | 2.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 (1721, 2259, 2171, '18000', '18000.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2273, 2267, '42000', '84000.00', '2', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2274, 2267, '99600', '99600.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2285, 868, '42000', '84000.00', '2', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2286, 2232, '99600', '99600.00', '1', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 868, '83962.26', '89000.00', '1', '实施服务', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 1373, '13274.34', '15000.00', '1', 'V3.0标准版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 2265, '2654.87', '30000.00', '10', 'V1.0（1年）', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 868, '13792.04', '155850.00', '10', 'V3.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 989, '9247.79', '104500.00', '10', 'V6.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 1025, '332000.00', '332000.00', '1', '2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:21:36.489 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 17:21:36.490 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1721) AND ("status"=0) ORDER BY "id" |
| 17:21:36.490 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.491 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1721) ORDER BY "id" |
| 17:21:36.491 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.492 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1721 ORDER BY "id" |
| 17:21:36.493 | 3.6 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_comments' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:21:36.497 | 16.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_comments' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:21:36.513 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1721 |
| 17:21:36.514 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:21:36.515 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1721, '刘人诚通过了这个审批', TRUE, 'XSDD-20260609-00001') RETURNING "id" |
| 17:21:36.516 | 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\Comments', 221110, 'a:11:{s:2:"id";i:221110;s:9:"object_id";i:1721;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-20260609-00001";}', '', 1001, '114.244.130.25') |
| 17:21:36.517 | 0.3 ms | SELECT | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 17:21:36.517 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.518 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.520 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "updated_at"='now()' WHERE "id"=1721 |
| 17:21:36.521 | 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', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.521 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.523 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2259 |
| 17:21:36.523 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='18000.00', "last_total_amount"='18000.00' WHERE "id"=2259 |
| 17:21:36.524 | 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', 2259, 'a:2:{s:12:"total_amount";s:8:"18000.00";s:17:"last_total_amount";s:8:"18000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.525 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2273 |
| 17:21:36.525 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='84000.00', "last_total_amount"='84000.00' WHERE "id"=2273 |
| 17:21:36.526 | 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', 2273, 'a:2:{s:12:"total_amount";s:8:"84000.00";s:17:"last_total_amount";s:8:"84000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.526 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2274 |
| 17:21:36.528 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='99600.00', "last_total_amount"='99600.00' WHERE "id"=2274 |
| 17:21:36.528 | 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', 2274, 'a:2:{s:12:"total_amount";s:8:"99600.00";s:17:"last_total_amount";s:8:"99600.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.529 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2285 |
| 17:21:36.529 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='84000.00', "last_number"='2', "last_amount"='42000', "last_total_amount"='84000.00' WHERE "id"=2285 |
| 17:21:36.530 | 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', 2285, 'a:2:{s:12:"total_amount";s:8:"84000.00";s:17:"last_total_amount";s:8:"84000.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.531 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2286 |
| 17:21:36.531 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='99600.00', "last_number"='1', "last_amount"='99600', "last_total_amount"='99600.00' WHERE "id"=2286 |
| 17:21:36.532 | 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', 2286, 'a:2:{s:12:"total_amount";s:8:"99600.00";s:17:"last_total_amount";s:8:"99600.00";}', '', 1001, '114.244.130.25') |
| 17:21:36.533 | 0.6 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 (1721, 868, '1', '83962.26', '89000.00', '实施服务', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.533 | 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', 2298, 'a:21:{s:2:"id";i:2298;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:868;s:11:"description";s:12:"实施服务";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:8:"83962.26";s:12:"total_amount";s:8:"89000.00";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, '114.244.130.25') |
| 17:21:36.534 | 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 (1721, 1373, '1', '13274.34', '15000.00', 'V3.0标准版', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.535 | 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', 2299, 'a:21:{s:2:"id";i:2299;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:1373;s:11:"description";s:13:"V3.0标准版";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:8:"13274.34";s:12:"total_amount";s:8:"15000.00";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, '114.244.130.25') |
| 17:21:36.535 | 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 (1721, 2265, '10', '2654.87', '30000.00', 'V1.0（1年）', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.536 | 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', 2300, 'a:21:{s:2:"id";i:2300;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:2265;s:11:"description";s:14:"V1.0（1年）";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:7:"2654.87";s:12:"total_amount";s:8:"30000.00";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, '114.244.130.25') |
| 17:21:36.536 | 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 (1721, 868, '10', '13792.04', '155850.00', 'V3.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.537 | 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', 2301, 'a:21:{s:2:"id";i:2301;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:868;s:11:"description";s:11:"V3.0Base版";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:8:"13792.04";s:12:"total_amount";s:9:"155850.00";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, '114.244.130.25') |
| 17:21:36.537 | 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 (1721, 989, '10', '9247.79', '104500.00', 'V6.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.538 | 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', 2302, 'a:21:{s:2:"id";i:2302;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:989;s:11:"description";s:11:"V6.0Base版";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:7:"9247.79";s:12:"total_amount";s:9:"104500.00";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, '114.244.130.25') |
| 17:21:36.539 | 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 (1721, 1025, '1', '332000.00', '332000.00', '2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:21:36.539 | 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', 2303, 'a:21:{s:2:"id";i:2303;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:1025;s:11:"description";s:119:"2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:9:"332000.00";s:12:"total_amount";s:9:"332000.00";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, '114.244.130.25') |
| 17:21:36.540 | 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', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.540 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2259, 2273, 2274, 2285, 2286, 2298, 2299, 2300, 2301, 2302, 2303)) AND ("erp_sales_order_id"=1721) |
| 17:21:36.541 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.541 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.542 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 |
| 17:21:36.543 | 1.0 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 (4183, 2259, 2171, '18000', '18000.00', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2273, 2267, '42000', '84000.00', 2, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2274, 2267, '99600', '99600.00', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2285, 868, '42000', '84000.00', 2, 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2286, 2232, '99600', '99600.00', 1, 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2298, 868, '83962.26', '89000.00', 1, '实施服务', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2299, 1373, '13274.34', '15000.00', 1, 'V3.0标准版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2300, 2265, '2654.87', '30000.00', 10, 'V1.0（1年）', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2301, 868, '13792.04', '155850.00', 10, 'V3.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2302, 989, '9247.79', '104500.00', 10, 'V6.0Base版', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2303, 1025, '332000.00', '332000.00', 1, '2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:21:36.545 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.547 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.548 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.548 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 17:21:36.549 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4505 |
| 17:21:36.550 | 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\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.550 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.551 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.552 | 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 17:21:36.553 | 0.9 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"=4505) AND ("t"."status" IN (2, 5)) |
| 17:21:36.554 | 0.9 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"=4505) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:21:36.556 | 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.556 | 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.557 | 0.5 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.558 | 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.558 | 0.5 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"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.559 | 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"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.560 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='1111550', "erp_all_settle_amount"='0' WHERE "id"=4505 |
| 17:21:36.561 | 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', 4505, 'a:1:{s:20:"erp_un_settle_amount";s:6:"385200";}', '', 1001, '114.244.130.25') |
| 17:21:36.561 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.562 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.562 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.564 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4183 |
| 17:21:36.565 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.567 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.567 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.568 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4183 ORDER BY "created_at" DESC |
| 17:21:36.569 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 17:21:36.570 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4505 |
| 17:21:36.571 | 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"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 17:21:36.572 | 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"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 17:21:36.572 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.573 | 0.4 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4505 |
| 17:21:36.574 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.576 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.577 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.578 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4505) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:21:36.578 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721 |
| 17:21:36.579 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2259, 2273, 2274, 2285, 2286, 2298, 2299, 2300, 2301, 2302, 2303) |
| 17:21:36.580 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2259 |
| 17:21:36.581 | 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', 2259, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.581 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2259 |
| 17:21:36.582 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2273 |
| 17:21:36.583 | 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', 2273, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.583 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2273 |
| 17:21:36.584 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2274 |
| 17:21:36.585 | 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', 2274, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.585 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2274 |
| 17:21:36.586 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2285 |
| 17:21:36.586 | 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', 2285, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.587 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2285 |
| 17:21:36.587 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2286 |
| 17:21:36.588 | 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', 2286, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.588 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2286 |
| 17:21:36.589 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2298 |
| 17:21:36.590 | 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', 2298, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.590 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2298 |
| 17:21:36.591 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2299 |
| 17:21:36.591 | 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', 2299, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.592 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2299 |
| 17:21:36.592 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2300 |
| 17:21:36.593 | 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', 2300, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.593 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2300 |
| 17:21:36.594 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2301 |
| 17:21:36.594 | 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', 2301, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.595 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2301 |
| 17:21:36.596 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2302 |
| 17:21:36.596 | 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', 2302, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.597 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2302 |
| 17:21:36.597 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2303 |
| 17:21:36.598 | 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', 2303, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.598 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2303 |
| 17:21:36.599 | 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', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.600 | 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', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.600 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.601 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.601 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.602 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:21:36.602 | 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', 1721, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 17:21:36.604 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "bargain_date"='2026-07-14', "contract_type"=1 WHERE "id"=4183 |
| 17:21:36.605 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.607 | 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', 4183, 'a:1:{s:12:"bargain_date";s:10:"2026-07-14";}', '', 1001, '114.244.130.25') |
| 17:21:36.607 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.608 | 0.5 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505 |
| 17:21:36.609 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 17:21:36.609 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 17:21:36.609 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.610 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4183 |
| 17:21:36.611 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505 |
| 17:21:36.612 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 17:21:36.612 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721) |
| 17:21:36.613 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_outbound"=FALSE WHERE "id"=4505 |
| 17:21:36.614 | 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', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.615 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465' |
| 17:21:36.615 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183' |
| 17:21:36.616 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505 |
| 17:21:36.617 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505 |
| 17:21:36.617 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4183 |
| 17:21:36.618 | 3.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505) |
| 17:21:36.623 | 3.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505) |
| 17:21:36.627 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (105, 4505, 32843), (105, 4505, 32842) |
| 17:21:36.628 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.629 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.630 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.631 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.632 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4505, 1001) RETURNING "id" |
| 17:21:36.633 | 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', 10190, 'a:3:{s:2:"id";i:10190;s:11:"contract_id";i:4505;s:7:"user_id";s:4:"1001";}', '', 1001, '114.244.130.25') |
| 17:21:36.634 | 0.4 ms | SELECT | SELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4505 |
| 17:21:36.634 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4505) AND (0=1) |
| 17:21:36.634 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.635 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505 |
| 17:21:36.635 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 17:21:36.636 | 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 17:21:36.637 | 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"=4505) AND ("t"."status" IN (2, 5)) |
| 17:21:36.638 | 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"=4505) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:21:36.638 | 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.639 | 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.640 | 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"=4505) AND ("t"."status"=1)) |
| 17:21:36.641 | 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.641 | 0.5 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"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.642 | 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"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 17:21:36.643 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='1111550', "erp_all_settle_amount"='0' WHERE "id"=4505 |
| 17:21:36.644 | 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', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.644 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.645 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.645 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.647 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4183 |
| 17:21:36.648 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.650 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.650 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.651 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4183 ORDER BY "created_at" DESC |
| 17:21:36.652 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 17:21:36.652 | 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"=4505 |
| 17:21:36.653 | 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"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 17:21:36.653 | 0.5 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"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 17:21:36.654 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.655 | 0.3 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4505 |
| 17:21:36.656 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:21:36.658 | 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', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.659 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.659 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4505) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:21:36.660 | 3.0 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=106)) |
| 17:21:36.663 | 2.9 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=107)) |
| 17:21:36.667 | 3.0 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=105)) |
| 17:21:36.670 | 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', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:21:36.670 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 17:21:36.671 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 17:21:36.674 | 1.6 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":"4505","client_id":"3465","project_id":"4183","project_name":"\u96f6\u552e001","amount":"385200","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"TSKJ&KTJT20260626001","signed_at":"2026-07-14","budget":"385200","profit":"111155","profit_pct":"10.00","description":"","expire_date":"2026-07-17","expire_remind_ahead":"","project_product_version_id":"1390","salesContractPayments":{"new":[""]},"salesContractPaymentCollectionRemindDates":{"2026-06-09":"18000"},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"sla":"","including_tax":"1","remind_ahead":"","contractFileList":{"32843":"\u62d3\u5b9e-\u4e2d\u521b\u6da6\u9526\u5408\u540c20260714.pdf","32842":"POTJ26073601.pdf"},"contractScans":["32843","32842"],"is_draft":"0","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u96f6\u552e001","projectContactPoints":"","projectContactPointRels":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12211":{"product_id":"2171","amount":"18000.00","total_amount":"18000.00","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12212":{"product_id":"2267","amount":"42000.00","total_amount":"84000.00","number":"2","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12213":{"product_id":"2267","amount":"99600.00","total_amount":"99600.00","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12214":{"product_id":"868","amount":"42000.00","total_amount":"84000.00","number":"2","description":"GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12215":{"product_id":"2232","amount":"99600.00","total_amount":"99600.00","number":"1","description":"W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"new":{"5":{"product_id":"868","amount":"83962.26","total_amount":"89000.00","number":"1","description":"\u5b9e\u65bd\u670d\u52a1","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"4":{"product_id":"1373","amount":"13274.34","total_amount":"15000.00","number":"1","description":"V3.0\u6807\u51c6\u7248","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"3":{"product_id":"2265","amount":"2654.87","total_amount":"30000.00","number":"10","description":"V1.0\uff081\u5e74\uff09","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"2":{"product_id":"868","amount":"13792.04","total_amount":"155850.00","number":"10","description":"V3.0Base\u7248","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"1":{"product_id":"989","amount":"9247.79","total_amount":"104500.00","number":"10","description":"V6.0Base\u7248","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"0":{"product_id":"1025","amount":"332000.00","total_amount":"332000.00","number":"1","description":"2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}}},"salesContractInvoices":"","projectProductTypes":{"7":{"budget":"18000","profit":"1800","pct":"10"},"23":{"budget":"213600","profit":"21360","pct":"10"},"5":{"budget":"532950","profit":"53295","pct":"10"},"4":{"budget":"347000","profit":"34700","pct":"10"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""},"web_access_token":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 17:21:36', 388413184) RETURNING "id" |