ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68737c8a050c7: POST https://beta.jinchangxiao.com/v2/schedule/delete at 2025-07-13 05:29:46 pm by 120.244.156.33

Database Queries

总计40条数据
TimeDurationTypeQuery
  
17:29:46.0242.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc'

[+] Explain
17:29:46.0271.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:29:46.0290.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17705'

[+] Explain
17:29:46.030119.6 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=17705) AND ("object_type"=9)

[+] Explain
17:29:46.1509.9 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=17705) AND ("object_type"=9)

[+] Explain
17:29:46.1613.2 msDELETEDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=17705) AND ("object_type"=9)

[+] Explain
17:29:46.1641.3 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17705)

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

[+] Explain
17:29:46.1681.2 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815

[+] Explain
17:29:46.1699.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
17:29:46.1791.1 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id"

[+] Explain
17:29:46.1801.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165365, 'a:5:{s:2:"id";i:165365;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1004, '120.244.156.33')

[+] Explain
17:29:46.1810.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1004, '120.244.156.33')

[+] Explain
17:29:46.1820.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:29:46.1830.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 (3, 'delete', 2815, 10, 17705, 9, 1004, '[17705]', '[17705]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"

[+] Explain
17:29:46.1840.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510848, 'a:13:{s:2:"id";i:510848;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:7:"[17705]";s:9:"new_value";s:7:"[17705]";s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.33')

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

[+] Explain
17:29:46.1850.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:29:46.1861.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 (3, 'delete', 2815, 10, 17705, 9, 1004, '17705', '17705', array[1004], '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"

[+] Explain
17:29:46.1870.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137242, 'a:15:{s:2:"id";i:137242;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:5:"17705";s:9:"new_value";s:5:"17705";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1004, '120.244.156.33')

[+] Explain
17:29:46.1880.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3822

[+] Explain
17:29:46.1900.9 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3822

[+] Explain
17:29:46.1911.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3822) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
17:29:46.1920.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3822, 'a:0:{}', '', 1004, '120.244.156.33')

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

[+] Explain
17:29:46.1940.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:29:46.1940.7 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 (3, 'delete', 3822, 1, 17705, 9, 1004, '[17705]', '[17705]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"

[+] Explain
17:29:46.1950.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', 510849, 'a:13:{s:2:"id";i:510849;s:9:"object_id";i:3822;s:11:"object_type";i:1;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:7:"[17705]";s:9:"new_value";s:7:"[17705]";s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.33')

[+] Explain
17:29:46.1960.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3822

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

[+] Explain
17:29:46.1970.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:29:46.1970.8 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 (3, 'delete', 3822, 1, 17705, 9, 1004, '17705', '17705', array[1004], '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"

[+] Explain
17:29:46.1980.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', 137243, 'a:15:{s:2:"id";i:137243;s:9:"object_id";i:3822;s:11:"object_type";i:1;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:5:"17705";s:9:"new_value";s:5:"17705";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1004, '120.244.156.33')

[+] Explain
17:29:46.199705.8 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=17705) AND ("object_type"=9)) OR (("target_id"=17705) AND ("target_object_type"=9))

[+] Explain
17:29:46.905319.2 msUPDATEUPDATE "a57be577deb434"."tbl_user_action_logs" SET "is_delete"=TRUE WHERE (("object_id"=17705) AND ("object_type"=9)) OR (("target_id"=17705) AND ("target_object_type"=9))

[+] Explain
17:29:47.22410.9 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=17705) AND ("object_type"=9)

[+] Explain
17:29:47.23510.4 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=17705) AND ("object_type"=9)

[+] Explain
17:29:47.2466.1 msDELETEDELETE FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17705

[+] Explain
17:29:47.2520.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Schedules', 17705, '', '', 1004, '120.244.156.33')

[+] Explain
17:29:47.2531.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1141, 'v2/schedule/delete', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","id":"17705","posttime":"1752398976","token":"45907ecadba4b5b3e50c42176aa97fbf","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5f85\u529e\u4e8b\u9879\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}]}', FALSE, '2025-07-13 17:29:47') RETURNING "id"

[+] Explain