Total processing time: 90 ms; Peak memory: 4.600 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 22:59:46.841 | 1.6 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-outbound/save-new-sn', '{"id":"525","sns":["\u6492\u5730\u65b9"]}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","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:59:46', 82619904) RETURNING "id" |
| 22:59:46.803 | 1.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_gift_product_sn_id", "sn") VALUES (525, 4, '撒地方') RETURNING "id" |
| 22:59:46.781 | 1.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=522 |
| 22:59:46.762 | 1.0 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 22:59:46.780 | 0.9 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=522 |
| 22:59:46.834 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 40, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.772 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_gift_product_sns" ("erp_purchase_gift_product_id", "sn") VALUES (36, '撒地方') |
| 22:59:46.777 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 522, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.836 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (969, 868, 867, 870, 1558, 989, 2231, 2232) |
| 22:59:46.771 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=36 |
| 22:59:46.765 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:59:46.773 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=25 |
| 22:59:46.783 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.769 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='525' |
| 22:59:46.789 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=523 |
| 22:59:46.818 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=527 |
| 22:59:46.776 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=522 |
| 22:59:46.796 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=524 |
| 22:59:46.762 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 22:59:46.775 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=33 |
| 22:59:46.805 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=525 |
| 22:59:46.812 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=526 |
| 22:59:46.786 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=34 |
| 22:59:46.838 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_gift_id"=25) AND ("erp_purchase_gift_product_id" NOT IN (33, 34, 35, 36, 37, 38, 39, 40)) |
| 22:59:46.809 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=37 |
| 22:59:46.793 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=35 |
| 22:59:46.812 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 526, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.822 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=39 |
| 22:59:46.799 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=36 |
| 22:59:46.815 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=38 |
| 22:59:46.828 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=40 |
| 22:59:46.770 | 0.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=525 |
| 22:59:46.782 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 522, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.832 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='39' WHERE "id"=529 |
| 22:59:46.825 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=528 |
| 22:59:46.784 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 522, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.774 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "erp_purchase_gift_id"=25 |
| 22:59:46.833 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.823 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=528 |
| 22:59:46.789 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=523 |
| 22:59:46.793 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=524 |
| 22:59:46.787 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=523 |
| 22:59:46.825 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=528 |
| 22:59:46.796 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=524 |
| 22:59:46.805 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=525 |
| 22:59:46.809 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=526 |
| 22:59:46.790 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 523, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.818 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=527 |
| 22:59:46.785 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=33 |
| 22:59:46.785 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 33, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.831 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=529 |
| 22:59:46.787 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 523, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.826 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 528, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.778 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=33 |
| 22:59:46.834 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.801 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=525) AND ("erp_purchase_gift_product_sn_id"<>4) |
| 22:59:46.811 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=526 |
| 22:59:46.821 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 527, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.829 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=529 |
| 22:59:46.816 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='5', "inventory"='5', "total_amount"='0' WHERE "id"=527 |
| 22:59:46.814 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 526, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.800 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='55', "inventory"='55', "total_amount"='0' WHERE "id"=525 |
| 22:59:46.791 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 523, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.818 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=527 |
| 22:59:46.832 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:1:{s:9:"inventory";d:39;}', '', 1001, '111.194.208.14') |
| 22:59:46.815 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 37, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.831 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=529 |
| 22:59:46.797 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 524, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.804 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSns', 57, 'a:27:{s:2:"id";i:57;s:24:"erp_inventory_product_id";i:525;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";N;s:2:"sn";s:9:"撒地方";s:7:"is_used";N;s:11:"description";N;s:22:"erp_inventory_start_id";N;s:33:"erp_inventory_start_product_sn_id";N;s:22:"erp_inventory_build_id";N;s:33:"erp_inventory_build_product_sn_id";N;s:26:"used_erp_inventory_lost_id";N;s:27:"used_erp_inventory_build_id";N;s:37:"used_erp_inventory_lost_product_sn_id";N;s:44:"used_erp_inventory_build_spent_product_sn_id";N;s:26:"used_erp_sales_outbound_id";N;s:43:"used_erp_sales_outbound_spent_product_sn_id";N;s:31:"erp_purchase_gift_product_sn_id";i:4;s:20:"erp_purchase_gift_id";N;s:22:"used_erp_sales_gift_id";N;s:39:"used_erp_sales_gift_spent_product_sn_id";N;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 22:59:46.810 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 526, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.828 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 39, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.784 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.827 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 528, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.792 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 34, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.802 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=525 |
| 22:59:46.808 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 36, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.837 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGifts', 25, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.779 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=522 |
| 22:59:46.798 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 524, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.807 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 525, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.806 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 525, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.798 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=35 |
| 22:59:46.819 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 527, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.779 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=522) |
| 22:59:46.794 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 524, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.808 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=36 |
| 22:59:46.821 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 38, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.788 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=523 |
| 22:59:46.790 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.814 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=37 |
| 22:59:46.816 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 527, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.800 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 525, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.799 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseGiftProducts', 35, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.829 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 529, 'a:1:{s:9:"inventory";s:2:"39";}', '', 1001, '111.194.208.14') |
| 22:59:46.823 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 528, 'a:0:{}', '', 1001, '111.194.208.14') |
| 22:59:46.807 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.811 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=526 |
| 22:59:46.792 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=34 |
| 22:59:46.795 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=524 |
| 22:59:46.820 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.824 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=528 |
| 22:59:46.821 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='5' WHERE "id"=38 |
| 22:59:46.834 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='16', "inventory"='39' WHERE "id"=40 |
| 22:59:46.827 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='55' WHERE "id"=39 |
| 22:59:46.826 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.791 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.817 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=38 |
| 22:59:46.823 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=39 |
| 22:59:46.806 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.813 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.788 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=34 |
| 22:59:46.826 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.797 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:46.830 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=40 |
| 22:59:46.833 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.820 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.813 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.798 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:46.811 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=526) |
| 22:59:46.801 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=36 |
| 22:59:46.795 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=524) |
| 22:59:46.788 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=523) |
| 22:59:46.810 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=37 |
| 22:59:46.794 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=35 |
| 22:59:46.824 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=528) |
| 22:59:46.830 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=529) |
| 22:59:46.817 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=527) |