| 1 |
0.47 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"paffile488@gmail.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = 'paffile488@gmail.com' LIMIT 1;
|
| 2 |
0.46 ms |
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = ? ORDER BY m0_.id DESC LIMIT 1
SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = 678 ORDER BY m0_.id DESC LIMIT 1;
|
| 3 |
0.42 ms |
SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = ?
SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = 1092;
|
| 4 |
1.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url_image AS url_image_3, t0.dataset_question_id AS dataset_question_id_4, t0.answers AS answers_5, t0.subject_id AS subject_id_6, t7.id AS id_8, t7.content AS content_9, t7.question_id AS question_id_10, t7.user_id AS user_id_11 FROM question t0 LEFT JOIN notes t7 ON t7.question_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.url_image AS url_image_3, t0.dataset_question_id AS dataset_question_id_4, t0.answers AS answers_5, t0.subject_id AS subject_id_6, t7.id AS id_8, t7.content AS content_9, t7.question_id AS question_id_10, t7.user_id AS user_id_11 FROM question t0 LEFT JOIN notes t7 ON t7.question_id = t0.id WHERE t0.id = 471244;
|
| 5 |
0.43 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 6 |
0.89 ms |
INSERT INTO notes (content, question_id, user_id) VALUES (?, ?, ?)
Parameters: [
"saturno è fatto di ghiaccio"
471244
678
]
INSERT INTO notes (content, question_id, user_id) VALUES ('saturno è fatto di ghiaccio', 471244, 678);
|
| 7 |
2.74 ms |
"COMMIT"
|
| 8 |
0.66 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.question_id AS question_id_3, t0.user_id AS user_id_4 FROM notes t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.question_id AS question_id_3, t0.user_id AS user_id_4 FROM notes t0 WHERE t0.id = 42312;
|