Total processing time: 413 ms; Peak memory: 5.523 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:52:29.479 | 18.3 ms | 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 |
| 16:52:29.420 | 16.9 ms | 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_contact_mobiles' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 16:52:29.383 | 14.7 ms | 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_contacts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 16:52:29.399 | 13.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_contacts" ("name", "user_status", "email", "mobile", "telephone", "telephone_area_code", "telephone_extension_number", "sex", "client_id", "created_by", "created_at", "updated_at", "namecut1", "pinyin_shortcut") VALUES ('4', 2, '', '17687439997', '', '', '', 'M', 3462, 1001, 'now()', 'now()', '4', '4') RETURNING "id" |
| 16:52:29.508 | 12.9 ms | 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 |
| 16:52:29.312 | 12.4 ms | 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 |
| 16:52:29.533 | 12.1 ms | 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 |
| 16:52:29.337 | 12.0 ms | 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_sales_rep_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 16:52:29.238 | 11.8 ms | 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 |
| 16:52:29.223 | 11.6 ms | 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 |
| 16:52:29.182 | 10.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sources" ("client_id", "client_name", "contact_name", "contact_id", "contact_sex", "contact_mobile", "client_industry", "client_type", "client_class", "telephone", "telephone_area_code", "telephone_extension_number", "company_nature", "project_description", "from_contact", "project_status", "sales_rep", "created_by", "status", "distribute_at", "distribute_by") VALUES (NULL, '大姑说的风格', '4', NULL, 'M', '17687439997', 1, 1, 1, '', '', '', 1, '个电饭锅多少', NULL, 1, 1001, 1001, 0, 'now()', 1001) RETURNING "id" |
| 16:52:29.259 | 10.3 ms | 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 |
| 16:52:29.199 | 10.2 ms | 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 |
| 16:52:29.361 | 10.0 ms | 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 |
| 16:52:29.209 | 9.7 ms | 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', 584, 'a:26:{s:2:"id";i:584;s:11:"client_name";s:18:"大姑说的风格";s:12:"contact_name";s:1:"4";s:11:"contact_sex";s:1:"M";s:14:"contact_mobile";s:11:"17687439997";s:9:"telephone";s:0:"";s:19:"telephone_area_code";s:0:"";s:26:"telephone_extension_number";s:0:"";s:19:"project_description";s:18:"个电饭锅多少";s:25:"projects_opportunity_from";N;s:9:"sales_rep";s:4:"1001";s:10:"project_id";N;s:9:"client_id";s:0:"";s:10:"contact_id";s:0:"";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:"1";s:6:"status";i:0;s:12:"from_contact";s:0:"";s:11:"client_type";s:1:"1";s:15:"client_industry";s:1:"1";s:12:"client_class";s:1:"1";s:14:"project_status";s:1:"1";}', '', 1001, '221.216.117.119') |
| 16:52:29.270 | 7.7 ms | 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', 584, 21, 1001, '2026-06-02 16:52:29', '{"id":584,"client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","contact_name":"4","contact_sex":"M","contact_mobile":"17687439997","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","projects_opportunity_from":null,"sales_rep":1001,"project_id":null,"client_id":null,"contact_id":null,"distribute_by":1001,"distribute_at":"2026-06-02 16:52:29","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","company_nature":1,"status":0,"from_contact":null,"client_type":1,"client_industry":1,"client_class":1,"project_status":1}', '{"id":584,"client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","contact_name":"4","contact_sex":"M","contact_mobile":"17687439997","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","projects_opportunity_from":null,"sales_rep":1001,"project_id":null,"client_id":null,"contact_id":null,"distribute_by":1001,"distribute_at":"2026-06-02 16:52:29","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","company_nature":1,"status":0,"from_contact":null,"client_type":1,"client_industry":1,"client_class":1,"project_status":1}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":[]}') RETURNING "id" |
| 16:52:29.461 | 6.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_projects" ("project_title", "project_status", "budget", "profit_pct", "collected", "comment", "from_contact", "client_id", "creator", "created_by", "created_at", "updated_at", "pinyin_shortcut") VALUES ('销售线索生成20260602001', 1, '0', '0', '0', '个电饭锅多少', NULL, 3462, 1001, 1001, 'now()', 'now()', 'xsxssc20260602001') RETURNING "id" |
| 16:52:29.325 | 6.1 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3462, 1001, 'now()', NULL) RETURNING "id" |
| 16:52:29.469 | 5.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 16:52:29.454 | 5.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("created_at" >= '2026-06-02 00:00:00') AND ("created_at" <= '2026-06-02 23:59:59') AND ("project_title" ILIKE '%销售线索生成20260602%') AND (LENGTH(project_title) = 17) ORDER BY "project_title" DESC |
| 16:52:29.193 | 5.5 ms | 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; |
| 16:52:29.371 | 5.4 ms | 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', 3462, 10, 1001, '2026-06-02 16:52:29', '{"cooperated":null,"last_contact":null,"lost_contact_days":null,"keyword":"","from":"","to":"","period":"","unread":0}', '{"cooperated":null,"last_contact":null,"lost_contact_days":null,"keyword":"","from":"","to":"","period":"","unread":0}', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u7ed9\u81ea\u5df1\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]}') RETURNING "id" |
| 16:52:29.377 | 5.1 ms | 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_contacts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 16:52:29.437 | 4.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_contact_mobiles" ("contact_id", "mobile") VALUES (6256, '17687439997') RETURNING "id" |
| 16:52:29.304 | 4.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_clients" ("name", "telephone", "company_nature", "client_type", "client_class", "client_industry", "created_by", "sales_rep", "pick_at", "created_at", "updated_at", "pinyin_shortcut") VALUES ('大姑说的风格', '', 1, 1, 1, 1, 1001, 1001, 'now()', 'now()', 'now()', 'dgsdfg') RETURNING "id" |
| 16:52:29.349 | 4.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_sales_rep_rels" ("sales_rep", "client_id") VALUES (1001, 3462) RETURNING "id" |
| 16:52:29.498 | 4.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4174, 1, '0', '0', '0', 'now()', NULL) RETURNING "id" |
| 16:52:29.475 | 4.3 ms | 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; |
| 16:52:29.255 | 4.1 ms | 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; |
| 16:52:29.522 | 3.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "new_status", "created_by", "created_at") VALUES (4174, 1, 1001, 'now()') RETURNING "id" |
| 16:52:29.416 | 3.7 ms | 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_contact_mobiles' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 16:52:29.443 | 3.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"=6256 |
| 16:52:29.250 | 3.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_source_product_types" ("product_type_id", "name", "source_id") VALUES (2, '服务器', 584) |
| 16:52:29.235 | 2.9 ms | 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; |
| 16:52:29.220 | 2.8 ms | 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; |
| 16:52:29.358 | 2.7 ms | 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; |
| 16:52:29.545 | 2.6 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("product_type_id", "name", "project_id") VALUES (2, '服务器', 4174) |
| 16:52:29.506 | 2.5 ms | 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; |
| 16:52:29.310 | 2.5 ms | 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; |
| 16:52:29.530 | 2.4 ms | 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; |
| 16:52:29.334 | 2.4 ms | 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_sales_rep_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 16:52:29.528 | 2.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4174 |
| 16:52:29.558 | 2.2 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "description2", "is_system") VALUES (1001, '21', 584, '您有一个新的销售线索', '个电饭锅多少', FALSE) RETURNING "id" |
| 16:52:29.562 | 1.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_comments" SET "is_system"=TRUE WHERE "id"=220642 |
| 16:52:29.550 | 1.5 ms | 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', 4174, 1, 1001, '2026-06-02 16:52:29', '{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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" |
| 16:52:29.413 | 1.4 ms | 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\Contacts', 6256, 'a:31:{s:2:"id";i:6256;s:4:"name";s:1:"4";s:5:"email";s:0:"";s:15:"pinyin_shortcut";s:1:"4";s:3:"sex";s:1:"M";s:10:"birth_date";N;s:10:"department";N;s:12:"job_position";N;s:6:"mobile";s:11:"17687439997";s:9:"telephone";s:0:"";s:9:"client_id";i:3462;s:11:"supplier_id";N;s:10:"created_by";i:1001;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:"user_status";s:1:"2";s:11:"description";N;s:12:"contact_type";N;s:16:"contact_attitude";N;s:19:"telephone_area_code";s:0:"";s:26:"telephone_extension_number";s:0:"";s:10:"mp_open_id";N;s:7:"pinyin1";N;s:7:"pinyin2";N;s:7:"pinyin3";N;s:7:"pinyin4";N;s:8:"namecut1";s:1:"4";s:8:"namecut2";N;s:8:"namecut3";N;s:8:"namecut4";N;s:10:"is_mp_bind";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.278 | 1.3 ms | 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', 640903, 'a:13:{s:2:"id";i:640903;s:9:"object_id";i:584;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:636:"{"id":584,"client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","contact_name":"4","contact_sex":"M","contact_mobile":"17687439997","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","projects_opportunity_from":null,"sales_rep":1001,"project_id":null,"client_id":null,"contact_id":null,"distribute_by":1001,"distribute_at":"2026-06-02 16:52:29","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","company_nature":1,"status":0,"from_contact":null,"client_type":1,"client_industry":1,"client_class":1,"project_status":1}";s:9:"new_value";s:636:"{"id":584,"client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","contact_name":"4","contact_sex":"M","contact_mobile":"17687439997","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","projects_opportunity_from":null,"sales_rep":1001,"project_id":null,"client_id":null,"contact_id":null,"distribute_by":1001,"distribute_at":"2026-06-02 16:52:29","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","company_nature":1,"status":0,"from_contact":null,"client_type":1,"client_industry":1,"client_class":1,"project_status":1}";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-02 16:52:29";s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.548 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sources" SET "project_id"=4174, "client_id"=3462, "status"=1 WHERE "id"=584 |
| 16:52:29.447 | 0.9 ms | 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', 6256, 14, 1001, '2026-06-02 16:52:29', '{"id":6256,"name":"4","email":"","pinyin_shortcut":"4","sex":"M","birth_date":null,"department":null,"job_position":null,"mobile":"17687439997","telephone":"","client_id":3462,"supplier_id":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":null,"pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"4","namecut2":null,"namecut3":null,"namecut4":null,"is_mp_bind":false}', '{"id":6256,"name":"4","email":"","pinyin_shortcut":"4","sex":"M","birth_date":null,"department":null,"job_position":null,"mobile":"17687439997","telephone":"","client_id":3462,"supplier_id":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":null,"pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"4","namecut2":null,"namecut3":null,"namecut4":null,"is_mp_bind":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":[]}') RETURNING "id" |
| 16:52:29.452 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (1, 'create', 3462, 10, 6256, 14, 1001, '[6256]', '[6256]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["4"]}') RETURNING "id" |
| 16:52:29.442 | 0.9 ms | 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\ContactMobiles', 7040, 'a:4:{s:2:"id";i:7040;s:10:"contact_id";i:6256;s:6:"mobile";s:11:"17687439997";s:10:"mp_open_id";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.449 | 0.9 ms | 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', 3462, 10, 6256, 14, 1001, '[6256]', '[6256]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["4"]}') RETURNING "id" |
| 16:52:29.355 | 0.8 ms | 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', 3462, 10, 1001, '2026-06-02 16:52:29', '{"id":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":null,"pinyin_shortcut":"dgsdfg","description":null,"corp_rep":null,"website":null,"capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":null,"scale":null,"branch":null,"purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":1,"client_class":1,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":null,"logo":null,"en_name":null,"pick_at":"2026-06-02 16:52:29.304979+08","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null}', '{"id":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":null,"pinyin_shortcut":"dgsdfg","description":null,"corp_rep":null,"website":null,"capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":null,"scale":null,"branch":null,"purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":1,"client_class":1,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":null,"logo":null,"en_name":null,"pick_at":"2026-06-02 16:52:29.304979+08","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]}') RETURNING "id" |
| 16:52:29.448 | 0.8 ms | 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', 640905, 'a:13:{s:2:"id";i:640905;s:9:"object_id";i:6256;s:11:"object_type";i:14;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:578:"{"id":6256,"name":"4","email":"","pinyin_shortcut":"4","sex":"M","birth_date":null,"department":null,"job_position":null,"mobile":"17687439997","telephone":"","client_id":3462,"supplier_id":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":null,"pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"4","namecut2":null,"namecut3":null,"namecut4":null,"is_mp_bind":false}";s:9:"new_value";s:578:"{"id":6256,"name":"4","email":"","pinyin_shortcut":"4","sex":"M","birth_date":null,"department":null,"job_position":null,"mobile":"17687439997","telephone":"","client_id":3462,"supplier_id":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","user_status":2,"description":null,"contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":null,"pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"4","namecut2":null,"namecut3":null,"namecut4":null,"is_mp_bind":false}";s:11:"description";s:87:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-02 16:52:29";s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.579 | 0.8 ms | 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":"","client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","contact_name":"4","contact_id":"","contact_sex":"M","contact_mobile":"17687439997","client_industry":"1","client_type":"1","client_class":"1","telephone":"","telephone_area_code":"","telephone_extension_number":"","company_nature":"1","project_description":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","from_contact_name":"","from_contact":"","sourceProductTypes":["2"],"project_status":"1","sales_rep":"1001"},"web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"id":584},"status":1,"msg":[{"name":"success","success":"\u65b0\u9500\u552e\u7ebf\u7d22\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 16:52:29', 409228032) RETURNING "id" |
| 16:52:29.554 | 0.8 ms | 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', 4174, 1, 1001, '2026-06-02 16:52:29', '{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":[]}') RETURNING "id" |
| 16:52:29.453 | 0.8 ms | 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', 171858, 'a:15:{s:2:"id";i:171858;s:9:"object_id";i:3462;s:11:"object_type";i:10;s:9:"target_id";i:6256;s:18:"target_object_type";i:14;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[6256]";s:9:"new_value";s:6:"[6256]";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:90:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["4"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.450 | 0.8 ms | 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', 640906, 'a:13:{s:2:"id";i:640906;s:9:"object_id";i:3462;s:11:"object_type";i:10;s:9:"target_id";i:6256;s:18:"target_object_type";i:14;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[6256]";s:9:"new_value";s:6:"[6256]";s:11:"description";s:90:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["4"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.356 | 0.8 ms | 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', 640904, 'a:13:{s:2:"id";i:640904;s:9:"object_id";i:3462;s:11:"object_type";i:10;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:1124:"{"id":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":null,"pinyin_shortcut":"dgsdfg","description":null,"corp_rep":null,"website":null,"capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":null,"scale":null,"branch":null,"purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":1,"client_class":1,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":null,"logo":null,"en_name":null,"pick_at":"2026-06-02 16:52:29.304979+08","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null}";s:9:"new_value";s:1124:"{"id":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":null,"pinyin_shortcut":"dgsdfg","description":null,"corp_rep":null,"website":null,"capital":null,"established_at":null,"headcount":null,"reg_address":null,"working_address":null,"telephone":"","fax":null,"scale":null,"branch":null,"purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":1,"client_class":1,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","main_business":null,"deleted":false,"capital_currency":"rmb","invoice_info":null,"logo":null,"en_name":null,"pick_at":"2026-06-02 16:52:29.304979+08","it_budget":null,"deployment_mode":null,"it_per_num":null,"public_relations_difficulty":null,"it_status":null,"decision_process":null,"coach":null,"competitor":null,"peers":null,"supplier":null,"main_product":null,"client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":null,"tax_no":null}";s:11:"description";s:81:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-02 16:52:29";s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.555 | 0.8 ms | 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', 3462, 10, 4174, 1, 1001, '[4174]', '[4174]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":["\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001"]}') RETURNING "id" |
| 16:52:29.552 | 0.7 ms | 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', 640907, 'a:13:{s:2:"id";i:640907;s:9:"object_id";i:4174;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:865:"{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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:865:"{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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-02 16:52:29";s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.353 | 0.7 ms | 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\ClientSalesRepRels', 2971, 'a:5:{s:2:"id";i:2971;s:9:"client_id";i:3462;s:9:"sales_rep";i:1001;s:8:"start_at";N;s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.331 | 0.7 ms | 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', 199807, 'a:5:{s:2:"id";i:199807;s:9:"client_id";i:3462;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.555 | 0.7 ms | 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', 171859, 'a:15:{s:2:"id";i:171859;s:9:"object_id";i:4174;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:865:"{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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:865:"{"id":4174,"client_id":3462,"project_status":1,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-02 16:52:29","engineer_id":null,"project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","collected":"0","status_updated_at":"2026-06-02 16:52:29.461946+08","success_rate":null,"comment":"\u4e2a\u7535\u996d\u9505\u591a\u5c11","contract_type":null,"progress_updated_at":"2026-06-02 16:52:29.461946+08","forecast_updated_at":"2026-06-02 16:52:29.461946+08","end_at":null,"pinyin_shortcut":"xsxssc20260602001","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[1001]";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-02 16:52:29";s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.332 | 0.7 ms | 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\Clients', 3462, 'a:55:{s:2:"id";i:3462;s:4:"name";s:18:"大姑说的风格";s:4:"abbr";N;s:15:"pinyin_shortcut";s:6:"dgsdfg";s:11:"description";N;s:8:"corp_rep";N;s:7:"website";N;s:7:"capital";N;s:14:"established_at";N;s:9:"headcount";N;s:11:"reg_address";N;s:15:"working_address";N;s:9:"telephone";s:0:"";s:3:"fax";N;s:5:"scale";N;s:6:"branch";N;s:21:"purchase_scale_per_yr";N;s:13:"purchase_freq";N;s:14:"company_nature";i:1;s:12:"client_class";i:1;s:15:"client_industry";i:1;s:11:"client_type";i:1;s:9:"sales_rep";i:1001;s:12:"main_contact";N;s:10:"created_by";i:1001;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:13:"main_business";N;s:7:"deleted";N;s:16:"capital_currency";N;s:12:"invoice_info";N;s:4:"logo";N;s:7:"en_name";N;s:7:"pick_at";s:5:"now()";s:9:"it_budget";N;s:15:"deployment_mode";N;s:10:"it_per_num";N;s:27:"public_relations_difficulty";N;s:9:"it_status";N;s:16:"decision_process";N;s:5:"coach";N;s:10:"competitor";N;s:5:"peers";N;s:8:"supplier";N;s:12:"main_product";N;s:22:"client_base_info_count";N;s:21:"client_key_info_count";N;s:13:"contact_count";N;s:11:"visit_count";N;s:15:"cooperate_count";N;s:20:"case_pre_sales_count";N;s:20:"case_implement_count";N;s:17:"is_overdue_remind";N;s:12:"from_contact";N;s:6:"tax_no";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.503 | 0.7 ms | 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', 17841, 'a:8:{s:2:"id";i:17841;s:10:"project_id";i:4174;s:14:"project_status";i:1;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, '221.216.117.119') |
| 16:52:29.526 | 0.7 ms | 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', 4343, 'a:6:{s:2:"id";i:4343;s:10:"project_id";i:4174;s:10:"new_status";i:1;s:10:"old_status";N;s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119') |
| 16:52:29.504 | 0.7 ms | 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', 4174, 'a:32:{s:2:"id";i:4174;s:9:"client_id";i:3462;s:14:"project_status";i:1;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:1001;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:"销售线索生成20260602001";s:9:"collected";i:0;s:17:"status_updated_at";N;s:12:"success_rate";N;s:7:"comment";s:18:"个电饭锅多少";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:"xsxssc20260602001";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, '221.216.117.119') |
| 16:52:29.549 | 0.7 ms | 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', 584, 'a:4:{s:13:"distribute_at";s:19:"2026-06-02 16:52:29";s:6:"status";i:0;s:10:"project_id";i:4174;s:9:"client_id";i:3462;}', '', 1001, '221.216.117.119') |
| 16:52:29.556 | 0.7 ms | 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', 640908, 'a:13:{s:2:"id";i:640908;s:9:"object_id";i:3462;s:11:"object_type";i:10;s:9:"target_id";i:4174;s:18:"target_object_type";i:1;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4174]";s:9:"new_value";s:6:"[4174]";s:11:"description";s:130:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5546\u673a","d4":["\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.561 | 0.7 ms | 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', 220642, 'a:11:{s:2:"id";i:220642;s:9:"object_id";i:584;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:18:"个电饭锅多少";}', '', 1001, '221.216.117.119') |
| 16:52:29.564 | 0.7 ms | 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', 220642, 'a:1:{s:9:"is_system";b:1;}', '', 1001, '221.216.117.119') |
| 16:52:29.377 | 0.7 ms | 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', 171857, 'a:15:{s:2:"id";i:171857;s:9:"object_id";i:3462;s:11:"object_type";i:10;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:118:"{"cooperated":null,"last_contact":null,"lost_contact_days":null,"keyword":"","from":"","to":"","period":"","unread":0}";s:9:"new_value";s:118:"{"cooperated":null,"last_contact":null,"lost_contact_days":null,"keyword":"","from":"","to":"","period":"","unread":0}";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:99:"{"d1":"\u5218\u4eba\u8bda","d2":"\u7ed9\u81ea\u5df1\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-02 16:52:29";s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '221.216.117.119') |
| 16:52:29.171 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:52:29.354 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 16:52:29.451 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 16:52:29.176 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='大姑说的风格') |
| 16:52:29.414 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 16:52:29.179 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='大姑说的风格') |
| 16:52:29.172 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:52:29.505 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 16:52:29.253 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=584 |
| 16:52:29.553 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 16:52:29.175 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "client_name"='大姑说的风格') |
| 16:52:29.280 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:52:29.234 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"='2' |
| 16:52:29.219 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=584 |
| 16:52:29.565 | 0.3 ms | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1001) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 16:52:29.550 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 16:52:29.557 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=584 |
| 16:52:29.558 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.179 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "client_name"='大姑说的风格') |
| 16:52:29.279 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=584 |
| 16:52:29.562 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.177 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.180 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001') |
| 16:52:29.177 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001') |
| 16:52:29.180 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.177 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.180 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:52:29.527 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=584 |
| 16:52:29.170 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:52:29.176 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='1') |
| 16:52:29.178 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='1') |
| 16:52:29.178 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='1') |
| 16:52:29.180 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='1') |
| 16:52:29.181 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='1') |
| 16:52:29.178 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1') |
| 16:52:29.178 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='1') |
| 16:52:29.181 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='1') |
| 16:52:29.181 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='1') |
| 16:52:29.181 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1') |