686771477009e: POST https://beta.jinchangxiao.com/v2/search/pre-sales-by-self at 2025-07-04 02:14:31 pm by 114.254.1.137
Database Queries
总计5条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:14:31.462 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd' |
| 14:14:31.465 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:14:31.470 | 3.7 ms | SELECT | SELECT COUNT(*) FROM (SELECT p.id, p.client_id, p.start_at, p.description, p.engineer_id, p.created_by, p.created_at, p.updated_at, p.following_work_content, p.project_status, p.end_at, p.location_id, p.is_draft, p.service_id, p.client_concerns, p.pre_sales_assessment, p.case_id, p.location_in_id, p.location_out_id, p.ticket_no, p.client_document_id, p.client_document_file, p.has_following_work, p.end_at - p.start_at AS hours_spent, p.indistance, p.outdistance FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "ca" ON p.case_id = ca.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = ca.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales_product_types" "pt" ON p.id = pt.pre_sales_id LEFT JOIN "a57be577deb434"."tbl_client_types" "clientType" ON "clientType".id = client.client_type LEFT JOIN "a57be577deb434"."tbl_client_classes" "clientClass" ON "clientClass".id = client.client_class LEFT JOIN "a57be577deb434"."tbl_client_industries" "clientIndustry" ON "clientIndustry".id = client.client_industry LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep".id = client.sales_rep WHERE (("client"."deleted"=FALSE) OR ("ca"."client_id" IS NULL)) AND ("p"."created_by"=1000) AND ("is_draft"=FALSE) AND ("ca"."client_id"='2815') AND ("ca"."project_id"='3811') GROUP BY "p"."id" ORDER BY "is_draft" DESC, "p"."end_at" DESC) "c" |
| 14:14:31.474 | 2.1 ms | SELECT | SELECT p.id, p.client_id, p.start_at, p.description, p.engineer_id, p.created_by, p.created_at, p.updated_at, p.following_work_content, p.project_status, p.end_at, p.location_id, p.is_draft, p.service_id, p.client_concerns, p.pre_sales_assessment, p.case_id, p.location_in_id, p.location_out_id, p.ticket_no, p.client_document_id, p.client_document_file, p.has_following_work, p.end_at - p.start_at AS hours_spent, p.indistance, p.outdistance FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "ca" ON p.case_id = ca.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = ca.project_id LEFT JOIN "a57be577deb434"."tbl_pre_sales_product_types" "pt" ON p.id = pt.pre_sales_id LEFT JOIN "a57be577deb434"."tbl_client_types" "clientType" ON "clientType".id = client.client_type LEFT JOIN "a57be577deb434"."tbl_client_classes" "clientClass" ON "clientClass".id = client.client_class LEFT JOIN "a57be577deb434"."tbl_client_industries" "clientIndustry" ON "clientIndustry".id = client.client_industry LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep".id = client.sales_rep WHERE (("client"."deleted"=FALSE) OR ("ca"."client_id" IS NULL)) AND ("p"."created_by"=1000) AND ("is_draft"=FALSE) AND ("ca"."client_id"='2815') AND ("ca"."project_id"='3811') GROUP BY "p"."id" ORDER BY "is_draft" DESC, "p"."end_at" DESC LIMIT 20 |
| 14:14:31.477 | 1.2 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, 0, 261, 'v2/search/pre-sales-by-self', '{"project_id":"3811","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","client_id":"2815","device_type":"0","version_code":"261","page":"1","token":"d06d569432a1c40a317f2385d5eef830","case_id":"","posttime":"1751609672"}', '{"code":200,"data":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-04 14:14:31') RETURNING "id" |