Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.region_idf AS region_idf_2,
  t0.region_ge AS region_ge_3,
  t0.region_ara AS region_ara_4,
  t0.region_paca AS region_paca_5,
  t0.kpi_talent AS kpi_talent_6,
  t0.kpi_collaborator AS kpi_collaborator_7,
  t0.kpi_young_accompany AS kpi_young_accompany_8,
  t0.kpi_educative_innovation_child AS kpi_educative_innovation_child_9,
  t0.kpi_educative_innovation_school AS kpi_educative_innovation_school_10,
  t0.kpi_third_places_spaces AS kpi_third_places_spaces_11,
  t0.kpi_third_places_visitor AS kpi_third_places_visitor_12,
  t0.kpi_third_places_event AS kpi_third_places_event_13,
  t0.kpi_third_places_employement AS kpi_third_places_employement_14,
  t0.partner AS partner_15,
  t0.kpi_join_us_women_rate AS kpi_join_us_women_rate_16,
  t0.kpi_join_us_age_average AS kpi_join_us_age_average_17,
  t0.region_reu AS region_reu_18
FROM
  kpi t0

SELECT t0.id AS id_1, t0.region_idf AS region_idf_2, t0.region_ge AS region_ge_3, t0.region_ara AS region_ara_4, t0.region_paca AS region_paca_5, t0.kpi_talent AS kpi_talent_6, t0.kpi_collaborator AS kpi_collaborator_7, t0.kpi_young_accompany AS kpi_young_accompany_8, t0.kpi_educative_innovation_child AS kpi_educative_innovation_child_9, t0.kpi_educative_innovation_school AS kpi_educative_innovation_school_10, t0.kpi_third_places_spaces AS kpi_third_places_spaces_11, t0.kpi_third_places_visitor AS kpi_third_places_visitor_12, t0.kpi_third_places_event AS kpi_third_places_event_13, t0.kpi_third_places_employement AS kpi_third_places_employement_14, t0.partner AS partner_15, t0.kpi_join_us_women_rate AS kpi_join_us_women_rate_16, t0.kpi_join_us_age_average AS kpi_join_us_age_average_17, t0.region_reu AS region_reu_18 FROM kpi t0;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.active AS active_3
FROM
  banner t0

SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.cta_name AS cta_name_4,
  t0.cta_link AS cta_link_5,
  t0.image AS image_6,
  t0.image_mobile AS image_mobile_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.visible AS visible_10,
  t0.ranking AS ranking_11
FROM
  home_screen t0
WHERE
  t0.visible = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.cta_name AS cta_name_4, t0.cta_link AS cta_link_5, t0.image AS image_6, t0.image_mobile AS image_mobile_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.ranking AS ranking_11 FROM home_screen t0 WHERE t0.visible = 1 ORDER BY t0.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.quote AS quote_2,
  t0.name AS name_3,
  t0.call_yourself AS call_yourself_4,
  t0.image AS image_5,
  t0.is_visible AS is_visible_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.region_id AS region_id_9,
  t0.community_center_id AS community_center_id_10
FROM
  testimonial t0
WHERE
  t0.region_id IS NULL
  AND t0.community_center_id IS NULL
  AND t0.is_visible = ?

SELECT t0.id AS id_1, t0.quote AS quote_2, t0.name AS name_3, t0.call_yourself AS call_yourself_4, t0.image AS image_5, t0.is_visible AS is_visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.region_id AS region_id_9, t0.community_center_id AS community_center_id_10 FROM testimonial t0 WHERE t0.region_id IS NULL AND t0.community_center_id IS NULL AND t0.is_visible = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.cta_link AS cta_link_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.slug AS slug_7,
  t0.meta_title AS meta_title_8,
  t0.meta_description AS meta_description_9,
  t0.image AS image_10,
  t0.published AS published_11,
  t0.cta_name AS cta_name_12,
  t0.body_secondly AS body_secondly_13,
  t0.catch_phrase AS catch_phrase_14,
  t0.subtitle AS subtitle_15,
  t0.author_id AS author_id_16,
  t0.category_id AS category_id_17
FROM
  article t0
WHERE
  t0.published = ?
ORDER BY
  t0.created_at DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_link AS cta_link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.image AS image_10, t0.published AS published_11, t0.cta_name AS cta_name_12, t0.body_secondly AS body_secondly_13, t0.catch_phrase AS catch_phrase_14, t0.subtitle AS subtitle_15, t0.author_id AS author_id_16, t0.category_id AS category_id_17 FROM article t0 WHERE t0.published = 1 ORDER BY t0.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.address AS address_5,
  t0.mail AS mail_6,
  t0.slug AS slug_7,
  t0.meta_title AS meta_title_8,
  t0.meta_desc AS meta_desc_9,
  t0.title AS title_10,
  t0.welcome_text AS welcome_text_11,
  t0.educative_project AS educative_project_12,
  t0.price AS price_13,
  t0.team_text AS team_text_14,
  t0.team_list AS team_list_15,
  t0.contact_phone AS contact_phone_16,
  t0.welcome_hours AS welcome_hours_17,
  t0.closure_hours AS closure_hours_18,
  t0.city AS city_19,
  t0.zip_code AS zip_code_20,
  t0.type AS type_21,
  t0.header AS header_22,
  t0.header_mobile AS header_mobile_23,
  t0.band AS band_24,
  t0.link_registration AS link_registration_25,
  t0.link_opinion AS link_opinion_26,
  t0.team_img AS team_img_27,
  t0.image_vignette AS image_vignette_28,
  t0.quotation_id AS quotation_id_29
FROM
  nursery t0

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.address AS address_5, t0.mail AS mail_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.title AS title_10, t0.welcome_text AS welcome_text_11, t0.educative_project AS educative_project_12, t0.price AS price_13, t0.team_text AS team_text_14, t0.team_list AS team_list_15, t0.contact_phone AS contact_phone_16, t0.welcome_hours AS welcome_hours_17, t0.closure_hours AS closure_hours_18, t0.city AS city_19, t0.zip_code AS zip_code_20, t0.type AS type_21, t0.header AS header_22, t0.header_mobile AS header_mobile_23, t0.band AS band_24, t0.link_registration AS link_registration_25, t0.link_opinion AS link_opinion_26, t0.team_img AS team_img_27, t0.image_vignette AS image_vignette_28, t0.quotation_id AS quotation_id_29 FROM nursery t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.picto AS picto_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.content_first AS content_first_8,
  t0.content_second AS content_second_9,
  t0.image_name AS image_name_10,
  t0.image_size AS image_size_11,
  t0.kpi1 AS kpi1_12,
  t0.kpi2 AS kpi2_13,
  t0.kpi3 AS kpi3_14,
  t0.banner_image_mobile AS banner_image_mobile_15,
  t0.banner_image_desktop AS banner_image_desktop_16,
  t0.kpi_text1 AS kpi_text1_17,
  t0.kpi_text2 AS kpi_text2_18,
  t0.kpi_text3 AS kpi_text3_19,
  t0.active AS active_20,
  t0.phone AS phone_21,
  t0.email AS email_22,
  t0.brochure AS brochure_23,
  t0.cost AS cost_24,
  t0.video_url AS video_url_25,
  t0.opening_hours AS opening_hours_26,
  t0.acm_title AS acm_title_27,
  t0.acm_description AS acm_description_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.video_thumbnail AS video_thumbnail_31,
  t0.content_image1 AS content_image1_32,
  t0.content_image2 AS content_image2_33,
  t0.quotation_id AS quotation_id_34
FROM
  community_center t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.picto AS picto_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.content_first AS content_first_8, t0.content_second AS content_second_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.kpi1 AS kpi1_12, t0.kpi2 AS kpi2_13, t0.kpi3 AS kpi3_14, t0.banner_image_mobile AS banner_image_mobile_15, t0.banner_image_desktop AS banner_image_desktop_16, t0.kpi_text1 AS kpi_text1_17, t0.kpi_text2 AS kpi_text2_18, t0.kpi_text3 AS kpi_text3_19, t0.active AS active_20, t0.phone AS phone_21, t0.email AS email_22, t0.brochure AS brochure_23, t0.cost AS cost_24, t0.video_url AS video_url_25, t0.opening_hours AS opening_hours_26, t0.acm_title AS acm_title_27, t0.acm_description AS acm_description_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.video_thumbnail AS video_thumbnail_31, t0.content_image1 AS content_image1_32, t0.content_image2 AS content_image2_33, t0.quotation_id AS quotation_id_34 FROM community_center t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.picto AS picto_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.content_first AS content_first_8,
  t0.content_second AS content_second_9,
  t0.image_name AS image_name_10,
  t0.image_size AS image_size_11,
  t0.kpi1 AS kpi1_12,
  t0.kpi2 AS kpi2_13,
  t0.kpi3 AS kpi3_14,
  t0.banner_image_mobile AS banner_image_mobile_15,
  t0.banner_image_desktop AS banner_image_desktop_16,
  t0.kpi_text1 AS kpi_text1_17,
  t0.kpi_text2 AS kpi_text2_18,
  t0.kpi_text3 AS kpi_text3_19,
  t0.active AS active_20,
  t0.phone AS phone_21,
  t0.email AS email_22,
  t0.brochure AS brochure_23,
  t0.cost AS cost_24,
  t0.video_url AS video_url_25,
  t0.opening_hours AS opening_hours_26,
  t0.acm_title AS acm_title_27,
  t0.acm_description AS acm_description_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.video_thumbnail AS video_thumbnail_31,
  t0.content_image1 AS content_image1_32,
  t0.content_image2 AS content_image2_33,
  t0.quotation_id AS quotation_id_34
FROM
  community_center t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.picto AS picto_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.content_first AS content_first_8, t0.content_second AS content_second_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.kpi1 AS kpi1_12, t0.kpi2 AS kpi2_13, t0.kpi3 AS kpi3_14, t0.banner_image_mobile AS banner_image_mobile_15, t0.banner_image_desktop AS banner_image_desktop_16, t0.kpi_text1 AS kpi_text1_17, t0.kpi_text2 AS kpi_text2_18, t0.kpi_text3 AS kpi_text3_19, t0.active AS active_20, t0.phone AS phone_21, t0.email AS email_22, t0.brochure AS brochure_23, t0.cost AS cost_24, t0.video_url AS video_url_25, t0.opening_hours AS opening_hours_26, t0.acm_title AS acm_title_27, t0.acm_description AS acm_description_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.video_thumbnail AS video_thumbnail_31, t0.content_image1 AS content_image1_32, t0.content_image2 AS content_image2_33, t0.quotation_id AS quotation_id_34 FROM community_center t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.active AS active_3
FROM
  banner t0

SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.active AS active_3
FROM
  banner t0

SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.active AS active_3
FROM
  banner t0

SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = 195;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = 194;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = 193;

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

SELECT
  c.COLUMN_NAME AS field,
  IF(
    x.CHECK_CLAUSE IS NOT NULL
    AND c.COLUMN_TYPE = 'longtext',
    '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
  LEFT JOIN information_schema.CHECK_CONSTRAINTS x ON (
    c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA
    AND c.TABLE_NAME = x.TABLE_NAME
    AND x.CHECK_CLAUSE = CONCAT(
      'json_valid(`', c.COLUMN_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(
        x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext',
        '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
    LEFT JOIN information_schema.CHECK_CONSTRAINTS x
    ON (
        c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA
        AND c.TABLE_NAME = x.TABLE_NAME
        AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)')
    ) WHERE c.TABLE_SCHEMA = 'qa_synergie_family' AND t.TABLE_SCHEMA = 'qa_synergie_family' 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 = 'qa_synergie_family' 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();