68c902fbdbe0a: POST https://beta.jinchangxiao.com/vue/erp-purchase-cost/list at 2025-09-16 02:26:03 pm by 114.244.128.96
Database Queries
总计8条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:26:03.922 | 3.4 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1011 |
| 14:26:03.926 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 14:26:03.935 | 1.6 ms | SELECT | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_erp_purchase_cost_visibles" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1011) AND (s.accessible_user IS NOT NULL) GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 14:26:03.937 | 2.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 1011 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 1011 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_purchase_costs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" "rvr" ON rvr.erp_purchase_cost_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" "rsvr" ON rvr.erp_purchase_cost_id = r.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "c" ON c.id = r.purchase_contract_id LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 WHERE ("r"."status"=2) AND (r.is_done = false) AND (("r"."created_by"=1011) OR ("rvr"."user_id"=1011) OR ("r"."created_by" IN (5030, 5351, 5026, 5203, 5025, 5072, 5105, 1004, 5299, 1001, 5037, 5446, 1027, 5045, 5087, 5094, 5123, 1008, 1029, 5048, 5043, 1025, 1003, 5208, 5305, 5078, 1015, 5449, 5358, 1023, 5064, 1026, 5089, 5027, 1007, 5258, 5135, 5076, 5071, 5209, 1028, 5083, 5081, 5033, 5440, 5229, 5104, 5359, 5412, 5409, 5393, 5062, 5360, 5247, 5015, 5023, 5126, 5124, 1022, 5022, 5311, 5248, 5128, 1000, 5333, 1006, 1014, 5093, 5297, 5249, 5095, 5082, 1012, 5070, 5096, 5420, 5063, 5102, 5028, 5259, 5445, 5448, 5298, 5075, 5388, 5230, 5073, 5404, 1021, 1030, 5069, 5066, 5079, 1020, 5252, 5364, 5309, 5411, 5301, 5049, 5419, 5044, 1018, 5088, 5031, 1013, 5074, 5413, 5125, 5101, 5024, 5300, 1016, 5293, 5250, 5047, 5029, 5304, 5296, 1005, 1017, 5050, 1019, 5080, 5032, 5085, 5332, 1011, 1011, 1002, 5065, 5086, 5294, 5357, 5329, 1010, 5356, 5016, 5295, 1009, 5302, 5303))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1011))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC) "c" |
| 14:26:03.940 | 1.5 ms | SELECT | SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 1011 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 1011 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_purchase_costs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" "rvr" ON rvr.erp_purchase_cost_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" "rsvr" ON rvr.erp_purchase_cost_id = r.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "c" ON c.id = r.purchase_contract_id LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 WHERE ("r"."status"=2) AND (r.is_done = false) AND (("r"."created_by"=1011) OR ("rvr"."user_id"=1011) OR ("r"."created_by" IN (5030, 5351, 5026, 5203, 5025, 5072, 5105, 1004, 5299, 1001, 5037, 5446, 1027, 5045, 5087, 5094, 5123, 1008, 1029, 5048, 5043, 1025, 1003, 5208, 5305, 5078, 1015, 5449, 5358, 1023, 5064, 1026, 5089, 5027, 1007, 5258, 5135, 5076, 5071, 5209, 1028, 5083, 5081, 5033, 5440, 5229, 5104, 5359, 5412, 5409, 5393, 5062, 5360, 5247, 5015, 5023, 5126, 5124, 1022, 5022, 5311, 5248, 5128, 1000, 5333, 1006, 1014, 5093, 5297, 5249, 5095, 5082, 1012, 5070, 5096, 5420, 5063, 5102, 5028, 5259, 5445, 5448, 5298, 5075, 5388, 5230, 5073, 5404, 1021, 1030, 5069, 5066, 5079, 1020, 5252, 5364, 5309, 5411, 5301, 5049, 5419, 5044, 1018, 5088, 5031, 1013, 5074, 5413, 5125, 5101, 5024, 5300, 1016, 5293, 5250, 5047, 5029, 5304, 5296, 1005, 1017, 5050, 1019, 5080, 5032, 5085, 5332, 1011, 1011, 1002, 5065, 5086, 5294, 5357, 5329, 1010, 5356, 5016, 5295, 1009, 5302, 5303))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1011))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC LIMIT 20 |
| 14:26:03.942 | 3.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=20000) AND ("visit_date"='2025-09-16') |
| 14:26:03.946 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=16, "last_visit_at"='now()' WHERE "id"=56581 |
| 14:26:03.947 | 1.1 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/erp-purchase-cost/list', '{"Filter":{"name":"default","sort":"DESC"},"ErpPurchaseCostSearch":{"wrote_date_period":"","status":"","contract_scan":"","is_done":"0","handler":"","created_by":"","number_range_to":"","number_range_from":"","amount_range_to":"","amount_range_from":""},"page":"1","web_access_token":"3M9IHFflx5fM6tRnS_F7r08k8HZ6t6eP"}', '{"code":2000,"result":{"list":[],"can_create":false,"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 14:26:03') RETURNING "id" |