QUERY PLAN
Seq Scan on tbl_auth_items (cost=0.00..110.22 rows=249 width=250)
Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewSchedule,createSchedule,updateSchedule,viewSource,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,viewCase,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,changeProjectStatus3,changeProjectStatus4,changeProjectStatus5,viewReimbursementAnalysis,viewApproveAnalysis,viewStatisticsChart,deletePunchApprove,importClient,exportClient,deleteClient,viewPurchaseAnalysis,createPurchaseContract,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,deleteSchedule,viewOperation,createOperation,updateOperation,deleteOperation,viewOtherOperation,distributeCase,deleteDocument,deleteClientDocument,viewService,createService,updateService,deleteService,updateOthersProject,deleteProjectDocument,deleteCaseDocument,createCase,updateCase,deleteCase,closeCase,suspendCase,viewSalesRepScore,updateTicket,lockClient,deleteTicket,createSupplierDocument,updateSupplierDocument,deleteSupplierDocument,viewContactAnalysis,createSource,updateSource,deleteSource,distributeSource,deleteApprove,viewErp,viewErpPurchaseOrder,updateErpPurchaseOrder,viewErpPurchaseInbound,createErpPurchaseInbound,updateErpPurchaseInbound,deleteErpPurchaseInbound,viewErpPurchaseReturn,createErpPurchaseReturn,updateErpPurchaseReturn,deleteErpPurchaseReturn,viewErpInventoryProduct,viewErpInventoryLost,createErpInventoryLost,updateErpInventoryLost,deleteErpInventoryLost,viewErpInventoryBuild,createErpInventoryBuild,updateErpInventoryBuild,deleteErpInventoryBuild,viewErpSalesOrder,updateErpSalesOrder,viewErpSalesOutbound,createErpSalesOutbound,updateErpSalesOutbound,deleteErpSalesOutbound,viewErpSalesReturn,createErpSalesReturn,updateErpSalesReturn,deleteErpSalesReturn,viewErpPurchaseGift,createErpPurchaseGift,updateErpPurchaseGift,deleteErpPurchaseGift,viewErpSalesGift,createErpSalesGift,updateErpSalesGift,deleteErpSalesGift,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,createErpPurchaseCost,updateErpPurchaseCost,deleteErpPurchaseCost,viewErpSocialInsurance,createErpSocialInsurance,updateErpSocialInsurance,deleteErpSocialInsurance,viewErpProvidentFund,createErpProvidentFund,updateErpProvidentFund,deleteErpProvidentFund,viewErpPersonalTax,createErpPersonalTax,updateErpPersonalTax,deleteErpPersonalTax,viewErpWagePrize,createErpWagePrize,updateErpWagePrize,deleteErpWagePrize,viewErpWageTicket,createErpWageTicket,updateErpWageTicket,deleteErpWageTicket,viewErpAsset}'::text[])))

QUERY PLAN

Seq Scan on tbl_auth_items (cost=0.00..110.22 rows=249 width=250)

Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewSchedule,createSchedule,updateSchedule,viewSource,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,viewCase,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,changeProjectStatus3,changeProjectStatus4,changeProjectStatus5,viewReimbursementAnalysis,viewApproveAnalysis,viewStatisticsChart,deletePunchApprove,importClient,exportClient,deleteClient,viewPurchaseAnalysis,createPurchaseContract,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,deleteSchedule,viewOperation,createOperation,updateOperation,deleteOperation,viewOtherOperation,distributeCase,deleteDocument,deleteClientDocument,viewService,createService,updateService,deleteService,updateOthersProject,deleteProjectDocument,deleteCaseDocument,createCase,updateCase,deleteCase,closeCase,suspendCase,viewSalesRepScore,updateTicket,lockClient,deleteTicket,createSupplierDocument,updateSupplierDocument,deleteSupplierDocument,viewContactAnalysis,createSource,updateSource,deleteSource,distributeSource,deleteApprove,viewErp,viewErpPurchaseOrder,updateErpPurchaseOrder,viewErpPurchaseInbound,createErpPurchaseInbound,updateErpPurchaseInbound,deleteErpPurchaseInbound,viewErpPurchaseReturn,createErpPurchaseReturn,updateErpPurchaseReturn,deleteErpPurchaseReturn,viewErpInventoryProduct,viewErpInventoryLost,createErpInventoryLost,updateErpInventoryLost,deleteErpInventoryLost,viewErpInventoryBuild,createErpInventoryBuild,updateErpInventoryBuild,deleteErpInventoryBuild,viewErpSalesOrder,updateErpSalesOrder,viewErpSalesOutbound,createErpSalesOutbound,updateErpSalesOutbound,deleteErpSalesOutbound,viewErpSalesReturn,createErpSalesReturn,updateErpSalesReturn,deleteErpSalesReturn,viewErpPurchaseGift,createErpPurchaseGift,updateErpPurchaseGift,deleteErpPurchaseGift,viewErpSalesGift,createErpSalesGift,updateErpSalesGift,deleteErpSalesGift,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,createErpPurchaseCost,updateErpPurchaseCost,deleteErpPurchaseCost,viewErpSocialInsurance,createErpSocialInsurance,updateErpSocialInsurance,deleteErpSocialInsurance,viewErpProvidentFund,createErpProvidentFund,updateErpProvidentFund,deleteErpProvidentFund,viewErpPersonalTax,createErpPersonalTax,updateErpPersonalTax,deleteErpPersonalTax,viewErpWagePrize,createErpWagePrize,updateErpWagePrize,deleteErpWagePrize,viewErpWageTicket,createErpWageTicket,updateErpWageTicket,deleteErpWageTicket,viewErpAsset}'::text[])))