Database Queries

总计75条数据
TimeDurationTypeQuery
  
12:23:01.5752.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

12:23:01.5781.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

12:23:01.5820.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"='2062'

12:23:01.58415.0 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=2062) AND ("object_type"=20012)

12:23:01.59912.0 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=2062) AND ("object_type"=20012)

12:23:01.6110.4 msDELETEDELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=2062) AND ("object_type"=20012)

12:23:01.61292.7 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=2062) AND ("object_type"=20012)) OR (("target_id"=2062) AND ("target_object_type"=20012))

12:23:01.7050.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.7060.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072

12:23:01.7080.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072 ORDER BY "id"

12:23:01.7090.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387

12:23:01.7261.5 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3387

12:23:01.72814.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3387) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

12:23:01.7431.4 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3387, 1005, 'now()', NULL) RETURNING "id"

12:23:01.7451.2 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 177351, 'a:5:{s:2:"id";i:177351;s:9:"client_id";i:3387;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5252, '124.64.23.198')

12:23:01.7460.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', 3387, 'a:0:{}', '', 5252, '124.64.23.198')

12:23:01.7470.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

12:23:01.7480.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 (2, 'update', 3387, 10, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

12:23:01.7490.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', 551516, 'a:13:{s:2:"id";i:551516;s:9:"object_id";i:3387;s:11:"object_type";i:10;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198')

12:23:01.7570.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934

12:23:01.7591.1 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3934

12:23:01.7601.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3934) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

12:23:01.7630.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', 3934, 'a:0:{}', '', 5252, '124.64.23.198')

12:23:01.7640.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387

12:23:01.7640.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

12:23:01.7650.8 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 (2, 'update', 3934, 1, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

12:23:01.7660.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', 551517, 'a:13:{s:2:"id";i:551517;s:9:"object_id";i:3934;s:11:"object_type";i:1;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198')

12:23:01.7680.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

12:23:01.7690.8 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 (2, 'update', 431, 12, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id"

12:23:01.7690.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', 551518, 'a:13:{s:2:"id";i:551518;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198')

12:23:01.7700.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

12:23:01.7710.8 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', 4072, 13, 2062, 20012, 5252, '[2062]', '[2062]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u5220\u9664\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":[""]}') RETURNING "id"

12:23:01.7721.5 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 551519, 'a:13:{s:2:"id";i:551519;s:9:"object_id";i:4072;s:11:"object_type";i:13;s:9:"target_id";i:2062;s:18:"target_object_type";i:20012;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:6:"[2062]";s:9:"new_value";s:6:"[2062]";s:11:"description";s:95:"{"d1":"\u738b\u7b11\u7b11","d2":"\u5220\u9664\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":[""]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198')

12:23:01.7730.8 msUPDATEUPDATE "a57be577deb434"."tbl_erp_payment_tickets" SET "status"=6 WHERE "id"=2062

12:23:01.7740.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPaymentTickets', 2062, 'a:1:{s:6:"status";i:6;}', '', 5252, '124.64.23.198')

12:23:01.7750.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPaymentTickets', 2062, 'a:0:{}', '', 5252, '124.64.23.198')

12:23:01.7760.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2062 ORDER BY "id"

12:23:01.7770.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "erp_payment_ticket_id"=2062 ORDER BY "id"

12:23:01.7770.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=2106

12:23:01.7857.3 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."approve_id"=2106) AND ("t"."status" IN (2, 5))

12:23:01.7930.7 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."approve_id"=2106) AND ("t"."status" IN (2, 5))

12:23:01.7940.4 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."approve_id"=2106) AND ("t"."status" IN (2, 5))

12:23:01.7940.8 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "erp_payment_settle_amount"='0', "erp_payment_un_settle_amount"='1' WHERE "id"=2106

12:23:01.7950.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 2106, 'a:0:{}', '', 5252, '124.64.23.198')

12:23:01.7960.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.7970.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072

12:23:01.8000.6 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8010.4 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8020.5 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8060.7 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8060.3 msSELECTSELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1))

12:23:01.8070.4 msSELECTSELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1))

12:23:01.8070.4 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1)

12:23:01.8080.9 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='7291', "erp_un_settle_amount"='46109' WHERE "id"=4072

12:23:01.8090.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 4072, 'a:2:{s:17:"erp_settle_amount";i:7291;s:20:"erp_un_settle_amount";i:46109;}', '', 5252, '124.64.23.198')

12:23:01.8100.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

12:23:01.8150.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4072

12:23:01.8150.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072

12:23:01.8160.3 msUPDATEUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4072

12:23:01.8160.3 msSELECTSELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8170.3 msSELECTSELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8170.4 msSELECTSELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))

12:23:01.8180.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4072) AND (amount > paid_amount) ORDER BY "remind_date"

12:23:01.8180.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.8190.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_cost_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.8190.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_other_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.8200.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_advance_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.8200.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id"

12:23:01.8201.4 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20019) AND ("object_id"=2062)

12:23:01.8221.7 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2062)

12:23:01.82412.2 msDELETEDELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=2062) AND ("object_type"=20012)

12:23:01.83611.4 msDELETEDELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=2062) AND ("object_type"=20012)

12:23:01.8481.8 msDELETEDELETE FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2062

12:23:01.8500.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\ErpPaymentTickets', 2062, '', '', 5252, '124.64.23.198')

12:23:01.8511.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 5, 'vue/erp-payment-ticket/delete', '{"id":"2062","web_access_token":"zd4K9tC1F9pL73eX9UTaEjjdfA981F9e"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u4ed8\u6b3e\u5355\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-08-04 12:23:01') RETURNING "id"