Skip to content

Instantly share code, notes, and snippets.

@willmitchell

willmitchell/jooq-tests-output.log

Created March 8, 2015 21:00
Show Gist options
  • Save willmitchell/0540a642c5657c668802 to your computer and use it in GitHub Desktop.
Save willmitchell/0540a642c5657c668802 to your computer and use it in GitHub Desktop.
Download ZIP
Shows hte output from running the unit tests
Raw
jooq-tests-output.log
/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/bin/java -ea -Didea.launcher.port=7535 "-Didea.launcher.bin.path=/Applications/IntelliJ IDEA 14.app/Contents/bin" -Dfile.encoding=UTF-8 -classpath "/Applications/IntelliJ IDEA 14.app/Contents/plugins/testng/lib/testng-plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/lib/tools.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_31.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Users/wm/Downloads/gen/sample_model/jpa/main/target/test-classes:/Users/wm/Downloads/gen/sample_model/jpa/main/target/classes:/Users/wm/.m2/repository/org/jooq/jooq/3.5.1/jooq-3.5.1.jar:/Users/wm/.m2/repository/org/codehaus/groovy/groovy-all/2.3.8/groovy-all-2.3.8.jar:/Users/wm/.m2/repository/ch/qos/logback/logback-classic/1.1.2/logback-classic-1.1.2.jar:/Users/wm/.m2/repository/ch/qos/logback/logback-core/1.1.2/logback-core-1.1.2.jar:/Users/wm/.m2/repository/org/slf4j/slf4j-api/1.7.6/slf4j-api-1.7.6.jar:/Users/wm/.m2/repository/org/postgresql/postgresql/9.3-1102-jdbc41/postgresql-9.3-1102-jdbc41.jar:/Users/wm/.m2/repository/org/liquibase/liquibase-core/3.3.2/liquibase-core-3.3.2.jar:/Users/wm/.m2/repository/org/testng/testng/6.8.7/testng-6.8.7.jar:/Users/wm/.m2/repository/junit/junit/4.10/junit-4.10.jar:/Users/wm/.m2/repository/org/hamcrest/hamcrest-core/1.1/hamcrest-core-1.1.jar:/Users/wm/.m2/repository/org/beanshell/bsh/2.0b4/bsh-2.0b4.jar:/Users/wm/.m2/repository/com/beust/jcommander/1.27/jcommander-1.27.jar:/Users/wm/.m2/repository/org/yaml/snakeyaml/1.12/snakeyaml-1.12.jar:/Applications/IntelliJ IDEA 14.app/Contents/plugins/testng/lib/testng.jar:/Applications/IntelliJ IDEA 14.app/Contents/lib/idea_rt.jar" com.intellij.rt.execution.application.AppMain org.testng.RemoteTestNGStarter -port 49840 -usedefaultlisteners false -socket49841 -temp /private/var/folders/ky/wgvw61wd6w9_wnyjd8fbmrbr0000gn/T/idea_testng116.tmp
[TestNG] Running:
/Users/wm/Library/Caches/IntelliJIdea14/temp-testng-customsuite.xml
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @ @ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using jOOQ 3.5.1
Executing query : delete from "public"."order_item"
Affected row(s) : 90
Query executed : Total: 59.224ms
Finishing : Total: 60.196ms, +0.971ms
Executing query : delete from "public"."product"
Affected row(s) : 10
Query executed : Total: 8.406ms
Finishing : Total: 8.459ms, +0.053ms
Executing query : delete from "public"."order"
Affected row(s) : 30
Query executed : Total: 7.806ms
Finishing : Total: 7.859ms, +0.052ms
Executing query : delete from "public"."group_role"
Affected row(s) : 6
Query executed : Total: 7.028ms
Finishing : Total: 7.08ms, +0.052ms
Executing query : delete from "public"."role"
Affected row(s) : 6
Query executed : Total: 2.301ms
Finishing : Total: 2.357ms, +0.056ms
Executing query : delete from "public"."group_user"
Affected row(s) : 24
Query executed : Total: 1.533ms
Finishing : Total: 1.582ms, +0.048ms
Executing query : delete from "public"."group"
Affected row(s) : 6
Query executed : Total: 2.88ms
Finishing : Total: 2.948ms, +0.067ms
Executing query : delete from "public"."asset"
Affected row(s) : 30
Query executed : Total: 1.478ms
Finishing : Total: 1.528ms, +0.05ms
Executing query : delete from "public"."account"
Affected row(s) : 3
Query executed : Total: 2.259ms
Finishing : Total: 2.308ms, +0.049ms
Executing query : delete from "public"."user"
Affected row(s) : 26
Query executed : Total: 4.41ms
Finishing : Total: 4.487ms, +0.076ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('owner') returning "public"."user"."id"
Query executed : Total: 24.834ms
Finishing : Total: 49.906ms
Fetched result : +----+
: | id|
: +----+
: | 208|
: +----+
Finishing : Total: 77.435ms, +52.6ms
+----+------+
| id|login |
+----+------+
| 208|{null}|
+----+------+
Executing query : insert into "public"."account" ("name", "owner_id") values (?, ?) returning "public"."account"."id"
-> with bind values : insert into "public"."account" ("name", "owner_id") values ('Mega Corp', 208) returning "public"."account"."id"
Query executed : Total: 7.692ms
Finishing : Total: 0.064ms
Fetched result : +----+
: | id|
: +----+
: | 22|
: +----+
Finishing : Total: 8.44ms, +0.748ms
Executing query : insert into "public"."group" ("account_id", "name") values (?, ?), (?, ?) returning "public"."group"."id"
-> with bind values : insert into "public"."group" ("account_id", "name") values (22, 'all'), (22, 'managers') returning "public"."group"."id"
Query executed : Total: 7.765ms
Finishing : Total: 0.08ms
Fetched result : +----+
: | id|
: +----+
: | 43|
: | 44|
: +----+
Finishing : Total: 8.571ms, +0.805ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-0-1') returning "public"."user"."id"
Query executed : Total: 9.085ms
Finishing : Total: 0.07ms
Fetched result : +----+
: | id|
: +----+
: | 209|
: +----+
Finishing : Total: 9.527ms, +0.441ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (43, 209)
Affected row(s) : 1
Query executed : Total: 8.002ms
Finishing : Total: 8.109ms, +0.106ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (44, 209)
Affected row(s) : 1
Query executed : Total: 6.82ms
Finishing : Total: 6.869ms, +0.049ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-0-2') returning "public"."user"."id"
Query executed : Total: 7.186ms
Finishing : Total: 0.063ms
Fetched result : +----+
: | id|
: +----+
: | 210|
: +----+
Finishing : Total: 7.643ms, +0.456ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (43, 210)
Affected row(s) : 1
Query executed : Total: 7.198ms
Finishing : Total: 7.26ms, +0.061ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-0-3') returning "public"."user"."id"
Query executed : Total: 1.659ms
Finishing : Total: 0.076ms
Fetched result : +----+
: | id|
: +----+
: | 211|
: +----+
Finishing : Total: 2.257ms, +0.597ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (43, 211)
Affected row(s) : 1
Query executed : Total: 1.825ms
Finishing : Total: 1.874ms, +0.048ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (44, 211)
Affected row(s) : 1
Query executed : Total: 1.709ms
Finishing : Total: 1.777ms, +0.067ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-0-4') returning "public"."user"."id"
Query executed : Total: 1.536ms
Finishing : Total: 0.082ms
Fetched result : +----+
: | id|
: +----+
: | 212|
: +----+
Finishing : Total: 2.335ms, +0.799ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (43, 212)
Affected row(s) : 1
Query executed : Total: 1.594ms
Finishing : Total: 1.658ms, +0.063ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-0-5') returning "public"."user"."id"
Query executed : Total: 1.464ms
Finishing : Total: 0.088ms
Fetched result : +----+
: | id|
: +----+
: | 213|
: +----+
Finishing : Total: 2.195ms, +0.73ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (43, 213)
Affected row(s) : 1
Query executed : Total: 1.586ms
Finishing : Total: 1.658ms, +0.071ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (44, 213)
Affected row(s) : 1
Query executed : Total: 1.406ms
Finishing : Total: 1.451ms, +0.045ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('basic') returning "public"."role"."id"
Query executed : Total: 1.357ms
Finishing : Total: 0.061ms
Fetched result : +----+
: | id|
: +----+
: | 43|
: +----+
Finishing : Total: 1.981ms, +0.623ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (43, 43)
Affected row(s) : 1
Query executed : Total: 1.647ms
Finishing : Total: 1.697ms, +0.049ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('manage') returning "public"."role"."id"
Query executed : Total: 1.062ms
Finishing : Total: 0.167ms
Fetched result : +----+
: | id|
: +----+
: | 44|
: +----+
Finishing : Total: 1.651ms, +0.588ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (44, 44)
Affected row(s) : 1
Query executed : Total: 1.198ms
Finishing : Total: 1.242ms, +0.044ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 1') returning "public"."asset"."id"
Query executed : Total: 1.849ms
Finishing : Total: 0.062ms
Fetched result : +----+
: | id|
: +----+
: | 151|
: +----+
Finishing : Total: 2.562ms, +0.713ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 2') returning "public"."asset"."id"
Query executed : Total: 1.54ms
Finishing : Total: 0.065ms
Fetched result : +----+
: | id|
: +----+
: | 152|
: +----+
Finishing : Total: 1.975ms, +0.435ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 3') returning "public"."asset"."id"
Query executed : Total: 1.346ms
Finishing : Total: 0.07ms
Fetched result : +----+
: | id|
: +----+
: | 153|
: +----+
Finishing : Total: 1.77ms, +0.424ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 4') returning "public"."asset"."id"
Query executed : Total: 1.251ms
Finishing : Total: 0.059ms
Fetched result : +----+
: | id|
: +----+
: | 154|
: +----+
Finishing : Total: 1.929ms, +0.677ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 5') returning "public"."asset"."id"
Query executed : Total: 1.528ms
Finishing : Total: 0.063ms
Fetched result : +----+
: | id|
: +----+
: | 155|
: +----+
Finishing : Total: 1.963ms, +0.434ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 6') returning "public"."asset"."id"
Query executed : Total: 1.601ms
Finishing : Total: 0.086ms
Fetched result : +----+
: | id|
: +----+
: | 156|
: +----+
Finishing : Total: 2.213ms, +0.612ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 7') returning "public"."asset"."id"
Query executed : Total: 1.448ms
Finishing : Total: 0.066ms
Fetched result : +----+
: | id|
: +----+
: | 157|
: +----+
Finishing : Total: 2.05ms, +0.601ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 8') returning "public"."asset"."id"
Query executed : Total: 1.283ms
Finishing : Total: 0.06ms
Fetched result : +----+
: | id|
: +----+
: | 158|
: +----+
Finishing : Total: 1.683ms, +0.4ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 9') returning "public"."asset"."id"
Query executed : Total: 1.308ms
Finishing : Total: 0.092ms
Fetched result : +----+
: | id|
: +----+
: | 159|
: +----+
Finishing : Total: 1.853ms, +0.544ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (22, 'address 10') returning "public"."asset"."id"
Query executed : Total: 1.582ms
Finishing : Total: 0.061ms
Fetched result : +----+
: | id|
: +----+
: | 160|
: +----+
Finishing : Total: 2.215ms, +0.632ms
Executing query : insert into "public"."account" ("name", "owner_id") values (?, ?) returning "public"."account"."id"
-> with bind values : insert into "public"."account" ("name", "owner_id") values ('Other Corp', 208) returning "public"."account"."id"
Query executed : Total: 1.188ms
Finishing : Total: 0.058ms
Fetched result : +----+
: | id|
: +----+
: | 23|
: +----+
Finishing : Total: 1.549ms, +0.361ms
Executing query : insert into "public"."group" ("account_id", "name") values (?, ?), (?, ?) returning "public"."group"."id"
-> with bind values : insert into "public"."group" ("account_id", "name") values (23, 'all'), (23, 'managers') returning "public"."group"."id"
Query executed : Total: 1.487ms
Finishing : Total: 0.14ms
Fetched result : +----+
: | id|
: +----+
: | 45|
: | 46|
: +----+
Finishing : Total: 2.116ms, +0.629ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-1-1') returning "public"."user"."id"
Query executed : Total: 1.346ms
Finishing : Total: 0.061ms
Fetched result : +----+
: | id|
: +----+
: | 214|
: +----+
Finishing : Total: 1.783ms, +0.436ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (45, 214)
Affected row(s) : 1
Query executed : Total: 1.324ms
Finishing : Total: 1.401ms, +0.077ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (46, 214)
Affected row(s) : 1
Query executed : Total: 1.382ms
Finishing : Total: 1.448ms, +0.065ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-1-2') returning "public"."user"."id"
Query executed : Total: 1.375ms
Finishing : Total: 0.08ms
Fetched result : +----+
: | id|
: +----+
: | 215|
: +----+
Finishing : Total: 1.912ms, +0.536ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (45, 215)
Affected row(s) : 1
Query executed : Total: 1.246ms
Finishing : Total: 1.291ms, +0.044ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-1-3') returning "public"."user"."id"
Query executed : Total: 1.064ms
Finishing : Total: 0.062ms
Fetched result : +----+
: | id|
: +----+
: | 216|
: +----+
Finishing : Total: 1.523ms, +0.458ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (45, 216)
Affected row(s) : 1
Query executed : Total: 1.18ms
Finishing : Total: 1.226ms, +0.045ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (46, 216)
Affected row(s) : 1
Query executed : Total: 0.969ms
Finishing : Total: 1.011ms, +0.042ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-1-4') returning "public"."user"."id"
Query executed : Total: 0.984ms
Finishing : Total: 0.075ms
Fetched result : +----+
: | id|
: +----+
: | 217|
: +----+
Finishing : Total: 1.466ms, +0.482ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (45, 217)
Affected row(s) : 1
Query executed : Total: 1.098ms
Finishing : Total: 1.147ms, +0.048ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-1-5') returning "public"."user"."id"
Query executed : Total: 1.398ms
Finishing : Total: 0.086ms
Fetched result : +----+
: | id|
: +----+
: | 218|
: +----+
Finishing : Total: 1.971ms, +0.572ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (45, 218)
Affected row(s) : 1
Query executed : Total: 1.658ms
Finishing : Total: 1.709ms, +0.05ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (46, 218)
Affected row(s) : 1
Query executed : Total: 1.264ms
Finishing : Total: 2.678ms, +1.413ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('basic') returning "public"."role"."id"
Query executed : Total: 0.996ms
Finishing : Total: 0.056ms
Fetched result : +----+
: | id|
: +----+
: | 45|
: +----+
Finishing : Total: 1.418ms, +0.421ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (45, 45)
Affected row(s) : 1
Query executed : Total: 1.361ms
Finishing : Total: 1.512ms, +0.151ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('manage') returning "public"."role"."id"
Query executed : Total: 1.211ms
Finishing : Total: 0.08ms
Fetched result : +----+
: | id|
: +----+
: | 46|
: +----+
Finishing : Total: 1.771ms, +0.56ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (46, 46)
Affected row(s) : 1
Query executed : Total: 1.211ms
Finishing : Total: 1.264ms, +0.053ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 1') returning "public"."asset"."id"
Query executed : Total: 1.091ms
Finishing : Total: 0.064ms
Fetched result : +----+
: | id|
: +----+
: | 161|
: +----+
Finishing : Total: 1.474ms, +0.383ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 2') returning "public"."asset"."id"
Query executed : Total: 1.096ms
Finishing : Total: 0.075ms
Fetched result : +----+
: | id|
: +----+
: | 162|
: +----+
Finishing : Total: 1.481ms, +0.385ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 3') returning "public"."asset"."id"
Query executed : Total: 1.145ms
Finishing : Total: 0.06ms
Fetched result : +----+
: | id|
: +----+
: | 163|
: +----+
Finishing : Total: 1.502ms, +0.357ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 4') returning "public"."asset"."id"
Query executed : Total: 1.206ms
Finishing : Total: 0.061ms
Fetched result : +----+
: | id|
: +----+
: | 164|
: +----+
Finishing : Total: 1.634ms, +0.428ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 5') returning "public"."asset"."id"
Query executed : Total: 1.452ms
Finishing : Total: 0.067ms
Fetched result : +----+
: | id|
: +----+
: | 165|
: +----+
Finishing : Total: 2.056ms, +0.604ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 6') returning "public"."asset"."id"
Query executed : Total: 1.208ms
Finishing : Total: 0.059ms
Fetched result : +----+
: | id|
: +----+
: | 166|
: +----+
Finishing : Total: 2.201ms, +0.993ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 7') returning "public"."asset"."id"
Query executed : Total: 1.224ms
Finishing : Total: 0.086ms
Fetched result : +----+
: | id|
: +----+
: | 167|
: +----+
Finishing : Total: 1.691ms, +0.466ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 8') returning "public"."asset"."id"
Query executed : Total: 1.273ms
Finishing : Total: 0.058ms
Fetched result : +----+
: | id|
: +----+
: | 168|
: +----+
Finishing : Total: 2.071ms, +0.797ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 9') returning "public"."asset"."id"
Query executed : Total: 1.287ms
Finishing : Total: 0.072ms
Fetched result : +----+
: | id|
: +----+
: | 169|
: +----+
Finishing : Total: 1.706ms, +0.418ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (23, 'address 10') returning "public"."asset"."id"
Query executed : Total: 1.056ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 170|
: +----+
Finishing : Total: 1.394ms, +0.337ms
Executing query : insert into "public"."account" ("name", "owner_id") values (?, ?) returning "public"."account"."id"
-> with bind values : insert into "public"."account" ("name", "owner_id") values ('Small Corp', 208) returning "public"."account"."id"
Query executed : Total: 1.028ms
Finishing : Total: 0.053ms
Fetched result : +----+
: | id|
: +----+
: | 24|
: +----+
Finishing : Total: 1.319ms, +0.29ms
Executing query : insert into "public"."group" ("account_id", "name") values (?, ?), (?, ?) returning "public"."group"."id"
-> with bind values : insert into "public"."group" ("account_id", "name") values (24, 'all'), (24, 'managers') returning "public"."group"."id"
Query executed : Total: 1.242ms
Finishing : Total: 0.077ms
Fetched result : +----+
: | id|
: +----+
: | 47|
: | 48|
: +----+
Finishing : Total: 1.645ms, +0.403ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-2-1') returning "public"."user"."id"
Query executed : Total: 7.344ms
Finishing : Total: 0.062ms
Fetched result : +----+
: | id|
: +----+
: | 219|
: +----+
Finishing : Total: 7.795ms, +0.45ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (47, 219)
Affected row(s) : 1
Query executed : Total: 6.493ms
Finishing : Total: 6.535ms, +0.042ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (48, 219)
Affected row(s) : 1
Query executed : Total: 6.738ms
Finishing : Total: 6.792ms, +0.053ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-2-2') returning "public"."user"."id"
Query executed : Total: 5.551ms
Finishing : Total: 0.063ms
Fetched result : +----+
: | id|
: +----+
: | 220|
: +----+
Finishing : Total: 5.918ms, +0.367ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (47, 220)
Affected row(s) : 1
Query executed : Total: 0.995ms
Finishing : Total: 1.03ms, +0.034ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-2-3') returning "public"."user"."id"
Query executed : Total: 1.154ms
Finishing : Total: 0.075ms
Fetched result : +----+
: | id|
: +----+
: | 221|
: +----+
Finishing : Total: 1.624ms, +0.47ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (47, 221)
Affected row(s) : 1
Query executed : Total: 1.255ms
Finishing : Total: 1.307ms, +0.051ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (48, 221)
Affected row(s) : 1
Query executed : Total: 1.094ms
Finishing : Total: 1.131ms, +0.037ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-2-4') returning "public"."user"."id"
Query executed : Total: 0.961ms
Finishing : Total: 0.082ms
Fetched result : +----+
: | id|
: +----+
: | 222|
: +----+
Finishing : Total: 1.376ms, +0.415ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (47, 222)
Affected row(s) : 1
Query executed : Total: 1.154ms
Finishing : Total: 1.205ms, +0.051ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('user-2-5') returning "public"."user"."id"
Query executed : Total: 1.18ms
Finishing : Total: 0.084ms
Fetched result : +----+
: | id|
: +----+
: | 223|
: +----+
Finishing : Total: 1.884ms, +0.704ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (47, 223)
Affected row(s) : 1
Query executed : Total: 1.063ms
Finishing : Total: 1.11ms, +0.047ms
Executing query : insert into "public"."group_user" ("group_id", "user_id") values (?, ?)
-> with bind values : insert into "public"."group_user" ("group_id", "user_id") values (48, 223)
Affected row(s) : 1
Query executed : Total: 1.275ms
Finishing : Total: 1.335ms, +0.059ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('basic') returning "public"."role"."id"
Query executed : Total: 1.417ms
Finishing : Total: 0.08ms
Fetched result : +----+
: | id|
: +----+
: | 47|
: +----+
Finishing : Total: 1.95ms, +0.533ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (47, 47)
Affected row(s) : 1
Query executed : Total: 1.341ms
Finishing : Total: 1.446ms, +0.104ms
Executing query : insert into "public"."role" ("name") values (?) returning "public"."role"."id"
-> with bind values : insert into "public"."role" ("name") values ('manage') returning "public"."role"."id"
Query executed : Total: 1.639ms
Finishing : Total: 0.065ms
Fetched result : +----+
: | id|
: +----+
: | 48|
: +----+
Finishing : Total: 2.074ms, +0.434ms
Executing query : insert into "public"."group_role" ("group_id", "role_id") values (?, ?)
-> with bind values : insert into "public"."group_role" ("group_id", "role_id") values (48, 48)
Affected row(s) : 1
Query executed : Total: 1.052ms
Finishing : Total: 1.091ms, +0.039ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 1') returning "public"."asset"."id"
Query executed : Total: 1.189ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 171|
: +----+
Finishing : Total: 1.463ms, +0.274ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 2') returning "public"."asset"."id"
Query executed : Total: 1.046ms
Finishing : Total: 0.059ms
Fetched result : +----+
: | id|
: +----+
: | 172|
: +----+
Finishing : Total: 1.368ms, +0.322ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 3') returning "public"."asset"."id"
Query executed : Total: 1.011ms
Finishing : Total: 0.053ms
Fetched result : +----+
: | id|
: +----+
: | 173|
: +----+
Finishing : Total: 1.298ms, +0.286ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 4') returning "public"."asset"."id"
Query executed : Total: 1.285ms
Finishing : Total: 0.074ms
Fetched result : +----+
: | id|
: +----+
: | 174|
: +----+
Finishing : Total: 1.636ms, +0.35ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 5') returning "public"."asset"."id"
Query executed : Total: 1.169ms
Finishing : Total: 0.059ms
Fetched result : +----+
: | id|
: +----+
: | 175|
: +----+
Finishing : Total: 1.461ms, +0.292ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 6') returning "public"."asset"."id"
Query executed : Total: 1.081ms
Finishing : Total: 0.062ms
Fetched result : +----+
: | id|
: +----+
: | 176|
: +----+
Finishing : Total: 1.358ms, +0.277ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 7') returning "public"."asset"."id"
Query executed : Total: 1.136ms
Finishing : Total: 0.052ms
Fetched result : +----+
: | id|
: +----+
: | 177|
: +----+
Finishing : Total: 1.396ms, +0.259ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 8') returning "public"."asset"."id"
Query executed : Total: 0.931ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 178|
: +----+
Finishing : Total: 1.201ms, +0.27ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 9') returning "public"."asset"."id"
Query executed : Total: 0.969ms
Finishing : Total: 0.05ms
Fetched result : +----+
: | id|
: +----+
: | 179|
: +----+
Finishing : Total: 1.217ms, +0.247ms
Executing query : insert into "public"."asset" ("account_id", "address") values (?, ?) returning "public"."asset"."id"
-> with bind values : insert into "public"."asset" ("account_id", "address") values (24, 'address 10') returning "public"."asset"."id"
Query executed : Total: 0.933ms
Finishing : Total: 0.047ms
Fetched result : +----+
: | id|
: +----+
: | 180|
: +----+
Finishing : Total: 1.242ms, +0.309ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 1', 10) returning "public"."product"."id"
Query executed : Total: 7.165ms
Finishing : Total: 0.302ms
Fetched result : +----+
: | id|
: +----+
: | 71|
: +----+
Finishing : Total: 8.079ms, +0.913ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 2', 20) returning "public"."product"."id"
Query executed : Total: 6.759ms
Finishing : Total: 0.078ms
Fetched result : +----+
: | id|
: +----+
: | 72|
: +----+
Finishing : Total: 7.162ms, +0.403ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 3', 30) returning "public"."product"."id"
Query executed : Total: 6.622ms
Finishing : Total: 0.085ms
Fetched result : +----+
: | id|
: +----+
: | 73|
: +----+
Finishing : Total: 6.991ms, +0.369ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 4', 40) returning "public"."product"."id"
Query executed : Total: 6.343ms
Finishing : Total: 0.061ms
Fetched result : +----+
: | id|
: +----+
: | 74|
: +----+
Finishing : Total: 6.728ms, +0.384ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 5', 50) returning "public"."product"."id"
Query executed : Total: 6.239ms
Finishing : Total: 0.098ms
Fetched result : +----+
: | id|
: +----+
: | 75|
: +----+
Finishing : Total: 6.644ms, +0.404ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 6', 60) returning "public"."product"."id"
Query executed : Total: 1.283ms
Finishing : Total: 0.13ms
Fetched result : +----+
: | id|
: +----+
: | 76|
: +----+
Finishing : Total: 1.719ms, +0.435ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 7', 70) returning "public"."product"."id"
Query executed : Total: 1.154ms
Finishing : Total: 0.09ms
Fetched result : +----+
: | id|
: +----+
: | 77|
: +----+
Finishing : Total: 1.538ms, +0.383ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 8', 80) returning "public"."product"."id"
Query executed : Total: 1.466ms
Finishing : Total: 0.068ms
Fetched result : +----+
: | id|
: +----+
: | 78|
: +----+
Finishing : Total: 1.804ms, +0.338ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 9', 90) returning "public"."product"."id"
Query executed : Total: 0.873ms
Finishing : Total: 0.068ms
Fetched result : +----+
: | id|
: +----+
: | 79|
: +----+
Finishing : Total: 1.202ms, +0.329ms
Executing query : insert into "public"."product" ("name", "price") values (?, ?) returning "public"."product"."id"
-> with bind values : insert into "public"."product" ("name", "price") values ('product 10', 100) returning "public"."product"."id"
Query executed : Total: 1.195ms
Finishing : Total: 0.062ms
Fetched result : +----+
: | id|
: +----+
: | 80|
: +----+
Finishing : Total: 1.516ms, +0.32ms
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u1') returning "public"."user"."id"
Query executed : Total: 1.436ms
Finishing : Total: 0.075ms
Fetched result : +----+
: | id|
: +----+
: | 224|
: +----+
Finishing : Total: 1.876ms, +0.44ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (224, 0) returning "public"."order"."id"
Query executed : Total: 1.426ms
Finishing : Total: 0.056ms
Fetched result : +----+
: | id|
: +----+
: | 151|
: +----+
Finishing : Total: 1.902ms, +0.476ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (151, 74, 2, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 3.658ms
Finishing : Total: 3.697ms, +0.038ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (151, 74, 42, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 1.351ms
Finishing : Total: 1.403ms, +0.052ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (151, 76, 34, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.502ms
Finishing : Total: 1.547ms, +0.045ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 151) where "public"."order"."id" = 151
Affected row(s) : 1
Query executed : Total: 4.346ms
Finishing : Total: 4.389ms, +0.042ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (224, 0) returning "public"."order"."id"
Query executed : Total: 0.863ms
Finishing : Total: 0.074ms
Fetched result : +----+
: | id|
: +----+
: | 152|
: +----+
Finishing : Total: 1.188ms, +0.324ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (152, 71, 29, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 1.26ms
Finishing : Total: 1.291ms, +0.03ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (152, 79, 7, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.239ms
Finishing : Total: 1.273ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (152, 78, 7, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 1.259ms
Finishing : Total: 1.301ms, +0.041ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 152) where "public"."order"."id" = 152
Affected row(s) : 1
Query executed : Total: 0.941ms
Finishing : Total: 0.974ms, +0.032ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (224, 0) returning "public"."order"."id"
Query executed : Total: 0.905ms
Finishing : Total: 0.086ms
Fetched result : +----+
: | id|
: +----+
: | 153|
: +----+
Finishing : Total: 1.226ms, +0.321ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (153, 73, 26, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.114ms
Finishing : Total: 1.144ms, +0.029ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (153, 77, 18, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.873ms
Finishing : Total: 0.958ms, +0.085ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (153, 79, 35, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 0.919ms
Finishing : Total: 0.951ms, +0.031ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 153) where "public"."order"."id" = 153
Affected row(s) : 1
Query executed : Total: 1.122ms
Finishing : Total: 1.158ms, +0.035ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u2') returning "public"."user"."id"
Query executed : Total: 0.993ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 225|
: +----+
Finishing : Total: 1.265ms, +0.271ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (225, 0) returning "public"."order"."id"
Query executed : Total: 0.749ms
Finishing : Total: 0.052ms
Fetched result : +----+
: | id|
: +----+
: | 154|
: +----+
Finishing : Total: 0.995ms, +0.246ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (154, 74, 37, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 1.043ms
Finishing : Total: 1.076ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (154, 77, 49, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 1.121ms
Finishing : Total: 1.185ms, +0.063ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (154, 78, 22, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 0.993ms
Finishing : Total: 1.046ms, +0.052ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 154) where "public"."order"."id" = 154
Affected row(s) : 1
Query executed : Total: 0.921ms
Finishing : Total: 0.95ms, +0.029ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (225, 0) returning "public"."order"."id"
Query executed : Total: 0.685ms
Finishing : Total: 0.052ms
Fetched result : +----+
: | id|
: +----+
: | 155|
: +----+
Finishing : Total: 0.932ms, +0.246ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (155, 80, 28, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 1.368ms
Finishing : Total: 1.414ms, +0.045ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (155, 74, 38, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 1.059ms
Finishing : Total: 1.102ms, +0.042ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (155, 73, 17, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.086ms
Finishing : Total: 1.136ms, +0.049ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 155) where "public"."order"."id" = 155
Affected row(s) : 1
Query executed : Total: 0.858ms
Finishing : Total: 0.882ms, +0.024ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (225, 0) returning "public"."order"."id"
Query executed : Total: 0.729ms
Finishing : Total: 0.057ms
Fetched result : +----+
: | id|
: +----+
: | 156|
: +----+
Finishing : Total: 1.007ms, +0.277ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (156, 76, 42, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.143ms
Finishing : Total: 1.177ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (156, 75, 16, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 1.185ms
Finishing : Total: 1.222ms, +0.037ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (156, 75, 40, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 1.004ms
Finishing : Total: 1.03ms, +0.026ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 156) where "public"."order"."id" = 156
Affected row(s) : 1
Query executed : Total: 0.935ms
Finishing : Total: 0.961ms, +0.026ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u3') returning "public"."user"."id"
Query executed : Total: 0.978ms
Finishing : Total: 0.06ms
Fetched result : +----+
: | id|
: +----+
: | 226|
: +----+
Finishing : Total: 1.261ms, +0.283ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (226, 0) returning "public"."order"."id"
Query executed : Total: 0.825ms
Finishing : Total: 0.053ms
Fetched result : +----+
: | id|
: +----+
: | 157|
: +----+
Finishing : Total: 1.073ms, +0.247ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (157, 80, 40, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 1.183ms
Finishing : Total: 1.225ms, +0.042ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (157, 75, 37, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 1.233ms
Finishing : Total: 1.274ms, +0.041ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (157, 73, 34, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.358ms
Finishing : Total: 1.397ms, +0.039ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 157) where "public"."order"."id" = 157
Affected row(s) : 1
Query executed : Total: 1.257ms
Finishing : Total: 1.298ms, +0.041ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (226, 0) returning "public"."order"."id"
Query executed : Total: 0.761ms
Finishing : Total: 0.074ms
Fetched result : +----+
: | id|
: +----+
: | 158|
: +----+
Finishing : Total: 1.144ms, +0.382ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (158, 79, 19, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.549ms
Finishing : Total: 1.618ms, +0.069ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (158, 79, 3, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.056ms
Finishing : Total: 1.078ms, +0.022ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (158, 74, 27, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 0.913ms
Finishing : Total: 0.938ms, +0.025ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 158) where "public"."order"."id" = 158
Affected row(s) : 1
Query executed : Total: 0.984ms
Finishing : Total: 1.01ms, +0.025ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (226, 0) returning "public"."order"."id"
Query executed : Total: 0.668ms
Finishing : Total: 0.054ms
Fetched result : +----+
: | id|
: +----+
: | 159|
: +----+
Finishing : Total: 0.912ms, +0.243ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (159, 71, 0, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 1.262ms
Finishing : Total: 1.296ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (159, 71, 16, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 1.496ms
Finishing : Total: 1.536ms, +0.039ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (159, 74, 9, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 1.262ms
Finishing : Total: 1.29ms, +0.028ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 159) where "public"."order"."id" = 159
Affected row(s) : 1
Query executed : Total: 1.228ms
Finishing : Total: 1.259ms, +0.031ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u4') returning "public"."user"."id"
Query executed : Total: 0.908ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 227|
: +----+
Finishing : Total: 1.216ms, +0.307ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (227, 0) returning "public"."order"."id"
Query executed : Total: 0.832ms
Finishing : Total: 0.05ms
Fetched result : +----+
: | id|
: +----+
: | 160|
: +----+
Finishing : Total: 1.138ms, +0.306ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (160, 73, 47, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 0.97ms
Finishing : Total: 0.991ms, +0.021ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (160, 72, 7, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 0.922ms
Finishing : Total: 0.963ms, +0.04ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (160, 78, 17, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 1.168ms
Finishing : Total: 1.205ms, +0.036ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 160) where "public"."order"."id" = 160
Affected row(s) : 1
Query executed : Total: 0.95ms
Finishing : Total: 1.026ms, +0.075ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (227, 0) returning "public"."order"."id"
Query executed : Total: 0.653ms
Finishing : Total: 0.051ms
Fetched result : +----+
: | id|
: +----+
: | 161|
: +----+
Finishing : Total: 0.904ms, +0.25ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (161, 72, 5, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.023ms
Finishing : Total: 1.052ms, +0.028ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (161, 76, 16, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.118ms
Finishing : Total: 1.143ms, +0.025ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (161, 79, 44, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.166ms
Finishing : Total: 1.188ms, +0.022ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 161) where "public"."order"."id" = 161
Affected row(s) : 1
Query executed : Total: 1.003ms
Finishing : Total: 1.033ms, +0.029ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (227, 0) returning "public"."order"."id"
Query executed : Total: 0.728ms
Finishing : Total: 0.067ms
Fetched result : +----+
: | id|
: +----+
: | 162|
: +----+
Finishing : Total: 0.997ms, +0.269ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (162, 78, 31, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 0.899ms
Finishing : Total: 0.918ms, +0.018ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (162, 77, 14, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.939ms
Finishing : Total: 0.96ms, +0.02ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (162, 77, 8, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.965ms
Finishing : Total: 0.986ms, +0.02ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 162) where "public"."order"."id" = 162
Affected row(s) : 1
Query executed : Total: 1.044ms
Finishing : Total: 1.081ms, +0.036ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u5') returning "public"."user"."id"
Query executed : Total: 0.855ms
Finishing : Total: 0.09ms
Fetched result : +----+
: | id|
: +----+
: | 228|
: +----+
Finishing : Total: 1.223ms, +0.368ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (228, 0) returning "public"."order"."id"
Query executed : Total: 0.754ms
Finishing : Total: 0.08ms
Fetched result : +----+
: | id|
: +----+
: | 163|
: +----+
Finishing : Total: 1.13ms, +0.375ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (163, 77, 41, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 1.317ms
Finishing : Total: 1.361ms, +0.044ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (163, 80, 28, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 0.866ms
Finishing : Total: 0.892ms, +0.025ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (163, 71, 43, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 1.018ms
Finishing : Total: 1.046ms, +0.028ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 163) where "public"."order"."id" = 163
Affected row(s) : 1
Query executed : Total: 1.133ms
Finishing : Total: 1.156ms, +0.023ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (228, 0) returning "public"."order"."id"
Query executed : Total: 0.78ms
Finishing : Total: 0.057ms
Fetched result : +----+
: | id|
: +----+
: | 164|
: +----+
Finishing : Total: 1.018ms, +0.238ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (164, 71, 28, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 0.851ms
Finishing : Total: 0.88ms, +0.028ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (164, 77, 6, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.925ms
Finishing : Total: 0.943ms, +0.017ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (164, 79, 7, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.063ms
Finishing : Total: 1.087ms, +0.024ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 164) where "public"."order"."id" = 164
Affected row(s) : 1
Query executed : Total: 1.173ms
Finishing : Total: 1.201ms, +0.027ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (228, 0) returning "public"."order"."id"
Query executed : Total: 0.711ms
Finishing : Total: 0.075ms
Fetched result : +----+
: | id|
: +----+
: | 165|
: +----+
Finishing : Total: 1.03ms, +0.319ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (165, 75, 1, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 1.191ms
Finishing : Total: 1.223ms, +0.032ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (165, 77, 40, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 7.314ms
Finishing : Total: 7.345ms, +0.031ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (165, 78, 31, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 1.139ms
Finishing : Total: 1.168ms, +0.028ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 165) where "public"."order"."id" = 165
Affected row(s) : 1
Query executed : Total: 1.184ms
Finishing : Total: 1.213ms, +0.028ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u6') returning "public"."user"."id"
Query executed : Total: 0.834ms
Finishing : Total: 0.076ms
Fetched result : +----+
: | id|
: +----+
: | 229|
: +----+
Finishing : Total: 1.146ms, +0.312ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (229, 0) returning "public"."order"."id"
Query executed : Total: 0.712ms
Finishing : Total: 0.07ms
Fetched result : +----+
: | id|
: +----+
: | 166|
: +----+
Finishing : Total: 1.411ms, +0.698ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (166, 72, 47, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 0.991ms
Finishing : Total: 1.018ms, +0.027ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (166, 76, 14, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.074ms
Finishing : Total: 1.1ms, +0.026ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (166, 72, 7, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 0.963ms
Finishing : Total: 0.983ms, +0.019ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 166) where "public"."order"."id" = 166
Affected row(s) : 1
Query executed : Total: 1.231ms
Finishing : Total: 1.255ms, +0.023ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (229, 0) returning "public"."order"."id"
Query executed : Total: 0.785ms
Finishing : Total: 0.076ms
Fetched result : +----+
: | id|
: +----+
: | 167|
: +----+
Finishing : Total: 1.124ms, +0.338ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (167, 72, 18, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.238ms
Finishing : Total: 1.269ms, +0.031ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (167, 79, 41, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.095ms
Finishing : Total: 1.121ms, +0.026ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (167, 72, 5, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.081ms
Finishing : Total: 1.106ms, +0.024ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 167) where "public"."order"."id" = 167
Affected row(s) : 1
Query executed : Total: 0.753ms
Finishing : Total: 0.777ms, +0.023ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (229, 0) returning "public"."order"."id"
Query executed : Total: 0.809ms
Finishing : Total: 0.081ms
Fetched result : +----+
: | id|
: +----+
: | 168|
: +----+
Finishing : Total: 1.178ms, +0.368ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (168, 72, 49, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.321ms
Finishing : Total: 1.602ms, +0.28ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (168, 73, 30, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.103ms
Finishing : Total: 1.13ms, +0.026ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (168, 77, 38, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 1.348ms
Finishing : Total: 1.391ms, +0.042ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 168) where "public"."order"."id" = 168
Affected row(s) : 1
Query executed : Total: 1.169ms
Finishing : Total: 1.197ms, +0.028ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u7') returning "public"."user"."id"
Query executed : Total: 6.303ms
Finishing : Total: 0.064ms
Fetched result : +----+
: | id|
: +----+
: | 230|
: +----+
Finishing : Total: 6.595ms, +0.291ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (230, 0) returning "public"."order"."id"
Query executed : Total: 0.804ms
Finishing : Total: 0.105ms
Fetched result : +----+
: | id|
: +----+
: | 169|
: +----+
Finishing : Total: 1.145ms, +0.34ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (169, 73, 30, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.131ms
Finishing : Total: 1.181ms, +0.049ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (169, 72, 11, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.105ms
Finishing : Total: 1.136ms, +0.03ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (169, 76, 33, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.149ms
Finishing : Total: 1.177ms, +0.027ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 169) where "public"."order"."id" = 169
Affected row(s) : 1
Query executed : Total: 1.23ms
Finishing : Total: 1.276ms, +0.045ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (230, 0) returning "public"."order"."id"
Query executed : Total: 0.681ms
Finishing : Total: 0.069ms
Fetched result : +----+
: | id|
: +----+
: | 170|
: +----+
Finishing : Total: 0.927ms, +0.245ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (170, 73, 40, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.178ms
Finishing : Total: 1.208ms, +0.03ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (170, 78, 48, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 1.258ms
Finishing : Total: 1.292ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (170, 79, 24, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.157ms
Finishing : Total: 1.179ms, +0.022ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 170) where "public"."order"."id" = 170
Affected row(s) : 1
Query executed : Total: 0.956ms
Finishing : Total: 0.974ms, +0.018ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (230, 0) returning "public"."order"."id"
Query executed : Total: 0.68ms
Finishing : Total: 0.054ms
Fetched result : +----+
: | id|
: +----+
: | 171|
: +----+
Finishing : Total: 0.897ms, +0.216ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (171, 78, 34, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 78))
Affected row(s) : 1
Query executed : Total: 0.957ms
Finishing : Total: 0.985ms, +0.028ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (171, 75, 8, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 0.905ms
Finishing : Total: 0.931ms, +0.026ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (171, 75, 27, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 0.982ms
Finishing : Total: 1.004ms, +0.021ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 171) where "public"."order"."id" = 171
Affected row(s) : 1
Query executed : Total: 0.995ms
Finishing : Total: 1.025ms, +0.03ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u8') returning "public"."user"."id"
Query executed : Total: 0.799ms
Finishing : Total: 0.057ms
Fetched result : +----+
: | id|
: +----+
: | 231|
: +----+
Finishing : Total: 1.02ms, +0.221ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (231, 0) returning "public"."order"."id"
Query executed : Total: 0.653ms
Finishing : Total: 0.048ms
Fetched result : +----+
: | id|
: +----+
: | 172|
: +----+
Finishing : Total: 0.883ms, +0.229ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (172, 75, 44, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 1.022ms
Finishing : Total: 1.041ms, +0.019ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (172, 77, 36, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.972ms
Finishing : Total: 0.998ms, +0.025ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (172, 76, 32, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.246ms
Finishing : Total: 1.286ms, +0.039ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 172) where "public"."order"."id" = 172
Affected row(s) : 1
Query executed : Total: 1.043ms
Finishing : Total: 1.068ms, +0.024ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (231, 0) returning "public"."order"."id"
Query executed : Total: 0.607ms
Finishing : Total: 0.055ms
Fetched result : +----+
: | id|
: +----+
: | 173|
: +----+
Finishing : Total: 0.851ms, +0.244ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (173, 77, 8, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.86ms
Finishing : Total: 0.882ms, +0.021ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (173, 75, 36, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 0.796ms
Finishing : Total: 0.815ms, +0.018ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (173, 77, 30, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 77))
Affected row(s) : 1
Query executed : Total: 0.812ms
Finishing : Total: 0.831ms, +0.018ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 173) where "public"."order"."id" = 173
Affected row(s) : 1
Query executed : Total: 1.018ms
Finishing : Total: 1.04ms, +0.021ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (231, 0) returning "public"."order"."id"
Query executed : Total: 0.822ms
Finishing : Total: 0.077ms
Fetched result : +----+
: | id|
: +----+
: | 174|
: +----+
Finishing : Total: 1.155ms, +0.332ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (174, 80, 31, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 1.155ms
Finishing : Total: 1.192ms, +0.036ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (174, 80, 30, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 1.167ms
Finishing : Total: 1.197ms, +0.029ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (174, 72, 9, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.125ms
Finishing : Total: 1.156ms, +0.03ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 174) where "public"."order"."id" = 174
Affected row(s) : 1
Query executed : Total: 1.033ms
Finishing : Total: 1.066ms, +0.033ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u9') returning "public"."user"."id"
Query executed : Total: 0.768ms
Finishing : Total: 0.066ms
Fetched result : +----+
: | id|
: +----+
: | 232|
: +----+
Finishing : Total: 1.131ms, +0.363ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (232, 0) returning "public"."order"."id"
Query executed : Total: 0.709ms
Finishing : Total: 0.073ms
Fetched result : +----+
: | id|
: +----+
: | 175|
: +----+
Finishing : Total: 0.991ms, +0.282ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (175, 76, 43, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 1.064ms
Finishing : Total: 1.095ms, +0.031ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (175, 79, 45, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.162ms
Finishing : Total: 1.196ms, +0.033ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (175, 72, 4, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.122ms
Finishing : Total: 1.153ms, +0.031ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 175) where "public"."order"."id" = 175
Affected row(s) : 1
Query executed : Total: 1.291ms
Finishing : Total: 1.321ms, +0.03ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (232, 0) returning "public"."order"."id"
Query executed : Total: 1.058ms
Finishing : Total: 0.065ms
Fetched result : +----+
: | id|
: +----+
: | 176|
: +----+
Finishing : Total: 1.34ms, +0.281ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (176, 72, 13, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.483ms
Finishing : Total: 1.518ms, +0.034ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (176, 73, 20, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.063ms
Finishing : Total: 1.092ms, +0.028ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (176, 71, 5, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 1.148ms
Finishing : Total: 1.18ms, +0.031ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 176) where "public"."order"."id" = 176
Affected row(s) : 1
Query executed : Total: 1.142ms
Finishing : Total: 1.167ms, +0.025ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (232, 0) returning "public"."order"."id"
Query executed : Total: 0.676ms
Finishing : Total: 0.073ms
Fetched result : +----+
: | id|
: +----+
: | 177|
: +----+
Finishing : Total: 0.972ms, +0.296ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (177, 71, 45, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 71))
Affected row(s) : 1
Query executed : Total: 0.884ms
Finishing : Total: 0.91ms, +0.026ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (177, 72, 23, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 1.0ms
Finishing : Total: 1.038ms, +0.038ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (177, 72, 30, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 72))
Affected row(s) : 1
Query executed : Total: 0.826ms
Finishing : Total: 0.852ms, +0.025ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 177) where "public"."order"."id" = 177
Affected row(s) : 1
Query executed : Total: 0.989ms
Finishing : Total: 1.016ms, +0.026ms
release savepoint
commit
setting auto commit : true
Executing query : insert into "public"."user" ("login") values (?) returning "public"."user"."id"
-> with bind values : insert into "public"."user" ("login") values ('u10') returning "public"."user"."id"
Query executed : Total: 0.84ms
Finishing : Total: 0.072ms
Fetched result : +----+
: | id|
: +----+
: | 233|
: +----+
Finishing : Total: 1.124ms, +0.283ms
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (233, 0) returning "public"."order"."id"
Query executed : Total: 0.871ms
Finishing : Total: 0.052ms
Fetched result : +----+
: | id|
: +----+
: | 178|
: +----+
Finishing : Total: 1.085ms, +0.213ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (178, 76, 24, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 76))
Affected row(s) : 1
Query executed : Total: 0.795ms
Finishing : Total: 0.815ms, +0.02ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (178, 80, 2, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 0.77ms
Finishing : Total: 0.8ms, +0.03ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (178, 74, 10, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 0.757ms
Finishing : Total: 0.78ms, +0.022ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 178) where "public"."order"."id" = 178
Affected row(s) : 1
Query executed : Total: 1.08ms
Finishing : Total: 1.11ms, +0.03ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (233, 0) returning "public"."order"."id"
Query executed : Total: 0.732ms
Finishing : Total: 0.073ms
Fetched result : +----+
: | id|
: +----+
: | 179|
: +----+
Finishing : Total: 1.032ms, +0.299ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (179, 74, 35, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 74))
Affected row(s) : 1
Query executed : Total: 1.075ms
Finishing : Total: 1.102ms, +0.027ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (179, 75, 14, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 75))
Affected row(s) : 1
Query executed : Total: 0.917ms
Finishing : Total: 0.949ms, +0.032ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (179, 79, 14, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 0.862ms
Finishing : Total: 0.901ms, +0.038ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 179) where "public"."order"."id" = 179
Affected row(s) : 1
Query executed : Total: 0.772ms
Finishing : Total: 0.825ms, +0.052ms
release savepoint
commit
setting auto commit : true
setting auto commit : false
set savepoint
Executing query : insert into "public"."order" ("user_id", "total") values (?, ?) returning "public"."order"."id"
-> with bind values : insert into "public"."order" ("user_id", "total") values (233, 0) returning "public"."order"."id"
Query executed : Total: 0.627ms
Finishing : Total: 0.111ms
Fetched result : +----+
: | id|
: +----+
: | 180|
: +----+
Finishing : Total: 1.075ms, +0.447ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (180, 80, 39, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 80))
Affected row(s) : 1
Query executed : Total: 1.11ms
Finishing : Total: 1.143ms, +0.032ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (180, 79, 40, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 79))
Affected row(s) : 1
Query executed : Total: 1.199ms
Finishing : Total: 1.232ms, +0.032ms
Executing query : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (?, ?, ?, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = ?))
-> with bind values : insert into "public"."order_item" ("order_id", "product_id", "quantity", "amount") values (180, 73, 32, (select "public"."product"."price" from "public"."product" where "public"."product"."id" = 73))
Affected row(s) : 1
Query executed : Total: 1.173ms
Finishing : Total: 1.201ms, +0.027ms
Executing query : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = ?) where "public"."order"."id" = ?
-> with bind values : update "public"."order" set "total" = (select sum("public"."order_item"."amount") from "public"."order_item" where "public"."order_item"."order_id" = 180) where "public"."order"."id" = 180
Affected row(s) : 1
Query executed : Total: 1.144ms
Finishing : Total: 1.172ms, +0.027ms
release savepoint
commit
setting auto commit : true
Executing query : select count(*) from "public"."order"
Query executed : Total: 0.92ms
Fetched result : +-----+
: |count|
: +-----+
: | 30|
: +-----+
Finishing : Total: 3.186ms, +2.266ms
Executing query : select "public"."asset"."id" from "public"."asset", "public"."account" where "public"."account"."owner_id" = (select "public"."user"."id" from "public"."user" where "public"."user"."login" = ?)
-> with bind values : select "public"."asset"."id" from "public"."asset", "public"."account" where "public"."account"."owner_id" = (select "public"."user"."id" from "public"."user" where "public"."user"."login" = 'owner')
Query executed : Total: 2.734ms
Fetched result : +----+
: | id|
: +----+
: | 151|
: | 152|
: | 153|
: | 154|
: | 155|
: +----+
: |...85 record(s) truncated...
Finishing : Total: 4.785ms, +2.051ms
Executing query : select distinct "u"."login", "r"."name" as "role_name", "acc"."name" as "account_name" from "public"."asset" as "ast" join "public"."account" as "acc" on "ast"."account_id" = "acc"."id" join "public"."group" as "g" on "g"."account_id" = "acc"."id" join "public"."group_user" as "gu" on "gu"."group_id" = "g"."id" join "public"."user" as "u" on "gu"."user_id" = "u"."id" join "public"."group_role" as "gr" on "gr"."group_id" = "g"."id" join "public"."role" as "r" on "gr"."group_id" = "r"."id" where "r"."name" like ? order by "u"."login" asc
-> with bind values : select distinct "u"."login", "r"."name" as "role_name", "acc"."name" as "account_name" from "public"."asset" as "ast" join "public"."account" as "acc" on "ast"."account_id" = "acc"."id" join "public"."group" as "g" on "g"."account_id" = "acc"."id" join "public"."group_user" as "gu" on "gu"."group_id" = "g"."id" join "public"."user" as "u" on "gu"."user_id" = "u"."id" join "public"."group_role" as "gr" on "gr"."group_id" = "g"."id" join "public"."role" as "r" on "gr"."group_id" = "r"."id" where "r"."name" like 'manage' order by "u"."login" asc
Query executed : Total: 7.667ms
Fetched result : +--------+---------+------------+
: |login |role_name|account_name|
: +--------+---------+------------+
: |user-0-1|manage |Mega Corp |
: |user-0-3|manage |Mega Corp |
: |user-0-5|manage |Mega Corp |
: |user-1-1|manage |Other Corp |
: |user-1-3|manage |Other Corp |
: +--------+---------+------------+
: |...4 record(s) truncated...
Finishing : Total: 8.554ms, +0.886ms
Executing query : select distinct "u"."login", "r"."name" as "role_name", "acc"."name" as "account_name" from "public"."asset" as "ast" join "public"."account" as "acc" on "ast"."account_id" = "acc"."id" join "public"."group" as "g" on "g"."account_id" = "acc"."id" join "public"."group_user" as "gu" on "gu"."group_id" = "g"."id" join "public"."user" as "u" on "gu"."user_id" = "u"."id" join "public"."group_role" as "gr" on "gr"."group_id" = "g"."id" join "public"."role" as "r" on "gr"."group_id" = "r"."id" order by "u"."login" asc
Query executed : Total: 7.071ms
Fetched result : +--------+---------+------------+
: |login |role_name|account_name|
: +--------+---------+------------+
: |user-0-1|basic |Mega Corp |
: |user-0-1|manage |Mega Corp |
: |user-0-2|basic |Mega Corp |
: |user-0-3|basic |Mega Corp |
: |user-0-3|manage |Mega Corp |
: +--------+---------+------------+
: |...19 record(s) truncated...
Finishing : Total: 8.226ms, +1.154ms
===============================================
Custom suite
Total tests run: 1, Failures: 0, Skips: 0
===============================================
Process finished with exit code 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment