Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.is_verified AS is_verified_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.username AS username_7,
  t0.token AS token_8,
  t0.token_mdp AS token_mdp_9,
  t0.desactivation_compte AS desactivation_compte_10,
  t0.created_at AS created_at_11,
  t0.refus_campagne AS refus_campagne_12,
  t0.compte_finalise AS compte_finalise_13,
  t0.coordonnees_id AS coordonnees_id_14,
  t0.info_allocataire_id AS info_allocataire_id_15,
  t16.id AS id_17,
  t16.date_naissance AS date_naissance_18,
  t16.pays_naissance AS pays_naissance_19,
  t16.code_postal_naissance AS code_postal_naissance_20,
  t16.commune_naissance AS commune_naissance_21,
  t16.numero_securite_social AS numero_securite_social_22,
  t16.intitule_poste AS intitule_poste_23,
  t16.nom_photo AS nom_photo_24,
  t16.updated_at_photo AS updated_at_photo_25,
  t16.notes AS notes_26,
  t16.code_insee AS code_insee_27,
  t16.user_id AS user_id_28,
  t16.statut_employe_id AS statut_employe_id_29
FROM
  user t0
  LEFT JOIN animateur t16 ON t16.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.token AS token_8, t0.token_mdp AS token_mdp_9, t0.desactivation_compte AS desactivation_compte_10, t0.created_at AS created_at_11, t0.refus_campagne AS refus_campagne_12, t0.compte_finalise AS compte_finalise_13, t0.coordonnees_id AS coordonnees_id_14, t0.info_allocataire_id AS info_allocataire_id_15, t16.id AS id_17, t16.date_naissance AS date_naissance_18, t16.pays_naissance AS pays_naissance_19, t16.code_postal_naissance AS code_postal_naissance_20, t16.commune_naissance AS commune_naissance_21, t16.numero_securite_social AS numero_securite_social_22, t16.intitule_poste AS intitule_poste_23, t16.nom_photo AS nom_photo_24, t16.updated_at_photo AS updated_at_photo_25, t16.notes AS notes_26, t16.code_insee AS code_insee_27, t16.user_id AS user_id_28, t16.statut_employe_id AS statut_employe_id_29 FROM user t0 LEFT JOIN animateur t16 ON t16.user_id = t0.id WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.nom_sejour AS nom_sejour_2,
  t0.age_min AS age_min_3,
  t0.age_max AS age_max_4,
  t0.date_debut AS date_debut_5,
  t0.date_fin AS date_fin_6,
  t0.description AS description_7,
  t0.nbplace AS nbplace_8,
  t0.montant_acompte AS montant_acompte_9,
  t0.hebergement AS hebergement_10,
  t0.justificatif_suplementaire AS justificatif_suplementaire_11,
  t0.nom_image_principale AS nom_image_principale_12,
  t0.updated_at AS updated_at_13,
  t0.type_activite AS type_activite_14,
  t0.nb_places_prises AS nb_places_prises_15,
  t0.date_delai_reservation AS date_delai_reservation_16,
  t0.date_delai_annulation AS date_delai_annulation_17,
  t0.statut AS statut_18,
  t0.total_liste_attente AS total_liste_attente_19,
  t0.recurrence AS recurrence_20,
  t0.type_recurrence AS type_recurrence_21,
  t0.numero_declaration_sdjes AS numero_declaration_sdjes_22,
  t0.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_23,
  t0.categorie_id AS categorie_id_24,
  t0.coordonnees_id AS coordonnees_id_25,
  t0.semaine_recurrence_id AS semaine_recurrence_id_26
FROM
  sejour t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_sejour AS nom_sejour_2, t0.age_min AS age_min_3, t0.age_max AS age_max_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.description AS description_7, t0.nbplace AS nbplace_8, t0.montant_acompte AS montant_acompte_9, t0.hebergement AS hebergement_10, t0.justificatif_suplementaire AS justificatif_suplementaire_11, t0.nom_image_principale AS nom_image_principale_12, t0.updated_at AS updated_at_13, t0.type_activite AS type_activite_14, t0.nb_places_prises AS nb_places_prises_15, t0.date_delai_reservation AS date_delai_reservation_16, t0.date_delai_annulation AS date_delai_annulation_17, t0.statut AS statut_18, t0.total_liste_attente AS total_liste_attente_19, t0.recurrence AS recurrence_20, t0.type_recurrence AS type_recurrence_21, t0.numero_declaration_sdjes AS numero_declaration_sdjes_22, t0.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_23, t0.categorie_id AS categorie_id_24, t0.coordonnees_id AS coordonnees_id_25, t0.semaine_recurrence_id AS semaine_recurrence_id_26 FROM sejour t0 WHERE t0.id = 81 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom_site AS nom_site_2,
  t0.url AS url_3,
  t0.nom_logo AS nom_logo_4,
  t0.date_maj_logo AS date_maj_logo_5,
  t0.description AS description_6,
  t0.conditions_generales_services AS conditions_generales_services_7,
  t0.nom_img_description AS nom_img_description_8,
  t0.date_maj_description AS date_maj_description_9,
  t0.nom_structure AS nom_structure_10,
  t0.mail_reception_automatique AS mail_reception_automatique_11,
  t0.a_prix_commune AS a_prix_commune_12,
  t0.prix_par_quotients AS prix_par_quotients_13,
  t0.url_facebook AS url_facebook_14,
  t0.url_instagram AS url_instagram_15,
  t0.url_twitter AS url_twitter_16,
  t0.url_site_web_structure AS url_site_web_structure_17,
  t0.utilise_hebergements AS utilise_hebergements_18,
  t0.type_activite AS type_activite_19,
  t0.validation_reservation_par_defaut AS validation_reservation_par_defaut_20,
  t0.a_delai_blocage_reservation AS a_delai_blocage_reservation_21,
  t0.nbre_unites_temps_blocage_reservation AS nbre_unites_temps_blocage_reservation_22,
  t0.validation_annulation_par_defaut AS validation_annulation_par_defaut_23,
  t0.a_delai_blocage_annulation AS a_delai_blocage_annulation_24,
  t0.nbre_unites_temps_blocage_annulation AS nbre_unites_temps_blocage_annulation_25,
  t0.nbre_unites_temps_validite_avoir AS nbre_unites_temps_validite_avoir_26,
  t0.nom_responsable AS nom_responsable_27,
  t0.code_siren AS code_siren_28,
  t0.forme_juridique AS forme_juridique_29,
  t0.date_immatriculation AS date_immatriculation_30,
  t0.code_apenaf AS code_apenaf_31,
  t0.num_tva AS num_tva_32,
  t0.fonction_responsable AS fonction_responsable_33,
  t0.nom_directeur AS nom_directeur_34,
  t0.unite_presence_accueil AS unite_presence_accueil_35,
  t0.auto_increment_facture AS auto_increment_facture_36,
  t0.auto_increment_avoir AS auto_increment_avoir_37,
  t0.tva_applicable AS tva_applicable_38,
  t0.cle_publique_mailjet AS cle_publique_mailjet_39,
  t0.cle_secrete_mailjet AS cle_secrete_mailjet_40,
  t0.mail_envoi_mailjet AS mail_envoi_mailjet_41,
  t0.id_template_campagne AS id_template_campagne_42,
  t0.taux_tva AS taux_tva_43,
  t0.auto_increment_avoirs AS auto_increment_avoirs_44,
  t0.liste_attente AS liste_attente_45,
  t0.nbre_unites_temps_liste_attente AS nbre_unites_temps_liste_attente_46,
  t0.id_site_noyau AS id_site_noyau_47,
  t0.asso_token_api_basicompta AS asso_token_api_basicompta_48,
  t0.token_api_basicompta AS token_api_basicompta_49,
  t0.created_interco_basicompta AS created_interco_basicompta_50,
  t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_51,
  t0.forfait_demi_journee AS forfait_demi_journee_52,
  t0.forfait_journee AS forfait_journee_53,
  t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_54,
  t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_55,
  t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_56,
  t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_57,
  t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_58,
  t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_59,
  t0.desactivation_qf AS desactivation_qf_60,
  t0.nom_tampon AS nom_tampon_61,
  t0.fonction_directeur AS fonction_directeur_62,
  t0.inscription_adultes AS inscription_adultes_63,
  t0.unite_presence_sejour AS unite_presence_sejour_64,
  t0.token_basicompta AS token_basicompta_65,
  t0.adhesions AS adhesions_66,
  t0.coordonnee_id AS coordonnee_id_67,
  t0.commune_rabais_id AS commune_rabais_id_68,
  t0.unite_temps_blocage_reservation_id AS unite_temps_blocage_reservation_id_69,
  t0.unite_temps_blocage_annulation_id AS unite_temps_blocage_annulation_id_70,
  t0.unite_temps_validite_avoir_id AS unite_temps_validite_avoir_id_71,
  t0.unite_temps_liste_attente_id AS unite_temps_liste_attente_id_72
FROM
  variables t0

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url AS url_3, t0.nom_logo AS nom_logo_4, t0.date_maj_logo AS date_maj_logo_5, t0.description AS description_6, t0.conditions_generales_services AS conditions_generales_services_7, t0.nom_img_description AS nom_img_description_8, t0.date_maj_description AS date_maj_description_9, t0.nom_structure AS nom_structure_10, t0.mail_reception_automatique AS mail_reception_automatique_11, t0.a_prix_commune AS a_prix_commune_12, t0.prix_par_quotients AS prix_par_quotients_13, t0.url_facebook AS url_facebook_14, t0.url_instagram AS url_instagram_15, t0.url_twitter AS url_twitter_16, t0.url_site_web_structure AS url_site_web_structure_17, t0.utilise_hebergements AS utilise_hebergements_18, t0.type_activite AS type_activite_19, t0.validation_reservation_par_defaut AS validation_reservation_par_defaut_20, t0.a_delai_blocage_reservation AS a_delai_blocage_reservation_21, t0.nbre_unites_temps_blocage_reservation AS nbre_unites_temps_blocage_reservation_22, t0.validation_annulation_par_defaut AS validation_annulation_par_defaut_23, t0.a_delai_blocage_annulation AS a_delai_blocage_annulation_24, t0.nbre_unites_temps_blocage_annulation AS nbre_unites_temps_blocage_annulation_25, t0.nbre_unites_temps_validite_avoir AS nbre_unites_temps_validite_avoir_26, t0.nom_responsable AS nom_responsable_27, t0.code_siren AS code_siren_28, t0.forme_juridique AS forme_juridique_29, t0.date_immatriculation AS date_immatriculation_30, t0.code_apenaf AS code_apenaf_31, t0.num_tva AS num_tva_32, t0.fonction_responsable AS fonction_responsable_33, t0.nom_directeur AS nom_directeur_34, t0.unite_presence_accueil AS unite_presence_accueil_35, t0.auto_increment_facture AS auto_increment_facture_36, t0.auto_increment_avoir AS auto_increment_avoir_37, t0.tva_applicable AS tva_applicable_38, t0.cle_publique_mailjet AS cle_publique_mailjet_39, t0.cle_secrete_mailjet AS cle_secrete_mailjet_40, t0.mail_envoi_mailjet AS mail_envoi_mailjet_41, t0.id_template_campagne AS id_template_campagne_42, t0.taux_tva AS taux_tva_43, t0.auto_increment_avoirs AS auto_increment_avoirs_44, t0.liste_attente AS liste_attente_45, t0.nbre_unites_temps_liste_attente AS nbre_unites_temps_liste_attente_46, t0.id_site_noyau AS id_site_noyau_47, t0.asso_token_api_basicompta AS asso_token_api_basicompta_48, t0.token_api_basicompta AS token_api_basicompta_49, t0.created_interco_basicompta AS created_interco_basicompta_50, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_51, t0.forfait_demi_journee AS forfait_demi_journee_52, t0.forfait_journee AS forfait_journee_53, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_54, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_55, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_56, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_57, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_58, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_59, t0.desactivation_qf AS desactivation_qf_60, t0.nom_tampon AS nom_tampon_61, t0.fonction_directeur AS fonction_directeur_62, t0.inscription_adultes AS inscription_adultes_63, t0.unite_presence_sejour AS unite_presence_sejour_64, t0.token_basicompta AS token_basicompta_65, t0.adhesions AS adhesions_66, t0.coordonnee_id AS coordonnee_id_67, t0.commune_rabais_id AS commune_rabais_id_68, t0.unite_temps_blocage_reservation_id AS unite_temps_blocage_reservation_id_69, t0.unite_temps_blocage_annulation_id AS unite_temps_blocage_annulation_id_70, t0.unite_temps_validite_avoir_id AS unite_temps_validite_avoir_id_71, t0.unite_temps_liste_attente_id AS unite_temps_liste_attente_id_72 FROM variables t0;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.statut_reservation AS statut_reservation_4,
  t0.montant_total AS montant_total_5,
  t0.montant_acompte AS montant_acompte_6,
  t0.valide AS valide_7,
  t0.statut AS statut_8,
  t0.archive AS archive_9,
  t0.num_liste_attente AS num_liste_attente_10,
  t0.plus_de_six_ans AS plus_de_six_ans_11,
  t0.numero_attestation_presence AS numero_attestation_presence_12,
  t0.utilisateur_id AS utilisateur_id_13,
  t0.enfant_id AS enfant_id_14,
  t0.activite_id AS activite_id_15,
  t0.commande_id AS commande_id_16,
  t0.annulation_id AS annulation_id_17,
  t0.presence_sejour_id AS presence_sejour_id_18,
  t0.tarif_id AS tarif_id_19
FROM
  reservation t0
WHERE
  t0.utilisateur_id = ?
  AND t0.statut_reservation = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut_reservation AS statut_reservation_4, t0.montant_total AS montant_total_5, t0.montant_acompte AS montant_acompte_6, t0.valide AS valide_7, t0.statut AS statut_8, t0.archive AS archive_9, t0.num_liste_attente AS num_liste_attente_10, t0.plus_de_six_ans AS plus_de_six_ans_11, t0.numero_attestation_presence AS numero_attestation_presence_12, t0.utilisateur_id AS utilisateur_id_13, t0.enfant_id AS enfant_id_14, t0.activite_id AS activite_id_15, t0.commande_id AS commande_id_16, t0.annulation_id AS annulation_id_17, t0.presence_sejour_id AS presence_sejour_id_18, t0.tarif_id AS tarif_id_19 FROM reservation t0 WHERE t0.utilisateur_id = 14 AND t0.statut_reservation = 'panier';

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.statut_reservation AS statut_reservation_4,
  t0.montant_total AS montant_total_5,
  t0.montant_acompte AS montant_acompte_6,
  t0.valide AS valide_7,
  t0.statut AS statut_8,
  t0.archive AS archive_9,
  t0.num_liste_attente AS num_liste_attente_10,
  t0.plus_de_six_ans AS plus_de_six_ans_11,
  t0.numero_attestation_presence AS numero_attestation_presence_12,
  t0.utilisateur_id AS utilisateur_id_13,
  t0.enfant_id AS enfant_id_14,
  t0.activite_id AS activite_id_15,
  t0.commande_id AS commande_id_16,
  t0.annulation_id AS annulation_id_17,
  t0.presence_sejour_id AS presence_sejour_id_18,
  t0.tarif_id AS tarif_id_19
FROM
  reservation t0
WHERE
  t0.activite_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut_reservation AS statut_reservation_4, t0.montant_total AS montant_total_5, t0.montant_acompte AS montant_acompte_6, t0.valide AS valide_7, t0.statut AS statut_8, t0.archive AS archive_9, t0.num_liste_attente AS num_liste_attente_10, t0.plus_de_six_ans AS plus_de_six_ans_11, t0.numero_attestation_presence AS numero_attestation_presence_12, t0.utilisateur_id AS utilisateur_id_13, t0.enfant_id AS enfant_id_14, t0.activite_id AS activite_id_15, t0.commande_id AS commande_id_16, t0.annulation_id AS annulation_id_17, t0.presence_sejour_id AS presence_sejour_id_18, t0.tarif_id AS tarif_id_19 FROM reservation t0 WHERE t0.activite_id = 81;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'bdd_awa'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'bdd_awa'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'bdd_awa' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'bdd_awa' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'bdd_awa' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bdd_awa' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'bdd_awa' AND t.TABLE_SCHEMA = 'bdd_awa' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'bdd_awa' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.num_allocataire AS num_allocataire_2,
  t0.quotient_familial AS quotient_familial_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.fichier_size AS fichier_size_5,
  t0.updated_at AS updated_at_6,
  t0.qf_inconnu AS qf_inconnu_7,
  t0.regime_num_alloc_inconnu AS regime_num_alloc_inconnu_8,
  t0.qf_valide AS qf_valide_9,
  t0.validation_prioritaire AS validation_prioritaire_10,
  t0.type_regime_id AS type_regime_id_11,
  t12.id AS id_13,
  t12.roles AS roles_14,
  t12.password AS password_15,
  t12.is_verified AS is_verified_16,
  t12.nom AS nom_17,
  t12.prenom AS prenom_18,
  t12.username AS username_19,
  t12.token AS token_20,
  t12.token_mdp AS token_mdp_21,
  t12.desactivation_compte AS desactivation_compte_22,
  t12.created_at AS created_at_23,
  t12.refus_campagne AS refus_campagne_24,
  t12.compte_finalise AS compte_finalise_25,
  t12.coordonnees_id AS coordonnees_id_26,
  t12.info_allocataire_id AS info_allocataire_id_27
FROM
  info_allocataire t0
  LEFT JOIN user t12 ON t12.info_allocataire_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.num_allocataire AS num_allocataire_2, t0.quotient_familial AS quotient_familial_3, t0.nom_fichier AS nom_fichier_4, t0.fichier_size AS fichier_size_5, t0.updated_at AS updated_at_6, t0.qf_inconnu AS qf_inconnu_7, t0.regime_num_alloc_inconnu AS regime_num_alloc_inconnu_8, t0.qf_valide AS qf_valide_9, t0.validation_prioritaire AS validation_prioritaire_10, t0.type_regime_id AS type_regime_id_11, t12.id AS id_13, t12.roles AS roles_14, t12.password AS password_15, t12.is_verified AS is_verified_16, t12.nom AS nom_17, t12.prenom AS prenom_18, t12.username AS username_19, t12.token AS token_20, t12.token_mdp AS token_mdp_21, t12.desactivation_compte AS desactivation_compte_22, t12.created_at AS created_at_23, t12.refus_campagne AS refus_campagne_24, t12.compte_finalise AS compte_finalise_25, t12.coordonnees_id AS coordonnees_id_26, t12.info_allocataire_id AS info_allocataire_id_27 FROM info_allocataire t0 LEFT JOIN user t12 ON t12.info_allocataire_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.statut_reservation AS statut_reservation_4,
  t0.montant_total AS montant_total_5,
  t0.montant_acompte AS montant_acompte_6,
  t0.valide AS valide_7,
  t0.statut AS statut_8,
  t0.archive AS archive_9,
  t0.num_liste_attente AS num_liste_attente_10,
  t0.plus_de_six_ans AS plus_de_six_ans_11,
  t0.numero_attestation_presence AS numero_attestation_presence_12,
  t0.utilisateur_id AS utilisateur_id_13,
  t0.enfant_id AS enfant_id_14,
  t0.activite_id AS activite_id_15,
  t0.commande_id AS commande_id_16,
  t0.annulation_id AS annulation_id_17,
  t0.presence_sejour_id AS presence_sejour_id_18,
  t0.tarif_id AS tarif_id_19
FROM
  reservation t0
WHERE
  t0.utilisateur_id = ?
  AND t0.statut_reservation = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut_reservation AS statut_reservation_4, t0.montant_total AS montant_total_5, t0.montant_acompte AS montant_acompte_6, t0.valide AS valide_7, t0.statut AS statut_8, t0.archive AS archive_9, t0.num_liste_attente AS num_liste_attente_10, t0.plus_de_six_ans AS plus_de_six_ans_11, t0.numero_attestation_presence AS numero_attestation_presence_12, t0.utilisateur_id AS utilisateur_id_13, t0.enfant_id AS enfant_id_14, t0.activite_id AS activite_id_15, t0.commande_id AS commande_id_16, t0.annulation_id AS annulation_id_17, t0.presence_sejour_id AS presence_sejour_id_18, t0.tarif_id AS tarif_id_19 FROM reservation t0 WHERE t0.utilisateur_id = 14 AND t0.statut_reservation = 'panier';

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commune AS commune_3,
  t0.plein_tarif AS plein_tarif_4,
  t0.nom AS nom_5,
  t0.type_duree_id AS type_duree_id_6
FROM
  tarif t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commune AS commune_3, t0.plein_tarif AS plein_tarif_4, t0.nom AS nom_5, t0.type_duree_id AS type_duree_id_6 FROM tarif t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.sexe AS sexe_4,
  t0.date_naissance AS date_naissance_5,
  t0.autres_allergies AS autres_allergies_6,
  t0.remarques_medicales AS remarques_medicales_7,
  t0.suivi_traitement AS suivi_traitement_8,
  t0.traitement AS traitement_9,
  t0.nom_ordonnance AS nom_ordonnance_10,
  t0.updated_at AS updated_at_11,
  t0.nom_photo AS nom_photo_12,
  t0.updated_at_photo AS updated_at_photo_13,
  t0.autorisation_photo AS autorisation_photo_14,
  t0.aeeh AS aeeh_15,
  t0.est_utilisateur AS est_utilisateur_16
FROM
  enfant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.date_naissance AS date_naissance_5, t0.autres_allergies AS autres_allergies_6, t0.remarques_medicales AS remarques_medicales_7, t0.suivi_traitement AS suivi_traitement_8, t0.traitement AS traitement_9, t0.nom_ordonnance AS nom_ordonnance_10, t0.updated_at AS updated_at_11, t0.nom_photo AS nom_photo_12, t0.updated_at_photo AS updated_at_photo_13, t0.autorisation_photo AS autorisation_photo_14, t0.aeeh AS aeeh_15, t0.est_utilisateur AS est_utilisateur_16 FROM enfant t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.statut AS statut_4,
  t0.montant AS montant_5,
  t0.statut_annulation AS statut_annulation_6,
  t0.adhesion_id AS adhesion_id_7,
  t0.utilisateur_id AS utilisateur_id_8,
  t0.personne_id AS personne_id_9,
  t0.commande_id AS commande_id_10,
  t0.annulation_id AS annulation_id_11
FROM
  adhesion_utilisateur t0
WHERE
  t0.utilisateur_id = ?
  AND t0.statut = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut AS statut_4, t0.montant AS montant_5, t0.statut_annulation AS statut_annulation_6, t0.adhesion_id AS adhesion_id_7, t0.utilisateur_id AS utilisateur_id_8, t0.personne_id AS personne_id_9, t0.commande_id AS commande_id_10, t0.annulation_id AS annulation_id_11 FROM adhesion_utilisateur t0 WHERE t0.utilisateur_id = 14 AND t0.statut = 'panier';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.type AS type_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.concerne AS concerne_6,
  t0.age_min AS age_min_7,
  t0.age_max AS age_max_8,
  t0.tarif AS tarif_9,
  t0.obligatoire AS obligatoire_10,
  t0.archive AS archive_11
FROM
  adhesion t0
  INNER JOIN adhesion_sejour ON t0.id = adhesion_sejour.adhesion_id
WHERE
  adhesion_sejour.sejour_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.concerne AS concerne_6, t0.age_min AS age_min_7, t0.age_max AS age_max_8, t0.tarif AS tarif_9, t0.obligatoire AS obligatoire_10, t0.archive AS archive_11 FROM adhesion t0 INNER JOIN adhesion_sejour ON t0.id = adhesion_sejour.adhesion_id WHERE adhesion_sejour.sejour_id = 81;

SELECT
  a0_.id AS id_0,
  a0_.created_at AS created_at_1,
  a0_.updated_at AS updated_at_2,
  a0_.statut AS statut_3,
  a0_.montant AS montant_4,
  a0_.statut_annulation AS statut_annulation_5,
  a0_.adhesion_id AS adhesion_id_6,
  a0_.utilisateur_id AS utilisateur_id_7,
  a0_.personne_id AS personne_id_8,
  a0_.commande_id AS commande_id_9,
  a0_.annulation_id AS annulation_id_10
FROM
  adhesion_utilisateur a0_
  INNER JOIN adhesion a1_ ON a0_.adhesion_id = a1_.id
WHERE
  (
    a0_.statut_annulation <> ?
    OR a0_.statut_annulation IS NULL
  )
  AND a1_.id = ?
  AND a0_.utilisateur_id = ?

SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.statut AS statut_3, a0_.montant AS montant_4, a0_.statut_annulation AS statut_annulation_5, a0_.adhesion_id AS adhesion_id_6, a0_.utilisateur_id AS utilisateur_id_7, a0_.personne_id AS personne_id_8, a0_.commande_id AS commande_id_9, a0_.annulation_id AS annulation_id_10 FROM adhesion_utilisateur a0_ INNER JOIN adhesion a1_ ON a0_.adhesion_id = a1_.id WHERE (a0_.statut_annulation <> 'annule' OR a0_.statut_annulation IS NULL) AND a1_.id = 5 AND a0_.utilisateur_id = 14;

SELECT
  r0_.id AS id_0,
  r0_.label AS label_1,
  r0_.statut AS statut_2,
  r0_.montant AS montant_3,
  r0_.debut AS debut_4,
  r0_.fin AS fin_5,
  r0_.nombre_condition AS nombre_condition_6,
  r0_.type AS type_7,
  r0_.pourcentage AS pourcentage_8,
  r0_.type_application AS type_application_9,
  r0_.application_globale AS application_globale_10,
  r0_.condition_reduction_id AS condition_reduction_id_11
FROM
  regle_reduction r0_
WHERE
  r0_.statut = ?
  AND r0_.type = ?
  AND (
    r0_.debut IS NULL
    OR r0_.debut <= ?
  )
  AND (
    r0_.fin IS NULL
    OR r0_.fin >= ?
  )
ORDER BY
  r0_.type_application ASC

SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.statut AS statut_2, r0_.montant AS montant_3, r0_.debut AS debut_4, r0_.fin AS fin_5, r0_.nombre_condition AS nombre_condition_6, r0_.type AS type_7, r0_.pourcentage AS pourcentage_8, r0_.type_application AS type_application_9, r0_.application_globale AS application_globale_10, r0_.condition_reduction_id AS condition_reduction_id_11 FROM regle_reduction r0_ WHERE r0_.statut = 'active' AND r0_.type = 'auto' AND (r0_.debut IS NULL OR r0_.debut <= '2025-04-23 09:14:51') AND (r0_.fin IS NULL OR r0_.fin >= '2025-04-23 09:14:51') ORDER BY r0_.type_application ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.type AS type_3
FROM
  condition_reduction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3 FROM condition_reduction t0 WHERE t0.id = 3;

SELECT
  count(
    DISTINCT (e0_.id)
  ) AS sclr_0
FROM
  enfant e0_
  INNER JOIN reservation r1_ ON e0_.id = r1_.enfant_id
WHERE
  r1_.id IN (?)

SELECT count(DISTINCT (e0_.id)) AS sclr_0 FROM enfant e0_ INNER JOIN reservation r1_ ON e0_.id = r1_.enfant_id WHERE r1_.id IN (1224);

SELECT
  m0_.id AS id_0,
  m0_.montant_paye AS montant_paye_1,
  m0_.numero_cheque AS numero_cheque_2,
  m0_.numero_avoir AS numero_avoir_3,
  m0_.avoir_utilise AS avoir_utilise_4,
  m0_.created_at AS created_at_5,
  m0_.fin_validite AS fin_validite_6,
  m0_.id_paiement AS id_paiement_7,
  m0_.id_lien_paiement_stripe AS id_lien_paiement_stripe_8,
  m0_.somme_remboursee AS somme_remboursee_9,
  m0_.paiement_plusieurs_fois AS paiement_plusieurs_fois_10,
  m0_.montant_attendu AS montant_attendu_11,
  m0_.order_id AS order_id_12,
  m0_.cancel_order AS cancel_order_13,
  m0_.date_utilisation_avoir AS date_utilisation_avoir_14,
  m0_.moyen_paiement_id AS moyen_paiement_id_15,
  m0_.utilisateur_id AS utilisateur_id_16,
  m0_.annulation_id AS annulation_id_17
FROM
  mode_paiement_commande m0_
WHERE
  m0_.numero_avoir IS NOT NULL
  AND m0_.avoir_utilise IN (?, ?)
  AND m0_.utilisateur_id = ?

SELECT m0_.id AS id_0, m0_.montant_paye AS montant_paye_1, m0_.numero_cheque AS numero_cheque_2, m0_.numero_avoir AS numero_avoir_3, m0_.avoir_utilise AS avoir_utilise_4, m0_.created_at AS created_at_5, m0_.fin_validite AS fin_validite_6, m0_.id_paiement AS id_paiement_7, m0_.id_lien_paiement_stripe AS id_lien_paiement_stripe_8, m0_.somme_remboursee AS somme_remboursee_9, m0_.paiement_plusieurs_fois AS paiement_plusieurs_fois_10, m0_.montant_attendu AS montant_attendu_11, m0_.order_id AS order_id_12, m0_.cancel_order AS cancel_order_13, m0_.date_utilisation_avoir AS date_utilisation_avoir_14, m0_.moyen_paiement_id AS moyen_paiement_id_15, m0_.utilisateur_id AS utilisateur_id_16, m0_.annulation_id AS annulation_id_17 FROM mode_paiement_commande m0_ WHERE m0_.numero_avoir IS NOT NULL AND m0_.avoir_utilise IN ('pas_utilise', 'utilise_dans_panier') AND m0_.utilisateur_id = 14;