8.79 ms (71.72%)
|
1 |
SELECT t0.id AS id_1, t0.checksum AS checksum_2, t0.pdf_information_js_object AS pdf_information_js_object_3 FROM pdfinformation t0 INNER JOIN pdfinformation_in_project_variants ON t0.id = pdfinformation_in_project_variants.pdfinformation_id WHERE pdfinformation_in_project_variants.project_id = ?
SELECT t0.id AS id_1, t0.checksum AS checksum_2, t0.pdf_information_js_object AS pdf_information_js_object_3 FROM pdfinformation t0 INNER JOIN pdfinformation_in_project_variants ON t0.id = pdfinformation_in_project_variants.pdfinformation_id WHERE pdfinformation_in_project_variants.project_id = 105;
|
1.17 ms (9.52%)
|
1 |
"COMMIT"
|
0.51 ms (4.20%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.language AS language_5, t0.is_verified AS is_verified_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.profession AS profession_9, t0.entity AS entity_10, t0.address AS address_11, t0.npa AS npa_12, t0.city AS city_13, t0.discriminator FROM user t0 WHERE t0.id = ? AND t0.discriminator IN ('client')
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.language AS language_5, t0.is_verified AS is_verified_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.profession AS profession_9, t0.entity AS entity_10, t0.address AS address_11, t0.npa AS npa_12, t0.city AS city_13, t0.discriminator FROM user t0 WHERE t0.id = 4 AND t0.discriminator IN ('client');
|
0.51 ms (4.18%)
|
1 |
SELECT count(p0_.id) AS sclr_0 FROM user u1_ INNER JOIN project_in_client p2_ ON u1_.id = p2_.client_id INNER JOIN project p0_ ON p0_.id = p2_.project_id WHERE (u1_.id = ? AND p0_.id = ?) AND u1_.discriminator IN ('client')
SELECT count(p0_.id) AS sclr_0 FROM user u1_ INNER JOIN project_in_client p2_ ON u1_.id = p2_.client_id INNER JOIN project p0_ ON p0_.id = p2_.project_id WHERE (u1_.id = 4 AND p0_.id = 105) AND u1_.discriminator IN ('client');
|
0.44 ms (3.60%)
|
1 |
INSERT INTO pdfinformation (checksum, pdf_information_js_object) VALUES (?, ?)
Parameters: [
"875cb271ca5a568fd3f7333344789e612cf3b8885ad91a1ea97f2921e57fb3b2"
"{"pages":[{"point":{"x":120,"y":717,"z":0},"pageNumber":1,"legend":{"x":100,"y":100,"z":0},"storeyToPrintList":[],"elevationToPrintList":[]}],"checksum":"875cb271ca5a568fd3f7333344789e612cf3b8885ad91a1ea97f2921e57fb3b2","textScale":1,"isPrintLegend":true,"isPrintAreas":true,"isFilterLegendShown":false}"
]
INSERT INTO pdfinformation (checksum, pdf_information_js_object) VALUES ('875cb271ca5a568fd3f7333344789e612cf3b8885ad91a1ea97f2921e57fb3b2', '{\"pages\":[{\"point\":{\"x\":120,\"y\":717,\"z\":0},\"pageNumber\":1,\"legend\":{\"x\":100,\"y\":100,\"z\":0},\"storeyToPrintList\":[],\"elevationToPrintList\":[]}],\"checksum\":\"875cb271ca5a568fd3f7333344789e612cf3b8885ad91a1ea97f2921e57fb3b2\",\"textScale\":1,\"isPrintLegend\":true,\"isPrintAreas\":true,\"isFilterLegendShown\":false}');
|
0.33 ms (2.72%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3 FROM project t0 WHERE t0.id = 105;
|
0.28 ms (2.30%)
|
1 |
INSERT INTO pdfinformation_in_project_variants (project_id, pdfinformation_id) VALUES (?, ?)
INSERT INTO pdfinformation_in_project_variants (project_id, pdfinformation_id) VALUES (105, 64);
|
0.22 ms (1.76%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|