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
Database Queries
总计419条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 22:43:46.550 | 0.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 22:43:46.553 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:43:46.561 | 1.8 ms | SELECT | SELECT * 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.564 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "serial_no"='XSCKD-20260703-00001') |
| 22:43:46.565 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001') |
| 22:43:46.565 | 1.0 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462') |
| 22:43:46.566 | 0.7 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174') |
| 22:43:46.567 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1') |
| 22:43:46.568 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 22:43:46.568 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"='1711') |
| 22:43:46.569 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.570 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2261 |
| 22:43:46.571 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=870 |
| 22:43:46.571 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2261 |
| 22:43:46.572 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2262 |
| 22:43:46.573 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232 |
| 22:43:46.573 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2262 |
| 22:43:46.574 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2263 |
| 22:43:46.574 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=868 |
| 22:43:46.574 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2263 |
| 22:43:46.575 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2264 |
| 22:43:46.575 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232 |
| 22:43:46.576 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2264 |
| 22:43:46.576 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2265 |
| 22:43:46.577 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=870 |
| 22:43:46.577 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2265 |
| 22:43:46.578 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.578 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.579 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.579 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.580 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE ("id"='1') AND ("is_delete"=FALSE)) |
| 22:43:46.580 | 0.5 ms | SELECT | SELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='870') AND ("erp_store_id"='1') |
| 22:43:46.581 | 0.3 ms | SELECT | SELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='870' |
| 22:43:46.582 | 0.3 ms | SELECT | SELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1' |
| 22:43:46.582 | 0.3 ms | SELECT | SELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='2232') AND ("erp_store_id"='1') |
| 22:43:46.583 | 0.2 ms | SELECT | SELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='2232' |
| 22:43:46.583 | 0.2 ms | SELECT | SELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1' |
| 22:43:46.583 | 0.3 ms | SELECT | SELECT sum(inventory) as inventory FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE ("product_id"='868') AND ("erp_store_id"='1') |
| 22:43:46.584 | 0.2 ms | SELECT | SELECT "name" FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 22:43:46.584 | 0.2 ms | SELECT | SELECT "title" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1' |
| 22:43:46.585 | 22.1 ms | INSERT | INSERT 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.608 | 1.1 ms | INSERT | INSERT 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.610 | 3.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=158) |
| 22:43:46.614 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=158 |
| 22:43:46.615 | 5.4 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_sales_outbound_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:43:46.621 | 9.1 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_sales_outbound_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:43:46.630 | 10.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" ("erp_sales_outbound_id", "user_id", "status") VALUES (158, 1001, 0) |
| 22:43:46.641 | 8.1 ms | INSERT | INSERT 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.651 | 2.3 ms | INSERT | INSERT 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.663 | 3.5 ms | SELECT | SELECT 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.667 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='57' WHERE "id"=517 |
| 22:43:46.668 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:1:{s:9:"inventory";d:57;}', '', 1001, '111.194.208.14') |
| 22:43:46.669 | 18.1 ms | INSERT | INSERT 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.691 | 5.7 ms | INSERT | INSERT 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.700 | 8.5 ms | INSERT | INSERT 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.712 | 6.6 ms | INSERT | INSERT 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.719 | 3.8 ms | SELECT | SELECT 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.724 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='46' WHERE "id"=529 |
| 22:43:46.724 | 0.4 ms | INSERT | INSERT 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.725 | 1.3 ms | INSERT | INSERT 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.727 | 4.8 ms | INSERT | INSERT 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.736 | 5.1 ms | INSERT | INSERT 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.744 | 9.6 ms | INSERT | INSERT 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.756 | 3.7 ms | SELECT | SELECT 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.760 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=513 |
| 22:43:46.760 | 0.3 ms | INSERT | INSERT 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.761 | 1.7 ms | INSERT | INSERT 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.770 | 6.0 ms | INSERT | INSERT 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.779 | 5.6 ms | SELECT | SELECT 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.791 | 4.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='658' WHERE "id"=516 |
| 22:43:46.796 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:1:{s:9:"inventory";d:658;}', '', 1001, '111.194.208.14') |
| 22:43:46.797 | 0.6 ms | INSERT | INSERT 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.798 | 0.3 ms | INSERT | INSERT 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.798 | 0.5 ms | INSERT | INSERT 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.799 | 0.3 ms | INSERT | INSERT 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.800 | 3.6 ms | SELECT | SELECT 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.804 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='39' WHERE "id"=529 |
| 22:43:46.805 | 0.3 ms | INSERT | INSERT 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.806 | 0.6 ms | INSERT | INSERT 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.807 | 0.3 ms | INSERT | INSERT 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.807 | 0.5 ms | INSERT | INSERT 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.808 | 0.3 ms | INSERT | INSERT 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:46.809 | 3.6 ms | SELECT | SELECT 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.813 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='49' WHERE "id"=517 |
| 22:43:46.814 | 0.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:1:{s:9:"inventory";d:49;}', '', 1001, '111.194.208.14') |
| 22:43:46.814 | 0.5 ms | INSERT | INSERT 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.815 | 0.3 ms | INSERT | INSERT 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:46.816 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id" |
| 22:43:46.816 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_outbounds" SET "amount"='3399000', "number"='42', "next_verify_user"=1001 WHERE "id"=158 |
| 22:43:46.817 | 0.3 ms | INSERT | INSERT 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.818 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (517, 529, 513, 516) |
| 22:43:46.819 | 0.7 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.820 | 0.4 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.820 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.821 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.821 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.822 | 0.4 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.822 | 0.5 ms | UPDATE | UPDATE "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.823 | 0.3 ms | INSERT | INSERT 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.824 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.825 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.827 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.828 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.830 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25 |
| 22:43:46.831 | 0.3 ms | UPDATE | UPDATE "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:46.832 | 0.3 ms | INSERT | INSERT 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.833 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=23 |
| 22:43:46.833 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.835 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.836 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.836 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.836 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.837 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.837 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.838 | 0.5 ms | UPDATE | UPDATE "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.839 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:1:{s:9:"inventory";s:3:"658";}', '', 1001, '111.194.208.14') |
| 22:43:46.839 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.839 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.840 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.840 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.841 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27 |
| 22:43:46.841 | 0.3 ms | UPDATE | UPDATE "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.842 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 27, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:46.842 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=24 |
| 22:43:46.842 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.843 | 0.4 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.843 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.844 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.844 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.845 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.845 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.846 | 0.5 ms | UPDATE | UPDATE "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.846 | 0.3 ms | INSERT | INSERT 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.847 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.847 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.848 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.848 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.848 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40 |
| 22:43:46.849 | 0.3 ms | UPDATE | UPDATE "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.849 | 0.3 ms | INSERT | INSERT 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.850 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=25 |
| 22:43:46.850 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.851 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.851 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.852 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.852 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.853 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.853 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.854 | 0.5 ms | UPDATE | UPDATE "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.854 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:1:{s:9:"inventory";s:2:"49";}', '', 1001, '111.194.208.14') |
| 22:43:46.855 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.855 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.856 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.856 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.856 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28 |
| 22:43:46.857 | 0.3 ms | UPDATE | UPDATE "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.857 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 28, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:46.859 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=FALSE WHERE "id"=24 |
| 22:43:46.860 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.860 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=158 |
| 22:43:46.861 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_id"=158 |
| 22:43:46.861 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=158 |
| 22:43:46.862 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id" IN (454, 455, 456, 457, 458) |
| 22:43:46.863 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=158 |
| 22:43:46.863 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=542 |
| 22:43:46.864 | 4.5 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_inventory_product_spents' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 22:43:46.869 | 13.3 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_inventory_product_spents' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 22:43:46.883 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517 |
| 22:43:46.884 | 7.8 ms | INSERT | INSERT 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.892 | 0.3 ms | INSERT | INSERT 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.892 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=543 |
| 22:43:46.893 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529 |
| 22:43:46.894 | 0.5 ms | INSERT | INSERT 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.894 | 0.4 ms | INSERT | INSERT 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.895 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=544 |
| 22:43:46.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=513 |
| 22:43:46.896 | 0.5 ms | INSERT | INSERT 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.897 | 0.3 ms | INSERT | INSERT 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.897 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=545 |
| 22:43:46.898 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=516 |
| 22:43:46.898 | 0.5 ms | INSERT | INSERT 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.899 | 0.3 ms | INSERT | INSERT 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:46.900 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=546 |
| 22:43:46.900 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529 |
| 22:43:46.901 | 0.5 ms | INSERT | INSERT 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.902 | 0.3 ms | INSERT | INSERT 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.902 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=547 |
| 22:43:46.903 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517 |
| 22:43:46.903 | 0.5 ms | INSERT | INSERT 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.904 | 0.3 ms | INSERT | INSERT 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.905 | 0.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_outbounds" SET "is_used"=FALSE WHERE "id"=158 |
| 22:43:46.905 | 0.3 ms | INSERT | INSERT 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.906 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (870, 2232, 868, 868, 2232, 870) |
| 22:43:46.907 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=517 |
| 22:43:46.907 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.908 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.908 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.909 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.909 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.910 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.910 | 0.4 ms | UPDATE | UPDATE "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.911 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a: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.912 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.912 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.913 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.913 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.913 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28 |
| 22:43:46.914 | 0.5 ms | UPDATE | UPDATE "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.915 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 28, 'a:2:{s:9:"inventory";d:49;s:14:"sales_outbound";s:2:"17";}', '', 1001, '111.194.208.14') |
| 22:43:46.915 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24 |
| 22:43:46.916 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.916 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:43:46.918 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:43:46.919 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:46.919 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=529 |
| 22:43:46.920 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.920 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.921 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.921 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.922 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.922 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:46.923 | 0.4 ms | UPDATE | UPDATE "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.924 | 0.3 ms | INSERT | INSERT 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:46.924 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.925 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.925 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.925 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.926 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40 |
| 22:43:46.926 | 0.4 ms | UPDATE | UPDATE "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.927 | 0.3 ms | INSERT | INSERT 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.927 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=25 |
| 22:43:46.928 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.928 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:43:46.929 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:43:46.929 | 0.3 ms | INSERT | INSERT 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.930 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=513 |
| 22:43:46.930 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.931 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.931 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.932 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.932 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.933 | 0.4 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:46.933 | 0.4 ms | UPDATE | UPDATE "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:46.934 | 0.3 ms | INSERT | INSERT 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.934 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.935 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.935 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.936 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.936 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25 |
| 22:43:46.936 | 0.4 ms | UPDATE | UPDATE "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.937 | 0.3 ms | INSERT | INSERT 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.937 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=23 |
| 22:43:46.938 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.938 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:43:46.939 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:43:46.940 | 0.3 ms | INSERT | INSERT 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.940 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=516 |
| 22:43:46.940 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.941 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.941 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.942 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.942 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.943 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:46.943 | 0.3 ms | UPDATE | UPDATE "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.944 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a: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.944 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.945 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.945 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:46.945 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:46.946 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27 |
| 22:43:46.946 | 0.4 ms | UPDATE | UPDATE "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.947 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 27, 'a:2:{s:9:"inventory";d:658;s:14:"sales_outbound";s:1:"8";}', '', 1001, '111.194.208.14') |
| 22:43:46.947 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24 |
| 22:43:46.948 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:46.948 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:43:46.949 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:43:46.949 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:46.950 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"='1711' |
| 22:43:46.951 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711 |
| 22:43:46.952 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2260, 2261, 2262, 2263, 2264, 2265) |
| 22:43:46.953 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=158 |
| 22:43:46.954 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id" IN (454, 455, 456, 457, 458) |
| 22:43:46.954 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_return_products" WHERE "erp_sales_outbound_spent_product_id" IN (542, 543, 544, 545, 546, 547) |
| 22:43:46.955 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2260 |
| 22:43:46.956 | 0.3 ms | INSERT | INSERT 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.957 | 1.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2260 |
| 22:43:46.958 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2261 |
| 22:43:46.959 | 0.3 ms | INSERT | INSERT 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.959 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486 |
| 22:43:46.961 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2261 |
| 22:43:46.962 | 0.6 ms | SELECT | SELECT "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.963 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=454 |
| 22:43:46.963 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=542 |
| 22:43:46.964 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12145 |
| 22:43:46.965 | 0.3 ms | INSERT | INSERT 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.965 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2261 |
| 22:43:46.966 | 0.3 ms | INSERT | INSERT 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.966 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2262 |
| 22:43:46.967 | 0.3 ms | INSERT | INSERT 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.967 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2262 |
| 22:43:46.968 | 0.5 ms | SELECT | SELECT "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.969 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=455 |
| 22:43:46.969 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=543 |
| 22:43:46.970 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12146 |
| 22:43:46.970 | 0.3 ms | INSERT | INSERT 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.971 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2262 |
| 22:43:46.971 | 0.3 ms | INSERT | INSERT 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.972 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='9' WHERE "id"=2263 |
| 22:43:46.972 | 0.3 ms | INSERT | INSERT 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.973 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2263 |
| 22:43:46.974 | 0.5 ms | SELECT | SELECT "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.974 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=456 |
| 22:43:46.975 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=544 |
| 22:43:46.976 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=545 |
| 22:43:46.977 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12147 |
| 22:43:46.977 | 0.3 ms | INSERT | INSERT 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:46.977 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2263 |
| 22:43:46.978 | 0.3 ms | INSERT | INSERT 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:46.979 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='7' WHERE "id"=2264 |
| 22:43:46.979 | 0.3 ms | INSERT | INSERT 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.979 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2264 |
| 22:43:46.980 | 0.5 ms | SELECT | SELECT "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.981 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=457 |
| 22:43:46.981 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=546 |
| 22:43:46.982 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12148 |
| 22:43:46.983 | 0.3 ms | INSERT | INSERT 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.983 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2264 |
| 22:43:46.984 | 0.3 ms | INSERT | INSERT 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.984 | 0.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='8' WHERE "id"=2265 |
| 22:43:46.984 | 0.3 ms | INSERT | INSERT 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.985 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "erp_sales_order_product_id"=2265 |
| 22:43:46.986 | 0.5 ms | SELECT | SELECT "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.986 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=458 |
| 22:43:46.987 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=547 |
| 22:43:46.988 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"='0', "total_cost"='0' WHERE "id"=12149 |
| 22:43:46.988 | 0.3 ms | INSERT | INSERT 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:46.988 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "cost"='0', "total_cost"='0' WHERE "id"=2265 |
| 22:43:46.989 | 0.3 ms | INSERT | INSERT 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.990 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "is_used"=TRUE WHERE "id"=1711 |
| 22:43:46.990 | 0.3 ms | INSERT | INSERT 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.991 | 0.3 ms | INSERT | INSERT 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:46.991 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462 |
| 22:43:46.993 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174 |
| 22:43:46.994 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (517, 529, 513, 516) |
| 22:43:46.995 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.995 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.996 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.996 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.997 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.997 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:43:46.998 | 0.4 ms | UPDATE | UPDATE "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.998 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 517, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:46.999 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:46.999 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:46.999 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:47.000 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:47.000 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28 |
| 22:43:47.001 | 0.4 ms | UPDATE | UPDATE "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:47.001 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 28, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:47.002 | 0.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24 |
| 22:43:47.002 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:47.003 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.003 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.004 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.004 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.004 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.005 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:43:47.005 | 0.4 ms | UPDATE | UPDATE "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:47.006 | 0.3 ms | INSERT | INSERT 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:47.006 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:47.007 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:47.007 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:47.007 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:47.008 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=40 |
| 22:43:47.008 | 0.4 ms | UPDATE | UPDATE "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:47.009 | 0.3 ms | INSERT | INSERT 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:47.009 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=25 |
| 22:43:47.010 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:47.010 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.011 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.011 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.012 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.012 | 0.8 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.013 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=513 |
| 22:43:47.014 | 0.4 ms | UPDATE | UPDATE "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:47.014 | 0.3 ms | INSERT | INSERT 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.015 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:47.015 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:47.015 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:47.016 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:47.016 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=25 |
| 22:43:47.017 | 0.3 ms | UPDATE | UPDATE "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:47.017 | 0.3 ms | INSERT | INSERT 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:47.017 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=23 |
| 22:43:47.018 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:47.018 | 0.3 ms | SELECT | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.019 | 0.3 ms | SELECT | SELECT SUM(lost_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.019 | 0.3 ms | SELECT | SELECT SUM(build_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.020 | 0.3 ms | SELECT | SELECT SUM(disassemble_spent_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.020 | 0.3 ms | SELECT | SELECT SUM(sales_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.020 | 0.3 ms | SELECT | SELECT SUM(sales_gift_outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:43:47.021 | 0.4 ms | UPDATE | UPDATE "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:47.022 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 516, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:47.022 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE 0=1 |
| 22:43:47.022 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1 |
| 22:43:47.023 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_build_products" WHERE 0=1 |
| 22:43:47.023 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" WHERE 0=1 |
| 22:43:47.024 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=27 |
| 22:43:47.024 | 0.3 ms | UPDATE | UPDATE "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:47.025 | 0.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 27, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:43:47.025 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_gifts" SET "is_used"=TRUE WHERE "id"=24 |
| 22:43:47.025 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" WHERE 0=1 |
| 22:43:47.026 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:43:47.026 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id" |
| 22:43:47.027 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=158) ORDER BY "id" |
| 22:43:47.028 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:43:47.029 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 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:47.030 | 0.3 ms | INSERT | INSERT 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:47.033 | 1.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-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" |