QUERY PLAN
Seq Scan on tbl_auth_items (cost=0.00..70.14 rows=117 width=250)
Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewOtherFootPrint,viewSalesRepScore,viewContactAnalysis,viewPurchaseAnalysis,viewReimbursementAnalysis,viewApproveAnalysis,viewSchedule,createSchedule,updateSchedule,viewSource,createSource,updateSource,viewCalendarMng,createCalendarMng,updateCalendarMng,deleteCalendarMng,viewTask,createTask,updateTask,deleteTask,viewOtherTask,viewClient,createClient,updateClient,createClientDocument,updateClientDocument,viewClientContact,createClientContact,updateClientContact,viewContactInfo,viewWorkLog,createWorkLog,updateWorkLog,viewProject,createProject,createProjectDocument,updateProjectDocument,viewCase,createCase,updateCase,deleteCase,closeCase,suspendCase,viewTicket,createTicket,updateTicket,deleteTicket,createCaseDocument,updateCaseDocument,viewSalesOrder,createSalesOrder,updateSalesOrder,viewSalesContract,createSalesContract,updateSalesContract,serviceProgress,viewReimbursement,createReimbursement,updateReimbursement,viewApprove,createApprove,updateApprove,viewDocument,createDocument,updateDocument,viewSupplier,visitSupplier,createSupplier,updateSupplier,createSupplierDocument,updateSupplierDocument,viewSupplierContact,createSupplierContact,updateSupplierContact,viewPurchaseContract,createPurchaseContract,updatePurchaseContract,viewProduct,viewService,viewPunch,createPunch,viewOtherPunch,viewPunchApprove,createPunchApprove,updatePunchApprove,viewRating,viewTaxManagement,viewErpPurchaseOrder,updateErpPurchaseOrder,viewErpPurchaseInbound,createErpPurchaseInbound,updateErpPurchaseInbound,viewErpPurchaseReturn,createErpPurchaseReturn,updateErpPurchaseReturn,viewErpInventoryLost,viewErpInventoryBuild,updateErpSalesOrder,viewErpSalesOutbound,createErpSalesOutbound,updateErpSalesOutbound,viewErpSalesReturn,createErpSalesReturn,updateErpSalesReturn,viewErpPurchaseGift,createErpPurchaseGift,updateErpPurchaseGift,viewErpSalesGift,createErpSalesGift,updateErpSalesGift,viewErpPurchaseCost,createErpPurchaseCost,updateErpPurchaseCost,createCostContract,updateCostContract,deleteCostContract,viewCostContract}'::text[])))

QUERY PLAN

Seq Scan on tbl_auth_items (cost=0.00..70.14 rows=117 width=250)

Filter: ((type = 2) AND ((name)::text = ANY ('{viewSalesChart,viewPreSalesChart,viewImplementChart,viewServicePlan,viewCalendar,viewClientAnalysis,viewClientMap,viewFootPrint,viewOtherFootPrint,viewSalesRepScore,viewContactAnalysis,viewPurchaseAnalysis,viewReimbursementAnalysis,viewApproveAnalysis,viewSchedule,createSchedule,updateSchedule,viewSource,createSource,updateSource,viewCalendarMng,createCalendarMng,updateCalendarMng,deleteCalendarMng,viewTask,createTask,updateTask,deleteTask,viewOtherTask,viewClient,createClient,updateClient,createClientDocument,updateClientDocument,viewClientContact,createClientContact,updateClientContact,viewContactInfo,viewWorkLog,createWorkLog,updateWorkLog,viewProject,createProject,createProjectDocument,updateProjectDocument,viewCase,createCase,updateCase,deleteCase,closeCase,suspendCase,viewTicket,createTicket,updateTicket,deleteTicket,createCaseDocument,updateCaseDocument,viewSalesOrder,createSalesOrder,updateSalesOrder,viewSalesContract,createSalesContract,updateSalesContract,serviceProgress,viewReimbursement,createReimbursement,updateReimbursement,viewApprove,createApprove,updateApprove,viewDocument,createDocument,updateDocument,viewSupplier,visitSupplier,createSupplier,updateSupplier,createSupplierDocument,updateSupplierDocument,viewSupplierContact,createSupplierContact,updateSupplierContact,viewPurchaseContract,createPurchaseContract,updatePurchaseContract,viewProduct,viewService,viewPunch,createPunch,viewOtherPunch,viewPunchApprove,createPunchApprove,updatePunchApprove,viewRating,viewTaxManagement,viewErpPurchaseOrder,updateErpPurchaseOrder,viewErpPurchaseInbound,createErpPurchaseInbound,updateErpPurchaseInbound,viewErpPurchaseReturn,createErpPurchaseReturn,updateErpPurchaseReturn,viewErpInventoryLost,viewErpInventoryBuild,updateErpSalesOrder,viewErpSalesOutbound,createErpSalesOutbound,updateErpSalesOutbound,viewErpSalesReturn,createErpSalesReturn,updateErpSalesReturn,viewErpPurchaseGift,createErpPurchaseGift,updateErpPurchaseGift,viewErpSalesGift,createErpSalesGift,updateErpSalesGift,viewErpPurchaseCost,createErpPurchaseCost,updateErpPurchaseCost,createCostContract,updateCostContract,deleteCostContract,viewCostContract}'::text[])))