Database Queries

总计8条数据
TimeDurationTypeQuery
  
16:53:10.0430.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1013

16:53:10.0450.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "ledger_access_token"='fm5QrMzndTK8qE2wxJ4UQJeJaYto4p5c'

16:53:10.0460.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

16:53:10.0470.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"='1'

16:53:10.0791.4 msSELECTSELECT "id", "parent_id", "title", "serial_no", "type", "direction", "amount", "year_debit_amount", "year_credit_amount", "balance_amount", "actual_amount", "is_auxiliary_customer", "is_auxiliary_supplier" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"='1' ORDER BY "serial_no", "id"

16:53:10.0810.4 msSELECTSELECT "parent_id" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"='1') AND (parent_id IS NOT NULL) GROUP BY "parent_id"

16:53:10.0921.0 msSELECTSELECT "id", "type", "title", "serial_no" FROM "a57be577deb434"."tbl_ledger_auxiliary_items" WHERE "ledger_id"='1' ORDER BY "type", "sort", "id"

16:53:10.0940.7 msSELECTSELECT "ledger_account_caption_id", "auxiliary_item_id", "amount", "opening_debit_amount", "opening_credit_amount" FROM "a57be577deb434"."tbl_ledger_auxiliary_opening_balances" WHERE "ledger_id"='1'