Log Messages

总计72条数据
TimeLevelCategoryMessage
 
10:53:30.177traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:53:30.177traceyii\base\Module::getModuleLoading module: debug
10:53:30.177traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:53:30.178traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:53:30.178traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:53:30.178traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.178infotime tracing start1780282410178513920
10:53:30.178traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:53:30.178traceyii\web\Application::handleRequestRoute requested: 'vue/approve/export'
10:53:30.178traceyii\base\Module::getModuleLoading module: vue
10:53:30.179infoyii\web\Session::openSession started
10:53:30.179infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:53:30.179infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:53:30.180traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.180traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:53:30.181traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.181traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:53:30.181infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:53:30.182traceyii\base\Controller::runActionRoute to run: vue/approve/export
10:53:30.182traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.183traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:53:30.183traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ApproveController::actionExport()
10:53:30.183traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.183traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:53:30.183traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.184traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.185infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:53:30.185infoyii\db\Command::querySELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5449, 5461, 5476)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."status"='4') GROUP BY "r"."id" ORDER BY "r"."status", "r"."created_at" DESC
10:53:30.189infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5087, 5360, 1005, 1017, 5295, 1015, 1011, 1013, 5015, 5252)
10:53:30.190infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1015, 1011, 1017, 5300, 5015, 5252, 5087, 1013, 5360, 1005))
10:53:30.190infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 2, 3, 9, 6, 7)
10:53:30.191infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) GROUP BY "object_id"
10:53:30.215infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND ("remind_user_id"=1001) AND ("is_read"=FALSE) AND ("object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) GROUP BY "object_id"
10:53:30.235infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.237infoyii\db\Command::querySELECT "id", "name", "approve_verify_user", "approve_carbon_copy_user" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (165, 179, 142, 98, 45, 46, 97, 101, 205, 203, 107, 105, 100, 213, 8, 96, 102, 94, 197, 199, 166, 115, 164, 1, 2, 7, 175, 185, 191, 128, 131, 136, 137, 153, 139, 167, 173, 140, 305, 184, 189, 138, 204, 224, 168, 210, 198, 202, 182, 181, 183, 106, 172, 6, 93, 5, 11, 9, 212, 154, 10, 215, 226, 129, 130, 156, 200, 194, 196, 160, 207, 208, 209, 229, 211, 214, 216, 217, 218, 221, 222, 223, 155, 225, 114, 227, 228, 230, 231, 313, 178, 304, 135, 2100000000, 317, 159, 311, 112, 340, 322, 319, 341, 349, 320, 324, 326, 353, 359, 367, 369, 374, 377, 350, 354, 373, 315))
10:53:30.238infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.240infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1011, 5252, 1001, 1013, 5015, 5360, 1004, 5388, 5413, 1015, 1005, 5087, 5445)
10:53:30.241infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1015, 1011, 5015, 5445, 5252, 5413, 1014, 5388, 5087, 1004, 1013, 5360, 1005))
10:53:30.241infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97) ORDER BY "id"
10:53:30.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5295, 1013, 5252, 1011, 1014)
10:53:30.242infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1011, 5252, 1014, 1013))
10:53:30.243infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (127, 166, 206, 210, 251, 252, 256, 423, 445, 462, 503, 576, 640, 641, 681, 758, 824, 1036, 1133, 1153, 1189, 1190, 1345, 1408, 1445, 2061, 2226, 2227, 2298, 2464, 2589, 2980, 2981, 3441, 3442, 3726))
10:53:30.245infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (127, 166, 206, 210, 251, 252, 256, 423, 445, 462, 503, 576, 640, 641, 681, 758, 824, 1036, 1133, 1153, 1189, 1190, 1345, 1408, 1445, 2061, 2226, 2227, 2298, 2464, 2589, 2980, 2981, 3441, 3442, 3726))
10:53:30.247infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) ORDER BY "id"
10:53:30.248infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) ORDER BY "id"
10:53:30.249infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97))
10:53:30.251infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (12164, 20802, 28558, 28559, 32665)
10:53:30.253infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3432, 101, 2128, 12, 2125, 90, 2599, 2704, 2136, 2130, 107)
10:53:30.253infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4079, 3559, 3801, 3802, 3682, 3249, 3446, 3330, 3350, 3294, 3314, 3168, 2867)
10:53:30.256infoyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3682, 3802, 3446, 3294, 3168, 3249, 3559, 4079, 3801, 2867, 3314, 3330, 3350)
10:53:30.257infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (287, 735, 46, 629, 556)
10:53:30.257infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name", "handler", "cost_type", "erp_un_settle_amount", "created_at", "amount", "erp_un_settle_amount", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4173, 3666, 3429, 2930)
10:53:30.258infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (2930, 3429, 3666, 4173) ORDER BY "remind_date"
10:53:30.258infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
10:53:30.258infoyii\db\Command::querySELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (2930, 3429, 3666, 4173)) ORDER BY "id"
10:53:30.259traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:53:30.259traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:53:30.259infoyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=410
10:53:30.259infoyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=307
10:53:30.260infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97) ORDER BY "id"
10:53:30.260infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) ORDER BY "id"
10:53:30.261infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)) ORDER BY "id"
10:53:30.261infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97))
10:53:30.263infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (15070, 18740, 23878, 24713, 24714, 31041, 31044, 32666)
10:53:30.265infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.265infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.266infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.266infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.266infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.267infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97)
10:53:30.267infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2753, 2577, 2576, 2280, 2001, 1910, 1783, 1730, 1729, 1606, 1113, 1083, 1032, 913, 887, 873, 790, 628, 580, 528, 505, 471, 427, 393, 381, 362, 208, 206, 168, 166, 130, 97))
10:53:30.291infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1001, 1013, 5295, 5015, 5252, 1011, 1014, 1017, 5300, 1015, 5360, 1005, 5064)