| 15:49:38.268 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:49:38.268 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:49:38.269 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:49:38.276 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:49:38.276 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:49:38.277 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.277 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:49:38.277 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:49:38.277 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:49:38.277 | trace | yii\web\Application::handleRequest | Route requested: 'vue/supplier/list' |
| 15:49:38.277 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:49:38.278 | info | yii\web\Session::open | Session started |
| 15:49:38.279 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:49:38.279 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:49:38.301 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:49:38.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:49:38.304 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:49:38.307 | trace | yii\base\Controller::runAction | Route to run: vue/supplier/list |
| 15:49:38.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.309 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:49:38.309 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SupplierController::actionList() |
| 15:49:38.309 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.309 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:49:38.310 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: visitSupplier |
| 15:49:38.310 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 15:49:38.310 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
| 15:49:38.310 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 15:49:38.310 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 15:49:38.311 | info | yii\db\Command::query | SELECT 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.338 | info | yii\db\Command::query | 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 LIMIT 20 |
| 15:49:38.348 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 15:49:38.348 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011) |
| 15:49:38.350 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 15:49:38.350 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=608 |
| 15:49:38.352 | info | yii\db\Command::query | SELECT "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.353 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=12) AND ("object_id"=608) GROUP BY "object_id" |
| 15:49:38.384 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=4 |
| 15:49:38.385 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "address1" AS "name", "zip" FROM "a57be577deb434"."tbl_addresses" WHERE "id"=3498 |
| 15:49:38.386 | info | yii\db\Command::query | SELECT "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.409 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.410 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.412 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.412 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:49:38.412 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=12) AND ("visit_date"='2025-12-22') |
| 15:49:38.419 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.419 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:49:38.419 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=59623 |
| 15:49:38.421 | info | yii\db\Command::query | INSERT 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.423 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:49:38.423 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |