ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a56ffa47fa6f: POST https://beta.jinchangxiao.com/vue/product/list at 2026-07-15 11:33:56 am by 114.244.130.61

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
11:33:56.521traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
11:33:56.521traceyii\base\Module::getModuleLoading module: debug
11:33:56.522traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
11:33:56.523traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
11:33:56.523traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
11:33:56.523traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.523infotime tracing start1784086436523919104
11:33:56.524traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
11:33:56.524traceyii\web\Application::handleRequestRoute requested: 'vue/product/list'
11:33:56.524traceyii\base\Module::getModuleLoading module: vue
11:33:56.524infoyii\web\Session::openSession started
11:33:56.525infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:33:56.526infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:33:56.527traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.527traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:33:56.528infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:33:56.528traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.529traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:33:56.529infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:33:56.530traceyii\base\Controller::runActionRoute to run: vue/product/list
11:33:56.530traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.532traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
11:33:56.532traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProductController::actionList()
11:33:56.532traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.532traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:33:56.534infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id WHERE (lower(p.name) ILIKE '%mk-mc300%') OR ("p"."pinyin_shortcut" ILIKE '%mk-mc300%') OR (lower(pt.name) ILIKE '%mk-mc300%') OR (lower(pb.name) ILIKE '%mk-mc300%') OR (lower(ps.name) ILIKE '%mk-mc300%') OR (lower(pc.name) ILIKE '%mk-mc300%') OR (lower(p.description) ILIKE '%mk-mc300%') ORDER BY "updated_at" DESC) "c"
11:33:56.554infoyii\db\Command::querySELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id WHERE (lower(p.name) ILIKE '%mk-mc300%') OR ("p"."pinyin_shortcut" ILIKE '%mk-mc300%') OR (lower(pt.name) ILIKE '%mk-mc300%') OR (lower(pb.name) ILIKE '%mk-mc300%') OR (lower(ps.name) ILIKE '%mk-mc300%') OR (lower(pc.name) ILIKE '%mk-mc300%') OR (lower(p.description) ILIKE '%mk-mc300%') ORDER BY "updated_at" DESC LIMIT 20
11:33:56.574infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
11:33:56.574infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=52
11:33:56.575infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
11:33:56.575infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1769
11:33:56.576infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
11:33:56.576infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
11:33:56.577infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)
11:33:56.577infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7
11:33:56.577infoyii\db\Command::querySELECT eip.product_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN eip.erp_purchase_inbound_id IS NOT NULL THEN eip.number ELSE 0 END) as purchase_inbound, sum(CASE WHEN eip.erp_purchase_gift_id IS NOT NULL THEN eip.number ELSE 0 END) as gift_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN eip.erp_inventory_overflow_id IS NOT NULL THEN eip.number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN eip.erp_inventory_disassemble_id IS NOT NULL THEN eip.number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN eip.erp_inventory_build_id IS NOT NULL THEN eip.number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN eip.erp_inventory_transfer_id IS NOT NULL THEN eip.number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, 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 "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2261 GROUP BY "eip"."product_id"
11:33:56.579traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.580traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.581traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.581traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:33:56.582infoyii\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/product/list', '{"ProductSearch":{"keyword":"MK-MC300"},"page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-15 11:32:10","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-15 11:32:10.299622+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":{},"erpInventoryCount":{"product_id":2261,"outbound":"21","number":"69","purchase_inbound":"6","gift_inbound":"0","sales_outbound":"10","overflow_inbound":"3","lost_outbound":"1","disassemble_inbound":"1","disassemble_spent_outbound":"0","sales_gift_outbound":"6","build_inbound":"3","build_spent_outbound":"4","transfer_inbound":"0","transfer_spent_outbound":"0","inventory":"48","avg_amount":"5792.7080769230769231","avg_total_amount":"498.3846153846153846","amount":"6479.000"},"bgcolor":"#89c541","can_update":true,"can_delete":true}],"can_import":true,"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-15 11:33:56', 58136832) RETURNING "id"
11:33:56.584traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:33:56.585traceyii\redis\Connection::executeCommandExecuting Redis Command: SET