1
1.27 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . pseudo AS pseudo_3 , t0 . licence AS licence_4 , t0 . id_dupr AS id_dupr_5 , t0 . genre AS genre_6 , t0 . nom AS nom_7 , t0 . prenom AS prenom_8 , t0 . date_de_naissance AS date_de_naissance_9 , t0 . ville AS ville_10 , t0 . description AS description_11 , t0 . telephone AS telephone_12 , t0 . instagram AS instagram_13 , t0 . linkedin AS linkedin_14 , t0 . tiktok AS tiktok_15 , t0 . twitter AS twitter_16 , t0 . facebook AS facebook_17 , t0 . statut AS statut_18 , t0 . roles AS roles_19 , t0 . password AS password_20 , t0 . indicateur AS indicateur_21 , t0 . createur AS createur_22 , t0 . pays_id AS pays_id_23 , t0 . niveau_simple_id AS niveau_simple_id_24 , t0 . niveau_double_id AS niveau_double_id_25 , t0 . niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . pseudo AS pseudo_3 , t0 . licence AS licence_4 , t0 . id_dupr AS id_dupr_5 , t0 . genre AS genre_6 , t0 . nom AS nom_7 , t0 . prenom AS prenom_8 , t0 . date_de_naissance AS date_de_naissance_9 , t0 . ville AS ville_10 , t0 . description AS description_11 , t0 . telephone AS telephone_12 , t0 . instagram AS instagram_13 , t0 . linkedin AS linkedin_14 , t0 . tiktok AS tiktok_15 , t0 . twitter AS twitter_16 , t0 . facebook AS facebook_17 , t0 . statut AS statut_18 , t0 . roles AS roles_19 , t0 . password AS password_20 , t0 . indicateur AS indicateur_21 , t0 . createur AS createur_22 , t0 . pays_id AS pays_id_23 , t0 . niveau_simple_id AS niveau_simple_id_24 , t0 . niveau_double_id AS niveau_double_id_25 , t0 . niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0 . id = 5748 ;
Copy
2
1.15 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . creation AS creation_4 , t0 . termine AS termine_5 , t0 . date_creation AS date_creation_6 , t0 . encours AS encours_7 , t0 . publier AS publier_8 , t0 . homologuer_fft AS homologuer_fft_9 , t0 . demander_id_dupr AS demander_id_dupr_10 , t0 . etat_actuel AS etat_actuel_11 , t0 . config_id AS config_id_12 , t0 . organisateur_id AS organisateur_id_13 , t0 . style_id AS style_id_14 FROM evenement t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . creation AS creation_4 , t0 . termine AS termine_5 , t0 . date_creation AS date_creation_6 , t0 . encours AS encours_7 , t0 . publier AS publier_8 , t0 . homologuer_fft AS homologuer_fft_9 , t0 . demander_id_dupr AS demander_id_dupr_10 , t0 . etat_actuel AS etat_actuel_11 , t0 . config_id AS config_id_12 , t0 . organisateur_id AS organisateur_id_13 , t0 . style_id AS style_id_14 FROM evenement t0 WHERE t0 . id = 2 ;
Copy
3
1.45 ms
SELECT t0 . id AS id_1 , t0 . date_debut AS date_debut_2 , t0 . fin_inscription AS fin_inscription_3 , t0 . nb_joueur AS nb_joueur_4 , t0 . date_fin AS date_fin_5 , t0 . adresse AS adresse_6 , t0 . complement AS complement_7 , t0 . cp AS cp_8 , t0 . ville AS ville_9 , t0 . pays AS pays_10 , t0 . map AS map_11 , t0 . nb_joueur_max AS nb_joueur_max_12 , t0 . nb_equipe_max AS nb_equipe_max_13 , t0 . terrain_interieur AS terrain_interieur_14 , t0 . terrain_exterieur AS terrain_exterieur_15 , t0 . type_balle AS type_balle_16 , t0 . nb_joueur_par_equipe AS nb_joueur_par_equipe_17 , t0 . montant_repas AS montant_repas_18 , t0 . devise AS devise_19 , t0 . nb_journee_previsionnel AS nb_journee_previsionnel_20 , t0 . prizepool AS prizepool_21 , t0 . nb_match_par_rencontre AS nb_match_par_rencontre_22 , t0 . datas_victoire AS datas_victoire_23 , t0 . points_victoire AS points_victoire_24 , t0 . points_defaite AS points_defaite_25 , t0 . points_nul AS points_nul_26 , t0 . categorie AS categorie_27 , t28 . id AS id_29 , t28 . titre AS titre_30 , t28 . description AS description_31 , t28 . creation AS creation_32 , t28 . termine AS termine_33 , t28 . date_creation AS date_creation_34 , t28 . encours AS encours_35 , t28 . publier AS publier_36 , t28 . homologuer_fft AS homologuer_fft_37 , t28 . demander_id_dupr AS demander_id_dupr_38 , t28 . etat_actuel AS etat_actuel_39 , t28 . config_id AS config_id_40 , t28 . organisateur_id AS organisateur_id_41 , t28 . style_id AS style_id_42 FROM config t0 LEFT JOIN evenement t28 ON t28 . config_id = t0 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . date_debut AS date_debut_2 ,
t0 . fin_inscription AS fin_inscription_3 ,
t0 . nb_joueur AS nb_joueur_4 ,
t0 . date_fin AS date_fin_5 ,
t0 . adresse AS adresse_6 ,
t0 . complement AS complement_7 ,
t0 . cp AS cp_8 ,
t0 . ville AS ville_9 ,
t0 . pays AS pays_10 ,
t0 . map AS map_11 ,
t0 . nb_joueur_max AS nb_joueur_max_12 ,
t0 . nb_equipe_max AS nb_equipe_max_13 ,
t0 . terrain_interieur AS terrain_interieur_14 ,
t0 . terrain_exterieur AS terrain_exterieur_15 ,
t0 . type_balle AS type_balle_16 ,
t0 . nb_joueur_par_equipe AS nb_joueur_par_equipe_17 ,
t0 . montant_repas AS montant_repas_18 ,
t0 . devise AS devise_19 ,
t0 . nb_journee_previsionnel AS nb_journee_previsionnel_20 ,
t0 . prizepool AS prizepool_21 ,
t0 . nb_match_par_rencontre AS nb_match_par_rencontre_22 ,
t0 . datas_victoire AS datas_victoire_23 ,
t0 . points_victoire AS points_victoire_24 ,
t0 . points_defaite AS points_defaite_25 ,
t0 . points_nul AS points_nul_26 ,
t0 . categorie AS categorie_27 ,
t28 . id AS id_29 ,
t28 . titre AS titre_30 ,
t28 . description AS description_31 ,
t28 . creation AS creation_32 ,
t28 . termine AS termine_33 ,
t28 . date_creation AS date_creation_34 ,
t28 . encours AS encours_35 ,
t28 . publier AS publier_36 ,
t28 . homologuer_fft AS homologuer_fft_37 ,
t28 . demander_id_dupr AS demander_id_dupr_38 ,
t28 . etat_actuel AS etat_actuel_39 ,
t28 . config_id AS config_id_40 ,
t28 . organisateur_id AS organisateur_id_41 ,
t28 . style_id AS style_id_42
FROM
config t0
LEFT JOIN evenement t28 ON t28 . config_id = t0 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . date_debut AS date_debut_2 , t0 . fin_inscription AS fin_inscription_3 , t0 . nb_joueur AS nb_joueur_4 , t0 . date_fin AS date_fin_5 , t0 . adresse AS adresse_6 , t0 . complement AS complement_7 , t0 . cp AS cp_8 , t0 . ville AS ville_9 , t0 . pays AS pays_10 , t0 . map AS map_11 , t0 . nb_joueur_max AS nb_joueur_max_12 , t0 . nb_equipe_max AS nb_equipe_max_13 , t0 . terrain_interieur AS terrain_interieur_14 , t0 . terrain_exterieur AS terrain_exterieur_15 , t0 . type_balle AS type_balle_16 , t0 . nb_joueur_par_equipe AS nb_joueur_par_equipe_17 , t0 . montant_repas AS montant_repas_18 , t0 . devise AS devise_19 , t0 . nb_journee_previsionnel AS nb_journee_previsionnel_20 , t0 . prizepool AS prizepool_21 , t0 . nb_match_par_rencontre AS nb_match_par_rencontre_22 , t0 . datas_victoire AS datas_victoire_23 , t0 . points_victoire AS points_victoire_24 , t0 . points_defaite AS points_defaite_25 , t0 . points_nul AS points_nul_26 , t0 . categorie AS categorie_27 , t28 . id AS id_29 , t28 . titre AS titre_30 , t28 . description AS description_31 , t28 . creation AS creation_32 , t28 . termine AS termine_33 , t28 . date_creation AS date_creation_34 , t28 . encours AS encours_35 , t28 . publier AS publier_36 , t28 . homologuer_fft AS homologuer_fft_37 , t28 . demander_id_dupr AS demander_id_dupr_38 , t28 . etat_actuel AS etat_actuel_39 , t28 . config_id AS config_id_40 , t28 . organisateur_id AS organisateur_id_41 , t28 . style_id AS style_id_42 FROM config t0 LEFT JOIN evenement t28 ON t28 . config_id = t0 . id WHERE t0 . id = 2 ;
Copy
4
1.18 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . prix AS prix_3 , t0 . metadata AS metadata_4 , t0 . jour AS jour_5 , t0 . id_epreuve_id AS id_epreuve_id_6 , t0 . id_age_id AS id_age_id_7 , t0 . id_niveau_id AS id_niveau_id_8 , t0 . id_forme_id AS id_forme_id_9 , t0 . config_id AS config_id_10 , t0 . evenement_id AS evenement_id_11 FROM selection t0 WHERE t0 . config_id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . prix AS prix_3 , t0 . metadata AS metadata_4 , t0 . jour AS jour_5 , t0 . id_epreuve_id AS id_epreuve_id_6 , t0 . id_age_id AS id_age_id_7 , t0 . id_niveau_id AS id_niveau_id_8 , t0 . id_forme_id AS id_forme_id_9 , t0 . config_id AS config_id_10 , t0 . evenement_id AS evenement_id_11 FROM selection t0 WHERE t0 . config_id = 2 ;
Copy
8
1.07 ms
SELECT t0 . id AS id_1 , t0 . stripe_session_id AS stripe_session_id_2 , t0 . stripe_payment_intent_id AS stripe_payment_intent_id_3 , t0 . montant_total AS montant_total_4 , t0 . montant_epreuves AS montant_epreuves_5 , t0 . montant_repas AS montant_repas_6 , t0 . nb_repas AS nb_repas_7 , t0 . code_promo AS code_promo_8 , t0 . montant_reduction AS montant_reduction_9 , t0 . date_paiement AS date_paiement_10 , t0 . status AS status_11 , t0 . metadata AS metadata_12 , t0 . user_id AS user_id_13 , t0 . evenement_id AS evenement_id_14 FROM payment t0 WHERE t0 . user_id = ? AND t0 . evenement_id = ? AND t0 . status = ?
Parameters :
[
5748
2
"completed "
]
SELECT t0 . id AS id_1 , t0 . stripe_session_id AS stripe_session_id_2 , t0 . stripe_payment_intent_id AS stripe_payment_intent_id_3 , t0 . montant_total AS montant_total_4 , t0 . montant_epreuves AS montant_epreuves_5 , t0 . montant_repas AS montant_repas_6 , t0 . nb_repas AS nb_repas_7 , t0 . code_promo AS code_promo_8 , t0 . montant_reduction AS montant_reduction_9 , t0 . date_paiement AS date_paiement_10 , t0 . status AS status_11 , t0 . metadata AS metadata_12 , t0 . user_id AS user_id_13 , t0 . evenement_id AS evenement_id_14 FROM payment t0 WHERE t0 . user_id = 5748 AND t0 . evenement_id = 2 AND t0 . status = 'completed' ;
Copy