Database Queries

总计7条数据

Time	Duration	Type	Query

17:57:39.079	2.3 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 /var/www/beta/models/Login.php:65 /var/www/beta/vendor/uranus/web/User.php:201 /var/www/beta/modules/vue/controllers/CommonController.php:106 [+] Explain
17:57:39.082	1.5 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 /var/www/beta/modules/vue/controllers/CommonController.php:122 /var/www/beta/modules/vue/controllers/ErpWageAnalysisController.php:69 [+] Explain
17:57:39.086	11.8 ms	SELECT	SELECT COUNT() FROM (SELECT FROM ((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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) 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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) 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, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) 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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_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) AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) 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, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, (COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0)) * sum(am.pct) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_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 LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" ON am.erp_wage_ticket_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" ON am.erp_social_insurance_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" ON am.erp_provident_fund_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" ON am.erp_personal_tax_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" ON am.erp_wage_prize_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) )) "sub" ORDER BY created_at DESC) "c" /var/www/beta/modules/vue/controllers/ErpWageAnalysisController.php:4537 [+] Explain
17:57:39.099	8.3 ms	SELECT	SELECT * FROM ((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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) 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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) 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, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) 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.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_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, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_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) AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) 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, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, (COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0)) * sum(am.pct) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_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 LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" ON am.erp_wage_ticket_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" ON am.erp_social_insurance_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" ON am.erp_provident_fund_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" ON am.erp_personal_tax_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) 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, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" ON am.erp_wage_prize_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) )) "sub" ORDER BY created_at DESC LIMIT 20 OFFSET 80 /var/www/beta/modules/vue/controllers/ErpWageAnalysisController.php:4539 [+] Explain
17:57:39.108	4.0 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5064) AND ("object_type"=20000) AND ("visit_date"='2025-09-24') /var/www/beta/modules/vue/controllers/CommonController.php:772 /var/www/beta/modules/vue/controllers/CommonController.php:608 /var/www/beta/modules/vue/controllers/CommonController.php:363 [+] Explain
17:57:39.112	0.8 ms	UPDATE	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=304, "last_visit_at"='now()' WHERE "id"=57055 /var/www/beta/modules/vue/controllers/CommonController.php:784 /var/www/beta/modules/vue/controllers/CommonController.php:608 /var/www/beta/modules/vue/controllers/CommonController.php:363 [+] Explain
17:57:39.113	1.1 ms	INSERT	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-wage-analysis/in-out-view-out-list', '{"created_at_period":"","created_at_to":"","created_at_from":"","user_id":["1001"],"page":"5","web_access_token":"_AoGeYJ0QgSiLktGksNR6aswyct1iLo2"}', '{"code":2000,"result":{"list":[],"pagenation":{"totalcount":67,"thispage":5,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-24 17:57:39') RETURNING "id" /var/www/beta/modules/vue/controllers/CommonController.php:665 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ErpWageAnalysisController.php:4552 [+] Explain

[+] Explain all