686b8d77ca474: POST https://beta.jinchangxiao.com/v2/implement/list at 2025-07-07 05:03:51 pm by 223.160.230.231
Database Queries
总计29条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:03:51.832 | 2.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd' |
| 17:03:51.836 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:03:51.838 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"='8246' |
| 17:03:51.840 | 2.3 ms | SELECT | SELECT COUNT(*) FROM (SELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id WHERE "case_id"=8246 GROUP BY "i"."id" ORDER BY "is_draft" DESC, "i"."has_following_work" DESC, "i"."left_at" DESC) "c" |
| 17:03:51.843 | 4.5 ms | SELECT | SELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id WHERE "case_id"=8246 GROUP BY "i"."id" ORDER BY "is_draft" DESC, "i"."has_following_work" DESC, "i"."left_at" DESC LIMIT 10 |
| 17:03:51.849 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125 |
| 17:03:51.850 | 0.2 ms | SELECT | SELECT "id", "case_status", "client_id", "project_id" FROM "a57be577deb434"."tbl_cases" WHERE "id"=8246 |
| 17:03:51.851 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125 |
| 17:03:51.851 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=4690 |
| 17:03:51.851 | 2.1 ms | SELECT | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_implement_types" WHERE "id"=2 |
| 17:03:51.854 | 1.5 ms | SELECT | SELECT "id", "id" AS "key", "method" AS "name" FROM "a57be577deb434"."tbl_implement_methods" WHERE "id"=1 |
| 17:03:51.855 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125 |
| 17:03:51.856 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 17:03:51.856 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023 |
| 17:03:51.857 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1023) |
| 17:03:51.857 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=2 |
| 17:03:51.858 | 3.2 ms | SELECT | SELECT *, "product_type_id" AS "key" FROM "a57be577deb434"."tbl_implement_product_types" WHERE "implement_id"=6653 |
| 17:03:51.861 | 1.0 ms | SELECT | SELECT id, id as key, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id"=19179 |
| 17:03:51.862 | 0.2 ms | SELECT | SELECT id, id as key, geolocation[0] AS lng, geolocation[1] AS lat, address, updated_at as time FROM "a57be577deb434"."tbl_location" WHERE "id"=19184 |
| 17:03:51.862 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=5) AND ("object_id"=6653) |
| 17:03:51.864 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=24) AND ("object_id"=6653) |
| 17:03:51.865 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_services" WHERE "id"=233 |
| 17:03:51.866 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=33 |
| 17:03:51.866 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_service_type" WHERE "id"=1 |
| 17:03:51.867 | 17.4 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=5) AND ("object_id"=6653) GROUP BY "object_id" |
| 17:03:51.884 | 15.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=5) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=6653) GROUP BY "object_id" |
| 17:03:51.900 | 1.5 ms | SELECT | SELECT "implement_record_id", sum(amount) as count FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" != 4) AND ("status" != 0) AND ("implement_record_id"=6653) GROUP BY "implement_record_id" |
| 17:03:51.902 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "implement_record_id"=6653 ORDER BY array_position(array[0,1,2,3,4], status::integer) |
| 17:03:51.906 | 5.6 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/implement/list', '{"page":"1","pagesize":"10","id":"8246","posttime":"1751879031","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"212cde0b6b3310ab0e0a67df853ba890"}', '{"code":200,"data":{"list":[{"id":6653,"client_id":2125,"contact_id":4690,"implement_type":2,"implement_method":1,"arrived_at":"2025-03-14 13:56:00","left_at":"2025-03-14 17:26:00","address":null,"has_following_work":false,"description":"\u5b9e\u65bd\u76ee\u6807\uff1a\u670d\u52a1\u5b58\u50a8\u8c03\u8bd5\n\u5b8c\u6210\u60c5\u51b5\uff1a\u6620\u5c04\u5e76\u6302\u8f7dSAP\u670d\u52a1\u5668\u5b58\u50a8\uff0c\u90ae\u7bb1\u670d\u52a1\u5668\u6620\u5c04\u591a\u8def\u5f84\u8c03\u8bd5\n\u95ee\u9898\u63cf\u8ff0\uff1a\u65e0\n\u8d39\u7528\uff1a\u5f80\u8fd4\u4ea4\u901a\u8d39112.32","created_by":1023,"created_at":"2025-03-14 13:56:56","updated_at":"2025-03-16 15:09:48","satisfaction_id":null,"implement_address":null,"following_work_content":null,"location_id":null,"client_address":null,"is_draft":0,"service_id":233,"case_id":8246,"location_in_id":19179,"location_out_id":19184,"ticket_no":"IM250314002001","client_document_id":null,"client_document_file":null,"indistance":"26.42972517987","outdistance":"32.345876203477","hours_spent":"03:30:00","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","sales_rep":5087,"logo":null},"case":{"id":8246,"case_status":4,"client_id":2125,"project_id":null,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"project":null},"contact":{"id":4690,"key":4690,"name":"\u56fd\u96f7\u519b"},"implementType":{"id":2,"key":2,"name":"\u552e\u540e\u670d\u52a1"},"implementMethod":{"id":1,"key":1,"name":"\u73b0\u573a\u5b9e\u65bd"},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"implementProductTypes":[{"id":3,"implement_id":6653,"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","description":null,"key":3},{"id":2,"implement_id":6653,"product_type_id":2,"name":"\u670d\u52a1\u5668","description":null,"key":2}],"location":null,"locationIn":{"id":19179,"key":19179,"lng":"116.421587999132","lat":"39.9540728081597","address":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u548c\u5e73\u91cc\u897f\u8857\u9760\u8fd1\u548c\u5e73\u91cc\u793e\u533a\u4e94\u533a","time":"2025-03-14 13:56:00"},"locationOut":{"id":19184,"key":19184,"lng":"116.421424696181","lat":"39.9539838324653","address":"\u5317\u4eac\u5e02\u4e1c\u57ce\u533a\u548c\u5e73\u91cc\u5357\u8857\u9760\u8fd1\u4e2d\u5173\u6751\u96cd\u548c\u822a\u661f\u79d1\u6280\u56ed","time":"2025-03-14 17:26:00"},"clientAddress":null,"attachmentRelationships":[],"files":[],"service":{"id":233,"serial_no":"ZH01","title":"\u7efc\u5408\u670d\u52a1\u534a\u5929","brand_id":33,"type_id":1,"points":25,"points_off_time":25,"points_holiday":25,"description":"\u7efc\u5408\u670d\u52a1\u3002","created_by":1013,"created_at":"2018-11-26 16:21:22","updated_at":"2021-01-12 16:45:09","is_delete":false,"sort":11,"brand":{"id":33,"key":33,"name":"Toast"},"type":{"id":1,"key":1,"name":"\u5b89\u88c5\u670d\u52a1"}},"commentCount":{"object_id":6653,"comment":1},"unreadComments":null,"reimbursementCount":null,"clientDocument":null,"reimbursements":[],"hours_spent_display":"3.5\u5c0f\u65f6","point_display":25,"can_create_items":true,"can_update":true,"can_delete":true,"can_complete":false,"can_create_reimbursement":false,"unread":0,"can_location_in":false,"can_location_out":false}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":10},"can_create":false},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:03:51') RETURNING "id" |