ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689954fb4d5d1: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-list at 2025-08-11 10:27:07 am by 124.64.23.198

Database Queries

总计17条数据
TimeDurationTypeQuery
  
10:27:07.3703.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
10:27:07.3750.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:27:07.3772.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:27:07.39816.1 msSELECTSELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" 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_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id" ORDER BY p.updated_at DESC, p.id desc) "c"

[+] Explain
10:27:07.41810.2 msSELECTSELECT "p".* FROM "a57be577deb434"."tbl_products" "p" 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_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id" ORDER BY p.updated_at DESC, p.id desc LIMIT 20

[+] Explain
10:27:07.4304.7 msSELECTSELECT "product_id", "erp_store_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(amount) as avg_amount, avg(amount * inventory) as avg_total_amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051) GROUP BY "product_id", "erp_store_id"

[+] Explain
10:27:07.4360.6 msSELECTSELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051) GROUP BY "product_id"

[+] Explain
10:27:07.4370.9 msSELECTSELECT "product_id", sum(inventory) as inventory, avg(actual_amount) as avg_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051)) GROUP BY "product_id"

[+] Explain
10:27:07.4380.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051))

[+] Explain
10:27:07.4390.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 4, 2, 10, 12, 11, 3)

[+] Explain
10:27:07.4390.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (35, 51, 23, 2, 199, 34, 22, 21, 19, 157, 36, 214, 26, 43, 154, 15, 135)

[+] Explain
10:27:07.4400.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 12, 4, 208, 20, 253, 21)

[+] Explain
10:27:07.4400.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (806, 231, 172, 1671, 1670, 1669, 1668, 1667, 1666, 615, 1664, 1665, 1012, 1663, 1662, 1661, 1227, 1660)

[+] Explain
10:27:07.4410.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (8, 2, 1, 3, 10, 4)

[+] Explain
10:27:07.4441.2 msSELECTSELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"

[+] Explain
10:27:07.4531.7 msSELECTSELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM "a57be577deb434"."tbl_products" "p" 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_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id") "sub"

[+] Explain
10:27:07.4561.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpProductSearch":{"erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":"","number_range_to":"","number_range_from":"","inventory":""},"page":"1","web_access_token":"YkvMWkUL2263Z49tytqyBRm0LxFzf1j_"}', '{"code":"","data":null,"status":0,"msg":[{"name":"error","success":"","error":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^\nThe SQL being executed was: SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM \"a57be577deb434\".\"tbl_products\" \"p\" 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_inventory_products\" \"eip\" ON eip.product_id = p.id GROUP BY \"p\".\"id\") \"sub\"","trace":{"name":"Database Exception","message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^\nThe SQL being executed was: SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM \"a57be577deb434\".\"tbl_products\" \"p\" 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_inventory_products\" \"eip\" ON eip.product_id = p.id GROUP BY \"p\".\"id\") \"sub\"","code":42703,"type":"yii\\db\\Exception","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Schema.php","line":637,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(915): yii\\db\\Schema->convertException(Object(PDOException), ''SELECT sum(inve...'')","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(376): yii\\db\\Command->queryInternal(''fetch'', NULL)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(253): yii\\db\\Command->queryOne()","#3 \/var\/www\/beta\/modules\/vue\/controllers\/ErpInventoryProductController.php(554): yii\\db\\Query->one()","#4 [internal function]: app\\modules\\vue\\controllers\\ErpInventoryProductController->actionProductList()","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''product-list'', Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-invento...'', Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#11 {main}"],"error-info":["42703",7,"ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^"],"previous":{"name":"Exception","message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^","code":"42703","type":"PDOException","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php","line":900,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(900): PDOStatement->execute()","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(376): yii\\db\\Command->queryInternal(''fetch'', NULL)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(253): yii\\db\\Command->queryOne()","#3 \/var\/www\/beta\/modules\/vue\/controllers\/ErpInventoryProductController.php(554): yii\\db\\Query->one()","#4 [internal function]: app\\modules\\vue\\controllers\\ErpInventoryProductController->actionProductList()","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''product-list'', Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-invento...'', Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#11 {main}"]}}}]}', TRUE, '2025-08-11 10:27:07') RETURNING "id"

[+] Explain