QUERY PLAN
Seq Scan on tbl_auth_items (cost=0.00..45.54 rows=142 width=247)
Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewOtherFootPrint,viewSalesRepScore,viewContactAnalysis,viewPurchaseAnalysis,viewReimbursementAnalysis,viewApproveAnalysis,viewSchedule,createSchedule,updateSchedule,deleteSchedule,viewSource,createSource,viewCalendarMng,createCalendarMng,updateCalendarMng,deleteCalendarMng,viewTask,createTask,updateTask,viewOtherTask,viewClient,viewOperation,viewOtherOperation,viewWorkLog,createWorkLog,updateWorkLog,viewProject,viewCase,viewTicket,viewSalesOrder,viewSalesContract,serviceProgress,viewReimbursement,createReimbursement,updateReimbursement,viewApprove,createApprove,updateApprove,viewDocument,viewSupplier,visitSupplier,viewPurchaseContract,viewProduct,viewService,viewPunch,createPunch,viewPunchApprove,createPunchApprove,updatePunchApprove,viewRating,viewStatisticsChart,deletePunchApprove,viewContactInfo,importClient,exportClient,updateClient,deleteClient,createPurchaseContract,updateProject,deleteProject,exportProject,updateSupplier,deleteSupplier,exportSupplier,updateSalesOrder,deleteSalesOrder,exportSalesOrder,updateProduct,deleteProduct,exportProduct,viewClientContact,updateClientContact,deleteClientContact,exportClientContact,viewSupplierContact,updateSupplierContact,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,createOperation,updateOperation,deleteOperation,distributeCase,updateDocument,deleteDocument,updateClientDocument,deleteClientDocument,createService,updateService,deleteService,updateOthersProject,createClientDocument,createProjectDocument,updateProjectDocument,deleteProjectDocument,createCaseDocument,updateCaseDocument,deleteCaseDocument,createCase,updateCase,deleteCase,closeCase,suspendCase,deleteReimbursement,updateTicket,lockClient,deleteTicket,createSupplierDocument,updateSupplierDocument,deleteSupplierDocument,changeProjectStatus3,changeProjectStatus4,changeProjectStatus5,updateSource,deleteSource,distributeSource,deleteApprove}'::text[])))

QUERY PLAN

Seq Scan on tbl_auth_items (cost=0.00..45.54 rows=142 width=247)

Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewOtherFootPrint,viewSalesRepScore,viewContactAnalysis,viewPurchaseAnalysis,viewReimbursementAnalysis,viewApproveAnalysis,viewSchedule,createSchedule,updateSchedule,deleteSchedule,viewSource,createSource,viewCalendarMng,createCalendarMng,updateCalendarMng,deleteCalendarMng,viewTask,createTask,updateTask,viewOtherTask,viewClient,viewOperation,viewOtherOperation,viewWorkLog,createWorkLog,updateWorkLog,viewProject,viewCase,viewTicket,viewSalesOrder,viewSalesContract,serviceProgress,viewReimbursement,createReimbursement,updateReimbursement,viewApprove,createApprove,updateApprove,viewDocument,viewSupplier,visitSupplier,viewPurchaseContract,viewProduct,viewService,viewPunch,createPunch,viewPunchApprove,createPunchApprove,updatePunchApprove,viewRating,viewStatisticsChart,deletePunchApprove,viewContactInfo,importClient,exportClient,updateClient,deleteClient,createPurchaseContract,updateProject,deleteProject,exportProject,updateSupplier,deleteSupplier,exportSupplier,updateSalesOrder,deleteSalesOrder,exportSalesOrder,updateProduct,deleteProduct,exportProduct,viewClientContact,updateClientContact,deleteClientContact,exportClientContact,viewSupplierContact,updateSupplierContact,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,createOperation,updateOperation,deleteOperation,distributeCase,updateDocument,deleteDocument,updateClientDocument,deleteClientDocument,createService,updateService,deleteService,updateOthersProject,createClientDocument,createProjectDocument,updateProjectDocument,deleteProjectDocument,createCaseDocument,updateCaseDocument,deleteCaseDocument,createCase,updateCase,deleteCase,closeCase,suspendCase,deleteReimbursement,updateTicket,lockClient,deleteTicket,createSupplierDocument,updateSupplierDocument,deleteSupplierDocument,changeProjectStatus3,changeProjectStatus4,changeProjectStatus5,updateSource,deleteSource,distributeSource,deleteApprove}'::text[])))