Symfony Profiler

SELECT
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'dev_cognetagencement_hector'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    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,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'dev_cognetagencement_hector'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        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 = 'dev_cognetagencement_hector' AND t.TABLE_SCHEMA = 'dev_cognetagencement_hector' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

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

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 = 'dev_cognetagencement_hector' */
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 = 'dev_cognetagencement_hector' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'dev_cognetagencement_hector' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c0_.id AS id_0,
  c0_.url AS url_1,
  c0_.version AS version_2,
  c0_.slogan AS slogan_3,
  c0_.compte_register_exterieur AS compte_register_exterieur_4,
  c0_.compte_login_pass_perdu AS compte_login_pass_perdu_5,
  c0_.coefGen AS coefGen_6,
  c0_.contact_telephone AS contact_telephone_7,
  c0_.contact_fax AS contact_fax_8,
  c0_.contact_email AS contact_email_9,
  c0_.entite_nom AS entite_nom_10,
  c0_.entite_siret AS entite_siret_11,
  c0_.nom_gerant AS nom_gerant_12,
  c0_.capital AS capital_13,
  c0_.adresse AS adresse_14,
  c0_.code_postal AS code_postal_15,
  c0_.ville AS ville_16,
  c0_.recaptcha_secret AS recaptcha_secret_17,
  c0_.recaptcha_public AS recaptcha_public_18,
  c0_.flag_caracteristique_materiel AS flag_caracteristique_materiel_19,
  c0_.flag_option_materiel AS flag_option_materiel_20,
  c0_.flag_increment_panier AS flag_increment_panier_21,
  c0_.date_creation AS date_creation_22,
  c0_.date_mise_a_jour AS date_mise_a_jour_23,
  c0_.entite_num_tva AS entite_num_tva_24,
  c0_.num_rcs AS num_rcs_25,
  c0_.code_ape AS code_ape_26,
  c0_.stock_cours_bas AS stock_cours_bas_27,
  c0_.stock_cours_haut AS stock_cours_haut_28,
  c0_.date_debut_facturation AS date_debut_facturation_29,
  c0_.nombre_jour_apparition_avant_facturation AS nombre_jour_apparition_avant_facturation_30,
  c0_.nombre_jour_apparition_apres_facturation AS nombre_jour_apparition_apres_facturation_31,
  c0_.facture_simple AS facture_simple_32,
  c0_.facture_ligne_garantie_facture AS facture_ligne_garantie_facture_33,
  c0_.facture_ligne_incident_paiement AS facture_ligne_incident_paiement_34,
  c0_.rib_banque AS rib_banque_35,
  c0_.rib_iban AS rib_iban_36,
  c0_.rib_bic AS rib_bic_37,
  c0_.facture_sujet_defaut AS facture_sujet_defaut_38,
  c0_.facture_text_defaut AS facture_text_defaut_39,
  c0_.devis_sujet_defaut AS devis_sujet_defaut_40,
  c0_.devis_text_defaut AS devis_text_defaut_41,
  c0_.from_email AS from_email_42,
  c0_.bcc_emails AS bcc_emails_43,
  c0_.flag_reroute_email AS flag_reroute_email_44,
  c0_.reroute_email AS reroute_email_45,
  c0_.flag_ecommerce AS flag_ecommerce_46,
  c0_.flag_champs_dynamiques AS flag_champs_dynamiques_47,
  c0_.increment_materiel AS increment_materiel_48,
  c0_.naf AS naf_49,
  c0_.message_ticket AS message_ticket_50,
  c0_.flag_maintenance AS flag_maintenance_51,
  c0_.flagActiverNotation AS flagActiverNotation_52,
  c0_.delai_relance_apres_expedition AS delai_relance_apres_expedition_53,
  c0_.flagActiverCommentaire AS flagActiverCommentaire_54,
  c0_.flag_prix_ht AS flag_prix_ht_55,
  c0_.description_seo_defaut AS description_seo_defaut_56,
  c0_.id_google_analytics AS id_google_analytics_57,
  c0_.id_site_matomo AS id_site_matomo_58,
  c0_.url_matomo AS url_matomo_59,
  c0_.pixel_facebook AS pixel_facebook_60,
  c0_.facebook AS facebook_61,
  c0_.twitter AS twitter_62,
  c0_.instagram AS instagram_63,
  c0_.google AS google_64,
  c0_.linkedin AS linkedin_65,
  c0_.youtube AS youtube_66,
  c0_.pinterest AS pinterest_67,
  c0_.nb_position AS nb_position_68,
  c0_.pagination_affichage_choix1 AS pagination_affichage_choix1_69,
  c0_.pagination_affichage_choix2 AS pagination_affichage_choix2_70,
  c0_.pagination_affichage_choix3 AS pagination_affichage_choix3_71,
  c0_.flagGererStock AS flagGererStock_72,
  c0_.maxProduitsPanier AS maxProduitsPanier_73,
  c0_.flagAfficheProduitSansStock AS flagAfficheProduitSansStock_74,
  c0_.flagCommandeEnRuptureStock AS flagCommandeEnRuptureStock_75,
  c0_.indication_sur_stock_en_rupture AS indication_sur_stock_en_rupture_76,
  c0_.titre_cross_selling AS titre_cross_selling_77,
  c0_.flag_activer_drive AS flag_activer_drive_78,
  c0_.virement_iban AS virement_iban_79,
  c0_.virement_bic AS virement_bic_80,
  c0_.nom_banque AS nom_banque_81,
  c0_.paypalclient_id AS paypalclient_id_82,
  c0_.paypal_client_secret AS paypal_client_secret_83,
  c0_.cheque_beneficiaire AS cheque_beneficiaire_84,
  c0_.cheque_adresse AS cheque_adresse_85,
  c0_.flag_paiement_virement AS flag_paiement_virement_86,
  c0_.flag_paiement_cheque AS flag_paiement_cheque_87,
  c0_.flag_paiement_paypal AS flag_paiement_paypal_88,
  c0_.flag_proforma AS flag_proforma_89,
  c0_.flag_facture AS flag_facture_90,
  c0_.flag_inventaire AS flag_inventaire_91,
  c0_.monetico_cle_mac AS monetico_cle_mac_92,
  c0_.monetico_tpe AS monetico_tpe_93,
  c0_.monetico_code_societe AS monetico_code_societe_94,
  c0_.monetico_url AS monetico_url_95,
  c0_.contact_idgls AS contact_idgls_96,
  c0_.login_gls AS login_gls_97,
  c0_.password_gls AS password_gls_98,
  c0_.url_shipping_gls AS url_shipping_gls_99,
  c0_.api_key_delivengo AS api_key_delivengo_100,
  c0_.url_shipping_delivengo AS url_shipping_delivengo_101,
  c0_.code_sh_douane AS code_sh_douane_102,
  c0_.date_export_stock AS date_export_stock_103,
  c0_.nom_export_stock AS nom_export_stock_104,
  c0_.flag_export_stock_en_cours AS flag_export_stock_en_cours_105,
  c0_.export_comptabilite_facture_en_cours AS export_comptabilite_facture_en_cours_106,
  c0_.export_comptabilite_avoir_en_cours AS export_comptabilite_avoir_en_cours_107,
  c0_.export_comptabilite_facture_avoir_en_cours AS export_comptabilite_facture_avoir_en_cours_108,
  c0_.dernier_export_comptabilite_facture_nom AS dernier_export_comptabilite_facture_nom_109,
  c0_.dernier_export_comptabilite_avoir_nom AS dernier_export_comptabilite_avoir_nom_110,
  c0_.dernier_export_comptabilite_facture_avoir_nom AS dernier_export_comptabilite_facture_avoir_nom_111,
  c0_.date_dernier_export_comptabilite_facture AS date_dernier_export_comptabilite_facture_112,
  c0_.date_dernier_export_comptabilite_avoir AS date_dernier_export_comptabilite_avoir_113,
  c0_.date_dernier_export_comptabilite_facture_avoir AS date_dernier_export_comptabilite_facture_avoir_114,
  c0_.code_vente_extracom AS code_vente_extracom_115,
  c0_.code_vente_intracom AS code_vente_intracom_116,
  c0_.code_fdpextracom AS code_fdpextracom_117,
  c0_.code_fdpintracom AS code_fdpintracom_118,
  c0_.code_client_defaut AS code_client_defaut_119,
  c0_.code_fdpdefaut AS code_fdpdefaut_120,
  c0_.code_remise_extracom AS code_remise_extracom_121,
  c0_.code_remise_intracom AS code_remise_intracom_122,
  c0_.code_remise_defaut AS code_remise_defaut_123,
  c0_.code_tva_extracom AS code_tva_extracom_124,
  c0_.code_tva_intracom AS code_tva_intracom_125,
  c0_.filtre_statistiques_dashboard AS filtre_statistiques_dashboard_126,
  c0_.data_statistiques_dashboard AS data_statistiques_dashboard_127,
  c0_.discr AS discr_128,
  c0_.logo AS logo_129,
  c0_.logoSvg AS logoSvg_130,
  c0_.taux_tva_defaut_id AS taux_tva_defaut_id_131,
  c0_.modifier_par AS modifier_par_132,
  c0_.logoArticle AS logoArticle_133,
  c0_.configuration_drive_id AS configuration_drive_id_134
FROM
  configuration_generale c0_
WHERE
  c0_.discr IN ('configuration_generale')
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.url AS url_1, c0_.version AS version_2, c0_.slogan AS slogan_3, c0_.compte_register_exterieur AS compte_register_exterieur_4, c0_.compte_login_pass_perdu AS compte_login_pass_perdu_5, c0_.coefGen AS coefGen_6, c0_.contact_telephone AS contact_telephone_7, c0_.contact_fax AS contact_fax_8, c0_.contact_email AS contact_email_9, c0_.entite_nom AS entite_nom_10, c0_.entite_siret AS entite_siret_11, c0_.nom_gerant AS nom_gerant_12, c0_.capital AS capital_13, c0_.adresse AS adresse_14, c0_.code_postal AS code_postal_15, c0_.ville AS ville_16, c0_.recaptcha_secret AS recaptcha_secret_17, c0_.recaptcha_public AS recaptcha_public_18, c0_.flag_caracteristique_materiel AS flag_caracteristique_materiel_19, c0_.flag_option_materiel AS flag_option_materiel_20, c0_.flag_increment_panier AS flag_increment_panier_21, c0_.date_creation AS date_creation_22, c0_.date_mise_a_jour AS date_mise_a_jour_23, c0_.entite_num_tva AS entite_num_tva_24, c0_.num_rcs AS num_rcs_25, c0_.code_ape AS code_ape_26, c0_.stock_cours_bas AS stock_cours_bas_27, c0_.stock_cours_haut AS stock_cours_haut_28, c0_.date_debut_facturation AS date_debut_facturation_29, c0_.nombre_jour_apparition_avant_facturation AS nombre_jour_apparition_avant_facturation_30, c0_.nombre_jour_apparition_apres_facturation AS nombre_jour_apparition_apres_facturation_31, c0_.facture_simple AS facture_simple_32, c0_.facture_ligne_garantie_facture AS facture_ligne_garantie_facture_33, c0_.facture_ligne_incident_paiement AS facture_ligne_incident_paiement_34, c0_.rib_banque AS rib_banque_35, c0_.rib_iban AS rib_iban_36, c0_.rib_bic AS rib_bic_37, c0_.facture_sujet_defaut AS facture_sujet_defaut_38, c0_.facture_text_defaut AS facture_text_defaut_39, c0_.devis_sujet_defaut AS devis_sujet_defaut_40, c0_.devis_text_defaut AS devis_text_defaut_41, c0_.from_email AS from_email_42, c0_.bcc_emails AS bcc_emails_43, c0_.flag_reroute_email AS flag_reroute_email_44, c0_.reroute_email AS reroute_email_45, c0_.flag_ecommerce AS flag_ecommerce_46, c0_.flag_champs_dynamiques AS flag_champs_dynamiques_47, c0_.increment_materiel AS increment_materiel_48, c0_.naf AS naf_49, c0_.message_ticket AS message_ticket_50, c0_.flag_maintenance AS flag_maintenance_51, c0_.flagActiverNotation AS flagActiverNotation_52, c0_.delai_relance_apres_expedition AS delai_relance_apres_expedition_53, c0_.flagActiverCommentaire AS flagActiverCommentaire_54, c0_.flag_prix_ht AS flag_prix_ht_55, c0_.description_seo_defaut AS description_seo_defaut_56, c0_.id_google_analytics AS id_google_analytics_57, c0_.id_site_matomo AS id_site_matomo_58, c0_.url_matomo AS url_matomo_59, c0_.pixel_facebook AS pixel_facebook_60, c0_.facebook AS facebook_61, c0_.twitter AS twitter_62, c0_.instagram AS instagram_63, c0_.google AS google_64, c0_.linkedin AS linkedin_65, c0_.youtube AS youtube_66, c0_.pinterest AS pinterest_67, c0_.nb_position AS nb_position_68, c0_.pagination_affichage_choix1 AS pagination_affichage_choix1_69, c0_.pagination_affichage_choix2 AS pagination_affichage_choix2_70, c0_.pagination_affichage_choix3 AS pagination_affichage_choix3_71, c0_.flagGererStock AS flagGererStock_72, c0_.maxProduitsPanier AS maxProduitsPanier_73, c0_.flagAfficheProduitSansStock AS flagAfficheProduitSansStock_74, c0_.flagCommandeEnRuptureStock AS flagCommandeEnRuptureStock_75, c0_.indication_sur_stock_en_rupture AS indication_sur_stock_en_rupture_76, c0_.titre_cross_selling AS titre_cross_selling_77, c0_.flag_activer_drive AS flag_activer_drive_78, c0_.virement_iban AS virement_iban_79, c0_.virement_bic AS virement_bic_80, c0_.nom_banque AS nom_banque_81, c0_.paypalclient_id AS paypalclient_id_82, c0_.paypal_client_secret AS paypal_client_secret_83, c0_.cheque_beneficiaire AS cheque_beneficiaire_84, c0_.cheque_adresse AS cheque_adresse_85, c0_.flag_paiement_virement AS flag_paiement_virement_86, c0_.flag_paiement_cheque AS flag_paiement_cheque_87, c0_.flag_paiement_paypal AS flag_paiement_paypal_88, c0_.flag_proforma AS flag_proforma_89, c0_.flag_facture AS flag_facture_90, c0_.flag_inventaire AS flag_inventaire_91, c0_.monetico_cle_mac AS monetico_cle_mac_92, c0_.monetico_tpe AS monetico_tpe_93, c0_.monetico_code_societe AS monetico_code_societe_94, c0_.monetico_url AS monetico_url_95, c0_.contact_idgls AS contact_idgls_96, c0_.login_gls AS login_gls_97, c0_.password_gls AS password_gls_98, c0_.url_shipping_gls AS url_shipping_gls_99, c0_.api_key_delivengo AS api_key_delivengo_100, c0_.url_shipping_delivengo AS url_shipping_delivengo_101, c0_.code_sh_douane AS code_sh_douane_102, c0_.date_export_stock AS date_export_stock_103, c0_.nom_export_stock AS nom_export_stock_104, c0_.flag_export_stock_en_cours AS flag_export_stock_en_cours_105, c0_.export_comptabilite_facture_en_cours AS export_comptabilite_facture_en_cours_106, c0_.export_comptabilite_avoir_en_cours AS export_comptabilite_avoir_en_cours_107, c0_.export_comptabilite_facture_avoir_en_cours AS export_comptabilite_facture_avoir_en_cours_108, c0_.dernier_export_comptabilite_facture_nom AS dernier_export_comptabilite_facture_nom_109, c0_.dernier_export_comptabilite_avoir_nom AS dernier_export_comptabilite_avoir_nom_110, c0_.dernier_export_comptabilite_facture_avoir_nom AS dernier_export_comptabilite_facture_avoir_nom_111, c0_.date_dernier_export_comptabilite_facture AS date_dernier_export_comptabilite_facture_112, c0_.date_dernier_export_comptabilite_avoir AS date_dernier_export_comptabilite_avoir_113, c0_.date_dernier_export_comptabilite_facture_avoir AS date_dernier_export_comptabilite_facture_avoir_114, c0_.code_vente_extracom AS code_vente_extracom_115, c0_.code_vente_intracom AS code_vente_intracom_116, c0_.code_fdpextracom AS code_fdpextracom_117, c0_.code_fdpintracom AS code_fdpintracom_118, c0_.code_client_defaut AS code_client_defaut_119, c0_.code_fdpdefaut AS code_fdpdefaut_120, c0_.code_remise_extracom AS code_remise_extracom_121, c0_.code_remise_intracom AS code_remise_intracom_122, c0_.code_remise_defaut AS code_remise_defaut_123, c0_.code_tva_extracom AS code_tva_extracom_124, c0_.code_tva_intracom AS code_tva_intracom_125, c0_.filtre_statistiques_dashboard AS filtre_statistiques_dashboard_126, c0_.data_statistiques_dashboard AS data_statistiques_dashboard_127, c0_.discr AS discr_128, c0_.logo AS logo_129, c0_.logoSvg AS logoSvg_130, c0_.taux_tva_defaut_id AS taux_tva_defaut_id_131, c0_.modifier_par AS modifier_par_132, c0_.logoArticle AS logoArticle_133, c0_.configuration_drive_id AS configuration_drive_id_134 FROM configuration_generale c0_ WHERE c0_.discr IN ('configuration_generale') ORDER BY c0_.id DESC LIMIT 1;

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.FULL_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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'dev_cognetagencement_hector' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.code_langue_defaut AS code_langue_defaut_4,
  t0.flag_principale AS flag_principale_5,
  t0.date_creation AS date_creation_6,
  t0.date_mise_a_jour AS date_mise_a_jour_7,
  t0.pays_livraison_defaut_id AS pays_livraison_defaut_id_8,
  t0.modifier_par AS modifier_par_9,
  t0.discr
FROM
  boutique t0
WHERE
  t0.url = ?
  AND t0.discr IN ('boutique')
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.code_langue_defaut AS code_langue_defaut_4, t0.flag_principale AS flag_principale_5, t0.date_creation AS date_creation_6, t0.date_mise_a_jour AS date_mise_a_jour_7, t0.pays_livraison_defaut_id AS pays_livraison_defaut_id_8, t0.modifier_par AS modifier_par_9, t0.discr FROM boutique t0 WHERE t0.url = 'cognetagencement.preprod-beware.fr' AND t0.discr IN ('boutique') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.html_content AS html_content_4,
  t0.css_content AS css_content_5,
  t0.js_content AS js_content_6,
  t0.preview_html_content AS preview_html_content_7,
  t0.preview_css_content AS preview_css_content_8,
  t0.preview_js_content AS preview_js_content_9,
  t0.editor_content AS editor_content_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  page_component t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.html_content AS html_content_4, t0.css_content AS css_content_5, t0.js_content AS js_content_6, t0.preview_html_content AS preview_html_content_7, t0.preview_css_content AS preview_css_content_8, t0.preview_js_content AS preview_js_content_9, t0.editor_content AS editor_content_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM page_component t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.page_id AS page_id_3
FROM
  slug_index t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.page_id AS page_id_3 FROM slug_index t0 WHERE t0.slug = 'robots.txt' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.title AS title_2,
  p0_.description AS description_3,
  p0_.slug AS slug_4,
  p0_.published AS published_5,
  p0_.excluded_from_sitemap AS excluded_from_sitemap_6,
  p0_.html_content AS html_content_7,
  p0_.css_content AS css_content_8,
  p0_.js_content AS js_content_9,
  p0_.preview_html_content AS preview_html_content_10,
  p0_.preview_css_content AS preview_css_content_11,
  p0_.preview_js_content AS preview_js_content_12,
  p0_.editor_content AS editor_content_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.handler AS handler_16,
  p0_.has_header AS has_header_17,
  p0_.has_footer AS has_footer_18,
  p0_.slug_dynamic AS slug_dynamic_19,
  p0_.need_connection AS need_connection_20,
  p0_.image_id AS image_id_21,
  p0_.parent_page_id AS parent_page_id_22
FROM
  page p0_
WHERE
  p0_.slug = ?
  AND p0_.slug_dynamic = ?
  AND p0_.parent_page_id IS NULL

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title AS title_2, p0_.description AS description_3, p0_.slug AS slug_4, p0_.published AS published_5, p0_.excluded_from_sitemap AS excluded_from_sitemap_6, p0_.html_content AS html_content_7, p0_.css_content AS css_content_8, p0_.js_content AS js_content_9, p0_.preview_html_content AS preview_html_content_10, p0_.preview_css_content AS preview_css_content_11, p0_.preview_js_content AS preview_js_content_12, p0_.editor_content AS editor_content_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.handler AS handler_16, p0_.has_header AS has_header_17, p0_.has_footer AS has_footer_18, p0_.slug_dynamic AS slug_dynamic_19, p0_.need_connection AS need_connection_20, p0_.image_id AS image_id_21, p0_.parent_page_id AS parent_page_id_22 FROM page p0_ WHERE p0_.slug = 'robots.txt' AND p0_.slug_dynamic = 0 AND p0_.parent_page_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.tel_fixe AS tel_fixe_9,
  t0.tel_portable AS tel_portable_10,
  t0.adresse AS adresse_11,
  t0.complement_adresse AS complement_adresse_12,
  t0.ville AS ville_13,
  t0.code_postal AS code_postal_14,
  t0.confirmation_token AS confirmation_token_15,
  t0.password_requested_at AS password_requested_at_16,
  t0.last_login AS last_login_17,
  t0.confirmation_register AS confirmation_register_18,
  t0.token_register AS token_register_19,
  t0.is_active AS is_active_20,
  t0.date_creation AS date_creation_21,
  t0.date_mise_a_jour AS date_mise_a_jour_22,
  t0.modifier_par AS modifier_par_23,
  t0.discr,
  t0.avatar AS avatar_24
FROM
  personnel t0
WHERE
  t0.id = ?
  AND t0.discr IN ('personnel')

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.salt AS salt_4, t0.password AS password_5, t0.email AS email_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.tel_fixe AS tel_fixe_9, t0.tel_portable AS tel_portable_10, t0.adresse AS adresse_11, t0.complement_adresse AS complement_adresse_12, t0.ville AS ville_13, t0.code_postal AS code_postal_14, t0.confirmation_token AS confirmation_token_15, t0.password_requested_at AS password_requested_at_16, t0.last_login AS last_login_17, t0.confirmation_register AS confirmation_register_18, t0.token_register AS token_register_19, t0.is_active AS is_active_20, t0.date_creation AS date_creation_21, t0.date_mise_a_jour AS date_mise_a_jour_22, t0.modifier_par AS modifier_par_23, t0.discr, t0.avatar AS avatar_24 FROM personnel t0 WHERE t0.id = 1 AND t0.discr IN ('personnel');

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

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.picto AS picto_3,
  t0.coeff_commercial AS coeff_commercial_4,
  t0.remise_pourcentage AS remise_pourcentage_5,
  t0.flag_actif AS flag_actif_6,
  t0.flag_default_creation AS flag_default_creation_7,
  t0.libelle_marketplace AS libelle_marketplace_8,
  t0.date_creation AS date_creation_9,
  t0.date_mise_a_jour AS date_mise_a_jour_10,
  t0.modifier_par AS modifier_par_11
FROM
  canal_de_vente t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.picto AS picto_3, t0.coeff_commercial AS coeff_commercial_4, t0.remise_pourcentage AS remise_pourcentage_5, t0.flag_actif AS flag_actif_6, t0.flag_default_creation AS flag_default_creation_7, t0.libelle_marketplace AS libelle_marketplace_8, t0.date_creation AS date_creation_9, t0.date_mise_a_jour AS date_mise_a_jour_10, t0.modifier_par AS modifier_par_11 FROM canal_de_vente t0;

SELECT
  p0_.id AS id_0,
  p0_.header_id AS header_id_1,
  p0_.footer_id AS footer_id_2,
  p0_.page_error_id AS page_error_id_3,
  p0_.page_maintenance_id AS page_maintenance_id_4,
  p0_.page_login_id AS page_login_id_5
FROM
  page_configuration p0_
LIMIT
  1

SELECT p0_.id AS id_0, p0_.header_id AS header_id_1, p0_.footer_id AS footer_id_2, p0_.page_error_id AS page_error_id_3, p0_.page_maintenance_id AS page_maintenance_id_4, p0_.page_login_id AS page_login_id_5 FROM page_configuration p0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.youtube AS youtube_1,
  c0_.openstreetmap AS openstreetmap_2
FROM
  consent_configuration c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.youtube AS youtube_1, c0_.openstreetmap AS openstreetmap_2 FROM consent_configuration c0_ LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code_devise_boutique AS code_devise_boutique_2,
  t0.code_devise_locale AS code_devise_locale_3,
  t0.taux_change AS taux_change_4,
  t0.date_derniere_maj AS date_derniere_maj_5,
  t0.date_creation AS date_creation_6,
  t0.date_mise_a_jour AS date_mise_a_jour_7,
  t0.modifier_par AS modifier_par_8,
  t0.discr
FROM
  devise_conversion t0
WHERE
  t0.code_devise_boutique = ?
  AND t0.code_devise_locale IS NULL
  AND t0.discr IN ('devise_conversion')
LIMIT
  1

SELECT t0.id AS id_1, t0.code_devise_boutique AS code_devise_boutique_2, t0.code_devise_locale AS code_devise_locale_3, t0.taux_change AS taux_change_4, t0.date_derniere_maj AS date_derniere_maj_5, t0.date_creation AS date_creation_6, t0.date_mise_a_jour AS date_mise_a_jour_7, t0.modifier_par AS modifier_par_8, t0.discr FROM devise_conversion t0 WHERE t0.code_devise_boutique = 'EUR' AND t0.code_devise_locale IS NULL AND t0.discr IN ('devise_conversion') LIMIT 1;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;