Symfony Profiler

SELECT
  t0.identifier AS identifier_1,
  t0.expiry AS expiry_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.revoked AS revoked_5,
  t0.client AS client_6
FROM
  oauth2_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = '41377e72f9722818434791207703b47c32f8a5f13eb13224e0e53b598770c70f0c089b640e6726f2';

SELECT
  t0.name AS name_1,
  t0.secret AS secret_2,
  t0.redirect_uris AS redirect_uris_3,
  t0.grants AS grants_4,
  t0.scopes AS scopes_5,
  t0.active AS active_6,
  t0.allow_plain_text_pkce AS allow_plain_text_pkce_7,
  t0.identifier AS identifier_8,
  t0.activation_url AS activation_url_9,
  t0.confirm_email_url AS confirm_email_url_10,
  t0.reset_password_url AS reset_password_url_11,
  t0.google_client_id AS google_client_id_12,
  t0.application_client_id AS application_client_id_13
FROM
  oauth_client t0
WHERE
  t0.identifier = ?

SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8, t0.activation_url AS activation_url_9, t0.confirm_email_url AS confirm_email_url_10, t0.reset_password_url AS reset_password_url_11, t0.google_client_id AS google_client_id_12, t0.application_client_id AS application_client_id_13 FROM oauth_client t0 WHERE t0.identifier = '65c6366c620f9';

SELECT
  t0.title AS title_1,
  t0.subtitle AS subtitle_2,
  t0.course_nature AS course_nature_3,
  t0.description AS description_4,
  t0.searchwords AS searchwords_5,
  t0.price AS price_6,
  t0.rabatt AS rabatt_7,
  t0.tax_rate AS tax_rate_8,
  t0.number AS number_9,
  t0.material_cost AS material_cost_10,
  t0.target_age_min AS target_age_min_11,
  t0.target_age_max AS target_age_max_12,
  t0.invoice_upper_comment AS invoice_upper_comment_13,
  t0.invoice_lower_comment AS invoice_lower_comment_14,
  t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_15,
  t0.id AS id_16,
  t0.created AS created_17,
  t0.modified AS modified_18,
  t0.client_id AS client_id_19,
  t0.subscription_id AS subscription_id_20,
  t0.category_id AS category_id_21,
  t0.series_id AS series_id_22,
  t0.type_id AS type_id_23
FROM
  course t0
WHERE
  t0.id = ?
  AND t0.client_id = ?
LIMIT
  1

SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.course_nature AS course_nature_3, t0.description AS description_4, t0.searchwords AS searchwords_5, t0.price AS price_6, t0.rabatt AS rabatt_7, t0.tax_rate AS tax_rate_8, t0.number AS number_9, t0.material_cost AS material_cost_10, t0.target_age_min AS target_age_min_11, t0.target_age_max AS target_age_max_12, t0.invoice_upper_comment AS invoice_upper_comment_13, t0.invoice_lower_comment AS invoice_lower_comment_14, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_15, t0.id AS id_16, t0.created AS created_17, t0.modified AS modified_18, t0.client_id AS client_id_19, t0.subscription_id AS subscription_id_20, t0.category_id AS category_id_21, t0.series_id AS series_id_22, t0.type_id AS type_id_23 FROM course t0 WHERE t0.id = 17 AND t0.client_id = 1 LIMIT 1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  COLUMN_NAME AS Field,
  COLUMN_TYPE AS TYPE,
  IS_NULLABLE AS `Null`,
  COLUMN_KEY AS `Key`,
  COLUMN_DEFAULT AS `Default`,
  EXTRA AS Extra,
  COLUMN_COMMENT AS COMMENT,
  CHARACTER_SET_NAME AS CharacterSet,
  COLLATION_NAME AS COLLATION
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = 'plattform-handwerk_back'
  AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS TYPE, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS COMMENT, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'plattform-handwerk_back' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  DISTINCT k.`CONSTRAINT_NAME`,
  k.`COLUMN_NAME`,
  k.`REFERENCED_TABLE_NAME`,
  k.`REFERENCED_COLUMN_NAME`
  /*!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 = 'doctrine_migration_versions' */
WHERE
  k.table_name = 'doctrine_migration_versions'
  AND k.table_schema = 'plattform-handwerk_back'
  /*!50116 AND c.constraint_schema = 'plattform-handwerk_back' */
  AND k.`REFERENCED_COLUMN_NAME` IS NOT NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!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 = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'plattform-handwerk_back' /*!50116 AND c.constraint_schema = 'plattform-handwerk_back' */ AND k.`REFERENCED_COLUMN_NAME` IS NOT NULL;

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_NAME = 'doctrine_migration_versions'
  AND TABLE_SCHEMA = 'plattform-handwerk_back'
ORDER BY
  SEQ_IN_INDEX ASC

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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'plattform-handwerk_back' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  ENGINE,
  AUTO_INCREMENT,
  TABLE_COLLATION,
  TABLE_COMMENT,
  CREATE_OPTIONS
FROM
  information_schema.TABLES
WHERE
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;