Total processing time: 229 ms; Peak memory: 5.873 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 22:39:02.602 | 22.1 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20010) AND ("object_id"=24) AND ("remind_user_id"=1001) AND ("is_read"=FALSE) |
| 22:39:02.450 | 13.7 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (26, 24, 1558, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.563 | 9.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_erp_ticket_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:39:02.486 | 9.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_settings' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:39:02.585 | 7.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_erp_ticket_change_log_handlers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:39:02.573 | 6.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20010, 'HZD-20260703-00001', '2026-07-03', NULL, '的孤独感', '0', NULL, NULL, NULL, NULL, 1001, '2026-07-03 22:38:54', '2026-07-03 22:39:02', 24, '2026-07-03 22:39:02.422889+08') RETURNING "id" |
| 22:39:02.593 | 5.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (2959, 1001) |
| 22:39:02.476 | 4.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.433 | 4.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20010', 24, '刘人诚通过了这个审批', TRUE, 'HZD-20260703-00001') RETURNING "id" |
| 22:39:02.481 | 4.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_settings' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:39:02.559 | 3.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_erp_ticket_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:39:02.581 | 3.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_erp_ticket_change_log_handlers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:39:02.466 | 2.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=515) |
| 22:39:02.629 | 1.9 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/erp-purchase-gift/verify', '{"id":"24","description":""}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u83b7\u8d60\u5355\u5ba1\u6279\u901a\u8fc7","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\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-03 22:39:02', 220738048) RETURNING "id" |
| 22:39:02.468 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=515 |
| 22:39:02.444 | 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 ('UPDATE', 'app\models\ErpPurchaseGifts', 24, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.473 | 1.2 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\ErpInventoryProducts', 515, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.528 | 1.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=519 |
| 22:39:02.425 | 1.0 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\ErpPurchaseGiftVerifyRels', 55, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '111.194.208.14') |
| 22:39:02.412 | 1.0 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 22:39:02.470 | 0.9 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=515 |
| 22:39:02.601 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (6, 'status', 24, 20010, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u540c\u610f\u4e86","d3":"\u83b7\u8d60\u5355\u7533\u8bf7","d4":""}') |
| 22:39:02.443 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "next_verify_user"=NULL WHERE "id"=24 |
| 22:39:02.472 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=515 |
| 22:39:02.414 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:39:02.499 | 0.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (27, 24, 868, 1, '0', '666', '666', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.553 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (1558, 868, 870, 867, 2231, 969, 989) |
| 22:39:02.509 | 0.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (28, 24, 870, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.423 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_verify_rels" SET "status"=1, "description"='', "verify_at"='now()' WHERE "id"=55 |
| 22:39:02.535 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=31 |
| 22:39:02.504 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='666' WHERE "id"=516 |
| 22:39:02.544 | 0.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (32, 24, 989, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.418 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"='24' |
| 22:39:02.427 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=24 |
| 22:39:02.536 | 0.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (31, 24, 969, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.448 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=26 |
| 22:39:02.531 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=519 |
| 22:39:02.544 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=32 |
| 22:39:02.600 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:39:02.513 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=517 |
| 22:39:02.525 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (30, 24, 2231, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.498 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=27 |
| 22:39:02.411 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 22:39:02.521 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=518 |
| 22:39:02.508 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=28 |
| 22:39:02.554 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_gift_id"=24) AND ("erp_purchase_gift_product_id" NOT IN (26, 27, 28, 29, 30, 31, 32)) |
| 22:39:02.549 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=521 |
| 22:39:02.500 | 0.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\ErpInventoryProducts', 516, 'a:32:{s:2:"id";i:516;s:10:"product_id";i:868;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:666;s:8:"outbound";N;s:9:"inventory";d:666;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:27;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.524 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=30 |
| 22:39:02.519 | 0.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=518) |
| 22:39:02.540 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66' WHERE "id"=520 |
| 22:39:02.428 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:39:02.530 | 0.4 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=519 |
| 22:39:02.517 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_products" ("erp_purchase_gift_product_id", "erp_purchase_gift_id", "product_id", "erp_store_id", "amount", "inventory", "number", "total_amount", "wrote_date", "created_at") VALUES (29, 24, 867, 1, '0', '66', '66', '0', '2026-07-03', 'now()') RETURNING "id" |
| 22:39:02.419 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_verify_rels" WHERE ("status"=0) AND ("erp_purchase_gift_id"=24) ORDER BY "id" |
| 22:39:02.464 | 0.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\ErpInventoryProducts', 515, 'a:32:{s:2:"id";i:515;s:10:"product_id";i:1558;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:26;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.426 | 0.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_verify_rels" WHERE ("status"=0) AND ("erp_purchase_gift_id"=24) ORDER BY "id") "c" |
| 22:39:02.427 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGifts', 24, 'a:1:{s:9:"verify_at";s:5:"now()";}', '', 1001, '111.194.208.14') |
| 22:39:02.545 | 0.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\ErpInventoryProducts', 521, 'a:32:{s:2:"id";i:521;s:10:"product_id";i:989;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:32;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.497 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 515, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.432 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 22:39:02.520 | 0.4 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=518 |
| 22:39:02.523 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 518, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.558 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=24 |
| 22:39:02.516 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=29 |
| 22:39:02.431 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=24 |
| 22:39:02.496 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.600 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:39:02.537 | 0.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\ErpInventoryProducts', 520, 'a:32:{s:2:"id";i:520;s:10:"product_id";i:969;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:31;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.548 | 0.4 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=521 |
| 22:39:02.503 | 0.4 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:39:02.539 | 0.4 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=520 |
| 22:39:02.438 | 0.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\Comments', 221014, 'a:11:{s:2:"id";i:221014;s:9:"object_id";i:24;s:11:"object_type";s:5:"20010";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:1;s:8:"for_user";N;s:12:"description2";s:18:"HZD-20260703-00001";}', '', 1001, '111.194.208.14') |
| 22:39:02.497 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=26 |
| 22:39:02.428 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=24 |
| 22:39:02.539 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=520 |
| 22:39:02.542 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 520, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.543 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=31 |
| 22:39:02.537 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=520 |
| 22:39:02.532 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 519, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.501 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=516 |
| 22:39:02.546 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=521 |
| 22:39:02.533 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 519, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.526 | 0.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\ErpInventoryProducts', 519, 'a:32:{s:2:"id";i:519;s:10:"product_id";i:2231;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:30;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.580 | 0.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\ErpTicketChangeLogs', 2959, 'a:17:{s:2:"id";i:2959;s:9:"serial_no";s:18:"HZD-20260703-00001";s:11:"ticket_type";i:20010;s:10:"wrote_date";s:10:"2026-07-03";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";N;s:8:"abstract";s:12:"的孤独感";s:11:"description";N;s:9:"verify_at";s:29:"2026-07-03 22:39:02.422889+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-03 22:38:54";s:10:"updated_at";s:19:"2026-07-03 22:39:02";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:1:"0";s:9:"object_id";i:24;}', '', 1001, '111.194.208.14') |
| 22:39:02.526 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=519 |
| 22:39:02.507 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='666' WHERE "id"=27 |
| 22:39:02.507 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 27, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.532 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.445 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "erp_purchase_gift_id"=24 |
| 22:39:02.498 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 26, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.549 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 521, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.505 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.506 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.519 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=518 |
| 22:39:02.540 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 520, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.510 | 0.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\ErpInventoryProducts', 517, 'a:32:{s:2:"id";i:517;s:10:"product_id";i:870;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:28;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.524 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 29, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.503 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=516 |
| 22:39:02.464 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=515 |
| 22:39:02.523 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=29 |
| 22:39:02.521 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 518, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.543 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 31, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.534 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 30, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.512 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:39:02.517 | 0.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\ErpInventoryProducts', 518, 'a:32:{s:2:"id";i:518;s:10:"product_id";i:867;s:23:"erp_purchase_inbound_id";N;s:21:"erp_purchase_order_id";N;s:31:"erp_purchase_inbound_product_id";N;s:29:"erp_purchase_order_product_id";N;s:12:"erp_store_id";i:1;s:10:"wrote_date";s:10:"2026-07-03";s:6:"number";d:66;s:8:"outbound";N;s:9:"inventory";d:66;s:6:"amount";s:1:"0";s:12:"total_amount";s:1:"0";s:13:"actual_amount";N;s:19:"actual_total_amount";N;s:8:"is_build";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:13:"lost_outbound";N;s:22:"erp_inventory_start_id";N;s:30:"erp_inventory_start_product_id";N;s:22:"erp_inventory_build_id";N;s:30:"erp_inventory_build_product_id";N;s:20:"build_spent_outbound";N;s:14:"sales_outbound";N;s:20:"erp_purchase_gift_id";i:24;s:28:"erp_purchase_gift_product_id";i:29;s:19:"sales_gift_outbound";N;s:28:"erp_inventory_disassemble_id";N;s:36:"erp_inventory_disassemble_product_id";N;s:26:"disassemble_spent_outbound";N;s:25:"erp_inventory_overflow_id";N;s:33:"erp_inventory_overflow_product_id";N;}', '', 1001, '111.194.208.14') |
| 22:39:02.518 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=518 |
| 22:39:02.510 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517 |
| 22:39:02.533 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.534 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=30 |
| 22:39:02.547 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=521 |
| 22:39:02.550 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.522 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.554 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGifts', 24, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.505 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.551 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 521, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.515 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.429 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_verify_rels" WHERE ("status"=0) AND ("erp_purchase_gift_id"=24) ORDER BY "id" |
| 22:39:02.541 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.541 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.538 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=31 |
| 22:39:02.516 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 28, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.552 | 0.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 ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 32, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.527 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=30 |
| 22:39:02.547 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=521) |
| 22:39:02.511 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=28 |
| 22:39:02.430 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_carbon_copy_rels" WHERE "erp_purchase_gift_id"=24 |
| 22:39:02.547 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=32 |
| 22:39:02.522 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.502 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=27 |
| 22:39:02.513 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:39:02.506 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.515 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=28 |
| 22:39:02.512 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=517 |
| 22:39:02.502 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=516) |
| 22:39:02.514 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:39:02.465 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=26 |
| 22:39:02.551 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=32 |
| 22:39:02.527 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=519) |
| 22:39:02.438 | 0.2 ms | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 22:39:02.550 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.511 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=517) |
| 22:39:02.514 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:39:02.538 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=520) |
| 22:39:02.518 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=29 |