ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a577ca2bacdb: POST https://beta.jinchangxiao.com/v2/supplier/list at 2026-07-15 08:27:14 pm by 111.9.5.127

Log Messages

总计47条数据
TimeLevelCategoryMessage
 
20:27:14.764traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
20:27:14.764traceyii\base\Module::getModuleLoading module: debug
20:27:14.765traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
20:27:14.765traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
20:27:14.765traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
20:27:14.765traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.766infotime tracing start1784118434766123008
20:27:14.766traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
20:27:14.766traceyii\web\Application::handleRequestRoute requested: 'v2/supplier/list'
20:27:14.766traceyii\base\Module::getModuleLoading module: v2
20:27:14.767infoyii\web\Session::openSession started
20:27:14.769infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:27:14.772infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
20:27:14.776traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.776traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:27:14.776traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.777traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:27:14.777infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:27:14.779traceyii\base\Controller::runActionRoute to run: v2/supplier/list
20:27:14.780traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.782traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
20:27:14.782traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\SupplierController::actionList()
20:27:14.782traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.782traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:27:14.782traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: visitSupplier
20:27:14.782traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
20:27:14.782traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
20:27:14.782traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
20:27:14.783traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
20:27:14.783traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
20:27:14.783infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" 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"
20:27:14.791infoyii\db\Command::querySELECT DISTINCT s.* FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" 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 10
20:27:14.799infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
20:27:14.800infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
20:27:14.800infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
20:27:14.801infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (469, 431, 94, 171, 234)
20:27:14.804infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=6) AND ("id" IN (100, 46, 107, 96, 101, 115, 185, 193, 128, 167, 142, 183, 187, 184, 200, 196, 204, 94, 6, 8, 11, 207, 208, 5, 226, 215, 2, 139, 319, 7, 153, 114, 315, 317, 340, 313, 365, 372, 374, 369, 377, 359, 349, 136))
20:27:14.805infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=12) AND ("object_id" IN (469, 431, 94, 171, 234)) GROUP BY "object_id"
20:27:14.825infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=4
20:27:14.825infoyii\db\Command::querySELECT "id", "id" AS "key", "address1" AS "name", "zip" FROM "a57be577deb434"."tbl_addresses" WHERE "id" IN (2745, 2630, 280, 577, 1335)
20:27:14.827infoyii\db\Command::querySELECT "id", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE (("is_draft"=FALSE) AND ("is_chargeback"=FALSE) AND ("is_refuse"=FALSE)) AND ("supplier_id" IN (469, 431, 94, 171, 234))
20:27:14.829infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=12) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (469, 431, 94, 171, 234)) GROUP BY "object_id"
20:27:14.847traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.848traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.850traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:27:14.850traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:27:14.851infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/supplier/list', '{"Filter":{"name":"","sort":""},"SupplierSearch":{"keyword":"\u5317\u4eac\u60e0","supplier_tag":""},"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","posttime":"1784118400","token":"dffbbef2f8a9b78a35bd823e10f58b2c","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":469,"name":"\u5317\u4eac\u60e0\u6cfd\u65b9\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhzfckjyxgs","main_products":"\u7fa4\u6656\u4ee3\u7406\u5546\/\u897f\u6570\/\u95ea\u8fea\u5927\u5e08","company_nature":4,"website":"","established_at":"2009-07-23","capital":100,"corp_rep":"\u9a6c\u7acb\u519b","reg_address":null,"telephone":"","fax":"","description":"","main_contact":null,"created_by":1011,"created_at":"2022-06-28 16:15:13","updated_at":"2022-06-28 16:44:00","working_address":2745,"capital_currency":"rmb","payment_cycle":"1","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":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":2745,"key":2745,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5927\u885718\u53f716\u5c421822-B","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhlxtxxjsfwyxgs","main_products":"\u540c\u65b9\u4fe1\u521bPC\u4ea7\u54c1","company_nature":4,"website":"","established_at":"2019-08-26","capital":500,"corp_rep":"\u90ed\u82b3\u541b ","reg_address":null,"telephone":"","fax":"","description":"","main_contact":null,"created_by":1011,"created_at":"2021-09-28 15:22:46","updated_at":"2021-09-28 15:22:46","working_address":2630,"capital_currency":"rmb","payment_cycle":"1","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":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":2630,"key":2630,"name":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u987a\u4e49\u533a\u7a7a\u6e2f\u8857\u9053\u4e09\u5c71\u65b0\u65b0\u5bb6\u56ed\u56db\u533a2\u53f7\u697c\u56db\u5c421612\u5ba4","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":94,"name":"\u5317\u4eac\u60e0\u540c\u666e\u65b9\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhtpfkjfzyxgs","main_products":"HP \u6253\u5370\u673a\u3001\u626b\u63cf\u4eea","company_nature":4,"website":"","established_at":"2004-03-30","capital":100,"corp_rep":"\u53f2\u4fee\u742a","reg_address":279,"telephone":"010-82872393","fax":"010-82872393","description":"\u666e\u901a\u4ee3\u7406\u5546\uff0c\u8d26\u671f\uff1a15\u5929\uff0c\u7535\u6c47","main_contact":null,"created_by":1011,"created_at":"2017-03-06 14:51:30","updated_at":"2019-03-05 10:24:33","working_address":280,"capital_currency":"rmb","payment_cycle":"15\u5929","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":{"object_id":94,"comment":2},"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":280,"key":280,"name":"\u4e2d\u6e7e\u56fd\u9645H\u5ea71217","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":171,"name":"\u5317\u4eac\u60e0\u901a\u96c5\u4fe1\u8d38\u6613\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhtyxmyyxgs","main_products":"\u601d\u798f\u8fea\u8fd0\u7ef4\u8f6f\u4ef6\uff08\u5382\u5546\u8fc7\u5355\u7684\u4ee3\u7406\u5546\uff09","company_nature":4,"website":"","established_at":"2003-12-16","capital":50,"corp_rep":"\u5218\u5b50\u5174","reg_address":576,"telephone":"010-82608008","fax":"010-82608008","description":"\u7535\u6c47","main_contact":null,"created_by":1011,"created_at":"2017-06-06 09:15:23","updated_at":"2018-10-31 17:24:07","working_address":577,"capital_currency":"rmb","payment_cycle":"1\u5929","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":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":577,"key":577,"name":"\u82cf\u5dde\u885775\u53f717\u5e62\u5e73\u623f2\u53f7","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":234,"name":"\u5317\u4eac\u60e0\u53cb\u65f6\u4ee3\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":null,"pinyin_shortcut":"bjhysdkjfzyxgs","main_products":"\u601d\u79d1\u7f51\u7edc\u4ea7\u54c1\u548c\u89c6\u9891\u7ec8\u7aef","company_nature":4,"website":"","established_at":"2001-08-07","capital":2000,"corp_rep":"\u9676\u9e9f","reg_address":null,"telephone":"010-51265797","fax":"010-51265797","description":"","main_contact":null,"created_by":1011,"created_at":"2018-04-09 09:45:52","updated_at":"2018-10-29 11:01:40","working_address":1335,"capital_currency":"rmb","payment_cycle":"30","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":null,"companyNature":{"id":4,"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},"workingAddress":{"id":1335,"key":1335,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e0a\u5730\u4fe1\u606f\u8def11\u53f71\u5e62\u56db\u5c42\u897f409\u5ba4","zip":""},"unreadComments":null,"is_cooperated":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"pagenation":{"totalcount":5,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 20:27:14', 84957952) RETURNING "id"