Symfony Profiler

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_pec'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

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_pec' AND t.TABLE_SCHEMA = 'bdd_pec' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY 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 = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'bdd_pec' */
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_pec' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bdd_pec' */ ORDER BY k.ORDINAL_POSITION;

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.token_basicompta AS token_basicompta_50,
  t0.created_interco_basicompta AS created_interco_basicompta_51,
  t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_52,
  t0.forfait_demi_journee AS forfait_demi_journee_53,
  t0.forfait_journee AS forfait_journee_54,
  t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_55,
  t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_56,
  t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_57,
  t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_58,
  t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_59,
  t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_60,
  t0.desactivation_qf AS desactivation_qf_61,
  t0.nom_tampon AS nom_tampon_62,
  t0.fonction_directeur AS fonction_directeur_63,
  t0.inscription_adultes AS inscription_adultes_64,
  t0.unite_presence_sejour AS unite_presence_sejour_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.token_basicompta AS token_basicompta_50, t0.created_interco_basicompta AS created_interco_basicompta_51, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_52, t0.forfait_demi_journee AS forfait_demi_journee_53, t0.forfait_journee AS forfait_journee_54, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_55, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_56, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_57, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_58, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_59, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_60, t0.desactivation_qf AS desactivation_qf_61, t0.nom_tampon AS nom_tampon_62, t0.fonction_directeur AS fonction_directeur_63, t0.inscription_adultes AS inscription_adultes_64, t0.unite_presence_sejour AS unite_presence_sejour_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
  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_pec' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

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_pec' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;