ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
687745fd062ec: POST https://beta.jinchangxiao.com/vue/analysis/contacts at 2025-07-16 02:26:05 pm by 124.127.56.185

Log Messages

总计37条数据
TimeLevelCategoryMessage
 
14:26:05.024traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:26:05.024traceyii\base\Module::getModuleLoading module: debug
14:26:05.024traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:26:05.025traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:26:05.025traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:26:05.025traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.026traceyii\base\Module::getModuleLoading module: gii
14:26:05.026traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:26:05.026traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:26:05.026traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/contacts'
14:26:05.026traceyii\base\Module::getModuleLoading module: vue
14:26:05.035infoyii\web\Session::openSession started
14:26:05.035infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:26:05.036infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:26:05.042traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.042traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:26:05.043traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.043traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:26:05.043infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:26:05.045traceyii\base\Controller::runActionRoute to run: vue/analysis/contacts
14:26:05.045traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.047traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:26:05.047traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionContacts()
14:26:05.047infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_contacts" WHERE "client_id" IS NOT NULL
14:26:05.052infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_contacts" WHERE ("client_id" IS NOT NULL) AND ("user_status"=1)
14:26:05.053infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_contacts" WHERE ("client_id" IS NOT NULL) AND ("user_status"=3)
14:26:05.057infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "c".* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id WHERE ("c"."client_id" IS NOT NULL) AND ("cm"."mp_open_id" IS NOT NULL) AND ("c"."is_mp_bind"=TRUE) GROUP BY "c"."id") "c"
14:26:05.061infoyii\db\Command::querySELECT u.id, u.name, count(c.id) as count FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON u.id = c.created_by WHERE ("c"."id" IS NOT NULL) AND ("c"."client_id" IS NOT NULL) GROUP BY "u"."id" ORDER BY "count" DESC
14:26:05.065traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.067traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:26:05.069infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-07-16')
14:26:05.076traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.076traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:26:05.076infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=10, "last_visit_at"='now()' WHERE "id"=49842
14:26:05.078infoyii\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/analysis/contacts', '{"period":"all","from":"","to":"","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":1001,"name":"\u5218\u4eba\u8bda","count":347},{"id":1005,"name":"\u8d75\u6657\u7131","count":282},{"id":5332,"name":"\u970d\u536b\u8d85","count":242},{"id":5359,"name":"\u5f20\u6d69\u7136","count":207},{"id":1006,"name":"\u6731\u5bb8\u96e8","count":194},{"id":5015,"name":"\u5f20\u96ea\u677e","count":162},{"id":1003,"name":"\u5415\u5174\u5143","count":161},{"id":1011,"name":"\u97e9\u96c5\u82b3","count":123},{"id":5096,"name":"\u674e\u6c5f\u661f","count":114},{"id":5311,"name":"\u62d3\u5c0f\u6587","count":107},{"id":5295,"name":"\u9b4f\u6cfd\u6587","count":98},{"id":5300,"name":"\u82cf\u6e05\u4e91","count":89},{"id":5089,"name":"\u5b59\u5a77\u5a77","count":88},{"id":1004,"name":"\u4f0a\u5cfb\u8fb0","count":85},{"id":5087,"name":"\u5218\u5fae","count":76},{"id":5072,"name":"\u4e8e\u7b60\u6052","count":64},{"id":1008,"name":"\u5218\u66e6\u7433","count":59},{"id":1023,"name":"\u5468\u5b50\u5065","count":58},{"id":5088,"name":"\u7f57\u7199","count":57},{"id":5026,"name":"\u4e1c\u5cf0","count":51},{"id":5329,"name":"\u9ad8\u5ce5","count":50},{"id":1022,"name":"\u5f90\u7855","count":49},{"id":5364,"name":"\u738b\u827a\u742e","count":41},{"id":1007,"name":"\u5b59\u6167","count":37},{"id":1016,"name":"\u8346\u626c","count":29},{"id":5032,"name":"\u9122\u535a","count":25},{"id":5209,"name":"\u5d14\u5efa\u8def","count":23},{"id":5420,"name":"\u674e\u6ea6","count":23},{"id":5043,"name":"\u5218\u79b9","count":23},{"id":5076,"name":"\u5b8b\u6d77\u7389","count":23},{"id":5309,"name":"\u7518\u83b9\u83b9","count":21},{"id":5413,"name":"\u8096\u6167\u4e3d","count":19},{"id":5045,"name":"\u5218\u5c0a\u559c","count":17},{"id":1015,"name":"\u5434\u660a","count":15},{"id":5299,"name":"\u4f55\u806a","count":13},{"id":5208,"name":"\u5415\u6770","count":13},{"id":5023,"name":"\u5f90\u4eac\u5357","count":12},{"id":5358,"name":"\u5468\u4e9a\u536b","count":11},{"id":1021,"name":"\u6c6a\u6653\u50b2","count":11},{"id":5297,"name":"\u6731\u9999\u83b2","count":9},{"id":5044,"name":"\u7941\u661f","count":8},{"id":1009,"name":"\u9b4f\u78ca","count":8},{"id":1019,"name":"\u90dd\u5c06\u4f1f","count":7},{"id":1018,"name":"\u7a0b\u946b\u658c","count":7},{"id":5094,"name":"\u5218\u5fd7\u521a","count":7},{"id":5075,"name":"\u6768\u5a01","count":6},{"id":5063,"name":"\u674e\u73ca\u73ca","count":6},{"id":5082,"name":"\u674e\u5fd7\u535a","count":6},{"id":5069,"name":"\u738b\u5029","count":6},{"id":5248,"name":"\u6587\u4f73\u9f99","count":5},{"id":5027,"name":"\u5b59\u5c11\u752b","count":5},{"id":1020,"name":"\u738b\u6069\u56fd","count":5},{"id":5360,"name":"\u5f20\u7ea2\u82b3","count":4},{"id":5229,"name":"\u5f20\u632f\u90a6","count":4},{"id":5304,"name":"\u8d75\u4e9a\u5a1f","count":4},{"id":1025,"name":"\u5411\u9633","count":3},{"id":5247,"name":"\u5f20\u91d1\u9192","count":3},{"id":1030,"name":"\u6c88\u7ea2\u82f1","count":3},{"id":5085,"name":"\u970d\u4e1c\u9633","count":3},{"id":5070,"name":"\u674e\u6676\u6676","count":3},{"id":1000,"name":"\u66f9\u6c38\u751f","count":3},{"id":5301,"name":"\u7545\u78ca","count":3},{"id":5298,"name":"\u675c\u6587\u98de","count":3},{"id":1010,"name":"\u9ad8\u73b2\u8273","count":2},{"id":5124,"name":"\u5f90\u73b2\u73b2","count":2},{"id":5411,"name":"\u7530\u60a6","count":2},{"id":5123,"name":"\u5218\u66e6\u5b50","count":2},{"id":5296,"name":"\u8d75\u5b87","count":2},{"id":5064,"name":"\u59da\u96ea\u7eaf","count":2},{"id":5031,"name":"\u7f57\u8c46","count":1},{"id":5074,"name":"\u803f\u7a0b\u6797","count":1},{"id":5259,"name":"\u674e\u8861","count":1},{"id":5022,"name":"\u6148\u5e05","count":1},{"id":5016,"name":"\u9ad8\u90e1\u9633","count":1},{"id":1017,"name":"\u8f66\u660e\u98de","count":1}],"total":3258,"dismissed":238,"missed":32,"bind":283},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-16 14:26:05') RETURNING "id"
14:26:05.080traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:26:05.080traceyii\redis\Connection::executeCommandExecuting Redis Command: SET