QUERY PLAN
Index Scan using tbl_auth_items_pkey on tbl_auth_items (cost=0.27..85.43 rows=159 width=250)
Index Cond: ((name)::text = ANY ('{Guest,viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewSchedule,createSchedule,updateSchedule,viewSource,createSource,updateSource,distributeSource,viewCalendarMng,createCalendarMng,updateCalendarMng,viewTask,createTask,updateTask,viewClient,createClient,updateClient,createClientDocument,updateClientDocument,createProjectDocument,updateProjectDocument,createCaseDocument,updateCaseDocument,viewOperation,createOperation,updateOperation,distributeContact,viewOtherOperation,viewClientContact,createClientContact,updateClientContact,viewContactInfo,viewWorkLog,createWorkLog,updateWorkLog,viewProject,viewCase,createCase,updateCase,closeCase,suspendCase,distributeCase,viewTicket,viewSalesOrder,createSalesOrder,updateSalesOrder,viewSalesContract,createSalesContract,updateSalesContract,viewReimbursement,createReimbursement,updateReimbursement,viewApprove,createApprove,updateApprove,viewDocument,createDocument,updateDocument,viewSupplier,createSupplier,updateSupplier,viewSupplierContact,createSupplierContact,updateSupplierContact,viewPurchaseContract,createPurchaseContract,updatePurchaseContract,viewProduct,createProduct,updateProduct,manageProductCategory,viewService,createService,updateService,viewPunch,createPunch,viewRating,createRating,updateRating,manageRating,createSupplierDocument,updateSupplierDocument,viewPunchApprove,createPunchApprove,updatePunchApprove,visitSupplier,serviceProgress,viewReimbursementAnalysis,viewApproveAnalysis,viewErpPurchaseOrder,viewErpPurchaseInbound,viewErpPurchaseReturn,viewErpInventoryLost,viewErpInventoryBuild,viewErpSalesOrder,viewErpSalesOutbound,viewErpSalesReturn,viewErpPurchaseGift,viewErpSalesGift,viewErpPaymentTicket,createErpPaymentTicket,updateErpPaymentTicket,deleteErpPaymentTicket,viewErpCollectTicket,createErpCollectTicket,updateErpCollectTicket,deleteErpCollectTicket,viewErpCostTicket,createErpCostTicket,updateErpCostTicket,deleteErpCostTicket,viewErpOtherIncomeTicket,createErpOtherIncomeTicket,updateErpOtherIncomeTicket,deleteErpOtherIncomeTicket,viewErpCostConvertTicket,createErpCostConvertTicket,updateErpCostConvertTicket,deleteErpCostConvertTicket,viewErpBankTransferTicket,createErpBankTransferTicket,updateErpBankTransferTicket,deleteErpBankTransferTicket,viewErpCashCostTicket,createErpCashCostTicket,updateErpCashCostTicket,deleteErpCashCostTicket,viewErpAdvancePaymentTicket,createErpAdvancePaymentTicket,updateErpAdvancePaymentTicket,deleteErpAdvancePaymentTicket,viewErpOtherPaymentTicket,createErpOtherPaymentTicket,updateErpOtherPaymentTicket,deleteErpOtherPaymentTicket,viewErpOtherCollectTicket,createErpOtherCollectTicket,updateErpOtherCollectTicket,deleteErpOtherCollectTicket,viewErpPurchaseCost,viewErpSocialInsurance,createErpSocialInsurance,updateErpSocialInsurance,deleteErpSocialInsurance,viewErpProvidentFund,createErpProvidentFund,updateErpProvidentFund,deleteErpProvidentFund,viewErpPersonalTax,createErpPersonalTax,updateErpPersonalTax,deleteErpPersonalTax,viewErpWagePrize,createErpWagePrize,updateErpWagePrize,deleteErpWagePrize,viewErpWageTicket,createErpWageTicket,updateErpWageTicket,deleteErpWageTicket,viewErpAsset}'::text[]))
Filter: (type = 2)