All Latest
6948f812435a6: POST https://beta.jinchangxiao.com/vue/supplier/list at 2025-12-22 03:49:38 pm by 223.72.15.22

Log Messages

总计52条数据
TimeLevelCategoryMessage
 
15:49:38.268traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:49:38.268traceyii\base\Module::getModuleLoading module: debug
15:49:38.269traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:49:38.276traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:49:38.276traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:49:38.277traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.277traceyii\base\Module::getModuleLoading module: gii
15:49:38.277traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:49:38.277traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:49:38.277traceyii\web\Application::handleRequestRoute requested: 'vue/supplier/list'
15:49:38.277traceyii\base\Module::getModuleLoading module: vue
15:49:38.278infoyii\web\Session::openSession started
15:49:38.279infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:49:38.279infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:49:38.301traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.304traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:38.304traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.304traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:38.304infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:49:38.307traceyii\base\Controller::runActionRoute to run: vue/supplier/list
15:49:38.307traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.309traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:49:38.309traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SupplierController::actionList()
15:49:38.309traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.309traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:38.310traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: visitSupplier
15:49:38.310traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:49:38.310traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:49:38.310traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:49:38.310traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:49:38.311infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.supplier_id = s.id and c.supplier_id is not null WHERE (lower(s.name) LIKE '%淘宝网%') OR ("s"."pinyin_shortcut" LIKE '%淘宝网%') OR (lower(s.description) LIKE '%淘宝网%') OR (lower(s.main_products) LIKE '%淘宝网%') OR (lower(c.name) LIKE '%淘宝网%') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC) "c"
15:49:38.338infoyii\db\Command::querySELECT DISTINCT s.* FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.supplier_id = s.id and c.supplier_id is not null WHERE (lower(s.name) LIKE '%淘宝网%') OR ("s"."pinyin_shortcut" LIKE '%淘宝网%') OR (lower(s.description) LIKE '%淘宝网%') OR (lower(s.main_products) LIKE '%淘宝网%') OR (lower(c.name) LIKE '%淘宝网%') GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC LIMIT 20
15:49:38.348infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:49:38.348infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
15:49:38.350infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
15:49:38.350infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=608
15:49:38.352infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=6) AND ("id" IN (93, 5, 1, 2, 9, 102, 107, 114, 135, 140, 142, 153, 183, 194, 316, 354, 377))
15:49:38.353infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=12) AND ("object_id"=608) GROUP BY "object_id"
15:49:38.384infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=4
15:49:38.385infoyii\db\Command::querySELECT "id", "id" AS "key", "address1" AS "name", "zip" FROM "a57be577deb434"."tbl_addresses" WHERE "id"=3498
15:49:38.386infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=12) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=608) GROUP BY "object_id"
15:49:38.409traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.410traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.412traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.412traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:38.412infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=12) AND ("visit_date"='2025-12-22')
15:49:38.419traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.419traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:49:38.419infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=59623
15:49:38.421infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/supplier/list', '{"SupplierSearch":{"supplier_tag":"","keyword":"\u6dd8\u5b9d\u7f51"},"Filter":{"name":"updated_at","sort":"DESC"},"page":"1"}', '{"code":2000,"result":{"list":[{"id":608,"name":"\u6dd8\u5b9d\u7f51","abbr":"","pinyin_shortcut":"tbw","main_products":"\u914d\u4ef6","company_nature":4,"website":"","established_at":"","capital":"","corp_rep":"","reg_address":"","telephone":"","fax":"","description":"","main_contact":"","created_by":1011,"created_at":"2024-05-07 10:20:50","updated_at":"2024-05-07 10:20:50","working_address":3498,"capital_currency":"rmb","payment_cycle":"","account_number":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"supplierTags":{"id":107,"key":107,"name":"\u4ee3\u7406\u5546"},"commentCount":{},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":3498,"key":3498,"name":"","zip":""},"unreadComments":{},"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"can_create":true,"can_import":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-22 15:49:38') RETURNING "id"
15:49:38.423traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:49:38.423traceyii\redis\Connection::executeCommandExecuting Redis Command: SET