ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a47caa2850ab: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/save-new at 2026-07-03 10:43:46 pm by 111.194.208.14

Performance Profiling

Total processing time: 495 ms; Peak memory: 9.240 MB. Show Profiling Timeline

总计420条数据
TimeDurationCategoryInfo
  
22:43:46.58522.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbounds" ("client_id", "erp_send_type_id", "handler", "project_id", "wrote_date", "serial_no", "abstract", "description", "erp_store_id", "erp_sales_order_id", "created_by", "created_at", "verify_type", "status", "is_resubmitted", "outbound_status") VALUES (3462, NULL, 1001, 4174, '2026-07-03', 'XSCKD-20260703-00001', NULL, NULL, 1, 1711, 1001, 'now()', 2, 1, FALSE, FALSE) RETURNING "id"
22:43:46.66918.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 454, 517, 870, '9', '1200', '10800') RETURNING "id"
22:43:46.86913.3 msyii\db\Command::queryselect 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_inventory_product_spents' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:43:46.63010.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" ("erp_sales_outbound_id", "user_id", "status") VALUES (158, 1001, 0)
22:43:46.7449.6 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundProducts', 456, 'a:17:{s:2:"id";i:456;s:21:"erp_sales_outbound_id";i:158;s:18:"erp_sales_order_id";s:4:"1711";s:26:"erp_sales_order_product_id";s:4:"2263";s:12:"erp_store_id";s:1:"1";s:10:"product_id";s:3:"868";s:11:"description";s:0:"";s:8:"outbound";N;s:6:"number";s:1:"9";s:6:"amount";s:4:"1400";s:12:"total_amount";s:8:"12600.00";s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";}', '', 1001, '111.194.208.14')
22:43:46.6219.1 msyii\db\Command::queryselect 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_sales_outbound_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:43:46.7008.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_products" ("erp_sales_outbound_id", "erp_sales_order_id", "erp_sales_order_product_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description", "hardware_from", "hardware_to", "software_from", "software_to", "maintenance_from", "maintenance_to") VALUES (158, 1711, 2262, 1, 2232, '9', '210375', '1893375.00', '', NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:43:46.6418.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_products" ("erp_sales_outbound_id", "erp_sales_order_id", "erp_sales_order_product_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description", "hardware_from", "hardware_to", "software_from", "software_to", "maintenance_from", "maintenance_to") VALUES (158, 1711, 2261, 1, 870, '9', '1200', '10800.00', '', NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:43:46.8847.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 542, 517, '0', '1200', '9', '10800', '9', '0') RETURNING "id"
22:43:46.7126.6 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundProducts', 455, 'a:17:{s:2:"id";i:455;s:21:"erp_sales_outbound_id";i:158;s:18:"erp_sales_order_id";s:4:"1711";s:26:"erp_sales_order_product_id";s:4:"2262";s:12:"erp_store_id";s:1:"1";s:10:"product_id";s:4:"2232";s:11:"description";s:0:"";s:8:"outbound";N;s:6:"number";s:1:"9";s:6:"amount";s:6:"210375";s:12:"total_amount";s:10:"1893375.00";s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";}', '', 1001, '111.194.208.14')
22:43:46.7706.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 544, 'a:12:{s:2:"id";i:544;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:456;s:24:"erp_inventory_product_id";i:513;s:10:"product_id";s:3:"868";s:11:"description";N;s:6:"number";s:1:"1";s:6:"amount";s:4:"1400";s:12:"total_amount";d:1400;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:46.6915.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 542, 'a:12:{s:2:"id";i:542;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:454;s:24:"erp_inventory_product_id";i:517;s:10:"product_id";s:3:"870";s:11:"description";N;s:6:"number";d:9;s:6:"amount";s:4:"1200";s:12:"total_amount";d:10800;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:46.7795.6 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='868') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.6155.4 msyii\db\Command::querySELECT 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_sales_outbound_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:43:46.7365.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_products" ("erp_sales_outbound_id", "erp_sales_order_id", "erp_sales_order_product_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description", "hardware_from", "hardware_to", "software_from", "software_to", "maintenance_from", "maintenance_to") VALUES (158, 1711, 2263, 1, 868, '9', '1400', '12600.00', '', NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:43:46.7914.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='658' WHERE "id"=516
22:43:46.7274.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 543, 'a:12:{s:2:"id";i:543;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:455;s:24:"erp_inventory_product_id";i:529;s:10:"product_id";s:4:"2232";s:11:"description";N;s:6:"number";d:9;s:6:"amount";s:6:"210375";s:12:"total_amount";d:1893375;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:46.8644.5 msyii\db\Command::querySELECT 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_inventory_product_spents' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:43:46.7193.8 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='2232') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.7563.7 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='868') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.8003.6 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='2232') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.8093.6 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='870') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.6103.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=158)
22:43:46.6633.5 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_projects" "eiops" ON eiops.erp_inventory_overflow_id = eios.id WHERE (eip.inventory > 0) AND ("eip"."product_id"='870') AND ("eip"."erp_store_id"='1') GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC
22:43:46.6512.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundProducts', 454, 'a:17:{s:2:"id";i:454;s:21:"erp_sales_outbound_id";i:158;s:18:"erp_sales_order_id";s:4:"1711";s:26:"erp_sales_order_product_id";s:4:"2261";s:12:"erp_store_id";s:1:"1";s:10:"product_id";s:3:"870";s:11:"description";s:0:"";s:8:"outbound";N;s:6:"number";s:1:"9";s:6:"amount";s:4:"1200";s:12:"total_amount";s:8:"10800.00";s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";}', '', 1001, '111.194.208.14')
22:43:46.5611.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE ("created_at" >= '2026-07-03 00:00:00') AND ("created_at" <= '2026-07-03 23:59:59') AND ("serial_no" ILIKE '%XSCKD-20260703-%') AND (LENGTH(serial_no) = 20) ORDER BY "serial_no" DESC
22:43:46.8281.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.7611.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 456, 513, 868, '1', '1400', '1400') RETURNING "id"
22:43:46.8331.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.9161.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:43:46.9571.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2260
22:43:46.7251.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 455, 529, 2232, '9', '210375', '1893375') RETURNING "id"
22:43:46.8241.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:47.0331.2 msyii\db\Command::queryINSERT 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-sales-outbound/save-new', '{"ErpSalesOutbounds":{"id":"","client_id":"3462","client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","erp_send_type_id":"","handler":"1001","project_id":"4174","wrote_date":"2026-07-03","serial_no":"XSCKD-20260703-00001","erpSalesOutboundVerifyRels":["1001"],"abstract":"","description":"","erp_store_id":"1","erp_store_name":"\u62d3\u5b9e\u4ed3\u5e93","erp_sales_order_id":"1711","erpSalesOutboundProducts":{"new":[{"product_id":"870","number":"9","amount":"1200","total_amount":"10800.00","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2261","erp_store_id":"1","sns":"","is_check":"0","erpSalesOutboundSpentProducts":""},{"product_id":"2232","number":"9","amount":"210375","total_amount":"1893375.00","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2262","erp_store_id":"1","sns":"","is_check":"0","erpSalesOutboundSpentProducts":""},{"product_id":"868","number":"9","amount":"1400","total_amount":"12600.00","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2263","erp_store_id":"1","sns":"","is_check":"0","erpSalesOutboundSpentProducts":""},{"product_id":"2232","number":"7","amount":"210375","total_amount":"1472625.00","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2264","erp_store_id":"1","sns":"","is_check":"0","erpSalesOutboundSpentProducts":""},{"product_id":"870","number":"8","amount":"1200","total_amount":"9600.00","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2265","erp_store_id":"1","sns":"","is_check":"0","erpSalesOutboundSpentProducts":""}]},"files":""}}', '{"code":2000,"result":{"id":158},"status":1,"msg":[{"name":"success","success":"\u65b0\u9500\u552e\u51fa\u5e93\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-03 22:43:47', 486839808) RETURNING "id"
22:43:46.6081.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutbounds', 158, 'a:31:{s:2:"id";i:158;s:9:"serial_no";s:20:"XSCKD-20260703-00001";s:9:"from_date";N;s:10:"wrote_date";s:10:"2026-07-03";s:7:"handler";s:4:"1001";s:18:"erp_sales_order_id";s:4:"1711";s:9:"client_id";s:4:"3462";s:10:"project_id";s:4:"4174";s:12:"erp_store_id";s:1:"1";s:6:"status";i:1;s:16:"erp_send_type_id";s:0:"";s:8:"abstract";N;s:11:"description";N;s:11:"verify_type";s:1:"2";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";b:0;s:6:"number";N;s:6:"amount";N;s:10:"created_by";i:1001;s:16:"stop_description";N;s:15:"outbound_status";b:0;s:9:"is_settle";N;s:7:"is_used";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"print_times";N;s:20:"is_sales_order_ready";N;}', '', 1001, '111.194.208.14')
22:43:46.8251.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.8271.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.8041.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='39' WHERE "id"=529
22:43:46.5651.0 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462')
22:43:46.9590.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:43:47.0290.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 158, 20008, 1001, '2026-07-03 22:43:46', '{"id":158,"serial_no":"XSCKD-20260703-00001","from_date":null,"wrote_date":"2026-07-03","handler":1001,"erp_sales_order_id":1711,"client_id":3462,"project_id":4174,"erp_store_id":1,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"number":"42","amount":"3399000","created_by":1001,"stop_description":null,"outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-07-03 22:43:46","updated_at":"2026-07-03 22:43:46","print_times":null,"is_sales_order_ready":false}', '{"id":158,"serial_no":"XSCKD-20260703-00001","from_date":null,"wrote_date":"2026-07-03","handler":1001,"erp_sales_order_id":1711,"client_id":3462,"project_id":4174,"erp_store_id":1,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"number":"42","amount":"3399000","created_by":1001,"stop_description":null,"outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-07-03 22:43:46","updated_at":"2026-07-03 22:43:46","print_times":null,"is_sales_order_ready":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u51fa\u5e93\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
22:43:46.5500.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
22:43:46.9910.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:43:47.0120.8 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8590.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=24
22:43:46.8160.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_outbounds" SET "amount"='3399000', "number"='42', "next_verify_user"=1001 WHERE "id"=158
22:43:46.5490.7 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:43:46.8190.7 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9610.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2261
22:43:46.5660.7 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174')
22:43:46.9930.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:43:46.5530.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:43:46.9050.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_outbounds" SET "is_used"=FALSE WHERE "id"=158
22:43:46.9620.6 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON r.erp_sales_outbound_id = t.id WHERE ("r"."erp_sales_order_product_id"=2261) AND ("t"."status" IN (2, 5, 1))
22:43:46.9730.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2263
22:43:46.8060.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 457, 529, 2232, '7', '210375', '1472625') RETURNING "id"
22:43:46.5700.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2261
22:43:46.6670.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='57' WHERE "id"=517
22:43:46.9540.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_return_products" WHERE "erp_sales_outbound_spent_product_id" IN (542, 543, 544, 545, 546, 547)
22:43:46.9500.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"='1711'
22:43:46.7970.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 456, 516, 868, '8', '1400', '11200') RETURNING "id"
22:43:46.9510.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711
22:43:46.5710.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2261
22:43:46.9790.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2264
22:43:46.9850.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2265
22:43:46.9670.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2262
22:43:46.7980.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_products" ("erp_sales_outbound_id", "erp_sales_order_id", "erp_sales_order_product_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description", "hardware_from", "hardware_to", "software_from", "software_to", "maintenance_from", "maintenance_to") VALUES (158, 1711, 2264, 1, 2232, '7', '210375', '1472625.00', '', NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:43:46.9680.5 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON r.erp_sales_outbound_id = t.id WHERE ("r"."erp_sales_order_product_id"=2262) AND ("t"."status" IN (2, 5, 1))
22:43:46.8940.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 543, 529, '0', '210375', '9', '1893375', '9', '0') RETURNING "id"
22:43:46.8330.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=23
22:43:46.9740.5 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON r.erp_sales_outbound_id = t.id WHERE ("r"."erp_sales_order_product_id"=2263) AND ("t"."status" IN (2, 5, 1))
22:43:46.5710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=870
22:43:46.9060.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (870, 2232, 868, 868, 2232, 870)
22:43:46.5800.5 msyii\db\Command::querySELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='870') AND ("erp_store_id"='1')
22:43:46.6140.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=158
22:43:46.8070.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_products" ("erp_sales_outbound_id", "erp_sales_order_id", "erp_sales_order_product_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description", "hardware_from", "hardware_to", "software_from", "software_to", "maintenance_from", "maintenance_to") VALUES (158, 1711, 2265, 1, 870, '8', '1200', '9600.00', '', NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:43:46.9860.5 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON r.erp_sales_outbound_id = t.id WHERE ("r"."erp_sales_order_product_id"=2265) AND ("t"."status" IN (2, 5, 1))
22:43:46.8130.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='49' WHERE "id"=517
22:43:46.8540.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='66', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=517
22:43:46.9140.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='49', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='17', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=28
22:43:46.6680.5 msyii\db\Command::executeINSERT 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:1:{s:9:"inventory";d:57;}', '', 1001, '111.194.208.14')
22:43:46.9800.5 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_erp_sales_outbound_products" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON r.erp_sales_outbound_id = t.id WHERE ("r"."erp_sales_order_product_id"=2264) AND ("t"."status" IN (2, 5, 1))
22:43:46.8380.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='666', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=516
22:43:46.8460.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='55', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=529
22:43:46.8140.5 msyii\db\Command::executeINSERT 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:1:{s:9:"inventory";d:49;}', '', 1001, '111.194.208.14')
22:43:46.8980.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 545, 516, '0', '1400', '8', '11200', '8', '0') RETURNING "id"
22:43:46.8140.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_spent_products" ("erp_sales_outbound_id", "erp_sales_outbound_product_id", "erp_inventory_product_id", "product_id", "number", "amount", "total_amount") VALUES (158, 458, 517, 870, '8', '1200', '9600') RETURNING "id"
22:43:46.5680.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"='1711')
22:43:46.8610.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_id"=158
22:43:46.9010.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 546, 529, '0', '210375', '7', '1472625', '7', '0') RETURNING "id"
22:43:46.8960.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 544, 513, '0', '1400', '1', '1400', '1', '0') RETURNING "id"
22:43:46.9650.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2261
22:43:47.0020.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24
22:43:46.8220.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0', "inventory"='1', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=513
22:43:46.9030.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_spents" ("erp_sales_outbound_id", "wrote_date", "erp_sales_outbound_spent_product_id", "erp_inventory_product_id", "actual_amount", "amount", "outbound", "total_amount", "sales_outbound", "actual_total_amount") VALUES (158, '2026-07-03', 547, 517, '0', '1200', '8', '9600', '8', '0') RETURNING "id"
22:43:46.9940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (517, 529, 513, 516)
22:43:46.9370.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=23
22:43:46.8830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517
22:43:46.9150.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24
22:43:46.5640.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "serial_no"='XSCKD-20260703-00001')
22:43:46.9270.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=25
22:43:46.8620.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id" IN (454, 455, 456, 457, 458)
22:43:46.9330.4 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9900.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "is_used"=TRUE WHERE "id"=1711
22:43:47.0010.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='49', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=28
22:43:46.7240.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:1:{s:9:"inventory";d:46;}', '', 1001, '111.194.208.14')
22:43:46.8180.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (517, 529, 513, 516)
22:43:46.9980.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='49', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=517
22:43:46.8160.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id"
22:43:46.9230.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='16', "inventory"='39', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='16', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=529
22:43:46.9470.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24
22:43:47.0140.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=513
22:43:46.9360.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='0', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='1', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=25
22:43:46.9520.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2260, 2261, 2262, 2263, 2264, 2265)
22:43:46.9100.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='17', "inventory"='49', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='17', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=517
22:43:46.5770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2265
22:43:46.7240.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='46' WHERE "id"=529
22:43:46.9330.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='1', "inventory"='0', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='1', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=513
22:43:47.0260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:43:47.0280.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:43:46.5650.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001')
22:43:47.0080.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='39', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=40
22:43:46.8930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529
22:43:47.0210.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='658', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=516
22:43:46.9260.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='39', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='16', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=40
22:43:46.5770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=870
22:43:46.5680.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
22:43:46.9460.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='658', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='8', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=27
22:43:46.9750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=544
22:43:47.0050.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='39', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=529
22:43:46.8630.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=542
22:43:46.8220.4 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25
22:43:46.8200.4 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9770.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2263
22:43:46.9690.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=543
22:43:46.9710.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2262
22:43:46.9810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=546
22:43:46.7600.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=513
22:43:46.8920.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=543
22:43:46.9760.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=545
22:43:46.9540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id" IN (454, 455, 456, 457, 458)
22:43:46.9880.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2265
22:43:46.8940.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 741, 'a:30:{s:2:"id";i:741;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:529;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:9;s:6:"amount";s:6:"210375";s:12:"total_amount";d:1893375;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:9;s:35:"erp_sales_outbound_spent_product_id";i:543;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:46.8430.4 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9000.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=546
22:43:46.9630.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=542
22:43:46.9430.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='8', "inventory"='658', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='8', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=516
22:43:46.9300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=513
22:43:47.0170.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=23
22:43:46.8970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=545
22:43:46.9870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=547
22:43:46.9830.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2264
22:43:46.5820.3 msyii\db\Command::querySELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='2232') AND ("erp_store_id"='1')
22:43:46.8950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=544
22:43:46.8230.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 513, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=158
22:43:46.8920.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 740, 'a:30:{s:2:"id";i:740;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:517;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:9;s:6:"amount";s:4:"1200";s:12:"total_amount";d:10800;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:9;s:35:"erp_sales_outbound_spent_product_id";i:542;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:46.9020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=547
22:43:46.9320.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8610.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=158
22:43:46.8520.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9340.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 513, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:47.0090.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=25
22:43:46.9220.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.8430.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:47.0250.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24
22:43:46.9530.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=158
22:43:46.8410.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27
22:43:46.7960.3 msyii\db\Command::executeINSERT 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:1:{s:9:"inventory";d:658;}', '', 1001, '111.194.208.14')
22:43:46.9380.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:43:47.0260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id"
22:43:46.5830.3 msyii\db\Command::querySELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='868') AND ("erp_store_id"='1')
22:43:46.7600.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 513, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8310.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='1', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=25
22:43:47.0170.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='0', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=25
22:43:46.8070.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 546, 'a:12:{s:2:"id";i:546;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:457;s:24:"erp_inventory_product_id";i:529;s:10:"product_id";s:4:"2232";s:11:"description";N;s:6:"number";d:7;s:6:"amount";s:6:"210375";s:12:"total_amount";d:1472625;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:46.9310.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9070.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9710.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2262, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.8600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=158
22:43:46.8530.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.5690.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:46.9550.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2260
22:43:46.9950.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8520.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8210.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517
22:43:46.9080.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:47.0240.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='658', "lost_outbound"='0', "build_spent_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=27
22:43:46.8490.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='55', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=40
22:43:46.8530.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.5810.3 msyii\db\Command::querySELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='870'
22:43:46.8210.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9400.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 513, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=513
22:43:46.9640.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12145
22:43:46.8200.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.5730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2262
22:43:46.7980.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 545, 'a:12:{s:2:"id";i:545;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:456;s:24:"erp_inventory_product_id";i:516;s:10:"product_id";s:3:"868";s:11:"description";N;s:6:"number";d:8;s:6:"amount";s:4:"1400";s:12:"total_amount";d:11200;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:46.5740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2263
22:43:46.8500.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=25
22:43:47.0110.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9200.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9210.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9440.3 msyii\db\Command::executeINSERT 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:3:{s:8:"outbound";s:1:"8";s:9:"inventory";d:658;s:14:"sales_outbound";s:1:"8";}', '', 1001, '111.194.208.14')
22:43:46.5750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2264
22:43:46.5760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2265
22:43:46.9970.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8360.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.8510.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517
22:43:47.0270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id"
22:43:46.9240.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:3:{s:8:"outbound";s:2:"16";s:9:"inventory";d:39;s:14:"sales_outbound";s:2:"16";}', '', 1001, '111.194.208.14')
22:43:47.0030.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:47.0300.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643158, 'a:13:{s:2:"id";i:643158;s:9:"object_id";i:158;s:11:"object_type";i:20008;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:652:"{"id":158,"serial_no":"XSCKD-20260703-00001","from_date":null,"wrote_date":"2026-07-03","handler":1001,"erp_sales_order_id":1711,"client_id":3462,"project_id":4174,"erp_store_id":1,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"number":"42","amount":"3399000","created_by":1001,"stop_description":null,"outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-07-03 22:43:46","updated_at":"2026-07-03 22:43:46","print_times":null,"is_sales_order_ready":false}";s:9:"new_value";s:652:"{"id":158,"serial_no":"XSCKD-20260703-00001","from_date":null,"wrote_date":"2026-07-03","handler":1001,"erp_sales_order_id":1711,"client_id":3462,"project_id":4174,"erp_store_id":1,"status":1,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"number":"42","amount":"3399000","created_by":1001,"stop_description":null,"outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-07-03 22:43:46","updated_at":"2026-07-03 22:43:46","print_times":null,"is_sales_order_ready":false}";s:11:"description";s:111:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u51fa\u5e93\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-03 22:43:46";s:9:"is_delete";N;}', '', 1001, '111.194.208.14')
22:43:46.5780.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:46.8970.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 742, 'a:30:{s:2:"id";i:742;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:513;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:1;s:6:"amount";s:4:"1400";s:12:"total_amount";d:1400;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:1;s:35:"erp_sales_outbound_spent_product_id";i:544;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:46.9040.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 745, 'a:30:{s:2:"id";i:745;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:517;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:8;s:6:"amount";s:4:"1200";s:12:"total_amount";d:9600;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:8;s:35:"erp_sales_outbound_spent_product_id";i:547;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:46.9590.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2261, 'a:1:{s:8:"outbound";s:1:"0";}', '', 1001, '111.194.208.14')
22:43:46.5730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232
22:43:46.8980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=516
22:43:46.9210.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9300.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8450.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9690.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=455
22:43:46.9290.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8370.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9020.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 744, 'a:30:{s:2:"id";i:744;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:529;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:7;s:6:"amount";s:6:"210375";s:12:"total_amount";d:1472625;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:7;s:35:"erp_sales_outbound_spent_product_id";i:546;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:46.9490.3 msyii\db\Command::executeINSERT 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:43:46.9630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=454
22:43:46.9000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529
22:43:46.9100.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9190.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529
22:43:46.9430.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9970.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8410.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='666', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=27
22:43:46.9190.3 msyii\db\Command::executeINSERT 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:43:47.0040.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.8570.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='66', "lost_outbound"='0', "build_spent_outbound"='0', "sales_outbound"='0', "sales_gift_outbound"='0', "disassemble_spent_outbound"='0' WHERE "id"=28
22:43:46.9960.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.5720.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2262
22:43:46.8390.3 msyii\db\Command::executeINSERT 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:1:{s:9:"inventory";s:3:"658";}', '', 1001, '111.194.208.14')
22:43:46.9320.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9400.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9910.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:47.0120.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8050.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:1:{s:9:"inventory";d:39;}', '', 1001, '111.194.208.14')
22:43:46.8490.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 40, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25
22:43:46.7990.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundProducts', 457, 'a:17:{s:2:"id";i:457;s:21:"erp_sales_outbound_id";i:158;s:18:"erp_sales_order_id";s:4:"1711";s:26:"erp_sales_order_product_id";s:4:"2264";s:12:"erp_store_id";s:1:"1";s:10:"product_id";s:4:"2232";s:11:"description";s:0:"";s:8:"outbound";N;s:6:"number";s:1:"7";s:6:"amount";s:6:"210375";s:12:"total_amount";s:10:"1472625.00";s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";}', '', 1001, '111.194.208.14')
22:43:46.8320.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 25, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8350.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.8450.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9080.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9400.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=516
22:43:47.0190.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:47.0200.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:47.0220.3 msyii\db\Command::executeINSERT 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:43:46.9090.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9470.3 msyii\db\Command::executeINSERT 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:2:{s:9:"inventory";d:658;s:14:"sales_outbound";s:1:"8";}', '', 1001, '111.194.208.14')
22:43:46.9660.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2261, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.9950.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.9090.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8570.3 msyii\db\Command::executeINSERT 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:43:46.9310.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.8370.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9720.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2263
22:43:46.9840.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2264, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.5740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=868
22:43:47.0170.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 25, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9790.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='7' WHERE "id"=2264
22:43:47.0050.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9110.3 msyii\db\Command::executeINSERT 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:3:{s:8:"outbound";s:2:"17";s:9:"inventory";d:49;s:14:"sales_outbound";s:2:"17";}', '', 1001, '111.194.208.14')
22:43:46.9150.3 msyii\db\Command::executeINSERT 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:2:{s:9:"inventory";d:49;s:14:"sales_outbound";s:2:"17";}', '', 1001, '111.194.208.14')
22:43:46.9770.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12147
22:43:46.9830.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12148, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.5760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2264
22:43:46.8420.3 msyii\db\Command::executeINSERT 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:43:46.9410.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9420.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.8150.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundSpentProducts', 547, 'a:12:{s:2:"id";i:547;s:21:"erp_sales_outbound_id";i:158;s:29:"erp_sales_outbound_product_id";i:458;s:24:"erp_inventory_product_id";i:517;s:10:"product_id";s:3:"870";s:11:"description";N;s:6:"number";d:8;s:6:"amount";s:4:"1200";s:12:"total_amount";d:9600;s:13:"cancel_number";N;s:13:"cancel_amount";N;s:19:"cancel_total_amount";N;}', '', 1001, '111.194.208.14')
22:43:47.0100.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:46.9650.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12145, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.8170.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOutbounds', 158, 'a:2:{s:6:"number";d:42;s:6:"amount";d:3399000;}', '', 1001, '111.194.208.14')
22:43:46.9370.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 25, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9670.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2262, 'a:1:{s:8:"outbound";s:1:"0";}', '', 1001, '111.194.208.14')
22:43:46.9740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=456
22:43:47.0180.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.8440.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9200.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9410.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9880.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12149
22:43:46.9420.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:47.0130.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:47.0250.3 msyii\db\Command::executeINSERT 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:43:46.9220.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=457
22:43:46.9890.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2265, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.9560.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2260, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9960.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8360.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27
22:43:47.0010.3 msyii\db\Command::executeINSERT 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:43:46.8510.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:43:46.8990.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSpents', 743, 'a:30:{s:2:"id";i:743;s:21:"erp_purchase_order_id";N;s:23:"erp_purchase_inbound_id";N;s:24:"erp_inventory_product_id";i:516;s:10:"wrote_date";s:10:"2026-07-03";s:13:"actual_amount";s:1:"0";s:19:"actual_total_amount";s:1:"0";s:8:"outbound";d:8;s:6:"amount";s:4:"1400";s:12:"total_amount";d:11200;s:13:"lost_outbound";N;s:29:"erp_inventory_lost_product_id";N;s:21:"erp_inventory_lost_id";N;s:22:"erp_inventory_start_id";N;s:22:"erp_inventory_build_id";N;s:20:"build_spent_outbound";N;s:36:"erp_inventory_build_spent_product_id";N;s:28:"erp_inventory_build_spent_id";N;s:14:"sales_outbound";d:8;s:35:"erp_sales_outbound_spent_product_id";i:545;s:21:"erp_sales_outbound_id";i:158;s:20:"erp_purchase_gift_id";N;s:19:"sales_gift_outbound";N;s:31:"erp_sales_gift_spent_product_id";N;s:17:"erp_sales_gift_id";N;s:28:"erp_inventory_disassemble_id";N;s:26:"disassemble_spent_outbound";N;s:42:"erp_inventory_disassemble_spent_product_id";N;s:34:"erp_inventory_disassemble_spent_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:43:47.0030.3 msyii\db\Command::querySELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:47.0110.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513
22:43:47.0200.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:47.0040.3 msyii\db\Command::querySELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.5820.3 msyii\db\Command::querySELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
22:43:46.8360.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.9050.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOutbounds', 158, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9270.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 40, 'a:2:{s:9:"inventory";d:39;s:14:"sales_outbound";s:2:"16";}', '', 1001, '111.194.208.14')
22:43:46.9780.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2263, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:47.0040.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:47.0190.3 msyii\db\Command::querySELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.8440.3 msyii\db\Command::querySELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529
22:43:46.9580.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2261
22:43:46.9700.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12146
22:43:46.9860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=458
22:43:46.5740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2263
22:43:46.8080.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOutboundProducts', 458, 'a:17:{s:2:"id";i:458;s:21:"erp_sales_outbound_id";i:158;s:18:"erp_sales_order_id";s:4:"1711";s:26:"erp_sales_order_product_id";s:4:"2265";s:12:"erp_store_id";s:1:"1";s:10:"product_id";s:3:"870";s:11:"description";s:0:"";s:8:"outbound";N;s:6:"number";s:1:"8";s:6:"amount";s:4:"1200";s:12:"total_amount";s:7:"9600.00";s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";}', '', 1001, '111.194.208.14')
22:43:47.0200.3 msyii\db\Command::querySELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:43:46.5780.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:47.0240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27
22:43:46.5800.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:46.8540.3 msyii\db\Command::executeINSERT 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:1:{s:9:"inventory";s:2:"49";}', '', 1001, '111.194.208.14')
22:43:46.9180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:43:47.0090.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 40, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28
22:43:46.9700.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12146, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:46.9900.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:1:{s:7:"is_used";b:1;}', '', 1001, '111.194.208.14')
22:43:46.5750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232
22:43:46.9260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40
22:43:46.8460.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:1:{s:9:"inventory";s:2:"39";}', '', 1001, '111.194.208.14')
22:43:46.9770.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12147, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:47.0080.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40
22:43:46.9720.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2263, 'a:1:{s:8:"outbound";s:1:"0";}', '', 1001, '111.194.208.14')
22:43:46.9880.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12149, 'a:2:{s:4:"cost";d:0;s:10:"total_cost";i:0;}', '', 1001, '111.194.208.14')
22:43:47.0000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28
22:43:47.0140.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 513, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.9980.3 msyii\db\Command::executeINSERT 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:43:47.0060.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:0:{}', '', 1001, '111.194.208.14')
22:43:46.8420.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=24
22:43:46.9660.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2262
22:43:46.9820.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12148
22:43:46.9790.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2264, 'a:1:{s:8:"outbound";s:1:"0";}', '', 1001, '111.194.208.14')
22:43:46.9840.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2265, 'a:1:{s:8:"outbound";s:1:"0";}', '', 1001, '111.194.208.14')
22:43:46.5670.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1')
22:43:46.9840.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='8' WHERE "id"=2265
22:43:46.8550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:47.0160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25
22:43:46.8560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28
22:43:46.5790.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:46.9290.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:43:46.8470.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40
22:43:46.9250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.5790.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE))
22:43:46.8390.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:47.0150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.9130.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.9160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.8600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.9380.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.9990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.9280.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:43:46.9390.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:43:47.0070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.9480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:43:46.5840.2 msyii\db\Command::querySELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='868'
22:43:47.0220.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9490.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:43:47.0160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.8470.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.9280.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:47.0100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.9450.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.8560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.9130.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.5830.2 msyii\db\Command::querySELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='2232'
22:43:46.9340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9240.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:47.0020.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.8560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:47.0060.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.9440.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1
22:43:46.5830.2 msyii\db\Command::querySELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
22:43:47.0180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:47.0250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.8420.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.8500.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1
22:43:46.8400.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.9120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:47.0000.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:47.0230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.9990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:47.0150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.9250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.9450.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:47.0220.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.8390.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.8550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1
22:43:46.5840.2 msyii\db\Command::querySELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
22:43:46.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.9450.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.9350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.9990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:46.8400.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:47.0150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:47.0230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:47.0070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1
22:43:47.0070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1
22:43:46.9360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1