| 1 |
0.45 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.is_verified AS is_verified_8, t0.date_time_payant AS date_time_payant_9, t0.date_time_creation AS date_time_creation_10, t0.google_id AS google_id_11, t0.stripe_id AS stripe_id_12, t0.last_pourcentage AS last_pourcentage_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.trusted_version AS trusted_version_15 FROM user t0 WHERE t0.id = 3;
|
| 2 |
0.33 ms |
SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE (s0_.current_period_start < ? AND s0_.current_period_end > ? AND s0_.user_id = ? AND s0_.is_active = ? AND p1_.name = ?) OR p1_.name = ? ORDER BY s0_.current_period_end DESC LIMIT 1
Parameters: [
"2026-02-04 19:31:32"
"2026-02-04 19:31:32"
3
1
"Or"
"Argent"
]
SELECT s0_.id AS id_0, s0_.stripe_id AS stripe_id_1, s0_.current_period_start AS current_period_start_2, s0_.current_period_end AS current_period_end_3, s0_.is_active AS is_active_4, p1_.id AS id_5, p1_.name AS name_6, p1_.slug AS slug_7, p1_.stripe_id AS stripe_id_8, p1_.price AS price_9, p1_.created_at AS created_at_10, p1_.payment_link AS payment_link_11, s0_.plan_id AS plan_id_12, s0_.user_id AS user_id_13 FROM subscription s0_ LEFT JOIN plan p1_ ON s0_.plan_id = p1_.id WHERE (s0_.current_period_start < '2026-02-04 19:31:32' AND s0_.current_period_end > '2026-02-04 19:31:32' AND s0_.user_id = 3 AND s0_.is_active = 1 AND p1_.name = 'Or') OR p1_.name = 'Argent' ORDER BY s0_.current_period_end DESC LIMIT 1;
|
| 4 |
0.29 ms |
INSERT INTO revenu (date, montant_ht, montant_ttc, montant_tps, montant_tvq, pourboire, date_time_creation, numero, mode_paiement_compte, fournisseur, recurrence, ref_recurrence, redevance, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"2026-02-04"
218.0455729
250.7
10.9016895
21.7527376
null
"2026-02-04 19:31:32"
"1909"
"Carte"
"Thibault Cohen"
"aucune"
null
2
3
]
INSERT INTO revenu (date, montant_ht, montant_ttc, montant_tps, montant_tvq, pourboire, date_time_creation, numero, mode_paiement_compte, fournisseur, recurrence, ref_recurrence, redevance, user_id) VALUES ('2026-02-04', 218.0455729, 250.7, 10.9016895, 21.7527376, NULL, '2026-02-04 19:31:32', '1909', 'Carte', 'Thibault Cohen', 'aucune', NULL, 2, 3);
|