ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868c194977da: POST https://beta.jinchangxiao.com/vue/analysis/sales-collect-list at 2025-07-05 02:09:24 pm by 223.72.35.175

Database Queries

总计12条数据
TimeDurationTypeQuery
  
14:09:24.6242.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

[+] Explain
14:09:24.6271.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
14:09:24.6314.2 msSELECTSELECT SUM(amount) FROM (SELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"

[+] Explain
14:09:24.6352.9 msSELECTSELECT COUNT(*) FROM (SELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"

[+] Explain
14:09:24.6382.4 msSELECTSELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20

[+] Explain
14:09:24.6410.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3844, 3840, 3837, 3803, 3626, 3418, 3724, 3763, 2961, 2978, 3811, 3629, 3796, 3345, 3745, 3809, 3808, 3758)

[+] Explain
14:09:24.6420.4 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3566, 3602, 3694, 3663, 3721, 3767, 3744, 3765, 3777, 3772, 3791, 3367, 3294, 3806, 3801, 3789, 3786, 3807)

[+] Explain
14:09:24.6420.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5087, 1005, 1001, 5295)

[+] Explain
14:09:24.6430.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1181, 2526, 20, 3327, 12, 107, 518, 2136, 57, 4, 531, 3334, 3300, 287, 3304, 3278)

[+] Explain
14:09:24.6443.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')

[+] Explain
14:09:24.6480.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=170, "last_visit_at"='now()' WHERE "id"=49799

[+] Explain
14:09:24.6491.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/sales-collect-list', '{"id":"","page":"1","project_status":"3","status":"collected","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":2163,"contract_id":3844,"amount":"1","created_by":1001,"created_at":"2025-06-11 13:43:46","collected_date":"2025-06-11","description":"\u6d4b\u8bd5","paid_amount":"1","project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898","budget":"8000","bargain_date":"2025-04-09","created_by":1001,"client_id":3278,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-11"},{"id":2162,"contract_id":3840,"amount":"34000","created_by":5250,"created_at":"2025-06-09 18:05:34","collected_date":"2025-06-09","description":"sdf sdf sdf ","paid_amount":"4222","project":{"id":3807,"key":3807,"name":"\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a","budget":"34000","bargain_date":"2025-06-09","created_by":1001,"client_id":3304,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-09"},{"id":2161,"contract_id":3837,"amount":"7.10","created_by":5016,"created_at":"2025-06-03 17:46:44","collected_date":"2025-06-03","description":"","paid_amount":"0","project":{"id":3806,"key":3806,"name":"dddd","budget":"700","bargain_date":"2025-06-03","created_by":5087,"client_id":3300,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3300,"key":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09"}},"created_at_display":"2025-06-03"},{"id":2160,"contract_id":3837,"amount":"645.95","created_by":5016,"created_at":"2025-06-03 17:44:43","collected_date":"2025-06-03","description":"","paid_amount":"0","project":{"id":3806,"key":3806,"name":"dddd","budget":"700","bargain_date":"2025-06-03","created_by":5087,"client_id":3300,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3300,"key":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09"}},"created_at_display":"2025-06-03"},{"id":2159,"contract_id":3837,"amount":"46.95","created_by":5016,"created_at":"2025-06-03 17:44:31","collected_date":"2025-06-03","description":"","paid_amount":"0","project":{"id":3806,"key":3806,"name":"dddd","budget":"700","bargain_date":"2025-06-03","created_by":5087,"client_id":3300,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3300,"key":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09"}},"created_at_display":"2025-06-03"},{"id":2156,"contract_id":3803,"amount":"-1","created_by":1001,"created_at":"2025-05-08 09:15:53","collected_date":"2025-05-08","description":"ces ","paid_amount":"0","project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","budget":"3593747","bargain_date":"2025-02-28","created_by":1001,"client_id":3334,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-05-08"},{"id":2137,"contract_id":3626,"amount":"737875","created_by":1013,"created_at":"2025-03-17 15:20:32","collected_date":"2025-03-17","description":"","paid_amount":"737875","project":{"id":3694,"key":3694,"name":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C","budget":"2672450","bargain_date":"2024-12-31","created_by":5300,"client_id":287,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"}},"created_at_display":"2025-03-17"},{"id":2136,"contract_id":3418,"amount":"7600","created_by":1013,"created_at":"2025-03-17 15:14:41","collected_date":"2025-03-17","description":"","paid_amount":"7600","project":{"id":3602,"key":3602,"name":"\u4e0a\u6d77\u6da6\u8bfa\u8ba2\u5355-PO#20240711184-186\uff1b20240716015","budget":"7600","bargain_date":"2024-07-17","created_by":1005,"client_id":57,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-03-17"},{"id":2135,"contract_id":3724,"amount":"12600.9","created_by":1013,"created_at":"2025-03-12 17:16:52","collected_date":"2025-03-12","description":"","paid_amount":"12600.9","project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"126009","bargain_date":"2024-12-25","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-12"},{"id":2134,"contract_id":3763,"amount":"12136.1","created_by":1013,"created_at":"2025-03-12 17:16:37","collected_date":"2025-03-12","description":"","paid_amount":"12136.1","project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","budget":"121361","bargain_date":"2025-01-16","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-03-12"},{"id":2133,"contract_id":2961,"amount":"45644","created_by":1013,"created_at":"2025-03-10 11:25:35","collected_date":"2025-03-10","description":"","paid_amount":"45644","project":{"id":3294,"key":3294,"name":"\u5b89\u5168\u8f6f\u4ef6\u91c7\u8d2d-K","budget":"456440","bargain_date":"2023-11-30","created_by":5087,"client_id":2136,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"}},"created_at_display":"2025-03-10"},{"id":2132,"contract_id":2978,"amount":"82560","created_by":1013,"created_at":"2025-03-10 11:21:54","collected_date":"2025-03-10","description":"","paid_amount":"82560","project":{"id":3367,"key":3367,"name":"\u6570\u636e\u5e93\u4e2d\u95f4\u4ef6\u8f6f\u4ef6\u91c7\u8d2d-K","budget":"825600","bargain_date":"2023-11-30","created_by":5087,"client_id":2136,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"}},"created_at_display":"2025-03-10"},{"id":2131,"contract_id":3811,"amount":"3150","created_by":1013,"created_at":"2025-03-10 11:16:35","collected_date":"2025-03-10","description":"","paid_amount":"3150","project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","budget":"3150","bargain_date":"2025-03-05","created_by":5300,"client_id":531,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-03-10"},{"id":2130,"contract_id":3629,"amount":"182000","created_by":1013,"created_at":"2025-03-10 11:13:30","collected_date":"2025-03-10","description":"","paid_amount":"182000","project":{"id":3663,"key":3663,"name":"VM300-Credit\u65b0\u8d2d1\u5e74-K-2024","budget":"182000","bargain_date":"2024-10-18","created_by":5300,"client_id":1181,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":1181,"key":1181,"name":"\u5148\u6b63\u8fbe\u751f\u7269\u79d1\u6280(\u4e2d\u56fd);\u5148\u6b63\u8fbe(\u4e2d\u56fd)\u6295\u8d44\u6709\u9650\u516c\u53f8;\u5317\u4eac\u65ed\u65e5\u4f73\u4e1a\u7f51\u7edc\u6709\u9650\u516c\u53f8\uff08CAE\/EDA\/BIO\uff09"}},"created_at_display":"2025-03-10"},{"id":2129,"contract_id":3796,"amount":"28000","created_by":1013,"created_at":"2025-03-07 11:17:36","collected_date":"2025-03-07","description":"","paid_amount":"28000","project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","budget":"28000","bargain_date":"2025-02-17","created_by":5295,"client_id":518,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-07"},{"id":2128,"contract_id":3345,"amount":"19080","created_by":1013,"created_at":"2025-03-06 18:10:01","collected_date":"2025-12-16","description":"\u822a\u4fe1\u5e73\u53f02024\u5e7412\u670816\u65e5\u63a5\u6536\u5ef6\u671f\u6536\u6b3e\uff0c\u627f\u8bfa\u4ed8\u6b3e\u65e52025-12-16","paid_amount":"19080","project":{"id":3566,"key":3566,"name":"VPN\u5bc6\u7801\u673a\u91c7\u8d2d-K\uff08\u76f4\u7b7e\uff09","budget":"19080","bargain_date":"2024-08-16","created_by":5087,"client_id":2526,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-12-16"},{"id":2127,"contract_id":3745,"amount":"117000","created_by":1013,"created_at":"2025-03-06 17:01:51","collected_date":"2025-03-06","description":"","paid_amount":"117000","project":{"id":3721,"key":3721,"name":"MSS24-25\u5e74\u7eed\u4fdd","budget":"117000","bargain_date":"2025-01-03","created_by":1005,"client_id":20,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-03-06"},{"id":2126,"contract_id":3809,"amount":"1700","created_by":1013,"created_at":"2025-03-06 17:01:07","collected_date":"2025-03-06","description":"","paid_amount":"22","project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","budget":"1700","bargain_date":"2025-03-04","created_by":5300,"client_id":4,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-06"},{"id":2125,"contract_id":3808,"amount":"35100","created_by":1013,"created_at":"2025-03-06 17:00:25","collected_date":"2025-03-06","description":"","paid_amount":"35100","project":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K","budget":"35100","bargain_date":"2025-02-20","created_by":5295,"client_id":107,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-06"},{"id":2124,"contract_id":3758,"amount":"7156","created_by":1013,"created_at":"2025-03-05 11:54:38","collected_date":"2025-03-05","description":"","paid_amount":"7156","project":{"id":3765,"key":3765,"name":"POTJ25013200-\u534e\u4e09\u7f51\u7edc\u8bbe\u59072-G-2025","budget":"7156","bargain_date":"2025-01-14","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-03-05"}],"sumAmount":"330484989.66","pagenation":{"totalcount":1856,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:09:24') RETURNING "id"

[+] Explain