6a1d32fd35935: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/list-export at 2026-06-01 03:21:33 pm by 43.224.72.82
Database Queries
总计54条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:21:33.221 | 0.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 15:21:33.222 | 0.4 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 15:21:33.225 | 0.6 ms | SELECT | SELECT "s"."accessible_user" FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_visibles" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5495) AND (s.accessible_user IS NOT NULL) GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 15:21:33.226 | 1.4 ms | SELECT | SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5495 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5495 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" "rvr" ON rvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" "rsvr" ON rsvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" "epop" ON epop.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=5495) OR ("r"."created_by"=5495) OR ("rvr"."user_id"=5495) OR ("r"."created_by" IN (5493, 5495, 5495))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5495))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC |
| 15:21:33.228 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:21:33.228 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:21:33.229 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:21:33.229 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:21:33.229 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:21:33.229 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:21:33.230 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1 |
| 15:21:33.230 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1 |
| 15:21:33.230 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" AS "name", "from_project", "erp_settle_amount", "erp_un_settle_amount" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project"=1 |
| 15:21:33.231 | 0.1 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_carbon_copy_rels" WHERE "erp_sales_outbound_id"=1 |
| 15:21:33.231 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:21:33.231 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:33.232 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:33.232 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:21:33.232 | 0.1 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id"=1) |
| 15:21:33.232 | 0.1 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=1) |
| 15:21:33.233 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:21:33.233 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=1 |
| 15:21:33.233 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:21:33.233 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:33.234 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:33.234 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:33.235 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:33.235 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:33.235 | 0.3 ms | SELECT | SELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1 GROUP BY "eip"."product_id" |
| 15:21:33.235 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=1 |
| 15:21:33.236 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:33.236 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:33.237 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:33.237 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:33.237 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:33.237 | 0.1 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:21:33.238 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:21:33.238 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" WHERE "id"=4 |
| 15:21:33.239 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" WHERE "id"=4 |
| 15:21:33.239 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_order_products" WHERE "id"=1 |
| 15:21:33.239 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=1 |
| 15:21:33.240 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" WHERE "id"=1 |
| 15:21:33.240 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:21:33.240 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:33.240 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:21:33.241 | 0.3 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:21:33.241 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=1 |
| 15:21:33.241 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:21:33.242 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:21:33.242 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:21:33.242 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:21:33.242 | 0.1 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:21:33.243 | 0.2 ms | SELECT | SELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=20008) AND ("object_id"=1) GROUP BY "object_id" |
| 15:21:33.243 | 0.2 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "o6a13e2c574d5a"."tbl_unread_comments" WHERE ("object_type"=20008) AND (remind_user_id = 5495 AND is_read = false) AND ("object_id"=1) GROUP BY "object_id" |