ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d1f764256a: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2026-06-01 01:58:14 pm by 43.224.72.82

Log Messages

总计72条数据
TimeLevelCategoryMessage
 
13:58:14.269traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
13:58:14.269traceyii\base\Module::getModuleLoading module: debug
13:58:14.269traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
13:58:14.271traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
13:58:14.272traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
13:58:14.273traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.277infotime tracing start1780293494277908992
13:58:14.278traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
13:58:14.278traceyii\web\Application::handleRequestRoute requested: 'vue/project/list-all-status'
13:58:14.278traceyii\base\Module::getModuleLoading module: vue
13:58:14.335infoyii\web\Session::openSession started
13:58:14.336infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5495
13:58:14.336infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:58:14.338traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.338traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:58:14.338traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.339traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:58:14.339infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
13:58:14.340traceyii\base\Controller::runActionRoute to run: vue/project/list-all-status
13:58:14.340traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.341traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:58:14.341traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProject
13:58:14.341traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:58:14.341traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:58:14.341traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
13:58:14.341traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionListAllStatus()
13:58:14.342traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.342traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:58:14.343traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'from_contact_name' in 'app\models\search\ProjectSearch'.
13:58:14.343traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.343traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.344infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.350infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.356infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.362infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.369infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.374infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.379infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.385infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.390infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.395infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.402infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
13:58:14.403infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
13:58:14.403infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
13:58:14.404infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
13:58:14.404infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1
13:58:14.405infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"
13:58:14.405infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "o6a13e2c574d5a"."tbl_project_statuses" WHERE "id"=3
13:58:14.405infoyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "o6a13e2c574d5a"."tbl_project_progresses" WHERE "id"=6
13:58:14.406infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "o6a13e2c574d5a"."tbl_project_remind_receivers" WHERE "project_id"=1
13:58:14.406traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateProject
13:58:14.406traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:58:14.406traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:58:14.406traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: deleteProject
13:58:14.406traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:58:14.406infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.411infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.415infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.421infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.425infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.429infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.434infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.440infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:14.445infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:14.452traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createProject
13:58:14.452traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:58:14.452traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:58:14.452traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.453traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:58:14.453infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/project/list-all-status', '{"ProjectSearch":{"group":"","project_status":"","creator":"","purchaseType":"","engineer_group":"","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"list1count":0,"list1sum":"","list1":[],"list2count":0,"list2sum":"","list2":[],"list3count":1,"list3sum":"10000","list3":[{"id":1,"client_id":1,"project_status":3,"project_progress":6,"budget":"10000","profit_pct":"60","bargain_date":"2026-05-27","description":"","created_by":5493,"created_at":"2026-05-27 17:25:00","updated_at":"2026-05-27 17:32:47","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001","collected":"0","status_updated_at":"2026-05-27 17:26:48.428905+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u64cd\u4f5c","contract_type":1,"progress_updated_at":"2026-05-27 17:26:48.428905+08","forecast_updated_at":"2026-05-27 17:26:48.428905+08","end_at":"","pinyin_shortcut":"xsxssc20260527001","creator":5495,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1,"is_sales_order_ready":false,"collected_plan":"10000","change_status_to":"","is_verify":false,"profits":"6000.0000000000000000","remain":"4 days 20:31:25.967979","progress_remain":"4 days 20:31:25.967979","forecast_remain":"4 days 20:31:25.967979","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"4 days 20:33:13.943856","issued_invoices":"","client":{"id":1,"key":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","logo":"","client_type":1,"client_class":1,"client_industry":20,"sales_rep":5493},"usedClient":{},"salesRep":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}},"salesForecast":{"id":93,"key":93,"name":"\u786e\u4fdd","description":"100%\u786e\u8ba4\u5728\u6210\u4ea4\u65e5\u671f\u5185\u7b7e\u8ba2\u5408\u540c\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002\n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u7248\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_update":false,"can_delete":false}],"list4count":0,"list4sum":"","list4":[],"list5count":0,"list5sum":"","list5":[],"list6count":0,"list6sum":"","list6":[],"thisUser":"","can_create":false,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:58:14', 175264000) RETURNING "id"
13:58:14.469traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:58:14.471traceyii\redis\Connection::executeCommandExecuting Redis Command: SET