ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
687076facf0b7: POST https://beta.jinchangxiao.com/v2/pre-sales/save-new at 2025-07-11 10:29:14 am by 223.104.40.121

Database Queries

总计42条数据
TimeDurationTypeQuery
  
10:29:14.8512.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp'

[+] Explain
10:29:14.8551.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017

[+] Explain
10:29:14.8581.3 msINSERTINSERT INTO "a57be577deb434"."tbl_location" ("created_by", "address", "geolocation", "updated_at") VALUES (1017, '北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店', '(116.2890698242188,39.96057969835069)', '2025-07-11 10:29') RETURNING "id"

[+] Explain
10:29:14.8601.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Location', 19238, 'a:6:{s:2:"id";i:19238;s:11:"geolocation";s:37:"(116.2890698242188,39.96057969835069)";s:10:"created_by";i:1017;s:7:"address";s:63:"北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店";s:10:"created_at";N;s:10:"updated_at";s:19:"2025-07-11 10:29:00";}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8610.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19238, 'a:0:{}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8620.8 msINSERTINSERT INTO "a57be577deb434"."tbl_location" ("created_by", "address", "geolocation", "updated_at") VALUES (1017, '北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店', '(116.288586968316,39.96068603515625)', '2025-07-11 10:29') RETURNING "id"

[+] Explain
10:29:14.8630.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Location', 19239, 'a:6:{s:2:"id";i:19239;s:11:"geolocation";s:36:"(116.288586968316,39.96068603515625)";s:10:"created_by";i:1017;s:7:"address";s:63:"北京市海淀区蓝靛厂东路靠近北京世纪星豪酒店";s:10:"created_at";N;s:10:"updated_at";s:19:"2025-07-11 10:29:00";}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8640.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19239, 'a:0:{}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8650.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')

[+] Explain
10:29:14.8660.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"='8279')

[+] Explain
10:29:14.8660.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017)

[+] Explain
10:29:14.8670.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017)

[+] Explain
10:29:14.8670.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19238)

[+] Explain
10:29:14.8670.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19239)

[+] Explain
10:29:14.8671.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_pre_sales" WHERE "case_id"='8279' ORDER BY "id" DESC

[+] Explain
10:29:14.8691.7 msINSERTINSERT INTO "a57be577deb434"."tbl_pre_sales" ("case_id", "client_concerns", "client_id", "description", "end_at", "has_following_work", "is_draft", "pre_sales_assessment", "service_id", "start_at", "updated_at", "created_by", "engineer_id", "indistance", "location_in_id", "outdistance", "location_out_id", "ticket_no") VALUES (8279, '', 2815, '', '2025-07-11 10:29:00', FALSE, FALSE, '', 273, '2025-07-11 10:29:00', 'now()', 1017, 1017, 959.10653305748, 19238, 920.78488929505, 19239, 'PS250711001003') RETURNING "id"

[+] Explain
10:29:14.8710.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PreSales', 1839, 'a:25:{s:2:"id";i:1839;s:9:"client_id";s:4:"2815";s:8:"start_at";s:19:"2025-07-11 10:29:00";s:11:"description";s:0:"";s:15:"client_concerns";s:0:"";s:20:"pre_sales_assessment";s:0:"";s:11:"engineer_id";i:1017;s:10:"created_by";i:1017;s:10:"created_at";N;s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:22:"following_work_content";N;s:14:"project_status";N;s:6:"end_at";s:19:"2025-07-11 10:29:00";s:18:"has_following_work";s:1:"0";s:11:"location_id";N;s:8:"is_draft";s:1:"0";s:7:"case_id";s:4:"8279";s:10:"service_id";s:3:"273";s:14:"location_in_id";i:19238;s:15:"location_out_id";i:19239;s:9:"ticket_no";s:14:"PS250711001003";s:18:"client_document_id";N;s:20:"client_document_file";N;s:10:"indistance";s:16:"959.106533057478";s:11:"outdistance";s:16:"920.784889295054";}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8710.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'

[+] Explain
10:29:14.8721.3 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=4) AND ("object_id"=1839)

[+] Explain
10:29:14.8741.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=23) AND ("object_id"=1839)

[+] Explain
10:29:14.8750.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_attend_pre_sales" WHERE "pre_sales_id"=1839

[+] Explain
10:29:14.8760.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_contacts" WHERE 0=1

[+] Explain
10:29:14.8760.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='5245')

[+] Explain
10:29:14.8770.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_pre_sales" WHERE "id"=1839)

[+] Explain
10:29:14.8771.0 msINSERTINSERT INTO "a57be577deb434"."tbl_contact_attend_pre_sales" ("contact_id", "pre_sales_id") VALUES (5245, 1839) RETURNING "pre_sales_id", "contact_id"

[+] Explain
10:29:14.8780.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ContactAttendPreSales', 0, 'a:3:{s:2:"id";N;s:12:"pre_sales_id";i:1839;s:10:"contact_id";i:5245;}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8790.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_pre_sales" WHERE "id"=1839

[+] Explain
10:29:14.8790.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017

[+] Explain
10:29:14.8801.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 1839, 4, 1017, '2025-07-11 10:29:14', '{"id":1839,"client_id":2815,"start_at":"2025-07-11 10:29:00","description":"","client_concerns":"","pre_sales_assessment":"","engineer_id":1017,"created_by":1017,"created_at":"2025-07-11 10:29:14","updated_at":"2025-07-11 10:29:14","following_work_content":null,"project_status":null,"end_at":"2025-07-11 10:29:00","has_following_work":false,"location_id":null,"is_draft":false,"case_id":8279,"service_id":273,"location_in_id":19238,"location_out_id":19239,"ticket_no":"PS250711001003","client_document_id":null,"client_document_file":null,"indistance":959.10653305748,"outdistance":920.78488929505}', '{"id":1839,"client_id":2815,"start_at":"2025-07-11 10:29:00","description":"","client_concerns":"","pre_sales_assessment":"","engineer_id":1017,"created_by":1017,"created_at":"2025-07-11 10:29:14","updated_at":"2025-07-11 10:29:14","following_work_content":null,"project_status":null,"end_at":"2025-07-11 10:29:00","has_following_work":false,"location_id":null,"is_draft":false,"case_id":8279,"service_id":273,"location_in_id":19238,"location_out_id":19239,"ticket_no":"PS250711001003","client_document_id":null,"client_document_file":null,"indistance":959.10653305748,"outdistance":920.78488929505}', '{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":[]}') RETURNING "id"

[+] Explain
10:29:14.8810.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510522, 'a:13:{s:2:"id";i:510522;s:9:"object_id";i:1839;s:11:"object_type";i:4;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:599:"{"id":1839,"client_id":2815,"start_at":"2025-07-11 10:29:00","description":"","client_concerns":"","pre_sales_assessment":"","engineer_id":1017,"created_by":1017,"created_at":"2025-07-11 10:29:14","updated_at":"2025-07-11 10:29:14","following_work_content":null,"project_status":null,"end_at":"2025-07-11 10:29:00","has_following_work":false,"location_id":null,"is_draft":false,"case_id":8279,"service_id":273,"location_in_id":19238,"location_out_id":19239,"ticket_no":"PS250711001003","client_document_id":null,"client_document_file":null,"indistance":959.10653305748,"outdistance":920.78488929505}";s:9:"new_value";s:599:"{"id":1839,"client_id":2815,"start_at":"2025-07-11 10:29:00","description":"","client_concerns":"","pre_sales_assessment":"","engineer_id":1017,"created_by":1017,"created_at":"2025-07-11 10:29:14","updated_at":"2025-07-11 10:29:14","following_work_content":null,"project_status":null,"end_at":"2025-07-11 10:29:00","has_following_work":false,"location_id":null,"is_draft":false,"case_id":8279,"service_id":273,"location_in_id":19238,"location_out_id":19239,"ticket_no":"PS250711001003","client_document_id":null,"client_document_file":null,"indistance":959.10653305748,"outdistance":920.78488929505}";s:11:"description";s:93:"{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":[]}";s:10:"created_by";i:1017;s:10:"created_at";s:19:"2025-07-11 10:29:14";s:9:"is_delete";N;}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8820.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"=8279

[+] Explain
10:29:14.8830.8 msUPDATEUPDATE "a57be577deb434"."tbl_cases" SET "updated_at"='now()' WHERE "id"=8279

[+] Explain
10:29:14.8840.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Cases', 8279, 'a:1:{s:8:"start_at";s:19:"2025-07-11 08:00:00";}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8840.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017

[+] Explain
10:29:14.8850.9 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 8279, 18, 1839, 4, 1017, '[1839]', '[1839]', '{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":["\u5de5\u5355\u7f16\u53f7:PS250711001003"]}') RETURNING "id"

[+] Explain
10:29:14.8860.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510523, 'a:13:{s:2:"id";i:510523;s:9:"object_id";i:8279;s:11:"object_type";i:18;s:9:"target_id";i:1839;s:18:"target_object_type";i:4;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1839]";s:9:"new_value";s:6:"[1839]";s:11:"description";s:134:"{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":["\u5de5\u5355\u7f16\u53f7:PS250711001003"]}";s:10:"created_by";i:1017;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8870.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"=8279

[+] Explain
10:29:14.8870.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815

[+] Explain
10:29:14.8880.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017

[+] Explain
10:29:14.8881.0 msINSERTINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (1, 'create', 8279, 18, 1839, 4, 1017, '1839', '1839', array[1004,1017], '{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":["\u5de5\u5355\u7f16\u53f7:PS250711001003"]}') RETURNING "id"

[+] Explain
10:29:14.8900.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137130, 'a:15:{s:2:"id";i:137130;s:9:"object_id";i:8279;s:11:"object_type";i:18;s:9:"target_id";i:1839;s:18:"target_object_type";i:4;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:4:"1839";s:9:"new_value";s:4:"1839";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:16:"array[1004,1017]";s:6:"params";a:0:{}}s:11:"description";s:134:"{"d1":"\u8f66\u660e\u98de","d2":"\u521b\u5efa\u4e86","d3":"\u552e\u524d\u5de5\u5355","d4":["\u5de5\u5355\u7f16\u53f7:PS250711001003"]}";s:10:"created_by";i:1017;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1017, '223.104.40.121')

[+] Explain
10:29:14.8911.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1017, 2, 1141, 'v2/pre-sales/save-new', '{"PreSales":{"attendedContacts":["5245"],"case_id":"8279","client_concerns":"","client_id":"2815","description":"","end_at":"2025-07-11 10:29","has_following_work":"0","is_draft":"0","location_in_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","location_in_distance":"959.106533057478","location_in_lat":"39.96057969835069","location_in_lng":"116.2890698242188","location_in_updated_at":"2025-07-11 10:29","location_out_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u84dd\u975b\u5382\u4e1c\u8def\u9760\u8fd1\u5317\u4eac\u4e16\u7eaa\u661f\u8c6a\u9152\u5e97","location_out_distance":"920.784889295054","location_out_lat":"39.96068603515625","location_out_lng":"116.288586968316","location_out_updated_at":"2025-07-11 10:29","pre_sales_assessment":"","service_id":"273","start_at":"2025-07-11 10:29"},"access_token":"LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp","device_type":"2","posttime":"1752200960","token":"2e6a75610ea420db61a83b727a30a0f3","version_code":"1141"}', '{"code":200,"data":{"id":1839},"status":1,"msg":[{"name":"success","success":"\u65b0\u552e\u524d\u5de5\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-11 10:29:14') RETURNING "id"

[+] Explain