ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2109085e97b: POST https://beta.jinchangxiao.com/vue/sales-contract/list-invoice at 2026-06-04 01:11:36 pm by 221.216.117.119

Database Queries

总计18条数据
TimeDurationTypeQuery
  
13:11:36.3890.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:11:36.3910.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
13:11:36.3940.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='2148'

[+] Explain
13:11:36.3956.4 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
13:11:36.40121.4 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
13:11:36.4653.4 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_contract_invoices' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
13:11:36.46914.7 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_contract_invoices' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
13:11:36.4851.3 msSELECTSELECT COUNT(*) FROM (SELECT sci.* FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (sci.cover_invoice_id is null) AND (("sci"."invoice_type" != '-1') OR (sci.invoice_type is null)) AND ("sci"."is_cancel"=FALSE) AND ("contract_id"=2148) GROUP BY "sci"."id" ORDER BY "from_date" DESC, "created_at" DESC) "c"

[+] Explain
13:11:36.4861.1 msSELECTSELECT sci.* FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (sci.cover_invoice_id is null) AND (("sci"."invoice_type" != '-1') OR (sci.invoice_type is null)) AND ("sci"."is_cancel"=FALSE) AND ("contract_id"=2148) GROUP BY "sci"."id" ORDER BY "from_date" DESC, "created_at" DESC LIMIT 20

[+] Explain
13:11:36.4870.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 5388, 1011, 5015)

[+] Explain
13:11:36.4880.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5015, 5252, 5388, 1011))

[+] Explain
13:11:36.4880.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 6, 3)

[+] Explain
13:11:36.4890.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=9008

[+] Explain
13:11:36.4892.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1739, 1600, 1377, 1285, 1142))

[+] Explain
13:11:36.4912.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1739, 1600, 1377, 1285, 1142))

[+] Explain
13:11:36.4930.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9008, 11266, 12828, 17685, 20695)

[+] Explain
13:11:36.4940.4 msSELECTSELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (1739, 1600, 1377, 1285, 1142) ORDER BY "id"

[+] Explain
13:11:36.4951.1 msINSERTINSERT 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/list-invoice', '{"contract_id":"2148","page":"1","web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"list":[{"id":1739,"contract_id":2148,"from_date":"2024-08-05","attachment_id":"","amount":"177980.00","created_by":5252,"created_at":"2024-08-05 16:27:34","description":"","invoice_num":"24112000000099506769","invoice_type":1,"is_match":true,"is_cancel":false,"is_used":true,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"20475.58","excluding_tax":"157504.42","is_draft":false,"updated_at":"2024-08-29 10:31:32","need_match":true,"need_match_description":"","match_tax_amount":"19656.55","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":true,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{"path":"\/vue\/attachment\/preview\/\/"},"attachmentRelationships":[],"files":[{"id":28223,"object_type":102,"object_id":1739,"attachment_id":20695,"attachment":{"id":20695,"key":20695,"name":"fa1719be-3ef4-3be7-bced-6f27899d3683","extension":"pdf","path":"\/vue\/attachment\/view\/fa1719be-3ef4-3be7-bced-6f27899d3683\/dzfp_24112000000099506769_\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e_20240805162547.pdf","orig_name":"dzfp_24112000000099506769_\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e_20240805162547.pdf"}}],"salesInvoiceAmounts":[{"id":51,"sales_invoice_id":1739,"amount":"177980","tax_rate":"13"}]},{"id":1600,"contract_id":2148,"from_date":"2024-02-21","attachment_id":"","amount":"60774.00","created_by":5388,"created_at":"2024-02-21 13:58:50","description":"","invoice_num":"","invoice_type":"","is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"","excluding_tax":"","is_draft":true,"updated_at":"","need_match":true,"need_match_description":"","match_tax_amount":"","simple_match_tax_amount":"","is_settle":false,"is_contract_cancel":true,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{"path":"\/vue\/attachment\/preview\/\/"},"attachmentRelationships":[],"files":[{"id":24054,"object_type":102,"object_id":1600,"attachment_id":17685,"attachment":{"id":17685,"key":17685,"name":"fce8fe8b-cfec-3431-875c-8f68201401c2","extension":"pdf","path":"\/vue\/attachment\/view\/fce8fe8b-cfec-3431-875c-8f68201401c2\/dzfp_24112000000005911171_\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e_20240221135748.pdf","orig_name":"dzfp_24112000000005911171_\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e_20240221135748.pdf"}}],"salesInvoiceAmounts":[{"id":2701,"sales_invoice_id":1600,"amount":"60774.00","tax_rate":"13"}]},{"id":1377,"contract_id":2148,"from_date":"2023-04-07","attachment_id":"","amount":"1067880.00","created_by":1011,"created_at":"2023-04-21 13:59:31","description":"","invoice_num":"","invoice_type":"","is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"","excluding_tax":"","is_draft":true,"updated_at":"","need_match":true,"need_match_description":"","match_tax_amount":"","simple_match_tax_amount":"","is_settle":false,"is_contract_cancel":true,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{"path":"\/vue\/attachment\/preview\/\/"},"attachmentRelationships":[],"files":[{"id":18150,"object_type":102,"object_id":1377,"attachment_id":12828,"attachment":{"id":12828,"key":12828,"name":"28aaf2dc-73b7-35eb-8642-68402002e4fc","extension":"pdf","path":"\/vue\/attachment\/view\/28aaf2dc-73b7-35eb-8642-68402002e4fc\/2023_04_07_14_57_10.pdf","orig_name":"2023_04_07_14_57_10.pdf"}}],"salesInvoiceAmounts":[{"id":2700,"sales_invoice_id":1377,"amount":"1067880.00","tax_rate":"13"}]},{"id":1285,"contract_id":2148,"from_date":"2022-10-18","attachment_id":"","amount":"520920.00","created_by":1011,"created_at":"2022-10-18 15:29:36","description":"","invoice_num":"","invoice_type":"","is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"","excluding_tax":"","is_draft":true,"updated_at":"","need_match":true,"need_match_description":"","match_tax_amount":"","simple_match_tax_amount":"","is_settle":false,"is_contract_cancel":true,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{"path":"\/vue\/attachment\/preview\/\/"},"attachmentRelationships":[],"files":[{"id":16368,"object_type":102,"object_id":1285,"attachment_id":11266,"attachment":{"id":11266,"key":11266,"name":"f317ee02-8d2b-3133-94e4-61b79074ec93","extension":"pdf","path":"\/vue\/attachment\/view\/f317ee02-8d2b-3133-94e4-61b79074ec93\/2022_10_18_15_29_02.pdf","orig_name":"2022_10_18_15_29_02.pdf"}}],"salesInvoiceAmounts":[{"id":2698,"sales_invoice_id":1285,"amount":"520920.00","tax_rate":"13"}]},{"id":1142,"contract_id":2148,"from_date":"2021-12-02","attachment_id":9008,"amount":"794400.00","created_by":5015,"created_at":"2021-12-02 17:33:29","description":"","invoice_num":"","invoice_type":"","is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"","excluding_tax":"","is_draft":true,"updated_at":"","need_match":true,"need_match_description":"","match_tax_amount":"","simple_match_tax_amount":"","is_settle":false,"is_contract_cancel":true,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"attachment":{"id":9008,"key":9008,"name":"d4422171-20c6-3348-bac0-32699323c026","extension":"pdf","path":"\/vue\/attachment\/preview\/d4422171-20c6-3348-bac0-32699323c026\/2021_12_02_17_29_59.pdf","orig_name":"2021_12_02_17_29_59.pdf"},"attachmentRelationships":[],"files":[{"id":6655,"object_type":102,"object_id":1142,"attachment_id":9008,"attachment":{"id":9008,"key":9008,"name":"d4422171-20c6-3348-bac0-32699323c026","extension":"pdf","path":"\/vue\/attachment\/view\/d4422171-20c6-3348-bac0-32699323c026\/2021_12_02_17_29_59.pdf","orig_name":"2021_12_02_17_29_59.pdf"}}],"salesInvoiceAmounts":[{"id":2699,"sales_invoice_id":1142,"amount":"794400.00","tax_rate":"13"}]}],"pagenation":{"totalcount":5,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 13:11:36', 107117056) RETURNING "id"

[+] Explain