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

Database Queries

总计22条数据
TimeDurationTypeQuery
  
10:28:56.1172.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp'

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

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

[+] Explain
10:28:56.1261.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', 19236, 'a:6:{s:2:"id";i:19236;s:11:"geolocation";s:37:"(116.2890785047743,39.96062825520833)";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:28:00";}', '', 1017, '223.104.40.121')

[+] Explain
10:28:56.1270.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', 19236, 'a:0:{}', '', 1017, '223.104.40.121')

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

[+] Explain
10:28:56.1290.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', 19237, 'a:6:{s:2:"id";i:19237;s:11:"geolocation";s:37:"(116.2890117730035,39.96051378038194)";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:28:00";}', '', 1017, '223.104.40.121')

[+] Explain
10:28:56.1300.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', 19237, 'a:0:{}', '', 1017, '223.104.40.121')

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

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

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

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

[+] Explain
10:28:56.1330.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19236)

[+] Explain
10:28:56.1330.1 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19237)

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

[+] Explain
10:28:56.1343.5 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:28:00', FALSE, TRUE, '', 273, '2025-07-11 10:28:00', 'now()', 1017, 1017, 956.05850737637, 19236, 960.36584996089, 19237, 'PS250711001002') RETURNING "id"

[+] Explain
10:28:56.1380.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PreSales', 1838, 'a:25:{s:2:"id";i:1838;s:9:"client_id";s:4:"2815";s:8:"start_at";s:19:"2025-07-11 10:28: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:28:00";s:18:"has_following_work";s:1:"0";s:11:"location_id";N;s:8:"is_draft";s:1:"1";s:7:"case_id";s:4:"8279";s:10:"service_id";s:3:"273";s:14:"location_in_id";i:19236;s:15:"location_out_id";i:19237;s:9:"ticket_no";s:14:"PS250711001002";s:18:"client_document_id";N;s:20:"client_document_file";N;s:10:"indistance";s:16:"956.058507376369";s:11:"outdistance";s:16:"960.365849960891";}', '', 1017, '223.104.40.121')

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

[+] Explain
10:28:56.1401.3 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=4) AND ("object_id"=1838)

[+] Explain
10:28:56.1411.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=23) AND ("object_id"=1838)

[+] Explain
10:28:56.1430.3 msDELETEDELETE FROM "a57be577deb434"."tbl_contact_attend_pre_sales" WHERE "pre_sales_id"=1838

[+] Explain
10:28:56.1431.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":"","case_id":"8279","client_concerns":"","client_id":"2815","description":"","end_at":"2025-07-11 10:28","has_following_work":"0","is_draft":"1","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":"956.058507376369","location_in_lat":"39.96062825520833","location_in_lng":"116.2890785047743","location_in_updated_at":"2025-07-11 10:28","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":"960.365849960891","location_out_lat":"39.96051378038194","location_out_lng":"116.2890117730035","location_out_updated_at":"2025-07-11 10:28","pre_sales_assessment":"","service_id":"273","start_at":"2025-07-11 10:28"},"access_token":"LaARkbjpq8ODkVzzYWTT4va5Qt3CsuSp","device_type":"2","posttime":"1752200960","token":"71a36a659e43157daff3c57fd9ffaefd","version_code":"1141"}', '{"code":200,"data":{"id":1838},"status":1,"msg":[{"name":"success","success":"\u65b0\u552e\u524d\u5de5\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-11 10:28:56') RETURNING "id"

[+] Explain