ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a20f086e2a14: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-profit-a-loss-view at 2026-06-04 11:27:02 am by 221.216.117.119

Performance Profiling

Total processing time: 38 ms; Peak memory: 4.847 MB. Show Profiling Timeline

总计14条数据
TimeDurationCategoryInfo
  
11:27:02.94011.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20002::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20002 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20001::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20001 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_orders" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20003::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20003 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_returns" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20004::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20004 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_losts" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20031::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20031 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_overflows" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20005::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20005 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_builds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20030::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20030 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20007::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20007 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_orders" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, COALESCE(sum(eipss.actual_total_amount), 0) as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20009::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20009 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_returns" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20010::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20010 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_gifts" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, COALESCE(sum(eipss.actual_total_amount), 0) as amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20013::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20013 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20015::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20015 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 20 AND dt2.object_type = 14 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t" ON dt.taxonomy_id = t.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.bank_settle_at as created_at, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE ("r"."is_payment_settle"=TRUE) AND ("r"."status"=2) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20020 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20022::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20022 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_costs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub" WHERE ("ticket_type"=20004) AND ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') ORDER BY created_at DESC) "c"
11:27:02.9528.8 msyii\db\Command::querySELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20002::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20002 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20001::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20001 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_orders" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20003::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20003 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_returns" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20004::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20004 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_losts" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20031::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20031 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_overflows" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20005::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20005 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_builds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20030::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20030 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20007::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20007 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_orders" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, COALESCE(sum(eipss.actual_total_amount), 0) as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20009::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20009 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_returns" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20010::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20010 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_gifts" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, COALESCE(sum(eipss.actual_total_amount), 0) as amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20013::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20013 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20015::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20015 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 20 AND dt2.object_type = 14 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t" ON dt.taxonomy_id = t.id WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.bank_settle_at as created_at, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "t2" ON dt2.taxonomy_id = t2.id WHERE ("r"."is_payment_settle"=TRUE) AND ("r"."status"=2) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20020 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20022::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20022 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_purchase_costs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, null::numeric as cost_amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub" WHERE ("ticket_type"=20004) AND ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') ORDER BY created_at DESC LIMIT 40
11:27:02.9631.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-profit-a-loss-view', '{"child_type_id":"","type_id":"","type":"inventory_lost","is_all":"0","year":"2026","month":"6","hide":"0","page":"1","pageSize":"40","listReload":"true","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":8,"id2":8,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","wrote_date":"2026-06-04","serial_no":"BSD-20260604-00001","ticket_type":20004,"abstract":"","description":"","created_by":1001,"amount":"232323","cost_amount":"","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-06-04 11:24:43","verify_at":"2026-06-04 11:24:47","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","ticket_type_display":"\u62a5\u635f\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":""}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 11:27:02', 34981888) RETURNING "id"
11:27:02.9300.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:27:02.9310.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:02.9620.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
11:27:02.9620.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
11:27:02.9610.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:02.9330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)
11:27:02.9300.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:27:02.9340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
11:27:02.9340.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
11:27:02.9340.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-07-01') AND ("is_settle"=TRUE)
11:27:02.9340.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)