| 1 |
0.40 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.26 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.montant_ht AS montant_ht_3, t0.montant_ttc AS montant_ttc_4, t0.montant_tps AS montant_tps_5, t0.montant_tvq AS montant_tvq_6, t0.pourboire AS pourboire_7, t0.date_time_creation AS date_time_creation_8, t0.numero AS numero_9, t0.mode_paiement_compte AS mode_paiement_compte_10, t0.fournisseur AS fournisseur_11, t0.recurrence AS recurrence_12, t0.ref_recurrence AS ref_recurrence_13, t0.redevance AS redevance_14, t0.user_id AS user_id_15 FROM revenu t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.montant_ht AS montant_ht_3, t0.montant_ttc AS montant_ttc_4, t0.montant_tps AS montant_tps_5, t0.montant_tvq AS montant_tvq_6, t0.pourboire AS pourboire_7, t0.date_time_creation AS date_time_creation_8, t0.numero AS numero_9, t0.mode_paiement_compte AS mode_paiement_compte_10, t0.fournisseur AS fournisseur_11, t0.recurrence AS recurrence_12, t0.ref_recurrence AS ref_recurrence_13, t0.redevance AS redevance_14, t0.user_id AS user_id_15 FROM revenu t0 WHERE t0.id = '1477';
|
| 3 |
0.34 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:33:01"
"2026-02-04 19:33:01"
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:33:01' AND s0_.current_period_end > '2026-02-04 19:33:01' 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.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chemin AS chemin_3, t0.taille AS taille_4, t0.type AS type_5, t0.facture_id AS facture_id_6, t0.revenu_id AS revenu_id_7, t0.vehicule_id AS vehicule_id_8, t0.incident_id AS incident_id_9 FROM piece_jointe t0 WHERE t0.revenu_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chemin AS chemin_3, t0.taille AS taille_4, t0.type AS type_5, t0.facture_id AS facture_id_6, t0.revenu_id AS revenu_id_7, t0.vehicule_id AS vehicule_id_8, t0.incident_id AS incident_id_9 FROM piece_jointe t0 WHERE t0.revenu_id = 1477;
|
| 5 |
0.30 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 = ? ORDER BY s0_.current_period_end DESC LIMIT 1
Parameters: [
"2026-02-04 19:33:01"
"2026-02-04 19:33:01"
3
1
]
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:33:01' AND s0_.current_period_end > '2026-02-04 19:33:01' AND s0_.user_id = 3 AND s0_.is_active = 1 ORDER BY s0_.current_period_end DESC LIMIT 1;
|
| 6 |
0.24 ms |
SELECT t0.id AS id_1, t0.date_time_invit AS date_time_invit_2, t0.date_time_accept AS date_time_accept_3, t0.organisation_id AS organisation_id_4, t0.user_id AS user_id_5, t0.statut_id AS statut_id_6 FROM employe t0 WHERE t0.user_id = ? AND t0.organisation_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.date_time_invit AS date_time_invit_2, t0.date_time_accept AS date_time_accept_3, t0.organisation_id AS organisation_id_4, t0.user_id AS user_id_5, t0.statut_id AS statut_id_6 FROM employe t0 WHERE t0.user_id = 3 AND t0.organisation_id = 5 LIMIT 1;
|