QUERY PLAN
Index Scan using tbl_auth_items_pkey on tbl_auth_items (cost=0.27..127.17 rows=294 width=250)
Index Cond: ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewReimbursementAnalysis,viewApproveAnalysis,viewSchedule,createSchedule,updateSchedule,viewSource,createSource,distributeSource,viewCalendarMng,createCalendarMng,updateCalendarMng,deleteCalendarMng,viewTask,createTask,updateTask,deleteTask,viewClient,createClient,updateClient,transferClient,createClientDocument,updateClientDocument,viewClientContact,createClientContact,updateClientContact,viewContactInfo,viewWorkLog,createWorkLog,updateWorkLog,viewProject,createProject,updateProject,createProjectDocument,updateProjectDocument,changeProjectStatus3,changeProjectStatus4,changeProjectStatus5,viewCase,createCase,viewTicket,createCaseDocument,updateCaseDocument,viewSalesOrder,viewSalesContract,serviceProgress,viewReimbursement,createReimbursement,updateReimbursement,deleteReimbursement,viewApprove,createApprove,updateApprove,viewDocument,createDocument,updateDocument,viewSupplier,visitSupplier,createSupplier,updateSupplier,viewSupplierContact,createSupplierContact,updateSupplierContact,viewPurchaseContract,viewProduct,viewPunch,createPunch,viewPunchApprove,createPunchApprove,updatePunchApprove,viewRating,viewErp,viewErpInventoryOverflow,createErpInventoryOverflow,viewStatisticsChart,deletePunchApprove,importClient,exportClient,deleteClient,viewPurchaseAnalysis,createPurchaseContract,viewErpProfitDistribute,createErpProfitDistribute,updateErpProfitDistribute,deleteErpProfitDistribute,viewErpAnalysisClientCost,viewErpAnalysisBank,viewErpAnalysisUnCollect,viewErpAnalysisUnPayment,viewErpAnalysisBoss,viewErpAnalysisSalesCost,viewErpAnalysisProfitAndLoss,deleteProject,exportProject,deleteSupplier,exportSupplier,updateSalesOrder,deleteSalesOrder,exportSalesOrder,updateProduct,deleteProduct,exportProduct,deleteClientContact,exportClientContact,deleteSupplierContact,exportSupplierContact,viewSalesLog,updateSalesLog,deleteSalesLog,exportSalesLog,exportPreSales,exportImplement,updateSalesContract,deleteSalesContract,exportSalesContract,updatePurchaseContract,deletePurchaseContract,exportPurchaseContract,viewCallback,updateCallback,deleteCallback,exportCallback,viewAccount,updateAccount,deleteAccount,exportAccount,createAccount,changeAccountPassword,approveAccount,manageSetting,Guest,viewTaxManagement,verifyInvoice,settleInvoice,viewEngineerLog,updateEngineerLog,deleteEngineerLog,makeProduct,viewErpPersonAnalysis,viewErpYearAnalysis,viewErpSalesGoal,viewErpProductAnalysis,viewErpSettle,saveErpSettle,deleteSchedule,viewOperation,createOperation,updateOperation,deleteOperation,viewOtherOperation,distributeCase,deleteDocument,deleteClientDocument,viewService,createService,updateService,deleteService,updateOthersProject,deleteProjectDocument,deleteCaseDocument,updateCase,deleteCase,closeCase,suspendCase,viewSalesRepScore,updateTicket,lockClient,deleteTicket,createSupplierDocument,updateSupplierDocument,deleteSupplierDocument,viewContactAnalysis,updateSource,deleteSource,viewErpPurchaseInbound,createErpPurchaseInbound,updateErpPurchaseInbound,deleteErpPurchaseInbound,viewErpAnalysisWage,viewErpAnalysisAccount,viewErpAnalysisUnit,viewErpSalesReturn,createErpSalesReturn,updateErpSalesReturn,deleteErpSalesReturn,viewErpPurchaseReturn,createErpPurchaseReturn,updateErpPurchaseReturn,deleteErpPurchaseReturn,viewErpSalesOrder,updateErpSalesOrder,viewErpSalesGift,createErpSalesGift,updateErpSalesGift,deleteErpSalesGift,viewErpCollectTicket,createErpCollectTicket,updateErpCollectTicket,deleteErpCollectTicket,viewErpOtherIncomeTicket,createErpOtherIncomeTicket,deleteApprove,viewTicketLog,viewErpAnalysisInOut,viewErpInventoryProduct,viewErpInventoryLost,createErpInventoryLost,updateErpInventoryLost,deleteErpInventoryLost,viewErpSalesOutbound,createErpSalesOutbound,updateErpSalesOutbound,deleteErpSalesOutbound,viewErpPurchaseGift,createErpPurchaseGift,updateErpPurchaseGift,deleteErpPurchaseGift,viewErpPaymentTicket,createErpPaymentTicket,updateErpPaymentTicket,deleteErpPaymentTicket,viewErpCostTicket,createErpCostTicket,updateErpCostTicket,deleteErpCostTicket,updateErpOtherIncomeTicket,viewErpPurchaseOrder,updateErpPurchaseOrder,viewErpInventoryBuild,createErpInventoryBuild,updateErpInventoryBuild,deleteErpInventoryBuild,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,createErpPurchaseCost,updateErpPurchaseCost,deleteErpPurchaseCost,viewErpSocialInsurance,createErpSocialInsurance,updateErpSocialInsurance,deleteErpSocialInsurance,viewErpProvidentFund,createErpProvidentFund,updateErpProvidentFund,deleteErpProvidentFund,viewErpPersonalTax,createErpPersonalTax,updateErpPersonalTax,deleteErpPersonalTax,viewErpWagePrize,createErpWagePrize,updateErpWagePrize,deleteErpWagePrize,viewErpWageTicket,createErpWageTicket,updateErpWageTicket,deleteErpWageTicket,viewErpAsset,createCostContract,updateCostContract,deleteCostContract,viewCostContract,viewProjectProduct,viewSaleContractProduct,viewSmartBoard,ViewSmartBoardSales,ViewSmartBoardAccount,ViewSmartBoardEngineer,viewErpInventoryDisassemble,createErpInventoryDisassemble,updateErpInventoryDisassemble,deleteErpInventoryDisassemble,updateErpInventoryOverflow,deleteErpInventoryOverflow,createSalesOrder,createSalesContract,createProduct,manageProductCategory,createRating,updateRating,manageRating}'::text[]))
Filter: (type = 2)