All Latest
6a42439f5cdc6: POST https://beta.jinchangxiao.com/vue/voucher-center/bill-list at 2026-06-29 06:06:23 pm by 221.216.117.25

Performance Profiling

Total processing time: 33 ms; Peak memory: 5.056 MB. Show Profiling Timeline

总计12条数据
TimeDurationCategoryInfo
  
18:06:23.3962.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT 109 AS "object_type", "i"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "i"."invoice_num" AS "bill_no", COALESCE(CAST(i.verify_at AS date), i.from_date) AS "bill_date", NULL::timestamp without time zone AS "completed_at", "i"."amount" AS "amount", NULL::integer AS "client_id", "i"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "i"."handler" AS "handler_id", "i"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", "i"."is_verify" AS "is_verified" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "i" WHERE ("i"."is_cancel"=FALSE) AND (("i"."invoice_type" <> -1) OR ("i"."invoice_type" IS NULL)) AND (COALESCE(CAST(i.verify_at AS date), i.from_date) >= '2026-02-01') AND (COALESCE(CAST(i.verify_at AS date), i.from_date) <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE))
18:06:23.4071.9 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/voucher-center/bill-list', '{"page":"1","pageSize":"200","object_type":"109","generation_scope":"ungenerated","date_from":"2026-02-01","date_to":"2026-06-30","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"id":"109_2729_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2729,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000528557551","bill_date":"2026-02-28","completed_at":"","amount":32000,"partner_name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2726_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2726,"event_type":0,"event_id":0,"business_node":"","bill_no":"\u8d39\u7528-53351866","bill_date":"2026-02-28","completed_at":"","amount":2180,"partner_name":"","department":"\u8d22\u52a1\u90e8","handler_name":"\u738b\u7b11\u7b11","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2724_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2724,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000486029896\u62c62-1","bill_date":"2026-02-28","completed_at":"","amount":520,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2723_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2723,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000486029896\u62c62-2","bill_date":"2026-02-28","completed_at":"","amount":1400,"partner_name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2721_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2721,"event_type":0,"event_id":0,"business_node":"","bill_no":"26120000478555846\u62c62-1","bill_date":"2026-02-28","completed_at":"","amount":6000,"partner_name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2720_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2720,"event_type":0,"event_id":0,"business_node":"","bill_no":"26120000478555846\u62c62-2","bill_date":"2026-02-28","completed_at":"","amount":30400,"partner_name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2719_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2719,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000477410971","bill_date":"2026-02-28","completed_at":"","amount":27600,"partner_name":"\u5317\u4eac\u878d\u521b\u777f\u901a\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2718_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2718,"event_type":0,"event_id":0,"business_node":"","bill_no":"26122000000151159291","bill_date":"2026-02-28","completed_at":"","amount":3721922,"partner_name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2717_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2717,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000476623741","bill_date":"2026-02-28","completed_at":"","amount":300,"partner_name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2716_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2716,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000475873021","bill_date":"2026-02-28","completed_at":"","amount":198300,"partner_name":"\u4e2d\u6d77\u57ce(\u5317\u4eac)\u5efa\u8bbe\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2715_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2715,"event_type":0,"event_id":0,"business_node":"","bill_no":"26112000000466664431","bill_date":"2026-02-28","completed_at":"","amount":2200,"partner_name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u5f20\u7ea2\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2680_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2680,"event_type":0,"event_id":0,"business_node":"","bill_no":"26312000000661542256","bill_date":"2026-02-28","completed_at":"","amount":25138,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2679_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2679,"event_type":0,"event_id":0,"business_node":"","bill_no":"26312000000661537801","bill_date":"2026-02-28","completed_at":"","amount":23654,"partner_name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2677_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2677,"event_type":0,"event_id":0,"business_node":"","bill_no":"26117000000195902930","bill_date":"2026-02-28","completed_at":"","amount":12970,"partner_name":"\u4eac\u4e1c\u5546\u57ce","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2672_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2672,"event_type":0,"event_id":0,"business_node":"","bill_no":"26312000000577887616","bill_date":"2026-02-28","completed_at":"","amount":1046515,"partner_name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""},{"id":"109_2626_0_0","object_type":109,"object_type_name":"\u91c7\u8d2d\u53d1\u7968","object_type_color":"","object_type_tip":"","object_id":2626,"event_type":0,"event_id":0,"business_node":"","bill_no":"25442000000830583271","bill_date":"2026-02-28","completed_at":"","amount":103571,"partner_name":"\u5e7f\u5dde\u5e02\u4f73\u65fa\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8","department":"\u5546\u52a1\u90e8","handler_name":"\u97e9\u96c5\u82b3","fund_account_name":"","fund_account_caption_name":"","gen_status":"\u672a\u751f\u6210\u51ed\u8bc1","can_select":true,"have_invoice":true,"is_verified":true,"is_error":false,"error_code":"","error_display":"","gen_success_count":0,"gen_fail_count":0,"book_date":""}],"pagenation":{"totalcount":16,"thispage":1,"pagesize":200},"total_amount":5234670},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-29 18:06:23', 25417216) RETURNING "id"
18:06:23.4011.7 msyii\db\Command::querySELECT "b"."object_type" AS "object_type", "b"."object_id" AS "object_id", "b"."event_type" AS "event_type", "b"."event_id" AS "event_id", "b"."business_node" AS "business_node", "b"."bill_no" AS "bill_no", "b"."bill_date" AS "bill_date", "b"."completed_at" AS "completed_at", "b"."amount" AS "amount", "b"."client_id" AS "client_id", "b"."supplier_id" AS "supplier_id", "b"."contact_id" AS "contact_id", "b"."department_id" AS "department_id", "b"."handler_id" AS "handler_id", "b"."created_by" AS "created_by", "b"."erp_bank_id" AS "erp_bank_id", "b"."have_invoice" AS "have_invoice", "b"."is_verified" AS "is_verified", COALESCE(g.success_count, 0) AS "gen_success_count", COALESCE(g.fail_count, 0) AS "gen_fail_count", COALESCE(CAST(g.last_book_date AS text), '') AS "gen_book_date" FROM (SELECT 109 AS "object_type", "i"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "i"."invoice_num" AS "bill_no", COALESCE(CAST(i.verify_at AS date), i.from_date) AS "bill_date", NULL::timestamp without time zone AS "completed_at", "i"."amount" AS "amount", NULL::integer AS "client_id", "i"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "i"."handler" AS "handler_id", "i"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", "i"."is_verify" AS "is_verified" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "i" WHERE ("i"."is_cancel"=FALSE) AND (("i"."invoice_type" <> -1) OR ("i"."invoice_type" IS NULL)) AND (COALESCE(CAST(i.verify_at AS date), i.from_date) >= '2026-02-01') AND (COALESCE(CAST(i.verify_at AS date), i.from_date) <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE)) ORDER BY "bill_date" DESC, "object_type", "object_id" DESC, "event_type", "event_id" DESC LIMIT 200
18:06:23.3991.6 msyii\db\Command::querySELECT COALESCE(SUM(b.amount), 0) AS "total_amount" FROM (SELECT 109 AS "object_type", "i"."id" AS "object_id", 0 AS "event_type", 0 AS "event_id", ''::text AS "business_node", "i"."invoice_num" AS "bill_no", COALESCE(CAST(i.verify_at AS date), i.from_date) AS "bill_date", NULL::timestamp without time zone AS "completed_at", "i"."amount" AS "amount", NULL::integer AS "client_id", "i"."supplier_id" AS "supplier_id", NULL::integer AS "contact_id", NULL::integer AS "department_id", "i"."handler" AS "handler_id", "i"."created_by" AS "created_by", NULL::integer AS "erp_bank_id", true AS "have_invoice", "i"."is_verify" AS "is_verified" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "i" WHERE ("i"."is_cancel"=FALSE) AND (("i"."invoice_type" <> -1) OR ("i"."invoice_type" IS NULL)) AND (COALESCE(CAST(i.verify_at AS date), i.from_date) >= '2026-02-01') AND (COALESCE(CAST(i.verify_at AS date), i.from_date) <= '2026-06-30')) "b" LEFT JOIN (SELECT "v"."object_type" AS "object_type", "v"."object_id" AS "object_id", COALESCE(v.event_type, 0) AS "event_type", COALESCE(v.event_id, 0) AS "event_id", COUNT(*) FILTER (WHERE v.status = 1) AS "success_count", COUNT(*) FILTER (WHERE v.status = 0) AS "fail_count", MAX(v.book_date) FILTER (WHERE v.status = 1) AS "last_book_date" FROM "a57be577deb434"."tbl_voucher_gen_items" "v" WHERE "v"."ledger_id"=1 GROUP BY "v"."object_type", "v"."object_id", COALESCE(v.event_type, 0), COALESCE(v.event_id, 0)) "g" ON g.object_type = b.object_type AND g.object_id = b.object_id AND g.event_type = b.event_type AND g.event_id = b.event_id WHERE (("g"."success_count" IS NULL) OR ("g"."success_count"=0)) AND (("b"."object_type" NOT IN (20, 20018)) OR ("b"."have_invoice"=TRUE) OR (EXISTS (SELECT 1 FROM a57be577deb434.tbl_term_taxonomy_relationships r INNER JOIN a57be577deb434.tbl_term_taxonomies tt ON r.taxonomy_id = tt.id WHERE r.term_id = 18 AND r.object_id = b.object_id AND tt.serial_no IN ('221106','640301','640302','640303','600704') AND ((b.object_type = 20 AND r.object_type = 7) OR (b.object_type = 20018 AND r.object_type = 11))))) AND ("b"."amount" > 0) AND (("b"."object_type" <> 109) OR ("b"."is_verified"=TRUE))
18:06:23.3850.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:06:23.3900.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
18:06:23.3870.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:06:23.4050.6 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 6)
18:06:23.3890.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:06:23.4030.5 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (598, 489, 678, 107, 90, 81, 607, 59, 67, 262, 163, 642)
18:06:23.3840.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:06:23.4040.3 msyii\db\Command::querySELECT "id", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5252, 5360)