ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868be9b5a91e: POST https://beta.jinchangxiao.com/vue/analysis/sales-year-histogram at 2025-07-05 01:56:43 pm by 223.72.35.175

Log Messages

总计40条数据
TimeLevelCategoryMessage
 
13:56:43.370traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
13:56:43.370traceyii\base\Module::getModuleLoading module: debug
13:56:43.370traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
13:56:43.371traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
13:56:43.371traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
13:56:43.371traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.371traceyii\base\Module::getModuleLoading module: gii
13:56:43.371traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
13:56:43.372traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
13:56:43.372traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-year-histogram'
13:56:43.372traceyii\base\Module::getModuleLoading module: vue
13:56:43.372infoyii\web\Session::openSession started
13:56:43.373infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
13:56:43.373infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:56:43.379traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.380traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:56:43.380traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.380traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:56:43.380infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
13:56:43.382traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-year-histogram
13:56:43.383traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.384traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:56:43.384traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesYearHistogram()
13:56:43.384traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.384traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:56:43.384infoyii\db\Command::querySELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
13:56:43.385infoyii\db\Command::querySELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
13:56:43.387traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.388traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.389infoyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, CASE WHEN p.bargain_date >= (to_char(p.bargain_date,'YYYY-') || '01-01') :: DATE THEN to_char( P.bargain_date, 'YYYY')::INTEGER ELSE to_char( P.bargain_date, 'YYYY')::INTEGER - 1 END AS bargain_year FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
13:56:43.397infoyii\db\Command::querySELECT count(distinct p.client_id) as avg_client, count(distinct p.id) as avg_project, sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "a57be577deb434"."tbl_projects" "p" WHERE "project_status"=3
13:56:43.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.400traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:56:43.400infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
13:56:43.406traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.406traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:56:43.407infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=83, "last_visit_at"='now()' WHERE "id"=49799
13:56:43.408infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/sales-year-histogram', '{"user_id":"","project_status":"3","alert":"false","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"category":{"budgetCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"profitsCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"clientCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"projectCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"]},"seriesBudget":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"9783017.70"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"65931903.70"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"35134547.09"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"33886193.64"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"35224503.80"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"44169012.80"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"48005880.55"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"45825636.94"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"32376587.50"}],"seriesProfits":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"1016937.54"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"8578826.32"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"4090144.83"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"8613044.01"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"7365186.61"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"9592543.48"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"13310849.09"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"8404778.14"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"6781289.89"}],"seriesClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":32},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":109},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":112},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":87},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":80},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":66},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":78},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":87},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":55}],"seriesProjects":[{"key":"fascal2025","name":"2025\u8d22\u5e74","y":44},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":255},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":206},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":156},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":140},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":146},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":167},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":205},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":140}],"avg":{"avg_client":"37.56","avg_project":"163.22","avg_budget":"39068341.97","avg_profit":"7563887.95"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 13:56:43') RETURNING "id"
13:56:43.410traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:56:43.410traceyii\redis\Connection::executeCommandExecuting Redis Command: SET