Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.path AS path_3,
  t0.deleteFile AS deleteFile_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t7.id AS id_8,
  t7.created AS created_9,
  t7.updated AS updated_10,
  t7.title AS title_11,
  t7.summary AS summary_12,
  t7.objective AS objective_13,
  t7.descriptive AS descriptive_14,
  t7.resultOnTheTerritory AS resultOnTheTerritory_15,
  t7.resultForSocialCenter AS resultForSocialCenter_16,
  t7.resultForInhabitants AS resultForInhabitants_17,
  t7.applicant_other AS applicant_other_18,
  t7.status AS status_19,
  t7.status_detailsr AS status_detailsr_20,
  t7.afterActionLimits AS afterActionLimits_21,
  t7.afterActionProspects AS afterActionProspects_22,
  t7.financialRessources AS financialRessources_23,
  t7.professionalRessources AS professionalRessources_24,
  t7.ficheActionTerritoire_other AS ficheActionTerritoire_other_25,
  t7.nbViews AS nbViews_26,
  t7.document1_id AS document1_id_27,
  t7.document2_id AS document2_id_28,
  t7.document3_id AS document3_id_29,
  t7.document4_id AS document4_id_30,
  t7.dimension_action_id AS dimension_action_id_31,
  t7.public_action_id AS public_action_id_32,
  t7.structure_id AS structure_id_33,
  t7.ficheActionTerritoire_id AS ficheActionTerritoire_id_34,
  t35.id AS id_36,
  t35.created AS created_37,
  t35.updated AS updated_38,
  t35.title AS title_39,
  t35.summary AS summary_40,
  t35.objective AS objective_41,
  t35.descriptive AS descriptive_42,
  t35.resultOnTheTerritory AS resultOnTheTerritory_43,
  t35.resultForSocialCenter AS resultForSocialCenter_44,
  t35.resultForInhabitants AS resultForInhabitants_45,
  t35.applicant_other AS applicant_other_46,
  t35.status AS status_47,
  t35.status_detailsr AS status_detailsr_48,
  t35.afterActionLimits AS afterActionLimits_49,
  t35.afterActionProspects AS afterActionProspects_50,
  t35.financialRessources AS financialRessources_51,
  t35.professionalRessources AS professionalRessources_52,
  t35.ficheActionTerritoire_other AS ficheActionTerritoire_other_53,
  t35.nbViews AS nbViews_54,
  t35.document1_id AS document1_id_55,
  t35.document2_id AS document2_id_56,
  t35.document3_id AS document3_id_57,
  t35.document4_id AS document4_id_58,
  t35.dimension_action_id AS dimension_action_id_59,
  t35.public_action_id AS public_action_id_60,
  t35.structure_id AS structure_id_61,
  t35.ficheActionTerritoire_id AS ficheActionTerritoire_id_62,
  t63.id AS id_64,
  t63.created AS created_65,
  t63.updated AS updated_66,
  t63.title AS title_67,
  t63.summary AS summary_68,
  t63.objective AS objective_69,
  t63.descriptive AS descriptive_70,
  t63.resultOnTheTerritory AS resultOnTheTerritory_71,
  t63.resultForSocialCenter AS resultForSocialCenter_72,
  t63.resultForInhabitants AS resultForInhabitants_73,
  t63.applicant_other AS applicant_other_74,
  t63.status AS status_75,
  t63.status_detailsr AS status_detailsr_76,
  t63.afterActionLimits AS afterActionLimits_77,
  t63.afterActionProspects AS afterActionProspects_78,
  t63.financialRessources AS financialRessources_79,
  t63.professionalRessources AS professionalRessources_80,
  t63.ficheActionTerritoire_other AS ficheActionTerritoire_other_81,
  t63.nbViews AS nbViews_82,
  t63.document1_id AS document1_id_83,
  t63.document2_id AS document2_id_84,
  t63.document3_id AS document3_id_85,
  t63.document4_id AS document4_id_86,
  t63.dimension_action_id AS dimension_action_id_87,
  t63.public_action_id AS public_action_id_88,
  t63.structure_id AS structure_id_89,
  t63.ficheActionTerritoire_id AS ficheActionTerritoire_id_90,
  t91.id AS id_92,
  t91.created AS created_93,
  t91.updated AS updated_94,
  t91.title AS title_95,
  t91.summary AS summary_96,
  t91.objective AS objective_97,
  t91.descriptive AS descriptive_98,
  t91.resultOnTheTerritory AS resultOnTheTerritory_99,
  t91.resultForSocialCenter AS resultForSocialCenter_100,
  t91.resultForInhabitants AS resultForInhabitants_101,
  t91.applicant_other AS applicant_other_102,
  t91.status AS status_103,
  t91.status_detailsr AS status_detailsr_104,
  t91.afterActionLimits AS afterActionLimits_105,
  t91.afterActionProspects AS afterActionProspects_106,
  t91.financialRessources AS financialRessources_107,
  t91.professionalRessources AS professionalRessources_108,
  t91.ficheActionTerritoire_other AS ficheActionTerritoire_other_109,
  t91.nbViews AS nbViews_110,
  t91.document1_id AS document1_id_111,
  t91.document2_id AS document2_id_112,
  t91.document3_id AS document3_id_113,
  t91.document4_id AS document4_id_114,
  t91.dimension_action_id AS dimension_action_id_115,
  t91.public_action_id AS public_action_id_116,
  t91.structure_id AS structure_id_117,
  t91.ficheActionTerritoire_id AS ficheActionTerritoire_id_118
FROM
  Document t0
  LEFT JOIN FicheAction t7 ON t7.document1_id = t0.id
  LEFT JOIN FicheAction t35 ON t35.document2_id = t0.id
  LEFT JOIN FicheAction t63 ON t63.document3_id = t0.id
  LEFT JOIN FicheAction t91 ON t91.document4_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.deleteFile AS deleteFile_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t7.id AS id_8, t7.created AS created_9, t7.updated AS updated_10, t7.title AS title_11, t7.summary AS summary_12, t7.objective AS objective_13, t7.descriptive AS descriptive_14, t7.resultOnTheTerritory AS resultOnTheTerritory_15, t7.resultForSocialCenter AS resultForSocialCenter_16, t7.resultForInhabitants AS resultForInhabitants_17, t7.applicant_other AS applicant_other_18, t7.status AS status_19, t7.status_detailsr AS status_detailsr_20, t7.afterActionLimits AS afterActionLimits_21, t7.afterActionProspects AS afterActionProspects_22, t7.financialRessources AS financialRessources_23, t7.professionalRessources AS professionalRessources_24, t7.ficheActionTerritoire_other AS ficheActionTerritoire_other_25, t7.nbViews AS nbViews_26, t7.document1_id AS document1_id_27, t7.document2_id AS document2_id_28, t7.document3_id AS document3_id_29, t7.document4_id AS document4_id_30, t7.dimension_action_id AS dimension_action_id_31, t7.public_action_id AS public_action_id_32, t7.structure_id AS structure_id_33, t7.ficheActionTerritoire_id AS ficheActionTerritoire_id_34, t35.id AS id_36, t35.created AS created_37, t35.updated AS updated_38, t35.title AS title_39, t35.summary AS summary_40, t35.objective AS objective_41, t35.descriptive AS descriptive_42, t35.resultOnTheTerritory AS resultOnTheTerritory_43, t35.resultForSocialCenter AS resultForSocialCenter_44, t35.resultForInhabitants AS resultForInhabitants_45, t35.applicant_other AS applicant_other_46, t35.status AS status_47, t35.status_detailsr AS status_detailsr_48, t35.afterActionLimits AS afterActionLimits_49, t35.afterActionProspects AS afterActionProspects_50, t35.financialRessources AS financialRessources_51, t35.professionalRessources AS professionalRessources_52, t35.ficheActionTerritoire_other AS ficheActionTerritoire_other_53, t35.nbViews AS nbViews_54, t35.document1_id AS document1_id_55, t35.document2_id AS document2_id_56, t35.document3_id AS document3_id_57, t35.document4_id AS document4_id_58, t35.dimension_action_id AS dimension_action_id_59, t35.public_action_id AS public_action_id_60, t35.structure_id AS structure_id_61, t35.ficheActionTerritoire_id AS ficheActionTerritoire_id_62, t63.id AS id_64, t63.created AS created_65, t63.updated AS updated_66, t63.title AS title_67, t63.summary AS summary_68, t63.objective AS objective_69, t63.descriptive AS descriptive_70, t63.resultOnTheTerritory AS resultOnTheTerritory_71, t63.resultForSocialCenter AS resultForSocialCenter_72, t63.resultForInhabitants AS resultForInhabitants_73, t63.applicant_other AS applicant_other_74, t63.status AS status_75, t63.status_detailsr AS status_detailsr_76, t63.afterActionLimits AS afterActionLimits_77, t63.afterActionProspects AS afterActionProspects_78, t63.financialRessources AS financialRessources_79, t63.professionalRessources AS professionalRessources_80, t63.ficheActionTerritoire_other AS ficheActionTerritoire_other_81, t63.nbViews AS nbViews_82, t63.document1_id AS document1_id_83, t63.document2_id AS document2_id_84, t63.document3_id AS document3_id_85, t63.document4_id AS document4_id_86, t63.dimension_action_id AS dimension_action_id_87, t63.public_action_id AS public_action_id_88, t63.structure_id AS structure_id_89, t63.ficheActionTerritoire_id AS ficheActionTerritoire_id_90, t91.id AS id_92, t91.created AS created_93, t91.updated AS updated_94, t91.title AS title_95, t91.summary AS summary_96, t91.objective AS objective_97, t91.descriptive AS descriptive_98, t91.resultOnTheTerritory AS resultOnTheTerritory_99, t91.resultForSocialCenter AS resultForSocialCenter_100, t91.resultForInhabitants AS resultForInhabitants_101, t91.applicant_other AS applicant_other_102, t91.status AS status_103, t91.status_detailsr AS status_detailsr_104, t91.afterActionLimits AS afterActionLimits_105, t91.afterActionProspects AS afterActionProspects_106, t91.financialRessources AS financialRessources_107, t91.professionalRessources AS professionalRessources_108, t91.ficheActionTerritoire_other AS ficheActionTerritoire_other_109, t91.nbViews AS nbViews_110, t91.document1_id AS document1_id_111, t91.document2_id AS document2_id_112, t91.document3_id AS document3_id_113, t91.document4_id AS document4_id_114, t91.dimension_action_id AS dimension_action_id_115, t91.public_action_id AS public_action_id_116, t91.structure_id AS structure_id_117, t91.ficheActionTerritoire_id AS ficheActionTerritoire_id_118 FROM Document t0 LEFT JOIN FicheAction t7 ON t7.document1_id = t0.id LEFT JOIN FicheAction t35 ON t35.document2_id = t0.id LEFT JOIN FicheAction t63 ON t63.document3_id = t0.id LEFT JOIN FicheAction t91 ON t91.document4_id = t0.id WHERE t0.id = '2749';

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.ficheAction_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.ficheAction_id = 7313;

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