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

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 = 'rulteamapp_db'
        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 = 'rulteamapp_db'
            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 = 'rulteamapp_db' AND t.TABLE_SCHEMA = 'rulteamapp_db' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.payment_uid AS payment_uid_3,
  c0_.is_cgu AS is_cgu_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.code AS code_7,
  u1_.id AS id_8,
  u1_.email AS email_9,
  u1_.roles AS roles_10,
  u1_.password AS password_11,
  u1_.created_at AS created_at_12,
  u1_.updated_at AS updated_at_13,
  u1_.last_login AS last_login_14,
  u1_.name AS name_15,
  u1_.category AS category_16,
  u1_.active AS active_17,
  u1_.ban_start AS ban_start_18,
  u1_.ban_end AS ban_end_19,
  u1_.reset_token AS reset_token_20,
  u1_.first_name AS first_name_21,
  u1_.last_name AS last_name_22,
  u1_.country AS country_23,
  u1_.`function` AS function_24,
  u1_.phone AS phone_25,
  u1_.username AS username_26,
  u1_.quotas AS quotas_27,
  u1_.quotas_type AS quotas_type_28,
  u1_.email_updated_at AS email_updated_at_29,
  u1_.email_validated_at AS email_validated_at_30,
  u1_.status AS status_31,
  u1_.device_os AS device_os_32,
  u1_.device_token AS device_token_33,
  u1_.device_name AS device_name_34,
  u1_.device_active AS device_active_35,
  u1_.device_update AS device_update_36,
  u1_.newsletter AS newsletter_37,
  u1_.newsletter_date AS newsletter_date_38,
  u1_.first_login AS first_login_39,
  u1_.home_survey AS home_survey_40,
  u1_.display_teamplay_tuto AS display_teamplay_tuto_41,
  u1_.live AS live_42,
  u1_.tv AS tv_43,
  c2_.id AS id_44,
  c2_.name AS name_45,
  c2_.image AS image_46,
  c2_.updated_at AS updated_at_47,
  c2_.presentation AS presentation_48,
  c2_.presentation_title AS presentation_title_49,
  c2_.siret AS siret_50,
  c2_.phone AS phone_51,
  c2_.created_at AS created_at_52,
  c2_.company_code AS company_code_53,
  c2_.visio_allowed AS visio_allowed_54,
  c2_.visio_payment_allowed AS visio_payment_allowed_55,
  c2_.force_segmentation AS force_segmentation_56,
  c2_.siren AS siren_57,
  c2_.status AS status_58,
  c2_.active AS active_59,
  c2_.subscription_start AS subscription_start_60,
  c2_.subscription_end AS subscription_end_61,
  c2_.clients_count AS clients_count_62,
  c2_.messages AS messages_63,
  c2_.max_clients AS max_clients_64,
  c2_.plan AS plan_65,
  c2_.slug AS slug_66,
  c2_.ips AS ips_67,
  c2_.domain AS domain_68,
  c2_.hourly_restriction AS hourly_restriction_69,
  c2_.customizable AS customizable_70,
  c2_.cms AS cms_71,
  c2_.cms_title AS cms_title_72,
  c2_.cms_text AS cms_text_73,
  c2_.cms_cta_text AS cms_cta_text_74,
  c2_.cms_cta_url AS cms_cta_url_75,
  c2_.resa_link_active AS resa_link_active_76,
  c2_.email AS email_77,
  c2_.live AS live_78,
  c2_.tv AS tv_79,
  c2_.consult_link AS consult_link_80,
  c2_.street AS street_81,
  c2_.zip_code AS zip_code_82,
  c2_.town AS town_83,
  c2_.longitude AS longitude_84,
  c2_.latitude AS latitude_85,
  c2_.country AS country_86,
  c2_.code AS code_87,
  m3_.id AS id_88,
  m3_.file_path AS file_path_89,
  m3_.mime_type AS mime_type_90,
  m3_.size AS size_91,
  m3_.extra AS extra_92,
  m3_.created_at AS created_at_93,
  m3_.name AS name_94,
  s4_.id AS id_95,
  s4_.name AS name_96,
  s4_.alone AS alone_97,
  s4_.active AS active_98,
  s4_.ranked AS ranked_99,
  s4_.`rank` AS rank_100,
  s4_.created_at AS created_at_101,
  s4_.updated_at AS updated_at_102,
  c5_.id AS id_103,
  c5_.name AS name_104,
  c5_.image AS image_105,
  c5_.updated_at AS updated_at_106,
  c5_.presentation AS presentation_107,
  c5_.presentation_title AS presentation_title_108,
  c5_.siret AS siret_109,
  c5_.phone AS phone_110,
  c5_.created_at AS created_at_111,
  c5_.company_code AS company_code_112,
  c5_.visio_allowed AS visio_allowed_113,
  c5_.visio_payment_allowed AS visio_payment_allowed_114,
  c5_.force_segmentation AS force_segmentation_115,
  c5_.siren AS siren_116,
  c5_.status AS status_117,
  c5_.active AS active_118,
  c5_.subscription_start AS subscription_start_119,
  c5_.subscription_end AS subscription_end_120,
  c5_.clients_count AS clients_count_121,
  c5_.messages AS messages_122,
  c5_.max_clients AS max_clients_123,
  c5_.plan AS plan_124,
  c5_.slug AS slug_125,
  c5_.ips AS ips_126,
  c5_.domain AS domain_127,
  c5_.hourly_restriction AS hourly_restriction_128,
  c5_.customizable AS customizable_129,
  c5_.cms AS cms_130,
  c5_.cms_title AS cms_title_131,
  c5_.cms_text AS cms_text_132,
  c5_.cms_cta_text AS cms_cta_text_133,
  c5_.cms_cta_url AS cms_cta_url_134,
  c5_.resa_link_active AS resa_link_active_135,
  c5_.email AS email_136,
  c5_.live AS live_137,
  c5_.tv AS tv_138,
  c5_.consult_link AS consult_link_139,
  c5_.street AS street_140,
  c5_.zip_code AS zip_code_141,
  c5_.town AS town_142,
  c5_.longitude AS longitude_143,
  c5_.latitude AS latitude_144,
  c5_.country AS country_145,
  c5_.code AS code_146,
  m6_.id AS id_147,
  m6_.file_path AS file_path_148,
  m6_.mime_type AS mime_type_149,
  m6_.size AS size_150,
  m6_.extra AS extra_151,
  m6_.created_at AS created_at_152,
  m6_.name AS name_153,
  a7_.id AS id_154,
  a7_.name AS name_155,
  a7_.short_description AS short_description_156,
  a7_.content AS content_157,
  a7_.link_url AS link_url_158,
  a7_.active AS active_159,
  a7_.created_at AS created_at_160,
  a7_.updated_at AS updated_at_161,
  m8_.id AS id_162,
  m8_.file_path AS file_path_163,
  m8_.mime_type AS mime_type_164,
  m8_.size AS size_165,
  m8_.extra AS extra_166,
  m8_.created_at AS created_at_167,
  m8_.name AS name_168,
  c0_.dtype AS dtype_169,
  c0_.user_id AS user_id_170,
  c0_.company_id AS company_id_171,
  c0_.segmentation_id AS segmentation_id_172,
  c0_.association_id AS association_id_173,
  c0_.avatar_id AS avatar_id_174,
  u1_.segmentation_id AS segmentation_id_175,
  c2_.dtype AS dtype_176,
  c2_.user_id AS user_id_177,
  c2_.logo_id AS logo_id_178,
  c2_.cms_img_id AS cms_img_id_179,
  s4_.company_id AS company_id_180,
  s4_.parent_id AS parent_id_181,
  c5_.dtype AS dtype_182,
  c5_.user_id AS user_id_183,
  c5_.logo_id AS logo_id_184,
  c5_.cms_img_id AS cms_img_id_185,
  a7_.preview_id AS preview_id_186,
  a7_.picture_id AS picture_id_187,
  a7_.illustration_id AS illustration_id_188
FROM
  client c0_
  INNER JOIN `user` u1_ ON c0_.user_id = u1_.id
  INNER JOIN company c2_ ON c0_.company_id = c2_.id
  AND c2_.dtype IN ('company', 'externalcompany')
  LEFT JOIN media_object m3_ ON c2_.logo_id = m3_.id
  LEFT JOIN segmentation s4_ ON c0_.segmentation_id = s4_.id
  LEFT JOIN company c5_ ON s4_.company_id = c5_.id
  AND c5_.dtype IN ('company', 'externalcompany')
  LEFT JOIN media_object m6_ ON c5_.logo_id = m6_.id
  LEFT JOIN association a7_ ON c0_.association_id = a7_.id
  LEFT JOIN media_object m8_ ON c0_.avatar_id = m8_.id
WHERE
  (c0_.id = ?)
  AND c0_.dtype IN ('client', 'externalclient')

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.payment_uid AS payment_uid_3, c0_.is_cgu AS is_cgu_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.code AS code_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.created_at AS created_at_12, u1_.updated_at AS updated_at_13, u1_.last_login AS last_login_14, u1_.name AS name_15, u1_.category AS category_16, u1_.active AS active_17, u1_.ban_start AS ban_start_18, u1_.ban_end AS ban_end_19, u1_.reset_token AS reset_token_20, u1_.first_name AS first_name_21, u1_.last_name AS last_name_22, u1_.country AS country_23, u1_.`function` AS function_24, u1_.phone AS phone_25, u1_.username AS username_26, u1_.quotas AS quotas_27, u1_.quotas_type AS quotas_type_28, u1_.email_updated_at AS email_updated_at_29, u1_.email_validated_at AS email_validated_at_30, u1_.status AS status_31, u1_.device_os AS device_os_32, u1_.device_token AS device_token_33, u1_.device_name AS device_name_34, u1_.device_active AS device_active_35, u1_.device_update AS device_update_36, u1_.newsletter AS newsletter_37, u1_.newsletter_date AS newsletter_date_38, u1_.first_login AS first_login_39, u1_.home_survey AS home_survey_40, u1_.display_teamplay_tuto AS display_teamplay_tuto_41, u1_.live AS live_42, u1_.tv AS tv_43, c2_.id AS id_44, c2_.name AS name_45, c2_.image AS image_46, c2_.updated_at AS updated_at_47, c2_.presentation AS presentation_48, c2_.presentation_title AS presentation_title_49, c2_.siret AS siret_50, c2_.phone AS phone_51, c2_.created_at AS created_at_52, c2_.company_code AS company_code_53, c2_.visio_allowed AS visio_allowed_54, c2_.visio_payment_allowed AS visio_payment_allowed_55, c2_.force_segmentation AS force_segmentation_56, c2_.siren AS siren_57, c2_.status AS status_58, c2_.active AS active_59, c2_.subscription_start AS subscription_start_60, c2_.subscription_end AS subscription_end_61, c2_.clients_count AS clients_count_62, c2_.messages AS messages_63, c2_.max_clients AS max_clients_64, c2_.plan AS plan_65, c2_.slug AS slug_66, c2_.ips AS ips_67, c2_.domain AS domain_68, c2_.hourly_restriction AS hourly_restriction_69, c2_.customizable AS customizable_70, c2_.cms AS cms_71, c2_.cms_title AS cms_title_72, c2_.cms_text AS cms_text_73, c2_.cms_cta_text AS cms_cta_text_74, c2_.cms_cta_url AS cms_cta_url_75, c2_.resa_link_active AS resa_link_active_76, c2_.email AS email_77, c2_.live AS live_78, c2_.tv AS tv_79, c2_.consult_link AS consult_link_80, c2_.street AS street_81, c2_.zip_code AS zip_code_82, c2_.town AS town_83, c2_.longitude AS longitude_84, c2_.latitude AS latitude_85, c2_.country AS country_86, c2_.code AS code_87, m3_.id AS id_88, m3_.file_path AS file_path_89, m3_.mime_type AS mime_type_90, m3_.size AS size_91, m3_.extra AS extra_92, m3_.created_at AS created_at_93, m3_.name AS name_94, s4_.id AS id_95, s4_.name AS name_96, s4_.alone AS alone_97, s4_.active AS active_98, s4_.ranked AS ranked_99, s4_.`rank` AS rank_100, s4_.created_at AS created_at_101, s4_.updated_at AS updated_at_102, c5_.id AS id_103, c5_.name AS name_104, c5_.image AS image_105, c5_.updated_at AS updated_at_106, c5_.presentation AS presentation_107, c5_.presentation_title AS presentation_title_108, c5_.siret AS siret_109, c5_.phone AS phone_110, c5_.created_at AS created_at_111, c5_.company_code AS company_code_112, c5_.visio_allowed AS visio_allowed_113, c5_.visio_payment_allowed AS visio_payment_allowed_114, c5_.force_segmentation AS force_segmentation_115, c5_.siren AS siren_116, c5_.status AS status_117, c5_.active AS active_118, c5_.subscription_start AS subscription_start_119, c5_.subscription_end AS subscription_end_120, c5_.clients_count AS clients_count_121, c5_.messages AS messages_122, c5_.max_clients AS max_clients_123, c5_.plan AS plan_124, c5_.slug AS slug_125, c5_.ips AS ips_126, c5_.domain AS domain_127, c5_.hourly_restriction AS hourly_restriction_128, c5_.customizable AS customizable_129, c5_.cms AS cms_130, c5_.cms_title AS cms_title_131, c5_.cms_text AS cms_text_132, c5_.cms_cta_text AS cms_cta_text_133, c5_.cms_cta_url AS cms_cta_url_134, c5_.resa_link_active AS resa_link_active_135, c5_.email AS email_136, c5_.live AS live_137, c5_.tv AS tv_138, c5_.consult_link AS consult_link_139, c5_.street AS street_140, c5_.zip_code AS zip_code_141, c5_.town AS town_142, c5_.longitude AS longitude_143, c5_.latitude AS latitude_144, c5_.country AS country_145, c5_.code AS code_146, m6_.id AS id_147, m6_.file_path AS file_path_148, m6_.mime_type AS mime_type_149, m6_.size AS size_150, m6_.extra AS extra_151, m6_.created_at AS created_at_152, m6_.name AS name_153, a7_.id AS id_154, a7_.name AS name_155, a7_.short_description AS short_description_156, a7_.content AS content_157, a7_.link_url AS link_url_158, a7_.active AS active_159, a7_.created_at AS created_at_160, a7_.updated_at AS updated_at_161, m8_.id AS id_162, m8_.file_path AS file_path_163, m8_.mime_type AS mime_type_164, m8_.size AS size_165, m8_.extra AS extra_166, m8_.created_at AS created_at_167, m8_.name AS name_168, c0_.dtype AS dtype_169, c0_.user_id AS user_id_170, c0_.company_id AS company_id_171, c0_.segmentation_id AS segmentation_id_172, c0_.association_id AS association_id_173, c0_.avatar_id AS avatar_id_174, u1_.segmentation_id AS segmentation_id_175, c2_.dtype AS dtype_176, c2_.user_id AS user_id_177, c2_.logo_id AS logo_id_178, c2_.cms_img_id AS cms_img_id_179, s4_.company_id AS company_id_180, s4_.parent_id AS parent_id_181, c5_.dtype AS dtype_182, c5_.user_id AS user_id_183, c5_.logo_id AS logo_id_184, c5_.cms_img_id AS cms_img_id_185, a7_.preview_id AS preview_id_186, a7_.picture_id AS picture_id_187, a7_.illustration_id AS illustration_id_188 FROM client c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN company c2_ ON c0_.company_id = c2_.id AND c2_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m3_ ON c2_.logo_id = m3_.id LEFT JOIN segmentation s4_ ON c0_.segmentation_id = s4_.id LEFT JOIN company c5_ ON s4_.company_id = c5_.id AND c5_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m6_ ON c5_.logo_id = m6_.id LEFT JOIN association a7_ ON c0_.association_id = a7_.id LEFT JOIN media_object m8_ ON c0_.avatar_id = m8_.id WHERE (c0_.id = 18131) AND c0_.dtype IN ('client', 'externalclient');

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

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 = 'rulteamapp_db' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

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