6a1d3480682e3: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/list-export at 2026-06-01 03:28:00 pm by 43.224.72.82
Performance Profiling
Total processing time: 93 ms; Peak memory: 4.812 MB. Show Profiling Timeline
总计55条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 15:28:00.437 | 2.9 ms | yii\db\Command::query | 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:28:00.442 | 1.5 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:28:00.433 | 1.4 ms | yii\db\Command::query | 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:28:00.447 | 1.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1 |
| 15:28:00.456 | 0.9 ms | yii\db\Command::query | 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:28:00.445 | 0.8 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493) |
| 15:28:00.462 | 0.6 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" WHERE "id"=4 |
| 15:28:00.460 | 0.6 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:28:00.428 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 15:28:00.463 | 0.5 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_order_products" WHERE "id"=1 |
| 15:28:00.444 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:28:00.454 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:28:00.457 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=1 |
| 15:28:00.452 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:28:00.455 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:28:00.454 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:28:00.430 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 15:28:00.451 | 0.4 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id"=1) |
| 15:28:00.455 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:28:00.461 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" WHERE "id"=4 |
| 15:28:00.464 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" WHERE "id"=1 |
| 15:28:00.460 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=1 |
| 15:28:00.469 | 0.3 ms | yii\db\Command::query | 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" |
| 15:28:00.448 | 0.3 ms | yii\db\Command::query | 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:28:00.441 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:28:00.449 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_carbon_copy_rels" WHERE "erp_sales_outbound_id"=1 |
| 15:28:00.468 | 0.3 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=20008) AND ("object_id"=1) GROUP BY "object_id" |
| 15:28:00.458 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:28:00.445 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:28:00.463 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=1 |
| 15:28:00.446 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1 |
| 15:28:00.453 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:28:00.452 | 0.3 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=1 |
| 15:28:00.466 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=1 |
| 15:28:00.466 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1 |
| 15:28:00.450 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:28:00.465 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:28:00.450 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:28:00.464 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:28:00.467 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:28:00.465 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id" |
| 15:28:00.458 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1 |
| 15:28:00.465 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:28:00.449 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id" |
| 15:28:00.450 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1) |
| 15:28:00.453 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1 |
| 15:28:00.428 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:28:00.446 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1 |
| 15:28:00.459 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:28:00.468 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |
| 15:28:00.467 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1 |
| 15:28:00.468 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:28:00.451 | 0.2 ms | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=1) |
| 15:28:00.459 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1 |
| 15:28:00.459 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1 |