Database Queries

总计22条数据
TimeDurationTypeQuery
  
10:09:03.9622.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'

10:09:03.9651.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

10:09:03.9680.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='6012'

10:09:03.9690.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689

10:09:03.9701.1 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_implement_records" WHERE "contact_id"=6012)

10:09:03.9710.9 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "contact_id"=6012)

10:09:03.9721.0 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "mp_submit_contact_id"=6012)

10:09:03.9730.7 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "contact_id"=6012)

10:09:03.9740.7 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_callback_records" WHERE "mp_submit_contact_id"=6012)

10:09:03.9762.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_attend_pre_sales" WHERE "contact_id"=6012)

10:09:03.9780.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_attend_pre_sales" WHERE "contact_id"=6012)

10:09:03.9781.6 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "contact_id"=6012)

10:09:03.9815.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "contact_id"=6012)

10:09:03.9881.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_operation_contacts" WHERE "contact_id"=6012)

10:09:03.9905.0 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE "contact_id"=6012)

10:09:03.9951.2 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', 689, 12, 6012, 15, 1000, '6012', '6012', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["\u9e21\u86cb\u9171"]}') RETURNING "id"

10:09:03.9971.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510498, 'a:13:{s:2:"id";i:510498;s:9:"object_id";i:689;s:11:"object_type";i:12;s:9:"target_id";i:6012;s:18:"target_object_type";i:15;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:4:"6012";s:9:"new_value";s:4:"6012";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["\u9e21\u86cb\u9171"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.40.121')

10:09:03.998709.2 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=6012) AND ("object_type"=15)) OR (("target_id"=6012) AND ("target_object_type"=15))

10:09:04.7080.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689

10:09:04.70818.3 msDELETEDELETE FROM "a57be577deb434"."tbl_contacts" WHERE "id"=6012

10:09:04.7270.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Contacts', 6012, '', '', 1000, '223.104.40.121')

10:09:04.7281.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/contact/delete', '{"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","id":"6012","posttime":"1752199680","token":"f1fd7f9cc38f3d485422fbc6b735b07d","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u8054\u7cfb\u4eba\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}]}', FALSE, '2025-07-11 10:09:04') RETURNING "id"