| 20:24:48.807 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 20:24:48.807 | trace | yii\base\Module::getModule | Loading module: debug |
| 20:24:48.807 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 20:24:48.808 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 20:24:48.808 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 20:24:48.808 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.808 | info | time tracing start | 1780575888808478208 |
| 20:24:48.808 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 20:24:48.808 | trace | yii\web\Application::handleRequest | Route requested: 'vue/source/save-new' |
| 20:24:48.808 | trace | yii\base\Module::getModule | Loading module: vue |
| 20:24:48.809 | info | yii\web\Session::open | Session started |
| 20:24:48.809 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 20:24:48.809 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 20:24:48.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.811 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.811 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.811 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:24:48.811 | trace | yii\base\Controller::runAction | Route to run: vue/source/save-new |
| 20:24:48.812 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.813 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 20:24:48.813 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SourceController::actionSaveNew() |
| 20:24:48.813 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\Sources'. |
| 20:24:48.813 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.814 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.814 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'from_contact_name' in 'app\models\Sources'. |
| 20:24:48.814 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'sourceProductTypes' in 'app\models\Sources'. |
| 20:24:48.814 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.814 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_clients'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:48.851 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_clients'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:48.880 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.881 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:48.881 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3303' |
| 20:24:48.884 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='4') |
| 20:24:48.884 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3303') |
| 20:24:48.885 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='5871') |
| 20:24:48.886 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 20:24:48.887 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:48.887 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:48.888 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43') |
| 20:24:48.888 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='13') |
| 20:24:48.888 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='5') |
| 20:24:48.889 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2') |
| 20:24:48.889 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='4') |
| 20:24:48.889 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3303') |
| 20:24:48.890 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='5871') |
| 20:24:48.890 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 20:24:48.890 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:48.891 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:48.891 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43') |
| 20:24:48.891 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='13') |
| 20:24:48.891 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='5') |
| 20:24:48.891 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2') |
| 20:24:48.892 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sources" ("client_id", "client_name", "client_industry", "client_type", "client_class", "telephone", "telephone_area_code", "telephone_extension_number", "company_nature", "project_description", "from_contact", "project_status", "sales_rep", "contact_mobile", "contact_sex", "contact_name", "contact_id", "created_by", "status", "distribute_at", "distribute_by") VALUES (3303, '北京神州邦邦技术服务有限公司(过单)', 13, 5, 43, '', '', '', 4, 'gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发', NULL, 2, 1004, '13501170233', 'F', '盛璟', 5871, 1001, 0, 'now()', 1001) RETURNING "id" |
| 20:24:48.902 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.902 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_action_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:48.905 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_action_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:48.915 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.915 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:48.915 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Sources', 590, 'a:26:{s:2:"id";i:590;s:11:"client_name";s:54:"北京神州邦邦技术服务有限公司(过单)";s:12:"contact_name";s:6:"盛璟";s:11:"contact_sex";s:1:"F";s:14:"contact_mobile";s:11:"13501170233";s:9:"telephone";s:0:"";s:19:"telephone_area_code";s:0:"";s:26:"telephone_extension_number";s:0:"";s:19:"project_description";s:130:"gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发";s:25:"projects_opportunity_from";N;s:9:"sales_rep";i:1004;s:10:"project_id";N;s:9:"client_id";s:4:"3303";s:10:"contact_id";s:4:"5871";s:13:"distribute_by";i:1001;s:13:"distribute_at";s:19:"1970-01-01 08:00:00";s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:14:"company_nature";s:1:"4";s:6:"status";i:0;s:12:"from_contact";s:0:"";s:11:"client_type";s:1:"5";s:15:"client_industry";s:2:"13";s:12:"client_class";s:2:"43";s:14:"project_status";s:1:"2";}', '', 1001, '111.194.208.14') |
| 20:24:48.927 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=590 |
| 20:24:48.927 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.927 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_product_types'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:48.930 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_product_types'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:48.941 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.942 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:48.942 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"='88' |
| 20:24:48.942 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.942 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_source_product_types'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:48.946 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_source_product_types'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:48.959 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.959 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:48.959 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_source_product_types" ("product_type_id", "name", "source_id") VALUES (88, '私有云', 590) |
| 20:24:48.964 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=590 |
| 20:24:48.966 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:48.966 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_object_change_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:48.970 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_object_change_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:48.981 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:48.981 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:48.981 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 590, 21, 1001, '2026-06-04 20:24:48', '{"id":590,"client_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","contact_name":"\u76db\u749f","contact_sex":"F","contact_mobile":"13501170233","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","projects_opportunity_from":null,"sales_rep":1004,"project_id":null,"client_id":3303,"contact_id":5871,"distribute_by":1001,"distribute_at":"2026-06-04 20:24:48","created_by":1001,"created_at":"2026-06-04 20:24:48","updated_at":"2026-06-04 20:24:48","company_nature":4,"status":0,"from_contact":null,"client_type":5,"client_industry":13,"client_class":43,"project_status":2}', '{"id":590,"client_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","contact_name":"\u76db\u749f","contact_sex":"F","contact_mobile":"13501170233","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","projects_opportunity_from":null,"sales_rep":1004,"project_id":null,"client_id":3303,"contact_id":5871,"distribute_by":1001,"distribute_at":"2026-06-04 20:24:48","created_by":1001,"created_at":"2026-06-04 20:24:48","updated_at":"2026-06-04 20:24:48","company_nature":4,"status":0,"from_contact":null,"client_type":5,"client_industry":13,"client_class":43,"project_status":2}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":[]}') RETURNING "id" |
| 20:24:48.992 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641179, 'a:13:{s:2:"id";i:641179;s:9:"object_id";i:590;s:11:"object_type";i:21;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:938:"{"id":590,"client_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","contact_name":"\u76db\u749f","contact_sex":"F","contact_mobile":"13501170233","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","projects_opportunity_from":null,"sales_rep":1004,"project_id":null,"client_id":3303,"contact_id":5871,"distribute_by":1001,"distribute_at":"2026-06-04 20:24:48","created_by":1001,"created_at":"2026-06-04 20:24:48","updated_at":"2026-06-04 20:24:48","company_nature":4,"status":0,"from_contact":null,"client_type":5,"client_industry":13,"client_class":43,"project_status":2}";s:9:"new_value";s:938:"{"id":590,"client_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","contact_name":"\u76db\u749f","contact_sex":"F","contact_mobile":"13501170233","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","projects_opportunity_from":null,"sales_rep":1004,"project_id":null,"client_id":3303,"contact_id":5871,"distribute_by":1001,"distribute_at":"2026-06-04 20:24:48","created_by":1001,"created_at":"2026-06-04 20:24:48","updated_at":"2026-06-04 20:24:48","company_nature":4,"status":0,"from_contact":null,"client_type":5,"client_industry":13,"client_class":43,"project_status":2}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-04 20:24:48";s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 20:24:48.993 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3303 |
| 20:24:49.018 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "name"='北京神州邦邦技术服务有限公司(过单)', "updated_at"='now()' WHERE "id"=3303 |
| 20:24:49.022 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3303) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 20:24:49.948 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:49.949 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_client_am_change_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:49.952 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_client_am_change_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:49.972 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:49.972 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:49.972 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3303, 1004, 'now()', NULL) RETURNING "id" |
| 20:24:49.982 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199862, 'a:5:{s:2:"id";i:199862;s:9:"client_id";i:3303;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14') |
| 20:24:49.983 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3303, 'a:0:{}', '', 1001, '111.194.208.14') |
| 20:24:49.984 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 3303, 10, 590, 21, 1001, '[590]', '[590]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":["gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1"]}') RETURNING "id" |
| 20:24:49.986 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641180, 'a:13:{s:2:"id";i:641180;s:9:"object_id";i:3303;s:11:"object_type";i:10;s:9:"target_id";i:590;s:18:"target_object_type";i:21;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[590]";s:9:"new_value";s:5:"[590]";s:11:"description";s:348:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":["gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 20:24:49.986 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=590 |
| 20:24:49.987 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:24:49.988 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3303 |
| 20:24:49.989 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3303) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 20:24:50.026 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3303, 1004, 'now()', NULL) RETURNING "id" |
| 20:24:50.027 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199863, 'a:5:{s:2:"id";i:199863;s:9:"client_id";i:3303;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.028 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3303, 'a:0:{}', '', 1001, '111.194.208.14') |
| 20:24:50.029 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("created_at" >= '2026-06-04 00:00:00') AND ("created_at" <= '2026-06-04 23:59:59') AND ("project_title" ILIKE '%销售线索生成20260604%') AND (LENGTH(project_title) = 17) ORDER BY "project_title" DESC |
| 20:24:50.035 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.035 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.036 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_projects" ("project_title", "project_status", "budget", "profit_pct", "collected", "comment", "client_id", "creator", "created_by", "from_contact", "created_at", "updated_at", "pinyin_shortcut") VALUES ('销售线索生成20260604002', 2, '0', '0', '0', 'gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发', 3303, 1001, 1004, NULL, 'now()', 'now()', 'xsxssc20260604002') RETURNING "id" |
| 20:24:50.043 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4178) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 20:24:50.050 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.050 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_project_change_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:50.055 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_project_change_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:50.072 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.072 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:50.072 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4178, 2, '0', '0', '0', 'now()', NULL) RETURNING "id" |
| 20:24:50.077 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17852, 'a:8:{s:2:"id";i:17852;s:10:"project_id";i:4178;s:14:"project_status";i:2;s:6:"budget";i:0;s:10:"profit_pct";i:0;s:9:"collected";i:0;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.079 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Projects', 4178, 'a:32:{s:2:"id";i:4178;s:9:"client_id";i:3303;s:14:"project_status";i:2;s:16:"project_progress";N;s:6:"budget";i:0;s:10:"profit_pct";i:0;s:12:"bargain_date";N;s:11:"description";N;s:10:"created_by";i:1004;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:11:"engineer_id";N;s:13:"project_title";s:29:"销售线索生成20260604002";s:9:"collected";i:0;s:17:"status_updated_at";N;s:12:"success_rate";N;s:7:"comment";s:130:"gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发";s:13:"contract_type";N;s:19:"progress_updated_at";N;s:19:"forecast_updated_at";N;s:6:"end_at";N;s:15:"pinyin_shortcut";s:17:"xsxssc20260604002";s:7:"creator";i:1001;s:11:"used_client";N;s:12:"from_contact";N;s:19:"total_contact_point";N;s:18:"paid_contact_point";N;s:26:"project_product_version_id";N;s:20:"is_sales_order_ready";N;s:14:"collected_plan";N;s:16:"change_status_to";N;s:9:"is_verify";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.080 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3303 |
| 20:24:50.081 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.081 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_project_status_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:50.085 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_project_status_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:50.098 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.098 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:50.098 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "new_status", "created_by", "created_at") VALUES (4178, 2, 1001, 'now()') RETURNING "id" |
| 20:24:50.104 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectStatusLogs', 4356, 'a:6:{s:2:"id";i:4356;s:10:"project_id";i:4178;s:10:"new_status";i:2;s:10:"old_status";N;s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '111.194.208.14') |
| 20:24:50.104 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=590 |
| 20:24:50.105 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4178 |
| 20:24:50.107 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.107 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_project_product_types'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:50.110 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_project_product_types'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:50.122 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.122 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:50.122 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("product_type_id", "name", "project_id") VALUES (88, '私有云', 4178) |
| 20:24:50.125 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sources" SET "project_id"=4178, "status"=1 WHERE "id"=590 |
| 20:24:50.126 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Sources', 590, 'a:3:{s:13:"distribute_at";s:19:"2026-06-04 20:24:48";s:6:"status";i:1;s:10:"project_id";i:4178;}', '', 1001, '111.194.208.14') |
| 20:24:50.127 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4178 |
| 20:24:50.128 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 4178, 1, 1001, '2026-06-04 20:24:50', '{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}', '{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]}') RETURNING "id" |
| 20:24:50.129 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641181, 'a:13:{s:2:"id";i:641181;s:9:"object_id";i:4178;s:11:"object_type";i:1;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:1082:"{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}";s:9:"new_value";s:1082:"{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}";s:11:"description";s:81:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-04 20:24:50";s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.130 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3303 |
| 20:24:50.132 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.132 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_user_action_logs'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:50.136 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_user_action_logs'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:50.147 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.147 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:50.147 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (1, 'create', 4178, 1, 1001, '2026-06-04 20:24:50', '{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}', '{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}', array[1004], '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]}') RETURNING "id" |
| 20:24:50.153 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 171924, 'a:15:{s:2:"id";i:171924;s:9:"object_id";i:4178;s:11:"object_type";i:1;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:1082:"{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}";s:9:"new_value";s:1082:"{"id":4178,"client_id":3303,"project_status":2,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2026-06-04 20:24:50","updated_at":"2026-06-04 20:24:50","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002","collected":"0","status_updated_at":"2026-06-04 20:24:50.036794+08","success_rate":null,"comment":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1","contract_type":null,"progress_updated_at":"2026-06-04 20:24:50.036794+08","forecast_updated_at":"2026-06-04 20:24:50.036794+08","end_at":null,"pinyin_shortcut":"xsxssc20260604002","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"change_status_to":null,"is_verify":false}";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:81:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-04 20:24:50";s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.155 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 3303, 10, 4178, 1, 1001, '[4178]', '[4178]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":["\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002"]}') RETURNING "id" |
| 20:24:50.156 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641182, 'a:13:{s:2:"id";i:641182;s:9:"object_id";i:3303;s:11:"object_type";i:10;s:9:"target_id";i:4178;s:18:"target_object_type";i:1;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4178]";s:9:"new_value";s:6:"[4178]";s:11:"description";s:130:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":["\u9500\u552e\u7ebf\u7d22\u751f\u621020260604002"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14') |
| 20:24:50.157 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.157 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.157 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=590 |
| 20:24:50.158 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:50.158 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "description2", "is_system") VALUES (1001, '21', 590, '您有一个新的销售线索', 'gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发', FALSE) RETURNING "id" |
| 20:24:50.163 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220708, 'a:11:{s:2:"id";i:220708;s:9:"object_id";i:590;s:11:"object_type";s:2:"21";s:6:"parent";N;s:11:"description";s:30:"您有一个新的销售线索";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:0;s:8:"for_user";N;s:12:"description2";s:130:"gasdf 阿斯顿发阿斯顿发阿斯顿发撒地方撒地方撒地方撒发顺丰撒发啊是苏打粉撒发撒发啊是 发生发";}', '', 1001, '111.194.208.14') |
| 20:24:50.164 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:24:50.165 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_comments" SET "is_system"=TRUE WHERE "id"=220708 |
| 20:24:50.167 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Comments', 220708, 'a:1:{s:9:"is_system";b:1;}', '', 1001, '111.194.208.14') |
| 20:24:50.168 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.168 | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
t.typname AS data_type,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p'
WHERE
a.attnum > 0 and t.typname != ''
and c.relname = 'tbl_unread_comments'
and d.nspname = 'a57be577deb434'
ORDER BY
a.attnum; |
| 20:24:50.172 | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='tbl_unread_comments'
and ns.nspname='a57be577deb434'
order by
fns.nspname, fc.relname, a.attnum |
| 20:24:50.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 20:24:50.193 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (590, '21', 220708, 1004) |
| 20:24:50.200 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1004) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 20:24:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 20:24:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 20:24:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 20:24:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 20:24:50.216 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/source/save-new', '{"Sources":{"id":"","client_id":"3303","client_name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","client_industry":"13","client_type":"5","client_class":"43","telephone":"","telephone_area_code":"","telephone_extension_number":"","company_nature":"4","project_description":"gasdf \u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u963f\u65af\u987f\u53d1\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u5730\u65b9\u6492\u53d1\u987a\u4e30\u6492\u53d1\u554a\u662f\u82cf\u6253\u7c89\u6492\u53d1\u6492\u53d1\u554a\u662f \u53d1\u751f\u53d1 ","from_contact_name":"","from_contact":"","sourceProductTypes":["88"],"project_status":"2","sales_rep":"1004","contact_mobile":"13501170233","contact_sex":"F","contact_name":"\u76db\u749f","contact_id":"5871"}}', '{"code":2000,"result":{"id":590},"status":1,"msg":[{"name":"success","success":"\u65b0\u9500\u552e\u7ebf\u7d22\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-04 20:24:50', 1407581696) RETURNING "id" |
| 20:24:50.217 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 20:24:50.217 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |